aonestar.public

Parameters

Name	Type	Mode
i_doc_data	jsonb	IN
i_doc_type	smallint	IN (DEFAULT NULL)
i_doc_id	integer	IN (DEFAULT NULL)
i_photo_path	text	IN (DEFAULT NULL)
i_photo_url	text	IN (DEFAULT NULL)
i_image_path	text	IN (DEFAULT NULL)
i_image_url	text	IN (DEFAULT NULL)

Definition

DECLARE
    v_map          jsonb := fn_map_guest_document_fields(i_doc_data, i_doc_type);
    v_base         jsonb := sp_get_guest_js(NULL)::jsonb;
    v_title_name   text;
    v_nationality  text;
    v_country_name text;
    v_photo_url    text := fn_presign_or_cached(i_photo_path, i_photo_url);
    v_image_url    text := fn_presign_or_cached(i_image_path, i_image_url);
BEGIN
    SELECT t.name INTO v_title_name
    FROM title t WHERE t.id = (v_map->>'title_id')::integer;

SELECT n.name INTO v_nationality
    FROM nationality n WHERE n.id = (v_map->>'nation_id')::integer;

SELECT c.name INTO v_country_name
    FROM country c WHERE c.id = (v_map->>'country_id')::integer;

RETURN v_base
        || jsonb_build_object(
               'doc_id', i_doc_id,
               'first_name', v_map->>'first_name',
               'last_name', v_map->>'last_name',
               'full_name', fn_fullname(v_map->>'last_name', v_map->>'first_name',
                                        NULL, v_title_name),
               'title_id', v_map->'title_id',
               'title_name', v_title_name,
               'sex', v_map->>'sex',
               'birthdate', v_map->'birthdate',
               'nation_id', v_map->'nation_id',
               'nationality', v_nationality,
               'photo_url', v_photo_url,
               'contact', COALESCE(v_base->'contact', '{}'::jsonb) || jsonb_build_object(
                   'address1', v_map->>'address1',
                   'address2', v_map->>'address2',
                   'country_id', v_map->'country_id',
                   'country_name', v_country_name
               ),
               'document', COALESCE(v_base->'document', '{}'::jsonb) || jsonb_build_object(
                   'doc_type', v_map->'doc_type',
                   'doc_number', v_map->>'doc_number',
                   'expire_date', v_map->'expire_date',
                   'country_id', v_map->'country_id',
                   'country_name', v_country_name,
                   'photo_url', v_photo_url,
                   'image_url', v_image_url
               )
           );
END;

fn_guest_document_guest_js

Parameters

Definition