NN2022100801/app/Modes/UserCoin.php

<?php

namespace App\Modes;

use Illuminate\Database\Eloquent\Model;

/**
 * App\Modes\UserCoin
 *
 * @property int $id
 * @property int $uid 用户id
 * @property int $order_id 订单id
 * @property float $price 单价
 * @property int $num 数量
 * @property float $total_price 总价
 * @property int $pay_type 支付方式 0-未支付 1-现金 2-支付宝 3-微信 4-银行转账 5-桃牛支付
 * @property int $status 状态 1-未审核 2-审核通过 3-审核拒绝 4-失效
 * @property string $remark 拒绝备注
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin newModelQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin newQuery()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin query()
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereNum($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereOrderId($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin wherePayType($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin wherePrice($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereRemark($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereStatus($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereTotalPrice($value)
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereUid($value)
 * @mixin \Eloquent
 * @property float $coin_parities 汇率
 * @method static \Illuminate\Database\Eloquent\Builder|\App\Modes\UserCoin whereCoinParities($value)
 */
class UserCoin extends Model
{
    protected $table = 'user_coin';
    public $timestamps = false;
    public static function updateCoin($order_id)
    {
        $coin = UserCoin::whereOrderId($order_id)->first();
        if (empty($coin)) {
            ErrorLog::saveMsg("点币记录[{$out_trade_no}]不存在");
        }
        $user = User::find($coin->uid);
        //点币记录

        $remark="用户【id:".$coin->uid."】，用途-购买点币".$coin->num.",支付金额【".$coin->total_price."】";
        AccountLog::insert([
            'uid' => $coin->uid,
            'type' => 32,
            'status' => 1,
            'money_type' => 1,
            'money' => $coin->total_price,
            'current_money' => $user->coin,
            'remark' => $remark
        ]);
        $coinUpdate = UserCoin::whereOrderId($order_id)->update([
            'status' => 2,
        ]);
        if (empty($coinUpdate)) {
            ErrorLog::saveMsg("点币记录[{$out_trade_no}]状态更新为已支付失败");
        }
        $num = User::whereId($coin->uid)->increment('coin',$coin->num);
        if (empty($num)) {
            ErrorLog::saveMsg("点币记录[{$out_trade_no}]入账失败：".$coin->num);
        }
        
    }
}