root/trunk/common/lib/Class.A2Billing.php

<?php
/***************************************************************************
 *
 * Class.A2Billing.php : PHP A2Billing Functions for A2Billing
 * Written for PHP 4.x & PHP 5.X versions.
 *
 * A2Billing -- Asterisk billing solution.
 * Copyright (C) 2004, 2007 Belaid Arezqui <areski _atl_ gmail com>
 *
 * See http://www.asterisk2billing.org for more information about
 * the A2Billing project.
 * Please submit bug reports, patches, etc to <areski _atl_ gmail com>
 *
 * This software is released under the terms of the GNU Lesser General Public License v2.1
 * A copy of which is available from http://www.gnu.org/copyleft/lesser.html
 *
 ****************************************************************************/


define('AST_CONFIG_DIR', '/etc/asterisk/');
define('DEFAULT_A2BILLING_CONFIG', AST_CONFIG_DIR . '/a2billing.conf');

// DEFINE STATUS FOR DEBUG
define ('VERBOSE',            1);
define ('WRITELOG',            2);            // 1 << 1

class A2Billing {


    /**
    * Config variables
    *
    * @var array
    * @access public
    */
    var $config;

    /**
    * Config AGI variables
    * Create for coding readability facilities
    *
    * @var array
    * @access public
    */
    var $agiconfig;

    /**
    * IDConfig variables
    *
    * @var interger
    * @access public
    */
    var $idconfig=1;


    /**
    * cardnumber & CallerID variables
    *
    * @var string
    * @access public
    */
    var $cardnumber;
    var $CallerID;


    /**
    * Buffer variables
    *
    * @var string
    * @access public
    */
    var $BUFFER;


    /**
    * DBHandle variables
    *
    * @var object
    * @access public
    */
    var $DBHandle;


    /**
    * instance_table variables
    *
    * @var object
    * @access public
    */
    var $instance_table;

    /**
    * store the file name to store the logs
    *
    * @var string
    * @access public
    */
    var $log_file = '';


    /**
    * request AGI variables
    *
    * @var string
    * @access public
    */

    var $channel;
    var $uniqueid;
    var $accountcode;
    var $dnid;

    // from apply_rules, if a prefix is removed we keep it to track exactly what the user introduce

    var $countrycode;
    var $subcode;
    var $myprefix;
    var $ipaddress;
    var $rate;
    var $destination;
    var $sip_iax_buddy;
    var $credit;
    var $tariff;
    var $active;
    var $status;
    var $hostname='';
    var $currency='usd';

    var $mode = '';
    var $timeout;
    var $newdestination;
    var $tech;
    var $prefix;
    var $username;

    var $typepaid = 0;
    var $removeinterprefix = 1;
    var $redial;
    var $nbused = 0;

    var $enableexpire;
    var $expirationdate;
    var $expiredays;
    var $firstusedate;
    var $creationdate;

    var $languageselected;
    var $current_language;


    var $cardholder_lastname;
    var $cardholder_firstname;
    var $cardholder_email;
    var $cardholder_uipass;
    var $id_campaign;
    var $id_card;
    var $useralias;

    // Enable voicemail for this card. For DID and SIP/IAX call
    var $voicemail = 0;

    // Flag to know that we ask for an othercardnumber when for instance we doesnt have enough credit to make a call
    var $ask_other_cardnumber=0;

    var $ivr_voucher;
    var $vouchernumber;
    var $add_credit;

    var $cardnumber_range;

    // Define if we have changed the status of the card
    var $set_inuse = 0;

    /**
    * CC_TESTING variables
    * for developer purpose, will replace some get_data inputs in order to test the application from shell
    *
    * @var interger
    * @access public
    */
    var $CC_TESTING;


    /* CONSTRUCTOR */

    function A2Billing()
    {
        $this -> agiconfig['debug'] = true;
        //$this -> DBHandle = $DBHandle;
    }


    /* Init */

    function Reinit()
    {
        $this -> countrycode='';
        $this -> subcode='';
        $this -> myprefix='';
        $this -> ipaddress='';
        $this -> rate='';
        $this -> destination='';
    }


    /*
     * Debug
     *
     * usage : $A2B -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, $buffer_debug);
     */
    function debug( $debug, $agi, $file, $line, $buffer_debug)
    {
        $file = basename($file);

        // RUN VERBOSE ON CLI
        if ($debug & VERBOSE) {
            if ($this->agiconfig['debug']>=1)   $agi->verbose('file:'.$file.' - line:'.$line.' - uniqueid:'.$this->uniqueid.' - '.$buffer_debug);
        }

        // RIGHT DEBUG IN LOG FILE
        if ($debug & WRITELOG) {
            $this -> write_log ($buffer_debug, 1, "[file:$file - line:$line - uniqueid:".$this->uniqueid."]:");
        }
    }

    /*
     * Write log into file
     */
    function write_log($output, $tobuffer = 1, $line_file_info = '')
    {
        //$tobuffer = 0;

        if (strlen($this->log_file) > 1) {
            $string_log = "[".date("d/m/Y H:i:s")."]:".$line_file_info."[CallerID:".$this->CallerID."]:[CN:".$this->cardnumber."]:[$output]\n";
            if ($this->CC_TESTING) echo $string_log;

            $this -> BUFFER .= $string_log;
            if (!$tobuffer || $this->CC_TESTING) {
                error_log ($this -> BUFFER, 3, $this->log_file);
                $this-> BUFFER = '';
            }
        }
    }

    /*
     * set the DB handler
     */
    function set_dbhandler ($DBHandle)
    {
        $this->DBHandle    = $DBHandle;
    }

    /*
     * set_instance_table
     */
    function set_instance_table ($instance_table)
    {
        $this->instance_table = $instance_table;
    }

    /*
     * load_conf
     */
    function load_conf( &$agi, $config=NULL, $webui=0, $idconfig=1, $optconfig=array())
    {
        $this -> idconfig = $idconfig;
        // load config
        if(!is_null($config) && file_exists($config)) {
            $this->config = parse_ini_file($config, true);
        } elseif(file_exists(DEFAULT_A2BILLING_CONFIG)) {
            $this->config = parse_ini_file(DEFAULT_A2BILLING_CONFIG, true);
        }

          /*  We don't need to do this twice.  load_conf_db() will do it
        // If optconfig is specified, stuff vals and vars into 'a2billing' config array.
        foreach($optconfig as $var=>$val) {
            $this->config["agi-conf$idconfig"][$var] = $val;
        }*/

        // conf for the database connection
        if(!isset($this->config['database']['hostname']))    $this->config['database']['hostname'] = 'localhost';
        if(!isset($this->config['database']['port']))        $this->config['database']['port'] = '5432';
        if(!isset($this->config['database']['user']))        $this->config['database']['user'] = 'postgres';
        if(!isset($this->config['database']['password']))    $this->config['database']['password'] = '';
        if(!isset($this->config['database']['dbname']))        $this->config['database']['dbname'] = 'a2billing';
        if(!isset($this->config['database']['dbtype']))        $this->config['database']['dbtype'] = 'postgres';

        return $this->load_conf_db($agi, NULL, 0, $idconfig, $optconfig);
    }

