
<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="panel panel-default outer">
				<div class="panel-heading">
					<h2>Final Admission</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="1200">
						<thead>
							<tr>
								<th width="5%">S.No.</th>
							  <th width="18%">Student Name</th>
							  <th width="11%">SID</th>
							  <th width="18%">Course</th>
							  <th width="14%">Registration Date</th>
							  <th width="8%">Contact No.</th>
                                <th width="17%">Fees </th>
							  <th width="9%">Action</th>
						  </tr>
						</thead>
						<tbody>
							<?php
							$GetList = mysql_query("SELECT * FROM  `student_registration` WHERE  `step` >8 AND  `sesion` ='$ses' ORDER BY `student_name` ASC");
							while($GetList1 = mysql_fetch_assoc($GetList))
							{
							 $s =$_REQUEST['v'];

$u = $s+0;
							
							?>
							
							<tr class="odd">
								<td align="center"><?php echo $_REQUEST['v'] = $u+1; ?></td>
								<td><?php echo $GetList1['student_name']; ?></td>
								<td><?php echo $GetList1['sid']; ?></td>
								<td><?php 
								$GetCourseType=mysql_query("SELECT * FROM  `step1_perosonal` WHERE  `sid` ='$GetList1[sid]'");
								$GetCourseType1=mysql_fetch_assoc($GetCourseType);
								
								$GetCourse=mysql_query("SELECT * FROM  `sgvu_courses` WHERE  `course_id` ='$GetCourseType1[program]'");
								$GetCourse1=mysql_fetch_assoc($GetCourse);
								echo $GetCourse1['coursename'];
								 ?></td>
								   <td><?php $ct = $GetList1['time'];
								   echo date('d-m-Y', $ct);
								     ?></td>
								   <td class="center"> <?php echo $GetList1['mobile']; ?></td>
                                   <td class="center"> 
								   <?php 
								   $GetPaymentDetail=mysql_query("SELECT * FROM  `sgvu_finance_payment_varify` WHERE  `sid` ='$GetList1[sid]'"); 
				while($GetPaymentDetail1=mysql_fetch_assoc($GetPaymentDetail))
				{
				echo 'Receipt No: '.$GetPaymentDetail1['trans_id'].' (Cash)';
				echo '<br>';
					$GetAmount=mysql_query("SELECT * FROM  `sgvu_finence_receipt` WHERE  `recept_no` =  '$GetPaymentDetail1[trans_id]'");
					$GetAmount1=mysql_fetch_assoc($GetAmount);
					echo 'Amount: Rs.<b> '.$cash[]=$GetAmount1['tot_amount'].'</b>';
				echo '<br>';
				
				}
				?>
                <?php
				$GetOnline=mysql_query("SELECT * FROM  `finance_online_transaction` WHERE  `sid` ='$GetList1[sid]'");
				while($GetOnline1=mysql_fetch_assoc($GetOnline))
				{
				echo 'Trans No: '.$GetOnline1['trans_id'].' (Online)';
				echo '<br>';
				echo 'Amount: Rs.<b> '.$cash[]=$GetOnline1['amount'].'</b>';
				}
				echo '<hr>';
				echo 'Total: Rs.'.array_sum($cash);
				unset($cash);
				
				?>
                
                                   
                                   </td>
								   <td class="center"><a href="admin.php?page=<?php echo $convert->encode("student-profile-scruitnizer");?>&&id=<?php echo $convert->encode($GetList1['sid']); ?>">View</a>&nbsp;&nbsp;&nbsp;<a href="admin.php?page=<?php echo $convert->encode("student-profile-edit");?>&&id=<?php echo $convert->encode($GetList1['sid']); ?>">Edit</a></td>
							   </tr>
							   <?php
							   }
							   ?>
							   
							   
						
							
						</tbody>
					</table>
				</div>
				<div class="panel-footer"></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>
