<?php
header('Content-Type: application/json');
require 'db_connection.php';

$user_id = isset($_POST['user_id']) ? $_POST['user_id'] : '';

$sql = "SELECT COUNT(*) as total_tasks, SUM(is_completed) as completed_tasks FROM tasks WHERE user_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $user_id);
$stmt->execute();
$result = $stmt->get_result();
$data = $result->fetch_assoc();

$in_progress = $data['total_tasks'] - $data['completed_tasks'];

echo json_encode(array("status" => "success", "in_process_count" => $in_progress));
?>