/** * Apply policy in existing employee * * @since 0.1 * * @param integer $policy_id * @param array $args * * @return void */ function erp_hr_apply_policy_existance_employee($policy_id, $args) { if ($args['instant_apply'] !== true) { return; } if ($args['activate'] == 2) { erp_hr_apply_policy_schedule(); } if ($args['activate'] == 1) { $active_employes = \WeDevs\ERP\HRM\Models\Employee::select('user_id')->where('status', 'active')->get()->toArray(); foreach ($active_employes as $key => $employee) { erp_hr_apply_new_employee_policy(intval($employee['user_id'])); } } }
/** * Get next seven days birthday * * @since 0.1 * * @return object [user_id, date_of_birth] */ function erp_hr_get_next_seven_days_birthday() { $db = new \WeDevs\ORM\Eloquent\Database(); return erp_array_to_object(\WeDevs\ERP\HRM\Models\Employee::select(array('user_id', 'date_of_birth'))->where($db->raw("DATE_FORMAT( `date_of_birth`, '%m %d' )"), '>', \Carbon\Carbon::today()->format('m d'))->where($db->raw("DATE_FORMAT( `date_of_birth`, '%m %d' )"), '<=', \Carbon\Carbon::tomorrow()->addWeek()->format('m d'))->get()->toArray()); }