@extends('layouts.bill_pdf')

@section('content')
    <style>
        p {
            margin: 0px
        }

        .text-right {
            text-align: right;
        }
    </style>
    {{-- <center>
            <p style="text-transform:uppercase">{{ $billing->branch->name }}</p>
        </center> --}}

    @php
        $arr = [];
    @endphp

    {{-- @foreach ($billing->invoices as $inv)
        @php
            $inv = $inv->invoice;
        @endphp

        @if ($inv->institution)
            @php
                $arr[] = $inv->institution->name;
            @endphp
        @endif
    @endforeach

    @if (count($arr) > 0)
        @php
            $arr = array_unique($arr);
        @endphp

        @foreach ($arr as $item)
            <center>
                <p style="text-transform:uppercase">{{ $item }}</p>
            </center>
        @endforeach
    @endif --}}

    <div style="text-align: center;">
        @if ($billing->billing_month)
            <p style="text-align: center;">Billing for Month of {{ date('F Y', strtotime($billing->billing_month)) }}</p>
        @else
            <p style="text-align: center;"></p>
        @endif


        @php $institute = ''; @endphp
        @foreach ($billing->inv as $inst)
            @if ($inst->institution == $billing->inv[0]->institution)
                @php $institute = $inst->institution ? $inst->institution->name : ''; @endphp
            @else
                @php $institute = ''; @endphp
            @endif
        @endforeach

        <p style="text-align: center; text-transform: uppercase;">{{ $institute }}</p>
    </div>

    <br>
    <table width="100%" class="table table-bordered">
        <thead>
            @if ($billing->branch_id == 3)
                <tr>
                    <th>PATIENT ID</th>
                    <th>PATIENT NAME</th>
                    <th>MOTHERS NAME</th>
                    <th>DATE OF BIRTH</th>
                    <th>BARCODE</th>
                    <th>ACCESSION NO.</th>
                    <th>DATE OF SAMPLE RECEPTION</th>
                    <th>COST</th>
                    <th>OTHER/REMARK/S</th>
                    <th>TOTAL COST</th>
                    <th>AMOUNT PAID</th>
                    <th>DATE PREPARED/ GENERATED</th>
                </tr>
            @else
                <tr>
                    <th>REQUEST NO.</th>
                    <th>SURNAME</th>
                    <th>FIRST NAME</th>
                    <th>MOTHER'S NAME</th>
                    <th>DATE OF BIRTH</th>
                    <th>REFERENCE NO.</th>
                    <th>DATE OF SAMPLE RECEPTION</th>
                    <th>TESTS</th>
                    <th>COST</th>
                    <th>OTHERS/REMARKS</th>
                    <th class="text-right">TOTAL COST</th>
                </tr>
            @endif
        </thead>
        <tbody>

            @php
                $overall_cost = 0;
            @endphp


            @if ($billing->branch_id == 3)
                @foreach ($billing->invoices as $inv)
                    @php
                        $inv = $inv->invoice;
                        $total_cost = 0;
                        $overall_cost += $inv->total;
                    @endphp
                    <tr id="{{ $inv->invoice_no }}" class="bill_row">
                        <td>{{ $inv->patient->code }}</td>
                        <td>{{ $inv->patient->name . ' ' . $inv->patient->last_name }}</td>
                        <td>{{ $inv->patient->mother_name }}</td>
                        <td>{{ date('F d, Y', strtotime($inv->patient->dob)) }}</td>
                        <td>{{ $inv->invoice_no }}</td>
                        <td>
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                @if ($gt->sample)
                                    <p>{{ $gt->sample->barcode }}</p>
                                @else
                                    No Sample
                                @endif
                            @endforeach
                        </td>
                        <td>
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                @if ($gt->sample)
                                    @if ($gt->sample->lab_receive_date)
                                        <p>{{ date('F d, Y', strtotime($gt->sample->lab_receive_date)) }}</p>
                                    @else
                                        <p>No Lab Received Date</p>
                                    @endif
                                @else
                                    No Sample
                                @endif
                            @endforeach
                        </td>
                        <td>
                            @php
                                $package_arr = [];
                            @endphp
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                {{-- IF PACKAGE --}}
                                @if ($gt->package)
                                    @php
                                        if (!in_array($gt->package_id, $package_arr)) {
                                            $package_arr[] = $gt->package_id;
                                            $total_cost += $gt->package->price;
                                        }
                                    @endphp
                                    <p>({{ $gt->package->shortcut }}) {{ number_format($gt->package->price, 2) }}</p>
                                @else
                                    @php
                                        $total_cost += $gt->price;
                                    @endphp
                                    <p>{{ number_format($gt->price, 2) }}</p>
                                @endif

                            @endforeach

                            {{-- MAILING FEE AND DUPLICATE FEE --}}
                            @php
                                $total_cost += $inv->mailing_fee;
                                $total_cost += $inv->duplicate_fee;
                            @endphp
                            {{ $inv->mailing_fee ? 'Mailing Fee: ' . number_format($inv->mailing_fee, 2) : '' }}
                            {!! $inv->duplicate_fee ? '<p>Duplicate Fee: ' . number_format($inv->duplicate_fee, 2) . '</p>' : '' !!}
                        </td>
                        <td style="text-align: center">{{ $inv->bill_remarks }}</td>
                        <td>
                            <p class="total_cost price">{{ number_format($total_cost, 2) }}</p>
                        </td>
                        <td></td>
                        <td>
                            <p>{{ date('F d, Y', strtotime($billing->created_at)) }}</p>
                        </td>
                    </tr>
                @endforeach
            @else
                @foreach ($billing->invoices as $inv)
                    @php
                        $inv = $inv->invoice;
                        $total_cost = 0;
                    @endphp
                    <tr>
                        <td>{{ $inv->invoice_no }}</td>
                        <td>{{ $inv->patient->last_name }}</td>
                        <td>{{ $inv->patient->name }}</td>
                        <td>{{ $inv->patient->mother_name }}</td>
                        <td>{{ date('F d, Y', strtotime($inv->patient->dob)) }}</td>
                        <td>
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                @if ($gt->sample)
                                    <p>{{ $gt->sample->barcode }}</p>
                                @else
                                    No Sample
                                @endif
                            @endforeach
                        </td>
                        <td>
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                <p>{{ $gt->collection_date ? date('F d, Y', strtotime($gt->collection_date)) : '' }}</p>
                            @endforeach
                        </td>
                        <td>
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                <p>{{ $gt->test->name }}</p>

                                @if ($loop->last)
                                    {{ $inv->mailing_fee ? 'Mailing Fee:' : '' }}
                                    {!! $inv->duplicate_fee ? '<br>Duplicate Fee:' : '' !!}
                                @endif
                            @endforeach
                        </td>
                        <td>
                            @php
                                $package_arr = [];
                            @endphp
                            @foreach ($inv->all_tests->where('cancelled', '!=', 1) as $gt)
                                {{-- IF PACKAGE --}}
                                @if ($gt->package)
                                    @php
                                        if (!in_array($gt->package_id, $package_arr)) {
                                            $package_arr[] = $gt->package_id;
                                            $total_cost += $gt->package->price;
                                        }
                                    @endphp
                                    <p>({{ $gt->package->shortcut }}) {{ number_format($gt->package->price, 2) }}</p>
                                @else
                                    @php
                                        $total_cost += $gt->price;
                                    @endphp
                                    <p>{{ number_format($gt->price, 2) }}</p>
                                @endif

                                @if ($loop->last)
                                    @php
                                        $total_cost += $inv->mailing_fee;
                                        $total_cost += $inv->duplicate_fee;
                                    @endphp
                                    {{ $inv->mailing_fee ? number_format($inv->mailing_fee, 2) : '' }}
                                    {!! $inv->duplicate_fee ? '<p>' . number_format($inv->duplicate_fee, 2) . '</p>' : '' !!}
                                @endif
                            @endforeach
                        </td>
                        <td style="text-align: center">{{ $inv->bill_remarks }}</td>
                        <td class="text-right">{{ number_format($total_cost, 2) }}</td>
                    </tr>

                    @php
                        $overall_cost += $total_cost;
                    @endphp
                @endforeach
            @endif


            <tr>
                @if ($billing->branch_id == 3)
                    <td colspan="7" style="text-align: center;">Nothing Follows</td>
                @else
                    <td colspan="8" style="text-align: center;">Nothing Follows</td>
                @endif

                <td>TOTAL</td>
                <td style="text-align: center">Php</td>
                <td class="text-right">{{ number_format($overall_cost, 2) }}</td>
            </tr>
        </tbody>
    </table>

    <table style="width:50%">
        <tr>
            <td>Prepared By</td>
            <td>Reviewed By</td>
            <td>Approved By</td>
        </tr>

        <tr>
            <td>
                @if ($billing->generated_by_user)
                    <img src="{{ asset('uploads/signature/' . $billing->generated_by_user->signature) }}" alt="img" height="100" />
                @endif
            </td>
            <td>
                @if ($billing->reviewed_by_user)
                    <img src="{{ asset('uploads/signature/' . $billing->reviewed_by_user->signature) }}" alt="img" height="100" />
                @endif
            </td>
            <td>
                @if ($billing->approved_by_user)
                    <img src="{{ asset('uploads/signature/' . $billing->approved_by_user->signature) }}" alt="img" height="100" />
                @endif
            </td>
        </tr>

        <tr>
            <td>___________________</td>
            <td>___________________</td>
            <td>___________________</td>
        </tr>

        <tr>
            <td>{{ $billing->generated_by_user ? $billing->generated_by_user->name . ' ' . $billing->generated_by_user->last_name : '' }}</td>
            <td>{{ $billing->reviewed_by_user ? $billing->reviewed_by_user->name . ' ' . $billing->reviewed_by_user->last_name : '' }}</td>
            <td>{{ $billing->approved_by_user ? $billing->approved_by_user->name . ' ' . $billing->approved_by_user->last_name : '' }}</td>
        </tr>
    </table>
@endsection