Table 477 Report Inbox

Base Application, Microsoft.EServices.EDocument

src/Layers/W1/BaseApp/eServices/EDocument/ReportInbox.Table.al219 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.EServices.EDocument;using System.Reflection;table 477 "Report Inbox"{    Caption = 'Report Inbox';    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        field(2; "User ID"; Text[65])        {            Caption = 'User ID';            ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.';            DataClassification = EndUserIdentifiableInformation;            Editable = false;        }        field(3; "Report Output"; BLOB)        {            Caption = 'Report Output';        }        field(4; "Created Date-Time"; DateTime)        {            Caption = 'Created Date-Time';            ToolTip = 'Specifies the date and time that the scheduled report was processed from the job queue.';            Editable = false;        }        field(5; "Job Queue Log Entry ID"; Guid)        {            Caption = 'Job Queue Log Entry ID';            Editable = false;        }        field(6; "Output Type"; Enum "Report Inbox Output Type")        {            Caption = 'Output Type';            ToolTip = 'Specifies the output type of the scheduled report.';            Editable = false;        }        field(7; Description; Text[250])        {            Caption = 'Description';            ToolTip = 'Specifies the description of the report.';            Editable = false;        }        field(8; "Report ID"; Integer)        {            Caption = 'Report ID';            ToolTip = 'Specifies the object ID of the report.';            Editable = false;        }        field(9; "Report Name"; Text[250])        {            CalcFormula = lookup(AllObjWithCaption."Object Caption" where("Object Type" = const(Report),                                                                           "Object ID" = field("Report ID")));            Caption = 'Report Name';            ToolTip = 'Specifies the name of the report.';            Editable = false;            FieldClass = FlowField;        }        field(10; Read; Boolean)        {            Caption = 'Read';        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "User ID", "Created Date-Time")        {        }    }    fieldgroups    {    }    var        FileDownLoadTxt: Label 'Export';        ReportIsEmptyMsg: Label 'The report is empty.';        NoReportsToShowErr: Label 'There are no reports in the list.';        FileDoesNotExistErr: Label 'The file does not exist.';        CannotAccessOtherUsersReportErr: Label 'You cannot download a report that was generated by another user.';    procedure ShowReport()    var        Instr: InStream;        Downloaded: Boolean;        FileName: Text;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeShowReport(Rec, IsHandled);        if IsHandled then            exit;        if "Entry No." = 0 then            Error(NoReportsToShowErr);        if "User ID" <> UserId() then            Error(CannotAccessOtherUsersReportErr);        CalcFields("Report Output", "Report Name");        if not "Report Output".HasValue() then begin            Read := true;            Modify();            Commit();            Message(ReportIsEmptyMsg);            exit;        end;        FileName := GetFileNameWithExtension();        "Report Output".CreateInStream(Instr);        Downloaded := DownloadFromStream(Instr, FileDownLoadTxt, '', '', FileName);        if not Read and Downloaded then begin            Read := true;            Modify();        end;    end;    procedure Suffix() Result: Text    begin        case "Output Type" of            "Output Type"::PDF:                exit('.pdf');            "Output Type"::Word:                exit('.docx');            "Output Type"::Excel:                exit('.xlsx');            "Output Type"::Zip:                exit('.zip');            else                OnSuffixCaseElse(Rec, Result);        end;    end;    procedure GetFileNameWithExtension(): Text    begin        exit(GetFileNameWithoutExtension() + Suffix());    end;    procedure GetFileNameWithoutExtension(): Text    var        FileName: Text;    begin        if "Report Name" <> '' then            FileName := DelChr("Report Name", '=', '/:*?"<>|')        else            FileName := DelChr(Description, '=', '/:*?"<>|');        exit(FileName);    end;    procedure OpenInOneDrive()    var        DocumentServiceMgt: Codeunit "Document Service Management";        FileName: Text;        FileExtension: Text;        InStream: InStream;    begin        if "Report Name" = '' then            Error(FileDoesNotExistErr);        if "User ID" <> UserId() then            Error(CannotAccessOtherUsersReportErr);        CalcFields("Report Output");        "Report Output".CreateInStream(InStream);        FileName := GetFileNameWithoutExtension();        FileExtension := Suffix();        DocumentServiceMgt.OpenInOneDrive(FileName, FileExtension, InStream);    end;    procedure ShareWithOneDrive()    var        DocumentServiceMgt: Codeunit "Document Service Management";        FileName: Text;        FileExtension: Text;        InStream: InStream;    begin        if "Report Name" = '' then            Error(FileDoesNotExistErr);        if "User ID" <> UserId() then            Error(CannotAccessOtherUsersReportErr);        CalcFields("Report Output");        "Report Output".CreateInStream(InStream);        FileName := GetFileNameWithoutExtension();        FileExtension := Suffix();        DocumentServiceMgt.ShareWithOneDrive(FileName, FileExtension, InStream);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeShowReport(var ReportInbox: Record "Report Inbox"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnSuffixCaseElse(ReportInbox: Record "Report Inbox"; var Result: Text)    begin    end;}