point_mall_admin/app/admin/controller/Refund.php

<?php

namespace app\admin\controller;

use think\facade\View;
use think\facade\Lang;

/**
 * ============================================================================
 * DSMall多用户商城
 * ============================================================================
 * 版权所有 2014-2028 长沙德尚网络科技有限公司，并保留所有权利。
 * 网站地址: http://www.csdeshang.com
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
 * 不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * 控制器
 */
class Refund extends AdminControl
{
    const EXPORT_SIZE = 1000;

    public function initialize()
    {
        parent::initialize();
        Lang::load(base_path() . 'admin/lang/' . config('lang.default_lang') . '/refund.lang.php');
        //向模板页面输出退款退货状态
        $this->getRefundStateArray();
    }

    function getRefundStateArray($type = 'all')
    {
        $state_array = [
            '1' => lang('refund_state_confirm'), '2' => lang('refund_state_yes'), '3' => lang('refund_state_no'),
        ]; //卖家处理状态:1为待审核,2为同意,3为不同意
        View::assign('state_array', $state_array);

        $admin_array = [
            '1' => lang('admin_state_1'), '2' => lang('admin_state_2'), '3' => lang('admin_state_3'), '4' => lang('refund_state_no'),
        ]; //确认状态:1为买家或卖家处理中,2为待平台管理员处理,3为退款退货已完成
        View::assign('admin_array', $admin_array);

        $state_data = [
            'seller' => $state_array, 'admin' => $admin_array,
        ];
        if ($type == 'all') {
            return $state_data; //返回所有
        }
        return $state_data[$type];
    }

    /**
     * 待处理列表
     */
    public function refund_manage()
    {
        $refundreturn_model = model('refundreturn');
        $condition          = [];
        $condition[]        = ['refund_type', '=', 1];
        $condition[]        = ['refund_state', '=', '2']; //状态:1为处理中,2为待管理员处理,3为已完成

        $keyword_type = ['order_sn', 'refund_sn', 'store_name', 'buyer_name', 'goods_name'];
        $key          = input('get.key');
        $type         = input('get.type');
        if (trim($key) != '' && in_array($type, $keyword_type)) {
            $condition[] = [$type, 'like', '%' . $key . '%'];
        }
        $add_time_from = input('get.add_time_from');
        $add_time_to   = input('get.add_time_to');
        if (trim($add_time_from) != '') {
            $add_time_from = strtotime(trim($add_time_from));
            if ($add_time_from !== false) {
                $condition[] = ['add_time', '>=', $add_time_from];
            }
        }
        if (trim($add_time_to) != '') {
            $add_time_to = strtotime(trim($add_time_to)) + 86399;
            if ($add_time_to !== false) {
                $condition[] = ['add_time', '<=', $add_time_to];
            }
        }
        $refund_list = $refundreturn_model->getRefundList($condition, 10);
        View::assign('show_page', $refundreturn_model->page_info->render());
        View::assign('refund_list', $refund_list);
        $this->setAdminCurItem('refund_manage');
        return View::fetch('refund_manage');
    }

    /**
     * 所有记录
     */
    public function refund_all()
    {
        $refundreturn_model = model('refundreturn');
        $condition          = [];
        $condition[]        = ['refund_type', '=', 1];
        $keyword_type       = ['order_sn', 'refund_sn', 'store_name', 'buyer_name', 'goods_name'];
        $key                = input('get.key');
        $type               = input('get.type');
        if (trim($key) != '' && in_array($type, $keyword_type)) {
            $condition[] = [$type, 'like', '%' . $key . '%'];
        }
        $add_time_from = input('get.add_time_from');
        $add_time_to   = input('get.add_time_to');
        if (trim($add_time_from) != '') {
            $add_time_from = strtotime(trim($add_time_from));
            if ($add_time_from !== false) {
                $condition[] = ['add_time', '>=', $add_time_from];
            }
        }
        if (trim($add_time_to) != '') {
            $add_time_to = strtotime(trim($add_time_to)) + 86399;
            if ($add_time_to !== false) {
                $condition[] = ['add_time', '<=', $add_time_to];
            }
        }
        $refund_list = $refundreturn_model->getRefundList($condition, 10);
        View::assign('show_page', $refundreturn_model->page_info->render());
        View::assign('refund_list', $refund_list);
        $this->setAdminCurItem('refund_all');
        return View::fetch('refund_all');
    }

