[%- USE T8 %]
[%- USE LxERP %]
[%- USE L %]
[%- USE HTML %]

<div id="sales_report">
  <table width="100%">
    <caption class="listtop">[%- HTML.escape(title) %]</caption>
    <tbody>
      <tr>
        <td class="listheading">[% 'Type' | $T8 %]</td>
        <td class="listheading">[% 'Invoice Number' | $T8 %]</td>
        <td class="listheading">[% 'Invoice Date' | $T8 %]</td>
        <td class="listheading">[% 'Amount' | $T8 %]</td>
        <td class="listheading">[% 'Inv. Duedate' | $T8 %]</td>
        <td class="listheading">[% 'Paid' | $T8 %]</td>
        <td class="listheading">[% 'Open Amount' | $T8 %]</td>
        [% IF FORM.db == 'customer' %]
          <td class="listheading">[% 'Dunnings (Id -- Dunning Date --Dunning Level -- Dunning Fee)' | $T8 %]</td>
        [% END %]
      </tr>

      [%- FOREACH row = OPEN_ITEMS %]
        [% IF FORM.db == 'customer' %]
          [% IF row.type == 'invoice' %]
            [% SET type = 'Invoice (one letter abbreviation)' %]
            [% SET link = 'is.pl' %]
          [% ELSIF row.type == 'credit_note' %]
            [% SET type = 'Credit note (one letter abbreviation)' %]
            [% SET link = 'is.pl' %]
          [% ELSE %]
            [% SET type = 'AR Transaction (abbreviation)' %]
            [% SET link = 'ar.pl' %]
          [% END %]
        [% ELSE %]
          [% IF row.invoice %]
            [% SET type = 'Invoice (one letter abbreviation)' %]
            [% SET link = 'ir.pl' %]
          [% ELSE %]
            [% SET type = 'AP Transaction (abbreviation)' %]
            [% SET link = 'ap.pl' %]
          [% END %]
        [% END %]
        <tr class="listrow[% loop.count % 2 %]">
          <td>[% type | $T8 %]</td>
          <td><a href="[% link %]?action=edit&id=[% row.id %]">[% row.invnumber | html %]</a></td>
          <td>[% row.transdate.to_kivitendo | html %]</td>
          <td class="numeric">[%- LxERP.format_amount(row.amount, 2) %]</td>
          <td>[% row.duedate.to_kivitendo | html %]</td>
          <td class="numeric">[%- LxERP.format_amount(row.paid, 2) %]</td>
          <td class="numeric">[%- LxERP.format_amount(row.amount - row.paid,2) %]
          [% IF FORM.db == 'customer' %]
            <td>
            [%- IF row.dunning_config_id != '' %]
              [%- FOREACH dun = row.dunnings %]
              [% dun.dunning_id | html %] -- [% dun.transdate.to_kivitendo | html %] -- [% dun.dunning_level | html %] -- [%- LxERP.format_amount(dun.fee, 2) %]<br>
              [% END %]
            [% END %]
            </td>
          [% END %]
        </tr>
      [% END %]
    </tbody>
  </table>
</div>