![](\"https://doitwell.app/img/appstore.png\")
";
$playstore = "![](\"https://doitwell.app/img/playstore.png\")
";
$qEncodedStr = "";
// die("DEBUG...");
$qRet = array();
// 預設值
$qLat = "24.688049814640937";
$qLon = "120.88507019431584";
// id:50282141 sid:09
$qID = "50282141";
$qSID = "09";
$qDefaultIDFile = "/mnt/cache.cctvs/speedCameras/defaultID.txt";
if (file_exists($qDefaultIDFile)) {
$qContent = file_get_contents($qDefaultIDFile);
$qTokens = preg_split("@\s+@", $qContent);
if (strlen($qTokens[0])==8 and strlen($qTokens[1])==2) {
$qID = $qTokens[0];
$qSID = $qTokens[1];
}
}
if (isset($_REQUEST['id']) and strlen(preg_replace("@[^0-9]@", "", $_REQUEST['id']))==10)
{
$qRealID = preg_replace("@[^0-9]@", "", $_REQUEST['id']);
$qID = substr($qRealID, 0, 8);
$qSID = substr($qRealID, 8, 2);
if (!file_exists($qDefaultIDFile) or filemtime($qDefaultIDFile)query("SET NAMES utf8mb4");
$mysqli->query("SET CHARACTER_SET_CLIENT=utf8mb4");
$mysqli->query("SET CHARACTER_SET_CLIENT=utf8mb4");
$mysqli_threadID = $mysqli->thread_id; // 重要，需要這個才能真正 kill, 有時 close 是不夠的
$qNearMarkers = array();
if (isset($_REQUEST['loc']) and isset($qLat) and isset($qLon))
{
$sql = "SELECT *,1.60934*3956 * 2 * ASIN(SQRT( POWER(SIN((". $qLat ."-abs(lat)) * pi()/180 / 2),2) + COS(". $qLat ." * pi()/180 ) * COS(abs(lat)* pi()/180) * POWER(SIN((". $qLon ." - lon) * pi()/180 / 2), 2) )) AS absDist";
$sql .= " FROM cctvs";
$sql .= " WHERE id LIKE 'speed_%'";
$sql .= " AND note NOT LIKE '%移動式%'";
$sql .= " ORDER BY absDist LIMIT 1";
if ($result = $mysqli->query($sql)) {
while ($row = $result->fetch_assoc()) {
$qID = preg_replace("@[^0-9]+@", "",$row['id']);
$qSID = $row['sid'];
}
}
/* close connection */
$mysqli->kill($mysqli_threadID);
$mysqli->close();
header("Location: https://cctvs.doitwell.tw/speedCameras/". $qID .$qSID);
die("Redirect");
} else {
// $_REQUEST['id']
$sql = "SELECT *";
$sql .= " FROM cctvs";
$sql .= " WHERE id LIKE 'speed_". $qID ."'";
$sql .= " AND note NOT LIKE '%移動式%'";
$sql .= " AND sid LIKE '". $qSID ."'";
if ($result = $mysqli->query($sql)) {
if ($row = $result->fetch_assoc()) {
$qLat = $row['lat'];
$qLon = $row['lon'];
}
}
$sql = "SELECT *,1.60934*3956 * 2 * ASIN(SQRT( POWER(SIN((". $qLat ."-abs(lat)) * pi()/180 / 2),2) + COS(". $qLat ." * pi()/180 ) * COS(abs(lat)* pi()/180) * POWER(SIN((". $qLon ." - lon) * pi()/180 / 2), 2) )) AS absDist";
$sql .= " FROM cctvs";
$sql .= " WHERE id LIKE 'speed_%'";
$sql .= " AND note NOT LIKE '%移動式%'";
$sql .= " ORDER BY absDist LIMIT 10";
if ($result = $mysqli->query($sql)) {
while ($row = $result->fetch_assoc())
{
$qTempBearing = preg_replace("@正斜@misuU","雙向",$row['bearing']);
$qTempBearing = preg_replace("@反斜@misuU","雙向",$qTempBearing);
// $qTempNote += "@";
array_push($qNearMarkers, array($row['lat'], $row['lon'], $row['note']."\n".$qTempBearing."\n".$row['url'], $row['id'], $row['sid']));
}
} else {
// printf("Errormessage: %s\n", $mysqli->error);
}
}
/* close connection */
$mysqli->kill($mysqli_threadID);
$mysqli->close();
$qFirstTouched = false;
foreach ($qNearMarkers as $qOne) {
if (!$qFirstTouched) {
$qFirstTouched = true;
$qLat = $qOne[0];
$qLon = $qOne[1];
$qLabel = preg_replace('/\s+/', ' ', $qOne[2]);
break;
}
}
// die("DEBUG...");
?>
測速照相地點 (<?php echo $qLabel; ?>) (即時路況影像App 提供)
附近測速照相地點
$qLabel";
}
?>
打開定位即實際地圖上繪製所在地中心附近的攝影機監視器、警廣路況、測速照相站點，快速了解各地的路況，並且可縮放地圖，不再是小小的縮小圖，快速了解各地的路況、附近旅遊景點說明，以及基本天氣資料。另外提供行車測速模式，可播報行車沿路之測速照相站點以及攝影機。
