{% extends 'D2RTTBundle::base.html.twig' %} {% block head_css_extra %} {% endblock head_css_extra %} {% block head_script_extra %} {% endblock head_script_extra %} {% block page_header %} {#
Toggle
#}
{% set waybill_cnt_total = 0 %} {% set kgs_total = 0 %} {% set excl_total = 0 %} {% set vat_total = 0 %} {% set incl_total = 0 %} {% if file_stats|length > 0 %} {% 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'] %} {% endfor %} {% endif %}
AccountServiceWaybillsKgsExcl VatVatInc Vat
{{ waybill_cnt_total }}{{ kgs_total|number_format(2, '.', '') }}{{ excl_total|number_format(2, '.', '') }}{{ vat_total|number_format(2, '.', '') }}{{ incl_total|number_format(2, '.', '') }}
{{ with_selected_form('rtt_list') }}

{% for k, v in app.request.query %} {% if k|lower not in ['search', 'page', 'list_cnt', 'service', 'customer', 'ma_acc', 'filter', 'alert'] %} {% endif %} {% endfor %}
Displaying {{ (rtt_list.getCurrentPageNumber()-1) * rtt_list.getItemNumberPerPage() + 1 }} to {{ ((rtt_list.getCurrentPageNumber()-1) * rtt_list.getItemNumberPerPage()) + (rtt_list.getItems()|length) }} of {{ rtt_list.getTotalItemCount() }} WAYBILL records for Partner: {{ company_name }} Imported File: {{ filename|trim|slice(0, 120) }} Period: {{ period }} {% if app.request.get('ma_acc') is not empty %} Account: {{ ma_accounts[app.request.get('ma_acc')] }}{% endif %} {% if app.request.get('quoted') == 1 %}All Quoted{% endif %} {% if app.request.get('early_invoiced') == 1 %}All Early Invoiced{% endif %} {% if app.request.get('adjusted') == 1 %}Adjusted{% endif %}
{% endblock page_header %} {% block content %} {% set consolidated = "" %} {% for wb_arr in rtt_list %} {% if wb_arr['cnt'] > 0 %} {% set consolidated = true %} {% else %} {% set consolidated = false %} {% endif %} {% if wb_arr['doc_cnt'] > 0 %} {% set docs = true %} {% else %} {% set docs = false %} {% endif %} {% if wb_arr['pod_cnt'] > 0 %} {% set pods = true %} {% else %} {% set pods = 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 %} {% if consolidated == true %} {% else %} {% endif %} {% if consolidated == true %} {% for linked_entity in wb_arr['data'].getChildren %} {% if wb_arr['data'].getConsolidationNo == linked_entity.getConsolidationNo %} {% endif %} {% endfor %} {% endif %} {% endfor %}
{% if sticky_mode_active %} {% else %} {% endif %} {{ knp_pagination_sortable(rtt_list, 'Received', 'w.date_received') }} {{ knp_pagination_sortable(rtt_list, 'Consig. ID', 'w.consignment_id') }} {{ knp_pagination_sortable(rtt_list, 'Service', 'w.service_level') }} {{ knp_pagination_sortable(rtt_list, 'From Hub', 'w.from_hub_code') }} {{ knp_pagination_sortable(rtt_list, 'Sender', 'w.sender_name') }} {{ knp_pagination_sortable(rtt_list, 'To Hub', 'w.to_hub_code') }} {{ knp_pagination_sortable(rtt_list, 'Consignee', 'w.consignee_name') }} {{ knp_pagination_sortable(rtt_list, 'Pkts', 'w.packets') }} {{ knp_pagination_sortable(rtt_list, 'Units', 'w.unit_of_measurement') }} {{ knp_pagination_sortable(rtt_list, 'Actual Kg', 'w.actual_kg') }} {{ knp_pagination_sortable(rtt_list, 'Volume Kg', 'w.volume_kg') }} {{ knp_pagination_sortable(rtt_list, 'Kgs Used', 'w.kgs_used') }} {{ knp_pagination_sortable(rtt_list, 'Cons. Kg', 'w.cons_kg') }} {{ knp_pagination_sortable(rtt_list, 'Charge Add On', 'w.rate_charge_add_on') }} {{ knp_pagination_sortable(rtt_list, 'Rate per Kg', 'w.rate_per_kg') }} {{ knp_pagination_sortable(rtt_list, 'Min Charge', 'w.minimum_charge') }} {{ knp_pagination_sortable(rtt_list, 'Doc Fee', 'w.document_fee') }} {{ knp_pagination_sortable(rtt_list, 'Rate Charge', 'w.rate_charge') }} {{ knp_pagination_sortable(rtt_list, 'BDD Charge', 'w.bdd_charge') }} {{ knp_pagination_sortable(rtt_list, 'High Risk Charge', 'w.high_risk_charge') }} {{ knp_pagination_sortable(rtt_list, 'Sanral Charge', 'w.sanral_charges') }} {{ knp_pagination_sortable(rtt_list, 'Sanral Zone', 'w.sanral_zone') }} {{ knp_pagination_sortable(rtt_list, 'Fuel %', 'w.fuel_surcharge_percent') }} {{ knp_pagination_sortable(rtt_list, 'Fuel ExVat', 'w.fuel_surcharge_ex_vat') }} {{ knp_pagination_sortable(rtt_list, 'Amount ExVat', 'w.amount_ex_vat') }} {{ knp_pagination_sortable(rtt_list, 'Vat', 'w.vat_total_cons') }} {{ knp_pagination_sortable(rtt_list, 'Amount IncVat', 'w.amount_inc_vat') }} {{ knp_pagination_sortable(rtt_list, 'R/Kg', 'w.cost_per_kg') }} {{ knp_pagination_sortable(rtt_list, 'C/Kg', 'w.calc_cost_per_kg') }}
{{ with_selected_checkbox('rtt_list', wb_arr['data'].id) }} {% if is_granted('ROLE_ADMIN_WAYBILL_MANAGE') %} {% if consolidated == false %} {% if pods == true %} {% else %} {% endif %} {% endif %} {% endif %} {% if consolidated == false %} {% if docs == true %} {% else %} {% endif %} {% endif %} {% if is_granted('ROLE_ADMIN_WAYBILL_EDIT') %} {% if history == true %} {% elseif wb_arr['data'].locked == false %} {% endif %} {% endif %} {% if wb_arr['data'].dateReceived is not null %} {{ wb_arr['data'].dateReceived|date("Y/m/d") }} {% endif %} {{ wb_arr['data'].consignmentId|trim }} {{ wb_arr['data'].serviceLevel|trim }} {{ wb_arr['data'].fromHubCode|trim }} {{ wb_arr['data'].senderName|trim }} {{ wb_arr['data'].toHubCode|trim }} {{ wb_arr['data'].consigneeName|trim }} {{ wb_arr['data'].packets|trim }} {{ wb_arr['data'].unitOfMeasurement|trim }} {{ wb_arr['data'].actualKg|number_format(1, '.', '') }} {{ wb_arr['data'].volumeKg|number_format(1, '.', '') }} {{ wb_arr['data'].kgsUsed|number_format(1, '.', '') }} {{ wb_arr['data'].consKg|number_format(1, '.', '') }} {{ wb_arr['data'].rateChargeAddOn|number_format(2, '.', '') }} {{ wb_arr['data'].ratePerKg|number_format(2, '.', '') }} {{ wb_arr['data'].minimumCharge|number_format(2, '.', '') }} {{ wb_arr['data'].documentFee|number_format(2, '.', '') }} {{ wb_arr['data'].rateCharge|number_format(2, '.', '') }} {{ wb_arr['data'].bddCharge|number_format(2, '.', '') }} {{ wb_arr['data'].highRiskCharge|number_format(2, '.', '') }} {{ wb_arr['data'].sanralCharges|number_format(2, '.', '') }} {{ wb_arr['data'].sanralZone }} {{ wb_arr['data'].fuelSurchargePercent|number_format(1, '.', '') }} {{ wb_arr['data'].fuelSurchargeExVat|number_format(2, '.', '') }} {{ wb_arr['data'].amountExVat|number_format(2, '.', '') }} {% if wb_arr['data'].creditAllocation is not null %}
{{ wb_arr['data'].creditAllocation.amountExVat|number_format(2, '.', '') }}{% endif %} {% if wb_arr['data'].quoted == true %}
QT: {{ wb_arr['data'].adjAmountExVat|number_format(2, '.', '') }}{% endif %} {% if wb_arr['data'].billingOverride == true %}
CHG: {{ wb_arr['data'].adjAmountExVat|number_format(2, '.', '') }}{% endif %}
{{ wb_arr['data'].vatTotalCons|number_format(2, '.', '') }} {% if wb_arr['data'].creditAllocation is not null %}
{{ wb_arr['data'].creditAllocation.vat|number_format(2, '.', '') }}{% endif %} {% if wb_arr['data'].quoted == true %}
{{ wb_arr['data'].adjVatTotal|number_format(2, '.', '') }}{% endif %} {% if wb_arr['data'].billingOverride == true %}
{{ wb_arr['data'].adjVatTotal|number_format(2, '.', '') }}{% endif %}
{{ wb_arr['data'].amountIncVat|number_format(2, '.', '') }} {% if wb_arr['data'].creditAllocation is not null %}
{{ wb_arr['data'].creditAllocation.amountIncVat|number_format(2, '.', '') }}{% endif %} {% if wb_arr['data'].quoted == true %}
{{ wb_arr['data'].adjAmountIncVat|number_format(2, '.', '') }}{% endif %} {% if wb_arr['data'].billingOverride == true %}
{{ wb_arr['data'].adjAmountIncVat|number_format(2, '.', '') }}{% endif %}
{{ wb_arr['data'].costPerKg|number_format(2, '.', '') }} {{ wb_arr['data'].calcCostPerKg|number_format(2, '.', '') }}
{% include 'D2PartnerBundle::quick_alert.html.twig' %} {% endblock content %}