sigfox

File "data_view.php"

Full path: /www/sigfox/data_view.php
File size: 3.74 KiB (3832 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?php
//===============================================
//	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>sigfox計測データ一覧</title>";
print "</head>";


$HOST = "192.168.100.153";
$DB = "lpwa";
$USER = "postgres";
$PASS = "postgres";

$DATA_TABLE = "sigfox.data";
$DEVICE_TABLE = "sigfox.device";

$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");

$now_time = time();

$Start_time = date("Y-m-d 00:00:00",$now_time);

$End_time = date("Y-m-d H:i:s",$now_time);


$sel_sl = "SELECT * FROM " .$DATA_TABLE ." WHERE getdatetime >= '" .$Start_time ."' AND getdatetime < '" .$End_time ."' ORDER BY getdatetime desc";
$res_sl = pg_query($conn,$sel_sl);
$ct_sl = pg_num_rows($res_sl);

$sel_dev1 = "SELECT count(*) FROM " .$DATA_TABLE ." WHERE device = '741D6A' AND getdatetime >= '" .$Start_time ."' AND getdatetime < '" .$End_time ."'";
$res_dev1 = pg_query($conn,$sel_dev1);
$row_dev1 = pg_fetch_array($res_dev1,0);
$dev1_send_ct = $row_dev1[0];

$sel_dev2 = "SELECT count(*) FROM " .$DATA_TABLE ." WHERE device = '739585' AND getdatetime >= '" .$Start_time ."' AND getdatetime < '" .$End_time ."'";
$res_dev2 = pg_query($conn,$sel_dev2);
$row_dev2 = pg_fetch_array($res_dev2,0);
$dev2_send_ct = $row_dev2[0];


$sel_dev3 = "SELECT count(*) FROM " .$DATA_TABLE ." WHERE device = '743224' AND getdatetime >= '" .$Start_time ."' AND getdatetime < '" .$End_time ."'";
$res_dev3 = pg_query($conn,$sel_dev3);
$row_dev3 = pg_fetch_array($res_dev3,0);
$dev3_send_ct = $row_dev3[0];


$sel_dev4 = "SELECT count(*) FROM " .$DATA_TABLE ." WHERE device = '741BC0' AND getdatetime >= '" .$Start_time ."' AND getdatetime < '" .$End_time ."'";
$res_dev4 = pg_query($conn,$sel_dev4);
$row_dev4 = pg_fetch_array($res_dev4,0);
$dev4_send_ct = $row_dev4[0];



print "■sigfox_Arduino 送信回数" ."<BR>";

print "<TABLE BORDER='2'><TR ALIGN='center'>";
print "<TD>端末名</TD>";
print "<TD>送信済</TD>";
print "<TD>送信残り</TD></TR>";
print "<TR ALIGN='center'>";
print "<TD>S-01</TD>";
print "<TD>" .$dev1_send_ct  ."</TD>";
print "<TD>" .(130-$dev1_send_ct)  ."</TD>";
print "</TR>";
print "<TR ALIGN='center'>";
print "<TD>S-02</TD>";
print "<TD>" .$dev2_send_ct  ."</TD>";
print "<TD>" .(130-$dev2_send_ct)  ."</TD>";
print "</TR>";
print "<TR ALIGN='center'>";
print "<TD>S-03</TD>";
print "<TD>" .$dev3_send_ct  ."</TD>";
print "<TD>" .(130-$dev3_send_ct) ."</TD>";
print "</TR>";
print "<TR ALIGN='center'>";
print "<TD>S-04</TD>";
print "<TD>" .$dev4_send_ct  ."</TD>";
print "<TD>" .(130-$dev4_send_ct) ."</TD>";
print "</TR>";
print "</TABLE>";
print "<BR>";

print "■送信履歴" ."<BR>";

print "<TABLE BORDER='2'><TR>";
print "<TD>端末名</TD>";
print "<TD>日時</TD>";
print "<TD>基地局ID</TD>";
print "<TD>RSSI</TD>";
print "</TR>";


//送信履歴表示
for($i = 0;$i < $ct_sl;$i++)
{
	$row = pg_fetch_array($res_sl,$i);
	
	//端末名の取得
	$sel_dev_name = "SELECT * FROM " .$DEVICE_TABLE ." WHERE device_id = '" .$row[0] ."'";
	$res_dev_name = pg_query($conn,$sel_dev_name);
	$row_dev_name = pg_fetch_array($res_dev_name,0);
	$dev_name = $row_dev_name[2];
	
	//基地局IDの変換(レンタルGWの時のみ)
	$station_id = (!strcmp($row[2],'9327')) ? "TestGW":$row[2];
	
	print "<TR>";
	print "<TD>" .$dev_name ."</TD>";
	print "<TD>" .$row[1] ."</TD>";
	print "<TD>" .$station_id ."</TD>";
	print "<TD>" .$row[5] ."</TD>";
	print "</TR>";
}
print "</TABLE>";


print "</html>";
?>

PHP File Manager