** );
**/
$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);
