${i + 1}. ${escapeHtml(name)}${notes}

';\n } else {\n volunteerListHtml = '

登録者はいません。

';\n }\n\n // Send email to school with error handling\n schoolEmailResult = await platform.sendEmail({\n templateName: 'volunteer_school_notification',\n recipientEmail: 'japanskajimu@hotmail.com',\n customVariables: {\n dayDate: day.date || 'N/A',\n dayTitle: day.title || 'N/A',\n dayType: day.day_type === 'saturday' ? '土曜学校' : \n day.day_type === 'special' ? '特別イベント' : '土曜学校＆特別イベント',\n dayDescription: day.description || 'なし',\n currentBookings: (day.current_bookings || 0).toString(),\n maxVolunteers: day.max_volunteers?.toString() || '制限なし',\n volunteerList: volunteerListHtml\n }\n });\n console.log('School notification email sent:', schoolEmailResult);\n } catch (schoolEmailError) {\n console.error('Failed to send school notification:', schoolEmailError);\n // Continue execution, but we'll log the error\n }\n }\n\n // Return success without exposing internal details\n return Response.json({ \n success: true,\n message: 'Cutoff notification processed successfully',\n notifiedSchool: !!shouldNotifySchool,\n ennichikaiEmailSent: !!emailResult && emailResult.responseCode === 'email_sent',\n schoolEmailSent: !!schoolEmailResult && schoolEmailResult.responseCode === 'email_sent'\n });\n\n } catch (error) {\n console.error('Error in volunteer cutoff notification:', error);\n return Response.json({ \n error: 'Internal server error',\n message: 'Failed to process cutoff notification'\n }, { status: 500 });\n }\n}\n\n// HTML escape utility function\nfunction escapeHtml(unsafe: string): string {\n return unsafe\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}",[],[175],{"_104":183,"_96":184,"_156":185,"_157":-5,"_158":141,"_159":163,"_161":118,"_106":186,"_101":187,"_164":165,"_166":188,"_168":22,"_169":-5,"_170":189,"_99":190},"41cc3c5a-c0e4-11f0-8203-42dde27851f2","fu44v2703ts1904t3099e6t5q73tt52v6t.ts","9611e6a8-c0e3-11f0-9dcb-42dde27851f2",["D",1763074703737],1,"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n // Get user from header\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n // Connect to database\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n const body = await req.json();\n const { userUuid: targetUserUuid, scheduleDayId } = body;\n\n if (!targetUserUuid || !scheduleDayId) {\n return Response.json({ error: \"Target user UUID and schedule day ID required\" }, { status: 400 });\n }\n\n console.log(`Cleaning up booking for user ${targetUserUuid}, day ${scheduleDayId}`);\n\n // Find and hard delete any bookings (both active and soft-deleted) for this specific day\n const findStmt = conn.prepare(`\n SELECT _row_id, _deleted FROM volunteer_bookings \n WHERE user_uuid = ? AND schedule_day_id = ?\n `);\n \n const existingBookings = findStmt.all([targetUserUuid, scheduleDayId]);\n console.log(`Found ${existingBookings.length} bookings:`, existingBookings);\n\n // Delete ALL bookings for this day and user to prevent constraint issues\n const deleteStmt = conn.prepare(`\n DELETE FROM volunteer_bookings \n WHERE user_uuid = ? AND schedule_day_id = ?\n `);\n \n const deleteResult = deleteStmt.run([targetUserUuid, scheduleDayId]);\n console.log(`Deleted ${deleteResult.changes} bookings`);\n\n return Response.json({\n success: true,\n deletedCount: deleteResult.changes,\n message: `Cleaned up ${deleteResult.changes} bookings for day ${scheduleDayId}`\n });\n\n } catch (error) {\n console.error(\"Error in volunteer-bookings-cleanup:\", error);\n return Response.json({ \n error: \"Internal server error\",\n details: error.message \n }, { status: 500 });\n }\n}",[],[184],{"_104":192,"_96":193,"_156":194,"_157":-5,"_158":141,"_159":195,"_161":118,"_106":196,"_101":32,"_164":165,"_166":197,"_168":22,"_169":-5,"_170":198,"_99":199},"2a9b858a-c310-11f0-ad30-42dde27851f2","fu481tt6q40qq74vf587t1e5399116fsv9.ts","2a9b8652-c310-11f0-ad30-42dde27851f2",3,["D",1763313465013],"export default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n const userUuid = req.headers.get('x-user-uuid');\n \n if (!userUuid) {\n return Response.json({ error: 'Unauthorized' }, { status: 401 });\n }\n\n try {\n const { connect } = await import(\"npm:@tursodatabase/serverless\");\n \n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n // Query to get only group chats where the user is a participant\n const stmt = conn.prepare(`\n SELECT DISTINCT gc.*\n FROM group_chat_conversations gc\n INNER JOIN group_chat_participants gcp ON gc.group_id = gcp.group_id\n WHERE gcp.user_uuid = ?\n AND gc._deleted = 0\n AND gc.is_active = 1\n AND gcp._deleted = 0\n ORDER BY gc.last_message_at DESC\n `);\n \n const result = await stmt.all([userUuid]);\n \n return Response.json({ \n data: result.rows || [],\n success: true \n }, { status: 200 });\n \n } catch (error) {\n console.error('Error fetching group chats:', error);\n return Response.json({ \n error: 'Failed to fetch group chats',\n details: error instanceof Error ? error.message : String(error)\n }, { status: 500 });\n }\n}",[],[193],{"_104":201,"_96":100,"_156":202,"_157":-5,"_158":141,"_159":203,"_161":118,"_106":204,"_101":32,"_164":165,"_166":205,"_168":22,"_169":-5,"_170":206,"_99":207},"484e174e-d21c-11f0-bbde-42dde27851f2","484e1820-d21c-11f0-bbde-42dde27851f2",12,["D",1764967936241],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n // Only accept POST requests\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n try {\n const body = await req.json();\n const { email, name } = body;\n\n // Validate email\n if (!email || typeof email !== 'string') {\n return Response.json({ error: 'Email is required' }, { status: 400 });\n }\n\n // Basic email validation\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(email)) {\n return Response.json({ error: 'Invalid email address' }, { status: 400 });\n }\n\n // Connect to database\n const conn = connect({\n url: req.headers.get(\"x-database-url\") || \"\",\n authToken: req.headers.get(\"x-database-token\") || \"\"\n });\n\n // Check if email already exists\n const checkStmt = conn.prepare(\"SELECT _row_id, is_active FROM newsletter_subscribers WHERE email = ?\");\n const existing = await checkStmt.get([email.toLowerCase()]);\n\n if (existing) {\n // If already subscribed and active\n if (existing.is_active === 1) {\n return Response.json({ \n message: 'This email is already subscribed',\n already_subscribed: true \n }, { status: 200 });\n }\n \n // Reactivate if previously unsubscribed\n const updateStmt = conn.prepare(\n \"UPDATE newsletter_subscribers SET is_active = 1, subscribed_at = CURRENT_TIMESTAMP WHERE email = ?\"\n );\n await updateStmt.run([email.toLowerCase()]);\n \n return Response.json({ \n message: 'Subscription reactivated successfully',\n reactivated: true \n }, { status: 200 });\n }\n\n // Insert new subscriber\n const insertStmt = conn.prepare(\n \"INSERT INTO newsletter_subscribers (email, name) VALUES (?, ?)\"\n );\n await insertStmt.run([email.toLowerCase(), name || null]);\n\n console.log('Newsletter subscription created:', email);\n\n return Response.json({ \n message: 'Successfully subscribed to newsletter',\n success: true \n }, { status: 200 });\n\n } catch (error) {\n console.error('Newsletter subscription error:', error);\n \n return Response.json({ \n error: 'Failed to subscribe. Please try again later.',\n details: error instanceof Error ? error.message : 'Unknown error'\n }, { status: 500 });\n }\n}\n",[],[100],{"_104":209,"_96":210,"_156":211,"_157":-5,"_158":141,"_159":212,"_161":118,"_106":213,"_101":187,"_164":165,"_166":214,"_168":22,"_169":-5,"_170":215,"_99":216},"aceed5ea-c712-11f0-9cd4-42dde27851f2","fu59ee3v36s12q4260970tq1qt790q03tf.ts","02f188a8-c703-11f0-8db5-42dde27851f2",8,["D",1763754347303],"import { connect } from \"npm:@tursodatabase/serverless\";\n\ninterface VerifyRequest {\n email: string;\n code: string;\n}\n\ninterface ResendRequest {\n email: string;\n}\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n const body = await req.json() as VerifyRequest | ResendRequest;\n const path = new URL(req.url).pathname;\n\n const conn = connect({\n url: req.headers.get(\"x-database-url\")!,\n authToken: req.headers.get(\"x-database-token\")!\n });\n\n if (path.includes('/resend')) {\n // Resend verification code\n const { email } = body as ResendRequest;\n \n if (!email) {\n return Response.json({ error: 'Email is required' }, { status: 400 });\n }\n\n // Generate new verification code\n const code = generateVerificationCode();\n const expiresAt = Math.floor(Date.now() / 1000) + (15 * 60); // 15 minutes in seconds\n\n // Update or insert verification record\n const updateStmt = conn.prepare(`\n INSERT OR REPLACE INTO email_verifications (email, code, expires_at, used_at)\n VALUES (?, ?, ?, NULL)\n `);\n \n await updateStmt.run([email, code, expiresAt]);\n\n // Import platform client using SDK URL\n const sdkUrl = req.headers.get(\"x-sdk-url\");\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(\n req.headers.get(\"x-platform-token\"),\n req.headers.get(\"x-api-base-url\")\n );\n\n // Send verification email using platform's email system\n try {\n const emailResult = await platform.sendEmail({\n templateName: 'email_confirmation',\n recipientEmail: email,\n customVariables: {\n firstName: email.split('@')[0], // Extract name from email as fallback\n code: code,\n email: email\n }\n });\n\n console.log('Email sent successfully:', emailResult);\n return Response.json({ success: true, message: 'Verification code sent', details: emailResult });\n } catch (emailError) {\n console.error('Email sending error:', emailError);\n return Response.json({ error: 'Failed to send verification email', details: emailError.message }, { status: 500 });\n }\n\n } else {\n // Verify code\n const { email, code } = body as VerifyRequest;\n \n if (!email || !code) {\n return Response.json({ error: 'Email and code are required' }, { status: 400 });\n }\n\n // Check verification code\n const checkStmt = conn.prepare(`\n SELECT * FROM email_verifications \n WHERE email = ? AND code = ? AND expires_at > ? AND used_at IS NULL\n `);\n \n const result = await checkStmt.get([email, code.toUpperCase(), Math.floor(Date.now() / 1000)]);\n \n if (!result) {\n return Response.json({ error: 'Invalid or expired verification code' }, { status: 400 });\n }\n\n // Mark the verification code as used\n const markUsedStmt = conn.prepare('UPDATE email_verifications SET used_at = ? WHERE email = ? AND code = ?');\n await markUsedStmt.run([Math.floor(Date.now() / 1000), email, code.toUpperCase()]);\n\n // Mark user as verified in user_verifications table\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (userUuid) {\n const updateVerifiedStmt = conn.prepare(`\n UPDATE user_verifications \n SET email_verified = 1, status = 'verified'\n WHERE user_uuid = ?\n `);\n await updateVerifiedStmt.run([userUuid]);\n }\n\n return Response.json({ success: true, message: 'Email verified successfully' });\n }\n\n } catch (error) {\n console.error('Verification error:', error);\n return Response.json({ error: 'Internal server error', details: error.message }, { status: 500 });\n }\n}\n\nfunction generateVerificationCode(): string {\n const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';\n let result = '';\n for (let i = 0; i < 6; i++) {\n result += chars.charAt(Math.floor(Math.random() * chars.length));\n }\n return result;\n}",[],[210],{"_104":218,"_96":219,"_156":220,"_157":-5,"_158":141,"_159":221,"_161":118,"_106":222,"_101":32,"_164":165,"_166":223,"_168":22,"_169":-5,"_170":224,"_99":225},"7933dbc4-cd20-11f0-9172-42dde27851f2","fu7672637qe20245678082fq48f3qt3f1s.ts","7933dd04-cd20-11f0-9172-42dde27851f2",9,["D",1764419980451],"export default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const userUuid = req.headers.get(\"x-user-uuid\");\n const userName = req.headers.get(\"x-user-name\") || '';\n const sdkUrl = req.headers.get(\"x-sdk-url\");\n const platformToken = req.headers.get(\"x-platform-token\");\n const apiBaseUrl = req.headers.get(\"x-api-base-url\");\n \n // 必須ヘッダーの検証\n if (!userUuid) {\n return Response.json({ error: '認証が必要です' }, { status: 401 });\n }\n \n if (!sdkUrl || !platformToken || !apiBaseUrl) {\n return Response.json({ error: 'プラットフォームヘッダーが不足しています' }, { status: 500 });\n }\n \n // ユーザー情報を取得\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(platformToken, apiBaseUrl);\n \n const richContext = await platform.getRichContext();\n const userEmail = richContext.user?.email;\n \n if (!userEmail) {\n return Response.json({ error: 'メールアドレスが取得できません' }, { status: 400 });\n }\n \n // 変更日時を日本時間でフォーマット\n const now = new Date();\n const changedAt = now.toLocaleString('ja-JP', { \n timeZone: 'Asia/Tokyo',\n year: 'numeric',\n month: 'long',\n day: 'numeric',\n hour: '2-digit',\n minute: '2-digit'\n });\n \n // メール送信\n await platform.sendEmail({\n templateName: 'password_changed',\n recipientEmail: userEmail,\n recipientName: userName,\n customVariables: {\n userName: userName || userEmail,\n changedAt: changedAt\n }\n });\n \n await platform.log('info', 'パスワード変更通知メール送信完了', { userUuid });\n \n return Response.json({ success: true, message: '通知メールを送信しました' });\n } catch (error) {\n console.error('パスワード変更通知エラー:', error);\n return Response.json({ error: 'メール送信に失敗しました' }, { status: 500 });\n }\n}",[],[219],{"_104":227,"_96":228,"_156":229,"_157":-5,"_158":141,"_159":230,"_161":118,"_106":231,"_101":32,"_164":165,"_166":232,"_168":22,"_169":-5,"_170":233,"_99":234},"dc1a8f38-ce21-11f0-ab66-42dde27851f2","fu881v69qvt2t943118t91e0e4v2fsq297.ts","dc1a8fec-ce21-11f0-ab66-42dde27851f2",11,["D",1764530527041],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n // Verify authentication (require logged-in user)\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ \n error: 'Authentication required' \n }, { status: 401 });\n }\n\n // Get platform SDK for email sending\n const sdkUrl = req.headers.get(\"x-sdk-url\");\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(\n req.headers.get(\"x-platform-token\"),\n req.headers.get(\"x-api-base-url\")\n );\n\n // Connect to database\n const conn = connect({\n url: req.headers.get(\"x-database-url\"),\n authToken: req.headers.get(\"x-database-token\")\n });\n\n // Get current timestamp\n const currentTime = Math.floor(Date.now() / 1000);\n console.log(`Processing scheduled cutoffs at ${new Date(currentTime * 1000).toISOString()}`);\n\n // Find volunteer days that should be cutoff now\n // (cutoff_time is set, is in the past, and day is not already cutoff)\n const stmt = conn.prepare(`\n SELECT *, \n (SELECT COUNT(*) FROM volunteer_bookings \n WHERE schedule_day_id = _row_id AND booking_status = 'confirmed' AND _deleted = 0) as current_bookings\n FROM volunteer_schedule_days \n WHERE cutoff_time IS NOT NULL \n AND cutoff_time <= ? \n AND is_cutoff = 0 \n AND _deleted = 0 \n AND is_active = 1\n `);\n const daysToCutoff = await stmt.all([currentTime]);\n\n console.log(`Found ${daysToCutoff.length} volunteer days to cutoff`);\n\n const results = [];\n\n for (const day of daysToCutoff) {\n try {\n // Update the day to mark it as cutoff\n const updateStmt = conn.prepare(`\n UPDATE volunteer_schedule_days \n SET is_cutoff = 1, _updated_at = ? \n WHERE _row_id = ?\n `);\n await updateStmt.run([currentTime, day._row_id]);\n\n console.log(`Marked volunteer day ${day._row_id} (${day.date}) as cutoff`);\n\n // Send email notification to ennichikai with error handling\n let emailResult = null;\n try {\n emailResult = await platform.sendEmail({\n templateName: 'volunteer_cutoff_notification',\n recipientEmail: 'info@ennichikai.org',\n customVariables: {\n dayDate: day.date || 'N/A',\n dayTitle: day.title || 'N/A',\n dayType: day.day_type || 'saturday',\n dayDescription: day.description || 'No description provided',\n currentBookings: (day.current_bookings || 0).toString(),\n maxVolunteers: day.max_volunteers?.toString() || 'Unlimited'\n }\n });\n console.log(`Sent cutoff notification for day ${day._row_id}:`, emailResult);\n } catch (emailError) {\n console.error(`Failed to send cutoff notification to ennichikai for day ${day._row_id}:`, emailError);\n }\n\n // Check if we should notify the school\n let schoolEmailSent = false;\n if (day.notify_school === 1) {\n try {\n // Get volunteer list with user details\n const volunteersStmt = conn.prepare(`\n SELECT vb.*, u.first_name, u.last_name, COALESCE(u.first_name, '') || ' ' || COALESCE(u.last_name, '') as full_name\n FROM volunteer_bookings vb\n LEFT JOIN users u ON vb.user_uuid = u.uuid\n WHERE vb.schedule_day_id = ? \n AND vb.booking_status = 'confirmed' \n AND vb._deleted = 0\n ORDER BY vb._created_at ASC\n `);\n const volunteers = await volunteersStmt.all([day._row_id]);\n\n // Build volunteer list HTML with safe defaults\n let volunteerListHtml = '';\n if (volunteers && volunteers.length > 0) {\n volunteerListHtml = '

