function getUsers()
{
$db = oseDB::instance();
$member = oseRegistry::call('member');
$post = JRequest::get('post');
$where = array();
$search = $post['search'];
if ($search) {
$searchQuery = $db->Quote('%' . $search . '%');
$where[] = "u.username LIKE {$searchQuery} OR u.name LIKE {$searchQuery} OR u.email LIKE {$searchQuery}";
}
$where = count($where > 0) ? oseDB::implodeWhere($where) : null;
$start = $post['start'];
$limit = $post['limit'];
$result['results'] = oseMemGroup::getUsers($where, $start, $limit);
//oseExit($db->_sql);
$result['total'] = oseMemGroup::getUsersTotal($where);
return $result;
}
function getUsers($post, $type = 'array')
{
$db = oseDB::instance();
$where = array();
$search = $post['search'];
if ($search) {
$searchQuery = $db->Quote('%' . $search . '%');
$where[] = "u.username LIKE {$searchQuery} OR u.name LIKE {$searchQuery} OR u.email LIKE {$searchQuery}";
}
$msc_id = oseObject::getValue($post, 'msc_id', 0);
//JRequest::getInt('msc_id','');
if (!empty($msc_id)) {
$msc_id = " AND msc_id = " . (int) $msc_id;
}
$where[] = "u.id NOT IN (SELECT member_id FROM `#__osemsc_member` WHERE `status` = '1' {$msc_id})";
$where = oseDB::implodeWhere($where);
$start = $post['start'];
$limit = $post['limit'];
$result['results'] = oseMemGroup::getUsers($where, $start, $limit);
$result['total'] = oseMemGroup::getUsersTotal($where);
return $result;
}
