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

class BoxMidHandleLogic
{

    public static function getList($page, $limit)
    {

        $count = (new BoxMidHandleModel())
            ->alias('r')
            ->leftJoin('user u', 'u.id = r.uid')
            ->field('r.*,u.mobile,u.total_null_box,u.total_free,u.total_income')
            ->order('r.box_type desc')
            ->page($page, $limit)
            ->count();

        $list = (new BoxMidHandleModel())
            ->alias('r')
            ->leftJoin('user u', 'u.id = r.uid')
            ->field('r.*,u.mobile,u.total_null_box,u.total_free,u.total_income,u.total_appoint_count,u.box10,u.box20,u.box30,u.box40')
            ->order('r.box_type desc')
            ->page($page, $limit)
            ->select()->toArray();

        return [$count, $list];
    }
}