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