PTC Network - Comprehensive Member Data Report

Generated on: ${new Date().toLocaleString()}

\n \n

User Summary

\n \n \n \n \n \n \n \n \n \n \n \n \n \n ${usersData.rows.map(user => {\n const userAdViews = adViewsData.rows.find(av => av.user_id === user.id) || { total_views: 0, total_ad_earnings: 0 };\n const userReferrals = referralData.rows.find(ref => ref.referrer_id === user.id) || { total_referrals: 0, total_referral_earnings: 0 };\n const userWithdrawals = withdrawalData.rows.find(wd => wd.user_id === user.id) || { total_withdrawals: 0, total_withdrawal_amount: 0 };\n\n return `\n \n \n \n \n \n \n \n \n \n \n \n \n `;\n }).join('')}\n

User ID	Username	Total Balance	Account Created	Total Ad Views	Ad Earnings	Total Referrals	Referral Earnings	Total Withdrawals	Total Withdrawal Amount
${user.id}	${user.username}	$${user.balance.toFixed(2)}	${new Date(user.created_at).toLocaleDateString()}	${userAdViews.total_views}	$${userAdViews.total_ad_earnings.toFixed(2)}	${userReferrals.total_referrals}	$${userReferrals.total_referral_earnings.toFixed(2)}	${userWithdrawals.total_withdrawals}	$${userWithdrawals.total_withdrawal_amount.toFixed(2)}

\n `;\n\n // Send email with comprehensive report\n await email({\n to: \"syedalisherazofficial@gmail.com\",\n subject: `PTC Network - Member Data Report ${new Date().toLocaleDateString()}`,\n html: reportHTML,\n text: `PTC Network Member Data Report generated on ${new Date().toLocaleString()}`\n });\n\n return new Response(JSON.stringify({ \n success: true, \n message: \"Member data report sent successfully\" \n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n\n } catch (error) {\n console.error(\"Error sending member data:\", error);\n return new Response(JSON.stringify({ \n success: false, \n message: \"Failed to send member data\" \n }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n // Existing routes for ads, dashboard stats, etc.\n if (request.method === 'GET') {\n if (request.url.includes('/dashboard-stats')) {\n const userId = new URL(request.url).searchParams.get('userId');\n const stats = await sqlite.execute(`\n SELECT \n COUNT(DISTINCT ad_id) as totalAdViews,\n (SELECT COUNT(*) FROM ${KEY}_referrals_${SCHEMA_VERSION} WHERE referrer_id = ?) as totalReferrals\n FROM ${KEY}_ad_views_${SCHEMA_VERSION}\n WHERE user_id = ?\n `, [userId, userId]);\n\n return new Response(JSON.stringify(stats.rows[0]), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (request.url.includes('/withdrawal-history')) {\n const userId = new URL(request.url).searchParams.get('userId');\n const withdrawals = await sqlite.execute(`\n SELECT amount, created_at as date, status \n FROM ${KEY}_withdrawals_${SCHEMA_VERSION}\n WHERE user_id = ?\n ORDER BY created_at DESC\n LIMIT 10\n `, [userId]);\n\n return new Response(JSON.stringify(withdrawals.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n // Add more GET routes as needed\n }\n\n // Handle POST routes for other operations\n if (request.method === 'POST') {\n // Add other POST routes here\n }\n\n // Default HTML response for the main page\n return new Response(`\n \n \n PTC Network\n \n 💰\">\n \n \n

\n \n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" }\n });\n\n } catch (error) {\n // Catch-all error handler to ensure a Response is always returned\n console.error(\"Unhandled server error:\", error);\n return new Response(JSON.stringify({ \n success: false, \n message: \"An unexpected error occurred\" \n }), {\n status: 500,\n headers: { 'Content-Type': 'application/json' }\n });\n }\n}\n\n// Rest of the client-side code remains unchanged\nfunction Dashboard({ user }) {\n // Existing dashboard code...\n\n const handleDataExport = async () => {\n try {\n const response = await fetch('/send-member-data', { method: 'POST' });\n const result = await response.json();\n \n if (result.success) {\n alert(\"Member data report has been sent to the administrator.\");\n } else {\n alert(\"Failed to send member data. Please try again.\");\n }\n } catch (error) {\n console.error(\"Data export error:\", error);\n alert(\"An error occurred while exporting data.\");\n }\n };\n\n return (\n

\n {/* Existing dashboard content */}\n \n {/* Optional: Add an export button for admin or specific users */}\n {user.username === 'admin' && (\n

🔐 Admin Tools

\n \n

\n )}\n

\n );\n}\n\n// Styles remain the same\nconst styles = {\n // Existing styles...\n exportButton: {\n backgroundColor: '#e74c3c',\n color: 'white',\n padding: '10px 20px',\n border: 'none',\n borderRadius: '4px',\n cursor: 'pointer',\n fontWeight: 'bold'\n }\n};","deleted","label",[99],"permalink","https://www.val.town/x/Sherazjaffri/ptcWebsiteDemo/code/main.tsx","extension","actionData","errors"]