    /*
     * Load config from Database
     */
    function load_conf_db( &$agi, $config=NULL, $webui=0, $idconfig=1, $optconfig=array())
    {
        $this -> idconfig = $idconfig;
        // load config
        $config_table = new Table("cc_config ccc, cc_config_group ccg", "ccc.config_key as cfgkey, ccc.config_value as cfgvalue, ccg.group_title as cfggname, ccc.config_valuetype as cfgtype");
        $this->DbConnect();

        $config_res = $config_table -> Get_list($this->DBHandle, "ccc.config_group_id = ccg.id");
        if (!$config_res) {
            echo 'Error : cannot load conf : load_conf_db';
            return false;
        }

        foreach ($config_res as $conf)
        {
            // FOR DEBUG
            /*if ($conf['cfgkey'] == 'sip_iax_pstn_direct_call_prefix') {
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "\n\n conf :".$conf['cfgkey']);
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "\n\n conf :".$conf['cfgvalue']);
            }*/
            if($conf['cfgtype'] == 0) // if its type is text
            {
                $this->config[$conf['cfggname']][$conf['cfgkey']] = $conf['cfgvalue'];
            }
            elseif($conf['cfgtype'] == 1) // if its type is boolean
            {
                if(strtoupper($conf['cfgvalue']) == "YES" || $conf['cfgvalue'] == 1 || strtoupper($conf['cfgvalue']) == "TRUE") // if equal to 'yes'
                {
                    $this->config[$conf['cfggname']][$conf['cfgkey']] = 1;
                }
                else // if equal to 'no'
                {
                    $this->config[$conf['cfggname']][$conf['cfgkey']] = 0;
                }
            }
        }
        $this->DbDisconnect($this->DBHandle);

        // If optconfig is specified, stuff vals and vars into 'a2billing' config array.
        foreach($optconfig as $var=>$val)
        {
            $this->config["agi-conf$idconfig"][$var] = $val;
        }

        // add default values to config for uninitialized values
        //Card Number Length Code
        $card_length_range = isset($this->config['global']['interval_len_cardnumber'])?$this->config['global']['interval_len_cardnumber']:null;
        $this -> cardnumber_range = $this -> splitable_data ($card_length_range);

        if(is_array($this -> cardnumber_range) && ($this -> cardnumber_range[0] >= 4))
        {
            define ("CARDNUMBER_LENGTH_MIN", $this -> cardnumber_range[0]);
            define ("CARDNUMBER_LENGTH_MAX", $this -> cardnumber_range[count($this -> cardnumber_range)-1]);
            define ("LEN_CARDNUMBER", CARDNUMBER_LENGTH_MIN);
        }
        else
        {
            echo gettext("Invalid card number lenght defined in configuration.");
            exit;
        }
        if(!isset($this->config['global']['len_aliasnumber']))        $this->config['global']['len_aliasnumber'] = 15;
        if(!isset($this->config['global']['len_voucher']))            $this->config['global']['len_voucher'] = 15;
        if(!isset($this->config['global']['base_currency']))         $this->config['global']['base_currency'] = 'usd';
        if(!isset($this->config['global']['didbilling_daytopay']))     $this->config['global']['didbilling_daytopay'] = 5;
        if(!isset($this->config['global']['admin_email']))             $this->config['global']['admin_email'] = 'root@localhost';

                // Conf for the Callback
        if(!isset($this->config['callback']['context_callback']))    $this->config['callback']['context_callback'] = 'a2billing-callback';
        if(!isset($this->config['callback']['ani_callback_delay']))    $this->config['callback']['ani_callback_delay'] = '10';
        if(!isset($this->config['callback']['extension']))        $this->config['callback']['extension'] = '1000';
        if(!isset($this->config['callback']['sec_avoid_repeate']))    $this->config['callback']['sec_avoid_repeate'] = '30';
        if(!isset($this->config['callback']['timeout']))        $this->config['callback']['timeout'] = '20';
        if(!isset($this->config['callback']['answer_call']))        $this->config['callback']['answer_call'] = '1';
        if(!isset($this->config['callback']['nb_predictive_call']))    $this->config['callback']['nb_predictive_call'] = '10';
        if(!isset($this->config['callback']['nb_day_wait_before_retry']))    $this->config['callback']['nb_day_wait_before_retry'] = '1';
        if(!isset($this->config['callback']['context_preditctivedialer']))    $this->config['callback']['context_preditctivedialer'] = 'a2billing-predictivedialer';
        if(!isset($this->config['callback']['predictivedialer_maxtime_tocall']))    $this->config['callback']['predictivedialer_maxtime_tocall'] = '5400';
        if(!isset($this->config['callback']['sec_wait_before_callback']))    $this->config['callback']['sec_wait_before_callback'] = '10';

        // Conf for the signup
        if(!isset($this->config['signup']['enable_signup']))$this->config['signup']['enable_signup'] = '1';
        if(!isset($this->config['signup']['credit']))        $this->config['signup']['credit'] = '0';
        if(!isset($this->config['signup']['tariff']))        $this->config['signup']['tariff'] = '8';
        if(!isset($this->config['signup']['activated']))    $this->config['signup']['activated'] = 't';
        if(!isset($this->config['signup']['simultaccess']))    $this->config['signup']['simultaccess'] = '0';
        if(!isset($this->config['signup']['typepaid']))        $this->config['signup']['typepaid'] = '0';
        if(!isset($this->config['signup']['creditlimit']))    $this->config['signup']['creditlimit'] = '0';
        if(!isset($this->config['signup']['runservice']))    $this->config['signup']['runservice'] = '0';
        if(!isset($this->config['signup']['enableexpire']))    $this->config['signup']['enableexpire'] = '0';
        if(!isset($this->config['signup']['expiredays']))    $this->config['signup']['expiredays'] = '0';

        // Conf for Paypal
        if(!isset($this->config['paypal']['item_name']))    $this->config['paypal']['item_name'] = 'Credit Purchase';
        if(!isset($this->config['paypal']['currency_code']))    $this->config['paypal']['currency_code'] = 'USD';
        if(!isset($this->config['paypal']['purchase_amount']))    $this->config['paypal']['purchase_amount'] = '5;10;15';
        if(!isset($this->config['paypal']['paypal_fees']))   $this->config['paypal']['paypal_fees'] = '1';

        // Conf for Backup
        if(!isset($this->config['backup']['backup_path']))    $this->config['backup']['backup_path'] ='/tmp';
        if(!isset($this->config['backup']['gzip_exe']))        $this->config['backup']['gzip_exe'] ='/bin/gzip';
        if(!isset($this->config['backup']['gunzip_exe']))    $this->config['backup']['gunzip_exe'] ='/bin/gunzip';
        if(!isset($this->config['backup']['mysqldump']))    $this->config['backup']['mysqldump'] ='/usr/bin/mysqldump';
        if(!isset($this->config['backup']['pg_dump']))        $this->config['backup']['pg_dump'] ='/usr/bin/pg_dump';
        if(!isset($this->config['backup']['mysql']))        $this->config['backup']['mysql'] ='/usr/bin/mysql';
        if(!isset($this->config['backup']['psql']))        $this->config['backup']['psql'] ='/usr/bin/psql';
        if(!isset($this->config['backup']['archive_data_x_month']))        $this->config['backup']['archive_data_x_month'] ='3';

        // Conf for Customer Web UI
        if(!isset($this->config['webcustomerui']['customerinfo']))    $this->config['webcustomerui']['customerinfo'] = '1';
        if(!isset($this->config['webcustomerui']['sipiaxinfo']))    $this->config['webcustomerui']['sipiaxinfo'] = '1';
        if(!isset($this->config['webcustomerui']['personalinfo']))    $this->config['webcustomerui']['personalinfo'] = '1';
        if(!isset($this->config['webcustomerui']['cdr']))        $this->config['webcustomerui']['cdr'] = '1';
        if(!isset($this->config['webcustomerui']['invoice']))        $this->config['webcustomerui']['invoice'] = '1';
        if(!isset($this->config['webcustomerui']['voucher']))        $this->config['webcustomerui']['voucher'] = '1';
        if(!isset($this->config['webcustomerui']['paypal']))        $this->config['webcustomerui']['paypal'] = '1';
        if(!isset($this->config['webcustomerui']['speeddial']))        $this->config['webcustomerui']['speeddial'] = '1';
        if(!isset($this->config['webcustomerui']['did']))        $this->config['webcustomerui']['did'] = '1';
        if(!isset($this->config['webcustomerui']['ratecard']))        $this->config['webcustomerui']['ratecard'] = '1';
        if(!isset($this->config['webcustomerui']['simulator']))        $this->config['webcustomerui']['simulator'] = '1';
        if(!isset($this->config['webcustomerui']['callback']))        $this->config['webcustomerui']['callback'] = '1';
        if(!isset($this->config['webcustomerui']['predictivedialer']))    $this->config['webcustomerui']['predictivedialer'] = '1';
        if(!isset($this->config['webcustomerui']['webphone']))        $this->config['webcustomerui']['webphone'] = '1';
        if(!isset($this->config['webcustomerui']['callerid']))        $this->config['webcustomerui']['callerid'] = '1';
        if(!isset($this->config['webcustomerui']['limit_callerid']))    $this->config['webcustomerui']['limit_callerid'] = '5';
        if(!isset($this->config['webcustomerui']['error_email']))    $this->config['webcustomerui']['error_email'] = 'root@localhost';
        if(!isset($this->config['webcustomerui']['support']))    $this->config['webcustomerui']['support'] = '1';
        if(!isset($this->config['webcustomerui']['notification']))    $this->config['webcustomerui']['notification'] = '1';
        if(!isset($this->config['webcustomerui']['payment']))    $this->config['webcustomerui']['payment'] = '1';
        // conf for the web ui
        if(!isset($this->config['webui']['buddy_sip_file']))        $this->config['webui']['buddy_sip_file'] = '/etc/asterisk/additional_a2billing_sip.conf';
        if(!isset($this->config['webui']['buddy_iax_file']))        $this->config['webui']['buddy_iax_file'] = '/etc/asterisk/additional_a2billing_iax.conf';
        if(!isset($this->config['webui']['api_logfile']))        $this->config['webui']['api_logfile'] = '/tmp/api_ecommerce_request.log';
        if(isset($this->config['webui']['api_ip_auth']))        $this->config['webui']['api_ip_auth'] = explode(";", $this->config['webui']['api_ip_auth']);

        if(!isset($this->config['webui']['dir_store_mohmp3']))        $this->config['webui']['dir_store_mohmp3'] = '/var/lib/asterisk/mohmp3';
        if(!isset($this->config['webui']['num_musiconhold_class']))    $this->config['webui']['num_musiconhold_class'] = 10;
        if(!isset($this->config['webui']['show_help']))            $this->config['webui']['show_help'] = 1;
        if(!isset($this->config['webui']['my_max_file_size_import']))    $this->config['webui']['my_max_file_size_import'] = 1024000;
        if(!isset($this->config['webui']['dir_store_audio']))        $this->config['webui']['dir_store_audio'] = '/var/lib/asterisk/sounds/a2billing';
        if(!isset($this->config['webui']['my_max_file_size_audio']))    $this->config['webui']['my_max_file_size_audio'] = 3072000;

        if(isset($this->config['webui']['file_ext_allow']))        $this->config['webui']['file_ext_allow'] = explode(",", $this->config['webui']['file_ext_allow']);
        else $this->config['webui']['file_ext_allow'] = explode(",", "gsm, mp3, wav");

        if(isset($this->config['webui']['file_ext_allow_musiconhold']))    $this->config['webui']['file_ext_allow_musiconhold'] = explode(",", $this->config['webui']['file_ext_allow_musiconhold']);
        else $this->config['webui']['file_ext_allow_musiconhold'] = explode(",", "mp3");

        if(!isset($this->config['webui']['show_top_frame']))         $this->config['webui']['show_top_frame'] = 1;
        if(!isset($this->config['webui']['currency_choose']))         $this->config['webui']['currency_choose'] = 'all';
        if(!isset($this->config['webui']['card_export_field_list']))    $this->config['webui']['card_export_field_list'] = 'creationdate, username, credit, lastname, firstname';
        if(!isset($this->config['webui']['voucher_export_field_list']))    $this->config['webui']['voucher_export_field_list'] = 'id, voucher, credit, tag, activated, usedcardnumber, usedate, currency';
        if(!isset($this->config['webui']['advanced_mode']))                $this->config['webui']['advanced_mode'] = 0;
        if(!isset($this->config['webui']['delete_fk_card']))            $this->config['webui']['delete_fk_card'] = 1;

        // conf for the recurring process
        if(!isset($this->config["recprocess"]['batch_log_file']))     $this->config["recprocess"]['batch_log_file'] = '/tmp/batch-a2billing.log';

        // conf for the peer_friend
        if(!isset($this->config['peer_friend']['type']))         $this->config['peer_friend']['type'] = 'friend';
        if(!isset($this->config['peer_friend']['allow']))         $this->config['peer_friend']['allow'] = 'ulaw,alaw,gsm,g729';
        if(!isset($this->config['peer_friend']['context']))     $this->config['peer_friend']['context'] = 'a2billing';
        if(!isset($this->config['peer_friend']['nat']))         $this->config['peer_friend']['nat'] = 'yes';
        if(!isset($this->config['peer_friend']['amaflags']))     $this->config['peer_friend']['amaflags'] = 'billing';
        if(!isset($this->config['peer_friend']['qualify']))     $this->config['peer_friend']['qualify'] = 'yes';
        if(!isset($this->config['peer_friend']['host']))         $this->config['peer_friend']['host'] = 'dynamic';
        if(!isset($this->config['peer_friend']['dtmfmode']))     $this->config['peer_friend']['dtmfmode'] = 'RFC2833';


        //conf for the notifications
        if(!isset($this->config['notifications']['values_notifications'])) $this->config['notifications']['values_notifications'] = '0';
        if(!isset($this->config['notifications']['cron_notifications'])) $this->config['notifications']['cron_notifications'] = '1';
        if(!isset($this->config['notifications']['delay_notifications'])) $this->config['notifications']['delay_notifications'] = '1';

        // conf for the log-files
        if(isset($this->config['log-files']['agi']) && strlen ($this->config['log-files']['agi']) > 1)
        {
            $this -> log_file = $this -> config['log-files']['agi'];
        }
        define ("LOGFILE_CRONT_ALARM",             isset($this->config['log-files']['cront_alarm'])            ?$this->config['log-files']['cront_alarm']:null);
        define ("LOGFILE_CRONT_AUTOREFILL",     isset($this->config['log-files']['cront_autorefill'])        ?$this->config['log-files']['cront_autorefill']:null);
        define ("LOGFILE_CRONT_BATCH_PROCESS",     isset($this->config['log-files']['cront_batch_process'])    ?$this->config['log-files']['cront_batch_process']:null);
        define ("LOGFILE_CRONT_ARCHIVE_DATA",     isset($this->config['log-files']['cront_archive_data'])    ?$this->config['log-files']['cront_archive_data']:null);
        define ("LOGFILE_CRONT_BILL_DIDUSE",     isset($this->config['log-files']['cront_bill_diduse'])        ?$this->config['log-files']['cront_bill_diduse']:null);
        define ("LOGFILE_CRONT_SUBSCRIPTIONFEE",isset($this->config['log-files']['cront_subscriptionfee'])    ?$this->config['log-files']['cront_subscriptionfee']:null);
        define ("LOGFILE_CRONT_CURRENCY_UPDATE",isset($this->config['log-files']['cront_currency_update'])    ?$this->config['log-files']['cront_currency_update']:null);
        define ("LOGFILE_CRONT_INVOICE",        isset($this->config['log-files']['cront_invoice'])            ?$this->config['log-files']['cront_invoice']:null);
        define ("LOGFILE_CRONT_CHECKACCOUNT",    isset($this->config['log-files']['cront_check_account'])    ?$this->config['log-files']['cront_check_account']:null);

        define ("LOGFILE_API_ECOMMERCE",         isset($this->config['log-files']['api_ecommerce'])            ?$this->config['log-files']['api_ecommerce']:null);
        define ("LOGFILE_API_CALLBACK",         isset($this->config['log-files']['api_callback'])            ?$this->config['log-files']['api_callback']:null);
        define ("LOGFILE_PAYPAL",                 isset($this->config['log-files']['paypal'])                    ?$this->config['log-files']['paypal']:null);
        define ("LOGFILE_EPAYMENT",             isset($this->config['log-files']['epayment'])                ?$this->config['log-files']['epayment']:null);


        // conf for the AGI
        if(!isset($this->config["agi-conf$idconfig"]['play_audio']))     $this->config["agi-conf$idconfig"]['play_audio'] = 1;
        define ("PLAY_AUDIO",                                             $this->config["agi-conf$idconfig"]['play_audio']);

        if(!isset($this->config["agi-conf$idconfig"]['debug']))     $this->config["agi-conf$idconfig"]['debug'] = false;
        if(!isset($this->config["agi-conf$idconfig"]['logger_enable'])) $this->config["agi-conf$idconfig"]['logger_enable'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['log_file'])) $this->config["agi-conf$idconfig"]['log_file'] = '/tmp/a2billing.log';

