t_nine/app/Service/PurchaseOrderSpecialService.php

<?php

namespace App\Service;

use App\Model\BasicType;
use App\Model\BookingList;
use App\Model\Depart;
use App\Model\Employee;
use App\Model\PaymentReceipt;
use App\Model\PurchaseOrder;
use App\Model\PurchaseOrderFile;
use App\Model\PurchaseOrderInfo;
use App\Model\PurchaseOrderSpecial;
use App\Model\PurchaseOrderSpecialInfo;
use App\Model\ReturnExchangeOrder;
use App\Model\SalesOrder;
use App\Model\SeeRange;
use App\Model\Storehouse;
use App\Model\Supplier;
use Illuminate\Support\Facades\DB;

/**
 * 采购单
 */
class PurchaseOrderSpecialService extends Service
{
    /**
     * 采购单编辑
     * @param $data
     * @param $user
     * @return array
     */
    public function edit($data,$user){
        list($status,$msg) = $this->orderRule($data,$user, false);
        if(!$status) return [$status,$msg];

        try{
            DB::beginTransaction();
            $material_model = PurchaseOrderSpecial::where('order_number',$data['order_number'])->first();
            $material_model->order_number = $data['order_number'];
            $material_model->other_fee = $data['other_fee'] ?? 0;
            $material_model->mark = $data['mark'] ?? '';
            $material_model->save();

            DB::commit();
        }catch (\Throwable $e){
            DB::rollBack();
            return [false,$e->getMessage()];
        }

        return [true,''];
    }

    /**
     * 采购单新增
     * @param $data
     * @param $user
     * @return array
     */
    public function add($data,$user){
        list($status,$msg) = $this->orderRule($data, $user);
        if(!$status) return [$status,$msg];
        try{
            DB::beginTransaction();
            $material_model = new PurchaseOrder();
            $material_model->order_number = $data['order_number'];
            $material_model->depart_id = $data['depart_id'] ?? 0;
            $material_model->top_depart_id = $data['top_depart_id'] ?? 0;
            $material_model->total = $data['total'] ?? 0;
            $material_model->other_fee = $data['other_fee'] ?? 0;
            $material_model->discount_fee = $data['discount_fee'] ?? 0;
            $material_model->purchase_total = $data['purchase_total'] ?? 0;
            $material_model->supplier = $data['supplier'] ?? 0;
            $material_model->purchase_id = $data['purchase_id'] ?? 0;
            $material_model->order_type = $data['order_type'];
            $material_model->sales_order_id = $data['sales_order_id'] ?? 0;
            $material_model->mark = $data['mark'] ?? '';
            $material_model->crt_id = $user['id'];
            $material_model->storehouse_id = $data['storehouse_id'];
            $material_model->save();

            $time = time();
            if(!empty($data['product'])){
                $sub = [];
                foreach ($data['product'] as $value){
                    $sub[] = [
                        'purchase_order_id' => $material_model->id,
                        'order_number' => $data['order_number'],
                        'storehouse_id' => $data['storehouse_id'] ?? 0,
                        'product_id' => $value['product_id'],
                        'number' => $value['number'],
                        'basic_type_id' => $value['basic_type_id'],
                        'price' => $value['price'],
                        'mark' => $value['mark'] ?? '',
                    ];
                }
                PurchaseOrderInfo::insert($sub);
            }

            if(! empty($data['file'])){
                $insert = [];
                foreach ($data['file'] as $value){
                    $insert[] = [
                        'purchase_order_id' => $material_model->id,
                        'order_number' => $data['order_number'],
                        'file' => $value['url'],
                        'type' => PurchaseOrderFile::type_one,
                        'name' => $value['name'],
                        'crt_time' => $time,
                    ];
                }
                PurchaseOrderFile::insert($insert);
            }

            DB::commit();
        }catch (\Throwable $e){
            DB::rollBack();
            return [false,$e->getMessage()];
        }

        return [true,''];
    }

