31:T45c,{ const div = html`

`; if (!order_json) { let waiting_message_html = html`

Waiting for file

`; // div.append(); div.append(waiting_message_html); } else { // header let order_header_html = html`

Showing the ${ r1 === 'file' ? 'Default Example' : 'Order ' + order_json['order']['member_order_count'] }

`; div.append(order_header_html); // order stats let order_stats_html = html`

Ordered on ${new Date( order_json['order']['created_at'] ).toLocaleString('en-US', date_options)} --> Delivered on ${new Date( order_json['order']['delivery']['slot'] ).toLocaleString('en-US', date_options)}

${order_json['order']['items'].length} items

`; div.append(order_stats_html); // photos of products order_json['order']['items'].forEach(item => { let item_img_html = html``; item_img_html.src = REDMART_IMAGE_ROOT + item['images'][0]['name']; item_img_html.title = item['title']; div.append(item_img_html); }); } return div; }32:T6c5,chart = { const tooltip = d3 .select("body") .append("div") .attr("class", "basic-tooltip"); const path = d3.geoPath(projection); const svg = d3 .create("svg") .style("display", "block") .style("background-color", "rgb(188, 212, 230, 0.3)") // #bcd4e6 .attr("viewBox", [0, 0, width, height]); const g = svg.append("g"); // draw countries g.append("g") .selectAll("path") .data(countries.features) .join("path") .attr("fill", d => setCountryColor( d, order_items_filtered.map(item => item['off']['product'] ? item['off']['product']['manufacturing_places'] : '' ) ) ) .attr("d", path) .on("mouseover", function(d) { // d3.select(this).attr("fill-opacity", 0.7); d3.select(this).attr("stroke", "black"); // tooltip.html(setTooltipContent(d)) // .style("left", (d3.event.pageX + 15) + "px") // .style("top", (d3.event.pageY) + "px") // .style("visibility", "visible"); }) .on("mousemove", function(d) { tooltip .style("left", d3.event.pageX + 15 + "px") .style("top", d3.event.pageY + "px"); }) .on("mouseout", function(d) { // d3.select(this).attr("fill-opacity", 1); d3.select(this).attr("stroke", null); tooltip.style("visibility", "hidden"); }); // .append("title") // .text(d => d.properties.name) // draw borders g.append("path") .datum(topojson.mesh(world, world.objects.countries, (a, b) => a !== b)) .attr("fill", "none") .attr("stroke", "black") .attr("stroke-width", 0.3) .attr("stroke-linejoin", "round") .attr("d", path); return svg.node(); }33:[] 2f:{"title":"OpenFoodFacts x Redmart","cells":[{"id":0,"value":"md`\n# OpenFoodFacts x Redmart\n\nGoal: Stats on your Redmart order with OpenFoodFacts\n\n1. Upload your redmart order (json or default example)\n2. View stats\n\nTODO:\n- Improve Map (tooltip, arrows)\n- Super-simple Carbon Footprint calculator\n\n

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":78,"value":"viewof r1 = radio({\n title: 'Data Source',\n description: 'Upload your json file, or select the default example',\n options: [\n { label: 'Example', value: 'example' },\n { label: 'Upload', value: 'file' }\n ],\n value: 'example'\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"viewof order_file = file({\n title: \"File upload: Redmart order\",\n // description: \"Only .json files are allowed.\",\n accept: \".json\",\n multiple: false\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":244,"value":"order_file_text = await Files.text(order_file)","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"// Strange bug when using the r1 value, it doesn't want to set the order_json value\n// order_json = r1 === \"example\" ? redmart_order_default_example : JSON.parse(order_file_text)\norder_json = redmart_order_default_example","pinned":false,"hidden":false,"mode":"ojs"},{"id":450,"value":"// clean item list\norder_items_filtered = filterFoodSingleItems(order_json['order']['items'])","pinned":false,"hidden":false,"mode":"ojs"},{"id":457,"value":"// enrich with OFF data\norder_items_filtered.forEach((item, index) => {\n searchProductInOpenFoodFacts(item['sku']).then(response => {\n order_items_filtered[index]['off'] = response;\n });\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":414,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":486,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"{\n const div = html`

`;\n // header\n let order_filtered_header_html = html`

Filtered Order

`;\n div.append(order_filtered_header_html);\n // clean item list\n let order_items_filtered_html = html`

${order_items_filtered.length} items match the OpenFoodFacts products criterias (removed non-food items, cases)

`;\n div.append(order_items_filtered_html);\n // search items in OFF\n let table = html``;\n table.append(productTableHeader);\n order_items_filtered.forEach(item => {\n table.append(productTableRow(item, item['off']));\n });\n div.append(table);\n\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":405,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":"md`## Order Items Manufacturing Places`","pinned":false,"hidden":false,"mode":"ojs"},{"id":439,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":519,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":62,"value":"md`## OpenFoodFacts helpers`","pinned":false,"hidden":false,"mode":"ojs"},{"id":397,"value":"productTableHeader = html`\n\n\n\n\n\n\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":387,"value":"function productTableRow(redmart_item, off_response) {\n return html`\n\n\n\n\n\n\n\n`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":305,"value":"function searchProductInOpenFoodFacts(productCode) {\n return fetch(\n OPENFOODFACTS_READ_API + '/product' + '/' + productCode\n ).then(response => response.json());\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":324,"value":"searchProductInOpenFoodFacts('4001724819806')","pinned":false,"hidden":false,"mode":"ojs"},{"id":302,"value":"OPENFOODFACTS_READ_API = 'https://world.openfoodfacts.org/api/v0'","pinned":false,"hidden":false,"mode":"ojs"},{"id":237,"value":"md`## Redmart helpers`","pinned":false,"hidden":false,"mode":"ojs"},{"id":273,"value":"function filterFoodSingleItems(items) {\n return items.filter(\n item =>\n !item['title'].includes('Case') &&\n item['categories'].some(\n category_id => REDMART_CATEGORIES_INCLUDE.indexOf(category_id) > -1\n )\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":287,"value":"REDMART_CATEGORIES_INCLUDE = [\n 1, // food-cupboard\n 2, // beverages\n 3, // alcohol\n 212, // bakery\n 221, // dairy-chilled\n 222, // cheese\n 229, // yoghurt\n 243, // fresh-produce\n 249, // frozen\n 250, // convenience-foods\n 253, // ice-cream\n 255, // meat\n 257, // seafood\n 266, // meat-seafood\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":283,"value":"REDMART_CATEGORIES_TAGS_EXCLUDE = [\n // 'home-baking', # 11\n 'beauty-0', // 11617\n 'health', // 11271\n 'home-outdoor', // 3039\n 'household-pet', // 6\n 'furniture-home-decor',\n 'paper-products',\n 'fresh-produce', // 243\n 'fresh-fruits', // 245\n 'aircare',\n 'case-71'\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"REDMART_IMAGE_ROOT = 'https://s3-ap-southeast-1.amazonaws.com/media.redmart.com/newmedia/1600x'","pinned":false,"hidden":false,"mode":"ojs"},{"id":433,"value":"md`## Map helpers`","pinned":false,"hidden":false,"mode":"ojs"},{"id":436,"value":"height = width / 2","pinned":false,"hidden":false,"mode":"ojs"},{"id":437,"value":"projection = d3\n .geoNaturalEarth1()","pinned":false,"hidden":false,"mode":"ojs"},{"id":495,"value":"function setCountryColor(d, country_list) {\n if (country_list.indexOf(d['properties']['name']) > -1) {\n return 'red';\n }\n return 'white';\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":117,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":157,"value":"date_options = {\n return { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":121,"value":"redmart_order_default_example = fetch(\n \"https://gist.githubusercontent.com/raphodn/d262f6d071d66e3cfe14d31de64ec1a1/raw/39b8324c30263fc519a20597c6eea90d14447b11/redmart_order_example.json\"\n).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":422,"value":"countries = topojson.feature(world, world.objects.countries)","pinned":false,"hidden":false,"mode":"ojs"},{"id":420,"value":"world = fetch(\"https://cdn.jsdelivr.net/npm/world-atlas@2/countries-50m.json\").then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs"},{"id":430,"value":"topojson = require(\"topojson-client@3\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":427,"value":"d3 = require(\"d3@5\")\n// d3 = require(\"d3-geo@1\", \"d3-geo-projection@2\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"import { radio, file } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}

In OFF DB ?	Image	Item Name	Barcode	Manufactured In	NutriScore	NOVA Score
${off_response['status']}		${redmart_item['title']}	${redmart_item['sku']}	${\n off_response['product'] && off_response['product']['manufacturing_places']\n ? off_response['product']['manufacturing_places']\n : ''\n }	${\n off_response['product'] && off_response['product']['nutrition_grades']\n ? off_response['product']['nutrition_grades'].toUpperCase()\n : ''\n }	${\n off_response['product'] && off_response['product']['nova_group']\n ? off_response['product']['nova_group']\n : ''\n }