"; print ""; print ""; print ""; print ""; print "sigfox計測データ一覧"; print ""; $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 送信回数" ."
"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "
端末名送信済送信残り
S-01" .$dev1_send_ct ."" .(130-$dev1_send_ct) ."
S-02" .$dev2_send_ct ."" .(130-$dev2_send_ct) ."
S-03" .$dev3_send_ct ."" .(130-$dev3_send_ct) ."
S-04" .$dev4_send_ct ."" .(130-$dev4_send_ct) ."
"; print "
"; print "■送信履歴" ."
"; print ""; print ""; print ""; print ""; print ""; print ""; //送信履歴表示 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 ""; print ""; print ""; print ""; print ""; print ""; } print "
端末名日時基地局IDRSSI
" .$dev_name ."" .$row[1] ."" .$station_id ."" .$row[5] ."
"; print ""; ?>