Page 949 Time Sheet Lines

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetLines.Page.al659 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.Projects.Resources.Setup;page 949 "Time Sheet Lines"{    Caption = 'Time Sheet Lines';    ApplicationArea = Jobs;    UsageCategory = Tasks;    InsertAllowed = false;    ModifyAllowed = false;    DeleteAllowed = false;    LinksAllowed = false;    PageType = List;    SourceTable = "Time Sheet Line";    SourceTableTemporary = true;    SourceTableView = sorting("Time Sheet No.", "Line No.") order(descending);    AnalysisModeEnabled = true;    layout    {        area(Content)        {            repeater(Control1)            {                ShowCaption = false;                FreezeColumn = "Header Ending Date";                Editable = false;                field("Time Sheet No."; Rec."Time Sheet No.")                {                    ApplicationArea = Suite;                    HideValue = TimeSheetNoHideValue;                    StyleExpr = 'Strong';                }                field("Header Resource No."; TempTimeSheetHeader."Resource No.")                {                    ApplicationArea = Jobs;                    Caption = 'Resource No.';                    ToolTip = 'Specifies the number of the resource for the time sheet.';                    Editable = false;                }                field("Header Starting Date"; Rec."Time Sheet Starting Date")                {                    ApplicationArea = Jobs;                    Caption = 'Starting Date';                    Editable = false;                    Importance = Additional;                }                field("Header Ending Date"; TempTimeSheetHeader."Ending Date")                {                    ApplicationArea = Jobs;                    Caption = 'Ending Date';                    ToolTip = 'Specifies the ending date for a time sheet.';                    Editable = false;                    Importance = Additional;                }                field(Type; Rec.Type)                {                    ApplicationArea = Jobs;                }                field(Status; Rec.Status)                {                    ApplicationArea = Jobs;                    Width = 4;                }                field(Description; Rec.Description)                {                    ApplicationArea = Jobs;                }                field("Job No."; Rec."Job No.")                {                    ApplicationArea = Jobs;                    Visible = JobFieldsVisible;                }                field("Job Task No."; Rec."Job Task No.")                {                    ApplicationArea = Jobs;                    Visible = JobFieldsVisible;                }                field("Cause of Absence Code"; Rec."Cause of Absence Code")                {                    ApplicationArea = Jobs;                    Visible = AbsenceCauseVisible;                }                field(Chargeable; Rec.Chargeable)                {                    ApplicationArea = Jobs;                    Visible = ChargeableVisible;                }                field("Work Type Code"; Rec."Work Type Code")                {                    ApplicationArea = Jobs;                    Visible = WorkTypeCodeVisible;                }                field("Assembly Order No."; Rec."Assembly Order No.")                {                    ApplicationArea = Assembly;                    Visible = false;                }                field(Archived; Rec.Posted) //used field to mark from archive                {                    Caption = 'Archived';                    ApplicationArea = Jobs;                    ToolTip = 'Specifies if the time sheet line has been archived.';                }                field(Field1; CellData[1])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[1];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field(Field2; CellData[2])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[2];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field(Field3; CellData[3])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[3];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field(Field4; CellData[4])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[4];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field(Field5; CellData[5])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[5];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field(Field6; CellData[6])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[6];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field(Field7; CellData[7])                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    BlankZero = true;                    CaptionClass = '3,' + ColumnCaption[7];                    ToolTip = 'Specifies the number of hours registered for this day.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }                field("Total Quantity"; LineTotal)                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    Caption = 'Total';                    Editable = false;                    ToolTip = 'Specifies the total number of hours that have been entered on a time sheet.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }            }        }        area(factboxes)        {            part(TimeSheetLineDetailsFactBox; "TimeSheet Line Details FactBox")            {                ApplicationArea = Basic, Suite;            }        }    }    actions    {        area(Processing)        {            action(ViewAll)            {                ApplicationArea = Jobs;                Caption = 'View All';                ToolTip = 'Use this action to reset Status filter.';                Image = ViewCheck;                trigger OnAction()                begin                    FilterLinesByStatus(-1);                end;            }            action(ViewOpen)            {                ApplicationArea = Jobs;                Caption = 'View Open';                ToolTip = 'Use this action to set filter Status = Open.';                Image = ViewCheck;                trigger OnAction()                begin                    FilterLinesByStatus(Enum::"Time Sheet Status"::Open.AsInteger());                end;            }            action(ViewSubmitted)            {                ApplicationArea = Jobs;                Caption = 'View Submitted';                ToolTip = 'Use this action to set filter Status = Submitted.';                Image = ViewCheck;                trigger OnAction()                begin                    FilterLinesByStatus(Enum::"Time Sheet Status"::Submitted.AsInteger());                end;            }        }        area(Navigation)        {            action(OpenTimeSheet)            {                ApplicationArea = Jobs;                Scope = Repeater;                Caption = 'Open Time Sheet Card';                Image = OpenWorksheet;                ToolTip = 'Open Time Sheet Card for the record.';                trigger OnAction()                var                    TimeSheetHeaderArchive: Record "Time Sheet Header Archive";                    TimeSheetHeader: Record "Time Sheet Header";                    TimeSheetCard: Page "Time Sheet Card";                    TimeSheetArchiveCard: Page "Time Sheet Archive Card";                begin                    if Rec.Posted then begin                        TimeSheetHeaderArchive.Get(Rec."Time Sheet No.");                        TimeSheetHeaderArchive.SetRecFilter();                        TimeSheetArchiveCard.SetTableView(TimeSheetHeaderArchive);                        TimeSheetArchiveCard.Run();                    end                    else begin                        TimeSheetHeader.Get(Rec."Time Sheet No.");                        TimeSheetHeader.SetRecFilter();                        TimeSheetCard.SetTableView(TimeSheetHeader);                        TimeSheetCard.Run();                    end;                end;            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.';                actionref(OpenTimeSheet_Promoted; OpenTimeSheet)                {                }                group(Category_FilterLines)                {                    Caption = 'View All';                    ShowAs = SplitButton;                    actionref(ViewAll_Promoted; ViewAll)                    {                    }                    actionref(ViewOpen_Promoted; ViewOpen)                    {                    }                    actionref(ViewSubmitted_Promoted; ViewSubmitted)                    {                    }                }            }        }    }    trigger OnAfterGetRecord()    begin        if TempTimeSheetHeader."No." <> Rec."Time Sheet No." then            TempTimeSheetHeader.Get(Rec."Time Sheet No.");        TimeSheetNoHideValue := false;        TimeSheetNoOnFormat();        UpdateValuesPerDays();    end;    trigger OnAfterGetCurrRecord()    begin        CurrPage.TimeSheetLineDetailsFactBox.Page.SetSource(Rec, Rec.Posted);    end;    trigger OnOpenPage()    begin        if not LookupMode then            GetData(Rec, '', 0D, true, true);        TimeSheetManagement.CheckTimeSheetLineFieldsVisible(WorkTypeCodeVisible, JobFieldsVisible, ChargeableVisible, ServiceOrderNoVisible, AbsenceCauseVisible, AssemblyOrderNoVisible);        if Rec.FindFirst() then;        NoOfColumns := 7;        SetWeekDaysOrder();    end;    var        GlobalTimeSheetHeader: Record "Time Sheet Header";        TimeSheetManagement: Codeunit "Time Sheet Management";        CellData: array[32] of Decimal;        LineTotal: Decimal;        ColumnCaption: array[7] of Text[30];        NoOfColumns: Integer;        LoadEntriesForPeriod: Option Month,Year,All;        WorkTypeCodeVisible, JobFieldsVisible, ChargeableVisible, AbsenceCauseVisible, AssemblyOrderNoVisible : Boolean;        TimeSheetNoHideValue: Boolean;        LastStartDate: Date;    protected var        TempTimeSheetHeader: Record "Time Sheet Header" temporary;        ServiceOrderNoVisible: Boolean;    local procedure UpdateValuesPerDays()    var        TimeSheetDetail: Record "Time Sheet Detail";        TimeSheetDetailArchive: Record "Time Sheet Detail Archive";        i: Integer;    begin        i := 0;        LineTotal := 0;        if Rec.Posted then            while i < NoOfColumns do begin                i := i + 1;                if (Rec."Line No." <> 0) and TimeSheetDetailArchive.Get(                     Rec."Time Sheet No.",                     Rec."Line No.",                     Rec."Time Sheet Starting Date" + i - 1)                then                    CellData[i] := TimeSheetDetailArchive.Quantity                else                    CellData[i] := 0;                LineTotal += CellData[i];            end        else            while i < NoOfColumns do begin                i := i + 1;                if (Rec."Line No." <> 0) and TimeSheetDetail.Get(                     Rec."Time Sheet No.",                     Rec."Line No.",                     Rec."Time Sheet Starting Date" + i - 1)                then                    CellData[i] := TimeSheetDetail.Quantity                else                    CellData[i] := 0;                LineTotal += CellData[i];            end;    end;    local procedure FilterLinesByStatus(TimeSheetStatusAsInt: Integer)    begin        case TimeSheetStatusAsInt of            -1: //all lines                Rec.SetRange(Status);            Enum::"Time Sheet Status"::Open.AsInteger():                Rec.SetRange(Status, Enum::"Time Sheet Status"::Open);            Enum::"Time Sheet Status"::Submitted.AsInteger():                Rec.SetRange(Status, Enum::"Time Sheet Status"::Submitted);            Enum::"Time Sheet Status"::Rejected.AsInteger():                Rec.SetRange(Status, Enum::"Time Sheet Status"::Rejected);            Enum::"Time Sheet Status"::Approved.AsInteger():                Rec.SetRange(Status, Enum::"Time Sheet Status"::Approved);        end;        CurrPage.Update(false);    end;    local procedure SetWeekDaysOrder()    var        ResourceSetup: Record "Resources Setup";        DaysInWeek: Dictionary of [Integer, Text[30]];        i: Integer;        FirsDay: Integer;        MondayLbl: Label 'Mon';        TuesdayLbl: Label 'Tue';        WednesdayLbl: Label 'Wed';        ThursdayLbl: Label 'Thu';        FridayLbl: Label 'Fri';        SaturdayLbl: Label 'Sat';        SundayLbl: Label 'Sun';    begin        DaysInWeek.Add(1, MondayLbl);        DaysInWeek.Add(2, TuesdayLbl);        DaysInWeek.Add(3, WednesdayLbl);        DaysInWeek.Add(4, ThursdayLbl);        DaysInWeek.Add(5, FridayLbl);        DaysInWeek.Add(6, SaturdayLbl);        DaysInWeek.Add(0, SundayLbl);        ResourceSetup.Get();        FirsDay := ResourceSetup."Time Sheet First Weekday";        for i := 1 to 7 do            ColumnCaption[i] := DaysInWeek.Get((FirsDay + i) mod 7);        OnAfterSetWeekDaysOrder(ColumnCaption);    end;    procedure SetForTimeSheetHeader(ForTimeSheetHeader: Record "Time Sheet Header")    begin        GlobalTimeSheetHeader := ForTimeSheetHeader;        LoadEntriesForPeriod := LoadEntriesForPeriod::All;        GlobalTimeSheetHeader.TestField("No.");        GlobalTimeSheetHeader.TestField("Resource No.");    end;    local procedure TimeSheetNoOnFormat()    begin        if not IsFirstDocLine() then            TimeSheetNoHideValue := true;    end;    local procedure IsFirstDocLine(): Boolean    var        TimeSheetLine: Record "Time Sheet Line";        TempTimeSheetLine: Record "Time Sheet Line" temporary;        TimeSheetLineArchive: Record "Time Sheet Line Archive";    begin        TempTimeSheetLine.Reset();        TempTimeSheetLine.CopyFilters(Rec);        TempTimeSheetLine.SetRange("Time Sheet No.", Rec."Time Sheet No.");        if not TempTimeSheetLine.FindFirst() then            if Rec.Posted then begin                TimeSheetLineArchive.SetRange("Time Sheet No.", Rec."Time Sheet No.");                TimeSheetLineArchive.SetExclusionTypeFilter();                if TimeSheetLineArchive.FindLast() then begin                    TempTimeSheetLine.TransferFields(TimeSheetLineArchive);                    TempTimeSheetLine.Insert();                end;            end            else begin                TimeSheetLine.CopyFilters(Rec);                TimeSheetLine.SetRange("Time Sheet No.", Rec."Time Sheet No.");                TimeSheetLine.SetExclusionTypeFilter();                if TimeSheetLine.FindLast() then begin                    TempTimeSheetLine := TimeSheetLine;                    TempTimeSheetLine.Insert();                end;            end;        if Rec."Line No." = TempTimeSheetLine."Line No." then            exit(true);    end;    local procedure GetFromDate(ForDate: Date) FromDate: Date    begin        if ForDate = 0D then            FromDate := 0D        else            case LoadEntriesForPeriod of                LoadEntriesForPeriod::Month:                    FromDate := CalcDate('<-4W>', ForDate);                LoadEntriesForPeriod::Year:                    FromDate := CalcDate('<-52W>', ForDate);                LoadEntriesForPeriod::All:                    FromDate := 0D;            end;        OnAfterGetFromDate(ForDate, LoadEntriesForPeriod, FromDate);    end;    procedure SetRec(var TimeSheetLine: Record "Time Sheet Line")    begin        if TimeSheetLine.FindSet() then            repeat                Rec.Init();                Rec := TimeSheetLine;                if Rec.Insert() then;            until TimeSheetLine.Next() = 0;    end;    procedure GetData(var TimeSheetLine: Record "Time Sheet Line"; ForResourceCode: Code[20]; ProcessingDate: Date; OnPageOpen: Boolean; IncludeArchive: Boolean)    var        FromDate: Date;        ToDate: Date;        NoLinesToShowErr: Label 'There are no time sheet lines to show.';    begin        if ProcessingDate = 0D then            LoadEntriesForPeriod := LoadEntriesForPeriod::All;        if LastStartDate = 0D then            ToDate := ProcessingDate        else            ToDate := LastStartDate - 1;        FromDate := GetFromDate(ProcessingDate);        LastStartDate := FromDate;        GetDataFromTimeSheetQuery(TimeSheetLine, ForResourceCode, FromDate, ToDate);        if IncludeArchive then            GetDataFromTimeSheetArchiveQuery(TimeSheetLine, ForResourceCode, FromDate, ToDate);        if (TimeSheetLine.Count = 0) and (OnPageOpen) then begin            if LoadEntriesForPeriod = LoadEntriesForPeriod::All then                Error(NoLinesToShowErr);            LoadEntriesForPeriod += 1;            GetData(TimeSheetLine, ForResourceCode, ProcessingDate, OnPageOpen, IncludeArchive);        end;    end;    local procedure GetDataFromTimeSheetQuery(var TimeSheetLine: Record "Time Sheet Line"; ForResourceCode: Code[20]; FromDate: Date; ToDate: Date)    var        GetTimeSheetLines: Query "Get Time Sheet Lines";    begin        if ForResourceCode <> '' then            GetTimeSheetLines.SetRange(Filter_Resource_No_, ForResourceCode);        if ToDate <> 0D then            GetTimeSheetLines.SetRange(Filter_Starting_Date, FromDate, ToDate);        if TimeSheetManagement.IsUserTimeSheetAdmin(UserId()) then            SetLinesFromGetTimeSheetLinesQuery(TimeSheetLine, GetTimeSheetLines)        else begin            GetTimeSheetLines.SetRange(Filter_Owner_User, UserId());            SetLinesFromGetTimeSheetLinesQuery(TimeSheetLine, GetTimeSheetLines);            GetTimeSheetLines.SetRange(Filter_Owner_User);            GetTimeSheetLines.SetRange(Filter_Approver_User, UserId());            SetLinesFromGetTimeSheetLinesQuery(TimeSheetLine, GetTimeSheetLines);        end;    end;    local procedure GetDataFromTimeSheetArchiveQuery(var TimeSheetLine: Record "Time Sheet Line"; ForResourceCode: Code[20]; FromDate: Date; ToDate: Date)    var        GetTimeSheetArchiveLines: Query "Get Time Sheet Archive Lines";    begin        if ForResourceCode <> '' then            GetTimeSheetArchiveLines.SetRange(Filter_Resource_No_, ForResourceCode);        if ToDate <> 0D then            GetTimeSheetArchiveLines.SetRange(Filter_Starting_Date, FromDate, ToDate);        if TimeSheetManagement.IsUserTimeSheetAdmin(UserId()) then            SetLinesFromGetTimeSheetArchiveLinesQuery(TimeSheetLine, GetTimeSheetArchiveLines)        else begin            GetTimeSheetArchiveLines.SetRange(Filter_Owner_User, UserId());            SetLinesFromGetTimeSheetArchiveLinesQuery(TimeSheetLine, GetTimeSheetArchiveLines);            GetTimeSheetArchiveLines.SetRange(Filter_Owner_User);            GetTimeSheetArchiveLines.SetRange(Filter_Approver_User, UserId());            SetLinesFromGetTimeSheetArchiveLinesQuery(TimeSheetLine, GetTimeSheetArchiveLines);        end;    end;    local procedure SetLinesFromGetTimeSheetLinesQuery(var TimeSheetLine: Record "Time Sheet Line"; var GetTimeSheetLines: Query "Get Time Sheet Lines")    begin        if GetTimeSheetLines.Open() then            while GetTimeSheetLines.Read() do                if (not (GetTimeSheetLines.Type in [GetTimeSheetLines.Type::"Assembly Order", GetTimeSheetLines.Type::Service])) and                (GetTimeSheetLines.Time_Sheet_No_ <> GlobalTimeSheetHeader."No.") then begin                    TimeSheetLine.Init();                    TimeSheetLine."Time Sheet No." := GetTimeSheetLines.Time_Sheet_No_;                    TimeSheetLine."Line No." := GetTimeSheetLines.Line_No_;                    TimeSheetLine."Time Sheet Starting Date" := GetTimeSheetLines.Starting_Date;                    TimeSheetLine.Type := GetTimeSheetLines.Type;                    TimeSheetLine.Status := GetTimeSheetLines.Status;                    TimeSheetLine.Description := GetTimeSheetLines.Description;                    TimeSheetLine."Job No." := GetTimeSheetLines.Job_No_;                    TimeSheetLine."Job Task No." := GetTimeSheetLines.Job_Task_No_;                    TimeSheetLine."Cause of Absence Code" := GetTimeSheetLines.Cause_of_Absence_Code;                    TimeSheetLine.Chargeable := GetTimeSheetLines.Chargeable;                    TimeSheetLine."Work Type Code" := GetTimeSheetLines.Work_Type_Code;                    TimeSheetLine."Service Order No." := GetTimeSheetLines.Service_Order_No_;                    TimeSheetLine."Assembly Order No." := GetTimeSheetLines.Assembly_Order_No_;                    if TimeSheetLine.Insert() then;                    if TempTimeSheetHeader."No." <> GetTimeSheetLines.Time_Sheet_No_ then begin                        TempTimeSheetHeader.Init();                        TempTimeSheetHeader."No." := GetTimeSheetLines.Time_Sheet_No_;                        TempTimeSheetHeader."Resource No." := GetTimeSheetLines.Resource_No_;                        TempTimeSheetHeader."Starting Date" := GetTimeSheetLines.Starting_Date;                        TempTimeSheetHeader."Ending Date" := GetTimeSheetLines.Ending_Date;                        if TempTimeSheetHeader.Insert() then;                    end;                end;        GetTimeSheetLines.Close();    end;    local procedure SetLinesFromGetTimeSheetArchiveLinesQuery(var TimeSheetLine: Record "Time Sheet Line"; var GetTimeSheetArchiveLines: Query "Get Time Sheet Archive Lines")    begin        if GetTimeSheetArchiveLines.Open() then            while GetTimeSheetArchiveLines.Read() do                if not (GetTimeSheetArchiveLines.Type in [GetTimeSheetArchiveLines.Type::"Assembly Order", GetTimeSheetArchiveLines.Type::Service]) then begin                    TimeSheetLine.Init();                    TimeSheetLine."Time Sheet No." := GetTimeSheetArchiveLines.Time_Sheet_No_;                    TimeSheetLine."Line No." := GetTimeSheetArchiveLines.Line_No_;                    TimeSheetLine."Time Sheet Starting Date" := GetTimeSheetArchiveLines.Starting_Date;                    TimeSheetLine.Type := GetTimeSheetArchiveLines.Type;                    TimeSheetLine.Status := GetTimeSheetArchiveLines.Status;                    TimeSheetLine.Description := GetTimeSheetArchiveLines.Description;                    TimeSheetLine."Job No." := GetTimeSheetArchiveLines.Job_No_;                    TimeSheetLine."Job Task No." := GetTimeSheetArchiveLines.Job_Task_No_;                    TimeSheetLine."Cause of Absence Code" := GetTimeSheetArchiveLines.Cause_of_Absence_Code;                    TimeSheetLine.Chargeable := GetTimeSheetArchiveLines.Chargeable;                    TimeSheetLine."Work Type Code" := GetTimeSheetArchiveLines.Work_Type_Code;                    TimeSheetLine."Service Order No." := GetTimeSheetArchiveLines.Service_Order_No_;                    TimeSheetLine."Assembly Order No." := GetTimeSheetArchiveLines.Assembly_Order_No_;                    TimeSheetLine.Posted := true; //to mark from archive                    if TimeSheetLine.Insert() then;                    if TempTimeSheetHeader."No." <> GetTimeSheetArchiveLines.Time_Sheet_No_ then begin                        TempTimeSheetHeader.Init();                        TempTimeSheetHeader."No." := GetTimeSheetArchiveLines.Time_Sheet_No_;                        TempTimeSheetHeader."Resource No." := GetTimeSheetArchiveLines.Resource_No_;                        TempTimeSheetHeader."Starting Date" := GetTimeSheetArchiveLines.Starting_Date;                        TempTimeSheetHeader."Ending Date" := GetTimeSheetArchiveLines.Ending_Date;                        if TempTimeSheetHeader.Insert() then;                    end;                end;        GetTimeSheetArchiveLines.Close();    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetFromDate(ForDate: Date; LoadEntriesForPeriod: Option Month,Year,All; var FromDate: Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterSetWeekDaysOrder(var ColumnCaption: array[7] of Text[30])    begin    end;}