|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.52 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 : ON Directory (0755) : /home/u490972518/domains/bpscps.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<html>
<head>
<?php include("../link/admin_headconnection.php");
include("../link/databaseconnection.php");
session_start();
$lg=$_SESSION['admin'];
$selt="select * from classteacher where mobile='$lg'";
$rest=mysqli_query($conn,$selt);
$rowt=mysqli_fetch_array($rest,MYSQLI_BOTH);
if(!$lg)
{
header("location:../admin/stafflogin.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"/>
<style>
<link href="../css/student_details.css" rel="stylesheet" type="text/css"/>
.work
{
min-height:200px;
}
.gap
{
height:100px;
}
</style>
<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;
}
thead input {
width: 100%;
padding: 1px;
box-sizing: border-box;
}
</style>
<script>
function record(id)
{
//alert(id);
$("#editmodel").modal("show");
$("#editbody").load("../code/student_detailscode.php?flag=293&id="+id);
}
function recordup(application,date)
{
// alert(date);
$("#editmodel134").modal("show");
$("#editbody134").load("../code/student_detailscode.php?flag=295&application="+application);
/// $("#editbody134").load("../code/student_detailscode.php?flag=295&date="+date);
}
function transferrow(id)
{
//alert(id);
$("#editmodel12t").modal("show");
$("#editbody12t").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);
$("#editmodel").modal("show");
$("#editbody").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(){
$("#search").submit(function(e){
e.preventDefault();
$.ajax({
url:"../code/student_detailscode.php?flag=291",
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 recordupdate(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=292",
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);
$("#editmodel").modal("hide");
$("#search").submit();
},
error:function(){
alert("error");
}
});
return false;
}
////
////for update
function recordupdate1(form)
{
$.ajax({
url:"../code/student_detailscode.php?flag=296",
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);
$("#editmodel134").modal("hide");
$("#search").submit();
},
error:function(){
alert("error");
}
});
return false;
}
////for update
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")
{
$("#editmodel12t").modal("hide");
$("#myform21").submit();
}
},
error:function(){
alert("error");
}
});
return false;
}
///
function result(id)
{
$("#editmodel").modal("show");
$("#editbody").load("../code/student_detailscode.php?flag=5&id="+id);
}
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 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;
}
</script>
</head>
<body>
<div class="container-fluid">
<div class="row">
<?php include("../link/presenty.php");?>
</div>
<div class="row">
<!--menu--close-->
<div class="col-sm-12">
<h4 style="color:red;font-weight:bold" ><SPAN STYLE="COLOR:BLACK">CLASS TEACHER</SPAN><marquee><?php echo $rowt['name'];?></marquee><h4>
<h2 class="text-center">Dues Record</h2>
<div class="row">
<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' and status='' order by id asc ";
}
else
{
$sel1="select * from registration where session='$session' and subject='$class' and status='' 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">Conv Dues to <?php echo $row45['month']?> </th><th style="text-align:center">Total Dues<?php echo $a;?></th><th style="text-align:center">Total Late</th><th style="text-align:center">Late+Dues</th><th style="text-align:center">Mob</th><th>Share</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'];
$s=0;
$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' and status='' ";
$res248=mysqli_query($conn,$sel248);
/////for fees paid
$row248=mysqli_fetch_array($res248,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']>2) {$month12=array_push($m1,$m);};
if($m!='2')
{
$m_name=$row21['month'].','.$m_name;
}
//echo $m;
if($m==1)
{
if($row248)
{
$k1=0;
$k2=$row2['fees'];;
}
else
{
$k1=$row2['exam'];
$k2=$row2['fees'];
}
}
// 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);
$mk1=$row2['exam']+$row2['fees'];
$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;
// $url="https://paramountdoharighat.in/admin/slip_teacher_dues.php?flag=" . $row['name'] .'S/O'. $row['fname'].urlencode('\n'). 'Total Dues= '. $k ;
if($k>0)
{
?>
<tr class="text-left">
<td><?php echo $s++ ;?> </td><td><?php echo $row['sr'] ;?> </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 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 $conv_fees;?></td><td><?php echo $to;?></td><td><?php echo $late; ;?> </td><td><?php echo $k ;?> </td><td><?php echo $row['mobile'] ;?> </td><td> <a href="https://wa.me/<?php echo $row['mobile']?>/?text= <?php echo $row['name'] ?> S/O <?php echo $row['fname'] ?>
**[ Total Dues = <?php echo $k;?>
(Old Dues = <?php echo $re;?> ,
Month Fee = <?php echo $all_fees;?>
, Conv Dues = <?php echo $conv_fees;?> ) ]**
- Dues Month = (<?php echo $m_name;?>)
Please Contact PARAMOUNT INTERNATIONAL SCHOOL DOHARIGHAT And Pay Dues Thanks" data-action="share/whatsapp/share" ><i class="fa fa-whatsapp" aria-hidden="true" style='font-size:20px'></i></a></td>
</tr>
<?php
$s++;
}
}
?>
<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_conv;?> </th><th style="text-align:center"><?php echo $total;?></th>
<th style="text-align:center"><?php echo $late_total;?></th><th style="text-align:center"><?php echo $total_k;?></th><th>Share</th>
<th style="text-align:center">Mob</th>
</tr>
</tfoot>
</tbody>
</table>
<?php
?>
</div>
</div>
</div>
</form>
<div id="modal"></div>
</div>
<br/>
<br/>
<div id="show" style="display:none"></div>
</div>
<!-- modal for result-->
<div class="modal fade" id="editmodel134">
<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"> Update Attendance </h2> </center>
</div>
<div class="modal-body" id="editbody134">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<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"> Attendance </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 bs-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" id="editmodel12">
<div class="modal-dialog modal-lg">
<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"> Attendance</h2> </center>
</div>
<div class="modal-body" id="editbody12">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!--for modal transfer--->
<div class="modal fade bs-example-modal-lg" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" id="editmodel12t">
<div class="modal-dialog modal-lg">
<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"> TRANSFER </h2> </center>
</div>
<div class="modal-body" id="editbody12t">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!--for modal transfer--->
</form>
</div>
</body>
</html>