Check duplication based on field condition in sugarcrm 7

Question

Am checking duplicate check in Accounts module based on some filed condition.

In Account i have a dropdown field called Account Type with options as
1. Organisation

2. Individual

if i select Account Type == Organisation then i have to check duplicates for some specific fields field1,field2,field3,field4.

and

if i select Account Type == Individual then i have to check duplicates for fields field1,field2,field5,field6.

How this can be achieve in sugarcrm 7.7 version.

I found one article for Duplication check but i want conditional based duplication checkup

Can any one please help me out from this

Thanks in advance

Regards

Sam

Sam Roy · Accepted Answer

Hi Sam Roy

You can try following code, which worked for me:

./custom/Extension/modules/Accounts/Ext/Vardefs/<file>.php

$dictionary['Account']['duplicate_check']['FilterDuplicateCheck'] = array(
    'filter_template' => array(
        array(
  '$or' => array(
  array(
  '$and' => array(
  array('account_type' => array('$equals' => 'Organisation')),
  array(
  '$or' => array(
  array('field1' => array('$equals' => '$field1')),  
  array('field2' => array('$equals' => '$field2')),  
  array('field3' => array('$equals' => '$field3')),  
  array('field4' => array('$equals' => '$field4'))
  )
  ),
  )
  ),
  array(
  '$and' => array(
  array('account_type' => array('$equals' => 'Individual')),
  array(
  '$or' => array(
  array('field1' => array('$equals' => '$field1')),  
  array('field2' => array('$equals' => '$field2')),  
  array('field5' => array('$equals' => '$field5')),  
  array('field6' => array('$equals' => '$field6'))
  )
  ),
  )
  ),
  )
        ),
    ),    
);

Or if you want to check for more condition base then go for below code:

./custom/Extension/modules/Accounts/Ext/Vardefs/<file>.php

<?php
$dictionary['Account']['duplicate_check'] = array(
  'enabled' => true,
  'OneFieldDuplicateCheck' => array(
            'field' => 'name'
        )
);

Replace OneFieldDuplicateCheck with following:

'MultipleFieldDuplicateCheck' => array(            
            'field' => 'account_type',
            'field1' => 'xxxxx',
            'field2' => 'xxxxx',
            'field3' => 'xxxxx',
            'field4' => 'xxxxx',
            'field5' => 'xxxxx'
        )

Now ./custom/data/duplicatecheck/MultipleFieldDuplicateCheck.php

<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');


class MultipleFieldDuplicateCheck extends DuplicateCheckStrategy
{


    protected $field;


    public function setMetadata($metadata)
    {
        if (isset($metadata['field'])) {            
            $this->field1 = $metadata['field1'];
            $this->field2 = $metadata['field2'];
            $this->field3 = $metadata['field3'];
            $this->field4 = $metadata['field4'];
            $this->field5 = $metadata['field5'];
        }
    }


    public function findDuplicates()
    {
        if($this->bean->{$this->field} == 'Individual'){
  $Query = new SugarQuery();
  $Query->from($this->bean); $Query->where()->queryOr()->ends($this->field1,$this->bean->{$this->field1})->equals($this->field2,$this->bean->{$this->field2})->equals($this->field5,$this->bean->{$this->field5})->equals($this->field6,$this->bean->{$this->field6});
  //Filter out the same Bean during Edits
  if (!empty($this->bean->id)) { 
  $Query->where()->notEquals('id',$this->bean->id);
  }
  $Query->limit(10);
  }else if($this->bean->{$this->field} == 'Organisation'){
  $Query = new SugarQuery();
  $Query->from($this->bean); $Query->where()->queryOr()->ends($this->field1,$this->bean->{$this->field1})->equals($this->field2,$this->bean->{$this->field2})->equals($this->field3,$this->bean->{$this->field3})->equals($this->field4,$this->bean->{$this->field4});
  //Filter out the same Bean during Edits
  if (!empty($this->bean->id)) { 
  $Query->where()->notEquals('id',$this->bean->id);
  }
  $Query->limit(10);

  }  
  $results = $Query->execute();        
        return array(
            'records' => $results
        );
    }
}

Hope this Helps

Best Regards

S Ramana Raju