${title}

${subtitle}

${msg}

`;\n}\n\nasync function hashPattern(color:string, pattern:string) {\n const bytes = new TextEncoder().encode(`SAMI.TECH|${color}|${pattern}`);\n const digest = await crypto.subtle.digest('SHA-256', bytes);\n return Array.from(new Uint8Array(digest)).map(b => b.toString(16).padStart(2,'0')).join('');\n}\nfunction validPattern(pattern:string) {\n const parts = pattern.split('-');\n return parts.length >= 4 && parts.length <= 9 && parts.every(x => /^[1-9]$/.test(x)) && new Set(parts).size === parts.length;\n}\n\nconst html = `\nSAMI.TECH\n

☰ PARAMÈTRES

EN LIGNE

✓ ENREGISTRÉ

SCAN QR COLIS

Sélectionnez une couleur, scannez le QR puis entrez le montant du colis.

COLIS

ENVOYER LA LOCALISATION DU BUREAU

Saisissez le numéro puis appuyez sur WhatsApp ou Entrée.

SCAN QR

TRACKING : AUCUN

CADREZ LE QR CODE

Présentez le QR code du colis dans le cadre bleu.

MONTANT DU COLIS

TÉLÉPHONE CLIENT

SCHÉMA

Dessinez votre schéma.

HISTORIQUE DU JOUR

Sélectionnez une couleur.

$\"1984$

