File: //var/www/html/qcr24/app/application/views/admin/reports/payment_success_list.php
<style>
.error {
color: red;
}
</style>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jquery-confirm/3.3.4/jquery-confirm.min.css" integrity="sha512-0V10q+b1Iumz67sVDL8LPFZEEavo6H/nBSyghr7mm9JEQkOAm91HNoZQRvQdjennBb/oEuW+8oZHVpIKq+d25g==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-confirm/3.3.4/jquery-confirm.min.js" integrity="sha512-zP5W8791v1A6FToy+viyoyUUyjCzx+4K8XZCKzW28AnCoepPNIXecxh9mvGuy3Rt78OzEsU+VCvcObwAMvBAww==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.5/jquery.validate.min.js" integrity="sha512-rstIgDs0xPgmG6RX1Aba4KV5cWJbAMcvRCVmglpam9SoHZiUCyQVDdH2LPlxoHtrv17XWblE/V/PP+Tr04hbtA==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<main class="main users job-role-page" id=""><main class="main users job-role-page" id="">
<div class="container">
<!-- <h2 class="main-title">Job Role</h2> -->
<?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;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;top: 5px;">×</a>
<?php echo $this->session->flashdata('error_msg') ?>
</div>
<?php endif ?>
<div class="row justify-content-between">
<div class="col-auto">
<h2 class="app-page-title mrg15B">List of Success Payments</h2>
</div>
</div>
<div class="white-block mrg15T">
<form action="<?=base_url('admin/reports/payments_success')?>" class="row" method="GET" autocomplete="off">
<div class="col-lg-6 col-md-6">
<div class="form-group">
<label for="" class="">Select Date </label>
<div class="row" style="align-items: center;">
<div class="col-1">
From
</div>
<div class="col-5">
<div class="Datepicker_sec">
<input type="text" class="form-control" id="from_date" name="from_date" value="<?=($search_array['from_date'])?date('d/m/Y',strtotime($search_array['from_date'])):''?>">
</div>
</div>
<div class="col-1">
TO
</div>
<div class="col-5">
<div class="Datepicker_sec">
<input type="text" class="form-control" id="to_date" name="to_date" value="<?=($search_array['to_date'])?date('d/m/Y',strtotime($search_array['to_date'])):''?>">
</div>
</div>
</div>
</div>
</div>
<div class="col-lg-3 col-md-3">
<div class="form-group">
<label for="" class="">Select Company </label>
<select name="company_id" id="company_id" class="form-control select2" style="border-radius: 0;">
<option value="" selected>Select All</option>
<?php foreach($companies as $company){?>
<option value="<?=$company['company_id']?>" <?=($company['company_id'] == $search_array['company_id'])?'selected':''?>><?=$company['company_name']?></option>
<?php } ?>
</select>
</div>
</div>
<!-- <div class="col-lg-4 col-md-4">
<div class="form-group">
<label for="" class="">Select Car No. <span class="asterisk"> *</span></label>
<select class="form-control select2" style="width: 100%;" id="car_id" name="car_id">
<option selected="selected" disabled>Select Car </option>
<?php foreach($cars as $car){?>
<option value="<?=$car['car_id']?>"><?=$car['car_no']?></option>
<?php } ?>
</select>
</div>
</div> -->
<div class="col-lg-1 col-md-1">
<div class="form-group">
<label for="" class="" style="opacity: 0;">Search <span class="asterisk"> *</span></label>
<button type="submit" class="btn app-btn-primary search">Search</button>
</div>
</div>
<div class="col-lg-1 col-md-1" style="margin-left: 10px;">
<div class="form-group">
<label for="" class="" style="opacity: 0;">Clear <span class="asterisk"> *</span></label>
<a href="<?=base_url('admin/reports/payments_success')?>" class="btn btn-danger search">CLEAR</a>
</div>
</div>
</form>
</div>
<div class="row" style="margin-top:15px;">
<div class="col-lg-12">
<div class="users-table table-wrapper">
<table class="table" id="example">
<thead>
<tr class="users-table-info">
<th>SL No.</th>
<th>Payment Code</th>
<th>Driver Name</th>
<th>Car No</th>
<th>Paid Time</th>
<th>Clears Time</th>
<th>Settled Time </th>
<th>Payment Status</th>
<th>Amount</th>
<th>Amount Inc Fees</th>
</tr>
</thead>
<tbody>
<?php if(!empty($payments)){
$i=0;
foreach($payments as $row){$i++;
?>
<tr>
<td><?= $i?></td>
<td><?=$row['payment_code']?></td>
<td><?=$row['first_name'].' '.$row['middle_name'].' '.$row['last_name']?></td>
<td><?=$row['car_no']?></td>
<td><?=($row['paid_ts'])?date('d/m/Y H:i:s',strtotime($row['paid_ts'])):''?></td>
<td><?=($row['clears_date'])?date('d/m/Y H:i:s',strtotime($row['clears_date'])):''?></td>
<td><?=($row['settled_date'])?date('d/m/Y H:i:s',strtotime($row['settled_date'])):''?></td>
<td><a class="<?=($row['payment_status'] == 'Success')?'badge-success':'badge-danger'?>" style="margin-top:3px;"><?=$row['payment_status']?></a></td>
<td><?=$row['amount']?></td>
<td><?=$row['amount_inc_fees']?></td>
</tr>
<?php }
} ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</main>
<script>
$(document).ready(function () {
$("#from_date").datepicker({
dateFormat: 'dd/mm/yy',
changeMonth: true,
changeYear: true,
maxDate: '1',
onClose: function( selectedDate ) {
$( "#to_date" ).datepicker( "option", "minDate", selectedDate );
}
});
$("#to_date").datepicker({
dateFormat: 'dd/mm/yy',
changeMonth: true,
changeYear: true,
maxDate: '1',
onClose: function( selectedDate ) {
$( "#from_date" ).datepicker( "option", "maxDate", selectedDate );
}
});
//Initialize Select2 Elements
$('.select2').select2();
})
</script>