Codeunit 362 PeriodPageManagement

Base Application, Microsoft.Foundation.Period

src/Layers/W1/BaseApp/Foundation/Period/PeriodPageManagement.Codeunit.al306 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.Inventory.Item;using System.Utilities;codeunit 362 PeriodPageManagement{    trigger OnRun()    begin    end;    var        AccountingPeriod: Record "Accounting Period";        AccountingPeriodMgt: Codeunit "Accounting Period Mgt.";        WeekYear4Txt: Label '<Week>.<Year4>', Locked = true;        MonthText3Year4Txt: Label '<Month Text,3> <Year4>', Locked = true;        QuarterYear4Txt: Label '<Quarter>/<Year4>', Locked = true;        Year4Txt: Label '<Year4>', Locked = true;    procedure FindDate(SearchString: Text[3]; var Calendar: Record Date; PeriodType: Enum "Analysis Period Type"): Boolean    var        Found: Boolean;        UseAccountingPeriod: Boolean;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFindDate(SearchString, Calendar, PeriodType, Found, IsHandled);        if IsHandled then            exit(Found);        Calendar.SetRange("Period Type", PeriodType);        Calendar."Period Type" := PeriodType.AsInteger();        if Calendar."Period Start" = 0D then            Calendar."Period Start" := WorkDate();        if SearchString in ['', '=><'] then            SearchString := '=<>';        UseAccountingPeriod := PeriodType = PeriodType::"Accounting Period";        IsHandled := false;        OnFindDateOnAfterCalcUseAccountingPeriod(Calendar, PeriodType, AccountingPeriod, UseAccountingPeriod, Found, IsHandled);        if not IsHandled then            if UseAccountingPeriod then begin                AccountingPeriod.SetRange("Starting Date");                if AccountingPeriod.IsEmpty() then begin                    AccountingPeriodMgt.InitDefaultAccountingPeriod(AccountingPeriod, GetCalendarPeriodMinDate(Calendar));                    Found := true;                end else begin                    SetAccountingPeriodFilter(Calendar);                    Found := AccountingPeriod.Find(SearchString);                end;                if Found then                    CopyAccountingPeriod(Calendar);            end else begin                Found := Calendar.Find(SearchString);                if Found then                    Calendar."Period End" := NormalDate(Calendar."Period End");            end;        exit(Found);    end;    procedure NextDate(NextStep: Integer; var Calendar: Record Date; PeriodType: Enum "Analysis Period Type"): Integer    var        UseAccountingPeriod: Boolean;        IsHandled: Boolean;        Result: Integer;    begin        IsHandled := false;        OnBeforeNextDate(NextStep, Calendar, PeriodType, AccountingPeriod, Result, Ishandled);        if IsHandled then            exit(Result);        Calendar.SetRange("Period Type", PeriodType);        Calendar."Period Type" := PeriodType.AsInteger();        UseAccountingPeriod := PeriodType = PeriodType::"Accounting Period";        OnNextDateOnAfterCalcUseAccountingPeriod(Calendar, PeriodType, AccountingPeriod, UseAccountingPeriod);        if UseAccountingPeriod then begin            if AccountingPeriod.IsEmpty() then                AccountingPeriodMgt.InitDefaultAccountingPeriod(AccountingPeriod, CalcDate('<+1M>', GetCalendarPeriodMinDate(Calendar)))            else begin                SetAccountingPeriodFilter(Calendar);                NextStep := AccountingPeriod.Next(NextStep);            end;            if NextStep <> 0 then                CopyAccountingPeriod(Calendar);        end else begin            NextStep := Calendar.Next(NextStep);            if NextStep <> 0 then                Calendar."Period End" := NormalDate(Calendar."Period End");        end;        exit(NextStep);    end;    procedure CreatePeriodFormat(PeriodType: Enum "Analysis Period Type"; Date: Date) PeriodFormat: Text[10]    begin        case PeriodType of            PeriodType::Day:                PeriodFormat := Format(Date);            PeriodType::Week:                begin                    if Date2DWY(Date, 2) = 1 then                        Date := Date + 7 - Date2DWY(Date, 1);                    PeriodFormat := Format(Date, 0, WeekYear4Txt);                end;            PeriodType::Month:                PeriodFormat := Format(Date, 0, MonthText3Year4Txt);            PeriodType::Quarter:                PeriodFormat := Format(Date, 0, QuarterYear4Txt);            PeriodType::Year:                PeriodFormat := Format(Date, 0, Year4Txt);            PeriodType::"Accounting Period":                PeriodFormat := Format(Date);        end;        OnAfterCreatePeriodFormat(PeriodType, Date, PeriodFormat, AccountingPeriod);    end;    procedure MoveDateByPeriod(Date: Date; PeriodType: Option; MoveByNoOfPeriods: Integer): Date    var        DateExpression: DateFormula;    begin        Evaluate(DateExpression, '<' + Format(MoveByNoOfPeriods) + GetPeriodTypeSymbol(PeriodType) + '>');        exit(CalcDate(DateExpression, Date));    end;    procedure MoveDateByPeriodToEndOfPeriod(Date: Date; PeriodType: Option; MoveByNoOfPeriods: Integer): Date    var        DateExpression: DateFormula;    begin        Evaluate(DateExpression, '<' + Format(MoveByNoOfPeriods + 1) + GetPeriodTypeSymbol(PeriodType) + '-1D>');        exit(CalcDate(DateExpression, Date));    end;    procedure GetPeriodTypeSymbol(PeriodType: Option): Text[1]    var        Date: Record Date;    begin        case PeriodType of            Date."Period Type"::Date:                exit('D');            Date."Period Type"::Week:                exit('W');            Date."Period Type"::Month:                exit('M');            Date."Period Type"::Quarter:                exit('Q');            Date."Period Type"::Year:                exit('Y');        end;    end;    local procedure SetAccountingPeriodFilter(var Calendar: Record Date)    begin        AccountingPeriod.SetFilter("Starting Date", Calendar.GetFilter("Period Start"));        AccountingPeriod.SetFilter(Name, Calendar.GetFilter("Period Name"));        AccountingPeriod."Starting Date" := Calendar."Period Start";    end;    local procedure GetCalendarPeriodMinDate(var Calendar: Record Date): Date    begin        if Calendar.GetFilter("Period Start") <> '' then            exit(Calendar.GetRangeMin("Period Start"));        exit(Calendar."Period Start");    end;    local procedure CopyAccountingPeriod(var Calendar: Record Date)    begin        Calendar.Init();        Calendar."Period Start" := AccountingPeriod."Starting Date";        Calendar."Period Name" := AccountingPeriod.Name;        if AccountingPeriod.IsEmpty() then            Calendar."Period End" := AccountingPeriodMgt.GetDefaultPeriodEndingDate(Calendar."Period Start")        else            if AccountingPeriod.Next() = 0 then                Calendar."Period End" := EndOfPeriod()            else                Calendar."Period End" := AccountingPeriod."Starting Date" - 1;    end;    procedure EndOfPeriod(): Date    begin        exit(DMY2Date(31, 12, 9999));    end;    procedure GetFullPeriodDateFilter(PeriodType: Enum "Analysis Period Type"; DateFilter: Text) Result: Text    var        Period: Record Date;        StartDate: Date;        EndDate: Date;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetFullPeriodDateFilter(PeriodType, DateFilter, AccountingPeriod, Result, IsHandled);        if IsHandled then            exit(Result);        if DateFilter = '' then            exit(DateFilter);        Period.SetFilter("Period Start", DateFilter);        StartDate := Period.GetRangeMin("Period Start");        EndDate := Period.GetRangeMax("Period Start");        case PeriodType of            PeriodType::Week,            PeriodType::Month,            PeriodType::Quarter,            PeriodType::Year:                begin                    Period.SetRange("Period Type", PeriodType);                    Period.SetFilter("Period Start", '<=%1', StartDate);                    Period.FindLast();                    StartDate := Period."Period Start";                    Period.SetRange("Period Start");                    Period.SetFilter("Period End", '>%1', EndDate);                    Period.FindFirst();                    EndDate := NormalDate(Period."Period End");                end;            PeriodType::"Accounting Period":                begin                    AccountingPeriod.SetFilter("Starting Date", '<=%1', StartDate);                    AccountingPeriod.FindLast();                    StartDate := AccountingPeriod."Starting Date";                    AccountingPeriod.SetFilter("Starting Date", '>%1', EndDate);                    AccountingPeriod.FindFirst();                    EndDate := AccountingPeriod."Starting Date" - 1;                end;        end;        Period.SetRange("Period Start", StartDate, EndDate);        exit(Period.GetFilter("Period Start"));    end;    procedure FindPeriod(var Item: Record Item; SearchText: Text[3]; PeriodType: Enum "Analysis Period Type"; AmountType: Enum "Analysis Amount Type")    var        Calendar: Record Date;    begin        if Item.GetFilter("Date Filter") <> '' then begin            Calendar.SetFilter("Period Start", Item.GetFilter("Date Filter"));            if not FindDate('+', Calendar, PeriodType) then                FindDate('+', Calendar, PeriodType::Day);            Calendar.SetRange("Period Start");        end;        FindDate(SearchText, Calendar, PeriodType);        if AmountType = AmountType::"Net Change" then begin            Item.SetRange("Date Filter", Calendar."Period Start", Calendar."Period End");            if Item.GetRangeMin("Date Filter") = Item.GetRangeMax("Date Filter") then                Item.SetRange("Date Filter", Item.GetRangeMin("Date Filter"));        end else            Item.SetRange("Date Filter", 0D, Calendar."Period End");    end;    procedure FindPeriodOnMatrixPage(var DateFilter: Text; var InternalDateFilter: Text; SearchText: Text[3]; PeriodType: Enum "Analysis Period Type"; UpdateDateFilter: Boolean)    var        Item: Record Item;        Calendar: Record Date;    begin        if DateFilter <> '' then begin            Calendar.SetFilter("Period Start", DateFilter);            if not FindDate('+', Calendar, PeriodType) then                FindDate('+', Calendar, PeriodType::Day);            Calendar.SetRange("Period Start");        end;        FindDate(SearchText, Calendar, PeriodType);        Item.SetRange("Date Filter", Calendar."Period Start", Calendar."Period End");        if Item.GetRangeMin("Date Filter") = Item.GetRangeMax("Date Filter") then            Item.SetRange("Date Filter", Item.GetRangeMin("Date Filter"));        InternalDateFilter := Item.GetFilter("Date Filter");        if UpdateDateFilter then            DateFilter := InternalDateFilter;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCreatePeriodFormat(PeriodType: Enum "Analysis Period Type"; Date: Date; var PeriodFormat: Text[10]; var AccountingPeriod: Record "Accounting Period")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeGetFullPeriodDateFilter(PeriodType: Enum "Analysis Period Type"; DateFilter: Text; var AccountingPeriod: Record "Accounting Period"; var Result: Text; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindDateOnAfterCalcUseAccountingPeriod(var Calendar: Record Date; PeriodType: Enum "Analysis Period Type"; var AccountingPeriod: Record "Accounting Period"; var UseAccountingPeriod: Boolean; var Found: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnNextDateOnAfterCalcUseAccountingPeriod(var Calendar: Record Date; PeriodType: Enum "Analysis Period Type"; var AccountingPeriod: Record "Accounting Period"; var UseAccountingPeriod: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFindDate(SearchString: Text[3]; var Calendar: Record Date; PeriodType: Enum "Analysis Period Type"; var Found: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeNextDate(NextStep: Integer; var Calendar: record Date; PeriodType: enum "Analysis Period Type"; var AccountingPeriod: Record "Accounting Period"; var Result: Integer; var Ishandled: Boolean)    begin    end;}