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