aonestar.public

Parameters

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

Definition

DECLARE save_count int;
begin
	Select sp_save_guest(g.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 int,
			first_name TEXT,
			last_name TEXT,
			title_id int,
			sex char(1),
			birthdate date,
			nation_id int,
			country_res_id int,
			lang_id int,
			vip_id int,
			company TEXT,
			occupation_id int,
			credit_limit t_money,
			confidential bool,
			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;

    return save_count;
END

sp_save_guest_js

Parameters

Definition