maya.public

Parameters

Name	Type	Mode
in_idclient	integer	IN
passwd	character varying	IN

Definition

DECLARE
_idpreference int;
_idmayauser int;
_idmayausergroup int;
BEGIN
PERFORM 1 FROM mayauser WHERE idclient = in_idclient AND username = 'helpdesk';
IF NOT FOUND THEN
        INSERT INTO preference SELECT nextval('sec_preference'),0,now(),0,now(),1,true,3,6 RETURNING idpreference INTO _idpreference;
        INSERT INTO mayauser SELECT nextval('sec_mayauser'),2,in_idclient,_idpreference,'helpdesk','helpdesk','helpdesk','rojeda@omnitracs.com','5555555555',md5(passwd),false,0,now(),0,now(),'DBA',true,0,1,false,null,1,null RETURNING idmayauser INTO _idmayauser;
        SELECT idmayausergroup INTO _idmayausergroup FROM mayausergroup WHERE idclient = in_idclient AND alias = 'DEFAULT';
        IF NOT FOUND THEN
        SELECT idmayausergroup INTO _idmayausergroup FROM mayausergroup WHERE idclient = in_idclient LIMIT 1;
        END IF;

IF _idmayausergroup IS NOT NULL THEN
        INSERT INTO mayauser_mayausergroup SELECT _idmayausergroup,_idmayauser,0,now(),0,now(),'DBA',true,nextval('sec_mayausermayausergroup');
        END IF;
        /* Todo usuario requiere un ctrlcode pero es generado por el trigger tg_genctrlcode, posterior a la inserción */
ELSE
        RAISE WARNING 'El usuario helpdesk ya existe para esa cuenta';
        RETURN 1;
END IF;
RETURN 0;
END

ot_rw_create_helpdesk_user(integer, character varying)

Parameters

Definition