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; }