kknongchang_2506/app/Module/OpenAPI/Models/OpenApiRateLimit.php

<?php

namespace App\Module\OpenAPI\Models;

use UCore\ModelCore;

/**
 * OpenAPI频率限制记录模型
 * 
 * @property int $id
 * @property string $app_id 应用ID
 * @property string $ip_address IP地址
 * @property string $endpoint 接口端点
 * @property string $limit_type 限制类型
 * @property \Carbon\Carbon $window_start 时间窗口开始
 * @property int $request_count 请求次数
 * @property bool $is_blocked 是否被阻止
 * @property string|null $user_agent 用户代理
 * @property array|null $headers 请求头信息
 * @property \Carbon\Carbon $created_at
 * @property \Carbon\Carbon $updated_at
 */
class OpenApiRateLimit extends ModelCore
{
    // field start
    protected $fillable = [
        'app_id',
        'ip_address',
        'endpoint',
        'limit_type',
        'window_start',
        'request_count',
        'is_blocked',
        'user_agent',
        'headers',
    ];
    // field end

    /**
     * 数据类型转换
     *
     * @var array
     */
    protected $casts = [
        'window_start' => 'datetime',
        'request_count' => 'integer',
        'is_blocked' => 'boolean',
        'headers' => 'array',
    ];

    /**
     * 关联应用模型
     *
     * @return \Illuminate\Database\Eloquent\Relations\BelongsTo
     */
    public function app()
    {
        return $this->belongsTo(OpenApiApp::class, 'app_id', 'app_id');
    }

    /**
     * 获取限制类型的中文名称
     *
     * @return string
     */
    public function getLimitTypeNameAttribute(): string
    {
        return match ($this->limit_type) {
            'requests_per_minute' => '每分钟请求数',
            'requests_per_hour' => '每小时请求数',
            'requests_per_day' => '每天请求数',
            'requests_per_week' => '每周请求数',
            'requests_per_month' => '每月请求数',
            default => $this->limit_type,
        };
    }

    /**
     * 获取状态标签
     *
     * @return string
     */
    public function getStatusLabelAttribute(): string
    {
        return $this->is_blocked ? '已阻止' : '正常';
    }

    /**
     * 获取状态颜色
     *
     * @return string
     */
    public function getStatusColorAttribute(): string
    {
        return $this->is_blocked ? 'danger' : 'success';
    }

    /**
     * 按应用ID查询
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param string $appId
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeByApp($query, string $appId)
    {
        return $query->where('app_id', $appId);
    }

    /**
     * 按IP地址查询
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param string $ip
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeByIp($query, string $ip)
    {
        return $query->where('ip_address', $ip);
    }

    /**
     * 按限制类型查询
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param string $limitType
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeByLimitType($query, string $limitType)
    {
        return $query->where('limit_type', $limitType);
    }

    /**
     * 查询被阻止的记录
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeBlocked($query)
    {
        return $query->where('is_blocked', true);
    }

    /**
     * 按时间范围查询
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param \Carbon\Carbon $start
     * @param \Carbon\Carbon $end
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeInTimeRange($query, $start, $end)
    {
        return $query->whereBetween('window_start', [$start, $end]);
    }

    /**
     * 获取最近的限制记录
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @param int $hours
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeRecent($query, int $hours = 24)
    {
        return $query->where('window_start', '>=', now()->subHours($hours));
    }
}