@extends('operations.layout.mainlayout')

@section('content')
    <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;">Sales Per Hour Report</h1>
                    </div>
                </div>
            </div>
        </div>

        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <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="date-from" class="form-control" type="date" name="date_from" value="@if(!empty($date_from)){{$date_from}}@endif" placeholder="Date From">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><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-3">
                                                        <span class="text-muted text-sm"><b>Hour From</b></span>
                                                        <input id="hour-from" class="form-control" type="time" name="hour_from" value="@if(!empty($hour_from)){{$hour_from}}@endif" placeholder="Hour From">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Hour To</b></span>
                                                        <input id="hour-to" class="form-control" type="time" name="hour_to" value="@if(!empty($hour_to)){{$hour_to}}@endif" placeholder="Hour To">
                                                    </div>
                                                </div>
                                                <div class="row mt-3">
                                                    <div class="col-md-6">
                                                        <span class="text-muted text-sm"><b>Branch</b></span>
                                                        <select class="form-control rhospital_id multi" id="branches_id" multiple="multiple" name="hospital[]" required>
                                                            <option value="" disabled>Select Branch</option>
                                                            @foreach($hospitals as $ehospital)
                                                                <option class="hospital-option" @if(!empty($hospital) && in_array($ehospital->ID,$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">
                            <div class="card-body">
                                <table id="sales-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>Date</th>
                                        <th>Hour From</th>
                                        <th>Hour To</th>
                                        <th>Reservation QTY</th>
                                        <th>Test QTY</th>
                                        <th>Patient QTY</th>
                                        <th>Price</th>
                                        <th>Discount</th>
                                        <th>SubTotal</th>
                                        <th>{{$global_symbol['tax'] ?? 'TAX'}}</th>
                                        <th>Net Total</th>
                                        <th>Cash</th>
                                        <th>Visa</th>
                                        <th>Bank Transfer</th>
                                        <th>Online</th>
                                        <th>Tabby</th>
                                        <th>Tamara</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($sales_per_hour as $sale)
                                        <tr>
                                            <td>{{ $sale->DATE }}</td>
                                            <td>{{ $sale->HOUR }}</td>
                                            <td>{{ date('h:i:s A', strtotime('+1 hour', strtotime($sale->HOUR))) }}</td>
                                            <td>{{ $sale->TOTAL_RESERVATIONS }}</td>
                                            <td>{{ $sale->TOTAL_TESTS }}</td>
                                            <td>{{ $sale->TOTAL_PATIENT }}</td>
                                            <td>{{ $sale->TOTAL_PRICE }}</td>
                                            <td>{{ $sale->TOTAL_DISCOUNT }}</td>
                                            <td>{{ $sale->SUB_TOTAL }}</td>
                                            <td>{{ $sale->TOTAL_TAX }}</td>
                                            <td>{{ $sale->NET_PRICE }}</td>
                                            <td>{{ $sale->TOTAL_CASH}}</td>
                                            <td>{{ $sale->TOTAL_VISA}}</td>
                                            <td>{{ $sale->TOTAL_BANK_TRANSFER }}</td>
                                            <td>{{ $sale->TOTAL_ONLINE }}</td>
                                            <td>{{ $sale->TOTAL_TABBY }}</td>
                                            <td>{{ $sale->TOTAL_TAMARA }}</td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                    <tfoot>
                                    <tr>
                                        <th colspan="3">Totals</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_RESERVATIONS') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_TESTS') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_PATIENT') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_PRICE') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_DISCOUNT') }}</th>
                                        <th>{{ $sales_per_hour->sum('SUB_TOTAL') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_TAX') }}</th>
                                        <th>{{ $sales_per_hour->sum('NET_PRICE') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_CASH')}}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_VISA')}}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_BANK_TRANSFER') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_ONLINE') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_TABBY') }}</th>
                                        <th>{{ $sales_per_hour->sum('TOTAL_TAMARA') }}</th>
                                    </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>
@endsection
@section('footer-scripts')
    <script>
        $('#select-all').on("click", function (e) {
            if($("#select-all").is(':checked'))
            {
                $("#branches_id > .hospital-option").prop("selected","selected");
                $("#branches_id").trigger("change");
            }
            else{
                $("#branches_id > .hospital-option").prop("selected","");
                $("#branches_id").trigger("change");
            }

        });

    </script>
@endsection