{% set months = {0:"--", 1:"Jan", 2:"Feb", 3:"Mar", 4:"Apr", 5:"May", 6:"Jun", 7:"Jul", 8:"Aug", 9:"Sep", 10:"Oct", 11:"Nov", 12:"Dec"} %}
{% if unallocated_credits|length > 0 %}
	<div class="well" style="background-color:#FCF8E3">
		<h4>Credit Notes not assigned to Accounting Period</h4><a id="row_filter" class="pull-right" data-state="show_all" href="javascript:FilterCreditNotes({{month}}, {{year}})">Show Month</a>
		<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
		<tr>
			<th>Date</th><th>Period</th><th>Doc Number</th><th>Partner</th><th>MA Account</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th><th style="width:20px"></th>
		</tr>
		{% for credit_note in unallocated_credits %}

		{% set row_class = 'success' %}
		{% set row_title = 'Ready to Allocate' %}
		{% if credit_note.allocations|length == 0 %}
			{% set row_class = 'error' %}
			{% set row_title = 'No allocations on Credit Note' %}
		{% else %}
			{% set alloc_ex_vat = 0 %}
			{% for credit_alloc in credit_note.allocations %}
				{% set alloc_ex_vat = alloc_ex_vat + credit_alloc.amountExVat %}
			{% endfor %}
			
			{% if alloc_ex_vat != credit_note.amountExVat %}
				{% set row_class = 'warning' %}
				{% set row_title = 'Allocations do not Match Credit Note amounts' %}
			{% endif %}
		{% endif %}
		<tr title="{{row_title}}" class="{{row_class}} cn_row" data-month='{{credit_note.periodMonth}}' data-year='{{credit_note.periodYear}}'>
			<td>{{ credit_note.creditNoteDate|date("Y/m/d") }}</td>
			<td>{{ months[credit_note.periodMonth] }} {{ credit_note.periodYear }}</td>
			<td title="Click to assign"><a href="javascript:AllocateCreditNote({{ credit_note.id }})">{{ credit_note.creditNoteNumber }}</a></td>
			<td>{{ credit_note.partner.companyName }}</td>
			<td>{{ credit_note.maAccount.maAccountName }}</td>
			<td style="text-align:right">{{ credit_note.amountExVat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_note.vat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_note.amountIncVat|number_format(2, '.', ' ') }}</td>
			<td><a href="javascript:ShowPDFCreditNote({{ credit_note.id }})"><i class="icon-info-sign"></i></a></td>
		</tr>
		{% endfor %}
		</table>
	</div>
{% endif %}

{% if credit_notes_period_set|length > 0 %}
	<div class="well" style="background-color:#DFF0D8">
		<h4>Credit Notes assigned to Accounting Period</h4>
		<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
		<tr>
			<th>Date</th><th>Period</th><th>Doc Number</th><th>Partner</th><th>MA Account</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th><th style="width:20px"></th>
		</tr>
		{% for credit_note in credit_notes_period_set %}
		<tr>
			<td>{{ credit_note.creditNoteDate|date("Y/m/d") }}</td>
			<td>{{ months[credit_note.periodMonth] }} {{ credit_note.periodYear }}</td>
			<td title="Click to un-assign"><a href="javascript:UnAllocateCreditNote({{ credit_note.id }})">{{ credit_note.creditNoteNumber }}</a></td>
			<td>{{ credit_note.partner.companyName }}</td>
			<td>{{ credit_note.maAccount.maAccountName }}</td>
			<td style="text-align:right">{{ credit_note.amountExVat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_note.vat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_note.amountIncVat|number_format(2, '.', ' ') }}</td>
			<td><a href="javascript:ShowPDFCreditNote({{ credit_note.id }})"><i class="icon-info-sign"></i></a></td>
		</tr>
		{% endfor %}
		</table>
	</div>
{% endif %}

