Report 1320 Notification Email
src/Layers/W1/BaseApp/System/Notifications/NotificationEmail.Report.al546 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Environment.Configuration;using Microsoft.EServices.EDocument;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Foundation.Company;using Microsoft.Inventory.Item;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Utilities;using System.Automation;using System.Reflection;using System.Security.AccessControl;using System.Utilities;report 1320 "Notification Email"{ WordLayout = './System/Notifications/NotificationEmail.docx'; Caption = 'Notification Email'; DefaultLayout = Word; dataset { dataitem("Integer"; "Integer") { DataItemTableView = sorting(Number) where(Number = const(1)); column(Line1; Line1) { } column(Line2; Line2) { } column(Line3; Line3Lbl) { } column(Line4; Line4Lbl) { } column(Settings_UrlText; SettingsLbl) { } column(Settings_Url; SettingsURL) { } column(SettingsWin_UrlText; SettingsWinLbl) { } column(SettingsWin_Url; SettingsWinURL) { } dataitem("Notification Entry"; "Notification Entry") { column(UserName; ReceipientUser."Full Name") { } column(DocumentType; DocumentType) { } column(DocumentNo; DocumentNo) { } column(Document_UrlText; DocumentName) { } column(Document_Url; DocumentURL) { } column(CustomLink_UrlText; CustomLinkLbl) { } column(CustomLink_Url; "Custom Link") { } column(ActionText; ActionText) { } column(Field1Label; Field1Label) { } column(Field1Value; Field1Value) { } column(Field2Label; Field2Label) { } column(Field2Value; Field2Value) { } column(Field3Label; Field3Label) { } column(Field3Value; Field3Value) { } column(DetailsLabel; DetailsLabel) { } column(DetailsValue; DetailsValue) { } trigger OnAfterGetRecord() var RecRef: RecordRef; begin FindReceipientUser(); CreateSettingsLink(); DataTypeManagement.GetRecordRef("Triggered By Record", RecRef); SetDocumentTypeAndNumber(RecRef); SetActionText(); SetReportFieldPlaceholders(RecRef); SetReportLinePlaceholders(); end; } } } requestpage { layout { } actions { } } labels { } trigger OnPreReport() begin CompanyInformation.Get(); end; var CompanyInformation: Record "Company Information"; ReceipientUser: Record User; PageManagement: Codeunit "Page Management"; DataTypeManagement: Codeunit "Data Type Management"; NotificationManagement: Codeunit "Notification Management"; SettingsURL: Text; SettingsWinURL: Text; DocumentType: Text; DocumentNo: Text; DocumentName: Text; DocumentURL: Text; ActionText: Text; Field1Label: Text; Field1Value: Text; Field2Label: Text; Field2Value: Text; Field3Label: Text; Field3Value: Text; SettingsLbl: Label 'Notification Settings'; SettingsWinLbl: Label '(Windows Client)'; CustomLinkLbl: Label '(Custom Link)'; NotificationSetupFilterStringTxt: Label '&filter=''Notification Setup''.''User ID'' IS ''%1''', Locked = true; Line1Lbl: Label 'Hello %1,', Comment = '%1 = User Name'; Line2Lbl: Label 'You are registered to receive notifications related to %1.', Comment = '%1 = Company Name'; Line3Lbl: Label 'This is a message to notify you that:'; Line4Lbl: Label 'Notification messages are sent automatically and cannot be replied to. But you can change when and how you receive notifications:'; DetailsLabel: Text; DetailsValue: Text; Line1: Text; Line2: Text; DetailsLbl: Label 'Details'; local procedure FindReceipientUser() begin ReceipientUser.SetRange("User Name", "Notification Entry"."Recipient User ID"); if not ReceipientUser.FindFirst() then ReceipientUser.Init(); end; local procedure CreateSettingsLink() begin if SettingsURL <> '' then exit; SettingsURL := GetUrl(CLIENTTYPE::Web, CompanyName, OBJECTTYPE::Page, Page::"Notification Setup"); SettingsURL += StrSubstNo(NotificationSetupFilterStringTxt, GetNotificationUser()); OnAfterCreateSettingsLink(SettingsURL); end; local procedure GetNotificationUser(): Text begin if not GuiAllowed then exit(ReceipientUser."User Name"); exit(UserId); end; local procedure SetDocumentTypeAndNumber(SourceRecRef: RecordRef) var RecRef: RecordRef; IsHandled: Boolean; begin GetTargetRecRef(SourceRecRef, RecRef); IsHandled := false; OnBeforeGetDocumentTypeAndNumber("Notification Entry", RecRef, DocumentType, DocumentNo, IsHandled); if not IsHandled then NotificationManagement.GetDocumentTypeAndNumber(RecRef, DocumentType, DocumentNo); DocumentName := DocumentType + ' ' + DocumentNo; end; local procedure SetActionText() begin ActionText := NotificationManagement.GetActionTextFor("Notification Entry"); end; local procedure SetReportFieldPlaceholders(SourceRecRef: RecordRef) var Customer: Record Customer; Vendor: Record Vendor; Item: Record Item; IncomingDocument: Record "Incoming Document"; GenJournalLine: Record "Gen. Journal Line"; GenJournalBatch: Record "Gen. Journal Batch"; ApprovalEntry: Record "Approval Entry"; OverdueApprovalEntry: Record "Overdue Approval Entry"; RecRef: RecordRef; FieldRef: FieldRef; RecordDetails: Text; HasApprovalEntryAmount: Boolean; begin Clear(Field1Label); Clear(Field1Value); Clear(Field2Label); Clear(Field2Value); Clear(Field3Label); Clear(Field3Value); Clear(DetailsLabel); Clear(DetailsValue); DetailsLabel := DetailsLbl; DetailsValue := "Notification Entry".FieldCaption("Created By") + ' ' + GetCreatedByText(); if SourceRecRef.Number = DATABASE::"Approval Entry" then begin HasApprovalEntryAmount := true; SourceRecRef.SetTable(ApprovalEntry); end; GetTargetRecRef(SourceRecRef, RecRef); case RecRef.Number of DATABASE::"Incoming Document": begin Field1Label := IncomingDocument.FieldCaption("Entry No."); FieldRef := RecRef.Field(IncomingDocument.FieldNo("Entry No.")); Field1Value := Format(FieldRef.Value); Field2Label := IncomingDocument.FieldCaption(Description); FieldRef := RecRef.Field(IncomingDocument.FieldNo(Description)); Field2Value := Format(FieldRef.Value); end; DATABASE::"Sales Header", DATABASE::"Sales Invoice Header", DATABASE::"Sales Cr.Memo Header": GetSalesDocValues(Field1Label, Field1Value, Field2Label, Field2Value, RecRef, SourceRecRef); DATABASE::"Purchase Header", DATABASE::"Purch. Inv. Header", DATABASE::"Purch. Cr. Memo Hdr.": GetPurchaseDocValues(Field1Label, Field1Value, Field2Label, Field2Value, RecRef, SourceRecRef); DATABASE::"Gen. Journal Line": begin RecRef.SetTable(GenJournalLine); Field1Label := GenJournalLine.FieldCaption("Document No."); Field1Value := Format(GenJournalLine."Document No."); Field2Label := GenJournalLine.FieldCaption(Amount); if GenJournalLine."Currency Code" <> '' then Field2Value := GenJournalLine."Currency Code" + ' '; if HasApprovalEntryAmount then Field2Value += FormatAmount(ApprovalEntry.Amount) else Field2Value += FormatAmount(GenJournalLine.Amount) end; DATABASE::"Gen. Journal Batch": begin Field1Label := GenJournalBatch.FieldCaption(Description); FieldRef := RecRef.Field(GenJournalBatch.FieldNo(Description)); Field1Value := Format(FieldRef.Value); Field2Label := GenJournalBatch.FieldCaption("Template Type"); FieldRef := RecRef.Field(GenJournalBatch.FieldNo("Template Type")); Field2Value := Format(FieldRef.Value); end; DATABASE::Customer: begin Field1Label := Customer.FieldCaption("No."); FieldRef := RecRef.Field(Customer.FieldNo("No.")); Field1Value := Format(FieldRef.Value); Field2Label := Customer.FieldCaption(Name); FieldRef := RecRef.Field(Customer.FieldNo(Name)); Field2Value := Format(FieldRef.Value); end; DATABASE::Vendor: begin Field1Label := Vendor.FieldCaption("No."); FieldRef := RecRef.Field(Vendor.FieldNo("No.")); Field1Value := Format(FieldRef.Value); Field2Label := Vendor.FieldCaption(Name); FieldRef := RecRef.Field(Vendor.FieldNo(Name)); Field2Value := Format(FieldRef.Value); end; DATABASE::Item: begin Field1Label := Item.FieldCaption("No."); FieldRef := RecRef.Field(Item.FieldNo("No.")); Field1Value := Format(FieldRef.Value); Field2Label := Item.FieldCaption(Description); FieldRef := RecRef.Field(Item.FieldNo(Description)); Field2Value := Format(FieldRef.Value); end; else OnSetReportFieldPlaceholders(RecRef, Field1Label, Field1Value, Field2Label, Field2Value, Field3Label, Field3Value, DetailsLabel, DetailsValue, "Notification Entry"); end; case "Notification Entry".Type of "Notification Entry".Type::Approval: begin SourceRecRef.SetTable(ApprovalEntry); Field3Label := ApprovalEntry.FieldCaption("Due Date"); Field3Value := Format(ApprovalEntry."Due Date"); RecordDetails := ApprovalEntry.GetChangeRecordDetails(); if RecordDetails <> '' then DetailsValue += RecordDetails; end; "Notification Entry".Type::Overdue: begin Field3Label := OverdueApprovalEntry.FieldCaption("Due Date"); FieldRef := SourceRecRef.Field(OverdueApprovalEntry.FieldNo("Due Date")); Field3Value := Format(FieldRef.Value); end; end; OnSetReportFieldPlaceholdersOnBeforeGetWebUrl(RecRef, Field1Label, Field1Value, Field2Label, Field2Value, Field3Label, Field3Value, SourceRecRef, DetailsLabel, DetailsValue, "Notification Entry"); DocumentURL := PageManagement.GetWebUrl(RecRef, "Notification Entry"."Link Target Page"); OnSetReportFieldPlaceholdersOnAfterGetDocumentURL(DocumentURL, "Notification Entry"); end; local procedure SetReportLinePlaceholders() begin Line1 := StrSubstNo(Line1Lbl, ReceipientUser."Full Name"); Line2 := StrSubstNo(Line2Lbl, CompanyInformation.Name); OnAfterSetReportLinePlaceholders(ReceipientUser, CompanyInformation, Line1, Line2); end; local procedure GetTargetRecRef(RecRef: RecordRef; var TargetRecRefOut: RecordRef) var ApprovalEntry: Record "Approval Entry"; OverdueApprovalEntry: Record "Overdue Approval Entry"; IsHandled: Boolean; begin IsHandled := false; OnBeforeGetTargetRecRef(RecRef, TargetRecRefOut, IsHandled, "Notification Entry"); if IsHandled then exit; case "Notification Entry".Type of "Notification Entry".Type::"New Record": TargetRecRefOut := RecRef; "Notification Entry".Type::Approval: begin RecRef.SetTable(ApprovalEntry); TargetRecRefOut.Get(ApprovalEntry."Record ID to Approve"); end; "Notification Entry".Type::Overdue: begin RecRef.SetTable(OverdueApprovalEntry); TargetRecRefOut.Get(OverdueApprovalEntry."Record ID to Approve"); end; end; end; local procedure GetSalesDocValues(var Field1Label: Text; var Field1Value: Text; var Field2Label: Text; var Field2Value: Text; RecRef: RecordRef; SourceRecRef: RecordRef) var SalesHeader: Record "Sales Header"; SalesInvoiceHeader: Record "Sales Invoice Header"; SalesCrMemoHeader: Record "Sales Cr.Memo Header"; Customer: Record Customer; AmountFieldRef: FieldRef; CurrencyCode: Code[10]; CustomerNo: Code[20]; begin case RecRef.Number of DATABASE::"Sales Header": begin RecRef.SetTable(SalesHeader); AmountFieldRef := RecRef.Field(SalesHeader.FieldNo(Amount)); CurrencyCode := SalesHeader."Currency Code"; CustomerNo := SalesHeader."Sell-to Customer No."; end; DATABASE::"Sales Invoice Header": begin RecRef.SetTable(SalesInvoiceHeader); AmountFieldRef := RecRef.Field(SalesInvoiceHeader.FieldNo(Amount)); CurrencyCode := SalesInvoiceHeader."Currency Code"; CustomerNo := SalesInvoiceHeader."Sell-to Customer No."; end; DATABASE::"Sales Cr.Memo Header": begin RecRef.SetTable(SalesCrMemoHeader); AmountFieldRef := RecRef.Field(SalesCrMemoHeader.FieldNo(Amount)); CurrencyCode := SalesCrMemoHeader."Currency Code"; CustomerNo := SalesCrMemoHeader."Sell-to Customer No."; end; end; OnGetSalesDocValuesOnBeforeGetSalesPurchDocAmountValue(RecRef, AmountFieldRef, CurrencyCode, CustomerNo); GetSalesPurchDocAmountValue(Field1Label, Field1Value, SourceRecRef, AmountFieldRef, CurrencyCode); Field2Label := Customer.TableCaption(); if Customer.Get(CustomerNo) then Field2Value := Customer.Name + ' (#' + Format(Customer."No.") + ')'; end; local procedure GetPurchaseDocValues(var Field1Label: Text; var Field1Value: Text; var Field2Label: Text; var Field2Value: Text; RecRef: RecordRef; SourceRecRef: RecordRef) var PurchaseHeader: Record "Purchase Header"; PurchInvHeader: Record "Purch. Inv. Header"; PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr."; Vendor: Record Vendor; AmountFieldRef: FieldRef; CurrencyCode: Code[10]; VendorNo: Code[20]; begin case RecRef.Number of DATABASE::"Purchase Header": begin RecRef.SetTable(PurchaseHeader); AmountFieldRef := RecRef.Field(PurchaseHeader.FieldNo(Amount)); CurrencyCode := PurchaseHeader."Currency Code"; VendorNo := PurchaseHeader."Buy-from Vendor No."; end; DATABASE::"Purch. Inv. Header": begin RecRef.SetTable(PurchInvHeader); AmountFieldRef := RecRef.Field(PurchInvHeader.FieldNo(Amount)); CurrencyCode := PurchInvHeader."Currency Code"; VendorNo := PurchInvHeader."Buy-from Vendor No."; end; DATABASE::"Purch. Cr. Memo Hdr.": begin RecRef.SetTable(PurchCrMemoHdr); AmountFieldRef := RecRef.Field(PurchCrMemoHdr.FieldNo(Amount)); CurrencyCode := PurchCrMemoHdr."Currency Code"; VendorNo := PurchCrMemoHdr."Buy-from Vendor No."; end; end; GetSalesPurchDocAmountValue(Field1Label, Field1Value, SourceRecRef, AmountFieldRef, CurrencyCode); Field2Label := Vendor.TableCaption(); if Vendor.Get(VendorNo) then Field2Value := Vendor.Name + ' (#' + Format(Vendor."No.") + ')'; end; local procedure GetSalesPurchDocAmountValue(var Field1Label: Text; var Field1Value: Text; SourceRecRef: RecordRef; AmountFieldRef: FieldRef; CurrencyCode: Code[10]) var ApprovalEntry: Record "Approval Entry"; Amount: Decimal; begin Field1Label := AmountFieldRef.Caption; if CurrencyCode <> '' then Field1Value := CurrencyCode + ' '; if SourceRecRef.Number = DATABASE::"Approval Entry" then begin SourceRecRef.SetTable(ApprovalEntry); Field1Value += FormatAmount(ApprovalEntry.Amount); end else begin AmountFieldRef.CalcField(); Amount := AmountFieldRef.Value(); Field1Value += FormatAmount(Amount); end; end; local procedure FormatAmount(Amount: Decimal): Text begin exit(Format(Amount, 0, '<Precision,2><Standard Format,0>')); end; local procedure GetCreatedByText(): Text begin if "Notification Entry"."Sender User ID" <> '' then exit(GetUserFullName("Notification Entry"."Sender User ID")); exit(GetUserFullName("Notification Entry"."Created By")); end; local procedure GetUserFullName(NotificationUserID: Code[50]): Text[80] var User: Record User; begin User.SetRange("User Name", NotificationUserID); if User.FindFirst() and (User."Full Name" <> '') then exit(User."Full Name"); exit(NotificationUserID); end; [IntegrationEvent(false, false)] local procedure OnAfterSetReportLinePlaceholders(ReceipientUser: Record User; CompanyInformation: Record "Company Information"; var Line1: Text; var Line2: Text) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetDocumentTypeAndNumber(var NotificationEntry: Record "Notification Entry"; var RecRef: RecordRef; var DocumentType: Text; var DocumentNo: Text; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetTargetRecRef(RecRef: RecordRef; var TargetRecRefOut: RecordRef; var IsHandled: Boolean; NotificationEntry: Record "Notification Entry") begin end; [IntegrationEvent(false, false)] local procedure OnGetSalesDocValuesOnBeforeGetSalesPurchDocAmountValue(var RecRef: RecordRef; var AmountFieldRef: FieldRef; var CurrencyCode: Code[10]; var CustomerNo: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnSetReportFieldPlaceholders(RecRef: RecordRef; var Field1Label: Text; var Field1Value: Text; var Field2Label: Text; var Field2Value: Text; var Field3Label: Text; var Field3Value: Text; var DetailsLabel: Text; var DetailsValue: Text; NotificationEntry: Record "Notification Entry") begin end; [IntegrationEvent(false, false)] local procedure OnSetReportFieldPlaceholdersOnAfterGetDocumentURL(var DocumentURL: Text; var NotificationEntry: Record "Notification Entry") begin end; [IntegrationEvent(false, false)] local procedure OnSetReportFieldPlaceholdersOnBeforeGetWebUrl(RecRef: RecordRef; var Field1Label: Text; var Field1Value: Text; var Field2Label: Text; var Field2Value: Text; var Field3Label: Text; var Field3Value: Text; var SourceRecRef: RecordRef; var DetailsLabel: Text; var DetailsValue: Text; NotificationEntry: Record "Notification Entry") begin end; [IntegrationEvent(false, false)] local procedure OnAfterCreateSettingsLink(var SettingsURL: Text) begin end;}