get('page_size') ?? 10; $requirements = Requirement::filter($request->all()) ->allowed() ->where('company_id',Auth::user()->company_id) ->orderBy('created_at', $request->input('sort','desc')) ->with(['createdBy', 'plan','group','asset.parent','projects']) ->paginate($pageSize); return AssetRequirementResource::collection($requirements); } //公共Requirement查询 public function publicSearch(Request $request) { $pageSize=$request->get('page_size') ?? 10; $requirements = Requirement::filter($request->all()) ->allowed() ->where('company_id',Auth::user()->company_id) ->orderByDesc('created_at') ->paginate($pageSize); return RequirementSimpleResource::collection($requirements); } // public function byAsset(Request $request,string $assetId) // { // $requirements=Requirement::filter($request->all())->with(['createdBy', 'plan','group']) ->where('asset_id', $assetId)->simplePaginate(); // // return AssetRequirementResource::collection($requirements); // } public function export(Request $request) { return $this->downloadExcelHelper( new RequirementExport(), "requirement", $request->get("extension"), ); } /** * Store a newly created resource in storage. */ public function store(FileAssociationService $service, CreateOrUpdateRequest $request) { $requirement = new Requirement(); $requirement->mergeFillable([ 'company_id', 'created_by', ]); $service->check( $request->get("file_ids", []), FileObjectType::REQUIREMENT, $request->get("file_uuid"), ); $requirement->fill([ ...$request->all(), 'company_id' => Auth::user()->company_id, 'description' => $request->description? (new \App\Services\File\ImageUrlService)->interceptImageUrl($request->description) : null, 'created_by' => Auth::id(), ]); $requirement->save(); //如果选择了需求关联的项目,则同时进行关联 $projectsId = $request->get('project_id', []); if(!empty($projectsId) && $projectsId !== []){ foreach ($projectsId as $projectId){ ProjectRequirement::query()->firstOrCreate([ 'project_id' => $projectId, 'requirement_id' => $requirement->id, 'asset_id' => $request->asset_id, 'requirement_group_id'=> $request->requirement_group_id, ]); } } ActionRepository::createRequirement( $requirement, ObjectAction::CREATED ); $service->association($requirement->id); return $this->created(); } /** * Display the specified resource. */ public function show(string $id) { $requirement = Requirement::query()->allowed()->with('projects')->findOrFail($id); return new RequirementResource($requirement); } /** * Update the specified resource in storage. */ public function update(CreateOrUpdateRequest $request, string $id) { $requirement = Requirement::allowed()->findOrFail($id); $requirement->fill([ ...$request->all(), 'description' => $request->description? (new \App\Services\File\ImageUrlService)->interceptImageUrl($request->description) : null, ]); $changes = ModelChangeDetector::detector(ActionObjectType::REQUIREMENT, $requirement); DB::transaction(function () use ($requirement,$request) { ProjectRequirement::where('requirement_id', $requirement->id)->delete(); $requirement->save(); //如果选择了需求关联的项目,则同时进行关联 $projectsId=$request->project_id; if (!empty($request->project_id)){ foreach ($projectsId as $projectId){ ProjectRequirement::query()->firstOrCreate([ 'project_id' => $projectId, 'requirement_id' => $requirement->id, 'asset_id' => $request->asset_id, 'requirement_group_id'=> $request->requirement_group_id, ]); } } }); ActionRepository::createRequirement( $requirement, ObjectAction::EDITED,objectChanges: $changes ); return $this->noContent(); } /** * Remove the specified resource from storage. */ public function destroy(string $id) { $requirement = Requirement::query()->allowed()->with(['projects','tasks'])->findOrFail($id); $requirement->delete(); Approval::query()->where('object_type','requirement')->where('object_id',$id)->delete(); ActionRepository::createRequirement( $requirement, ObjectAction::DELETED ); return $this->noContent(); } public function close(Request $request,string $id){ $requirement = Requirement::allowed()->findOrFail($id); $requirement->status = RequirementStatus::CLOSED->value; $changes = ModelChangeDetector::detector(ActionObjectType::REQUIREMENT, $requirement); $requirement->save(); ActionRepository::createRequirement( $requirement, ObjectAction::CLOSED, $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null, objectChanges: $changes ); return $this->noContent(); } public function start(Request $request, string $id) { $requirement = Requirement::allowed()->findOrFail($id); $requirement->status = RequirementStatus::ACTIVE->value; $changes = ModelChangeDetector::detector(ActionObjectType::REQUIREMENT, $requirement); $requirement->save(); ActionRepository::createRequirement( $requirement, ObjectAction::STARTED, $request->comment?(new \App\Services\File\ImageUrlService)->interceptImageUrl($request->comment) : null, objectChanges: $changes ); return $this->noContent(); } public function linkPlan(LinkPlanRequest $request, string $planId) { $plan = Plan::query()->findOrFail($planId); Requirement::query()->allowed()->where("asset_id", $plan->asset_id) ->whereIn('id', $request->get("requirement_ids")) ->update([ 'plan_id' => $plan->id, ]); return $this->noContent(); } public function unlinkPlan(LinkPlanRequest $request) { Requirement::query()->allowed()->whereIn('id', $request->get("requirement_ids")) ->update([ 'plan_id' => null, ]); return $this->noContent(); } public function batchStore(BatchCreateRequest $request) { $requirementsData = $request->all(); $companyId = Auth::user()->company_id; $created_by = Auth::id(); DB::transaction(function () use ($requirementsData,$companyId,$created_by) { foreach ($requirementsData as $k => $data) { $requirement = new Requirement(); $requirement->mergeFillable([ 'company_id', 'created_by', ]); if($k != 0){ $requirementsData[$k]["requirement_group_id"] = $requirementsData[$k]["requirement_group_id"] == 'ditto'?$requirementsData[$k-1]["requirement_group_id"]:$requirementsData[$k]["requirement_group_id"]; $requirementsData[$k]["priority"] = $requirementsData[$k]["priority"] == 'ditto'? $requirementsData[$k-1]["priority"]: $requirementsData[$k]["priority"]; $requirementsData[$k]["plan_id"] = $requirementsData[$k]["plan_id"] == 'ditto'? $requirementsData[$k-1]["plan_id"]: $requirementsData[$k]["plan_id"]; $requirementsData[$k]["project_id"]=$requirementsData[$k]["project_id"] == 'ditto'? $requirementsData[$k-1]["project_id"]: $requirementsData[$k]["project_id"]; } $requirement->fill([ ...$requirementsData[$k], 'company_id' => $companyId, 'created_by' => $created_by, 'status' => RequirementStatus::ACTIVE, 'mailto' => [], ]); DB::transaction(function () use ($requirement,$requirementsData,$k) { $requirement->save(); //如果选择了需求关联的项目,则同时进行关联 $projectsId=$requirementsData[$k]['project_id']; if (!empty($projectsId)){ foreach ($projectsId as $projectId){ ProjectRequirement::query()->firstOrCreate([ 'project_id' => $projectId, 'requirement_id' => $requirement->id, 'asset_id' => $requirementsData[$k]['asset_id'], 'requirement_group_id'=> $requirementsData[$k]['requirement_group_id'], ]); } } }); ActionRepository::createRequirement( $requirement, ObjectAction::CREATED ); } }); return $this->created(); } public function import(Request $request) { Excel::import(new RequirementImport(), $request->file("file")); return $this->created(); } }