|
Server IP : 2a02:4780:3:1378:0:3736:a38e:10 / Your IP : 18.219.214.90 Web Server : LiteSpeed System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 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(!isset($_SESSION['user']) && !isset($_SESSION['Mng_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");
}
// Everything below this point in the file is secured by the login system
// We can display the user's username to them by reading it from the session array. Remember that because
// a username is user submitted content we must use htmlentities on it before displaying it to the user.
?>
<?php include "config/config.php";
$r=mysqli_query($con,"select * from class");
$r1=mysqli_query($con,"select * from division");
$r2=mysqli_query($con,"select * from head ");
?>
<!DOCTYPE html>
<html>
<head>
<!-- start: Meta -->
<meta charset="utf-8">
<title>Receipt Report List</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'>
<!-- end: CSS -->
<!-- The HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<link id="ie-style" href="css/ie.css" rel="stylesheet">
<![endif]-->
<!--[if IE 9]>
<link id="ie9style" href="css/ie9.css" rel="stylesheet">
<![endif]-->
<!-- start: Favicon -->
<link rel="shortcut icon" href="img/favicon.ico">
<!-- end: Favicon -->
<style type="text/css">
<!--
.style1 {
color: #3300CC;
font-weight: bold;
}
.style2 {
color: #FF0000;
font-weight: bold;
}
.style4 {
color: #CC00FF;
font-weight: bold;
}
-->
</style>
<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">
$.fn.dataTable.ext.errMode = 'none';
$(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>
<style>
.table-responsive {
display: block;
width: 100%;
overflow-x: auto;
-webkit-overflow-scrolling: touch;
-ms-overflow-style: -ms-autohiding-scrollbar;
}
</style>
</head>
<body onLoad="myFunction()">
<!-- start: Header -->
<!-- start: Header -->
<div class="table-responsive">
<table width="945" border="3" align="center">
<tr>
<td width="313">Fees Code:
<?php if($d=isset($_POST["head"]))
{
$sql6=mysqli_query($con,"SELECT * FROM `head` WHERE `Head_Id` = '$_POST[head]'");
$row9=mysqli_fetch_array($sql6);
echo "<font color='Blue'><b> $row9[Name] </b> </font>";
}
?> </td>
<td>Class:<?php if($e=isset($_POST["Class"]))
{
echo "<font color='Blue'><b> $_POST[Class] </b> </font>";
}
?></td>
<td>Division:<?php if($f=isset($_POST["Division"]))
{
echo "<font color='Blue'><b> $_POST[Division] </b> </font>";
}
?></td>
</tr>
</table>
</div>
<br>
<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 user"></i><span class="break"></span>Students</h2>
<div class="box-icon">
</div>
</div>
<div class="box-content" >
<?php
?>
<div class="table-responsive">
<table id="example" class="table table-striped table-bordered bootstrap-datatable datatable">
<thead>
<tr>
<th>Sr. No.</th>
<th>Class</th>
<th>Div</th>
<th>Student Name</th>
<th>Fees Code</th>
<th>Total</th>
<th>Balance</th>
<th>Date</th>
<th>Recipt No.</th>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
if (isset($_POST['Subb']))
if ($_POST['Subb'] != NULL)
{
$Subb=$_POST["Subb"];
}
if (isset($_POST['head']))
if ($_POST['head'] != NULL)
{
$Head_Id=$_POST["head"];
}
?>
<?php
if($Subb == "Yes")
{ ?>
<?php
$qu=mysqli_query($con,"select `SubHeads` from head where `Head_Id` = '$Head_Id'");
$qu1=mysqli_fetch_array($qu);
$qu2=explode("/",$qu1[0]);
foreach($qu2 as $qu3)
{ ?>
<th><?php
$qu4=mysqli_query($con,"select `Name` from sub_head where `Sub_Id` = '$qu3'");
$qu5=mysqli_fetch_array($qu4);
echo $qu5[0]; ?></th>
<?php
}
?>
<?php }else
{
?><th>
<?php
echo"Amount";
?>
</th>
<?php
}
}
?>
</tr>
</thead>
<tbody>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
$argu="";
if (isset($_POST['Class']))
if ($_POST['Class'] != NULL)
{
$Class=$_POST["Class"];
$argu=$argu."and stud_basic.Class='$Class'";
}
if (isset($_POST['Division']))
if ($_POST['Division'] != NULL)
{
$Division=$_POST["Division"];
$argu=$argu." and stud_basic.Division='$Division'";
}
if (isset($_POST['head']))
if ($_POST['head'] != NULL)
{
$Head_Id=$_POST["head"];
$argu=$argu."and paid_fees.Head_Id='$Head_Id'";
}
if (isset($_POST['Subb']))
if ($_POST['Subb'] != NULL)
{
$Subb=$_POST["Subb"];
}
?>
<?php
$sqll= "SELECT paid_fees.Recipt_No, stud_basic.Class, stud_basic.Division, stud_basic.Name, paid_fees.Head_Id,
paid_fees.Grand_Total, paid_fees.Paid_date, stud_basic.Stud_Id, paid_fees.Mode, paid_fees.DateNumber,
paid_fees.Recp_Book_No AS recpno
FROM stud_basic
INNER JOIN stud_basic2 ON stud_basic.Stud_Id = stud_basic2.Stud_Id
INNER JOIN (
SELECT Stud_Id, MAX(Paid_date) AS Last_Paid_date
FROM paid_fees
GROUP BY Stud_Id
) AS last_paid_dates ON stud_basic2.Stud_Id = last_paid_dates.Stud_Id
INNER JOIN paid_fees ON stud_basic2.Stud_Id = paid_fees.Stud_Id
AND last_paid_dates.Stud_Id = paid_fees.Stud_Id
AND last_paid_dates.Last_Paid_date = paid_fees.Paid_date
INNER JOIN head ON head.Head_Id = paid_fees.Head_Id
WHERE '0' = '0' $argu
GROUP BY paid_fees.Recipt_No, stud_basic.Class, stud_basic.Division, stud_basic.Name, paid_fees.Head_Id,
paid_fees.Grand_Total, paid_fees.Paid_date, stud_basic.Stud_Id, paid_fees.Mode, paid_fees.DateNumber,
paid_fees.Recp_Book_No";
//echo "$sqll<br>";
$res=mysqli_query($con,$sqll);
$ii=1;
while($data=mysqli_fetch_array($res))
{
//$cc=sizeof($data);
//echo "cc=$cc<br>$sqll";
//echo "$sqll";
?><tr>
<?php
$hd_res=mysqli_query($con,"select * from head where Head_Id = '$data[4]'");
$hd=mysqli_fetch_array($hd_res);
$Stud_Id=$data['Stud_Id'];
$tmp_rs=mysqli_query($con,"select SUM(stud_basic2.Total_Amount) AS Total_Amount,SUM(stud_basic2.Balance) AS Balance from stud_basic2 where Head_Id = '$data[4]' AND Stud_Id=$Stud_Id");
$pt_res=mysqli_fetch_array($tmp_rs);
?>
<td><?php echo $ii++; ?></td>
<td><?php echo $data['1']; ?></td>
<td><?php echo $data['2']; ?></td>
<td><a href="stud_profile.php?key=<?php echo "$data[Stud_Id]"; ?>" ><?php echo "$data[3]"; ?></a></td>
<td><?php echo $hd['Name']; ?> </td>
<td><?php echo $pt_res['Total_Amount']; ?></td>
<td><?php echo $pt_res['Balance']; ?></td>
<td><?php echo $data['6']; ?></td>
<td><?php echo $data['0']; ?></td>
<?php
if($Subb == "Yes")
{ ?>
<?php
$qu=mysqli_query($con,"select `SubHeads` from head where `Head_Id` = '$Head_Id'");
$qu1=mysqli_fetch_array($qu);
$qu2=explode("/",$qu1[0]);
foreach($qu2 as $qu3)
{ ?>
<td><?php
$qu4=mysqli_query($con,"select * from sub_head where `Sub_Id` = '$qu3'");
$qu5=mysqli_fetch_array($qu4);
$paid_res=mysqli_query($con,"SELECT * FROM `paid_fees` WHERE `Recipt_No` = '$data[recpno]'");
$paid=mysqli_fetch_array($paid_res);
$subid_arr=explode("/",$paid['Subhead_Ids']);
$amount_arr=explode("/",$paid['Sub_Amounts']);
$index= array_search($qu3,$subid_arr,true);
if($index != ""){
echo $amount_arr[$index];
}else{
echo "0";
}
?></td>
<?php
}
?>
<?php
}else
{
?><td>
<?php
echo $data['5'];
?>
</td>
<?php
}
?>
<?php
}
?>
</tr> <?php
}
?>
</tbody>
</table>
</div>
</div> </div> </div>
<div class="clearfix"></div>
<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>
</body>
</html>