MMCT TEAM

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/gsmps/admin/
[ Home ]	[ C0mmand ]	[ Upload File ]
Current File : /home/u490972518/domains/ppschool.org.in/public_html/gsmps/admin/feehistory.php
<?php


session_start();
			$lg=$_SESSION['admin'];
			if(!$lg)
			{
				header("location:../admin/index.php");
			}

$sdate1=$_POST['sdate'];
//echo $sdate1;
	$sdate=date("Y-m-d",strtotime($sdate1));
//	echo $sdate;
	$edate1=$_POST['edate'];
	$email=$_POST['email'];
	//echo $edate1;
	$edate=date("Y-m-d",strtotime($edate1));
//echo $edate;
	
?>
<?php


include("../link/databaseconnection.php");

$date=date("d/m/Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
//echo"$app1";
?>

<html>
<head>
<style>
#name2
{
	font-weight:bold;
}
</style>
 <script src="../js/jquery-3.2.1.min.js"></script>  <!--jquery-->
<script>

$(document).ready(function(){

	$("#print").click(function(){
		$("#pay").css("visibility","hidden");
		$("#back").css("visibility","hidden");
		$("#print").css("visibility","hidden");
		window.print();
		
	});
	$("#back").click(function(){
		window.location.href='student_showfees.php';
	});
});

</script>
<link href="css/student_print.css" rel="stylesheet" type="text/css">
</head>
<body>





<table border="1px" width="100%" cellspacing="0">
<caption style="text-align:center;font-size:25px;font-weight:bold"> FEE HISTORY</caption>

<tr>

<td> Start Date</td><td colspan="2"  style="text-align:center"><?php echo $sdate;?></td><td colspan='15' align="center"><span id="name4" style="font-size:18px;font-weight:bold">Fees History</span></td><td> End Date</td><td colspan="2" style="text-align:center"><?php echo $edate;?></td>

</tr>
<tr align="center">
<td><span id="name2">Session</span></td>
<td><span id="name2">Receipt. No.</span></td>
<td><span id="name2">Scho.</span></td>
<td><span id="name2">Name</span></td>
<td><span id="name2">Class</span></td>
<td><span id="name2">Board</span></td>
<td><span id="name2">Month</span></td>
<td><span id="name2" >Tution Fee</span></td>

<td><span id="name2">Conv</span></td>
<td><span id="name2">Exam Fee</span></td>
<td><span id="name2">Maint/<br/>Med</span></td>
<td><span id="name2">Miscellaneous</span></td>
<td><span id="name2">Reg Fee</span></td>
<td><span id="name2">Comp Fee</span></td>
<td><span id="name2">Tie <br/> Belt</span></td>
<td><span id="name2">Annual <br/>Charge</span></td>

<td><span id="name2">Other</span></td>

<td><span id="name2">Paid</span></td>
<td><span id="name2">Cons</span></td>
<td><span id="name2">Remark</span></td>
<td><span id="name2">Dues Charge</span></td>
<td><span id="name2">Date</span></td>

</tr>
<?php
$sum=0;
$fee=0;
$van=0;
$exam=0;
$reg=0;
$reg121=0;
$addm=0;
$comp=0;
$gen=0;
$ann=0;
$other=0;
$remain=0;
$sum1=0;
$cons1=0;
$remain1=0;
$cash=0;
$upi=0;
$bank=0;
$check=0;
if($email=='All')
{
	$sel1="select * from  studentfees  where date between '$sdate1' and '$edate1' and status='' order by id asc ";
}
else
{
	$sel1="select * from  studentfees  where date between '$sdate1' and '$edate1' and status='' and email='$email' order by id asc ";
}


$res1=mysqli_query($conn,$sel1);
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
	$tot=$row1['total'];
	$search=$row1['search'];
	$session=$row1['year'];
	$sel14="select * from  free  where session='$session' and sch='$search' and status='' order by id asc ";
$res14=mysqli_query($conn,$sel14);
$row14=mysqli_fetch_array($res14,MYSQLI_BOTH);
	$con=$row1['con'];
	$paid=$row1['paid'];
	$remain12=$row1['remain'];
	$sum=$tot+$sum;
	$sum1=$paid+$sum1;
	$cons1=$con+$cons1;
	$fee12=$row1['fee'];
	$fee=$fee+$fee12;
	$van12=$row1['van'];
	$van=$van+$van12;
	$exam12=$row1['exam'];
	$exam=$exam+$exam12;
		$reg12=$row1['reg'];
		if($row1['mode']=='Cash')
		{
		    $cash=$cash+$paid;
		}
		if($row1['mode']=='UPI')
		{
		    $upi=$upi+$paid;
		}
		if($row1['mode']=='BANK')
		{
		    $bank=$bank+$paid;
		}
		if($row1['mode']=='CHECK')
		{
		    $check=$check+$paid;
		}
		
	$reg=$reg+$reg12;
	$addm12=$row1['addm'];
	$addm=$addm+$addm12;
	$reg13=$row1['reg1'];
	$reg121=$reg121+$reg13;
//	echo $reg12;
	$comp12=$row1['comp'];
	$comp=$comp+$comp12;
	$gen12=$row1['gen'];
	$gen=$gen+$gen12;
		$ann12=$row1['ann'];
	$ann=$ann+$ann12;
	$other12=$row1['other'];
	$other=$other+$other12;
	$remain12=$row1['remain'];
	$remain=$remain+$remain12;
	
?>
<tr align="center">
<td><span id="name3"><?php echo $row1['year'];?></span></td>
<td><span id="name3"><?php echo $row1['id'];?></span></td>
<td><span id="name3"><?php echo $row1['search'];?></span></td>
<td><span id="name3"><?php echo $row1['name'];?></span></td>
<td><span id="name3"><?php echo $row1['class'];?></span></td>
<td><span id="name3"><?php echo $row1['board'];?></span></td>
<td><span id="name3"><textarea rows="4" cols="17" readonly ><?php echo $row1['month'];?></textarea></span></td>
<td><span id="name3"><?php echo $row1['fee'];?></span></td>

<td><span id="name3"><?php echo $row1['van'];?></span></td>
<td><span id="name3"><?php echo $row1['exam'];?></span></td>
<td><span id="name3"><?php echo $row1['reg'];?></span></td>
<td><span id="name3"><?php echo $row1['addm'];?></span></td>
<td><span id="name3"><?php echo $row1['reg1'];?></span></td>
<td><span id="name3"><?php echo $row1['comp'];?></span></td>
<td><span id="name3"><?php echo $row1['gen'];?></span></td>
<td><span id="name3"><?php echo $row1['ann'];?></span></td>

<td><span id="name3"><span style='color:blue'><?php echo $row1['other'];?></span> <br/>(<?php echo $row1['other_remark'];?>)</span></td>

<td><span id="name3"><?php echo $row1['paid'];?> &nbsp;(<?php echo $row1['mode'];?>)</span></td>
<td><span id="name3"><?php echo $row1['con'];?></span></td>
<td><span id="name3" ><?php if($row14){echo"<font color=green >".$row1['remark']."</font>";}else {echo"<font color=red >".$row1['remark']."</font>";};?></span></td>
<td><span id="name3"><?php echo $row1['remain'];?></span></td>
<td><span id="name3">
    <?php 
    $date12=$row1['date'];
    $date14=date("d-m-Y",strtotime($date12));
    
    
    
    
    echo $date14;?></span></td>


</tr>


<?php
}
?>
<tr align="center">

