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