|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.52 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 : ON Directory (0755) : /home/u490972518/domains/bpscps.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$id=$_REQUEST['id'];
$month=5;
include('../link/databaseconnection.php');
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:index.php");
}
$sel215="select * from plan where id='$month' ";
$res215=mysqli_query($conn,$sel215);
$row45=mysqli_fetch_array($res215,MYSQLI_BOTH);
// $monthNum = 3;
$sel1="select * from registration where id='$id' and status='' order by id asc ";
$res1=mysqli_query($conn,$sel1);
?>
<html>
<head>
<link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="https://cdn.datatables.net/buttons/1.5.1/css/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
<script src="//code.jquery.com/jquery-1.12.4.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"></script>
<script src="//cdn.datatables.net/buttons/1.5.1/js/buttons.flash.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/pdfmake.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.32/vfs_fonts.js"></script>
<script src="//cdn.datatables.net/buttons/1.5.1/js/buttons.html5.min.js"></script>
<script src="//cdn.datatables.net/buttons/1.5.1/js/buttons.print.min.js"></script>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['strcmp', 'csv', 'excel', 'pdf', 'print']
});
});
</script>
<style>
#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;
}
</style>
<style type="text/css" media="print">
@page
{
size: auto; /* auto is the initial value */
margin: 10mm; /* this affects the margin in the printer settings */
}
td{font-size:11px;
text-transform: uppercase;
}
#a{text-transform: capitalize;}
#b{text-transform: lowercase;}
</style>
</head>
<body>
<?php
$sel24="select * from session order by id desc limit 1,1";
$res24=mysqli_query($conn,$sel24);
$row24=mysqli_fetch_array($res24,MYSQLI_BOTH);
$session_old=$row24['session'];
$s=1;
$toamount=0;
$re_fee1=0;
$re_van1=0;
$re_dues=0;
$re_remain=0;
$re_exam=0;
$total1=0;
$van_fee1=0;
$remain1=0;
$tpaid1=0;
$comp_fee_c1=0;
$free1=0;
$total_fee=0;
$total_conv=0;
$total=0;
$re1=0;
$late_total=0;
$total_k=0;
while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$app=$row['application'];
$application=$row['application'];
$code=$row['code'];
$subject=$row['subject'];
$class=$row['subject'];
$session=$row['session'];
////////////for month show///////////
//echo $conc;
$sel248="select * from registration where session='$old_session' and application='$app' and status='' ";
$res248=mysqli_query($conn,$sel248);
/////for fees paid
$row248=mysqli_fetch_array($res248,MYSQLI_BOTH);
$sel21="select * from plan where id<='$month' ";
$res21=mysqli_query($conn,$sel21);
/////for fees paid
$mk=0;
$fees=0;$s=0;
$con_count=0;
$r=1;
$n='';
$t1=0;
$m_name='';
$m1=array();
while($row21=mysqli_fetch_array($res21,MYSQLI_BOTH))
{
$p_order= $row21['p_order'];
$m= $row21['id'];
$sel244="select * from fees where session='$session' and class='$class' and month='$m' ";
$res244=mysqli_query($conn,$sel244);
/////for fees paid
$row2=mysqli_fetch_array($res244,MYSQLI_BOTH);
$sel24="select * from fees_data where session='$session' and app='$app' and month_name='$m' and status='Yes' ";
$res24=mysqli_query($conn,$sel24);
/////for fees paid
$row24=mysqli_fetch_array($res24,MYSQLI_BOTH);
if(!$row24)
{
if($row21['id']>2) {$month12=array_push($m1,$m);};
if($m!='2')
{
$m_name=$row21['month'].','.$m_name;
}
//echo $m;
if($m==1)
{
if($row248)
{
$k1=0;
$k2=$row2['fees'];;
}
else
{
$k1=$row2['exam'];
$k2=$row2['fees'];
}
}
// echo '<br/>';
$n=$m.','.$n;
$con_count1=$row21['month_count'];
$con_count=$con_count+$con_count1;
$sel2="select * from fees where session='$session' and class='$class' and month='$m' ";
$res2=mysqli_query($conn,$sel2);
/////for fees paid
//echo $m;
// echo '<br/>';
$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
$mk1=$row2['exam']+$row2['fees'];
$mk=$mk1+$mk;
$sel23="select * from free where session='$session' and sch='$app' ";
$res23=mysqli_query($conn,$sel23);
/////for fees paid
$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
$fix=$row23['fix'];
$fee_free=$row23['fee'];
$conv_free=$code;
if($fix>0)
{
$f_fix=$fix;
}
else
{
$f_fix=0;
}
$f=$con_count*$f_fix;
$t1=$mk-$f;
if($t1>0){$t1=$t1;}else{$t1=0;}
}
else
{
// echo 'No';
}
//echo $con_count;
}
///////////
$conv_fees=$code*$con_count;
//echo'<br/>';
// echo $fees;
$fees=$row2['fees'];
/////
///
$application=$app;
$sel241="select * from fees_paid where session='$session' and sch='$app' and status='' order by id desc ";
$res241=mysqli_query($conn,$sel241);
/////for fees paid
$row241=mysqli_fetch_array($res241,MYSQLI_BOTH);
$re=$row241['remain'];
$all_fees=$t1;
$to=$conv_fees+$all_fees+$re;
//echo $conc;
$total_fee=$t1+$total_fee;
$total_conv=$conv_fees+$total_conv;
$total=$to+$total;
$re1=$re+$re1;
//////////
$class=$row['subject'];
$mn=min($m1);
$sel2482="select * from fees where session='$session' and month='$mn' and class='$class' ";
$res2482=mysqli_query($conn,$sel2482);
/////for fees paid
$row2482=mysqli_fetch_array($res2482,MYSQLI_BOTH);
$du_date=$row2482['date'];
$now = time(); // or your date as well
$your_date = strtotime("$du_date");
$datediff = $now - $your_date;
$days= round($datediff / (60 * 60 * 24));
if($days>0){if($days>1000){$days= '0';}else{ $days=$days;}}else{$days=0;};
$late=5*$days;
$k=$to+$late;
$total_k=$total_k+$k;
$late_total=$late_total+$late;
// $sel241="update registration set late='$late' where session='$session' and application='$app' and status='' order by id desc ";
//$res241=mysqli_query($conn,$sel241);
$sel24821="select * from pgukgadmit where year='$session' and class='$class' ";
$res24821=mysqli_query($conn,$sel24821);
/////for fees paid
$row24821=mysqli_fetch_array($res24821,MYSQLI_BOTH);
$sel248212="select * from fees_data where session='$session' and app='$app' and month_name='5' and status='Yes' ";
$res248212=mysqli_query($conn,$sel248212);
/////for fees paid
$row248212=mysqli_fetch_array($res248212,MYSQLI_BOTH);
?>
<center>
<table frame="border" width="100%" id="example">
<tr align="">
<td align="center"><img src="../images/logo.png" style=""height="80px" width="80px"/></td><td colspan="2"><center><p style="font-weight:bold;text-align:center"><u>ADMIT CARD</u>
<BR/>PARAMOUNT INTERNATIONAL SCHOOL DHANAULI ,DOHARIGHAT MAU <br/><span style="font-size:12px" id='b'> Cont.: 9473725359 , 9696136245</span> </p></center>
</td>
</tr>
</table>
<table border="1px" width="100%" cellspacing="0">
<tr align="left">
<td><h4>Class: <?php echo $row['subject'];?>/<?php echo $row['section'];?></h4></td><td colspan="2"><h4> <?php echo $row24821['name'];?>  <?php echo $session;?> </h4></td><td ><h4>Sch. Number: <?php echo $row['sr'];?></h4></td>
</tr>
<tr align="left">
<td>Name</td><td colspan="2"><p><?php echo $row['name'];?></p></td><td rowspan="3"><img src="../code/img/<?php echo $row['picture'];?>" height="70px" width="100px"/></td>
</tr>
<tr align="left">
<td>Father Name</td><td colspan="2"><p><?php echo $row['fname'];?></p></td>
</tr>
<tr align="left">
<td>Mother Name</td><td colspan="2"><p><?php echo $row['mname'];?></p></td>
</tr>
<tr align="center">
<td colspan="5"><h5>SUBJECT</h5></td>
</tr>
<table cellspacing="0" border="1px" width="100%">
<tr align="left">
<td colspan='3'><?php echo $row24821['sub1'];?></td><td colspan='3'><?php echo $row24821['date1'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub2'];?></td><td colspan='3'><?php echo $row24821['date2'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub3'];?></td><td colspan='3'><?php echo $row24821['date3'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub4'];?></td><td colspan='3'><?php echo $row24821['date4'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub5'];?></td><td colspan='3'><?php echo $row24821['date5'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub6'];?></td><td colspan='3'><?php echo $row24821['date6'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub7'];?></td><td colspan='3'><?php echo $row24821['date7'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub8'];?></td><td colspan='3'><?php echo $row24821['date8'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub9'];?></td><td colspan='3'><?php echo $row24821['date9'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub10'];?></td><td colspan='3'><?php echo $row24821['date10'];?></td>
</tr>
<tr align="left">
<td colspan='3'><?php echo $row24821['sub11'];?></td><td colspan='3'><?php echo $row24821['date11'];?></td>
</tr>
<tr>
<td colspan="2" align="center"><h4>Principal Signature</h4><br/><br/></td><td colspan="3" align="center"><h4>Class Teacher Signature</h4><br/><br/></td><td><b>Dues = <?php echo $k;?> Rs.
</b></td>
</tr>
</table>
<center>
<?php
?><br/><br/><br/><br/><br/><br/><?php
$r++;
$p++;
if($p==2)
{
?> <div style="page-break-before: always"></div> <?php
$p=0;
}
}
?>
<?php
?>
</body>
</html>