File manager

File manager - Edit - /home/autoph/public_html/projects/app/Http/Controllers/API/v1/TimelogController.php

Back
<?php namespace App\Http\Controllers\API\v1; use App\Http\Controllers\Controller; use Illuminate\Http\Request; use Illuminate\Http\Response; use Illuminate\Support\Facades\Validator; use App\Models\Timelog; use App\Models\Employee; use App\Models\TimelogSync; use App\Models\EmployeeSync; use Illuminate\Support\Facades\Cache; use Illuminate\Support\Facades\DB; use Illuminate\Validation\Rule; use PHPUnit\Event\Code\Throwable; class TimelogController extends Controller { // 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', ''); // // Generate a unique cache key based on request parameters // $cacheKey = 'companies_' . md5(json_encode([ // 'keyword' => $keyword, // 'perPage' => $perPage, // 'sortBy' => $sortBy, // 'sortType' => $sortType, // ])); // // Check if data exists in cache, otherwise execute the query and cache the result // $data = Cache::remember($cacheKey, 60, function () use ($keyword, $perPage, $sortBy, $sortType) { // return Timelog::where(function ($query) use ($keyword) { // $keyword = str_replace(" ", "%", $keyword); // $query->where('name', 'like', '%' . $keyword . '%') // ->orWhere('code', 'like', '%' . $keyword . '%'); // }) // ->when(!empty($sortBy) && !empty($sortType), function ($query) use ($sortBy, $sortType) { // $query->orderBy($sortBy, $sortType); // }) // ->paginate($perPage); // }); // return response()->json($data); // } public function getEmployeeTimelogs(string $id) { $year = date('Y'); $data = Timelog::where('employee_id', '=', $id)->whereYear('datetimelog', $year)->get(); // dd($data); return response()->json($data); } public function store(Request $request) { // Validate the incoming request data $validator = Validator::make($request->all(), [ 'employee_id' => [ 'required', ], 'time_keeping_id' => [ 'required', ], 'datetimelog' => [ '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); } dd($request->all()); DB::connection()->beginTransaction(); try { $data = Timelog::create($request->all()); DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully added!', 'status' => 'success', ],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 sync_bio(Request $request) { $employee = EmployeeSync::where('employee_id', '=', $request->time_keeping_id)->first(); if ($employee) { $request['employee_id'] = $employee->employee_id; } else { $request['employee_id'] = $request->time_keeping_id; } // dd($request->all()); // Validate the incoming request data $validator = Validator::make($request->all(), [ 'time_keeping_id' => [ 'required', ], 'datetimelog' => [ '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); } // dd($request->all()); DB::connection()->beginTransaction(); try { $data = TimelogSync::create($request->all()); DB::connection()->commit(); return response()->json([ 'message' => 'Record Successfully added!', 'status' => 'success', ],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 show(Request $request) { $dateTo = date('Y-m-d', strtotime($request->dateTo . '+1 day')); $query = Employee::with([ 'timelog' => function ($query) use ($request, $dateTo) { $query->whereBetween('datetimelog', [$request->dateFrom, $dateTo]); }, 'company', 'department' ])->where(['enabled' => 1]); if (!empty($request->employee_id)) { $query->where('employee_id', $request->employee_id); } if (!empty($request->department_id)) { $query->where('department_id', $request->department_id); } $data = $query->get(); return response()->json($data); } public function destroy(int $id) { $data = Timelog::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); } }

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings