Codeunit 7600 Calendar Management

Base Application, Microsoft.Foundation.Calendar

src/Layers/W1/BaseApp/Foundation/Calendar/CalendarManagement.Codeunit.al770 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.Calendar;using Microsoft.Foundation.Company;using Microsoft.Foundation.Shipping;using Microsoft.Inventory.Location;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using System.Utilities;codeunit 7600 "Calendar Management"{    Permissions = tabledata "Base Calendar Change" = r;    trigger OnRun()    begin    end;    var        CurrCustomizedCalendarChange: Record "Customized Calendar Change";        TempCustChange: Record "Customized Calendar Change" temporary;#pragma warning disable AA0470        NegativeExprErr: Label 'The expression %1 cannot be negative.';#pragma warning restore AA0470        SourceErr: Label 'The calendar source must be set by a source record.';    procedure SetSource(SourceVariant: Variant; var NewCustomCalendarChange: Record "Customized Calendar Change")    begin        OnBeforeSetSource(SourceVariant, NewCustomCalendarChange);        if not SourceVariant.IsRecord then            Error(SourceErr);        FillSource(SourceVariant, NewCustomCalendarChange);        CombineChanges(NewCustomCalendarChange, TempCustChange)    end;    procedure FillSource(SourceVariant: Variant; var CustomCalendarChange: Record "Customized Calendar Change")    var        RecRef: RecordRef;    begin        RecRef.GetTable(SourceVariant);        case RecRef.RecordId.TableNo of            Database::"Base Calendar":                SetSourceBaseCalendar(RecRef, CustomCalendarChange);            Database::"Company Information":                SetSourceCompany(RecRef, CustomCalendarChange);            Database::Location:                SetSourceLocation(RecRef, CustomCalendarChange);            Database::Customer:                SetSourceCustomer(RecRef, CustomCalendarChange);            Database::Vendor:                SetSourceVendor(RecRef, CustomCalendarChange);            Database::"Shipping Agent Services":                SetSourceShippingAgentServices(RecRef, CustomCalendarChange);            Database::"Customized Calendar Entry":                SetSourceCustomizedCalendarEntry(RecRef, CustomCalendarChange);            else                OnFillSourceRec(RecRef, CustomCalendarChange);        end;    end;    [IntegrationEvent(false, false)]    local procedure OnFillSourceRec(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    begin    end;    local procedure SetSourceBaseCalendar(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        BaseCalendar: Record "Base Calendar";    begin        RecRef.SetTable(BaseCalendar);        CustomCalendarChange.SetSource(CustomCalendarChange."Source Type"::Company, '', '', BaseCalendar.Code);    end;    local procedure SetSourceCompany(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        CompanyInfo: Record "Company Information";    begin        RecRef.SetTable(CompanyInfo);        CustomCalendarChange.SetSource(CustomCalendarChange."Source Type"::Company, '', '', CompanyInfo."Base Calendar Code");    end;    local procedure SetSourceLocation(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        Location: Record Location;    begin        RecRef.SetTable(Location);        CustomCalendarChange.SetSource(            CustomCalendarChange."Source Type"::Location, Location.Code, '', Location."Base Calendar Code");    end;    local procedure SetSourceCustomer(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        Customer: Record Customer;    begin        RecRef.SetTable(Customer);        CustomCalendarChange.SetSource(            CustomCalendarChange."Source Type"::Customer, Customer."No.", '', Customer."Base Calendar Code");    end;    local procedure SetSourceCustomizedCalendarEntry(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        CustomizedCalendarEntry: record "Customized Calendar Entry";    begin        RecRef.SetTable(CustomizedCalendarEntry);        CustomCalendarChange.SetSource(            CustomizedCalendarEntry."Source Type", CustomizedCalendarEntry."Source Code",            CustomizedCalendarEntry."Additional Source Code", CustomizedCalendarEntry."Base Calendar Code");    end;    local procedure SetSourceShippingAgentServices(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        ShippingAgentServices: Record "Shipping Agent Services";    begin        OnBeforeSetSourceShippingAgentServices(ShippingAgentServices);        RecRef.SetTable(ShippingAgentServices);        CustomCalendarChange.SetSource(            CustomCalendarChange."Source Type"::"Shipping Agent", ShippingAgentServices."Shipping Agent Code",            ShippingAgentServices.Code, ShippingAgentServices."Base Calendar Code");    end;    local procedure SetSourceVendor(RecRef: RecordRef; var CustomCalendarChange: Record "Customized Calendar Change")    var        Vendor: Record Vendor;    begin        RecRef.SetTable(Vendor);        CustomCalendarChange.SetSource(            CustomCalendarChange."Source Type"::Vendor, Vendor."No.", '', Vendor."Base Calendar Code");    end;    procedure ShowCustomizedCalendar(SourceVariant: Variant)    var        TempCustomizedCalEntry: Record "Customized Calendar Entry" temporary;        CustomizedCalendarChange: Record "Customized Calendar Change";    begin        FillSource(SourceVariant, CustomizedCalendarChange);        TempCustomizedCalEntry.CopyFromCustomizedCalendarChange(CustomizedCalendarChange);        TempCustomizedCalEntry.Insert();        PAGE.Run(PAGE::"Customized Calendar Entries", TempCustomizedCalEntry);    end;    procedure GetMaxDate(): Date    var        Date: Record Date;    begin        Date.SetRange("Period Type", Date."Period Type"::Date);        Date.FindLast();        exit(NormalDate(Date."Period End"));    end;    procedure IsNonworkingDay(TargetDate: Date; var CustomizedCalendarChange: Record "Customized Calendar Change"): Boolean;    begin        OnBeforeIsNonworkingDay(TargetDate, CustomizedCalendarChange);        CustomizedCalendarChange.Date := TargetDate;        CheckDateStatus(CustomizedCalendarChange);        exit(CustomizedCalendarChange.Nonworking);    end;    procedure CheckDateStatus(var TargetCustomizedCalendarChange: Record "Customized Calendar Change")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckDateStatus(TargetCustomizedCalendarChange, IsHandled);        if not IsHandled then begin            CombineChanges(TargetCustomizedCalendarChange, TempCustChange);            OnCheckDateStatusOnAfterCombineChanges(TargetCustomizedCalendarChange, TempCustChange);            TargetCustomizedCalendarChange.Description := '';            TargetCustomizedCalendarChange.Nonworking := false;            if CurrCustomizedCalendarChange.IsBlankSource() then                exit;            TempCustChange.Reset();            TempCustChange.SetCurrentKey("Entry No.");            if TempCustChange.FindSet() then                repeat                    if TempCustChange.IsDateCustomized(TargetCustomizedCalendarChange.Date) then begin                        TargetCustomizedCalendarChange.Description := TempCustChange.Description;                        TargetCustomizedCalendarChange.Nonworking := TempCustChange.Nonworking;                        OnCheckDateStatusAfterDateCustomized(TargetCustomizedCalendarChange, TempCustChange);                        exit;                    end;                until TempCustChange.Next() = 0;        end;        OnAfterCheckDateStatus(TargetCustomizedCalendarChange);    end;    local procedure CombineChanges(NewCustomizedCalendarChange: Record "Customized Calendar Change"; var TempCustomizedCalendarChange: record "Customized Calendar Change" temporary)    begin        if CurrCustomizedCalendarChange.IsEqualSource(NewCustomizedCalendarChange) then            exit;        TempCustomizedCalendarChange.Reset();        TempCustomizedCalendarChange.DeleteAll();        AddCustomizedCalendarChanges(NewCustomizedCalendarChange, TempCustomizedCalendarChange);        AddBaseCalendarChanges(NewCustomizedCalendarChange, TempCustomizedCalendarChange);        CurrCustomizedCalendarChange := NewCustomizedCalendarChange;    end;    local procedure AddCustomizedCalendarChanges(NewCustomizedCalendarChange: Record "Customized Calendar Change"; var TempCustomizedCalendarChange: record "Customized Calendar Change" temporary)    var        CustomizedCalendarChange: Record "Customized Calendar Change";        EntryNo: Integer;    begin        OnBeforeAddCustomizedCalendarChanges(CustomizedCalendarChange);        if TempCustomizedCalendarChange.FindLast() then            EntryNo := TempCustomizedCalendarChange."Entry No.";        CustomizedCalendarChange.Reset();        CustomizedCalendarChange.SetRange("Source Type", NewCustomizedCalendarChange."Source Type");        CustomizedCalendarChange.SetRange("Source Code", NewCustomizedCalendarChange."Source Code");        CustomizedCalendarChange.SetRange("Base Calendar Code", NewCustomizedCalendarChange."Base Calendar Code");        CustomizedCalendarChange.SetRange("Additional Source Code", NewCustomizedCalendarChange."Additional Source Code");        if CustomizedCalendarChange.FindSet() then            repeat                EntryNo += 1;                TempCustomizedCalendarChange := CustomizedCalendarChange;                TempCustomizedCalendarChange."Entry No." := EntryNo;                OnCombineCustomCalendarChange(CustomizedCalendarChange, TempCustomizedCalendarChange);                TempCustomizedCalendarChange.Insert();            until CustomizedCalendarChange.Next() = 0;    end;    [IntegrationEvent(false, false)]    local procedure OnCombineCustomCalendarChange(CustomCalChange: Record "Customized Calendar Change"; var CustomizedCalendarChange: record "Customized Calendar Change")    begin    end;    local procedure AddBaseCalendarChanges(NewCustomizedCalendarChange: Record "Customized Calendar Change"; var TempCustomizedCalendarChange: record "Customized Calendar Change" temporary)    var        BaseCalendarChange: Record "Base Calendar Change";        EntryNo: Integer;    begin        OnBeforeAddBaseCalendarChanges(NewCustomizedCalendarChange, TempCustomizedCalendarChange, BaseCalendarChange);        if TempCustomizedCalendarChange.FindLast() then            EntryNo := TempCustomizedCalendarChange."Entry No.";        BaseCalendarChange.Reset();        BaseCalendarChange.SetRange("Base Calendar Code", NewCustomizedCalendarChange."Base Calendar Code");        if BaseCalendarChange.FindSet() then            repeat                EntryNo += 1;                TempCustomizedCalendarChange.Init();                TempCustomizedCalendarChange."Entry No." := EntryNo;                TempCustomizedCalendarChange."Source Type" := NewCustomizedCalendarChange."Source Type";                TempCustomizedCalendarChange."Source Code" := NewCustomizedCalendarChange."Source Code";                TempCustomizedCalendarChange."Additional Source Code" := NewCustomizedCalendarChange."Additional Source Code";                TempCustomizedCalendarChange."Base Calendar Code" := BaseCalendarChange."Base Calendar Code";                TempCustomizedCalendarChange.Date := BaseCalendarChange.Date;                TempCustomizedCalendarChange.Description := BaseCalendarChange.Description;                TempCustomizedCalendarChange.Day := BaseCalendarChange.Day;                TempCustomizedCalendarChange.Nonworking := BaseCalendarChange.Nonworking;                TempCustomizedCalendarChange."Recurring System" := BaseCalendarChange."Recurring System";                OnCombineBaseCalendarChange(BaseCalendarChange, TempCustomizedCalendarChange);                TempCustomizedCalendarChange.Insert();            until BaseCalendarChange.Next() = 0;    end;    [IntegrationEvent(false, false)]    local procedure OnCombineBaseCalendarChange(BaseCalendarChange: Record "Base Calendar Change"; var CustomizedCalendarChange: record "Customized Calendar Change")    begin    end;    procedure CreateWhereUsedEntries(BaseCalendarCode: Code[10])    var        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        WhereUsedBaseCalendar.DeleteAll();        AddWhereUsedBaseCalendarCompany(BaseCalendarCode);        AddWhereUsedBaseCalendarCustomer(BaseCalendarCode);        AddWhereUsedBaseCalendarLocation(BaseCalendarCode);        AddWhereUsedBaseCalendarVendor(BaseCalendarCode);        AddWhereUsedBaseCalendarShippingAgentServices(BaseCalendarCode);        OnCreateWhereUsedEntries(BaseCalendarCode);        Commit();    end;    [IntegrationEvent(true, false)]    local procedure OnCreateWhereUsedEntries(BaseCalendarCode: code[10])    begin    end;    local procedure AddWhereUsedBaseCalendarCompany(BaseCalendarCode: code[10])    var        CompanyInfo: Record "Company Information";        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        if CompanyInfo.Get() then            if CompanyInfo."Base Calendar Code" = BaseCalendarCode then begin                WhereUsedBaseCalendar.Init();                WhereUsedBaseCalendar."Base Calendar Code" := CompanyInfo."Base Calendar Code";                WhereUsedBaseCalendar."Source Type" := WhereUsedBaseCalendar."Source Type"::Company;                WhereUsedBaseCalendar."Source Name" :=                  CopyStr(CompanyInfo.Name, 1, MaxStrLen(WhereUsedBaseCalendar."Source Name"));                WhereUsedBaseCalendar."Customized Changes Exist" := CustomizedChangesExist(CompanyInfo);                WhereUsedBaseCalendar.Insert();            end;    end;    local procedure AddWhereUsedBaseCalendarCustomer(BaseCalendarCode: code[10])    var        Customer: Record Customer;        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        Customer.SetLoadFields("Base Calendar Code", "Name");        Customer.SetRange("Base Calendar Code", BaseCalendarCode);        if Customer.FindSet() then            repeat                WhereUsedBaseCalendar.Init();                WhereUsedBaseCalendar."Base Calendar Code" := Customer."Base Calendar Code";                WhereUsedBaseCalendar."Source Type" := WhereUsedBaseCalendar."Source Type"::Customer;                WhereUsedBaseCalendar."Source Code" := Customer."No.";                WhereUsedBaseCalendar."Source Name" :=                  CopyStr(Customer.Name, 1, MaxStrLen(WhereUsedBaseCalendar."Source Name"));                WhereUsedBaseCalendar."Customized Changes Exist" := CustomizedChangesExist(Customer);                WhereUsedBaseCalendar.Insert();            until Customer.Next() = 0;    end;    local procedure AddWhereUsedBaseCalendarLocation(BaseCalendarCode: code[10])    var        Location: Record Location;        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        Location.SetLoadFields("Base Calendar Code", "Name");        Location.SetRange("Base Calendar Code", BaseCalendarCode);        if Location.FindSet() then            repeat                WhereUsedBaseCalendar.Init();                WhereUsedBaseCalendar."Base Calendar Code" := Location."Base Calendar Code";                WhereUsedBaseCalendar."Source Type" := WhereUsedBaseCalendar."Source Type"::Location;                WhereUsedBaseCalendar."Source Code" := Location.Code;                WhereUsedBaseCalendar."Source Name" :=                  CopyStr(Location.Name, 1, MaxStrLen(WhereUsedBaseCalendar."Source Name"));                WhereUsedBaseCalendar."Customized Changes Exist" := CustomizedChangesExist(Location);                WhereUsedBaseCalendar.Insert();            until Location.Next() = 0;    end;    local procedure AddWhereUsedBaseCalendarShippingAgentServices(BaseCalendarCode: code[10])    var        ShippingAgentServices: Record "Shipping Agent Services";        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        ShippingAgentServices.SetLoadFields("Base Calendar Code", "Description");        ShippingAgentServices.SetRange("Base Calendar Code", BaseCalendarCode);        if ShippingAgentServices.FindSet() then            repeat                WhereUsedBaseCalendar.Init();                WhereUsedBaseCalendar."Base Calendar Code" := ShippingAgentServices."Base Calendar Code";                WhereUsedBaseCalendar."Source Type" := WhereUsedBaseCalendar."Source Type"::"Shipping Agent";                WhereUsedBaseCalendar."Source Code" := ShippingAgentServices."Shipping Agent Code";                WhereUsedBaseCalendar."Additional Source Code" := ShippingAgentServices.Code;                WhereUsedBaseCalendar."Source Name" :=                  CopyStr(ShippingAgentServices.Description, 1, MaxStrLen(WhereUsedBaseCalendar."Source Name"));                WhereUsedBaseCalendar."Customized Changes Exist" := CustomizedChangesExist(ShippingAgentServices);                WhereUsedBaseCalendar.Insert();            until ShippingAgentServices.Next() = 0;    end;    local procedure AddWhereUsedBaseCalendarVendor(BaseCalendarCode: code[10])    var        Vendor: Record Vendor;        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        Vendor.SetLoadFields("Base Calendar Code", "Name");        Vendor.SetRange("Base Calendar Code", BaseCalendarCode);        if Vendor.FindSet() then            repeat                WhereUsedBaseCalendar.Init();                WhereUsedBaseCalendar."Base Calendar Code" := Vendor."Base Calendar Code";                WhereUsedBaseCalendar."Source Type" := WhereUsedBaseCalendar."Source Type"::Vendor;                WhereUsedBaseCalendar."Source Code" := Vendor."No.";                WhereUsedBaseCalendar."Source Name" :=                  CopyStr(Vendor.Name, 1, MaxStrLen(WhereUsedBaseCalendar."Source Name"));                WhereUsedBaseCalendar."Customized Changes Exist" := CustomizedChangesExist(Vendor);                WhereUsedBaseCalendar.Insert();            until Vendor.Next() = 0;    end;    procedure CustomizedChangesExist(SourceVariant: Variant): Boolean    var        CustomizedCalendarChange: Record "Customized Calendar Change";    begin        FillSource(SourceVariant, CustomizedCalendarChange);        CustomizedCalendarChange.Reset();        CustomizedCalendarChange.SetRange("Source Type", CustomizedCalendarChange."Source Type");        CustomizedCalendarChange.SetRange("Source Code", CustomizedCalendarChange."Source Code");        CustomizedCalendarChange.SetRange("Additional Source Code", CustomizedCalendarChange."Additional Source Code");        CustomizedCalendarChange.SetRange("Base Calendar Code", CustomizedCalendarChange."Base Calendar Code");        exit(not CustomizedCalendarChange.IsEmpty());    end;    procedure CalcDateBOC(OrgDateExpression: Text[30]; OrgDate: Date; CustomCalendarChange: array[2] of Record "Customized Calendar Change"; CheckBothCalendars: Boolean): Date    var        CompanyInfo: Record "Company Information";        CalendarMgt: array[2] of Codeunit "Calendar Management";        DateFormula: DateFormula;        NegDateFormula: DateFormula;        LoopCounter: Integer;        NewDate: Date;        LoopFactor: Integer;        CalConvTimeFrame: Integer;        CalendarChangeNo: Integer;        IsHandled: Boolean;    begin        if not IsOnBeforeCalcDateBOCHandled(CustomCalendarChange, CalConvTimeFrame) then begin            CustomCalendarChange[1].AdjustSourceType();            CustomCalendarChange[2].AdjustSourceType();            if CompanyInfo.Get() then                CalConvTimeFrame := CalcDate(CompanyInfo."Cal. Convergence Time Frame", WorkDate()) - WorkDate();            CustomCalendarChange[1].CalcCalendarCode();            CustomCalendarChange[2].CalcCalendarCode();            OnCalcDateBOCOnAfterGetCalendarCodes(CustomCalendarChange, CalConvTimeFrame);        end;        IsHandled := false;        NewDate := 0D;        OnCalcDateBOCOnBeforeCalcNewDate(OrgDateExpression, OrgDate, CustomCalendarChange, CheckBothCalendars, NewDate, IsHandled);        if IsHandled then            exit(NewDate);        Evaluate(DateFormula, OrgDateExpression);        Evaluate(NegDateFormula, '<-0D>');        if OrgDate = 0D then            OrgDate := WorkDate();        if (CalcDate(DateFormula, OrgDate) >= OrgDate) and (DateFormula <> NegDateFormula) then            LoopFactor := 1        else            LoopFactor := -1;        CalendarChangeNo := 1;        if CheckBothCalendars and (CustomCalendarChange[1]."Base Calendar Code" = '') and (CustomCalendarChange[2]."Base Calendar Code" <> '') then            CalendarChangeNo := 2;        NewDate := OrgDate;        if CalcDate(DateFormula, OrgDate) <> OrgDate then            repeat                NewDate := NewDate + LoopFactor;                CustomCalendarChange[CalendarChangeNo].Date := NewDate;                CalendarMgt[CalendarChangeNo].CheckDateStatus(CustomCalendarChange[CalendarChangeNo]);                OnCalcDateBOCOnAfterCheckDates(CustomCalendarChange[CalendarChangeNo]);                if not CustomCalendarChange[CalendarChangeNo].Nonworking then                    LoopCounter := LoopCounter + 1;                if NewDate >= OrgDate + CalConvTimeFrame then                    LoopCounter := Abs(CalcDate(DateFormula, OrgDate) - OrgDate);                if LoopFactor = -1 then                    if NewDate <= OrgDate - CalConvTimeFrame then                        LoopCounter := Abs(CalcDate(DateFormula, OrgDate) - OrgDate);            until LoopCounter = Abs(CalcDate(DateFormula, OrgDate) - OrgDate);        LoopCounter := 0;        repeat            LoopCounter := LoopCounter + 1;            CalendarMgt[1].IsNonworkingDay(NewDate, CustomCalendarChange[1]);            CalendarMgt[2].IsNonworkingDay(NewDate, CustomCalendarChange[2]);            OnCalcDateBOCOnAfterSetNonworking(CustomCalendarChange);            if CustomCalendarChange[1].Nonworking or CheckBothCalendars and CustomCalendarChange[2].Nonworking then                NewDate := NewDate + LoopFactor            else                exit(NewDate);        until LoopCounter >= CalConvTimeFrame;        exit(NewDate);    end;    procedure CalcDateBOC2(OrgDateExpression: Text[30]; OrgDate: Date; CustomCalendarChange: array[2] of Record "Customized Calendar Change"; CheckBothCalendars: Boolean): Date    var        NewOrgDateExpression: Text[30];    begin        // Use this procedure to subtract time expression.        NewOrgDateExpression := ReverseSign(OrgDateExpression);        exit(CalcDateBOC(NewOrgDateExpression, OrgDate, CustomCalendarChange, CheckBothCalendars));    end;    local procedure ReverseSign(DateFormulaExpr: Text[30]): Text[30]    var        Formula: DateFormula;        NewDateFormulaExpr: Text[30];    begin        Evaluate(Formula, DateFormulaExpr);        NewDateFormulaExpr := ConvertStr(Format(Formula), '+-', '-+');        if not (DateFormulaExpr[1] in ['+', '-']) then            if NewDateFormulaExpr <> '<0D>' then                NewDateFormulaExpr := '-' + NewDateFormulaExpr;        OnAfterReverseSign(DateFormulaExpr, NewDateFormulaExpr);        exit(NewDateFormulaExpr);    end;    procedure CheckDateFormulaPositive(CurrentDateFormula: DateFormula)    begin        if CalcDate(CurrentDateFormula) < Today then            Error(NegativeExprErr, CurrentDateFormula);    end;    procedure CalcTimeDelta(EndingTime: Time; StartingTime: Time) Result: Integer    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcTimeDelta(EndingTime, StartingTime, Result, IsHandled);        if IsHandled then            exit(Result);        Result := EndingTime - StartingTime;        if (Result <> 0) and (EndingTime = 235959T) then            Result += 1000;    end;    procedure CalcTimeSubtract(SubstractTime: Time; SubstractValue: Integer) Result: Time    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCalcTimeSubtract(SubstractTime, SubstractValue, Result, IsHandled);        if IsHandled then            exit;        Result := SubstractTime - SubstractValue;        if (Result <> 000000T) and (SubstractTime = 235959T) and (SubstractValue <> 0) then            Result += 1000;    end;    local procedure IsOnBeforeCalcDateBOCHandled(var CustomCalendarChange: array[2] of Record "Customized Calendar Change"; var CalConvTimeFrame: Integer) IsHandled: Boolean    begin        OnBeforeCalcDateBOC(CustomCalendarChange, CalConvTimeFrame, IsHandled)    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcDateBOC(var CustomCalendarChange: array[2] of Record "Customized Calendar Change"; var CalConvTimeFrame: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterReverseSign(DateFormulaExpr: Text[30]; var NewDateFormulaExpr: Text[30])    begin    end;    procedure DeleteCustomizedBaseCalendarData(SourceType: Enum "Calendar Source Type"; SourceCode: Code[20])    var        CustomizedCalendarChange: Record "Customized Calendar Change";        CustomizedCalendarEntry: Record "Customized Calendar Entry";        WhereUsedBaseCalendar: Record "Where Used Base Calendar";    begin        CustomizedCalendarChange.SetRange("Source Type", SourceType);        CustomizedCalendarChange.SetRange("Source Code", SourceCode);        OnDeleteCustomizedBaseCalendarDataOnAfterFilterCalendarChange(CustomizedCalendarChange);        CustomizedCalendarChange.DeleteAll();        CustomizedCalendarEntry.SetRange("Source Type", SourceType);        CustomizedCalendarEntry.SetRange("Source Code", SourceCode);        OnDeleteCustomizedBaseCalendarDataOnAfterFilterCalendarEntry(CustomizedCalendarEntry);        CustomizedCalendarEntry.DeleteAll();        WhereUsedBaseCalendar.SetRange("Source Type", SourceType);        WhereUsedBaseCalendar.SetRange("Source Code", SourceCode);        OnDeleteCustomizedBaseCalendarDataOnAfterFilterWhereUsedBaseCalendar(WhereUsedBaseCalendar);        WhereUsedBaseCalendar.DeleteAll();    end;    procedure RenameCustomizedBaseCalendarData(SourceType: Enum "Calendar Source Type"; SourceCode: Code[20]; xSourceCode: Code[20])    var        CustomizedCalendarChange: Record "Customized Calendar Change";        TempCustomizedCalendarChange: Record "Customized Calendar Change" temporary;        CustomizedCalendarEntry: Record "Customized Calendar Entry";        TempCustomizedCalendarEntry: Record "Customized Calendar Entry" temporary;        WhereUsedBaseCalendar: Record "Where Used Base Calendar";        TempWhereUsedBaseCalendar: Record "Where Used Base Calendar" temporary;    begin        CustomizedCalendarChange.SetRange("Source Type", SourceType);        CustomizedCalendarChange.SetRange("Source Code", xSourceCode);        if CustomizedCalendarChange.FindSet() then            repeat                TempCustomizedCalendarChange := CustomizedCalendarChange;                TempCustomizedCalendarChange.Insert();            until CustomizedCalendarChange.Next() = 0;        if TempCustomizedCalendarChange.FindSet() then            repeat                Clear(CustomizedCalendarChange);                CustomizedCalendarChange := TempCustomizedCalendarChange;                CustomizedCalendarChange.Rename(                  CustomizedCalendarChange."Source Type",                  SourceCode,                  CustomizedCalendarChange."Additional Source Code",                  CustomizedCalendarChange."Base Calendar Code",                  CustomizedCalendarChange."Recurring System",                  CustomizedCalendarChange.Date,                  CustomizedCalendarChange.Day,                  CustomizedCalendarChange."Entry No.");            until TempCustomizedCalendarChange.Next() = 0;        CustomizedCalendarEntry.SetRange("Source Type", SourceType);        CustomizedCalendarEntry.SetRange("Source Code", xSourceCode);        if CustomizedCalendarEntry.FindSet() then            repeat                TempCustomizedCalendarEntry := CustomizedCalendarEntry;                TempCustomizedCalendarEntry.Insert();            until CustomizedCalendarEntry.Next() = 0;        if TempCustomizedCalendarEntry.FindSet() then            repeat                Clear(CustomizedCalendarEntry);                CustomizedCalendarEntry := TempCustomizedCalendarEntry;                CustomizedCalendarEntry.Rename(                  CustomizedCalendarEntry."Source Type",                  SourceCode,                  CustomizedCalendarEntry."Additional Source Code",                  CustomizedCalendarEntry."Base Calendar Code",                  CustomizedCalendarEntry.Date);            until TempCustomizedCalendarEntry.Next() = 0;        WhereUsedBaseCalendar.SetRange("Source Type", SourceType);        WhereUsedBaseCalendar.SetRange("Source Code", xSourceCode);        if WhereUsedBaseCalendar.FindSet() then            repeat                TempWhereUsedBaseCalendar := WhereUsedBaseCalendar;                TempWhereUsedBaseCalendar.Insert();            until WhereUsedBaseCalendar.Next() = 0;        if TempWhereUsedBaseCalendar.FindSet() then            repeat                Clear(WhereUsedBaseCalendar);                WhereUsedBaseCalendar := TempWhereUsedBaseCalendar;                WhereUsedBaseCalendar.Rename(                  WhereUsedBaseCalendar."Base Calendar Code",                  WhereUsedBaseCalendar."Source Type",                  SourceCode,                  WhereUsedBaseCalendar."Source Name");            until TempWhereUsedBaseCalendar.Next() = 0;    end;    procedure ReverseDateFormula(var ReversedDateFormula: DateFormula; DateFormula: DateFormula)    var        DateFormulaAsText: Text;        ReversedDateFormulaAsText: Text;        SummandPositions: array[100] of Integer;        i: Integer;        j: Integer;    begin        Clear(ReversedDateFormula);        DateFormulaAsText := Format(DateFormula);        if DateFormulaAsText = '' then            exit;        if not (CopyStr(DateFormulaAsText, 1, 1) in ['+', '-']) then            DateFormulaAsText := '+' + DateFormulaAsText;        j := 0;        for i := 1 to StrLen(DateFormulaAsText) do            if DateFormulaAsText[i] in ['+', '-'] then begin                SummandPositions[j + 1] := i;                j += 1;                if DateFormulaAsText[i] = '+' then                    DateFormulaAsText[i] := '-'                else                    DateFormulaAsText[i] := '+';            end;        for i := j downto 1 do            if i = j then                ReversedDateFormulaAsText := CopyStr(DateFormulaAsText, SummandPositions[i])            else                ReversedDateFormulaAsText :=                  ReversedDateFormulaAsText + CopyStr(DateFormulaAsText, SummandPositions[i], SummandPositions[i + 1] - SummandPositions[i]);        Evaluate(ReversedDateFormula, ReversedDateFormulaAsText);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCheckDateStatus(var CustomizedCalendarChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcTimeSubtract(SubstractTime: Time; SubstractValue: Integer; var Result: Time; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckDateStatus(var CustomizedCalendarChange: Record "Customized Calendar Change"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeIsNonworkingDay(var TargetDate: Date; var CustomizedCalendarChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetSourceShippingAgentServices(var ShippingAgentServices: Record "Shipping Agent Services")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcDateBOCOnAfterCheckDates(var CustomCalendarChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcDateBOCOnAfterGetCalendarCodes(var CustomCalendarChange: array[2] of Record "Customized Calendar Change"; var CalConvTimeFrame: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcDateBOCOnAfterSetNonworking(var CustomCalendarChange: array[2] of Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCheckDateStatusAfterDateCustomized(var TargetCustomizedCalendarChange: Record "Customized Calendar Change"; TempCustChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCheckDateStatusOnAfterCombineChanges(var TargetCustomizedCalendarChange: Record "Customized Calendar Change"; var TempCustChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcDateBOCOnBeforeCalcNewDate(var OrgDateExpression: Text[30]; var OrgDate: Date; var CustomCalendarChange: array[2] of Record "Customized Calendar Change"; CheckBothCalendars: Boolean; var NewDate: Date; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteCustomizedBaseCalendarDataOnAfterFilterCalendarChange(var CustomizedCalendarChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteCustomizedBaseCalendarDataOnAfterFilterCalendarEntry(var CustomizedCalendarEntry: Record "Customized Calendar Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnDeleteCustomizedBaseCalendarDataOnAfterFilterWhereUsedBaseCalendar(var WhereUsedBaseCalendar: Record "Where Used Base Calendar")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcTimeDelta(EndingTime: Time; StartingTime: Time; var Result: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeAddCustomizedCalendarChanges(var CustomizedCalendarChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeSetSource(SourceVariant: Variant; var NewCustomizedCalendarChange: Record "Customized Calendar Change")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeAddBaseCalendarChanges(NewCustomizedCalendarChange: Record "Customized Calendar Change"; var TempCustomizedCalendarChange: Record "Customized Calendar Change" temporary; var BaseCalendarChange: Record "Base Calendar Change")    begin    end;}