[Spce-user] free time configuration

Andrew Pogrebennyk apogrebennyk at sipwise.com
Mon Jan 9 11:37:02 EST 2012


That is the problem - for some reason you have two contract_balances
records with period from=2012-01-01 to=2012-01-31. It should not be
possible to create such duplicates with spce, if you find a way to do
that please let me know. For now just remove one record from the DB and
keep the correct one.

I guess the correct one has cash_balance: 5000, in that case execute
mysql biling -e "delete from contract_balances where id=9;"
The admin panel should display correct data after that. And you can
check if the billing works as expected.

On 01/09/2012 05:31 PM, Jayesh Labade wrote:
> Hello Andrew,
> 
> This is output..
> 
> *************************** 1. row ***************************
>                         id: 2
>                contract_id: 3
>               cash_balance: 0
>      cash_balance_interval: 0
>          free_time_balance: 0
> free_time_balance_interval: 0
>                      start: 2011-12-01 00:00:00
>                        end: 2011-12-31 23:59:59
>                 invoice_id: NULL
> *************************** 2. row ***************************
>                         id: 7
>                contract_id: 3
>               cash_balance: 0
>      cash_balance_interval: 0
>          free_time_balance: 0
> free_time_balance_interval: 0
>                      start: 2012-01-01 00:00:00
>                        end: 2012-01-31 00:00:00
>                 invoice_id: NULL
> *************************** 3. row ***************************
>                         id: 9
>                contract_id: 3
>               cash_balance: 5000
>      cash_balance_interval: 0
>          free_time_balance: 112
> free_time_balance_interval: 0
>                      start: 2012-01-01 00:00:00
>                        end: 2012-01-31 23:59:59
>                 invoice_id: NULL
> 
> 
> Best Regards,
> *Jayesh Labade*
> e-mail: jayesh.labade at gmail.com <mailto:jayesh.labade at gmail.com>
> 




More information about the Spce-user mailing list