exec("SET NAMES 'utf8mb4'"); } catch (Exception $e) {} require_login(); $userId = (int)$_SESSION['user_id']; // --- LOGIK FÜR AKTIONEN (SWAP, RENAME, DELETE) --- if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) { $action = $_POST['action']; if ($action === 'swap_goals') { $fromId = (int)$_POST['from_goal']; $target = $_POST['to_goal']; $amount = (float)str_replace(',', '.', $_POST['amount']); if ($amount > 0) { $pdo->beginTransaction(); try { $stmtSource = $pdo->prepare("SELECT goal_name, current_amount FROM user_savings_goals WHERE id = ? AND user_id = ?"); $stmtSource->execute([$fromId, $userId]); $sourceGoal = $stmtSource->fetch(); if ($sourceGoal && (float)$sourceGoal['current_amount'] >= $amount) { $fromName = $sourceGoal['goal_name']; $pdo->prepare("UPDATE user_savings_goals SET current_amount = current_amount - ? WHERE id = ?")->execute([$amount, $fromId]); if ($target === 'wallet') { $pdo->prepare("UPDATE wallets SET balance = balance + ? WHERE user_id = ?")->execute([$amount, $userId]); $desc = "Auszahlung: $fromName ➔ Wallet"; } else { $toId = (int)$target; if ($fromId !== $toId) { $stmtTo = $pdo->prepare("SELECT goal_name FROM user_savings_goals WHERE id = ? AND user_id = ?"); $stmtTo->execute([$toId, $userId]); $toName = $stmtTo->fetchColumn(); $pdo->prepare("UPDATE user_savings_goals SET current_amount = current_amount + ? WHERE id = ?")->execute([$amount, $toId]); $desc = "Swap: $fromName ➔ $toName"; } else { throw new Exception("Source and target are the same."); } } $pdo->prepare("INSERT INTO wallet_transactions (user_id, amount, type, description, created_at) VALUES (?, ?, 'swap', ?, NOW())")->execute([$userId, $amount, $desc]); $pdo->commit(); header("Location: dashboard.php?success=1"); exit; } else { $pdo->rollBack(); } } catch (Exception $e) { $pdo->rollBack(); } } } if ($action === 'rename_goal') { $goalId = (int)$_POST['goal_id']; $newName = htmlspecialchars(trim($_POST['new_name'])); if (!empty($newName)) { $pdo->prepare("UPDATE user_savings_goals SET goal_name = ? WHERE id = ? AND user_id = ?")->execute([newName, $goalId, $userId]); header("Location: dashboard.php?success=rename"); exit; } } if ($action === 'delete_goal') { $goalId = (int)$_POST['goal_id']; $pdo->beginTransaction(); try { $stmt = $pdo->prepare("SELECT current_amount, goal_name FROM user_savings_goals WHERE id = ? AND user_id = ? FOR UPDATE"); $stmt->execute([$goalId, $userId]); $goal = $stmt->fetch(); if ($goal) { $amount = (float)$goal['current_amount']; if ($amount > 0) { $pdo->prepare("UPDATE wallets SET balance = balance + ? WHERE user_id = ?")->execute([$amount, $userId]); $pdo->prepare("INSERT INTO wallet_transactions (user_id, amount, type, description, created_at) VALUES (?, ?, 'refund', ?, NOW())")->execute([$userId, $amount, "Goal Deleted: " . $goal['goal_name']]); } $pdo->prepare("DELETE FROM user_savings_goals WHERE id = ?")->execute([$goalId]); $pdo->commit(); header("Location: dashboard.php?success=deleted"); exit; } } catch (Exception $e) { $pdo->rollBack(); } } } // --- DATENABFRAGEN --- $stmtUser = $pdo->prepare("SELECT first_name, last_name, email FROM users WHERE id = ?"); $stmtUser->execute([$userId]); $userData = $stmtUser->fetch(PDO::FETCH_ASSOC); $cardHolderName = !empty($userData['first_name']) ? strtoupper($userData['first_name'] . " " . ($userData['last_name'] ?? '')) : strtoupper(explode('@', $userData['email'])[0]); $pdo->prepare("INSERT IGNORE INTO wallets (user_id, balance) VALUES (?, 0)")->execute([$userId]); $stmtW = $pdo->prepare("SELECT balance FROM wallets WHERE user_id = ?"); $stmtW->execute([$userId]); $walletBalance = (float)$stmtW->fetchColumn(); $stmtOffers = $pdo->prepare("SELECT uc.id, uc.amount, u.email FROM user_credits uc JOIN users u ON u.id = uc.from_user WHERE uc.to_user = ? AND uc.status = 'pending' ORDER BY uc.created_at DESC"); $stmtOffers->execute([$userId]); $incomingOffers = $stmtOffers->fetchAll(PDO::FETCH_ASSOC); $stmtReceived = $pdo->prepare("SELECT uc.*, u.email, 'credit' as entry_type FROM user_credits uc JOIN users u ON u.id = uc.from_user WHERE uc.to_user = ? AND uc.status IN ('accepted', 'active', 'paid', 'repaid', 'completed', 'open', 'aktiv') ORDER BY uc.created_at DESC"); $stmtReceived->execute([$userId]); $receivedCredits = $stmtReceived->fetchAll(PDO::FETCH_ASSOC); $stmtGiven = $pdo->prepare("SELECT uc.*, u.email AS to_email, 'credit' as entry_type FROM user_credits uc JOIN users u ON u.id = uc.to_user WHERE uc.from_user = ? AND uc.status IN ('accepted', 'active', 'paid', 'repaid', 'completed', 'open', 'aktiv') ORDER BY uc.created_at DESC"); $stmtGiven->execute([$userId]); $givenCredits = $stmtGiven->fetchAll(PDO::FETCH_ASSOC); $stmtSwaps = $pdo->prepare("SELECT id, amount, description as email, created_at, 'swap' as entry_type, 'completed' as status FROM wallet_transactions WHERE user_id = ? AND type = 'swap' ORDER BY created_at DESC"); $stmtSwaps->execute([$userId]); $swapHistory = $stmtSwaps->fetchAll(PDO::FETCH_ASSOC); $stmtGoals = $pdo->prepare("SELECT * FROM user_savings_goals WHERE user_id = ? AND status = 'active' ORDER BY created_at DESC"); $stmtGoals->execute([$userId]); $savingsGoals = $stmtGoals->fetchAll(PDO::FETCH_ASSOC); function getStatusUI($status) { $s = strtolower(trim($status)); switch($s) { case 'paid': case 'repaid': case 'completed': case 'bezahlt': case 'swap': return ['#10b981', __('status_paid'), 'check-circle']; case 'accepted': case 'active': case 'aktiv': case 'open': return ['#3b82f6', __('status_active'), 'activity']; default: return ['#64748b', ucfirst($s), 'info']; } } ?> <?= __('nav_dashboard') ?> – Pendlify
WALLET BALANCE
€
PENDLIFY

Quick Actions

Senden Scannen
Mein Code
Aufladen

Sparziele

0) ? min(100, round(($goal['current_amount'] / $goal['target_amount']) * 100)) : 0; ?>
€

Aktivität

€