
<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">
<h3>Total Registration Report</h3>
	<div class="row">
		<div class="col-md-12">
			<div class="panel panel-default">
				<div class="panel-heading">
					<h2>Total Admission Report</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%">
                  
                  <tr>
                  <td width="5%"><strong>S.No.</strong></td>
                  <td width="39%"><strong>Course</strong></td>
                  <td width="14%"><strong>Total Seats</strong></td>
                  <td width="16%"><strong>Today's Admission</strong></td>
                  <td width="14%"><strong>Total Admission</strong></td>
                  <td width="12%"><strong>Available Seats</strong></td>
                  </tr>
                    <?php
					$cournt=0;
  $GetList=mysql_query("SELECT * FROM  `sgvu_courses` ORDER BY  `sgvu_courses`.`coursename` ASC ");
  while($GetList1=mysql_fetch_assoc($GetList))
  {
  $cournt+=1;
  ?>
                  <tr>
                   <td width="5%"><?php echo $cournt; ?></td>
				<td width="39%"><?php echo $GetList1['coursename']; ?></td>
                  <td width="14%"><?php echo $totalSeats[]=$GetList1['intake']; ?></td>
                  <td width="16%"><?php
				  $d=date('d-m-Y');
                  $GetToday=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `course` ='$GetList1[course_id]' AND  `date` = '$d'");
				  echo $todayAdmission[]=mysql_num_rows($GetToday);
				  
				  ?></td>
                  <td width="14%"><?php
                  $GetTotalAdmission=mysql_query("SELECT sgvu_new_admission_finance.course, student_registration.sid FROM sgvu_new_admission_finance INNER JOIN student_registration ON sgvu_new_admission_finance.sid=student_registration.sid WHERE sgvu_new_admission_finance.course ='$GetList1[course_id]' AND student_registration.sesion='9' AND student_registration.step>8");
				  echo $totalAdmisison[]=mysql_num_rows($GetTotalAdmission);
				  
				  ?></td>
                  <td width="12%"><?php
                  echo $totAvailable[]=$GetList1['intake']-mysql_num_rows($GetTotalAdmission);
				  ?></td>
                  </tr>
                  
                  <?php
				  }
				  ?>
                   <tr>
                  <td width="5%"><strong></strong></td>
                  <td width="39%"><strong>Total</strong></td>
                  <td width="14%"><strong><?php echo array_sum($totalSeats);?></strong></td>
                  <td width="16%"><strong><?php echo array_sum($todayAdmission);?></strong></td>
                  <td width="14%"><strong><?php echo array_sum($totalAdmisison);?></strong></td>
                  <td width="12%"><strong><?php echo array_sum($totAvailable);?></strong></td>
                  </tr>
                  </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>
