File "view_OLD.php"
Full path: /www/ansys/qgis/006_haneda/map/view_OLD.php
File size: 17.88 KiB (18311 bytes)
MIME-type: text/x-php
Charset: utf-8
<?php
function retShipSimbol($point_, $direction_, $mapDegree_)
{
$ret = -1;
if ($direction_ == -1)
return -1;
$ret = array();
$ret[0]["x"] = $point_["x"];
$ret[0]["y"] = $point_["y"];
$ret[1]["x"] = floor($point_["x"] + (25 * cos(deg2rad($direction_ - 90 - $mapDegree_))));
$ret[1]["y"] = floor($point_["y"] + (25 * sin(deg2rad($direction_ - 90 - $mapDegree_))));
$ret[2]["x"] = floor($point_["x"] + (12 * cos(deg2rad($direction_ - 90 - $mapDegree_))));
$ret[2]["y"] = floor($point_["y"] + (12 * sin(deg2rad($direction_ - 90 - $mapDegree_))));
$ret[3]["x"] = floor($point_["x"] + (8 * cos(deg2rad($direction_ - 90 + 120 - $mapDegree_))));
$ret[3]["y"] = floor($point_["y"] + (8 * sin(deg2rad($direction_ - 90 + 120 - $mapDegree_))));
$ret[4]["x"] = floor($point_["x"] + (8 * cos(deg2rad($direction_ - 90 - 120 - $mapDegree_))));
$ret[4]["y"] = floor($point_["y"] + (8 * sin(deg2rad($direction_ - 90 - 120 - $mapDegree_))));
return $ret;
}
function deleteFile($dir)
{
if (!$handle=opendir($dir))
return;
while($filename=readdir($handle))
{
if(!preg_match("/^\./", $filename))
{
if (!unlink("$dir/$filename"));
return;
}
}
}
/*
function StatusSet($PositionLat,$PositionLon,$DateTime)
{
$Margin = time() - strtotime($DateTime)
$LimitTime = 600;
if($LimitTime < $Margin)
$JudeResult =
return $JudgeResult;
}
*/
//-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
// 自動でクラスを参照する
// 関数名 ： __autoload()
// 備考 ： 参照先は./class/XXX.phpとする
// 更新 ： 2012/10/19 KMK-Teraoka
//-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
function __autoload($className)
{
$fPath = "./class/" . str_replace("_", "/", $className) . ".php";
require_once $fPath;
}
//===============================================
// DEBUG_MODE
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
define("DEBUG_MODE", "0");
Debug::setMode(DEBUG_MODE);
if (DEBUG_MODE == 1)
{
Stopwatch::start();
}
//===============================================
// CommonUtilities
// 備考 ：
// 更新 ： 2012/11/29 KMK-Teraoka
//===============================================
$SCRIPT_TITLE = "工事車両運行管理システム -位置確認-";
$PENTA_OCEAN = "五洋・大本特定建設工事共同企業体";
$TAIL_PENTA_OCEAN = "penta-ocean";
$HOST = "192.168.100.153";
$DB = "ansys";
$USER = "postgres";
$PASS = "am#71ZJ*";
$LOG_FILE = "./log/view.log";
$CONST_ID = 9;
$APPLICATION_ID = 16;
$MAP_NAME = "./scmap/orig.png";
$MAP_NAME_ZOOM = "./scmap/webpage2.png";
$ZOOM_MAP_DEGREE = 36.029;
$R_VAL = array(255, 204, 204, 204, 204, 153, 153, 100, 102, 102, 255, 153);
$G_VAL = array(102, 255, 102, 153, 255, 0, 51, 0, 204, 51, 0, 153);
$B_VAL = array( 0, 0, 102, 255, 255, 51, 255, 0, 153, 255, 153, 0);
$ENABLE_SEC = 600;
$ENABLE_DATETIME = date("Y-m-d H:i:s", time() - $ENABLE_SEC);
//===============================================
// HTML-HEAD-
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<html>";
print "<head>";
//print "<meta http-equiv=\"content-type\" content=\"text/html;charset=utf-8\">";
print "<meta http-equiv=\"Refresh\" content=\"30\">";
print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/ansys/config/css/style.css\">";
print "<link rel=\"shortcut icon\" href=\"/ansys/config/favicon.ico\">";
print "<title>". $SCRIPT_TITLE. "</title>";
print "</head>";
//===============================================
// HTML-BODY部開始-
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "<body>";
print "<center>";
print "<font size=\"3\">";
print "<b>";
print "". $SCRIPT_TITLE. "<br>";
print "</b>";
print "</font>";
print "</center>";
try
{
// tmpディレクトリ内のファイルを削除
deleteFile("./tmp");
$_log = new Log($LOG_FILE);
// ===============================================
// 画像情報の取得
// 備考 ：
// 更新 ： 2012/11/29 KMK-Teraoka
// ===============================================
$imgSize = getimagesize($MAP_NAME);
$zoomImgSize = getimagesize($MAP_NAME_ZOOM);
$imgFileName = "./tmp/". $CONST_ID. "_". $APPLICATION_ID. "_". md5(uniqid(rand(), true)) .image_type_to_extension($imgSize[2]);
// ===============================================
// 基準点情報
// 備考 ：
// 更新 ： 2012/11/29 KMK-Teraoka
// ===============================================
$ltLon = 139.793416; //経度(左上)
$ltLat = 35.592797; //緯度(左上)
$rbLon = 139.981100; //経度(右下)
$rbLat = 35.666697; //緯度(右下)
$ltX = 149; // 左上X座標
$ltY = 486; // 左上Y座標
$rbX = 1010; // 右下X座標
$rbY = 71; // 右下Y座標
$diffX = $rbX - $ltX; // X座標ピクセルの差を求める
$diffY = $rbY - $ltY; // Y座標ピクセルの差を求める
$spX = number_format(($rbLon - $ltLon) / $diffX, 10); // X座標の倍率を求める
$spY = number_format(($ltLat - $rbLat) / $diffY, 10); // Y座標の倍率を求める
// ===============================================
// 基準点情報2
// 備考 ：
// 更新 ： 2012/11/29 KMK-Teraoka
// ===============================================
$ltLonZm = 139.8023727; //経度(左上)
$ltLatZm = 35.58572163; //緯度(左上)
$rbLonZm = 139.8100264; //経度(右下)
$rbLatZm = 35.57928836; //緯度(右下)
$ltXZm = 18; // 左上X座標
$ltYZm = 72; // 左上Y座標
$rbXZm = 399; // 右下X座標
$rbYZm = 139; // 右下Y座標
// 回転させてから比率を求める
$ltXZm = 17 * cos(deg2rad($ZOOM_MAP_DEGREE)) - 73 * sin(deg2rad($ZOOM_MAP_DEGREE));
$ltYZm = 17 * sin(deg2rad($ZOOM_MAP_DEGREE)) + 73 * cos(deg2rad($ZOOM_MAP_DEGREE));
$rbXZm = 384 * cos(deg2rad($ZOOM_MAP_DEGREE)) - 136 * sin(deg2rad($ZOOM_MAP_DEGREE));
$rbYZm = 384 * sin(deg2rad($ZOOM_MAP_DEGREE)) + 136 * cos(deg2rad($ZOOM_MAP_DEGREE));
$diffXZm = $rbXZm - $ltXZm; // X座標ピクセルの差を求める
$diffYZm = $rbYZm - $ltYZm; // Y座標ピクセルの差を求める
$spXZm = number_format(($rbLonZm - $ltLonZm) / $diffXZm, 10); // X座標の倍率を求める
$spYZm = number_format(($ltLatZm - $rbLatZm) / $diffYZm, 10); // Y座標の倍率を求める
// ===============================================
// GD処理準備
// 備考 ：
// 更新 ： 2010/09/08 KMK T.Teraoka
// ===============================================
$src = ImageCreateFromPNG($MAP_NAME); //パレットへ貼り付ける画像指定(地図画像)
$src2 = ImageCreateFromPNG($MAP_NAME_ZOOM);
$img = imagecreatetruecolor($imgSize[0], $imgSize[1]); //パレットの作成
$zoomImg = imagecreatetruecolor($zoomImgSize[0], $zoomImgSize[1]);
imagecopy($img, $src, 0, 0, 0, 0, $imgSize[0], $imgSize[1]); //画像をパレットへ貼り付け
imagecopy($zoomImg, $src2, 0, 0, 0, 0, $zoomImgSize[0], $zoomImgSize[1]);
$font1 = "/usr/share/fonts/vlgothic/VL-Gothic-Regular.ttf";
imagesetthickness($img, $THIC);
imagesetthickness($img, $THIC);
// 使用色の準備
$Black = imagecolorallocate($img, 0,0,0);
$BlackZm = imagecolorallocate($zoomImg, 0,0,0);
$White = imagecolorallocate($img, 255, 255, 255);
$WhiteZm = imagecolorallocate($zoomImg, 255, 255, 255);
// 更新時間をマップに表示する
//$update = date("H:i:s" ,time());
//imagefilledpolygon($img, array(10, 10, 10, 20, 55, 20, 55, 10), 4, $White);
//ImageTTFText ($img, 8, 0, 10, 20, $Black, $font1, $update);
//================================================
// データベース接続
// 備考 ：
// 更新 ： 2012/11/29 KMK-Teraoka
//================================================
$conn = pg_connect("
host = ". $HOST. "
dbname = ". $DB. "
user = ". $USER. "
password= ". $PASS. "
");
if (!$conn)
{
throw new Exception("データベースへの接続に失敗しました");
}
// ===============================================
// 位置を取得する
// 備考 ：
// 更新 ： 2012/11/29 KMK T.Teraoka
// ===============================================
$selTerm = "SELECT * FROM qgis.ts_terminal";
$selTerm .= " WHERE const_id='". $CONST_ID. "'";
$selTerm .= " AND app_id='". $APPLICATION_ID. "'";
$selTerm .= " AND NOT terminal_name = 'haneda_test'";
//$selTerm .= " AND mesdatetime >= '". $ENABLE_DATETIME. "'";
$selTerm .= " ORDER BY terminal_name";
$selTerm .= ";";
//$_log->write($selTerm. "\n");
if (!($resTerm = pg_query($conn, $selTerm)))
{
throw new Exception("データ取得に失敗<br />". $resTerm. "<br />". pg_last_error(). "<br />");
}
$shipCol = imagecolorallocate($img, 255, 165, 0);
$zmShipCol = imagecolorallocate($img, 255, 165, 0);
$zmSyunCol = imagecolorallocate($img, 0, 102, 253);
$StatusView = array();
$row = pg_num_rows($resTerm);
for($iCount = 0; $iCount < $row; $iCount++)
{
$rowTerm = pg_fetch_array($resTerm, $iCount, PGSQL_ASSOC);
//var_dump($rowTerm);
if (0 != strcmp($rowTerm["lat"], "") && 0 != strcmp($rowTerm["lon"], "") && strcmp($rowTerm["android_id"], "8041c3ba7d4843c1") != 0)
{
// 基準点1
//
if (strcmp($rowTerm["android_id"], "a237b48012d8873e") != 0 && strcmp($rowTerm["android_id"], "26f784b2293665d0") != 0 && strcmp($rowTerm["android_id"], "db9739dd1cfbc823") != 0)
{
//print $iCount ."__" .$rowTerm["lat"] ."__" .$rowTerm["lon"] ."__" .$rowTerm["terminal_name"] ."<BR>";
$point = array();
$point["x"] = ($rowTerm["lon"] - $ltLon) / $spX + $ltX;
$point["y"] = ($ltLat - $rowTerm["lat"]) / $spY + $ltY;
$shipSimbol = retShipSimbol($point, $rowTerm["direction"], 0);
if ($shipSimbol == -1)
{
$ellipSize = 8;
imagefilledellipse($img, $point["x"], $point["y"], $ellipSize, $ellipSize, $shipCol);
}
else
{
imageline($img, $shipSimbol[0]["x"], $shipSimbol[0]["y"], $shipSimbol[1]["x"], $shipSimbol[1]["y"], $shipCol);
imageline($img, $shipSimbol[2]["x"], $shipSimbol[2]["y"], $shipSimbol[3]["x"], $shipSimbol[3]["y"], $shipCol);
imageline($img, $shipSimbol[3]["x"], $shipSimbol[3]["y"], $shipSimbol[4]["x"], $shipSimbol[4]["y"], $shipCol);
imageline($img, $shipSimbol[4]["x"], $shipSimbol[4]["y"], $shipSimbol[2]["x"], $shipSimbol[2]["y"], $shipCol);
}
$length = strlen($rowTerm["terminal_name"]);
imagefilledrectangle($img, $point["x"] + 5, $point["y"] - 45, $point["x"] + 5 + ($length * 8), $point["y"] - 22, $WhiteZm);
imagerectangle($img, $point["x"] + 5, $point["y"] - 45, $point["x"] + 5 + ($length * 8), $point["y"] - 22, $shipCol);
ImageTTFText($img, 12, 0, $point["x"] + 15, $point["y"] - 27, $Black, $font1, $rowTerm["terminal_name"]);
}
// 基準点2
$point = array();
$px = ($rowTerm["lon"] - $ltLonZm) / $spXZm + $ltXZm;
$py = ($ltLatZm - $rowTerm["lat"]) / $spYZm + $ltYZm;
$point["x"] = $px * cos(deg2rad(-$ZOOM_MAP_DEGREE)) - $py * sin(deg2rad(-$ZOOM_MAP_DEGREE));
$point["y"] = $px * sin(deg2rad(-$ZOOM_MAP_DEGREE)) + $py * cos(deg2rad(-$ZOOM_MAP_DEGREE));
if (strcmp($rowTerm["android_id"], "a237b48012d8873e") != 0 && strcmp($rowTerm["android_id"], "26f784b2293665d0") != 0 && strcmp($rowTerm["android_id"], "db9739dd1cfbc823") != 0)
{
$shipSimbol = retShipSimbol($point, $rowTerm["direction"], $ZOOM_MAP_DEGREE);
if ($shipSimbol == -1)
{
$ellipSize = 8;
imagefilledellipse($zoomImg, $point["x"], $point["y"], $ellipSize, $ellipSize, $zmShipCol);
}
else
{
imageline($zoomImg, $shipSimbol[0]["x"], $shipSimbol[0]["y"], $shipSimbol[1]["x"], $shipSimbol[1]["y"], $zmShipCol);
imageline($zoomImg, $shipSimbol[2]["x"], $shipSimbol[2]["y"], $shipSimbol[3]["x"], $shipSimbol[3]["y"], $zmShipCol);
imageline($zoomImg, $shipSimbol[3]["x"], $shipSimbol[3]["y"], $shipSimbol[4]["x"], $shipSimbol[4]["y"], $zmShipCol);
imageline($zoomImg, $shipSimbol[4]["x"], $shipSimbol[4]["y"], $shipSimbol[2]["x"], $shipSimbol[2]["y"], $zmShipCol);
}
$length = strlen($rowTerm["terminal_name"]);
imagefilledrectangle($zoomImg, $point["x"] + 30, $point["y"] - 40, $point["x"] + 30 + ($length * 8), $point["y"] - 17, $White);
imagerectangle($zoomImg, $point["x"] + 30, $point["y"] - 40, $point["x"] + 30 + ($length * 8), $point["y"] - 17, $zmShipCol);
imageline($zoomImg, $point["x"] + 30, $point["y"] - 17, $point["x"], $point["y"], $zmShipCol);
ImageTTFText($zoomImg, 12, 0, $point["x"] + 40, $point["y"] - 22, $BlackZm, $font1, $rowTerm["terminal_name"]);
}
else
{
$ellipSize = 8;
imagefilledellipse($zoomImg, $point["x"], $point["y"], $ellipSize, $ellipSize, $zmSyunCol);
$length = strlen($rowTerm["terminal_name"]);
imagefilledrectangle($zoomImg, $point["x"] + 30, $point["y"] - 40, $point["x"] + 30 + ($length * 8), $point["y"] - 17, $White);
imagerectangle($zoomImg, $point["x"] + 30, $point["y"] - 40, $point["x"] + 30 + ($length * 8), $point["y"] - 17, $zmSyunCol);
imageline($zoomImg, $point["x"] + 30, $point["y"] - 17, $point["x"], $point["y"], $zmSyunCol);
ImageTTFText($zoomImg, 12, 0, $point["x"] + 40, $point["y"] - 22, $BlackZm, $font1, $rowTerm["terminal_name"]);
}
}
}
/*
//-----------------------------------------------------------------------------------
// Debug
$FUNABASHI_ROUTE_LAT = 35.59561081;
$FUNABASHI_ROUTE_LON = 139.9843314;
$COUNT_AREA = array(
array("lat" => 35.62678039, "lon" => 140.0013295),
array("lat" => 35.63562604, "lon" => 140.0137459),
array("lat" => 35.62880063, "lon" => 140.0254795),
array("lat" => 35.62017771, "lon" => 140.0109185)
);
// $COUNT_AREA = array(
// array("lat" => 35.585232, "lon" => 139.804459),
// array("lat" => 35.581812, "lon" => 139.800081),
// array("lat" => 35.579438, "lon" => 139.804716),
// array("lat" => 35.582580, "lon" => 139.808836)
// );
$xa = ($FUNABASHI_ROUTE_LON - $ltLon) / $spX + $ltX;
$ya = ($ltLat - $FUNABASHI_ROUTE_LAT) / $spY + $ltY;
imagefilledellipse($img, $xa, $ya, 8, 8, $Black);
$pointa = array();
for($iCount = 0; $iCount < 4; $iCount++)
{
$pointa[$iCount]["x"] = ($COUNT_AREA[$iCount]["lon"] - $ltLon) / $spX + $ltX;
$pointa[$iCount]["y"] = ($ltLat - $COUNT_AREA[$iCount]["lat"]) / $spY + $ltY;
if ($iCount > 0)
{
imageline($img, $pointa[$iCount]["x"], $pointa[$iCount]["y"], $pointa[$iCount - 1]["x"], $pointa[$iCount - 1]["y"], $Black);
}
if ($iCount == 3)
{
imageline($img, $pointa[$iCount]["x"], $pointa[$iCount]["y"], $pointa[0]["x"], $pointa[0]["y"], $Black);
}
}
*/
//-----------------------------------------------------------------------------------
imagerectangle($zoomImg, 0, 0, $zoomImgSize[0] - 1, $zoomImgSize[1] - 1, $BlackZm);
imagecopy($img, $zoomImg, 0, 0, 0, 0, $zoomImgSize[0], $zoomImgSize[1]);
// ===============================================
// 描画した画像を保存 & パレットを削除
// 備考 ：
// 更新 ： 2010/09/08 KMK T.Teraoka
// ===============================================
imagepng($img, $imgFileName);
imagedestroy($img);
imagedestroy($zoomImg);
imagedestroy($src);
imagedestroy($src2);
// ===============================================
// 上で保存した画像を表示
// 備考 ：
// 更新 ： 2010/09/08 KMK T.Teraoka
// ===============================================
print "<table border=\"0\" bgcolor=\"#000000\" cellspacing=\"0\" cellpadding=\"0\">";
print "<tr>";
print "<td>";
print "<table border=\"0\" bgcolor=\"#000000\" cellspacing=\"1\" cellpadding=\"0\">";
print "<tr>";
print "<td>";
print "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\">";
print "<tr bgcolor=\"#FFFFFF\">";
// print "<td align=\"left\">";
print "<td >";
// print "<img src=\"". $imgFileName. "?t=$now_t\" galleryimg=\"no\" width=\"881\" height=\"590\">";
print "<img src=\"". $imgFileName. "?t=$now_t\" galleryimg=\"no\" width=\"638\" height=\"448\">";
print "</td>";
//print "<td align=\"left\" valign=\"top\">";
for($iCount = 0; $iCount < $row; $iCount++)
{
$rowTerm = pg_fetch_array($resTerm, $iCount, PGSQL_ASSOC);
if($iCount % 25 == 0) print "<td align=\"left\" valign=\"top\">";
$Data = sprintf("%02d", $iCount + 1);
print "●" .$Data ."<br />";
if(($iCount+1) % 25 == 0) print "</td><td> </td><td> </td>";
}
//print "</td>";
/*
print "<td align=\"left\" valign=\"top\">";
print "<br />";
// ===============================================
// 帳票出力Formの作成
// 備考 ：
// 更新 ： 2013/06/17 KMK T.Teraoka
// ===============================================
print "<form action=\"". "../output/transport/output.php". "\" method=\"post\" style=\"display:inline\">";
print "<input type=\"submit\" name=\"btnPrint\" value=\"csv出力\" style=\"width:90px\">";
print "<br />";
print "<br />";
$nowDate = explode(",", date("m,d", time()));
print "<input type=\"text\" name=\"txtTargetM\" value=\"". $nowDate[0]. "\" maxlength=\"2\" style=\"width:20px\">";
print " 月";
print " ";
print "<input type=\"text\" name=\"txtTargetD\" value=\"". $nowDate[1]. "\" maxlength=\"2\" style=\"width:20px\">";
print " 日";
print "</form>";
print "</td>";
*/
/*
print "<td align=\"left\" valign=\"top\">";
for($iCount = 0; $iCount < $row; $iCount++)
{
$rowTerm = pg_fetch_array($resTerm, $iCount, PGSQL_ASSOC);
$Data = sprintf("%02d", $iCount + 1);
print $Data ."<br />";
}
print "</td>";
*/
print "</tr>";
print "</table>";
print "</td>";
print "</tr>";
print "</table>";
print "</td>";
print "</tr>";
print "</table>";
}
catch(Exception $exc)
{
$_log->write($exc->getMessage(). "\n");
}
// 戻る
//print "<br />";
print "<a href=\"../index.php\">戻る</a>";
//===============================================
// Postgresql終了処理
// 備考 ：
// 更新 ： 2012/10/19 KMK-Teraoka
//===============================================
pg_close($conn);
//===============================================
// HTML終了処理
// 備考 ：
// 更新 ： 2012/10/18 KMK-Teraoka
//===============================================
print "</body>";
print "</html>";
?>