I found two extensions, one created by thekrotek that allows you to create a primary category for products and another created by muglali that allows you to show product categories on product pages.
I want to be able to use the primary category (from the primary category module) as the category shown on the product pages (from the show category on product page module) and not all categories that the product is assigned to.
In the primary category module it adds the below code to "catalog/model/catalog/product.php"
Code: Select all
public function addProductPrimaryCategory($product_id = 0, $category_id)
{
if (!$product_id) {
$query = $this->db->query("SELECT product_id FROM `".DB_PREFIX."product` ORDER BY product_id DESC LIMIT 1");
if ($query->num_rows) {
$product_id = $query->row['product_id'];
}
}
$this->db->query("INSERT INTO `".DB_PREFIX."product_primary_category` (`category_id`, `product_id`) VALUES ('".(int)$category_id."', '".(int)$product_id."')");
}
public function editProductPrimaryCategory($product_id, $category_id)
{
$primary_category_id = $this->getProductPrimaryCategory($product_id);
if ($primary_category_id) {
$this->db->query("UPDATE `".DB_PREFIX."product_primary_category` SET category_id = '".(int)$category_id."' WHERE product_id = '".(int)$product_id."'");
} else {
$this->addProductPrimaryCategory($product_id, $category_id);
}
}
public function getProductPrimaryCategory($product_id)
{
$query = $this->db->query("SELECT category_id FROM `".DB_PREFIX."product_primary_category` WHERE product_id = '".(int)$product_id."'");
if ($query->num_rows) return $query->row['category_id'];
else return 0;
}
Code: Select all
$this->load->language('common/header');
$data['text_category'] = $this->language->get('text_category');
$querycats = $this->model_catalog_product->getCategories($product_id);
$categories = array();
foreach( $querycats as $item ) {
$categ = $this->model_catalog_category->getCategory($item['category_id']);
if ($categ['parent_id'] > 0) {
$catinfo['href'] = $this->url->link('product/category', 'path=' . $categ['parent_id'] . '_' . $item['category_id']);
}
else {
$catinfo['href'] = $this->url->link('product/category', 'path=' . $item['category_id']);
}
$catinfo['name'] = $categ['name'];
$categories[] = $catinfo;
}"When you install this extension, three new functions are added to product model in admin and catalog:
addProductPrimaryCategory($product_id = 0, $category_id)
editProductPrimaryCategory($product_id, $category_id)
getProductPrimaryCategory($product_id)
Their names say for themselves and usage is very simple. Any developer or customer with some basic PHP knowledge can implement these functions easily. All our extensions already utilize them, when necessary."
I am using Opencart version 3.0.3.2 Default theme.
I am still new to PHP, and would like some help achieving this.
I have taken care of the twig and language section.
Thank you in advance for your help.
