GX-Bug #51340 » OrderListFilterCustomerFix.patch
src/GXMainComponents/Services/Core/Order/OrderListGenerator.inc.php (revision ) | ||
---|---|---|
763 | 763 |
else |
764 | 764 |
{ |
765 | 765 |
$this->db->where('`orders`.`customers_name` LIKE "' . $filterParameters['customer'] . '"') |
766 |
->or_where('`orders`.`customers_firstname` LIKE "' . $filterParameters['customer'] . '"') |
|
767 |
->or_where('`orders`.`customers_lastname` LIKE "' . $filterParameters['customer'] . '"') |
|
768 |
->or_where('`orders`.`customers_id` LIKE "' . $filterParameters['customer'] . '"') |
|
769 |
->or_where('`orders`.`customers_cid` LIKE "' . $filterParameters['customer'] . '"') |
|
770 |
->or_where('`orders`.`customers_vat_id` LIKE "' . $filterParameters['customer'] . '"') |
|
771 |
->or_where('`orders`.`customers_gender` LIKE "' . $filterParameters['customer'] . '"') |
|
772 |
->or_where('`orders`.`customers_email_address` LIKE "' . $filterParameters['customer']. '"') |
|
773 |
->or_where('`orders`.`customers_telephone` LIKE "' . $filterParameters['customer'] . '"') |
|
774 | ||
766 | 775 |
->or_where('`customers`.`customers_firstname` LIKE "' . $filterParameters['customer'] . '"') |
767 | 776 |
->or_where('`customers`.`customers_lastname` LIKE "' . $filterParameters['customer'] . '"') |
768 | 777 |
->or_where('`customers`.`customers_id` LIKE "' . $filterParameters['customer'] . '"') |
769 | 778 |
->or_where('`customers`.`customers_cid` LIKE "' . $filterParameters['customer'] . '"') |
770 | 779 |
->or_where('`customers`.`customers_vat_id` LIKE "' . $filterParameters['customer'] . '"') |
771 | 780 |
->or_where('`customers`.`customers_gender` LIKE "' . $filterParameters['customer'] . '"') |
772 |
->or_where('`customers`.`customers_email_address` LIKE "' . $filterParameters['customer'] |
|
773 |
. '"') |
|
781 |
->or_where('`customers`.`customers_email_address` LIKE "' . $filterParameters['customer']. '"') |
|
774 | 782 |
->or_where('`customers`.`customers_telephone` LIKE "' . $filterParameters['customer'] . '"') |
783 | ||
775 | 784 |
->or_where('`customers`.`customers_fax` LIKE "' . $filterParameters['customer'] . '"'); |
776 | 785 |
} |
777 | 786 |
$this->db->group_end(); |