    /**
     * 采购单详情
     * @param $data
     * @return array
     */
    public function detail($data,$user){
        if($this->isEmpty($data,'order_number')) return [false,'请选择数据'];

        $order = PurchaseOrderSpecial::where('order_number',$data['order_number'])
            ->where('del_time',0)
            ->select('id','order_number','depart_id','mark','state','crt_id','sales_order_id','supplier','purchase_id','purchase_total','crt_time','storehouse_id','top_depart_id','total','other_fee','type')
            ->first();
        if(empty($order)) return [false, '虚拟采购单不存在或已被删除'];
        $order = $order->toArray();
        $order['file'] = [];
        $order['storehouse_title'] = Storehouse::where('id',$order['storehouse_id'])->value('title');
        $supplier = Depart::where('id',$order['supplier'])->first();
        $order['supplier_title'] = $supplier->title ?? '';
        $order['state_title'] = PurchaseOrderSpecial::$name[$order['state']] ?? '';
        $order['type_title'] = PurchaseOrderSpecial::$type[$order['type']] ?? '';
        $sales_order_number = SalesOrder::where('id',$order['sales_order_id'])->value('order_number');
        $order['sales_order_number'] = $sales_order_number;
        $emp_map = Employee::whereIn('id',array_unique(array_merge_recursive([$order['purchase_id']],[$order['crt_id']])))
            ->pluck('emp_name','id')
            ->toArray();
        $order['purchase_title'] = $emp_map[$order['purchase_id']] ?? '';

        $p_info = PurchaseOrderSpecialInfo::where('del_time',0)
            ->where('order_number',$data['order_number'])
            ->get()->toArray();
        $basic_price = BasicType::whereIn('id',array_unique(array_column($p_info,'basic_type_id')))->pluck('title','id')->toArray();
        $map = (new ProductService())->getProductDetail(array_column($p_info,'product_id'));
        foreach ($p_info as $value){
            $tmp = $map[$value['product_id']] ?? [];
            $value['title'] = $tmp['title'] ?? "";
            $value['code'] = $tmp['code'] ?? "";
            $value['size'] = $tmp['size'] ?? "";
            $value['unit'] = $tmp['unit'] ?? "";
            $value['bar_code'] = $tmp['bar_code'] ?? "";
            $value['basic_type_title'] = $basic_price[$value['basic_type_id']] ?? "";
            $order['product'][] = $value;
        }

        $order['crt_name'] = $emp_map[$order['crt_id']] ?? '';
        $order['crt_time'] = $order['crt_time'] ? date("Y-m-d H:i:s",$order['crt_time']): '';

        //退换货信息
        $order['return_exchange'] = (new ReturnExchangeOrderService())->getDifferentAmount($order['sales_order_id']);
        $order['return_exchange_amount'] = 0;
        foreach ($order['return_exchange'] as $value){
            if($value['state'] == ReturnExchangeOrder::State_two)  $order['return_exchange_amount'] += $value['difference_amount'];
        }

        //回款单信息 审核过的
        $sales['order_number'] = $order['sales_order_number'];
        $order['payment_receipt_list'] = (new PaymentReceiptService())->getPaymentReceiptDataList($sales, PaymentReceipt::data_type_one);
        //坏账金额 = 已审核退货退款金额 - 红冲金额
        $order['payment_receipt_list']['bad_amount'] = bcsub($order['return_exchange_amount'], $order['payment_receipt_list']['red_amount'],2);
        //未回款金额 = 总金额 - 已回款金额 - 坏账金额 - 红冲
        $total = bcadd($order['purchase_total'],$order['other_fee'],2);
        $order['payment_receipt_list']['not_receipt_amount'] = bcsub(bcsub(bcsub($total, $order['payment_receipt_list']['receipt_amount'],2), $order['payment_receipt_list']['bad_amount'], 2),$order['payment_receipt_list']['red_amount'],2);
        //回款单信息 审核过的

        $order['not_payment_receipt_amount'] = bcsub($total,$order['payment_receipt_list']['not_confirm_receipt_amount'],2);


        return [true, $order];
    }

