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