@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: var(--blazma-text)!important;">Services Analysis 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="text" 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="text" name="registration_date_to" value="@if(!empty($registration_date_to)){{$registration_date_to}}@endif">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Payment Date from</b></span>
                                                        <input id="payment-date-from" autocomplete="off" class="form-control" type="date" name="payment_date_from" value="@if(!empty($payment_date_from)){{$payment_date_from}}@endif" >
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Payment Date to</b></span>
                                                        <input id="payment-date-to" autocomplete="off" class="form-control"  type="date" name="payment_date_to" value="@if(!empty($payment_date_to)){{$payment_date_to}}@endif" >
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Collected Date from</b></span>
                                                        <input id="service-collection-from" name="collection_date_from" value="@if(!empty($collection_date_from)){{$collection_date_from}}@endif" autocomplete="off" class="form-control" type="date">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Collected Date to</b></span>
                                                        <input id="service-collection-to" name="collection_date_to" value="@if(!empty($collection_date_to)){{$collection_date_to}}@endif" autocomplete="off" class="form-control"  type="date">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Received Date from</b></span>
                                                        <input id="receive-date-from" class="form-control" type="date" name="receive_date_from" value="@if(!empty($receive_date_from)){{$receive_date_from}}@endif" >
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Received Date to</b></span>
                                                        <input id="receive-date-to" class="form-control"  type="date" name="receive_date_to" value="@if(!empty($receive_date_to)){{$receive_date_to}}@endif" >
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Approval Date from</b></span>
                                                        <input id="result-date-from" autocomplete="off" class="form-control" type="date" name="result_date_from" value="@if(!empty($result_date_from)){{$result_date_from}}@endif">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Approval Date to</b></span>
                                                        <input id="result-date-to" autocomplete="off" class="form-control"  type="date" name="result_date_to" value="@if(!empty($result_date_to)){{$result_date_to}}@endif" >
                                                    </div>

                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Test Status</b></span>
                                                        <select class="form-control rhospital_id" id="service-status-id" name="test_status">
                                                            <option value="">Select Status</option>
                                                            <option value="-5" @if(!empty($test_status)) @if($test_status == -5) selected @endif @endif>Pending</option>
                                                            <option value="-1" @if(!empty($test_status)) @if($test_status == -1) selected @endif @endif>Rejected</option>
                                                            <option value="1" @if(!empty($test_status)) @if($test_status == 1) selected @endif @endif>Order Confirmed</option>
                                                            <option value="13" @if(!empty($test_status)) @if($test_status == 13) selected @endif @endif>Pre Analytical</option>
                                                            <option value="2" @if(!empty($test_status)) @if($test_status == 2) selected @endif @endif>Sample Collected</option>
                                                            <option value="6" @if(!empty($test_status)) @if($test_status == 6) selected @endif @endif>In Transit</option>
                                                            <option value="7" @if(!empty($test_status)) @if($test_status == 7) selected @endif @endif>Dropped off</option>
                                                            <option value="5" @if(!empty($test_status)) @if($test_status == 5) selected @endif @endif>Outsourced</option>
                                                            <option value="3" @if(!empty($test_status)) @if($test_status == 3) selected @endif @endif>Received</option>
                                                            <option value="4" @if(!empty($test_status)) @if($test_status == 4) selected @endif @endif>Ready</option>
                                                        </select>
                                                    </div>

                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Booking Source</b></span>
                                                        <select class="form-control rhospital_id" id="service-booking-source" name="bsource">
                                                            <option value="">All</option>
                                                            <option @if(!empty($bsource) && $bsource == 1) selected @endif value="1">B2B Outreach</option>
                                                            <option @if(!empty($bsource) && $bsource == 2) selected @endif value="2">B2B Operations</option>
                                                            <option @if(!empty($bsource) && $bsource == 3) selected @endif value="3">B2C Operations/Portal</option>
                                                        </select>
                                                    </div>

                                                </div>

                                                <div class="row">
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Test Name</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 class="col-md-3" style="">
                                                        <span class="text-muted text-sm"><b>Package Name</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 Source Filter</b></span>
                                                        <select class="form-control rhospital_id" id="service-test-type" name="test_type">
                                                            <option value=""> All (Individual Tests + Package Name)</option>
                                                            <option value="test" @if(!empty($test_type)) @if($test_type == 'test') selected @endif @endif>Individual Tests</option>
                                                            <option value="package" @if(!empty($test_type)) @if($test_type == 'package') selected @endif @endif>Packages (Tests in Packages)</option>
                                                            <option value="service" @if(!empty($test_type)) @if($test_type == 'service') selected @endif @endif>Service</option>
                                                            <option value="all_tests" @if(!empty($test_type)) @if($test_type == 'all_tests') selected @endif @endif>All Tests (Individual Tests + Test in Packages)</option>
                                                        </select>
                                                    </div>

                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Reservation Type</b></span>
                                                        <select class="form-control rhospital_id" name="type" id="type">
                                                            <option value="0" @if(empty($type)) selected @endif>All</option>
                                                            <option value="1" @if(!empty($type) && $type == 1) selected @endif>Normal Booking</option>
                                                            <option value="2" @if(!empty($type) && $type == 2) selected @endif>Homevisit</option>
                                                        </select>
                                                    </div>

                                                    <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 disabled 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 Branch</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" id="service-processing-hospitals" name="processing_hospital_id[]" >
                                                            <option disabled value="">Select Processing Branch </option>
                                                            @foreach($processing_hospitals as $processing_hospital)
                                                                <option value="{{$processing_hospital->ID}}" @if(!empty($processing_hospital_id)) @if(in_array($processing_hospital->ID,$processing_hospital_id)) selected @endif @endif>{{$processing_hospital->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>

                                                    <div class="col-md-3" >
                                                        <span class="text-muted text-sm"><b>Collection Branch</b></span>
                                                        <select class="form-control rhospital_id" multiple="multiple" id="service-collection-branch" name="collection_branch_id[]" >
                                                            <option disabled value="">Select Collection Branch </option>
                                                            @foreach($collection_branches as $collection_branch)
                                                                <option value="{{$collection_branch->ID}}" @if(!empty($collection_branch_id)) @if(in_array($collection_branch->ID,$collection_branch_id)) selected @endif @endif>{{$collection_branch->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 disabled 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 disabled 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 Group</b></span>
                                                        <select class="form-control rhospital_id"  name="client_group_ids[]" multiple>
                                                            <option  value="">Select Client Group</option>
                                                            @foreach($client_groups as $group)
                                                                <option @if(!empty($client_group_ids) && in_array($group->ID,$client_group_ids)) 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>Branch Manager</b></span>
                                                        <select name="branch_manager_id" class="form-control rhospital_id">
                                                            <option value="">Select Branch Manager</option>
                                                            @foreach($users as $manager)
                                                                <option @if(!empty($branch_manager_id) && $manager->ID == $branch_manager_id) selected @endif value="{{$manager->ID}}">{{$manager->USERNAME}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>

                                                    <div class="col-md-3" >
                                                        <span class="text-muted text-sm"><b>Paid Users</b></span>
                                                        <select class="form-control rhospital_id" multiple id="service-user-id" name="user_id[]">
                                                            <option value="" disabled>Select Users </option>
                                                            @foreach($users as $user)
                                                                <option value="{{$user->ID}}" @if(!empty($user_id)) @if(in_array($user->ID,$user_id)) selected @endif @endif>{{$user->USERNAME}}</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" name="payment_id[]" multiple="multiple" id="service-payments">
                                                            <option value="1" @if(!empty($payment_id)) @if(in_array(1,$payment_id)) selected @endif @endif>COD</option>
                                                            <option value="3" @if(!empty($payment_id)) @if(in_array(3,$payment_id)) selected @endif @endif>Credits</option>
                                                            <option value="2" @if(!empty($payment_id)) @if(in_array(2,$payment_id)) selected @endif @endif>Online</option>
                                                        </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>Service Name</th>
                                        <th>Service Code</th>
                                        <th>TAT</th>
                                        <th>In TAT</th>
                                        <th>Out TAT</th>
                                        <th>Test Qty</th>
                                        <th>Reservation Qty</th>
                                        <th>Patient Qty</th>
                                        <th>Net Total</th>
                                        <th>Cost Price</th>
                                        <th>P&L</th>
                                        <th>OPD Qty</th>
                                        <th>OPD Amount</th>
                                        <th>Credits Qty</th>
                                        <th>Credits Amount</th>
                                        <th>Online Qty</th>
                                        <th>Online Amount</th>
                                        <th>Selected Users</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @php
                                        $total_service = 0;
                                        $total_test = 0;
                                        $total_reservation = 0;
                                        $total_patient_qty = 0;
                                        $total_cod_qty = 0;
                                        $total_credit_qty = 0;
                                        $total_credit_amount = 0;
                                        $total_cod_amount = 0;
                                        $total_online_qty = 0;
                                        $total_online_amount = 0;
                                        $total_amount = 0;
                                        $total_cost_price = 0;
                                        $total_pl = 0;
                                        $total_service_subtotal_cod_tax = 0;
                                        $total_service_subtotal_credit_tax = 0;
                                        $total_service_subtotal_online_tax = 0;
                                        $total_service_subtotal_total_tax = 0;
                                    @endphp
                                    @foreach($orders as $order)
                                        @php
                                            $net_total_test = 0;
                                            if (isset($order->TOTAL_AMOUNT_TEST)){
                                                $net_total_test = $order->TOTAL_AMOUNT_TEST;
                                            }
                                            $cod_total_test = 0;
                                            if (isset($order->COD_AMOUNT_TEST)){
                                                $cod_total_test = $order->COD_AMOUNT_TEST;
                                            }
                                            $credit_test = 0;
                                            if (isset($order->CREDIT_TEST)){
                                                $credit_test = $order->CREDIT_TEST;
                                            }
                                            $online_test = 0;
                                            if (isset($order->Online_amount_test)){
                                                $online_test = $order->Online_amount_test;
                                            }
                                            $service_subtotal_cod_tax_test = 0;
                                            $service_subtotal_credit_tax_test = 0;
                                            $service_subtotal_online_tax_test = 0;
                                            $service_subtotal_total_tax_test = 0;
                                            if (isset($order->service_subtotal_cod_tax_test)){
                                                $service_subtotal_cod_tax_test = $order->service_subtotal_cod_tax_test;
                                            }
                                            if (isset($order->service_subtotal_credit_tax_test)){
                                                $service_subtotal_credit_tax_test = $order->service_subtotal_credit_tax_test;
                                            }
                                            if (isset($order->service_subtotal_online_tax_test)){
                                                $service_subtotal_online_tax_test = $order->service_subtotal_online_tax_test;
                                            }
                                            if (isset($order->service_subtotal_total_tax_test)){
                                                $service_subtotal_total_tax_test = $order->service_subtotal_total_tax_test;
                                            }
                                            $total_service += 1;
                                            $total_test += $order->quantity ?? 0;
                                            $total_reservation += $order->total_reservations ?? 0;
                                            $total_patient_qty += $order->quantity ?? 0;
                                            $total_cod_qty += $order->cod_qty ?? 0;
                                            $total_cod_amount += $order->COD_AMOUNT + $cod_total_test ?? 0;
                                            $total_credit_qty += $order->credit_qty ?? 0;
                                            $total_credit_amount += $order->CREDIT + $credit_test ?? 0;
                                            $total_online_qty += $order->Online_qty ?? 0;
                                            $total_online_amount += $order->Online_amount + $online_test ?? 0;
                                            $total_amount += $order->TOTAL_AMOUNT + $net_total_test  ?? 0;
                                            $total_cost_price += $order->COST_PRICE ?? 0;
                                            $net_total = ($order->TOTAL_AMOUNT + $net_total_test) - ($order->service_subtotal_total_tax + $service_subtotal_total_tax_test);
                                            $cost_price = $order->COST_PRICE ?? 0;
                                            $pl = $net_total - $cost_price;
                                            $total_pl += $pl;
                                            $total_service_subtotal_cod_tax += ($order->service_subtotal_cod_tax + $service_subtotal_cod_tax_test) ?? 0;
                                            $total_service_subtotal_credit_tax += ($order->service_subtotal_credit_tax + $service_subtotal_credit_tax_test) ?? 0;
                                            $total_service_subtotal_online_tax += ($order->service_subtotal_online_tax + $service_subtotal_online_tax_test) ?? 0;
                                            $total_service_subtotal_total_tax += ($order->service_subtotal_total_tax + $service_subtotal_total_tax_test) ?? 0;
                                        @endphp
                                        <tr>
                                            <td>{{$order->NAME_EN ?? null}}</td>
                                            <td>{{$order->CODE ?? null}}</td>
                                            <td>{{$order->TAT ?? null}}</td>
                                            <td>{{$order->in_of_tat ?? null}}</td>
                                            <td>{{$order->out_of_tat ?? null}}</td>
                                            <td>{{$order->quantity ?? 0}}</td>
                                            <td>{{$order->total_reservations ?? 0}}</td>
                                            <td>{{$order->quantity ?? 0}}</td>
                                            <td>{{$net_total}}</td>
                                            <td>{{$cost_price}}</td>
                                            <td>{{$pl}}</td>
                                            <td>{{$order->cod_qty ?? 0}}</td>
                                            <td>{{($order->COD_AMOUNT + $cod_total_test) - ($order->service_subtotal_cod_tax + $service_subtotal_cod_tax_test) ?? 0}}</td>
                                            <td>{{$order->credit_qty ?? 0}}</td>
                                            <td>{{($order->CREDIT + $credit_test) - ($order->service_subtotal_credit_tax + $service_subtotal_credit_tax_test) ?? 0}}</td>
                                            <td>{{$order->Online_qty ?? 0}}</td>
                                            <td>{{($order->Online_amount + $online_test) - ($order->service_subtotal_online_tax + $service_subtotal_online_tax_test) ?? 0}}</td>
                                            <td>{{$user_selected ?? '--'}}</td>
                                        </tr>
                                    @endforeach
                                    </tbody>
                                    <tfoot>
                                    <th class="text-left">Service Name <br>{{$total_service}}</th>
                                    <th class="text-left"><br></th>
                                    <th class="text-left"><br></th>
                                    <th class="text-left"><br></th>
                                    <th class="text-left"><br></th>
                                    <th class="text-left">Test Qty <br> {{$total_test}}</th>
                                    <th class="text-left">Reservation Qty <br> {{$total_reservation}}</th>
                                    <th class="text-left">Patient Qty <br> {{$total_patient_qty}}</th>
                                    <th class="text-left">Net Total<br>{{$total_amount - $total_service_subtotal_total_tax}}</th>
                                    <th class="text-left">Cost Price<br>{{$total_cost_price}}</th>
                                    <th class="text-left">P&L<br>{{$total_pl}}</th>
                                    <th class="text-left">OPD Qty <br>{{$total_cod_qty}}</th>
                                    <th class="text-left">OPD Amount <br>{{$total_cod_amount - $total_service_subtotal_cod_tax}}</th>
                                    <th class="text-left">Credits Qty <br>{{$total_credit_qty}}</th>
                                    <th class="text-left">Credits Amount <br>{{$total_credit_amount - $total_service_subtotal_credit_tax}}</th>
                                    <th class="text-left">Online Qty <br> {{$total_online_qty}}</th>
                                    <th class="text-left">Online Amount<br>{{$total_online_amount - $total_service_subtotal_online_tax}}</th>
                                    <th></th>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>

@endsection

@section('footer-scripts')
    <script>
        $('#registration-date-from').daterangepicker({
            singleDatePicker: true,
            timePicker: true,
            timePicker24Hour: true,
            autoUpdateInput: false,
            locale: {
                format: 'YYYY-MM-DD HH:mm'
            },
        }, function(chosen_date) {
            $('#registration-date-from').val(chosen_date.format('YYYY-MM-DD HH:mm'));
        })
        $('#registration-date-from').on('apply.daterangepicker', function(ev, picker) {
            $(this).val(picker.startDate.format('YYYY-MM-DD HH:mm')).trigger("change");
        });
        $('#registration-date-to').daterangepicker({
            singleDatePicker: true,
            timePicker: true,
            timePicker24Hour: true,
            autoUpdateInput: false,
            locale: {
                format: 'YYYY-MM-DD HH:mm'
            },
        }, function(chosen_date) {
            $('#registration-date-to').val(chosen_date.format('YYYY-MM-DD HH:mm'));
        })
        $('#registration-date-to').on('apply.daterangepicker', function(ev, picker) {
            $(this).val(picker.startDate.format('YYYY-MM-DD HH:mm')).trigger("change");
        });
    </script>
@endsection