<?php
$action_data = array(
    "complex_drop" => array("points" => 2.49, "cost" => 87.07),
    "normal_move" => array("points" => 1.34, "cost" => 47.10),
    "extra_install" => array("points" => 0.29, "cost" => 10.19),
    "street_intervention" => array("points" => 0.29, "cost" => 10.19),
    "normal_install" => array("points" => 1.35, "cost" => 47.10),
    "repair" => array("points" => 1.09, "cost" => 38.22),
    "repair_lvl2" => array("points" => 1.23, "cost" => 43.22),
    "simple_drop" => array("points" => 1.69, "cost" => 59.22),
    "simple_install" => array("points" => 0.95, "cost" => 33.50),
    "simple_move" => array("points" => 0.95, "cost" => 33.50)
);

function updatePointsAndMoney($conn, $userId, $pointsToAdd, $costToAdd, $actionName) {
    $sql_update = "UPDATE users SET points = points + $pointsToAdd, money = money + $costToAdd WHERE id = $userId";
    if ($conn->query($sql_update) === TRUE) {
        $today = date("Y-m-d");
        $sql_insert = "INSERT INTO user_points (user_id, points, cost, action_name, date) VALUES ($userId, $pointsToAdd, $costToAdd, '$actionName', '$today')";
        if ($conn->query($sql_insert) === TRUE) {
            echo "Punten met succes toegevoegd!";
        } else {
            echo "Error updating points and cost: " . $conn->error;
        }
    } else {
        echo "Error updating points and cost: " . $conn->error;
    }
}

if (isset($_POST["action"])) {
    $action = $_POST["action"];
    if (array_key_exists($action, $action_data)) {
        $pointsToAdd = $action_data[$action]["points"];
        $costToAdd = $action_data[$action]["cost"];
        $actionName = ucfirst(str_replace("_", " ", $action));
        updatePointsAndMoney($conn, $_SESSION["user_id"], $pointsToAdd, $costToAdd, $actionName);
    } else {
        echo "Invalid action.";
    }
}

function getTodayPoints($conn, $userId) {
    $today = date("Y-m-d");
    $sql = "SELECT SUM(points) AS total_points FROM user_points WHERE user_id = $userId AND date = '$today'";
    $result = $conn->query($sql);
    $row = $result->fetch_assoc();
    return $row["total_points"];
}
?>