doubi9531 2012-08-15 13:19
浏览 33
已采纳

Opencart - 显示两个产品类别中的一个

I have Opencart 1.5.1.3 and have modified Meta title to display "Product name - Product category"

$product_info['name'] . ' - ' . $category_info['name']

The problem is when some of the products belong to two or more categories. How to tell open cart to use any one of product's categories? I don't really care which one :)

$this->language->load('product/product');

    $this->data['breadcrumbs'] = array();

    $this->data['breadcrumbs'][] = array(
        'text'      => $this->language->get('text_home'),
        'href'      => $this->url->link('common/home'),         
        'separator' => false
    );

    $this->load->model('catalog/category'); 
    $this->request->get['path'] = (isset($this->request->get['path']))? $this->request->get['path'] : $this->model_catalog_category->getCategoryPath($this->request->get['product_id']);

    if (isset($this->request->get['path'])) {
        $path = '';

        foreach (explode('_', $this->request->get['path']) as $path_id) {
            if (!$path) {
                $path = $path_id;
            } else {
                $path .= '_' . $path_id;
            }

            $category_info = $this->model_catalog_category->getCategory($path_id);

            if ($category_info) {
                $this->data['breadcrumbs'][] = array(
                    'text'      => $category_info['name'],
                    'href'      => $this->url->link('product/category', 'path=' . $path),
                    'separator' => $this->language->get('text_separator')
                );
            }
        }
    }
  • 写回答

1条回答 默认 最新

  • dongzuo7166 2012-08-15 15:45
    关注

    The code you have above assumes you get to a product via the categories, when in fact that doesn't always happen. Instead, you want to do the following

    Find this line in /catalog/controller/product/product.php

    $this->document->setTitle($product_info['name']);
    

    Replace it with the following

            $result = $this->db->query("
                SELECT `cd`.`name`
                FROM `" . DB_PREFIX . "product_to_category` `p2c`
                LEFT JOIN `" . DB_PREFIX . "category_description` `cd`
                ON `cd`.`category_id` = `p2c`.`category_id`
                WHERE `p2c`.`product_id` = '" . (int) $product_id . "'
                AND `cd`.`language_id` = '" . $this->confing->get('config_language_id') . "'
                ORDER BY `cd`.`category_id` DESC
                LIMIT 1
            ");
    
            $category_name = $result->num_rows ?  $result->row['name']: '';
            $this->document->setTitle($product_info['name'] . (empty($category_name) ? '' : ' - ' . $category_name));
    

    That will always show the last category created as the category assigned to the product. It will also not show a category if one isn't assigned to it (and hide the -)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥100 调查 Vitis AI 中验证 .xmodel 量化后的正确性
  • ¥30 codelite全屏时file、setting那一行消失了
  • ¥15 gazebo-rviz教程
  • ¥15 付费求做一个自助抢单插件
  • ¥15 bat批处理,关于数据复制问题
  • ¥50 同步两个不同结果的array中某些属性
  • ¥15 悬赏15远程操控解决问题
  • ¥15 CST复制的模型无法单独修改参数?
  • ¥15 前端页面想做个定时任务,但是使用requestAnimationFrame,setinterval和settimeout都不行
  • ¥15 根据以下文字信息,做EA模型图