|
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);
include('../link/databaseconnection.php');
session_start();
$lg=$_SESSION['admin'];
$id=$_REQUEST['flag'];
$session=$_REQUEST['flag2'];
$sel5="select *from registration where id='$id'";
$res5=mysqli_query($conn,$sel5);
$row5=mysqli_fetch_array($res5,MYSQLI_BOTH);
$application=$row5['application'];
$session=$row5['session'];
//echo $application;
$class=$row5['subject'];
$exam='HALF YEARLY EXAM';
$sel1="select * from fees where class='$class' and session='$session' ";
$res1=mysqli_query($conn,$sel1);
$row1=mysqli_fetch_array($res1,MYSQLI_BOTH);
$class1=$row1['class'];
$fees=$row1['fees'];
// $extra=600+$fees;
$sel12="select * from studentfees WHERE search ='$application' and year='$session' ";
$res12=mysqli_query($conn,$sel12);
$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
?>
<html>
<head>
<script src="../js/jquery-3.2.1.min.js"></script> <!--jquery-->
<script>
$(document).ready(function(){
$("#pay").click(function(){
window.location.href='bil.php';
});
});
$(document).ready(function(){
$("#print").click(function(){
$("#pay").css("visibility","hidden");
$("#back").css("visibility","hidden");
$("#print").css("visibility","hidden");
window.print();
//window.location.href='resultpg.php';
});
$("#back").click(function(){
window.location.href='student_details.php';
});
});
</script>
<style>
.graph-7{background: url("../images/kids.png") no-repeat ;}
.graph-image img{display: none;}
.graph-7{background-size:100% 100% ;}
@media print{
.graph-img img{display:inline;}
width:100%;
}
@media print {
* {
-webkit-print-color-adjust: exact;
}
}
td {
padding-top: .5em;
padding-bottom: .5em;
}
#header
{
height:70px;
background-color:red;
width:495px;
}
#logo
{
height:70px;
background-color:green;
width:70px;
float-left;
}
#name
{
height:70px;
background-color:yellow;
width:420px;
float-left;
}
.graph-7{background: url(../images/kids.png) no-repeat;
}
.graph-7{background-size:100% 100% ;}
.graph-image img{display: inline;
}
@media print{
.graph-image img{display:inline;}
}
td{font-size:12px;
font-weight:bold;
}
#p {font-size:13px;
text-transform: uppercase;}
</style>
<style type="text/css" media="print">
</style>
</head>
<body>
<?php
$y2= substr($row1['session'],5);
//echo '<br/>';
$y1= substr($row1['session'],0,4);
?>
<center>
<table frame="border" height="10%" width="100%" id="example">
<tr>
<td align="center" COLSPAN="5"><img src="../images/bonofide.jpg" style=""height="154px" width="100%"/><span></td>
</tr>
</table>
<div class="row graph-image graph-7" style="width:100%">
<table border="1px" width="100%" cellspacing="0">
<tr align="center">
<td colspan="7"><h2 style='color:#fc2204'><b><u>TO WHOMSOEVER IT MAY CONCERN YEAR : <?php echo $row1['session'];?></b></u></h2></td>
</tr>
<table cellspacing="0" border="1px" width="100%">
<tr>
<td colspan='7'><br/>
<p style='text-align: justify;letter-spacing: 1px;line-height: 1.8;font-size:13px;font-family: Verdana, serif;'>This is to certify that <span style='font-weight:bold'><?php echo $row5['name'];?></span> Son/Daughter of <span style='font-weight:bold'><?php echo $row5['fname'];?></span> and <span style='font-weight:bold'> <?php echo $row5['mname'];?></span> is a bonafide student of Class <span style='font-weight:bold'><?php echo $row5['subject'];?></span> in our school for academic year <span style='font-weight:bold'><?php echo $row5['session'];?> the total fees collection as part of Monthly Tution Fee from him/her is Rs <span style='font-weight:bold'><?php echo 12*$fees;?></span> for academic year <?php echo $row5['session'];?>. from 01-Apr-<?php echo $y1;?> to 31-Mar-<?php echo $y2;?>.
the student has paid the following fees.
</p></td>
</tr>
<tr align="center" style="font-weight:bold">
<td style="text-align:left" >SL.NO</td><td >FEE TYPE</td><td colspan='6'>AMOUNT</td>
</tr>
<tr align="center">
<td style="text-align:left">1</td><td >Monthly tution Fee</td><td><?php echo $number= 12*$fees;?>.00 Rs.</td>
</tr>
<tr align="center">
<?php
//$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>
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>
<td style="text-align:left" colspan='3'>Total Fees Paid: <?php echo $result . "Rupees " . $points . " Only.";?></td>
</tr>
<tr>
<td align="LEFT" colspan='3' style='font-weight:bold'><SPAN style='font-weight:bold'><br/><br/><br/><br/><br/><br/><br/><br/><i> <?php echo date('d-M-Y')?> <br/>Date</i></SPAN>               <i ></i>                    <i >Principal Signatute and Stamp</i>
<br/></br/>
<p style='text-align: justify;letter-spacing: 1px;line-height: 1.8;font-size:15px;font-family: Garamond, serif;'>Note: This certificate is being issued on the rquest of the parent for the purpose of income tax Proof Submission.</p>
</td>
</tr>
</table>
</div>
<?php
?><br/><br/><?php
?>
<br/>
<button id="print" style="margin-left:500px;" >Print</button>     
<span><button id="back" >Back</button></span>
</body>
</html>