/**
* get all role to show grid in admin
*
* @return model
*/
public static function getAllItemGrid()
{
$pager = General::getPagerOption();
$model = self::orderBy($pager['order'], $pager['dir']);
$model = $model->select('user.id as id', 'user.name as name', 'user.email as email', 'role.name as role_name')->leftJoin('role', 'role.id', '=', 'user.role_id');
$filter = Input::get('filter');
BaseModel::filterGrid($model);
$model = $model->paginate($pager['limit']);
return $model;
}
/**
* get all role to show grid in admin
*
* @return model
*/
public static function getAllItemGrid()
{
$pager = General::getPagerOption();
$model = self::orderBy($pager['order'], $pager['dir']);
$model = $model->select('role.id as id', 'role.name as name', 'role_group.name as group_name')->join('role_group', 'role_group.id', '=', 'role.role_group_id');
$filter = Input::get('filter');
self::filterGrid($model);
$model = $model->paginate($pager['limit']);
return $model;
}
/**
* get all role to show grid in admin
*
* @return model
*/
public static function getAllItemGrid()
{
$pager = General::getPagerOption();
$model = self::orderBy($pager['order'], $pager['dir']);
$model = $model->select('id', 'name');
$filter = Input::get('filter');
if ($filter && count($filter)) {
foreach ($filter as $key => $value) {
if (is_array($value)) {
if (isset($value['from']) && $value['from']) {
$model = $model->where($key, '>=', $value['from']);
}
if (isset($value['to']) && $value['to']) {
$model = $model->where($key, '<=', $value['to']);
}
} else {
$model = $model->where($key, 'like', "%{$value}%");
}
}
}
$model = $model->paginate($pager['limit']);
return $model;
}