\n\n`;\n\napp.get(\"/\", async (c) => {\n c.header('Cache-Control','no-store, no-cache, must-revalidate');\n c.header('Pragma','no-cache');\n const state = await rootAccessState(c.req.header('cookie') || '');\n if (!state.configured) return c.html(accessPage('setup'));\n if (!state.valid) return c.html(accessPage('login'));\n return c.html(html);\n});\napp.get(\"/health\", (c) => c.json({ ok: true }));\n\napp.post(\"/api/access/setup\", async (c) => {\n if (await accessConfigured()) return c.redirect('/',303);\n const body = await c.req.parseBody();\n const code = String(body?.code || '').trim();\n const confirm = String(body?.confirm || '').trim();\n if (!/^[0-9]{4,8}$/.test(code)) return c.html(accessPage('setup','Le code doit contenir de 4 à 8 chiffres.'),400);\n if (code !== confirm) return c.html(accessPage('setup','Les deux codes ne correspondent pas.'),400);\n const salt = randomHex(16);\n const codeHash = await hashText(salt+'|'+code);\n await sqlite.execute({sql:'INSERT INTO app_access (id,salt,code_hash,updated_at) VALUES (1,?,?,?)',args:[salt,codeHash,Date.now()]});\n const token = randomHex(32);\n const tokenHash = await hashText(token);\n const expiresAt = Date.now() + 12*60*60*1000;\n await sqlite.execute({sql:'INSERT INTO access_sessions (token_hash,expires_at) VALUES (?,?)',args:[tokenHash,expiresAt]});\n const res = c.redirect('/',303);\n res.headers.append('Set-Cookie',`sami_session=${encodeURIComponent(token)}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=43200`);\n return res;\n});\n\napp.post(\"/api/access/login\", async (c) => {\n if (!(await accessConfigured())) return c.redirect('/',303);\n const now = Date.now();\n const key = clientKey(c);\n const failed = await sqlite.execute({sql:'SELECT attempts,locked_until FROM access_failures WHERE client_key=?',args:[key]});\n let attempts = failed.rows.length ? Number((failed.rows[0] as any).attempts || 0) : 0;\n let lockedUntil = failed.rows.length ? Number((failed.rows[0] as any).locked_until || 0) : 0;\n if (lockedUntil > now) {\n const seconds = Math.max(1,Math.ceil((lockedUntil-now)/1000));\n return c.html(accessPage('login','Trop de tentatives. Réessayez dans '+seconds+' seconde(s).'),429);\n }\n if (lockedUntil > 0 && lockedUntil <= now) attempts = 0;\n const body = await c.req.parseBody();\n const code = String(body?.code || '').trim();\n const cfg = await sqlite.execute('SELECT salt,code_hash FROM app_access WHERE id=1 LIMIT 1');\n const salt = String((cfg.rows[0] as any).salt || '');\n const expected = String((cfg.rows[0] as any).code_hash || '');\n const actual = await hashText(salt+'|'+code);\n if (!/^[0-9]{4,8}$/.test(code) || actual !== expected) {\n attempts += 1;\n const newLock = attempts >= 5 ? now + 5*60*1000 : 0;\n const storedAttempts = attempts >= 5 ? 0 : attempts;\n await sqlite.execute({sql:'INSERT INTO access_failures (client_key,attempts,locked_until,updated_at) VALUES (?,?,?,?) ON CONFLICT(client_key) DO UPDATE SET attempts=excluded.attempts,locked_until=excluded.locked_until,updated_at=excluded.updated_at',args:[key,storedAttempts,newLock,now]});\n return c.html(accessPage('login',attempts >= 5 ? 'Accès bloqué pendant 5 minutes.' : 'Code incorrect.'),401);\n }\n await sqlite.execute({sql:'DELETE FROM access_failures WHERE client_key=?',args:[key]});\n await sqlite.execute({sql:'DELETE FROM access_sessions WHERE expires_at<=?',args:[now]});\n const token = randomHex(32);\n const tokenHash = await hashText(token);\n const expiresAt = now + 12*60*60*1000;\n await sqlite.execute({sql:'INSERT INTO access_sessions (token_hash,expires_at) VALUES (?,?)',args:[tokenHash,expiresAt]});\n const res = c.redirect('/',303);\n res.headers.append('Set-Cookie',`sami_session=${encodeURIComponent(token)}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=43200`);\n return res;\n});\n\napp.post(\"/api/access/logout\", async (c) => {\n const token = readCookie(c.req.header('cookie') || '','sami_session');\n if (token) await sqlite.execute({sql:'DELETE FROM access_sessions WHERE token_hash=?',args:[await hashText(token)]});\n const res = c.redirect('/',303);\n res.headers.append('Set-Cookie','sami_session=; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=0');\n return res;\n});\n\napp.use('/api/*', async (c,next) => {\n const path = new URL(c.req.url).pathname;\n if (path.startsWith('/api/access/')) return next();\n if (!(await validSession(c.req.header('cookie') || ''))) return c.json({success:false,error:'Accès verrouillé'},401);\n await next();\n});\n\napp.get(\"/api/admin/settings-status\", async (c) => {\n const cfg = await sqlite.execute('SELECT 1 FROM settings_access WHERE id=1 LIMIT 1');\n return c.json({configured:cfg.rows.length > 0});\n});\n\napp.post(\"/api/admin/settings-setup\", async (c) => {\n try {\n const existing = await sqlite.execute('SELECT 1 FROM settings_access WHERE id=1 LIMIT 1');\n if (existing.rows.length) return c.json({success:false,error:'Le code PARAMÈTRES est déjà configuré.'},409);\n const body = await c.req.json();\n const appCode = String(body?.appCode || '').trim();\n const settingsCode = String(body?.settingsCode || '').trim();\n if (!/^[0-9]{4,8}$/.test(appCode) || !/^[0-9]{4,8}$/.test(settingsCode)) return c.json({success:false,error:'Les codes doivent contenir de 4 à 8 chiffres.'},400);\n if (appCode === settingsCode) return c.json({success:false,error:'Le code PARAMÈTRES doit être différent du code de l’application.'},400);\n const appCfg = await sqlite.execute('SELECT salt,code_hash FROM app_access WHERE id=1 LIMIT 1');\n if (!appCfg.rows.length) return c.json({success:false,error:'Code d’accès application non configuré.'},409);\n const appActual = await hashText(String((appCfg.rows[0] as any).salt || '')+'|'+appCode);\n if (appActual !== String((appCfg.rows[0] as any).code_hash || '')) return c.json({success:false,error:'Code application incorrect.'},401);\n const salt = randomHex(16);\n const codeHash = await hashText(salt+'|'+settingsCode);\n await sqlite.execute({sql:'INSERT INTO settings_access (id,salt,code_hash,updated_at) VALUES (1,?,?,?)',args:[salt,codeHash,Date.now()]});\n return c.json({success:true});\n } catch (_) {\n return c.json({success:false,error:'Impossible de créer le code PARAMÈTRES.'},500);\n }\n});\n\napp.post(\"/api/admin/settings-unlock\", async (c) => {\n try {\n const cfg = await sqlite.execute('SELECT salt,code_hash FROM settings_access WHERE id=1 LIMIT 1');\n if (!cfg.rows.length) return c.json({success:false,setupRequired:true,error:'Code PARAMÈTRES non configuré.'},409);\n const body = await c.req.json();\n const code = String(body?.code || '').trim();\n if (!/^[0-9]{4,8}$/.test(code)) return c.json({success:false,error:'Code PARAMÈTRES incorrect.'},401);\n const now = Date.now();\n const key = 'settings:'+clientKey(c);\n const failed = await sqlite.execute({sql:'SELECT attempts,locked_until FROM access_failures WHERE client_key=?',args:[key]});\n let attempts = failed.rows.length ? Number((failed.rows[0] as any).attempts || 0) : 0;\n let lockedUntil = failed.rows.length ? Number((failed.rows[0] as any).locked_until || 0) : 0;\n if (lockedUntil > now) {\n const seconds = Math.max(1,Math.ceil((lockedUntil-now)/1000));\n return c.json({success:false,error:'PARAMÈTRES bloqués. Réessayez dans '+seconds+' seconde(s).'},429);\n }\n if (lockedUntil > 0 && lockedUntil <= now) attempts = 0;\n const actual = await hashText(String((cfg.rows[0] as any).salt || '')+'|'+code);\n if (actual !== String((cfg.rows[0] as any).code_hash || '')) {\n attempts += 1;\n const newLock = attempts >= 5 ? now + 5*60*1000 : 0;\n const storedAttempts = attempts >= 5 ? 0 : attempts;\n await sqlite.execute({sql:'INSERT INTO access_failures (client_key,attempts,locked_until,updated_at) VALUES (?,?,?,?) ON CONFLICT(client_key) DO UPDATE SET attempts=excluded.attempts,locked_until=excluded.locked_until,updated_at=excluded.updated_at',args:[key,storedAttempts,newLock,now]});\n return c.json({success:false,error:attempts >= 5 ? 'PARAMÈTRES bloqués pendant 5 minutes.' : 'Code PARAMÈTRES incorrect.'},401);\n }\n await sqlite.execute({sql:'DELETE FROM access_failures WHERE client_key=?',args:[key]});\n return c.json({success:true});\n } catch (_) {\n return c.json({success:false,error:'Impossible de vérifier le code PARAMÈTRES.'},500);\n }\n});\n\napp.post(\"/api/admin/change-access-code\", async (c) => {\n try {\n const body = await c.req.json();\n const currentCode = String(body?.currentCode || '').trim();\n const newCode = String(body?.newCode || '').trim();\n if (!/^[0-9]{4,8}$/.test(currentCode)) return c.json({success:false,error:'Code actuel incorrect.'},401);\n if (!/^[0-9]{4,8}$/.test(newCode)) return c.json({success:false,error:'Le nouveau code doit contenir de 4 à 8 chiffres.'},400);\n if (currentCode === newCode) return c.json({success:false,error:'Le nouveau code doit être différent du code actuel.'},400);\n const cfg = await sqlite.execute('SELECT salt,code_hash FROM app_access WHERE id=1 LIMIT 1');\n if (!cfg.rows.length) return c.json({success:false,error:'Code d’accès non configuré.'},409);\n const salt = String((cfg.rows[0] as any).salt || '');\n const expected = String((cfg.rows[0] as any).code_hash || '');\n const actual = await hashText(salt+'|'+currentCode);\n if (actual !== expected) return c.json({success:false,error:'Code actuel incorrect.'},401);\n const settingsCfg = await sqlite.execute('SELECT salt,code_hash FROM settings_access WHERE id=1 LIMIT 1');\n if (settingsCfg.rows.length) {\n const sameAsSettings = await hashText(String((settingsCfg.rows[0] as any).salt || '')+'|'+newCode);\n if (sameAsSettings === String((settingsCfg.rows[0] as any).code_hash || '')) return c.json({success:false,error:'Le code de l’application doit être différent du code PARAMÈTRES.'},400);\n }\n const newSalt = randomHex(16);\n const newHash = await hashText(newSalt+'|'+newCode);\n const now = Date.now();\n await sqlite.execute({sql:'UPDATE app_access SET salt=?,code_hash=?,updated_at=? WHERE id=1',args:[newSalt,newHash,now]});\n await sqlite.execute('DELETE FROM access_sessions');\n await sqlite.execute('DELETE FROM access_failures');\n const token = randomHex(32);\n const tokenHash = await hashText(token);\n const expiresAt = now + 12*60*60*1000;\n await sqlite.execute({sql:'INSERT INTO access_sessions (token_hash,expires_at) VALUES (?,?)',args:[tokenHash,expiresAt]});\n const res = c.json({success:true});\n res.headers.append('Set-Cookie',`sami_session=${encodeURIComponent(token)}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=43200`);\n return res;\n } catch (_) {\n return c.json({success:false,error:'Impossible de modifier le code d’accès.'},500);\n }\n});\n\napp.get(\"/api/debug/status\", async (c) => {\n const started = performance.now();\n const dbStarted = performance.now();\n await sqlite.execute('SELECT 1 AS ok');\n const sqliteMs = Math.round((performance.now() - dbStarted) * 10) / 10;\n const totalMs = Math.round((performance.now() - started) * 10) / 10;\n return c.json({ok:true,serverTime:new Date().toISOString(),sqliteMs,totalMs});\n});\n\napp.get(\"/api/pattern/status\", async (c) => {\n const color = String(c.req.query('color') || '').trim().toUpperCase();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(color)) return c.json({configured:false,error:'Couleur invalide'},400);\n const result = await sqlite.execute({sql:'SELECT 1 FROM color_patterns WHERE color=? LIMIT 1',args:[color]});\n return c.json({configured:result.rows.length > 0});\n});\napp.post(\"/api/pattern/verify\", async (c) => {\n try {\n const body = await c.req.json();\n const color = String(body?.color || '').trim().toUpperCase();\n const pattern = String(body?.pattern || '').trim();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(color) || !validPattern(pattern)) return c.json({success:false},400);\n const result = await sqlite.execute({sql:'SELECT pattern_hash FROM color_patterns WHERE color=?',args:[color]});\n if (!result.rows.length) return c.json({success:false,configured:false},200);\n const expected = String((result.rows[0] as any).pattern_hash || '');\n const actual = await hashPattern(color,pattern);\n return c.json({success:actual === expected,configured:true},200);\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err)},500);\n }\n});\napp.post(\"/api/admin/pattern/set\", async (c) => {\n try {\n const body = await c.req.json();\n const color = String(body?.color || '').trim().toUpperCase();\n const pattern = String(body?.pattern || '').trim();\n if (String(body?.confirm || '') !== 'SET') return c.json({success:false,error:'Confirmation invalide'},400);\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(color)) return c.json({success:false,error:'Couleur invalide'},400);\n if (!validPattern(pattern)) return c.json({success:false,error:'Schéma invalide'},400);\n const patternHash = await hashPattern(color,pattern);\n await sqlite.execute({sql:'INSERT INTO color_patterns (color,pattern_hash,updated_at) VALUES (?,?,?) ON CONFLICT(color) DO UPDATE SET pattern_hash=excluded.pattern_hash,updated_at=excluded.updated_at',args:[color,patternHash,Date.now()]});\n return c.json({success:true});\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err)},500);\n }\n});\napp.post(\"/api/admin/reset-dedup\", async (c) => {\n return c.json({success:true,deleted:0,localOnly:true});\n});\napp.post(\"/api/reserve\", async (c) => {\n try {\n const body = await c.req.json();\n const user = String(body?.user || \"\").trim().toUpperCase();\n let value = String(body?.value || \"\").trim();\n if (body?.manualPhone) {\n let phone = value.replace(/[^0-9]/g,'');\n if (phone.startsWith('00')) phone = phone.slice(2);\n if (/^213[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone.slice(3);\n else if (/^[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone;\n value = phone;\n }\n const scanId = String(body?.id || '').trim();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(user)) return c.json({success:false,error:'Utilisateur invalide'},400);\n if (!value) return c.json({success:false,error:'Numéro vide'},400);\n if (!scanId) return c.json({success:false,error:'scan_id manquant'},400);\n return c.json({success:true,reserved:true,synced:false,localOnly:true},200);\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err)},200);\n }\n});\n\napp.post(\"/api/scan\", async (c) => {\n try {\n const body = await c.req.json();\n const user = String(body?.user || \"\").trim().toUpperCase();\n let value = String(body?.value || \"\").trim();\n if (body?.manualPhone) {\n let phone = value.replace(/[^0-9]/g,'');\n if (phone.startsWith('00')) phone = phone.slice(2);\n if (/^213[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone.slice(3);\n else if (/^[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone;\n value = phone;\n }\n const scanId = String(body?.id || '').trim();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(user)) return c.json({success:false,error:'Utilisateur invalide'},400);\n if (!value) return c.json({success:false,error:'Numéro vide'},400);\n if (!scanId) return c.json({success:false,error:'scan_id manquant'},400);\n\n const form = new URLSearchParams();\n form.set('user', user);\n form.set('color', user === 'ANIS' ? 'BLEU' : user === 'RACIM' ? 'ORANGE' : user);\n form.set('tracking', value);\n form.set('phone', String(body?.phone || ''));\n form.set('amount', String(body?.amount || ''));\n form.set('scan_id', scanId);\n form.set('timestamp', String(body?.timestamp || Date.now()));\n form.set('timezone', String(body?.timezone || 'Africa/Algiers'));\n\n const r = await fetch(GOOGLE_SCRIPT_URL, {\n method: 'POST',\n headers: {'Content-Type':'application/x-www-form-urlencoded;charset=UTF-8'},\n body: form.toString(),\n redirect: 'follow'\n });\n const text = await r.text();\n let data:any;\n try { data = JSON.parse(text); } catch { throw new Error('Réponse Google invalide'); }\n if (!data?.success) throw new Error(data?.error || 'Échec Google Sheets');\n return c.json(data);\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err),debug:true},200);\n }\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","import { Hono } from \"npm:hono\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst app = new Hono();\nconst GOOGLE_SCRIPT_URL = \"https://script.google.com/macros/s/AKfycbwo2Z_aVnoqofRQ-c8gEoWruUCelChlkXy1PJe-O1sle6jhffM1tClWS0UEDH-YYav1/exec\";\nconst APP_LOGO = \"data:image/webp;base64,UklGRmYVAABXRUJQVlA4IFoVAACwTQCdASrAAMAAPm0wlUckIqIhKhiKgIANiWhu9H/OPo2l8TYF5k/lvy09mOvv5ryKdGMWXuazt/67/O/173R/2r/NewT+vXnk+qDzAfzv/RfsB70//L9Un+I9QD+yf7LrMPQI8t39zfhH/tP/R/dH2pP//7AHoAf/Thbu4D9VPGnybfA/cv2AMy/Xjqd9sf8fy5/3n928Y/iZqBez/9R6KXz3Z47N/oPQC93fsH/C8Iv/K/vvqL9b/+H7gH8n/rn/T9af8Z4NH2//Tf7L3AP5b/WP+B/lv7n+53xp/8v+J/MD23fRP/Y/yXwG/zr+uf7T+6/5b9pvnd9nf7W+zT+2bPvmKYmbgTA1ms1tqFTrO6xtEjqCwNfWuIe+5UgQenEpkIvdBEZ/UE9I2Rhx6A9iMtKuieOO/G2FP9z4jPG3uqCkBg9dWkeoWuVtXT81RMfaofr4dyrAtq/DUkDVse0YuSJtbDchHXG6zCXH2QMv+gYfcWWh+uU4vhUoK0IpSzkii1f7Bgw7RgWGsYVDFKflCkY6yakIsVuy0AnjN8tDLUoTZDfc7AEwnJalU2gwk15H/5YubdLOOBxGsOA15yABlJDRqkztCsD6SDC6C8tUdZc38ONiw0ajxQ4RfmFz5l3oafujoePNKmSo2UVgCwNQx3T3ZHjiIyxn6WAjNW7S+ykm8OmMw+8nA98HgOR3ZSLbmiuZfCkTFks28w3lh43kL+JCxDIpzw+cKv3kFC0zLdWDVRj53cKsHoxZKicESvC0qHn26APz4htm3WrcWPrV+p7isY6dLI5TY26LfNWWFJUiALKW0xdcD/QrgYvfTbGnE4nFjAAA/vzxo7wKALtMFX0oth0VCD7GTwy9Ur7eCUJXU8wefnH425TZ8a5l5v+LkuVOEdGoiGjyn+c2kA+DtHcHpGFgyGRljcByPq3qXCiQbwAQUIYqq7cacmvQzhXm9loLwe0/HLcGrD3wA9VQFu/uMhVZA9ZsaEr03FCaR69p5jdllmrt0cVaiWHkAmw9d1U1RBvaj+hu+J7K/UGcQaf2VdeRNDtut43g3/7011JT0zWtv47/Pg+dsnwbV+u+bw7kVvbj8+8Ff7sqp0wgqlix9+rohZyj5NP3f4NCPZb0Colrix+Qi5Lw12XebY2DWclhvm02uHsK4/qk27lqJAwbTf03VraatV4MhmnKUeCoXbi+asnPZR15n5VJvRDVjII+S3i2K4TuAK9tgm+PyrKGLkc9mGWrqkC2BqnXHVj5eeTByWRjVe1pqDMlPKo73yjo30+3+AETLTVmhiCu6ttCkxveoosaHbyL+oCbKnSY28uydvCFT+LKXwV64OC2Bnc600AzXRsu8f4iFULMbEAqOKchNq9qxH0DP71JIKgMtfrjfAToqX1oh2b3EVX67Jnneiab+9mjzusC1P8EfmUB1OOv0bpHRaVshlxf5EKHA2FKkiv5B6jKJ+7Kqz0mYkGQ2tGkAR6fR8QSkaG6R3TZ3vjtKgX8U5TWjuLlAhCoyLmS3uLqPt/W/h9q+wunvummgFCKHu3hgur/rlmYPR2FaxNMiuN7o2WdBTxTCQB9m1gCj7MxfF8qGsAfR73/wsq04LEe/twQ7soYsP6EsdG16ZBGh8lbTHxlgwwRIXIj1rHdvJBAFM/1cXkkIUdWFzy4RL8AyKpUgcxvSrBo1UxNBuMtqBRVU3QmjaSWGhtJF1Fh+PWieah9bQp46FXkTbsXSB00G0TVHIEOPvE8kxgWCbcoxhNzPq+gaM9j56qMj75rHBhoRLSbOFm6ZHZxY7z4hY089IuLrPB1TTrAwLdZEABgMZFMLWsdFtCATV+iyPeOGvnLHp/w1Kx/iI8JM2ZEigaT+PB7mHP83qq3gpBM8Lp5baZ/7ANtJVglq/bEpYcYqOAvKXCtsL4ah/7bYM83U/tGeacnUpOXrGqCn6IlklYz18iDSpc9O9C0dTECZgN7Ez7FpNPEsWosmNiShxxpBhA46CpdIuRMVpUJWD8LcOCgFWraLi3AAW7egrvgLXaM05q0d4MTSrY20p3UyIsz0BLZz4hI+Er4BgrD9OH5KZEOL56bookrOAHCP5jBCEucrpDEjO6slMdHzJPv0lNckyCTdvvrCmsL+ebyzpvLnrNFAth+ba7b/SpXcCv4BcaA7IoyKdY/EXkJlkPL6YozsZSvDuV/Fp+yhcM8J4Ql9+nHsnrjutdp2nNXpOLq3WdVcPoynX6GQW5wJbZ+IHs9tTpG7qUg+44SX6bmTwxicS6fKfXQNqFNBqe67kPJXhBHPTdkHHVSPWNM1uKIvacZU9ENti035eymszIEu6GcX4cTjbnR3HfMl/Ree6noeRwurxi91fUDb6M8qMhg9Z5mgc5exppEVi8xAurnYG1sB5HByKEDZN9phPgcbuaBRZyHGhLTScYRT07BslX1cv9xZStG+Iu6+xJMXEHfpRYv6D+La2FPsZWetFlnIrvGmAezKlBPwCj+nnx7fBQuPr2yhnu29+1rLiJw4K/lv9xn1u+bEWp/mMiF9sYcaZfdQjpU7chT+I1TNPakVa3IbYfgJ7Xkt+1VrVnqzmoVyC6so69sblBI8EjlZQZlhnQHxe5oV7o++6Z7c+8fNsQlLKaNmvnrn3Rt34trA0foIUm/NRcQp5RE54IXajzOq2/9/I1cfr94GXUMqJ8dOX06bE07WPm3faDzqFl/Xb8MCUreZMq3pkEv9Qswb0rETz+RDDcGUGjlTmPzCOlUzFnBP4ms6WmA5F/BjxeqDTlRdKyIYaX56hW72C9P6mlmSB44nOd75dWwY1ZRk+LcaS1LP9C//h7gte2AUd1S+CN3mlnrwlGS/Ig+OH42a0lhpU3U75ujQOoMy/9bCG6jVUSGyYx6cRz1Pl7E/t8z7E5deuKPFzfVs1bwnCs6rlYYLp65YRYH3FzFn3LjIRkn090+r75Q0c9fQnMX/OGHYrmOYV6BpbmV9S5HGSmGh8BRGSqwDQ4mQg/ka3VTO6dwsOgurvEUwFIh1vg+84LrE3VQEnMdC+ay22hjcoGJNzqr2+jrtxm1hkzDbekUzoPOuv7+cCbnaVuEvMQqrX/F2Hntha9iOQ81KJnERL1qlOnWNJSKnq3TI41rUCdp8BiDHSVKbmQb75c+6siJJkVmbMUKAvRtsWlcY0IOkc02FHyv4gQ1jyePO4LIhVUrdpCjBeN+L4bKMf6S7RsEyM6M9S+zMqNkFBeF0PQc37VOuuZbY8YsdVQuj4dSAyjPZ+bx5+4m+Arw7U+qSglcov45hIHALHJ5kCm6EBR9rDIOOrNvAQgrSpJyVJSMw0MCTpfTG0fJ7LyNN1omr0SAWQQ3r/gl3Am5nwiRvYAopXb8+z4qNp3YEhqdqM0YNt5EbnyQz09voK0ryHrTD8fQd2R0AVkl7IgHMrGNENzN35N78k5pWYnNoGJ32yFJ5Z9/m6aOiBnaOwf0lMcd8S2XckuUSMlwdU3SE3GTzdp2DgKUkHYslhaEMlY+2egvGoG/bMuSm1NNltuxSci+lkJf2VZpT46Ub7vVMuXA+Qcdvkp0eZuDv33np/Bm+tIHNLZuvf7zPNEBZnOnYadEuktYhaLBYJCCnPJ9jBf6BwnE04xE0iMUGG6+x098fID+DS8nLpOot77PIXhE6DkhueECV9vpqelwBTBOlhVm/o423rwTBdFGUXgdwwxeyObaHNMq5hI/2rZfnABGrR3FZKxX8jyiG7Db+gf3Z6uFsQih+IsLDHw5e6qj/k7/o8eYwDXz5IsqbG+7D9FLwdL9lIilJBUoTrODliMANKbmpZfxZLIkHag9WFFHr/vwkvosocnFZReot+G5byZUkZjO5H+7oUyYDvvy6YteN/U1KCaAAK2FOWQG4KW1gAg8zBwa6Xx+LyWuFUF7ZbCj8ONnQlg96bc1rTTJ1hWuE/Zef+B1bIo+dDlaFkXW7UcboLy9QPNaX5R6OUkQPWekb2yy2cC1U3lSTQoD+0Ot2gfp1uA3XSpJsWA/WRqyB6nV2D+CkKRNX49JWrKXk73ryzYMpNp3iL+I/1dzYQTpCC9RILpvA+rm/NtqFfz0pcfmJ7AfBppmOOTPKhMlv4IVJPm5mcsqWBEnW2AoyZcvdERUh+s+jnZY9zrY8FnTyxxUUbMOcw/Gurj9iKgSYkpJwrDSY5hl3zwGgBRfI4dZ0VPQ0Ci/dLIvYdRiO/f4PKDVPjf7+Mc8lUNQSgXuPDqnMrYKhZowE4Q4mpSK+vtIDvEJtiWmjIMb4/ZjqlEizOAgmwAQSkMSpO/9VzSwSfVpAYdikdNSKiPKonppA2HT5oIx3dSteXBnCs3vLC2M6zwtR1HvhZ0SmwFwzcKyOI7N51u8AsSfbAfoPpzOvUaY4IgmG7mZt52HYebT7jS8p5o5w3mIPTfDmPDpczB142l+W/6chA+sjsmwgyIWBm7dI1RJwOarCHWFqInWbnipGyzwN0oxaK8fYc++RGrb+5m5Xc0nsLL+dhjzlt7gU6K75zx+mn74WTioDhfXmA7/ZcWKu1hCF18crcH6YsYxEftH6Zn0ki88ai9PcWjWdfmv+De0buDaCSy+CHi3ePdRcNEiPDyDpu5z9ms+C3qvGAgQDEb+CXZzNVD+9WcNiX7cp9Hx3abulN3rPI1Q/iP0JRiNx572uxBcT47qPi4ARBIUsjlWhr791X/NCuT/9smqDmdUEofGiUDaedr/zKONZYWunp1mHDfwsJ0pM9uv56AdxWAmyO87N2jHOoqnD/vcor2P2f6g3/VLJCtpLPKdfnpa1wmChARPDfch/a/3kSRePFj5GuUd8MFEWSwICheKlDen04XxIZOhMyid0BIYMPM4o6lI9kdso20ta65jARF8Jv/LpwktR9tCXUGt7Gpt7hInh+DZYgmYW64PPDUGTR85kZunEC5BiSKZ5MIeDw2LFrGzZKNOReSlBZx0JSVNb2apuk0DGf2WeM6yr3txiNUhRX0uvimMewFhQAEDdGYIPiTu/He6QLL8ldjU84Y77y/ojMS7FRaX4T4ZdtPQnwTKu4xjsPamwo1cYQgdtyUJW9ImEWWoMJyRWmQq79wLdo03eOiXwZcYS75HzEWEHm41zUp8UR1oY5dcld1h1cAKSJWWIyGAubJ52PRr4Xh+TsbjqnhZPf+80UTBuqZj2ai3vjawSdFCsjJJ1ANR7tDDdGP8/ga3/l22DbnCPnjYB2OkJQxqutOAbC3bk74EH00xhgkN7T9C81Q0BgM69JkF5rQOzrIgCpVkbrsTfP8+4fWFMG3+HGz9LFfzL3v3Zl1Qexx5qiiw1oaBX2bjiQn6G9N7F4MLpHvmZyN1PPs7TfGh7/jAAnWKhRIAIi7DvUfQU/u6hGu0NY4r11/A/f1gE2oYxFQB1k1o5sjlTBAxI4TKJs9Ybx2k4dfX78kav80ztpbvHjLhIaZWc3atdcQo2dqQT7JxvgllMt+JPk4PyVOpNk+87h231GxYdwT4/3nfbFRd8xwdqmjwxFdaAJAs6U2AgPvmVi89X/zGiXvPBZNVvin0mhwRwY3NZOI++vF0UPqlFrXfJj+DBe87yzVXmkfezGFx03DzyUDRVVua2Bv8fW61HpNpgv544sn51fRIo/wYQ3qfxF8kXI7o7/40SSRdXuuKDYrDORs0rWS3QvBLmQi4+QVBujnPR4q74Hd+Ml0BazcL2wbHRlBJNJDMWcZlzQK/9TG1jS3ogLMmQR9fNwDKrKB2sO2Nx4W7W3mpeKZI97ijAbd4q3zblfwbiP3QSOSfmeep2SbIxs7B5Gi1tgb4D2YwnfWDlR9RiPXaF4SfA/Ac9ARr8NOoRErEwu2LLnQsT92mLEXzIjYiGAcDd4jFLz20AoOPuyySG3wyTY2chf89XkxXwwG94DLk+0hs96clSDJmCo3T7C8bBb5w7/m9MMBOdUHq88JU1fQWZVT4vPd4DEI7UeHOOleBsejNdcrpVSrcwzyppTQpfNfBbyb+zXLR59N1617wI1phkvLF+lYjZ3mD4VuGjLfBYfZu3MpWKg7mC3J03JNp2pEJkc/3EvE85ZiUAa+J+pe4waul1xqz3bIxCaJMlcE664xabgMTU74xwVvYt/YoZIiPLESGaTC7AcgGnzAv9Dy9hhVDw5Leh3Db4eHYTDqqpqRodGHRy+8i5G5/GmbycchVltPoUtwd8NtbSrPTSVGN8Yhc9ohlaVf2Kh+Pu8DtgPC0TUb75lagaSv7daYvbu/dgOyCnqr7LQ8+C35s5nB2+I9gdnZguEIQGhv6e/+2XMFyP8wdt/S26COF3kr1eHYAm2blFujpHdzjzQXrk++A0PDE8r64qVnKLJ16ae5vgCAM4hYKqK3sanh2P0h4FDIAET1MfFDoM+UXMWZjhWOwAmJmUBBbRsCd9U+y7JrMjLdQg9CURwQX21cn0FfWbX4VLB6aZBjZY5CT5t6w7G6ua9Dylxy8Ix9+k3dt4q7Imv+xOTyx2WFnUmiRfp8RYZC1nBvCgzZqxsMyCtGC3Ii80OQclAV+FdE0Shv5ZIkGJ6iDr9KelvgKzX67jpckJyeKQysCMTplhSnYKVjUbhgolnkjWCy2GK9cggBR7RQObpBTMDiRSfiq8c/VF4kHbx+w8TzCYPVbC1jkPz5kH9pVNzINCcK4hkm6tFkkaKC9x/jpBjq1Qi6Cq3FIEF7jFzvXI1zaHykAzYMiZWUPtW2gXC/734IkrFf9z9mYDAvVMcIk9VybZkhbfRpEH6WPFHXroSPY8NBadDQcyp9SE83O+SojiIFHjhmvIZh8JGIlfPIwRpPTKvf7TCqG60kQhCpHeHxTlozMGrUcovY009jRjLv2fjJteymOLHO7lG2WKADtZVvmVm7KoS+w0pS6mYUO5kwxAs5Tw8/O/j+WsEqeJ9S44M2h9blIjqdWpjgcmr0IEEIirhQ7vMW5k+ygQ8pg6agCj44rzcrMKykRbuUxhQvfzqEDE+WFG3a+epGRr6JdkDM8dmSqjNSVjtt8t/Tl5DZFmIRq1I2fuTdMSLQ1Dy/2PJqMdwr5qvyPaMyuUJsQUQ8p5GCGkZd1Q79Pw8IPTFSb6Ij9vMxi9T5pAGMtR9JCRAZDVh4q9Ibmu0ZaDNc7crxb1V//lq9PmaNwXKO4wb//VSh72nwSN24eiwBIgmM7ACJuor1OLLtYqlodabu8n8fQksctKPvuBesiVAx61SgMjYOLAqO5Mcj1i09T9qDMOdQXDt1LVNz2nJGXOb1eQkLCWbzmFkLcC9dZnlsj2bkKPAFdXwCXoy4TWMgPaqkAAAA=\";\n\nlet schemaReady = false;\nasync function ensureSchema() {\n if (schemaReady) return;\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS color_patterns (\n color TEXT PRIMARY KEY,\n pattern_hash TEXT NOT NULL,\n updated_at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS app_access (\n id INTEGER PRIMARY KEY CHECK(id=1),\n salt TEXT NOT NULL,\n code_hash TEXT NOT NULL,\n updated_at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS access_sessions (\n token_hash TEXT PRIMARY KEY,\n expires_at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS settings_access (\n id INTEGER PRIMARY KEY CHECK(id=1),\n salt TEXT NOT NULL,\n code_hash TEXT NOT NULL,\n updated_at INTEGER NOT NULL\n )`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS access_failures (\n client_key TEXT PRIMARY KEY,\n attempts INTEGER NOT NULL,\n locked_until INTEGER NOT NULL,\n updated_at INTEGER NOT NULL\n )`);\n schemaReady = true;\n}\n\nasync function hashText(value:string) {\n const bytes = new TextEncoder().encode(value);\n const digest = await crypto.subtle.digest('SHA-256', bytes);\n return Array.from(new Uint8Array(digest)).map(b => b.toString(16).padStart(2,'0')).join('');\n}\nfunction randomHex(bytes=32) {\n const buf = crypto.getRandomValues(new Uint8Array(bytes));\n return Array.from(buf).map(b => b.toString(16).padStart(2,'0')).join('');\n}\nfunction readCookie(header:string, name:string) {\n for (const part of String(header || '').split(';')) {\n const i = part.indexOf('=');\n if (i < 0) continue;\n if (part.slice(0,i).trim() === name) return decodeURIComponent(part.slice(i+1).trim());\n }\n return '';\n}\nasync function accessConfigured() {\n try {\n const r = await sqlite.execute('SELECT 1 FROM app_access WHERE id=1 LIMIT 1');\n return r.rows.length > 0;\n } catch (_) {\n await ensureSchema();\n const r = await sqlite.execute('SELECT 1 FROM app_access WHERE id=1 LIMIT 1');\n return r.rows.length > 0;\n }\n}\nasync function validSession(cookieHeader:string) {\n const token = readCookie(cookieHeader,'sami_session');\n if (!token) return false;\n const tokenHash = await hashText(token);\n try {\n const r = await sqlite.execute({sql:'SELECT 1 FROM access_sessions WHERE token_hash=? AND expires_at>? LIMIT 1',args:[tokenHash,Date.now()]});\n return r.rows.length > 0;\n } catch (_) {\n await ensureSchema();\n const r = await sqlite.execute({sql:'SELECT 1 FROM access_sessions WHERE token_hash=? AND expires_at>? LIMIT 1',args:[tokenHash,Date.now()]});\n return r.rows.length > 0;\n }\n}\nasync function rootAccessState(cookieHeader:string) {\n const token = readCookie(cookieHeader,'sami_session');\n const tokenHash = token ? await hashText(token) : '';\n const query = async () => sqlite.execute({\n sql:'SELECT EXISTS(SELECT 1 FROM app_access WHERE id=1) AS configured, EXISTS(SELECT 1 FROM access_sessions WHERE token_hash=? AND expires_at>?) AS valid',\n args:[tokenHash,Date.now()]\n });\n let r;\n try { r = await query(); }\n catch (_) { await ensureSchema(); r = await query(); }\n const row:any = r.rows[0] || {};\n return {configured:Number(row.configured || 0) === 1, valid:Number(row.valid || 0) === 1};\n}\nfunction clientKey(c:any) {\n return String(c.req.header('cf-connecting-ip') || c.req.header('x-forwarded-for') || 'unknown').split(',')[0].trim().slice(0,120);\n}\nfunction accessPage(mode:'setup'|'login', message='') {\n const setup = mode === 'setup';\n const title = setup ? 'CRÉER LE CODE D’ACCÈS' : 'CODE D’ACCÈS';\n const subtitle = setup ? 'Première utilisation : choisissez un code de 4 à 8 chiffres.' : 'Entrez votre code pour ouvrir SAMI.TECH.';\n const action = setup ? '/api/access/setup' : '/api/access/login';\n const confirm = setup ? '' : '';\n const msg = message ? '

'+message+'

' : '';\n return `SAMI.TECH

