Page 9213 ResGrp. Alloc. per Job Matrix
src/Layers/W1/BaseApp/Projects/Project/Analysis/ResGrpAllocperJobMatrix.Page.al630 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.Project.Analysis;using Microsoft.Foundation.UOM;using Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Planning;using System.Utilities;page 9213 "ResGrp. Alloc. per Job Matrix"{ Caption = 'Res. Gr. Allocated per Project Matrix'; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; PageType = List; SourceTable = Job; layout { area(content) { repeater(Control1) { ShowCaption = false; field("No."; Rec."No.") { ApplicationArea = Jobs; Editable = false; } field("Bill-to Name"; Rec."Bill-to Name") { ApplicationArea = Jobs; Editable = false; } field(Col1; MatrixCellData[1]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[1]; DrillDown = true; DrillDownPageID = "Job Planning Lines"; Editable = false; Visible = Col1Visible; trigger OnDrillDown() begin MatrixOnDrillDown(1); end; } field(Col2; MatrixCellData[2]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[2]; DrillDown = true; Editable = false; Visible = Col2Visible; trigger OnDrillDown() begin MatrixOnDrillDown(2); end; } field(Col3; MatrixCellData[3]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[3]; DrillDown = true; Editable = false; Visible = Col3Visible; trigger OnDrillDown() begin MatrixOnDrillDown(3); end; } field(Col4; MatrixCellData[4]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[4]; DrillDown = true; Editable = false; Visible = Col4Visible; trigger OnDrillDown() begin MatrixOnDrillDown(4); end; } field(Col5; MatrixCellData[5]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[5]; DrillDown = true; Editable = false; Visible = Col5Visible; trigger OnDrillDown() begin MatrixOnDrillDown(5); end; } field(Col6; MatrixCellData[6]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[6]; DrillDown = true; Editable = false; Visible = Col6Visible; trigger OnDrillDown() begin MatrixOnDrillDown(6); end; } field(Col7; MatrixCellData[7]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[7]; DrillDown = true; Editable = false; Visible = Col7Visible; trigger OnDrillDown() begin MatrixOnDrillDown(7); end; } field(Col8; MatrixCellData[8]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[8]; DrillDown = true; Editable = false; Visible = Col8Visible; trigger OnDrillDown() begin MatrixOnDrillDown(8); end; } field(Col9; MatrixCellData[9]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[9]; DrillDown = true; Editable = false; Visible = Col9Visible; trigger OnDrillDown() begin MatrixOnDrillDown(9); end; } field(Col10; MatrixCellData[10]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[10]; DrillDown = true; Editable = false; Visible = Col10Visible; trigger OnDrillDown() begin MatrixOnDrillDown(10); end; } field(Col11; MatrixCellData[11]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[11]; DrillDown = true; Editable = false; Visible = Col11Visible; trigger OnDrillDown() begin MatrixOnDrillDown(11); end; } field(Col12; MatrixCellData[12]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[12]; DrillDown = true; Editable = false; Visible = Col12Visible; trigger OnDrillDown() begin MatrixOnDrillDown(12); end; } field(Col13; MatrixCellData[13]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[13]; DrillDown = true; Editable = false; Visible = Col13Visible; trigger OnDrillDown() begin MatrixOnDrillDown(13); end; } field(Col14; MatrixCellData[14]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[14]; DrillDown = true; Editable = false; Visible = Col14Visible; trigger OnDrillDown() begin MatrixOnDrillDown(14); end; } field(Col15; MatrixCellData[15]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[15]; DrillDown = true; Editable = false; Visible = Col15Visible; trigger OnDrillDown() begin MatrixOnDrillDown(15); end; } field(Col16; MatrixCellData[16]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[16]; DrillDown = true; Editable = false; Visible = Col16Visible; trigger OnDrillDown() begin MatrixOnDrillDown(16); end; } field(Col17; MatrixCellData[17]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[17]; DrillDown = true; Editable = false; Visible = Col17Visible; trigger OnDrillDown() begin MatrixOnDrillDown(17); end; } field(Col18; MatrixCellData[18]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[18]; DrillDown = true; Editable = false; Visible = Col18Visible; trigger OnDrillDown() begin MatrixOnDrillDown(18); end; } field(Col19; MatrixCellData[19]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[19]; DrillDown = true; Editable = false; Visible = Col19Visible; trigger OnDrillDown() begin MatrixOnDrillDown(19); end; } field(Col20; MatrixCellData[20]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[20]; DrillDown = true; Editable = false; Visible = Col20Visible; trigger OnDrillDown() begin MatrixOnDrillDown(20); end; } field(Col21; MatrixCellData[21]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[21]; DrillDown = true; Editable = false; Visible = Col21Visible; trigger OnDrillDown() begin MatrixOnDrillDown(21); end; } field(Col22; MatrixCellData[22]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[22]; DrillDown = true; Editable = false; Visible = Col22Visible; trigger OnDrillDown() begin MatrixOnDrillDown(22); end; } field(Col23; MatrixCellData[23]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[23]; DrillDown = true; Editable = false; Visible = Col23Visible; trigger OnDrillDown() begin MatrixOnDrillDown(23); end; } field(Col24; MatrixCellData[24]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[24]; Visible = Col24Visible; trigger OnDrillDown() begin MatrixOnDrillDown(24); end; } field(Col25; MatrixCellData[25]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[25]; Visible = Col25Visible; trigger OnDrillDown() begin MatrixOnDrillDown(25); end; } field(Col26; MatrixCellData[26]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[26]; Visible = Col26Visible; trigger OnDrillDown() begin MatrixOnDrillDown(26); end; } field(Col27; MatrixCellData[27]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[27]; Visible = Col27Visible; trigger OnDrillDown() begin MatrixOnDrillDown(27); end; } field(Col28; MatrixCellData[28]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[28]; Visible = Col28Visible; trigger OnDrillDown() begin MatrixOnDrillDown(28); end; } field(Col29; MatrixCellData[29]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[29]; Visible = Col29Visible; trigger OnDrillDown() begin MatrixOnDrillDown(29); end; } field(Col30; MatrixCellData[30]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[30]; Visible = Col30Visible; trigger OnDrillDown() begin MatrixOnDrillDown(30); end; } field(Col31; MatrixCellData[31]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[31]; Visible = Col31Visible; trigger OnDrillDown() begin MatrixOnDrillDown(31); end; } field(Col32; MatrixCellData[32]) { ApplicationArea = All; CaptionClass = '3,' + MatrixColumnCaptions[32]; Visible = Col32Visible; trigger OnDrillDown() begin MatrixOnDrillDown(32); end; } } } } actions { } trigger OnAfterGetRecord() begin MatrixOnAfterGetRecord(); end; trigger OnInit() begin Col32Visible := true; Col31Visible := true; Col30Visible := true; Col29Visible := true; Col28Visible := true; Col27Visible := true; Col26Visible := true; Col25Visible := true; Col24Visible := true; Col23Visible := true; Col22Visible := true; Col21Visible := true; Col20Visible := true; Col19Visible := true; Col18Visible := true; Col17Visible := true; Col16Visible := true; Col15Visible := true; Col14Visible := true; Col13Visible := true; Col12Visible := true; Col11Visible := true; Col10Visible := true; Col9Visible := true; Col8Visible := true; Col7Visible := true; Col6Visible := true; Col5Visible := true; Col4Visible := true; Col3Visible := true; Col2Visible := true; Col1Visible := true; end; var MatrixColumnDateFilters: array[32] of Record Date; MatrixRec: Record "Job Planning Line"; UOMMgt: Codeunit "Unit of Measure Management"; MatrixColumnCaptions: array[32] of Text[100]; MatrixCellData: array[32] of Text[100]; MatrixCellQuantity: Decimal; Col1Visible: Boolean; Col2Visible: Boolean; Col3Visible: Boolean; Col4Visible: Boolean; Col5Visible: Boolean; Col6Visible: Boolean; Col7Visible: Boolean; Col8Visible: Boolean; Col9Visible: Boolean; Col10Visible: Boolean; Col11Visible: Boolean; Col12Visible: Boolean; Col13Visible: Boolean; Col14Visible: Boolean; Col15Visible: Boolean; Col16Visible: Boolean; Col17Visible: Boolean; Col18Visible: Boolean; Col19Visible: Boolean; Col20Visible: Boolean; Col21Visible: Boolean; Col22Visible: Boolean; Col23Visible: Boolean; Col24Visible: Boolean; Col25Visible: Boolean; Col26Visible: Boolean; Col27Visible: Boolean; Col28Visible: Boolean; Col29Visible: Boolean; Col30Visible: Boolean; Col31Visible: Boolean; Col32Visible: Boolean; procedure Load(var NewVerticalRec: Record Job; var NewHorizontalRec: Record "Job Planning Line"; NewMatrixColumnCaptions: array[32] of Text[100]; var NewMatrixDateFilters: array[32] of Record Date) begin Rec.Copy(NewVerticalRec); MatrixRec.Copy(NewHorizontalRec); CopyArray(MatrixColumnCaptions, NewMatrixColumnCaptions, 1); CopyArray(MatrixColumnDateFilters, NewMatrixDateFilters, 1); end; local procedure MatrixOnAfterGetRecord() var I: Integer; begin MatrixRec.Reset(); MatrixRec.SetRange(Type, MatrixRec.Type::Resource); MatrixRec.SetRange("Job No.", Rec."No."); MatrixRec.SetRange("Schedule Line", true); if Rec.GetFilter("Resource Gr. Filter") <> '' then MatrixRec.SetFilter("Resource Group No.", Rec.GetRangeMin("Resource Gr. Filter"), Rec.GetRangeMax("Resource Gr. Filter")); for I := 1 to ArrayLen(MatrixColumnDateFilters) do begin MatrixCellQuantity := 0; MatrixRec.SetRange( "Planning Date", MatrixColumnDateFilters[I]."Period Start", MatrixColumnDateFilters[I]."Period End"); OnMatrixOnAfterGetRecordOnBeforeMatrixRecLoop(MatrixRec, MatrixCellQuantity); if MatrixRec.Find('-') then repeat MatrixCellQuantity += Round(MatrixRec.Quantity * MatrixRec."Qty. per Unit of Measure", UOMMgt.QtyRndPrecision()) until MatrixRec.Next() = 0; if MatrixCellQuantity <> 0 then MatrixCellData[I] := Format(MatrixCellQuantity) else MatrixCellData[I] := ''; end; SetVisible(); end; local procedure MatrixOnDrillDown(Column: Integer) var JobPlanningLine: Record "Job Planning Line"; IsHandled: Boolean; begin JobPlanningLine.SetFilter("Resource Group No.", Rec.GetRangeMin("Resource Gr. Filter"), Rec.GetRangeMax("Resource Gr. Filter")); JobPlanningLine.SetRange( "Planning Date", MatrixColumnDateFilters[Column]."Period Start", MatrixColumnDateFilters[Column]."Period End"); JobPlanningLine.SetRange("Job No.", Rec."No."); JobPlanningLine.SetRange(Type, JobPlanningLine.Type::Resource); JobPlanningLine.SetRange("Schedule Line", true); IsHandled := false; OnAfterMatrixOnDrillDown(JobPlanningLine, IsHandled); if IsHandled then exit; PAGE.RunModal(PAGE::"Job Planning Lines", JobPlanningLine); end; procedure SetVisible() begin Col1Visible := MatrixColumnCaptions[1] <> ''; Col2Visible := MatrixColumnCaptions[2] <> ''; Col3Visible := MatrixColumnCaptions[3] <> ''; Col4Visible := MatrixColumnCaptions[4] <> ''; Col5Visible := MatrixColumnCaptions[5] <> ''; Col6Visible := MatrixColumnCaptions[6] <> ''; Col7Visible := MatrixColumnCaptions[7] <> ''; Col8Visible := MatrixColumnCaptions[8] <> ''; Col9Visible := MatrixColumnCaptions[9] <> ''; Col10Visible := MatrixColumnCaptions[10] <> ''; Col11Visible := MatrixColumnCaptions[11] <> ''; Col12Visible := MatrixColumnCaptions[12] <> ''; Col13Visible := MatrixColumnCaptions[13] <> ''; Col14Visible := MatrixColumnCaptions[14] <> ''; Col15Visible := MatrixColumnCaptions[15] <> ''; Col16Visible := MatrixColumnCaptions[16] <> ''; Col17Visible := MatrixColumnCaptions[17] <> ''; Col18Visible := MatrixColumnCaptions[18] <> ''; Col19Visible := MatrixColumnCaptions[19] <> ''; Col20Visible := MatrixColumnCaptions[20] <> ''; Col21Visible := MatrixColumnCaptions[21] <> ''; Col22Visible := MatrixColumnCaptions[22] <> ''; Col23Visible := MatrixColumnCaptions[23] <> ''; Col24Visible := MatrixColumnCaptions[24] <> ''; Col25Visible := MatrixColumnCaptions[25] <> ''; Col26Visible := MatrixColumnCaptions[26] <> ''; Col27Visible := MatrixColumnCaptions[27] <> ''; Col28Visible := MatrixColumnCaptions[28] <> ''; Col29Visible := MatrixColumnCaptions[29] <> ''; Col30Visible := MatrixColumnCaptions[30] <> ''; Col31Visible := MatrixColumnCaptions[31] <> ''; Col32Visible := MatrixColumnCaptions[32] <> ''; end; [IntegrationEvent(false, false)] local procedure OnAfterMatrixOnDrillDown(var JobPlanningLine: Record "Job Planning Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMatrixOnAfterGetRecordOnBeforeMatrixRecLoop(var JobPlanningLine: Record "Job Planning Line"; var MatrixCellQuantity: Decimal) begin end;}