Page 491 Items by Location
src/Layers/W1/BaseApp/Inventory/Analysis/ItemsbyLocation.Page.al218 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.Inventory.Analysis;using Microsoft.Finance.Analysis;using Microsoft.Foundation.Enums;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;page 491 "Items by Location"{ Caption = 'Items by Location'; DataCaptionExpression = ''; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; PageType = ListPlus; SaveValues = true; SourceTable = Item; SourceTableView = where(Type = const(Inventory)); layout { area(content) { group(Options) { Caption = 'Options'; field(ShowInTransit; ShowInTransit) { ApplicationArea = Location; Caption = 'Show Items in Transit'; ToolTip = 'Specifies the items in transit between locations.'; trigger OnValidate() begin ShowInTransitOnAfterValidate(); end; } field(ShowColumnName; ShowColumnName) { ApplicationArea = Location; Caption = 'Show Column Name'; ToolTip = 'Specifies that the names of columns are shown in the matrix window.'; trigger OnValidate() begin ShowColumnNameOnAfterValidate(); end; } field(MATRIX_CaptionRange; MATRIX_CaptionRange) { ApplicationArea = Location; Caption = 'Column Set'; Editable = false; ToolTip = 'Specifies the range of values that are displayed in the matrix window, for example, the total period. To change the contents of the field, choose Next Set or Previous Set.'; } } part(MatrixForm; "Items by Location Matrix") { ApplicationArea = Location; ShowFilter = false; } } } actions { area(processing) { action("Previous Set") { ApplicationArea = Location; Caption = 'Previous Set'; Image = PreviousSet; ToolTip = 'Go to the previous set of data.'; trigger OnAction() begin SetMatrixColumns("Matrix Page Step Type"::Previous); end; } action("Next Set") { ApplicationArea = Location; Caption = 'Next Set'; Image = NextSet; ToolTip = 'Go to the next set of data.'; trigger OnAction() begin SetMatrixColumns("Matrix Page Step Type"::Next); end; } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref("Previous Set_Promoted"; "Previous Set") { } actionref("Next Set_Promoted"; "Next Set") { } } } } trigger OnInit() begin TempMatrixLocation.GetLocationsIncludingUnspecifiedLocation(false, false); end; trigger OnOpenPage() begin SetMatrixColumns("Matrix Page Step Type"::Initial); end; var TempMatrixLocation: Record Location temporary; MatrixRecords: array[32] of Record Location; MatrixRecordRef: RecordRef; ShowColumnName: Boolean; ShowInTransit: Boolean; MATRIX_CaptionSet: array[32] of Text[80]; MATRIX_CaptionRange: Text; MATRIX_PKFirstRecInCurrSet: Text; MATRIX_CurrSetLength: Integer; UnspecifiedLocationCodeTxt: Label 'UNSPECIFIED', Comment = 'Code for unspecified location'; procedure SetMatrixColumns(StepType: Enum "Matrix Page Step Type") var MatrixMgt: Codeunit "Matrix Management"; CaptionFieldNo: Integer; CurrentMatrixRecordOrdinal: Integer; begin SetTempMatrixLocationFilters(); OnSetColumnsOnAfterSetTempMatrixLocationFilters(TempMatrixLocation); Clear(MATRIX_CaptionSet); Clear(MatrixRecords); CurrentMatrixRecordOrdinal := 1; MatrixRecordRef.GetTable(TempMatrixLocation); MatrixRecordRef.SetTable(TempMatrixLocation); if ShowColumnName then CaptionFieldNo := TempMatrixLocation.FieldNo(Name) else CaptionFieldNo := TempMatrixLocation.FieldNo(Code); MatrixMgt.GenerateMatrixData(MatrixRecordRef, StepType.AsInteger(), ArrayLen(MatrixRecords), CaptionFieldNo, MATRIX_PKFirstRecInCurrSet, MATRIX_CaptionSet, MATRIX_CaptionRange, MATRIX_CurrSetLength); if MATRIX_CaptionSet[1] = '' then begin MATRIX_CaptionSet[1] := UnspecifiedLocationCodeTxt; MATRIX_CaptionRange := StrSubstNo('%1%2', MATRIX_CaptionSet[1], MATRIX_CaptionRange); end; if MATRIX_CurrSetLength > 0 then begin TempMatrixLocation.SetPosition(MATRIX_PKFirstRecInCurrSet); TempMatrixLocation.Find(); repeat MatrixRecords[CurrentMatrixRecordOrdinal].Copy(TempMatrixLocation); CurrentMatrixRecordOrdinal := CurrentMatrixRecordOrdinal + 1; until (CurrentMatrixRecordOrdinal > MATRIX_CurrSetLength) or (TempMatrixLocation.Next() <> 1); end; OnSetColumnsOnBeforeUpdateMatrixSubform(MATRIX_CaptionSet, MatrixRecords, TempMatrixLocation, MATRIX_CurrSetLength); UpdateMatrixSubform(); end; local procedure SetTempMatrixLocationFilters() begin TempMatrixLocation.SetRange("Use As In-Transit", ShowInTransit); OnAfterSetTempMatrixLocationFilters(TempMatrixLocation); end; local procedure ShowColumnNameOnAfterValidate() begin SetMatrixColumns("Matrix Page Step Type"::Same); end; local procedure ShowInTransitOnAfterValidate() begin SetMatrixColumns("Matrix Page Step Type"::Initial); end; local procedure UpdateMatrixSubform() begin CurrPage.MatrixForm.PAGE.Load(MATRIX_CaptionSet, MatrixRecords, TempMatrixLocation, MATRIX_CurrSetLength); CurrPage.MatrixForm.PAGE.SetRecord(Rec); CurrPage.Update(false); end; [IntegrationEvent(true, false)] local procedure OnAfterSetTempMatrixLocationFilters(var TempMatrixLocation: Record Location temporary); begin end; [IntegrationEvent(true, false)] local procedure OnSetColumnsOnBeforeUpdateMatrixSubform(MATRIXCaptionSet: array[32] of Text[80]; var Matrix_Records: array[32] of Record Location; TempMatrixLocation: Record Location temporary; CurrSetLength: Integer); begin end; [IntegrationEvent(true, false)] local procedure OnSetColumnsOnAfterSetTempMatrixLocationFilters(var TempMatrixLocation: Record Location temporary) begin end;}