authen.public

Parameters

Name	Type	Mode
i_token	citext	IN
i_log_id	bigint	IN
i_prop_id	integer	IN
i_user_id	integer	IN
i_function_name	text	IN (DEFAULT NULL)
res_code	integer	OUT
res_msg	text	OUT
login_data	jsonb	OUT

Definition

declare v_log_id bigint;
begin
    select v.log_id, v.res_code, v.res_msg,
        case when v.res_code = 0 then
            jsonb_build_object(
                'access_token', i_token,
                'log_id', v.log_id,
                'user_id', v.user_id,
                'user_name', v.user_name,
                'user_group_id', v.user_group_id,
                'user_group_name', v.user_group_name,
                'user_group_type', v.user_group_type,
                'full_name', v.full_name,
                'job_position', v.job_position,
                'email', v.email,
                'mobile', v.mobile,
                'telephone', v.telephone,
                'current_shift', v.current_shift,
                'login_time', v.login_time,
                'profile_pic', v.image_url,
                'prop_id', v.prop_id,
                'prop_code', (select code from property where id = i_prop_id),
                'prop_name', v.prop_name,
                'prop_group_id', v.prop_group_id,
                'prop_group_name', v.prop_group_name,
                'user_permission', case v.user_group_type when 'X' then null else v.permissions end,
                'system_config', case v.user_group_type when 'X' then null else fn_system_config_js(i_prop_id) end
                ,'payload', v.payload
            ) 
            else null  
        end as login_data                         
    from fn_verify_token(i_token, i_log_id, i_prop_id, i_user_id, i_function_name) as V
    into v_log_id, res_code, res_msg, login_data;

--    perform sys.log_debug(format('log_id: %L, res_code: %L, res_msg: %s', v_log_id, res_code, res_msg), 'sp_verify_token');
end