<?php
class ModelCatalogAttributes extends Model {
	public function getCategoryLayouts() {
		$query = $this->db->query("SELECT DISTINCT * FROM " . DB_PREFIX . "layout_route lr LEFT JOIN " . DB_PREFIX . "layout l ON (lr.layout_id = l.layout_id) WHERE lr.route = 'product/category' GROUP BY lr.layout_id");
		
		return $query->rows;
	}
        
        public function getAttributeGroups($data = array()) {
		$sql = "SELECT ag.attribute_group_id, agd.name FROM " . DB_PREFIX . "attribute_group ag LEFT JOIN " . DB_PREFIX . "attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE agd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND LCASE(agd.name) LIKE '" . $this->db->escape(mb_strtolower($data['filter'])) . "%' ORDER BY agd.name ASC LIMIT 0,100";
		
		$query = $this->db->query($sql);
                
		return $query->rows;
	}
}
?>