see the sku

[abolabo]

i said about product options... not product sku.
Abantecart allow to set sku for option too.
For ex. you have product with name "shoes". Shoes have 2 options: size and color. For all combination of this properties merchant can set different values of sku. that's why changing of core is difficult right now.
You showed me your custom, partial, solution.
Why do you don't change method getOrderProducts() on file public_html/admin/model/sale/order.php ?
it used by sale/invoice.php controller.
FYI. you don't need to create new connection to database. Instance of db-class is already in memory.
you can do

Code: [Select]

$this->db->query($sql) in any controllers and models
or

Code: [Select]

$registry = Registry::getInstance()
$registry->get('db')->query(sql);everywhere in code

But personally i prefer to create custom extension with hooks of controllers.. this approach saves your changes after cart upgrade.

[ygalbrami]

thank you so much for this, this is want i need.

i have the code to select db

Code: [Select]

SELECT * FROM order_products INNER JOIN products ON order_products.product_id = products.product_id WHERE order_products.order_id='$get_orderid

can you show me how to put my code to this:

Code: [Select]

$this->db->query($sql)
thanks again very very much

[abolabo]

$result = $this->db->query("SELECT * FROM order_products INNER JOIN products ON order_products.product_id = products.product_id WHERE order_products.order_id='".(int)$order_id."'" );
var_dump($result->rows); 
$result->rows - is array with all rows.

[ygalbrami]

i put this on invoice.php

Code: [Select]

$result = $this->db->query("SELECT * FROM order_products INNER JOIN products ON order_products.product_id = products.product_id WHERE order_products.order_id='".(int)$order_id."'" );
 


foreach ($result->rows as $product) {
$product['sku'];

}

echo $product['sku'];
and i see the sku at the top of the page so it work

but when i put the line into: order_invoice.tpl - i don't see the sku why is that?
what i am doing wrong?

Code: [Select]

echo $product['sku'];

[abolabo]

try to write

echo $orders['products']['sku'];

controller $this->data['orders'] become $orders variable inside tpl..

[ygalbrami]

So sorry but its don't work.
I will use my code for this.

The best way I see to use a AbanteCart cart code is when users make an order it will put in do database the SKU then is no problem to get the data.