|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.112 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/report_js/../Management/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../config/dbconnect.php");
//require("../common.php");
if(empty($_SESSION['Mng_Username']))
{
header("Location: ../management-login.php");
die("Redirecting to ../management-login.php.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- start: Meta -->
<meta charset="utf-8">
<title>Fees Management</title>
<meta name="description" content="Bootstrap Metro Dashboard">
<meta name="author" content="Dennis Ji">
<meta name="keyword" content="Metro, Metro UI, Dashboard, Bootstrap, Admin, Template, Theme, Responsive, Fluid, Retina">
<!-- end: Meta -->
<!-- start: Mobile Specific -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- end: Mobile Specific -->
<!-- start: CSS -->
<link id="bootstrap-style" href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/bootstrap-responsive.min.css" rel="stylesheet">
<link id="base-style" href="css/style.css" rel="stylesheet">
<link id="base-style-responsive" href="css/style-responsive.css" rel="stylesheet">
<link href='http://fonts.googleapis.com/css?family=Open+Sans:300italic,400italic,600italic,700italic,800italic,400,300,600,700,800&subset=latin,cyrillic-ext,latin-ext' rel='stylesheet' type='text/css'>
</style>
<!-- start: Favicon -->
<link rel="shortcut icon" href="img/favicon.ico">
<!-- end: Favicon -->
<style type="text/css">
<!--
.style1 {
color: #0000FF;
font-weight: bold;
}
.style2 {font-size: 24px}
.style3 {
color: #330099;
font-weight: bold;
}
-->
</style>
</head>
<body>
<!-- start: Header -->
<?php
include "menu_f.php";
?>
<!-- start: Header -->
<div class="container-fluid-full">
<div class="row-fluid">
<!-- start: Main Menu -->
<div id="sidebar-left" class="span2">
<div class="nav-collapse sidebar-nav">
<ul class="nav nav-tabs nav-stacked main-menu">
<li><a href="dashboard.php"><i class="icon-bar-chart"></i><span class="hidden-tablet"> Dashboard</span></a></li>
<?php
include "menu.php";
?>
</ul>
</div>
</div>
<!-- end: Main Menu -->
<noscript>
<div class="alert alert-block span10">
<h4 class="alert-heading">Warning!</h4>
<p>You need to have <a href="http://en.wikipedia.org/wiki/JavaScript" target="_blank">JavaScript</a> enabled to use this site.</p>
</div>
</noscript>
<!-- start: Content -->
<div id="content" class="span10">
<ul class="breadcrumb">
<li>
<i class="icon-home"></i>
<a href="dashboard.php">Home</a>
<i class="icon-angle-right"></i>
</li>
<li>
<i class="icon-edit"></i>
<a href="#">Reports</a>
</li
<li>
<i class="icon-school"></i>
<?php echo $schoolName; ?></li>
<li> <?php
//$myfile = fopen("api.txt", "r") or die("Unable to open file!");
//$api=fread($myfile,filesize("api.txt"));
$url = "https://api-alerts.kaleyra.com/v4/?api_key=$api&method=account.credits&credits=1";
$fields = array(
'registration_ids' => $registatoin_ids,
'data' => $message,
);
$headers = array(
'Authorization: key=' . GOOGLE_API_KEY,
'Content-Type: application/json'
);
// Open connection
$ch = curl_init();
// Set the url, number of POST vars, POST data
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// Disabling SSL Certificate support temporarly
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($fields));
// Execute post
$result = curl_exec($ch);
if ($result === FALSE) {
die('Curl failed: ' . curl_error($ch));
}
// Close connection
curl_close($ch);
//echo $result;
$resultl=json_decode($result);
// print_r($resultl);
foreach($resultl as $l)
{
$credits="{$l->credits}";
}
?><div align="left"><b><a href="https://alerts.solutionsinfini.com/members/login"><?php
if($credits==0)
{
echo "<font color='Red'>Messages Left:- ".$credits."($smsId)"."</font>";
}else
{
echo "<font color='Blue'>Messages Left:- ".$credits."($smsId)"."</font>";
}
?></font></a></b>
</div><?php
?>
</li>
</ul>
<!--<form method="post">
<input type="submit" name="button1"
value="Last Year"/>
<input type="submit" name="button2"
value="This Year"/>
</form> -->
<?php
if(isset($_POST['button1'])) {
$_SESSION['last_year']="2019";
header("Refresh:0");
include '../config/config.php';
}
if(isset($_POST['button2'])) {
unset($_SESSION['last_year']);
header("Refresh:0");
include './config/config.php';
}
?>
<br>
<div class="row-fluid">
<div class="box blue span12">
<div class="box-header">
<h2><i class="halflings-icon white white hand-top"></i><span class="break"></span>Quick Count</h2>
</div>
<div class="box-content">
<a class="quick-button span2">
<i class="icon-group"></i>
<p>Students</p>
<span class="notification blue"><?php echo "$total_students[0]"; ?></span>
</a>
<a class="quick-button span2">
<i class="icon-certificate"></i>
<p>Total Amount</p>
<span class="notification yellow"><?php echo "$total_amount[0]"; ?></span>
</a>
<a class="quick-button span2">
<i class="icon-asterisk"></i>
<p>Paid Amount</p>
<span class="notification green"><?php echo "$paid_amount[0]"; ?></span>
<span class="notification yellow" style="top: 25px;"><?php echo "$paid_amount1[0]"; ?></span>
</a>
<a class="quick-button span2">
<i class="icon-adjust"></i>
<p>Balance Amount</p>
<span class="notification red"><?php echo "$balance_amount[0]"; ?></span>
</a>
<?php
$a=$_SESSION['user'];
if(is_array($a))
{
?>
<a class="quick-button span2" href="online_approve.php">
<i class="icon-warning-sign"></i>
<p>Online Approve</p>
<span class="notification red"><?php echo "$online_app[0]"; ?></span>
</a>
<a class="quick-button span2" href="Pay_fees.php">
<i class="icon-home"></i>
<p>Pay Fees</p>
</a>
<?php
}
?>
<div class="clearfix"></div>
</div>
</div><!--/span-->
</div>
<div class="row-fluid">
<div class="box span12 SchoolDetails">
<div class="box-header">
<h2><i class="halflings-icon white th"></i><span class="break"></span>School Intake</h2>
<div class="box-icon"><a href="testexcel.php" ><font color="White">Print</font></a>
</div>
</div>
<div class="box-content">
<div class="table-responsive" style="overflow-x:auto;">
<table class="table table-striped table-bordered ">
<thead>
<tr>
<th>Div/Class </th>
<?php
if(!$class_res=mysqli_query($con,"SELECT * FROM `class`"))
{
echo("Error description: " . mysqli_error($con));
}
while ($class=mysqli_fetch_array($class_res))
{
?>
<th><?php echo "$class[Name]";?></th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
if(!$heads_res=mysqli_query($con,"SELECT * FROM `division`"))
{
echo("Error description: " . mysqli_error($con));
}
while ($heads=mysqli_fetch_array($heads_res))
{
?>
<tr>
<td class="center"><?php echo "$heads[Name]";?> </td>
<?php
$class_res=mysqli_query($con,"SELECT * FROM `class`");
while ($class=mysqli_fetch_array($class_res))
{
//echo "select count(`Stud_Id`) where `Class` = '$class[Cls_Id]' and `Division`='$heads[Div_Id]'";
$cnt_res=mysqli_query($con,"select COUNT(`Stud_Id`) FROM `stud_basic` where `Class` = '$class[Name]' and `Division`='$heads[Name]'")or die(mysqli_error($con));
$cnt=mysqli_fetch_array($cnt_res);
?>
<td> <?php echo "$cnt[0]"; ?> </td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div>
<div align="right" class="style1">
</div>
</div>
</div></div></div>
<div class="box-content">
<div class="row-fluid sortable">
<div class="box span12">
<div class="box-header" data-original-title>
<h2><i class="halflings-icon white th"></i><span class="break"></span>Collection Summary(Bankwise) </h2>
<div class="box-icon"><a href="testexcel.php"><font color="White">Print</font></a>
</div>
</div>
<table id="example" class="table table-striped table-bordered">
<thead>
<tr>
<th>Sl.No</th>
<th>Bank Name</th>
<th>Total Amount</th>
<th>Paid Amount</th>
<th>Balance Amount</th>
</tr>
</thead>
<tbody>
<?php
$heads_c=mysqli_query($con,"SELECT * FROM `bankaccounts`,`head` WHERE `bankaccounts`.`Id` = `head`.`Bank_Code`");
$i=0;
while($heads1=mysqli_fetch_array($heads_c))
{
$i++;
$head_tamount_res1=mysqli_query($con,"SELECT sum(`stud_basic2`.`Total_Amount`) FROM `stud_basic2` WHERE `stud_basic2`.`Head_Id` = '$heads1[Head_Id]'");
$head_tamount1=mysqli_fetch_array($head_tamount_res1);
$head_pamount_res=mysqli_query($con,"SELECT sum(`stud_basic2`.`Paid`) FROM `stud_basic2` WHERE `Head_Id` =
'$heads1[Head_Id]'");
$head_bamount_res=mysqli_query($con,"SELECT sum(`stud_basic2`.`Balance`) FROM `stud_basic2` WHERE `Head_Id` = '$heads1[Head_Id]'");
$head_pamount=mysqli_fetch_array($head_pamount_res);
$head_bamount=mysqli_fetch_array($head_bamount_res);
?>
<tr>
<td class="center"> <?php echo $i; ?></td>
<td class="center"><?php echo "$heads1[Bank_Name]";?> </td>
<td class="center"><?php echo "$head_tamount1[0]";?> </td>
<td class="center"><?php echo "$head_pamount[0]";?> </td>
<td class="center"> <?php echo "$head_bamount[0]";?></td>
</tr>
<?php }?>
</tbody>
</table>
</div></div></div>
<div class="box-content">
<div class="row-fluid sortable">
<div class="box span12">
<div class="box-header" data-original-title>
<h2><i class="halflings-icon white th"></i><span class="break"></span>By Fees Code Summary (Reciept Details) </h2>
<div class="box-icon">
<a href="testexcel.php"><font color="White">Print</font></a>
</div>
</div>
<table id="example" class="table table-striped table-bordered">
<thead>
<tr>
<th>Sl.No</th>
<th>Fees Code</th>
<th>Total Amount</th>
<th>Paid Amount</th>
<th>Balance Amount</th>
</tr>
</thead>
<tbody>
<?php
if(!$heads_res=mysqli_query($con,"SELECT * FROM `head`"))
{
echo("Error description: " . mysqli_error($con));
}
$i=0;
while ($heads=mysqli_fetch_array($heads_res))
{
$i++;
?>
<tr>
<td class="center"><?php echo "$i";?> </td>
<td class="center"><?php echo "$heads[Name]";?> </td>
<?php
$head_tamount_res=mysqli_query($con,"SELECT sum(`Total_Amount`) FROM `stud_basic2` WHERE `Head_Id` = '$heads[Head_Id]'");
$head_pamount_res=mysqli_query($con,"SELECT sum(`Paid`) FROM `stud_basic2` WHERE `Head_Id` =
'$heads[Head_Id]'");
$head_bamount_res=mysqli_query($con,"SELECT sum(`Balance`) FROM `stud_basic2` WHERE `Head_Id` =
'$heads[Head_Id]'");
$head_tamount=mysqli_fetch_array($head_tamount_res);
$head_pamount=mysqli_fetch_array($head_pamount_res);
$head_bamount=mysqli_fetch_array($head_bamount_res);
?>
<td class="center"><?php echo "$head_tamount[0]";?> </td>
<td class="center"><?php echo "$head_pamount[0]";?> </td>
<td class="center"> <?php echo "$head_bamount[0]";?></td>
</tr>
<?php } ?>
</tbody>
</table>
<div>
<div align="right" class="style1">
<div align="center"><a href="recpt_report_excle.php" class="style1"> Receipt Report </a> - <a href="balancelist.php" class="style1">Balance Report</a> </div>
</div>
</div>
</div></div></div>
<div class="row-fluid">
<div class="box span12">
<div class="box-header">
<h2><i class="halflings-icon white th"></i><span class="break"></span>fees Collection Summary </h2>
<div class="box-icon"><a href="testexcel.php" ><font color="White">Print</font></a>
</div>
</div>
<div class="box-content">
<div class="table-responsive" style="overflow-x:auto;">
<table class="table table-striped table-bordered ">
<thead>
<tr>
<th>Fees Code</th>
<?php
if(!$class_res=mysqli_query($con,"SELECT * FROM `class` ORDER BY `Cls_Id` ASC "))
{
echo("Error description: " . mysqli_error($con));
}
while ($class=mysqli_fetch_array($class_res))
{
?>
<th><?php echo "$class[Name]";?></th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
if(!$heads_res=mysqli_query($con,"SELECT * FROM `head`"))
{
echo("Error description: " . mysqli_error($con));
}
while ($heads=mysqli_fetch_array($heads_res))
{
?>
<tr>
<td class="center"><?php echo "$heads[Name]";?> </td>
<?php
$class_res=mysqli_query($con,"SELECT * FROM `class` ORDER BY Cls_Id ASC");
while ($class=mysqli_fetch_array($class_res))
{
$count_res=mysqli_query($con,
"SELECT SUM(stud_basic2.Paid)
FROM stud_basic INNER JOIN stud_basic2
ON stud_basic.Stud_Id = stud_basic2.Stud_Id
WHERE stud_basic.Class='$class[Name]' and
stud_basic2.Head_Id='$heads[Head_Id]'");
$cnt=mysqli_fetch_array($count_res);
if($cnt['0'] == "")
{
$cnt['0'] = 0;
}
?>
<td> <?php echo "$cnt[0]"; ?> </td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div>
<div align="right" class="style1">
<div align="center"><b><a href="reportsexcel.php" class="style1">Explore </a></b> </div>
</div>
</div>
</div></div></div>
<div class="row-fluid">
<div class="box span12">
<div class="box-header">
<h2><i class="halflings-icon white th"></i><span class="break"></span>Fees Code Assigned Summary </h2>
<div class="box-icon"><a href="testexcel.php"><font color="White">Print</font></a>
</div>
</div>
<div class="box-content">
<div class="table-responsive" style="overflow-x:auto;">
<table class="table table-striped table-bordered ">
<thead>
<tr>
<th>Fees Code</th>
<?php
if(!$class_res=mysqli_query($con,"SELECT * FROM `class` ORDER BY Cls_Id ASC"))
{
echo("Error description: " . mysqli_error($con));
}
while ($class=mysqli_fetch_array($class_res))
{
?>
<th><?php echo "$class[Name]";?></th>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
if(!$heads_res=mysqli_query($con,"SELECT * FROM `head`"))
{
echo("Error description: " . mysqli_error($con));
}
while ($heads=mysqli_fetch_array($heads_res))
{ $cccc=0;
?>
<tr>
<td class="center"><?php echo "$heads[Name]";?> </td>
<?php
$class_res=mysqli_query($con,"SELECT * FROM `class`ORDER BY Cls_Id ASC");
while ($class=mysqli_fetch_array($class_res))
{
$cccc=0;
// $a= "SELECT count(DISTINCT stud_basic.Stud_Id)
// FROM stud_basic INNER JOIN stud_basic2
// ON stud_basic.Stud_Id = stud_basic2.Stud_Id
// WHERE stud_basic.Class='$class[Name]' and
// stud_basic2.Head_Id='$heads[Head_Id]'";
// echo "<br>";
$count_res=mysqli_query($con,
"SELECT count(DISTINCT stud_basic.Stud_Id)
FROM stud_basic INNER JOIN stud_basic2
ON stud_basic.Stud_Id = stud_basic2.Stud_Id
WHERE stud_basic.Class='$class[Name]' and
stud_basic2.Head_Id='$heads[Head_Id]'");
$cnt=mysqli_fetch_array($count_res);
$cccc=$cnt['0'];
?>
<td> <?php echo "$cccc"; ?> </td>
<?php
}
?>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div></div></div>
</div>
</div>
</div><!--/span-->
</div>
</div><!--/.fluid-container-->
<!-- end: Content -->
</div><!--/#content.span10-->
</div><!--/fluid-row-->
<div class="clearfix"></div>
<footer>
<p>
<span style="text-align:left;float:left">© 2018 <a href="http://evisioninfotech.in" alt="Bootstrap_Metro_Dashboard">e vision infotech</a></span>
</p>
</footer>
<!-- start: JavaScript-->
<script src="js/jquery-1.9.1.min.js"></script>
<script src="js/jquery-migrate-1.0.0.min.js"></script>
<script src="js/jquery-ui-1.10.0.custom.min.js"></script>
<script src="js/jquery.ui.touch-punch.js"></script>
<script src="js/modernizr.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.cookie.js"></script>
<script src='js/fullcalendar.min.js'></script>
<script src='js/jquery.dataTables.min.js'></script>
<script src="js/excanvas.js"></script>
<script src="js/jquery.flot.js"></script>
<script src="js/jquery.flot.pie.js"></script>
<script src="js/jquery.flot.stack.js"></script>
<script src="js/jquery.flot.resize.min.js"></script>
<script src="js/jquery.chosen.min.js"></script>
<script src="js/jquery.uniform.min.js"></script>
<script src="js/jquery.cleditor.min.js"></script>
<script src="js/jquery.noty.js"></script>
<script src="js/jquery.elfinder.min.js"></script>
<script src="js/jquery.raty.min.js"></script>
<script src="js/jquery.iphone.toggle.js"></script>
<script src="js/jquery.uploadify-3.1.min.js"></script>
<script src="js/jquery.gritter.min.js"></script>
<script src="js/jquery.imagesloaded.js"></script>
<script src="js/jquery.masonry.min.js"></script>
<script src="js/jquery.knob.modified.js"></script>
<script src="js/jquery.sparkline.min.js"></script>
<script src="js/counter.js"></script>
<script src="js/retina.js"></script>
<script src="js/custom.js"></script>
<script src="js9/fastclick.js"></script>
<script src="js/easyscroll.js"></script>
<!-- end: JavaScript-->
<?php if(isset($_GET['id'])) { ?>
<script>
$('html, body').animate({
scrollTop: $(".SchoolDetails").offset().top - 20
}, 0);
</script>
<?php } ?>
</body>
</html>