[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