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


{% block head_css_extra %}
{% endblock head_css_extra %}

{% block head_script_extra %}
<script type="text/javascript" src="{{ asset('bundles/d2rtt/js/debit_admin.js') }}"></script>

<script>
$(document).ready(function() {
	d2.with_selected.setHook('assign_debit.override', function( tag, action ) {
		AssignDebitOverride();
	});
  
	$('#stats_header_row').on('click', function() {	
		$('.waybill_stat_row').toggle();
	});
});
</script>
{% endblock head_script_extra %}
    
{% block page_header %}
    {#
    <div class="pull-left">
        <a href="javascript:ControlView()" class="btn btn-small">Toggle</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('rtt_debit_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'] %}
				<input type="hidden" name="{{ k }}" value="{{ v }}" />
			{% endif %}
		{% endfor %}
        <div class="filter">
            <label class="sr-only" for="customer">Customer</label>
            <select class="form-control" name="customer" id="customer">
			<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="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_level }}" {{ app.request.get('service') is sameas(v.service_level|lower) ? 'selected="selected"' : '' }}>{{ v.service_level }}</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_rtt_waybill_view', {'month': period_month, 'year': period_year}) }}">Reset View</a></li>
					<li class="divider"></li>
					<li><a href="{{ path('admin_rtt_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>
				</ul>
            </div>
        </div>
	</form>
    <div class="clearfix"></div>
    <div>Displaying 
        {{ (rtt_debit_list.getCurrentPageNumber()-1) * rtt_debit_list.getItemNumberPerPage() + 1 }}
        to
        {{ ((rtt_debit_list.getCurrentPageNumber()-1) * rtt_debit_list.getItemNumberPerPage()) + (rtt_debit_list.getItems()|length) }}
        of
        {{ rtt_debit_list.getTotalItemCount() }}
        DEBIT 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 %}
    </div>
{% endblock page_header %}

