|
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/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
$session=$_POST['session'];
$board=$_POST['board'];
$class=$_POST['class'];
$section=$_POST['section'];
$month=$_POST['month'];
include('../link/databaseconnection.php');
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:index.php");
}
if($month==1)
{
$a='APR';
}
if($month==2)
{
$a='MAY';
}
if($month==3)
{
$a='JUN';
}
if($month==4)
{
$a='JUL';
}
if($month==5)
{
$a='AUG';
}
if($month==6)
{
$a='SEP';
}
if($month==7)
{
$a='OCT';
}
if($month==8)
{
$a='NOV';
}
if($month==9)
{
$a='DE';
}
if($month==10)
{
$a='JAN';
}
if($month==11)
{
$a='FEB';
}
if($month==12)
{
$a='MAR';
}
// $monthNum = 3;
$sel="select * from pgukgadmit where year='$session' and class='$class'";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
$exam=$row['name'];
$sel1="select *from registration where session='$session' and subject='$class'and status='' and section='$section'";
$res1=mysqli_query($conn,$sel1);
$sel3="select *from registration where session='$session' and subject='$class' and section='$section'and status=''";
$res3=mysqli_query($conn,$sel3);
$row3=mysqli_fetch_array($res3,MYSQLI_BOTH);
$rol=$row3['application'];
?>
<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: ['copy', '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:10px;
text-transform: uppercase;
}
#a{text-transform: capitalize;}
#b{text-transform: lowercase;}
</style>
</head>
<body>
<?php
$s=2017;
$r=1;
$p=0;
while($row1=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$rol1=$row1['application'];
$app=$row1['application'];
$application=$row1['application'];
$code=$row1['code'];
$subject=$row1['subject'];
$class=$subject;
$sel67="select * from studentfees where year='$session' and search='$app' and status='' order by id asc ";
$res67=mysqli_query($conn,$sel67);
/////for fees paid
$am=0;
$co=0;
$van1=0;
$mon='';
$paid=0;
while($row67=mysqli_fetch_array($res67,MYSQLI_BOTH))
{
$paid=$row67['paid'];
$con=$row67['con'];
$am=$am+$paid;
$co=$co+$con;
$van1=$van1+$row67['van'];
$m=$row1['month'];
$mon=$mon.','.$m;
}
/////for fees paid
$totalpay=$totalpay+$am;
////for class fees
$sel2="select * from fees where session='$session' and class='$class' ";
$res2=mysqli_query($conn,$sel2);
/////for fees paid
$row2=mysqli_fetch_array($res2,MYSQLI_BOTH);
$comp_fee=$row2['comp'];
$fees=$row2['fees'];
$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=$row23['conv'];
if($fix>0)
{
$f_fix=$fix;
}
else
{
$f_fix=0;
}
if($fee_free=='YES')
{
$fee_free=$fees;
}
else
{
$fee_free=0;;
}
if($conv_free=='YES')
{
$conv_free=$code;
}
else
{
$conv_free=0;;
}
if($session=='2020-2021')
{
$cal=12;
}
else
{
$cal=$month;
}
$sel211f133="select * from studentfees where year='$session' and search='$app' and status='' order by id asc";
$res211f133=mysqli_query($conn,$sel211f133);
$ot=0;
$ad=0;
$rg=0;
$rg1=0;
$cp=0;
$gn=0;
$ann1=0;
$exam1=0;
$van12=0;
$fee1=0;
$tpaid=0;
while($row211f133=mysqli_fetch_array($res211f133,MYSQLI_BOTH))
{
$tpaid=$row211f133['paid']+$tpaid;
}
//echo $cal;
////////////
/////////
////////
$fees=$row2['fees'];
/////
///
$application=$app;
//echo $conc;
$apr='';
$c='';
$selca="select * from studentfees where month like '%April%' and year='$session' and search='$application' and status='' order by id asc ";
$resca=mysqli_query($conn,$selca);
if($rowca=mysqli_fetch_array($resca,MYSQLI_BOTH))
{
$apr=1;
$c++;
}
//////may
$may='';
$selcm="select * from studentfees where month like '%May%' and year='$session' and search='$application' and status='' order by id asc ";
$rescm=mysqli_query($conn,$selcm);
if($rowcm=mysqli_fetch_array($rescm,MYSQLI_BOTH))
{
//echo "SHOW2";
$may=2;
$c++;
}
//////Jun
$jun='';
$selcj="select * from studentfees where month like '%Jun%' and year='$session' and search='$application' and status='' order by id asc ";
$rescj=mysqli_query($conn,$selcj);
if($rowcj=mysqli_fetch_array($rescj,MYSQLI_BOTH))
{
//echo "SHOW3";
$jun=3;
$c++;
}
//////july
$jul='';
$selcmj="select * from studentfees where month like '%July%' and year='$session' and search='$application' and status='' order by id asc ";
$rescmj=mysqli_query($conn,$selcmj);
if($rowcmj=mysqli_fetch_array($rescmj,MYSQLI_BOTH))
{
//echo "SHOW4";
$jul=4;
$c++;
}
//////August
$aug='';
$selcmja="select * from studentfees where month like '%August%' and year='$session' and search='$application' and status='' order by id asc ";
$rescmja=mysqli_query($conn,$selcmja);
if($rowcmja=mysqli_fetch_array($rescmja,MYSQLI_BOTH))
{
//echo "SHOW5";
$aug=5;
$c++;
}
//////sep
$sep='';
$selcms="select * from studentfees where month like '%September%' and year='$session' and search='$application' and status='' order by id asc ";
$rescms=mysqli_query($conn,$selcms);
if($rowcms=mysqli_fetch_array($rescms,MYSQLI_BOTH))
{
//echo "SHOW6";
$sep=6;
$c++;
}
//////oct
$oct='';
$selcmjo="select * from studentfees where month like '%October%' and year='$session' and search='$application' and status='' order by id asc ";
$rescmjo=mysqli_query($conn,$selcmjo);
if($rowcmjo=mysqli_fetch_array($rescmjo,MYSQLI_BOTH))
{
//echo "SHOW7";
$oct=7;
$c++;
}
//////Nov
$nov='';
$selcmjn="select * from studentfees where month like '%November%' and year='$session' and search='$application' and status='' order by id asc ";
$rescmjn=mysqli_query($conn,$selcmjn);
if($rowcmjn=mysqli_fetch_array($rescmjn,MYSQLI_BOTH))
{
//echo "SHOW7";
$nov=8;
$c++;
}
//////Dec
$dec='';
$selcmjd="select * from studentfees where month like '%December%' and year='$session' and search='$application' and status=''order by id asc ";
$rescmjd=mysqli_query($conn,$selcmjd);
if($rowcmjd=mysqli_fetch_array($rescmjd,MYSQLI_BOTH))
{
//echo "SHOW7";
$dec=9;
$c++;
}
//////Jan
$jan='';
$selcmjdj="select * from studentfees where month like '%January%' and year='$session' and search='$application' and status='' order by id asc ";
$rescmjdj=mysqli_query($conn,$selcmjdj);
if($rowcmjdj=mysqli_fetch_array($rescmjdj,MYSQLI_BOTH))
{
//echo "SHOW7";
$jan=10;
$c++;
}
//////Jan
$feb='';
$selcmf="select * from studentfees where month like '%February%' and year='$session' and search='$application' and status=''order by id asc ";
$rescmf=mysqli_query($conn,$selcmf);
if($rowcmf=mysqli_fetch_array($rescmf,MYSQLI_BOTH))
{
//echo "SHOW7";
$feb=11;
$c++;
}
//////mar
$mar='';
$selcmm="select * from studentfees where month like '%March%' and year='$session' and search='$application' and status='' order by id asc ";
$rescmm=mysqli_query($conn,$selcmm);
if($rowcmm=mysqli_fetch_array($rescmm,MYSQLI_BOTH))
{
//echo "SHOW7";
$mar=12;
$c++;
$ex1=0;
}
$g=max($apr,$may,$jun,$jul,$aug,$sep,$oct,$nov,$dec,$jan,$feb,$mar);
$new_g=$cal-$g;
if($new_g>0)
{
$new_g=$new_g;
}
else
{
$new_g=0;
}
$re_fee=$fees*$new_g;
$re_fee1=$re_fee+$re_fee1;
$sel4="select * from studentfees where year='$session' and search='$app' and status='' order by id desc ";
$res4=mysqli_query($conn,$sel4);
$row4=mysqli_fetch_array($res4,MYSQLI_BOTH);
$remain=$row4['remain'];
$van_fee=$code*$new_g;
$comp_fee_c=$comp_fee*$new_g;
$f_fix=$f_fix*$new_g;
$fee_free1=$fee_free*$new_g;
$conv_free1=$conv_free*$new_g;
$van_fee1=$van_fee1+$van_fee;
$comp_fee_c1=$comp_fee_c1+$comp_fee_c;
$re_fee_van=$re_fee+$van_fee+$remain+$comp_fee_c-$f_fix-$fee_free1-$conv_free1;
$total1=$re_fee_van+$total1;
$remain1=$remain+$remain1;
$tpaid1=$tpaid1+$tpaid;
$free=$f_fix+$fee_free1+$conv_free1;
$free1=$free1+$free;
?>
<center>
<table frame="border" width="100%" id="example">
<tr align="">
<td align="center"><img src="../images/logo.png" style=""height="60px" width="60px"/></td><td colspan="2"><center><p style="font-weight:bold;text-align:center"><u>ADMIT CARD</u>
<BR/>PACIFIC PUBLIC SCHOOL CHARGAWAN- GORAKHPUR <br/><span style="font-size:11px" id='b'> Cont.: 7376598752 , 9451960467</span> </p></center>
</td>
</tr>
</table>
<table border="1px" width="100%" cellspacing="0">
<tr align="left">
<td><h4>Class: <?php echo $row1['subject'];?>/<?php echo $row1['section'];?></h4></td><td colspan="2"><h4> <?php echo $exam;?>  <?php echo $session;?> </h4></td><td ><h4>Sch. Number: <?php echo $row1['application'];?></h4></td>
</tr>
<tr align="left">
<td>Name</td><td colspan="2"><p><?php echo $row1['name'];?></p></td><td rowspan="3"><img src="../code/img/<?php echo $row1['picture'];?>" height="70px" width="100px"/></td>
</tr>
<tr align="left">
<td>Father Name</td><td colspan="2"><p><?php echo $row1['fname'];?></p></td>
</tr>
<tr align="left">
<td>Mother Name</td><td colspan="2"><p><?php echo $row1['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><?php echo $row['sub1'];?></td><td><?php echo $row['date1'];?></td><td ><?php echo $row['sub2'];?></td><td><?php echo $row['date2'];?></td><td ><?php echo $row['sub3'];?></td><td><?php echo $row['date3'];?></td>
</tr>
<tr align="left">
<td><?php echo $row['sub4'];?></td><td><?php echo $row['date4'];?></td><td ><?php echo $row['sub5'];?></td><td><?php echo $row['date5'];?></td><td ><?php echo $row['sub6'];?></td><td><?php echo $row['date6'];?></td>
</tr>
<tr align="left">
<td><?php echo $row['sub7'];?></td><td><?php echo $row['date7'];?></td><td ><?php echo $row['sub8'];?></td><td><?php echo $row['date8'];?></td><td ><?php echo $row['sub9'];?></td><td><?php echo $row['date9'];?></td>
</tr>
<tr align="left">
<td><?php echo $row['sub10'];?></td><td><?php echo $row['date10'];?></td><td><?php echo $row['sub11'];?></td><td><?php echo $row['date11'];?></td><td></td><td></td>
</tr>
<tr>
<td colspan="2" align="center"><h4>Principal Signature</h4><br/></td><td colspan="3" align="center"><h4>Class Teacher Signature</h4><br/></td><td><b>Dues = <?php echo $re_fee_van;?> Rs.
</b></td>
</tr>
</table>
<center>
<?php
?><br/><?php
$r++;
$p++;
if($p==3)
{
?> <div style="page-break-before: always"></div> <?php
$p=0;
}
}
?>
<?php
?>
</body>
</html>