". $SCRIPT_TITLE. "

array("head" => "工事ID", "object" => "const_id", "type" => "0", "control" => "-"), "1" => array("head" => "工事名称", "object" => "const_name", "type" => "1", "control" => "txtConstName"), "2" => array("head" => "工事開始日時", "object" => "start_at", "type" => "2", "control" => "txtStartAt"), "3" => array("head" => "工事終了日時", "object" => "end_at", "type" => "2", "control" => "txtEndAt"), "4" => array("head" => "備考", "object" => "remarks", "type" => "1", "control" => "txtRemarks"), "5" => array("head" => "更新日時", "object" => "upddatetime", "type" => "3", "control" => "-"), ); //=============================================== // HTML-HEAD- // 備考： // 更新： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print ""; print "". $SCRIPT_TITLE. ""; print ""; //=============================================== // HTML-BODY部開始- // 備考： // 更新： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print "". $SCRIPT_TITLE. "
"; print "【". $PENTA_OCEAN. "】"; print ""; print ""; print ""; print "

"; try { //================================================ // データベース接続 // 備考： // 更新： 2012/10/19 KMK-Teraoka //================================================ $conn = pg_connect(" host = ". $HOST. " dbname = ". $DB. " user = ". $USER. " password= ". $PASS. " "); if (!$conn) { throw new Exception("データベースへの接続に失敗しました"); } //=============================================== // POST、GETパラメータの受け取り // 備考： // 更新： 2012/10/19 KMK-Teraoka //=============================================== if (DEBUG_MODE == 1) { extract($_POST); extract($_GET); Debug::writes($_POST); } $selSearch = isset($_POST["selSearch"]) ? htmlspecialchars($_POST["selSearch"]) : ""; $txtSearchObj = isset($_POST["txtSearchObj"]) ? htmlspecialchars($_POST["txtSearchObj"]) : ""; $viewPage = isset($_POST["hPage"]) ? htmlspecialchars($_POST["hPage"]) : 1; $btnUpdate = isset($_POST["btnUpdate"]) ? htmlspecialchars($_POST["btnUpdate"]) : ""; if (strcmp($btnUpdate, "確認") == 0) { $txtConstName = isset($_POST["txtConstName"]) ? htmlspecialchars($_POST["txtConstName"]) : ""; if (strcmp($txtConstName, "") == 0) { throw new Exception("工事名が入力されていません"); } $today = getdate(); $txtStartAt_y = isset($_POST["txtStartAt_y"]) ? htmlspecialchars($_POST["txtStartAt_y"]) : ""; if (strcmp($txtStartAt_y, "") == 0) { $txtStartAt_y = $today["year"]; } $txtStartAt_m = isset($_POST["txtStartAt_m"]) ? htmlspecialchars($_POST["txtStartAt_m"]) : ""; if (strcmp($txtStartAt_m, "") == 0) { $txtStartAt_m = $today["mon"]; } $txtStartAt_d = isset($_POST["txtStartAt_d"]) ? htmlspecialchars($_POST["txtStartAt_d"]) : ""; if (strcmp($txtStartAt_d, "") == 0) { $txtStartAt_d = $today["mday"]; } $txtStartAt_h = isset($_POST["txtStartAt_h"]) ? htmlspecialchars($_POST["txtStartAt_h"]) : "00"; $txtStartAt_i = isset($_POST["txtStartAt_i"]) ? htmlspecialchars($_POST["txtStartAt_i"]) : "00"; $txtStartAt_s = isset($_POST["txtStartAt_s"]) ? htmlspecialchars($_POST["txtStartAt_s"]) : "00"; $txtEndAt_y = isset($_POST["txtEndAt_y"]) ? htmlspecialchars($_POST["txtEndAt_y"]) : ""; if (strcmp($txtEndAt_y, "") == 0) { $txtEndAt_y = $today["year"]; } $txtEndAt_m = isset($_POST["txtEndAt_m"]) ? htmlspecialchars($_POST["txtEndAt_m"]) : $today["mon"]; if (strcmp($txtEndAt_m, "") == 0) { $txtEndAt_m = $today["mon"]; } $txtEndAt_d = isset($_POST["txtEndAt_d"]) ? htmlspecialchars($_POST["txtEndAt_d"]) : $today["mday"]; if (strcmp($txtEndAt_d, "") == 0) { $txtEndAt_d = $today["mday"]; } $txtEndAt_h = isset($_POST["txtEndAt_h"]) ? htmlspecialchars($_POST["txtEndAt_h"]) : "00"; $txtEndAt_i = isset($_POST["txtEndAt_i"]) ? htmlspecialchars($_POST["txtEndAt_i"]) : "00"; $txtEndAt_s = isset($_POST["txtEndAt_s"]) ? htmlspecialchars($_POST["txtEndAt_s"]) : "00"; $txtRemarks = isset($_POST["txtRemarks"]) ? htmlspecialchars($_POST["txtRemarks"]) : ""; $confMode = 1; $confValue = array( "const_id" => "", "const_name" => $txtConstName, "start_at" => sprintf("%04d", $txtStartAt_y). "-". sprintf("%02d", $txtStartAt_m). "-". sprintf("%02d", $txtStartAt_d). " ". sprintf("%02d", $txtStartAt_h). ":". sprintf("%02d", $txtStartAt_i). ":". sprintf("%02d", $txtStartAt_s), "end_at" => sprintf("%04d", $txtEndAt_y). "-". sprintf("%02d", $txtEndAt_m). "-". sprintf("%02d", $txtEndAt_d). " ". sprintf("%02d", $txtEndAt_h). ":". sprintf("%02d", $txtEndAt_i). ":". sprintf("%02d", $txtEndAt_s), "remarks" => $txtRemarks, "upddatetime" => "" ); $mgrMsg = "下記内容で更新します
"; } else if (strcmp($btnUpdate, "登録") == 0) { $regConstName = isset($_POST["regConstName"]) ? htmlspecialchars($_POST["regConstName"]) : ""; $regStartAt = isset($_POST["regStartAt"]) ? htmlspecialchars($_POST["regStartAt"]) : ""; $regEndAt = isset($_POST["regEndAt"]) ? htmlspecialchars($_POST["regEndAt"]) : ""; $regRemarks = isset($_POST["regRemarks"]) ? htmlspecialchars($_POST["regRemarks"]) : ""; $insData = "INSERT INTO ". $CONSTRUCTION_TABLE. " ("; $insData .= "const_name, start_at, end_at, remarks, upddatetime, regdatetime"; $insData .= ") VALUES ("; $insData .= "'". $regConstName. "', '". $regStartAt. "', '". $regEndAt. "', '". $regRemarks. "', current_timestamp, current_timestamp"; $insData .= ")"; $insData .= ";"; Debug::write($insData); if (!($resData = pg_query($conn, $insData))) { throw new Exception("データの登録に失敗しました
". $insData. "
". pg_last_error(). "
"); } $confMode = 2; $selInsData = "SELECT * FROM ". $CONSTRUCTION_TABLE. ""; $selInsData .= " ORDER BY const_id DESC"; $selInsData .= " LIMIT 1"; $selInsData .= ";"; if (!($resInsData = pg_query($conn, $selInsData))) { throw new Exception("最新データの取得に失敗しました
". $selInsData. "
". pg_last_error(). "
"); } $rowInsData = pg_fetch_array($resInsData, 0, PGSQL_ASSOC); $mgrMsg = "工事ID[". $rowInsData["const_id"]. "]：工事登録を行いました
"; } //=============================================== // 見出し // 備考： Table内TableでBorderを細くする // 更新： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print "

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

