Files

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();
}
}