|
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></div>
<div class="panel-body">
<div class="row">
<?php
$session=$_POST['session'];
$section=$_POST['section'];
$class=$_POST['class'];
$month=$_POST['month'];
$sel215="select * from plan where id='$month' ";
$res215=mysqli_query($conn,$sel215);
$row45=mysqli_fetch_array($res215,MYSQLI_BOTH);
// $monthNum = 3;
if($class=='All')
{
$sel1="select * from registration where session='$session' order by id asc ";
}
else
{
$sel1="select * from registration where session='$session' and subject='$class' 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">Class</th><th style="text-align:center">Dues Month </th><th style="text-align:center"> Pre Dues</th><th style="text-align:center"> Fees Dues to <?php echo $row45['month']?></th><th style="text-align:center">Total Dues<?php echo $a;?></th><th style="text-align:center">Mob</th>
</tr>
</thead>
<tbody>
<?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'];
$s12=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'];
////////////for month show///////////
//echo $conc;
$sel248="select * from registration where session='$session_old' and application='$app' ";
$res248=mysqli_query($conn,$sel248);
/////for fees paid
$row248=mysqli_fetch_array($res248,MYSQLI_BOTH);
$sel2487="select * from convence where session='$session' and code='$code' ";
$res2487=mysqli_query($conn,$sel2487);
/////for fees paid
$row2487=mysqli_fetch_array($res2487,MYSQLI_BOTH);
$code=$row2487['conv'];
$sel6="select * from fix where session='$session' and sch='$application' ";
$res6=mysqli_query($conn,$sel6);
$row6=mysqli_fetch_array($res6,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']) {$month12=array_push($m1,$m);};
if($m==1 or $m==2)
{
if($m==1)
{
if($row248)
{
//$m_name=$row21['month'].','.$m_name;
$k2=$row2['exam'];
$k1=0;
}
else
{
$k1=0;$k2=0;
}
}
if($m==2)
{
if($row248)
{
$k1=0;$k2=0;
}
else
{
$m_name=$row21['month'].','.$m_name;
$k2=$row2['exam'];
$k1=0;
}
}
}
else
{
$m_name=$row21['month'].','.$m_name;
$k2=$row2['exam'];$k1=$row2['fees'];
}
//echo $m;
// 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);
if($row6)
{
if($m=='9' or $m=='18' or $m=='22' or $m=='23' or $m=='2')
{
// $m_name=$row21['month'].','.$m_name;
$k2=$row2['exam'];
$k1=0;
$mk1=$k2+$k1;
$mk=$mk1+$mk;
}
else
{
$mk1=0;
$mk=0;
}
}
else
{
$mk1=$k2+$k1;
$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;
?>
<tr class="text-left">
<td><?php echo $s12 ;?> </td><td><?php echo $row['application'] ;?> </td><td><?php echo $row['name'];?></td><td><?php echo $row['fname'];?></td><td><?php echo $row['subject'];?>/<?php echo $row['section'];?></td><td><?php if($row6){echo $row6['reason'];} else{echo $m_name;};?></td><td><?php echo $re;?></td><td><?php if($all_fees>0){echo $all_fees;} else{echo '0';};?></td><td><?php echo $to;?></td><td><?php echo $row['mobile'] ;?> </td>
</tr>
<?php
$s12++;
}
?>
<tfoot>
<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">Class</th><th style="text-align:center">Paid Month </th><th style="text-align:center"> <?php echo $re1;?></th><th style="text-align:center"> <?php echo $total_fee;?></th><th style="text-align:center"><?php echo $total;?></th>
<th style="text-align:center">Mob</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>