160 lines
8.9 KiB
C#
160 lines
8.9 KiB
C#
using System.IO.Compression;
|
||
using System.Text;
|
||
using NTP.Application.Refinery.Trips;
|
||
using Xunit;
|
||
|
||
namespace NTP.Tests.Refinery;
|
||
|
||
/// <summary>The refinery Excel reports follow the layout of the legacy report.cfc (font, alignment, header colours, widths, RTL).</summary>
|
||
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("<mergeCell ref=\"A1:C1\"/>", sheet);
|
||
Assert.Contains("<mergeCell ref=\"E1:F1\"/>", 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("<c r=\"A2\" s=\"3\" t=\"inlineStr\"><is><t xml:space=\"preserve\">رقم القاطرة</t>", sheet); // label in the header style
|
||
Assert.Contains("<c r=\"B2\" s=\"4\" t=\"inlineStr\"><is><t xml:space=\"preserve\">123</t>", sheet); // value in the grey style
|
||
Assert.Contains("<c r=\"A4\" s=\"3\" t=\"inlineStr\"><is><t xml:space=\"preserve\">متسلسل</t>", sheet);
|
||
Assert.Contains("<c r=\"A5\" s=\"5\"><v>1</v></c>", 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("<name val=\"Arial Unicode MS\"/>", 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, "<col ").Count);
|
||
Assert.Contains("customWidth=\"1\"", sheet);
|
||
}
|
||
|
||
[Fact]
|
||
public void Cell_text_starting_with_equals_is_a_string_never_a_formula()
|
||
{
|
||
var sheet = Part(Sample(), "xl/worksheets/sheet1.xml");
|
||
Assert.DoesNotContain("<f>", sheet);
|
||
Assert.Contains("<t xml:space=\"preserve\">=1+1</t>", 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<IReadOnlyList<object?>>? 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($"<mergeCell ref=\"{m}\"/>", sheet);
|
||
Assert.Contains("<c r=\"A4\" s=\"2\" t=\"inlineStr\"><is><t xml:space=\"preserve\">صاحب الحساب</t>", sheet); // label on A:B
|
||
Assert.Contains("<c r=\"C4\" s=\"3\" t=\"inlineStr\"><is><t xml:space=\"preserve\">مكتب</t>", sheet); // value on C:M
|
||
Assert.Contains("<c r=\"C9\" s=\"3\"><v>360.743</v></c>", sheet); // total, numeric
|
||
Assert.Contains("<row r=\"11\" ht=\"45\" customHeight=\"1\">", sheet); // captions on row 11
|
||
Assert.Contains("<c r=\"A11\" s=\"4\" t=\"inlineStr\"><is><t xml:space=\"preserve\">متسلسل</t>", sheet);
|
||
Assert.Contains("<c r=\"M11\" s=\"4\" t=\"inlineStr\"><is><t xml:space=\"preserve\">تاريخ الاستلام</t>", sheet);
|
||
Assert.Contains("<c r=\"A12\" s=\"5\"><v>1</v></c>", sheet); // first data row on row 12
|
||
Assert.Equal(13, System.Text.RegularExpressions.Regex.Matches(sheet, "<col ").Count);
|
||
}
|
||
|
||
[Fact]
|
||
public void Transfers_styles_follow_the_legacy_file()
|
||
{
|
||
var styles = Part(Transfers(), "xl/styles.xml");
|
||
Assert.Contains("<name val=\"Arial Unicode MS\"/>", styles);
|
||
Assert.Contains("<b/><sz val=\"21\"/>", 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("<c r=\"A11\" s=\"4\"", sheet);
|
||
Assert.DoesNotContain("<row r=\"12\"", sheet);
|
||
}
|
||
|
||
[Fact]
|
||
public async Task Transfers_report_needs_the_bank_account_number()
|
||
{
|
||
// validation happens before the repository is touched
|
||
var svc = new TripReportService(null!);
|
||
var e = await Assert.ThrowsAsync<NTP.Application.Common.BusinessException>(() => svc.ExchangeAsync(new TripQuery(), default));
|
||
Assert.Equal("يجب ادخال رقم الحساب", e.Message);
|
||
await Assert.ThrowsAsync<NTP.Application.Common.BusinessException>(() => 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()));
|
||
}
|
||
}
|