|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/miereducation.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
$installment_id=mysqli_fetch_array($installment_id);
$installment_id=$installment_id['menuper'];
$menuper=explode(',',$installment_id);
if(in_array('Manage Fee',$menuper)){
}else{
header("location:index.php");
}
$_SESSION['page_name']="Fee";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
?>
<script src="plugins/jQuery/jQuery-2.1.4.min.js" type="text/javascript"></script>
<div class="content-wrapper">
<section class="content-header">
<h1> Monthly Fee Reports</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Monthly Fee Reports</a></li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
</div><!-- /.box-header -->
<div class="box-body" style="overflow-x: scroll;">
<!-- <form action="" method="get" id="tables">
<select class='form-control col-md-3' id="tablechange" name="table" style="width: 24%;" >
<option value="0" <?php //if($_GET['table']==0){ echo "selected";}?>> Admission Enquiry Form </option>
<option value="1" <?php //if($_GET['table']==1){ echo "selected";}?>>Direct Admission </option>
</select>
<input type="submit" value="Search" class="btn btn-primary"/>
</form> -->
<table id="example1" class="table table-bordered table-striped">
<?php if(!empty($_SESSION['msg'])){
$msg=$_SESSION["msg"];
echo '<div class="col-md-8">
<div class="alert alert-success alert-dismissible">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
'.$msg.'
</div>'; $_SESSION["msg"]='';} ?>
<thead>
<tr>
<th>SR NO</th>
<th>Student ID</th>
<th scope="col">Name</th>
<th scope="col">Course</th>
<th scope="col">Academic Year</th>
<th scope="col">Mobile No</th>
<th scope="col"> Fee_Name </th>
<th scope="col">Amount</th>
<th scope="col">Reciepts</th>
<th scope="col">Start_Date</th>
<th scope="col">End_Date</th>
<th scope="col"> Pay </th>
</tr>
</thead>
<tbody>
<?php
$totalpaidamount=0;
$totalallamount=0;
$totalpaidfine=0;
if(!empty($_GET['course']) && !empty($_GET['academicyear'])){
$Query= "select * from admission_enquiry_form
left JOIN course as
course ON admission_enquiry_form.course=course.id
left JOIN commenacademicyear as
commenacademicyear ON admission_enquiry_form.academicyear=commenacademicyear.id
where course.id='".$_GET['course']."' AND commenacademicyear.id='".$_GET['academicyear']."'
";
}else{
$Query= "select * from admission_enquiry_form
left JOIN course as
course ON admission_enquiry_form.course=course.id
left JOIN commenacademicyear as
commenacademicyear ON admission_enquiry_form.academicyear=commenacademicyear.id
";
}
$Query= mysqli_query($con,$Query);
$i = 1;
$totalfee=0;
$remainingfee=0;
$paidfee=0;
while($Row=mysqli_fetch_array($Query)){
$id=$Row['student_id'];
$Query2=mysqli_query($con,"select * from setmonthlyfee where student_id='$id'");
$num2=mysqli_num_rows($Query2);
if($num2>0){
?>
<tr>
<td><span id=""><?=$i;?></span></td>
<td><span id=""><?=$Row['student_id'];?></span></td>
<td><span id=""><?=$Row['name'];?></span></td>
<td><span id=""><?=$Row['c_name'];?></span></td>
<td><span id=""><?=$Row['academictitle'];?></span></td>
<td><span id=""><?=$Row['mobileno'];?></span></td>
<td>
<?php
$id=$Row['student_id'];
$getfeeQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$id."'");
while($getfeeR=mysqli_fetch_array($getfeeQ)){
$getfeenameQ=mysqli_query($con,"select * from miscfeemaster where id=".$getfeeR['miscfeemaster_id']);
$getfeenameR=mysqli_fetch_array($getfeenameQ);
?>
<span id=""><?=$getfeenameR['feemaster'];?></span><br/>
<?php
}
?>
</td>
<td>
<?php
$id=$Row['student_id'];
$getfeeQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$id."'");
while($getfeeR=mysqli_fetch_array($getfeeQ)){
$getfeeamountQ=mysqli_query($con,"select * from miscfeemaster where id=".$getfeeR['miscfeemaster_id']);
$getfeeamountR=mysqli_fetch_array($getfeeamountQ);
$totalfee+=$getfeeamountR['amount'];
?>
<span id=""><?=$getfeeamountR['amount'];?></span><br/>
<?php
}
?>
</td>
<td>
<?php
$monthlyfeeQ=mysqli_query($con,"select id from setmonthlyfee where student_id='".$Row['student_id']."' order by id asc");
while($monthlyfeeR=mysqli_fetch_array($monthlyfeeQ)){
$paidfeeQ=mysqli_query($con,"select id from paymonthlyfee where setmonthlyfee_id='".$monthlyfeeR['id']."' order by id asc");
$i=0;
while($paidfeeR=mysqli_fetch_array($paidfeeQ)){$i++;
?>
<span id="">
<a href='./receipt_monthly_sub.php?upid=<?php echo $paidfeeR["id"]; ?>&num=<?=$i;?>'><i class='fa fa-eye'></i></a>
</span>
<?php
}
echo "<br />";
}
?>
</td>
<td>
<?php
$id=$Row['student_id'];
$getfeeQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$id."'");
while($getfeeR=mysqli_fetch_array($getfeeQ)){
$getfeeamountQ=mysqli_query($con,"select * from miscfeemaster where id=".$getfeeR['miscfeemaster_id']);
$getfeeamountR=mysqli_fetch_array($getfeeamountQ);
?>
<span id=""><?=$getfeeamountR['start'];?></span><br/>
<?php
}
?>
</td>
<td>
<?php
$id=$Row['student_id'];
$getfeeQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$id."'");
while($getfeeR=mysqli_fetch_array($getfeeQ)){
$getfeeamountQ=mysqli_query($con,"select * from miscfeemaster where id=".$getfeeR['miscfeemaster_id']);
$getfeeamountR=mysqli_fetch_array($getfeeamountQ);
?>
<span id=""><?=$getfeeamountR['end'];?></span><br/>
<?php
}
?>
</td>
<td>
<?php
$id=$Row['student_id'];
$getfeeQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$id."' order by id asc");
while($getfeeR=mysqli_fetch_array($getfeeQ)){
$getfeeamountQ=mysqli_query($con,"select * from miscfeemaster where id=".$getfeeR['miscfeemaster_id']);
$getfeeamountR=mysqli_fetch_array($getfeeamountQ);
$getfeepaidQ=mysqli_query($con,"select id,sum(payment_amount) as payment_amount from paymonthlyfee where student_id='".$id."' AND setmonthlyfee_id=".$getfeeR['id']." order by setmonthlyfee_id asc");
$getfeepaidR=mysqli_fetch_array($getfeepaidQ);
if($getfeeamountR['amount']==$getfeepaidR['payment_amount']){
$paidfee+=$getfeeamountR['amount'];
?>
<a href="#"><i class="fa fa-paypal text-green"></i></a><br/>
<?php
}else{
$remainingfee+=$getfeeamountR['amount'];
?>
<a href="./paysetmonthlyfee.php?upid=<?=$getfeeR['id']; ?>"><i class="fa fa-paypal text-red"></i></a> <?php echo $getfeeamountR['amount']-$getfeepaidR['payment_amount']; ?><br/>
<?php
}
}
?>
</td>
</tr>
<?php }$i++;} ?>
</tbody>
<tr>
<td></td>
<td><b>Total Fee:</b><br/><?=$totalfee;?></td>
<td><b>Paid Fee:</b><br/><?=$paidfee;?></td>
<td><b>Remaining Fee:</b><br/><?=$remaining;?></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<!-- DataTables -->
<script src="plugins/datatables/jquery.dataTables.min.js" type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js" type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="bootstrap/js/jszip.min.js" type="text/javascript"></script>
<script src="bootstrap/js/pdfmake.min.js" type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.colVis.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#example1').DataTable( {
dom: 'Bfrtip',
columnDefs: [
{
targets: 1,
className: 'noVis'
}
],
buttons: [
{
extend: 'colvis',
columns: ':not(.noVis)'
}
],
buttons: [
{ extend: 'colvis', text: 'COLOUMNS' },
{ extend: 'csv', text: 'Export to CSV' },
{ extend: 'excel', text: 'Export to Excel' },
{ extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
],
} );
var htmls='';
var course=$('#coursealert :selected').val();
$.ajax({
type: "POST",
url: "getacademicyear.php",
data: {'course': course,'type':'load'},
dataType: "json",
success: function(dataString) {
$.each(dataString, function(key,valv) {
htmls+= "<option value='"+ valv.id +"'>" + valv.academictitle + "</option>";
});
$('#academicyear').append(htmls);
}
});
} );
//$(function () {
//$("#example1").DataTable();
//});
</script>
<script>
$('#coursealert').on('change',function(){
var htmls='';
$('#academicyear').html('');
var course=$('#coursealert :selected').val();
$.ajax({
type: "POST",
url: "getacademicyear.php",
data: {'course': course},
dataType: "json",
success: function(dataString) {
$.each(dataString, function(key,valv) {
htmls+= "<option value='"+ valv.id +"'>" + valv.academictitle + "</option>";
});
$('#academicyear').append(htmls);
}
});
});
</script>