@extends('backend.layouts.pdf')
@section('content')
<div class="container" style="padding-right: 40px; padding-left: 35px;">
    <div class="row">
        <div class="col-xs-1 text-left">
            <img src="{{asset('public/backend/images/logo.png')}}" style="margin:0 auto; width:50px" class="img-rounded" alt="Cinque Terre">
        </div>
        <div class="style="width:25%"">

            <h4 style="text-align: center; margin: 0px;">Summaray of Course Payment Report</h4>
            <h5 style="text-align: center; margin: 0px;">Bhatiary Golf &Country Club</h5>
            <h5 style="text-align: center; margin: 0px;">Driving Range</h5>
        </div>
        <div class="co-xs-1 text-right">
            
        </div>
    </div>			
		</div>
		<br>
<div class="container">
    <p> <strong>Date form: {{ $date_from }} to: {{$date_to}}</strong> </p>
    <div class="row">
        <h5 style="text-align: center"> <strong><u>Summaray of Course Payment</u></strong> </h5>
        <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::getTotalCoachPaymentByDate($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::getTotalCoachPaymentByDate
                                (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 (15%):</strong></td>
                        @if(sizeof($coach_list)>0)
                        @foreach($coach_list as $list)
                            <td align="center"> 
                                <strong>
                                {{ getPercentage(App\Drivingrangeservice::getTotalCoachPaymentByDate
                                    (date('Y-m-d',strtotime($date_from)),date('Y-m-d',strtotime($date_to)),$list->id) ,15) 
                                }}
                                </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::getTotalCoachPaymentByDate
                                    (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 (85%):</strong></td>
                        @if(sizeof($coach_list)>0)
                        @foreach($coach_list as $list)
                            <td align="center"> 
                                <strong>
                                {{ getPercentage(App\Drivingrangeservice::getTotalCoachPaymentByDate
                                    (date('Y-m-d',strtotime($date_from)),date('Y-m-d',strtotime($date_to)),$list->id) ,85) 
                                }}
                                </strong>
                            </td>
                        @endforeach
                        @endif
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
    <div class="row">
        <h5 style="text-align: center"> <strong><u>Summaray of Course Payment Distribution</u></strong> </h5>
        <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 (15%)</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::getTotalPaymentByDate($value,$value) }}</strong></td>
                        <td align="center">
                            <strong>
                                {{ getPercentage(App\Drivingrangeservice::getTotalPaymentByDate($value,$value),15) }}
                            </strong>
                        </td>
                        <td align="center">
                            <strong>
                                {{ getPercentage(App\Drivingrangeservice::getTotalPaymentByDate($value,$value),0) }}
                            </strong>
                        </td>
                        <td align="center">
                            <strong>
                                {{ getPercentage(App\Drivingrangeservice::getTotalPaymentByDate($value,$value),85) }}
                            </strong>
                        </td>
                    </tr>
                    @endforeach
                    @endif
                </tbody>
            </table>
        </div>
    </div>
</div>
@include('backend.driving.signutare_footer')
<style type="text/css">
	table th, table td {
		font-size: 12px;
	}
    table tfoot td{
        text-align:center;
    }
</style>
<script>
    $('document').ready(function(){
        
    });
</script>
@endsection