\"+appLogo()+\"

\"+(isLogin?'تسجيل الدخول':'إنشاء حساب')+\"

\"+(isLogin?'أدخل بياناتك للمتابعة':'انضم وابدأ الطلب مع زملائك')+\"

الاسم

كلمة المرور

دخول المشرف

\";\n document.getElementById('sw').onclick=function(){mode=isLogin?'signup':'login';renderAuth();};\n document.getElementById('go').onclick=function(){var nm=document.getElementById('nm').value.trim(),pw=document.getElementById('pw').value,er=document.getElementById('er');if(!nm||!pw){er.textContent='اكتب الاسم وكلمة المرور';return;}var done=bload(this);post(isLogin?'/api/login':'/api/signup',{name:nm,password:pw}).then(function(d){if(d.ok){ME={kind:'user',name:d.name};tab='orders';render();maybePush();}else{done();er.textContent=d.error||'خطأ';}},function(){done();er.textContent='تعذّر الاتصال، حاول مرة ثانية';});};\n}\nfunction renderName(){\n app.innerHTML=\"

\"+appLogo()+\"

أهلاً بك

اكتب اسمك للانضمام كضيف

الاسم

عندك حساب؟ سجّل دخولك

\";\n document.getElementById('go').onclick=function(){var v=document.getElementById('nm').value.trim();if(!v){document.getElementById('er').textContent='اكتب اسمك';return;}gname=v;localStorage.setItem(GKEY,v);var done=bload(this);P('/api/join',{}).then(function(){render();maybePush();},function(){done();document.getElementById('er').textContent='تعذّر الاتصال، حاول مرة ثانية';});};\n}\nfunction stopPoll(){if(poll){clearInterval(poll);poll=null;}}\nfunction startPoll(){stopPoll();refresh();poll=setInterval(refresh,2500);}\nfunction render(){\n stopPoll();\n if(GUEST){ app.innerHTML=\"

\"+skel(3)+\"

\"; scrn='';lastSig='';startPoll(); return; }\n var content=tab==='history'?\"

\":tab==='settings'?viewSettings():\"

\"+skel(3)+\"

\";\n app.innerHTML=\"

\"+content+\"

\"+nav();\n bindNav();\n if(tab==='settings')bindSettings();\n if(tab==='history')loadHistory();\n if(tab==='orders'){scrn='';lastSig='';startPoll();}\n}\nfunction nav(){function b(id,ic,l,dot){return \"\";}var I={orders:\"\",history:\"\",settings:\"\"};return \"

\"+b('orders',I.orders,'الطلبات',false)+b('history',I.history,'السجل',window.unpaidDot)+b('settings',I.settings,'الإعدادات',false)+\"

\";}\nfunction bindNav(){var bs=document.querySelectorAll('.nav button');for(var i=0;i0&&scrn==='vote')return;\n ST=st;\n if(!GUEST&&tab!=='orders')return;\n if(scrn==='menu'&&st.session&&st.session.stage==='ordering')return;\n var sig=JSON.stringify(st);if(sig===lastSig)return;lastSig=sig;\n renderSession(st);updateCd(st);\n }).catch(function(){});\n}\nfunction renderSession(st){\n var ov=document.getElementById('ov');if(!ov)return;\n if(!st.session){scrn='none';showNav(true);ov.innerHTML=emptyState('ما فيه طلب حالياً','لا أحد يطلب الآن. بيبدأ المشرف الجلسة وبتوصلك هنا.');return;}\n var s=st.session, me=st.me||{}, joined=me.status&&me.status!=='left';\n if(!joined){scrn='join';showNav(true);renderJoin(s);return;}\n if(s.type==='vote'&&s.stage==='voting'){renderVote(st);return;}\n if(s.stage==='setup'){scrn='wait';showNav(true);ov.innerHTML=waitBox('المشرف يجهّز الطلب... انتظر قليلاً');return;}\n if(s.stage==='ordering'){ if(me.myorder&&!editing){renderStatus(st);} else {scrn='menu';REST={name:s.rest_name,logo:s.rest_logo,cover:s.rest_cover};ensureMenu(s.id,function(){renderMenu(st);});} return; }\n if(me.myorder)renderStatus(st); else {scrn='wait';showNav(true);ov.innerHTML=waitBox('انتهى وقت الطلب.');}\n}\nfunction waitBox(msg){return \"

⏳

\"+msg+\"

\";}\nfunction renderJoin(s){var ov=document.getElementById('ov'),tl=s.type==='vote'?'تصويت':'طلب';ov.innerHTML=\"

🍽️

بدأت جلسة \"+tl+\"

انضم عشان تشارك.

\";document.getElementById('join').onclick=function(){var done=bload(this);P('/api/join',{}).then(function(){lastSig='';refresh();},function(){done();});};}\nfunction renderVote(st){\n scrn='vote';showNav(true);\n var s=st.session, me=st.me||{}, ov=document.getElementById('ov');\n VEA=(s.vote_ends_at&&!s.vote_ended)?s.vote_ends_at:null;\n var choices=(s.choices||[]).slice();\n if(s.vote_ended){\n var max=0;choices.forEach(function(c){if(c.votes>max)max=c.votes;});\n var tops=choices.filter(function(c){return c.votes===max&&max>0;});\n var head=tops.length===1?(\"الفائز: \"+esc(tops[0].name)+\" 🏆\"):(tops.length>1?(\"تعادل: \"+tops.map(function(c){return esc(c.name);}).join('، ')):\"انتهى التصويت\");\n ov.innerHTML=\"

