1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / ashtokenrewards.com / manager /
Filename : all-tasks.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');

$title = "Tasks";

// Delete task
if (isset($_GET['del'])) {
    $id = intval($_GET['id']);
    $query = "DELETE FROM `tasks` WHERE `id` = ?";
    $stmt = $con->prepare($query);
    $stmt->bind_param("i", $id);

    if ($stmt->execute()) {
        $_SESSION['msg'] = "Task deleted successfully!";
    } else {
        $_SESSION['msg'] = "Error deleting task.";
    }
    echo "<script>window.location.href='all-tasks.php';</script>";
}

// Update task status
if (isset($_GET['make']) || isset($_GET['remove'])) {
    $id = intval($_GET['id']);
    $status = isset($_GET['make']) ? '1' : '0';
    $query = "UPDATE `tasks` SET `status` = ? WHERE `id` = ?";
    $stmt = $con->prepare($query);
    $stmt->bind_param("ii", $status, $id);

    if ($stmt->execute()) {
        $_SESSION['msg'] = $status == '1' ? "Task activated successfully!" : "Task deactivated successfully!";
    } else {
        $_SESSION['msg'] = "Error updating task status.";
    }
    echo "<script>window.location.href='all-tasks.php';</script>";
}
?>

<div class="container-fluid py-4">
    <div class="card" style="padding:30px;">
        <h5 class="card-header">All Tasks</h5>

        <?php if (isset($_SESSION['msg'])) { ?>
            <div class="alert alert-info">
                <?php echo htmlentities($_SESSION['msg']); unset($_SESSION['msg']); ?>
            </div>
        <?php } ?>

        <div class="table-responsive table-wrapper-top text-nowrap">
            <table class="table table-bordered" id="dataTables-example">
                <thead>
                    <tr class="text-nowrap">
                        <th>SN</th>
                        <th>Image</th>
                        <th>Title</th>
                        <th>Category</th>
                        <th>Description</th>
                        <th>Link</th>
                        <th>Status</th>
                        <th>Type</th>
                        <th>Reward</th>
                        <th>Action</th>
                    </tr>
                </thead>
                <tbody>
                <?php 
                $query = "SELECT * FROM `tasks` ORDER BY `id` DESC";
                $result = mysqli_query($con, $query);
                $cnt = 1;

                if (mysqli_num_rows($result) > 0) {
                    while ($row = mysqli_fetch_assoc($result)) { ?>
                        <tr>
                            <td><?php echo $cnt++; ?></td>
                            <td><img src="../admin/tasks/<?php echo htmlentities($row['image']); ?>" width="100" alt="Task Image"></td>
                            <td><?php echo htmlentities($row['title']); ?></td>
                            <td><?php echo htmlentities($row['category']); ?></td>
                            <td><?php echo htmlentities($row['description']); ?></td>
                            <td><a href="<?php echo htmlentities($row['task_link']); ?>" target="_blank">View</a></td>
                            <td class="align-middle">
                                <?php if ($row['status'] == '1') { ?>
                                    <span class="btn btn-success">Active</span>
                                <?php } else { ?>
                                    <span class="btn btn-warning">Inactive</span>
                                <?php } ?>
                            </td>
                            <td><?php echo htmlentities($row['type']); ?></td>
                            <td><?php echo htmlentities($row['reward']); ?></td>
                            <td class="align-middle">
                                <?php if ($row['status'] == '1') { ?>
                                    <a href="?id=<?php echo $row['id']; ?>&remove=1" 
                                       onClick="return confirm('Are you sure you want to deactivate this task?');" 
                                       class="btn btn-warning">Deactivate</a>
                                <?php } else { ?>
                                    <a href="?id=<?php echo $row['id']; ?>&make=1" 
                                       onClick="return confirm('Are you sure you want to activate this task?');" 
                                       class="btn btn-primary">Activate</a>
                                <?php } ?>
                                <a href="edit-task.php?id=<?php echo $row['id']; ?>" class="btn btn-primary">Edit</a>
                                <a href="?id=<?php echo $row['id']; ?>&del=1" 
                                   onClick="return confirm('Are you sure you want to delete this task?');" 
                                   class="btn btn-danger">Delete</a>
                            </td>
                        </tr>
                    <?php }
                } else { ?>
                    <tr>
                        <td colspan="10" class="text-center">No records found!</td>
                    </tr>
                <?php } ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<div style="margin-left:10vw; height:30vh;"></div>

<?php include('include/footer.php'); ?>