aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_tr_registration_doorlock_revoke
Parameters
Name
Type
Mode
Definition
BEGIN IF NOT is_interface_active('DOORLOCK_PIN') AND NOT is_interface_active('DOORLOCK_QR') THEN RETURN NULL; END IF; PERFORM sp_revoke_register_credentials(NEW.id, fn_current_user(), 'CANCEL_CHECKIN', true); RETURN NULL; EXCEPTION WHEN OTHERS THEN PERFORM sp_log_warning('sp_tr_registration_doorlock_revoke', 'register ' || NEW.id::text || ': ' || SQLERRM); RETURN NULL; END