";
//データベース接続
$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 "
";
// 始点に入っているか
$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. "
";
$numr = pg_num_rows(pg_query($conn, $sql));
if ($numr > 0)
{
//print "in!!
";
$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. "
";
$numr = pg_num_rows(pg_query($conn, $sql));
if ($numr > 0)
{
//print "in!!
";
$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 "";
print "";
print "";
print "";
print "";
print "";
print "";
print "";
print "";
print "| ";
print $msg;
print " | ";
print "
";
print "
";
print "";
print "";
*/
?>