all(), [ 'name' => 'required|string', 'uom' => 'required|string', 'unit_price' => 'required|integer', 'description' => 'required', 'status' => 'nullable|string|max:80', 'qty' => 'nullable', 'created_by' => 'nullable|string|max:80', 'updated_by' => 'nullable|string|max:80', ]); if ($validator->fails()) { return response()->json(['status' => 'failed', 'message' => 'add data material resource failed!', 'code' => 400], 400); } $validated = $validator->validated(); $validated['description'] = trim($validated['description']); $validated['created_by'] = $this->currentName; $result = MaterialResource::create($validated); if ($result) { return response()->json(['status' => 'success', 'message' => 'add data material resource successfully!', 'code' => 200], 200); } else { return response()->json(['status' => 'failed', 'message' => 'add data material resource failed!', 'code' => 400], 400); } } public function edit($id) { if (empty($id)) { return response()->json(['status' => 'failed', 'message' => 'id is required!', 'code' => 400], 400); } $result = MaterialResource::find($id); if ($result) { return response()->json(['status' => 'success', 'code' => 200, 'data' => $result], 200); } else { return response()->json(['status' => 'failed', 'message' => 'failed get data material resource, please try again later!', 'code' => 400], 400); } } public function update(Request $request, $id) { if (empty($id)) { return response()->json(['status' => 'failed', 'message' => 'id is required!', 'code' => 400], 400); } $data = MaterialResource::find($id); if ($data) { $validator = Validator::make($request->all(), [ 'name' => 'required|string', 'uom' => 'required|string', 'unit_price' => 'required|integer', 'description' => 'required', 'status' => 'nullable|string|max:80', 'qty' => 'nullable', 'created_by' => 'nullable|string|max:80', 'updated_by' => 'nullable|string|max:80', ]); if ($validator->fails()) { return response()->json(['status' => 'failed', 'message' => 'data material resource failed updated!', 'code' => 400], 400); } $validated = $validator->validated(); $result = $data->update($validated); if ($result) { return response()->json(['status' => 'success', 'message' => 'data material resource successfully updated!', 'code' => 200], 200); } else { return response()->json(['status' => 'failed', 'message' => 'data material resource failed updated!', 'code' => 400], 400); } } else { return response()->json(['status' => 'failed', 'message' => 'data material resource not found!', 'code' => 400], 400); } } public function delete($id) { $data = MaterialResource::find($id); if ($data) { $delete = $data->delete(); if ($delete) { return response()->json(['status' => 'success', 'message' => 'data material resource successfully deleted!', 'code' => 200], 200); } else { return response()->json(['status' => 'failed', 'message' => 'data material resource failed deleted!', 'code' => 400], 400); } } else { return response()->json(['status' => 'failed', 'message' => 'data material resource not found!', 'code' => 400], 400); } } public function search(Request $request) { $payload = $request->all(); $dataBuilder = $this->setUpPayload($payload, 'm_material_resource'); $builder = $dataBuilder['builder']; $countBuilder = $dataBuilder['count']; $dataGet = $builder->get(); $totalRecord = $countBuilder->count(); return response()->json(['status' => 'success', 'code' => 200, 'data' => $dataGet, 'totalRecord' => $totalRecord], 200); } public function list() { $data = MaterialResource::all(); $countData = $data->count(); if ($data && $countData) { return response()->json(['status' => 'success', 'code' => 200, 'data' => $data, 'totalRecord' => $countData], 200); } else { return response()->json(['status' => 'failed', 'message' => 'failed get list material resource, please try again later!', 'code' => 400], 400); } } public function select(Request $request) { $search = $request->query('search'); $projectId = $request->idProyek; if ($search && !empty($search)) { $data = RequestMaterial::where("description", 'ILIKE', '%' . $search . '%')->get(); } else { $data = RequestMaterial::where("proyek_id", $projectId)->get(); } return response()->json($data); } }