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

[Richard Fuchs]

There's a problem with the ratings, the contract_balances don't show any
charges being made to the account, everything is zero. If the CDRs are
rated correctly, then the association between calling subscriber and
account must be incorrect. Check the source_account_id field of the
CDRs, it should contain 22, and the customer_cost field should contain
the cost.

BR


On 03/21/13 15:00, Alejandro Sanchez Gimenez wrote:
> 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!!!
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 900 bytes
Desc: OpenPGP digital signature
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20130321/d2ec5288/attachment-0001.asc>