NN2023021801/app/admin/logic/MoneyLogLogic.php

<?php


namespace app\admin\logic;


use app\admin\model\dao\MoneyLog;
use app\admin\model\dao\ScoreLog;
use app\admin\model\dao\ShopOrder;
use app\admin\model\dao\User;
use app\common\model\UserMoneyModel;
use think\facade\Cache;
use think\facade\Db;

class MoneyLogLogic
{

    // 1.预约福袋  2.回收商品 3.预约福袋空盒退回  4.奖金流失  5.直推收益到奖金  6-奖金领取  7-团队收益到奖金  8-利润结算兑换  9-余额提现  10-提现失败退还  11-提现多次返回  12-提现手续费退回，13-提现失败退回 14-奖金领取退回  15-系统退回  16-平台充值  17-平台扣除
    private static $typeMap = [
        ['id' => 0, 'name' => '其他'],
        ['id' => 1, 'name' => '预约福袋'],
        ['id' => 2, 'name' => '回收商品'],
        ['id' => 3, 'name' => '预约福袋空盒退回'],
        ['id' => 4, 'name' => '奖金流失'],
        ['id' => 5, 'name' => '直推收益到奖金'],
        ['id' => 6, 'name' => '奖金领取'],
        ['id' => 7, 'name' => '团队收益到奖金'],
        ['id' => 8, 'name' => '利润结算兑换'],
        ['id' => 9, 'name' => '余额提现'],
        ['id' => 10, 'name' => '提现失败退还'],
        ['id' => 11, 'name' => '提现多次返回'],
        ['id' => 12, 'name' => '提现手续费退回'],
        ['id' => 13, 'name' => '提现失败退回'],
        ['id' => 14, 'name' => '奖金领取退回'],
        ['id' => 15, 'name' => '系统退回'],
        ['id' => 16, 'name' => '平台充值'],
        ['id' => 17, 'name' => '平台扣除'],
    ];

    private static $stateMap = [
        ['id' => 1, 'name' => '增加'],
        ['id' => 2, 'name' => '减少']
    ];

    /**
     * @return array[]
     */
    public static function getStateMap(): array
    {
        return self::$stateMap;
    }

    /**
     * @return array[]
     */
    public static function getTypeMap(): array
    {
        return self::$typeMap;
    }

    public static function getMoneyLog($page, $limit, $where, $sort)
    {
        $model = new UserMoneyModel();
        $count = $model
            ->where($where)
            ->count();

        $type_conf = config('type.money');

        $list = $model
            ->where($where)
            ->withAttr('type', function ($value, $data) use ($type_conf) {
                return $type_conf[$value];
            })
            ->withAttr('money', function ($value, $data) {
                if ($data['state'] == 2)
                    $value = '-' . $value;
                return $value;
            })
            ->page($page, $limit)
            ->order($sort)
            ->select();
        return [$count, $list];
    }
}