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/ |
<?php
namespace App\Repositories;
use App\DataTable\UserDataTable;
use App\Models\Appointment;
use App\Models\Country;
use App\Models\Doctor;
use App\Models\DoctorSession;
use App\Models\Patient;
use App\Models\Permission;
use App\Models\Qualification;
use App\Models\Specialization;
use App\Models\User;
use Arr;
use Carbon\Carbon;
use Hash;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
use Symfony\Component\HttpKernel\Exception\UnprocessableEntityHttpException;
use Yajra\DataTables\DataTables;
/**
* Class UserRepository
*/
class UserRepository extends BaseRepository
{
public $fieldSearchable = [
'first_name',
'last_name',
'email',
'contact',
'dob',
'specialization',
'experience',
'gender',
'status',
'password',
];
/**
* @inheritDoc
*/
public function getFieldsSearchable()
{
return $this->fieldSearchable;
}
/**
* @inheritDoc
*/
public function model()
{
return User::class;
}
/**
* @param array $input
*
* @return mixed
*/
public function store($input){
$addressInputArray = Arr::only($input,
['address1', 'address2', 'country_id', 'city_id', 'state_id', 'postal_code']);
$doctorArray = Arr::only($input, ['experience', 'twitter_url', 'linkedin_url', 'instagram_url']);
$specialization = $input['specializations'];
try {
DB::beginTransaction();
$input['email'] = setEmailLowerCase($input['email']);
$input['status'] = (isset($input['status'])) ? 1 : 0;
$input['password'] = Hash::make($input['password']);
$input['type'] = User::DOCTOR;
$doctor = User::create($input);
$doctor->assignRole('doctor');
$doctor->address()->create($addressInputArray);
$createDoctor = $doctor->doctor()->create($doctorArray);
$createDoctor->specializations()->sync($specialization);
if (isset($input['profile']) && !empty('profile')) {
$doctor->addMedia($input['profile'])->toMediaCollection(User::PROFILE, config('app.media_disc'));
}
DB::commit();
return $doctor;
}catch (\Exception $e){
throw new UnprocessableEntityHttpException($e->getMessage());
}
}
/**
* @param array $input
* @param int $doctor
*
*
* @return int
*/
public function update($input, $doctor)
{
$addressInputArray = Arr::only($input,
['address1', 'address2', 'city_id', 'state_id', 'country_id', 'postal_code']);
$doctorArray = Arr::only($input, ['experience', 'twitter_url', 'linkedin_url', 'instagram_url']);
$qualificationArray = json_decode($input['qualifications'], true);
$specialization = $input['specializations'];
try {
DB::beginTransaction();
$input['email'] = setEmailLowerCase($input['email']);
$input['status'] = (isset($input['status'])) ? 1 : 0;
$input['type'] = User::DOCTOR;
$doctor->user->update($input);
$doctor->user->address()->update($addressInputArray);
$doctor->update($doctorArray);
$doctor->specializations()->sync($specialization);
if (count($qualificationArray) >= 0) {
if (isset($input['deletedQualifications'])) {
Qualification::whereIn('id', explode(',', $input['deletedQualifications']))->delete();
}
foreach ($qualificationArray as $qualifications) {
if ($qualifications == null) {
continue;
}
if (isset($qualifications['id'])) {
$doctor->user->qualifications()->where('id', $qualifications['id'])->update($qualifications);
} else {
unset($qualifications['id']);
$doctor->user->qualifications()->create($qualifications);
}
}
}
if (isset($input['profile']) && ! empty('profile')) {
$doctor->user->clearMediaCollection(User::PROFILE);
$doctor->user->media()->delete();
$doctor->user->addMedia($input['profile'])->toMediaCollection(User::PROFILE, config('app.media_disc'));
}
DB::commit();
return $doctor;
}catch (\Exception $e){
throw new UnprocessableEntityHttpException($e->getMessage());
}
}
/**
* @param array $userInput
*
* @return bool
*/
public function updateProfile($userInput)
{
try {
DB::beginTransaction();
$user = Auth::user();
$user->update($userInput);
if ((getLogInUser()->hasRole('patient'))) {
if (! empty($userInput['image'])) {
$user->clearMediaCollection(Patient::PROFILE);
$user->patient->media()->delete();
$user->patient->addMedia($userInput['image'])->toMediaCollection(Patient::PROFILE,
config('app.media_disc'));
}
} else {
if ((! empty($userInput['image']))) {
$user->clearMediaCollection(User::PROFILE);
$user->media()->delete();
$user->addMedia($userInput['image'])->toMediaCollection(User::PROFILE, config('app.media_disc'));
}
}
DB::commit();
return true;
} catch (\Exception $e) {
DB::rollBack();
throw new UnprocessableEntityHttpException($e->getMessage());
}
}
/**
* @param $doctor
*
* @return mixed
*/
public function getSpecializationsData($doctor)
{
$data['specializations'] = Specialization::pluck('name', 'id')->toArray();
$data['doctorSpecializations'] = $doctor->specializations()->pluck('specialization_id')->toArray();
$data['countryId'] = $doctor->user->address()->pluck('country_id');;
$data['stateId'] = $doctor->user->address()->pluck('state_id');;
return $data;
}
/**
* @return mixed
*/
public function getCountries()
{
$countries = Country::pluck('name', 'id');
return $countries;
}
public function addQualification($input)
{
$input['user_id'] = $input['id'];
$qualification = Qualification::create($input);
return $qualification;
}
/**
* @param $input
*
* @throws \Exception
*
* @return array
*/
public function doctorDetail($input)
{
$todayDate = Carbon::now()->format('Y-m-d');
$doctor['data'] = Doctor::with([
'user.address', 'specializations', 'appointments.patient.user',
])->whereId($input->id)->first();
$doctor['doctorSession'] = DoctorSession::whereDoctorId($input->id)->get();
$doctor['appointments'] = DataTables::of((new UserDataTable())->getAppointment($input->id))->make(true);
$doctor['appointmentStatus'] = Appointment::ALL_STATUS;
$doctor['totalAppointmentCount'] = Appointment::whereDoctorId($input->id)->count();
$doctor['todayAppointmentCount'] = Appointment::whereDoctorId($input->id)->where('date', '=',
$todayDate)->count();
$doctor['upcomingAppointmentCount'] = Appointment::whereDoctorId($input->id)->where('date', '>',
$todayDate)->count();
return $doctor;
}
}