Sort Order detail by product name in BO

[Micke21]

hi there,

i want to sort the order detail in bo by product_name but i don't find where is the code for. I try to modify all query in class order with order by product_name.

 

Could you help me ?

 

Thanks

Micke

[shokinro]

Have you tried modifying following code in OrderDetail.php file?

 

    public static function getList($id_order)
    {
        return Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'order_detail` WHERE `id_order` = '.(int)$id_order);
    }

[Micke21]

 

Have you tried modifying following code in OrderDetail.php file?

 

    public static function getList($id_order)
    {
        return Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'order_detail` WHERE `id_order` = '.(int)$id_order);
    }

hi,

i have already try this

  public static function getList($id_order)

    {

        return Db::getInstance()->executeS('SELECT * FROM `'._DB_PREFIX_.'order_detail` WHERE `id_order` = '.(int)$id_order.' order by product_name');

    }

but the order detail don't change, i don't understand