[Solved] Sort product features on comparsion page

[Coldlaw]

How to sort by name pruduct features on product comparsion page?
I searched in product-comparsion.php, CompareController.php but i doesn't found it.
Anybody can help me?

[Coldlaw]

Ohh , I found it.
In the Feature.php funtion of getFeaturesForComparison moded it:

public static function getFeaturesForComparison($list_ids_product, $id_lang)
{
$ids = '';
foreach($list_ids_product as $id)
$ids .= (int)($id).',';

$ids = rtrim($ids, ',');

if (empty($ids))
return false;

return Db::getInstance()->ExecuteS('
SELECT * , COUNT(*) as nb
FROM `'._DB_PREFIX_.'feature` f
LEFT JOIN `'._DB_PREFIX_.'feature_product` fp ON f.`id_feature` = fp.`id_feature`
LEFT JOIN `'._DB_PREFIX_.'feature_lang` fl ON f.`id_feature` = fl.`id_feature`
WHERE fp.`id_product` IN ('.$ids.')
AND `id_lang` = '.(int)($id_lang).'
GROUP BY f.`id_feature`
ORDER BY `name` ASC');
}
}

[guillenqn]

Could you tell me the location of those files please?

[nadie]

Could you tell me the location of those files please?

 

The file: Feature.php is in the directory called /classes/

 

 

 

Sorry for my English

[guillenqn]

Ohh , I found it.

In the Feature.php funtion of getFeaturesForComparison moded it:

 

public static function getFeaturesForComparison($list_ids_product, $id_lang)

{

$ids = '';

foreach($list_ids_product as $id)

$ids .= (int)($id).',';

 

$ids = rtrim($ids, ',');

 

if (empty($ids))

return false;

 

return Db::getInstance()->ExecuteS('

SELECT * , COUNT(*) as nb

FROM `'._DB_PREFIX_.'feature` f

LEFT JOIN `'._DB_PREFIX_.'feature_product` fp ON f.`id_feature` = fp.`id_feature`

LEFT JOIN `'._DB_PREFIX_.'feature_lang` fl ON f.`id_feature` = fl.`id_feature`

WHERE fp.`id_product` IN ('.$ids.')

AND `id_lang` = '.(int)($id_lang).'

GROUP BY f.`id_feature`

ORDER BY `name` ASC');

}

}

 

 

Great! Worked for me.

New question, is it possible to sort the features by the ID order, not alphabetically?

 

Sorry for my English.

[logs00]

Thanks !!!

It's work for me too and it's work on PS 1.5.2 ;-)