[Virtuemart] Customize Order List search keywords
The default Order List search keyword doesn't check for customer's email address, billing addresses, phone numbers, Custom Message... To include all these:
In/administrator/components/com_virtuemart/html/order.order_list.php
locate this section
The add the keywords that you wish to include.
Below is an example code. The codes are pretty self-explanatory.
Enjoy.
In
locate this section
if (!empty($keyword)) { $q .= "(#__{vm}_orders.order_id LIKE '%$keyword%' "; $q .= "OR #__{vm}_orders.order_status LIKE '%$keyword%' "; $q .= "OR first_name LIKE '%$keyword%' "; $q .= "OR last_name LIKE '%$keyword%' "; $q .= "OR CONCAT(`first_name`, ' ', `last_name`) LIKE '%$keyword%' ";
The add the keywords that you wish to include.
Below is an example code. The codes are pretty self-explanatory.
$list = "SELECT #__{vm}_orders.order_id,order_status, #__{vm}_orders.cdate,#__{vm}_orders.mdate,order_total,order_currency,#__{vm}_orders.user_id,"; $list .= "first_name, last_name, user_email, address_1, address_2, city, phone_1, phone_2, zip, customer_note "; $list .= "FROM #__{vm}_orders, #__{vm}_order_user_info, WHERE "; $count = "SELECT count(*) as num_rows FROM #__{vm}_orders, #__{vm}_order_user_info WHERE "; $q = "address_type = 'BT' AND "; if (!empty($keyword)) { $q .= "(#__{vm}_orders.order_id LIKE '%$keyword%' "; $q .= "OR #__{vm}_orders.order_status LIKE '%$keyword%' "; $q .= "OR first_name LIKE '%$keyword%' "; $q .= "OR last_name LIKE '%$keyword%' "; $q .= "OR CONCAT(`first_name`, ' ', `last_name`) LIKE '%$keyword%' "; $q .= "OR user_email LIKE '%$keyword%' "; $q .= "OR address_1 LIKE '%$keyword%' "; $q .= "OR address_2 LIKE '%$keyword%' "; $q .= "OR city LIKE '%$keyword%' "; $q .= "OR phone_1 LIKE '%$keyword%' "; $q .= "OR phone_2 LIKE '%$keyword%' "; $q .= "OR zip LIKE '%$keyword%' "; $q .= "OR customer_note LIKE '%$keyword%' "; $q .= ") AND "; } if (!empty($show)) { $q .= "order_status = '$show' AND "; } $q .= "(#__{vm}_orders.order_id=#__{vm}_order_user_info.order_id) "; $q .= "AND #__{vm}_orders.vendor_id='".$_SESSION['ps_vendor_id']."' "; $q .= "ORDER BY #__{vm}_orders.cdate DESC "; $list .= $q . " LIMIT $limitstart, " . $limit; $count .= $q;
Enjoy.
oh man you are amazing thnx
ReplyDeleteput i have a question ?
how can i view the address_1 or product_name or vendors_name in Order List page
@mezo
ReplyDeleteGlad that this article helped you.
Regarding you question, I've posted another article. Feel free to check it out.
:)
scorexper-no_1988 Alexis Sanchez https://wakelet.com/wake/nrovtCfSOig8ask4ie4Kw
ReplyDeletecaleanelbo
Oboesolprudgi1991 Evelyn Gaddie Firefox browser
ReplyDeleteReiBoot Pro
Your Uninstaller
entaltobou