Toll Management and Payment System

\n \n

\n \n } />\n } />\n } />\n } />\n } />\n \n

\n \n

\n \n );\n}\n\n// Home component\nfunction Home({ user }) {\n if (!user) {\n return

Welcome! Please login or register to use the system.

;\n }\n\n switch (user.role) {\n case 'driver':\n return ;\n case 'operator':\n return ;\n case 'admin':\n return ;\n default:\n return

Invalid user role

;\n }\n}\n\n// Login component\nfunction Login({ setUser }) {\n const [email, setEmail] = useState('');\n const [password, setPassword] = useState('');\n const navigate = useNavigate();\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n const response = await fetch('/api/login', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ email, password }),\n });\n if (response.ok) {\n const { token } = await response.json();\n localStorage.setItem('token', token);\n const decodedToken = jwtDecode(token);\n setUser(decodedToken);\n navigate('/');\n } else {\n alert('Login failed');\n }\n };\n\n return (\n \n );\n}\n\n// Register component\nfunction Register() {\n const [email, setEmail] = useState('');\n const [password, setPassword] = useState('');\n const [role, setRole] = useState('driver');\n const navigate = useNavigate();\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n const response = await fetch('/api/register', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({ email, password, role }),\n });\n if (response.ok) {\n alert('Registration successful. Please login.');\n navigate('/login');\n } else {\n alert('Registration failed');\n }\n };\n\n return (\n \n );\n}\n\n// Profile component\nfunction Profile({ user }) {\n const [name, setName] = useState(user.name || '');\n const [phone, setPhone] = useState(user.phone || '');\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n const response = await fetch('/api/profile', {\n method: 'PUT',\n headers: { \n 'Content-Type': 'application/json',\n 'Authorization': `Bearer ${localStorage.getItem('token')}`\n },\n body: JSON.stringify({ name, phone }),\n });\n if (response.ok) {\n alert('Profile updated successfully');\n } else {\n alert('Profile update failed');\n }\n };\n\n return (\n \n );\n}\n\n// Logout component\nfunction Logout({ setUser }) {\n const navigate = useNavigate();\n\n useEffect(() => {\n localStorage.removeItem('token');\n setUser(null);\n navigate('/');\n }, []);\n\n return

Logging out...

;\n}\n\n// Driver Dashboard component\nfunction DriverDashboard({ user }) {\n const [vehicles, setVehicles] = useState([]);\n const [transactions, setTransactions] = useState([]);\n\n useEffect(() => {\n fetchVehicles();\n fetchTransactions();\n }, []);\n\n const fetchVehicles = async () => {\n const response = await fetch('/api/vehicles', {\n headers: { 'Authorization': `Bearer ${localStorage.getItem('token')}` },\n });\n if (response.ok) {\n const data = await response.json();\n setVehicles(data);\n }\n };\n\n const fetchTransactions = async () => {\n const response = await fetch('/api/transactions', {\n headers: { 'Authorization': `Bearer ${localStorage.getItem('token')}` },\n });\n if (response.ok) {\n const data = await response.json();\n setTransactions(data);\n }\n };\n\n return (\n

Driver Dashboard

Your Vehicles

{vehicle.make} {vehicle.model} ({vehicle.year})

Recent Transactions

\n {transaction.date}: {transaction.amount} ({transaction.status})\n

\n );\n}\n\n// Operator Dashboard component\nfunction OperatorDashboard({ user }) {\n const [tollBooths, setTollBooths] = useState([]);\n\n useEffect(() => {\n fetchTollBooths();\n }, []);\n\n const fetchTollBooths = async () => {\n const response = await fetch('/api/toll-booths', {\n headers: { 'Authorization': `Bearer ${localStorage.getItem('token')}` },\n });\n if (response.ok) {\n const data = await response.json();\n setTollBooths(data);\n }\n };\n\n return (\n

Operator Dashboard

Toll Booths

\n {booth.name}: {booth.status}\n \n

