File "data_regist_org.php"
Full path: /www/geye/OLD/data_regist_org.php
File size: 44.91 KiB (45983 bytes)
MIME-type: text/html
Charset: utf-8
<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>
<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_regist.php?del=" + data_no ;
}
else
{
location.href = "data_regist.php";
}
}
else
{
if(window.confirm('削除のチェックが選択されていません'))
{}
else
{}
}
}
//■ファイル個別削除
function FileDeleteServlet(edit_id_,file_cat_,file_name_)
{
console.log("file_del");
var edit_id = edit_id_;
var file_del = file_cat_;
var file_name = file_name_;
if(edit_id != null)
{
if(window.confirm('対象のファイルを削除してもよろしいですか？'))
{
location.href = "data_regist.php?edit_id=" + edit_id + "&file_del=" + file_del + "&file_name=" + file_name;
}
else
{
location.href = "data_regist.php";
}
}
}
//■ファイルダウンロード
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_regist.php?file_dl=" + data_no ;
}
else
{
location.href = "data_regist.php";
}
}
else
{
if(window.confirm('チェックが選択されていません'))
{}
else
{}
}
}
</script>
<?php
//-------------------------------------------------------------------------------------------------
//関数(php)
//-------------------------------------------------------------------------------------------------
//■プルダウン作成(数値型)
function Pulldown_create_int($width ,$name_,$min_int, $max_int,$interval,$selected,$Space)
{
print "<select name='" .$name_ ."' style='width:" .$width ."px;'>";
for($j= $min_int ;$j < $max_int;$j += $interval)
{
$sel = ($j == $selected) ? "selected" : "";
print "<option value='" .$j ."' " .$sel ." >" .$j ."</option>";
}
if (is_null($selected) && $Space)
{
print "<option value='' selected > </option>";
}
print "</select>";
}
//■フォルダ内のファイル削除($dirは該当ファイルがあるディレクトリの絶対パス)
function deleteData ( $dir )
{
if ( $dirHandle = opendir ( $dir )) {
while ( false !== ( $fileName = readdir ( $dirHandle ) ) ) {
if ( $fileName != "." && $fileName != ".." ) {
unlink ( $dir.$fileName );
}
}
closedir ( $dirHandle );
}
}
//■フォルダ内のファイル移動($dir1元ディレクトリ,$dir2移動先ディレクトリ)
function moveData ( $dir1,$dir2 )
{
if ( $dirHandle = opendir ( $dir1 )) {
while ( false !== ( $fileName = readdir ( $dirHandle ) ) ) {
if ( $fileName != "." && $fileName != ".." ) {
rename($dir1.$fileName , $dir2.$fileName);
}
}
closedir ( $dirHandle );
}
}
//■元画像からサムネイル画像の作成
function ThumbnailMake($tmp_dir_,$in_pict,$out_pict,$x_size,$y_size)
{
list($width, $hight) = getimagesize($tmp_dir_ .$in_pict); // 元の画像名を指定してサイズを取得
$baseImage = imagecreatefromjpeg($tmp_dir_.$in_pict); // 元の画像から新しい画像を作る準備
$image = imagecreatetruecolor($x_size, $y_size); // サイズを指定して新しい画像のキャンバスを作成
// 画像のコピーと伸縮
imagecopyresampled($image, $baseImage, 0, 0, 0, 0, $x_size, $y_size, $width, $hight);
// コピーした画像を出力する
$name_replace = str_replace("." ,"_s.",$in_pict);
$out_pict = $out_pict. $name_replace;
imagejpeg($image , $out_pict);
}
//■ファイルのダウンロードリンク作成(テキスト･画像サムネイル)
//DlLinkMake(リンクタイプ[1:テキスト､2:画像],データ名[配列],ファイルのパス,表内の位置)
function DlLinkMake($dl_type_,$data_name_,$dir_path_,$Align_)
{
$data_ct_ = count($data_name_);
print "<TD ALIGN='" .$Align_ ."'>";
for($cp = 0 ;$cp < $data_ct_;$cp++)
{
if($data_name_[$cp])
{
$file_data = $data_name_[$cp];
if($dl_type_ == 1)
{
$file_data_v = explode("_",$file_data);
if (file_exists($dir_path_ .$file_data))
{
print "<a href='download.php?u=" .$dl_type_ ."&f=" .$file_data ."'>" .$file_data_v[2] ."</a><BR>";
}
}
else
{
$thum_name = "./inspection/pict_s/" .str_replace("." ,"_s." ,$data_name_[$cp]);
if (file_exists($dir_path_ .$file_data))
{
print "<a href='download.php?u=" .$dl_type_ ."&f=" .$file_data ."'.>";
print "<img src='" .$thum_name ."' alt='" .$file_data ."'></a>";
print " ";
}
}
}
}
print " </TD>";
}
//-------------------------------------------------------------------------------------------------
//初期値設定
//-------------------------------------------------------------------------------------------------
//■現在時刻の取得･設定
$now_time = time() + 86400;
$now_time_date = date("Y年m月d日 H時i分",$now_time);
$reg_date_time = $now_time;
$date_y = date("Y",$now_time);
$date_m = date("m",$now_time );
$date_d = date("d",$now_time);
$time_h = date("H",$now_time);
$time_m = date("i",$now_time);
//■アップロード時の一時保存パス
$tmp_record_dir = '/www/geye/tmp_record/';
$tmp_pict_dir = '/www/geye/tmp_pict/';
$tmp_pict_dir_s = '/www/geye/tmp_pict_s/';
//■アップロード時の保存パス
$record_dir = '/www/geye/inspection/record/';
$pict_dir = '/www/geye/inspection/pict/';
$pict_dir_s = '/www/geye/inspection/pict_s/';
//■zip保存用
$zip_dir = '/geye/';
//■POST･GETデータの出力
EXTRACT($_GET);
EXTRACT($_POST);
//print_r($_GET);
//print_r($_POST);
//-------------------------------------------------------------------------------------------------
// 接続設定（サーバ／データベース／ユーザ／パスワード）
//-------------------------------------------------------------------------------------------------
$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($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($file_dl)
{
//データidの分割
$id_ = explode(",",$file_dl);
$id_count_ = count($id_);
//zip用ファイルの初期化(削除)
$cmd_del = "rm -Rf " .$zip_dir ."*";
exec($cmd_del);
//deleteData($zip_dir);
for($k = 0;$k < $id_count_ ;$k++)
{
//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";
header('Location: http://penta-02.ptgw.net/geye/download.php?u=3&f=' .$file_name );
}
//-------------------------------------------------------------------------------------------------
// 画面上部に画面更新ボタンの配置
//-------------------------------------------------------------------------------------------------
print "<form enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<INPUT TYPE='submit' NAME='reload' VALUE='画面更新' class='button'>";
print "</form>";
print "<HR>";
//-------------------------------------------------------------------------------------------------
// 新規申請･編集処理
//-------------------------------------------------------------------------------------------------
//■■新規申請
if($_POST['request'])
{
print "【新規申請】<BR>";
if($_POST['send_address'])
{
//現在のデータ登録数を取得(ファイル名の頭につける)
$sql_max = "SELECT max(id) FROM inspection_record;";
$res_max = pg_query($conn,$sql_max);
$row_max = pg_fetch_array($res_max,0);
$id = $row_max[0] + 1;
//一時フォルダ内のファイルの削除(調書･画像)
deleteData ($tmp_record_dir);
deleteData ($tmp_pict_dir);
deleteData ($tmp_pict_dir_s);
//アップロードファイルの確認(一時的に保存)
//①調書ファイルがあれば処理実行
if(isset($_FILES['upfile_record']))
{
// アップロードされたファイル件を処理
for($i = 0; $i < count($_FILES['upfile_record']['name']); $i++ )
{
// アップロードされたファイルか検査
if(is_uploaded_file($_FILES['upfile_record']['tmp_name'][$i]))
{
//ファイル名をナンバリングする
$ii = $i+1;
$record_file_name = $id ."_" .$ii ."_" .$_FILES['upfile_record']['name'][$i];
//データベース登録用(ファイル名:aaaa.pdf,bbbb.pdf･･･)
$record_regist_name .= ($i >= 1) ? "," :"";
$record_regist_name .= $record_file_name;
//ファイルを一時保存フォルダへ移動
move_uploaded_file($_FILES['upfile_record']['tmp_name'][$i], "./tmp_record/" .$record_file_name);
}
}
}
//②画像ファイルがあれば処理実行
if(isset($_FILES['upfile_pict']))
{
// アップロードされたファイル件を処理
for($j = 0; $j < count($_FILES['upfile_pict']['name']); $j++ )
{
// アップロードされたファイルか検査
if(is_uploaded_file($_FILES['upfile_pict']['tmp_name'][$j]))
{
//ファイル名をナンバリングする
$jj = $j+1;
$pict_file_name = $id ."_" .$jj ."_" .$_FILES['upfile_pict']['name'][$j];
//データベース登録用(ファイル名:aaaa.pdf,bbbb.pdf･･･)
$pict_regist_name .= ($j >= 1) ? "," :"";
$pict_regist_name .= $pict_file_name;
// ファイルをお好みの場所に移動
$tmp_pict_path = $tmp_pict_dir .$pict_file_name;
move_uploaded_file($_FILES['upfile_pict']['tmp_name'][$j],$tmp_pict_path);
//サムネイル画像作成
ThumbnailMake($tmp_pict_dir,$pict_file_name,$tmp_pict_dir_s,77,75);
}
}
}
print "以下の内容で申請します。よろしいですか？";
print "<BR>";
print "※申請先メールアドレスへメールが送信されます";
print "<TABLE BORDER=\"1\">";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='150'><FONT SIZE ='2' COLOR='white'>申請先メールアドレス</FONT></TH>";
print "<TD WIDTH='200'>" .$_POST['send_address'] ."</TD>";
print "</TR>";
print "<TR>";
$make_date = $_POST['date_y_'] ."年" .$_POST['date_m_'] ."月" .$_POST['date_d_'] ."日";
$make_date .= $_POST['time_h_'] ."時" .$_POST['time_m_'] ."分";
$mk_date_reg = mktime($_POST['time_h_'],$_POST['time_m_'],0,$_POST['date_m_'],$_POST['date_d_'],$_POST['date_y_']);
print "<TH BGCOLOR='blue' WIDTH='20'><FONT SIZE ='2' COLOR='white'>希望日</FONT></TH>";
print "<TD WIDTH='200'>" .$make_date ."</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>場所</FONT></TH>";
print "<TD WIDTH='200'>" .$_POST['place_reg'] ."</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>工種</FONT></TH>";
print "<TD WIDTH='200'>" .$_POST['construction_reg'] ."</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>検査項目</FONT></TH>";
print "<TD WIDTH='200'>" .$_POST['inspection_name_reg'] ."</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>監理技術者</FONT></TH>";
print "<TD WIDTH='200'>" .$_POST['supervision_engineer_reg'] ."</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='200'><FONT SIZE ='2' COLOR='white'>記事</FONT></TH>";
print "<TD WIDTH='200'>" .$_POST['memo_reg'] ."</TD>";
print "</TR>";
print "</TABLE>";
print "<form enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<INPUT TYPE='submit' NAME='sentaku_yes' VALUE='はい' class='button'>";
print "<INPUT TYPE='submit' NAME='sentaku_no' VALUE='いいえ' class='button'>";
print "<INPUT TYPE='hidden' NAME='send_address' VALUE='" .$_POST['send_address'] ."'>";
print "<INPUT TYPE='hidden' NAME='scheduled_date_reg' VALUE='" .$mk_date_reg ."'>";
print "<INPUT TYPE='hidden' NAME='place_reg' VALUE='" .$_POST['place_reg'] ."'>";
print "<INPUT TYPE='hidden' NAME='construction_reg' VALUE='" .$_POST['construction_reg'] ."'>";
print "<INPUT TYPE='hidden' NAME='inspection_name_reg' VALUE='" .$_POST['inspection_name_reg'] ."'>";
print "<INPUT TYPE='hidden' NAME='supervision_engineer_reg' VALUE='" .$_POST['supervision_engineer_reg'] ."'>";
print "<INPUT TYPE='hidden' NAME='record_reg' VALUE='" .$record_regist_name ."'>";
print "<INPUT TYPE='hidden' NAME='pict_reg' VALUE='" .$pict_regist_name ."'>";
print "<INPUT TYPE='hidden' NAME='memo_reg' VALUE='" .$_POST['memo_reg'] ."'>";
print "</form>";
}
else
{
print "正しいメールアドレスを入力してください。";
}
}
//■■編集処理
else if($_POST['edit_id'] && (!$_POST['edit_cancel']))
{
$edit_id_ = ($_POST['edit_id']) ? $_POST['edit_id'] : $edit_id;
//print $edit_id_;
$sql_e = "SELECT * FROM inspection_record WHERE id =" .$edit_id_ ." ORDER BY scheduled_date DESC;";
$res_e = pg_query($conn,$sql_e);
$row_e = pg_fetch_array($res_e,0);
$scheduled_date = $row_e['scheduled_date']; //希望日
$place = $row_e['place']; //場所
$construction = $row_e['construction']; //工種
$inspection_name = $row_e['inspection_name']; //検査項目
$supervision_engineer = $row_e['supervision_engineer']; //監理技術者
$confirmer = $row_e['confirmer']; //確認者
$implementation_date = $row_e['implementation_date']; //実施日
$record = $row_e['record']; //調書(ファイル名1,ファイル名2,・・・)
$pict = $row_e['pict']; //写真(ファイル名1,ファイル名2,・・・)
$memo = $row_e['memo']; //記事(メモ)
$updatetime = $row_e['updatetime']; //更新日時(最終編集日時)
$regdatetime = $row_e['updatetime']; //登録日時(申請日時)
$chk_flag = $row_e['chk_flag']; //確認フラグ(true:確認済み、false:未確認)
$del_flag = $row_e['del_flag']; //削除フラグ(true:無効データ[削除状態]、false:有効データ)
$request_status = $row_e['request_status']; //立会承認(0:未承認、1:承認済、2:差戻、3:ﾒｰﾙ未送信)
$mail_address = $row_e['mail_address']; //メールアドレス(承認先)
//調書のファイル名を分割･カウント
$record_ = explode(",",$record);
$record_ct = count($record_);
//写真のファイル名を分割･カウント
$pict_ = explode(",",$pict);
$pict_ct = count($pict_);
//①保存を押した場合
if(($_POST['edit_save']) || ($_POST['edit_request']))
{
$ii = $record_ct;
//アップロードファイルの確認(一時的に保存)
//①調書ファイルがあれば処理実行
if(isset($_FILES['upfile_record_e']))
{
// アップロードされたファイル件を処理
for($i = 0; $i < count($_FILES['upfile_record_e']['name']); $i++ )
{
// アップロードされたファイルか検査
if(is_uploaded_file($_FILES['upfile_record_e']['tmp_name'][$i]))
{
//ファイル名をナンバリングする
$ii = $ii+1;
$record_file_name = $edit_id_ ."_" .$ii ."_" .$_FILES['upfile_record_e']['name'][$i];
//データベース登録用(ファイル名:aaaa.pdf,bbbb.pdf･･･)
$record_regist_name .= ($i >= 1) ? "," :"";
$record_regist_name .= $record_file_name;
//ファイルをフォルダへ移動
move_uploaded_file($_FILES['upfile_record_e']['tmp_name'][$i], $record_dir .$record_file_name);
}
}
if($record)
{
$record_regist_name = $record ."," .$record_regist_name;
}
}
//②画像ファイルがあれば処理実行
$jj = $pict_ct;
if(isset($_FILES['upfile_pict_e']))
{
// アップロードされたファイル件を処理
for($j = 0; $j < count($_FILES['upfile_pict_e']['name']); $j++ )
{
// アップロードされたファイルか検査
if(is_uploaded_file($_FILES['upfile_pict_e']['tmp_name'][$j]))
{
//ファイル名をナンバリングする
$jj = $jj+1;
$pict_file_name = $edit_id_ ."_" .$jj ."_" .$_FILES['upfile_pict_e']['name'][$j];
//データベース登録用(ファイル名:aaaa.pdf,bbbb.pdf･･･)
$pict_regist_name .= ($j >= 1) ? "," :"";
$pict_regist_name .= $pict_file_name;
// ファイルをお好みの場所に移動
$tmp_pict_path = $pict_dir .$pict_file_name;
move_uploaded_file($_FILES['upfile_pict_e']['tmp_name'][$j],$tmp_pict_path);
//サムネイル画像作成
ThumbnailMake($pict_dir,$pict_file_name,$pict_dir_s,77,75);
}
}
if($pict) $pict_regist_name = $pict ."," .$pict_regist_name;
}
$scheduled_date_reg = date("Y/m/d H:i:s", mktime($time_h_,$time_m_ ,0,$date_m_,$date_d_,$date_y_));
$implementation_date_reg = date("Y/m/d H:i:s" ,mktime($time2_h_,$time2_m_ ,0,$date2_m_,$date2_d_,$date2_y_));
$sql_up = "UPDATE inspection_record SET ";
$sql_up .= ($scheduled_date_reg) ? "scheduled_date='" .$scheduled_date_reg ."',":"";
$sql_up .= ($place_reg) ? "place='" .$place_reg."',":"";
$sql_up .= ($construction_reg) ? "construction='" .$construction_reg ."',":"";
$sql_up .= ($inspection_name_reg) ? "inspection_name='" .$inspection_name_reg ."',":"";
$sql_up .= ($supervision_engineer_reg) ? "supervision_engineer='" .$supervision_engineer_reg ."',":"";
$sql_up .= ($confirmer_reg) ? "confirmer='" .$confirmer_reg ."',":"";
$sql_up .= ($implementation_date_reg) ? "implementation_date='" .$implementation_date_reg ."',":"";
$sql_up .= ($record_regist_name) ? "record='" .$record_regist_name ."',":"";
$sql_up .= ($pict_regist_name) ? "pict='" .$pict_regist_name ."',":"";
$sql_up .= ($memo_reg) ? "memo='" .$memo_reg ."',":"";
$sql_up .= ($mail_address_reg) ? "mail_address='" .$mail_address_reg ."',":"";
$sql_up .= "updatetime= '".date("Y-m-d H:i:s",time()) ."'";
$sql_up .= " WHERE id=" .$edit_id_ .";";
$res_up = pg_query($conn,$sql_up);
//★内容更新
$sql_e = "SELECT * FROM inspection_record WHERE id =" .$edit_id_ ." ORDER BY scheduled_date DESC;";
$res_e = pg_query($conn,$sql_e);
$row_e = pg_fetch_array($res_e,0);
$scheduled_date = $row_e['scheduled_date']; //希望日
$place = $row_e['place']; //場所
$construction = $row_e['construction']; //工種
$inspection_name = $row_e['inspection_name']; //検査項目
$supervision_engineer = $row_e['supervision_engineer']; //監理技術者
$confirmer = $row_e['confirmer']; //確認者
$implementation_date = $row_e['implementation_date']; //実施日
$record = $row_e['record']; //調書(ファイル名1,ファイル名2,・・・)
$pict = $row_e['pict']; //写真(ファイル名1,ファイル名2,・・・)
$memo = $row_e['memo']; //記事(メモ)
$updatetime = $row_e['updatetime']; //更新日時(最終編集日時)
$regdatetime = $row_e['updatetime']; //登録日時(申請日時)
$chk_flag = $row_e['chk_flag']; //確認フラグ(true:確認済み、false:未確認)
$del_flag = $row_e['del_flag']; //削除フラグ(true:無効データ[削除状態]、false:有効データ)
$request_status = $row_e['request_status']; //立会承認(0:未承認、1:承認済、2:差戻、3:ﾒｰﾙ未送信)
$mail_address = $row_e['mail_address']; //メールアドレス(承認先)
//調書のファイル名を分割･カウント
$record_ = explode(",",$record);
$record_ct = count($record_);
//写真のファイル名を分割･カウント
$pict_ = explode(",",$pict);
$pict_ct = count($pict_);
//■再申請が押された場合
if($_POST['edit_request'])
{
//承認用URLの作成
$ok_url = "https://penta-02.ptgw.net/geye/data_update.php?id=" .$edit_id_ ."&request=1";
//否認用URLの作成
$ng_url = "https://penta-02.ptgw.net/geye/data_update.php?id=" .$edit_id_ ."&request=2";
//■内部文字エンコーディングを設定
mb_internal_encoding("ISO-2022-JP");
//ヘッダー設定
$header = "From: " ."五洋立会申請" ."<www@penta-05.ptgw2.net>" ."\n";
$header .= "Reply-To: " ."五洋立会申請" ."<www@penta-05.ptgw2.net>" ."\n";
//$header.= "Cc: " .$send_to1 ."," .$send_to2 ."\n";
//$header.= "Bcc: " ."'blue.puny@gmail.com'" ."\n";
$header .= "Content-Type: text/html;charset=ISO-2022-JP" ."\n";
$header .= "X-Mailer: myphpMail ". phpversion(). "\n";
//件名設定
$Subject = mb_convert_encoding("【立会申請】","ISO-2022-JP","UTF-8");
//本文設定
$message = mb_convert_encoding("※このメールはシステム側から送信しています" ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("以下の内容で立会申請がされました。" ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("承認・差戻を選択してURLをクリックしてください。" ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("選択を誤ってしまった場合は、正しい方をクリックしなおしてください。" ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("[承認]" .$ok_url ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("[差戻]" .$ng_url ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("希望日時 ：" .date("Y年m月d日 H時i分" ,($_POST['scheduled_date_reg'])) ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("場所 ：" .$_POST['place_reg'] ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("工種 ：" .$_POST['construction_reg'] ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("検査項目 ：" .$_POST['inspection_name_reg'] ."<BR>","ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("監理技術者：" .$_POST['supervision_engineer_reg'],"ISO-2022-JP","UTF-8");
$message = wordwrap($message, 70);
//送信する
if(mb_send_mail($_POST['mail_address_reg'], $Subject , $message,$header))
{
print "<script type='text/javascript'>";
print "alert('メールを送信しました');";
print "</script>";
}
}
}
//②削除を押した場合
else if(($_POST['check_rec']) || ($_POST['check_pict']))
{
$record_regist_name = "";
//調書の場合
if($_POST['check_rec'])
{
$check_rec_ct = count($_POST['check_rec']);
for($cp = 0 ;$cp < $record_ct;$cp++)
{
if($record_[$cp])
{
//データベース登録用(ファイル名:aaaa.pdf,bbbb.pdf･･･)
$record_regist_name .= ($cp >= 1) ? "," :"";
for($frc = 0 ;$frc < $check_rec_ct; $frc++)
{
$record_name = explode("_",$record_[$cp]);
//●ファイル比較
$record_regist_name_tmp = $record_[$cp];
if(!strcmp($record_[$cp] ,$_POST['check_rec'][$frc]))
{
$record_regist_name_tmp = "000" ."_" .$record_name[1] ."_" .$record_name[2];
rename($record_dir .$record_[$cp] , $record_dir ."DEL_" .$record_name[1] ."_" .$record_name[2]);
}
}
$record_regist_name .= $record_regist_name_tmp;
}
}
print $record_regist_name;
$sql_u = "UPDATE inspection_record SET record='" .$record_regist_name ."'";
$sql_u .= " WHERE id= ".$edit_id_;
$res_u = pg_query($conn,$sql_u);
print "対象の調書ファイルを削除しました。" ."<BR>";
}
//写真の場合
if($_POST['check_pict'])
{
$check_pict_ct = count($_POST['check_pict']);
$pict_regist_name = "";
for($cp = 0 ;$cp < $pict_ct;$cp++)
{
if($pict_[$cp])
{
//データベース登録用(ファイル名:aaaa.pdf,bbbb.pdf･･･)
$pict_regist_name .= ($cp >= 1) ? "," :"";
for($fpc = 0 ;$fpc < $check_pict_ct; $fpc++)
{
$pict_name = explode("_",$pict_[$cp]);
$pict_regist_name_tmp = $pict_[$cp];
if(!strcmp($pict_[$cp] ,$_POST['check_pict'][$fpc]))
{
$pict_regist_name_tmp = "000_" .$pict_name[1] ."_" .$pict_name[2];
rename($pict_dir .$pict_[$cp] , $pict_dir ."DEL_" .$pict_name[1] ."_" .$pict_name[2]);
}
}
$pict_regist_name .= $pict_regist_name_tmp;
}
}
$sql_u = "UPDATE inspection_record SET pict='" .$pict_regist_name ."'";
$sql_u .= " WHERE id= ".$edit_id_;
$res_u = pg_query($conn,$sql_u) OR DIE(pg_last_error());
print "対象の写真を削除しました。" ."<BR>";
}
//■最新データの取得
$sql_e = "SELECT * FROM inspection_record WHERE id =" .$edit_id_ ." ORDER BY scheduled_date DESC;";
$res_e = pg_query($conn,$sql_e);
$row_e = pg_fetch_array($res_e,0);
$scheduled_date = $row_e['scheduled_date']; //希望日
$place = $row_e['place']; //場所
$construction = $row_e['construction']; //工種
$inspection_name = $row_e['inspection_name']; //検査項目
$supervision_engineer = $row_e['supervision_engineer']; //監理技術者
$confirmer = $row_e['confirmer']; //確認者
$implementation_date = $row_e['implementation_date']; //実施日
$record = $row_e['record']; //調書(ファイル名1,ファイル名2,・・・)
$pict = $row_e['pict']; //写真(ファイル名1,ファイル名2,・・・)
$memo = $row_e['memo']; //記事(メモ)
$updatetime = $row_e['updatetime']; //更新日時(最終編集日時)
$regdatetime = $row_e['updatetime']; //登録日時(申請日時)
$chk_flag = $row_e['chk_flag']; //確認フラグ(true:確認済み、false:未確認)
$del_flag = $row_e['del_flag']; //削除フラグ(true:無効データ[削除状態]、false:有効データ)
$request_status = $row_e['request_status']; //立会承認(0:未承認、1:承認済、2:差戻、3:ﾒｰﾙ未送信)
$mail_address = $row_e['mail_address']; //メールアドレス(承認先)
//調書のファイル名を分割･カウント
$record_ = explode(",",$record);
$record_ct = count($record_);
//写真のファイル名を分割･カウント
$pict_ = explode(",",$pict);
$pict_ct = count($pict_);
}
//■申請先メールアドレス
//立会承認が"ﾒｰﾙ未送信"の場合のみ、編集可能
print "【編集中】<BR>";
print "<form enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<INPUT TYPE='submit' NAME='file_delite' VALUE='チェック項目ファイルの削除'>";
print "<TABLE BORDER=\"1\">";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='150'><FONT SIZE ='2' COLOR='white'>申請先メールアドレス</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='mail_address_reg' VALUE='" .$mail_address ."' " .$mail_disabled ."></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='20'><FONT SIZE ='2' COLOR='white'>希望日</FONT></TH>";
print "<TD WIDTH='240'>";
print Pulldown_create_int(60,"date_y_",2020,2025,1,$date_y,0) ."年";
print Pulldown_create_int(60,"date_m_",1,13,1,$date_m,0) ."月";
print Pulldown_create_int(60,"date_d_",1,32,1,$date_d,0) ."日";
print "<BR>";
print Pulldown_create_int(60,"time_h_",0,24,1,$time_h,0) ."時";
print Pulldown_create_int(60,"time_m_",0,60,10,$time_m,0) ."分";
print "</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>場所</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='place_reg' VALUE='" .$place ."'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>工種</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='construction_reg' VALUE='" .$construction ."'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>検査項目</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='inspection_name_reg' VALUE='" .$inspection_name ."'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>監理技術者</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='supervision_engineer_reg' VALUE='" .$supervision_engineer ."'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>確認者</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='$confirmer_reg' VALUE='" .$confirmer ."'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>実施日</FONT></TH>";
print "<TD WIDTH='200'>";
print Pulldown_create_int(60,"date2_y_",2020,2025,1,$date_y,0) ."年";
print Pulldown_create_int(60,"date2_m_",1,13,1,$date_m,0) ."月";
print Pulldown_create_int(60,"date2_d_",1,32,1,$date_d,0) ."日";
print "<BR>";
print Pulldown_create_int(60,"time2_h_",0,60,1,$time_h,0) ."時";
print Pulldown_create_int(60,"time2_m_",0,60,1,$time_m,0) ."分";
print "</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>調書</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='file' multiple NAME='upfile_record_e[]' size='40'>";
print "<BR>";
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 "<INPUT TYPE='checkbox' NAME='check_rec[]' VALUE='" .$record_name ."' >";
print "<a href='download.php?u=1&f=" .$record_name ."'>" .$record_name_v[2] ."</a>" ." ";
print "<BR>";
}
}
}
print "</TD";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>写真</FONT></TH>";
print "<TD WIDTH='500'><INPUT TYPE='file' multiple NAME='upfile_pict_e[]' size='40'>";
print "<BR>";
for($cp = 0 ;$cp < $pict_ct;$cp++)
{
if($pict_[$cp])
{
$thum_name = "inspection/pict_s/" .str_replace("." ,"_s." ,$pict_[$cp]);
$pict_name = $pict_[$cp];
if (file_exists($pict_dir .$pict_[$cp]))
{
print "<INPUT TYPE='checkbox' NAME='check_pict[]' VALUE='" .$pict_[$cp] ."' >";
print "<a href='download.php?u=2&f=" .$pict_name ."'.><img src='" .$thum_name ."' alt='" .$pict_name ."'></a>";
print " ";
}
}
}
print "</TD";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>記事</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='70' NAME='memo_reg' VALUE='" .$memo ."'></TD>";
print "</TR>";
print "</TABLE>";
//■再申請ボタンの表示･非表示
//立会承認が"差戻"､"ﾒｰﾙ未送信"の場合､"再申請"ボタンの表示
if($request_status >= 2) print "<INPUT TYPE='submit' NAME='edit_request' VALUE='再申請' class='button'>";
print "<INPUT TYPE='submit' NAME='edit_save' VALUE='保存' class='button'>";
print "<INPUT TYPE='submit' NAME='edit_cancel' VALUE='戻る' class='button'>";
print "<INPUT TYPE='hidden' NAME='edit_id' VALUE='" .$edit_id_ ."'>";
print "</form>";
}
//■■初期画面(画面更新時)
else
{
print "【新規申請】<BR>";
//---------------------------------------------------------------------------------------------
//●新規申請確認画面で"はい"を選択した場合の処理
if($_POST['sentaku_yes'])
{
//データの登録
$sql_ins = "INSERT INTO inspection_record(scheduled_date, ";
$sql_ins .= ($_POST['place_reg']) ? "place,": "";
$sql_ins .= ($_POST['construction_reg']) ? "construction,": "";
$sql_ins .= ($_POST['inspection_name_reg']) ? "inspection_name,": "";
$sql_ins .= ($_POST['supervision_engineer_reg']) ? "supervision_engineer,": "";
$sql_ins .= ($_POST['record_reg']) ? "record,": "";
$sql_ins .= ($_POST['pict_reg']) ? "pict,": "";
$sql_ins .= ($_POST['memo_reg']) ? "memo,": "";
$sql_ins .= "updatetime,regdatetime, mail_address) VALUES (";
$sql_ins .= "'" .date("Y-m-d H:i", $_POST['scheduled_date_reg']) ."',";
$sql_ins .= ($_POST['place_reg']) ? "'" .$_POST['place_reg'] ."',": "";
$sql_ins .= ($_POST['construction_reg']) ? "'" .$_POST['construction_reg'] ."',": "";
$sql_ins .= ($_POST['inspection_name_reg']) ? "'" .$_POST['inspection_name_reg'] ."',": "";
$sql_ins .= ($_POST['supervision_engineer_reg']) ? "'" .$_POST['supervision_engineer_reg'] ."',": "";
$sql_ins .= ($_POST['record_reg']) ? "'" .$_POST['record_reg'] ."',": "";
$sql_ins .= ($_POST['pict_reg']) ? "'" .$_POST['pict_reg'] ."',": "";
$sql_ins .= ($_POST['memo_reg']) ? "'" .$_POST['memo_reg'] ."',": "";
$sql_ins .= "'" .date("Y-m-d H:i", time()) ."',";
$sql_ins .= "'" .date("Y-m-d H:i", time()) ."',";
$sql_ins .= "'" .$_POST['send_address'] ."')";
$res_ins = pg_query($conn,$sql_ins) or die(pg_last_error() ."<BR>" .$sql_ins);
//一時ファイルを本来アップロードするフォルダへ移動
moveData($tmp_record_dir,$record_dir);
moveData($tmp_pict_dir,$pict_dir);
moveData($tmp_pict_dir_s,$pict_dir_s);
//現在のデータ登録数を取得
$sql_max = "SELECT max(id) FROM inspection_record;";
$res_max = pg_query($conn,$sql_max);
$row_max = pg_fetch_array($res_max,0);
$id = $row_max[0];
//承認用URLの作成
$ok_url = "https://penta-02.ptgw.net/geye/data_update.php?id=" .$id ."&request=1";
//否認用URLの作成
$ng_url = "https://penta-02.ptgw.net/geye/data_update.php?id=" .$id ."&request=2";
//■内部文字エンコーディングを設定
mb_internal_encoding("ISO-2022-JP");
//ヘッダー設定
$header = "From: " ."五洋立会申請" ."<www@penta-05.ptgw2.net>" ."\n";
$header .= "Reply-To: " ."五洋立会申請" ."<www@penta-05.ptgw2.net>" ."\n";
//$header.= "Cc: " .$send_to1 ."," .$send_to2 ."\n";
//$header.= "Bcc: " ."'blue.puny@gmail.com'" ."\n";
$header .= "Content-Type: text/html;charset=ISO-2022-JP" ."\n";
$header .= "X-Mailer: myphpMail ". phpversion(). "\n";
//件名設定
$Subject = mb_convert_encoding("【立会申請】","ISO-2022-JP","UTF-8");
//本文設定
$message = mb_convert_encoding("※このメールはシステム側から送信しています" ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("以下の内容で立会申請がされました。" ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("承認・差戻を選択してURLをクリックしてください。" ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("選択を誤ってしまった場合は、正しい方をクリックしなおしてください。" ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("[承認]" .$ok_url ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("[差戻]" .$ng_url ."<BR><BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("希望日時 ：" .date("Y年m月d日 H時i分" ,($_POST['scheduled_date_reg'])) ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("場所 ：" .$_POST['place_reg'] ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("工種 ：" .$_POST['construction_reg'] ."<BR>" ,"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("検査項目 ：" .$_POST['inspection_name_reg'] ."<BR>","ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("監理技術者：" .$_POST['supervision_engineer_reg'],"ISO-2022-JP","UTF-8");
$message .= mb_convert_encoding("記事(備考)：" .$_POST['memo_reg'],"ISO-2022-JP","UTF-8");
$message = wordwrap($message, 70);
//送信する
if(mb_send_mail($_POST['send_address'], $Subject , $message,$header))
{
print "<script type='text/javascript'>";
print "alert('メールを送信しました');";
print "</script>";
}
}
//●新規申請確認画面で"いいえ"を選択した場合の処理
else if($_POST['sentaku_no'])
{
print "<script type='text/javascript'>";
print "alert('メールを送信しませんでした');";
print "</script>";
}
//---------------------------------------------------------------------------------------------
//データの一覧表の作成
//---------------------------------------------------------------------------------------------
//■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 "<form enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<TABLE BORDER=\"1\">";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='150'><FONT SIZE ='2' COLOR='white'>申請先メールアドレス</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='40' NAME='send_address' ></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='20'><FONT SIZE ='2' COLOR='white'>希望日</FONT></TH>";
print "<TD WIDTH='240'>";
print Pulldown_create_int(60,"date_y_",2020,2025,1,$date_y,0) ."年";
print Pulldown_create_int(60,"date_m_",1,13,1,$date_m,0) ."月";
print Pulldown_create_int(60,"date_d_",1,32,1,$date_d,0) ."日";
print "<BR>";
print Pulldown_create_int(60,"time_h_",0,24,1,$time_h,0) ."時";
print Pulldown_create_int(60,"time_m_",0,60,10,$time_m,0) ."分";
print "</TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>場所</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='40' NAME='place_reg' ></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>工種</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='40' NAME='construction_reg' ></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='130'><FONT SIZE ='2' COLOR='white'>検査項目</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='40' NAME='inspection_name_reg' ></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>監理技術者</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='40' NAME='supervision_engineer_reg' ></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>調書</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='file' multiple NAME='upfile_record[]' size='40'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>写真</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='file' multiple NAME='upfile_pict[]' size='40'></TD>";
print "</TR>";
print "<TR>";
print "<TH BGCOLOR='blue' WIDTH='100'><FONT SIZE ='2' COLOR='white'>記事</FONT></TH>";
print "<TD WIDTH='200'><INPUT TYPE='text' size='40' NAME='memo_reg' ></TD>";
print "</TR>";
print "</TABLE>";
print "<INPUT TYPE='submit' NAME='request' VALUE='申請' class='button'>";
print "</form>";
print "<BR>";
print "チェック項目の ";
print "<INPUT TYPE='submit' NAME='download' VALUE='ダウンロード' onclick='dlServlet()' 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' COLSPAN='3'><FONT SIZE ='2' COLOR='white'>CB</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='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='50'><FONT SIZE ='2' COLOR='white'>記事</FONT></TH>";
print "</TR>";
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]);
$pict = explode(",",$row[9]);
if($row[15] == 0)
{
$request_status = "承認待ち";
}
else if($row[15] == 1)
{
$request_status = "承認済";
}
else if($row[15] == 2)
{
$request_status = "<FONT color= 'red'>差戻";
$request_status .= "<BR>※条件を変えて<BR>再申請して下さい</FONT><BR>";
}
else
{
$request_status = "<FONT color= 'red'>メール送信失敗";
$request_status .= "<BR>※アドレスを確認し<BR>再申請して下さい</FONT><BR>";
}
$memo = $row[10];
$updatetime = $row[11];
$regdatetime = $row[12];
$chk_flag = ($row[13] === f) ? '--------':'確認済';
print "<TD><INPUT TYPE='checkbox' NAME='check' VALUE='$no' ></TD>"; //●チェックボックス
print "<TD>" .$no ."</TD>"; //●ファイルNo
print "<FORM enctype='multipart/form-data' action='$_SERVER[PHP_SELF]' method='post'>";
print "<TD><INPUT TYPE='submit' NAME='edit[]' VALUE='編集'>"; //●編集ボタン
print "<INPUT TYPE='hidden' NAME='edit_id' VALUE='" .$no ."'>";
print "</FORM>";
print "</TD>";
print "<TD><FONT SIZE ='2'>" .$request_status ."</FONT></TD>"; //●立会承認
print "<TD>" .$chk_flag ." </TD>"; //●確認状況
print "<TD><FONT SIZE ='2'>" .$scheduled_date ."</FONT></TD>"; //●希望日
print "<TD>" .$place ." </TD>"; //●場所
print "<TD>" .$construction ." </TD>"; //●検査項目
print "<TD>" .$inspection_name ." </TD>"; //●工種
print "<TD>" .$supervision_engineer ." </TD>"; //●監理技術者
print "<TD>" .$confirmer ." </TD>"; //●確認者
print "<TD>" .$implementation_date ."</TD>"; //●実施日
DlLinkMake(1,$record,$record_dir,'left'); //●調書(ダウンロードリンク表示)
DlLinkMake(2,$pict,$pict_dir,'left'); //●写真の表示
print "<TD>" .$memo ." </TD>"; //●記事
print "</TR>";
}
print "</TABLE>";
}
?>
</BODY>
</HTML>