@extends('backend.layouts.app')
@section('content')
<div class="container-fluid">

    <div class="row">
        <div class="col-xl-12">
            <div class="breadcrumb-holder">
                <h1 class="main-title float-left">
                	Summary of Spot Registration Fees
            	</h1>
                <ol class="breadcrumb float-right">
                    <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a> </li>
                    <li class="breadcrumb-item"><a href="{{ route('tournaments') }}">Tournament</a> </li>
                    <li class="breadcrumb-item active">
                    	Summary of Spot Registration Fees
                    </li>
                </ol>
                <div class="clearfix"></div>
            </div>
        </div>
    </div>
    
    <div class="row">
    	<div class="col-sm-12">
    		<div class="card">                
                <div class="card-body">
                    <form method="get" action="{{route('tournaments.report.spot-registration.summary')}}">
                        <div class="row justify-content-center">
                            @php
                                $selected_year = request()->year?request()->year:date('Y');
                                if(isset($tournaments) && $tournaments->count() > 0){
                                    $selected_tour = request()->tour?request()->tour:$tournaments->last()->id;
                                }else{
                                    $selected_tour = null;
                                }
                               
                            @endphp
                            <div class="col-sm-2">
                                <div class="form-group">
                                    <label>Year</label>
                                    <select class="form-control select2 year-select" name="year">
                                        <option value="">Select Year</option>
                                        @for($i=date('Y')+1; $i > 2015; $i--)
                                            <option value="{{$i}}" @if($i == $selected_year) selected @endif>{{$i}}</option>
                                        @endfor
                                    </select>
                                </div>
                            </div>
                            <div class="col-sm-4">
                                <div class="form-group">
                                    <label>Tournament</label>
                                    <select class="form-control select2 tournament-select" name="tour">
                                        <option value="">Select Tournament</option>
                                        @foreach($tournaments as $tournament)
                                        <option value="{{$tournament->id}}" @if($tournament->id == $selected_tour) selected @endif>{{$tournament->tour_name}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>                            
                        </div>
                    </form>
                </div>
            </div>
            <br />
            @if($selected_year && $selected_tour)
                <a href="{{ route('tournaments.report.spot-registration.summary-pdf', ['tour_id' => $selected_tour]) }}" class="btn btn-info pull-right" target="_blank"><i class="fa fa-print"></i> Print</a>           
                <div class="clearfix">                    
                </div>
                <div class="card">
                    <div class="card-body">
                        <table class="table table-sm table-bordered">
                            <thead>
                                <tr>
                                    <th colspan="10" class="text-center">
                                        <h3 style="font-size: 16px; text-align: center; display: block;">Tournament: {{$tournament_info->tour_name}}</h3>                                
                                    </th>
                                </tr>
                                <tr>
                                    <th class="text-center">SL</th>
                                    <th class="text-center">Member Cat.</th>
                                    <th class="text-center">Tee Category</th>
                                    <th class="text-center">M. ID</th>
                                    <th class="text-center">Name</th>
                                    <th class="text-center">Handicap</th>
                                    <th class="text-center">Amount</th>
                                    <th class="text-center">Paid Date</th>
                                    <th class="text-center">Due</th>
                                    <th class="text-center">Action</th>                                    
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($registrations as $row)
                                <tr>
                                    <td class="text-center">{{ $loop->index + 1 }}</td>
                                    <td class="text-center">{{ $row->member_type }}</td>
                                    <td class="text-center">{{ $row->tee_category?$row->tee_category->name:'' }}</td>
                                    <td class="text-center">{{ $row->membership_no }}</td>
                                    <td class="text-center">{{ $row->golfer_name }}</td>
                                    <td class="text-center">{{ $row->handicap }}</td>
                                    <td class="text-right">{{ number_format($row->reg_bill, 2) }}</td>
                                    <td class="text-center">{{ $row->paid_date }}</td>
                                    <td class="text-right">{{ number_format($row->reg_bill - $row->paid, 2) }}</td>
                                    <td class="text-center">
                                        <a href="{{ route('tournaments.spot-registration.money-receipt', $row->id) }}" class="btn btn-sm btn-info"><i class="fa fa-print"></i></a>
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                            <tfoot>
                                <th colspan="6" class="text-right">Total</th>
                                <th class="text-right">{{ number_format($registrations->sum('reg_bill'), 2) }}</th>
                                <th></th>
                                <th class="text-right">{{ number_format($registrations->sum('reg_bill') - $registrations->sum('paid'), 2) }}</th>
                                <th></th>
                            </tfoot>                    
                        </table> 
                    </div>
                </div>                                       
            @endif
    	</div>
    </div>    
</div>
@endsection

@section('before_body_end')
<script type="text/javascript">
	$(function(){								
	   $('.year-select').on('change', function(){
            $('.tournament-select').val('');
            $('.date-select').val('');
            $(this).closest('form').submit();
       });

       $('.tournament-select').on('change', function(){
            $('.date-select').val('');
            $(this).closest('form').submit();
       });

       $('.date-select').on('change', function(){
            $(this).closest('form').submit();
       });

        $('.tee-slot-remove-btn').on('click', function(e){
            e.preventDefault();
            if(confirm('Are you sure to remove this slot?')){
                $(this).closest('td').find('form').submit();
            }
        });

        $('#registration-modal').on('shown.bs.modal', function(e) {
          var id = $(e.relatedTarget).data('id');
          $(e.currentTarget).find('input[name="slot_id"]').val(id);
        })

        $('.registration-delete-btn').on('click', function(e){
            if(confirm('Are you sure to remove registration')){
                $(this).closest('td').find('.registration-delete-form').submit();
            }
        })
	});

    $(function() {
        $('.timepicker').daterangepicker({
            singleDatePicker: true,
            showDropdowns: true,
            autoUpdateInput: true,
            timePicker: true,
            // drops: "up",
            autoApply:true,
            locale: {
                format: 'hh:mm A',
                daysOfWeek: ['Su', 'Mo', 'Tu', 'We', 'Th', 'Fr','Sa'],
                firstDay: 0
            }
        }).on('show.daterangepicker', function(ev, picker) {
             picker.container.find(".calendar-table").hide();
        });
    });
</script>
@endsection