<?php
require("../inc/common.inc.php");

//获取版本号
if($action == 'getVersion' && $version != '' && $verifier != ''){	
	$msg = array('status'=>'','reason'=>'','downurl'=>'');
	if(md5($version) != $verifier){
		$msg['status'] = '0';
		$msg['reasion'] = '非法操作!';
		echo json_encode($msg);
		exit();
	}

	$rs = $db->excu("SELECT TOP 1 * FROM mx_wifi_assistant ORDER BY pub_date desc");
	$rsdb = $db->fetch_array($rs);
	
	if(trim($rsdb['version']) == $version){
		$msg['status'] = '1';
		$msg['reason'] = '您的版本已经是最新版本';
		echo json_encode($msg);
		exit();
	}
	elseif(trim($rsdb['version']) != $version && !empty($version)){
		$msg['status'] = '2';		
		$msg['downurl'] = $rsdb['downurl'];
		echo json_encode($msg);
		exit();
	}
	
}

//获取商户ID
if($action == 'getShanghuInfo' && !empty($rid) && trim($ssid) != '' && $verifier != ''){	
	$msg = array('status'=>'','reason'=>'','host'=>'','shanghuinfo'=>'');
	if(md5($rid.$ssid) != $verifier){
		$msg['status'] = '0';
		$msg['reasion'] = '非法操作!';
		echo json_encode($msg);
		exit();
	}
	$shanghuid = 0;
	$ssid = iconv('utf-8','gb2312',$ssid);
	$shanghuid = $db->getsingle("SELECT TOP 1 shanghuid FROM mx_shebei WHERE ssid = '$ssid' and id = '$rid'");
	
	if($shanghuid == 0){
		$msg['status'] = '1';
		$msg['reason'] = '未找到相应商户ID';
		echo json_encode($msg);
		exit();
	}
	
	//获取商户信息
	$rs = $db->excu("SELECT TOP 1 id,srealname,zuobiao,address,logo,tel from MX_SHANGHU where id = '$shanghuid'");
	
	$rsdb = mssql_fetch_assoc($rs);	
	if(trim($rsdb['logo']) != ''){	
		$rsdb['logo'] = '/upload_files/'.$rsdb['logo'];	
	}else{
		$rsdb['logo'] = 'http://guanjia.20080531.com/images/nopic.png';
	}
	//$rsdb['srealname'] = urlencode($rsdb['srealname']);
	$rsdb['srealname'] = iconv('gb2312','utf-8',$rsdb['srealname']);
	if(trim($rsdb['gotourl']) == ''){
	 $msg['host'] = 'http://guanjia.20080531.com/';
	}else{
		$msg['host'] = $rsdb['gotourl'] ;
	}
	$msg['status'] = '2';			
	$msg['shanghuinfo'] = $rsdb;	
	echo urldecode(json_encode($msg));
	exit();
	
}

//插入安装时间


if($action == 'UpdateInsDate' && $mobile != '' && $version != '' && $verifier != ''){

	$msg = array('status'=>'','reason'=>'');
	if(md5($mobile.$version) != $verifier){
		$msg['status'] = '0';
		$msg['reasion'] = '非法操作!';
		echo json_encode($msg);
		exit();
	}

	$insDate = date('Y-m-d H:i:s',time());
	//echo "update mx_shang_maclist set app_ins_date = '$insDate',app_version='$version' WHERE mobile = '$mobile'";
	$address = iconv('utf-8','gb2312',$address);

	$rs = $db->excu("INSERT INTO mx_wifi_inslog (mobile,ins_date,version,address) values ('$mobile','$insDate','$version','$address')");
	
	$msg['status'] = '2';
	$msg['reason'] = '成功';
	echo json_encode($msg);
	exit();
	
}

//获取安装时间

if($action == 'getInsDate' && $mobile != '' && $verifier != ''){

	$msg = array('status'=>'','reason'=>'','installDate'=>'');
	if(md5($mobile) != $verifier){
		$msg['status'] = '0';
		$msg['reasion'] = '非法操作!';
		echo json_encode($msg);
		exit();
	}
	if($mobile != '0'){
		if(preg_match("/^13[0-9]{1}[0-9]{8}$|15[0-9]{1}[0-9]{8}$|18[0-9]{1}[0-9]{8}$/",$mobile)){}
		else{
$msg['status'] = '0';
$msg['reason'] = '手机号码格式不正确!';
			echo json_encode($msg);
			exit();
		}
	}
$rs = $db->excu("SELECT TOP 1 * FROM mx_shang_maclist WHERE mobile = '$mobile'");
$rsdb = $db->fetch_array($rs);

	if(trim($rsdb['app_ins_date']) != ''){
$msg['status'] = '2';
$msg['reasion'] = '成功';
$msg['installDate'] = $rsdb['app_ins_date'];		
		echo json_encode($msg);
		exit();
	}	
	else{
$msg['status'] = '1';
$msg['reason'] = '未找到';
$msg['installDate'] = '';		
		echo json_encode($msg);
		exit();
	}

}

//获取区域内热点
if($action == 'getHotspot' && $scope != '' && $verifier != '' ){	

	//$aaa = array(array('117.067097','36.707053'),array('117.067099','36.707055'));

// $scope = '[{"latitude":"117.067097","longitude":"36.707053"},{"latitude":"117.067099","longitude":"36.707055"}]';

$scopearr = array();
$scope = stripslashes($scope);
$scopearr = json_decode($scope,true);

//	echo $scopearr[0]['latitude'];

$msg = array('status'=>'','reason'=>'','scopes'=>'');

/*	if(md5($scope) != $verifier){
$msg['status'] = '0';
$msg['reason'] = '非法操作!';
		echo json_encode($msg);
		exit();
	}
*/

$rs = $db->excu("SELECT srealname,zuobiao,address,logo,tel from MX_SHANGHU where SUBSTRING(zuobiao,1,charindex(',',zuobiao)-1) > '".$scopearr[0]['longitude']."' and SUBSTRING(zuobiao,1,charindex(',',zuobiao)-1) < '".$scopearr[1]['longitude']."' and SUBSTRING(zuobiao,charindex(',',zuobiao)+2,len(zuobiao)) > '".$scopearr[1]['latitude']."' and SUBSTRING(zuobiao,charindex(',',zuobiao)+2,len(zuobiao)) < '".$scopearr[0]['latitude']."'");


	if($db->num_rows($rs) <= 0){
$msg['status'] = '1';
$msg['reason'] = '您所在区域内还没有wifi热点';
		echo json_encode($msg);
		exit();
	}
$scopes = array();
	while($rsdb = mssql_fetch_assoc($rs)){
		if($rsdb['srealname'] != ''){
$rsdb['srealname'] = iconv('gb2312','utf-8',$rsdb['srealname']);
		}
$rsdb['address'] = iconv('gb2312','utf-8',$rsdb['address']);
		if(trim($rsdb['logo'])!=''){
$rsdb['logo'] = '/upload_files/'.$rsdb['logo'];	
		}

$scopes[] = $rsdb;
	}

//	echo json_encode($scopes);
$msg['status'] = '2';
$msg['reason'] = '';
$msg['scopes'] = $scopes;


	echo json_encode($msg);
	exit();

}
?>