@extends('operations.layout.mainlayout')

@section('content')
{{--    @if(session('role') != 4 &&  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;">Rejection 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">
                        <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>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>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>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">Rejected</option>
                                                        <option @if(!empty($status) && $status == -2) selected @endif value="-2">Refunded</option>
                                                    </select>
                                                </div>
                                                <div class="col-md-4 mt-3">
                                                    <span class="text-muted text-sm"><b>Process Branch</b></span>
                                                    <select multiple="multiple" class="form-control rhospital_id" name="hospital[]" @if(!empty(session('role')) && session('role') == 12) required @endif>
                                                        <option value="">Select Process Branch</option>
                                                        @foreach($hospitals as $ehospital)
                                                            <option @if(!empty($hospital)) @if(in_array($ehospital->ID,$hospital)) selected @endif @endif value="{{$ehospital->ID}}">{{$ehospital->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-4 mt-3">
                                                    <span class="text-muted text-sm"><b>Test</b></span>
                                                    <select multiple="multiple" class="form-control" id="sales-category-id" name="package_id[]">
                                                        <option value="">Select Test </option>
                                                        @foreach($packages as $package)
                                                            <option @if(!empty($package_id)) @if(in_array($package->ID , $package_id)) selected @endif @endif value="{{$package->ID}}">{{$package->NAME_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                                <div class="col-md-4 mt-3">
                                                    <span class="text-muted text-sm"><b>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>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 mt-3">
                                                    <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>Process 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>
                                    </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="row">
                        <div class="col-md-6">
                            <div class="card">
                                <div class="card-header">
                                    <h3 class="card-title">Rejection Percentage Chart</h3>

                                    <div class="card-tools">
                                        <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
                                        </button>
                                        <button type="button" class="btn btn-tool" data-card-widget="remove"><i class="fas fa-times"></i>
                                        </button>
                                    </div>
                                </div>
                                <!-- /.card-header -->
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-12">
                                            <div class="chart-responsive">
                                                <div id="apex-pie-chart"></div>
                                            </div>
                                            <!-- ./chart-responsive -->
                                        </div>
                                    </div>
                                    <!-- /.row -->
                                </div>
                                <!-- /.card-body -->
                                <div class="card-footer bg-white p-0">

                                </div>
                                <!-- /.footer -->
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="card">
                                <div class="card-header">
                                    <h3 class="card-title">Rejection Quantity Chart</h3>

                                    <div class="card-tools">
                                        <button type="button" class="btn btn-tool" data-card-widget="collapse"><i class="fas fa-minus"></i>
                                        </button>
                                        <button type="button" class="btn btn-tool" data-card-widget="remove"><i class="fas fa-times"></i>
                                        </button>
                                    </div>
                                </div>
                                <!-- /.card-header -->
                                <div class="card-body">
                                    <div class="row">
                                        <div class="col-md-12">
                                            <div class="chart-responsive">
                                                <div id="apex-pie-chart2"></div>
                                            </div>
                                            <!-- ./chart-responsive -->
                                        </div>
                                    </div>
                                    <!-- /.row -->
                                </div>
                                <!-- /.card-body -->
                                <div class="card-footer bg-white p-0">

                                </div>
                                <!-- /.footer -->
                            </div>
                        </div>

                    </div>



                    <div class="card">

                        <!-- /.card-header -->
                        <div class="card-body">

                            <table id="payment-table" class="table table-bordered table-striped">
                                <thead>
                                <tr>
                                    <th>Rejection Type</th>
                                    <th>Total Tests</th>
                                    <th>Ready Tests</th>
                                    <th>Rejected Tests</th>
                                    <th>% of Rejected Tests</th>
                                </tr>
                                </thead>
                                <tbody>
                                @foreach($orders as $order)
                                        <tr>
                                            <td>{{$order->NAME_EN}}</td>
                                            <td>{{$order->TOTAL_QTY + $total_ready}}</td>
                                            <td>{{$total_ready}}</td>
                                            <td>{{$order->TOTAL_QTY}}</td>
                                            <td>
                                                @if($order->TOTAL_QTY)
                                                    @php($percentage_reject = number_format(($order->TOTAL_QTY / ($order->TOTAL_QTY + $total_ready)) * 100,2))
                                                    {{substr($percentage_reject, -3) === '.00' ? substr($percentage_reject, 0, -3) : $percentage_reject }} %
                                                @else
                                                    0
                                                @endif
                                            </td>
                                        </tr>
                                @endforeach
                                </tbody>
                                <tfoot>
                                <th>Totals</th>
                                <th>{{$total_qty ? ($total_qty + $total_ready) : 0}}</th>
                                <th>{{$total_qty ? $total_ready : 0}}</th>
                                <th>{{$total_qty}}</th>
                                <th> @if($total_qty)
                                        @php($percentage_total = number_format(($total_qty / ($total_qty + $total_ready)) * 100,2))
                                        {{substr($percentage_total, -3) === '.00' ? substr($percentage_total, 0, -3) : $percentage_total }} %
                                    @else
                                        0
                                    @endif</th>
                                </tfoot>
                            </table>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
                <!-- /.col -->
            </div>
            <!-- /.row -->
        </div>
        <!-- /.container-fluid -->
    </section>
    <!-- /.content -->
</div>
<!-- /.content-wrapper -->

@endsection
<script src="/warehouse_components/js/apexcharts.min.js"></script>
@section('footer-scripts')
    <script>
        $('#sales-category-id').select2();
        var labels = @json($labels);

        var colors = {
            primary: "#6571ff",
            secondary: "#7987a1",
            success: "#05a34a",
            info: "#66d1d1",
            warning: "#fbbc06",
            danger: "#ff3366",
            theme: "var(--blazma-primary)",
            light: "#e9ecef",
            dark: "#060c17",
            muted: "#7987a1",
            gridBorder: "rgba(77, 138, 240, .15)",
            bodyColor: "#000",
            cardBg: "#fff"
        }

        var options = {
            chart: {
                width: 580,
                type: "donut"
            },
            legend: {
                show: true,
                position: "right",
                horizontalAlign: 'center',
                fontSize: '14px',
                itemMargin: {
                    horizontal: 8,
                    vertical: 4
                },
            },
            colors: [colors.theme, colors.info, colors.primary, colors.warning, colors.danger,  colors.cardBg, colors.success, colors.dark],
            dataLabels: {
                enabled: true
            },
            series: @json($quantities),
            labels: labels,

        };

        var chart = new ApexCharts(document.querySelector("#apex-pie-chart"), options);
        chart.render();

        var options2 = {
            chart: {
                width: 580,
                type: "donut"
            },
            legend: {
                show: true,
                position: "right",
                horizontalAlign: 'center',
                fontSize: '14px',
                itemMargin: {
                    horizontal: 8,
                    vertical: 4
                },
            },
            colors: [colors.theme, colors.info, colors.primary, colors.warning, colors.danger, colors.cardBg, colors.success, colors.dark],
            dataLabels: {
                formatter: function (val, opts) {
                    return opts.w.config.series[opts.seriesIndex]
                },
            },
            series: @json($quantities),
            labels: labels,
        };

        var chart2 = new ApexCharts(document.querySelector("#apex-pie-chart2"), options2);
        chart2.render();
    </script>
@endsection