Page 974 Time Sheet Lines Subform
src/Layers/W1/BaseApp/Projects/TimeSheet/TimeSheetLinesSubform.Page.al826 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.Finance.Dimension;using System.Environment;using System.Utilities;page 974 "Time Sheet Lines Subform"{ AutoSplitKey = true; Caption = 'Lines'; DelayedInsert = true; LinksAllowed = false; PageType = ListPart; SourceTable = "Time Sheet Line"; layout { area(Content) { repeater(Control1) { FreezeColumn = Status; ShowCaption = false; field(Type; Rec.Type) { ApplicationArea = Jobs; Editable = AllowEdit; trigger OnValidate() begin UpdateControls(); CurrPage.Update(true); end; } field(Status; Rec.Status) { ApplicationArea = Jobs; Style = Unfavorable; StyleExpr = Rec."Total Quantity" = 0; Width = 4; } field(Description; Rec.Description) { ApplicationArea = Jobs; Editable = AllowEdit; trigger OnAssistEdit() begin if Rec."Line No." = 0 then exit; Rec.ShowLineDetails(false); CurrPage.Update(false); end; trigger OnValidate() begin CurrPage.SaveRecord(); end; } field("Job No."; Rec."Job No.") { ApplicationArea = Jobs; Editable = AllowEdit; Visible = JobFieldsVisible; trigger OnValidate() begin CurrPage.SaveRecord(); end; } field("Job Task No."; Rec."Job Task No.") { ApplicationArea = Jobs; Editable = AllowEdit; Visible = JobFieldsVisible; trigger OnValidate() begin CurrPage.SaveRecord(); end; } field("Cause of Absence Code"; Rec."Cause of Absence Code") { ApplicationArea = Jobs; Editable = AllowEdit; Visible = AbsenceCauseVisible; trigger OnValidate() begin CurrPage.SaveRecord(); end; } field(Chargeable; Rec.Chargeable) { ApplicationArea = Jobs; Editable = AllowEdit; Visible = ChargeableVisible; trigger OnValidate() begin CurrPage.SaveRecord(); end; } field("Work Type Code"; Rec."Work Type Code") { ApplicationArea = Jobs; Editable = AllowEdit; Visible = WorkTypeCodeVisible; trigger OnValidate() begin CurrPage.SaveRecord(); end; } field("Assembly Order No."; Rec."Assembly Order No.") { ApplicationArea = Assembly; Visible = false; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(1); end; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(2); end; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(3); end; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(4); end; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(5); end; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(6); end; } 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; Editable = AllowEdit; Width = 3; trigger OnValidate() begin CurrPage.SaveRecord(); ValidateQuantity(7); end; } field("Total Quantity"; Rec."Total Quantity") { ApplicationArea = Jobs; AutoFormatType = 0; Caption = 'Total'; DrillDown = false; DecimalPlaces = 0 : 2; Width = 3; } } 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 number of hours that are registered on the time sheet.'; Editable = false; DecimalPlaces = 0 : 2; } } } } actions { area(Processing) { group(Line) { Caption = 'Line'; action(Submit) { ApplicationArea = Jobs; Caption = '&Submit'; Image = ReleaseDoc; ShortCutKey = 'F9'; ToolTip = 'Submit the time sheet line for approval. Line must have a Type defined.'; Scope = Repeater; Gesture = RightSwipe; Enabled = SubmitLineEnabled; Visible = not ManagerTimeSheet; trigger OnAction() begin SubmitLines(); end; } action(ReopenSubmitted) { ApplicationArea = Jobs; Caption = '&Reopen'; Image = ReOpen; Scope = Repeater; Gesture = LeftSwipe; ToolTip = 'Reopen the time sheet line, for example, after it has been rejected. Line must have a Type defined. The approver of a time sheet has permission to approve, reject, or reopen a time sheet. The approver can also submit a time sheet for approval.'; Enabled = ReopenSubmittedLineEnabled; Visible = not ManagerTimeSheet; trigger OnAction() begin ReopenSubmittedLines(); end; } action(Approve) { ApplicationArea = Jobs; Caption = '&Approve'; Ellipsis = true; Image = ReleaseDoc; ToolTip = 'Approve the lines on the time sheet. Each line must have a Type defined.'; Scope = Repeater; Gesture = RightSwipe; Enabled = ApproveLineEnabled; Visible = ManagerTimeSheet; trigger OnAction() begin ApproveLines(); end; } action(Reject) { ApplicationArea = Jobs; Caption = 'Reject'; Image = Reject; ToolTip = 'Reject the lines on the time sheet. Each line must have a Type defined.'; Scope = Repeater; Gesture = RightSwipe; Enabled = RejectLineEnabled; Visible = ManagerTimeSheet; trigger OnAction() begin RejectLines(); end; } action(ReopenApproved) { ApplicationArea = Jobs; Caption = '&Reopen'; Image = ReOpen; Scope = Repeater; Gesture = LeftSwipe; ToolTip = 'Reopen the approved or rejected time sheet line. Line must have a Type defined.'; Enabled = ReopenApprovedLineEnabled; Visible = ManagerTimeSheet; trigger OnAction() begin ReopenApprovedLines(); end; } action("Time Sheet Allocation") { ApplicationArea = Jobs; Caption = 'Time Sheet Allocation'; Image = Allocate; ToolTip = 'Allocate posted hours among days of the week on a time sheet.'; Enabled = Rec.Posted; trigger OnAction() begin TimeAllocation(); end; } action("Activity &Details") { ApplicationArea = Jobs; Caption = 'Activity &Details'; Image = View; ShortCutKey = 'Shift+F7'; ToolTip = 'View the quantity of hours for each time sheet status.'; trigger OnAction() begin Rec.ShowLineDetails(false); end; } action(Dimensions) { AccessByPermission = TableData Dimension = R; ApplicationArea = Dimensions; Caption = 'Dimensions'; Image = Dimensions; ShortCutKey = 'Alt+D'; ToolTip = 'View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.'; trigger OnAction() var DimMgt: Codeunit DimensionManagement; begin Rec."Dimension Set ID" := DimMgt.EditDimensionSet(Rec."Dimension Set ID", DimensionCaptionTok); end; } action(LineComments) { ApplicationArea = Comments; Caption = 'Comments'; Image = ViewComments; RunObject = Page "Time Sheet 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; trigger OnOpenPage() begin TimeSheetMgt.CheckTimeSheetLineFieldsVisible(WorkTypeCodeVisible, JobFieldsVisible, ChargeableVisible, ServiceOrderNoVisible, AbsenceCauseVisible, AssemblyOrderNoVisible); end; trigger OnNewRecord(BelowxRec: Boolean) begin if (BelowxRec) and (Rec.Status = Rec.Status::Open) then Rec.Type := xRec.Type; end; var TimeSheetDetail: Record "Time Sheet Detail"; ColumnRecords: array[32] of Record Date; TimeSheetMgt: Codeunit "Time Sheet Management"; TimeSheetApprovalMgt: Codeunit "Time Sheet Approval Management"; RefActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject; NoOfColumns: Integer; ColumnCaption: array[32] of Text[1024]; UnitOfMeasureCode: Code[10]; WorkTypeCodeVisible, JobFieldsVisible, ChargeableVisible, AbsenceCauseVisible, AssemblyOrderNoVisible : Boolean; InvalidTypeErr: Label 'The type of time sheet line cannot be empty.'; DimensionCaptionTok: Label 'Dimensions'; protected var TimeSheetHeader: Record "Time Sheet Header"; CellData: array[32] of Decimal; ManagerTimeSheet: Boolean; SubmitLineEnabled: Boolean; ReopenSubmittedLineEnabled: Boolean; ApproveLineEnabled: Boolean; RejectLineEnabled: Boolean; ReopenApprovedLineEnabled: Boolean; AllowEdit: Boolean; ServiceOrderNoVisible: Boolean; procedure SetManagerTimeSheetMode() begin ManagerTimeSheet := true; end; procedure SetColumns(TimeSheetNo: Code[20]) var Calendar: Record Date; begin Clear(ColumnCaption); Clear(ColumnRecords); Clear(Calendar); Clear(NoOfColumns); GetTimeSheetHeader(TimeSheetNo); TimeSheetHeader.CalcFields("Unit of Measure"); UnitOfMeasureCode := TimeSheetHeader."Unit of Measure"; Calendar.SetRange("Period Type", Calendar."Period Type"::Date); Calendar.SetRange("Period Start", TimeSheetHeader."Starting Date", TimeSheetHeader."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 GetTimeSheetHeader(TimeSheetNo: Code[20]) begin TimeSheetHeader.Get(TimeSheetNo); OnAfterGetTimeSheetHeader(TimeSheetHeader); end; local procedure UpdateControls() var i: Integer; begin i := 0; while i < NoOfColumns do begin i := i + 1; if (Rec."Line No." <> 0) and TimeSheetDetail.Get( Rec."Time Sheet No.", Rec."Line No.", ColumnRecords[i]."Period Start") then CellData[i] := TimeSheetDetail.Quantity else CellData[i] := 0; end; AllowEdit := Rec.Status in [Rec.Status::Open, Rec.Status::Rejected]; SubmitLineEnabled := (Rec.Status = Rec.Status::Open) and (Rec.Type <> Rec.Type::" "); ReopenSubmittedLineEnabled := (Rec.Status in [Rec.Status::Submitted, Rec.Status::Rejected]) and (Rec.Type <> Rec.Type::" "); ApproveLineEnabled := (Rec.Status = Rec.Status::Submitted) and (Rec.Type <> Rec.Type::" "); RejectLineEnabled := (Rec.Status = Rec.Status::Submitted) and (Rec.Type <> Rec.Type::" "); ReopenApprovedLineEnabled := (Rec.Status in [Rec.Status::Approved, Rec.Status::Rejected]) and (Rec.Type <> Rec.Type::" "); end; procedure ValidateQuantity(ColumnNo: Integer) begin if (CellData[ColumnNo] <> 0) and (Rec.Type = Rec.Type::" ") then Error(InvalidTypeErr); if TimeSheetDetail.Get( Rec."Time Sheet No.", Rec."Line No.", ColumnRecords[ColumnNo]."Period Start") then begin if CellData[ColumnNo] <> TimeSheetDetail.Quantity then TestTimeSheetLineStatus(); if CellData[ColumnNo] = 0 then TimeSheetDetail.Delete() else begin TimeSheetDetail.Quantity := CellData[ColumnNo]; OnValidateQuantityOnBeforeModifyTimeSheetDetail(TimeSheetDetail, Rec); TimeSheetDetail.Modify(true); end; end else if CellData[ColumnNo] <> 0 then begin TestTimeSheetLineStatus(); TimeSheetDetail.Init(); TimeSheetDetail.CopyFromTimeSheetLine(Rec); TimeSheetDetail.Date := ColumnRecords[ColumnNo]."Period Start"; TimeSheetDetail.Quantity := CellData[ColumnNo]; TimeSheetDetail.Insert(true); end; Rec.CalcFields("Total Quantity"); CurrPage.Update(false); end; local procedure GetTimeSheetTotalQuantity(): Decimal begin TimeSheetHeader.Get(Rec."Time Sheet No."); TimeSheetHeader.CalcFields(Quantity); exit(TimeSheetHeader.Quantity); end; procedure Process(ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject; ProcessAll: Boolean) var TimeSheetLine: Record "Time Sheet Line"; TempTimeSheetLine: Record "Time Sheet Line" temporary; TimeSheetAction: Enum "Time Sheet Action"; begin CurrPage.SaveRecord(); FilterLines(TimeSheetLine, ActionType, ProcessAll); TimeSheetMgt.CopyFilteredTimeSheetLinesToBuffer(TimeSheetLine, TempTimeSheetLine); OnProcessOnBeforeProcessTimeSheetLines(TimeSheetLine, TempTimeSheetLine, ActionType, ProcessAll); if TimeSheetLine.FindSet() then repeat TimeSheetApprovalMgt.ProcessAction(TimeSheetLine, ActionType); until TimeSheetLine.Next() = 0 else begin case ActionType of ActionType::Submit: TimeSheetAction := TimeSheetAction::Submit; ActionType::Approve: TimeSheetAction := TimeSheetAction::Approve; ActionType::Reject: TimeSheetAction := TimeSheetAction::Reject; ActionType::ReopenSubmitted: TimeSheetAction := TimeSheetAction::"Reopen Submitted"; ActionType::ReopenApproved: TimeSheetAction := TimeSheetAction::"Reopen Approved"; end; TimeSheetApprovalMgt.NoTimeSheetLinesToProcess(TimeSheetAction); end; OnAfterProcess(TempTimeSheetLine, ActionType, ProcessAll); CurrPage.Update(true); end; local procedure FilterLines(var TimeSheetLine: Record "Time Sheet Line"; ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject; ProcessAll: Boolean) begin if not ProcessAll then begin CurrPage.SetSelectionFilter(TimeSheetLine); 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; end else FilterAllLines(TimeSheetLine, ActionType); OnAfterFilterLines(TimeSheetLine, ActionType, ProcessAll); end; local procedure TestTimeSheetLineStatus() var TimeSheetLine: Record "Time Sheet Line"; begin TimeSheetLine.Get(Rec."Time Sheet No.", Rec."Line No."); TimeSheetLine.TestStatus(); end; local procedure SubmitLines() var IsHandled: Boolean; begin IsHandled := false; OnBeforeSubmitLines(Rec, IsHandled); if IsHandled then exit; if IsPhone() then TimeSheetApprovalMgt.SubmitIfConfirmed(Rec) else case ShowDialog(RefActionType::Submit) of 1: Process(RefActionType::Submit, true); 2: Process(RefActionType::Submit, false); end; end; local procedure ApproveLines() var IsHandled: Boolean; begin IsHandled := false; OnBeforeApproveLines(Rec, IsHandled); if IsHandled then exit; if IsPhone() then TimeSheetApprovalMgt.ApproveIfConfirmed(Rec) else case ShowDialog(RefActionType::Approve) of 1: Process(RefActionType::Approve, true); 2: Process(RefActionType::Approve, false); end; end; local procedure RejectLines() var IsHandled: Boolean; begin IsHandled := false; OnBeforeRejectLines(Rec, IsHandled); if IsHandled then exit; if IsPhone() then TimeSheetApprovalMgt.RejectIfConfirmed(Rec) else case ShowDialog(RefActionType::Reject) of 1: Process(RefActionType::Reject, true); 2: Process(RefActionType::Reject, false); end; end; local procedure ReopenSubmittedLines() var IsHandled: Boolean; begin IsHandled := false; OnBeforeReopenSubmittedLines(Rec, IsHandled); if IsHandled then exit; if IsPhone() then TimeSheetApprovalMgt.ReopenSubmittedIfConfirmed(Rec) else case ShowDialog(RefActionType::ReopenSubmitted) of 1: Process(RefActionType::ReopenSubmitted, true); 2: Process(RefActionType::ReopenSubmitted, false); end; end; local procedure ReopenApprovedLines() var IsHandled: Boolean; begin IsHandled := false; OnBeforeReopenApprovedLines(Rec, IsHandled); if IsHandled then exit; if IsPhone() then TimeSheetApprovalMgt.ReopenApprovedIfConfirmed(Rec) else case ShowDialog(RefActionType::ReopenApproved) of 1: Process(RefActionType::ReopenApproved, true); 2: Process(RefActionType::ReopenApproved, false); end; end; local procedure TimeAllocation() var TimeSheetAllocation: Page "Time Sheet Allocation"; AllocatedQty: array[7] of Decimal; begin Rec.TestField(Posted, true); Rec.CalcFields("Total Quantity"); TimeSheetAllocation.InitParameters(Rec."Time Sheet No.", Rec."Line No.", Rec."Total Quantity"); if TimeSheetAllocation.RunModal() = ACTION::OK then begin TimeSheetAllocation.GetAllocation(AllocatedQty); TimeSheetMgt.UpdateTimeAllocation(Rec, AllocatedQty); end; end; local procedure GetDialogText(ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject): Text var TimeSheetLine: Record "Time Sheet Line"; begin FilterAllLines(TimeSheetLine, ActionType); exit(TimeSheetApprovalMgt.GetCommonTimeSheetActionDialogText(ActionType, TimeSheetLine.Count())); end; local procedure FilterAllLines(var TimeSheetLine: Record "Time Sheet Line"; ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject) begin TimeSheetLine.CopyFilters(Rec); TimeSheetMgt.FilterAllTimeSheetLines(TimeSheetLine, ActionType); end; local procedure IsPhone(): Boolean var ClientTypeManagement: Codeunit "Client Type Management"; begin exit(ClientTypeManagement.GetCurrentClientType() = CLIENTTYPE::Phone); end; local procedure ShowDialog(ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject): Integer begin exit(StrMenu(GetDialogText(ActionType), 2, TimeSheetApprovalMgt.GetCommonTimeSheetDialogInstruction(ActionType))); end; [IntegrationEvent(false, false)] local procedure OnAfterGetTimeSheetHeader(var TimeSheetHeader: Record "Time Sheet Header"); begin end; [IntegrationEvent(false, false)] local procedure OnAfterFilterLines(var TimeSheetLine: Record "Time Sheet Line"; ActionType: Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject; ProcessAll: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnAfterProcess(var TimeSheetLine: Record "Time Sheet Line"; "Action": Option "Submit Selected","Submit All","Reopen Selected","Reopen All"; ProcessAll: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeReopenSubmittedLines(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeReopenApprovedLines(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSubmitLines(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeApproveLines(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRejectLines(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean); begin end; [IntegrationEvent(true, false)] local procedure OnValidateQuantityOnBeforeModifyTimeSheetDetail(var TimeSheetDetail: Record "Time Sheet Detail"; TimeSheetLine: Record "Time Sheet Line"); begin end; [IntegrationEvent(true, false)] local procedure OnProcessOnBeforeProcessTimeSheetLines(var TimeSheetLine: Record "Time Sheet Line"; var TempTimeSheetLine: Record "Time Sheet Line" temporary; "Action": Option Submit,ReopenSubmitted,Approve,ReopenApproved,Reject; ProcessAll: Boolean) begin end;}