|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.60 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.77.1.lve.el8.x86_64 #1 SMP Wed Oct 8 14:21:00 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/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// First we execute our common code to connection to the database and start the session
require("common.php");
// At the top of the page we check to see whether the user is logged in or not
if(empty($_SESSION['user']))
{
// If they are not, we redirect them to the login page.
header("Location: login.php");
// Remember that this die statement is absolutely critical. Without it,
// people can view your members-only content without logging in.
die("Redirecting to login.php");
}
error_reporting(E_ALL ^ E_WARNING);
?>
<!DOCTYPE html>
<html>
<head>
<title>Consulated Reports </title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="https://code.jquery.com/jquery-3.3.1.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css"/>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.1/css/buttons.dataTables.min.css"/>
<script type="text/javascript">
$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
} );
} );
$(document).ready(function() {
$('#example1').DataTable( {
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
} );
} );
$(document).ready(function() {
$('#example2').DataTable( {
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
} );
} );
$(document).ready(function() {
$('#example3').DataTable( {
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
} );
} );
$(document).ready(function() {
$('#example4').DataTable( {
dom: 'Bfrtip',
buttons: [
'copyHtml5',
'excelHtml5',
'csvHtml5',
'pdfHtml5'
]
} );
} );
</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/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>
</head>
<body><div style="width:100%;">
<div style="margin-left:30px;margin-right:30px;">
<nav class="navbar navbar-default">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="dashboard.php">Dashboard</a>
</div>
</div>
</nav>
<?php
include './config/config.php';
?>
<h2><i class="halflings-icon white th"></i><span class="break"></span><font color="Blue">By Bank</font> </h2>
<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`, `head` WHERE `stud_basic2`.`Head_Id` = '$heads1[Head_Id]' AND `head`.`Bank_Code`='$heads1[Id]'");
$head_tamount1=mysqli_fetch_array($head_tamount_res1);
$head_pamount_res=mysqli_query($con,"SELECT sum(`Paid`) FROM `stud_basic2` WHERE `Head_Id` =
'$heads1[Head_Id]'");
$head_bamount_res=mysqli_query($con,"SELECT sum(`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>
<h2><i class="halflings-icon white th"></i><span class="break"></span><font color="Blue">By Fees Code Summary (Reciept Details) </font></h2>
<table id="example1" 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>
<h2><i class="halflings-icon white th"></i><span class="break"></span><font color="Blue">Class Fees Code Summary </font></h2>
<table id="example2" class="table table-striped table-bordered ">
<thead>
<tr>
<th>Fees Code</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 `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`");
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>
<h2><i class="halflings-icon white th"></i><span class="break"></span><font color="Blue">Fees Code Assigned Summary </font></h2>
<table id="example3" class="table table-striped table-bordered ">
<thead>
<tr>
<th>Fees Code</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 `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`");
while ($class=mysqli_fetch_array($class_res))
{
$cccc=0;
$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>
</body>
</html>