public function indexAction() { if ($this->session->get('successfu_edite')) { $this->view->successfu_edite = true; $this->session->clear('successfu_edite'); } if ($this->session->get('error_permision')) { $this->view->error_permision = $this->session->get('error_permision'); $this->session->clear('error_permision'); } $reques = $this->getRequest(); $this->view->sort = $reques->getRequest('sort', 'DESC'); $this->view->order = $reques->getRequest('order', 'p.board_id'); $this->view->page_num = $page = $reques->getRequest('page', 1); $this->view->filter_board_id = $reques->getQuery('filter_board_id'); $this->view->filter_user_id = $reques->getQuery('filter_user_id'); $this->view->filter_board_name = $reques->getQuery('filter_board_name'); $this->view->filter_username = $reques->getQuery('filter_username'); $url = ''; if ($this->view->filter_board_id) { $url .= '&filter_dic_id=' . $this->view->filter_board_id; } if ($this->view->filter_board_name) { $url .= '&filter_board_name=' . $this->view->filter_board_name; } if ($this->view->filter_username) { $url .= '&filter_username='******'&filter_user_id=' . $this->view->filter_user_id; } $url1 = ''; if ($this->view->sort) { $url1 .= '&sort=' . $this->view->sort; } if ($this->view->order) { $url1 .= '&order=' . $this->view->order; } $url2 = '&page=' . $page; $data = array('start' => $page * Helper_Config::get('config_admin_limit') - Helper_Config::get('config_admin_limit'), 'limit' => Helper_Config::get('config_admin_limit'), 'sort' => $this->view->sort, 'order' => $this->view->order, 'filter_board_id' => $this->view->filter_board_id, 'filter_board_name' => trim($this->view->filter_board_name), 'filter_username' => trim($this->view->filter_username), 'filter_user_id' => $this->view->filter_user_id); $this->view->boards = array(); $boards = Model_Boards::getBoards($data); if ($boards) { foreach ($boards as $board) { $board['board_href'] = WM_Router::create($reques->getBaseUrl() . '?controller=board&board_id=' . $board['board_id']); $board['user_href'] = WM_Router::create($reques->getBaseUrl() . '?controller=users&action=profile&user_id=' . $board['user_id']); $board['shared'] = Model_Boards::boardShared($board['board_id']); $this->view->boards[] = $board; } } $this->view->sort = strtolower($this->view->sort); $this->view->sort_board_id = $reques->getModule() . '/boards/?order=p.board_id&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_total_views = $reques->getModule() . '/boards/?order=p.total_views&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_followers = $reques->getModule() . '/boards/?order=p.followers&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_pins = $reques->getModule() . '/boards/?order=p.pins&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_username = $reques->getModule() . '/boards/?order=u.username&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $total_records = Model_Boards::getTotalBoards($data); $this->view->total_pages = ceil($total_records / Helper_Config::get('config_admin_limit')); $this->view->total_rows = $total_records; $pagination = new Model_Pagination(); $pagination->setLimit(Helper_Config::get('config_admin_limit')); $pagination->setPage($page); $pagination->setTotal($total_records); $pagination->setUrl($this->getRequest()->getModule() . '/boards/?page={page}' . $url . $url1); $this->view->pagination = $pagination->render(); }