qyadmin/app/Service/ProjectService.php

<?php

namespace App\Service;

use App\Model\Employee;
use App\Model\Project;
use App\Model\ProjectStage;
use App\Model\ProjectStageNode;
use App\Model\ProjectStageNodeMission;
use App\Model\ProjectStageNodeMissionDetail;
use Illuminate\Support\Facades\DB;

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

        DB::beginTransaction();
        try{
            $model = Project::where('id',$data['id'])->first();
            $model->title = $data['title'] ?? "";
            $model->importance = $data['importance'] ?? 0;
            $model->company = $data['company'] ?? "";
            $model->project_cycle = $data['project_cycle'] ?? 0;
            $model->business_director = $data['business_director'] ?? 0;
            $model->technical_director = $data['technical_director'] ?? 0;
            $model->online_director = $data['online_director'] ?? 0;
            $model->after_sale_director = $data['after_sale_director'] ?? 0;
            $model->project_amount = $data['project_amount'] ?? 0;
            $model->plan_start_time = $data['plan_start_time'] ?? 0;
            $model->plan_end_time = $data['plan_end_time'] ?? 0;
            $model->finish_time = $data['finish_time'] ?? 0;
            $model->budget = $data['budget'] ?? 0;
            $model->stage = $data['stage'] ?? 0;
            $model->save();

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

        return [true, ''];
    }

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

        try{
            DB::beginTransaction();

            $model = new Project();
            $model->title = $data['title'] ?? "";
            $model->importance = $data['importance'] ?? 0;
            $model->company = $data['company'] ?? "";
            $model->project_cycle = $data['project_cycle'] ?? 0;
            $model->business_director = $data['business_director'] ?? 0;
            $model->technical_director = $data['technical_director'] ?? 0;
            $model->online_director = $data['online_director'] ?? 0;
            $model->after_sale_director = $data['after_sale_director'] ?? 0;
            $model->project_amount = $data['project_amount'] ?? 0;
            $model->plan_start_time = $data['plan_start_time'] ?? 0;
            $model->plan_end_time = $data['plan_end_time'] ?? 0;
            $model->finish_time = $data['finish_time'] ?? 0;
            $model->budget = $data['budget'] ?? 0;
            $model->stage = $data['stage'] ?? 0;
            $model->crt_id = $user['id'];
            $model->save();

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

        return [true, ''];
    }

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

        DB::beginTransaction();
        try {
            Project::where('id',$data['id'])->update([
                'del_time' => time()
            ]);
            ProjectStage::where('project_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNode::where('project_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNodeMission::where('project_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNodeMissionDetail::where('project_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);

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

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

    public function detail($data){
        if(empty($data['id'])) return [false, "ID不能为空"];

        $project = Project::where('id',$data['id'])->first();
        if(empty($project) || $project->del_time > 0) return [false, '项目不存在或已被删除'];
        $project = $project->toArray();

        //组织数据
        $emp_id = [$project['business_director'], $project['technical_director'], $project['online_director'], $project['after_sale_director'], $project['crt_id']];
        $emp_id = array_unique($emp_id);
        $emp_map = Employee::whereIn('id',$emp_id)->pluck('emp_name','id')->toArray();
        $start_time = $project['plan_start_time'] ? date("Y-m-d H:i",$project['plan_start_time']) : '';
        $end_time = $project['plan_end_time'] ? date("Y-m-d H:i",$project['plan_end_time']) : '';
        $project['plan_time'] = $start_time . '——' . $end_time;
        $project['crt_time'] = $project['crt_time'] ? date("Y-m-d H:i:s",$project['crt_time']): '';
        $project['finish_time'] = $project['finish_time'] ? date("Y-m-d",$project['finish_time']): '';
        $project['business_director_title'] = $emp_map[$project['business_director']] ?? "";
        $project['technical_director_title'] = $emp_map[$project['technical_director']] ?? "";
        $project['online_director_title'] = $emp_map[$project['online_director']] ?? "";
        $project['after_sale_director_title'] = $emp_map[$project['after_sale_director']] ?? "";
        $project['crt_name'] = $emp_map[$project['crt_id']] ?? "";

        //任务报告
        $project_stage_node_mission_detail = ProjectStageNodeMissionDetail::where('del_time',0)
            ->where('project_id',$data['id'])
            ->get()->toArray();
        $employee_id = array_unique(array_column($project_stage_node_mission_detail,'crt_id'));
        $emp_map = Employee::whereIn('id',$employee_id)->pluck('emp_name','id')->toArray();
        $project_stage_node_mission_detail_map = [];
        foreach ($project_stage_node_mission_detail as $key => $value){
            $start_time = $value['start_time'] ? date("Y-m-d H:i",$value['start_time']) : '';
            $end_time = $value['end_time'] ? date("Y-m-d H:i",$value['end_time']) : '';
            $project_stage_node_mission_detail[$key]['time'] = $start_time . '——' . $end_time;
            $project_stage_node_mission_detail[$key]['crt_name'] = $emp_map[$value['crt_id']] ?? "";

            $project_stage_node_mission_detail_map[$value['project_stage_node_mission_id']][] = $project_stage_node_mission_detail[$key];
        }

        //任务
        $project_stage_node_mission = ProjectStageNodeMission::where('del_time',0)
            ->where('project_id',$data['id'])
            ->get()->toArray();

        //获取人员名称
        $emp_map = $this->returnEmployeeTitle($project_stage_node_mission);
        $project_stage_node_mission_map = [];
        foreach ($project_stage_node_mission as $key => $value){
            $title = "";
            $tmp = explode(',', $value['employee_id']);
            foreach ($tmp as $val){
                $title_tmp = $emp_map[$val] ?? "";
                if($title_tmp) $title .= $title_tmp . ",";
            }
            $project_stage_node_mission[$key]['employee_title'] = rtrim($title,',');

            $son = $project_stage_node_mission_detail_map[$value['id']] ?? [];
            $project_stage_node_mission[$key]['children'] = $son;
            $project_stage_node_mission_map[$value['project_stage_node_id']][] = $project_stage_node_mission[$key];
        }

        //节点
        $project_stage_node = ProjectStageNode::where('del_time',0)
            ->where('project_id',$data['id'])
            ->get()->toArray();
        $project_stage_node_map = [];
        foreach ($project_stage_node as $key => $value){
            $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
            $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
            $project_stage_node[$key]['plan_time'] = $start_time . '——' . $end_time;
            $project_stage_node[$key]['start_time'] = $value['start_time'] ? date("Y-m-d",$value['start_time']): '';

            $son = $project_stage_node_mission_map[$value['id']] ?? [];
            $project_stage_node[$key]['children'] = $son;
            $project_stage_node_map[$value['project_stage_id']][] = $project_stage_node[$key];
        }

        //阶段
        $project_stage = ProjectStage::where('del_time',0)
            ->where('project_id',$data['id'])
            ->get()->toArray();
        foreach ($project_stage as $key => $value){
            $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
            $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
            $project_stage[$key]['plan_time'] = $start_time . '——' . $end_time;
            $project_stage[$key]['start_time'] = $value['start_time'] ? date("Y-m-d",$value['start_time']): '';
            $project_stage[$key]['children'] = $project_stage_node_map[$value['id']] ?? [];
        }

//        $project['project_stage'] = $project_stage;
//        $project['project_stage_node'] = $project_stage_node;
//        $project['project_stage_node_mission'] = $project_stage_node_mission;
//        $project['project_stage_node_mission_detail'] = $project_stage_node_mission_detail;
        $project['children'] = $project_stage;

        return [true, $project];
    }

    public function projectList($data,$user){
        $model = Project::where('del_time',0)
            ->select('id','title','importance','company','project_cycle','business_director','technical_director','online_director','after_sale_director','project_amount','plan_start_time','plan_end_time','finish_time','budget','stage','crt_time','crt_id')
            ->orderBy('id','desc');

        if(! empty($data['title'])) $model->where('title',$data['title']);
        if(! empty($data['company'])) $model->where('company',$data['company']);
        if(isset($data['importance'])) $model->where('importance',$data['importance']);
        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

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

        return [true, $list];
    }

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

        $emp_id = array_unique(array_merge_recursive(array_column($data['data'], 'business_director'), array_column($data['data'], 'technical_director'),array_column($data['data'], 'online_director'),array_column($data['data'], 'after_sale_director'),array_column($data['data'],'crt_id')));
        $emp_map = Employee::whereIn('id',$emp_id)->pluck('emp_name','id')->toArray();
        foreach ($data['data'] as $key => $value){
            $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
            $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
            $data['data'][$key]['plan_time'] = $start_time . '——' . $end_time;
            $data['data'][$key]['crt_name'] = $emp_map[$value['crt_id']] ?? "";
            $data['data'][$key]['crt_time'] = $value['crt_time'] ? date("Y-m-d H:i:s",$value['crt_time']): '';
            $data['data'][$key]['finish_time'] = $value['finish_time'] ? date("Y-m-d",$value['finish_time']): '';
            $data['data'][$key]['business_director_title'] = $emp_map[$value['business_director']] ?? "";
            $data['data'][$key]['technical_director_title'] = $emp_map[$value['technical_director']] ?? "";
            $data['data'][$key]['online_director_title'] = $emp_map[$value['online_director']] ?? "";
            $data['data'][$key]['after_sale_director_title'] = $emp_map[$value['after_sale_director']] ?? "";
        }

        return $data;
    }

    public function projectRule(&$data, $is_check = true){
        if(empty($data['title'])) return [false,'项目名称不能为空'];
        if(isset($data['project_cycle'])){
            if(! is_numeric($data['project_cycle']) || floatval($data['project_cycle']) < 0.0) return [false, '项目周期请输入合法的数字(天数)'];
        }

        if(isset($data['project_amount'])){
            $res = $this->checkNumber($data['project_amount']);
            if(! $res) return [false, '项目金额请输入不超过两位小数并且大于的等于0的数值'];
        }

        if(isset($data['budget'])){
            $res = $this->checkNumber($data['budget']);
            if(! $res) return [false, '预算请输入不超过两位小数并且大于的等于0的数值'];
        }

        if(isset($data['stage'])){
            $res = $this->checkNumber($data['budget'], 0);
            if(! $res) return [false, '阶段数请输入大于等于0的整数'];
        }

        if(! empty($data['plan_time'][0]) && ! empty($data['plan_time'][1])){
            $data['plan_start_time'] = $this->changeDateToDateMin($data['plan_time'][0]);
            $data['plan_end_time'] = $this->changeDateToDateMin($data['plan_time'][1]);
        }

        if(! empty($data['finish_time'])) $data['finish_time'] = $this->changeDateToDate($data['finish_time']);

        if($is_check){

        }else{
            if(empty($data['id'])) return [false, '项目ID不能为空'];
            $boolean = Project::where('id',$data['id'])->where('del_time',0)->exists();
            if(! $boolean) return [false, '项目不存在或已被删除'];
        }

        return [true, ''];
    }

    public function editStage($data){
        list($status,$msg) = $this->stageRule($data,false);
        if(! $status) return [$status,$msg];

        DB::beginTransaction();
        try{
            $model = ProjectStage::where('id',$data['id'])->first();
            $model->project_id = $data['project_id'] ?? 0;
            $model->title = $data['title'] ?? "";
            $model->plan_start_time = $data['plan_start_time'] ?? 0;
            $model->plan_end_time = $data['plan_end_time'] ?? 0;
            $model->start_time = $data['start_time'] ?? 0;
            $model->receivable_amount = $data['receivable_amount'] ?? 0;
            $model->receipt_amount = $data['receipt_amount'] ?? 0;
            $model->save();

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

        return [true, ''];
    }

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

        try{
            DB::beginTransaction();

            $model = new ProjectStage();
            $model->project_id = $data['project_id'] ?? 0;
            $model->title = $data['title'] ?? "";
            $model->plan_start_time = $data['plan_start_time'] ?? 0;
            $model->plan_end_time = $data['plan_end_time'] ?? 0;
            $model->start_time = $data['start_time'] ?? 0;
            $model->receivable_amount = $data['receivable_amount'] ?? 0;
            $model->receipt_amount = $data['receipt_amount'] ?? 0;
            $model->save();

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

        return [true, ''];
    }

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

        DB::beginTransaction();
        try {
            ProjectStage::where('id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNode::where('project_stage_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNodeMission::where('project_stage_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNodeMissionDetail::where('project_stage_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);

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

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

    public function stageRule(&$data, $is_check = true){
        if(empty($data['project_id'])) return [false,'项目ID不能为空'];
        $bool = Project::where('id',$data['project_id'])->where('del_time',0)->exists();
        if(! $bool) return [false, '该项目不存在或已被删除'];

        if(empty($data['title'])) return [false, '阶段名称不能为空'];

        if(isset($data['receivable_amount'])){
            $res = $this->checkNumber($data['receivable_amount']);
            if(! $res) return [false, '阶段应收金额请输入不超过两位小数并且大于的等于0的数值'];
        }

        if(isset($data['receipt_amount'])){
            $res = $this->checkNumber($data['receipt_amount']);
            if(! $res) return [false, '阶段实收金额请输入不超过两位小数并且大于的等于0的数值'];
        }

        if(! empty($data['plan_time'][0]) && ! empty($data['plan_time'][1])){
            $data['plan_start_time'] = $this->changeDateToDateMin($data['plan_time'][0]);
            $data['plan_end_time'] = $this->changeDateToDateMin($data['plan_time'][1]);
        }

        if(! empty($data['start_time'])) $data['start_time'] = $this->changeDateToDate($data['start_time']);

        if($is_check){
            $bool = ProjectStage::where('project_id',$data['project_id'])
                ->where('title',$data['title'])
                ->exists();
        }else{
            if(empty($data['id'])) return [false, '阶段ID不能为空'];
            $boolean = ProjectStage::where('id',$data['id'])->where('del_time',0)->exists();
            if(! $boolean) return [false, '项目阶段不存在或已被删除'];

            $bool = ProjectStage::where('project_id',$data['project_id'])
                ->where('id','<>',$data['id'])
                ->where('title',$data['title'])
                ->exists();
        }
        if($bool) return [false, '项目阶段名已存在'];

        return [true, ''];
    }

    public function projectStageList($data,$user){
        $model = ProjectStage::where('del_time',0)
            ->select('id','title','project_id','plan_start_time','plan_end_time','start_time','receivable_amount','receipt_amount','crt_time')
            ->orderBy('id','desc');

        if(! empty($data['title'])) $model->where('title',$data['title']);
        if(! empty($data['project_title'])) {
            $project_id = $this->searchProject(['title' => $data['project_title']]);
            $model->whereIn('project_id', $project_id);
        }
        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

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

        return [true, $list];
    }

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

        $project_map = $this->getProject(array_column($data['data'],'project_id'));
        foreach ($data['data'] as $key => $value){
            $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
            $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
            $data['data'][$key]['plan_time'] = $start_time . '——' . $end_time;
            $data['data'][$key]['crt_time'] = $value['crt_time'] ? date("Y-m-d H:i:s",$value['crt_time']): '';
            $data['data'][$key]['start_time'] = $value['start_time'] ? date("Y-m-d",$value['start_time']): '';
            $data['data'][$key]['project_title'] = $project_map[$value['project_id']] ?? "";
        }

        return $data;
    }

    public function editStageNode($data){
        list($status,$msg) = $this->stageRuleNode($data,false);
        if(! $status) return [$status,$msg];

        DB::beginTransaction();
        try{
            $model = ProjectStageNode::where('id',$data['id'])->first();
            $model->project_id = $data['project_id'] ?? 0;
            $model->project_stage_id = $data['project_stage_id'] ?? 0;
            $model->title = $data['title'] ?? "";
            $model->plan_start_time = $data['plan_start_time'] ?? 0;
            $model->plan_end_time = $data['plan_end_time'] ?? 0;
            $model->start_time = $data['start_time'] ?? 0;
            $model->save();

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

        return [true, ''];
    }

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

        try{
            DB::beginTransaction();

            $model = new ProjectStageNode();
            $model->project_id = $data['project_id'] ?? 0;
            $model->project_stage_id = $data['project_stage_id'] ?? 0;
            $model->title = $data['title'] ?? "";
            $model->plan_start_time = $data['plan_start_time'] ?? 0;
            $model->plan_end_time = $data['plan_end_time'] ?? 0;
            $model->start_time = $data['start_time'] ?? 0;
            $model->save();

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

        return [true, ''];
    }

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

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

            ProjectStageNodeMission::where('project_stage_node_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNodeMissionDetail::where('project_stage_node_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);

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

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

    public function stageRuleNode(&$data, $is_check = true){
        if(empty($data['project_stage_id'])) return [false,'项目阶段ID不能为空'];
        $stage = ProjectStage::where('id',$data['project_stage_id'])->where('del_time',0)->first();
        if(empty($stage)) return [false, '该项目阶段不存在或已被删除'];
        $stage = $stage->toArray();
        $data['project_id'] = $stage['project_id'];

        if(empty($data['title'])) return [false, '节点名称不能为空'];

        if(! empty($data['plan_time'][0]) && ! empty($data['plan_time'][1])){
            $data['plan_start_time'] = $this->changeDateToDateMin($data['plan_time'][0]);
            $data['plan_end_time'] = $this->changeDateToDateMin($data['plan_time'][1]);
        }

        if(! empty($data['start_time'])) $data['start_time'] = $this->changeDateToDate($data['start_time']);

        if($is_check){
            $bool = ProjectStageNode::where('project_id',$data['project_id'])
                ->where('project_stage_id',$data['project_stage_id'])
                ->where('title',$data['title'])
                ->exists();
        }else{
            if(empty($data['id'])) return [false, '阶段节点ID不能为空'];
            $boolean = ProjectStageNode::where('id',$data['id'])->where('del_time',0)->exists();
            if(! $boolean) return [false, '项目阶段节点不存在或已被删除'];

            $bool = ProjectStageNode::where('project_id',$data['project_id'])
                ->where('project_stage_id',$data['project_stage_id'])
                ->where('id','<>',$data['id'])
                ->where('title',$data['title'])
                ->exists();
        }
        if($bool) return [false, '项目阶段节点名已存在'];

        return [true, ''];
    }

    public function projectStageNodeList($data,$user){
        $model = ProjectStageNode::where('del_time',0)
            ->select('id','project_stage_id','project_id','plan_start_time','plan_end_time','start_time','crt_time','title')
            ->orderBy('id','desc');

        if(! empty($data['project_stage_title'])) {
            $project_stage_id = $this->searchProjectStage(['title' => $data['project_stage_title']]);
            $model->whereIn('project_stage_id', $project_stage_id);
        }
        if(! empty($data['project_title'])) {
            $project_id = $this->searchProject(['title' => $data['project_title']]);
            $model->whereIn('project_id', $project_id);
        }
        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

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

        return [true, $list];
    }

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

        $project_map = $this->getProject(array_column($data['data'],'project_id'));
        $project_stage_map = $this->getProjectStage(array_column($data['data'],'project_stage_id'));
        foreach ($data['data'] as $key => $value){
            $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
            $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
            $data['data'][$key]['plan_time'] = $start_time . '——' . $end_time;
            $data['data'][$key]['crt_time'] = $value['crt_time'] ? date("Y-m-d H:i:s",$value['crt_time']): '';
            $data['data'][$key]['start_time'] = $value['start_time'] ? date("Y-m-d",$value['start_time']): '';
            $data['data'][$key]['project_title'] = $project_map[$value['project_id']] ?? "";
            $data['data'][$key]['project_stage_title'] = $project_stage_map[$value['project_stage_id']] ?? "";
        }

        return $data;
    }

    public function editStageNodeMission($data){
        list($status,$msg) = $this->stageRuleNodeMission($data,false);
        if(! $status) return [$status,$msg];

        DB::beginTransaction();
        try{
            $model = ProjectStageNodeMission::where('id',$data['id'])->first();
            $model->project_id = $data['project_id'] ?? 0;
            $model->project_stage_id = $data['project_stage_id'] ?? 0;
            $model->project_stage_node_id = $data['project_stage_node_id'] ?? 0;
            $model->title = $data['title'] ?? "";
            $model->content = $data['content'] ?? 0;
            $model->employee_id = $data['employee_id'] ?? "";
            $model->save();

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

        return [true, ''];
    }

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

        try{
            DB::beginTransaction();

            $model = new ProjectStageNodeMission();
            $model->project_id = $data['project_id'] ?? 0;
            $model->project_stage_id = $data['project_stage_id'] ?? 0;
            $model->project_stage_node_id = $data['project_stage_node_id'] ?? 0;
            $model->title = $data['title'] ?? "";
            $model->content = $data['content'] ?? 0;
            $model->employee_id = $data['employee_id'] ?? "";
            $model->save();

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

        return [true, ''];
    }

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

        DB::beginTransaction();
        try {
            ProjectStageNodeMission::where('id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);
            ProjectStageNodeMissionDetail::where('project_stage_node_mission_id',$data['id'])->where('del_time',0)->update([
                'del_time' => time()
            ]);

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

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

    public function stageRuleNodeMission(&$data, $is_check = true){
        if(empty($data['project_stage_node_id'])) return [false,'项目阶段节点ID不能为空'];
        $stage = ProjectStageNode::where('id',$data['project_stage_node_id'])->where('del_time',0)->first();
        if(empty($stage)) return [false, '该项目阶段节点不存在或已被删除'];
        $stage = $stage->toArray();
        $data['project_id'] = $stage['project_id'];
        $data['project_stage_id'] = $stage['project_stage_id'];

        if(empty($data['title'])) return [false, '节点任务名称不能为空'];
        if(empty($data['content'])) return [false, '节点任务内容不能为空'];

        if($is_check){
            $bool = ProjectStageNodeMission::where('project_id',$data['project_id'])
                ->where('project_stage_id',$data['project_stage_id'])
                ->where('project_stage_node_id',$data['project_stage_node_id'])
                ->where('title',$data['title'])
                ->exists();
        }else{
            if(empty($data['id'])) return [false, '阶段节点任务ID不能为空'];
            $boolean = ProjectStageNodeMission::where('id',$data['id'])->where('del_time',0)->exists();
            if(! $boolean) return [false, '项目阶段节点任务不存在或已被删除'];

            $bool = ProjectStageNodeMission::where('project_id',$data['project_id'])
                ->where('project_stage_id',$data['project_stage_id'])
                ->where('project_stage_node_id',$data['project_stage_node_id'])
                ->where('id','<>',$data['id'])
                ->where('title',$data['title'])
                ->exists();
        }
        if($bool) return [false, '节点任务名称已存在'];

        return [true, ''];
    }

    public function projectStageNodeMissionList($data,$user){
        $model = ProjectStageNodeMission::where('del_time',0)
            ->select('id','project_stage_id','project_id','project_stage_node_id','title','content','employee_id','crt_time')
            ->orderBy('id','desc');

        if(! empty($data['project_stage_title'])) {
            $project_stage_id = $this->searchProjectStage(['title' => $data['project_stage_title']]);
            $model->whereIn('project_stage_id', $project_stage_id);
        }
        if(! empty($data['project_title'])) {
            $project_id = $this->searchProject(['title' => $data['project_title']]);
            $model->whereIn('project_id', $project_id);
        }
        if(! empty($data['project_stage_node_title'])) {
            $project_stage_node_id = $this->searchProjectStageNode(['title' => $data['project_stage_node_title']]);
            $model->whereIn('project_stage_node_id', $project_stage_node_id);
        }
        if(! empty($data['title'])) $model->where('title', 'LIKE', '%'.$data['title'].'%');
        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

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

        return [true, $list];
    }

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

        $emp_map = $this->returnEmployeeTitle($data['data']);
        $project_map = $this->getProject(array_column($data['data'],'project_id'));
        $project_stage_map = $this->getProjectStage(array_column($data['data'],'project_stage_id'));
        $project_stage_node_map = $this->getProjectStageNode(array_column($data['data'],'project_stage_node_id'));
        foreach ($data['data'] as $key => $value){
            $title = "";
            $tmp = explode(',', $value['employee_id']);
            foreach ($tmp as $val){
                $title_tmp = $emp_map[$val] ?? "";
                if($title_tmp) $title .= $title_tmp . ",";
            }
            $data['data'][$key]['employee_title'] = rtrim($title,',');
            $data['data'][$key]['crt_time'] = $value['crt_time'] ? date("Y-m-d H:i:s",$value['crt_time']): '';
            $data['data'][$key]['project_title'] = $project_map[$value['project_id']] ?? "";
            $data['data'][$key]['project_stage_title'] = $project_stage_map[$value['project_stage_id']] ?? "";
            $data['data'][$key]['project_stage_node_title'] = $project_stage_node_map[$value['project_stage_node_id']] ?? "";
        }

        return $data;
    }

    public function editStageNodeMissionDetail($data){
        list($status,$msg) = $this->stageRuleNodeMissionDetail($data,false);
        if(! $status) return [$status,$msg];

        DB::beginTransaction();
        try{
            $model = ProjectStageNodeMissionDetail::where('id',$data['id'])->first();
            $model->project_id = $data['project_id'] ?? 0;
            $model->project_stage_id = $data['project_stage_id'] ?? 0;
            $model->project_stage_node_id = $data['project_stage_node_id'] ?? 0;
            $model->project_stage_node_mission_id = $data['project_stage_node_mission_id'] ?? 0;
            $model->start_time = $data['start_time'] ?? 0;
            $model->end_time = $data['end_time'] ?? 0;
            $model->content = $data['content'] ?? 0;
            $model->completion_degree = $data['completion_degree'] ?? "";
            $model->save();

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

        return [true, ''];
    }

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

        try{
            DB::beginTransaction();

            $model = new ProjectStageNodeMissionDetail();
            $model->project_id = $data['project_id'] ?? 0;
            $model->project_stage_id = $data['project_stage_id'] ?? 0;
            $model->project_stage_node_id = $data['project_stage_node_id'] ?? 0;
            $model->project_stage_node_mission_id = $data['project_stage_node_mission_id'] ?? 0;
            $model->start_time = $data['start_time'] ?? 0;
            $model->end_time = $data['end_time'] ?? 0;
            $model->content = $data['content'] ?? 0;
            $model->completion_degree = $data['completion_degree'] ?? "";
            $model->crt_id = $user['id'] ?? "";
            $model->save();

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

        return [true, ''];
    }

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

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

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

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

    public function stageRuleNodeMissionDetail(&$data, $is_check = true){
        if(empty($data['project_stage_node_mission_id'])) return [false,'项目阶段节点任务ID不能为空'];
        $stage = ProjectStageNodeMission::where('id',$data['project_stage_node_mission_id'])->where('del_time',0)->first();
        if(empty($stage)) return [false, '该项目阶段节点任务不存在或已被删除'];
        $stage = $stage->toArray();
        $data['project_id'] = $stage['project_id'];
        $data['project_stage_id'] = $stage['project_stage_id'];
        $data['project_stage_node_id'] = $stage['project_stage_node_id'];

        if(! empty($data['time'][0]) && ! empty($data['time'][1])){
            $data['start_time'] = $this->changeDateToDateMin($data['time'][0]);
            $data['end_time'] = $this->changeDateToDateMin($data['time'][1]);
        }

        if(empty($data['content'])) return [false, '节点任务报告内容不能为空'];
        if(! isset($data['completion_degree'])) return [false, '任务报告完成度不能为空'];
        $res = $this->checkNumber($data['completion_degree'], 0);
        if(! $res) return [false, '任务报告完成度请输入大于等于0的整数'];

        if($is_check){

        }else{
            if(empty($data['id'])) return [false, '阶段节点任务ID不能为空'];
            $boolean = ProjectStageNodeMissionDetail::where('id',$data['id'])->where('del_time',0)->exists();
            if(! $boolean) return [false, '项目阶段节点任务报告不存在或已被删除'];
        }

        return [true, ''];
    }

    public function projectStageNodeMissionDetailList($data,$user){
        $model = ProjectStageNodeMissionDetail::where('del_time',0)
            ->select('id','project_stage_id','project_id','project_stage_node_id','project_stage_node_mission_id','content','start_time','crt_time','end_time','completion_degree','crt_id')
            ->orderBy('id','desc');

        if(! empty($data['project_stage_title'])) {
            $project_stage_id = $this->searchProjectStage(['title' => $data['project_stage_title']]);
            $model->whereIn('project_stage_id', $project_stage_id);
        }
        if(! empty($data['project_title'])) {
            $project_id = $this->searchProject(['title' => $data['project_title']]);
            $model->whereIn('project_id', $project_id);
        }
        if(! empty($data['project_stage_node_title'])) {
            $project_stage_node_id = $this->searchProjectStageNode(['title' => $data['project_stage_node_title']]);
            $model->whereIn('project_stage_node_id', $project_stage_node_id);
        }
        if(! empty($data['project_stage_node_mission_title'])) {
            $project_stage_node_mission_id = $this->searchProjectStageNodeMission(['title' => $data['project_stage_node_mission_title']]);
            $model->whereIn('project_stage_node_mission_title', $project_stage_node_mission_id);
        }
        if(! empty($data['crt_time'][0]) && ! empty($data['crt_time'][1])) {
            $return = $this->changeDateToTimeStampAboutRange($data['crt_time']);
            $model->where('crt_time','>=',$return[0]);
            $model->where('crt_time','<=',$return[1]);
        }

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

        return [true, $list];
    }

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

        $project_map = $this->getProject(array_column($data['data'],'project_id'));
        $project_stage_map = $this->getProjectStage(array_column($data['data'],'project_stage_id'));
        $project_stage_node_map = $this->getProjectStageNode(array_column($data['data'],'project_stage_node_id'));
        $project_stage_node_mission_map = $this->getProjectStageNodeMission(array_column($data['data'],'project_stage_node_mission_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]['start_time'] = $value['start_time'] ? date("Y-m-d H:i",$value['start_time']): '';
            $data['data'][$key]['end_time'] = $value['end_time'] ? date("Y-m-d H:i",$value['end_time']): '';
            $data['data'][$key]['project_title'] = $project_map[$value['project_id']] ?? "";
            $data['data'][$key]['project_stage_title'] = $project_stage_map[$value['project_stage_id']] ?? "";
            $data['data'][$key]['project_stage_node_title'] = $project_stage_node_map[$value['project_stage_node_id']] ?? "";
            $data['data'][$key]['project_stage_node_mission_title'] = $project_stage_node_mission_map[$value['project_stage_node_mission_id']] ?? "";
        }

        return $data;
    }

    public function getSonData($data, $user){
        if(empty($data['id'])) return [false, '数据id不能为空'];
        if(empty($data['type'])) return [false, '查询类型不能为空'];

        $id = $data['id'];
        $type = $data['type'];

        if($type == 1){
            //阶段
            $project_stage = ProjectStage::where('del_time',0)
                ->where('project_id',$id)
                ->get()->toArray();
            foreach ($project_stage as $key => $value){
                $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
                $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
                $project_stage[$key]['plan_time'] = $start_time . '——' . $end_time;
                $project_stage[$key]['start_time'] = $value['start_time'] ? date("Y-m-d",$value['start_time']): '';
            }

            return [true, $project_stage];
        }elseif($type == 2){
            //节点
            $project_stage_node = ProjectStageNode::where('del_time',0)
                ->where('project_stage_id',$id)
                ->get()->toArray();
            foreach ($project_stage_node as $key => $value){
                $start_time = $value['plan_start_time'] ? date("Y-m-d H:i",$value['plan_start_time']) : '';
                $end_time = $value['plan_end_time'] ? date("Y-m-d H:i",$value['plan_end_time']) : '';
                $project_stage_node[$key]['plan_time'] = $start_time . '——' . $end_time;
                $project_stage_node[$key]['start_time'] = $value['start_time'] ? date("Y-m-d",$value['start_time']): '';
            }

            return [true, $project_stage_node];
        }elseif($type == 3){
            //任务
            $project_stage_node_mission = ProjectStageNodeMission::where('del_time',0)
                ->where('project_stage_node_id',$id)
                ->get()->toArray();

            //获取人员名称
            $emp_map = $this->returnEmployeeTitle($project_stage_node_mission);
            foreach ($project_stage_node_mission as $key => $value){
                $title = "";
                $tmp = explode(',', $value['employee_id']);
                foreach ($tmp as $val){
                    $title_tmp = $emp_map[$val] ?? "";
                    if($title_tmp) $title .= $title_tmp . ",";
                }
                $project_stage_node_mission[$key]['employee_title'] = rtrim($title,',');
            }

            return [true, $project_stage_node_mission];
        }elseif ($type == 4){
            //任务报告
            $project_stage_node_mission_detail = ProjectStageNodeMissionDetail::where('del_time',0)
                ->where('project_stage_node_mission_id',$data['id'])
                ->get()->toArray();
            $employee_id = array_unique(array_column($project_stage_node_mission_detail,'crt_id'));
            $emp_map = Employee::whereIn('id',$employee_id)->pluck('emp_name','id')->toArray();
            foreach ($project_stage_node_mission_detail as $key => $value){
                $start_time = $value['start_time'] ? date("Y-m-d H:i",$value['start_time']) : '';
                $end_time = $value['end_time'] ? date("Y-m-d H:i",$value['end_time']) : '';
                $project_stage_node_mission_detail[$key]['time'] = $start_time . '——' . $end_time;
                $project_stage_node_mission_detail[$key]['crt_name'] = $emp_map[$value['crt_id']] ?? "";
            }

            return [false, $project_stage_node_mission_detail];
        }

        return [false, '查询类型不存在'];
    }

    public function searchProject($data){
        $model = new Project();
        $model->where('del_time',0);

        if(empty($data['title'])){
            $model->where('title', 'LIKE', '%'.$data['title'].'%');
            $id = $model->select('id')->get()->toArray();
            return array_column($id,'id');
        }

        return [];
    }

    public function getProject($project_id = []){
        if(empty($project_id)) return [];

        $map = Project::whereIn('id', $project_id)
            ->pluck('title','id')
            ->toArray();

        return $map;
    }

    public function searchProjectStage($data){
        $model = new ProjectStage();
        $model->where('del_time',0);

        if(empty($data['title'])){
            $model->where('title', 'LIKE', '%'.$data['title'].'%');
            $id = $model->select('id')->get()->toArray();
            return array_column($id,'id');
        }

        return [];
    }

    public function getProjectStage($project_stage_id = []){
        if(empty($project_stage_id)) return [];

        $map = ProjectStage::whereIn('id', $project_stage_id)
            ->pluck('title','id')
            ->toArray();

        return $map;
    }

    public function searchProjectStageNode($data){
        $model = new ProjectStageNode();
        $model->where('del_time',0);

        if(empty($data['title'])){
            $model->where('title', 'LIKE', '%'.$data['title'].'%');
            $id = $model->select('id')->get()->toArray();
            return array_column($id,'id');
        }

        return [];
    }

    public function getProjectStageNode($project_stage_node_id = []){
        if(empty($project_stage_node_id)) return [];

        $map = ProjectStageNode::whereIn('id', $project_stage_node_id)
            ->pluck('title','id')
            ->toArray();

        return $map;
    }

    public function returnEmployeeTitle($data){
        $employee_array = [];
        $employee_id = array_column($data,'employee_id');
        foreach ($employee_id as $emp){
            $tmp = explode(',',$emp);
            foreach ($tmp as $val){
                if(! in_array($val, $employee_array)) $employee_array[] = $val;
            }
        }
        $emp_map = Employee::whereIn('id',$employee_array)->pluck('emp_name','id')->toArray();

        return $emp_map;
    }

    public function searchProjectStageNodeMission($data){
        $model = new ProjectStageNodeMission();
        $model->where('del_time',0);

        if(empty($data['title'])){
            $model->where('title', 'LIKE', '%'.$data['title'].'%');
            $id = $model->select('id')->get()->toArray();
            return array_column($id,'id');
        }

        return [];
    }

    public function getProjectStageNodeMission($project_stage_node_mission_id = []){
        if(empty($project_stage_node_mission_id)) return [];

        $map = ProjectStageNodeMission::whereIn('id', $project_stage_node_mission_id)
            ->pluck('title','id')
            ->toArray();

        return $map;
    }
}