    /**
     * 退款处理页
     *
     */
    public function edit()
    {
        $refundreturn_model = model('refundreturn');
        $condition          = [];
        $condition[]        = ['refund_id', '=', intval(input('param.refund_id'))];
        $refund_list        = $refundreturn_model->getRefundList(array_merge($condition, [['refund_type', '=', 1]]));
        $refund             = $refund_list[0];
        if (request()->isPost()) {
            if (!in_array(input('post.refund_state'), [3, 4])) {
                $this->error(lang('refund_state_null'));
            }
            $check = request()->checkToken('__token__');
            if (false === $check) {
                $this->error('invalid token');
            }
            if ($refund['refund_state'] != '2') {//检查状态,防止页面刷新不及时造成数据错误
                $this->error(lang('ds_common_save_fail'));
            }
            $order_id                      = $refund['order_id'];
            $refund_array                  = [];
            $refund_array['admin_time']    = TIMESTAMP;
            $refund_array['refund_state']  = '4'; //状态:1为处理中,2为待管理员处理,3为已完成
            $refund_array['admin_message'] = input('post.admin_message');
            if (input('post.refund_state') == '3') {
                $refund_array['refund_state'] = '3';
                $res                          = $refundreturn_model->editOrderRefund($refund);
                $state                        = $res['code'];
                if (!$state) {
                    $this->error($res['msg']);
                }
            } else {
                if ($refund['order_lock'] == '2') {
                    $state = $refundreturn_model->editOrderUnlock($order_id); //订单解锁
                } else {
                    $state = true;
                }
                //自提点订单解锁
                $chain_order_model = model('chain_order');
                $chain_order_model->editChainOrderUnlock($order_id);
            }

            if ($state) {
                $refundreturn_model->editRefundreturn($condition, $refund_array);

                // 发送买家消息
                $param              = [];
                $param['code']      = 'refund_return_notice';
                $param['member_id'] = $refund['buyer_id'];
                //阿里短信参数
                $param['ali_param'] = [
                    'refund_sn' => $refund['refund_sn'],
                ];
                $param['ten_param'] = [
                    $refund['refund_sn'],
                ];
                $param['param']     = array_merge($param['ali_param'], [
                    'refund_url' => HOME_SITE_URL . '/memberrefund/view?refund_id=' . $refund['refund_id'],
                ]);
                //微信模板消息
                $param['weixin_param'] = [
                    'url'  => config('ds_config.h5_site_url') . '/member/refund_view?refund_id=' . $refund['refund_id'],
                    'data' => [
                        "keyword1" => [
                            "value" => $refund['order_sn'],
                            "color" => "#333",
                        ],
                        "keyword2" => [
                            "value" => $refund['refund_amount'],
                            "color" => "#333",
                        ],
                    ],
                ];
                \mall\queue\QueueClient::push('sendMemberMsg', $param);

                $this->log('退款确认，退款编号' . $refund['refund_sn']);
                dsLayerOpenSuccess(lang('ds_common_save_succ'));
            } else {
                $this->error(lang('ds_common_save_fail'));
            }
        }
        View::assign('refund', $refund);
        $info['buyer'] = [];
        if (!empty($refund['pic_info'])) {
            $info = unserialize($refund['pic_info']);
        }
        View::assign('pic_list', $info['buyer']);
        return View::fetch('edit');
    }

    /**
     * 退款记录查看页
     *
     */
    public function view()
    {
        $refundreturn_model = model('refundreturn');
        $condition          = [];
        $condition[]        = ['refund_id', '=', intval(input('param.refund_id'))];
        $condition[]        = ['refund_type', '=', 1];
        $refund_list        = $refundreturn_model->getRefundList($condition);
        $refund             = $refund_list[0];
        View::assign('refund', $refund);
        $info['buyer'] = [];
        if (!empty($refund['pic_info'])) {
            $info = unserialize($refund['pic_info']);
        }
        View::assign('pic_list', $info['buyer']);
        return View::fetch('view');
    }

