{% extends 'D2BillingBundle::base.html.twig' %}

{% set months = {1:"Jan", 2:"Feb", 3:"Mar", 4:"Apr", 5:"May", 6:"Jun", 7:"Jul", 8:"Aug", 9:"Sep", 10:"Oct", 11:"Nov", 12:"Dec"} %}


{% block head_script_extra %}
<script type="text/javascript" src="{{ asset('bundles/d2billing/js/billing_run_admin.js') }}"></script>
<script type="text/javascript" src="{{ asset('bundles/d2partner/js/credit_note_assignment.js') }}"></script>
<script type="text/javascript" src="{{ asset('bundles/d2partner/js/waybill.js') }}"></script>
{#<script type="text/javascript" src="{{ asset('bundles/d2partner/js/waybill_docs.js') }}"></script>#}
<script>
var tick_png = '{{ asset("bundles/d2core/images/tick.png") }}';
var cross_png = '{{ asset("bundles/d2core/images/cross.png") }}';

$(document).ready(function() {
	$('.select_customer').on('click', function() {
		var src = $(this).attr('src');
		if(src == tick_png)
			$(this).attr('src', cross_png);
		else
			$(this).attr('src', tick_png);
	});

	{% for k, v in backgnd_proc_arr  %}
		{% if v['bulk_edit'] == true %}
			ContinueBillingBulkEdit({{ k }}, {{ v['bulk_edit_coverage'] }});
		{% endif %}
		{% if v['gen'] == true %}
			ContinueBillingRun({{ k }}, {{ v['coverage'] }});
		{% endif %}
		{% if v['report'] == true %}
			ContinueBillingReport({{ k }}, {{ v['report_coverage'] }});
		{% endif %}
		{% if v['clear'] == true %}
			ContinueClearBillingRun({{ k }}, {{ v['coverage'] }});
		{% endif %}
		{% if v['export'] == true %}
			ContinueBillingExport({{ k }}, {{ v['report_coverage'] }});
		{% endif %}
		{% if v['import'] == true %}
			ContinueBillingImport({{ k }}, {{ v['report_coverage'] }});
		{% endif %}
	{% endfor %}

	{% if ok_to_edit == false %}
	bootbox.alert("PLEASE NOTE THAT THIS IS NOT THE LATEST BILLING RUN!");
	{% endif %}
		
	{% if global_backgnd_proc_arr['export'] == true %}
			ContinueAllBillingExport(10000);
	{% endif %}
	
	if({{ partner_flags_array|length }})
		ProcessWaybillFlags({{ partner_flags_array|json_encode|raw }});
});	

function DatedPdf(customer_id, statement_date) 
{
	$("#modal_title").html("Statement Date");
	$("#modal_action_btn").attr("href", "javascript:DoStatement(" + customer_id + ", '" + statement_date + "')");
	$("#modal_form").html('<table><tr><td width="150px">Statement Date:</td><td><div id="statement_date" class="input-append"><input id="from_date" type="text" value="' + statement_date + '" style="width:100px" data-format="yyyy-MM-dd" name="from_date"><span class="add-on"><i class="icon-calendar" data-date-icon="icon-calendar" data-time-icon="icon-time"></i></span></div></td></tr></table>');
	$('#modal_pop').modal('show');

    $('#statement_date').datetimepicker({
        pickTime: false
    });
}

function DoStatement(customer_id, statement_date)
{
	var new_date = $('#from_date').val();

	CheckBillingEmailStatus(customer_id, new_date);
}
</script>

{% endblock head_script_extra %}
    
{% block page_header %}
    <div class="pull-left">
        <code>Billing Run</code>.
    </div>
	<form class="filter_form form-inline pull-right" role="form" method="get">
		{% for k, v in app.request.query %}
			{% if k|lower not in ['search', 'page', 'year', 'month'] %}
				<input type="hidden" name="{{ k }}" value="{{ v }}" />
			{% endif %}
		{% endfor %}
        <div class="filter">
            <label class="sr-only" for="customer">Customer</label>
            <select class="form-control" name="customer" id="customer">
			<option value='0' {{ app.request.get('customer') == '0' ? 'selected="selected"' : '' }}>Show All</option>
            {% for k, v in all_customers %}<option value="{{ v.getId }}" {{ app.request.get('customer') is sameas(v.getId|lower) ? 'selected="selected"' : '' }}>{{ v.getCompanyName }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="month">Month</label>
            <select class="form-control" name="month" id="month">
            {% set opts = {'1':"Jan", '2':"Feb", '3':"Mar", '4':"Apr", '5':"May", '6':"Jun", '7':"Jul", '8':"Aug", '9':"Sep", '10':"Oct", '11':"Nov", '12':"Dec"} %}
            {% for k, v in opts %}<option value="{{ k }}" {{ month is sameas(k|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="year">Year</label>
            <select class="form-control" name="year" id="year">
            {% set opts = {'2015':"2015", '2016':"2016", '2017':"2017", '2018':"2018", '2019':"2019", '2020':"2020", '2021':"2021", '2022':"2022", '2023':"2023", '2024':"2024", '2025':"2025", '2026':"2026", '2027':"2027", '2028':"2028", '2029':"2029", '2030':"2030"} %}
            {% for k, v in opts %}<option value="{{ k }}" {{ year is sameas(k|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
            </select>
            
            <div class="btn-group">
                <button type="submit" class="btn btn-default">Go</button>
                <button type="button" class="btn btn-default clear_filter">Clear</button>
            </div>
        </div>
	</form>
    <div class="clearfix"></div>
{% endblock page_header %}

{% block content %}
<input type="text" id="run_month" style="display:none" value="{{ month }}">
<input type="text" id="run_year" style="display:none" value="{{ year }}">

{% if is_period_data == true %}
<table style="width:100%">
	<tr>
		<td style="vertical-align:top; width:50%">
		{% if unassigned_master|length > 0 %}
			<div class="well well-small" style="background-color:#FCF8E3;min-height:50px">
			<h4 class="pull-left" style="color:#C09853">Warning: Un-assigned Waybills!</h4><a class="pull-right" href="javascript:ToggleUnassignedSection()"><i class='icon-chevron-down'></i></a>
			<table id="unassigned_section" class="table table-condensed table-bordered" style="display:none">
				<tr>
					<th>Partner</th>
					<th>Invoice File</th>
					<th>Count</th>
				</tr>
			{% for item in unassigned_master %}
				<tr>
					<td>{{ item['partner_name'] }}</td>
					<td><a href="{{ item['route'] }}">{{ item['file_name'] }}</a></td>
					<td>{{ item['unassigned_cnt'] }}</td>
				</tr>
			{% endfor %}
			</table>
			</div>
		{% endif %}
		</td>
		<td style="vertical-align:top">
		{% if alert_master|length > 0 %}
			<div class="well well-small" style="background-color:#FCF8E3;min-height:50px">
			<h4 class="pull-left" style="color:#C09853">Warning: Alerts not cleared on Waybills!</h4><a class="pull-right" href="javascript:ToggleAlertsSection()"><i class='icon-chevron-down'></i></a>
			<table id="alerts_section" class="table table-condensed table-bordered" style="display:none">
				<tr>
					<th>Partner</th>
					<th>Invoice File</th>
					<th>Count</th>
				</tr>
			{% for item in alert_master %}
				<tr>
					<td>{{ item['partner_name'] }}</td>
					<td><a href="{{ item['route'] }}">{{ item['file_name'] }}</td>
					<td>{{ item['alert_cnt'] }}</td>
				</tr>
			{% endfor %}
			</table>
			</div>
		{% endif %}
		</td>
	</tr>
	{% if partner_invoice_data|length > 0 %}
	<tr>
		<td colspan='2'>
			<div class="well" style="background-color:#FCF8E3">
				<h4 class="pull-left" style="color:#C09853">Partner Summary</h4><a class="pull-right" href="javascript:TogglePartnerSummarySection()"><i class='icon-chevron-down'></i></a>
				<div class="clearfix"></div>
				<div  id="partner_summary_section" style="display:none">
					<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
					<tr>
						<th>Partner</th><th>Account</th><th colspan="3" style="text-align:center">Waybills</th><th colspan="3" style="text-align:center">Invoice</th><th colspan="3" style="text-align:center">Credits</th><th>Statement</th>
					</tr>
					<tr>
						<th colspan="2"></th><th style="text-align:right">Sub Total</th><th style="text-align:right">Vat</th><th style="text-align:right">Total</th>
						<th style="text-align:right">Sub Total</th><th style="text-align:right">Vat</th><th style="text-align:right">Total</th>
						<th style="text-align:right">Sub Total</th><th style="text-align:right">Vat</th><th style="text-align:right">Total</th>
						<th style="text-align:right">Current</th>
					</tr>
					{% for invoice_data in partner_invoice_data %}
						{% for invoice_stat in invoice_data %}
							{% if (invoice_stat['waybill_totals']['total']|round(2) != invoice_stat['inc_vat']|round(2)) %}
								{% set waybill_color = '#F2DEDE' %}
								{% set invoice_color = '#F2DEDE' %}
							{% else %}
								{% set waybill_color = '#FCF8E3' %}
								{% set invoice_color = '#FCF8E3' %}
							{% endif %}
							{% if invoice_stat['statement_current'] is not null %}
							{% if ((invoice_stat['waybill_totals']['total'] - invoice_stat['credit_totals']['total'])|round(2) != invoice_stat['statement_current']|round(2)) %}
								{% set waybill_color = '#F2DEDE' %}
								{% set statement_color = '#F2DEDE' %}
							{% else %}
								{% set waybill_color = '#FCF8E3' %}
								{% set statement_color = '#FCF8E3' %}
							{% endif %}
							{% if ((invoice_stat['inc_vat'] - invoice_stat['credit_totals']['total'])|round(2) != invoice_stat['statement_current']|round(2)) %}
								{% set invoice_color = '#F2DEDE' %}
								{% set statement_color = '#F2DEDE' %}
							{% else %}
								{% set invoice_color = '#FCF8E3' %}
								{% set statement_color = '#FCF8E3' %}
							{% endif %}
							{% endif %}
							<tr title="Click to show breakdown" onclick= "ShowInvoiceStat({{invoice_stat['partner_id'] }}, {{invoice_stat['ma_account_id'] }})">
								<td>{{ invoice_stat['partner_name'] }}</td>
								<td>{{ invoice_stat['ma_account_name'] }}</td>
								<td style="text-align:right">{{ invoice_stat['waybill_totals']['sub_total']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right">{{ invoice_stat['waybill_totals']['vat']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right; background-color:{{ waybill_color }}">{{ invoice_stat['waybill_totals']['total']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right">{{ invoice_stat['ex_vat']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right">{{ invoice_stat['vat']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right; background-color:{{ invoice_color }}">{{ invoice_stat['inc_vat']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right">{{ invoice_stat['credit_totals']['sub_total']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right">{{ invoice_stat['credit_totals']['vat']|number_format(2, '.', ' ') }}</td>
								<td style="text-align:right">{{ invoice_stat['credit_totals']['total']|number_format(2, '.', ' ') }}</td>
								{% if invoice_stat['statement_current'] is null %}
								<td style="text-align:right; background-color:F2DEDE">NO STATEMENT</td>
								{% else %}
								<td style="text-align:right; background-color:{{ statement_color }}">{{ invoice_stat['statement_current']|number_format(2, '.', ' ') }}</td>
								{% endif %}
							</tr>
						{% endfor %}
					{% endfor %}
					</table>
				</div>
			</div>
		</td>
	</tr>	
	{% endif %}
	{% if unresolved_calc_rules|length > 0 %}
	<tr>
		<td colspan='2'>
			<div class="well" style="background-color:#F2DEDE">
				<h4 class="pull-left" style="color:#C09853">Calc Rule Exceptions</h4><a class="pull-right" href="javascript:ToggleCalcRuleSection()"><i class='icon-chevron-down'></i></a>
				<div class="clearfix"></div>
				<div  id="calc_rule_section" style="display:none">
					<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
					<tr>
						<th>Customer</th><th>Partner</th><th>Invoice</th><th>Waybill</th>
					</tr>
					{% for calc_res in unresolved_calc_rules %}
					<tr>
						<td>{{ calc_res['customer'] }}</td>
						<td>{{ calc_res['partner'] }}</td>
						<td><a href="{{ calc_res['item_route'] }}">{{ calc_res['invoice'] }}</a></td>
						<td><a href="javascript:ShowPartnerWaybill({{ calc_res['partner_id'] }}, {{ calc_res['waybill_id'] }})">{{ calc_res['waybill'] }}</a></td>
					</tr>
					{% endfor %}
					</table>
				</div>
			</div>
		</td>
	</tr>
	{% endif %}
	{% if unallocated_credit_notes|length > 0 %}
	<tr>
		<td colspan='2'>
			{% set months = {0:"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"} %}
			<div class="well" style="background-color:#F2DEDE">
				<h4 class="pull-left" style="color:#C09853">Warning: Credit Notes without Allocations!</h4><a class="pull-right" href="javascript:ToggleNoCreditAllocSection()"><i class='icon-chevron-down'></i></a>
				<div class="clearfix"></div>
				<div  id="no_credit_alloc_section" style="display:none">
					<a id="row_filter_unallocated" class="pull-right" data-state="show_all" href="javascript:FilterUnAllocatedCreditNotes({{month}}, {{year}})">Show Month </a>
					<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
					<tr>
						<th colspan="6"></th><th colspan="3">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 class=" cn_row_unallocated" 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>{% if credit_note.vatPeriodMonth != 0 and credit_note.vatPeriodYear != 0 %}{{ months[credit_note.vatPeriodMonth] }} {{ credit_note.vatPeriodYear }}{% endif %}</td>
						<td>
							<div class="dropdown">
							  <a class="dropdown-toggle" data-toggle="dropdown">{{ credit_note.creditNoteNumber }}</i></a>
							  <ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
								<li><a href="javascript:ShowPDFCreditNote({{ credit_note.id }})">View Credit Note</a></li>
								<li><a href="javascript:HideBillingCredit({{ credit_note.id }})">Hide Credit Note</a></li>
							  </ul>
							</div>					
						</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>
			</div>
		</td>	
	</tr>
	{% endif %}
	{% if credit_note_allocations|length > 0 %}
	<tr>
		<td colspan='2'>
			{% set months = {0:"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"} %}
			<div class="well" style="background-color:#FCF8E3">
				<h4 class="pull-left">Available Credit Allocations</h4><a class="pull-right" href="javascript:ToggleAvailCreditAllocSection()"><i class='icon-chevron-down'></i></a>
				<div class="clearfix"></div>
				<div  id="avail_credit_alloc_section" style="display:none">
					<a id="row_filter_available" class="pull-right" data-state="show_all" href="javascript:FilterAvailableCreditNotes({{month}}, {{year}})">Show Month</a>
					<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
					<tr>
						<th colspan="10"></th><th style="text-align:center" colspan="3">Item Amount</th><th style="text-align:center" colspan="3">Credit Amount</th><th style="text-align:center" colspan="3">Adjustment Amount</th>
					</tr>
					<tr>
						<th>Date</th><th>Period</th><th>Accounting Period</th><th>Credit Note</th><th>Customer</th><th>Partner</th><th>Account</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>
					{% for credit_allocation in credit_note_allocations %}
						{% set adjustments = null %}
						{% 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 %}
					<tr class=" cn_row_available" data-month='{{credit_allocation.creditNote.periodMonth}}' data-year='{{credit_allocation.creditNote.periodYear}}'>
						<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>
							<div class="dropdown">
							  <a class="dropdown-toggle" data-toggle="dropdown">{{ credit_allocation.creditNote.creditNoteNumber }}</i></a>
							  <ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
								<li><a href="javascript:ShowPDFCreditNote({{ credit_allocation.creditNote.id }})">Show Credit Note</a></li>
								<li><a href="javascript:HideBillingCredit({{ credit_allocation.creditNote.id }})">Hide Credit Note</a></li>
								<li><a href="javascript:HideBillingCreditAllocation({{ credit_allocation.id }})">Hide Credit Allocation</a></li>
							  </ul>
							</div>					
							
						</td>
						<td title="Click to assign">{% if credit_allocation.customer %}<a href="javascript:AllocateBillingCredit({{ credit_allocation.id }}, {{ month }}, {{ year }})">{{ credit_allocation.customer.companyName }}</a>{% else %}<span class="text-error">NOT SET</span>{% 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>
							{% 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>
						<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">{{ credit_allocation.amountExVat|number_format(2, '.', ' ') }}</td>
						<td style="text-align:right">{{ credit_allocation.vat|number_format(2, '.', ' ') }}</td>
						<td style="text-align:right">{{ credit_allocation.amountIncVat|number_format(2, '.', ' ') }}</td>
						{% if adjustments is not null %}
						{% set adj_data = d2_calc_adjustment_sum(adjustments) %}
						
						{% if (adj_data['ex_vat']|abs != credit_allocation.amountExVat) or (adj_data['vat']|abs != credit_allocation.vat) or (adj_data['inc_vat']|abs != credit_allocation.amountIncVat) %}
						{% set color = '#F2DEDE' %}
						{% else %}
						{% set color = '#FCF8E3' %}
						{% endif %}
							{% if adj_data['ex_vat'] != 0.00 or adj_data['vat'] != 0.00 or adj_data['inc_vat'] != 0.00 %}
							<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 style="text-align:right"></td>
							<td style="text-align:right"></td>
							<td style="text-align:right"></td>
							{% endif %}
						{% else %}
						<td style="text-align:right"></td>
						<td style="text-align:right"></td>
						<td style="text-align:right"></td>
						{% endif %}
					</tr>
					{% endfor %}
					</table>
				</div>
			</div>
		</td>	
	</tr>
	{% endif %}


	{% if allocated_allocations|length > 0 %}
	<tr>
		<td colspan='2'>
			{% set months = {0:"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"} %}
			<div class="well" style="background-color:#DFF0D8">
				<h4>Allocated Credit Allocations</h4>
				<table class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
				<tr>
					<th colspan="10"></th><th style="text-align:center" colspan="3">Item Amount</th><th style="text-align:center" colspan="3">Credit Amount</th><th style="text-align:center" colspan="3">Adjustment Amount</th>
				</tr>
				<tr>
					<th>Date</th><th>Period</th><th>Accounting Period</th><th>Credit Note</th><th>Customer</th><th>Partner</th><th>Account</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>
				{% for credit_allocation in allocated_allocations %}
					{% set adjustments = null %}
					{% set item_totals = d2_credit_alloc_item_amount(credit_allocation.id) %}
					{% set item_color = '#DFF0D8' %}
					{% if item_totals['ex_vat'] < credit_allocation.amountExVat %}
						{% set item_color = '#F2DEDE' %}
					{% endif %}
				<tr>
					<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><a href="javascript:ShowPDFCreditNote({{ credit_allocation.creditNote.id }})">{{ credit_allocation.creditNote.creditNoteNumber }}</a></td>
					<td title="Click to un-assign">{% if credit_allocation.customer %}<a href="javascript:UnAllocateBillingCredit({{ credit_allocation.id }})">{{ credit_allocation.customer.companyName }}</a>{% else %}<span class="text-error">NOT SET</span>{% 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>
						{% 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>
					<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">{{ credit_allocation.amountExVat|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">{{ credit_allocation.vat|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">{{ credit_allocation.amountIncVat|number_format(2, '.', ' ') }}</td>
					{% if adjustments is not null %}
					{% set adj_data = d2_calc_adjustment_sum(adjustments) %}
					
					{% if (adj_data['ex_vat']|abs != credit_allocation.amountExVat) or (adj_data['vat']|abs != credit_allocation.vat) or (adj_data['inc_vat']|abs != credit_allocation.amountIncVat) %}
					{% set color = '#F2DEDE' %}
					{% else %}
					{% set color = '#DFF0D8' %}
					{% endif %}
					
						{% if adj_data['ex_vat'] != 0.00 or adj_data['vat'] != 0.00 or adj_data['inc_vat'] != 0.00 %}
						<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 style="text-align:right"></td>
						<td style="text-align:right"></td>
						<td style="text-align:right"></td>
						{% endif %}
					{% else %}
					<td style="text-align:right"></td>
					<td style="text-align:right"></td>
					<td style="text-align:right"></td>
					{% endif %}
				</tr>
				{% endfor %}
				</table>
			</div>
		</td>	
	</tr>
	{% endif %}



	{% if adjusted_master|length > 0 %}
	<tr>
		<td colspan='2'>
			<div class="well" style="background-color:#FCF8E3">
				<h4 class="pull-left">Adjusted Waybills</h4><a class="pull-right" href="javascript:ToggleAdjustedSection()"><i class='icon-chevron-down'></i></a>
				<div class="clearfix"></div>
				<table id="adjusted_section" class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px;display:none">
				<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>
				</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 != adjusted_waybill['cred_ex_vat']) or (adjusted_waybill['adj_vat']|abs != adjusted_waybill['cred_vat']) or (adjusted_waybill['adj_inc_vat']|abs != adjusted_waybill['cred_inc_vat']) %}
				{% 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>
				</tr>
				{% endif %}
				{% endfor %}
				{% endfor %}
				</table>
			</div>
		</td>	
	</tr>
	{% endif %}

	{% set ubwc = 0 %}
	{% for key, unbilled_data in unbilled_waybills %}
		{% set ubwc = ubwc + unbilled_data['data']|length %}
	{% endfor %}
	
	{% if ubwc > 0 %}
	{% set wp = 0 %}
	<tr>
		<td colspan='2'>
			<div class="well" style="background-color:#FCF8E3">
				<h4 class="pull-left">Un-billed Waybills ({{ months[previous_month] }} {{ previous_year }})</h4><a class="pull-right" href="javascript:ToggleUnbilledSection()"><i class='icon-chevron-down'></i></a>
				<div class="clearfix"></div>
				<div  id="unbilled_section"  style="display:none">
					<table id="unbilled_table" class="table table-condensed table-extra-condensed table-bordered" style="font-size:10px">
					<tr>
						<th><a href="javascript:ClearAllCheckBox()">CLEAR</a></th><th>Partner</th><th>Customer</th><th>Waybill</th><th>File</th><th>ex VAT</th><th>VAT</th><th>inc VAT</th>
					</tr>
					{% for key, unbilled_data in unbilled_waybills %}
					{% if unbilled_data['data']|length > 0 %}
					{% for waybill_data in unbilled_data['data'] %}
					<tr>
						<td><input type="checkbox" data-partner="{{key}}" data-file="{{ waybill_data['file_id'] }}" data-waybill="{{ waybill_data['waybill_id'] }}"></td>
						<td>{% if key != wp %} <a href="javascript:SelectAllByPartner({{ key }})">{{ unbilled_data['partner'] }}</a> {% endif %}</td>
						<td>{% if  waybill_data['customer_name'] != '' %} {{ waybill_data['customer_name'] }} {% else %} UN-ALLOCATED {% endif %}</td>
						<td>{{ waybill_data['waybill'] }}</td>
						<td><a href="javascript:SelectAllByPartnerFile({{ key }}, {{ waybill_data['file_id'] }})">{{ waybill_data['file_name'] }}</a></td>
						<td></td>
						<td></td>
						<td></td>
					</tr>
					{% set wp = key %}
					{% endfor %}
					{% endif %}
					{% endfor %}
					</table>
					<a href="javascript:AssignCurrentPeriod()" class="btn btn-small btn-success pull-right" style="margin-right:10px">Assign to Current Period</a>
					<div class="clearfix"></div>
				</div>
			</div>
		</td>	
	</tr>
	{% endif %}

</table>

{% set displayed_customer_cnt = 0 %}

{% if customers|length > 0 %}
		{% set overall_not_processed_cnt = 0 %}
		{% set overall_processed_cnt = 0 %}
		{% set overall_imported_cnt = 0 %}
		{% set overall_coverage = 0 %}
		{% set overall_partner_amount = 0 %}
		{% set imported_overall_partner_amount = 0 %}
		{% set overall_ma_amount = 0 %}
		{% set overall_bm_amount = 0 %}
		{% set overall_final_amount = 0 %}
		{% set any_stats_processed = false %}
		
	{% for customer in customers %}
		{% set billing_ver = d2_get_billing_ver(customer, month, year)|trim %}
		{% set export_exists = d2_check_export_ver(customer, month, year) %}
		{% set report_exists = d2_check_report_ver(customer, month, year) %}
		{% set billing_alert = d2_check_billing_setup(customer, month, year) %}
		{% set are_unassigned = false %}
		{% set are_alerted = false %}
		{% set is_rule_covered = true %}
		{% set total_not_processed_cnt = 0 %}
		{% set total_processed_cnt = 0 %}
		{% set total_coverage = 0 %}
		{% set total_report_coverage = 0 %}
		{% set total_bulk_edit_coverage = 0 %}
		{% set cust_not_processed_cnt = 0 %}
		{% set cust_processed_cnt = 0 %}
		{% set cust_imported = 0 %}
		{% set cust_coverage = 0 %}
		{% set cust_partner_amount = 0 %}
		{% set imported_cust_partner_amount = 0 %}
		{% set final_cust_amount = 0 %}
		{% set cust_ma_amount = 0 %}
		{% set cust_bm_amount = 0 %}
		
		{% if show_cust_billing[customer.getId] == true %}
		{% set displayed_customer_cnt = displayed_customer_cnt + 1 %}
		<div class="well">
			<h4 class="pull-left" onclick="javascript:EditBillingSettings({{ customer.id }}, {{ month }}, {{ year}})"> {{ customer.getCompanyName }} V{{ billing_ver }}</h4><span class="pull-right"><b>Imported: </b><img src="{{ asset('bundles/d2core/images/' ~ (cust_arr[customer.id]['billing_imported'] ? 'tick.png' : 'cross.png')) }}" title="{{ cust_arr[customer.id]['billing_imported'] ? 'Active' : 'Inactive' }}" alt="{{ cust_arr[customer.id]['billing_imported'] ? 'Active' : 'Inactive' }}" width="15" /></span>
			<div class="clearfix"></div>
			{% if billing_alert != '' %}
			<div class="well" style="background-color:#F2DEDE">
				{{ billing_alert|raw }}
			</div>
			{% endif %}
			<table class="table table-condensed table-bordered">
				<tr>
					<th colspan="6"></th>
					<th colspan="1" style="text-align:center">Partner</th>
					<th colspan="3" style="text-align:center">Generated</th>
					<th colspan="3" style="text-align:center">Imported</th>
				</tr>
				<tr>
					<th style="width:190px">Partner</th>
					<th>Invoice File</th>
					<th style="text-align:right; width:60px">Not Proc</th>
					<th style="text-align:right; width:60px">Proced</th>
					<th style="text-align:right; width:60px">Rules</th>
					<th style="text-align:right; width:60px">Imported</th>
					<th style="text-align:right; width:100px">Amt (excl)</th>
					<th style="text-align:right; width:100px">Amt (excl)</th>
					<th style="text-align:right; width:100px">Profit (excl)</th>
					<th style="text-align:right; width:80px">Margin</th>
					<th style="text-align:right; width:100px">Amt (excl)</th>
					<th style="text-align:right; width:100px">Profit (excl)</th>
					<th style="text-align:right; width:80px">Margin</th>
					<td style="width:50px"></td>
				</tr>
			{% for stat in proc_master %}
				{% if stat['customer_id'] == customer.getId %}

				{% set overall_not_processed_cnt = overall_not_processed_cnt + stat['not_processed_cnt'] %}
				{% set overall_imported_cnt = overall_imported_cnt + stat['billing_import_cnt'] %}
				{% set overall_processed_cnt = overall_processed_cnt + stat['processed_cnt'] %}
				{% set total_not_processed_cnt = total_not_processed_cnt + stat['not_processed_cnt'] %}
				{% set total_processed_cnt = total_processed_cnt + stat['processed_cnt'] %}
				{% set total_coverage = total_coverage + stat['coverage_cnt'] %}
				{% set total_report_coverage = total_report_coverage + stat['report_coverage_cnt'] %}
				{% set total_bulk_edit_coverage = total_bulk_edit_coverage + stat['bulk_edit_coverage_cnt'] %}
				{% set overall_coverage = overall_coverage + stat['coverage_cnt'] %}
				{% set cust_not_processed_cnt = cust_not_processed_cnt + stat['not_processed_cnt'] %}
				{% set cust_processed_cnt = cust_processed_cnt + stat['processed_cnt'] %}
				{% set cust_coverage = cust_coverage + stat['coverage_cnt'] %}
				{% set cust_imported = cust_imported + stat['billing_import_cnt'] %}
				{% set cust_partner_amount = cust_partner_amount + stat['total_ex_vat'] %}
				{% set imported_cust_partner_amount = imported_cust_partner_amount + stat['imported_ex_vat'] %}
				{% set final_cust_amount = final_cust_amount + stat['final_ex_vat'] %}
				{% set cust_ma_amount = cust_ma_amount + stat['adj_total_ex_vat'] %}
				{% set cust_bm_amount = cust_bm_amount + stat['bm_ex_vat'] %}

				{% if stat['are_unassigned'] == true %}
					{% set are_unassigned = true %}
				{% endif %}	
				{% if stat['are_alerted'] == true %}
					{% set are_alerted = true %}
				{% endif %}	
				{% if stat['is_rule_covered'] == false %}
					{% set is_rule_covered = false %}
				{% endif %}	
				
				{% set coverage_color = '#F5F5F5' %}
				{% set coverage_ok = true %}
				{% if (stat['not_processed_cnt'] + stat['processed_cnt']) != stat['coverage_cnt'] %}
					{% set coverage_color = '#F2DEDE' %}
					{% set coverage_ok = false %}
				{% endif %}
				<tr>
					<td>
						<div class="dropdown">
						  <a name= "partner_dropdown" class="dropdown-toggle" data-toggle="dropdown">{{ stat['partner_name'] }}</a>
						  <ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							{% for filter in stat['filters'] %}
							<li><a target="_default" href="{{ filter['route'] }}">{{ filter['name'] }}</a></li>
							{% endfor %}
						  </ul>
						</div>
    				</td>
					{% if stat['invoice_file_status'] == constant('D2\\RTTBundle\\Entity\\InvoiceFile::TYPE_PS_CHECKED') or stat['invoice_file_status'] == constant('D2\\RTTBundle\\Entity\\InvoiceFile::TYPE_PS_INVOICED') %}
					<td><a target="_default" href="{{ stat['waybill_route'] }}"><span title="File checked!" style="color:#56AE56">{{ stat['invoice_file_name'] }}</span></a></td>
					{% else %}
					<td><a target="_default" href="{{ stat['waybill_route'] }}"><span title="File not checked!" style="color:#C53C36">{{ stat['invoice_file_name'] }}</span></a></td>
					{% endif %}
					<td style="text-align:right">{{ stat['not_processed_cnt'] }}</td>
					<td style="text-align:right">{{ stat['processed_cnt'] }}</td>
					<td style="text-align:right; background-color:{{ coverage_color }}">{% if coverage_ok %}{{ stat['coverage_cnt'] }}{% else %}<a title="View Unbillable Waybills" href="javascript:ViewUnBilled({{ stat['customer_id'] }}, {{ stat['partner_id'] }}, {{ stat['invoice_file_id'] }})">{{ stat['coverage_cnt'] }}</a>{% endif %}</td>
					<td style="text-align:right;">{{ stat['billing_import_cnt'] }}</td>
					{% if stat['not_processed_cnt'] != 0 %}
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					{% else %}
						{% set overall_partner_amount = overall_partner_amount + stat['total_ex_vat'] %}
						{% set imported_overall_partner_amount = imported_overall_partner_amount + stat['imported_ex_vat'] %}
						{% set overall_ma_amount = overall_ma_amount + stat['adj_total_ex_vat'] %}
						{% set overall_bm_amount = overall_bm_amount + stat['bm_ex_vat'] %}
						{% set overall_final_amount = overall_final_amount + stat['final_ex_vat'] %}
						{% set any_stats_processed = true %}
					<td style="text-align:right">
						R {{ stat['total_ex_vat']|number_format(2, '.', ' ') }}
					</td>
					<td style="text-align:right">
						R {{ stat['adj_total_ex_vat']|number_format(2, '.', ' ') }}
					</td>
					<td style="text-align:right">
						{% if stat['adj_total_ex_vat'] != 0 %}
							R {{(stat['adj_total_ex_vat'] - stat['total_ex_vat'])|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						{% if stat['adj_total_ex_vat'] != 0 %}
							{{ (((stat['adj_total_ex_vat'] - stat['total_ex_vat'])/stat['adj_total_ex_vat'])*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						R {{ stat['bm_ex_vat']|number_format(2, '.', ' ') }}
					</td>
					<td style="text-align:right">
						{% if stat['bm_ex_vat'] != 0 %}
							R {{(stat['bm_ex_vat'] - stat['imported_ex_vat'])|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						{% if stat['bm_ex_vat'] != 0 %}
							{{ (((stat['bm_ex_vat'] - stat['imported_ex_vat'])/stat['bm_ex_vat'])*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</td>
					{% endif %}
					<td style="text-align:right">
						<a href="javascript:TestBillingRun({{ stat['customer_id'] }}, {{ stat['partner_id'] }}, {{ stat['invoice_file_id'] }})" class="btn btn-small">View</a>
					</td>
				</tr>
				{% endif %}
			{% endfor %}
			{% if credits_breakdown[customer.id] is defined %}
				{% set cust_partner_amount = cust_partner_amount - credits_breakdown[customer.id]['orig_total'] %}
				{% set cust_ma_amount = cust_ma_amount - credits_breakdown[customer.id]['markup_total'] %}
				{% set overall_partner_amount = overall_partner_amount - credits_breakdown[customer.id]['orig_total'] %}
				{% set overall_ma_amount = overall_ma_amount - credits_breakdown[customer.id]['markup_total'] %}
				{% set imported_overall_partner_amount = imported_overall_partner_amount - credits_breakdown[customer.id]['imported_ex_vat'] %}
				{% set imported_cust_partner_amount = imported_cust_partner_amount - credits_breakdown[customer.id]['imported_ex_vat'] %}
				{% set final_cust_amount = final_cust_amount - credits_breakdown[customer.id]['final_ex_vat'] %}
				{% set cust_bm_amount = cust_bm_amount - credits_breakdown[customer.id]['bm_total'] %}
				{% set overall_bm_amount = overall_bm_amount - credits_breakdown[customer.id]['bm_total'] %}
				{% set overall_final_amount = overall_final_amount - credits_breakdown[customer.id]['final_ex_vat'] %}
				{% set any_stats_processed = true %}
				<tr style="background-color:#FCF8E3">
					<td>All Partners</td>
					<td title="Out of Period Credits">OOP CREDITS</td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td style="text-align:right">R {{ (0 - (credits_breakdown[customer.id]['orig_total']))|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">R {{ (0 - (credits_breakdown[customer.id]['markup_total']))|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">R {{ (0 - (credits_breakdown[customer.id]['markup_total'] - credits_breakdown[customer.id]['orig_total']))|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">
						{% if credits_breakdown[customer.id]['markup_total'] != 0 %}
							{{ (0 - (((credits_breakdown[customer.id]['markup_total'] - credits_breakdown[customer.id]['orig_total'])/credits_breakdown[customer.id]['markup_total'])*100))|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</td>
					<td style="text-align:right">R {{ (0 - (credits_breakdown[customer.id]['bm_total']))|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">R {{ (0 - (credits_breakdown[customer.id]['bm_total'] - credits_breakdown[customer.id]['imported_ex_vat']))|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">
						{% if credits_breakdown[customer.id]['bm_total'] != 0 %}
							{{ (0 - (((credits_breakdown[customer.id]['bm_total'] - credits_breakdown[customer.id]['imported_ex_vat'])/credits_breakdown[customer.id]['bm_total'])*100))|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						<a href="javascript:CreditsBillingRun({{ customer.id }})" class="btn btn-small">View</a>
					</td>
				</tr>
			{% endif %}	
			{% if general_invoice_breakdown[customer.id] is defined %}
				{% set cust_partner_amount = cust_partner_amount + general_invoice_breakdown[customer.id]['orig_total'] %}
				{% set cust_ma_amount = cust_ma_amount + general_invoice_breakdown[customer.id]['markup_total'] %}
				{% set overall_partner_amount = overall_partner_amount + general_invoice_breakdown[customer.id]['orig_total'] %}
				{% set overall_ma_amount = overall_ma_amount + general_invoice_breakdown[customer.id]['markup_total'] %}
				{% set imported_overall_partner_amount = imported_overall_partner_amount + general_invoice_breakdown[customer.id]['imported_ex_vat'] %}
				{% set imported_cust_partner_amount = imported_cust_partner_amount + general_invoice_breakdown[customer.id]['imported_ex_vat'] %}
				{% set final_cust_amount = final_cust_amount + general_invoice_breakdown[customer.id]['final_ex_vat'] %}
				{% set cust_bm_amount = cust_bm_amount + general_invoice_breakdown[customer.id]['bm_total'] %}
				{% set overall_bm_amount = overall_bm_amount + general_invoice_breakdown[customer.id]['bm_total'] %}
				{% set overall_final_amount = overall_final_amount + general_invoice_breakdown[customer.id]['final_ex_vat'] %}
				{% set any_stats_processed = true %}
				<tr style="background-color:#FCF8E3">
					<td>All Partners</td>
					<td>GENERAL INVOICES</td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td style="text-align:right">R {{ (general_invoice_breakdown[customer.id]['orig_total'])|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">R {{ (general_invoice_breakdown[customer.id]['markup_total'])|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">R {{ (general_invoice_breakdown[customer.id]['markup_total'] - general_invoice_breakdown[customer.id]['orig_total'])|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">
						{% if general_invoice_breakdown[customer.id]['markup_total'] != 0 %}
							{{ (((general_invoice_breakdown[customer.id]['markup_total'] - general_invoice_breakdown[customer.id]['orig_total'])/general_invoice_breakdown[customer.id]['markup_total'])*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</td>
					<td style="text-align:right">R {{ (general_invoice_breakdown[customer.id]['bm_total'])|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">R {{ (general_invoice_breakdown[customer.id]['bm_total'] - general_invoice_breakdown[customer.id]['imported_ex_vat'])|number_format(2, '.', ' ') }}</td>
					<td style="text-align:right">
						{% if general_invoice_breakdown[customer.id]['bm_total'] != 0 %}
							{{ (((general_invoice_breakdown[customer.id]['bm_total'] - general_invoice_breakdown[customer.id]['imported_ex_vat'])/general_invoice_breakdown[customer.id]['bm_total'])*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						<a href="javascript:InvoicesBillingRun({{ customer.id }})" class="btn btn-small">View</a>
					</td>
				</tr>
			{% endif %}	
			{% if cust_processed_cnt != 0 %}
				<tr>
					<th></th>
					<th></th>
					<th style="text-align:right;border-top: 2px solid #666666">{{ cust_not_processed_cnt }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">{{ cust_processed_cnt }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">{{ cust_coverage }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">{{ cust_imported }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {{ cust_partner_amount|number_format(2, '.', ' ') }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {{ cust_ma_amount|number_format(2, '.', ' ') }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {{ (cust_ma_amount - cust_partner_amount)|number_format(2, '.', ' ') }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">
						{% if cust_ma_amount != 0 %}
							{{ (((cust_ma_amount - cust_partner_amount)/cust_ma_amount)*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {{ cust_bm_amount|number_format(2, '.', ' ') }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {% if cust_bm_amount != 0 %}{{ (cust_bm_amount - imported_cust_partner_amount)|number_format(2, '.', ' ') }} {% else %} 0.00 {% endif %}</th>
					<th style="text-align:right;border-top: 2px solid #666666">
						{% if cust_bm_amount != 0 %}
							{{ (((cust_bm_amount - imported_cust_partner_amount)/cust_bm_amount)*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</th>
					<td></td>
				</tr>
				<tr>
					<th colspan="9"></th>
					<th style="text-align:right;border-top: 2px solid #666666">TOTAL:</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {{ final_cust_amount|number_format(2, '.', ' ') }}</th>
					<th style="text-align:right;border-top: 2px solid #666666">R {% if final_cust_amount != 0 %}{{ (final_cust_amount - cust_partner_amount)|number_format(2, '.', ' ') }} {% else %} 0.00 {% endif %}</th>
					<th style="text-align:right;border-top: 2px solid #666666">
						{% if final_cust_amount != 0 %}
							{{ (((final_cust_amount - cust_partner_amount)/final_cust_amount)*100)|number_format(2, '.', ' ') }}
						{% else %}
							0.00
						{% endif %}
					</th>
					<td></td>
				</tr>
			{% endif %}
			</table>
			{% if backgnd_proc_arr[customer.id]['gen'] == true or backgnd_proc_arr[customer.id]['report'] == true or backgnd_proc_arr[customer.id]['clear'] == true or backgnd_proc_arr[customer.id]['export'] == true %}
			<div class="progress progress-info" id="billing_progress_div_{{ customer.id }}" >
			  <div class="bar" style="width: 20%" id="billing_progress_{{ customer.id }}"></div>
			</div>
			{% else %}
			<div class="progress progress-info" style="display:none" id="billing_progress_div_{{ customer.id }}" >
			  <div class="bar" style="width: 20%" id="billing_progress_{{ customer.id }}"></div>
			</div>
			{% endif %}
			{% set invoice_id = d2_customer_billed(customer.id, year, month) %}
			{% set must_credit_note = d2_customer_must_credit_note(customer.id, year, month) %}
			{% set credit_note_id = d2_customer_credit_note(customer.id, year, month) %}
			
			{# WHEN WAYBILLS TO BILL #}
			{% if cust_coverage != 0 %}
			<div>
				{% if is_granted('ROLE_ADMIN_BILLING_RUN_MANAGE') and backgnd_proc_arr[customer.id]['gen'] != true and backgnd_proc_arr[customer.id]['report'] != true and backgnd_proc_arr[customer.id]['clear'] != true %}
					{% if total_not_processed_cnt != 0 %}
						{% if are_unassigned == true or are_alerted == true or is_rule_covered == false %}
						{# <a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-warning pull-left" style="margin-right:10px">Download</a> #}
						<div class="dropdown  pull-left">
							<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
							<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
								{% if export_exists == true %}<li><a href="/uploads/billing/{{ customer.id }}/billing_export_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Export</a></li>{% endif %}
								<li><a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})">Generate Export</a></li>
							</ul>
						</div>
						
						{% if ok_to_edit %}<a href="javascript:BillingImport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-warning pull-left" style="margin-right:10px">Upload</a>{% endif %}
						{% if ok_to_edit %}<a href="javascript:BillingRun({{ customer.id }}, {{ total_coverage }}, {{ total_report_coverage }})" class="btn btn-large btn-warning pull-right">Generate</a>{% endif %}
						{% if cust_arr[customer.id]['got_bulk_editors'] == true and cust_arr[customer.id]['bulk_edit_status'] == false %}
						<a href="javascript:BillingBulkEdit({{ customer.id }}, {{ total_bulk_edit_coverage }})" class="btn btn-large btn-warning pull-right" style="margin-right:10px">Bulk Edit</a>
						{% endif %}
						{% else %}
						{# <a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-primary pull-left" style="margin-right:10px">Download</a> #}
						<div class="dropdown  pull-left">
							<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
							<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
								{% if export_exists == true %}<li><a href="/uploads/billing/{{ customer.id }}/billing_export_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Export</a></li>{% endif %}
								<li><a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})">Generate Export</a></li>
							</ul>
						</div>
						
						{# <a href="" class="btn btn-large btn-primary pull-left" style="margin-right:10px">Upload</a> #}
						{% if ok_to_edit %}<a href="javascript:BillingRun({{ customer.id }}, {{ total_coverage }}, {{ total_report_coverage }})" class="btn btn-large btn-primary pull-right">Generate</a>{% endif %}
						{% if  cust_arr[customer.id]['got_bulk_editors'] == true and cust_arr[customer.id]['bulk_edit_status'] == false %}
						<a href="javascript:BillingBulkEdit({{ customer.id }}, {{ total_bulk_edit_coverage }})" class="btn btn-large btn-primary pull-right" style="margin-right:10px">Bulk Edit</a>
						{% endif %}
						{% endif %}
					{% else %}
						{% if total_not_processed_cnt == 0 and (invoice_id == false or (must_credit_note == true and credit_note_id == false)) %}
							{% if ok_to_edit %}<a href="javascript:ClearBillingRun({{ customer.id }}, {{ total_coverage }})" class="btn btn-large btn-warning pull-left" style="margin-right:10px">Clear</a>{% endif %}
							{% if cust_arr[customer.id]['report_status'] == true %}
							{# <a href="/uploads/billing/{{ customer.id }}/month_end_report_{{ month }}_{{ year }}.xlsx" class="btn btn-large btn-success pull-left" style="margin-right:10px">View Report</a> #}
							<div class="dropdown  pull-left">
								<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Report <span class="caret"></span></a>
								<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
									{% if report_exists == true %}
										<li><a href="/uploads/billing/{{ customer.id }}/billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Report</a></li>
										<li><a href="/uploads/billing/{{ customer.id }}/check_billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}_do_not_send.xlsx">View Check Report</a></li>
									{% endif %}
									<li><a href="javascript:BillingReport({{ customer.id }}, {{ total_report_coverage }})">Generate Report</a></li>
								</ul>
							</div>
							{% else %}
							<a href="javascript:BillingReport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-success pull-left" style="margin-right:10px">Generate Report</a>
							{% endif %}
							{# <a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-primary pull-left" style="margin-right:10px">Download</a> #}
							<div class="dropdown  pull-left">
								<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
								<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
									{% if export_exists == true %}<li><a href="/uploads/billing/{{ customer.id }}/billing_export_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Export</a></li>{% endif %}
									<li><a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})">Generate Export</a></li>
								</ul>
							</div>
							
							{% if ok_to_edit %}<a href="javascript:BillingImport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-warning pull-left" style="margin-right:10px">Upload</a>{% endif %}
							{% if invoice_id == false %}
							{% if ok_to_edit %}<a href="javascript:GenerateInvoice({{ customer.id }})" class="btn btn-large btn-success pull-right" style="margin-right:10px">Invoice</a>{% endif %}
							{% else %}
							<a href="{{ path('invoices_show', { 'id': invoice_id }) }}"  class="btn btn-large btn-success pull-left" style="margin-right:10px">Invoice: {{ d2_customer_billed_invoice(invoice_id) }}</a>					
							{% endif %}
							{% if must_credit_note == true and credit_note_id == false%}
							<a href="javascript:GenerateCreditNote({{ customer.id }})" class="btn btn-large btn-success pull-right" style="margin-right:10px">Credit Note</a>
							{% elseif credit_note_id != false %}
							<a href="{{ path('credit_notes_show', { 'id': credit_note_id }) }}"  class="btn btn-large btn-success pull-left" style="margin-right:10px">Credit Note: {{ d2_customer_billed_credit_note(credit_note_id) }}</a>					
							{% endif %}
						{% else %}
							{% if ok_to_edit %}<a href="javascript:ReRunBilling({{ customer.id }},  {{ total_coverage }})" class="btn btn-large btn-danger pull-left" style="margin-right:10px">Reset</a>{% endif %}
							<a href="{{ path('invoices_show', { 'id': invoice_id }) }}"  class="btn btn-large btn-success pull-left" style="margin-right:10px">Invoice: {{ d2_customer_billed_invoice(invoice_id) }}</a>					
							{% if credit_note_id != false %}
							<a href="{{ path('credit_notes_show', { 'id': credit_note_id }) }}"  class="btn btn-large btn-success pull-left" style="margin-right:10px">Credit Note: {{ d2_customer_billed_credit_note(credit_note_id) }}</a>					
							{% endif %}
							{# <a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-primary pull-left" style="margin-right:10px">Download</a> #}
							<div class="dropdown  pull-left">
								<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
								<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
									{% if export_exists == true %}<li><a href="/uploads/billing/{{ customer.id }}/billing_export_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Export</a></li>{% endif %}
									<li><a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})">Generate Export</a></li>
								</ul>
							</div>
							
							{% if cust_arr[customer.id]['report_status'] == true %}
							{# <a href="/uploads/billing/{{ customer.id }}/month_end_report_{{ month }}_{{ year }}.xlsx" class="btn btn-large btn-success pull-left" style="margin-right:10px">View Report</a> #}
							<div class="dropdown  pull-left">
								<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Report <span class="caret"></span></a>
								<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
									{% if report_exists == true %}
									<li><a href="/uploads/billing/{{ customer.id }}/billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Report</a></li>
									<li><a href="/uploads/billing/{{ customer.id }}/check_billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}_do_not_send.xlsx">View Check Report</a></li>
									{% endif %}
									<li><a href="javascript:BillingReport({{ customer.id }}, {{ total_report_coverage }})">Generate Report</a></li>
								</ul>
							</div>
							
							<div class="dropdown  pull-left">
								<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Attachments <span class="caret"></span></a>
								<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
									<li><a href="{{ path('billing_attachment_new', { 'id': customer.id, 'month': month, 'year': year }) }}"><b>Upload Attachment</b></a></li>
									{% for attachment in attachment_arr %}
										{% if attachment['cust_id'] == customer.id %}
										<li class="divider"></li>
										<li><a href="{{ attachment['path'] }}"><b>View</b> {{ attachment['name'] }}</a></li>
										<li><a href="javascript:DeleteAttachment({{ attachment['id'] }})"><b>Delete</b> {{ attachment['name'] }}</a></li>
										{% endif %}
									{% endfor %}
								</ul>
							</div>
							{# <a href="javascript:CheckBillingEmailStatus({{ customer.id }})" class="btn btn-large btn-danger pull-right" style="margin-right:10px">Send</a> #}
					        <a href="javascript:DatedPdf({{ customer.id }}, '{{ backgnd_proc_arr[customer.id]['statement_date']|date('Y-m-d') }}')" class="btn btn-large btn-danger pull-right" style="margin-right:10px">Send</a>

							{% else %}
							<a href="javascript:BillingReport({{ customer.id }},  {{ total_report_coverage }})" class="btn btn-large btn-success pull-left" style="margin-right:10px">Generate Report</a>
							{% endif %}
						{% endif %}
					{% endif %}
				{% endif %}
			</div>
			{# WHEN CREDIT NOTE / GENERAL INVOICE ONLY - NO WAYBILLS TO BILL #}
			{% elseif must_credit_note == true or general_invoice_breakdown[customer.id] is defined %}
				{% if (invoice_id == false or (must_credit_note == true and credit_note_id == false)) %}
					{% if ok_to_edit %}<a href="javascript:ClearBillingRun({{ customer.id }}, {{ total_coverage }})" class="btn btn-large btn-warning pull-left" style="margin-right:10px">Clear</a>{% endif %}
					{% if cust_arr[customer.id]['report_status'] == true %}
					{# <a href="/uploads/billing/{{ customer.id }}/month_end_report_{{ month }}_{{ year }}.xlsx" class="btn btn-large btn-success pull-left" style="margin-right:10px">View Report</a> #}
					<div class="dropdown  pull-left">
						<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Report <span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							{% if report_exists == true %}
							<li><a href="/uploads/billing/{{ customer.id }}/billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Report</a></li>
							<li><a href="/uploads/billing/{{ customer.id }}/check_billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}_do_not_send.xlsx">View Check Report</a></li>
							{% endif %}
							<li><a href="javascript:BillingReport({{ customer.id }}, {{ total_report_coverage }})">Generate Report</a></li>
						</ul>
					</div>
					{% else %}
					<a href="javascript:BillingReport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-success pull-left" style="margin-right:10px">Generate Report</a>
					{% endif %}
					{# <a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-primary pull-left" style="margin-right:10px">Download</a> #}
					<div class="dropdown  pull-left">
						<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							{% if export_exists == true %}<li><a href="/uploads/billing/{{ customer.id }}/billing_export_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Export</a></li>{% endif %}
							<li><a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})">Generate Export</a></li>
						</ul>
					</div>
					
					{# <a href="javascript:BillingImport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-warning pull-left" style="margin-right:10px">Upload</a> #}
					{% if invoice_id == false %}
					{% if ok_to_edit %}<a href="javascript:GenerateInvoice({{ customer.id }})" class="btn btn-large btn-success pull-right" style="margin-right:10px">Invoice</a>{% endif %}
					{% endif %}
					{% if must_credit_note == true %}
					<a href="javascript:GenerateCreditNote({{ customer.id }})" class="btn btn-large btn-success pull-right" style="margin-right:10px">Credit Note</a>
					{% endif %}
				{% else %}
					{% if ok_to_edit %}<a href="javascript:ReRunBilling({{ customer.id }},  {{ total_coverage }})" class="btn btn-large btn-danger pull-left" style="margin-right:10px">Reset</a>{% endif %}
					<a href="{{ path('invoices_show', { 'id': invoice_id }) }}"  class="btn btn-large btn-success pull-left" style="margin-right:10px">Invoice: {{ d2_customer_billed_invoice(invoice_id) }}</a>					
					{% if credit_note_id != false %}
					<a href="{{ path('credit_notes_show', { 'id': credit_note_id }) }}"  class="btn btn-large btn-success pull-left" style="margin-right:10px">Credit Note: {{ d2_customer_billed_credit_note(credit_note_id) }}</a>					
					{% endif %}
					{# <a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})" class="btn btn-large btn-primary pull-left" style="margin-right:10px">Download</a> #}
					<div class="dropdown  pull-left">
						<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							{% if export_exists == true %}<li><a href="/uploads/billing/{{ customer.id }}/billing_export_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Export</a></li>{% endif %}
							<li><a href="javascript:BillingExport({{ customer.id }}, {{ total_report_coverage }})">Generate Export</a></li>
						</ul>
					</div>
					
					{% if cust_arr[customer.id]['report_status'] == true %}
					{# <a href="/uploads/billing/{{ customer.id }}/billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx" class="btn btn-large btn-success pull-left" style="margin-right:10px">View Report</a> #}
					<div class="dropdown  pull-left">
						<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Report <span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							{% if report_exists == true %}
							<li><a href="/uploads/billing/{{ customer.id }}/billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}.xlsx">View Report</a></li>
							<li><a href="/uploads/billing/{{ customer.id }}/check_billing_report_{{ customer.internalName }}_{{ month }}_{{ year }}_V{{ billing_ver }}_do_not_send.xlsx">View Check Report</a></li>
							{% endif %}
							<li><a href="javascript:BillingReport({{ customer.id }}, {{ total_report_coverage }})">Generate Report</a></li>
						</ul>
					</div>
					
					<div class="dropdown  pull-left">
						<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Attachments <span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							<li><a href="{{ path('billing_attachment_new', { 'id': customer.id, 'month': month, 'year': year }) }}"><b>Upload Attachment</b></a></li>
							{% for attachment in attachment_arr %}
								{% if attachment['cust_id'] == customer.id %}
								<li class="divider"></li>
								<li><a href="{{ attachment['path'] }}"><b>View</b> {{ attachment['name'] }}</a></li>
								<li><a href="javascript:DeleteAttachment({{ attachment['id'] }})"><b>Delete</b> {{ attachment['name'] }}</a></li>
								{% endif %}
							{% endfor %}
						</ul>
					</div>
					{# <a href="javascript:CheckBillingEmailStatus({{ customer.id }})" class="btn btn-large btn-danger pull-right" style="margin-right:10px">Send</a> #}
			        <a href="javascript:DatedPdf({{ customer.id }}, '{{ backgnd_proc_arr[customer.id]['statement_date']|date('Y-m-d') }}')" class="btn btn-large btn-danger pull-right" style="margin-right:10px">Send</a>
					{% else %}
					<a href="javascript:BillingReport({{ customer.id }},  {{ total_report_coverage }})" class="btn btn-large btn-success pull-left" style="margin-right:10px">Generate Report</a>
					{% endif %}
				{% endif %}
			{% endif %}
			<div class="clearfix"></div>
		</div>
		{% endif %}
	{% endfor %}

		{% set all_coverage_color = '#F5F5F5' %}
		{% if (overall_not_processed_cnt + overall_processed_cnt) != overall_coverage %}
			{% set all_coverage_color = '#F2DEDE' %}
		{% endif %}
		<div class="well">
			<h4>Billing Run Summary</h4>
			<table class="table table-condensed table-bordered">
				<tr>
					<th colspan="6"></th>
					<th colspan="1" style="text-align:center">Partner</th>
					<th colspan="3" style="text-align:center">Generated</th>
					<th colspan="3" style="text-align:center">Imported</th>
				</tr>
				<tr>
					<th style="width:190px"></th>
					<th></th>
					<th style="text-align:right; width:60px">Not Proc</th>
					<th style="text-align:right; width:60px">Proced</th>
					<th style="text-align:right; width:60px">Rules</th>
					<th style="text-align:right; width:60px">Imported</th>
					<th style="text-align:right; width:100px">Amt (excl)</th>
					<th style="text-align:right; width:100px">Amt (excl)</th>
					<th style="text-align:right; width:100px">Profit (excl)</th>
					<th style="text-align:right; width:80px">Margin</th>
					<th style="text-align:right; width:100px">Amt (excl)</th>
					<th style="text-align:right; width:100px">Profit (excl)</th>
					<th style="text-align:right; width:80px">Margin</th>
					<td style="width:50px"></td>
				</tr>
				<tr>
					<td></td>
					<td></td>
					<td style="text-align:right">{{ overall_not_processed_cnt }}</td>
					<td style="text-align:right">{{ overall_processed_cnt }}</td>
					<td style="text-align:right; background-color:{{ all_coverage_color }}">{{ overall_coverage }}</td>
					<td style="text-align:right">{{ overall_imported_cnt }}</td>
					{% if any_stats_processed == false %}
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					<td></td>
					{% else %}
					<td style="text-align:right">
						R {{ overall_partner_amount|number_format(2, '.', ' ') }}
					</td>
					<td style="text-align:right">
						R {{ overall_ma_amount|number_format(2, '.', ' ') }}
					</td>
					<td style="text-align:right">
						{% if overall_ma_amount != 0 %}
							R {{(overall_ma_amount - overall_partner_amount)|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						{% if overall_ma_amount != 0 %}
							{{ (((overall_ma_amount - overall_partner_amount)/overall_ma_amount)*100)|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						R {{ overall_bm_amount|number_format(2, '.', ' ') }}
					</td>
					<td style="text-align:right">
						{% if overall_bm_amount != 0 %}
							R {{(overall_bm_amount - imported_overall_partner_amount)|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</td>
					<td style="text-align:right">
						{% if overall_bm_amount != 0 %}
							{{ (((overall_bm_amount - imported_overall_partner_amount)/overall_bm_amount)*100)|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</td>
					{% endif %}
					<td style="text-align:right">
					</td>
				</tr>
				<tr>
					<td></td>
					<td></td>
					<td colspan="7"></td>
					<th style="text-align:right;border-top: 2px solid #666666">TOTAL:</th>
					<th style="text-align:right;border-top: 2px solid #666666">
						R {{ overall_final_amount|number_format(2, '.', ' ') }}
					</th>
					<th style="text-align:right;border-top: 2px solid #666666">
						{% if overall_final_amount != 0 %}
							R {{(overall_final_amount - overall_partner_amount)|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</th>
					<th style="text-align:right;border-top: 2px solid #666666">
						{% if overall_final_amount != 0 %}
							{{ (((overall_final_amount - overall_partner_amount)/overall_final_amount)*100)|number_format(2, '.', ' ') }}
						{% else %}
							R 0.00
						{% endif %}
					</th>
					<td style="text-align:right">
					</td>
				</tr>
			</table>
		</div>
		{% if show_global_export_import == true %}
		<div class="well">
			<h4>Billing Import / Export V{{ billing_global_version }}</h4>
            <table>
				<tr>
					<td style="width:100px">Sort Mode</td>
					<td>
						<select name="export_sort_mode" id="export_sort_mode">
						{% set opts = {'1':"service/chrg weight/cost", '2':"date sent/waybill number"} %}
						{% for k, v in opts %}<option value="{{ k }}" {{ month is sameas(k|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
						</select>
					</td>
				</tr>
            </table>
            
			{% set cnt = 0 %}
			{% set row_cnt = 0 %}
			{% set rows_per_cnt = (displayed_customer_cnt/3)|round(0, 'ceil') %}
			{% if all_customers|length > 0 %}
				{% for customer in all_customers %}
					{% if show_cust_billing[customer.getId] == true %}
						{% if cnt == 0 %}
							<table class="table table-condensed">
								<tr><td style="width:33%">
									<table class="table table-condensed table-extra-condensed table-bordered">
						{% elseif cnt == rows_per_cnt %}
									</table>
							
							{% set row_cnt = row_cnt + 1 %}
							{% if row_cnt == 3 %}	
								</td></tr>
							</table>
							<table class="table table-condensed table-extra-condensed table-bordered">
								<tr><td>
							{% set row_cnt = 0 %}
							{% else %}
								</td><td>
							{% endif %}
											
									<table class="table table-condensed table-extra-condensed table-bordered">
							{% set cnt = 0 %}
						{% endif %}
						<tr><td>{{ customer.internalName }}</td><td><img class="select_customer" data-customer= "{{ customer.id }}" src="{{ asset('bundles/d2core/images/tick.png') }}" title="Active" alt="Active" width="15" /></td></tr>
						{% set cnt = cnt + 1 %}
					{% endif %}
				{% endfor %}
								</table>
							</td></tr>
						</table>
			{% endif %}
			<div class="clearfix"></div>

			<div class="progress progress-info" style="display:none" id="all_billing_progress_div" >
			  <div class="bar" style="width: 20%" id="all_billing_progress"></div>
			</div>

			{% set zip_exists = d2_check_zip_all_ver(billing_global_version, month, year) %}
			<div class="dropdown  pull-right">
				<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Billing ZIP<span class="caret"></span></a>
				<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
					{% if zip_exists == true %}<li><a href="/uploads/billing/all_billing_zip_{{ month }}_{{ year }}_V{{ billing_global_version }}.zip">View ZIP</a></li>{% endif %}
					<li><a href="javascript:AllBillingZip()">Generate ZIP</a></li>
				</ul>
			</div>

			{# <a href="javascript:AllBillingExport({{ overall_coverage }})" class="btn btn-large btn-primary pull-right" style="margin-right:10px">Download</a> #}
			{% set export_exists = d2_check_export_all_ver(billing_global_version, month, year) %}
			<div class="dropdown  pull-right">
				<a class="btn btn-large btn-success dropdown-toggle" data-toggle="dropdown" style="margin-right:10px">Download<span class="caret"></span></a>
				<ul class="dropdown-menu" role="menu" aria-labelledby="dLabel">
					{% if export_exists == true %}<li><a href="/uploads/billing/all_billing_export_{{ month }}_{{ year }}_V{{ billing_global_version }}.xlsx">View Export</a></li>{% endif %}
					<li><a href="javascript:AllBillingExport({{ overall_coverage }})">Generate Export</a></li>
				</ul>
			</div>
			
			{% if ok_to_edit == true %}
			<a href="javascript:AllBillingImport({{ overall_coverage }})" class="btn btn-large btn-warning pull-right" style="margin-right:10px">Upload</a>
			<a href="javascript:ClearAllBillingRun({{ overall_coverage }})" class="btn btn-large btn-default pull-right" style="margin-right:60px">Clear All Customers</a>
			<a href="javascript:AllBillingRun({{ overall_coverage }})" class="btn btn-large btn-default pull-right" style="margin-right:10px">Generate All Customers</a>
			{% endif %}

			<div class="clearfix"></div>
		</div>
		{% endif %}
	
{% endif %}
{% else %}
	<div class="alert alert-warning text-center">There is currently no waybill data available for processing!</div>
{% endif %}
{% endblock content %}