aonestar.public

Parameters

Name	Type	Mode
p_data	jsonb	IN

Definition

declare
   result_json json;
   eff_result int;
  
   v_register_id integer;
   v_guest_id integer;
   v_arrival_date date;
  
   v_msg_text text;
   v_sqlstate text;
   v_detail text;
   v_hint text;
   v_context text;
   v_guests jsonb;
begin
	  

   if p_data is not null then
   
	   v_register_id := (p_data ->> 'register_id') :: int4;
	   v_guest_id := (p_data ->> 'guest_id') :: int4;
	   v_arrival_date := (p_data  ->> 'arrival_date') :: date;
	  	   
		
	   delete from register_guests 
	   where register_id = v_register_id
	   and guest_id = v_guest_id;
   
   end if;

   

   result_json := (select * from sp_get_scan_inhouse_json(
       arrival_date := v_arrival_date
   ));

  return coalesce(result_json, '[]'::json);
  -- return fn_result_success(coalesce(result_json, '[]'::json));
 
 
  exception
   when others then
       get stacked diagnostics
           v_msg_text = message_text,
           v_sqlstate = returned_sqlstate,
           v_detail = pg_exception_detail,
           v_hint = pg_exception_hint,
           v_context = pg_exception_context;

       return fn_handle_error(
           v_sqlstate,
           v_msg_text,
           v_detail,
           v_hint,
           v_context,
           'sp_delete_more_guest_inhouse_json',
           null
       );
end;