hello,
here all the log on tha a2billing_agi of a call.. can u plz help me thanks
[05/05/2013 17:08:47]:[file:Class.A2Billing.php - line:604 - uniqueid:]:[CallerID:]:[CN:]:[A2Billing AGI internal configuration:] [05/05/2013 17:08:47]:[file:Class.A2Billing.php - line:605 - uniqueid:]:[CallerID:]:[CN:]:[Array ( [dialcommand_param_call_2did] => |60|HiL(%timeout%:61000:30000) [description] => agi-config [asterisk_version] => 1_6 [answer_call] => 1 [play_audio] => 0 [say_goodbye] => 0 [play_menulanguage] => 0 [force_language] => [intro_prompt] => [min_credit_2call] => 0 [min_duration_2bill] => 0 [notenoughcredit_cardnumber] => 0 [notenoughcredit_assign_newcardnumber_cid] => 0 [use_dnid] => 1 [no_auth_dnid] => Array ( [0] => 2400 [1] => 2300 )
[number_try] => 3 [force_callplan_id] => [say_balance_after_auth] => 1 [say_balance_after_call] => 0 [say_rateinitial] => 0 [say_timetocall] => 1 [auto_setcallerid] => 1 [force_callerid] => [cid_sanitize] => 0 [cid_enable] => 0 [cid_askpincode_ifnot_callerid] => 1 [failover_lc_prefix] => 0 [cid_auto_assign_card_to_cid] => 1 [callerid_authentication_over_cardnumber] => 0 [sip_iax_friends] => 0 [sip_iax_pstn_direct_call_prefix] => 555 [sip_iax_pstn_direct_call] => 0 [ivr_voucher] => 0 [ivr_voucher_prefix] => 8 [jump_voucher_if_min_credit] => 0 [dialcommand_param] => |60|HRrL(%timeout%:61000:30000) [dialcommand_param_sipiax_friend] => |60|HiL(3600000:61000:30000) [switchdialcommand] => 1 [failover_recursive_limit] => 2 [maxtime_tocall_negatif_free_route] => 5400 [send_reminder] => 0 [record_call] => 0 [monitor_formatfile] => gsm [agi_force_currency] => [currency_association] => Array ( [0] => usd:dollars [1] => mxn:pesos [2] => eur:euros [3] => all:credit )
[local_dialing_addcountryprefix] => 0 [max_call_call_2_did] => 3600 [file_conf_enter_destination] => prepaid-enter-dest [conf_order_menulang] => en:fr:es [callback_bill_1stleg_ifcall_notconnected] => 1 [international_prefixes] => Array ( [0] => 011 [1] => 00 [2] => 09 [3] => 1 )
[extracharge_did] => Array ( [0] => 1800 [1] => 1900 )
[extracharge_fee] => Array ( [0] => 0 [1] => 0 )
[extracharge_buyfee] => Array ( [0] => 0 [1] => 0 )
[maxtime_tounlimited_calls] => 5400 [maxtime_tofree_calls] => 5400 [callplan_deck_minute_threshold] => [disable_announcement_seconds] => 0 [verbosity_level] => 0 [logging_level] => 4 [dial_balance_reservation] => 0.25 [callerid_update] => 0 [cid_auto_create_card] => 0 [cid_auto_create_card_len] => 10 [cid_auto_create_card_typepaid] => PREPAID [cid_auto_create_card_credit] => 0 [cid_auto_create_card_credit_limit] => 0 [cid_auto_create_card_tariffgroup] => 1 [busy_timeout] => 1 [callback_reduce_balance] => 1 [ivr_enable_locking_option] => 0 [ivr_enable_account_information] => 0 [ivr_enable_ivr_speeddial] => 0 [play_rate_cents_if_lower_one] => 0 [callback_beep_to_enter_destination] => 0 [cid_prompt_callback_confirm_phonenumber] => 0 [logger_enable] => 1 [log_file] => /var/log/a2billing/a2billing.log [dialcommand_param_call_2did ] => |30|HL(3600000:61000:30000) [currency_association_internal] => Array ( [usd] => dollars [mxn] => pesos [eur] => euros [all] => credit )
[file_conf_enter_menulang] => prepaid-menulang [ivr_voucher_prefixe] => 8 [cheat_on_announcement_time] => 0 ) ] [05/05/2013 17:08:47]:[file:a2billing.php - line:106 - uniqueid:]:[CallerID:]:[CN:]:[IDCONFIG : 2] [05/05/2013 17:08:47]:[file:a2billing.php - line:107 - uniqueid:]:[CallerID:]:[CN:]:[MODE : standard] [05/05/2013 17:08:47]:[file:a2billing.php - line:124 - uniqueid:]:[CallerID:]:[CN:]:[AGI Request: Array ( [agi_request] => a2billing.php [agi_channel] => SIP/4887623847-00000052 [agi_language] => en [agi_type] => SIP [agi_uniqueid] => 1367766527.82 [agi_version] => 1.8.11.1-1digium1~lucid [agi_callerid] => 4887623847 [agi_calleridname] => unknown [agi_callingpres] => 0 [agi_callingani2] => 0 [agi_callington] => 0 [agi_callingtns] => 0 [agi_dnid] => 555 [agi_rdnis] => unknown [agi_context] => a2billing-sip [agi_extension] => 555 [agi_priority] => 1 [agi_enhanced] => 0.0 [agi_accountcode] => 4887623847 [agi_threadid] => 139868021856000 [agi_arg_1] => 2 ) ] [05/05/2013 17:08:47]:[file:a2billing.php - line:126 - uniqueid:]:[CallerID:]:[CN:]:[[INFO : A2Billing - Version 1.9.4 (Cuprum)]] [05/05/2013 17:08:47]:[file:Class.A2Billing.php - line:718 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[ get_agi_request_parameter = 4887623847 ; SIP/4887623847-00000052 ; 1367766527.82 ; 4887623847 ; 555] [05/05/2013 17:08:47]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[Running time=0.0025959014892578 - QUERY= SELECT id, currency, name, value FROM cc_currencies ORDER BY id ] [05/05/2013 17:08:47]:[file:a2billing.php - line:162 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[[ANSWER CALL]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2721 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:]:[ - Account code ::> 4887623847] [05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00097417831420898 - QUERY= SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='4887623847' ] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2738 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ - Retrieve account info SQL ::> SELECT credit, tariff, activated, inuse, simultaccess, typepaid, creditlimit, language, removeinterprefix, redial, enableexpire, UNIX_TIMESTAMP(expirationdate), expiredays, nbused, UNIX_TIMESTAMP(firstusedate), UNIX_TIMESTAMP(cc_card.creationdate), cc_card.currency, cc_card.lastname, cc_card.firstname, cc_card.email, cc_card.uipass, cc_card.id_campaign, cc_card.id, useralias, status, voicemail_permitted, voicemail_activated, cc_card.restriction, cc_country.countryprefix FROM cc_card LEFT JOIN cc_tariffgroup ON tariff=cc_tariffgroup.id LEFT JOIN cc_country ON cc_card.country=cc_country.countrycode WHERE username='4887623847'] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2807 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[SET CHANNEL(language) en]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2811 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[credit=5.00000 :: tariff=1 :: status=1 :: isused=0 :: simultaccess=0 :: typepaid=0 :: creditlimit= :: language=en]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:750 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CARD STATUS UPDATE]] [05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00041699409484863 - QUERY= UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='4887623847' ] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:759 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse+1, credit=credit-0.25 WHERE username='4887623847']] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:3099 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[A2Billing] SAY BALANCE : 5.00000 ] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:1924 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CURRENCY : EUR]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:1931 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[BEFORE: 4.1955108034403 SPRINTF : 4.20]] [05/05/2013 17:08:48]:[file:a2billing.php - line:178 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[TRY : callingcard_ivr_authenticate]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2392 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[AUTO SetCallerID]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2398 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[REQUESTED SetCallerID : 4887623847]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:2410 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[EXEC SetCallerID : 4887623847]] [05/05/2013 17:08:48]:[file:a2billing.php - line:193 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CHANNEL STATUS : 6 = Line is up] [CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]] [05/05/2013 17:08:48]:[file:a2billing.php - line:396 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[TARIFF ID -> 1] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:808 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[use_dnid:1 && (!in_array:) && len_dnid:(3 || len_exten:3 ) && (try_num:0)] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:817 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[USE_DNID DESTINATION ::> 555]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:881 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CALL 2 DID]] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:890 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='555' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')] [05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00042390823364258 - QUERY= SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='555' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00') ] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:896 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[DESTINATION ::> 555] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:903 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RULES APPLY ON DESTINATION ::> 555] [05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00031399726867676 - QUERY= UPDATE cc_card SET redial = '555' WHERE username='4887623847' ] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:3551 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '555' WHERE username='4887623847']:[result: 1]] [05/05/2013 17:08:48]:[file:Class.RateEngine.php - line:98 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine: (1, 555)]] [05/05/2013 17:08:48]:[file:Class.RateEngine.php - line:120 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine - CALLERID : 4887623847]] [05/05/2013 17:08:48]:[file:Class.Table.php - line:182 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00136399269104 - QUERY= SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination, cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock, connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix, musiconhold, tp_trunk.failover_trunk AS tp_failover_trunk, rt_trunk.failover_trunk AS rt_failover_trunk,tp_trunk.addparameter AS tp_addparameter_trunk, rt_trunk.addparameter AS rt_addparameter_trunk, id_outbound_cidgroup, id_cc_package_offer, tp_trunk.status, rt_trunk.status, tp_trunk.inuse, rt_trunk.inuse, tp_trunk.maxuse, rt_trunk.maxuse,tp_trunk.if_max_use, rt_trunk.if_max_use,cc_ratecard.rounding_calltime AS rounding_calltime, cc_ratecard.rounding_threshold AS rounding_threshold, cc_ratecard.additional_block_charge AS additional_block_charge, cc_ratecard.additional_block_charge_time AS additional_block_charge_time, cc_ratecard.additional_grace AS additional_grace, cc_ratecard.minimal_cost AS minimal_cost,disconnectcharge_after,announce_time_correction
FROM cc_tariffgroup RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
WHERE cc_tariffgroup.id=1 AND ((dialprefix='555' OR dialprefix='55' OR dialprefix='5' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '555' REGEXP REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CONCAT('^', dialprefix, '$'), 'X', '[0-9]'), 'Z', '[1-9]'), 'N', '[2-9]'), '.', '.+'), '_', ''))) AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL) AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL) AND (starttime <= 9668 AND endtime >=9668) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('555',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = (SELECT COUNT(dnidprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE dnidprefix=SUBSTRING('555',1,length(dnidprefix)) AND idtariffgroup=1 ) )) AND ( calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = (SELECT count(calleridprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) AND idtariffgroup=1 ))) ORDER BY LENGTH(dialprefix) DESC ] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:1017 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[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)] [05/05/2013 17:08:48]:[file:a2billing.php - line:572 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ANSWER fct callingcard_ivr authorize:> -1] [05/05/2013 17:08:48]:[file:a2billing.php - line:193 - uniqueid:1367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CHANNEL STATUS : 6 = Line is up] [CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]] [05/05/2013 17:08:48]:[file:a2billing.php - line:396 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[TARIFF ID -> 1] [05/05/2013 17:08:48]:[file:Class.A2Billing.php - line:808 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[use_dnid:0 && (!in_array:) && len_dnid:(3 || len_exten:3 ) && (try_num:1)] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:825 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RES DTMF : 1] [05/05/2013 17:08:51]:[file:Class.Table.php - line:182 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00044417381286621 - QUERY= SELECT phone FROM cc_speeddial WHERE id_cc_card='3' AND speeddial='1' ] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:871 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SPEEDIAL REPLACE DESTINATION ::> 1] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:881 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CALL 2 DID]] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:890 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='1' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')] [05/05/2013 17:08:51]:[file:Class.Table.php - line:182 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00040817260742188 - QUERY= SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='1' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00') ] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:896 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[DESTINATION ::> 1] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:903 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RULES APPLY ON DESTINATION ::> ] [05/05/2013 17:08:51]:[file:a2billing.php - line:572 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ANSWER fct callingcard_ivr authorize:> -1] [05/05/2013 17:08:51]:[file:a2billing.php - line:193 - uniqueid:2367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CHANNEL STATUS : 6 = Line is up] [CREDIT : 5.00000][CREDIT MIN_CREDIT_2CALL : 0]] [05/05/2013 17:08:51]:[file:a2billing.php - line:396 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[TARIFF ID -> 1] [05/05/2013 17:08:51]:[file:Class.A2Billing.php - line:808 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[use_dnid:0 && (!in_array:) && len_dnid:(3 || len_exten:3 ) && (try_num:2)] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:825 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RES DTMF : 19] [05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00040721893310547 - QUERY= SELECT phone FROM cc_speeddial WHERE id_cc_card='3' AND speeddial='19' ] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:871 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SPEEDIAL REPLACE DESTINATION ::> 19] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:881 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CALL 2 DID]] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:890 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='19' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00')] [05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00040411949157715 - QUERY= SELECT cc_did.id, iduser FROM cc_did, cc_card WHERE cc_card.status=1 and cc_card.id=iduser and cc_did.activated=1 and did='19' AND cc_did.startingdate<= CURRENT_TIMESTAMP AND (cc_did.expirationdate > CURRENT_TIMESTAMP OR cc_did.expirationdate IS NULL OR cc_did.expirationdate = '0000-00-00 00:00:00') ] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:896 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[DESTINATION ::> 19] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:903 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[RULES APPLY ON DESTINATION ::> 9] [05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.0003821849822998 - QUERY= UPDATE cc_card SET redial = '9' WHERE username='4887623847' ] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:3551 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[SAVING DESTINATION FOR REDIAL: SQL: UPDATE cc_card SET redial = '9' WHERE username='4887623847']:[result: 1]] [05/05/2013 17:08:53]:[file:Class.RateEngine.php - line:98 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine: (1, 9)]] [05/05/2013 17:08:53]:[file:Class.RateEngine.php - line:120 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CC_asterisk_rate-engine - CALLERID : 4887623847]] [05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.0013830661773682 - QUERY= SELECT tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination, cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock, connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb,timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc,cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech,tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix,cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech,rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix, musiconhold, tp_trunk.failover_trunk AS tp_failover_trunk, rt_trunk.failover_trunk AS rt_failover_trunk,tp_trunk.addparameter AS tp_addparameter_trunk, rt_trunk.addparameter AS rt_addparameter_trunk, id_outbound_cidgroup, id_cc_package_offer, tp_trunk.status, rt_trunk.status, tp_trunk.inuse, rt_trunk.inuse, tp_trunk.maxuse, rt_trunk.maxuse,tp_trunk.if_max_use, rt_trunk.if_max_use,cc_ratecard.rounding_calltime AS rounding_calltime, cc_ratecard.rounding_threshold AS rounding_threshold, cc_ratecard.additional_block_charge AS additional_block_charge, cc_ratecard.additional_block_charge_time AS additional_block_charge_time, cc_ratecard.additional_grace AS additional_grace, cc_ratecard.minimal_cost AS minimal_cost,disconnectcharge_after,announce_time_correction
FROM cc_tariffgroup RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk
WHERE cc_tariffgroup.id=1 AND ((dialprefix='9' OR dialprefix='defaultprefix') OR (dialprefix LIKE '&_%' ESCAPE '&' AND '9' REGEXP REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CONCAT('^', dialprefix, '$'), 'X', '[0-9]'), 'Z', '[1-9]'), 'N', '[2-9]'), '.', '.+'), '_', ''))) AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL) AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL) AND (starttime <= 9668 AND endtime >=9668) AND idtariffgroup='1' AND ( dnidprefix=SUBSTRING('555',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = (SELECT COUNT(dnidprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE dnidprefix=SUBSTRING('555',1,length(dnidprefix)) AND idtariffgroup=1 ) )) AND ( calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = (SELECT count(calleridprefix) FROM cc_tariffgroup_plan RIGHT JOIN cc_tariffplan ON cc_tariffgroup_plan.idtariffplan=cc_tariffplan.id WHERE calleridprefix=SUBSTRING('4887623847',1,length(calleridprefix)) AND idtariffgroup=1 ))) ORDER BY LENGTH(dialprefix) DESC ] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:1017 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[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)] [05/05/2013 17:08:53]:[file:a2billing.php - line:572 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[ANSWER fct callingcard_ivr authorize:> -1] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:750 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[CARD STATUS UPDATE]] [05/05/2013 17:08:53]:[file:Class.Table.php - line:182 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[Running time=0.00035905838012695 - QUERY= UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='4887623847' ] [05/05/2013 17:08:53]:[file:Class.A2Billing.php - line:759 - uniqueid:3367766527.82]:[CallerID:4887623847]:[CN:4887623847]:[[QUERY USING CARD UPDATE::> UPDATE cc_card SET inuse=inuse-1, credit=credit+0.25 WHERE username='4887623847']] [05/05/2013 17:08:53]:[CallerID:4887623847]:[CN:4887623847]:[[exit]]
|