PHP WeDevs\ERP\HRM\Models Employee::select示例

示例#1

文件： functions-leave.php 项目： ediamin/wp-erp

/**
 * 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']));
        }
    }
}

示例#2

文件： functions-employee.php 项目： ediamin/wp-erp

/**
 * 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());
}