Table 950 Time Sheet Header

Base Application, Microsoft.Projects.TimeSheet

src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetHeader.Table.al455 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.Resource;using Microsoft.Projects.Resources.Setup;using System.Security.User;table 950 "Time Sheet Header"{    Caption = 'Time Sheet Header';    DataClassification = CustomerContent;    fields    {        field(1; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';        }        field(3; "Starting Date"; Date)        {            Caption = 'Starting Date';            ToolTip = 'Specifies the starting date for a time sheet.';        }        field(4; "Ending Date"; Date)        {            Caption = 'Ending Date';            ToolTip = 'Specifies the ending date for a time sheet.';        }        field(5; "Resource No."; Code[20])        {            Caption = 'Resource No.';            ToolTip = 'Specifies the number of the resource for the time sheet.';            TableRelation = Resource;            trigger OnValidate()            var                IsHandled: Boolean;            begin                ResourcesSetup.Get();                if "Resource No." <> '' then begin                    Resource.Get("Resource No.");                    CheckResourcePrivacyBlocked(Resource);                    IsHandled := false;                    OnValidateResourceNoOnBeforeTestFields(Resource, IsHandled);                    if IsHandled then                        exit;                    Resource.TestField(Blocked, false);                    Resource.TestField("Time Sheet Owner User ID");                    Resource.TestField("Time Sheet Approver User ID");                    "Owner User ID" := Resource."Time Sheet Owner User ID";                    "Approver User ID" := Resource."Time Sheet Approver User ID";                end;            end;        }        field(6; "Resource Name"; Text[100])        {            Caption = 'Resource Name';            ToolTip = 'Specifies the name of the resource for the time sheet.';            FieldClass = FlowField;            CalcFormula = lookup(Resource.Name where("No." = field("Resource No.")));            Editable = false;        }        field(7; "Owner User ID"; Code[50])        {            Caption = 'Owner User ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = "User Setup";        }        field(8; "Approver User ID"; Code[50])        {            Caption = 'Approver User ID';            DataClassification = EndUserIdentifiableInformation;            TableRelation = "User Setup";        }        field(10; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the description for a time sheet.';            DataClassification = CustomerContent;        }        field(11; "Unit of Measure"; Code[10])        {            CalcFormula = lookup(Resource."Base Unit of Measure" where("No." = field("Resource No.")));            Caption = 'Unit of Measure';            FieldClass = FlowField;            Editable = false;        }        field(12; "Open Exists"; Boolean)        {            CalcFormula = exist("Time Sheet Line" where("Time Sheet No." = field("No."),                                                         Status = const(Open)));            Caption = 'Open Exists';            ToolTip = 'Specifies if there are time sheet lines with the status Open.';            Editable = false;            FieldClass = FlowField;        }        field(13; "Submitted Exists"; Boolean)        {            CalcFormula = exist("Time Sheet Line" where("Time Sheet No." = field("No."),                                                         Status = const(Submitted)));            Caption = 'Submitted Exists';            ToolTip = 'Specifies if there are time sheet lines with the status Submitted.';            Editable = false;            FieldClass = FlowField;        }        field(14; "Rejected Exists"; Boolean)        {            CalcFormula = exist("Time Sheet Line" where("Time Sheet No." = field("No."),                                                         Status = const(Rejected)));            Caption = 'Rejected Exists';            ToolTip = 'Specifies whether there are time sheet lines with the status Rejected.';            Editable = false;            FieldClass = FlowField;        }        field(15; "Approved Exists"; Boolean)        {            CalcFormula = exist("Time Sheet Line" where("Time Sheet No." = field("No."),                                                         Status = const(Approved)));            Caption = 'Approved Exists';            ToolTip = 'Specifies whether there are time sheet lines with the status Approved.';            Editable = false;            FieldClass = FlowField;        }        field(16; "Posted Exists"; Boolean)        {            CalcFormula = exist("Time Sheet Posting Entry" where("Time Sheet No." = field("No.")));            Caption = 'Posted Exists';            ToolTip = 'Specifies whether there are time sheet lines with the status Posted.';            Editable = false;            FieldClass = FlowField;        }        field(18; "Lines Exist"; Boolean)        {            CalcFormula = exist("Time Sheet Line" where("Time Sheet No." = field("No.")));            Caption = 'Lines Exist';            Editable = false;            FieldClass = FlowField;        }        field(20; Quantity; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Time Sheet Detail".Quantity where("Time Sheet No." = field("No."),                                                                  Status = field("Status Filter"),                                                                  "Job No." = field("Job No. Filter"),                                                                  "Job Task No." = field("Job Task No. Filter"),                                                                  Date = field("Date Filter"),                                                                  Posted = field("Posted Filter"),                                                                  Type = field("Type Filter")));            Caption = 'Quantity';            ToolTip = 'Specifies the total number of hours that are registered on the time sheet.';            FieldClass = FlowField;        }        field(21; "Posted Quantity"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Time Sheet Posting Entry".Quantity where("Time Sheet No." = field("No.")));            Caption = 'Posted Quantity';            FieldClass = FlowField;        }        field(26; Comment; Boolean)        {            CalcFormula = exist("Time Sheet Comment Line" where("No." = field("No."),                                                                 "Time Sheet Line No." = const(0)));            Caption = 'Comment';            ToolTip = 'Specifies that a comment about this document has been entered.';            Editable = false;            FieldClass = FlowField;        }        field(30; "Status Filter"; Enum "Time Sheet Status")        {            Caption = 'Status Filter';            FieldClass = FlowFilter;        }        field(31; "Job No. Filter"; Code[20])        {            Caption = 'Project No. Filter';            FieldClass = FlowFilter;        }        field(32; "Job Task No. Filter"; Code[20])        {            Caption = 'Project Task No. Filter';            FieldClass = FlowFilter;        }        field(33; "Date Filter"; Date)        {            Caption = 'Date Filter';            FieldClass = FlowFilter;        }        field(34; "Posted Filter"; Boolean)        {            Caption = 'Posted Filter';            FieldClass = FlowFilter;        }        field(35; "Type Filter"; Enum "Time Sheet Line Type")        {            Caption = 'Type Filter';            FieldClass = FlowFilter;        }        field(40; "Quantity Open"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Time Sheet Detail".Quantity where("Time Sheet No." = field("No."),                                                         Status = const(Open)));            Caption = 'Quantity Open';            ToolTip = 'Specifies the total number of hours with the status Open on the time sheet.';            Editable = false;            FieldClass = FlowField;        }        field(41; "Quantity Submitted"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Time Sheet Detail".Quantity where("Time Sheet No." = field("No."),                                                         Status = const(Submitted)));            Caption = 'Quantity Submitted';            ToolTip = 'Specifies the total number of hours with the status Submitted on the time sheet.';            Editable = false;            FieldClass = FlowField;        }        field(42; "Quantity Approved"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Time Sheet Detail".Quantity where("Time Sheet No." = field("No."),                                                         Status = const(Approved)));            Caption = 'Quantity Approved';            ToolTip = 'Specifies the total number of hours with the status Approved on the time sheet.';            Editable = false;            FieldClass = FlowField;        }        field(43; "Quantity Rejected"; Decimal)        {            AutoFormatType = 0;            CalcFormula = sum("Time Sheet Detail".Quantity where("Time Sheet No." = field("No."),                                                         Status = const(Rejected)));            Caption = 'Quantity Rejected';            ToolTip = 'Specifies the total number of hours with the status Rejected on the time sheet.';            Editable = false;            FieldClass = FlowField;        }    }    keys    {        key(Key1; "No.")        {            Clustered = true;        }        key(Key2; "Resource No.", "Starting Date")        {        }        key(Key3; "Owner User ID")        {        }        key(Key4; "Approver User ID")        {        }    }    fieldgroups    {        fieldgroup(DropDown; "No.", "Starting Date", "Ending Date", "Resource No.")        {        }        fieldgroup(Brick; "No.", "Starting Date", "Ending Date", "Resource No.", Quantity)        {        }    }    trigger OnDelete()    var        TimeSheetCommentLine: Record "Time Sheet Comment Line";    begin        if "Resource No." <> '' then begin            Resource.Get("Resource No.");            CheckResourcePrivacyBlocked(Resource);            Resource.TestField(Blocked, false);        end;        TimeSheetLine.SetRange("Time Sheet No.", "No.");        TimeSheetLine.DeleteAll(true);        TimeSheetCommentLine.SetRange("No.", "No.");        TimeSheetCommentLine.SetRange("Time Sheet Line No.", 0);        TimeSheetCommentLine.DeleteAll();        RemoveFromMyTimeSheets();    end;    trigger OnInsert()    begin        if "Resource No." <> '' then begin            Resource.Get("Resource No.");            CheckResourcePrivacyBlocked(Resource);            Resource.TestField(Blocked, false);            if Resource."Time Sheet Owner User ID" <> '' then                AddToMyTimeSheets(Resource."Time Sheet Owner User ID");        end;    end;    trigger OnModify()    begin        if "Resource No." <> '' then begin            Resource.Get("Resource No.");            CheckResourcePrivacyBlocked(Resource);            Resource.TestField(Blocked, false);        end;    end;    trigger OnRename()    begin        if "Resource No." <> '' then begin            Resource.Get("Resource No.");            CheckResourcePrivacyBlocked(Resource);            Resource.TestField(Blocked, false);        end;    end;    var        Resource: Record Resource;        ResourcesSetup: Record "Resources Setup";        TimeSheetLine: Record "Time Sheet Line";        TimeSheetMgt: Codeunit "Time Sheet Management";#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label '%1 does not contain lines.';#pragma warning restore AA0470        Text002: Label 'No time sheets are available. The time sheet administrator must create time sheets before you can access them in this window.';#pragma warning restore AA0074        PrivacyBlockedErr: Label 'You cannot use resource %1 because they are marked as blocked due to privacy.', Comment = '%1=resource no.';    procedure CalcQtyWithStatus(Status: Enum "Time Sheet Status"): Decimal    begin        SetRange("Status Filter", Status);        CalcFields(Quantity);        exit(Quantity);    end;    procedure Check()    begin        TimeSheetLine.SetRange("Time Sheet No.", "No.");        if TimeSheetLine.FindSet() then            repeat                CheckTimeSheetLine(TimeSheetLine);            until TimeSheetLine.Next() = 0        else            Error(Text001, "No.");    end;    local procedure CheckTimeSheetLine(TimeSheetLine: Record "Time Sheet Line")    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckTimeSheetLine(TimeSheetLine, IsHandled);        if IsHandled then            exit;        TimeSheetLine.TestField(Status, TimeSheetLine.Status::Approved);        TimeSheetLine.TestField(Posted, true);    end;    procedure GetLastLineNo(): Integer    begin        TimeSheetLine.Reset();        TimeSheetLine.SetRange("Time Sheet No.", "No.");        if TimeSheetLine.FindLast() then;        exit(TimeSheetLine."Line No.");    end;    procedure FindLastTimeSheetNo(FilterFieldNo: Integer): Code[20]    begin        Reset();        SetCurrentKey("Resource No.", "Starting Date");        TimeSheetMgt.FilterTimeSheets(Rec, FilterFieldNo);        SetFilter("Starting Date", '%1..', WorkDate());        if FindFirst() then            exit("No.");        SetRange("Starting Date");        SetRange("Ending Date");        if FindLast() then            exit("No.");        Error(Text002);    end;    procedure FindCurrentTimeSheetNo(FilterFieldNo: Integer): Code[20]    begin        Reset();        SetCurrentKey("Resource No.", "Starting Date");        TimeSheetMgt.FilterTimeSheets(Rec, FilterFieldNo, true);        if Rec.IsEmpty then            Error(Text002);        SetFilter("Starting Date", '..%1', WorkDate());        if FindLast() then            exit("No.");    end;    procedure FindTimeSheetList(FilterFieldNo: Integer): Code[20]    begin        Reset();        SetCurrentKey("Resource No.", "Starting Date");        TimeSheetMgt.FilterTimeSheets(Rec, FilterFieldNo);    end;    local procedure AddToMyTimeSheets(UserID: Code[50])    var        MyTimeSheets: Record "My Time Sheets";    begin        MyTimeSheets.Init();        MyTimeSheets."User ID" := UserId;        MyTimeSheets."Time Sheet No." := "No.";        MyTimeSheets."Start Date" := "Starting Date";        MyTimeSheets."End Date" := "Ending Date";        MyTimeSheets.Comment := Comment;        MyTimeSheets.Insert();    end;    local procedure RemoveFromMyTimeSheets()    var        MyTimeSheets: Record "My Time Sheets";    begin        MyTimeSheets.SetRange("Time Sheet No.", "No.");        if MyTimeSheets.FindFirst() then            MyTimeSheets.DeleteAll();    end;    local procedure CheckResourcePrivacyBlocked(Resource: Record Resource)    begin        if Resource."Privacy Blocked" then            Error(PrivacyBlockedErr, Resource."No.");    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckTimeSheetLine(TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnValidateResourceNoOnBeforeTestFields(Resource: Record Resource; var IsHandled: Boolean)    begin    end;}