@extends('backend.layouts.app')
<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":false,
            columnDefs: [
                // { width: 50, targets:1},
            ],
            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"> Payment of Coach  </h5> -->
		 <a href="{{route('drivingrange.add')}}" 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"> --}}
					 Driving Dashboard
				</a>		
		<br>
	
		<div class="clearfix"></div>
	</div>
</div>
<div class="container-fluid" >
	<div class="row">
		<div class="col-xl-12">
			<form method="get">
				<div class="card">
					<div class="card-body">	
                        <form action="" method="get">
                            <div class="row justify-content-center daily-filter">
                                <label class="col-sm-1 control-label text-right">Start Date</label>
                                    <div class="col-sm-2 text-center">								
                                        <input type="text" name="date_from" class="datepickerjui text-center form-control" value="{{$date_from}}" autocomplete="off" required="" id="date_from"/>
                                    </div>
                                <label class="col-sm-1 control-label text-right">End Date</label>
                                    <div class="col-sm-2 text-center">
                                        <input type="text" name="date_to" class="datepickerjui text-center form-control" value="{{$date_to}}" autocomplete="off" required="" id="date_to" />
                                    </div>
                                <div class="col-sm-2 " style="display: inline-flex;">							
                                    <button type="submit" class="btn btn-info"><i class="fa fa-search"></i></button>
                                    <button type="button" id="categoryPrint" class="btn btn-info" style="margin-left: 7px;"><i class="fa fa-print"></i></button>
                                </div>

                            </div>
                        </form>
					</div>
					<div class="card-footer text-center">					
                        <form id="categoryPrintForm" target="_blank" action="{{ route('summaryOfPaymentCoachPrintTrainner') }}" method="get">
                            <input type="hidden" name="date_from" id="print_date_from">
                            <input type="hidden" name="date_to" id="print_date_to">
                        </form>
					</div>
				</div>
			</form>
		</div>
        <div class="card-body" style="background: white;">	
            <h5 style="text-align: center"> <u>Summaray of Coach Payment</u></h5>
            <div class="row">
                <div class="col-xl-12">	
                    <table class="table table-striped table-bordered" id="" style="width: 100%;">
                        <thead>
                            <tr>
                                <th>SL</th>
                                <th>Date</th>
                                @if(sizeof($coach_list)>0)
                                @foreach($coach_list as $list)
                                    <th>{{ $list->course_name }} -BDT</th>
                                @endforeach
                                @endif
                            </tr>
                        </thead>
                        <tbody>
                            @if(sizeof($date_range)>0)
                            @foreach($date_range as $key=>$value)
                            <tr>    
                                <td>{{ ++$sl1 }}</td>
                                <td>{{ date('d M Y',strtotime($value))  }}</td>
                                @if(sizeof($coach_list)>0)
                                @foreach($coach_list as $list)
                                    <td align="center"><strong>{{ App\Drivingrangeservice::getTotalTrainingPaymentByDate($value,$value,$list->id) }}</strong></td>
                                @endforeach
                                @endif
                            </tr>
                            @endforeach
                            @endif
                        </tbody>
                        <tfoot>
                            <tr>
                                <td colspan="2" align="right"> <strong>Grand Total:</strong></td>
                                @if(sizeof($coach_list)>0)
                                @foreach($coach_list as $list)
                                    <td align="center"> <strong>{{ App\Drivingrangeservice::getTotalTrainingPaymentByDate
                                        (date('Y-m-d',strtotime($date_from)),date('Y-m-d',strtotime($date_to)),$list->id) 
                                        }} </strong> </td>
                                @endforeach
                                @endif
                            </tr>
                            <tr>
                                <td colspan="2" align="right"> <strong>AGC (0%):</strong></td>
                                @if(sizeof($coach_list)>0)
                                @foreach($coach_list as $list)
                                    <td align="center"> 
                                        <strong>
                                        {{ getPercentage(App\Drivingrangeservice::getTotalTrainingPaymentByDate
                                            (date('Y-m-d',strtotime($date_from)),date('Y-m-d',strtotime($date_to)),$list->id) ,0) 
                                        }}
                                        </strong>
                                    </td>
                                @endforeach
                                @endif
                            </tr>
                            <tr>
                                <td colspan="2" align="right"> <strong>Contractor (0%):</strong></td>
                                @if(sizeof($coach_list)>0)
                                @foreach($coach_list as $list)
                                    <td align="center"> 
                                        <strong>
                                        {{ getPercentage(App\Drivingrangeservice::getTotalTrainingPaymentByDate
                                            (date('Y-m-d',strtotime($date_from)),date('Y-m-d',strtotime($date_to)),$list->id) ,0) 
                                        }}
                                        </strong>
                                    </td>
                                @endforeach
                                @endif
                            </tr>
                            <tr>
                                <td colspan="2" align="right"> <strong>Coach (100%):</strong></td>
                                @if(sizeof($coach_list)>0)
                                @foreach($coach_list as $list)
                                    <td align="center"> 
                                        <strong>
                                        {{ getPercentage(App\Drivingrangeservice::getTotalTrainingPaymentByDate
                                            (date('Y-m-d',strtotime($date_from)),date('Y-m-d',strtotime($date_to)),$list->id) ,100) 
                                        }}
                                        </strong>
                                    </td>
                                @endforeach
                                @endif
                            </tr>
                        </tfoot>
                    </table>
                </div>
                <div class="col-xl-12" style=" text-align: right; ">
                    <strong></strong>
                </div>
            </div>			
        </div>
        <div class="card-body" style="background: white;">	
            <h5 style="text-align: center"> <u>Summaray of Coach Payment Distribution</u> </h5>
            <div class="row">
                <div class="col-xl-12">	
                    <table class="table table-striped table-bordered" id="" style="width: 100%; text-align: center;">
                        <thead>
                            <tr>
                                <th>SL</th>
                                <th>Date</th>
                                <th>Total</th>
                                <th>AGC (0%)</th>
                                <th>Contractor (0%)</th>
                                <th>Coach (100%)</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if(sizeof($date_range)>0)
                            @foreach($date_range as $key=>$value)
                            <tr>    
                                <td align="center">{{ ++$sl2 }}</td>
                                <td align="center">{{ date('d M Y',strtotime($value))  }}</td>
                                <td align="center"> <strong>{{ App\Drivingrangeservice::getTotalPaymentByDateTraining($value,$value) }}</strong></td>
                                <td align="center">
                                    <strong>
                                        {{ getPercentage(App\Drivingrangeservice::getTotalPaymentByDateTraining($value,$value),0) }}
                                    </strong>
                                </td>
                                <td align="center">
                                    <strong>
                                        {{ getPercentage(App\Drivingrangeservice::getTotalPaymentByDateTraining($value,$value),0) }}
                                    </strong>
                                </td>
                                <td align="center">
                                    <strong>
                                        {{ getPercentage(App\Drivingrangeservice::getTotalPaymentByDateTraining($value,$value),100) }}
                                    </strong>
                                </td>
                            </tr>
                            @endforeach
                            @endif
                        </tbody>
                    </table>
                </div>
                <div class="col-xl-12" style=" text-align: right; ">
                    <strong></strong>
                </div>
            </div>			
        </div>
	</div>
</div>

<style type="text/css">
	.table th, table td {
		font-size: 12px;
	}
</style>
@endsection
@section('page_script')
<script>
    $('document').ready(function(){
        $('#categoryPrint').click(function(){
            // alert("hi");
            $('#print_row_id').val( $('#row_id').val() );
            $('#print_date_from').val( $('#date_from').val() );
            $('#print_date_to').val( $('#date_to').val() );
            $('#categoryPrintForm').submit();
        });
    });
</script>
@endsection