На жаль, я не розуміюся на таких правках.
А блок пошуку, знайти вдалось, на багато простіше.
public function getCustomers($data = array()) {
$sql = "SELECT c.*, CONCAT(c.firstname, ' ', c.lastname) AS name, cgd.name AS customer_group FROM " . DB_PREFIX . "customer c LEFT JOIN " . DB_PREFIX . "customer_group_description cgd ON (c.customer_group_id = cgd.customer_group_id) ";
if (!empty($data['filter_name'])) {
$sql .= " LEFT JOIN ".DB_PREFIX."address adr ON (adr.customer_id = c.customer_id) ";
}
$sql .= " WHERE cgd.language_id = '" . (int)$this->config->get('config_language_id') . "'";
$implode = array();
if (!empty($data['filter_name'])) {
$filer_name_sql = '';
$filer_name_sql .= " ( CONCAT(c.firstname, ' ', c.lastname) LIKE '%" . $this->db->escape($data['filter_name']) . "%' ";
$filer_name_sql .= " OR c.firstname LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR c.lastname LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR c.telephone LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR adr.firstname LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR adr.lastname LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR adr.address_1 LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR adr.address_2 LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR adr.city LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " OR adr.postcode LIKE '%" . $this->db->escape($data['filter_email']) . "%' ";
$filer_name_sql .= " ) ";
Якщо можете, підкажіть будь ласка, як змінити параметр пошуку, щоб по c.telephone, щукало без урахування символів "(", ")", "-".