dms-api/app/v1/model/gameLog/SdkLoginLog.php

<?php
// +----------------------------------------------------------------------
// | saiadmin [ saiadmin快速开发框架 ]
// +----------------------------------------------------------------------
// | Author: your name
// +----------------------------------------------------------------------
namespace app\v1\model\gameLog;

use plugin\saiadmin\basic\BaseNormalModel;

/**
 * 登录日志模型
 */
class SdkLoginLog extends BaseNormalModel
{
    /**
     * 数据表主键
     * @var string
     */
    protected $pk = 'id';

    /**
     * 数据库表名称
     * @var string
     */
    protected $table = 'sdk_login_log_202507';

    /**
     * 数据库连接
     * @var string
     */
    protected $connection = 'db_game_log';


    /**
     * 登录时间搜索
     * 传入的是日期， 搜索的是同一天
     * 
     */
    public function searchLoginTimeAttr($query, $value)
    {
        $sTime = strtotime($value . " 00:00:00");
        $eTime = strtotime($value . " 23:59:59");

        $query->where('login_time', 'between', [$sTime, $eTime]);
    }

    /**
     * 注册时间搜索
     * 传入的是日期， 搜索的是同一天
     * 
     */
    public function searchRegTimeAttr($query, $value)
    {
        $sTime = strtotime($value . " 00:00:00");
        $eTime = strtotime($value . " 23:59:59");
        $query->where('reg_time', 'between', [$sTime, $eTime]);
    }

}