<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>Dear Irina,</p>
    <p>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?</p>
    <p>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.<br>
    </p>
    Best regards,<br>
    Henk Plessius<br>
    <br>
    <div class="moz-cite-prefix">On 19-1-2017 9:31, Henk wrote:<br>
    </div>
    <blockquote
      cite="mid:1c10f807-3327-28f8-fb46-86998e70c28b@voipdigit.nl"
      type="cite">
      <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
      <p>Dear Irina,</p>
      <p>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.</p>
      <p>Best regards,</p>
      <p>Henk Plessius  <br>
      </p>
      <br>
      On 18-1-2017 17:25, Irina Peshinskaya wrote:<br>
      <blockquote
        cite="mid:9245581a-81e9-8425-65b1-78a11fa81886@sipwise.com"
        type="cite">
        <meta content="text/html; charset=utf-8"
          http-equiv="Content-Type">
        <p>Dear Henk,<br>
        </p>
        Could you please describe what do you mean by "manually"
        generated invoices? <br>
        Did you use WEB interface for this? <br>
        <br>
        Thanks in advance.<br>
        <br>
        Best regards,<br>
        Irina Peshinskaya<br>
        <br>
        <br>
        <div class="moz-cite-prefix">On 15.01.2017 19:56, Henk wrote:<br>
        </div>
        <blockquote
          cite="mid:08108fa6-4ade-8db9-5e27-760fe4f6d6c0@voipdigit.nl"
          type="cite">
          <meta content="text/html; charset=utf-8"
            http-equiv="Content-Type">
          <p>Sorry, that format wasn't working. I hope this will be more
            readable<br>
          </p>
          I'm on mr5.0.1.1 and have the wrong billing profile on my
          (manually) generated invoices from january.<br>
          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.<br>
          <br>
          From the sql query log:<br>
          <br>
          select * FROM billing_mappings <br>
                  where contract_id = '17' <br>
                      and (billing_mappings.start_date <=
          '1485903599' OR billing_mappings.start_date is null)<br>
                      and (billing_mappings.end_date >= '1483225200'
          OR billing_mappings.end_date is null)<br>
                  order by billing_mappings.start_date desc,
          billing_mappings.id desc limit 1<br>
          <br>
          If I add from_unixtime it's working and I get the right one:<br>
          <br>
          select * FROM billing_mappings <br>
                  where contract_id = '17' <br>
                      and (billing_mappings.start_date <= <code
            class="sql">from_unixtime(</code>'1485903599') OR
          billing_mappings.start_date is null)<br>
                      and (billing_mappings.end_date >= <code
            class="sql">from_unixtime(</code>'1483225200') OR
          billing_mappings.end_date is null)<br>
                  order by billing_mappings.start_date desc,
          billing_mappings.id desc limit 1<br>
          <br>
          Maybe this is related to MariaDB?<br>
          <br>
          Regards,<br>
          <br>
          Henk Plessius<br>
          <br>
          <fieldset class="mimeAttachmentHeader"></fieldset>
          <br>
          <pre wrap="">_______________________________________________
Spce-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Spce-user@lists.sipwise.com">Spce-user@lists.sipwise.com</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.sipwise.com/listinfo/spce-user">https://lists.sipwise.com/listinfo/spce-user</a>
</pre>
        </blockquote>
        <br>
      </blockquote>
      <br>
    </blockquote>
    <br>
  </body>
</html>