Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/www/website_93b53270/admin/manage_missing_enquiry/ |
Upload File : |
<?php
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));
include('../include/sidebar.php');
#$menu_id=$_GET['id'];
?>
<!-- [ Main Content ] start -->
<div class="pcoded-main-container">
<div class="pcoded-content">
<!-- [ breadcrumb ] start -->
<div class="page-header">
<div class="page-block">
<div class="row align-items-center">
<div class="col-md-12">
<div class="page-header-title">
<div class="card-header d-flex justify-content-between">
<button class="btn btn-dark btn-sm btn-round has-ripple"><i class="feather icon-check-square"></i> Manage Variant Enquiry </button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<div class="row">
<!-- [ col-md-12 ] start -->
<form method="post" action="">
<div class="col-md-12">
<div class="card">
<div class="card-header d-flex justify-content-between">
<h5>Manage Variant Enquiry</h5>
<div>
<input class="btn btn-danger btn-sm btn-round has-ripple" type="submit" value="Delete" name='but_delete'>
</div>
</div>
<div class="card-body">
<?php if(isset($_SESSION['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['message'].' <i class="feather icon-thumbs-up text-success"></i></strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['message']);
?>
<?php if(isset($_SESSION['error'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['error'].' <i class="feather icon-thumbs-up text-danger"></i></strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['error']);
?>
<?php if(isset($_SESSION['delete'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<strong class="text-dark">'.$_SESSION['delete'].' <i class="feather icon-trash-2 text-danger"></i></strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['delete']);
?>
<div class="table-responsive">
<table id="report-table" class="table table-bordered table-striped mb-0">
<thead>
<tr>
<th><input type="checkbox" id="some1" data-check-pattern="[name^='delete']" />
</th>
<th>Sno</th>
<th>User Id</th>
<th>Variant Name</th>
<th>Received date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$user_fetch_query=mysqli_query($conn,"SELECT * FROM missing_enquiry_tbl WHERE enquiry_type='Variant'");
$n=1;
while($fetch_row=mysqli_fetch_array($user_fetch_query)){ ?>
<tr>
<td><input type='checkbox' name='delete[]' value='<?=$fetch_row['id'];?>'></td>
<td><?=$n; $n++;?></td>
<td><?=$fetch_row['user_id']?></td>
<td><?=$fetch_row['name']?></td>
<td><?=$fetch_row['recieve_date']?></td>
<td>
<a href="variant.php?page=mdl&&delete_id=<?=$fetch_row['id']?>" class="btn btn-danger btn-sm"><i class="feather icon-trash-2"></i></a>
</td>
</tr>
<?php } ;?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</form>
<!-- col-md-12 end -->
</div>
<!-- [ Main Content ] end -->
</div>
</div>
<!-- Required Js -->
<script src="<?=$admin_url?>assets/js/vendor-all.min.js"></script>
<script src="<?=$admin_url?>assets/js/plugins/bootstrap.min.js"></script>
<script src="<?=$admin_url?>assets/js/ripple.js"></script>
<script src="<?=$admin_url?>assets/js/pcoded.min.js"></script>
<script src="<?=$admin_url?>assets/js/menu-setting.min.js"></script>
<script src="<?=$admin_url?>assets/js/plugins/jquery.dataTables.min.js"></script>
<script src="<?=$admin_url?>assets/js/plugins/dataTables.bootstrap4.min.js"></script>
<script>
// DataTable start
$('#report-table').DataTable();
// DataTable end
</script>
<?php
if(!empty($_GET['delete_id'])){
$id=$_GET['delete_id'];
$dtQuery=mysqli_query($conn,"DELETE FROM `enquiry_tbl` WHERE id='$id'");
if($dtQuery){
echo "<script>window.location='variant.php?page=mdl';</script>";
$_SESSION['delete']="Record Deleted Successfully";
}
}
?>
<?php
if(isset($_POST['but_delete'])){
if(isset($_POST['delete'])){
foreach($_POST['delete'] as $deleteid){
$deleteUser = "DELETE from enquiry_tbl WHERE id=".$deleteid;
mysqli_query($conn,$deleteUser);
echo "<script>window.location='variant.php?page=mdl';</script>";
$_SESSION['delete']="All Record Deleted Successfully";
}
}
}
?>
<script src='//cdnjs.cloudflare.com/ajax/libs/jquery/2.1.3/jquery.min.js'></script>
<script>
jQuery(function() {
jQuery('[data-check-pattern]').checkAll();
});
;(function($) {
'use strict';
$.fn.checkAll = function(options) {
return this.each(function() {
var mainCheckbox = $(this);
var selector = mainCheckbox.attr('data-check-pattern');
var onChangeHandler = function(e) {
var $currentCheckbox = $(e.currentTarget);
var $subCheckboxes;
if ($currentCheckbox.is(mainCheckbox)) {
$subCheckboxes = $(selector);
$subCheckboxes.prop('checked', mainCheckbox.prop('checked'));
} else if ($currentCheckbox.is(selector)) {
$subCheckboxes = $(selector);
mainCheckbox.prop('checked', $subCheckboxes.filter(':checked').length === $subCheckboxes.length);
}
};
$(document).on('change', 'input[type="checkbox"]', onChangeHandler);
});
};
}(jQuery));
</script>
</body>
</html>