". $SCRIPT_TITLE. "

array("name" => "アプリID", "object" => "app_id", "pattern" => "all"), "1" => array("name" => "アプリ名", "object" => "app_name", "pattern" => "middle"), "2" => array("name" => "アプリVer.", "object" => "app_version", "pattern" => "middle"), "3" => array("name" => "GCM利用", "object" => "use_gcm", "pattern" => "all"), "4" => array("name" => "備考", "object" => "remarks", "pattern" => "middle") ); $VIEW_LIST = array( "0" => array("head" => "アプリID", "object" => "app_id", "type" => "0", "control" => "-", "defval" => ""), "1" => array("head" => "アプリ名", "object" => "app_name", "type" => "1", "control" => "txtAppName", "defval" => ""), "2" => array("head" => "アプリVer.", "object" => "app_version", "type" => "1", "control" => "txtAppVersion", "defval" => "1.0"), "3" => array("head" => "GCM利用", "object" => "use_gcm", "type" => "4", "control" => "chkUseGcm", "defval" => ""), "4" => array("head" => "備考", "object" => "remarks", "type" => "1", "control" => "txtRemarks", "defval" => ""), "5" => array("head" => "更新日時", "object" => "upddatetime", "type" => "0", "control" => "-", "defval" => ""), ); $PAGE_LIMIT = 30; //=============================================== // HTML-HEAD- // 備考： // 更新： 2012/11/02 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print ""; print "". $SCRIPT_TITLE. ""; print ""; //=============================================== // HTML-BODY部開始- // 備考： // 更新： 2012/11/02 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print "". $SCRIPT_TITLE. "
"; print "【". $PENTA_OCEAN. "】"; print ""; print ""; print ""; print "

"; try { //================================================ // データベース接続 // 備考： // 更新： 2012/11/02 KMK-Teraoka //================================================ $conn = pg_connect(" host = ". $HOST. " dbname = ". $DB. " user = ". $USER. " password= ". $PASS. " "); if (!$conn) { throw new Exception("データベースへの接続に失敗しました"); } //=============================================== // POST、GETパラメータの受け取り // 備考： // 更新： 2012/11/02 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) { $txtAppName = isset($_POST["txtAppName"]) ? htmlspecialchars($_POST["txtAppName"]) : ""; if (strcmp($txtAppName, "") == 0) { throw new Exception("アプリ名が入力されていません"); } $txtAppVersion = isset($_POST["txtAppVersion"]) ? htmlspecialchars($_POST["txtAppVersion"]) : ""; if (strcmp($txtAppVersion, "") == 0) { $txtAppVersion = "1.0"; } $chkUseGcm = isset($_POST["chkUseGcm"]) ? htmlspecialchars($_POST["chkUseGcm"]) : "f"; if (strcmp($chkUseGcm, "1") == 0) { $chkUseGcm = "t"; } $txtRemarks = isset($_POST["txtRemarks"]) ? htmlspecialchars($_POST["txtRemarks"]) : ""; $confMode = 1; $confValue = array( "app_id" => "", "app_name" => $txtAppName, "app_version" => $txtAppVersion, "use_gcm" => $chkUseGcm, "remarks" => $txtRemarks, "upddatetime" => "" ); $mgrMsg = "下記内容で更新します
"; } else if (strcmp($btnUpdate, "登録") == 0) { $regAppName = isset($_POST["regAppName"]) ? htmlspecialchars($_POST["regAppName"]) : ""; $regAppVersion = isset($_POST["regAppVersion"]) ? htmlspecialchars($_POST["regAppVersion"]) : ""; $regUseGcm = isset($_POST["regUseGcm"]) ? htmlspecialchars($_POST["regUseGcm"]) : ""; $regRemarks = isset($_POST["regRemarks"]) ? htmlspecialchars($_POST["regRemarks"]) : ""; $insData = "INSERT INTO ". $APPLICATIONS_TABLE. " ("; $insData .= "app_name, app_version, use_gcm, remarks, upddatetime, regdatetime"; $insData .= ") VALUES ("; $insData .= "'". $regAppName. "', '". $regAppVersion. "', '". $regUseGcm. "', '". $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 ". $APPLICATIONS_TABLE. ""; $selInsData .= " ORDER BY app_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["app_id"]. "]：アプリ登録を行いました
"; } //=============================================== // 見出し // 備考： Table内TableでBorderを細くする // 更新： 2012/11/02 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print "

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

"; print "アプリケーション登録"; print "

"; print "

"; print "
"; //=============================================== // 管理メッセージの表示 // 備考： // 更新： 2012/11/02 KMK-Teraoka //=============================================== print ""; print $mgrMsg; print ""; //=============================================== // 一覧の表示 // 備考： // 更新： 2012/11/02 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; default: throw new Exception("リストに存在しません"); break; } print "

"; print "

"; //=============================================== // 確認、登録ボタン // 備考： // 更新： 2012/11/02 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/11/02 KMK-Teraoka //=============================================== print ""; //=============================================== // Postgresql終了処理 // 備考： // 更新： 2012/11/02 KMK-Teraoka //=============================================== pg_close($conn); //=============================================== // HTML終了処理 // 備考： // 更新： 2012/11/02 KMK-Teraoka //=============================================== print "

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