bfrigon

[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 ****

bfrigon

<!--
************************************************************************** 
*                                                                             
* Title    : Asterisk Dialplan language definition
* Author   : Benoit Frigon (bfrigon@gmail.com)
*                                                                           
************************************************************************** 
-->
<language id="ast_dialplan" _name="Asterisk Dialplan" version="2.0" _section="Sources">
    <metadata>

bfrigon

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;