[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_165":166,"_167":168},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_124":-5,"_20":125,"_22":126,"_127":128,"_129":130,"_26":131,"_24":132,"_133":-5,"_134":-5,"_135":51,"_136":137,"_138":43,"_139":-5,"_140":-5,"_141":142},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","fleurmeijer","name","picnic-mob-import","branchName","main","version","path","index.html","project",{"_33":69,"_13":14,"_44":70,"_71":-5,"_72":51,"_73":74,"_75":74,"_76":77,"_78":-5,"_79":80,"_81":58,"_82":43,"_83":-5,"_84":-5,"_85":46,"_86":87,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":93,"_94":93,"_95":96,"_97":96,"_98":96,"_99":93,"_100":93,"_101":102,"_103":104,"_105":106,"_107":51},"tree",[54,55],"file",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":53},"contents",[],"upstream","pull","ahead","behind","envVars","id","e05be727-a0ad-41d0-9224-ab5f74d93714","fileId","9b7ed352-8691-11f1-b2a9-1607ee4eb77e","parentId","branchId","6df26615-e8b7-404a-a59a-17c6b44e2072","branchVersion",8,"latest",true,"createdAt",["D",1784809536224],0,"fileType","content","\n\n\n \n \n Picnic MOB Import\n \n\n\n

🛒 Picnic MOB Import

Plak je MOB boodschappenlijst en voeg automatisch toe aan je Picnic-wagen.

\n\n \n

\n MOB boodschappenlijst\n \n \n

\n\n \n

\n SMS-code van Picnic\n

Je hebt een code per SMS ontvangen. Vul deze hieronder in.

\n \n \n

\n\n \n

