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'
Get Asterisk: The Future of Telephony, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.