@extends('app-new')
@push('head-script')
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/dataTables.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/tables/datatable/responsive.bootstrap5.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/components.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/vendors.min.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/vendors/css/extensions/toastr.min.css">
    
    <!-- BEGIN: Page CSS-->
    <link rel="stylesheet" type="text/css" href="/app-assets/css/core/menu/menu-types/vertical-menu.css">
    <link rel="stylesheet" type="text/css" href="/app-assets/css/plugins/forms/pickers/form-flat-pickr.css">
    <!-- END: Page CSS-->
@endpush 

@push('content-header')
    <div class="row breadcrumbs-top">
        <div class="col-12">
            <h2 class="content-header-title float-start mb-0">MIS Roll Report</h2>
            <div class="breadcrumb-wrapper">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="home">{{trans('master/master.home')}}</a>
                    </li>
                    <li class="breadcrumb-item active">MIS Report
                    </li>
                </ol>
            </div>
        </div>
    </div>
@endpush
@section('content')
    <!-- Column Search -->
    <section id="column-search-datatable">
        <div class="row">
            <div class="col-12">
                <div class="card">
                    <div class="card-header border-bottom">
                        <div class="head-label">
                            <h6 class="mb-0">MIS Roll Report</h6>
                        </div>
                        <div class="dt-action-buttons text-end">
                            <form method="GET" action="{{ route('mis-roll-report', $alias) }}">
                                <div class="d-flex align-items-center gap-1">
                                    <input type="date"
                                        name="from_date"
                                        class="form-control"
                                        value="{{ request('from_date') }}"
                                        style="width:180px;">
                                    <input type="date"
                                        name="to_date"
                                        class="form-control"
                                        value="{{ request('to_date') }}"
                                        style="width:180px;">
                                    <button type="submit" class="btn btn-primary">
                                        Filter
                                    </button>
                                    <a href="{{ route('mis-roll-report', ['alias' => $alias]) }}"
                                        class="btn btn-outline-secondary">
                                        Reset
                                    </a>
                                    <div class="dropdown">
                                        <button
                                            class="btn btn-secondary dropdown-toggle"
                                            type="button"
                                            data-bs-toggle="dropdown">
                                            Export
                                        </button>
                                        <div class="dropdown-menu">
                                            <a class="dropdown-item"
                                                target="_blank"
                                                href="{{ route('mis-roll-report', [
                                                    'alias' => $alias,
                                                    'export' => 1,
                                                    'from_date' => request('from_date'),
                                                    'to_date' => request('to_date')
                                                ]) }}">
                                                Excel
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div> 
                    <div class="card-body">
                        <div class="table-responsive">
                            <table class="table table-bordered table-striped mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th rowspan="2" class="align-middle">Location</th>
                                        <th colspan="2" class="text-center">O & M</th>
                                        <th colspan="2" class="text-center">Security</th>
                                        <th rowspan="2" class="align-middle text-center">Total Active Employees</th>
                                        <th rowspan="2" class="align-middle text-center">Total Present Employees</th>
                                    </tr>
                                    <tr>
                                        <th class="text-center">Active Employees</th>
                                        <th class="text-center">Present Employees</th>
                                        <th class="text-center">Active Employees</th>
                                        <th class="text-center">Present Employees</th>
                                    </tr>
                                </thead>

                                <tbody>
                                    @forelse($reportQuery as $row)
                                        <tr>
                                            <td>{{ $row->location_name }}</td>
                                            <td class="text-center">{{ $row->onm_active }}</td>
                                            <td class="text-center">{{ $row->onm_present }}</td>
                                            <td class="text-center">{{ $row->security_active }}</td>
                                            <td class="text-center">{{ $row->security_present }}</td>
                                            <td class="text-center">{{ $row->total_active }}</td>
                                            <td class="text-center">{{ $row->total_present }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="7" class="text-center">
                                                No records found.
                                            </td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>

                        @if($reportQuery->count())
                            <div class="d-flex justify-content-between align-items-center mt-3">
                                <div>
                                    Showing {{ $reportQuery->firstItem() }} to {{ $reportQuery->lastItem() }}
                                    of {{ $reportQuery->total() }} records
                                </div>

                                <div>
                                    {{ $reportQuery->appends(request()->query())->links('pagination::bootstrap-4') }}
                                </div>
                            </div>
                        @endif
                    </div>
                </div>
            </div>
        </div>
    </section>
    <!--/ Column Search -->
@endsection 
@push('footer-script') 
    <!-- BEGIN: Page Vendor JS-->
    <script src="/app-assets/vendors/js/tables/datatable/jquery.dataTables.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.bootstrap5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.responsive.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/responsive.bootstrap5.js"></script>
    <script src="/app-assets/vendors/js/pickers/flatpickr/flatpickr.min.js"></script>
    <script src="/app-assets/js/scripts/ui/ui-feather.js"></script>

    <script src="/app-assets/vendors/js/tables/datatable/datatables.checkboxes.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/datatables.buttons.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/jszip.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/pdfmake.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/vfs_fonts.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.html5.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/buttons.print.min.js"></script>
    <script src="/app-assets/vendors/js/tables/datatable/dataTables.rowGroup.min.js"></script>
    <!-- END: Page Vendor JS-->
    <script src="/app-assets/vendors/js/extensions/toastr.min.js"></script>


    <!-- BEGIN: Page JS-->
    <script src="/app-assets/js/scripts/tables/table-datatables-basic.js"></script>
    <script src="/app-assets/js/scripts/tables/table-datatables-advanced.js"></script>
    <!-- END: Page JS-->
    <script>
        $(window).on('load', function() {
            if (feather) {
                feather.replace({
                    width: 14,
                    height: 14
                });
            }
        });
    </script>
@endpush