<div class="page-content">
                            <ol class="breadcrumb">
                                
<li class=""><a href="index.html">Home</a></li>
<li class="active"><a href="index.html">Dashboard</a></li>
                            </ol>
                            <div class="container-fluid">
                                

<div class="row">
	<div class="col-md-3">
		<div class="info-tile tile-orange">
			<div class="tile-icon"><i class="ti ti-user"></i></div>
			<div class="tile-heading"><span>Final Admissions</span></div>
			<div class="tile-body"><span><?php
			$final_admission = mysql_query("SELECT * FROM `student_registration` WHERE `step` >=9 AND  `sesion` ='$ses'");
			echo mysql_num_rows($final_admission);
			?></span></div>
<!--			<div class="tile-footer"><span class="text-success">22.5% <i class="fa fa-level-up"></i></span></div>
-->		</div>
	</div>
	<div class="col-md-3">
		<div class="info-tile tile-success">
			<div class="tile-icon"><i class="ti ti-user"></i></div>
			<div class="tile-heading"><span>Total SID</span></div>
			<div class="tile-body"><span><?php
			$registration = mysql_query("SELECT * FROM `student_registration` WHERE `sesion` ='$ses'");
			echo $noregi=mysql_num_rows($registration);
			?></span></div>
		</div>
	</div>
	<div class="col-md-3">
		<div class="info-tile tile-info">
			<div class="tile-icon"><i class="ti ti-user"></i></div>
			<div class="tile-heading"><span>SID- National </span></div>
			<div class="tile-body"><span><?php
            $national=mysql_query("SELECT * FROM  `student_registration` WHERE  `city` ='0' AND  `sesion` ='$ses'");
			echo mysql_num_rows($national);
			?></span></div>
		</div>
	</div>
	<div class="col-md-3">
		<div class="info-tile tile-danger">
			<div class="tile-icon"><i class="ti ti-user"></i></div>
			<div class="tile-heading"><span>SID- International </span></div>
			<div class="tile-body"><span><?php
            $International=mysql_query("SELECT * FROM  `student_registration` WHERE  `city` !='0' AND  `sesion` ='$ses'");
			echo mysql_num_rows($International);
			?></span></div>
		</div>
	</div>
</div>

<div data-widget-group="group1">
	<div class="row">
		

		<div class="col-md-6">
		<div class="panel panel-teal" data-widget='{"draggable": "false"}'>
				<div class="panel-heading">
					<h2>Top City</h2>
					<div class="panel-ctrls button-icon-bg" 
						data-actions-container="" 
						data-action-collapse='{"target": ".panel-body"}'
						data-action-colorpicker=''
						data-action-refresh-demo='{"type": "circular"}'
						>					</div>
				</div>
				<div class="panel-body no-padding">
					<table class="table browsers m-n">
						<tbody>
							<?php
							$GetTotCount = mysql_query("SELECT * FROM `step1_contact`");
							$GetTotCount1=mysql_num_rows($GetTotCount);
							
							
							$GetTopCity = mysql_query("SELECT city, count(*) as 'Cnt' FROM step1_contact GROUP BY city ORDER BY `Cnt` DESC LIMIT 0, 6");
							while($GetTopCity1 = mysql_fetch_assoc($GetTopCity))
							{
								if($GetTopCity1['city']!='0')
								{
								
								
							?>
							
							<tr>
								<td><?php 
								$GetCity = mysql_query("SELECT * FROM `city` WHERE `city_id` = '$GetTopCity1[city]'");
								$GetCity1=mysql_fetch_assoc($GetCity);
								echo $GetCity1['cityname'];
								?></td>
								<td class="text-right"><?php $topcity = ($GetTopCity1['Cnt']/$GetTotCount1)*100; echo round($topcity); ?>% (<?php echo $GetTopCity1['Cnt']; ?>)</td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: <?php echo $topcity; ?>%"></div>
	                                </div>	                            </td>
							</tr>
							<?php 
									}
							} ?>
						</tbody>
					</table>
				</div>
			</div>	
		</div>
		<div class="col-md-6">
			<div class="panel panel-teal" data-widget='{"draggable": "false"}'>
				<div class="panel-heading">
					<h2>Top State</h2>
					<div class="panel-ctrls button-icon-bg" 
						data-actions-container="" 
						data-action-collapse='{"target": ".panel-body"}'
						data-action-colorpicker=''
						data-action-refresh-demo='{"type": "circular"}'
						>					</div>
				</div>
				<div class="panel-body no-padding">
					<table class="table browsers m-n">
						<tbody>
							<?php
							$GetTopState = mysql_query("SELECT state, count(*) as 'cnt' FROM step1_contact GROUP BY state ORDER BY `cnt` DESC LIMIT 0, 6");
							while($GetTopState1 = mysql_fetch_assoc($GetTopState))
							{
								if($GetTopState1['state']!='')
									{	
							?>
							
							<tr>
								<td><?php 
								$GetState = mysql_query("SELECT * FROM `state` WHERE `ids` = '$GetTopState1[state]'");
								$GetState1 = mysql_fetch_assoc($GetState);
								echo $GetState1['state'];
								?></td>
								<td class="text-right"><?php $topstate = ($GetTopState1['cnt']/$GetTotCount1)*100; echo round($topstate); ?>% (<?php echo $GetTopState1['cnt']; ?>)</td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: <?php echo $topstate; ?>%"></div>
	                                </div>	                            </td>
							</tr>
							<?php 
										}
							} ?>
						</tbody>
					</table>
				</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>

<!-- End loading site level scripts -->
    
    <!-- Load page level scripts-->
    
<!-- Charts -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.min.js"></script>             	<!-- Flot Main File -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.pie.min.js"></script>             <!-- Flot Pie Chart Plugin -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.stack.min.js"></script>       	<!-- Flot Stacked Charts Plugin -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.orderBars.min.js"></script>   	<!-- Flot Ordered Bars Plugin-->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.resize.min.js"></script>          <!-- Flot Responsive -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.tooltip.min.js"></script> 		<!-- Flot Tooltips -->
<script type="text/javascript" src="assets/plugins/charts-flot/jquery.flot.spline.js"></script> 				<!-- Flot Curved Lines -->

<script type="text/javascript" src="assets/plugins/sparklines/jquery.sparklines.min.js"></script> 			 <!-- Sparkline -->

<script type="text/javascript" src="assets/plugins/jvectormap/jquery-jvectormap-2.0.2.min.js"></script>       <!-- jVectorMap -->
<script type="text/javascript" src="assets/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>   <!-- jVectorMap -->

<script type="text/javascript" src="assets/plugins/switchery/switchery.js"></script>     					<!-- Switchery -->
<script type="text/javascript" src="assets/plugins/easypiechart/jquery.easypiechart.js"></script>
<script type="text/javascript" src="assets/plugins/fullcalendar/moment.min.js"></script> 		 			<!-- Moment.js Dependency -->
<script type="text/javascript" src="assets/plugins/fullcalendar/fullcalendar.min.js"></script>   			<!-- Calendar Plugin -->

<script type="text/javascript" src="assets/demo/demo-index.js"></script> 									<!-- Initialize scripts for this page-->

						