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