<?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\admin\model\SystemLog;
use app\common\model\BoxModel;
use app\common\model\UserMoneyModel;
use think\facade\Cache;
use think\facade\Db;

class SystemLogLogic
{

    public static function getList($page, $limit, $where, $excludeFields, $sort)
    {
        $month = (isset($excludeFields['month']) && !empty($excludeFields['month']))
            ? date('Ym', strtotime($excludeFields['month']))
            : date('Ym');

        // todo TP6框架有一个BUG，非模型名与表名不对应时（name属性自定义），withJoin生成的sql有问题

        $count = (new SystemLog())
            ->setMonth($month)
            ->with('admin')
            ->where($where)
            ->select();
        $list  = (new SystemLog())
            ->setMonth($month)
            ->with('admin')
            ->where($where)
            ->page($page, $limit)
            ->order($sort)
            ->select();

        return [$count, $list];
    }
}