\n\n \n\n\n","deleted",false,"label",[19],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":66,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_63":67,"_18":68},{"_33":56,"_13":57,"_35":58,"_37":-5,"_38":39,"_40":59,"_42":43,"_44":60,"_17":41,"_47":61,"_48":62,"_50":51,"_52":-5,"_63":64,"_18":65},"954d97b7-4620-4f5e-bceb-9ff5c8646afe","main.ts","51d67252-85ae-11f1-8ef0-1607ee4eb77e",10,["D",1784809848749],"http","import PicnicClient from \"npm:picnic-api\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst AUTH_BLOB_KEY = \"picnicAuthKey\";\n\nexport default async function (req: Request): Promise {\n // GET = toon de webpagina\n if (req.method === \"GET\") {\n const html = await readFile(\"index.html\");\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html; charset=UTF-8\" },\n });\n }\n\n if (req.method !== \"POST\") {\n return new Response(\"Gebruik POST met JSON body\", { status: 405 });\n }\n const body = await req.json();\n\n // === STAP 1: Login + 2FA starten ===\n if (body.text && !body.code) {\n const items = parseMobList(body.text);\n\n // Probeer bewaarde auth key te hergebruiken (sla 2FA over)\n const saved = await blob.getJSON(AUTH_BLOB_KEY);\n if (saved?.authKey) {\n const testClient = new PicnicClient({ countryCode: \"NL\", apiVersion: \"15\", authKey: saved.authKey });\n try {\n await testClient.cart.getCart();\n return await processItems(items, saved.authKey);\n } catch (e) {\n // bewaarde key verlopen/ongeldig -> val terug op login hieronder\n }\n }\n\n const client = new PicnicClient({ countryCode: \"NL\", apiVersion: \"15\" });\n const loginResult = await client.auth.login(\n Deno.env.get(\"PICNIC_EMAIL\")!,\n Deno.env.get(\"PICNIC_PASSWORD\")!,\n );\n if (loginResult.second_factor_authentication_required) {\n const sessionId = crypto.randomUUID();\n await blob.setJSON(`session:${sessionId}`, { items, authKey: loginResult.authKey, createdAt: Date.now() });\n await client.auth.generate2FACode(\"SMS\");\n return new Response(\n JSON.stringify({\n status: \"2FA_REQUIRED\",\n message: \"Voer de SMS-code in die je zojuist hebt ontvangen.\",\n sessionId,\n totaal: items.length,\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n await blob.setJSON(AUTH_BLOB_KEY, { authKey: loginResult.authKey, savedAt: Date.now() });\n return await processItems(items, loginResult.authKey);\n }\n\n // === STAP 2: 2FA code verifiëren + producten toevoegen ===\n if (body.sessionId && body.code) {\n const session = await blob.getJSON(`session:${body.sessionId}`);\n if (!session) {\n return new Response(\n JSON.stringify({ error: \"Sessie niet gevonden of verlopen. Start opnieuw.\" }),\n { status: 400, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n const client = new PicnicClient({ countryCode: \"NL\", apiVersion: \"15\", authKey: session.authKey });\n const verifyResult = await client.auth.verify2FACode(body.code);\n await blob.delete(`session:${body.sessionId}`);\n // Sla de verified auth key op voor volgende keer\n await blob.setJSON(AUTH_BLOB_KEY, { authKey: verifyResult.authKey, savedAt: Date.now() });\n return await processItems(session.items, verifyResult.authKey);\n }\n\n return new Response(\n JSON.stringify({ error: \"Stuur { text: '...' }, of { sessionId: '...', code: '...' } na een 2FA-verzoek.\" }),\n { status: 400, headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n\nconst EN_NL: Record = {\n \"vine tomatoes\": \"trostomaten\", \"tomatoes\": \"tomaten\", \"red onion\": \"rode ui\", \"onion\": \"uien\",\n \"garlic\": \"knoflook\", \"lemon\": \"citroen\", \"lime\": \"limoen\", \"cucumber\": \"komkommer\",\n \"carrot\": \"wortelen\", \"potato\": \"aardappelen\", \"sweet potato\": \"zoete aardappel\", \"spinach\": \"spinazie\",\n \"fresh dill\": \"verse dille\", \"dill\": \"dille\", \"fresh basil\": \"verse basilicum\", \"basil\": \"basilicum\",\n \"fresh parsley\": \"verse peterselie\", \"parsley\": \"peterselie\", \"fresh coriander\": \"verse koriander\",\n \"coriander\": \"koriander\", \"fresh thyme\": \"verse tijm\", \"thyme\": \"tijm\", \"fresh rosemary\": \"verse rozemarijn\",\n \"rosemary\": \"rozemarijn\", \"fresh mint\": \"verse munt\", \"mint\": \"munt\", \"fresh ginger\": \"verse gember\",\n \"ginger\": \"gember\", \"celery\": \"bleekselderij\", \"leek\": \"prei\", \"zucchini\": \"courgette\",\n \"courgette\": \"courgette\", \"eggplant\": \"aubergine\", \"aubergine\": \"aubergine\", \"bell pepper\": \"paprika\",\n \"pepper\": \"paprika\", \"chili\": \"chili\", \"chilli\": \"chili\", \"lettuce\": \"sla\", \"rocket\": \"rucola\",\n \"arugula\": \"rucola\", \"avocado\": \"avocado\", \"broccoli\": \"broccoli\", \"cauliflower\": \"bloemkool\",\n \"green beans\": \"sperziebonen\", \"green bean\": \"sperziebonen\", \"beans\": \"bonen\", \"peas\": \"erwten\",\n \"mushroom\": \"champignons\", \"mushrooms\": \"champignons\", \"apple\": \"appelen\", \"banana\": \"bananen\",\n \"orange\": \"sinaasappelen\", \"pear\": \"peren\", \"strawberry\": \"aardbeien\", \"strawberries\": \"aardbeien\",\n \"blueberry\": \"bosbessen\", \"blueberries\": \"bosbessen\", \"raspberry\": \"frambozen\", \"raspberries\": \"frambozen\",\n \"grapes\": \"druiven\", \"mango\": \"mango\", \"pineapple\": \"ananas\", \"watermelon\": \"watermeloen\", \"melon\": \"meloen\",\n \"turkey thigh mince\": \"kalkoen gehakt\", \"turkey mince\": \"kalkoen gehakt\", \"turkey\": \"kalkoen\",\n \"chicken thigh\": \"kip dij\", \"chicken breast\": \"kipfilet\", \"chicken\": \"kip\", \"beef mince\": \"rundergehakt\",\n \"mince\": \"gehakt\", \"ground beef\": \"rundergehakt\", \"pork\": \"varkensvlees\", \"bacon\": \"bacon\",\n \"sausages\": \"worstjes\", \"sausage\": \"worst\", \"ham\": \"ham\", \"salmon\": \"zalm\", \"tuna\": \"tonijn\",\n \"cod\": \"kabeljauw\", \"shrimp\": \"garnalen\", \"prawns\": \"garnalen\", \"milk\": \"melk\", \"whole milk\": \"volle melk\",\n \"semi-skimmed milk\": \"halfvolle melk\", \"skimmed milk\": \"magere melk\", \"buttermilk\": \"karnemelk\",\n \"cream\": \"slagroom\", \"butter\": \"boter\", \"cheese\": \"kaas\", \"grated cheese\": \"geraspte kaas\",\n \"eggs\": \"eieren\", \"egg\": \"eieren\", \"yogurt\": \"yoghurt\", \"yoghurt\": \"yoghurt\", \"greek yogurt\": \"griekse yoghurt\",\n \"bread\": \"brood\", \"flatbreads\": \"flatbreads\", \"flatbread\": \"flatbread\", \"pita\": \"pita\", \"tortilla\": \"tortilla\",\n \"wraps\": \"wraps\", \"bun\": \"broodjes\", \"buns\": \"broodjes\", \"rolls\": \"broodjes\", \"croissant\": \"croissant\",\n \"olive oil\": \"olijfolie\", \"sunflower oil\": \"zonnebloemolie\", \"cooking oil\": \"bakolie\", \"soy sauce\": \"sojasaus\",\n \"tomato sauce\": \"tomatensaus\", \"tomato paste\": \"tomatenpuree\", \"pesto\": \"pesto\", \"mayonnaise\": \"mayonaise\",\n \"ketchup\": \"ketchup\", \"mustard\": \"mosterd\", \"vinegar\": \"azijn\", \"honey\": \"honing\", \"rice\": \"rijst\",\n \"pasta\": \"pasta\", \"spaghetti\": \"spaghetti\", \"penne\": \"penne\", \"flour\": \"bloem\", \"sugar\": \"suiker\",\n \"salt\": \"zout\", \"pepper\": \"peper\",\n \"orange juice\": \"sinaasappelsap\", \"apple juice\": \"appelsap\", \"juice\": \"sap\", \"water\": \"water\",\n \"tea\": \"thee\", \"coffee\": \"koffie\",\n};\n\nfunction getSearchTerms(name: string): string[] {\n const terms: string[] = [];\n const lower = name.toLowerCase().trim();\n\n // 1. Originele naam\n terms.push(name);\n\n // 2. Volledige Engelse vertaling naar Nederlands\n if (EN_NL[lower]) {\n terms.push(EN_NL[lower]);\n }\n\n // 3. Woord-voor-woord vertalen (bv. \"fresh dill\" → \"verse dille\")\n let translated = lower;\n for (const [en, nl] of Object.entries(EN_NL)) {\n const re = new RegExp(`\\\\b${en}\\\\b`, \"gi\");\n translated = translated.replace(re, nl);\n }\n if (translated !== lower) {\n terms.push(translated);\n }\n\n // 4. Verwijder \"fresh\" / \"frozen\" / \"dried\" etc. en probeer opnieuw\n const stripped = lower\n .replace(/\\b(fresh|frozen|dried|chopped|sliced|whole|organic|bio)\\b/gi, \"\")\n .replace(/\\s+/g, \" \")\n .trim();\n if (stripped && stripped !== lower) {\n terms.push(stripped);\n let strippedTranslated = stripped;\n for (const [en, nl] of Object.entries(EN_NL)) {\n const re = new RegExp(`\\\\b${en}\\\\b`, \"gi\");\n strippedTranslated = strippedTranslated.replace(re, nl);\n }\n if (strippedTranslated !== stripped) {\n terms.push(strippedTranslated);\n }\n }\n\n // 5. Eerste woord only (laatste redmiddel)\n const firstWord = lower.split(/\\s+/)[0];\n if (firstWord && !terms.includes(firstWord)) {\n if (EN_NL[firstWord]) {\n terms.push(EN_NL[firstWord]);\n }\n terms.push(firstWord);\n }\n\n return [...new Set(terms)];\n}\n\nasync function processItems(\n items: { category: string; name: string }[],\n authKey: string,\n): Promise {\n const client = new PicnicClient({\n countryCode: \"NL\",\n apiVersion: \"15\",\n authKey,\n });\n\n const addedByCategory: Record = {};\n const notFound: string[] = [];\n const searchLog: string[] = [];\n\n for (const { category, name } of items) {\n const searchTerms = getSearchTerms(name);\n let found = false;\n\n for (const term of searchTerms) {\n try {\n const results = await client.catalog.search(term);\n const product = results?.[0];\n if (product) {\n await client.cart.addProductToCart(product.id, 1);\n (addedByCategory[category] ??= []).push(`${name} → ${product.name}`);\n searchLog.push(`✓ \"${name}\" → gezocht als \"${term}\" → gevonden: ${product.name}`);\n found = true;\n break;\n }\n } catch (e) {\n // probeer volgende zoekterm\n }\n }\n\n if (!found) {\n notFound.push(`${category}: ${name}`);\n searchLog.push(`✗ \"${name}\" → geprobeerd: ${searchTerms.join(\", \")}`);\n }\n }\n\n return new Response(\n JSON.stringify({ addedByCategory, notFound, totaal: items.length, searchLog }, null, 2),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n\nfunction parseMobList(text: string): { category: string; name: string }[] {\n const lines = text.split(\"\\n\").map((l) => l.trim());\n const blocks: string[][] = [[]];\n for (const line of lines) {\n if (line === \"\") {\n if (blocks[blocks.length - 1].length > 0) blocks.push([]);\n } else {\n blocks[blocks.length - 1].push(line);\n }\n }\n const items: { category: string; name: string }[] = [];\n for (const block of blocks) {\n if (block.length <= 1) continue;\n const category = block[0];\n for (const raw of block.slice(1)) {\n items.push({ category, name: cleanItemLine(raw) });\n }\n }\n return items;\n}\n\nfunction cleanItemLine(line: string): string {\n return line\n .replace(/^\\d+x\\s*/i, \"\")\n .replace(/^\\d+(\\.\\d+)?\\s*(kg|g|ltr|ml|l)\\b\\s*/i, \"\")\n .replace(/^\\d+%\\s*/, \"\")\n .replace(/^\\d+\\s*(bulbs?|cans?|pouches?)\\b\\s*/i, \"\")\n .replace(/^\\d+\\s+/, \"\")\n .replace(/^(pouch|can|tin|bag|jar|packet|box)\\s+/i, \"\")\n .trim();\n}\n","children",[],[57],["D",1784809536224],[],[19],"3808b97d-eb66-445b-a855-c165a162d0a9",["D",1784711910300],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Importeer MOB-boodschappenlijst naar Picnic-wagen","imageUrl","userId","dc2762d3-0ad6-4690-aed6-b32c569811c6","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","019f891d-9fbf-722d-b9fe-8c5d81e09a33","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_123":119},"org",{"_11":12,"_116":117,"_118":119,"_79":80,"_120":121,"_122":51},"branch",{"_17":59,"_13":16,"_33":39,"_108":69,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":14,"_115":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","fleur meijer","avatar","https://lh3.googleusercontent.com/a/ACg8ocLKiPUHH6Cpa99Ayq4L7C9626JfviyIm4Q0BDV3gBxET3KnQQ=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":69,"_13":14,"_44":161,"_71":-5,"_72":51,"_73":74,"_75":74,"_76":77,"_78":-5,"_79":80,"_81":58,"_82":43,"_83":-5,"_84":-5,"_85":46,"_86":87,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":93,"_94":93,"_95":96,"_97":96,"_98":96,"_99":93,"_100":93,"_101":162,"_103":163,"_105":164,"_107":51},[155,156],"files",[155,156],"counts",{"_144":46,"_145":146,"_147":46,"_32":148,"_149":150},[],{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":45,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_18":143},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},[19],"pulls","branches",1,"forks",{"_151":153,"_154":46},"connections",{"_151":46,"_152":46},"count","unfilledCount",2,"emptyCount",{"_33":34,"_13":19,"_35":36,"_37":-5,"_38":39,"_40":41,"_42":43,"_44":66,"_17":46,"_47":24,"_48":49,"_50":51,"_52":-5,"_63":159,"_18":160},{"_33":56,"_13":57,"_35":58,"_37":-5,"_38":39,"_40":59,"_42":43,"_44":60,"_17":41,"_47":61,"_48":62,"_50":51,"_52":-5,"_63":157,"_18":158},[],[57],[],[19],["D",1784711910300],{"_11":12,"_123":119},{"_11":12,"_116":117,"_118":119,"_79":80,"_120":121,"_122":51},{"_17":59,"_13":16,"_33":39,"_108":69,"_109":-5,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":14,"_115":12},"ctx",{"_101":-5,"_140":198,"_199":200,"_201":202,"_203":51,"_204":51,"_205":51,"_206":43,"_207":-5,"_208":-7,"_209":-7,"_210":46,"_211":51,"_212":51,"_213":-5,"_214":51,"_215":51,"_216":51,"_217":-5},"ENV",{"_169":170,"_171":172,"_173":16,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195,"_196":197},"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"]