0) { $expiresAt = date('Y-m-d H:i:s', strtotime("+{$days} days")); } } try { $stmt = $pdo->prepare(" INSERT INTO licenses (license_key, customer_name, customer_email, customer_phone, tier, max_devices, expires_at, notes, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'ACTIVE') "); $stmt->execute([$finalKey, $name, $email, $phone, $tier, $maxDevices, $expiresAt, $notes]); $_SESSION['newly_created_key'] = [ 'key' => $finalKey, 'name' => $name, 'tier' => $tier, 'expires' => $expiresAt ? date('d M Y', strtotime($expiresAt)) : 'Lifetime Access', 'devices' => $maxDevices ]; header("Location: index.php?msg=key_created"); exit(); } catch (Exception $e) { $notification = ['type' => 'error', 'text' => 'Error creating key: ' . $e->getMessage()]; } } // B. SAVE CASHFREE & PRICING SETTINGS if ($postAction === 'save_settings') { $appId = trim($_POST['cashfree_app_id'] ?? ''); $secretKey = trim($_POST['cashfree_secret_key'] ?? ''); $env = trim($_POST['cashfree_env'] ?? 'sandbox'); $p30 = trim($_POST['plan_price_30'] ?? '199'); $p90 = trim($_POST['plan_price_90'] ?? '499'); $p365 = trim($_POST['plan_price_365'] ?? '999'); $pLife = trim($_POST['plan_price_lifetime'] ?? '1999'); $curr = trim($_POST['currency'] ?? 'INR'); $toSave = [ 'cashfree_app_id' => $appId, 'cashfree_secret_key' => $secretKey, 'cashfree_env' => $env, 'plan_price_30' => $p30, 'plan_price_90' => $p90, 'plan_price_365' => $p365, 'plan_price_lifetime' => $pLife, 'currency' => $curr ]; foreach ($toSave as $k => $v) { $del = $pdo->prepare("DELETE FROM settings WHERE setting_key = ?"); $del->execute([$k]); $ins = $pdo->prepare("INSERT INTO settings (setting_key, setting_value) VALUES (?, ?)"); $ins->execute([$k, $v]); } header("Location: index.php?tab=settings&msg=settings_saved"); exit(); } // C. TOGGLE STATUS (Suspend / Activate) if ($postAction === 'toggle_status') { $id = (int)$_POST['license_id']; $newStatus = $_POST['new_status'] === 'ACTIVE' ? 'ACTIVE' : 'SUSPENDED'; $stmt = $pdo->prepare("UPDATE licenses SET status = ? WHERE id = ?"); $stmt->execute([$newStatus, $id]); header("Location: index.php?msg=status_updated"); exit(); } // D. RESET DEVICE BINDINGS (Unbind all devices for a key) if ($postAction === 'reset_devices') { $id = (int)$_POST['license_id']; $stmt = $pdo->prepare("DELETE FROM activations WHERE license_id = ?"); $stmt->execute([$id]); header("Location: index.php?msg=devices_reset"); exit(); } // E. DELETE KEY if ($postAction === 'delete_key') { $id = (int)$_POST['license_id']; $stmt = $pdo->prepare("DELETE FROM licenses WHERE id = ?"); $stmt->execute([$id]); header("Location: index.php?msg=key_deleted"); exit(); } } // ------------------------------------------------------------- // 3. FETCH DASHBOARD METRICS, SETTINGS & ORDERS // ------------------------------------------------------------- if ($isLoggedIn) { // Current Active Tab $currentTab = $_GET['tab'] ?? 'licenses'; // Stats $totalKeys = (int)$pdo->query("SELECT COUNT(*) FROM licenses")->fetchColumn(); $activeKeys = (int)$pdo->query("SELECT COUNT(*) FROM licenses WHERE status = 'ACTIVE'")->fetchColumn(); $totalActivations = (int)$pdo->query("SELECT COUNT(*) FROM activations")->fetchColumn(); // Orders Stats $totalOrders = (int)$pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn(); $paidOrders = (int)$pdo->query("SELECT COUNT(*) FROM orders WHERE status = 'PAID'")->fetchColumn(); $totalRevenue = (float)$pdo->query("SELECT SUM(amount) FROM orders WHERE status = 'PAID'")->fetchColumn(); // Settings $settings = []; $stmtSettings = $pdo->query("SELECT setting_key, setting_value FROM settings"); while ($row = $stmtSettings->fetch()) { $settings[$row['setting_key']] = $row['setting_value']; } // Search & Filter for Licenses $search = trim($_GET['q'] ?? ''); $filterStatus = trim($_GET['status'] ?? 'ALL'); $query = " SELECT l.*, (SELECT COUNT(*) FROM activations a WHERE a.license_id = l.id) as bound_devices FROM licenses l WHERE 1=1 "; $params = []; if (!empty($search)) { $query .= " AND (l.license_key LIKE ? OR l.customer_name LIKE ? OR l.customer_email LIKE ?)"; $params[] = "%$search%"; $params[] = "%$search%"; $params[] = "%$search%"; } if ($filterStatus !== 'ALL') { $query .= " AND l.status = ?"; $params[] = $filterStatus; } $query .= " ORDER BY l.created_at DESC"; $stmt = $pdo->prepare($query); $stmt->execute($params); $licenses = $stmt->fetchAll(); // Fetch Orders $ordersStmt = $pdo->query("SELECT * FROM orders ORDER BY created_at DESC LIMIT 100"); $orders = $ordersStmt->fetchAll(); } ?> GymFuel Titan • License & Payment Command Center
⚡

GymFuel Command

Sign in to access License & Gateway portal

⚡
GymFuel Titan
Command Center
🛍️ Store Logout
🔑 Licenses () 💳 Cashfree Orders ( Paid) ⚙️ Gateway & Pricing
Total Licenses
Active Licenses
Bound Devices
Store Online Revenue
₹
Clear
Status License Key Athlete / Customer Tier Devices Expires Actions
No license keys found matching your criteria.
Active
/ Lifetime
WhatsApp
Total Online Orders
Successful Purchases
Total Revenue Collected
₹
Status Order ID Customer Info Plan Amount Generated Key Date
No online orders placed yet. Customers who buy via buy.php will appear here automatically!
PAID
•
₹
Not generated yet

⚙️ Cashfree Gateway & Pricing Configuration

Enter your Cashfree API keys to automatically accept payments and instantly issue license keys to users.

💰 Plan Pricing (in INR ₹)