db->select('*');
$this->db->from('book_service');
$this->db->where('tokenid !=', '');
$this->db->order_by('id','DESC');
$this->db->limit(5);
$query = $this->db->get();
$list_payments= $query->result_array();
?>
# |
Date |
Provider |
Service |
Amount |
Status |
db->where('id',$rows['provider_id'])->get('providers')->row_array();
$user_name = $this->db->where('id',$rows['user_id'])->get('users')->row_array();
$service = $this->db->where('id',$rows['service_id'])->get('services')->row_array();
$service = $this->db->where('id',$rows['service_id'])->get('services')->row_array();
$admin_payment = $this->db->where('booking_id',$rows['id'])->get('admin_payment')->row_array();
$color='';
if($rows['status'] == 1) {
$status = 'Pending';
$color='warning';
}
elseif($rows['status'] == 2) {
$status = 'Inprogress';
$color='primary';
}
elseif($rows['status'] == 3) {
$status = 'Completed Provider';
$color='success';
}
elseif($rows['status'] == 5) {
$status = 'Rejected';
$color='danger';
}
elseif($rows['status'] == 6) {
$status = 'Accepted';
$color='success';
}
elseif($rows['status'] == 7) {
$status = 'Cancelled Provider';
$color='danger';
}
?>
|
=date('d-m-Y',strtotime($rows['service_date']));?> |
|
|
|
|
No records found |