DwyController.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524
  1. <?php
  2. namespace App\Http\Controllers\Api;
  3. use App\Model\BigKingTbj;
  4. use App\Service\EmployeeService;
  5. use App\Service\SysMenuService;
  6. use Illuminate\Http\Request;
  7. use Illuminate\Support\Facades\Redis;
  8. use Illuminate\Support\Str;
  9. class DwyController extends BaseController
  10. {
  11. public function advertisement()
  12. {
  13. return ['status' => 200, 'data' => [
  14. 'video' => ['https://clouddevice.qingyaokeji.com/1.mp4',
  15. 'https://clouddevice.qingyaokeji.com/2.mp4'],
  16. 'img' => [
  17. 'https://clouddevice.qingyaokeji.com/3.jpeg',
  18. 'https://clouddevice.qingyaokeji.com/3.jpeg',
  19. ],
  20. 'limit_time' => 10
  21. ]];
  22. }
  23. public function openCommand(Request $request)
  24. {
  25. $data = $request->all();
  26. file_put_contents('dwy1.txt', json_encode($data) . PHP_EOL, 8);
  27. $device_id = $data['device_code'];
  28. $box_code = $data['box_code'];
  29. $key = $data['type'];
  30. if ($key === 'UP') {
  31. $num = Redis::get($device_id . 'status_num');
  32. if (empty($num)) $num = 0;
  33. $num++;
  34. if ($num === 1) {
  35. Redis::set($device_id . 'status_num', $num);
  36. Redis::expire($device_id . 'status_num', 300);
  37. Redis::set($device_id . 'status', 201);
  38. Redis::expire($device_id . 'status', 300);
  39. Redis::set($device_id, json_encode([$box_code]));
  40. Redis::expire($device_id, 300);
  41. } else {
  42. $old = Redis::get($device_id);
  43. if (empty($old)) $old = [];
  44. else $old = json_decode($old, true);
  45. $data = array_merge($old, [$box_code]);
  46. Redis::set($device_id, json_encode($data));
  47. Redis::expire($device_id, 300);
  48. Redis::del($device_id . 'status');
  49. Redis::del($device_id . 'status_num');
  50. }
  51. } else {
  52. Redis::set($device_id, json_encode([$box_code]));
  53. Redis::expire($device_id, 300);
  54. }
  55. return ['status' => 200];
  56. }
  57. public function openDoor(Request $request)
  58. {
  59. $data = $request->all();
  60. file_put_contents('dwy1.txt', json_encode($data) . PHP_EOL, 8);
  61. $data = $data['device_code'];
  62. $code = Redis::get($data);
  63. Redis::del($data);
  64. // return ['data'=>['CK00001','CK00018'],'status'=>200];
  65. if (empty($code)) return ['data' => [], 'status' => 201];
  66. $status = Redis::get($data . 'status');
  67. if (empty($status)) $status = 200;
  68. return ['data' => json_decode($code, true), 'status' => $status];
  69. }
  70. public function getOpenCommand(Request $request)
  71. {
  72. $data = $request->all();
  73. file_put_contents('dwy1.txt', json_encode($data) . PHP_EOL, 8);
  74. $device_id = $data['device_code'];
  75. $box_code = $data['box_code'];
  76. $key = $device_id . '_' . $box_code;
  77. $return = 201;
  78. $status = Redis::get($key);
  79. if ($status) {
  80. $return = 200;
  81. Redis::del($key);
  82. }
  83. return ['status' => $return];
  84. }
  85. public function boxList(Request $request)
  86. {
  87. $param = $request->all();
  88. $token = $param['token'];
  89. $device_code = $param['device_code'];
  90. //商标仓列表
  91. $url = 'https://tm.dwycloud.com/jbl/api/module-data/device/device/diy/device_code';
  92. $header = [
  93. 'Content-Type:application/json',
  94. 'Authorization: ' . $token,
  95. ];
  96. $box_data = $this->post_helper($url, '{"device_code":"' . $device_code . '"}', $header);
  97. $box_data = json_decode($box_data, true);
  98. if (isset($box_data['status']) && $box_data['status'] === 'success') {
  99. //库存查询
  100. $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/box_inventory';
  101. $stock_data = $this->post_helper($url, '{"device_code":"' . $device_code . '"}', $header);
  102. $stock_data = json_decode($stock_data, true);
  103. if ($stock_data) {
  104. $list = [];
  105. $material_list = [];
  106. foreach ($box_data['data'] as $v) {
  107. $list[$v['box_code']] = [
  108. 'material_code' => $v['material_code'],
  109. 'material_code_show' => $v['material_code_show'],
  110. 'box_code' => $v['box_code'],
  111. 'box_code_show' => $v['box_code_show'],
  112. 'min_stock_qty' => $v['min_stock_qty'] ?? 0,
  113. 'safe_stock_qty' => $v['safe_stock_qty'] ?? 0,
  114. 'status' => 1, //0设备仓中没有对应库存,1有对应库存,2对应商标仓中还有数量不允许上标
  115. 'qty' => 0,
  116. ];
  117. $material_list[$v['material_code']][] = $v['box_code'];
  118. }
  119. $return = [];
  120. foreach ($stock_data as $v) {
  121. if (isset($material_list[$v['material_code']]) && $v['box_code'] == 'CK00001' && $v['qty'] > 0) {
  122. foreach ($material_list[$v['material_code']] as $vv) {
  123. $list[$vv]['status'] = 1;
  124. }
  125. }
  126. if (isset($list[$v['box_code']]) && $v['qty'] > 0) {
  127. $list[$v['box_code']]['qty'] = $v['qty'];
  128. }
  129. }
  130. foreach ($list as $v) {
  131. if ($v['qty'] > 0) {
  132. $v['status'] = 2;
  133. }
  134. $return[] = $v;
  135. }
  136. return ['status' => 'success', 'data' => $return];
  137. }
  138. }
  139. return $box_data;
  140. }
  141. public function setLb(Request $request)
  142. {
  143. $param = $request->all();
  144. file_put_contents('dwy.txt', json_encode($param) . PHP_EOL, 8);
  145. // $param = [
  146. // 'token'=>'Bearer eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiIyNzM2OTUyNTA3NTI5NTQzNzMiLCJhdXRoIjoiUk9MRV9JTk5FUl9VU0VSLFJPTEVfQlJBTkRfQVJSRVNULFJPTEVfQURNSU4iLCJ0b2tlbklkIjoiOTUwIiwiZXhwIjoxNzA3OTcxMTcxfQ.2VQ9Wqmk4rvKAcTsQPw59llBbeXjalKDGIZA4kesnuOJ0POmPVOVlRLbTtUDxl0XiFdPDUrKzuEFl2DXSgQdJg',
  147. // 'list'=>[
  148. // [
  149. // 'title'=>'优选A7家具板ENF小标',
  150. // 'num'=>'20',
  151. // ],[
  152. // 'title'=>'植萃除醛圆标',
  153. // 'num'=>'10',
  154. // ],
  155. // ],
  156. // ];
  157. // dd(json_encode($param));
  158. $token = $param['token'];
  159. $list = $param['list'];
  160. $mac = $param['mac'];
  161. $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/box_inventory';
  162. $header = [
  163. 'Content-Type:application/json',
  164. 'Authorization: ' . $token,
  165. ];
  166. $data = $this->post_helper($url, '{"device_code":"'.$mac.'"}', $header);
  167. $data = json_decode($data, true);
  168. foreach ($data as $k => &$v) {
  169. if (!isset($v['product_list'])) $v['product_list'] = [];
  170. if (!isset($v['box_code_show']) || $v['box_code_show'] == '设备仓') {
  171. unset($data[$k]);
  172. continue;
  173. }
  174. // $v['use_qty'] = $v['qty'];
  175. // if($v['box_code'] === 'CK00004'){
  176. // $v['use_qty'] = 200;
  177. // $v['qty'] = 200;
  178. // $v['in_stock_qty'] = 0;
  179. // }
  180. if ($v['qty'] <= 0) {
  181. unset($data[$k]);
  182. continue;
  183. }
  184. // $key_list = [];
  185. if (!isset($v['send_qty'])) $v['send_qty'] = 0;
  186. foreach ($list as $kk => $vv) {
  187. //写死的代码
  188. // if($vv['num'] > 0 ) $vv['num'] = 200;
  189. //end
  190. if ($vv['num'] == 0) continue;
  191. if ($v['material_code_show'] === $vv['title']) {
  192. $v['restore_qty'] = isset($vv['restock_qty']) && $vv['restock_qty'] > 0 ? $vv['restock_qty'] : 0;
  193. if (($v['qty'] - $v['send_qty']) > $vv['num']) {
  194. $list[$kk]['num'] -= $vv['num'];
  195. $v['send_qty'] += $vv['num'];
  196. } else {
  197. $list[$kk]['num'] -= ($v['qty'] - $v['send_qty']);
  198. $v['send_qty'] += ($v['qty'] - $v['send_qty']);
  199. }
  200. //把产品相关参数进行封装
  201. ////产品编号
  202. //"product_code": "",
  203. ////产品名称
  204. //"product_code_show": "",
  205. ////工艺
  206. //"process_title": "",
  207. ////花色
  208. //"color": "",
  209. ////工艺2
  210. //"process_title_two": "",
  211. ////花色2
  212. //"color_two": "",
  213. $key_arr = [
  214. 'product_code' => $vv['product_code'] ?? '',
  215. 'product_code_show' => $vv['product_code_show'] ?? '',
  216. 'order_item_id' => $vv['order_item_id'] ?? '',
  217. 'order_item_id_show' => $vv['order_item_id_show'] ?? '',
  218. 'process_title' => $vv['process_title'] ?? '',
  219. 'color' => $vv['color'] ?? '',
  220. 'process_title_two' => $vv['process_title_two'] ?? '',
  221. 'color_two' => $vv['color_two'] ?? '',
  222. 'send_qty' => $vv['num'],
  223. // 'send_qty' => 0,
  224. 'restock_qty' => $vv['restock_qty'] ?? 0,
  225. ];
  226. $v['product_list'][] = $key_arr;
  227. }
  228. //测试代码到时候注释掉就好了
  229. //8,10
  230. // if($v['box_code'] == 'CK00017'){
  231. // $v['box_code'] = 'CK00008';
  232. // $v['box_code_show'] = '商标五号仓';
  233. // $v['send_qty'] = '3';
  234. // $key_arr = [
  235. // 'product_code' => $vv['product_code'] ?? '',
  236. // 'product_code_show' => $vv['product_code_show'] ?? '',
  237. // 'order_item_id' => $vv['order_item_id'] ?? '',
  238. // 'order_item_id_show' => $vv['order_item_id_show'] ?? '',
  239. // 'send_qty' => 3,
  240. // 'restock_qty' => $vv['restock_qty'] ?? 0,
  241. // ];
  242. // $v['product_list'][] = $key_arr;
  243. // }elseif($v['box_code'] == 'CK00013'){
  244. // $v['box_code'] = 'CK00010';
  245. // $v['box_code_show'] = '商标七号仓';
  246. // $v['send_qty'] = '3';
  247. // $key_arr = [
  248. // 'product_code' => $vv['product_code'] ?? '',
  249. // 'product_code_show' => $vv['product_code_show'] ?? '',
  250. // 'order_item_id' => $vv['order_item_id'] ?? '',
  251. // 'order_item_id_show' => $vv['order_item_id_show'] ?? '',
  252. // 'send_qty' => 3,
  253. // 'restock_qty' => $vv['restock_qty'] ?? 0,
  254. // ];
  255. // $v['product_list'][] = $key_arr;
  256. // } else{
  257. // $v['send_qty'] = 0;
  258. // }
  259. }
  260. }
  261. // foreach ($data as $kk=>$vv){
  262. // if($vv['box_code'] === 'CK00008'){
  263. //// $data[$kk]['box_code'] = 'CK00008';
  264. //// $data[$kk]['box_code_show'] = '商标五号仓';
  265. //
  266. // $c = $vv;
  267. // $c['box_code'] = 'CK00010';
  268. // $c['box_code_show'] = '商标十三号仓';
  269. // $c['restock_qty'] = '200';
  270. // $c['send_qty'] = '200';
  271. // $c['qty'] = '200';
  272. // $c['use_qty'] = '200';
  273. //
  274. ////
  275. // $b = $vv;
  276. // $b['restock_qty'] = '200';
  277. // $b['send_qty'] = '200';
  278. // $b['qty'] = '200';
  279. // $b['use_qty'] = '200';
  280. // $b['box_code'] = 'CK00013';
  281. // $b['box_code_show'] = '商标十号仓';//
  282. //
  283. //
  284. // $d = $vv;
  285. // $d['box_code'] = 'CK00014';
  286. // $d['box_code_show'] = '商标十一号仓';
  287. //
  288. //// $d = $vv;
  289. //// $d['box_code'] = 'CK00008';
  290. //// $d['box_code_show'] = '商标五号仓';
  291. // }
  292. //
  293. // if($vv['box_code'] === 'CK00008'||$vv['box_code'] === 'CK00007'||$vv['box_code'] === 'CK00004'||$vv['box_code'] === 'CK00010'||$vv['box_code'] === 'CK00015'||$vv['box_code'] === 'CK00016'||$vv['box_code'] === 'CK00013'){
  294. //
  295. // unset($data[$kk]);
  296. //
  297. //// $c = $vv;
  298. //// $c['box_code'] = 'CK00009';
  299. //// $c['box_code_show'] = '商标六号仓';
  300. //// $data[] = $c;
  301. // }
  302. //
  303. // if($vv['box_code'] === 'CK00004'){
  304. //
  305. // unset($data[$kk]);
  306. //
  307. //// $c = $vv;
  308. //// $c['box_code'] = 'CK00009';
  309. //// $c['box_code_show'] = '商标六号仓';
  310. //// $data[] = $c;
  311. // }
  312. //
  313. //
  314. // }
  315. // if(isset($c)) {
  316. // $data[] = $c;
  317. //// $data[] = $b;
  318. //// $data[] = $d;
  319. // }
  320. sort($data);
  321. return ['status' => 200, 'data' => $data];
  322. }
  323. public function zjlb(Request $request)
  324. {
  325. $param = $request->all();
  326. file_put_contents('dwy1.txt', json_encode($param) . PHP_EOL, 8);
  327. // $param = [
  328. // 'token'=>'Bearer eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiIyNzM2OTUyNTA3NTI5NTQzNzMiLCJhdXRoIjoiUk9MRV9JTk5FUl9VU0VSLFJPTEVfQlJBTkRfQVJSRVNULFJPTEVfQURNSU4iLCJ0b2tlbklkIjoiOTUwIiwiZXhwIjoxNzA3OTcxMTcxfQ.2VQ9Wqmk4rvKAcTsQPw59llBbeXjalKDGIZA4kesnuOJ0POmPVOVlRLbTtUDxl0XiFdPDUrKzuEFl2DXSgQdJg',
  329. // 'list'=>[
  330. // [
  331. // 'title'=>'优选A7家具板ENF小标',
  332. // 'num'=>'20',
  333. // ],[
  334. // 'title'=>'植萃除醛圆标',
  335. // 'num'=>'10',
  336. // ],
  337. // ],
  338. // ];
  339. // dd(json_encode($param));
  340. $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/box_inventory';
  341. $header = [
  342. 'Content-Type:application/json',
  343. 'Authorization: ' . $request->header('Authorization'),
  344. ];
  345. $data = $this->post_helper($url, json_encode($param), $header);
  346. $data = json_decode($data, true);
  347. foreach ($data as $k => $v) {
  348. if($v['box_code'] !== 'CK00001') unset($data[$k]);
  349. if($v['qty'] == 0) unset($data[$k]);
  350. }
  351. sort($data);
  352. return json_encode($data);
  353. }
  354. public function boxOut(Request $request)
  355. {
  356. $param = $request->all();
  357. file_put_contents('dwy.txt', json_encode($param) . PHP_EOL, 8);
  358. //商标绑定
  359. $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/1';
  360. // $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/lead_bind';
  361. $header = [
  362. 'Content-Type:application/json',
  363. 'Authorization: ' . $request->header('Authorization'),
  364. ];
  365. $lead_bind = $param['lead_bind'];
  366. $this->post_helper($url, json_encode($lead_bind), $header);
  367. //商标出库
  368. // $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/lead_bind_out_stock';
  369. $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_in_stock/brand_in_stock/diy/11';
  370. $lead_bind = $param['lead_out'];
  371. $this->post_helper($url, json_encode($lead_bind), $header);
  372. return ['status'=>200,'msg'=>'success'];
  373. }
  374. public function post_helper($url, $data, $header)
  375. {
  376. $ch = curl_init();
  377. curl_setopt($ch, CURLOPT_POST, 1);
  378. curl_setopt($ch, CURLOPT_URL, $url);
  379. curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
  380. curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  381. curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
  382. curl_setopt($ch, CURLOPT_TIMEOUT, 30);
  383. if (!is_null($data)) curl_setopt($ch, CURLOPT_POSTFIELDS, $data);
  384. $r = curl_exec($ch);
  385. curl_close($ch);
  386. file_put_contents('33.txt',$r.PHP_EOL,8);
  387. return $r;
  388. }
  389. public function setTbData(Request $request){
  390. $data = $request->all();
  391. if(empty($data['id']) && empty($data['data'])) return [201, ''];
  392. BigKingTbj::updateOrCreate(
  393. ['id' => $data['id']], //查询条件
  394. [
  395. "id" => $data['id'],
  396. "data" => json_encode($data['data'])
  397. ] //添加或者修改的数据
  398. );
  399. return [200, ''];
  400. }
  401. public function getTbData(Request $request){
  402. $data = $request->all();
  403. if(empty($data['id'])) return [201, ''];
  404. $result = BigKingTbj::where('id',$data['id'])->first();
  405. if(empty($result)) return [200,'data' => []];
  406. $result = $result->toArray();
  407. return [200, 'data' => json_decode($result['data'],true)];
  408. }
  409. public function setBoxTrademark(Request $request){
  410. $url = 'https://tm.dwycloud.com/jbl/api/module-data/brand_sale_order/brand_sale_order/diy/find_roll_qr_code_list';
  411. $header = [
  412. 'Content-Type:application/json',
  413. 'Authorization: ' .'Bearer eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiI1NjYxNTc5MjMwMDUzNzAzNjgiLCJhdXRoIjoiUk9MRV9JTk5FUl9VU0VSLFJPTEVfQlJBTkRfU1VQUExJRVIsUk9MRV9JTlRFUkZBQ0UsUk9MRV9VU0VfQlJBTkRfU1VQUExJRVIsUk9MRV9TRU5EX0JSQU5EX1NVUFBMSUVSIiwidG9rZW5JZCI6IjQiLCJleHAiOjE3MTk2MzM1NTJ9.CC69s4dpUdd9UqQlpeK5UF3DwY5Zenn-YHv8Iy1ai0cCXgere7r7jskWU9ARmKotys2tCGYRlO-Idtxdwdsefg',
  414. ];
  415. $data = [
  416. 'roll_qr_code_list' => [
  417. '171368443563212'
  418. ]
  419. ];
  420. $a = $this->post_helper($url, json_encode($data), $header);
  421. var_dump($a);die;
  422. $a = json_decode($a,true);
  423. $detail = [];
  424. foreach ($a['data'] as $v){
  425. $code = $v['brand_qr_code'];
  426. $detail[] = $code;
  427. }
  428. file_put_contents('1.txt',json_encode($detail));
  429. var_dump($a);die;
  430. }
  431. public function getBoxTrademark(Request $request){
  432. $data = $request->all();
  433. if(empty($data['box_nos']) && empty($data['mac'])) return ['status' => 201,'data' => []];
  434. $box_nos = $data['box_nos'];
  435. $dv = $data['mac'];
  436. $detail = [];
  437. //测试写入文件
  438. // foreach ($box_nos as $v) {
  439. // $filePath = storage_path( "app/box_trade/"."{$dv}_{$v}.txt");
  440. // if (! file_exists(storage_path('box_trade'))) Storage::makeDirectory('box_trade');
  441. // file_put_contents($filePath,json_encode(['a' => '测试','b'=>'测试2']));
  442. // }
  443. //读取文件
  444. foreach ($box_nos as $v) {
  445. // $filePath = public_path($file_path . "{$dv}_{$v}.txt");
  446. $filePath = storage_path("app/box_trade/"."{$dv}_{$v}.txt");
  447. if(file_exists($filePath)){
  448. if (($content = file_get_contents($filePath)) === false) continue;
  449. $decodedContent = json_decode($content, true);
  450. if (json_last_error() !== JSON_ERROR_NONE) continue;
  451. $detail[] = [
  452. 'detail'=>$decodedContent,
  453. 'code'=>$v,
  454. ];
  455. }
  456. }
  457. return ['status' => 200, 'data' => $detail];
  458. }
  459. }