{% extends 'D2SkyNetBundle::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/d2skynet/js/FMR/fmr_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();
	});
  
    $('#basicCalculator').calculator({
	    showOn: 'both', buttonImageOnly: true, buttonImage: "{{ asset('bundles/d2core/jQuery-Easy-Calculator-Plugin/calculator.png') }}"});
});
</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_skynet_fmr_waybill_soap') }}" class="btn btn-small">SOAP</a>
    </div>
    #}
	{{ with_selected_form('skynet_fmr_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>
            {% 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_skynet_fmr_waybill_view', {'month': period_month, 'year': period_year}) }}">Reset View</a></li>
					<li class="divider"></li>
					<li><a href="{{ path('admin_skynet_manage', {'month': period_month, 'year': period_year}) }}">FMR 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, 'sub_type': filter_sub_type}) }}">FMR Filters</a></li>
					<li class="divider"></li>
					<li><a href="javascript:PodPaste()">POD Copy</a></li>
					<li><a href="{{ path('get_skynet_fmr_image_drop_cntrl') }}">POD Drop</a></li>
				</ul>
            </div>
        </div>
	</form>
    <div class="clearfix"></div>
    <div>Displaying 
        {{ (skynet_list.getCurrentPageNumber()-1) * skynet_list.getItemNumberPerPage() + 1 }}
        to
        {{ ((skynet_list.getCurrentPageNumber()-1) * skynet_list.getItemNumberPerPage()) + (skynet_list.getItems()|length) }}
        of
        {{ skynet_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(skynet_list, 'Date', 'w.date') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Waybill', 'w.waybill') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Client Ref.', 'w.client_ref') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Ref2', 'w.additional_ref') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Sender', 'w.sender') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Origin', 'w.start_town') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Receiver', 'w.receiver') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Dest', 'w.destination_town') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Service', 'w.service') }}</th>
                <th>{{ knp_pagination_sortable(skynet_list, 'Desc', 'w.description') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Pieces', 'w.num_parcels') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Act Mass', 'w.actual_mass') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Vol Mass', 'w.vol_mass') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Mass Chg', 'w.mass_charged') }}</th>
                {#
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'AFT', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'AMB', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'BDR', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'BPS', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'CSH', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'CTL', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'DS1', 'w.aft') }}</th>
                #}
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'DSD', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'EAR', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'EMB', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'FUE', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'FUX', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'HAZ', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'HND', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'IFL', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'INH', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'INS', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'LTE', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'NDC', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'OUT', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'RTL', 'w.aft') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Other', 'w.other_charges') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Ex Vat', 'w.excl_vat') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'VAT', 'w.vat') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'Total', 'w.total') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'R/Kg', 'w.cost_per_kg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(skynet_list, 'C/Kg', 'w.calc_cost_per_kg') }}</th>
            </tr>
        </thead>
		<tbody>
    {% for wb_arr in skynet_list %}
    
		{% if wb_arr['pod_cnt'] == 1 %}
			{% set pods = true %}
			{% set multi_pods = false %}
		{% elseif wb_arr['pod_cnt'] > 1 %}
			{% set pods = true %}
			{% set multi_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('skynet_fmr_list', wb_arr['data'].id) }}</td>
            <td id="pod_icon_{{ wb_arr['data'].getId }}">
				{% if is_granted('ROLE_ADMIN_WAYBILL_MANAGE') %}
					{% if pods == true %} 
						{% if multi_pods == false %}
						<a title="View POD" class="view-pdf" href="{{ wb_arr['data'].getId }}"><i class='icon-file'></i></a> 
						{% else %}
							<span style="font-size:14px">
							<div class="dropdown">
							  <a name= "pod_dropdown" class="dropdown-toggle" data-waybill_id="{{wb_arr['data'].getId}}" data-partner_type="{{partner_type}}"><i class='icon-file'></i></a>
							  <ul id="waybill_pod_menu_{{wb_arr['data'].getId}}" class="dropdown-menu" role="menu" aria-labelledby="dLabel">
							{% for waybill_pod in wb_arr['data'].getPods %}
								<li><a title="" tabindex="-1" href="javascript:DisplaySpecificPOD({{waybill_pod.getId}})">{{ waybill_pod.getOrigPath }}</a></li>
							{% endfor %}
							  </ul>
							</div>					
							</span>
						{% endif %}
					{% else %} 
						<a title="Upload POD" href="javascript:SoapPOD({{ 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'].date is not null %} {{ wb_arr['data'].date|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'].clientRef|trim }}</td>
            <td>{{ wb_arr['data'].additionalRef|trim }}</td>
            <td title="{{ wb_arr['data'].getStartTown }}">{{ wb_arr['data'].sender|trim }}</td>
            <td>{{ wb_arr['data'].startTown|trim }}</td>
            <td title="{{ wb_arr['data'].getDestinationTown }}">{{ wb_arr['data'].receiver|trim }}</td>
            <td>{{ wb_arr['data'].destinationTown|trim }}</td>
            <td><a href="javascript:GlobalAlertProcess('{{ partner_type }}', 'FMR', '{{ wb_arr['data'].id }}', '{{ alert_info }}');">{{ wb_arr['data'].service|trim }}</a></td>
            <td>{{ wb_arr['data'].description|trim }}</td>
            <td style="text-align:right">{{ wb_arr['data'].numParcels }}</td>
            <td style="text-align:right">{{ wb_arr['data'].actualMass|number_format(1, '.', '') }}</td>
            <td title="{{ wb_arr['data'].getTotalVolMass }}" style="text-align:right">{{ wb_arr['data'].volMass|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].massCharged|number_format(1, '.', '') }}</td>
            {#
            <td style="text-align:right">{{ wb_arr['data'].aft|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].amb|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].bdr|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].bps|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].csh|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ctl|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ds1|number_format(2, '.', '') }}</td>
            #}
            <td style="text-align:right">{{ wb_arr['data'].dsd|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ear|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].emb|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].fue|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].fux|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].haz|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].hnd|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ifl|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].inh|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ins|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].lte|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ndc|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].out|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].rtl|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].otherCharges|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].exclVat|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].vat|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].total|number_format(2, '.', '') }}</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(skynet_list) }}
    </div>
    
    {% include 'D2PartnerBundle::quick_alert.html.twig' %} 
    
    
{% endblock content %}