ApiAction.class.php 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806
  1. <?php
  2. class ApiAction extends Action {
  3. public function login( ){
  4. $data = I('post.data');
  5. //$data = json_decode(htmlspecialchars_decode(I('post.data')),true);
  6. if(!$data){
  7. $this->api_fail(C('FAIL'),'没有用户信息');
  8. }
  9. $cond = array(
  10. 'LicensePlate|GpsDeviceNumber|DeviceNumber'=>$data['username'],
  11. 'Password'=>$data['password']
  12. );
  13. $userinfo = M('jms_vehicle')->where($cond)->find();
  14. if(!$userinfo){
  15. $this->api_fail(C('FAIL'),'用户名或者密码不正确');
  16. }
  17. $token = md5($data['username'].I('post.loginMark').$data['password'].date('Y-m-d H:i:s'));
  18. $result = \Jiaruan\RedisCache::setSessionRules(I('post.loginMark'),$token);
  19. if($result === false){
  20. $this->api_fail(C('FAIL'),'添加redis失败');
  21. }
  22. $where = array("ID" => $userinfo['ID']);
  23. $data = array(
  24. "LoginMark" => I('post.loginMark'),
  25. "Token" => $token
  26. );
  27. $res = M('jms_vehicle')->createSave($where,$data);
  28. if(!$res){
  29. $this->api_fail(C('FAIL'),'token信息保存失败');
  30. }
  31. $baseinfo = array(
  32. "userId" => $userinfo['ID'],
  33. "enCode" => "System",
  34. "account" => $userinfo['FullName'],
  35. "password" => $userinfo['Password'],
  36. "secretkey" => '',
  37. "realName" => $userinfo['FullName'],
  38. "nickName" => $userinfo['FullName'],
  39. "headIcon" => ".jpg",
  40. "gender" => $userinfo['Sex'],
  41. "mobile" => $userinfo['UserPhone'],
  42. "telephone" => $userinfo['Telephone'],
  43. "email" => $userinfo['Email'],
  44. "oICQ" => $userinfo['QQ'],
  45. "weChat" => $userinfo['WxName'],
  46. "companyId" => "",
  47. "companyIds" => array(),
  48. "departmentId" => "",
  49. "departmentIds" => array(),
  50. "openId" => $userinfo['WxOpenId'],
  51. "roleIds" => $userinfo['RoleId'],
  52. "postIds" => "",
  53. "isSystem" => true,
  54. "appId" => "renlian_1.0.0_App",
  55. "logTime" => date('Y-m-d H:i:s'),
  56. "iPAddress" => $_SERVER['REMOTE_ADDR'],
  57. "browser" => "Safari 11.0",
  58. "loginMark" => I('post.loginMark'),
  59. "token" => $token,
  60. "imUrl" => '',
  61. "imOpen" => '',
  62. "wfProcessId" => '',
  63. "photoUrl" => $userinfo['Avatar'],
  64. "plate" => $userinfo['LicensePlate'],
  65. 'deviceNumber' => $userinfo['DeviceNumber'],
  66. 'gpsNumber' => $userinfo['GpsDeviceNumber'],
  67. 'cityid' => $userinfo['CityId']
  68. );
  69. $data = array(
  70. "baseinfo" => $baseinfo,
  71. "post" => array(),
  72. "role" => array()
  73. );
  74. $this->api_success('登录成功',$data);
  75. }
  76. public function modifypassword( ){
  77. $this->token_verify();
  78. $post_data = I('post.data');
  79. if( empty($post_data) ){
  80. $this->api_fail(C('FAIL'),'post_data不能为空!');
  81. }
  82. $userid = $post_data['userid'];
  83. $newpassword = $post_data['newpassword'];
  84. $oldpassword = $post_data['oldpassword'];
  85. if(!M('jms_vehicle')->where(array('ID'=>$userid,'Password'=>$oldpassword))->find()){
  86. $this->api_fail(C('FAIL'),'旧密码不正确');
  87. }
  88. $where = array(
  89. 'ID' => $userid,
  90. 'Password' => $oldpassword
  91. );
  92. $data = array(
  93. 'Password' => $newpassword
  94. );
  95. $res = M('jms_vehicle')->createSave($where,$data);
  96. if(!$res){
  97. $this->api_fail(C('FAIL'),'修改密码失败');
  98. }
  99. $this->api_success('修改成功');
  100. }
  101. public function get_baojing_info( ){
  102. $this->token_verify();
  103. $plate = I('get.plate');
  104. $msg = M('jms_baojing_message')->where(array('Type'=>C('STOLEN_ALARM'),'LicensePlate'=>$plate))->select();
  105. if(!$msg){
  106. $this->api_fail(C('FAIL'),'报警信息不存在');
  107. }
  108. $this->api_success('成功',$msg);
  109. }
  110. public function get_map_index_data( ){
  111. $this->token_verify();
  112. $deviceNumber = $_GET['data']['deviceNumber'];
  113. $licensePlate = $_GET['data']['licensePlate'];
  114. $gpsNumber = $_GET['data']['gpsNumber'];
  115. if(!$deviceNumber){
  116. $this->api_fail(C('FAIL'),'faild, no deviceNumber !');
  117. }
  118. //获取车辆最新位置mysql
  119. /*
  120. $result = M('jms_vehicle')->field('GpsLongitude, GpsLatitude, Address, FenceShapeInfo, LockStatus, FenceAlarmEnable, Battery, GpsOnlineTime, Speed, CityId')->where(array('DeviceNumber' => $deviceNumber))->find();
  121. */
  122. //redis获取
  123. $vehicle = Redis('fdrc_vehicle','hash');
  124. //var_dump($vehicle);
  125. $vehicleInfo = $vehicle->get($deviceNumber);
  126. $vehicleInfo = json_decode($vehicleInfo, true);
  127. $rlfd_vehicle_fence = Redis('rlfd_vehicle_fence','hash');
  128. $fence = $rlfd_vehicle_fence->get($licensePlate);
  129. //$fence = json_decode($fence, true);
  130. $lastLocReis = Redis('rfld_gps_last_location','hash');
  131. $lastLoction = $lastLocReis->get($gpsNumber);
  132. //var_dump($lastLoction);
  133. if($lastLoction){
  134. $lastLoction = json_decode($lastLoction, true);
  135. $alterVehLoction = \Jms\Algo\Geometry::convertBd09ToGcj02($lastLoction['GpsLatitude'], $lastLoction['GpsLongitude']);
  136. }
  137. /*
  138. if(!$result){
  139. $this->api_fail(C('FAIL'),'cant find this vehicle !');
  140. }
  141. */
  142. $onlineTimeStamp = strtotime($lastLoction['GpsOnlineTime']);
  143. if(!$onlineTimeStamp){
  144. $onlineTimeStamp = 0;
  145. }
  146. /*
  147. if(!$result['GpsLongitude'] || !$result['GpsLatitude']){
  148. $where = array('ID' => $result['CityId']);
  149. $cityLngLat = M('jms_city')->field('CenterLng, CenterLat')->where($where)->find();
  150. $result['GpsLongitude'] = $cityLngLat['CenterLng'];
  151. $result['GpsLatitude'] = $cityLngLat['CenterLat'];
  152. }
  153. */
  154. $mapData = array(
  155. 'vehicleLocation' => array('longitude' => $alterVehLoction['lng'], 'latitude' => $alterVehLoction['lat']),
  156. // 'vehicleAddress' => $result['Address'],
  157. 'lockStatus' => $vehicleInfo['LockStatus'],
  158. 'fenceShapeInfo' => $fence,
  159. 'battery' => $lastLoction['Battery'],
  160. // 'fenceAlarmStatus' => $result['FenceAlarmEnable'],
  161. 'onlineTime' => $onlineTimeStamp,
  162. 'speed' => $result['Speed']
  163. );
  164. $this->api_success('success', $mapData);
  165. }
  166. public function get_insure_info( ){
  167. $this->token_verify();
  168. $cityid = I('get.cityid');
  169. $insure_info = M('jms_insurance')->where(array('CityId'=>$cityid))->select();
  170. if(!$insure_info){
  171. $this->api_fail(C('FAIL'),'保险信息不存在');
  172. }
  173. $this->api_success('成功',$insure_info);
  174. }
  175. public function get_user_platenumber( ){
  176. $this->token_verify();
  177. $userid = I('get.userid');
  178. if(!$userid){
  179. $this->api_fail(C('FAIL'),'用户id不存在');
  180. }
  181. $plate_info = M('jms_vehicle')->where(array('ID'=>$userid))->field('ID,LicensePlate')->select();
  182. if(!$plate_info){
  183. $this->api_fail(C('FAIL'),'该车主没有使用的车牌');
  184. }
  185. $this->api_success('成功',$plate_info);
  186. }
  187. public function submit_add_baojing( ){
  188. $this->token_verify();
  189. $post_data = I('post.data');
  190. if( empty($post_data) ){
  191. $this->api_fail(C('FAIL'),'报警信息不能为空!');
  192. }
  193. $mobile = trim($post_data['UserPhone']);
  194. if(!preg_match("/^1[345678]{1}\d{9}$/",$mobile)){
  195. $this->api_fail(C('FAIL'),'手机号格式不正确!');
  196. }
  197. $date = $post_data['StolenDate'];
  198. if($date == '请选择'){
  199. $this->api_fail(C('FAIL'),'请选择被盗日期');
  200. }
  201. $Keyword = strtoupper($post_data['LicensePlate']);
  202. if ( empty($Keyword)) {
  203. $this->api_fail(C('FAIL'),'报警车辆不能为空');
  204. }
  205. $userid = $post_data['userid'];
  206. if ( empty($userid)) {
  207. $this->api_fail(C('FAIL'),'用户id不能为空');
  208. }
  209. $stolenCityId = $post_data['StolenCityId'];
  210. if ( empty($stolenCityId)) {
  211. $this->api_fail(C('FAIL'),'请选择事发城市');
  212. }
  213. $stolenaddress = $post_data['StolenAddress'];
  214. if ( empty($stolenaddress)) {
  215. $this->api_fail(C('FAIL'),'事发地址不能为空');
  216. }
  217. $WoContent = trim($post_data['WoContent']);
  218. if (empty($WoContent)) {
  219. $this->api_fail(C('FAIL'),'报警原因不能为空');
  220. }
  221. //获取登录用户城市id
  222. /*$cond = array('ID'=>$userid);
  223. $cityid = M('uc_user')->where($cond)->getField('CityId');
  224. if(!$cityid){
  225. $this->api_fail('failerror','获取登录城市失败!');
  226. }*/
  227. $vehicle_info = M('jms_vehicle')->where(array( 'LicensePlate|IdCard|UserPhone' => $Keyword ))->field('ID,UserId,CityId,IdCard,UserPhone,LicensePlate')->find();
  228. if(!$vehicle_info){
  229. $this->api_fail(C('FAIL'),'报警车辆不存在!');
  230. }
  231. /*if( $vehicle_info['CityId'] != $cityid ){
  232. $this->api_fail('failerror','该车辆不在管辖区域,无法添加报警!');
  233. }
  234. if(!$vehicle_info['UserId']){
  235. $this->api_fail('failerror','此车辆还未开户,不能添加报警信息!');
  236. }*/
  237. //$vehicle_id = $vehicle_info['ID'];
  238. /*$chezhu_id = $vehicle_info['UserId'];
  239. //$chezhu_info = fd_get_userinfo($chezhu_id);
  240. //$chezhu_info = get_chezhu_info($chezhu_id);*/
  241. //$this->api_check_vehicle_isrepeat2($vehicle_id);
  242. if ($post_data['StolenDate'] != '请选择') {
  243. $StolenDate = $post_data['StolenDate'];
  244. $StolenDate = date('Y-m-d',strtotime($StolenDate));
  245. // 被盗日期不能超过当前时间
  246. $now_time = date('Y-m-d');
  247. if(strtotime($StolenDate) > strtotime($now_time)){
  248. $this->api_fail(C('FAIL'),'被盗日期不能超过当前时间!');
  249. }
  250. } else {
  251. $StolenDate = date('Y-m-d');
  252. }
  253. $this->api_fail(C('FAIL'),$stolenCityId);
  254. if(M('jms_baojing')->where(array('LicensePlate' => $vehicle_info['LicensePlate'],'StolenState'=>0))->find()){
  255. $this->api_fail(C('FAIL'),'报警信息已经存在');
  256. }
  257. $StolenCityId = explode(',',$stolenCityId);
  258. $StolenCityId = $StolenCityId[2]+1000;
  259. $data = array(
  260. 'WoContent' => $WoContent,
  261. 'VehicleId' => $userid,
  262. 'LicensePlate' => $vehicle_info['LicensePlate'],
  263. 'IdCard' => $vehicle_info['IdCard'],
  264. 'UserId' => $userid,
  265. 'UserPhone' =>$mobile,
  266. 'CityId' => $vehicle_info['CityId'],
  267. 'SubmitUserId' => $userid,
  268. 'SubmitTime' => date('Y-m-d H:i:s'),
  269. 'StolenDate' => $StolenDate,
  270. 'StolenCityId' => $StolenCityId, //新增:被盗城市id
  271. 'StolenAddress' => $stolenaddress
  272. );
  273. if (!M('jms_baojing')->createAdd($data)) {
  274. $this->api_fail(C('FAIL'),'添加报警信息失败');
  275. }
  276. $this->api_success('添加报警信息成功');
  277. }
  278. public function update_jg_registrationid( ){
  279. $this->token_verify();
  280. $post_data = I('post.data');
  281. //$post_data = json_decode(htmlspecialchars_decode(I('post.data')),true);
  282. if( empty($post_data) ){
  283. $this->api_fail(C('FAIL'),'post_data不能为空!');
  284. }
  285. $regid = $post_data['regid'];//极光推设备唯一标识id
  286. if( empty($regid) ){
  287. $this->api_fail(C('FAIL'),'极光推注册id不能为空!');
  288. }
  289. if(!$post_data['uid']){
  290. $this->api_fail(C('FAIL'),'uid不能为空!');
  291. }
  292. $cond = array(
  293. 'ID' => $post_data['uid']
  294. );
  295. $result = M('jms_vehicle')->where($cond)->setField('JgClientRegistrationId',$regid);
  296. if( false === $result ){
  297. $this->api_fail(C('FAIL'),'更新极光推注册信息失败! error:'.M('jms_vehicle')->getDbError());
  298. }
  299. $this->api_success('更新成功');
  300. }
  301. public function save_fence_info( ){
  302. $this->token_verify();
  303. $fence_info =I('post.data');
  304. $fenceData = htmlspecialchars_decode($fence_info['data']);
  305. $plate = $fence_info['plate'];
  306. if( !$fence_info || !$plate){
  307. json_fail('Missing param !');
  308. }
  309. $fence_data = json_decode($fenceData, true);
  310. // 保存百度地图
  311. $fence_data['data']['center'] = \Jms\Algo\Geometry::convertGcj02ToBd09($fence_data['data']['center']['lat'], $fence_data['data']['center']['lng']);
  312. $data = array(
  313. 'fenceStatus' => $fence_info['fenceAlarmEnable'] == 'true' ? true : false,
  314. 'fenceInfo' => $fence_data
  315. );
  316. //围栏信息改为存入redis表 rlfd_vehicle_fence( key车牌号,value围栏信息)
  317. $rlfd_vehicle_fence = Redis('rlfd_vehicle_fence','hash');
  318. $key = $plate;
  319. $val = json_encode($data, JSON_UNESCAPED_UNICODE);
  320. $hash = array($key=>$val);
  321. $result = $rlfd_vehicle_fence->add($hash);
  322. if( $result === false ){
  323. json_fail('保存失败');
  324. }
  325. json_success('保存成功');
  326. }
  327. public function get_gps_route( ){
  328. $this->token_verify();
  329. $postParm = I('post.data');
  330. $search_date = $postParm['date'];
  331. $gps_number = $postParm['gpsNumber'];
  332. if( !$gps_number || !$search_date){
  333. json_fail('Missing param !');
  334. }
  335. $timestamp = strtotime($search_date);
  336. if( !$timestamp ){
  337. json_fail('Date format error !');
  338. }
  339. $start_date = strtotime( date('Y-m-d 00:00:00',$timestamp) );
  340. $end_date = strtotime( date('Y-m-d 23:59:59',$timestamp) );
  341. $cond = array(
  342. 'DeviceId' => $gps_number,
  343. 'DeviceTime' => array( 'between', array($start_date,$end_date) ),
  344. );
  345. $fields = 'Longitude as lng,Latitude as lat,Speed as speed, DeviceTime as deviceTime';
  346. $dateStr = str_replace("-","",$search_date);
  347. $route_list = M('gps_location_'.$dateStr, '', C('DB_DSN_GPS'))->field($fields)->where($cond)->order('DeviceTime asc')->select();
  348. //var_dump(M('gps_location_'.$dateStr, '', C('DB_DSN_GPS'))->getLastSql());
  349. if( !$route_list ){
  350. json_fail('无轨迹 !');
  351. }
  352. foreach($route_list as &$v){
  353. $v['deviceTime'] = date('Y-m-d H:i:s', $v['deviceTime']);
  354. }
  355. $route_data = json_encode($route_list);
  356. //$testData = json_encode($testData);
  357. json_success('success',$route_data);
  358. //json_success('success',$testData);
  359. }
  360. public function change_lock_status( ){
  361. $this->token_verify();
  362. $lock_state = I('post.data')['lockStatus'];
  363. $device_number = I('post.data')['deviceNumber'];
  364. if( !$device_number || $lock_state === ''){
  365. json_fail('Missing param !');
  366. }
  367. //检查锁定状态值
  368. if( !is_numeric($lock_state) && ($lock_state != 0 && $lock_state != 1) ){
  369. json_fail('unknown state !');
  370. }
  371. $cond = array('DeviceNumber' => $device_number);
  372. $result = M('jms_vehicle')->where($cond)->setField('LockStatus',$lock_state);
  373. if( $result === false ){
  374. json_fail('设置失败');
  375. }
  376. json_success('设置成功');
  377. }
  378. public function api_success( $msg, $data ){
  379. $array = array(
  380. 'success'=>true,
  381. 'message'=>$msg,
  382. 'data' => $data,
  383. 'code'=>200
  384. );
  385. echo json_encode($array,JSON_UNESCAPED_UNICODE);
  386. exit;
  387. }
  388. public function api_fail( $code, $msg, $data ){
  389. $array = array(
  390. 'success'=>false,
  391. 'message'=>$msg,
  392. 'data' => $data,
  393. 'code'=>$code
  394. );
  395. echo json_encode($array,JSON_UNESCAPED_UNICODE);
  396. exit;
  397. }
  398. public function get_gonggao_info( ){
  399. $this->token_verify();
  400. $plate = I('get.plate');
  401. $msg = M('jms_baojing_message')->where(array('Type'=>C('BROADCASTING'),'LicensePlate'=>$plate))->select();
  402. if(!$msg){
  403. $this->api_fail(C('FAIL'),'公告信息不存在');
  404. }
  405. $this->api_success('成功',$msg);
  406. }
  407. public function token_verify( ){
  408. $token = I('token');//用户登录token
  409. $login_mark = I('loginMark');
  410. if(!$token){
  411. $this->api_fail(C('FAIL'),'token不存在 !');
  412. }
  413. if(!$login_mark){
  414. $this->api_fail(C('FAIL'),'login_mark不存在 !');
  415. }
  416. //获取token
  417. $redis = Redis('czapp_client_login_session','hash');
  418. $key = $login_mark;
  419. $val = json_decode($redis->get($key),true);
  420. if(!$val){
  421. $this->api_fail(C('FAIL'),'无效token1 !');
  422. }
  423. //验证token是否一致
  424. if( $token != $val['token'] ){
  425. $this->api_fail(C('FAIL'),'无效token2 !');
  426. }
  427. //验证token是否过期
  428. if(!$val['login_time']){
  429. $this->api_fail(C('FAIL'),'没有登录时间,token校验失败 !');
  430. }
  431. $login_time = strtotime($val['login_time']);
  432. $end_time = $login_time + $val['expire']*60;
  433. if(time()>$end_time){
  434. $this->api_fail(C('TOKEN_OVERTIME'),'token失效,请重新登录 !');
  435. }
  436. }
  437. public function get_gonggao_detail( ){
  438. header('Access-Control-Allow-Origin:*');
  439. $this->token_verify();
  440. $plate = I('get.plate');
  441. $msg = M('jms_baojing_message')->where(array('Type'=>C('BROADCASTING'),'LicensePlate'=>$plate))->find();
  442. if(!$msg){
  443. $this->api_fail(C('FAIL'),'公告信息不存在');
  444. }
  445. $this->api_success('成功',$msg);
  446. }
  447. public function get_baojing_detail( ){
  448. $this->token_verify();
  449. $plate = I('get.plate');
  450. $addtime = I('get.addtime');
  451. $msg = M('jms_baojing_message')->where(array('Type'=>C('STOLEN_ALARM'),'LicensePlate'=>$plate,'AddTime'=>$addtime))->find();
  452. if(!$msg){
  453. $this->api_fail(C('FAIL'),'报警信息不存在');
  454. }
  455. $this->api_success('成功',$msg);
  456. }
  457. public function register( ){
  458. $where = array('LicensePlate'=>I('post.LicensePlate'));
  459. $userinfo = M('jms_vehicle')->where($where)->find();
  460. if(!$userinfo){
  461. $this->api_fail(C('FAIL'),'用户车牌还未登记');
  462. }
  463. if($userinfo['FullName'] != I('post.FullName')){
  464. $this->api_fail(C('FAIL'),'姓名和备案时填写不一致');
  465. }
  466. if($userinfo['IdCard'] != I('post.IdCard')){
  467. $this->api_fail(C('FAIL'),'身份证和备案时填写不一致');
  468. }
  469. $data = array(
  470. 'Password' => I('post.Password'),
  471. );
  472. $result = M('jms_vehicle')->createSave($where,$data);
  473. if(!$result){
  474. $this->api_fail(C('FAIL'),'注册失败');
  475. }
  476. $this->api_success('注册成功');
  477. }
  478. public function get_fence_info( ){
  479. $this->token_verify();
  480. $plate = I('get.data');
  481. if( !$plate){
  482. json_fail('Missing param !');
  483. }
  484. $rlfd_vehicle_fence = Redis('rlfd_vehicle_fence','hash');
  485. $fence = $rlfd_vehicle_fence->get($plate);
  486. if( !$fence ){
  487. json_fail('无围栏 !');
  488. }
  489. $fence_info = json_decode($fence, true);
  490. // 转高德地图坐标
  491. $fence_info['fenceInfo']['data']['center'] = \Jms\Algo\Geometry::convertBd09ToGcj02($fence_info['fenceInfo']['data']['center']['lat'], $fence_info['fenceInfo']['data']['center']['lng']);
  492. $fence = json_encode($fence_info);
  493. json_success('success',$fence);
  494. }
  495. public function get_gps_route_table( ){
  496. $this->token_verify();
  497. $postParm = I('post.data');
  498. $search_date = $postParm['date'];
  499. $gps_number = $postParm['gpsNumber'];
  500. if( !$gps_number || !$search_date){
  501. json_fail('请检查GPS标签或者日期 !');
  502. }
  503. //$list = $this->getBTGpsRoute($search_date,'1');//test
  504. $list = $this->getBTGpsRoute($search_date, $gps_number);
  505. $lngLatAlter = new \Jms\Algo\Geometry();
  506. $respData = array();
  507. foreach($list as $v){
  508. $alterRes = $lngLatAlter->convertBd09ToGcj02($v['Latitude'], $v['Longitude']);
  509. $nv = array(
  510. 'lat' => $alterRes['lat'],
  511. 'lng' => $alterRes['lng'],
  512. 'speed' => $v['Speed'],
  513. 'deviceTime' => $v['OnlineTime']
  514. );
  515. array_push($respData, $nv);
  516. }
  517. /*
  518. foreach(&$respData as &$v){
  519. $v['deviceTime'] = date('Y-m-d H:i:s', $v['deviceTime']);
  520. }
  521. */
  522. if(!$respData){
  523. json_success('无轨迹');
  524. }
  525. $route_data = json_encode($respData);
  526. //$testData = json_encode($testData);
  527. json_success('success',$route_data);
  528. //json_success('success',$testData);
  529. }
  530. private function getBTGpsRoute( $date, $gpsNumber ){
  531. if(!$gpsNumber){
  532. return false;
  533. }
  534. if(!$date){
  535. $date = date('Y-m-d');
  536. }
  537. //获取所有轨迹信号
  538. $option = array();
  539. $option['pagesize'] = 1000;
  540. $option['asc'];
  541. $option['fields'] = array('Longitude','Latitude','Speed','DeviceTime');
  542. $routesig = new \Rlfd\Route\RouteSignal();
  543. $list = $routesig->queryEbicyleDailyGpsSignals($gpsNumber, $date,$option);
  544. //var_dump($list);
  545. //var_dump(array('route'=>$list,'vehicle'=>$vehicle_info));
  546. return $list;
  547. }
  548. public function get_driving_data( ){
  549. $gpsNumber = $_GET['data']['gpsNumber'];
  550. //var_dump($_GET);
  551. $days = C('DRIVING_STATISTICS_DAYS');
  552. if(!$gpsNumber){
  553. json_fail('未获取到gps设备号');
  554. }
  555. if(!$days){
  556. $days = 5;
  557. }
  558. $drivingData = array();
  559. for($i = $days-1; $i > 0; --$i){
  560. $preStr2time = strtotime('-'.$i.'days');
  561. $date = date('Y-m-d', $preStr2time);
  562. /*
  563. $where = array(
  564. 'GpsDeviceNumber' => $gpsNumber,
  565. 'Date' => $date
  566. );
  567. $sqlData = M('gps_driving_data')->where($where)->find();//当天前的数据查询sql数据库
  568. if($sqlData){
  569. $dayData = array(
  570. 'date' => $date,
  571. 'averageSpeed' => $sqlData['AverageSpeed'],
  572. 'totalTime' => $sqlData['TotalTime'],
  573. 'totalDist' => $sqlData['TotalDistance']
  574. );
  575. array_push($drivingData, $dayData);
  576. continue;
  577. }
  578. */
  579. $cache = S($gpsNumber.'_cache'.$date);
  580. if($cache){
  581. array_push($drivingData, $cache);
  582. continue;
  583. }else{
  584. $dayData = $this->searchDrivingData($gpsNumber, $date);
  585. array_push($drivingData, $dayData);
  586. S($gpsNumber.'_cache'.$date, $dayData, 3600*24*7);
  587. }
  588. }
  589. //当日
  590. $todayDate = date('Y-m-d');
  591. $todayCache = S($gpsNumber.'_cache'.$todayDate);
  592. if(!$todayCache){
  593. $todayData = $this->searchDrivingData($gpsNumber, $todayDate);
  594. array_push($drivingData, $todayData);
  595. $todayCache = S($gpsNumber.'_cache'.$todayData, $todayData, 3600*24);
  596. }else{
  597. $newOnlineTime = M('jms_vehicle')->where(array('GpsDeviceNumber' => $gpsNumber))->getField('GpsOnlineTime');
  598. $nTime = strtotime($newOnlineTime);
  599. $oTime = strtotime($lastOnlineTime);
  600. if($nTime == $oTime){
  601. array_push($drivingData, $todayCache);
  602. }else{
  603. $todayData = $this->searchDrivingData($gpsNumber, $date);
  604. array_push($drivingData, $todayData);
  605. $todayCache = S($gpsNumber.'_cache'.$todayDate, $todayData, 3600*24);
  606. }
  607. }
  608. //dump($drivingData);
  609. if(!$drivingData){
  610. json_fail('未查询到近'.$days.'日行驶数据');
  611. }
  612. json_success('查询成功', $drivingData);
  613. }
  614. private function searchDrivingData( $gpsNumber, $date ){
  615. if(!$gpsNumber){
  616. return false;
  617. }
  618. $start = microtime(true);
  619. $result = $this->getBTGpsRoute( $date,$gpsNumber);
  620. $end = microtime(true);
  621. $totalTime = 0;
  622. $totalDist = 0;
  623. $lastOnlineTime =end($result)['OnlineTime'];
  624. for($i = 0; $i < count($result)-1; ++$i){
  625. $lat1 = $result[$i]['lat'];
  626. $lng1 = $result[$i]['lng'];
  627. $lat2 = $result[$i+1]['lat'];
  628. $lng2 = $result[$i+1]['lng'];
  629. $dist = $this->get_2points_distance($lat1,$lng1,$lat2,$lng2 );
  630. $totalDist += $dist;
  631. $time = strtotime($result[$i+1]['OnlineTime']) - strtotime($result[$i]['OnlineTime']);
  632. $totalTime += ($time/3600);
  633. }
  634. return array(
  635. 'totalTime' => $totalTime,
  636. 'totalDist' => $totalDist,
  637. // 'averageSpeed' => $totalDist/$totalTime,
  638. 'lastOnlineTime' => $lastOnlineTime,
  639. 'caculateTime' => $end - $start
  640. );
  641. }
  642. private function get_2points_distance( $lat1, $lng1, $lat2, $lng2, $radius = 6378.137 ){
  643. $rad = floatval(M_PI / 180.0);
  644. $lat1 = floatval($lat1) * $rad;
  645. $lng1 = floatval($lng1) * $rad;
  646. $lat2 = floatval($lat2) * $rad;
  647. $lng2 = floatval($lng2) * $rad;
  648. $theta = $lng2 - $lng1;
  649. $dist = acos(sin($lat1) * sin($lat2) +
  650. cos($lat1) * cos($lat2) * cos($theta)
  651. );
  652. if ($dist < 0 ) {
  653. $dist += M_PI;
  654. }
  655. return $dist = $dist * $radius;
  656. }
  657. public function test_function( ){
  658. $lat1 = '31.253411';
  659. $lng1 = '121.518998';
  660. $lat2 = '31.277117';
  661. $lng2 = '120.744587';
  662. $distance = $this->get_2points_distance($lat1, $lng1, $lat2, $lng2);
  663. var_dump($distance);
  664. }
  665. public function get_vehicle_ElectronicPlateUrl( ){
  666. $this->token_verify();
  667. $userid = I('userid');
  668. $result = M('jms_vehicle')->where(array('ID'=>$userid))->field('FrontElectronicPlateUrl,BackElectronicPlateUrl')->cache('key',86400)->select();
  669. $electronicPlateUrl = S('key');
  670. $this->api_success('成功',$electronicPlateUrl[0]);
  671. }
  672. public function getCityInfo( ){
  673. $this->token_verify();
  674. $cityid = I('get.cityid');
  675. if(!$cityid){
  676. $this->api_fail(C('FAIL'),'开户城市不存在');
  677. }
  678. $parentcity = M('jms_city')->where(array('ID'=>$cityid))->find();
  679. $child_1 = M('jms_city')->where(array('ParentId'=>$parentcity['ParentId']))->select();
  680. $this->api_success('成功',$child_1);
  681. }
  682. public function get_cityinfo_by_cityid( ){
  683. $cityid = I('cityid');
  684. $ids = M('jms_city')->field('ParentId,ProvinceId')->where(array('ID'=>$cityid))->find();
  685. $result = $ids['ProvinceId'].','.($ids['ParentId']-100).','.($cityid-1000);
  686. $this->api_success('成功',$result);
  687. }
  688. }