| 1 |
[04/07/2008 18:59:28]:[file:a2billing.php - line:78]:[CallerID:]:[CN:]:[IDCONFIG : 1] |
|---|
| 2 |
[04/07/2008 18:59:28]:[file:a2billing.php - line:79]:[CallerID:]:[CN:]:[MODE : standard] |
|---|
| 3 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:621]:[CallerID:8299518526]:[CN:]:[ get_agi_request_parameter = 8299518526 ; SIP/8299518526-095a35c8 ; 1215212367.5 ; 8299518526 ; 18095673804] |
|---|
| 4 |
[04/07/2008 18:59:28]:[file:a2billing.php - line:141]:[CallerID:8299518526]:[CN:]:[[ANSWER CALL]] |
|---|
| 5 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1438]:[CallerID:8299518526]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:8299518526]] |
|---|
| 6 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1439]:[CallerID:8299518526]:[CN:]:[[CID_ENABLE - CID_CONTROL - CID:8299518526]] |
|---|
| 7 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1456]:[CallerID:8299518526]:[CN:]:[QUERY = SELECT cc_callerid.cid, cc_callerid.id_cc_card, cc_callerid.activated, cc_card.credit, cc_card.tariff, cc_card.activated, cc_card.inuse, cc_card.simultaccess, cc_card.typepaid, cc_card.creditlimit, cc_card.language, cc_card.username, removeinterprefix, cc_card.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 FROM cc_callerid LEFT JOIN cc_card ON cc_callerid.id_cc_card=cc_card.id LEFT JOIN cc_tariffgroup ON cc_card.tariff=cc_tariffgroup.id WHERE cc_callerid.cid='8299518526' |
|---|
| 8 |
RESULT : Array |
|---|
| 9 |
( |
|---|
| 10 |
[0] => Array |
|---|
| 11 |
( |
|---|
| 12 |
[0] => 8299518526 |
|---|
| 13 |
[cid] => 8299518526 |
|---|
| 14 |
[1] => 1 |
|---|
| 15 |
[id_cc_card] => 1 |
|---|
| 16 |
[2] => t |
|---|
| 17 |
[activated] => t |
|---|
| 18 |
[3] => 300.00000 |
|---|
| 19 |
[credit] => 300.00000 |
|---|
| 20 |
[4] => 1 |
|---|
| 21 |
[tariff] => 1 |
|---|
| 22 |
[5] => t |
|---|
| 23 |
[6] => 0 |
|---|
| 24 |
[inuse] => 0 |
|---|
| 25 |
[7] => 1 |
|---|
| 26 |
[simultaccess] => 1 |
|---|
| 27 |
[8] => 0 |
|---|
| 28 |
[typepaid] => 0 |
|---|
| 29 |
[9] => |
|---|
| 30 |
[creditlimit] => |
|---|
| 31 |
[10] => es |
|---|
| 32 |
[language] => es |
|---|
| 33 |
[11] => 5926325728 |
|---|
| 34 |
[username] => 5926325728 |
|---|
| 35 |
[12] => 0 |
|---|
| 36 |
[removeinterprefix] => 0 |
|---|
| 37 |
[13] => |
|---|
| 38 |
[redial] => |
|---|
| 39 |
[14] => 0 |
|---|
| 40 |
[enableexpire] => 0 |
|---|
| 41 |
[15] => 1530743817 |
|---|
| 42 |
[UNIX_TIMESTAMP(expirationdate)] => 1530743817 |
|---|
| 43 |
[16] => 0 |
|---|
| 44 |
[expiredays] => 0 |
|---|
| 45 |
[17] => 0 |
|---|
| 46 |
[nbused] => 0 |
|---|
| 47 |
[18] => 0 |
|---|
| 48 |
[UNIX_TIMESTAMP(firstusedate)] => 0 |
|---|
| 49 |
[19] => 1215211035 |
|---|
| 50 |
[UNIX_TIMESTAMP(cc_card.creationdate)] => 1215211035 |
|---|
| 51 |
[20] => USD |
|---|
| 52 |
[currency] => USD |
|---|
| 53 |
[21] => |
|---|
| 54 |
[lastname] => |
|---|
| 55 |
[22] => |
|---|
| 56 |
[firstname] => |
|---|
| 57 |
[23] => |
|---|
| 58 |
[email] => |
|---|
| 59 |
[24] => 7808794005 |
|---|
| 60 |
[uipass] => 7808794005 |
|---|
| 61 |
[25] => -1 |
|---|
| 62 |
[id_campaign] => -1 |
|---|
| 63 |
[26] => 1 |
|---|
| 64 |
[id] => 1 |
|---|
| 65 |
[27] => 8299518526 |
|---|
| 66 |
[useralias] => 8299518526 |
|---|
| 67 |
) |
|---|
| 68 |
|
|---|
| 69 |
) |
|---|
| 70 |
] |
|---|
| 71 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1625]:[CallerID:8299518526]:[CN:]:[ - Account code - 5926325728] |
|---|
| 72 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1714]:[CallerID:8299518526]:[CN:5926325728]:[[SET CHANNEL(language) es]] |
|---|
| 73 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1717]:[CallerID:8299518526]:[CN:5926325728]:[[credit=300.00000 :: tariff=1 :: active=t :: isused=0 :: simultaccess=1 :: typepaid=0 :: creditlimit= :: language=es]] |
|---|
| 74 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:654]:[CallerID:8299518526]:[CN:5926325728]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse+1 WHERE username='5926325728']] |
|---|
| 75 |
[04/07/2008 18:59:28]:[file:a2billing.php - line:158]:[CallerID:8299518526]:[CN:5926325728]:[[TRY : callingcard_ivr_authenticate]] |
|---|
| 76 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1400]:[CallerID:8299518526]:[CN:5926325728]:[[AUTO SetCallerID]] |
|---|
| 77 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1406]:[CallerID:8299518526]:[CN:5926325728]:[[REQUESTED SetCallerID : 8299518526]] |
|---|
| 78 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:1417]:[CallerID:8299518526]:[CN:5926325728]:[[EXEC SetCallerID : 8299518526]] |
|---|
| 79 |
[04/07/2008 18:59:28]:[file:a2billing.php - line:172]:[CallerID:8299518526]:[CN:5926325728]:[[CHANNEL STATUS : 6 = Line is up]] |
|---|
| 80 |
[04/07/2008 18:59:28]:[file:a2billing.php - line:173]:[CallerID:8299518526]:[CN:5926325728]:[[CREDIT : 300.00000][CREDIT MIN_CREDIT_2CALL : 5.40]] |
|---|
| 81 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:676]:[CallerID:8299518526]:[CN:5926325728]:[1 && && 11&& 0] |
|---|
| 82 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:701]:[CallerID:8299518526]:[CN:5926325728]:[DESTINATION ::> 18095673804] |
|---|
| 83 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:703]:[CallerID:8299518526]:[CN:5926325728]:[RULES APPLY ON DESTINATION ::> 18095673804] |
|---|
| 84 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:73]:[CallerID:8299518526]:[CN:5926325728]:[[CC_asterisk_rate-engine: (1, 18095673804)]] |
|---|
| 85 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:122]:[CallerID:8299518526]:[CN:5926325728]:[[CC_asterisk_rate-engine: CALLERID] |
|---|
| 86 |
8299518526 |
|---|
| 87 |
] |
|---|
| 88 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:136]:[CallerID:8299518526]:[CN:5926325728]:[[CALLERID_QUERY] |
|---|
| 89 |
SELECT count(calleridprefix) FROM cc_tariffplan RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=1 WHERE calleridprefix=SUBSTRING('8299518526',1,length(calleridprefix)) |
|---|
| 90 |
[RESULT]Array |
|---|
| 91 |
( |
|---|
| 92 |
[0] => Array |
|---|
| 93 |
( |
|---|
| 94 |
[0] => 0 |
|---|
| 95 |
[count(calleridprefix)] => 0 |
|---|
| 96 |
) |
|---|
| 97 |
|
|---|
| 98 |
) |
|---|
| 99 |
|
|---|
| 100 |
] |
|---|
| 101 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:184]:[CallerID:8299518526]:[CN:5926325728]:[[RATE ENGINE QUERY] |
|---|
| 102 |
SELECT |
|---|
| 103 |
tariffgroupname, lcrtype, idtariffgroup, cc_tariffgroup_plan.idtariffplan, tariffname, destination, |
|---|
| 104 |
cc_ratecard.id, dialprefix, destination, buyrate, buyrateinitblock, buyrateincrement, rateinitial, initblock, billingblock, |
|---|
| 105 |
connectcharge, disconnectcharge, stepchargea, chargea, timechargea, billingblocka, stepchargeb, chargeb, |
|---|
| 106 |
timechargeb, billingblockb, stepchargec, chargec, timechargec, billingblockc, |
|---|
| 107 |
cc_tariffplan.id_trunk AS tp_id_trunk, tp_trunk.trunkprefix AS tp_trunk, tp_trunk.providertech AS tp_providertech, |
|---|
| 108 |
tp_trunk.providerip AS tp_providerip, tp_trunk.removeprefix AS tp_removeprefix, |
|---|
| 109 |
cc_ratecard.id_trunk AS rc_id_trunk, rt_trunk.trunkprefix AS rc_trunkprefix, rt_trunk.providertech AS rc_providertech, |
|---|
| 110 |
rt_trunk.providerip AS rc_providerip, rt_trunk.removeprefix AS rc_removeprefix, musiconhold, |
|---|
| 111 |
tp_trunk.failover_trunk AS tp_failover_trunk, rt_trunk.failover_trunk AS rt_failover_trunk, |
|---|
| 112 |
tp_trunk.addparameter AS tp_addparameter_trunk, rt_trunk.addparameter AS rt_addparameter_trunk, id_outbound_cidgroup, |
|---|
| 113 |
freetimetocall_package_offer, freetimetocall, packagetype, billingtype, startday, id_cc_package_offer |
|---|
| 114 |
|
|---|
| 115 |
FROM cc_tariffgroup |
|---|
| 116 |
RIGHT JOIN cc_tariffgroup_plan ON cc_tariffgroup_plan.idtariffgroup=cc_tariffgroup.id |
|---|
| 117 |
INNER JOIN cc_tariffplan ON (cc_tariffplan.id=cc_tariffgroup_plan.idtariffplan ) |
|---|
| 118 |
LEFT JOIN cc_ratecard ON cc_ratecard.idtariffplan=cc_tariffplan.id |
|---|
| 119 |
LEFT JOIN cc_trunk AS rt_trunk ON cc_ratecard.id_trunk=rt_trunk.id_trunk |
|---|
| 120 |
LEFT JOIN cc_trunk AS tp_trunk ON cc_tariffplan.id_trunk=tp_trunk.id_trunk |
|---|
| 121 |
LEFT JOIN cc_package_offer ON cc_package_offer.id=cc_tariffgroup.id_cc_package_offer |
|---|
| 122 |
|
|---|
| 123 |
WHERE cc_tariffgroup.id=1 AND (dialprefix='18095673804' OR dialprefix='1809567380' OR dialprefix='180956738' OR dialprefix='18095673' OR dialprefix='1809567' OR dialprefix='180956' OR dialprefix='18095' OR dialprefix='1809' OR dialprefix='180' OR dialprefix='18' OR dialprefix='1' OR dialprefix='defaultprefix') |
|---|
| 124 |
AND startingdate<= CURRENT_TIMESTAMP AND (expirationdate > CURRENT_TIMESTAMP OR expirationdate IS NULL OR LENGTH(expirationdate)<5) |
|---|
| 125 |
AND startdate<= CURRENT_TIMESTAMP AND (stopdate > CURRENT_TIMESTAMP OR stopdate IS NULL OR LENGTH(stopdate)<5) |
|---|
| 126 |
AND (starttime <= 6899 AND endtime >=6899) |
|---|
| 127 |
AND idtariffgroup='1' |
|---|
| 128 |
AND ( dnidprefix=SUBSTRING('18095673804',1,length(dnidprefix)) OR (dnidprefix='all' AND 0 = 0)) |
|---|
| 129 |
AND ( calleridprefix=SUBSTRING('8299518526',1,length(calleridprefix)) OR (calleridprefix='all' AND 0 = 0)) |
|---|
| 130 |
ORDER BY LENGTH(dialprefix) DESC |
|---|
| 131 |
] |
|---|
| 132 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:192]:[CallerID:8299518526]:[CN:5926325728]:[[rate-engine: Count Total result 2]] |
|---|
| 133 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:267]:[CallerID:8299518526]:[CN:5926325728]:[[CC_asterisk_rate-engine: Count Total result 1]] |
|---|
| 134 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:268]:[CallerID:8299518526]:[CN:5926325728]:[[CC_asterisk_rate-engine: number_trunk 1]] |
|---|
| 135 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:741]:[CallerID:8299518526]:[CN:5926325728]:[OK - RESFINDRATE::> 1] |
|---|
| 136 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:280]:[CallerID:8299518526]:[CN:5926325728]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT (300.00000)]] |
|---|
| 137 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:286]:[CallerID:8299518526]:[CN:5926325728]:[[CC_RATE_ENGINE_ALL_CALCULTIMEOUT: k=0 - res_calcultimeout:5280]] |
|---|
| 138 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:763]:[CallerID:8299518526]:[CN:5926325728]:[RES_ALL_CALCULTIMEOUT ::> 1] |
|---|
| 139 |
[04/07/2008 18:59:28]:[file:Class.A2Billing.php - line:780]:[CallerID:8299518526]:[CN:5926325728]:[TIMEOUT::> 5280 : minutes=88 - seconds=0] |
|---|
| 140 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:1012]:[CallerID:8299518526]:[CN:5926325728]:[app_callingcard: Dialing 'IAX2/ig729/992318095673804|60|HRgLC(5280000:61000:30000)' with timeout of '5280'. |
|---|
| 141 |
] |
|---|
| 142 |
[04/07/2008 18:59:28]:[file:Class.RateEngine.php - line:1037]:[CallerID:8299518526]:[CN:5926325728]:[app_callingcard: CIDGROUPID='-1' OUTBOUND CID SELECTED IS '0'.] |
|---|
| 143 |
[04/07/2008 18:59:40]:[file:Class.RateEngine.php - line:1042]:[CallerID:8299518526]:[CN:5926325728]:[DIAL IAX2/ig729/992318095673804|60|HRgLC(5280000:61000:30000)] |
|---|
| 144 |
[04/07/2008 18:59:40]:[file:Class.RateEngine.php - line:1143]:[CallerID:8299518526]:[CN:5926325728]:[[USEDRATECARD=0]] |
|---|
| 145 |
[04/07/2008 18:59:40]:[file:Class.RateEngine.php - line:875]:[CallerID:8299518526]:[CN:5926325728]:[[CC_RATE_ENGINE_UPDATESYSTEM: usedratecard K=0 - (sessiontime=0 :: dialstatus= :: buycost=0 :: cost= : signe_cc_call=-: signe=+)]] |
|---|
| 146 |
[04/07/2008 18:59:40]:[file:Class.RateEngine.php - line:899]:[CallerID:8299518526]:[CN:5926325728]:[[CC_asterisk_stop 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, buyrate, buycost, id_card_package_offer) VALUES ('1215212367.5', 'SIP/8299518526-095a35c8', '5926325728', '', CURRENT_TIMESTAMP - INTERVAL 0 SECOND , '0', '18095673804', '', now(), '3.4', '-0', '', '', 'distrito_nacional', '1', '1', '165', '2', '8299518526', '0', '1.26', '0', '0')]] |
|---|
| 147 |
[04/07/2008 18:59:40]:[file:Class.RateEngine.php - line:902]:[CallerID:8299518526]:[CN:5926325728]:[[CC_asterisk_stop 1.1: SQL: DONE : result=1]] |
|---|
| 148 |
[04/07/2008 18:59:40]:[file:a2billing.php - line:312]:[CallerID:8299518526]:[CN:5926325728]:[[a2billing account stop]] |
|---|
| 149 |
[04/07/2008 18:59:40]:[file:a2billing.php - line:172]:[CallerID:8299518526]:[CN:5926325728]:[[CHANNEL STATUS : -1 = There is no channel that matches SIP/8299518526-095a35c8]] |
|---|
| 150 |
[04/07/2008 18:59:40]:[file:a2billing.php - line:173]:[CallerID:8299518526]:[CN:5926325728]:[[CREDIT : 300.00000][CREDIT MIN_CREDIT_2CALL : 5.40]] |
|---|
| 151 |
[04/07/2008 18:59:40]:[file:Class.A2Billing.php - line:654]:[CallerID:8299518526]:[CN:5926325728]:[[CARD STATUS UPDATE : UPDATE cc_card SET inuse=inuse-1 WHERE username='5926325728']] |
|---|
| 152 |
[04/07/2008 18:59:40]:[CallerID:8299518526]:[CN:5926325728]:[[STOP - EXIT]] |
|---|
