Add to order_confirm.tpl model description

Code: Select all

<?php echo $product['name']; ?>

Code: Select all

'description'     => $result['description'],

Code: Select all

$this->data['products'][] = array(
'name'     => $result['name'],
'description'     => $result['description'],
'model'    => $result['model'],.....

Code: Select all

$order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'"); 

Code: Select all

$order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product op LEFT JOIN " . DB_PREFIX . "product_description pd ON (op.product_id = pd.product_id) WHERE op.order_id = '" . (int)$order_id . "' AND pd.language_id = '" . (int)$order_query->row['language_id'] . "'"); 

Code: Select all

'name'     => $product['name'], 

Code: Select all

'description' => html_entity_decode($product['description']), 

Code: Select all

<td class="right"><?php echo $product['description']; ?></td>

Code: Select all

<td class="right"><?php echo $product['model']; ?></td>

Code: Select all

'description' => html_entity_decode($product['description']), 

Code: Select all

$this->data['products'][] = array(
					'order_product_id'  => $product['order_product_id'],
					'product_id'     	=> $product['product_id'],
					'name'    	 		=> $product['name'],
					'model'    			=> $product['model'],

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product op LEFT JOIN " . DB_PREFIX . "product_description pd ON (op.product_id = pd.product_id) WHERE op.order_id = '" . (int)$order_id . "' AND pd.language_id = '" . (int)$order_query->row['language_id'] . "'");  

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");

Code: Select all

$_['column_description']    = 'Description'; 

Code: Select all

$this->data['column_description'] = $this->language->get('column_description'); 

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product op LEFT JOIN " . DB_PREFIX . "product_description pd ON (op.product_id = pd.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND op.order_id = '" . (int)$order_id . "'"); 

Code: Select all

$query = $this->db->query("SELECT op.name, op.model, SUM(op.quantity) AS quantity, SUM(op.total + op.total * op.tax / 100) AS total FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (op.order_id = o.order_id) WHERE o.order_status_id > '0' GROUP BY op.name, op.model ORDER BY total DESC LIMIT " . (int)$start . "," . (int)$limit);

Code: Select all

$query = $this->db->query("SELECT op.name, pd.description, SUM(op.quantity) AS quantity, SUM(op.total + op.total * op.tax / 100) AS total FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_product op ON (op.order_id = o.order_id) LEFT JOIN " . DB_PREFIX . "product_description pd ON (op.product_id = pd.product_id) WHERE o.order_status_id > '0' GROUP BY op.name ORDER BY total DESC LIMIT " . (int)$start . "," . (int)$limit);

Code: Select all

        <p><b>Items return: </b><?php echo $test_custom_field_value[1]; ?></p>