How to extend adminsearchcontroller to search on product reference number in orders

[Deoorbel]

Is there somenone who can help me to extend the adminsearchcontroller to search and display orders with specifik products.

 

Search on product reference in orders and display the order where the product is found.

 

Thanks

 

Prestashop 1.6.0.14

www.deoorbel.nl

Edited October 11, 2015 by Deoorbel (see edit history)

[Deoorbel]

I tried to adjust ther clases>order.php to get a order list below. But didn't work

 

public static function getOrderByProductID($productid)

{

$orders = new PrestaShopCollection('Order');

$orders->where('reference', '=', $reference);

                $product_list = $this->getOrderDetailList();

foreach ($product_list as $product)

if ($product['product_id'] == (int)$id_product)

            return $orders;                 

}

 

I stil need to adjust the adminsearchcontroller to display the record of the found orders.

[Deoorbel]

Can some one help me with this.

[EdEichman]

I would use a MySQL query, either via a client (I use Navicat), or via the SQL Manager in Prestashop. Assuming a table prefix of ps_, and a search for productID 10....

 

 

select
	reference,
	o.id_order,
	d.product_id,
	d.product_name
from
	ps_orders as o
	join ps_order_detail as d on (o.id_order = d.id_order)
where 
	product_id = 10
group by
	reference
order by 
	o.id_order

[EdEichman]

Also, if you go into the product itself, click on the "Product Sales" icon at the top, and indicate your date range, you can see sales associated with that product.

[Deoorbel]

Thanks! that does the trick [solved]