co2csv_output

File "data_view_20220914.php"

Full path: /www/co2/csv_output/data_view_20220914.php
File size: 4.94 KiB (5061 bytes)
MIME-type: text/html
Charset: utf-8

Download   Open   Back 

<!DOCTYPE html>
<html lang="ja">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta http-equiv="Pragma" content="no-cache">
    <meta http-equiv="Cache-Control" content="no-cache">
    <title>CO2調査</title>
    <!-- css -->
    <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" rel="stylesheet" crossorigin="anonymous">
    <link href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css" rel="stylesheet" crossorigin="anonymous">
    <link href="https://use.fontawesome.com/releases/v5.0.6/css/all.css" rel="stylesheet">
    <!-- page org style -->
  </head>

  <body>

    <!-- page contents -->
<?php

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2013/03/12 KMK-Yokosuka
//================================================
$DATA_TABLE[0] = "gps.constructions";
$DATA_TABLE[1] = "gps.terminals";

//テスト用DB(後に本番用設定
$DATA_TABLE[2] = "gps.rtk_data5";
$DATA_TABLE[3] = "gps.rtk_data6";


$HOST = "localhost";
$DB = "ichimill";
$USER = "postgres";
$PASS = "postgres";

$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");


EXTRACT($_GET);
EXTRACT($_POST);

//print_r($_POST);
//print "<BR>";


//日付の設定
if(!$_POST['data_input'])
{
	$now = time();
	$date_ = date("Y-m-d",$now);
//	$date_a = date("Y-m-d",$now);
//	$date_b = date("H:i:s",$now);
//	$date_ = $date_a ."T" .$date_b;
}
else
{
	$date_ = $_POST['date_'];
}



//工事ID取得
if($_GET['id'])
{
	$id = $_GET['id'];
}
else if($_POST['id'])
{
	$id = $_POST['id'];
}
else
{
	$id = 1;
}


//工事IDから工事名を取得
$sql_const = "SELECT * FROM " .$DATA_TABLE[0] ." WHERE const_id = " .$id;
$res_const = pg_query($conn, $sql_const);
//$res_const = pg_query($conn, $sql_const) or die("SQL ERROR!!<br />". $sql_const.pg_last_error());
$row_const = pg_fetch_array($res_const,0);
$const_name = $row_const['const_name'];


//工事IDから使用端末情報を取得
$sql_terminal = "SELECT * FROM " .$DATA_TABLE[1] ." WHERE const_id = " .$id;
$res_terminal = pg_query($conn, $sql_terminal);
$ct_terminal = pg_num_rows($res_terminal);



//工事名を表示
print "<TABLE >";
print "<TR>";
print "<TD WIDTH='200' ALIGN='center'><B>" .$const_name ."</B></TD>";
print "</TR>";
print "</TABLE>";



//print "<BR><BR>";
//print "<form name='formName' enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
//print "<INPUT TYPE='submit' NAME='up' VALUE='更新' style='width:100px;height:25px;font-size:10pt'>";
//print "<INPUT TYPE='hidden' NAME='id' VALUE='".$id ."'>";
//print "</FORM>";

print "<BR><BR>";
print "<form name='formName' enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<TABLE border='2'>";
print "<TR>";
print "<TD>日時</TD>";
print "<TD>";
print "<input type='date' name='date_' value='" .$date_ ."' step='1' min='2012-02-16T00:40:00' style='width:150px;' class='txt3'></input>";
print "</TD>";
print "<TD>";
print "<INPUT TYPE='submit' NAME='data_input' VALUE='選択' style='width:100px;height:25px;font-size:10pt'>";
print "</TD>";
print "</TR>";
print "<INPUT TYPE='hidden' NAME='id' VALUE='".$id ."'>";
print "</FORM>";
print "</TABLE>";

print "<BR><BR>";

//選択した日付の稼働時間を表示
print "<TABLE border='2'>";
print "<TR ALIGN='center'>";
print "<TD WIDTH='200' style='border-bottom-width:2px;background:#00bfff'>端末番号</TD>";
print "<TD WIDTH='200' style='border-bottom-width:2px;background:#00bfff'>機械名</TD>";
print "<TD WIDTH='200' style='border-bottom-width:2px;background:#00bfff'>稼働時間</TD>";
print "</TR>";

//$ct_terminal =1;
for($i = 0;$i < $ct_terminal ;$i++)
{
	$row_terminal = pg_fetch_array($res_terminal,$i);
	$job = 0;
	if($row_terminal['start_time'] <= $date_)
	{
		$start_time = $date_;
		$end_time = date("Y-m-d" ,strtotime($date_) + 86400);
		
		if(!strcmp($row_terminal['terminal_id'],"lc1949"))
		{
			$sql_job = "SELECT max(gps_date) AS date_max,min(gps_date) AS date_min FROM gps.rtk_data5 WHERE gps_date >= '" .$start_time ."' AND gps_date < '" .$end_time ."'";
			
		}
		else if(!strcmp($row_terminal['terminal_id'],"lc2355"))
		{
			$sql_job = "SELECT max(gps_date) AS date_max,min(gps_date) AS date_min FROM gps.rtk_data6 WHERE gps_date >= '" .$start_time ."' AND gps_date < '" .$end_time ."'";
		}
		$res_job = pg_query($conn, $sql_job);
		$row_job = pg_fetch_array($res_job,0);
		
		
		//稼働時間の計算
		$job_calc = strtotime($row_job['date_max']) - strtotime($row_job['date_min']);
		if($job_calc != 0)
		{
			$job = number_format($job_calc /3600, 1, '.', '');
		}
	}
		
	print "<TR ALIGN='center'>";
	print "<TD>" .$row_terminal['terminal_id'] ."</TD>";
	print "<TD>" .$row_terminal['terminal_name'] ."</TD>";
	print "<TD ALIGN='center'>" .$job ."時間</TD>";
	print "</TR>";

}
	print "</TABLE>";






?>


  </body>

</html>

PHP File Manager