public function indexAction() { $orderBy = array("1" => "price asc", "2" => "price desc", "3" => "discount asc", "4" => "discount desc"); $numberPage = 1; $query = Products::query(); // -> where("is_available=1"); if ($this->request->isPost()) { // SEARCH $name = $this->request->getPost("name"); $status = $this->request->getPost("status"); $category = $this->request->getPost("category"); $subcat = $this->request->getPost("subcat"); $order = $this->request->getPost("order"); if ($name != "") { $query->andWhere("name like '%{$name}%'"); } if ($category != "") { $query->andWhere("category_id={$category}"); } if ($subcat != "") { $query->andWhere("sub_category_id={$subcat}"); } if ($order != "") { $query->order($orderBy[$order]); } } if (!$status || $status == "") { $status = 'New'; } if ($status != "All") { $query->andWhere("status='{$status}'"); } $numberPage = $this->request->getQuery("page", "int"); $productList = $query->execute(); $products = new Paginator(array("data" => $productList, "limit" => 10, "page" => $numberPage)); $categories = Categories::find(); $statusTypies = ["New", "Confirmed", "Enabled", "Disabled", "Approved"]; $postData = $this->request->getPost(); $subcats = SubCategories::find(); $this->view->page = $products->getPaginate(); $this->view->categories = $categories; $this->view->subcats = $subcats; $this->view->statusTypies = $statusTypies; $this->view->postData = $postData; $this->view->orderBy = $orderBy; $this->view->status = $status; $this->view->categoriesJson = json_encode(Categories::find()->toArray()); $this->view->subCatsJson = json_encode($subcats->toArray()); }
/** * Deletes a categorie * * @param string $id */ public function deleteAction($id) { $categorie = SubCategories::findFirstByid($id); if (!$categorie) { $this->flash->error("categorie was not found"); return $this->dispatcher->forward(array("controller" => "subcat", "action" => "index")); } if (!$categorie->delete()) { foreach ($categorie->getMessages() as $message) { $this->flash->error($message); } return $this->dispatcher->forward(array("controller" => "subcat", "action" => "search")); } $this->flash->success("Subcat was deleted successfully"); return $this->dispatcher->forward(array("controller" => "subcat", "action" => "index")); }