|
Server : LiteSpeed System : Linux terra.hostitbro.com 5.14.0-611.54.3.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Thu May 7 16:31:24 EDT 2026 x86_64 User : outerorb ( 1091) PHP Version : 8.1.34 Disable Function : mail Directory : /home2/outerorb/dev.outerorbittech.com/oot/admin/ | |
|
Path: /home2/outerorb/dev.outerorbittech.com/oot/admin/manage-banners.php
Size: 13.69 KB
Permissions: 0644
<?php
include_once("../include/main.inc.php");
check_session('MyCpanel', 'index.php');
################ Paging Starts From Here ##################
@extract($_REQUEST);
$start = (intval($start) == 0 or $start == "") ? $start = 0 : $start;
$pagesize = intval($pagesize) == 0 ? $pagesize = 100 : $pagesize;
if ($parentID == "") {
$parentID = 0;
}
$heading = "Manage Banners";
$record_type = "Banners";
$script_name = "manage-banners.php";
$table_name = "banner_tbl";
#################### DELETE Record ##################
if ($action == "delete_record") {
print_r($_POST['cat_arr']);
$categoryRes = getResult($table_name, " where slno='$slno'");
$filename = $categoryRes['bannerImage'];
if ($filename != "") {
$file = SITE_DIR_PATH . "/uploaded-files/banner-image/" . $filename;
if (file_exists($file)) {
unlink($file);
}
$file_thumb = SITE_DIR_PATH . "/uploaded-files/banner-image/" . $filename;
if (file_exists($file_thumb)) {
unlink($file_thumb);
}
}
mysqli_query($dbconn, "delete from $table_name where slno='$slno'");
$_SESSION['session_message'] = $record_type . ' has been deleted successfully';
header("Location: " . SITE_ADMIN_URL . "/" . $script_name . "?start=" . $start . "&parentID=" . $parentID . "&catID=" . $catID . "&pagesize=" . $pagesize);
exit;
}
####################################################
if (isset($_POST['active'])) {
if (!empty($_POST['cat_arr'])) {
$catid = $_POST['cat_arr'];
foreach ($catid as $id) {
mysqli_query($dbconn, "UPDATE $table_name SET status = 'Y' WHERE slno = '$id'");
}
$_SESSION['session_message'] = '<div class="btn btn-success">' . $record_type . ' has been updated successfully</div>';
} else {
$_SESSION['session_message'] = '<div class="btn btn-danger">No Category selected</div>';
}
header("Location: " . SITE_ADMIN_URL . "/" . $script_name);
exit;
}
if (isset($_POST['inactive'])) {
if (!empty($_POST['cat_arr'])) {
$catid = $_POST['cat_arr'];
foreach ($catid as $id) {
mysqli_query($dbconn, "UPDATE $table_name SET status = 'N' WHERE slno = '$id'");
}
$_SESSION['session_message'] = '<div class="btn btn-success">' . $record_type . ' has been updated successfully</div>';
} else {
$_SESSION['session_message'] = '<div class="btn btn-danger">No Category selected</div>';
}
header("Location: " . SITE_ADMIN_URL . "/" . $script_name);
exit;
}
if (isset($_POST['delete'])) {
if (!empty($_POST['cat_arr'])) {
$catid = $_POST['cat_arr'];
foreach ($catid as $id) {
mysqli_query($dbconn, "DELETE FROM $table_name WHERE slno = '$id'");
}
// $_SESSION['session_message'] = '<div class="btn btn-success">' . $record_type . ' has been deleted successfully</div>';
} else {
$_SESSION['session_message'] = '<div class="btn btn-danger">No Category selected</div>';
}
header("Location: " . SITE_ADMIN_URL . "/" . $script_name);
exit;
}
if($action=="Update") {
$input = $_POST;
$part = array_splice($input, 0, 2);
foreach ($input as $key => $val) {
if (substr($key,0,6)=="order_") {
$key1 = substr($key,6,strlen($key)-6);
$qry1=db_query("update $table_name set bannerorder='$val' where slno='$key1'");
}
}
//$_SESSION['session_message']='<div class="btn btn-success">' . $record_type . ' has been updated successfully </div>';
header("Location: ".SITE_ADMIN_URL."/".$script_name."?start=".$start."&parentID=".$parentID."&catID=".$catID."&pagesize=".$pagesize);
exit;
}
########################################################
admin_header("Manage $record_type");
$qry = db_query("select * from $table_name");
?>
<div class="content-wrapper">
<div class="page-header">
<h3 class="page-title">
<?= $heading; ?>
</h3>
<nav aria-label="breadcrumb">
<a class="nav-link" href="<?= SITE_ADMIN_URL . '/addeditbanner.php' ?>">
<span class="btn btn-primary">+ Add New Banner</span>
</a>
</nav>
</div>
<div class="card">
<div class="card-body">
<div class="row">
<div class="col-12">
<form action="" method="post">
<div class="table-responsive">
<table id="order-listing" class="table table-bordered table-hover">
<thead>
<tr>
<th class="_reab">
<div class="form-check mt-0">
<label class="form-check-label">
<input type="checkbox" class="form-check-input">
<i class="input-helper"></i>
</label>
</div>
</th>
<th>S.No.</th>
<th>Banner Title</th>
<th>Banner Image</th>
<th>Order</th>
<th>Status</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
$sl = $start + 1;
while ($arr = mysqli_fetch_array($qry)) { ?>
<tr>
<td>
<div class="form-check mt-0"><label class="form-check-label"><input
type="checkbox" class="form-check-input" name="cat_arr[]"
value="<?= $arr['slno'] ?>"><i class="input-helper"></i></label>
</div>
</td>
<td>
<?= $sl ?>
</td>
<td>
<p class="ordern">
<?= $arr['personName']; ?>
</p>
</td>
<td>
<p class="dongle-dcs">
<?php
if ($arr['bannerImage'] != "") {
$file1 = SITE_DIR_PATH . "/uploaded-files/banner-image/" . $arr['bannerImage'];
$dimens = GetImageSize($file1);
if ($dimens[0] > 130) {
$dimens[0] = $dimens[0] + 30;
$dimens[1] = $dimens[1] + 80;
} else {
$dimens[0] = 200;
$dimens[1] = 200;
}
?>
<a href="javascript:void(0);"
onClick="openwin('<?= SITE_ADMIN_URL; ?>/popup_new.php?img=banner-image/<?= $arr['bannerImage']; ?>', '<?= $dimens[0]; ?>', '<?= $dimens[1]; ?>')"><span>View
Image <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16"
fill="currentColor" class="bi bi-eye-slash" viewBox="0 0 16 16">
<path
d="M13.359 11.238C15.06 9.72 16 8 16 8s-3-5.5-8-5.5a7.028 7.028 0 0 0-2.79.588l.77.771A5.944 5.944 0 0 1 8 3.5c2.12 0 3.879 1.168 5.168 2.457A13.134 13.134 0 0 1 14.828 8c-.058.087-.122.183-.195.288-.335.48-.83 1.12-1.465 1.755-.165.165-.337.328-.517.486l.708.709z" />
<path
d="M11.297 9.176a3.5 3.5 0 0 0-4.474-4.474l.823.823a2.5 2.5 0 0 1 2.829 2.829l.822.822zm-2.943 1.299.822.822a3.5 3.5 0 0 1-4.474-4.474l.823.823a2.5 2.5 0 0 0 2.829 2.829z" />
<path
d="M3.35 5.47c-.18.16-.353.322-.518.487A13.134 13.134 0 0 0 1.172 8l.195.288c.335.48.83 1.12 1.465 1.755C4.121 11.332 5.881 12.5 8 12.5c.716 0 1.39-.133 2.02-.36l.77.772A7.029 7.029 0 0 1 8 13.5C3 13.5 0 8 0 8s.939-1.721 2.641-3.238l.708.709zm10.296 8.884-12-12 .708-.708 12 12-.708.708z" />
</svg> </span></a>
</p>
<?php } ?>
</td>
<td>
<p class="rec-date-dcs">
<input name="order_<?=$arr['slno'];?>" class="form-control order" type="text" size="2" value="<?=$arr['bannerorder'];?>">
</p>
</td>
<td>
<?php if ($arr['status'] == 'Y') { ?><label
class="badge badge-success badge-pill">Active</label>
<?php } else if ($arr['status'] == 'N') { ?> <label class="badge badge-danger badge-pill">In-Active</label>
<?php } ?>
</td>
<td>
<p class="download-dcs">
<a href="<?= SITE_ADMIN_URL ?>/addeditbanner.php?slno=<?= $arr['slno']; ?>"><svg
xmlns="http://www.w3.org/2000/svg" width="24" height="24"
viewBox="0 0 24 24" fill="none" stroke="currentColor"
stroke-width="2" stroke-linecap="round" stroke-linejoin="round"
class="feather feather-edit-3">
<path d="M12 20h9"></path>
<path d="M16.5 3.5a2.121 2.121 0 0 1 3 3L7 19l-4 1 1-4L16.5 3.5z">
</path>
</svg></a>
</p>
</td>
</tr>
<?php $sl++;
} ?>
</tbody>
</table>
<div class="btn-grp">
<button type="submit" name="active" onclick="return select_chk()"
class="btn btn-success btn-icon-text btn-sm">
<i class="fas fa-toggle-on mr-1"></i>Activate
</button>
<button type="submit" name="inactive" onclick="return select_chk()"
class="btn btn-warning btn-icon-text btn-sm">
<i class="far fa-times-circle mr-1"></i>Deactivate
</button>
<button type="submit" name="delete" onclick="return select_chk()"
class="btn btn-danger btn-icon-text btn-sm">
<i class="fas fa-trash-alt mr-1"></i>Delete
</button>
<button type="submit" name="action" value="Update" class="btn btn-default btn-icon-text btn-sm">
<i class="far fa-check-square mr-1"></i>Update Order
</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<script language="javascript">
function select_chk() {
var chks = document.getElementsByName('cat_arr[]');
var hasChecked = false;
for (var i = 0; i < chks.length; i++) {
if (chks[i].checked) {
hasChecked = true;
break;
}
}
if (hasChecked == false) {
alert("Please Select At Least One.");
return false;
}
}
</script>
<?php
admin_footer();
exit;
?>