public function __construct($username, $password)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
$query->where('email = ? OR username = ?', (string) $username);
$query->where('password = ?', (string) md5($password))->limit(1);
$response = $db->fetchRow($query);
$response = is_array($response) ? $response : array();
if ($response) {
$groups = unserialize($response['groups']);
if (is_array($groups) && count($groups) > 0) {
$query_group = $db->select()->from('user_groups')->where("ug_id IN (?)", new JO_Db_Expr(implode(',', array_keys($groups))));
$fetch_all = $db->fetchAll($query_group);
$response['access'] = array();
if ($fetch_all) {
foreach ($fetch_all as $row) {
$modules = unserialize($row['rights']);
if (is_array($modules)) {
foreach ($modules as $module => $ison) {
foreach ($ison as $m => $on) {
$response['access'][$module][$m] = $m;
}
}
}
}
}
}
parent::__construct($response);
new Model_Users_Edit($response['user_id'], array('last_login' => new JO_Db_Expr('NOW()')));
}
}
public function __construct($email)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
$query->where('users.email = ?', (string) $email)->limit(1);
$response = $db->fetchRow($query);
$response = is_array($response) ? $response : array();
parent::__construct($response);
}
public function __construct($board_id)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
$query->where('users.user_id IN (?)', new JO_Db_Expr('(' . $db->select()->from('users_boards', 'user_id')->where('board_id = ?', (string) $board_id)->where('allow = 1') . ')'));
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
parent::__construct($db->fetchAll($query));
}
public function __construct($data)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
//sort and limit add to query from Model_Users_Abstract
$query = self::sortOrderLimit($query, $data);
parent::__construct($db->fetchAll($query));
}
public function __construct($user_id)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
$query->where('users.user_id = ?', (string) $user_id)->limit(1);
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
$response = $db->fetchRow($query);
$response = is_array($response) ? $response : array();
parent::__construct($response);
}
public function __construct($data)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
if (is_array($data) && count($data) > 0) {
$query->where('users.user_id IN (?)', new JO_Db_Expr(implode(',', $data)));
} else {
$query->where('users.user_id = 0');
}
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
parent::__construct($db->fetchAll($query));
}
public function __construct($data)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQuery();
if (isset($data['filter_username']) && $data['filter_username']) {
$query->where('users.firstname LIKE ? OR users.lastname LIKE ? OR users.username LIKE ?', '%' . str_replace(' ', '%', $data['filter_username']) . '%');
} else {
$query->where('users.user_id = 0');
}
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
//sort and limit add to query from Model_Users_Abstract
$query = self::sortOrderLimit($query, $data);
parent::__construct($db->fetchAll($query));
}
public function __construct($data = array())
{
$db = JO_Db::getDefaultAdapter();
//select default users data
$query = self::getListUsersQuery();
if (isset($data['filter_followers_user_id']) && $data['filter_followers_user_id']) {
$query->where('user_id IN (SELECT user_id FROM users_following_user WHERE following_id = ?) OR user_id IN (SELECT user_id FROM users_following WHERE following_id = ?)', (string) $data['filter_followers_user_id']);
//$query->where('user_id IN (SELECT following_id FROM users_following_user WHERE user_id = ?) OR user_id IN (SELECT following_id FROM users_following WHERE user_id = ?)', (string)$data['filter_followers_user_id']);
} else {
$query->where('user_id = 0');
}
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
//sort and limit add to query from Model_Pins_Abstract
$query = self::sortOrderLimit($query, $data);
parent::__construct($db->fetchAll($query));
}
public function __construct($data)
{
$db = JO_Db::getDefaultAdapter();
//select default pin data
$query = self::getListUsersQueryLite();
//$query->where(new JO_Db_Expr('users.user_id = ? OR ('.$db->select()->from('users_following','COUNT(users_following_id)')->where('following_id = users.user_id AND user_id = ?')->orWhere('user_id = users.user_id AND following_id = ?')->limit(1) .') OR ('.$db->select()->from('users_following_user', 'COUNT(ufu_id)')->where('following_id = users.user_id AND user_id = ?')->orWhere('user_id = users.user_id AND following_id = ?')->limit(1).')'), JO_Session::get('user[user_id]'));
$sql1 = $db->select()->from('users_following', 'following_id')->where('user_id = ?');
$sql2 = $db->select()->from('users_following', 'user_id')->where('following_id = ?');
$sql3 = $db->select()->from('users_following_user', 'following_id')->where('user_id = ?');
$sql4 = $db->select()->from('users_following_user', 'user_id')->where('following_id = ?');
$query->where(new JO_Db_Expr('users.user_id = ? OR users.user_id IN (' . $sql1 . ') OR users.user_id IN (' . $sql2 . ') OR users.user_id IN (' . $sql3 . ') OR users.user_id IN (' . $sql4 . ')'), JO_Session::get('user[user_id]'));
if (isset($data['filter_username']) && $data['filter_username']) {
$query->where('users.firstname LIKE ? OR users.lastname LIKE ? OR users.username LIKE ?', '%' . str_replace(' ', '%', $data['filter_username']) . '%');
} else {
$query->where('users.user_id = 0');
}
//v2.2
if (Helper_Config::get('config_enable_follow_private_profile')) {
$query = self::filterFriend($query);
}
//sort and limit add to query from Model_Users_Abstract
$query = self::sortOrderLimit($query, $data);
parent::__construct($db->fetchAll($query));
}
