[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_234":235,"_236":237},"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",12,"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","fu568f52e3qvf34f069se076e873s8s1q8.ts","latestPath","fileId","484e1820-d21c-11f0-bbde-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 // 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","createdAt",["D",1764967936241],"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":230,"_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":231,"_78":232,"_80":233,"_82":24},"tree",[197,198,199,200,201,202,203,204],"files",[197,198,199,200,201,202,203,204],"counts",{"_187":60,"_188":154,"_189":60,"_190":191,"_192":193},"contents",[124,125,126,127,128,129,130,131],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":181,"_31":182,"_29":54,"_135":-5,"_39":40,"_38":183,"_137":56,"_36":184,"_13":170,"_32":33,"_34":185,"_23":24,"_140":-5,"_26":186},{"_41":174,"_31":175,"_29":176,"_135":-5,"_39":40,"_38":177,"_137":56,"_36":178,"_13":60,"_32":33,"_34":179,"_23":24,"_140":-5,"_26":180},{"_41":167,"_31":168,"_29":169,"_135":-5,"_39":40,"_38":170,"_137":56,"_36":171,"_13":154,"_32":33,"_34":172,"_23":24,"_140":-5,"_26":173},{"_41":160,"_31":161,"_29":162,"_135":-5,"_39":40,"_38":163,"_137":56,"_36":164,"_13":60,"_32":33,"_34":165,"_23":24,"_140":-5,"_26":166},{"_41":157,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":56,"_36":158,"_13":60,"_32":33,"_34":35,"_23":24,"_140":-5,"_26":159},{"_41":149,"_31":150,"_29":151,"_135":-5,"_39":40,"_38":152,"_137":56,"_36":153,"_13":154,"_32":33,"_34":155,"_23":24,"_140":-5,"_26":156},{"_41":142,"_31":143,"_29":144,"_135":-5,"_39":40,"_38":145,"_137":56,"_36":146,"_13":60,"_32":33,"_34":147,"_23":24,"_140":-5,"_26":148},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":56,"_36":138,"_13":60,"_32":33,"_34":139,"_23":24,"_140":-5,"_26":141},"dc1a8f38-ce21-11f0-ab66-42dde27851f2","fu881v69qvt2t943118t91e0e4v2fsq297.ts","dc1a8fec-ce21-11f0-ab66-42dde27851f2","parentId",11,"latest",["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}","label",[133],"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}",[143],"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}",[150],"484e174e-d21c-11f0-bbde-42dde27851f2",["D",1764967936241],[27],"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}",[161],"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}",[168],"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}",[175],"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}",[182],"pulls","branches","forks","envVars",{"_194":60,"_196":60},"connections",{"_194":60,"_195":60},"count","unfilledCount","emptyCount",{"_41":181,"_31":182,"_29":54,"_135":-5,"_39":40,"_38":183,"_137":56,"_36":227,"_13":170,"_32":33,"_34":185,"_23":24,"_140":-5,"_206":228,"_26":229},{"_41":174,"_31":175,"_29":176,"_135":-5,"_39":40,"_38":177,"_137":56,"_36":224,"_13":60,"_32":33,"_34":179,"_23":24,"_140":-5,"_206":225,"_26":226},{"_41":167,"_31":168,"_29":169,"_135":-5,"_39":40,"_38":170,"_137":56,"_36":221,"_13":154,"_32":33,"_34":172,"_23":24,"_140":-5,"_206":222,"_26":223},{"_41":160,"_31":161,"_29":162,"_135":-5,"_39":40,"_38":163,"_137":56,"_36":218,"_13":60,"_32":33,"_34":165,"_23":24,"_140":-5,"_206":219,"_26":220},{"_41":157,"_31":27,"_29":30,"_135":-5,"_39":40,"_38":14,"_137":56,"_36":215,"_13":60,"_32":33,"_34":35,"_23":24,"_140":-5,"_206":216,"_26":217},{"_41":149,"_31":150,"_29":151,"_135":-5,"_39":40,"_38":152,"_137":56,"_36":212,"_13":154,"_32":33,"_34":155,"_23":24,"_140":-5,"_206":213,"_26":214},{"_41":142,"_31":143,"_29":144,"_135":-5,"_39":40,"_38":145,"_137":56,"_36":209,"_13":60,"_32":33,"_34":147,"_23":24,"_140":-5,"_206":210,"_26":211},{"_41":132,"_31":133,"_29":134,"_135":-5,"_39":40,"_38":136,"_137":56,"_36":205,"_13":60,"_32":33,"_34":139,"_23":24,"_140":-5,"_206":207,"_26":208},["D",1764530527041],"children",[],[133],["D",1764419980451],[],[143],["D",1763754347303],[],[150],["D",1764967936241],[],[27],["D",1763313465013],[],[161],["D",1763074703737],[],[168],["D",1764530509035],[],[175],["D",1763377606730],[],[182],["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":267,"_268":269,"_270":271,"_272":24,"_273":24,"_274":24,"_275":56,"_276":-5,"_277":-7,"_278":-7,"_279":60,"_280":24,"_281":24,"_282":-5,"_283":24,"_284":24,"_285":24,"_286":-5},"ENV",{"_238":239,"_240":241,"_242":84,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · v12