File manager - Edit - /home/autoph/public_html/projects/app/Http/Controllers/API/v1/ClearanceController.php
Back
<?php namespace App\Http\Controllers; namespace App\Http\Controllers\API\v1; use App\Http\Controllers\Controller; use App\Models\Clearance; use Exception; use Illuminate\Http\Request; use Illuminate\Http\Response; use Illuminate\Support\Facades\Auth; use Illuminate\Support\Facades\Validator; use Illuminate\Support\Facades\DB; use Illuminate\Support\Facades\Storage; use Illuminate\Validation\Rule; use PHPUnit\Event\Code\Throwable; use Illuminate\Support\Str; class ClearanceController extends Controller { /** * Display a listing of the resource. */ public function index(Request $request) { // $keyword = $request->input('keyword', ''); $perPage = $request->input('per_page',PHP_INT_MAX); $sortBy = $request->input('sortBy', ''); $sortType = $request->input('sortType', ''); $data = Clearance::with('template')->where(function ($query) use ($keyword) { $keyword = str_replace(" ", "%", $keyword); $query->where('date_accepted', 'like', '%' . $keyword . '%'); }); if (!empty($sortBy) && !empty($sortType)) { $data = $data->orderBy($sortBy, $sortType); } $data = $data->paginate($perPage); return response()->json($data); } public function store(Request $request) { $validator = Validator::make($request->all(), [ 'employee_id' => 'required', 'clearance_template_id' => 'required', 'reason_id' => 'required', 'date_accepted' => 'required|date', 'effectivity_date' => 'required|date', 'from_date' => 'required|date', 'to_date' => 'required|date', 'attachment' => 'required', ]); if ($validator->fails()) { return response()->json([ 'status' => false, 'message' => $validator->errors()->first(), 'errors' => $validator->errors() ], Response::HTTP_UNPROCESSABLE_ENTITY); } DB::beginTransaction(); try { $attachmentName = $this->handleAttachment($request); $status = Clearance::create([ 'employee_id' => $request->employee_id, 'clearance_template_id' => $request->clearance_template_id, 'reason_id' => $request->reason_id, 'shared_services' => $request->shared_services, 'date_accepted' => $request->date_accepted, 'to_company' => $request->to_company, 'effectivity_date' => $request->effectivity_date, 'from_date' => $request->from_date, 'to_date' => $request->to_date, 'note' => $request->note, 'attachment' => $attachmentName, ]); DB::commit(); return response()->json([ 'status' => true, 'message' => 'Saved successfully!', 'data' => $status ], Response::HTTP_CREATED); } catch(Throwable $e) { DB::rollBack(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ], Response::HTTP_INTERNAL_SERVER_ERROR); } } public function handleAttachment(Request $request) { if ($request->hasFile('attachment')) { $image = $request->file('attachment'); $attachmentName = time() . '_' . $image->getClientOriginalName(); $path = "employee-clearance/" . $attachmentName; if (Storage::disk('local')->put($path, file_get_contents($image))) { return $attachmentName; } throw new Exception('Unable to process attachment.'); } return ''; } public function update(Request $request) { $id = $request->id; $data = Clearance::where('id', $id)->first(); $validator = Validator::make($request->all(), [ 'employee_id' => 'required', 'clearance_template_id' => 'required', 'reason_id' => 'required', 'date_accepted' => 'required|date', 'effectivity_date' => 'required|date', 'from_date' => 'required|date', 'to_date' => 'required|date', 'attachment' => 'required', ]); /** If validation fails return with error message */ if ($validator->fails()) { $errors = $validator->errors(); $first = $errors->getMessages(); return response()->json([ 'status' => false, 'message' => (reset($first))[0], 'errors' => $errors ], Response::HTTP_UNPROCESSABLE_ENTITY); } $attachment_name = $request->attachment; if($data->attachment != $request->attachment) { $attachment_file_path = 'employee-clearance/' . $data->attachment; if(Storage::exists($attachment_file_path)) { Storage::delete($attachment_file_path); } if($request->hasFile('attachment')) { $image = $request->file('attachment'); $attachment_name = time().'_'.$image->getClientOriginalName(); $path = "employee-clearance/".$attachment_name; if(!Storage::disk('local')->put($path, file_get_contents($image))) { return response()->json(['message'=> "Failed to upload attachment"],304); } } else { $attachment_name = null; } } DB::connection()->beginTransaction(); try { $data->employee_id = $request->employee_id; $data->clearance_template_id = $request->clearance_template_id; $data->reason_id = $request->reason_id; $data->shared_services = $request->shared_services; $data->date_accepted = $request->date_accepted; $data->to_company = $request->to_company; $data->effectivity_date = $request->effectivity_date; $data->from_date = $request->from_date; $data->to_date = $request->to_date; $data->note = $request->note; $data->attachment = $attachment_name; $data->save(); DB::connection()->commit(); return response()->json([ 'status' => true, 'message' => 'Saved successfully!', 'data' => $data ],201); } catch (Throwable $e) { DB::connection()->rollback(); return response()->json([ 'status' => false, 'message' => 'Unable to process request. Please try again.', 'data' => $e->getMessage() ]); } } public function destroy(int $id) { $data = Clearance::find($id); if(!$data) { return response()->json(['message' => "Record not found!"],204); } DB::connection()->beginTransaction(); $data->delete(); DB::connection()->commit(); return response()->json(['message' => "Record successfully deleted!"],201); } public function removeAttachment(Request $request) { $id = $request->id; $attachment = $request->attachment; $data = Clearance::where('id', $id)->first(); $data->attachment = NULL; $data->save(); DB::connection()->commit(); $attachment_file_path = 'employee-clearance/' . $request->attachment; if(Storage::exists($attachment_file_path)) { Storage::delete($attachment_file_path); } return response()->json([ 'status' => true, 'message' => 'Saved successfully!', 'data' => $data ],201); } }
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.08 |
proxy
|
phpinfo
|
Settings