Display phone number column from shipping address changing to invoice address (ets_ordermanager module)
/modules/ets_ordermanager/ets_ordermanager.php
line 1334
// edited by Jimmy @14OCT2022 change to invoice address phone number
// if(isset($fields['address_invoice']))
// {
$searchQueryBuilder->addSelect( 'address_invoice.address1 as address_invoice')
->innerJoin('o',_DB_PREFIX_.'address','address_invoice','address_invoice.id_address = o.id_address_invoice');
$countQueryBuilder->innerJoin('o',_DB_PREFIX_.'address','address_invoice','address_invoice.id_address = o.id_address_invoice');
// }
line 1405
// edited by Jimmy @14OCT2022 change to invoice address phone number
// ->addSelect('IF(a.phone, a.`phone`, a.`phone_mobile`) as number_phone')
->addSelect('IF(address_invoice.phone, address_invoice.`phone`, address_invoice.`phone_mobile`) as number_phone')
line 1454
if(isset($submit_filters['number_phone']))
{
// edited by Jimmy @14OCT2022 change to invoice address phone number
// $countQueryBuilder->andWhere('(a.phone LIKE "%'.pSQL($submit_filters['number_phone']).'%" OR a.phone_mobile LIKE "%'.pSQL($submit_filters['number_phone']).'%")');
// $searchQueryBuilder->andWhere('(a.phone LIKE "%'.pSQL($submit_filters['number_phone']).'%" OR a.phone_mobile LIKE "%'.pSQL($submit_filters['number_phone']).'%")');
$countQueryBuilder->andWhere('(address_invoice.phone LIKE "%'.pSQL($submit_filters['number_phone']).'%" OR address_invoice.phone_mobile LIKE "%'.pSQL($submit_filters['number_phone']).'%")');
$searchQueryBuilder->andWhere('(address_invoice.phone LIKE "%'.pSQL($submit_filters['number_phone']).'%" OR address_invoice.phone_mobile LIKE "%'.pSQL($submit_filters['number_phone']).'%")');
}