Trigger for Default Team and Default Role

[whitty]

Hi,

I have recently installed SugarCRM 5.0 and am not very happy that there is no default role or default team to be specified for a new user. We use LDAP integration so it is increasingly difficult to keep track over who has what permissions. I have done some research and created the following trigger to set new users into my default role and would also like to change the default team for users to Global. Here is the trigger:

delimiter |
CREATE TRIGGER sugarcrm.new_user BEFORE INSERT ON sugarcrm.users
FOR EACH ROW
BEGIN
set NEW.default_team=1;
insert into sugarcrm.acl_roles_users values (uuid(), '198f140b-78bd-a24c-4074-48b748f172ab', NEW.id, current_timestamp, 0);
end |

The insert statement works and creates the user with out default role, however the set statement doesn't work for some reason. Has anyone accomplished this successfully or know what i am doing wrong?

Thanks,

Terry

[andopes]

Hi Terry

You can add two new rows into config table whose can specify the default team and default role.
You can also create a logic_hook before save into Users module to assign the just created user to the default team and role.

You can retrieve the default team and default role this way:

         require_once('modules/Administration/Administration.php');
        $administration = new Administration();
        $administration->retrieveSettings('MySettings'); 
  

Just changing the MySettings by the category name you created.
Let me know if you have any doubt

Cheers

[whitty]

Hi Andre,

I'm not sure if I understand what you mean?
I basically just want the easiest way to accomplish setting a default role and the default team of global.
I have never done any php modification so I would need step-by-step instructions if at all possible.

I am using Sugar Professional as well.

Regards,

Terry

[whitty]

Anyone figured out how to do this yet?

[kuske]

In my installation the table users does not have a column "default_team".

Is this a PRO or ENT feature?

[andopes]

Hi Kuske

The default_team as Team module itself is a PRO/ENT feature.

Hi Terry

Run this sql script into your database using phpMyAdmin:

INSERT INTO config (category, name, value) VALUES ('MySettings', 'default_team', 'id_of_team');
INSERT INTO config (category, name, value) VALUES ('MySettings', 'default_role', 'id_of_role');

Create the file custom/modules/Users/logic_hooks.php with this content:

 $hook_version = 1;
$hook_array = Array();
 
$hook_array['before_save'] = Array();
$hook_array['before_save'][] = Array(1, 'setTeamRole', 'custom/modules/Users/UserHook.php','UserHook', 'setTeamRole'); 
  

Create the file custom/modules/Users/UserHook.php with this content:

 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class UserHook {
    function setTeamRole(&$focus, $event, $arguments) {
        global $current_user;
        
        if($focus->id == $current_user->id) {
            $query = "SELECT * FROM users WHERE id = '{$focus->id}'";
            $result = $focus->db->query($query, true);
 
            if($focus->db->getRowCount($result) == 0) {
                require_once('modules/Administration/Administration.php');
 
                $administration = new Administration();
                $administration->retrieveSettings('MySettings');
                $default_team = $administratin->settings['MySettings_default_team'];
                $default_role = $administratin->settings['MySettings_default_role'];
                $focus->default_team = $default_team;
                $focus->load_relationship('teams');
                $focus->teams->add($default_team);
                $focus->load_relationship('aclroles');
                $focus->aclroles->add($default_role);
            }
        }
    }
} 
  

Cheers