<?php
include "header.php";
include "sidebar.php";
?>

<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
	<!-- Content Header (Page header) -->
	<section class="content-header">
	  <h1>Inquires List
        <!-- <a href="add-subcategory.php" class="btn btn-primary pull-right" style="margin-top:-5px;margin-right:5px;"><i class="fa fa-plus"></i>&nbsp;Add New SubCategory</a> -->
		
    </h1>
	</section>

	<!-- Main content -->
	<section class="content">
		<div class="row">
			<div class="col-sm-12">
				<div class="box">
					<div class="box-body">
						<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='data_uploaded') { ?>
							<div class="row">
								<div class="col-sm-12">
									<div class="alert alert-success alert-dismissible">
										<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
										Record Added successfully!!.
									</div>
								</div>
							</div>
						<?php 
						$_SESSION['msg'] = '';
						} ?>

						<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='data_updated') { ?>
						<div class="row">
							<div class="col-sm-12">
								<div class="alert alert-success alert-dismissible">
									<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
									Record Updated successfully!!.
								</div>
							</div>
						</div>
						<?php 
						$_SESSION['msg'] = '';
						} 
						?>
						<?php if(isset($_SESSION['msg']) && $_SESSION['msg']=='delete_data') { ?>
							<div class="row">
								<div class="col-sm-12">
									<div class="alert alert-success alert-dismissible">
										<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
										Record Deleted !!.
									</div>
								</div>
							</div>
						<?php 

						$_SESSION['msg'] = '';
						} ?>	
						<table id="show-records-table" class="table table-bordered table-striped">
							<thead>
								<tr>
									<th># Sr. No.</th>
									<th>Name</th>
									<th>Phone Number</th>
									<th>Email</th>
									<th>Date</th>
									<th colspan="2">Action</th>
								</tr>
							</thead>
							<tbody>
								<?php
						$fetch_data=mysqli_query($con,	"SELECT * from contact_us order by id desc");


									// $fetch_data=mysqli_query($con,"SELECT * FROM sub_category left join category on category.id= sub_category.category_id") or die(mysqli_error($con));
									$i=1;
									if(mysqli_num_rows($fetch_data)>0) {
									while($data = mysqli_fetch_array($fetch_data)) {
								?>
								<tr>
									<td><?php echo $i;?></td>
									<td><?php echo $data['firstname'];?></td>
									<td><?php echo $data['number'];?></td>
									<td><?php echo $data['email'];?></td>
									<td><?php echo $data['created_date'];?></td>
									<td style="display: flex; justify-content: space-evenly;">
							 <a href="view-inquiry-details.php?id=<?php echo base64_encode($data['id']); ?>" class="btn btn-warning"  title="View"><i class="fa fa-eye"> View</i></a>

						  <a title="Click here to Delete This Record" class="show-pointer"><span class="btn btn-danger deleteButton " id="<?php echo base64_encode($data['id']);?>"><i class="fa fa-trash"> Delete</i></span></a>
						 </td>
								</tr>
								<?php $i++;   } }    ?>
							</tbody>
						</table>
					</div><!-- /.box-body -->
				</div><!-- /.box -->
			</div>
		</div>
		
		
		
	</section>
</div>	

<script>
$(".deleteButton").click(function() {
	var dataid = $(this).attr('id');
	if(confirm("Do you really want to delete this record?")) {
		window.location = "inquiry-process.php?action=delete&id="+dataid;
	}
});

$(function () {
	$('#show-records-table').DataTable({
	  "paging": true,
	  "lengthChange": true,
	  "searching": true,
	  "ordering": true,
	  "info": true,
	  "autoWidth": false
	});
});
</script>

<?php
include "footer.php";
?>

<script>
function openCategoryOrderSetup(event){
	var URL = 'category-ajax.php?action=getAllCategory';
	var POST = {
	}; 
	var data = callajax(URL,POST);
	// console.log(data);
	var Code  = data.code;
	var Data  = data.data;
	var MSG  = data.data;	
}
function callajax(URL,POST){
	var ajaxvalue = function () {
		var tmp_data = null;
		$.ajax({
			'async': false,
			'type': "POST",
			'global': false,
			'dataType': 'json',
			'url': URL,
			'data': POST,
			'success': function (response) {
				tmp_data = response;
			}
		});
		return tmp_data;
	}();
	return ajaxvalue;
}

</script>

<style>
#sortable-list li i{
 color: #fff;
    line-height: 18px;
}

#sortable-list li {
    display: flex !important;
    list-style: none !important;
    background-color: #0091EA !important;
    border-bottom: 1px solid #f8f8f8 !important;
    padding: 5px 10px !important;
    color: #fff !important;
    margin-bottom: 0.3rem !important;
}
    #sortable-list li p {
            padding-left: 10px;
    margin: 0px;
    }
    
    .modal-header .close {
    /* margin-top: -2px; */
    position: relative;
    top: -20px;
    font-size: 27px;
    color: #0091ea;
    opacity: 1;
}
</style>