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


{% block head_css_extra %}
<link href="{{ asset('bundles/d2core/css/pdf_popup.css') }}" rel="stylesheet" />
<link rel="stylesheet" type="text/css" href="{{ asset('bundles/d2core/dropzone-4.2.0/dist/dropzone.css') }}">
{% endblock head_css_extra %}

{% block head_script_extra %}
<script type="text/javascript" src="{{ asset('bundles/d2rowel/js/waybill_admin.js') }}"></script>
<script type="text/javascript" src="{{ asset('bundles/d2partner/js/waybill_docs.js') }}"></script>
<link rel="stylesheet" type="text/css" href="{{ asset('bundles/d2core/jQuery-Easy-Calculator-Plugin/jquery.calculator.css') }}">
<script type="text/javascript" src="{{ asset('bundles/d2core/jQuery-Easy-Calculator-Plugin/jquery.plugin.js') }}"></script>
<script type="text/javascript" src="{{ asset('bundles/d2core/jQuery-Easy-Calculator-Plugin/jquery.calculator.js') }}"></script>
<script type="text/javascript" src="{{ asset('bundles/d2core/js/pdf_popup.min.js') }}"></script>

<script>
$(document).ready(function() {
	d2.with_selected.setHook('assign_waybill.override', function( tag, action ) {
		AssignWaybillOverride();
	});
	d2.with_selected.setHook('set_waybill_error.override', function( tag, action ) {
		SetWaybillErrorOverride();
	});
	d2.with_selected.setHook('clear_waybill_error.override', function( tag, action ) {
		ClearWaybillErrorOverride();
	});
	d2.with_selected.setHook('add_alert_finding.override', function( tag, action ) {
		AddAlertFindingOverride();
	});
	d2.with_selected.setHook('assign_waybill_period.override', function( tag, action ) {
		PeriodWaybillOverride();
	});
	d2.with_selected.setHook('set_waybill_diesel_price.override', function( tag, action ) {
		DieselPriceWaybillOverride();
	});
	d2.with_selected.setHook('export_waybill.override', function( tag, action ) {
		ExportWaybills();
	});
	d2.with_selected.setHook('edit_waybill.override', function( tag, action ) {
		EditWaybillOverride({{ partner_type }});
	});
  
    $('#basicCalculator').calculator({
	    showOn: 'both', buttonImageOnly: true, buttonImage: "{{ asset('bundles/d2core/jQuery-Easy-Calculator-Plugin/calculator.png') }}"});
	
	$('#stats_header_row').on('click', function() {	
		$('.waybill_stat_row').toggle();
	});
});
</script>
{% endblock head_script_extra %}
    
