Codeunit 5409 Feature - Report Selection
src/Layers/W1/BaseApp/FeatureReportSelection.codeunit.al160 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.Environment.Configuration;using Microsoft.Foundation.Navigate;using Microsoft.Foundation.Reporting;using System.Reflection;codeunit 5409 "Feature - Report Selection" implements "Feature Data Update"{ Permissions = TableData "Feature Data Update Status" = rm; TableNo = "Tenant Report Layout"; // The Data upgrade codeunit for Platform Based Report Selection var TempDocumentEntry: Record "Document Entry" temporary; FeatureDataUpdateMgt: Codeunit "Feature Data Update Mgt."; DescriptionTxt: Label 'If you enable platform based report selection, all user-added layouts from the Custom Report Layout table will be migrated to the Report Layouts table.'; CustomReportLayoutTok: Label 'CRL'; procedure IsDataUpdateRequired(): Boolean; begin // Data upgrade is not required if the Custom report layout table is empty. CountRecords(); exit(not TempDocumentEntry.IsEmpty); end; procedure ReviewData() var DataUpgradeOverview: Page "Data Upgrade Overview"; begin Commit(); Clear(DataUpgradeOverview); DataUpgradeOverview.Set(TempDocumentEntry); DataUpgradeOverview.RunModal(); end; procedure AfterUpdate(FeatureDataUpdateStatus: Record "Feature Data Update Status") var UpdateFeatureDataUpdateStatus: Record "Feature Data Update Status"; begin UpdateFeatureDataUpdateStatus.SetRange("Feature Key", FeatureDataUpdateStatus."Feature Key"); UpdateFeatureDataUpdateStatus.SetFilter("Company Name", '<>%1', FeatureDataUpdateStatus."Company Name"); UpdateFeatureDataUpdateStatus.ModifyAll("Feature Status", FeatureDataUpdateStatus."Feature Status"); // Data is not per company end; procedure UpdateData(FeatureDataUpdateStatus: Record "Feature Data Update Status") var CustomReportLayout: Record "Custom Report Layout"; StartDateTime: DateTime; begin StartDateTime := CurrentDateTime; MigrateCustomReportLayouts(); FeatureDataUpdateMgt.LogTask(FeatureDataUpdateStatus, CustomReportLayout.TableCaption(), StartDateTime); end; procedure GetTaskDescription() TaskDescription: Text; begin TaskDescription := DescriptionTxt; end; local procedure CountRecords() var CustomReportLayout: Record "Custom Report Layout"; TenantReportLayout: Record "Tenant Report Layout"; NoOfNonUpdatedLayouts: Integer; NullGuid: Guid; begin TempDocumentEntry.Reset(); TempDocumentEntry.DeleteAll(); CustomReportLayout.SetRange(CustomReportLayout."Built-In", false); if CustomReportLayout.FindSet() then repeat if not TenantReportLayout.Get(CustomReportLayout."Report ID", CustomReportLayout.Code + '-' + CustomReportLayoutTok, NullGuid) then NoOfNonUpdatedLayouts += 1; until CustomReportLayout.Next() = 0; if NoOfNonUpdatedLayouts > 0 then InsertDocumentEntry(Database::"Custom Report Layout", CustomReportLayout.TableCaption(), NoOfNonUpdatedLayouts); end; procedure MigrateCustomReportLayouts() var NonFilteredCustomReportLayout: Record "Custom Report Layout"; begin MigrateCustomReportLayouts(NonFilteredCustomReportLayout); end; procedure MigrateCustomReportLayouts(var CustomReportLayout: Record "Custom Report Layout") var TenantReportLayout: Record "Tenant Report Layout"; ReportLayoutSelection: Record "Report Layout Selection"; ReportMetadata: Record "Report Metadata"; TenantReportLayoutSelection: Record "Tenant Report Layout Selection"; InStreamLayout: Instream; ProgressDlg: Dialog; begin ProgressDlg.Open('#1#########################################'); CustomReportLayout.SetRange("Built-In", false); if CustomReportLayout.FindSet() then repeat ProgressDlg.Update(1, CustomReportLayout.Code + ' - ' + CustomReportLayout.Description); TenantReportLayout.Init(); CustomReportLayout.CalcFields(Layout); if ReportMetadata.Get(CustomReportLayout."Report ID") and CustomReportLayout.Layout.HasValue then begin CustomReportLayout.Layout.CreateInStream(InStreamLayout); TenantReportLayout.Layout.ImportStream(InStreamLayout, CustomReportLayout.Description); TenantReportLayout."Report ID" := CustomReportLayout."Report ID"; TenantReportLayout.Name := CustomReportLayout.Code + '-' + CustomReportLayoutTok; TenantReportLayout.Description := CustomReportLayout.Description; TenantReportLayout."Company Name" := CustomReportLayout."Company Name"; // Assign the Layout-Format. case CustomReportLayout.Type of CustomReportLayout.Type::RDLC: TenantReportLayout."Layout Format" := TenantReportLayout."Layout Format"::RDLC; CustomReportLayout.Type::Word: TenantReportLayout."Layout Format" := TenantReportLayout."Layout Format"::Word else TenantReportLayout."Layout Format" := TenantReportLayout."Layout Format"::Custom; end; // Assign the File-Format if the layout format is 'Custom'/'External' (UI) if (CustomReportLayout."File Extension" <> '') and (TenantReportLayout."Layout Format" = TenantReportLayout."Layout Format"::Custom) then TenantReportLayout."MIME Type" := 'reportlayout/' + CustomReportLayout."File Extension"; if TenantReportLayout.Insert() then begin ReportLayoutSelection.SetRange("Report ID", CustomReportLayout."Report ID"); ReportLayoutSelection.SetRange("Custom Report Layout Code", CustomReportLayout.Code); if ReportLayoutSelection.FindSet(true) then repeat TenantReportLayoutSelection.Init(); TenantReportLayoutSelection."App ID" := TenantReportLayout."App ID"; TenantReportLayoutSelection."Company Name" := TenantReportLayout."Company Name"; TenantReportLayoutSelection."Layout Name" := TenantReportLayout.Name; TenantReportLayoutSelection."Report ID" := TenantReportLayout."Report ID"; if TenantReportLayoutSelection.Insert() then if ReportLayoutSelection.Delete() then; until ReportLayoutSelection.Next() = 0; end; end; until CustomReportLayout.Next() = 0; ProgressDlg.Close(); end; local procedure InsertDocumentEntry(TableID: Integer; TableName: Text; RecordCount: Integer) begin if RecordCount = 0 then exit; TempDocumentEntry.Init(); TempDocumentEntry."Entry No." += 1; TempDocumentEntry."Table ID" := TableID; TempDocumentEntry."Table Name" := CopyStr(TableName, 1, MaxStrLen(TempDocumentEntry."Table Name")); TempDocumentEntry."No. of Records" := RecordCount; TempDocumentEntry.Insert(); end;}