File "applications_delete.php"
Full path: /www/ansys/applications/applications_delete.php
File size: 10.36 KiB (10607 bytes)
MIME-type: text/x-php
Charset: utf-8
<?php
//-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
// 自動でクラスを参照する
// 関数名 ： __autoload()
// 備考 ： 参照先は./class/XXX.phpとする
// 更新 ： 2012/10/19 KMK-Teraoka
//-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
function __autoload($className)
{
$fPath = "./class/" . str_replace("_", "/", $className) . ".php";
require_once $fPath;
}
//===============================================
// DEBUG_MODE
// 備考 ：
// 更新 ： 2012/11/02 KMK-Teraoka
//===============================================
define("DEBUG_MODE", "0");
Debug::setMode(DEBUG_MODE);
if (DEBUG_MODE == 1)
{
Stopwatch::start();
}
//===============================================
// CommonUtilities
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
$PENTA_OCEAN = "五洋建設株式会社";
$TAIL_PENTA_OCEAN = "penta-ocean";
$SCRIPT_TITLE = "アンドロイドシステム アプリケーション管理";
$TOP_FORM = "../index.php";
$REGIST_FORM = "./applications_regist.php";
$LIST_FORM = "./applications_list.php";
$EDIT_FORM = "./applications_edit.php";
$VIEW_FORM = "./applications_view.php";
$DELETE_FORM = "./applications_delete.php";
$HOST = "192.168.100.153";
$DB = "ansys";
$USER = "postgres";
$PASS = "am#71ZJ*";
$APPLICATIONS_TABLE = "apc_common.applications";
$WHERE_PATTERN = array(
"0" => 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" => "-"),
"1" => array("head" => "アプリ名", "object" => "app_name", "type" => "1", "control" => "txtAppName"),
"2" => array("head" => "アプリVer.", "object" => "app_version", "type" => "1", "control" => "txtAppVersion"),
"3" => array("head" => "GCM利用", "object" => "use_gcm", "type" => "4", "control" => "chkUseGcm"),
"4" => array("head" => "備考", "object" => "remarks", "type" => "1", "control" => "txtRemarks"),
"5" => array("head" => "更新日時", "object" => "upddatetime", "type" => "0", "control" => "-"),
);
$PAGE_LIMIT = 30;
//===============================================
// HTML-HEAD-
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<html>";
print "<head>";
print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "<title>". $SCRIPT_TITLE. "</title>";
print "</head>";
//===============================================
// HTML-BODY部開始-
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<body>";
print "<center>";
print "<font size=\"3\">";
print "<b>";
print "". $SCRIPT_TITLE. "<br>";
print "【". $PENTA_OCEAN. "】";
print "</b>";
print "</font>";
print "</center>";
print "<hr />";
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;
$btnDelete = isset($_POST["btnDelete"]) ? htmlspecialchars($_POST["btnDelete"]) : "";
if (strcmp($btnDelete, "削除") == 0)
{
$delData = "DELETE FROM ". $APPLICATIONS_TABLE. "";
$delData .= " WHERE app_id='". $editId. "'";
$delData .= ";";
Debug::write($delData);
if (!($resData = pg_query($conn, $delData)))
{
throw new Exception("アプリID：[". $editId. "]のデータ削除に失敗しました<br />". $delData. "<br />". pg_last_error(). "<br />");
}
$delMode = 1;
$mgrMsg = "アプリID：[". $editId. "]のデータを削除しました<br />";
}
else
{
$mgrMsg = "下記のアプリデータを削除します<br />";
}
//===============================================
// WHERE句の作成
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
$whereObj = "";
$whereObj .= " WHERE app_id='". $editId. "'";
Debug::write($whereObj);
//===============================================
// 見出し
// 備考 ： Table内TableでBorderを細くする
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<table width=\"100%\" border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr>";
print "<td>";
print "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\">";
print "<tr bgcolor=\"#99CCFF\">";
print "<td align=\"left\">";
print "アプリケーション削除";
print "</td>";
print "</tr>";
print "</table>";
print "</td>";
print "</tr>";
print "</table>";
print "<br />";
//===============================================
// データの取得
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
if ($delMode != 1)
{
$selData = "SELECT * FROM ". $APPLICATIONS_TABLE;
if (strcmp($whereObj, "") != 0)
{
$selData .= $whereObj;
}
$selData .= ";";
Debug::write($selData);
if (!($resData = pg_query($conn, $selData)))
{
throw new Exception("アプリID：[". $editId. "]のデータ取得に失敗しました<br />". $selData. "<br />". pg_last_error(). "<br />");
}
$rowData = pg_fetch_array($resData, 0, PGSQL_ASSOC);
}
//===============================================
// 管理メッセージの表示
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<font color=\"#FF0000\">";
print $mgrMsg;
print "</font>";
//===============================================
// 一覧の表示
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
if ($delMode != 1)
{
print "<form action=\"". $_SERVER['PHP_SELF']. "\" method=\"post\" style=\"display:inline\">";
print "<table width=\"45%\" border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr>";
print "<td>";
print "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\">";
for($iCount = 0; $iCount < count($VIEW_LIST); $iCount++)
{
print "<tr bgcolor=\"#FFFFFF\" align=\"left\">";
print "<td bgcolor=\"#99CCFF\" style=\"width:30%;height:25px;\">";
print $VIEW_LIST[$iCount]["head"];
print "</td>";
print "<td bgcolor=\"#FFFFFF\" style=\"width:70%\">";
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;
case 4:
print $rowData[$VIEW_LIST[$iCount]["object"]];
break;
default:
throw new Exception("リストに存在しません");
break;
}
print "</td>";
print "</tr>";
}
print "</table>";
print "</td>";
print "</tr>";
print "</table>";
}
//===============================================
// 確認、登録ボタン
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
if ($delMode != 1)
{
print "<input type=\"submit\" name=\"btnDelete\" value=\"削除\" style=\"width:60px\" id=\"submit_button\">";
print "<br />";
print "<input type=\"hidden\" name=\"editId\" value=\"". $editId. "\">";
print "<input type=\"hidden\" name=\"selSearch\" value=\"". $selSearch. "\">";
print "<input type=\"hidden\" name=\"txtSearchObj\" value=\"". $txtSearchObj. "\">";
print "<input type=\"hidden\" name=\"hPage\" value=\"". $viewPage. "\">";
print "</form>";
print "<br />";
}
}
catch(Exception $exc)
{
print "<font color=\"#FF0000\">";
print "【スクリプトエラー】<br />";
print $exc->getMessage(). "<br />";
print "</font>";
}
//===============================================
// 一覧リンク
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
print "<form name=\"listForm\" method=\"post\" action=\"". $LIST_FORM. "\" style=\"display:inline\">";
print "<a href=\"javascript:listForm.submit()\">一覧</a>";
print "<input type=\"hidden\" name=\"selSearch\" value=\"". $selSearch. "\">";
print "<input type=\"hidden\" name=\"txtSearchObj\" value=\"". $txtSearchObj. "\">";
print "<input type=\"hidden\" name=\"hPage\" value=\"". $viewPage. "\">";
print "</form>";
print "<br />";
//===============================================
// Postgresql終了処理
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
pg_close($conn);
//===============================================
// HTML終了処理
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<hr />";
print "<font size=\"3\" color=\"#000000\" face=\"Arial\">";
print "<center>";
print "<b>";
print "<i>";
print $TAIL_PENTA_OCEAN;
print "</i>";
print "</b>";
print "</center>";
print "</font>";
print "</body>";
print "</html>";
?>