ATech Machine LIBRA-02 M Informações Técnicas descarregar pdf (Página 394)

100

101

At the PostgreSQL console, run the following commands:

asterisk=> INSERT INTO ast_hotdesk ('extension', 'first_name', 'last_name',\

'cid_name','cid_number', 'pin', 'context', 'location') \

VALUES (1101, 'Leif', 'Madsen', 'Leif Madsen', '4165551101', '555',\

'longdistance','0000FFFF0001');

At the MySQL console, run the following commands:

mysql> INSERT INTO ast_hotdesk (extension, first_name, last_name, cid_name,

cid_number, pin, context, location)

VALUES (1101, 'Leif', 'Madsen', 'Leif Madsen',

'4165551101', '555', 'longdistance', '0000FFFF0001');

Repeat these commands, changing the VALUES as needed, for all entries you wish to have

in the database. You can view the data in the ast_hotdesk table by running a simple

SELECT statement from the database console:

mysql> SELECT * FROM ast_hotdesk;

which would give you something like the following output:

|----+-----------+------------+----------------+--------------------+--------------

| 1 | 1101 | "Leif" | "Madsen" | "Leif Madsen" | "4165551101"

| 2 | 1102 | "Jim" | "Van Meggelen" | "Jim Van Meggelen" | "4165551102"

| 3 | 1103 | "Russell" | "Bryant" | "Russell Bryant" | "4165551103"

| 4 | 1104 | "Mark" | "Spencer" | "Mark Spencer" | "4165551104"

| 5 | 1105 | "Kevin" | "Fleming" | "Kevin Fleming" | "4165551105"

+-------+-----------------+---------+----------------+

| "556" | "longdistance" | "FALSE" | "" |

| "557" | "local" | "FALSE" | "" |

| "558" | "international" | "FALSE" | "" |

| "559" | "local" | "FALSE" | "" |

We’ve got the condiments now, so let’s get to our dialplan. This is where the magic is

going to happen.

Somewhere in extensions.conf we are going to have to create the hotdesk context. To

start, let’s define a pattern-match extension that will allow the users to log in:

; extensions.conf

; Hot-Desking Feature

[hotdesk]

; Hot Desk Login

exten => _#110[1-5],1,NoOp()

same => n,Set(E=${EXTEN:1}) ; strip off the leading hash (#) symbol

same => n,Verbose(1,Hot Desk Extension ${E} is changing status)

same => n,Verbose(1,Checking current status of extension ${E})

same => n,Set(${E}_STATUS=${HOTDESK_INFO(status,${E})})

same => n,Set(${E}_PIN=${HOTDESK_INFO(pin,${E})})

358 | Chapter 16: Relational Database Integration

1 2 ... 389 390 391 392 393 394 395 396 397 398 399 ... 733 734

Comentários a estes Manuais

Sem comentários

ATech Machine LIBRA-02 M Informações Técnicas Página 394

Comentários a estes Manuais