beginTransaction(); if ($action === 'approve') { // Admin verifies -> move to held_in_escrow $stmt = $pdo->prepare("UPDATE purchases SET status = 'paid', escrow_status = 'held_in_escrow' WHERE id = ?"); $stmt->execute([$purchase_id]); // Get car ID and mark as sold $stmt = $pdo->prepare("SELECT car_id FROM purchases WHERE id = ?"); $stmt->execute([$purchase_id]); $car_id = $stmt->fetchColumn(); $carRepo->markAsSold($car_id); $message = "Transaction verified. Funds are now held in Escrow."; } elseif ($action === 'release') { // Admin releases payment to seller $stmt = $pdo->prepare("UPDATE purchases SET status = 'completed', escrow_status = 'released' WHERE id = ?"); $stmt->execute([$purchase_id]); $message = "Payment released to seller. Transaction completed."; } elseif ($action === 'reject') { $stmt = $pdo->prepare("UPDATE purchases SET status = 'failed', escrow_status = 'cancelled' WHERE id = ?"); $stmt->execute([$purchase_id]); $message = "Transaction rejected and cancelled."; } $pdo->commit(); } catch (Exception $e) { $pdo->rollBack(); $message = "Error: " . $e->getMessage(); } } // Fetch all purchases with car and user info $stmt = $pdo->query(" SELECT p.*, c.brand, c.model, c.year, u.name as buyer_user_name, ci.image_path FROM purchases p JOIN cars c ON p.car_id = c.id JOIN users u ON p.user_id = u.id LEFT JOIN car_images ci ON c.id = ci.car_id AND ci.is_main = 1 ORDER BY p.created_at DESC "); $purchases = $stmt->fetchAll(); ?> Enterprise Transactions | Admin

ENTERPRISE MODE

Transaction Engine

Manage Escrow, verify SHA256 tokens, and release payments for secure car marketplace sales.

✓

Transaction Ref	Vehicle	Escrow Status	Cost Breakdown	Verification	Action
		Status:	Base: $ Fee: $ Total: $	Bank ID: Token: ...	COMPLETED