Blame view

application/admin/controller/kuerp/GoodsSerialLog.php 5.13 KB
2db47680   hexiaodong   chore: 初始提交 php 遗...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
  <?php

  

  namespace app\admin\controller\kuerp;

  

  use app\common\controller\Backend;

  

  /**

   * 商品序列跟踪号

   *

   * @icon fa fa-circle-o

   */

  class GoodsSerialLog extends Backend

  {

      

      /**

       * GoodsSerialLog模型对象

       * @var \app\admin\model\kuerp\GoodsSerialLog

       */

      protected $model = null;

  

      public function _initialize()

      {

          parent::_initialize();

          $setData = (new Goods())->getSetData();

          $this->assign('set', $setData['setList']);

          $this->assignconfig('set',$setData['setList']);

          $this->assign('nowmenu', $setData['nowmenu']);

  

          $this->model = new \app\admin\model\kuerp\GoodsSerialLog;

          $this->view->assign("businessTypeList", $this->model->getBusinessTypeList());

          $this->view->assign("storeStatusList", $this->model->getStoreStatusList());

  

          $serialList = $this->model->getSerialList();

          $serialLists = [];

          foreach ($serialList as $serialList_k=>$serialList_v){

              $serialLists[] = ['name'=>$serialList_v['serial'],'value'=>$serialList_v['serial']];

          }

          $this->view->assign("serialList", $serialList);

          $this->assignconfig("serialList", $serialLists);

  

          $goodsList = $this->model->getGoodsList();

          $goodsLists = [];

          foreach ($goodsList as $goodsList_k=>$goodsList_v){

              $goodsLists[] = ['name'=>$goodsList_v['goods_name'],'value'=>$goodsList_v['id']];

          }

          $this->view->assign("goodsList", $goodsList);

          $this->assignconfig("goodsList", $goodsLists);

      }

  

      public function import()

      {

          parent::import();

      }

  

      /**

       * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法

       * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑

       * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改

       */

      

  

      /**

       * 查看

       */

      public function index()

      {

          //当前是否为关联查询

          $this->relationSearch = true;

          //设置过滤方法

          $this->request->filter(['strip_tags', 'trim']);

          if ($this->request->isAjax()) {

              //如果发送的来源是Selectpage,则转发到Selectpage

              if ($this->request->request('keyField')) {

                  return $this->selectpage();

              }

              list($where, $sort, $order, $offset, $limit) = $this->buildparams();

  

              $list = $this->model

                      ->with(['goods','stores'])

                      ->where($where)

                      ->where((new Goods())->setWhere([],'kuerp_goods_serial_log'))

                      ->order('serial asc,createtime asc')

                      ->paginate($limit);

  

              foreach ($list as $row) {

                  

                  $row->getRelation('goods')->visible(['goods_code','goods_name','goods_barcode','goods_specification_id']);

  				$row->getRelation('stores')->visible(['store_code','name']);

              }

              $listData = $list->items();

              $lists = array_reverse($list->items());

              $serial_id = '';

              foreach ($lists as $lists_k=>$lists_v){

                  if($serial_id==$lists_v['serial']){

                      unset($lists[$lists_k]);

                  }else{

                      $serial_id=$lists_v['serial'];

                  }

              }

              foreach ($listData as $listData_k=>$listData_v){

                  $listData[$listData_k]['goods_code'] = $listData_v['goods']['goods_code'];

                  $listData[$listData_k]['goods_name'] = $listData_v['goods']['goods_name'];

                  $listData[$listData_k]['goods_spec'] = $listData_v['goods']['goods_specification_id'];

                  $listData[$listData_k]['store_name'] = $listData_v['stores']['name'];

                  //供应商/客户

                  if($listData_v['business_type']==2 || $listData_v['business_type']==3 || $listData_v['business_type']==8 || $listData_v['business_type']==9){

                      $listData[$listData_k]['customer_id'] = \think\Db::name('kuerp_suppliers')->where((new Goods())->setWhere(['id'=>$listData_v['customer_id']]))->value('supplyer_name');

                  }else if($listData_v['business_type']==4 || $listData_v['business_type']==5 || $listData_v['business_type']==10 || $listData_v['business_type']==11){

                      $listData[$listData_k]['customer_id'] = \think\Db::name('kuerp_customers')->where((new Goods())->setWhere(['id'=>$listData_v['customer_id']]))->value('customer_name');

                  }

                  foreach ($lists as $lists_k=>$lists_v){

                      if($listData_v['id']!=$lists_v['id'] && $listData_v['serial']==$lists_v['serial']){

                          $listData[$listData_k]['store_status'] = '';

                      }

                  }

              }

              $result = array("total" => $list->total(), "rows" => $listData);

  

              return json($result);

          }

          return $this->view->fetch();

      }

  

  }