<?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> 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">×</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">×</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">×</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>