Page 491 Items by Location
- App
- Base Application
- Namespace
- Microsoft.Inventory.Analysis
- Versions
- 17-28
- Source table
- 27
Procedures, 2Events, 3Obsolete, 1
Versions171819202122232425262728
Source29
Source in 29
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;
}