{% set cumulative_total = opening_balance %}
{% set end_date = '' %}

<table class="table table-condensed report_fixed_table">
  <thead>
    <tr>
      <th class="report_fixed_value">Date</th>
      <th class="report_fixed_value">Entry Type</th>
      <th class="report_fixed_value">Reference</th>
      <th>Description</th>
      <th class="report_fixed_value" style="text-align:right">Debit</th>
      <th class="report_fixed_value" style="text-align:right">Credit</th>
      <th class="report_fixed_value" style="text-align:right">Cumulative</th>
    </tr>
  </thead>
  <tbody>

    {% for entity in transactions_data %}
      {% if loop.first %}
        <tr>
          <td colspan="2">Opening balance as at {{ entity.getDate() | date('Y-m-d') }}</td>
          {% if opening_balance <= 0 %}
          <td colspan="3"></td>
          <td style="text-align:right"><span>{{ opening_balance | abs | number_format(2, '.', ' ') }}</span></td>
          <td></td>
          {% else %}
          <td colspan="2"></td>
          <td style="text-align:right"><span>{{ opening_balance | abs |number_format(2, '.', ' ') }}</span></td>
          <td colspan="2"></td>
          {% endif %}
        </tr>
      {% endif %}

      <tr>
        <td>{{ entity.getDate() | date('Y-m-d') }}</td>
        <td>
          {% if entity.getInvoiceNumber() is not empty %}
            Tax Invoice
          {% elseif entity.getCreditNoteNumber() is not empty %}
            Credit Note
          {% elseif entity.getDebitNoteNumber() is not empty %}
            Debit Note
          {% elseif entity.getPaymentCode() is not empty %}
            Payment
          {% elseif entity.getRefundCode() is not empty %}
            Refund
          {% else %}
            Transaction
          {% endif %}
        </td>
        <td>
            {% if entity.getInvoiceNumber() is not empty %}
				{% if show_links %}
					<a href="{{ path('invoices_show', { 'id': entity.getInvoice().getId() }) }}" title="View Invoice">{{ entity.getInvoiceNumber() | trim }}</a>
				{% else %}
					{{ entity.getInvoiceNumber() | trim }}
				{% endif %}
            {% elseif entity.getCreditNoteNumber() is not empty %}
				{% if show_links %}
					<a href="{{ path('credit_notes_show', { 'id': entity.getCreditNote().getId() }) }}" title="View Credit Note">{{ entity.getCreditNoteNumber() | trim }}</a>
				{% else %}
					{{ entity.getCreditNoteNumber() | trim }}
				{% endif %}
            {% elseif entity.getDebitNoteNumber() is not empty %}
				{% if show_links %}
					<a href="{{ path('debit_notes_show', { 'id': entity.getDebitNote().getId() }) }}" title="View Debit Note">{{ entity.getDebitNoteNumber() | trim }}</a>
				{% else %}
					{{ entity.getDebitNoteNumber() | trim }}
				{% endif %}
            {% elseif entity.getPaymentCode() is not empty %}
				{% if show_links %}
					<a href="{{ path('payments_show', { 'id': entity.getPayment().getId() }) }}" title="View Payment">{{ entity.getPaymentCode() | trim }}</a>
				{% else %}
					{{ entity.getPaymentCode() | trim }}
				{% endif %}
            {% elseif entity.getRefundCode() is not empty %}
				{% if show_links %}
					<a href="{{ path('refunds_show', { 'id': entity.getRefund().getId() }) }}" title="View Refund">{{ entity.getRefundCode() | trim }}</a>
				{% else %}
					{{ entity.getRefundCode() | trim }}
				{% endif %}
            {% endif %}
        </td>
        <td>{{ entity.getDescription() | trim }}</td>
        <td style="text-align:right">
          {% if entity.getInvoiceNumber() is not empty %}
            <span class="red">{{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}</span>
            {% set cumulative_total = cumulative_total + entity.getTotal() %}
          {% elseif entity.getDebitNoteNumber() is not empty %}
            <span class="red">{{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}</span>
            {% set cumulative_total = cumulative_total + entity.getTotal() %}
          {% elseif entity.getTotal() >= 0 and entity.getCreditNoteNumber() is empty and entity.getPaymentCode() is empty %}
            <span class="red">{{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}</span>
            {% set cumulative_total = cumulative_total + entity.getTotal() %}
          {% endif %}
        </td>
        <td style="text-align:right">
          {% if entity.getCreditNoteNumber() is not empty %}
            {{ entity.getTotal() | abs | number_format(2, '.', ' ') }}
            {% set cumulative_total = cumulative_total + entity.getTotal() %}
          {% elseif entity.getPaymentCode() is not empty %}
            {{ entity.getTotal() | abs | number_format(2, '.', ' ') }}
            {% set cumulative_total = cumulative_total + entity.getTotal() %}
          {% elseif entity.getTotal() < 0 and entity.getInvoiceNumber() is empty and entity.getDebitNoteNumber() is empty %}
            {{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}
            {% set cumulative_total = cumulative_total + entity.getTotal() %}
          {% endif %}
        </td>
        <td style="text-align:right"><span>{{ cumulative_total | number_format(2, '.', ' ') }}</span></td>
      </tr>

      {% if loop.last %}
        {% set closing_balance = cumulative_total %}
        {% set end_date = entity.getDate() %}
        <tr>
          <td colspan="2">Closing balance as at {{ entity.getDate() | date('Y-m-d') }}</td>
          {% if closing_balance <= 0 %}
          <td colspan="3"></td>
          <td style="text-align:right"><span>{{ closing_balance | abs | number_format(2, '.', ' ') }}</span></td>
          <td></td>
          {% else %}
          <td colspan="2"></td>
          <td style="text-align:right"><span>{{ closing_balance | number_format(2, '.', ' ') | trim('-') }}</span></td>
          <td colspan="2"></td>
          {% endif %}
        </tr>
      {% endif %}
    {% endfor %}

  </tbody>
</table>
<br /><br />

<table class="record_list report_fixed_table">
  <tbody>
    <tr>
      <td colspan="2">TOTAL CLOSING BALANCE AS AT {{ end_date | date('Y-m-d') }}</td>
      {% if cumulative_total <= 0 %}
      <td colspan="2"></td>
      <td class="report_fixed_value"> </td>
      <td class="report_fixed_value"><span>{{ cumulative_total | abs | number_format(2, '.', ' ') }}</span></td>
      <td class="report_fixed_value"> </td>
      {% else %}
      <td colspan="2"></td>
      <td class="report_fixed_value"><span>{{ cumulative_total | number_format(2, '.', ' ') | trim('-') }}</span></td>
      <td class="report_fixed_value"> </td>
      <td class="report_fixed_value"> </td>
      {% endif %}
    </tr>
  </tbody>
</table>