authen.public

Parameters

Name	Type	Mode
i_user_name	text	IN
i_prop_id	integer	IN

Definition

DECLARE
    v_user record;
    v_log_id bigint;
    v_access_token text;
BEGIN
    SELECT r.user_id, r.user_name, r.work_shift
    INTO v_user
    FROM public.fn_resolve_user_by_name(i_prop_id, i_user_name, true) r;

IF v_user.user_id IS NULL THEN
        RAISE EXCEPTION 'Active user not found for property: %', i_user_name;
    END IF;

INSERT INTO public.work_log (
        prop_id,
        user_id,
        user_name,
        device_name,
        login_date,
        shift,
        reactivate,
        app_code
    )
    VALUES (
        i_prop_id,
        v_user.user_id,
        v_user.user_name,
        'Background Report Export',
        COALESCE(public.fn_system_date(i_prop_id), current_date),
        v_user.work_shift,
        false,
        'pms'
    )
    RETURNING id INTO v_log_id;

v_access_token := public.fn_gen_access_token(v_user.user_name, i_prop_id, v_log_id);
    IF v_access_token IS NULL THEN
        RAISE EXCEPTION 'Unable to generate temporary token for user: %', i_user_name;
    END IF;

UPDATE public.work_log
    SET login_token = v_access_token,
        last_seen = clock_timestamp()
    WHERE id = v_log_id;

RETURN v_log_id;
END

fn_create_temp_report_token

Description

Parameters

Definition