db_bkbkOLD

File "data_view_20200513.php"

Full path: /www/db_bk/bk/OLD/data_view_20200513.php
File size: 12.01 KiB (12300 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="pict.css" TYPE="text/css">
</HEAD>
<BODY>

<!--
<style type="text/css">
.button {
  display       : inline-block;
  border-radius : 5%;          /* 角丸       */
  font-size     : 10pt;        /* 文字サイズ */
  text-align    : center;      /* 文字位置   */
  cursor        : pointer;     /* カーソル   */
  padding       : 6px 6px;     /* 余白       */
  background    : #808080;     /* 背景色     */
  color         : #ffffff;     /* 文字色     */
  line-height   : 1em;         /* 1行の高さ  */
  width         : 100px;       /* 横幅　　　 */
}

</style>
-->

<script type="text/javascript">

/////関数(javascript)////////////////////////////////////////////////

//■チェック項目の削除
function goDeleteServlet()
{
	//チェックボタンは配列に入っている
	checks = document.getElementsByName("check");

	var data_no = null;

	for(var i = 0; i < checks.length; i++)
	{
		if(checks[i].checked)
		{
			if(data_no == null)
			{
				data_no = checks[i].value;
			}
			else
			{
				 data_no = data_no + ","  + checks[i].value ;
			}
		}
	}
	
	if(data_no != null)
	{
		if(window.confirm("No." +data_no + 'を削除してもよろしいですか？'))
		{
			location.href = "data_view.php?del=" + data_no ;
		} 
		else
		{
			location.href = "data_view.php";
		}
	}
	else
	{
		if(window.confirm('削除のチェックが選択されていません'))
		{}
		else
		{}
	}
}


//■ファイルダウンロード
function dlServlet()
{

	//チェックボタンは配列に入っている
	checks = document.getElementsByName("check");

	var data_no = null;

	for(var i = 0; i < checks.length; i++)
	{
		if(checks[i].checked)
		{
			if(data_no == null)
			{
				data_no = checks[i].value;
			}
			else
			{
				 data_no = data_no + ","  + checks[i].value ;
			}
		}
	}
	
	if(data_no != null)
	{
		if(window.confirm('選択した項目をダウンロードしますか？'))
		{
			location.href = "data_view.php?file_dl=" + data_no ;
		} 
		else
		{
			location.href = "data_view.php";
		}
	}
	else
	{
		if(window.confirm('チェックが選択されていません'))
		{}
		else
		{}
	}

}

//■確認ボタンの切り替え処理
function CheckPush(id_,no_)
{
	//チェックボタンは配列に入っている
	confirmer_ = document.getElementsByName("confirmer_reg");
	implementation_date_ = document.getElementsByName("implementation_date");
	memo_ = document.getElementsByName("memo_reg");
	
	console.log(confirmer_[id_].value);
	console.log(implementation_date_ [id_].value);
	
	var conf = confirmer_[id_].value;
	var imp = implementation_date_[id_].value;	
	var memo = memo_[id_].value;	
	
	location.href = "data_view.php?chk=" + no_ + "&conf=" + conf + "&imp=" + imp + "&memo=" + memo;
}
/////////////////////////////////////////////////////////////////////
</script>


<?php
/////関数(php)///////////////////////////////////////////////////////
//■フォルダ内のファイル削除($dirは該当ファイルがあるディレクトリの絶対パス)
function deleteData ( $dir )
{
    if ( $dirHandle = opendir ( $dir )) {
        while ( false !== ( $fileName = readdir ( $dirHandle ) ) ) {
            if ( $fileName != "." && $fileName != ".." ) {
                unlink ( $dir.$fileName );
            }
        }
        closedir ( $dirHandle );
    }
}

//----------------------------------------------------------------------
//初期値設定
//----------------------------------------------------------------------
//アップロード時の保存パス
$record_dir = '/www/geye/inspection/record/';
$pict_dir = '/www/geye/inspection/pict/';
$pict_dir_s = '/www/geye/inspection/pict_s/';

//zip保存用
$zip_dir = '/geye/';


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

$sv = "192.168.100.153";
$dbname = "geye";
$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']);

*/

EXTRACT($_GET);
//■削除処理
if($del)
{
	$DelSql = "UPDATE inspection_record SET ";
	$DelSql .= "del_flag = 'TRUE' ";
	$DelSql .= " WHERE id IN (" .$del .");";
	
	if (!($resDelSql = pg_query($conn, $DelSql)))
	{
		print pg_last_error() ."<BR>";
//		throw new Exception("データ取得に失敗<br />". $DelArea. "<br />". pg_last_error(). "<br />");
	}
	
}

//■確認処理
if($chk)
{
//	print "chk==" .$chk;
	//現在の確認状況を取得
	$sql_ch = "SELECT * FROM inspection_record WHERE id = " .$chk ." AND del_flag ='false' ;";
	$res_ch = pg_query($conn,$sql_ch);
	$row_ch = pg_fetch_array($res_ch,0);
	
	//print $row_ch['chk_flag'] ."<BR>";
	$chk_flag = ($row_ch['chk_flag'] == 'f') ? "true" : "false";
	
	$sql_chup = "UPDATE inspection_record SET ";
	$sql_chup .= "confirmer = '" .$conf ."', ";
	$sql_chup .= "implementation_date = '" .$imp ."',";
	$sql_chup .= "memo = '" .$memo ."',";
	$sql_chup .= "chk_flag = '" .$chk_flag ."' ";
	$sql_chup .= " WHERE id = " .$chk .";";
	
	if (!($res_chup = pg_query($conn, $sql_chup )))
	{
//		print pg_last_error() ."<BR>";
//		throw new Exception("データ取得に失敗<br />". $DelArea. "<br />". pg_last_error(). "<br />");
	}
	
}


//print_r($_GET);

//■ダウンロード処理
if($file_dl)
{
	//データidの分割
	$id_ = explode(",",$file_dl);
	$id_count_ = count($id_);
	//print $id_count_;
	for($k = 0;$k < $id_count_ ;$k++)
	{
//		print $id_[$k] ."<BR>";
		//zip用ファイルの初期化(削除)
		deleteData($zip_dir);

		//ZIP用のフォルダの作成
		$zip_sub_dir = $zip_dir.$id_[$k];
		mkdir($zip_sub_dir , 0777);
		$zip_sub_dir_rec = $zip_sub_dir ."/record/";
		$zip_sub_dir_pict = $zip_sub_dir ."/pict/";
		mkdir($zip_sub_dir_rec , 0777);
		mkdir($zip_sub_dir_pict , 0777);
		
		//対象ファイルをコピー
		$cmd_1 = "cp -a " .$record_dir .$id_[$k] ."_*" ." " .$zip_sub_dir_rec;
		$cmd_2 = "cp -a " .$pict_dir .$id_[$k] ."_*" ." " .$zip_sub_dir_pict;
		exec($cmd_1);
		exec($cmd_2);
	}
	//zipの作成
	$file_name_date = date("YmdHis" ,time());
	$zip_path = $zip_dir .$file_name_date .".zip";
	//$zip_path = $id_[$k] .".zip";
	//print $zip_path;
	$cmd_3 = "zip -r " .$zip_path  ." /geye/*";
	exec($cmd_3);
	print $cmd_3 ;
	$file_name = $file_name_date .".zip";
	//exit;
	header('Location: http://penta-02.ptgw.net/geye/download.php?u=3&f=' .$file_name );

}












$sql_v = "SELECT * FROM inspection_record WHERE del_flag ='false' ORDER BY id DESC;";
$res_v = pg_query($conn,$sql_v);
$ct_v = pg_num_rows($res_v);


//$row[chk] = "未確認";

//print_r($_POST);
//print_r($_GET);


print "<form enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<INPUT TYPE='submit' NAME='reload' VALUE='画面更新' class='button'>";
print "</form>";
print "チェック項目の ";
print "<INPUT TYPE='submit' NAME='download' VALUE='ダウンロード' onclick='dlServlet()' class='button'>";
//print "<INPUT TYPE='submit' NAME='download' VALUE='ダウンロード' class='button'>";
print "<INPUT TYPE='submit' NAME='delite' VALUE='削除' onclick='goDeleteServlet()' class='hoge button'>";

print "<TABLE BORDER=\"1\">";
print "<TR BGCOLOR='blue'>";
print "<TH WIDTH='20'><FONT SIZE ='2' COLOR='white' >CB</FONT></TH>";
print "<TH WIDTH='20'><FONT SIZE ='2' COLOR='white' >No</FONT></TH>";
print "<TH WIDTH='130'><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='100'><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='200'><FONT SIZE ='2' COLOR='white'>記事</FONT></TH>";
print "</TR>";


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

for($i = 0 ;$i < $ct_v;$i++)
{
	print "<TR ALIGN='center'>";
	$row = pg_fetch_array($res_v,$i);

	$no = $row[0];
	$scheduled_date = date("Y-m-d" ,strtotime($row[1])) ."<BR>" .date("H:i" ,strtotime($row[1]));
	$place =  $row[2];
	$construction =  $row[3];
	$inspection_name = $row[4];
	$supervision_engineer = $row[5];
	$confirmer = $row[6];
	$implementation_date = ($row[7]) ? date("Y-m-d" ,strtotime($row[7])) : "";
	$record =  explode(",",$row[8]);
	$record_ct = count($record);
	$pict =  explode(",",$row[9]);
	$pict_ct = count($pict);
	//print $pict[0] ."<BR>";

	$memo =  $row[10];
	$updatetime =  $row[11];
	$regdatetime =  $row[12];
	$chk_flag = ($row[13] === f) ? '--------':'確認済';

	//確認者･実施日のテキストボックスの有効/無効切り替え
	$disabled = ($row[13] === f) ? "":"disabled='disabled'";


	print "<TD><INPUT TYPE='checkbox' NAME='check' VALUE='$no' ></TD>";
	print "<TD>" .$no ."</TD>";
	print "<TD><INPUT TYPE='submit' NAME='chk_f[]' VALUE='$chk_flag' onclick='CheckPush(\"" .$i ."\",\"" .$no ."\");' ></TD>";

	print "<TD><FONT SIZE ='2'>" .$scheduled_date ."</FONT></TD>";
	print "<TD>" .$place ."&nbsp;</TD>";
	print "<TD>" .$construction ."&nbsp;</TD>";


	//確認者　実施日
	print "<TD>" .$inspection_name ."&nbsp;</TD>";
	print "<TD>" .$supervision_engineer ."&nbsp;</TD>";
	print "<TD><INPUT TYPE='text' size='10' NAME='confirmer_reg' VALUE='" .$confirmer ."' "  .$disabled ." ></TD>";
	print "<TD><INPUT TYPE='text' size='10' NAME='implementation_date' VALUE='" .$implementation_date ."' "  .$disabled ."></TD>";
	print "<TD>";




	//調書
	for($cp = 0 ;$cp < $record_ct;$cp++)
	{
		if($record[$cp])
		{
			$record_name = $record[$cp];
			$record_name_v = explode("_",$record[$cp]);
			
			if (file_exists($record_dir .$record_name))
			{
				print "<a href='download.php?u=1&f=" .$record_name ."'>" .$record_name_v[2] ."</a>" ."&nbsp;&nbsp;";
				print "<BR>";
			}
		}
	}

	print "&nbsp;</TD>";



//写真の表示
	print "<TD>";
	for($cp = 0 ;$cp < $pict_ct;$cp++)
	{
		if($pict[$cp])
		{
			if (file_exists($pict_dir .$pict[$cp]))
			{
				$thum_name = "inspection/pict_s/" .str_replace("." ,"_s." ,$pict[$cp]);
				//print $thum_name ."<BR>";
				$pict_name = $pict[$cp];
				print "<a href='download.php?u=2&f=" .$pict_name ."'.><img src='" .$thum_name ."' alt='" .$pict_name ."'></a>";
				print "&nbsp;&nbsp;";
			}
		}
	}


	print "&nbsp;</TD>";
	print "<TD><INPUT TYPE='text' size='25' NAME='memo_reg' VALUE='" .$memo ."' "  .$disabled ." ></TD>";
	//print "<TD>" .$memo ."&nbsp;</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