Guest Folio

Printed: {{ date('d-m-Y H:i') }}

@php /*echo '

';
            print_r($RoomCharges);
            echo '

';*/ @endphp

Guest Info

Name: {{ optional($GuestFolioInfo)->guest_firstname . ' ' . optional($GuestFolioInfo)->guest_lastname }}

@isset($GuestFolioInfo->guest_cmpname)

Company: {{ $GuestFolioInfo->guest_cmpname }}

@endisset

Address: {{ $GuestFolioInfo->address }}

Stay Details

Arrival Mode: {{ $GuestFolioInfo->arrivalname }}

Room Type: {{ $GuestFolioInfo->roomtypename }}

No. of Days: {{ $GuestFolioInfo->noofdays }}

No. of Pax: {{ $GuestFolioInfo->noofpax }}

Booking Info

GRC: {{ $GuestFolioInfo->grcno }}

Arr. Date: {{ \Carbon\Carbon::parse($GuestFolioInfo?->checkindatetime)->format('d-m-Y H:i') }}

Exp. Checkout: {{ \Carbon\Carbon::parse($GuestFolioInfo?->likelycheckoutdate)->format('d-m-Y H:i') }}

Printed By: {{ session('user_name') }}

@php $grand_amount = $grand_discount = $grand_taxable = 0; $grand_igst = $grand_cgst = $grand_sgst = 0; $grand_debit = $grand_credit = $grand_dayclose = 0; $currentDate = null; $date_amount = $date_discount = $date_taxable = 0; $date_igst = $date_cgst = $date_sgst = 0; $date_debit = $date_credit = $date_dayclose = 0; @endphp @foreach ($RoomCharges as $charge) @php $date = \Carbon\Carbon::parse($charge->crgdate)->format('d-m-Y'); $taxable = $charge->amount - $charge->discount; // Check if date changes => print subtotal row if ($currentDate && $currentDate !== $date) { echo ''; // Reset date totals $date_amount = $date_discount = $date_taxable = 0; $date_igst = $date_cgst = $date_sgst = 0; $date_debit = $date_credit = $date_dayclose = 0; } // Update running totals $date_amount += $charge->amount; $date_discount += $charge->discount; $date_taxable += $taxable; $date_igst += $charge->IGST; $date_cgst += $charge->CGST; $date_sgst += $charge->SGST; $date_debit += $charge->debit; $date_credit += $charge->credit; $date_dayclose += $charge->debit - $charge->credit; $grand_amount += $charge->amount; $grand_discount += $charge->discount; $grand_taxable += $taxable; $grand_igst += $charge->IGST; $grand_cgst += $charge->CGST; $grand_sgst += $charge->SGST; $grand_debit += $charge->debit; $grand_credit += $charge->credit; $grand_dayclose += $charge->debit - $charge->credit; $currentDate = $date; @endphp @endforeach {{-- Last Date Subtotal --}} {{-- Grand Total --}}

Date Time	Room No	Ref	Charges	Rate	Disc	Taxable	Tax			Debit	Credit	Day Close
Date Time	Room No	Ref	Charges	Rate	Disc	Taxable	IGST	CGST	SGST	Debit	Credit	Day Close
Subtotal for ' . $currentDate . '				' . number_format($date_amount, 2) . '	' . number_format($date_discount, 2) . '	' . number_format($date_taxable, 2) . '	' . number_format($date_igst, 2) . '	' . number_format($date_cgst, 2) . '	' . number_format($date_sgst, 2) . '	' . number_format($date_debit, 2) . '	' . number_format($date_credit, 2) . '	' . number_format($date_dayclose, 2) . '
{{ $charge->crgdate }}	{{ $charge->roomno }}	{{ $charge->refno ?? '' }}	@if($charge->remarks) ({{ $charge->remarks .' - '. $charge->narration }}) @else {{ $charge->narration }} @endif	{{ number_format($charge->amount, 2) }}	{{ number_format($charge->discount, 2) }}	{{ number_format($taxable, 2) }}	{{ number_format($charge->IGST, 2) }}	{{ number_format($charge->CGST, 2) }}	{{ number_format($charge->SGST, 2) }}	{{ number_format($charge->debit, 2) }}	{{ number_format($charge->credit, 2) }}	{{ number_format($charge->debit - $charge->credit, 2) }}
Subtotal				{{ number_format($date_amount, 2) }}	{{ number_format($date_discount, 2) }}	{{ number_format($date_taxable, 2) }}	{{ number_format($date_igst, 2) }}	{{ number_format($date_cgst, 2) }}	{{ number_format($date_sgst, 2) }}	{{ number_format($date_debit, 2) }}	{{ number_format($date_credit, 2) }}	{{ number_format($date_dayclose, 2) }}
Grand Total				{{ number_format($grand_amount, 2) }}	{{ number_format($grand_discount, 2) }}	{{ number_format($grand_taxable, 2) }}	{{ number_format($grand_igst, 2) }}	{{ number_format($grand_cgst, 2) }}	{{ number_format($grand_sgst, 2) }}	{{ number_format($grand_debit, 2) }}	{{ number_format($grand_credit, 2) }}	{{ number_format($grand_dayclose, 2) }}