Codeunit 950 Time Sheet Management

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetManagement.Codeunit.al1,398 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.Projects.TimeSheet;using Microsoft.Assembly.Document;using Microsoft.Foundation.Period;using Microsoft.HumanResources.Absence;using Microsoft.HumanResources.Employee;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Journal;using Microsoft.Projects.Project.Planning;using Microsoft.Projects.Resources.Journal;using Microsoft.Projects.Resources.Resource;using Microsoft.Projects.Resources.Setup;using Microsoft.Utilities;using System.Security.User;using System.Utilities;codeunit 950 "Time Sheet Management"{    Permissions = TableData "Time Sheet Posting Entry" = ri,                  TableData "Job Planning Line" = r,                  TableData Employee = r;    trigger OnRun()    begin    end;    var#pragma warning disable AA0074        Text001: Label 'Mon,Tue,Wed,Thu,Fri,Sat,Sun';#pragma warning disable AA0470        Text002: Label '%1 is already defined as Time Sheet Owner User ID for Resource No. %2 with type %3.', Comment = 'User1 is already defined as Resources for Resource No. LIFT with type Machine.';        Text003: Label 'Time Sheet Header %1 is not found.', Comment = 'Time Sheet Header Archive 10 is not found.';        Text005: Label 'Time Sheet Header Archive %1 is not found.', Comment = 'Time Sheet Header Archive 10 is not found.';#pragma warning restore AA0470#pragma warning restore AA0074        CannotBeGreaterErr: Label 'cannot be greater than %1 %2.', Comment = '%1 - Quantity, %2 - Unit of measure. Example: Quantity cannot be greater than 8 HOUR.';        NoLinesToCopyErr: Label 'There are no time sheet lines to copy.';        CopyLinesQst: Label 'Do you want to copy lines from the previous time sheet (%1)?', Comment = '%1 - number';        JobPlanningLinesNotFoundErr: Label 'Could not find project planning lines.';        CreateLinesQst: Label 'Do you want to create lines from project planning (%1)?', Comment = '%1 - number';        PageDataCaptionTxt: Label '%1 (%2)', Comment = '%1 - start date, %2 - Description,';        CopiedLinesWithClearedCodesMsg: Label 'The work type or cause of absence on %1 copied line(s) no longer exists and was left blank. Review these lines before you submit the time sheet.', Comment = '%1 - number of lines';        NoOfCopiedLinesWithClearedCodes: Integer;    procedure IsUserTimeSheetAdmin(UserId: Text): Boolean    var        UserSetup: Record "User Setup";    begin        if UserSetup.Get(UserId) then            if UserSetup."Time Sheet Admin." then                exit(true);        exit(false);    end;    procedure FilterTimeSheets(var TimeSheetHeader: Record "Time Sheet Header"; FieldNo: Integer)    begin        FilterTimeSheets(TimeSheetHeader, FieldNo, false);    end;    procedure FilterTimeSheets(var TimeSheetHeader: Record "Time Sheet Header"; FieldNo: Integer; ApplyToAdmin: Boolean)    var        UserSetup: Record "User Setup";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFilterTimeSheets(TimeSheetHeader, FieldNo, ApplyToAdmin, IsHandled);        if IsHandled then            exit;        if not ApplyToAdmin then begin            UserSetup.SetLoadFields("Time Sheet Admin.");            if UserSetup.Get(UserId) then;        end;        if ApplyToAdmin or (not UserSetup."Time Sheet Admin.") then begin            TimeSheetHeader.FilterGroup(2);            case FieldNo of                TimeSheetHeader.FieldNo("Owner User ID"):                    TimeSheetHeader.SetRange("Owner User ID", UserId);                TimeSheetHeader.FieldNo("Approver User ID"):                    TimeSheetHeader.SetRange("Approver User ID", UserId);            end;            TimeSheetHeader.FilterGroup(0);        end;    end;    procedure FilterAllTimeSheetLines(var TimeSheetLine: Record "Time Sheet Line"; ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject)    begin        TimeSheetLine.FilterGroup(2);        TimeSheetLine.SetFilter(Type, '<>%1', TimeSheetLine.Type::" ");        TimeSheetLine.FilterGroup(0);        case ActionType of            ActionType::Submit:                TimeSheetLine.SetRange(Status, TimeSheetLine.Status::Open);            ActionType::ReopenSubmitted:                TimeSheetLine.SetFilter(Status, '%1|%2', TimeSheetLine.Status::Submitted, TimeSheetLine.Status::Rejected);            ActionType::Reject,            ActionType::Approve:                TimeSheetLine.SetRange(Status, TimeSheetLine.Status::Submitted);            ActionType::ReopenApproved:                TimeSheetLine.SetFilter(Status, '%1|%2', TimeSheetLine.Status::Approved, TimeSheetLine.Status::Rejected);        end;        OnAfterFilterAllLines(TimeSheetLine, ActionType);    end;    procedure CheckTimeSheetNo(var TimeSheetHeader: Record "Time Sheet Header"; TimeSheetNo: Code[20])    begin        TimeSheetHeader.SetRange("No.", TimeSheetNo);        if TimeSheetHeader.IsEmpty() then            Error(Text003, TimeSheetNo);    end;    procedure SetTimeSheetNo(TimeSheetNo: Code[20]; var TimeSheetLine: Record "Time Sheet Line")    begin        TimeSheetLine.FilterGroup(2);        TimeSheetLine.SetRange("Time Sheet No.", TimeSheetNo);        TimeSheetLine.FilterGroup(0);        TimeSheetLine."Time Sheet No." := TimeSheetNo;    end;    procedure LookupOwnerTimeSheet(var TimeSheetNo: Code[20]; var TimeSheetLine: Record "Time Sheet Line"; var TimeSheetHeader: Record "Time Sheet Header")    var        TimeSheetList: Page "Time Sheet List";    begin        Commit();        if TimeSheetNo <> '' then begin            TimeSheetHeader.Get(TimeSheetNo);            TimeSheetList.SetRecord(TimeSheetHeader);        end;        TimeSheetList.LookupMode := true;        if TimeSheetList.RunModal() = ACTION::LookupOK then begin            TimeSheetList.GetRecord(TimeSheetHeader);            TimeSheetNo := TimeSheetHeader."No.";            SetTimeSheetNo(TimeSheetNo, TimeSheetLine);        end;    end;    procedure LookupApproverTimeSheet(var TimeSheetNo: Code[20]; var TimeSheetLine: Record "Time Sheet Line"; var TimeSheetHeader: Record "Time Sheet Header")    var        ManagerTimeSheetList: Page "Manager Time Sheet List";    begin        Commit();        if TimeSheetNo <> '' then begin            TimeSheetHeader.Get(TimeSheetNo);            ManagerTimeSheetList.SetRecord(TimeSheetHeader);        end;        ManagerTimeSheetList.LookupMode := true;        if ManagerTimeSheetList.RunModal() = ACTION::LookupOK then begin            ManagerTimeSheetList.GetRecord(TimeSheetHeader);            TimeSheetNo := TimeSheetHeader."No.";            SetTimeSheetNo(TimeSheetNo, TimeSheetLine);        end;    end;    procedure FormatDate(Date: Date; DOWFormatType: Option Full,Short): Text[30]    begin        case DOWFormatType of            DOWFormatType::Full:                exit(StrSubstNo('%1 %2', Date2DMY(Date, 1), Format(Date, 0, '<Weekday Text>')));            DOWFormatType::Short:                exit(StrSubstNo('%1 %2', Date2DMY(Date, 1), SelectStr(Date2DWY(Date, 1), Text001)));        end;    end;    procedure CheckAccPeriod(Date: Date)    var        AccountingPeriod: Record "Accounting Period";        IsHandled: Boolean;    begin        OnBeforeCheckAccPeriod(Date, IsHandled);        if IsHandled then            exit;        if AccountingPeriod.IsEmpty() then            exit;        AccountingPeriod.SetFilter("Starting Date", '..%1', Date);        AccountingPeriod.FindLast();        AccountingPeriod.TestField(Closed, false);    end;    procedure CheckResourceTimeSheetOwner(TimeSheetOwnerUserID: Code[50]; CurrResourceNo: Code[20])    var        Resource: Record Resource;    begin        Resource.Reset();        Resource.SetFilter("No.", '<>%1', CurrResourceNo);        Resource.SetRange(Type, Resource.Type::Person);        Resource.SetRange("Time Sheet Owner User ID", TimeSheetOwnerUserID);        if Resource.FindFirst() then            Error(              Text002,              TimeSheetOwnerUserID,              Resource."No.",              Resource.Type);    end;    procedure CalcStatusFactBoxData(var TimeSheetHeader: Record "Time Sheet Header"; var OpenQty: Decimal; var SubmittedQty: Decimal; var RejectedQty: Decimal; var ApprovedQty: Decimal; var PostedQty: Decimal; var TotalQuantity: Decimal)    var        Status: Enum "Time Sheet Status";    begin        TotalQuantity := 0;        TimeSheetHeader.SetRange("Date Filter", TimeSheetHeader."Starting Date", TimeSheetHeader."Ending Date");        OnCalcStatusFactBoxDataOnAfterTimeSheetHeaderSetFilters(TimeSheetHeader);        OpenQty := TimeSheetHeader.CalcQtyWithStatus(Status::Open);        SubmittedQty := TimeSheetHeader.CalcQtyWithStatus(Status::Submitted);        RejectedQty := TimeSheetHeader.CalcQtyWithStatus(Status::Rejected);        ApprovedQty := TimeSheetHeader.CalcQtyWithStatus(Status::Approved);        TimeSheetHeader.SetRange("Status Filter");        TimeSheetHeader.CalcFields(Quantity);        TimeSheetHeader.CalcFields("Posted Quantity");        TotalQuantity := TimeSheetHeader.Quantity;        PostedQty := TimeSheetHeader."Posted Quantity";    end;    procedure CalcActSchedFactBoxData(TimeSheetHeader: Record "Time Sheet Header"; var DateDescription: array[7] of Text[30]; var DateQuantity: array[7] of Text[30]; var TotalQtyText: Text[30]; var TotalPresenceQty: Decimal; var AbsenceQty: Decimal)    var        TotalScheduledQty: Decimal;    begin        CalcActSchedFactBoxData(TimeSheetHeader, DateDescription, DateQuantity, TotalQtyText, TotalPresenceQty, AbsenceQty, TotalScheduledQty);    end;    procedure CalcActSchedFactBoxData(TimeSheetHeader: Record "Time Sheet Header"; var DateDescription: array[7] of Text[30]; var DateQuantity: array[7] of Text[30]; var TotalQtyText: Text[30]; var TotalPresenceQty: Decimal; var AbsenceQty: Decimal; var TotalScheduledQty: Decimal)    var        Resource: Record Resource;        Calendar: Record Date;        i: Integer;    begin        TotalPresenceQty := 0;        TotalScheduledQty := 0;        if Resource.Get(TimeSheetHeader."Resource No.") then begin            Calendar.SetRange("Period Type", Calendar."Period Type"::Date);            Calendar.SetRange("Period Start", TimeSheetHeader."Starting Date", TimeSheetHeader."Ending Date");            if Calendar.FindSet() then                repeat                    i += 1;                    DateDescription[i] := FormatDate(Calendar."Period Start", 0);                    OnCalcActSchedFactBoxDataOnAfterSetDateDescription(TimeSheetHeader, Calendar, DateDescription[i]);                    TimeSheetHeader.SetRange("Date Filter", Calendar."Period Start");                    OnCalcActSchedFactBoxDataOnAfterTimeSheetHeaderSetFilters(TimeSheetHeader, Calendar);                    TimeSheetHeader.CalcFields(Quantity);                    Resource.SetRange("Date Filter", Calendar."Period Start");                    OnCalcActSchedFactBoxDataOnBeforeResouceCalcFields(Resource, Calendar);                    Resource.CalcFields(Capacity);                    DateQuantity[i] := FormatActualSched(TimeSheetHeader.Quantity, Resource.Capacity);                    TotalPresenceQty += TimeSheetHeader.Quantity;                    TotalScheduledQty += Resource.Capacity;                until Calendar.Next() = 0;            TotalQtyText := FormatActualSched(TotalPresenceQty, TotalScheduledQty);            TimeSheetHeader.SetRange("Type Filter", TimeSheetHeader."Type Filter"::Absence);            TimeSheetHeader.SetRange("Date Filter", TimeSheetHeader."Starting Date", TimeSheetHeader."Ending Date");            TimeSheetHeader.CalcFields(Quantity);            AbsenceQty := TimeSheetHeader.Quantity;        end;        OnAfterCalcActSchedFactBoxData(TimeSheetHeader, TotalQtyText, TotalPresenceQty, AbsenceQty);    end;    procedure FormatActualSched(ActualQty: Decimal; ScheduledQty: Decimal): Text[30]    begin        exit(          Format(ActualQty, 0, '<Precision,2:2><Standard Format,0>') + '/' + Format(ScheduledQty, 0, '<Precision,2:2><Standard Format,0>'));    end;    procedure FilterTimeSheetsArchive(var TimeSheetHeaderArchive: Record "Time Sheet Header Archive"; FieldNo: Integer)    var        UserSetup: Record "User Setup";    begin        if UserSetup.Get(UserId) then;        if not UserSetup."Time Sheet Admin." then begin            TimeSheetHeaderArchive.FilterGroup(2);            case FieldNo of                TimeSheetHeaderArchive.FieldNo("Owner User ID"):                    TimeSheetHeaderArchive.SetRange("Owner User ID", UserId);                TimeSheetHeaderArchive.FieldNo("Approver User ID"):                    TimeSheetHeaderArchive.SetRange("Approver User ID", UserId);            end;            TimeSheetHeaderArchive.FilterGroup(0);        end;    end;    procedure CheckTimeSheetArchiveNo(var TimeSheetHeaderArchive: Record "Time Sheet Header Archive"; TimeSheetNo: Code[20])    begin        TimeSheetHeaderArchive.SetRange("No.", TimeSheetNo);        if TimeSheetHeaderArchive.IsEmpty() then            Error(Text005, TimeSheetNo);    end;    procedure GetTimeSheetDataCaption(TimeSheetHeader: Record "Time Sheet Header"): Text    begin        if TimeSheetHeader.Description = '' then            exit(Format(TimeSheetHeader."Starting Date", 0, 4));        exit(StrSubstNo(PageDataCaptionTxt, Format(TimeSheetHeader."Starting Date", 0, 4), TimeSheetHeader.Description));    end;    procedure SetTimeSheetArchiveNo(TimeSheetNo: Code[20]; var TimeSheetLineArchive: Record "Time Sheet Line Archive")    begin        TimeSheetLineArchive.FilterGroup(2);        TimeSheetLineArchive.SetRange("Time Sheet No.", TimeSheetNo);        TimeSheetLineArchive.FilterGroup(0);        TimeSheetLineArchive."Time Sheet No." := TimeSheetNo;    end;    procedure LookupOwnerTimeSheetArchive(var TimeSheetNo: Code[20]; var TimeSheetLineArchive: Record "Time Sheet Line Archive"; var TimeSheetHeaderArchive: Record "Time Sheet Header Archive")    var        TimeSheetArchiveList: Page "Time Sheet Archive List";    begin        Commit();        if TimeSheetNo <> '' then begin            TimeSheetHeaderArchive.Get(TimeSheetNo);            TimeSheetArchiveList.SetRecord(TimeSheetHeaderArchive);        end;        TimeSheetArchiveList.LookupMode := true;        if TimeSheetArchiveList.RunModal() = ACTION::LookupOK then begin            TimeSheetArchiveList.GetRecord(TimeSheetHeaderArchive);            TimeSheetNo := TimeSheetHeaderArchive."No.";            SetTimeSheetArchiveNo(TimeSheetNo, TimeSheetLineArchive);        end;    end;    procedure LookupApproverTimeSheetArchive(var TimeSheetNo: Code[20]; var TimeSheetLineArchive: Record "Time Sheet Line Archive"; var TimeSheetHeaderArchive: Record "Time Sheet Header Archive")    var        ManagerTimeSheetArcList: Page "Manager Time Sheet Arc. List";    begin        Commit();        if TimeSheetNo <> '' then begin            TimeSheetHeaderArchive.Get(TimeSheetNo);            ManagerTimeSheetArcList.SetRecord(TimeSheetHeaderArchive);        end;        ManagerTimeSheetArcList.LookupMode := true;        if ManagerTimeSheetArcList.RunModal() = ACTION::LookupOK then begin            ManagerTimeSheetArcList.GetRecord(TimeSheetHeaderArchive);            TimeSheetNo := TimeSheetHeaderArchive."No.";            SetTimeSheetArchiveNo(TimeSheetNo, TimeSheetLineArchive);        end;    end;    procedure CalcSummaryArcFactBoxData(TimeSheetHeaderArchive: Record "Time Sheet Header Archive"; var DateDescription: array[7] of Text[30]; var DateQuantity: array[7] of Decimal; var TotalQuantity: Decimal; var AbsenceQuantity: Decimal)    var        Calendar: Record Date;        i: Integer;    begin        TotalQuantity := 0;        Calendar.SetRange("Period Type", Calendar."Period Type"::Date);        Calendar.SetRange("Period Start", TimeSheetHeaderArchive."Starting Date", TimeSheetHeaderArchive."Ending Date");        if Calendar.FindSet() then            repeat                i += 1;                DateDescription[i] := FormatDate(Calendar."Period Start", 0);                TimeSheetHeaderArchive.SetRange("Date Filter", Calendar."Period Start");                TimeSheetHeaderArchive.CalcFields(Quantity);                DateQuantity[i] := TimeSheetHeaderArchive.Quantity;                TotalQuantity += TimeSheetHeaderArchive.Quantity;            until Calendar.Next() = 0;        TimeSheetHeaderArchive.SetRange("Type Filter", TimeSheetHeaderArchive."Type Filter"::Absence);        TimeSheetHeaderArchive.SetRange("Date Filter", TimeSheetHeaderArchive."Starting Date", TimeSheetHeaderArchive."Ending Date");        TimeSheetHeaderArchive.CalcFields(Quantity);        AbsenceQuantity := TimeSheetHeaderArchive.Quantity;    end;    procedure MoveTimeSheetToArchive(TimeSheetHeader: Record "Time Sheet Header")    var        TimeSheetLine: Record "Time Sheet Line";        TimeSheetDetail: Record "Time Sheet Detail";        TimeSheetCommentLine: Record "Time Sheet Comment Line";        TimeSheetHeaderArchive: Record "Time Sheet Header Archive";        TimeSheetLineArchive: Record "Time Sheet Line Archive";        TimeSheetDetailArchive: Record "Time Sheet Detail Archive";        TimeSheetCmtLineArchive: Record "Time Sheet Cmt. Line Archive";    begin        TimeSheetHeader.Check();        TimeSheetHeaderArchive.TransferFields(TimeSheetHeader);        OnBeforeTimeSheetHeaderArchiveInsert(TimeSheetHeaderArchive, TimeSheetHeader);        TimeSheetHeaderArchive.Insert();        TimeSheetLine.SetRange("Time Sheet No.", TimeSheetHeader."No.");        if TimeSheetLine.FindSet() then begin            repeat                TimeSheetLineArchive.TransferFields(TimeSheetLine);                OnBeforeTimeSheetLineArchiveInsert(TimeSheetLineArchive, TimeSheetLine);                TimeSheetLineArchive.Insert();            until TimeSheetLine.Next() = 0;            TimeSheetLine.DeleteAll();        end;        TimeSheetDetail.SetRange("Time Sheet No.", TimeSheetHeader."No.");        if TimeSheetDetail.FindSet() then begin            repeat                TimeSheetDetailArchive.TransferFields(TimeSheetDetail);                OnBeforeTimeSheetDetailArchiveInsert(TimeSheetDetailArchive, TimeSheetDetail);                TimeSheetDetailArchive.Insert();            until TimeSheetDetail.Next() = 0;            TimeSheetDetail.DeleteAll();        end;        TimeSheetCommentLine.SetRange("No.", TimeSheetHeader."No.");        if TimeSheetCommentLine.FindSet() then begin            repeat                TimeSheetCmtLineArchive.TransferFields(TimeSheetCommentLine);                OnBeforeTimeSheetCmtLineArchiveInsert(TimeSheetCmtLineArchive, TimeSheetCommentLine);                TimeSheetCmtLineArchive.Insert();            until TimeSheetCommentLine.Next() = 0;            TimeSheetCommentLine.DeleteAll();        end;        TimeSheetHeader.Delete();    end;    procedure CheckTimeSheetLineFieldsVisible(var WorkTypeCodeVisible: Boolean; var JobFieldsVisible: Boolean; var ChargeableVisible: Boolean; var ServiceOrderNoVisible: Boolean; var AbsenceCauseVisible: Boolean; var AssemblyOrderNoVisible: Boolean)    var        Resource: Record Resource;        CauseOfAbsence: Record "Cause of Absence";        Job: Record Job;    begin        OnBeforeCheckTimeSheetLineFieldsVisible(ServiceOrderNoVisible);        AssemblyOrderNoVisible := false;  //not in use for now.        JobFieldsVisible := not Job.IsEmpty;        AbsenceCauseVisible := not CauseOfAbsence.IsEmpty;        ChargeableVisible := JobFieldsVisible or ServiceOrderNoVisible;        WorkTypeCodeVisible := not Resource.IsEmpty or JobFieldsVisible or ServiceOrderNoVisible;        OnAfterCheckTimeSheetLineFieldsVisible(WorkTypeCodeVisible, JobFieldsVisible, ChargeableVisible, ServiceOrderNoVisible, AbsenceCauseVisible, AssemblyOrderNoVisible);    end;    procedure SelectAndCopyTimeSheetLines(ToTimeSheetHeader: Record "Time Sheet Header"; CopyComments: Boolean)    var        TempTimeSheetLine: Record "Time Sheet Line" temporary;        TimeSheetLineArchive: Record "Time Sheet Line Archive";        TimeSheetLines: Page "Time Sheet Lines";        NextLineNo: Integer;        IsArchive: Boolean;    begin        NoOfCopiedLinesWithClearedCodes := 0;        TimeSheetLines.LookupMode := true;        TimeSheetLines.Editable(false);        TimeSheetLines.SetForTimeSheetHeader(ToTimeSheetHeader);        TimeSheetLines.GetData(TempTimeSheetLine, ToTimeSheetHeader."Resource No.", 0D, true, true);        TimeSheetLines.SetRec(TempTimeSheetLine);        if TimeSheetLines.RunModal() <> ACTION::LookupOK then            exit;        TimeSheetLines.SetSelectionFilter(TempTimeSheetLine);        if (TempTimeSheetLine.Count() = 0) then begin            Message(NoLinesToCopyErr);            exit;        end;        NextLineNo := ToTimeSheetHeader.GetLastLineNo();        if TempTimeSheetLine.Count() = 1 then begin            TempTimeSheetLine.FindFirst();            if TempTimeSheetLine.Posted then begin                TimeSheetLineArchive.SetLoadFields("Time Sheet No.", "Line No.");                IsArchive := TimeSheetLineArchive.Get(TempTimeSheetLine."Time Sheet No.", TempTimeSheetLine."Line No.");                if IsArchive then begin                    if not CheckUserWantAllLinesFromOneTimeSheetHeaderArchive(TempTimeSheetLine) then                        exit;                end else                    if not CheckUserWantAllLinesFromOneTimeSheetHeader(TempTimeSheetLine) then                        exit;            end else                if not CheckUserWantAllLinesFromOneTimeSheetHeader(TempTimeSheetLine) then                    exit;        end;        TimeSheetLineArchive.SetLoadFields();        if TempTimeSheetLine.FindSet() then            repeat                if not TempTimeSheetLine.Posted then                    CopyTimeSheetLine(ToTimeSheetHeader, TempTimeSheetLine, CopyComments, NextLineNo)                else begin                    IsArchive := TimeSheetLineArchive.Get(TempTimeSheetLine."Time Sheet No.", TempTimeSheetLine."Line No.");                    if IsArchive then                        CopyTimeSheetLineArchive(ToTimeSheetHeader, TimeSheetLineArchive, CopyComments, NextLineNo)                    else                        CopyTimeSheetLine(ToTimeSheetHeader, TempTimeSheetLine, CopyComments, NextLineNo)                end;            until TempTimeSheetLine.Next() = 0;        SendCopiedLinesWithClearedCodesNotification();    end;    local procedure CheckUserWantAllLinesFromOneTimeSheetHeader(var TempTimeSheetLine: Record "Time Sheet Line" temporary) ContinueProcessing: Boolean    var        TimeSheetLine: Record "Time Sheet Line";        LinesToCopy: Integer;        TimeSheetLineCount: Integer;    begin        ContinueProcessing := true;        TimeSheetLine.SetRange("Time Sheet No.", TempTimeSheetLine."Time Sheet No.");        TimeSheetLine.SetExclusionTypeFilter();        TimeSheetLineCount := TimeSheetLine.Count;        if TimeSheetLineCount > 1 then begin            TimeSheetLine.FindLast();            if TimeSheetLine."Line No." = TempTimeSheetLine."Line No." then begin                LinesToCopy := ConfirmCopyTimeSheetLines(TimeSheetLineCount, TempTimeSheetLine."Time Sheet No.");                if LinesToCopy < 1 then                    exit(false);                if LinesToCopy = 1 then begin //all lines                    TempTimeSheetLine.Reset();                    TempTimeSheetLine.DeleteAll();                    if TimeSheetLine.FindSet() then                        repeat                            TempTimeSheetLine.Init();                            TempTimeSheetLine := TimeSheetLine;                            if TempTimeSheetLine.Insert() then;                        until TimeSheetLine.Next() = 0;                end;            end;        end;    end;    local procedure CheckUserWantAllLinesFromOneTimeSheetHeaderArchive(var TempTimeSheetLine: Record "Time Sheet Line" temporary) ContinueProcessing: Boolean    var        TimeSheetLineArchive: Record "Time Sheet Line Archive";        LinesToCopy: Integer;        TimeSheetLineCount: Integer;    begin        ContinueProcessing := true;        TimeSheetLineArchive.SetRange("Time Sheet No.", TempTimeSheetLine."Time Sheet No.");        TimeSheetLineArchive.SetExclusionTypeFilter();        TimeSheetLineCount := TimeSheetLineArchive.Count;        if TimeSheetLineCount > 1 then begin            TimeSheetLineArchive.FindLast();            if TimeSheetLineArchive."Line No." = TempTimeSheetLine."Line No." then begin                LinesToCopy := ConfirmCopyTimeSheetLines(TimeSheetLineCount, TempTimeSheetLine."Time Sheet No.");                if LinesToCopy < 1 then                    exit(false);                if LinesToCopy = 1 then begin //all lines                    TempTimeSheetLine.Reset();                    TempTimeSheetLine.DeleteAll();                    if TimeSheetLineArchive.FindSet() then                        repeat                            TempTimeSheetLine.Init();                            TempTimeSheetLine.TransferFields(TimeSheetLineArchive);                            if TempTimeSheetLine.Insert() then;                        until TimeSheetLineArchive.Next() = 0;                end;            end;        end;    end;    local procedure ConfirmCopyTimeSheetLines(TimeSheetLineCount: Integer; TimeSheetNo: Code[20]): Integer    var        SelectLineConfirmTxt: Label 'All lines,Selected line';        StrMenuInstructionTxt: Label 'You selected just 1 of %1 lines from Time Sheet %2. Do you want to copy:', Comment = '%1 - Lines count, %2 - Time Sheet No.';    begin        exit(Dialog.StrMenu(SelectLineConfirmTxt, 2, StrSubstNo(StrMenuInstructionTxt, TimeSheetLineCount, TimeSheetNo)));    end;    procedure CheckCopyPrevTimeSheetLines(TimeSheetHeader: Record "Time Sheet Header")    var        QtyToBeCopied: Integer;    begin        QtyToBeCopied := CalcPrevTimeSheetLines(TimeSheetHeader);        if QtyToBeCopied = 0 then            Message(NoLinesToCopyErr)        else            if Confirm(CopyLinesQst, true, QtyToBeCopied) then                CopyPrevTimeSheetLines(TimeSheetHeader);    end;    procedure CopyPrevTimeSheetLines(ToTimeSheetHeader: Record "Time Sheet Header")    var        FromTimeSheetHeader: Record "Time Sheet Header";        FromTimeSheetLine: Record "Time Sheet Line";        LineNo: Integer;        IsHandled: Boolean;    begin        NoOfCopiedLinesWithClearedCodes := 0;        LineNo := ToTimeSheetHeader.GetLastLineNo();        FromTimeSheetHeader.Get(ToTimeSheetHeader."No.");        FromTimeSheetHeader.SetCurrentKey("Resource No.", "Starting Date");        FromTimeSheetHeader.SetRange("Resource No.", ToTimeSheetHeader."Resource No.");        if FromTimeSheetHeader.Next(-1) <> 0 then begin            FromTimeSheetLine.SetRange("Time Sheet No.", FromTimeSheetHeader."No.");            FromTimeSheetLine.SetExclusionTypeFilter();            if FromTimeSheetLine.FindSet() then                repeat                    IsHandled := false;                    OnCopyPrevTimeSheetLinesOnBeforeCopyLine(FromTimeSheetLine, IsHandled);                    if not IsHandled then                        CopyTimeSheetLine(ToTimeSheetHeader, FromTimeSheetLine, false, LineNo);                until FromTimeSheetLine.Next() = 0;        end;        SendCopiedLinesWithClearedCodesNotification();        OnAfterCopyPrevTimeSheetLines();    end;    local procedure CopyTimeSheetLine(ToTimeSheetHeader: Record "Time Sheet Header"; FromTimeSheetLine: Record "Time Sheet Line"; CopyComments: Boolean; var NextLineNo: Integer)    var        ToTimeSheetLine: Record "Time Sheet Line";        IsHandled: Boolean;        CauseOfAbsenceCleared: Boolean;        WorkTypeCleared: Boolean;    begin        IsHandled := false;        OnBeforeCopyTimeSheetLine(ToTimeSheetHeader, FromTimeSheetLine, CopyComments, NextLineNo, IsHandled);        if not IsHandled then begin            NextLineNo := NextLineNo + 10000;            ToTimeSheetLine.Init();            ToTimeSheetLine."Time Sheet No." := ToTimeSheetHeader."No.";            ToTimeSheetLine."Line No." := NextLineNo;            ToTimeSheetLine."Time Sheet Starting Date" := ToTimeSheetHeader."Starting Date";            ToTimeSheetLine.Type := FromTimeSheetLine.Type;            if ToTimeSheetLine.Type = ToTimeSheetLine.Type::Job then begin                ToTimeSheetLine.Validate("Job No.", FromTimeSheetLine."Job No.");                ToTimeSheetLine.Validate("Job Task No.", FromTimeSheetLine."Job Task No.");            end;            CopyExistingCauseOfAbsenceAndWorkType(ToTimeSheetLine, FromTimeSheetLine."Cause of Absence Code", FromTimeSheetLine."Work Type Code", CauseOfAbsenceCleared, WorkTypeCleared);            ToTimeSheetLine.Description := FromTimeSheetLine.Description;            ToTimeSheetLine.Chargeable := FromTimeSheetLine.Chargeable;            OnBeforeToTimeSheetLineInsert(ToTimeSheetLine, FromTimeSheetLine);            ToTimeSheetLine.Insert();            CountCopiedLineWithClearedCodes(ToTimeSheetLine, CauseOfAbsenceCleared, WorkTypeCleared);            CopyTimeSheetLineDetails(ToTimeSheetLine, FromTimeSheetLine);            if CopyComments then                CopyTimeSheetLineComments(ToTimeSheetLine, FromTimeSheetLine);        end;    end;    local procedure CopyTimeSheetLineDetails(ToTimeSheetLine: Record "Time Sheet Line"; FromTimeSheetLine: Record "Time Sheet Line")    var        ToTimeSheetDetail: Record "Time Sheet Detail";        FromTimeSheetDetail: Record "Time Sheet Detail";        IsHandled: Boolean;    begin        FromTimeSheetDetail.SetRange("Time Sheet No.", FromTimeSheetLine."Time Sheet No.");        FromTimeSheetDetail.SetRange("Time Sheet Line No.", FromTimeSheetLine."Line No.");        if FromTimeSheetDetail.FindSet() then            repeat                ToTimeSheetDetail.Init();                ToTimeSheetDetail.TransferFields(FromTimeSheetDetail);                ToTimeSheetDetail."Time Sheet No." := ToTimeSheetLine."Time Sheet No.";                ToTimeSheetDetail."Time Sheet Line No." := ToTimeSheetLine."Line No.";                ToTimeSheetDetail.Date := ToTimeSheetLine."Time Sheet Starting Date" + (FromTimeSheetDetail."Date" - FromTimeSheetLine."Time Sheet Starting Date");                ToTimeSheetDetail.Status := "Time Sheet Status"::Open;                ToTimeSheetDetail.Posted := false;                ToTimeSheetDetail."Posted Quantity" := 0;                IsHandled := false;                OnBeforeTimeSheetDetailInsert(ToTimeSheetDetail, FromTimeSheetDetail, IsHandled);                if not IsHandled then                    ToTimeSheetDetail.Insert();            until FromTimeSheetDetail.Next() = 0;    end;    local procedure CopyTimeSheetLineComments(ToTimeSheetLine: Record "Time Sheet Line"; FromTimeSheetLine: Record "Time Sheet Line")    var        ToTimeSheetCommentLine: Record "Time Sheet Comment Line";        FromTimeSheetCommentLine: Record "Time Sheet Comment Line";    begin        FromTimeSheetCommentLine.SetRange("No.", FromTimeSheetLine."Time Sheet No.");        FromTimeSheetCommentLine.SetRange("Time Sheet Line No.", FromTimeSheetLine."Line No.");        if FromTimeSheetCommentLine.FindSet() then            repeat                ToTimeSheetCommentLine.Init();                ToTimeSheetCommentLine.TransferFields(FromTimeSheetCommentLine);                ToTimeSheetCommentLine."No." := ToTimeSheetLine."Time Sheet No.";                ToTimeSheetCommentLine."Time Sheet Line No." := ToTimeSheetLine."Line No.";                ToTimeSheetCommentLine.Insert();            until FromTimeSheetCommentLine.Next() = 0;    end;    local procedure CopyTimeSheetLineArchive(ToTimeSheetHeader: Record "Time Sheet Header"; FromTimeSheetLineArchive: Record "Time Sheet Line Archive"; CopyComments: Boolean; var NextLineNo: Integer)    var        ToTimeSheetLine: Record "Time Sheet Line";        IsHandled: Boolean;        CauseOfAbsenceCleared: Boolean;        WorkTypeCleared: Boolean;    begin        IsHandled := false;        OnBeforeCopyTimeSheetLineArchive(ToTimeSheetHeader, FromTimeSheetLineArchive, CopyComments, NextLineNo, IsHandled);        if not IsHandled then begin            NextLineNo := NextLineNo + 10000;            ToTimeSheetLine.Init();            ToTimeSheetLine."Time Sheet No." := ToTimeSheetHeader."No.";            ToTimeSheetLine."Line No." := NextLineNo;            ToTimeSheetLine."Time Sheet Starting Date" := ToTimeSheetHeader."Starting Date";            ToTimeSheetLine.Type := FromTimeSheetLineArchive.Type;            if ToTimeSheetLine.Type = ToTimeSheetLine.Type::Job then begin                ToTimeSheetLine.Validate("Job No.", FromTimeSheetLineArchive."Job No.");                ToTimeSheetLine.Validate("Job Task No.", FromTimeSheetLineArchive."Job Task No.");            end;            CopyExistingCauseOfAbsenceAndWorkType(ToTimeSheetLine, FromTimeSheetLineArchive."Cause of Absence Code", FromTimeSheetLineArchive."Work Type Code", CauseOfAbsenceCleared, WorkTypeCleared);            ToTimeSheetLine.Description := FromTimeSheetLineArchive.Description;            ToTimeSheetLine.Chargeable := FromTimeSheetLineArchive.Chargeable;            OnCopyTimeSheetLineArchiveOnBeforeToTimeSheetLineInsert(ToTimeSheetLine, FromTimeSheetLineArchive);            ToTimeSheetLine.Insert();            CountCopiedLineWithClearedCodes(ToTimeSheetLine, CauseOfAbsenceCleared, WorkTypeCleared);            CopyTimeSheetLineArchiveDetails(ToTimeSheetLine, FromTimeSheetLineArchive);            if CopyComments then                CopyTimeSheetLineArchiveComments(ToTimeSheetLine, FromTimeSheetLineArchive);        end;    end;    local procedure CopyTimeSheetLineArchiveDetails(ToTimeSheetLine: Record "Time Sheet Line"; FromTimeSheetLineArchive: Record "Time Sheet Line Archive")    var        ToTimeSheetDetail: Record "Time Sheet Detail";        FromTimeSheetDetailArchive: Record "Time Sheet Detail Archive";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCopyTimeSheetLineArchiveDetails(FromTimeSheetLineArchive, ToTimeSheetLine, IsHandled);        if IsHandled then            exit;        FromTimeSheetDetailArchive.SetRange("Time Sheet No.", FromTimeSheetLineArchive."Time Sheet No.");        FromTimeSheetDetailArchive.SetRange("Time Sheet Line No.", FromTimeSheetLineArchive."Line No.");        if FromTimeSheetDetailArchive.FindSet() then            repeat                ToTimeSheetDetail.Init();                ToTimeSheetDetail.TransferFields(FromTimeSheetDetailArchive);                ToTimeSheetDetail."Time Sheet No." := ToTimeSheetLine."Time Sheet No.";                ToTimeSheetDetail."Time Sheet Line No." := ToTimeSheetLine."Line No.";                ToTimeSheetDetail.Date := ToTimeSheetLine."Time Sheet Starting Date" + (FromTimeSheetDetailArchive."Date" - FromTimeSheetLineArchive."Time Sheet Starting Date");                ToTimeSheetDetail.Status := "Time Sheet Status"::Open;                ToTimeSheetDetail.Posted := false;                ToTimeSheetDetail."Posted Quantity" := 0;                ToTimeSheetDetail.Insert();            until FromTimeSheetDetailArchive.Next() = 0;    end;    local procedure CopyTimeSheetLineArchiveComments(ToTimeSheetLine: Record "Time Sheet Line"; FromTimeSheetLineArchive: Record "Time Sheet Line Archive")    var        ToTimeSheetCommentLine: Record "Time Sheet Comment Line";        TimeSheetCmtLineArchive: Record "Time Sheet Cmt. Line Archive";    begin        TimeSheetCmtLineArchive.SetRange("No.", FromTimeSheetLineArchive."Time Sheet No.");        TimeSheetCmtLineArchive.SetRange("Time Sheet Line No.", FromTimeSheetLineArchive."Line No.");        if TimeSheetCmtLineArchive.FindSet() then            repeat                ToTimeSheetCommentLine.Init();                ToTimeSheetCommentLine.TransferFields(TimeSheetCmtLineArchive);                ToTimeSheetCommentLine."No." := ToTimeSheetLine."Time Sheet No.";                ToTimeSheetCommentLine."Time Sheet Line No." := ToTimeSheetLine."Line No.";                ToTimeSheetCommentLine.Insert();            until TimeSheetCmtLineArchive.Next() = 0;    end;    local procedure CopyExistingCauseOfAbsenceAndWorkType(var ToTimeSheetLine: Record "Time Sheet Line"; CauseOfAbsenceCode: Code[10]; WorkTypeCode: Code[10]; var CauseOfAbsenceCleared: Boolean; var WorkTypeCleared: Boolean)    var        CauseOfAbsence: Record "Cause of Absence";        WorkType: Record "Work Type";    begin        if (ToTimeSheetLine.Type = ToTimeSheetLine.Type::Absence) and (CauseOfAbsenceCode <> '') then begin            CauseOfAbsence.SetRange(Code, CauseOfAbsenceCode);            CauseOfAbsenceCleared := CauseOfAbsence.IsEmpty();            if not CauseOfAbsenceCleared then                ToTimeSheetLine.Validate("Cause of Absence Code", CauseOfAbsenceCode);        end;        if WorkTypeCode <> '' then begin            WorkType.SetRange(Code, WorkTypeCode);            WorkTypeCleared := WorkType.IsEmpty();            if not WorkTypeCleared then                ToTimeSheetLine."Work Type Code" := WorkTypeCode;        end;    end;    local procedure CountCopiedLineWithClearedCodes(ToTimeSheetLine: Record "Time Sheet Line"; CauseOfAbsenceCleared: Boolean; WorkTypeCleared: Boolean)    begin        // Subscribers to the insert events may have filled in the cleared values        if (CauseOfAbsenceCleared and (ToTimeSheetLine."Cause of Absence Code" = '')) or           (WorkTypeCleared and (ToTimeSheetLine."Work Type Code" = ''))        then            NoOfCopiedLinesWithClearedCodes += 1;    end;    local procedure SendCopiedLinesWithClearedCodesNotification()    var        CopiedLinesNotification: Notification;    begin        if NoOfCopiedLinesWithClearedCodes = 0 then            exit;        CopiedLinesNotification.Id := GetCopiedLinesWithClearedCodesNotificationId();        CopiedLinesNotification.Message := StrSubstNo(CopiedLinesWithClearedCodesMsg, NoOfCopiedLinesWithClearedCodes);        CopiedLinesNotification.Scope := NotificationScope::LocalScope;        CopiedLinesNotification.Send();    end;    local procedure GetCopiedLinesWithClearedCodesNotificationId(): Guid    begin        exit('d23bcf27-786e-4dd4-9185-2cedc5475b30');    end;    procedure CalcPrevTimeSheetLines(ToTimeSheetHeader: Record "Time Sheet Header") LinesQty: Integer    var        TimeSheetHeader: Record "Time Sheet Header";        TimeSheetLine: Record "Time Sheet Line";    begin        TimeSheetHeader.Get(ToTimeSheetHeader."No.");        TimeSheetHeader.SetCurrentKey("Resource No.", "Starting Date");        TimeSheetHeader.SetRange("Resource No.", ToTimeSheetHeader."Resource No.");        if TimeSheetHeader.Next(-1) <> 0 then begin            TimeSheetLine.SetRange("Time Sheet No.", TimeSheetHeader."No.");            TimeSheetLine.SetExclusionTypeFilter();            LinesQty := TimeSheetLine.Count();        end;    end;    procedure CheckCreateLinesFromJobPlanning(TimeSheetHeader: Record "Time Sheet Header"): Integer    var        QtyToBeCreated: Integer;    begin        QtyToBeCreated := CalcLinesFromJobPlanning(TimeSheetHeader);        if QtyToBeCreated = 0 then            Message(JobPlanningLinesNotFoundErr)        else            if Confirm(CreateLinesQst, true, QtyToBeCreated) then                exit(CreateLinesFromJobPlanning(TimeSheetHeader));    end;    procedure CreateLinesFromJobPlanning(TimeSheetHeader: Record "Time Sheet Header") CreatedLinesQty: Integer    var        TimeSheetLine: Record "Time Sheet Line";        TempJobPlanningLine: Record "Job Planning Line" temporary;        LineNo: Integer;    begin        LineNo := TimeSheetHeader.GetLastLineNo();        FillJobPlanningBuffer(TimeSheetHeader, TempJobPlanningLine);        TempJobPlanningLine.Reset();        if TempJobPlanningLine.FindSet() then            repeat                LineNo := LineNo + 10000;                CreatedLinesQty := CreatedLinesQty + 1;                TimeSheetLine.Init();                TimeSheetLine."Time Sheet No." := TimeSheetHeader."No.";                TimeSheetLine."Line No." := LineNo;                TimeSheetLine."Time Sheet Starting Date" := TimeSheetHeader."Starting Date";                TimeSheetLine.Validate(Type, TimeSheetLine.Type::Job);                TimeSheetLine.Validate("Job No.", TempJobPlanningLine."Job No.");                TimeSheetLine.Validate("Job Task No.", TempJobPlanningLine."Job Task No.");                OnCreateLinesFromJobPlanningOnBeforeTimeSheetLineInsert(TimeSheetLine, TempJobPlanningLine);                TimeSheetLine.Insert();            until TempJobPlanningLine.Next() = 0;    end;    procedure CalcLinesFromJobPlanning(TimeSheetHeader: Record "Time Sheet Header"): Integer    var        TempJobPlanningLine: Record "Job Planning Line" temporary;    begin        FillJobPlanningBuffer(TimeSheetHeader, TempJobPlanningLine);        exit(TempJobPlanningLine.Count);    end;    local procedure FillJobPlanningBuffer(TimeSheetHeader: Record "Time Sheet Header"; var JobPlanningLineBuffer: Record "Job Planning Line")    var        JobPlanningLine: Record "Job Planning Line";        SkipLine: Boolean;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeFillJobPlanningBuffer(JobPlanningLine, JobPlanningLineBuffer, TimeSheetHeader, IsHandled);        if IsHandled then            exit;        JobPlanningLine.SetRange(Type, JobPlanningLine.Type::Resource);        JobPlanningLine.SetRange("No.", TimeSheetHeader."Resource No.");        JobPlanningLine.SetRange("Planning Date", TimeSheetHeader."Starting Date", TimeSheetHeader."Ending Date");        if JobPlanningLine.FindSet() then            repeat                SkipLine := TimesheetLineWithJobPlanningLineExists(TimeSheetHeader, JobPlanningLine);                if not SkipLine then                    SkipLine := JobPlanningLineIsNotValidForTimesheetLine(JobPlanningLine);                OnCheckInsertJobPlanningLine(JobPlanningLine, JobPlanningLineBuffer, SkipLine);                if not SkipLine then begin                    JobPlanningLineBuffer.SetRange("Job No.", JobPlanningLine."Job No.");                    JobPlanningLineBuffer.SetRange("Job Task No.", JobPlanningLine."Job Task No.");                    if JobPlanningLineBuffer.IsEmpty() then begin                        JobPlanningLineBuffer."Job No." := JobPlanningLine."Job No.";                        JobPlanningLineBuffer."Job Task No." := JobPlanningLine."Job Task No.";                        OnFillJobPlanningBufferOnBeforeJobPlanningLineBufferInsert(JobPlanningLine, JobPlanningLineBuffer);                        JobPlanningLineBuffer.Insert();                    end;                end;            until JobPlanningLine.Next() = 0;        JobPlanningLineBuffer.Reset();    end;    local procedure TimesheetLineWithJobPlanningLineExists(TimeSheetHeader: Record "Time Sheet Header"; JobPlanningLine: Record "Job Planning Line"): Boolean    var        TimeSheetLine: Record "Time Sheet Line";    begin        TimeSheetLine.SetRange("Time Sheet No.", TimeSheetHeader."No.");        TimeSheetLine.SetRange(Type, TimeSheetLine.Type::Job);        TimeSheetLine.SetRange("Job No.", JobPlanningLine."Job No.");        TimeSheetLine.SetRange("Job Task No.", JobPlanningLine."Job Task No.");        exit(not TimeSheetLine.IsEmpty());    end;    local procedure JobPlanningLineIsNotValidForTimesheetLine(JobPlanningLine: Record "Job Planning Line"): Boolean    var        Job: Record Job;    begin        if JobPlanningLine."Job No." = '' then            exit(true);        if not Job.Get(JobPlanningLine."Job No.") then            exit(true);        if (Job.Blocked = Job.Blocked::All) or (Job.Status = Job.Status::Completed) then            exit(true);        exit(false);    end;    procedure FindTimeSheet(var TimeSheetHeader: Record "Time Sheet Header"; Which: Option Prev,Next): Code[20]    begin        TimeSheetHeader.Reset();        TimeSheetHeader.SetCurrentKey("Resource No.", "Starting Date");        TimeSheetHeader.SetRange("Resource No.", TimeSheetHeader."Resource No.");        case Which of            Which::Prev:                TimeSheetHeader.Next(-1);            Which::Next:                TimeSheetHeader.Next(1);        end;        exit(TimeSheetHeader."No.");    end;    procedure FindTimeSheetArchive(var TimeSheetHeaderArchive: Record "Time Sheet Header Archive"; Which: Option Prev,Next): Code[20]    begin        TimeSheetHeaderArchive.Reset();        TimeSheetHeaderArchive.SetCurrentKey("Resource No.", "Starting Date");        TimeSheetHeaderArchive.SetRange("Resource No.", TimeSheetHeaderArchive."Resource No.");        OnFindTimeSheetArchiveOnAfterSetFilters(TimeSheetHeaderArchive);        case Which of            Which::Prev:                TimeSheetHeaderArchive.Next(-1);            Which::Next:                TimeSheetHeaderArchive.Next(1);        end;        exit(TimeSheetHeaderArchive."No.");    end;    procedure GetDateFilter(StartingDate: Date; EndingDate: Date) DateFilter: Text[30]    var        Date: Record Date;    begin        if StartingDate = 0D then begin            Date.FindFirst();            StartingDate := Date."Period Start";        end;        if EndingDate = 0D then begin            Date.FindLast();            EndingDate := Date."Period Start";        end;        DateFilter := StrSubstNo('%1..%2', StartingDate, EndingDate);    end;    procedure CreateTSLineFromDocLine(TableID: Integer; ResourceNo: Code[20]; PostingDate: Date; DocumentNo: Code[20]; OrderNo: Code[20]; OrderLineNo: Integer; WorkTypeCode: Code[10]; Chargbl: Boolean; Desc: Text[100]; Quantity: Decimal)    var        Resource: Record Resource;        TimeSheetHeader: Record "Time Sheet Header";        TimeSheetLine: Record "Time Sheet Line";        TimeSheetDetail: Record "Time Sheet Detail";        LineNo: Integer;    begin        Resource.Get(ResourceNo);        if not Resource."Use Time Sheet" then            exit;        TimeSheetHeader.SetRange("Resource No.", Resource."No.");        TimeSheetHeader.SetFilter("Starting Date", '..%1', PostingDate);        TimeSheetHeader.SetFilter("Ending Date", '%1..', PostingDate);        TimeSheetHeader.FindFirst();        TimeSheetLine.SetRange("Time Sheet No.", TimeSheetHeader."No.");        if TimeSheetLine.FindLast() then;        LineNo := TimeSheetLine."Line No." + 10000;        TimeSheetLine.Init();        TimeSheetLine."Time Sheet No." := TimeSheetHeader."No.";        TimeSheetLine."Line No." := LineNo;        TimeSheetLine."Time Sheet Starting Date" := TimeSheetHeader."Starting Date";        case TableID of            DATABASE::"Assembly Line":                begin                    TimeSheetLine.Type := TimeSheetLine.Type::"Assembly Order";                    TimeSheetLine."Assembly Order No." := OrderNo;                    TimeSheetLine."Assembly Order Line No." := OrderLineNo;                end;        end;        TimeSheetLine.Description := Desc;        TimeSheetLine."Work Type Code" := WorkTypeCode;        TimeSheetLine.Chargeable := Chargbl;        TimeSheetLine."Approver ID" := TimeSheetHeader."Approver User ID";        TimeSheetLine."Approved By" := CopyStr(UserId(), 1, MaxStrLen(TimeSheetLine."Approved By"));        TimeSheetLine."Approval Date" := Today();        TimeSheetLine.Status := TimeSheetLine.Status::Approved;        TimeSheetLine.Posted := true;        OnCreateTSLineFromDocLineOnBeforeTimeSheetLineInsert(TimeSheetLine, TableID, OrderNo, OrderLineNo);        TimeSheetLine.Insert();        TimeSheetDetail.Init();        TimeSheetDetail.CopyFromTimeSheetLine(TimeSheetLine);        TimeSheetDetail.Date := PostingDate;        TimeSheetDetail.Quantity := Quantity;        TimeSheetDetail."Posted Quantity" := Quantity;        TimeSheetDetail.Posted := true;        TimeSheetDetail.Insert();        CreateTSPostingEntry(TimeSheetDetail, Quantity, PostingDate, DocumentNo, TimeSheetLine.Description);    end;    procedure CreateTSLineFromAssemblyLine(AssemblyHeader: Record "Assembly Header"; AssemblyLine: Record "Assembly Line"; Qty: Decimal)    begin        AssemblyLine.TestField(Type, AssemblyLine.Type::Resource);        CreateTSLineFromDocLine(            DATABASE::"Assembly Line",            AssemblyLine."No.",            AssemblyHeader."Posting Date",            AssemblyHeader."Posting No.",            AssemblyLine."Document No.",            AssemblyLine."Line No.",            '',            true,            AssemblyLine.Description,            Qty);    end;    procedure CreateTSPostingEntry(TimeSheetDetail: Record "Time Sheet Detail"; Qty: Decimal; PostingDate: Date; DocumentNo: Code[20]; Desc: Text[100])    var        TimeSheetPostingEntry: Record "Time Sheet Posting Entry";    begin        TimeSheetPostingEntry.Init();        TimeSheetPostingEntry."Time Sheet No." := TimeSheetDetail."Time Sheet No.";        TimeSheetPostingEntry."Time Sheet Line No." := TimeSheetDetail."Time Sheet Line No.";        TimeSheetPostingEntry."Time Sheet Date" := TimeSheetDetail.Date;        TimeSheetPostingEntry.Quantity := Qty;        TimeSheetPostingEntry."Document No." := DocumentNo;        TimeSheetPostingEntry."Posting Date" := PostingDate;        TimeSheetPostingEntry.Description := Desc;        TimeSheetPostingEntry.Insert();        OnAfterCreateTSPostingEntry(TimeSheetDetail, TimeSheetPostingEntry);    end;    procedure CheckTSLineDetailPosting(TimeSheetNo: Code[20]; TimeSheetLineNo: Integer; TimeSheetDate: Date; QtyToPost: Decimal; QtyPerUnitOfMeasure: Decimal; var MaxAvailableQty: Decimal): Boolean    var        TimeSheetDetail: Record "Time Sheet Detail";        MaxAvailableQtyBase: Decimal;    begin        TimeSheetDetail.Get(TimeSheetNo, TimeSheetLineNo, TimeSheetDate);        TimeSheetDetail.TestField(Status, TimeSheetDetail.Status::Approved);        TimeSheetDetail.TestField(Posted, false);        MaxAvailableQtyBase := TimeSheetDetail.GetMaxQtyToPost();        MaxAvailableQty := MaxAvailableQtyBase * QtyPerUnitOfMeasure;        exit(QtyToPost <= MaxAvailableQty);    end;    procedure CheckResJnlLine(ResJnlLine: Record "Res. Journal Line")    var        MaxAvailableQty: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckResJnlLine(ResJnlLine, IsHandled);        if IsHandled then            exit;        ResJnlLine.TestField("Qty. per Unit of Measure");        if not CheckTSLineDetailPosting(             ResJnlLine."Time Sheet No.",             ResJnlLine."Time Sheet Line No.",             ResJnlLine."Time Sheet Date",             ResJnlLine.Quantity,             ResJnlLine."Qty. per Unit of Measure",             MaxAvailableQty)        then            ResJnlLine.FieldError(Quantity, StrSubstNo(CannotBeGreaterErr, MaxAvailableQty, ResJnlLine."Unit of Measure Code"));    end;    procedure CheckJobJnlLine(JobJnlLine: Record "Job Journal Line")    var        MaxAvailableQty: Decimal;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckJobJnlLine(JobJnlLine, IsHandled);        if IsHandled then            exit;        JobJnlLine.TestField("Qty. per Unit of Measure");        if not CheckTSLineDetailPosting(             JobJnlLine."Time Sheet No.",             JobJnlLine."Time Sheet Line No.",             JobJnlLine."Time Sheet Date",             JobJnlLine.Quantity,             JobJnlLine."Qty. per Unit of Measure",             MaxAvailableQty)        then            JobJnlLine.FieldError(Quantity, StrSubstNo(CannotBeGreaterErr, MaxAvailableQty, JobJnlLine."Unit of Measure Code"));    end;    procedure CopyFilteredTimeSheetLinesToBuffer(var TimeSheetLineFrom: Record "Time Sheet Line"; var TimeSheetLineTo: Record "Time Sheet Line")    begin        if TimeSheetLineFrom.FindSet() then            repeat                TimeSheetLineTo := TimeSheetLineFrom;                TimeSheetLineTo.Insert();            until TimeSheetLineFrom.Next() = 0;    end;    procedure UpdateTimeAllocation(TimeSheetLine: Record "Time Sheet Line"; AllocatedQty: array[7] of Decimal)    var        TimeSheetHeader: Record "Time Sheet Header";        TimeSheetDetail: Record "Time Sheet Detail";        TimeSheetDate: Date;        i: Integer;    begin        TimeSheetHeader.Get(TimeSheetLine."Time Sheet No.");        for i := 1 to 7 do begin            TimeSheetDate := TimeSheetHeader."Starting Date" + i - 1;            if AllocatedQty[i] <> 0 then begin                if TimeSheetDetail.Get(TimeSheetLine."Time Sheet No.", TimeSheetLine."Line No.", TimeSheetDate) then begin                    TimeSheetDetail.Quantity := AllocatedQty[i];                    TimeSheetDetail."Posted Quantity" := TimeSheetDetail.Quantity;                    TimeSheetDetail.Modify();                end else begin                    TimeSheetDetail.Init();                    TimeSheetDetail.CopyFromTimeSheetLine(TimeSheetLine);                    TimeSheetDetail.Posted := true;                    TimeSheetDetail.Date := TimeSheetDate;                    TimeSheetDetail.Quantity := AllocatedQty[i];                    TimeSheetDetail."Posted Quantity" := TimeSheetDetail.Quantity;                    TimeSheetDetail.Insert();                end;            end else                if TimeSheetDetail.Get(TimeSheetLine."Time Sheet No.", TimeSheetLine."Line No.", TimeSheetDate) then                    TimeSheetDetail.Delete();        end;    end;    procedure GetActivityInfo(TimeSheetLine: Record "Time Sheet Line"; var ActivityCaption: Text[30]; var ActivityID: Code[20]; var ActivitySubCaption: Text[30]; var ActivitySubID: Code[20])    begin        ActivitySubCaption := '';        ActivitySubID := '';        ActivityCaption := '';        ActivityID := '';        case TimeSheetLine.Type of            TimeSheetLine.Type::Job:                begin                    ActivityCaption := CopyStr(TimeSheetLine.FieldCaption("Job No."), 1, 30);                    ActivityID := TimeSheetLine."Job No.";                    ActivitySubCaption := CopyStr(TimeSheetLine.FieldCaption("Job Task No."), 1, 30);                    ActivitySubID := TimeSheetLine."Job Task No.";                end;            TimeSheetLine.Type::Absence:                begin                    ActivityCaption := CopyStr(TimeSheetLine.FieldCaption("Cause of Absence Code"), 1, 30);                    ActivityID := TimeSheetLine."Cause of Absence Code";                end;            TimeSheetLine.Type::"Assembly Order":                begin                    ActivityCaption := CopyStr(TimeSheetLine.FieldCaption("Assembly Order No."), 1, 30);                    ActivityID := TimeSheetLine."Assembly Order No.";                end;            else                OnGetActivityInfoCaseTypeElse(TimeSheetLine, ActivitySubCaption, ActivitySubID, ActivityCaption, ActivityID);        end;        OnAfterGetActivityInfo(TimeSheetLine, ActivitySubCaption, ActivitySubID, ActivityCaption, ActivityID);    end;    procedure ShowPostingEntries(TimeSheetNo: Code[20]; TimeSheetLineNo: Integer)    var        TimeSheetPostingEntry: Record "Time Sheet Posting Entry";        TimeSheetPostingEntries: Page "Time Sheet Posting Entries";    begin        TimeSheetPostingEntry.FilterGroup(2);        TimeSheetPostingEntry.SetRange("Time Sheet No.", TimeSheetNo);        TimeSheetPostingEntry.SetRange("Time Sheet Line No.", TimeSheetLineNo);        TimeSheetPostingEntry.FilterGroup(0);        Clear(TimeSheetPostingEntries);        TimeSheetPostingEntries.SetTableView(TimeSheetPostingEntry);        TimeSheetPostingEntries.RunModal();    end;    procedure FindNearestTimeSheetStartDate(Date: Date): Date    var        ResourcesSetup: Record "Resources Setup";    begin        ResourcesSetup.Get();        if Date2DWY(Date, 1) = ResourcesSetup."Time Sheet First Weekday" + 1 then            exit(Date);        exit(CalcDate(StrSubstNo('<WD%1>', ResourcesSetup."Time Sheet First Weekday" + 1), Date));    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalcActSchedFactBoxData(var TimeSheetHeader: Record "Time Sheet Header"; var TotalQtyText: Text; var TotalPresenceQty: Decimal; var AbsenceQty: Decimal);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCreateTSPostingEntry(TimeSheetDetail: Record "Time Sheet Detail"; var TimeSheetPostingEntry: Record "Time Sheet Posting Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyPrevTimeSheetLines()    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterAllLines(var TimeSheetLine: Record "Time Sheet Line"; ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcStatusFactBoxDataOnAfterTimeSheetHeaderSetFilters(var TimeSheetHeader: Record "Time Sheet Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcActSchedFactBoxDataOnAfterTimeSheetHeaderSetFilters(var TimeSheetHeader: Record "Time Sheet Header"; Calendar: Record Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcActSchedFactBoxDataOnBeforeResouceCalcFields(var Resource: Record Resource; Calendar: Record Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCheckInsertJobPlanningLine(JobPlanningLine: Record "Job Planning Line"; var JobPlanningLineBuffer: Record "Job Planning Line"; var SkipLine: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyPrevTimeSheetLinesOnBeforeCopyLine(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckJobJnlLine(var JobJnlLine: Record "Job Journal Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckResJnlLine(ResJournalLine: Record "Res. Journal Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFillJobPlanningBuffer(var JobPlanningLine: Record "Job Planning Line"; var JobPlanningLineBuffer: Record "Job Planning Line"; TimeSheetHeader: Record "Time Sheet Header"; var IsHandled: Boolean);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeFilterTimeSheets(var TimeSheetHeader: Record "Time Sheet Header"; FieldNo: Integer; ApplyToAdmin: Boolean; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeToTimeSheetLineInsert(var ToTimeSheetLine: Record "Time Sheet Line"; FromTimeSheetLine: Record "Time Sheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateLinesFromJobPlanningOnBeforeTimeSheetLineInsert(var TimeSheetLine: Record "Time Sheet Line"; var JobPlanningLine: Record "Job Planning Line");    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetActivityInfo(var TimeSheetLine: Record "Time Sheet Line"; var ActivityCaption: Text[30]; var ActivityID: Code[20]; var ActivitySubCaption: Text[30]; var ActivitySubID: Code[20]);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFillJobPlanningBufferOnBeforeJobPlanningLineBufferInsert(JobPlanningLine: Record "Job Planning Line"; var JobPlanningLineBuffer: Record "Job Planning Line" temporary);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnFindTimeSheetArchiveOnAfterSetFilters(var TimeSheetHeaderArchive: Record "Time Sheet Header Archive")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetActivityInfoCaseTypeElse(var TimeSheetLine: Record "Time Sheet Line"; var ActivityCaption: Text[30]; var ActivityID: Code[20]; var ActivitySubCaption: Text[30]; var ActivitySubID: Code[20]);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcActSchedFactBoxDataOnAfterSetDateDescription(TimeSheetHeader: Record "Time Sheet Header"; Calendar: Record Date; var DateDescriptionForSpecificDate: Text[30]);    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTimeSheetHeaderArchiveInsert(var TimeSheetHeaderArchive: Record "Time Sheet Header Archive"; TimeSheetHeader: Record "Time Sheet Header")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTimeSheetLineArchiveInsert(var TimeSheetLineArchive: Record "Time Sheet Line Archive"; TimeSheetLine: Record "Time Sheet Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTimeSheetDetailArchiveInsert(var TimeSheetDetailArchive: Record "Time Sheet Detail Archive"; TimeSheetDetail: Record "Time Sheet Detail")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTimeSheetCmtLineArchiveInsert(var TimeSheetCmtLineArchive: Record "Time Sheet Cmt. Line Archive"; TimeSheetCommentLine: Record "Time Sheet Comment Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCopyTimeSheetLine(var ToTimeSheetHeader: Record "Time Sheet Header"; var FromTimeSheetLine: Record "Time Sheet Line"; CopyComments: Boolean; var NextLineNo: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCopyTimeSheetLineArchive(var ToTimeSheetHeader: Record "Time Sheet Header"; var FromTimeSheetLineArchive: Record "Time Sheet Line Archive"; CopyComments: Boolean; var NextLineNo: Integer; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCheckTimeSheetLineFieldsVisible(var WorkTypeCodeVisible: Boolean; var JobFieldsVisible: Boolean; var ChargeableVisible: Boolean; var ServiceOrderNoVisible: Boolean; var AbsenceCauseVisible: Boolean; var AssemblyOrderNoVisible: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckTimeSheetLineFieldsVisible(var ServiceOrderNoVisible: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateTSLineFromDocLineOnBeforeTimeSheetLineInsert(var TimeSheetLine: Record "Time Sheet Line"; TableID: Integer; OrderNo: Code[20]; OrderLineNo: Integer)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeTimeSheetDetailInsert(var ToTimeSheetDetail: Record "Time Sheet Detail"; FromTimeSheetDetail: Record "Time Sheet Detail"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyTimeSheetLineArchiveOnBeforeToTimeSheetLineInsert(var ToTimeSheetLine: Record "Time Sheet Line"; FromTimeSheetLineArchive: Record "Time Sheet Line Archive")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckAccPeriod(Date: Date; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCopyTimeSheetLineArchiveDetails(var FromTimeSheetLineArchive: Record "Time Sheet Line Archive"; var ToTimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean)    begin    end;}