IP1 Filter client using zip code instead of email address

[dac]

Hello,

I wish to use zip code as client filter instead of email address. What files will I need to modify?

Thanks

[crafter]

/application/modules/filter/controllers/Ajax.php

Replace the following code

public function filter_clients()
{
                ...
            $this->mdl_clients->like("CONCAT_WS('^',LOWER(client_name),LOWER(client_surname),LOWER(client_email),client_phone,client_active)", $keyword);
                ...
}

to

public function filter_clients()
{
                ...
$this->mdl_clients->like("CONCAT_WS('^',LOWER(client_name),LOWER(client_surname),LOWER(client_email),client_phone,client_active, client_zip)", $keyword);
                 ...
}

[dac]

Works a treat, thanks.

[miquel_cabanas]

@dac whenever you have time, remember to mark @crafter post with the answer as “accepted answer” using the check-box button under the message.

Also, I have added this as a feature request for a later version:

• IP-748 - Improve clients table filter: add other fields not displayed in the table