@extends('operations.layout.mainlayout')

@section('content')
{{--    @if(session('role') != 4 &&  session('role') != 8)--}}
{{--        {{exit("<h1>Unauthorized access</h1>")}}--}}
{{--    @endif--}}
<style>
     .select2-container--default .select2-selection--multiple .select2-selection__choice__display{
        color:black;
    }
</style>
<!-- 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: #e35a80!important;">Sales Report</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">
                        <div class="row">
                            <div class="col" style="text-align: center;">
                                <div class="alert alert-danger alert-danger-order" role="alert" style="@if(empty($error))display: none;@endif">@if(!empty($error)){{$error}}@endif</div>
                            </div>
                        </div>
                        <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>Branch</b></span>
                                                    <select class="form-control rhospital_id" multiple="multiple" name="hospitals[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option value="">Select Branch</option>
                                                        @foreach($hospitals as $ehospital)
                                                            <option @if(!empty($selected_hospitals) && in_array($ehospital->ID,$selected_hospitals) ) selected @endif value="{{$ehospital->ID}}">{{$ehospital->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Client</b></span>
                                                    <select class="form-control rhospital_id" multiple="multiple" name="clients[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option value="">Select Client</option>
                                                        @foreach($companies as $company)
                                                            <option @if(!empty($selected_companies) && in_array($company->ID,$selected_companies) ) selected @endif value="{{$company->ID}}">{{$company->COMPANY_NAME}}{{!empty($company->CLIENT_CODE)?' ('.$company->CLIENT_CODE.')':''}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Tests</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" name="tests[]" id="service-tests" >
                                                            <option value="">Select Test</option>
                                                            @foreach($packages as $package)
                                                            <option @if(!empty($tests) && in_array($package->ID,$tests) ) selected @endif value="{{$package->ID}}">{{$package->NAME_EN}}</option>
                                                        @endforeach
                                                        </select>
                                                    </div>
                                                <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Packages</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" name="packages[]" id="service-packages" >
                                                            <option value="">Select Packages</option>
                                                            @foreach($packages_lists as $packages_list)
                                                            <option @if(!empty($packages_selected) && in_array($packages_list->ID,$packages_selected) ) selected @endif value="{{$packages_list->ID}}">{{$packages_list->NAME_EN}}</option>
                                                        @endforeach
                                                        </select>
                                                    </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Payment Date from</b></span>
                                                    <input required id="payment-date-from" class="form-control" type="date" name="payment_date_from" value="@if(!empty($payment_date_from)){{$payment_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="payment-date-to" class="form-control"  type="date" name="payment_date_to" value="@if(!empty($payment_date_to)){{$payment_date_to}}@endif" placeholder="Date To" />
                                                </div>
                                                <div required class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Test Status</b></span>
                                                    <select class="form-control rhospital_id" id="report-status-id" name="status">
                                                        <option value="">Select Status</option>
                                                        <option @if(!empty($status) && $status == 2) selected @endif value="2">Sample Collected</option>
                                                        <option @if(!empty($status) && $status == 5) selected @endif value="5">Outsourced</option>
                                                        <option @if(!empty($status) && $status == 3) selected @endif value="3">Sample Received</option>
                                                        <option @if(!empty($status) && $status == 4) selected @endif value="4">Ready</option>
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Reservation Status</b></span>
                                                    <select class="form-control rhospital_id"  name="reservation_status">
                                                        <option value="">Select Status</option>
                                                        @foreach($order_status as $ostatus)
                                                            <option @if(!empty($ostatus) && $ostatus->ORDER_STATUS_ID == $reservation_status) selected @endif value="{{$ostatus->ORDER_STATUS_ID}}">{{$ostatus->LAB_DESC_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Unit</b></span>
                                                    <select class="form-control rhospital_id"  multiple="multiple" id="reservation-unit-id" name="units[]">
                                                        <option value="">Select Unit</option>
                                                        @foreach($units as $unit)
                                                            <option @if(!empty($selected_units) && in_array($unit->ID,$selected_units) ) selected @endif value="{{$unit->ID}}">{{$unit->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Lab Unit Category</b></span>
                                                    <select class="form-control rhospital_id"  multiple="multiple" id="reservation-categories-unit-id" name="units_categories[]">
                                                        <option value="">Select Lab Unit Category</option>
                                                        @foreach($units_categories as $units_category)
                                                            <option @if(!empty($selected_units_categories) && in_array($units_category->ID,$selected_units_categories) ) selected @endif value="{{$units_category->ID}}">{{$units_category->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </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>
                                    </div>
                                </div>

                            </form>
                        </div>
                    </div>
                    <div class="row">
                        <div @if(!in_array('hide_financial_data_reports', session('permissions', []))) class="col-md-6" @else class="col-md-12" @endif>
                            <div class="card">
                                <div class="card-header">
                                    <h3 class="card-title">Branch Quantity Chart</h3>

                                    <div class="card-tools">
                                        <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
                                        </button>
                                        <button type="button" class="btn btn-tool" data-card-widget="remove"><i class="fas fa-times"></i>
                                        </button>
                                    </div>
                                </div>
                                <!-- /.card-header -->
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-7">
                                            <div class="chart-responsive">
                                                <canvas id="pieChart" height="150"></canvas>
                                            </div>
                                            <!-- ./chart-responsive -->
                                        </div>
                                        <!-- /.col -->
                                        <div class="col-md-5">
                                            <ul class="chart-legend clearfix">
                                                @foreach($orders as $eorder)
                                                    <li><i class="far fa-circle" style="color: {{$eorder->COLOR}}"></i> {{$eorder->NAME_EN}}</li>
                                                @endforeach
                                            </ul>
                                        </div>
                                        <!-- /.col -->
                                    </div>
                                    <!-- /.row -->
                                </div>
                                <!-- /.card-body -->
                                <div class="card-footer bg-white p-0">

                                </div>
                                <!-- /.footer -->
                            </div>
                        </div>
                        @if(!in_array('hide_financial_data_reports', session('permissions', [])))
                            <div class="col-md-6">
                                <div class="card">
                                    <div class="card-header">
                                        <h3 class="card-title">Branch Sales Chart</h3>

                                        <div class="card-tools">
                                            <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
                                            </button>
                                            <button type="button" class="btn btn-tool" data-card-widget="remove"><i class="fas fa-times"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <!-- /.card-header -->
                                    <div class="card-body">
                                        <div class="row">
                                            <div class="col-md-7">
                                                <div class="chart-responsive">
                                                    <canvas id="pieChart2" height="150"></canvas>
                                                </div>
                                                <!-- ./chart-responsive -->
                                            </div>
                                            <!-- /.col -->
                                            <div class="col-md-5">
                                                <ul class="chart-legend clearfix">
                                                    @foreach($orders as $eorder)
                                                        <li><i class="far fa-circle {{$eorder->COLOR}}"></i> {{$eorder->NAME_EN}}</li>
                                                    @endforeach
                                                </ul>
                                            </div>
                                            <!-- /.col -->
                                        </div>
                                        <!-- /.row -->
                                    </div>
                                    <!-- /.card-body -->
                                    <div class="card-footer bg-white p-0">

                                    </div>
                                    <!-- /.footer -->
                                </div>
                            </div>
                        @endif

                    </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>Reservations QTY</th>
                                    <th>Patient QTY</th>
                                    <th>Qty</th>
                                    @if(!in_array('hide_financial_data_reports', session('permissions', [])))
                                    <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>Credit</th>
                                    <th>Refund (Cash)</th>
                                    <th>Refund (Visa)</th>
                                    <th>Bank Transfer</th>
                                    <th>Online</th>
                                    <th>Tamara</th>
                                    <th>Tabby</th>
                                    @endif
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                        <tr>
                                            <td>{{$order->NAME_EN}}</td>
                                            <td>{{$order->TOTAL_RESERVATIONS??0}}</td>
                                            <td>{{$order->TOTAL_PATIENTS??0}}</td>
                                            <td>{{$order->TOTAL_QTY??0}}</td>
                                            @if(!in_array('hide_financial_data_reports', session('permissions', [])))
                                            <td>{{($order->TOTAL_PRICE)+($order->TOTAL_DISCOUNT) - ($order->TOTAL_TAX)}}</td>
                                            <td>{{$order->TOTAL_DISCOUNT??0}}</td>
                                            <td>{{($order->TOTAL_PRICE)-($order->TOTAL_TAX)}}</td>
                                            <td>{{$order->TOTAL_TAX??0}}</td>
                                            <td>{{($order->TOTAL_PRICE)}}</td>
                                            <td>{{$order->TOTAL_CASH / 100}}</td>
                                            <td>{{$order->TOTAL_VISA / 100}}</td>
                                            <td>{{$order->TOTAL_CREDIT??0}}</td>
                                            <td>{{$order->TOTAL_CASH_REFUND??0}}</td>
                                            <td>{{$order->TOTAL_VISA_REFUND??0}}</td>
                                            <td>{{$order->TOTAL_BANK_TRANSFER??0}}</td>
                                            <td>{{$order->TOTAL_ONLINE??0}}</td>
                                            <td>{{$order->TOTAL_TAMARA??0}}</td>
                                            <td>{{$order->TOTAL_TABBY??0}}</td>
                                            @endif
                                        </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th>Totals</th>
                                <th>{{$total_reservation_qty}}</th>
                                <th>{{$total_patient_qty}}</th>
                                <th>{{$total_qty}}</th>
                                @if(!in_array('hide_financial_data_reports', session('permissions', [])))
                                <th>{{$price_total}}</th>
                                <th>{{$total_discounts}}</th>
                                <th>{{$total_subtotal}}</th>
                                <th>{{$total_tax}}</th>
                                <th>{{$total_net}}</th>
                                <th>{{$cash_total}}</th>
                                <th>{{$visa_total}}</th>
                                <th>{{$total_credit}}</th>
                                <th>{{$total_refund_cash}}</th>
                                <th>{{$total_refund_visa}}</th>
                                <th>{{$total_bank_transfer}}</th>
                                <th>{{$total_online}}</th>
                                <th>{{$total_tamara}}</th>
                                <th>{{$total_tabby}}</th>
                                @endif
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->

@endsection