
<div class="page-content">
<style>


.outer {position:relative}
.inner {
  overflow-x:scroll;
  overflow-y:visible;
}
</style>




<?php
include("common/sitemap.php");
?>                            <div class="container-fluid">
                                

<div data-widget-group="group1">
	<div class="row">
		<div class="col-md-12">
			<div class="alert alert-info mb-xl">
				<h3>Show  Report</h3>
				
<div class="form-group"><form action="#" method="post" id="myform" name="myform">
					
					<div class="col-md-12">
					<div class="col-sm-4">
						<select name="sesion" class="form-control" >
										<option value="">SELECT SESSION</option>
										<?php
										$GetSession= mysql_query("SELECT * FROM `sgvu_session` ORDER BY `sgvu_session`.`ses_id` DESC");
										while($GetSession1 = mysql_fetch_assoc($GetSession))
										{
										?>
										<option value="<?php echo $GetSession1['ses_id']; ?>" 
                                        <?php if($GetSession1['ses_id'] == $_REQUEST['sesion'])
										{ ?>
                                        selected
                                        <?php } ?>
                                        ><?php echo $GetSession1['session']; ?></option>
										<?php } ?>
										</select>
					</div>
                    <div class="col-sm-4"><button class="btn-primary btn" type="submit">SUBMIT</button></div>
					
					</div>
					



</form>
<br><br>


				</div>			</div>
		</div>
	</div>
    <?php
	if($_REQUEST['sesion'] =='')
	{
		
	}
	else
	{
	
	?>
    
    <div class="row">
		<div class="col-md-12">
			<div class="panel panel-default outer">
				<div class="panel-heading">
					<h2>Total List</h2>
					<div class="panel-ctrls"></div>
				</div>
				<div class="panel-body no-padding inner">
					<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
						<thead>
							<tr>
								<th width="6%">S.No.</th>
							  <th width="16%">Student Name</th>
							  <th width="10%">SID</th>
							  <th width="11%">Course</th>
                              <th width="21%">Enrollment</th>
							  <th width="13%">Registration Date</th>
							  <th width="16%">Contact No.</th>
                              <th width="7%">Action</th>
						  </tr>
						</thead>
						<tbody>
							<?php
							$GetList = mysql_query("SELECT * FROM `student_registration` WHERE `sesion` ='$_REQUEST[sesion]' AND `step` = '11' ORDER BY `student_registration`.`master_id` DESC");
							while($GetList1 = mysql_fetch_assoc($GetList))
							{
							 $s =$_REQUEST['v'];

$u = $s+0;
								$GetCourseType=mysql_query("SELECT * FROM  `step1_perosonal` WHERE  `sid` ='$GetList1[sid]'");
								$GetCourseType1=mysql_fetch_assoc($GetCourseType);
							
							?>
							
							<tr class="odd">
								<td align="center"><?php echo $_REQUEST['v'] = $u+1; ?></td>
								<td><?php echo $GetCourseType1['firstname'].' '.$GetCourseType1['middlename'].' '.$GetCourseType1['lastname']; ?></td>
								<td><?php echo $GetList1['sid']; ?></td>
								<td><?php 
								
								
								$GetCourse=mysql_query("SELECT * FROM  `sgvu_courses` WHERE  `course_id` ='$GetCourseType1[program]'");
								$GetCourse1=mysql_fetch_assoc($GetCourse);
								echo $GetCourse1['coursename'];
								 ?></td>
                                 
                                 <td><?php 
								
								
								$Enrollment=mysql_query("SELECT * FROM `sgvu_enrollment` WHERE `sid` ='$GetList1[sid]'");
								$Enrollment1=mysql_fetch_assoc($Enrollment);
								$Enrollment2=mysql_num_rows($Enrollment);
								if($Enrollment2 > 0)
								{
								echo $Enrollment1['enrollment_no'];
								}
								else
								{
								 echo '<span style="color:#F00">Enrollment Pending</span>';	
								}
								 ?>
                                 
                                 </td>
								   <td><?php $ct = $GetCourseType1['time'];
								   echo date('d-m-Y', $ct);
								     ?></td>
								   <td class="center"> <?php echo $GetList1['mobile']; ?></td>
                                   <td class="center"><a href="admin.php?page=<?php echo $convert->encode("student-profile-admin");?>&&id=<?php echo $convert->encode($GetList1['sid']); ?>" target="_blank">View</a></td>
							   </tr>
							   <?php
							   }
							   ?>
							   
							   
						
							
						</tbody>
					</table>
				</div>
				<div class="panel-footer"></div>
			</div>
		</div>
	</div>
    
    <?php
	}
	?>
</div>
                            </div> <!-- .container-fluid -->
                        </div>
						
						<script type="text/javascript" src="assets/js/jquery-1.10.2.min.js"></script> 							<!-- Load jQuery -->
<script type="text/javascript" src="assets/js/jqueryui-1.10.3.min.js"></script> 							<!-- Load jQueryUI -->
<script type="text/javascript" src="assets/js/bootstrap.min.js"></script> 								<!-- Load Bootstrap -->
<script type="text/javascript" src="assets/js/enquire.min.js"></script> 									<!-- Load Enquire -->

<script type="text/javascript" src="assets/plugins/velocityjs/velocity.min.js"></script>					<!-- Load Velocity for Animated Content -->
<script type="text/javascript" src="assets/plugins/velocityjs/velocity.ui.min.js"></script>

<script type="text/javascript" src="assets/plugins/wijets/wijets.js"></script>     						<!-- Wijet -->

<script type="text/javascript" src="assets/plugins/codeprettifier/prettify.js"></script> 				<!-- Code Prettifier  -->
<script type="text/javascript" src="assets/plugins/bootstrap-switch/bootstrap-switch.js"></script> 		<!-- Swith/Toggle Button -->

<script type="text/javascript" src="assets/plugins/bootstrap-tabdrop/js/bootstrap-tabdrop.js"></script>  <!-- Bootstrap Tabdrop -->

<script type="text/javascript" src="assets/plugins/iCheck/icheck.min.js"></script>     					<!-- iCheck -->

<script type="text/javascript" src="assets/plugins/nanoScroller/js/jquery.nanoscroller.min.js"></script> <!-- nano scroller -->

<script type="text/javascript" src="assets/js/application.js"></script>
<script type="text/javascript" src="assets/demo/demo.js"></script>
<script type="text/javascript" src="assets/demo/demo-switcher.js"></script>

<script type="text/javascript" src="assets/plugins/datatables/jquery.dataTables.js"></script>
<script type="text/javascript" src="assets/plugins/datatables/dataTables.bootstrap.js"></script>
<script type="text/javascript" src="assets/demo/demo-datatables.js"></script>
