LYECS 2.0 BUG修复

重要:部份2.0客户因为文件疏漏遗留了退换货后台管理显示问题

LYECS,LYECS+商城系统,多用户商城系统,开源商城系统 发布日期:2015-08-24   作者:老杨

重要:部份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;
}

热门文章

分类标签