VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Quality & Testing VirtueMart 1.1.x => Virtuemart 1.1 Development (Archiv) => Q&T Resolved => Topic started by: patrik60 on December 27, 2008, 05:45:46 AM

Title: [FIXED] Search Product in Account Maintenance
Post by: patrik60 on December 27, 2008, 05:45:46 AM
Hello
Can anybody explain the "Search product" function in the account maintenance in "Order information". I only get "No Orders to Display" even when I'm looking for an article or a SKU or an order number I have ordered. As far as I understand it should show me informations or links to articles I've ordered.
Patrik

VM 1.1.2, J 1.5.8
Title: Re: Search Product in Account Maintenance
Post by: mauri on January 04, 2009, 12:10:33 PM
Confirmed!
ps_order.php
function list_order($order_status='A', $secure=0 ) {

if( !empty( $keyword )) {
$q .= "AND (order_id LIKE '%".$keyword."%' ";
$q .= "OR order_number LIKE '%".$keyword."%' ";
$q .= "OR order_total LIKE '%".$keyword."%') ";
}


Seems that you can search only order_id, order_number, order_total.
order_number is MD5 hash in DB like: 73_d0dfeca9f4ad01a7b3695e3873c52

If you search order_id like: 2
It finds order with id 2
and all orders where order_number MD5 hash code have number 2 (allmost all orders)
and all orders where total have number 2 (many orders)
If you search keyword pending, article name, Sku .... it find notfing.
Title: Re: Search Product in Account Maintenance
Post by: patrik60 on January 04, 2009, 17:08:32 PM
In this case I uncomment the html code in html.Tools.class.php on line 242 and 243:

<!--<input class="inputbox" type="text" size="25" name="keyword" value="'.shopMakeHtmlSafe($keyword).'" />
            <input class="button" type="submit" name="search" value="'.$VM_LANG->_('PHPSHOP_SEARCH_TITLE').'" />-->

Because this kind of search function makes no sence for customers. :-\

Title: Re: Search Product in Account Maintenance
Post by: aravot on January 08, 2009, 21:11:08 PM
Fixed in r1601
Title: Re: [FIXED] Search Product in Account Maintenance
Post by: mauri on January 09, 2009, 15:54:50 PM
Quote from: aravot on January 08, 2009, 21:11:08 PM
Fixed in r1601
Ohoooooo. Now it works.
Thank you very much aravot !