co2

File "terminal_regist.php"

Full path: /www/co2/terminal_regist.php
File size: 8.2 KiB (8395 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>";


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


//日付の設定
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'];
	$now_date = date("Y-m-d" ,time());
	
	$sql_ins ="INSERT INTO " .$DATA_TABLE[1];
	$sql_ins .= " (const_id, terminal_id, terminal_name, start_time, end_time,upddatetime, regdatetime,delflag) ";
	$sql_ins .= " VALUES (";
	$sql_ins .= $id .",";
	$sql_ins .= "'" .$_POST['terminal_id'] ."',";
	$sql_ins .= "'" .$_POST['machine_name'] ."',";
	$sql_ins .= "'" .$st_date ."',";
	$sql_ins .= "'" .$end_date ."',";
	$sql_ins .= "'" .$now_date ."',";
	$sql_ins .= "'" .$now_date ."',";
	$sql_ins .= "'false'";
	$sql_ins .= ");";
	$res_ins = pg_query($conn, $sql_ins) or die("SQL ERROR!!<br />". $sql_ins.pg_last_error());
}



//端末の編集
if($_POST['data_edit'])
{
	$sql_up = "UPDATE " .$DATA_TABLE[1] ." SET ";
	$sql_up .= "terminal_id='" .$_POST['terminal_id'] ."',";
	$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 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' ORDER BY id";
$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 "<INPUT TYPE='hidden' name='id' value='" .$id ."'></INPUT>";
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 "<INPUT TYPE='hidden' name='id' value='" .$id ."'></INPUT>";
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><input type='text' name='terminal_id' value='" .$row_terminal['terminal_id'] ."'></input></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='" .$id ."'></INPUT>";
	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>";
?>

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

</html>

PHP File Manager