Codeunit 920 Period Form Lines Mgt.
src/Layers/W1/BaseApp/Foundation/Period/PeriodFormLinesMgt.Codeunit.al151 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.Foundation.Period;using Microsoft.Foundation.Enums;using Microsoft.Sales.Analysis;using System.Utilities;codeunit 920 "Period Form Lines Mgt."{ trigger OnRun() begin end; var DummyBuffer: Record "Customer Sales Buffer"; PeriodPageMgt: Codeunit PeriodPageManagement; procedure FindDate(var BufferRecord: Variant; var DateRec: Record Date; Which: Text[3]; PeriodType: Option): Boolean var RecRef: RecordRef; FoundDate: Boolean; FoundLine: Boolean; begin RecRef.GetTable(BufferRecord); CopyPeriodStartFilter(RecRef, DateRec); FoundDate := PeriodPageMgt.FindDate(Which, DateRec, "Analysis Period Type".FromInteger(PeriodType)); if not FoundDate then exit(false); FoundLine := FindLine(RecRef, DateRec); if not FoundLine then FoundLine := InsertLine(RecRef, DateRec); RecRef.SetTable(BufferRecord); exit(FoundLine); end; procedure NextDate(var BufferRecord: Variant; var DateRec: Record Date; Steps: Integer; PeriodType: Option): Integer var RecRef: RecordRef; ResultSteps: Integer; ShouldInsertLine: Boolean; begin RecRef.GetTable(BufferRecord); CopyPeriodStartFilter(RecRef, DateRec); if not CompareRecRefWithDate(RecRef, DateRec) then if not FindDateRec(DateRec, RecRef, "Analysis Period Type".FromInteger(PeriodType)) then exit(0); ResultSteps := PeriodPageMgt.NextDate(Steps, DateRec, "Analysis Period Type".FromInteger(PeriodType)); if ResultSteps = 0 then exit(0); ShouldInsertLine := not FindLine(RecRef, DateRec); OnNextDateOnAfterCalcShouldInsertLine(BufferRecord, DateRec, ResultSteps, ShouldInsertLine); if ShouldInsertLine then if not InsertLine(RecRef, DateRec) then exit(0); RecRef.SetTable(BufferRecord); exit(ResultSteps); end; local procedure FindLine(var RecRef: RecordRef; var TargetDate: Record Date) FoundLine: Boolean begin RecRef.Reset(); SetFieldFilter(RecRef, DummyBuffer.FieldNo("Period Type"), TargetDate."Period Type"); SetFieldFilter(RecRef, DummyBuffer.FieldNo("Period Start"), TargetDate."Period Start"); FoundLine := RecRef.FindFirst(); RecRef.Reset(); end; local procedure InsertLine(var RecRef: RecordRef; var TargetDate: Record Date): Boolean begin SetFieldValue(RecRef, DummyBuffer.FieldNo("Period Type"), TargetDate."Period Type"); SetFieldValue(RecRef, DummyBuffer.FieldNo("Period Start"), TargetDate."Period Start"); SetFieldValue(RecRef, DummyBuffer.FieldNo("Period End"), TargetDate."Period End"); SetFieldValue(RecRef, DummyBuffer.FieldNo("Period Name"), TargetDate."Period Name"); exit(RecRef.Insert()); end; local procedure FindDateRec(var TargetDate: Record Date; var RecRef: RecordRef; PeriodType: Enum "Analysis Period Type") FoundLine: Boolean begin TargetDate."Period Start" := GetFieldDate(RecRef, DummyBuffer.FieldNo("Period Start")); FoundLine := PeriodPageMgt.FindDate('=<>', TargetDate, PeriodType); end; local procedure CompareRecRefWithDate(var RecRef: RecordRef; var TargetDate: Record Date): Boolean begin if GetFieldInteger(RecRef, DummyBuffer.FieldNo("Period Type")) <> TargetDate."Period Type" then exit(false); exit(GetFieldDate(RecRef, DummyBuffer.FieldNo("Period Start")) = TargetDate."Period Start"); end; local procedure SetFieldValue(var RecRef: RecordRef; FieldNo: Integer; FieldValue: Variant) var BufferField: FieldRef; begin BufferField := RecRef.Field(FieldNo); BufferField.Value := FieldValue; end; local procedure GetFieldDate(var RecRef: RecordRef; FieldNo: Integer) Result: Date var BufferField: FieldRef; begin BufferField := RecRef.Field(FieldNo); Result := BufferField.Value(); end; local procedure GetFieldInteger(var RecRef: RecordRef; FieldNo: Integer) Result: Integer var BufferField: FieldRef; begin BufferField := RecRef.Field(FieldNo); Result := BufferField.Value(); end; local procedure SetFieldFilter(var RecRef: RecordRef; FieldNo: Integer; FieldFilter: Variant) var BufferField: FieldRef; begin BufferField := RecRef.Field(FieldNo); BufferField.SetRange(FieldFilter); end; local procedure GetPeriodStartFilter(RecRef: RecordRef): Text var PeriodStart: FieldRef; begin PeriodStart := RecRef.Field(DummyBuffer.FieldNo("Period Start")); exit(PeriodStart.GetFilter()); end; local procedure CopyPeriodStartFilter(var RecRef: RecordRef; var DateRec: Record Date) begin DateRec.SetFilter("Period Start", GetPeriodStartFilter(RecRef)); end; [IntegrationEvent(false, false)] local procedure OnNextDateOnAfterCalcShouldInsertLine(var BufferRecord: Variant; var DateRec: Record Date; var ResultSteps: Integer; var ShouldInsertLine: Boolean) begin end;}