@page "/serilogs/database"
@using Indotalent.Data.Entities
@using Indotalent.Infrastructure.Database
@using Indotalent.Shared.Consts
@using Microsoft.AspNetCore.Components.Web
@using Microsoft.EntityFrameworkCore
@using Microsoft.JSInterop
@using MudBlazor
@using Features.Root.Shared
@using Indotalent.Features.Serilogs.Database
@using Indotalent.Shared.Models
@using ClosedXML.Excel
@using System.IO
@inject SerilogsService SerilogsService
@inject IDialogService DialogService
@inject ISnackbar Snackbar
@inject IJSRuntime JSRuntime

<MudPaper Elevation="0" Square="true" Class="pa-6 mb-3 d-flex align-center justify-space-between" Style="border: 1px solid #E5E7EB; border-radius: 12px;">
    <div>
        <MudText Typo="Typo.h5" Style="font-weight: 700; color: #111827;">Database Logs</MudText>
        <MudText Typo="Typo.body2" Style="color: #9CA3AF;">Monitor application events, errors, and system activities stored in MSSQL Server.</MudText>
    </div>

    <div class="d-flex align-center gap-2">
        <MudIcon Icon="@Icons.Material.Filled.Storage" Size="Size.Small" Color="Color.Default" />
        <MudText Typo="Typo.caption" Style="color: #9CA3AF;">/</MudText>
        <MudText Typo="Typo.caption" Style="color: #9CA3AF;">Serilogs</MudText>
        <MudText Typo="Typo.caption" Style="color: #9CA3AF;">/</MudText>
        <MudText Typo="Typo.caption" Style="font-weight: 700; color: #111827;">Database</MudText>
    </div>
</MudPaper>

