[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_231":232,"_233":234},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_88":-7,"_89":90,"_29":-7,"_91":-5,"_15":92,"_93":94,"_95":96,"_97":98,"_99":100,"_101":-5,"_102":-5,"_103":-5,"_104":38,"_105":106,"_107":49,"_108":-5,"_109":-5,"_110":111},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","kliv","name","tefev7tv28f31f418qs164tts72f816306","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":-5,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":49,"_51":-5,"_52":53,"_54":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":61,"_62":61,"_63":64,"_65":64,"_66":64,"_67":61,"_68":61,"_69":70,"_71":72,"_73":74,"_75":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","87e1fe8e-c349-11f0-aba0-42dde27851f2","createdAt",["D",1763338102820],"updatedAt",["D",1764654278299],"main","projectId","87e1b1b8-c349-11f0-aba0-42dde27851f2","version",10,"forkedBranchId","forkedBranchVersion","lockfileKey","1764654292224-esm.town_v_kliv_tefev7tv28f31f418qs164tts72f816306@10-main","deletedAt",["D",1763338102820],"legacyEnvVars",false,"privacy","public","httpPrivacy","description","imageUrl","userId","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",{"_11":12,"_87":83},"org",{"_11":12,"_81":-5,"_82":83,"_44":45,"_84":85,"_86":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_76":-5,"_77":-5,"_78":-5,"_79":14,"_80":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzMzeW9MdTZSSlZXdUFyNHFTckJtSlg1b3paYiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","path","","adoptOrgId",{"_20":28,"_13":14,"_22":227,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":-5,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":49,"_51":-5,"_52":53,"_54":55,"_56":-5,"_57":-5,"_58":-5,"_59":-5,"_60":61,"_62":61,"_63":64,"_65":64,"_66":64,"_67":61,"_68":61,"_69":228,"_71":229,"_73":230,"_75":38},"tree",[194,195,196,197,198,199,200,201],"files",[194,195,196,197,198,199,200,201],"counts",{"_185":53,"_17":130,"_186":53,"_187":188,"_189":190},"contents",[112,113,114,115,116,117,118,119],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_20":179,"_13":180,"_122":47,"_124":-5,"_125":21,"_126":181,"_128":49,"_22":182,"_29":130,"_131":132,"_133":183,"_135":38,"_136":-5,"_89":184},{"_20":172,"_13":173,"_122":174,"_124":-5,"_125":21,"_126":175,"_128":49,"_22":176,"_29":53,"_131":132,"_133":177,"_135":38,"_136":-5,"_89":178},{"_20":165,"_13":166,"_122":167,"_124":-5,"_125":21,"_126":168,"_128":49,"_22":169,"_29":53,"_131":132,"_133":170,"_135":38,"_136":-5,"_89":171},{"_20":158,"_13":159,"_122":160,"_124":-5,"_125":21,"_126":161,"_128":49,"_22":162,"_29":53,"_131":132,"_133":163,"_135":38,"_136":-5,"_89":164},{"_20":151,"_13":152,"_122":153,"_124":-5,"_125":21,"_126":154,"_128":49,"_22":155,"_29":53,"_131":132,"_133":156,"_135":38,"_136":-5,"_89":157},{"_20":145,"_13":146,"_122":147,"_124":-5,"_125":21,"_126":30,"_128":49,"_22":148,"_29":53,"_131":132,"_133":149,"_135":38,"_136":-5,"_89":150},{"_20":138,"_13":139,"_122":140,"_124":-5,"_125":21,"_126":141,"_128":49,"_22":142,"_29":53,"_131":132,"_133":143,"_135":38,"_136":-5,"_89":144},{"_20":120,"_13":121,"_122":123,"_124":-5,"_125":21,"_126":127,"_128":49,"_22":129,"_29":130,"_131":132,"_133":134,"_135":38,"_136":-5,"_89":137},"7a68ed98-c34f-11f0-836d-42dde27851f2","fuv97720e714ev49148te53078s5vv7q36.ts","fileId","87f1736e-c349-11f0-a49f-42dde27851f2","parentId","branchId","branchVersion",2,"latest",["D",1763340657191],1,"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 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}","deleted","label",[121],"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}",[139],"fd9a8fac-cf41-11f0-9e4b-42dde27851f2","fuq64f6sf0563643eqqv4f83e3se40577q.ts","fd9a9074-cf41-11f0-9e4b-42dde27851f2",["D",1764654278299],"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}",[146],"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}",[152],"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",[159],"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}",[166],"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}",[173],"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}",[180],"pulls","forks","envVars",{"_191":53,"_193":53},"connections",{"_191":53,"_192":53},"count","unfilledCount","emptyCount",{"_20":179,"_13":180,"_122":47,"_124":-5,"_125":21,"_126":181,"_128":49,"_22":224,"_29":130,"_131":132,"_133":183,"_135":38,"_136":-5,"_203":225,"_89":226},{"_20":172,"_13":173,"_122":174,"_124":-5,"_125":21,"_126":175,"_128":49,"_22":221,"_29":53,"_131":132,"_133":177,"_135":38,"_136":-5,"_203":222,"_89":223},{"_20":165,"_13":166,"_122":167,"_124":-5,"_125":21,"_126":168,"_128":49,"_22":218,"_29":53,"_131":132,"_133":170,"_135":38,"_136":-5,"_203":219,"_89":220},{"_20":158,"_13":159,"_122":160,"_124":-5,"_125":21,"_126":161,"_128":49,"_22":215,"_29":53,"_131":132,"_133":163,"_135":38,"_136":-5,"_203":216,"_89":217},{"_20":151,"_13":152,"_122":153,"_124":-5,"_125":21,"_126":154,"_128":49,"_22":212,"_29":53,"_131":132,"_133":156,"_135":38,"_136":-5,"_203":213,"_89":214},{"_20":145,"_13":146,"_122":147,"_124":-5,"_125":21,"_126":30,"_128":49,"_22":209,"_29":53,"_131":132,"_133":149,"_135":38,"_136":-5,"_203":210,"_89":211},{"_20":138,"_13":139,"_122":140,"_124":-5,"_125":21,"_126":141,"_128":49,"_22":206,"_29":53,"_131":132,"_133":143,"_135":38,"_136":-5,"_203":207,"_89":208},{"_20":120,"_13":121,"_122":123,"_124":-5,"_125":21,"_126":127,"_128":49,"_22":202,"_29":130,"_131":132,"_133":134,"_135":38,"_136":-5,"_203":204,"_89":205},["D",1763340657191],"children",[],[121],["D",1764649926072],[],[139],["D",1764654278299],[],[146],["D",1763340660622],[],[152],["D",1764648616243],[],[159],["D",1764654273356],[],[166],["D",1764649918720],[],[173],["D",1764651591438],[],[180],["D",1763338102820],{"_11":12,"_87":83},{"_11":12,"_81":-5,"_82":83,"_44":45,"_84":85,"_86":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_76":-5,"_77":-5,"_78":-5,"_79":14,"_80":12},"ctx",{"_69":-5,"_109":264,"_265":266,"_267":268,"_269":38,"_270":38,"_271":38,"_272":49,"_273":-5,"_274":-7,"_275":-7,"_276":53,"_277":38,"_278":38,"_279":-5,"_280":38,"_281":38,"_282":38,"_283":-5},"ENV",{"_235":236,"_237":238,"_239":26,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263},"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"]

Branches1

Branches
1