Writeoff.php 84.8 KB
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 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455
<?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 Writeoff extends Backend
{
    protected $noNeedRight = ['choselist','choseadvancelist','chosereceivable','chosecopewith'];
    /**
     * Writeoff模型对象
     * @var \app\admin\model\kuerp\Writeoff
     */
    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\Writeoff;
        $this->view->assign("businessTypeList", $this->model->getBusinessTypeList());
        $this->view->assign("examineStatusList", $this->model->getExamineStatusList());

        $this->view->assign("customers", $this->model->getCustomersList());
        $this->view->assign("suppliers", $this->model->getSuppliersList());
        $this->view->assign("accountsList", $this->model->getAccountsList());
        $this->view->assign("saleList", $this->model->getSaleList());
        $this->view->assign("settlementtype", $this->model->getSettlementtype());
    }

    public function import()
    {
        parent::import();
    }

    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */


    /**
     * 查看
     */
    public function index()
    {
        //当前是否为关联查询
        $this->relationSearch = true;
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage,则转发到Selectpage
            if ($this->request->request('keyField')) {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();

            $list = $this->model
                ->with(['admin'])
                ->where($where)
                ->order($sort, $order)
                ->paginate($limit);

            foreach ($list as $row) {

                $row->getRelation('admin')->visible(['username']);
            }
            foreach ($list as $list_k=>$list_v){
                if(isset($list_v['print_num']) && empty($list_v['print_num'])){
                    $list[$list_k]['print_num'] = 0;
                }
                $list[$list_k]['purchase_times'] = date('Y-m-d',$list_v['purchase_time']);

                if ($list_v['business_type']==4){
                    $list[$list_k]['customers_id'] = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_out_id']])->value('customer_name');
                }else{
                    $list[$list_k]['customers_id'] = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_id']])->value('customer_name');
                }
                if ($list_v['business_type']==5){
                    $list[$list_k]['suppliers_id'] = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_out_id']])->value('supplyer_name');
                }else{
                    $list[$list_k]['suppliers_id'] = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_id']])->value('supplyer_name');
                }

                $list[$list_k]['preparation_id'] = Db::name('admin')->where(['id'=>$list_v['preparation_id']])->value('username');
                $list[$list_k]['examine_id'] = Db::name('admin')->where(['id'=>$list_v['examine_id']])->value('username');
            }

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

            return json($result);
        }
        return $this->view->fetch();
    }

    public function add($ids = null)
    {
        if ($this->request->isPost()) {
            $params = $this->request->post("row/a");
            if ($params) {
                (new \app\admin\controller\kuerp\Checkout())->checkOutTime($params['purchase_time']);
                $examine= Db::name('kuerp_sets')->where(['name'=>'examine'])->value('is_checked');
                $params = $this->preExcludeFields($params);

                if(empty($params['purchase_code'])){
                    $this->error('请填写单据编号');
                }
                $admin = Session::get('admin');

                $business_type = $params['business_type'];
                $data = input();
                $account = $data['account'];
                $sale = $data['sale'];
                $info = [];
                $log_arr = [];
                $log_add = [];
                $order_id = [];
                foreach ($account['purchase_numbers'] as $account_k=>$account_v){
                    if(!empty($account_v) && !empty($account['purchase_type'][$account_k])){
                        $order = Db::name('kuerp_writeoff_source')->where(['id'=>$account['purchase_type'][$account_k]])->find();
                        if(empty($order)){
                            $this->error('源单信息查询错误');
                        }
                        if(in_array($account_v,$order_id)){
                            $this->error('不可多次选择相同的源单');
                        }else{
                            $order_id[] = $account_v;
                        }
                        $thisrow = (new Goods())->setDataInfo([
                            'source_id'        => $order['id'],
                            'purchase_code'    => $params['purchase_code'],
                            'purchase_time'    => strtotime($params['purchase_time']),
                            'type'             => $order['type'],
                            'purchase_number'  => $order['purchase_code'],
                            'business_type'    => $business_type,
                            'business_name'    => isset($account['business_type'][$account_k])?$account['business_type'][$account_k]:null,
                            'purchase_type'    => $order['purchase_type'],
                            'times'            => $order['purchase_time'],
                            'money'            => $order['price'],
                            'write_off'        => isset($account['write_off'][$account_k])?(float)$account['write_off'][$account_k]:0,
                            'write_off_money'  => isset($account['write_off_money'][$account_k])?(float)$account['write_off_money'][$account_k]:0,
                            'write_off_price'  => isset($account['write_off_price'][$account_k])?(float)$account['write_off_price'][$account_k]:0,
                            'top'              => 1,
                        ]);
                        $info[] = $thisrow;

                        $where = [];
                        $where['source_id'] = $order['id'];
                        $log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere($where))->find();
                        if($log){
                            $status = true;
                            foreach ($log_arr as $log_arr_k=>$log_arr_v){
                                if($log_arr_v['id']==$log['id']){
                                    $status = false;
                                    $log_arr[$log_arr_k]['money'] += $thisrow['write_off_price'];
                                    $log_arr[$log_arr_k]['write_off'] -= $thisrow['write_off_price'];
                                }
                            }
                            if($status){
                                $log_arr[] = [
                                    'id' => $log['id'],
                                    'write_off' => $log['write_off']-$thisrow['write_off_price'],
                                    'money' => $log['money']+$thisrow['write_off_price'],
                                ];
                            }
                        }else{
                            $log_add[] = [
                                'source_id' => $order['id'],
                                'write_off' => $thisrow['write_off_money']-$thisrow['write_off_price'],
                                'money' => $thisrow['write_off_price'],
                            ];
                        }
                    }
                }

                $account_money = 0;
                foreach ($info as $info_k=>$info_v){
                    $account_money += $info_v['write_off_price'];
                }

                $order_id = [];
                $sale_money = 0;
                if($business_type<=3){
                    foreach ($sale['purchase_numbers'] as $account_k=>$account_v){
                        if(!empty($account_v) && !empty($sale['purchase_type'][$account_k])){
                            $sale_money += $sale['write_off_price'][$account_k];
                            $order = Db::name('kuerp_writeoff_source')->where(['id'=>$sale['purchase_type'][$account_k]])->find();
                            if(empty($order)){
                                $this->error('源单信息查询错误');
                            }
                            if(in_array($account_v,$order_id)){
                                $this->error('不可多次选择相同的源单');
                            }else{
                                $order_id[] = $account_v;
                            }
                            $thisrow = (new Goods())->setDataInfo([
                                'source_id'        => $order['id'],
                                'purchase_code'    => $params['purchase_code'],
                                'purchase_time'    => strtotime($params['purchase_time']),
                                'type'             => $order['type'],
                                'purchase_number'  => $order['purchase_code'],
                                'business_type'    => $business_type,
                                'business_name'    => isset($sale['business_type'][$account_k])?$sale['business_type'][$account_k]:null,
                                'purchase_type'    => $order['purchase_type'],
                                'times'            => $order['purchase_time'],
                                'money'            => $order['price'],
                                'write_off'        => isset($sale['write_off'][$account_k])?(float)$sale['write_off'][$account_k]:0,
                                'write_off_money'  => isset($sale['write_off_money'][$account_k])?(float)$sale['write_off_money'][$account_k]:0,
                                'write_off_price'  => isset($sale['write_off_price'][$account_k])?(float)$sale['write_off_price'][$account_k]:0,
                                'top'              => 2,
                            ]);
                            $info[] = $thisrow;

                            $where = [];
                            $where['source_id'] = $order['id'];
                            $log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere($where))->find();
                            if($log){
                                $status = true;
                                foreach ($log_arr as $log_arr_k=>$log_arr_v){
                                    if($log_arr_v['id']==$log['id']){
                                        $status = false;
                                        $log_arr[$log_arr_k]['write_off'] -= $thisrow['write_off_price'];
                                        $log_arr[$log_arr_k]['money'] += $thisrow['write_off_price'];
                                    }
                                }
                                if($status){
                                    $log_arr[] = [
                                        'id' => $log['id'],
                                        'write_off' => $log['write_off']-$thisrow['write_off_price'],
                                        'money' => $log['money']+$thisrow['write_off_price'],
                                    ];
                                }
                            }else{
                                $log_add[] = [
                                    'source_id' => $order['id'],
                                    'write_off' => $thisrow['write_off_money']-$thisrow['write_off_price'],
                                    'money' => $thisrow['write_off_price'],
                                ];
                            }
                        }
                    }
                }

                $row = (new Goods())->setDataInfo([
                    'purchase_code'     =>  $params['purchase_code'],
                    'purchase_time'     =>  strtotime($params['purchase_time']),
                    'business_type'     =>  $params['business_type'],
                    'customers_id'      =>  isset($params['customers_id'])?(float)$params['customers_id']:null,
                    'customers_out_id'  =>  isset($params['customers_out_id'])?(float)$params['customers_out_id']:null,
                    'customers_enter_id'=>  isset($params['customers_enter_id'])?(float)$params['customers_enter_id']:null,
                    'suppliers_id'      =>  isset($params['suppliers_id'])?(float)$params['suppliers_id']:null,
                    'suppliers_out_id'  =>  isset($params['suppliers_out_id'])?(float)$params['suppliers_out_id']:null,
                    'suppliers_enter_id'=>  isset($params['suppliers_enter_id'])?(float)$params['suppliers_enter_id']:null,
                    'write_off'         =>  $account_money,
                    'remarks'           =>  $params['note'],
                    'preparation_id'    =>  $admin['id'],
                    'operation_id'      =>  $admin['id'],
                    'createtime'        => time(),
                    'updatetime'        => time(),
                ]);

                if($account_money!=$sale_money && $business_type<=3){
                    $this->error('核销金额错误');
                }
                if($this->model->where((new Goods())->setWhere(['purchase_code'=>trim($params['purchase_code'])]))->find()){
                    $this->error('单据编号已占用');
                }

                $result = false;
                Db::startTrans();
                try {
                    if(!empty($row)){
                        $result = $this->model->insertGetId($row);
                    }

                    foreach ($info as $info_k=>$info_v){
                        $info[$info_k]['collection_id'] = $result;
                    }
                    Db::name('kuerp_writeoff_info')->insertAll($info);
                    if(!empty($log_arr)){
                        (new \app\admin\model\kuerp\WriteoffLog())->saveAll($log_arr);
                    }
                    if(!empty($log_add)){
                        (new \app\admin\model\kuerp\WriteoffLog())->insertAll($log_add);
                    }
                    Db::commit();
                } catch (Exception $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                }
                if (isset($result) && $result !== false) {
                    if($examine!=1){
                        try {
                            $exa = $this->examine($result,1);
                        } catch (Exception $e) {
                        }
                        if(!isset($exa) || $exa['status']!=1){
                            $exa = $this->examine($result,1);
                            try {
                                $this->del($result);
                            } catch (Exception $e) {
                            }
                            $this->error($exa['msg']);
                        }
                    }
                    $this->success();
                } else {
                    $this->error(__('No rows were inserted'));
                }
            }
            $this->error(__('Parameter %s can not be empty', ''));
        }
        $code = (new Goods())->getCodes('',23);
        $this->view->assign("code", $code);
        return $this->view->fetch();
    }

    public function edit($ids = null)
    {
        $row = $this->model->get($ids);
        if (!$row) {
            $this->error(__('No Results were found'));
        }
        $adminIds = $this->getDataLimitAdminIds();
        if (is_array($adminIds)) {
            if (!in_array($row[$this->dataLimitField], $adminIds)) {
                $this->error(__('You have no permission'));
            }
        }
        if ($this->request->isPost()) {
            (new \app\admin\controller\kuerp\Checkout())->checkOutTime($row['purchase_time']);
            $examine= Db::name('kuerp_sets')->where(['name'=>'examine'])->value('is_checked');
            if($row['examine_status']==1 && $examine==1){
                $this->error('不能编辑已审核的数据');
            }

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

                if(empty($params['purchase_code'])){
                    $this->error('请填写单据编号');
                }
                $admin = Session::get('admin');

                //详情
                $info_list = Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>$ids]))->select();

                $business_type = $params['business_type'];
                $data = input();
                $account = $data['account'];
                $sale = $data['sale'];
                $info = [];
                $log_arr = [];
                $log_add = [];
                $order_id = [];
                foreach ($account['purchase_numbers'] as $account_k=>$account_v){
                    if(!empty($account_v) && !empty($account['purchase_type'][$account_k])){
                        $order = Db::name('kuerp_writeoff_source')->where(['id'=>$account['purchase_type'][$account_k]])->find();
                        if(empty($order)){
                            $this->error('源单信息查询错误');
                        }
                        if(in_array($account_v,$order_id)){
                            $this->error('不可多次选择相同的源单');
                        }else{
                            $order_id[] = $account_v;
                        }
                        $thisrow = (new Goods())->setDataInfo([
                            'source_id'        => $order['id'],
                            'purchase_code'    => $params['purchase_code'],
                            'purchase_time'    => strtotime($params['purchase_time']),
                            'type'             => $order['type'],
                            'purchase_number'  => $order['purchase_code'],
                            'business_type'    => $business_type,
                            'business_name'    => isset($account['business_type'][$account_k])?$account['business_type'][$account_k]:null,
                            'purchase_type'    => $order['purchase_type'],
                            'times'            => $order['purchase_time'],
                            'money'            => $order['price'],
                            'write_off'        => isset($account['write_off'][$account_k])?(float)$account['write_off'][$account_k]:0,
                            'write_off_money'  => isset($account['write_off_money'][$account_k])?(float)$account['write_off_money'][$account_k]:0,
                            'write_off_price'  => isset($account['write_off_price'][$account_k])?(float)$account['write_off_price'][$account_k]:0,
                            'top'              => 1,
                        ]);
                        $info[] = $thisrow;

                        $where = [];
                        $where['source_id'] = $order['id'];
                        $log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere($where))->find();
                        if($log){
                            $status = true;
                            foreach ($log_arr as $log_arr_k=>$log_arr_v){
                                if($log_arr_v['id']==$log['id']){
                                    $status = false;
                                    $log_arr[$log_arr_k]['money'] += $thisrow['write_off_price'];
                                    $log_arr[$log_arr_k]['write_off'] -= $thisrow['write_off_price'];
                                }
                            }
                            if($status){
                                $log_arr[] = [
                                    'id' => $log['id'],
                                    'write_off' => $log['write_off']-$thisrow['write_off_price'],
                                    'money' => $log['money']+$thisrow['write_off_price'],
                                ];
                            }
                        }else{
                            $log_add[] = [
                                'source_id' => $order['id'],
                                'write_off' => $thisrow['write_off_money']-$thisrow['write_off_price'],
                                'money' => $thisrow['write_off_price'],
                            ];
                        }
                    }
                }

                $account_money = 0;
                foreach ($info as $info_k=>$info_v){
                    $account_money += $info_v['write_off_price'];
                }

                $order_id = [];
                $sale_money = 0;
                if($business_type<=3){
                    foreach ($sale['purchase_numbers'] as $account_k=>$account_v){
                        if(!empty($account_v) && !empty($sale['purchase_type'][$account_k])){
                            $sale_money += $sale['write_off_price'][$account_k];
                            $order = Db::name('kuerp_writeoff_source')->where(['id'=>$sale['purchase_type'][$account_k]])->find();
                            if(empty($order)){
                                $this->error('源单信息查询错误');
                            }
                            if(in_array($account_v,$order_id)){
                                $this->error('不可多次选择相同的源单');
                            }else{
                                $order_id[] = $account_v;
                            }
                            $thisrow = (new Goods())->setDataInfo([
                                'source_id'        => $order['id'],
                                'purchase_code'    => $params['purchase_code'],
                                'purchase_time'    => strtotime($params['purchase_time']),
                                'type'             => $order['type'],
                                'purchase_number'  => $order['purchase_code'],
                                'business_type'    => $business_type,
                                'business_name'    => isset($sale['business_type'][$account_k])?$sale['business_type'][$account_k]:null,
                                'purchase_type'    => $order['purchase_type'],
                                'times'            => $order['purchase_time'],
                                'money'            => $order['price'],
                                'write_off'        => isset($sale['write_off'][$account_k])?(float)$sale['write_off'][$account_k]:0,
                                'write_off_money'  => isset($sale['write_off_money'][$account_k])?(float)$sale['write_off_money'][$account_k]:0,
                                'write_off_price'  => isset($sale['write_off_price'][$account_k])?(float)$sale['write_off_price'][$account_k]:0,
                                'top'              => 2,
                            ]);
                            $info[] = $thisrow;

                            $where = [];
                            $where['source_id'] = $order['id'];
                            $log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere($where))->find();
                            if($log){
                                $status = true;
                                foreach ($log_arr as $log_arr_k=>$log_arr_v){
                                    if($log_arr_v['id']==$log['id']){
                                        $status = false;
                                        $log_arr[$log_arr_k]['money'] += $thisrow['write_off_price'];
                                        $log_arr[$log_arr_k]['write_off'] -= $thisrow['write_off_price'];
                                    }
                                }
                                if($status){
                                    $log_arr[] = [
                                        'id' => $log['id'],
                                        'write_off' => $log['write_off']-$thisrow['write_off_price'],
                                        'money' => $log['money']+$thisrow['write_off_price'],
                                    ];
                                }
                            }else{
                                $log_add[] = [
                                    'source_id' => $order['id'],
                                    'write_off' => $thisrow['write_off_money']-$thisrow['write_off_price'],
                                    'money' => $thisrow['write_off_price'],
                                ];
                            }
                        }
                    }
                }

                $rowdata = (new Goods())->setDataInfo([
                    'purchase_code'     =>  $params['purchase_code'],
                    'purchase_time'     =>  strtotime($params['purchase_time']),
                    'business_type'     =>  $params['business_type'],
                    'customers_id'      =>  isset($params['customers_id'])?(float)$params['customers_id']:null,
                    'customers_out_id'  =>  isset($params['customers_out_id'])?(float)$params['customers_out_id']:null,
                    'customers_enter_id'=>  isset($params['customers_enter_id'])?(float)$params['customers_enter_id']:null,
                    'suppliers_id'      =>  isset($params['suppliers_id'])?(float)$params['suppliers_id']:null,
                    'suppliers_out_id'  =>  isset($params['suppliers_out_id'])?(float)$params['suppliers_out_id']:null,
                    'suppliers_enter_id'=>  isset($params['suppliers_enter_id'])?(float)$params['suppliers_enter_id']:null,
                    'write_off'         =>  $account_money,
                    'remarks'           =>  $params['note'],
                    'preparation_id'    =>  $admin['id'],
                    'operation_id'      =>  $admin['id'],
                    'createtime'        => time(),
                    'updatetime'        => time(),
                ]);


                if($account_money!=$sale_money && $business_type<=3){
                    $this->error('核销金额错误');
                }

                if($this->model->where((new Goods())->setWhere(['purchase_code'=>trim($params['purchase_code']),'id'=>['<>',$ids]]))->find()){
                    $this->error('单据编号已占用');
                }

                $writeoff_log = $log_arr;
                foreach ($info_list as $info_list_k=>$info_list_v){
                    $log = Db::name('kuerp_writeoff_log')->where(['source_id'=>$info_list_v['source_id']])->find();
                    if($log){
                        $addstatus = true;
                        foreach ($writeoff_log as $writeoff_log_k=>$writeoff_log_v){
                            if($writeoff_log_v['id']==$log['id']){
                                $addstatus = false;
                                $writeoff_log[$writeoff_log_k]['write_off'] = $writeoff_log_v['write_off']+$info_list_v['write_off_price'];
                                $writeoff_log[$writeoff_log_k]['money'] = $writeoff_log_v['money']-$info_list_v['write_off_price'];
                            }
                        }
                        if($addstatus){
                            $writeoff_log[] = [
                                'id' => $log['id'],
                                'write_off'=>($log['write_off']+$info_list_v['write_off_price']),
                                'money'=>($log['money']-$info_list_v['write_off_price'])
                            ];
                        }
                    }
                }

                $result = false;
                Db::startTrans();
                try {if($examine!=1 && $row['examine_status']==1){
                    $this->examine($ids,2);
                }
                    if(!empty($row)){
                        $result = $this->model->where((new Goods())->setWhere(['id'=>$ids]))->update($rowdata);
                    }
                    if(!empty($writeoff_log)){
                        (new \app\admin\model\kuerp\WriteoffLog())->saveAll($writeoff_log);
                    }
                    Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>$ids]))->delete();
                    foreach ($info as $info_k=>$info_v){
                        $info[$info_k]['collection_id'] = $ids;
                    }
                    Db::name('kuerp_writeoff_info')->insertAll($info);
                    if(!empty($log_add)){
                        (new \app\admin\model\kuerp\WriteoffLog())->insertAll($log_add);
                    }
                    Db::commit();
                } catch (Exception $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                }
                if ($result !== false) {
                    if($examine!=1){
                        try {
                            $exa = $this->examine($ids,1);
                        } catch (Exception $e) {
                        }
                        if(!isset($exa) || $exa['status']!=1){
                            $this->error(__('No rows were inserted'));
                        }
                    }
                    $this->success();
                } else {
                    $this->error(__('No rows were inserted'));
                }
            }
            $this->error(__('Parameter %s can not be empty', ''));
        }
        $this->view->assign("row", $row);

        $info = Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>$row['id']]))->select();
        $this->view->assign("info", $info);

        $kuerp_customers = Db::name('kuerp_customers')->where(['id'=>$row['customers_id']])->field('id,customer_name')->find();
        $this->assignconfig("kuerp_customers", $kuerp_customers);
        $kuerp_customers_out = Db::name('kuerp_customers')->where(['id'=>$row['customers_out_id']])->field('id,customer_name')->find();
        $this->assignconfig("kuerp_customers_out", $kuerp_customers_out);
        $kuerp_customers_enter = Db::name('kuerp_customers')->where(['id'=>$row['customers_enter_id']])->field('id,customer_name')->find();
        $this->assignconfig("kuerp_customers_enter", $kuerp_customers_enter);

        $kuerp_suppliers = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_id']])->field('id,supplyer_name')->find();
        $this->assignconfig("kuerp_suppliers", $kuerp_suppliers);
        $kuerp_suppliers_out = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_out_id']])->field('id,supplyer_name')->find();
        $this->assignconfig("kuerp_suppliers_out", $kuerp_suppliers_out);
        $kuerp_suppliers_enter = Db::name('kuerp_suppliers')->where(['id'=>$row['suppliers_enter_id']])->field('id,supplyer_name')->find();
        $this->assignconfig("kuerp_suppliers_enter", $kuerp_suppliers_enter);

        //审核禁止输入
        $examine_set= Db::name('kuerp_sets')->where(['name'=>'examine'])->value('is_checked');
        if($examine_set==1 && $row['examine_status']==1){
            $this->assign('exclass','hiddens');
        }
        $this->assignconfig("examine_status", $row['examine_status']);

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

    /**
     * 删除
     */
    public function del($ids = "")
    {
        if (!$this->request->isPost()) {
            $this->error(__("Invalid parameters"));
        }
        $ids = $ids ? $ids : $this->request->post("ids");
        if ($ids) {
            $pk = $this->model->getPk();
            $adminIds = $this->getDataLimitAdminIds();
            $examine= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'examine']))->value('is_checked');
            if (is_array($adminIds)) {
                $this->model->where($this->dataLimitField, 'in', $adminIds);
            }
            $list = $this->model->where($pk, 'in', $ids)->select();
            $del_id = [];
            foreach ($list as $list_k=>$list_v){
                if($list_v['examine_status']==1){
                    (new \app\admin\controller\kuerp\Checkout())->checkOutTime($list_v['purchase_time']);
                }
                if($list_v['examine_status']==1 && $examine==1){
                    $this->error('不能删除已审核的数据');
                }elseif ($list_v['examine_status']==1 && $examine!=1){
                    try {
                        $this->examine($list_v['id'],2);
                        $del_id[] = $list_v['id'];
                    } catch (Exception $e) {
                    }
                }else{
                    $del_id[] = $list_v['id'];
                }
            }
            $list = $this->model->where((new Goods())->setWhere(['id'=>['in',$del_id]]))->select();
            //详情
            $info_list = Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>['in',$del_id]]))->select();

            $count = 0;
            Db::startTrans();
            try {
                foreach ($list as $k => $v) {
                    $count += $v->delete();
                }
                foreach ($info_list as $info_list_k=>$info_list_v){
                    $log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere(['source_id'=>$info_list_v['source_id']]))->find();
                    if($log){
                        Db::name('kuerp_writeoff_log')->where(['id'=>$log['id']])->update([
                            'write_off'=>($log['write_off']+$info_list_v['write_off_price']),
                            'money'=>($log['money']-$info_list_v['write_off_price'])
                        ]);
                    }
                }
                foreach ($info_list as $info_list_k=>$info_list_v){
                    $log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere(['source_id'=>$info_list_v['source_id']]))->find();
                    if($log && $log['money']==0){
                        Db::name('kuerp_writeoff_log')->where(['id'=>$log['id']])->delete();
                    }
                }
                Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>['in',$del_id]]))->delete();
                Db::commit();
            }catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            if ($count) {
                $this->success();
            } else {
                $this->error(__('No rows were deleted'));
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }

    //审核/反审核
    public function examine($ids = null,$examine=1){
        $examine_set= Db::name('kuerp_sets')->where((new Goods())->setWhere(['name'=>'examine']))->value('is_checked');
        if(empty($ids)){
            if($examine_set!=1){
                return ['status'=>0,'msg'=>'系统错误'];
            }
            $this->error('请选择要操作的数据');
        }
        $admin = Session::get('admin');
        if($examine==1){
            $list = Db::name('kuerp_writeoff')->where((new Goods())->setWhere(['id'=>['in',$ids],'examine_status'=>'0']))->select();
            foreach ($list as $list_k=>$list_v){
                (new \app\admin\controller\kuerp\Checkout())->checkOutTime($list_v['purchase_time']);
            }
            if(empty($list)){
                if($examine_set!=1){
                    return ['status'=>0,'msg'=>'系统错误'];
                }
                $this->error('请选择需要审核的数据');
            }
            $success_count = 0;
            foreach ($list as $list_k=>$list_v){

                $info = Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>$list_v['id']]))->select();

                Db::startTrans();
                try {
                    foreach ($info as $info_k=>$info_v){
                        if($info_v['purchase_type']==3 && $info_v['type']==1){
                            //销售
                            $order = Db::name('kuerp_goods_sales')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            $more_money = $order['money_tax_price']-$info_v['write_off_price']-$order['pay_money'];
                            $status = $more_money<=0?1:2;
                            $pay_money = $order['pay_money']+$info_v['write_off_price'];
                            Db::name('kuerp_goods_sales')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                ->update(['pay_money'=>$pay_money,'pay_status'=>$status]);
                        }else if($info_v['purchase_type']==3 && $info_v['type']==2){
                            //销售退货
                            $order = Db::name('kuerp_goods_sales_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            $more_money = $order['money_tax_price']+$info_v['write_off_price']-$order['retreat_money'];
                            $status = $more_money==0?1:2;
                            $pay_money = $order['retreat_money']+(-$info_v['write_off_price']);
                            Db::name('kuerp_goods_sales_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                ->update(['retreat_money'=>$pay_money,'retreat_status'=>$status]);
                        }else if($info_v['purchase_type']==4 && $info_v['type']==1){
                            //购货
                            $order = Db::name('kuerp_goods_purchase')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            $more_money = $order['all_money']+$order['tax_money']-$info_v['write_off_price']-$order['pay_money'];
                            $status = $more_money<=0?1:2;
                            $pay_money = $order['pay_money']+$info_v['write_off_price'];
                            Db::name('kuerp_goods_purchase')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                ->update(['pay_money'=>$pay_money,'pay_status'=>$status]);
                        }else if($info_v['purchase_type']==4 && $info_v['type']==2){
                            //购货退货
                            $order = Db::name('kuerp_goods_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            $more_money = $order['all_money']+$order['tax_money']+$info_v['write_off_price']-$order['retreat_money'];;
                            $status = $more_money==0?1:2;
                            $pay_money = $order['retreat_money']+(-$info_v['write_off_price']);
                            Db::name('kuerp_goods_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                ->update(['retreat_money'=>$pay_money,'retreat_status'=>$status]);
                        }

                        $writeoff_source = Db::name('kuerp_writeoff_source')->where(['id'=>$info_v['source_id']])->find();
                        if ($info_v['top']==1){
                            if(($info_v['business_type']==1 && $info_v['type']==3)){
                                Db::name('kuerp_sales_payment_log')->insert([
                                    'customers_id'      => $writeoff_source['customers_id'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }else if($info_v['business_type']==2 && $info_v['type']==3){
                                Db::name('kuerp_payment_log')->insert([
                                    'suppliers_code'    => $writeoff_source['suppliers_code'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }else if($info_v['business_type']==3 && $info_v['type']<4){
                                Db::name('kuerp_sales_payment_log')->insert([
                                    'customers_id'      => $writeoff_source['customers_id'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }else if($info_v['business_type']==4 && $info_v['type']<4){
                                Db::name('kuerp_sales_payment_log')->insert([
                                    'customers_id'      => $list_v['customers_out_id'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => -$info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                                Db::name('kuerp_sales_payment_log')->insert([
                                    'customers_id'      => $list_v['customers_enter_id'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }else if($info_v['business_type']==5 && $info_v['type']<4){
                                $suppliers = Db::name('kuerp_suppliers')->where((new Goods())->setWhere(['id'=>$list_v['suppliers_out_id']]))->value('supplyer_code');
                                Db::name('kuerp_payment_log')->insert([
                                    'suppliers_code'    => $suppliers,
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                                $suppliers = Db::name('kuerp_suppliers')->where((new Goods())->setWhere(['id'=>$list_v['suppliers_enter_id']]))->value('supplyer_code');
                                Db::name('kuerp_payment_log')->insert([
                                    'suppliers_code'    => $suppliers,
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => -$info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }
                        }else if ($info_v['top']==2){
                            if(($info_v['business_type']==1 && ($info_v['purchase_type']==3 || $info_v['purchase_type']==5))){
                                Db::name('kuerp_sales_payment_log')->insert([
                                    'customers_id'      => $writeoff_source['customers_id'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }else if($info_v['business_type']==2 && ($info_v['purchase_type']==4 || $info_v['purchase_type']==5)){
                                Db::name('kuerp_payment_log')->insert([
                                    'suppliers_code'    => $writeoff_source['suppliers_code'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }else if($info_v['business_type']==3 && ($info_v['purchase_type']==4 || $info_v['purchase_type']==5)){
                                Db::name('kuerp_payment_log')->insert([
                                    'suppliers_code'    => $writeoff_source['suppliers_code'],
                                    'bill_time'         => $info_v['purchase_time'],
                                    'bill_code'         => $info_v['purchase_number'],
                                    'bill_codes'        => $info_v['purchase_code'],
                                    'business_type'     => '7',
                                    'pay_money'         => $info_v['write_off_price'],
                                    'createtime'        => time(),
                                ]);
                            }
                        }

                        if(($info_v['purchase_type']==3 || $info_v['purchase_type']==4) && $info_v['type']==1){
                            Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['id'=>$info_v['id']]))->update([
                                'old_money'=>$order['pay_money'],
                                'old_status'=>$order['pay_status'],
                            ]);
                        }else if(($info_v['purchase_type']==3 || $info_v['purchase_type']==4) && $info_v['type']==2){
                            Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['id'=>$info_v['id']]))->update([
                                'old_money'=>$order['retreat_money'],
                                'old_status'=>$order['retreat_status'],
                            ]);
                        }
                    }

                    switch ($list_v['business_type']){
                        case 1:
                            //预收冲应收
                            Db::name('kuerp_accounts_receivable')->insert((new Goods())->setDataInfo([
                                'customers_id'      => $list_v['customers_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '1',
                                'receivable'        => -$list_v['write_off'],
                                'advance'           => -$list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => -$list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'0']))->update(['examine_status'=>1,'examine_id'=>$admin['id'],'examine_time'=>time(),'operation_id'=>$admin['id']]);
                            break;
                        case 2:
                            //预付冲应付
                            Db::name('kuerp_accounts_copewith')->insert((new Goods())->setDataInfo([
                                'suppliers_id'      => $list_v['suppliers_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '2',
                                'receivable'        => -$list_v['write_off'],
                                'advance'           => -$list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => -$list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'0']))->update(['examine_status'=>1,'examine_id'=>$admin['id'],'examine_time'=>time(),'operation_id'=>$admin['id']]);
                            break;
                        case 3:
                            //应收冲应付
                            Db::name('kuerp_accounts_receivable')->insert((new Goods())->setDataInfo([
                                'customers_id'      => $list_v['customers_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '3',
                                'receivable'        => -$list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => -$list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));
                            Db::name('kuerp_accounts_copewith')->insert((new Goods())->setDataInfo([
                                'suppliers_id'      => $list_v['suppliers_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '3',
                                'receivable'        => -$list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => -$list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));
                            $suppliers = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_id']])->find();
                            $gave_money = $suppliers['need_receive_account'] - $list_v['write_off'];
                            Db::name('kuerp_customers')->where(['id'=>$list_v['customers_id']])->update(['need_receive_account'=>$gave_money]);

                            $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_id']])->find();
                            $gave_money = $suppliers['need_give_account'] - $list_v['write_off'];
                            Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_id']])->update(['need_give_account'=>$gave_money]);

                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'0']))->update(['examine_status'=>1,'examine_id'=>$admin['id'],'examine_time'=>time(),'operation_id'=>$admin['id']]);
                            break;
                        case 4:
                            //应收转应收
                            Db::name('kuerp_accounts_receivable')->insert((new Goods())->setDataInfo([
                                'customers_id'      => $list_v['customers_out_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '4',
                                'receivable'        => -$list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => -$list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));

                            $suppliers = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_out_id']])->find();
                            $gave_money = $suppliers['need_receive_account'] - $list_v['write_off'];
                            Db::name('kuerp_customers')->where(['id'=>$list_v['customers_out_id']])->update(['need_receive_account'=>$gave_money]);

                            Db::name('kuerp_accounts_receivable')->insert((new Goods())->setDataInfo([
                                'customers_id'      => $list_v['customers_enter_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '4',
                                'receivable'        => $list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => $list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));

                            $suppliers = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_enter_id']])->find();
                            $gave_money = $suppliers['need_receive_account'] + $list_v['write_off'];
                            Db::name('kuerp_customers')->where(['id'=>$list_v['customers_enter_id']])->update(['need_receive_account'=>$gave_money]);

                            Db::name('kuerp_writeoff_source')->insert([
                                'purchase_type' => 3,
                                'type' => 4,
                                'customers_id' => $list_v['customers_enter_id'],
                                'purchase_code' => $list_v['purchase_code'],
                                'purchase_time' => $list_v['purchase_time'],
                                'price' => $list_v['write_off'],
                                'money' => 0,
                                'write_off' => $list_v['write_off'],
                            ]);
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'0']))->update(['examine_status'=>1,'examine_id'=>$admin['id'],'examine_time'=>time(),'operation_id'=>$admin['id']]);
                            break;
                        case 5:
                            //应付转应付
                            Db::name('kuerp_accounts_copewith')->insert((new Goods())->setDataInfo([
                                'suppliers_id'      => $list_v['suppliers_out_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '5',
                                'receivable'        => -$list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => -$list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));

                            $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_out_id']])->find();
                            $gave_money = $suppliers['need_give_account'] - $list_v['write_off'];
                            Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_out_id']])->update(['need_give_account'=>$gave_money]);

                            Db::name('kuerp_accounts_copewith')->insert((new Goods())->setDataInfo([
                                'suppliers_id'      => $list_v['suppliers_enter_id'],
                                'purchase_time'     => $list_v['purchase_time'],
                                'purchase_code'     => $list_v['purchase_code'],
                                'business_type'     => '5',
                                'receivable'        => $list_v['write_off'],
                                'remark'            => $list_v['remarks'],
                                'receivable_money'  => $list_v['write_off'],
                                'createtime'        => time(),
                                'updatetime'        => time(),
                            ]));

                            $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_enter_id']])->find();
                            $gave_money = $suppliers['need_give_account'] + $list_v['write_off'];
                            Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_enter_id']])->update(['need_give_account'=>$gave_money]);

                            $suppliers = Db::name('kuerp_suppliers')->where((new Goods())->setWhere(['id'=>$list_v['suppliers_enter_id']]))->value('supplyer_code');
                            Db::name('kuerp_writeoff_source')->insert([
                                'purchase_type' => 4,
                                'type' => 4,
                                'suppliers_code' => $suppliers,
                                'purchase_code' => $list_v['purchase_code'],
                                'purchase_time' => $list_v['purchase_time'],
                                'price' => $list_v['write_off'],
                                'money' => 0,
                                'write_off' => $list_v['write_off'],
                            ]);
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'0']))->update(['examine_status'=>1,'examine_id'=>$admin['id'],'examine_time'=>time(),'operation_id'=>$admin['id']]);
                            break;
                    }
                    Db::commit();
                } catch (Exception $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                }
                if(isset($result) && $result !== false){
                    $success_count += 1;
                }
            }
            if($success_count>0){
                if($examine_set!=1){
                    return ['status'=>1,'msg'=>'操作成功'];
                }
                $this->success($success_count.'条数据审核成功');
            }else{
                if($examine_set!=1){
                    return ['status'=>0,'msg'=>'操作失败'];
                }
                $this->error('审核失败');
            }
        }else{
            $list = Db::name('kuerp_writeoff')->where((new Goods())->setWhere(['id'=>['in',$ids],'examine_status'=>'1']))->select();
            foreach ($list as $list_k=>$list_v){
                (new \app\admin\controller\kuerp\Checkout())->checkOutTime($list_v['purchase_time']);
            }
            if(empty($list)){
                if($examine_set!=1){
                    return ['status'=>0,'msg'=>'系统错误'];
                }
                $this->error('请选择需要反审核的数据');
            }
            $success_count = 0;
            foreach ($list as $list_k=>$list_v){

                $info = Db::name('kuerp_writeoff_info')->where((new Goods())->setWhere(['collection_id'=>$list_v['id']]))->select();

                Db::startTrans();
                try {
                    foreach ($info as $info_k=>$info_v){
                        if($info_v['purchase_type']==3 && $info_v['type']==1){
                            //销售
                            $order = Db::name('kuerp_goods_sales')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            if($order){
                                Db::name('kuerp_goods_sales')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                    ->update(['pay_money'=>$info_v['old_money'],'pay_status'=>$info_v['old_status']]);
                            }
                        }else if($info_v['purchase_type']==3 && $info_v['type']==2){
                            //销售退货
                            $order = Db::name('kuerp_goods_sales_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            if($order){
                                Db::name('kuerp_goods_sales_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                    ->update(['retreat_money'=>$info_v['old_money'],'retreat_status'=>$info_v['old_status']]);
                            }
                        }else if($info_v['purchase_type']==4 && $info_v['type']==1){
                            //购货
                            $order = Db::name('kuerp_goods_purchase')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            if($order){
                                Db::name('kuerp_goods_purchase')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                    ->update(['pay_money'=>$info_v['old_money'],'pay_status'=>$info_v['old_status']]);
                            }
                        }else if($info_v['purchase_type']==4 && $info_v['type']==2){
                            //购货退货
                            $order = Db::name('kuerp_goods_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))->find();
                            if($order){
                                Db::name('kuerp_goods_exchange')->where((new Goods())->setWhere(['purchase_code'=>$info_v['purchase_number']]))
                                    ->update(['retreat_money'=>$info_v['old_money'],'retreat_status'=>$info_v['old_status']]);
                            }
                        }

                        Db::name('kuerp_payment_log')->where(['bill_codes'=>$info_v['purchase_code']])->delete();
                        Db::name('kuerp_sales_payment_log')->where(['bill_codes'=>$info_v['purchase_code']])->delete();
                    }

                    switch ($list_v['business_type']){
                        case 1:
                            //预收冲应收
                            Db::name('kuerp_accounts_receivable')->where((new Goods())->setWhere(['business_type'=>'1','purchase_code'=>$list_v['purchase_code']]))->delete();
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'1']))->update(['examine_status'=>'0','examine_id'=>null,'examine_time'=>null,'operation_id'=>$admin['id']]);
                            break;
                        case 2:
                            //预付冲应付
                            Db::name('kuerp_accounts_copewith')->where((new Goods())->setWhere(['business_type'=>'2','purchase_code'=>$list_v['purchase_code']]))->delete();
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'1']))->update(['examine_status'=>'0','examine_id'=>null,'examine_time'=>null,'operation_id'=>$admin['id']]);
                            break;
                        case 3:
                            //应收冲应付
                            $suppliers = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_id']])->find();
                            $gave_money = $suppliers['need_receive_account'] + $list_v['write_off'];
                            Db::name('kuerp_customers')->where(['id'=>$list_v['customers_id']])->update(['need_receive_account'=>$gave_money]);

                            $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_id']])->find();
                            $gave_money = $suppliers['need_give_account'] + $list_v['write_off'];
                            Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_id']])->update(['need_give_account'=>$gave_money]);

                            Db::name('kuerp_accounts_receivable')->where((new Goods())->setWhere(['business_type'=>'3','purchase_code'=>$list_v['purchase_code']]))->delete();
                            Db::name('kuerp_accounts_copewith')->where((new Goods())->setWhere(['business_type'=>'3','purchase_code'=>$list_v['purchase_code']]))->delete();
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'1']))->update(['examine_status'=>'0','examine_id'=>null,'examine_time'=>null,'operation_id'=>$admin['id']]);
                            break;
                        case 4:
                            //应收转应收

                            $suppliers = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_out_id']])->find();
                            $gave_money = $suppliers['need_receive_account'] + $list_v['write_off'];
                            Db::name('kuerp_customers')->where(['id'=>$list_v['customers_out_id']])->update(['need_receive_account'=>$gave_money]);

                            $suppliers = Db::name('kuerp_customers')->where(['id'=>$list_v['customers_enter_id']])->find();
                            $gave_money = $suppliers['need_receive_account'] - $list_v['write_off'];
                            Db::name('kuerp_customers')->where(['id'=>$list_v['customers_enter_id']])->update(['need_receive_account'=>$gave_money]);

                            Db::name('kuerp_writeoff_source')->where(['purchase_code'=>$list_v['purchase_code'],'type'=>4])->delete();
                            Db::name('kuerp_accounts_receivable')->where((new Goods())->setWhere(['business_type'=>'4','purchase_code'=>$list_v['purchase_code']]))->delete();
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'1']))->update(['examine_status'=>'0','examine_id'=>null,'examine_time'=>null,'operation_id'=>$admin['id']]);
                            break;
                        case 5:
                            //应付转应付

                            $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_out_id']])->find();
                            $gave_money = $suppliers['need_give_account'] + $list_v['write_off'];
                            Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_out_id']])->update(['need_give_account'=>$gave_money]);

                            $suppliers = Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_enter_id']])->find();
                            $gave_money = $suppliers['need_give_account'] - $list_v['write_off'];
                            Db::name('kuerp_suppliers')->where(['id'=>$list_v['suppliers_enter_id']])->update(['need_give_account'=>$gave_money]);

                            Db::name('kuerp_writeoff_source')->where(['purchase_code'=>$list_v['purchase_code'],'type'=>4])->delete();
                            Db::name('kuerp_accounts_copewith')->where((new Goods())->setWhere(['business_type'=>'5','purchase_code'=>$list_v['purchase_code']]))->delete();
                            $result = $this->model->where((new Goods())->setWhere(['id'=>$list_v['id'],'examine_status'=>'1']))->update(['examine_status'=>'0','examine_id'=>null,'examine_time'=>null,'operation_id'=>$admin['id']]);
                            break;
                    }
                    Db::commit();
                } catch (Exception $e) {
                    Db::rollback();
                    $this->error($e->getMessage());
                }

                if(isset($result) && $result !== false){
                    $success_count += 1;
                }
            }
            if($success_count>0){
                if($examine_set!=1){
                    return ['status'=>1,'msg'=>'操作成功'];
                }
                $this->success($success_count.'条数据反审核成功');
            }else{
                if($examine_set!=1){
                    return ['status'=>0,'msg'=>'操作失败'];
                }
                $this->error('反审核失败');
            }
        }
    }
    //核销单选择预收单据
    public function choselist($customers_id=''){
        $this->assignconfig('customers_id',$customers_id);
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            $data = input();
            $where = [];
            $where['customers_id'] = $customers_id;
            $where['purchase_type'] = ['in',[1,6]];
            if(isset($data['filter'])){
                $filter = (array)json_decode($data['filter'], true);
                $filter = $filter ? $filter : [];
                if(!empty($filter['purchase_time'])){
                    $str = explode(' - ',$filter['purchase_time']);
                    $where['purchase_time'] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];
                }
                if(!empty($filter['purchase_code'])){
                    $where['purchase_code'] = ["like", '%'.$filter['purchase_code'].'%'];
                }
            }
            $list = Db::name('kuerp_writeoff_source')
                ->where((new Goods())->setWhere($where))
                ->where(function ($query){
                    $query->where('id', 'NOT IN', function ($query) {
                        $query->name('kuerp_writeoff_log')->field('source_id');
                    })
                        ->whereOr('id', 'IN', function ($query) {
                            $query->name('kuerp_writeoff_log')->where(['write_off'=>['<>','0']])->field('source_id');
                        });
                })
                ->order(['purchase_type'=>'DESC','purchase_time'=>'ASC'])
                ->select();

            foreach ($list as $list_k=>$list_v){
                $list[$list_k]['money_tax_price'] = $list_v['price'];
                $list[$list_k]['pay_money'] = $list_v['money'];
                $list[$list_k]['money'] = $list_v['write_off'];
                $list[$list_k]['purchase_type_id'] = $list_v['id'];
                $list[$list_k]['purchase_codes'] = $list_v['purchase_code'];
                if($list_v['purchase_type']>4){
                    $list[$list_k]['purchase_type'] = '期初余额';
                    $list[$list_k]['purchase_code'] = '期初余额';
                }else{
                    $list[$list_k]['purchase_type'] = '收款';
                }
                $list[$list_k]['purchase_time'] = date('Y-m-d',$list_v['purchase_time']);
                $list[$list_k]['remark'] = $list_v['remark'];
                $list[$list_k]['type'] = $list_v['type'];

                $writeoff_log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere(['source_id'=>$list_v['id']]))->field('money,write_off')->find();
                if($writeoff_log){
                    $list[$list_k]['money'] = $writeoff_log['write_off'];
                    $list[$list_k]['pay_money'] = $writeoff_log['money'];
                }else{
                    $list[$list_k]['pay_money'] = 0;
                }
            }

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

            return json($result);
        }
        return $this->view->fetch();
    }
    //核销单选择预付单据
    public function choseadvancelist($suppliers_id=''){
        $this->assignconfig('suppliers_id',$suppliers_id);
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            $data = input();
            $suppliers = Db::name('kuerp_suppliers')->where((new Goods())->setWhere(['id'=>$suppliers_id]))->find();
            $where = [];
            $where['suppliers_code'] = $suppliers['supplyer_code'];
            $where['purchase_type'] = ['in',[2,6]];
            if(isset($data['filter'])){
                $filter = (array)json_decode($data['filter'], true);
                $filter = $filter ? $filter : [];
                if(!empty($filter['purchase_time'])){
                    $str = explode(' - ',$filter['purchase_time']);
                    $where['purchase_time'] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];
                }
                if(!empty($filter['purchase_code'])){
                    $where['purchase_code'] = ["like", '%'.$filter['purchase_code'].'%'];
                }
            }
            $list = Db::name('kuerp_writeoff_source')
                ->where((new Goods())->setWhere($where))
                ->where(function ($query){
                    $query->where('id', 'NOT IN', function ($query) {
                        $query->name('kuerp_writeoff_log')->field('source_id');
                    })
                        ->whereOr('id', 'IN', function ($query) {
                            $query->name('kuerp_writeoff_log')->where(['write_off'=>['<>','0']])->field('source_id');
                        });
                })
                ->order(['purchase_type'=>'DESC','purchase_time'=>'ASC'])
                ->select();

            foreach ($list as $list_k=>$list_v){
                $list[$list_k]['money_tax_price'] = $list_v['price'];
                $list[$list_k]['pay_money'] = $list_v['money'];
                $list[$list_k]['money'] = $list_v['write_off'];
                $list[$list_k]['purchase_type_id'] = $list_v['id'];
                $list[$list_k]['purchase_codes'] = $list_v['purchase_code'];
                if($list_v['purchase_type']>4){
                    $list[$list_k]['purchase_type'] = '期初余额';
                    $list[$list_k]['purchase_code'] = '期初余额';
                }else{
                    $list[$list_k]['purchase_type'] = '付款';
                }
                $list[$list_k]['purchase_time'] = date('Y-m-d',$list_v['purchase_time']);
                $list[$list_k]['remark'] = $list_v['remark'];
                $list[$list_k]['type'] = $list_v['type'];

                $writeoff_log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere(['source_id'=>$list_v['id']]))->field('money,write_off')->find();
                if($writeoff_log){
                    $list[$list_k]['money'] = $writeoff_log['write_off'];
                    $list[$list_k]['pay_money'] = $writeoff_log['money'];
                }else{
                    $list[$list_k]['pay_money'] = 0;
                }
            }
            $result = array("total" => 1, "rows" => $list);

            return json($result);
        }
        return $this->view->fetch();
    }
    //核销单选择应收单据
    public function chosereceivable($customers_id=''){
        $this->assignconfig('customers_id',$customers_id);
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            $data = input();
            $where = [];
            $where['customers_id'] = $customers_id;
            $where['purchase_type'] = ['in',[3,5]];
            if(isset($data['filter'])){
                $filter = (array)json_decode($data['filter'], true);
                $filter = $filter ? $filter : [];
                if(!empty($filter['purchase_time'])){
                    $str = explode(' - ',$filter['purchase_time']);
                    $where['purchase_time'] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];
                }
                if(!empty($filter['purchase_code'])){
                    $where['purchase_code'] = ["like", '%'.$filter['purchase_code'].'%'];
                }
            }
            $list = Db::name('kuerp_writeoff_source')
                ->where((new Goods())->setWhere($where))
                ->where(function ($query){
                    $query->where('id', 'NOT IN', function ($query) {
                        $query->name('kuerp_writeoff_log')->field('source_id');
                    })
                        ->whereOr('id', 'IN', function ($query) {
                            $query->name('kuerp_writeoff_log')->where(['write_off'=>['<>','0']])->field('source_id');
                        });
                })
                ->order(['purchase_type'=>'DESC','purchase_time'=>'ASC'])
                ->select();

            foreach ($list as $list_k=>$list_v){
                $list[$list_k]['money_tax_price'] = $list_v['price'];
                $list[$list_k]['pay_money'] = $list_v['money'];
                $list[$list_k]['money'] = $list_v['write_off'];
                $list[$list_k]['purchase_type_id'] = $list_v['id'];
                $list[$list_k]['purchase_codes'] = $list_v['purchase_code'];
                if($list_v['purchase_type']>4){
                    $list[$list_k]['purchase_type'] = '期初余额';
                    $list[$list_k]['purchase_code'] = '期初余额';
                }else{
                    if($list_v['type']==1){
                        $list[$list_k]['purchase_type'] = '普通销售';
                    }else if($list_v['type']==4){
                        $list[$list_k]['purchase_type'] = '核销';
                    }else{
                        $list[$list_k]['purchase_type'] = '销售退货';
                    }
                }
                $list[$list_k]['purchase_time'] = date('Y-m-d',$list_v['purchase_time']);
                $list[$list_k]['remark'] = $list_v['remark'];
                $list[$list_k]['type'] = $list_v['type'];

                $writeoff_log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere(['source_id'=>$list_v['id']]))->field('money,write_off')->find();
                if($writeoff_log){
                    $list[$list_k]['money'] = $writeoff_log['write_off'];
                    $list[$list_k]['pay_money'] = $writeoff_log['money'];
                }else{
                    $list[$list_k]['pay_money'] = 0;
                }
            }

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

            return json($result);
        }
        return $this->view->fetch();
    }
    //核销单选择应付单据
    public function chosecopewith($suppliers_id=''){
        $this->assignconfig('suppliers_id',$suppliers_id);
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if ($this->request->isAjax()) {
            $data = input();
            $suppliers = Db::name('kuerp_suppliers')->where((new Goods())->setWhere(['id'=>$suppliers_id]))->find();
            $where = [];
            $where['suppliers_code'] = $suppliers['supplyer_code'];
            $where['purchase_type'] = ['in',[4,5]];
            if(isset($data['filter'])){
                $filter = (array)json_decode($data['filter'], true);
                $filter = $filter ? $filter : [];
                if(!empty($filter['purchase_time'])){
                    $str = explode(' - ',$filter['purchase_time']);
                    $where['purchase_time'] = ["BETWEEN", [strtotime($str[0]),strtotime($str[1])]];
                }
                if(!empty($filter['purchase_code'])){
                    $where['purchase_code'] = ["like", '%'.$filter['purchase_code'].'%'];
                }
            }
            $list = Db::name('kuerp_writeoff_source')
                ->where((new Goods())->setWhere($where))
                ->where(function ($query){
                    $query->where('id', 'NOT IN', function ($query) {
                        $query->name('kuerp_writeoff_log')->field('source_id');
                    })
                        ->whereOr('id', 'IN', function ($query) {
                            $query->name('kuerp_writeoff_log')->where(['write_off'=>['<>','0']])->field('source_id');
                        });
                })
                ->order(['purchase_type'=>'DESC','purchase_time'=>'ASC'])
                ->select();

            foreach ($list as $list_k=>$list_v){
                $list[$list_k]['money_tax_price'] = $list_v['price'];
                $list[$list_k]['pay_money'] = $list_v['money'];
                $list[$list_k]['money'] = $list_v['write_off'];
                $list[$list_k]['purchase_type_id'] = $list_v['id'];
                $list[$list_k]['purchase_codes'] = $list_v['purchase_code'];
                if($list_v['purchase_type']>4){
                    $list[$list_k]['purchase_type'] = '期初余额';
                    $list[$list_k]['purchase_code'] = '期初余额';
                }else{
                    if($list_v['type']==1){
                        $list[$list_k]['purchase_type'] = '普通购货';
                    }else{
                        $list[$list_k]['purchase_type'] = '购货退货';
                    }
                }
                $list[$list_k]['purchase_time'] = date('Y-m-d',$list_v['purchase_time']);
                $list[$list_k]['remark'] = $list_v['remark'];
                $list[$list_k]['type'] = $list_v['type'];

                $writeoff_log = Db::name('kuerp_writeoff_log')->where((new Goods())->setWhere(['source_id'=>$list_v['id']]))->field('money,write_off')->find();
                if($writeoff_log){
                    $list[$list_k]['money'] = $writeoff_log['write_off'];
                    $list[$list_k]['pay_money'] = $writeoff_log['money'];
                }else{
                    $list[$list_k]['pay_money'] = 0;
                }
            }

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

            return json($result);
        }
        return $this->view->fetch();
    }
}