NN2023021801/app/common/model/UserMoneyModel.php

<?php
/**
 * 用户余额
 */

namespace app\common\model;


use think\facade\Db;
use think\Model;

class UserMoneyModel extends Model
{
    protected $name = 'money_log';

    /**
     * 记录
     * @param $param
     * @return array
     * @throws \think\db\exception\DbException
     */
    public function getLog ($request)
    {
        $type_conf = config('type.money');
        $list = self::where('uid', $request->uid)
            ->field('money,id,type,create_at,state')
            ->withAttr('type', function ($value, $data) use ($type_conf) {
                return isset($type_conf[$value]) ? $type_conf[$value] : '未知类型';
            })
            ->order('create_at', 'desc')
            ->paginate($request->data['limit'])
            ->toArray();
//        $history = self::where([
//            ['uid', '=', $param->uid],
//            ['state', '=', 1]
//        ])->sum('money');
//        return compact('list', 'history');
        if (empty($list['data'])){
            return null;
        }
        return $list['data'];
    }

    public function getRedLog ($request)
    {
        $type_conf = config('type.money');
        $condition = ['uid'=> $request->uid, 'type'=>4];

        $list = self::where($condition)
            ->field('money,id,type,create_at,state,uid')
            ->withAttr('type', function ($value, $data) use ($type_conf) {
                return isset($type_conf[$value]) ? $type_conf[$value] : '未知类型';
            })
            ->order('create_at', 'desc')
            ->paginate($request->data['limit'])
            ->toArray();

//        $history = self::where([
//            ['uid', '=', $param->uid],
//            ['state', '=', 1]
//        ])->sum('money');
//        return compact('list', 'history');
        if (empty($list['data'])){
            return null;
        }
        return $list['data'];
    }



    public static function change ($data)
    {
        if ($data['state'] == 1) {
            $data['after_money'] = $data['before_money'] + $data['money'];
        } else {
            $data['after_money'] = $data['before_money'] - $data['money'];
        }
        $model = new self();
        if ($model->save($data)) {
            return $model->id;
        }
        return false;
    }
}