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 result_json json; begin select jsonb_agg(t.x ORDER BY t.log_time DESC) into result_json from ( select row_to_json(l.*)::jsonb || '{"log_source":"KEYCARD"}'::jsonb AS x, l.log_time from intf_keycard_logs l where (l.register_id is not null and l.register_id = $1) or (l.booking_id is not null and l.booking_id = $2) union all -- doorlock rows: เพิ่ม field ให้ compat กับ keycard log เดิม (เพิ่มได้แต่ไม่ลด) select row_to_json(d.*)::jsonb || jsonb_build_object( 'log_source', 'DOORLOCK', 'log_type', 'N', 'card_serial', NULL, 'card_index', NULL, 'card_qty', 1 ) AS x, d.log_time from intf_doorlock_logs d where (d.register_id is not null and d.register_id = $1) or (d.booking_id is not null and d.booking_id = $2) ) t; return result_json; end;