"; //print $tagid. "
"; //print $state. "
"; //print $recvid. "
"; //print $rssi. "
"; $selectTag = "SELECT tagid FROM nakagusuku.worker_position WHERE tagid='". $tagid. "';"; //print $selectTag. "
"; $response = pg_query($conn, $selectTag); if (pg_num_rows($response) > 0) { // update //print "update
"; $updateTag = "UPDATE nakagusuku.worker_position SET state='". $state. "', update=current_timestamp WHERE tagid='". $tagid. "';"; //print $updateTag. "
"; $response = pg_query($conn, $updateTag); } else { // insert //print "insert
"; $insertTag = "INSERT INTO nakagusuku.worker_position (dispno, tagid, state, update, regdate) VALUES (DEFAULT, '". $tagid. "','". $state. "',current_timestamp, current_timestamp);"; //print $insertTag. "
"; $response = pg_query($conn, $insertTag); } $loginsert = "INSERT INTO nakagusuku.worker_log (tagid, state, recvid, rssi, regdate) VALUES ('". $tagid. "','". $state. "','". $recvid. "','". $rssi. "',current_timestamp);"; $response = pg_query($conn, $loginsert); } pg_close($conn); ?>