Page 976 Time Sheet Archive Subform

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetArchiveSubform.Page.al259 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 System.Utilities;page 976 "Time Sheet Archive Subform"{    AutoSplitKey = true;    Caption = 'Lines';    DelayedInsert = true;    LinksAllowed = false;    PageType = ListPart;    SourceTable = "Time Sheet Line Archive";    layout    {        area(Content)        {            repeater(Control1)            {                ShowCaption = false;                field(Type; Rec.Type)                {                    ApplicationArea = Jobs;                    ToolTip = 'Specifies the type of time sheet line.';                }                field("Job No."; Rec."Job No.")                {                    ApplicationArea = Jobs;                }                field("Job Task No."; Rec."Job Task No.")                {                    ApplicationArea = Jobs;                }                field(Description; Rec.Description)                {                    ApplicationArea = Jobs;                }                field("Cause of Absence Code"; Rec."Cause of Absence Code")                {                    ApplicationArea = Jobs;                }                field(Chargeable; Rec.Chargeable)                {                    ApplicationArea = Jobs;                }                field("Work Type Code"; Rec."Work Type Code")                {                    ApplicationArea = Jobs;                }                field("Assembly Order No."; Rec."Assembly Order No.")                {                    ApplicationArea = Assembly;                }                field(Status; Rec.Status)                {                    ApplicationArea = Jobs;                }                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"; Rec."Total Quantity")                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    Caption = 'Total';                    DrillDown = false;                    ToolTip = 'Specifies the total number of hours that have been entered on a time sheet.';                    DecimalPlaces = 0 : 2;                    Width = 6;                }            }            group(GroupTotal)            {                ShowCaption = false;                field(UnitOfMeasureCode; UnitOfMeasureCode)                {                    ApplicationArea = Jobs;                    Caption = 'Unit of Measure';                    ToolTip = 'Specifies the unit of measure for the time sheet.';                    Editable = false;                }                field(TimeSheetTotalQuantity; GetTimeSheetTotalQuantity())                {                    ApplicationArea = Jobs;                    AutoFormatType = 0;                    Caption = 'Total';                    ToolTip = 'Specifies the total amount of time for the time sheet.';                    Editable = false;                    DecimalPlaces = 0 : 2;                }            }        }    }    actions    {        area(Processing)        {            group(Line)            {                action(LineComments)                {                    ApplicationArea = Comments;                    Caption = 'Comments';                    Image = ViewComments;                    RunObject = Page "Time Sheet Arc. Comment Sheet";                    RunPageLink = "No." = field("Time Sheet No."),                                  "Time Sheet Line No." = field("Line No.");                    Scope = Repeater;                    ToolTip = 'View or create comments.';                }            }        }    }    trigger OnAfterGetRecord()    begin        UpdateControls();    end;    trigger OnAfterGetCurrRecord()    begin        UpdateControls();    end;    var        TimeSheetDetailArchive: Record "Time Sheet Detail Archive";        ColumnRecords: array[32] of Record Date;        TimeSheetMgt: Codeunit "Time Sheet Management";        NoOfColumns: Integer;        CellData: array[32] of Decimal;        ColumnCaption: array[32] of Text[1024];        UnitOfMeasureCode: Code[10];    protected var        TimeSheetHeaderArchive: Record "Time Sheet Header Archive";    procedure SetColumns(TimeSheetNo: Code[20])    var        Calendar: Record Date;    begin        Clear(ColumnCaption);        Clear(ColumnRecords);        Clear(Calendar);        Clear(NoOfColumns);        TimeSheetHeaderArchive.Get(TimeSheetNo);        TimeSheetHeaderArchive.CalcFields("Unit of Measure");        UnitOfMeasureCode := TimeSheetHeaderArchive."Unit of Measure";        Calendar.SetRange("Period Type", Calendar."Period Type"::Date);        Calendar.SetRange("Period Start", TimeSheetHeaderArchive."Starting Date", TimeSheetHeaderArchive."Ending Date");        if Calendar.FindSet() then            repeat                NoOfColumns += 1;                ColumnRecords[NoOfColumns]."Period Start" := Calendar."Period Start";                ColumnCaption[NoOfColumns] := TimeSheetMgt.FormatDate(Calendar."Period Start", 1);            until Calendar.Next() = 0;    end;    local procedure UpdateControls()    var        i: Integer;    begin        i := 0;        while i < NoOfColumns do begin            i := i + 1;            if (Rec."Line No." <> 0) and TimeSheetDetailArchive.Get(                 Rec."Time Sheet No.",                 Rec."Line No.",                 ColumnRecords[i]."Period Start")            then                CellData[i] := TimeSheetDetailArchive.Quantity            else                CellData[i] := 0;        end;    end;    local procedure GetTimeSheetTotalQuantity(): Decimal    begin        TimeSheetHeaderArchive.Get(Rec."Time Sheet No.");        TimeSheetHeaderArchive.CalcFields(Quantity);        exit(TimeSheetHeaderArchive.Quantity);    end;}