"; print ""; print ""; print ""; print ""; print "退避監視システム"; print ""; print ""; print "
"; print ""; print "退避監視システム
-作業員退避状況-"; print "【五洋建設株式会社】"; print ""; print "
"; print "
"; $vstatus = array( "0" => "退避済", "3" => "不明", "4" => "退避済", "7" => "不明", "8" => "退避済", "B" => "不明", "F" => "作業中" ); try { $conn = pg_connect(" host = 192.168.100.153 dbname = cnbs user = postgres password= am#71ZJ* "); if (!$conn) throw new Exception("データベースへの接続に失敗"); print "
"; print ""; $selectWrkName = "SELECT dispno, tagid, wname FROM nakagusuku.worker_info WHERE useflg='t' ORDER BY dispno;"; $resWrkName = pg_query($conn, $selectWrkName); $rowcnt = pg_num_rows($resWrkName); for($i = 0; $i < $rowcnt; $i++) { $rowWrkName = pg_fetch_assoc($resWrkName, $i); $selectState = "SELECT recvid, state, update FROM nakagusuku.worker_position WHERE tagid='". $rowWrkName["tagid"]. "';"; $resState = pg_query($conn, $selectState); $rowcntState = pg_num_rows($resState); if ($rowcntState < 1) { print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } else { $rowState = pg_fetch_assoc($resState, 0); print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; } } print "
表示番号作業者氏名タグID状態アンテナ更新
". $rowWrkName["dispno"]. "". $rowWrkName["wname"]. "". $rowWrkName["tagid"]. "検出履歴なし--
". $rowWrkName["dispno"]. "". $rowWrkName["wname"]. "". $rowWrkName["tagid"]. "". $vstatus[$rowState["state"]]. "". $rowState["recvid"]. "". $rowState["update"]. "
"; } catch(Exception $exc) { print ""; print $exc. "
"; print ""; } pg_close($conn); print "

"; print "戻る"; print "

"; print "
"; print "
"; print ""; print "penta-ocean"; print ""; print "
"; ?>