YAAM MySQL Database setup (trigger for cdr insert)

db_cdr_trigger.sql

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;

DECLARE EXIT HANDLER FOR NOT FOUND BEGIN 
    SET NEW.cost=0;
END;

SELECT 
    cost, min, increment
INTO _cost , _min , _inc FROM
    cdr_routes
WHERE
    name = NEW.route_name;

SET _inc = GREATEST(_inc,1);

IF (NEW.billsec > 0) THEN
	SET NEW.billsec = GREATEST(_min, ceil(NEW.billsec / _inc) * _inc);
END IF;

SET NEW.cost = (NEW.billsec/60) * _cost;

END$$

DELIMITER ;