QcodeBach.php 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800
  1. <?php
  2. namespace app\admin\controller;
  3. use app\admin\model\QcodeCompany;
  4. use app\admin\model\QcodeProduct;
  5. use app\admin\model\QcodeGsmc;
  6. use app\admin\model\QcodeLarge;
  7. use app\admin\model\QcodeSmall;
  8. use app\common\controller\Backend;
  9. use \think\Session;
  10. use think\Db;
  11. /**
  12. *
  13. *
  14. * @icon fa fa-circle-o
  15. */
  16. class QcodeBach extends Backend
  17. {
  18. /**
  19. * Product模型对象
  20. * @var \app\admin\model\QcodeBach
  21. */
  22. protected $model = null;
  23. protected $multiFields = 'status';
  24. public function _initialize()
  25. {
  26. parent::_initialize();
  27. $this->model = new \app\admin\model\QcodeBach();
  28. }
  29. /**
  30. * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
  31. * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
  32. * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
  33. */
  34. /**
  35. * 查看
  36. */
  37. public function index()
  38. {
  39. //当前是否为关联查询
  40. $this->relationSearch = false;
  41. //设置过滤方法
  42. $this->request->filter(['strip_tags', 'trim']);
  43. return $this->view->fetch();
  44. }
  45. /**
  46. * 主表查询
  47. */
  48. public function bach()
  49. {
  50. //当前是否为关联查询
  51. $this->relationSearch = false;
  52. //设置过滤方法
  53. $this->request->filter(['strip_tags', 'trim']);
  54. if ($this->request->isAjax()) {
  55. //如果发送的来源是Selectpage,则转发到Selectpage
  56. if ($this->request->request('keyField')) {
  57. return $this->selectpage();
  58. }
  59. $userInfo = Session::get('admin');
  60. $company_id = (int)$userInfo['company'];
  61. $where = [
  62. 'delete_time'=> ''
  63. ];
  64. $req = input();
  65. $req['sort'] == 'id' ? $sort = '_id' : $sort = $req['sort'];
  66. $order = $req['order'];
  67. $offset = $req['offset'];
  68. $limit = $req['limit'];
  69. // 构造模糊查询条件
  70. // $regex = new MongoDB\BSON\Regex('.*abc.*', 'i');
  71. // $filter = ['field' => $regex];
  72. $filter = json_decode($req['filter'], true);
  73. foreach ($filter as $k => $v){
  74. $where[$k] = new \MongoDB\BSON\Regex($v);
  75. }
  76. $total = $this->model->name($company_id.'_'."qcode_bach")->where($where)->count();
  77. $list = $this->model->name($company_id.'_'."qcode_bach")->where($where)
  78. ->order($sort,$order)
  79. ->limit($limit)
  80. ->skip($offset)
  81. ->select();
  82. foreach ($list as $k=>$v) {
  83. $oid = $v['_id']->jsonSerialize();
  84. $list[$k]['id'] = $oid['$oid'];
  85. }
  86. $result = array("total" => $total, "rows" => $list);
  87. return json($result);
  88. }
  89. return $this->view->fetch();
  90. }
  91. /**
  92. * 大件列表
  93. */
  94. public function large()
  95. {
  96. //当前是否为关联查询
  97. $this->relationSearch = false;
  98. //设置过滤方法
  99. $this->request->filter(['strip_tags', 'trim']);
  100. if ($this->request->isAjax()) {
  101. //如果发送的来源是Selectpage,则转发到Selectpage
  102. if ($this->request->request('keyField')) {
  103. return $this->selectpage();
  104. }
  105. $userInfo = Session::get('admin');
  106. $company_id = (int)$userInfo['company'];
  107. $where = [
  108. // 'company_id'=>(int)$userInfo['company'],
  109. 'delete_time'=> ''
  110. ];
  111. $req = input();
  112. if($req['filter']=='{}'){
  113. $result = array("total" => 0, "rows" => []);
  114. return json($result);
  115. }
  116. $req['sort'] == 'id' ? $sort = '_id' : $sort = $req['sort'];
  117. $order = $req['order'];
  118. $offset = $req['offset'];
  119. $limit = $req['limit'];
  120. // 构造模糊查询条件
  121. // $regex = new MongoDB\BSON\Regex('.*abc.*', 'i');
  122. // $filter = ['field' => $regex];
  123. $filter = json_decode($req['filter'], true);
  124. foreach ($filter as $k => $v){
  125. $where[$k] = new \MongoDB\BSON\Regex($v);
  126. }
  127. $db = new QcodeLarge();
  128. $total = $db->name($company_id.'_'."qcode_large")->where($where)->count();
  129. $list = $db->name($company_id.'_'."qcode_large")->where($where)
  130. ->order($sort,$order)
  131. ->limit($limit)
  132. ->skip($offset)
  133. ->select();
  134. $qcodeSmall = new QcodeSmall();
  135. foreach ($list as $k=>$v) {
  136. $oid = $v['_id']->jsonSerialize();
  137. $list[$k]['id'] = $oid['$oid'];
  138. //设置当前托盘号
  139. $list[$k]['l_flow'] = ltrim(substr($v['code'],53,6),'0');
  140. //查询小件数量
  141. $small_num = $qcodeSmall->name($company_id.'_'."qcode_small")
  142. ->where('large_id',$oid['$oid'])
  143. ->count();
  144. $list[$k]['small_num'] = $small_num;
  145. //设置当前大件重量
  146. $list[$k]['l_weight'] = floatval($v['l_weight'])/100;
  147. }
  148. $result = array("total" => $total, "rows" => $list);
  149. return json($result);
  150. }
  151. return $this->view->fetch();
  152. }
  153. /**
  154. * 小件列表
  155. */
  156. public function small()
  157. {
  158. //设置过滤方法
  159. $this->request->filter(['strip_tags', 'trim']);
  160. $req = $this->request->param();
  161. if ($this->request->isAjax()) {
  162. //如果发送的来源是Selectpage,则转发到Selectpage
  163. if ($this->request->request('keyField')) {
  164. return $this->selectpage();
  165. }
  166. $userInfo = Session::get('admin');
  167. $company_id = (int)$userInfo['company'];
  168. $where = [
  169. 'delete_time'=> '',
  170. 'large_id'=> $req['large_id']
  171. ];
  172. $req = input();
  173. $req['sort'] == 'id' ? $sort = '_id' : $sort = $req['sort'];
  174. $order = $req['order'];
  175. $offset = $req['offset'];
  176. $limit = $req['limit'];
  177. // 构造模糊查询条件
  178. // $regex = new MongoDB\BSON\Regex('.*abc.*', 'i');
  179. // $filter = ['field' => $regex];
  180. $filter = json_decode($req['filter'], true);
  181. foreach ($filter as $k => $v){
  182. $where[$k] = new \MongoDB\BSON\Regex($v);
  183. }
  184. $qcodeSmall = new QcodeSmall();
  185. $total = $qcodeSmall->name($company_id.'_'."qcode_small")->where($where)->count();
  186. $list = $qcodeSmall->name($company_id.'_'."qcode_small")->where($where)
  187. ->order($sort,$order)
  188. ->limit($limit)
  189. ->skip($offset)
  190. ->select();
  191. foreach ($list as $k=>$v) {
  192. $oid = $v['_id']->jsonSerialize();
  193. $list[$k]['id'] = $oid['$oid'];
  194. $list[$k]['l_flow'] = $req['l_flow'].'-'.$v['l_flow'];
  195. }
  196. $result = array("total" => $total, "rows" => $list);
  197. return json($result);
  198. }
  199. return $this->view->fetch();
  200. }
  201. /**
  202. * 小件导出状态修改
  203. */
  204. public function small_status()
  205. {
  206. $req = $this->request->param();
  207. $ids = $req['ids'];
  208. $userInfo = Session::get('admin');
  209. $company_id = (int)$userInfo['company'];
  210. $qcodeSmall = new QcodeSmall();
  211. $status = $qcodeSmall->name($company_id.'_'."qcode_small")->where('_id', $ids)->value('status');
  212. if ($status === 0) {
  213. $newStatus = 1;
  214. } elseif ($status === 1) {
  215. $newStatus = 0;
  216. } else {
  217. // 处理其他情况,如果有需要
  218. }
  219. $bool = $qcodeSmall->name($company_id.'_'."qcode_small")->where('_id', $req['ids'])
  220. ->update(['status' => $newStatus]);
  221. if ($bool){
  222. $this->success("切换成功", null, ['id' => $ids]);
  223. }else{
  224. $this->error("切换失败", null, ['id' => $ids]);
  225. }
  226. }
  227. /**
  228. * 自动打码(大件)
  229. */
  230. public function print_l()
  231. {
  232. //设置过滤方法
  233. $this->request->filter(['strip_tags', 'trim']);
  234. $req = $this->request->param();
  235. if ($this->request->isAjax()) {
  236. $ids = $req['ids'];
  237. $type = $req['type'];
  238. $numn = $req['numn'];
  239. $userInfo = Session::get('admin');
  240. $company_id = (int)$userInfo['company'];
  241. $qcodeLarge = new QcodeLarge();
  242. $qcodeSmall = new QcodeSmall();
  243. $qcodeProduct = new QcodeProduct();
  244. $large = $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$ids[0])->find();
  245. $bach = $this->model->name($company_id.'_'."qcode_bach")->where('_id',json_decode($large,true)['bach_id'])->find();
  246. $row = $qcodeProduct->where('product_code',json_decode($bach,true)['matter_no'])->find();
  247. $company_name = json_decode($bach,true)['supplier_name'];
  248. $product_name = json_decode($bach,true)['matter_name'];
  249. // $date = json_decode($bach,true)['manufacture_date'];
  250. // $batch = json_decode($bach,true)['bach_num'];
  251. $main_unit = json_decode($row,true)['main_unit'];
  252. $sec_unit = json_decode($row,true)['sec_unit'];
  253. $proportion = json_decode($row,true)['proportion'];
  254. $rows = [];
  255. //查询打印大件码所需数据
  256. foreach ($ids as $key=>$value){
  257. $row = $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$value)->find();
  258. $row = json_decode($row,true);
  259. $code = $row['code'];
  260. $rows[$key]['company_name'] = $company_name;
  261. $rows[$key]['product_name'] = $product_name;
  262. $rows[$key]['sqrcd'] = $qcodeSmall->name($company_id.'_'."qcode_small")->where('large_id',$value)->count();
  263. $rows[$key]['main_unit'] = $main_unit;
  264. $rows[$key]['sec_unit'] = $sec_unit;
  265. $rows[$key]['date'] = substr_replace(substr_replace('20'.substr($code,38,6), '-', 4, 0), '-', 7, 0);
  266. $rows[$key]['l_flow'] = ltrim(substr($code,53,6),'0');
  267. $rows[$key]['qrcode'] = $code;
  268. $rows[$key]['pCode'] = $this->qrcode($code);
  269. //批次号特殊情况判断
  270. if (substr($code,76,10)=='0000000000'){
  271. $rows[$key]['batch'] = ltrim(substr($code,66,10),'0');
  272. }else{
  273. $rows[$key]['batch'] = ltrim(substr($code,66,10),'0').'、'.ltrim(substr($code,76,10),'0');
  274. }
  275. //转换关系判断
  276. if($row['l_num']===null){
  277. //走转换关系
  278. if ($proportion){
  279. $rows[$key]['num'] = $rows[$key]['sqrcd']*$proportion;
  280. $rows[$key]['num'] = floor($rows[$key]['num'] * 100) / 100;
  281. }else{
  282. $rows[$key]['num'] = '';
  283. }
  284. }else if($row['l_num']==0){
  285. //判断是否是公斤
  286. if($main_unit=='公斤'){
  287. //公斤使用l_weight
  288. $rows[$key]['num'] = $row['l_weight'];
  289. }else{
  290. //不是公斤走转换关系
  291. if ($proportion){
  292. $rows[$key]['num'] = $rows[$key]['sqrcd']*$proportion;
  293. $rows[$key]['num'] = floor($rows[$key]['num'] * 100) / 100;
  294. }else{
  295. $rows[$key]['num'] = '';
  296. }
  297. }
  298. }else{
  299. //箱, 使用l_num
  300. $rows[$key]['num'] = $row['l_num'];
  301. }
  302. }
  303. $data = [
  304. 'type'=>$type,
  305. 'numn'=>$numn,
  306. 'rows'=>$rows,
  307. 'ids'=>$ids,
  308. ];
  309. $this->success('成功','',$data);
  310. }
  311. $this->view->assign('ids',$req['ids']);
  312. return $this->view->fetch();
  313. }
  314. /**
  315. * 自动打码(小件)
  316. */
  317. public function print_s()
  318. {
  319. //设置过滤方法
  320. $this->request->filter(['strip_tags', 'trim']);
  321. $req = $this->request->param();
  322. if ($this->request->isAjax()) {
  323. $ids = $req['ids'];
  324. $type = $req['type'];
  325. $numn = $req['numn'];
  326. $userInfo = Session::get('admin');
  327. $company_id = (int)$userInfo['company'];
  328. $qcodeLarge = new QcodeLarge();
  329. $qcodeSmall = new QcodeSmall();
  330. $large = $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$ids[0])->find();
  331. $bach = $this->model->name($company_id.'_'."qcode_bach")->where('_id',json_decode($large,true)['bach_id'])->find();
  332. $company_name = json_decode($bach,true)['supplier_name'];
  333. $product_name = json_decode($bach,true)['matter_name'];
  334. //获取全部小件id
  335. $rows = [];
  336. $key = 0;
  337. foreach ($ids as $value){
  338. $large = $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$value)->find();
  339. $large = json_decode($large,true);
  340. $arr = $qcodeSmall->name($company_id.'_'."qcode_small")->where('large_id',$value)->column('_id');
  341. //查询打印大件码所需数据
  342. foreach ($arr as $v){
  343. $small = $qcodeSmall->name($company_id.'_'."qcode_small")->where('_id',$v->jsonSerialize()['$oid'])->find();
  344. $small = json_decode($small,true);
  345. $code = $small['code'];
  346. $rows[$key]['company_name'] = $company_name;
  347. $rows[$key]['product_name'] = $product_name;
  348. $rows[$key]['date'] = substr_replace(substr_replace('20'.substr($code,38,6), '-', 4, 0), '-', 7, 0);
  349. $rows[$key]['l_flow'] = ltrim(substr($large['code'],53,6),'0').'-'.$small['l_flow'];
  350. $rows[$key]['qrcode'] = $code;
  351. // $rows[$key]['pCode'] = $this->qrcode($code);
  352. //批次号特殊情况判断
  353. if (substr($code,76,10)=='0000000000'){
  354. $rows[$key]['batch'] = ltrim(substr($code,66,10),'0');
  355. }else{
  356. $rows[$key]['batch'] = ltrim(substr($code,66,10),'0').'、'.ltrim(substr($code,76,10),'0');
  357. }
  358. $key++;
  359. }
  360. }
  361. $data = [
  362. 'type'=>$type,
  363. 'numn'=>$numn,
  364. 'rows'=>$rows,
  365. 'ids'=>$ids,
  366. ];
  367. $this->success('成功','',$data);
  368. }
  369. $this->view->assign('ids',$req['ids']);
  370. return $this->view->fetch();
  371. }
  372. /**
  373. * 手动打码(小件)
  374. */
  375. public function print_ls()
  376. {
  377. //设置过滤方法
  378. $this->request->filter(['strip_tags', 'trim']);
  379. $req = $this->request->param();
  380. if ($this->request->isAjax()) {
  381. $ids = $req['ids'];
  382. $type = $req['type'];
  383. $numn = $req['numn'];
  384. $userInfo = Session::get('admin');
  385. $company_id = (int)$userInfo['company'];
  386. $qcodeLarge = new QcodeLarge();
  387. $qcodeSmall = new QcodeSmall();
  388. $small = $qcodeSmall->name($company_id.'_'."qcode_small")->where('_id',$ids)->find();
  389. $small = json_decode($small,true);
  390. $large = $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$small['large_id'])->find();
  391. $large = json_decode($large,true);
  392. $bach = $this->model->name($company_id.'_'."qcode_bach")->where('_id',$small['bach_id'])->find();
  393. $company_name = json_decode($bach,true)['supplier_name'];
  394. $product_name = json_decode($bach,true)['matter_name'];
  395. //获取全部小件id
  396. $rows = [];
  397. $code = $small['code'];
  398. $rows[0]['company_name'] = $company_name;
  399. $rows[0]['product_name'] = $product_name;
  400. $rows[0]['date'] = substr_replace(substr_replace('20'.substr($code,38,6), '-', 4, 0), '-', 7, 0);
  401. $rows[0]['l_flow'] = ltrim(substr($large['code'],53,6),'0').'-'.$small['l_flow'];
  402. $rows[0]['qrcode'] = $code;
  403. // $rows[0]['pCode'] = $this->qrcode($code);
  404. //批次号特殊情况判断
  405. if (substr($code,76,10)=='0000000000'){
  406. $rows[0]['batch'] = ltrim(substr($code,66,10),'0');
  407. }else{
  408. $rows[0]['batch'] = ltrim(substr($code,66,10),'0').'、'.ltrim(substr($code,76,10),'0');
  409. }
  410. $data = [
  411. 'type'=>$type,
  412. 'numn'=>$numn,
  413. 'rows'=>$rows,
  414. 'ids'=>$ids,
  415. ];
  416. $this->success('成功','',$data);
  417. }
  418. $this->view->assign('ids',$req['ids']);
  419. return $this->view->fetch();
  420. }
  421. /**
  422. * 打印数量设置
  423. */
  424. public function set_num()
  425. {
  426. $req = $this->request->param();
  427. //获取数据
  428. $status = $req['status'];
  429. $num = (int)$req['num'];
  430. $ids = $req['ids'];
  431. //获取company_id
  432. $userInfo = Session::get('admin');
  433. $company_id = (int)$userInfo['company'];
  434. //自动打印大件
  435. if($status==1){
  436. $qcodeLarge = new QcodeLarge();
  437. foreach ($ids as $v){
  438. $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$v)->setInc('p_nums',$num);
  439. $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$v)->setField('l_print','1');
  440. }
  441. }elseif($status==2){
  442. $qcodeSmall = new QcodeSmall();
  443. foreach ($ids as $v){
  444. $qcodeSmall->name($company_id.'_'."qcode_small")->where('large_id',$v)->setInc('p_nums',$num);
  445. }
  446. }elseif($status==3){
  447. $qcodeSmall = new QcodeSmall();
  448. $qcodeSmall->name($company_id.'_'."qcode_small")->where('_id',$ids)->setInc('p_nums',$num);
  449. }
  450. }
  451. /**
  452. * 导出excel跳转
  453. */
  454. public function exp()
  455. {
  456. //获取产品配置菜单id
  457. $bool = db('auth_rule')->field('id')->where('title','发货管理')->find();
  458. if ($bool){
  459. $this->success('成功','',$bool);
  460. }else{
  461. $this->error('未获取到菜单','',$bool);
  462. }
  463. }
  464. /**
  465. * 修改大件重量数量
  466. */
  467. public function edit($ids = NULL)
  468. {
  469. $req = $this->request->param();
  470. if ($this->request->isAjax()){
  471. parse_str($req['data'],$req);
  472. if(!isset($req['row']['type']) || empty($req['row']['type'])){
  473. $this->error('请选择修改类型');
  474. }
  475. if(!isset($req['row']['numn']) || empty($req['row']['numn'])){
  476. $this->error('请填写修改数量');
  477. }
  478. $ids = explode(',',$req['row']['ids']);
  479. $data = [
  480. 'update_time'=>time(),
  481. 'sync_flag'=>0
  482. ];
  483. $userInfo = Session::get('admin');
  484. $company_id = (int)$userInfo['company'];
  485. $qcodeLarge = new QcodeLarge();
  486. if($req['row']['type']==1){//修改大件重量
  487. $data['l_weight'] = intval($req['row']['numn']*100);
  488. foreach($ids as $val){
  489. //查询code
  490. $large = $qcodeLarge->name($company_id.'_'."qcode_large")->field('code')->where('_id',$val)->find();
  491. $code = json_decode($large,true)['code'];
  492. if($code){
  493. $code1 = substr($code,0,59);
  494. $code2 = substr($code,65,85);
  495. $data['code'] = $code1.str_pad(intval($req['row']['numn'])*100,6, '0', STR_PAD_LEFT).$code2;
  496. //修改code和大件重量
  497. $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$val)->update($data);
  498. }
  499. }
  500. $this->success('修改成功');
  501. }
  502. if($req['row']['type']==2){//修改大件总张数
  503. $data['l_num'] = intval($req['row']['numn']);
  504. foreach($ids as $val){
  505. //查询l_num, 判断是否可以修改总张数
  506. $large = $qcodeLarge->name($company_id.'_'."qcode_large")->field('l_num')->where('_id',$val)->find();
  507. $l_num = json_decode($large,true)['l_num'];
  508. if($l_num > 0 || $l_num==null){
  509. //可以修改
  510. $qcodeLarge->name($company_id.'_'."qcode_large")->where('_id',$val)->update($data);
  511. }else{
  512. $this->error('该产品不能修改大件数量');
  513. }
  514. }
  515. $this->success('修改成功');
  516. }
  517. }
  518. $this->view->assign('ids',$req['ids']);
  519. return $this->view->fetch();
  520. }
  521. /**
  522. * 删除批次
  523. */
  524. public function del($ids = NULL)
  525. {
  526. $userInfo = Session::get('admin');
  527. $company_id = (int)$userInfo['company'];
  528. $qcodeLarge = new QcodeLarge();
  529. $qcodeSmall = new QcodeSmall();
  530. $data = [
  531. 'delete_time'=>time(),
  532. ];
  533. $bool1 = $this->model->name($company_id.'_'."qcode_bach")->where('_id',$ids)->update($data);
  534. $bool2 = $qcodeLarge->name($company_id.'_'."qcode_large")->where('bach_id',$ids)->update($data);
  535. $bool3 = $qcodeSmall->name($company_id.'_'."qcode_small")->where('bach_id',$ids)->update($data);
  536. if($bool1!==false && $bool2!==false && $bool3!==false){
  537. $this->success('删除成功');
  538. }else{
  539. $this->error('删除失败');
  540. }
  541. }
  542. /**
  543. * 补打标签
  544. */
  545. public function reprint()
  546. {
  547. if ($this->request->isAjax()) {
  548. $data = $this->request->param();
  549. parse_str($data['data'],$req);
  550. if(!isset($req['row']['nickname']) || empty($req['row']['nickname'])){
  551. $this->error('请填写公司名称');
  552. }
  553. if((!isset($req['row']['product_name']) || empty($req['row']['product_name'])) && (!isset($req['row']['product_code']) || empty($req['row']['product_code']))){
  554. $this->error('请填写辅料名称或辅料编号');
  555. }
  556. if(!isset($req['row']['sqrcd']) || empty($req['row']['sqrcd'])){
  557. $this->error('请填写配盘数');
  558. }
  559. if(!isset($req['row']['num']) || empty($req['row']['num'])){
  560. $this->error('请填写数量');
  561. }
  562. //查询公司信息
  563. $qcodeGsmc = new QcodeGsmc();
  564. $print_code = $qcodeGsmc
  565. ->field('id, nickname, print_code')
  566. ->where('nickname',$req['row']['nickname'])
  567. ->find();
  568. if (!$print_code) $this->error('未查到公司信息');
  569. $print_code = json_decode($print_code,true);
  570. //查询产品信息
  571. $qcodeProduct = new QcodeProduct();
  572. if(!empty($req['row']['product_code'])){
  573. $sel = $qcodeProduct
  574. ->field('id, product_name, product_code, temple')
  575. ->where('product_code',$req['row']['product_code'])
  576. ->find();
  577. }else{
  578. $sel = $qcodeProduct
  579. ->field('id, product_name, product_code, temple')
  580. ->where('product_name',$req['row']['product_name'])
  581. ->find();
  582. }
  583. if (!$sel) $this->error('未查到辅料信息');
  584. $sel = json_decode($sel,true);
  585. $data = [
  586. 'company_name'=>$req['row']['nickname'],
  587. 'product_name'=>$sel['product_name'],
  588. 'sqrcd'=>$req['row']['sqrcd'],
  589. 'num'=>$req['row']['num'],
  590. 'main_unit'=>'盘',
  591. 'sec_unit'=>'万米',
  592. 'date'=>date('Y-m-d'),
  593. 'batch'=>substr(date('Ymd'),2,6),
  594. 'l_flow'=>1,
  595. ];
  596. $num = str_pad($req['row']['num'], 3, '0', STR_PAD_LEFT);
  597. $qrcode = 'AB'.'92'.$sel['temple'].'0'.$print_code['print_code'].('000'.$sel['product_code']).$data['batch'].$num.$data['batch'].'000001'.'000000'.'2'.'0000'.$data['batch'].'0000000000';
  598. $data['pCode'] = $this->qrcode($qrcode);
  599. $data['qrcode'] = $qrcode;
  600. $this->success('成功','',$data);
  601. }
  602. return $this->view->fetch();
  603. }
  604. /**
  605. * 公司名称搜索
  606. */
  607. public function sel_n()
  608. {
  609. $name = $this->request->param()['q_word'][0];
  610. $where = [
  611. 'nickname'=>new \MongoDB\BSON\Regex($name),
  612. 'delete_time'=>'',
  613. ];
  614. $qcodeGsmc = new QcodeGsmc();
  615. $sel = $qcodeGsmc
  616. ->field('nickname')
  617. ->where($where)
  618. ->limit(0,10)
  619. ->select();
  620. return json(['list' => $sel, 'total' => count($sel)]);
  621. }
  622. /**
  623. * 辅料名称搜索
  624. */
  625. public function sel_p()
  626. {
  627. $name = $this->request->param()['q_word'][0];
  628. $where = [
  629. 'product_name'=>new \MongoDB\BSON\Regex($name),
  630. 'delete_time'=>'',
  631. ];
  632. $qcodeProduct = new QcodeProduct();
  633. $sel = $qcodeProduct
  634. ->field('product_name, product_code')
  635. ->where($where)
  636. ->limit(0,10)
  637. ->select();
  638. foreach ($sel as $k=>$v) {
  639. $oid = $v['_id']->jsonSerialize();
  640. $sel[$k]['id'] = $oid['$oid'];
  641. }
  642. return json(['list' => $sel, 'total' => count($sel)]);
  643. }
  644. /**
  645. * 辅料编码搜索
  646. */
  647. public function sel_c()
  648. {
  649. $name = $this->request->param()['q_word'][0];
  650. $where = [
  651. 'product_code'=>new \MongoDB\BSON\Regex($name),
  652. 'delete_time'=>'',
  653. ];
  654. $qcodeProduct = new QcodeProduct();
  655. $sel = $qcodeProduct
  656. ->field('id, product_name, product_code')
  657. ->where($where)
  658. ->limit(0,10)
  659. ->select();
  660. foreach ($sel as $k=>$v) {
  661. $oid = $v['_id']->jsonSerialize();
  662. $sel[$k]['id'] = $oid['$oid'];
  663. }
  664. return json(['list' => $sel, 'total' => count($sel)]);
  665. }
  666. /**
  667. * 二维码生成类
  668. */
  669. public function qrcode($url)//二维码生成类
  670. {
  671. $url=$url;
  672. $level=3;
  673. $size=6;
  674. Vendor('phpqrcode.phpqrcode');//加载生成二维码的核心类
  675. $errorCorrectionLevel =intval($level) ;//容错级别
  676. $matrixPointSize = intval($size);//生成图片大小
  677. //生成二维码图片
  678. $object = new \QRcode();
  679. //打开缓冲区
  680. ob_start();
  681. $object->png($url, false, $errorCorrectionLevel, $matrixPointSize, 2);
  682. //这里就是把生成的图片流从缓冲区保存到内存对象上,使用base64_encode变成编码字符串,通过json返回给页面。
  683. $imageString = base64_encode(ob_get_contents());
  684. //关闭缓冲区
  685. ob_end_clean();
  686. //把生成的base64字符串返回给前端
  687. // $data = array(
  688. // 'labelcode'=>$url,
  689. // 'code'=>200,
  690. // 'data'=>$imageString,
  691. // 'product_code'=>$url
  692. // );
  693. return 'data:image/png;base64,'.$imageString;
  694. }
  695. }