array("name" => "工事ID", "object" => "const_id", "pattern" => "all"), "1" => array("name" => "工事名称", "object" => "const_name", "pattern" => "middle") ); $VIEW_LIST = array( "0" => array("head" => "工事ID", "object" => "const_id", "width" => "6%"), "1" => array("head" => "工事名称", "object" => "const_name", "width" => "16%"), "2" => array("head" => "工事開始日時", "object" => "start_at", "width" => "14%"), "3" => array("head" => "工事終了日時", "object" => "end_at", "width" => "14%"), "4" => array("head" => "備考", "object" => "remarks", "width" => "23%"), "5" => array("head" => "更新日時", "object" => "upddatetime", "width" => "14%"), ); $PAGE_LIMIT = 30; //=============================================== // HTML-HEAD- // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print ""; print ""; 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/18 KMK-Teraoka //================================================ $conn = pg_connect(" host = ". $HOST. " dbname = ". $DB. " user = ". $USER. " password= ". $PASS. " "); if (!$conn) { throw new Exception("データベースへの接続に失敗しました"); } //=============================================== // POST、GETパラメータの受け取り // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== if (DEBUG_MODE == 1) { extract($_POST); extract($_GET); Debug::writes($_POST); } $editId = isset($_POST["editId"]) ? htmlspecialchars($_POST["editId"]) : ""; if (strcmp($editId, "") == 0) { throw new Exception("工事IDが指定されていません"); } $selSearch = isset($_POST["selSearch"]) ? htmlspecialchars($_POST["selSearch"]) : ""; $txtSearchObj = isset($_POST["txtSearchObj"]) ? htmlspecialchars($_POST["txtSearchObj"]) : ""; $viewPage = isset($_POST["hPage"]) ? htmlspecialchars($_POST["hPage"]) : 1; //=============================================== // WHERE句の作成 // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== $whereObj = ""; $whereObj .= " WHERE const_id='". $editId. "'"; Debug::write($whereObj); //=============================================== // 見出し // 備考 ： Table内TableでBorderを細くする // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print "

"; print ""; print ""; print ""; print ""; print " "; print "工事参照"; print " "; print "

"; print "
"; //=============================================== // データの取得 // 備考 ： // 更新 ： 2012/10/19 KMK-Teraoka //=============================================== $selData = "SELECT * FROM ". $CONSTRUCTION_TABLE; if (strcmp($whereObj, "") != 0) { $selData .= $whereObj; } $selData .= ";"; Debug::write($selData); if (!($resData = pg_query($conn, $selData))) { throw new Exception("工事ID：[". $editId. "]のデータ取得に失敗しました
". $selData. "
". pg_last_error(). "
"); } $rowData = pg_fetch_array($resData, 0, PGSQL_ASSOC); //=============================================== // 管理メッセージの表示 // 備考 ： // 更新 ： 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: print $rowData[$VIEW_LIST[$iCount]["object"]]; break; case 1: print $rowData[$VIEW_LIST[$iCount]["object"]]; break; case 2: print $rowData[$VIEW_LIST[$iCount]["object"]]; break; case 3: print $rowData[$VIEW_LIST[$iCount]["object"]]; break; default: throw new Exception("リストに存在しません"); break; } print " "; print "

"; print "

"; print "
"; //=============================================== // 編集リンク // 備考 ： // 更新 ： 2012/10/23 KMK-Teraoka //=============================================== print "

"; print "編集"; print ""; print ""; print ""; print ""; print "

"; print " | "; } catch(Exception $exc) { print ""; print "【スクリプトエラー】
"; print $exc->getMessage(). "
"; print ""; } //=============================================== // 一覧リンク // 備考 ： // 更新 ： 2012/10/19 KMK-Teraoka //=============================================== print "

"; print "一覧"; print ""; print ""; print ""; print "

"; print "
"; //=============================================== // Postgresql終了処理 // 備考 ： // 更新 ： 2012/10/19 KMK-Teraoka //=============================================== pg_close($conn); //=============================================== // HTML終了処理 // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print "

---

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