$\"1984$

${title}

${subtitle}

${msg}

☰ PARAMÈTRES

EN LIGNE

✓ ENREGISTRÉ

SCAN QR COLIS

Sélectionnez une couleur, scannez le QR puis entrez le montant du colis.

COLIS

ENVOYER LA LOCALISATION DU BUREAU

Saisissez le numéro puis appuyez sur WhatsApp ou Entrée.

SCAN QR

TRACKING : AUCUN

CADREZ LE QR CODE

Présentez le QR code du colis dans le cadre bleu.

MONTANT DU COLIS

TÉLÉPHONE CLIENT

SCHÉMA

Dessinez votre schéma.

HISTORIQUE DU JOUR

Sélectionnez une couleur.

$\"1984$

\n\n`;\n\napp.get(\"/\", async (c) => {\n c.header('Cache-Control','no-store, no-cache, must-revalidate');\n c.header('Pragma','no-cache');\n const state = await rootAccessState(c.req.header('cookie') || '');\n if (!state.configured) return c.html(accessPage('setup'));\n if (!state.valid) return c.html(accessPage('login'));\n return c.html(html);\n});\napp.get(\"/health\", (c) => c.json({ ok: true }));\n\napp.post(\"/api/access/setup\", async (c) => {\n if (await accessConfigured()) return c.redirect('/',303);\n const body = await c.req.parseBody();\n const code = String(body?.code || '').trim();\n const confirm = String(body?.confirm || '').trim();\n if (!/^[0-9]{4,8}$/.test(code)) return c.html(accessPage('setup','Le code doit contenir de 4 à 8 chiffres.'),400);\n if (code !== confirm) return c.html(accessPage('setup','Les deux codes ne correspondent pas.'),400);\n const salt = randomHex(16);\n const codeHash = await hashText(salt+'|'+code);\n await sqlite.execute({sql:'INSERT INTO app_access (id,salt,code_hash,updated_at) VALUES (1,?,?,?)',args:[salt,codeHash,Date.now()]});\n const token = randomHex(32);\n const tokenHash = await hashText(token);\n const expiresAt = Date.now() + 12*60*60*1000;\n await sqlite.execute({sql:'INSERT INTO access_sessions (token_hash,expires_at) VALUES (?,?)',args:[tokenHash,expiresAt]});\n const res = c.redirect('/',303);\n res.headers.append('Set-Cookie',`sami_session=${encodeURIComponent(token)}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=43200`);\n return res;\n});\n\napp.post(\"/api/access/login\", async (c) => {\n if (!(await accessConfigured())) return c.redirect('/',303);\n const now = Date.now();\n const key = clientKey(c);\n const failed = await sqlite.execute({sql:'SELECT attempts,locked_until FROM access_failures WHERE client_key=?',args:[key]});\n let attempts = failed.rows.length ? Number((failed.rows[0] as any).attempts || 0) : 0;\n let lockedUntil = failed.rows.length ? Number((failed.rows[0] as any).locked_until || 0) : 0;\n if (lockedUntil > now) {\n const seconds = Math.max(1,Math.ceil((lockedUntil-now)/1000));\n return c.html(accessPage('login','Trop de tentatives. Réessayez dans '+seconds+' seconde(s).'),429);\n }\n if (lockedUntil > 0 && lockedUntil <= now) attempts = 0;\n const body = await c.req.parseBody();\n const code = String(body?.code || '').trim();\n const cfg = await sqlite.execute('SELECT salt,code_hash FROM app_access WHERE id=1 LIMIT 1');\n const salt = String((cfg.rows[0] as any).salt || '');\n const expected = String((cfg.rows[0] as any).code_hash || '');\n const actual = await hashText(salt+'|'+code);\n if (!/^[0-9]{4,8}$/.test(code) || actual !== expected) {\n attempts += 1;\n const newLock = attempts >= 5 ? now + 5*60*1000 : 0;\n const storedAttempts = attempts >= 5 ? 0 : attempts;\n await sqlite.execute({sql:'INSERT INTO access_failures (client_key,attempts,locked_until,updated_at) VALUES (?,?,?,?) ON CONFLICT(client_key) DO UPDATE SET attempts=excluded.attempts,locked_until=excluded.locked_until,updated_at=excluded.updated_at',args:[key,storedAttempts,newLock,now]});\n return c.html(accessPage('login',attempts >= 5 ? 'Accès bloqué pendant 5 minutes.' : 'Code incorrect.'),401);\n }\n await sqlite.execute({sql:'DELETE FROM access_failures WHERE client_key=?',args:[key]});\n await sqlite.execute({sql:'DELETE FROM access_sessions WHERE expires_at<=?',args:[now]});\n const token = randomHex(32);\n const tokenHash = await hashText(token);\n const expiresAt = now + 12*60*60*1000;\n await sqlite.execute({sql:'INSERT INTO access_sessions (token_hash,expires_at) VALUES (?,?)',args:[tokenHash,expiresAt]});\n const res = c.redirect('/',303);\n res.headers.append('Set-Cookie',`sami_session=${encodeURIComponent(token)}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=43200`);\n return res;\n});\n\napp.post(\"/api/access/logout\", async (c) => {\n const token = readCookie(c.req.header('cookie') || '','sami_session');\n if (token) await sqlite.execute({sql:'DELETE FROM access_sessions WHERE token_hash=?',args:[await hashText(token)]});\n const res = c.redirect('/',303);\n res.headers.append('Set-Cookie','sami_session=; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=0');\n return res;\n});\n\napp.use('/api/*', async (c,next) => {\n const path = new URL(c.req.url).pathname;\n if (path.startsWith('/api/access/')) return next();\n if (!(await validSession(c.req.header('cookie') || ''))) return c.json({success:false,error:'Accès verrouillé'},401);\n await next();\n});\n\napp.get(\"/api/admin/settings-status\", async (c) => {\n const cfg = await sqlite.execute('SELECT 1 FROM settings_access WHERE id=1 LIMIT 1');\n return c.json({configured:cfg.rows.length > 0});\n});\n\napp.post(\"/api/admin/settings-setup\", async (c) => {\n try {\n const existing = await sqlite.execute('SELECT 1 FROM settings_access WHERE id=1 LIMIT 1');\n if (existing.rows.length) return c.json({success:false,error:'Le code PARAMÈTRES est déjà configuré.'},409);\n const body = await c.req.json();\n const appCode = String(body?.appCode || '').trim();\n const settingsCode = String(body?.settingsCode || '').trim();\n if (!/^[0-9]{4,8}$/.test(appCode) || !/^[0-9]{4,8}$/.test(settingsCode)) return c.json({success:false,error:'Les codes doivent contenir de 4 à 8 chiffres.'},400);\n if (appCode === settingsCode) return c.json({success:false,error:'Le code PARAMÈTRES doit être différent du code de l’application.'},400);\n const appCfg = await sqlite.execute('SELECT salt,code_hash FROM app_access WHERE id=1 LIMIT 1');\n if (!appCfg.rows.length) return c.json({success:false,error:'Code d’accès application non configuré.'},409);\n const appActual = await hashText(String((appCfg.rows[0] as any).salt || '')+'|'+appCode);\n if (appActual !== String((appCfg.rows[0] as any).code_hash || '')) return c.json({success:false,error:'Code application incorrect.'},401);\n const salt = randomHex(16);\n const codeHash = await hashText(salt+'|'+settingsCode);\n await sqlite.execute({sql:'INSERT INTO settings_access (id,salt,code_hash,updated_at) VALUES (1,?,?,?)',args:[salt,codeHash,Date.now()]});\n return c.json({success:true});\n } catch (_) {\n return c.json({success:false,error:'Impossible de créer le code PARAMÈTRES.'},500);\n }\n});\n\napp.post(\"/api/admin/settings-unlock\", async (c) => {\n try {\n const cfg = await sqlite.execute('SELECT salt,code_hash FROM settings_access WHERE id=1 LIMIT 1');\n if (!cfg.rows.length) return c.json({success:false,setupRequired:true,error:'Code PARAMÈTRES non configuré.'},409);\n const body = await c.req.json();\n const code = String(body?.code || '').trim();\n if (!/^[0-9]{4,8}$/.test(code)) return c.json({success:false,error:'Code PARAMÈTRES incorrect.'},401);\n const now = Date.now();\n const key = 'settings:'+clientKey(c);\n const failed = await sqlite.execute({sql:'SELECT attempts,locked_until FROM access_failures WHERE client_key=?',args:[key]});\n let attempts = failed.rows.length ? Number((failed.rows[0] as any).attempts || 0) : 0;\n let lockedUntil = failed.rows.length ? Number((failed.rows[0] as any).locked_until || 0) : 0;\n if (lockedUntil > now) {\n const seconds = Math.max(1,Math.ceil((lockedUntil-now)/1000));\n return c.json({success:false,error:'PARAMÈTRES bloqués. Réessayez dans '+seconds+' seconde(s).'},429);\n }\n if (lockedUntil > 0 && lockedUntil <= now) attempts = 0;\n const actual = await hashText(String((cfg.rows[0] as any).salt || '')+'|'+code);\n if (actual !== String((cfg.rows[0] as any).code_hash || '')) {\n attempts += 1;\n const newLock = attempts >= 5 ? now + 5*60*1000 : 0;\n const storedAttempts = attempts >= 5 ? 0 : attempts;\n await sqlite.execute({sql:'INSERT INTO access_failures (client_key,attempts,locked_until,updated_at) VALUES (?,?,?,?) ON CONFLICT(client_key) DO UPDATE SET attempts=excluded.attempts,locked_until=excluded.locked_until,updated_at=excluded.updated_at',args:[key,storedAttempts,newLock,now]});\n return c.json({success:false,error:attempts >= 5 ? 'PARAMÈTRES bloqués pendant 5 minutes.' : 'Code PARAMÈTRES incorrect.'},401);\n }\n await sqlite.execute({sql:'DELETE FROM access_failures WHERE client_key=?',args:[key]});\n return c.json({success:true});\n } catch (_) {\n return c.json({success:false,error:'Impossible de vérifier le code PARAMÈTRES.'},500);\n }\n});\n\napp.post(\"/api/admin/change-access-code\", async (c) => {\n try {\n const body = await c.req.json();\n const currentCode = String(body?.currentCode || '').trim();\n const newCode = String(body?.newCode || '').trim();\n if (!/^[0-9]{4,8}$/.test(currentCode)) return c.json({success:false,error:'Code actuel incorrect.'},401);\n if (!/^[0-9]{4,8}$/.test(newCode)) return c.json({success:false,error:'Le nouveau code doit contenir de 4 à 8 chiffres.'},400);\n if (currentCode === newCode) return c.json({success:false,error:'Le nouveau code doit être différent du code actuel.'},400);\n const cfg = await sqlite.execute('SELECT salt,code_hash FROM app_access WHERE id=1 LIMIT 1');\n if (!cfg.rows.length) return c.json({success:false,error:'Code d’accès non configuré.'},409);\n const salt = String((cfg.rows[0] as any).salt || '');\n const expected = String((cfg.rows[0] as any).code_hash || '');\n const actual = await hashText(salt+'|'+currentCode);\n if (actual !== expected) return c.json({success:false,error:'Code actuel incorrect.'},401);\n const settingsCfg = await sqlite.execute('SELECT salt,code_hash FROM settings_access WHERE id=1 LIMIT 1');\n if (settingsCfg.rows.length) {\n const sameAsSettings = await hashText(String((settingsCfg.rows[0] as any).salt || '')+'|'+newCode);\n if (sameAsSettings === String((settingsCfg.rows[0] as any).code_hash || '')) return c.json({success:false,error:'Le code de l’application doit être différent du code PARAMÈTRES.'},400);\n }\n const newSalt = randomHex(16);\n const newHash = await hashText(newSalt+'|'+newCode);\n const now = Date.now();\n await sqlite.execute({sql:'UPDATE app_access SET salt=?,code_hash=?,updated_at=? WHERE id=1',args:[newSalt,newHash,now]});\n await sqlite.execute('DELETE FROM access_sessions');\n await sqlite.execute('DELETE FROM access_failures');\n const token = randomHex(32);\n const tokenHash = await hashText(token);\n const expiresAt = now + 12*60*60*1000;\n await sqlite.execute({sql:'INSERT INTO access_sessions (token_hash,expires_at) VALUES (?,?)',args:[tokenHash,expiresAt]});\n const res = c.json({success:true});\n res.headers.append('Set-Cookie',`sami_session=${encodeURIComponent(token)}; Path=/; HttpOnly; Secure; SameSite=Lax; Max-Age=43200`);\n return res;\n } catch (_) {\n return c.json({success:false,error:'Impossible de modifier le code d’accès.'},500);\n }\n});\n\napp.get(\"/api/pattern/status\", async (c) => {\n const color = String(c.req.query('color') || '').trim().toUpperCase();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(color)) return c.json({configured:false,error:'Couleur invalide'},400);\n const result = await sqlite.execute({sql:'SELECT 1 FROM color_patterns WHERE color=? LIMIT 1',args:[color]});\n return c.json({configured:result.rows.length > 0});\n});\napp.post(\"/api/pattern/verify\", async (c) => {\n try {\n const body = await c.req.json();\n const color = String(body?.color || '').trim().toUpperCase();\n const pattern = String(body?.pattern || '').trim();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(color) || !validPattern(pattern)) return c.json({success:false},400);\n const result = await sqlite.execute({sql:'SELECT pattern_hash FROM color_patterns WHERE color=?',args:[color]});\n if (!result.rows.length) return c.json({success:false,configured:false},200);\n const expected = String((result.rows[0] as any).pattern_hash || '');\n const actual = await hashPattern(color,pattern);\n return c.json({success:actual === expected,configured:true},200);\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err)},500);\n }\n});\napp.post(\"/api/admin/pattern/set\", async (c) => {\n try {\n const body = await c.req.json();\n const color = String(body?.color || '').trim().toUpperCase();\n const pattern = String(body?.pattern || '').trim();\n if (String(body?.confirm || '') !== 'SET') return c.json({success:false,error:'Confirmation invalide'},400);\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(color)) return c.json({success:false,error:'Couleur invalide'},400);\n if (!validPattern(pattern)) return c.json({success:false,error:'Schéma invalide'},400);\n const patternHash = await hashPattern(color,pattern);\n await sqlite.execute({sql:'INSERT INTO color_patterns (color,pattern_hash,updated_at) VALUES (?,?,?) ON CONFLICT(color) DO UPDATE SET pattern_hash=excluded.pattern_hash,updated_at=excluded.updated_at',args:[color,patternHash,Date.now()]});\n return c.json({success:true});\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err)},500);\n }\n});\napp.post(\"/api/admin/reset-dedup\", async (c) => {\n return c.json({success:true,deleted:0,localOnly:true});\n});\napp.post(\"/api/reserve\", async (c) => {\n try {\n const body = await c.req.json();\n const user = String(body?.user || \"\").trim().toUpperCase();\n let value = String(body?.value || \"\").trim();\n if (body?.manualPhone) {\n let phone = value.replace(/[^0-9]/g,'');\n if (phone.startsWith('00')) phone = phone.slice(2);\n if (/^213[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone.slice(3);\n else if (/^[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone;\n value = phone;\n }\n const scanId = String(body?.id || '').trim();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(user)) return c.json({success:false,error:'Utilisateur invalide'},400);\n if (!value) return c.json({success:false,error:'Numéro vide'},400);\n if (!scanId) return c.json({success:false,error:'scan_id manquant'},400);\n return c.json({success:true,reserved:true,synced:false,localOnly:true},200);\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err)},200);\n }\n});\n\napp.post(\"/api/scan\", async (c) => {\n try {\n const body = await c.req.json();\n const user = String(body?.user || \"\").trim().toUpperCase();\n let value = String(body?.value || \"\").trim();\n if (body?.manualPhone) {\n let phone = value.replace(/[^0-9]/g,'');\n if (phone.startsWith('00')) phone = phone.slice(2);\n if (/^213[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone.slice(3);\n else if (/^[5-7][0-9]{8}$/.test(phone)) phone = '0' + phone;\n value = phone;\n }\n const scanId = String(body?.id || '').trim();\n if (!['ANIS','RACIM','VERT','JAUNE','ROSE'].includes(user)) return c.json({success:false,error:'Utilisateur invalide'},400);\n if (!value) return c.json({success:false,error:'Numéro vide'},400);\n if (!scanId) return c.json({success:false,error:'scan_id manquant'},400);\n\n const form = new URLSearchParams();\n form.set('user', user);\n form.set('color', user === 'ANIS' ? 'BLEU' : user === 'RACIM' ? 'ORANGE' : user);\n form.set('tracking', value);\n form.set('phone', String(body?.phone || ''));\n form.set('amount', String(body?.amount || ''));\n form.set('scan_id', scanId);\n form.set('timestamp', String(body?.timestamp || Date.now()));\n form.set('timezone', String(body?.timezone || 'Africa/Algiers'));\n\n const r = await fetch(GOOGLE_SCRIPT_URL, {\n method: 'POST',\n headers: {'Content-Type':'application/x-www-form-urlencoded;charset=UTF-8'},\n body: form.toString(),\n redirect: 'follow'\n });\n const text = await r.text();\n let data:any;\n try { data = JSON.parse(text); } catch { throw new Error('Réponse Google invalide'); }\n if (!data?.success) throw new Error(data?.error || 'Échec Google Sheets');\n return c.json(data);\n } catch (err) {\n return c.json({success:false,error:err instanceof Error ? err.message : String(err),debug:true},200);\n }\n});\n\napp.onError((err) => Promise.reject(err));\nexport default app.fetch;\n","createdAt",["D",1789170374665],"branchVersion","branchId","7239f298-4410-42fd-82ec-4aa06460a97b","id","81fba5d7-d8f6-4db9-81f9-40d55ad5a3ad","anis-racim-scanner",["D",1788906685327],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Android scanner for ANIS and RACIM","imageUrl","d1a4e165-322f-4bea-a472-a3bfe065b80a","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a04a3a-ab09-722d-b08e-d53e0c46d95a","tursoName","81fba5d7d8f64db981f940d55ad5a3ad","tursoHostname","81fba5d7d8f64db981f940d55ad5a3ad-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789516910456],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",354,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","emller","handle","displayName","E. Müller","avatar","https://lh3.googleusercontent.com/a/ACg8ocLJnTmCFn0ipeSgvNaIC4rYdYukPA7khbo2Fye1VgNbr6ozzQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":237,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":31,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":238,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":239,"_83":240,"_85":241,"_87":25},"tree",[172,179,180,181],"files",[172,173,174,175,176,177,178,179,180,181],"counts",{"_161":62,"_162":163,"_164":62,"_165":166,"_167":168},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":155,"_32":156,"_30":157,"_135":-5,"_41":42,"_40":145,"_136":58,"_38":158,"_13":62,"_33":159,"_35":-5,"_24":25,"_139":-5,"_27":160},{"_43":149,"_32":150,"_30":151,"_135":-5,"_41":42,"_40":145,"_136":58,"_38":152,"_13":62,"_33":20,"_35":153,"_24":25,"_139":-5,"_27":154},{"_43":142,"_32":143,"_30":144,"_135":-5,"_41":42,"_40":145,"_136":58,"_38":146,"_13":62,"_33":20,"_35":147,"_24":25,"_139":-5,"_27":148},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":140,"_27":141},"68fad388-302e-478b-942b-f5f574266655","parentId","latest",["D",1789170374665],352,"label","sami",[28],"83f92fb4-f268-4793-95ef-f4f4d62fcd1d","README.md","01a08325-c3d5-76d8-a1f2-6ce5083410b7",1,["D",1788906685327],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"root.tsx\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n root.tsx ← HTML shell (stamps immutable asset URLs)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types\n\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[143],"6a77602d-e02e-49c0-b11c-55682dcef565","CHANGELOG.md","01a08325-c3d5-76d8-a1f2-6baabc9a4774",["D",1788906685327],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v353