ApiAction.class.php 14 KB

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