Add categories to invoice and cart

Re: Adding the category to invoices

Postby straightlight » Wed Nov 23, 2011 8:50 pm
Simply by reversing psychology, when we can't get a product by categories, we have to get a category by products.

In admin/controller/sale/order.php file,

Find:

Code: Select all
$this->data['column_model'] = $this->language->get('column_model');



add above:

Code: Select all
$this->data['column_category'] = $this->language->get('column_category');



Then, find:

Code: Select all
$this->data['order_products'][]



add above:

Code: Select all
$category_info = $this->model_catalog_product->getCategoriesByProduct($order_product['product_id']);

if ($category_info) {
$this->data['category_info'] = array();
foreach ($category_info as $cat_info) {
$this->data['category_info'][] = array(
'product_id' => (int)$cat_info['product_id'],
'name' => $cat_info['name'],
);
}
}



In admin/model/catalog/product.php file,

Find:

Code: Select all
public function getProductsByCategoryId($category_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p2c.category_id = '" . (int)$category_id . "' ORDER BY pd.name ASC");

return $query->rows;
}



Add above:

Code: Select all
public function getCategoriesByProduct($product_id) {
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (cd.category_id = c.product_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (c.category_id = p2c.category_id) WHERE cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p2c.product_id = '" . (int)$product_id . "' ORDER BY pd.name ASC");

return $query->rows;
}



Of course, this is a quick way of doing it while a separate model file could be built in order to adapt it into the controller file.

In admin/view/template/sale/order_form.tpl file,

find:

Code: Select all
<td class="left"><?php echo $column_model; ?></td>



Add above:

Code: Select all
<td class="left"><?php echo $column_category; ?></td>



Then, find:

Code: Select all
<td class="left"><?php echo $order_product['name']; ?><br />



add below (NOT above):

Code: Select all
<?php foreach ($category_info as $cat_info) { ?>
<?php if ((int)$order_product['product_id'] == (int)$cat_info['product_id']) { ?>
<td class="left"><?php echo $cat_info['name']; ?><br />
<?php } ?>
<?php } ?>



In admin/language/english/sale/order.php file,

find:

Code: Select all
$_['column_model'] = 'Model';



add above:

Code: Select all
$_['column_category'] = 'Categories';



All set.
Regards,
Straightlight