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/Repositories/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace App\Repositories;

use App\Models\Doctor;
use App\Models\DoctorSession;
use App\Models\User;
use Carbon\Carbon;
use DateTime;
use Illuminate\Support\Arr;
use Illuminate\Support\Collection;
use Illuminate\Support\Facades\DB;
use Symfony\Component\HttpKernel\Exception\UnprocessableEntityHttpException;

/**
 * Class DoctorSessionRepository
 * @package App\Repositories
 * @version July 31, 2021, 6:04 am UTC
 */
class DoctorSessionRepository extends BaseRepository
{
    /**
     * @var array
     */
    protected $fieldSearchable = [
        'session_time',
    ];

    /**
     * Return searchable fields
     *
     * @return array
     */
    public function getFieldsSearchable()
    {
        return $this->fieldSearchable;
    }

    /**
     * Configure the Model
     **/
    public function model()
    {
        return DoctorSession::class;
    }

    /**
     *
     * @return Collection
     */
    public function getSyncList()
    {
        if (getLogInUser()->hasRole('doctor')) {
            return Doctor::with('user')->where('user_id', getLogInUserId())->get()->pluck('user.full_name', 'id');
        }

        return Doctor::with('user')->whereNotIn('id',
            DoctorSession::pluck('doctor_id')->toArray())->get()->where('user.status',
            User::ACTIVE)->pluck('user.full_name', 'id');
    }

    /**
     * @param $input
     * @return array|bool[]|false
     */
    public function store($input)
    {
        try {
            DB::beginTransaction();
            /** @var DoctorSession $doctorSession */
            $doctorSession = DoctorSession::create(Arr::only($input, (new DoctorSession())->fillable));
            $result['success'] = true;
            if (! empty($input['checked_week_days']) && count($input['checked_week_days']) > 0) {
                foreach ($input['checked_week_days'] as $day) {
                    $exists = DB::table('session_week_days')
                        ->where('doctor_id', $input['doctor_id'])
                        ->where('day_of_week', $day)
                        ->exists();

                    if ($exists) {
                        return false;
                    }
                    $result = $this->validateSlotTiming($input, $day);
                    if (! $result['success']) {
                        return $result;
                    }
                    $this->saveSlots($input, $day, $doctorSession);
                }
            }

            DB::commit();

            return $result;

        } catch (\Exception $e) {
            throw new UnprocessableEntityHttpException($e->getMessage());
        }

    }

    /**
     * @param  array  $input
     *
     * @param  DoctorSession  $doctorSession
     *
     * @return array|bool[]
     */
    public function updateDoctorSession(array $input, DoctorSession $doctorSession)
    {
        try {
            DB::beginTransaction();
            $doctorId = $doctorSession->doctor_id;
            $doctorSession->update($input);
            $result['success'] = true;

            $doctorSession->sessionWeekDays()->delete();
            if (! empty($input['checked_week_days'])) {
                foreach ($input['checked_week_days'] as $day) {
                    $result = $this->validateSlotTiming($input, $day);
                    if (! $result['success']) {
                        return $result;
                    }
                    $this->saveSlots($input, $day, $doctorSession);
                }
            }

            DB::commit();

            return $result;

        } catch (\Exception $e) {
            throw new UnprocessableEntityHttpException($e->getMessage());
        }
    }

    /**
     * @param $input
     * @param $day
     * @param $doctorSession
     * @return bool
     */
    public function saveSlots($input, $day, $doctorSession)
    {
        /** @var DoctorSession $doctorSession */
        $startTimeArr = $input['startTimes'][$day] ?? [];
        $endTimeArr = $input['endTimes'][$day] ?? [];
        if (count($startTimeArr) != 0 && count($endTimeArr) != 0) {
            foreach ($startTimeArr as $key => $startTime) {
                $startTimeData = explode(' ', $startTime);
                $endTimeData = explode(' ', $endTimeArr[$key]);
                $doctorSession->sessionWeekDays()->create([
                    'doctor_id'         => $doctorSession->doctor_id,
                    'doctor_session_id' => $doctorSession->id,
                    'day_of_week'       => $day,
                    'start_time'        => $startTimeData[0],
                    'start_time_type'   => $startTimeData[1],
                    'end_time'          => $endTimeData[0],
                    'end_time_type'     => $endTimeData[1],
                ]);
            }
        }

        return true;
    }

    public function validateSlotTiming($input, $day)
    {
        $startTimeArr = $input['startTimes'][$day] ?? [];
        $endTimeArr = $input['endTimes'][$day] ?? [];
        foreach ($startTimeArr as $key => $startTime) {
            $slotStartTime = Carbon::instance(DateTime::createFromFormat('h:i A', $startTime));
            $tempArr = Arr::except($startTimeArr, [$key]);
            foreach ($tempArr as $tempKey => $tempStartTime) {
                $start = Carbon::instance(DateTime::createFromFormat('h:i A', $tempStartTime));
                $end = Carbon::instance(DateTime::createFromFormat('h:i A', $endTimeArr[$tempKey]));
                if ($slotStartTime->isBetween($start, $end)) {
                    return ['day' => $day, 'startTime' => $startTime, 'success' => false, 'key' => $key];
                }
            }
        }

        return ['success' => true];
    }
}