TOUR DETAILS STATEMENT
For the period from {{ fromDate|date("d-m-Y") }} to {{ toDate|date("d-m-Y") }}
Print Date : {{ "now"|date("d-m-Y") }}

{% set totalAmount = 0 %} {% for tour_claim in tour_claims %} {% set totalAmount = ( totalAmount | default(0) ) + tour_claim.amount %} {% endfor %}

SL#	PIN	Employee	Designation	Department	Expense Type	Expense Purpose	Tour Scope	Customer Name	Place to Visit	Purpose of Tour	Result of Tour	Expenses Category	From / Place of Stay	From Date & Time	To / Place of Stay	To Date & Time	Mode of Transportation	Amount	Remarks
{{loop.index}}	{{tour_claim.tourClaim.tourRequest.user.username}}	{{tour_claim.tourClaim.tourRequest.user.fullName}}	{{ tour_claim.tourClaim.tourRequest.user.designation }}	{{ tour_claim.tourClaim.tourRequest.user.department }}	{{ tour_claim.tourClaim.tourRequest.expenseType.name }}	{{ tour_claim.tourClaim.tourRequest.expensePurpose.name }}	{{ tour_claim.tourClaim.tourRequest.tourScope }}	{{ tour_claim.tourClaim.tourRequest.expectVisit }}	{{ tour_claim.tourClaim.tourRequest.placeVisit }}	{{ tour_claim.tourClaim.tourRequest.tourPurpose\|slice(0, 55) }}	{{ tour_claim.tourClaim.tourDetails\|slice(0, 55) }}	{{ tour_claim.category }}	{{ tour_claim.fromPlace }}	{{ tour_claim.startingDate ? tour_claim.startingDate\|date('d-m-Y H:i:s') : '' }}	{{ tour_claim.toPlace }}	{{ tour_claim.endingDate ? tour_claim.endingDate\|date('d-m-Y H:i:s') : '' }}	{{ tour_claim.travelMode }}	{{ tour_claim.amount\|number_format(2, '.', ',') }}	{{ tour_claim.remarks }}
Grand Total :																		{{ totalAmount \|number_format(2, '.', ',')}}