ApiAction.class.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612
  1. <?php
  2. class ApiAction extends Action {
  3. public function getEnableRandomPlates( ){
  4. header('Access-Control-Allow-Origin:*');
  5. $appid = I('get.AppId');
  6. if(!$appid){
  7. json_fail('AppId不存在!');
  8. }
  9. $appkey = I('get.AppKey');
  10. if(!$appkey){
  11. json_fail('AppKey不存在!');
  12. }
  13. $token = I('get.Token');
  14. if(!$token){
  15. json_fail('Token不存在!');
  16. }
  17. $timestamp = I('get.Timestamp');
  18. if(!$timestamp){
  19. json_fail('Timestamp不存在!');
  20. }
  21. $random = I('get.Random');
  22. if(!$random){
  23. json_fail('Random不存在!');
  24. }
  25. $this->token_verify($appkey,$timestamp,$random,$token);
  26. $res = $this->getPlateFromRedis();
  27. json_success('查询成功',$res);
  28. }
  29. private function getPlateFromRedis( ){
  30. $config = parse_url(C('REDIS_DSN'));
  31. $redis = new Redis();
  32. $redis->connect($config["host"],$config["port"]?:6379);
  33. $redis->auth($config["pass"]?: "");
  34. $redis->select(trim($config['path'],'//') ? : 0);
  35. /*
  36. for($i=0;$i<10;$i++){
  37. $redis->sRem('plate_preselect_pool' , 'TK'.$i);
  38. }
  39. echo 'start sAdd'.PHP_EOL;
  40. $start = microtime(true);
  41. for($i=0;$i<100000;$i++){
  42. //向集合中添加元素
  43. $redis->sAdd('plate_preselect_pool' , 'TK'.$i);
  44. }
  45. echo 'sAdd: '.(microtime(true)-$start)*1000 .' ms'.PHP_EOL;
  46. */
  47. /*
  48. //显示所有元素
  49. $res = $redis->sMembers('plate_preselect_pool');
  50. var_dump($res);
  51. //删除一个元素
  52. $res = $redis->sRem('plate_preselect_pool','TK2');
  53. var_dump($res);
  54. $res = $redis->sMembers('plate_preselect_pool');
  55. var_dump($res);
  56. */
  57. $start = microtime(true);
  58. //获取随机元素的一个集合
  59. $list = $redis->sRandMember('plate_preselect_pool',20);
  60. //var_dump($list);
  61. //echo 'sRandMember: '.(microtime(true)-$start)*1000 .' ms'.PHP_EOL;
  62. return $list;
  63. }
  64. public function token_verify( $appkey, $timestamp, $random, $token ){
  65. $old_token = base64_encode(md5($appkey . C('APPSECREAT') . $timestamp . $random));
  66. //echo $old_token;exit;
  67. if($old_token != $token){
  68. json_fail('token无效!');
  69. }
  70. }
  71. public function reportPreSelectPlate( ){
  72. header('Access-Control-Allow-Origin:*');
  73. $data = $_POST;
  74. //验证需要字段是否存在
  75. $appid = $data['AppId'];
  76. if(!$appid){
  77. json_fail('AppId不存在!');
  78. }
  79. $appkey = $data['AppKey'];
  80. if(!$appkey){
  81. json_fail('AppKey不存在!');
  82. }
  83. $token = $data['Token'];
  84. if(!$token){
  85. json_fail('Token不存在!');
  86. }
  87. $timestamp = $data['Timestamp'];
  88. if(!$timestamp){
  89. json_fail('Timestamp不存在!');
  90. }
  91. $random = $data['Random'];
  92. if(!$random){
  93. json_fail('Random不存在!');
  94. }
  95. //检验token
  96. $this->token_verify($appkey,$timestamp,$random,$token);
  97. $licenseplate = $data['LicensePlate'];
  98. if(!$licenseplate){
  99. json_fail('LicensePlate不存在!');
  100. }
  101. $res = $this->plate_verify($licenseplate);
  102. if(!res){
  103. json_fail('无效车牌,请重新选择!');
  104. }
  105. $openid = $data['Openid'];
  106. if(!$openid){
  107. json_fail('Openid不存在!');
  108. }
  109. //车牌加锁(20分钟)
  110. $servers = [
  111. parse_url(C('REDIS_DSN_LOCK')),
  112. ];
  113. $expirein = C('EXPIREIN')?:10;
  114. $redLock = new \RedLock\RedLock($servers);
  115. $lock = $redLock->lock($licenseplate, $expirein*60*1000, $openid);
  116. if(!$lock){
  117. json_fail('车牌: '.$licenseplate .' 已被占用,请更换其它号牌!');
  118. }
  119. //预选车牌加入临时队列
  120. $key = strtoupper($licenseplate);
  121. $expire_time = time()+$expirein*60;
  122. $info = array(
  123. 'ExpireTime' => $expire_time,
  124. 'LicensePlate' => $licenseplate
  125. );
  126. $preselect_plate_queue = Redis("wjw_preselect_plate_queue","queue");
  127. $result = $preselect_plate_queue -> add($info);
  128. if(!$result){
  129. json_fail('预选车牌失败,请稍后重试');
  130. }
  131. //返回成功信息
  132. $response = array(
  133. 'LicensePlate' => $licenseplate,
  134. 'ExpireIn' => C('EXPIREIN'),
  135. 'Timestamp' => time()
  136. );
  137. //删除车牌库中的当前车牌
  138. $this->deletePlateFromRedis($licenseplate);
  139. json_success('上报预选车牌成功',$response);
  140. /*
  141. //从redis获取车牌
  142. $key = strtoupper($licenseplate);
  143. $p = Redis("wjw_plate","hash");
  144. $val = $p->get($key);
  145. if(!$val){
  146. //车牌信息不存在,添加到redis
  147. $info = array(
  148. 'ExpireIn' => C('EXPIREIN'),
  149. 'Timestamp' => time(),
  150. 'OpenId' => $openid
  151. );
  152. $new_val = json_encode($info,JSON_UNESCAPED_UNICODE);
  153. $hash = array($key =>$new_val);
  154. $redis_res = $p->add($hash);
  155. if(!$redis_res){
  156. json_fail('推送redis失败');
  157. }
  158. //返回成功信息
  159. $response = array(
  160. 'LicensePlate' => $licenseplate,
  161. 'ExpireIn' => C('EXPIREIN'),
  162. 'Timestamp' => time()
  163. );
  164. //删除未选车牌库中的该车牌
  165. $this->deletePlateFromRedis($licenseplate);
  166. json_success('上报预选车牌成功',$response);
  167. }else{
  168. $info = json_decode($val,true);
  169. //检测openid是否是本人
  170. if($info['OpenId'] == $openid){
  171. //是否过期
  172. $time = time() - (C('EXPIREIN')*60);
  173. if($time > $info['Timestamp']){
  174. json_fail('该车牌已经过期');
  175. }else{
  176. $response = array(
  177. 'LicensePlate' => $licenseplate,
  178. 'ExpireIn' => C('EXPIREIN'),
  179. 'Timestamp' => $info['Timestamp']
  180. );
  181. json_success('上报预选车牌成功',$response);
  182. }
  183. }else{
  184. //是否过期
  185. $time = time() - (C('EXPIREIN')*60);
  186. if($time > $info['Timestamp']){
  187. //过期车牌,新用户选牌信息添加到redis
  188. $info = array(
  189. 'ExpireIn' => C('EXPIREIN'),
  190. 'Timestamp' => time(),
  191. 'OpenId' => $openid
  192. );
  193. $new_val = json_encode($info,JSON_UNESCAPED_UNICODE);
  194. $hash = array($key =>$new_val);
  195. $redis_res = $p->add($hash);
  196. if(!$redis_res){
  197. json_fail('推送redis失败');
  198. }
  199. //返回成功信息
  200. $response = array(
  201. 'LicensePlate' => $licenseplate,
  202. 'ExpireIn' => C('EXPIREIN'),
  203. 'Timestamp' => time()
  204. );
  205. //删除未选车牌库中的该车牌
  206. $this->deletePlateFromRedis($licenseplate);
  207. json_success('上报预选车牌成功',$response);
  208. }else{
  209. json_fail('该车牌已被占用,请重新选牌!');
  210. }
  211. }
  212. }
  213. */
  214. }
  215. public function getEnablePlaces( ){
  216. header('Access-Control-Allow-Origin:*');
  217. $appid = I('get.AppId');
  218. if(!$appid){
  219. json_fail('AppId不存在!');
  220. }
  221. $appkey = I('get.AppKey');
  222. if(!$appkey){
  223. json_fail('AppKey不存在!');
  224. }
  225. $token = I('get.Token');
  226. if(!$token){
  227. json_fail('Token不存在!');
  228. }
  229. $timestamp = I('get.Timestamp');
  230. if(!$timestamp){
  231. json_fail('Timestamp不存在!');
  232. }
  233. $random = I('get.Random');
  234. if(!$random){
  235. json_fail('Random不存在!');
  236. }
  237. $this->token_verify($appkey,$timestamp,$random,$token);
  238. $res = M('yhgl_kh_places')->field('ID as PlaceId,RegPointName as PlaceName,Longitude,Latitude,Address')->select();
  239. if(!$res){
  240. json_fail('备案点不存在!');
  241. }
  242. json_success('查询成功',$res);
  243. }
  244. public function reportPersonalOrderInfo( ){
  245. header('Access-Control-Allow-Origin:*');
  246. $data = $_POST;
  247. $data['OpenId'] = $data['Openid'];
  248. $appid = $data['AppId'];
  249. if(!$appid){
  250. json_fail('AppId不存在!');
  251. }
  252. $appkey = $data['AppKey'];
  253. if(!$appkey){
  254. json_fail('AppKey不存在!');
  255. }
  256. $token = $data['Token'];
  257. if(!$token){
  258. json_fail('Token不存在!');
  259. }
  260. $timestamp = $data['Timestamp'];
  261. if(!$timestamp){
  262. json_fail('Timestamp不存在!');
  263. }
  264. $random = $data['Random'];
  265. if(!$random){
  266. json_fail('Random不存在!');
  267. }
  268. $this->token_verify($appkey,$timestamp,$random,$token);
  269. if(!$data['FullName']){
  270. json_fail('用户名不存在!');
  271. }
  272. if(!$data['Sex']){
  273. json_fail('用户性别不存在!');
  274. }
  275. if(!$data['UserPhone']){
  276. json_fail('用户手机号不存在!');
  277. }
  278. if(!$data['IdCard']){
  279. json_fail('用户身份证不存在!');
  280. }
  281. if(!$data['DetailedAdd']){
  282. json_fail('用户地址不存在!');
  283. }
  284. if(!$data['PlaceId']){
  285. json_fail('备案点不存在!');
  286. }
  287. if(!$data['OrderType']){
  288. json_fail('订单类型不存在!');
  289. }
  290. if(!$data['OpenId']){
  291. json_fail('用户ID不存在!');
  292. }
  293. //获取备案点信息
  294. $place_message = M('yhgl_kh_places')->where(array('ID'=>$data['PlaceId']))->field('RegPointName,PersonInCharge,ResPhone,Address,Latitude,Longitude')->find();
  295. //获取订单号
  296. $ordernumber = $this->setOrderNumber();
  297. //检测车牌是否存在
  298. if(!$data['LicensePlate']){
  299. $data['ID'] = create_guid();
  300. $data['OrderNumber'] = $ordernumber;
  301. $data['OrderStatus'] = 0;
  302. $data['AddTime'] = date('Y-m-d H:i:s');
  303. if($data['OrderType']==1){
  304. $data['EffectiveDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//开始安装日期
  305. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')+C('WJW.EXPIRATION_DATE')." day"));//过期日期
  306. }else{
  307. $data['EffectiveDate'] = date("Y-m-d");
  308. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//过期日期
  309. }
  310. $res = M('jms_order')->createAdd($data);
  311. if(!$res){
  312. json_fail('订单信息添加失败!');
  313. }
  314. $place_message['OrderNumber'] = $ordernumber;
  315. $place_message['EffectiveDate'] = $data['EffectiveDate'];
  316. $place_message['ExpireDate'] = $data['ExpireDate'];
  317. json_success('操作成功',$place_message);
  318. }else{
  319. $licenseplate = $data['LicensePlate'];
  320. /*
  321. //从redis获取车牌
  322. $key = strtoupper($licenseplate);
  323. $p = Redis("wjw_plate","hash");
  324. $val = $p->get($key);
  325. if(!$val){
  326. json_fail('系统错误');
  327. }
  328. $info = json_decode($val,true);
  329. //检测openid是否是本人
  330. if($info['OpenId'] == $data['OpenId']){
  331. //是否过期
  332. $time = time() - (C('EXPIREIN')*60);
  333. if($time > $info['Timestamp']){
  334. json_fail('该车牌已经过期,请重选车牌');
  335. }
  336. }else{
  337. //是否过期
  338. $time = time() - (C('EXPIREIN')*60);
  339. if($time < $info['Timestamp']){
  340. json_fail('该车牌已被占用,请重新选牌!');
  341. }
  342. }
  343. */
  344. //检测车牌是否有效
  345. $res = $this->plate_verify($licenseplate);
  346. if(!res){
  347. json_fail('无效车牌,请重新选择!');
  348. }
  349. //检测预选车牌是否超时
  350. $result = $this->checkPreSelectPlateIsTimeout($licenseplate,$data['OpenId']);
  351. if($result['success'] === true){
  352. json_fail($result['message']);
  353. }
  354. if($result['success'] === -1){
  355. json_fail($result['message']);
  356. }
  357. $cond = array(
  358. 'LicensePlate'=>$data['LicensePlate'],
  359. 'OrderStatus'=>array('neq','2')
  360. );
  361. $order_num = M('jms_order')->where($cond)->count();
  362. //判断订单状态,过期重新开户
  363. if($order_num){
  364. json_fail('订单信息已经存在');
  365. }
  366. $data['ID'] = create_guid();
  367. $data['OrderNumber'] = $ordernumber;
  368. $data['OrderStatus'] = 0;
  369. $data['AddTime'] = date('Y-m-d H:i:s');
  370. $data['LicensePlate'] = $data['LicensePlate'];
  371. if($data['OrderType']==1){
  372. $data['EffectiveDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//开始安装日期
  373. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')+C('WJW.EXPIRATION_DATE')." day"));//过期日期
  374. }else{
  375. $data['EffectiveDate'] = date("Y-m-d");
  376. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//过期日期
  377. }
  378. $res = M('jms_order')->createAdd($data);
  379. if(!$res){
  380. json_fail('订单信息保存失败!');
  381. }
  382. $place_message['OrderNumber'] = $ordernumber;
  383. $place_message['LicensePlate'] = $data['LicensePlate'];
  384. $place_message['EffectiveDate'] = $data['EffectiveDate'];
  385. $place_message['ExpireDate'] = $data['ExpireDate'];
  386. json_success('操作成功',$place_message);
  387. }
  388. }
  389. public function getCompanyList( ){
  390. header('Access-Control-Allow-Origin:*');
  391. $appid = I('get.AppId');
  392. if(!$appid){
  393. json_fail('AppId不存在!');
  394. }
  395. $appkey = I('get.AppKey');
  396. if(!$appkey){
  397. json_fail('AppKey不存在!');
  398. }
  399. $token = I('get.Token');
  400. if(!$token){
  401. json_fail('Token不存在!');
  402. }
  403. $timestamp = I('get.Timestamp');
  404. if(!$timestamp){
  405. json_fail('Timestamp不存在!');
  406. }
  407. $random = I('get.Random');
  408. if(!$random){
  409. json_fail('Random不存在!');
  410. }
  411. $this->token_verify($appkey,$timestamp,$random,$token);
  412. $res = M('jms_company')->field('ID as CompanyId,Name as CompanyName')->select();
  413. if(!$res){
  414. json_fail('公司不存在!');
  415. }
  416. json_success('查询成功',$res);
  417. }
  418. public function reportCompanyOrderInfo( ){
  419. header('Access-Control-Allow-Origin:*');
  420. $data = $_POST;
  421. $appid = $data['AppId'];
  422. if(!$appid){
  423. json_fail('AppId不存在!');
  424. }
  425. $appkey = $data['AppKey'];
  426. if(!$appkey){
  427. json_fail('AppKey不存在!');
  428. }
  429. $token = $data['Token'];
  430. if(!$token){
  431. json_fail('Token不存在!');
  432. }
  433. $timestamp = $data['Timestamp'];
  434. if(!$timestamp){
  435. json_fail('Timestamp不存在!');
  436. }
  437. $random = $data['Random'];
  438. if(!$random){
  439. json_fail('Random不存在!');
  440. }
  441. $this->token_verify($appkey,$timestamp,$random,$token);
  442. if(!$data['FullName']){
  443. json_fail('用户名不存在!');
  444. }
  445. if(!$data['Sex']){
  446. json_fail('用户性别不存在!');
  447. }
  448. if(!$data['UserPhone']){
  449. json_fail('用户手机号不存在!');
  450. }
  451. if(!$data['IdCard']){
  452. json_fail('用户身份证不存在!');
  453. }
  454. if(!$data['DetailedAdd']){
  455. json_fail('用户地址不存在!');
  456. }
  457. if(!$data['PlaceId']){
  458. json_fail('备案点不存在!');
  459. }
  460. if(!$data['CompanyId']){
  461. json_fail('公司ID不存在!');
  462. }
  463. //获取备案点信息
  464. $place_message = M('yhgl_kh_places')->where(array('ID'=>$data['PlaceId']))->field('RegPointName,PersonInCharge,ResPhone,Address,Latitude,Longitude')->find();
  465. //获取订单号
  466. $ordernumber = $this->setOrderNumber();
  467. //检测车牌是否存在
  468. if(!$data['LicensePlate']){
  469. $data['ID'] = create_guid();
  470. $data['InstallDate'] = date('Y-m-d');
  471. $data['OrderType'] = 2;
  472. $data['OrderNumber'] = $ordernumber;
  473. $data['OrderStatus'] = 0;
  474. $data['AddTime'] = date('Y-m-d H:i:s');
  475. $data['EffectiveDate'] = date("Y-m-d");
  476. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));
  477. $res = M('jms_order')->createAdd($data);
  478. if(!$res){
  479. json_fail('订单信息添加失败!');
  480. }
  481. $place_message['EffectiveDate'] =$data['EffectiveDate'];
  482. $place_message['ExpireDate'] =$data['ExpireDate'];
  483. $place_message['OrderNumber'] = $ordernumber;
  484. json_success('操作成功',$place_message);
  485. }else{
  486. $order_num = M('jms_order')->where(array('LicensePlate'=>$data['LicensePlate'],'OrderStatus'=>array('neq','2')))->count();
  487. //判断订单状态,过期重新开户
  488. if(!$order_num){
  489. $data['ID'] = create_guid();
  490. $data['InstallDate'] = date('Y-m-d');
  491. $data['OrderType'] = 2;
  492. $data['OrderNumber'] = $ordernumber;
  493. $data['OrderStatus'] = 0;
  494. $data['AddTime'] = date('Y-m-d H:i:s');
  495. $data['LicensePlate'] = $data['LicensePlate'];
  496. $data['EffectiveDate'] = date("Y-m-d");
  497. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));
  498. $res = M('jms_order')->createAdd($data);
  499. if(!$res){
  500. json_fail('订单信息保存失败!');
  501. }
  502. $place_message['OrderNumber'] = $ordernumber;
  503. $place_message['EffectiveDate'] =$data['EffectiveDate'];
  504. $place_message['ExpireDate'] =$data['ExpireDate'];
  505. json_success('操作成功',$place_message);
  506. }else{
  507. json_fail('订单信息已经存在');
  508. }
  509. }
  510. }
  511. public function deletePlateFromRedis( $plate ){
  512. $config = parse_url(C('REDIS_DSN'));
  513. $redis = new Redis();
  514. $redis->connect($config["host"],$config["port"]?:6379);
  515. $redis->auth($config["pass"]?: "");
  516. $redis->select(trim($config['path'],'//') ? : 0);
  517. //删除一个元素
  518. $res = $redis->sRem('plate_preselect_pool',$plate);
  519. if(!$res){
  520. json_fail('车牌库删除车牌失败');
  521. }
  522. }
  523. public function setOrderNumber( ){
  524. $i = 0;
  525. while($i < 100){
  526. $order_id = rand(10000000,99999999);
  527. $res = M('jms_order')->where(array('OrderNumber'=>$order_id_main))->find();
  528. if(!$res){
  529. return $order_id;
  530. }
  531. $i++;
  532. }
  533. }
  534. private function plate_verify( $licenseplate ){
  535. if(!$licenseplate){
  536. json_fail('车牌不能为空!');
  537. }
  538. $cond = array(
  539. 'LicensePlate'=>$licenseplate,
  540. 'PreSelection'=>1
  541. );
  542. $res = M('jms_plate')->where($cond)->find();
  543. if(!$res){
  544. return false;
  545. }else{
  546. return true;
  547. }
  548. }
  549. private function checkPreSelectPlateIsTimeout( $plate, $openid ){
  550. if(!$openid){
  551. array('success'=> -1,'message'=>'openid不能为空');
  552. }
  553. if(!$plate){
  554. array('success'=> -1,'message'=>'车牌号不能为空');
  555. }
  556. $server = parse_url(C('REDIS_DSN_LOCK'));
  557. $redis = new \Redis();
  558. $redis->connect($server["host"],$server["port"]?:6379);
  559. $redis->auth($server["pass"]?: "");
  560. $redis->select(trim($server['path'],'//') ? : 0);
  561. $old_openid = $redis->get($plate);
  562. if(!$old_openid){
  563. return array('success'=>true,'message'=>'预选车牌超时,请重新选择车牌');
  564. }
  565. if($old_openid != $openid){
  566. return array('success'=>true,'message'=>'您选择的车牌已超时释放,已被其他用户占用,请选择其它车牌');
  567. }
  568. return array('success'=>false,'message'=>'没有超时');
  569. }
  570. }