Admin Login

`); }); router.post('/login', async (req, res) => { const { username, password } = req.body; try { const [users] = await pool.query( 'SELECT * FROM admin_users WHERE username = ?', [username] ); if (users.length === 0) { return res.redirect('/admin/login?error=1'); } const user = users[0]; const match = await bcrypt.compare(password, user.password_hash); if (!match) { return res.redirect('/admin/login?error=1'); } req.session.adminLoggedIn = true; req.session.adminUsername = username; await pool.query( 'UPDATE admin_users SET last_login = NOW() WHERE id = ?', [user.id] ); res.redirect('/admin/dashboard'); } catch (error) { console.error('Login error:', error); res.redirect('/admin/login?error=1'); } }); router.get('/logout', (req, res) => { req.session.destroy(); res.redirect('/admin/login'); }); router.get('/dashboard', requireAuth, async (req, res) => { try { const [stats] = await pool.query(` SELECT COUNT(*) as total_purchases, SUM(CASE WHEN status = 'PENDING' THEN 1 ELSE 0 END) as pending, SUM(CASE WHEN status = 'DELIVERED' THEN 1 ELSE 0 END) as delivered, SUM(CASE WHEN status = 'FAILED' THEN 1 ELSE 0 END) as failed, SUM(price) as total_revenue FROM purchases `); const [recentPurchases] = await pool.query( 'SELECT * FROM purchases ORDER BY payment_date DESC LIMIT 10' ); const [packages] = await pool.query( 'SELECT * FROM packages ORDER BY display_order ASC' ); res.send(generateDashboardHTML(stats[0], recentPurchases, packages)); } catch (error) { console.error('Dashboard error:', error); res.status(500).send('Error loading dashboard'); } }); function generateDashboardHTML(stats, purchases, packages) { return ` Admin Dashboard - ${config.site.name}

Total Purchases

${stats.total_purchases || 0}

Pending

${stats.pending || 0}

Delivered

${stats.delivered || 0}

Failed

${stats.failed || 0}

Total Revenue

$${(stats.total_revenue || 0).toFixed(2)}

Recent Purchases

${purchases.map(p => ` `).join('')}

ID	Player	Package	Price	Status	Date
${p.id}	${p.player_name}	${p.package_name}	$${p.price}	${p.status}	${new Date(p.payment_date).toLocaleString()}

Packages

${packages.map(p => ` `).join('')}

ID	Name	Price	Type	Enabled
${p.id}	${p.name}	$${p.price}	${p.delivery_type}	${p.enabled ? '✓' : '✗'}

`; } module.exports = router;