Checkout.php 45 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
<?php

namespace app\admin\controller\kuerp;

use app\common\controller\Backend;
use think\Db;
use Exception;
use think\exception\PDOException;
use think\exception\ValidateException;
use think\Session;
/**
 * 结账/反结账
 *
 * @icon fa fa-circle-o
 */
class Checkout extends Backend
{

    /**
     * ExpendType模型对象
     * @var \app\admin\model\kuerp\ExpendType
     */
    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\Checkout();

        $enable_time = Db::name('kuerp_sets')->where(['name'=>'enable_time'])->value('value');
        $checkdate = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checkdate');
        $this->assign('enable_time', $enable_time);
        $this->assign('checkdate', $checkdate);
    }

    /**
     * 查看
     */
    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(['preparation'])
                ->where($where)
                ->order($sort, $order)
                ->paginate($limit);

            foreach ($list as $row) {
                $row->getRelation('preparation')->visible(['username']);
            }

            foreach ($list as $list_k=>$list_v){
                $list[$list_k]['createtime'] = date('Y-m-d H:i:s',$list_v['createtime']);
            }

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

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

    /**
     * 结账
     */
    public function checkout()
    {
        if ($this->request->isPost()) {
            $checkdate = $this->request->post("checkdate");
            if(empty($checkdate)){
                $this->error('请选择结账日期');
            }
            $checkdate = date('Y-m-d',strtotime($checkdate));
            $checktime = strtotime($checkdate);

            $enable_time = Db::name('kuerp_sets')->where(['name'=>'enable_time'])->value('value');
            $enable_time = strtotime($enable_time);
            if($enable_time>$checktime){
                $this->error('结账日期不能小于系统启用日期:'.date('Y-m-d',$enable_time).'!');
            }
            $lastdate = Db::name('kuerp_checkout')->order(['checktime'=>'DESC'])->value('checkdate');
            $log = Db::name('kuerp_checkout')->where(['checktime'=>['>=',$checktime]])->find();
            if($log){
                $this->error('结账日期不能小于等于上次结账日期:'.$lastdate.'!');
            }
            if(empty($lastdate)){
                $lastdate = $enable_time;
            }else{
                $lastdate = strtotime($lastdate);
            }

            $admin = Session::get('admin');
            $data = [
                'checkdate'         => $checkdate,
                'checktime'         => $checktime,
                'preparation_id'    => $admin['id'],
                'preparation_time'  => time(),
                'createtime'        => time(),
                'updatetime'        => time()
            ];

            $goodsInfo = $this->checkOutGoods($lastdate,$checktime);
            $saleData = [];
            foreach ($goodsInfo as $goodsInfo_k=>$goodsInfo_v){
                $saleData[] = [
                    'id'            => $goodsInfo_v['id'],
                    'sales_cost'    => $goodsInfo_v['sales_cost']
                ];
            }

            $info = [];
            $result= $this->checkOutGoodss($checktime);
            foreach ($result as $result_k=>$result_v){
                $info[] = [
                    'goods_id'      => $result_v['id'],
                    'goods_code'    => $result_v['goods_code'],
                    'basic_nmber'   => isset($result_v['purchase_info']['basic_nmber'])?$result_v['purchase_info']['basic_nmber']:0,
                    'all_money'     => isset($result_v['purchase_info']['all_money'])?$result_v['purchase_info']['all_money']:0,
                    'purchase_id'   => isset($result_v['purchase_info']['id'])?$result_v['purchase_info']['id']:0,
                    'purchase_time' => isset($result_v['purchase_info']['purchase_time'])?$result_v['purchase_info']['purchase_time']:null,
                ];
            }
            //移动平均
            $result= $this->checkOutGoodsss($checktime);
            foreach ($result as $result_k=>$result_v){
                foreach ($info as $info_k=>$info_v){
                    if(isset($result_v['purchase_info']['purchase_time'])){
                        if($info_v['purchase_time']==$result_v['purchase_info']['purchase_time']){
                            $info[$info_k]['av_basic_nmber'] = isset($result_v['purchase_info']['basic_nmber'])?$result_v['purchase_info']['basic_nmber']:0;
                            $info[$info_k]['av_all_money'] = isset($result_v['purchase_info']['all_money'])?$result_v['purchase_info']['all_money']:0;
                        }
                    }else{
                        $info[$info_k]['av_basic_nmber'] = 0;
                        $info[$info_k]['av_all_money'] = 0;
                    }
                }
            }
            $result = false;
            Db::startTrans();
            try {
                $result = Db::name('kuerp_checkout')->insertGetId($data);
                if(!empty($saleData)){
                    (new \app\admin\model\kuerp\GoodsSalesProfit())->allowField(true)->saveAll($saleData);
                }
                if(!empty($info)){
                    foreach($info as $info_k=>$info_v){
                        $info[$info_k]['checkout_id'] = $result;
                    }
                    Db::name('kuerp_checkout_info')->insertAll($info);
                }
                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            if($result){
                $this->success('结账成功');
            }else{
                $this->error('结账失败');
            }
        }
    }

    /**
     * 反结账
     */
    public function checkoutf()
    {
        if ($this->request->isPost()) {
            $lastdate = Db::name('kuerp_checkout')->order(['checktime'=>'DESC'])->value('id');
            if(empty($lastdate)){
                $this->error('请先结账');
            }
            $result = false;
            Db::startTrans();
            try {
                $result = $this->model->where(['id'=>$lastdate])->delete();
                Db::name('kuerp_checkout_info')->where(['checkout_id'=>$lastdate])->delete();
                Db::commit();
            } catch (Exception $e) {
                Db::rollback();
                $this->error($e->getMessage());
            }
            if($result){
                $this->success('反结账成功');
            }else{
                $this->error('反结账失败');
            }
        }
    }

    function checkOutGoods($start_time,$end_time){
        $sort = 'purchase_time';$order='ASC';
        $where = [];
        $where['purchase_time'] = ['BETWEEN',[$start_time+1,$end_time]];
        $lists = Db::name('kuerp_goods_sales_profit')
            ->where($where)
            ->order($sort, $order)
            ->select();

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

        $valuation_set= \think\Db::name('kuerp_sets')->where(['name'=>'valuation'])->value('value');//计算方法
        $stores_set= \think\Db::name('kuerp_sets')->where(['name'=>'stores'])->value('is_checked');//是否分仓
        if($valuation_set!=2){
            $valuation_set = 1;
        }
        if($stores_set!=1){
            $stores_set = 0;
        }

        $goods_info = [];
        foreach ($lists as $list_k=>$list_v){
            $cost_all = 0;$pay_money = 0;
            if($list_v['purchase_type']==1){
                $info = Db::name('kuerp_goods_sales_info')->where(['purchase_code'=>$list_v['purchase_code']])->field('pay_money,basic_nmber,goods_code,stores_id,purchase_time')->select();
                foreach ($info as $info_k=>$info_v){

                    if(!isset($goods_info[$info_v['goods_code']])){
                        $where = [];
                        $stores_ids = \think\Db::name('kuerp_stores')->where(['status'=>'1'])->column('id');
                        if($stores_set==1){
                            $where['stores_id'] = ['in',$stores_ids];
                        }else{
                            $where['stores_id'] = $info_v['stores_id'];
                        }
                        $where['goods_code'] = $info_v['goods_code'];

                        $checkdate = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checktime');
                        if(empty($checkdate)){
                            $enable_time = Db::name('kuerp_sets')->where(['name'=>'enable_time'])->value('value');
                            $start_time = strtotime($enable_time);

                            $end_time = strtotime(date('Y-m-d',$info_v['purchase_time']).' 23:59:59');
                            $wheretime['start_time'] = $start_time;
                            $wheretime['end_time'] = $end_time;
                            if(!empty($wheretime)){
                                $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                            }
                            if($valuation_set==1){
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)->group('purchase_time')
                                    ->field('purchase_time,sum(basic_nmber) as basic_nmber,sum(all_money) as all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                            }else{
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                    ->field('purchase_time,basic_nmber,all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                            }
                        }else{
                            $checkout_id = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('id');
                            $purchase_more = Db::name('kuerp_checkout_info')->where([
                                'checkout_id'=>$checkout_id,
                                'goods_code'=>$info_v['goods_code'],
                            ])->find();
                            $purchase_infos = Db::name('kuerp_goods_purchase')->where(['id'=>$purchase_more['purchase_id']])->find();

                            $start_time = $checkdate;
                            $end_time = strtotime(date('Y-m-d',$info_v['purchase_time']).' 23:59:59');
                            $wheretime['start_time'] = $start_time;
                            $wheretime['end_time'] = $end_time;
                            if(!empty($wheretime)){
                                $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                            }
                            if($valuation_set==1){
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)->group('purchase_time')
                                    ->field('purchase_time,sum(basic_nmber) as basic_nmber,sum(all_money) as all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                                if(!empty($purchase_more)){
                                    foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                        if($purchase_info_v['purchase_time']==$purchase_more['purchase_time']){
                                            $purchase_info[$purchase_info_k]['basic_nmber'] = (float)$purchase_more['av_basic_nmber'];
                                            $purchase_info[$purchase_info_k]['all_money'] = (float)$purchase_more['av_all_money'];
                                        }
                                    }
                                }
                            }else{
                                if(empty($purchase_more)){
                                    $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                        ->field('purchase_time,basic_nmber,all_money')
                                        ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                                }else{
                                    $where['purchase_code'] = ['>=',$purchase_infos['purchase_code']];
                                    $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                        ->field('id,purchase_time,basic_nmber,all_money')
                                        ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                                    foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                        if($purchase_info_v['id']==$purchase_more['purchase_id']){
                                            $purchase_info[$purchase_info_k]['basic_nmber'] = (float)$purchase_more['basic_nmber'];
                                            $purchase_info[$purchase_info_k]['all_money'] = (float)$purchase_more['all_money'];
                                        }
                                    }
                                }
                            }
                        }


                        $where = [];
                        $where['goods_code'] = $info_v['goods_code'];
                        $where['stores_id'] = ['in',$stores_ids];
                        if(!empty($wheretime)){
                            $where['createtime'] = ['between',[$wheretime['start_time'],time()]];
                        }
                        //期初
                        $period = Db::name('kuerp_goods_period')->where($where)->field('period as basic_nmber,price as all_money,createtime as purchase_time')->find();
                        if(!empty($period)){
                            $period['purchase_time'] = strtotime(date('Y-m-d',$period['purchase_time']));
                            if($valuation_set==1){
                                $status = true;
                                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                    if($purchase_info_v['purchase_time']==$period['purchase_time']){
                                        $status = false;
                                        $purchase_info[$purchase_info_k]['basic_nmber'] += $period['basic_nmber'];
                                        $purchase_info[$purchase_info_k]['all_money'] += $period['all_money'];
                                    }
                                }
                                if($status){
                                    $purchase_info[] = $period;
                                    $purchase_info = $this->arraySequence($purchase_info,'purchase_time','SORT_ASC');
                                }
                            }else{
                                $purchase_infos = [];
                                $purchase_infos[] = $period;
                                foreach ($purchase_info as $k=>$v){
                                    $purchase_infos[] = $v;
                                }
                                $purchase_info = $purchase_infos;
                            }
                        }

                        $goods = Db::name('kuerp_goods')->where(['goods_code'=>$info_v['goods_code']])->field('id,unit_id')->find();
                        if($goods){
                            $where = [];
                            $where['goods_id'] = $goods['id'];
                            $where['stores_id'] = ['in',$stores_ids];
                            if(!empty($wheretime)){
                                $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                            }
                            //成本调整
                            $adjustment_money = 0;
                            $adjustment = \think\Db::name('kuerp_adjustment_info')->where($where)->select();
                            foreach ($adjustment as $adjustment_k=>$adjustment_v){
                                $advance_rate = 1;//单位换算进率
                                if($adjustment_v['goods_unit']!=$goods['unit_id']){
                                    $unit = \think\Db::name('kuerp_unit_conversion')->where(['main_unit'=>$goods['unit_id'],'vice_unit'=>$adjustment_v['goods_unit']])->value('advance_rate');
                                    if(!empty($unit) && $unit>0){
                                        $advance_rate = $unit;
                                    }
                                }
                                $money = $adjustment_v['money']/$advance_rate;//换算后的调整成本
                                $adjustment[$adjustment_k]['purchase_time'] = strtotime(date('Y-m-d',$adjustment_v['purchase_time']));
                                $adjustment[$adjustment_k]['all_money'] = $adjustment_v['money'];
                            }
                            foreach ($adjustment as $adjustment_k=>$adjustment_v){
                                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                    if($purchase_info_v['purchase_time']==$adjustment_v['purchase_time']){
                                        $purchase_info[$purchase_info_k]['all_money'] += $adjustment_v['all_money'];
                                    }
                                }
                            }
                            //成本调整结束
                        }
                    }else{
                        $purchase_info = $goods_info[$info_v['goods_code']];
                    }

                    $cost = (new Goods())->getCost_Price($info_v['goods_code'],'',$info_v['basic_nmber'],$purchase_info);

                    if(isset($cost['purchase_info'])){
                        $goods_info[$info_v['goods_code']] = $cost['purchase_info'];
                        $purchase_info = $goods_info[$info_v['goods_code']];
                        $cost = $cost['cost'];
                    }
                    $cost_all += $cost*$info_v['basic_nmber'];
                    $pay_money += $info_v['pay_money'];
                }
            }
            $lists[$list_k]['pay_money'] = $pay_money;
            $lists[$list_k]['sales_cost'] = round($cost_all,$price_decimal);
            $lists[$list_k]['profit'] = round($list_v['all_money']-$cost_all,$price_decimal);
            if($list_v['all_money']>0){
                $lists[$list_k]['profit_rate'] = round($lists[$list_k]['profit']/$list_v['all_money']*100,2);
            }else{
                $lists[$list_k]['profit_rate'] = 0;
            }
            $lists[$list_k]['net_profit'] = round($lists[$list_k]['profit']-$list_v['preferential_money']-$list_v['purchase_money'],$price_decimal);
            if($list_v['all_money']>0){
                $lists[$list_k]['net_profit_rate'] = round($lists[$list_k]['net_profit']/$list_v['all_money']*100,2);
            }else{
                $lists[$list_k]['net_profit_rate'] = 0;
            }
        }
        return $lists;
    }

    function checkOutGoodss($end_time){
        $stores_set= Db::name('kuerp_sets')->where(['name'=>'stores'])->value('is_checked');//是否分仓
        $valuation_set = 2;
        if($stores_set!=1){
            $stores_set = 0;
        }

        $checkdate = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checkdate');
        if(empty($checkdate)){
            $enable_time = Db::name('kuerp_sets')->where(['name'=>'enable_time'])->value('value');
            $start_time = strtotime($enable_time);
        }else{
            $start_time = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checktime');
            $start_time+=1;
        }

        $goods = Db::name('kuerp_goods')->where(['status'=>'1'])->field('id,goods_code,inventory,unit_id')->select();
        $sort = 'purchase_time';$order='ASC';
        foreach ($goods as $goods_k=>$goods_v){
            $goods[$goods_k]['sales_cost'] = 0;
            $goods[$goods_k]['basic_nmber'] = 0;
            $purchase = Db::name('kuerp_goods_purchase_info')->where(['goods_code'=>$goods_v['goods_code'],'purchase_time'=>['BETWEEN',[$start_time,$end_time]]])
                ->field('sum(all_money) as all_money,sum(basic_nmber) as basic_nmber')->find();
            $goods[$goods_k]['all_money'] = (float)$purchase['all_money'];
            $goods[$goods_k]['purchase_basic_nmber'] = (float)$purchase['basic_nmber'];

            $goods_info = [];
            $info = Db::name('kuerp_goods_sales_info')->where(['goods_code'=>$goods_v['goods_code'],'purchase_time'=>['BETWEEN',[$start_time,$end_time]]])
                ->order($sort, $order)
                ->field('pay_money,basic_nmber,goods_code,stores_id,purchase_time')->select();

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

                if(!isset($goods_info[$info_v['goods_code']])){
                    $where = [];
                    $stores_ids = \think\Db::name('kuerp_stores')->where(['status'=>'1'])->column('id');
                    if($stores_set==1){
                        $where['stores_id'] = ['in',$stores_ids];
                    }else{
                        $where['stores_id'] = $info_v['stores_id'];
                    }
                    $where['goods_code'] = $info_v['goods_code'];

                    $checkdate = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checktime');
                    if(empty($checkdate)){
                        $end_time = strtotime(date('Y-m-d',$info_v['purchase_time']).' 23:59:59');
                        $wheretime['start_time'] = $start_time;
                        $wheretime['end_time'] = $end_time;
                        if(!empty($wheretime)){
                            $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                        }
                        if($valuation_set==1){
                            $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)->group('purchase_time')
                                ->field('purchase_time,sum(basic_nmber) as basic_nmber,sum(all_money) as all_money')
                                ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                        }else{
                            $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                ->field('purchase_time,basic_nmber,all_money')
                                ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                        }
                    }else{
                        $checkout_id = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('id');
                        $purchase_more = Db::name('kuerp_checkout_info')->where([
                            'checkout_id'=>$checkout_id,
                            'goods_code'=>$info_v['goods_code'],
                        ])->find();
                        $purchase_infos = Db::name('kuerp_goods_purchase')->where(['id'=>$purchase_more['purchase_id']])->find();

                        $start_time = $checkdate;
                        $end_time = strtotime(date('Y-m-d',$info_v['purchase_time']).' 23:59:59');
                        $wheretime['start_time'] = $start_time;
                        $wheretime['end_time'] = $end_time;
                        if(!empty($wheretime)){
                            $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                        }
                        if($valuation_set==1){
                            $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)->group('purchase_time')
                                ->field('purchase_time,sum(basic_nmber) as basic_nmber,sum(all_money) as all_money')
                                ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                            if(!empty($purchase_more)){
                                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                    if($purchase_info_v['purchase_time']==$purchase_more['purchase_time']){
                                        $purchase_info[$purchase_info_k]['basic_nmber'] = (float)$purchase_more['av_basic_nmber'];
                                        $purchase_info[$purchase_info_k]['all_money'] = (float)$purchase_more['av_all_money'];
                                    }
                                }
                            }
                        }else{
                            if(empty($purchase_more)){
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                    ->field('purchase_time,basic_nmber,all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                            }else{
                                $where['purchase_code'] = ['>=',$purchase_infos['purchase_code']];
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                    ->field('id,purchase_time,basic_nmber,all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                    if($purchase_info_v['id']==$purchase_more['purchase_id']){
                                        $purchase_info[$purchase_info_k]['basic_nmber'] = (float)$purchase_more['basic_nmber'];
                                        $purchase_info[$purchase_info_k]['all_money'] = (float)$purchase_more['all_money'];
                                    }
                                }
                            }
                        }
                    }


                    $where = [];
                    $where['goods_code'] = $info_v['goods_code'];
                    $where['stores_id'] = ['in',$stores_ids];
                    if(!empty($wheretime)){
                        $where['createtime'] = ['between',[$wheretime['start_time'],time()]];
                    }
                    //期初
                    $period = Db::name('kuerp_goods_period')->where($where)->field('period as basic_nmber,price as all_money,createtime as purchase_time')->find();
                    if(!empty($period)){
                        $period['purchase_time'] = strtotime(date('Y-m-d',$period['purchase_time']));
                        if($valuation_set==1){
                            $status = true;
                            foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                if($purchase_info_v['purchase_time']==$period['purchase_time']){
                                    $status = false;
                                    $purchase_info[$purchase_info_k]['basic_nmber'] += $period['basic_nmber'];
                                    $purchase_info[$purchase_info_k]['all_money'] += $period['all_money'];
                                }
                            }
                            if($status){
                                $purchase_info[] = $period;
                                $purchase_info = $this->arraySequence($purchase_info,'purchase_time','SORT_ASC');
                            }
                        }else{
                            $purchase_infos = [];
                            $purchase_infos[] = $period;
                            foreach ($purchase_info as $k=>$v){
                                $purchase_infos[] = $v;
                            }
                            $purchase_info = $purchase_infos;
                        }
                    }

                    $where = [];
                    $where['goods_id'] = $goods_v['id'];
                    $where['stores_id'] = ['in',$stores_ids];
                    if(!empty($wheretime)){
                        $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                    }
                    //成本调整
                    $adjustment_money = 0;
                    $adjustment = \think\Db::name('kuerp_adjustment_info')->where($where)->select();
                    foreach ($adjustment as $adjustment_k=>$adjustment_v){
                        $advance_rate = 1;//单位换算进率
                        if($adjustment_v['goods_unit']!=$goods_v['unit_id']){
                            $unit = \think\Db::name('kuerp_unit_conversion')->where(['main_unit'=>$goods_v['unit_id'],'vice_unit'=>$adjustment_v['goods_unit']])->value('advance_rate');
                            if(!empty($unit) && $unit>0){
                                $advance_rate = $unit;
                            }
                        }
                        $money = $adjustment_v['money']/$advance_rate;//换算后的调整成本
                        $adjustment[$adjustment_k]['purchase_time'] = strtotime(date('Y-m-d',$adjustment_v['purchase_time']));
                        $adjustment[$adjustment_k]['all_money'] = $adjustment_v['money'];
                    }
                    foreach ($adjustment as $adjustment_k=>$adjustment_v){
                        foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                            if($purchase_info_v['purchase_time']==$adjustment_v['purchase_time']){
                                $purchase_info[$purchase_info_k]['all_money'] += $adjustment_v['all_money'];
                            }
                        }
                    }
                    //成本调整结束
                }else{
                    $purchase_info = $goods_info[$info_v['goods_code']];
                }

                $cost = (new Goods())->getCost_Price($info_v['goods_code'],'',$info_v['basic_nmber'],$purchase_info);

                if(isset($cost['purchase_info'])){
                    $goods_info[$info_v['goods_code']] = $cost['purchase_info'];
                    $purchase_info = $goods_info[$info_v['goods_code']];
                    $cost = $cost['cost'];
                }
                $cost_all = $cost*$info_v['basic_nmber'];
                $goods[$goods_k]['sales_cost'] += $cost_all;
                $goods[$goods_k]['basic_nmber'] += $info_v['basic_nmber'];
            }

            if(isset($purchase_info)){
                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                    if($purchase_info_v['basic_nmber']>0){
                        $goods[$goods_k]['purchase_info'] = $purchase_info_v;
                        break;
                    }
                }
            }
        }
        return $goods;
    }

    function checkOutGoodsss($end_time){
        $stores_set= Db::name('kuerp_sets')->where(['name'=>'stores'])->value('is_checked');//是否分仓
        $valuation_set = 1;
        if($stores_set!=1){
            $stores_set = 0;
        }

        $checkdate = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checkdate');
        if(empty($checkdate)){
            $enable_time = Db::name('kuerp_sets')->where(['name'=>'enable_time'])->value('value');
            $start_time = strtotime($enable_time);
        }else{
            $start_time = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checktime');
            $start_time+=1;
        }

        $goods = Db::name('kuerp_goods')->where(['status'=>'1'])->field('id,goods_code,inventory,unit_id')->select();
        $sort = 'purchase_time';$order='ASC';
        foreach ($goods as $goods_k=>$goods_v){
            $goods[$goods_k]['sales_cost'] = 0;
            $goods[$goods_k]['basic_nmber'] = 0;
            $purchase = Db::name('kuerp_goods_purchase_info')->where(['goods_code'=>$goods_v['goods_code'],'purchase_time'=>['BETWEEN',[$start_time,$end_time]]])
                ->field('sum(all_money) as all_money,sum(basic_nmber) as basic_nmber')->find();
            $goods[$goods_k]['all_money'] = (float)$purchase['all_money'];
            $goods[$goods_k]['purchase_basic_nmber'] = (float)$purchase['basic_nmber'];

            $goods_info = [];
            $info = Db::name('kuerp_goods_sales_info')->where(['goods_code'=>$goods_v['goods_code'],'purchase_time'=>['BETWEEN',[$start_time,$end_time]]])
                ->order($sort, $order)
                ->field('pay_money,basic_nmber,goods_code,stores_id,purchase_time')->select();

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

                if(!isset($goods_info[$info_v['goods_code']])){
                    $where = [];
                    $stores_ids = \think\Db::name('kuerp_stores')->where(['status'=>'1'])->column('id');
                    if($stores_set==1){
                        $where['stores_id'] = ['in',$stores_ids];
                    }else{
                        $where['stores_id'] = $info_v['stores_id'];
                    }
                    $where['goods_code'] = $info_v['goods_code'];

                    $checkdate = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('checktime');
                    if(empty($checkdate)){
                        $end_time = strtotime(date('Y-m-d',$info_v['purchase_time']).' 23:59:59');
                        $wheretime['start_time'] = $start_time;
                        $wheretime['end_time'] = $end_time;
                        if(!empty($wheretime)){
                            $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                        }
                        if($valuation_set==1){
                            $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)->group('purchase_time')
                                ->field('purchase_time,sum(basic_nmber) as basic_nmber,sum(all_money) as all_money')
                                ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                        }else{
                            $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                ->field('purchase_time,basic_nmber,all_money')
                                ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                        }
                    }else{
                        $checkout_id = Db::name('kuerp_checkout')->order(['checkdate'=>'DESC'])->value('id');
                        $purchase_more = Db::name('kuerp_checkout_info')->where([
                            'checkout_id'=>$checkout_id,
                            'goods_code'=>$info_v['goods_code'],
                        ])->find();
                        $purchase_infos = Db::name('kuerp_goods_purchase')->where(['id'=>$purchase_more['purchase_id']])->find();

                        $start_time = $checkdate;
                        $end_time = strtotime(date('Y-m-d',$info_v['purchase_time']).' 23:59:59');
                        $wheretime['start_time'] = $start_time;
                        $wheretime['end_time'] = $end_time;
                        if(!empty($wheretime)){
                            $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                        }
                        if($valuation_set==1){
                            $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)->group('purchase_time')
                                ->field('purchase_time,sum(basic_nmber) as basic_nmber,sum(all_money) as all_money')
                                ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                            if(!empty($purchase_more)){
                                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                    if($purchase_info_v['purchase_time']==$purchase_more['purchase_time']){
                                        $purchase_info[$purchase_info_k]['basic_nmber'] = (float)$purchase_more['av_basic_nmber'];
                                        $purchase_info[$purchase_info_k]['all_money'] = (float)$purchase_more['av_all_money'];
                                    }
                                }
                            }
                        }else{
                            if(empty($purchase_more)){
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                    ->field('purchase_time,basic_nmber,all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                            }else{
                                $where['purchase_code'] = ['>=',$purchase_infos['purchase_code']];
                                $purchase_info = Db::name('kuerp_goods_purchase_info')->where($where)
                                    ->field('id,purchase_time,basic_nmber,all_money')
                                    ->order(['purchase_time'=>'ASC','purchase_code'=>'ASC'])->select();
                                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                    if($purchase_info_v['id']==$purchase_more['purchase_id']){
                                        $purchase_info[$purchase_info_k]['basic_nmber'] = (float)$purchase_more['basic_nmber'];
                                        $purchase_info[$purchase_info_k]['all_money'] = (float)$purchase_more['all_money'];
                                    }
                                }
                            }
                        }
                    }


                    $where = [];
                    $where['goods_code'] = $info_v['goods_code'];
                    $where['stores_id'] = ['in',$stores_ids];
                    if(!empty($wheretime)){
                        $where['createtime'] = ['between',[$wheretime['start_time'],time()]];
                    }
                    //期初
                    $period = Db::name('kuerp_goods_period')->where($where)->field('period as basic_nmber,price as all_money,createtime as purchase_time')->find();
                    if(!empty($period)){
                        $period['purchase_time'] = strtotime(date('Y-m-d',$period['purchase_time']));
                        if($valuation_set==1){
                            $status = true;
                            foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                                if($purchase_info_v['purchase_time']==$period['purchase_time']){
                                    $status = false;
                                    $purchase_info[$purchase_info_k]['basic_nmber'] += $period['basic_nmber'];
                                    $purchase_info[$purchase_info_k]['all_money'] += $period['all_money'];
                                }
                            }
                            if($status){
                                $purchase_info[] = $period;
                                $purchase_info = $this->arraySequence($purchase_info,'purchase_time','SORT_ASC');
                            }
                        }else{
                            $purchase_infos = [];
                            $purchase_infos[] = $period;
                            foreach ($purchase_info as $k=>$v){
                                $purchase_infos[] = $v;
                            }
                            $purchase_info = $purchase_infos;
                        }
                    }

                    $where = [];
                    $where['goods_id'] = $goods_v['id'];
                    $where['stores_id'] = ['in',$stores_ids];
                    if(!empty($wheretime)){
                        $where['purchase_time'] = ['between',[$wheretime['start_time'],time()]];
                    }
                    //成本调整
                    $adjustment_money = 0;
                    $adjustment = \think\Db::name('kuerp_adjustment_info')->where($where)->select();
                    foreach ($adjustment as $adjustment_k=>$adjustment_v){
                        $advance_rate = 1;//单位换算进率
                        if($adjustment_v['goods_unit']!=$goods_v['unit_id']){
                            $unit = \think\Db::name('kuerp_unit_conversion')->where(['main_unit'=>$goods_v['unit_id'],'vice_unit'=>$adjustment_v['goods_unit']])->value('advance_rate');
                            if(!empty($unit) && $unit>0){
                                $advance_rate = $unit;
                            }
                        }
                        $money = $adjustment_v['money']/$advance_rate;//换算后的调整成本
                        $adjustment[$adjustment_k]['purchase_time'] = strtotime(date('Y-m-d',$adjustment_v['purchase_time']));
                        $adjustment[$adjustment_k]['all_money'] = $adjustment_v['money'];
                    }
                    foreach ($adjustment as $adjustment_k=>$adjustment_v){
                        foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                            if($purchase_info_v['purchase_time']==$adjustment_v['purchase_time']){
                                $purchase_info[$purchase_info_k]['all_money'] += $adjustment_v['all_money'];
                            }
                        }
                    }
                    //成本调整结束
                }else{
                    $purchase_info = $goods_info[$info_v['goods_code']];
                }

                $cost = (new Goods())->getCost_Price($info_v['goods_code'],'',$info_v['basic_nmber'],$purchase_info);

                if(isset($cost['purchase_info'])){
                    $goods_info[$info_v['goods_code']] = $cost['purchase_info'];
                    $purchase_info = $goods_info[$info_v['goods_code']];
                    $cost = $cost['cost'];
                }
                $cost_all = $cost*$info_v['basic_nmber'];
                $goods[$goods_k]['sales_cost'] += $cost_all;
                $goods[$goods_k]['basic_nmber'] += $info_v['basic_nmber'];
            }

            if(isset($purchase_info)){
                foreach ($purchase_info as $purchase_info_k=>$purchase_info_v){
                    if($purchase_info_v['basic_nmber']>0){
                        $goods[$goods_k]['purchase_info'] = $purchase_info_v;
                        break;
                    }
                }
            }
        }
        return $goods;
    }

    /**
     * 二维数组根据字段进行排序
     * @params array $array 需要排序的数组
     * @params string $field 排序的字段
     * @params string $sort 排序顺序标志 SORT_DESC 降序;SORT_ASC 升序
     */
    function arraySequence($array, $field, $sort)
    {
        if(sizeof($array)<2){
            return $array;
        }
        $arrSort = array();
        foreach ($array as $uniqid => $row) {
            foreach ($row as $key => $value) {
                $arrSort[$key][$uniqid] = $value;
            }
        }
        array_multisort($arrSort[$field], constant($sort), $array);
        return $array;
    }

    function checkOutTime($time){
        $checktime = Db::name('kuerp_checkout')->order(['checktime'=>'DESC'])->value('checktime');
        $checkdate = Db::name('kuerp_checkout')->order(['checktime'=>'DESC'])->value('checkdate');
        if(strpos($time,' - ') !== false){
            $time = strtotime($time);
        }
        if(strpos($time,'-') !== false){
            $time = strtotime($time);
        }
        if($time<=$checktime){
            $this->error('不可操作小于结账日期'.$checkdate.'的数据');
        }
    }
}