public static function footerWidget() { $model = new ArticleTableModel(); $model->setTable('article'); $model->readAllRecords('id, title, main_image, created_time', 'ORDER BY created_time LIMIT 4'); return $model->getAllRecords(); }
public function getAllArticlesWidget($fields = '*', $condition = '') { $model = new ArticleTableModel(); $model->setTable('article'); $model->readAllRecords($fields, $condition); $records = $model->getAllRecords(); $userModel = new UserTableModel(); foreach ($records as $key => $record) { $userModel->setId($record['author']); $userModel->setTable('user'); $records[$key]['author_name'] = $userModel->readRecordsById('id', 'username')[0]['username']; } return $records; }
public function viewAction() { $fc = FrontController::getInstance(); $model = new FrontModel(); $articleModel = new ArticleTableModel(); $userModel = new UserTableModel(); $id = filter_var($fc->getParams()['id'], FILTER_SANITIZE_NUMBER_INT); if (!$id) { header('Location: /admin/notFound'); exit; } $articleModel->setId($id); $articleModel->setTable('article'); $article = $articleModel->readRecordsById(); $userModel->setId($article[0]['author']); $userModel->setTable('user'); $model->setData(['article' => $article, 'author' => $userModel->readRecordsById('id', 'id, username')]); $output = $model->render('../views/blog/view.php', 'withoutSlider'); $fc->setPage($output); }
public function deleteArticleAction() { header('Content-type: text/plain; charset=utf-8'); header('Cache-Control: no-store, no-cache'); header('Expires: ' . date('r')); if (filter_has_var(INPUT_POST, 'id')) { $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); } $model = new ArticleTableModel(); $model->setId($id); $model->setTable('article'); echo $model->deleteRecord(); }
public function addArticleAction() { $fc = FrontController::getInstance(); $model = new AdminModel('Блог', 'Новая статья'); $articleModel = new ArticleTableModel(); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $articleModel->setData(); $articleModel->addRecord(); Session::setMsg('Статья успешно добавлена', 'success'); header('Location: /admin/blog'); exit; } else { $output = $model->render('../views/admin/blog/addarticle.php', 'admin'); $fc->setPage($output); } }