${i + 1}. ${escapeHtml(name)}${notes}

';\n } else {\n volunteerListHtml = '

登録者はいません。

';\n }\n\n // Send email to school with error handling\n const schoolEmailResult = await platform.sendEmail({\n templateName: 'volunteer_school_notification',\n recipientEmail: 'japanskajimu@hotmail.com',\n customVariables: {\n dayDate: day.date || 'N/A',\n dayTitle: day.title || 'N/A',\n dayType: day.day_type === 'saturday' ? '土曜学校' : \n day.day_type === 'special' ? '特別イベント' : '土曜学校＆特別イベント',\n dayDescription: day.description || 'なし',\n currentBookings: (day.current_bookings || 0).toString(),\n maxVolunteers: day.max_volunteers?.toString() || '制限なし',\n volunteerList: volunteerListHtml\n }\n });\n console.log(`Sent school notification for day ${day._row_id}:`, schoolEmailResult);\n schoolEmailSent = true;\n } catch (schoolEmailError) {\n console.error(`Failed to send school notification for day ${day._row_id}:`, schoolEmailError);\n }\n }\n\n results.push({\n dayId: day._row_id,\n date: day.date,\n title: day.title,\n status: 'success',\n emailSent: !!emailResult && emailResult.responseCode === 'email_sent',\n schoolEmailSent\n });\n\n } catch (error) {\n console.error(`Failed to process cutoff for day ${day._row_id}:`, error);\n results.push({\n dayId: day._row_id,\n date: day.date,\n title: day.title,\n status: 'error',\n error: error.message\n });\n }\n }\n\n return Response.json({ \n success: true,\n processedAt: new Date(currentTime * 1000).toISOString(),\n totalProcessed: results.length,\n results\n });\n\n } catch (error) {\n console.error('Error in scheduled cutoff processor:', error);\n return Response.json({ \n error: 'Internal server error',\n message: 'Failed to process scheduled cutoffs'\n }, { status: 500 });\n }\n}\n\n// HTML escape utility function\nfunction escapeHtml(unsafe: string): string {\n return unsafe\n .replace(/&/g, \"&\")\n .replace(//g, \">\")\n .replace(//g, \">\")\n .replace(/\"/g, \""\")\n .replace(/'/g, \"'\");\n}",[],[228],{"_104":236,"_96":237,"_156":238,"_157":-5,"_158":141,"_159":140,"_161":118,"_106":239,"_101":187,"_164":165,"_166":240,"_168":22,"_169":-5,"_170":241,"_99":242},"4a5425b2-d48b-11f0-91c0-42dde27851f2","fu93799q7t6ffe43679vqsv78f24363tvv.ts","5dba599c-d48a-11f0-a820-42dde27851f2",["D",1765235516094],"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n if (req.method !== 'POST') {\n return Response.json({ error: 'Method not allowed' }, { status: 405 });\n }\n\n // Check authentication - this function requires authenticated users\n const userUuid = req.headers.get(\"x-user-uuid\");\n if (!userUuid) {\n return Response.json({ error: 'Authentication required' }, { status: 401 });\n }\n\n // Validate required headers\n const databaseUrl = req.headers.get(\"x-database-url\");\n const databaseToken = req.headers.get(\"x-database-token\");\n const platformToken = req.headers.get(\"x-platform-token\");\n const apiBaseUrl = req.headers.get(\"x-api-base-url\");\n const sdkUrl = req.headers.get(\"x-sdk-url\");\n\n if (!databaseUrl || !databaseToken || !platformToken || !apiBaseUrl || !sdkUrl) {\n return Response.json({ error: 'Missing required headers' }, { status: 400 });\n }\n\n const body = await req.json();\n const { email, isBulkCreation = false } = body;\n \n if (!email) {\n return Response.json({ error: 'Email is required' }, { status: 400 });\n }\n\n // Basic email validation\n if (!email.includes('@') || email.length < 5) {\n return Response.json({ error: 'Invalid email format' }, { status: 400 });\n }\n\n // Connect to database\n const conn = connect({\n url: databaseUrl,\n authToken: databaseToken\n });\n\n // Generate secure setup code\n const code = generateSecureCode();\n const expiresAt = Math.floor(Date.now() / 1000) + (24 * 60 * 60); // 24 hours\n const now = Math.floor(Date.now() / 1000);\n\n // Check if user exists\n const userCheckStmt = conn.prepare(\"SELECT email FROM users WHERE email = ? LIMIT 1\");\n const existingUser = await userCheckStmt.get([email]);\n \n if (!existingUser) {\n return Response.json({ error: 'User not found' }, { status: 404 });\n }\n\n // Delete existing reset codes for this email\n const deleteStmt = conn.prepare(\"DELETE FROM password_resets WHERE email = ?\");\n await deleteStmt.run([email]);\n\n // Insert new reset code - use correct schema without system columns\n const insertStmt = conn.prepare(`\n INSERT INTO password_resets (email, code, created_at, expires_at)\n VALUES (?, ?, ?, ?)\n `);\n \n await insertStmt.run([email, code, now, expiresAt]);\n\n // Import platform clients\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(platformToken, apiBaseUrl);\n\n // Get user first name from email (fallback approach)\n let firstName = email.split('@')[0].replace(/[^a-zA-Z]/g, '');\n if (firstName.length === 0) firstName = 'Member';\n\n // Send email using platform\n try {\n const templateName = isBulkCreation ? 'account_setup_welcome' : 'user_password_reset_ja';\n \n const emailResult = await platform.sendEmail({\n templateName: templateName,\n recipientEmail: email,\n customVariables: {\n firstName: firstName,\n code: code,\n email: email\n }\n });\n\n console.log('Account setup email sent successfully');\n return Response.json({ \n success: true, \n message: isBulkCreation ? 'Account setup code sent' : 'Reset code sent'\n });\n } catch (emailError) {\n console.error('Email sending error:', emailError);\n return Response.json({ \n error: 'Failed to send email' \n }, { status: 500 });\n }\n\n } catch (error) {\n console.error('Account setup error:', error);\n return Response.json({ \n error: 'Internal server error' \n }, { status: 500 });\n }\n}\n\nfunction generateSecureCode(): string {\n const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';\n const array = new Uint8Array(6);\n crypto.getRandomValues(array);\n \n let result = '';\n for (let i = 0; i < 6; i++) {\n result += chars[array[i] % chars.length];\n }\n return result;\n}",[],[237],"files",[153,173,182,191,200,208,217,226,235],"counts",{"_247":32,"_248":187,"_249":32,"_250":251},"pulls","branches","forks","envVars",{"_252":32,"_253":32},"count","emptyCount","contents",[],"file",{"_104":201,"_96":100,"_156":202,"_157":-5,"_158":141,"_159":203,"_161":118,"_106":258,"_101":32,"_164":165,"_166":205,"_168":22,"_169":-5,"_99":259},["D",1764967936241],[100],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_94":95,"_96":97,"_98":44,"_101":-7,"_99":100,"_102":268,"_151":273,"_243":301,"_256":302,"_254":304,"_305":-5,"_306":-5,"_307":-5,"_308":-5,"_309":310,"_250":-5},{"_104":105,"_96":97,"_106":269,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":116,"_117":118,"_119":118,"_120":-5,"_121":32,"_16":122,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_23":270,"_135":271,"_138":272,"_150":22},["D",1763074415526],{"_94":95,"_133":134},{"_94":95,"_137":134,"_14":114},{"_101":140,"_96":44,"_104":141,"_142":105,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":97,"_149":95},[274,277,280,283,286,289,292,295,298],{"_104":154,"_96":155,"_156":116,"_157":-5,"_158":141,"_159":160,"_161":118,"_106":162,"_101":163,"_164":165,"_166":167,"_168":22,"_169":-5,"_170":275,"_99":276},[],[155],{"_104":174,"_96":175,"_156":176,"_157":-5,"_158":141,"_159":177,"_161":118,"_106":178,"_101":32,"_164":165,"_166":179,"_168":22,"_169":-5,"_170":278,"_99":279},[],[175],{"_104":183,"_96":184,"_156":185,"_157":-5,"_158":141,"_159":163,"_161":118,"_106":186,"_101":187,"_164":165,"_166":188,"_168":22,"_169":-5,"_170":281,"_99":282},[],[184],{"_104":192,"_96":193,"_156":194,"_157":-5,"_158":141,"_159":195,"_161":118,"_106":196,"_101":32,"_164":165,"_166":197,"_168":22,"_169":-5,"_170":284,"_99":285},[],[193],{"_104":201,"_96":100,"_156":202,"_157":-5,"_158":141,"_159":203,"_161":118,"_106":204,"_101":32,"_164":165,"_166":205,"_168":22,"_169":-5,"_170":287,"_99":288},[],[100],{"_104":209,"_96":210,"_156":211,"_157":-5,"_158":141,"_159":212,"_161":118,"_106":213,"_101":187,"_164":165,"_166":214,"_168":22,"_169":-5,"_170":290,"_99":291},[],[210],{"_104":218,"_96":219,"_156":220,"_157":-5,"_158":141,"_159":221,"_161":118,"_106":222,"_101":32,"_164":165,"_166":223,"_168":22,"_169":-5,"_170":293,"_99":294},[],[219],{"_104":227,"_96":228,"_156":229,"_157":-5,"_158":141,"_159":230,"_161":118,"_106":231,"_101":32,"_164":165,"_166":232,"_168":22,"_169":-5,"_170":296,"_99":297},[],[228],{"_104":236,"_96":237,"_156":238,"_157":-5,"_158":141,"_159":140,"_161":118,"_106":239,"_101":187,"_164":165,"_166":240,"_168":22,"_169":-5,"_170":299,"_99":300},[],[237],[274,277,280,283,286,289,292,295,298],{"_104":201,"_96":100,"_156":202,"_157":-5,"_158":141,"_159":203,"_161":118,"_106":258,"_101":32,"_164":165,"_166":205,"_168":22,"_169":-5,"_99":303},[100],[],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

kliv

te9e6sv4vt78104s9f9f7te24957s8v7v5