Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/clinic.corals.io/app/Http/Controllers/ |
<?php
namespace App\Http\Controllers;
use App\DataTables\DoctorSessionDataTable;
use App\Http\Requests\CreateDoctorSessionRequest;
use App\Http\Requests\UpdateDoctorSessionRequest;
use App\Models\Appointment;
use App\Models\ClinicSchedule;
use App\Models\DoctorSession;
use App\Models\WeekDay;
use App\Repositories\DoctorSessionRepository;
use Carbon\Carbon;
use DateTime;
use Exception;
use Illuminate\Contracts\Foundation\Application;
use Illuminate\Contracts\View\Factory;
use Illuminate\Contracts\View\View;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\RedirectResponse;
use Illuminate\Http\Request;
use Illuminate\Routing\Redirector;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Laracasts\Flash\Flash;
use Response;
use Symfony\Component\HttpKernel\Exception\UnprocessableEntityHttpException;
use Yajra\DataTables\DataTables;
class DoctorSessionController extends AppBaseController
{
/** @var DoctorSessionRepository */
private $doctorSessionRepository;
public function __construct(DoctorSessionRepository $doctorSessionRepo)
{
$this->doctorSessionRepository = $doctorSessionRepo;
}
/**
* Display a listing of the DoctorSession.
*
* @param Request $request
* @throws Exception
* @return Application|Factory|View|Response
*/
public function index(Request $request)
{
if ($request->ajax()) {
return Datatables::of((new DoctorSessionDataTable())->get())->make(true);
}
return view('doctor_sessions.index');
}
/**
* Show the form for creating a new DoctorSession.
*
* @return Application|Factory|View
*/
public function create()
{
$doctorsList = $this->doctorSessionRepository->getSyncList();
return view('doctor_sessions.create', compact('doctorsList'));
}
/**
* Store a newly created DoctorSession in storage.
*
* @param CreateDoctorSessionRequest $request
*
* @return JsonResponse
*/
public function store(CreateDoctorSessionRequest $request)
{
$input = $request->all();
$result = $this->doctorSessionRepository->store($input);
if (! $result['success']) {
return $this->sendError($result);
}
return $this->sendSuccess('Schedule created successfully.');
}
/**
* Display the specified DoctorSession.
*
* @param DoctorSession $doctorSession
* @return Application|Factory|View
*/
public function show(DoctorSession $doctorSession)
{
if (empty($doctorSession)) {
Flash::error('Doctor Session not found.');
return redirect(getDoctorSessionURL());
}
return view('doctor_sessions.show', compact('doctorSession'));
}
/**
* Show the form for editing the specified DoctorSession.
*
* @param $id
* @return Application|Factory|View
*/
public function edit($id)
{
if (getLogInUser()->hasRole('doctor')) {
$doctorSession = DoctorSession::with('doctor.user')->whereDoctorId(getLogInUser()->doctor->id)->first();
} else {
$doctorSession = DoctorSession::with('doctor.user')->findOrFail($id);
}
$doctorsList = $this->doctorSessionRepository->getSyncList();
if (empty($doctorSession)) {
Flash::error('Schedule not found.');
return redirect(route('doctor-sessions.index'));
}
$sessionWeekDays = $doctorSession->sessionWeekDays;
return view('doctor_sessions.edit', compact('doctorSession', 'doctorsList', 'sessionWeekDays'));
}
/**
* Update the specified DoctorSession in storage.
*
* @param UpdateDoctorSessionRequest $request
* @param DoctorSession $doctorSession
* @return JsonResponse
*/
public function update(UpdateDoctorSessionRequest $request, DoctorSession $doctorSession)
{
if (empty($doctorSession)) {
return $this->sendError('Doctor Session not found.');
}
$result = $this->doctorSessionRepository->updateDoctorSession($request->all(), $doctorSession);
if (! $result['success']) {
return $this->sendError($result);
}
return $this->sendSuccess('Schedule updated successfully.');
}
/**
* Remove the specified DoctorSession from storage.
*
* @param DoctorSession $doctorSession
* @return JsonResponse
*/
public function destroy(DoctorSession $doctorSession)
{
try {
DB::beginTransaction();
$doctorSession->delete();
$doctorSession->sessionWeekDays()->delete();
DB::commit();
return $this->sendSuccess('Schedule deleted successfully.');
} catch (Exception $e) {
throw new UnprocessableEntityHttpException($e->getMessage());
}
}
/**
* @param Request $request
*
* @throws Exception
* @return JsonResponse
*/
public function getDoctorSession(Request $request)
{
$doctorId = $request->get('doctorId');
$timezone_offset_minutes = $request->get('timezone_offset_minutes');
// Convert minutes to seconds
$timezone_name = timezone_name_from_abbr("", $timezone_offset_minutes*60, false);
$date = Carbon::createFromFormat('Y-m-d', $request->date);
$doctorWeekDaySessions = WeekDay::whereDayOfWeek($date->dayOfWeek)->whereDoctorId($doctorId)->with('doctorSession')->get();
if ($doctorWeekDaySessions->count() == 0) {
return $this->sendError('There is no available slots on given date.');
}
$appointments = Appointment::whereDoctorId($doctorId)->whereIn('status',
[Appointment::BOOKED, Appointment::CHECK_IN, Appointment::CHECK_OUT])->get();
$bookedSlot = [];
$bookingSlot = [];
foreach ($appointments as $appointment) {
if ($appointment->date == $request->date) {
$bookedSlot[] = $appointment->from_time.' '.$appointment->from_time_type.' - '.$appointment->to_time.' '.$appointment->to_time_type;
}
}
foreach ($doctorWeekDaySessions as $index => $doctorWeekDaySession) {
date_default_timezone_set($timezone_name);
$doctorSession = $doctorWeekDaySession->doctorSession;
// convert 12 hours to 24 hours
$startTime = date("H:i", strtotime($doctorWeekDaySession->full_start_time));
$endTime = date("H:i", strtotime($doctorWeekDaySession->full_end_time));
$slots = $this->getTimeSlot($doctorSession->session_meeting_time, $startTime, $endTime);
$gap = $doctorSession->session_gap;
$isSameWeekDay = (Carbon::now()->dayOfWeek == $date->dayOfWeek) && (Carbon::now()->isSameDay($date));
foreach ($slots as $key => $slot) {
$key--;
if ($key != 0) {
$slotStartTime = date('h:i A',
strtotime('+'.$gap * $key.' minutes', strtotime($slot[0])));
$slotEndTime = date('h:i A',
strtotime('+'.$gap * $key.' minutes', strtotime($slot[1])));
if (strtotime($doctorWeekDaySession->full_end_time) < strtotime($slotEndTime)) {
break;
}
if (strtotime($slotStartTime) < strtotime($slotEndTime)) {
if (($isSameWeekDay && strtotime($slotStartTime) > strtotime(date('h:i A'))) || ! $isSameWeekDay) {
$startTimeOrg = Carbon::parse(date('h:i A', strtotime($slotStartTime)));
$slotStartTimeCarbon = Carbon::parse(date('h:i A', strtotime($startTime)));
$slotEndTimeCarbon = Carbon::parse(date('h:i A', strtotime($endTime)));
if (! $startTimeOrg->between($slotStartTimeCarbon, $slotEndTimeCarbon)) {
break;
}
$bookingSlot[] = $slotStartTime.' - '.$slotEndTime;
}
}
} else {
if (($isSameWeekDay && strtotime($slot[0]) > strtotime(date('h:i A'))) || ! $isSameWeekDay) {
$bookingSlot[] = date('h:i A', strtotime($slot[0])).' - '.date('h:i A', strtotime($slot[1]));
}
}
}
}
$slots = [
'bookedSlot' => ! empty($bookedSlot) ? $bookedSlot : null,
'slots' => $bookingSlot,
];
return $this->sendResponse($slots, 'Retrieved successfully.');
}
/**
* @throws Exception
*/
function getTimeSlot($interval, $start_time, $end_time)
{
$start = new DateTime($start_time);
$end = new DateTime($end_time);
$carbonStart = Carbon::createFromFormat('H:i',$start_time);
$carbonEnd = Carbon::createFromFormat('H:i',$end_time);
$startTime = $start->format('H:i');
$endTime = $originalEndTime = $end->format('H:i');
$i = 0;
$time = [];
while (strtotime($startTime) <= strtotime($endTime)) {
$start = $startTime;
$end = date('H:i', strtotime('+'.$interval.' minutes', strtotime($startTime)));
$startTime = date('H:i', strtotime('+'.$interval.' minutes', strtotime($startTime)));
if (! Carbon::createFromFormat('H:i', $start)->isBetween($carbonStart,
$carbonEnd) || ! Carbon::createFromFormat('H:i', $end)->isBetween($carbonStart, $carbonEnd)) {
break;
}
$i++;
if (strtotime($startTime) <= strtotime($endTime)) {
$time[$i][] = $start;
$time[$i][] = $end;
}
if (strtotime($startTime) >= strtotime($originalEndTime)) {
break;
}
if (strtotime($start) >= strtotime($end)) {
break;
}
}
return $time;
}
/**
* @param Request $request
*
* @return mixed
*/
public function getSlotByGap(Request $request)
{
$gap = $request->get('gap');
$day = $request->get('day');
$clinicSchedule = ClinicSchedule::whereDayOfWeek($day)->first();
$slots = getSlotByGap($clinicSchedule->start_time, $clinicSchedule->end_time);
$html = view('doctor_sessions.slot', ['slots' => $slots, 'day' => $day])->render();
return $this->sendResponse($html, 'Retrieved successfully.');
}
/**
*
* @return Application|Factory|View|RedirectResponse|Redirector
*/
public function doctorScheduleEdit()
{
$doctorSession = DoctorSession::whereDoctorId(getLogInUser()->doctor->id)->first();
if (empty($doctorSession)) {
Flash::error('Schedule not found.');
return redirect(route('doctor-sessions.index'));
}
$doctorsList = $this->doctorSessionRepository->getSyncList();
$sessionWeekDays = $doctorSession->sessionWeekDays;
return view('doctor_sessions.edit', compact('doctorSession', 'doctorsList', 'sessionWeekDays'));
}
}