ApiAction.class.php 14 KB

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