Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/app/Models/ |
Upload File : |
<?php
namespace App\Models;
use App\Scopes\ActiveScope;
use App\Traits\HasCompany;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Relations\HasMany;
use Illuminate\Database\Eloquent\Relations\HasOne;
/**
* App\Models\LeaveType
*
* @property int $id
* @property string $type_name
* @property string $color
* @property int $no_of_leaves
* @property \Illuminate\Support\Carbon|null $created_at
* @property \Illuminate\Support\Carbon|null $updated_at
* @property int $paid
* @property-read mixed $icon
* @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Leave[] $leaves
* @property-read int|null $leaves_count
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType newModelQuery()
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType newQuery()
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType query()
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereColor($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereCreatedAt($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereId($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereNoOfLeaves($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType wherePaid($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereTypeName($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereUpdatedAt($value)
* @property int|null $company_id
* @property int $monthly_limit
* @property-read \App\Models\Company|null $company
* @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Leave[] $leavesCount
* @property-read int|null $leaves_count_count
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereCompanyId($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereMonthlyLimit($value)
* @property int|null $effective_after
* @property string|null $effective_type
* @property string|null $unused_leave
* @property int $encashed
* @property int $allowed_probation
* @property int $allowed_notice
* @property string|null $gender
* @property string|null $marital_status
* @property string|null $department
* @property string|null $designation
* @property string|null $role
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereAllowedNotice($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereAllowedProbation($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereDepartment($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereDesignation($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereEffectiveAfter($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereEffectiveType($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereEncashed($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereGender($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereMaritalStatus($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereRole($value)
* @method static \Illuminate\Database\Eloquent\Builder|LeaveType whereUnusedLeave($value)
* @mixin \Eloquent
*/
class LeaveType extends BaseModel
{
use HasCompany;
public function leaves(): HasMany
{
return $this->hasMany(Leave::class, 'leave_type_id');
}
public function leavesCount(): HasOne
{
return $this->hasOne(Leave::class, 'leave_type_id')
->selectRaw('leave_type_id, count(*) as count, SUM(if(duration="half day", 1, 0)) AS halfday')
->groupBy('leave_type_id');
}
public static function byUser($user, $leaveTypeId = null, $status = array('approved'), $leaveDate = null)
{
if (!is_null($leaveDate)) {
$leaveDate = Carbon::createFromFormat(company()->date_format, $leaveDate);
}
else {
$leaveDate = Carbon::createFromFormat('d-m-Y', '01-'.company()->year_starts_from.'-'.now(company()->timezone)->year)->startOfMonth();
}
if (!$user instanceof User) {
$user = User::withoutGlobalScope(ActiveScope::class)->withOut('clientDetails', 'role')->findOrFail($user);
}
$setting = company();
if (isset($user->employee[0])) {
if ($setting->leaves_start_from == 'joining_date') {
$currentYearJoiningDate = Carbon::parse($user->employee[0]->joining_date->format((now(company()->timezone)->year) . '-m-d'));
if ($currentYearJoiningDate->isFuture()) {
$currentYearJoiningDate->subYear();
}
$leaveTypes = LeaveType::with(['leavesCount' => function ($q) use ($user, $currentYearJoiningDate, $status) {
$q->where('leaves.user_id', $user->id);
$q->whereBetween('leaves.leave_date', [$currentYearJoiningDate->copy()->toDateString(), $currentYearJoiningDate->copy()->addYear()->toDateString()]);
$q->whereIn('leaves.status', $status);
}])->select('leave_types.*', 'employee_details.notice_period_start_date', 'employee_details.probation_end_date',
'employee_details.department_id as employee_department', 'employee_details.designation_id as employee_designation',
'employee_details.marital_status as maritalStatus', 'users.gender as usergender', 'employee_details.joining_date')
->join('employee_leave_quotas', 'employee_leave_quotas.leave_type_id', 'leave_types.id')
->join('users', 'users.id', 'employee_leave_quotas.user_id')
->join('employee_details', 'employee_details.user_id', 'users.id')->where('users.id', $user->id);
if (!is_null($leaveTypeId)) {
$leaveTypes = $leaveTypes->where('leave_types.id', $leaveTypeId);
}
return $leaveTypes = $leaveTypes->get();
}
else {
$leaveTypes = LeaveType::with(['leavesCount' => function ($q) use ($user, $status, $leaveDate) {
$q->where('leaves.user_id', $user->id);
$q->whereBetween('leaves.leave_date', [$leaveDate->copy()->toDateString(), $leaveDate->copy()->addYear()->toDateString()]);
$q->whereIn('leaves.status', $status);
}])->select('leave_types.*', 'employee_details.notice_period_start_date', 'employee_details.probation_end_date',
'employee_details.department_id as employee_department', 'employee_details.designation_id as employee_designation',
'employee_details.marital_status as maritalStatus', 'users.gender as usergender', 'employee_details.joining_date')
->join('employee_leave_quotas', 'employee_leave_quotas.leave_type_id', 'leave_types.id')
->join('users', 'users.id', 'employee_leave_quotas.user_id')
->join('employee_details', 'employee_details.user_id', 'users.id')->where('users.id', $user->id);
}
if (!is_null($leaveTypeId)) {
$leaveTypes = $leaveTypes->where('leave_types.id', $leaveTypeId);
}
return $leaveTypes->get();
}
return collect();
}
public static function leaveTypeCodition($leave, $userRole)
{
$currentDate = Carbon::now()->format('Y-m-d');
$leaveRole = $leave->role;
if(!is_null($leave->effective_type) && !is_null($leave->effective_after)){
$effectiveDate = $leave->effective_type == 'days' ? Carbon::parse($leave->joining_date)->addDays($leave->effective_after)->format('Y-m-d') : Carbon::parse($leave->joining_date)->addMonths($leave->effective_after)->format('Y-m-d');
}
$probation = Carbon::parse($leave->probation_end_date)->format('Y-m-d');
$noticePeriod = Carbon::parse($leave->notice_period_start_date)->format('Y-m-d');
if((is_null($leave->probation_end_date) || ($leave->allowed_probation == 0 && $probation < $currentDate) || $leave->allowed_probation == 1) &&
(is_null($leave->notice_period_start_date) || ($leave->allowed_notice == 0 && $noticePeriod > $currentDate) || $leave->allowed_notice == 1) &&
(!is_null($leave->gender) && in_array($leave->usergender, json_decode($leave->gender))) &&
(!is_null($leave->marital_status) && in_array($leave->maritalStatus, json_decode($leave->marital_status))) &&
(!is_null($leave->department) && in_array($leave->employee_department, json_decode($leave->department))) &&
(!is_null($leave->designation) && in_array($leave->employee_designation, json_decode($leave->designation))) &&
(!is_null($leave->role) && array_intersect($userRole, json_decode($leaveRole))) &&
(is_null($leave->effective_after) || $currentDate > $effectiveDate)){ /** @phpstan-ignore-line */
return true;
}
return false;
}
}