<!DOCTYPE html>
<html lang="{{ app.locale }}">
{% from "macros/meta_fields.html.twig" import meta_field_value, form_type_value %}
{% set storageItemName = 'kimai_html_export' %}
{% set decimal = decimal|default(false) %}
{% set columnTitles = {} %}
{% set columns = {
    'date': true,
    'begin': false,
    'end': false,
    'username': false,
    'customer': true,
    'project': true,
    'activity': true,
    'description': false,
    'exported': false,
    'tags': false,
} %}

{% for id, field in timesheetMetaFields %}
    {% set columns = columns|merge({ ('t_' ~ field.name): true}) %}
    {% set columnTitles = columnTitles|merge({ ('t_' ~ field.name): (field.label)}) %}
{% endfor %}
{% for id, field in customerMetaFields %}
    {% set columns = columns|merge({ ('c_' ~ field.name): true}) %}
    {% set columnTitles = columnTitles|merge({ ('c_' ~ field.name): (field.label)}) %}
{% endfor %}
{% for id, field in projectMetaFields %}
    {% set columns = columns|merge({ ('p_' ~ field.name): true}) %}
    {% set columnTitles = columnTitles|merge({ ('p_' ~ field.name): (field.label)}) %}
{% endfor %}
{% for id, field in activityMetaFields %}
    {% set columns = columns|merge({ ('a_' ~ field.name): true}) %}
    {% set columnTitles = columnTitles|merge({ ('a_' ~ field.name): (field.label)}) %}
{% endfor %}
{% for id, field in userPreferences %}
    {% set columns = columns|merge({ ('u_' ~ field.name): true}) %}
    {% set columnTitles = columnTitles|merge({ ('u_' ~ field.name): (field.label)}) %}
{% endfor %}

{% set columns = columns|merge({
    'hourlyRate': false,
    'fixedRate': false,
    'duration': 'duration',
    'internalRate': 'internalRate',
    'rate': 'rate',
}) %}

{% set formItemClass = "d-inline-block w-auto text-nowrap me-2" %}
<head>
    <meta charset="utf-8">
    <meta content="width=device-width, initial-scale=1" name="viewport">
    {{ encore_entry_link_tags('app') }}
    {{ encore_entry_script_tags('app') }}
    <title>{{ 'export'|trans }}</title>
    <style>
        @media print{
            h2 { font-size: 22px; }
            h3 { font-size: 18px; }
            p, td { font-size: 11px; }
            th, td.totals { font-size: 12px; }
        }
        .items td.totals {
            font-weight: bold;
            text-align: right;
        }
        .items td.duration,
        .items th.duration,
        .items th.cost,
        .items td.cost,
        .items th.column-rate,
        .items th.column-internalRate,
        .items th.column-hourlyRate,
        .items th.column-fixedRate,
        .items th.column-duration {
            text-align: right;
        }
        .items th.column-exported {
            text-align: center;
        }
        .table>thead:first-child>tr:first-child>th {
            padding-right: 5px;
        }
    </style>