{% block page_header %}
    {#
    <div class="pull-left">
        <input type="text" id="basicCalculator" style="width:50px">
    </div>
    
    <div class="pull-left">
        <a href="javascript:ControlView()" class="btn btn-small">Toggle</a>
        <a href="{{ path('admin_rowel_waybill_soap') }}" class="btn btn-small">SOAP</a>
    </div>
    #}
    <div class="pull-left">
		{% set waybill_cnt_total = 0 %}
		{% set kgs_total = 0 %}
		{% set excl_total = 0 %}
		{% set vat_total = 0 %}
		{% set incl_total = 0 %}
        <table class="table table-condensed table-extra-condensed table-bordered">
			{% if file_stats|length > 0 %}
				<tr id="stats_header_row"><th>Account</th><th>Service</th><th>Waybills</th><th>Kgs</th><th>Excl Vat</th><th>Vat</th><th>Inc Vat</th></tr>
				{% for stat in file_stats %}
				{% set waybill_cnt_total = waybill_cnt_total + stat['waybill_cnt'] %}
				{% set kgs_total = kgs_total + stat['kg_shipped'] %}
				{% set excl_total = excl_total + stat['total_ex_vat'] %}
				{% set vat_total = vat_total + stat['totat_vat'] %}
				{% set incl_total = incl_total + stat['total_inc_vat'] %}
				<tr class="waybill_stat_row" style="display:none">
					<td>{{ stat['ma_account_name'] }}</td><td>{{ stat['service'] }}</td><td style="text-align:right">{{ stat['waybill_cnt'] }}</td><td style="text-align:right">{{ stat['kg_shipped']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ stat['total_ex_vat']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ stat['totat_vat']|number_format(2, '.', '') }}</td><td style="text-align:right">{{ stat['total_inc_vat']|number_format(2, '.', '') }}</td>
				</tr>
				{% endfor %}
				<tr><th></th><th></th><th style="text-align:right">{{ waybill_cnt_total }}</th><th style="text-align:right">{{ kgs_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></tr>
			{% endif %}
        </table>
    </div>

	{{ with_selected_form('rowel_list') }}
    <div class="clearfix"></div>
	<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', 'list_cnt', 'service', 'customer', 'ma_acc', 'filter', 'alert'] %}
				<input type="hidden" name="{{ k }}" value="{{ v }}" />
			{% endif %}
		{% endfor %}
        <div class="filter">
            <label class="sr-only" for="filter">Filter</label>
            <select class="form-control" name="filter" id="filter" style="width:200px">
			<option value='' {{ app.request.get('filter') == '' ? 'selected="selected"' : '' }}>No Filter</option>
			<option value='adjusted' {{ app.request.get('filter') == 'adjusted' ? 'selected="selected"' : '' }}>Adjusted Waybills</option>
			<option value='credited' {{ app.request.get('filter') == 'credited' ? 'selected="selected"' : '' }}>Credited Waybills</option>
            {% for k, v in filters %}<option value="{{ v.getId }}" {{ app.request.get('filter') is sameas(v.getId|lower) ? 'selected="selected"' : '' }}>{{ v.getQueryName }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="ma_acc">Account</label>
            <select class="form-control" name="ma_acc" id="ma_acc" style="width:100px">
			<option value='' {{ app.request.get('ma_acc') == '' ? 'selected="selected"' : '' }}>Show All</option>
            {% for k, v in ma_accounts %}<option value="{{ k }}" {{ app.request.get('ma_acc') is sameas(k|lower) ? 'selected="selected"' : '' }}>{{ v }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="customer">Customer</label>
            <select class="form-control" name="customer" id="customer" style="width:200px">
			<option value='' {{ app.request.get('customer') == '' ? 'selected="selected"' : '' }}>Show All</option>
			<option value='0' {{ app.request.get('customer') == '0' ? 'selected="selected"' : '' }}>Show Unassigned</option>
			<option  disabled role=separator></option>
            {% for k, v in customers %}<option value="{{ v['id']}}" {{ app.request.get('customer') is sameas(v['id']|lower) ? 'selected="selected"' : '' }}>{{ v['company_name'] }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="alert">Alert</label>
            <select class="form-control" name="alert" id="alert" style="width:200px">
			<option value='' {{ app.request.get('alert') == '' ? 'selected="selected"' : '' }}>SHOW ALL</option>
			<option value='all_unset' {{ app.request.get('alert') == 'all_unset' ? 'selected="selected"' : '' }}>SHOW NOT ALERTED</option>
			<option value='all_set' {{ app.request.get('alert') == 'all_set' ? 'selected="selected"' : '' }}>SHOW ALERTED</option>
			<option value='all_not_cleared' {{ app.request.get('alert') == 'all_not_cleared' ? 'selected="selected"' : '' }}>SHOW NOT CLEARED</option>
			<option value='all_cleared' {{ app.request.get('alert') == 'all_cleared' ? 'selected="selected"' : '' }}>SHOW CLEARED</option>
			<option value='esculated' {{ app.request.get('alert') == 'esculated' ? 'selected="selected"' : '' }}>SHOW ESCULATED</option>
			<option  disabled role=separator></option>
            {% for k, v in alert_opts %}<option value="{{ v.alert_type }}" {{ app.request.get('alert') is sameas(v.alert_type|lower) ? 'selected="selected"' : '' }}>{{ alert_type_opts[v.alert_type] }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="service">Service</label>
            <select class="form-control" name="service" id="service" style="width:100px">
			<option value='' {{ app.request.get('service') == '' ? 'selected="selected"' : '' }}>Show All</option>
            {% for k, v in service_opts %}<option value="{{ v.service }}" {{ app.request.get('service') is sameas(v.service) ? 'selected="selected"' : '' }}>{{ v.service }}</option>{% endfor %}
            </select>
            <label class="sr-only" for="search">Search</label>
            <input type="text" class="form-control" name="search" id="search" placeholder="Search for" value="{{ app.request.get('search') }}" style="width:150px">
            
            <input type="text" class="form-control" name="list_cnt" id="list_cnt" placeholder="Cnt" style="width:33px" value="{{ app.request.get('list_cnt') }}">
            <div class="btn-group">
                <button type="submit" class="btn btn-default">Go</button>
                <button type="button" class="btn btn-default clear_filter">Clear</button>
				<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown"><span class="caret"></span></button>
				<ul class="dropdown-menu" role="menu" style="min-width:129px">
					<li><a href="{{ path('admin_rowel_waybill_view', {'month': period_month, 'year': period_year}) }}">Reset View</a></li>
					<li class="divider"></li>
					<li><a href="{{ path('admin_rowel_manage', {'month': period_month, 'year': period_year}) }}">Invoice Files</a></li>
					<li><a href="{{ path('partner_consolidated_waybill_report', {'month': period_month, 'year': period_year}) }}">Partner Reports</a></li>
					<li><a href="{{ path('dynamic_waybill_query_view', {'type': partner_type}) }}">Waybill Filters</a></li>
					<li class="divider"></li>
					<li><a href="javascript:PodPaste()">POD Copy</a></li>
					<li><a href="{{ path('get_rowel_image_drop_cntrl') }}">POD Drop</a></li>
				</ul>
            </div>
        </div>
	</form>
    <div class="clearfix"></div>
    <div>Displaying 
        {{ (rowel_list.getCurrentPageNumber()-1) * rowel_list.getItemNumberPerPage() + 1 }}
        to
        {{ ((rowel_list.getCurrentPageNumber()-1) * rowel_list.getItemNumberPerPage()) + (rowel_list.getItems()|length) }}
        of
        {{ rowel_list.getTotalItemCount() }}
        records for <b>Partner:</b> <code>{{ company_name }}</code> <b>Imported File:</b> <code><span title="{{ filename }}">{{ filename|trim|slice(0, 120) }}</span></code> <b>Period:</b> <code>{{ period }}</code>
        {% if app.request.get('ma_acc') is not empty %} <b>Account:</b> <code>{{ ma_accounts[app.request.get('ma_acc')] }}</code>{% endif %}
        {% if app.request.get('quoted') == 1 %}<code>All Quoted</code>{% endif %}
        {% if app.request.get('early_invoiced') == 1 %}<code>All Early Invoiced</code>{% endif %}
        {% if app.request.get('adjusted') == 1 %}<code>Adjusted</code>{% endif %}
    </div>
{% endblock page_header %}

{% block content %}
    <table id="waybill_table" class="table table-condensed table-extra-condensed">
        <thead>
            <tr>
				<th class="ws_th">
					{% if sticky_mode_active %}
					<i title="Sticky Sort Mode Active [{{ order_str }}]" class='sticky_class icon-lock'></i>
					{% else %}
					<i title="Enable Sticky Sorting?" class=' sticky_class icon-hand-right'></i>
					{% endif %}
				</th>
                <th style="width:15px"></th>
                <th style="width:15px"></th>
                <th style="width:15px"></th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Date', 'w.waybill_date') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Waybill', 'w.waybill') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Manifest', 'w.manifest') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Route', 'w.route_code') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Sender', 'w.sender') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Origin', 'w.origin') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Receiver', 'w.recipient') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Dest', 'w.dest') }}</th>
                <th>{{ knp_pagination_sortable(rowel_list, 'Service', 'w.service') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Pieces', 'w.pieces') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Weight', 'w.weight') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Vol Mass', 'w.vol_mass') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Mass Charged', 'w.mass_charged') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Tariff', 'w.tariff') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Col Chrg', 'w.pickup_chrg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Del Chrg', 'w.delivery_chrg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Fuel', 'w.fuel_surcharge') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'EToll', 'w.etoll') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Insurance', 'w.insurance') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Hazchem', 'w.hazchem') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Doc Fee', 'w.doc_fee') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Other', 'w.other') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Sub Total', 'w.sub_total') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'VAT', 'w.vat') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'Total', 'w.total') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'R/Kg', 'w.cost_per_kg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rowel_list, 'C/Kg', 'w.calc_cost_per_kg') }}</th>
            </tr>
        </thead>
		<tbody>
    {% for wb_arr in rowel_list %}
    
		{% if wb_arr['pod_cnt'] > 0 %}
			{% set pods = true %}
		{% else %}
			{% set pods = false %}
		{% endif %}

		{% if wb_arr['doc_cnt'] > 0 %}
			{% set docs = true %}
		{% else %}
			{% set docs = false %}
		{% endif %}

		{% if wb_arr['adj_cnt'] > 0 %}
			{% set history = true %}
		{% else %}
			{% set history = false %}
		{% endif %}
		
		{% if wb_arr['data'].getAlert is not null %}
			{% set alert_status = wb_arr['data'].getAlert.getAlertStatus %}
			{% set alert_info = wb_arr['data'].getAlert.getSystemFinding|trim('\n')  %}
		{% else %}
			{% set alert_status = 0 %}
			{% set alert_info = '' %}
		{% endif %}
		
		{% if alert_status == 0 %}
			{% set row_color = '#F2DEDE' %}
		{% elseif alert_status == 1 %}
			{% set row_color = '#F2C77D' %}
		{% elseif alert_status == 2 %}
			{% set row_color = '#ADD0D8' %}
		{% elseif alert_status == 3 %}
			{% set row_color = '#DEE09D' %}
		{% elseif alert_status == 4 %}
			{% set row_color = '#D7F4D2' %}
		{% endif %}
				
        <tr data-id="{{ wb_arr['data'].id }}" {% if wb_arr['data'].getAlert is not null %} title="{{ alert_info }}" {% endif %} {% if wb_arr['data'].getAlert is not null and alert_status != 4%} class="error" {% else %} class="no-error" {% endif %}>
			<td id="alert_td_{{ wb_arr['data'].id }}" {% if wb_arr['data'].getAlert is not null %}style="background-color:{{ row_color }}"{% endif %}>{{ with_selected_checkbox('rowel_list', wb_arr['data'].id) }}</td>
            <td>
				{% if is_granted('ROLE_ADMIN_WAYBILL_MANAGE') %}
					{% if pods == true %} 
						<a title="View POD" class="view-pdf" href="{{ wb_arr['data'].getId }}"><i class='icon-file'></i></a> 
					{% else %} 
						<a title="Upload POD" href="{{ path('rowel_admin_new_pod', { 'id': wb_arr['data'].getId}) }}" ><i class='icon-upload'></i></a> 
					{% endif %}
				{% endif %}
			</td>
			<td>
					{% if docs == true %} 
					<span style="font-size:14px">
					<div class="dropdown">
					  <a class="dropdown-toggle doc_dropdown_menu" data-waybill_id="{{wb_arr['data'].getId}}" data-partner_type="{{partner_type}}"><i class='icon-folder-open'></i></a>
					  <ul id="waybill_doc_menu_{{wb_arr['data'].getId}}" class="dropdown-menu" role="menu" aria-labelledby="dLabel">
						<li><a title="" tabindex="-1" href="{{ path('waybill_admin_new_doc', { 'type': partner_type, 'id': wb_arr['data'].getId}) }}">Add Document</a></li>
						<li><a title="" tabindex="-1" href="javascript:DeleteDocuments({{partner_type}}, {{wb_arr['data'].getId}})">Delete Document</a></li>
						<li class="divider"></li>
					  </ul>
					</div>					
					</span>
					{% else %} 
						<a title="Upload Waybill Docs" href="{{ path('waybill_admin_new_doc', { 'type': partner_type, 'id': wb_arr['data'].getId}) }}" ><i class='icon-book'></i></a> 
					{% endif %}
			</td>
			<td>
				{% if is_granted('ROLE_ADMIN_WAYBILL_EDIT') %}
					{% if history == true %} 
						<i title="View Edits" hist_id="{{wb_arr['data'].id}}" class='history_tag icon-tag'></i>
					{% elseif wb_arr['data'].locked == false %} 
						<i title="Edit Waybill" hist_id="{{wb_arr['data'].id}}" class='history_tag icon-edit'></i>
					{% endif %}
				{% endif %}
			</td>
            <td>{% if wb_arr['data'].waybillDate is not null %} {{ wb_arr['data'].waybillDate|date("Y/m/d") }} {% endif %}</td>
            <td><a title="Alerts" href="javascript:ProcessWaybillAlert('{{wb_arr['data'].id}}', '{{ wb_arr['data'].waybill|trim }}', '{{ alert_info }}', '{{wb_arr['data'].locked}}')">{{ wb_arr['data'].waybill|trim }}</a></td>
            <td>{{ wb_arr['data'].manifest|trim }}</td>
            <td>{{ wb_arr['data'].routeCode|trim }}</td>
            <td title="{{ wb_arr['data'].getOrigin }} - {{ wb_arr['data'].getColRoute }}">{{ wb_arr['data'].sender|trim }}</td>
            <td>{{ wb_arr['data'].origin|trim }}</td>
            <td title="{{ wb_arr['data'].getDest }} - {{ wb_arr['data'].getDelRoute }}">{{ wb_arr['data'].recipient|trim }}</td>
            <td>{{ wb_arr['data'].dest|trim }}</td>
            <td><a href="javascript:GlobalAlertProcess('{{ partner_type }}', 'WAYBILL', '{{ wb_arr['data'].id }}', '{{ alert_info }}');">{{ wb_arr['data'].service|trim }}</a></td>
            <td style="text-align:right">{{ wb_arr['data'].pieces }}</td>
            <td style="text-align:right">{{ wb_arr['data'].weight|number_format(0, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].volMass|number_format(0, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].massCharged|number_format(0, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].tariff|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].pickupChrg|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].deliveryChrg|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].fuelSurcharge|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].etoll|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].insurance|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].hazchem|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].docFee|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].other|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].subTotal|number_format(2, '.', '') }}
				{% if wb_arr['data'].creditAllocation is not null %}<br/><span  class="text-error">{{ wb_arr['data'].creditAllocation.amountExVat|number_format(2, '.', '') }}</span>{% endif %}
				{% if wb_arr['data'].quoted == true %}<br/><span  class="text-info">QT: {{ wb_arr['data'].adjAmountExVat|number_format(2, '.', '') }}</span>{% endif %}
				{% if wb_arr['data'].billingOverride == true %}<br/><span  class="text-info">CHG: {{ wb_arr['data'].adjAmountExVat|number_format(2, '.', '') }}</span>{% endif %}
			</td>
            <td style="text-align:right">{{ wb_arr['data'].vat|number_format(2, '.', '') }}
				{% if wb_arr['data'].creditAllocation is not null %}<br/><span  class="text-error">{{ wb_arr['data'].creditAllocation.vat|number_format(2, '.', '') }}</span>{% endif %}
				{% if wb_arr['data'].quoted == true %}<br/><span  class="text-info">{{ wb_arr['data'].adjVatTotal|number_format(2, '.', '') }}</span>{% endif %}
				{% if wb_arr['data'].billingOverride == true %}<br/><span  class="text-info">{{ wb_arr['data'].adjVatTotal|number_format(2, '.', '') }}</span>{% endif %}
			</td>
            <td style="text-align:right">{{ wb_arr['data'].total|number_format(2, '.', '') }}
				{% if wb_arr['data'].creditAllocation is not null %}<br/><span  class="text-error">{{ wb_arr['data'].creditAllocation.amountIncVat|number_format(2, '.', '') }}</span>{% endif %}
				{% if wb_arr['data'].quoted == true %}<br/><span  class="text-info">{{ wb_arr['data'].adjAmountIncVat|number_format(2, '.', '') }}</span>{% endif %}
				{% if wb_arr['data'].billingOverride == true %}<br/><span  class="text-info">{{ wb_arr['data'].adjAmountIncVat|number_format(2, '.', '') }}</span>{% endif %}
			</td>
            <td style="text-align:right"><b>{{ wb_arr['data'].costPerKg|number_format(2, '.', '') }}</b></td>
            <td style="text-align:right"><b>{{ wb_arr['data'].calcCostPerKg|number_format(2, '.', '') }}</b></td>
        </tr>
    {% endfor %}
		</tbody>
    </table>
    <div class="pagination pull-right">
        {{ knp_pagination_render(rowel_list) }}
    </div>
    
    {% include 'D2PartnerBundle::quick_alert.html.twig' %}
    
    
{% endblock content %}