[Spce-user] Wrong billing profile

[Henk]

Dear Irina,

I checked again and it's working from the UI. But I didn't got any 
warning from the script and also the monthly cron job is not removed 
during upgrade. Can you tell me where to find this in the release notes?

But manually generating invoices is not a problem for me. The only thing 
that irritates a little is that the downloaded invoice doesn't have a 
pdf extension (using firefox), so I always have to rename it before opening.

Best regards,
Henk Plessius

On 19-1-2017 9:31, Henk wrote:
>
> 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/20170120/f5686b91/attachment-0001.html>