legacy12

Quick question I managed to add the short description on the delivery slip. We also want to sort the product using the data in the short description. This is done in /classes/order/OrderInvoice.php with the following code: public function getProductsDetail() { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT * FROM `' . _DB_PREFIX_ . 'order_detail` od LEFT JOIN `' . _DB_PREFIX_ . 'product` p ON p.id_product = od.product_id LEFT JOIN `' . _DB_PREFIX_ . 'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = ' . (int) $this->id_order . ' ' . ($this->id && $this->number ? ' AND od.`id_order_invoice` = ' . (int) $this->id : '') . ' ORDER BY od.`product_reference`'); } The short description information is located in ps_product_lang database. Does someone know how to change the query above? Thanks!

Quick question I managed to add the short description on the delivery slip. We also want to sort the product using the data in the short description. This is done in /classes/order/OrderInvoice.php with the following code: public function getProductsDetail() { return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS(' SELECT * FROM `' . _DB_PREFIX_ . 'order_detail` od LEFT JOIN `' . _DB_PREFIX_ . 'product` p ON p.id_product = od.product_id LEFT JOIN `' . _DB_PREFIX_ . 'product_shop` ps ON (ps.id_product = p.id_product AND ps.id_shop = od.id_shop) WHERE od.`id_order` = ' . (int) $this->id_order . ' ' . ($this->id && $this->number ? ' AND od.`id_order_invoice` = ' . (int) $this->id : '') . ' ORDER BY od.`product_reference`'); } The short description information is located in ps_product_lang database. Does someone know how to change the query above? Thanks!

ok thanks for your feedback

Did you manage to fix this?

Would be great if this query is extended with product without combinations.

Thanks for you reply. If i Put AdminProducts in the place of AdminProductGrid then the AdminProducts page is working. I have to find a way to combine those two. if(file_exists(_PS_MODULE_DIR_.'pc_orderspanel/views/templates/admin/_configure/'.$this->base_folder.$tpl_name) && Tools::getValue('controller') != 'AdminProducts')

Hello, I want to use this code: if(file_exists(_PS_MODULE_DIR_.'pc_orderspanel/views/templates/admin/_configure/'.$this->base_folder.$tpl_name) && Tools::getValue('controller') != 'AdminProductGrid' && Tools::getValue('controller') != 'AdminProducts') Somehow it is not working. If i remove a part and use this code it is working: if(file_exists(_PS_MODULE_DIR_.'pc_orderspanel/views/templates/admin/_configure/'.$this->base_folder.$tpl_name) && Tools::getValue('controller') != 'AdminProductGrid') How can i add: && Tools::getValue('controller') != 'AdminProducts' Thanks! Luke

Hi did you find a solution?

Hello, we want to integrate a possibility like this: see demo: http://jscolor.com/ on the product page.. Can someone help us?

That's perfect.

What will be the price?

Great!

Hallo, Heeft iemand ervaring met het implementeren van zowel hoog als laag btw bij 1 product? Wij hebben namelijk een aantal producten met verschillende typen btw dit willen we graag registreren in het systeem.. Bedankt. Luke