@extends('layouts.admissions')

@section('content')

			<div class="container-fluid">
				<div class="page-header">
					<div class="pull-left">
						<h4>@if(!empty($status)) {{strtoupper($status)}} @endif</h4>
					</div>
					
				</div>
				<div class="row">
					<div class="col-sm-6">
						<label>
							@if(!empty($status)) {{$status}} @endif
						</label>
						
					</div>
					
				</div>
				@if (count($errors) > 0)
				    <div class="alert alert-danger">
				        <ul>
				            @foreach ($errors->all() as $error)
				                <li>{{ $error }}</li>
				            @endforeach
				        </ul>
				    </div>
				@endif
				<!-- <center><span style="background-color:maroon; color:linen">Color Coding</span></center>
				<table class="table">
					<tr>
						<td class="info">COURSE TRANSFER</td>
						<td class="success">CAMPUS TRANSFER</td>
						<td class="danger">COURSE and CAMPUS TRANSFER</td>
						<td class="active">Not Action/ DEFAULT</td></td>

						
					</tr>

				</table> -->
                <div class="row">
                    <div class="col-sm-6">
                    
                    </div>
                    <div class="col-sm-3">
                    <!-- <a class="btn btn-success float-right" href="{{url('enroll-pending-students')}}"> Enroll all students</a> -->
                    </div>
                </div>
				<form action="pendingonlineenrolled" method="post">
					{{csrf_field()}}
					<div class="row">
						<div class="col-sm-4">
							<div class="form-group">
								<label>Select Course</label>
								<select name="courses" class="select2 form-control" required>
										<option value="">--select--</option>
										<option value="All">All</option>
									@foreach($courses as $course)
										<option value="{{$course->id}}" {{old("courses") == $course->id ? "selected" : ""}}>{{strtoupper($course->course)}}</option>
									@endforeach
								</select>
							</div>
						</div>
						<div class="col-sm-2">
							<div class="form-group">
								<label>Academic Calender</label>
								<select name="calender" class="select2 form-control" required>
										<option value="">--select--</option>
									@foreach($academic_calenders as $calender)
										<option value="{{$calender->id}}" {{old("calender") == $calender->id ? "selected" : ""}}>{{strtoupper($calender->year)}}</option>
									@endforeach
								</select>
							</div>
						</div>
						<div class="col-sm-2">
							<div class="form-group">
								<label>Select Intake</label>
								<select name="intake" class="select2 form-control" required>
									<option value="">--select--</option>
									@foreach($intakes as $intake)
										<option value="{{$intake->id}}" {{old("intake") == $intake->id ? "selected" : ""}}>{{strtoupper($intake->name)}}</option>
									@endforeach
								</select>
							</div>
						</div>
						<div class="col-sm-4">
							<div class="form-group">
								<label>Excude course</label>
								<select name="exclude_course" class="select2 form-control" required>
										<option value="">--select--</option>
										<option value="0">None</option>
									@foreach($courses as $course)
										<option value="{{$course->id}}" {{old("exclude_course") == $course->id ? "selected" : ""}}>{{strtoupper($course->course)}}</option>
									@endforeach
								</select>
							</div>
						</div>
						
					</div>
					<div class="row">
					<div class="col-sm-12">
							<div class="form-group">
								<label><br><br></label>
								<input type="submit" name="" value="Filter" class="btn btn-primary btn-sm">
							</div>
						</div>
					</div>
				</form>
				@if(!empty($filtered))
					<!-- <span>
						<a href="{{url('printpreserviceweblist',[$cours,$calende,$intak])}}" class="btn btn-success">Print PDF WebList</a>
						<a href="{{url('prelisttocampus',[$cours,$calende,$intak])}}" class="btn btn-primary">Print Campus List</a>
					</span> -->

				@else


				@endif

				@php

function latestpayment($reg)
{
	$res = \DB::table('payment')

		->where('Mpesa_Account', '=', $reg)

		->orderBy('Date_received', 'DESC')
		->select('Date_received')
		->first();


	if (!$res) {
		return "Check payment";

	} else {
		return $res->Date_received;

	}



}
				
				 @endphp
				@if(!empty($students))
									<div class="box-content nopadding">
					<form action="onlineenroll2" method="POST">
					{{csrf_field()}}
					<div class="row">
						<div class="col-lg-12">
							<div class="card">


								<div class="card-body">
									<table id="scroll-horizontal" class="table nowrap align-middle" style="width:100%">
										<thead>
											<tr>
												<th><input type="checkbox" name="check" id="checkAll">#</th>
												<th>RegNo</th>
												<th>Name</th>
												<th>NationalID</th>
												<th>Email</th>
												<th>Gender</th>
												<th>Campus</th>
												<th>Joining Date</th>
												<th>Acad.Year</th>
												<th>Phone</th>
												<th>Alt. Phone</th>
												<th>County</th>
												<th>Subcounty</th>
												<th>Constituency</th>
												<th>Date paid</th>
												<th>Enrolled On</th>
												<th>Action</th>
											</tr>
										</thead>
										<tbody>
																						@foreach($students as $key)

												<tr>
													<td><input type="checkbox" name="params[]" value="{{$key->sidd}}"></td>
													<td>{{$key->reg_num}}</td>
													<td>{{$key->first_name . " " . $key->middle_name . " " . $key->last_name}}</td>
													<td>{{$key->id_number}}</td>
													<td>{{$key->email}}</td>
													<td>{{$key->gender}}</td>
													<td>{{$key->name}}</td>
													<td>{{$key->joining_date}}</td>
													<td>{{$key->year . "-" . $key->intake}}</td>
													<td>{{$key->phone}}</td>
													<td>{{$key->altphone}}</td>
													<td>{{$key->county}}</td>
													<td>{{$key->subcounty}}</td>
													<td>{{$key->const}}</td>
													<td>{{latestpayment($key->reg_num)}}</td>
													<td>{{$key->enrolled_on}}</td>
													<td><a class="btn btn-sm btn-primary" target="_blank"
															href="{{url('onlineenrollpaymentdetails', base64_encode($key->reg_num))}}">View
															payment</a></td>
												</tr>


											@endforeach

										</tbody>
									</table>
								</div>
							</div>
						</div>
					</div>
									</div>

									<div class="row">
										<div class="col-sm-12">
											<input type="submit" class="btn btn-primary" value="Enroll">
										</div>
									</div>
					</form>

				@else
				<div class="row alert-danger">
					No Data Available
				</div>
				@endif
				
				
			</div>
		

@stop