\n );\n}\n\n// Admin Dashboard component\nfunction AdminDashboard({ user }) {\n const [revenueReport, setRevenueReport] = useState(null);\n const [trafficAnalytics, setTrafficAnalytics] = useState(null);\n\n useEffect(() => {\n fetchRevenueReport();\n fetchTrafficAnalytics();\n }, []);\n\n const fetchRevenueReport = async () => {\n const response = await fetch('/api/revenue-report', {\n headers: { 'Authorization': `Bearer ${localStorage.getItem('token')}` },\n });\n if (response.ok) {\n const data = await response.json();\n setRevenueReport(data);\n }\n };\n\n const fetchTrafficAnalytics = async () => {\n const response = await fetch('/api/traffic-analytics', {\n headers: { 'Authorization': `Bearer ${localStorage.getItem('token')}` },\n });\n if (response.ok) {\n const data = await response.json();\n setTrafficAnalytics(data);\n }\n };\n\n return (\n

Admin Dashboard

Revenue Report

\n {revenueReport && (\n

Total Revenue: ${revenueReport.totalRevenue}

\n )}\n

Traffic Analytics

\n {trafficAnalytics && (\n

Peak Hours: {trafficAnalytics.peakHours}

Average Daily Vehicles: {trafficAnalytics.avgDailyVehicles}

\n )}\n

