Change Categories List To Mfg's List on search.tpl

Code: Select all

if ($ manufacturer_id) {
				$data = array();
				
				$this->load->model('catalog/manufacturer');
				
				$string = rtrim($this->getPath($ manufacturer_id), ',');
				
				foreach (explode(',', $string) as $ manufacturer_id) {
					$data[] = " manufacturer_id = '" . (int)$ manufacturer_id . "'";
				}
				
				$sql .= " AND p.product_id IN (SELECT product_id FROM product_to_category WHERE " . implode(" OR ", $data) . ")";
			}

Code: Select all

if ($manufacturer_id) {
				$this->load->model('catalog/manufacturer');
				
				$string = $this->getManufacturer($manufacturer_id);
				$sql .= " AND p.product_id IN (SELECT product_id FROM product WHERE " . $string . ")";
			}

Code: Select all

if ($manufacturer_id) {
				$sql .= " AND p.manufacturer_id = '" . $manufacturer_id . "'";
			}

Code: Select all

SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM review r 
WHERE p.product_id = r.product_id 
GROUP BY r.product_id) AS rating FROM product p 
LEFT JOIN product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '1') 
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id AND p2s.store_id = '0') 
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) 
LEFT JOIN stock_status ss ON (p.stock_status_id = ss.stock_status_id AND ss.language_id = '1') 
WHERE pd.language_id = '1' AND (LCASE(pd.name) LIKE '%s2448c%' OR LCASE(p.model) LIKE '%s2448c%') AND p.status = '1' AND p.date_available <= NOW() 
GROUP BY p.product_id 
ORDER BY LCASE(p.model) ASC LIMIT 0,8

Code: Select all

public function getTotalProductsByKeyword($keyword, $category_id = 0, $description = FALSE, $model = FALSE) {