invisio v2.0

<?php
	include('innerpageheader.php');
	
	include('config.php');
	
	$enqstat = 'Pending';
	$enqstat1 = '';
	$result = $js->prepare('SELECT * FROM `customer_entry` WHERE `enquirystatus` = :enqstat OR `enquirystatus` = :enqstat1 ORDER BY `entrydate`');
		$result->execute(array(':enqstat' => $enqstat,
								':enqstat1' => $enqstat1));
?>
		
		<section>
			<div class="content listing-content">
				<div class="in-content-wrapper">
					<div class="row no-gutters">

<div class="col">
							<div class="heading-messages">
								<h3>Customers</h3>
							</div>
						</div>
						<div class="col-md-4">
							<div class="breadcrumb">
								<div class="breadcrumb-item"><i class="fas fa-angle-right"></i><a href="#">Listing</a>
								</div>
								<div class="breadcrumb-item active"><i class="fas fa-angle-right"></i>All
								</div>
							</div>
						</div>
					</div>

<div class="box">
						<div class="row no-gutters">
							<div class="col-auto me-auto text-start pe-0">
								<div class="add-new">
									<a href="add_customer.php">Add New Customer<i class="fas fa-plus"></i></a>
								</div>
							</div>
							<div class="col text-end">
								<div class="tools-btns">
									<a href="#"><i class="fas fa-print" data-bs-toggle="tooltip" data-html="true" title="Print"></i></a>
									<a href="#"><i class="fas fa-file-pdf" data-bs-toggle="tooltip" data-html="true" title="Pdf"></i></a>
									<a href="#"><i class="fas fa-file-excel" data-bs-toggle="tooltip" data-html="true"
											title="Excel"></i></a>
								</div>
							</div>

</div>
						<div class="row no-gutters">
							<div class="col-12 table-responsive">
								<table id="example" class="table table-hover responsive listing">
									<thead>
										<tr>
											<th>#</th>
											<th>Name</th>
                                            <th>Phone Number</th>
                                            <th>Email</th>
                                            <th>Location</th>
                                            <th>Preferred Destination</th>
                                            <th>Planning Date</th>
                                            <th>No of Days</th>
                                            <th>No of Pax</th>
                                            <th>Print Enquiry</th>
                                            <th>Prepare Quotation</th>
                                            <th>Action</th>
										</tr>
									</thead>
									<tbody>
                                    
                                    <?php
										$i =1;
										
										while($row = $result->fetch(PDO::FETCH_ASSOC)) 
										{
											
											$id = $row['id'];
											$custid = $row['custid'];
											$custname = $row['custname'];
											$phone = $row['phone'];
											$email = $row['email'];
											$address = $row['address'];
											$location = $row['location'];
											$prefdest = $row['prefdest'];
											$planningdate = date('d-m-Y', strtotime($row['plannningdate']));
											$daysplanning = $row['daysplanning'];
											$pax = $row['pax'];
											$salesemail = $row['salesemail'];
											$website = $row['website'];
											
									?>

<tr>
											<td><?php echo $i?></td>
                                            <td><?php echo $custname?></td>
                                            <td><?php echo $phone?></td>
                                            <td><?php echo $email?></td>
                                            <td><?php echo $location?></td>
                                            <td><?php echo $prefdest?></td>
                                            <td><?php echo $planningdate?></td>
                                            <td><?php echo $daysplanning?></td>
                                            <td><?php echo $pax?></td>
                                            <td>
												<a href="view_detailedenquiry.php?custid=<?php echo $custid?>"><i class="fa fa-print" style="size:15px;"></i></a>
                                            </td>
                                            <td><a href="preparequotation.php?id=<?php echo $id?>" target="_blank"><i class="fa fa-quote-left" aria-hidden="true"></i></a></td>
											<td>
												<a href="edit_customers.php?id=<?php echo $id?>"><i class="fas fa-edit" style="size:15px;"></i></a>
												<a href="delete_vendors.php?id=<?php echo $id?>"><i class="fa fa-times-circle" style="color:red"></i></a>
											</td>
                                            
										</tr>
                                      <?php
											$i++;
										}
									  ?>

</tbody>
								</table>
							</div>
						</div>
					</div>
				</div>
			</div>
		</section>

</div>

<?php
	include('footer.php');
?>

<script src="js/jquery-3.3.1.min.js"></script>
	<script src="js/popper.min.js"></script>
	<script src="js/bootstrap-5.3.2.min.js"></script>
	<script src="vendors/datatables/datatables.min.js"></script>
	<script src="js/customscriptfile.js"></script>

</html>