Codeunit 783 Relationship Performance Mgt.

Base Application, Microsoft.CRM.Opportunity

src/Layers/W1/BaseApp/CRM/Opportunity/RelationshipPerformanceMgt.Codeunit.al231 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.CRM.Opportunity;using Microsoft.CRM.Interaction;using Microsoft.CRM.Segment;using System;using System.Visualization;using System.Xml;codeunit 783 "Relationship Performance Mgt."{    trigger OnRun()    begin    end;    var        CreateOpportunityQst: Label 'Do you want to create an opportunity for contact %1?', Comment = '%1 - Contact No.';        CreateOpportunityCaptionTxt: Label 'Create opportunity...';    local procedure CalcTopFiveOpportunities(var TempOpportunity: Record Opportunity temporary)    var        [SecurityFiltering(SecurityFilter::Filtered)]        Opportunity: Record Opportunity;        I: Integer;    begin        TempOpportunity.DeleteAll();        Opportunity.SetAutoCalcFields("Estimated Value (LCY)");        Opportunity.SetRange(Closed, false);        Opportunity.SetCurrentKey("Estimated Value (LCY)");        Opportunity.Ascending(false);        OnCalcTopFiveOpportunitiesOnAfterOpportunitySetFilters(Opportunity);        if Opportunity.FindSet() then            repeat                I += 1;                TempOpportunity := Opportunity;                OnCalcTopFiveOpportunitiesOnBeforeTempOpportunityInsert(TempOpportunity, Opportunity);                TempOpportunity.Insert();            until (Opportunity.Next() = 0) or (I = 5);    end;    procedure DrillDown(var BusinessChartBuffer: Record "Business Chart Buffer"; var TempOpportunity: Record Opportunity temporary)    var        Opportunity: Record Opportunity;    begin        if TempOpportunity.FindSet() then begin            TempOpportunity.Next(BusinessChartBuffer."Drill-Down X Index");            Opportunity.SetRange("No.", TempOpportunity."No.");            PAGE.Run(PAGE::"Opportunity List", Opportunity);        end;    end;    [Scope('OnPrem')]    procedure UpdateData(var BusinessChartBuffer: Record "Business Chart Buffer"; var TempOpportunity: Record Opportunity temporary)    var        I: Integer;    begin        BusinessChartBuffer.Initialize();        BusinessChartBuffer.AddDecimalMeasure(TempOpportunity.FieldCaption("Estimated Value (LCY)"), 1, BusinessChartBuffer."Chart Type"::StackedColumn);        BusinessChartBuffer.SetXAxis(TempOpportunity.TableCaption(), BusinessChartBuffer."Data Type"::String);        CalcTopFiveOpportunities(TempOpportunity);        TempOpportunity.SetAutoCalcFields("Estimated Value (LCY)");        OnUpdateDataOnAfterTempOpportunitySetFilters(TempOpportunity);        if TempOpportunity.FindSet() then            repeat                I += 1;                AddBusinessChartBufferColumn(BusinessChartBuffer, TempOpportunity);                BusinessChartBuffer.SetValueByIndex(0, I - 1, TempOpportunity."Estimated Value (LCY)");            until TempOpportunity.Next() = 0;    end;    local procedure AddBusinessChartBufferColumn(var BusinessChartBuffer: Record "Business Chart Buffer"; var TempOpportunity: Record Opportunity temporary)    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeAddBusinessChartBufferColumn(BusinessChartBuffer, TempOpportunity, IsHandled);        if IsHandled then            exit;        BusinessChartBuffer.AddColumn(TempOpportunity.Description);    end;    procedure SendCreateOpportunityNotification(SegmentLine: Record "Segment Line")    var        InteractionLogEntry: Record "Interaction Log Entry";        CreateOpportunityNotification: Notification;    begin        CreateOpportunityNotification.Id := CreateGuid();        CreateOpportunityNotification.Message := StrSubstNo(CreateOpportunityQst, SegmentLine."Contact No.");        InteractionLogEntry.SetRange("User ID", UserId);        InteractionLogEntry.SetRange("Contact No.", SegmentLine."Contact No.");        InteractionLogEntry.FindFirst();        CreateOpportunityNotification.SetData(          GetSegmentLineNotificationDataItemID(), RecordsToXml(SegmentLine, InteractionLogEntry));        CreateOpportunityNotification.Scope(NOTIFICATIONSCOPE::LocalScope);        CreateOpportunityNotification.AddAction(          CreateOpportunityCaptionTxt, CODEUNIT::"Relationship Performance Mgt.", 'CreateOpportunityFromSegmentLineNotification');        CreateOpportunityNotification.Send();    end;    [Scope('OnPrem')]    procedure CreateOpportunityFromSegmentLineNotification(var CreateOpportunityNotification: Notification)    var        TempSegmentLine: Record "Segment Line" temporary;        InteractionLogEntry: Record "Interaction Log Entry";    begin        TempSegmentLine.Init();        TempSegmentLine.Insert();        XmlToRecords(          CreateOpportunityNotification.GetData(GetSegmentLineNotificationDataItemID()), TempSegmentLine, InteractionLogEntry);        InteractionLogEntry."Opportunity No." := TempSegmentLine.CreateOpportunity();        InteractionLogEntry.Modify();    end;    local procedure RecordsToXml(SegmentLine: Record "Segment Line"; InteractionLogEntry: Record "Interaction Log Entry"): Text    var        XMLDOMManagement: Codeunit "XML DOM Management";        RecRef: RecordRef;        DotNetXmlDocument: DotNet XmlDocument;        XmlRootNode: DotNet XmlNode;        XmlNode: DotNet XmlNode;    begin        DotNetXmlDocument := DotNetXmlDocument.XmlDocument();        XMLDOMManagement.AddRootElement(DotNetXmlDocument, 'Notification', XmlRootNode);        RecRef.GetTable(SegmentLine);        XMLDOMManagement.AddElement(XmlRootNode, GetXmlTableName(RecRef), '', '', XmlNode);        AddFieldToXml(XmlNode, RecRef.Field(SegmentLine.FieldNo("Segment No.")));        AddFieldToXml(XmlNode, RecRef.Field(SegmentLine.FieldNo(Description)));        AddFieldToXml(XmlNode, RecRef.Field(SegmentLine.FieldNo("Campaign No.")));        AddFieldToXml(XmlNode, RecRef.Field(SegmentLine.FieldNo("Salesperson Code")));        AddFieldToXml(XmlNode, RecRef.Field(SegmentLine.FieldNo("Contact No.")));        AddFieldToXml(XmlNode, RecRef.Field(SegmentLine.FieldNo("Contact Company No.")));        RecRef.Close();        RecRef.GetTable(InteractionLogEntry);        XMLDOMManagement.AddElement(XmlRootNode, GetXmlTableName(RecRef), '', '', XmlNode);        AddFieldToXml(XmlNode, RecRef.Field(InteractionLogEntry.FieldNo("Entry No.")));        RecRef.Close();        exit(DotNetXmlDocument.OuterXml);    end;    local procedure XmlToRecords(InText: Text; var SegmentLine: Record "Segment Line"; var InteractionLogEntry: Record "Interaction Log Entry")    var        XMLDOMManagement: Codeunit "XML DOM Management";        RecRef: RecordRef;        DotNetXmlDocument: DotNet XmlDocument;        XmlRootNode: DotNet XmlNode;    begin        XMLDOMManagement.LoadXMLDocumentFromText(InText, DotNetXmlDocument);        RecRef.GetTable(SegmentLine);        XMLDOMManagement.FindNode(DotNetXmlDocument.DocumentElement, GetXmlTableName(RecRef), XmlRootNode);        SetFieldFromXml(RecRef, SegmentLine.FieldNo("Segment No."), XmlRootNode);        SetFieldFromXml(RecRef, SegmentLine.FieldNo(Description), XmlRootNode);        SetFieldFromXml(RecRef, SegmentLine.FieldNo("Campaign No."), XmlRootNode);        SetFieldFromXml(RecRef, SegmentLine.FieldNo("Salesperson Code"), XmlRootNode);        SetFieldFromXml(RecRef, SegmentLine.FieldNo("Contact No."), XmlRootNode);        SetFieldFromXml(RecRef, SegmentLine.FieldNo("Contact Company No."), XmlRootNode);        RecRef.Modify();        RecRef.SetTable(SegmentLine);        RecRef.Close();        RecRef.Open(DATABASE::"Interaction Log Entry");        XMLDOMManagement.FindNode(DotNetXmlDocument.DocumentElement, GetXmlTableName(RecRef), XmlRootNode);        SetFieldFromXml(RecRef, InteractionLogEntry.FieldNo("Entry No."), XmlRootNode);        RecRef.Find();        RecRef.SetTable(InteractionLogEntry);    end;    local procedure AddFieldToXml(var XmlNode: DotNet XmlNode; FieldRef: FieldRef)    var        XMLDOMManagement: Codeunit "XML DOM Management";        XmlNodeChild: DotNet XmlNode;    begin        XMLDOMManagement.AddElement(XmlNode, GetXmlNodeName(FieldRef.Number), Format(FieldRef.Value), '', XmlNodeChild);    end;    local procedure SetFieldFromXml(RecRef: RecordRef; FieldNo: Integer; XmlRootNode: DotNet XmlNode)    var        XMLDOMManagement: Codeunit "XML DOM Management";        FieldRef: FieldRef;    begin        FieldRef := RecRef.Field(FieldNo);        FieldRef.Value :=          XMLDOMManagement.FindNodeText(XmlRootNode, GetXmlNodeName(FieldNo));    end;    local procedure GetXmlNodeName(FieldNo: Integer): Text    begin        exit(StrSubstNo('F_%1', Format(FieldNo)));    end;    local procedure GetXmlTableName(RecRef: RecordRef): Text    begin        exit(DelChr(RecRef.Name, '=', ' '));    end;    local procedure GetSegmentLineNotificationDataItemID(): Text    begin        exit('SegmentLineNotificationTok');    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeAddBusinessChartBufferColumn(var BusinessChartBuffer: Record "Business Chart Buffer"; var TempOpportunity: Record Opportunity temporary; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcTopFiveOpportunitiesOnAfterOpportunitySetFilters(var Opportunity: Record Opportunity)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalcTopFiveOpportunitiesOnBeforeTempOpportunityInsert(var TempOpportunity: Record Opportunity temporary; Opportunity: Record Opportunity)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnUpdateDataOnAfterTempOpportunitySetFilters(var TempOpportunity: Record Opportunity temporary)    begin    end;}