@extends('admin.layout.master')
@section('title', 'Frontdesk Report || ' . $report_title)

@section('custom_style')
    <link rel="stylesheet" href="{{ asset('assets/css/custom_print.css') }}">
@endsection

@section('content')
    @php
    use App\Http\Controllers\Frontdesk\CheckInController;
    @endphp
    {{-- <div class="row">
        <div class="col-12">
            <button class="btn btn-primary" onclick="callPrintThis()"><i class="fa fa-print"></i> Print</button>
        </div>
    </div> --}}


    <div class="card sina-card ">
        {{-- <div class="card-header">
            <h4>Daily Bill Book Summery</h4>
        </div> --}}
    @section('page_title', 'Reservation Report')
    @include('admin.layout.page_title_header_with_print')
    <div class="card-body" id="divTableDataHolder">
                {{-- print_preview --}}
                @include('frontdesk.report.report_header')
                {{-- checkin/booking information --}}
                <div class="row">
                    <div class="col-4">
                        @if ($booking_info->resv_code)
                            <h6><b>Resv. Id: </b>{{ $booking_info->resv_code }}</h6>
                        @endif
                        @if ($booking_info->checkin_code)
                            <h6><b>Check In Code: </b>{{ $booking_info->checkin_code }}</h6>
                            @if($booking_info->allotment_id != 0) <h6><b>Allotment Code: </b>{{ $booking_info->get_allotment_info->code }}</h6> @endif
                        @endif
                        <h6><b>Company Name: </b>
                            @if ($booking_info->get_company_name)
                                {{ $booking_info->get_company_name->name }}
                            @endif
                        </h6>
                        <h6><b>Number of Adult: </b>
                            @if ($booking_info->adult)
                                {{ $booking_info->adult }}
                            @endif
                        </h6>
                        <h6><b>Number of Child: </b>
                            @if ($booking_info->children)
                                {{ $booking_info->children }}
                            @endif
                        </h6>
                    </div>
                    <div class="col-4">
                        <h6><b>Agent Name: </b>
                            @if ($booking_info->get_agent_info)
                                {{ $booking_info->get_agent_info->name_eng }}
                            @endif
                        </h6>
                        <h6><b>Status: </b>
                            {{ booking_status($booking_info->booking_status) }}</h6>
                        <h6><b>BookedBy:
                            </b>{{ user_name($booking_info->posted_by) }}</h6>
                        @if (!$booking_info->checkin_code)
                            <h6><b>Confirmation: </b>
                                @if ($booking_info->confirm_date)
                                    Confirmed
                                @else
                                    Not Confirmed
                                @endif
                        @endif
                        </h6>
                        @if ($booking_info->confirm_date)
                            <h6><b>Confirmation Time:
                                </b>{{ $booking_info->confirm_date }}</h6>
                        @endif
                    </div>
                    <div class="col-4 text-right">
                        <h6><b>Resv. Date:</b>
                            @if ($booking_info->created_at)
                                {{ date('d-m-Y h:i:sa', strtotime($booking_info->created_at)) }}
                            @endif
                        </h6>
                        @if ($booking_info->check_in_date)
                            <h6><b>Check In Date:</b>
                                {{ date('d-m-Y', strtotime($booking_info->check_in_date)) }}
                            </h6>
                        @endif
                        @if ($booking_info->check_out_date)
                            <h6><b>Check Out Date:</b>
                                {{ date('d-m-Y', strtotime($booking_info->check_out_date)) }}
                            </h6>
                        @endif
                        @if($booking_info->booking_status == 4)
                            <h1 style="font-family: arial; font-weight: bold" class="text-danger">CANCELLED</h1>
                        @endif
                    </div>
                </div>

                {{-- Guest information --}}
                <div class="report-indi-div">
                    <h6 class="text-center font-weight-bold mt-3">Guest Information:</h6>
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th class="text-center">Sl</th>
                                <th class="text-center">Room/Bed Number</th>
                                <th class="text-center">Name</th>
                                <th class="text-center">Email</th>
                                <th class="text-center">Mobile No.</th>
                                <th class="text-center">Country</th>
                                <th class="text-center">Identity Type</th>
                                <th class="text-center text-nowrap">Identity Number</th>
                            </tr>
                        </thead>
                        <tbody class="text-center">
                            @forelse ($guest_info as $key=>$gi)
                                <tr>
                                    <td>{{ $key + 1 }}</td>
                                    <td>{{ $gi->get_room != null ? $gi->get_room->room_number : '-' }}
                                    </td>
                                    <td>{{ $gi->name }}</td>
                                    <td>{{ $gi->email }}</td>
                                    <td>{{ $gi->mobile_no }}</td>
                                    <td>{{ $gi->get_country->name }}</td>
                                    <td>{{ $gi->get_identity_type->name ?? '' }}</td>
                                    <td>{{ $gi->identity_no }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="7">No Guest Info Provided</td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
                {{-- Reservation Information --}}
                <div class="report-indi-div">
                    <h6 class="text-center font-weight-bold mt-3">
                        @if ($booking_info->checkin_code)
                            Check In Information
                        @else
                            Reservation Information:
                        @endif
                    </h6>
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th class="text-center">Sl</th>
                                <th class="text-center">Rooms/Bed</th>
                                <th class="text-center">Room Type</th>
                                {{-- @if ($booking_info->checkin_code) <th>Room/Bed Number</th> @endif --}}
                                <th>Room/Bed Number</th>
                                <th class="text-center">Qty</th>
                                <th class="text-center">From</th>
                                <th class="text-center text-nowrap" style="white-space: nowrap;">
                                    Total Night
                                </th>
                                <th class="text-center">To</th>
                                @if ($booking_info->checkin_code)
                                    <th>Status</th>
                                @endif
                                @if(!request()->without_bill)
                                    <th class="text-center">Rent</th>
                                    <th class="text-center" style="white-space: nowrap;">
                                        Amount
                                    </th>
                                    <th class="text-center">Tax</th>
                                    <th class="text-center" style="width: 120px;">Total
                                        Amount
                                    </th>
                                @endif
                            </tr>
                        </thead>
                        <tbody class="text-center">
                            @php
                                $total_amount = 0;
                                $total_vat = 0;
                                $sub_total = 0;
                                $total_room_bed = 0;
                                $total_night = 0;
                            @endphp

                            @forelse ($booking_room_details as $key=>$brd)
                                @php $amount = 0; @endphp

                                @if ($booking_info->checkin_code)
                                    <tr>
                                        <td>{{ $key + 1 }}</td>
                                        <td>
                                            @if ($booking_info->type == 1)
                                                Room
                                            @else
                                                Bed
                                            @endif
                                        </td>
                                        <td>{{ $brd->get_room_type->name }}</td>
                                        <td>{{ $brd->bed_id == 0? $brd->get_room_info->room_number: $brd->get_bed_info->room_number . ' [' . $brd->get_room_info->room_number . ']' }}
                                        </td>
                                        <td style="white-space: nowrap;"> 1
                                            @php $total_room_bed+=1 @endphp</td>
                                        <td>{{ date('d-m-Y', strtotime($brd->start_date_time)) }}
                                        </td>
                                        <td style="white-space: nowrap;">
                                            {{ $brd->qty }} @php $total_night+=$brd->qty @endphp</td>
                                        <td style="white-space: nowrap;">
                                            {{ date('d-m-Y', strtotime($brd->end_date_time . '+1 day')) }}
                                        </td>

                                        <td>{!! chk_room_status($brd->check_in_status) !!}</td>
                                        @if(!request()->without_bill)
                                        <td class="text-right">
                                            @if ($booking_info->tax_type == 2)
                                                {{ number_format($brd->rent, 2) }}
                                            @else
                                                {{ number_format($brd->rent + $brd->vat, 2) }}
                                            @endif
                                        </td>
                                        <td class="text-right">
                                            @if ($booking_info->tax_type == 2)
                                                {{ number_format($brd->rent * $brd->qty * 1, 2) }}
                                            @else
                                                {{ number_format(($brd->rent + $brd->vat) * $brd->qty * 1, 2) }}
                                            @endif
                                        </td>
                                        @php
                                            $amount = $booking_info->tax_type == 2 ? $brd->rent * $brd->qty * 1 : ($brd->rent + $brd->vat) * $brd->qty * 1;
                                        @endphp
                                        <td class="text-right">
                                            {{ number_format($brd->vat * $brd->qty, 2) }}
                                        </td>
                                        <td class="text-right">
                                            @if ($booking_info->tax_type == 2)
                                                {{ number_format($amount + $brd->vat * $brd->qty, 2) }}
                                                @php $sub_total+=($amount+($brd->vat*$brd->qty)) @endphp
                                            @else
                                                {{ number_format($amount - $brd->vat * $brd->qty, 2) }}
                                                @php $sub_total+=($amount-($brd->vat*$brd->qty)) @endphp
                                            @endif
                                        </td>
                                        @endif
                                    </tr>
                                    @php
                                        $total_amount += $amount;
                                        $total_vat += $brd->vat * $brd->qty;
                                    @endphp
                                @else
                                    <tr>
                                        <td>{{ $key + 1 }}</td>
                                        <td>
                                            @if ($booking_info->type == 1)
                                                Room
                                            @else
                                                Bed
                                            @endif
                                        </td>
                                        <td>{{ $brd->get_room_type->name ?? '-' }}</td>
                                        <td>{{ $brd->room->room_number ?? '-' }}</td>
                                        <td style="white-space: nowrap;">
                                            {{ $brd->qty }} @php $total_room_bed+=$brd->qty @endphp</td>
                                        <td>{{ date('d-m-Y', strtotime($brd->start_date)) }}
                                        </td>
                                        <td style="white-space: nowrap;">
                                            {{ number_format($brd->total_night, 2) }}
                                            @php $total_night+=$brd->total_night @endphp</td>
                                        <td style="white-space: nowrap;">
                                            {{ date('d-m-Y', strtotime($brd->end_date)) }}
                                        </td>
                                        @if(!request()->without_bill)
                                        <td class="text-right">
                                            {{ number_format($brd->rent, 2) }}</td>

                                        <td class="text-right">
                                            {{ number_format($brd->rent * $brd->qty * $brd->total_night, 2) }}
                                        </td>
                                        @php $amount = $brd->rent*$brd->qty*$brd->total_night @endphp
                                        @php $vat = CheckInController::calculate_tax($amount, $booking_info->tax_percent, $booking_info->tax_type) @endphp
                                        <td class="text-right">
                                            {{ number_format($vat, 2) }}</td>
                                        <td class="text-right">
                                            @if ($booking_info->tax_type == 2)
                                                {{ number_format($amount + $vat, 2) }}
                                                @php $sub_total+=($amount+$vat) @endphp
                                            @else
                                                {{ number_format($amount - $vat, 2) }}
                                                @php $sub_total+=($amount-$vat) @endphp
                                            @endif
                                        </td>
                                        @endif
                                    </tr>
                                    @if(!request()->without_bill)
                                    @php
                                        $total_amount += $amount;
                                        $total_vat += $vat;
                                    @endphp
                                    @endif
                                @endif

                            @empty
                                <tr>
                                    <td colspan="11">
                                        <h6>No Room Record Found</h6>
                                    </td>
                                </tr>

                            @endforelse

                            <tr>
                                {{-- @if ($booking_info->checkin_code) <td></td> @endif --}}
                                <td colspan="3"></td>
                                <td class="text-nowrap"><b>Total Room/Bed: </b></td>
                                <td class="text-nowrap">{{ $total_room_bed }}</td>
                                <td class="text-nowrap"><b>Total Night: </b></td>
                                <td class="text-nowrap">{{ $total_night }}</td>
                                @if(request()->without_bill)
                                <td></td>
                                @endif
                                @if(!request()->without_bill)
                                <td class="text-right text-nowrap"
                                    colspan="{{ $booking_info->checkin_code ? 3 : 2 }}">
                                    <b>Total Amount<span style="font-weight: normal;">
                                            @if ($booking_info->tax_type == 1)
                                                (Including)
                                            @endif
                                        </span></b>
                                </td>
                                <td class="text-right">
                                    <b>{{ number_format($total_amount, 2) }}
                                </td>
                                <td class="text-right">
                                    <b></b>{{ number_format($total_vat, 2) }}
                                </td>
                                <td class="text-right">
                                    <b></b>{{ number_format($sub_total, 2) }}
                                </td>
                                @endif
                            </tr>
                            @if(!request()->without_bill)
                            <tr>
                                @if ($booking_info->checkin_code)
                                    <td></td>
                                @endif
                                <td class="text-right" colspan="11"><b>Sub Total</b>
                                </td>
                                <td class="text-right"><b>
                                        @if ($booking_info->tax_type == 2)
                                            {{ number_format($total_amount, 2) }}
                                            @else{{ number_format($sub_total, 2) }}
                                        @endif
                                    </b></td>
                            </tr>
                            <tr>
                                @if ($booking_info->checkin_code)
                                    <td></td>
                                @endif
                                <td class="text-right" colspan="11"><b>Tax</b></td>
                                <td class="text-right">
                                    <b>{{ number_format($total_vat, 2) }}</b>
                                </td>
                            </tr>
                            <tr>
                                @if ($booking_info->checkin_code)
                                    <td></td>
                                @endif
                                <td class="text-right" colspan="11"><b>Grand Total</b>
                                </td>
                                <td class="text-right"><b>
                                        @if ($booking_info->tax_type == 2)
                                            {{ number_format($total_amount + $total_vat, 2) }}
                                            @else{{ number_format($sub_total + $total_vat, 2) }}
                                        @endif
                                    </b></td>
                            </tr>
                            @endif
                        </tbody>
                    </table>
                </div>

                {{-- Facility --}}
                <div class="report-indi-div" style="">
                    <h6 class="text-center font-weight-bold mt-3">Facility</h6>
                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th class="text-center">Sl</th>
                                <th class="text-center" style="width: 120px;">Date</th>
                                <th class="text-center">Facility Name</th>
                                <th class="text-center">Qty</th>
                                @if(!request()->without_bill)
                                <th class="text-center">Amount</th>
                                <th class="text-center">Free/Cost</th>
                                <th class="text-center">Total Amount</th>
                                @endif
                            </tr>
                        </thead>
                        <tbody>
                            @php $facility_amount=0; @endphp
                            @forelse ($facility as $key=>$f)
                                <tr>
                                    <td class="text-center">{{ $key + 1 }}</td>
                                    <td class="text-center" nowrap>
                                        {{ date('d-m-Y h:i:sa', strtotime($f->created_at)) }}
                                    </td>
                                    <td class="text-center">
                                        @if ($f->get_facility_name)
                                            {{ $f->get_facility_name->name_eng }}
                                        @endif
                                    </td>
                                    <td class="text-center">{{ $f->qty }}</td>
                                    @if(!request()->without_bill)
                                    <td class="text-center">{{ $f->amount }}</td>
                                    <td class="text-center">
                                        @if ($f->facility_status == 2)
                                            Free
                                        @endif
                                    </td>
                                    <td class="text-right">
                                        @if ($f->facility_status == 2)
                                            0
                                        @else
                                            {{ $f->qty * $f->amount }} @php $facility_amount+=$f->qty*$f->amount @endphp
                                        @endif
                                    </td>
                                    @endif
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="7">
                                        <h6>No Facility Found</h6>
                                    </td>
                                </tr>
                            @endforelse
                            @if(!request()->without_bill)
                            <tr>
                                <td class="text-right" colspan="6"><b>Total Facility
                                        Amount</b></td>
                                <td class="text-right"><b>{{ $facility_amount }}</b>
                                </td>
                            </tr>
                            @endif
                        </tbody>
                    </table>
                </div>

                {{-- For advance --}}
                @if(!request()->without_bill)
                @if (!$booking_info->checkin_code)

                    <div class="report-indi-div">
                        <table class="table table-bordered">
                            <tbody>
                                @php $resv_com_dis = 0; @endphp
                                <tr>
                                    <td class="text-right" width="90%"><b>Total Bill</b>
                                    </td>
                                    <td class="text-right"><b>
                                            @if ($booking_info->tax_type == 2)
                                                {{ number_format($total_amount + $total_vat + $facility_amount, 2) }}
                                                @else{{ number_format($sub_total + $total_vat + $facility_amount, 2) }}
                                            @endif
                                        </b></td>
                                    @php $resv_total_bill = $booking_info->tax_type == 2 ? $total_amount+$total_vat+$facility_amount : $sub_total+$total_vat+$facility_amount @endphp
                                </tr>
                                @if(!request()->without_comission)
                                    <tr>
                                        <td class="text-right" width="90%">
                                            <b>Discount/Commission</b>
                                        </td>
                                        <td class="text-right">
                                            <b>{{ number_format($booking_info->discount, 2) }}</b>
                                        </td>
                                        @php
                                            $resv_com_dis = $booking_info->discount;
                                        @endphp
                                    </tr>
                                @endif
                                <tr>
                                    <td class="text-right" width="90%"><b>Advance</b>
                                    </td>
                                    @php
                                        // $advance_cal = $advance['adv_total'];
                                        $temp_adv_calculation = App\Models\Frontdesk\FdInvoiceDetails::where('reservation_id', $booking_info->id)->where('type',1)->where('voucher_type',1)->sum('amount');
                                        $advance_cal = $temp_adv_calculation;
                                    @endphp
                                    @if(request()->without_comission)
                                        @php
                                            // $advance_cal = $advance['adv_total']+$booking_info->discount;
                                            $advance_cal = $temp_adv_calculation+$booking_info->discount;
                                        @endphp
                                    @endif
                                    <td class="text-right">
                                        <b>{{ number_format($advance_cal, 2) }}</b>
                                    </td>
                                </tr>
                                <tr>
                                    <td class="text-right" width="90%"><b>Total Due</b>
                                    </td>
                                    <td class="text-right">
                                        <b>{{ number_format(($resv_total_bill - $advance_cal - $resv_com_dis), 2) }}</b>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                @endif
                @endif

                @if ($booking_info->checkin_code)
                    {{-- when reservation charges section && receipt will not show --}}
                    {{-- charges --}}
                    <div class="report-indi-div">
                        <h6 class="text-center font-weight-bold mt-3">Charges</h6>
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th class="text-center">Sl</th>
                                    <th class="text-center" style="width: 120px;">Date
                                    </th>
                                    <th class="text-center">Voucher</th>
                                    <th class="text-center">Description</th>
                                    @if(!request()->without_bill)
                                    <th class="text-center" style="width: 120px;">Amount
                                    </th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>
                                @php $charges_amount = 0; @endphp
                                @forelse ($charges as $key=>$charge)
                                    <tr>
                                        <td class="text-center">{{ $key + 1 }}</td>
                                        <td class="text-center">
                                            {{ date('d-m-Y', strtotime($charge->created_at)) }}
                                        </td>
                                        <td class="text-center">
                                            {{ $charge->fd_invoice->invoice_no }}</td>
                                        <td class="text-center">
                                            {{ $charge->fd_invoice->note }}</td>
                                        @if(!request()->without_bill)
                                        <td class="text-right">
                                            {{ number_format($charge->amount, 2) }}</td>
                                            @endif
                                        @php $charges_amount+=$charge->amount; @endphp
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="5">
                                            <p>No Charges Yet</p>
                                        </td>
                                    </tr>
                                @endforelse
                                @if(!request()->without_bill)
                                <tr>
                                    <td class="text-right" colspan="4"><b>Total Charges
                                            Amount</b></td>
                                    <td class="text-right">
                                        <b>{{ number_format($charges_amount, 2) }}</b>
                                    </td>
                                </tr>
                                @endif
                            </tbody>
                        </table>
                    </div>

                    {{-- receipt --}}
                    @if(!request()->without_bill)

                    <div class="report-indi-div">
                        @if(!request()->without_comission)
                        <h6 class="text-center font-weight-bold mt-3">Receipt</h6>
                        @endif
                        <table class="table table-bordered">
                            @if(!request()->without_comission)
                            <thead>
                                <tr>
                                    <th class="text-center">Sl</th>
                                    <th class="text-center">Voucher</th>
                                    <th class="text-center">Description</th>
                                    <th class="text-center">Received Mode</th>
                                    <th class="text-center" style="width: 150px;">
                                        Received Date</th>
                                    <th class="text-center" style="width: 120px;">Amount
                                    </th>
                                </tr>
                            </thead>
                            @endif
                            <tbody>
                                @php $total_receive=0; @endphp
                                @if(!request()->without_comission)
                                @forelse ($receipt as $key=>$r)
                                    <tr>
                                        <td>{{ $key + 1 }}</td>
                                        <td class="text-center">
                                            {{ $r->fd_invoice->invoice_no }}</td>
                                        <td class="text-center">{{ $r->note }}
                                        </td>
                                        <td class="text-center">
                                            {{ $r->cash_bank->name_eng }}</td>
                                        <td class="text-center">
                                            {{ date('d-m-Y', strtotime($r->date)) }}</td>
                                        <td class="text-right">
                                            {{ number_format($r->amount, 2) }}</td>
                                        @php $total_receive+=$r->amount @endphp
                                    </tr>

                                @empty
                                    <tr>
                                        <td colspan="6">
                                            <h6>No Receive Found</h6>
                                        </td>
                                    </tr>
                                @endforelse
                                @endif
                                <tr>
                                    <td colspan="5" class="text-right"><b>Total
                                            Bill</b></td>
                                    <td class="text-right">
                                        <b>{{ number_format($accounts_info['total_bill'], 2) }}</b>
                                    </td>
                                </tr>

                                @if(!request()->without_comission)
                                <tr>
                                    <td colspan="5" class="text-right"><b>Total
                                            Discount</b></td>
                                    <td class="text-right">
                                        <b>{{ number_format($accounts_info['total_discount'], 2) }}</b>
                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="5" class="text-right"><b>Total
                                            Commission</b></td>
                                    <td class="text-right">
                                        <b>{{ number_format($accounts_info['total_commission'], 2) }}</b>
                                    </td>
                                </tr>
                                @endif
                                <tr>
                                    <td colspan="5" class="text-right"><b>Total
                                            Paid</b></td>
                                    <td class="text-right">
                                        @if(!request()->without_comission)
                                            <b>{{ number_format($total_receive, 2) }}</b>
                                        @else
                                            <b>{{ number_format(($receipt->sum('amount')+$accounts_info['total_commission']+$accounts_info['total_discount']), 2) }}</b>
                                        @endif

                                    </td>
                                </tr>
                                <tr>
                                    <td colspan="5" class="text-right"><b>Advance Adjust(-)</b></td>
                                    <td class="text-right">
                                        <b>{{ number_format($accounts_info['total_advance_deduct'], 2) }}</b>
                                    </td>
                                </tr>
                                @if ($accounts_info['total_refund'] > 0)
                                    <tr>
                                        <td colspan="5" class="text-right"><b>Total
                                                Refund</b></td>
                                        <td class="text-right">
                                            <b>{{ number_format($accounts_info['total_refund'], 2) }}</b>
                                        </td>
                                    </tr>
                                @endif
                                <tr>
                                    <td colspan="5" class="text-right"><b>Due</b></td>
                                    <td class="text-right">
                                        <b>{{ number_format($accounts_info['total_due'] + $accounts_info['total_refund'], 2) }}</b>
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                    @endif
                @endif
                                <div style="clear:both!important;"></div>
                <div style="page-break-after:always"></div>
                <div style="clear:both!important;"></div>
    </div>
    @include('frontdesk.report.report_footer')
    <script type="text/javascript">
        function callPrintThis() {
            $('#printThis').printThis({
                printDelay: 1000,
                // loadCSS: true,
            });
        }
    </script>
@endsection