Page 9987 Word Templates Related Part
src/System Application/App/Word Templates/src/WordTemplatesRelatedPart.Page.al330 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 System.Integration.Word;using System.Reflection;/// <summary>/// A list part page to view and edit related entities for Word templates./// </summary>page 9987 "Word Templates Related Part"{ Caption = 'Related Entities'; PageType = ListPart; SourceTable = "Word Templates Related Buffer"; InsertAllowed = false; ModifyAllowed = true; DeleteAllowed = true; SourceTableTemporary = true; Extensible = false; Permissions = tabledata "Word Template" = r, tabledata "Word Template Field" = r, tabledata "Word Templates Related Table" = r; InherentEntitlements = X; InherentPermissions = X; layout { area(Content) { repeater(Tables) { ShowAsTree = true; IndentationColumn = Rec.Depth; IndentationControls = "Table Caption"; field("Table Caption"; Rec."Related Table Caption") { ApplicationArea = All; Caption = 'Name'; ToolTip = 'Specifies the related entity.'; Editable = false; Style = Strong; StyleExpr = Rec."Related Table ID" = SourceTableId; } field("Related Table Code"; Rec."Related Table Code") { ApplicationArea = All; Caption = 'Prefix'; ToolTip = 'Specifies a prefix that will indicate that the field is from the related entity when you are setting up the template. For example, if you enter SALES, the field names are prefixed with SALES_. The prefix must be unique.'; Editable = Rec."Related Table ID" <> SourceTableId; trigger OnValidate() var WordTemplateImpl: Codeunit "Word Template Impl."; begin WordTemplateImpl.VerifyRelatedTableCodeIsUnique(Rec.Code, Rec."Related Table Code", Rec."Related Table ID", Rec); end; } field(SelectedFields; NumberOfSelectedFields) { ApplicationArea = All; Caption = 'Number of Selected Fields'; ToolTip = 'Specifies the number of fields for this record that has been selected.'; Editable = false; trigger OnAssistEdit() var WordTemplateFieldSelection: Codeunit "Word Template Field Selection"; begin WordTemplateFieldSelection.ShowFieldSelection(Rec."Related Table ID", TempWordTemplateField); NumberOfSelectedFields := WordTemplateFieldSelection.CalculateNoSelectedFields(Rec."Related Table ID", TempWordTemplateField); SelectedFieldsCount.Set(Rec."Related Table ID", NumberOfSelectedFields); end; } field("Entity Relation"; RecordTypeTxt) { ApplicationArea = All; Style = Subordinate; Enabled = false; Editable = false; Caption = 'Entity relation'; ToolTip = 'Specifies the relation to the source entity.'; } } } } actions { area(Processing) { group("Add Entity") { Caption = 'Add'; ShowAs = SplitButton; Image = NewRow; action("Add related table") { ApplicationArea = All; Caption = 'Add related entity'; ToolTip = 'Add a related entity to the template.'; Scope = Repeater; Image = NewRow; trigger OnAction() begin AddRelatedTable(Rec."Related Table ID") end; } action("Add specific table") { ApplicationArea = All; Caption = 'Add unrelated entity'; ToolTip = 'Select and add an unrelated entity to the template.'; Scope = Repeater; Image = New; trigger OnAction() begin if WordTemplateImpl.AddSelectedTable(Rec, Rec.Code, TempWordTemplateField) then RefreshTreeView(); end; } } action("Edit relation") { ApplicationArea = All; Caption = 'Edit'; ToolTip = 'Change the field from the source entity that creates the relationship to the related entity.'; Scope = Repeater; Image = EditLines; Enabled = EditEnabled; trigger OnAction() begin WordTemplateImpl.EditRelatedTable(Rec, TempWordTemplateField); end; } } } trigger OnOpenPage() begin RefreshTreeView(); end; trigger OnAfterGetRecord() var RecordSelection: Codeunit "Record Selection"; begin if IsNullGuid(Rec."Source Record ID") then if Rec."Related Table ID" = SourceTableId then RecordTypeTxt := SourceRecordTypeLbl else begin Rec.CalcFields("Table Caption"); RecordTypeTxt := StrSubstNo(RelatedRecordTypeLbl, Rec."Table Caption") end else RecordTypeTxt := StrSubstNo(SelectedRecordTypeLbl, RecordSelection.ToText(Rec."Related Table ID", Rec."Source Record ID")); CalculateSelectedFields(); end; internal procedure VerifyNoSelectedFields() var FieldCount: Integer; TotalFieldCount: Integer; begin foreach FieldCount in SelectedFieldsCount.Values() do TotalFieldCount += FieldCount; if TotalFieldCount > 250 then Error(FieldCountErr); end; local procedure CalculateSelectedFields() var WordTemplateFieldSelection: Codeunit "Word Template Field Selection"; begin if not SelectedFieldsCount.Get(Rec."Related Table ID", NumberOfSelectedFields) then begin // Cache custom fields since code may be executed on every call. NumberOfSelectedFields := WordTemplateFieldSelection.CalculateNoSelectedFields(Rec."Related Table ID", TempWordTemplateField); SelectedFieldsCount.Add(Rec."Related Table ID", NumberOfSelectedFields); end; end; trigger OnAfterGetCurrRecord() begin EditEnabled := IsNullGuid(Rec."Source Record ID") and (Rec."Related Table ID" <> SourceTableId); end; trigger OnDeleteRecord(): Boolean begin if Rec."Related Table ID" = SourceTableId then Error(CannotDeleteSourceRecordErr); TempWordTemplateField.Reset(); TempWordTemplateField.SetRange("Table ID", Rec."Related Table ID"); TempWordTemplateField.DeleteAll(); SelectedFieldsCount.Remove(Rec."Related Table ID"); end; internal procedure AddRelatedTable(TableId: Integer) begin if Rec."Table ID" = 0 then TableId := SourceTableId; if not IsNullGuid(Rec."Source Record ID") then TableId := Rec."Related Table ID"; if WordTemplateImpl.AddRelatedTable(Rec, TableId, true, TempWordTemplateField) then RefreshTreeView(); end; internal procedure RefreshTreeView() begin WordTemplateImpl.RefreshTreeView(SourceTableId, Rec); Rec.SetCurrentKey(Position); CurrPage.Update(false); end; internal procedure SetTableNo(TableId: Integer) var WordTemplateFieldSelection: Codeunit "Word Template Field Selection"; begin if SourceTableId <> TableId then begin TempWordTemplateField.Reset(); TempWordTemplateField.DeleteAll(); WordTemplateFieldSelection.SelectDefaultFieldsForTable('', TableId, TempWordTemplateField); SourceTableId := TableId; Rec.Reset(); Rec.DeleteAll(); RefreshTreeView(); end; end; internal procedure SetWordTemplate(WordTemplate: Record "Word Template") var WordTemplatesRelatedTable: Record "Word Templates Related Table"; WordTemplateField: Record "Word Template Field"; begin SourceTableId := WordTemplate."Table ID"; WordTemplateImpl.RefreshTreeView(SourceTableId, Rec); WordTemplatesRelatedTable.SetRange(Code, WordTemplate.Code); if WordTemplatesRelatedTable.FindSet() then repeat Rec.TransferFields(WordTemplatesRelatedTable); Rec.Code := ''; Rec.Insert(); until WordTemplatesRelatedTable.Next() = 0; WordTemplateField.SetRange("Word Template Code", WordTemplate.Code); if WordTemplateField.FindSet() then repeat TempWordTemplateField := WordTemplateField; TempWordTemplateField."Word Template Code" := ''; TempWordTemplateField.Insert(); until WordTemplateField.Next() = 0; end; internal procedure SetRelatedTable(TableId: Integer; RelatedTableId: Integer; FieldNo: Integer; RelatedCode: Code[5]) var WordTemplateFieldSelection: Codeunit "Word Template Field Selection"; begin Rec.Init(); Rec."Table ID" := TableId; Rec."Related Table ID" := RelatedTableId; Rec."Field No." := FieldNo; Rec."Related Table Code" := RelatedCode; Rec.Insert(); WordTemplateFieldSelection.SelectDefaultFieldsForTable('', RelatedTableId, TempWordTemplateField); end; internal procedure SetUnrelatedTable(TableId: Integer; UnrelatedTableID: Integer; RecordSystemId: Guid; RelatedCode: Code[5]) begin WordTemplateImpl.AddTable(Rec, Rec.Code, UnrelatedTableID, RecordSystemId, RelatedCode, TempWordTemplateField); end; internal procedure SetFieldsToBeIncluded(TableId: Integer; IncludeFields: List of [Text[30]]) var WordTemplateFieldSelection: Codeunit "Word Template Field Selection"; begin WordTemplateFieldSelection.SetIncludeFields('', TableId, IncludeFields, TempWordTemplateField); end; internal procedure GetRelatedTables(var RelatedTableIds: List of [Integer]; var RelatedTableCodes: List of [Code[5]]) begin Rec.Reset(); Rec.SetFilter("Related Table ID", '<>%1', SourceTableId); // Exclude source record if Rec.FindSet() then repeat RelatedTableIds.Add(Rec."Related Table ID"); RelatedTableCodes.Add(Rec."Related Table Code"); until Rec.Next() = 0; end; internal procedure GetWordTemplateFields(var OutTempWordTemplateField: Record "Word Template Field" temporary) begin OutTempWordTemplateField.Copy(TempWordTemplateField, true); end; internal procedure GetRelatedTables(var WordTemplatesRelatedTable: Record "Word Templates Related Table" temporary) begin Rec.Reset(); Rec.SetFilter("Related Table ID", '<>%1', SourceTableId); // Exclude source record if Rec.FindSet() then repeat WordTemplatesRelatedTable.TransferFields(Rec); WordTemplatesRelatedTable.Insert(); until Rec.Next() = 0; end; var TempWordTemplateField: Record "Word Template Field" temporary; WordTemplateImpl: Codeunit "Word Template Impl."; SelectedFieldsCount: Dictionary of [Integer, Integer]; RecordTypeTxt: Text; NumberOfSelectedFields: Integer; EditEnabled: Boolean; SourceTableId: Integer; CannotDeleteSourceRecordErr: Label 'You cannot delete the source record.'; SourceRecordTypeLbl: Label 'Source entity'; RelatedRecordTypeLbl: Label 'Related to %1 entity', Comment = '%1 - Table caption of the entity that this entity is related to'; SelectedRecordTypeLbl: Label 'Selected record: {%1}', Comment = '%1 - Text representation of a record'; FieldCountErr: Label 'At most 250 fields can be selected.';}