{% set period_end_date = '' %}
{% set closing_balance = 0 %}
{% set cumulative_total = 0 %}

{% for key, period_entity in periods_data %}
<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 period_entity[1] %}
				{% set period_start_date = key %}
				{% set period_end_date   = period_entity[0] %}
				{% if loop.first %}
				  <tr>
					{% set opening_balance = opening_balance + cumulative_total %}
					<td colspan="2">Opening balance as at {{ period_start_date | 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.description | 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 %}
				  <tr>
					<td colspan="2">Closing balance as at {{ period_end_date | 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 />
	</div>
</div>
{% endfor %}

<div class="row">
	<div class="col-md-12">
		<table class="table table-condensed record_list report_fixed_table">
		  <tbody>
			<tr>
			  <th colspan="3">TOTAL CLOSING BALANCE AS AT {{ period_end_date | date('Y-m-d') }}</th>
			  {% if cumulative_total <= 0 %}
			  <td colspan="4"></td>
			  <th>{{ 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 class="red">{{ cumulative_total | number_format(2, '.', ' ') | trim('-') }}</span></th>
			  <td colspan="2"></td>
			  {% endif %}
			</tr>
		  </tbody>
		</table>
	</div>
</div>