|
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
error_reporting(0);
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:../admin/index.php");
}
$search=$_REQUEST['flag'];
//echo $search;
?>
<?php
include("../link/databaseconnection.php");
$sel4="select * from registration where application ='$search' and session='2018-2019'";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$sel12="select * from studentfees where search ='$search' order by id desc";
$res12=mysqli_query($conn,$sel12);
$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
$search=$row12['search'];
$idd=$row12['id'];
$id12=$idd-1;
//echo $id12;
$sel121="select * from studentfees where search ='$search' and id='$idd' ";
$res121=mysqli_query($conn,$sel121);
$row121=mysqli_fetch_array($res121,MYSQLI_BOTH);
$date12=date("d-m-Y");
$sel1="select * from studentfees where search ='$search' ";
$res1=mysqli_query($conn,$sel1);
$sel10="select * from studentfees where search ='$search' order by id desc ";
$res10=mysqli_query($conn,$sel10);
$row10=mysqli_fetch_array($res10,MYSQLI_BOTH);
$selde="select * from studentfees where search ='$search' order by id desc limit 2 ";
$resde=mysqli_query($conn,$selde);
$rowde=mysqli_fetch_array($resde,MYSQLI_BOTH);
$idd=$rowde['id'];
//echo $idd;
$selmo="select * from studentfees where search ='$search' order by id desc ";
$resmo=mysqli_query($conn,$selmo);
$month12='';
while($rowmo=mysqli_fetch_array($resmo,MYSQLI_BOTH))
{
$month13=$rowmo['month'];
$month12=$month13.",".$month12;
}
//echo $date;
//echo"$app1";
?>
<html>
<head>
<style>
#name2
{
}
</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_details1.php';
});
});
</script>
<style>
.a{
width:46%;
float:left;
}
@media print
{
.a{width:46%;}
.ab{width:5%;}
.sd{font-size:11px;}
#name7{font-size:10px;}
}
@media print
{
table{width:100%;}
#mo{width:230px;}
}
</style>
<link href="css/student_print.css" rel="stylesheet" type="text/css">
</head>
<body>
<script>
$(document).ready(function(){
var p=$("#pay").val();
});
</script>
<?php
/**
* Created by PhpStorm.
* User: sakthikarthi
* Date: 9/22/14
* Time: 11:26 AM
* Converting Currency Numbers to words currency format
*/
$number = $row10['paid'];
$no = round($number);
$point = round($number - $no, 2) * 100;
$hundred = null;
$digits_1 = strlen($no);
$i = 0;
$str = array();
$words = array('0' => '', '1' => 'One', '2' => 'Two',
'3' => 'Three', '4' => 'Four', '5' => 'Five', '6' => 'Six',
'7' => 'Seven', '8' => 'Eight', '9' => 'Nine',
'10' => 'Ten', '11' => 'Eleven', '12' => 'Twelve',
'13' => 'Thirteen', '14' => 'Fourteen',
'15' => 'Fifteen', '16' => 'Sixteen', '17' => 'Seventeen',
'18' => 'Eighteen', '19' =>'Nineteen', '20' => 'Twenty',
'30' => 'Thirty', '40' => 'Forty', '50' => 'Fifty',
'60' => 'Sixty', '70' => 'Seventy',
'80' => 'Eighty', '90' => 'Ninety');
$digits = array('', 'Hundred', 'Thousand', 'Lakh', 'Crore');
while ($i < $digits_1) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += ($divider == 10) ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number] .
" " . $digits[$counter] . $plural . " " . $hundred
:
$words[floor($number / 10) * 10]
. " " . $words[$number % 10] . " "
. $digits[$counter] . $plural . " " . $hundred;
} else $str[] = null;
}
$str = array_reverse($str);
$result = implode('', $str);
$points = ($point) ?
"." . $words[$point / 10] . " " .
$words[$point = $point % 10] : '';
?>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script>
function getIndianCurrency(float $number)
{
$decimal = round($number - ($no = floor($number)), 2) * 100;
$hundred = null;
$digits_length = strlen($no);
$i = 0;
$str = array();
$words = array(0 => '', 1 => 'one', 2 => 'two',
3 => 'three', 4 => 'four', 5 => 'five', 6 => 'six',
7 => 'seven', 8 => 'eight', 9 => 'nine',
10 => 'ten', 11 => 'eleven', 12 => 'twelve',
13 => 'thirteen', 14 => 'fourteen', 15 => 'fifteen',
16 => 'sixteen', 17 => 'seventeen', 18 => 'eighteen',
19 => 'nineteen', 20 => 'twenty', 30 => 'thirty',
40 => 'forty', 50 => 'fifty', 60 => 'sixty',
70 => 'seventy', 80 => 'eighty', 90 => 'ninety');
$digits = array('', 'hundred','thousand','lakh', 'crore');
while( $i < $digits_length ) {
$divider = ($i == 2) ? 10 : 100;
$number = floor($no % $divider);
$no = floor($no / $divider);
$i += $divider == 10 ? 1 : 2;
if ($number) {
$plural = (($counter = count($str)) && $number > 9) ? 's' : null;
$hundred = ($counter == 1 && $str[0]) ? ' and ' : null;
$str [] = ($number < 21) ? $words[$number].' '. $digits[$counter]. $plural.' '.$hundred:$words[floor($number / 10) * 10].' '.$words[$number % 10]. ' '.$digits[$counter].$plural.' '.$hundred;
} else $str[] = null;
}
$Rupees = implode('', array_reverse($str));
$paise = ($decimal) ? "." . ($words[$decimal / 10] . " " . $words[$decimal % 10]) . ' Paise' : '';
return ($Rupees ? $Rupees . 'Rupees ' : '') . $paise .;
}
</script>
<div style="border:1px solid" class="a">
<table frame="border" width="100%" >
<tr>
<td><span><img src="../images/logo2.png" height="50px" width="50px"/></span></td><td align="center"><span id="name" style="font-size:12px;text-align:left;font-weight:bold">Gloriole Convent School <br/>Navodaya Nagar,Jiyanpur Azamgarh </span></td><td style="font-size:12px;text-align:right"><b>Contact: </b>9450677302<br/>9450119224<br/><b>Web-</b>gcschool.co.in</td>
</tr>
</table>
<table border="1px;" width="100%"cellspacing="0">
<caption style="font-size:13px;font-weight:bold">Fee Receipt</caption>
<tr>
<td><span id="name2" style="font-size:11px;font-weight:bold">Scho. Number</span></td><td colspan="2"><span style="font-size:11px"><?php echo $row12['search'];?> (Sr.-<?php echo $row12['id'];?>)</span></td><td align="center" rowspan="2"><span><img src="../code/img/<?php echo $row4['picture'];?>" style="width:50px;height:50px" class="img-responsive" ></span></td>
</tr>
<tr>
<td ><span id="name2" style="font-size:11px;font-weight:bold">Student Name</span></td><td colspan='2'><span style="font-size:11px"><?php echo $row12['name'];?></span></td>
</tr>
<tr>
<td ><span id="name2" style="font-size:11px;font-weight:bold"> Father Name</span></td><td><span style="font-size:11px"><?php echo $row4['fname'];?></span></td><td style="font-size:11px"><b>Class</b></td><td style="font-size:11px"><?php echo $row10['class'];?></td>
</tr>
</table>
<table frame="border" cellspacing="0" height="25%">
<tr>
<td colspan='4' align="center"><span id="name4" style="font-size:13px;font-weight:bold">Fees Category</span></td>
</tr>
<tr >
<td align="center" style="border: 1px solid black"><span id="name2" ><b>Month</b></span></td><td colspan="12" style="border: 1px solid black"><textarea id="mo" style="font-weight:bold;font-size:10px;resize:none" rows="3" cols="70"><?php echo $row121['month'];?></textarea></td>
</tr>
<tr align="center">
<td width="25%"><span id="name2" >Reg</span></td>
<td width="25%"><span id="name2" ><?php if($row10['reg1']=='0'){echo '';}else{echo $row10['reg1'];}?></span></td>
<td width="25%" style="border: 1px solid black"><span id="name2" ></span></td>
<td width="25%" style="border: 1px solid black"></span></td>
</tr>
<tr align="center">
<td width="25%"><span id="name2" >Annual</span></td>
<td width="25%"><span id="name2" ><?php if($row10['ann']=='0'){echo '';}else{echo $row10['ann'];}?></span></td>
<td width="25%" style="border: 1px solid black"><span id="name2" >Month Fee</span></td>
<td width="25%" style="border: 1px solid black"><span id="name2" ><?php if($row10['fee']=='0'){echo '';}else{echo $row10['fee'];}?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Addm</span></td>
<td><span id="name2" ><?php if($row10['addm']=='0'){echo '';}else{echo $row10['addm'];}?></td>
<td style="border: 1px solid black"><span id="name2" >Conv</span></td>
<td style="border: 1px solid black"><span id="name2" ><?php echo $row12['van'];?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Exam</span></td>
<td><span id="name2" ><?php if($row10['exam']=='0'){echo '';}else{echo $row10['exam'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" >Pre Dues</span></td>
<td style="border: 1px solid black"><span id="name2" ><?php if($row10['pre']=='0'){echo '';}else{echo $row10['pre'];}?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Comp </span></td>
<td><span id="name2" ><?php if($row10['comp']=='0'){echo '';}else{echo $row10['comp'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold">Total</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['total']; ?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Maint/Med</span></td>
<td><span id="name2" ><?php if($row10['reg']=='0'){echo '';}else{echo $row10['reg'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold" >Cons</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['con'];?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Generator</span></td>
<td><span id="name2" ><?php if($row10['gen']=='0'){echo '';}else{echo $row10['gen'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold" >Paid</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['paid'];?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Other</span></td>
<td><span id="name2" ><?php if($row10['other']=='0'){echo '';}else{echo $row10['other'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold">New Dues</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['remain'];?></span></td>
</tr>
<br/>
<tr >
<td colspan="4" style="text-align:center">
<p style="font-size:12px"><b>Paid-</b> <?php echo $result . "Rupees " . $points . " Only.";?></p>
</td>
</tr>
<?php
$tot='0';
$paid16='0';
$due16='0';
$con12='0';
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$tot1=$row1['mtotal'];
$paid15=$row1['paid'];
$con=$row1['con'];
$remain15=$row1['remain'];
$tot16=$remain15+$paid15+$con;
$due16=$remain15+$due16;
$con12=$con+$con12;
$tot=$tot16+$tot;
$paid16=$paid16+$paid15;
?>
<?php
}
?>
</table>
<table>
<tr>
<td width="10%">Date</td><td width="40%"><?php
$date12=$row10['date'];
$date14=date("d-m-Y",strtotime($date12));
echo $date14;?></td><td width="50%" align="right" style="font-size:11px"><br/><br/><br/><br/>Sign Of Received Staff</td>
</tr>
</table>
</div>
<div class="ab" style="float:left;width:5%">--</div>
 <div style="border:1px solid" class="a">
<table frame="border" width="100%" >
<tr>
<td><span><img src="../images/logo2.png" height="50px" width="50px"/></span></td><td align="center"><span id="name" style="font-size:12px;text-align:left;font-weight:bold" class="sd">Gloriole Convent School <br/>Navodaya Nagar,Jiyanpur Azamgarh </span></td><td style="font-size:12px;text-align:right"><b>Contact: </b>9450677302<br/>9450119224<br/><b>Web-</b>gcschool.co.in</td>
</tr>
</table>
<table border="1px;" width="100%"cellspacing="0">
<caption style="font-size:13px;font-weight:bold">Fee Receipt</caption>
<tr>
<td><span id="name2" style="font-size:11px;font-weight:bold">Scho. Number</span></td><td colspan="2"><span style="font-size:11px"><?php echo $row12['search'];?> (Sr.-<?php echo $row12['id'];?>)</span></td><td align="center" rowspan="2"><span><img src="../code/img/<?php echo $row4['picture'];?>" style="width:50px;height:50px" class="img-responsive" ></span></td>
</tr>
<tr>
<td ><span id="name2" style="font-size:11px;font-weight:bold">Student Name</span></td><td colspan='2'><span style="font-size:11px"><?php echo $row12['name'];?></span></td>
</tr>
<tr>
<td ><span id="name2" style="font-size:11px;font-weight:bold"> Father Name</span></td><td><span style="font-size:11px"><?php echo $row4['fname'];?></span></td><td style="font-size:11px"><b>Class</b></td><td style="font-size:11px"><?php echo $row10['class'];?></td>
</tr>
</table>
<table frame="border" width="100%" cellspacing="0" height="25%">
<tr>
<td colspan='4' align="center"><span id="name4" style="font-size:13px;font-weight:bold">Fees Category</span></td>
</tr>
<tr >
<td align="center" style="border: 1px solid black"><span id="name2" ><b>Month</b></span></td><td colspan="12" style="border: 1px solid black ;width:50%"><textarea id="mo" class="mo" style="font-weight:bold;font-size:10px;resize:none" rows="3" cols="70"><?php echo $row121['month'];?></textarea></td>
</tr>
<tr align="center">
<td width="25%"><span id="name2" >Reg</span></td>
<td width="25%"><span id="name2" ><?php if($row10['reg1']=='0'){echo '';}else{echo $row10['reg1'];}?></span></td>
<td width="25%" style="border: 1px solid black"><span id="name2" ></span></td>
<td width="25%" style="border: 1px solid black"></span></td>
</tr>
<tr align="center">
<td width="25%"><span id="name2" >Annual</span></td>
<td width="25%"><span id="name2" ><?php if($row10['ann']=='0'){echo '';}else{echo $row10['ann'];}?></span></td>
<td width="25%" style="border: 1px solid black"><span id="name2" >Month Fee</span></td>
<td width="25%" style="border: 1px solid black"><span id="name2" ><?php if($row10['fee']=='0'){echo '';}else{echo $row10['fee'];}?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Addm</span></td>
<td><span id="name2" ><?php if($row10['addm']=='0'){echo '';}else{echo $row10['addm'];}?></td>
<td style="border: 1px solid black"><span id="name2" >Conv</span></td>
<td style="border: 1px solid black"><span id="name2" ><?php echo $row12['van'];?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Exam</span></td>
<td><span id="name2" ><?php if($row10['exam']=='0'){echo '';}else{echo $row10['exam'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" >Pre Dues</span></td>
<td style="border: 1px solid black"><span id="name2" ><?php if($row10['pre']=='0'){echo '';}else{echo $row10['pre'];}?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Comp </span></td>
<td><span id="name2" ><?php if($row10['comp']=='0'){echo '';}else{echo $row10['comp'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold">Total</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['total']; ?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Maint/Med</span></td>
<td><span id="name2" ><?php if($row10['reg']=='0'){echo '';}else{echo $row10['reg'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold" >Cons</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['con'];?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Generator</span></td>
<td><span id="name2" ><?php if($row10['gen']=='0'){echo '';}else{echo $row10['gen'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold" >Paid</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['paid'];?></span></td>
</tr>
<tr align="center">
<td><span id="name2" >Other</span></td>
<td><span id="name2" ><?php if($row10['other']=='0'){echo '';}else{echo $row10['other'];}?></span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold">New Dues</span></td>
<td style="border: 1px solid black"><span id="name2" style="font-weight:bold"><?php echo $row10['remain'];?></span></td>
</tr>
<br/>
<tr >
<td colspan="4" style="text-align:center">
<p style="font-size:12px"><b>Paid-</b> <?php echo $result . "Rupees " . $points . " Only.";?></p>
</td>
</tr>
<?php
$tot='0';
$paid16='0';
$due16='0';
$con12='0';
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$tot1=$row1['mtotal'];
$paid15=$row1['paid'];
$con=$row1['con'];
$remain15=$row1['remain'];
$tot16=$remain15+$paid15+$con;
$due16=$remain15+$due16;
$con12=$con+$con12;
$tot=$tot16+$tot;
$paid16=$paid16+$paid15;
?>
<?php
}
?>
</table>
<table>
<tr>
<td width="10%">Date</td><td width="40%"><?php
$date12=$row10['date'];
$date14=date("d-m-Y",strtotime($date12));
echo $date14;?></td><td width="50%" align="right" style="font-size:11px"><br/><br/><br/><br/>Sign Of Received Staff</td>
</tr>
</table>
</div>
</div>
<br/>
<button id="print" style="margin-left:500px;" >Print</button>     
<span><button id="back" >Back</button></span>
</body>
</html>