{% block content %}
    <table id="debit_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(rtt_debit_list, 'Received', 'w.date_received') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Consig. ID', 'w.consignment_id') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Service', 'w.service_level') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'From Hub', 'w.from_hub_code') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Sender', 'w.sender_name') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'To Hub', 'w.to_hub_code') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Consignee', 'w.consignee_name') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Pkts', 'w.packets') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Units', 'w.unit_of_measurement') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Actual Kg', 'w.actual_kg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Volume Kg', 'w.volume_kg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Kgs Used', 'w.kgs_used') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Cons. Kg', 'w.cons_kg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Charge Add On', 'w.rate_charge_add_on') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Rate per Kg', 'w.rate_per_kg') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Min Charge', 'w.minimum_charge') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Doc Fee', 'w.document_fee') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Rate Charge', 'w.rate_charge') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'BDD Charge', 'w.bdd_charge') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'High Risk Charge', 'w.high_risk_charge') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Sanral Charge', 'w.sanral_charges') }}</th>
                <th>{{ knp_pagination_sortable(rtt_debit_list, 'Sanral Zone', 'w.sanral_zone') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Fuel %', 'w.fuel_surcharge_percent') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Fuel ExVat', 'w.fuel_surcharge_ex_vat') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Amount ExVat', 'w.amount_ex_vat') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Vat', 'w.vat_total_cons') }}</th>
                <th style="text-align:right">{{ knp_pagination_sortable(rtt_debit_list, 'Amount IncVat', 'w.amount_inc_vat') }}</th>
                <th style="text-align:right"></th>
            </tr>
        </thead>
		<tbody>
    {% set consolidated = "" %}
    {% for wb_arr in rtt_debit_list %}
    
		{% if wb_arr['cnt'] > 0 %}
			{% set consolidated = true %}
		{% else %}
			{% set consolidated = false %}
		{% endif %}
				
        <tr data-id="{{ wb_arr['data'].getId }}" class="no-error">
			<td>{{ with_selected_checkbox('rtt_debit_list', wb_arr['data'].id) }}</td>
            {% if consolidated == true %}
            <td> <a title="View Consolidated" href="javascript:ShowLinkedRows('{{ wb_arr['data'].getConsolidationNo }}')" ><i class='icon-plus'></i></a></td>
            {% else %}
            <td>
			</td>
            {% endif %}
			<td>
			</td>
			<td>
			</td>
            <td>{% if wb_arr['data'].dateReceived is not null %} {{ wb_arr['data'].dateReceived|date("Y/m/d") }} {% endif %}</td>
            <td>{{ wb_arr['data'].consignmentId|trim }}</td>
            <td>{{ wb_arr['data'].serviceLevel|trim }}</td>
            <td>{{ wb_arr['data'].fromHubCode|trim }}</td>
            <td title="[{{ wb_arr['data'].getFromHubName }}] {{ wb_arr['data'].getSenderSuburb }}, {{ '%04d'|format(wb_arr['data'].getFromPostalCode) }}">{{ wb_arr['data'].senderName|trim }}</td>
            <td>{{ wb_arr['data'].toHubCode|trim }}</td>
            <td title="[{{ wb_arr['data'].getToHubName }}] {{ wb_arr['data'].getConsigneeTown }}, {{ wb_arr['data'].getConsigneeSuburb }}, {{ '%04d'|format(wb_arr['data'].getToPostalCode) }}">{{ wb_arr['data'].consigneeName|trim }}</td>
            <td>{{ wb_arr['data'].packets|trim }}</td>
            <td>{{ wb_arr['data'].unitOfMeasurement|trim }}</td>
            <td style="text-align:right">{{ wb_arr['data'].actualKg|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].volumeKg|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].kgsUsed|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].consKg|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].rateChargeAddOn|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].ratePerKg|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].minimumCharge|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].documentFee|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].rateCharge|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].bddCharge|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].highRiskCharge|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].sanralCharges|number_format(2, '.', '') }}</td>
            <td>{{ wb_arr['data'].sanralZone }}</td>
            <td style="text-align:right">{{ wb_arr['data'].fuelSurchargePercent|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].fuelSurchargeExVat|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].amountExVat|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].vatTotalCons|number_format(2, '.', '') }}</td>
            <td style="text-align:right">{{ wb_arr['data'].amountIncVat|number_format(2, '.', '') }}</td>
            <td style="text-align:right"></td>
        </tr>
	{% if consolidated == true %}
    {% for linked_entity in wb_arr['data'].getChildren %}
		{% if wb_arr['data'].getConsolidationNo == linked_entity.getConsolidationNo %}
        <tr data-id="{{ linked_entity.getId }}" class="info sub_row_{{ wb_arr['data'].getConsolidationNo }}" style="display:none">
			<td></td>
            <td>
            </td>
			<td>
			</td>
			<td>
			</td>
            <td>{% if linked_entity.dateReceived is not null %} {{ linked_entity.dateReceived|date("Y/m/d") }} {% endif %}</td>
            <td>{{ linked_entity.consignmentId|trim }}</td>
            <td>{{ linked_entity.serviceLevel|trim }}</td>
            <td>{{ linked_entity.fromHubCode|trim }}</td>
            <td>{{ linked_entity.senderName|trim }}</td>
            <td>{{ linked_entity.toHubCode|trim }}</td>
            <td>{{ linked_entity.consigneeName|trim }}</td>
            <td>{{ linked_entity.packets|trim }}</td>
            <td>{{ linked_entity.unitOfMeasurement|trim }}</td>
            <td style="text-align:right">{{ linked_entity.actualKg|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ linked_entity.volumeKg|number_format(1, '.', '') }}</td>
            <td style="text-align:right">{{ linked_entity.kgsUsed|number_format(1, '.', '') }}</td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td>{{ linked_entity.sanralZone }}</td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"></td>
            <td style="text-align:right"><b></b></td>
        </tr>
        {% endif %}
    {% endfor %}
	{% endif %}
    {% endfor %}
		</tbody>
    </table>
    <div class="pagination pull-right">
        {{ knp_pagination_render(rtt_debit_list) }}
    </div>
    
    
{% endblock content %}