<?php
EXTRACT($_POST);


$data = isset($_POST["data"]) ? htmlspecialchars($_POST["data"]) : "";

//データ取得終了フラグ
$endf = isset($_POST["end"]) ? htmlspecialchars($_POST["end"]) : "";


if(!$endf)
{
	$fp = fopen("data.log", "a");
	$fp2 = fopen("data.csv", "a");
	
	$data_ = explode("#",$data);
	$gps_data = explode("," ,$data_[1]);
	$gps_date_tmp = mktime(substr($gps_data[1],0,2), substr($gps_data[1],2,2), substr($gps_data[1],4,2), substr($gps_data[9],2,2), substr($gps_data[9],0,2), substr($gps_data[9],4,2)) + 32400;
	$gps_date = date("Y-m-d H:i:s" ,$gps_date_tmp);

	
	fwrite($fp, $data_[1] ."__" .date("Y-m-d H:i:s",time())  ."," .$data_[2]);
	fwrite($fp2,$gps_date ."," .$gps_data[3] ."," .$gps_data[5] ."," .date("Y-m-d H:i:s",time())  ."," .$data_[2]);
	fclose($fp);
	fclose($fp2);
}
else
{
	$mk_file_name = "/www/ri/csv/" .date("YmdHis",time()) .".csv";
	rename("data.csv", $mk_file_name);

	//データベース登録処理
	$cm = "sudo -u postgres psql shimooguni -c \" COPY ri.data FROM '" .$mk_file_name ."' WITH CSV\";";
	$a = exec($cm);
	$fpt =fopen("test.txt","a");
	fwrite($fpt,$cm  ."__result:" .$a ."\n");
	fclose($fpt);


	$fp = fopen("sendflag.txt", "w");
	fwrite($fp, "0");
	fclose($fp);
}


?>