|
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/gsmps/admin/ |
| [ 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><a href='duesmonth2.php'><button class="btn btn-danger">Click For Back</button></a></div>
<div class="panel-body">
<div class="row">
<?php
$pre_t=0;
$session='2023-2024';
$class=$_POST['class'];
$month=$_POST['month'];
$section=$_POST['section'];
$area=$_POST['area'];
$session_old='2022-2023';
$sel12="select * from subclass ";
$res12=mysqli_query($conn,$sel12);
?>
<script>
$(document).ready(function(){
$('#example').DataTable({
dom: 'Bfrtip',
buttons: ['copy', 'excel', 'print']
});
});
</script>
<div class="table-responsive">
<table id="example" class="display nowrap" cellspacing="0" width="100%" border="1px">
<thead>
<tr align="center">
<th style="text-align:center">Sr</th><th style="text-align:center">Class</th><th style="text-align:center">Dues</th>
</tr>
</thead>
<tbody>
<?php
$s=1;
$toamount=0;
$total_pay1=0;
while($row12=mysqli_fetch_array($res12,MYSQLI_BOTH))
{
$class=$row12['subclass'];
$sel1="select * from registration where session='$session' and subject='$class' order by id asc ";
$res1=mysqli_query($conn,$sel1);
$remain_total1=0;
while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$app=$row['application'];
$application=$row['application'];
$code=$row['code'];
$subject=$row['subject'];
$class=$subject;
$sel24="select * from convence where code='$code' and session='$session'";
$res24=mysqli_query($conn,$sel24);
$row24=mysqli_fetch_array($res24,MYSQLI_BOTH);
//$vill=$row2['vill'];
$conv=$row24['conv'];
$conv12=(int)$code;
////////////for month show///////////
//echo $conc;
$sel18="select * from studentfees where year='$session' and class='$subject' and search='$app' and status=''order by id asc ";
$res18=mysqli_query($conn,$sel18);
$row18=mysqli_fetch_array($res18,MYSQLI_BOTH);
$adm=$row18['reg1'];
// echo $max;
////max for month/////////
////for month cal_days_in_month/////
$sel211="select * from studentfees where year='$session' and class='$class' and search='$app' and status='' order by id desc ";
$res211=mysqli_query($conn,$sel211);
$row211=mysqli_fetch_array($res211,MYSQLI_BOTH);
// $month=$row211['month'];
$pre1=$row211['pre'];
$remain=$row211['remain'];
$other=$row211['other'];
////////for month cal close/////
$sel="select * from studentfees where year='$session' and class='$class' and search='$app' and status='' order by id asc ";
$res=mysqli_query($conn,$sel);
/////for fees paid
$am=0;
$co=0;
$mon='';
$t_comp=0;
$t_exam=0;
while($row1=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$paid=$row1['paid'];
$con=$row1['con'];
$comp1=$row1['comp'];
$exam1=$row1['exam'];
$am=$am+$paid;
$t_comp=$comp1+$t_comp;
$t_exam=$exam1+$t_exam;
$co=$co+$con;
$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);
$sel26="select * from studentfees where year='$session_old' and search='$app' order by id desc ";
$res26=mysqli_query($conn,$sel26);
/////for fees paid
$row26=mysqli_fetch_array($res26,MYSQLI_BOTH);
$sel23="select * from free where session='$session' and class='$class' sch='$app' ";
$res23=mysqli_query($conn,$sel23);
/////for fees paid
$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
$fix=$row23['fix'];
$date=date("m");
if($date==1)
{
$cal=10;
}
if($date==2)
{
$cal=11;
}
if($date==3)
{
$cal=12;
}
if($date==4)
{
$cal=1;
}
if($date==5)
{
$cal=2;
}
if($date==6)
{
$cal=3;
}
if($date==7)
{
$cal=4;
}
if($date==8)
{
$cal=5;
}
if($date==9)
{
$cal=6;
}
if($date==10)
{
$cal=7;
}
if($date==11)
{
$cal=8;
}
if($date==12)
{
$cal=9;
}
if($class=='NURSERY' or $class=='LKG' or $class=='FIRST' or $class=='SECOND' )
{
if($cal>=5 and $cal<=8 )
{
$exam=200;
}
if($cal>=8 and $cal<=11 )
{
$exam=400;
}
if($cal>11 )
{
$exam=600;
}
}
if($class=='THIRD' or $class=='FOURTH' or $class=='FIFTH' or $class=='SIXTH' or $class=='SEVENTH' or $class=='EIGHTH' )
{
if($cal>=5 and $cal<=8 )
{
$exam=250;
}
if($cal>=8 and $cal<=11 )
{
$exam=500;
}
if($cal>11 )
{
$exam=750;
}
}
if($class=='NURSERY' or $class=='LKG' or $class=='FIRST' or $class=='SECOND' )
{
}
// $cal;
$tra1=$row2['ann'];
//echo $tra1;
$fees=$row2['fees'];
$gen=$row2['gen'];
$computer=$row2['comp'];
$maint=$row2['reg'];
//////
$apr='';
$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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
//////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;
}
$g=max($apr,$may,$jun,$jul,$aug,$sep,$oct,$nov,$dec,$jan,$feb,$mar);
$new_g=$cal-$g;
/////
$date5=(int)$date;
////free///
$sel211f="select * from free where session='$session' and class='$class' and sch='$app' ";
$res211f=mysqli_query($conn,$sel211f);
$row211f=mysqli_fetch_array($res211f,MYSQLI_BOTH);
$sel211f1="select * from studentfees where year='$session' and search='$app' and status='' order by id desc";
$res211f1=mysqli_query($conn,$sel211f1);
$row211f1=mysqli_fetch_array($res211f1,MYSQLI_BOTH);
$remain=$row211f1['remain'];
$feef=$row211f['fee'];
$convf=$row211f['conv'];
$fixf=$row211f['fix'];
$month=$row211f['month'];
$sel232="select * from free where session='$session' and sch='$app' and fee='YES' ";
$res232=mysqli_query($conn,$sel232);
/////for fees paid
if($row232=mysqli_fetch_array($res232,MYSQLI_BOTH))
{
// $free_fee=$row2['fees'];
$free_fee=$new_g*$row2['fees'];
}
else
{
$free_fee=0;
}
$sel234="select * from free where session='$session' and sch='$app' and conv='YES' ";
$res234=mysqli_query($conn,$sel234);
/////for fees paid
if($row234=mysqli_fetch_array($res234,MYSQLI_BOTH))
{
$free_conv=$new_g*$conv12;
}
else
{
$free_conv=0;
}
$total_Fees=$new_g*$row2['fees'];
$van=$new_g*$conv12;
$diary_other=0;
$total_con=$con;
$total_pay=$am;
$tot_fix=$new_g*$fix;
$total_free_conv=$new_g*$free_conv;
$total_free_fee=$new_g*$free_fee;
////////
$exam_new=$exam-$t_exam;
$sel1811="select * from registration where session='$session_old' and application='$app' order by id asc ";
$res1811=mysqli_query($conn,$sel1811);
$row1811=mysqli_fetch_array($res1811,MYSQLI_BOTH);
if($row1811)
{
$adm=0;
}
else
{
$adm=0;
}
$sel181="select * from studentfees where year='$session' and search='$app' and status=''order by id desc ";
$res181=mysqli_query($conn,$sel181);
$row181=mysqli_fetch_array($res181,MYSQLI_BOTH);
if($row181)
{
$remain=$row181['remain'];
$remain_total=$remain+$total_Fees+$new_g*$conv12+$exam_new-$tot_fix-$total_free_fee-$total_free_conv;
$pre=0;
}
else
{
$sel181="select * from studentfees where year='$session_old' and search='$app' and status='' order by id desc ";
$res181=mysqli_query($conn,$sel181);
$row181=mysqli_fetch_array($res181,MYSQLI_BOTH);
// $row181=mysqli_fetch_array($res181,MYSQLI_BOTH);
$remain=$row181['remain'];
$pre=$remain;
$remain_total=$adm+$remain+$total_Fees+$new_g*$conv12+$exam_new-$tot_fix-$total_free_fee-$total_free_conv;
}
$total_add=$total_Fees+$diary_other+$exam+$tra1+$van+$pre1+$maint+$tie+$gen;
//////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////
////free///
// echo $ff;
// echo $fc;
//echo $n;
$remain_total1=$remain_total1+$remain_total;
$total_pay1=$total_pay1+$total_pay;
$pre_t=$pre+$pre_t;
}
?>
<tr class="text-center">
<td><?php echo $s ;?> </td><td><?php echo $row12['subclass'];?></td><td><?php echo $remain_total1;?></td>
</tr>
<?php
$s++;
}
?>
<tfoot>
<tr align="center">
<th style="text-align:center">Sch No.</th><th style="text-align:center">Name</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>