{% set _base_url = (_base_url is defined ? _base_url : asset('')) %}
{% set terms_type = 'monthly' %}
{% set cur_sym = d2_config('currency_symbol') %}
<div class="row" style="margin-top:20px">
	<div class="col-md-12">
		<table class="table table-condensed report_fixed_table no_border">
		  <tbody>
			<tr>
			  <td class="no_border"><!-- row 1, col 1 -->

				<table class="table table-condensed table-bordered report_fixed_table">
				  <thead>
					<tr>
					  <th class="report_fixed_value">Date</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>
					</tr>
				  </thead>
				  <tbody>

					{% if account_entity is empty %}
					  <tr><td colspan="5" class="light_grey">nothing to display</td></tr>
					{% else %}
					  {% for entity in account_entity %}
						{% include 'D2BillingBundle:StatementReport:list.itemDetails.html.twig' with {'entity': entity} %}
						{% if account_missing[account_name] is defined and account_missing[account_name][entity.getId()] is defined and account_missing[account_name][entity.getId()] is not empty %}
						  {% for missing_entity in account_missing[account_name][entity.getId()] %}
							{% include 'D2BillingBundle:StatementReport:list.itemDetails.html.twig' with {'entity': missing_entity, 'missing': 1} %}
						  {% endfor %}
						{% endif %}
					  {% endfor %}
					{% endif %}

				  </tbody>
				</table>

			  </td>
			  <td class="report_fixed_summary no_border"><!-- row 1, col 2 -->

				<table class="table table-condensed table-bordered report_fixed_table">
				  <thead>
					<tr>
					  <th class="report_fixed_value">Date</th>
					  <th class="report_fixed_value">Reference</th>
					  <th class="report_fixed_value">Amount</th>
					</tr>
				  </thead>
				  <tbody>

					<!-- make amount vars -->
					{% set amount_paid = 0 %}
					{% set amount_due = 0 %}

					{% if account_entity is empty %}
					  <tr><td colspan="3" class="light_grey">nothing to display</td></tr>
					{% else %}
					  {% for entity in account_entity %}
						{% set terms_type = entity.getAccount().getSettings().getTerms() | lower %}
						<tr>
						  <td>{{ entity.getDate() | date('Y-m-d') }}</td>
						  <td>
							{% if entity.getInvoiceNumber() is not empty %}
							  {% if show_links %}
							   {% if is_granted('ROLE_ADMIN_SALES_VIEW') %} <a href="{{ path('invoices_show', { 'id': entity.getInvoice().getId() }) }}" title="View Invoice"> {% endif %}
							   {{ entity.getInvoiceNumber() | trim }}
							   {% if is_granted('ROLE_ADMIN_SALES_VIEW') %}</a> {% endif %}
							  {% else %}
								{{ entity.getInvoiceNumber() | trim }}
							  {% endif %}
							{% elseif entity.getCreditNoteNumber() is not empty %}
							  {% if show_links %}
								{% if is_granted('ROLE_ADMIN_SALES_VIEW') %}<a href="{{ path('credit_notes_show', { 'id': entity.getCreditNote().getId() }) }}" title="View Credit Note"> {% endif %}
								{{ entity.getCreditNoteNumber() | trim }}
								{% if is_granted('ROLE_ADMIN_SALES_VIEW') %}</a> {% endif %}
							  {% else %}
								{{ entity.getInvoiceNumber() | trim }}
							  {% endif %}
							{% elseif entity.getDebitNoteNumber() is not empty %}
							  {% if show_links %}
								{% if is_granted('ROLE_ADMIN_SALES_VIEW') %}<a href="{{ path('debit_notes_show', { 'id': entity.getDebitNote().getId() }) }}" title="View Debit Note"> {% endif %}
								{{ entity.getDebitNoteNumber() | trim }}
								{% if is_granted('ROLE_ADMIN_SALES_VIEW') %}</a> {% endif %}
							  {% else %}
								{{ entity.getDebitNoteNumber() | trim }}
							  {% endif %}
							{% elseif entity.getPaymentCode() is not empty %}
							  {% if show_links %}
								{% if is_granted('ROLE_ADMIN_PAYMENT_VIEW') %}<a href="{{ path('payments_show', { 'id': entity.getPayment().getId() }) }}" title="View Payment"> {% endif %}
								{{ entity.getPaymentCode() | trim }}
								{% if is_granted('ROLE_ADMIN_PAYMENT_VIEW') %}</a> {% endif %}
							  {% else %}
								{{ entity.getPaymentCode() | trim }}
							  {% endif %}
							{% elseif entity.getRefundCode() is not empty %}
							  {% if show_links %}
								{% if is_granted('ROLE_ADMIN_REFUND_VIEW') %}<a href="{{ path('refunds_show', { 'id': entity.getRefund().getId() }) }}" title="View Refund"> {% endif %}
								{{ entity.getRefundCode() | trim }}
								{% if is_granted('ROLE_ADMIN_REFUND_VIEW') %}</a> {% endif %}
							  {% else %}
								{{ entity.getRefundCode() | trim }}
							  {% endif %}
							{% endif %}
						  </td>
						  <td>
							{% if entity.getInvoiceNumber() is not empty %}
							  {{ cur_sym }} <span{% if entity.getTotal() > 0 %} class="red"{% endif %}>{{ entity.getTotal() | abs | number_format(2, '.', ' ') }}</span>
							  {% set amount_due = amount_due + entity.getTotal() %}
							{% elseif entity.getDebitNoteNumber() is not empty %}
							  {{ cur_sym }} <span{% if entity.getTotal() > 0 %} class="red"{% endif %}>{{ entity.getTotal() | abs | number_format(2, '.', ' ') }}</span>
							  {% set amount_due = amount_due + entity.getTotal() %}
							{% elseif entity.getCreditNoteNumber() is not empty %}
							  {{ cur_sym }} {{ entity.getTotal() | number_format(2, '.', ' ') }}
							  {% set amount_paid = amount_paid + entity.getTotal() %}
							{% elseif entity.getPaymentCode() is not empty %}
							  {{ cur_sym }} {{ entity.getTotal() | number_format(2, '.', ' ') }}
							  {% set amount_paid = amount_paid + entity.getTotal() %}
							{% elseif entity.getTotal() >= 0 %}
							  {{ cur_sym }} <span class="red">{{ entity.getTotal() | abs | number_format(2, '.', ' ') }}</span>
							  {% set amount_due = amount_due + entity.getTotal() %}
							{% elseif entity.getTotal() < 0 %}
							  {{ cur_sym }} {{ entity.getTotal() | number_format(2, '.', ' ') }}
							  {% set amount_paid = amount_paid + entity.getTotal() %}
							{% endif %}
						  </td>
						</tr>
					  
						{% if account_missing[account_name] is defined and account_missing[account_name][entity.getId()] is defined and account_missing[account_name][entity.getId()] is not empty %}
						  {% for missing_entity in account_missing[account_name][entity.getId()] %}
							<tr>
							  <td><span class="red">{{ missing_entity.getDate() | date('Y-m-d') }}</span></td>
							  <td>
								{% if missing_entity.getInvoiceNumber() is not empty %}
								  {% if show_links %}
									<a href="{{ path('invoices_show', { 'id': missing_entity.getInvoice().getId() }) }}" title="View Invoice">{{ missing_entity.getInvoiceNumber() | trim }}</a>
								  {% else %}
									{{ missing_entity.getInvoiceNumber() | trim }}
								  {% endif %}                                
								{% elseif missing_entity.getCreditNoteNumber() is not empty %}
								  {% if show_links %}
									<a href="{{ path('credit_notes_show', { 'id': missing_entity.getCreditNote().getId() }) }}" title="View Credit Note">{{ missing_entity.getCreditNoteNumber() | trim }}</a>
								  {% else %}
									{{ missing_entity.getCreditNoteNumber() | trim }}
								  {% endif %}                                
								{% elseif missing_entity.getDebitNoteNumber() is not empty %}
								  {% if show_links %}
									<a href="{{ path('debit_notes_show', { 'id': missing_entity.getDebitNote().getId() }) }}" title="View Debit Note">{{ missing_entity.getDebitNoteNumber() | trim }}</a>
								  {% else %}
									{{ missing_entity.getDebitNoteNumber() | trim }}
								  {% endif %}                                
								{% elseif missing_entity.getPaymentCode() is not empty %}
								  {% if show_links %}
									<a href="{{ path('payments_show', { 'id': missing_entity.getPayment().getId() }) }}" title="View Payment">{{ missing_entity.getPaymentCode() | trim }}</a>
								  {% else %}
									{{ missing_entity.getPaymentCode() | trim }}
								  {% endif %}                                
								{% elseif missing_entity.getRefundCode() is not empty %}
								  {% if show_links %}
									<a href="{{ path('refunds_show', { 'id': missing_entity.getRefund().getId() }) }}" title="View Refund">{{ missing_entity.getRefundCode() | trim }}</a>
								  {% else %}
									{{ missing_entity.getRefundCode() | trim }}
								  {% endif %}                                
								{% endif %}
							  </td>
							  <td>
								{% if missing_entity.getInvoiceNumber() is not empty %}
								  {{ cur_sym }} <span>{{ missing_entity.getTotal() | number_format(2, '.', ' ') }}</span>
								  {% set amount_due = amount_due + missing_entity.getTotal() %}
								{% elseif missing_entity.getDebitNoteNumber() is not empty %}
								  {{ cur_sym }} <span>{{ missing_entity.getTotal() | number_format(2, '.', ' ')  }}</span>
								  {% set amount_due = amount_due + missing_entity.getTotal() %}
								{% elseif missing_entity.getCreditNoteNumber() is not empty %}
								  {{ cur_sym }} {{ missing_entity.getTotal() | number_format(2, '.', ' ') }}
								  {% set amount_paid = amount_paid + missing_entity.getTotal() %}
								{% elseif missing_entity.getPaymentCode() is not empty %}
								  {{ cur_sym }} {{ missing_entity.getTotal() | number_format(2, '.', ' ') }}
								  {% set amount_paid = amount_paid + missing_entity.getTotal() %}
								{% endif %}
							  </td>
							</tr>
						  {% endfor %}
						{% endif %}
					  {% endfor %}
					{% endif %}
				  </tbody>
				</table>

			  </td>
			</tr>
			<tr class="statement_footer">
			  <td class="no_border ageing"><!-- row 2, col 1 -->

				{% set amount_due_all_time = 0 %}
				{% set amount_due = amount_due + amount_paid %}

				<table class="table table-condensed table-bordered report_fixed_table">
				  <thead>
					<tr>
					  <th></th>
					  {% if terms_type == 'monthly' %}
						<th></th>
						
						<th>120 Days</th>

						<th>90 Days</th>

						<th>60 Days</th>

						<th>30 Days</th>

						<th>Current</th>
					  {% else %}
						<th>70 Days</th>

						<th>56 Days</th>

						<th>42 Days</th>

						<th>28 Days</th>

						<th>14 Days</th>

						<th>Current</th>
					  {% endif %}
					  
					</tr>
				  </thead>
				  <tbody>

					{% for entity_age in account_ages[account_name] %}
					  {% set amount_due_all_time = entity_age.total_current %}
					  <tr>
						<td></td>
						<td>
						  {% if entity_age.total_70 is defined %}
						  {{ cur_sym }} <span>{{ entity_age.total_70 | number_format(2, '.', ' ') }}</span>
						  {% endif %}
						</td>
						<td>
						  {{ cur_sym }} <span>{{ entity_age.total_120 | number_format(2, '.', ' ') }}</span>
						</td>
						
						<td>
						  {{ cur_sym }} <span>{{ entity_age.total_90 | number_format(2, '.', ' ') }}</span>
						</td>

						<td>
						  {{ cur_sym }} <span>{{ entity_age.total_60 | number_format(2, '.', ' ') }}</span>
						</td>

						<td>
						  {{ cur_sym }} <span>{{ entity_age.total_30 | number_format(2, '.', ' ') }}</span>
						</td>

						<td>{{ cur_sym }} <span>{{ entity_age.total_current | number_format(2, '.', ' ') }}</span></td>
					  </tr>
					{% endfor %}

					<tr>
					  <td colspan="5"></td>
					  <td><b>Total Due:</b></td>
					  <td>{{ cur_sym }} <span>{{ amount_due | number_format(2, '.', ' ')}}</span></td>
					</tr>
				  </tbody>
				</table>

			  </td>
			  <td class="no_border"><!-- row 2, col 2 -->

				<table class="table table-condensed table-bordered report_fixed_table">
				  <tbody>
					<tr>
					  <td><b>Amount Paid:</b></td>
					  <td></td>
					  <td>{{ cur_sym }} <span{% if amount_paid > 0 %} class="red"{% endif %}>{{ amount_paid | abs | number_format(2, '.', ' ') }}</span></td>
					</tr>
					<tr>
					  <td><b>Amount Due:</b></td>
					  <td></td>
					  <td>{{ cur_sym }} <span>{{ amount_due  | number_format(2, '.', ' ') }}</span></td>
					</tr>
					<tr>
					  <td colspan="3">&nbsp;</td>
					</tr>
				  </tbody>
				</table>

			  </td>
			</tr>
		  </tbody>
		</table>
	</div>
</div>