Codeunit 5409 Feature - Report Selection

Base Application, System.Environment.Configuration

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;}