<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $requestData = json_decode(file_get_contents('php://input'), true);

    if (isset($requestData['projectId'])) {
        $projectId = $requestData['projectId'];

        // Connect to the database
        $db = new SQLite3('database/invoices.db');

        if (!$db) {
            die("Database connection failed: " . $db->lastErrorMsg());
        }

        // Prepare and execute the SQL DELETE query
        $deleteQuery = "DELETE FROM figures WHERE invoicefull = :invoicefull";
        $stmt = $db->prepare($deleteQuery);

        if (!$stmt) {
            die("Prepare failed: " . $db->lastErrorMsg());
        }

        $stmt->bindValue(':invoicefull', $projectId, SQLITE3_TEXT);

        $result = $stmt->execute();

        if (!$result) {
            die("Execute failed: " . $db->lastErrorMsg());
        }

        // Close the database connection and the prepared statement
        $stmt->close();
        $db->close();

        $response = ['success' => true];
        echo json_encode($response);
    } else {
        $response = ['success' => false];
        echo json_encode($response);
    }
}
?>