@extends('backend.layouts.app')
<style>
    table thead tr th{
        font-size:11px;
    }
</style>
<link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0/css/bootstrap.css" rel="stylesheet">
<link href="https://cdn.datatables.net/1.10.16/css/dataTables.bootstrap4.min.css" rel="stylesheet">
<script src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<script>
    $('document').ready(function(){
        var table = $('#example').DataTable({
            "bLengthChange": false,
            "ordering":true,
            columnDefs: [
                { width: 200, targets: 2 },
                { width: 200, targets: 3 },
            ],
            fixedColumns: false,
            // initComplete: function () {
            //     this.api().columns([1,2]).every( function () {
            //         var column = this;
            //         var select = $('<select class="form-control select2" style="width: 100%;"><option value="">Search</option></select>')
            //             .appendTo( $(column.header()).empty() )
            //             .on( 'change', function () {
            //                 var val = $.fn.dataTable.util.escapeRegex(
            //                     $(this).val()
            //                 );
    
            //                 column
            //                     .search( val ? '^'+val+'$' : '', true, false )
            //                     .draw();
            //             } );
    
            //         column.data().unique().sort().each( function ( d, j ) {
            //             select.append( '<option value="'+d+'">'+d+'</option>' )
            //         } );
            //     } );
            // }
        });
        $('.select2').select2();
    });
</script>

@section('content')

<div class="col-xl-12">
	<div class="breadcrumb-holder">
		<h5 style="text-align: center">
        Monthly Summary of Collection
        </h5>
		    <a href="{{route('swimming-pool')}}"class="btn btn-success" style="color: #000000; border: 1px solid #eee; margin: 0px auto;">
                <i class="fa fa-home" aria-hidden="true" style="font-size: 20px; "></i>
                {{-- <img src="{{ url('public/backend/images/icons/admission.png') }}" style="width: 20px"> --}}
                    Swimming Dashboard
            </a>
		<ol class="breadcrumb float-right">
		</ol>
		<div class="clearfix"></div>
	</div>
</div>
<div class="container-fluid">
	<div class="col-md-12">
		<div style="text-align: right; margin-bottom: 20px;">

        </div>
        <div class="card">
            <div class="card-header" style="display: inherit;">
                <div class="col-md-6">
                    <div class="row">
                        <div class="col-md-6">
                        </div>
                        <div class="col-md-6">
                        </div>
                    </div>
                </div>
                <div class="col-md-6">
                    <div>
                        <form action="#" method="GET">
                        @csrf
                            <div class="row">
                                <div class="col-sm-3">

                                </div>
                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label class="control-label">Date From</label>
                                        <input type="text" name="date_from" id="date_from" class="month-picker form-control" value="{{ date('F Y',strtotime($date_from)) }}" autocomplete="off"/>
                                    </div>
                                </div>
                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label class="control-label">Date To</label>
                                        <input type="text" name="date_to" id="date_to" class="month-picker form-control" value="{{ date('F Y',strtotime($date_to)) }}"  autocomplete="off"/>
                                    </div>
                                </div>
                                <div class="col-sm-3" style="padding-top: 30px;">
                                    <div class="form-group">
                                        <button type="submit" class="btn btn-info"><i class="fa fa-search"></i></button>								
                                        <button title="Report Print" type="button" id="printFullReport" class="btn btn-info" >
                                            <i class="fa fa-print"></i>
                                        </button>
                                    </div>
                                </div>	
                            </div>				
                        </form>
                    </div>
                    <div style="float: right;">
                        <form action="{{ route('MonthlyCategoryReport.print') }}" target="_blank" method="get" id="printFullReportForm">@csrf
                            <input type="hidden" name="date_from" id="date_form_2">
                            <input type="hidden" name="date_to" id="date_to_2">
                        </form>
                    </div>
                </div>
            </div>

            <div class="card-body">	
                <table class="table table-striped table-bordered" id="" style="width: 100%;text-align: center;">
                    <thead>
                        <tr>
                            <th>Sl</th>
                            <th>Month</th>
                            @if(sizeof($swimmingPoolDept)>0)
                            @foreach($swimmingPoolDept as $value)
                            <th>{{ $value }}</th>
                            @endforeach
                            @endif
                            <th>Total</th>
                        </tr>
                    </thead>

                    <tbody>
                        @if(sizeof($date_range)>0)
                        @foreach($date_range as $key=>$date)
                                                <tr>
                            <td>{{ ++$sl }}</td>
                            <td>{{ date('F,Y',strtotime($date)) }}</td>
                            @if(sizeof($swimmingPoolDept)>0)
                            @foreach($swimmingPoolDept as $value)
                            <td>