112
'meta_description' => $result['meta_description'],
'description' => $result['description']
);
}
return $category_description_data;
}
public function getCategoryFilters($category_id) {
$category_filter_data = array();
$query = $this->db->query("SELECT * FROM " . DB_PREFIX .
"category_filter WHERE category_id = '" . (int)$category_id . "'");
foreach ($query->rows as $result) {
$category_filter_data[] = $result['filter_id'];
}
return $category_filter_data;
}
public function getCategoryStores($category_id) {
$category_store_data = array();
$query = $this->db->query("SELECT * FROM " . DB_PREFIX .
"category_to_store WHERE category_id = '" . (int)$category_id . "'");
foreach ($query->rows as $result) {
$category_store_data[] = $result['store_id'];
}
return $category_store_data;
113
}
public function getCategoryLayouts($category_id) {
$category_layout_data = array();
$query = $this->db->query("SELECT * FROM " . DB_PREFIX .
"category_to_layout WHERE category_id = '" . (int)$category_id . "'");
foreach ($query->rows as $result) {
$category_layout_data[$result['store_id']] =
$result['layout_id'];
}
return $category_layout_data;
}
public function getTotalCategories() {
$query = $this->db->query("SELECT COUNT(*) AS total
FROM " . DB_PREFIX . "category");
return $query->row['total'];
}
public function getTotalCategoriesByImageId($image_id) {
$query = $this->db->query("SELECT COUNT(*) AS total
FROM " . DB_PREFIX . "category WHERE image_id = '" . (int)$image_id . "'");
return $query->row['total'];
}
public function getTotalCategoriesByLayoutId($layout_id) {
114
$query = $this->db->query("SELECT COUNT(*) AS total
FROM " . DB_PREFIX . "category_to_layout WHERE layout_id = '" . (int)$layout_id
. "'");
return $query->row['total'];
}
}
?>