using System.IO.Compression;
using System.Text;
using NTP.Application.Refinery.Trips;
using Xunit;
namespace NTP.Tests.Refinery;
/// The refinery Excel reports follow the layout of the legacy report.cfc (font, alignment, header colours, widths, RTL).
public class LegacyReportWorkbookTests
{
private static string Part(byte[] xlsx, string name)
{
using var zip = new ZipArchive(new MemoryStream(xlsx), ZipArchiveMode.Read);
using var s = zip.GetEntry(name)!.Open();
using var r = new StreamReader(s, Encoding.UTF8);
return r.ReadToEnd();
}
private static byte[] Sample(IReadOnlyList<(string, string)>? filters = null) =>
LegacyReportWorkbook.ToXlsx(new LegacyReport(
"شركة نافذ للخدمات اللوجستية", "أرصدة الديزل", filters ?? [("رقم القاطرة", "123")],
["متسلسل", "رقم القاطرة", "رقم بطاقة جوبترول", "القيمة التراكمية الحالية"], [100, 150, 150, 150],
[[1, "123", "=1+1", 55.5m]]));
[Fact]
public void Sheet_is_right_to_left_with_the_legacy_title_row_and_merges()
{
var sheet = Part(Sample(), "xl/worksheets/sheet1.xml");
Assert.Contains("rightToLeft=\"1\"", sheet);
Assert.Contains("", sheet);
Assert.Contains("", sheet);
Assert.Contains("شركة نافذ للخدمات اللوجستية", sheet);
Assert.Contains("أرصدة الديزل", sheet);
}
[Fact]
public void Filters_are_label_value_pairs_on_row_two_and_the_header_is_on_row_four()
{
var sheet = Part(Sample(), "xl/worksheets/sheet1.xml");
Assert.Contains("رقم القاطرة", sheet); // label in the header style
Assert.Contains("123", sheet); // value in the grey style
Assert.Contains("متسلسل", sheet);
Assert.Contains("1", sheet); // counter, data style
}
[Fact]
public void Styles_use_the_legacy_font_centre_alignment_and_navy_header()
{
var styles = Part(Sample(), "xl/styles.xml");
Assert.Contains("", styles);
Assert.DoesNotContain("Calibri", styles);
Assert.Contains("rgb=\"FF003366\"", styles); // navy header fill
Assert.Contains("rgb=\"FFC0C0C0\"", styles); // grey filter values
Assert.Contains("horizontal=\"center\"", styles);
Assert.Contains("horizontal=\"right\"", styles); // company name
Assert.Contains("wrapText=\"1\"", styles);
}
[Fact]
public void Column_widths_follow_the_legacy_point_widths()
{
Assert.InRange(LegacyReportWorkbook.Chars(100), 18, 19);
Assert.True(LegacyReportWorkbook.Chars(200) > LegacyReportWorkbook.Chars(150));
Assert.True(LegacyReportWorkbook.Chars(150) > LegacyReportWorkbook.Chars(100));
var sheet = Part(Sample(), "xl/worksheets/sheet1.xml");
Assert.Equal(4, System.Text.RegularExpressions.Regex.Matches(sheet, "", sheet);
Assert.Contains("=1+1", sheet);
}
[Fact]
public void Sheet_name_has_no_forbidden_characters_and_fits_31_characters()
{
Assert.Equal("Report", LegacyReportWorkbook.SheetName("[:*?/\\]"));
Assert.Equal(31, LegacyReportWorkbook.SheetName(new string('ا', 50)).Length);
Assert.Equal("أرصدة الديزل", LegacyReportWorkbook.SheetName("أرصدة الديزل"));
}
private static readonly string[] TransferHeaders =
[
"متسلسل", "رقم الارسالية", "تاريخ الارسالية", "رقم الحمولة", "رقم النموذج", "تاريخ النموذج", "الوزن الصافي للتحميل (كغ)",
"الوزن الصافي للتفريغ(كغ)", "رقم القاطرة", "رقم المقطورة", "صافي قيمة اجور النقل", "الحالة", "تاريخ الاستلام"
];
private static byte[] Transfers(IReadOnlyList>? rows = null) =>
LegacyReportWorkbook.ToTransfersXlsx(new TransfersReport(
"شركة نافذ للخدمات اللوجستية", "قائمة ارقام نماذج التفريغ المعدة لصرف أجور النقل",
[("صاحب الحساب", "مكتب"), ("الاسم بالانجليزي", "OFFICE"), ("اسم البنك", "بنك"), ("رقم الحساب", "0055"), ("IBAN", "JO83"), ("صافي قيمة اجور النقل", 360.743m)],
TransferHeaders, [9.14, 10.86, 16.71, 12.29, 12.71, 24.86, 12.29, 13.57, 13.71, 11.43, 15.43, 15.43, 24.29],
rows ?? [[1, "318912", "03/07/2021", 23300L, "26680", "04/07/2021", 35600m, 35600m, "6059378", "7117953", 360.743m, "جاهز للدفع", "08/07/2021 13:37"]]));
[Fact]
public void Transfers_sheet_has_the_legacy_cell_layout()
{
var sheet = Part(Transfers(), "xl/worksheets/sheet1.xml");
Assert.Contains("rightToLeft=\"1\"", sheet);
foreach (var m in new[] { "A1:M1", "A2:M2", "A3:M3", "A4:B4", "C4:M4", "A9:B9", "C9:M9", "A10:M10" })
Assert.Contains($"", sheet);
Assert.Contains("صاحب الحساب", sheet); // label on A:B
Assert.Contains("مكتب", sheet); // value on C:M
Assert.Contains("360.743", sheet); // total, numeric
Assert.Contains("", sheet); // captions on row 11
Assert.Contains("متسلسل", sheet);
Assert.Contains("تاريخ الاستلام", sheet);
Assert.Contains("1", sheet); // first data row on row 12
Assert.Equal(13, System.Text.RegularExpressions.Regex.Matches(sheet, "", styles);
Assert.Contains("", styles); // banner: Arial bold 21
Assert.Contains("rgb=\"FF003366\"", styles); // navy labels and captions
Assert.Contains("horizontal=\"right\"", styles); // account values
Assert.Contains("horizontal=\"center\"", styles);
Assert.DoesNotContain("Calibri", styles);
}
[Fact]
public void Transfers_with_no_rows_still_has_the_block_and_the_captions()
{
var sheet = Part(Transfers([]), "xl/worksheets/sheet1.xml");
Assert.Contains("(() => svc.ExchangeAsync(new TripQuery(), default));
Assert.Equal("يجب ادخال رقم الحساب", e.Message);
await Assert.ThrowsAsync(() => svc.ExchangeAsync(new TripQuery(BankAccount: " "), default));
}
[Fact]
public void Trip_filters_show_status_captions_and_dates_oldest_first()
{
var f = TripReportService.Filters(new TripQuery(
Tn: " 55 ", StatusCode: "DISCHARGED,'RESD'", LoadingDateFrom: new DateTime(2026, 3, 1), LoadingDateTo: new DateTime(2026, 3, 31),
PaymentedDateFrom: new DateTime(2026, 1, 5)));
Assert.Equal(("رقم القاطرة", "55"), f[0]);
Assert.Equal("الحالة", f[1].Label);
Assert.Contains("تم التفريغ", f[1].Value);
Assert.Equal(new[] { "من تاريخ الدفع", "من تاريخ التحميل", "الى تاريخ التحميل" }, f.Skip(2).Select(x => x.Label).ToArray());
Assert.Equal("05/01/2026", f[2].Value);
Assert.Empty(TripReportService.Filters(new TripQuery()));
}
}