geyeOLD

File "data_view_OLD20200304.php"

Full path: /www/geye/OLD/data_view_OLD20200304.php
File size: 7.21 KiB (7378 bytes)
MIME-type: text/html
Charset: utf-8

Download   Open   Back 

<HTML>
<HEAD>
<META Http-Equiv="Content-Type" Content="text/html;charset=UTF-8">
<TITLE>検査記録</TITLE>
<LINK REL="stylesheet" HREF="mstmnt.css" TYPE="text/css">
</HEAD>
<BODY>


<FONT>
<!--<A HREF="./conc_data_today2_view.php">非表示のデータ一覧</A>-->

<!--<FORM ACTION="<?php $_SERVER[PHP_SELF]; ?>" METHOD="POST">
<INPUT TYPE="button" onclick="location.href='menu.php'" value="メニューへ戻る" style="WIDTH: 120px; HEIGHT: 50px">
<INPUT TYPE="submit" NAME="prc"  VALUE="チェックを入れた項目が非表示になります" style="WIDTH: 300px; HEIGHT: 50px">
-->


<?php
/*
EXTRACT($_POST);
EXTRACT($_GET);
$userAgent = $_SERVER['HTTP_USER_AGENT'];
if(strpos($userAgent,'iPad') === false)
{
  print "<INPUT TYPE='button' NAME='prc' onclick=\"location.href='csv-out.php?company_id_=" .$_GET['company_id_']    ."'\" VALUE='CSV出力' style='WIDTH: 100px; HEIGHT: 50px'>";
}
print "<BR><BR>";
*/

//■初期値設定

//////////////////
//Function定義
/////////////////

//func：データをSQL用に変換
function cnv_sqlstr($string) {
  if (!strlen($string)) return "null";
    if (get_magic_quotes_gpc()) {
        $string = stripslashes($string);
    }
    $string = htmlspecialchars($string);
    $string = pg_escape_string($string);

    return "'".$string."'";
}

$enc_db = "UTF-8";
$enc_disp = "SJIS";




//●ファイルを保存するディレクトリ
$save_dir = "/var/www/html/awara_ukeire/pict/";

//----------------------------------------------------------------------
// 接続設定（サーバ／データベース／ユーザ／パスワード）

/*
$sv = "localhost";
$dbname = "pentaict";
$user = "postgres";
$pass = "postgres";
$conn = pg_connect("host=$sv dbname=$dbname user=$user password=$pass") or die("接続エラー");

if(!strcmp($prc,"チェックを入れた項目が非表示になります")){
	if (count($_POST) > 0) {
		EXTRACT($_POST);
	}
//	print "<BR>POST:";
//	print_r($_POST);
	$ct2 = count($de_f);
	
	for($i2 = 0;$i2 < $ct2;$i2++){
		$sql_de = "UPDATE awara_ukeire.data SET del_flag = true WHERE no = " .$de_f[$i2];
		$res_de = pg_query($conn,$sql_de);
	}
	
}



$sql_v = "SELECT * FROM awara_ukeire.data WHERE del_flag ='false' ORDER BY delivery_date DESC,delivery_time DESC;";
$res_v = pg_query($conn,$sql_v);
$ct_v = pg_num_rows($res_v);


	//配合名の取得(配合一覧表)
	$sel_c = "SELECT * FROM awara.material ORDER BY  material_id";
	$res_c = pg_query($conn,$sel_c);
	$ct_c = pg_num_rows($res_c);
	//$combi_name_ = explode(" " ,$row_cm['combi_name'];
	//$combi_name = str_replace(' ', '<BR>', $row_cm['combi_name']);
*/
print "<TABLE BORDER=\"1\">";
print "<TR BGCOLOR='blue'>";
//print "<TH><FONT SIZE ='2' COLOR='white'>ﾁｪｯｸ</FONT></TH>";
print "<TH WIDTH='130'><FONT SIZE ='2' COLOR='white'>希望日</FONT></TH>";
print "<TH WIDTH='100'><FONT SIZE ='2' COLOR='white'>場所</FONT></TH>";
print "<TH WIDTH='100'><FONT SIZE ='2' COLOR='white'>工種</FONT></TH>";
print "<TH WIDTH='120'><FONT SIZE ='2' COLOR='white'>検査項目</FONT></TH>";
print "<TH WIDTH='100'><FONT SIZE ='2' COLOR='white'>管理技術者</FONT></TH>";
print "<TH WIDTH='100'><FONT SIZE ='2' COLOR='white'>確認者</FONT></TH>";
print "<TH WIDTH='120'><FONT SIZE ='2' COLOR='white'>実施日</FONT></TH>";
print "<TH WIDTH='50'><FONT SIZE ='2' COLOR='white'>調書</FONT></TH>";
print "<TH WIDTH='50'><FONT SIZE ='2' COLOR='white'>写真</FONT></TH>";
print "<TH WIDTH='50'><FONT SIZE ='2' COLOR='white'>記事</FONT></TH>";
print "</TR>";
print "<TR ALIGN='center'>";
//print "<TD><INPUT TYPE='checkbox' NAME='de_f[]' VALUE='$row[no]' ></TD>";

