File "recv_OLD20190308.php"
Full path: /www/shimooguni/recv/OLD/recv_OLD20190308.php
File size: 6.32 KiB (6475 bytes)
MIME-type: text/x-php
Charset: utf-8
<?php
//-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
// 自動でクラスを参照する
// 関数名 ： __autoload()
// 備考 ： 参照先は./class/XXX.phpとする
// 更新 ： 2012/10/19 KMK-Teraoka
//-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
//EXTRACT($_POST);
EXTRACT($_GET);
/////////////////////////////////////////////////////////////////////////////////////
// 最初に保存ファイル名を取得しておく（ファイルが存在しなかったらヘッダーを作成）
$data_dir = "./data/";
$dname = $GLOBALS["data_dir"] . date("Ym") . "/";
$fname = $dname . date("Ymd") . ".log";
if (!file_exists($dname)) {
if (!create_data_directory($dname)) {
return false;
}
}
if (!file_exists($fname)) {
if (!create_csv_header($fname)) {
return false;
}
}
// データディレクトリの作成
function create_data_directory($dname) {
if (!mkdir($dname, 0755, true)) {
return false;
}
return true;
}
// CSVファイルとヘッダーの作成
function create_csv_header($fname) {
$fp = fopen($fname, "w");
if (!$fp) {
return false;
}
// fwrite($fp, "[DataTime],date,time,roll,pitch,yaw,ax,ay,az\n");
fclose($fp);
return true;
}
function double_explode($word1, $word2, $str) {
$return = array();
//分割文字その1で文字列を分割
$array = explode($word1, $str);
//各配列を分割文字その2で分割して結合していく
foreach ($array as $value) {
$return = array_merge($return, explode($word2, $value));
}
return $return;
}
/////////////////////////////////////////////////////////////////////////////////////
//$date_ = date("[Y-m-d H:i:s]",time());
$date_ = date("Y-m-d ",time()) ;
//$data_ = isset($_POST["data"]) ? htmlspecialchars($_POST["data"]) : "";
$data_ = isset($_GET["data"]) ? htmlspecialchars($_GET["data"]) : "";
$fp = fopen($fname,"a");
//fwrite($fp,$data_ ."\n");
fwrite($fp,$data_ );
fclose($fp);
//日付確認用
$fp2_r = fopen("new.log","r");
$data_r = fgets($fp2_r);
$data_a = explode(",", $data_r);
fclose($fp2_r);
$data_A = double_explode(",","\n", $data_);
$ct = count($data_A) -2;
$date_ct = 0;
for($k = 0;$k <=$ct;$k++)
{
if($k == $date_ct)
{
$out_data .= $date_ .$data_A[$k] .",";
$date_ct = $date_ct + 14;
}
else
{
$out_data .= $data_A[$k] .",";
}
if($k == 13) $out_data .= "\n";
}
$fp2 = fopen("new.csv","w");
//fwrite($fp,$data_ ."\n");
//fwrite($fp2,$date_ ."\n" .$out_data);
fwrite($fp2, $out_data);
fclose($fp2);
$fp3 = fopen("url.log","w");
//fwrite($fp,$data_ ."\n");
fwrite($fp3,"http://" .$_SERVER['REMOTE_ADDR'] );
fclose($fp3);
$HOST = "192.168.100.153";
$DB = "shimooguni";
$USER = "postgres";
$PASS = "postgres";
$DATA_TABLE = "weather.data_log";
$DATA_TABLE_DAY = "weather.data_day";
$DATA_TABLE_WEEK = "weather.data_week";
$DATA_TABLE_MONTH = "weather.data_month";
$DATA_TABLE_NEW = "weather.data_new";
//================================================
// データベース接続
// 備考 ：
// 更新 ： 2013/03/12 KMK-Yokosuka
//================================================
$conn = pg_connect("
host = ". $HOST. "
dbname = ". $DB. "
user = ". $USER. "
password= ". $PASS. "
");
if(strtotime($data_a[14]) < strtotime($data_A[0]))
{
// $insert = "INSERT INTO ". $DATA_TABLE. " VALUES ('" .$data_A[0] ."','" .$data_A[1] ."'," .$data_A[2] .",'" .$data_A[3] ."'," .$data_A[4] ."," .$data_A[5] ."," .$data_A[6] ."," .$data_A[7] ."," .$data_A[8] ."," .$data_A[9] .",'" .$data_A[10] ."','" .$data_A[11] ."'," .$data_A[12] .",'" .$data_A[13] ."');";
// $res = pg_query($conn, $insert);
}
if(strtotime($data_a[14]) < strtotime($data_A[14]))
{
// $insert = "INSERT INTO ". $DATA_TABLE. " VALUES ('" .$data_A[0] ."','" .$data_A[1] ."'," .$data_A[2] .",'" .$data_A[3] ."'," .$data_A[4] ."," .$data_A[5] ."," .$data_A[6] ."," .$data_A[7] ."," .$data_A[8] ."," .$data_A[9] .",'" .$data_A[10] ."','" .$data_A[11] ."'," .$data_A[12] .",'" .$data_A[13] ."');";
// $res = pg_query($conn, $insert);
}
//$insert = "INSERT INTO ". $RAIN_GAUGE_TABLE. " VALUES ('". $pls2gauge[$deviceid]["ch00"]. "', '". $ftdate. "', current_timestamp);";
//$res = pg_query($conn, $insert);
/*
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.log";
$RAIN_GAUGE_TABLE = "xband.raingauge";
$HOST = "192.168.100.153";
$DB = "xband";
$USER = "postgres";
$PASS = "postgres";
$datetime = isset($_POST["datetime"]) ? htmlspecialchars($_POST["datetime"]) : "";
$deviceid = isset($_POST["deviceid"]) ? htmlspecialchars($_POST["deviceid"]) : "";
$ch00 = isset($_POST["ch00"]) ? htmlspecialchars($_POST["ch00"]) : "";
$ch01 = isset($_POST["ch01"]) ? htmlspecialchars($_POST["ch01"]) : "";
$mLog = new cLog($LOG_FILE);
$mLog->writeLog($datetime. "\n");
$mLog->writeLog($ch00. "\n");
$mLog->writeLog($ch01. "\n");
//================================================
// データベース接続
// 備考 ：
// 更新 ： 2013/03/12 KMK-Yokosuka
//================================================
$conn = pg_connect("
host = ". $HOST. "
dbname = ". $DB. "
user = ". $USER. "
password= ". $PASS. "
");
// CNT24-2(端末ID, Channel)→雨量計ID
$pls2gauge = array(
"CNT810001" => array("ch00" => "1", "ch01" => "2"),
"CNT820002" => array("ch00" => "3", "ch01" => "4")
);
// 日付を切り出し
$datey = substr($datetime, 0, 4);
$datem = substr($datetime, 4, 2);
$dated = substr($datetime, 6, 2);
$dateh = substr($datetime, 8, 2);
$datei = substr($datetime, 10, 2);
$dates = substr($datetime, 12, 2);
$ftdate = "$datey/$datem/$dated $dateh:$datei:$dates";
// CH00を処理
for($iCount = 0; $iCount < $ch00; $iCount++)
{
$insert = "INSERT INTO ". $RAIN_GAUGE_TABLE. " VALUES ('". $pls2gauge[$deviceid]["ch00"]. "', '". $ftdate. "', current_timestamp);";
$res = pg_query($conn, $insert);
$mLog->writeLog($insert. "\n");
}
// CH01を処理
for($iCount = 0; $iCount < $ch01; $iCount++)
{
$insert = "INSERT INTO ". $RAIN_GAUGE_TABLE. " VALUES ('". $pls2gauge[$deviceid]["ch01"]. "', '". $ftdate. "', current_timestamp);";
$res = pg_query($conn, $insert);
$mLog->writeLog($insert. "\n");
}
*/
?>