\n );\n}\n\n// Client-side rendering\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\n// Server-side code\nexport default async function server(request: Request): Promise {\n const { pathname } = new URL(request.url);\n \n if (pathname.startsWith('/api/')) {\n return handleApiRequest(request);\n }\n\n return new Response(`\n \n \n \n \n \n Toll Management and Payment System\n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n });\n}\n\nasync function handleApiRequest(request: Request): Promise {\n const { pathname } = new URL(request.url);\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const { jwtDecode } = await import(\"https://esm.sh/jwt-decode\");\n const SCHEMA_VERSION = 1;\n const KEY = \"prodigiousTanTurtle\";\n\n // Initialize database tables\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n password TEXT NOT NULL,\n role TEXT NOT NULL,\n name TEXT,\n phone TEXT\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_vehicles_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n type TEXT NOT NULL,\n make TEXT NOT NULL,\n model TEXT NOT NULL,\n year INTEGER NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${KEY}_users_${SCHEMA_VERSION}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_transactions_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n vehicle_id INTEGER NOT NULL,\n amount REAL NOT NULL,\n date DATETIME DEFAULT CURRENT_TIMESTAMP,\n status TEXT NOT NULL,\n FOREIGN KEY (user_id) REFERENCES ${KEY}_users_${SCHEMA_VERSION}(id),\n FOREIGN KEY (vehicle_id) REFERENCES ${KEY}_vehicles_${SCHEMA_VERSION}(id)\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_toll_booths_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n status TEXT NOT NULL,\n latitude REAL NOT NULL,\n longitude REAL NOT NULL\n )\n `);\n\n switch (pathname) {\n case '/api/register':\n return handleRegister(request, sqlite, KEY, SCHEMA_VERSION);\n case '/api/login':\n return handleLogin(request, sqlite, KEY, SCHEMA_VERSION);\n case '/api/profile':\n return handleProfile(request, sqlite, KEY, SCHEMA_VERSION, jwtDecode);\n case '/api/vehicles':\n return handleVehicles(request, sqlite, KEY, SCHEMA_VERSION, jwtDecode);\n case '/api/transactions':\n return handleTransactions(request, sqlite, KEY, SCHEMA_VERSION, jwtDecode);\n case '/api/toll-booths':\n return handleTollBooths(request, sqlite, KEY, SCHEMA_VERSION, jwtDecode);\n case '/api/revenue-report':\n return handleRevenueReport(request, sqlite, KEY, SCHEMA_VERSION, jwtDecode);\n case '/api/traffic-analytics':\n return handleTrafficAnalytics(request, sqlite, KEY, SCHEMA_VERSION, jwtDecode);\n default:\n return new Response('Not Found', { status: 404 });\n }\n}\n\nasync function handleRegister(request: Request, sqlite, KEY, SCHEMA_VERSION) {\n if (request.method !== 'POST') {\n return new Response('Method Not Allowed', { status: 405 });\n }\n\n const { email, password, role } = await request.json();\n\n try {\n await sqlite.execute(`\n INSERT INTO ${KEY}_users_${SCHEMA_VERSION} (email, password, role)\n VALUES (?, ?, ?)\n `, [email, password, role]);\n\n return new Response(JSON.stringify({ message: 'User registered successfully' }), {\n status: 201,\n headers: { 'Content-Type': 'application/json' },\n });\n } catch (error) {\n return new Response(JSON.stringify({ error: 'Registration failed' }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n}\n\nasync function handleLogin(request: Request, sqlite, KEY, SCHEMA_VERSION) {\n if (request.method !== 'POST') {\n return new Response('Method Not Allowed', { status: 405 });\n }\n\n const { email, password } = await request.json();\n\n const result = await sqlite.execute(`\n SELECT id, role FROM ${KEY}_users_${SCHEMA_VERSION}\n WHERE email = ? AND password = ?\n `, [email, password]);\n\n if (result.rows.length === 0) {\n return new Response(JSON.stringify({ error: 'Invalid credentials' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const user = result.rows[0];\n const token = generateJWT(user);\n\n return new Response(JSON.stringify({ token }), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n}\n\nfunction generateJWT(user) {\n // This is a simplified JWT generation.\n // In a real application, use a proper JWT library and keep the secret secure.\n const header = btoa(JSON.stringify({ alg: 'HS256', typ: 'JWT' }));\n const payload = btoa(JSON.stringify({ id: user.id, role: user.role }));\n const signature = btoa('secret'); // Use a secure secret in a real application\n return `${header}.${payload}.${signature}`;\n}\n\nasync function handleProfile(request: Request, sqlite, KEY, SCHEMA_VERSION, jwtDecode) {\n if (request.method !== 'PUT') {\n return new Response('Method Not Allowed', { status: 405 });\n }\n\n const token = request.headers.get('Authorization')?.split(' ')[1];\n if (!token) {\n return new Response(JSON.stringify({ error: 'Unauthorized' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const decodedToken = jwtDecode(token);\n const { name, phone } = await request.json();\n\n try {\n await sqlite.execute(`\n UPDATE ${KEY}_users_${SCHEMA_VERSION}\n SET name = ?, phone = ?\n WHERE id = ?\n `, [name, phone, decodedToken.id]);\n\n return new Response(JSON.stringify({ message: 'Profile updated successfully' }), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n } catch (error) {\n return new Response(JSON.stringify({ error: 'Profile update failed' }), {\n status: 400,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n}\n\nasync function handleVehicles(request: Request, sqlite, KEY, SCHEMA_VERSION, jwtDecode) {\n const token = request.headers.get('Authorization')?.split(' ')[1];\n if (!token) {\n return new Response(JSON.stringify({ error: 'Unauthorized' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const decodedToken = jwtDecode(token);\n\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_vehicles_${SCHEMA_VERSION}\n WHERE user_id = ?\n `, [decodedToken.id]);\n\n return new Response(JSON.stringify(result.rows), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n}\n\nasync function handleTransactions(request: Request, sqlite, KEY, SCHEMA_VERSION, jwtDecode) {\n const token = request.headers.get('Authorization')?.split(' ')[1];\n if (!token) {\n return new Response(JSON.stringify({ error: 'Unauthorized' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const decodedToken = jwtDecode(token);\n\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_transactions_${SCHEMA_VERSION}\n WHERE user_id = ?\n ORDER BY date DESC\n LIMIT 10\n `, [decodedToken.id]);\n\n return new Response(JSON.stringify(result.rows), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n}\n\nasync function handleTollBooths(request: Request, sqlite, KEY, SCHEMA_VERSION, jwtDecode) {\n const token = request.headers.get('Authorization')?.split(' ')[1];\n if (!token) {\n return new Response(JSON.stringify({ error: 'Unauthorized' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const decodedToken = jwtDecode(token);\n if (decodedToken.role !== 'operator' && decodedToken.role !== 'admin') {\n return new Response(JSON.stringify({ error: 'Forbidden' }), {\n status: 403,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const result = await sqlite.execute(`\n SELECT * FROM ${KEY}_toll_booths_${SCHEMA_VERSION}\n `);\n\n return new Response(JSON.stringify(result.rows), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n}\n\nasync function handleRevenueReport(request: Request, sqlite, KEY, SCHEMA_VERSION, jwtDecode) {\n const token = request.headers.get('Authorization')?.split(' ')[1];\n if (!token) {\n return new Response(JSON.stringify({ error: 'Unauthorized' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const decodedToken = jwtDecode(token);\n if (decodedToken.role !== 'admin') {\n return new Response(JSON.stringify({ error: 'Forbidden' }), {\n status: 403,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const result = await sqlite.execute(`\n SELECT SUM(amount) as totalRevenue\n FROM ${KEY}_transactions_${SCHEMA_VERSION}\n WHERE date >= date('now', '-30 days')\n `);\n\n return new Response(JSON.stringify(result.rows[0]), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n}\n\nasync function handleTrafficAnalytics(request: Request, sqlite, KEY, SCHEMA_VERSION, jwtDecode) {\n const token = request.headers.get('Authorization')?.split(' ')[1];\n if (!token) {\n return new Response(JSON.stringify({ error: 'Unauthorized' }), {\n status: 401,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const decodedToken = jwtDecode(token);\n if (decodedToken.role !== 'admin') {\n return new Response(JSON.stringify({ error: 'Forbidden' }), {\n status: 403,\n headers: { 'Content-Type': 'application/json' },\n });\n }\n\n const peakHoursResult = await sqlite.execute(`\n SELECT strftime('%H:00', date) as hour, COUNT(*) as count\n FROM ${KEY}_transactions_${SCHEMA_VERSION}\n GROUP BY hour\n ORDER BY count DESC\n LIMIT 1\n `);\n\n const avgDailyVehiclesResult = await sqlite.execute(`\n SELECT AVG(daily_count) as avgDailyVehicles\n FROM (\n SELECT COUNT(DISTINCT vehicle_id) as daily_count\n FROM ${KEY}_transactions_${SCHEMA_VERSION}\n GROUP BY date(date)\n )\n `);\n\n const analytics = {\n peakHours: peakHoursResult.rows[0].hour,\n avgDailyVehicles: Math.round(avgDailyVehiclesResult.rows[0].avgDailyVehicles),\n };\n\n return new Response(JSON.stringify(analytics), {\n status: 200,\n headers: { 'Content-Type': 'application/json' },\n });\n}\n\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n color: #333;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\n\nheader {\n background-color: #f4f4f4;\n padding: 1rem;\n margin-bottom: 2rem;\n}\n\nnav {\n display: flex;\n justify-content: space-around;\n}\n\na {\n color: #333;\n text-decoration: none;\n}\n\na:hover {\n color: #666;\n}\n\nform {\n display: flex;\n flex-direction: column;\n max-width: 300px;\n margin: 0 auto;\n}\n\ninput, select, button {\n margin-bottom: 1rem;\n padding: 0.5rem;\n}\n\nbutton {\n background-color: #333;\n color: #fff;\n border: none;\n cursor: pointer;\n}\n\nbutton:hover {\n background-color: #666;\n}\n\nul {\n list-style-type: none;\n padding: 0;\n}\n\nli {\n margin-bottom: 0.5rem;\n}\n\nfooter {\n margin-top: 2rem;\n text-align: center;\n font-size: 0.8rem;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/ocholap9/prodigiousTanTurtle/code/main.tsx","extension","actionData","errors"]