@extends('operations.layout.mainlayout')

@section('content')
    <style>
        .select2-container--default .select2-selection--multiple .select2-selection__choice__display{
            color:black;
        }
    </style>
    <div class="content-wrapper">
        <div class="content-header">
            <div class="container-fluid card">
                <div class="row mb-2">
                    <div class="col-sm-6 card-body">
                        <h1 class="m-0 text-dark" style="color: var(--blazma-text)!important;">Daily Performance Report</h1>
                    </div>
                    <div class="col-sm-6">
                    </div>
                </div>
            </div>
        </div>
        <!-- /.content-header -->

        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">

                        <!-- /.card -->
                        <div class="col-12 col-sm-12 col-md-12">
                            <br />
                            <div class="card bg-light">
                                <div class="card-header text-muted border-bottom-0">
                                </div>
                                <form method="get" action="" style="width:100%;">
                                    <div class="card-body pt-0">
                                        <div class="row">
                                            <div class="col-12">

                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Payment Date from</b></span>
                                                        <input id="payment-date-from" autocomplete="off" class="form-control" type="date" name="payment_date_from" value="@if(!empty($payment_date_from)){{$payment_date_from}}@endif" >
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Payment Date to</b></span>
                                                        <input id="payment-date-to" autocomplete="off" class="form-control"  type="date" name="payment_date_to" value="@if(!empty($payment_date_to)){{$payment_date_to}}@endif" >
                                                    </div>
                                                    <div class="col-md-3" style="">
                                                        <span class="text-muted text-sm"><b>Packages / Tests</b></span>
                                                        <select class="form-control col-md-2 rhospital_id" multiple="multiple" name="package_id[]" id="service-packages" style="width: auto">
                                                            @foreach($packages as $package)
                                                                <option value="{{$package->ID}}" @if(!empty($package_id)) @if(in_array($package->ID,$package_id)) selected @endif @endif>{{$package->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Reservation Type</b></span>
                                                        <select class="form-control rhospital_id" name="type" id="type">
                                                            <option value="0" @if(empty($type)) selected @endif>All</option>
                                                            <option value="1" @if(!empty($type) && $type == 1) selected @endif>Normal Booking</option>
                                                            <option value="2" @if(!empty($type) && $type == 2) selected @endif>Homevisit</option>
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col-md-3" >
                                                        <span class="text-muted text-sm"><b>Registration Branch</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" id="service-hospitals" name="hospital_id[]" >
                                                            <option value="">Select Registration Branch </option>
                                                            @foreach($registration_branches as $registration_branche)
                                                                <option value="{{$registration_branche->ID}}" @if(!empty($hospital_id)) @if(in_array($registration_branche->ID,$hospital_id)) selected @endif @endif>{{$registration_branche->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>

                                                    <div class="col-md-3" >
                                                        <span class="text-muted text-sm"><b>Users</b></span>
                                                        <select class="form-control rhospital_id" multiple id="service-user-id" name="user_id[]">
                                                            <option value="" disabled>Select Users </option>
                                                            @foreach($users as $user)
                                                                <option value="{{$user->ID}}" @if(!empty($user_id)) @if(in_array($user->ID,$user_id)) selected @endif @endif>{{$user->USERNAME}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Payment Method</b></span>
                                                        <select class="form-control rhospital_id" name="payment_id[]" multiple="multiple" id="service-payments">
                                                            <option value="1" @if(!empty($payment_id)) @if(in_array(1,$payment_id)) selected @endif @endif>COD</option>
                                                            <option value="3" @if(!empty($payment_id)) @if(in_array(3,$payment_id)) selected @endif @endif>Credits</option>
                                                            <option value="2" @if(!empty($payment_id)) @if(in_array(2,$payment_id)) selected @endif @endif>Online</option>
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="card-footer">
                                        <div class="text-right">
                                            <button type="submit" name="submit" value="submit" class="btn btn-sm btn-info">
                                                <i class="fas fa-search"></i> Submit
                                            </button>
                                            <button  type="submit" name="export" value="export" class="btn btn-sm btn-success">
                                                <i class="fas fa-download"></i> Export Excel
                                            </button>
                                        </div>
                                    </div>

                                </form>
                            </div>
                        </div>
                        <div class="card">
                            <div class="card-body">
                                <table id="daily-performance-report-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>Paid By</th>
                                        <th>Main Branch</th>
                                        <th>Access Branch</th>
                                        <th>Trans</th>
                                        <th>Total Patients # </th>
                                        <th>Total Packages #</th>
                                        <th>Total Individual Tests #</th>
                                        <th>Total Services #</th>
                                        <th>Total Packages Income</th>
                                        <th>Total Individual Tests Incomes</th>
                                        <th>Total Service Income</th>
                                        @if(!empty($package_id))
                                            @foreach ($package_id as $packageId)
                                                <th>{{isset($selected_package[$packageId]) ? $selected_package[$packageId] : "Total Package $packageId" }}</th>
                                            @endforeach
                                        @endif
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @php
                                        $total_service = 0;
                                        $total_patients = 0;
                                        $total_amount = 0;
                                        $total_packages = 0;
                                        $total_individual_test = 0;
                                        $package_income = 0;
                                        $test_income = 0;
                                        $new_columns = [];
                                    @endphp
                                    @foreach($orders as $order)
                                        @php
                                            $total_service += ($order->total_packages + $order->total_individual_test);
                                            $total_amount += ($order->total_package_income + $order->total_test_income);
                                            $total_patients += $order->TOTAL_PATIENT;
                                            $total_packages += $order->total_packages;
                                            $total_individual_test += $order->total_individual_test;
                                            $package_income +=  $order->total_package_income;
                                            $test_income += $order->total_test_income;
                                        @endphp
                                        <tr>
                                            <td>{{$order->USERNAME ?? null}}</td>
                                            <td>{{$order->main_branch ?? 0}}</td>
                                            <td>{{$order->hospital_name ?? 0}}</td>
                                            <td>{{$order->hospital_name == $order->main_branch ? 0 : 1}}</td>
                                            <td>{{$order->TOTAL_PATIENT ?? 0}}</td>
                                            <td>{{$order->total_packages ?? 0}}</td>
                                            <td>{{$order->total_individual_test ?? 0}}</td>
                                            <td>{{$order->total_packages + $order->total_individual_test}}</td>
                                            <td>{{$order->total_package_income ?? 0}}</td>
                                            <td>{{$order->total_test_income ?? 0}}</td>
                                            <td>{{$order->total_package_income + $order->total_test_income}}</td>
                                            @if(!empty($package_id))
                                                @foreach ($package_id as $packageId)
                                                    @php
                                                        $new_columns[$packageId] = (isset($new_columns[$packageId]) ? $new_columns[$packageId] : 0) + $order->{'total_package_' . $packageId};
                                                    @endphp
                                                    <td>{{ $order->{'total_package_' . $packageId} }}</td>
                                                @endforeach
                                            @endif
                                        </tr>
                                    @endforeach
                                    </tbody>
                                    <tfoot>
                                    <th class="text-left"></th>
                                    <th class="text-left"></th>
                                    <th class="text-left"></th>
                                    <th class="text-left"></th>
                                    <th class="text-left">Total Patients : {{$total_patients}}</th>
                                    <th class="text-left">Total Packages : {{$total_packages}}</th>
                                    <th class="text-left">Total Individual Tests : {{$total_individual_test}}</th>
                                    <th class="text-left">Total Services : {{$total_service}}</th>
                                    <th class="text-left">Total Packages Income : {{$package_income}}</th>
                                    <th class="text-left">Total Individual Tests Incomes : {{$test_income}}</th>
                                    <th class="text-left">Total Service Income : {{$total_amount}}</th>
                                    @if(!empty($package_id))
                                        @foreach ($package_id as $packageId)
                                            <th>{{isset($selected_package[$packageId]) ? $selected_package[$packageId] : "Total Package $packageId" }} : {{isset($new_columns[$packageId]) ? $new_columns[$packageId] : "0" }} </th>
                                        @endforeach
                                    @endif
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>

@endsection