Using Cisco SPA504G Yealink t27 t22p Fanvil C66 X5S Grandstream GXP1628 BLF lamps as status indicators and speed dial - Asterisk

; extensions.conf

[Hints]
exten => 9901,hint,Custom:LoginStat01
exten => 9801,hint,Custom:QueueStat01
exten => 9701,hint,Custom:PauseStat01
[Internal-Main]
; Operator login/logout ==================================
exten => _99XX,1,Answer
 same => n,noCDR()
 same => n,GotoIf($["${DEVICE_STATE(Custom:LoginStat${CALLERID(num)})}" = "NOT_INUSE"]?logout)
 same => n,Set(DEVICE_STATE(Custom:LoginStat${CALLERID(num)})=NOT_INUSE) ; login indicator becomes green
; do something and hangup
 same => n(logout),NoOp("Выход из системы")
 same => n,Set(DEVICE_STATE(Custom:LoginStat${CALLERID(num)})=INUSE) ; login indicator becomes red
; do something and hangup

"Правильная" таблица CDR

<pre>

CREATE TABLE `cdr` (
`id` int(11) unsigned NOT NULL,
  `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `clid` varchar(80)  NOT NULL DEFAULT '',
  `src` varchar(80)  NOT NULL DEFAULT '',
  `dst` varchar(80)  NOT NULL DEFAULT '',
  `dcontext` varchar(80) NOT NULL DEFAULT '',
  `channel` varchar(80)  NOT NULL DEFAULT '',
  `dstchannel` varchar(80)  NOT NULL DEFAULT '',
  `lastapp` varchar(80)  NOT NULL DEFAULT '',
  `lastdata` varchar(80)  NOT NULL DEFAULT '',
  `duration` int(11) NOT NULL DEFAULT '0',
  `billsec` int(11) NOT NULL DEFAULT '0',
  `disposition` varchar(45)  NOT NULL DEFAULT '',
  `amaflags` int(11) NOT NULL DEFAULT '0',
  `accountcode` varchar(20)  NOT NULL DEFAULT '',
  `userfield` varchar(255)  NOT NULL DEFAULT '',
  `uniqueid` varchar(32)  NOT NULL DEFAULT '',
  `linkedid` varchar(32)  NOT NULL DEFAULT '',
  `sequence` varchar(32)  NOT NULL DEFAULT '',
  `peeraccount` varchar(32)  NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

ALTER TABLE `cdr`
ADD PRIMARY KEY (`id`),
ADD KEY `calldate` (`calldate`),
ADD KEY `dst` (`dst`),
ADD KEY `src` (`src`),
ADD KEY `uniqueid` (`uniqueid`),
ADD KEY `accountcode` (`accountcode`);

ALTER TABLE `cdr`
MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT;