<link rel="stylesheet" id="bootstrap-css" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" media="all">
<link rel="stylesheet" id="datatables-css" href="https://cdn.datatables.net/1.10.24/css/jquery.dataTables.min.css" media="all">
<link rel="stylesheet" id="fontawesome-css" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css" media="all">
<style>
	.page-numbers{
		display: inline-block;
		vertical-align: baseline;
		min-width: 30px;
		min-height: 30px;
		margin: 0;
		padding: 0 4px;
		font-size: 16px;
		line-height: 1.625;
		text-align: center;
		background: #fff;
		border: 1px solid #ccc;
		border-radius: 5px;
	}
</style>
<div class="wrap">
	<h2>Enquiry</h2>
	<table id="guestEnqTable" class="table table-striped table-bordered">
		<thead class="thead-dark">
		<tr>
			<th scope="row" class="manage-column">Sr. No</th>
			<th scope="col" class="manage-column">Lead ID</th>
			<th scope="col" class="manage-column">Date Raised</th>
			<th scope="col" class="manage-column">User Name</th>
			<th scope="col" class="manage-column">User Email</th>
			<th scope="col" class="manage-column">Phone</th>
			<th scope="col" class="manage-column">Product Name</th>
			<th scope="col" class="manage-column">Location</th>
			<th scope="col" class="manage-column">User Note</th>
			<th scope="col" class="manage-column">BA Comment</th>
			<th scope="col" class="manage-column">Last Updated</th>
			<th scope="col" class="manage-column">Status</th>
			<th scope="row" class="manage-column">Customer ID</th>
		</tr>
		</thead>
		<tbody>
			
			<?php
			global $wpdb;
			$query = $wpdb->prepare("SELECT * FROM wp_leads ORDER BY id DESC");
			$res = $wpdb->get_results($query);

			$i=1;
		foreach ($res as $row) {
			
			$userid = $row->user_id;
			if($userid == 0){
				$leadstatus = 'Guest User';
			}else{
				$leadstatus = 'RMS User';
			}
			?>
			<tr>
			<td><?php echo $i;?></td>
			<td><?php echo $row->lead_id;?></td>
			<td>Date Raised</td>
			<td><?php echo $row->full_name;?></td>
			<td><?php echo $row->lead_email;?></td>
			<td><?php echo $row->lead_phone;?></td>
			<td><?php echo $row->product_name;?></td>
			<td><?php echo $row->location;?></td>
			<td><?php echo $row->remarks;?></td>
			<td>Test</td>	
			<td>Last Updated Date</td>
			<td><?php echo $leadstatus;?></td>
			<td>Customer ID</td>
			</tr>
			<?php
			$i++;
		}
		
			?>
			
		</tbody>
		</table>
		
	</div>
	<script src="https://cdn.datatables.net/1.10.24/js/jquery.dataTables.min.js?ver=1.10.24" id="datatables-js-js"></script>
	<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js?ver=4.5.2" id="bootstrap-js-js"></script>
	<script>
        // Initialize DataTable
        jQuery(document).ready(function($) {
            $('#guestEnqTable').DataTable();
        });
    </script>