[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_247":248,"_249":250},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":58,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","fu93799q7t6ffe43679vqsv78f24363tvv.ts","latestPath","fileId","5dba599c-d48a-11f0-a820-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 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 with system columns\n const insertStmt = conn.prepare(`\n INSERT INTO password_resets (email, code, _created_by, _created_at, expires_at)\n VALUES (?, ?, ?, ?, ?)\n `);\n \n await insertStmt.run([email, code, userUuid, 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}","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}","createdAt",["D",1765235516094],"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",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","kliv","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":243,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":244,"_80":245,"_82":246,"_84":25},"tree",[206,207,208,209,210,211,212,213,214],"files",[206,207,208,209,210,211,212,213,214],"counts",{"_196":62,"_197":138,"_198":62,"_199":200,"_201":202},"contents",[125,126,127,128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":190,"_32":191,"_30":56,"_135":-5,"_41":42,"_40":192,"_136":58,"_38":193,"_13":179,"_33":34,"_35":194,"_24":25,"_139":-5,"_27":195},{"_43":183,"_32":184,"_30":185,"_135":-5,"_41":42,"_40":186,"_136":58,"_38":187,"_13":62,"_33":34,"_35":188,"_24":25,"_139":-5,"_27":189},{"_43":176,"_32":177,"_30":178,"_135":-5,"_41":42,"_40":179,"_136":58,"_38":180,"_13":138,"_33":34,"_35":181,"_24":25,"_139":-5,"_27":182},{"_43":169,"_32":170,"_30":171,"_135":-5,"_41":42,"_40":172,"_136":58,"_38":173,"_13":62,"_33":34,"_35":174,"_24":25,"_139":-5,"_27":175},{"_43":162,"_32":163,"_30":164,"_135":-5,"_41":42,"_40":165,"_136":58,"_38":166,"_13":62,"_33":34,"_35":167,"_24":25,"_139":-5,"_27":168},{"_43":155,"_32":156,"_30":157,"_135":-5,"_41":42,"_40":158,"_136":58,"_38":159,"_13":138,"_33":34,"_35":160,"_24":25,"_139":-5,"_27":161},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":151,"_136":58,"_38":152,"_13":62,"_33":34,"_35":153,"_24":25,"_139":-5,"_27":154},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":145,"_13":62,"_33":34,"_35":146,"_24":25,"_139":-5,"_27":147},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":58,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":140},"4a5425b2-d48b-11f0-91c0-42dde27851f2","parentId","latest",["D",1765235516094],1,"label",[28],"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}",[142],"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}",[149],"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}",[156],"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",[163],"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}",[170],"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}",[177],"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}",[184],"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}",[191],"pulls","branches","forks","envVars",{"_203":62,"_205":62},"connections",{"_203":62,"_204":62},"count","unfilledCount","emptyCount",{"_43":190,"_32":191,"_30":56,"_135":-5,"_41":42,"_40":192,"_136":58,"_38":240,"_13":179,"_33":34,"_35":194,"_24":25,"_139":-5,"_216":241,"_27":242},{"_43":183,"_32":184,"_30":185,"_135":-5,"_41":42,"_40":186,"_136":58,"_38":237,"_13":62,"_33":34,"_35":188,"_24":25,"_139":-5,"_216":238,"_27":239},{"_43":176,"_32":177,"_30":178,"_135":-5,"_41":42,"_40":179,"_136":58,"_38":234,"_13":138,"_33":34,"_35":181,"_24":25,"_139":-5,"_216":235,"_27":236},{"_43":169,"_32":170,"_30":171,"_135":-5,"_41":42,"_40":172,"_136":58,"_38":231,"_13":62,"_33":34,"_35":174,"_24":25,"_139":-5,"_216":232,"_27":233},{"_43":162,"_32":163,"_30":164,"_135":-5,"_41":42,"_40":165,"_136":58,"_38":228,"_13":62,"_33":34,"_35":167,"_24":25,"_139":-5,"_216":229,"_27":230},{"_43":155,"_32":156,"_30":157,"_135":-5,"_41":42,"_40":158,"_136":58,"_38":225,"_13":138,"_33":34,"_35":160,"_24":25,"_139":-5,"_216":226,"_27":227},{"_43":148,"_32":149,"_30":150,"_135":-5,"_41":42,"_40":151,"_136":58,"_38":222,"_13":62,"_33":34,"_35":153,"_24":25,"_139":-5,"_216":223,"_27":224},{"_43":141,"_32":142,"_30":143,"_135":-5,"_41":42,"_40":144,"_136":58,"_38":219,"_13":62,"_33":34,"_35":146,"_24":25,"_139":-5,"_216":220,"_27":221},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":58,"_38":215,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_216":217,"_27":218},["D",1765235516094],"children",[],[28],["D",1764530527041],[],[142],["D",1764419980451],[],[149],["D",1763754347303],[],[156],["D",1764967936241],[],[163],["D",1763313465013],[],[170],["D",1763074703737],[],[177],["D",1764530509035],[],[184],["D",1763377606730],[],[191],["D",1763074415526],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":14,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_78":-5,"_122":280,"_281":282,"_283":284,"_285":25,"_286":25,"_287":25,"_288":58,"_289":-5,"_290":-7,"_291":-7,"_292":62,"_293":25,"_294":25,"_295":-5,"_296":25,"_297":25,"_298":25,"_299":-5},"ENV",{"_251":252,"_253":254,"_255":85,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279},"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 · v14