
<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 outer">
				<div class="panel-heading">
					<h2>Total Registration Report</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" style="width:1800px">
						 <col width="64" span="23">
  <tr height="21">
    <td rowspan="2" height="42" width="221">Program</td>
    <td colspan="2" rowspan="2">Total Application</td>
    <td colspan="2" rowspan="2">DD Desk</td>
    <td colspan="6">Scr. Desk</td>
    <td colspan="6">Sr. Desk</td>
    <td colspan="2">Finance Desk</td>
    <td colspan="2">Enrollment Desk</td>
    <td colspan="2">Final Admission</td>
  </tr>
  <tr height="21">
    <td colspan="2" height="21">JOB DESK</td>
    <td colspan="2">PENDING</td>
    <td colspan="2">REJECT</td>
    <td colspan="2">JOB DESK</td>
    <td colspan="2">PENDING</td>
    <td colspan="2">REJECT</td>
    <td colspan="2">JOB DESK</td>
    <td colspan="2">JOB DESK</td>
    <td width="68">&nbsp;</td>
    <td width="88">&nbsp;</td>
  </tr>
  <tr height="21">
    <td height="21">&nbsp;</td>
    <td width="63">Nat</td>
    <td width="58">Int.</td>
    <td width="60">Nat</td>
    <td width="76">Int</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int.</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int</td>
    <td>Nat</td>
    <td>Int</td>
  </tr>
  <?php
  $GetList=mysql_query("SELECT * FROM  `sgvu_courses` ORDER BY  `sgvu_courses`.`coursename` ASC ");
  while($GetList1=mysql_fetch_assoc($GetList))
  {
  ?>
  
  <tr height="41">
    <td height="41" width="221"><?php echo $GetList1['coursename']; ?></td>
    <td width="63"><?php $GetTotAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.city
FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program =  '$GetList1[course_id]' AND student_registration.step BETWEEN 5 AND 15");
echo $TotAppNat[]=mysql_num_rows($GetTotAppNat);
?></td>
    <td width="58"><?php $GetTotAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.city
FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program =  '$GetList1[course_id]' AND student_registration.step BETWEEN 5 AND 15");
echo $TotAppInt[]=mysql_num_rows($GetTotAppInt);
?></td>
    <td width="60"><?php $GetDDAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program =  '$GetList1[course_id]' AND student_registration.step =  '5' ");
echo mysql_num_rows($GetDDAppNat);
?></td>
    <td width="76"><?php $GetDDAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program =  '$GetList1[course_id]' AND student_registration.step =  '5' ");
echo mysql_num_rows($GetDDAppInt);
?></td>
    <td width="60"><?php $GetScrAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '6' AND student_registration.status =  '0' ");
echo mysql_num_rows($GetScrAppNat);
?></td>
    <td width="76"><?php $GetScrAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '6' AND student_registration.status =  '0' ");
echo mysql_num_rows($GetScrAppInt);
?></td>
    <td width="64"><?php $GetScrPanAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '6' AND student_registration.status =  '2' ");
echo mysql_num_rows($GetScrPanAppNat);
?></td>
    <td width="76"><?php $GetScrPanAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '6' AND student_registration.status =  '2' ");
echo mysql_num_rows($GetScrPanAppInt);
?></td>
    <td width="62"><?php $GetScrRejAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '6' AND student_registration.status =  '3' ");
echo $ScrRajNat[]=mysql_num_rows($GetScrRejAppNat);
?></td>
    <td width="76"><?php $GetScrRejAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '6' AND student_registration.status =  '3' ");
echo $ScrRajInt[]=mysql_num_rows($GetScrRejAppInt);
?></td>
    <td width="60"><?php $GetSrJobAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '7' AND student_registration.status =  '1' ");
echo $SrJobNat[]=mysql_num_rows($GetSrJobAppNat);
?></td>
    <td width="76"><?php $GetSrJobAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '7' AND student_registration.status =  '1' ");
echo $SrJobInt[]=mysql_num_rows($GetSrJobAppInt);
?></td>
    <td width="64"><?php $GetSrPenAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '7' AND student_registration.status =  '2' ");
echo $SrPanNat[]=mysql_num_rows($GetSrPenAppNat);
?></td>
    <td width="76"><?php $GetSrPenAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '7' AND student_registration.status =  '2' ");
echo $SrPanInt[]=mysql_num_rows($GetSrPenAppInt);
?></td>
    <td width="76"><?php $GetSrRejAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '7' AND student_registration.status =  '3' ");
echo $SrRejNat[]=mysql_num_rows($GetSrRejAppNat);
?></td>
    <td width="76"><?php $GetSrRejAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '7' AND student_registration.status =  '3' ");
echo $SrRejInt[]=mysql_num_rows($GetSrRejAppInt);
?></td>
    <td width="60"><?php $GetFinanceAppNat=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city =  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '8' ");
echo $FinanceNat[]=mysql_num_rows($GetFinanceAppNat);
?></td>
    <td width="76"><?php $GetFinanceAppInt=mysql_query("SELECT step1_perosonal.sid, step1_perosonal.program, student_registration.sid, student_registration.step, student_registration.city, student_registration.status FROM step1_perosonal INNER JOIN student_registration ON student_registration.sid = step1_perosonal.sid WHERE student_registration.city !=  '0' AND step1_perosonal.program = '$GetList1[course_id]' AND student_registration.step =  '8' ");
echo $FinanceInt[]=mysql_num_rows($GetFinanceAppInt);
?></td>
    <td width="64">0</td>
    <td width="76">0</td>
    <td width="68">0</td>
    <td width="88">0</td>
    
  </tr>
  <?php
  }
  ?>
  <tr height="41">
    <td height="41" width="221">&nbsp;</td>
    <td width="63"><?php echo array_sum($TotAppNat); ?></td>
    <td width="58"><?php echo array_sum($TotAppInt); ?></td>
    <td width="60">&nbsp;</td>
    <td width="76">&nbsp;</td>
    <td width="60">&nbsp;</td>
    <td width="76">&nbsp;</td>
    <td width="64">&nbsp;</td>
    <td width="76">&nbsp;</td>
    <td width="62"><?php echo array_sum($ScrRajNat);?></td>
    <td width="76"><?php echo array_sum($ScrRajInt);?></td>
    <td width="60"><?php echo array_sum($SrJobNat);?></td>
    <td width="76"><?php echo array_sum($SrJobInt);?></td>
    <td width="64"><?php echo array_sum($SrPanNat);?></td>
    <td width="76"><?php echo array_sum($SrPanInt);?></td>
    <td width="76"><?php echo array_sum($SrRejNat);?></td>
    <td width="76"><?php echo array_sum($SrRejInt);?></td>
    <td width="60"><?php echo array_sum($FinanceNat);?></td>
    <td width="76"><?php echo array_sum($FinanceInt);?></td>
    <td width="64">0</td>
    <td width="76">0</td>
    <td width="68">0</td>
    <td width="88">0</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>
