<?php include "../inc/odbc.php"; ?>
|
<?php include "../inc/function.php"; ?>
|
<?php
|
$OrdID=empty($_REQUEST['OrdID'])!=false ? "" : $_REQUEST['OrdID'];
|
$time=empty($_REQUEST['UnixTime'])!=false ? "" : $_REQUEST['UnixTime'];
|
$sign=empty($_REQUEST['Sign'])!=false ? "" : $_REQUEST['Sign'];
|
$errcode=1;
|
$DispatchOrdState=0;
|
if ($OrdID=="" or $time=="" or $sign==""){
|
$errcode=40010;
|
$errmsg="invalid OrdID";
|
}
|
if ($sign!=MD5($OrdID.$time.$GPSKey)){
|
//$errcode=40005;
|
//$errmsg="invalid Sign";
|
}
|
|
//获取GPS access_token
|
Function GetAccess_token() {
|
$access_tokenID=4039; //对应数据库ID
|
global $conn;
|
global $account;
|
global $accountpass;
|
$sql = "select vtext,vMono from dictionary where id=".$access_tokenID;
|
//echo $sql;exit;
|
$dataDt = sqlsrv_query($conn,$sql);
|
if($dataDt == true){
|
while($rs = sqlsrv_fetch_array( $dataDt, SQLSRV_FETCH_ASSOC) ) {
|
$access_token=$rs['vtext'];
|
$access_token_time=$rs['vMono'];
|
if(strtotime($access_token_time)<strtotime(date("y-m-d h:i:s"))){
|
$data_url="http://api.gpsoo.net/1/auth/access_token?account=".$account."&time=".time()."&signature=".MD5(MD5($accountpass).time());
|
//echo $data_url;exit;
|
$datainfo=file_get_contents($data_url);
|
$datainfo=json_decode($datainfo,true);
|
if ($datainfo['ret']==0){
|
$access_token=$datainfo['access_token'];
|
$sql="update dictionary set vtext='".$access_token."',vMono='".date("Y-m-d H:i:s",time()+7200)."' where id=".$access_tokenID;
|
$UPsql = sqlsrv_query($conn,$sql);
|
}else{
|
$errcode=40014;
|
$errmsg="GPS信息查询失败";
|
}
|
}
|
}
|
}
|
return $access_token;
|
}
|
|
if ($errcode==1) {
|
//调度单数据
|
//$sql="select DispatchOrdCarID from DispatchOrd where DispatchOrdState>=6 and DispatchOrdState<7 and DispatchOrdID=".$OrdID;
|
$sql="select DispatchOrdID,DispatchOrdCarID,CarLicense,DispatchOrdTraStreet,DispatchOrdTraVia,DispatchOrdTraEnd,DispatchOrdState from DispatchOrd,CarData where CarID=DispatchOrdCarID and DispatchOrdID=".$OrdID;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$CarID = $rs['DispatchOrdCarID']; //派遣车辆ID
|
$CarLicense = $rs['CarLicense']; //派遣车车辆牌
|
$webJson['CarLicense']=str_ireplace("（奔驰）","",$CarLicense);
|
$DispatchOrdTraStreet = $rs['DispatchOrdTraStreet'];//出发地
|
$DispatchOrdTraVia = $rs['DispatchOrdTraVia']; //途经
|
$DispatchOrdTraEnd = $rs['DispatchOrdTraEnd']; //目的地
|
$DispatchOrdState = $rs['DispatchOrdState']; //调度单状态
|
$webJson['DispatchOrdState']=$DispatchOrdState;
|
if ($DispatchOrdTraVia!=''){
|
$webJson['TraStreet'] = $DispatchOrdTraVia;
|
$webJson['TraEnd'] = $DispatchOrdTraEnd;
|
}else{
|
$webJson['TraStreet'] = $DispatchOrdTraStreet;
|
$webJson['TraEnd'] = $DispatchOrdTraEnd;
|
}
|
}
|
}else{
|
$errcode=40011;
|
$errmsg="转运未出车或已完成";
|
}
|
}
|
if ($errcode==1) {
|
//医院详细地址
|
$TraStreet=$webJson['TraStreet'];
|
$TraEnd=$webJson['TraEnd'];
|
if ($TraStreet!=''){
|
$sql="select TraStreet=(HopsProvince+HopsCity+HopsArea+HospAddress) from HospData where HospState=1 and HospName='".$TraStreet."'";
|
//echo $sql;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$TraStreet = $rs['TraStreet'];
|
}
|
}
|
}
|
}
|
if ($TraEnd!=''){
|
$sql="select TraEnd=(HopsProvince+HopsCity+HopsArea+HospAddress) from HospData where HospState=1 and HospName='".$TraEnd."'";
|
//echo $sql;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$TraEnd = $rs['TraEnd'];
|
}
|
}
|
}
|
}
|
|
//车辆数据
|
$sql="select CarLicense,GPS_IMEI from CarData where CarID=".$CarID;
|
//echo $sql;
|
$data = sqlsrv_query($conn,$sql);
|
if($data == true){
|
if (sqlsrv_rows_affected($data)!=0) {
|
while($rs = sqlsrv_fetch_array($data) ) {
|
$CarLicense = $rs['CarLicense'];
|
$imeis = $rs['GPS_IMEI'];
|
}
|
}else{
|
$errcode=40012;
|
$errmsg="车辆信息查询失败";
|
}
|
}
|
}
|
|
if ($errcode==1) {
|
if ($DispatchOrdState<7){
|
//当前GPS接口信息
|
$account="966120";
|
$accountpass="new966120";
|
$access_token=GetAccess_token();
|
$data_url='http://api.gpsoo.net/1/devices/tracking?access_token='.$access_token."&imeis=".$imeis."&map_type=BAIDU&time=".time();
|
$datainfo=file_get_contents($data_url);
|
$datainfo=json_decode($datainfo,true);
|
//var_dump($datainfo);exit;
|
if ($datainfo['ret']==0){
|
foreach ($datainfo['data'] as $ArrayValue) {
|
$webJson['method'] = $method;
|
$webJson['result'] = 1;
|
$webJson['data_imei'] = $ArrayValue['imei']; //设备IMEI
|
$webJson['device_info'] = $ArrayValue['device_info']; //0:正常数据 1:设备未上线 2:设备已过期 3:设备离线
|
|
$webJson['data_course'] = $ArrayValue['course']; //航向
|
$webJson['data_speed'] = $ArrayValue['speed']; //速度
|
if (floor((time()-$ArrayValue['gps_time'])/86400/60/60)<=90){
|
$webJson['CarLicense'] = $webJson['CarLicense']." 速度:".$ArrayValue['speed']."km/h";
|
}
|
|
//GPS坐标转腾讯坐标
|
$GPSdata_url='https://apis.map.qq.com/ws/coord/v1/translate?locations='.$ArrayValue['lat'].','.$ArrayValue['lng'].'&type=3&key=D56BZ-BFAHR-34GWH-WOM7M-H76VO-H6F4M';
|
$GPSdatainfo=file_get_contents($GPSdata_url);
|
$GPSdatainfo=json_decode($GPSdatainfo,true);
|
//var_dump($GPSdatainfo);exit;
|
if ($GPSdatainfo['status']==0){
|
foreach ($GPSdatainfo['locations'] as $ArrayGPSValue) {
|
$webJson['data_lat'] = $ArrayGPSValue['lat']; //纬度
|
$webJson['data_lng'] = $ArrayGPSValue['lng']; //经度
|
}
|
}else{
|
$webJson['data_lat'] = $ArrayValue['lat']; //纬度
|
$webJson['data_lng'] = $ArrayValue['lng']; //经度
|
}
|
}
|
}else{
|
$errcode=40013;
|
$errmsg="GPS信息查询失败";
|
}
|
}else{
|
//出发地坐标
|
$webJson['data_lng']='';
|
$webJson['data_lat']='';
|
$webJson['method'] = $method;
|
$webJson['result'] = 1;
|
$webJson['data_imei'] = ''; //设备IMEI
|
$webJson['device_info'] = 0; //0:正常数据 1:设备未上线 2:设备已过期 3:设备离线
|
|
$webJson['data_course'] = 0; //航向
|
$webJson['data_speed'] = 0; //速度
|
$webJson['CarLicense'] = $webJson['CarLicense']." （行程结束）";
|
$GPSdata_url='https://apis.map.qq.com/ws/geocoder/v1/?address='.$TraStreet.'&key=D56BZ-BFAHR-34GWH-WOM7M-H76VO-H6F4M';
|
$GPSdatainfo=file_get_contents($GPSdata_url);
|
$GPSdatainfo=json_decode($GPSdatainfo,true);
|
//var_dump($GPSdatainfo);//exit;
|
if ($GPSdatainfo['status']==0){
|
//var_dump($GPSdatainfo['result']['location']);//exit;
|
foreach ($GPSdatainfo['result']['location'] as $ArrayGPSEndValue) {
|
if ($webJson['data_lng']==''){$webJson['data_lng'] = $ArrayGPSEndValue;} //经度
|
else {$webJson['data_lat']= $ArrayGPSEndValue;} //纬度
|
}
|
}
|
}
|
|
//目的地坐标
|
$webJson['TraEnd_lat']='';
|
$webJson['TraEnd_lng']='';
|
if ($DispatchOrdState<6 and $TraStreet!='') {
|
$GPSdata_url='https://apis.map.qq.com/ws/geocoder/v1/?address='.$TraStreet.'&key=D56BZ-BFAHR-34GWH-WOM7M-H76VO-H6F4M';
|
$GPSdatainfo=file_get_contents($GPSdata_url);
|
$GPSdatainfo=json_decode($GPSdatainfo,true);
|
//var_dump($GPSdatainfo);//exit;
|
if ($GPSdatainfo['status']==0){
|
//var_dump($GPSdatainfo['result']['location']);//exit;
|
foreach ($GPSdatainfo['result']['location'] as $ArrayGPSEndValue) {
|
if ($webJson['TraEnd_lng']==''){$webJson['TraEnd_lng'] = $ArrayGPSEndValue;} //经度
|
else {$webJson['TraEnd_lat']= $ArrayGPSEndValue;} //纬度
|
}
|
}
|
}elseif ($DispatchOrdState>=6 and $TraEnd!=''){
|
$GPSdata_url='https://apis.map.qq.com/ws/geocoder/v1/?address='.$TraEnd.'&key=D56BZ-BFAHR-34GWH-WOM7M-H76VO-H6F4M';
|
$GPSdatainfo=file_get_contents($GPSdata_url);
|
$GPSdatainfo=json_decode($GPSdatainfo,true);
|
//var_dump($GPSdatainfo);//exit;
|
if ($GPSdatainfo['status']==0){
|
//var_dump($GPSdatainfo['result']['location']);//exit;
|
foreach ($GPSdatainfo['result']['location'] as $ArrayGPSEndValue) {
|
if ($webJson['TraEnd_lng']==''){$webJson['TraEnd_lng'] = $ArrayGPSEndValue;} //经度
|
else {$webJson['TraEnd_lat']= $ArrayGPSEndValue;} //纬度
|
}
|
}
|
|
}
|
|
}
|
}
|
|
If (substr($errcode,0,1)=="4") {
|
$webJson['result'] = 2;
|
$webJson['errcode'] = $errcode;
|
$webJson['errmsg'] = $errmsg;
|
}
|
|
|
|
echo json_encode($webJson,JSON_UNESCAPED_UNICODE);
|
?>
|
