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

{% block head_script_extra %} 
	<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script>
	<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/4.17.47/js/bootstrap-datetimepicker.min.js"></script>
	<script type="text/javascript" src="{{ asset('bundles/d2core/js/datetimepicker_utils.js') }}"></script>
	<script type="text/javascript" src="{{ asset('bundles/d2engen/js/engen_report.js') }}"></script>
{% endblock head_script_extra %}

{% block head_style_extra %} 
	<link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/4.17.47/css/bootstrap-datetimepicker.min.css" rel="stylesheet">
{% endblock head_style_extra %}
    
{% block page_header %}
<div class="row">
	<div class="col-md-12">
		<hr/>
		<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', 'status', 'approved', 'vehicle', 'tag', 'from_date', 'to_date'] %}
					<input type="hidden" name="{{ k }}" value="{{ v }}" />
				{% endif %}
			{% endfor %}
			<div class="filter">
				<label for="sel_from_date">From</label>
				<div class="form-group">
					<div class='input-group date' id='sel_from_date' name='sel_from_date' style="width:140px; font-size:10px">
						<input type='text' class="form-control" placeholder="From Date" name="from_date" value="{{ app.request.get('from_date') }}"/>
						<span class="input-group-addon">
							<span class="glyphicon glyphicon-calendar"></span>
						</span>
					</div>
				</div>
				<label for="sel_to_date">To</label>
				<div class="form-group">
					<div class='input-group date' id='sel_to_date' name='sel_to_date' style="width:140px">
						<input type='text' class="form-control" placeholder="To Date" name="to_date" value="{{ app.request.get('to_date') }}"/>
						<span class="input-group-addon">
							<span class="glyphicon glyphicon-calendar"></span>
						</span>
					</div>
				</div>

				<label for="search">Search</label>
				<input type="text" class="form-control" name="search" id="search" placeholder="Search for" value="{{ app.request.get('search') }}">

				<label for="vehicle">Vehicle</label>
				<select class="form-control" name="vehicle" id="vehicle" style="width:200px">
				<option value='' {{ app.request.get('vehicle') == '' ? 'selected="selected"' : '' }}>Show All</option>
				{% for k, v in engen_vehicles %}<option value="{{ v.id }}" {{ app.request.get('vehicle') is sameas(v.id|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
				</select>

				<label for="tag">Tag</label>
				<select class="form-control" name="tag" id="tag" style="width:200px">
				<option value='' {{ app.request.get('tag') == '' ? 'selected="selected"' : '' }}>Show All</option>
				{% for k, v in engen_vehicles %}<option value="{{ v.tag }}" {{ app.request.get('tag') is sameas(v.tag) ? 'selected="selected"' : '' }}>{{ v.tag }}</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>
					<a title="Export Summary"  class="btn btn-default" href="javascript:ExportTransactionSummary('{{ app.request.get('search') }}', '{{ app.request.get('vehicle') }}', '{{ app.request.get('tag') }}', '{{ app.request.get('from_date') }}', '{{ app.request.get('to_date') }}')">Export</a>
				</div>
			</div>
		</form>
		<div class="clearfix"></div>
		<div>Transaction Summary</div>
	</div>
</div>
{% endblock page_header %}

{% block content %}
{% set w_trans_sum = 0.00 %}
{% set w_litres_sum = 0.00 %}
{% set w_non_fuel_sum = 0.00 %}
{% set w_fuel_sum = 0.00 %}
{% set w_sub_total_sum = 0.00 %}
{% set w_vat_sum = 0.00 %}
{% set w_total_sum = 0.00 %}

{% set trans_sum = 0.00 %}
{% set litres_sum = 0.00 %}
{% set non_fuel_sum = 0.00 %}
{% set fuel_sum = 0.00 %}
{% set sub_total_sum = 0.00 %}
{% set vat_sum = 0.00 %}
{% set total_sum = 0.00 %}

<div class="row" style="margin-top:25px">
	<div class="col-md-offset-1 col-md-10">
		<table class="table table-condensed table-bordered">
			<thead>
				<tr style="background-color:#EBEBEB">
					<th>Account Number</th>
					<th>Account Name</th>
					<th style="text-align:right">Current Balance</th>
				</tr>
				<tr>
					<th>{{ engen_account.accountNumber|trim }}</th>
					<th>{{ engen_account|trim }}</th>
					<th style="text-align:right">{{ engen_account.accountBalance|number_format(2, '.', '') }}</th>
				</tr>
			</tbody>
		</table>
	</div>
</div>    

<div class="row" style="margin-top:25px">
	<div class="col-md-offset-1 col-md-10">
		<table class="table table-condensed table-bordered">
			<thead>
				<tr style="background-color:#EBEBEB">
					<th>Date</th>
					<th>POS Description</th>
					<th>POS Reference</th>
					<th style="text-align:right">Amount</th>
				</tr>
				{% for payment in payments %}
				<tr>
					<td>{{ payment.transaction_date|date("Y/m/d") }}</td>
					<td>{{ payment.description|trim }}</td>
					<td>{{ payment.reference|trim }}</td>
					<td style="text-align:right">{{ payment.total|number_format(2, '.', '') }}</td>
				</tr>
				{% endfor %}
			</tbody>
		</table>
	</div>
</div>    

<div class="row" style="margin-top:25px">
	<div class="col-md-offset-1 col-md-10">
		<table class="table table-condensed table-bordered">
			<thead>
				<tr style="background-color:#EBEBEB">
					<th>Week</th>
					<th style="text-align:right">Transactions</th>
					<th style="text-align:right">Litres</th>
					<th style="text-align:right">Non Fuel</th>
					<th style="text-align:right">Fuel</th>
					<th style="text-align:right">Sub Total</th>
					<th style="text-align:right">Vat</th>
					<th style="text-align:right">Total</th>
				</tr>
			</thead>
			<tbody>
		{% for item in week_summary %}
			{% set w_trans_sum = w_trans_sum + item['transactions'] %}
			{% set w_litres_sum = w_litres_sum + item['litres'] %}
			{% set w_non_fuel_sum = w_non_fuel_sum + item['non_fuel_amt'] %}
			{% set w_fuel_sum = w_fuel_sum + item['fuel_amt'] %}
			{% set w_sub_total_sum = w_sub_total_sum + item['sub_total'] %}
			{% set w_vat_sum = w_vat_sum + item['vat'] %}
			{% set w_total_sum = w_total_sum + item['total'] %}

			{% set week_dates = d2_engen_week_to_dates(item['week_num'], item['year']) %}
			
			<tr>
				<td>{{ week_dates['start'] }} - {{ week_dates['end'] }}</td>
				<td style="text-align:right">
					<div class="btn-group account_dropdown_group" id="account_drop_down_menu" style="cursor:pointer">
						<a class="dropdown-toggle" data-toggle="dropdown">{{ item['transactions']|number_format(0, '.', '') }}</a>
						<ul class="dropdown-menu account_dropdown" id="account_drop_down_list">
							{# <li><a title="View Fuel Transactions" href="javascript:showFuelTransPopup(0, '{{ week_dates['start'] }}', '{{ week_dates['end'] }}')">Fuel Transactions</a></li> #}
							<li><a title="View Pos Transactions" href="javascript:showPosTransPopup(0, '{{ week_dates['start'] }}', '{{ week_dates['end'] }}')">POS Transactions</a></li>
						</ul>
					</div>							
				</td>
				<td style="text-align:right">{{ item['litres']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['non_fuel_amt']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['fuel_amt']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['sub_total']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['vat']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['total']|number_format(2, '.', '') }}</td>
			</tr>
		{% endfor %}

			<tr>
				<th style="text-align:right"></th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_trans_sum|number_format(0, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_litres_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_non_fuel_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_fuel_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_sub_total_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_vat_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ w_total_sum|number_format(2, '.', '') }}</th>
			</tr>
			</tbody>
		</table>
	</div>
</div>    

<div class="row" style="margin-top:25px">
	<div class="col-md-offset-1 col-md-10">
		<table class="table table-condensed table-bordered">
			<thead>
				<tr style="background-color:#EBEBEB">
					<th>Vehicle</th>
					<th>Tag</th>
					<th>Driver</th>
					<th style="text-align:right">Last Odometer</th>
					<th style="text-align:right">Transactions</th>
					<th style="text-align:right">Litres</th>
					<th style="text-align:right">Non Fuel</th>
					<th style="text-align:right">Fuel</th>
					<th style="text-align:right">Sub Total</th>
					<th style="text-align:right">Vat</th>
					<th style="text-align:right">Total</th>
				</tr>
			</thead>
			<tbody>
		{% for item in summary %}
			{% set trans_sum = trans_sum + item['transactions'] %}
			{% set litres_sum = litres_sum + item['litres'] %}
			{% set non_fuel_sum = non_fuel_sum + item['non_fuel_amt'] %}
			{% set fuel_sum = fuel_sum + item['fuel_amt'] %}
			{% set sub_total_sum = sub_total_sum + item['sub_total'] %}
			{% set vat_sum = vat_sum + item['vat'] %}
			{% set total_sum = total_sum + item['total'] %}

			<tr>
				<td><a title="View Vehicle" href="javascript:showVehiclePopup({{ item['vehicle_id'] }})">{{ item['registration_number'] }}</a></td>
				<td>{{ item['tag'] }}</td>
				<td>{{ item['driver_name'] }}</td>
				<td style="text-align:right">{{ item['odo']|number_format(0, '.', '') }}</td>
				<td style="text-align:right">
					<div class="btn-group account_dropdown_group" id="account_drop_down_menu" style="cursor:pointer">
						<a class="dropdown-toggle" data-toggle="dropdown">{{ item['transactions']|number_format(0, '.', '') }}</a>
						<ul class="dropdown-menu account_dropdown" id="account_drop_down_list">
							{# <li><a title="View Fuel Transactions" href="javascript:showFuelTransPopup({{ item['vehicle_id'] }}, '{{ app.request.get('from_date') }}', '{{ app.request.get('to_date') }}')">Fuel Transactions</a></li> #}
							<li><a title="View Pos Transactions" href="javascript:showPosTransPopup({{ item['vehicle_id'] }}, '{{ app.request.get('from_date') }}', '{{ app.request.get('to_date') }}')">POS Transactions</a></li>
						</ul>
					</div>							
				</td>
				<td style="text-align:right">{{ item['litres']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['non_fuel_amt']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['fuel_amt']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['sub_total']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['vat']|number_format(2, '.', '') }}</td>
				<td style="text-align:right">{{ item['total']|number_format(2, '.', '') }}</td>
			</tr>
		{% endfor %}

			<tr>
				<th colspan="4" style="text-align:right">TOTALS:</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ trans_sum|number_format(0, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ litres_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ non_fuel_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ fuel_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ sub_total_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ vat_sum|number_format(2, '.', '') }}</th>
				<th style="text-align:right;background-color:#EBEBEB">{{ total_sum|number_format(2, '.', '') }}</th>
			</tr>
			</tbody>
		</table>
	</div>
</div>    
{% endblock content %}