json(['status' => 'failed', 'message' => 'project id is required!', 'code' => 400], 400); } $document = DokumenProject::where("ref_id", $id)->get(); if (count($document) == 0) return response()->json(['status' => '', 'message' => 'Data not found!', 'code' => 404], 404); return response()->json(['status' => 'success', 'data' => $document, 'code' => 200], 200); } public function delete($id) { if (empty($id) || !is_int((int)$id)) { return response()->json(['status' => 'failed', 'message' => 'id is required!', 'code' => 400], 400); } $document = DokumenProject::find($id); if (!$document) { return response()->json(['status' => 'failed', 'message' => 'Data not found!', 'code' => 400], 400); } $destinationPath = $this->setCustomeDirectoryUpload(); if (file_exists($destinationPath['pathDocument'] . $document['file'])) { unlink($destinationPath['pathDocument'] . $document['file']); } $document->delete(); return response()->json(['status' => 'success', 'message' => 'Data deleted!', 'code' => 200], 200); } public function uploadProjectDokumen(Request $request) { DB::beginTransaction(); $timeNow = Carbon::now(); if ($request->hasFile('dokumen')) { $document = $request->file('dokumen'); $ref_id = $request->ref_id; $originalFilename = $document->getClientOriginalName(); $extension = pathinfo($originalFilename, PATHINFO_EXTENSION); $filename = pathinfo($originalFilename, PATHINFO_FILENAME); $name = $filename . '_' . $timeNow->format('d-m-y-His') . '.' . $extension; $destinationPath = $this->setCustomeDirectoryUpload(); $data = [ 'ref_id' => (int)$ref_id, 'file' => $name, 'type_dokumen' => isset($request->type_dokumen) ? $request->type_dokumen : 'project-document' ]; $result = DokumenProject::create($data); if (!$document->move($destinationPath['pathDocument'], $name) && $result) { unlink($destinationPath['pathDocument'] . $name); DB::rollBack(); return response()->json(['status' => 'failed', 'message' => 'Dokumen project gagal diupload!', 'code' => 500], 500); } DB::commit(); return response()->json(['status' => 'success', 'message' => 'Dokumen project berhasil diupload!', 'code' => 200], 200); } DB::rollBack(); return response()->json(['status' => 'failed', 'message' => 'File is required!', 'code' => 400], 400); } public function searchDocProject(Request $request) { $payload = $request->all(); $dataBuilder = $this->setUpPayload($payload, 'document_project'); $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 downloadDokumen($id) { if (empty($id) || !is_int((int)$id)) { return response()->json(['status' => 'failed', 'message' => 'Id is required!', 'code' => 400], 400); } $document = DokumenProject::find($id); if (!$document) { return response()->json(['status' => 'failed', 'message' => 'Data not found!', 'code' => 404], 404); } $destinationPath = $this->setCustomeDirectoryUpload(); $pathToFile = $destinationPath['pathDocument'] . $document['file']; if (!file_exists($pathToFile)) { return response()->json(['status' => 'failed', 'message' => 'Directory not found!', 'code' => 404], 404); } $name = pathinfo($pathToFile, PATHINFO_FILENAME) . "." . pathinfo($pathToFile, PATHINFO_EXTENSION); $headers = [ 'Content-Disposition' => 'attachment; filename="' . $name . '"' ]; return response()->download($pathToFile, $name, $headers); } }