MMCT TEAM

Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.60
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/mjcacademy/admin/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : /home/u490972518/domains/ppschool.org.in/public_html/mjcacademy/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  fees_paid where status='' and date='$d'  ";
}
else
{
	$sel="select * from  fees_paid 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')
{
	$sel1="select * from  fees_paid where  status=''  ";
}
else
{
	$sel1="select * from  fees_paid where  status=''   ";
}
			
		$res1=mysqli_query($conn,$sel1);
		$paid=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$paid=$row1['paid']+$paid;
		}
		
			 $paid;
			?>
			<center>
			<h4 style='color:white;font-weight:bold'> <?php  $session;?></h4>
			<h4 style='color:white;font-weight:bold'><?php  $paid?> .</h4>
			</center>
		</div>
		<a href='today.php'><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  fees_paid where  status='' and date='$date'  ";
}
else
{
	$sel1="select * from  fees_paid where  status='' and date='$date'  and email='$lg'";
}
			
		$res1=mysqli_query($conn,$sel1);
		$paid=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$paid=$row1['paid']+$paid;
		}
		
			 $paid;
			?>
			<center>
			<h4 style='color:black;font-weight:bold'>Today Fees (<?php echo $date;?>)</h4>
			<h4 style='color:black;font-weight:bold'><?php echo $paid?> Rs.</h4>
			</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'];
	 
	 $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'];
	 
	 $date=date('Y-m-d');
			$sel1="select * from  registration where session='$session' and status=''   ";
		$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' and status='' ";
		$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>
		<div class='col-sm-3' id='box' style='background-Color:blue;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='2022-2023';
	 $date=date('Y-m-d');
			$sel1="select * from  registration where session='$session_old' and status=''  ";
		$res1=mysqli_query($conn,$sel1);
		$s=0;
		while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
		
		{
			 
			$s++;
		}
		
			 
			?>
			<center>
			<h4 style='color:white;font-weight:bold'>Total Student (<?php echo $session_old;?>)</h4>
			<h4 style='color:white;font-weight:bold'><?php echo $s?> </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="../registration.php" target='_blank' class="hvr hvr-Grow-Shadow"><img src="../images/student.jpg" alt="..." class="img-circle" height="150px" /><h4 >&emsp;Registration</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>
						<div class="col-sm-6">
					<center><a href="video.php" class="hvr hvr-Grow-Shadow"><img src="../images/gallery.jpg" alt="..." class="img-circle" height="150px">
					<h4 >&emsp;Video</h4></a></center>
					</div>
					<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>
					
					<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="resultpg.php" class="hvr hvr-Grow-Shadow" target='_blank'><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?flag=" 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
		$session=	$row2['session'];
			$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 status='' 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'];
		 if($user_login=='Admin')
{
	$sel1="select * from  fees_paid where  status='' and class='$class' ";
}
else
{
	$sel1="select * from  fees_paid where  status='' and class='$class'  and email='$lg'";
}
		
		$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","black","brown","red",];

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>
<br/>
<br/>
<br/>
	</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="user" 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