NN2023021801/app/admin/logic/BoxRecordLogic.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\BoxRecordModel;
use app\common\model\UserMoneyModel;
use think\facade\Cache;
use think\facade\Db;

class BoxRecordLogic
{

    public static function getList( $page,  $limit,  $where, array $sort)
    {

        $count = (new BoxRecordModel())
            ->where($where)
            ->count();

        $list = (new BoxRecordModel())
            ->withJoin('user', 'LEFT')
            ->withAttr('box_img', function ($val, $data) {
                return getWebUrl() . '/' . $val;
            })
            ->where($where)
            ->page($page, $limit)
            ->order($sort)
            ->select();

        return [$count, $list];

    }
}