[SOLVED]Edit PDF invoice -sort order:Reference

[havegang]

Hi
Is it possible to change the sort order on the PDF-invoice, so it´s order after Preference? Ex.

MyStuff1 Reference# 1
MyStuff2 Reference# 2
MyStuff3 Reference# 3

I guess it´s in classes/PDF.php?

Thanks in advance.
/Michael

[rocky]

Try changing the getProductDetail() function in classes/Order.php from:

public function getProductsDetail()
{
   return Db::getInstance()->ExecuteS('
   SELECT *
   FROM `'._DB_PREFIX_.'order_detail` od
   WHERE od.`id_order` = '.intval($this->id));
}

to:

public function getProductsDetail()
{
   return Db::getInstance()->ExecuteS('
   SELECT *
   FROM `'._DB_PREFIX_.'order_detail` od
   WHERE od.`id_order` = '.intval($this->id).'
   ORDER BY od.`product_reference`');
}

[havegang]

Thanks very much.
It works perfect!

/Michael

[rocky]

Please edit your first post and add [sOLVED] to the front of the title.

[MrBaseball34]

havegang,

add [sOLVED] to the front of the title.

[yadav.kumar]

Hello There,

 

I have did this and the products are not get sorted in the invoice. I executed the same query in phpmyadmin and there I found the the order is sorted by reference.

 

Do you have any idea why it is behaving like that??

 

Thank you

[Yankee Store]

How can we do this for Prestashop 1.5.4 invoice ?

[eleazar]

Save this Override as /overrides/classes/order/Order.php:

 

<?php
/* override Sort by reference ID */
class Order extends OrderCore{
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 BY od.`product_reference`');
}
}

Edited July 17, 2013 by eleazar (see edit history)

[prestalollo]

Hi,

do I create a new file, order.php, and place it under "override/classes/order" directory, or how is this done?

[eleazar]

Yep, exactly. With the above content.

[prestalollo]

Excellent, thank you!

[Yankee Store]

I am looking to get the products on the invoices to be sorted by reference of the product or by category in prestashop 1.5.4 .

 

how and which files need to be changed

 

thank you in advance for any help

[LowCarbCentral]

Running prestashop 1.6, editing creating an override in order.php only affected the display of the product order in the store.  To have that order changed in invoices, I needed to edit OrderInvoice.php.

 

1. Copy /classes/order/OrderInvoice.php to /overrides/classes/orderOrderInvoice.php

2. Make edit as stated initially.

 

My code ended up like this:

	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 BY od.product_reference ASC');
	}

[helikoptermannen]

I want to sort the invoices when creating many pdf invoices in one pdf file. Sometimes I want to sort byt id_order and sometimes by invoice number. Where can I do that? Thanks!