@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: #e35a80!important;">Services Income 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>Registration Date from</b></span>
                                                        <input id="registration-date-from" autocomplete="off" class="form-control" type="date" name="registration_date_from" value="@if(!empty($registration_date_from)){{$registration_date_from}}@endif">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Registration Date to</b></span>
                                                        <input id="registration-date-to" autocomplete="off" class="form-control"  type="date" name="registration_date_to" value="@if(!empty($registration_date_to)){{$registration_date_to}}@endif">
                                                    </div>
                                                    <div class="col-md-3" style="">
                                                        <span class="text-muted text-sm"><b>Packages</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>Test</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" id="service-tests" name="test_id[]" >
                                                            <option value="">Select Test</option>
                                                            @foreach($tests as $test)
                                                                <option value="{{$test->ID}}" @if(!empty($test_id)) @if(in_array($test->ID,$test_id)) selected @endif @endif >{{$test->NAME_EN}}</option>
                                                            @endforeach
                                                        </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>Processing Unit</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" id="service-process-unit" name="unit_id[]" >
                                                            <option value="">Select Processing Unit </option>
                                                            @foreach($units as $unit)
                                                                <option value="{{$unit->ID}}" @if(!empty($unit_id)) @if(in_array($unit->ID,$unit_id)) selected @endif @endif>{{$unit->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Client</b></span>
                                                        <select  id="service-client-id" name="client_id[]" multiple class="form-control rhospital_id">
                                                            <option value="">Select Client</option>
                                                            @foreach($companies as $company)
                                                                <option @if(!empty($client_id)) @if(in_array($company->ID,$client_id)) selected @endif @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>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,$groups_filter) ) selected @endif  value="{{$group->ID}}">{{$group->NAME}}-{{$group->CODE}}</option>
                                                            @endforeach
                                                        </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="service-analysis-report-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>Registration Branch</th>
                                        <th>Client Name</th>
                                        <th>Processing Unit</th>
                                        <th>Service Code</th>
                                        <th>Service Name</th>
                                        <th>Service Type</th>
                                        <th>Service Qty</th>
                                        <th>Service Subtotal</th>
                                        <th>Service {{$global_symbol['tax'] ?? 'TAX'}}</th>
                                        <th>Service Net Total</th>
                                        <!-- <th>Reservation Qty </th>
                                        <th>Patient Qty</th> -->
                                        <th>OPD Qty</th>
                                        <th>OPD Subtotal</th>
                                        <th>OPD {{$global_symbol['tax'] ?? 'TAX'}}</th>
                                        <th>OPD Net Total</th>
                                        <th>Credits Qty</th>
                                        <th>Credits Subtotal</th>
                                        <th>Credits {{$global_symbol['tax'] ?? 'TAX'}}</th>
                                        <th>Credits Net Total</th>
                                        <!-- <th>Selected Users</th> -->
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @php
                                      
                                        $total_service = 0;
                                        $total_test = 0;
                                        $total_reservation = 0;
                                        $total_cod_qty = 0;
                                        $total_service_subtotal = 0;
                                        $total_service_subtotal_tax = 0;
                                        $total_service_cod_subtotal = 0;
                                        $total_service_subtotal_cod_tax = 0;
                                        $total_service_credit_subtotal = 0;
                                        $total_service_subtotal_credit_tax = 0;
                                        $total_credit_qty = 0;
                                    

                                    @endphp
                                    @foreach($orders as $order)
                                        @php
                                          
                                            $total_service += 1;
                                            $total_test += $order->quantity ?? 0;
                                            $total_reservation += $order->total_reservations ?? 0;
                                            $total_cod_qty += $order->cod_qty ?? 0;
                                            $total_service_subtotal += ($order->service_subtotal ?? 0) - ($order->service_subtotal_tax ?? 0);
                                            $total_service_subtotal_tax += $order->service_subtotal_tax ?? 0;
                                            $total_service_cod_subtotal += ($order->service_cod_subtotal ?? 0) - ($order->service_subtotal_cod_tax ?? 0);
                                            $total_service_subtotal_cod_tax += $order->service_subtotal_cod_tax ?? 0;
                                            $total_credit_qty += $order->credit_qty ?? 0;
                                            $total_service_credit_subtotal += ($order->service_credit_subtotal ?? 0) - ($order->service_subtotal_credit_tax ?? 0);
                                            $total_service_subtotal_credit_tax += $order->service_subtotal_credit_tax ?? 0;
                                            
                                        @endphp
                                        <tr>
                                            <td>{{$order->registration_branch ?? null}}</td>
                                            <td>{{$order->client_name ?? null}}</td>
                                            <td>{{$order->processing_unit ?? null}}</td>
                                            <td>{{$order->CODE ?? null}}</td>
                                            <td>{{$order->NAME_EN ?? null}}</td>
                                            <td>{{$order->service_type ?? null}}</td>
                                            <td>{{$order->quantity ?? 0}}</td>
                                            <td>{{($order->service_subtotal ?? 0) - ($order->service_subtotal_tax ?? 0)}}</td>
                                            <td>{{$order->service_subtotal_tax ?? 0}}</td>
                                            <td>{{($order->service_subtotal ?? 0)}}</td>
                                            <td>{{$order->cod_qty ?? 0}}</td>
                                            <td>{{($order->service_cod_subtotal ?? 0) - ($order->service_subtotal_cod_tax ?? 0)}}</td>
                                            <td>{{$order->service_subtotal_cod_tax ?? 0}}</td>
                                            <td>{{($order->service_cod_subtotal ?? 0)}}</td>
                                            <td>{{$order->credit_qty ?? 0}}</td>
                                            <td>{{($order->service_credit_subtotal ?? 0) - ($order->service_subtotal_credit_tax ?? 0)}}</td>
                                            <td>{{$order->service_subtotal_credit_tax ?? 0}}</td>
                                            <td>{{($order->service_credit_subtotal ?? 0)}}</td>
                                        </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"></th>
                                    <th class="text-left"></th>
                                    <th class="text-left">Service Qty <br> {{$total_test}}</th>
                                    <th class="text-left">Service Subtotal <br> {{$total_service_subtotal}} </th>
                                    <th class="text-left">Service {{$global_symbol['tax'] ?? 'TAX'}} <br> {{$total_service_subtotal_tax}}</th>
                                    <th class="text-left">Service Net Total <br> {{$total_service_subtotal + $total_service_subtotal_tax}} </th>                                  
                                    <th class="text-left">OPD Qty <br>{{$total_cod_qty}}</th>
                                    <th class="text-left">OPD Subtotal <br> {{$total_service_cod_subtotal}} </th>
                                    <th class="text-left">OPD {{$global_symbol['tax'] ?? 'TAX'}} <br> {{$total_service_subtotal_cod_tax}}</th>
                                    <th class="text-left">OPD Net Total <br>{{$total_service_cod_subtotal + $total_service_subtotal_cod_tax}}</th>
                                    <th class="text-left">Credits Qty <br>{{$total_credit_qty}}</th>
                                    <th class="text-left">Credits Subtotal <br> {{$total_service_credit_subtotal}} </th>
                                    <th class="text-left">Credits {{$global_symbol['tax'] ?? 'TAX'}} <br> {{$total_service_subtotal_credit_tax}}</th>
                                    <th class="text-left">Credits Net Total <br> {{$total_service_credit_subtotal + $total_service_subtotal_credit_tax}}</th>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>

@endsection