Adding the category to invoices

Code: Select all

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

Code: Select all

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

Code: Select all

$this->data['order_products'][]

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'],							
						);
					}
				}

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;
	}

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;
	}

Code: Select all

<td class="left"><?php echo $column_model; ?></td>

Code: Select all

<td class="left"><?php echo $column_category; ?></td>

Code: Select all

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

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 } ?>

Code: Select all

$_['column_model']            = 'Model';

Code: Select all

$_['column_category']         = 'Categories';

Code: Select all

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

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'],                     
                  );
               }
            }

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;
   }

Code: Select all

<td class="left"><?php echo $column_category; ?></td>

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 } ?>

Code: Select all

$_['column_category']         = 'Categories';

Code: Select all

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

Code: Select all

if ($order_info) {
    $category_info = $this->model_catalog_product->getCategoriesByProduct($order_product['product_id'], $order_info['store_id']);
} else {
    $category_info = $this->model_catalog_product->getCategoriesByProduct($order_product['product_id'], $this->config->get('config_store_id'));
}

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;
       }

Code: Select all

    public function getCategoriesByProduct($product_id, $store_id) {
          $query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (cd.category_id = c.category_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p2c.category_id = cd.category_id) LEFT JOIN `" . DB_PREFIX . "category_to_store` c2s ON (c2s.`category_id` = p2c.`category_id`) WHERE cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p2c.product_id = '" . (int)$product_id . "' AND c2s.`store_id` = '" . (int)$store_id . "' ORDER BY pd.name ASC");
                             
          return $query->rows;
       }

Code: Select all

SELECT cd.name FROM category c LEFT JOIN category_description cd ON (cd.category_id = c.category_id) LEFT JOIN product_to_category p2c ON (p2c.category_id = cd.category_id) LEFT JOIN `category_to_store` c2s ON (c2s.`category_id` = p2c.`category_id`) WHERE p2c.product_id =47543

Code: Select all

SELECT * FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (cd.category_id = c.category_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p2c.category_id = cd.category_id) LEFT JOIN `" . DB_PREFIX . "category_to_store` c2s ON (c2s.`category_id` = p2c.`category_id`) WHERE

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 } ?>

Code: Select all

<?php if ($category_info) { ?>
<?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 } ?>
<?php } ?>

Code: Select all

    public function getCategoriesByProduct($product_id, $store_id) {
          $query = $this->db->query("SELECT *, `cd`.`name` AS `name` FROM " . DB_PREFIX . "category c LEFT JOIN " . DB_PREFIX . "category_description cd ON (cd.category_id = c.category_id) LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p2c.category_id = cd.category_id) LEFT JOIN " . DB_PREFIX . "product_description pd ON (pd.product_id = p2c.product_id) LEFT JOIN " . DB_PREFIX . "product p ON (p.product_id = pd.product_id) LEFT JOIN `" . DB_PREFIX . "category_to_store` c2s ON (c2s.`category_id` = p2c.`category_id`) WHERE cd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p2c.product_id = '" . (int)$product_id . "' AND c2s.`store_id` = '" . (int)$store_id . "' ORDER BY pd.name ASC");
                             
          return $query->rows;
       }

Code: Select all

Undefined variable: category_info in C:\wamp\www\testing\vqmod\vqcache\vq2-admin_view_template_sale_order_invoice.tpl on line 96