<?php

try
{
	$conn = pg_connect("
	host	=	192.168.100.153
	dbname	=	cnbs
	user	=	postgres
	password=	am#71ZJ*
	");
	if (!$conn)
		throw new Exception("データベースへの接続に失敗");
	
	$wrkok = "";
	$wrkng = "";
	
	$selectTagList = "SELECT dispno, tagid FROM nakagusuku.worker_info WHERE useflg='t' ORDER BY dispno;";
	$resTagList = pg_query($conn, $selectTagList);
	$cntTagList = pg_num_rows($resTagList);
	for($i = 0; $i < $cntTagList; $i++)
	{
		$rowTagList = pg_fetch_assoc($resTagList, $i);
		
		$selectState = "SELECT state, recvid FROM nakagusuku.worker_position WHERE tagid='". $rowTagList["tagid"]. "'";
		$resState = pg_query($conn, $selectState);
		$cntState = pg_num_rows($resState);
		if ($cntState < 1)
			continue;
		$rowState = pg_fetch_assoc($resState, 0);
		if (strcmp($rowState["state"], "0") == 0 || strcmp($rowState["state"], "4") == 0 || strcmp($rowState["state"], "8") == 0)
		{
			if (strcmp($wrkok, "") != 0)
				$wrkok .= ",";
			$wrkok .= $rowState["recvid"]. $rowTagList["tagid"];
		}
		else if (strcmp($rowState["state"], "F") == 0)
		{
			if (strcmp($wrkng, "") != 0)
				$wrkng .= ",";
			$wrkng .= $rowState["recvid"]. $rowTagList["tagid"];
		}
	}
	/*
	$selectWrk = "SELECT tagid, state, recvid FROM nakagusuku.worker_position ORDER BY dispno;";
	$res = pg_query($conn, $selectWrk);
	$rowcnt = pg_num_rows($res);
	for($i = 0; $i < $rowcnt; $i++)
	{
		$row = pg_fetch_assoc($res, $i);
		
		$selectChkUseFlag = "SELECT * FROM nakagusuku.worker_info WHERE tagid='". $row["tagid"]. "' AND useflg='t';";
		$resChkUseFlag = pg_query($conn, $selectChkUseFlag);
		$cntChkUseFlag = pg_num_rows($resChkUseFlag);
		if ($cntChkUseFlag > 0)
		{
			if (strcmp($row["state"], "0") == 0 || strcmp($row["state"], "4") == 0 || strcmp($row["state"], "8") == 0)
			{
				if (strcmp($wrkok, "") != 0)
					$wrkok .= ",";
				$tagid = $row["tagid"];
				$wrkok .= $row["recvid"]. $tagid;
			}
			else if (strcmp($row["state"], "F") == 0)
			{
				if (strcmp($wrkng, "") != 0)
					$wrkng .= ",";
				$tagid = $row["tagid"];
				$wrkng .= $row["recvid"]. $tagid;
			}
		}
	}
	*/
	print $wrkok. "\n";
	print $wrkng. "\n";
}
catch(Exception $exc)
{
	print "\n";
	print "\n";
}
pg_close($conn);
?>