@extends('operations.layout.mainlayout')

@section('content')
    <style>
        #critical-report-table th {
            white-space: nowrap;
        }
        .select2-container--default .select2-selection--multiple .select2-selection__choice {
            color: #020202;
        }
    </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: var(--blazma-text)!important;">Result Analysis 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">
                            <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>Result Date from</b></span>
                                                        <input required name="date_from" type="text"
                                                               class="form-control" id="r-sample-date-from"
                                                               value="@if(!empty($date_from)){{$date_from}} @else{{date('Y-m-01 00:00')}}@endif"/>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Result Date to</b></span>
                                                        <input required id="r-sample-date-to" class="form-control"
                                                               type="text" name="date_to"
                                                               value="@if(!empty($date_to)){{$date_to}}@else{{date('Y-m-t 23:59')}}@endif">
                                                    </div>
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Unit</b></span>
                                                        <select multiple="multiple" class="form-control rhospital_id" name="unit_id[]" id="p-sample-unit-id">
                                                            <option value="">Select Unit</option>
                                                            @foreach($units as $unit)
                                                                <option  value="{{$unit->ID}}" @if(!empty($unit_ids)) @if(in_array($unit->ID,$unit_ids)) selected @endif @endif>{{$unit->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                                <div class="row mt-3">
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Registration Branch</b></span>
                                                        <select multiple="multiple" name="registration_branch[]" class="form-control rhospital_id" id="p-registration-branch">
                                                            <option value="">Select Registration Branch</option>
                                                            @foreach($registration_branches as $branch)
                                                                <option  value="{{$branch->ID}}"  @if(!empty($registration_branche_ids)) @if(in_array($branch->ID,$registration_branche_ids)) selected @endif @endif >{{$branch->NAME_EN}}</option>
                                                            @endforeach
                                                        </select><br/>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Processing Branch</b></span>
                                                        <select multiple="multiple" class="form-control rhospital_id" name="processing_branch[]" id="p-sample-processing-branch">
                                                            <option value="">Select Processing Branch</option>
                                                            @foreach($hospitals as $branch)
                                                                <option  value="{{$branch->ID}}"   @if(!empty($processing_branches)) @if(in_array($branch->ID,$processing_branches)) selected @endif @endif >{{$branch->NAME_EN}}</option>
                                                            @endforeach
                                                        </select><br/>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Tests</b></span>
                                                        <select multiple="multiple"  name="test_id[]" class="form-control rhospital_id" id="p-sample-test-ids">
                                                            <option value="">Select Tests</option>
                                                            @foreach($packages as $package)
                                                                <option value="{{$package->ID}}"  @if(!empty($test_ids)) @if(in_array($package->ID,$test_ids)) selected @endif @endif >{{$package->NAME_EN}}</option>
                                                            @endforeach
                                                        </select><br/>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Clients</b></span>
                                                        <select multiple="multiple" name="client_id[]"  class="form-control rhospital_id" id="p-sample-client-ids">
                                                            <option value="">Select Tests</option>
                                                            @foreach($companies as $company)
                                                                <option value="{{$company->ID}}"   @if(!empty($client_ids)) @if(in_array($company->ID,$client_ids)) selected @endif @endif >{{$company->COMPANY_NAME}}{{!empty($company->CLIENT_CODE)?' ('.$company->CLIENT_CODE.')':''}}</option>
                                                            @endforeach
                                                        </select><br/>
                                                    </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">
                            <!-- /.card-header -->
                            <div class="card-body">

                                <table id="result-analysis-report-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>Registration Branch</th>
                                        <th>Number of Results</th>
                                        <th>Number of Normal Results</th>
                                        <th>% of Normal Results</th>
                                        <th>Number of Abnormal Results</th>
                                        <th>% of Abnormal Results</th>
                                        <th>Number of Critical Results</th>
                                        <th>% of Critical Results</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($orders as $order)
                                    <tr>

                                        <td>{{$order->registration_name ?? ''}}</td>
                                        <td>{{$order->total_result ?? 0}}</td>
                                        <td>{{$order->normal_result ?? 0}}</td>
                                        <td>@if($order->normal_result && $order->total_result)
                                                @php($normal_result = number_format(($order->normal_result / $order->total_result) * 100,2))
                                                {{substr($normal_result, -3) === '.00' ? substr($normal_result, 0, -3) : $normal_result }} %
                                            @else
                                                0
                                            @endif
                                        </td>
                                        <td>{{$order->abnormal_result ?? 0}}</td>
                                        <td>@if($order->abnormal_result && $order->total_result)
                                            @php($abnormal_per = number_format(($order->abnormal_result / $order->total_result) * 100,2))
                                              {{substr($abnormal_per, -3) === '.00' ? substr($abnormal_per, 0, -3) : $abnormal_per }} %
                                            @else
                                                0
                                            @endif
                                        </td>
                                        <td>{{$order->critical_result ?? 0}}</td>
                                        <td>@if($order->critical_result && $order->total_result)
                                                @php($critical_result = number_format(($order->critical_result / $order->total_result) * 100,2))
                                                {{substr($critical_result, -3) === '.00' ? substr($critical_result, 0, -3) : $critical_result }} %
                                            @else
                                                0
                                            @endif
                                        </td>
                                    </tr>
                                    @endforeach
                                    </tbody>
                                </table>
                            </div>
                            <!-- /.card-body -->
                        </div>
                        <!-- /.card -->
                    </div>
                    <!-- /.col -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container-fluid -->
        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->

@endsection

@section('footer-scripts')
    <script>
        $('#r-sample-date-from').daterangepicker({
            singleDatePicker: true,
            timePicker: true,
            timePicker24Hour: true,
            locale: {
                format: 'YYYY-MM-DD HH:mm'
            },
        })

        $('#r-sample-date-to').daterangepicker({
            singleDatePicker: true,
            timePicker: true,
            timePicker24Hour: true,
            locale: {
                format: 'YYYY-MM-DD HH:mm'
            },
        })
        var resultAnalysisDataTable = $("#result-analysis-report-table").DataTable({
            dom: 'lBfrtip',
            "searching": false,
            "buttons" : [
                'copy', {
                    extend: 'csv',
                    charset: 'UTF-8',
                    bom: true,
                    footer: true,
                    filename: 'ResultAnalysisReport',
                    title: 'Result Analysis Report'
                }, 'excel', 'pdf', 'print'
            ],
            "lengthMenu": [[10, 25, 50, 100, 500,1000,5000,10000,100000], [10, 25, 50, 100, 500, 1000,5000,10000,100000]],
            "responsive": true,
            "autoWidth": false,
            "order": [[ 0, "asc" ]],
            "paging": true,
        });


        /*$("#r-sample-date-from").change(function(){
            resultAnalysisDataTable.draw();
        });
        $("#r-sample-date-to").change(function(){
            resultAnalysisDataTable.draw();
        });
        $("#p-registration-branch").change(function(){
            resultAnalysisDataTable.draw();
        });
        $("#p-sample-processing-branch").change(function(){
            resultAnalysisDataTable.draw();
        });

        $("#p-sample-unit-id").change(function(){
            resultAnalysisDataTable.draw();
        });
        $("#p-sample-client-ids").change(function(){
            resultAnalysisDataTable.draw();
        });
        $("#p-sample-test-ids").change(function(){
            resultAnalysisDataTable.draw();
        });*/

    </script>
@endsection