{#
{% if unallocated_credit_notes|length > 0 %}
	<div class="well" style="background-color:#F2DEDE">
		<h4>Credit Notes without Allocations</h4>
		<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
		<tr>
			<th colspan="6"></th><th colspan="3" style="text-align:center">Credit Amount</th>
		</tr>
		<tr>
			<th>Date</th><th>Period</th><th>Accounting Period</th><th>Credit Note</th><th>Partner</th><th>Account</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th>
		</tr>
		{% for credit_note in unallocated_credit_notes %}
		<tr>
			<td>{{ credit_note.creditNoteDate|date("Y/m/d") }}</td>
			<td>{{ months[credit_note.periodMonth] }} {{ credit_note.periodYear }}</td>
			<td>{% if credit_note.vatPeriodMonth != 0 and credit_note.vatPeriodYear != 0 %}{{ months[credit_note.vatPeriodMonth] }} {{ credit_note.vatPeriodYear }}{% endif %}</td>
			<td><a href="javascript:ShowPDFCreditNote({{ credit_note.id }})">{{ credit_note.creditNoteNumber }}</a></td>
			<td>{% if credit_note.partner %}{{ credit_note.partner.companyName }}{% else %}<span class="text-error">NOT SET</span>{% endif %}</td>
			<td>{% if credit_note.maAccount %}{{ credit_note.maAccount.maAccountName }}{% else %}<span class="text-error">NOT SET</span>{% endif %}</td>
			<td style="text-align:right">{{ credit_note.amountExVat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_note.vat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_note.amountIncVat|number_format(2, '.', ' ') }}</td>
		</tr>
		{% endfor %}
		</table>
	</div>
{% endif %}
#}

{% if credit_note_allocations|length > 0 %}
{% set last_credit_note_id = 0 %}
	<div class="well" style="background-color:#FCF8E3">
		<h4>Credit Note Allocations</h4>
		<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
		<tr>
			<th style="text-align:center" colspan="9">Credit Note</th><th style="text-align:center" colspan="5">Credit Allocation</th><th style="text-align:center" colspan="3">Item Amount</th><th style="text-align:center" colspan="3">Allocation Amount</th><th style="text-align:center" colspan="3">Waybill Adjustment</th>
		</tr>
		<tr>
			<th>Date</th><th>Period</th><th>Accounting Period</th><th>Partner</th><th>Account</th><th>Credit Note</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th><th>Customer</th><th>Period</th><th>Invoice</th><th>Waybill</th><th>Credit</th>
			<th>ex VAT</th><th>VAT</th><th>inc VAT</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th>
		</tr>
		{% set sum_alloc_ex_vat = 0 %}
		{% set sum_alloc_vat = 0 %}
		{% set sum_alloc_inc_vat = 0 %}
		
		{% for credit_allocation in credit_note_allocations %}
			{% set adjustments = null %}
		<tr>
			{% if last_credit_note_id != credit_allocation.creditNote.id %}
			<td>{{ credit_allocation.creditNote.creditNoteDate|date("Y/m/d") }}</td>
			<td>{{ months[credit_allocation.creditNote.periodMonth] }} {{ credit_allocation.creditNote.periodYear }}</td>
			<td>{% if credit_allocation.creditNote.vatPeriodMonth != 0 and credit_allocation.creditNote.vatPeriodYear != 0 %}{{ months[credit_allocation.creditNote.vatPeriodMonth] }} {{ credit_allocation.creditNote.vatPeriodYear }}{% endif %}</td>
			<td>{% if credit_allocation.creditNote.partner %}{{ credit_allocation.creditNote.partner.companyName }}{% else %}<span class="text-error">NOT SET</span>{% endif %}</td>
			<td>{% if credit_allocation.creditNote.maAccount %}{{ credit_allocation.creditNote.maAccount.maAccountName }}{% else %}<span class="text-error">NOT SET</span>{% endif %}</td>
			<td><a href="javascript:ShowPDFCreditNote({{ credit_allocation.creditNote.id }})">{{ credit_allocation.creditNote.creditNoteNumber }}</a></td>
			<td style="text-align:right">{{ credit_allocation.creditNote.amountExVat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_allocation.creditNote.vat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ credit_allocation.creditNote.amountIncVat|number_format(2, '.', ' ') }}</td>
			{% else %}
			<td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td>
			{% endif %}
			<td>{% if credit_allocation.customer %}{{ credit_allocation.customer.companyName }}{% else %}<span class="text-error">NOT SET</span>{% endif %}</td>
			<td>
				{% if credit_allocation.accountingPeriodMonth != 0 and credit_allocation.accountingPeriodYear != 0 %}
					{{ months[credit_allocation.accountingPeriodMonth] }} {{ credit_allocation.accountingPeriodYear }}
				{% endif %}
			</td>
			<td>
				{% if credit_allocation.pdfInvoice is not null %}
					<a href="javascript:ShowPDFInvoice({{ credit_allocation.pdfInvoice.id }})">{{ credit_allocation.pdfInvoice.invoiceNumber|trim }}</a>
				{% endif %}
			</td>
			<td>
				<a href="javascript:ShowAllocatedWaybill({{ credit_allocation.id }})">
				{% if credit_allocation.rttWaybill is not null %}
					{% set adjustments = credit_allocation.rttWaybill.adjustments %}
					{{ credit_allocation.rttWaybill.consignmentId|trim }}
				{% elseif credit_allocation.courieritWaybill is not null %}
					{% set adjustments = credit_allocation.courieritWaybill.adjustments %}
					{{ credit_allocation.courieritWaybill.waybillNumber|trim }}
				{% elseif credit_allocation.ewcWaybill is not null %}
					{% set adjustments = credit_allocation.ewcWaybill.adjustments %}
					{{ credit_allocation.ewcWaybill.waybill|trim }}
				{% elseif credit_allocation.kingsWaybill is not null %}
					{% set adjustments = credit_allocation.kingsWaybill.adjustments %}
					{{ credit_allocation.kingsWaybill.waybill|trim }}
				{% elseif credit_allocation.cargoworksWaybill is not null %}
					{% set adjustments = credit_allocation.cargoworksWaybill.adjustments %}
					{{ credit_allocation.cargoworksWaybill.waybill|trim }}
				{% elseif credit_allocation.churchillsWaybill is not null %}
					{% set adjustments = credit_allocation.churchillsWaybill.adjustments %}
					{{ credit_allocation.churchillsWaybill.waybill|trim }}
				{% elseif credit_allocation.expresswaysWaybill is not null %}
					{% set adjustments = credit_allocation.expresswaysWaybill.adjustments %}
					{{ credit_allocation.expresswaysWaybill.waybill|trim }}
				{% elseif credit_allocation.utiWaybill is not null %}
					{% set adjustments = credit_allocation.utiWaybill.adjustments %}
					{{ credit_allocation.utiWaybill.shipmentNumber|trim }}
				{% elseif credit_allocation.skynetWaybill is not null %}
					{% set adjustments = credit_allocation.skynetWaybill.adjustments %}
					{{ credit_allocation.skynetWaybill.waybill|trim }}
				{% elseif credit_allocation.gavicWaybill is not null %}
					{% set adjustments = credit_allocation.gavicWaybill.adjustments %}
					{{ credit_allocation.gavicWaybill.waybill|trim }}
				{% elseif credit_allocation.fpDuToitWaybill is not null %}
					{% set adjustments = credit_allocation.fpDuToitWaybill.adjustments %}
					{{ credit_allocation.fpDuToitWaybill.waybill|trim }}
				{% elseif credit_allocation.celticFreightWaybill is not null %}
					{% set adjustments = credit_allocation.celticFreightWaybill.adjustments %}
					{{ credit_allocation.celticFreightWaybill.waybill|trim }}
				{% elseif credit_allocation.bbTransportWaybill is not null %}
					{% set adjustments = credit_allocation.bbTransportWaybill.adjustments %}
					{{ credit_allocation.bbTransportWaybill.waybill|trim }}
				{% elseif credit_allocation.transWorldWaybill is not null %}
					{% set adjustments = credit_allocation.transWorldWaybill.adjustments %}
					{{ credit_allocation.transWorldWaybill.waybill|trim }}
				{% elseif credit_allocation.camposWaybill is not null %}
					{% set adjustments = credit_allocation.camposWaybill.adjustments %}
					{{ credit_allocation.camposWaybill.waybill|trim }}
				{% elseif credit_allocation.aramexWaybill is not null %}
					{% set adjustments = credit_allocation.aramexWaybill.adjustments %}
					{{ credit_allocation.aramexWaybill.waybill|trim }}
				{% elseif credit_allocation.abafaziWaybill is not null %}
					{% set adjustments = credit_allocation.abafaziWaybill.adjustments %}
					{{ credit_allocation.abafaziWaybill.waybill|trim }}
				{% elseif credit_allocation.fedexWaybill is not null %}
					{% set adjustments = credit_allocation.fedexWaybill.adjustments %}
					{{ credit_allocation.fedexWaybill.waybill|trim }}
				{% elseif credit_allocation.emitWaybill is not null %}
					{% set adjustments = credit_allocation.emitWaybill.adjustments %}
					{{ credit_allocation.emitWaybill.waybill|trim }}
				{% elseif credit_allocation.rowelWaybill is not null %}
					{% set adjustments = credit_allocation.rowelWaybill.adjustments %}
					{{ credit_allocation.rowelWaybill.waybill|trim }}
				{% elseif credit_allocation.inMotionWaybill is not null %}
					{% set adjustments = credit_allocation.inMotionWaybill.adjustments %}
					{{ credit_allocation.inMotionWaybill.waybill|trim }}
				{% elseif credit_allocation.adhocWaybillWaybill is not null %}
					{% set adjustments = credit_allocation.adhocWaybillWaybill.adjustments %}
					{{ credit_allocation.adhocWaybillWaybill.waybill|trim }}
				{% elseif credit_allocation.rbAndSonWaybill is not null %}
					{% set adjustments = credit_allocation.rbAndSonWaybill.adjustments %}
					{{ credit_allocation.rbAndSonWaybill.waybill|trim }}
				{% endif %}
				</a>
			</td>
			<td>
				<a href="javascript:ShowAllocatedWaybillCredit({{ credit_allocation.id }})">
				{% if credit_allocation.skynetReversal is not null %}
					{% if credit_allocation.skynetReversal.adjustedWaybill is not null %}
						{% set adjustments = credit_allocation.skynetReversal.adjustedWaybill.adjustments %} 
					{% endif %}
					{{ credit_allocation.skynetReversal.waybill|trim }}
				{% elseif credit_allocation.utiReversal is not null %}
					{% if credit_allocation.utiReversal.adjustedWaybill is not null %}
						{% set adjustments = credit_allocation.utiReversal.adjustedWaybill.adjustments %}
					{% endif %}
					{{ credit_allocation.utiReversal.shipmentNumber|trim }}
				{% endif %}
				</a>
			</td>
			
			{% set alloc_color = '#FCF8E3' %}
			{% if loop.last or (credit_note_allocations[loop.index0+1] is defined and (credit_note_allocations[loop.index0+1].creditNote.id !=  credit_allocation.creditNote.id)) %}
				{% set sum_alloc_ex_vat = sum_alloc_ex_vat + credit_allocation.amountExVat %}
				{% set sum_alloc_vat = sum_alloc_vat + credit_allocation.vat %}
				{% set sum_alloc_inc_vat = sum_alloc_inc_vat + credit_allocation.amountIncVat %}
				{% if credit_allocation.creditNote.amountExVat|round(2) != sum_alloc_ex_vat|round(2) or credit_allocation.creditNote.vat|round(2) != sum_alloc_vat|round(2) or credit_allocation.creditNote.amountIncVat|round(2) != sum_alloc_inc_vat|round(2) %}
					{% set alloc_color = '#F2DEDE' %}
				{% endif %}
				{% set sum_alloc_ex_vat = 0 %}
				{% set sum_alloc_vat = 0 %}
				{% set sum_alloc_inc_vat = 0 %}
			{% else %}
				{% set sum_alloc_ex_vat = sum_alloc_ex_vat + credit_allocation.amountExVat %}
				{% set sum_alloc_vat = sum_alloc_vat + credit_allocation.vat %}
				{% set sum_alloc_inc_vat = sum_alloc_inc_vat + credit_allocation.amountIncVat %}
			{% endif %}

			{% set item_totals = d2_credit_alloc_item_amount(credit_allocation.id) %}
			{% set item_color = '#FCF8E3' %}
			{% if item_totals['ex_vat'] < credit_allocation.amountExVat %}
				{% set item_color = '#F2DEDE' %}
			{% endif %}
				
			<td style="text-align:right; background-color:{{ item_color }}">{{ item_totals['ex_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right; background-color:{{ item_color }}">{{ item_totals['vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right; background-color:{{ item_color }}">{{ item_totals['inc_vat']|number_format(2, '.', ' ') }}</td>
			
			<td style="text-align:right; background-color:{{ alloc_color }}">{{ credit_allocation.amountExVat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right; background-color:{{ alloc_color }}">{{ credit_allocation.vat|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right; background-color:{{ alloc_color }}">{{ credit_allocation.amountIncVat|number_format(2, '.', ' ') }}</td>
			{% if adjustments is not null %}
			{% set adj_data = d2_calc_adjustment_sum(adjustments) %}
			
			{% set color = '#FCF8E3' %}
			{% if (adj_data['ex_vat']|abs != 0) or (adj_data['vat']|abs != 0) or (adj_data['inc_vat']|abs != 0) %}
			{% if (adj_data['ex_vat']|abs|round(2) != credit_allocation.amountExVat|round(2)) or (adj_data['vat']|abs|round(2) != credit_allocation.vat|round(2)) or (adj_data['inc_vat']|abs|round(2) != credit_allocation.amountIncVat|round(2)) %}
			{% set color = '#F2DEDE' %}
			{% endif %}
			<td style="text-align:right; background-color:{{ color }}">{{ adj_data['ex_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right; background-color:{{ color }}">{{ adj_data['vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right; background-color:{{ color }}">{{ adj_data['inc_vat']|number_format(2, '.', ' ') }}</td>
			{% else %}
			<td></td>
			<td></td>
			<td></td>
			{% endif %}
			
			{% else %}
			<td style="text-align:right"></td>
			<td style="text-align:right"></td>
			<td style="text-align:right"></td>
			{% endif %}
		</tr>
		{% set last_credit_note_id = credit_allocation.creditNote.id %}
		{% endfor %}
		</table>
	</div>
{% endif %}

{% if adjusted_master|length > 0 %}
	<div class="well" style="background-color:#FCF8E3">
		<h4 >Adjusted Waybills</h4>
		<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
		<tr>
			<th colspan="4"></th><th colspan = "3" style="text-align:center">Credit Allocation Amount</th><th colspan = "3" style="text-align:center">Adjustment Amount</th>
		</tr>
		<tr>
			<th>Partner</th><th>Customer</th><th>Waybill</th><th>Credit Note</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th><th style="width:20px"></th>
		</tr>
		{% for adjusted_section in adjusted_master %}
		{% for adjusted_waybill in adjusted_section %}
		{% if (adjusted_waybill['adj_ex_vat'] != 0) or (adjusted_waybill['adj_vat'] != 0) or (adjusted_waybill['adj_inc_vat'] != 0) %}
		{% if (adjusted_waybill['adj_ex_vat']|abs|round(2) != adjusted_waybill['cred_ex_vat']|round(2)) or (adjusted_waybill['adj_vat']|abs|round(2) != adjusted_waybill['cred_vat']|round(2)) or (adjusted_waybill['adj_inc_vat']|abs|round(2) != adjusted_waybill['cred_inc_vat']|round(2)) %}
		{% set color = '#F2DEDE' %}
		{% else %}
		{% set color = '#FCF8E3' %}
		{% endif %}
		<tr>
			<td>{{ adjusted_waybill['partner'] }}</td>
			<td>{{ adjusted_waybill['customer'] }}</td>
			<td><a href="javascript:ShowPartnerWaybill({{ adjusted_waybill['partner_id'] }}, {{ adjusted_waybill['waybill_id'] }})">{{ adjusted_waybill['waybill'] }}</a></td>
			<td><a href="javascript:ShowPDFCreditNote({{ adjusted_waybill['credit_note_id'] }})">{{ adjusted_waybill['credit_note'] }}</a></td>
			<td style="text-align:right">{{ adjusted_waybill['cred_ex_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ adjusted_waybill['cred_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ adjusted_waybill['cred_inc_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right;background-color:{{ color }}">{{ adjusted_waybill['adj_ex_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right;background-color:{{ color }}">{{ adjusted_waybill['adj_vat']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right;background-color:{{ color }}">{{ adjusted_waybill['adj_inc_vat']|number_format(2, '.', ' ') }}</td>
			<td><a href="javascript:ClearForwardCredits({{ adjusted_waybill['partner_id'] }}, {{ adjusted_waybill['waybill_id'] }})"><i title="Clear Forward Credits" class="icon-remove-circle"></i></a></td>
		</tr>
		{% endif %}
		{% endfor %}
		{% endfor %}
		</table>
	</div>
{% endif %}