Table 5510 Employee Time Reg Buffer
src/Layers/W1/BaseApp/Integration/Graph/EmployeeTimeRegBuffer.Table.al423 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.Integration.Graph;using Microsoft.Foundation.UOM;using Microsoft.HumanResources.Employee;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Resources.Resource;using Microsoft.Projects.TimeSheet;using System.Utilities;table 5510 "Employee Time Reg Buffer"{ Caption = 'Employee Time Reg Buffer'; ReplicateData = false; TableType = Temporary; DataClassification = CustomerContent; fields { field(2; "Line No"; Integer) { Caption = 'Line No'; DataClassification = SystemMetadata; } field(3; Date; Date) { Caption = 'Date'; DataClassification = SystemMetadata; NotBlank = true; } field(6; "Job No."; Code[20]) { DataClassification = SystemMetadata; TableRelation = "Job"; } field(7; "Job Task No."; Code[20]) { DataClassification = SystemMetadata; TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No.")); } field(9; "Cause of Absence Code"; Code[10]) { DataClassification = SystemMetadata; } field(15; Quantity; Decimal) { AutoFormatType = 0; Caption = 'Quantity'; DataClassification = SystemMetadata; NotBlank = true; } field(20; Status; Enum "Employee Time Reg. Status") { Caption = 'Status'; DataClassification = SystemMetadata; } field(21; "Employee No"; Code[20]) { Caption = 'Employee No'; DataClassification = SystemMetadata; } field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; DataClassification = SystemMetadata; } field(5407; "Unit of Measure Code"; Code[10]) { Caption = 'Unit of Measure Code'; DataClassification = SystemMetadata; TableRelation = "Unit of Measure"; ValidateTableRelation = false; } field(7999; "Employee Id"; Guid) { Caption = 'Employee Id'; DataClassification = SystemMetadata; NotBlank = true; trigger OnValidate() var Employee: Record Employee; Resource: Record Resource; begin if not Employee.GetBySystemId(Rec."Employee Id") then Error(CouldNotFindEmployeeErr); GraphMgtTimeRegistration.InitUserSetup(); if not Resource.Get(Employee."Resource No.") then begin GraphMgtTimeRegistration.CreateResourceToUseTimeSheet(Resource); Employee.Validate("Resource No.", Resource."No."); Employee.Modify(); end else GraphMgtTimeRegistration.ModifyResourceToUseTimeSheet(Resource); end; } field(8000; Id; Guid) { Caption = 'Id'; DataClassification = SystemMetadata; Editable = false; } field(8001; "Last Modified Date Time"; DateTime) { Caption = 'Last Modified Date Time'; DataClassification = SystemMetadata; Editable = false; } field(9032; "Unit of Measure Id"; Guid) { Caption = 'Unit of Measure Id'; DataClassification = SystemMetadata; } field(8002; "Job Id"; Guid) { Caption = 'Project Id'; DataClassification = SystemMetadata; } } keys { key(Key1; Id) { Clustered = true; } } fieldgroups { } trigger OnInsert() begin if not IsTemporary then Error(RecordMustBeTemporaryErr); end; var GraphMgtTimeRegistration: Codeunit "Graph Mgt - Time Registration"; CouldNotFindEmployeeErr: Label 'The employee cannot be found.', Locked = true; RecordMustBeTemporaryErr: Label 'Employee Time Reg Buffer must be used as a temporary record.', Locked = true; FiltersMustBeSpecifiedErr: Label 'A filter must be specified. The filter could be for the date, employeeId or id.', Locked = true; DateFilterIsInvalidErr: Label 'The date filter is invalid. The date filter must be a valid range with maximum %1 days.', Locked = true; EmployeeFilterOneEmployeeOnlyErr: Label 'You can only search for one employee using the employee filter.'; [Scope('Cloud')] procedure PropagateInsert() var Employee: Record Employee; TimeSheetLine: Record "Time Sheet Line"; TimeSheetDetail: Record "Time Sheet Detail"; Resource: Record Resource; UnitOfMeasure: Record "Unit of Measure"; TimeSheetHeaderNo: Code[20]; begin if not IsTemporary then Error(RecordMustBeTemporaryErr); Employee.Get("Employee No"); TimeSheetHeaderNo := GraphMgtTimeRegistration.GetTimeSheetHeader(Employee."Resource No.", CalcDate('<-CW>', Date)); GraphMgtTimeRegistration.GetTimeSheetLineWithEmptyDate(TimeSheetLine, TimeSheetHeaderNo, Date); GraphMgtTimeRegistration.AddTimeSheetDetailWithDimensionSetAndJob(TimeSheetDetail, TimeSheetLine, Date, Quantity, "Dimension Set ID", "Job Id"); TimeSheetDetail.Validate("Job Task No.", "Job Task No."); TransferFields(TimeSheetDetail, true); Id := TimeSheetDetail.SystemId; "Employee No" := Employee."No."; "Employee Id" := Employee.SystemId; if Resource.Get(Employee."Resource No.") then "Unit of Measure Code" := Resource."Base Unit of Measure"; if UnitOfMeasure.Get(Resource."Base Unit of Measure") then "Unit of Measure Id" := UnitOfMeasure.SystemId; end; [Scope('Cloud')] procedure PropagateModify() var TimeSheetDetail: Record "Time Sheet Detail"; RecordModified: Boolean; begin if Quantity <> xRec.Quantity then begin TimeSheetDetail.GetBySystemId(Rec.Id); TimeSheetDetail.Validate(Quantity, Quantity); RecordModified := true; end; if "Dimension Set ID" <> xRec."Dimension Set ID" then begin if not RecordModified then begin TimeSheetDetail.GetBySystemId(Id); TimeSheetDetail.FindFirst(); RecordModified := true; end; TimeSheetDetail.Validate("Dimension Set ID", "Dimension Set ID"); end; if "Job Id" <> xRec."Job Id" then begin if not RecordModified then begin TimeSheetDetail.GetBySystemId(Id); RecordModified := true; end; TimeSheetDetail.Validate("Job Id", "Job Id"); TimeSheetDetail.Validate("Job No.", "Job No."); end; if RecordModified then begin TimeSheetDetail.Modify(true); TransferFields(TimeSheetDetail); Id := TimeSheetDetail.SystemId; end; end; [Scope('Cloud')] procedure PropagateDelete() var TimeSheetDetail: Record "Time Sheet Detail"; begin TimeSheetDetail.GetBySystemId(Id); TimeSheetDetail.Delete(true); end; [Scope('Cloud')] procedure LoadRecords(IdFilter: Text; DateFilter: Text; EmployeeIdFilter: Text) var Employee: Record Employee; Calendar: Record Date; FirstDate: Date; LastDate: Date; begin if IdFilter <> '' then begin LoadRecordFromId(IdFilter); exit; end; if EmployeeIdFilter <> '' then begin Employee.SetFilter(SystemId, EmployeeIdFilter); if Employee.Count > 1 then Error(EmployeeFilterOneEmployeeOnlyErr); LoadRecordsFromEmployee(EmployeeIdFilter); exit; end; if DateFilter <> '' then begin Calendar.SetRange("Period Type", Calendar."Period Type"::Date); Calendar.SetFilter("Period Start", DateFilter); if Calendar.FindFirst() then begin FirstDate := Calendar."Period Start"; Calendar.FindLast(); LastDate := Calendar."Period Start"; end else Error(DateFilterIsInvalidErr, MaxDateFilterRange()); if LastDate - FirstDate > MaxDateFilterRange() then Error(DateFilterIsInvalidErr, MaxDateFilterRange()); LoadRecordsFromTSDetails(DateFilter); exit; end; Error(FiltersMustBeSpecifiedErr); end; [Scope('OnPrem')] procedure LoadRecordFromId(IdFilter: Text) var TimeSheetHeader: Record "Time Sheet Header"; TimeSheetLine: Record "Time Sheet Line"; TimeSheetDetail: Record "Time Sheet Detail"; Employee: Record Employee; Resource: Record Resource; UnitOfMeasure: Record "Unit of Measure"; begin TimeSheetDetail.SetFilter(SystemId, IdFilter); if not TimeSheetDetail.FindFirst() then exit; TimeSheetLine.Get(TimeSheetDetail."Time Sheet No.", TimeSheetDetail."Time Sheet Line No."); if TimeSheetLine.Type <> TimeSheetLine.Type::Resource then exit; TimeSheetHeader.Get(TimeSheetDetail."Time Sheet No."); Employee.SetRange("Resource No.", TimeSheetHeader."Resource No."); if not Employee.FindFirst() or not Resource.Get(TimeSheetHeader."Resource No.") then exit; TransferFields(TimeSheetDetail, true); Id := TimeSheetDetail.SystemId; "Line No" := TimeSheetDetail."Time Sheet Line No."; "Employee No" := Employee."No."; "Employee Id" := Employee.SystemId; if UnitOfMeasure.Get(Resource."Base Unit of Measure") then begin "Unit of Measure Code" := UnitOfMeasure.Code; "Unit of Measure Id" := UnitOfMeasure.SystemId; end; Insert(true); end; [Scope('OnPrem')] procedure LoadRecordsFromEmployee(EmployeeIdFilter: Text) var TimeSheetHeader: Record "Time Sheet Header"; TimeSheetLine: Record "Time Sheet Line"; TimeSheetDetail: Record "Time Sheet Detail"; Employee: Record Employee; Resource: Record Resource; UnitOfMeasure: Record "Unit of Measure"; UnitOfMeasureFound: Boolean; begin Employee.SetFilter(SystemId, EmployeeIdFilter); if not Employee.FindFirst() then exit; if not Resource.Get(Employee."Resource No.") then exit; TimeSheetHeader.SetRange("Resource No.", Resource."No."); if not TimeSheetHeader.FindSet() then exit; if UnitOfMeasure.Get(Resource."Base Unit of Measure") then UnitOfMeasureFound := true; repeat TimeSheetLine.SetRange("Time Sheet No.", TimeSheetHeader."No."); TimeSheetLine.SetRange(Type, TimeSheetLine.Type::Resource); if TimeSheetLine.FindSet() then repeat TimeSheetDetail.SetRange("Time Sheet No.", TimeSheetHeader."No."); TimeSheetDetail.SetRange("Time Sheet Line No.", TimeSheetLine."Line No."); if TimeSheetDetail.FindSet() then repeat TransferFields(TimeSheetDetail, true); Id := TimeSheetDetail.SystemId; "Line No" := TimeSheetDetail."Time Sheet Line No."; "Employee No" := Employee."No."; "Employee Id" := Employee.SystemId; if UnitOfMeasureFound then begin "Unit of Measure Id" := UnitOfMeasure.SystemId; "Unit of Measure Code" := UnitOfMeasure.Code; end; Insert(true); until TimeSheetDetail.Next() = 0; until TimeSheetLine.Next() = 0; until TimeSheetHeader.Next() = 0; end; [Scope('OnPrem')] procedure LoadRecordsFromTSDetails(DateFilter: Text) var TimeSheetHeader: Record "Time Sheet Header"; TimeSheetLine: Record "Time Sheet Line"; TimeSheetDetail: Record "Time Sheet Detail"; Employee: Record Employee; Resource: Record Resource; UnitOfMeasure: Record "Unit of Measure"; PrevTimeSheetHeaderNo: Code[20]; HeaderFound: Boolean; PrevResourceNo: Code[20]; ResourceFound: Boolean; UnitOfMeasureFound: Boolean; begin TimeSheetDetail.SetFilter(Date, DateFilter); if not TimeSheetDetail.FindSet() then exit; PrevResourceNo := ''; PrevTimeSheetHeaderNo := ''; repeat TimeSheetLine.Get(TimeSheetDetail."Time Sheet No.", TimeSheetDetail."Time Sheet Line No."); if TimeSheetLine.Type = TimeSheetLine.Type::Resource then begin HeaderFound := false; if PrevTimeSheetHeaderNo = TimeSheetDetail."Time Sheet No." then HeaderFound := true else if TimeSheetHeader.Get(TimeSheetDetail."Time Sheet No.") then begin PrevTimeSheetHeaderNo := TimeSheetHeader."No."; HeaderFound := true; end; if HeaderFound then begin ResourceFound := false; Employee.SetRange("Resource No.", TimeSheetHeader."Resource No."); if PrevResourceNo = TimeSheetHeader."Resource No." then ResourceFound := true else if Employee.FindFirst() and Resource.Get(TimeSheetHeader."Resource No.") then begin PrevResourceNo := TimeSheetHeader."Resource No."; ResourceFound := true; UnitOfMeasureFound := false; if UnitOfMeasure.Get(Resource."Base Unit of Measure") then UnitOfMeasureFound := true; end; if ResourceFound then begin TransferFields(TimeSheetDetail, true); Id := TimeSheetDetail.SystemId; "Line No" := TimeSheetDetail."Time Sheet Line No."; "Employee No" := Employee."No."; "Employee Id" := Employee.SystemId; if UnitOfMeasureFound then begin "Unit of Measure Code" := UnitOfMeasure.Code; "Unit of Measure Id" := UnitOfMeasure.SystemId; end; Insert(true); end; end; end; until TimeSheetDetail.Next() = 0; end; local procedure MaxDateFilterRange(): Integer begin exit(70); end;}