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/public_html/website_6031bb72/admin/manage_home/ |
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'] . "'"));
$mudule_access_tbl = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM mudule_access_tbl WHERE `module_id` ='1' AND `admin_id`='" . $login_tbl['admin_id'] . "'"));
include('../include/sidebar.php');
?>
<!-- [ 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">
<h5 class="m-b-10 btn btn-dark btn-sm btn-round has-ripple"><i class="feather icon-check-square"></i> Manage Opportunities</h5>
</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 Opportunities</h5>
<div>
<?php
if ($_SESSION['admin_id'] == 1 || $mudule_access_tbl['insert1'] == 1) { ?>
<a href="add_edit_oppo.php?page=opportunities" class="text-white btn btn-info btn-sm btn-round has-ripple"><i class="feather icon-plus"></i>Add</a>
<?php }
if ($_SESSION['admin_id'] == 1 || $mudule_access_tbl['delete1'] == 1) { ?>
<input class="btn btn-danger btn-sm btn-round has-ripple" type="submit" value="Delete" name='but_delete' onclick="return confirm('Are you sure to delete the record?');">
<?php }
if ($_SESSION['admin_id'] == 1 || $mudule_access_tbl['status1'] == 1) { ?>
<input class="btn btn-success btn-sm btn-round has-ripple" type="submit" value="Active" name='but_active'>
<input class="btn btn-secondary btn-sm btn-round has-ripple" type="submit" value="Deactive" name='but_deactive'>
<?php } ?>
</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>Deal Type</th>
<th>Title</th>
<th>Images/Video</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$query = mysqli_query($conn, "SELECT * FROM opportunities_tbl ORDER BY ID DESC");
$n = 1;
while ($fetch_row = mysqli_fetch_array($query)) {
$fetch_deal = mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `deal_type_tbl` WHERE id='".$fetch_row['dealtype1']."'"));
?>
<tr>
<td><input type='checkbox' name='delete[]' value='<?= $fetch_row['id']; ?>'></td>
<td><?= $n;
$n++; ?></td>
<td><?= wordwrap($fetch_deal['title'], 40, "<br>\n"); ?><br><?= wordwrap($fetch_deal['title_ar'], 40, "<br>\n"); ?></td>
<td><?= wordwrap($fetch_row['heading1'], 40, "<br>\n"); ?><br><?= wordwrap($fetch_row['heading1_ar'], 40, "<br>\n"); ?></td>
<td>
<?php
$fileExtension = pathinfo($fetch_row['image1'], PATHINFO_EXTENSION);
$videoExtensions = ['mp4', 'avi', 'mov', 'webm', 'mkv'];
if (in_array(strtolower($fileExtension), $videoExtensions)) {
echo '<video width="320" height="240" class="my-3" controls muted>
<source src="' . $base_url . 'images/Upload/opportunities/' . $fetch_row['image1'] . '" type="video/' . strtolower($fileExtension) . '">
Your browser does not support the video tag.
</video>';
} else {
echo '<img class="my-3" src="' . $base_url . 'images/Upload/opportunities/' . $fetch_row['image1'] . '" style="width:200px;">';
}
?>
</td>
<td>
<?php
if ($_SESSION['admin_id'] == 1 || $mudule_access_tbl['status1'] == 1) {
if (($fetch_row['status'] == '1')) {
echo '<a href="show.php?page=opportunities&&status_id=' . $fetch_row['id'] . '" class="btn btn-success btn-sm"><i class="feather icon-eye"></i></a>';
} else {
echo '<a href="show.php?page=opportunities&&status_id=' . $fetch_row['id'] . '" class="btn btn-danger btn-sm"><i class="feather icon-eye-off"></i></a>';
}
}
?>
<?php
if ($_SESSION['admin_id'] == 1 || $mudule_access_tbl['update1'] == 1) { ?>
<a href="add_edit_oppo.php?page=opportunities&&id=<?= $fetch_row['id'] ?>" class="btn btn-info btn-sm"><i class="feather icon-edit"></i></a>
<?php }
if ($_SESSION['admin_id'] == 1 || $mudule_access_tbl['delete1'] == 1) { ?>
<a href="show.php?page=opportunities&&delete_id=<?= $fetch_row['id'] ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure to delete the record?');"><i class="feather icon-trash-2"></i></a>
<?php }; ?>
</td>
</tr>
<?php }; ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</form>
<!-- col-md-12 end -->
</div>
<!-- [ Main Content ] end -->
</div>
</div>
<?php
if (!empty($_GET['status_id'])) {
$id = $_GET['status_id'];
$stsQry = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM `opportunities_tbl` WHERE id ='$id'"));
$menu_id = $stsQry['menu_id'];
if ($stsQry['status'] == 0) {
$updtQry = mysqli_query($conn, "UPDATE `opportunities_tbl` SET `status`='1' WHERE id='$id'") or die(mysqli_error($conn));
if ($updtQry) {
echo "<script>window.location='opportunities.php?page=opportunities;</script>";
$_SESSION['message'] = "Our News Activated Successfully";
}
} elseif ($stsQry['status'] == 1) {
$updtQry = mysqli_query($conn, "UPDATE `opportunities_tbl` SET `status`='0' WHERE id='$id'") or die(mysqli_error($conn));
if ($updtQry) {
echo "<script>window.location='opportunities.php?page=opportunities;</script>";
$_SESSION['error'] = "Our News Deactivated Successfully";
}
}
}
?>
<?php
if (!empty($_GET['delete_id'])) {
$id = $_GET['delete_id'];
$query = mysqli_query($conn, "SELECT * FROM opportunities_tbl WHERE id=" . $_GET['delete_id']);
$row = mysqli_fetch_array($query);
unlink("../../images/Upload/news/" . $row['image1']);
unlink("../../images/Upload/news/" . $row['image2']);
$dtQuery = mysqli_query($conn, "DELETE FROM `opportunities_tbl` WHERE id=" . $_GET['delete_id']);
echo "<script>window.location='opportunities.php?page=opportunities;</script>";
$_SESSION['delete'] = "Our News Deleted Successfully";
}
?>
<?php
if (isset($_POST['but_delete'])) {
if (isset($_POST['delete'])) {
foreach ($_POST['delete'] as $deleteid) {
$query = mysqli_fetch_array(mysqli_query($conn, "SELECT * FROM opportunities_tbl WHERE id=" . $deleteid));
unlink("../../images/Upload/news/" . $query['image1']);
unlink("../../images/Upload/news/" . $query['image2']);
$deleteUser = "DELETE from opportunities_tbl WHERE id=" . $deleteid;
mysqli_query($conn, $deleteUser);
}
echo "<script>window.location='opportunities.php?page=opportunities;</script>";
$_SESSION['delete'] = "All Our News Deleted Successfully";
}
}
?>
<?php
if (isset($_POST['but_active'])) {
if (isset($_POST['delete'])) {
foreach ($_POST['delete'] as $deleteid) {
$deleteUser = "UPDATE `opportunities_tbl` SET `status`='1' WHERE id=" . $deleteid;
mysqli_query($conn, $deleteUser);
echo "<script>window.location='opportunities.php?page=opportunities;</script>";
$_SESSION['message'] = "All Our News Activated Successfully";
}
}
}
?>
<?php
if (isset($_POST['but_deactive'])) {
if (isset($_POST['delete'])) {
foreach ($_POST['delete'] as $deleteid) {
$deleteUser = "UPDATE `opportunities_tbl` SET `status`='0' WHERE id=" . $deleteid;
mysqli_query($conn, $deleteUser);
}
echo "<script>window.location='opportunities.php?page=opportunities;</script>";
$_SESSION['error'] = "All Our News Deactivated Successfully";
}
}
?>
<?php include('../include/footer.php'); ?>