"; } //■確認処理 if($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); $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() ."
"; } //■ダウンロード処理 if($file_dl) { //データidの分割 $id_ = explode(",",$file_dl); $id_count_ = count($id_); for($k = 0;$k < $id_count_ ;$k++) { //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"; $cmd_3 = "zip -r " .$zip_path ." /geye/*"; exec($cmd_3); print $cmd_3 ; $file_name = $file_name_date .".zip"; header('Location: http://penta-02.ptgw.net/geye/download.php?u=3&f=' .$file_name ); } //------------------------------------------------------------------------------------------------- // データの一覧表の作成 //------------------------------------------------------------------------------------------------- //■DBから最新データの抽出 $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); //■フォームボタンの作成(ダウンロード･削除) print "
"; print ""; print "
"; print "チェック項目の "; print ""; print ""; //■データ表の作成 print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; for($i = 0 ;$i < $ct_v;$i++) { print ""; $row = pg_fetch_array($res_v,$i); $no = $row[0]; $scheduled_date = date("Y/m/d" ,strtotime($row[1])) ."
" .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); $memo = $row[10]; $updatetime = $row[11]; $regdatetime = $row[12]; $chk_flag = ($row[13] === f) ? '--------':'確認済'; //●確認者･実施日のテキストボックスの有効/無効切り替え $disabled = ($row[13] === f) ? "":"disabled='disabled'"; print ""; print ""; print ""; print ""; print ""; print ""; //●確認者　実施日 print ""; print ""; print ""; print ""; // print ""; print ""; //●写真の表示 print ""; //●記事の表示 print ""; print ""; } print "
CBNo確認希望日場所工種検査項目管理技術者確認者実施日調書写真記事
" .$no ."" .$scheduled_date ."" .$place ." " .$construction ." " .$inspection_name ." " .$supervision_engineer ." "; //●調書 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 "" .$record_name_v[2] ."" ."  "; print "
"; } } } print " 		"; 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 ."
"; $pict_name = $pict[$cp]; print "" .$pict_name .""; print "  "; } } } print " 
"; ?>