Asterisk: The Future of Telephony, 2nd Edition

Name

Hot-Desking (func_odbc.conf) — Custom dialplan functions

Synopsis

[INFO]
prefix=HOTDESK
dsn=asterisk
read=SELECT ${ARG1} FROM ast_hotdesk WHERE extension = '${ARG2}'

[STATUS]
prefix=HOTDESK
dsn=asterisk
write=UPDATE ast_hotdesk SET status = '${VAL1}', location = '${VAL2}' WHERE extension 
= '${ARG1}'

[CHECK_PHONE_LOGINS]
prefix=HOTDESK
dsn=asterisk
read=SELECT COUNT(status) FROM ast_hotdesk WHERE status = '1' AND location = '${ARG1}'

[LOGGED_IN_USER]
prefix=HOTDESK
dsn=asterisk
read=SELECT extension FROM ast_hotdesk WHERE status = '1' AND location = '${ARG1}' 
ORDER BY id LIMIT '1' OFFSET '${ARG2}'

[PHONE_STATUS]
prefix=HOTDESK
dsn=asterisk
read=SELECT extension FROM ast_hotdesk WHERE location = '${ARG1}' AND status = '1'

See Also

Hot-Desking (extensions.conf), Hot-Desking (sip.conf), res_odbc.conf