@extends('operations.layout.mainlayout')

@section('content')
{{--    @if(session('role') != 4 && session('role') != 5 && session('role') != 8)--}}
{{--        {{exit("<h1>Unauthorized access</h1>")}}--}}
{{--    @endif--}}
<!-- Content Wrapper. Contains page content -->
<style>
    #critical-report-table th {
        white-space: nowrap;
    }
    .select2-container--default .select2-selection--multiple .select2-selection__choice {
        color: #020202;
    }
</style>
<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;">Audit Trail 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>Updating Date From</b></span>
                                                    <input id="updated-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>Updating Date to</b></span>
                                                    <input id="updated-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>Updated Type</b></span>
                                                    <select class="form-control rhospital_id" id="update-report-type" name="updated_type">
                                                        <option value="">Select Updated Type</option>
                                                        @foreach($updateTypes as $type)
                                                            <option value="{{$type}}" @if(!empty($type)) @if($type == $updated_type) selected @endif @endif>{{$type}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>

                                            </div>

                                            <div class="row mt-3">
                                                <div class="col-md-4">
                                                    <span class="text-muted text-sm"><b>Registered Branch</b></span>
                                                    <select multiple="multiple" name="registration_branch[]" class="form-control rhospital_id" id="p-registration-branch">
                                                        <option value="">Select Registered 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>Client Name</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 class="col-md-4 mt-3">
                                                    <span class="text-muted text-sm"><b>Corrected User</b></span>
                                                    <select multiple="multiple" name="user_id[]"  class="form-control rhospital_id" id="p-sample-users-ids">
                                                        <option value="">Select User</option>
                                                        @foreach($users as $user)
                                                            <option value="{{$user->ID}}"   @if(!empty($user_ids)) @if(in_array($user->ID,$user_ids)) selected @endif @endif >{{$user->USERNAME}}</option>
                                                        @endforeach
                                                    </select><br/>
                                                </div>
                                                <div class="col-md-4 mt-3">
                                                    <span class="text-muted text-sm"><b>Processing Unit</b></span>
                                                    <select multiple="multiple" class="form-control rhospital_id" name="unit_id[]" id="p-sample-unit-id">
                                                        <option value="">Select Processing 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 class="col-md-4 mt-3">
                                                    <span class="text-muted text-sm"><b>Status</b></span>
                                                    <select class="form-control rhospital_id" id="update-report-status-id" name="status_id">
                                                        <option value="">Select Status</option>
                                                        @foreach($statuses as $status)
                                                            <option value="{{$status->LAB_ORDER_STATUS_ID}}" @if(!empty($status_id)) @if($status_id == $status->LAB_ORDER_STATUS_ID) selected @endif @endif >{{$status->DESC_EN}}</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">

                        <!-- /.card-header -->
                        <div class="card-body">
                            <table id="user-update-report-table2" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>Reservation ID</th>
                                    <th>Sample ID</th>
                                    <th>Patient Name</th>
                                    <th>Test Name</th>
                                    <th>Registration Branch</th>
                                    <th>Client</th>
                                    <th>Processing Branch</th>
                                    <th>Processing Unit</th>
                                    <th>Status</th>
                                    <th>Update Type</th>
                                    <th>Before Update</th>
                                    <th>After Update</th>
                                    <th>Corrected User</th>
                                    <th>Updating Date & Time</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                    <tr>
                                        <td>{{$order->reservation_id}}</td>
                                        <td>
                                            @if(in_array('view_samples_details', session('permissions', []) ?? array()))
                                                <a target="_blank" href="/operations/samples/{{$order->TEST_ID}}">{{$order->TEST_ID}}</a>
                                            @else
                                                {{$order->TEST_ID}}
                                            @endif
                                        </td>
                                        <td>{{$order->NAME ?? null}}</td>
                                        <td>{{$order->NAME_EN ?? null}}</td>
                                        <td>{{$order->HOSPITAL_NAME ?? null}}</td>
                                        <td>{{$order->client_name ?? null}}</td>
                                        <td>{{$order->process_branch ?? null}}</td>
                                        <td>{{$order->processing_unit ?? null}}</td>
                                        <td>{{$order->DESC_EN ?? null}}</td>
                                        <td>{{$order->UPDATED_COLUMN ?? null}}</td>
                                        <td>
                                            @if(($order->TEST_CATEGORY == null || $order->TEST_CATEGORY == 5) && $order->UPDATED_COLUMN == 'Result')
                                                @if($order->PREUPDATE == 1)
                                                    Negative
                                                @elseif($order->PREUPDATE == 2) {
                                                    Positive
                                                @endif
                                            @else
                                                {{$order->PREUPDATE}}
                                            @endif
                                        </td>
                                        <td>
                                            @if(($order->TEST_CATEGORY == null || $order->TEST_CATEGORY == 5) && $order->UPDATED_COLUMN == 'Result')
                                                @if($order->POSTUPDATE == 1)
                                                    Negative
                                                @elseif($order->POSTUPDATE == 2) {
                                                Positive
                                                @endif
                                            @else
                                                {{$order->POSTUPDATE}}
                                            @endif
                                        </td>
                                        <td>{{$order->SYSTEM_USER_NAME ?? null}}</td>
                                        <td>{{$order->UPDATE_TIME ?? null}}</td>
                                    </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th>{{$total->total_reservation ?? 0}}</th>
                                <th>{{$total->total_sample ?? 0}}</th>
                                <th>{{$total->total_patient ?? 0}}</th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                <th></th>
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->


@endsection

@section('footer-scripts')
    <script>

        var resultAnalysisDataTable = $("#user-update-report-table2").DataTable({
            dom: 'lBfrtip',
            "searching": false,
            "buttons" : [
                'copy', {
                    extend: 'csv',
                    charset: 'UTF-8',
                    bom: true,
                    footer: true,
                    filename: 'UserUpdateReport',
                    title: 'User Update 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, "desc" ]],
            "paging": true,
        });
    </script>
@endsection