";
print "";
print "";
print "";
print "";
print "";
print "";
print "品質項目入力";
print "";
print "";
print "";
try
{
//================================================
// データベース接続
// 備考 ：
// 更新 ： 2012/11/27 KMK-Teraoka
//================================================
$conn = pg_connect("
host = ". $HOST. "
dbname = ". $DB. "
user = ". $USER. "
password= ". $PASS. "
");
if (!$conn)
{
throw new Exception("データベースへの接続に失敗しました");
}
//===============================================
// POST、GETパラメータの受け取り
// 備考 ：
// 更新 ： 2012/11/27 KMK-Teraoka
//===============================================
if (DEBUG_MODE == 1)
{
extract($_POST);
extract($_GET);
Debug::writes($_POST);
}
$btnRegist = isset($_POST["btnRegist"]) ? htmlspecialchars($_POST["btnRegist"]) : "";
if (strcmp($btnRegist, "登録") == 0)
{
$txtYmd = isset($_POST["txtYmd"]) ? htmlspecialchars($_POST["txtYmd"]) : "";
if (mb_strlen($txtYmd) == 8)
{
$dateY = substr($txtYmd, 0, 4);
$dateM = substr($txtYmd, 4, 2);
$dateD = substr($txtYmd, 6, 2);
}
else
{
throw new Exception("年月日はYYYYmmddの型式で入力して下さい");
}
$txtHi = isset($_POST["txtHi"]) ? htmlspecialchars($_POST["txtHi"]) : "";
if (mb_strlen($txtHi) == 4)
{
$dateH = substr($txtHi, 0, 2);
$dateI = substr($txtHi, 2, 2);
}
else
{
throw new Exception("時分はHHiiの型式で入力して下さい");
}
$txtCarNumber = isset($_POST["txtCarNumber"]) ? htmlspecialchars($_POST["txtCarNumber"]) : "";
if (strcmp($txtCarNumber, "") == 0)
throw new Exception("車番が指定されていません");
$txtSlump = isset($_POST["txtSlump"]) ? htmlspecialchars($_POST["txtSlump"]) : "";
$txtAmountAir = isset($_POST["txtAmountAir"]) ? htmlspecialchars($_POST["txtAmountAir"]) : "";
$txtUnitWater = isset($_POST["txtUnitWater"]) ? htmlspecialchars($_POST["txtUnitWater"]) : "";
$txtConcreteTemp = isset($_POST["txtConcreteTemp"]) ? htmlspecialchars($_POST["txtConcreteTemp"]) : "";
$txtTemperature = isset($_POST["txtTemperature"]) ? htmlspecialchars($_POST["txtTemperature"]) : "";
$txtChlorideIon = isset($_POST["txtChlorideIon"]) ? htmlspecialchars($_POST["txtChlorideIon"]) : "";
// データベース登録
$insConcData = "INSERT INTO qgis.quality_of_concrete";
$insConcData .= "(const_id, upddatetime, regdatetime, iptdatetime, car_number, slump, amount_air, unit_water, concrete_temp, temperature, chloride_ion)";
$insConcData .= " VALUES (";
$insConcData .= "'". $CONSTRUCTION_ID. "'";
$insConcData .= ", current_timestamp";
$insConcData .= ", current_timestamp";
$insConcData .= ", '". $dateY. "-". $dateM. "-". $dateD. " ". $dateH. ":". $dateI. ":00". "'";
$insConcData .= ", '". $txtCarNumber. "'";
$insConcData .= ", '". $txtSlump. "'";
$insConcData .= ", '". $txtAmountAir. "'";
$insConcData .= ", '". $txtUnitWater. "'";
$insConcData .= ", '". $txtConcreteTemp. "'";
$insConcData .= ", '". $txtTemperature. "'";
$insConcData .= ", '". $txtChlorideIon. "'";
$insConcData .= ");";
//print $insConcData;
$resConcData = pg_query($conn, $insConcData);
print "登録しました";
}
if (strcmp($txtYmd, "") == 0)
$txtYmd = date("Ymd");
if (strcmp($txtHi, "") == 0)
$txtHi = date("Hi");
if (strcmp($txtSlump, "") == 0)
$txtSlump = "";
if (strcmp($txtAmountAir, "") == 0)
$txtAmountAir = "";
if (strcmp($txtUnitWater, "") == 0)
$txtUnitWater = "";
if (strcmp($txtConcreteTemp, "") == 0)
$txtConcreteTemp = "";
if (strcmp($txtTemperature, "") == 0)
$txtTemperature = "";
if (strcmp($txtChlorideIon, "") == 0)
$txtChlorideIon = "";
//===============================================
// 表示部分
// 備考 ：
// 更新 ： 2013/08/01 KMK-Teraoka
//===============================================
print "品質管理項目";
print "
";
print "";
print "";
}
catch(Exception $exc)
{
print "";
print "【スクリプトエラー】
";
print $exc->getMessage(). "
";
print "";
print "
";
print "戻る";
}
//===============================================
// Postgresql終了処理
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
pg_close($conn);
print "";
print "