Report 5198 Add Contacts

Base Application, Microsoft.CRM.Contact

src/Layers/W1/BaseApp/CRM/Contact/AddContacts.Report.al558 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.Contact;using Microsoft.CRM.BusinessRelation;using Microsoft.CRM.Interaction;using Microsoft.CRM.Profiling;using Microsoft.CRM.Segment;using Microsoft.Inventory.Ledger;using Microsoft.Purchases.History;using Microsoft.Sales.History;using System.Utilities;report 5198 "Add Contacts"{    Caption = 'Add Contacts';    ProcessingOnly = true;    dataset    {        dataitem("Segment Header"; "Segment Header")        {            DataItemTableView = sorting("No.");        }        dataitem(Contact; Contact)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Search Name", Type, "Salesperson Code", "Post Code", "Country/Region Code", "Territory Code";            dataitem("Contact Profile Answer"; "Contact Profile Answer")            {                DataItemLink = "Contact No." = field("No.");                DataItemTableView = sorting("Contact No.", "Profile Questionnaire Code", "Line No.");                RequestFilterFields = "Profile Questionnaire Code", "Line No.";                trigger OnAfterGetRecord()                begin                    ContactOK := true;                    CurrReport.Break();                end;                trigger OnPreDataItem()                begin                    if ContactOK and (GetFilters <> '') then                        ContactOK := false                    else                        CurrReport.Break();                end;            }            dataitem("Contact Mailing Group"; "Contact Mailing Group")            {                DataItemLink = "Contact No." = field("No.");                DataItemTableView = sorting("Contact No.", "Mailing Group Code");                RequestFilterFields = "Mailing Group Code";                trigger OnAfterGetRecord()                begin                    ContactOK := true;                    CurrReport.Break();                end;                trigger OnPreDataItem()                begin                    if ContactOK and (GetFilters <> '') then                        ContactOK := false                    else                        CurrReport.Break();                end;            }            dataitem("Interaction Log Entry"; "Interaction Log Entry")            {                DataItemLink = "Contact Company No." = field("Company No."), "Contact No." = field("No.");                DataItemTableView = sorting("Contact Company No.", "Contact No.", Date);                RequestFilterFields = Date, "Segment No.", "Campaign No.", Evaluation, "Interaction Template Code", "Salesperson Code";                trigger OnAfterGetRecord()                begin                    ContactOK := true;                    CurrReport.Break();                end;                trigger OnPreDataItem()                begin                    if ContactOK and (GetFilters <> '') then                        ContactOK := false                    else                        CurrReport.Break();                end;            }            dataitem("Contact Job Responsibility"; "Contact Job Responsibility")            {                DataItemLink = "Contact No." = field("No.");                DataItemTableView = sorting("Contact No.", "Job Responsibility Code");                RequestFilterFields = "Job Responsibility Code";                trigger OnAfterGetRecord()                begin                    ContactOK := true;                    CurrReport.Break();                end;                trigger OnPreDataItem()                begin                    if ContactOK and (GetFilters <> '') then                        ContactOK := false                    else                        CurrReport.Break();                end;            }            dataitem("Contact Industry Group"; "Contact Industry Group")            {                DataItemLink = "Contact No." = field("Company No.");                DataItemTableView = sorting("Contact No.", "Industry Group Code");                RequestFilterFields = "Industry Group Code";                trigger OnAfterGetRecord()                begin                    ContactOK := true;                    CurrReport.Break();                end;                trigger OnPreDataItem()                begin                    if ContactOK and (GetFilters <> '') then                        ContactOK := false                    else                        CurrReport.Break();                end;            }            dataitem("Contact Business Relation"; "Contact Business Relation")            {                DataItemLink = "Contact No." = field("Company No.");                DataItemTableView = sorting("Contact No.", "Business Relation Code");                RequestFilterFields = "Business Relation Code";                dataitem("Value Entry"; "Value Entry")                {                    DataItemTableView = sorting("Source Type", "Source No.", "Item No.", "Posting Date");                    RequestFilterFields = "Item No.", "Variant Code", "Posting Date", "Inventory Posting Group";                    trigger OnAfterGetRecord()                    begin                        if Contact.Type = Contact.Type::Person then                            ContactOK := FindContInPostDocuments(Contact."No.", "Value Entry")                        else                            ContactOK := true;                        if ContactOK then                            CurrReport.Break();                    end;                    trigger OnPreDataItem()                    begin                        if SkipItemLedgerEntry then                            CurrReport.Break();                        case "Contact Business Relation"."Link to Table" of                            "Contact Business Relation"."Link to Table"::Customer:                                begin                                    SetRange("Source Type", "Source Type"::Customer);                                    SetRange("Source No.", "Contact Business Relation"."No.");                                end;                            "Contact Business Relation"."Link to Table"::Vendor:                                begin                                    SetRange("Source Type", "Source Type"::Vendor);                                    SetRange("Source No.", "Contact Business Relation"."No.");                                end                            else                                CurrReport.Break();                        end;                    end;                }                trigger OnAfterGetRecord()                begin                    SkipItemLedgerEntry := false;                    if not ItemFilters then begin                        ContactOK := true;                        SkipItemLedgerEntry := true;                        CurrReport.Break();                    end;                end;                trigger OnPreDataItem()                begin                    if ContactOK and ((GetFilters <> '') or ItemFilters) then                        ContactOK := false                    else                        CurrReport.Break();                end;            }            dataitem("Integer"; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                trigger OnAfterGetRecord()                begin                    if ContactOK then                        InsertContact(Contact);                end;            }            trigger OnAfterGetRecord()            begin                RecordNo := RecordNo + 1;                if RecordNo = 1 then begin                    Window.Open(Text000);                    NoOfRecords := Count;                    OldDateTime := CurrentDateTime;                end;                NewDateTime := CurrentDateTime;                if (NewDateTime - OldDateTime > 100) or (NewDateTime < OldDateTime) then begin                    NewProgress := Round(RecordNo / NoOfRecords * 100, 1);                    if NewProgress <> OldProgress then begin                        Window.Update(1, NewProgress * 100);                        OldProgress := NewProgress;                    end;                    OldDateTime := CurrentDateTime;                end;                ContactOK := true;            end;        }    }    requestpage    {        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(AllowExistingContact; AllowExistingContact)                    {                        ApplicationArea = RelationshipMgmt;                        Caption = 'Allow Existing Contacts';                        ToolTip = 'Specifies if existing contacts are included in the segment.';                    }                    field(ExpandCompanies; ExpandCompanies)                    {                        ApplicationArea = RelationshipMgmt;                        Caption = 'Expand Companies';                        ToolTip = 'Specifies if you want the segment to include all person contacts who are working for the company that you want to add to the segment.';                    }                    field(AllowRelatedCompaines; AllowCoRepdByContPerson)                    {                        ApplicationArea = RelationshipMgmt;                        Caption = 'Allow Related Companies';                        Importance = Additional;                        MultiLine = true;                        ToolTip = 'Specifies if companies represented by person contacts are included in the segment.';                    }                    field(IgnoreExclusion; IgnoreExclusion)                    {                        ApplicationArea = RelationshipMgmt;                        Caption = 'Ignore Exclusion';                        Importance = Additional;                        ToolTip = 'Specifies if contacts are excluded for which the Exclude from Segment field has been selected on the contact card.';                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnPostReport()    begin        if ExpandCompanies then            AddPeople();        if AllowCoRepdByContPerson then            AddCompanies();        OnPostReportOnBeforeUpdateSegLines("Segment Header");        UpdateSegLines();    end;    trigger OnPreReport()    begin        ItemFilters := "Value Entry".HasFilter;        SegCriteriaManagement.InsertCriteriaAction(          "Segment Header".GetFilter("No."), REPORT::"Add Contacts",          AllowExistingContact, ExpandCompanies, AllowCoRepdByContPerson, IgnoreExclusion, false);        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::Contact,          Contact.GetFilters, Contact.GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Contact Profile Answer",          "Contact Profile Answer".GetFilters, "Contact Profile Answer".GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Contact Mailing Group",          "Contact Mailing Group".GetFilters, "Contact Mailing Group".GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Interaction Log Entry",          "Interaction Log Entry".GetFilters, "Interaction Log Entry".GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Contact Job Responsibility", "Contact Job Responsibility".GetFilters,          "Contact Job Responsibility".GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Contact Industry Group",          "Contact Industry Group".GetFilters, "Contact Industry Group".GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Contact Business Relation",          "Contact Business Relation".GetFilters, "Contact Business Relation".GetView(false));        SegCriteriaManagement.InsertCriteriaFilters(          "Segment Header".GetFilter("No."), DATABASE::"Value Entry",          "Value Entry".GetFilters, "Value Entry".GetView(false));    end;    var        Cont: Record Contact;        SegLine: Record "Segment Line";        SegmentHistoryMgt: Codeunit SegHistoryManagement;        Window: Dialog;        NextLineNo: Integer;        ItemFilters: Boolean;        AllowExistingContact: Boolean;        ExpandCompanies: Boolean;        AllowCoRepdByContPerson: Boolean;        IgnoreExclusion: Boolean;        SkipItemLedgerEntry: Boolean;        NoOfRecords: Integer;        RecordNo: Integer;        OldDateTime: DateTime;        NewDateTime: DateTime;        OldProgress: Integer;        NewProgress: Integer;#pragma warning disable AA0074        Text000: Label 'Inserting contacts @1@@@@@@@@@@@@@';#pragma warning restore AA0074    protected var        TempCont: Record Contact temporary;        TempCont2: Record Contact temporary;        SegCriteriaManagement: Codeunit SegCriteriaManagement;        ContactOK: Boolean;    procedure SetOptions(OptionAllowExistingContact: Boolean; OptionExpandCompanies: Boolean; OptionAllowCoRepdByContPerson: Boolean; OptionIgnoreExclusion: Boolean)    begin        AllowExistingContact := OptionAllowExistingContact;        ExpandCompanies := OptionExpandCompanies;        AllowCoRepdByContPerson := OptionAllowCoRepdByContPerson;        IgnoreExclusion := OptionIgnoreExclusion;    end;    procedure InsertContact(var CheckedCont: Record Contact)    begin        TempCont := CheckedCont;        if TempCont.Insert() then;    end;    local procedure AddCompanies()    begin        TempCont.Reset();        if TempCont.Find('-') then            repeat                TempCont2 := TempCont;                if TempCont2.Insert() then;                if TempCont."Company No." <> '' then begin                    Cont.Get(TempCont."Company No.");                    TempCont2 := Cont;                    if TempCont2.Insert() then;                end;            until TempCont.Next() = 0;        TempCont.DeleteAll();        if TempCont2.Find('-') then            repeat                TempCont := TempCont2;                TempCont.Insert();            until TempCont2.Next() = 0;        TempCont2.DeleteAll();    end;    local procedure AddPeople()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeAddPeople(TempCont, TempCont2, Cont, "Contact Mailing Group", IsHandled);        if IsHandled then            exit;        TempCont.Reset();        if TempCont.Find('-') then            repeat                if TempCont."Company No." <> '' then begin                    Cont.SetCurrentKey("Company No.");                    Cont.SetRange("Company No.", TempCont."Company No.");                    if Cont.Find('-') then                        repeat                            TempCont2 := Cont;                            if TempCont2.Insert() then;                        until Cont.Next() = 0                end else begin                    TempCont2 := TempCont;                    TempCont2.Insert();                end;            until TempCont.Next() = 0;        TempCont.DeleteAll();        if TempCont2.Find('-') then            repeat                TempCont := TempCont2;                TempCont.Insert();            until TempCont2.Next() = 0;        TempCont2.DeleteAll();    end;    local procedure UpdateSegLines()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeUpdateSegLines("Segment Header", IsHandled);        if IsHandled then            exit;        SegLine.SetRange("Segment No.", "Segment Header"."No.");        if SegLine.FindLast() then            NextLineNo := SegLine."Line No." + 10000        else            NextLineNo := 10000;        TempCont.Reset();        TempCont.SetCurrentKey("Company Name", "Company No.", Type, Name);        if not IgnoreExclusion then            TempCont.SetRange("Exclude from Segment", false);        if TempCont.Find('-') then            repeat                ContactOK := true;                if not AllowExistingContact then begin                    SegLine.SetCurrentKey("Contact No.", "Segment No.");                    SegLine.SetRange("Contact No.", TempCont."No.");                    SegLine.SetRange("Segment No.", "Segment Header"."No.");                    if SegLine.FindFirst() then                        ContactOK := false;                end;                OnBeforeInsertSegmentLine(                  TempCont, AllowExistingContact, ExpandCompanies, AllowCoRepdByContPerson, IgnoreExclusion, ContactOK);                if ContactOK then begin                    SegLine.Init();                    SegLine."Line No." := NextLineNo;                    SegLine.Validate("Segment No.", "Segment Header"."No.");                    SegLine.Validate("Contact No.", TempCont."No.");                    SegLine.Insert(true);                    SegmentHistoryMgt.InsertLine(                      SegLine."Segment No.", SegLine."Contact No.", SegLine."Line No.");                    NextLineNo := SegLine."Line No." + 10000;                end;            until TempCont.Next() = 0;    end;    procedure FindContInPostDocuments(ContactNo: Code[20]; ValueEntry: Record "Value Entry"): Boolean    var        SalesShptHeader: Record "Sales Shipment Header";        SalesInvHeader: Record "Sales Invoice Header";        ReturnRcptHeader: Record "Return Receipt Header";        SalesCrMemoHeader: Record "Sales Cr.Memo Header";        PurchRcptHeader: Record "Purch. Rcpt. Header";        PurchInvHeader: Record "Purch. Inv. Header";        ReturnShptHeader: Record "Return Shipment Header";        PurchCrMemoHeader: Record "Purch. Cr. Memo Hdr.";    begin        case ValueEntry."Source Type" of            ValueEntry."Source Type"::Customer:                begin                    if SalesInvHeader.ReadPermission then                        if SalesInvHeader.Get(ValueEntry."Document No.") then                            if (SalesInvHeader."Sell-to Contact No." = ContactNo) or                               (SalesInvHeader."Bill-to Contact No." = ContactNo)                            then                                exit(true);                    if SalesShptHeader.ReadPermission then                        if SalesShptHeader.Get(ValueEntry."Document No.") then                            if (SalesShptHeader."Sell-to Contact No." = ContactNo) or                               (SalesShptHeader."Bill-to Contact No." = ContactNo)                            then                                exit(true);                    if SalesCrMemoHeader.ReadPermission then                        if SalesCrMemoHeader.Get(ValueEntry."Document No.") then                            if (SalesCrMemoHeader."Sell-to Contact No." = ContactNo) or                               (SalesCrMemoHeader."Bill-to Contact No." = ContactNo)                            then                                exit(true);                    if ReturnRcptHeader.ReadPermission then                        if ReturnRcptHeader.Get(ValueEntry."Document No.") then                            if (ReturnRcptHeader."Sell-to Contact No." = ContactNo) or                               (ReturnRcptHeader."Bill-to Contact No." = ContactNo)                            then                                exit(true);                end;            ValueEntry."Source Type"::Vendor:                begin                    if PurchInvHeader.ReadPermission then                        if PurchInvHeader.Get(ValueEntry."Document No.") then                            if (PurchInvHeader."Buy-from Contact No." = ContactNo) or                               (PurchInvHeader."Pay-to Contact No." = ContactNo)                            then                                exit(true);                    if ReturnShptHeader.ReadPermission then                        if ReturnShptHeader.Get(ValueEntry."Document No.") then                            if (ReturnShptHeader."Buy-from Contact No." = ContactNo) or                               (ReturnShptHeader."Pay-to Contact No." = ContactNo)                            then                                exit(true);                    if PurchCrMemoHeader.ReadPermission then                        if PurchCrMemoHeader.Get(ValueEntry."Document No.") then                            if (PurchCrMemoHeader."Buy-from Contact No." = ContactNo) or                               (PurchCrMemoHeader."Pay-to Contact No." = ContactNo)                            then                                exit(true);                    if PurchRcptHeader.ReadPermission then                        if PurchRcptHeader.Get(ValueEntry."Document No.") then                            if (PurchRcptHeader."Buy-from Contact No." = ContactNo) or                               (PurchRcptHeader."Pay-to Contact no." = ContactNo)                            then                                exit(true);                end;        end;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeAddPeople(var TempContact: Record Contact temporary; var TempContact2: Record Contact temporary; Contact: Record Contact; ContactMailingGroup: Record "Contact Mailing Group"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertSegmentLine(var TempContact: Record Contact temporary; AllowExistingContact: Boolean; ExpandCompanies: Boolean; AllowCoRepdByContPerson: Boolean; IgnoreExclusion: Boolean; var ContactOK: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateSegLines(var SegmentHeader: Record "Segment Header"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnPostReportOnBeforeUpdateSegLines(var SegmentHeader: Record "Segment Header")    begin    end;}