File "state.php"

Full path: /www/nakagusuku/wpos/output/state.php
File size: 1.05 KiB (1078 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php

try
{
	$conn = pg_connect("
	host	=	192.168.100.153
	dbname	=	cnbs
	user	=	postgres
	password=	am#71ZJ*
	");
	if (!$conn)
		throw new Exception("データベースへの接続に失敗");
	
	$wrkok = "";
	$wrkng = "";
	
	$selectWrk = "SELECT pid, dispno, state, recvid FROM nakagusuku.worker_position WHERE useflg='t' 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);
		if (strcmp($row["state"], "0") == 0 || strcmp($row["state"], "4") == 0 || strcmp($row["state"], "8") == 0)
		{
			if (strcmp($wrkok, "") != 0)
				$wrkok .= ",";
			$dno = $row["dispno"];
			if ($dno == 0)
				$dno = $row["pid"];
			$wrkok .= $row["recvid"]. $dno;
		}
		else if (strcmp($row["state"], "F") == 0)
		{
			if (strcmp($wrkng, "") != 0)
				$wrkng .= ",";
			$dno = $row["dispno"];
			if ($dno == 0)
				$dno = $row["pid"];
			$wrkng .= $row["recvid"]. $dno;
		}
	}
	print $wrkok. "\n";
	print $wrkng. "\n";
}
catch(Exception $exc)
{
	print "\n";
	print "\n";
}
pg_close($conn);
?>