|
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/bengaledu.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('CONSULTANT',$menuper)){
}else{
header("location:index.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 installment_consultants_payments where id='$doid'");
if($check){
$_SESSION['msg']='Record Deleted Successfully';
}
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=consultant_installment_pay.php">';
exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="ConsultantPayForm";
$doid=$_REQUEST['upid'];
if($_REQUEST['editdata']==1){
$upuserresult=mysqli_query($con,"select * from installment_consultants_payments where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
}else{
$upuserresult=mysqli_query($con,"select * from consultants_payments where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
}
}else{
$dovalue="ConsultantPayForm";
$doid='';
}
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
<h3 class="box-title">REPORT</h3>
</div>
<!-- /.box-header -->
<div class="box-body">
<form name="datesearch" method="get" action="" class="pull-right">
Form: <input id="demo1" name="datefrom" placeholder="yyyy-mm-dd" type="text" value="<?php if(!empty($_GET['datefrom'])){ echo $_GET['datefrom'];}else{ } ?>">
To: <input id="demo1" name="dateto" placeholder="yyyy-mm-dd" type="text" value="<?php if(!empty($_GET['dateto'])){ echo $_GET['dateto'];}else{ } ?>" size="25">
<input type="submit" value="Search" class='btn btn-primary' >
</form>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th scope="col">No</th>
<th scope="col">Student Id</th>
<th scope="col">Student Name</th>
<th scope="col">Consultant Name</th>
<th scope="col"> Consultant Number</th>
<th scope="col"> Consultant Amount</th>
<th scope="col"> Consultant Due</th>
<th scope="col">Submit Amount</th>
<th scope="col">Payment Mode</th>
<th scope="col">Created Date</th>
<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
<th scope="col">Action</th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php
if(!empty($_GET['datefrom']) && !empty($_GET['dateto'])){
$start =$_GET["datefrom"];
$end =$_GET["dateto"];
$Query=mysqli_query($con,"select *,installment_consultants_payments.id as sid,
installment_consultants_payments.paymentmode as paymentmodes,
consultants.name as con_name,
consultants.email as con_email,consultants.phone as con_phone, admin.username as
uname,direct_admission.name as stu_name from installment_consultants_payments left
JOIN consultants ON installment_consultants_payments.consultants_id=consultants.id left
JOIN direct_admission ON installment_consultants_payments.student_id=direct_admission.student_id
left JOIN admin ON installment_consultants_payments.user_id=admin.id
left JOIN consultants_payments ON installment_consultants_payments.con_payments=consultants_payments.id
WHERE installment_consultants_payments.created_at between '".$start."' and '".$end."'
and installment_consultants_payments.con_payments='".$_REQUEST['upid']."'
"
);
}else{
$Query=mysqli_query($con,"select *,installment_consultants_payments.id as sid,
installment_consultants_payments.paymentmode as paymentmodes,
consultants.name as con_name,
consultants.email as con_email,consultants.phone as con_phone, admin.username as uname,direct_admission.name
as stu_name from installment_consultants_payments left JOIN consultants ON
installment_consultants_payments.consultants_id=consultants.id left JOIN direct_admission
ON installment_consultants_payments.student_id=direct_admission.student_id
left JOIN admin ON installment_consultants_payments.user_id=admin.id
left JOIN consultants_payments ON installment_consultants_payments.con_payments=consultants_payments.id
where installment_consultants_payments.con_payments='".$_REQUEST['upid']."'
");
}
$i = 1;
$k=1;
while($Row=mysqli_fetch_array($Query)){
if($k==$i){
?>
<tr>
<td><?php echo $i; ?></td>
<td><?=$Row['student_id'];?></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['stu_name'];?></span></td>
<td><?=$Row['con_name'];?></td>
<td><?=$Row['con_phone'];?></td>
<td><?=$Row['consultants_payments'];?></td>
<td><?=$Row['due'];?></td>
<td>
<?php $Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid
from installment_consultants_payments where student_id='".$Row['student_id']."'
");
while($Row2=mysqli_fetch_array($Query1)){
?>
<?=$Row2['submitamount'];?><br>
<?php } ?>
</td>
<td>
<?php
$Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid
from installment_consultants_payments where student_id='".$Row['student_id']."'
");
while($Row2=mysqli_fetch_array($Query1)){
?>
<?=$Row2['paymentmode'];?><br>
<?php } ?><br/>
</td>
<td>
<?php
$Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid
from installment_consultants_payments where student_id='".$Row['student_id']."'
");
while($Row2=mysqli_fetch_array($Query1)){
?>
<?php echo $Row2['created_at']; ?><br/>
<?php } ?>
</td>
<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
<td>
<?php
$Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid
from installment_consultants_payments where student_id='".$Row['student_id']."'
");
while($Row2=mysqli_fetch_array($Query1)){
?>
<a href="?upid=<?php echo $Row["sid"]; ?>&editdata=1"><i class="fa fa-pencil text-yellow"></i></a>
<a href="?did=<?php echo $Row["sid"]; ?>"><i class="fa fa-remove text-red"></i></a><br/>
<?php } ?>
</td>
<?php } ?>
</tr>
<?php $k=1; }else{ $k++; }?>
<?php $i++;} ?>
</tbody>
</table>
</div>
<!-- /.box-body -->
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
</div>
<?php include('include/footer.php');?>
<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">
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false
});
});
</script>