File: /var/www/html/nt/list.php
<div class="app-content pt-3 p-md-3 p-lg-3">
<div class="container-xl">
<?php if ($this->session->flashdata('success_msg')) : ?>
<div class="alert alert-success">
<a href="" class="close" data-dismiss="alert" aria-label="close" title="close" style="position: absolute;right: 15px;font-size: 30px;color: red;top: 5px;">×</a>
<?php echo $this->session->flashdata('success_msg') ?>
</div>
<?php endif ?>
<?php if ($this->session->flashdata('error_msg')) : ?>
<div class="alert alert-danger">
<a href="" class="close" data-dismiss="alert" aria-label="close" title="close" style="position: absolute;right: 15px;font-size: 30px;color: red;top: 5px;">×</a>
<?php echo $this->session->flashdata('error_msg') ?>
</div>
<?php endif ?>
<div class="row g-3 mb-4 align-items-center justify-content-between">
<div class="col-auto">
<h1 class="app-page-title mb-0">Application List</h1>
</div>
</div>
<!--//row-->
<div class="app-card app-card-orders-table shadow-sm mb-5">
<div class="app-card-body p-3">
<!-- <div class="col-auto"> -->
<!-- <div class="page-utilities"> -->
<form method="POST">
<div class="row g-2 justify-content-start justify-content-md-end align-items-center">
<!--//col-->
<div class="col-lg-3 col-md-6">
<select name="project_id" class="form-select select2" id="project_id">
<option value="0">All Project</option>
<?php
if ($projects)
foreach($projects as $row) {
?>
<option value="<?= $row['project_id']; ?>" <?= set_select('project_id', $row['project_id'], isset($project_id) && $project_id == $row['project_id'] ? true : false); ?>><?= $row['project_name']; ?></option>
<?php } ?>
</select>
</div>
<div class="col-lg-3 col-md-6">
<select name="application_status" class="form-select select2" id="application_status">
<option value="0">All Status</option>
<option value="Application Received" <?= ($application_status == 'Application Received') ? 'selected' : '' ?>>Application Received</option>
<option value="Pending for Physical Verification of Uploaded Document" <?= ($application_status == 'Pending for Physical Verification of Uploaded Document') ? 'selected' : '' ?>>Pending for Physical Verification of Uploaded Document</option>
<option value="Rejected in Physical Verification" <?= ($application_status == 'Rejected in Physical Verification') ? 'selected' : '' ?>>Rejected in Physical Verification</option>
<option value="Withdrawn after Site Inspection" <?= ($application_status == 'Withdrawn after Site Inspection') ? 'selected' : '' ?>>Withdrawn after Site Inspection</option>
<option value="Withdrawn" <?= ($application_status == 'Withdrawn') ? 'selected' : '' ?>>Withdrawn</option>
<option value="Amount Refunded" <?= ($application_status == 'Amount Refunded') ? 'selected' : '' ?>>Amount Refunded</option>
<option value="Eligible for Lottery" <?= ($application_status == 'Eligible for Lottery') ? 'selected' : '' ?>>Eligible for Lottery</option>
</select>
</div>
<div class="col-lg-2 col-md-4">
<input type="date" class="form-control" name="start_date"
value="<?= !empty($start_date) ? date('Y-m-d', strtotime($start_date)) : "" ?>">
</div>
<div class="col-lg-2 col-md-4">
<input type="date" class="form-control" name="end_date"
value="<?= !empty($end_date) ? date('Y-m-d', strtotime($end_date)) : "" ?>">
</div>
<div class="col-lg-2 col-md-4">
<button class="btn app-btn-primary">
Search
</button>
</div>
</div>
</form>
<!--//row-->
<!-- </div> -->
<!--//table-utilities-->
<!-- </div> -->
<!--//col-auto-->
</div>
</div>
<div class="app-card app-card-orders-table shadow-sm mb-5">
<div class="app-card-body">
<div class="table-responsive">
<table id="application_list_table" class="table app-table-hover mb-0 text-left">
<thead>
<tr>
<th class="small notexport">Action</th>
<th class="small">Present Status</th>
<th class="small">Date</th>
<th class="small">Transaction ID</th>
<th class="small">Application No.</th>
<th class="small">Money Receipt No.</th>
<th class="small">Application Type</th>
<th class="small">Amount (INR)</th>
<th class="small">Payment Mode</th>
<th class="small">Reference No.</th>
<th class="small">Sole/First Applicant</th>
<th class="small">PAN</th>
<th class="small">Residential Status</th>
<th class="small">Co-Applicant</th>
<th class="small">Residential Status</th>
<th class="small">Relation</th>
<th class="small">Family Income Criteria</th>
<th class="large">Project</th>
<th class="small">Sub-Type</th>
<th class="small">Built up Area</th>
</tr>
</thead>
<tbody>
<?php
if(!empty($applications)){
foreach($applications as $row){
?>
<tr>
<td class="text-center">
<div class="btn-group dropend">
<button type="button" class="btn btn-primary dropdown-toggle" data-bs-toggle="dropdown" aria-expanded="false">
<i class="fa fa-ellipsis-v"></i>
</button>
<ul class="dropdown-menu p-0">
<li><a class="btn btn-primary text-white w-100 rounded-0 mb-1" href="<?php echo base_url();?>admin/application_list/detailedView/<?php echo encode_url($row['application_id']);?>">View Details</a></li>
<li><a class="btn btn-danger text-white w-100 rounded-0 mb-1" href="<?php echo base_url();?>admin/application_list/zip/<?php echo encode_url($row['applicant_id']);?>">Download Files</a></li>
<li><a class="btn btn-warning text-white w-100 rounded-0 mb-1" href="<?php echo base_url();?>admin/application_list/print_application_form/<?php echo encode_url($row['application_id']);?>" target="_blank">Print Application Form</a></li>
</ul>
</div>
<!-- <a class="btn btn-primary text-white text-white" href="<?php echo base_url();?>admin/application_list/zip/<?php echo encode_url($row['applicant_id']);?>" style="width:120px;">Download Files</a> -->
</td>
<td>
<span class="badge" style="background: <?php echo $row['colour'];?>;"><?php echo $row['application_status'];?></span>
</td>
<td><?php echo date('d F Y', strtotime($row['payment_date']));?></td>
<td><?php echo $row['transaction_ref_id'];?></td>
<td><?php echo $row['application_no'];?></td>
<td><?php echo $row['money_receipt_no'];?></td>
<td><?php echo $row['application_type'];?></td>
<td><?php echo IND_money_format($row['amount']);?></td>
<td><?php echo $row['payment_mode'];?></td>
<td><?php echo $row['bank_upi_ref_num'];?></td>
<td><?php echo $row['aui_full_name'];?></td>
<td><?php echo $row['pancard_no'];?></td>
<td><?php echo $row['aui_residential_status'];?></td>
<td><?php echo $row['second_applicant_name'];?></td>
<td><?php echo $row['second_applicant_rs'];?></td>
<td><?php echo $row['second_applicant_rma'];?></td>
<td><?php echo $row['category_name'];?></td>
<td><?php echo $row['project_name'];?></td>
<td><?php echo $row['sub_type'];?></td>
<td><?php echo $row['std_built_area'];?></td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
<!--//table-responsive-->
</div>
<!--//app-card-body-->
</div>
</div>
<!--//container-fluid-->
</div>
<script>
$(document).ready(function() {
var today = new Date();
$('#application_list_table').DataTable({
// "order": [[ 3, "desc" ]],
//"paging": false,
//"showNEntries" : false,
//"bPaginate": false,
//"bFilter": false,
"bInfo": false,
"dom": 'Bfrtip',
buttons: [{
"extend": 'excel',
"text": 'Download Excel',
exportOptions: {
columns: ':visible',
orthogonal: null,
format: {
body: function (data, row, column, node) {
var momentDate = moment(data, 'DD/MM/YYYY', true);
if (momentDate.isValid()) {
return momentDate.format('YYYY-MM-DD');
}
else {
return data;
}
}
}
} ,
'className': 'btn app-btn-primary',
'filename': 'Application_List'+ today.getFullYear()+'-'+(today.getMonth()+1)+'-'+today.getDate()+'_'+today.getHours() + ":" + today.getMinutes() + ":" + today.getSeconds(),
exportOptions: {
columns: ':visible:not(.notexport)'
}
}
],
initComplete: function() {
var btns = $('.dt-button');
btns.removeClass('dt-button');
},
// "searching": false
});
});
</script>