{% block body %}

Cross World
Plot 1/B, Road 90, Gulshan -2, Dhaka 1212.

TOUR REPORT (TR) and Tour Bill Claim
1. Employee PIN : {{ tour_claim.tourRequest.user.userName }}
2. Name : {{ tour_claim.tourRequest.user.fullName }}
3. Designation : {{ tour_claim.tourRequest.user.designation }}
4. Department : {{ tour_claim.tourRequest.user.department }}
5. Expense Type : {{ tour_claim.tourRequest.expenseType.name }}
6. Expense Purpose : {{ tour_claim.tourRequest.expensePurpose.name }}
7. Place to Visit : {{ tour_claim.tourRequest.placeVisit }}
8. Name of Customer Visited : {{ tour_claim.tourRequest.expectVisit }}
9. Report submission date : {{ tour_claim.submitionDate|date("d-m-Y") }}
10. Actual Tour starting date & time : {{ tour_claim.startingDate ? tour_claim.startingDate|date('d-m-Y H:i:s') : '' }}
11. Actual Tour ending date & time : {{ tour_claim.endingDate ? tour_claim.endingDate|date('d-m-Y H:i:s') : '' }}
12. Tour Details : {{ tour_claim.tourDetails }}
{% set grandTotalAmount = 0 %} {% for tourClaimDetailsGroup in tourClaimDetailsGroupBy %}
Category : {{tourClaimDetailsGroup.category}}
{% set totalAmount = 0 %} {% for tourDetails in tour_claim.tourClaimDetails %} {% if tourClaimDetailsGroup.category == tourDetails.category %} {% set counter = ( counter | default(0) ) + 1 %} {% set totalAmount = ( totalAmount | default(0) ) + tourDetails.amount %} {% set grandTotalAmount = ( grandTotalAmount | default(0) ) + tourDetails.amount %} {% endif %} {% endfor %}
From / Place of Stay To / Place of Stay From Date & Time To Date & Time Mode of Transportation Amount Remarks
{{ tourDetails.fromPlace }} {{ tourDetails.toPlace }} {{ tourDetails.startingDate ? tourDetails.startingDate|date('d-m-Y H:i:s') : '' }} {{ tourDetails.endingDate ? tourDetails.endingDate|date('d-m-Y H:i:s') : '' }} {{ tourDetails.travelMode }} {{ tourDetails.amount |number_format(2, '.', ',')}} {{ tourDetails.amountCurrency }} {{ tourDetails.remarks }}
Total Amount: {{ totalAmount|number_format(2, '.', ',') }}
{% endfor %}
Grand Total Amount : {{ grandTotalAmount |number_format(2, '.', ',')}}
{# #} {# #}
Superviser / Functional Head Approval Department's Head Approval CBO's Approval

HR Department's Comment

{% if functionalHeadObj is not null %} Approved By
{{ functionalHeadObj.fullName }}
{{ tour_claim.fhApprovalDate|date('d-m-Y') }} {% endif %}
---------------------
Signature & Date
Approved By
{{ departmentHeadObj.fullName }}
{{ tour_claim.dhApprovalDate|date('d-m-Y') }}
---------------------
Signature & Date
Approved By
{{ ceoObj.fullName }}
{{ tour_claim.ceoApprovalDate|date('d-m-Y') }}
---------------------
Signature & Date

---------------------
Signature & Date
This is a system generated bill and does not require a signature.

Note:
1. Original Invoices/Bills must be attached in support of expenses (Hotel, Transportation, Tickets, Food Bills etc). No claim shall be honored without proper supportive invoices/bills.
2. TR to be submitted within two days of tour completion
3. Extra page can be used if required
4. One copy of the Tour report to be kept in the personal file of the employee
5. CBO’s approval is required only for Manager’s and above.

{% endblock %}