Sort Order - more than one category?

Code: Select all

// ######################################################################################################
// ## START: New sort code that looks for a meta tag in the section description to sort the products.
// ## Put in the category description via the admin panel source view. Note you must unview source view
// ## for it to save in the admin panel.
// ## <meta name="sortorder" content="21536,16146,16133">
// ######################################################################################################
		$sortflag = 0;
 		if ( (isset($data['sort']) && in_array($data['sort'], $sort_data) && ($data['sort'] == 'p.sort_order')) || !(isset($data['sort']) && in_array($data['sort'], $sort_data))   ){
				$description = '';
				$sortordersql = "select description from oc_category_description where category_id=".$data['filter_category_id']." limit 1";
				$query = $this->db->query($sortordersql);
				foreach ($query->rows as $result) {
					$description = $result['description'];
				}
				$pattern = '/&lt;meta.*?name=&quot;sortorder&quot;.*?content=&quot;(.*)?&quot;&gt;/i';
				$matches = array();
				$sortorder = '';
				if ( preg_match($pattern, $description, $matches) ){
					$sortorder = $matches[1];
				}
				if(!empty($sortorder)){
					$sql .= " ORDER BY IF(FIELD(p.product_id,$sortorder)=0,1,0),FIELD(p.product_id,$sortorder)";
					$sortflag = 1;
				}
		}
		if (!$sortflag) {
// ##################################################################################
// ## START: Original unmodified sorting code
// ##################################################################################
			if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
				if ($data['sort'] == 'pd.name' || $data['sort'] == 'p.model') {
					$sql .= " ORDER BY LCASE(" . $data['sort'] . ")";
				} elseif ($data['sort'] == 'p.price') {
					$sql .= " ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END)";
				} else {
					$sql .= " ORDER BY " . $data['sort'];
				}
			} else {
				$sql .= " ORDER BY p.sort_order";
			}
// ##################################################################################
// ## END: Original unmodified sorting code
// ##################################################################################
		}
// ######################################################################################################
// ## END: New sort code that looks for a meta tag in the section description to sort the products.
// ######################################################################################################

Code: Select all

// ######################################################################################################
// ## START: New sort code that looks for a meta tag in the section description to sort the products.
// ## Put in the category description via the admin panel source view. Note you must unview source view
// ## for it to save in the admin panel.
// ## <!-- name="sortorder" content="21536,16146,16133" -->
// ######################################################################################################
		$sortflag = 0;
 		if ( (isset($data['sort']) && in_array($data['sort'], $sort_data) && ($data['sort'] == 'p.sort_order')) || !(isset($data['sort']) && in_array($data['sort'], $sort_data))   ){
				$description = '';
				$sortordersql = "select description from oc_category_description where category_id=".$data['filter_category_id']." limit 1";
				$query = $this->db->query($sortordersql);
				foreach ($query->rows as $result) {
					$description = $result['description'];
				}
				$pattern = '/&lt;!--.*?name=&quot;sortorder&quot;.*?content=&quot;(.*)?&quot;.*?--&gt;/i';
				$matches = array();
				$sortorder = '';
				if ( preg_match($pattern, $description, $matches) ){
					$sortorder = $matches[1];
				}
				if(!empty($sortorder)){
					$sql .= " ORDER BY IF(FIELD(p.product_id,$sortorder)=0,1,0),FIELD(p.product_id,$sortorder)";
					$sortflag = 1;
				}
		}
		if (!$sortflag) {
// ##################################################################################
// ## START: Original unmodified sorting code
// ##################################################################################
			if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
				if ($data['sort'] == 'pd.name' || $data['sort'] == 'p.model') {
					$sql .= " ORDER BY LCASE(" . $data['sort'] . ")";
				} elseif ($data['sort'] == 'p.price') {
					$sql .= " ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END)";
				} else {
					$sql .= " ORDER BY " . $data['sort'];
				}
			} else {
				$sql .= " ORDER BY p.sort_order";
			}
// ##################################################################################
// ## END: Original unmodified sorting code
// ##################################################################################
		}
// ######################################################################################################
// ## END: New sort code that looks for a meta tag in the section description to sort the products.
// ######################################################################################################

Code: Select all

	public function getCategories($parent_id = 0) {
		$sqlquery = "SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '" . (int)$parent_id . "' AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'  AND c.status = '1' ";

		$description = '';
		$sortordersql = "select description from oc_category_description where category_id=".$parent_id." limit 1";
		$query = $this->db->query($sortordersql);
		foreach ($query->rows as $result) {
				$description = $result['description'];
		}
		$pattern = '/<!--.*?name="sortorder".*?content="(.*)?".*?-->/i';
		$matches = array();
		$sortorder = '';
		if ( preg_match($pattern, $description, $matches) ){
			$sortorder = $matches[1];
		}
;
		if(!empty($sortorder)){
			$sqlquery .= " ORDER BY IF(FIELD(c.category_id,$sortorder)=0,1,0),FIELD(c.category_id,$sortorder)";
		} else {
			$sqlquery .= " ORDER BY c.sort_order, LCASE(cd.name)";
		}

		$query = $this->db->query($sqlquery);

		return $query->rows;
	}

Code: Select all

INSERT INTO `oc_event` (`code`, `trigger`, `action`, `status`) VALUES ('cgg_product_sort', 'catalog/model/catalog/product/getProducts/after', 'extension/module/cgg_product_sort/cggProductSort', 1);

Code: Select all

<?php
class ControllerExtensionModulecggProductSort extends Controller {
	public function cggProductSort(&$route, &$args, &$output) {

		ob_start();
		var_dump($route);
		$dump_route = ob_get_clean();

		ob_start();
		var_dump($args);
		$dump_args = ob_get_clean();

		ob_start();
		var_dump($output);
		$dump_output = ob_get_clean();

		ob_start();
		var_dump($this);
		$data_dump = ob_get_clean();

		$data_dump = "ROUTE:\n$dump_route\n\nARGS:\n$dump_args\n\nOUTPUT:\n$dump_output";

		file_put_contents('/var/www/html/test.txt',  $data_dump );

	}
}