aonestar.public

Parameters

Name	Type	Mode
guest_data	jsonb	IN
preserve_old_values	boolean	IN (DEFAULT true)
merge_duplicates	boolean	IN (DEFAULT false)

Definition

DECLARE
    save_count integer;
    v_doc_id integer := NULLIF(guest_data->>'doc_id', '')::integer;
    v_resolved_guest_id integer;
BEGIN
    -- merge_duplicates = สแกนเอกสารมา (check-in / update guest in-house): ถ้าเอกสารนี้
    -- เป็นของ profile ที่มีอยู่แล้ว ให้ยุบเหลือใบเดียวก่อน แล้ว save ลงใบที่อยู่รอด
    -- ไม่เปิด flag = พฤติกรรมเดิม (sp_save_guest redirect เฉพาะตอนไม่มี guest_id
    -- ส่วนเคสชนกันปล่อยให้ tr_guest_identity_guard raise 23505)
    IF merge_duplicates THEN
        SELECT sp_merge_guest_by_document(
                   COALESCE(g.id, g.guest_id),
                   doc_type(g.document)::smallint,
                   doc_number(g.document)::text,
                   country_id(g.document),
                   country_id(g.contact))
        FROM jsonb_to_record(guest_data) AS g(
                id integer,
                guest_id integer,
                contact t_contact,
                document t_document
            )
        INTO v_resolved_guest_id;
    END IF;

SELECT sp_save_guest(COALESCE(v_resolved_guest_id, g.id, g.guest_id), g.last_name, g.first_name, g.title_id,
            g.sex, g.birthdate, g.nation_id, g.lang_id, g.vip_id, address1(g.contact),
            address2(g.contact), city_id(g.contact), country_id(g.contact), g.country_res_id,
            emails(g.contact), telephones(g.contact), mobiles(g.contact), g.company,
            g.occupation_id, doc_number(g.document)::citext,
            doc_type(g.document)::smallint, expire_date(g.document), country_id(g.document),
            g.credit_limit, g.confidential, g.member_code::citext, g.carplate_no,
            g.remark, g.social_media, g.likes, g.dislikes, credit_cards,
            g.photo, g.photo_url, preserve_old_values => preserve_old_values)
    FROM jsonb_to_record(guest_data) AS g(
            id integer,
            guest_id integer,
            first_name text,
            last_name text,
            title_id integer,
            sex char(1),
            birthdate date,
            nation_id integer,
            country_res_id integer,
            lang_id integer,
            vip_id integer,
            company text,
            occupation_id integer,
            credit_limit t_money,
            confidential boolean,
            member_code text,
            carplate_no text,
            photo bytea,
            photo_url text,
            remark text,
            likes text[],
            dislikes text[],
            contact t_contact,
            document t_document,
            credit_cards t_credit_card[],
            social_media t_social_account[]
        )
    INTO save_count;

IF v_doc_id IS NOT NULL THEN
        UPDATE guest
        SET doc_id = v_doc_id
        WHERE id = save_count
          AND doc_id IS DISTINCT FROM v_doc_id;

UPDATE guest_document
        SET guest_id = save_count,
            pending_assignment = false,
            assign_time = current_timestamp
        WHERE id = v_doc_id
          AND (guest_id IS DISTINCT FROM save_count OR pending_assignment);
    END IF;

RETURN save_count;
END;

sp_save_guest_js

Parameters

Definition