\"+head+\"

بانتظار المشرف يفتح الطلب...

\"+voteList(choices,me,true)+\"

\";return;\n }\n var vl=document.getElementById('vl');var needCd=VEA&&!document.getElementById('cd');\n if(vl&&!needCd){vl.innerHTML=voteList(choices,me,false);bindVoteRows();paintCd();return;}\n ov.innerHTML=\"

\"+(VEA?\"

\":\"\")+\"

\"+voteList(choices,me,false)+\"

\";\n document.getElementById('addr').onclick=function(){var i=document.getElementById('newr');var v=i.value.trim();if(!v)return;var done=bload(this);P('/api/addchoice',{name:v}).then(function(){done();i.value='';lastSig='';refresh();},function(){done();});};\n bindVoteRows();paintCd();\n}\nfunction voteList(choices,me,ended){\n if(!choices.length)return \"

أضف أول مطعم 👇

\";\n return choices.map(function(c){var mine=me.myvote===c.id;var voters=(c.voters&&c.voters.length)?(\"

صوّت: \"+c.voters.map(esc).join('، ')+\"

\"):\"\";return \"

\"+esc(c.name)+(mine?' ✅':'')+\"\"+c.votes+\"

\"+voters+\"

\";}).join('');\n}\nfunction bindVoteRows(){var r=document.querySelectorAll('[data-vote]');for(var i=0;i\"+esc(c.cat)+\"\";}).join('');\n var secs=MENU.map(function(c,i){var items=c.items.map(function(it){return \"

\"+(it.img?\"

\":\"

\")+\"

\"+esc(it.name)+\"

\"+(it.desc?\"

\"+esc(it.desc)+\"

\":\"\")+\"

\"+money(it.price)+\"

\";}).join('');return \"

\"+esc(c.cat)+\"

\"+items+\"

\";}).join('');\n var ov=document.getElementById('ov');\n var cartSVG=\"\";\n ov.innerHTML=\"

\"+(REST.logo?\"

\":\"\")+\"

القائمة

\"+esc(REST.name)+\"

\"+tabs+\"

\"+secs+\"

\";\n bindMenu();updateBar();\n}\nfunction bindMenu(){\n var jt=document.querySelectorAll('[data-jump]');for(var i=0;i\":\"\")+\"

\"+esc(it.name)+\"

\"+(it.desc?\"

\"+esc(it.desc)+\"

\":\"\")+\"

\"+money(it.price)+\"

\"+window._q+\"

\";\n document.getElementById('qm').onclick=function(){window._q=Math.max(1,window._q-1);document.getElementById('q').textContent=window._q;};\n document.getElementById('qp').onclick=function(){window._q=window._q+1;document.getElementById('q').textContent=window._q;};\n document.getElementById('addc').onclick=function(){var n=document.getElementById('note').value.trim();var e={id:it.id,name:it.name,price:it.price,img:it.img,qty:window._q,note:n};if(window._ei>=0)cart[window._ei]=e;else cart.push(e);closeSheet();updateBar();};\n openSheet();\n}\nfunction cartTotal(){var t=0;for(var i=0;i

\"+esc(c.name)+\" ×\"+c.qty+\"\"+money(c.price*c.qty)+\"

\"+(c.note?\"

📝 \"+esc(c.note)+\"

\":\"\")+\"

\";}).join('');\n if(!cart.length)rows=\"

السلة فارغة

\";\n var chips=obNames.map(function(n,i){return \"\"+esc(n)+\"\";}).join('');\n var per=money(cartTotal()/(1+obNames.length));\n var sh=document.getElementById('sheet');\n sh.innerHTML=\"

السلة

\"+rows+\"

اطلب نيابة عن (تقسيم الفاتورة)

\"+chips+\"

\"+(obNames.length?\"

كل واحد يدفع \"+per+\" (أنت + \"+obNames.length+\")

\":\"\")+\"

الإجمالي\"+money(cartTotal())+\"

\";\n document.getElementById('addn').onclick=function(){var i=document.getElementById('obn');var v=i.value.trim();if(!v)return;obNames.push(v);openCart();};\n var rm=document.querySelectorAll('[data-rmname]');for(var k=0;k\"+esc(i.name)+\" ×\"+i.qty+\"\"+(i.note?\"\"+esc(i.note)+\"\":\"\")+\"\"+money(i.price*i.qty)+\"\";}).join('');\n var namesLine=(mo.names&&mo.names.length)?(\"

مقسومة على: أنت، \"+mo.names.map(esc).join('، ')+\" — كل واحد \"+money(owed/(1+mo.names.length))+\"

\"):\"\";\n var reason=mo.reason?\"

تعديل المشرف: \"+esc(mo.reason)+\"

\":\"\";\n var head=ordered?(\"

🎉

تم الطلب!

يوصل الساعة \"+fmtTime(s.arrival)+\"

\"):(\"

✅

استلمنا طلبك

بنطلب قريباً 😌

\");\n var orderCard=\"

طلبك من \"+esc(s.rest_name||'')+\"

\"+items+\"

\";\n var bank=ordered?(\"

حوّل إلى

\"+esc(s.bank)+\"

\"):\"\";\n var payBlock=\"\";\n if(ordered){\n if(mo.paid){payBlock=\"

المبلغ المطلوب

\"+money(owed)+\"

\"+reason+namesLine+\"

شكراً لدفعك ✅

\";}\n else{payBlock=\"

المبلغ المطلوب منك

\"+money(owed)+\"

