[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_199":200,"_201":202},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_17":18,"_39":-7,"_130":-5,"_19":131,"_132":133,"_134":135,"_136":137,"_138":139,"_21":140,"_141":-5,"_142":-5,"_143":24,"_144":145,"_146":91,"_147":-5,"_148":-5,"_149":150},"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":24,"_25":26,"_27":28,"_29":24,"_30":-5},"handle","arjunmavai","name","google-arjun-portfolio","branchName","main","path","new-file-7739.ts","project",{"_33":78,"_13":14,"_37":79,"_80":-5,"_81":24,"_82":83,"_84":83,"_85":86,"_87":-5,"_30":67,"_88":89,"_90":91,"_92":-5,"_93":-5,"_94":26,"_41":42,"_95":96,"_97":98,"_99":100,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_52":111,"_112":113,"_114":115,"_116":24},"file",{"_62":63,"_13":18,"_64":65,"_66":24,"_77":-5},"isDirectory",false,"page",0,"history",[31,32],"hasNext","userId",{"_33":70,"_35":36,"_37":71,"_39":72,"_41":42,"_43":34,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":73,"_21":74,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":75},{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_21":54,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60},"id","7b163dbf-704b-417f-9955-55ffc7ccca35","branchId","d3766096-94c8-48e1-8b92-1ccffd41fef3","createdAt",["D",1788108958992],"version",8,"orgId","019b1e36-b929-7358-a682-22975330638b","parentId","869f5501-7d7a-4af9-8a27-a40b9f44cb9e","incomingCommitId","aiChatMessageId","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle","source","clientLabel","user",{"_33":67,"_41":42,"_11":12,"_68":69},{"_62":63,"_13":18,"_64":65,"_66":24},"pull","merge","revert","multiple","commits",[61],{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":53,"_21":54,"_55":-5,"_56":-5,"_57":-5},"fileId","acb7ef3a-a493-11f1-b9f9-1607ee4eb77e","fileType","script","deleted","019b1e36-b928-764a-bdc9-a49f1ce8eec0","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zNnFlSTlQZmdYdjlLS09Lc0JwNDlSSm10OEUifQ","34a45899-33f9-45d4-8092-4c7911c2df72",["D",1788108965181],9,{"_33":67,"_41":42,"_11":12,"_68":69},{"_62":63,"_13":18,"_64":65,"_66":24},[76],{"_33":70,"_35":36,"_37":71,"_39":72,"_41":42,"_43":34,"_45":-5,"_46":-5,"_47":-5,"_48":-5,"_49":-5,"_50":-5,"_51":-5,"_52":73,"_21":74,"_55":-5,"_56":-5,"_57":-5},"deletedAtVersion","1237ce6d-0111-43cf-932f-86ceaedaed89",["D",1788106459861],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description"," saving portfolio form data in google sheet tg notif","imageUrl","pinnedFileId","27a9de5c-a48e-11f1-80ef-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","tursoName","1237ce6d011143cf932f86ceaedaed89","tursoHostname","1237ce6d011143cf932f86ceaedaed89-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789497078049],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_11":12,"_129":69},"org",{"_11":12,"_125":-5,"_68":69,"_30":67,"_126":127,"_128":24},"branch",{"_39":72,"_13":16,"_33":36,"_117":78,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":78,"_13":14,"_37":194,"_80":-5,"_81":24,"_82":83,"_84":83,"_85":86,"_87":-5,"_30":67,"_88":89,"_90":91,"_92":-5,"_93":-5,"_94":26,"_41":42,"_95":96,"_97":98,"_99":195,"_101":-5,"_102":103,"_104":103,"_105":106,"_107":106,"_108":106,"_109":103,"_110":103,"_52":196,"_112":197,"_114":198,"_116":24},"tree",[170,171,172],"files",[170,171,172],"counts",{"_160":26,"_161":155,"_162":26,"_163":164,"_165":166},"contents",[],{"_33":151,"_13":18,"_62":63,"_43":-5,"_35":36,"_152":72,"_153":91,"_37":154,"_39":155,"_64":65,"_156":157,"_66":24,"_158":-5,"_17":159},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},"e855bc43-52cf-4121-89a0-bb9d4b0935ea","branchVersion","latest",["D",1788108965181],1,"content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Naya data sabse upar dekhne ke liye ORDER BY DESC lagaya hai\nconst data = await sqlite.execute(\n \"SELECT * FROM portfolio_messages ORDER BY created_at DESC\",\n);\n\n// Ye console me saara data print kar dega\nconsole.log(data.rows);","label",[18],"pulls","branches","forks","envVars",{"_167":26,"_169":26},"connections",{"_167":26,"_168":26},"count","unfilledCount","emptyCount",{"_33":186,"_13":187,"_62":188,"_43":-5,"_35":36,"_152":189,"_153":91,"_37":190,"_39":155,"_64":65,"_156":191,"_66":24,"_158":-5,"_174":192,"_17":193},{"_33":177,"_13":178,"_62":89,"_43":-5,"_35":36,"_152":179,"_153":91,"_37":180,"_39":181,"_64":182,"_156":183,"_66":24,"_158":-5,"_174":184,"_17":185},{"_33":151,"_13":18,"_62":63,"_43":-5,"_35":36,"_152":72,"_153":91,"_37":173,"_39":155,"_64":65,"_156":157,"_66":24,"_158":-5,"_174":175,"_17":176},["D",1788108965181],"children",[],[18],"d564382e-5f01-4f52-b981-8448546a0d1f","new-file-2412.ts",7,["D",1788108157425],4,"http","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function (req: Request) {\n // 1. CORS Handle\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Only POST method allowed\", { status: 405 });\n }\n\n try {\n const body = await req.json();\n console.log(\"✅ 1. Received Payload:\", body);\n \n const name = body.name || \"N/A\";\n const email = body.email || \"N/A\";\n const phone = body.phone || body.mobile || \"N/A\";\n const type = body.type || body.category || body.inquiryType || \"N/A\";\n const message = body.message || \"No message provided.\";\n\n // --- STEP 1: SAVE TO VAL TOWN BUILT-IN SQLITE ---\n console.log(\"⏳ 2. Creating SQLite table if not exists...\");\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS portfolio_messages (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n email TEXT,\n phone TEXT,\n type TEXT,\n message TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log(\"⏳ 3. Inserting data into SQLite...\");\n await sqlite.execute({\n sql: \"INSERT INTO portfolio_messages (name, email, phone, type, message) VALUES (?, ?, ?, ?, ?)\",\n args: [name, email, phone, type, message],\n });\n console.log(\"✅ SQLite Insert Success!\");\n\n // --- STEP 2: SEND TELEGRAM NOTIFICATION ---\n console.log(\"⏳ 4. Sending Telegram notification...\");\n const TELEGRAM_BOT_TOKEN = \"8520251378:AAGLIr36Zml7YfI7LokOwugm49QGZ1z6IgA\";\n const TELEGRAM_CHAT_ID = \"342875152\";\n \n const telegramText = `\n🌟 New Portfolio Lead! 🌟\n\n👤 Name: ${name}\n📧 Email: ${email}\n📱 Phone: ${phone}\n🎯 Purpose: ${type}\n\n💬 Message:\n${message}\n`;\n\n const telegramUrl = `https://api.telegram.org/bot${TELEGRAM_BOT_TOKEN}/sendMessage`;\n const tgResponse = await fetch(telegramUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: TELEGRAM_CHAT_ID,\n text: telegramText,\n parse_mode: \"HTML\", \n }),\n });\n console.log(\"✅ Telegram Status:\", tgResponse.status === 200 ? \"Message Sent\" : \"Failed\");\n\n // --- STEP 3: SAVE TO GOOGLE SHEETS ---\n console.log(\"⏳ 5. Sending data to Google Sheets...\");\n const GOOGLE_SHEET_WEBHOOK_URL = \"https://script.google.com/macros/s/AKfycbwvvfVJQ9CFdglCbElWHwn7RWP7x5taLByGEN9QHqzSnjnM6xwlGb5yhqIyDWJ6CE1guw/exec\";\n \n const sheetData = { name, email, phone, category: type, message };\n\n const sheetResponse = await fetch(GOOGLE_SHEET_WEBHOOK_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"text/plain;charset=utf-8\" },\n body: JSON.stringify(sheetData),\n redirect: \"follow\"\n });\n console.log(\"✅ Google Sheets Status:\", sheetResponse.status);\n\n console.log(\"🎉 All tasks completed successfully!\");\n \n return new Response(JSON.stringify({ success: true, message: \"Saved to SQLite & Sheets, and Telegram notified!\" }), {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n\n } catch (error) {\n console.error(\"❌ ERROR CAUGHT:\", error.message);\n return new Response(JSON.stringify({ success: false, error: error.message }), {\n status: 500,\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n }\n}",[],[178],"5b52e8bd-8563-4808-a05c-c8503f098337","main.ts","db21c8b0-a48d-11f1-960b-1607ee4eb77e",2,["D",1788106529401],"export default async function (req: Request) {\n // CORS handle karna zaroori hai taaki portfolio (frontend) se request block na ho\n if (req.method === \"OPTIONS\") {\n return new Response(null, {\n headers: {\n \"Access-Control-Allow-Origin\": \"*\",\n \"Access-Control-Allow-Methods\": \"POST, OPTIONS\",\n \"Access-Control-Allow-Headers\": \"Content-Type\",\n },\n });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Only POST method allowed\", { status: 405 });\n }\n\n try {\n const data = await req.json();\n const { name, email, phone, category, message } = data;\n\n // 1. Telegram Notification Send Karna\n // (In credentials ko aap Val Town ke Environment variables me bhi save kar sakte ho for security)\n const TELEGRAM_BOT_TOKEN = \"8520251378:AAGLIr36Zml7YfI7LokOwugm49QGZ1z6IgA\";\n const TELEGRAM_CHAT_ID = \"342875152\";\n\n const telegramText =\n `🚀 *New Portfolio Request!*\\n\\n👤 *Name:* ${name}\\n✉️ *Email:* ${email}\\n📞 *Phone:* ${\n phone || \"N/A\"\n }\\n📌 *Type:* ${category}\\n💬 *Message:* ${message}`;\n\n const telegramUrl =\n `https://api.telegram.org/bot${TELEGRAM_BOT_TOKEN}/sendMessage`;\n await fetch(telegramUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: TELEGRAM_CHAT_ID,\n text: telegramText,\n parse_mode: \"Markdown\",\n }),\n });\n\n // 2. Google Sheet me data save karna\n // Yaha apna Step 2 wala Apps Script ka Web App URL paste karo\n const GOOGLE_SHEET_WEBHOOK_URL =\n \"https://script.google.com/macros/s/AKfycbwvvfVJQ9CFdglCbElWHwn7RWP7x5taLByGEN9QHqzSnjnM6xwlGb5yhqIyDWJ6CE1guw/exec\";\n\n if (\n GOOGLE_SHEET_WEBHOOK_URL !==\n \"https://script.google.com/macros/s/AKfycbwvvfVJQ9CFdglCbElWHwn7RWP7x5taLByGEN9QHqzSnjnM6xwlGb5yhqIyDWJ6CE1guw/exec\"\n ) {\n await fetch(GOOGLE_SHEET_WEBHOOK_URL, {\n method: \"POST\",\n headers: { \"Content-Type\": \"text/plain\" }, // Apps script text/plain easily handle karta hai\n body: JSON.stringify(data),\n });\n }\n\n // Success Response back to Portfolio\n return new Response(\n JSON.stringify({ success: true, message: \"Message sent and saved!\" }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Access-Control-Allow-Origin\": \"*\",\n },\n },\n );\n } catch (error) {\n return new Response(\n JSON.stringify({ success: false, error: error.message }),\n {\n status: 500,\n headers: { \"Access-Control-Allow-Origin\": \"*\" },\n },\n );\n }\n}",[],[187],["D",1788106459861],["D",1789497078049],{"_11":12,"_129":69},{"_11":12,"_125":-5,"_68":69,"_30":67,"_126":127,"_128":24},{"_39":72,"_13":16,"_33":36,"_117":78,"_118":-5,"_119":-5,"_120":-5,"_121":-5,"_122":-5,"_123":14,"_124":12},"ctx",{"_52":-5,"_148":232,"_233":234,"_235":236,"_237":24,"_238":24,"_239":24,"_240":91,"_241":-5,"_242":-7,"_243":-7,"_244":26,"_245":24,"_246":24,"_247":-5,"_248":24,"_249":24,"_250":24,"_251":-5},"ENV",{"_203":204,"_205":206,"_207":16,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

History · new-file-7739.ts