Blame view

application/admin/controller/kuerp/Sets.php 15.2 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
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
  <?php

  

  namespace app\admin\controller\kuerp;

  

  use app\common\controller\Backend;

  use think\Db;

  use Exception;

  /**

   * 设置

   *

   * @icon fa fa-circle-o

   */

  class Sets extends Backend

  {

  

      /**

       * Sets模型对象

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

       */

      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\Sets;

          $this->view->assign("typeList", $this->model->getTypeList());

      }

  

      public function import()

      {

          parent::import();

      }

  

      /**

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

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

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

       */

  

      public function index(){

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

              $params = $this->request->post("row/a");

              if ($params) {

                  if(isset($params['type']) && $params['type']==3){

                      //单号设置

                      $data = [];

                      $prefix = [];

                      foreach ($params['id'] as $k=>$v){

                          if(in_array($params['prefix'.$v],$prefix)){

                              $this->error('单号前缀'.$params['prefix'.$v].'重复');

                          }

                          $data[] = [

                              'id' => $v,

                              'prefix' => $params['prefix'.$v],

                              'year' => isset($params['year'.$v])?$params['year'.$v]:2,

                              'month' => isset($params['month'.$v])?$params['month'.$v]:2,

                              'day' => isset($params['day'.$v])?$params['day'.$v]:2,

                              'hour' => isset($params['hour'.$v])?$params['hour'.$v]:2,

                              'minute' => isset($params['minute'.$v])?$params['minute'.$v]:2,

                              'second' => isset($params['second'.$v])?$params['second'.$v]:2,

                              'start' => isset($params['start'.$v])?$params['start'.$v]:1,

                              'strlen' => isset($params['strlen'.$v])?$params['strlen'.$v]:1,

                              'example' => isset($params['example'.$v])?$params['example'.$v]:'',

                          ];

                          $datas = [

                              'id' => $v,

                              'prefix' => $params['prefix'.$v],

                              'year' => isset($params['year'.$v])?$params['year'.$v]:2,

                              'month' => isset($params['month'.$v])?$params['month'.$v]:2,

                              'day' => isset($params['day'.$v])?$params['day'.$v]:2,

                              'hour' => isset($params['hour'.$v])?$params['hour'.$v]:2,

                              'minute' => isset($params['minute'.$v])?$params['minute'.$v]:2,

                              'second' => isset($params['second'.$v])?$params['second'.$v]:2,

                              'start' => isset($params['start'.$v])?$params['start'.$v]:1,

                              'strlen' => isset($params['strlen'.$v])?$params['strlen'.$v]:1,

                              'example' => isset($params['example'.$v])?$params['example'.$v]:'',

                          ];

                          $row = Db::name('kuerp_prefix')->where(['id'=>$v])->find();

                          foreach ($row as $row_k=>$row_v){

                              if(isset($datas[$row_k]) && $datas[$row_k]!=$row_v){

                                  $order = Db::name($row['dbname'])->find();

                                  if($order){

                                      $this->error('已产生'.$row['name'].'数据,不可再修改'.$row['name'].'单号组合规则');

                                  }

                              }

                          }

                      }

                      if(!empty($data)){

                          $res = (new \app\admin\model\kuerp\Prefix())->saveAll($data);

                          if ($res) {

                              $this->success();

                          } else {

                              $this->error(__('No rows were inserted'));

                          }

                      }

                  }

                  if(isset($params['type']) && $params['type']==4){

                      $price_sale_last = $params['price_sale_last'];

                      $price_buy_last = $params['price_buy_last'];

                      $res = $this->model->where(['name'=>'price_sale_last'])->update(['is_checked'=>$price_sale_last]);

                      $res1 = $this->model->where(['name'=>'price_buy_last'])->update(['is_checked'=>$price_buy_last]);

                      if ($res || $res1) {

                          $this->success();

                      } else {

                          $this->error(__('没有更改设置项'));

                      }

                  }

                  foreach ($params as $params_k=>$params_v){

                      if($params_v['id']==8 || $params_v['id']==9){

                          $sets = Db::name('kuerp_sets')->where(['id'=>$params_v['id']])->value('value');

                          if($sets>$params_v['value']){

                              if($params_v['id']==8){

                                  $this->error('价格小数位数不可小于当前设置位数');

                              }

                              if($params_v['id']==9){

                                  $this->error('数量小数位数不可小于当前设置位数');

                              }

                          }

                          if($params_v['value']>4 && ($params_v['id']==8 || $params_v['id']==9)){

                              $this->error('小数位数最高不可超过4位');

                          }

                      }

                      if($params_v['id']==11 && (!isset($params_v['is_checked']) || (isset($params_v['is_checked']) && $params_v['is_checked']==0))){

                          $sets = Db::name('kuerp_sets')->where(['id'=>$params_v['id']])->value('is_checked');

                          if($sets==1){

                              $arr = [

                                  'kuerp_goods_purchase_order' => '购货订单',

                                  'kuerp_goods_purchase' => '购货单',

                                  'kuerp_goods_exchange' => '购货退货单',

                                  'kuerp_goods_sales_order' => '销货订单',

                                  'kuerp_goods_sales' => '销货单',

                                  'kuerp_goods_sales_exchange' => '销货退货单',

                                  'kuerp_allocation' => '调拨单',

                                  'kuerp_warehousing' => '其他入库单',

                                  'kuerp_warehouse' => '其他出库单',

                                  'kuerp_assemble' => '组装单',

                                  'kuerp_split' => '拆卸单',

                                  'kuerp_payment' => '付款单',

                                  'kuerp_collection' => '收款单',

                                  'kuerp_writeoff' => '核销单',

                                  'kuerp_income' => '其他收入单',

                                  'kuerp_expenditure' => '其他支出单',

                                  'kuerp_accounts_transfer' => '资金转账单',

                              ];

                              foreach ($arr as $arr_k=>$arr_v){

                                  $order =Db::name($arr_k)->where(['examine_status'=>'0'])->find();

                                  if($order){

                                      $this->error('你还有未审核的'.$arr_v.',不可取消审核功能');

                                  }

                              }

                          }

                      }

                      if($params_v['id']=='12'){

                          $check = self::checkOrder();

                          if(!$check['status']){

                              $price_taxes = Db::name('kuerp_sets')->where(['id'=>$params_v['id']])->find();

                              $params_v['is_checked'] = isset($params_v['is_checked'])?$params_v['is_checked']:0;

                              $params_v['value'] = isset($params_v['value'])?$params_v['value']:0;

                              if($price_taxes['is_checked']!=$params_v['is_checked']){

                                  return ['status'=>400,'msg'=>'你已产生'.$check['msg'].',不可编辑启用税金'];

                              }

                              if($price_taxes['value']!=$params_v['value']){

                                  return ['status'=>400,'msg'=>'你已产生'.$check['msg'].',不可编辑税金'];

                              }

                          }

                      }

                      if($params_v['id']=='13'){

                          $taxes = 0;

                          foreach ($params as $k=>$v){

                              $v['is_checked'] = isset($v['is_checked'])?$v['is_checked']:0;

                              if($v['id']=='12'){

                                  $taxes = $v['is_checked'];

                              }

                          }

                          if($taxes==0){

                              $taxes = Db::name('kuerp_sets')->where(['id'=>'12'])->value('is_checked');

                          }

                          $params_v['is_checked'] = isset($params_v['is_checked'])?$params_v['is_checked']:0;

                          if(empty($taxes) && $params_v['is_checked']==1){

                              return ['status'=>400,'msg'=>'必须启用税金才能设置商品价格是否含税'];

                          }

                          $check = self::checkOrder();

                          if(!$check['status']){

                              $price_taxes = Db::name('kuerp_sets')->where(['id'=>$params_v['id']])->value('is_checked');

                              if($price_taxes!=$params_v['is_checked']){

                                  return ['status'=>400,'msg'=>'你已产生'.$check['msg'].',不可编辑商品价格是否含税'];

                              }

                          }

                      }

                      if(($params_v['id']=='14' || $params_v['id']=='15' || $params_v['id']=='16') && (!isset($params_v['is_checked']) || (isset($params_v['is_checked']) && $params_v['is_checked']==0))){

                          $check = self::checkOrder();

                          $data_name = [

                              '14' => '辅助属性',

                              '15'    => '序列号',

                              '16'     => '批次保质期管理',

                          ];

                          if(!$check['status']){

                              $price_taxes = Db::name('kuerp_sets')->where(['id'=>$params_v['id']])->find();

                              $params_v['is_checked'] = isset($params_v['is_checked'])?$params_v['is_checked']:0;

                              if($price_taxes['is_checked']!=$params_v['is_checked']){

                                  return ['status'=>400,'msg'=>'你已产生'.$check['msg'].',不可关闭'.$data_name[$params_v['id']]];

                              }

                          }

                      }

  

                      if(isset($params_v['value'])){

                          if(is_array($params_v['value'])){

                              $params[$params_k]['value'] = implode(',',$params_v['value']);

                          }

                          if(!isset($params_v['is_checked'])){

                              $params[$params_k]['is_checked'] = 0;

                          }

                      }else{

                          $params[$params_k]['value'] = '';

                          $params[$params_k]['is_checked'] = 0;

                      }

                  }

                  foreach ($params as $params_k=>$params_v){

                      $params[$params_k] = $params_v;

                  }

  

                  $data = input();

                  if(isset($data['agreement']) && isset($data['privacy'])){

                      $agreement = $this->request->post("agreement",'');

                      $privacy = $this->request->post("privacy",'');

                      Db::name('kuerp_config')->where(['name'=>'agreement'])->update(['value'=>$agreement]);

                      Db::name('kuerp_config')->where(['name'=>'privacy'])->update(['value'=>$privacy]);

                  }

  

                  $result = false;

                  Db::startTrans();

                  try {

                      $result = $this->model->saveAll($params);

                      Db::commit();

                  } catch (Exception $e) {

                      Db::rollback();

                      $this->error($e->getMessage());

                  }

                  if (isset($result) && $result !== false) {

                      $this->success();

                  } else {

                      $this->error(__('No rows were inserted'));

                  }

              }

              $this->error(__('Parameter %s can not be empty', ''));

          }

          $sets = Db::name('kuerp_sets')->select();

          foreach ($sets as $sets_k=>$sets_v){

              if($sets_v['name']=='secret'){

                  unset($sets[$sets_k]);

              }

          }

          sort($sets);

          $xcx_agreement = Db::name('kuerp_config')->where(['name'=>'agreement'])->value('value');

          $xcx_privacy = Db::name('kuerp_config')->where(['name'=>'privacy'])->value('value');

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

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

  

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

          $prefix = Db::name('kuerp_prefix')->select();

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

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

      }

      public static function checkOrder(){

          $arr = [

              'kuerp_goods_purchase_order' => '购货订单',

              'kuerp_goods_purchase' => '购货单',

              'kuerp_goods_exchange' => '购货退货单',

              'kuerp_goods_sales_order' => '销货订单',

              'kuerp_goods_sales' => '销货单',

              'kuerp_goods_sales_exchange' => '销货退货单',

              'kuerp_allocation' => '调拨单',

              'kuerp_warehousing' => '其他入库单',

              'kuerp_warehouse' => '其他出库单',

              'kuerp_assemble' => '组装单',

              'kuerp_split' => '拆卸单',

              'kuerp_payment' => '付款单',

              'kuerp_collection' => '收款单',

              'kuerp_writeoff' => '核销单',

              'kuerp_income' => '其他收入单',

              'kuerp_expenditure' => '其他支出单',

              'kuerp_accounts_transfer' => '资金转账单',

          ];

          foreach ($arr as $arr_k=>$arr_v){

              $order = \think\Db::name($arr_k)->find();

              if($order){

                  return ['status'=>false,'msg'=>$arr_v];

              }

          }

          return ['status'=>true,'msg'=>''];

      }

  }