". $SCRIPT_TITLE. "

array("name" => "警告音声ID", "object" => "msg_id", "pattern" => "all"), "1" => array("name" => "警告音声情報", "object" => "msg_info", "pattern" => "middle"), "2" => array("name" => "ファイル名称", "object" => "msg_file_name", "pattern" => "middle"), "3" => array("name" => "備考", "object" => "remarks", "pattern" => "middle"), ); $VIEW_LIST = array( "0" => array("head" => "警告音声ID", "object" => "msg_id", "type" => "0", "control" => "-"), // "1" => array("head" => "工事ID", "object" => "const_id", "type" => "1", "control" => "txtConstId"), // "2" => array("head" => "アプリID", "object" => "app_id", "type" => "1", "control" => "txtAppId"), "1" => array("head" => "警告音声情報", "object" => "msg_info", "type" => "1", "control" => "txtMsgInfo"), "2" => array("head" => "ファイル名称", "object" => "msg_file_name", "type" => "1", "control" => "txtMsgFileName"), "3" => array("head" => "アップロードファイル", "object" => "local_file", "type" => "5", "control" => "fileMsgOgg"), "4" => array("head" => "備考", "object" => "remarks", "type" => "1", "control" => "txtRemarks"), "5" => array("head" => "更新日時", "object" => "upddatetime", "type" => "0", "control" => "-"), ); $PAGE_LIMIT = 30; $TMP_DIR = "./msg_tmp"; $UPLOAD_DIR = "./msg_files"; $CONST_ID = "1"; $APP_ID = "18"; //=============================================== // 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/11/06 KMK-Teraoka //=============================================== if (DEBUG_MODE == 1) { extract($_POST); extract($_GET); extract($_FILES); Debug::writes($_POST, $_FILES); } $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) { $txtMsgInfo = isset($_POST["txtMsgInfo"]) ? htmlspecialchars($_POST["txtMsgInfo"]) : ""; $txtMsgFileName = isset($_POST["txtMsgFileName"]) ? htmlspecialchars($_POST["txtMsgFileName"]) : ""; if (strcmp($txtMsgFileName, "") == 0) { $txtMsgFileName = $fileName; } else if (!preg_match("/\\.ogg$/i", $txtMsgFileName)) { $txtMsgFileName .= ".ogg"; } if (file_exists($UPLOAD_DIR. "/". $txtMsgFileName)) { $txtMsgFileName = str_replace(".ogg", "_". date("Ymd_His"). ".ogg", $txtMsgFileName); } $txtRemarks = isset($_POST["txtRemarks"]) ? htmlspecialchars($_POST["txtRemarks"]) : ""; //=============================================== // アップロードされたファイルを確認 // 一時保存ディレクトリへコピー // 備考： // 更新： 2012/11/06 KMK-Teraoka //=============================================== if ($_FILES["fileMsgOgg"]["error"] == 0) { $fileName = $_FILES["fileMsgOgg"]["name"]; if (file_exists($_FILES["fileMsgOgg"]["tmp_name"])) { if (preg_match("/\\.ogg$/i", $fileName)) { move_uploaded_file($_FILES["fileMsgOgg"]["tmp_name"], mb_convert_encoding($TMP_DIR. "/". $txtMsgFileName, "SJIS", "UTF-8")); chmod(mb_convert_encoding($TMP_DIR. "/". $txtMsgFileName, "SJIS", "UTF-8"), 0777); } else { throw new Exception("アップロード可能な警告音声のファイル形式は「ogg」のみです"); } } else { throw new Exception("アップロードに失敗しました"); } } else { throw new Exception("ファイルの指定がありません"); } $confMode = 1; $confValue = array( "id" => "", "msg_info" => $txtMsgInfo, "msg_file_name" => $txtMsgFileName, "local_file" => $_FILES["fileMsgOgg"]["name"], "remarks" => $txtRemarks, "upddatetime" => "" ); $mgrMsg = "下記内容で更新します
"; } else if (strcmp($btnUpdate, "登録") == 0) { $regMsgInfo = isset($_POST["regMsgInfo"]) ? htmlspecialchars($_POST["regMsgInfo"]) : ""; $regMsgFileName = isset($_POST["regMsgFileName"]) ? htmlspecialchars($_POST["regMsgFileName"]) : ""; $regRemarks = isset($_POST["regRemarks"]) ? htmlspecialchars($_POST["regRemarks"]) : ""; $insData = "INSERT INTO ". $MESSAGES_TABLE. " ("; $insData .= "const_id, app_id, msg_info, msg_file_name, remarks, upddatetime, regdatetime"; $insData .= ") VALUES ("; $insData .= "'". $CONST_ID. "','". $APP_ID. "', '". $regMsgInfo. "', '". $regMsgFileName. "', '". $regRemarks. "', current_timestamp, current_timestamp"; $insData .= ")"; $insData .= ";"; Debug::write($insData); if (!($resData = pg_query($conn, $insData))) { throw new Exception("データの登録に失敗しました
". $insData. "
". pg_last_error(). "
"); } //=============================================== // アップロードファイルを一時保存ディレクトリから移動 // 備考： // 更新： 2012/11/06 KMK-Teraoka //=============================================== Debug::write($TMP_DIR. "/". $regMsgFileName, $UPLOAD_DIR. "/". $regMsgFileName); if(!rename(mb_convert_encoding($TMP_DIR. "/". $regMsgFileName, "SJIS", "UTF-8"), mb_convert_encoding($UPLOAD_DIR. "/". $regMsgFileName, "SJIS", "UTF-8"))) { throw new Exception("ファイルの移動に失敗しました"); } $confMode = 2; $selInsData = "SELECT * FROM ". $MESSAGES_TABLE. ""; $selInsData .= " ORDER BY msg_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["msg_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; case 4: if ($confMode == 1) { print $confValue[$VIEW_LIST[$iCount]["object"]]; } else if ($confMode == 2) { print $rowInsData[$VIEW_LIST[$iCount]["object"]]; } else { print ""; } break; case 5: if ($confMode == 1) { print $confValue[$VIEW_LIST[$iCount]["object"]]; } else if ($confMode == 2) { print "-"; } 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 "
"; } 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 ""; ?>