Blame view

application/admin/controller/kuerp/Prints.php 80.6 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
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
1335
1336
1337
1338
1339
1340
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
1394
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
  <?php

  

  namespace app\admin\controller\kuerp;

  

  use app\common\controller\Backend;

  use think\Db;

  use Exception;

  use think\Session;

  /**

   * 打印

   *

   * @icon fa fa-circle-o

   */

  class Prints extends Backend

  {

      protected $noNeedRight = '*';

  

      public function _initialize()

      {

          parent::_initialize();

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

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

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

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

      }

      function getGoods($goods_code='',$goods_attr='',$goods_id=''){

          if(!empty($goods_code)){

              $goods = Db::name('kuerp_goods')->where(['goods_code'=>$goods_code])->find();

          }else{

              $goods = Db::name('kuerp_goods')->where(['id'=>$goods_id])->find();

          }

          $attr_name = '';

          $goods_attr = Db::name('kuerp_goods_attr')->where(['id'=>$goods_attr])->value('attribute_id');

          if($goods_attr){

              $aux_combination = Db::name('kuerp_aux_combination')->where(['id'=>$goods_attr])->value('attr_ids');

              if($aux_combination){

                  $attr_ids = explode('&',$aux_combination);

                  $auxiliary = Db::name('kuerp_auxiliary')->where(['id'=>['in',$attr_ids]])->column('name');

                  $attr_name = implode('/',$auxiliary);

              }

          }

          $goods['goods_name'] = $goods['goods_name'].(empty($goods['goods_specification_id'])?'':'_').$goods['goods_specification_id'].(empty($attr_name)?'':'_').$attr_name;

          return $goods;

      }

      /**

       * 查看

       */

      public function prints()

      {

          $data = input();

          $id = isset($data['id'])?$data['id']:'';

          $type = isset($data['type'])?$data['type']:'';

          if(empty($id) || empty($type)){

              $this->error('参数错误');

          }

  

          //获取设置

          $set= \think\Db::name('kuerp_sets')->field('type,name,value,is_checked,set')->select();

          $setList = [];

          foreach ($set as $set_k=>$set_v){

              if(!empty($set_v['set'])){

                  $set_v['set'] = unserialize($set_v['set']);

              }

              $setList[$set_v['name']] = $set_v;

          }

          //数量价格格式化

          $number_decimal = $setList['number_decimal']['value'];

          $price_decimal  = $setList['price_decimal']['value'];

  

          $this->view->assign("company_name", $setList['company_name']['value']);

  

          switch($type){

              case 1:

                  $list = Db::name('kuerp_goods_purchase_order')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_goods_purchase_order')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_goods_purchase_order_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $goods = $this->getGoods($v['goods_code'],$v['goods_attr']);

                          $purchase_info[$k]['goods'] = $goods;

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['money_tax_price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

  

                      $suppliers = Db::name('kuerp_suppliers')->where(['supplyer_code'=>$row['supplyer_code']])->find();

                      $row['suppliers'] = $suppliers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 2:

                  $list = Db::name('kuerp_goods_purchase')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_goods_purchase')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_goods_purchase_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $goods = $this->getGoods($v['goods_code'],$v['goods_attr']);

                          $purchase_info[$k]['goods'] = $goods;

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['money_tax_price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['money_tax_price'] = round(($row['real_money']+$row['preferential_money']),$price_decimal);

                      $row['purchase_info'] = $purchase_info;

  

                      $suppliers = Db::name('kuerp_suppliers')->where(['supplyer_code'=>$row['supplyer_code']])->find();

                      $row['suppliers'] = $suppliers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 3:

                  $list = Db::name('kuerp_goods_exchange')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_goods_exchange')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_goods_exchange_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $purchase_info[$k]['number'] = $v['number'] = $v['retreat_number'];

                          $goods = $this->getGoods($v['goods_code'],$v['goods_attr']);

                          $purchase_info[$k]['goods'] = $goods;

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['money_tax_price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['money_tax_price'] = round(($row['real_money']+$row['preferential_money']),$price_decimal);

                      $row['purchase_info'] = $purchase_info;

  

                      $suppliers = Db::name('kuerp_suppliers')->where(['supplyer_code'=>$row['supplyer_code']])->find();

                      $row['suppliers'] = $suppliers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 4:

                  $list = Db::name('kuerp_goods_sales_order')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_goods_sales_order')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_goods_sales_order_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $goods = $this->getGoods($v['goods_code'],$v['goods_attr']);

                          $purchase_info[$k]['goods'] = $goods;

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['money_tax_price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['staff_member'] = Db::name('kuerp_staff_member')->where(['id'=>$row['sale_user']])->find();

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

  

                      $customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->find();

                      $row['customers'] = $customers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 5:

                  $list = Db::name('kuerp_goods_sales')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_goods_sales')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_goods_sales_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $goods = $this->getGoods($v['goods_code'],$v['goods_attr']);

                          $purchase_info[$k]['goods'] = $goods;

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['money_tax_price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['staff_member'] = Db::name('kuerp_staff_member')->where(['id'=>$row['sale_user']])->find();

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

  

                      $customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->find();

                      $row['customers'] = $customers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 6:

                  $list = Db::name('kuerp_goods_sales_exchange')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_goods_sales_exchange')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_goods_sales_exchange_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $purchase_info[$k]['number'] = $v['number'] = $v['retreat_number'];

                          $goods = $this->getGoods($v['goods_code'],$v['goods_attr']);

                          $purchase_info[$k]['goods'] = $goods;

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['money_tax_price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['staff_member'] = Db::name('kuerp_staff_member')->where(['id'=>$row['sale_user']])->find();

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

  

                      $customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->find();

                      $row['customers'] = $customers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'cgmx':

                  $page = isset($data['page'])?$data['page']:1;

                  $limit = isset($data['limit'])?$data['limit']:10;

                  $search = (array)json_decode($data['search'], true);

                  $where = [];

                  $where['examine_status'] = '1';

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

                      if(strpos($v,' - ') !== false && strpos($k,'time') !== false){

                          $str = explode(' - ',$v);

                          $where[$k] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];

                      }else{

                          $where[$k] = ["LIKE", "%{$v}%"];

                      }

                  }

                  $list = Db::name('kuerp_goods_purchase_info')->where($where)->page($page,$limit)->select();

                  foreach ($list as $list_k=>$list_v){

                      $goods = $this->getGoods($list_v['goods_code'],$list_v['goods_attr']);

                      $list[$list_k]['goods'] = $goods;

                      $list[$list_k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$list_v['goods_unit']])->find();

                      $list[$list_k]['suppliers'] = Db::name('kuerp_suppliers')->where(['supplyer_code'=>$list_v['supplyer_code']])->find();

                      $list[$list_k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$list_v['stores_id']])->find();

                  }

  

                  foreach ($list as $list_k=>$list_v){

                      if($list_v['purchase_type']==1){

                          $note = Db::name('kuerp_goods_purchase')->where(['purchase_code'=>$list_v['purchase_code']])->value('note');

                      }else{

                          $note = Db::name('kuerp_goods_exchange')->where(['purchase_code'=>$list_v['purchase_code']])->value('note');

                          $list[$list_k]['number'] = -$list_v['number'];

                          $list[$list_k]['all_money'] = -$list_v['all_money'];

                          $list[$list_k]['tax_money'] = -$list_v['tax_money'];

                          $list[$list_k]['money_tax_price'] = -$list_v['money_tax_price'];

                      }

                      $list[$list_k]['note'] = $note;

  

                      $list[$list_k]['number'] = round($list[$list_k]['number'],$number_decimal);

                      $list[$list_k]['unit_price'] = round($list[$list_k]['unit_price'],$price_decimal);

                      $list[$list_k]['tax_included'] = round($list[$list_k]['tax_included'],$price_decimal);

                      $list[$list_k]['all_money'] = round($list[$list_k]['all_money'],$price_decimal);

                      $list[$list_k]['purchase_money'] = round($list[$list_k]['purchase_money'],$price_decimal);

                      $list[$list_k]['tax_money'] = round($list[$list_k]['tax_money'],$price_decimal);

                      $list[$list_k]['money_tax_price'] = round($list[$list_k]['money_tax_price'],$price_decimal);

                  }

  

                  $number = Db::name('kuerp_goods_purchase_info')->where($where)->sum('number');

                  $all_money = Db::name('kuerp_goods_purchase_info')->where($where)->sum('all_money');

                  $purchase_money = Db::name('kuerp_goods_purchase_info')->where($where)->sum('purchase_money');

                  $tax_money = Db::name('kuerp_goods_purchase_info')->where($where)->sum('tax_money');

                  $money_tax_price = Db::name('kuerp_goods_purchase_info')->where($where)->sum('money_tax_price');

  

                  if($number>0){

                      $unit_price = round($all_money/$number,$price_decimal);

                      $tax_included = round($money_tax_price/$number,$price_decimal);

                  }else{

                      $unit_price = 0;

                      $tax_included = 0;

                  }

                  $number = round($number,$number_decimal);

                  $all_money = round($all_money,$price_decimal);

                  $purchase_money = round($purchase_money,$price_decimal);

                  $tax_money = round($tax_money,$price_decimal);

                  $money_tax_price = round($money_tax_price,$price_decimal);

                  $count = ['number'=>$number,'unit_price'=>$unit_price,'tax_included'=>$tax_included,'all_money'=>$all_money,'purchase_money'=>$purchase_money,'tax_money'=>$tax_money,'money_tax_price'=>$money_tax_price];

  

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

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

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

                  break;

              case 'cgddgz':

                  $search = (array)json_decode($data['search'], true);

                  $where = [];

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

                      if(strpos($v,' - ') !== false && strpos($k,'time') !== false){

                          $str = explode(' - ',$v);

                          $where['i.'.$k] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];

                      }else{

                          $where['i.'.$k] = ["LIKE", "%{$v}%"];

                      }

                  }

  

                  $field = empty(input('field'))?'goods_code':trim(input('field'));

                  $order = empty(input('sort'))?'DESC':trim(input('sort'));

  

                  $list = Db::name('kuerp_goods_purchase_order_info')->alias('i')

                      ->join('kuerp_goods_purchase_order po','po.purchase_code=i.purchase_code')

                      ->join('kuerp_goods g','g.goods_code=i.goods_code')

                      ->join('kuerp_unit u','u.id=i.default_unit')

                      ->join('kuerp_suppliers s','s.supplyer_code=i.supplyer_code')

                      ->join('kuerp_stores r','r.id=i.stores_id')

                      ->where($where)

                      ->order(['i.'.$field=>$order,'i.purchase_time'=>'DESC'])

                      ->field('i.id,i.goods_attr,i.goods_code,i.purchase_code,i.purchase_type,i.purchase_time,i.delivery_time

                  ,i.supplyer_code,i.money_tax_price,po.status,i.number,i.tax_included,i.number as library_number,i.money_tax_price as library_money,i.library_time,

                  g.goods_name,g.goods_specification_id,

                  s.supplyer_code as s_code,s.supplyer_name as s_name,

                  r.name as r_name,

                  u.name as unitname')

                      ->select();

                  foreach ($list as $list_k=>$list_v){

                      $purord_info = Db::name('kuerp_goods_purord_info')->where(['order_id'=>$list_v['id'],'status'=>'1'])->field('sum(number) as number,sum(money_tax_price) as all_money')->find();

  

                      $p_id = Db::name('kuerp_goods_purord_info')->where(['order_id'=>$list_v['id'],'status'=>'1'])->value('purchase_id');

                      $goods_excpur_info = Db::name('kuerp_goods_excpur_info')->where(['purchase_id'=>$p_id,'status'=>'1'])->find();

                      if($goods_excpur_info){

                          $purord_info['number'] = round( ($purord_info['number']-$goods_excpur_info['number']),2 );

                          $purord_info['all_money'] = round( ($purord_info['all_money']-$goods_excpur_info['money_tax_price']),2 );

                      }

  

                      if($purord_info){

                          $list[$list_k]['library_number'] = round(($list[$list_k]['library_number']-$purord_info['number']),2);

                          $list[$list_k]['library_money'] = round(($list[$list_k]['library_money']-$purord_info['all_money']),4);

                      }

                      if($list[$list_k]['library_number']>0 && $list[$list_k]['library_number']<$list[$list_k]['number']){

                          $list[$list_k]['status'] = 2;

                      }else if($list[$list_k]['library_number']>0 && $list[$list_k]['library_number']=$list[$list_k]['number']){

                          $list[$list_k]['status'] = 0;

                      }

                      $purord_time = Db::name('kuerp_goods_purord_info')->where(['order_id'=>$list_v['id'],'status'=>1])->order('times','DESC')->value('times');

                      if($purord_time){

                          $list[$list_k]['library_time'] = $purord_time;

                      }

                  }

  

                  foreach ($list as $list_k=>$list_v){

                      $goods = $this->getGoods($list_v['goods_code'],$list_v['goods_attr']);

                      $list[$list_k]['goods_name'] = isset($goods['goods_name'])?$goods['goods_name']:$list_v['goods_name'];

                      if($list_v['purchase_type']==2){

                          $list[$list_k]['number'] = -$list_v['number'];

                          $list[$list_k]['money_tax_price'] = -$list_v['money_tax_price'];

                          $list[$list_k]['library_number'] = -$list_v['library_number'];

                          $list[$list_k]['library_money'] = -$list_v['library_money'];

                      }

                  }

  

                  $count = [

                      'number'=>0,

                      'money_tax_price'=>0,

                      'library_number'=>0,

                      'library_money'=>0,

                  ];

                  $counts = $count;

                  $counts['purchase_type'] = '合计';

                  $data = [];

                  $now = isset($list[0][$field])?$list[0][$field]:'';

                  foreach ($list as $list_k=>$list_v){

                      if($list_v[$field]!=$now){

                          $now = $list_v[$field];

                          $row = $count;$row['purchase_type'] = '小计';

                          $data[] = $row;

                          foreach ($count as $count_k=>$count_v){

                              $count[$count_k] = $list_v[$count_k];

                              $counts[$count_k] += $list_v[$count_k];

                          }

                      }else{

                          foreach ($count as $count_k=>$count_v){

                              $count[$count_k] += $list_v[$count_k];

                              $counts[$count_k] += $list_v[$count_k];

                          }

                      }

                      $data[] = $list_v;

                      if($list_k==(sizeof($list)-1) || sizeof($list)==1){

                          $row = $count;$row['purchase_type'] = '小计';

                      }

                  }

                  $this->view->assign("list", $data);

                  $this->view->assign("count", $row);

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

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

                  break;

              case 'cghzb_sp':

                  $search = (array)json_decode($data['search'], true);

                  $where = [];

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

                      if(strpos($v,' - ') !== false && strpos($k,'time') !== false){

                          $str = explode(' - ',$v);

                          $where['i.'.$k] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];

                      }else{

                          $where['i.'.$k] = ["LIKE", "%{$v}%"];

                      }

                  }

  

                  $field = empty(input('field'))?'goods_code':trim(input('field'));

                  $order = empty(input('sort'))?'DESC':trim(input('sort'));

  

                  $price_decimal = \think\Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'price_decimal']))->value('value');

                  $number_decimal = \think\Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'number_decimal']))->value('value');

  

                  $list = [];

                  $lists = Db::name('kuerp_goods_purchase_summary')->alias('i')

                      ->join('kuerp_goods g','g.goods_code=i.goods_code')

                      ->join('kuerp_goods_type gt','gt.id=g.goods_type_id')

                      ->join('kuerp_stores s','s.id=i.stores_id')

                      ->join('kuerp_unit u','u.id=i.goods_unit')

                      ->where($where)

                      ->order(['i.'.$field=>$order])

                      ->group('i.goods_code,i.stores_id')

                      ->field('sum(i.tax_money) as tax_money,sum(i.money_tax_price) as money_tax_price,i.goods_code,i.stores_id,sum(i.basic_nmber) as basic_nmber,sum(number) as i_number,sum(all_money) as all_money,i.default_unit,i.goods_unit,i.purchase_money,

                  g.goods_code,g.goods_name,g.goods_specification_id,

                  gt.supplier_type_name,

                  s.name as s_name,u.name as u_name')

                      ->select();

                  if(!empty($lists)){

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

                          $lists_v['i_number'] = $lists_v['basic_nmber'];

                          $lists_v['unit_conversion'] = Db::name('kuerp_unit_conversion')->where(['main_unit'=>$lists_v['default_unit'],'vice_unit'=>$lists_v['goods_unit']])->value('advance_rate');

                          if(!empty($list)){

                              foreach ($list as $list_k=>$list_v){

                                  if($list_v['goods_code']==$lists_v['goods_code'] && $list_v['stores_id']==$lists_v['stores_id']){

                                      $list[$list_k]['i_number'] += $lists_v['i_number'];

                                      $list[$list_k]['all_money'] += $lists_v['all_money'];

                                      $list[$list_k]['purchase_money'] += $lists_v['purchase_money'];

                                      $list[$list_k]['unit_price'] = round(($list[$list_k]['all_money']/$list[$list_k]['i_number']),$price_decimal);

                                      $status = true;

                                      if($list[$list_k]['i_number']%$lists_v['basic_nmber']>0){

                                          $list[$list_k]['basic_nmber'] = floor($list[$list_k]['i_number']/$lists_v['unit_conversion']).$lists_v['u_name'].($list[$list_k]['i_number']%$lists_v['unit_conversion']).$list_v['u_name'];

                                      }else{

                                          $list[$list_k]['basic_nmber'] = floor($list[$list_k]['i_number']/$lists_v['unit_conversion']).$lists_v['u_name'];

                                      }

                                      $list[$list_k]['unit_conversion'] = '1'.$lists_v['u_name'].'='.$lists_v['unit_conversion'].$list_v['u_name'];

                                  }

                              }

                          }

                          if(!isset($status)){

                              $list[] = $lists_v;

                          }

                      }

                  }

                  $all_money = 0;$i_number = 0;$purchase_money = 0;$tax_money = 0;$money_tax_price = 0;

                  foreach ($list as $list_k=>$list_v){

                      $all_money += $list_v['all_money'];

                      $i_number += $list_v['i_number'];

                      $purchase_money += $list_v['purchase_money'];

                      $tax_money += $list_v['tax_money'];

                      $money_tax_price += $list_v['money_tax_price'];

                      $list[$list_k]['all_money'] = round($list_v['all_money'],$price_decimal);

                      if($list_v['i_number']!=0){

                          $list[$list_k]['unit_price'] = round($list_v['all_money']/$list_v['i_number'],$price_decimal);

                      }else{

                          $list[$list_k]['unit_price'] = 0;

                      }

                      $list[$list_k]['tax_money'] = round($list_v['tax_money'],$price_decimal);

                      $list[$list_k]['money_tax_price'] = round($list_v['money_tax_price'],$price_decimal);

                  }

                  if($i_number>0){

                      $unit_price = round($all_money/$i_number,$price_decimal);

                  }else{

                      $unit_price = 0;

                  }

                  $i_number = round($i_number,$number_decimal);

                  $all_money = round($all_money,$price_decimal);

                  $purchase_money = round($purchase_money,$price_decimal);

                  $tax_money = round($tax_money,$price_decimal);

                  $money_tax_price = round($money_tax_price,$price_decimal);

                  $count = [

                      'i_number'=>$i_number,

                      'unit_price'=>$unit_price,

                      'purchase_money'=>$purchase_money,

                      'all_money'=>$all_money,

                      'tax_money'=>$tax_money,

                      'money_tax_price'=>$money_tax_price,

                  ];

  

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

                  $this->view->assign("counts", $count);

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

                  break;

              case 'cghzb_gys':

                  $search = (array)json_decode($data['search'], true);

                  $where = [];$map=[];

                  foreach ($search as $k => &$v) {

                      if(!empty($v)){

                          if(strpos($v,' - ') !== false && strpos($k,'time') !== false){

                              $str = explode(' - ',$v);

                              $where['i.'.$k] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];

                          }else{

                              if($k=='supplyer_code'){

                                  $map['sp.supplyer_code'] = ["LIKE", "%{$v}%"];

                              }else{

                                  $where['i.'.$k] = ["LIKE", "%{$v}%"];

                              }

                          }

                      }

                  }

  

                  $field = empty(input('field'))?'supplyer_code':trim(input('field'));

                  $order = empty(input('sort'))?'DESC':trim(input('sort'));

  

                  $sup = Db::name('kuerp_suppliers')->alias('sp')

                      ->join('kuerp_supplyertype gt','sp.supplyertype_id=gt.id')

                      ->where($map)

                      ->field('sp.supplyer_code,sp.supplyer_name,gt.supplier_type_name')

                      ->select();

  

                  $listarr = [];

                  foreach ($sup as $sup_k=>$sup_v){

                      $list = [];

                      $lists = Db::name('kuerp_goods_purchase_summary')->alias('i')

                          ->join('kuerp_goods g','g.goods_code=i.goods_code')

                          ->join('kuerp_stores s','s.id=i.stores_id')

                          ->join('kuerp_unit u','u.id=i.goods_unit')

                          ->where($where)

                          ->where(['i.supplyer_code'=>$sup_v['supplyer_code']])

                          ->order(['i.'.$field=>$order])

                          ->group('i.goods_code,i.stores_id')

                          ->field('sum(i.tax_money) as tax_money,sum(i.money_tax_price) as money_tax_price,i.goods_code,i.stores_id,sum(i.basic_nmber) as basic_nmber,sum(number) as i_number,sum(all_money) as all_money,i.default_unit,i.goods_unit,i.purchase_money,

                  g.goods_code,g.goods_name,g.goods_specification_id,g.unit_id,g.more_unit,

                  s.name as s_name,u.name as u_name')

                          ->select();

                      if(!empty($lists)){

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

                              $lists_v['i_number'] = $lists_v['basic_nmber'];

  

                              $lists_v['unit_conversion'] = 1;

                              $now_unit = Db::name('kuerp_unit')->where(['id'=>$lists_v['goods_unit']])->find();

                              if(!empty($now_unit)){

                                  $unit_conversion = Db::name('kuerp_unit_conversion')->where(['main_unit'=>$lists_v['unit_id'],'vice_unit'=>$now_unit['id']])->find();

                                  if(!empty($unit_conversion)){

                                      $lists_v['unit_conversion'] = $unit_conversion['advance_rate'];

                                  }

                              }

  

                              if(!empty($list)){

                                  foreach ($list as $list_k=>$list_v){

                                      if($list_v['goods_code']==$lists_v['goods_code'] && $list_v['stores_id']==$lists_v['stores_id']){

                                          $list[$list_k]['i_number'] += $lists_v['i_number'];

                                          $list[$list_k]['all_money'] += $lists_v['all_money'];

                                          $list[$list_k]['purchase_money'] += $lists_v['purchase_money'];

                                          $list[$list_k]['unit_price'] = round(($list[$list_k]['all_money']/$list[$list_k]['i_number']),2);

                                          $status = true;

                                          if($list[$list_k]['i_number']%$lists_v['basic_nmber']>0){

                                              $list[$list_k]['basic_nmber'] = floor($list[$list_k]['i_number']/$lists_v['unit_conversion']).$lists_v['u_name'].($list[$list_k]['i_number']%$lists_v['unit_conversion']).$list_v['u_name'];

                                          }else{

                                              $list[$list_k]['basic_nmber'] = floor($list[$list_k]['i_number']/$lists_v['unit_conversion']).$lists_v['u_name'];

                                          }

                                          if($list_v['more_unit']==1){

                                              $list[$list_k]['unit_conversion'] = '1'.$lists_v['u_name'].'='.$lists_v['unit_conversion'].$list_v['u_name'];

                                          }else{

                                              $lists_v['unit_conversion'] = '';

                                          }

                                      }

                                  }

                              }

                              if(!isset($status)){

                                  $unit_name = Db::name('kuerp_unit')->where(['id'=>$lists_v['default_unit']])->value('name');

                                  if($lists_v['basic_nmber']!=0){

                                      if($lists_v['i_number']%$lists_v['basic_nmber']>0){

                                          $lists_v['basic_nmber'] = floor($lists_v['i_number']/$lists_v['unit_conversion']).$lists_v['u_name'].($lists_v['i_number']%$lists_v['unit_conversion']).$unit_name;

                                      }else{

                                          $lists_v['basic_nmber'] = ($lists_v['i_number']/$lists_v['unit_conversion']).$lists_v['u_name'];

                                      }

                                  }else{

                                      $lists_v['basic_nmber'] = 0;

                                  }

                                  if($lists_v['more_unit']==1){

                                      $lists_v['unit_conversion'] = '1'.$lists_v['u_name'].'='.$lists_v['unit_conversion'].$unit_name;

                                  }else{

                                      $lists_v['unit_conversion'] = '';

                                  }

                                  $lists_v['u_name'] = $unit_name;

                                  $list[] = $lists_v;

                              }

                          }

                      }

                      foreach ($list as $list_k=>$list_v){

                          $list_v['all_money'] = round($list_v['all_money'],2);

                          if($list_v['i_number']!=0){

                              $list_v['unit_price'] = round($list_v['all_money']/$list_v['i_number'],2);

                          }else{

                              $list_v['unit_price'] = 0;

                          }

                          $list_v['tax_money'] = round($list_v['tax_money'],2);

                          $list_v['money_tax_price'] = round($list_v['money_tax_price'],2);

  

                          $list_v[$field] = $sup_v['supplyer_code'];

                          $list_v['supplyer_name'] = $sup_v['supplyer_name'];

                          $list_v['supplier_type_name'] = $sup_v['supplier_type_name'];

                          $listarr[] = $list_v;

                      }

                      $sup[$sup_k]['list'] = $list;

                  }

  

                  //获取设置

                  $set= \think\Db::name('kuerp_sets')->field('type,name,value,is_checked,set')->select();

                  $setList = [];

                  foreach ($set as $set_k=>$set_v){

                      if(!empty($set_v['set'])){

                          $set_v['set'] = unserialize($set_v['set']);

                      }

                      $setList[$set_v['name']] = $set_v;

                  }

                  //数量价格格式化

                  $number_decimal = $setList['number_decimal']['value'];

                  $price_decimal  = $setList['price_decimal']['value'];

  

                  $count = [

                      'i_number'=>0,

                      'unit_price'=>0,

                      'all_money'=>0,

                      'tax_money'=>0,

                      'purchase_money'=>0,

                      'money_tax_price'=>0,

                  ];

                  $counts = $count;

                  $counts['supplier_type_name'] = '合计';

                  $data = [];

                  $now = isset($listarr[0][$field])?$listarr[0][$field]:'';

                  foreach ($listarr as $list_k=>$list_v){

                      if($list_v[$field]!=$now){

                          $now = $list_v[$field];

                          $row = $count;$row['supplier_type_name'] = '小计';

                          $row['unit_price'] = round($row['all_money']/$row['i_number'],2);

                          $data[] = $row;

                          foreach ($count as $count_k=>$count_v){

                              $count[$count_k] = $list_v[$count_k];

                              $counts[$count_k] += $list_v[$count_k];

                          }

                      }else{

                          foreach ($count as $count_k=>$count_v){

                              $count[$count_k] += $list_v[$count_k];

                              $counts[$count_k] += $list_v[$count_k];

                          }

                      }

                      $data[] = $list_v;

                      if($list_k==(sizeof($listarr)-1) || sizeof($listarr)==1){

                          $row = $count;$row['supplier_type_name'] = '小计';

                          if($row['i_number']!=0){

                              $row['unit_price'] = round($row['all_money']/$row['i_number'],$price_decimal);

                          }else{

                              $row['unit_price'] = 0;

                          }

                          $data[] = $row;

                      }

                  }

                  $counts['unit_price'] = $counts['i_number']>0?(round($counts['all_money']/$counts['i_number'],$price_decimal)):0;

  

                  $counts['i_number'] = round($counts['i_number'],$number_decimal);

                  $counts['unit_price'] = round($counts['unit_price'],$price_decimal);

                  $counts['all_money'] = round($counts['all_money'],$price_decimal);

                  $counts['purchase_money'] = round($counts['purchase_money'],$price_decimal);

                  $counts['tax_money'] = round($counts['tax_money'],$price_decimal);

                  $counts['money_tax_price'] = round($counts['money_tax_price'],$price_decimal);

                  $data[] = $counts;

                  $this->view->assign("list", $data);

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

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

                  break;

              case 'cgfk':

                  $page = isset($data['page'])?$data['page']:1;

                  $limit = isset($data['limit'])?$data['limit']:10;

                  $search = (array)json_decode($data['search'], true);

                  $where = [];

                  foreach ($search as $k => &$v) {

                      if(!empty($v)){

                          if(strpos($v,' - ') !== false && strpos($k,'time') !== false){

                              $str = explode(' - ',$v);

                              $where[$k] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];

                          }else{

                              $where[$k] = ["LIKE", "%{$v}%"];

                          }

                      }

                  }

                  $list = Db::name('kuerp_payment_log')->where($where)->page($page,$limit)->order(['bill_code'=>'ASC','id'=>'ASC'])->select();

  

                  $price_decimal = \think\Db::name('kuerp_sets')->where(['name'=>'price_decimal'])->value('value');

  

                  $oldcount = $count = [

                      'money_tax_price'=>0,

                      'purchase_money'=>0,

                      'discount_money'=>0,

                      'real_money'=>0,

                      'pay_money'=>0,

                      'give_money'=>0,

                  ];

                  $counts = $count;

                  $counts['s_name'] = '合计';

                  $data = [];

                  $field = 'bill_code';

                  $now = isset($list[0][$field])?$list[0][$field]:'';

                  $give_money = 0;

                  $pay_money = 0;

                  $status = true;

                  foreach ($list as $list_k=>$list_v){

                      $list[$list_k]['supplyer_name'] = Db::name('kuerp_suppliers')->where(['supplyer_code'=>$list_v['suppliers_code']])->value('supplyer_name');

                      $list[$list_k]['payment_rate'] = '';

                      $list[$list_k]['payment_rate'] = '';

  

                      if($list_v[$field]!=$now){

                          $now = $list_v[$field];

                          $row = $count;

                          $row['s_name'] = '小计';$row['supplyer_name'] = '小计';$row['bill_time'] = '';

                          if(($count['pay_money']+$count['give_money'])>0){

                              $row['payment_rate'] = round($count['pay_money']/($count['pay_money']+$count['give_money']),4)*100 .'%';

                          }else{

                              $row['payment_rate'] = '';

                          }

                          $data[] = $row;

                          foreach ($count as $count_k=>$count_v){

                              $counts[$count_k] += $row[$count_k];

                          }

                          $status = true;

                      }

  

                      if($list_v[$field]==$now){

                          if($status){

                              $give_money = $list_v['give_money'];$pay_money = $list_v['pay_money'];

                              $status = false;

                              $count = $oldcount;

                          }else{

                              $pay_money += $list_v['pay_money'];

                              $give_money += $list_v['give_money'];

                          }

                          $list_v['give_money'] = $give_money;

                          if(!$status){

                              foreach ($count as $count_k=>$count_v){

                                  $count[$count_k] += $list_v[$count_k];

                              }

                              $count['give_money'] = $list_v['give_money'];

                          }

                      }

                      $data[] = $list_v;

                      if($list_k==(sizeof($list)-1) || sizeof($list)==1){

                          $row = $count;$row['s_name'] = '小计';$row['supplyer_name'] = '小计';$row['bill_time'] = '';

                          if($row['give_money']>0){

                              $row['payment_rate'] = round($count['pay_money']/($count['pay_money']+$count['give_money']),4)*100 .'%';

                          }else{

                              $row['payment_rate'] = '';

                          }

                          $data[] = $row;

                          foreach ($count as $count_k=>$count_v){

                              $counts[$count_k] += $row[$count_k];

                          }

                      }

                  }

  

                  if ($counts['give_money']>0){

                      $counts['payment_rate'] = round($counts['pay_money']/($counts['pay_money']+$counts['give_money']),4)*100 .'%';

                  }else{

                      $counts['payment_rate'] = '';

                  }

                  $counts['supplyer_name'] = '合计';$counts['bill_time'] = '';

                  $counts['purchase_money'] = round($counts['purchase_money'],$price_decimal);

                  $counts['discount_money'] = round($counts['discount_money'],$price_decimal);

                  $counts['real_money'] = round($counts['real_money'],$price_decimal);

                  $counts['pay_money'] = round($counts['pay_money'],$price_decimal);

                  $counts['give_money'] = round($counts['give_money'],$price_decimal);

                  $data[] = $counts;

  

                  $this->view->assign("list", $data);

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

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

                  break;

              case 'xsddgz':

                  $page = isset($data['page'])?$data['page']:1;

                  $limit = isset($data['limit'])?$data['limit']:10;

                  $search = (array)json_decode($data['search'], true);

                  $where = [];

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

                      if(strpos($v,' - ') !== false && strpos($k,'time') !== false){

                          $str = explode(' - ',$v);

                          $where['i.'.$k] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];

                      }else{

                          $where['i.'.$k] = ["LIKE", "%{$v}%"];

                      }

                  }

                  $field = empty(input('field'))?'goods_code':trim(input('field'));

                  $order = empty(input('sort'))?'DESC':trim(input('sort'));

  

                  $list = Db::name('kuerp_goods_sales_order_info')->alias('i')

                      ->join('kuerp_goods_sales_order po','po.purchase_code=i.purchase_code')

                      ->join('kuerp_goods g','g.goods_code=i.goods_code')

                      ->join('kuerp_unit u','u.id=i.default_unit')

                      ->join('kuerp_customers s','s.id=i.customers_id')

                      ->join('kuerp_stores r','r.id=i.stores_id')

                      ->where($where)

                      ->order(['i.'.$field=>$order,'i.purchase_time'=>'DESC'])

                      ->field('i.id,i.goods_attr,i.goods_code,i.purchase_code,i.purchase_type,i.purchase_time,i.delivery_time

                  ,i.all_money,po.status,i.number,i.tax_included,i.money_tax_price,i.unit_price,i.number as library_number,i.money_tax_price as library_money,i.library_time,

                  g.goods_name,g.goods_specification_id,

                  s.customer_name as s_name,

                  r.name as r_name,

                  u.name as unitname')

                      ->select();

                  foreach ($list as $list_k=>$list_v){

                      $purord_info = Db::name('kuerp_goods_saleord_info')->where(['order_id'=>$list_v['id'],'status'=>'1'])->field('sum(number) as number,sum(money_tax_price) as all_money')->find();

                      $p_id = Db::name('kuerp_goods_saleord_info')->where(['order_id'=>$list_v['id'],'status'=>'1'])->value('purchase_id');

                      $goods_excpur_info = Db::name('kuerp_goods_saleexc_info')->where(['purchase_id'=>$p_id,'status'=>'1'])->find();

                      if($goods_excpur_info){

                          $purord_info['number'] = round( ($purord_info['number']-$goods_excpur_info['number']),2 );

                          $purord_info['all_money'] = round( ($purord_info['all_money']-$goods_excpur_info['money_tax_price']),2 );

                      }

                      if($purord_info){

                          $list[$list_k]['library_number'] = round(($list[$list_k]['library_number']-$purord_info['number']),2);

                          $list[$list_k]['library_money'] = round(($list[$list_k]['library_money']-$purord_info['all_money']),4);

                      }

                      if($list[$list_k]['library_number']>0 && $list[$list_k]['library_number']<$list[$list_k]['number']){

                          $list[$list_k]['status'] = 2;

                      }else if($list[$list_k]['library_number']>0 && $list[$list_k]['library_number']=$list[$list_k]['number']){

                          $list[$list_k]['status'] = 0;

                      }

                      $purord_time = Db::name('kuerp_goods_saleord_info')->where(['order_id'=>$list_v['id'],'status'=>1])->order('times','DESC')->value('times');

                      if($purord_time){

                          $list[$list_k]['library_time'] = $purord_time;

                      }

                  }

  

                  foreach ($list as $list_k=>$list_v){

                      $goods = $this->getGoods($list_v['goods_code'],$list_v['goods_attr']);

                      $list[$list_k]['goods_name'] = isset($goods['goods_name'])?$goods['goods_name']:$list_v['goods_name'];

                      if($list_v['purchase_type']==2){

                          $list[$list_k]['number'] = -$list_v['number'];

                          $list[$list_k]['money_tax_price'] = -$list_v['money_tax_price'];

                          $list[$list_k]['library_number'] = -$list_v['library_number'];

                          $list[$list_k]['library_money'] = -$list_v['library_money'];

                      }

                  }

  

                  $count = [

                      'number'=>0,

                      'money_tax_price'=>0,

                      'library_number'=>0,

                      'library_money'=>0,

                  ];

                  $counts = $count;

                  $counts['goods_code'] = '合计';

                  $data = [];

                  $now = isset($list[0][$field])?$list[0][$field]:'';

                  foreach ($list as $list_k=>$list_v){

                      if($list_v[$field]!=$now){

                          $now = $list_v[$field];

                          $row = $count;$row['goods_code'] = '小计';

                          $data[] = $row;

                          foreach ($count as $count_k=>$count_v){

                              $count[$count_k] = $list_v[$count_k];

                              $counts[$count_k] += $list_v[$count_k];

                          }

                      }else{

                          foreach ($count as $count_k=>$count_v){

                              $count[$count_k] += $list_v[$count_k];

                              $counts[$count_k] += $list_v[$count_k];

                          }

                      }

                      $data[] = $list_v;

                      if($list_k==(sizeof($list)-1) || sizeof($list)==1){

                          $row = $count;$row['goods_code'] = '小计';

                          $data[] = $row;

                      }

                  }

                  $data[] = $counts;

                  $this->view->assign("list", $data);

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

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

                  break;

              case 'dbd':

                  $list = Db::name('kuerp_allocation')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_allocation')->where(['id'=>['in',$id]])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $info = Db::name('kuerp_allocation_info')->where((new Goods())->setWhere(['allocation_id'=>$row['id']]))->select();

                      $number = 0;

                      foreach ($info as $info_k=>$info_v){

                          $number+=$info_v['number'];

                          $goods = $this->getGoods('',$info_v['goods_attr'],$info_v['goods_id']);

                          $info[$info_k]['goods'] = $goods;

                          $info[$info_k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$info_v['goods_unit']])->find();

                          $info[$info_k]['stores_out'] = Db::name('kuerp_stores')->where(['id'=>$info_v['stores_out']])->find();

                          $info[$info_k]['stores_enter'] = Db::name('kuerp_stores')->where(['id'=>$info_v['stores_enter']])->find();

                      }

                      $number = round($number,$number_decimal);

                      $row['print_number'] = $number;

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['info_list'] = $info;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'cbtzd':

                  $list = Db::name('kuerp_adjustment')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_adjustment')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_adjustment')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

                      $info = Db::name('kuerp_adjustment_info')->where((new Goods())->setWhere(['purchase_code'=>$row['purchase_code']]))->select();

                      $money = 0;

                      foreach ($info as $info_k=>$info_v){

                          $money+=$info_v['money'];

                          $info[$info_k]['goods'] = Db::name('kuerp_goods')->where(['id'=>$info_v['goods_id']])->find();

                          $info[$info_k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$info_v['goods_unit']])->find();

                          $info[$info_k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$info_v['stores_id']])->find();

                      }

                      $money = round($money,$price_decimal);

                      $row['print_money'] = $money;

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['info_list'] = $info;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'qtrkd':

                  $list = Db::name('kuerp_warehousing')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_warehousing')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_warehousing')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

                      $purchase_info = Db::name('kuerp_warehousing_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $purchase_info[$k]['goods'] = Db::name('kuerp_goods')->where(['id'=>$v['goods_id']])->find();

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

  

                      $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_id']])->find();

                      $row['suppliers'] = $suppliers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'qtckd':

                  $list = Db::name('kuerp_warehouse')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_warehouse')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_warehouse')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

                      $purchase_info = Db::name('kuerp_warehouse_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $purchase_info[$k]['goods'] = Db::name('kuerp_goods')->where(['id'=>$v['goods_id']])->find();

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          $number+=$v['number'];$money+=$v['price'];

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

  

                      $customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->find();

                      $row['customers'] = $customers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'zzd':

                  $list = Db::name('kuerp_assemble')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_assemble')->where(['id'=>$id])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_assemble_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $purchase_info[$k]['goods'] = Db::name('kuerp_goods')->where(['id'=>$v['goods_id']])->find();

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          if($v['type']==2){

                              $number+=$v['number'];$money+=$v['cost_money'];

                          }

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'cxd':

                  $list = Db::name('kuerp_split')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  Db::name('kuerp_split')->where(['id'=>$id])->inc('print_num')->update();

                  foreach ($list as $list_k=>$row){

                      $purchase_info = Db::name('kuerp_split_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $number = 0;$money = 0;

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

                          $purchase_info[$k]['goods'] = Db::name('kuerp_goods')->where(['id'=>$v['goods_id']])->find();

                          $purchase_info[$k]['unit'] = Db::name('kuerp_unit')->where(['id'=>$v['goods_unit']])->find();

                          $purchase_info[$k]['stores'] = Db::name('kuerp_stores')->where(['id'=>$v['stores_id']])->find();

                          if($v['type']==2){

                              $number+=$v['number'];$money+=$v['cost_money'];

                          }

                      }

                      $number = round($number,$number_decimal);

                      $money  = round($money,$price_decimal);

                      $row['print_number'] = $number;

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['purchase_info'] = $purchase_info;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'fkd':

                  $list = Db::name('kuerp_payment')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_payment')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_payment')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

  

                      $payment_account = Db::name('kuerp_payment_account')->where(['collection_id'=>$row['id']])->select();

                      $payment_sale    = Db::name('kuerp_payment_sale')->where(['collection_id'=>$row['id']])->select();

  

                      $settlementtype = Db::name('kuerp_settlementtype')->where((new Goods())->setWhere())->column('name','id');

                      $money = 0;

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

                          $money+=$v['money'];

                          $payment_account[$k]['accounts'] = Db::name('kuerp_accounts')->where(['id'=>$v['accounts_id']])->find();

                          $payment_account[$k]['settlementtype'] = $settlementtype[$v['settlementtype']];

                      }

                      $money  = round($money,$price_decimal);

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$row['customers_id']])->find();

                      $row['suppliers'] = $suppliers;

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['payment_account'] = $payment_account;

                      $row['payment_sale'] = $payment_sale;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'skd':

                  $list = Db::name('kuerp_collection')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  $settlementtype = Db::name('kuerp_settlementtype')->where((new Goods())->setWhere())->column('name','id');

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_collection')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_collection')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

  

                      $payment_account = Db::name('kuerp_collection_account')->where(['collection_id'=>$row['id']])->select();

                      $payment_sale    = Db::name('kuerp_collection_sale')->where(['collection_id'=>$row['id']])->select();

  

                      $money = 0;

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

                          $money+=$v['money'];

                          $payment_account[$k]['accounts'] = Db::name('kuerp_accounts')->where(['id'=>$v['accounts_id']])->find();

                          $payment_account[$k]['settlementtype'] = isset($settlementtype[$v['settlementtype']])?$settlementtype[$v['settlementtype']]:'';

                      }

                      $money  = round($money,$price_decimal);

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->find();

                      $row['customers'] = $customers;

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['payment_account'] = $payment_account;

                      $row['payment_sale'] = $payment_sale;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'hxd':

                  $business_type = ['','预收冲应收','预付冲应付','应收冲应付','应收转应收','应付转应付'];

                  $list = Db::name('kuerp_writeoff')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  foreach ($list as $list_k=>$row){

                      $row['business_type_text'] = $business_type[$row['business_type']];

                      if($row['print_num']>0){

                          Db::name('kuerp_writeoff')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_writeoff')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

  

                      if ($row['business_type']==1){

                          $row['customers_id'] = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->value('customer_name');

                      }else if ($row['business_type']==2){

                          $row['suppliers_id'] = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_id']])->value('supplyer_name');

                      }else if ($row['business_type']==3){

                          $row['customers_id'] = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->value('customer_name');

                          $row['suppliers_id'] = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_id']])->value('supplyer_name');

                      }else if ($row['business_type']==4){

                          $row['customers_out_id'] = Db::name('kuerp_customers')->where(['id'=>$row['customers_out_id']])->value('customer_name');

                          $row['customers_enter_id'] = Db::name('kuerp_customers')->where(['id'=>$row['customers_enter_id']])->value('customer_name');

                      }else{

                          $row['suppliers_out_id'] = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_out_id']])->value('supplyer_name');

                          $row['suppliers_enter_id'] = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_enter_id']])->value('supplyer_name');

                      }

  

                      $purchase_info = Db::name('kuerp_writeoff_info')->where(['collection_id'=>$row['id']])->select();

                      $row['purchase_info'] = $purchase_info;

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'qtsrd':

                  $list = Db::name('kuerp_income')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  $income = Db::name('kuerp_income_type')->column('name','id');

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_income')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_income')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

                      $purchase_info = Db::name('kuerp_income_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $money = 0;

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

                          $money+=$v['money'];

                          $purchase_info[$k]['income_type_id'] = $income[$v['income_type_id']];

                      }

                      $money  = round($money,$price_decimal);

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['accounts'] = Db::name('kuerp_accounts')->where(['id'=>$row['accounts_id']])->find();

                      $row['purchase_info'] = $purchase_info;

  

                      $customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->find();

                      $row['customers'] = $customers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              case 'qtzcd':

                  $list = Db::name('kuerp_expenditure')->where(['id'=>['in',$id]])->select();

                  if(empty($list)){

                      $this->error('未查询到相关数据');

                  }

                  $income = Db::name('kuerp_expend_type')->column('name','id');

                  foreach ($list as $list_k=>$row){

                      if($row['print_num']>0){

                          Db::name('kuerp_expenditure')->where(['id'=>$row['id']])->inc('print_num')->update();

                      }else{

                          Db::name('kuerp_expenditure')->where(['id'=>$row['id']])->update(['print_num'=>1]);

                      }

                      $purchase_info = Db::name('kuerp_expenditure_info')->where(['purchase_code'=>$row['purchase_code']])->select();

                      $money = 0;

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

                          $money+=$v['money'];

                          $purchase_info[$k]['expend_type_id'] = $income[$v['expend_type_id']];

                      }

                      $money  = round($money,$price_decimal);

                      $row['print_money'] = $money;

                      $row['print_money_c'] = $this->num_to_rmb($money);

  

                      $row['preparation'] = Db::name('admin')->where(['id'=>$row['preparation_id']])->find();

                      if(isset($row['preparation']['nickname']) && !empty($row['preparation']['nickname'])){

                          $row['preparation']['username'] = $row['preparation']['nickname'];

                      }

                      $row['accounts'] = Db::name('kuerp_accounts')->where(['id'=>$row['accounts_id']])->find();

                      $row['purchase_info'] = $purchase_info;

  

                      $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_id']])->find();

                      $row['suppliers'] = $suppliers;

                      $list[$list_k] = $row;

                  }

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

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

                  break;

              default:

                  $this->error('参数错误');

          }

      }

  

      function num_to_rmb($num){

          $c1 = "零壹贰叁肆伍陆柒捌玖";

          $c2 = "分角元拾佰仟万拾佰仟亿";

          //精确到分后面就不要了,所以只留两个小数位

          $num = round($num, 2);

          //将数字转化为整数

          $num = $num * 100;

          if (strlen($num) > 10) {

              return "金额太大,请检查";

          }

          $i = 0;

          $c = "";

          while (1) {

              if ($i == 0) {

                  //获取最后一位数字

                  $n = substr($num, strlen($num)-1, 1);

              } else {

                  $n = $num % 10;

              }

              //每次将最后一位数字转化为中文

              $p1 = substr($c1, 3 * $n, 3);

              $p2 = substr($c2, 3 * $i, 3);

              if ($n != '0' || ($n == '0' && ($p2 == '亿' || $p2 == '万' || $p2 == '元'))) {

                  $c = $p1 . $p2 . $c;

              } else {

                  $c = $p1 . $c;

              }

              $i = $i + 1;

              //去掉数字最后一位了

              $num = $num / 10;

              $num = (int)$num;

              //结束循环

              if ($num == 0) {

                  break;

              }

          }

          $j = 0;

          $slen = strlen($c);

          while ($j < $slen) {

              //utf8一个汉字相当3个字符

              $m = substr($c, $j, 6);

              //处理数字中很多0的情况,每次循环去掉一个汉字“零”

              if ($m == '零元' || $m == '零万' || $m == '零亿' || $m == '零零') {

                  $left = substr($c, 0, $j);

                  $right = substr($c, $j + 3);

                  $c = $left . $right;

                  $j = $j-3;

                  $slen = $slen-3;

              }

              $j = $j + 3;

          }

          //这个是为了去掉类似23.0中最后一个“零”字

          if (substr($c, strlen($c)-3, 3) == '零') {

              $c = substr($c, 0, strlen($c)-3);

          }

          //将处理的汉字加上“整”

          if (empty($c)) {

              return "零元整";

          }else{

              return $c . "整";

          }

      }

  }