@extends('operations.layout.mainlayout')

@section('content')
<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;">Turn Around Time - Unit</h1>
                </div>
                <div class="col-sm-6">

                </div>
            </div>
        </div>
    </div>

    <section class="content">
        <div class="container-fluid" id="time-table-div">
            <div class="row">
                <div class="col-12">
                    <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>Result Date from</b></span>
                                                    {{--<input id="treport-date-from" class="form-control" type="date" name="date_from" value="@if(!empty($date_from)){{$date_from}}@endif" placeholder="Date From">--}}
                                                    <input autocomplete="off" id="treport-date-from" class="form-control date-from-invoice" type="text" 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>Result Date to</b></span>
                                                    {{--<input id="treport-date-to" class="form-control" type="date" name="date_to" value="@if(!empty($date_to)){{$date_to}}@endif" placeholder="Date To"></div>--}}
                                                    <input autocomplete="off" id="treport-date-to" class="form-control date-to-invoice" type="text" 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 multi" id="treport-status-id" name="status[]" multiple="multiple">
                                                        @foreach($statuses as $status)
                                                            <option value="{{$status->LAB_ORDER_STATUS_ID}}">{{$status->DESC_EN}}</option>
                                                        @endforeach
                                                    </select>
                                                </div>
                                            </div>
                                                <div class="row">
                                                    <div class="col-md-4">
                                                        <span class="text-muted text-sm"><b>Registration Branch</b></span>
                                                        <select class="form-control rhospital_id" id="treport-hospital-id" name="hospital">
                                                            <option value="">Select Registration Branch</option>
                                                            @foreach($hospitals as $ehospital)
                                                                <option @if(!empty($hospital) && $hospital == $ehospital->ID) selected @endif value="{{$ehospital->ID}}">{{$ehospital->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </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($all_processing_branches as $branch)
                                                                <option  value="{{$branch->ID}}" {{--@if(!empty($all_processing_branches)) @if(in_array($branch->ID,$all_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>Unit</b></span>
                                                        <select class="form-control" id="tat-unit-id" >
                                                            <option value="">Select Unit</option>
                                                            @foreach($units as $unit)
                                                                <option value="{{$unit->ID}}">{{$unit->NAME_EN}}</option>
                                                            @endforeach
                                                        </select>
                                                    </div>
                                                </div>
                                            </div>

                                        </div>
                                    </div>
                                <div class="card-footer">
                                    <div class="text-right">
                                        <input type="checkbox" name="only_urgent" value="only_urgent" id="only-urgent">
                                        <label for="only-urgent" style="margin-right: 10px;font-weight: 300;"> Only Urgent</label>

                                        <input type="checkbox" name="exceed_tat" value="exceed_tat" id="exceed-tat">
                                        <label for="exceed-tat" style="margin-right: 10px;font-weight: 300;"> Exceed tat</label>

                                        <input type="checkbox" name="only_reset" value="reset" id="only-reset">
                                        <label for="only-reset" style="margin-right: 10px;font-weight: 300;"> Only Reset</label>

                                    </div>
                                    <div class="text-right">

                                    </div>

                                </div>

                            </form>
                        </div>

                    <div class="card">
                    <div class="card-body">
                        <div class="card">
                            <div class="card-body">
                                <table id="tat-unit-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>Processing Unit</th>
                                        <th>Total Registered Services</th>
                                        <th>Total Delayed Services</th>
                                        <th>Average Delay Time in Hours</th>
                                        <th>Delay Time Percentage (from Setup Time)</th>
                                        <th>Total Delay Per Service Percentage</th>
                                    </tr>
                                    </thead>
                                    <tbody></tbody>
                                    <tfoot>
                                    <tr>
                                        <th>Total</th>
                                        <th id="total-registered-services"></th>
                                        <th id="total-delayed-services"></th>
                                        <th id="avg-delay-time"></th>
                                        <th id="avg-delay-time-percentage"></th>
                                        <th id="total-delay-percentage"></th>
                                    </tr>
                                    </tfoot>
                                </table>
                            </div>
                        </div>
                </div>
                </div>
                </div>

            </div>

        </div>

        </div>
    </section>
</div>


@endsection

@section('footer-scripts')
    <script>
        var table = $('#tat-unit-table').DataTable({
            processing: true,
            serverSide: true,
            dom: 'lBfrtip',
            buttons: [
                'copy', {
                    extend: 'excel',
                    text: 'Excel',
                    title: 'TAT Unit Report',
                    filename: 'TatUnitReport',
                    exportOptions: {
                        format: {
                            body: function ( data, row, column, node ) {
                                return node.textContent || node.innerText;
                            }
                        }
                    },
                    customize: function(xlsx) {
                        var sheet = xlsx.xl.worksheets['sheet1.xml'];
                        $('row c', sheet).each(function() {
                            var cell = $(this);
                            var text = cell.text();
                            var parentRow = cell.parent();
                            var tableRow = $('#tat-unit-table').DataTable().row(parentRow.index() - 1).nodes().to$().children();
                            if (tableRow.length > cell.index()) {
                                var tableCell = $(tableRow[cell.index()]);
                                if (tableCell.css('color') === 'rgb(255, 133, 133)') {
                                    cell.attr('s', '2');
                                } else if (tableCell.css('color') === 'rgb(53, 177, 0)') {
                                    cell.attr('s', '3');
                                }
                            }
                        });
                    }
                }, {
                    extend: 'csv',
                    charset: 'UTF-8',
                    bom: true,
                    filename: 'TatUnitReport',
                    title: 'TatUnitReport'
                }, 'pdf', {
                    extend: 'print',
                    text: 'Print',
                    autoPrint: false,
                    title: 'TAT Unit Report'
                }
            ],
            responsive: true,
            ajax: {
                url: '/operations/data/tat-unit-report',
                data: function (d) {
                    d.date_from = $('#treport-date-from').val(),
                        d.date_to = $('#treport-date-to').val(),
                        d.hospital_id = $('#treport-hospital-id').val(),
                        d.processing_hospital_id = $('#p-sample-processing-branch').val(),
                        d.status_id = $('#treport-status-id').val(),
                        d.category_id = $('#treport-category-id').val(),
                        d.tat_unit_id = $('#tat-unit-id').val(),
                        d.only_reset = $('#only-reset').is(':checked'),
                        d.exceed_tat = $('#exceed-tat').is(':checked'),
                        d.only_urgent = $('#only-urgent').is(':checked'),
                        d.identification = $('#treport-identification').val(),
                        d.mobile = $('#treport-mobile').val(),
                        d.name = $('#treport-name').val()
                }
            },
            columns: [
                {
                    data: 'processing_unit',
                    name: 'processing_unit',
                    render: function (data, type, row, meta) {
                        var tatUnitId = $('#tat-unit-id').val();
                        if (!tatUnitId) {
                            tatUnitId = row['UNIT_ID'];
                        }

                        var url = '/operations/tat-test-report?' +
                            'date_from=' + encodeURIComponent($('#treport-date-from').val()) +
                            '&date_to=' + encodeURIComponent($('#treport-date-to').val()) +
                            '&hospital_id=' + encodeURIComponent($('#p-sample-processing-branch').val()) +
                            '&status_id=' + encodeURIComponent($('#treport-status-id').val()) +
                            '&category_id=' + encodeURIComponent($('#treport-category-id').val()) +
                            '&tat_unit_id=' + encodeURIComponent(tatUnitId) +
                            '&only_reset=' + ($('#only-reset').is(':checked') ? 'true' : 'false') +
                            '&exceed_tat=' + ($('#exceed-tat').is(':checked') ? 'true' : 'false') +
                            '&only_urgent=' + ($('#only-urgent').is(':checked') ? 'true' : 'false') +
                            '&identification=' + encodeURIComponent($('#treport-identification').val()) +
                            '&mobile=' + encodeURIComponent($('#treport-mobile').val()) +
                            '&name=' + encodeURIComponent($('#treport-name').val());

                        return '<a target="_blank" href="' + url + '">' + data + '</a>';

                        /*var url = '/operations/tat-test-report?date_from=' + encodeURIComponent($('#treport-date-from').val()) +
                            '&hospital_id=' + encodeURIComponent($('#treport-hospital-id').val()) +
                            '&date_to=' + encodeURIComponent($('#treport-date-to').val());
                        return '<a target="_blank" href="' + url + '">' + data + '</a>';*/
                    }
                },
                { data: 'total_registered_services', name: 'total_registered_services' },
                { data: 'total_delayed_services', name: 'total_delayed_services' },
                { data: 'avg_delay_time_formatted', name: 'avg_delay_time' },
                { data: 'delay_time_percentage', name: 'delay_time_percentage' },
                { data: 'total_delay_percentage', name: 'total_delay_percentage' }
            ],
            footerCallback: function (row, data, start, end, display) {
                var api = this.api();
                var json = api.ajax.json();

                var totalRegisteredServices = json.grand_total_registered || 0;
                var totalDelayedServices = json.grand_total_delayed || 0;
                var avgDelayTime = json.grand_avg_delay_time || 0;
                var avgDelayTimePercentage = json.grand_delay_time_percentage || 0;
                var totalDelayPercentage = json.grand_total_delay_percentage || 0;

                $('#total-registered-services').text(totalRegisteredServices);
                $('#total-delayed-services').text(totalDelayedServices);
                $('#avg-delay-time').text(isNaN(avgDelayTime) ? '00:00' : (Math.floor(avgDelayTime / 60)).toString().padStart(2, '0') + ':' + (Math.floor(avgDelayTime % 60)).toString().padStart(2, '0'));
                $('#avg-delay-time-percentage').text(isNaN(avgDelayTimePercentage) ? '0.00%' : avgDelayTimePercentage.toFixed(2) + '%');
                $('#total-delay-percentage').text(isNaN(totalDelayPercentage) ? '0.00%' : totalDelayPercentage.toFixed(2) + '%');
            }
        });

        function renderZeroIfEmpty(data, type, row) {
            return data ? data : 0;
        }

        $("#treport-date-from,#tat-unit-id,#treport-status-id, #treport-date-to, #p-sample-processing-branch, #treport-hospital-id, #supervisor-id, #only-reset, #exceed-tat, #only-urgent, #tat-unit-id, #treport-category-id, #treport-identification, #treport-mobile, #treport-name").change(function () {
            table.draw();
        });
    </script>
@endsection