" .$file_list[$fct] ."
"; print "

"; print " "; print " "; print " "; print "

"; } else { $thum_name = "./inspection/" .$id_ ."/pict_s/" .str_replace("." ,"_s." ,$file_list[$fct]); print ""; print ""; print "  "; } } } } //------------------------------------------------------------------------------------------------ //初期値設定 //------------------------------------------------------------------------------------------------ //アップロード時の保存パス //$record_dir = '/www/geye/inspection/record/'; //$pict_dir = '/www/geye/inspection/pict/'; //$pict_dir_s = '/www/geye/inspection/pict_s/'; //■アップロード時の保存パス $save_dir = "/www/geye/inspection/"; $record_dir = "/record/"; $pict_dir = "/pict/"; $pict_dir_s = "/pict_s/"; $delete_dir = "/delete/"; $upload_pict_dir = "/www/geye/pict/"; //print time(); //zip保存用 $zip_dir = '/geye/'; //GETデータの出力(データ抽出) EXTRACT($_GET); //print_r($_GET); //print_r($_POST); //------------------------------------------------------------------------------------------------- // 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("接続エラー"); //------------------------------------------------------------------------------------------------- // 調書に使用する項目リストをDBから取得 //------------------------------------------------------------------------------------------------- $sql_item = "SELECT * FROM check_item_name ORDER BY id;"; $res_item = pg_query($conn,$sql_item); $count_item = pg_num_rows($res_item); //------------------------------------------------------------------------------------------------- // アップロードされた画像の振り分け //------------------------------------------------------------------------------------------------- if($_POST['pictupload']) { $sql_p = "SELECT * FROM inspection_record WHERE del_flag=false ORDER BY scheduled_date desc;"; $res_p = pg_query($conn,$sql_p); $count_p = pg_num_rows($res_p); //対象データの期間(デフォルト3時間) $range_1 = 10800; //秒 $range_2 = 10800; //秒 for($p=0;$p<$count_p;$p++) { $row_p = pg_fetch_array($res_p,$p); $id = $row_p['id']; $schedul_unix = strtotime($row_p['scheduled_date']); $schedul_date = date("Ymd" ,$schedul_unix); //希望日から*時間前 $past_unix = $schedul_unix - $range_1; $past_date = date("Ymd" ,$past_unix); //希望日から*時間後 $future_unix = $schedul_unix + $range_2; $future_date = date("Ymd" ,$future_unix); //今日のフォルダ画像を検索 $upload_pict_dir_ = $upload_pict_dir .$schedul_date; if ($dirHandle = opendir ($upload_pict_dir_)) { while ( false !== ( $fileName = readdir ( $dirHandle))) { if ( $fileName != "." && $fileName != ".." ) { //ファイルの更新時間 $file_datetime = filemtime($upload_pict_dir_ ."/" .$fileName); //print $id ."_" .$past_unix ."_" .$file_datetime ."_" .$future_unix ."
"; if(($past_unix < $file_datetime) && ($file_datetime < $future_unix)) { //print $id ."_" .$past_unix ."_" .$file_datetime ."_" .$future_unix ."_" .$fileName ."
"; copy($upload_pict_dir_ ."/" .$fileName , $save_dir .$id .$pict_dir.$fileName ); ThumbnailMake($save_dir .$id .$pict_dir,$fileName,$save_dir .$id .$pict_dir_s ,77,75); } } } closedir ( $dirHandle ); } if($schedul_date != $past_date) { print "前日"; //前日のフォルダ画像を検索 $upload_pict_dir_ = $upload_pict_dir .$past_date; //print $upload_pict_dir_ ."
"; if ($dirHandle = opendir ($upload_pict_dir_)) { while ( false !== ( $fileName = readdir ( $dirHandle))) { if ( $fileName != "." && $fileName != ".." ) { //ファイルの更新時間 $file_datetime = filemtime($upload_pict_dir_ ."/" .$fileName); //print $id ."_" .$past_unix ."_" .$file_datetime ."_" .$future_unix ."
"; if(($past_unix < $file_datetime) && ($file_datetime < $future_unix)) { //print $id ."_" .$past_unix ."_" .$file_datetime ."_" .$future_unix ."
"; copy($upload_pict_dir_ ."/" .$fileName , $save_dir .$id .$pict_dir.$fileName ); ThumbnailMake($save_dir .$id .$pict_dir,$fileName,$save_dir .$id .$pict_dir_s ,77,75); } } } closedir ( $dirHandle ); } } if($schedul_date != $future_date) { print "後日"; //後日のフォルダ画像を検索 $upload_pict_dir_ = $upload_pict_dir .$future_date; //print $upload_pict_dir_ ."
"; if ($dirHandle = opendir ($upload_pict_dir_)) { while ( false !== ( $fileName = readdir ( $dirHandle))) { if ( $fileName != "." && $fileName != ".." ) { //ファイルの更新時間 $file_datetime = filemtime($upload_pict_dir_ ."/" .$fileName); if(($past_unix < $file_datetime) && ($file_datetime < $future_unix)) { //print $id ."_" .$past_unix ."_" .$file_datetime ."_" .$future_unix ."
"; copy($upload_pict_dir_ ."/" .$fileName , $save_dir .$id .$pict_dir.$fileName ); ThumbnailMake($save_dir .$id .$pict_dir,$fileName,$save_dir .$id .$pict_dir_s ,77,75); } } } closedir ( $dirHandle ); } } } } //------------------------------------------------------------------------------------------------- //フォームアクション処理(削除･確認画面･ダウンロード) //------------------------------------------------------------------------------------------------- //■削除処理 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() ."
"; } //■確認処理 if($chk) { /* //現在の確認状況を取得 $sql_ch = "SELECT * FROM inspection_record_t 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_t 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() ."
"; */ //現在の確認状況を取得 $sql_chup = "UPDATE inspection_record SET "; $sql_chup .= "confirmer = '" .$conf ."', "; $sql_chup .= "implementation_date = '" .$imp ."',"; $sql_chup .= "memo = '" .$memo ."'"; $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用ファイルの初期化(削除) $cmd_del = "rm -Rf " .$zip_dir ."*"; exec($cmd_del); //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 " .$save_dir .$id_[$k] .$record_dir ."/*" ." " .$zip_sub_dir_rec; $cmd_2 = "cp -a " .$save_dir .$id_[$k] .$pict_dir ."/*" ." " .$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"; //print 'http://penta-02.ptgw.net/geye/download.php?u=3&f=' .$file_name; header('Location: http://penta-02.ptgw.net/geye/download.php?u=3&f=' .$file_name ); } //------------------------------------------------------------------------------------------------- // データの一覧表の作成 //------------------------------------------------------------------------------------------------- if(!$_POST['record_chk'] && !$_GET['list_no_']) { //■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 ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; for($i = 0 ;$i < $ct_v;$i++) { $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])) : ""; $memo = $row[8]; $updatetime = $row[9]; $regdatetime = $row[10]; $chk_flag = ($row[11] === f) ? '--------':'確認済'; print ""; //●確認者･実施日のテキストボックスの有効/無効切り替え $disabled = ($row[11] === f) ? "":"disabled='disabled'"; print ""; print ""; //print ""; print ""; print ""; print ""; print ""; //●確認者　実施日 print ""; print ""; print ""; print ""; //●調書 print ""; //●写真の表示 print ""; //●記事の表示 print ""; print ""; print ""; } print "

