Skip to content

Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.

2.5 KB
Raw Blame
<?php
require_once '../../includes/connect_endpoint.php';
require_once '../../includes/validate_endpoint.php';
require_once '../../includes/logo_cleanup.php';

$postData = file_get_contents("php://input");
$data = json_decode($postData, true);

$subscriptionId = $data["id"];

$logoStmt = $db->prepare("SELECT logo, logo_variant FROM subscriptions WHERE id = :subscriptionId AND user_id = :userId");
$logoStmt->bindParam(':subscriptionId', $subscriptionId, SQLITE3_INTEGER);
$logoStmt->bindParam(':userId', $userId, SQLITE3_INTEGER);
$logoResult = $logoStmt->execute();
$logoRow = $logoResult ? $logoResult->fetchArray(SQLITE3_ASSOC) : false;

$payersStmt = $db->prepare("DELETE FROM subscription_payers WHERE subscription_id IN (SELECT id FROM subscriptions WHERE id = :subscriptionId AND user_id = :userId)");
$payersStmt->bindParam(':subscriptionId', $subscriptionId, SQLITE3_INTEGER);
$payersStmt->bindParam(':userId', $userId, SQLITE3_INTEGER);
$payersStmt->execute();

$categoriesStmt = $db->prepare("DELETE FROM subscription_categories WHERE subscription_id IN (SELECT id FROM subscriptions WHERE id = :subscriptionId AND user_id = :userId)");
$categoriesStmt->bindParam(':subscriptionId', $subscriptionId, SQLITE3_INTEGER);
$categoriesStmt->bindParam(':userId', $userId, SQLITE3_INTEGER);
$categoriesStmt->execute();

$deleteQuery = "DELETE FROM subscriptions WHERE id = :subscriptionId AND user_id = :userId";
$deleteStmt = $db->prepare($deleteQuery);
$deleteStmt->bindParam(':subscriptionId', $subscriptionId, SQLITE3_INTEGER);
$deleteStmt->bindParam(':userId', $userId, SQLITE3_INTEGER);

if ($deleteStmt->execute()) {
    $query = "UPDATE subscriptions SET replacement_subscription_id = NULL WHERE replacement_subscription_id = :subscriptionId AND user_id = :userId";
    $stmt = $db->prepare($query);
    $stmt->bindParam(':subscriptionId', $subscriptionId, SQLITE3_INTEGER);
    $stmt->bindParam(':userId', $userId, SQLITE3_INTEGER);
    $stmt->execute();

    if ($logoRow !== false) {
        deleteLogoFileIfUnused($db, $logoRow['logo'], '../../images/uploads/logos/');
        deleteLogoFileIfUnused($db, $logoRow['logo_variant'], '../../images/uploads/logos/');
    }

    echo json_encode([
        "success" => true,
        "message" => translate('subscription_deleted', $i18n)
    ]);
} else {
    echo json_encode([
        "success" => false,
        "message" => translate('error_deleting_subscription', $i18n)
    ]);
}
$db->close();