File "recv_d.php"

Full path: /www/haneda/qr/recv/recv_d.php
File size: 6.59 KiB (6746 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", "1");
cDebug::setMode(DEBUG_MODE);
if (DEBUG_MODE == 1)
{
	cStopwatch::start();
}

$LOG_FILE = "./log/recv_r.log";
$mLog = new cLog($LOG_FILE);

$HOST = "192.168.100.153";
$DB = "pntdb";
$USER = "postgres";
$PASS = "am#71ZJ*";
$TABLE = "qr.regist_data";

//================================================
//	データベース接続
//	備考		：	
//	更新		：	2012/10/19 KMK-Teraoka
//================================================
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");


extract($_GET['data']);
extract($_GET['date']);
extract($_GET['reg']);
$GET_data = isset($_GET['data']) ? htmlspecialchars($_GET['data']) : "";
$GET_date = isset($_GET['date']) ? htmlspecialchars($_GET['date']) : "";
$GET_reg = isset($_GET['reg']) ? htmlspecialchars($_GET['reg']) : "";

//ｴﾑﾃｸﾉ,高堰（富）,1,74890,1,,,0,,0,65,1,,0,,0,,,0
//20140402A
//與儀

//$DATA = explode("," ,"ｴﾑﾃｸﾉ,高堰（富）,1,74890,1,,,0,,0,65,1,,0,,0,,,0");
//$DATE = "20140402A";
//$REG = "與儀";



$DATA = explode("," ,$GET_data);
$DATE = $GET_date;
$REG = $GET_reg;

$mLog->writeLog($GET_data. "\n");
$mLog->writeLog($GET_date. "\n");
$mLog->writeLog($GET_reg. "\n");

//変数にデータをセット

$DataDate = substr($DATE,"0","4") ."-" .substr($DATE,"4","2") ."-" .substr($DATE,"6","2") ." " ."00:00:00";
$DataTimeZone = substr($DATE,"8","1");
$DataTimeZone = (!strcmp(substr($DATE,"8","1"),"A")) ? 0 : 1;
$DataRegistrant = urldecode($REG);

$DataConpanyName = urldecode($DATA[0]);
$DataUserName = urldecode($DATA[1]);
$DataUserDentificationFlag = urldecode($DATA[2]);
$DataUserId = urldecode($DATA[3]);
$DataUserIdFlag = urldecode($DATA[4]);
$DataCarType = urldecode($DATA[5]);
$DataCarNumber = urldecode($DATA[6]);
$DataCarDentificationFlag = urldecode($DATA[7]);
$DataCarId = urldecode($DATA[8]);
$DataCarIdFlag = urldecode($DATA[9]);
$DataFlagNumber = urldecode($DATA[10]);
$DataFlagNumberFlag = urldecode($DATA[11]);
$DataMarkNumber = urldecode($DATA[12]);
$DataMarkNumberFlag = urldecode($DATA[13]);
$DataManualNumber = urldecode($DATA[14]);
$DataManualNumberFlag = urldecode($DATA[15]);
$DataFireNumber = urldecode($DATA[16]);
$DataFireNumberFlag = urldecode($DATA[18]);
$DataDepository = urldecode($DATA[17]);




//重複確認
$SELECT_C = "SELECT * FROM " .$TABLE ." WHERE company_name = '" .$DataConpanyName ."' AND user_name = '" .$DataUserName ."' AND date =  '" .$DataDate ."' AND time_zone = '" .$DataTimeZone ."' AND del_flag = false ORDER BY regdatetime;";
$RES_C = pg_query($conn,$SELECT_C) OR DIE(pg_last_error() ."<BR>" .$SELECT_C);
$C_count = pg_num_rows($RES_C);


if(!$C_count)
{
	$INSERT = "INSERT INTO " .$TABLE ." (";
	$INSERT .= "registrant_name, date, time_zone, company_name, user_name, user_dentification_flag,";
	$INSERT .= "user_id, user_id_flag, car_type, car_number, car_dentification_flag, ";
	$INSERT .= "car_id, car_id_flag, flag_number, flag_number_flag, mark_number, ";
	$INSERT .= "mark_number_flag, manual_number, manual_number_flag, fire_number, ";
	$INSERT .= "fire_flag, depository, regdatetime,del_flag";
	$INSERT .= ") VALUES (";
	$INSERT .= "'" .$DataRegistrant ."'";
	$INSERT .= "," ."'" .$DataDate ."'";
	$INSERT .= "," .$DataTimeZone;
	$INSERT .= "," ."'" .$DataConpanyName ."'";
	$INSERT .= "," ."'" .$DataUserName ."'";
	$INSERT .= "," ."'" .$DataUserDentificationFlag ."'";
	$INSERT .= "," ."'" .$DataUserId ."'";
	$INSERT .= "," ."'" .$DataUserIdFlag ."'";
	$INSERT .= "," ."'" .$DataCarType ."'";
	$INSERT .= "," ."'" .$DataCarNumber ."'";
	$INSERT .= "," ."'" .$DataCarDentificationFlag ."'";
	$INSERT .= "," ."'" .$DataCarId ."'";
	$INSERT .= "," ."'" .$DataCarIdFlag ."'";
	$INSERT .= "," ."'" .$DataFlagNumber ."'";
	$INSERT .= "," ."'" .$DataFlagNumberFlag ."'";
	$INSERT .= "," ."'" .$DataMarkNumber ."'";
	$INSERT .= "," ."'" .$DataMarkNumberFlag ."'";
	$INSERT .= "," ."'" .$DataManualNumber ."'";
	$INSERT .= "," ."'" .$DataManualNumberFlag ."'";
	$INSERT .= "," ."'" .$DataFireNumber ."'";
	$INSERT .= "," ."'" .$DataFireNumberFlag ."'";
	$INSERT .= "," ."'" .$DataDepository ."'";
	$INSERT .= "," ."current_timestamp,false";
	$INSERT .= ")";
	$RES = pg_query($conn,$INSERT) OR DIE(pg_last_error() ."<BR>" .$INSERT);
}
else
{
	$UPDATE = "UPDATE " .$TABLE ." SET del_flag=true ";
	$UPDATE .=" WHERE company_name = '" .$DataConpanyName ."' AND user_name = '" .$DataUserName ."' AND date =  '" .$DataDate ."' AND time_zone = '" .$DataTimeZone ."' AND del_flag = false";
	$RES = pg_query($conn,$UPDATE) OR DIE(pg_last_error() ."<BR>" .$UPDATE);
	
	$INSERT = "INSERT INTO " .$TABLE ." (";
	$INSERT .= "registrant_name, date, time_zone, company_name, user_name, user_dentification_flag,";
	$INSERT .= "user_id, user_id_flag, car_type, car_number, car_dentification_flag, ";
	$INSERT .= "car_id, car_id_flag, flag_number, flag_number_flag, mark_number, ";
	$INSERT .= "mark_number_flag, manual_number, manual_number_flag, fire_number, ";
	$INSERT .= "fire_flag, depository, regdatetime,del_flag";
	$INSERT .= ") VALUES (";
	$INSERT .= "'" .$DataRegistrant ."'";
	$INSERT .= "," ."'" .$DataDate ."'";
	$INSERT .= "," .$DataTimeZone;
	$INSERT .= "," ."'" .$DataConpanyName ."'";
	$INSERT .= "," ."'" .$DataUserName ."'";
	$INSERT .= "," ."'" .$DataUserDentificationFlag ."'";
	$INSERT .= "," ."'" .$DataUserId ."'";
	$INSERT .= "," ."'" .$DataUserIdFlag ."'";
	$INSERT .= "," ."'" .$DataCarType ."'";
	$INSERT .= "," ."'" .$DataCarNumber ."'";
	$INSERT .= "," ."'" .$DataCarDentificationFlag ."'";
	$INSERT .= "," ."'" .$DataCarId ."'";
	$INSERT .= "," ."'" .$DataCarIdFlag ."'";
	$INSERT .= "," ."'" .$DataFlagNumber ."'";
	$INSERT .= "," ."'" .$DataFlagNumberFlag ."'";
	$INSERT .= "," ."'" .$DataMarkNumber ."'";
	$INSERT .= "," ."'" .$DataMarkNumberFlag ."'";
	$INSERT .= "," ."'" .$DataManualNumber ."'";
	$INSERT .= "," ."'" .$DataManualNumberFlag ."'";
	$INSERT .= "," ."'" .$DataFireNumber ."'";
	$INSERT .= "," ."'" .$DataFireNumberFlag ."'";
	$INSERT .= "," ."'" .$DataDepository ."'";
	$INSERT .= "," ."current_timestamp,false";
	$INSERT .= ")";
	$RES = pg_query($conn,$INSERT) OR DIE(pg_last_error() ."<BR>" .$INSERT);
	
}

?>