Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.
<?php
require_once '../../includes/connect_endpoint.php';
require_once '../../includes/validate_endpoint.php';
$input = file_get_contents('php://input');
$data = json_decode($input, true);
$paymentMethodId = $data["id"];
$checkStmt = $db->prepare('SELECT COUNT(*) as count FROM subscriptions WHERE payment_method_id = :paymentMethodId and user_id = :userId');
$checkStmt->bindParam(':paymentMethodId', $paymentMethodId, SQLITE3_INTEGER);
$checkStmt->bindParam(':userId', $userId, SQLITE3_INTEGER);
$checkResult = $checkStmt->execute();
$row = $checkResult->fetchArray();
$inUse = $row['count'] > 0;
if ($inUse) {
header('Content-Type: application/json');
echo json_encode(array("success" => false, "message" => translate('payment_in_use', $i18n)));
$db->close();
exit;
}
$deleteQuery = "DELETE FROM payment_methods WHERE id = :paymentMethodId and user_id = :userId";
$deleteStmt = $db->prepare($deleteQuery);
$deleteStmt->bindParam(':paymentMethodId', $paymentMethodId, SQLITE3_INTEGER);
$deleteStmt->bindParam(':userId', $userId, SQLITE3_INTEGER);
if ($deleteStmt->execute()) {
$success['success'] = true;
$success['message'] = translate('payment_method_removed', $i18n);
$json = json_encode($success);
header('Content-Type: application/json');
echo $json;
} else {
http_response_code(500);
echo json_encode(array("message" => translate('error', $i18n)));
}
$db->close();
?>