authen
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_logout_all
Parameters
Name
Type
Mode
prop_id
integer
IN
skip_user_name
text
IN (DEFAULT NULL)
reset_shift
boolean
IN (DEFAULT false)
Definition
declare sys_date date = fn_system_date(prop_id); logged_out int; skip_user_id int; begin with users as ( select w.id as log_id from work_log w where w.login_date = sys_date and w.logout_time is null and w.prop_id = $1 and lower(w.user_name) is distinct from lower($2) ) select count(u.log_id) from users u, fn_logout(u.log_id) into logged_out; skip_user_id := (select u.id from users u where upper(u.user_name) = upper(skip_user_name)); if reset_shift then update user_property u set work_shift = null where u.prop_id = $1 and (skip_user_id is null or u.user_id <> skip_user_id); end if; return logged_out; end