". $SCRIPT_TITLE. "

"; print ""; //print ""; //print ""; print ""; print ""; print "". $SCRIPT_TITLE. ""; //print ""; //print ""; //print ""; //print ""; //print ""; //print ""; print ""; //=============================================== // HTML-BODY部開始- // 備考： // 更新： 2012/10/18 KMK-Teraoka //=============================================== print ""; /* print ""; print ""; print ""; print "". $SCRIPT_TITLE. "
"; print ""; print ""; print ""; */ ?> "; if($del) { $DelArea = "UPDATE qgis.area_status_2 SET "; $DelArea .= "del_flg = 'TRUE' "; $DelArea .= " WHERE list_id =" .$del .";"; //$_log->write($selTerm. "\n"); if (!($resDelArea = pg_query($conn, $DelArea))) { // print pg_last_error() ."
"; // throw new Exception("データ取得に失敗
". $DelArea. "
". pg_last_error(). "
"); } $selArea = "SELECT * FROM qgis.area_status_2"; $selArea .= " WHERE const_id='". $CONST_ID. "'"; $selArea .= " AND app_id='". $APPLICATION_ID. "'"; $selArea .= " AND del_flg = FALSE"; $selArea .= " ORDER BY list_id"; $selArea .= ";"; //print $selArea ."
"; if (!($resArea = pg_query($conn, $selArea))) { //throw new Exception("データ取得に失敗
". $resArea. "
". pg_last_error(). "
"); //print pg_last_error() ; } $rowA = pg_num_rows($resArea); $fp = fopen($AreaFileName, "w"); for($iCount = 0; $iCount < $rowA; $iCount++) { $rowArea = pg_fetch_array($resArea, $iCount, PGSQL_ASSOC); $OutputData .= $rowArea['lat1'] ."," .$rowArea['lon1'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name']; $OutputData .= "#" .$rowArea['lat2'] ."," .$rowArea['lon2'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name']; $OutputData .= "#" .$rowArea['lat3'] ."," .$rowArea['lon3'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name']; $OutputData .= ($rowArea['lat4']) ? "#" .$rowArea['lat4'] ."," .$rowArea['lon4'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; $OutputData .= ($rowArea['lat5']) ? "#" .$rowArea['lat5'] ."," .$rowArea['lon5'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; $OutputData .= ($rowArea['lat6']) ? "#" .$rowArea['lat6'] ."," .$rowArea['lon6'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; $OutputData .= ($rowArea['lat7']) ? "#" .$rowArea['lat7'] ."," .$rowArea['lon7'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; $OutputData .= ($rowArea['lat8']) ? "#" .$rowArea['lat8'] ."," .$rowArea['lon8'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; $OutputData .= ($rowArea['lat9']) ? "#" .$rowArea['lat9'] ."," .$rowArea['lon9'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; $OutputData .= ($rowArea['lat10']) ? "#" .$rowArea['lat10'] ."," .$rowArea['lon10'] ."," .$rowArea['list_id'] ."," .$rowArea['legend_color']."," .$rowArea['area_name'] :""; if(($rowA-1) != $iCount) $OutputData .= "#"; } fwrite($fp, $OutputData); fclose($fp); } //20151001 追加 // $AreaData = file_get_contents($AreaFileName); // $Area = split("#", $AreaData); // =============================================== // 基準点情報 // 備考： // 更新： 2012/11/29 KMK-Teraoka // =============================================== // $ltLon = 140.62380; //経度(左上) // $ltLat = 36.42613; //緯度(左上) // $rbLon = 140.61533; //経度(右下) // $rbLat = 36.41504; //緯度(右下) // $ltX = 112; // 左上X座標 // $ltY = 359; // 左上Y座標 // $rbX = 929; // 右下X座標 // $rbY = 854; // 右下Y座標 $ltLon = 140.62993; //経度(左上) $ltLat = 36.42755; //緯度(左上) $rbLon = 140.61488; //経度(右下) $rbLat = 36.41410; //緯度(右下) $ltX = 5; // 左上X座標 $ltY = 2; // 左上Y座標 $rbX = 1152; // 右下X座標 $rbY = 1021; // 右下Y座標 //0,40,36.42829978,140.62994 //1227,935,36.4056804,140.6091508 $ltLon = 140.62994; //経度(左上) $ltLat = 36.42829978; //緯度(左上) $rbLon = 140.6091508; //経度(右下) $rbLat = 36.4056804; //緯度(右下) $ltX = 0; // 左上X座標 $ltY = 40; // 左上Y座標 $rbX = 1227; // 右下X座標 $rbY = 935; // 右下Y座標 $diffX = $rbX - $ltX; // X座標ピクセルの差を求める $diffY = $rbY - $ltY; // Y座標ピクセルの差を求める $spX = number_format(($rbLat - $ltLat) / $diffX, 10); // X座標の倍率を求める // $spY = number_format(($ltLat - $rbLat) / $diffY, 10); // Y座標の倍率を求める $spY = number_format(($rbLon - $ltLon) / $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); //20151001 $AreaData = file_get_contents($AreaFileName); $Area = split("#", $AreaData); $Act = count($Area); $AreaCt = 1; $AreaNo2 = 0; if($Act > 2) { $values = array(); for($AA = 0;$AA < $Act;$AA++) { $Adata =split(",", $Area[$AA]); if(($AA + 1) < $Act) { $Adata2 = split(",", $Area[$AA+1]); $AreaNo2 = $Adata2[2]; } else { $AreaNo2 = 0; } $values[] = ($Adata[0]-$ltLat) / $spX + $ltX; $values[] = ($Adata[1]- $ltLon) / $spY + $ltY; if(($Adata[2] != $AreaNo2)) { $SetColor = ColorConvert($Adata[3]); $AreaCol = imagecolorallocate($img, $SetColor[0],$SetColor[1],$SetColor[2]); $AreaAlpha = imagecolorallocatealpha($img, $SetColor[0],$SetColor[1],$SetColor[2], 75); imagefilledpolygon($img, $values, $AreaCt, $AreaAlpha); imagepolygon($img, $values, $AreaCt, $AreaCol); $values = array(); $AreaCt = 1; } else { $AreaCt += 1; } } } // =============================================== // 位置を取得する // 備考： // 更新： 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 mesdatetime >= '". $ENABLE_DATETIME. "'"; $selTerm .= " AND mesdatetime > '". $RTime. "'"; $selTerm .= " ORDER BY android_id"; $selTerm .= ";"; //$_log->write($selTerm. "\n"); 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, 300, 200, $Black, $font1, $spX ."__" .$spY); 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; // $rowTerm["lon"] = $point["x"] * $spX - $ltX * $spX + $ltLon; // $rowTerm["lat"] = $ltLat - $point["y"] * $spY + $ltY*$spY $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, $White); 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, $Black, $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, $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($zoomImg); imagedestroy($src); // imagedestroy($src2); // =============================================== // 上で保存した画像を表示 // 備考： // 更新： 2010/09/08 KMK T.Teraoka // =============================================== // print "

"; // print "

"; // print ""; /* if (file_exists($imgFileName)) { echo "$imgFileName が存在します"; } else { echo "$imgFileName は存在しません"; } */ print ""; print "

"; print "

"; print "

"; print ""; // print " "; // print "エリア名称 設定色
"; print "

"; print "

"; print "

"; // =============================================== // 帳票出力Formの作成 // 備考： // 更新： 2013/06/17 KMK T.Teraoka // =============================================== $selArea = "SELECT * FROM qgis.area_status_2"; $selArea .= " WHERE const_id='". $CONST_ID. "'"; $selArea .= " AND app_id='". $APPLICATION_ID. "'"; $selArea .= " AND del_flg='FALSE'"; //$selArea .= " AND mesdatetime >= '". $ENABLE_DATETIME. "'"; $selArea .= " ORDER BY list_id"; $selArea .= ";"; if (!($resArea = pg_query($conn, $selArea))) { throw new Exception("データ取得に失敗
". $resTerm. "
". pg_last_error(). "
"); } $rowA = pg_num_rows($resArea); // print "    "; print "
"; print ""; for($iCount = 0; $iCount < $rowA; $iCount++) { $rowArea = pg_fetch_array($resArea, $iCount, PGSQL_ASSOC); // print ""; print ""; print ""; } print "
"; print "
"; print "" .$rowArea['area_name'] .""; 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 ""; ?>