\"+reason+namesLine+\"

\";}\n }\n var editBtn=(s.stage==='ordering'&&!mo.paid)?\"\":\"\";\n ov.innerHTML=\"

\"+head+orderCard+bank+payBlock+editBtn+\"

\";\n var eb=document.getElementById('editOrder');if(eb)eb.onclick=function(){editing=true;scrn='';lastSig='';refresh();};\n var sb=document.getElementById('splitb');if(sb)sb.onclick=function(){var n=parseInt(document.getElementById('splitn').value);if(!n||n<1)return;document.getElementById('splitr').textContent='كل واحد يدفع '+money(owed/n);};\n var pb=document.getElementById('paidb');if(pb)pb.onclick=function(){var done=bload(this);P('/api/paid',{room_id:s.id}).then(function(){lastSig='';refresh();},function(){done();});};\n}\nfunction loadHistory(){\n api('/api/history').then(function(d){\n window.unpaidDot=!!(d.mine&&d.mine.some(function(x){return !x.paid;}));\n var hv=document.getElementById('hv');if(!hv)return;\n if(!d.mine||!d.mine.length){hv.innerHTML=emptyState('لا يوجد سجل بعد','طلباتك السابقة بتظهر هنا.');return;}\n hv.innerHTML=\"

\"+d.mine.map(function(m){var dt=new Date(m.ordered_at),date=dt.getDate()+'/'+(dt.getMonth()+1);var pay=m.paid?\"دفعت\":\"\";return \"

\"+esc(m.name||'مطعم')+\"\"+date+\"

\"+money(m.total)+\"\"+pay+\"

\";}).join('')+\"

\";\n var pb=document.querySelectorAll('[data-pay]');for(var i=0;i

الاسم

كلمة مرور جديدة (اتركها فارغة لعدم التغيير)

🔔 تنبيهات الجوال

ننبهك لما تبدأ جلسة غداء أو يوصل طلبك.

\"+(PUSHOFF?\"\":\"

التنبيهات مفعّلة ✅

\")+\"

\";}\nfunction bindSettings(){\n document.getElementById('save').onclick=function(){var nm=document.getElementById('snm').value.trim(),pw=document.getElementById('spw').value;var ok=document.getElementById('sok'),er=document.getElementById('ser');ok.textContent='';er.textContent='';var body={};if(nm&&nm!==ME.name)body.name=nm;if(pw)body.password=pw;if(!body.name&&!body.password){ok.textContent='لا تغييرات';return;}var done=bload(this);post('/api/update-profile',body).then(function(d){done();if(d.ok){if(body.name)ME.name=nm;tab='settings';render();var o=document.getElementById('sok');if(o)o.textContent='تم الحفظ ✅';}else er.textContent=d.error||'خطأ';},function(){done();er.textContent='تعذّر الاتصال، حاول مرة ثانية';});};\n document.getElementById('logout').onclick=function(){post('/api/logout',{}).then(function(){ME=null;mode='login';stopPoll();renderAuth();});};\n var pb=document.getElementById('pushBtn');if(pb)pb.onclick=function(){var msg=document.getElementById('pushMsg');msg.textContent='...جارٍ التفعيل';pb.disabled=true;PUSHOFF=false;localStorage.removeItem('push_off');enablePush(function(r){pb.disabled=false;var m={ok:'تم تفعيل التنبيهات ✅',denied:'رفضت الإذن — فعّله من إعدادات المتصفح.',unsupported:'جهازك ما يدعم. على الآيفون: أضف التطبيق للشاشة الرئيسية ثم افتحه من هناك.',nokey:'التنبيهات غير مهيأة على الخادم بعد.',error:'صار خطأ، حاول مرة ثانية.'};if(r==='ok'){render();}else{msg.textContent=m[r]||r;}});};\n var po=document.getElementById('pushOff');if(po)po.onclick=function(){PUSHOFF=true;localStorage.setItem('push_off','1');po.disabled=true;pushDisable(function(){render();});};\n}\nboot();\nsetInterval(function(){ if(scrn==='vote')paintCd(); },1000);\n`;\n\nexport const ADMIN_JS = `\nvar tab='home', poll=null, lastSig='', uiBusy=false, AEA=null, chosen=null;\nvar app=document.getElementById('app');\nfunction boot(){api('/api/me').then(function(m){if(m.kind==='admin'){api('/api/history').then(function(d){window.unpaidDot=!!(d.sessions&&d.sessions.some(function(s){return s.orders.some(function(o){return !o.paid;});}));render();}).catch(function(){render();});}else renderLogin();}).catch(function(){setTimeout(boot,2000);});}\nfunction renderLogin(){\n app.innerHTML=\"

🔑

لوحة المشرف

كلمة مرور المشرف

رجوع لتطبيق الأعضاء

\";\n document.getElementById('go').onclick=function(){var pw=document.getElementById('pw').value,er=document.getElementById('er');if(!pw){er.textContent='اكتب كلمة المرور';return;}var btn=this;btn.disabled=true;post('/api/admin-login',{password:pw}).then(function(d){btn.disabled=false;if(d.ok){tab='home';boot();}else er.textContent=d.error||'خطأ';});};\n}\nfunction stopPoll(){if(poll){clearInterval(poll);poll=null;}}\nfunction startPoll(){stopPoll();refreshHome();poll=setInterval(refreshHome,2500);}\nfunction render(){\n stopPoll();\n var content=tab==='history'?\"

\":\"

\"+skel(3)+\"

\";\n app.innerHTML=\"

\"+content+\"