        if(!isset($this->config["agi-conf$idconfig"]['answer_call'])) $this->config["agi-conf$idconfig"]['answer_call'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['auto_setcallerid'])) $this->config["agi-conf$idconfig"]['auto_setcallerid'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['say_goodbye'])) $this->config["agi-conf$idconfig"]['say_goodbye'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['play_menulanguage'])) $this->config["agi-conf$idconfig"]['play_menulanguage'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['force_language'])) $this->config["agi-conf$idconfig"]['force_language'] = 'EN';
        if(!isset($this->config["agi-conf$idconfig"]['min_credit_2call'])) $this->config["agi-conf$idconfig"]['min_credit_2call'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['min_duration_2bill'])) $this->config["agi-conf$idconfig"]['min_duration_2bill'] = 0;

        if(!isset($this->config["agi-conf$idconfig"]['use_dnid'])) $this->config["agi-conf$idconfig"]['use_dnid'] = 0;
        // Explode the no_auth_dnid string
        if(isset($this->config["agi-conf$idconfig"]['no_auth_dnid'])) $this->config["agi-conf$idconfig"]['no_auth_dnid'] = explode(",",$this->config["agi-conf$idconfig"]['no_auth_dnid']);

        // Explode the international_prefixes, extracharge_did and extracharge_fee strings
        if(isset($this->config["agi-conf$idconfig"]['extracharge_did'])) $this->config["agi-conf$idconfig"]['extracharge_did'] = explode(",",$this->config["agi-conf$idconfig"]['extracharge_did']);
        if(isset($this->config["agi-conf$idconfig"]['extracharge_fee'])) $this->config["agi-conf$idconfig"]['extracharge_fee'] = explode(",",$this->config["agi-conf$idconfig"]['extracharge_fee']);
        if(isset($this->config["agi-conf$idconfig"]['extracharge_buyfee'])) $this->config["agi-conf$idconfig"]['extracharge_buyfee'] = explode(",",$this->config["agi-conf$idconfig"]['extracharge_buyfee']);

        if(isset($this->config["agi-conf$idconfig"]['international_prefixes'])) {
            $this->config["agi-conf$idconfig"]['international_prefixes'] = explode(",",$this->config["agi-conf$idconfig"]['international_prefixes']);
        } else {
            // to retain config file compatibility assume a default unless config option is set
            $this->config["agi-conf$idconfig"]['international_prefixes'] = explode(",","011,09,00,1");
        }



        if(!isset($this->config["agi-conf$idconfig"]['number_try'])) $this->config["agi-conf$idconfig"]['number_try'] = 3;
        if(!isset($this->config["agi-conf$idconfig"]['say_balance_after_auth'])) $this->config["agi-conf$idconfig"]['say_balance_after_auth'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['say_balance_after_call'])) $this->config["agi-conf$idconfig"]['say_balance_after_call'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['say_rateinitial'])) $this->config["agi-conf$idconfig"]['say_rateinitial'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['say_timetocall'])) $this->config["agi-conf$idconfig"]['say_timetocall'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['cid_enable'])) $this->config["agi-conf$idconfig"]['cid_enable'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['cid_sanitize'])) $this->config["agi-conf$idconfig"]['cid_sanitize'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['cid_askpincode_ifnot_callerid'])) $this->config["agi-conf$idconfig"]['cid_askpincode_ifnot_callerid'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['cid_auto_assign_card_to_cid'])) $this->config["agi-conf$idconfig"]['cid_auto_assign_card_to_cid'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['notenoughcredit_cardnumber'])) $this->config["agi-conf$idconfig"]['notenoughcredit_cardnumber'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['notenoughcredit_assign_newcardnumber_cid'])) $this->config["agi-conf$idconfig"]['notenoughcredit_assign_newcardnumber_cid'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['maxtime_tocall_negatif_free_route'])) $this->config["agi-conf$idconfig"]['maxtime_tocall_negatif_free_route'] = 1800;
        if(!isset($this->config["agi-conf$idconfig"]['callerid_authentication_over_cardnumber'])) $this->config["agi-conf$idconfig"]['callerid_authentication_over_cardnumber'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['cid_auto_create_card_len'])) $this->config["agi-conf$idconfig"]['cid_auto_create_card_len'] = 10;

        if(!isset($this->config["agi-conf$idconfig"]['sip_iax_friends'])) $this->config["agi-conf$idconfig"]['sip_iax_friends'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['sip_iax_pstn_direct_call'])) $this->config["agi-conf$idconfig"]['sip_iax_pstn_direct_call'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['dialcommand_param'])) $this->config["agi-conf$idconfig"]['dialcommand_param'] = '|30|HL(%timeout%:61000:30000)';
        if(!isset($this->config["agi-conf$idconfig"]['dialcommand_param_sipiax_friend'])) $this->config["agi-conf$idconfig"]['dialcommand_param_sipiax_friend'] = '|30|HL(3600000:61000:30000)';
        if(!isset($this->config["agi-conf$idconfig"]['switchdialcommand'])) $this->config["agi-conf$idconfig"]['switchdialcommand'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['failover_recursive_limit'])) $this->config["agi-conf$idconfig"]['failover_recursive_limit'] = 1;
        if(!isset($this->config["agi-conf$idconfig"]['record_call'])) $this->config["agi-conf$idconfig"]['record_call'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['monitor_formatfile'])) $this->config["agi-conf$idconfig"]['monitor_formatfile'] = 'gsm';
        if(!isset($this->config["agi-conf$idconfig"]['currency_association']))    $this->config["agi-conf$idconfig"]['currency_association'] = 'all:credit';
        $this->config["agi-conf$idconfig"]['currency_association'] = explode(",",$this->config["agi-conf$idconfig"]['currency_association']);

        foreach($this->config["agi-conf$idconfig"]['currency_association'] as $cur_val) {
            $cur_val = explode(":",$cur_val);
            $this->config["agi-conf$idconfig"]['currency_association_internal'][$cur_val[0]]=$cur_val[1];
        }

        if(!isset($this->config["agi-conf$idconfig"]['currency_association_minor']))    $this->config["agi-conf$idconfig"]['currency_association_minor'] = 'all:prepaid-cents';
        $this->config["agi-conf$idconfig"]['currency_association_minor'] = explode(",",$this->config["agi-conf$idconfig"]['currency_association_minor']);

        foreach($this->config["agi-conf$idconfig"]['currency_association_minor'] as $cur_val) {
            $cur_val = explode(":",$cur_val);
            $this->config["agi-conf$idconfig"]['currency_association_minor_internal'][$cur_val[0]]=$cur_val[1];
        }

        if(!isset($this->config["agi-conf$idconfig"]['file_conf_enter_destination']))    $this->config["agi-conf$idconfig"]['file_conf_enter_destination'] = 'prepaid-enter-number-u-calling-1-or-011';
        if(!isset($this->config["agi-conf$idconfig"]['file_conf_enter_menulang']))    $this->config["agi-conf$idconfig"]['file_conf_enter_menulang'] = 'prepaid-menulang';
        if(!isset($this->config["agi-conf$idconfig"]['send_reminder'])) $this->config["agi-conf$idconfig"]['send_reminder'] = 0;
        if(isset($this->config["agi-conf$idconfig"]['debugshell']) && $this->config["agi-conf$idconfig"]['debugshell'] == 1 && isset($agi)) $agi->nlinetoread = 0;

        if(!isset($this->config["agi-conf$idconfig"]['ivr_voucher'])) $this->config["agi-conf$idconfig"]['ivr_voucher'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['ivr_voucher_prefixe'])) $this->config["agi-conf$idconfig"]['ivr_voucher_prefixe'] = 8;
        if(!isset($this->config["agi-conf$idconfig"]['jump_voucher_if_min_credit'])) $this->config["agi-conf$idconfig"]['jump_voucher_if_min_credit'] = 0;
        if(!isset($this->config["agi-conf$idconfig"]['failover_lc_prefix'])) $this->config["agi-conf$idconfig"]['failover_lc_prefix'] = 0;

        // Define the agiconfig property
        $this->agiconfig = $this->config["agi-conf$idconfig"];

        // Print out on CLI for debug purpose
        if (!$webui) $this->conlog ('A2Billing AGI internal configuration:');
        if (!$webui) $this->conlog (print_r($this->agiconfig, true));
        return true;
    }


    /**
    * Log to console if debug mode.
    *
    * @example examples/ping.php Ping an IP address
    *
    * @param string $str
    * @param integer $vbl verbose level
    */
    function conlog($str, $vbl=1)
    {
        global $agi;
        static $busy = false;

        if($this->agiconfig['debug'] != false)
        {
            if(!$busy) // no conlogs inside conlog!!!
            {
              $busy = true;
              if (isset($agi)) $agi->verbose($str, $vbl);
              $busy = false;
            }
        }
    }

    /*
     * Function to create a menu to select the language
     */
    function play_menulanguage ($agi)
    {
        // MENU LANGUAGE
        if ($this->agiconfig['play_menulanguage']==1){
            
            $list_prompt_menulang = explode(':',$this->agiconfig['conf_order_menulang']);
            $i=1;
            foreach ($list_prompt_menulang as $lg_value ){
                $res_dtmf = $agi->get_data("menu_".$lg_value, 100, 1);
                if(!empty($res_dtmf["result"]) && is_numeric($res_dtmf["result"] && $res_dtmf["result"]>0))break;
                $res_dtmf = $agi->get_data("num_".$lg_value."_".$i,100, 1);
                if(!empty($res_dtmf["result"]) && is_numeric($res_dtmf["result"]) && $res_dtmf["result"]>0 )break;
                $i++;
            }
            
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "RES Menu Language DTMF : ".$res_dtmf ["result"]);

            $this -> languageselected = $res_dtmf ["result"];
            
            if($this -> languageselected>0 && $this -> languageselected<=sizeof($list_prompt_menulang) ){
                $language = $list_prompt_menulang[$this -> languageselected-1];
            }else{
                if (strlen($this->agiconfig['force_language'])==2) {
                    $language = strtolower($this->agiconfig['force_language']);
                } else {
                    $language = 'en';
                }
                
            }

            $this ->current_language = $language;  
            
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, " CURRENT LANGUAGE : ".$language);
            
            
            if($this->agiconfig['asterisk_version'] == "1_2") {
                $lg_var_set = 'LANGUAGE()';
            } else {
                $lg_var_set = 'CHANNEL(language)';
            }
            $agi -> set_variable($lg_var_set, $language);
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[SET $lg_var_set $language]");
            $this->languageselected = 1;

        } elseif (strlen($this->agiconfig['force_language'])==2) {

            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "FORCE LANGUAGE : ".$this->agiconfig['force_language']);
            $this->languageselected = 1;
            $language = strtolower($this->agiconfig['force_language']);
            $this ->current_language = $language;
            if($this->agiconfig['asterisk_version'] == "1_2") {
                $lg_var_set = 'LANGUAGE()';
            } else {
                $lg_var_set = 'CHANNEL(language)';
            }
            $agi -> set_variable($lg_var_set, $language);
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[SET $lg_var_set $language]");
        }
    }



    /*
     * intialize evironement variables from the agi values
     */
    function get_agi_request_parameter($agi)
    {
        $this->CallerID     = $agi->request['agi_callerid'];
        $this->channel        = $agi->request['agi_channel'];
        $this->uniqueid        = $agi->request['agi_uniqueid'];
        $this->accountcode    = $agi->request['agi_accountcode'];
        //$this->dnid        = $agi->request['agi_dnid'];
        $this->dnid            = $agi->request['agi_extension'];
        
        //Call function to find the cid number
        $this -> isolate_cid();

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, ' get_agi_request_parameter = '.$this->CallerID.' ; '.$this->channel.' ; '.$this->uniqueid.' ; '.$this->accountcode.' ; '.$this->dnid);
    }



    /*
     *    function to find the cid number
     */
    function isolate_cid()
    {
        $pos_lt = strpos($this->CallerID, '<');
        $pos_gt = strpos($this->CallerID, '>');

        if (($pos_lt !== false) && ($pos_gt !== false)) {
            $len_gt = $pos_gt - $pos_lt - 1;
            $this->CallerID = substr($this->CallerID,$pos_lt+1,$len_gt);
        }
    }


    /*
     *    function would set when the card is used or when it release
     */
    function callingcard_acct_start_inuse($agi, $inuse)
    {
        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[CARD STATUS UPDATE]");
        if ($inuse) {
            $QUERY = "UPDATE cc_card SET inuse=inuse+1 WHERE username='".$this->username."'";
            $this -> set_inuse = 1;
        } else {
            $QUERY = "UPDATE cc_card SET inuse=inuse-1 WHERE username='".$this->username."'";
            $this -> set_inuse = 0;
        }
        
        if (!$this -> CC_TESTING) $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY, 0);

        return 0;
    }



    /**
     *    Function callingcard_ivr_authorize : check the dialed/dialing number and play the time to call
     *
     *  @param object $agi
     *  @param float $credit
     *  @return 1 if Ok ; -1 if error
    **/
    function callingcard_ivr_authorize($agi, &$RateEngine, $try_num)
    {
        $res=0;

        /**************     ASK DESTINATION     ******************/
        $prompt_enter_dest = $this->agiconfig['file_conf_enter_destination'];

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__,  $this->agiconfig['use_dnid']." && ".in_array ($this->dnid, $this->agiconfig['no_auth_dnid'])." && ".strlen($this->dnid)."&& $try_num");

        // CHECK IF USE_DNID IF NOT GET THE DESTINATION NUMBER
        if ($this->agiconfig['use_dnid']==1 && !in_array ($this->dnid, $this->agiconfig['no_auth_dnid']) && strlen($this->dnid)>2 && $try_num==0){
            $this->destination = $this->dnid;
        }else{
            $res_dtmf = $agi->get_data($prompt_enter_dest, 6000, 20);
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "RES DTMF : ".$res_dtmf ["result"]);
            $this->destination = $res_dtmf ["result"];
        }
        
        //REDIAL FIND THE LAST DIALED NUMBER (STORED IN THE DATABASE)
        if (strlen($this->destination)<=2 && is_numeric($this->destination) && $this->destination>=0){

            $QUERY = "SELECT phone FROM cc_speeddial WHERE id_cc_card='".$this->id_card."' AND speeddial='".$this->destination."'";
            $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY);
            if( is_array($result))    $this->destination = $result[0][0];
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "REDIAL : DESTINATION ::> ".$this->destination);
        }
        
        // FOR TESTING : ENABLE THE DESTINATION NUMBER
        if ($this->CC_TESTING) $this->destination="1800300200";
        if ($this->CC_TESTING) $this->destination="3390010022";

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "DESTINATION ::> ".$this->destination);
        if ($this->removeinterprefix) $this->destination = $this -> apply_rules ($this->destination);
        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "RULES APPLY ON DESTINATION ::> ".$this->destination);

        // TRIM THE "#"s IN THE END, IF ANY
        // usefull for SIP or IAX friends with "use_dnid" when their device sends also the "#"
        // it should be safe for normal use
        $this->destination = rtrim($this->destination, "#");

        // SAY BALANCE AND FT2C PACKAGE IF APPLICABLE
        // this is hardcoded for now but we might have a setting in a2billing.conf for the combination
        if ($this->destination=='*0'){
            $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[SAY BALANCE ::> ".$this->credit."]");
            $this -> fct_say_balance ($agi, $this->credit);

            // Retrieve this customer's FT2C package details
            $QUERY = "SELECT freetimetocall, label, packagetype, billingtype, startday, id_cc_package_offer FROM cc_card RIGHT JOIN cc_tariffgroup ON cc_tariffgroup.id=cc_card.tariff RIGHT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer WHERE cc_card.id='".$this->id_card."'";
            $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY);
            if (is_array($result) && ($result[0][0] > 0) ) {
                $freetime = $result[0][0];
                $label = $result[0][1];
                $packagetype = $result[0][2];
                $billingtype = $result[0][3];
                $startday = $result[0][4];
                $id_cc_package_offer = $result[0][5];
                $freetimetocall_used = $this->FT2C_used_seconds($this->DBHandle, $this->id_card, $id_cc_package_offer, $billingtype, $startday);
                
                //TO MANAGE BY PACKAGE TYPE IT -> only for freetime
                if (($packagetype == 0) || ($packagetype == 1)) {
                    $minutes=intval(($freetime-$freetimetocall_used)/60);
                    $seconds=($freetime-$freetimetocall_used) % 60;
                } else {
                    $minutes=intval($freetimetocall_used/60);
                    $seconds=$freetimetocall_used % 60;
                }
                // Now say either "You have X minutes and Y seconds of free package calls remaining this week/month"
                // or "You have dialed X minutes and Y seconds of free package calls this week/month"
                if (($packagetype == 0) || ($packagetype == 1)) {
                    $agi-> stream_file('prepaid-you-have', '#');
                } else {
                    $agi-> stream_file('prepaid-you-have-dialed', '#');
                }
                if (($minutes > 0) || ($seconds == 0)) {
                    $agi->say_number($minutes);
                    if ($minutes==1){
                        $agi-> stream_file('prepaid-minute', '#');
                    }else{
                        
                        if((strtolower($this->agiconfig['force_language'])=='ru')&& ( ( $minutes%10==2) || ($minutes%10==3 )|| ($minutes%10==4)) ){
                            // test for the specific grammatical rules in RUssian
                            $agi-> stream_file('prepaid-minute2', '#');
                        }else{
                            $agi-> stream_file('prepaid-minutes', '#');
                        }
                    }
                }
                if ($seconds > 0) {
                    if ($minutes > 0) $agi-> stream_file('vm-and', '#');
                    $agi->say_number($seconds);
                    if ($seconds == 1) {
                        $agi-> stream_file('prepaid-second', '#');
                    } else {
                        if((strtolower($this->agiconfig['force_language'])=='ru')&& ( ( $seconds%10==2) || ($seconds%10==3 )|| ($seconds%10==4)) ){
                            // test for the specific grammatical rules in RUssian
                            $agi-> stream_file('prepaid-second2', '#');
                        }else{
                            $agi-> stream_file('prepaid-seconds', '#');
                        }
                    }
                }
                $agi-> stream_file('prepaid-of-free-package-calls', '#');
                if (($packagetype == 0) || ($packagetype == 1)) {
                    $agi-> stream_file('prepaid-remaining', '#');
                    $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[SAY FT2C REMAINING ::> ".$minutes.":".$seconds."]");
                } else {
                    $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[SAY FT2C USED ::> ".$minutes.":".$seconds."]");
                }
                $agi-> stream_file('this', '#');
                if ($billingtype == 0) {
                    $agi-> stream_file('month', '#');
                } else {
                    $agi-> stream_file('weeks', '#');
                }
            }
            return -1;
        }

        //REDIAL FIND THE LAST DIALED NUMBER (STORED IN THE DATABASE)
        if ( $this->destination=='0*' ){
            $this->destination = $this->redial;
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[REDIAL : DTMF DESTINATION ::> ".$this->destination."]");
        }

        if ($this->destination<=0){
            $prompt = "prepaid-invalid-digits";
            // do not play the error message if the destination number is not numeric
            // because most probably it wasn't entered by user (he has a phone keypad remember?)
            // it helps with using "use_dnid" and extensions.conf routing
            if (is_numeric($this->destination)) $agi-> stream_file($prompt, '#');
            return -1;
        }

        // STRIP * FROM DESTINATION NUMBER
        $this->destination = str_replace('*', '', $this->destination);

        $this->save_redial_number($agi, $this->destination);
        
        // LOOKUP RATE : FIND A RATE FOR THIS DESTINATION
        $resfindrate = $RateEngine->rate_engine_findrates($this, $this->destination,$this->tariff);
        if ($resfindrate==0){
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "ERROR ::> RateEngine didnt succeed to match the dialed number over the ratecard (Please check : id the ratecard is well create ; if the removeInter_Prefix is set according to your prefix in the ratecard ; if you hooked the ratecard to the Call Plan)");
        }else{
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "OK - RESFINDRATE::> ".$resfindrate);
        }


        // IF DONT FIND RATE
        if ($resfindrate==0){
            $prompt="prepaid-dest-unreachable";
            $agi-> stream_file($prompt, '#');
            return -1;
        }

        /*$rate=$result[0][0];
        if ($rate<=0){
            //$prompt="prepaid-dest-blocked";
            $prompt="prepaid-dest-unreachable";
            continue;
        }*/


        // CHECKING THE TIMEOUT
        $res_all_calcultimeout = $RateEngine->rate_engine_all_calcultimeout($this, $this->credit);

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "RES_ALL_CALCULTIMEOUT ::> $res_all_calcultimeout");
        if (!$res_all_calcultimeout){
            $prompt="prepaid-no-enough-credit";
            $agi-> stream_file($prompt, '#');
            return -1;
        }


        // calculate timeout
        //$this->timeout = intval(($this->credit * 60*100) / $rate);  // -- RATE is millime cents && credit is 1cents

        $this->timeout = $RateEngine-> ratecard_obj[0]['timeout'];
        $timeout = $this->timeout;
        if ($this->agiconfig['cheat_on_announcement_time']==1){
         $timeout = $RateEngine-> ratecard_obj[0]['timeout_without_rules'];    
        }
        // set destination and timeout
        // say 'you have x minutes and x seconds'
        $minutes = intval($timeout / 60);
        $seconds = $timeout % 60;

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "TIMEOUT::> ".$this->timeout."  : minutes=$minutes - seconds=$seconds");
        if (!($minutes>0)){
            $prompt="prepaid-no-enough-credit";
            $agi-> stream_file($prompt, '#');
            return -1;
        }

        if ($this->agiconfig['say_rateinitial']==1){
            $this -> fct_say_rate ($agi, $RateEngine->ratecard_obj[0][12]);
        }

        if ($this->agiconfig['say_timetocall']==1){
            $agi-> stream_file('prepaid-you-have', '#');
            if ($minutes>0){
                $agi->say_number($minutes);
                if ($minutes==1){
                    $agi-> stream_file('prepaid-minute', '#');
                }else{
                    if((strtolower($this->agiconfig['force_language'])=='ru')&& ( ( $minutes%10==2) || ($minutes%10==3 )|| ($minutes%10==4)) ){
                            // test for the specific grammatical rules in RUssian
                            $agi-> stream_file('prepaid-minute2', '#');
                        }else{
                            $agi-> stream_file('prepaid-minutes', '#');
                        }

                }
            }
            if ($seconds>0 && ($this->agiconfig['disable_announcement_seconds']==0)){
                if ($minutes>0) $agi-> stream_file('vm-and', '#');

                $agi->say_number($seconds);
                if ($seconds==1){
                    $agi-> stream_file('prepaid-second', '#');
                }else{
                    if((strtolower($this->agiconfig['force_language'])=='ru')&& ( ( $seconds%10==2) || ($seconds%10==3 )|| ($seconds%10==4)) ){
                                // test for the specific grammatical rules in RUssian
                        $agi-> stream_file('prepaid-second2', '#');
                    }else{
                        $agi-> stream_file('prepaid-seconds', '#');
                    }
                }
            }
        }
        return 1;
    }


    /**
     *    Function call_sip_iax_buddy : make the Sip/IAX free calls
     *
     *  @param object $agi
     *  @param object $RateEngine
     *  @param integer $try_num
     *  @return 1 if Ok ; -1 if error
    **/
    function call_sip_iax_buddy($agi, &$RateEngine, $try_num)
    {
        $res = 0;

        if ( ($this->agiconfig['use_dnid']==1) && (!in_array ($this->dnid, $this->agiconfig['no_auth_dnid'])) && (strlen($this->dnid)>2 ))
        {
            $this->destination = $this->dnid;
        } else {
            $res_dtmf = $agi->get_data('prepaid-sipiax-enternumber', 6000, $this->config['global']['len_aliasnumber'], '#');
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "RES DTMF : ".$res_dtmf ["result"]);
            $this->destination = $res_dtmf ["result"];

            if ($this->destination<=0) {
                return -1;
            }
        }

        $this->save_redial_number($this->destination);

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "SIP o IAX DESTINATION : ".$this->destination);
        $sip_buddies = 0;
        $iax_buddies = 0;

        $QUERY = "SELECT name FROM cc_iax_buddies, cc_card WHERE cc_iax_buddies.name=cc_card.username AND useralias='".$this->destination."'";
        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, $QUERY);

        $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY);
        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, $result);

        if( is_array($result) && count($result) > 0) {
            $iax_buddies = 1;
            $destiax=$result[0][0];
        }

        $card_alias = $this->destination;
        $QUERY = "SELECT name FROM cc_sip_buddies, cc_card WHERE cc_sip_buddies.name=cc_card.username AND useralias='".$this->destination."'";
        $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY);
        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "RESULT : ".print_r($result,true));
        
        if( is_array($result) && count($result) > 0) {
            $sip_buddies = 1;
            $destsip=$result[0][0];
        }

        if (!$sip_buddies && !$iax_buddies){
            $agi-> stream_file('prepaid-sipiax-num-nomatch', '#');
            return -1;
        }
        
        for ($k=0;$k< $sip_buddies+$iax_buddies;$k++)
        {
            if ($k==0 && $sip_buddies) {
                $this->tech = 'SIP';
                $this->destination= $destsip;
            } else {
                $this->tech = 'IAX2';
                $this->destination = $destiax;
            }
            if ($this -> CC_TESTING) $this->destination = "kphone";

            if ($this->agiconfig['record_call'] == 1){
                $myres = $agi->exec("MixMonitor {$this->uniqueid}.{$this->agiconfig['monitor_formatfile']}|b");
                $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "EXEC MixMonitor {$this->uniqueid}.{$this->agiconfig['monitor_formatfile']}|b");
            }

            $agi->set_callerid($this->useralias);
            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[EXEC SetCallerID : ".$this->useralias."]");

            $dialparams = $this->agiconfig['dialcommand_param_sipiax_friend'];
            $dialstr = $this->tech."/".$this->destination.$dialparams;

            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "app_callingcard sip/iax friend: Dialing '$dialstr' ".$this->tech." Friend.\n");

            //# Channel: technology/number@ip_of_gw_to PSTN
            // Dial(IAX2/guest@misery.digium.com/s@default)
            $myres = $agi->exec("DIAL $dialstr");
            $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "DIAL");

            $answeredtime = $agi->get_variable("ANSWEREDTIME");
            $answeredtime = $answeredtime['data'];
            $dialstatus = $agi->get_variable("DIALSTATUS");
            $dialstatus = $dialstatus['data'];

            if ($this->agiconfig['record_call'] == 1) {
                // Monitor(wav,kiki,m)
                $myres = $agi->exec("STOPMONITOR");
                $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "EXEC StopMonitor (".$this->uniqueid."-".$this->cardnumber.")");
            }

            $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[".$this->tech." Friend][K=$k]:[ANSWEREDTIME=".$answeredtime."-DIALSTATUS=".$dialstatus."]");

            //# Ooh, something actually happend!
            if ($dialstatus  == "BUSY") {
                $answeredtime=0;
                $agi-> stream_file('prepaid-isbusy', '#');
            } elseif ($this->dialstatus == "NOANSWER") {
                $answeredtime=0;
                $agi-> stream_file('prepaid-noanswer', '#');
            } elseif ($dialstatus == "CANCEL") {
                $answeredtime=0;
            } elseif ($dialstatus == "ANSWER") {
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "-> dialstatus : $dialstatus, answered time is ".$answeredtime." \n");
            } elseif ($k+1 == $sip_buddies+$iax_buddies){
                $prompt="prepaid-dest-unreachable";
                $agi-> stream_file($prompt, '#');
            }

            if (($dialstatus  == "CHANUNAVAIL") || ($dialstatus  == "CONGESTION"))    continue;

            if ($answeredtime > 0){
                $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=$K - (answeredtime=$answeredtime :: dialstatus=$dialstatus :: cost=$cost)]");
                $QUERY = "INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, ".
                    " terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax) VALUES ".
                    "('".$this->uniqueid."', '".$this->channel."',  '".$this->username."', '".$this->hostname."',";
                if ($this->config['database']['dbtype'] == "postgres"){
                    $QUERY .= " CURRENT_TIMESTAMP - interval '$answeredtime seconds' ";
                }else{
                    $QUERY .= " CURRENT_TIMESTAMP - INTERVAL $answeredtime SECOND ";
                }
                $QUERY .= ", '$answeredtime', '".$card_alias."', '$dialstatus', now(), '0', '0', ".
                    " '".$this->countrycode."', '".$this->subcode."', '".$this->tech." CALL', '0', '0', '0', '0', '$this->CallerID', '1' )";

                $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY, 0);
                return 1;
            }
        }
        if ($this->voicemail) {
            if (($dialstatus =="CHANUNAVAIL") || ($dialstatus == "CONGESTION") ||($dialstatus == "NOANSWER")) {
                // The following section will send the caller to VoiceMail with the unavailable priority.
                // $dest = "u".$card_alias;
                $dest = $card_alias;
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[STATUS] CHANNEL UNAVAILABLE - GOTO VOICEMAIL ($dest)");
                $agi-> exec(VoiceMail,$dest);
            }

            if (($dialstatus =="BUSY")) {
                // The following section will send the caller to VoiceMail with the busy priority.
                // $dest = "b".$card_alias;
                $dest = $card_alias;
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[STATUS] CHANNEL BUSY - GOTO VOICEMAIL ($dest)");
                $agi-> exec(VoiceMail,$dest);
            }
        }

        return -1;
    }


    /**
     *    Function call_did
     *
     *  @param object $agi
     *  @param object $RateEngine
     *  @param object $listdestination
         cc_did.id, cc_did_destination.id, billingtype, cc_did.id_trunk,    destination, cc_did.id_trunk, voip_call

     *  @return 1 if Ok ; -1 if error
    **/
    function call_did ($agi, &$RateEngine, $listdestination)
    {
        $res=0;

        if ($this -> CC_TESTING) $this->destination="kphone";
        $this->agiconfig['say_balance_after_auth']=0;
        $this->agiconfig['say_timetocall']=0;


        if (($listdestination[0][2]==0) || ($listdestination[0][2]==2)) {
            $doibill = 1;
        } else {
            $doibill = 0;
        }

        $callcount=0;
        foreach ($listdestination as $inst_listdestination) {
            $callcount++;

            $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[A2Billing] DID call friend: FOLLOWME=$callcount (cardnumber:".$inst_listdestination[6]."|destination:".$inst_listdestination[4]."|tariff:".$inst_listdestination[3].")\n");

            $this->agiconfig['cid_enable']            = 0;
            $this->accountcode                 = $inst_listdestination[6];
            $this->tariff                     = $inst_listdestination[3];
            $this->destination                 = $inst_listdestination[4];
            $this->username                 = $inst_listdestination[6];
            $this->useralias                 = $inst_listdestination[7];

            // MAKE THE AUTHENTICATION TO GET ALL VALUE : CREDIT - EXPIRATION - ...
            if ($this -> callingcard_ivr_authenticate($agi)!=0) {
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[A2Billing] DID call friend: AUTHENTICATION FAILS !!!\n");
            } else {
                // CHECK IF DESTINATION IS SET
                if (strlen($inst_listdestination[4])==0) continue;

                // IF VOIP CALL
                if ($inst_listdestination[5]==1){

                    // RUN MIXMONITOR TO RECORD CALL
                    if ($this->agiconfig['record_call'] == 1){
                        $myres = $agi->exec("MixMonitor {$this->uniqueid}.{$this->agiconfig['monitor_formatfile']}|b");
                        $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "EXEC MixMonitor {$this->uniqueid}.{$this->agiconfig['monitor_formatfile']}|b");
                    }

                    $dialparams = $this->agiconfig['dialcommand_param_sipiax_friend'];
                    $dialstr     = $inst_listdestination[4].$dialparams;

                    $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[A2Billing] DID call friend: Dialing '$dialstr' Friend.\n");

                    //# Channel: technology/number@ip_of_gw_to PSTN
                    // Dial(IAX2/guest@misery.digium.com/s@default)
                    // DIAL OUT
                    $myres = $agi->exec("DIAL $dialstr");
                    $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "DIAL");

                    $answeredtime     = $agi->get_variable("ANSWEREDTIME");
                    $answeredtime     = $answeredtime['data'];
                    $dialstatus     = $agi->get_variable("DIALSTATUS");
                    $dialstatus     = $dialstatus['data'];

                    if ($this->agiconfig['record_call'] == 1){
                        $myres = $agi->exec("STOPMONITOR");
                        $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "EXEC StopMonitor (".$this->uniqueid."-".$this->cardnumber.")");
                    }

                    $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[".$inst_listdestination[4]." Friend][followme=$callcount]:[ANSWEREDTIME=".$answeredtime."-DIALSTATUS=".$dialstatus."]");


                    //# Ooh, something actually happend!
                    if ($dialstatus  == "BUSY") {
                        $answeredtime=0;
                        $agi-> stream_file('prepaid-isbusy', '#');
                        // FOR FOLLOWME IF THERE IS MORE WE PASS TO THE NEXT ONE OTHERWISE WE NEED TO LOG THE CALL MADE
                        if (count($listdestination)>$callcount) continue;
                    } elseif ($this->dialstatus == "NOANSWER") {
                        $answeredtime=0;
                        $agi-> stream_file('prepaid-callfollowme', '#');
                        // FOR FOLLOWME IF THERE IS MORE WE PASS TO THE NEXT ONE OTHERWISE WE NEED TO LOG THE CALL MADE
                        if (count($listdestination)>$callcount) continue;
                    } elseif ($dialstatus == "CANCEL") {
                        $answeredtime=0;
                        // FOR FOLLOWME IF THERE IS MORE WE PASS TO THE NEXT ONE OTHERWISE WE NEED TO LOG THE CALL MADE
                        if (count($listdestination)>$callcount) continue;
                    } elseif ($dialstatus == "ANSWER") {
                        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[A2Billing] DID call friend: dialstatus : $dialstatus, answered time is ".$answeredtime." \n");
                    } elseif (($dialstatus  == "CHANUNAVAIL") || ($dialstatus  == "CONGESTION")) {
                        $answeredtime=0;
                        // FOR FOLLOWME IF THERE IS MORE WE PASS TO THE NEXT ONE OTHERWISE WE NEED TO LOG THE CALL MADE
                        if (count($listdestination)>$callcount) continue;
                    } else{
                        $agi-> stream_file('prepaid-callfollowme', '#');
                        // FOR FOLLOWME IF THERE IS MORE WE PASS TO THE NEXT ONE OTHERWISE WE NEED TO LOG THE CALL MADE
                        if (count($listdestination)>$callcount) continue;
                    }

                    if ($answeredtime >0) {

                        $this -> debug( WRITELOG, $agi, __FILE__, __LINE__, "[DID CALL - LOG CC_CALL: FOLLOWME=$callcount - (answeredtime=$answeredtime :: dialstatus=$dialstatus :: cost=$cost)]");

                        $QUERY = "INSERT INTO cc_call (uniqueid,sessionid,username,nasipaddress,starttime,sessiontime, calledstation, ".
                            " terminatecause, stoptime, calledrate, sessionbill, calledcountry, calledsub, destination, id_tariffgroup, id_tariffplan, id_ratecard, id_trunk, src, sipiax) VALUES ".
                            "('".$this->uniqueid."', '".$this->channel."',  '".$this->username."', '".$this->hostname."',";
                        if ($this->config['database']['dbtype'] == "postgres"){
                            $QUERY .= " CURRENT_TIMESTAMP - interval '$answeredtime seconds' ";
                        }else{
                            $QUERY .= " CURRENT_TIMESTAMP - INTERVAL $answeredtime SECOND ";
                        }
                        $QUERY .= ", '$answeredtime', '".$inst_listdestination[4]."', '$dialstatus', now(), '0', '0', ".
                            " '".$this->countrycode."', '".$this->subcode."', 'DID CALL', '0', '0', '0', '0', '$this->CallerID', '3' )";

                        $result = $this -> instance_table -> SQLExec ($this->DBHandle, $QUERY, 0);
                        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[DID CALL - LOG CC_CALL: SQL: $QUERY]:[result:$result]");

                        // CC_DID & CC_DID_DESTINATION - cc_did.id, cc_did_destination.id
                        $QUERY = "UPDATE cc_did SET secondusedreal = secondusedreal + $answeredtime WHERE id='".$inst_listdestination[0]."'";
                        $result = $this->instance_table -> SQLExec ($this -> DBHandle, $QUERY, 0);
                        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[UPDATE DID]:[result:$result]");

                        $QUERY = "UPDATE cc_did_destination SET secondusedreal = secondusedreal + $answeredtime WHERE id='".$inst_listdestination[1]."'";
                        $result = $this->instance_table -> SQLExec ($this -> DBHandle, $QUERY, 0);
                        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[UPDATE DID_DESTINATION]:[result:$result]");

                        return 1;
                    }

                // ELSEIF NOT VOIP CALL
                } else {

                    $this->agiconfig['use_dnid']=1;
                    $this->agiconfig['say_timetocall']=0;

                    $this->dnid = $this->destination = $inst_listdestination[4];
                    if ($this->CC_TESTING) $this->dnid = $this->destination="011324885";


                    if ($this -> callingcard_ivr_authorize($agi, $RateEngine, 0)==1){

                        // PERFORM THE CALL
                        $result_callperf = $RateEngine->rate_engine_performcall ($agi, $this -> destination, $this);
                        if (!$result_callperf) {
                            $prompt="prepaid-callfollowme";
                            $agi-> stream_file($prompt, '#');
                            continue;
                        }

                        $dialstatus = $RateEngine->dialstatus;
                        if (($RateEngine->dialstatus == "NOANSWER") || ($RateEngine->dialstatus == "CANCEL") || ($RateEngine->dialstatus == "BUSY") || ($RateEngine->dialstatus == "CHANUNAVAIL") || ($RateEngine->dialstatus == "CONGESTION")) continue;

                        // INSERT CDR  & UPDATE SYSTEM
                        $RateEngine->rate_engine_updatesystem($this, $agi, $this-> destination, $doibill, 1);
                        // CC_DID & CC_DID_DESTINATION - cc_did.id, cc_did_destination.id
                        $QUERY = "UPDATE cc_did SET secondusedreal = secondusedreal + ".$RateEngine->answeredtime." WHERE id='".$inst_listdestination[0]."'";
                        $result = $this->instance_table -> SQLExec ($this -> DBHandle, $QUERY, 0);
                        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[UPDATE DID]:[result:$result]");

                        $QUERY = "UPDATE cc_did_destination SET secondusedreal = secondusedreal + ".$RateEngine->answeredtime." WHERE id='".$inst_listdestination[1]."'";
                        $result = $this->instance_table -> SQLExec ($this -> DBHandle, $QUERY, 0);
                        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[UPDATE DID_DESTINATION]:[result:$result]");
                        
                        // THEN STATUS IS ANSWER
                        break;
                    }
                }
            } // END IF AUTHENTICATE
        }// END FOR
        
        if ($this->voicemail) {
            if (($dialstatus =="CHANUNAVAIL") || ($dialstatus == "CONGESTION") ||($dialstatus == "NOANSWER")) {
                // The following section will send the caller to VoiceMail with the unavailable priority.
                // $dest = "u".$this->useralias;
                $dest = $this->useralias;
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[STATUS] CHANNEL UNAVAILABLE - GOTO VOICEMAIL ($dest)");
                $agi-> exec(VoiceMail,$dest);
            }

            if (($dialstatus =="BUSY")) {
                // The following section will send the caller to VoiceMail with the busy priority.
                // $dest = "b".$this->useralias;
                $dest = $this->useralias;
                $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[STATUS] CHANNEL BUSY - GOTO VOICEMAIL ($dest)");
                $agi-> exec(VoiceMail,$dest);
            }
        }
    }


    /**
     *    Function to play the balance
     *     format : "you have 100 dollars and 28 cents"
     *
     *  @param object $agi
     *  @param float $credit
     *  @return nothing
    **/
    function fct_say_balance ($agi, $credit, $fromvoucher = 0)
    {
        global $currencies_list;

        if (isset($this->agiconfig['agi_force_currency']) && strlen($this->agiconfig['agi_force_currency'])==3)
        {
            $this->currency = $this->agiconfig['agi_force_currency'];
        }

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[CURRENCY : $this->currency]");
        if (!isset($currencies_list[strtoupper($this->currency)][2]) || !is_numeric($currencies_list[strtoupper($this->currency)][2])) $mycur = 1;
        else $mycur = $currencies_list[strtoupper($this->currency)][2];
        $credit_cur = $credit / $mycur;

        list($units, $cents)=split('[.]', sprintf('%01.2f', $credit_cur));

        $this -> debug( VERBOSE | WRITELOG, $agi, __FILE__, __LINE__, "[BEFORE: $credit_cur SPRINTF : ".sprintf('%01.2f', $credit_cur)."]");

        if (isset($this->