Table 1051 Sorting Table

Base Application, Microsoft.Sales.Reminder

src/Layers/W1/BaseApp/Sales/Reminder/SortingTable.Table.al214 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.Reminder;using Microsoft.Finance.Currency;using System.Visualization;/// <summary>/// Provides a temporary sorting buffer for charting and visualization of additional fee calculations./// </summary>table 1051 "Sorting Table"{    Caption = 'Sorting Table';    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Stores an integer value used as a sequence number for ordering entries.        /// </summary>        field(1; "Integer"; Integer)        {            Caption = 'Integer';        }        /// <summary>        /// Stores a decimal value used for sorting and calculations in fee charts.        /// </summary>        field(2; Decimal; Decimal)        {            AutoFormatType = 0;            Caption = 'Decimal';        }        /// <summary>        /// Stores a code value for categorization purposes.        /// </summary>        field(3; "Code"; Code[20])        {            Caption = 'Code';        }    }    keys    {        key(Key1; "Integer")        {            Clustered = true;        }        key(Key2; Decimal)        {        }        key(Key3; "Code")        {        }    }    fieldgroups    {    }    var        TempSortingTable: Record "Sorting Table" temporary;        CurrMaxRemAmount: Decimal;        NextEntryNo: Integer;    /// <summary>    /// Updates the business chart buffer with additional fee visualization data for a reminder level.    /// </summary>    /// <param name="BusChartBuf">The business chart buffer to populate with chart data.</param>    /// <param name="ReminderLevel">The reminder level to calculate fees for.</param>    /// <param name="ChargePerLine">True if showing charge per line fees, false for fixed fees.</param>    /// <param name="Currency">The currency code for fee calculations.</param>    /// <param name="RemAmountTxt">The label text for the remaining amount axis.</param>    /// <param name="MaxRemAmount">The maximum remaining amount to display on the chart.</param>    [Scope('OnPrem')]    procedure UpdateData(var BusChartBuf: Record "Business Chart Buffer"; ReminderLevel: Record "Reminder Level"; ChargePerLine: Boolean; Currency: Code[10]; RemAmountTxt: Text; MaxRemAmount: Decimal)    var        AddFeeSetup: Record "Additional Fee Setup";        CurrencyExchangeRate: Record "Currency Exchange Rate";        RemAmount: Decimal;        XIndex: Integer;        NextRangeStart: Decimal;        CurrencyFactor: Decimal;        MeasureA: Text;        MeasureB: Text;        MeasureC: Text;        FixedFee: Decimal;    begin        CurrencyFactor := 1;        BusChartBuf.Initialize();        MeasureA := Format(ReminderLevel."Add. Fee Calculation Type"::Fixed);        MeasureB := Format(ReminderLevel."Add. Fee Calculation Type"::"Single Dynamic");        MeasureC := Format(ReminderLevel."Add. Fee Calculation Type"::"Accumulated Dynamic");        BusChartBuf.AddDecimalMeasure(MeasureA, 1, BusChartBuf."Chart Type"::Line);        BusChartBuf.AddDecimalMeasure(MeasureB, 1, BusChartBuf."Chart Type"::Line);        BusChartBuf.AddDecimalMeasure(MeasureC, 1, BusChartBuf."Chart Type"::Line);        BusChartBuf.SetXAxis(RemAmountTxt, BusChartBuf."Data Type"::Decimal);        AddFeeSetup.SetRange("Reminder Terms Code", ReminderLevel."Reminder Terms Code");        AddFeeSetup.SetRange("Reminder Level No.", ReminderLevel."No.");        AddFeeSetup.SetRange("Charge Per Line", ChargePerLine);        AddFeeSetup.SetRange("Currency Code", Currency);        if (not AddFeeSetup.FindSet()) and (Currency <> '') then begin            AddFeeSetup.SetRange("Currency Code", '');            CurrencyFactor := CurrencyExchangeRate.ExchangeAmtLCYToFCY(                Today, Currency,                1,                CurrencyExchangeRate.ExchangeRate(Today, Currency));        end;        CurrMaxRemAmount := MaxRemAmount / CurrencyFactor;        RemAmount := 0;        TempSortingTable.DeleteAll();        NextEntryNo := 1;        SetValuesAt(TempSortingTable, 0);        if AddFeeSetup.FindSet() then begin            repeat                // Add points for maximum values and just before the range change                if AddFeeSetup."Threshold Remaining Amount" > 0 then begin                    RemAmount := AddFeeSetup."Threshold Remaining Amount" - 1;                    SetValuesAt(TempSortingTable, RemAmount);                end;                // Set at start value for range                RemAmount := AddFeeSetup."Threshold Remaining Amount";                SetValuesAt(TempSortingTable, RemAmount);                if AddFeeSetup."Additional Fee %" > 0 then begin                    // Add points for miniumum and offset                    if (AddFeeSetup."Min. Additional Fee Amount" > 0) and                       (AddFeeSetup."Additional Fee Amount" < AddFeeSetup."Min. Additional Fee Amount")                    then begin                        NextRangeStart := 0;                        if AddFeeSetup.Next() <> 0 then begin                            NextRangeStart := AddFeeSetup."Threshold Remaining Amount";                            AddFeeSetup.Next(-1);                        end;                        RemAmount :=                          AddFeeSetup."Threshold Remaining Amount" +                          (AddFeeSetup."Min. Additional Fee Amount" - AddFeeSetup."Additional Fee Amount") /                          (AddFeeSetup."Additional Fee %" / 100);                        if (NextRangeStart > RemAmount) or (NextRangeStart = 0) then                            SetValuesAt(TempSortingTable, RemAmount);                        RemAmount :=                          AddFeeSetup."Threshold Remaining Amount" + AddFeeSetup."Min. Additional Fee Amount" /                          (AddFeeSetup."Additional Fee %" / 100);                        if (NextRangeStart > RemAmount) or (NextRangeStart = 0) then                            SetValuesAt(TempSortingTable, RemAmount);                    end;                    // Find maximum threshold                    if AddFeeSetup."Max. Additional Fee Amount" > 0 then begin                        SetValuesAt(TempSortingTable, AddFeeSetup."Max. Additional Fee Amount" / (AddFeeSetup."Additional Fee %" / 100));                        SetValuesAt(                          TempSortingTable, AddFeeSetup."Threshold Remaining Amount" +                          (AddFeeSetup."Max. Additional Fee Amount" - AddFeeSetup."Additional Fee Amount") /                          (AddFeeSetup."Additional Fee %" / 100));                        SetValuesAt(                          TempSortingTable, AddFeeSetup."Threshold Remaining Amount" +                          (AddFeeSetup."Max. Additional Fee Amount" - AddFeeSetup."Min. Additional Fee Amount") /                          (AddFeeSetup."Additional Fee %" / 100));                        SetValuesAt(                          TempSortingTable, AddFeeSetup."Threshold Remaining Amount" + AddFeeSetup."Max. Additional Fee Amount" /                          (AddFeeSetup."Additional Fee %" / 100));                    end;                end;            until AddFeeSetup.Next() = 0;            // Add final entries            RemAmount := RemAmount * 1.5;            if RemAmount = 0 then                RemAmount := 1000;            SetValuesAt(TempSortingTable, RemAmount);            if CurrMaxRemAmount > 0 then                SetValuesAt(TempSortingTable, CurrMaxRemAmount);        end else            SetValuesAt(TempSortingTable, 1000);        // Add the points in order        FixedFee := ReminderLevel.CalculateAdditionalFixedFee(Currency, ChargePerLine, Today);        TempSortingTable.SetCurrentKey(Decimal);        if TempSortingTable.FindSet() then            repeat                BusChartBuf.AddColumn(TempSortingTable.Decimal * CurrencyFactor);                BusChartBuf.SetValue(MeasureA, XIndex, FixedFee);                BusChartBuf.SetValue(                  MeasureB, XIndex,                  AddFeeSetup.GetAdditionalFeeFromSetup(ReminderLevel,                    TempSortingTable.Decimal * CurrencyFactor, Currency, ChargePerLine, 1, Today));                BusChartBuf.SetValue(                  MeasureC, XIndex,                  AddFeeSetup.GetAdditionalFeeFromSetup(ReminderLevel,                    TempSortingTable.Decimal * CurrencyFactor, Currency, ChargePerLine, 2, Today));                XIndex += 1;            until TempSortingTable.Next() = 0;    end;    local procedure SetValuesAt(var TempSortingTable: Record "Sorting Table" temporary; RemAmount: Decimal)    begin        if (RemAmount > CurrMaxRemAmount) and (CurrMaxRemAmount > 0) then            exit;        TempSortingTable.Init();        TempSortingTable.Integer := NextEntryNo;        NextEntryNo += 1;        TempSortingTable.Decimal := RemAmount; // Used as buffer to store decimals and sort them later        TempSortingTable.Insert();    end;}