function viewAction() { $fc = FrontController::getInstance(); $model = new FrontModel(); $id = filter_var($fc->getParams()['id'], FILTER_SANITIZE_NUMBER_INT); if (!$id) { header('Location: /admin/notFound'); exit; } $productModel = new ProductTableModel(); $productModel->setId($id); $productModel->setTable('product'); $ImageModel = new ImageTableModel(); $ImageModel->setId($id); $ImageModel->setTable('image'); $images = $ImageModel->readRecordsById('product_id', '*', 'ORDER BY main'); $product = $productModel->readRecordsById()[0]; $categoryModel = new CategoryTableModel(); $product['category'] = $categoryModel->getCategoryById($product['category_id'])['category_name']; $product['subCategory'] = $categoryModel->getSubCategoryById($product['subcategory_id'])['subcategory_name']; if (!$product) { header('Location: /admin/notFound'); exit; } $recProducts = (new IndexWidgets())->recAndPopProductsWidget('recommended'); $model->setData(['product' => $product, 'images' => $images, 'recommendedProducts' => Generator::recommendedProducts($recProducts)]); $output = $model->render('../views/product/product.php', 'withoutSlider'); $fc->setPage($output); }
protected function getCatsAndSubCats($flag = FALSE) { $condition = ''; $categoryModel = new CategoryTableModel(); $categoryModel->setTable('category'); $categoryModel->readAllRecords(); $subCategoryModel = new SubCategoryTableModel(); $subCategoryModel->setTable('subcategory'); if (!$flag) { $condition .= "WHERE subcategory.category_id = " . end($categoryModel->getAllRecords())['id']; } $subCategoryModel->readAllRecords('*', $condition); return ['cats' => array_reverse($categoryModel->getAllRecords()), 'subcats' => array_reverse($subCategoryModel->getAllRecords())]; }
public function deleteCategoryAction($id = NULL) { header('Content-type: text/plain; charset=utf-8'); header('Cache-Control: no-store, no-cache'); header('Expires: ' . date('r')); $id = Validate::validateInputVar('catid', 'INPUT_GET', 'int'); $this->deleteSubCategoryAction('category_id', $id); $model = new CategoryTableModel(); $model->setTable('category'); $model->setId($id); if ($model->deleteRecord()) { $this->getCategoriesAction(); } }
public function newCatAction() { $fc = FrontController::getInstance(); $model = new CategoryTableModel(); if ($_SERVER['REQUEST_METHOD'] === 'POST') { $model->setTable('category'); if ($model->setData()) { $model->addRecord(); } } // header('Location: ' . $_SERVER['HTTP_REFERER']); // exit; }