gaoyixia/application/order/controller/RefundOrder.php

<?php
namespace app\order\controller;
use app\common\model\GoodsOrder;
use app\common\model\GoodsOrderItem;
use app\common\model\GoodsOrderRefund;
use app\common\model\OrderRefundCase;
use app\common\model\StoreOrderRefund;
use app\common\model\UserMessage;
use app\common\service\OrderCallback;
use EasyWeChat\Factory;
use library\Controller;
use think\Db;
/**
 * 商品订单
 * Class CustomOrder
 * @package app\order\controller
 */
class RefundOrder extends Controller
{
    protected $table = 'StoreOrderRefund';
    /**
     * 订单列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->title = '订单管理';
        $this->order_status = ['待支付','已支付'];
        $this->all_pay_type = all_pay_type();
        $query = $this->_query($this->table);
        $where = [];
        $where[] = ['o.is_deleted','=',0];
        $where[] = ['r.order_type','=',2];
        $where[] = ['r.status','<>',5];
        if($this->request->request('tel'))$where[]= ['u.phone','like','%'.$this->request->request('tel').'%'];
        if($this->request->request('order_no'))$where[]= ['o.order_no','like','%'.$this->request->request('order_no').'%'];
        if($this->request->request('user_name'))$where[]= ['u.name','like','%'.$this->request->request('user_name').'%'];
        $query->alias('r')
            ->field('r.express_time,r.consignee_add,r.consignee_name,r.consignee_tel,r.express_company,r.express_no,r.id as rid,refund_type,r.create_at as rtime,r.status as rstatus,r.express_info,r.order_id,r.refund_money,r.order_type, u.name ,u.phone as user_phone,u.headimg, o.*')
            ->join('StoreMember u','r.user_id = u.id ','LEFT')
            ->join('StoreOrder o',' o.id = r.order_id ','LEFT');
        $arr = ['is_new' => 0];
        \app\common\model\StoreOrderRefund::alias('f')->where('is_new',1)->update($arr);
        if(!empty($where)) $query->where($where);
        $query ->order('r.create_at desc')->page();
    }

    /**
     * 订单列表处理
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _index_page_filter(array &$data)
    {
        foreach ($data as &$vo) {
            $vo['item_list'] =  GoodsOrderItem::field('i.num,i.sell_price,g.name,i.goods_spec')
                ->alias('i')
                ->where(['i.order_id'=>$vo['id']])
                ->leftJoin('StoreGoods g','g.id = i.goods_id')
                ->select();
        }
    }

    /**
     * 订单审核
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function audit()
    {
        $this->title = '审核';
        $this->_form($this->table);
    }



    /**
     * 表单数据处理
     * @auth true
     * @menu true
     * @param array $data
     */
    protected function _form_filter(&$data)
    {
        if($this->request->isGet() && $this->request->action() == 'audit'){
            $this->order_info = GoodsOrder::where('id',$data['order_id'])->find()->toArray();
            $data['apply_case_title'] = OrderRefundCase::where('id',$data['apply_case'])->value('title');
        }
        if($this->request->isPost() && $this->request->action() == 'audit'){
            if($data['price_total'] < $data['refund_money']) $this->error('退款金额不能超过支付金额');
        }

    }

    protected function _form_result($id)
    {
        if($this->request->isPost() && $this->request->action() == 'audit'){
            $refund_info = StoreOrderRefund::where('id',$id)->find()->toArray();
            $status = input('post.status');
            $sh_status = 1;
            switch ($status){
                case 1:
                    $sh_status = 3;
                    break;
                case 2:
                    $sh_status = 2;
                    break;
                case 3:
                    $sh_status = 3;
                    break;
            }
            if($sh_status > 1){
                GoodsOrder::where('id',$refund_info['order_id'])->update(['refund_state'=>$sh_status]);
                UserMessage::sendUserMessage($refund_info['user_id'],'mall',1,0,0,$refund_info['order_id'],'您的退款申请已通过审核',$refund_info['order_id']);
            }
            if($status == 3) {
                $res = OrderCallback::refundMoney($refund_info,[],$refund_info['order_id']);
                if($res['code'] != 200) StoreOrderRefund::where('id',$id)->update(['status'=>4]);
                if($res['code'] == 200){
                    UserMessage::sendUserMessage($refund_info['user_id'],'mall',1,0,0,$refund_info['order_id'],'退款成功',$refund_info['order_id']);
                    $this->success($res['msg']);
                }else{
                    $this->error($res['msg']);
                }
            }
            StoreOrderRefund::where('id',$id)->update(['examine_time'=>date('Y-m-d H:i:s')]);
        }
    }

    public function refund()
    {
        if($this->request->isPost()){
            $id = input('post.id');
            $refund_info = GoodsOrderRefund::where('id',$id)->find()->toArray();
            $order_info = GoodsOrder::where('id',$refund_info['order_id'])->find()->toArray();
            if($refund_info['status'] == 3) $this->error('已退款');
            if($refund_info['status'] == 5) $this->error('申请已取消');
            if ($order_info['price_total'] < $refund_info['refund_money'])return $this->error('退款金额错误');
            $res = OrderCallback::refundMoney($refund_info,$order_info,$refund_info['order_id']);
            if($res['code'] == 200) {
                UserMessage::sendUserMessage($refund_info['user_id'],'mall',1,0,0,$refund_info['order_id'],'退款成功',$refund_info['order_id']);
                $this->success($res['msg']);
            }else{
                $this->error($res['msg']);
            };
        }
    }



}