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', 'rp.date_added'); $this->view->page_num = $page = $reques->getRequest('page', 1); $this->view->filter_pr_id = $reques->getQuery('filter_pr_id'); $this->view->filter_prc_id = $reques->getQuery('filter_prc_id'); $this->view->filter_fullname = $reques->getQuery('filter_fullname'); $this->view->filter_username = $reques->getQuery('filter_username'); $this->view->filter_description = $reques->getQuery('filter_description'); $this->view->filter_board = $reques->getQuery('filter_board'); $this->view->categories = Model_Comments::getCommentReportCategories(); $url = ''; if ($this->view->filter_date_added) { $url .= '&filter_date_added=' . $this->view->filter_date_added; } if ($this->view->filter_pin_id) { $url .= '&filter_pin_id=' . $this->view->filter_pin_id; } if ($this->view->filter_fullname) { $url .= '&filter_fullname=' . $this->view->filter_fullname; } if ($this->view->filter_username) { $url .= '&filter_username='******'&filter_user_id=' . $this->view->filter_user_id; } if ($this->view->filter_description) { $url .= '&filter_description=' . $this->view->filter_description; } if ($this->view->filter_board) { $url .= '&filter_description=' . $this->view->filter_board; } $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 * JO_Registry::get('config_admin_limit') - JO_Registry::get('config_admin_limit'), 'limit' => JO_Registry::get('config_admin_limit'), 'sort' => $this->view->sort, 'order' => $this->view->order, 'filter_pr_id' => $this->view->filter_pr_id, 'filter_prc_id' => trim($this->view->filter_prc_id), 'filter_username' => trim($this->view->filter_username), 'filter_description' => trim($this->view->filter_description), 'filter_board' => trim($this->view->filter_board), 'filter_user_id' => $this->view->filter_user_id); $this->view->pins = array(); $pins = Model_Comments::getCommentsR($data); if ($pins) { foreach ($pins as $pin) { $pin['pin_href'] = WM_Router::create($reques->getBaseUrl() . '?controller=pin&pin_id=' . $pin['pin_id']); $pin['user_href'] = WM_Router::create($reques->getBaseUrl() . '?controller=users&action=profile&user_id=' . $pin['user_id']); $this->view->pins[] = $pin; } } $this->view->sort = strtolower($this->view->sort); $this->view->sort_pin_id = $reques->getModule() . '/reportedpins/?order=p.pin_id&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_date_added = $reques->getModule() . '/reportedpins/?order=rp.date_added&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_fullname = $reques->getModule() . '/reportedpins/?order=fullname&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $this->view->sort_username = $reques->getModule() . '/reportedpins/?order=u.username&sort=' . ($this->view->sort == 'asc' ? 'DESC' : 'ASC') . $url . $url2; $total_records = Model_Comments::getTotalCommentsR($data); $this->view->total_pages = ceil($total_records / JO_Registry::get('config_admin_limit')); $this->view->total_rows = $total_records; $pagination = new Model_Pagination(); $pagination->setLimit(JO_Registry::get('config_admin_limit')); $pagination->setPage($page); $pagination->setTotal($total_records); $pagination->setUrl($this->getRequest()->getModule() . '/reportedpins/?page={page}' . $url . $url1); $this->view->pagination = $pagination->render(); }