TOTVS CRM | SFA - 12.1.2501

Parameters

Name	Type	Mode
internalid	integer	IN
login	character varying	IN
nome	character varying	IN
senha	character varying	IN
email	character varying	IN
idnativo	integer	IN
endereco	character varying	IN
cep	character varying	IN
idperfilacesso	integer	IN
externalid	character varying	IN

Definition

begin  
	
	update usuario set 
		login = case when PutUsuario.login = 'NOVALUEWS' then usuario.login else PutUsuario.login end, 
		nome = case when PutUsuario.nome = 'NOVALUEWS' then usuario.nome else PutUsuario.nome end, 
		senha = case when PutUsuario.senha = 'NOVALUEWS' then usuario.senha else substr(encode(digest((PutUsuario.senha::text)::bytea, 'sha1'::text), 'hex'),0,31) end, 
		email = case when PutUsuario.email = 'NOVALUEWS' then usuario.email else PutUsuario.email end, 
		idnativo = case when PutUsuario.idnativo = -99999 then usuario.idnativo else PutUsuario.idnativo end, 
		endereco = case when PutUsuario.endereco = 'NOVALUEWS' then usuario.endereco else PutUsuario.endereco end, 
		cep = case when PutUsuario.cep = 'NOVALUEWS' then usuario.cep else PutUsuario.cep end, 
		idperfilacesso = case when PutUsuario.idperfilacesso = -99999 then usuario.idperfilacesso else PutUsuario.idperfilacesso end, 
		codigoerp = case when PutUsuario.externalid = 'NOVALUEWS' then usuario.codigoerp else PutUsuario.externalid end 
	where idusuario = internalid ;
	
	return query select internalid;
END;

putusuario(integer, character varying, character varying, character varying, character varying, integer, character varying, character varying, integer, character varying)

Parameters

Definition