"; 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("データベースへの接続に失敗"); $btnchstate = isset($_POST["btnchstate"]) ? htmlspecialchars($_POST["btnchstate"]) : ""; if (strcmp($btnchstate, "切替") == 0) { // refresh state $editid = isset($_POST["hipid"]) ? htmlspecialchars($_POST["hipid"]) : ""; $nowstate = isset($_POST["hinowstate"]) ? htmlspecialchars($_POST["hinowstate"]) : ""; $refstate = ""; if (strcmp($nowstate, "F") == 0) $refstate = "0"; else if (strcmp($nowstate, "0") == 0 || strcmp($nowstate, "4") == 0 || strcmp($nowstate, "8") == 0) $refstate = "F"; if (strcmp($refstate, "") != 0) { $updatestate = "UPDATE nakagusuku.worker_position SET state='". $refstate. "', update=current_timestamp WHERE pid='". $editid. "';"; $resupdatestate = pg_query($conn, $updatestate); print ""; print "状態を更新しました
"; print ""; } } 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 pid, recvid, state, update FROM nakagusuku.worker_position WHERE tagid='". $rowWrkName["tagid"]. "';"; $resState = pg_query($conn, $selectState); $rowcntState = pg_num_rows($resState); if ($rowcntState < 1) continue; $rowState = pg_fetch_assoc($resState, 0); print ""; print ""; print ""; print ""; print "" print ""; print ""; print ""; print ""; print ""; } print "
表示番号作業者氏名状態
". $rowWrkName["dispno"]. "". $rowWrkName["wname"]. "". $vstatus[$rowState["state"]]. ""; print "
"; //print "". $row["dispno"]. "
"; } catch(Exception $exc) { } pg_close($conn); print "

"; print "戻る"; print "

"; ?>