Codeunit 5060 DuplicateManagement
src/Layers/W1/BaseApp/CRM/Duplicates/DuplicateManagement.Codeunit.al259 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.Duplicates;using Microsoft.CRM.Contact;using Microsoft.CRM.Setup;using System.Environment.Configuration;codeunit 5060 DuplicateManagement{ Permissions = tabledata "Marketing Setup" = r, tabledata "Contact Duplicate" = rid, tabledata "Cont. Duplicate Search String" = rid, tabledata "Duplicate Search String Setup" = r; trigger OnRun() begin end; var RMSetup: Record "Marketing Setup";#pragma warning disable AA0074 Text000: Label 'Duplicate Contacts were found. Would you like to process these?';#pragma warning restore AA0074 DuplicateContactExistMsg: Label 'There are duplicate contacts.'; OpenContactDuplicatesPageLbl: Label 'Show'; procedure MakeContIndex(Cont: Record Contact) var DuplSearchStringSetup: Record "Duplicate Search String Setup"; IsHandled: Boolean; begin IsHandled := false; OnMakeContIndex(Cont, IsHandled); if IsHandled then exit; RMSetup.Get(); RemoveContIndex(Cont, true); if DuplSearchStringSetup.Find('-') then repeat InsDuplContIndex(Cont, DuplSearchStringSetup); until DuplSearchStringSetup.Next() = 0; IsHandled := false; OnMakeContIndexOnBeforeInsDuplCont(Cont, IsHandled); if not IsHandled then InsDuplCont(Cont, RMSetup."Search Hit %"); end; procedure RemoveContIndex(Cont: Record Contact; KeepAccepted: Boolean) var DuplContSearchString: Record "Cont. Duplicate Search String"; ContactDuplicate: Record "Contact Duplicate"; IsHandled: Boolean; begin IsHandled := false; OnBeforeRemoveContIndex(Cont, KeepAccepted, IsHandled); if IsHandled then exit; DuplContSearchString.SetRange("Contact Company No.", Cont."No."); if DuplContSearchString.FindFirst() then DuplContSearchString.DeleteAll(); ContactDuplicate.FilterGroup(-1); ContactDuplicate.SetRange("Contact No.", Cont."No."); ContactDuplicate.SetRange("Duplicate Contact No.", Cont."No."); ContactDuplicate.FilterGroup(0); if KeepAccepted then ContactDuplicate.SetRange("Separate Contacts", false); ContactDuplicate.DeleteAll(true); end; procedure DuplicateExist(Cont: Record Contact) Result: Boolean var ContactDuplicate: Record "Contact Duplicate"; IsHandled: Boolean; begin IsHandled := false; OnBeforeDuplicateExist(Cont, Result, IsHandled); if IsHandled then exit(Result); RMSetup.Get(); if not RMSetup."Autosearch for Duplicates" then exit(false); ContactDuplicate.FilterGroup(-1); ContactDuplicate.SetRange("Contact No.", Cont."No."); ContactDuplicate.SetRange("Duplicate Contact No.", Cont."No."); ContactDuplicate.FilterGroup(0); ContactDuplicate.SetRange("Separate Contacts", false); exit(ContactDuplicate.Find('=<>')); end; procedure LaunchDuplicateForm(Cont: Record Contact) var ContactDuplicate: Record "Contact Duplicate"; begin if Confirm(Text000, true) then begin ContactDuplicate.SetRange("Contact No.", Cont."No."); PAGE.RunModal(PAGE::"Contact Duplicates", ContactDuplicate); end end; local procedure InsDuplContIndex(Cont: Record Contact; DuplSearchStringSetup: Record "Duplicate Search String Setup") var DuplContSearchString: Record "Cont. Duplicate Search String"; ContactRecRef: RecordRef; begin ContactRecRef.GetTable(Cont); DuplContSearchString.Init(); DuplContSearchString."Contact Company No." := Cont."No."; DuplContSearchString."Field No." := DuplSearchStringSetup."Field No."; DuplContSearchString."Part of Field" := DuplSearchStringSetup."Part of Field"; DuplContSearchString."Search String" := ComposeSearchString( ContactRecRef, DuplContSearchString."Field No.", DuplSearchStringSetup."Part of Field", DuplSearchStringSetup.Length); OnInsDuplContIndexOnBeforeDuplContSearchStringInsert(Cont, DuplContSearchString, DuplSearchStringSetup); if DuplContSearchString."Search String" <> '' then DuplContSearchString.Insert(); end; local procedure InsDuplCont(Cont: Record Contact; HitRatio: Integer) var DuplContSearchString: Record "Cont. Duplicate Search String"; DuplContSearchString2: Record "Cont. Duplicate Search String"; TempContactDuplicate: Record "Contact Duplicate" temporary; DuplCont2: Record "Contact Duplicate"; DuplSearchStringSetup: Record "Duplicate Search String Setup"; begin DuplContSearchString.SetRange("Contact Company No.", Cont."No."); if DuplContSearchString.Find('-') then repeat DuplContSearchString2.ReadIsolation(IsolationLevel::ReadUncommitted); DuplContSearchString2.SetCurrentKey("Field No.", "Part of Field", "Search String"); DuplContSearchString2.SetRange("Field No.", DuplContSearchString."Field No."); DuplContSearchString2.SetRange("Part of Field", DuplContSearchString."Part of Field"); DuplContSearchString2.SetRange("Search String", DuplContSearchString."Search String"); DuplContSearchString2.SetFilter("Contact Company No.", '<>%1', DuplContSearchString."Contact Company No."); OnInsDuplContOnAfterDuplContSearchString2SetFilters(DuplContSearchString, DuplContSearchString2); if DuplContSearchString2.Find('-') then repeat if TempContactDuplicate.Get(DuplContSearchString."Contact Company No.", DuplContSearchString2."Contact Company No.") then begin if not TempContactDuplicate."Separate Contacts" then begin TempContactDuplicate."No. of Matching Strings" := TempContactDuplicate."No. of Matching Strings" + 1; TempContactDuplicate.Modify(); end; end else begin TempContactDuplicate."Contact No." := DuplContSearchString."Contact Company No."; TempContactDuplicate."Duplicate Contact No." := DuplContSearchString2."Contact Company No."; TempContactDuplicate."Separate Contacts" := false; TempContactDuplicate."No. of Matching Strings" := 1; TempContactDuplicate.Insert(); end; until DuplContSearchString2.Next() = 0; until DuplContSearchString.Next() = 0; TempContactDuplicate.SetFilter("No. of Matching Strings", '>=%1', Round(DuplSearchStringSetup.Count * HitRatio / 100, 1, '>')); OnInsDuplContOnAfterDuplContSetFilters(TempContactDuplicate, DuplContSearchString, DuplSearchStringSetup); if TempContactDuplicate.Find('-') then begin repeat DuplCont2 := TempContactDuplicate; if not DuplCont2.Get(TempContactDuplicate."Contact No.", TempContactDuplicate."Duplicate Contact No.") and not DuplCont2.Get(TempContactDuplicate."Duplicate Contact No.", TempContactDuplicate."Contact No.") then DuplCont2.Insert(true); until TempContactDuplicate.Next() = 0; TempContactDuplicate.DeleteAll(); end; end; procedure ComposeIndexString(var RecRef: RecordRef; FieldNo: Integer; "Part": Option First,Last; ChrToCopy: Integer): Text[10] begin exit(ComposeSearchString(RecRef, FieldNo, "Duplicate Search String Part".FromInteger("Part"), ChrToCopy)); end; procedure ComposeSearchString(var RecRef: RecordRef; FieldNo: Integer; StringPart: Enum "Duplicate Search String Part"; ChrToCopy: Integer): Text[10] var FieldRef: FieldRef; InString: Text; begin FieldRef := RecRef.Field(FieldNo); InString := Format(FieldRef.Value); InString := DelChr(InString, '=', ' +"&/,.;:-_(){}#!£$\'); if StrLen(InString) < ChrToCopy then ChrToCopy := StrLen(InString); if ChrToCopy > 0 then if StringPart = StringPart::First then InString := CopyStr(InString, 1, ChrToCopy) else InString := CopyStr(InString, StrLen(InString) - ChrToCopy + 1, ChrToCopy); exit(CopyStr(UpperCase(InString), 1, 10)); end; procedure Notify() var NotificationLifecycleMgt: Codeunit "Notification Lifecycle Mgt."; DuplicateContNotification: Notification; DummyRecID: RecordId; begin DuplicateContNotification.Message(DuplicateContactExistMsg); DuplicateContNotification.AddAction(OpenContactDuplicatesPageLbl, Codeunit::DuplicateManagement, 'RunModalContactDuplicates'); NotificationLifecycleMgt.SendNotification(DuplicateContNotification, DummyRecID); end; procedure RunModalContactDuplicates(Notification: Notification) begin PAGE.RunModal(PAGE::"Contact Duplicates"); end; [IntegrationEvent(false, false)] local procedure OnBeforeRemoveContIndex(Contact: Record Contact; KeepAccepted: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeDuplicateExist(Contact: Record Contact; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnInsDuplContIndexOnBeforeDuplContSearchStringInsert(var Contact: Record Contact; var DuplContSearchString: Record "Cont. Duplicate Search String"; DuplSearchStringSetup: Record "Duplicate Search String Setup") begin end; [IntegrationEvent(false, false)] local procedure OnInsDuplContOnAfterDuplContSearchString2SetFilters(var DuplContSearchString: Record "Cont. Duplicate Search String"; var DuplContSearchString2: Record "Cont. Duplicate Search String") begin end; [IntegrationEvent(false, false)] local procedure OnInsDuplContOnAfterDuplContSetFilters(var TempDuplCont: Record "Contact Duplicate" temporary; var DuplContSearchString: Record "Cont. Duplicate Search String"; var DuplSearchStringSetup: Record "Duplicate Search String Setup") begin end; [IntegrationEvent(false, false)] local procedure OnMakeContIndex(var Contact: Record Contact; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnMakeContIndexOnBeforeInsDuplCont(var Contact: Record Contact; var IsHandled: Boolean) begin end;}