<?php

namespace App\Service;

use App\Model\Depart;
use App\Model\Employee;
use App\Model\InvoiceOrder;
use App\Model\InvoiceOrderInfo;
use App\Model\SalesOrder;
use Illuminate\Support\Facades\DB;

class InvoiceOrderService extends Service
{
    public function edit($data,$user){
        list($status,$msg) = $this->orderRule($data,false);
        if(!$status) return [$status,$msg];

        try{
            DB::beginTransaction();
            $material_model = InvoiceOrder::where('order_number',$data['order_number'])->first();
            $material_model->sales_order_id = $data['sales_order_id'];
            $material_model->send = $data['send'];
            $material_model->send_time = $data['send_time'];
            $material_model->take = $data['take'];
            $material_model->take_address = $data['take_address'];
            $material_model->take_phone = $data['take_phone'];
            $material_model->logistics_company = $data['logistics_company'];
            $material_model->logistics_number = $data['logistics_number'];
            $material_model->depart_id = $data['depart_id'] ?? 0;
            $material_model->mark = $data['mark'];
            $material_model->save();

            InvoiceOrderInfo::where('order_number',$data['order_number'])
                ->where('del_time',0)
                ->update(['del_time' => time()]);
            if(!empty($data['product'])){
                $sub = [];
                foreach ($data['product'] as $value){
                    $sub[] = [
                        'invoice_id' => $material_model->id,
                        'order_number' => $data['order_number'],
                        'depart_id' => $data['depart_id'] ?? 0,
                        'product_id' => $value['product_id'],
                        'number' => $value['number'],
                        'mark' => $value['mark'] ?? '',
                        'title' => $value['title'] ?? '',
                        'code' => $value['code'] ?? '',
                        'size' => $value['size'] ?? '',
                        'unit' => $value['unit'] ?? 0,
                        'bar_code' => $value['bar_code'] ?? '',
                    ];
                }
                InvoiceOrderInfo::insert($sub);

                //锁定库存
                ProductInventoryService::changeLockNumber($msg[0],$msg[1]);
            }

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

        return [true,''];
    }

    public function add($data,$user){
        list($status,$msg) = $this->orderRule($data);
        if(!$status) return [$status,$msg];

        try{
            DB::beginTransaction();
            $material_model = new InvoiceOrder();
            $material_model->order_number = $data['order_number'];
            $material_model->sales_order_id = $data['sales_order_id'];
            $material_model->send = $data['send'];
            $material_model->send_time = $data['send_time'];
            $material_model->take = $data['take'];
            $material_model->take_address = $data['take_address'];
            $material_model->take_phone = $data['take_phone'];
            $material_model->logistics_company = $data['logistics_company'];
            $material_model->logistics_number = $data['logistics_number'];
            $material_model->depart_id = $data['depart_id'] ?? 0;
            $material_model->mark = $data['mark'];
            $material_model->crt_id = $user['id'];
            $material_model->save();

            if(!empty($data['product'])){
                $sub = [];
                foreach ($data['product'] as $value){
                    $sub[] = [
                        'invoice_id' => $material_model->id,
                        'order_number' => $data['order_number'],
                        'depart_id' => $data['depart_id'] ?? 0,
                        'product_id' => $value['product_id'],
                        'number' => $value['number'],
                        'mark' => $value['mark'] ?? '',
                        'title' => $value['title'] ?? '',
                        'code' => $value['code'] ?? '',
                        'size' => $value['size'] ?? '',
                        'unit' => $value['unit'] ?? 0,
                        'bar_code' => $value['bar_code'] ?? '',
                    ];
                }
                InvoiceOrderInfo::insert($sub);

                //锁定库存
                ProductInventoryService::changeLockNumber($msg[0]);
            }

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

        return [true,''];
    }

    public function detail($data){
        if($this->isEmpty($data,'order_number')) return [false,'请选择数据'];

        $order = InvoiceOrder::where('order_number',$data['order_number'])
            ->where('del_time',0)
            ->select('id','order_number','sales_order_id','send','send_time','take','take_address','take_phone','logistics_company','logistics_number','crt_id','mark','state','crt_time')
            ->first();
        if(empty($order)) return [false, '发货订单不存在或已被删除'];
        $order = $order->toArray();
        $order['state_title'] = InvoiceOrder::$name[$order['state']] ?? '';
        $sales = SalesOrder::where('id',$order['sales_order_id'])->value('order_number');
        $order['sales_order_number'] = $sales;

        $emp_map = Employee::whereIn('id',array_unique(array_merge_recursive([$order['crt_id']],[$order['send']])))
            ->pluck('emp_name','id')
            ->toArray();
        $info = InvoiceOrderInfo::where('del_time',0)
            ->where('order_number',$data['order_number'])
            ->select('id','order_number','depart_id','product_id','number','mark','title','code','size','unit','bar_code','invoice_id')
            ->get()->toArray();
        $order['product'] = $info;
        $order['send_name'] = $emp_map[$order['send']] ?? '';
        $order['crt_name'] = $emp_map[$order['crt_id']] ?? '';
        $order['crt_time'] = $order['crt_time'] ? date("Y-m-d H:i:s",$order['crt_time']): '';

        return [true, $order];
    }

    public function del($data){
        if($this->isEmpty($data,'order_number')) return [false,'请选择数据！'];

        $bool = InvoiceOrder::where('order_number',$data['order_number'])
            ->where('state','>',InvoiceOrder::STATE_ZERO)->exists();
        if($bool) return [false,'发货订单已确认,删除失败！'];

        $product_save = $this->getSaveDetail($data['order_number']);
        try{
            DB::beginTransaction();
            InvoiceOrder::where('order_number',$data['order_number'])->update([
                'del_time'=>time()
            ]);
            InvoiceOrderInfo::where('order_number',$data['order_number'])->update([
                'del_time'=>time()
            ]);
            //锁定库存释放
            ProductInventoryService::changeLockNumber([],$product_save);

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

        return [true,''];
    }

    public function getList($data,$user){
        $model = InvoiceOrder::where('del_time',0)
            ->select('id','order_number','sales_order_id','depart_id','send','send_time','take','take_address','take_phone','logistics_company','logistics_number','crt_id','mark','state','crt_time')
            ->orderby('id', 'desc');
        if(! empty($data['order_number'])) $model->where('order_number', 'LIKE', '%'.$data['order_number'].'%');
        if(! empty($data['depart_id'])) $model->where('depart_id', $data['depart_id']);
        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]]);
        }

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

