|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.161 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/swrampyarejan.in/public_html/link/../admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include("../link/databaseconnection.php");
error_reporting(0);
session_start();
$id=$_REQUEST['flag'];
$sel41="select * from fees_paid where id ='$id' order by id desc";
$res41=mysqli_query($conn,$sel41);
$row41=mysqli_fetch_array($res41,MYSQLI_BOTH);
$sch=$row41['sch'];
$session=$row41['session'];
$pr=$row41['pr'];
//echo $sch;
$date=$row41['date'];
//echo $month;
$date20=date("d-m-Y",strtotime($date));
//echo $date;
date_default_timezone_set("asia/kolkata");
$time=date("h:i:sa");
?>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<?php
$sel4="select * from registration where application ='$sch' and session='$session' and status='' order by id desc";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$reg_id=$row4['id'];
$sel12="select * from fees_paid WHERE id='$id' and status='' ";
$res12=mysqli_query($conn,$sel12);
$row12=mysqli_fetch_array($res12,MYSQLI_BOTH);
$sch=$row12['sch'];
$idd=$row12['id'];
$id12=$idd-1;
//echo $id12;
$date12=date("d-m-Y");
$sel1="select * from fees_paid where id='$id' and status='' ";
$res1=mysqli_query($conn,$sel1);
$sel10="select * from fees_paid WHERE id='$id' and status='' order by id desc ";
$res10=mysqli_query($conn,$sel10);
$row10=mysqli_fetch_array($res10,MYSQLI_BOTH);
$pr=$row10['pr'];
$selde="select * from fees_paid where id='$id' and status='' 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 fees_paid where id='$id' and status='' order by id desc ";
$resmo=mysqli_query($conn,$selmo);
$month12='';
$rowmo=mysqli_fetch_array($resmo,MYSQLI_BOTH);
$month12=$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();
window.close();
});
$("#back").click(function(){
window.location.href='student_details1.php';
});
});
</script>
<style>
.a{
width:47%;
float:left;
}
body{
-webkit-print-color-adjust:exact !important;
print-color-adjust:exact !important;
}
@media print
{
print-color-adjust: exact;
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>
<center><div style="border:1px solid;width:80%" class="a">
<table frame="border" width="100%" >
<tr>
<td><span><img src="../images/logo.png" height="50px" width="50px"/></span></td><td align="left"><span id="name" style="font-size:13px;text-align:left;font-weight:bold">PARAMOUNT INTERNATIONAL SCHOOL</span><br/><span style='font-size:12px'>THE LAND OF WISDOM</span><br/><span style='font-size:10px'>Dhanauli , Doharighat, [Uttar Pradesh] </span></td><td style=' border-left: double;'><div style='margin-left:5px'><span style='font-size:10px;'>Registration/Affilatio No.</span><br/><span style='font-size:11px;'>MAU096290960</span><br/><span style='font-size:10px'><i class="fa fa-phone-square"></i> 9473725359<br/><i class="fa fa-envelope"></i> paramountinternational739@gmail.com</span></div></td>
</tr>
</table>
<table border="1px;" width="100%"cellspacing="0" >
<tr style='background-color:gray'>
<td colspan='2' style='padding:3px'><span style='font-size:12px;color:white'>Fee Receipt</span></td><td colspan="2"><span style="font-size:11px;color:white">Session : <?php echo $row12['session'];?></span></td>
</tr>
<tr style='background-color:#D7D1D1'>
<td colspan='2' style='padding:3px'><span style='font-size:12px;color:black'> Receipt No: <?php echo $row10['id'];?></span></td><td colspan="2"><span style="font-size:11px;color:black">Date : <?php echo $date20;?></span></td>
</tr>
<tr>
<td style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold">Scho. Number</span></td><td colspan="2"><span style="font-size:11px"><?php echo $row4['sr'];?></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 style='padding:3px'><span id="name2" style="font-size:11px;font-weight:bold">Student Name</span></td><td colspan='2'><span style="font-size:11px"><?php echo $row4['name'];?></span></td>
</tr>
<tr>
<td style='padding:3px'><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 $row4['subject'];?>/<?php echo $row4['section'];?></td>
</tr>
</table>
<table frame="border" width="100%" height="25%">
<tr style='background-color:#D7D1D1'>
<td colspan='6' style='padding: 3px'><span style='font-size:13px;color:black;font-weight:bold;padding: 6px'>Month</span></td>
<td colspan="2" align="right" style='padding: 3px'><span style="font-size:13px;color:black;font-weight:bold;padding:6px">Tution </span></td>
<td colspan="2" align="right" style='padding: 3px'><span style="font-size:13px;color:black;font-weight:bold;padding:6px">Exam/Dev/Sport/Act./Adm </span></td>
<td colspan="2" align="right" style='padding: 3px'><span style="font-size:13px;color:black;font-weight:bold;padding:6px">Total </span></td>
</tr>
<?php
$sel101="select * from fees_data WHERE pr='$pr' and reg_id='$reg_id' and status='Yes' ";
$res101=mysqli_query($conn,$sel101);
while($row101=mysqli_fetch_array($res101,MYSQLI_BOTH))
{
$month_name=$row101['month_name'];
$sel44="select * from plan where id ='$month_name'";
$res44=mysqli_query($conn,$sel44);
$row44=mysqli_fetch_array($res44,MYSQLI_BOTH);
?>
<tr >
<td width="25%" colspan='6' align="left" style='padding: 2px;'><span id="name2" ><?php echo $row44['month'];?></span></td>
<td width="25%" colspan='2' align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row101['fees']=='0'){echo '';}else{echo $row101['fees'];}?> </span></td>
<td width="25%" colspan='2' align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row101['exam']=='0'){echo '';}else{echo $row101['exam'];}?> </span></td>
<td width="25%" colspan='2' align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php echo $al=$row101['fees']+ $row101['exam']?> </span></td>
</tr>
<?php }?>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Conv Fee</span></td>
<td width="25%" align="right" colspan='2' style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['conv']=='0'){echo '';}else{echo $row10['conv'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Exam Fee</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['exam']=='0'){echo '';}else{echo $row10['exam'];}?></span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Other Fee ( <?php echo $row10['remark']?>)</span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['other']=='0'){echo '';}else{echo $row10['other'];}?> </span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Old Dues </span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['pre_dues']=='0'){echo '';}else{echo $row10['pre_dues'];}?> </span></td>
</tr>
<tr align="left">
<td width="25%" style=";padding: 2px" colspan='10'><span id="name2" >Late Charge </span></td>
<td width="25%" align="right" style='border-left: 1px solid black;padding: 2px'><span id="name2" ><?php if($row10['late']=='0'){echo '';}else{echo $row10['late'];}?> </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:100px' >
<td colspan='10' style='border: 1px solid black;padding: 7px'><span style='font-size:13px;color:black;font-weight:bold'>Paymode Mode : <?php echo $row10['mode']?> </span></td><td colspan="2" align="right" style='border: 1px solid black;padding: 7px'><span style="font-size:13px;color:black;font-weight:bold"><?php echo $row10['total']?> Rs. </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='11'style='border: 1px solid black;padding: 7px;text-align:left' ><span style='font-size:13px;color:black;font-weight:bold'>Discount (<?php echo $row10['cons_remark']?>) : <?php if($row10['cons']=='0'){echo '';}else{echo $row10['cons'];}?> Rs.</span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='5'style='border: 1px solid black;padding: 7px;text-align:left' ><span style='font-size:13px;color:black;font-weight:bold'>Paid : <?php echo $row10['paid']?> Rs.</span></td><td colspan='6'style='border: 1px solid black;padding: 7px;text-align:center' ><span style='font-size:13px;color:black;'>Dues Fee : <?php echo $row10['remain']?> </span></td>
</tr>
<tr style='background-color:#D7D1D1;margin-top:40px' >
<td colspan='11'style='border: 1px solid black;padding: 7px;' ><span style='font-size:13px;color:black;'> Amount in Word : <?php echo $result . "Rupees " . $points . " Only.";?> </span></td>
</tr>
<tr style='background-color:;margin-top:40px' >
<td colspan='7'style='border: 1px solid black;padding: 7px;' ><br/><span style='font-size:11px;color:black;'> PRINCIPAL </span></td><td colspan='5'style='border: 1px solid black;padding: 7px;text-align:right' ><br/><span style='font-size:11px;color:black;'> ACCOUNTANT </td>
</tr>
<tr style='background-color:;margin-top:40px' >
<td colspan='7'style='border: 1px solid black;padding: 7px;' ><span style='font-size:11px;color:black;'> Print : <?php echo date('d-M-Y')?> : <?php echo $time;?> </span></td><td colspan='5'style='border: 1px solid black;padding: 7px;' ><span style='font-size:11px;color:black;'> Student strcmp </span></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['cons'];
$remain15=$row1['remain'];
$tot16=$remain15+$paid15+$con;
$due16=$remain15+$due16;
$con12=$con+$con12;
$tot=$tot16+$tot;
$paid16=$paid16+$paid15;
?>
<?php
}
?>
</table>
</div>
</center>
<br/>
<button id="print" style="margin-left:500px;" >Print</button>     
<span><button id="back" >Back</button></span>
</body>
</html>