ansysconstructions

File "constructions_regist.php"

Full path: /www/ansys/constructions/constructions_regist.php
File size: 14.31 KiB (14655 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?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/10/19 KMK-Teraoka
//===============================================
define("DEBUG_MODE", "0");
Debug::setMode(DEBUG_MODE);
if (DEBUG_MODE == 1)
{
	Stopwatch::start();
}

//===============================================
//	CommonUtilities
//	備考		：	
//	更新		：	2012/10/19 KMK-Teraoka
//===============================================
$PENTA_OCEAN = "五洋建設株式会社";
$TAIL_PENTA_OCEAN = "penta-ocean";
$SCRIPT_TITLE = "アンドロイドシステム 工事管理";
$LIST_FORM = "./constructions_list.php";
$EDIT_FORM = "./constructions_edit.php";
$VIEW_FORM = "./constructions_view.php";
$DELETE_FORM = "./constructions_delete.php";
$CREATE_FORM = "./constructions_create.php";
$HOST = "192.168.100.153";
$DB = "ansys";
$USER = "postgres";
$PASS = "am#71ZJ*";
$CONSTRUCTION_TABLE = "apc_common.constructions";

$VIEW_LIST = array(
	"0"		=>	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 "<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/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 = "下記内容で更新します<br />";
	}
	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("データの登録に失敗しました<br />". $insData. "<br />". pg_last_error(). "<br />");
		}
		
		$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("最新データの取得に失敗しました<br />". $selInsData. "<br />". pg_last_error(). "<br />");
		}
		$rowInsData = pg_fetch_array($resInsData, 0, PGSQL_ASSOC);
		$mgrMsg = "工事ID[". $rowInsData["const_id"]. "]：工事登録を行いました<br />";
	}
	
	//===============================================
	//	見出し
	//	備考		：	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/18 KMK-Teraoka
	//===============================================
	print "<font color=\"#FF0000\">";
	print $mgrMsg;
	print "</font>";
	
	//===============================================
	//	一覧の表示
	//	備考		：	
	//	更新		：	2012/10/18 KMK-Teraoka
	//===============================================
	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:
				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 "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "\" value=\"\" style=\"width:100%\" id=\"text\">";
				}
				break;
			case 2:
				if ($confMode == 1)
				{
					print $confValue[$VIEW_LIST[$iCount]["object"]];
				}
				else if ($confMode == 2)
				{
					print $rowInsData[$VIEW_LIST[$iCount]["object"]];
				}
				else
				{
					print "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "_y\" value=\"\" style=\"width:34px;ime-mode:inactive\" maxlength=\"4\" id=\"text\">";
					print "-";
					print "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "_m\" value=\"\" style=\"width:21px;ime-mode:inactive\" maxlength=\"2\" id=\"text\">";
					print "-";
					print "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "_d\" value=\"\" style=\"width:21px;ime-mode:inactive\" maxlength=\"2\" id=\"text\">";
					print "&nbsp;";
					print "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "_h\" value=\"\" style=\"width:21px;ime-mode:inactive\" maxlength=\"2\" id=\"text\">";
					print ":";
					print "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "_i\" value=\"\" style=\"width:21px;ime-mode:inactive\" maxlength=\"2\" id=\"text\">";
					print ":";
					print "<input type=\"text\" name=\"". $VIEW_LIST[$iCount]["control"]. "_s\" value=\"\" style=\"width:21px;ime-mode:inactive\" maxlength=\"2\" id=\"text\">";
				}
				break;
			case 3:
				if ($confMode == 2)
				{
					print $rowInsData[$VIEW_LIST[$iCount]["object"]];
				}
				else
				{
					print "-";
				}
				break;
			default:
				throw new Exception("リストに存在しません");
				break;
		}
		print "</td>";
		print "</tr>";
	}
	print "</table>";
	print "</td>";
	print "</tr>";
	print "</table>";
	
	//===============================================
	//	確認、登録ボタン
	//	備考		：	
	//	更新		：	2012/10/19 KMK-Teraoka
	//===============================================
	if ($confMode == 1)
	{
		print "<input type=\"submit\" name=\"btnUpdate\" value=\"登録\" style=\"width:60px\" id=\"submit_button\">";
		print "&nbsp;";
		print "<input type=\"submit\" name=\"btnUpdate\" value=\"修正\" style=\"width:60px\" id=\"submit_button\">";
		
		print "<input type=\"hidden\" name=\"regConstName\" value=\"". $confValue["const_name"]. "\">";
		print "<input type=\"hidden\" name=\"regStartAt\" value=\"". $confValue["start_at"]. "\">";
		print "<input type=\"hidden\" name=\"regEndAt\" value=\"". $confValue["end_at"]. "\">";
		print "<input type=\"hidden\" name=\"regRemarks\" value=\"". $confValue["remarks"]. "\">";
		print "<br />";
	}
	else if ($confMode == 2)
	{
		
	}
	else
	{
		print "<input type=\"submit\" name=\"btnUpdate\" value=\"確認\" style=\"width:60px\" id=\"submit_button\">";
		print "<br />";
	}
	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 $exe)
{
	print "<font color=\"#FF0000\">";
	print "【スクリプトエラー】<br />";
	print $exe->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>";

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

//===============================================
//	HTML終了処理
//	備考		：	
//	更新		：	2012/10/19 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>";
?>

PHP File Manager