<?php

namespace App\Service;

use App\Model\BasicType;
use App\Model\Customer;
use App\Model\Employee;
use App\Model\FollowUpRecord;
use App\Model\SalesOrder;

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

        $model = new FollowUpRecord();
        $model = $model->where('id',$data['id'])->first();
        $model->sales_order_id = $data['sales_order_id'] ?? 0;
        $model->customer_id = $data['customer_id'];
        $model->basic_type_id = $data['basic_type_id'] ;
        $model->visit_time = $data['visit_time'];
        $model->content = $data['content'];
        $model->is_remind = $data['is_remind'];
        $model->save();

        return [true,''];
    }

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

        $model = new FollowUpRecord();
        $model->sales_order_id = $data['sales_order_id'] ?? 0;
        $model->customer_id = $data['customer_id'];
        $model->basic_type_id = $data['basic_type_id'] ;
        $model->visit_time = $data['visit_time'];
        $model->content = $data['content'];
        $model->is_remind = $data['is_remind'];
        $model->crt_id = $user['id'];
        $model->save();

        return [true,''];
    }

    public function followUpRecordDel($data){
        if($this->isEmpty($data,'id')) return [false,'ID必须！'];

        FollowUpRecord::where('id',$data['id'])->update([
            'del_time'=>time()
        ]);

        return [true,'删除成功'];
    }

    public function followUpRecordList($data,$user){
        $model = FollowUpRecord::where('del_time',0)
            ->select('customer_id','basic_type_id','visit_time','id','content','is_remind','crt_time','crt_id','sales_order_id')
            ->orderBy('id','desc');

        if(! empty($data['customer_id'])) $model->where('customer_id',$data['customer_id']);
        if(! empty($data['basic_type_id'])) $model->where('basic_type_id', $data['basic_type_id']);
        if(! empty($data['crt_id'])) $model->where('crt_id',$data['crt_id']);
        if(! empty($data['sales_order_id'])) $model->where('sales_order_id',$data['sales_order_id']);

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

        return [true, $list];
    }

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

        $customer = Customer::whereIn('id',array_unique(array_column($data['data'],'customer_id')))
            ->pluck('title','id')
            ->toArray();

        $basic_type = BasicType::whereIn('id',array_unique(array_column($data['data'],'basic_type_id')))
            ->pluck('title','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]['customer_name'] = $customer[$value['customer_id']] ?? '';
            $data['data'][$key]['basic_type_name'] = $basic_type[$value['basic_type_id']] ?? '';
            $data['data'][$key]['sales_order_number'] = $sales[$value['sales_order_id']] ?? '';
        }
        return $data;
    }

    public function followUpRecordRule(&$data,$is_add = true){
        if($this->isEmpty($data,'customer_id')) return [false,'客户不能为空'];
        if($this->isEmpty($data,'basic_type_id')) return [false,'跟进方式不能为空'];
        if($this->isEmpty($data,'visit_time')) return [false,'拜访时间不能为空'];
        if($this->isEmpty($data,'content')) return [false,'跟进内容不能为空'];
        if($this->isEmpty($data,'sales_order_id')) return [false,'请选择合同'];

        if(! $is_add){
            if($this->isEmpty($data,'id')) return [false,'ID不能为空！'];
        }
        $data['visit_time'] = $this->changeDateToDateMin($data['visit_time']);

        return [true,''];
    }

    public function followUpRecordDetail($data){
        if($this->isEmpty($data,'id')) return [false,'ID必须！'];

        $record = FollowUpRecord::where('del_time',0)
            ->where('id',$data['id'])
            ->first();
        if(empty($record)) return [false,'跟进记录不存在或已被删除'];
        $record = $record->toArray();
        $sales = SalesOrder::where('id',$record['sales_order_id'])->value('order_number');
        $record['sales_order_number'] = $sales;
        $emp_map = Employee::where('id',$record['crt_id'])->value('emp_name');
        $record['crt_name'] = $emp_map;
        $record['crt_time'] = $record['crt_time'] ? date("Y-m-d H:i:s",$record['crt_time']): '';

        return [true, $record];
    }
}