aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_keycard_issue_logs_json
Parameters
Name
Type
Mode
register_id
integer
IN (DEFAULT NULL)
booking_id
integer
IN (DEFAULT NULL)
Definition
declare v_roomstay_key text; v_result json; begin if register_id is not null then select fn_keycard_staykey(r.room_id, r.booking_id, $1) from registration r where r.id = $1 into v_roomstay_key; select json_agg(logs) from intf_keycard_logs logs where logs.roomstay_key = v_roomstay_key --order by logs.id into v_result; else select json_agg(logs) from intf_keycard_logs logs where logs.booking_id = $2 --order by logs.id into v_result; end if; return v_result; end;