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

[Alejandro Sanchez Gimenez]

Hello Richard, 


this is what I get: 



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




mysql> select * from contract_balances where contract_id = 22; 
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+ 
| id | contract_id | cash_balance | cash_balance_interval | free_time_balance | free_time_balance_interval | start | end | invoice_id | 
+----+-------------+--------------+-----------------------+-------------------+----------------------------+---------------------+---------------------+------------+ 
| 21 | 22 | 0 | 0 | 0 | 0 | 2013-03-01 00:00:00 | 2013-03-31 23:59:59 | 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; 
+----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+ 
| id | start_date | end_date | billing_profile_id | contract_id | product_id | id | reseller_id | handle | name | prepaid | interval_charge | interval_free_time | interval_free_cash | interval_unit | interval_count | fraud_interval_limit | fraud_interval_lock | fraud_interval_notify | fraud_daily_limit | fraud_daily_lock | fraud_daily_notify | currency | vat_rate | vat_included | 
+----+------------+----------+--------------------+-------------+------------+----+-------------+--------------+--------------+---------+-----------------+--------------------+--------------------+---------------+----------------+----------------------+---------------------+-------------------------------+-------------------+------------------+--------------------+----------+----------+--------------+ 
| 22 | NULL | NULL | 4 | 22 | NULL | 4 | 1 | Tarifa_plana | Tarifa plana | 0 | 0 | 0 | 0 | month | 1 | 100 | 3 | | 100 | 3 | NULL | ⬠| 0 | 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/c59db2c1/attachment-0001.html>