Codeunit 1326 Top Five Customers Chart Mgt.

Base Application, Microsoft.Sales.Customer

src/Layers/W1/BaseApp/Sales/Customer/TopFiveCustomersChartMgt.Codeunit.al133 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.Customer;using Microsoft.Finance.GeneralLedger.Setup;using System.Visualization;/// <summary>/// Manages the doughnut chart visualization displaying the top five customers by sales./// </summary>codeunit 1326 "Top Five Customers Chart Mgt."{    SingleInstance = true;    trigger OnRun()    begin    end;    var        CustomerXCaptionTxt: Label 'Customer Name';        SalesLCYYCaptionTxt: Label 'Sales (LCY)';        AllOtherCustomersTxt: Label 'All Other Customers';        CustomerNameNoLbl: Label '%1 - %2', Locked = true;        CustomerNo: array[5] of Code[20];    /// <summary>    /// Updates the business chart buffer with the top five customers by sales data for doughnut chart visualization.    /// </summary>    /// <param name="BusChartBuf">Specifies the business chart buffer to populate with customer sales data.</param>    procedure UpdateChart(var BusChartBuf: Record "Business Chart Buffer")    var        GLSetup: Record "General Ledger Setup";        ColumnIndex: Integer;        CustomerName: array[11] of Text[100];        SalesLCY: array[11] of Decimal;    begin        BusChartBuf.Initialize();        if GLSetup.Get() then;        BusChartBuf.AddDecimalMeasure(SalesLCYYCaptionTxt, 1, BusChartBuf."Chart Type"::Doughnut);        BusChartBuf.SetXAxis(CustomerXCaptionTxt, BusChartBuf."Data Type"::String);        CalcTopSalesCustomers(CustomerName, SalesLCY);        for ColumnIndex := 1 to 6 do begin            if SalesLCY[ColumnIndex] = 0 then                exit;            BusChartBuf.AddColumn(CustomerName[ColumnIndex]);            BusChartBuf.SetValueByIndex(0, ColumnIndex - 1, SalesLCY[ColumnIndex]);        end;    end;    /// <summary>    /// Handles drill-down actions on the top five customers chart by opening the customer card or customer list.    /// </summary>    /// <param name="BusChartBuf">Specifies the business chart buffer containing drill-down context information.</param>    procedure DrillDown(var BusChartBuf: Record "Business Chart Buffer")    var        CustomerName: Variant;    begin        BusChartBuf.GetXValue(BusChartBuf."Drill-Down X Index", CustomerName);        // drill down only for top 5 customers        // for the 6th column "all other customers", it drills down to customer list of all other customers        if (BusChartBuf."Drill-Down Measure Index" = 0) and (BusChartBuf."Drill-Down X Index" < 5) then            DrillDownCust(CustomerNo[BusChartBuf."Drill-Down X Index" + 1]);        if (BusChartBuf."Drill-Down Measure Index" = 0) and (BusChartBuf."Drill-Down X Index" = 5) then            DrillDownOtherCustList();    end;    local procedure CalcTopSalesCustomers(var CustomerName: array[6] of Text[100]; var SalesLCY: array[6] of Decimal)    var        TopCustomersBySalesBuffer: Record "Top Customers By Sales Buffer";        TopCustomersBySalesJob: Codeunit "Top Customers By Sales Job";        ChartManagement: Codeunit "Chart Management";        ColumnIndex: Integer;        OtherCustomersSalesLCY: Decimal;    begin        if TopCustomersBySalesBuffer.IsEmpty() then            TopCustomersBySalesJob.UpdateCustomerTopList();        if TopCustomersBySalesBuffer.FindSet() then begin            repeat                ColumnIndex += 1;                if ColumnIndex <= 5 then begin                    CustomerName[TopCustomersBySalesBuffer.Ranking] :=                        CopyStr(StrSubstNo(CustomerNameNoLbl, TopCustomersBySalesBuffer.CustomerNo, TopCustomersBySalesBuffer.CustomerName),                            1, MaxStrLen(CustomerName[TopCustomersBySalesBuffer.Ranking]));                    SalesLCY[TopCustomersBySalesBuffer.Ranking] := TopCustomersBySalesBuffer.SalesLCY;                    CustomerNo[TopCustomersBySalesBuffer.Ranking] := TopCustomersBySalesBuffer.CustomerNo                end else                    OtherCustomersSalesLCY += TopCustomersBySalesBuffer.SalesLCY;            until TopCustomersBySalesBuffer.Next() = 0;            if OtherCustomersSalesLCY <> 0 then begin                CustomerName[6] := AllOtherCustomersTxt;                SalesLCY[6] := OtherCustomersSalesLCY            end;            ChartManagement.ScheduleTopCustomerListRefreshTask()        end;    end;    local procedure DrillDownCust(DrillDownCustomerNo: Code[20])    var        Customer: Record Customer;    begin        Customer.Get(DrillDownCustomerNo);        Page.Run(Page::"Customer Card", Customer);    end;    local procedure DrillDownOtherCustList()    var        Customer: Record Customer;    begin        Customer.SetFilter("No.", GetFilterToExcludeTopFiveCustomers());        Customer.SetCurrentKey(Name);        Customer.Ascending(true);        Page.Run(Page::"Customer List", Customer);    end;    local procedure GetFilterToExcludeTopFiveCustomers(): Text    var        CustomerCounter: Integer;        FilterToExcludeTopFiveCustomers: Text;    begin        for CustomerCounter := 1 to 5 do            if CustomerCounter = 1 then                FilterToExcludeTopFiveCustomers := StrSubstNo('<>%1', CustomerNo[CustomerCounter])            else                FilterToExcludeTopFiveCustomers += StrSubstNo('&<>%1', CustomerNo[CustomerCounter]);        exit(FilterToExcludeTopFiveCustomers);    end;}