
    <link type="text/css" href="assets/fonts/font-awesome/css/font-awesome.min.css" rel="stylesheet">        <!-- Font Awesome -->
    <link type="text/css" href="assets/fonts/themify-icons/themify-icons.css" rel="stylesheet">              <!-- Themify Icons -->
    <link type="text/css" href="assets/css/styles.css" rel="stylesheet">                                     <!-- Core CSS with all styles -->

    <link type="text/css" href="assets/plugins/codeprettifier/prettify.css" rel="stylesheet">                <!-- Code Prettifier -->
    <link type="text/css" href="assets/plugins/iCheck/skins/minimal/blue.css" rel="stylesheet">              <!-- iCheck -->


<?php
$ChkNewFroms = mysql_query("SELECT * FROM `student_registration` WHERE `step` = 5");
$tm=time();
$date=date('d-m-Y', $tm);
?>

<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-stats-up"></i></div>
			<div class="tile-heading"><span>Today Collection</span></div>
			<div class="tile-body"><span><?php 
			$GetToday=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$date'");
			while($GetToday1=mysql_fetch_assoc($GetToday))
			{
			$today[]=$GetToday1['amt'];
			}
			echo array_sum($today)+0;
			 ?></span></div>
			<div class="tile-footer"><span class="text-success"><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-bar-chart"></i></div>
			<div class="tile-heading"><span>Today's Admission</span></div>
			<div class="tile-body"><span><?php 
			$GetTodayAdmission=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `date` =  '$date'");
			echo mysql_num_rows($GetTodayAdmission)+0;
			?>

</span></div>
			<div class="tile-footer"><span class="text-danger"><i class="fa fa-level-up"></i></span></div>
		</div>
	</div>
	<div class="col-md-3">
		<div class="info-tile tile-info">
			<div class="tile-icon"><i class="ti ti-stats-up"></i></div>
			<div class="tile-heading"><span>Earnings</span></div>
			<div class="tile-body"><span>0</span></div>
			<div class="tile-footer"><span class="text-success">5.2% <i class="fa fa-level-up"></i></span></div>
		</div>
	</div>
	<div class="col-md-3">
		<div class="info-tile tile-danger">
			<div class="tile-icon"><i class="ti ti-bar-chart-alt"></i></div>
			<div class="tile-heading"><span>Visitors</span></div>
			<div class="tile-body"><span>0</span></div>
			<div class="tile-footer"><span class="text-danger">10.5% <i class="fa fa-level-down"></i></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>Last 7 Days Collection (Cash)</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>
							<tr>
								<td><?php echo $dateA=date('d-m-Y', ($tm-86400));
								
								
								?></td>
								<td class="text-right">Rs. <?php 
											$GetRevanueA=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateA'");
											while($GetRevanueA1=mysql_fetch_assoc($GetRevanueA))
											{
											$GetRevanueA2[]=$GetRevanueA1['amt'];
											}
											echo array_sum($GetRevanueA2)+0;

								?></td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							<tr>
								<td><?php echo $dateB=date('d-m-Y', ($tm-86400*2));?></td>
								<td class="text-right">Rs. <?php 
											$GetRevanueB=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateB'");
											while($GetRevanueB1=mysql_fetch_assoc($GetRevanueB))
											{
											$GetRevanueB2[]=$GetRevanueB1['amt'];
											}
											echo array_sum($GetRevanueB2)+0;

								?></td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							<tr>
								<td><?php echo $dateC=date('d-m-Y', ($tm-86400*3));?></td>
								<td class="text-right">
								Rs. <?php 
											$GetRevanueC=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateC'");
											while($GetRevanueC1=mysql_fetch_assoc($GetRevanueC))
											{
											$GetRevanueC2[]=$GetRevanueC1['amt'];
											}
											echo array_sum($GetRevanueC2)+0;

								?>
								</td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							<tr>
								<td><?php echo $dateD=date('d-m-Y', ($tm-86400*4));?></td>
								<td class="text-right">Rs. <?php 
											$GetRevanueD=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateD'");
											while($GetRevanueD1=mysql_fetch_assoc($GetRevanueD))
											{
											$GetRevanueD2[]=$GetRevanueD1['amt'];
											}
											echo array_sum($GetRevanueD2)+0;

								?></td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							<tr>
								<td><?php echo $dateE=date('d-m-Y', ($tm-86400*5));?></td>
								<td class="text-right">Rs. <?php 
											$GetRevanueE=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateE'");
											while($GetRevanueE1=mysql_fetch_assoc($GetRevanueE))
											{
											$GetRevanueE2[]=$GetRevanueE1['amt'];
											}
											echo array_sum($GetRevanueE2)+0;

								?></td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							<tr>
								<td><?php echo $dateF=date('d-m-Y', ($tm-86400*6));?></td>
								<td class="text-right">Rs. <?php 
											$GetRevanueF=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateF'");
											while($GetRevanueF1=mysql_fetch_assoc($GetRevanueF))
											{
											$GetRevanueF2[]=$GetRevanueF1['amt'];
											}
											echo array_sum($GetRevanueF2)+0;

								?></td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							<tr>
								<td><?php echo $dateG=date('d-m-Y', ($tm-86400*7));?></td>
								<td class="text-right">Rs. <?php 
											$GetRevanueG=mysql_query("SELECT * FROM `sgvu_cash_receipt` WHERE `date` = '$dateG'");
											while($GetRevanueG1=mysql_fetch_assoc($GetRevanueG))
											{
											$GetRevanueG2[]=$GetRevanueG1['amt'];
											}
											echo array_sum($GetRevanueG2)+0;

								?></td>
								<td class="vam" style="width: 56px;">
									<div class="progress m-n">
	                                  <div class="progress-bar progress-bar-teal" style="width: 100%"></div>
	                                </div>	                            </td>
							</tr>
							
						</tbody>
					</table>
				</div>
			</div>
		</div>
			<div class="col-md-6">
			<div class="panel panel-bluegray" data-widget='{"draggable": "false"}'>
				<div class="panel-heading">
					<h2>Earnings Stats</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">
                <?php
				$AdmissionCash1=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `mode` =1");
				$AdmissionCash2=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `mode` =2");
				$AdmissionCash3=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `mode` =3");
				$AdmissionCash4=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `mode` =4");
				$AdmissionCash5=mysql_query("SELECT * FROM  `sgvu_new_admission_finance` WHERE  `mode` =5");
				
				?>
					<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);
      function drawChart() {

        var data = google.visualization.arrayToDataTable([
          ['Task', 'Hours per Day'],
          ['Cash',     <?php echo mysql_num_rows($AdmissionCash3); ?>],
          ['Challan',      <?php echo mysql_num_rows($AdmissionCash1); ?>],
          ['Online(PayU)',  <?php echo mysql_num_rows($AdmissionCash2); ?>],
          ['Cheque/DD', <?php echo mysql_num_rows($AdmissionCash4); ?>],
          ['Card',    <?php echo mysql_num_rows($AdmissionCash5); ?>]
        ]);

        var options = {
          title: 'Total Admission'
        };

        var chart = new google.visualization.PieChart(document.getElementById('piechart'));

        chart.draw(data, options);
      }
    </script>
    <div id="piechart" style="width: 100%; height: 250px;"></div>
					
				</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-->
    
