How to sort alphabetically the menu categories labels

[Abdillokra]

Hello Guys,

 

 

I'm  trying to sort alphabetically the categories labels from my menu. 

 

I've looked into the .php file and found this function :

 

 

    public function getblockCategTree() {

 

        // Get all groups for this customer and concatenate them as a string: "1,2,3..."

        $groups = implode(', ', Customer::getGroupsStatic((int) $this->context->customer->id));

        $maxdepth = Configuration::get('BLOCK_CATEG_MAX_DEPTH');

        if (!$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('

                  SELECT DISTINCT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite

                  FROM `' . _DB_PREFIX_ . 'category` c

                  INNER JOIN `' . _DB_PREFIX_ . 'category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = ' . (int) $this->context->language->id . Shop::addSqlRestrictionOnLang('cl') . ')

                  INNER JOIN `' . _DB_PREFIX_ . 'category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = ' . (int) $this->context->shop->id . ')

                  WHERE (c.`active` = 1 OR c.`id_category` = ' . (int) Configuration::get('PS_HOME_CATEGORY') . ')

                  AND c.`id_category` != ' . (int) Configuration::get('PS_ROOT_CATEGORY') . '

' . ((int) $maxdepth != 0 ? ' AND `level_depth` <= ' . (int) $maxdepth : '') . '

                  AND c.id_category IN (SELECT id_category FROM `' . _DB_PREFIX_ . 'category_group` WHERE `id_group` IN (' . pSQL($groups) . '))

                  ORDER BY `level_depth` ASC, ' . (Configuration::get('BLOCK_CATEG_SORT') ? 'cl.`name`' : 'cs.`position`') . ' ' . (Configuration::get('BLOCK_CATEG_SORT_WAY') ? 'DESC' : 'ASC')))

            return;

 

        $resultParents = array();

        $resultIds = array();

 

 

 

I tried to edit the Order by

 

from this :

 

 ORDER BY `level_depth` ASC, ' . (Configuration::get('BLOCK_CATEG_SORT') ? 'cl.`name`' : 'cs.`position`') . ' ' . (Configuration::get('BLOCK_CATEG_SORT_WAY') ? 'DESC' : 'ASC')))

 

into

 

this :

 

 ORDER BY cl.`name` ASC, ' . (Configuration::get('BLOCK_CATEG_SORT') ? 'cl.`name`' : 'cs.`position`') . ' ' . (Configuration::get('BLOCK_CATEG_SORT_WAY') ? 'DESC' : 'ASC')))

 

But with no effect on the the labels' order.

 

 

Can anyone please point the correct method to sort it alphabetically?

 

Many thanks for your help.