1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / ashtokenrewards.com /
Filename : done-task.php
back
<?php
session_start();
//error_reporting(E_ALL);
//ini_set('display_errors', 1);

require_once '../config/aconn.php';
include 'includes/functions.php';
checkLogin();  // Ensure the user is logged in

// Check if task_id is provided via POST request
if (isset($_POST['task_id']) && is_numeric($_POST['task_id'])) {
    $taskId = (int) $_POST['task_id'];
    $uid = $_SESSION['id'];  // Get the logged-in user's ID

    // Check if task exists and is available for the user to complete
    $task_query = "SELECT * FROM `tasks` WHERE `id` = ? AND `status` = '1'";
    $stmt = mysqli_prepare($con, $task_query);
    mysqli_stmt_bind_param($stmt, "i", $taskId);
    mysqli_stmt_execute($stmt);
    $task_result = mysqli_stmt_get_result($stmt);

    if (mysqli_num_rows($task_result) > 0) {
        // Task exists and is available to complete
        $task = mysqli_fetch_assoc($task_result);

        // Check if the user has already started the task
        $user_task_query = "SELECT * FROM `user_tasks` WHERE `user_id` = ? AND `task_id` = ?";
        $stmt_user_task = mysqli_prepare($con, $user_task_query);
        mysqli_stmt_bind_param($stmt_user_task, "ii", $uid, $taskId);
        mysqli_stmt_execute($stmt_user_task);
        $user_task_result = mysqli_stmt_get_result($stmt_user_task);

        if (mysqli_num_rows($user_task_result) > 0) {
            // The user has started the task, so update the task status
            $update_user_task_query = "UPDATE `user_tasks` SET `status` = '1', `done_time` = NOW() WHERE `user_id` = ? AND `task_id` = ?";
            
            $stmt_update = mysqli_prepare($con, $update_user_task_query);
            mysqli_stmt_bind_param($stmt_update, "ii", $uid, $taskId);

            if (mysqli_stmt_execute($stmt_update)) {
                echo json_encode([
                    'status' => 'success',
                    'message' => 'Task marked as completed successfully.'
                ]);  // Task status updated successfully
            } else {
                echo json_encode([
                    'status' => 'error',
                    'message' => 'Failed to update task status.'
                ]);  // Failed to update task status
            }

            // Close the update statement
            mysqli_stmt_close($stmt_update);
        } else {
            // User has not started the task yet, so we can't mark it as done
            echo json_encode([
                'status' => 'error',
                'message' => 'You must start the task before marking it as done.'
            ]);
        }
    } else {
        // Task not found or not available to complete
        echo json_encode([
            'status' => 'error',
            'message' => 'Task not found or not available to complete.'
        ]);
    }

    // Close the prepared statements
    mysqli_stmt_close($stmt);
    mysqli_stmt_close($stmt_user_task);

} else {
    // Invalid task ID or missing task ID
    echo json_encode([
        'status' => 'error',
        'message' => 'Invalid or missing task ID.'
    ]);
}
?>