This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELIMITER $$ | |
DROP TRIGGER IF EXISTS asterisk.cdr_update_cost$$ | |
CREATE DEFINER=`root`@`localhost` TRIGGER `asterisk`.`cdr_update_cost` BEFORE INSERT ON `cdr` FOR EACH ROW | |
BEGIN | |
declare _min INTEGER; | |
declare _cost FLOAT; | |
declare _inc INTEGER; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- | |
************************************************************************** | |
* | |
* Title : Asterisk Dialplan language definition | |
* Author : Benoit Frigon (bfrigon@gmail.com) | |
* | |
************************************************************************** | |
--> | |
<language id="ast_dialplan" _name="Asterisk Dialplan" version="2.0" _section="Sources"> | |
<metadata> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[context-incoming] | |
exten => s, 1, NoOp() | |
;**** Check if a call treatment exists for the caller **** | |
same => n, Set(action=${TOLOWER(${ODBC_CALL_TREATMENT(${ARG1},${CALLERID(name)},${CALLERID(num)})})}) | |
;**** Jump to label normal if none is found **** | |
same => n, GotoIf(${ISNULL(${action})}?normal) | |
;**** Jump to the propriate call treatment action, or treatment-invalid if not found **** |