Профиль | Публикации (9) | Комментарии (105) | Избранное (102) |
DROP TABLE IF EXISTS `opinion`;
CREATE TABLE IF NOT EXISTS `opinion` (
`id` int(11) NOT NULL auto_increment,
`callerid` varchar(15) NOT NULL default '',
`exten` varchar(15) NOT NULL default '',
`queues` varchar(7) NOT NULL,
`opinion` char(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
[macro-press-1]
exten => s,1,MYSQL(Connect connid localhost ВАШ_ЮЗЕР ВАШ_ПАСС asteriskcdrdb)
exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO opinion (`id`, `callerid`, `exten`, `queues`, `opinion`) VALUES (NULL, ${FROMEXTEN}, ${CDR(dst)}, ${CDR(src)}, 1))
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})
[macro-press-0]
exten => s,1,MYSQL(Connect connid localhost ВАШ_ЮЗЕР ВАШ_ПАСС asteriskcdrdb)
exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO opinion (`id`, `callerid`, `exten`, `queues`, `opinion`) VALUES (NULL, ${FROMEXTEN}, ${CDR(dst)}, ${CDR(src)}, 0))
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})
press1 => 1,peer/caller,Macro,press-1
press0 => 0,peer/caller,Macro,press-0
[globals]
DYNAMIC_FEATURES = apprecord#press0#press1
-- Feature Found: press1 exten: press1
-- Executing [s@macro-press-1:1] MYSQL("Local/299@from-queue-56b8;1", "Connect connid localhost root 123 asteriskcdrdb") in new stack
-- Executing [s@macro-press-1:2] MYSQL("Local/299@from-queue-56b8;1", "Query resultid 1 INSERT INTO opinion (`id`, `callerid`, `exten`, `queues`, `opinion`) VALUES (NULL, +74993462198, 299, 1234, 1)") in new stack
mysql> SELECT * FROM opinion;
+----+-------------+-------+--------+---------+
| id | callerid | exten | queues | opinion |
+----+-------------+-------+--------+---------+
| 8 | 74993462198 | 299 | 1234 | 1 |
| 9 | 74993462198 | 299 | 1234 | 1 |
+----+-------------+-------+--------+---------+
2 rows in set (0.00 sec)
member=Local/299@opinion-ivr/n
member=Local/999@opinion-ivr/n
[opinion-ivr]
exten => _.,1,NoOp(Statrt IVR)
exten => _.,n,DIAL(SIP/${EXTEN},,trg) ;опция g позволяет звонку пройти далее по диалплану
exten => _.,n,Goto(opinion,,1)
[opinion]
exten => _X.,1,NoOp(Statrt IVR)
exten => _X.,n,Background(Plese_press_0_or_1,m) ; заменить на свой голосовой файл
exten => _X.,n,Set(TIMEOUT(absolute)=2)
exten => 0,1,MYSQL(Connect connid localhost root 123 asteriskcdrdb)
exten => 0,n,MYSQL(Query resultid ${connid} INSERT INTO opinion (`id`, `callerid`, `exten`, `queues`, `opinion`) VALUES (NULL, ${FROMEXTEN}, ${DIALEDPEERNUMBER}, ${NODEST}, 0))
exten => 0,n,MYSQL(Disconnect ${connid})
exten => 1,1,MYSQL(Connect connid localhost root 123 asteriskcdrdb)
exten => 1,n,MYSQL(Query resultid ${connid} INSERT INTO opinion (`id`, `callerid`, `exten`, `queues`, `opinion`) VALUES (NULL, ${FROMEXTEN}, ${DIALEDPEERNUMBER}, ${NODEST}, 1))
exten => 1,n,MYSQL(Disconnect ${connid})
Только зарегистрированные пользователи могут оставлять комментарии. Войдите, пожалуйста.
Комментарии (25)