[Spce-user] Fwd: ngcp-fraud-auto-lock

Alejandro Sanchez Gimenez alesg at coit.es
Thu Mar 21 18:14:44 EDT 2013


Hi again Richard!! 


I´ve checked accounting.cdr table and source_account_id field of the contains 22, and the customer_cost field contains the cost. Here you can see the query with relevant data: 



mysql> select * from cdr where source_account_id like "22"\G; 
*************************** 1. row *************************** 
id: 52 
update_time: 2013-03-21 15:03:32 
source_user_id: 635a08f3-3df3-4559-a6fd-d5e280d9761e 
source_provider_id: 1 
source_external_subscriber_id: XXXXXXXX 
source_external_contract_id: 
source_account_id: 22 
source_user: XXXXXXXXX 
source_domain: xxx.xxx.es 
source_cli: 34XXXXXXXXX 
source_clir: 0 
source_ip: 192.168.0.24 
destination_user_id: 43317f99-0859-4e89-a63b-ddf3d9bffb20 
destination_provider_id: 1 
destination_external_subscriber_id: XXXXXXXXX 
destination_external_contract_id: XXXXX 
destination_account_id: 8 
destination_user: XXXXXXXXX 
destination_domain: xxx.xxx.es 
destination_user_dialed: XXXXXXXXX 
destination_user_in: XXXXXXXXX 
destination_domain_in: xxx.xxx.es 
peer_auth_user: 
peer_auth_realm: 
call_type: call 
call_status: ok 
call_code: 200 
init_time: 1363874581.577 
start_time: 1363874584.840 
duration: 15.680 
call_id: OWIzN2RmY2M5M2RlMmFmMWU1MzVhNzkyNTVkNzI2YmM. 
carrier_cost: 0.00 
reseller_cost: 0.00 
customer_cost: 16.50 
carrier_free_time: 0 
reseller_free_time: 0 
customer_free_time: 0 
carrier_billing_fee_id: NULL 
reseller_billing_fee_id: NULL 
customer_billing_fee_id: 7 
carrier_billing_zone_id: NULL 
reseller_billing_zone_id: NULL 
customer_billing_zone_id: 7 
frag_carrier_onpeak: NULL 
frag_reseller_onpeak: NULL 
frag_customer_onpeak: NULL 
is_fragmented: NULL 
split: 0 
rated_at: 2013-03-21 15:03:32 
rating_status: ok 
exported_at: NULL 
export_status: unexported 


Jon, I paste the query with \G: 



mysql> select * from contracts where id = 22\G; 
*************************** 1. row *************************** 
id: 22 
customer_id: NULL 
reseller_id: 1 
contact_id: NULL 
order_id: NULL 
status: active 
external_id: 
modify_timestamp: 2013-03-21 15:02:14 
create_timestamp: 2013-03-21 15:02:14 
activate_timestamp: 2013-03-21 15:02:14 
terminate_timestamp: NULL 
1 row in set (0.00 sec) 


mysql> select * from contract_balances where contract_id = 22\G; 
*************************** 1. row *************************** 
id: 21 
contract_id: 22 
cash_balance: 0 
cash_balance_interval: 0 
free_time_balance: 0 
free_time_balance_interval: 0 
start: 2013-03-01 00:00:00 
end: 2013-03-31 23:59:59 
invoice_id: NULL 
1 row in set (0.00 sec) 


mysql> select * from billing.billing_mappings m, billing.billing_profiles p 
-> where p.id = m.billing_profile_id and m.contract_id = 22\G; 
*************************** 1. row *************************** 
id: 22 
start_date: NULL 
end_date: NULL 
billing_profile_id: 4 
contract_id: 22 
product_id: NULL 
id: 4 
reseller_id: 1 
handle: Tarifa_plana 
name: Tarifa plana 
prepaid: 0 
interval_charge: 0 
interval_free_time: 0 
interval_free_cash: 0 
interval_unit: month 
interval_count: 1 
fraud_interval_limit: 100 
fraud_interval_lock: 3 
fraud_interval_notify: 
fraud_daily_limit: 100 
fraud_daily_lock: 3 
fraud_daily_notify: NULL 
currency: ⬠
vat_rate: 0 
vat_included: 0 
1 row in set (0.00 sec) 


Thank you very much!! 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130321/df7f1dc7/attachment-0001.html>


More information about the Spce-user mailing list