|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.20 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/hj/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<html>
<head>
<?php
error_reporting(0);
include("../link/admin_headconnection.php");
include("../link/databaseconnection.php");
session_start();
$lg=$_SESSION['admin'];
if(!$lg)
{
header("location:../admin/index.php");
}
?>
<link href="../css/dashboard.css" rel="stylesheet" type="text/css"/>
<link href="../css/dashboardmenu.css" rel="stylesheet" type="text/css"/>
<link href="../css/student_details_side_menu.css" rel="stylesheet" type="text/css"/>
<link href="../css/student_details.css" rel="stylesheet" type="text/css"/>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<link href="jq/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="jq/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
<script src="jq/jquery.dataTables.min.js"></script>
<script src="jq/dataTables.buttons.min.js"></script>
<script src="jq/buttons.flash.min.js"></script>
<script src="jq/jszip.min.js"></script>
<script src="jq/pdfmake.min.js"></script>
<script src="jq/vfs_fonts.js"></script>
<script src="jq/buttons.html5.min.js"></script>
<script src="jq/buttons.print.min.js"></script>
<style>
.work
{
min-height:200px;
}
.gap
{
height:100px;
}
</style>
<script>
function editrow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=3&id="+id);
}
function transferrow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=31&id="+id);
}
function feesrow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=9&id="+id);
}
//===message==//
function messagerow(id)
{
//alert(id);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=7&id="+id);
}
function slip123(application)
{
//alert(application);
$("#editmodel12").modal("show");
$("#editbody12").load("../code/student_detailscode.php?flag=34&application="+application);
}
$(document).ready(function(){
$("#myform21").submit(function(e){
e.preventDefault();
$.ajax({
url:"../code/student_detailscode.php?flag=6111",
type:"POST",
data: new FormData(this),
contentType:false,
processData:false,
success:function(res){
//alert(res);
$("#modal").html(res);
},
error:function(){
alert("error");
}
});
});
});
//== message==///
function deleterow(id)
{
//alert(id);
var a=confirm("Are you Sure");
if(a==true)
{
$.ajax({
url:"../code/student_detailscode.php?flag=2",
type:"POST",
data:{rowid:id},
success:function(res){
//alert(res);
//$("#modal").html(res);
$("#myform21").submit();
},
error:function(){
alert("error");
}
});
}
}
$(document).ready(function(){
//$("#modal").load("../code/student_detailscode.php?flag=1");
});
function updaterow(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=4",
type:"POST",
data:new FormData(form),
contentType:false, // for photo upload ke liye hai
processData:false, //for photo upload ke liye hai
cache:false,
success:function(res){
alert(res);
if(res=="ok")
{
$("#editmodel12").modal("hide");
$("#myform21").submit();
}
},
error:function(){
alert("error");
}
});
return false;
}
////
function changerow(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=32",
type:"POST",
data:new FormData(form),
contentType:false, // for photo upload ke liye hai
processData:false, //for photo upload ke liye hai
cache:false,
success:function(res){
alert(res);
if(res=="Transfered")
{
$("#editmodel12").modal("hide");
}
},
error:function(){
alert("error");
}
});
return false;
}
///
function result(id)
{
$("#editmodel").modal("show");
$("#editbody").load("../code/student_detailscode.php?flag=5&id="+id);
}
function go()
{
alert("ok");
$("#editmodel12").modal("show");
}
function data(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=6",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
alert(res);
if(res=="ok")
{
$("#editmodel").modal("hide");
}
},
error:function(){
alert("error");
}
});
return false;
}
function go(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=35",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
$("#editmodel").modal("hide");
},
error:function(){
alert("error");
}
});
return false;
}
function feesdata(form)
{
$("#btn").prop("disabled",true);
$.ajax({
url:"../code/student_detailscode.php?flag=10",
type:"POST",
data:new FormData(form),
contentType:false,
processData:false,
success:function(res){
alert(res);
$("#editmodel12").modal("hide");
},
error:function(){
alert("error");
}
});
return false;
}
///////
// for check box coding (JAN)/////
$("document").ready(function(){
var totalm=0;
var fees123=$("#fee").val();
var conv123=$("#conv").val();
$(".option").change(function(){
var m=$(":checkbox").filter(':checked').length;
var lem=0;
for(i=0;i< m;i++)
{
lem++;
// alert(lem);
$("#count").val(lem);
}
if($(this).prop("checked")==true)
{
}
else
{
var checkbox = document.getElementsByName('choice[]');
var n = checkbox.length;
var lem=0;
for(j=0;j< n;j++)
{
lem++;
// alert(lem1);
}
}
});
});
////////
</script>
</head>
<body>
<div class="container-fluid">
<div class="row">
<?php include("../link/admin_dashboardmenu .php");?>
</div>
<div class="row">
<!--menu-->
<div class="col-sm-2">
<?php include("../link/student_details_side_menu.php");?>
</div>
<!--menu--close-->
<div class="col-sm-10">
<div class="panel-group">
<div class="panel panel-primary">
<div class="panel-heading"><center><h4>Search Method</h4></center><span><img src="../images/new_icon (1)-3.gif" style="height:20px"></span></div>
<div class="panel-body">
<div class="row">
<?php
$session=$_POST['session'];
$section=$_POST['section'];
$class=$_POST['class'];
$month=$_POST['month'];
$all=$_POST['all'];
if($month==1)
{
$a='APR';
$v1='';
}
if($month==2)
{
$a='MAY';
$v1='';
}
if($month==3)
{
$a='JUN';
$v1='';
}
if($month==4)
{
$a='JUL';
$v1='';
}
if($month==5)
{
$a='AUG';
$v1='';
}
if($month==6)
{
$a='SEP';
$v1='';
}
if($month==7)
{
$a='OCT';
$v1='';
}
if($month==8)
{
$a='NOV';
$v1='';
}
if($month==9)
{
$a='DE';
$v1='';
}
if($month==10)
{
$a='JAN';
$v1='';
}
if($month==11)
{
$a='FEB';
}
if($month==12)
{
$a='MAR';
$v1='';
}
// $monthNum = 3;
if($all=='All')
{
$sel1="select * from registration where session='$session' and status='' order by id asc ";
}
else
{
$sel1="select * from registration where session='$session' and subject='$class' and status='' and section='$section' order by id asc ";
}
$res1=mysqli_query($conn,$sel1);
?>
<script>
$(document).ready(function() {
$('#example').DataTable( {
fixedHeader: true,
dom: 'Bfrtip',
lengthMenu: [
[ 10, 25, 50, -1 ],
[ '10 rows', '25 rows', '50 rows', 'Show all' ]
],
buttons: ['excel',
'pageLength',
{ extend: 'pdf', footer: true,
orientation: 'landscape',
pageSize: 'LEGAL'
}
]
} );
} );
</script>
<style>
td{font-size:12px}
</style>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr tr align="center">
<th style="text-align:center">Sr.</th><th style="text-align:center">Sch No.</th><th style="text-align:center">Name</th><th style="text-align:center">Father</th><th style="text-align:center">Remain Month</th><th style="text-align:center">Class</th><th style="text-align:center">Paid Month </th><th style="text-align:center">Total Paid </th><th style="text-align:center"> Dues</th><th style="text-align:center">Fee Dues To <?php echo $a;?></th><th style="text-align:center">Conv Dues To <?php echo $a;?></th><th style="text-align:center">Comp Dues To <?php echo $a;?></th><th style="text-align:center">Concess.</th><th style="text-align:center">Latest Dues</th><th style="text-align:center">Mob</th><th style="text-align:center">Lost Date</th>
</tr>
</thead>
<tbody>
<?php
$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;
while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$app=$row['application'];
$application=$row['application'];
$code=$row['code'];
$subject=$row['subject'];
$class=$row['subject'];
////////////for month show///////////
//echo $conc;
// echo $max;
////max for month/////////
////////for month cal close/////
$sel="select * from studentfees where year='$session' and search='$app' and status='' order by id asc ";
$res=mysqli_query($conn,$sel);
/////for fees paid
$am=0;
$co=0;
$van1=0;
$mon='';
$paid=0;
while($row1=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$paid=$row1['paid'];
$con=$row1['con'];
$am=$am+$paid;
$co=$co+$con;
$van1=$van1+$row1['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='';
$a1='';
$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++;
$a1='APR';
$m1='April';
}
//////may
$may='';
$a2='';
$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++;
$a2='MAY';
}
//////Jun
$jun='';
$a3='';
$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++;
$a3='JUN';
}
//////july
$jul='';
$a4='';
$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++;
$a4='JUL';
}
//////August
$aug='';
$a5='';
$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++;
$a5='AUG';
}
//////sep
$sep='';
$a6='';
$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++;
$a6='SEP';
}
//////oct
$oct='';
$a7='';
$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++;
$a7='OCT';
}
//////Nov
$nov='';
$a8='';
$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++;
$a8='NOV';
}
//////Dec
$dec='';
$a9='';
$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++;
$a9='DEC';
}
//////Jan
$jan='';
$a10='';
$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++;
$a10='JAN';
}
//////Jan
$feb='';
$a11='';
$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++;
$a11='FEB';
}
//////mar
$mar='';
$a12='';
$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;
$a12='MAR';
$c++;
$ex1=0;
}
$g=max(0,$apr,$may,$jun,$jul,$aug,$sep,$oct,$nov,$dec,$jan,$feb,$mar);
$new_g=$cal-$g;
$t=$fees*$new_g;
$re_fee=$fees*$new_g;
$t=0;
foreach ($at as $x) {
if($x=='')
{
$t++;
}
}
$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;
$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;
$remain1=$remain+$remain1;
$tpaid1=$tpaid1+$tpaid;
$free=$f_fix+$fee_free1+$conv_free1;
$free1=$free1+$free;
$mon=$a1.','.$a2.','.$a3.','.$a4.','.$a5.','.$a6.','.$a7.','.$a8.','.$a9.','.$a10.','.$a11.','.$a12;
if($re_fee_van>0)
{
$re_fee_van=$re_fee_van;
}
else
{
$re_fee_van=0;
}
//////////
///////////
$t=$re_fee+$van_fee;
if($re_fee>0)
{
$re_fee=$re_fee;
}
else
{
$re_fee=0;
}
if($van_fee>0)
{
$van_fee=$van_fee;
}
else
{
$van_fee=0;
}
$free=$f_fix+$fee_free1+$conv_free1;
$t1=$van_fee+$re_fee;
$t12=$t1+$remain-$free;
if($t12>0)
{
$t12=$t12;
}
else
{
$t12=0;
}
$re_fee1=$re_fee+$re_fee1;
$van_fee1=$van_fee1+$van_fee;
if($g>$month)
{
$re_fee_van=0;
$comp_fee_c=0;
}
else
{
$re_fee_van=$re_fee_van;
$comp_fee_c=$comp_fee_c;
}
$total1=$re_fee_van+$total1;
if($re_fee_van>0)
{
?>
<tr class="text-left">
<td><?php echo $s ;?> </td><td><?php echo $row['application'] ;?> </td><td><?php echo $row['name'];?></td><td><?php echo $row['fname'];?></td><td><?php if($t>0){echo $t;} ;?></td><td><?php echo $row['subject'];?>/<?php echo $row['section'];?></td><td><?php echo $mon;?></td><td><?php echo $tpaid;?></td><td><?php echo $remain;?></td><td><?php echo $re_fee;?></td><td><?php echo $van_fee;?></td><td><?php echo $comp_fee_c;?></td><td><?php echo $free=$f_fix+$fee_free1+$conv_free1;?></td><td><?php echo $re_fee_van;?></td><td><?php echo $row['mobile'] ;?> </td><td><?php echo date("d-m-Y", strtotime($row4['date'])) ;?> </td>
</tr>
<?php
$s++;
$ch='Dues_session';
// echo $ch;
$name=$row['name'];
$remark1='';
$other_remark1='';
$remark='';
$other_remark='';
$year=$row['session'];
$date1=date('Y-m-d');
$pr=rand(10000,50000);
$mobile1=$row['mobile'];
// $remain=$re_fee_van;
// $ins="insert into studentfees(name,class,month,fee,date,year,search,van,exam,other,total,board,remain,ann,addm,reg,comp,gen,paid,con,mtotal,pre,remark,reg1,fine,dpaid,to1,status,c_date,other_remark,mode,pr,email) values('$name','$class','$ch','$re_fee','$date1','$year','$app','$van_fee','0','0','0','','$re_fee_van','0','0','0','0','0','0','0','0','0','','','','','','','$date1','','','$pr','')";
// mysqli_query($conn,$ins);
}
}
?>
<tfoot>
<tr tr align="left">
<th style="text-align:center">Sr</th><th style="text-align:center">Sch No.</th><th style="text-align:center">Name</th><th style="text-align:center">Father</th><th style="text-align:center">Remain Month</th><th style="text-align:center">Class</th><th style="text-align:center">Paid Month </th><th style="text-align:center"><?php echo $tpaid1; ?> </th><th style="text-align:center"><?php echo $remain1;?></th><th style="text-align:center"><?php echo $re_fee1;?></th><th style="text-align:center"><?php echo $van_fee1?></th><th style="text-align:center"><?php echo $comp_fee_c1?></th><th style="text-align:center"><?php echo $free1?></th><th style="text-align:center"><?php echo $total1;?></th><th style="text-align:center">Mob</th><th style="text-align:center">Date</th>
</tr>
</tfoot>
</tbody>
</table>
<?php
?>
</div>
</div>
<br/>
<div id="modal"></div>
</div>
</div>
</div>
</div>
<br/>
<br/>
<div id="show" style="display:none"></div>
</div>
<!-- modal for result-->
<div class="modal fade" id="editmodel">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> Load Data </h2> </center>
</div>
<div class="modal-body" id="editbody">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- modal for result-->
<div class="modal fade" id="editmodel12">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> Fill Data </h2> </center>
</div>
<div class="modal-body" id="editbody12">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
</form>
</div>
</body>
</html>