Codeunit 781 Sales Pipeline Chart Mgt.

Base Application, Microsoft.Sales.Analysis

src/Layers/W1/BaseApp/Sales/Analysis/SalesPipelineChartMgt.Codeunit.al199 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.Analysis;using Microsoft.CRM.Opportunity;using System.Visualization;/// <summary>/// Manages the sales pipeline chart data and navigation between sales cycles./// </summary>codeunit 781 "Sales Pipeline Chart Mgt."{    trigger OnRun()    begin    end;    /// <summary>    /// Opens the opportunity entries page filtered by the selected sales cycle stage.    /// </summary>    /// <param name="BusinessChartBuffer">The business chart buffer containing drill-down context.</param>    /// <param name="SalesCycleStage">The sales cycle stage records used to determine filtering.</param>    procedure DrillDown(var BusinessChartBuffer: Record "Business Chart Buffer"; var SalesCycleStage: Record "Sales Cycle Stage")    var        OppEntry: Record "Opportunity Entry";    begin        if SalesCycleStage.FindSet() then begin            SalesCycleStage.Next(BusinessChartBuffer."Drill-Down X Index");            OppEntry.SetRange("Sales Cycle Code", SalesCycleStage."Sales Cycle Code");            OppEntry.SetRange("Sales Cycle Stage", SalesCycleStage.Stage);            OnBeforeDrillDown(OppEntry);            PAGE.Run(PAGE::"Opportunity Entries", OppEntry);        end;    end;    /// <summary>    /// Returns the count of opportunity entries for the specified sales cycle and stage.    /// </summary>    /// <param name="SalesCycleCode">The sales cycle code to filter by.</param>    /// <param name="SalesCycleStage">The stage number within the sales cycle.</param>    /// <returns>The count of matching opportunity entries.</returns>    procedure GetOppEntryCount(SalesCycleCode: Code[10]; SalesCycleStage: Integer): Integer    var        OppEntry: Record "Opportunity Entry";    begin        OppEntry.SetRange("Sales Cycle Code", SalesCycleCode);        OppEntry.SetRange("Sales Cycle Stage", SalesCycleStage);        OnGetOppEntryCountOnBeforeCount(OppEntry);        exit(OppEntry.Count);    end;    /// <summary>    /// Populates a temporary table with stages from the specified sales cycle.    /// </summary>    /// <param name="TempSalesCycleStage">The temporary table to populate with sales cycle stages.</param>    /// <param name="SalesCycle">The sales cycle to retrieve stages from.</param>    procedure InsertTempSalesCycleStage(var TempSalesCycleStage: Record "Sales Cycle Stage" temporary; SalesCycle: Record "Sales Cycle")    var        SourceSalesCycleStage: Record "Sales Cycle Stage";    begin        TempSalesCycleStage.Reset();        TempSalesCycleStage.DeleteAll();        SourceSalesCycleStage.SetRange("Sales Cycle Code", SalesCycle.Code);        if SourceSalesCycleStage.FindSet() then            repeat                TempSalesCycleStage := SourceSalesCycleStage;                TempSalesCycleStage.Insert();            until SourceSalesCycleStage.Next() = 0;    end;    /// <summary>    /// Sets the default sales cycle and determines navigation availability.    /// </summary>    /// <param name="SalesCycle">The sales cycle record to initialize with the first available cycle.</param>    /// <param name="NextSalesCycleAvailable">Returns whether a next sales cycle is available.</param>    /// <param name="PrevSalesCycleAvailable">Returns whether a previous sales cycle is available.</param>    /// <returns>True if a sales cycle was found, otherwise false.</returns>    procedure SetDefaultSalesCycle(var SalesCycle: Record "Sales Cycle"; var NextSalesCycleAvailable: Boolean; var PrevSalesCycleAvailable: Boolean): Boolean    begin        OnBeforeSetDefaultSalesCycle(SalesCycle);        if not SalesCycle.FindFirst() then            exit(false);        NextSalesCycleAvailable := TryNextSalesCycle(SalesCycle);        PrevSalesCycleAvailable := TryPrevSalesCycle(SalesCycle);        exit(true);    end;    /// <summary>    /// Navigates to the previous or next sales cycle and updates availability flags.    /// </summary>    /// <param name="SalesCycle">The current sales cycle record to navigate from.</param>    /// <param name="NextSalesCycleAvailable">Returns whether a next sales cycle is available after navigation.</param>    /// <param name="PrevSalesCycleAvailable">Returns whether a previous sales cycle is available after navigation.</param>    /// <param name="Step">The navigation direction: positive for next, negative for previous.</param>    procedure SetPrevNextSalesCycle(var SalesCycle: Record "Sales Cycle"; var NextSalesCycleAvailable: Boolean; var PrevSalesCycleAvailable: Boolean; Step: Integer)    begin        SalesCycle.Next(Step);        NextSalesCycleAvailable := TryNextSalesCycle(SalesCycle);        PrevSalesCycleAvailable := TryPrevSalesCycle(SalesCycle);    end;    local procedure TryNextSalesCycle(CurrentSalesCycle: Record "Sales Cycle"): Boolean    var        NextSalesCycle: Record "Sales Cycle";    begin        NextSalesCycle := CurrentSalesCycle;        OnTryNextSalesCycleOnBeforeNextSalesCycleFind(NextSalesCycle);#pragma warning disable AA0181, AA0233 // Positional Find() paired with Next(); suppression tracked for follow-up        NextSalesCycle.Find('=><');        exit(NextSalesCycle.Next() <> 0);#pragma warning restore AA0181, AA0233    end;    local procedure TryPrevSalesCycle(CurrentSalesCycle: Record "Sales Cycle"): Boolean    var        PrevSalesCycle: Record "Sales Cycle";    begin        PrevSalesCycle := CurrentSalesCycle;        OnTryPrevSalesCycleOnBeforePrevSalesCycleFind(PrevSalesCycle);#pragma warning disable AA0181, AA0233 // Positional Find() paired with Next(); suppression tracked for follow-up        PrevSalesCycle.Find('=><');        exit(PrevSalesCycle.Next(-1) <> 0);#pragma warning restore AA0181, AA0233    end;    /// <summary>    /// Updates the chart data with opportunity counts for each sales cycle stage.    /// </summary>    /// <param name="BusinessChartBuffer">The business chart buffer to populate with data.</param>    /// <param name="TempSalesCycleStage">The temporary table to populate with sales cycle stages.</param>    /// <param name="SalesCycle">The sales cycle to display data for.</param>    [Scope('OnPrem')]    procedure UpdateData(var BusinessChartBuffer: Record "Business Chart Buffer"; var TempSalesCycleStage: Record "Sales Cycle Stage" temporary; SalesCycle: Record "Sales Cycle")    var        I: Integer;    begin        BusinessChartBuffer.Initialize();        BusinessChartBuffer.AddIntegerMeasure(TempSalesCycleStage.FieldCaption("No. of Opportunities"), 1, BusinessChartBuffer."Chart Type"::Funnel);        BusinessChartBuffer.SetXAxis(TempSalesCycleStage.TableCaption(), BusinessChartBuffer."Data Type"::String);        InsertTempSalesCycleStage(TempSalesCycleStage, SalesCycle);        if TempSalesCycleStage.FindSet() then            repeat                I += 1;                BusinessChartBuffer.AddColumn(TempSalesCycleStage.Description);                BusinessChartBuffer.SetValueByIndex(0, I - 1, GetOppEntryCount(TempSalesCycleStage."Sales Cycle Code", TempSalesCycleStage.Stage));            until TempSalesCycleStage.Next() = 0;    end;    /// <summary>    /// Raised before opening the opportunity entries page during drill-down.    /// </summary>    /// <param name="OppEntry">The opportunity entry record with applied filters.</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeDrillDown(var OppEntry: Record "Opportunity Entry")    begin    end;    /// <summary>    /// Raised before selecting the default sales cycle.    /// </summary>    /// <param name="SalesCycle">The sales cycle record that will be initialized.</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeSetDefaultSalesCycle(var SalesCycle: Record "Sales Cycle")    begin    end;    /// <summary>    /// Raised before counting opportunity entries for a sales cycle stage.    /// </summary>    /// <param name="OppEntry">The opportunity entry record with applied filters.</param>    [IntegrationEvent(false, false)]    local procedure OnGetOppEntryCountOnBeforeCount(var OppEntry: Record "Opportunity Entry")    begin    end;    /// <summary>    /// Raised before checking if a next sales cycle is available.    /// </summary>    /// <param name="NextSalesCycle">The sales cycle record to check for next availability.</param>    [IntegrationEvent(false, false)]    local procedure OnTryNextSalesCycleOnBeforeNextSalesCycleFind(var NextSalesCycle: Record "Sales Cycle")    begin    end;    /// <summary>    /// Raised before checking if a previous sales cycle is available.    /// </summary>    /// <param name="PrevSalesCycle">The sales cycle record to check for previous availability.</param>    [IntegrationEvent(false, false)]    local procedure OnTryPrevSalesCycleOnBeforePrevSalesCycleFind(var PrevSalesCycle: Record "Sales Cycle")    begin    end;}