NTP_V2/tests/NTP.Tests/ReportsSliceTests.cs

391 lines
15 KiB
C#

using NTP.Application.Grains.Reports;
namespace NTP.Tests;
public class TripsReportMathTests
{
private static readonly DateOnly D = new(2024, 1, 1);
[Fact]
public void Frequency_computes_totals_and_groups()
{
// 10 trucks with 1 trip, 5 with 2, 2 with 15
var t = new long[15]; t[0] = 10; t[1] = 5; t[14] = 2;
var r = TripsReportMath.Frequency(D, D, t);
Assert.Equal(17, r.TotalTrucks);
Assert.Equal(10 + 10 + 30, r.TotalTrips);
Assert.Equal(30, r.Trips[14]);
Assert.Equal(60m, r.TripsPct[14]);
Assert.Equal(5, r.Groups.Count);
Assert.Equal(15, r.Groups[0].Trucks); // 1-3
Assert.Equal(20, r.Groups[0].Trips);
Assert.Equal(2, r.Groups[4].Trucks); // 13-15
Assert.Equal(30, r.Groups[4].Trips); // legacy used multipliers 1..3 here; the real one is applied
}
[Fact]
public void Frequency_with_no_data_does_not_divide_by_zero()
{
var r = TripsReportMath.Frequency(D, D, new long[15]);
Assert.Equal(0, r.TotalTrips);
Assert.All(r.TripsPct, p => Assert.Equal(0m, p));
Assert.All(r.Groups, g => Assert.Equal(0m, g.TrucksPct));
}
[Fact]
public void Frequency_tolerates_short_input()
{
var r = TripsReportMath.Frequency(D, D, [3, 1]);
Assert.Equal(15, r.Trucks.Count);
Assert.Equal(5, r.TotalTrips);
}
private static TripsPerCompanyRow Row(string code, decimal trucks, decimal trips, decimal tripPct, decimal share = 10) =>
new() { Scac = "C" + code, CompanyCode = code, NumOfTruk = trucks, AllTripNum = trips, AvrgTrips = tripPct, CompanyShare = share, TotalShare = 1.5m };
[Fact]
public void Quota_splits_companies_and_badiya()
{
var q = TripsReportMath.Quota(D, D, [Row("10", 30, 100, 40), Row("11", 20, 50, 20), Row("327", 50, 150, 40)]);
Assert.Equal(50, q.Companies.Trucks);
Assert.Equal(50m, q.Companies.TruckPct);
Assert.Equal(150, q.Companies.Trips);
Assert.Equal(60m, q.Companies.TripPct);
Assert.Equal(50, q.Individuals.Trucks);
Assert.Equal(40m, q.Individuals.TripPct);
}
[Fact]
public void Quota_without_rows_is_zero()
{
var q = TripsReportMath.Quota(D, D, []);
Assert.Equal(0m, q.Companies.TruckPct);
Assert.Equal(0m, q.Individuals.TruckPct);
}
[Fact]
public void NumOfTrips_totals_exclude_badiya_then_add_it_to_the_grand_total()
{
var r = TripsReportMath.NumOfTrips(D, D, [Row("10", 3, 7, 70), Row("327", 1, 3, 30)]);
Assert.Single(r.Companies);
Assert.Equal(7, r.CompaniesTotal.Trips); // allTripNum summed (legacy summed numOfTruk)
Assert.Equal(10, r.GrandTrips);
Assert.Equal(4, r.GrandTrucks);
Assert.Equal(100m, r.GrandTripsPct);
Assert.NotNull(r.Individuals);
}
[Fact]
public void Details_groups_by_company()
{
var rows = new List<DetailsRow>
{
new() { Scac = "A", Tn = "1", Tt = 2 }, new() { Scac = "A", Tn = "2", Tt = 3 }, new() { Scac = "B", Tn = "3", Tt = 1 }
};
var r = TripsReportMath.Details(D, D, rows);
Assert.Equal(2, r.Groups.Count);
Assert.Equal(5, r.Groups[0].TotalTrips);
Assert.Equal(2, r.Groups[0].TruckCount);
}
}
public class WeighbridgeEventMathTests
{
private static WeighbridgeEventRaw Ev(long pid, string? type, string? w, string? date = "01/02/2024") => new()
{
Pid = pid, Pn = "P" + pid, Tn = "T", Loc = "Dest", EventType = type, Weight = w, EventDate = date, OriginAddressId = "Silo", Scac = "Co", CargoType = "قمح سائب"
};
[Fact]
public void Net_falls_back_to_gross_minus_tare_and_loss_is_difference()
{
var rows = WeighbridgeEventMath.Pivot([
Ev(1, "LTW", "10000", "01/02/2024"), Ev(1, "LGW", "40000"), Ev(1, "DTW", "10000", "02/02/2024"), Ev(1, "DGW", "39500")]);
var r = Assert.Single(rows);
Assert.Equal(30000, r.Lnw);
Assert.Equal(29500, r.Dnw);
Assert.Equal(500, r.NetLoss);
Assert.Equal("01/02/2024", r.LoadDate);
Assert.Equal("02/02/2024", r.DischargeDate);
Assert.Equal(@"العقبة \ Silo", r.Origin);
}
[Fact]
public void Explicit_net_events_win_and_are_shown_absolute()
{
var r = Assert.Single(WeighbridgeEventMath.Pivot([Ev(1, "LNW", "-30000"), Ev(1, "DNW", "29000")]));
Assert.Equal(30000, r.Lnw);
Assert.Equal(-59000, r.NetLoss); // legacy: signed LNW - DNW, shown unabsoluted
}
[Fact]
public void Permit_without_weight_events_still_gets_a_row_with_dashes()
{
var r = Assert.Single(WeighbridgeEventMath.Pivot([Ev(1, null, null)]));
Assert.Equal("-", r.LoadDate);
Assert.Equal(0, r.Ltw);
}
[Fact]
public void Serial_counts_permits_not_events()
{
var rows = WeighbridgeEventMath.Pivot([Ev(1, "LTW", "1"), Ev(1, "LGW", "2"), Ev(2, "LTW", "1")]);
Assert.Equal([1, 2], rows.Select(x => x.Serial));
}
}
public class PhoneApprovalTests
{
private static string[] Row(string id, string conf, string callNo = "", string status = "")
{
var r = new string[20];
Array.Fill(r, "");
r[16] = id; r[17] = conf; r[18] = callNo; r[19] = status;
return r;
}
[Fact]
public void Header_and_non_numeric_ids_are_skipped() =>
Assert.Equal(PhoneDecisionKind.Skip, PhoneApprovalLogic.Decide(Row("ID", "Yes")).Kind);
[Fact]
public void Yes_is_accept()
{
var d = PhoneApprovalLogic.Decide(Row("123", "Yes", "", "Call Answered."));
Assert.Equal(PhoneDecisionKind.Accept, d.Kind);
Assert.Equal(123, d.PermitId);
}
[Theory]
[InlineData("0123456789one", 1)]
[InlineData("0123456789two", 2)]
[InlineData("0123456789thr", 3)]
[InlineData("0123456789fou", 4)]
[InlineData("0123456789fiv", 5)]
[InlineData("0123456789xyz", 0)]
[InlineData("short", 0)]
public void No_rejects_with_delay_from_the_call_number(string callNo, int days)
{
var d = PhoneApprovalLogic.Decide(Row("5", "No", callNo));
Assert.Equal(PhoneDecisionKind.Reject, d.Kind);
Assert.Equal(days, d.DelayDays);
Assert.Contains($"تم التأجيل {days} يوم", d.Remarks);
}
[Fact]
public void Conf_containing_space_No_is_a_reject() =>
Assert.Equal(PhoneDecisionKind.Reject, PhoneApprovalLogic.Decide(Row("5", "Press No", "0123456789one")).Kind);
[Fact]
public void Empty_confirmation_is_no_decision_with_one_day_delay()
{
var d = PhoneApprovalLogic.Decide(Row("5", "", "", "Call Made. No Answer."));
Assert.Equal(PhoneDecisionKind.Reject, d.Kind);
Assert.Equal(1, d.DelayDays);
Assert.StartsWith(PhoneApprovalLogic.NoAnswerRemark, d.Remarks);
Assert.EndsWith(PhoneApprovalLogic.NoDecisionRemark, d.Remarks);
}
[Fact]
public void Status_text_selects_the_remark_case_insensitively()
{
Assert.StartsWith(PhoneApprovalLogic.AnsweredRemark, PhoneApprovalLogic.Decide(Row("5", "", "", "call answered.")).Remarks);
Assert.StartsWith(PhoneApprovalLogic.NoAnswerRemark, PhoneApprovalLogic.Decide(Row("5", "", "", "Call Made. timeout")).Remarks);
}
[Fact]
public void Csv_reader_handles_quotes_commas_and_crlf()
{
var rows = CsvReader.Parse("a,\"b,c\",d\r\n\"x\"\"y\",,z\r\n");
Assert.Equal(2, rows.Count);
Assert.Equal(["a", "b,c", "d"], rows[0]);
Assert.Equal(["x\"y", "", "z"], rows[1]);
}
[Fact]
public void Csv_reader_keeps_a_last_line_without_newline()
{
var rows = CsvReader.Parse("1,2\n3,4");
Assert.Equal(2, rows.Count);
Assert.Equal(["3", "4"], rows[1]);
}
}
public class FileParserTests
{
[Fact]
public void Irbid_first_record_has_9_lines_then_10()
{
var lines = new List<string> { "2" };
lines.AddRange(["1", "12 345", "20000", "10:30:00", "2024-01-05 00:00:00.0", "0", "x", "y", "z"]); // 9 lines
lines.AddRange(["2", "99999", "100", "11:00:00", "2024-01-06 00:00:00.0", "5", "a", "b", "c", "last"]); // 10 lines
var r = IrbidFileParser.Parse(lines, @"D:\silos\ir\IR2024.txt");
Assert.Equal(2, r.Count);
Assert.Equal("6012345", r[0].F1); // blanks removed, "60" prefix
Assert.Null(r[0].F9);
Assert.Equal("last", r[1].F9);
Assert.Equal([1L, 2L], r.Select(x => x.Wid));
Assert.Equal("IR", r[0].FileName); // digits stripped from the file name
}
[Fact]
public void Irbid_event_date_combines_date_and_time()
{
var rec = new IrbidRecord { F3 = "10:30:05", F4 = "2024-01-05 00:00:00.0" };
Assert.Equal("20240105103005", IrbidFileParser.EventDate(rec));
Assert.Equal("", IrbidFileParser.EventDate(new IrbidRecord { F3 = "", F4 = "2024-01-05" }));
}
[Fact]
public void Rsifeh_reads_id_and_data_line_pairs()
{
var lines = new[]
{
"1", "777",
"\"12/345*\", 5 ,\"ABC\",plate,#2024-01-05 10:00:00#,#2024-01-05 11:00:00#,#2024-01-05#,#2024-01-05#,\"n1\",\"n2\",\"n3\",\"n4\",13"
};
var r = Assert.Single(RsifehFileParser.Parse(lines, @"C:\files\W31122013.rdg"));
Assert.Equal("777", r.Id);
Assert.Equal("6012345", r.F1);
Assert.Equal("5", r.F2);
Assert.Equal(new DateTime(2024, 1, 5, 10, 0, 0), r.F5);
Assert.Equal(new DateTime(2024, 1, 5), r.F7);
Assert.Equal("n4", r.F12);
Assert.Equal("31122013", r.FileName);
}
[Fact]
public void Rsifeh_stops_after_the_announced_record_count()
{
var data = "\"1\",2,\"x\",d,#2024-01-05#,#2024-01-05#,#2024-01-05#,#2024-01-05#,\"a\",\"b\",\"c\",\"d\",1";
var r = RsifehFileParser.Parse(["1", "1", data, "2", data], "f.rdg");
Assert.Single(r);
}
}
public class WsRulesTests
{
[Theory]
[InlineData("EN", "ACCPT", "LTW", "ACCPT", null)]
[InlineData("EN", "RESD", "LTW", "RESD", null)]
[InlineData("EX", "ACTRL", "LGW", "ACTRL", "ACTRL")]
public void Origin_plans(string trx, string status, string evt, string current, string? next)
{
var p = WbRules.Plan(WbRules.LocationType.Origin, trx, status, out _);
Assert.NotNull(p);
Assert.Equal(evt, p!.EventType);
Assert.Equal(next, p.NewPermitStatus);
Assert.True(p.UseProvidedEventDate);
_ = current;
}
[Fact]
public void Origin_entry_rejects_wrong_status() =>
Assert.Null(WbRules.Plan(WbRules.LocationType.Origin, "EN", "ACTRL", out _));
[Theory]
[InlineData("ACCPT")] [InlineData("RESD")] [InlineData("ACTRL")] [InlineData("CLRPR")]
public void Destination_entry_moves_to_CLRPR(string status)
{
var p = WbRules.Plan(WbRules.LocationType.Destination, "EN", status, out _);
Assert.Equal("DGW", p!.EventType);
Assert.Equal("CLRPR", p.NewPermitStatus);
Assert.False(p.UseProvidedEventDate);
}
[Fact]
public void Destination_exit_needs_CLRPR_and_closes()
{
Assert.Null(WbRules.Plan(WbRules.LocationType.Destination, "EX", "ACTRL", out _));
var p = WbRules.Plan(WbRules.LocationType.Destination, "EX", "CLRPR", out _);
Assert.Equal("DTW", p!.EventType);
Assert.Equal("CLOSE", p.NewPermitStatus);
Assert.Equal("printPage2", p.Action);
}
[Fact]
public void Unknown_trx_type_is_the_generic_error()
{
Assert.Null(WbRules.Plan(WbRules.LocationType.Origin, "ZZ", "ACCPT", out var generic));
Assert.True(generic);
}
[Fact]
public void Location_is_matched_against_origin_then_destination()
{
Assert.Equal(WbRules.LocationType.Origin, WbRules.Locate(10, 20, 10));
Assert.Equal(WbRules.LocationType.Destination, WbRules.Locate(10, 20, 20));
Assert.Equal(WbRules.LocationType.None, WbRules.Locate(10, 20, 30));
Assert.Equal(WbRules.LocationType.None, WbRules.Locate(null, null, 30));
}
[Theory]
[InlineData("20240105 103005", true)]
[InlineData("20240105103005", true)]
[InlineData("2024-01-05", false)]
[InlineData("", false)]
public void Event_date_formats(string s, bool ok)
{
Assert.Equal(ok, WbRules.TryParseEventDate(s, out var d));
if (ok) Assert.Equal(new DateTime(2024, 1, 5, 10, 30, 5), d);
}
[Theory]
[InlineData("BULK", 5, "10", 3L, "1" + "03" + "000005")]
[InlineData("BULK", 5, "327", 3L, "30" + "03" + "000005")]
[InlineData("PCKD", 12, "10", 3L, "1" + "44" + "000012")]
[InlineData("PCKD", 12, "327", 3L, "3" + "44" + "0000012")]
[InlineData("BULK", 5, "10", 123L, "1" + "123" + "000005")]
public void Permit_number_format(string tt, long seq, string company, long tenders, string expected) =>
Assert.Equal(expected, PermitNumber.Generate(tt, seq, company, tenders));
[Fact]
public void Permit_number_unsupported_type_is_null() => Assert.Null(PermitNumber.Generate("OTHER", 1, "10", 1));
}
public class OrderLabelsAndMotTests
{
[Fact]
public void Labels_match_legacy_getOrderDetails()
{
Assert.Equal("سائب", GrainsOrderLabels.CargoTypeLabel(38));
Assert.Equal("مشول", GrainsOrderLabels.CargoTypeLabel(41));
Assert.Equal("صوامع", GrainsOrderLabels.LocationLabel(205));
Assert.Equal("999", GrainsOrderLabels.LocationLabel(999));
Assert.Equal("سائب قلاب", GrainsOrderLabels.OrderTypeLabel("BULK_GALLAB"));
}
[Fact]
public void Mot_pivot_sums_months_and_averages_trucks()
{
var rows = new List<MotMultiTripsRow>
{
new() { Mm = "2016-01", RegType = "COMP", Trips = 1, TnFreq = 10, TripFreq = 10 },
new() { Mm = "2016-01", RegType = "COMP", Trips = 2, TnFreq = 4, TripFreq = 8 },
new() { Mm = "2016-02", RegType = "COMP", Trips = 1, TnFreq = 20, TripFreq = 20 },
new() { Mm = "2016-01", RegType = "OWN", Trips = 1, TnFreq = 6, TripFreq = 6 },
};
var r = MotMultiTripsBuilder.Build(rows);
Assert.Equal(2, r.MonthCount);
Assert.Equal(2, r.Companies.Months.Count);
Assert.Equal(14, r.Companies.Months[0].TrucksTotal);
Assert.Equal(18, r.Companies.Months[0].TripsTotal);
Assert.Equal(15, r.Companies.AvgTrucksPerTrips[0]); // (10+20)/2 months
Assert.Equal(17, r.Companies.AvgTrucksTotal); // (14+20)/2
Assert.Equal(38, r.Companies.TripsSum);
Assert.Equal(3, r.Individuals.AvgTrucksTotal); // 6 / 2 months
// per-bucket average over rows present: COMP trips=1 -> avg(10,20)=15, OWN -> 6 => 71%/29%
Assert.Equal(15, r.ChartCompanies[0]);
Assert.Equal(6, r.ChartIndividuals[0]);
Assert.Equal(71.43m, r.ChartCompaniesPct[0]);
}
[Fact]
public void Mot_pivot_with_no_rows_is_empty_not_a_crash()
{
var r = MotMultiTripsBuilder.Build([]);
Assert.Empty(r.Companies.Months);
Assert.Equal(0, r.Companies.AvgTrucksTotal);
}
}