CB	No	確認	希望日	場所	工種	検査項目	管理技術者	確認者	実施日	調書	写真	記事	登録
	" .$no ."		" .$chk_flag ."	" .$scheduled_date ."	" .$place ."	" .$construction ."	" .$inspection_name ."	" .$supervision_engineer ."			"; DlLinkMake(1,$no,$save_dir,$record_dir,0); print "	"; DlLinkMake(2,$no,$save_dir,$pict_dir,0); print "

"; } else { $no = ($_POST['id_']) ? $_POST['id_'] : $_GET['id_']; $list_no = ($_POST['list_no_']) ? $_POST['list_no_']: $_GET['list_no_']; //■項目がチェックされた場合､DBをアップデート if($_GET['list_no_']) { if($_GET['item_no']) { //編集中のIDをテキストファイルに出力 //キャプチャ画像と結びつけるため $fp_id = fopen("editing_id.txt","w"); fwrite($fp_id,$no ."," .$list_no ."," .$_GET['item_no']); fclose($fp_id); ///////////////////////////////////// $regdate = date("Y-m-d H:i:s",time()); $sql_up = "UPDATE record_check_list SET "; $sql_up .= ($_GET['chk']=='true') ? "regdatetime='" .$regdate ."'," :""; $sql_up .= "chk=" .$_GET['chk']; $sql_up .= " WHERE data_no=" .$no ." AND list_no=" .$list_no ." AND item_no=" .$_GET['item_no']; $res_up = pg_query($conn,$sql_up)OR DIE (pg_last_error() .$sql_up ."
"); //確認が全て終わっているか確認･終わっていれば確認済みにする $sel_ct = "SELECT count(data_no = " .$no ." or null) AS data_ct,count(chk=true or null) AS chk_ct FROM record_check_list WHERE data_no=" .$no ; $res_ct = pg_query($conn,$sel_ct); $row_ct = pg_fetch_array($res_ct,0); if($row_ct['data_ct'] == $row_ct['chk_ct']) { $sql_up2 = "UPDATE inspection_record SET "; $sql_up2 .= "chk_flag=true"; $sql_up2 .= " WHERE id=" .$no ; $res_up2 = pg_query($conn,$sql_up2)OR DIE (pg_last_error() .$sql_up2 ."
"); } else { $sql_up2 = "UPDATE inspection_record SET "; $sql_up2 .= "chk_flag=false"; $sql_up2 .= " WHERE id=" .$no ; $res_up2 = pg_query($conn,$sql_up2)OR DIE (pg_last_error() .$sql_up2 ."
"); } } } //■DBから最新データの抽出 $sql_v = "SELECT * FROM inspection_record WHERE id=" .$no .";"; $res_v = pg_query($conn,$sql_v); $ct_v = pg_num_rows($res_v); //■DBからチェックリストの抽出 $sql_cl = "SELECT * FROM record_check_list WHERE data_no=" .$no ." AND list_no=" .$list_no ." ORDER BY sort_no;"; $res_cl = pg_query($conn,$sql_cl); $ct_cl = pg_num_rows($res_cl); //■DBからチェックリストの項目名を抽出 for($ict =0;$ict< $count_item;$ict++) { $row_item = pg_fetch_array($res_item,$ict); $id_item = $row_item['id']; $item_name[$id_item] = $row_item['name']; } //■データ表の作成 print ""; print ""; // print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; $row = pg_fetch_array($res_v,0); $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[8]; $updatetime = $row[9]; $regdatetime = $row[10]; $chk_flag = ($row[11] === f) ? '--------':'確認済'; print ""; //●確認者･実施日のテキストボックスの有効/無効切り替え $disabled = ($row[11] === f) ? "":"disabled='disabled'"; print ""; //print ""; print ""; print ""; print ""; print ""; //●確認者　実施日 print ""; print ""; print ""; print ""; // print ""; print ""; //●写真の表示 print ""; //●記事の表示 print ""; print ""; print "

CB	No	確認	希望日	場所	工種	検査項目	管理技術者	確認者	実施日	調書	写真	記事	"; print ""; print " "; print ""; print " "; print "
" .$no ."		" .$chk_flag ."	" .$scheduled_date ."	" .$place ."	" .$construction ."	" .$inspection_name ."	" .$supervision_engineer ."				"; //●調書 $dir = $save_dir .$no .$record_dir; if (is_dir($dir)) { if ($dh = opendir($dir)) { while (($file = readdir($dh)) !== false) { if ( $file != "." && $file != ".." ) { $list_no_ = filemtime($dir .$file); if($list_no_ == $list_no) { print "" .$file ." "; print " "; for($cl =0;$cl< $ct_cl;$cl++) { $row_cl = pg_fetch_array($res_cl,$cl); $cl_id = $row_cl['item_no']; $chk = $row_cl['chk']; $checked = ($row_cl['chk'] === t) ? "checked" : ""; print "" .$item_name[$cl_id] ." "; } print " "; } } } closedir($dh); } } print "	"; DlLinkMake(2,$no,$save_dir,$pict_dir,0); print "

"; } ?>