@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> -->
				<form action="onlineenrolled" 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">
										<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-3">
							<div class="form-group">
								<label>Select Academic Calender</label>
								<select name="calender" class="select2 form-control">
										<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-3">
							<div class="form-group">
								<label>Select Intake</label>
								<select name="intake" class="select2 form-control">
									<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><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
				 <br>

				@if(!empty($students))
					<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>#</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>{{$i++}}</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>

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

@stop