{% 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 src="{{ asset('bundles/d2billing/js/billing_report.js') }}" type="text/javascript"></script>
<script type="text/javascript" src="{{ asset('bundles/d2core/Chart.js-master/Chart.min.js') }}"></script>
{% endblock head_script_extra %}
    
{% block page_header %}
    <div class="pull-left">
        <code>Billing Report</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', 'customers'] %}
				<input type="hidden" name="{{ k }}" value="{{ v }}" />
			{% endif %}
		{% endfor %}
        <div class="filter">
			<label class="sr-only" for="customers">Customers</label>
			<input type="text" class="form-control" name="customers" id="filter_customers" placeholder="Search for" style="width:200px" value="{{ app.request.get('customers') }}">
            <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 }}">

<div class="well">
<h4>Period Totals: {{ months[month] }} {{ year }}</h4>
<table class="table table-bordered table-condensed table-extra-condensed">
	<tr>
		<th colspan="4"></th><th colspan="3" style="text-align:center">Partner</th><th colspan="3" style="text-align:center">Move Analytics</th><th></th>
	</tr>
	<tr>
		<th>Customer</th><th>Waybills</th><th>Pieces</th><th>Mass Charged</th><th>Sub Total</th><th>Vat</th><th>Total</th><th>Sub Total</th><th>Vat</th><th>Total</th><th>Markup</th>
	</tr>
	{% for indx, stat in customer_breakdown %}
	<tr>
		<th style="text-align:left">{{ stat['customer'] }}</th>
		<td style="text-align:right">{{ stat['waybill_cnt'] }}</td>
		<td style="text-align:right">{{ stat['pcs'] }}</td>
		<td style="text-align:right">{{ stat['mass_charged']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{{ stat['orig_sub_total']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{{ stat['orig_vat']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{{ stat['orig_total']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{{ stat['total_amount_exl']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{{ stat['total_amount_vat']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{{ stat['total_amount_inc']|number_format(2, '.', '') }}</td>
		<td style="text-align:right">{% if stat['total_amount_exl'] != 0 %}{{ (((stat['total_amount_exl']-stat['orig_sub_total'])/stat['total_amount_exl'])*100)|number_format(2, '.', '') }}%{% endif %}</td>
	</tr>
	{% endfor %}
	<tr>
		<th></th>
		<th style="text-align:right">{{ all_totals['waybill_cnt'] }}</th>
		<th style="text-align:right">{{ all_totals['pcs'] }}</th>
		<th style="text-align:right">{{ all_totals['mass_charged']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{{ all_totals['orig_sub_total']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{{ all_totals['orig_vat']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{{ all_totals['orig_total']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{{ all_totals['total_amount_exl']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{{ all_totals['total_amount_vat']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{{ all_totals['total_amount_inc']|number_format(2, '.', '') }}</th>
		<th style="text-align:right">{% if all_totals['total_amount_exl'] != 0 %}{{ (((all_totals['total_amount_exl']-all_totals['orig_sub_total'])/all_totals['total_amount_exl'])*100)|number_format(2, '.', '') }}%{% endif %}</th>
	</tr>
	<tr>
		<th style="text-align:right" colspan="10">Profit:</th>
		<th style="text-align:right">{{ (all_totals['total_amount_exl'] - all_totals['orig_sub_total'])|number_format(2, '.', '') }}</th>
	</tr>
</table>
</div>

<div class="well">
<h4>Billing Coverage: {{ months[month] }} {{ year }}</h4>
<table class="table table-bordered table-condensed table-extra-condensed">
	<tr>
		<th></th>
		{% for partner in all_partners %}
		<th>{{ partner.getInternalName }}</th>
		{% endfor %}
	</tr>
		{% for c_indx, recon in billing_recon %}
	<tr>
		<th>{{ c_indx }}</th>
		{% for partner in all_partners %}
		{% if billing_recon[c_indx][partner.getInternalName] > 0 %}
		<th>{{ billing_recon[c_indx][partner.getInternalName] }}</th>
		{% else %}
		<td>{{ billing_recon[c_indx][partner.getInternalName] }}</td>
		{% endif %}
		{% endfor %}
	</tr>
		{% endfor %}
	<tr>
		<th></th>
		{% for partner in all_partners %}
		{% if partner_recon_totals[partner.getInternalName] != waybill_cnts[partner.getInternalName] %}
		<th class="text-error">{{ partner_recon_totals[partner.getInternalName] }} / {{ waybill_cnts[partner.getInternalName] }}</th>
		{% else %}
		<th class="text-success">{{ partner_recon_totals[partner.getInternalName] }}</th>
		{% endif %}
		{% endfor %}
	</tr>
</table>
</div>

<div class="well">
<h4>Year to Date: {{ year }}</h4>
{% for indx, margin_stat in customer_margins %}
{% if margin_stat[1]['customer'] != '' %}<code style="background-color: {{ margin_stat[1]['color'] }}; color:#000000" >{{ margin_stat[1]['customer'] }}</code>{% endif %}
{% endfor %}
<table style="width:100%">
	<tr>
		<td>
			<h4>Customer Margins</h4>
			<div class="canvas-holder"><canvas id="margins_lineChart" width="600" height="200"></canvas></div>
		</td>
		<td>
			<h4>Customer ex Vat</h4>
			<div class="canvas-holder"><canvas id="income_lineChart" width="600" height="200"></canvas></div>
		</td>
	</tr>
	<tr>
		<td>
			<h4>Waybills</h4>
			<div class="canvas-holder"><canvas id="waybills_lineChart" width="600" height="200"></canvas></div>
		</td>
		<td>
			<h4>Partner ex Vat</h4>
			<div class="canvas-holder"><canvas id="outgoing_lineChart" width="600" height="200"></canvas></div>
		</td>
	</tr>
	<tr>
		<td>
			<h4>Pieces Shipped</h4>
			<div class="canvas-holder"><canvas id="pcs_lineChart" width="600" height="200"></canvas></div>
		</td>
		<td>
			<h4>Mass Charged</h4>
			<div class="canvas-holder"><canvas id="mass_lineChart" width="600" height="200"></canvas></div>
		</td>
	</tr>
</table>
</div>

<div class="well">
<h4>Delivery Type Breakdown: {{ months[month] }} {{ year }}</h4>
<code style="background-color: #F5858B; color:#000000" >Bulk</code><code style="background-color: #BDE598; color:#000000" >Courier</code><code style="background-color: #A1CAEA; color:#000000" >Other</code>
<table style="width:100%">
	<tr>
{% for key, partner_key in partner_keys %}
		<td>
			<h5>{{ partner_key['label'] }}</h5>
			<div class="canvas-holder"><canvas id="delivery_pieChart_{{ key }}" width="200" height="200"></canvas></div>
		</td>
{% endfor %}
	</tr>
</table>
</div>

<div class="well">
<h4>Destination Type Breakdown: {{ months[month] }} {{ year }}</h4>
<code style="background-color: #F5858B; color:#000000" >Local</code><code style="background-color: #BDE598; color:#000000" >International</code><code style="background-color: #A1CAEA; color:#000000" >Other</code>
<table style="width:100%">
	<tr>
{% for key, partner_key in partner_keys %}
		<td>
			<h5>{{ partner_key['label'] }}</h5>
			<div class="canvas-holder"><canvas id="destination_pieChart_{{ key }}" width="200" height="200"></canvas></div>
		</td>
{% endfor %}
	</tr>
</table>
</div>

<div class="well">
<h4>Partner Breakdown: {{ months[month] }} {{ year }}</h4>
{% for indx, stat in partner_breakdown %}
{% if stat['partner'] != '' %}<code style="background-color: {{ stat['color'] }}; color:#000000" >{{ stat['partner'] }}</code>{% endif %}
{% endfor %}
<table style="width:100%">
	<tr>
{% for key, partner_key in partner_keys %}
		<td>
			<h5>{{ partner_key['label'] }}</h5>
			<div class="canvas-holder"><canvas id="partner_pieChart_{{ key }}" width="200" height="200"></canvas></div>
		</td>
{% endfor %}
	</tr>
</table>
</div>

<div class="well">
<h4>Customer Breakdown: {{ months[month] }} {{ year }}</h4>
{% for indx, stat in customer_breakdown %}
{% if stat['customer'] != '' %}<code style="background-color: {{ stat['color'] }}; color:#000000" >{{ stat['customer'] }}</code>{% endif %}
{% endfor %}
<table style="width:100%">
	<tr>
{% for key, partner_key in partner_keys %}
		<td>
			<h5>{{ partner_key['label'] }}</h5>
			<div class="canvas-holder"><canvas id="customer_pieChart_{{ key }}" width="200" height="200"></canvas></div>
		</td>
{% endfor %}
	</tr>
</table>
</div>

<script>

	var margins_line_ctx = $("#margins_lineChart").get(0).getContext("2d");
	var income_line_ctx = $("#income_lineChart").get(0).getContext("2d");
	var outgoing_line_ctx = $("#outgoing_lineChart").get(0).getContext("2d");
	var waybills_line_ctx = $("#waybills_lineChart").get(0).getContext("2d");
	var pcs_line_ctx = $("#pcs_lineChart").get(0).getContext("2d");
	var mass_line_ctx = $("#mass_lineChart").get(0).getContext("2d");
{% for key, partner_key in partner_keys  %}
	var partner_pie_ctx_{{ key }} = $("#partner_pieChart_{{ key }}").get(0).getContext("2d");
	var customer_pie_ctx_{{ key }} = $("#customer_pieChart_{{ key }}").get(0).getContext("2d");
	var delivery_pie_ctx_{{ key }} = $("#delivery_pieChart_{{ key }}").get(0).getContext("2d");
	var destination_pie_ctx_{{ key }} = $("#destination_pieChart_{{ key }}").get(0).getContext("2d");
{% endfor %}


	var margins_line_data = {
		labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
		datasets: [
			{% for margin_stat in customer_margins %}
			{
				label: "{{ margin_stat[1]['customer'] }}",
				fillColor: "rgba(220,220,220,0.2)",
				strokeColor: "{{ margin_stat[1]['color'] }}",
				pointColor: "{{ margin_stat[1]['color'] }}",
				pointStrokeColor: "#fff",
				pointHighlightFill: "#fff",
				pointHighlightStroke: "{{ margin_stat[1]['color'] }}",
				data: [
					{% for indx in 1..12 %}
						{% if margin_stat[indx]['total_amount_exl'] != 0 %} {{ (((margin_stat[indx]['total_amount_exl'] - margin_stat[indx]['orig_sub_total'])/margin_stat[indx]['total_amount_exl'])*100)|number_format(2, '.', '') }} {% else %} 0.00 {% endif %},
					{% endfor %}
				],
			},
			{% endfor %}
		]
	};
	var income_line_data = {
		labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
		datasets: [
			{% for margin_stat in customer_margins %}
			{
				label: "{{ margin_stat[1]['customer'] }}",
				fillColor: "rgba(220,220,220,0.2)",
				strokeColor: "{{ margin_stat[1]['color'] }}",
				pointColor: "{{ margin_stat[1]['color'] }}",
				pointStrokeColor: "#fff",
				pointHighlightFill: "#fff",
				pointHighlightStroke: "{{ margin_stat[1]['color'] }}",
				data: [
					{% for indx in 1..12 %}
						{{ margin_stat[indx]['total_amount_exl']|number_format(2, '.', '') }},
					{% endfor %}
				],
			},
			{% endfor %}
		]
	};
	var outgoing_line_data = {
		labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
		datasets: [
			{% for margin_stat in customer_margins %}
			{
				label: "{{ margin_stat[1]['customer'] }}",
				fillColor: "rgba(220,220,220,0.2)",
				strokeColor: "{{ margin_stat[1]['color'] }}",
				pointColor: "{{ margin_stat[1]['color'] }}",
				pointStrokeColor: "#fff",
				pointHighlightFill: "#fff",
				pointHighlightStroke: "{{ margin_stat[1]['color'] }}",
				data: [
					{% for indx in 1..12 %}
						{{ margin_stat[indx]['orig_sub_total']|number_format(2, '.', '') }},
					{% endfor %}
				],
			},
			{% endfor %}
		]
	};
	var waybills_line_data = {
		labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
		datasets: [
			{% for margin_stat in customer_margins %}
			{
				label: "{{ margin_stat[1]['customer'] }}",
				fillColor: "rgba(220,220,220,0.2)",
				strokeColor: "{{ margin_stat[1]['color'] }}",
				pointColor: "{{ margin_stat[1]['color'] }}",
				pointStrokeColor: "#fff",
				pointHighlightFill: "#fff",
				pointHighlightStroke: "{{ margin_stat[1]['color'] }}",
				data: [
					{% for indx in 1..12 %}
						{{ margin_stat[indx]['waybill_cnt']|number_format(2, '.', '') }},
					{% endfor %}
				],
			},
			{% endfor %}
		]
	};
	var pcs_line_data = {
		labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
		datasets: [
			{% for margin_stat in customer_margins %}
			{
				label: "{{ margin_stat[1]['customer'] }}",
				fillColor: "rgba(220,220,220,0.2)",
				strokeColor: "{{ margin_stat[1]['color'] }}",
				pointColor: "{{ margin_stat[1]['color'] }}",
				pointStrokeColor: "#fff",
				pointHighlightFill: "#fff",
				pointHighlightStroke: "{{ margin_stat[1]['color'] }}",
				data: [
					{% for indx in 1..12 %}
						{{ margin_stat[indx]['pcs']|number_format(2, '.', '') }},
					{% endfor %}
				],
			},
			{% endfor %}
		]
	};

	var mass_line_data = {
		labels: ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
		datasets: [
			{% for margin_stat in customer_margins %}
			{
				label: "{{ margin_stat[1]['customer'] }}",
				fillColor: "rgba(220,220,220,0.2)",
				strokeColor: "{{ margin_stat[1]['color'] }}",
				pointColor: "{{ margin_stat[1]['color'] }}",
				pointStrokeColor: "#fff",
				pointHighlightFill: "#fff",
				pointHighlightStroke: "{{ margin_stat[1]['color'] }}",
				data: [
					{% for indx in 1..12 %}
						{{ margin_stat[indx]['mass_charged']|number_format(2, '.', '') }},
					{% endfor %}
				],
			},
			{% endfor %}
		]
	};

{% for key, partner_key in partner_keys  %}
	var partner_pie_data_{{ key }} = [
			{% for indx, stat in partner_breakdown %}
			{
				label: "{{ stat['partner'] }}",
				color: "{{ stat['color'] }}",
				highlight: "{{ stat['color'] }}",
				value: {{ stat[key]|number_format(2, '.', '') }}
			},
			{% endfor %}
	];

	var customer_pie_data_{{ key }} = [
			{% for indx, stat in customer_breakdown %}
			{
				label: "{{ stat['customer'] }}",
				color: "{{ stat['color'] }}",
				highlight: "{{ stat['color'] }}",
				value: {{ stat[key]|number_format(2, '.', '') }}
			},
			{% endfor %}
	];

	var delivery_pie_data_{{ key }} = [
			{
				label: "Bulk",
				color: "#F5858B",
				highlight: "#F5858B",
				value: {{ all_delivery_type[key]['bulk']|number_format(2, '.', '') }}
			},
			{
				label: "Courier",
				color: "#BDE598",
				highlight: "#BDE598",
				value: {{ all_delivery_type[key]['courier']|number_format(2, '.', '') }}
			},
			{
				label: "Other",
				color: "#A1CAEA",
				highlight: "#A1CAEA",
				value: {{ all_delivery_type[key]['other']|number_format(2, '.', '') }}
			},
	];

	var destination_pie_data_{{ key }} = [
			{
				label: "Local",
				color: "#F5858B",
				highlight: "#F5858B",
				value: {{ all_dest_type[key]['local']|number_format(2, '.', '') }}
			},
			{
				label: "International",
				color: "#BDE598",
				highlight: "#BDE598",
				value: {{ all_dest_type[key]['international']|number_format(2, '.', '') }}
			},
			{
				label: "Other",
				color: "#A1CAEA",
				highlight: "#A1CAEA",
				value: {{ all_dest_type[key]['other']|number_format(2, '.', '') }}
			},
	];

{% endfor %}


	var marginsLineChart = new Chart(margins_line_ctx).Line(margins_line_data, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",  
   		   tooltipFontSize: 9,                
		   multiTooltipTemplate: "<%= datasetLabel %> <%= value %>"
		}
	);
	var incomeLineChart = new Chart(income_line_ctx).Line(income_line_data, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
   		   tooltipFontSize: 9,                
		   multiTooltipTemplate: "<%= datasetLabel %> <%= value %>"
		}
	);
	var outgoingLineChart = new Chart(outgoing_line_ctx).Line(outgoing_line_data, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
   		   tooltipFontSize: 9,                
		   multiTooltipTemplate: "<%= datasetLabel %> <%= value %>"
		}
	);
	var waybillsLineChart = new Chart(waybills_line_ctx).Line(waybills_line_data, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
   		   tooltipFontSize: 9,                
		   multiTooltipTemplate: "<%= datasetLabel %> <%= value %>"
		}
	);
	var pcsLineChart = new Chart(pcs_line_ctx).Line(pcs_line_data, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
   		   tooltipFontSize: 9,                
		   multiTooltipTemplate: "<%= datasetLabel %> <%= value %>"
		}
	);
	var massLineChart = new Chart(mass_line_ctx).Line(mass_line_data, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
   		   tooltipFontSize: 9,                
		   multiTooltipTemplate: "<%= datasetLabel %> <%= value %>"
		}
	);

{% for key, partner_key in partner_keys  %}
	var myDeliveryPieChart_{{ key }} = new Chart(delivery_pie_ctx_{{ key }}).Pie(delivery_pie_data_{{ key }}, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
		   tooltipFontSize: 10,                
		   tooltipTemplate: "<%=label%>:<%= value %>"
		}
	);

	var myDestinationPieChart_{{ key }} = new Chart(destination_pie_ctx_{{ key }}).Pie(destination_pie_data_{{ key }}, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)", 
		   tooltipFontSize: 10,                
		   tooltipTemplate: "<%=label%>:<%= value %>"
		}
	);

	var myPartnerPieChart_{{ key }} = new Chart(partner_pie_ctx_{{ key }}).Pie(partner_pie_data_{{ key }}, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
		   tooltipFontSize: 10,                
		   tooltipTemplate: "<%=label%>:<%= value %>"
		}
	);

	var myCustomerPieChart_{{ key }} = new Chart(customer_pie_ctx_{{ key }}).Pie(customer_pie_data_{{ key }}, 
		{
		   responsive : false,
		   animation: true,
		   tooltipFillColor: "rgba(0,0,0,0.8)",                
		   tooltipFontSize: 10,                
		   tooltipTemplate: "<%=label%>:<%= value %>"
		}
	);
{% endfor %}

</script>



{% endblock content %}