<MudPaper Elevation="0" Outlined="true" Style="border-radius: 12px; overflow: hidden; background-color: #ffffff; border: 1px solid #E5E7EB;">

    <div style="padding: 20px 24px; border-bottom: 1px solid #E5E7EB; display: flex; justify-content: space-between; align-items: center; background-color: #ffffff; min-height: 80px;">
        
        <div style="display: flex; align-items: center; gap: 8px;">
            <MudTextField @bind-Value="_searchString"
                          Placeholder="Search..." 
                          Adornment="Adornment.Start"
                          AdornmentIcon="@Icons.Material.Filled.Search"
                          IconSize="Size.Small"
                          Class="mt-0"
                          Variant="Variant.Outlined"
                          Margin="Margin.Dense"
                          Immediate="true"
                          Style="background-color: white; width: 280px; border-radius: 8px;"
                          OnKeyDown="@HandleSearchKeyDown" />
            
            <MudButton Variant="Variant.Filled"
                       Color="Color.Primary"
                       OnClick="OnSearchClick"
                       Size="Size.Small"
                       Style="text-transform: none; font-weight: 500; border-radius: 6px; height: 34px; box-shadow: none;">
                Search
            </MudButton>
        </div>

        <div style="display: flex; gap: 8px; align-items: center;">
            <MudButton Variant="Variant.Outlined"
                       Color="Color.Success"
                       OnClick="ExportToExcel"
                       Size="Size.Small"
                       Disabled="_isExporting"
                       StartIcon="@(_isExporting ? null : Icons.Custom.FileFormats.FileExcel)"
                       Style="background: white; font-weight: 500; border-radius: 6px; text-transform: none; height: 34px; border: 1px solid #D1D5DB;">
                @if (_isExporting)
                {
                    <MudProgressCircular Class="ms-n1" Size="Size.Small" Indeterminate="true" />
                    <MudText Class="ms-2" Typo="Typo.button" Style="text-transform: none !important;">Processing...</MudText>
                }
                else
                {
                    <MudText Typo="Typo.button" Style="text-transform: none !important;">Excel</MudText>
                }
            </MudButton>

            <MudButton Variant="Variant.Outlined"
                       Color="Color.Primary"
                       OnClick="HandleRefresh"
                       Size="Size.Small"
                       StartIcon="@(_isRefreshing ? null : Icons.Material.Filled.Refresh)"
                       Disabled="_isRefreshing"
                       Style="background: white; font-weight: 500; border-radius: 6px; text-transform: none; height: 34px; border: 1px solid #D1D5DB;">
                @if (_isRefreshing)
                {
                    <MudProgressCircular Class="ms-n1" Size="Size.Small" Indeterminate="true" />
                    <MudText Class="ms-2" Typo="Typo.button" Style="text-transform: none !important;">Refreshing...</MudText>
                }
                else
                {
                    <MudText Typo="Typo.button" Style="text-transform: none !important;">Refresh</MudText>
                }
            </MudButton>

            <MudButton Variant="Variant.Filled"
                       Color="Color.Error"
                       StartIcon="@Icons.Material.Filled.DeleteSweep"
                       Size="Size.Small"
                       OnClick="OnDeleteAll"
                       Disabled="_isClearing"
                       Style="text-transform: none; font-weight: 500; border-radius: 6px; height: 34px;">
                @if (_isClearing)
                {
                    <MudProgressCircular Class="ms-n1" Size="Size.Small" Indeterminate="true" />
                }
                else
                {
                    <MudText>Clear All</MudText>
                }
            </MudButton>

            @if (_selectedLog != null)
            {
                <MudButton Variant="Variant.Filled" Color="Color.Info" StartIcon="@Icons.Material.Filled.Visibility" Size="Size.Small" OnClick="OnViewDetail" Style="text-transform: none; font-weight: 500; border-radius: 6px;">View</MudButton>
                <MudButton Variant="Variant.Filled" Color="Color.Error" StartIcon="@Icons.Material.Filled.Delete" Size="Size.Small" OnClick="OnDeleteSingle" Style="text-transform: none; font-weight: 500; border-radius: 6px;">Delete</MudButton>
                <MudIconButton Icon="@Icons.Material.Filled.Close" Size="Size.Small" OnClick="() => _selectedLog = null" />
            }
        </div>
    </div>

    <MudTable Striped="true" Items="@_pagedItems" Hover="true" Elevation="0" CustomHeader="true" Dense="true" T="GetSerilogLogsPagedListResponse" OnRowClick="@HandleRowClick" RowStyle="cursor: pointer;" Class="mud-table-styled mud-width-full" Loading="@_isRefreshing">
        <HeaderContent>
            <MudTh Style="width: 50px; background-color: #F9FAFB; border-bottom: 1px solid #E5E7EB;"></MudTh>
            <MudTh Style="width: 180px; font-weight: 600; color: #1a1a1a; text-transform: uppercase; font-size: 0.75rem; background-color: #F9FAFB; border-bottom: 1px solid #E5E7EB; white-space: nowrap;">Timestamp</MudTh>
            <MudTh Style="width: 100px; font-weight: 600; color: #1a1a1a; text-transform: uppercase; font-size: 0.75rem; background-color: #F9FAFB; border-bottom: 1px solid #E5E7EB; white-space: nowrap;">Level</MudTh>
            <MudTh Style="font-weight: 600; color: #1a1a1a; text-transform: uppercase; font-size: 0.75rem; background-color: #F9FAFB; border-bottom: 1px solid #E5E7EB; white-space: nowrap;">Message</MudTh>
            <MudTh Style="width: 150px; font-weight: 600; color: #1a1a1a; text-transform: uppercase; font-size: 0.75rem; background-color: #F9FAFB; border-bottom: 1px solid #E5E7EB; white-space: nowrap;">Exception</MudTh>
        </HeaderContent>
        <RowTemplate>
            <MudTd Style="padding-top: 0.75rem; padding-bottom: 0.75rem;">
                <MudCheckBox T="bool" Value="@(_selectedLog?.Id == context.Id)" Color="Color.Primary" Dense="true" Size="Size.Small" ReadOnly="true" />
            </MudTd>
            <MudTd Style="padding-top: 0.75rem; padding-bottom: 0.75rem;">
                <MudText Typo="Typo.body2" Style="color: #9CA3AF;">@context.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss")</MudText>
            </MudTd>
            <MudTd Style="padding-top: 0.75rem; padding-bottom: 0.75rem;">
                <MudChip T="string" Color="@GetLevelColor(context.Level)" Size="Size.Small" Variant="Variant.Text" Style="font-weight: 600; border-radius: 4px; text-transform: uppercase; height: 20px; font-size: 0.7rem;">
                    @context.Level
                </MudChip>
            </MudTd>
            <MudTd Style="padding-top: 0.75rem; padding-bottom: 0.75rem;">
                <MudText Typo="Typo.body2" Style="font-weight: 700; color: #111827;">@context.Message</MudText>
            </MudTd>
            <MudTd>
                @if (!string.IsNullOrEmpty(context.Exception))
                {
                    <MudIcon Icon="@Icons.Material.Filled.ErrorOutline" Color="Color.Error" Size="Size.Small" />
                    <MudText Typo="Typo.caption" Color="Color.Error">Has Error</MudText>
                }
                else
                {
                    <MudText Typo="Typo.caption" Style="color: #9CA3AF;">-</MudText>
                }
            </MudTd>
        </RowTemplate>
    </MudTable>

    <div style="display: flex; justify-content: space-between; align-items: center; padding: 12px 24px; background-color: #F9FAFB; border-top: 1px solid #E5E7EB;">
        <div style="display: flex; align-items: center; gap: 12px;">
            <MudText Typo="Typo.caption" Style="font-weight: 500; color: #9CA3AF; font-size: 0.75rem;">Rows per page:</MudText>
            
            <MudSelect T="int" Value="@_top" ValueChanged="OnPageSizeChanged" Dense="true" Margin="Margin.Dense" Style="width: 80px; background-color: white; font-size: 12px; font-weight: 600;" Variant="Variant.Outlined" Class="mt-0 custom-select-dense">
                <MudSelectItem Value="5" />
                <MudSelectItem Value="10" />
                <MudSelectItem Value="50" />
                <MudSelectItem Value="500" />
                <MudSelectItem Value="1000" />
            </MudSelect>

            <MudText Typo="Typo.caption" Style="color: #9CA3AF; font-size: 0.75rem; font-weight: 500; margin-left: 12px;">
                Showing @(_totalCount == 0 ? 0 : _skip + 1)-@Math.Min(_skip + _top, _totalCount) of @_totalCount
            </MudText>
        </div>

        <div style="display: flex; gap: 8px; align-items: center;">
            <MudIconButton Icon="@Icons.Material.Filled.FirstPage" Size="Size.Small" OnClick="@(() => OnPageChanged(1))" Disabled="@(_currentPage == 1)" Style="@(_currentPage == 1 ? "color: #D1D5DB; background: transparent;" : "color: #6B7280; background: white; border: 1px solid #D1D5DB; border-radius: 6px;")" />
            <MudButton OnClick="@(() => OnPageChanged(_currentPage - 1))" Disabled="@(_currentPage == 1)" Variant="Variant.Text" StartIcon="@Icons.Material.Filled.ChevronLeft" Size="Size.Small" Style="@(_currentPage == 1 ? "min-width: 34px; padding: 4px 8px; font-size: 0.75rem; font-weight: 500; color: #D1D5DB; border-radius: 6px; text-transform: none;" : "min-width: 34px; padding: 4px 8px; font-size: 0.75rem; font-weight: 500; color: #6B7280; background: white; border: 1px solid #D1D5DB; border-radius: 6px; text-transform: none;")">Prev</MudButton>
            @{
    var totalPages = _totalPage == 0 ? 1 : _totalPage;
    var maxVisible = 5;
    var startPage = Math.Max(1, _currentPage - maxVisible / 2);
    var endPage = Math.Min(totalPages, startPage + maxVisible - 1);
    if (endPage - startPage < maxVisible - 1) { startPage = Math.Max(1, endPage - maxVisible + 1); }
}
@for (int i = startPage; i <= endPage; i++)
{
    var pageNum = i;
    var isActive = pageNum == _currentPage;
    <MudButton OnClick="@(() => OnPageChanged(pageNum))"
               Variant="Variant.Text" Size="Size.Small"
               Style="@(isActive ? "min-width: 34px; padding: 4px 8px; font-size: 0.75rem; font-weight: 600; background: #3B82F6; color: white; border: 1px solid #3B82F6; border-radius: 6px; text-transform: none;" : "min-width: 34px; padding: 4px 8px; font-size: 0.75rem; font-weight: 500; color: #374151; background: white; border: 1px solid #D1D5DB; border-radius: 6px; text-transform: none;")">@pageNum</MudButton>
}
            <MudButton OnClick="@(() => OnPageChanged(_currentPage + 1))" Disabled="@(_currentPage == _totalPage || _totalPage == 0)" Variant="Variant.Text" EndIcon="@Icons.Material.Filled.ChevronRight" Size="Size.Small" Style="@(_currentPage == _totalPage || _totalPage == 0 ? "min-width: 34px; padding: 4px 8px; font-size: 0.75rem; font-weight: 500; color: #D1D5DB; border-radius: 6px; text-transform: none;" : "min-width: 34px; padding: 4px 8px; font-size: 0.75rem; font-weight: 500; color: #6B7280; background: white; border: 1px solid #D1D5DB; border-radius: 6px; text-transform: none;")">Next</MudButton>
            <MudIconButton Icon="@Icons.Material.Filled.LastPage" Size="Size.Small" OnClick="@(() => OnPageChanged(_totalPage))" Disabled="@(_currentPage == _totalPage || _totalPage == 0)" Style="@(_currentPage == _totalPage || _totalPage == 0 ? "color: #D1D5DB; background: transparent;" : "color: #6B7280; background: white; border: 1px solid #D1D5DB; border-radius: 6px;")" />
        </div>
    </div>
