@extends('admin.layout.master')
@section('custom_style')

    <style>
        .fd_common_header td{
            padding: 1px 5px!important;
        }
        td,th{
            color: #000;
            padding: 0.25rem 0.35rem!important;
        }
    </style>

@endsection
@section('content')
<div id="divTableDataHolder">
    @include('frontdesk.bill_print.common_header')
    <table class="table table-bordered border-dark">
        <tbody>
            <tr>
                <th colspan="2" class="text-end">Bill No</th>
                <th colspan="2" class="text-center">{{ $booking_info->checkin_code }}</th>
                <th colspan="2" class="text-start">رقم الفاتورة</th>
            </tr>
            <tr>
                <th class="text-end">NO.OF.ROOMS</th>
                <td class="text-center">{{ $booking_info->get_checkin_info->count() }}</td>
                <th>عدد الغرف</th>
                <th class="text-end">Res No</th>
                <td class="text-center">{{ $booking_info->checkin_code }}</td>
                <th>رقم الحجز</th>
            </tr>
            <tr>
                <th class="text-end">Arrival</th>
                <td class="text-center">{{ date('d-m-Y H:i:s', strtotime($booking_info->check_in_date)) }}</td>
                <th>الوصول</th>
                <th class="text-end"></th>
                <td class="text-center"></td>
                <th></th>
            </tr>
            <tr>
                <th class="text-end">Departure</th>
                <td class="text-center">{{ $booking_info->check_out_date ? date('d-m-Y H:i:s', strtotime($booking_info->check_out_date)) : '' }}</td>
                <th>المغادرة</th>
                <th class="text-end">Customer</th>
                <td class="text-center">{{ $booking_info->get_agent_info->name_eng }}</td>
                <th>العميل</th>
            </tr>
        </tbody>
    </table>

    @php
        $sl = 0;
        $account_amount = 0;
    @endphp
    @if($from_accounts->count() > 0)
        <table class="table table-bordered border-dark">
            <thead>
                <tr>
                    <th>Sl</th>
                    <th>Description</th>
                    <th>Ref No.</th>
                    <th>Date</th>
                    <th>Amount</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($from_accounts as $f)
                    @php
                        $description = '';
                        $amount = '';
                        foreach ($f->journalsGlobal as $g){
                            $description .= ($g->ledger->name ?? "").'<br>';
                            $amount .= round($g->amount,2).'<br>';
                            $account_amount += $g->amount;
                        }
                    @endphp
                    <tr>
                        {{-- <td>{{ $f->voucher_no }} {{ $f->journalsGlobal->count() }}</td> --}}
                        <td>{{ ++$sl }}</td>
                        <td>{!! $description !!}</td>
                        <td class="text-center">{{ $f->voucher_no }}</td>
                        <td class="text-center" nowrap>{{ date('d-m-Y', strtotime($f->date)) }}</td>
                        <td class="text-end">{!! $amount !!}</td>
                    </tr>
                @endforeach
                <tr>
                    <td colspan="4" class="text-end fw-bold">Total</td>
                    <td class="fw-bold text-end">{{ round($account_amount,2) }}</td>
                </tr>
            </tbody>
        </table>
    @endif

    <table class="table table-bordered border-dark">
        @php
            $rent = $booking_info->get_checkin_info->sum(function($qry){
                return $qry->rent * $qry->qty;
            });
            $sl = 0;
            $debit = $credit = 0;
        @endphp
        <tbody>
            <tr>
                <td class="text-center">Sl</td>
                <td class="text-center">Description</td>
                <td class="text-center">Credit</td>
                <td class="text-center">Debit</td>
                {{-- <td>Currency</td> --}}
            </tr>
            <tr>
                @php $debit += $rent; @endphp
                <td>{{ ++$sl }}</td>
                <td>Bill</td>
                <td></td>
                <td class="text-center">{{ number_format($rent,2) }}</td>
                {{-- <td></td> --}}
            </tr>
            @foreach ($booking_info->get_vat_tax_tran as $v)
                @php
                    $v_amount = calculate_tax($rent,$v->tax_percent,2,$booking_info->tax_percent); // excluding
                    $debit += $v_amount
                @endphp
                <tr>
                    <td>{{ ++$sl }}</td>
                    <td>{{ $v->getVatInfo->name }}</td>
                    <td></td>
                    <td class="text-center">{{ number_format($v_amount,2) }}</td>
                </tr>
                {{-- <td></td> --}}
            @endforeach
            <tr>
                @php
                    $discount = $accounts_info['total_discount']+$accounts_info['total_commission'];
                    $credit += $discount;
                @endphp
                <td>{{ ++$sl }}</td>
                <td>Discount/Commission</td>
                <td class="text-center">{{ number_format($discount, 2) }}</td>
                <td></td>
                {{-- <td></td> --}}
            </tr>
            <tr>
                @php
                    $adjust = $accounts_info['total_advance_deduct'];
                    $credit += $adjust;
                @endphp
                <td>{{ ++$sl }}</td>
                <td>Advance Adjust</td>
                <td class="text-center">{{ number_format($adjust, 2) }}</td>
                <td></td>
                {{-- <td></td> --}}
            </tr>
            <tr>
                @php
                    $receive = $receipt->sum('amount');
                    $credit += $receive;
                @endphp
                <td>{{ ++$sl }}</td>
                <td>Receive</td>
                <td class="text-center">{{ number_format($receive, 2) }}</td>
                <td></td>
                {{-- <td></td> --}}
            </tr>
            <tr>
                @php
                    $refund = $accounts_info['total_refund'];
                    $debit += $refund;
                @endphp
                <td>{{ ++$sl }}</td>
                <td>Refund</td>
                <td></td>
                <td class="text-center">{{ number_format($refund, 2) }}</td>
                {{-- <td></td> --}}
            </tr>
            <tr>
                <td>{{ ++$sl }}</td>
                <td>Total</td>
                <td class="text-center">{{ number_format($credit, 2) }}</td>
                <td class="text-center">{{ number_format($debit, 2) }}</td>
                {{-- <td></td> --}}
            </tr>
            <tr>
                <td>{{ ++$sl }}</td>
                <td>Balance</td>
                <td colspan="2" class="text-center">{{ number_format($debit-$credit,2) }}</td>
                {{-- <td></td> --}}
            </tr>
        </tbody>
    </table>

</div>
    @include('frontdesk.report.frontdesk_common_report_setup', ['noDivTableDataHolder'=>1, 'noExcel'=>1])
@endsection