[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_172":173,"_174":175},"routes/_app.x.$handle.$name",{"_100":99,"_37":48,"_109":90,"_32":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_26":-5,"_121":-5,"_122":-5,"_123":30,"_124":125,"_126":62,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_46":47,"_37":48,"_41":49,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":30},"version",8,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","efcee7d3-9820-4d90-8a80-f64b16b5702e","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":26,"_39":40,"_41":42,"_43":14,"_44":45,"_29":30},"previous","deleted",false,"deletedHere","path","index.html","latestPath","fileId","9b7ed352-8691-11f1-b2a9-1607ee4eb77e","name","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","createdAt",["D",1784809536224],"branchVersion","branchId","6df26615-e8b7-404a-a59a-17c6b44e2072","id","3808b97d-eb66-445b-a855-c165a162d0a9","picnic-mob-import",["D",1784711910300],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Importeer MOB-boodschappenlijst naar Picnic-wagen","imageUrl","dc2762d3-0ad6-4690-aed6-b32c569811c6","pinnedFileId","51d67252-85ae-11f1-8ef0-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f891d-9fbf-722d-b9fe-8c5d81e09a33","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_19":58,"_105":106,"_107":30},"branch",{"_13":89,"_37":90,"_46":45,"_91":47,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":48,"_98":99},"isOwned",10,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","fleurmeijer","handle","displayName","fleur meijer","avatar","https://lh3.googleusercontent.com/a/ACg8ocLKiPUHH6Cpa99Ayq4L7C9626JfviyIm4Q0BDV3gBxET3KnQQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_46":47,"_37":48,"_41":168,"_50":-5,"_51":30,"_52":53,"_54":53,"_55":56,"_57":-5,"_19":58,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":169,"_84":170,"_86":171,"_88":30},"tree",[159,160],"files",[159,160],"counts",{"_147":66,"_148":149,"_150":66,"_151":152,"_153":154},"contents",[131,132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_46":144,"_37":33,"_35":36,"_135":-5,"_44":45,"_43":14,"_137":62,"_41":145,"_13":66,"_38":26,"_39":40,"_29":30,"_142":-5,"_32":146},{"_46":133,"_37":134,"_35":60,"_135":-5,"_44":45,"_43":136,"_137":30,"_41":138,"_13":139,"_38":140,"_39":141,"_29":30,"_142":-5,"_32":143},"0cc4b54e-7304-46b6-b6cf-ab3929ca6702","main.ts","parentId",7,"latest",["D",1784798749109],6,"http","import PicnicClient from \"npm:picnic-api\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Gebruik POST met JSON body\", { status: 405 });\n }\n\n const body = await req.json();\n\n // === STAP 1: Login + 2FA starten ===\n // Body: { \"text\": \"MOB export tekst\" }\n if (body.text && !body.code) {\n const items = parseMobList(body.text);\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\n if (loginResult.second_factor_authentication_required) {\n // Sla de MOB-lijst + authKey op in blob storage voor stap 2\n const sessionId = crypto.randomUUID();\n await blob.setJSON(`session:${sessionId}`, {\n items,\n authKey: loginResult.authKey,\n createdAt: Date.now(),\n });\n\n // Start 2FA via SMS\n await client.auth.generate2FACode(\"SMS\");\n\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\n // Geen 2FA nodig — direct door naar het zoekproces\n return await processItems(items, loginResult.authKey);\n }\n\n // === STAP 2: 2FA code verifiëren + producten toevoegen ===\n // Body: { \"sessionId\": \"...\", \"code\": \"123456\" }\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\n // Verifieer 2FA\n const client = new PicnicClient({\n countryCode: \"NL\",\n apiVersion: \"15\",\n authKey: session.authKey,\n });\n const verifyResult = await client.auth.verify2FACode(body.code);\n\n // Sessie opruimen\n await blob.delete(`session:${body.sessionId}`);\n\n // Nu kunnen we zoeken en toevoegen met de verified auth key\n return await processItems(session.items, verifyResult.authKey);\n }\n\n return new Response(\n JSON.stringify({\n error: \"Stuur { text: '...' } voor stap 1, of { sessionId: '...', code: '...' } voor stap 2.\",\n }),\n { status: 400, headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n\n// Engels → Nederlands vertaalwoordenboek voor veelvoorkomende boodschappen\nconst EN_NL: Record = {\n // Groenten & fruit\n \"vine tomatoes\": \"trostomaten\",\n \"tomatoes\": \"tomaten\",\n \"red onion\": \"rode ui\",\n \"onion\": \"uien\",\n \"garlic\": \"knoflook\",\n \"lemon\": \"citroen\",\n \"lime\": \"limoen\",\n \"cucumber\": \"komkommer\",\n \"carrot\": \"wortelen\",\n \"potato\": \"aardappelen\",\n \"sweet potato\": \"zoete aardappel\",\n \"spinach\": \"spinazie\",\n \"fresh dill\": \"verse dille\",\n \"dill\": \"dille\",\n \"fresh basil\": \"verse basilicum\",\n \"basil\": \"basilicum\",\n \"fresh parsley\": \"verse peterselie\",\n \"parsley\": \"peterselie\",\n \"fresh coriander\": \"verse koriander\",\n \"coriander\": \"koriander\",\n \"fresh thyme\": \"verse tijm\",\n \"thyme\": \"tijm\",\n \"fresh rosemary\": \"verse rozemarijn\",\n \"rosemary\": \"rozemarijn\",\n \"fresh mint\": \"verse munt\",\n \"mint\": \"munt\",\n \"fresh ginger\": \"verse gember\",\n \"ginger\": \"gember\",\n \"celery\": \"bleekselderij\",\n \"leek\": \"prei\",\n \"zucchini\": \"courgette\",\n \"courgette\": \"courgette\",\n \"eggplant\": \"aubergine\",\n \"aubergine\": \"aubergine\",\n \"bell pepper\": \"paprika\",\n \"pepper\": \"paprika\",\n \"chili\": \"chili\",\n \"chilli\": \"chili\",\n \"lettuce\": \"sla\",\n \"rocket\": \"rucola\",\n \"arugula\": \"rucola\",\n \"avocado\": \"avocado\",\n \"broccoli\": \"broccoli\",\n \"cauliflower\": \"bloemkool\",\n \"green beans\": \" sperziebonen\",\n \"green bean\": \"sperziebonen\",\n \"beans\": \"bonen\",\n \"peas\": \"erwten\",\n \"mushroom\": \"champignons\",\n \"mushrooms\": \"champignons\",\n \"apple\": \"appelen\",\n \"banana\": \"bananen\",\n \"orange\": \"sinaasappelen\",\n \"pear\": \"peren\",\n \"strawberry\": \"aardbeien\",\n \"strawberries\": \"aardbeien\",\n \"blueberry\": \"bosbessen\",\n \"blueberries\": \"bosbessen\",\n \"raspberry\": \"frambozen\",\n \"raspberries\": \"frambozen\",\n \"grapes\": \"druiven\",\n \"mango\": \"mango\",\n \"pineapple\": \"ananas\",\n \"watermelon\": \"watermeloen\",\n \"melon\": \"meloen\",\n // Vlees & vis\n \"turkey thigh mince\": \"kalkoen gehakt\",\n \"turkey mince\": \"kalkoen gehakt\",\n \"turkey\": \"kalkoen\",\n \"chicken thigh\": \"kip dij\",\n \"chicken breast\": \"kipfilet\",\n \"chicken\": \"kip\",\n \"beef mince\": \"rundergehakt\",\n \"mince\": \"gehakt\",\n \"ground beef\": \"rundergehakt\",\n \"pork\": \"varkensvlees\",\n \"bacon\": \"bacon\",\n \"sausages\": \"worstjes\",\n \"sausage\": \"worst\",\n \"ham\": \"ham\",\n \"salmon\": \"zalm\",\n \"tuna\": \"tonijn\",\n \"cod\": \"kabeljauw\",\n \"shrimp\": \"garnalen\",\n \"prawns\": \"garnalen\",\n // Zuivel & eieren\n \"milk\": \"melk\",\n \"whole milk\": \"volle melk\",\n \"semi-skimmed milk\": \"halfvolle melk\",\n \"skimmed milk\": \"magere melk\",\n \"buttermilk\": \"karnemelk\",\n \"cream\": \"slagroom\",\n \"butter\": \"boter\",\n \"cheese\": \"kaas\",\n \"grated cheese\": \"geraspte kaas\",\n \"eggs\": \"eieren\",\n \"egg\": \"eieren\",\n \"yogurt\": \"yoghurt\",\n \"yoghurt\": \"yoghurt\",\n \"greek yogurt\": \"griekse yoghurt\",\n // Bakkerij\n \"bread\": \"brood\",\n \"flatbreads\": \"flatbreads\",\n \"flatbread\": \"flatbread\",\n \"pita\": \"pita\",\n \"tortilla\": \"tortilla\",\n \"wraps\": \"wraps\",\n \"bun\": \"broodjes\",\n \"buns\": \"broodjes\",\n \"rolls\": \"broodjes\",\n \"croissant\": \"croissant\",\n // Sauces & oils\n \"olive oil\": \"olijfolie\",\n \"sunflower oil\": \"zonnebloemolie\",\n \"cooking oil\": \"bakolie\",\n \"soy sauce\": \"sojasaus\",\n \"tomato sauce\": \"tomatensaus\",\n \"tomato paste\": \"tomatenpuree\",\n \"pesto\": \"pesto\",\n \"mayonnaise\": \"mayonaise\",\n \"ketchup\": \"ketchup\",\n \"mustard\": \"mosterd\",\n \"vinegar\": \"azijn\",\n \"honey\": \"honing\",\n // Pantry\n \"rice\": \"rijst\",\n \"pasta\": \"pasta\",\n \"spaghetti\": \"spaghetti\",\n \"penne\": \"penne\",\n \"flour\": \"bloem\",\n \"sugar\": \"suiker\",\n \"salt\": \"zout\",\n \"pepper\": \"peper\",\n // Drinks\n \"orange juice\": \"sinaasappelsap\",\n \"apple juice\": \"appelsap\",\n \"juice\": \"sap\",\n \"water\": \"water\",\n \"tea\": \"thee\",\n \"coffee\": \"koffie\",\n};\n\n// Genereert alternatieve zoektermen voor een productnaam\nfunction getSearchTerms(name: string): string[] {\n const terms: string[] = [];\n const lower = name.toLowerCase().trim();\n\n // 1. Originele naam (gewist van hoeveelheden door cleanItemLine)\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\" → \"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 // ook vertaald zonder die woorden\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, breedste zoekopdracht)\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 // Uniek maken, behoud volgorde\n return [...new Set(terms)];\n}\n\n// Zoekt producten op Picnic en voegt ze toe aan de wagen\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","label",[134],"e05be727-a0ad-41d0-9224-ab5f74d93714",["D",1784809536224],[33],"pulls","branches",1,"forks","envVars",{"_155":157,"_158":66},"connections",{"_155":66,"_156":66},"count","unfilledCount",2,"emptyCount",{"_46":144,"_37":33,"_35":36,"_135":-5,"_44":45,"_43":14,"_137":62,"_41":165,"_13":66,"_38":26,"_39":40,"_29":30,"_142":-5,"_162":166,"_32":167},{"_46":133,"_37":134,"_35":60,"_135":-5,"_44":45,"_43":136,"_137":30,"_41":161,"_13":139,"_38":140,"_39":141,"_29":30,"_142":-5,"_162":163,"_32":164},["D",1784798749109],"children",[],[134],["D",1784809536224],[],[33],["D",1784711910300],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_19":58,"_105":106,"_107":30},{"_13":89,"_37":90,"_46":45,"_91":47,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":48,"_98":99},"ctx",{"_82":-5,"_128":205,"_206":207,"_208":209,"_210":30,"_211":30,"_212":30,"_213":62,"_214":-5,"_215":-7,"_216":-7,"_217":66,"_218":30,"_219":30,"_220":-5,"_221":30,"_222":30,"_223":30,"_224":-5},"ENV",{"_176":177,"_178":179,"_180":90,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204},"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"]

Diff · v8