
<div class="page-content">



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

<div data-widget-group="group1">
	<div class="row">
		<div class="col-md-12">
			<div class="panel panel-default">
				<div class="panel-heading">
					<h2>Enrollment List</h2>
					<div class="panel-ctrls"></div>
				</div>
				<div class="panel-body no-padding">
					<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
						<thead>
							<tr>
								<th width="5%">S.No.</th>
								<th width="25%">Student Name</th>
							  <th width="10%">SID</th>
							  <th width="14%">Enrollment No</th>
								<th width="29%">Course Name</th>
							  <th width="9%">Date</th>
							  <th width="8%">Action</th>
						  </tr>
						</thead>
						<tbody>
							<?php
							$GetList = mysql_query("SELECT * FROM `student_registration` WHERE `step` = '11' AND  `sesion` ='$ses' ORDER BY `student_registration`.`master_id` DESC");
							while($GetList1 = mysql_fetch_assoc($GetList))
							{
							 $s =$_REQUEST['v'];
							 
							 $GetStudentpersonal=mysql_query("SELECT * FROM  `step1_perosonal` WHERE  `sid` ='$GetList1[sid]'");
							 $GetStudentpersonal1=mysql_fetch_assoc($GetStudentpersonal);

$u = $s+0;

$GetEnroll=mysql_query("SELECT * FROM `sgvu_enrollment` WHERE `sid` ='$GetList1[sid]'");
$GetEnroll1=mysql_fetch_assoc($GetEnroll);
							
							?>
							
							<tr class="odd">
								<td align="center"><?php echo $_REQUEST['v'] = $u+1; ?></td>
								<td><div style="text-transform:uppercase"><?php echo $GetStudentpersonal1['firstname'].'&nbsp;'.$GetStudentpersonal1['middlename'].'&nbsp;'.$GetStudentpersonal1['lastname']; ?></div></td>
								<td><?php echo $GetList1['sid']; ?></td>
                                <td><?php
$GetChkenroll=mysql_query("SELECT * FROM  `old_student_enrollment` WHERE  `sid` ='$GetList1[sid]'");
$GetChkenroll1=mysql_num_rows($GetChkenroll);
$GetChkenroll2=mysql_fetch_assoc($GetChkenroll);
if($GetChkenroll1 > 0)
{
	echo $GetChkenroll2['enrollment'];
}
else
{

 $GetEnroll=mysql_query("SELECT * FROM `sgvu_enrollment` WHERE `sid` ='$GetList1[sid]'");
$GetEnroll1=mysql_fetch_assoc($GetEnroll);
echo $GetEnroll1['enrollment_no'];
}
?></td>
								   <td><?php 
								   
								   $GetCourse=mysql_query("SELECT * FROM  `sgvu_courses` WHERE  `course_id` ='$GetStudentpersonal1[program]'");
								   $GetCourse1=mysql_fetch_assoc($GetCourse);
								   echo $GetCourse1['coursename'];
								   ?></td>
								   <td class="center"><?php echo $GetEnroll1['date']; ?></td>
								   <td class="center"><a href="admin.php?page=<?php echo $convert->encode("edit-enrollment-form");?>&&id=<?php echo $convert->encode($GetList1['sid']); ?>">Edit</a>&nbsp;&nbsp;<a href="admin.php?page=<?php echo $convert->encode("view-enrollment-form");?>&&id=<?php echo $convert->encode($GetList1['sid']); ?>">View</a></td>
							   </tr>
							   <?php
							   }
							   ?>
							   
							   
						
							
						</tbody>
					</table>
				</div>
<div class="panel-footer"><a href="reports/download_enroll_list.php?id=<?php echo $ses; ?>" target="_blank"><i class="fa fa-download"></i> Download List</a></div>			</div>
		</div>
	</div>
</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>