$test = date("Y/m/d H:i",time());

print "<TD><FONT SIZE ='2'>" .$test ."</FONT></TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "<TD>&nbsp;</TD>";
print "</TR>";

for($i = 0 ;$i < $ct_v;$i++)
{
	$row = pg_fetch_array($res_v,$i);
	$ii = $i + 1;
	
	$test_datetime = ($row['test_datetime']) ? date("H:i" ,strtotime($row['test_datetime'])) : "";
	$delivery_time = ($row['delivery_time']) ? date("H:i" ,strtotime($row['delivery_time'])) : "";
	$arrival_time =  ($row['arrival_time']) ? date("H:i" ,strtotime($row['arrival_time'])) : "";
	$placing_end_time =  ($row['placing_end_time']) ? date("H:i" ,strtotime($row['placing_end_time'])) : "";

	//配合名の取得
	$sel_cm = "SELECT * FROM awara.material WHERE material_id =" .$row['combination'];
	$res_cm = pg_query($conn,$sel_cm);
	$row_cm = pg_fetch_array($res_cm,0);
	//$combi_name_ = explode(" " ,$row_cm['combi_name'];
	//$combi_name = str_replace(' ', '<BR>', $row_cm['combi_name']);
	$combi_name = (strlen($row_cm['combi_name']) > 16) ? substr($row_cm['combi_name'],-11) : $row_cm['combi_name'];

	//車番の取得
	//マスターから車番を取得
	$sel_cn = "SELECT * FROM awara.car WHERE car_id = " .$row['car_no'];
	$res_cn = pg_query($conn,$sel_cn);
	$row_cn = pg_fetch_array($res_cn,0);

	print "<TR ALIGN='center'>";
	print "<TD><INPUT TYPE='checkbox' NAME='de_f[]' VALUE='$row[no]' ></TD>";
	print "<TD ><FONT SIZE ='4'><A HREF='conc_data_regist.php?reg_no_=" .$row[no] ."&combi_=" .$row[combination] ."&company_id_=" .$_GET['company_id_']  ."'>" .$row[no] ."</A></FONT></TD>";
//	print "<TD>" .$row['name_1'] ."</TD>";
	print "<TD><FONT SIZE ='2'>" .$combi_name ."</FONT></TD>";
	print "<TD>" .$row['block_no'] ."</TD>";
	print "<TD>" .$row_cn['car_number'] ."</TD>";
	print "<TD>" .$row['delivery_date'] ."</TD>";
	print "<TD>" .$delivery_time ."</TD>";
	print "<TD>" .$arrival_time ."</TD>";
	print "<TD>" .$placing_end_time ."</TD>";
	print "<TD>" .$test_datetime ."</TD>";
	print "<TD>" .$row['slump'] ."</TD>";
	print "<TD>" .$row['air'] ."</TD>";
	print "<TD>" .$row['unit_water_content'] ."</TD>";
	print "<TD>" .$row['ambient_temperature'] ."</TD>";
	print "<TD>" .$row['concrete_temperature'] ."</TD>";
	print "<TD>" .$row['chloride_content'] ."</TD>";



  if($row['w1_st_date'] && $row['w1_st_time'] && $row['w1_st_observer'] && $row['w1_st_1'] && $row['w1_st_2'] && $row['w1_st_3'] && $row['w1_st_avg'])
  {
  	 print "<TD>●</TD>";
  }
  else
  {
  	 print "<TD>×</TD>";
  }


  if($row['w4_st_date'] && $row['w4_st_time'] && $row['w4_st_observer'] && $row['w4_st_1'] && $row['w4_st_2'] && $row['w4_st_3'] && $row['w4_st_avg'])
  {
  	 print "<TD>●</TD>";
  }
  else
  {
  	 print "<TD>×</TD>";
  }

  //写真の確認
  if((file_exists($save_dir .$row['no']  ."_1.png")) || (file_exists($save_dir .$row['no']  ."_2.png")) || (file_exists($save_dir .$row['no']  ."_3.png")) || (file_exists($save_dir .$row['no']  ."_4.png")) || (file_exists($save_dir .$row['no']  ."_5.png")))
  {
	print "<TD ><FONT SIZE ='6'><A HREF='conc_pict_view.php?reg_no_=" .$row[no] ."'>■</A></FONT></TD>";
  }
  else
  {
	print "<TD ><FONT SIZE ='2'>×</FONT></TD>";
  }


	print "</TR>";

}

print "</TABLE>";

?>

<!--
<BR>
<INPUT type="button" onclick="location.href='menu.php'" value="メニューへ戻る" style="WIDTH: 120px; HEIGHT: 50px">
<INPUT TYPE="submit" NAME="prc"  VALUE="チェックを入れた項目が非表示になります" style="WIDTH: 300px; HEIGHT: 50px">
</FORM>
</FONT>
<HR>
<FONT SIZE=4 COLOR="#000000" FACE="Arial">
<CENTER><B><I>penta-ocean</I></B></CENTER>
</FONT>
-->
	
</BODY>
</HTML>

PHP File Manager