/** * Function is responsible for listing the ALL of the products from * the database without querying for any categories. * * @return unknown|string */ function getAllServices() { $db =& $this->getDBO(); $db->resetTree(); $db->setTree('SELECT', '`' . $this->_tbl . '`.*'); $db->setTree('FROM', '`#__rel_serv_cca`'); $db->setTree('INNER JOIN', '`' . $this->_tbl . '` ON `#__rel_serv_cca`.bizid=' . $this->_tbl . '.bizid'); $db->setTree('WHERE', '`#__rel_serv_cca`.catid = ' . $db->Quote('108')); if (BRequest::getCmd('p', false) == 'h' && BRequest::getCmd('s', false) == 'r' && BRequest::getCmd('r', false) == 'o') { $db->setTree('ORDER BY', '`' . $this->_tbl . '`.`price` DESC'); } elseif (BRequest::getCmd('p', false) == 'l' && BRequest::getCmd('s', false) == 'r' && BRequest::getCmd('r', false) == 'o') { $db->setTree('ORDER BY', "`{$this->_tbl}`.`price` ASC"); } elseif (BRequest::getCmd('s', false) == 'l' && BRequest::getCmd('r', false) == 'o') { //@todo doesn't work as expected $db->setTree('SELECT', "sum((`likes`.`like`)) AS `tlikes`"); $db->setTree('LEFT JOIN', "`likes` ON `{$this->_tbl}`.`id` = `likes`.`itemid`"); $db->setTree('ORDER BY', "tlikes ASC"); } elseif (BRequest::getCmd('s', false) == 'r' && BRequest::getCmd('r', false) == 'n') { $db->setTree('ORDER BY', "`{$this->_tbl}`.`dateAdded` DESC"); } elseif (BRequest::getCmd('s', false) == 'r' && BRequest::getCmd('r', false) == 'o') { $db->setTree('ORDER BY', "`{$this->_tbl}`.`dateAdded` ASC"); } elseif (BRequest::getCmd('s', false) == 'r') { //@todo doesn't work as expected $db->setTree('SELECT', "sum((`ratings`.`like`)) AS `ratingsum`"); $db->setTree('LEFT JOIN', "`ratings` ON `{$this->_tbl}`.`id` = `ratings`.`itemid`"); $db->setTree('ORDER BY', "ratingsum ASC"); } //default ordering if (empty($sql['ORDER BY'])) { $db->setTree('ORDER BY', "`{$this->_tbl}`.dateAdded ASC"); } $per_page = config('products.per_page'); $db->setTree('LIMIT', $per_page); if ($offset = (BRequest::getInt('ppage', 1) - 1) * $per_page) { $db->setTree('OFFSET', $offset); } $q = $db->queryTree(); //echo _520($q); if ($results = $db->loadList($this->_tbl_key, $this->_type)) { return $results; } return false; }
function old__construct() { global $path_site; global $cl; // CONTENT LOGIC FUNCTIONS global $meta_desc; global $meta_keywords; global $title; $action = BRequest::getCmd('action'); $method = BRequest::getCmd('method'); $call = BRequest::getCmd('call'); // a call is an ajax call. // TRACK LAST PAGE // $last = lastURL(); $returnmsg = NULL; // INIT OBJECTS if (!BRequest::getVar('category', false)) { unset($_SESSION['assortment'], $_SESSION['category'], $_SESSION['collection']); } if (BRequest::getVar('category', false)) { $title .= ucwords(BRequest::getString('category')) . ' - '; unset($_SESSION['assortment'], $_SESSION['collection']); } if (BRequest::getVar('collection', false)) { $title .= ucwords(BRequest::getString('collection')) . ' - '; unset($_SESSION['assortment']); } if (BRequest::getVar('category', false) && !isset($_SESSION['category']) || BRequest::getVar('category', false) && $_SESSION['category'] != BRequest::getString('category')) { $_SESSION['category'] = BRequest::getVar('category'); } if (BRequest::getVar('collection', false) && !isset($_SESSION['collection']) || BRequest::getVar('collection', false) && $_SESSION['collection'] != BRequest::getVar('collection')) { $_SESSION['collection'] = BRequest::getVar('collection'); } if (BRequest::getVar('assortment', false) && !isset($_SESSION['assortment']) || BRequest::getVar('assortment', false) && $_SESSION['assortment'] != BRequest::getVar('assortment')) { $title .= ucwords(BRequest::getString('assortment')) . ' - '; $_SESSION['assortment'] = BRequest::getVar('assortment'); } // AJAX CALLS START \\ if ($call == 'sl') { if ((BRequest::getVar('i', false) and preg_match('/^[0-9]{1,20}$/i', BRequest::getInt('i'))) && (isset($method) and preg_match('/^[a-z]{4,20}$/i', $method))) { $return = $this->set('like'); } else { $return = 0; } print $return; exit; } if ($call == 'sr') { if ((BRequest::getVar('i', false) and preg_match('/^[0-9]{1,20}$/i', BRequest::getInt('i'))) && (isset($method) and preg_match('/^[a-z]{4,20}$/i', $method))) { $return = $this->set('rating'); } else { $return = 0; } print $return; exit; } /* // CALL CONTENT AND REPLACE TAGS INSIDE $content = ABSPATH.'/inc/cb/index.inc'; $returnOutput = new main_output($content); // replace tags from template @ $returnOutput->replace_tags(array( 'path_site' => SITE_BASEURL, 'side_nav' => $cl->get_sideNav(), 'collections' => $cl->get_boxOne('collections'), 'assortments' => $cl->get_boxOne('assortments'), 'sm_icons_index' => $cl->get_smicons('index'), 'news_events' => $cl->get_boxTwo('news'), 'this_month' => '', 'advertise_banner' => rand(1, 2), 'think_global_shop_local' => $cl->get_boxSeven('tgsl'), 'pm_bill_of_rights' => $cl->get_boxSeven('bor'), 'our_favorite_things' => '', // $cl->get_boxSeven('oft'), 'category_calendar' => $cl->get_boxSeven('cm'), 'banner' => $cl->get_banner(), 'content' => $this->get_content() //'page_title' => $page_title_txt, )); // Call the output $this->output = $returnOutput->output;*/ }