public function __construct($board_id) { $db = JO_Db::getDefaultAdapter(); //select default pin data $query = self::getListBoardsQuery(); $query->where('boards.board_id = ?', (string) $board_id); //v2.2 if (Helper_Config::get('config_enable_follow_private_profile')) { $query = self::filterFriend($query); } $query->limit(1); $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::getListBoardsQuery(); if (isset($data['where']) && $data['where'] instanceof JO_Db_Expr) { $query->where($data['where']); } //v2.2 if (Helper_Config::get('config_enable_follow_private_profile')) { $query = self::filterFriend($query); } $query = self::sortOrderLimit($query, $data); parent::__construct($db->fetchAll($query)); }
public function __construct($data = array()) { $db = JO_Db::getDefaultAdapter(); //select default pin data $query = self::getListBoardsQuery(); if (isset($data['filter_user_id']) && $data['filter_user_id']) { $query->where('boards.board_id IN (SELECT board_id FROM users_boards WHERE user_id = ? AND is_author = 0 AND allow = 0)', (string) $data['filter_user_id']); } else { $query->where('boards.board_id = 0'); } //v2.2 if (Helper_Config::get('config_enable_follow_private_profile')) { $query = self::filterFriend($query); } $query = self::sortOrderLimit($query, $data); parent::__construct($db->fetchAll($query)); }
public function __construct($data = array()) { $db = JO_Db::getDefaultAdapter(); //select default pin data $query = self::getListBoardsQuery(); //v2.2 if (Helper_Config::get('config_enable_follow_private_profile')) { if (JO_Session::get('user[user_id]') && JO_Session::get('user[user_id]') == (string) $data['filter_user_id']) { $query->where('boards.user_id = ? OR boards.board_id IN (SELECT board_id FROM users_boards WHERE user_id = ? AND allow = 1 AND (SELECT user_id FROM users WHERE user_id = ? AND public = 1))', (string) JO_Session::get('user[user_id]')); } else { $query->where('(boards.user_id = ? AND users.public = 1) OR boards.board_id IN (SELECT board_id FROM users_boards WHERE user_id = ? AND allow = 1 AND (SELECT user_id FROM users WHERE user_id = ? AND public = 1))', (string) $data['filter_user_id']); } } else { $query->where('boards.user_id = ? OR boards.board_id IN (SELECT board_id FROM users_boards WHERE user_id = ? AND allow = 1)', (string) $data['filter_user_id']); } $query = self::sortOrderLimit($query, $data); parent::__construct($db->fetchAll($query)); }
public function __construct($data = array()) { $db = JO_Db::getDefaultAdapter(); //select default pin data $query = self::getListBoardsQueryLite(); $query->where("(boards.user_id = ? OR boards.board_id IN (SELECT DISTINCT board_id FROM users_boards WHERE user_id = ? AND allow = 1))", (string) JO_Session::get('user[user_id]')); if (isset($data['filter_title']) && $data['filter_title']) { $data['filter_title'] = str_replace(' ', '%', $data['filter_title']); $data['filter_title'] = preg_replace('/([\\%]{2,})/', '%', $data['filter_title']); $query->where('boards.title LIKE ?', '%' . (string) $data['filter_title'] . '%'); } else { $query->where('boards.board_id = 0'); } //v2.2 if (Helper_Config::get('config_enable_follow_private_profile')) { $query = self::filterFriend($query); } $query = self::sortOrderLimit($query, $data); parent::__construct($db->fetchAll($query)); }
public function __construct($data = array()) { $db = JO_Db::getDefaultAdapter(); //select default pin data $query = self::getListBoardsQuery(); $query->where('boards.pins > 0'); if (isset($data['filter_title']) && $data['filter_title']) { $data['filter_title'] = str_replace(' ', '%', $data['filter_title']); $data['filter_title'] = preg_replace('/([\\%]{2,})/', '%', $data['filter_title']); $query->where('boards.title LIKE ?', '%' . (string) $data['filter_title'] . '%'); } else { $query->where('boards.board_id = 0'); } //v2.2 if (Helper_Config::get('config_enable_follow_private_profile')) { $query = self::filterFriend($query); } $query = self::sortOrderLimit($query, $data); parent::__construct($db->fetchAll($query)); }
public function __construct($title, $user_id = 0, $category_id = 0) { $db = JO_Db::getDefaultAdapter(); $user_id = $user_id ? $user_id : JO_Session::get('user[user_id]'); //select default pin data $query = self::getListBoardsQuery(); $query->where('boards.title LIKE ?', $title)->where('boards.user_id = ?', $user_id); $query->limit(1); $response = $db->fetchRow($query); if (!$response) { $result = new Model_Boards_Create(array('title' => $title, 'category_id' => $category_id, 'user_id' => $user_id)); if ($result->board_id) { $board_data = new Model_Boards_Board($result->board_id); if ($board_data) { $response = $board_data->toArray(); } } } $response = is_array($response) ? $response : array(); parent::__construct($response); }