ecshop订单列表增加商品检索的方法

<input name="goods_name" type="text" id="goods_name" size="15">

{$lang.order_sn}<input name="order_sn" type="text" id="order_sn" size="15">
{$lang.consignee|escape}<input name="consignee" type="text" id="consignee"size="15">
商品名<input name="goods_name" type="text" id="goods_name" size="15">
{$lang.all_status}
<select name="status" id="status">

listTable.filter['goods_name'] = Utils.trim(document.forms['searchForm'].elements['goods_name'].value);

/**
* 搜索订单
*/
function searchOrder()
{
listTable.filter['order_sn'] = Utils.trim(document.forms['searchForm'].elements['order_sn'].value);
listTable.filter['consignee'] = Utils.trim(document.forms['searchForm'].elements['consignee'].value);
listTable.filter['goods_name'] = Utils.trim(document.forms['searchForm'].elements['goods_name'].value);
listTable.filter['composite_status'] = document.forms['searchForm'].elements['status'].value;
listTable.filter['page'] = 1;
listTable.loadList();
}

$join_goods =" ";
if ($filter['goods_name'])
{
$join_goods = " LEFT JOIN " .$GLOBALS['ecs']->table('order_goods'). " AS og ON o.order_id=og.order_id LEFT JOIN " .$GLOBALS['ecs']->table('goods'). " AS g ON g.goods_id = og.goods_id ";
$where .= " AND g.goods_name LIKE '%" . mysql_like_quote($filter['goods_name']) . "%'";
}

$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_info') . " AS o ,".
$GLOBALS['ecs']->table('users') . " AS u ". $join_goods. $where;

$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_info') . " AS o ".$join_goods. $where;

/* 查询 */
$sql = "SELECT o.order_id, o.order_sn, o.add_time, o.order_status, o.shipping_status, o.order_amount, o.money_paid," .
"o.pay_status, o.consignee, o.address, o.email, o.tel, o.extension_code, o.extension_id, " .
"(" . order_amount_field('o.') . ") AS total_fee, " .
"IFNULL(u.user_name, '" .$GLOBALS['_LANG']['anonymous']. "') AS buyer ".
" FROM " . $GLOBALS['ecs']->table('order_info') . " AS o " .
" LEFT JOIN " .$GLOBALS['ecs']->table('users'). " AS u ON u.user_id=o.user_id ".$join_goods. $where .
" ORDER BY $filter[sort_by] $filter[sort_order] ".
" LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ",$filter[page_size]";

<tr>
<td><div align="right"><strong>商品名</strong></div></td>
<td><input name="goods_name" type="text" id="goods_name" size="40"></td>
</tr>