public function init() { $site = new Model_Site(); $products = new Model_Products(); $all_menus = $site->AllMenus(); foreach ($all_menus as $menu_id => $menu) { $menu_key = 'menu_' . $menu_id; $this->view->{$menu_key} = $menu; } $this->view->widget_blurb = $site->widget_blurb(); //@todo to be removed soon $this->view->pagetypes = $this->pageTypes(); //echo '<pre>'; print_r($products->bestSeller()); exit; $this->view->best_sellers = $products->bestSeller(); $this->view->featured_products = $products->featuredProducts(); }
public function init() { parent::init(); $site = new Model_Site(); $page = new Model_Page(); $categories = new Model_Categories(); $products = new Model_Products(); $all_menus = $site->AllMenus(); foreach ($all_menus as $menu_id => $menu) { $menu_key = 'menu_' . $menu_id; $this->view->{$menu_key} = $menu; } $this->view->category_menu = $site->categoryMenu(); $categoryTree = $categories->listCategoryTree(); $this->view->categoryTree = $categoryTree; $this->view->widget_blurb = $site->widget_blurb(); //@todo to be removed soon $this->view->categories = $page->displayCategories(null, 12); $this->view->Brands = $site->ListBrands(); $this->view->best_sellers = $products->bestSeller(); $this->view->featured_products = $products->featuredProducts(); }
public function bestsellersAction() { $this->view->errorMessage = ''; $BestSellers = new Model_Bestsellers(); if ($this->_getParam('add_best_seller') != '') { $bestSellerItem = $BestSellers->getData('best_sellers', 'ProductID=' . $this->_getParam('add_best_seller'), null, 1); if (empty($bestSellerItem)) { $order = $BestSellers->selectNextOrder(); $BestSellers->insertData('best_sellers', array('ProductID' => $this->_getParam('add_best_seller'), 'order' => $order)); } else { $this->view->errorMessage = 'Product that you have selected already exist in the best seller list.'; } } if ($this->_getParam('delete_best_seller') != '') { if ($this->_getParam('delete_best_seller') == 'all') { $BestSellers->deleteData('best_sellers', ''); } else { $BestSellers->deleteData('best_sellers', 'ProductID = ' . $this->_getParam('delete_best_seller')); } } if ($this->_getParam('up_best_seller') != '') { $bestSellerItem = $BestSellers->getData('best_sellers', 'ProductID=' . $this->_getParam('up_best_seller'), null, 1); if (!empty($bestSellerItem[0])) { $order = $bestSellerItem[0]['order']; $bestSellerItemBefore = $BestSellers->getData('best_sellers', '`order` < ' . $order, '`order` desc', 1); if (!empty($bestSellerItemBefore[0])) { $BestSellers->updateData('best_sellers', array('order' => $bestSellerItemBefore[0]['order']), 'ProductID=' . $this->_getParam('up_best_seller')); $BestSellers->updateData('best_sellers', array('order' => $order), 'ProductID=' . $bestSellerItemBefore[0]['ProductID']); } } } if ($this->_getParam('down_best_seller') != '') { $bestSellerItem = $BestSellers->getData('best_sellers', 'ProductID=' . $this->_getParam('down_best_seller'), null, 1); if (!empty($bestSellerItem[0])) { $order = $bestSellerItem[0]['order']; $bestSellerItemAfter = $BestSellers->getData('best_sellers', '`order` > ' . $order, '`order` asc', 1); if (!empty($bestSellerItemAfter[0])) { $BestSellers->updateData('best_sellers', array('order' => $bestSellerItemAfter[0]['order']), 'ProductID=' . $this->_getParam('down_best_seller')); $BestSellers->updateData('best_sellers', array('order' => $order), 'ProductID=' . $bestSellerItemAfter[0]['ProductID']); } } } if ($this->_getParam('default_setting') == 'true') { $BestSellers->setDefaultSetting(); } $products = new Model_Products(); $this->view->bestSellersList = $products->bestSeller(); $where = "where 1"; if ($_POST) { if (isset($_POST['q1']) && !empty($_POST['q1'])) { $where .= " and t2.Name like '%" . $_POST['q1'] . "%' or t2.Name like '" . $_POST['q1'] . "%'"; } if (isset($_POST['q2']) && !empty($_POST['q2'])) { $where .= " and t2.Code = '" . $_POST['q2'] . "' "; } if (isset($_POST['q3']) && !empty($_POST['q3'])) { $where .= " and t5.DiscPrice = '" . $_POST['q3'] . "' "; } if (isset($_POST['q4']) && !empty($_POST['q4'])) { $where .= " and t5.Price = '" . $_POST['q4'] . "' "; } if (isset($_POST['q5']) && !empty($_POST['q5'])) { $where .= " and t1.Quantity = '" . $_POST['q5'] . "' "; } } //$list = $products->ListProducts("",$where,"",1); //set to forcebuild $sql = "select t1.Quantity, t1.Minimum, t2.ID ProductID, t2.*, t3.ID CategoryID, t3.Name CatName, t4.ID BrandID, t4.Name BrandName, t5.Currency, t5.Price, t5.DiscPrice, t5.DiscRate, t5.isDefault , t6.Filename , t8.Attributes\n\t\tfrom Store t1 join Products t2 on t1.ProductID = t2.ID \n\t\tleft join ProductCategory t7 on t1.ProductID = t7.ProductID \n\t\tleft join Category t3 on t7.CategoryID = t3.ID join Brands t4 on t1.BrandID = t4.ID \n\t\tleft join Prices t5 on t1.ProductID = t5.ProductID \n\t\tleft join ProductImages t6 on t6.ProductID = t2.ID \n\t\tleft join ProductAttributes t8 on t8.ProductID = t2.ID\n\t\t" . $where . " \n\t\tgroup by t2.ID order by t2.Created Desc"; //echo $sql;exit; $list = $products->oldSkul($sql); if (count($list) > 0) { $paginator = Zend_Paginator::factory($list); $this->paginator($list); } else { $this->view->nodata = true; } }