LJH_Shop/niucloud/app/service/admin/order/RechargeOrderRefundService.php

<?php
// +----------------------------------------------------------------------
// | Niucloud-admin 企业快速开发的saas管理平台
// +----------------------------------------------------------------------
// | 官方网址：https://www.niucloud.com
// +----------------------------------------------------------------------
// | niucloud团队 版权所有 开源版本可自由商用
// +----------------------------------------------------------------------
// | Author: Niucloud Team
// +----------------------------------------------------------------------

namespace app\service\admin\order;

use app\dict\order\RechargeOrderDict;
use app\model\order\RechargeOrderItemRefund;
use app\service\core\order\recharge\CoreRechargeRefundService;
use core\base\BaseAdminService;
use Exception;

/**
 * 充值订单
 * Class RechargeOrderService
 * @package app\service\admin\order
 */
class RechargeOrderRefundService extends BaseAdminService
{
    public function __construct()
    {
        parent::__construct();
        $this->model = new RechargeOrderItemRefund();
    }

    public function create($order_id) {
        try {
            (new CoreRechargeRefundService())->create($this->site_id, $order_id);
            return true;
        } catch ( Exception $e) {
            return $e->getMessage();
        }
    }

    /**
     * 查询退款列表
     * @param array $where
     * @return array
     */
    public function getPage(array $where) {

        $field = 'recharge_order_item_refund.refund_id,recharge_order_item_refund.num,recharge_order_item_refund.money,recharge_order_item_refund.refund_no,recharge_order_item_refund.status,recharge_order_item_refund.create_time,recharge_order_item_refund.audit_time,recharge_order_item_refund.transfer_time,recharge_order_item_refund.item_type,recharge_order_item_refund.order_item_id, recharge_order_item_refund.order_id,recharge_order_item_refund.member_id,recharge_order_item_refund.order_no';
        $member_where = [];
        if(!empty($where['keywords']))
        {
            $member_where[] = ["member.member_id|member.nickname|member.mobile", '=', $where['keywords']];
        }
        $search_model = $this->model->where([['recharge_order_item_refund.site_id', '=', $this->site_id]])->with(['item' => function($query) {
            $query->with('orderNo')->field('order_id, order_item_id, item_name, item_image');
        }])->withSearch(['join_order_no' => 'order_no', 'join_status' => 'status', 'join_member_id' => 'member_id', 'refund_no' => 'refund_no', 'join_create_time' => 'create_time'],$where)
            ->withJoin(['member' => ['memeber_id', 'member_no', 'username', 'mobile', 'nickname', 'headimg']
        ])->where($member_where)->field($field)->order('create_time desc')->append(['status_name', 'payrefund.type_name']);

        return $this->pageQuery($search_model);
    }

    /**
     * 查询退款详情
     * @param int $refund_id
     * @return array
     */
    public function getDetail(int $refund_id) {
        $field = 'refund_id,num,money,refund_no,status,create_time,audit_time,transfer_time,item_type,order_item_id, order_id,member_id';
        return $this->model->where([ ['site_id', '=', $this->site_id], ['refund_id', '=', $refund_id]])->field($field)->with(['item' => function($query) {
            $query->field('order_item_id, item_name, item_image');
        }, 'member' => function($query) {
            $query->field('member_id, nickname, mobile, headimg');
        }, 'payrefund' => function($query) {
            $query->field('refund_no');
        }])->append(['status_name', 'payrefund.type_name'])->findOrEmpty()->toArray();
    }

    /**
     * 获取退款状态
     * @return array|array[]|string
     */
    public function getStatus(){
        return RechargeOrderDict::getRefundStatus();
    }

    /**
     * 退款统计数据(根据状态查询)
     */
    public function stat()
    {
        $status = RechargeOrderDict::getRefundStatus();
        $all = 0;
        $have = 0;
        foreach ($status as $k => &$v)
        {
            $money = $this->model->where([['status', '=', $v['status']], ['site_id', '=', $this->site_id]])->sum("money");
            if($money == null)
            {
                $money = 0;
            }
            if($k == 1 || $k == 2){
                $have += $money;
            }
            $v['money'] = number_format($money, 2);
            $all += $money;
        }
        $status['all'] = [
            'name' => get_lang('dict_refund.all'),
            'key' => 'all',
            'money' => number_format($all, 2)
        ];
        $status['have'] = [
            'name' => get_lang('dict_refund.have'),
            'key' => 'all',
            'money' => number_format($have, 2)
        ];
        return $status;

    }
}