/**
* Named scope for customer users
* @param unknown $query
*/
public function scopeCustomer($query)
{
$query->leftJoin('user_to_role', 'user.id', '=', 'user_to_role.user_id');
$query->leftJoin('role', 'role.id', '=', 'user_to_role.role_id');
$query->groupBy('user.id');
return $query->where('role.value', '=', 'role_customer');
}
/**
*
* @param unknown $query
*/
public function scopePopular($query)
{
return $query->where('votes', '>', 100);
}
/**
* Named scope for customer category
* @param unknown $query
*/
public function scopeCustomer($query)
{
return $query->where('permission.category', '=', 'customer');
}
/**
* Named scope for geting custom features only
* @param unknown $query
*/
public function scopeCustom($query)
{
return $query->where('system', '=', 0);
}
/**
* Query scope for filtering admin users
* @param unknown $query
*/
public function scopeAdmin($query)
{
$id = \DB::table('user_group')->where(['name' => 'admin'])->value('id');
return $query->where('user_group_pk_id', '=', $id);
}
/**
* Query scope for filtering admins
* @param unknown $query
*/
public function scopeUser($query)
{
return $query->where('name', '=', 'user');
}
/**
* Method for the create where commands for filter function
*
* @param unknown $query
* @param unknown $db
* @return string where command for audiotrack list filtering
*/
public function setFilters($query, $db)
{
$app = JFactory::getApplication();
$user = JFactory::getUser();
// Filter by Artist / Band.
if ($artist = $app->getUserStateFromRequest('filter.artist', 'filter_artist')) {
$query->where('a.artist = "' . $db->escape($artist) . '"');
}
// Filter by Category.
if ($category_id = $app->getUserStateFromRequest('filter.category_id', 'filter_category_id')) {
$query->where('a.catid = ' . (int) $category_id);
}
// Filter by Category.
if ($access_id = $app->getUserStateFromRequest('filter.access_id', 'filter_access_id')) {
$query->where('a.access = ' . (int) $access_id);
}
// Filter by User.
if ($user_id = $app->getUserStateFromRequest('filter.user_id', 'filter_user_id')) {
$query->where('a.add_by = ' . (int) $user_id);
}
// Filter by Album.
if ($album = $app->getUserStateFromRequest('filter.album', 'filter_album')) {
$query->where('a.album = "' . $db->escape($album) . '"');
}
// Filter by Year.
if ($year = $app->getUserStateFromRequest('filter.year', 'filter_year')) {
$query->where('a.year = ' . (int) $year);
}
// Filter by User.
if (JAccess::check($user->get('id'), 'core.admin') != 1) {
$query->where('a.add_by = ' . $user->get('id'));
}
return $query;
}
/**
* Query scope for filtering prirmary contact number
* @param unknown $query
*/
public function scopePrimary($query)
{
return $query->where('primary', '=', '1');
}
/**
* Named scope for protected navs
* @param unknown $query
*/
public function scopeProtected($query)
{
return $query->where('navigation.protected', '=', 1);
}
/**
* Chỉ hiện thị các bài viết (Article) đã lựa chọn cho phép hiển thị
*
* @param unknown $query
*/
public function scopeActive($query)
{
$query->where('status', 1);
}
/**
* Named scope for geting inactive roles only
* @param unknown $query
*/
public function scopeInactive($query)
{
return $query->where('active', '=', 0);
}
