{% extends 'D2CargoWorksBundle::base.html.twig' %} {% block head_css_extra %} {% endblock head_css_extra %} {% block head_script_extra %} {% endblock head_script_extra %} {% block page_header %} {#
Toggle SOAP
#}
{% 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('cargoworks_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 {{ (cargoworks_list.getCurrentPageNumber()-1) * cargoworks_list.getItemNumberPerPage() + 1 }} to {{ ((cargoworks_list.getCurrentPageNumber()-1) * cargoworks_list.getItemNumberPerPage()) + (cargoworks_list.getItems()|length) }} of {{ cargoworks_list.getTotalItemCount() }} 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 %} {% for wb_arr in cargoworks_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 %} {% endfor %}
{% if sticky_mode_active %} {% else %} {% endif %} {{ knp_pagination_sortable(cargoworks_list, 'Waybill', 'w.waybill') }} {{ knp_pagination_sortable(cargoworks_list, 'Cap. Date', 'w.capture_date') }} {{ knp_pagination_sortable(cargoworks_list, 'Col. Date', 'w.collect_date') }} {{ knp_pagination_sortable(cargoworks_list, 'POD. Date', 'w.pod_date') }} {{ knp_pagination_sortable(cargoworks_list, 'Ref1', 'w.reference') }} {{ knp_pagination_sortable(cargoworks_list, 'Ref2', 'w.additional_ref') }} {{ knp_pagination_sortable(cargoworks_list, 'Sender', 'w.sender') }} {{ knp_pagination_sortable(cargoworks_list, 'Origin', 'w.origin') }} {{ knp_pagination_sortable(cargoworks_list, 'Receiver', 'w.receiver') }} {{ knp_pagination_sortable(cargoworks_list, 'Dest', 'w.destination') }} {{ knp_pagination_sortable(cargoworks_list, 'Service', 'w.service') }} {{ knp_pagination_sortable(cargoworks_list, 'Pieces', 'w.pieces') }} {{ knp_pagination_sortable(cargoworks_list, 'Act Kgs', 'w.act_kgs') }} {{ knp_pagination_sortable(cargoworks_list, 'Vol Kgs', 'w.vol_kgs') }} {{ knp_pagination_sortable(cargoworks_list, 'Chg Kgs', 'w.chg_kgs') }} {{ knp_pagination_sortable(cargoworks_list, 'Freight', 'w.freight') }} {{ knp_pagination_sortable(cargoworks_list, 'Reg Chrg', 'w.reg_charge') }} {{ knp_pagination_sortable(cargoworks_list, 'Fuel', 'w.fuel') }} {{ knp_pagination_sortable(cargoworks_list, 'Doc Fee', 'w.doc_fee') }} {{ knp_pagination_sortable(cargoworks_list, 'Ins Fee', 'w.ins_fee') }} {{ knp_pagination_sortable(cargoworks_list, 'Surcharge', 'w.surcharge') }} {{ knp_pagination_sortable(cargoworks_list, 'Other', 'w.other') }} {{ knp_pagination_sortable(cargoworks_list, 'Custom Duty', 'w.customs_duty') }} {{ knp_pagination_sortable(cargoworks_list, 'Custom Vat', 'w.customs_vat') }} {{ knp_pagination_sortable(cargoworks_list, 'Excl Vat', 'w.excl_vat') }} {{ knp_pagination_sortable(cargoworks_list, 'Vat', 'w.vat') }} {{ knp_pagination_sortable(cargoworks_list, 'Incl Vat', 'w.incl_vat') }} {{ knp_pagination_sortable(cargoworks_list, 'R/Kg', 'w.cost_per_kg') }} {{ knp_pagination_sortable(cargoworks_list, 'C/Kg', 'w.calc_cost_per_kg') }}
{{ with_selected_checkbox('cargoworks_list', wb_arr['data'].id) }} {% if is_granted('ROLE_ADMIN_WAYBILL_MANAGE') %} {% if pods == true %} {% else %} {% endif %} {% endif %} {% if docs == true %} {% else %} {% endif %} {% if is_granted('ROLE_ADMIN_WAYBILL_EDIT') %} {% if history == true %} {% elseif wb_arr['data'].locked == false %} {% endif %} {% endif %} {{ wb_arr['data'].waybill|trim }} {% if wb_arr['data'].captureDate is not null %} {{ wb_arr['data'].captureDate|date("Y/m/d") }} {% endif %} {% if wb_arr['data'].collectDate is not null %} {{ wb_arr['data'].collectDate|date("Y/m/d") }} {% endif %} {% if wb_arr['data'].podDate is not null %} {{ wb_arr['data'].podDate|date("Y/m/d") }} {% endif %} {{ wb_arr['data'].reference|trim }} {{ wb_arr['data'].additionalRef|trim }} {{ wb_arr['data'].sender|trim }} {{ wb_arr['data'].origin|trim }} {{ wb_arr['data'].receiver|trim }} {{ wb_arr['data'].destination|trim }} {{ wb_arr['data'].service|trim }} {{ wb_arr['data'].pieces }} {{ wb_arr['data'].actKgs|number_format(2, '.', '') }} {{ wb_arr['data'].volKgs|number_format(2, '.', '') }} {{ wb_arr['data'].chgKgs|number_format(2, '.', '') }} {{ wb_arr['data'].freight|number_format(2, '.', '') }} {{ wb_arr['data'].regCharge|number_format(2, '.', '') }} {{ wb_arr['data'].fuel|number_format(2, '.', '') }} {{ wb_arr['data'].docFee|number_format(2, '.', '') }} {{ wb_arr['data'].insFee|number_format(2, '.', '') }} {{ wb_arr['data'].surcharge|number_format(2, '.', '') }} {{ wb_arr['data'].other|number_format(2, '.', '') }} {{ wb_arr['data'].customsDuty|number_format(2, '.', '') }} {{ wb_arr['data'].customsVat|number_format(2, '.', '') }} {{ wb_arr['data'].exclVat|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'].vat|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'].inclVat|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 %}