\"+nav();\n bindNav();\n if(tab==='history')loadHistory();\n if(tab==='home'){lastSig='';startPoll();}\n}\nfunction nav(){function b(id,ic,l,dot){return \"\";}var I={home:\"\",history:\"\"};return \"

\"+b('home',I.home,'الرئيسية',false)+b('history',I.history,'السجل',window.unpaidDot)+\"

\";}\nfunction bindNav(){var bs=document.querySelectorAll('.nav button');for(var i=0;i

رابط الضيوف (شاركه مع أي أحد):

\";}\nfunction rhead(s){return \"

\"+(s.rest_logo?\"

\":\"\")+\"

الطلب الجماعي

\"+esc(s.rest_name||'')+\"

\";}\nfunction orderCard(o){var t=o.over_total!=null?o.over_total:o.total;var items=o.items.map(function(i){return \"

\"+esc(i.name)+\" ×\"+i.qty+(i.note?\"\"+esc(i.note)+\"\":\"\")+\"\"+money(i.price*i.qty)+\"

\";}).join('');var names=(o.names&&o.names.length)?\"

نيابة عن: \"+o.names.map(esc).join('، ')+\"

\":\"\";var reason=o.over_reason?\"

تعديل: \"+esc(o.over_reason)+\"

\":\"\";var paid=o.paid?\" دفع\":\"\";return \"

\"+esc(o.person)+paid+\"\"+money(t)+\"

\"+items+names+reason+\"

\";}\nfunction participantsBox(s){var rows=s.participants.length?s.participants.map(function(p){return \"

\"+esc(p.name)+(p.is_guest?\" (ضيف)\":\"\")+\"\"+chip(p.status)+\"

\";}).join(''):\"

ما انضم أحد بعد.

\";return \"

المشاركون

\"+rows;}\nfunction renderHome(st,orders){\n var hv=document.getElementById('hv');if(!hv)return;\n if(!st.session){\n hv.innerHTML=emptyState('ما فيه جلسة نشطة','ابدأ جلسة يشوفها الأعضاء وينضمّون إليها.')+\"

\";\n document.getElementById('sV').onclick=function(){start('vote',this);};\n document.getElementById('sO').onclick=function(){start('order',this);};\n return;\n }\n var s=st.session, body='';\n if(s.type==='vote'&&s.stage==='voting'&&!s.vote_ended) body=voteAdminBox(s);\n else if(s.type==='vote'&&s.stage==='voting'&&s.vote_ended) body=voteEndedBox(s);\n else if(s.stage==='setup') body=shareBox()+\"

الصق رابط المطعم من هنقرستيشن:

\";\n else if(s.stage==='ordering') body=orderingBox(s,orders);\n else if(s.stage==='ordered'||s.stage==='arrived') body=orderedBox(s,orders);\n body+=participantsBox(s);\n if(s.stage!=='done') body+=\"\";\n hv.innerHTML=\"

\"+body+\"

\";\n bindHome(s,orders);paintACd();\n}\nfunction voteAdminBox(s){\n AEA=(s.vote_ends_at&&!s.vote_ended)?s.vote_ends_at:null;\n var choices=(s.choices||[]).slice().sort(function(a,b){return b.votes-a.votes;});\n var list=choices.length?choices.map(function(c){return \"

\"+esc(c.name)+\"\"+c.votes+\"

\"+(c.voters&&c.voters.length?\"

صوّت: \"+c.voters.map(esc).join('، ')+\"

\":\"\")+\"

\";}).join(''):\"

ما صوّت أحد بعد.

\";\n return shareBox()+\"

مؤقّت التصويت (دقائق)

\"+(AEA?\"

\":\"\")+\"

الأصوات

\"+list+\"\";\n}\nfunction voteEndedBox(s){\n var choices=(s.choices||[]).slice().sort(function(a,b){return b.votes-a.votes;});\n var max=choices.length?choices[0].votes:0;var tops=choices.filter(function(c){return c.votes===max&&max>0;});\n var block;\n if(tops.length>1&&!chosen){block=\"

تعادل! اختر الفائز 👇

\"+tops.map(function(c){return \"\";}).join('');}\n else{var wn=tops.length===1?tops[0].name:(chosen||'—');block=\"

الفائز: \"+esc(wn)+\" 🏆

الصق رابط المطعم من هنقرستيشن:

\";}\n var results=choices.map(function(c){return \"

\"+esc(c.name)+\"\"+c.votes+\"

\";}).join('');\n return block+\"

النتائج

\"+results;\n}\nfunction orderingBox(s,orders){\n var grand=0;orders.forEach(function(o){grand+=(o.over_total!=null?o.over_total:o.total);});\n var cards=orders.length?orders.map(orderCard).join(''):\"

لا طلبات بعد.

\";\n return shareBox()+rhead(s)+\"

الإجمالي

\"+money(grand)+\"