    /**
     * 退款退货原因
     */
    public function reason()
    {
        $refundreturn_model = model('refundreturn');
        $condition          = [];
        $reason_list        = $refundreturn_model->getReasonList($condition, 10);
        View::assign('reason_list', $reason_list);
        View::assign('show_page', $refundreturn_model->page_info->render());

        $this->setAdminCurItem('reason');
        return View::fetch('reason');
    }

    /**
     * 新增退款退货原因
     */
    public function add_reason()
    {
        $refundreturn_model = model('refundreturn');
        if (request()->post()) {
            $reason_array                      = [];
            $reason_array['reason_info']       = input('post.reason_info');
            $reason_array['reason_sort']       = intval(input('post.reason_sort'));
            $reason_array['reason_updatetime'] = TIMESTAMP;

            $state = $refundreturn_model->addReason($reason_array);
            if ($state) {
                $this->log('新增退款退货原因，编号' . $state);
                dsLayerOpenSuccess(lang('ds_common_save_succ'));
            } else {
                $this->error(lang('ds_common_save_fail'));
            }
        }
        return View::fetch('add_reason');
    }

    /**
     * 编辑退款退货原因
     *
     */
    public function edit_reason()
    {
        $refundreturn_model = model('refundreturn');
        $condition          = [];
        $reason_id          = intval(input('param.reason_id'));
        $condition[]        = ['reason_id', '=', $reason_id];
        $reason_list        = $refundreturn_model->getReasonList($condition);
        $reason             = $reason_list[$reason_id];
        if (request()->post()) {
            $reason_array                      = [];
            $reason_array['reason_info']       = input('post.reason_info');
            $reason_array['reason_sort']       = intval(input('post.reason_sort'));
            $reason_array['reason_updatetime'] = TIMESTAMP;
            $state                             = $refundreturn_model->editReason($condition, $reason_array);
            if ($state) {
                $this->log('编辑退款退货原因，编号' . $reason_id);
                dsLayerOpenSuccess(lang('ds_common_save_succ'));
            } else {
                $this->error(lang('ds_common_save_fail'));
            }
        }
        View::assign('reason', $reason);
        return View::fetch('edit_reason');
    }

    /**
     * 删除退款退货原因
     *
     */
    public function del_reason()
    {
        $refundreturn_model = model('refundreturn');
        $reason_id          = input('param.reason_id');
        $reason_id_array    = ds_delete_param($reason_id);
        if ($reason_id_array === FALSE) {
            ds_json_encode('10001', lang('param_error'));
        }
        $condition = [['reason_id', 'in', $reason_id_array]];
        $state     = $refundreturn_model->delReason($condition);
        if ($state) {
            $this->log('删除退款退货原因，编号' . $reason_id);
            ds_json_encode('10000', lang('ds_common_del_succ'));
        } else {
            ds_json_encode('10001', lang('ds_common_del_fail'));
        }
    }

