private function showAction()
{
if (!current_user_can('wpProQuiz_show')) {
wp_die(__('You do not have sufficient permissions to access this page.'));
}
$view = new WpProQuiz_View_QuizOverall();
$m = new WpProQuiz_Model_QuizMapper();
$categoryMapper = new WpProQuiz_Model_CategoryMapper();
$per_page = (int) get_user_option('wp_pro_quiz_quiz_overview_per_page');
if (empty($per_page) || $per_page < 1) {
$per_page = 20;
}
$current_page = $this->getCurrentPage();
$search = isset($_GET['s']) ? trim($_GET['s']) : '';
$orderBy = isset($_GET['orderby']) ? trim($_GET['orderby']) : '';
$order = isset($_GET['order']) ? trim($_GET['order']) : '';
$offset = ($current_page - 1) * $per_page;
$limit = $per_page;
$filter = array();
if (isset($_GET['cat'])) {
$filter['cat'] = $_GET['cat'];
}
$result = $m->fetchTable($orderBy, $order, $search, $limit, $offset, $filter);
$view->quizItems = $result['quiz'];
$view->quizCount = $result['count'];
$view->categoryItems = $categoryMapper->fetchAll(WpProQuiz_Model_Category::CATEGORY_TYPE_QUIZ);
$view->perPage = $per_page;
$view->show();
}
