@extends('operations.layout.mainlayout')

@section('content')
<style>
        .select2-container--default .select2-selection--multiple .select2-selection__choice__display{
            color:black;
        }
</style>
{{--    @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;">Accounts Totals</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-4">
                                                    <span class="text-muted text-sm"><b>Payment Date from</b></span>
                                                    <input required 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-4">
                                                    <span  class="text-muted text-sm"><b>Payment Date to</b></span>
                                                    <input required 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>Client</b></span>
                                                    <select class="form-control rhospital_id multi" multiple="multiple" name="company[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option value="">Select an Client</option>
                                                        @foreach($companies as $ecompany)
                                                            <option @if(!empty($company) && in_array($ecompany->ID,$company)) selected @endif value="{{$ecompany->ID}}">{{$ecompany->COMPANY_NAME}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                            <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="hospital[]" >
                                                        <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>
                                                 <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Payment Method</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" name="payment_methods_ids[]" id="clients-claim-payments">
                                                        @foreach($payment_methods as $payment_method)
                                                            <option class="payment-options" @if(!empty($payment_methods_ids) && in_array($payment_method->PAYMENT_METHOD_ID,$payment_methods_ids) ) selected @endif value="{{$payment_method->PAYMENT_METHOD_ID}}">{{$payment_method->DESC_EN}}</option>
                                                        @endforeach
                                                        </select>
                                                </div>

                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Client Groups</b></span>
                                                    <select  class="form-control rhospital_id multi" id="group_ids"  multiple="multiple" name="groups_filter[]">
                                                        <option value="" disabled>Select Group</option>
                                                        @foreach($groups as $group)
                                                            <option class="hospital-option" @if(!empty($groups_filter) && in_array($group->ID,explode(",",$groups_filter)) ) selected @endif  value="{{$group->ID}}">{{$group->NAME}}-{{$group->CODE}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Contract Types</b></span>
                                                    <select  class="form-control rhospital_id multi" id="contract_type_ids"  multiple="multiple" name="contract_types_filter[]">
                                                        <option value="" disabled>Select Contract Type</option>
                                                        @foreach($contractTypes as $contractType)
                                                            <option class="hospital-option" @if(!empty($contract_types_filter) && in_array($contractType->ID,(array)$contract_types_filter) ) selected @endif  value="{{$contractType->ID}}">{{$contractType->NAME}}-{{$contractType->CODE}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-3">
                                                    <span class="text-muted text-sm"><b>Account Managers</b></span>
                                                    <select name="account_manager_id" class="form-control rhospital_id"
                                                            id="ref-company-id">
                                                        <option value="">Select Account Manager</option>
                                                        @foreach($accountManagers as $key => $value)
                                                            <option
                                                                @if(!empty(request('account_manager_id')) && request('account_manager_id') == $key) selected
                                                                @endif value="{{$key}}">{{$value}}
                                                            </option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <!-- <div class="col-md-6">
                                                    <span class="text-muted text-sm"><b>Report Type</b></span>
                                                    <select class="form-control" name="report_type" >
                                                        <option value="">Select Hospital</option>
                                                        <option @if(!empty($report_type) && $report_type == 1) selected @endif value="1">Companies</option>
                                                        <option @if(!empty($report_type) && $report_type == 2) selected @endif value="2">Medical Complex</option>
                                                    </select>
                                                </div> -->

                                                <!-- <div class="col-md-6">
                                                    <span class="text-muted text-sm"><b>Test Status</b></span>
                                                    <select class="form-control" id="report-status-id" name="status">
                                                        <option value="">Select Status</option>
                                                        <option @if(!empty($status) && $status == 1) selected @endif value="1">Order Confirmed</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">Received</option>
                                                        <option @if(!empty($status) && $status == 4) selected @endif value="4">Ready</option>
                                                    </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>
                                        <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>Client</th>
                                    <th>B2B Invoice Number</th>
                                    <th>B2B Invoice Date</th>
                                    <th>Account Manager</th>
                                    <th>Reservation QTY</th>
                                    <th>Patient QTY</th>
                                    <th>Test 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>Credit</th>
                                    <th>Cost Price</th>
                                    <th>P&L ( Subtotal - Cost )</th>
                                    <th>Remaining Amount</th>
                                    <th>Paid Amount</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                        <tr>
                                        <td>{{$order->NAME_EN}}</td>
                                            <td>
                                                <a target="_blank" href="/operations/account-details-report?{{ http_build_query(array_filter([
                                                        'date_from' => $date_from ?? null,
                                                        'date_to' => $date_to ?? null,
                                                        'company' => [$order->ID] ?? [],
                                                        'hospital' => $hospital ?? [],
                                                        'payment_methods_ids' => $payment_methods_ids ?? [],
                                                        'groups_filter' => [$groups_filter] ?? [],
                                                    ])) }}">
                                                    {{ $order->COMPANY_NAME }}
                                                </a>
                                            </td>
                                            <td>{{$order->B2B_INVOICE_NO ?? ''}}</td>
                                            <td>{{$order->B2B_INVOICE_DATE ?? ''}}</td>
                                            <td>{{$order->account_manager_name}}</td>
                                            <td>{{$order->TOTAL_RESERVATIONS}}</td>
                                            <td>{{$order->TOTAL_PATIENTS}}</td>
                                            <td>{{$order->TOTAL_QTY}}</td>
                                            <td>{{($order->TOTAL_PRICE)+($order->TOTAL_DISCOUNT) - ($order->TOTAL_TAX)}}</td>
                                            <td>{{$order->TOTAL_DISCOUNT}}</td>
                                            <td>{{$order->SUB_TOTAL}}</td>
                                            <td>{{$order->TOTAL_TAX}}</td>
                                            <td>{{$order->TOTAL_PRICE}}</td>
                                            <td>{{$order->TOTAL_CASH / 100}}</td>
                                            <td>{{$order->TOTAL_VISA / 100}}</td>
                                            <td>{{$order->TOTAL_CREDIT}}</td>
                                            <td>{{$order->COST_PRICE ?? 0}}</td>
                                            <td>{{($order->SUB_TOTAL ?? 0) - ($order->COST_PRICE ?? 0)}}</td>
                                            <td>{{(empty($order->TOTAL_PRICE) ? 0 : $order->TOTAL_PRICE) - (($order->TOTAL_AMOUNT / 100))}}</td>
                                            <td>{{empty($order->TOTAL_INVOICE) ? "0" : $order->TOTAL_INVOICE}}</td>
                                        </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th>Totals</th>
                                <th>{{$total_reservations}}</th>
                                <th>{{$total_patients}}</th>
                                <th>{{$total_qty}}</th>
                                <th>{{$price_total}}</th>
                                <th>{{$discount_total}}</th>
                                <th>{{$sub_total}}</th>
                                <th>{{$tax_total}}</th>
                                <th>{{$total_net}}</th>

                                <th>{{$cash_total}}</th>
                                <th>{{$visa_total}}</th>
                                <th>{{$credit_total}}</th>
                                <th>{{$total_cost}}</th>
                                <th>{{$sub_total - $total_cost}}</th>
                                <th>{{$total_net - $total}}</th>
                                <th>{{$total_invoice}}</th>
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->

@endsection