"; print "工事登録"; print "

"; print "

"; print "
"; //=============================================== // 管理メッセージの表示 // 備考： // 更新： 2012/10/18 KMK-Teraoka //=============================================== print ""; print $mgrMsg; print ""; //=============================================== // 一覧の表示 // 備考： // 更新： 2012/10/18 KMK-Teraoka //=============================================== print "

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

"; print ""; for($iCount = 0; $iCount < count($VIEW_LIST); $iCount++) { print ""; print ""; print ""; print ""; } print "

"; print $VIEW_LIST[$iCount]["head"]; print "

"; switch($VIEW_LIST[$iCount]["type"]) { case 0: if ($confMode == 2) { print $rowInsData[$VIEW_LIST[$iCount]["object"]]; } else { print "-"; } break; case 1: if ($confMode == 1) { print $confValue[$VIEW_LIST[$iCount]["object"]]; } else if ($confMode == 2) { print $rowInsData[$VIEW_LIST[$iCount]["object"]]; } else { print ""; } break; case 2: if ($confMode == 1) { print $confValue[$VIEW_LIST[$iCount]["object"]]; } else if ($confMode == 2) { print $rowInsData[$VIEW_LIST[$iCount]["object"]]; } else { print ""; print "-"; print ""; print "-"; print ""; print " "; print ""; print ":"; print ""; print ":"; print ""; } break; case 3: if ($confMode == 2) { print $rowInsData[$VIEW_LIST[$iCount]["object"]]; } else { print "-"; } break; default: throw new Exception("リストに存在しません"); break; } print "

"; print "

"; //=============================================== // 確認、登録ボタン // 備考： // 更新： 2012/10/19 KMK-Teraoka //=============================================== if ($confMode == 1) { print ""; print " "; print ""; print ""; print ""; print ""; print ""; print "
"; } else if ($confMode == 2) { } else { print ""; print "
"; } print ""; print ""; print ""; print "

"; print "
"; } catch(Exception $exe) { print ""; print "【スクリプトエラー】
"; print $exe->getMessage(). "
"; print ""; } //=============================================== // 一覧へ戻るリンク // 備考： // 更新： 2012/10/19 KMK-Teraoka //=============================================== print ""; //=============================================== // Postgresql終了処理 // 備考： // 更新： 2012/10/19 KMK-Teraoka //=============================================== pg_close($conn); //=============================================== // HTML終了処理 // 備考： // 更新： 2012/10/19 KMK-Teraoka //=============================================== print "

"; print ""; print ""; print ""; print ""; print $TAIL_PENTA_OCEAN; print ""; print ""; print ""; print ""; print ""; print ""; ?>