Page 4402 SOA KPI
src/Apps/W1/SalesOrderAgent/app/src/RoleCenter/SOAKPI.Page.al296 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.// ------------------------------------------------------------------------------------------------#pragma warning disable AS0007namespace Microsoft.Agent.SalesOrderAgent;using Microsoft.Finance.GeneralLedger.Setup;using System.Agents;using System.Reflection;page 4402 "SOA KPI"{ PageType = CardPart; ApplicationArea = All;#pragma warning disable AS0035 // SourceTable changed from obsoleted singleton "SOA KPI" (ObsoleteTag 29.0) to "SOA KPI Summary" for per-agent KPI tracking. SourceTable = "SOA KPI Summary";#pragma warning restore AS0035 Permissions = tabledata "General Ledger Setup" = R; Caption = 'Sales Order Agent'; InherentEntitlements = X; InherentPermissions = X; layout { area(Content) { cuegroup(Summary) { ShowCaption = false; field(ReceivedEmails; Rec."Received Emails") { ApplicationArea = All; Caption = 'Received emails'; ToolTip = 'Specifies the total number of emails that the agent has received.'; } field(Quotes; Rec."Total Quotes Created") { ApplicationArea = All; Caption = 'Quotes created'; ToolTip = 'Specifies the total number of quotes that the agent has created. Both active and inactive quotes are included.'; trigger OnDrillDown() var SOAKPIEntry: Record "SOA KPI Entry"; begin SOAKPIEntry.SetRange("Created by User ID", Rec."User Security ID"); SOAKPIEntry.SetRange("Record Type", SOAKPIEntry."Record Type"::"Sales Quote"); Page.Run(Page::"SOA KPI Entries", SOAKPIEntry); end; } field(Orders; Rec."Total Orders Created") { ApplicationArea = All; Caption = 'Orders created'; ToolTip = 'Specifies the total number of orders that the agent has created. Both active and inactive orders are included.'; trigger OnDrillDown() var SOAKPIEntry: Record "SOA KPI Entry"; begin SOAKPIEntry.SetRange("Created by User ID", Rec."User Security ID"); SOAKPIEntry.SetRange("Record Type", SOAKPIEntry."Record Type"::"Sales Order"); Page.Run(Page::"SOA KPI Entries", SOAKPIEntry); end; } field(TimeSavedEmailsHour; TimeSavedEmails) { ApplicationArea = All; Caption = 'Time saved on emails'; AutoFormatType = 11; AutoFormatExpression = EmailTimeAutoFormatExpression; ToolTip = 'Specifies the total time saved by the agent on emails. The time saved is calculated based on the assumption that the agent saves 3 minutes per email.'; } field(TimeSavedQuotesMin; TimeSavedQuotes) { ApplicationArea = All; Caption = 'Time saved on quotes'; AutoFormatType = 11; AutoFormatExpression = QuoteTimeAutoFormatExpression; ToolTip = 'Specifies the total time saved by the agent on quotes. The time saved is calculated based on the assumption that the agent saves 6 minutes per quote.'; } field(TotalAmountOrders; TotalAmountOrders) { ApplicationArea = All; AutoFormatExpression = TotalAmountOrdersFormat; AutoFormatType = 11; CaptionClass = '3,' + GetAmountCaption(); Caption = 'Amount incl. Tax'; ToolTip = 'Specifies the total amount of all orders that the agent has created. Both active and inactive orders are included.'; } } } } trigger OnOpenPage() begin CurrentAgentSecurityID := GetAgentSecurityIDFromFilter(); if IsNullGuid(CurrentAgentSecurityID) then CurrentAgentSecurityID := GetCurrentUserAgentSecurityID(); Rec.GetSafe(CurrentAgentSecurityID); VerifyUserHasAccessToAgent(); end; trigger OnAfterGetCurrRecord() begin CalculateTotals(); end; local procedure CalculateTotals() begin VerifyUserHasAccessToAgent(); Rec.UpdateEmailKPIs(CurrentAgentSecurityID); GetAmount(Rec."Total Amount Orders", TotalAmountOrders, TotalAmountOrdersFormat); TimeSavedEmails := GetTimeSavedEmails(EmailTimeAutoFormatExpression); TimeSavedQuotes := GetTimeSavedQuotes(QuoteTimeAutoFormatExpression); end; local procedure VerifyUserHasAccessToAgent() var Agent: Record Agent; begin // Verify user has access to the agent if IsNullGuid(CurrentAgentSecurityID) then exit; Agent.Get(CurrentAgentSecurityID); end; local procedure GetAgentSecurityIDFromFilter(): Guid var AgentSecurityID: Guid; UserSecurityIDFilter: Text; begin UserSecurityIDFilter := Rec.GetFilter("User Security ID"); if Evaluate(AgentSecurityID, UserSecurityIDFilter) then exit(AgentSecurityID); Clear(AgentSecurityID); exit(AgentSecurityID); end; local procedure GetCurrentUserAgentSecurityID(): Guid var SOASetup: Record "SOA Setup"; SOASetupCU: Codeunit "SOA Setup"; begin // An archived agent has no live KPIs, so prefer an agent that is still in use. SOASetup.SetRange("Owner User Security ID", UserSecurityId()); if SOASetupCU.FindFirstNonArchivedSetup(SOASetup) then exit(SOASetup."User Security ID"); // Backward compatibility for setups created before Owner User Security ID existed. SOASetup.Reset(); SOASetup.SetRange("User Security ID", UserSecurityId()); if SOASetup.FindFirst() then exit(SOASetup."User Security ID"); end; local procedure GetAmount(CurrentAmount: Decimal; var NewAmount: Decimal; var NewAmountFormat: Text) var TypeHelper: Codeunit "Type Helper"; AmountAbbreviation: Text; DecimalPlaces: Integer; begin ShortenAmount(CurrentAmount, NewAmount, AmountAbbreviation, DecimalPlaces); NewAmountFormat := TypeHelper.GetAmountFormatWithUserLocale('', DecimalPlaces); NewAmountFormat := NewAmountFormat.TrimStart(' ').TrimEnd(' ') + ' ' + AmountAbbreviation; end; local procedure GetAmountCaption(): Text var AmountCaption: Text; begin AmountCaption := AmountIncludingTaxLbl; AddCurrencySymbol(AmountCaption); exit(AmountCaption); end; local procedure AddCurrencySymbol(var AmountCaption: Text) var GeneralLedgerSetup: Record "General Ledger Setup"; CurrencySymbol: Text[10]; begin GeneralLedgerSetup.ReadIsolation := IsolationLevel::ReadUncommitted; CurrencySymbol := ''; if GeneralLedgerSetup.Get() then CurrencySymbol := GeneralLedgerSetup.GetCurrencySymbol(); if CurrencySymbol <> '' then AmountCaption := StrSubstNo(AmountIncludingCurrencyLbl, AmountCaption, CurrencySymbol); end; local procedure ShortenAmount(CurrentAmount: Decimal; var NewAmount: Decimal; var AmountAbbreviation: Text; var DecimalPlaces: Integer) begin // From 1 until 99999 increment of 1 if CurrentAmount < 100000 then begin AmountAbbreviation := ''; NewAmount := Round(CurrentAmount, 1); DecimalPlaces := 0; exit; end; // From 0.1M until 9.9M increment of 0.1 if CurrentAmount < 10000000 then begin AmountAbbreviation := MillionAbbreviationLbl; NewAmount := Round(CurrentAmount / 1000000, 0.1); DecimalPlaces := 1; exit; end; // From 10M to 99 M increment of 1 if CurrentAmount < 100000000 then begin AmountAbbreviation := MillionAbbreviationLbl; NewAmount := Round(CurrentAmount / 1000000, 1); DecimalPlaces := 0; exit; end; // From 0.1B increment of 0.1 AmountAbbreviation := BillionAbbreviationLbl; NewAmount := Round(CurrentAmount / 1000000000, 0.1); DecimalPlaces := 1; end; local procedure GetTimeSavedEmails(var ControlAutoFormatExpression: Text): Decimal begin exit(ConvertDurationToText(Rec."Total Emails" * 3, ControlAutoFormatExpression)); // Estimate is - 3 minutes per email end; local procedure GetTimeSavedQuotes(var ControlAutoFormatExpression: Text): Decimal begin exit(ConvertDurationToText(Rec."Total Quotes Created" * 6, ControlAutoFormatExpression)); // Estimate is - 6 minutes per quote end; local procedure ConvertDurationToText(MinutesSaved: Integer; var ControlAutoFormatExpression: Text): Decimal var HoursSaved: Decimal; DaysSaved: Decimal; YearsSaved: Decimal; begin ControlAutoFormatExpression := StrSubstNo(AutoFormatExpressionLbl, MinutesUnitLbl); if MinutesSaved < 60 then exit(MinutesSaved); ControlAutoFormatExpression := StrSubstNo(AutoFormatExpressionLbl, HoursUnitLbl); // Under 100 hours we track with 0.1 increment, over 100 hours we track with 0.5 increment. // This is to show more progress in the beginning. With larger numbers it feels odd to track with small increments. if MinutesSaved < 6000 then HoursSaved := Round(MinutesSaved / 60, 0.1) else HoursSaved := Round(MinutesSaved / 60, 0.5); if HoursSaved < 1000 then exit(HoursSaved); // Under 100 days we track with 0.1 increment, over 100 days we report full days. DaysSaved := Round(HoursSaved / 24, 0.1); ControlAutoFormatExpression := StrSubstNo(AutoFormatExpressionLbl, DaysUnitLbl); if DaysSaved < 100 then exit(DaysSaved) else DaysSaved := Round(DaysSaved, 1); if DaysSaved < 1000 then exit(DaysSaved); // Years are always reported with 0.01 increment. YearsSaved := Round(DaysSaved / 365, 0.01); ControlAutoFormatExpression := StrSubstNo(AutoFormatExpressionLbl, YearsUnitLbl); exit(YearsSaved); end; var TimeSavedEmails: Decimal; TimeSavedQuotes: Decimal; EmailTimeAutoFormatExpression: Text; QuoteTimeAutoFormatExpression: Text; TotalAmountOrdersFormat: Text; TotalAmountOrders: Decimal; CurrentAgentSecurityID: Guid; AmountIncludingTaxLbl: Label 'Amount incl. Tax'; AmountIncludingCurrencyLbl: Label '%1 (%2)', Comment = '%1 - is the title e.g. Amount incl. Tax, %2 - is the currency symbol. Example of full title Amount incl. Tax ($) or Amount incl. Tax (DKK)'; AutoFormatExpressionLbl: Label '<Precision,0:1><Standard Format,0> %1', Locked = true, Comment = '%1 - is the unit hr or min'; HoursUnitLbl: Label 'h', Comment = 'h represents hours, it will be shown like 23.7 h', MaxLength = 3; DaysUnitLbl: Label 'd', Comment = 'd represents days, it will be shown like 23.6 d', MaxLength = 3; YearsUnitLbl: Label 'yr', Comment = 'yr represents years, it will be shown like 3.6 yr', MaxLength = 3; MinutesUnitLbl: Label 'min', Comment = 'min represents minutes, it will be shown like 23 min', MaxLength = 3; MillionAbbreviationLbl: Label 'M', Comment = 'M is a short for million, use a local language abbreviation.', MaxLength = 5; BillionAbbreviationLbl: Label 'B', Comment = 'B is a short for billion, use a local language abbreviation.', MaxLength = 5;}