[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_233":234,"_235":236},"routes/_app.x.$handle.$name",{"_93":92,"_31":43,"_101":83,"_26":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":56,"_119":-5,"_120":-5,"_121":122},"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","fuq64f6sf0563643eqqv4f83e3se40577q.ts","latestPath","fileId","fd9a9074-cf41-11f0-9e4b-42dde27851f2","name","fileType","http","content","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: 'Authentication required' }, { status: 401 });\n }\n\n const squareToken = __secrets['SQUARE_ACCESS_TOKEN'];\n const squareLocationId = __secrets['SQUARE_LOCATION_ID'];\n const paypalClientId = __secrets['PAYPAL_CLIENT_ID'];\n const paypalSecret = __secrets['PAYPAL_SECRET'];\n\n return Response.json({\n square: {\n configured: Boolean(squareToken && squareLocationId),\n hasToken: Boolean(squareToken),\n hasLocation: Boolean(squareLocationId)\n },\n paypal: {\n configured: Boolean(paypalClientId && paypalSecret),\n hasClientId: Boolean(paypalClientId),\n hasSecret: Boolean(paypalSecret)\n }\n });\n}","createdAt",["D",1764654278299],"branchVersion","branchId","87e1fe8e-c349-11f0-aba0-42dde27851f2","id","87e1b1b8-c349-11f0-aba0-42dde27851f2","tefev7tv28f31f418qs164tts72f816306",["D",1763338102820],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","0199d9f9-8fb9-705d-a1be-150ee5ea0145","pinnedFileId","bcd7d6ac-cf3a-11f0-aba9-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",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":52,"_97":98,"_99":24},"branch",{"_13":14,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"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",{"_41":42,"_31":43,"_36":229,"_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":230,"_78":231,"_80":232,"_82":24},"tree",[196,197,198,199,200,201,202,203],"files",[196,197,198,199,200,201,202,203],"counts",{"_186":60,"_187":138,"_188":60,"_189":190,"_191":192},"contents",[123,124,125,126,127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":180,"_31":181,"_29":54,"_134":-5,"_39":40,"_38":182,"_136":56,"_36":183,"_13":138,"_32":33,"_34":184,"_23":24,"_140":-5,"_26":185},{"_41":173,"_31":174,"_29":175,"_134":-5,"_39":40,"_38":176,"_136":56,"_36":177,"_13":60,"_32":33,"_34":178,"_23":24,"_140":-5,"_26":179},{"_41":166,"_31":167,"_29":168,"_134":-5,"_39":40,"_38":169,"_136":56,"_36":170,"_13":60,"_32":33,"_34":171,"_23":24,"_140":-5,"_26":172},{"_41":159,"_31":160,"_29":161,"_134":-5,"_39":40,"_38":162,"_136":56,"_36":163,"_13":60,"_32":33,"_34":164,"_23":24,"_140":-5,"_26":165},{"_41":152,"_31":153,"_29":154,"_134":-5,"_39":40,"_38":155,"_136":56,"_36":156,"_13":60,"_32":33,"_34":157,"_23":24,"_140":-5,"_26":158},{"_41":149,"_31":27,"_29":30,"_134":-5,"_39":40,"_38":14,"_136":56,"_36":150,"_13":60,"_32":33,"_34":35,"_23":24,"_140":-5,"_26":151},{"_41":142,"_31":143,"_29":144,"_134":-5,"_39":40,"_38":145,"_136":56,"_36":146,"_13":60,"_32":33,"_34":147,"_23":24,"_140":-5,"_26":148},{"_41":131,"_31":132,"_29":133,"_134":-5,"_39":40,"_38":135,"_136":56,"_36":137,"_13":138,"_32":33,"_34":139,"_23":24,"_140":-5,"_26":141},"7a68ed98-c34f-11f0-836d-42dde27851f2","fuv97720e714ev49148te53078s5vv7q36.ts","87f1736e-c349-11f0-a49f-42dde27851f2","parentId",2,"latest",["D",1763340657191],1,"import { connect } from \"npm:@tursodatabase/serverless\";\n\nexport default async function(req: Request): Promise {\n // Read secrets from x-secrets header\n const __secrets = JSON.parse(req.headers.get('x-secrets') || '{}');\n\n try {\n const userUuid = req.headers.get(\"x-user-uuid\");\n const dbUrl = req.headers.get(\"x-database-url\");\n const dbToken = req.headers.get(\"x-database-token\");\n\n if (!userUuid) {\n return Response.json({ error: \"Not authenticated\" }, { status: 401 });\n }\n\n const conn = connect({\n url: dbUrl,\n authToken: dbToken\n });\n\n // Query kliv_users table\n const stmt = conn.prepare(`\n SELECT user_uuid, name, email, verified, metadata, _created_at, _updated_at\n FROM kliv_users \n WHERE _deleted = 0 \n ORDER BY name, email\n LIMIT 500\n `);\n \n const result = await stmt.all();\n\n // Parse metadata for each user\n const users = result.rows.map((user: any) => {\n let metadata = {};\n if (user.metadata) {\n try {\n metadata = JSON.parse(user.metadata);\n } catch (e) {\n console.error(\"Error parsing metadata:\", e);\n }\n }\n return {\n ...user,\n metadata\n };\n });\n\n return Response.json({\n users\n }, { status: 200 });\n } catch (error) {\n console.error(\"Error listing members:\", error);\n return Response.json({ \n error: \"Internal server error\",\n details: error.message \n }, { status: 500 });\n }\n}","label",[132],"db79643e-cf37-11f0-be1f-42dde27851f2","fus6222q2v1f104f1f9ssv56v5e58e7876.ts","db7964f2-cf37-11f0-be1f-42dde27851f2",6,["D",1764649926072],"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 // Validate required platform headers\n const userUuid = req.headers.get(\"x-user-uuid\");\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 const dbUrl = req.headers.get(\"x-database-url\");\n const dbToken = req.headers.get(\"x-database-token\");\n\n if (!userUuid) {\n return Response.json({ error: \"Unauthorized - user not authenticated\" }, { status: 401 });\n }\n if (!sdkUrl || !platformToken || !apiBaseUrl) {\n return Response.json({ error: \"Missing required platform headers\" }, { status: 400 });\n }\n if (!dbUrl || !dbToken) {\n return Response.json({ error: \"Missing required database headers\" }, { status: 400 });\n }\n\n // Get platform SDK\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(platformToken, apiBaseUrl);\n\n // Get database connection\n const conn = connect({ url: dbUrl, authToken: dbToken });\n\n try {\n const body = await req.json();\n \n // Validate required input fields\n if (!body || typeof body !== 'object') {\n return Response.json({ error: \"Invalid request body\" }, { status: 400 });\n }\n \n const testResultId = body.testResultId;\n const memberEmail = body.memberEmail;\n const memberName = body.memberName || 'Member';\n const testTitle = body.testTitle || 'Test';\n const score = typeof body.score === 'number' ? body.score : 0;\n const organizationName = body.organizationName || 'Your Chapter';\n\n if (!testResultId || !memberEmail) {\n return Response.json({ error: \"Missing required fields: testResultId, memberEmail\" }, { status: 400 });\n }\n\n // Verify the test result belongs to the authenticated user (access control)\n const checkStmt = conn.prepare(\n \"SELECT _row_id, member_uuid FROM test_results WHERE _row_id = ?\"\n );\n const resultRecord = await checkStmt.get([testResultId]);\n \n if (!resultRecord) {\n return Response.json({ error: \"Test result not found\" }, { status: 404 });\n }\n \n if (resultRecord.member_uuid !== userUuid) {\n return Response.json({ error: \"Unauthorized - not your test result\" }, { status: 403 });\n }\n\n // Generate certificate number\n const timestamp = Date.now();\n const randomPart = Math.random().toString(36).substr(2, 6).toUpperCase();\n const certificateNumber = `CERT-${timestamp}-${randomPart}`;\n const completionDate = new Date().toLocaleDateString('en-US', { \n year: 'numeric', \n month: 'long', \n day: 'numeric' \n });\n const updatedAt = Math.floor(Date.now() / 1000);\n\n // Update test result with certificate info (including _updated_at)\n const updateStmt = conn.prepare(\n \"UPDATE test_results SET certificate_issued = 1, certificate_number = ?, _updated_at = ? WHERE _row_id = ? AND member_uuid = ?\"\n );\n await updateStmt.run([certificateNumber, updatedAt, testResultId, userUuid]);\n\n // Send certificate email\n await platform.sendEmail({\n templateName: 'test_passed_certificate',\n recipientEmail: memberEmail,\n recipientName: memberName,\n customVariables: {\n memberName: memberName,\n testTitle: testTitle,\n score: Math.round(score).toString(),\n completionDate: completionDate,\n certificateNumber: certificateNumber,\n organizationName: organizationName\n }\n });\n\n await platform.log('info', 'Certificate email sent', { testTitle, certificateNumber });\n\n return Response.json({ \n success: true, \n certificateNumber,\n completionDate,\n message: 'Certificate issued and emailed'\n });\n } catch (error) {\n await platform.log('error', 'Certificate email failed', { error: String(error) });\n return Response.json({ error: \"Failed to issue certificate\" }, { status: 500 });\n }\n}",[143],"fd9a8fac-cf41-11f0-9e4b-42dde27851f2",["D",1764654278299],[27],"7c759d3e-c34f-11f0-bafe-42dde27851f2","fuf6sq467e2v1v4836qt8qq72eef4v1f76.ts","7c759df2-c34f-11f0-bafe-42dde27851f2",3,["D",1763340660622],"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 body = await req.json();\n const { user_uuid, name, title, service_hours_approver, approved } = body;\n\n const requestingUserUuid = req.headers.get(\"x-user-uuid\");\n\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 requesting user is admin or superadmin\n const requestingUserStmt = conn.prepare(\n \"SELECT metadata FROM kliv_users WHERE user_uuid = ? AND _deleted = 0\"\n );\n const requestingUser = await requestingUserStmt.get([requestingUserUuid]);\n\n let isAdmin = false;\n if (requestingUser?.metadata) {\n try {\n const metadata = JSON.parse(requestingUser.metadata as string);\n isAdmin = metadata.role === \"admin\" || metadata.role === \"superadmin\";\n } catch (e) {\n console.error(\"Error parsing requesting user metadata:\", e);\n }\n }\n\n // Only admins and superadmins can update profiles\n if (!isAdmin) {\n return Response.json(\n { error: \"Only admins can update member profiles\" },\n { status: 403 }\n );\n }\n\n if (!user_uuid || !name) {\n return Response.json(\n { error: \"user_uuid and name are required\" },\n { status: 400 }\n );\n }\n\n // Get current user data\n const userStmt = conn.prepare(\n \"SELECT metadata FROM kliv_users WHERE user_uuid = ? AND _deleted = 0\"\n );\n const user = await userStmt.get([user_uuid]);\n\n if (!user) {\n return Response.json({ error: \"User not found\" }, { status: 404 });\n }\n\n // Parse existing metadata\n let currentMetadata = {};\n try {\n if (user.metadata) {\n currentMetadata = JSON.parse(user.metadata as string);\n }\n } catch (e) {\n console.error(\"Error parsing metadata:\", e);\n currentMetadata = {};\n }\n\n // Build updated metadata\n const updatedMetadata = { ...currentMetadata };\n\n // Update title\n if (title !== undefined) {\n if (title && title.trim()) {\n updatedMetadata.title = title.trim();\n } else {\n delete updatedMetadata.title;\n }\n }\n\n // Update service hours approver (super admin only)\n if (service_hours_approver !== undefined) {\n // Check if requesting user is superadmin\n const isSuperAdmin = requestingUser?.metadata && \n JSON.parse(requestingUser.metadata as string).role === \"superadmin\";\n \n if (isSuperAdmin) {\n if (service_hours_approver && service_hours_approver.trim()) {\n updatedMetadata.service_hours_approver = service_hours_approver.trim();\n } else {\n delete updatedMetadata.service_hours_approver;\n }\n }\n }\n\n // Update approval status (super admin only)\n if (approved !== undefined) {\n // Check if requesting user is superadmin\n const isSuperAdmin = requestingUser?.metadata && \n JSON.parse(requestingUser.metadata as string).role === \"superadmin\";\n \n if (isSuperAdmin) {\n if (approved === true) {\n updatedMetadata.approved = true;\n } else if (approved === \"rejected\") {\n updatedMetadata.approved = \"rejected\";\n } else {\n updatedMetadata.approved = false;\n }\n }\n }\n\n // Update user\n const updateStmt = conn.prepare(\n \"UPDATE kliv_users SET name = ?, metadata = ? WHERE user_uuid = ?\"\n );\n await updateStmt.run([name, JSON.stringify(updatedMetadata), user_uuid]);\n\n console.log(`Profile updated for user ${user_uuid}:`, {\n name,\n title,\n service_hours_approver,\n approved,\n });\n\n return Response.json(\n {\n success: true,\n user_uuid,\n name,\n title,\n service_hours_approver,\n approved,\n },\n { status: 200 }\n );\n } catch (error) {\n console.error(\"Error updating profile:\", error);\n return Response.json(\n { error: \"Internal server error\", details: error.message },\n { status: 500 }\n );\n }\n}",[153],"cec11a1e-cf34-11f0-b535-42dde27851f2","fuf0tes1q416fs409795t6263eq74203sq.ts","cec11ad2-cf34-11f0-b535-42dde27851f2",4,["D",1764648616243],"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 // Square sends webhooks as POST\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 eventType = body.type;\n\n // Log webhook receipt\n console.log(\"Square webhook received:\", eventType);\n\n // Handle payment completed\n if (eventType === \"payment.completed\" || eventType === \"order.fulfillment.updated\") {\n const payment = body.data?.object;\n const note = payment?.note || \"\";\n \n // Extract charge IDs from payment note\n const chargeMatch = note.match(/Charge IDs: ([\\d,]+)/);\n if (chargeMatch) {\n const chargeIds = chargeMatch[1].split(\",\").map((id: string) => parseInt(id.trim()));\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 // Mark charges as paid\n const now = Math.floor(Date.now() / 1000);\n for (const chargeId of chargeIds) {\n const stmt = conn.prepare(\n \"UPDATE member_charges SET status = 'paid', _updated_at = ? WHERE _row_id = ?\"\n );\n await stmt.run([now, chargeId]);\n }\n\n // Record payment\n const insertStmt = conn.prepare(\n `INSERT INTO payments (charge_id, member_uuid, amount, payment_method, notes, _created_at, _updated_at)\n VALUES (?, ?, ?, 'square', ?, ?, ?)`\n );\n await insertStmt.run([\n chargeIds[0],\n payment.customer_id || \"webhook\",\n (payment.amount_money?.amount || 0) / 100,\n `Square Payment ID: ${payment.id}`,\n now,\n now\n ]);\n\n console.log(\"Marked charges as paid:\", chargeIds);\n }\n }\n\n return Response.json({ received: true });\n } catch (error) {\n console.error(\"Webhook error:\", error);\n return Response.json({ error: \"Webhook processing failed\" }, { status: 500 });\n }\n}\n",[160],"faa7e8d0-cf41-11f0-8feb-42dde27851f2","fu9eqeq1966q354tst999253092s860142.ts","faa7e9a2-cf41-11f0-8feb-42dde27851f2",9,["D",1764654273356],"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: 'Authentication required' }, { status: 401 });\n }\n\n let body;\n try {\n body = await req.json();\n } catch {\n return Response.json({ error: 'Invalid JSON' }, { status: 400 });\n }\n\n const { chargeId, amount, description, provider } = body;\n \n if (!chargeId || !amount || !provider) {\n return Response.json({ error: 'Missing required fields' }, { status: 400 });\n }\n\n // Check which payment provider to use\n if (provider === 'square') {\n const squareToken = __secrets['SQUARE_ACCESS_TOKEN'];\n const squareLocationId = __secrets['SQUARE_LOCATION_ID'];\n \n if (!squareToken || !squareLocationId) {\n return Response.json({ \n error: 'Square not configured',\n configured: false \n }, { status: 400 });\n }\n\n // Create Square checkout link\n const squareResponse = await fetch('https://connect.squareup.com/v2/online-checkout/payment-links', {\n method: 'POST',\n headers: {\n 'Square-Version': '2024-01-18',\n 'Authorization': `Bearer ${squareToken}`,\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({\n idempotency_key: `charge-${chargeId}-${Date.now()}`,\n quick_pay: {\n name: description || 'Chapter Dues',\n price_money: {\n amount: Math.round(amount * 100),\n currency: 'USD'\n },\n location_id: squareLocationId\n },\n checkout_options: {\n redirect_url: `${req.headers.get('origin') || ''}/dashboard?payment=success&charge=${chargeId}`\n },\n pre_populated_data: {\n buyer_email: req.headers.get('x-user-email') || undefined\n }\n })\n });\n\n if (!squareResponse.ok) {\n const errorData = await squareResponse.text();\n console.error('Square API error:', errorData);\n return Response.json({ error: 'Failed to create payment link' }, { status: 500 });\n }\n\n const data = await squareResponse.json();\n return Response.json({ \n success: true,\n paymentUrl: data.payment_link?.url,\n provider: 'square'\n });\n }\n\n if (provider === 'paypal') {\n const paypalClientId = __secrets['PAYPAL_CLIENT_ID'];\n const paypalSecret = __secrets['PAYPAL_SECRET'];\n \n if (!paypalClientId || !paypalSecret) {\n return Response.json({ \n error: 'PayPal not configured',\n configured: false \n }, { status: 400 });\n }\n\n // Get PayPal access token\n const authResponse = await fetch('https://api-m.paypal.com/v1/oauth2/token', {\n method: 'POST',\n headers: {\n 'Authorization': `Basic ${btoa(`${paypalClientId}:${paypalSecret}`)}`,\n 'Content-Type': 'application/x-www-form-urlencoded'\n },\n body: 'grant_type=client_credentials'\n });\n\n if (!authResponse.ok) {\n console.error('PayPal auth error');\n return Response.json({ error: 'PayPal authentication failed' }, { status: 500 });\n }\n\n const authData = await authResponse.json();\n const accessToken = authData.access_token;\n\n // Create PayPal order\n const orderResponse = await fetch('https://api-m.paypal.com/v2/checkout/orders', {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify({\n intent: 'CAPTURE',\n purchase_units: [{\n reference_id: `charge-${chargeId}`,\n description: description || 'Chapter Dues',\n amount: {\n currency_code: 'USD',\n value: amount.toFixed(2)\n }\n }],\n application_context: {\n return_url: `${req.headers.get('origin') || ''}/dashboard?payment=success&charge=${chargeId}`,\n cancel_url: `${req.headers.get('origin') || ''}/dashboard?payment=cancelled`\n }\n })\n });\n\n if (!orderResponse.ok) {\n const errorData = await orderResponse.text();\n console.error('PayPal order error:', errorData);\n return Response.json({ error: 'Failed to create PayPal order' }, { status: 500 });\n }\n\n const orderData = await orderResponse.json();\n const approvalLink = orderData.links?.find((l: { rel: string }) => l.rel === 'approve');\n \n return Response.json({ \n success: true,\n paymentUrl: approvalLink?.href,\n orderId: orderData.id,\n provider: 'paypal'\n });\n }\n\n return Response.json({ error: 'Invalid payment provider' }, { status: 400 });\n}",[167],"d7178d94-cf37-11f0-81cc-42dde27851f2","fu594q3s862t944fvf83904v258sve68s2.ts","d7178e48-cf37-11f0-81cc-42dde27851f2",5,["D",1764649918720],"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 // Validate required platform headers\n const userUuid = req.headers.get(\"x-user-uuid\");\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 const dbUrl = req.headers.get(\"x-database-url\");\n const dbToken = req.headers.get(\"x-database-token\");\n\n if (!userUuid) {\n return Response.json({ error: \"Unauthorized - user not authenticated\" }, { status: 401 });\n }\n if (!sdkUrl || !platformToken || !apiBaseUrl) {\n return Response.json({ error: \"Missing required platform headers\" }, { status: 400 });\n }\n if (!dbUrl || !dbToken) {\n return Response.json({ error: \"Missing required database headers\" }, { status: 400 });\n }\n\n // Get platform SDK\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(platformToken, apiBaseUrl);\n\n // Get database connection\n const conn = connect({ url: dbUrl, authToken: dbToken });\n\n try {\n const body = await req.json();\n \n // Validate required input fields\n if (!body || typeof body !== 'object') {\n return Response.json({ error: \"Invalid request body\" }, { status: 400 });\n }\n \n const resourceTitle = body.resourceTitle || 'New Resource';\n const resourceDescription = body.resourceDescription || 'A new resource has been added.';\n const resourceType = body.resourceType || 'document';\n const resourceCategory = body.resourceCategory || 'General';\n const organizationName = body.organizationName || 'Your Chapter';\n\n await platform.log('info', 'Sending workshop notifications', { resourceTitle });\n\n // Get all members to notify - query member_charges for unique members\n const memberStmt = conn.prepare(\n \"SELECT DISTINCT member_uuid, member_email, member_name FROM member_charges WHERE member_uuid IS NOT NULL\"\n );\n const members = await memberStmt.all([]);\n\n let sentCount = 0;\n let errorCount = 0;\n\n // Process in batches to avoid timeout\n const batchSize = 10;\n for (let i = 0; i < members.length; i += batchSize) {\n const batch = members.slice(i, i + batchSize);\n \n for (const member of batch) {\n try {\n const memberName = member.member_name || 'Member';\n await platform.sendEmail({\n templateName: 'workshop_resource_added',\n recipientEmail: member.member_email,\n recipientName: memberName,\n customVariables: {\n memberName: memberName,\n resourceTitle: resourceTitle,\n resourceDescription: resourceDescription,\n resourceType: resourceType,\n resourceCategory: resourceCategory,\n organizationName: organizationName\n }\n });\n sentCount++;\n } catch (err) {\n await platform.log('error', 'Failed to send notification to member', { error: String(err) });\n errorCount++;\n }\n }\n }\n\n await platform.log('info', 'Workshop notifications complete', { sentCount, errorCount });\n\n return Response.json({ \n success: true, \n sentCount,\n errorCount,\n message: `Notifications sent to ${sentCount} member(s)`\n });\n } catch (error) {\n await platform.log('error', 'Workshop notification failed', { error: String(error) });\n return Response.json({ error: \"Failed to send notifications\" }, { status: 500 });\n }\n}",[174],"bc212c62-cf3b-11f0-821c-42dde27851f2","fu50e6q8ese0eq4208q47effv99913v05e.ts",8,["D",1764651591438],"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 // Verify required headers\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 const userUuid = req.headers.get(\"x-user-uuid\");\n\n if (!sdkUrl || !platformToken || !apiBaseUrl) {\n return Response.json({ error: 'Missing required platform headers' }, { status: 401 });\n }\n\n if (!userUuid) {\n return Response.json({ error: 'Authentication required' }, { status: 401 });\n }\n\n // Import platform SDK for logging\n const { PlatformClient } = await import(sdkUrl);\n const platform = new PlatformClient(platformToken, apiBaseUrl);\n\n // Get rich context to verify admin status\n const context = await platform.getRichContext();\n \n // Check if user is from primary org (admin)\n if (!context.organization?.isPrimary) {\n await platform.log('warn', 'Non-admin attempted to access member list', { \n userUuid, \n orgUuid: context.organization?.uuid \n });\n return Response.json({ error: 'Admin access required' }, { status: 403 });\n }\n\n await platform.log('info', 'Admin fetching member list', { adminUuid: userUuid });\n\n // Use platform API to list users\n const response = await fetch(`${apiBaseUrl}/users?limit=100`, {\n headers: {\n 'Authorization': `Bearer ${platformToken}`,\n 'Content-Type': 'application/json'\n }\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n await platform.log('error', 'Failed to fetch users from platform API', { \n status: response.status, \n error: errorText \n });\n return Response.json({ error: 'Failed to fetch members' }, { status: 500 });\n }\n\n const usersData = await response.json();\n \n // Also fetch groups to identify admins\n const groupsResponse = await fetch(`${apiBaseUrl}/groups`, {\n headers: {\n 'Authorization': `Bearer ${platformToken}`,\n 'Content-Type': 'application/json'\n }\n });\n\n let adminGroupUuid = '';\n if (groupsResponse.ok) {\n const groupsData = await groupsResponse.json();\n const adminGroup = (groupsData.data || []).find((g: { name: string }) => g.name === 'Administrators');\n if (adminGroup) {\n adminGroupUuid = adminGroup.uuid;\n }\n }\n\n // Transform to expected format with admin status\n const members = (usersData.users || []).map((user: { \n uuid: string; \n email: string; \n firstName?: string; \n lastName?: string; \n enabled: boolean;\n groups?: Array<{ uuid: string; name: string }>;\n }) => {\n const isAdmin = user.groups?.some((g: { uuid: string; name: string }) => \n g.name === 'Administrators' || g.uuid === adminGroupUuid\n ) || false;\n \n return {\n userUuid: user.uuid,\n email: user.email,\n firstName: user.firstName,\n lastName: user.lastName,\n enabled: user.enabled,\n isAdmin,\n groups: user.groups || []\n };\n });\n\n await platform.log('info', 'Member list retrieved successfully', { \n count: members.length,\n adminGroupUuid \n });\n\n return Response.json({ members, total: members.length, adminGroupUuid });\n}",[181],"pulls","branches","forks","envVars",{"_193":60,"_195":60},"connections",{"_193":60,"_194":60},"count","unfilledCount","emptyCount",{"_41":180,"_31":181,"_29":54,"_134":-5,"_39":40,"_38":182,"_136":56,"_36":226,"_13":138,"_32":33,"_34":184,"_23":24,"_140":-5,"_205":227,"_26":228},{"_41":173,"_31":174,"_29":175,"_134":-5,"_39":40,"_38":176,"_136":56,"_36":223,"_13":60,"_32":33,"_34":178,"_23":24,"_140":-5,"_205":224,"_26":225},{"_41":166,"_31":167,"_29":168,"_134":-5,"_39":40,"_38":169,"_136":56,"_36":220,"_13":60,"_32":33,"_34":171,"_23":24,"_140":-5,"_205":221,"_26":222},{"_41":159,"_31":160,"_29":161,"_134":-5,"_39":40,"_38":162,"_136":56,"_36":217,"_13":60,"_32":33,"_34":164,"_23":24,"_140":-5,"_205":218,"_26":219},{"_41":152,"_31":153,"_29":154,"_134":-5,"_39":40,"_38":155,"_136":56,"_36":214,"_13":60,"_32":33,"_34":157,"_23":24,"_140":-5,"_205":215,"_26":216},{"_41":149,"_31":27,"_29":30,"_134":-5,"_39":40,"_38":14,"_136":56,"_36":211,"_13":60,"_32":33,"_34":35,"_23":24,"_140":-5,"_205":212,"_26":213},{"_41":142,"_31":143,"_29":144,"_134":-5,"_39":40,"_38":145,"_136":56,"_36":208,"_13":60,"_32":33,"_34":147,"_23":24,"_140":-5,"_205":209,"_26":210},{"_41":131,"_31":132,"_29":133,"_134":-5,"_39":40,"_38":135,"_136":56,"_36":204,"_13":138,"_32":33,"_34":139,"_23":24,"_140":-5,"_205":206,"_26":207},["D",1763340657191],"children",[],[132],["D",1764649926072],[],[143],["D",1764654278299],[],[27],["D",1763340660622],[],[153],["D",1764648616243],[],[160],["D",1764654273356],[],[167],["D",1764649918720],[],[174],["D",1764651591438],[],[181],["D",1763338102820],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":52,"_97":98,"_99":24},{"_13":14,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"ctx",{"_76":-5,"_120":266,"_267":268,"_269":270,"_271":24,"_272":24,"_273":24,"_274":56,"_275":-5,"_276":-7,"_277":-7,"_278":60,"_279":24,"_280":24,"_281":-5,"_282":24,"_283":24,"_284":24,"_285":-5},"ENV",{"_237":238,"_239":240,"_241":83,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265},"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 · v10