{% extends 'base.html.twig' %} {% set bscgranted = is_granted("ROLE_MARKET") %} {% set beugranted = is_granted("ROLE_EUROPE") %} {% set beditmode = (plan and plan.fkplanstatus.code == "edition") %} {% block stylesheets %} {{ parent() }} {% endblock %} {% block breadcrumb_buttons %} {% endblock %} {% block body %}
{{dataset_complete|json_encode|raw}}
{% if plan %}

{{ plan.executionYear }}

{{ (plan.title == plan.executionYear) ? "" : "

#{plan.title}

"|raw }}

{{plan.fkplanstatus.name}}

More info
{% endif %}

{{ current_date }}

Current date

{% if plan %} {% if beditmode %}
{% endif %} {% if beditmode %} {% if beugranted %}

Markets

Market
Additional
Mandatory
Total
Kubota United Kingdom
4/25
2/5
6/30
Kubota Germany
10/25
4/5
14/30
Kubota Spain
12/25
3/5
15/30
Kubota Poland
9/25
4/5
13/30
Kubota France
9/25
2/5
11/30
Kubota Turkey
11/25
3/5
14/30
Kubota Italy
5/25
4/5
9/30
Kubota Holland
7/25
2/5
9/30
{% endif %}
{% if beugranted %}

Europe

Additional
25/25
Mandatory
5/5
Total
30/30
{% endif %} {% if bscgranted %}

Partners

All actions selected
0%
Plan approved
0%
{% else %}

Partner

Mandatory
0/25
Additional
0/5
{% endif %}
{% endif %} {% if bscgranted %}
{% if beugranted %}

Markets selector

{% else %}

Partner selector

{% endif %}
Market territories
Please, select one market in the map No territories in current market
{% if beugranted %} {% endif %}
Most efficient partners
{% if beugranted %} Kubota Poland {% else %} Partner Valencia {% endif %}
Least efficient partners
{% if beugranted %} Kubota Italy {% else %} Partner Murcia {% endif %}
{% if beditmode==false %}
{% if app.user.hasRole('ROLE_MARKET') %}

{{app.user.fkCompanyEntity.name}} ({{app.user.fkCompanyEntity.code}})

{% else %}

Europe

{% endif %} {% set prev_done = 0 %} {% set prev_pending = 0 %} {% set prev_expired = 0 %} {% if dataset_complete['all'] and dataset_complete['all']['total'] > 0 %} {% set prev_done = dataset_complete['all']['done'] / dataset_complete['all']['total'] * 100 %} {% set prev_pending = dataset_complete['all']['pending'] / dataset_complete['all']['total'] * 100 %} {% set prev_expired = dataset_complete['all']['expired'] / dataset_complete['all']['total'] * 100 %} {% endif %}
Actions done {{prev_done|round(1)}}%
n% Increase in 15 Days
Pending actions {{prev_pending|round(1)}}%
n% Increase in 15 Days
Actions not done {{prev_expired|round(1)}}%
n% Increase in 15 Days
{% else %}
{% if app.user.hasRole('ROLE_MARKET') %}

{{app.user.fkCompanyEntity.name}} ({{app.user.fkCompanyEntity.code}})

{% else %}

Europe

{% endif %}
% Actions created by Europe {{actions_europe_percentage|round(1)}}%
% Actions created by Market {{actions_market_percentage|round(1)}}%
% Plans validated {{plans_validated_percentage|round(1)}}%
{% for validate_plan in plans_validated %} {% endfor %} {% set prev_selected = 0 %} {% if num_actions_selectables > 0 and dataset_complete['all']['n_act_by_con'] and dataset_complete['partners']|length > 0 %} {% set prev_selected = dataset_complete['all']['n_act_by_con']/(num_actions_selectables*(dataset_complete['partners']|length)) * 100 %} {% endif %}
% Actions selected {{prev_selected|round(1)}}%
{% endif %}

Territories by market

{% set nterritory = 0 %} {% for territory in territories %} {% set done_percentage = 0 %} {% set pending_percentage = 0 %} {% set expired_percentage = 0 %} {% if beditmode==false %} {% else %} {% endif %} {% set nterritory = nterritory + 1 %} {% endfor %}
Name Market Status
{{ territory.name }} {{ territory.fkMarket.name }} {% if dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all'] %} {% if dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['total'] > 0 %} {% set done_percentage = dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['done'] / dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['total'] * 100 %} {% set pending_percentage = dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['pending'] / dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['total'] * 100 %} {% set expired_percentage = dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['expired'] / dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['total'] * 100 %} {% endif %} {% endif %}
{{done_percentage|round(1)}}%
{{pending_percentage|round(1)}}%
{{expired_percentage|round(1)}}%
{% set territory_percentage = 0 %} {% if dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['n_act_by_con'] and dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['n_act_by_con'] > 0 and dataset_complete['partners']|length > 0 and num_actions_selectables > 0 %} {% set num_partners_by_territory = 0 %} {% for partner in dataset_complete['partners'] %} {% if partner['territory_id'] == territory.rowid %} {% set num_partners_by_territory = num_partners_by_territory + 1 %} {% endif %} {% endfor %} {% if num_partners_by_territory > 0 %} {% set territory_percentage = (dataset_complete['markets'][territory.fkMarket.rowid]['territories'][territory.rowid]['all']['n_act_by_con'] / (num_actions_selectables * num_partners_by_territory))*100 %} {% endif %} {% endif %}
{{territory_percentage|round(1)}}%

Partners by territory

{% set npartner = 0 %} {% for partner in partners %} {% set done_percentage = 0 %} {% set pending_percentage = 0 %} {% set expired_percentage = 0 %} {% set style_extra = '' %} {% set route = path('actions_list_choose_validate', {partner_rowid:partner.getRowid(), plan_rowid:plan.rowid}) %} {% if dataset_complete['partners'][partner.rowid]['all']['total'] == 0 %} {% set route = '#!' %} {% set style_extra = 'cursor: not-allowed;' %} {% endif %} {% if beditmode==false %} {% else %} {% endif %} {% set npartner = npartner + 1 %} {% endfor %}
Name Territory Status
{{ partner.name }} {% if partner.fkTerritory %}{{ partner.fkTerritory.name }}{% endif %} {% if dataset_complete['partners'][partner.rowid]['all'] %} {% if dataset_complete['partners'][partner.rowid]['all']['total'] > 0 %} {% set done_percentage = dataset_complete['partners'][partner.rowid]['all']['done'] / dataset_complete['partners'][partner.rowid]['all']['total'] * 100 %} {% set pending_percentage = dataset_complete['partners'][partner.rowid]['all']['pending'] / dataset_complete['partners'][partner.rowid]['all']['total'] * 100 %} {% set expired_percentage = dataset_complete['partners'][partner.rowid]['all']['expired'] / dataset_complete['partners'][partner.rowid]['all']['total'] * 100 %} {% endif %} {% endif %}
{{done_percentage|round(1)}}%
{{pending_percentage|round(1)}}%
{{expired_percentage|round(1)}}%
{% set partner_percentage = 0 %} {% if dataset_complete['partners'][partner.rowid]['all']['n_act_by_con'] and dataset_complete['partners'][partner.rowid]['all']['n_act_by_con'] > 0 and num_actions_selectables > 0 %} {% if dataset_complete['partners'][partner.rowid]['all']['n_act_by_con'] > num_actions_selectables %} {% set partner_percentage = 100 %} {% else %} {% set partner_percentage = dataset_complete['partners'][partner.rowid]['all']['n_act_by_con'] / num_actions_selectables * 100 %} {% endif %} {% endif %}
{{partner_percentage|round(1)}}%
{% else %}
{% endif %} {% if bscgranted %}

Most selected actions (% relative)

Pref. for additional actions per function (%)

Pref. for additional actions per contract (%)

Annual action dispersion (med.)

{% endif %}
{% if beugranted %}

Partner plan history

{% for plan in plans %} {% endfor %}
Title Description Execution year Quarters
{{ plan.getTitle() }} {{ plan.getDescription() }} {{ plan.getExecutionYear() }} {{ plan.getQuarters()|join(', ') }}
{% endif %} {% if beditmode %}

Last actions added

{% for action in plan.getActions %} {% endfor %}
Title Timing Plan Mandatory Notification from {{ 'dashboard.departments'|trans }}
{{ action.getTitle() }} {{ action.getTimingString() }} {{ action.getFkPlan().getTitle() }} {{ (action.getMandatory())?"Yes":"No" }} {{ action.getNotificationFromString() }} {% if action.getFkDepartment().getName() == "Sales" %} {{ action.getFkDepartment().getName() }} {% elseif action.getFkDepartment().getName() == "Marketing" %} {{ action.getFkDepartment().getName() }} {% elseif action.getFkDepartment().getName() == "Development" %} {{ action.getFkDepartment().getName() }} {% elseif action.getFkDepartment().getName() == "Parts" %} {{ action.getFkDepartment().getName() }} {% elseif action.getFkDepartment().getName() == "Service" %} {{ action.getFkDepartment().getName() }} {% endif %}
{% endif %} {% if bscgranted %}

Last registered partners

{% for partner in partners|reverse %} {% endfor %}
Name Territory
{{ partner.name }} {{ (partner.fkTerritory)?partner.fkTerritory.name:""}}
{% endif %} {% if beditmode==false %}

Last actions done

{% for action in plan.getActions %} {% endfor %}
Title Timing Plan Mandatory Notification from {{ 'dashboard.departments'|trans }}
{{ action.getTitle() }} {{ action.getTimingString() }} {{ action.getFkPlan().getTitle() }} {{ (action.getMandatory())?"Yes":"No" }} {{ action.getNotificationFromString() }} {{ action.getFkDepartment().getName() }}
{% endif %}

{{ 'dashboard.actions_by_department'|trans }}

{% if beditmode==false %} {% if (beugranted == false) and (bscgranted == false) %} {% endif %} {% endif %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% if beditmode==false %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% endif %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% if beditmode==false %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% endif %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% if beditmode==false %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% endif %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% if beditmode==false %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% endif %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% if beditmode==false %} {% if (beugranted == false) and (bscgranted == false) %} {% else %} {% endif %} {% endif %}
{{ 'dashboard.departments'|trans }} Mandatory Actions Additional Actions Total ActionsDone (%)Fail (%)
Sales2 3 51 5 6100% 0%2% 1%
Marketing2 3 51 5 620% 20%6% 2%
Parts2 3 51 5 640% 20%12% 3%
Service2 3 51 5 660% 0%24% 5%
Development2 3 51 5 680% 0%16% 5%
{% if bscgranted %}

{{ 'dashboard.most_selected_actions_by_department'|trans }}

{{ 'dashboard.department'|trans }} Actions
Sales Action 2, Action 3, Action 1
Marketing Action 3, Action 5, Action 1
Parts Action 4, Action 5, Action 2
Service Action 2, Action 3, Action 1
Development Action 5, Action 3, Action 1
{% endif %} {% endif %}
{% endblock %} {% block javascripts %} {{ parent() }} {% endblock %}