|
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('Admission',$menuper)){
}else{
header("location:index.php");
}
$_SESSION['page_name']="Admission";
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 admission_enquiry_form where id='$doid'");
if($check){
$_SESSION['msg']='Record Deleted Successfully';
}
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=AdmissionEnquiryReports.php">';
exit;
}
?>
<div class="content-wrapper">
<section class="content-header">
<h1> Admission Reports</h1>
<ol class="breadcrumb">
<li><a href="Dashboard.php"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Admission Reports</a></li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<?php if(!empty($_SESSION['msg'])){
$msg=$_SESSION["msg"];
echo '<div class="col-md-12">
<div class="alert alert-success alert-dismissible">
<a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
'.$msg.'
</div>'; $_SESSION["msg"]='';} ?>
<div class="box">
<div class="box-header">
<h3 class="box-title">Admission Reports :</h3>
</div><!-- /.box-header -->
<div class="box-body" style="overflow-x: scroll;">
<form action="" method="get">
<select name="course" id="coursealert" class="form-control subject" style="width:200px;margin-left:200px;float:left;" required>
<option value=''>-select-</option>
<?php
$CasteQuery=mysqli_query($con,"select * from course");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($_REQUEST['course'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['c_name'].'</option>';
} ?>
</select>
<select name="academicyear" id="academicyear" style="width:200px;margin-left:30px;float:left;" class="form-control subject" required>
<option value=''>-select-</option>
</select>
<input type="submit" value="Search" name="search" class="btn btn-primary" style="width:100px;margin-left:30px;float:left;"/>
</form>
<table id="example1" class="table table-bordered table-striped" style="margin-top:20px;">
<thead>
<tr>
<th>No</th>
<th scope="col">View Receipt</th>
<th scope="col">Set Username/Password</th>
<th scope="col">Student ID</th>
<th scope="col">I Card</th>
<th scope="col">Name</th>
<th scope="col">Academic Year</th>
<th scope="col">Course</th>
<th scope="col">Photo</th>
<th scope="col">Father's Name</th>
<th scope="col">Mother's Name </th>
<th scope="col">DOB</th>
<th scope="col">Mobile</th>
<th scope="col">Caste</th>
<th scope="col">Last Qualification </th>
<th scope="col">Address </th>
<th scope="col">Consultant Name </th>
<th scope="col">Consultants Amount</th>
<th scope="col">Booking Amount</th>
<th scope="col">Submit Fee</th>
<th scope="col">Less Scholarship</th>
<th scope="col">Total Fee</th>
<th scope="col">Late Fine</th>
<th scope="col">Installment Amount</th>
<th scope="col">Due Amount</th>
<th scope="col">Total MISC FEE</th>
<th scope="col">Due MISC FEE</th>
<th scope="col">Signature</th>
<th scope="col">Aadhar Card</th>
<th scope="col">H.S Marksheet</th>
<th scope="col">Graduation Marksheet</th>
<th scope="col">Masters Marksheet</th>
<th scope="col">MADHYAMIC ADMIT :</th>
<th scope="col">MC RESOLUTION :</th>
<th scope="col">DI PERMISION:</th>
<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
<th scope="col">Action</th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php
if(!empty($_GET['course']) && !empty($_GET['academicyear'])){
$Query=mysqli_query($con,"select *,admission_enquiry_form.address as student_address,consultants.name as consult_name,admission_enquiry_form.id as sid,admission_enquiry_form.name as student_name from admission_enquiry_form
left JOIN caste as castes ON admission_enquiry_form.caste=castes.CasteID left JOIN religion as
religions ON admission_enquiry_form.religion=religions.ReligionID left JOIN course as
course ON admission_enquiry_form.course=course.id
left JOIN commenacademicyear as
commenacademicyear ON admission_enquiry_form.academicyear=commenacademicyear.id
left JOIN consultants as
consultants ON admission_enquiry_form.consultants=consultants.id
where course.id='".$_GET['course']."' AND commenacademicyear.id='".$_GET['academicyear']."'
order by admission_enquiry_form.id desc
");
}else{
$Query=mysqli_query($con,"select *,admission_enquiry_form.address as student_address,consultants.name as consult_name,admission_enquiry_form.id as sid,admission_enquiry_form.name as student_name from admission_enquiry_form
left JOIN caste as castes ON admission_enquiry_form.caste=castes.CasteID left JOIN religion as
religions ON admission_enquiry_form.religion=religions.ReligionID left JOIN course as
course ON admission_enquiry_form.course=course.id
left JOIN commenacademicyear as
commenacademicyear ON admission_enquiry_form.academicyear=commenacademicyear.id
left JOIN consultants as
consultants ON admission_enquiry_form.consultants=consultants.id
order By admission_enquiry_form.id desc
");
}
$i = 1;
while($Row=mysqli_fetch_array($Query)){ ?>
<tr>
<td><?php echo $i; ?></td>
<td> <a href='./provisionbed.php?upid=<?php echo $Row["student_id"]; ?>'><i class='fa fa-eye'></i></a><br/></td>
<td> <a href='./credentials.php?upid=<?php echo $Row["student_id"]; ?>'><i class='fa fa-key'></i></a><br/></td>
<td><?php echo $Row["student_id"]; ?></td>
<td> <a href='./icard.php?upid=<?php echo $Row["student_id"]; ?>'><i class='fa fa-user'></i></a><br/></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['student_name'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['academictitle'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['c_name'];?></span></td>
<td><img src="images/StudentEnquiry/<?php echo $Row['photos'];?>" height="70" width="70" /></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelMobile_0"><?=$Row['fname'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row['mname'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelApplicationTypeName_0"><?=$Row['dob'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?=$Row['mobileno'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0"><?=$Row['CasteName'];?></span>
</td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['lastqualification'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['student_address'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['consult_name'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['consultants_amount'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['bookingamount'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['submitfee'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['lessdiscount'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['totalfee'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['latefine'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['installmentamount'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['dueamount'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['miscfeetotal'];?></span></td>
<td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelCastName_0">
<?=$Row['duemiscfee'];?></span></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['signature'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['signature'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['adharcard'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['adharcard'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['studentdoc'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['studentdoc'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['graduationmark'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['graduationmark'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['mastermark'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['mastermark'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['madhymicmarksheet'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['madhymicmarksheet'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['mcresolation'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['mcresolation'];?>" height="70" width="70" /></a></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['dipermission'];?>" download><img src="images/StudentEnquiry/<?php echo $Row['dipermission'];?>" height="70" width="70" /></a></td>
<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1){ ?>
<td>
<?php if($Row['admissiontype']=='Enquiry'){ ?>
<a href="./admission_form_enquiry.php?upid=<?php echo $Row["sid"]; ?>"><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> -->
<?php }else{ ?>
<a href="./direct_admission.php?upid=<?php echo $Row["sid"]; ?>"><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> -->
<?php } ?>
</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 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>