[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_210":211,"_212":213},"routes/_app.x.$handle.$name",{"_94":93,"_31":43,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":56,"_120":-5,"_121":-5,"_122":123},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","fu1e18e17v041e4te593581s42471384t9.ts","latestPath","fileId","d1613eb6-ce21-11f0-bf8b-42dde27851f2","name","fileType","http","content","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}","createdAt",["D",1764530509035],"branchVersion","branchId","96027286-c0e3-11f0-9dcb-42dde27851f2","id","9601f5c2-c0e3-11f0-9dcb-42dde27851f2","te9e6sv4vt78104s9f9f7te24957s8v7v5",["D",1763074415526],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","334fb8a4-c310-11f0-b5eb-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0199d9f9-8fb9-705d-a1be-18ed6d1d02d7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kliv","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":206,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":-5,"_51":-5,"_18":52,"_53":54,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":207,"_78":208,"_80":209,"_82":24},"tree",[181,182,183,184,185,186],"files",[181,182,183,184,185,186],"counts",{"_171":60,"_172":145,"_173":60,"_174":175,"_176":177},"contents",[124,125,126,127,128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":165,"_31":166,"_29":54,"_133":-5,"_39":40,"_38":167,"_135":56,"_36":168,"_13":158,"_32":33,"_34":169,"_23":24,"_138":-5,"_26":170},{"_41":162,"_31":27,"_29":30,"_133":-5,"_39":40,"_38":14,"_135":56,"_36":163,"_13":60,"_32":33,"_34":35,"_23":24,"_138":-5,"_26":164},{"_41":155,"_31":156,"_29":157,"_133":-5,"_39":40,"_38":158,"_135":56,"_36":159,"_13":145,"_32":33,"_34":160,"_23":24,"_138":-5,"_26":161},{"_41":148,"_31":149,"_29":150,"_133":-5,"_39":40,"_38":151,"_135":56,"_36":152,"_13":60,"_32":33,"_34":153,"_23":24,"_138":-5,"_26":154},{"_41":140,"_31":141,"_29":142,"_133":-5,"_39":40,"_38":143,"_135":56,"_36":144,"_13":145,"_32":33,"_34":146,"_23":24,"_138":-5,"_26":147},{"_41":130,"_31":131,"_29":132,"_133":-5,"_39":40,"_38":134,"_135":56,"_36":136,"_13":60,"_32":33,"_34":137,"_23":24,"_138":-5,"_26":139},"7933dbc4-cd20-11f0-9172-42dde27851f2","fu7672637qe20245678082fq48f3qt3f1s.ts","7933dd04-cd20-11f0-9172-42dde27851f2","parentId",9,"latest",["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}","label",[131],"aceed5ea-c712-11f0-9cd4-42dde27851f2","fu59ee3v36s12q4260970tq1qt790q03tf.ts","02f188a8-c703-11f0-8db5-42dde27851f2",8,["D",1763754347303],1,"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}",[141],"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}",[149],"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}",[156],"d1613dee-ce21-11f0-bf8b-42dde27851f2",["D",1764530509035],[27],"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}",[166],"pulls","branches","forks","envVars",{"_178":60,"_180":60},"connections",{"_178":60,"_179":60},"count","unfilledCount","emptyCount",{"_41":165,"_31":166,"_29":54,"_133":-5,"_39":40,"_38":167,"_135":56,"_36":203,"_13":158,"_32":33,"_34":169,"_23":24,"_138":-5,"_188":204,"_26":205},{"_41":162,"_31":27,"_29":30,"_133":-5,"_39":40,"_38":14,"_135":56,"_36":200,"_13":60,"_32":33,"_34":35,"_23":24,"_138":-5,"_188":201,"_26":202},{"_41":155,"_31":156,"_29":157,"_133":-5,"_39":40,"_38":158,"_135":56,"_36":197,"_13":145,"_32":33,"_34":160,"_23":24,"_138":-5,"_188":198,"_26":199},{"_41":148,"_31":149,"_29":150,"_133":-5,"_39":40,"_38":151,"_135":56,"_36":194,"_13":60,"_32":33,"_34":153,"_23":24,"_138":-5,"_188":195,"_26":196},{"_41":140,"_31":141,"_29":142,"_133":-5,"_39":40,"_38":143,"_135":56,"_36":191,"_13":145,"_32":33,"_34":146,"_23":24,"_138":-5,"_188":192,"_26":193},{"_41":130,"_31":131,"_29":132,"_133":-5,"_39":40,"_38":134,"_135":56,"_36":187,"_13":60,"_32":33,"_34":137,"_23":24,"_138":-5,"_188":189,"_26":190},["D",1764419980451],"children",[],[131],["D",1763754347303],[],[141],["D",1763313465013],[],[149],["D",1763074703737],[],[156],["D",1764530509035],[],[27],["D",1763377606730],[],[166],["D",1763074415526],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":52,"_98":99,"_100":24},{"_13":83,"_31":84,"_41":40,"_85":42,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":43,"_92":93},"ctx",{"_76":-5,"_121":243,"_244":245,"_246":247,"_248":24,"_249":24,"_250":24,"_251":56,"_252":-5,"_253":-7,"_254":-7,"_255":60,"_256":24,"_257":24,"_258":-5,"_259":24,"_260":24,"_261":24,"_262":-5},"ENV",{"_214":215,"_216":217,"_218":84,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242},"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"]

Diff · v10