[FIXED] Search Product in Account Maintenance

[patrik60]

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

[mauri]

Confirmed!
ps_order.php
function list_order($order_status='A', $secure=0 ) {

Code Select Expand

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.

[patrik60]

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.

[aravot]

Fixed in r1601

[mauri]

Fixed in r1601

Ohoooooo. Now it works.
Thank you very much aravot !