{% extends '::email.html.twig' %}

{% block subject %}
{{ subject }}
{% endblock %}

{% block body %}
<script type="text/javascript" src="{{ script_path }}"></script>
<style>
table {  
    color: #333;
    font-family: Helvetica, Arial, sans-serif;
    font-size: 10pt;
    border-collapse: 
    collapse; border-spacing: 0; 
    text-align: left;
}

td, th {  
    border: 1px solid white; /* No more visible border */
    height: 30px; 
    text-align: left;
}

th {  
    background: #DFDFDF;  /* Darken header a bit */
    font-weight: bold;
}

td {  
    background: #FAFAFA;
}

/* Cells in even rows (2,4,6...) are one color */        
tr:nth-child(even) td { background: #F1F1F1; }   

/* Cells in odd rows (1,3,5...) are another (excludes header cells)  */        
tr:nth-child(odd) td { background: #FEFEFE; }  

</style>

<h1 style="text-align:center">{{ type|title }} Report - {{ month_str }} {{ year }}</h1>

<div style="margin-left:20px; margin-top:30px">
	<div style="margin-left:50px">
	<table class="table" style="width:80%; margin-top:20px">
		{% set waybill_total = 0 %}
		{% set pcs_total = 0 %}
		{% set mass_total = 0 %}
		{% set excl_total = 0 %}
		{% set vat_total = 0 %}
		{% set incl_total = 0 %}
		{% set ma_excl_total = 0 %}
		{% set ma_vat_total = 0 %}
		{% set ma_incl_total = 0 %}
		<tr><th colspan="11" style="text-align:center">All Partner Breakdown</th></tr>
		<tr><th style="width:25%">Partner</th><th style="text-align:right">Waybills</th><th style="text-align:right">Pieces</th><th style="text-align:right">Chrg Mass</th><th style="text-align:right">Excl Vat</th><th style="text-align:right">Vat</th><th style="text-align:right">Inc Vat</th><th style="text-align:right">MA Excl Vat</th><th style="text-align:right">MA Vat</th><th style="text-align:right">MA Inc Vat</th><th style="text-align:right">Markup</th></tr>
		{% for partner in partner_data %}
		{% set waybill_total = waybill_total + partner['waybills'] %}
		{% set pcs_total = pcs_total + partner['pcs'] %}
		{% set mass_total = mass_total + partner['mass'] %}
		{% set excl_total = excl_total + partner['sub_total'] %}
		{% set vat_total = vat_total + partner['vat'] %}
		{% set incl_total = incl_total + partner['total'] %}
		{% set ma_excl_total = ma_excl_total + partner['ma_sub_total'] %}
		{% set ma_vat_total = ma_vat_total + partner['ma_vat'] %}
		{% set ma_incl_total = ma_incl_total + partner['ma_total'] %}
		{% if partner['ma_sub_total'] > 0 %}
		{% set markup = ((partner['ma_sub_total'] - partner['sub_total'])/partner['ma_sub_total'])*100 %}
		{% else %}
		{% set markup = 0.00 %}
		{% endif %}
		<tr>
			<td>{{ partner['name'] }}</td><td style="text-align:right">{{ partner['waybills'] }}</td><td style="text-align:right">{{ partner['pcs'] }}</td><td style="text-align:right">{{ partner['mass']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ partner['sub_total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ partner['vat']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ partner['total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ partner['ma_sub_total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ partner['ma_vat']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ partner['ma_total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ markup|number_format(2, '.', '') }}</td>
		</tr>
		{% endfor %}
		{% if ma_excl_total > 0 %}
		{% set total_markup = ((ma_excl_total - excl_total)/ma_excl_total)*100 %}
		{% else %}
		{% set total_markup = 0.00 %}
		{% endif %}
		<tr>
			<th></th><th style="text-align:right">{{ waybill_total }}</th><th style="text-align:right">{{ pcs_total }}</th><th style="text-align:right">{{ mass_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ excl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ vat_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ incl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ ma_excl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ ma_vat_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ ma_incl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ total_markup|number_format(2, '.', '') }}</th>
		</tr>
	</table>


	<table class="table" style="width:80%; margin-top:20px">
		{% set waybill_total = 0 %}
		{% set pcs_total = 0 %}
		{% set mass_total = 0 %}
		{% set excl_total = 0 %}
		{% set vat_total = 0 %}
		{% set incl_total = 0 %}
		{% set ma_excl_total = 0 %}
		{% set ma_vat_total = 0 %}
		{% set ma_incl_total = 0 %}
		<tr><th colspan="11" style="text-align:center">All Customer Breakdown</th></tr>
		<tr><th style="width:25%">Customer</th><th style="text-align:right">Waybills</th><th style="text-align:right">Pieces</th><th style="text-align:right">Chrg Mass</th><th style="text-align:right">Excl Vat</th><th style="text-align:right">Vat</th><th style="text-align:right">Inc Vat</th><th style="text-align:right">MA Excl Vat</th><th style="text-align:right">MA Vat</th><th style="text-align:right">MA Inc Vat</th><th style="text-align:right">Markup</th></tr>
		{% for cust in customer_data %}
		{% set waybill_total = waybill_total + cust['waybills'] %}
		{% set pcs_total = pcs_total + cust['pcs'] %}
		{% set mass_total = mass_total + cust['mass'] %}
		{% set excl_total = excl_total + cust['sub_total'] %}
		{% set vat_total = vat_total + cust['vat'] %}
		{% set incl_total = incl_total + cust['total'] %}
		{% set ma_excl_total = ma_excl_total + cust['ma_sub_total'] %}
		{% set ma_vat_total = ma_vat_total + cust['ma_vat'] %}
		{% set ma_incl_total = ma_incl_total + cust['ma_total'] %}
		{% if cust['ma_sub_total'] > 0 %}
		{% set markup = ((cust['ma_sub_total'] - cust['sub_total'])/cust['ma_sub_total'])*100 %}
		{% else %}
		{% set markup = 0.00 %}
		{% endif %}
		<tr>
			<td>{{ cust['name'] }}</td><td style="text-align:right">{{ cust['waybills'] }}</td><td style="text-align:right">{{ cust['pcs'] }}</td><td style="text-align:right">{{ cust['mass']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ cust['sub_total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ cust['vat']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ cust['total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ cust['ma_sub_total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ cust['ma_vat']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ cust['ma_total']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ markup|number_format(2, '.', '') }}</td>
		</tr>
		{% endfor %}
		{% if ma_excl_total > 0 %}
		{% set total_markup = ((ma_excl_total - excl_total)/ma_excl_total)*100 %}
		{% else %}
		{% set total_markup = 0.00 %}
		{% endif %}
		<tr>
			<th></th><th style="text-align:right">{{ waybill_total }}</th><th style="text-align:right">{{ pcs_total }}</th><th style="text-align:right">{{ mass_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ excl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ vat_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ incl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ ma_excl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ ma_vat_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ ma_incl_total|number_format(2, '.', '') }}</th><th style="text-align:right">{{ total_markup|number_format(2, '.', '') }}</th>
		</tr>
	</table>

	<table class="table" style="width:80%; margin-top:20px">
		<tr><th colspan="7" style="text-align:center">Waybill Quotations</th></tr>
		<tr><th>Customer</th><th>Waybill</th><th>Amount</th><th>Quotation</th><th>Info</th><th>Amount</th><th>Markup</th></tr>
		{% for item in quoted_info %}
		<tr>
			<td>{{ item['customer']|trim }}</td>
			<td>{{ item['waybill'] }}</td>
			<td style="text-align:right">{{ item['waybill_amount']|number_format(2, '.', ' ') }}</td>
			<td>{{ item['quote_num'] }}</td>
			<td>{{ item['quote_info']|trim }}</td>
			<td style="text-align:right">{{ item['quote_amount']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ (((item['quote_amount'] - item['waybill_amount'])/item['waybill_amount']) * 100)|number_format(2, '.', ' ') }}%</td>
		</tr>
		{% endfor %}
	</table>

	<table class="table" style="width:80%; margin-top:20px">
		<tr><th colspan="7" style="text-align:center">Early Invoiced Waybills</th></tr>
		<tr><th>Customer</th><th>Waybill</th><th>Amount</th><th>Invoice</th><th>Info</th><th>Amount</th><th>Markup</th></tr>
		{% for item in invoiced_info %}
		<tr>
			<td>{{ item['customer']|trim }}</td>
			<td>{{ item['waybill'] }}</td>
			<td style="text-align:right">{{ item['waybill_amount']|number_format(2, '.', ' ') }}</td>
			<td>{{ item['quote_num'] }}</td>
			<td>{{ item['quote_info']|trim }}</td>
			<td style="text-align:right">{{ item['quote_amount']|number_format(2, '.', ' ') }}</td>
			<td style="text-align:right">{{ (((item['quote_amount'] - item['waybill_amount'])/item['waybill_amount']) * 100)|number_format(2, '.', ' ') }}%</td>
		</tr>
		{% endfor %}
	</table>
	</div>

	<div>
	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">Esculated Waybills</th></tr>
		<tr>
			<th>Partner</th>
			<th>Account</th>
			<th>Customer</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in esculated_data %}
		<tr>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{{ wb.customer_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
					<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
					{% if wb.early_invoiced %}
					{% if quote.invoice is not null %}
					<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
					{% endif %}
					{% endif %}
					{% endif %}
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>

	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">International Waybills</th></tr>
		<tr>
			<th>Customer</th>
			<th>Partner</th>
			<th>Account</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in international_data %}
		<tr>
			<td>{{ wb.customer_name }}</td>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
					<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
					{% if wb.early_invoiced %}
					{% if quote.invoice is not null %}
					<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
					{% endif %}
					{% endif %}
					{% endif %}
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>

	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">Credited Waybills</th></tr>
		<tr>
			<th>Customer</th>
			<th>Partner</th>
			<th>Account</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in credited_data %}
		<tr>
			<td>{{ wb.customer_name }}</td>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
					<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
					{% if wb.early_invoiced %}
					{% if quote.invoice is not null %}
					<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
					{% endif %}
					{% endif %}
					{% endif %}
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>

	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">Credit Requested Waybills</th></tr>
		<tr>
			<th>Customer</th>
			<th>Partner</th>
			<th>Account</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in credit_requested_data %}
		<tr>
			<td>{{ wb.customer_name }}</td>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
					<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
					{% if wb.early_invoiced %}
					{% if quote.invoice is not null %}
					<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
					{% endif %}
					{% endif %}
					{% endif %}
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>


	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">Quoted Waybills</th></tr>
		<tr>
			<th>Customer</th>
			<th>Partner</th>
			<th>Account</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in quoted_data %}
		<tr>
			<td>{{ wb.customer_name }}</td>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
						<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
						{% if wb.early_invoiced %}
							{% if quote.invoice is not null %}
							<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
							{% endif %}
						{% endif %}
					{% else %}
					QUOTE NULL
					{% endif %}
				{% else %}
				QUOTE NOT FLAG
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>


	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">Early Invoiced Waybills</th></tr>
		<tr>
			<th>Customer</th>
			<th>Partner</th>
			<th>Account</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in invoiced_data %}
		<tr>
			<td>{{ wb.customer_name }}</td>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
					<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
					{% if wb.early_invoiced %}
					{% if quote.invoice is not null %}
					<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
					{% endif %}
					{% endif %}
					{% endif %}
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>

	<table class="table" style="width:100%; margin-top:20px; font-size:7pt">
		<tr><th colspan="23" style="text-align:center">Un-Billable Waybills</th></tr>
		<tr>
			<th>Customer</th>
			<th>Partner</th>
			<th>Account</th>
			<th>Date</th>
			<th>Waybill</th>
			<th>Service</th>
			<th>Level</th>
			<th>Esculation</th>
			<th>Ref</th>
			<th>Sender</th>
			<th>Orig</th>
			<th>Receiver</th>
			<th>Dest</th>
			<th style="text-align:right">Pcs</th>
			<th style="text-align:right">Act Mass</th>
			<th style="text-align:right">Chrg Mass</th>
			<th style="text-align:right">Basic</th>
			<th style="text-align:right">Other</th>
			<th style="text-align:right">R/KG</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">Markup</th>
		</tr>
		{% for wb in un_billable_waybills %}
		<tr>
			<td>{{ wb.customer_name }}</td>
			<td>{{ wb.partner_name }}</td>
			<td>{{ wb.ma_account_name }}</td>
			<td>{% if wb.waybill_date is not null %} {{ wb.waybill_date|date("Y/m/d") }} {% endif %}</td>
			<td>{{ wb.waybill }}</td>
			<td>{{ wb.service }}</td>
			<td>{% if wb.esculation_level != 0 %}{{ wb.esculation_level }}{% endif %}</td>
			<td>
				{{ wb.esculation }}
				
				{% if wb.credit_request_number is not null %}
				<br/><b>[CREDIT REQUEST: {{ wb.credit_request_number }} R{{ wb.credit_req_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_req_vat|number_format(2, '.', '') }} R{{ wb.credit_req_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}

				{% if wb.credit_note_number is not null %}
				<br/><b>[CREDIT NOTE: {{ wb.credit_note_number }} R{{ wb.credit_ex_vat|number_format(2, '.', '') }} R{{ wb.credit_vat|number_format(2, '.', '') }} R{{ wb.credit_inc_vat|number_format(2, '.', '') }}]</b>
				{% endif %}
				
				{% if wb.quoted %}
					{% set quote = d2_waybill_quote(wb.waybill) %}
					{% if quote is not null %}
					<br/><b>[QUOTE: {{ quote.docNo }} R{{ quote.total|number_format(2, '.', '') }}</b>
					{% if wb.early_invoiced %}
					{% if quote.invoice is not null %}
					<br/><b>[INVOICE: {{ quote.invoice.docNo }} R{{ quote.invoice.total|number_format(2, '.', '') }}</b>
					{% endif %}
					{% endif %}
					{% endif %}
				{% endif %}
			</td>
			<td>{{ wb.ref1 }}{% if wb.ref2|trim != '' %}/{{ wb.ref2 }}{% endif %}</td>
			<td>{{ wb.sender }}</td>
			<td>{{ wb.orig }}</td>
			<td>{{ wb.receiver }}</td>
			<td>{{ wb.dest }}</td>
			<td style="text-align:right">{{ wb.pcs }}</td>
			<td style="text-align:right">{{ wb.act_mass|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.mass_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.basic_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.other_chrg|number_format(2, '.', '') }}</td>
			<td style="text-align:right">{{ wb.cost_per_kg|number_format(1, '.', '') }}</td>
			{% if wb.markup_sub_total == 0.00 and wb.markup_vat == 0.00 and wb.markup_total == 0.00 %}
				{% set markup_color = 'red' %}
			{% else %}
				{% set markup_color = 'black' %}
			{% endif %}
			<td style="text-align:right">{{ wb.sub_total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_sub_total|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.vat_ex|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_vat|number_format(2, '.', '') }}</span></b></td>
			<td style="text-align:right">{{ wb.total|number_format(2, '.', '') }}<br/><b><span style="color:{{ markup_color }}">{{ wb.markup_total|number_format(2, '.', '') }}</span></b></td>
			{% if wb.sub_total > 0.00 %}
			{% set wb_markup = ((wb.markup_sub_total - wb.sub_total)/wb.sub_total)*100 %}
			{% else %}
			{% set wb_markup = 0.00 %}
			{% endif %}
			<td style="text-align:right{% if wb_markup <= 0.00 %}; color:red{% endif %}" title="{{ wb.formula }}">{{ wb_markup|number_format(2, '.', '') }}%</td>
		</tr>
		{% endfor %}
	</table>

	</div>

	{% if cust_graph_links|length > 0 %}
	<h1 style="text-align:center;margin-top:30px">Customer Reports</h1>
    {% for key,link in cust_graph_links %}
	<div>
		<table style="width:100%">
		<tr>
			<td style="width:25%"><img src="{{ link }}" style="width:100%" alt="Chart Image" /></td>
			<td style="width:25%"><img src="{{ billing_graph_links[key]['cost_per_kg'] }}" style="width:100%" alt="Chart Image" /></td>
			<td style="width:25%"><img src="{{ billing_graph_links[key]['sales'] }}" style="width:100%" alt="Chart Image" /></td>
			<td style="width:25%"><img src="{{ billing_graph_links[key]['margin'] }}" style="width:100%" alt="Chart Image" /></td>
		</tr>
		</table>
	</div>
    {% endfor %}
    {% endif %}
</div>

{% endblock %}