How to change contact form subjects order?

[grupaperun]

Hello,
how can I change contact form subjects order? Now it's sorted alphabetically by subject names. I would like to sort subjects by ID in ascending order.

I use Prestashop 1.7.5.1.

Here is the code from contactform.tpl

<div class="form-group row">
          <label class="col-md-3 form-control-label">{l s='Subject' d='Shop.Forms.Labels'}</label>
          <div class="col-md-9 col-lg-6">
            <select name="id_contact" class="form-control form-control-select">
              {foreach from=$contact.contacts item=contact_elt}
                <option value="{$contact_elt.id_contact}">{$contact_elt.name}</option>
              {/foreach}
            </select>
          </div>
        </div>

Please help.

[Rolige]

Hello:

You should order the list before pass it to the tpl, in the corresponding PHP file.

Regards

[sandra nanou]

Hi,

Have you found a solution? 

Thank you

[VeeTee]

Hi,

So all I did was, I put a number in front of the department (1. Information, 2. Support, 3. Webmaster) so that it's going according to this order, which is what the client wanted. 

Not ideal but the easiest way to do it.

[sandra nanou]

Hi,

It's also what I ended it up doing! I couldn't find any other way.

Thanks for your answer

[Marcellog19]

You can override class Contact.php

Copy /classes/Contact.php in /override/classes and write

/**
 * Class Contact
 */
class Contact extends ContactCore
{
    /**
     * Return available contacts
     * @param int $idLang Language ID
     * @return array Contacts
     */
    public static function getContacts($idLang)
    {
        $shopIds = Shop::getContextListShopID();
        $sql = 'SELECT *
				FROM `'._DB_PREFIX_.'contact` c
				'.Shop::addSqlAssociation('contact', 'c', false).'
				LEFT JOIN `'._DB_PREFIX_.'contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
				WHERE cl.`id_lang` = '.(int) $idLang.'
				AND contact_shop.`id_shop` IN ('.implode(', ', array_map('intval', $shopIds)).')
				GROUP BY c.`id_contact`
				ORDER BY `name` ASC';

        return Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql);
    }
}

By default, order is by name. I replace by position and in Database > "ps_contact" table I change value for position column.

PS : clear cache (remove all cache in /var/cache)

Edited September 15, 2020 by Marcellog19 (see edit history)