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; }
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 getMembers($msc_id, $status, $search = null, $start = 0, $limit = 20, $type = 'array') { $db = oseDB::instance(); $where = array(); if (!empty($search)) { $searchEscaped = strtolower($db->Quote('%' . $search . '%', false)); $searchEscaped = str_replace(" ", "%", $searchEscaped); $where[] = " LOWER(mem.username) LIKE {$searchEscaped} " . " OR LOWER(mem.name) LIKE {$searchEscaped} " . " OR LOWER(mem.email) LIKE {$searchEscaped} "; } if (is_array($msc_id)) { $msc_id = "('" . implode("','", $msc_id) . "')"; $where[] = ' mem.msc_id IN ' . $msc_id; //$db->Quote($msc_id); } else { $where[] = ' mem.msc_id = ' . $db->Quote($msc_id); } //$where[] = ' luv.group_name = '. $db->Quote('master'); if ($status == 1 || $status == 0) { $where[] = ' mem.status = ' . $db->Quote($status); } //$where = array_merge($where,oseJSON::generateQueryWhere()); // Generate the where query $where = count($where) ? ' WHERE (' . implode(') AND (', $where) . ')' : ''; $result = array(); $result['results'] = oseMemGroup::getMscMembers($msc_id, $where, $start, $limit); //oseExit($db->getQuery()); $result['total'] = oseMemGroup::getGroupTotal($msc_id, $where); return $result; }