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-团队收益，8-利润结算兑换,10-提现失败退还，12-平台充补，13-平台扣除 14-提现失败退还手续费',
    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' => 8, 'name' => '利润结算兑换'],
        ['id' => 10, 'name' => '提现失败退还'],
        ['id' => 12, 'name' => '平台充补'],
        ['id' => 13, 'name' => '平台扣除'],
        ['id' => 14, '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];
    }
}