aonestar.public

Parameters

Name	Type	Mode
i_draft_type	integer	IN
i_ref_id	integer	IN (DEFAULT NULL)
i_draft_data	jsonb	IN (DEFAULT NULL)
i_no_return	boolean	IN (DEFAULT false)

Definition

declare 
		json_result json;
		current_username text;
	begin
		/**
		 * Create by KenG (2020/03/12)
		 */
		current_username = fn_current_user();
		if ((i_ref_id is null) and (select sp_get_draft(i_draft_type, i_ref_id) is not null) ) then
			-- Incase already exist data but ref_id = null 
			-- that delete before renew insert
			delete from draft where username = current_username and draft_type = i_draft_type and ref_id is null;
			INSERT INTO draft(username, draft_type, draft_data, ref_id)
			VALUES (current_username, i_draft_type, i_draft_data, i_ref_id)
			RETURNING json_build_object('create_time', create_time, 'modify_time', modify_time, 'draft_data', draft_data) into json_result;
		else
			-- Incase do not exist data or already exist data and ref_id have some number
			INSERT INTO draft(username, draft_type, draft_data, ref_id)
			VALUES (current_username, i_draft_type, i_draft_data, i_ref_id)
			ON CONFLICT(username, draft_type, ref_id) 
			DO UPDATE SET draft_data = i_draft_data, modify_time = current_timestamp
			RETURNING json_build_object('create_time', create_time, 'modify_time', modify_time, 'draft_data', draft_data) into json_result;
		end if;
	
		/** 
		 * Modified by Pisanu 2020-03-25 
		 * Return draft data with updated summary
		 * -----------------------
		 * Modified by KenG 2020-05-07
		 * Check return data and summay booking
		 */
		--PERFORM sp_sys_log('sp_save_draft_booking_js()', i_draft_data::text);
		if i_no_return = false then
			RETURN jsonb_set(i_draft_data, ARRAY['summary'], sp_get_booking_summary_js(i_draft_data));
		else
			RETURN null;
		end if;
	end