    /**
     * 采购单删除
     * @param $data
     * @return array
     */
    public function del($data){
        if($this->isEmpty($data,'order_number')) return [false,'请选择数据！'];
        $order = PurchaseOrderSpecial::where('del_time',0)->where('order_number',$data['order_number'])->first();
        if(empty($order)) return [false,'虚拟采购单不存在或已被删除'];
        $order = $order->toArray();
        if($order['state'] > PurchaseOrderSpecial::STATE_ZERO) return [false,'请确认虚拟采购单状态,删除失败！'];

        try{
            DB::beginTransaction();
            PurchaseOrderSpecial::where('order_number',$data['order_number'])->where('del_time',0)->update([
                'del_time'=>time()
            ]);
            PurchaseOrderSpecialInfo::where('order_number',$data['order_number'])->where('del_time',0)->update([
                'del_time'=>time()
            ]);

            DB::commit();
        }catch (\Throwable $e){
            DB::rollBack();
            return [false,$e->getMessage()];
        }

        return [true,''];
    }

    /**
     * 获取采购单列表
     * @param $data
     * @param $user
     * @return array
     */
    public function getList($data,$user){
        $model = PurchaseOrderSpecial::Clear($user,$data);
        $model = $model->where('del_time',0)->select('order_number','id','depart_id','top_depart_id','mark','crt_time','state','crt_id','sales_order_id','supplier','purchase_id','purchase_total','storehouse_id','total','other_fee','type')
            ->orderby('id', 'desc');
        if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
        if(isset($data['state'])) $model->where('state',$data['state']);
        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->whereBetween('crt_time',[$return[0],$return[1]]);
        }
        if(! empty($data['time_type'])) {
            if($data['time_type'] == 1) {
                $start = strtotime('today');
                $end = strtotime('tomorrow') - 1;
            }elseif ($data['time_type'] == 2){
                $start = strtotime('this week',strtotime('today'));
                $end = strtotime('this week +6 days 23:59:59', strtotime('today'));
            }
            if(! empty($start) && ! empty($end)) {
                $model->where('crt_time','>=',$start);
                $model->where('crt_time','<=',$end);
            }
        }
        if(! empty($data['supplier_title'])) {
            $id = Depart::where('del_time',0)
                ->where('parent_id',0)
                ->where('title', 'LIKE', '%'.$data['supplier_title'].'%')
                ->select('id')->get()->toArray();
            $model->whereIn('supplier',array_column($id,'id'));
        }

        $list = $this->limit($model,'',$data);
        $list = $this->fillListData($list,$data,$user);

