co2

File "terminal_regist_20220915.php"

Full path: /www/co2/terminal_regist_20220915.php
File size: 8.94 KiB (9158 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>端末の登録・編集</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>
    <!-- Main Contents -->
      <div class="container-fluid">

        <!-- return -->
        <!--
        <div class="row mt-2 mb-2">
          <div class="col-6"></div>
          <div class="col-6">
            <a class="btn btn-light float-right" href="menu.php" role="button">メニューへ戻る</a>
          </div>
        </div>
		-->
        <!-- page header -->
        <div class="row mb-2">
          <div class="col-12">
            <div class="title p-2 border rounded text-center"><FONT SIZE='6'>端末の登録・編集</FONT></div>
          </div>
        </div>

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

//■掘削の計算範囲(0:全て 1:指定範囲)
$range_set = 0;


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

//ichimillデータDB(後に本番用設定
$DATA_TABLE[2] = "gps.rtk_data";


$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;

	$st_date = date("Y-m-d",$now);
	$end_date = date("Y-m-d",$now+2592000);
}
else
{
	$date_ = $_POST['date_'];
//	print "登録";
//	$st_date = $_POST['date_a'];
//	$end_date = $_POST['date_b'];
}



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



//端末の編集
if($_POST['data_edit'])
{
	$sql_up = "UPDATE " .$DATA_TABLE[1] ." SET ";
	$sql_up .= "terminal_name='" .$_POST['terminal_name'] ."',";
	$sql_up .= "start_time='" .$_POST['date_aa'] ."',";
	$sql_up .= "end_time='" .$_POST['date_bb'] ."',";
	$sql_up .= "upddatetime='" .date("Y-m-d H:i:s",time()) ."'";
	$sql_up .= " WHERE id=" .$_POST['id_'];
	$res_up = pg_query($conn, $sql_up) or die("SQL ERROR!!<br />". $sql_up.pg_last_error());

}
else if($_POST['data_del'])
{
	$sql_up = "UPDATE " .$DATA_TABLE[1] ." SET ";
	$sql_up .= "delflag='true',";
	$sql_up .= "upddatetime='" .date("Y-m-d H:i:s",time()) ."'";
	$sql_up .= " WHERE id=" .$_POST['id_'];
	$res_up = pg_query($conn, $sql_up) or die("SQL ERROR!!<br />". $sql_up.pg_last_error());
}




//工事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 ." AND delflag='false'";
$res_terminal = pg_query($conn, $sql_terminal);
$ct_terminal = pg_num_rows($res_terminal);


//print_r($_POST);
print "<INPUT TYPE='button' onclick='window.close();' value='閉じる' style='width:50px;height:25px;font-size:10pt'>";
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 "</FORM>";

print "<form name='formName' enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<TABLE border='1'>";
print "<TR>";
print "<TD>現場名</TD>";
print "<TD>";
//print "<input type='text' name='const_name'></input>";
print $const_name;
print "</TD>";
print "</TR>";
print "<TR>";
print "<TD>端末番号</TD>";
print "<TD>";
print "<input type='text' name='terminal_id'></input>";
print "</TD>";
print "</TR>";
print "<TR>";
print "<TD>機械名</TD>";
print "<TD>";
print "<input type='text' name='machine_name'></input>";
print "</TD>";
print "</TR>";
print "<TR>";
print "<TD>開始日時</TD>";
print "<TD>";
print "<input type='date' name='date_a' value='" .$st_date ."' style='width:150px;'></input>";
print "</TD>";
print "</TR>";
print "<TR>";
print "<TD>終了日時</TD>";
print "<TD>";
print "<input type='date' name='date_b' value='" .$end_date ."' style='width:150px;'></input>";
print "</TD>";
print "</TR>";
print "</TABLE>";
print "<INPUT TYPE='submit' NAME='data_input' VALUE='登録' style='width:100px;height:25px;font-size:10pt'>";
print "</FORM>";
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 "<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>";

for($i = 0;$i < $ct_terminal ;$i++)
{
	$row_terminal = pg_fetch_array($res_terminal,$i);

	print "<TR ALIGN='center'>";
	print "<form name='formName' enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
	print "<TD>" .$row_terminal['terminal_id'] ."</TD>";
	print "<TD><input type='text' name='terminal_name' value='" .$row_terminal['terminal_name'] ."'></input></TD>";
	print "<TD ALIGN='center'><input type='date' name='date_aa' value='" .date("Y-m-d" ,strtotime($row_terminal['start_time'])) ."' style='width:150px;'></input></TD>";
	print "<TD ALIGN='center'><input type='date' name='date_bb' value='" .date("Y-m-d" ,strtotime($row_terminal['end_time'])) ."' style='width:150px;'></input></TD>";
	print "<TD ALIGN='center'>";
	print "<INPUT TYPE='submit' NAME='data_edit' VALUE='更新' style='width:50px;height:25px;font-size:10pt'>";
	print "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
	print "<INPUT TYPE='submit' NAME='data_del' VALUE='削除' style='width:50px;height:25px;font-size:10pt'>";
	print "</TD>";
	print "<INPUT TYPE='hidden' name='id_' value='" .$row_terminal['id'] ."'></INPUT>";
	print "</FORM>";
//	print "<TD ALIGN='center'>" .$row_terminal['end_time'] ."</TD>";


//print "<input type='date' name='date_a' value='" .$st_date ."' style='width:150px;'></input>";
//	print "<TD ALIGN='center'>" .$row_terminal['start_time'] ."</TD>";
//	print "<TD ALIGN='center'>" .$row_terminal['end_time'] ."</TD>";
	print "</TR>";

}
	print "</TABLE>";

/*
//選択した日付の稼働時間を表示
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>";

*/
?>

    <input type="hidden" name="PYUSER" value="<?php echo $pyuser ?>" />
  </body>

</html>

PHP File Manager