** ); **/ $lat = $postArr['Location_X']; $lng = $postArr['Location_Y']; $query = 'SELECT * FROM shops WHERE active = 1'; if (!$mysql->query($query)) { throw new Exception($mysql->error); } if ($mysql->num_row > 0) { $transaction = array('user_id' => $postArr['FromUserName'], 'MsgId' => null, 'media_id' => null, 'keyword_id' => null, 'media_type' => $wechat::MSGTYPE_NEWS, 'request' => 0, 'content' => null, 'raw_data' => null); $shops = $mysql->data; $shoplist = array(); $dataSet = array('type' => 'news'); for ($i = 0; $i < count($shops); $i++) { # calculate the distance $distance = distanceCalculation($lat, $lng, $shops[$i]['latitude'], $shops[$i]['longitude']); $shops[$i]['distance'] = $distance; array_push($shoplist, $shops); } # sort by distance usort($shops, "compare_distance"); $url = 'http://apis.map.qq.com/uri/v1/marker?marker=coord:%s,%s;title:%s;addr:%s'; for ($k = 0; $k < 10 && $k < count($shops); $k++) { $transaction['content'] .= $shops[$k]['name'] . "\r\n"; $addr = preg_replace("/(\r|\n)/m", ' ', $shops[$k]['address']); $dataSet['articles'][] = array('title' => $shops[$k]['name'], 'digest' => $shops[$k]['address'], 'thumb' => $SYSCONFIG['SERVER']['baseUrl'] . 'upload/image/' . $shops[$k]['cover'], 'url' => sprintf($url, $shops[$k]['latitude'], $shops[$k]['longitude'], $shops[$k]['name'], $addr)); } $responseXML = buildXML($postArr['FromUserName'], $postArr['ToUserName'], $dataSet); $transaction['raw_data'] = $wechat->raw_json_encode($dataSet); log_transaction($transaction); }
echo '</div>'; } echo '</div>'; /*{{content['.$i.']['.$j.']}}*/ /* $link = mysqli_connect("127.0.0.1", "jeremix", "Bn@n@s666", "bnanas"); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; */ $p1 = array("lat" => "38.5836479", "lng" => "-7.9069337"); //Evora $p2 = array("lat" => "48.8666667", "lng" => "2.3333333"); // Paris $km = distanceCalculation($p1, $p2, 2); // Calculate distance in kilometres (default) //echo $km; function distanceCalculation($point1, $point2, $decimals) { // Calculate the distance in degrees $degrees = rad2deg(acos(sin(deg2rad($point1['lat'])) * sin(deg2rad($point2['lat'])) + cos(deg2rad($point1['lat'])) * cos(deg2rad($point2['lat'])) * cos(deg2rad($point1['lng'] - $point2['lng'])))); return round($degrees * 111.13384, $decimals); } ?> <script> function changeMonth(value){ $('.mainCalendarContainer').load('calendar.php?m='+value); } function makeCalendarclickable(){
$kml_loop = 0; $kml_grab = 4; $long_grab = 5; $lat_1_set = explode(" ", $kml_split[2]); $lat_1 = $lat_1_set[1]; $long_1 = $kml_split[3]; $total_km = 0; while ($kml_loop < $kml_length) { $alt_split = explode(" ", $kml_split[$kml_grab]); $kml_alt = $alt_split[0]; $lat_2 = $alt_split[1]; $long_2 = $kml_split[$long_grab]; if ($long_2 == '') { $kml_loop = $kml_length + 10; } else { $km = distanceCalculation($lat_1, $long_1, $lat_2, $long_2); $total_km = $total_km + round($km, 1); $massive_kml = $massive_kml . "[" . round($total_km) . ", " . round($kml_alt, 1) . "],"; $kml_loop++; $kml_grab = $kml_grab + 2; $lat_1 = $lat_2; $long_1 = $long_2; $long_grab = $long_grab + 2; } } ?> <script type="text/javascript"> google.load("visualization", "1", {packages: ["corechart"]}); google.setOnLoadCallback(drawChart);