|
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/swrampyarejan.in/public_html/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
$session=$_POST['session'];
// $class=$_POST['class'];
$month=$_POST['month'];
$sel1="select * from registration where session='$session' order by id asc ";
$res1=mysqli_query($conn,$sel1);
?>
<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 tr align="center">
<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">Class</th><th style="text-align:center">Paid Month </th><th style="text-align:center">Paid</th><th style="text-align:center"> Dues UP TO <?php $ma=date("M"); echo $ma;?></th>
</tr>
</thead>
<tbody>
<?php
$s=0;
$toamount=0;
$totalpay=0;
while($row=mysqli_fetch_array($res1,MYSQLI_BOTH))
{
$app=$row['application'];
$application=$row['application'];
$code=$row['code'];
$tra=$row['tra'];
$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)$conv;
////////////for month show///////////
//echo $conc;
$selca="select * from studentfees where month like '%April%' and year='$session' and search='$application' order by id desc ";
$resca=mysqli_query($conn,$selca);
$a='';
if($rowca=mysqli_fetch_array($resca,MYSQLI_BOTH))
{
$a='1';
}
//////may
$selcm="select * from studentfees where month like '%May%' and year='$session' and search='$application' order by id desc ";
$rescm=mysqli_query($conn,$selcm);
$b='';
if($rowcm=mysqli_fetch_array($rescm,MYSQLI_BOTH))
{
$b='2';
}
//////Jun
$selcj="select * from studentfees where month like '%Jun%' and year='$session' and search='$application' order by id desc ";
$rescj=mysqli_query($conn,$selcj);
$c='';
if($rowcj=mysqli_fetch_array($rescj,MYSQLI_BOTH))
{
$c='3';
}
//////july
$selcmj="select * from studentfees where month like '%July%' and year='$session' and search='$application' order by id desc ";
$rescmj=mysqli_query($conn,$selcmj);
$d='';
if($rowcmj=mysqli_fetch_array($rescmj,MYSQLI_BOTH))
{
$d='4';
}
//////August
$selcmja="select * from studentfees where month like '%August%' and year='$session' and search='$application' order by id desc ";
$rescmja=mysqli_query($conn,$selcmja);
$e='';
if($rowcmja=mysqli_fetch_array($rescmja,MYSQLI_BOTH))
{
$e='5';
}
//////sep
$selcms="select * from studentfees where month like '%September%' and year='$session' and search='$application' order by id desc ";
$rescms=mysqli_query($conn,$selcms);
$f='';
if($rowcms=mysqli_fetch_array($rescms,MYSQLI_BOTH))
{
$f='6';
}
//////oct
$selcmjo="select * from studentfees where month like '%October%' and year='$session' and search='$application' order by id desc ";
$rescmjo=mysqli_query($conn,$selcmjo);
$g='';
if($rowcmjo=mysqli_fetch_array($rescmjo,MYSQLI_BOTH))
{
$g='7';
}
//////Nov
$selcmjn="select * from studentfees where month like '%November%' and year='$session' and search='$application' order by id desc ";
$rescmjn=mysqli_query($conn,$selcmjn);
$h='';
if($rowcmjn=mysqli_fetch_array($rescmjn,MYSQLI_BOTH))
{
$h='8';
}
//////Dec
$selcmjd="select * from studentfees where month like '%December%' and year='$session' and search='$application' order by id desc ";
$rescmjd=mysqli_query($conn,$selcmjd);
$i='';
if($rowcmjd=mysqli_fetch_array($rescmjd,MYSQLI_BOTH))
{
$i='9';
}
//////Jan
$selcmjdj="select * from studentfees where month like '%January%' and year='$session' and search='$application' order by id desc ";
$rescmjdj=mysqli_query($conn,$selcmjdj);
$j='';
if($rowcmjdj=mysqli_fetch_array($rescmjdj,MYSQLI_BOTH))
{
$j='10';
}
//////Jan
$selcmf="select * from studentfees where month like '%February%' and year='$session' and search='$application' order by id desc ";
$rescmf=mysqli_query($conn,$selcmf);
$k='';
if($rowcmf=mysqli_fetch_array($rescmf,MYSQLI_BOTH))
{
$k='11';
}
//////mar
$selcmm="select * from studentfees where month like '%March%' and year='$session' and search='$application' order by id desc ";
$rescmm=mysqli_query($conn,$selcmm);
$l='';
if($rowcmm=mysqli_fetch_array($rescmm,MYSQLI_BOTH))
{
$l='12';
}
////////////for month show///////////
////max for month/////////
$max=max($a,$b,$c,$d,$e,$f,$g,$h,$i,$j,$k,$l);
// echo $max;
////max for month/////////
if($max==11 or $max==12)
{
$ex1='300';
}
else
{
$ex1='0';
}
////for month cal_days_in_month/////
$sel211="select * from studentfees where year='$session' and class='$class' and search='$app' order by id asc ";
$res211=mysqli_query($conn,$sel211);
$row211=mysqli_fetch_array($res211,MYSQLI_BOTH);
$month=$row211['month'];
$pre1=$row211['pre'];
////////for month cal close/////
$sel="select * from studentfees where year='$session' and class='$class' and search='$app' order by id asc ";
$res=mysqli_query($conn,$sel);
/////for fees paid
$am=0;
$co=0;
$mon='';
while($row1=mysqli_fetch_array($res,MYSQLI_BOTH))
{
$paid=$row1['paid'];
$con=$row1['con'];
$am=$am+$paid;
$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);
if($tra=='')
{
$tra1=$row2['addm'];
}
else
{
$tra1=$row2['ann'];
}
//echo $tra1;
$fees=$row2['fees'];
$gen=$row2['gen'];
$computer=$row2['comp'];
$maint=$row2['reg'];
//
$other=$row211['other'];
$date=date("m");
$m1=(int)$maint;
$m2=(int)$tra1;
$ma=(int)$max;
$m3=(int)$other;
$m5=(int)$computer;
$m6=(int)$gen;
$date5=(int)$date;
if( $date5==11 )
{
$ex='300';
}
else
{
$ex='300';
}
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($date==1)
{
$cal=10;
}
if($date==2)
{
$cal=11;
}
if($date==3)
{
$cal=12;
}
//echo $cal;
$n=(int)$fees;
$pai=$cal-$ma;
////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 class='$class' and search='$app' order by id asc";
$res211f1=mysqli_query($conn,$sel211f1);
$row211f1=mysqli_fetch_array($res211f1,MYSQLI_BOTH);
$pre=$row211f1['pre'];
$feef=$row211f['fee'];
$convf=$row211f['conv'];
$fixf=$row211f['fix'];
if($feef=='YES')
{
$ff=$pai*$n;
}
else
{
$ff='0';
}
if($convf=='YES')
{
$fc=$pai*$conv12;
}
else
{
$fc='0';
}
if($subject=='NINTH CBSE')
{
$regn='1500';
}
else
{
$regn='0';
}
////free///
// echo $ff;
// echo $fc;
//echo $n;
$balance=$cal*$n;
$fixc=(int)$fixf;
$fixd=$pai*$fixc;
$convm=$conv12*$cal;
$tc=$fc+$ff+$fixd;
// echo $n;
$main=$balance+$m1+$m2+$m3+$m5+$m6+$convm+$ex+$pre1+$regn+$ex1-$conv12;
$amountnet=$main-$am-$co-$tc;
$toamount=$amountnet+$toamount;
//echo $balance;
////for class fees
$sel21="select * from studentfees where year='$session' and class='$class' and search='$app' ";
$res21=mysqli_query($conn,$sel21);
$row21=mysqli_fetch_array($res21,MYSQLI_BOTH);
$dues=$row21['remain'];
?>
<tr class="text-center">
<td><?php echo $row['application'] ;?></td><td><?php echo $row['name'];?></td><td><?php echo $row['fname'];?></td><td><?php echo $row['subject'];?></td><td><?php echo $mon;?></td><td><?php echo $am;?></td><td><?php echo $amountnet;?></td>
</tr>
<?php
$s++;
}
?>
<tr class="text-center">
<td>TOTAL</td><td></td><td></td><td></td><td></td><td><?php echo $totalpay;?></td><td><?php echo $toamount;?></td>
</tr>
<tfoot>
<tr tr align="center">
<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">Class</th><th style="text-align:center">Paid Month </th><th style="text-align:center"><?php echo $totalpay;?></th><th style="text-align:center"> <?php echo $toamount;?></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>