public static function loadByUserId($userId, $options = [])
{
$db = new Util\Data();
$db->buildQuery('select', self::getList());
$db->buildQuery('from', 'core_role r');
$db->buildQuery('join', 'core_user_role ur ON ur.role_id = r.id');
$db->buildQuery('where', 'ur.user_id = ' . $userId);
$db->extendQuery($options);
return self::mapList($db);
}
public static function loadFullComponents($options = [])
{
$db = new Util\Data();
$list = 'component.id AS componentId,
component.module_id AS componentModuleId,
CONCAT(module.title, \' - \', component.title) AS componentTitle';
$db->buildQuery('select', $list);
$db->buildQuery('from', 'cms_component component');
$db->buildQuery('join', 'cms_module module ON module.id = component.module_id');
$db->buildQuery('where', 'component.status = 1');
$db->buildQuery('where', 'module.status = 1');
$db->buildQuery('order', 'module.title, component.title');
$db->extendQuery($options);
return self::mapList($db);
}
public static function loadAll(array $options = [])
{
$db = new Util\Data();
$db->buildQuery('select', self::getList());
$db->buildQuery('from', 'core_user `user`');
$db->extendQuery($options);
return self::mapList($db);
}
