82 lines
2.8 KiB
C#
82 lines
2.8 KiB
C#
using Microsoft.AspNetCore.Mvc;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using DataServer.Data;
|
|
|
|
namespace GameServices.Admin.Pages.Players;
|
|
|
|
public class IndexModel : AdminPageModel
|
|
{
|
|
private readonly GameDbContext _db;
|
|
|
|
public IndexModel(GameDbContext db)
|
|
{
|
|
_db = db;
|
|
}
|
|
|
|
public List<Account> Accounts { get; set; } = new();
|
|
|
|
[FromQuery(Name = "search")]
|
|
public string? Search { get; set; }
|
|
|
|
[FromQuery(Name = "role")]
|
|
public AccountRole? RoleFilter { get; set; }
|
|
|
|
[FromQuery(Name = "status")]
|
|
public string? StatusFilter { get; set; }
|
|
|
|
[FromQuery(Name = "page")]
|
|
public int CurrentPage { get; set; } = 1;
|
|
|
|
public int PageSize { get; set; } = 25;
|
|
public int TotalCount { get; set; }
|
|
public int TotalPages => (int)Math.Ceiling(TotalCount / (double)PageSize);
|
|
|
|
// Stats
|
|
public int ActiveCount { get; set; }
|
|
public int BannedCount { get; set; }
|
|
public int AdminCount { get; set; }
|
|
|
|
public string? Message { get; set; }
|
|
public bool IsError { get; set; }
|
|
|
|
public string GetPageUrl(int page)
|
|
{
|
|
var parts = new List<string> { $"page={page}" };
|
|
if (!string.IsNullOrEmpty(Search)) parts.Add($"search={Uri.EscapeDataString(Search)}");
|
|
if (RoleFilter.HasValue) parts.Add($"role={RoleFilter}");
|
|
if (!string.IsNullOrEmpty(StatusFilter)) parts.Add($"status={StatusFilter}");
|
|
return "/admin/players?" + string.Join("&", parts);
|
|
}
|
|
|
|
public async Task OnGetAsync()
|
|
{
|
|
if (CurrentPage < 1) CurrentPage = 1;
|
|
|
|
// Stats
|
|
ActiveCount = await _db.Set<Account>().CountAsync(a => !a.IsBanned && (a.BannedUntil == null || a.BannedUntil <= DateTime.UtcNow));
|
|
BannedCount = await _db.Set<Account>().CountAsync(a => a.IsBanned || (a.BannedUntil != null && a.BannedUntil > DateTime.UtcNow));
|
|
AdminCount = await _db.Set<Account>().CountAsync(a => a.Role >= AccountRole.Admin);
|
|
|
|
var query = _db.Set<Account>().AsQueryable();
|
|
|
|
if (!string.IsNullOrWhiteSpace(Search))
|
|
query = query.Where(a => a.Username.Contains(Search) || (a.Email != null && a.Email.Contains(Search)));
|
|
|
|
if (RoleFilter.HasValue)
|
|
query = query.Where(a => a.Role == RoleFilter.Value);
|
|
|
|
if (StatusFilter == "banned")
|
|
query = query.Where(a => a.IsBanned || (a.BannedUntil != null && a.BannedUntil > DateTime.UtcNow));
|
|
else if (StatusFilter == "active")
|
|
query = query.Where(a => !a.IsBanned && (a.BannedUntil == null || a.BannedUntil <= DateTime.UtcNow));
|
|
|
|
TotalCount = await query.CountAsync();
|
|
|
|
Accounts = await query
|
|
.OrderByDescending(a => a.CreatedAt)
|
|
.Skip((CurrentPage - 1) * PageSize)
|
|
.Take(PageSize)
|
|
.ToListAsync();
|
|
}
|
|
}
|