prepare(" SELECT o.id, u.name, u.email, u.phone, o.total_amount, o.status, o.payment_method, o.created_at FROM orders o JOIN users u ON o.user_id = u.id WHERE o.created_at BETWEEN ? AND ? ORDER BY o.id DESC "); $stmt->execute([$start, $end]); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { fputcsv($output, $row); } } // 2. EXPORT CUSTOMERS if ($type == 'customers') { fputcsv($output, ['User ID', 'Name', 'Email', 'Phone', 'Wallet Balance', 'Joined Date']); $stmt = $pdo->query("SELECT id, name, email, phone, wallet_balance, created_at FROM users ORDER BY id DESC"); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { fputcsv($output, $row); } } // 3. EXPORT UNSOLD KEYS (BACKUP) if ($type == 'keys') { fputcsv($output, ['Key ID', 'Product Name', 'License Key', 'Status']); $stmt = $pdo->query(" SELECT k.id, p.name, k.license_key, k.status FROM license_keys k JOIN products p ON k.product_id = p.id WHERE k.status = 'available' "); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { fputcsv($output, $row); } } fclose($output); exit(); } ?> Reports & Export

Data Reports & Export

Download your business data for accounting and backup.

Sales Report

Customer List

Download email list of all registered users for marketing.

Inventory Backup

Download all Available license keys as a backup file.