الطلبات (\"+orders.length+\")

\"+cards+\"

عند إتمام الطلب في هنقرستيشن:

وقت الوصول المتوقع

\";\n}\nfunction orderedBox(s,orders){\n var cards=orders.map(orderCard).join('');\n var arrivedBtn=s.stage==='ordered'?\"\":\"

وصل الطلب ✅

\";\n return rhead(s)+\"

وقت الوصول

الساعة \"+fmtTime(s.arrival)+\"

معلومات التحويل

\"+esc(s.bank)+\"

الطلبات

\"+cards+arrivedBtn+\"\";\n}\nfunction bindHome(s,orders){\n var cp=document.getElementById('cp');if(cp)cp.onclick=function(){navigator.clipboard.writeText(location.origin+'/j');cp.textContent='تم!';setTimeout(function(){cp.textContent='نسخ';},1200);};\n var setT=document.getElementById('setT');if(setT)setT.onclick=function(){var m=parseInt(document.getElementById('mins').value);if(!m)return;doPost('/api/settimer',{minutes:m});};\n var cv=document.getElementById('closeV');if(cv)cv.onclick=function(){if(confirm('إغلاق التصويت؟'))doPost('/api/closevote',{});};\n var tie=document.querySelectorAll('[data-tie]');for(var i=0;i\"+d.sessions.map(function(s){var dt=new Date(s.ordered_at),date=dt.getDate()+'/'+(dt.getMonth()+1),grand=0;var ppl=s.orders.map(function(o){grand+=o.total;if(!o.paid)anyUnpaid=true;var b=o.paid?\"دفع\":\"ما دفع\";return \"

\"+esc(o.person)+\"\"+money(o.total)+\" \"+b+\"

\";}).join('');return \"

\"+esc(s.name||'مطعم')+\"\"+date+\"

\"+ppl+\"

الإجمالي\"+money(grand)+\"

\";}).join('')+\"\";\n window.unpaidDot=anyUnpaid;\n }).catch(function(){var hv=document.getElementById('hv');if(hv)hv.innerHTML=emptyState('تعذّر التحميل','تحقق من الاتصال وحاول مرة ثانية.');});\n}\nboot();\nsetInterval(paintACd,1000);\n`;","deleted","label",[61],"49ff8eb3-b642-4684-8ec1-700b99c5bdd0","lunch-app.ts","019f4cf7-ed04-72db-9b5e-6dd0c1c47c61",1,["D",1783702744328],"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { ADMIN_JS, CSS, PERSON_JS, SW_JS } from \"./lunch-assets.ts\";\n\nconst ADMIN_PASSWORD = Deno.env.get(\"ADMIN_PASSWORD\") || \"changeme-admin\";\n\nlet inited = false;\nasync function initDb() {\n if (inited) return;\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT UNIQUE, pass TEXT, created_at INTEGER)`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS auth_tokens (token TEXT PRIMARY KEY, kind TEXT, user_id INTEGER, created_at INTEGER)`,\n );\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS room (\n id INTEGER PRIMARY KEY AUTOINCREMENT, type TEXT, stage TEXT, created_at INTEGER,\n vote_ends_at INTEGER, vote_closed INTEGER DEFAULT 0,\n link TEXT, rest_name TEXT, rest_logo TEXT, rest_cover TEXT, menu_json TEXT,\n ordered_at INTEGER, arrival TEXT, bank TEXT)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS participants (\n id INTEGER PRIMARY KEY AUTOINCREMENT, room_id INTEGER, pkey TEXT, user_id INTEGER,\n name TEXT, is_guest INTEGER DEFAULT 0, status TEXT DEFAULT 'joined',\n joined_at INTEGER, left_at INTEGER, UNIQUE(room_id, pkey))`);\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS l_choices (id INTEGER PRIMARY KEY AUTOINCREMENT, room_id INTEGER, name TEXT)`,\n );\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS l_votes (room_id INTEGER, voter_pkey TEXT, voter_name TEXT, choice_id INTEGER, PRIMARY KEY (room_id, voter_pkey))`,\n );\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS l_orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT, room_id INTEGER, pkey TEXT, person TEXT,\n items_json TEXT, total REAL, over_total REAL, over_reason TEXT,\n names_json TEXT, paid INTEGER DEFAULT 0, submitted_at INTEGER, UNIQUE(room_id, pkey))`);\n await addCols(\"room\", {\n type: \"TEXT\",\n stage: \"TEXT\",\n created_at: \"INTEGER\",\n vote_ends_at: \"INTEGER\",\n vote_closed: \"INTEGER DEFAULT 0\",\n link: \"TEXT\",\n rest_name: \"TEXT\",\n rest_logo: \"TEXT\",\n rest_cover: \"TEXT\",\n menu_json: \"TEXT\",\n ordered_at: \"INTEGER\",\n arrival: \"TEXT\",\n bank: \"TEXT\",\n });\n await addCols(\"participants\", {\n room_id: \"INTEGER\",\n pkey: \"TEXT\",\n user_id: \"INTEGER\",\n name: \"TEXT\",\n is_guest: \"INTEGER DEFAULT 0\",\n status: \"TEXT DEFAULT 'joined'\",\n joined_at: \"INTEGER\",\n left_at: \"INTEGER\",\n });\n await addCols(\"l_orders\", {\n room_id: \"INTEGER\",\n pkey: \"TEXT\",\n person: \"TEXT\",\n items_json: \"TEXT\",\n total: \"REAL\",\n over_total: \"REAL\",\n over_reason: \"TEXT\",\n names_json: \"TEXT\",\n paid: \"INTEGER DEFAULT 0\",\n submitted_at: \"INTEGER\",\n });\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS push_subs (endpoint TEXT PRIMARY KEY, pkey TEXT, sub_json TEXT, created_at INTEGER)`,\n );\n await addCols(\"push_subs\", {\n pkey: \"TEXT\",\n sub_json: \"TEXT\",\n created_at: \"INTEGER\",\n });\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_choices_room ON l_choices (room_id)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_room_stage ON room (stage)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_push_pkey ON push_subs (pkey)`,\n );\n inited = true;\n}\nasync function addCols(table, cols) {\n for (const c in cols) {\n try {\n await sqlite.execute(\n \"ALTER TABLE \" + table + \" ADD COLUMN \" + c + \" \" + cols[c],\n );\n } catch (_) {}\n }\n}\n\nconst json = (o, status = 200, extra = {}) =>\n new Response(JSON.stringify(o), {\n status,\n headers: { \"content-type\": \"application/json; charset=utf-8\", ...extra },\n });\nconst htmlResp = (s) =>\n new Response(s, { headers: { \"content-type\": \"text/html; charset=utf-8\" } });\n\nfunction b64(u8) {\n let s = \"\";\n for (const b of u8) s += String.fromCharCode(b);\n return btoa(s);\n}\nfunction ub64(str) {\n const s = atob(str);\n const u = new Uint8Array(s.length);\n for (let i = 0; i < s.length; i++) u[i] = s.charCodeAt(i);\n return u;\n}\nasync function pbkdf2(pw, salt) {\n const key = await crypto.subtle.importKey(\n \"raw\",\n new TextEncoder().encode(pw),\n \"PBKDF2\",\n false,\n [\"deriveBits\"],\n );\n const bits = await crypto.subtle.deriveBits(\n { name: \"PBKDF2\", salt, iterations: 100000, hash: \"SHA-256\" },\n key,\n 256,\n );\n return new Uint8Array(bits);\n}\nasync function hashPw(pw) {\n const salt = crypto.getRandomValues(new Uint8Array(16));\n return b64(salt) + \"$\" + b64(await pbkdf2(pw, salt));\n}\nasync function verifyPw(pw, stored) {\n const [s, h] = String(stored).split(\"$\");\n if (!s || !h) return false;\n return b64(await pbkdf2(pw, ub64(s))) === h;\n}\n\nfunction newToken() {\n const u = crypto.getRandomValues(new Uint8Array(32));\n let s = \"\";\n for (const b of u) s += b.toString(16).padStart(2, \"0\");\n return s;\n}\nfunction cookieHeader(t) {\n return {\n \"Set-Cookie\": \"sid=\" + t +\n \"; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=2592000\",\n };\n}\nfunction clearCookieHeader() {\n return {\n \"Set-Cookie\": \"sid=; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=0\",\n };\n}\nfunction readCookie(req, key) {\n const raw = req.headers.get(\"cookie\") || \"\";\n for (const part of raw.split(\";\")) {\n const [k, ...v] = part.trim().split(\"=\");\n if (k === key) return v.join(\"=\");\n }\n return \"\";\n}\nasync function getAuth(req) {\n const tok = readCookie(req, \"sid\");\n if (!tok) return null;\n const r = await sqlite.execute({\n sql: \"SELECT * FROM auth_tokens WHERE token = ?\",\n args: [tok],\n });\n const row = r.rows[0];\n if (!row) return null;\n if (row.kind === \"admin\") {\n return { kind: \"admin\", userId: null, name: \"المشرف\", pkey: null };\n }\n const u = await sqlite.execute({\n sql: \"SELECT name FROM users WHERE id = ?\",\n args: [row.user_id],\n });\n if (!u.rows[0]) return null;\n return {\n kind: \"user\",\n userId: Number(row.user_id),\n name: String(u.rows[0].name),\n pkey: \"u:\" + row.user_id,\n };\n}\nasync function actor(req, url, body) {\n const a = await getAuth(req);\n if (a) return a;\n const g = (body && body.guest) || url.searchParams.get(\"g\") || \"\";\n const nm = String(g).trim();\n if (nm) return { kind: \"guest\", userId: null, name: nm, pkey: \"g:\" + nm };\n return null;\n}\n\nasync function activeRoom() {\n const r = await sqlite.execute(\n \"SELECT * FROM room WHERE stage NOT IN ('cancelled','done') ORDER BY id DESC LIMIT 1\",\n );\n return r.rows[0] || null;\n}\nfunction voteEnded(room) {\n if (Number(room.vote_closed) === 1) return true;\n if (room.vote_ends_at && Date.now() >= Number(room.vote_ends_at)) return true;\n return false;\n}\nasync function choicesWithVotes(roomId) {\n const ch = await sqlite.execute({\n sql: \"SELECT * FROM l_choices WHERE room_id=? ORDER BY id\",\n args: [roomId],\n });\n const vt = await sqlite.execute({\n sql: \"SELECT choice_id, voter_name FROM l_votes WHERE room_id=?\",\n args: [roomId],\n });\n const map = {};\n for (const v of vt.rows) {\n (map[String(v.choice_id)] = map[String(v.choice_id)] || []).push(\n v.voter_name,\n );\n }\n return ch.rows.map((r) => ({\n id: r.id,\n name: r.name,\n votes: (map[String(r.id)] || []).length,\n voters: map[String(r.id)] || [],\n }));\n}\nasync function participantsOf(roomId, stage) {\n const ps = await sqlite.execute({\n sql: \"SELECT * FROM participants WHERE room_id=? ORDER BY joined_at\",\n args: [roomId],\n });\n const os = await sqlite.execute({\n sql: \"SELECT pkey, paid FROM l_orders WHERE room_id=?\",\n args: [roomId],\n });\n const has = {}, paid = {};\n for (const o of os.rows) {\n has[o.pkey] = true;\n paid[o.pkey] = Number(o.paid) === 1;\n }\n return ps.rows.map((p) => {\n let st;\n if (p.status === \"left\") st = \"left\";\n else if (has[p.pkey] && paid[p.pkey]) st = \"paid\";\n else if (\n has[p.pkey] &&\n (stage === \"ordered\" || stage === \"arrived\" || stage === \"done\")\n ) st = \"pending\";\n else if (has[p.pkey]) st = \"ordered\";\n else if (p.status === \"ordering\") st = \"ordering\";\n else st = \"joined\";\n return { name: p.name, status: st, is_guest: Number(p.is_guest) === 1 };\n });\n}\nfunction orderOwed(o) {\n return o.over_total != null ? o.over_total : o.total;\n}\n\nasync function sendPush(subs, payload) {\n const pub = Deno.env.get(\"VAPID_PUBLIC\"),\n priv = Deno.env.get(\"VAPID_PRIVATE\");\n if (!pub || !priv || !subs || !subs.length) return;\n let webpush;\n try {\n webpush = (await import(\"npm:web-push\")).default;\n } catch (_) {\n return;\n }\n try {\n webpush.setVapidDetails(\n Deno.env.get(\"VAPID_SUBJECT\") || \"mailto:admin@affoods.app\",\n pub,\n priv,\n );\n } catch (_) {\n return;\n }\n const data = JSON.stringify(payload);\n await Promise.allSettled(subs.map(async (row) => {\n try {\n await webpush.sendNotification(JSON.parse(row.sub_json), data, { TTL: 3600, urgency: \"high\" });\n } catch (err) {\n const code = err && err.statusCode;\n if (code === 404 || code === 410) {\n try {\n await sqlite.execute({\n sql: \"DELETE FROM push_subs WHERE endpoint=?\",\n args: [row.endpoint],\n });\n } catch (_) {}\n }\n }\n }));\n}\nasync function pushAll(payload) {\n const r = await sqlite.execute(\"SELECT * FROM push_subs\");\n await sendPush(r.rows, payload);\n}\nasync function pushOrderers(roomId, payload) {\n const os = await sqlite.execute({\n sql: \"SELECT DISTINCT pkey FROM l_orders WHERE room_id=?\",\n args: [roomId],\n });\n const keys = os.rows.map((x) => x.pkey).filter(Boolean);\n if (!keys.length) return;\n const subs = await sqlite.execute({\n sql: \"SELECT * FROM push_subs WHERE pkey IN (\" + keys.map(() =>\n \"?\"\n ).join(\",\") + \")\",\n args: keys,\n });\n await sendPush(subs.rows, payload);\n}\n\nasync function scrape(link) {\n const res = await fetch(link, {\n headers: {\n \"user-agent\":\n \"Mozilla/5.0 (iPhone; CPU iPhone OS 17_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0 Mobile/15E148 Safari/604.1\",\n \"accept-language\": \"ar-SA,ar;q=0.9,en;q=0.8\",\n \"accept\": \"text/html,application/xhtml+xml\",\n },\n });\n const html = await res.text();\n if (\n /just a moment|cf-chl|captcha|access denied|attention required/i.test(html)\n ) throw new Error(\"blocked\");\n const meta = (h, prop) => {\n const a = h.match(\n new RegExp(\n ']+(?:property|name)=\"' + prop + '\"[^>]+content=\"([^\"]*)\"',\n \"i\",\n ),\n );\n if (a) return a[1];\n const b = h.match(\n new RegExp(\n ']+content=\"([^\"]*)\"[^>]+(?:property|name)=\"' + prop + '\"',\n \"i\",\n ),\n );\n return b ? b[1] : \"\";\n };\n let name = \"\";\n const h1 = html.match(/]*>([\\s\\S]*?)<\\/h1>/i);\n if (h1) {\n name = h1[1].replace(/<[^>]+>/g, \"\").trim().split(/\\s+-\\s+/)[0].trim();\n }\n if (!name) {\n name = (meta(html, \"og:title\") || \"\").replace(/منيو التوصيل من\\s*/, \"\")\n .replace(/إطلب اونلاين من مطاعم\\s*/, \"\").replace(/\\s*في\\s+.*/, \"\").replace(\n /\\s*Delivery Menu.*/i,\n \"\",\n ).replace(/\\s*\\|.*/, \"\").trim();\n }\n const clean = (u) =>\n u\n ? u.replace(/&/g, \"&\").replace(/\\\\u002F/gi, \"/\").replace(/\\\\\\//g, \"/\")\n : \"\";\n const cover = clean(\n (html.match(\n /https:\\/\\/images\\.deliveryhero\\.io\\/image\\/[^\"'\\\\ )]*cover[^\"'\\\\ )]*/i,\n ) || [])[0] || meta(html, \"og:image\") || \"\",\n );\n const logo = clean(\n (html.match(\n /https:\\/\\/images\\.deliveryhero\\.io\\/image\\/hungerstation\\/restaurant\\/logo[^\"'\\\\ )]*/i,\n ) || [])[0] || \"\",\n );\n const rows = [];\n const seen = new Set();\n const priceOf = (n) => {\n const p = n.price ?? n.original_price ?? n.amount;\n return typeof p === \"number\" ? p : parseFloat(p);\n };\n const isItem = (n) =>\n n && typeof n === \"object\" && !Array.isArray(n) &&\n typeof (n.name ?? n.title) === \"string\" && (() => {\n const p = priceOf(n);\n return !isNaN(p) && p > 0;\n })();\n const pickImg = (n) => {\n const c = n.image ?? n.image_url ?? n.imageUrl ?? n.photo ?? n.picture;\n if (typeof c === \"string\" && c.startsWith(\"http\")) return c;\n if (c && typeof c === \"object\") {\n const u = c.url ?? c.src ?? c.href;\n if (typeof u === \"string\" && u.startsWith(\"http\")) return u;\n }\n return \"\";\n };\n const add = (n, cat) => {\n const nm = n.name ?? n.title, p = priceOf(n), key = nm + \"|\" + p;\n if (nm.length < 60 && p > 0 && !seen.has(key)) {\n seen.add(key);\n rows.push({\n name: nm,\n price: p,\n img: pickImg(n),\n desc: typeof n.description === \"string\" ? n.description : \"\",\n cat,\n });\n }\n };\n const walk = (node, cat) => {\n if (!node || typeof node !== \"object\") return;\n if (Array.isArray(node)) {\n for (const el of node) walk(el, cat);\n return;\n }\n const nn = node.name ?? node.title, ni = isItem(node);\n for (const k in node) {\n const v = node[k];\n if (Array.isArray(v) && v.some(isItem) && typeof nn === \"string\" && !ni) {\n for (const el of v) {\n if (isItem(el)) add(el, nn);\n else walk(el, nn);\n }\n } else walk(v, cat);\n }\n if (ni) add(node, cat || \"أخرى\");\n };\n const m = html.match(/\" +\n \"\";\n}\n\nconst PERSON_BODY =\n `

`;\n\nconst ADMIN_BODY =\n `

`;",[81],{"_35":80,"_13":81,"_62":82,"_64":-5,"_65":66,"_67":83,"_69":70,"_37":94,"_17":31,"_73":85,"_75":86,"_77":51,"_78":-5,"_91":95,"_18":96},{"_35":60,"_13":61,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_37":90,"_17":72,"_73":74,"_75":76,"_77":51,"_78":-5,"_91":92,"_18":93},["D",1783704656424],"children",[],[61],["D",1783702744328],[],[81],["D",1783460327132],"legacyEnvVars","httpPrivacy","description","تطبيق طلب اكل جماعي","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7077f4b0-0b72-480d-7175-ad5e8b41c800/square512?exp=1789577999&sig=7c94bb59ab41abb51c1dc4c084fad58293d5a4592b6a6138a5c788c67199ae5d","userId","76904432-f49a-4ba8-b504-369966016573","pinnedFileId","88a67dbc-7a4c-11f1-8037-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","b96d24c6342249c592ce0a67d4148546","tursoHostname","b96d24c6342249c592ce0a67d4148546-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789525245864],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_145":141},"org",{"_11":12,"_138":139,"_140":141,"_104":105,"_142":143,"_144":51},"branch",{"_17":68,"_13":16,"_35":66,"_42":43,"_45":36,"_46":134,"_135":53,"_136":43,"_137":56,"_57":14,"_54":12},55,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","mark hendrix","avatar","https://lh3.googleusercontent.com/a/ACg8ocI_0WbtTqX1bGlGaxjSvUmulKWTEMFx6815CDVEknoPQVYkgBc=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":43,"_13":14,"_37":187,"_49":-5,"_98":51,"_52":53,"_99":53,"_100":101,"_102":103,"_104":105,"_106":107,"_108":51,"_109":-5,"_110":-5,"_111":31,"_55":56,"_112":113,"_114":115,"_116":188,"_118":-5,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_128":189,"_130":190,"_132":191,"_50":51},[181,182],"files",[181,182],"counts",{"_171":31,"_172":33,"_173":31,"_34":174,"_175":176},[167,168],"upstreamProject","upstreamBranch",{"_35":36,"_37":165,"_39":166,"_13":41,"_42":43,"_17":44,"_45":-5,"_46":-5,"_47":48,"_49":-5,"_50":51,"_52":53,"_54":12,"_55":56,"_57":14},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1783460327137],["D",1783706916772],{"_35":80,"_13":81,"_62":82,"_64":-5,"_65":66,"_67":83,"_69":70,"_37":84,"_17":31,"_73":85,"_75":86,"_77":51,"_78":-5,"_18":170},{"_35":60,"_13":61,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_37":71,"_17":72,"_73":74,"_75":76,"_77":51,"_78":-5,"_18":169},[61],[81],"pulls","branches","forks",{"_177":179,"_180":31},"connections",{"_177":31,"_178":31},"count","unfilledCount",3,"emptyCount",{"_35":80,"_13":81,"_62":82,"_64":-5,"_65":66,"_67":83,"_69":70,"_37":94,"_17":31,"_73":85,"_75":86,"_77":51,"_78":-5,"_91":185,"_18":186},{"_35":60,"_13":61,"_62":63,"_64":-5,"_65":66,"_67":68,"_69":70,"_37":90,"_17":72,"_73":74,"_75":76,"_77":51,"_78":-5,"_91":183,"_18":184},[],[61],[],[81],["D",1783460327132],["D",1789525245864],{"_11":12,"_145":141},{"_11":12,"_138":139,"_140":141,"_104":105,"_142":143,"_144":51},{"_17":68,"_13":16,"_35":66,"_42":43,"_45":36,"_46":134,"_135":53,"_136":43,"_137":56,"_57":14,"_54":12},"ctx",{"_128":-5,"_162":225,"_226":227,"_228":229,"_230":51,"_231":51,"_232":51,"_233":70,"_234":-5,"_235":-7,"_236":-7,"_237":31,"_238":51,"_239":51,"_240":-5,"_241":51,"_242":51,"_243":51,"_244":-5},"ENV",{"_196":197,"_198":199,"_200":41,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224},"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"]