</MudPaper>

<script>
    function downloadFile(fileName, contentType, base64String) {
        const link = document.createElement('a');
        link.download = fileName;
        link.href = `data:${contentType};base64,${base64String}`;
        document.body.appendChild(link);
        link.click();
        document.body.removeChild(link);
    }
</script>

<style>
    .mud-input-outlined-border { border-radius: 0px !important; }
    .custom-select-dense .mud-input-control { margin-top: 0 !important; }
    .custom-select-dense .mud-input-slot { padding-top: 4px !important; padding-bottom: 4px !important; padding-left: 8px !important; font-size: 12px !important; }
</style>
<style>
    .mud-table-styled .mud-table-row:hover { background-color: #F9FAFB !important; }
</style>

@code {
    private GetSerilogLogsPagedListResponse? _selectedLog = null;
    private List<GetSerilogLogsPagedListResponse> _pagedItems = new();
    private int _skip = 0;
    private int _top = 5;
    private int _totalCount = 0;
    private int _totalPage = 0;
    private int _currentPage => (_skip / _top) + 1;
    private string _searchString = "";
    private bool _isRefreshing = false;
    private bool _isClearing = false;
    private bool _isExporting = false;

    protected override async Task OnInitializedAsync() => await LoadData();

    private async Task LoadData()
    {
        _isRefreshing = true;
        StateHasChanged();
        var response = await SerilogsService.GetSerilogLogsODataAsync(_skip, _top, _searchString);
        await Task.Delay(500);
        if (response != null)
        {
            _pagedItems = response.Value ?? new();
            _totalCount = response.Count;
            _totalPage = (int)Math.Ceiling((double)_totalCount / _top);
        }
        else
        {
            _pagedItems = new();
            _totalCount = 0;
            _totalPage = 0;
        }
        _isRefreshing = false;
        StateHasChanged();
    }

    private async Task HandleRefresh()
    {
        _skip = 0;
        _selectedLog = null;
        await LoadData();
    }

    private void HandleRowClick(TableRowClickEventArgs<GetSerilogLogsPagedListResponse> args)
    {
        _selectedLog = (_selectedLog?.Id == args.Item.Id) ? null : args.Item;
    }

    private async Task OnSearchClick()
    {
        _skip = 0;
        _selectedLog = null;
        await LoadData();
    }

    private async Task HandleSearchKeyDown(KeyboardEventArgs e)
    {
        if (e.Key == "Enter") await OnSearchClick();
    }

    private async Task OnPageChanged(int page)
    {
        if (page >= 1 && page <= _totalPage)
        {
            _skip = (page - 1) * _top;
            _selectedLog = null;
            await LoadData();
        }
    }

    private async Task OnPageSizeChanged(int size)
    {
        _top = size;
        _skip = 0;
        _selectedLog = null;
        await LoadData();
    }

    private async Task ExportToExcel()
    {
        _isExporting = true;
        StateHasChanged();
        try
        {
            await Task.Delay(1000);
            var response = await SerilogsService.GetSerilogLogsODataAsync(0, GlobalConsts.ODataMaxTop, _searchString);
            var dataToExport = response?.Value ?? new List<GetSerilogLogsPagedListResponse>();

            using (var workbook = new XLWorkbook())
            {
                var worksheet = workbook.Worksheets.Add("DatabaseLogs");
                var currentRow = 1;
                worksheet.Cell(currentRow, 1).Value = "Timestamp";
                worksheet.Cell(currentRow, 2).Value = "Level";
                worksheet.Cell(currentRow, 3).Value = "Message";
                worksheet.Cell(currentRow, 4).Value = "Exception";

                var headerRange = worksheet.Range(1, 1, 1, 4);
                headerRange.Style.Font.Bold = true;
                headerRange.Style.Fill.BackgroundColor = XLColor.FromHtml("#0D47A1");
                headerRange.Style.Font.FontColor = XLColor.White;

                foreach (var item in dataToExport)
                {
                    currentRow++;
                    worksheet.Cell(currentRow, 1).Value = item.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss");
                    worksheet.Cell(currentRow, 2).Value = item.Level;
                    worksheet.Cell(currentRow, 3).Value = item.Message;
                    worksheet.Cell(currentRow, 4).Value = item.Exception;
                }

                worksheet.Columns().AdjustToContents();
                using (var stream = new MemoryStream())
                {
                    workbook.SaveAs(stream);
                    var content = Convert.ToBase64String(stream.ToArray());
                    await JSRuntime.InvokeVoidAsync("downloadFile", "Database_Logs.xlsx", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", content);
                    Snackbar.Add("Exported successfully", Severity.Success);
                }
            }
        }
        catch (Exception ex)
        {
            Snackbar.Add($"Export failed: {ex.Message}", Severity.Error);
        }
        finally
        {
            _isExporting = false;
            StateHasChanged();
        }
    }

    private async Task OnDeleteAll()
    {
        var parameters = new DialogParameters<_DeleteConfirmation> { { x => x.ContentText, "ALL database logs" } };
        var dialog = await DialogService.ShowAsync<_DeleteConfirmation>("Confirmation", parameters);
        var result = await dialog.Result;
        if (result != null && !result.Canceled)
        {
            _isClearing = true;
            StateHasChanged();
            if (await SerilogsService.DeleteSerilogLogsAllAsync())
            {
                Snackbar.Add("All logs cleared.", Severity.Success);
                _selectedLog = null; _skip = 0; await LoadData();
            }
            _isClearing = false;
            StateHasChanged();
        }
    }

    private async Task OnDeleteSingle()
    {
        if (_selectedLog == null) return;
        var parameters = new DialogParameters<_DeleteConfirmation> { { x => x.ContentText, $"Log ID {_selectedLog.Id}" } };
        var dialog = await DialogService.ShowAsync<_DeleteConfirmation>("Confirmation", parameters);
        var result = await dialog.Result;
        if (result != null && !result.Canceled)
        {
            if (await SerilogsService.DeleteSerilogLogsByIdAsync(_selectedLog.Id))
            {
                Snackbar.Add("Log deleted.", Severity.Success);
                _selectedLog = null; await LoadData();
            }
        }
    }

    private async Task OnViewDetail()
    {
        if (_selectedLog == null) return;
        var detail = await SerilogsService.GetSerilogLogsByIdAsync(_selectedLog.Id);
        if (detail != null)
        {
            var parameters = new DialogParameters<_SerilogDetailDialog> { { x => x.Log, detail } };
            await DialogService.ShowAsync<_SerilogDetailDialog>("Log Details", parameters, new DialogOptions { MaxWidth = MaxWidth.Medium, FullWidth = true });
        }
    }

    private Color GetLevelColor(string? level) => level switch
    {
        "Information" or "Info" => Color.Info,
        "Warning" => Color.Warning,
        "Error" or "Fatal" => Color.Error,
        _ => Color.Default
    };
}