php 购买记录,ECShop修改商品的近期购买记录显示所有

直接上修改方法，找到文件：includes/lib_insert.php

找到这句话：

[代码]php代码：

$sql = \'SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status \' . \'FROM \' . $GLOBALS[\'ecs\']->table(\'order_info\') . \' AS oi LEFT JOIN \' . $GLOBALS[\'ecs\']->table(\'users\') . \' AS u ON oi.user_id = u.user_id, \' . $GLOBALS[\'ecs\']->table(\'order_goods\') . \' AS og \' . \'WHERE oi.order_id = og.order_id AND \' . time() . \' - oi.add_time getAll($sql);

将其修改为：

[代码]php代码：

$sql = \'SELECT u.user_name, og.goods_number, oi.add_time, IF(oi.order_status IN (2, 3, 4), 0, 1) AS order_status \' . \'FROM \' . $GLOBALS[\'ecs\']->table(\'order_info\') . \' AS oi LEFT JOIN \' . $GLOBALS[\'ecs\']->table(\'users\') . \' AS u ON oi.user_id = u.user_id, \' . $GLOBALS[\'ecs\']->table(\'order_goods\') . \' AS og \' . \'WHERE oi.order_id = og.order_id AND og.goods_id = \' . $arr[\'id\'] . \' ORDER BY oi.add_time DESC LIMIT 50\'; $bought_notes = $GLOBALS[\'db\']->getAll($sql);

再找到下面这句：

[代码]php代码：

$sql = \'SELECT count(*) \' . \'FROM \' . $GLOBALS[\'ecs\']->table(\'order_info\') . \' AS oi LEFT JOIN \' . $GLOBALS[\'ecs\']->table(\'users\') . \' AS u ON oi.user_id = u.user_id, \' . $GLOBALS[\'ecs\']->table(\'order_goods\') . \' AS og \' . \'WHERE oi.order_id = og.order_id AND \' . time() . \' - oi.add_time getOne($sql);

将其修改为：

[代码]php代码：

$sql = \'SELECT count(*) \' . \'FROM \' . $GLOBALS[\'ecs\']->table(\'order_info\') . \' AS oi LEFT JOIN \' . $GLOBALS[\'ecs\']->table(\'users\') . \' AS u ON oi.user_id = u.user_id, \' . $GLOBALS[\'ecs\']->table(\'order_goods\') . \' AS og \' . \'WHERE oi.order_id = og.order_id AND og.goods_id = \' . $arr[\'id\']...