        return [true, $list];
    }

    /**
     * 拼接数据
     * @param $data
     * @return array
     */
    public function fillListData($data,$ergs,$user){
        if(empty($data['data'])) return $data;

        $emp_id = array_unique(array_merge_recursive(array_column($data['data'],'crt_id'),array_column($data['data'],'purchase_id')));
        $emp_map = Employee::whereIn('id',$emp_id)
                    ->pluck('emp_name','id')
                    ->toArray();

        $sales = SalesOrder::whereIn('id',array_unique(array_column($data['data'],'sales_order_id')))->pluck('order_number','id')->toArray();
        $supplier = Depart::whereIn('id',array_unique(array_column($data['data'],'supplier')))
            ->pluck('title','id')
            ->toArray();

        list($for_amount_list, $for_amount_list1) = (new PaymentReceiptService())->getPaymentReceiptDataCountList(array_column($data['data'],'order_number'));
        list($getDifferentAmountALL,$getDifferentAmountALL1) = (new ReturnExchangeOrderService())->getDifferentAmountALLNew(array_column($data['data'],'sales_order_id'));

        foreach ($data['data'] as $key => $value){
            $data['data'][$key]['crt_time'] = $value['crt_time'] ? date("Y-m-d H:i:s",$value['crt_time']) : '';
            $data['data'][$key]['crt_name'] = $emp_map[$value['crt_id']] ?? '';
            $data['data'][$key]['purchase_name'] = $emp_map[$value['purchase_id']] ?? '';
            $data['data'][$key]['state_title'] = PurchaseOrderSpecial::$name[$value['state']] ?? '';
            $data['data'][$key]['sales_order_number'] = $sales[$value['sales_order_id']] ?? '';
            $data['data'][$key]['supplier_title'] = $supplier[$value['supplier']] ?? '';
            $data['data'][$key]['type_title'] = PurchaseOrderSpecial::$type[$value['type']] ?? "";

            //用于计算--------
            //已收（审核后）
            $one1 = $for_amount_list1[$value['order_number'] . PaymentReceipt::type_one] ?? 0;
            $data['data'][$key]['checked_payment_receipt_amount'] = $one1;
            //已收
            $one = $for_amount_list[$value['order_number'] . PaymentReceipt::type_one] ?? 0;
            $data['data'][$key]['payment_receipt_amount'] = $one;
            //已红冲
            $three = $for_amount_list[$value['order_number'] . PaymentReceipt::type_three] ?? 0;
            $data['data'][$key]['red_amount'] = $three;
            //已退货退款
            $return_exchange_amount = $getDifferentAmountALL[$value['sales_order_id']] ?? 0;
            $data['data'][$key]['return_exchange_amount'] = $return_exchange_amount;
            //用于计算--------

            //用于统计--------
            $red = $for_amount_list1[$value['order_number'] . PaymentReceipt::type_three] ?? 0;
            $return_exchange_amount1 = $getDifferentAmountALL1[$value['sales_order_id']] ?? 0;
            $bad = bcsub($return_exchange_amount1 ,$red,2);
            //已收金额
            $fee1 = bcsub($one1 ,$red,2);
            $data['data'][$key]['fee1'] = $fee1;
            //未收金额
            $total = bcadd($value['purchase_total'],$value['other_fee'],2);
            $fee2 = bcsub(bcsub($total, $bad, 2),$red,2);
            $data['data'][$key]['fee2'] = $fee2;
            //红冲金额
            $data['data'][$key]['fee3'] = $red;
            //坏账金额
            $data['data'][$key]['fee4'] = $bad;
            //用于统计--------
        }

        return $data;
    }

    /**
     * 采购单参数规则
     * @param $data
     * @param $is_check
     * @return array
     */
    public function orderRule(&$data, $user, $is_check = true){
        if(! isset($data['mark']) && ! isset($data['other_fee'])) return [false, '请填写更新的内容'];
        if(isset($data['other_fee']) && ! is_numeric($data['other_fee'])) return [false, '其他费用请填写正确的数值'];

        //所属部门 以及 顶级部门
        if(empty($data['depart_id'])) $data['depart_id'] = $this->getDepart($user);
        $data['top_depart_id'] = $user['depart_map'][$data['depart_id']] ?? 0;

        if($is_check){
            $order_number = (new OrderNoService())->createOrderNumber(PurchaseOrderSpecial::prefix);
            if(empty($order_number)) return [false,'虚拟采购单号生成失败！'];
            $data['order_number'] = $order_number;
        }else{
            if($this->isEmpty($data,'order_number')) return [false,'虚拟采购单号不能为空！'];
            $purchase = PurchaseOrderSpecial::where('del_time',0)->where('order_number',$data['order_number'])->first();
            if(empty($purchase)) return [false, '虚拟采购单不存在或已被删除'];
            if($purchase->state > PurchaseOrderSpecial::STATE_ZERO) return [false,'请确认虚拟采购单单据状态，修改失败'];
        }

        return [true, ''];
    }
}