ApiAction.class.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
  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. public 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. //从redis获取车牌
  110. $key = strtoupper($licenseplate);
  111. $p = Redis("wjw_plate","hash");
  112. $val = $p->get($key);
  113. if(!$val){
  114. //车牌信息不存在,添加到redis
  115. $info = array(
  116. 'ExpireIn' => C('EXPIREIN'),
  117. 'Timestamp' => time(),
  118. 'OpenId' => $openid
  119. );
  120. $new_val = json_encode($info,JSON_UNESCAPED_UNICODE);
  121. $hash = array($key =>$new_val);
  122. $redis_res = $p->add($hash);
  123. if(!$redis_res){
  124. json_fail('推送redis失败');
  125. }
  126. //返回成功信息
  127. $response = array(
  128. 'LicensePlate' => $licenseplate,
  129. 'ExpireIn' => C('EXPIREIN'),
  130. 'Timestamp' => time()
  131. );
  132. //删除未选车牌库中的该车牌
  133. $this->deletePlateFromRedis($licenseplate);
  134. json_success('上报预选车牌成功',$response);
  135. }else{
  136. $info = json_decode($val,true);
  137. //检测openid是否是本人
  138. if($info['OpenId'] == $openid){
  139. //是否过期
  140. $time = time() - (C('EXPIREIN')*60);
  141. if($time > $info['Timestamp']){
  142. json_fail('该车牌已经过期');
  143. }else{
  144. $response = array(
  145. 'LicensePlate' => $licenseplate,
  146. 'ExpireIn' => C('EXPIREIN'),
  147. 'Timestamp' => $info['Timestamp']
  148. );
  149. json_success('上报预选车牌成功',$response);
  150. }
  151. }else{
  152. json_fail('该车牌已经被占用');
  153. }
  154. }
  155. }
  156. public function getEnablePlaces( ){
  157. header('Access-Control-Allow-Origin:*');
  158. $appid = I('get.AppId');
  159. if(!$appid){
  160. json_fail('AppId不存在!');
  161. }
  162. $appkey = I('get.AppKey');
  163. if(!$appkey){
  164. json_fail('AppKey不存在!');
  165. }
  166. $token = I('get.Token');
  167. if(!$token){
  168. json_fail('Token不存在!');
  169. }
  170. $timestamp = I('get.Timestamp');
  171. if(!$timestamp){
  172. json_fail('Timestamp不存在!');
  173. }
  174. $random = I('get.Random');
  175. if(!$random){
  176. json_fail('Random不存在!');
  177. }
  178. $this->token_verify($appkey,$timestamp,$random,$token);
  179. $res = M('yhgl_kh_places')->field('ID as PlaceId, RegPointName as PlaceName,Longitude,Latitude')->select();
  180. if(!$res){
  181. json_fail('备案点不存在!');
  182. }
  183. json_success('查询成功',$res);
  184. }
  185. public function reportPersonalOrderInfo( ){
  186. header('Access-Control-Allow-Origin:*');
  187. $data = $_POST;
  188. $data['OpenId'] = $data['Openid'];
  189. $appid = $data['AppId'];
  190. if(!$appid){
  191. json_fail('AppId不存在!');
  192. }
  193. $appkey = $data['AppKey'];
  194. if(!$appkey){
  195. json_fail('AppKey不存在!');
  196. }
  197. $token = $data['Token'];
  198. if(!$token){
  199. json_fail('Token不存在!');
  200. }
  201. $timestamp = $data['Timestamp'];
  202. if(!$timestamp){
  203. json_fail('Timestamp不存在!');
  204. }
  205. $random = $data['Random'];
  206. if(!$random){
  207. json_fail('Random不存在!');
  208. }
  209. $this->token_verify($appkey,$timestamp,$random,$token);
  210. if(!$data['FullName']){
  211. json_fail('用户名不存在!');
  212. }
  213. if(!$data['Sex']){
  214. json_fail('用户性别不存在!');
  215. }
  216. if(!$data['UserPhone']){
  217. json_fail('用户手机号不存在!');
  218. }
  219. if(!$data['IdCard']){
  220. json_fail('用户身份证不存在!');
  221. }
  222. if(!$data['DetailedAdd']){
  223. json_fail('用户地址不存在!');
  224. }
  225. if(!$data['PlaceId']){
  226. json_fail('备案点不存在!');
  227. }
  228. if(!$data['OrderType']){
  229. json_fail('订单类型不存在!');
  230. }
  231. if(!$data['OpenId']){
  232. json_fail('用户ID不存在!');
  233. }
  234. //获取备案点信息
  235. $place_message = M('yhgl_kh_places')->where(array('ID'=>$data['PlaceId']))->field('RegPointName,PersonInCharge,ResPhone,Address,Latitude,Longitude')->find();
  236. //获取订单号
  237. $ordernumber = $this->setOrderNumber();
  238. //检测车牌是否存在
  239. if(!$data['LicensePlate']){
  240. $data['ID'] = create_guid();
  241. $data['OrderNumber'] = $ordernumber;
  242. $data['OrderStatus'] = 0;
  243. $data['AddTime'] = date('Y-m-d H:i:s');
  244. if($data['OrderType']==1){
  245. $data['EffectiveDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//开始安装日期
  246. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')+C('WJW.EXPIRATION_DATE')." day"));//过期日期
  247. }else{
  248. $data['EffectiveDate'] = date("Y-m-d");
  249. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//过期日期
  250. }
  251. $res = M('jms_order')->createAdd($data);
  252. if(!$res){
  253. json_fail('订单信息添加失败!');
  254. }
  255. $place_message['OrderNumber'] = $ordernumber;
  256. $place_message['EffectiveDate'] = $data['EffectiveDate'];
  257. $place_message['ExpireDate'] = $data['ExpireDate'];
  258. json_success('操作成功',$place_message);
  259. }else{
  260. $licenseplate = $data['LicensePlate'];
  261. //从redis获取车牌
  262. $key = strtoupper($licenseplate);
  263. $p = Redis("wjw_plate","hash");
  264. $val = $p->get($key);
  265. if(!$val){
  266. json_fail('系统错误');
  267. }
  268. $info = json_decode($val,true);
  269. //检测openid是否是本人
  270. if($info['OpenId'] == $data['OpenId']){
  271. //是否过期
  272. $time = time() - (C('EXPIREIN')*60);
  273. if($time > $info['Timestamp']){
  274. json_fail('该车牌已经过期,请重选车牌');
  275. }
  276. }else{
  277. //是否过期
  278. $time = time() - (C('EXPIREIN')*60);
  279. if($time < $info['Timestamp']){
  280. json_fail('该车牌已被占用,请重新选牌!');
  281. }
  282. }
  283. //检测车牌
  284. $res = $this->plate_verify($licenseplate);
  285. if(!res){
  286. json_fail('无效车牌,请重新选择!');
  287. }
  288. $cond = array(
  289. 'LicensePlate'=>$data['LicensePlate'],
  290. 'OrderStatus'=>array('neq','2')
  291. );
  292. $order_num = M('jms_order')->where($cond)->count();
  293. //判断订单状态,过期重新开户
  294. if($order_num){
  295. json_fail('订单信息已经存在');
  296. }
  297. $data['ID'] = create_guid();
  298. $data['OrderNumber'] = $ordernumber;
  299. $data['OrderStatus'] = 0;
  300. $data['AddTime'] = date('Y-m-d H:i:s');
  301. $data['LicensePlate'] = $data['LicensePlate'];
  302. if($data['OrderType']==1){
  303. $data['EffectiveDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//开始安装日期
  304. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')+C('WJW.EXPIRATION_DATE')." day"));//过期日期
  305. }else{
  306. $data['EffectiveDate'] = date("Y-m-d");
  307. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));//过期日期
  308. }
  309. $res = M('jms_order')->createAdd($data);
  310. if(!$res){
  311. json_fail('订单信息保存失败!');
  312. }
  313. $place_message['OrderNumber'] = $ordernumber;
  314. $place_message['LicensePlate'] = $data['LicensePlate'];
  315. $place_message['EffectiveDate'] = $data['EffectiveDate'];
  316. $place_message['ExpireDate'] = $data['ExpireDate'];
  317. json_success('操作成功',$place_message);
  318. }
  319. }
  320. public function getCompanyList( ){
  321. header('Access-Control-Allow-Origin:*');
  322. $appid = I('get.AppId');
  323. if(!$appid){
  324. json_fail('AppId不存在!');
  325. }
  326. $appkey = I('get.AppKey');
  327. if(!$appkey){
  328. json_fail('AppKey不存在!');
  329. }
  330. $token = I('get.Token');
  331. if(!$token){
  332. json_fail('Token不存在!');
  333. }
  334. $timestamp = I('get.Timestamp');
  335. if(!$timestamp){
  336. json_fail('Timestamp不存在!');
  337. }
  338. $random = I('get.Random');
  339. if(!$random){
  340. json_fail('Random不存在!');
  341. }
  342. $this->token_verify($appkey,$timestamp,$random,$token);
  343. $res = M('jms_company')->field('ID as CompanyId,Name as CompanyName')->select();
  344. if(!$res){
  345. json_fail('公司不存在!');
  346. }
  347. json_success('查询成功',$res);
  348. }
  349. public function reportCompanyOrderInfo( ){
  350. header('Access-Control-Allow-Origin:*');
  351. $data = $_POST;
  352. $appid = $data['AppId'];
  353. if(!$appid){
  354. json_fail('AppId不存在!');
  355. }
  356. $appkey = $data['AppKey'];
  357. if(!$appkey){
  358. json_fail('AppKey不存在!');
  359. }
  360. $token = $data['Token'];
  361. if(!$token){
  362. json_fail('Token不存在!');
  363. }
  364. $timestamp = $data['Timestamp'];
  365. if(!$timestamp){
  366. json_fail('Timestamp不存在!');
  367. }
  368. $random = $data['Random'];
  369. if(!$random){
  370. json_fail('Random不存在!');
  371. }
  372. $this->token_verify($appkey,$timestamp,$random,$token);
  373. if(!$data['FullName']){
  374. json_fail('用户名不存在!');
  375. }
  376. if(!$data['Sex']){
  377. json_fail('用户性别不存在!');
  378. }
  379. if(!$data['UserPhone']){
  380. json_fail('用户手机号不存在!');
  381. }
  382. if(!$data['IdCard']){
  383. json_fail('用户身份证不存在!');
  384. }
  385. if(!$data['DetailedAdd']){
  386. json_fail('用户地址不存在!');
  387. }
  388. if(!$data['PlaceId']){
  389. json_fail('备案点不存在!');
  390. }
  391. if(!$data['CompanyId']){
  392. json_fail('公司ID不存在!');
  393. }
  394. //获取备案点信息
  395. $place_message = M('yhgl_kh_places')->where(array('ID'=>$data['PlaceId']))->field('RegPointName,PersonInCharge,ResPhone,Address,Latitude,Longitude')->find();
  396. //获取订单号
  397. $ordernumber = $this->setOrderNumber();
  398. //检测车牌是否存在
  399. if(!$data['LicensePlate']){
  400. $data['ID'] = create_guid();
  401. $data['InstallDate'] = date('Y-m-d');
  402. $data['OrderType'] = 2;
  403. $data['OrderNumber'] = $ordernumber;
  404. $data['OrderStatus'] = 0;
  405. $data['AddTime'] = date('Y-m-d H:i:s');
  406. $data['EffectiveDate'] = date("Y-m-d");
  407. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));
  408. $res = M('jms_order')->createAdd($data);
  409. if(!$res){
  410. json_fail('订单信息添加失败!');
  411. }
  412. $place_message['EffectiveDate'] =$data['EffectiveDate'];
  413. $place_message['ExpireDate'] =$data['ExpireDate'];
  414. $place_message['OrderNumber'] = $ordernumber;
  415. json_success('操作成功',$place_message);
  416. }else{
  417. $order_num = M('jms_order')->where(array('LicensePlate'=>$data['LicensePlate'],'OrderStatus'=>array('neq','2')))->count();
  418. //判断订单状态,过期重新开户
  419. if(!$order_num){
  420. $data['ID'] = create_guid();
  421. $data['InstallDate'] = date('Y-m-d');
  422. $data['OrderType'] = 2;
  423. $data['OrderNumber'] = $ordernumber;
  424. $data['OrderStatus'] = 0;
  425. $data['AddTime'] = date('Y-m-d H:i:s');
  426. $data['LicensePlate'] = $data['LicensePlate'];
  427. $data['EffectiveDate'] = date("Y-m-d");
  428. $data['ExpireDate'] = date("Y-m-d",strtotime("+".C('WJW.DELIVERY_TIME')." day"));
  429. $res = M('jms_order')->createAdd($data);
  430. if(!$res){
  431. json_fail('订单信息保存失败!');
  432. }
  433. $place_message['OrderNumber'] = $ordernumber;
  434. $place_message['EffectiveDate'] =$data['EffectiveDate'];
  435. $place_message['ExpireDate'] =$data['ExpireDate'];
  436. json_success('操作成功',$place_message);
  437. }else{
  438. json_fail('订单信息已经存在');
  439. }
  440. }
  441. }
  442. public function deletePlateFromRedis( $plate ){
  443. $config = parse_url(C('REDIS_DSN'));
  444. $redis = new Redis();
  445. $redis->connect($config["host"],$config["port"]?:6379);
  446. $redis->auth($config["pass"]?: "");
  447. $redis->select(trim($config['path'],'//') ? : 0);
  448. //删除一个元素
  449. $res = $redis->sRem('plate_preselect_pool',$plate);
  450. if(!$res){
  451. json_fail('车牌库删除车牌失败');
  452. }
  453. }
  454. public function setOrderNumber( ){
  455. $i = 0;
  456. while($i < 100){
  457. $order_id = rand(10000000,99999999);
  458. $res = M('jms_order')->where(array('OrderNumber'=>$order_id_main))->find();
  459. if(!$res){
  460. return $order_id;
  461. }
  462. $i++;
  463. }
  464. }
  465. public function releaseRedisExpiredLicenseplate( ){
  466. $config = parse_url(C('REDIS_DSN'));
  467. $redis = new Redis();
  468. $redis->connect($config["host"],$config["port"]?:6379);
  469. $redis->auth($config["pass"]?: "");
  470. $redis->select(trim($config['path'],'//') ? : 0);
  471. $all = $redis->hgetall('wjw_plate');
  472. foreach($all as $key=>$val){
  473. $data = json_decode($val,true);
  474. $orderstatus = M('jms_order')->where(array('LicensePlate'=>$key))->getField('OrderStatus');
  475. if($orderstatus == NULL){
  476. $time = time() - (C('EXPIREIN')*60);
  477. if($time > $data['Timestamp']){
  478. $p = Redis("wjw_plate","hash");
  479. $res = $p->where($key)->delete();
  480. if(!$res){
  481. json_fail('删除过期车牌失败');
  482. }
  483. $result = $redis->sAdd('plate_preselect_pool' , $key);
  484. if(!$result){
  485. json_fail('释放过期车牌失败');
  486. }
  487. }
  488. }
  489. if($orderstatus == 2){
  490. $p = Redis("wjw_plate","hash");
  491. $res = $p->where($key)->delete();
  492. if(!$res){
  493. json_fail('删除过期车牌失败');
  494. }
  495. $result = $redis->sAdd('plate_preselect_pool' , $key);
  496. if(!$result){
  497. json_fail('释放过期车牌失败');
  498. }
  499. }
  500. if($orderstatus == 1){
  501. $p = Redis("wjw_plate","hash");
  502. $res = $p->where($key)->delete();
  503. if(!$res){
  504. json_fail('删除已开户车牌失败');
  505. }
  506. }
  507. }
  508. json_success('执行完毕');
  509. }
  510. private function plate_verify( $licenseplate ){
  511. if(!$licenseplate){
  512. json_fail('车牌不能为空!');
  513. }
  514. $cond = array(
  515. 'LicensePlate'=>$licenseplate,
  516. 'PreSelection'=>1
  517. );
  518. $res = M('jms_plate')->where($cond)->find();
  519. if(!$res){
  520. return false;
  521. }else{
  522. return true;
  523. }
  524. }
  525. }