@extends('operations.layout.mainlayout')

@section('content')
{{--    @if(session('role') != 4 && session('role') != 5 && session('role') != 8)--}}
{{--        {{exit("<h1>Unauthorized access</h1>")}}--}}
{{--    @endif--}}

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <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 Revenue Analysis</h1>
                </div><!-- /.col -->
                <div class="col-sm-6">

                </div><!-- /.col -->
            </div><!-- /.row -->
        </div><!-- /.container-fluid -->
    </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-4">
                                                    <span class="text-muted text-sm"><b>Payment Date from</b></span>
                                                    <input id="date-from" required class="form-control" type="date" name="date_from" value="@if(!empty($date_from)){{$date_from}}@endif" placeholder="Date From">                                             </div>
                                                <div class="col-md-4">
                                                    <span class="text-muted text-sm" required><b>Payment Date to</b></span>
                                                    <input id="date-to" class="form-control"  type="date" name="date_to" value="@if(!empty($date_to)){{$date_to}}@endif" placeholder="Date To">
                                                </div>
                                                <div class="col-md-4">
                                                    <span class="text-muted text-sm"><b>Branch</b></span>
                                                    <select required class="form-control rhospital_id multi"  multiple="multiple" name="hospital[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option disabled >Select Branch</option>
                                                    @foreach($hospitals as $ehospital)
                                                            <option class="hospital-option" @if(!empty($hospital) && in_array($ehospital->ID,explode(",",$hospital)) ) selected @endif value="{{$ehospital->ID}}">{{$ehospital->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                    <div class="custom-control custom-switch">
                                                        <input type="checkbox" class="custom-control-input" @if(isset($all_hospital)) checked @endif value="1" name="all_hospital" id="select-all">
                                                        <label class="custom-control-label" for="select-all"  style="margin-right: 10px;font-weight: 300;"> Select All</label>
                                                    </div>
                                                </div>
                                            </div>


                                        </div>
                                    </div>
                                </div>
                                <div class="card-footer">
                                    <div class="text-right">
                                        <button type="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">

                        <!-- /.card-header -->
                        <div class="card-body">

                            <table id="payment-table" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>Branch</th>
                                    <th>Date</th>
                                    <th>Day</th>
                                    <th>Reservations QTY</th>
                                    <th>Tests QTY</th>
                                    <th>Patient QTY</th>
                                    <th>Total Price</th>
                                    <th>Discount</th>
                                    <th>Subtotal</th>
                                    <th>{{$global_symbol['tax'] ?? 'TAX'}}</th>
                                    <th>Net Total</th>
                                    <th>Total Refund</th>
                                    <th>Cash</th>
                                    <th>Visa</th>
                                    <th>Total (Cash + Visa)</th>
                                    <th>Online</th>
                                    <th>Credit</th>

                                    <th>Bank Trans</th>

                                    <th>B2B Cash</th>
                                    <th>Tamara</th>
                                    <th>Tabby</th>

                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                    <tr>
                                        <td class="text-nowrap">{{$order['NAME_EN']??null}}</td>
                                        <td >{{$order['DATE']??null}}</td>
                                        <td>{{$order['DAY']??null}}</td>
                                        <td>{{$order['TOTAL_RESERVATIONS']??0}}</td>
                                        <td>{{$order['QTY']??0}}</td>
                                        <td>{{$order['TOTAL_PATIENTS']??0}}</td>
                                        <td>{{round(($order['TOTAL_DISCOUNT'] + $order['TOTAL_PRICE']) - $order['TOTAL_TAX'], 2)}}</td>
                                        <td>{{$order['TOTAL_DISCOUNT']??0}}</td>
                                        <td>{{round($order['TOTAL_PRICE'] - $order['TOTAL_TAX'], 2)??0}}</td>
                                        <td>{{round($order['TOTAL_TAX']??0,2)}}</td>
                                        <td>{{$order['TOTAL_PRICE']??0}}</td>
                                        <td>{{round($order['TOTAL_REFUND']??0,2)}}</td>
                                        <td>{{$order['TOTAL_CASH']??0 / 100}}</td>
                                        <td>{{$order['TOTAL_VISA']??0 / 100}}</td>
                                        <td>{{($order['TOTAL_CASH']??0 / 100) + ($order['TOTAL_VISA']??0 / 100)}}</td>
                                        <td>{{round($order['TOTAL_ONLINE']??0,2)}}</td>
                                        <td>{{round($order['TOTAL_CREDIT']??0,2)}}</td>

                                        <td>{{round($order['TOTAL_BANK_TRANSFER']??0,2)}}</td>
                                        <td>{{$order['TOTAL_B2B_CASH']??0 / 100}}</td>
                                        <td>{{round($order['TOTAL_TAMARA']??0,2)}}</td>
                                        <td>{{round($order['TOTAL_TABBY']??0,2)}}</td>


                                    </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th></th>
                                <th></th>
                                <th>Totals</th>
                            
                                <th>{{$total_reservations}}</th>
                                <th>{{$qty_total}}</th>
                                <th>{{$total_patients}}</th>
                               
                                <th>{{$total_price}}</th>
                                <th>{{$discount_total}}</th>
                                <th>{{$total_subtotal}}</th>
                                <th>{{round($tax_total,2)}}</th>
                                <th>{{$net_total}}</th>
                                <th>{{round($total_refund,2)}}</th>
                                <th>{{$cash_total}}</th>
                                <th>{{$visa_total}}</th>
                                <th>{{$total}}</th>
                                <th>{{round($online_total,2)}}</th>
                                <th>{{round($credit_total,2)}}</th>
                                <th>{{round($bank_transfer_total,2)}}</th>
                                <th>{{$b2b_total}}</th>
                                <th>{{$tamara_total}}</th>
                                <th>{{$tabby_total}}</th>
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
@endsection

@section('footer-scripts')
    <script>
        $('#select-all').on("click", function (e) {
            if($("#select-all").is(':checked'))
            {
                $(".rhospital_id > .hospital-option").prop("selected","selected");
                $(".rhospital_id").trigger("change");
            }
            else{
                $(".rhospital_id > .hospital-option").prop("selected","");
                $(".rhospital_id").trigger("change");
            }

        });
    </script>
@endsection