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

<div class="row">
	<div class="col-md-12">
		<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">Debit</th>
			  <th class="report_fixed_value">Credit</th>
			  <th class="report_fixed_value">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>{{ d2_config('currency_symbol') }} <span>{{ opening_balance | number_format(2, '.', ' ') }}</span></td>
				  <td></td>
				  {% else %}
				  <td colspan="2"></td>
				  <td>{{ d2_config('currency_symbol') }} <span>{{ opening_balance | number_format(2, '.', ' ') | trim('-') }}</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 %}
					<a href="{{ path('invoices_show', { 'id': entity.getInvoice().getId() }) }}" title="View Invoice">{{ entity.getInvoiceNumber() | trim }}</a>
				  {% elseif entity.getCreditNoteNumber() is not empty %}
					<a href="{{ path('credit_notes_show', { 'id': entity.getCreditNote().getId() }) }}" title="View Credit Note">{{ entity.getCreditNoteNumber() | trim }}</a>
				  {% elseif entity.getDebitNoteNumber() is not empty %}
					<a href="{{ path('debit_notes_show', { 'id': entity.getDebitNote().getId() }) }}" title="View Debit Note">{{ entity.getDebitNoteNumber() | trim }}</a>
				  {% elseif entity.getPaymentCode() is not empty %}
					<a href="{{ path('payments_show', { 'id': entity.getPayment().getId() }) }}" title="View Payment">{{ entity.getPaymentCode() | trim }}</a>
				  {% elseif entity.getRefundCode() is not empty %}
					<a href="{{ path('refunds_show', { 'id': entity.getRefund().getId() }) }}" title="View Refund">{{ entity.getRefundCode() | trim }}</a>
				  {% endif %}
				</td>
				<td>{{ entity.getDescription() | trim }}</td>
				<td>
				  {% if entity.getInvoiceNumber() is not empty %}
					{{ d2_config('currency_symbol') }} <span class="red">{{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}</span>
					{% set cumulative_total = cumulative_total + entity.getTotal() %}
				  {% elseif entity.getDebitNoteNumber() is not empty %}
					{{ d2_config('currency_symbol') }} <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 %}
					{{ d2_config('currency_symbol') }} <span class="red">{{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}</span>
					{% set cumulative_total = cumulative_total + entity.getTotal() %}
				  {% endif %}
				</td>
				<td>
				  {% if entity.getCreditNoteNumber() is not empty %}
					{{ d2_config('currency_symbol') }} {{ entity.getTotal() | abs | number_format(2, '.', ' ') }}
					{% set cumulative_total = cumulative_total + entity.getTotal() %}
				  {% elseif entity.getPaymentCode() is not empty %}
					{{ d2_config('currency_symbol') }} {{ 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 %}
					{{ d2_config('currency_symbol') }} {{ entity.getTotal() | number_format(2, '.', ' ') | trim('-') }}
					{% set cumulative_total = cumulative_total + entity.getTotal() %}
				  {% endif %}
				</td>
				<td>{{ d2_config('currency_symbol') }} <span>{{ cumulative_total | number_format(2, '.', ' ') }}</span></td>
			  </tr>

			  {% if loop.last %}
				{% set closing_balance = opening_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>{{ d2_config('currency_symbol') }} <span>{{ closing_balance | abs | number_format(2, '.', ' ') }}</span></td>
				  <td></td>
				  {% else %}
				  <td colspan="2"></td>
				  <td>{{ d2_config('currency_symbol') }} <span>{{ closing_balance | number_format(2, '.', ' ') | trim('-') }}</span></td>
				  <td colspan="2"></td>
				  {% endif %}
				</tr>
			  {% endif %}
			{% endfor %}

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

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