Codeunit 869 Cash Flow Chart Mgt.
src/Layers/W1/BaseApp/CashFlow/Forecast/CashFlowChartMgt.Codeunit.al310 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.CashFlow.Forecast;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Setup;using System.Visualization;codeunit 869 "Cash Flow Chart Mgt."{ trigger OnRun() begin end; var CashFlowForecast: Record "Cash Flow Forecast"; CashFlowSetup: Record "Cash Flow Setup"; CashFlowChartSetup: Record "Cash Flow Chart Setup";#pragma warning disable AA0074 TextTotal: Label 'Total'; TextPositive: Label 'Positive'; TextNegative: Label 'Negative'; Text001: Label 'Select the "Show in Chart on Role Center" field in the Cash Flow Forecast window to display the chart on the Role Center.';#pragma warning restore AA0074 procedure OnOpenPage(var CashFlowChartSetup: Record "Cash Flow Chart Setup") begin if not CashFlowChartSetup.Get(UserId) then begin CashFlowChartSetup."User ID" := CopyStr(UserId(), 1, MaxStrLen(CashFlowChartSetup."User ID")); CashFlowChartSetup."Start Date" := CashFlowChartSetup."Start Date"::"Working Date"; CashFlowChartSetup."Period Length" := CashFlowChartSetup."Period Length"::Month; CashFlowChartSetup.Show := CashFlowChartSetup.Show::Combined; CashFlowChartSetup."Chart Type" := CashFlowChartSetup."Chart Type"::"Stacked Column"; CashFlowChartSetup."Group By" := CashFlowChartSetup."Group By"::"Source Type"; CashFlowChartSetup.Insert(); end; end; [Scope('OnPrem')] procedure DrillDown(var BusChartBuf: Record "Business Chart Buffer") var ToDate: Date; begin ToDate := BusChartBuf.GetXValueAsDate(BusChartBuf."Drill-Down X Index"); CashFlowChartSetup.Get(UserId); BusChartBuf."Period Length" := CashFlowChartSetup."Period Length"; CashFlowForecast.Reset(); CashFlowForecast.SetCashFlowDateFilter(BusChartBuf.CalcFromDate(ToDate), ToDate); DrillDownAmountForGroupBy(CashFlowForecast, CashFlowChartSetup."Group By", BusChartBuf.GetCurrMeasureValueString()); end; local procedure DrillDownAmountForGroupBy(var CashFlowForecast: Record "Cash Flow Forecast"; GroupBy: Option; Value: Text[30]) var SourceType: Integer; AccountNo: Code[20]; PositiveAmount: Boolean; begin if Value = '' then CashFlowForecast.DrillDown() else case GroupBy of CashFlowChartSetup."Group By"::"Positive/Negative": begin Evaluate(PositiveAmount, Value, 9); CashFlowForecast.DrillDownPosNegEntries(PositiveAmount); end; CashFlowChartSetup."Group By"::"Account No.": begin Evaluate(AccountNo, Value, 9); CashFlowForecast.DrillDownEntriesForAccNo(AccountNo); end; CashFlowChartSetup."Group By"::"Source Type": begin Evaluate(SourceType, Value, 9); CashFlowForecast.DrillDownSourceTypeEntries("Cash Flow Source Type".FromInteger(SourceType)); end; end; end; [Scope('OnPrem')] procedure UpdateData(var BusChartBuf: Record "Business Chart Buffer"): Boolean var BusChartMapColumn: Record "Business Chart Map"; BusChartMapMeasure: Record "Business Chart Map"; Amount: Decimal; FromDate: Date; ToDate: Date; Accumulate: Boolean; begin if not CashFlowSetup.Get() or CashFlowForecast.IsEmpty() then exit(false); if CashFlowSetup."CF No. on Chart in Role Center" = '' then begin Message(Text001); exit(false); end; CashFlowForecast.Get(CashFlowSetup."CF No. on Chart in Role Center"); CashFlowChartSetup.Get(UserId); BusChartBuf.Initialize(); BusChartBuf."Period Length" := CashFlowChartSetup."Period Length"; BusChartBuf.SetPeriodXAxis(); if CalcPeriods(CashFlowForecast, BusChartBuf) then begin case CashFlowChartSetup.Show of CashFlowChartSetup.Show::"Accumulated Cash": AddMeasures(CashFlowForecast, CashFlowChartSetup.Show::"Accumulated Cash", BusChartBuf); CashFlowChartSetup.Show::"Change in Cash": AddMeasures(CashFlowForecast, CashFlowChartSetup.Show::"Change in Cash", BusChartBuf); CashFlowChartSetup.Show::Combined: begin AddMeasures(CashFlowForecast, CashFlowChartSetup.Show::"Change in Cash", BusChartBuf); AddMeasures(CashFlowForecast, CashFlowChartSetup.Show::"Accumulated Cash", BusChartBuf); end; end; if BusChartBuf.FindFirstMeasure(BusChartMapMeasure) then repeat Accumulate := BusChartMapMeasure.Name = TextTotal; if BusChartBuf.FindFirstColumn(BusChartMapColumn) then repeat ToDate := BusChartMapColumn.GetValueAsDate(); if Accumulate then begin if CashFlowChartSetup."Start Date" = CashFlowChartSetup."Start Date"::"Working Date" then FromDate := WorkDate() else FromDate := 0D end else FromDate := BusChartBuf.CalcFromDate(ToDate); CashFlowForecast.Reset(); CashFlowForecast.SetCashFlowDateFilter(FromDate, ToDate); Amount := CalcAmountForGroupBy(CashFlowForecast, CashFlowChartSetup."Group By", BusChartMapMeasure."Value String"); BusChartBuf.SetValue(BusChartMapMeasure.Name, BusChartMapColumn.Index, Amount); until not BusChartBuf.NextColumn(BusChartMapColumn); until not BusChartBuf.NextMeasure(BusChartMapMeasure); end; exit(true); end; local procedure CalcAmountForGroupBy(var CashFlowForecast: Record "Cash Flow Forecast"; GroupBy: Option; Value: Text[30]): Decimal var SourceType: Integer; AccountNo: Code[20]; PositiveAmount: Boolean; begin if Value = '' then exit(CashFlowForecast.CalcAmount()); case GroupBy of CashFlowChartSetup."Group By"::"Positive/Negative": begin Evaluate(PositiveAmount, Value, 9); exit(CashFlowForecast.CalcAmountForPosNeg(PositiveAmount)); end; CashFlowChartSetup."Group By"::"Account No.": begin Evaluate(AccountNo, Value, 9); exit(CashFlowForecast.CalcAmountForAccountNo(AccountNo)); end; CashFlowChartSetup."Group By"::"Source Type": begin Evaluate(SourceType, Value, 9); exit(CashFlowForecast.CalcSourceTypeAmount("Cash Flow Source Type".FromInteger(SourceType))); end; end; end; local procedure AddMeasures(CashFlowForecast: Record "Cash Flow Forecast"; Show: Option; var BusChartBuf: Record "Business Chart Buffer") begin case Show of CashFlowChartSetup.Show::"Accumulated Cash": BusChartBuf.AddDecimalMeasure(TextTotal, '', BusChartBuf."Chart Type"::StepLine); CashFlowChartSetup.Show::"Change in Cash": case CashFlowChartSetup."Group By" of CashFlowChartSetup."Group By"::"Positive/Negative": CollectPosNeg(CashFlowForecast, BusChartBuf); CashFlowChartSetup."Group By"::"Account No.": CollectAccounts(CashFlowForecast, BusChartBuf); CashFlowChartSetup."Group By"::"Source Type": CollectSourceTypes(CashFlowForecast, BusChartBuf); end; end; end; local procedure GetEntryDate(CashFlowForecast: Record "Cash Flow Forecast"; Which: Option First,Last): Date begin if Which = Which::First then if CashFlowChartSetup."Start Date" = CashFlowChartSetup."Start Date"::"Working Date" then exit(WorkDate()); exit(CashFlowForecast.GetEntryDate(Which)); end; [Scope('OnPrem')] procedure CollectSourceTypes(CashFlowForecast: Record "Cash Flow Forecast"; var BusChartBuf: Record "Business Chart Buffer"): Integer var CFForecastEntry: Record "Cash Flow Forecast Entry"; SourceType: Enum "Cash Flow Source Type"; SkipSourceType: Boolean; FromDate: Date; ToDate: Date; Which: Option First,Last; Index: Integer; begin Index := 0; FromDate := CashFlowChartSetup.GetStartDate(); ToDate := CashFlowForecast.GetEntryDate(Which::Last); CFForecastEntry.SetRange("Cash Flow Forecast No.", CashFlowForecast."No."); CFForecastEntry.SetRange("Cash Flow Date", FromDate, ToDate); foreach SourceType in "Cash Flow Source Type".Ordinals() do begin SkipSourceType := SourceType = "Cash Flow Source Type"::" "; if not SkipSourceType then begin CFForecastEntry.SetRange("Source Type", SourceType); SkipSourceType := CFForecastEntry.IsEmpty(); end; OnCollectSourceTypesBeforeSkipSourceType(CashFlowChartSetup, CashFlowForecast, SourceType, SkipSourceType); if not SkipSourceType then begin CashFlowForecast."Source Type Filter" := SourceType; Index += 1; BusChartBuf.AddDecimalMeasure( Format(CashFlowForecast."Source Type Filter"), CashFlowForecast."Source Type Filter", BusChartBuf."Chart Type"::StackedColumn); end; end; exit(Index); end; [Scope('OnPrem')] procedure CollectAccounts(CashFlowForecast: Record "Cash Flow Forecast"; var BusChartBuf: Record "Business Chart Buffer"): Integer var CFForecastEntry: Record "Cash Flow Forecast Entry"; CFAccount: Record "Cash Flow Account"; FromDate: Date; ToDate: Date; Which: Option First,Last; Index: Integer; begin Index := 0; FromDate := CashFlowChartSetup.GetStartDate(); ToDate := CashFlowForecast.GetEntryDate(Which::Last); CFForecastEntry.SetRange("Cash Flow Forecast No.", CashFlowForecast."No."); CFForecastEntry.SetRange("Cash Flow Date", FromDate, ToDate); CFAccount.SetRange("Account Type", CFAccount."Account Type"::Entry); if CFAccount.FindSet() then repeat CFForecastEntry.SetRange("Cash Flow Account No.", CFAccount."No."); if not CFForecastEntry.IsEmpty() then begin Index += 1; BusChartBuf.AddDecimalMeasure( CFAccount."No.", CFAccount."No.", BusChartBuf."Chart Type"::StackedColumn); end; until CFAccount.Next() = 0; exit(Index); end; [Scope('OnPrem')] procedure CollectPosNeg(CashFlowForecast: Record "Cash Flow Forecast"; var BusChartBuf: Record "Business Chart Buffer"): Integer var CFForecastEntry: Record "Cash Flow Forecast Entry"; Caption: Text[80]; FromDate: Date; ToDate: Date; Which: Option First,Last; Index: Integer; Positive: Boolean; begin Index := 0; FromDate := CashFlowChartSetup.GetStartDate(); ToDate := CashFlowForecast.GetEntryDate(Which::Last); CFForecastEntry.SetRange("Cash Flow Forecast No.", CashFlowForecast."No."); CFForecastEntry.SetRange("Cash Flow Date", FromDate, ToDate); Caption := TextNegative; for Positive := false to true do begin CFForecastEntry.SetRange(Positive, Positive); if not CFForecastEntry.IsEmpty() then begin Index += 1; BusChartBuf.AddDecimalMeasure(Caption, Positive, BusChartBuf."Chart Type"::StackedColumn); end; Caption := TextPositive; end; exit(Index); end; local procedure CalcPeriods(CashFlowForecast: Record "Cash Flow Forecast"; var BusChartBuf: Record "Business Chart Buffer"): Boolean var Which: Option First,Last; FromDate: Date; ToDate: Date; begin FromDate := GetEntryDate(CashFlowForecast, Which::First); ToDate := GetEntryDate(CashFlowForecast, Which::Last); if ToDate <> 0D then BusChartBuf.AddPeriods(FromDate, ToDate); exit(ToDate <> 0D); end; [IntegrationEvent(false, false)] local procedure OnCollectSourceTypesBeforeSkipSourceType(CashFlowChartSetup: Record "Cash Flow Chart Setup"; CashFlowForecast: Record "Cash Flow Forecast"; SourceType: Enum "Cash Flow Source Type"; var SkipSourceType: Boolean) begin end;}