</head>
<body class="pad export_print">
    <div class="wrapper">
        <section class="export">

            <form class="w-100 d-print-none row row-cards p-3">
                <div class="card mb-1 p-0">
                    <div class="card-header">
                        {{ 'settings'|trans }}
                    </div>
                    <div class="card-body">
                        <label for="duration-decimal">
                            <input type="checkbox" id="duration-decimal" name="duration-decimal"{% if decimal%} checked="checked"{% endif %}>
                            {{ 'export_decimal'|trans }}
                        </label>
                        |
                        <label for="date-format">
                            {{ 'date'|trans }}:
                            {% set demo_date = create_date('2024-01-01 11:00:00') %}
                            <select id="date-format" name="date-format">
                                <option value="short">{{ demo_date|date_short }}</option>
                                <option value="time">{{ demo_date|date_time }}</option>
                            </select>
                        </label>
                        |
                        <label for="begin-format">
                            {{ 'begin'|trans }}:
                            {% set demo_date = create_date('2024-01-01 11:00:00') %}
                            <select id="begin-format" name="begin-format">
                                <option value="plain">{{ demo_date|date_format('H:i') }}</option>
                                <option value="short">{{ demo_date|date_short }}</option>
                                <option value="time">{{ demo_date|date_time }}</option>
                            </select>
                        </label>
                        |
                        <label for="end-format">
                            {{ 'end'|trans }}:
                            {% set demo_date = create_date('2024-01-01 18:00:00') %}
                            <select id="end-format" name="end-format">
                                <option value="plain">{{ demo_date|date_format('H:i') }}</option>
                                <option value="short">{{ demo_date|date_short }}</option>
                                <option value="time">{{ demo_date|date_time }}</option>
                            </select>
                        </label>
                        <button type="reset" class="btn btn-primary btn-sm pull-right" onclick="resetExport()">{{ 'action.reset'|trans }}</button>
                    </div>
                </div>

                <div class="card mb-1 p-0">
                    <div class="card-header">
                        <label for="summary-show">
                            <input type="checkbox" id="summary-show" name="summary-show" checked="checked">
                            {{ 'export.summary'|trans }}
                        </label>
                    </div>
                    <div class="card-body w-100">
                        <div class="{{ formItemClass }}">
                            <label for="summary-by-activities">
                                <input type="checkbox" id="summary-by-activities" name="summary-by-activities">
                                {{ 'activity'|trans }}
                            </label>
                        </div>
                        <div class="{{ formItemClass }}">
                            <label for="summary-timeBudget">
                                <input type="checkbox" id="summary-timeBudget" name="summary-timeBudget" checked>
                                {{ 'timeBudget'|trans }}
                            </label>
                        </div>
                        <div class="{{ formItemClass }}">
                            <label for="summary-budget">
                                <input type="checkbox" id="summary-budget" name="summary-budget" checked>
                                {{ 'budget'|trans }}
                            </label>
                        </div>

                        <div class="{{ formItemClass }}">
                            <label for="summary-duration">
                                <input type="checkbox" id="summary-duration" name="summary-duration" checked>
                                {{ 'duration'|trans }}
                            </label>
                        </div>
                        <div class="{{ formItemClass }}">
                            <label for="summary-internalRate">
                                <input type="checkbox" id="summary-internalRate" name="summary-internalRate" checked>
                                {{ 'internalRate'|trans }}
                            </label>
                        </div>
                        <div class="{{ formItemClass }}">
                            <label for="summary-rate">
                                <input type="checkbox" id="summary-rate" name="summary-rate" checked>
                                {{ 'rate'|trans }}
                            </label>
                        </div>
                    </div>
                </div>

                <div class="card mb-1 p-0">
                    <div class="card-header">
                        <div class="{{ formItemClass }}">
                            <label for="records-show">
                                <input type="checkbox" id="records-show" name="records-show" checked="checked">
                                {{ 'export.full_list'|trans }}
                            </label>
                        </div>
                    </div>
                    <div class="card-body">
                        {% for columnId, visibility in columns %}
                            <div class="{{ formItemClass }}">
                                <label for="records-column-{{ columnId }}">
                                    <input type="checkbox" class="column-visibility-changer" id="records-column-{{ columnId }}" name="{{ columnId }}" {% if visibility %}checked="checked"{% endif %}>
                                    {{ columnTitles[columnId]|default(columnId)|trans }}
                                </label>
                            </div>
                        {% endfor %}
                    </div>
                </div>
            </form>

            <div class="row m-3">
                <div class="col-xs-12">
                    <h2 id="doc-title" contenteditable="true" data-original="{{ 'export.document_title'|trans }}">{{ 'export.document_title'|trans }}</h2>
                    <p>
                        {{ 'export.period'|trans }}:
                        {{ query.begin|date_short }} - {{ query.end|date_short }}
                    </p>
                </div>
            </div>

            <div class="row m-3" id="export-summary">
                <div class="card p-0">
                    <div class="card-header">
                        <h3 class="card-title" id="doc-summary" contenteditable="true" data-original="{{ 'export.summary'|trans }}">{{ 'export.summary'|trans }}</h3>
                    </div>
                    <table class="items table table-sm table-bordered dataTable" id="summary-project">
                        <thead>
                        <tr>
                            <th>{{ 'customer'|trans }}</th>
                            <th>{{ 'project'|trans }}</th>
                            <th class="center export-timeBudget">{{ 'timeBudget'|trans }}</th>
                            <th class="center export-budget">{{ 'budget'|trans }}</th>
                            <th class="duration summary-duration">{{ 'duration'|trans }}</th>
                            <th class="cost summary-internalRate">{{ 'internalRate'|trans }}</th>
                            <th class="cost summary-rate">{{ 'rate'|trans }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        {% set customer = null %}
                        {% set customerDuration = 0 %}
                        {% set customerRate = 0 %}
                        {% set customerInternalRate = 0 %}
                        {% set customerCurrency = null %}
                        {% for id, summary in summaries %}
                            {% if customer is same as(null) %}
                                {% set customer = summary.customer %}
                                {% set customerCurrency = summary.currency %}
                            {% endif %}
                            {% if customer is not same as(summary.customer) %}
                                {% set durationNormal = customerDuration|duration(false) %}
                                {% set durationDecimal = customerDuration|duration(true) %}
                                <tr class="summary">
                                    <td colspan="2">&nbsp;</td>
                                    <td class="export-timeBudget"></td>
                                    <td class="export-budget"></td>
                                    <td class="totals duration summary-duration">
                                        <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                    </td>
                                    <td class="totals cost summary-internalRate">{{ customerInternalRate|money(customerCurrency) }}</td>
                                    <td class="totals cost summary-rate">{{ customerRate|money(customerCurrency) }}</td>
                                </tr>
                                {% set customerCurrency = summary.currency %}
                                {% set customer = summary.customer %}
                                {% set customerDuration = 0 %}
                                {% set customerRate = 0 %}
                                {% set customerInternalRate = 0 %}
                            {% endif %}
                            <tr>
                                <td>{{ summary.customer }}</td>
                                <td>{{ summary.project }}</td>
                                <td class="center export-timeBudget">
                                    {% if budgets[id] is defined and budgets[id].time_left > 0 %}
                                        {% set durationNormal = budgets[id].time_left|duration(false) %}
                                        {% set durationDecimal = budgets[id].time_left|duration(true) %}
                                        <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                    {% endif %}
                                </td>
                                <td class="center export-budget">
                                    {% if budgets[id] is defined and budgets[id].money_left > 0 %}
                                        {{ budgets[id].money_left|money(summary.currency) }}
                                    {% endif %}
                                </td>
                                <td class="duration summary-duration">
                                    {% set durationNormal = summary.duration|duration(false) %}
                                    {% set durationDecimal = summary.duration|duration(true) %}
                                    <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                </td>
                                <td class="cost summary-internalRate">{{ summary.rate_internal|money(summary.currency) }}</td>
                                <td class="cost summary-rate">{{ summary.rate|money(summary.currency) }}</td>
                            </tr>
                            {% set customerDuration = customerDuration + summary.duration %}
                            {% set customerRate = customerRate + summary.rate %}
                            {% set customerInternalRate = customerInternalRate + summary.rate_internal %}
                        {% endfor %}
                        {% if customer is not same as(null) %}
                            {% set durationNormal = customerDuration|duration(false) %}
                            {% set durationDecimal = customerDuration|duration(true) %}
                            <tr class="summary">
                                <td colspan="2">&nbsp;</td>
                                <td class="export-timeBudget"></td>
                                <td class="export-budget"></td>
                                <td class="totals duration summary-duration">
                                    <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                </td>
                                <td class="totals cost summary-internalRate">{{ customerInternalRate|money(customerCurrency) }}</td>
                                <td class="totals cost summary-rate">{{ customerRate|money(customerCurrency) }}</td>
                            </tr>
                        {% endif %}
                        </tbody>
                    </table>

                    {#
                    ============================================
                    SUMMARY: BY ACTIVITY
                    ============================================
                    #}

                    <table class="items table table-sm table-bordered dataTable" id="summary-activity" style="display:none">
                        <thead>
                        <tr>
                            <th>{{ 'customer'|trans }}</th>
                            <th>{{ 'project'|trans }}</th>
                            <th>{{ 'activity'|trans }}</th>
                            <th class="center export-timeBudget">{{ 'timeBudget'|trans }}</th>
                            <th class="center export-budget">{{ 'budget'|trans }}</th>
                            <th class="duration summary-duration">{{ 'duration'|trans }}</th>
                            <th class="cost summary-internalRate">{{ 'internalRate'|trans }}</th>
                            <th class="cost summary-rate">{{ 'rate'|trans }}</th>
                        </tr>
                        </thead>
                        <tbody>
                        {% set customer = null %}
                        {% set customerDuration = 0 %}
                        {% set customerRate = 0 %}
                        {% set customerInternalRate = 0 %}
                        {% set customerCurrency = null %}
                        {% for id, summary in summaries %}
                            {% if customer is same as(null) %}
                                {% set customer = summary.customer %}
                                {% set customerCurrency = summary.currency %}
                            {% endif %}
                            {% if customer is not same as(summary.customer) %}
                                <tr class="summary">
                                    <td colspan="3"></td>
                                    <td class="export-timeBudget"></td>
                                    <td class="export-budget"></td>
                                    <td class="totals duration summary-duration">
                                        {% set durationNormal = customerDuration|duration(false) %}
                                        {% set durationDecimal = customerDuration|duration(true) %}
                                        <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                    </td>
                                    <td class="totals cost summary-internalRate">{{ customerInternalRate|money(customerCurrency) }}</td>
                                    <td class="totals cost summary-rate">{{ customerRate|money(customerCurrency) }}</td>
                                </tr>
                                {% set customerCurrency = summary.currency %}
                                {% set customer = summary.customer %}
                                {% set customerDuration = 0 %}
                                {% set customerRate = 0 %}
                                {% set customerInternalRate = 0 %}
                            {% endif %}
                            {% for activityId, activitySummary in summary.activities %}
                                <tr>
                                    <td>{{ summary.customer }}</td>
                                    <td>{{ summary.project }}</td>
                                    <td>{{ activitySummary.activity }}</td>
                                    {% if activity_budgets[id] is defined and activity_budgets[id][activityId] is defined %}
                                        <td class="center export-timeBudget">
                                            {% if activity_budgets[id][activityId].time_left > 0 %}
                                                {% set durationNormal = activity_budgets[id][activityId].time_left|duration(false) %}
                                                {% set durationDecimal = activity_budgets[id][activityId].time_left|duration(true) %}
                                                <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                            {% endif %}
                                        </td>
                                        <td class="center export-budget">
                                            {% if activity_budgets[id][activityId].money_left > 0 %}
                                                {{ activity_budgets[id][activityId].money_left|money(summary.currency) }}
                                            {% endif %}
                                        </td>
                                    {% else %}
                                        <td class="center export-timeBudget"></td>
                                        <td class="center export-budget"></td>
                                    {% endif %}
                                    <td class="duration summary-duration">
                                        {% set durationNormal = activitySummary.duration|duration(false) %}
                                        {% set durationDecimal = activitySummary.duration|duration(true) %}
                                        <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                    </td>
                                    <td class="cost summary-internalRate">{{ activitySummary.rate_internal|money(activitySummary.currency) }}</td>
                                    <td class="cost summary-rate">{{ activitySummary.rate|money(activitySummary.currency) }}</td>
                                </tr>
                            {% endfor %}
                            {% set customerDuration = customerDuration + summary.duration %}
                            {% set customerRate = customerRate + summary.rate %}
                            {% set customerInternalRate = customerInternalRate + summary.rate_internal %}
                        {% endfor %}
                        {% if customer is not same as(null) %}
                            <tr class="summary">
                                <td colspan="3"></td>
                                <td class="export-timeBudget"></td>
                                <td class="export-budget"></td>
                                <td class="totals duration summary-duration">
                                    {% set durationNormal = customerDuration|duration(false) %}
                                    {% set durationDecimal = customerDuration|duration(true) %}
                                    <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                </td>
                                <td class="totals cost summary-internalRate">{{ customerInternalRate|money(customerCurrency) }}</td>
                                <td class="totals cost summary-rate">{{ customerRate|money(customerCurrency) }}</td>
                            </tr>
                        {% endif %}
                        </tbody>
                    </table>
                </div>
            </div>

            <div class="row m-3" id="export-records">
                <div class="card p-0">
                    <div class="card-header">
                        <h3 class="card-title" id="doc-records" contenteditable="true" data-original="{{ 'export.full_list'|trans }}">{{ 'export.full_list'|trans }}</h3>
                    </div>
                    <table class="items table table-sm table-bordered dataTable">
                        <thead>
                        <tr>
                            {% for columnId, visibility in columns %}
                                <th class="column column-{{ columnId }}" {% if not visibility %}style="display: none"{% endif %}>
                                    {{ columnTitles[columnId]|default(columnId)|trans }}
                                </th>
                            {% endfor %}
                        </tr>
                        </thead>
                        <tbody>
                        {% set timeWorked = 0 %}
                        {% set rateTotal = 0 %}
                        {% set rateInternalTotal = 0 %}
                        {% set currency = false %}
                        {% for entry in entries %}
                            {% set timeWorked = timeWorked + entry.duration %}
                            {% set rateTotal = rateTotal + entry.rate %}
                            {% if entry.internalRate is defined %}
                                {% set rateInternalTotal = rateInternalTotal + entry.internalRate %}
                            {% else %}
                                {% set rateInternalTotal = rateInternalTotal + entry.rate %}
                            {% endif %}
                            {% if currency is same as(false) %}
                                {% set currency = entry.project.customer.currency %}
                            {% endif %}
                            {% if currency is not same as(entry.project.customer.currency) %}
                                {% set currency = null %}
                            {% endif %}
                            <tr>
                                <td class="column-date text-nowrap" {% if not columns.date %}style="display: none"{% endif %}>
                                        <span class="dateformat" data-short="{{ entry.begin|date_short }}" data-full="{{ entry.begin|date_time }}" data-time="{{ entry.begin|date_time }}">
                                        {{ entry.begin|date_short }}
                                        </span>
                                </td>
                                <td class="column-begin text-nowrap" {% if not columns.begin %}style="display: none"{% endif %}>
                                        <span class="beginformat" data-short="{{ entry.begin|date_short }}" data-full="{{ entry.begin|date_time }}" data-time="{{ entry.begin|date_time }}" data-plain="{{ entry.begin|date_format('H:i') }}">
                                        {{ entry.begin|date_format('H:i') }}
                                        </span>
                                </td>
                                <td class="column-end text-nowrap" {% if not columns.end %}style="display: none"{% endif %}>
                                        <span class="endformat" data-short="{{ entry.end|date_short }}" data-full="{{ entry.end|date_time }}" data-time="{{ entry.end|date_time }}" data-plain="{{ entry.end|date_format('H:i') }}">
                                        {{ entry.end|date_format('H:i') }}
                                        </span>
                                </td>
                                <td class="column-username" {% if not columns.username %}style="display: none"{% endif %}>
                                    {{ entry.user.displayName }}
                                </td>
                                <td class="column-customer" {% if not columns.customer %}style="display: none"{% endif %}>
                                    {{ entry.project.customer.name }}
                                </td>
                                <td class="column-project" {% if not columns.project %}style="display: none"{% endif %}>{{ entry.project.name }}
                                </td>
                                <td class="column-activity" {% if not columns.activity %}style="display: none"{% endif %}>
                                    {% if entry.activity is not null %}
                                        {{ entry.activity.name }}
                                    {% endif %}
                                </td>
                                <td class="column-description" {% if not columns.description %}style="display: none"{% endif %}>
                                    {% if entry.description is not empty %}
                                        {{ entry.description|desc2html }}
                                    {% endif %}
                                </td>
                                <td class="column-exported text-center" {% if not columns.exported %}style="display: none"{% endif %}>
                                    {% set export_class = entry.exported ? 'success' : 'default' %}
                                    <span class="badge bg-{{ export_class }} text-{{ export_class }}-fg">{{ (entry.exported ? 'yes' : 'no')|trans }}</span>
                                </td>
                                <td class="column-tags" {% if not columns.tags %}style="display: none"{% endif %}>
                                    {% if entry.tags is defined and entry.tags is not empty %}
                                        {{ entry.tagsAsArray|join(', ') }}
                                    {% endif %}
                                </td>
                                {% for id, field in timesheetMetaFields %}
                                    <td class="column-{{ 't_' ~ field.name }} text-nowrap" {% if not columns['t_' ~ field.name] %}style="display: none"{% endif %}>
                                        {{ meta_field_value(entry, field) }}
                                    </td>
                                {% endfor %}
                                {% for id, field in customerMetaFields %}
                                    <td class="column-{{ 'c_' ~ field.name }} text-nowrap" {% if not columns['c_' ~ field.name] %}style="display: none"{% endif %}>
                                        {{ meta_field_value(entry.project.customer, field) }}
                                    </td>
                                {% endfor %}
                                {% for id, field in projectMetaFields %}
                                    <td class="column-{{ 'p_' ~ field.name }} text-nowrap" {% if not columns['p_' ~ field.name] %}style="display: none"{% endif %}>
                                        {{ meta_field_value(entry.project, field) }}
                                    </td>
                                {% endfor %}
                                {% for id, field in activityMetaFields %}
                                    <td class="column-{{ 'a_' ~ field.name }} text-nowrap" {% if not columns['a_' ~ field.name] %}style="display: none"{% endif %}>
                                        {% if entry.activity is not null %}
                                            {{ meta_field_value(entry.activity, field) }}
                                        {% endif %}
                                    </td>
                                {% endfor %}
                                {% for id, field in userPreferences %}
                                    <td class="column-{{ 'u_' ~ field.name }} text-nowrap" {% if not columns['u_' ~ field.name] %}style="display: none"{% endif %}>
                                        {% set metaField = entry.user.preference(field.name) %}
                                        {% if not metaField is null and metaField.value is not null and metaField.value is not empty %}
                                            {{ form_type_value(field.type, metaField.value, entry.user) }}
                                        {% endif %}
                                    </td>
                                {% endfor %}
                                <td class="cost column-hourlyRate text-nowrap" {% if not columns.hourlyRate %}style="display: none"{% endif %}>
                                    {{ entry.hourlyRate|money(entry.project.customer.currency) }}
                                </td>
                                <td class="cost column-fixedRate text-nowrap" {% if not columns.fixedRate %}style="display: none"{% endif %}>
                                    {{ entry.fixedRate|money(entry.project.customer.currency) }}
                                </td>
                                <td class="duration column-duration text-nowrap" {% if not columns.duration %}style="display: none"{% endif %}>
                                    {% set durationNormal = entry.duration|duration(false) %}
                                    {% set durationDecimal = entry.duration|duration(true) %}
                                    <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                                </td>
                                <td class="cost column-internalRate text-nowrap" {% if not columns.internalRate %}style="display: none"{% endif %}>
                                    {% if entry.internalRate is defined %}
                                        {{ entry.internalRate|money(entry.project.customer.currency) }}
                                    {% else %}
                                        {{ entry.rate|money(entry.project.customer.currency) }}
                                    {% endif %}
                                </td>
                                <td class="cost column-rate text-nowrap" {% if not columns.rate %}style="display: none"{% endif %}>
                                    {{ entry.rate|money(entry.project.customer.currency) }}
                                </td>
                            </tr>
                        {% endfor %}
                        {# leave in tbody instead of adding it to tfoot, as tfoot will be repeated on each page when printing #}
                        <tr>
                            {% for id, visibility in columns %}
                                {% if id not in ['duration', 'rate', 'internalRate'] %}
                                    <th class="column-{{ id }}" {% if not visibility %}style="display: none"{% endif %}></th>
                                {% endif %}
                            {% endfor %}
                            <th class="text-nowrap column-duration">
                                {% set durationNormal = timeWorked|duration(false) %}
                                {% set durationDecimal = timeWorked|duration(true) %}
                                <span class="duration-format" data-duration-decimal="{{ durationDecimal }}" data-duration="{{ durationNormal }}">{{ decimal ? durationDecimal : durationNormal }}</span>
                            </th>
                            <th class="text-nowrap column-internalRate">
                                {%- if currency is not null and currency is not same as(false) %}
                                    {{ rateInternalTotal|money(currency) }}
                                {% else %}
                                    {{ rateInternalTotal|money }}
                                {% endif -%}
                            </th>
                            <th class="text-nowrap column-rate">
                                {%- if currency is not null and currency is not same as(false) %}
                                    {{ rateTotal|money(currency) }}
                                {% else %}
                                    {{ rateTotal|money }}
                                {% endif -%}
                            </th>
                        </tr>
                        </tbody>
                    </table>
                </div>
            </div>

        </section>
    </div>

    <script type="text/javascript">
        let initialized = false;

        document.getElementById('duration-decimal').addEventListener('click', function(event) {
            var spans = document.getElementsByClassName('duration-format');
            for (var span of spans) {
                if (!event.target.checked) {
                    if (span.dataset['duration'] !== undefined) {
                        span.innerHTML = span.dataset['duration'];
                    }
                } else {
                    if (span.dataset['durationDecimal'] !== undefined) {
                        span.innerHTML = span.dataset['durationDecimal'];
                    }
                }
            }
            saveVisibility();
        });

        document.getElementById('summary-by-activities').addEventListener('click', function(event) {
            document.getElementById('summary-project').style.display = event.target.checked ? 'none' : 'table';
            document.getElementById('summary-activity').style.display = event.target.checked ? 'table' : 'none';
            saveVisibility();
        });
        document.getElementById('date-format').addEventListener('change', function(event) {
            changedDateFormat(event.target.value, 'dateformat');
        });
        document.getElementById('begin-format').addEventListener('change', function(event) {
            changedDateFormat(event.target.value, 'beginformat');
        });
        document.getElementById('end-format').addEventListener('change', function(event) {
            changedDateFormat(event.target.value, 'endformat');
        });
        document.getElementById('summary-show').addEventListener('click', function(event) {
            document.getElementById('export-summary').style.display = event.target.checked ? 'block' : 'none';
            saveVisibility();
        });
        document.getElementById('summary-timeBudget').addEventListener('click', function(event) {
            let cells = document.getElementsByClassName('export-timeBudget');
            for (let columnCell of cells) {
                columnCell.style.display = event.target.checked ? 'table-cell' : 'none';
            }
            saveVisibility();
        });
        document.getElementById('summary-budget').addEventListener('click', function(event) {
            let cells = document.getElementsByClassName('export-budget');
            for (let columnCell of cells) {
                columnCell.style.display = event.target.checked ? 'table-cell' : 'none';
            }
            saveVisibility();
        });
        document.getElementById('summary-duration').addEventListener('click', function(event) {
            let cells = document.getElementsByClassName('summary-duration');
            for (let columnCell of cells) {
                columnCell.style.display = event.target.checked ? 'table-cell' : 'none';
            }
            saveVisibility();
        });
        document.getElementById('summary-rate').addEventListener('click', function(event) {
            let cells = document.getElementsByClassName('summary-rate');
            for (let columnCell of cells) {
                columnCell.style.display = event.target.checked ? 'table-cell' : 'none';
            }
            saveVisibility();
        });
        document.getElementById('summary-internalRate').addEventListener('click', function(event) {
            let cells = document.getElementsByClassName('summary-internalRate');
            for (let columnCell of cells) {
                columnCell.style.display = event.target.checked ? 'table-cell' : 'none';
            }
            saveVisibility();
        });
        document.getElementById('summary-show').addEventListener('click', function(event) {
            document.getElementById('export-summary').style.display = event.target.checked ? 'block' : 'none';
            saveVisibility();
        });
        document.getElementById('records-show').addEventListener('click', function(event) {
            document.getElementById('export-records').style.display = event.target.checked ? 'block' : 'none';
            saveVisibility();
        });

        let columnCheckboxes = document.getElementsByClassName('column-visibility-changer');

        for (let checkbox of columnCheckboxes) {
            checkbox.addEventListener('click', function(event) {
                changeVisibility(event.target.name, event.target.checked);
            });
        }

        let editableTitles = document.querySelectorAll('[contenteditable=true]');

        for (let editable of editableTitles) {
            editable.addEventListener('input', function(event) {
                if (event.target.innerText === '') {
                    return;
                }
                saveVisibility();
            });
        }

        // needs to be executed as last action in the flow, after the listener were registered
        let config = localStorage.getItem('{{ storageItemName }}');
        if (config !== null) {
            try {
                config = JSON.parse(config);
                for (const elName in config) {
                    if (!config.hasOwnProperty(elName)) {
                        continue;
                    }
                    let elValue = config[elName];
                    let el = document.getElementById(elName);
                    if (el === undefined || el === null) {
                        el = document.getElementById('records-column-' + elName);
                        if (el === undefined || el === null) {
                            continue;
                        }
                    }
                    if (el.type === 'checkbox') {
                        if (elValue !== el.checked) {
                            el.click();
                        }
                    } else if (el.type === 'select-one') {
                        if (el.value !== elValue) {
                            el.value = elValue;
                            el.dispatchEvent(new Event('change'));
                        }
                    } else if (el.isContentEditable) {
                        el.innerText = elValue;
                    }
                }
            } catch (e) {
                // ignore error in restoring
                console.log('Failed to restore settings, removing invalid settings', e);
                localStorage.removeItem('{{ storageItemName }}');
            }
        }

        initialized = true;

        function changeVisibility(column, visible)
        {
            let cells = document.getElementsByClassName('column-' + column);
            for (let columnCell of cells) {
                columnCell.style.display = visible ? 'table-cell' : 'none';
            }
            saveVisibility();
        }

        function changedDateFormat(formatType, className)
        {
            let elements = document.getElementsByClassName(className);
            for (let elem of elements) {
                let formattedDate = elem.dataset[formatType];
                if (formattedDate === undefined) {
                    continue;
                }
                elem.innerHTML = formattedDate;
            }
            saveVisibility();
        }

        function saveVisibility()
        {
            if (!initialized) {
                return;
            }

            const form = document.getElementsByTagName('form')[0];
            let settings = {};
            for (let checkbox of form.querySelectorAll('input[type=checkbox]')) {
                settings[checkbox.getAttribute('id')] = checkbox.checked;
            }
            for (let selectbox of form.querySelectorAll('select')) {
                settings[selectbox.getAttribute('id')] = selectbox.value;
            }
            for (let editable of document.querySelectorAll('[contenteditable=true]')) {
                settings[editable.getAttribute('id')] = editable.innerText;
            }
            localStorage.setItem('{{ storageItemName }}', JSON.stringify(settings));
        }

        function resetExport()
        {
            let editableTitles = document.querySelectorAll('[contenteditable=true]');

            for (let editable of editableTitles) {
                editable.innerText = editable.dataset['original'];
            }

            localStorage.removeItem('{{ storageItemName }}');
            const form = document.getElementsByTagName('form')[0];
            form.reset();
        }
    </script>
</body>
</html>
