hanedaqr

File "work_list_details.php"

Full path: /www/haneda/qr/work_list_details.php
File size: 7.11 KiB (7276 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?php

function restitution_check($row_name,$row_flag,$n_flag)
{
	if($n_flag)
	{
		if($row_flag == 1)
		{
			$color = "bgcolor = '#FFA500'";
		}
		else if($row_flag == 2)
		{
			$color = "bgcolor = '#ADFF2F'";
		}
		else
		{
			$color = "bgcolor = '#FFFFFF'";
		}
		

	}
	else
	{
		if($row_flag == 1)
		{
			$color = "bgcolor = '#FF0000'";
		}
		else if($row_flag == 2)
		{
			$color = "bgcolor = '#ADFF2F'";
		}
		else
		{
			$color = "bgcolor = '#FFFFFF'";
		}
	}
	
	return "<td " .$color .">" .$row_name ."</td>";
}
//===============================================
//	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;

//===============================================
//	HTML-HEAD-
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//===============================================
print "<html>";
print "<head>";
print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "<title>". $SCRIPT_TITLE. "</title>";
print "</head>";

//===============================================
//	HTML-BODY部開始-
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//===============================================
print "<body>";
//print "<center>";
//print "<font size=\"3\">";
//print "<b>";
//print "". $SCRIPT_TITLE. "<br>";
//print "【". $PENTA_OCEAN. "】";
//print "</b>";
//print "</font>";
//print "</center>";
//print "<hr />";


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


if(extract($_GET))
{
	$DataDate = isset($_GET['d']) ? htmlspecialchars($_GET['d']) : "";
	$DataTimeZone = isset($_GET['t']) ? htmlspecialchars($_GET['t']) : "";
	$BackUrl = "./work_list.php";
	$data_flag = 1;
}


//===============================================
//	WHERE句の作成
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
//最新の作業時間を抽出
$select_wn = "SELECT * FROM " .$WORK_TABLE ." ORDER BY date desc limit 1;";
$res_wn = pg_query($conn,$select_wn) or die(pg_last_eror() ."<BR>" .$select_wn ."<BR>");
$row_wn = pg_fetch_array($res_wn,0);
$new_date = date("Y-m-d",strtotime($row_wn['date']));
$new_date_zone = $row_wn['time_zone'];

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

if($data_flag == 0)
{
	$select_w = $select_wn;
	$DataDate = $new_date;
	$DataTimeZone = $new_date_zone;
	$BackUrl = "./index.php";
}	
else
{
	$select_w = "SELECT * FROM " .$WORK_TABLE ." WHERE date = '" .$DataDate ." 00:00:00" ."' AND time_zone = '" .$DataTimeZone ."';";
}

$res_w = pg_query($conn,$select_w);
$row_w = pg_fetch_array($res_w,0);

$select_date = date("Y-m-d",strtotime($row_w['date']));
$date_zone_s = (!$row_w['time_zone']) ? "昼間" : "夜間";
$work_status = (!$row_w['work_flag']) ? "作業中" : "作業終了";
$new_flag = ((!strcmp($new_date,$select_date)) && (!strcmp($new_date_zone,$row_w['time_zone']))) ? 1 :0;


$select_r = "SELECT * FROM " .$REGIST_TABLE ." WHERE date =  '" .$DataDate ." 00:00:00' AND time_zone = '" .$DataTimeZone ."' AND del_flag = false ORDER BY regdatetime;";
$res_r = pg_query($conn,$select_r);
$data_ct = pg_num_rows($res_r);


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

//===============================================
//	見出し
//	備考		：	Table内TableでBorderを細くする
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================

//print $row_w['date'] ."<BR>";

//print "<table border='1' align='right'><tr><td>" .$date_zone_s .$work_status ."</td></tr></table><BR>";
print 	substr($row_w['date'],0,4) ."年" .substr($row_w['date'],5,2) ."月" .substr($row_w['date'],8,2) ."日 管理表";
print "<BR><a href='" .$BackUrl ."'>戻る</a><BR>";
print "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr>";
print "<td align='center' colspan='4'>";
print "入場者";
print "</td>";
print "<td align='center' colspan='7'>";
print "車両";
print "</td>";
print "<td align='center'>";
print "火気";
print "</td>";
print "</tr>";
print "<tr align='center'>";
print "<td>会社名</td>";
print "<td>氏名</td>";
print "<td>ID</td>";
print "<td>識別票</td>";
print "<td>車種</td>";
print "<td>車番</td>";
print "<td>ID</td>";
print "<td>識別票</td>";
print "<td>旗</td>";
print "<td>マーク</td>";
print "<td>マニュアル</td>";
print "<td>番号</td>";
print "</tr>";


//print $new_flag ."<BR>";
//print $row_w['work_flag'] ."<BR>";
for($i = 0;$i < $data_ct;$i++)
{
	$row_r = pg_fetch_array($res_r,$i);
	
	$user_shikibetsu = ($row_r['company_name'] && $row_r['user_name'])? "◯" : "";
	$car_shikibetsu = ($row_r['car_type'] && $row_r['car_number'])? "◯" : "";

	
	print "<tr align='center'>";
	print restitution_check($row_r['company_name'],$row_r['user_dentification_flag'],$new_flag);
	print restitution_check($row_r['user_name'],$row_r['user_dentification_flag'],$new_flag);
	print restitution_check($row_r['user_id'],$row_r['user_id_flag'],$new_flag);
	print restitution_check($user_shikibetsu,$row_r['user_dentification_flag'],$new_flag);
	print restitution_check($row_r['car_type'],$row_r['car_dentification_flag'],$new_flag);
	print restitution_check($row_r['car_number'],$row_r['car_dentification_flag'],$new_flag);
	print restitution_check($row_r['car_id'],$row_r['car_id_flag'],$new_flag);
	print restitution_check($car_shikibetsu,$row_r['car_dentification_flag'],$new_flag);
	print restitution_check($row_r['flag_number'],$row_r['flag_number_flag'],$new_flag);
	print restitution_check($row_r['mark_number'],$row_r['mark_number_flag'],$new_flag);
	print restitution_check($row_r['manual_number'],$row_r['manual_number_flag'],$new_flag);
	print restitution_check($row_r['fire_number'],$row_r['fire_flag'],$new_flag);
	print "</tr>";
}
	print "</table>";
	print "<br />";

//===============================================
//	Postgresql終了処理
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
pg_close($conn);
print "<a href='" .$BackUrl ."'>戻る</a>";
//===============================================
//	HTML終了処理
//	備考		：	
//	更新		：	2012/11/01 KMK-Teraoka
//===============================================
print "<hr />";
print "<font size=\"3\" color=\"#000000\" face=\"Arial\">";
print "<center>";
print "<b>";
print "<i>";
print $TAIL_PENTA_OCEAN;
print "</i>";
print "</b>";
print "</center>";
print "</font>";
print "</body>";
print "</html>";
?>

PHP File Manager