        return [true, $list];
    }

    public function fillListData($data){
        if(empty($data['data'])) return $data;

        $depart_id = array_unique(array_column($data['data'],'depart_id'));
        $depart_map = Depart::whereIn('id',$depart_id)
            ->pluck('title','id')
            ->toArray();

        $emp_id = array_unique(array_merge_recursive(array_column($data['data'],'crt_id'),array_column($data['data'],'send')));
        $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();
        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]['depart_name'] = $depart_map[$value['depart_id']] ?? '';
            $data['data'][$key]['crt_name'] = $emp_map[$value['crt_id']] ?? '';
            $data['data'][$key]['send_name'] = $emp_map[$value['send']] ?? '';
            $data['data'][$key]['state_title'] = InvoiceOrder::$name[$value['state']] ?? '';
            $data['data'][$key]['sales_order_number'] = $sales[$value['sales_order_id']] ?? '';
        }

        return $data;
    }

    public function orderRule(&$data, $is_check = true){
        if($this->isEmpty($data,'send')) return [false,'发货人不能为空！'];
        if($this->isEmpty($data,'product')) return [false,'产品不能为空！'];
        if(! empty($data['send_time'])) $data['send_time'] = $this->changeDateToDateMin($data['send_time']);
        if(! empty($data['sales_order_id'])) {
            $sales = SalesOrder::where('del_time',0)
                ->where('id',$data['sales_order_id'])
                ->first();
            if(empty($sales)) return [false,'合同不存在或已被删除'];
            if($sales['sales_order_type'] != SalesOrder::Order_type_two) return [false,'非快递件合同'];
        }
        $product_submit = $product_save = [];
        foreach ($data['product'] as $value){
            if(empty($value['number'])) return [false,'产品数量不能为空'];
            $res = $this->checkNumber($value['number']);
            if(! $res) return [false,'请输入正确的产品数量'];

            if(isset($product_submit[$value['product_id']])){
                $product_submit[$value['product_id']] += $value['number'];
            }else{
                $product_submit[$value['product_id']] = $value['number'];
            }
        }
        list($status,$msg) = (new ProductInventoryService())->compareStock(array_keys($product_submit), [
            'order_number' => $data['order_number'] ?? "",
            'product' => $product_submit
        ]);
        if(! $status) return [false, $msg];

        if($is_check){
            $order_number = (new OrderNoService())->createOrderNumber(InvoiceOrder::prefix);
            if(empty($order_number)) return [false,'发货单号生成失败！'];
            $data['order_number'] = $order_number;
        }else{
            if($this->isEmpty($data,'order_number')) return [false,'发货单号不能为空！'];
            $product_save = $this->getSaveDetail($data['order_number']);
        }

        return [true, [$product_submit, $product_save]];
    }

    public function getSaveDetail($order_number){
        $product_save = [];
        $sub = InvoiceOrderInfo::where('order_number',$order_number)
            ->where('del_time',0)
            ->get()->toArray();
        foreach ($sub as $value){
            if(isset($product_save[$value['product_id']])){
                $product_save[$value['product_id']] += $value['number'];
            }else{
                $product_save[$value['product_id']] = $value['number'];
            }
        }

        return $product_save;
    }
}