${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}",[139],"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}",[146],"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}",[153],"484e174e-d21c-11f0-bbde-42dde27851f2","fu568f52e3qvf34f069se076e873s8s1q8.ts","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",[160],"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}",[167],"41cc3c5a-c0e4-11f0-8203-42dde27851f2","fu44v2703ts1904t3099e6t5q73tt52v6t.ts","9611e6a8-c0e3-11f0-9dcb-42dde27851f2",2,["D",1763074703737],"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}",[174],"d1613dee-ce21-11f0-bf8b-42dde27851f2","fu1e18e17v041e4te593581s42471384t9.ts","d1613eb6-ce21-11f0-bf8b-42dde27851f2",10,["D",1764530509035],"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 context and 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 // Get user context to check if admin\n const richContext = await platform.getRichContext();\n const isAdmin = richContext?.user?.role === 'admin' || richContext?.user?.role === 'superadmin';\n\n // Only admins can cutoff volunteer days\n if (!isAdmin) {\n return Response.json({ \n error: 'Admin access required' \n }, { status: 403 });\n }\n\n // Parse request body and validate action\n const body = await req.json();\n const { dayId, action, notifySchool } = body;\n\n if (!dayId || !action) {\n return Response.json({ \n error: 'Missing required parameters: dayId and action' \n }, { status: 400 });\n }\n\n // Validate action against allowed values\n if (action !== 'cutoff' && action !== 'uncutoff') {\n return Response.json({ \n error: 'Invalid action. Must be \"cutoff\" or \"uncutoff\"' \n }, { status: 400 });\n }\n\n // Validate dayId is a positive integer\n const dayIdNum = parseInt(dayId);\n if (!dayIdNum || dayIdNum <= 0) {\n return Response.json({ \n error: 'Invalid dayId. Must be a positive integer' \n }, { 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 // Get the volunteer day details (admin can access any)\n const dayStmt = conn.prepare(`\n SELECT *, \n (SELECT COUNT(*) FROM volunteer_bookings \n WHERE schedule_day_id = ? AND booking_status = 'confirmed' AND _deleted = 0) as current_bookings\n FROM volunteer_schedule_days \n WHERE _row_id = ? AND _deleted = 0\n `);\n const day = await dayStmt.get([dayIdNum, dayIdNum]);\n\n if (!day) {\n return Response.json({ \n error: 'Volunteer day not found' \n }, { status: 404 });\n }\n\n // Only send email when marking as cutoff, not when un-cutoffing\n if (action !== 'cutoff') {\n return Response.json({ \n success: true, \n message: 'No notification sent for non-cutoff action' \n });\n }\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('Cutoff notification email sent:', emailResult);\n } catch (emailError) {\n console.error('Failed to send cutoff notification to ennichikai:', emailError);\n // Continue execution, but we'll log the error\n }\n\n // Check if we should notify the school\n const shouldNotifySchool = notifySchool || (day.notify_school === 1);\n let schoolEmailResult = null;\n\n if (shouldNotifySchool) {\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([dayIdNum]);\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 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}",[181],"820d3666-c3a5-11f0-a308-42dde27851f2","fu1e17030qq76440tfs24v49vq814t2f23.ts",6,["D",1763377606730],"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 const userUuid = req.headers.get(\"x-user-uuid\");\n const databaseUrl = req.headers.get(\"x-database-url\");\n const databaseToken = req.headers.get(\"x-database-token\");\n \n console.log(\"get-group-messages: Request headers:\", { \n userUuid, \n hasDatabaseUrl: !!databaseUrl,\n hasDatabaseToken: !!databaseToken\n });\n \n if (!userUuid) {\n console.log(\"get-group-messages: No user UUID provided\");\n return Response.json({ error: \"Unauthorized\" }, { status: 401 });\n }\n\n const body = await req.json();\n const { group_id } = body;\n\n console.log(\"get-group-messages: Request body:\", { group_id });\n\n if (!group_id) {\n console.log(\"get-group-messages: No group_id provided\");\n return Response.json({ error: \"group_id required\" }, { status: 400 });\n }\n\n const conn = connect({\n url: databaseUrl || \"\",\n authToken: databaseToken || \"\"\n });\n\n console.log(\"get-group-messages: Database connection established\");\n\n // Check if user is a participant in this group\n const participantCheck = conn.prepare(\n \"SELECT * FROM group_chat_participants WHERE group_id = ? AND user_uuid = ? AND _deleted = 0\"\n );\n const participant = await participantCheck.get([group_id, userUuid]);\n\n console.log(\"get-group-messages: Participant check:\", participant ? \"found\" : \"not found\");\n\n if (!participant) {\n console.log(\"get-group-messages: User not authorized for group\");\n return Response.json({ error: \"Not a participant of this group\" }, { status: 403 });\n }\n\n // First, let's check all messages in the conversation to debug\n const allMessagesCheck = conn.prepare(\n \"SELECT * FROM messages WHERE conversation_id = ? ORDER BY _created_at ASC\"\n );\n const allMessages = await allMessagesCheck.all([group_id]);\n \n console.log(\"get-group-messages: All messages in conversation:\", allMessages.rows?.length || 0);\n\n // Fetch messages for this group with specific category filter\n const messagesStmt = conn.prepare(\n \"SELECT * FROM messages WHERE conversation_id = ? AND message_category = 'group' AND _deleted = 0 ORDER BY _created_at ASC\"\n );\n const result = await messagesStmt.all([group_id]);\n\n console.log(\"get-group-messages: Filtered group messages:\", result.rows?.length || 0);\n\n // Also check without the deleted filter for debugging\n const allGroupMessagesStmt = conn.prepare(\n \"SELECT * FROM messages WHERE conversation_id = ? AND message_category = 'group' ORDER BY _created_at ASC\"\n );\n const allGroupResult = await allGroupMessagesStmt.all([group_id]);\n \n console.log(\"get-group-messages: All group messages (including deleted):\", allGroupResult.rows?.length || 0);\n\n return Response.json({ \n data: result.rows || [],\n debug: {\n participantFound: !!participant,\n allMessagesCount: allMessages.rows?.length || 0,\n groupMessagesCount: result.rows?.length || 0,\n allGroupMessagesCount: allGroupResult.rows?.length || 0\n }\n }, { status: 200 });\n } catch (error) {\n console.error(\"get-group-messages: Error:\", error);\n return Response.json({ error: \"Internal server error\", details: String(error) }, { status: 500 });\n }\n}",[188],"pulls","forks","envVars",{"_199":53,"_201":53},"connections",{"_199":53,"_200":53},"count","unfilledCount","emptyCount",{"_20":187,"_13":188,"_123":47,"_125":-5,"_126":21,"_127":189,"_128":49,"_22":236,"_29":176,"_131":132,"_133":191,"_135":38,"_136":-5,"_212":237,"_89":238},{"_20":180,"_13":181,"_123":182,"_125":-5,"_126":21,"_127":183,"_128":49,"_22":233,"_29":53,"_131":132,"_133":185,"_135":38,"_136":-5,"_212":234,"_89":235},{"_20":173,"_13":174,"_123":175,"_125":-5,"_126":21,"_127":176,"_128":49,"_22":230,"_29":130,"_131":132,"_133":178,"_135":38,"_136":-5,"_212":231,"_89":232},{"_20":166,"_13":167,"_123":168,"_125":-5,"_126":21,"_127":169,"_128":49,"_22":227,"_29":53,"_131":132,"_133":171,"_135":38,"_136":-5,"_212":228,"_89":229},{"_20":159,"_13":160,"_123":161,"_125":-5,"_126":21,"_127":162,"_128":49,"_22":224,"_29":53,"_131":132,"_133":164,"_135":38,"_136":-5,"_212":225,"_89":226},{"_20":152,"_13":153,"_123":154,"_125":-5,"_126":21,"_127":155,"_128":49,"_22":221,"_29":130,"_131":132,"_133":157,"_135":38,"_136":-5,"_212":222,"_89":223},{"_20":145,"_13":146,"_123":147,"_125":-5,"_126":21,"_127":148,"_128":49,"_22":218,"_29":53,"_131":132,"_133":150,"_135":38,"_136":-5,"_212":219,"_89":220},{"_20":138,"_13":139,"_123":140,"_125":-5,"_126":21,"_127":141,"_128":49,"_22":215,"_29":53,"_131":132,"_133":143,"_135":38,"_136":-5,"_212":216,"_89":217},{"_20":121,"_13":122,"_123":124,"_125":-5,"_126":21,"_127":30,"_128":49,"_22":211,"_29":130,"_131":132,"_133":134,"_135":38,"_136":-5,"_212":213,"_89":214},["D",1765235516094],"children",[],[122],["D",1764530527041],[],[139],["D",1764419980451],[],[146],["D",1763754347303],[],[153],["D",1764967936241],[],[160],["D",1763313465013],[],[167],["D",1763074703737],[],[174],["D",1764530509035],[],[181],["D",1763377606730],[],[188],["D",1763074415526],{"_11":12,"_87":83},{"_11":12,"_81":-5,"_82":83,"_44":45,"_84":85,"_86":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_76":-5,"_77":-5,"_78":-5,"_79":14,"_80":12},"ctx",{"_69":-5,"_109":276,"_277":278,"_279":280,"_281":38,"_282":38,"_283":38,"_284":49,"_285":-5,"_286":-7,"_287":-7,"_288":53,"_289":38,"_290":38,"_291":-5,"_292":38,"_293":38,"_294":38,"_295":-5},"ENV",{"_247":248,"_249":250,"_251":26,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Branches1

Branches
1