Hi
I want to execute an sql statement in the before save logic hook.
I have tried
$GLOBALS['db']->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");
$db = DBManagerFactory::getInstance();
$res = $db->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");
But it is not working.Shijin Krishna@
If you use before save logic hook in module Users, Sugar logic overwrites field [Description].
You need use this:
function customHook(&$focus, $event, $arguments){
$focus->description = 'test';
}
Update the bean instead
$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');
$user->description = 'Test';
Hi Gustav Lindstrom
I have tried
$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');
$user->description = 'Test';
but it wasnt working.
You also need this:
$user->save();
Hi Anand Chitikela,
Have you tried like global $db; to get $db instead of creating db instance.
Can you please try below two possibilities
1.
global $db;
$res = $db->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");
2.
require_once('data/BeanFactory.php');
$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');
$user->description = 'Test';
$user->save();
Thanks!.
If it's an before save hook and it's the same record/bean that jst got saved he can't do a save bean, that will create a infinite loop. He should do it the way Roman adviced, change bean that is handed with the function.
Hi Roman and Gustav
I am currently work in on sugarcrm version 7.6.I have used
class logic_hooks_class{
function before_save_method($bean, $event, $arguments){
$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');
$user->description = 'Test';
$user->save();//line 8
}
But this was throwing
Fatal error: Call to undefined method stdClass::save() in /<>/custom/modules/Users/logic_hooks_class.php on line 8
Hi Ajay
I have tried the above ways but it was not doing my work.I am currently work in on sugarcrm version 7.6
Hello Anand Chitikela,
I tested below code in contacts module sugar ent 7.6.1.0.It is working for me.
/crm/custom/Extension/modules/Contacts/Ext/LogicHooks/logic_hooks.php
<?php
$hook_version = 1;
$hook_array = array();
$hook_array['before_save'] = array();
$hook_array['before_save'][] = array(
1,
'test',
'custom/modules/Contacts/customLogicHook.php',
'TestClass',
'TestFunction'
);
?>
/crm/custom/modules/Contacts/customLogicHook.php
<?php
if(!defined('sugarEntry')) die('Not a valid entry point');
class TestClass
{
function TestFunction($bean, $event, $arguments)
{
$bean->phone_mobile='556677';
$GLOBALS['log']->fatal("before save logic hook gets called");
}
}
?>
Hello Anand Chitikela,
I tested below code in contacts module sugar ent 7.6.1.0.It is working for me.
/crm/custom/Extension/modules/Contacts/Ext/LogicHooks/logic_hooks.php
<?php
$hook_version = 1;
$hook_array = array();
$hook_array['before_save'] = array();
$hook_array['before_save'][] = array(
1,
'test',
'custom/modules/Contacts/customLogicHook.php',
'TestClass',
'TestFunction'
);
?>
/crm/custom/modules/Contacts/customLogicHook.php
<?php
if(!defined('sugarEntry')) die('Not a valid entry point');
class TestClass
{
function TestFunction($bean, $event, $arguments)
{
$bean->phone_mobile='556677';
$GLOBALS['log']->fatal("before save logic hook gets called");
}
}
?>
Please make sure your logic hook file is getting called,by printing something to log.
Hi Ajay
Actually i want to execute an sql query inside the logic hook as i start up i am using the above query.The code which you have mentioned a above is working for me but need to run an sql query inside the logichook
Ok.Have you tried like below,
global $db;
$res = $db->query("UPDATE contacts SET description='test' WHERE id='102162e1-62cd-1fa3-1bcf-556fb62dc90b'");
Hi Ajay
Yes i have tried.But the sql statement was not updating.
Is it throwing any error to log?
It will be easy to figure it out the issue,if you paste the code here.
Hi Ajay
This is the code which i am using for executing an sql statement in the before save logic hook
<>/custom/modules/Users/logic_hooks_class.php
$hook_version = 1;
$hook_array = array();
$hook_array['before_save'] = array();
$hook_array['before_save'][] = Array(
//Processing index. For sorting the array.
1,
'before_save example',
'custom/modules/Users/logic_hooks_class.php',
'logic_hooks_class',
'before_save_method'
);
In
<>/custom/modules/Users/logic_hooks.php
<?php
if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
class logic_hooks_class{
function before_save_method($bean, $event, $arguments){
global $db;
$res = $db->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");
}
}
You have defined wrong path in logic hook definition file.
And
Here is the code snippet to update description field.
Create a file in below path
/crm/custom/Extension/modules/Users/Ext/LogicHooks/logic_hooks_class.php
and content is like below,
<?php
$hook_version = 1;
$hook_array = array();
$hook_array['before_save'] = array();
$hook_array['before_save'][] = Array(
//Processing index. For sorting the array.
1,
'before_save example',
'custom/modules/Users/UpdateDescription.php',
'update_Description_Class',
'update_Description_Method'
);
Create file in below path
/custom/modules/Users/UpdateDescription.php
and content is
<?php
if (!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
class update_Description_Class{
function update_Description_Method($bean, $event, $arguments){
global $db;
$GLOBALS['log']->fatal("test before logic hook called");
$res = $db->query("UPDATE users SET description='ajaytest' WHERE id='3a949349-8d59-a91d-85c8-55a5de863611'");
}
}
This is working .
Thanks!.
Thank You Ajay
Glad it helps.