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

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

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

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

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}","ai1000-adflex-bridge",[75],"4f071074-0356-4509-a243-a2d7661ac1d1",["D",1787557576564],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst FORMATS=['مربع 1:1','منشور 4:5','ستوري 9:16','ريل 9:16','تصوير منتج','منشور فوائد','مشكلة/حل','مقارنة قبل/بعد','فيديو صوتي','إعلان بيع مباشر'];\nconst ANGLES=['اختصار الوقت','رفع الجودة','الجاهزية','توفير الجهد','التنظيم','الثقة في الصياغة','العمل المؤسسي','الإنتاجية','سهولة البداية','الحزمة المتكاملة'];\nconst AUDIENCES=['الإعلاميون','العلاقات العامة','التواصل المؤسسي','صناع المحتوى','طلاب الإعلام','المشاريع الصغيرة','الجهات التدريبية','الوكالات الإعلامية','المستقلون','فرق التسويق'];\nconst CTA=['اشتر الآن','احصل على الحزمة الآن','ابدأ اليوم','احصل على نسختك','اكتشف الحزمة'];\n\nasync function setup(){\n await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS growth_tasks(\n id INTEGER PRIMARY KEY AUTOINCREMENT, task_key TEXT UNIQUE NOT NULL,\n format TEXT NOT NULL, angle TEXT NOT NULL, audience TEXT NOT NULL,\n hook TEXT, caption TEXT, prompt TEXT, tracking_url TEXT,\n state TEXT NOT NULL DEFAULT 'pending', created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n packaged_at TEXT)`});\n await sqlite.execute({sql:`CREATE TABLE IF NOT EXISTS growth_runs(\n id INTEGER PRIMARY KEY AUTOINCREMENT, started_at TEXT NOT NULL, finished_at TEXT,\n processed INTEGER DEFAULT 0, pending INTEGER DEFAULT 0, packaged INTEGER DEFAULT 0, result TEXT)`});\n}\n\nasync function seed(){\n const formatsSql=FORMATS.map((v,i)=>`WHEN ${i} THEN '${v}'`).join(' ');\n const anglesSql=ANGLES.map((v,i)=>`WHEN ${i} THEN '${v}'`).join(' ');\n const audiencesSql=AUDIENCES.map((v,i)=>`WHEN ${i} THEN '${v}'`).join(' ');\n await sqlite.execute({sql:`WITH RECURSIVE nums(n) AS (SELECT 1 UNION ALL SELECT n+1 FROM nums WHERE n<1000)\n INSERT OR IGNORE INTO growth_tasks(task_key,format,angle,audience)\n SELECT 'g'||printf('%04d',n),\n CASE CAST((n-1)/100 AS INTEGER) ${formatsSql} END,\n CASE CAST(((n-1)/10)%10 AS INTEGER) ${anglesSql} END,\n CASE CAST((n-1)%10 AS INTEGER) ${audiencesSql} END\n FROM nums`});\n}\n\nfunction packageTask(t:any){\n const cta=CTA[(Number(t.id)-1)%CTA.length];\n const hook=`${t.audience}: ${t.angle} مع غرفة الأخبار الذكية`;\n const caption=`${hook}. حزمة رقمية للإعلام والعلاقات العامة تضم دليلاً تطبيقياً و120 أمراً احترافياً و12 قالباً جاهزاً. ${cta}.`;\n const prompt=`أنشئ ${t.format} باللغة العربية لمنتج «غرفة الأخبار الذكية». الجمهور: ${t.audience}. الزاوية: ${t.angle}. أبرز: دليل تطبيقي + 120 أمرًا احترافيًا + 12 قالبًا جاهزًا. هوية كحلي وذهبي وأبيض، أسلوب مؤسسي نظيف، RTL واضح، بدون ادعاءات مبالغ فيها. CTA: ${cta}.`;\n const tracking=`https://smart-newsroom-growth.val.run/go/${t.task_key}`;\n return {hook,caption,prompt,tracking};\n}\n\nexport default async function(){\n await setup();\n await seed();\n const start=new Date().toISOString();\n const rr=await sqlite.execute({sql:\"INSERT INTO growth_runs(started_at) VALUES(?) RETURNING id\",args:[start]});\n const runId=Number(rr.rows[0]?.id||0);\n const batch=await sqlite.execute({sql:\"SELECT id,task_key,format,angle,audience FROM growth_tasks WHERE state='pending' ORDER BY id LIMIT 50\"});\n for(const t of batch.rows as any[]){\n const p=packageTask(t);\n await sqlite.execute({sql:\"UPDATE growth_tasks SET hook=?,caption=?,prompt=?,tracking_url=?,state='packaged',packaged_at=? WHERE id=?\",args:[p.hook,p.caption,p.prompt,p.tracking,new Date().toISOString(),t.id]});\n }\n let store:any={ok:false,status:null};\n try{const r=await fetch('https://salla.sa/smart-newsroom',{headers:{'user-agent':'AI1000-Growth-Worker/1.0'}});store={ok:r.ok,status:r.status};}catch(e){store={ok:false,error:String(e)}}\n const counts=await sqlite.execute({sql:\"SELECT state,count(*) c FROM growth_tasks GROUP BY state\"});\n const map:any={}; for(const r of counts.rows as any[]) map[String(r.state)]=Number(r.c||0);\n const result=JSON.stringify({processed:batch.rows.length,pending:map.pending||0,packaged:map.packaged||0,store});\n await sqlite.execute({sql:\"UPDATE growth_runs SET finished_at=?,processed=?,pending=?,packaged=?,result=? WHERE id=?\",args:[new Date().toISOString(),batch.rows.length,map.pending||0,map.packaged||0,result,runId]});\n console.log(result);\n}",[145],"ae9d45fa-80f9-4027-a949-e0a6d362d9d0",["D",1787557705236],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst now=new Date().toISOString();\nawait sqlite.execute({sql:`UPDATE growth_tasks SET\n hook = audience || ': ' || angle || ' مع غرفة الأخبار الذكية',\n caption = audience || ': ' || angle || ' مع غرفة الأخبار الذكية. حزمة رقمية للإعلام والعلاقات العامة تضم دليلاً تطبيقياً و120 أمراً احترافياً و12 قالباً جاهزاً. احصل على الحزمة الآن.',\n prompt = 'أنشئ ' || format || ' باللغة العربية لمنتج «غرفة الأخبار الذكية». الجمهور: ' || audience || '. الزاوية: ' || angle || '. أبرز: دليل تطبيقي + 120 أمرًا احترافيًا + 12 قالبًا جاهزًا. هوية كحلي وذهبي وأبيض، أسلوب مؤسسي نظيف، RTL واضح، بدون ادعاءات مبالغ فيها. CTA: احصل على الحزمة الآن.',\n tracking_url = 'https://smart-newsroom-growth.val.run/go/' || task_key,\n state='packaged', packaged_at=?\n WHERE state='pending'`,args:[now]});\nconst counts=await sqlite.execute({sql:\"SELECT state,count(*) c FROM growth_tasks GROUP BY state\"});\nconsole.log(JSON.stringify({ok:true,counts:counts.rows}));",[175],"pulls","branches","forks","envVars",{"_307":20,"_309":20},"connections",{"_307":20,"_308":20},"count","unfilledCount","emptyCount",{"_42":296,"_13":175,"_73":174,"_52":-5,"_44":45,"_276":169,"_277":209,"_46":328,"_48":20,"_76":115,"_279":298,"_78":24,"_281":-5,"_316":329,"_248":330},{"_42":292,"_13":145,"_73":144,"_52":-5,"_44":45,"_276":162,"_277":209,"_46":325,"_48":91,"_76":98,"_279":294,"_78":24,"_281":-5,"_316":326,"_248":327},{"_42":287,"_13":75,"_73":74,"_52":-5,"_44":45,"_276":192,"_277":209,"_46":322,"_48":118,"_76":77,"_279":289,"_78":24,"_281":290,"_316":323,"_248":324},{"_42":283,"_13":114,"_73":113,"_52":-5,"_44":45,"_276":125,"_277":209,"_46":319,"_48":84,"_76":115,"_279":285,"_78":24,"_281":-5,"_316":320,"_248":321},{"_42":275,"_13":97,"_73":96,"_52":-5,"_44":45,"_276":91,"_277":209,"_46":315,"_48":20,"_76":98,"_279":280,"_78":24,"_281":-5,"_316":317,"_248":318},["D",1787556297341],"children",[],[97],["D",1787557082815],[],[114],["D",1787557848147],[],[75],["D",1787557576564],[],[145],["D",1787557705236],[],[175],["D",1787556239105],["D",1789475460618],{"_11":12,"_247":81},{"_11":12,"_243":12,"_80":81,"_25":79,"_244":245,"_246":24},{"_48":192,"_13":16,"_42":45,"_235":197,"_236":-5,"_237":-5,"_238":-5,"_239":-5,"_240":-5,"_241":14,"_242":12},"ctx",{"_62":-5,"_267":369,"_370":371,"_372":373,"_374":24,"_375":24,"_376":24,"_377":209,"_378":-5,"_379":-7,"_380":-7,"_381":20,"_382":24,"_383":24,"_384":-5,"_385":24,"_386":24,"_387":24,"_388":-5},"ENV",{"_340":341,"_342":343,"_344":16,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368},"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