重要:部份2.0客户因为文件疏漏遗留了退换货后台管理显示问题
重要:部份2.0客户因为文件疏漏,遗留了早期1.1.3版的退换货后台管理显示问题
解决方法,找到文件:
admin(你的后台目录)/order.php
找到代码:
//退换货 www.lyecs.com 老杨ecshop
function return_list($return_id=0)
{
$wheres .= empty($_REQUEST['consignee']) ? '' : " oi.consignee = '" .trim($_REQUEST['consignee']) ."' AND ";
$wheres .= empty($_REQUEST['kuaidi_no']) ? '' : " r.kuaidi_no = '". trim($_REQUEST['kuaidi_no']) ."' AND ";
$wheres .= empty($_REQUEST['order_sn']) ? '' : " oi.order_sn = '". trim($_REQUEST['order_sn']) ."' AND ";
if($rec_id)$wheres.=" r.return_id = '$return_id' AND ";
$result = get_filter();
if ($result === false)
{
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
$where = 'WHERE 1 ';
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || (intval($_REQUEST['page']) <= 0) ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0)
{
$filter['page_size'] = intval($_REQUEST['page_size']);
}
elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0)
{
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
}
else
{
$filter['page_size'] = 15;
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('back_order') . $wheres;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
$sql = "SELECT g.goods_thumb,oi.order_sn,g.goods_thumb,g.goods_name,r.*, o.goods_id, o.goods_name,o.order_id, o.goods_sn, o.market_price, o.goods_number, " .
"o.goods_price,oi.consignee,oi.email,oi.shipping_time, o.goods_attr, o.is_real, o.parent_id, o.is_gift,oi.user_id, " .
"o.goods_price * o.goods_number AS subtotal, o.extension_code " .
"FROM " . $GLOBALS['ecs']->table('return') ." AS r ".
"LEFT JOIN ". $GLOBALS['ecs']->table('order_goods') ." AS o ON r.rec_id =o.rec_id ".
"LEFT JOIN ". $GLOBALS['ecs']->table('goods') ." AS g ON g.goods_id =o.goods_id ".
"LEFT JOIN ". $GLOBALS['ecs']->table('order_info') ." AS oi ON oi.order_id =o.order_id ".
"WHERE $wheres r.return_type>0 ORDER BY r.return_add_time DESC " . $filter['sort_by'] . " " . $filter['sort_order']. "
LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
set_filter($filter, $sql);
}
else
{
$sql = $result['sql'];
$filter = $result['filter'];
}
$res = $GLOBALS['db']->getAll($sql);
foreach($res AS $key => $row){
if ($row['extension_code'] == 'package_buy')
{
$res[$key]['package_goods_list'] = get_package_goods($row['goods_id']);
}
$res[$key]['return_add_time']=local_date('Y-m-d', $row['return_add_time']);
$res[$key]['shipping_time']=local_date('Y-m-d', $row['shipping_time']);
switch ($row['return_status'])
{
case 1:
$res[$key]['return_status_name']='正在审核处理';
break;
case 2:
$res[$key]['return_status_name']='审核通过,正在处理';
break;
case 3:
$res[$key]['return_status_name']='审核未通过';
break;
case 4:
$res[$key]['return_status_name']='售后收货中';
break;
case 5:
$res[$key]['return_status_name']='售后已处理';
break;
case 6:
$res[$key]['return_status_name']='已完成';
break;
}
if($row['return_type']==1){
$res[$key]['return_type_name']='退货';
}elseif($row['return_type']==2){
$res[$key]['return_type_name']='换货';
}elseif($row['return_type']==3){
$res[$key]['return_type_name']='维修';
}
}
$arr = array('return' => $res, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
替换为:
//退换货 www.lyecs.com 老杨ecshop
function return_list($return_id=0)
{
$wheres .= empty($_REQUEST['consignee']) ? '' : " oi.consignee = '" .trim($_REQUEST['consignee']) ."' AND ";
$wheres .= empty($_REQUEST['kuaidi_no']) ? '' : " r.kuaidi_no = '". trim($_REQUEST['kuaidi_no']) ."' AND ";
$wheres .= empty($_REQUEST['order_sn']) ? '' : " oi.order_sn = '". trim($_REQUEST['order_sn']) ."' AND ";
if($return_id)$wheres.=" r.return_id = '$return_id' AND ";
$result = get_filter();
if ($result === false)
{
$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
$where = 'WHERE 1 ';
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || (intval($_REQUEST['page']) <= 0) ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0)
{
$filter['page_size'] = intval($_REQUEST['page_size']);
}
elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0)
{
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
}
else
{
$filter['page_size'] = 15;
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('return') ." WHERE ". ($return_id>0 ? "return_id = '$return_id'" : " 1");
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
$sql = "SELECT g.goods_thumb,oi.order_sn,g.goods_thumb,g.goods_name,r.*, o.goods_id, o.goods_name,o.order_id, o.goods_sn, o.market_price, o.goods_number, " .
"o.goods_price,oi.consignee,oi.email,oi.shipping_time, o.goods_attr, o.is_real, o.parent_id, o.is_gift,oi.user_id, " .
"o.goods_price * o.goods_number AS subtotal, o.extension_code " .
"FROM " . $GLOBALS['ecs']->table('return') ." AS r ".
"LEFT JOIN ". $GLOBALS['ecs']->table('order_goods') ." AS o ON r.rec_id =o.rec_id ".
"LEFT JOIN ". $GLOBALS['ecs']->table('goods') ." AS g ON g.goods_id =o.goods_id ".
"LEFT JOIN ". $GLOBALS['ecs']->table('order_info') ." AS oi ON oi.order_id =o.order_id ".
"WHERE $wheres r.return_type>0 ORDER BY r.return_add_time DESC " . $filter['sort_by'] . " " . $filter['sort_order']. "
LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
set_filter($filter, $sql);
}
else
{
$sql = $result['sql'];
$filter = $result['filter'];
}
$res = $GLOBALS['db']->getAll($sql);
foreach($res AS $key => $row){
if ($row['extension_code'] == 'package_buy')
{
$res[$key]['package_goods_list'] = get_package_goods($row['goods_id']);
}
$res[$key]['return_add_time']=local_date('Y-m-d', $row['return_add_time']);
$res[$key]['shipping_time']=local_date('Y-m-d', $row['shipping_time']);
switch ($row['return_status'])
{
case 1:
$res[$key]['return_status_name']='正在审核处理';
break;
case 2:
$res[$key]['return_status_name']='审核通过,正在处理';
break;
case 3:
$res[$key]['return_status_name']='审核未通过';
break;
case 4:
$res[$key]['return_status_name']='售后收货中';
break;
case 5:
$res[$key]['return_status_name']='售后已处理';
break;
case 6:
$res[$key]['return_status_name']='已完成';
break;
}
if($row['return_type']==1){
$res[$key]['return_type_name']='退货';
}elseif($row['return_type']==2){
$res[$key]['return_type_name']='换货';
}elseif($row['return_type']==3){
$res[$key]['return_type_name']='维修';
}
}
$arr = array('return' => $res, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}