OC 3.0 相关产品的写法

1、catalog\controller\product\product.php中
$data[‘attribute_groups’]之后引入
$data[‘products’] = array();
$results = $this->model_catalog_product->getCategoryRelatedProducts($this->request->get[‘product_id’],10);
foreach ($results as $result) {
if ($result[‘image’] && is_array($result[‘image’])) {
$image = $this->model_tool_image->resize($result[‘image’], $this->config->get(‘theme_’ . $this->config->get(‘config_theme’) . ‘_image_related_width’), $this->config->get(‘theme_’ . $this->config->get(‘config_theme’) . ‘_image_related_height’));
} else {
$image = $this->model_tool_image->resize(‘placeholder.png’, $this->config->get(‘theme_’ . $this->config->get(‘config_theme’) . ‘_image_related_width’), $this->config->get(‘theme_’ . $this->config->get(‘config_theme’) . ‘_image_related_height’));
}

if ($this->customer->isLogged() || !$this->config->get(‘config_customer_price’)) {
$price = $this->currency->format($this->tax->calculate($result[‘price’], $result[‘tax_class_id’], $this->config->get(‘config_tax’)), $this->session->data[‘currency’]);
} else {
$price = false;
}

if ((float)$result[‘special’]) {
$special = $this->currency->format($this->tax->calculate($result[‘special’], $result[‘tax_class_id’], $this->config->get(‘config_tax’)), $this->session->data[‘currency’]);
} else {
$special = false;
}

if ($this->config->get(‘config_tax’)) {
$tax = $this->currency->format((float)$result[‘special’] ? $result[‘special’] : $result[‘price’], $this->session->data[‘currency’]);
} else {
$tax = false;
}

if ($this->config->get(‘config_review_status’)) {
$rating = (int)$result[‘rating’];
} else {
$rating = false;
}

$data[‘products’][] = array(
‘product_id’ => $result[‘product_id’],
‘thumb’ => $image,
‘name’ => $result[‘name’],
‘description’ => utf8_substr(trim(strip_tags(html_entity_decode($result[‘description’], ENT_QUOTES, ‘UTF-8’))), 0, $this->config->get(‘theme_’ . $this->config->get(‘config_theme’) . ‘_product_description_length’)) . ‘..’,
‘price’ => $price,
‘special’ => $special,
‘tax’ => $tax,
‘minimum’ => $result[‘minimum’] > 0 ? $result[‘minimum’] : 1,
‘rating’ => $rating,
‘href’ => $this->url->link(‘product/product’, ‘product_id=’ . $result[‘product_id’])
);
}

2、catalog\model\catalog\product.php添加方法
public function getProductAttributes($product_id) {
$product_attribute_group_data = array();

$product_attribute_group_query = $this->db->query(“SELECT ag.attribute_group_id, agd.name FROM ” . DB_PREFIX . “product_attribute pa LEFT JOIN ” . DB_PREFIX . “attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN ” . DB_PREFIX . “attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN ” . DB_PREFIX . “attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = ‘” . (int)$product_id . “‘ AND agd.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘ GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name”);

foreach ($product_attribute_group_query->rows as $product_attribute_group) {
$product_attribute_data = array();

$product_attribute_query = $this->db->query(“SELECT a.attribute_id, ad.name, pa.text FROM ” . DB_PREFIX . “product_attribute pa LEFT JOIN ” . DB_PREFIX . “attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN ” . DB_PREFIX . “attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = ‘” . (int)$product_id . “‘ AND a.attribute_group_id = ‘” . (int)$product_attribute_group[‘attribute_group_id’] . “‘ AND ad.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘ AND pa.language_id = ‘” . (int)$this->config->get(‘config_language_id’) . “‘ ORDER BY a.sort_order, ad.name”);

foreach ($product_attribute_query->rows as $product_attribute) {
$product_attribute_data[] = array(
‘attribute_id’ => $product_attribute[‘attribute_id’],
‘name’ => $product_attribute[‘name’],
‘text’ => $product_attribute[‘text’]
);
}

$product_attribute_group_data[] = array(
‘attribute_group_id’ => $product_attribute_group[‘attribute_group_id’],
‘name’ => $product_attribute_group[‘name’],
‘attribute’ => $product_attribute_data
);
}

return $product_attribute_group_data;
}