all())->where('company_id',Auth::user()->company_id)->with(['createdBy', 'plan','group','asset'=>function($query){ $query->with('parent'); }]) ->simplePaginate(); return AssetRequirementResource::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); // } /** * Store a newly created resource in storage. */ public function store(CreateOrUpdateRequest $request) { $requirement = new Requirement(); $requirement->mergeFillable([ 'company_id', 'created_by', ]); $requirement->fill([ ...$request->all(), 'company_id' => Auth::user()->company_id, 'created_by' => Auth::id(), ]); $requirement->save(); return $this->created(); } /** * Display the specified resource. */ public function show(string $id) { $requirement = Requirement::query()->findOrFail($id); return new RequirementResource($requirement); } /** * Update the specified resource in storage. */ public function update(CreateOrUpdateRequest $request, string $id) { // $requiremen = Requirement::findOrFail($id); $requiremen->fill($request->all()); $requiremen->save(); return $this->noContent(); } /** * Remove the specified resource from storage. */ public function destroy(string $id) { $requiremen = Requirement::findOrFail($id); $requiremen->delete(); return $this->noContent(); } public function close(ClosedRequest $request,string $id){ $requiremen = Requirement::findOrFail($id); $requiremen->update([ ...$request->all(), 'status' =>RequirementStatus::CLOSED->value, ]); return $this->noContent(); } public function linkPlan(LinkPlanRequest $request, string $planId) { $plan = Plan::query()->findOrFail($planId); Requirement::query()->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()->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 $data) { $requirement = new Requirement(); $requirement->mergeFillable([ 'company_id', 'created_by', ]); $requirement->fill([ ...$data, 'company_id' => $companyId, 'created_by' => $created_by, 'status' => RequirementStatus::ACTIVE, 'mailto' => [], ]); $requirement->save(); } }); return $this->created(); } }