How to do backround query on button click

[vistar86]

Hi i wonder if this is possible at all, i have textbox named "serial_number_c" and a submit button in edit view (both custom) and when user clicks button, i want it to check to see if the text from the "serial_number_c" value is in the table already and if so then populate some data into the editview textboxes from the record found.

thanks in advance

[SagarCRM]

You can do this using ajax functionality on save button click
or onblur event of textbox
or before editview load you can store data fetched from db in variable abd can compare before saving using javascript (not recommended) .
I have done this in one of my module on onblur event.


keep rocking !!!

[vistar86]

ok this sounds good, but where to start? any pointers? when i add custom php code to editview it makes css mess up.

do i need to add this code to editviewvardefs? or code in views/edit.view.php? or both?

where can i code the onblur event? and example?

do you or anyone have any examples, or link to a tutorial?

thanks for your response.

[SagarCRM]

ok this sounds good, but where to start? any pointers? when i add custom php code to editview it makes css mess up.

do i need to add this code to editviewvardefs? or code in views/edit.view.php? or both?

where can i code the onblur event? and example?

do you or anyone have any examples, or link to a tutorial?

thanks for your response.

Hi Vistar,
For using javascript you have to do a lot of stuff bu my way.
Well it starts from creating javascript file in your cutom/modules/<module_name>/EditView.js

the file will contain code somthing like this:

window.onload = load;
function load(){

textboxid.onblur = function(){checkduplicate()}

}

function checkduplicate()
{
//your ajax functionality which will disable your save button if serial number is duplicated
}

then you have to include your javascript file in your editviewdefs.php

it will look something like this

     'templateMeta' => 
    array (
      'includes' => 
      array (
        0 => 
        array (
          'file' => 'custom/modules/<module_name>/EditView.js',
        ),
      ),
      'maxColumns' => '2',
      'form' => 
  

hope this will be helpfull..

Keep rocking !!!

[vistar86]

That does not seem to work for me, i'm using sugar 6.1 and both module and fields are custom.

heres what i did:

stuck this in custom/modules/GBM_Repairs/editView.js

 window.onload = load;
function load(){
 
serial_number_c.onblur = function(){checkduplicate()}
 
}
 
function checkduplicate()
{
alert('works');
} 
  

and heres my editviewdefs.php:

 $module_name = 'GBM_Repairs';
$_object_name = 'gbm_repairs';
$viewdefs[$module_name]['EditView'] = array(
 
 
    'templateMeta' => array('maxColumns' => '2', 
                            'widths' => array(
                                            array('label' => '10', 'field' => '30'), 
                                            array('label' => '10', 'field' => '30')
                                            ), 
                                            
                                            
                                            'includes' => 
                                            array (
                                            0 => 
                                            array (
                                            'file' => 'custom/modules/GBM_Repairs/EditView.js',
                                            ),
                                            ),           
                                            
                                            ),
      
                                            
 'panels' =>array (
  'default' => 
  array (
    
    array (
      
      array (
        'name' => $_object_name . '_number',
        'type' => 'readonly',
      ),
      'assigned_user_name',
    ),
    
    array (
      'priority',
    ),
    
    array (
      'resolution',
      'status',
    ),
 
    array (
      array('name'=>'name', 'displayParams'=>array('size'=>60)),
    ),
    
    array (
      'description',
    ),
    
    
    array (
      'work_log',
    ),
  ),
                                                    
),
                        
); 
  

can you point out where i'm going wrong, i am in developer mode also.

[SagarCRM]

Hi vistar,
your code should be something like this,

 
    'templateMeta' => array(
                        'includes' => 
                        array (
                        0 => 
                        array (
                        'file' => 'custom/modules/GBM_Repairs/EditView.js',
                        ),
                                           ),
                        'maxColumns' => '2', 
                            'widths' => array(
                                            array('label' => '10', 'field' => '30'), 
                                            array('label' => '10', 'field' => '30')
                                            ), 
                                            ),           
                                            
                        ), 
  

hope this will work fine

Keep rAwKing!!!

[vistar86]

heres my new editviewdefs.php:

  
$module_name = 'GBM_Repairs';
$_object_name = 'gbm_repairs';
$viewdefs[$module_name]['EditView'] = array(
 
 
    'templateMeta' => array(
                        'includes' => 
                        array (
                        0 => 
                        array (
                        'file' => 'modules/GBM_Repairs/EditView.js',
                        ),
                                           ),
                        'maxColumns' => '2', 
                            'widths' => array(
                                            array('label' => '10', 'field' => '30'), 
                                            array('label' => '10', 'field' => '30')
                                            ), 
                                            ),           
                                            
                        ),  
      
                                            
 'panels' =>array (
  'default' => 
  array (
    
    array (
      
      array (
        'name' => $_object_name . '_number',
        'type' => 'readonly',
      ),
      'assigned_user_name',
    ),
    
    array (
      'priority',
    ),
    
    array (
      'resolution',
      'status',
    ),
 
    array (
      array('name'=>'name', 'displayParams'=>array('size'=>60)),
    ),
    
    array (
      'description',
    ),
    
    
    array (
      'work_log',
    ),
  ),
                                                    
),
                        
); 
  

and my EditView.js:

 window.onload = load;
function load(){
 
serial_number_c.onblur = function(){checkduplicate()}
 
}
 
function checkduplicate()
{
alert('works');
} 
  

It's still not doing anything???

i just realised too, as this is javascript, how am i supposed to query database in JS?? is that possible...

[SagarCRM]

where your javascript file situated in???????
is it in custom module directory or in module directory????

  'file' => 'modules/GBM_Repairs/EditView.js', 
  

if its situated in custom folder it'll be like

  'file' => 'custom/modules/GBM_Repairs/EditView.js', 
  

you have to call AJAX in javascript

[vistar86]

i'm working in modules directory directly, i'm not updating the system so this shouldn't be an issue.

Looking through firebug, the JS is not even being called in editView.

does it have to be done in custom directory for it to work?

i've never coded in Ajax, so is there any other way to do it in PHP or javascript?

thanks for your responses, much appreciated pal.

[SagarCRM]

Well I'm newbie in Sugar, So i do prefer ajax for such cases, you can include javascript file in another way too...

in edit view.edit.php

     function display(){
        
     $javascript = file_get_contents('custom/modules/<module_name>/EditView.js');
    echo $javascript; 
  

the file will contain same javascript file as above adding <script> snippet

 <script type="text/javascript">
 
window.onload = load;
function load(){
 
serial_number_c.onblur = function(){checkduplicate()}
 
}
 
function checkduplicate()
{
alert('works');
}  
 
</script>