"; print ""; //print ""; print ""; print ""; print ""; print ""; print ""; //=============================================== // HTML-BODY部開始- // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; print ""; print ""; print "". $SCRIPT_TITLE. "
"; print ""; print ""; print ""; 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 = 140.61044; //経度(左上) // $ltLat = 36.41828; //緯度(左上) // $rbLon = 140.61207; //経度(右下) // $rbLat = 36.42019; //緯度(右下) $ltLon = 140.61207; //経度(左上) $ltLat = 36.42019; //緯度(左上) $rbLon = 140.61044; //経度(右下) $rbLat = 36.41828; //緯度(右下) $ltX = 386; // 左上X座標 $ltY = 257; // 左上Y座標 $rbX = 841; // 右下X座標 $rbY = 566; // 右下Y座標 $diffX = $rbX - $ltX; // X座標ピクセルの差を求める $diffY = $rbY - $ltY; // Y座標ピクセルの差を求める // $spX = number_format(($rbLon - $ltLon) / $diffX, 10); // X座標の倍率を求める // $spY = number_format(($rbLat - $ltLat) / $diffY, 10); // Y座標の倍率を求める $spX = number_format(($rbLat - $ltLat) / $diffX, 10); // X座標の倍率を求める $spY = number_format(($rbLon - $ltLon) / $diffY, 10); // Y座標の倍率を求める // =============================================== // GD処理準備 // 備考 ： // 更新 ： 2010/09/08 KMK T.Teraoka // =============================================== $src = ImageCreateFromPNG($MAP_NAME); //パレットへ貼り付ける画像指定(地図画像) $img = imagecreatetruecolor($imgSize[0], $imgSize[1]); //パレットの作成 imagecopy($img, $src, 0, 0, 0, 0, $imgSize[0], $imgSize[1]); //画像をパレットへ貼り付け $font1 = "/usr/share/fonts/vlgothic/VL-Gothic-Regular.ttf"; imagesetthickness($img, $THIC); imagesetthickness($img, $THIC); // 使用色の準備 $Black = imagecolorallocate($img, 0,0,0); $White = imagecolorallocate($img, 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 // =============================================== $RTime = date("Y-m-d H:i:s" ,time() - 600); $selTerm = "SELECT * FROM qgis.ts_terminal"; $selTerm .= " WHERE const_id='". $CONST_ID. "'"; $selTerm .= " AND app_id='". $APPLICATION_ID. "'"; // $selTerm .= " AND android_id='a5e4f91fce680532'"; //$selTerm .= " AND mesdatetime >= '". $ENABLE_DATETIME. "'"; $selTerm .= " AND mesdatetime > '". $RTime. "'"; $selTerm .= " ORDER BY android_id"; $selTerm .= ";"; //$_log->write($selTerm. "\n"); // ImageTTFText($img, 12, 0, 500, 400, $Black, $font1, $Area[1] ."__" .$Area[0]); // ImageTTFText($img, 12, 0, 500, 420, $Black, $font1, $Area[3] ."__" .$Area[2]); // ImageTTFText($img, 12, 0, 500, 440, $Black, $font1, $Area[5] ."__" .$Area[4]); // ImageTTFText($img, 12, 0, 500, 460, $Black, $font1, $Area[7] ."__" .$Area[6]); if (!($resTerm = pg_query($conn, $selTerm))) { throw new Exception("データ取得に失敗
". $resTerm. "
". pg_last_error(). "
"); } $shipCol = imagecolorallocate($img, 255, 165, 0); $zmShipCol = imagecolorallocate($img, 255, 165, 0); $zmSyunCol = imagecolorallocate($img, 0, 102, 253); $row = pg_num_rows($resTerm); //ImageTTFText($img, 12, 0, 500, 400, $Black, $font1, $row); 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) { $point = array(); $point["x"] = ($rowTerm["lat"] - $ltLat) / $spX + $ltX; $point["y"] = ($rowTerm["lon"] - $ltLon) / $spY + $ltY; imagefilledellipse($img, $point["x"], $point["y"], 15, 15, $shipCol); //ImageTTFText($img, 12, 0, 500, 400, $Black, $font1, $point["x"] ."__" .$point["y"]); /* $shipSimbol = retShipSimbol($point, $rowTerm["direction"], 0); if ($shipSimbol == -1) { $ellipSize = 8; imagefilledellipse($img, $point["x"], $point["y"], $ellipSize, $ellipSize, $shipCol); } else { imagefilledellipse($img, $point["x"], $point["y"], 15, 15, $shipCol); //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 * 9), $point["y"] - 22, $White); imagerectangle($img, $point["x"] + 5, $point["y"] - 45, $point["x"] + 5 + ($length * 9), $point["y"] - 22, $shipCol); ImageTTFText($img, 12, 0, $point["x"] + 15, $point["y"] - 27, $Black, $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($src); print ""; // =============================================== // 上で保存した画像を表示 // 備考 ： // 更新 ： 2010/09/08 KMK T.Teraoka // =============================================== print ""; print ""; print ""; print ""; print "

"; print ""; print ""; print ""; print ""; print " "; print ""; print ""; print ""; print ""; print ""; print " "; // print ""; // print ""; print ""; print " "; print " "; print " "; print " "; print "

"; } catch(Exception $exc) { $_log->write($exc->getMessage(). "\n"); } // 戻る //print "
"; print "戻る"; //=============================================== // Postgresql終了処理 // 備考 ： // 更新 ： 2012/10/19 KMK-Teraoka //=============================================== pg_close($conn); //=============================================== // HTML終了処理 // 備考 ： // 更新 ： 2012/10/18 KMK-Teraoka //=============================================== print ""; print ""; ?>