File "state_.php"

Full path: /www/nakagusuku/wpos/output/state_.php
File size: 1.38 KiB (1415 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;
		}
	}
	*/
	//$wrkok = "A21,A12,A13,A14,A15,A16,A17,A18,A19,A110,A111,A112,A113,A114,A115,A116,A117,A118,A119,A120,B11,B12,B13,B14,B15,B16,B17,B18,B19,B110,B111,B112,B113,B114,B115,B116,B117,B118,B119,B123";
	$wrkok = "A11,A12";
	$wrkng = "B111,B112,B113,B114,B115,B116,B117,B118,B119,B120,B121,B122,B123,B124,B125,B126,B127,B128,B129,B130";
	print $wrkok. "\n";
	print $wrkng. "\n";
}
catch(Exception $exc)
{
	print "\n";
	print "\n";
}
pg_close($conn);
?>