File "work_list_csv.php"

Full path: /www/haneda/qr/work_list_csv.php
File size: 4.12 KiB (4217 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php

function _DataChange($row_data)
{
	$change_data = "";
	
	switch($row_data)
	{
		case 0:
			$change_data = "";
			break;
		case 1:
			$change_data = "未返却";
			break;
		case 2:
			$change_data = "返却済";
			break;
	}
	
	return $change_data;
}





//===============================================
//	CommonUtilities
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================

$PENTA_OCEAN = "五洋・清水特定建設工事企業体";
$TAIL_PENTA_OCEAN = "penta-ocean";
$SCRIPT_TITLE = "作業一覧";

$TOP_FORM = "./index.php";
$VIEW_FORM = "./work_list_details.php";
$HOST = "192.168.100.153";
$DB = "pntdb";
$USER = "postgres";
$PASS = "am#71ZJ*";
$WORK_TABLE = "qr.work_data";
$REGIST_TABLE = "qr.regist_data";
$PAGE_LIMIT = 30;

//print "AAAA";
//================================================
//	データベース接続
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");
if (!$conn)
{
	throw new Exception("データベースへの接続に失敗しました");
}

//===============================================
//	POST、GETパラメータの受け取り
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
if(extract($_POST))
{
	$POST_date = isset($_POST['Date']) ? htmlspecialchars($_POST['Date']) : "";
	$POST_time_zone = isset($_POST['TimeZone']) ? htmlspecialchars($_POST['TimeZone']) : "";
	$POST_h_flag =  isset($_POST['HFlag']) ? htmlspecialchars($_POST['HFlag']) : "";
	
	$DataDate = $POST_date;
	$DataTimeZone = $POST_time_zone;
	$DataHFlag = $POST_h_flag;
}

//print_r($_POST);

if($DataTimeZone == 99)
{
	$select_r = "SELECT * FROM " .$REGIST_TABLE ." WHERE date =  '" .$DataDate ."' AND del_flag = false ORDER BY regdatetime;";
	$file_p = "_all";
}
else
{
	$select_r = "SELECT * FROM " .$REGIST_TABLE ." WHERE date =  '" .$DataDate ."' AND time_zone = '" .$DataTimeZone ."' AND del_flag = false ORDER BY regdatetime;";
	$file_p = (!$DataTimeZone) ? "_hiru" : "_yoru";

}

//print $select_r ."<BR>";


$res_r = pg_query($conn,$select_r);
$data_ct = pg_num_rows($res_r);


$output = "会社名,名称,識別表返却状況,IDカード(ユーザ),IDカード(ユーザ)返却状況,車種,車番,車識別表返却状況,IDカード(車),IDカード(車)返却状況,旗,旗返却状況,マーク,マーク返却状況,マニュアル,マニュアル返却状況,火気番号,火気返却状況,管理場所";
$output .= "\r\n";


for($i = 0;$i < $data_ct;$i++)
{
	$row = pg_fetch_array($res_r,$i);
	$check = 0;


	if($DataHFlag == 99)
	{
		$check = 1;
	}
	else if($DataHFlag == 2)
	{
		if(($row[5] != 1) && ($row[7] != 1) && ($row[10] != 1) && ($row[12] != 1) && ($row[14] != 1) && ($row[16] != 1) && ($row[18] != 1) && ($row[21] != 1))
		{
			$check = 1;
		}
	}
	else
	{
		if(($row[5] != 2) && ($row[7] != 2) && ($row[10] != 2) && ($row[12] != 2) && ($row[14] != 2) && ($row[16] != 2) && ($row[18] != 2) && ($row[21] != 2))
		{
			$check = 1;
		}
	}
	
	if($check == 1)
	{
		$output .=$row[3] .",";
		$output .=$row[4] .",";
		$output .=_DataChange($row[5]) .",";
		$output .=$row[6] .",";
		$output .=_DataChange($row[7]) .",";
		$output .=$row[8] .",";
		$output .=$row[9] .",";
		$output .=_DataChange($row[10]) .",";
		$output .=$row[11] .",";
		$output .=_DataChange($row[12]) .",";
		$output .=$row[13] .",";
		$output .=_DataChange($row[14]) .",";
		$output .=$row[15] .",";
		$output .=_DataChange($row[16]) .",";
		$output .=$row[17] .",";
		$output .=_DataChange($row[18]) .",";
		$output .=$row[19] .",";
		$output .=_DataChange($row[20]).",";;
		$output .=$row[21];
		$output .= "\r\n";
	}
}


$length = mb_strlen($output);

header("Content-Type: application/octet-stream");
header("Content-Disposition: inline; filename=\"". mb_convert_encoding("Data_" .substr($DataDate,"0","4") .substr($DataDate,"5","2") .substr($DataDate,"8","2") .$file_p .".csv", "Shift-JIS", "UTF-8"). "\"");
header("Content-Length: ". $length. "");
header("Pragma:no-cache");
header("Cache-Control:nocache");

print $output;
?>