qyadmin/app/Service/ProjectService.php

<?php

namespace App\Service;

use App\Model\Employee;
use App\Model\Project;
use App\Model\ProjectEmployee;
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 getProjectEmployee($data, $type = 1){
        $data_id_column = ProjectEmployee::$type_id[$type] ?? "";
        if(empty($data_id_column)) return ['name' => "", 'name_id' => ""];

        if(is_array($data['id'])){
            $employee = ProjectEmployee::where('del_time',0)
                ->whereIn($data_id_column, $data['id'])
                ->where('type', $type)
                ->select($data_id_column, 'employee_id')
                ->get()->toArray();
            $employee_id = array_column($employee, 'employee_id');

            $man = Employee::whereIn('id', $employee_id)
                ->pluck('emp_name','id')
                ->toArray();

            $array = [];
            foreach ($employee as $value){
                $tmp = $man[$value['employee_id']] ?? "";
                if(isset($array[$value[$data_id_column]])){
                    $array[$value[$data_id_column]]['name'] .= ',' . $tmp;
                    $array[$value[$data_id_column]]['name_id'] .= ',' . $value['employee_id'];
                }else{
                    $array[$value[$data_id_column]] = [
                        'name' => $tmp,
                        'name_id' => $value['employee_id'],
                    ];
                }
            }

            return $array;
        }else{
            $employee = ProjectEmployee::where('del_time',0)
                ->where($data_id_column, $data['id'])
                ->where('type', $type)
                ->select('employee_id')
                ->get()->toArray();
            $employee = array_column($employee, 'employee_id');

            $man = Employee::whereIn('id', $employee)
                ->pluck('emp_name','id')
                ->toArray();

            $title = $title_id = "";
            foreach ($employee as $value){
                $tmp = $man[$value] ?? "";
                if($tmp) $title .= $tmp . ',';
                $title_id .= $value . ',';
            }
            $title = rtrim($title, ',');
            $title_id = rtrim($title_id, ',');

            return ['name' => $title, 'name_id' => $title_id];
        }
    }

    public function projectEmployee($data, $type = 0, $is_add = true){
        //关联字段
        $data_id_column = ProjectEmployee::$type_id[$type] ?? "";
        if(empty($data_id_column)) return;
        //关联类型
        $type_array = ProjectEmployee::$type_id_type[$type] ?? [];

        if(! $is_add) {
            ProjectEmployee::where('del_time',0)
                ->where($data_id_column, $data['id'])
                ->whereIn('type',$type_array)
                ->update(['del_time' => time()]);
        }

        if(! empty($data['employee_id'])){
            $array = [];
            foreach (ProjectEmployee::$type_id as $v){
                $array[$v] = 0;
            }
            if(isset($array[$data_id_column])) $array[$data_id_column] = $data['id'];

            $tmp = [
                'employee_id' => 0,
                'type' => $type,
            ];
            $tmp = array_merge($tmp, $array);

            $insert = [];
            $employee = explode(',', $data['employee_id']);
            foreach ($employee as $value){
                $tmp['employee_id'] = $value;
                $insert[] = $tmp;
            }
            ProjectEmployee::insert($insert);
        }
    }

    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->order_number = $data['order_number'] ?? "";
            $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();

            $this->projectEmployee($data, ProjectEmployee::type_one, false);

            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->order_number = $data['order_number'] ?? "";
            $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();
            $data['id'] = $model->id;

            $this->projectEmployee($data, ProjectEmployee::type_one);

            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 {
            $this->projectEmployee($data, ProjectEmployee::type_one, false);

            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']] ?? "";

        //项目成员
        $return = $this->getProjectEmployee($data, ProjectEmployee::type_one);
        $project['employee_title'] = $return['name'] ?? "";
        $project['employee_id'] = $return['name_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();
        $map = [];
        $project_stage_node_mission_id = array_column($project_stage_node_mission, 'id');
        foreach ($project_stage_node_mission_id as $value){
            //任务成员
            $return = $this->getProjectEmployee(['id' => $value], ProjectEmployee::type_four);
            $map[$value] = $return;
        }

        $project_stage_node_mission_map = [];
        foreach ($project_stage_node_mission as $key => $value){
            $tmp = $map[$value['id']] ?? [];
            $project_stage_node_mission[$key]['employee_title'] = $tmp['name'] ?? "";
            $project_stage_node_mission[$key]['employee_id'] = $tmp['name_id'] ?? "";

            $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();
        $map = [];
        $project_stage_node_id = array_column($project_stage_node, 'id');
        foreach ($project_stage_node_id as $value){
            //节点成员
            $return = $this->getProjectEmployee(['id' => $value], ProjectEmployee::type_three);
            $map[$value] = $return;
        }

        $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']): '';
            $tmp = $map[$value['id']] ?? [];
            $project_stage_node[$key]['employee_title'] = $tmp['name'] ?? "";
            $project_stage_node[$key]['employee_id'] = $tmp['name_id'] ?? "";

            $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();
        $map = [];
        $project_stage_id = array_column($project_stage, 'id');
        foreach ($project_stage_id as $value){
            //阶段成员
            $return = $this->getProjectEmployee(['id' => $value], ProjectEmployee::type_two);
            $map[$value] = $return;
        }
        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']): '';
            $tmp = $map[$value['id']] ?? [];
            $project_stage[$key]['employee_title'] = $tmp['name'] ?? "";
            $project_stage[$key]['employee_id'] = $tmp['name_id'] ?? "";

            $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','order_number')
            ->orderBy('id','desc');

        if(! empty($data['title'])) $model->where('title',$data['title']);
        if(! empty($data['order_number'])) $model->where('order_number',$data['order_number']);
        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;

        $project = array_column($data['data'], 'id');
        $map = $this->getProjectEmployee(['id' => $project], ProjectEmployee::type_one);
        $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();
        //获取当前阶段 当前阶段节点 已收金额
        $other_map = $this->getProjectOtherMessage($project);
        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']] ?? "";
            $tmp = $map[$value['id']] ?? [];
            $data['data'][$key]['employee_title'] = $tmp['name'] ?? "";
            $data['data'][$key]['employee_id'] = $tmp['name_id'] ?? "";

            //获取当前阶段 当前阶段节点 已收金额
            $tmp = $other_map[$value['id']] ?? [];
            $stage = $tmp['stage'] ?? [];
            $node = $tmp['node'] ?? [];
            $data['data'][$key]['current_stage_id'] = $stage['id'] ?? '';
            $data['data'][$key]['current_stage_title'] = $stage['title'] ?? '';
            $data['data'][$key]['current_stage_node_id'] = $node['id'] ?? '';
            $data['data'][$key]['current_stage_node_title'] = $node['title'] ?? '';
            $data['data'][$key]['receipt_amount'] = $tmp['receipt'] ?? '';
        }

        return $data;
    }

    public function projectRule(&$data, $is_check = true){
        if(empty($data['order_number'])) return [false, '项目编号不能为空'];
        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){
            $bool = Project::where('order_number',$data['order_number'])->exists();
        }else{
            if(empty($data['id'])) return [false, '项目ID不能为空'];
            $boolean = Project::where('id',$data['id'])->where('del_time',0)->exists();
            if(! $boolean) return [false, '项目不存在或已被删除'];

            $bool = Project::where('order_number',$data['order_number'])
                ->where('id','<>',$data['id'])
                ->exists();
        }
        if($bool) 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();

            $this->projectEmployee($data, ProjectEmployee::type_two, false);

            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();
            $data['id'] = $model->id;

            $this->projectEmployee($data, ProjectEmployee::type_two);

            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 {
            $this->projectEmployee($data, ProjectEmployee::type_two, false);

            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;

        $map = $this->getProjectEmployee(['id' => array_column($data['data'], 'id')], ProjectEmployee::type_two);
        $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']] ?? "";
            $tmp = $map[$value['id']] ?? [];
            $data['data'][$key]['employee_title'] = $tmp['name'] ?? "";
            $data['data'][$key]['employee_id'] = $tmp['name_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();

            $this->projectEmployee($data, ProjectEmployee::type_three, false);

            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();
            $data['id'] = $model->id;

            $this->projectEmployee($data, ProjectEmployee::type_three);

            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 {

            $this->projectEmployee($data, ProjectEmployee::type_three, false);

            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;

        $map = $this->getProjectEmployee(['id' => array_column($data['data'], 'id')],  ProjectEmployee::type_three);
        $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']] ?? "";
            $tmp = $map[$value['id']] ?? [];
            $data['data'][$key]['employee_title'] = $tmp['name'] ?? "";
            $data['data'][$key]['employee_id'] = $tmp['name_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->save();

            $this->projectEmployee($data, ProjectEmployee::type_four, false);

            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->save();
            $data['id'] = $model->id;

            $this->projectEmployee($data, ProjectEmployee::type_four);

            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 {
            $this->projectEmployee($data, ProjectEmployee::type_four, false);

            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','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;

        $map = $this->getProjectEmployee(['id' => array_column($data['data'], 'id')], ProjectEmployee::type_four);
        $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){
            $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']] ?? "";
            $tmp = $map[$value['id']] ?? [];
            $data['data'][$key]['employee_title'] = $tmp['name'] ?? "";
            $data['data'][$key]['employee_id'] = $tmp['name_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){
            $main = Project::where('del_time',0)
                ->where('id',$id)
                ->first();
            if(empty($main)) return [false, '项目不存在或已删除'];
            $main = $main->toArray();

            //项目成员
            $return = $this->getProjectEmployee($main, ProjectEmployee::type_one);
            $main['employee_title'] = $return['name'] ?? "";
            $main['employee_id'] = $return['name_id'] ?? "";

            //阶段
            $project_stage = ProjectStage::where('del_time',0)
                ->where('project_id',$id)
                ->get()->toArray();
            $map = [];
            $project_stage_id = array_column($project_stage, 'id');
            foreach ($project_stage_id as $value){
                //阶段成员
                $return = $this->getProjectEmployee(['id' => $value], ProjectEmployee::type_two);
                $map[$value] = $return;
            }
            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']): '';
                $tmp = $map[$value['id']] ?? [];
                $project_stage[$key]['employee_title'] = $tmp['name'] ?? "";
                $project_stage[$key]['employee_id'] = $tmp['name_id'] ?? "";
            }

            $main['children'] = $project_stage;

            return [true, $main];
        }elseif($type == 2){
            $main = ProjectStage::where('del_time',0)
                ->where('id',$id)
                ->first();
            if(empty($main)) return [false, '项目的阶段不存在或已删除'];
            $main = $main->toArray();

            //阶段成员
            $return = $this->getProjectEmployee($main, ProjectEmployee::type_two);
            $main['employee_title'] = $return['name'] ?? "";
            $main['employee_id'] = $return['name_id'] ?? "";

            //节点
            $project_stage_node = ProjectStageNode::where('del_time',0)
                ->where('project_stage_id',$id)
                ->get()->toArray();
            $map = [];
            $project_stage_node_id = array_column($project_stage_node, 'id');
            foreach ($project_stage_node_id as $value){
                //节点成员
                $return = $this->getProjectEmployee(['id' => $value], ProjectEmployee::type_three);
                $map[$value] = $return;
            }
            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']): '';

                $tmp = $map[$value['id']] ?? [];
                $project_stage_node[$key]['employee_title'] = $tmp['name'] ?? "";
                $project_stage_node[$key]['employee_id'] = $tmp['name_id'] ?? "";
            }
            $main['children'] = $project_stage_node;

            return [true, $main];
        }elseif($type == 3){
            $main = ProjectStageNode::where('del_time',0)
                ->where('id',$id)
                ->first();
            if(empty($main)) return [false, '项目阶段节点不存在或已删除'];
            $main = $main->toArray();

            //节点成员
            $return = $this->getProjectEmployee($main, ProjectEmployee::type_three);
            $main['employee_title'] = $return['name'] ?? "";
            $main['employee_id'] = $return['name_id'] ?? "";

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

            $map = [];
            $project_stage_node_mission_id = array_column($project_stage_node_mission, 'id');
            foreach ($project_stage_node_mission_id as $value){
                //任务成员
                $return = $this->getProjectEmployee(['id' => $value], ProjectEmployee::type_four);
                $map[$value] = $return;
            }
            foreach ($project_stage_node_mission as $key => $value){
                $tmp = $map[$value['id']] ?? [];
                $project_stage_node_mission[$key]['employee_title'] = $tmp['name'] ?? "";
                $project_stage_node_mission[$key]['employee_id'] = $tmp['name_id'] ?? "";
            }
            $main['children'] = $project_stage_node_mission;

            return [true, $main];
        }elseif ($type == 4){
            $main = ProjectStageNodeMission::where('del_time',0)
                ->where('id',$id)
                ->first();
            if(empty($main)) return [false, '项目阶段节点下该任务不存在或已删除'];
            $main = $main->toArray();

            //任务成员
            $return = $this->getProjectEmployee($main, ProjectEmployee::type_four);
            $main['employee_title'] = $return['name'] ?? "";
            $main['employee_id'] = $return['name_id'] ?? "";

            //任务报告
            $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']] ?? "";
            }
            $main['children'] = $project_stage_node_mission_detail;

            return [true, $main];
        }

        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 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;
    }

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

        $project = [];
        $stage = ProjectStage::whereIn('project_id', $project_id)
            ->where('del_time',0)
            ->select('id','title','receipt_amount','project_id')
            ->orderBy('id','desc')
            ->get()->toArray();

        foreach ($stage as $value){
            if(! isset($project[$value['project_id']]['stage'])){
                $project[$value['project_id']]['stage'] = [
                    'id' => $value['id'],
                    'title' => $value['title'],
                ];
            }

            if(isset($project[$value['project_id']]['receipt'])){
                $receipt = bcadd($value['receipt_amount'], $project[$value['project_id']]['receipt'],2);
                $project[$value['project_id']]['receipt'] = $receipt;
            }else{
                $project[$value['project_id']]['receipt'] = $value['receipt_amount'];
            }
        }

        $node = ProjectStageNode::whereIn('project_id', $project_id)
            ->where('del_time',0)
            ->select('id','title','project_id')
            ->get()->toArray();

        foreach ($node as $value){
            if(! isset($project[$value['project_id']]['node'])){
                $project[$value['project_id']]['node'] = [
                    'id' => $value['id'],
                    'title' => $value['title'],
                ];
            }
        }

        return $project;
    }
}