    /**
     * 导出
     *
     */
    public function export_step1()
    {

        $refundreturn_model = model('refundreturn');
        $condition          = [];

        $keyword_type = ['order_sn', 'refund_sn', 'store_name', 'buyer_name', 'goods_name'];
        $key          = input('get.key');
        $type         = input('get.type');
        if (trim($key) != '' && in_array($type, $keyword_type)) {
            $condition[] = [$type, 'like', '%' . $key . '%'];
        }
        $add_time_from = input('get.add_time_from');
        $add_time_to   = input('get.add_time_to');
        if (trim($add_time_from) != '') {
            $add_time_from = strtotime(trim($add_time_from));
            if ($add_time_from !== false) {
                $condition[] = ['add_time', '>=', $add_time_from];
            }
        }
        if (trim($add_time_to) != '') {
            $add_time_to = strtotime(trim($add_time_to)) + 86399;
            if ($add_time_to !== false) {
                $condition[] = ['add_time', '<=', $add_time_to];
            }
        }
        if (!is_numeric(input('param.page'))) {
            $count       = $refundreturn_model->getRefundCount($condition);
            $export_list = [];
            if ($count > self::EXPORT_SIZE) { //显示下载链接
                $page = ceil($count / self::EXPORT_SIZE);
                for ($i = 1; $i <= $page; $i++) {
                    $limit1          = ($i - 1) * self::EXPORT_SIZE + 1;
                    $limit2          = $i * self::EXPORT_SIZE > $count ? $count : $i * self::EXPORT_SIZE;
                    $export_list[$i] = $limit1 . ' ~ ' . $limit2;
                }
                View::assign('export_list', $export_list);
                return View::fetch('/public/excel');
            } else { //如果数量小，直接下载
                $data = $refundreturn_model->getRefundList(array_merge($condition, [['refund_type', '=', 1]]), '', '*', 'refund_id desc', self::EXPORT_SIZE);
                $this->createExcel($data);
            }
        } else { //下载
            $limit1 = (input('param.page') - 1) * self::EXPORT_SIZE;
            $limit2 = self::EXPORT_SIZE;
            $data   = $refundreturn_model->getRefundList(array_merge($condition, [['refund_type', '=', 1]]), $limit2, '*', 'refund_id desc');
            $this->createExcel($data);
        }
    }

    /**
     * 生成excel
     *
     * @param array $data
     */
    private function createExcel($data = [])
    {
        Lang::load(base_path() . 'admin/lang/' . config('lang.default_lang') . '/export.lang.php');
        $excel_obj  = new \excel\Excel();
        $excel_data = [];
        //设置样式
        $excel_obj->setStyle(['id' => 's_title', 'Font' => ['FontName' => '宋体', 'Size' => '12', 'Bold' => '1']]);
        //header
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('ds_order_sn')];
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('ds_refund_sn')];
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('ds_store_name')];
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('ds_goods_name')];
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('ds_buyer_name')];
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('exp_tk_order_add_time')];
        $excel_data[0][] = ['styleid' => 's_title', 'data' => lang('exp_tk_order_refund')];
        //data
        foreach ((array)$data as $k => $v) {
            $tmp          = [];
            $tmp[]        = ['data' => 'DS' . $v['order_sn']];
            $tmp[]        = ['data' => $v['refund_sn']];
            $tmp[]        = ['data' => $v['store_name']];
            $tmp[]        = ['data' => $v['goods_name']];
            $tmp[]        = ['data' => $v['buyer_name']];
            $tmp[]        = ['data' => date('Y-m-d H:i:s', $v['add_time'])];
            $tmp[]        = ['format' => 'Number', 'data' => ds_price_format($v['refund_amount'])];
            $excel_data[] = $tmp;
        }
        $excel_data = $excel_obj->charset($excel_data, CHARSET);
        $excel_obj->addArray($excel_data);
        $excel_obj->addWorksheet($excel_obj->charset(lang('exp_tk_refund'), CHARSET));
        $excel_obj->generateXML($excel_obj->charset(lang('exp_tk_refund'), CHARSET) . input('param.page') . '-' . date('Y-m-d-H', TIMESTAMP));
    }

    /**
     * 获取卖家栏目列表,针对控制器下的栏目
     */
    protected function getAdminItemList()
    {
        $menu_array = [
            [
                'name' => 'refund_manage', 'text' => lang('admin_state_2'), 'url' => (string)url('Refund/refund_manage'),
            ], [
                'name' => 'refund_all', 'text' => lang('refund_all'), 'url' => (string)url('Refund/refund_all'),
            ], [
                'name' => 'reason', 'text' => lang('refund_return_reason'), 'url' => (string)url('Refund/reason'),
            ],
        ];
        if (request()->action() == 'reason') {
            $menu_array[] = [
                'name' => 'add_reason', 'text' => lang('add_reason'), 'url' => "javascript:dsLayerOpen('" . (string)url('Refund/add_reason') . "','" . lang('add_reason') . "')",
            ];
        }
        return $menu_array;
    }
}

?>