ansysqgis000_nasu2inout

File "inout.php"

Full path: /www/ansys/qgis/000_nasu2/inout/inout.php
File size: 3.21 KiB (3285 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back 

<?php
print "<!DOCTYPE html>";
//データベース接続
$HOST = "192.168.100.153";
$DB = "ansys";
$USER = "postgres";
$PASS = "am#71ZJ*";

$CONST_ID = "10";
$APP_ID = "17";

$enableSec = 600;
$enableDateTime = date("Y-m-d H:i:s", time() - $enableSec);

$spol = array(
	array(35.4279452, 139.6784323),
	array(35.4270557, 139.6779549),
	array(35.4267978, 139.6783438),
	array(35.4278294, 139.6788856)
);
$epol = array(
	array(35.4395918, 139.6838896),
	array(35.4379768, 139.6829104),
	array(35.4373758, 139.6843904),
	array(35.4389908, 139.6853696)
);
$stcnt = 0;
$sterm = array();
$etcnt = 0;
$eterm = array();
$conn = pg_connect("
	host	=	". $HOST. "
	dbname	=	". $DB. "
	user	=	". $USER. "
	password=	". $PASS. "
");

// 時刻で絞り込む場合
$enableSec = 600;
$enableDateTime = date("Y-m-d H:i:s", time() - $enableSec);

$sql = "SELECT * FROM qgis.ts_terminal";
$sql .= " WHERE app_id='". $APP_ID. "'";
$sql .= " AND const_id='". $CONST_ID. "'";
$sql .= " AND mesdatetime >= '". $enableDateTime. "'";
$sql .= " ORDER BY terminal_name";
$sql .= ";";
$res = pg_query($conn, $sql);
$numTemrinal = pg_num_rows($res);
for($i = 0; $i < $numTemrinal; $i++)
{
	$row = pg_fetch_array($res, $iCount);
	//$terminals[$i]["name"] = $row["terminal_name"];
	//$terminals[$i]["android_id"] = $row["android_id"];
	
	//print_r($row);
	//print "<br>";
	
	// 始点に入っているか
	$sql = "SELECT 1 AS angle WHERE point '(". ($row["lon"] * 100000000). ",". ($row["lat"] * 100000000). ")'";
	$sql .= " @ polygon '(";
	for($j = 0; $j < count($spol); $j++)
	{
		if ($j > 0)
			$sql .= ",";
		$sql .= "(". ($spol[$j][1] * 100000000). ",". ($spol[$j][0] * 100000000). ")";
	}
	$sql .= ")';";
	//print $sql. "<br>";
	$numr = pg_num_rows(pg_query($conn, $sql));
	if ($numr > 0)
	{
		//print "in!!<br>";
		$sterm[$stcnt++] = array($row["terminal_name"]);
	}
	// 終点に入っているか
	$sql = "SELECT 1 AS angle WHERE point '(". ($row["lon"] * 100000000). ",". ($row["lat"] * 100000000). ")'";
	$sql .= " @ polygon '(";
	for($j = 0; $j < count($epol); $j++)
	{
		if ($j > 0)
			$sql .= ",";
		$sql .= "(". ($epol[$j][1] * 100000000). ",". ($epol[$j][0] * 100000000). ")";
	}
	$sql .= ")';";
	//print $sql. "<br>";
	$numr = pg_num_rows(pg_query($conn, $sql));
	if ($numr > 0)
	{
		//print "in!!<br>";
		$eterm[$etcnt++] = array($row["terminal_name"]);
	}
}

print "#";
for($i = 0; $i < count($sterm); $i++)
{
	if ($i > 0)
		print ",";
	print $sterm[$i]["0"];
}
print "#";
for($i = 0; $i < count($eterm); $i++)
{
	if ($i > 0)
		print ",";
	print $eterm[$i]["0"];
}
// 切断
pg_close($conn);

/*
//===============================================
//	HTML-HEAD-
//	備考		：	
//	更新		：	2012/10/18 KMK-Teraoka
//===============================================
print "<html>";
print "<head>";
print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "</head>";

print "<body>";

print "<table style=\"width:100%;\"border=\"1\">";
	print "<tr>";
		print "<td><font color=\"#FF0000\">";
		print $msg;
		print "</font></td>";
	print "</tr>";
print "</table>";

print "</body>";
print "</html>";
*/
?>

PHP File Manager