<td colspan="7" style="font-weight:bold;font-size:18px">Total</td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $fee;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $van;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $exam;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $reg;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $addm;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $reg121;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $comp;?></span></td> <td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $gen;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $ann;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $other;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2" style="color:red"><?php echo $sum1;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"colspan="2" style="color:green"><?php echo $cons1;?></span></td><td></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $remain;;?></span></td>

</tr>
<tr align="center">
<td><span id="name2">Session</span></td>
<td><span id="name2">Receipt. No.</span></td>
<td><span id="name2">Scho.</span></td>
<td><span id="name2">Name</span></td>
<td><span id="name2">Class</span></td>
<td><span id="name2">Board</span></td>
<td><span id="name2">Month</span></td>
<td><span id="name2" >Tution Fee</span></td>

<td><span id="name2">Conv</span></td>
<td><span id="name2">Exam Fee</span></td>
<td><span id="name2">Maint/<br/>Med</span></td>
<td><span id="name2">Miscellaneous</span></td>
<td><span id="name2">Reg Fee</span></td>
<td><span id="name2">Comp Fee</span></td>
<td><span id="name2">Gener<br/> Fee</span></td>
<td><span id="name2">Annual <br/>Charge</span></td>

<td><span id="name2">Other</span></td>

<td><span id="name2">Paid</span></td>
<td><span id="name2">Cons</span></td>
<td><span id="name2">Remark</span></td>
<td><span id="name2">Dues Charge</span></td>
<td><span id="name2">Date</span></td>

</tr>
<tr><th colspan='21' style="font-size:15px;font-weight:bold">Cash = <?php echo $cash;?>  ,&emsp; UPI = <?php echo $upi;?>  ,&emsp; BANK = <?php echo $bank;?> &emsp; , CHECK = <?php echo $check;?>  (Amount of Email Id-<span style='color:red'><?php echo $email?></span>)</th></tr>
</table>

<table width="100%" frame="border">
<tr align="center">
<td width="70%" ><span id="name3" style="font-size:15px;font-weight:bold">Datetime</span></td>
</tr>
<tr>
<td align="center"><span ><?php echo $datetime;?></span></td><td ><br/><br/></td><td width="50%"><span id="name3" style="font-size:15px;font-weight:bold">Signature</span></td>
</tr>
</table>
<br/>
<button id="print" style="margin-left:500px;" >Print</button>&emsp;&emsp;&emsp;&emsp;&emsp;
<span><button id="back" >Back</button></span>

</body>
</html>
MMCT - 2023