public static function getSliderWidget() { $model = new SliderTableModel(); $model->setTable('slider'); $model->readAllRecords(); $slides = $model->getAllRecords(); return Generator::sliderGenerator($slides); }
public function sliderAction() { $fc = FrontController::getInstance(); $model = new AdminModel('Слайдер', 'управление слайдами'); $sliderModel = new SliderTableModel(); $sliderModel->setTable('slider'); $page = $fc->getParams()['page'] ? filter_var($fc->getParams()['page'], FILTER_SANITIZE_NUMBER_INT) : 1; $limit = $fc->getParams()['limit'] ? filter_var($fc->getParams()['limit'], FILTER_SANITIZE_NUMBER_INT) : 10; $orderBy = $fc->getParams()['orderBy'] ? filter_var($fc->getParams()['orderBy'], FILTER_SANITIZE_STRING) : 'id'; $direction = $fc->getParams()['direction'] ? filter_var($fc->getParams()['direction'], FILTER_SANITIZE_STRING) : 'asc'; $offset = $limit * $page - $limit; $sliderModel->readAllRecords('*', "ORDER BY {$orderBy} " . strtoupper($direction) . " LIMIT {$limit} OFFSET {$offset}"); $model->setData(['slider' => $sliderModel->getAllRecords(), 'limit' => $limit, 'orderBy' => $orderBy, 'direction' => $direction, 'page' => $page, 'num' => (new AdminWidgets())->getNum('slider'), 'offset' => $offset]); $output = $model->render('../views/admin/slider/slider.php', 'admin'); $fc->setPage($output); }