[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","hucccc","name","adflex-cloud-bridge","path","main.ts","project",{"_22":46,"_11":12,"_33":47,"_48":-5,"_49":42,"_50":51,"_52":51,"_53":54,"_55":-5,"_56":57,"_58":25,"_59":32,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_13":45},"permalink","https://www.val.town/x/hucccc/adflex-cloud-bridge/code/main.ts","extension","id","6e375ea4-219f-460f-8106-8e1cd2a63550","fileId","c607ce12-9f8c-11f1-8f00-1607ee4eb77e","parentId","branchId","15869605-47be-4d85-8270-0400f72b4399","branchVersion",16,"latest",true,"createdAt",["D",1787557848147],"version",6,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst STORE_URL='https://salla.sa/smart-newsroom';\n\nasync function init(){\n await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS bridge_state(\n key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`});\n await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS campaign_queue(\n id INTEGER PRIMARY KEY AUTOINCREMENT, campaign_key TEXT UNIQUE NOT NULL,\n objective TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'staged',\n route TEXT NOT NULL DEFAULT 'cloud', next_action TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`});\n await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS asset_queue(\n id INTEGER PRIMARY KEY AUTOINCREMENT, asset_key TEXT UNIQUE NOT NULL,\n format TEXT NOT NULL, angle TEXT NOT NULL, headline TEXT NOT NULL, cta TEXT NOT NULL,\n prompt TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'ready', route TEXT NOT NULL DEFAULT 'cloud-fallback',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`});\n await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS clicks(\n id INTEGER PRIMARY KEY AUTOINCREMENT, campaign TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP)`});\n}\n\nfunction landing(origin:string){\n const buy=`${origin}/go/landing`;\n return `غرفة الأخبار الذكية

حزمة رقمية للإعلام والعلاقات العامة

غرفة الأخبار الذكية

ابدأ من الجاهز بدل البدء من الصفر. أدوات عملية تساعد على تسريع العمل الإعلامي ورفع جودة المخرجات.

دليل تطبيقي
مرجع عملي منظم

120 أمراً احترافياً
للمهام الإعلامية المتكررة

12 قالباً جاهزاً
لبداية أسرع وأكثر تنظيماً

احصل على الحزمة الآن

يتم إتمام الشراء عبر متجر سلة الرسمي.

`;\n}\n\nexport default async function(req:Request){\n await init();\n const u=new URL(req.url);\n if(u.pathname==='/health'){\n const rows=await sqlite.execute({sql:\"SELECT key,value,updated_at FROM bridge_state ORDER BY key\"});\n const q=await sqlite.execute({sql:\"SELECT status,count(*) c FROM campaign_queue GROUP BY status\"});\n const a=await sqlite.execute({sql:\"SELECT status,count(*) c FROM asset_queue GROUP BY status\"});\n const c=await sqlite.execute({sql:\"SELECT count(*) c FROM clicks\"});\n const g=await sqlite.execute({sql:\"SELECT state,count(*) c FROM growth_tasks GROUP BY state\"});\n const m=await sqlite.execute({sql:\"SELECT kind,count(*) c FROM media_assets GROUP BY kind\"});\n return Response.json({name:'AI1000 AdFlex Cloud Bridge',status:'online',mode:'cloud-first',desktopRequired:false,policy:['official-channels-only','no-password-or-otp-capture','no-reverse-engineering','no-auto-purchase','checkpoint-before-switch'],accountAccess:'awaiting_official_delegation_or_supported_api',publicChecks:rows.rows,queue:q.rows,assets:a.rows,growth:g.rows,media:m.rows,trackedClicks:c.rows[0]?.c||0});\n }\n if(u.pathname==='/assets'){\n const rows=await sqlite.execute({sql:\"SELECT id,asset_key,format,angle,headline,cta,status,route FROM asset_queue ORDER BY id LIMIT 120\"});\n return Response.json({count:rows.rows.length,assets:rows.rows});\n }\n if(u.pathname==='/media'){\n const rows=await sqlite.execute({sql:\"SELECT asset_key,kind,style,url,status FROM media_assets ORDER BY id\"});\n return Response.json({count:rows.rows.length,media:rows.rows});\n }\n if(u.pathname==='/growth'){\n const limit=Math.min(100,Math.max(1,Number(u.searchParams.get('limit')||20)));\n const offset=Math.max(0,Number(u.searchParams.get('offset')||0));\n const rows=await sqlite.execute({sql:\"SELECT task_key,format,angle,audience,hook,caption,prompt,tracking_url,state FROM growth_tasks ORDER BY id LIMIT ? OFFSET ?\",args:[limit,offset]});\n return Response.json({limit,offset,items:rows.rows});\n }\n if(u.pathname==='/metrics'){\n const rows=await sqlite.execute({sql:\"SELECT campaign,count(*) clicks,max(created_at) last_click FROM clicks GROUP BY campaign ORDER BY clicks DESC\"});\n return Response.json({privacy:'campaign-level only; no IP addresses stored',rows:rows.rows});\n }\n if(u.pathname.startsWith('/go/')){\n const campaign=(u.pathname.split('/')[2]||'direct').replace(/[^a-zA-Z0-9_-]/g,'').slice(0,80)||'direct';\n await sqlite.execute({sql:\"INSERT INTO clicks(campaign) VALUES(?)\",args:[campaign]});\n return Response.redirect(STORE_URL,302);\n }\n if(u.pathname==='/plan'){\n return Response.json({target:'AdFlex',desktopRequired:false,stages:['brand brief','sales creatives','vertical video','voiceover','social variants','schedule package'],currentRoute:'AI1000 cloud staging + connected creative fallbacks',blockedOnlyBy:'AdFlex authenticated account action until an official supported delegation/API path exists'});\n }\n if(u.pathname==='/' || u.pathname==='/landing') return new Response(landing(u.origin),{headers:{'content-type':'text/html; charset=utf-8','cache-control':'public,max-age=300'}});\n return Response.json({name:'AI1000 AdFlex Cloud Bridge',status:'online',endpoints:['/','/landing','/go/:campaign','/metrics','/health','/plan','/assets']});\n}","deleted",false,"label","ai1000-adflex-bridge",[14],"e78ac2fb-6c34-4acd-b799-096754300563",["D",1787556239105],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","AI1000 cloud staging and failover bridge for AdFlex","imageUrl","userId","d01b5ba9-4190-4170-b205-935688c090c0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fff33-2891-750b-b930-6536da9aa970","tursoName","e78ac2fb6c344acdb799096754300563","tursoHostname","e78ac2fb6c344acdb799096754300563-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789475460618],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_104":100},"org",{"_9":10,"_98":10,"_99":100,"_56":57,"_101":102,"_103":42},"branch",{"_35":30,"_11":89,"_22":28,"_90":46,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://avatars.githubusercontent.com/u/290340746?v=4","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":63,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":89,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]