Table 9657 Custom Report Selection

Base Application, Microsoft.Foundation.Reporting

src/Layers/W1/BaseApp/Foundation/Reporting/CustomReportSelection.Table.al568 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.Foundation.Reporting;using Microsoft.CRM.BusinessRelation;using Microsoft.CRM.Contact;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using System.Email;using System.Reflection;using System.Text;using System.Utilities;table 9657 "Custom Report Selection"{    Caption = 'Custom Report Selection';    DataClassification = CustomerContent;    fields    {        field(1; "Source Type"; Integer)        {            Caption = 'Source Type';        }        field(2; "Source No."; Code[20])        {            Caption = 'Source No.';            TableRelation = if ("Source Type" = const(18)) Customer."No."            else            if ("Source Type" = const(23)) Vendor."No.";        }        field(3; Usage; Enum "Report Selection Usage")        {            Caption = 'Usage';        }        field(4; Sequence; Integer)        {            AutoIncrement = true;            Caption = 'Sequence';        }        field(5; "Report ID"; Integer)        {            Caption = 'Report ID';            TableRelation = "Report Metadata"."ID";            ToolTip = 'Specifies the ID of the report.';            trigger OnValidate()            begin                CalcFields("Report Caption");                if (("Report ID" = 0) or ("Report ID" <> xRec."Report ID")) then begin                    Validate("Custom Report Layout Code", '');                    Validate("Email Body Layout Code", '');                    Validate("Email Body Layout Name", '');                    Validate("Email Attachment Layout Name", '');                end;            end;        }        field(6; "Report Caption"; Text[250])        {            CalcFormula = lookup("Report Metadata".Caption where("ID" = field("Report ID")));            Caption = 'Report Caption';            Editable = false;            FieldClass = FlowField;            ToolTip = 'Specifies the name of the report.';        }        field(7; "Custom Report Layout Code"; Code[20])        {            Caption = 'Custom Report Layout Code';            TableRelation = "Custom Report Layout" where(Code = field("Custom Report Layout Code"));            trigger OnValidate()            begin                CalcFields("Custom Report Description");            end;        }        field(8; "Custom Report Description"; Text[250])        {            CalcFormula = lookup("Custom Report Layout".Description where(Code = field("Custom Report Layout Code")));            Caption = 'Custom Report Description';            FieldClass = FlowField;            ToolTip = 'Specifies a description of the custom report layout.';        }        field(9; "Send To Email"; Text[200])        {            Caption = 'Send To Email';            ToolTip = 'Specifies that the report is used when sending emails.';            trigger OnValidate()            var                MailManagement: Codeunit "Mail Management";            begin                if "Send To Email" <> '' then begin                    if "Use Email from Contact" then                        Error(UseEmailFromContactErr);                    MailManagement.CheckValidEmailAddresses("Send To Email");                end else                    ClearSeletedContactsFilter();            end;        }        field(19; "Use for Email Attachment"; Boolean)        {            Caption = 'Use for Email Attachment';            InitValue = true;            ToolTip = 'Specifies that summarized information, such as invoice number, due date, and payment service link, will be inserted in the body of the email that you send.';            trigger OnValidate()            begin                if not "Use for Email Body" then begin                    Validate("Email Body Layout Code", '');                    Validate("Email Body Layout AppID", EmptyGuid);                    Validate("Email Body Layout Name", '');                end;            end;        }        field(20; "Use for Email Body"; Boolean)        {            Caption = 'Use for Email Body';            ToolTip = 'Specifies that summarized information, such as invoice number, due date, and payment service link, will be inserted in the body of the email that you send.';            trigger OnValidate()            begin                if not "Use for Email Body" then begin                    Validate("Email Body Layout Code", '');                    Validate("Email Body Layout AppID", EmptyGuid);                    Validate("Email Body Layout Name", '');                end;            end;        }        field(21; "Email Body Layout Code"; Code[20])        {            Caption = 'Email Body Layout Code';            TableRelation = "Custom Report Layout" where(Code = field("Email Body Layout Code"),                                                          "Report ID" = field("Report ID"));            ToolTip = 'Specifies the ID of the email body layout that is used.';            trigger OnValidate()            begin                if "Email Body Layout Code" <> '' then                    TestField("Use for Email Body", true);                CalcFields("Email Body Layout Description");            end;        }        field(22; "Email Body Layout Description"; Text[250])        {            CalcFormula = lookup("Custom Report Layout".Description where(Code = field("Email Body Layout Code")));            Caption = 'Email Body Layout Description';            Editable = false;            FieldClass = FlowField;            ToolTip = 'Specifies a description of the custom email body layout that is used.';        }        field(23; "Use Email from Contact"; Boolean)        {            Caption = 'Use Email from Contacts';        }        field(24; "Selected Contacts Filter"; Blob)        {            Caption = 'Selected Contacts Filter';        }        field(25; "Email Attachment Layout Name"; Text[250])        {            Caption = 'Email attachment layout name';            Editable = false;        }        field(26; "Email Attachment Layout AppID"; Guid)        {            Caption = 'Email attachment layout App ID';            Editable = false;        }        field(27; "Email Body Layout Name"; Text[250])        {            Caption = 'Email body layout name';            Editable = false;        }        field(28; "Email Body Layout AppID"; Guid)        {            Caption = 'Email body layout App ID';            Editable = false;        }        field(29; "Email Body Layout Caption"; Text[250])        {            Caption = 'Email Body Layout';            ToolTip = 'Specifies the description of the report layout that is used for email body.';            FieldClass = FlowField;            CalcFormula = lookup("Report Layout List".Caption where("Report ID" = field("Report ID"), Name = field("Email Attachment Layout Name")));            Editable = false;            trigger OnLookup()            var                ReportLayoutList: Record "Report Layout List";                ReportManagement: Codeunit ReportManagement;                Handled: Boolean;            begin                ReportLayoutList.SetRange("Report ID", Rec."Report ID");                ReportManagement.OnSelectReportLayout(ReportLayoutList, Handled);                if not Handled then                    exit;                "Email Body Layout Name" := ReportLayoutList.Name;                "Email Body Layout AppID" := ReportLayoutList."Application ID";            end;        }    }    keys    {        key(Key1; "Source Type", "Source No.", Usage, Sequence)        {            Clustered = true;        }        key(Key2; "Report ID")        {        }    }    fieldgroups    {    }    trigger OnInsert()    begin        TestField("Report ID");    end;    trigger OnModify()    begin        TestField("Report ID");    end;    var        TargetEmailAddressErr: Label 'The target email address has not been specified on the document layout for %1, %2. //Choose the Document Layouts action on the customer or vendor card to specify the email address.', Comment = '%1 - Source Data RecordID, %2 - Usage';        ExceededContactsNotificationTxt: Label 'Too many contacts were selected. Only %1 of %2 contact emails were processed. You can revise contact selection.', Comment = '%1 = number of contacts, %2 = number of contacts';        UseEmailFromContactErr: Label 'You already use emails from contacts and cannot enter email addresses manually. Delete the value in the Send to Email field, and then enter another email address.';        StartUseEmailFromContactTxt: Label 'Choose the Select Email from Contacts action if you want to view the list of contacts that will be used to send emails.';        EmptyGuid: Guid;    procedure InitUsage()    begin        Usage := xRec.Usage;    end;    procedure FilterReportUsage(NewSourceType: Integer; NewSourceNo: Code[20]; NewUsage: Option)    begin        Reset();        SetRange("Source Type", NewSourceType);        SetRange("Source No.", NewSourceNo);        SetRange(Usage, NewUsage);    end;    procedure FilterEmailBodyUsage(NewSourceType: Integer; NewSourceNo: Code[20]; NewUsage: Option)    begin        FilterReportUsage(NewSourceType, NewSourceNo, NewUsage);        SetRange("Use for Email Body", true);        OnAfterFilterEmailBodyUsage(Rec, NewSourceType, NewSourceNo, NewUsage);    end;    local procedure LookupCustomReportLayout(CurrentLayoutCode: Code[20]): Code[20]#if not CLEAN28    var        CustomReportLayout: Record "Custom Report Layout";#endif    begin#if not CLEAN28#pragma warning disable AL0432        if CustomReportLayout.LookupLayoutOK("Report ID") then#pragma warning restore AL0432            exit(CustomReportLayout.Code);#endif        exit(CurrentLayoutCode);    end;    procedure LookupCustomReportDescription()    begin        Validate("Custom Report Layout Code", LookupCustomReportLayout("Custom Report Layout Code"));    end;    procedure LookupEmailBodyDescription()    begin        Validate("Email Body Layout Code", LookupCustomReportLayout("Custom Report Layout Code"));    end;    [Scope('OnPrem')]    procedure CheckEmailSendTo(DataRecRef: RecordRef)    var        ErrorMessageManagement: Codeunit "Error Message Management";        ErrorMessage: Text;    begin        if GetSendToEmail(true) = '' then begin            ErrorMessage := StrSubstNo(TargetEmailAddressErr, DataRecRef.RecordId, Usage);            ErrorMessageManagement.LogError(Rec, ErrorMessage, '');        end;    end;    procedure CopyFromReportSelections(var ReportSelections: Record "Report Selections"; SourceType: Integer; SourceNo: Code[20])    var        CustomReportSelection: Record "Custom Report Selection";        SequenceNo: Integer;    begin        if ReportSelections.FindSet() then begin            SequenceNo := GetSequenceNo();            CustomReportSelection.SetRange("Source Type", SourceType);            CustomReportSelection.SetRange("Source No.", SourceNo);            repeat                CustomReportSelection.SetRange(Usage, ReportSelections.Usage);                CustomReportSelection.SetRange("Report ID", ReportSelections."Report ID");                if CustomReportSelection.IsEmpty() then begin                    Init();                    Validate("Source Type", SourceType);                    Validate("Source No.", SourceNo);                    Validate(Usage, ReportSelections.Usage);                    Validate(Sequence, SequenceNo);                    Validate("Report ID", ReportSelections."Report ID");                    Validate("Use for Email Body", ReportSelections."Use for Email Body");                    Validate("Use for Email Attachment", ReportSelections."Use for Email Attachment");                    Validate("Custom Report Layout Code", ReportSelections."Custom Report Layout Code");                    if ReportSelections."Email Body Layout Type" = ReportSelections."Email Body Layout Type"::"Custom Report Layout" then                        Validate("Email Body Layout Code", ReportSelections."Email Body Layout Code");                    Validate("Email Body Layout Name", ReportSelections."Email Body Layout Name");                    Validate("Email Body Layout AppID", ReportSelections."Email Body Layout AppID");                    Validate("Email Attachment Layout Name", ReportSelections."Report Layout Name");                    Validate("Email Attachment Layout AppID", ReportSelections."Report Layout AppID");                    OnCopyFromReportSelectionsOnBeforeInsert(Rec, ReportSelections);                    Insert();                    SequenceNo += 1;                end;            until ReportSelections.Next() = 0;        end;        OnCopyFromReportSelections(Rec, ReportSelections);    end;    procedure GetSendToEmailFromContactsSelection(LinkType: Option; LinkNo: Code[20])    var        Contact: Record Contact;        ContBusRel: Record "Contact Business Relation";    begin        ContBusRel.FindContactsByRelation(Contact, "Contact Business Relation Link to Table".FromInteger(LinkType), LinkNo);        if IsCustomerVendorLinkType("Contact Business Relation Link to Table".FromInteger(LinkType)) then            GetCustomerVendorAdditionalContacts(Contact, "Contact Business Relation Link to Table".FromInteger(LinkType), LinkNo);        if Contact.FindSet() then            if Contact.GetContactsSelectionFromContactList(true) then                GetSendToEmailFromContacts(Contact);    end;    procedure GetSendToEmailFromContacts(var Contact: Record Contact)    var        ExceededContactsNotification: Notification;        EmailList: Text;        FieldLenghtExceeded: Boolean;        MaxFieldLength: Integer;        ProcessedContactsCount: Integer;        ShowExceededContactsNotification: Boolean;    begin        "Send To Email" := '';        if Contact.FindSet() then begin            MaxFieldLength := MaxStrLen("Send To Email");            repeat                if Contact."E-Mail" <> '' then                    if StrLen(EmailList + Contact."E-Mail") <= MaxFieldLength then begin                        ProcessedContactsCount += 1;                        EmailList += Contact."E-Mail";                        if StrLen(EmailList) < MaxFieldLength then                            EmailList += ';';                    end else begin                        FieldLenghtExceeded := true;                        ShowExceededContactsNotification := FieldLenghtExceeded;                    end;            until (Contact.Next() = 0) or FieldLenghtExceeded;        end;        EmailList := DelChr(EmailList, '>', ';');        "Send To Email" := CopyStr(EmailList, 1, MaxStrLen("Send To Email"));        if "Send To Email" <> '' then            FillSelectedContactsFilter(Contact.GetFilter("No."));        OnGetSendToEmailFromContacts(Rec, Contact, ShowExceededContactsNotification);        if ShowExceededContactsNotification then begin            ExceededContactsNotification.Scope(NotificationScope::LocalScope);            ExceededContactsNotification.Message(StrSubstNo(ExceededContactsNotificationTxt, ProcessedContactsCount, Contact.Count));            ExceededContactsNotification.Send();        end;    end;    procedure ShowSelectedContacts()    var        Contact: Record Contact;    begin        if "Use Email from Contact" then begin            Contact.SetFilter("No.", GetSelectedContactsFilter());            Contact.GetContactsSelectionFromContactList(false);        end else            Message(StartUseEmailFromContactTxt);    end;    local procedure ClearSeletedContactsFilter()    begin        CalcFields("Selected Contacts Filter");        Clear("Selected Contacts Filter");        "Use Email from Contact" := false;    end;    local procedure FillSelectedContactsFilter(SelectedContactsFilter: Text)    var        OStream: OutStream;    begin        if SelectedContactsFilter = '' then            exit;        if "Selected Contacts Filter".HasValue() then begin            CalcFields("Selected Contacts Filter");            Clear("Selected Contacts Filter");        end;        "Selected Contacts Filter".CreateOutStream(OStream);        OStream.WriteText(SelectedContactsFilter);        "Use Email from Contact" := true;    end;    local procedure GetSelectedContactsFilter() SelectedContactsFilter: Text    var        IStream: InStream;    begin        if not "Selected Contacts Filter".HasValue() then            exit('');        CalcFields("Selected Contacts Filter");        "Selected Contacts Filter".CreateInStream(IStream);        IStream.ReadText(SelectedContactsFilter);        OnGetSelectedContactsFilter(SelectedContactsFilter);    end;    procedure GetSendToEmail(Update: Boolean) Result: Text[250]    var        Contact: Record Contact;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeGetSendToEmail(Update, Result, IsHandled);        if IsHandled then            exit(Result);        if "Use Email from Contact" then begin            Contact.SetFilter("No.", GetSelectedContactsFilter());            FillSendToEmail(Contact);            if Update then                Modify();        end;        exit("Send To Email");    end;    local procedure FillSendToEmail(var Contact: Record Contact)    var        EmailList: Text;        MaxFieldLength: Integer;        FieldLenghtExceeded: Boolean;    begin        "Send To Email" := '';        MaxFieldLength := MaxStrLen("Send To Email");        if Contact.FindSet() then            repeat                if Contact."E-Mail" <> '' then                    if StrLen(EmailList + Contact."E-Mail") <= MaxFieldLength then begin                        EmailList += Contact."E-Mail";                        if StrLen(EmailList) < MaxFieldLength then                            EmailList += ';';                    end else                        FieldLenghtExceeded := true;            until (Contact.Next() = 0) or FieldLenghtExceeded;        EmailList := DelChr(EmailList, '>', ';');        "Send To Email" := CopyStr(EmailList, 1, MaxStrLen("Send To Email"));    end;    procedure UpdateSendtoEmail(Update: Boolean)    begin        if FindSet() then            repeat                GetSendToEmail(Update);            until Next() = 0;    end;    local procedure GetSequenceNo(): Integer    var        CustomReportSelection: Record "Custom Report Selection";    begin        CustomReportSelection.SetCurrentKey(Sequence);        if CustomReportSelection.FindLast() then            exit(CustomReportSelection.Sequence + 1);        exit(1);    end;    local procedure IsCustomerVendorLinkType(LinkType: Enum "Contact Business Relation Link To Table"): Boolean    begin        exit((LinkType = LinkType::Customer) or (LinkType = LinkType::Vendor));    end;    local procedure GetCustomerVendorAdditionalContacts(var Contact: Record Contact; LinkType: Enum "Contact Business Relation Link To Table"; LinkNo: Code[20])    var        Customer: Record Customer;        Vendor: Record Vendor;        BillToPayToContact: Record Contact;        ContactBusinessRelation: Record "Contact Business Relation";        CVNo: Code[20];    begin        case LinkType of            "Contact Business Relation Link To Table"::Customer:                begin                    Customer.Get(LinkNo);                    if Customer.Get(Customer."Bill-to Customer No.") then                        CVNo := Customer."No.";                end;            "Contact Business Relation Link To Table"::Vendor:                begin                    Vendor.Get(LinkNo);                    if Vendor.Get(Vendor."Pay-to Vendor No.") then                        CVNo := Vendor."No.";                end;        end;        if ContactBusinessRelation.FindContactsByRelation(BillToPayToContact, LinkType, CVNo) then            CombineContacts(Contact, BillToPayToContact);    end;    local procedure CombineContacts(var Contact: Record Contact; var BillToPayToContact: Record Contact)    var        SelectionFilterManagement: Codeunit SelectionFilterManagement;        ContactNoFilter: Text;    begin        ContactNoFilter := SelectionFilterManagement.GetSelectionFilterForContact(Contact);        if ContactNoFilter <> '' then            ContactNoFilter += '|' + SelectionFilterManagement.GetSelectionFilterForContact(BillToPayToContact)        else            ContactNoFilter := SelectionFilterManagement.GetSelectionFilterForContact(BillToPayToContact);        Contact.Reset();        Contact.SetFilter("No.", ContactNoFilter);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterFilterEmailBodyUsage(var CustomReportSelection: Record "Custom Report Selection"; NewSourceType: Integer; NewSourceNo: Code[20]; NewUsage: Option)    begin    end;    [IntegrationEvent(true, false)]    local procedure OnBeforeGetSendToEmail(Update: Boolean; var Result: Text[250]; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyFromReportSelections(var CustomReportSelection: Record "Custom Report Selection"; var ReportSelections: Record "Report Selections")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCopyFromReportSelectionsOnBeforeInsert(var CustomReportSelection: Record "Custom Report Selection"; ReportSelections: Record "Report Selections")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSendToEmailFromContacts(var CustomReportSelection: Record "Custom Report Selection"; var Contact: Record Contact; var ShowExceededContactsNotification: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnGetSelectedContactsFilter(var SelectedContactsFilter: Text)    begin    end;}