Hello,
I had the same problem in version 2.0.23, and changed the way this search as follows:
1) Tunning this querie in the file: \administrator\components\com_vminvoice\helpers\getter.php
In my case only consider in filter the fields after the WHERE clouse:
...
static function getAjaxUserList($filterOrig)
{
$db = JFactory::getDBO();
$filter = $db->Quote('%'.$db->getEscaped(JString::strtolower(JString::trim($filterOrig)), true).'%');
//get user list with all shipping adresses
if (COM_VMINVOICE_ISVM2)
{
//get user list with all shipping adresses
if (COM_VMINVOICE_ISVM2)
{
$searchId = is_numeric($filterOrig) ? ' OR BT.virtuemart_user_id = '.(int)$filterOrig : '';
$db->setQuery('SELECT ST.`address_type_name`, ST.`virtuemart_userinfo_id` AS st_user_info_id,
BT.`virtuemart_user_id` AS user_id, BT.`virtuemart_userinfo_id` AS bt_user_info_id,
BT.`last_name`, BT.`first_name`, BT.`title`, BT.`middle_name`, BT.`company`, BT.`city`
FROM `#__virtuemart_userinfos` AS BT
LEFT JOIN `#__virtuemart_userinfos` AS ST ON (BT.virtuemart_user_id = ST.virtuemart_user_id AND ST.`address_type` = "ST")
LEFT JOIN `#__users` AS U ON BT.virtuemart_user_id=U.id
WHERE (BT.`address_type` = "BT"
AND BT.`first_name` LIKE ' . $filter . '
AND BT.`first_name` LIKE ' . $filter . '
OR BT.`CUSTOM_FIELD_1` LIKE ' . $filter . '
'.$searchId . ' ) ORDER BY BT.`first_name`', 0, 50);
/* original querie commented below*/
/*
$searchId = is_numeric($filterOrig) ? ' OR BT.virtuemart_user_id = '.(int)$filterOrig : '';
$db->setQuery('SELECT ST.`address_type_name`, ST.`virtuemart_userinfo_id` AS st_user_info_id,
BT.`virtuemart_user_id` AS user_id, BT.`virtuemart_userinfo_id` AS bt_user_info_id,
BT.`last_name`, BT.`first_name`, BT.`title`, BT.`middle_name`, BT.`company`, BT.`city`
FROM `#__virtuemart_userinfos` AS BT
LEFT JOIN `#__virtuemart_userinfos` AS ST ON (BT.virtuemart_user_id = ST.virtuemart_user_id AND ST.`address_type` = "ST")
LEFT JOIN `#__users` AS U ON BT.virtuemart_user_id=U.id
WHERE (BT.`address_type` = "BT"
AND BT.`last_name` LIKE ' . $filter . '
'.$searchId.'
OR BT.`first_name` LIKE ' . $filter . '
OR U.`email` LIKE ' . $filter . '
OR BT.`company` LIKE ' . $filter . '
OR BT.`city` LIKE ' . $filter . '
OR ST.`address_type_name` LIKE ' . $filter . ' )
ORDER BY BT.`last_name`', 0, 50);
*/
}
else
...
2) Suggestion, change in the file "\administrator\components\com_vminvoice\views\order\tmpl\userinfo.php", on input field "user" the propertie "onkeyup" to execute the function "generateWhisper" only the "enter" is pressed.
[ ]`s
