Page 9247 Abs. Overview by Period Matrix

Base Application, Microsoft.HumanResources.Absence

src/Layers/W1/BaseApp/HumanResources/Absence/AbsOverviewbyPeriodMatrix.Page.al524 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.HumanResources.Absence;using Microsoft.Foundation.Enums;using Microsoft.HumanResources.Employee;using System.Utilities;page 9247 "Abs. Overview by Period Matrix"{    Caption = 'Abs. Overview by Period Matrix';    DataCaptionExpression = '';    Editable = false;    LinksAllowed = false;    PageType = List;    SourceTable = Employee;    layout    {        area(content)        {            repeater(Control1)            {                ShowCaption = false;                field("No."; Rec."No.")                {                    ApplicationArea = BasicHR;                }                field("Full Name"; Rec.FullName())                {                    ApplicationArea = BasicHR;                    Caption = 'Full Name';                    ToolTip = 'Specifies the name of resource.';                }                field(Field1; MATRIX_CellData[1])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[1];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(1);                    end;                }                field(Field2; MATRIX_CellData[2])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[2];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(2);                    end;                }                field(Field3; MATRIX_CellData[3])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[3];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(3);                    end;                }                field(Field4; MATRIX_CellData[4])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[4];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(4);                    end;                }                field(Field5; MATRIX_CellData[5])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[5];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(5);                    end;                }                field(Field6; MATRIX_CellData[6])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[6];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(6);                    end;                }                field(Field7; MATRIX_CellData[7])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[7];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(7);                    end;                }                field(Field8; MATRIX_CellData[8])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[8];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(8);                    end;                }                field(Field9; MATRIX_CellData[9])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[9];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(9);                    end;                }                field(Field10; MATRIX_CellData[10])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[10];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(10);                    end;                }                field(Field11; MATRIX_CellData[11])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[11];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(11);                    end;                }                field(Field12; MATRIX_CellData[12])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[12];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(12);                    end;                }                field(Field13; MATRIX_CellData[13])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[13];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(13);                    end;                }                field(Field14; MATRIX_CellData[14])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[14];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(14);                    end;                }                field(Field15; MATRIX_CellData[15])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[15];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(15);                    end;                }                field(Field16; MATRIX_CellData[16])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[16];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(16);                    end;                }                field(Field17; MATRIX_CellData[17])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[17];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(17);                    end;                }                field(Field18; MATRIX_CellData[18])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[18];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(18);                    end;                }                field(Field19; MATRIX_CellData[19])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[19];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(19);                    end;                }                field(Field20; MATRIX_CellData[20])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[20];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(20);                    end;                }                field(Field21; MATRIX_CellData[21])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[21];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(21);                    end;                }                field(Field22; MATRIX_CellData[22])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[22];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(22);                    end;                }                field(Field23; MATRIX_CellData[23])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[23];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(23);                    end;                }                field(Field24; MATRIX_CellData[24])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[24];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(24);                    end;                }                field(Field25; MATRIX_CellData[25])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[25];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(25);                    end;                }                field(Field26; MATRIX_CellData[26])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[26];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(26);                    end;                }                field(Field27; MATRIX_CellData[27])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[27];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(27);                    end;                }                field(Field28; MATRIX_CellData[28])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[28];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(28);                    end;                }                field(Field29; MATRIX_CellData[29])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[29];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(29);                    end;                }                field(Field30; MATRIX_CellData[30])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[30];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(30);                    end;                }                field(Field31; MATRIX_CellData[31])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[31];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(31);                    end;                }                field(Field32; MATRIX_CellData[32])                {                    AutoFormatType = 0;                    ApplicationArea = BasicHR;                    BlankZero = true;                    CaptionClass = '3,' + MATRIX_ColumnCaption[32];                    DecimalPlaces = 0 : 5;                    trigger OnDrillDown()                    begin                        MatrixOnDrillDown(32);                    end;                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    var        MATRIX_CurrentColumnOrdinal: Integer;        MATRIX_NoOfColumns: Integer;    begin        MATRIX_CurrentColumnOrdinal := 1;        MATRIX_NoOfColumns := ArrayLen(MATRIX_CellData);        while MATRIX_CurrentColumnOrdinal <= MATRIX_NoOfColumns do begin            MATRIX_OnAfterGetRecord(MATRIX_CurrentColumnOrdinal);            MATRIX_CurrentColumnOrdinal := MATRIX_CurrentColumnOrdinal + 1;        end;    end;    var        MatrixRecords: array[32] of Record Date;        AbsenceAmountType: Enum "Analysis Amount Type";        MATRIX_CellData: array[32] of Decimal;        MATRIX_ColumnCaption: array[32] of Text[1024];        CauseOfAbsenceFilter: Code[10];    local procedure SetDateFilter(ColumnID: Integer)    begin        if AbsenceAmountType = AbsenceAmountType::"Net Change" then            if MatrixRecords[ColumnID]."Period Start" = MatrixRecords[ColumnID]."Period End" then                Rec.SetRange("Date Filter", MatrixRecords[ColumnID]."Period Start")            else                Rec.SetRange("Date Filter", MatrixRecords[ColumnID]."Period Start", MatrixRecords[ColumnID]."Period End")        else            Rec.SetRange("Date Filter", 0D, MatrixRecords[ColumnID]."Period End");    end;    procedure LoadMatrix(NewMatrixColumns: array[32] of Text[1024]; var NewMatrixRecords: array[32] of Record Date; NewCauseOfAbsenceFilter: Code[10]; NewAmountType: Enum "Analysis Amount Type")    var        i: Integer;    begin        CopyArray(MATRIX_ColumnCaption, NewMatrixColumns, 1);        for i := 1 to ArrayLen(MatrixRecords) do            MatrixRecords[i].Copy(NewMatrixRecords[i]);        CauseOfAbsenceFilter := NewCauseOfAbsenceFilter;        AbsenceAmountType := NewAmountType;    end;    local procedure MatrixOnDrillDown(ColumnID: Integer)    var        EmployeeAbsence: Record "Employee Absence";    begin        SetDateFilter(ColumnID);        EmployeeAbsence.SetRange("Employee No.", Rec."No.");        EmployeeAbsence.SetFilter("Cause of Absence Code", CauseOfAbsenceFilter);        EmployeeAbsence.SetFilter("From Date", Format(Rec."Date Filter"));        PAGE.Run(0, EmployeeAbsence);    end;    local procedure MATRIX_OnAfterGetRecord(ColumnID: Integer)    begin        SetDateFilter(ColumnID);        Rec.SetFilter("Cause of Absence Filter", CauseOfAbsenceFilter);        Rec.CalcFields("Total Absence (Base)");        MATRIX_CellData[ColumnID] := Rec."Total Absence (Base)";    end;}