how to check for the duplicates ?

[bandsb]

Hi

I builded a new module using module builder, i created a default field called sheet_name, i dont want allow duplicate values to sheet_name, When user saving the data, it should check the existing sheet_names in db, and if any thing exist with the same name, i want to show the error message saying that already another sheet exists with this name.. any help would be appreciated

Thanks
bands

[andopes]

Hi bands

You need to implement an ajax based javascript on button SAVE to query database against existing duplicates.
How are your skills regarding php, ajax, javascript and SugarCRM development?

Cheers

[bands]

Thanks Andopes

I have experience with php , and sugarcrm

Can u guide me the step by step process to accomplish my requirement. ( in which files i should write the hack for this)

so that i can code as per your guide lines

I really appreciate your help.

Thanks
bands

[andopes]

Hi Bands

Create a view.edit.php for your custom modules and implement the function process like that:

     function process() {
        parent::process();
 
        global $db;
        
        $fields = array();
        $query = "SELECT DISTINCT sheet_name FROM <table_name> WHERE deleted = 0";
        $result = $db->query($query, true, "Error retrieving sheet_name values: ");
 
        while($row = $db->fetchByAssoc($result)) {
            $fields[] = $row['sheet_name'];
        }
 
        $json_fields = json_encode($fields);
        echo "<script>addToValidateIsInArray('EditView', 'sheet_name', 'in_array', 'true', 'Duplicated value on database', '{$json_fields}', '==')</script>";
    } 
  

Obviously you have to consider modify something to fits your needs.

Cheers

[bands]

Andopes Thanks for your help .

Created a file view.edit.php in modules/Sheets folder,

added the class called SheetsEditview extends EditView

in that class called the function process.

when i check for the validation, even this page is not getting executed.

Could you please correct me.

I really appreciate your help Andopes.

Thanks
bands

[andopes]

Hi Bands

This night I'll deliver the new release of DevToolKit which implements in an easy to use way such feature.

Kind regards

[andopes]

I just released the DevToolKit 0.5 which implements the Duplicate Fields Validation.

Enjoy this and let me know if you face any issue.

Regards

[meryblue82]

Hello:
I use a translator to write this post ... sorry for my slightly English

My doubt is the following one, install the DevToolKit 0.5, create a module that is called " Alumnos ", I have did everything that thing about the user's guide, I create the view.edit.php, view.detail.php and the view.list.php, my need was use checkForDuplicates for a field inside the module, I did it as he was saying in the user's guide inside the matadata create a check_duplicate_fields.php, but it does not work, it does not verify that the fact does not repeat itself...

This are my codes:

Edit

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
require_once('include/MVC/View/views/view.edit.php');
class AlumnosViewEdit extends ViewEdit {
private $manager;
function init($bean = null, $view_object_map = array()) {
parent::init($bean, $view_object_map);
require_once('custom/include/utils/DevToolKitManager.php');
$this->manager = new DevToolKitManager($this);
}function display() {
$this->manager->display();
$this->ev->process();
echo $this->ev->display();
}
function process() {
parent::process();
$this->manager->process();
}
}
?>  

Detail

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
require_once('include/MVC/View/views/view.detail.php');
class AlumnosViewDetail extends ViewDetail {
private $manager;
    function init($bean = null, $view_object_map = array()) {
parent::init($bean, $view_object_map);
require_once('custom/include/utils/DevToolKitManager.php');
$this->manager = new DevToolKitManager($this);    }
function process() {
$this->manager->process();
parent::process();
}
}
?>  

List

 <?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
require_once('include/MVC/View/views/view.list.php');
class AlumnosViewList extends ViewList {
private $manager;
    function init($bean = null, $view_object_map = array()) {
parent::init($bean, $view_object_map);
require_once('custom/include/utils/DevToolKitManager.php');
$this->manager = new DevToolKitManager($this);
    }
function process() {
$this->manager->process();
parent::process();}
}
?>  

And check

 <?php
$check_duplicate_fields = array(
'run_alumno'
);
?>  

run_alumno is a unique number for every student ....

Can you Help Me?

[andopes]

Hi Mary Blue

Thank you for trying this.

Figure it out some details:
Make sure the module name has no a prefix, like blue_Alumnos;
Make sure you had specified the correct name for the metadata file: check_duplicate_fields.php

Cheers

[meryblue82]

Hello andropes:

Thanks for your answer, the truth is that my module is called re01_Alumnos therefore modify the php files view.edit, view.detail and view.list in the line of the file where it says "class re01_AlumnosViewDetail extends ViewDetail", on the other hand, I realized that the files should go into the folder CUSTOM and not in MODULES, I made all these modification, but still does not work check_duplicate_fields.php ...

Any idea?