[Spce-user] Wrong billing profile

[Henk]

Dear Irina,

Thank you for having a look at this. I used the script as specified in 
the cron job (/usr/share/ngcp-panel/tools/generate_invoices.pl) to try 
to generate some debugging info, without much success. That's the reason 
I analyzed this further with the SQL debug log. But I think the web 
interface produces the same results. I temporary solved the issue by 
setting the startdate to NULL.

Best regards,

Henk Plessius


On 18-1-2017 17:25, Irina Peshinskaya wrote:
>
> Dear Henk,
>
> Could you please describe what do you mean by "manually" generated 
> invoices?
> Did you use WEB interface for this?
>
> Thanks in advance.
>
> Best regards,
> Irina Peshinskaya
>
>
> On 15.01.2017 19:56, Henk wrote:
>>
>> Sorry, that format wasn't working. I hope this will be more readable
>>
>> I'm on mr5.0.1.1 and have the wrong billing profile on my (manually) 
>> generated invoices from january.
>> After some research I found the date selection on billing_mappings 
>> isn't working. The start_date is 10-1-2017. Only the records with 
>> start_date NULL are selected.
>>
>> From the sql query log:
>>
>> select * FROM billing_mappings
>>         where contract_id = '17'
>>             and (billing_mappings.start_date <= '1485903599' OR 
>> billing_mappings.start_date is null)
>>             and (billing_mappings.end_date >= '1483225200' OR 
>> billing_mappings.end_date is null)
>>         order by billing_mappings.start_date desc, 
>> billing_mappings.id desc limit 1
>>
>> If I add from_unixtime it's working and I get the right one:
>>
>> select * FROM billing_mappings
>>         where contract_id = '17'
>>             and (billing_mappings.start_date <= 
>> |from_unixtime(|'1485903599') OR billing_mappings.start_date is null)
>>             and (billing_mappings.end_date >= 
>> |from_unixtime(|'1483225200') OR billing_mappings.end_date is null)
>>         order by billing_mappings.start_date desc, 
>> billing_mappings.id desc limit 1
>>
>> Maybe this is related to MariaDB?
>>
>> Regards,
>>
>> Henk Plessius
>>
>>
>> _______________________________________________
>> Spce-user mailing list
>> Spce-user at lists.sipwise.com
>> https://lists.sipwise.com/listinfo/spce-user
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20170119/289dcba5/attachment-0001.html>