|
Server IP : 103.53.40.154 / Your IP : 3.129.216.15 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/ppcad7no/naturewoodfloor.in/../asinteriors.in/../ntimachinery.com/webpanel/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include('config/function.php');
if(!isset($_SESSION['user_name']) || empty($_SESSION['user_name']))
{
header('location:login.php');
exit();
}
if(isset($_GET['id']) && $_GET['id']!="")
{
$id = $_GET['id'];
$query_select = "SELECT * FROM cms_menu WHERE id ='".$id."'";
if($sql_select = $conn->query($query_select))
{
$result = $sql_select->fetch_array(MYSQLI_ASSOC);
@unlink("uploads/video/".$result['video']);
@unlink("uploads/fvicon/".$result['fvicon']);
@unlink("uploads/up_image/".$result['up_image']);
@unlink("uploads/up_pdf/".$result['up_pdf']);
}
$query_delete="DELETE FROM cms_menu WHERE id='".$id."'";
if($sql_delete=$conn->query($query_delete))
{
$sess_msg="Deleted Successfully.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
if(isset($_POST['delete_all']) && !empty($_POST['delete_all']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
foreach($_POST['check_status'] as $value)
{
$query_select= "SELECT * from cms_menu WHERE id ='".$value."'";
if($sql_select=$conn->query($query_select))
{
while($result=$sql_select->fetch_array(MYSQLI_ASSOC))
{
extract($result);
@unlink("uploads/video/".$result['video']);
@unlink("uploads/fvicon/".$result['fvicon']);
@unlink("uploads/up_image/".$result['up_image']);
@unlink("uploads/up_pdf/".$result['up_pdf']);
}
}
if($sql_deleteall=$conn->query("DELETE FROM cms_menu WHERE id = '".$value."'"))
{
$sess_msg="Deleted Successfully.";
}
}
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
if(isset($_POST['chk_btn']) && !empty($_POST['chk_btn']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
$str_rest_refs=implode(",",$_POST['check_status']);
$query_act="UPDATE cms_menu SET status = '1' WHERE id IN (".$str_rest_refs.")";
if($sql_act=$conn->prepare($query_act))
{
$sql_act->execute();
$sess_msg="Activated Successfully.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
if(isset($_POST['unchk_btn']) && !empty($_POST['unchk_btn']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
$str_rest_refs=implode(",",$_POST['check_status']);
$query_deact="UPDATE cms_menu SET status = '0' WHERE id IN (".$str_rest_refs.")";
if($sql_deact=$conn->prepare($query_deact))
{
$sql_deact->execute();
$sess_msg="Deactivated Successfully.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
if(isset($_POST['galleryathome']) && !empty($_POST['galleryathome']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
$str_rest_refs=implode(",",$_POST['check_status']);
$query_deact="UPDATE cms_menu SET category = 'home' WHERE id IN (".$str_rest_refs.")";
if($sql_deact=$conn->prepare($query_deact))
{
$sql_deact->execute();
$sess_msg="Deactivated Successfully.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
if(isset($_POST['regalleryathome']) && !empty($_POST['regalleryathome']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
$str_rest_refs=implode(",",$_POST['check_status']);
$query_deact="UPDATE cms_menu SET category = 'homeno' WHERE id IN (".$str_rest_refs.")";
if($sql_deact=$conn->prepare($query_deact))
{
$sql_deact->execute();
$sess_msg="Deactivated Successfully.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
/*
if(isset($_POST['']) && !empty($_POST['updateorder']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
$str_rest_refs=implode(",",$_POST['check_status']);
$query_act="UPDATE cms_menu SET updateorder = '".$_POST['updateorder']."' WHERE id IN (".$str_rest_refs.")";
if($sql_act=$conn->prepare($query_act))
{
$sql_act->execute();
$sess_msg="Activated Successfully.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
} */
if(isset($_POST['updateorder']) && !empty($_POST['updateorder']))
{
if(isset($_POST['check_status']) && count($_POST['check_status'])>0)
{
foreach($_POST['check_status'] as $value)
{
foreach($_POST['updateorder'] as $key => $value1)
{
if($key==$value) {
$query_act="UPDATE cms_menu SET updateorder = '".$value1."' WHERE id = '".$value."'";
if($sql_act=$conn->prepare($query_act))
{
$sql_act->execute();
$sess_msg="Updated Successfully.";
}
}
}
}
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
else
{
$sess_msg="Please select check box.";
echo "<script>document.location.href='view-menu.php?msg=".$sess_msg."';</script>";
exit();
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
<title>Admin</title>
<link rel="stylesheet" href="bower_components/bootstrap/dist/css/bootstrap.min.css">
<link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css">
<link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
<link rel="stylesheet" href="dist/css/AdminLTE.min.css">
<link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">
<link rel="stylesheet"
href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.2/sweetalert.css" />
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.2/sweetalert.min.css" />
</head>
<body class="hold-transition skin-blue sidebar-mini">
<div class="wrapper">
<?php include('header.php') ?>
<?php include('left-menu.php') ?>
<div class="content-wrapper">
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="main-title">
<?php if(isset($_REQUEST['msg'])) { ?> <h3 class="h5-headn hegt-96" style="color:red;"><?php echo $_REQUEST['msg']; ?></h3> <?php } else { ?>
<h3>All Menu</h3>
<?php } ?>
</div>
<form action="<?php $_SERVER['PHP_SELF'] ?>" method ="post">
<a href="cms.php" class="btn btn-addnew">Create New</a>
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<tr role="row">
<td colspan="8" style="text-align:right;" rowspan="1">
<input type="submit" name="galleryathome" value="At Home" onClick="return confirm('Are you sure? You want to At Home');" class="btn btn-success">
<input type="submit" name="regalleryathome" value="Remove from Home" onClick="return confirm('Are you sure? You want to Remove from Home');" class="btn btn-warning">
<input type="submit" name="delete_all" value="Delete / Block" class="btn btn-danger" style="margin-top:2px;" onClick="return confirm('Are you sure? You want to Delete');">
</td>
<td colspan="2" style="text-align:right;" rowspan="1">
<input type="submit" name="updateorder" value="Update Order" onClick="return confirm('Are you sure you want to update order?');" class="btn btn-warning">
<input type="submit" name="chk_btn" value="Active" onClick="return confirm('Are you sure you want to activate ?');" class="btn btn-success">
<input type="submit" name="unchk_btn" value="Deactivate" onClick="return confirm('Are you sure you want to deactivate ?');" class="btn btn-danger">
</td></tr>
<tr>
<th>Sr. N.</th>
<th>Page Name</th>
<th></th>
<th>Is Home?</th>
<th>Is Category</th>
<th>Page Type</th>
<th>Status</th>
<th>
<input type="checkbox" name="checkedAll" id="checkedAll" />
</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php $query="SELECT * FROM cms_menu ORDER BY id DESC";
$result=mysqli_query($conn,$query);
if(mysqli_num_rows($result)){
$i=1;
while($row=mysqli_fetch_array($result))
{
//print_r($row);
?>
<tr>
<td><?php //echo $row['id']; ?> <?php echo $i; ?></td>
<td><a href="#"><?php echo $row['page_name']; ?></a></td>
<td><a href="cms.php">Add Page</a></td>
<?php if($row['category']=='home') { ?>
<td>Yes</td>
<?php }else { ?>
<td colspan="1"> No</td>
<?php } ?>
<td><?php echo $row['page_category']; ?></td>
<td> <?php echo $row['page_type']; ?></td>
<td colspan="1"> <?php if($row['status']=='1'){ echo "Enable";}else { echo "Disable";} ?></td>
<td></td>
<td>
<input type="checkbox" value="<?php echo $row['id']; ?>" name="check_status[]" class="checkSingle" />
</td>
<td>
<ul class="edit-button">
<li><a href="cms.php?id=<?php echo $row['id'];?>"><i class="fa fa-edit"></i></a></li>
<li><a href="#" onclick="remove(<?php echo $row['id']; ?>)"><i class="fa fa-remove"></i></a></li>
</ul>
</td>
</tr>
<?php
$i++;
}
}
?>
</tbody>
</table>
</div>
<!-- /.box-body -->
</div>
</form>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<footer class="main-footer">
<strong>Copyright © <?php echo date("Y");?> <a href="#">Dashboard</a>.</strong> All rights
reserved.
</footer>
</div>
<!-- ./wrapper -->
<script src="bower_components/jquery/dist/jquery.min.js"></script>
<script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<script src="bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<script src="bower_components/fastclick/lib/fastclick.js"></script>
<script src="dist/js/adminlte.min.js"></script>
<!-- AdminLTE App -->
<script src="dist/js/app.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.2/sweetalert-dev.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.2/sweetalert-dev.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.2/sweetalert.min.js"></script>
<script>
$(function () {
$('#example1').DataTable()
$('#example2').DataTable({
'paging' : true,
'lengthChange': false,
'searching' : false,
'ordering' : true,
'info' : true,
'autoWidth' : false
})
})
</script>
<script>
$(document).ready(function() {
$("#checkedAll").change(function() {
if (this.checked) {
$(".checkSingle").each(function() {
this.checked=true;
});
} else {
$(".checkSingle").each(function() {
this.checked=false;
});
}
});
$(".checkSingle").click(function () {
if ($(this).is(":checked")) {
var isAllChecked = 0;
$(".checkSingle").each(function() {
if (!this.checked)
isAllChecked = 1;
});
if (isAllChecked == 0) {
$("#checkedAll").prop("checked", true);
}
}
else {
$("#checkedAll").prop("checked", false);
}
});
});
</script>
<script>
function remove(ids){
swal({ title: "Are you sure?",
text: "Want remove this menu",
type: "warning",
showCancelButton: true,
confirmButtonColor: "#DD6B55",
cancelButtonText: "No, cancel it!",
confirmButtonText: "Yes, remove it!",
showLoaderOnConfirm:true,
closeOnConfirm: false,
closeOnCancel: true },
function(isConfirm){
if (isConfirm) {
$.ajax({
url: "sandeepphp/actions.php",
data: {'id': ids ,'remove_menu':'action'} ,
type: "POST",
success: function (data) {
if(data=='OK'){
swal("Remove!", "Menu has been removed", "success");
location.reload();
}
else{
sweetAlert("Oops", data, "error");
}
},
error: function () {
sweetAlert("Oops...", data, "error");
}
});
}
});
}
</script>
<script>
$("#checkAllbox").change(function () {
$(".checkbox").prop('checked', $(this).prop("checked"));
});
</script>
</body>
</html>