bike-admin/app/Models/DepositOrder.php

<?php

namespace App\Models;

use App\Traits\ModelHelpers;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\Log;

class DepositOrder extends Model
{
    use ModelHelpers;

    const NO_TAG = 'Y';
    //押金订单表
    protected $table = "deposit_orders";
    protected $guarded = [];

    const STATUS_OK = 1;
    const STATUS_PAUSE = 0;
    public static $statusMaps = [
        self::STATUS_OK => '正常',
        self::STATUS_PAUSE => '暂停'
    ];

    const PAY_STATUS_OK = 1;
    const PAY_STATUS_NO = 0;
    public static $payStatusMaps = [
        self::PAY_STATUS_NO => '未支付',
        self::PAY_STATUS_OK => '缴纳成功'
    ];

    const PAY_TYPE_NO = 0;
    const PAY_TYPE_WECHAT = 1;
    const PAY_TYPE_ACCOUNT = 2;
    const PAY_TYPE_ALIPAYMINI = 3;
    const PAY_TYPE_ALIPAYMINI_CREDIT = 4;
    public static $payTypeMaps = [
        self::PAY_TYPE_NO => '待支付',
        self::PAY_TYPE_WECHAT => '微信支付',
        self::PAY_TYPE_ACCOUNT => '余额支付',
        self::PAY_TYPE_ALIPAYMINI => '支付宝支付',
        self::PAY_TYPE_ALIPAYMINI_CREDIT => '支付宝免押金支付',
    ];


    const REFUND_OK = 1;
    const REFUND_NO = 0;
    public static $refundMaps = [
        self::REFUND_OK => '已退款',
        self::REFUND_NO => '未退款'
    ];
    // 交易类型 用is_refund 判断
    public static $transactionTypeMaps = [
        self::REFUND_OK => '退还押金',
        self::REFUND_NO => '缴纳押金'
    ];

    public function depositRefund()
    {
        return $this->hasOne(DepositRefund::class, 'deposit_id', 'id');
    }

    public function users()
    {
        return $this->belongsTo('App\Models\User', 'user_id', 'id');
    }

    public function area()
    {
        return $this->belongsTo(Area::class, 'area_id', 'id');
    }

    /**
     * 生成订单号
     * @return bool|string
     * User: Mead
     */
    public static function makeNo()
    {
        // 订单流水号前缀
        $prefix = AdminMerchant::getOrderTag() . self::NO_TAG . date('YmdHis');
        for ($i = 0; $i < 10; $i++) {
            // 随机生成 6 位的数字
            $no = $prefix . str_pad(random_int(0, 999999), 6, '0', STR_PAD_LEFT);
            // 判断是否已经存在
            if (!static::query()->where('no', $no)->exists()) {
                return $no;
            }
        }
        Log::warning('find order no failed');
        return false;
    }




    /**
     * 退款回调
     * Author: Mead
     */
    public function refund_order_callback()
    {
        //商户平台直接退押金回调
        $user_id = $this->attributes['user_id'];
        $user = User::find($user_id);



        $re = CouponsUserBag::query()->where('user_id', $user_id)->where('coupon_type', CouponsUserBag::COUPON_TYPE_DEPOSIT_FREE)->where('valid_end_time', '<=', Carbon::now()->toDateTimeString())->where('status', CouponsUserBag::STATUS_OK)->exists();
        if ($re) {
            //是否有免押金劵
            User::where('id', $user_id)->update([
                'deposit_money' => 0,
                'is_deposit' => User::DEPOSIT_OK,
                'deposit_type' => User::DEPOSIT_COUPON
            ]);
        } else {
            $deposit_expire_time = Carbon::parse($user->deposit_expire_time);
            if (Carbon::now()->gte($deposit_expire_time)) {
                // 免押金卡已经过期
                User::where('id', $user_id)->update([
                    'deposit_money' => 0,
                    'is_deposit' => User::DEPOSIT_NO,
                    'deposit_type' => User::DEPOSIT_TYPE_NO
                ]);
            } else {
                // 免押金卡未过期
             User::where('id', $user_id)->update([
                    'deposit_money' => 0,
                    'is_deposit' => User::DEPOSIT_OK,
                    'deposit_type' => User::DEPOSIT_CARD
                ]);
            }
        }

        //检查退款请求
        RefundLog::where('deposit_id', $this->attributes['id'])->update([
            'pay_status' => RefundLog::PAY_STATUS_OK,
            'pay_time' => date('Y-m-d H:i:s')
        ]);
    }


}