cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 -c " import pdfplumber with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: print(f'Total pages: {len(pdf.pages)}') for i, page in enumerate(pdf.pages): text = page.extract_text() print(f'--- PAGE {i+1} ---') print(text) print() "

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 -c " import pdfplumber # Let's look at pages 21-27 more carefully to get the frequency tags per item with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: for i in [20, 21, 22, 23, 24, 25, 26]: # pages 21-27 (0-indexed) page = pdf.pages[i] tables = page.extract_tables() print(f'--- PAGE {i+1} TABLES ---') for j, table in enumerate(tables): print(f'Table {j+1}:') for row in table: print(row) print() words = page.extract_words() print(f'--- PAGE {i+1} WORDS (first 50) ---') for w in words[:80]: print(w) print() "

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 -c " import pdfplumber # Extract image positions to understand color coding on page 22 (Greens & Vegetables) with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 (0-indexed = 21) # Get all rects/lines which represent the colored circles rects = page.rects print('RECTS on page 22:') for r in rects[:50]: print(r) print() lines = page.lines print('LINES on page 22 (first 20):') for l in lines[:20]: print(l) print() # Check curves/circles curves = page.curves print('CURVES on page 22 (first 20):') for c in curves[:20]: print(c) "

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber # Color mapping (from curves analysis): # Pink/Rose (1.0, 0.913725, 0.94902) = background of "Avoid" icon (red-ish) # Light green (0.894118, 0.976471, 0.792157) = background of "Every day" (green) # Light purple (0.921569, 0.831373, 1.0) = background of "Every 3 days" # The dot colors inside: # (0.854902, 0.109804, 0.360784) = deep pink/red -> Avoid # (0.317647, 0.619608, 0.0) = green -> Every day OR every other day # (0.4, 0.176471, 0.568627) = purple -> Every 3 days or avoid # Let's map: # Icon background colors (approx): # (1.0, 0.913725, 0.94902) = Pink = "Avoid" # (0.894118, 0.976471, 0.792157) = Light Green = "Everyday" # (0.921569, 0.831373, 1.0) = Light Purple = "Every 3 days" # There should be a 4th for "every other day" - let's look for orange/yellow # Let me analyze all curve colors on page 22 to understand the pattern with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 curves = page.curves # Get unique background colors (the larger rounded rectangles) bg_colors = set() for c in curves: if c['width'] > 10 and c['height'] > 10: # larger shapes = backgrounds color = c['non_stroking_color'] if isinstance(color, tuple): bg_colors.add(color) print("Unique background colors (large curves):") for col in sorted(bg_colors, key=str): print(col) print() # Now let's check positions of each icon at row of "Ash Gourd" (top ~164.638) # Items are at y ~164, 203, 242, 281, 320, 359, 398, 437, 476, 515, 554, 593, 632, 671, 710, 749 # Columns (Phase 1, 2, 3) are at x ~166-185, 210-230, 255-276 (left column) # 446-465, 490-510, 535-556 (right column) # Let's check what icons appear for Ash Gourd (y~677 in page coords since top/bottom are measured from bottom) # From words: Ash Gourd is at top=164.638, in PDF coords y = 841 - 164.638 = 676.362 target_items = [ ("Ash Gourd", 676.362), ("Beet Root", 637.362), ("Bengal Gram", 598.362), ("Bitter Gourd", 559.362), ("Bottle Gourd", 520.362), ("Brinjal", 481.362), ("Broad Beans", 442.362), ("Broccoli", 403.362), ("Cabbage", 364.362), ("Capsicum", 325.362), ("Carrot", 286.362), ("Cauliflower", 247.362), ("Chickpeas", 208.362), ("Cho Cho", 169.362), ("Cluster Beans", 130.362), ("Cowpea", 91.362), ] for item_name, item_y in target_items: icons = [] for c in curves: # Match y within ~15 units and width > 10 (background icons) if abs(c['y0'] - item_y) < 15 and c['width'] > 10: color = c['non_stroking_color'] x_center = (c['x0'] + c['x1']) / 2 icons.append((x_center, color)) icons.sort(key=lambda x: x[0]) print(f"{item_name}: {icons}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber # Let's directly look at curve y values to understand positioning with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 curves = page.curves # Show ALL curves with their top/bottom/x positions large_curves = [c for c in curves if c['width'] > 10 and c['height'] > 10] print(f"Total large curves: {len(large_curves)}") for c in large_curves[:40]: color = c['non_stroking_color'] print(f" top={c['top']:.1f} bottom={c['bottom']:.1f} x0={c['x0']:.1f} x1={c['x1']:.1f} color={color}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber # These 6 large curves at the TOP of page 22 are the LEGEND icons (Phase 1, 2, 3 header) # So each food item row must have its own icons - but they appear as images, not curves # Let's look for images on the page with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 # Check images images = page.images print(f"Images on page 22: {len(images)}") for img in images[:20]: print(f" top={img.get('top', 'N/A'):.1f} x0={img.get('x0', 'N/A'):.1f} x1={img.get('x1', 'N/A'):.1f} colorspace={img.get('colorspace', 'N/A')} srcsize={img.get('srcsize', 'N/A')}") print() print("All curves (including small ones):") all_curves = page.curves print(f"Total curves: {len(all_curves)}") # Group by approximate y position (top) from collections import defaultdict by_row = defaultdict(list) for c in all_curves: if isinstance(c['non_stroking_color'], tuple) and c['width'] > 10: row_key = round(c['top'] / 30) * 30 # group by ~30pt rows by_row[row_key].append(c) for row_y in sorted(by_row.keys()): items = by_row[row_y] print(f"Row y~{row_y}: {len(items)} icons") for c in sorted(items, key=lambda x: x['x0']): print(f" x={c['x0']:.0f}-{c['x1']:.0f}, top={c['top']:.0f}, color={c['non_stroking_color']}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber import fitz # PyMuPDF # Let's use PyMuPDF to render page and extract pixel colors at icon positions doc = fitz.open('BS042976-P jaswik--GMT-Report.pdf') page = doc[21] # page 22 (0-indexed) # Render at 2x scale for better accuracy mat = fitz.Matrix(2, 2) pix = page.get_pixmap(matrix=mat) img_data = pix.samples # raw RGB bytes width = pix.width height = pix.height print(f"Page rendered: {width}x{height}") # Known icon x positions (from image analysis): # Phase 1: x center ~ (168.7+182.8)/2 = 175.75 # Phase 2: x center ~ (212.6+228.0)/2 = 220.3 # Phase 3: x center ~ (258.4+273.9)/2 = 266.15 # Right column Phase 1: x ~ (448.7+462.8)/2 = 455.75 # Right column Phase 2: x ~ (492.6+508.0)/2 = 500.3 # Right column Phase 3: x ~ (538.4+553.9)/2 = 546.15 # Food item rows (top in PDF coords): # Ash Gourd: top~155.3-161 # Items every ~39px apart # From images list: tops = 155, 194, 233, 272, 311, 350, 389, 428, 467, 506, 545, 584, 623, 662, 701, 740 (left col) food_items_left = [ "Ash Gourd", "Beet Root", "Bengal Gram", "Bitter Gourd", "Bottle Gourd", "Brinjal", "Broad Beans", "Broccoli", "Cabbage", "Capsicum", "Carrot", "Cauliflower", "Chickpeas", "Cho Cho", "Cluster Beans", "Cowpea" ] food_items_right = [ "Cucumber", "Drumstick", "Fenugreek Leaves", "Field Bean", "French Beans", "Gogu Leaves", "Green Chillies", "Green Gram", "Green Peas", "Horse Gram", "Kidney Beans", "Knol", "Ladies Finger", "Moth Bean", "Mung Bean", "Mushrooms" ] # Icon top positions start at ~155 and increment by ~39 row_tops = [155 + i*39 for i in range(16)] # At 2x scale: multiply all positions by 2 scale = 2 phase_x = [175, 220, 266] # Phase 1, 2, 3 centers (left column) right_phase_x = [455, 500, 546] # Phase 1, 2, 3 centers (right column) def get_dominant_color(pix, img_width, center_x, center_y, scale): """Get the dominant color in a ~8x8 region around center point""" cx = int(center_x * scale) cy = int(center_y * scale) r_vals, g_vals, b_vals = [], [], [] for dy in range(-6, 7): for dx in range(-6, 7): nx, ny = cx+dx, cy+dy if 0 <= nx < img_width and 0 <= ny < pix.height: idx = (ny * img_width + nx) * 3 if idx + 2 < len(pix.samples): r, g, b = pix.samples[idx], pix.samples[idx+1], pix.samples[idx+2] r_vals.append(r) g_vals.append(g) b_vals.append(b) if not r_vals: return (0, 0, 0) return (int(sum(r_vals)/len(r_vals)), int(sum(g_vals)/len(g_vals)), int(sum(b_vals)/len(b_vals))) def classify_color(r, g, b): """Classify color to frequency category""" # Red/avoid: high R, low G, low B # Green/everyday: high G # Orange/every other day: high R+G, low B # Purple/every 3 days: high R+B, low G if r > 180 and g < 100 and b < 100: return "AVOID" elif g > 140 and r < 200 and b < 130: return "EVERYDAY" elif r > 200 and g > 150 and b < 80: return "EVERY_OTHER_DAY" elif r > 100 and b > 100 and g < 100: return "EVERY_3_DAYS" elif r > 200 and g > 180 and b > 180: return "EVERYDAY" # light = often means everyday (white/light green) else: return f"UNKNOWN({r},{g},{b})" print("\nSample analysis of first 5 rows (left column):") for i, item in enumerate(food_items_left[:5]): row_top = row_tops[i] + 4 # center of icon (add ~4 to get to center of 32px icon) phases = [] for px in phase_x: color = get_dominant_color(pix, width, px, row_top, scale) cat = classify_color(*color) phases.append(f"P{phase_x.index(px)+1}:{cat}({color})") print(f" {item}: {' | '.join(phases)}") doc.close() EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber from PIL import Image import io, struct # Extract the actual icon images from PDF using pdfplumber with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 images = page.images # The frequency icons are at x~168-274 and x~448-554 # The food icons are at x~29-54 # Each row has: food icon at x~30-54, then 3 phase icons at x~168,212,258 (left col) # food icon at x~309-334, then 3 phase icons at x~448,492,538 (right col) # Let's get all icons per row and classify # Group images by their top coordinate from collections import defaultdict by_row = defaultdict(list) for img in images: if img.get('srcsize') == (32, 32): # Only the icon images top_rounded = round(img['top'] / 5) * 5 # round to nearest 5 by_row[top_rounded].append(img) print(f"Rows found: {len(by_row)}") for row_top in sorted(by_row.keys())[:10]: imgs = sorted(by_row[row_top], key=lambda x: x['x0']) print(f"Row {row_top}: {len(imgs)} images") for img in imgs: print(f" x0={img['x0']:.1f} x1={img['x1']:.1f} top={img['top']:.1f}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber from PIL import Image import io # Extract actual image pixels from an icon to see its color with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 images = page.images # Get the first 3 phase icons for row 1 (Ash Gourd) phase_icons = [img for img in images if img['top'] > 153 and img['top'] < 160 and img['x0'] > 150] phase_icons.sort(key=lambda x: x['x0']) print("Phase icons for row 1 (Ash Gourd / Cucumber):") for img in phase_icons[:6]: print(f" x0={img['x0']:.1f} top={img['top']:.1f}") # Extract raw image data if 'stream' in img: try: raw = img['stream'].read() print(f" stream length: {len(raw)}") print(f" first bytes: {raw[:20].hex()}") except: pass # Try to get image via different key for key in img.keys(): print(f" key: {key} = {str(img[key])[:50]}") break EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber from PIL import Image import io # Extract and analyze actual icon pixel colors with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] # page 22 images = page.images # Get all phase icons (x > 150, srcsize=(32,32)) phase_icons = [img for img in images if img.get('srcsize') == (32, 32) and img['x0'] > 150] phase_icons.sort(key=lambda x: (round(x['top']/5)*5, x['x0'])) # Analyze unique icon types by looking at pixel data seen_names = {} for img in phase_icons[:20]: name = img['name'] if name not in seen_names: stream = img['stream'] raw = stream.read() # Try to open as image try: image = Image.open(io.BytesIO(raw)) image = image.convert('RGB') pixels = list(image.getdata()) # Get average color (center pixels) center_pixels = pixels[10*32+10:10*32+22] # row 10, cols 10-22 avg_r = sum(p[0] for p in center_pixels) // len(center_pixels) avg_g = sum(p[1] for p in center_pixels) // len(center_pixels) avg_b = sum(p[2] for p in center_pixels) // len(center_pixels) seen_names[name] = f"RGB({avg_r},{avg_g},{avg_b})" except Exception as e: # Try raw RGB if len(raw) == 32*32*3: # Direct RGB center_start = (10*32 + 10) * 3 r = raw[center_start] g = raw[center_start+1] b = raw[center_start+2] seen_names[name] = f"RGB({r},{g},{b}) [raw]" else: seen_names[name] = f"Error({e}), raw_len={len(raw)}" top_rounded = round(img['top']/5)*5 print(f"top~{top_rounded} x={img['x0']:.0f} name={name} -> {seen_names[name]}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber from PIL import Image import io # Use pdfplumber's page.images and extract via pdf object with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: page = pdf.pages[21] images = page.images phase_icons = [img for img in images if img.get('srcsize') == (32, 32) and img['x0'] > 150] phase_icons.sort(key=lambda x: (round(x['top']/5)*5, x['x0'])) seen_names = {} for img in phase_icons[:20]: name = img['name'] if name not in seen_names: stream_obj = img['stream'] # PDFStream object - get the raw data try: raw = stream_obj.get_data() except: try: raw = stream_obj.get_rawdata() except: try: raw = bytes(stream_obj) except Exception as e2: seen_names[name] = f"Cannot read: {e2}" continue # The image is 32x32 RGB = 3072 bytes if len(raw) == 32*32*3: # Sample center pixels (row 10-22, col 10-22) r_vals, g_vals, b_vals = [], [], [] for row in range(10, 22): for col in range(10, 22): idx = (row * 32 + col) * 3 r_vals.append(raw[idx]) g_vals.append(raw[idx+1]) b_vals.append(raw[idx+2]) avg_r = sum(r_vals)//len(r_vals) avg_g = sum(g_vals)//len(g_vals) avg_b = sum(b_vals)//len(b_vals) seen_names[name] = f"RGB({avg_r},{avg_g},{avg_b})" else: seen_names[name] = f"len={len(raw)}" top_rounded = round(img['top']/5)*5 print(f"top~{top_rounded} x={img['x0']:.0f} name={name} -> {seen_names.get(name,'?')}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber from PIL import Image # Full extraction across all food pages def get_icon_color_name(raw): if len(raw) < 32*32*3: return "?" r_vals, g_vals, b_vals = [], [], [] for row in range(8, 24): for col in range(8, 24): idx = (row * 32 + col) * 3 if idx+2 < len(raw): r_vals.append(raw[idx]) g_vals.append(raw[idx+1]) b_vals.append(raw[idx+2]) if not r_vals: return "?" avg_r = sum(r_vals)//len(r_vals) avg_g = sum(g_vals)//len(g_vals) avg_b = sum(b_vals)//len(b_vals) # Classify if avg_r > 200 and avg_g > 220 and avg_b > 100 and avg_g > avg_b: return "EVERYDAY" # light green elif avg_b > 200 and avg_r > 180 and avg_g > 210: return "EVERY_OTHER_DAY" # light blue elif avg_r > 240 and avg_g > 200 and avg_b < 160: return "EVERY_3_DAYS" # yellow/orange elif avg_r > 220 and avg_g < 150 and avg_b < 150: return "AVOID" # red/pink else: return f"UNK({avg_r},{avg_g},{avg_b})" # Cache icon name -> category icon_cache = {} def get_icon_category(stream_obj): try: raw = stream_obj.get_data() except: return "?" # Create a hash key from first 50 bytes key = bytes(raw[:100]) if key in icon_cache: return icon_cache[key] cat = get_icon_color_name(raw) icon_cache[key] = cat return cat # Pages with food data: 22-27 (0-indexed 21-26) # Food items structure: # Each page has left column (items 1-N) and right column (items N+1-M) # Phase icons at x: 168-183 (P1), 212-228 (P2), 258-274 (P3) for left col # 448-463 (P1), 492-508 (P2), 538-554 (P3) for right col with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: # First, learn all unique icons across pages all_icon_colors = {} for pg_idx in range(21, 28): page = pdf.pages[pg_idx] for img in page.images: if img.get('srcsize') == (32, 32): name = img['name'] if name not in all_icon_colors: try: raw = img['stream'].get_data() cat = get_icon_color_name(raw) all_icon_colors[name] = cat except: pass print("All unique icon types found:") for name, cat in sorted(all_icon_colors.items()): print(f" {name}: {cat}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber # Only look at phase icon positions (x > 150, specific x ranges) # Phase icon x ranges: 168-183, 212-228, 258-274, 448-463, 492-508, 538-554 def get_icon_color_name(raw): if len(raw) < 32*32*3: return "?" r_vals, g_vals, b_vals = [], [], [] for row in range(8, 24): for col in range(8, 24): idx = (row * 32 + col) * 3 if idx+2 < len(raw): r_vals.append(raw[idx]) g_vals.append(raw[idx+1]) b_vals.append(raw[idx+2]) if not r_vals: return "?" r = sum(r_vals)//len(r_vals) g = sum(g_vals)//len(g_vals) b = sum(b_vals)//len(b_vals) return f"RGB({r},{g},{b})" phase_x_ranges = [(165,185), (208,232), (254,278), (444,467), (488,512), (534,558)] with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: # Collect unique icon name -> color for phase positions only phase_icons_found = {} for pg_idx in range(21, 28): page = pdf.pages[pg_idx] for img in page.images: if img.get('srcsize') == (32, 32): x0 = img['x0'] # Check if in a phase icon column in_phase_col = any(lo <= x0 <= hi for lo,hi in phase_x_ranges) if in_phase_col: name = img['name'] if name not in phase_icons_found: try: raw = img['stream'].get_data() color = get_icon_color_name(raw) phase_icons_found[name] = color except: phase_icons_found[name] = "error" print("Phase icon types:") for name, color in sorted(phase_icons_found.items()): print(f" {name}: {color}") EOF

cd /home/daytona/workspace/attachments/a351c83b-623e-4efe-af71-eb6454de11b4/ && python3 << 'EOF' import pdfplumber from collections import defaultdict # Icon name -> frequency ICON_MAP = { 'x367': 'Everyday', 'x368': 'Every Other Day', 'x369': 'Every 3 Days', 'x370': 'Avoid', } # Phase icon x ranges PHASE_COLS = [ (165, 185), # Phase 1 left col (208, 232), # Phase 2 left col (254, 278), # Phase 3 left col (444, 467), # Phase 1 right col (488, 512), # Phase 2 right col (534, 558), # Phase 3 right col ] def get_phase_col(x): for i, (lo, hi) in enumerate(PHASE_COLS): if lo <= x <= hi: col_idx = i % 3 # 0=P1, 1=P2, 2=P3 side = 'R' if i >= 3 else 'L' return (side, col_idx) return None # Food items per page (from text extraction) FOOD_DATA = { # Page 22 - Greens & Vegetables 21: { 'category': 'Greens & Vegetables', 'left': ["Ash Gourd","Beet Root","Bengal Gram","Bitter Gourd","Bottle Gourd", "Brinjal","Broad Beans","Broccoli","Cabbage","Capsicum","Carrot", "Cauliflower","Chickpeas","Cho Cho","Cluster Beans","Cowpea"], 'right': ["Cucumber","Drumstick","Fenugreek Leaves","Field Bean","French Beans", "Gogu Leaves","Green Chillies","Green Gram","Green Peas","Horse Gram", "Kidney Beans","Knol","Ladies Finger","Moth Bean","Mung Bean","Mushrooms"], }, # Page 23 22: { 'category': 'Greens & Vegetables (cont) / Cereals, Herbs & Condiments', 'left': ["Onion","Pigeon Pea","Pointed Gourd","Potato","Pumpkin","Radish","Ridge Gourd"], 'right': ["Snake Gourd","Spinach","Sweet Corn","Sweet Potato","Tinda","Tomatoes","Yam"], 'left2': ["Almond","Asafoetida","Cardamom","Cashew Nut","Cloves","Coconut","Coconut Oil"], 'right2': ["Coriander Leaves","Coriander Seeds","Cumin Seeds","Curry Leaves","Dates","Fenugreek Seeds","Finger Millet"], }, # Page 24 23: { 'category': 'Cereals, Herbs & Condiments (cont)', 'left': ["Garlic","Ghee","Ginger","Ground Nut","Honey","Jaggery","Kodo Millets", "Little Millets","Maize","Mint Leaves","Mustard Oil","Mustard Seeds", "Olive Oil","Palm Oil","Pearl Millet","Pepper"], 'right': ["Pistachio Nuts","Poppy Seeds","Red Chilli Powder","Rice Bran Oil", "Rice Flakes","Rice Puffed","Sesame Oil","Sesame Seeds","Shalgam", "Sunflower Oil","Sunflower Seeds","Turmeric Powder","Walnut", "Wheat","Wheat Flour","White Rice"], }, # Page 25 - Fruits + Egg & Meat 24: { 'category': 'Fruits', 'left': ["Apple","Banana","Custard Apple","Fig","Goosberry","Grapes","Guava", "Jack Fruit","Kala Jamun","Kokum","Lychee","Mango"], 'right': ["Mosambi","Muskmelon","Orange","Papaya","Pear","Pineapple","Pomegranate", "Raisins","Sapota","Strawberry","Watermelon","Wood Apple"], 'left2': ["Beef"], 'right2': ["Catla"], }, # Page 26 - Egg & Meat + Milk & Fermented 25: { 'category': 'Egg & Meat / Milk & Fermented Products', 'left': ["Chicken","Crab","Egg","Goat","Haddock","Mussels","Oysters","Pork"], 'right': ["Prawns","Rohu","Salmon","Sardine","Sheep","Trout","Tuna","Turkey"], 'left2': ["Butter Milk","Cheese","Soy Products","Kefir","Kimchi"], 'right2': ["Kombucha","Panner","Sauerkraut","Shrikhand","Yogurt"], }, # Page 27 - Processed Foods + Drinks 26: { 'category': 'Processed Foods / Drinks & Beverages', 'left': ["Artificial Sweeteners","Bakery Breads","Burger","Cake","Cookies", "Crackers","Dark Chocolate","French Toast","Garlic Bread"], 'right': ["Ice Cream","Milk Chocolate","Noodles","Pasta","Pastry","Pizza", "Rolls","Sandwich","Taco"], 'left2': ["Beer","Carbonated Beverages","Distilled Alcoholic Beverages","Milk Shakes"], 'right2': ["Red Wine","Soy Milk","Sugarcane Juice","Tender Coconut"], }, } with pdfplumber.open('BS042976-P jaswik--GMT-Report.pdf') as pdf: results = {} # food_name -> {P1: freq, P2: freq, P3: freq} for pg_idx in [21, 22, 23, 24, 25, 26]: page = pdf.pages[pg_idx] images = page.images # Get phase icons only (at specific x positions) phase_imgs = [] for img in images: if img.get('srcsize') == (32, 32): col_info = get_phase_col(img['x0']) if col_info: name = img['name'] freq = ICON_MAP.get(name, '?') phase_imgs.append({ 'top': img['top'], 'side': col_info[0], 'phase': col_info[1], 'freq': freq }) # Group by row (top position) by_row = defaultdict(dict) for pi in phase_imgs: row_key = round(pi['top'] / 5) * 5 side_phase = f"{pi['side']}_P{pi['phase']+1}" by_row[row_key][side_phase] = pi['freq'] # Match rows to food items based on position # The first row of icons is at top~155 for page 22 # Subsequent rows are ~39px apart # Get sorted row positions sorted_rows = sorted(by_row.keys()) pg_data = FOOD_DATA.get(pg_idx, {}) left_items = pg_data.get('left', []) right_items = pg_data.get('right', []) left2_items = pg_data.get('left2', []) right2_items = pg_data.get('right2', []) # Separate into "first table" rows and "second table" rows # On pg 22, first table rows are for Greens&Veg, then second table for Cereals # The second table starts after a gap print(f"\n=== Page {pg_idx+1} ===") print(f"Found {len(sorted_rows)} icon rows at tops: {sorted_rows}") for row in sorted_rows: print(f" Row {row}: {by_row[row]}") EOF

mkdir -p /home/daytona/workspace/gut-microbiome-report && cat > /home/daytona/workspace/gut-microbiome-report/build_table.py << 'PYEOF' from openpyxl import Workbook from openpyxl.styles import Font, PatternFill, Alignment, Border, Side from openpyxl.utils import get_column_letter # ============================================================ # COMPLETE FOOD DATA with phase frequencies # Assembled from PDF icon extraction # ============================================================ # Format: (Food Item, P1, P2, P3, Category) # Frequencies: E=Everyday, A=Every Other Day, 3=Every 3 Days, X=Avoid food_data = [ # =========== GREENS & VEGETABLES =========== ("Ash Gourd", "E", "A", "A", "Greens & Vegetables"), ("Beet Root", "E", "A", "A", "Greens & Vegetables"), ("Bengal Gram", "A", "A", "3", "Greens & Vegetables"), ("Bitter Gourd", "A", "A", "A", "Greens & Vegetables"), ("Bottle Gourd", "E", "E", "E", "Greens & Vegetables"), ("Brinjal", "A", "A", "A", "Greens & Vegetables"), ("Broad Beans", "E", "E", "E", "Greens & Vegetables"), ("Broccoli", "A", "A", "3", "Greens & Vegetables"), ("Cabbage", "E", "E", "E", "Greens & Vegetables"), ("Capsicum", "3", "A", "A", "Greens & Vegetables"), ("Carrot", "E", "E", "E", "Greens & Vegetables"), ("Cauliflower", "A", "A", "3", "Greens & Vegetables"), ("Chickpeas", "3", "A", "A", "Greens & Vegetables"), ("Cho Cho", "A", "A", "A", "Greens & Vegetables"), ("Cluster Beans", "A", "A", "A", "Greens & Vegetables"), ("Cowpea", "A", "A", "3", "Greens & Vegetables"), ("Cucumber", "A", "A", "3", "Greens & Vegetables"), ("Drumstick", "A", "A", "A", "Greens & Vegetables"), ("Fenugreek Leaves", "A", "A", "A", "Greens & Vegetables"), ("Field Bean", "A", "A", "A", "Greens & Vegetables"), ("French Beans", "A", "A", "A", "Greens & Vegetables"), ("Gogu Leaves", "3", "A", "A", "Greens & Vegetables"), ("Green Chillies", "A", "A", "A", "Greens & Vegetables"), ("Green Gram", "A", "A", "A", "Greens & Vegetables"), ("Green Peas", "A", "E", "E", "Greens & Vegetables"), ("Horse Gram", "3", "A", "A", "Greens & Vegetables"), ("Kidney Beans", "A", "A", "A", "Greens & Vegetables"), ("Knol", "A", "3", "3", "Greens & Vegetables"), ("Ladies Finger", "A", "A", "A", "Greens & Vegetables"), ("Moth Bean", "A", "A", "A", "Greens & Vegetables"), ("Mung Bean", "E", "A", "A", "Greens & Vegetables"), ("Mushrooms", "3", "A", "A", "Greens & Vegetables"), ("Onion", "E", "E", "E", "Greens & Vegetables"), ("Pigeon Pea", "E", "E", "A", "Greens & Vegetables"), ("Pointed Gourd", "3", "3", "A", "Greens & Vegetables"), ("Potato", "3", "A", "A", "Greens & Vegetables"), ("Pumpkin", "E", "E", "E", "Greens & Vegetables"), ("Radish", "E", "A", "A", "Greens & Vegetables"), ("Ridge Gourd", "A", "A", "3", "Greens & Vegetables"), ("Snake Gourd", "A", "A", "A", "Greens & Vegetables"), ("Spinach", "E", "A", "A", "Greens & Vegetables"), ("Sweet Corn", "3", "3", "A", "Greens & Vegetables"), ("Sweet Potato", "E", "A", "A", "Greens & Vegetables"), ("Tinda", "A", "A", "A", "Greens & Vegetables"), ("Tomatoes", "E", "E", "E", "Greens & Vegetables"), ("Yam", "A", "A", "3", "Greens & Vegetables"), # =========== CEREALS, HERBS & CONDIMENTS =========== ("Almond", "E", "E", "A", "Cereals, Herbs & Condiments"), ("Asafoetida", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Cardamom", "A", "A", "3", "Cereals, Herbs & Condiments"), ("Cashew Nut", "A", "A", "A", "Cereals, Herbs & Condiments"), ("Cloves", "E", "A", "A", "Cereals, Herbs & Condiments"), ("Coconut", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Coconut Oil", "E", "A", "A", "Cereals, Herbs & Condiments"), ("Coriander Leaves", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Coriander Seeds", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Cumin Seeds", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Curry Leaves", "A", "E", "E", "Cereals, Herbs & Condiments"), ("Dates", "A", "A", "A", "Cereals, Herbs & Condiments"), ("Fenugreek Seeds", "E", "A", "A", "Cereals, Herbs & Condiments"), ("Finger Millet", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Garlic", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Ghee", "E", "E", "A", "Cereals, Herbs & Condiments"), ("Ginger", "A", "A", "A", "Cereals, Herbs & Condiments"), ("Ground Nut", "E", "E", "A", "Cereals, Herbs & Condiments"), ("Honey", "E", "E", "A", "Cereals, Herbs & Condiments"), ("Jaggery", "3", "3", "A", "Cereals, Herbs & Condiments"), ("Kodo Millets", "A", "A", "3", "Cereals, Herbs & Condiments"), ("Little Millets", "A", "A", "3", "Cereals, Herbs & Condiments"), ("Maize", "E", "A", "A", "Cereals, Herbs & Condiments"), ("Mint Leaves", "3", "A", "A", "Cereals, Herbs & Condiments"), ("Mustard Oil", "3", "3", "A", "Cereals, Herbs & Condiments"), ("Mustard Seeds", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Olive Oil", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Palm Oil", "A", "3", "3", "Cereals, Herbs & Condiments"), ("Pearl Millet", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Pepper", "A", "E", "A", "Cereals, Herbs & Condiments"), ("Pistachio Nuts", "A", "A", "A", "Cereals, Herbs & Condiments"), ("Poppy Seeds", "A", "A", "3", "Cereals, Herbs & Condiments"), ("Red Chilli Powder", "3", "A", "A", "Cereals, Herbs & Condiments"), ("Rice Bran Oil", "A", "A", "3", "Cereals, Herbs & Condiments"), ("Rice Flakes", "A", "3", "3", "Cereals, Herbs & Condiments"), ("Rice Puffed", "3", "A", "A", "Cereals, Herbs & Condiments"), ("Sesame Oil", "3", "3", "A", "Cereals, Herbs & Condiments"), ("Sesame Seeds", "A", "A", "3", "Cereals, Herbs & Condiments"), ("Shalgam", "E", "A", "A", "Cereals, Herbs & Condiments"), ("Sunflower Oil", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Sunflower Seeds", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Turmeric Powder", "E", "E", "E", "Cereals, Herbs & Condiments"), ("Walnut", "A", "3", "3", "Cereals, Herbs & Condiments"), ("Wheat", "A", "A", "A", "Cereals, Herbs & Condiments"), ("Wheat Flour", "E", "E", "A", "Cereals, Herbs & Condiments"), ("White Rice", "A", "3", "A", "Cereals, Herbs & Condiments"), # =========== FRUITS =========== ("Apple", "E", "E", "A", "Fruits"), ("Banana", "E", "E", "A", "Fruits"), ("Custard Apple", "A", "A", "3", "Fruits"), ("Fig", "E", "A", "A", "Fruits"), ("Goosberry", "E", "A", "A", "Fruits"), ("Grapes", "E", "E", "A", "Fruits"), ("Guava", "E", "E", "A", "Fruits"), ("Jack Fruit", "A", "A", "3", "Fruits"), ("Kala Jamun", "A", "A", "3", "Fruits"), ("Kokum", "E", "A", "A", "Fruits"), ("Lychee", "A", "A", "3", "Fruits"), ("Mango", "A", "A", "3", "Fruits"), ("Mosambi", "3", "3", "A", "Fruits"), ("Muskmelon", "A", "A", "3", "Fruits"), ("Orange", "E", "E", "A", "Fruits"), ("Papaya", "A", "A", "3", "Fruits"), ("Pear", "A", "A", "3", "Fruits"), ("Pineapple", "A", "A", "3", "Fruits"), ("Pomegranate", "A", "A", "3", "Fruits"), ("Raisins", "A", "A", "3", "Fruits"), ("Sapota", "A", "A", "3", "Fruits"), ("Strawberry", "A", "A", "3", "Fruits"), ("Watermelon", "A", "A", "3", "Fruits"), ("Wood Apple", "E", "E", "A", "Fruits"), # =========== EGG & MEAT =========== ("Beef", "X", "X", "X", "Egg & Meat"), ("Catla", "3", "A", "A", "Egg & Meat"), ("Chicken", "X", "3", "A", "Egg & Meat"), ("Crab", "X", "3", "A", "Egg & Meat"), ("Egg", "X", "3", "A", "Egg & Meat"), ("Goat", "X", "X", "X", "Egg & Meat"), ("Haddock", "X", "3", "A", "Egg & Meat"), ("Mussels", "X", "3", "3", "Egg & Meat"), ("Oysters", "X", "3", "A", "Egg & Meat"), ("Pork", "X", "X", "X", "Egg & Meat"), ("Prawns", "X", "3", "A", "Egg & Meat"), ("Rohu", "X", "3", "A", "Egg & Meat"), ("Salmon", "X", "A", "A", "Egg & Meat"), ("Sardine", "X", "3", "A", "Egg & Meat"), ("Sheep", "X", "X", "X", "Egg & Meat"), ("Trout", "X", "A", "A", "Egg & Meat"), ("Tuna", "X", "A", "A", "Egg & Meat"), ("Turkey", "X", "X", "X", "Egg & Meat"), # =========== MILK & FERMENTED PRODUCTS =========== ("Butter Milk", "X", "E", "A", "Milk & Fermented Products"), ("Cheese", "X", "A", "A", "Milk & Fermented Products"), ("Soy Products", "X", "A", "3", "Milk & Fermented Products"), ("Kefir", "X", "A", "3", "Milk & Fermented Products"), ("Kimchi", "X", "E", "3", "Milk & Fermented Products"), ("Kombucha", "X", "A", "3", "Milk & Fermented Products"), ("Panner", "X", "A", "A", "Milk & Fermented Products"), ("Sauerkraut", "X", "A", "A", "Milk & Fermented Products"), ("Shrikhand", "X", "A", "3", "Milk & Fermented Products"), ("Yogurt", "X", "A", "A", "Milk & Fermented Products"), # =========== PROCESSED FOODS =========== ("Artificial Sweeteners","X", "X", "X", "Processed Foods"), ("Bakery Breads", "X", "X", "X", "Processed Foods"), ("Burger", "X", "X", "X", "Processed Foods"), ("Cake", "X", "X", "X", "Processed Foods"), ("Cookies", "X", "X", "X", "Processed Foods"), ("Crackers", "X", "X", "X", "Processed Foods"), ("Dark Chocolate", "X", "X", "3", "Processed Foods"), ("French Toast", "X", "X", "X", "Processed Foods"), ("Garlic Bread", "X", "X", "X", "Processed Foods"), ("Ice Cream", "X", "X", "X", "Processed Foods"), ("Milk Chocolate", "X", "X", "X", "Processed Foods"), ("Noodles", "X", "X", "X", "Processed Foods"), ("Pasta", "X", "X", "X", "Processed Foods"), ("Pastry", "X", "X", "X", "Processed Foods"), ("Pizza", "X", "X", "X", "Processed Foods"), ("Rolls", "X", "X", "X", "Processed Foods"), ("Sandwich", "X", "X", "X", "Processed Foods"), ("Taco", "X", "X", "X", "Processed Foods"), # =========== DRINKS & BEVERAGES =========== ("Beer", "X", "3", "3", "Drinks & Beverages"), ("Carbonated Beverages", "X", "X", "X", "Drinks & Beverages"), ("Distilled Alcoholic Beverages","X","X","X","Drinks & Beverages"), ("Milk Shakes", "X", "X", "X", "Drinks & Beverages"), ("Red Wine", "3", "3", "3", "Drinks & Beverages"), ("Soy Milk", "3", "3", "A", "Drinks & Beverages"), ("Sugarcane Juice", "X", "X", "X", "Drinks & Beverages"), ("Tender Coconut", "E", "E", "A", "Drinks & Beverages"), ] # ============================================================ # BUILD EXCEL # ============================================================ wb = Workbook() ws = wb.active ws.title = "Food Guide" # Color palette COLORS = { 'header_bg': "2E4057", # Dark blue 'header_font': "FFFFFF", 'cat_bg': "054A29", # Dark green for category rows 'cat_font': "FFFFFF", 'E_bg': "D4EDDA", # Light green = Everyday 'A_bg': "CCE5FF", # Light blue = Every Other Day '3_bg': "FFF3CD", # Yellow = Every 3 Days 'X_bg': "F8D7DA", # Pink/red = Avoid 'E_dot': "28A745", # Green dot 'A_dot': "007BFF", # Blue dot '3_dot': "FFC107", # Yellow dot 'X_dot': "DC3545", # Red dot 'alt_row': "F8F9FA", # Light grey alternating 'white': "FFFFFF", 'legend_bg': "E8F4FD", } FREQ_LABELS = { 'E': '● Every Day', 'A': '● Every Other Day', '3': '● Every 3 Days', 'X': '✕ Avoid', } def make_fill(hex_color): return PatternFill(start_color=hex_color, end_color=hex_color, fill_type="solid") def make_font(bold=False, color="000000", size=11): return Font(bold=bold, color=color, size=size, name="Calibri") def thin_border(): thin = Side(style='thin', color='CCCCCC') return Border(left=thin, right=thin, top=thin, bottom=thin) # ============================================================ # TITLE ws.merge_cells('A1:F1') ws['A1'] = "BugSpeaks® Gut Microbiome - Personalised Food Guide" ws['A1'].font = Font(bold=True, size=16, color=COLORS['header_font'], name="Calibri") ws['A1'].fill = make_fill(COLORS['header_bg']) ws['A1'].alignment = Alignment(horizontal='center', vertical='center', wrap_text=True) ws.row_dimensions[1].height = 40 ws.merge_cells('A2:F2') ws['A2'] = "Patient: P Jaswik | ID: BS042976 | Report Date: 2026-06-15 | Sample Received: 2026-06-02" ws['A2'].font = Font(bold=False, size=10, color="666666", name="Calibri") ws['A2'].fill = make_fill("EBF3FB") ws['A2'].alignment = Alignment(horizontal='center', vertical='center') ws.row_dimensions[2].height = 22 # LEGEND ws.merge_cells('A3:F3') ws['A3'] = "FREQUENCY LEGEND: 🟢 Every Day (daily) 🔵 Every Other Day (1 meal/2 days) 🟡 Every 3 Days (1 meal/3 days) 🔴 Avoid" ws['A3'].font = Font(bold=True, size=10, name="Calibri", color="333333") ws['A3'].fill = make_fill(COLORS['legend_bg']) ws['A3'].alignment = Alignment(horizontal='center', vertical='center') ws.row_dimensions[3].height = 20 ws.row_dimensions[4].height = 6 # spacer # COLUMN HEADERS headers = ['#', 'Food Item', 'Category', 'Phase 1\n(Weeks 1-2)', 'Phase 2\n(Weeks 3-10)', 'Phase 3\n(Weeks 11-12)'] for col, h in enumerate(headers, 1): cell = ws.cell(row=5, column=col, value=h) cell.font = Font(bold=True, color=COLORS['header_font'], size=11, name="Calibri") cell.fill = make_fill(COLORS['header_bg']) cell.alignment = Alignment(horizontal='center', vertical='center', wrap_text=True) cell.border = thin_border() ws.row_dimensions[5].height = 36 # COLUMN WIDTHS ws.column_dimensions['A'].width = 5 ws.column_dimensions['B'].width = 28 ws.column_dimensions['C'].width = 30 ws.column_dimensions['D'].width = 22 ws.column_dimensions['E'].width = 22 ws.column_dimensions['F'].width = 22 # PHASE DESCRIPTIONS - sub-row ws.merge_cells('D6:D6') ws['D6'] = "Restore (Strict Anti-inflammatory)" ws['D6'].font = Font(italic=True, size=9, color="555555", name="Calibri") ws['D6'].alignment = Alignment(horizontal='center', wrap_text=True) ws['E6'] = "Rebuild (Probiotic Reintroduction)" ws['E6'].font = Font(italic=True, size=9, color="555555", name="Calibri") ws['E6'].alignment = Alignment(horizontal='center', wrap_text=True) ws['F6'] = "Maintain (Long-term Sustenance)" ws['F6'].font = Font(italic=True, size=9, color="555555", name="Calibri") ws['F6'].alignment = Alignment(horizontal='center', wrap_text=True) ws.row_dimensions[6].height = 28 FREQ_COLORS_BG = {'E': COLORS['E_bg'], 'A': COLORS['A_bg'], '3': COLORS['3_bg'], 'X': COLORS['X_bg']} FREQ_COLORS_FG = {'E': COLORS['E_dot'], 'A': COLORS['A_dot'], '3': COLORS['3_dot'], 'X': COLORS['X_dot']} # DATA ROWS current_cat = None row_num = 7 item_num = 0 alt = False for item, p1, p2, p3, cat in food_data: # Category separator if cat != current_cat: current_cat = cat ws.merge_cells(f'A{row_num}:F{row_num}') ws[f'A{row_num}'] = f" {cat.upper()}" ws[f'A{row_num}'].font = Font(bold=True, color=COLORS['cat_font'], size=11, name="Calibri") ws[f'A{row_num}'].fill = make_fill(COLORS['cat_bg']) ws[f'A{row_num}'].alignment = Alignment(horizontal='left', vertical='center', indent=1) ws[f'A{row_num}'].border = thin_border() ws.row_dimensions[row_num].height = 24 row_num += 1 item_num = 0 alt = False item_num += 1 alt = not alt row_bg = COLORS['alt_row'] if alt else COLORS['white'] # Row data cells_data = [ ('A', item_num, row_bg, "000000", False, 'center'), ('B', item, row_bg, "111111", False, 'left'), ('C', cat, row_bg, "555555", False, 'left'), ('D', FREQ_LABELS[p1], FREQ_COLORS_BG[p1], FREQ_COLORS_FG[p1], True, 'center'), ('E', FREQ_LABELS[p2], FREQ_COLORS_BG[p2], FREQ_COLORS_FG[p2], True, 'center'), ('F', FREQ_LABELS[p3], FREQ_COLORS_BG[p3], FREQ_COLORS_FG[p3], True, 'center'), ] for col_letter, value, bg, fg, bold, align in cells_data: cell = ws[f'{col_letter}{row_num}'] cell.value = value cell.font = Font(bold=bold, color=fg, size=10, name="Calibri") cell.fill = make_fill(bg) cell.alignment = Alignment(horizontal=align, vertical='center', indent=(1 if align=='left' else 0)) cell.border = thin_border() ws.row_dimensions[row_num].height = 20 row_num += 1 # ============================================================ # SUMMARY SHEET ws2 = wb.create_sheet("Summary") ws2.column_dimensions['A'].width = 35 ws2.column_dimensions['B'].width = 12 ws2.column_dimensions['C'].width = 12 ws2.column_dimensions['D'].width = 12 # Title ws2.merge_cells('A1:D1') ws2['A1'] = "Quick Reference Summary: Gut Health Score & Recommendations" ws2['A1'].font = Font(bold=True, size=14, color='FFFFFF', name='Calibri') ws2['A1'].fill = make_fill("2E4057") ws2['A1'].alignment = Alignment(horizontal='center', vertical='center') ws2.row_dimensions[1].height = 36 # Score info info = [ ["Gut Health Score (Rych Index)", "-0.50 (Non-Ideal Range)", "", ""], ["Diversity", "Above Average", "", ""], ["Kingdom Distribution", "Non-Ideal", "", ""], ["Probiotic Characterization", "Below Average", "", ""], ["Pathogen Characterization", "Non-Ideal", "", ""], ["SCFA Production", "Below Average", "", ""], ["Vitamin Production", "Average", "", ""], ["Neurotransmitters", "Non-Ideal", "", ""], ["Antibiotic Recovery Potential", "Ideal", "", ""], ["", "", "", ""], ["PHASE GUIDE", "Duration", "Weeks", "Goal"], ["Phase 1 - Restore", "2 weeks", "1-2", "Reduce pathogens, strict anti-inflammatory diet"], ["Phase 2 - Rebuild", "8 weeks", "3-10", "Reintroduce probiotics, prebiotics, fermented foods"], ["Phase 3 - Maintain", "2 weeks", "11-12", "Sustain healthy microbiome long-term"], ["", "", "", ""], ["KEY PATHOGENS DETECTED (elevated)", "", "", ""], ["Candida albicans, C. glabrata, C. tropicalis", "", "", ""], ["Yersinia enterocolitica", "", "", ""], ["Aspergillus fumigatus, A. niger, A. terreus, A. nidulans", "", "", ""], ["Cryptosporidium", "", "", ""], ["", "", "", ""], ["PROBIOTICS NEEDED (supplementation)", "", "", ""], ["Bifidobacterium infantis, Lactobacillus acidophilus", "", "", ""], ["Lacticaseibacillus casei, Bacillus coagulans", "", "", ""], ["Saccharomyces boulardii, Bacillus indicus", "", "", ""], ["", "", "", ""], ["DISEASE RISKS (moderate)", "", "", ""], ["IBS (Moderate Risk), Depression (Moderate Risk)", "", "", ""], ["Anxiety (Moderate Risk), Atherosclerosis (Moderate Risk)", "", "", ""], ["Sleep quality: Unfavorable", "", "", ""], ] for i, row_data in enumerate(info, 2): for j, val in enumerate(row_data, 1): cell = ws2.cell(row=i, column=j, value=val) if i == 12: # Phase guide header cell.font = Font(bold=True, color='FFFFFF', size=11, name='Calibri') cell.fill = make_fill("054A29") elif row_data[0] in ["KEY PATHOGENS DETECTED (elevated)", "PROBIOTICS NEEDED (supplementation)", "DISEASE RISKS (moderate)"]: cell.font = Font(bold=True, size=10, color='CC0000', name='Calibri') cell.fill = make_fill("FFF3F3") elif i == 12: cell.font = Font(bold=True, size=10, name='Calibri') else: cell.font = Font(size=10, name='Calibri') cell.border = thin_border() cell.alignment = Alignment(vertical='center', wrap_text=True) ws2.row_dimensions[i].height = 18 # ============================================================ # DO & DON'T QUICK GUIDE SHEET ws3 = wb.create_sheet("Do & Don't Quick Guide") ws3.column_dimensions['A'].width = 3 ws3.column_dimensions['B'].width = 38 ws3.column_dimensions['C'].width = 3 ws3.column_dimensions['D'].width = 38 # Title ws3.merge_cells('A1:D1') ws3['A1'] = "Quick Do's & Don'ts — P Jaswik Gut Microbiome Dietary Guide" ws3['A1'].font = Font(bold=True, size=14, color='FFFFFF', name='Calibri') ws3['A1'].fill = make_fill("2E4057") ws3['A1'].alignment = Alignment(horizontal='center', vertical='center') ws3.row_dimensions[1].height = 36 ws3.merge_cells('A2:B2') ws3['A2'] = "✅ DO — Recommended Foods" ws3['A2'].font = Font(bold=True, size=12, color='FFFFFF', name='Calibri') ws3['A2'].fill = make_fill("28A745") ws3['A2'].alignment = Alignment(horizontal='center', vertical='center') ws3.row_dimensions[2].height = 28 ws3.merge_cells('C2:D2') ws3['C2'] = "🚫 DON'T — Foods to Avoid / Restrict" ws3['C2'].font = Font(bold=True, size=12, color='FFFFFF', name='Calibri') ws3['C2'].fill = make_fill("DC3545") ws3['C2'].alignment = Alignment(horizontal='center', vertical='center') dos = [ ("VEGETABLES (Everyday+)", "Bottle Gourd, Broccoli, Cabbage, Carrot, Brinjal, Broad Beans, Capsicum, Cauliflower, Cluster Beans, Cowpea, Cucumber, Mushrooms, Onion, Pumpkin, Spinach, Sweet Corn, Sweet Potato, Tomatoes"), ("FRUITS (Everyday+)", "Apple, Banana, Grapes, Guava, Mango, Orange, Papaya, Pomegranate, Strawberry, Watermelon, Pineapple, Muskmelon, Mosambi"), ("CEREALS & GRAINS", "Finger Millet, Pearl Millet, Kodo Millet, Little Millet, Oats (if suitable), Wheat, Wheat Flour — prefer millets over white rice"), ("OILS (Recommended)", "Coconut Oil (P1), Olive Oil, Sunflower Oil, Sesame Oil, Rice Bran Oil — use in moderation"), ("SPICES & HERBS", "Garlic (daily), Ginger, Turmeric (daily), Cumin Seeds (daily), Coriander Seeds, Mustard Seeds, Asafoetida, Fenugreek Seeds"), ("FERMENTED FOODS (P2+)", "Yogurt, Kefir, Kimchi, Kombucha, Sauerkraut — rich in beneficial probiotics; start Phase 2 onwards"), ("NUTS & SEEDS", "Almond (daily), Walnut, Sunflower Seeds, Sesame Seeds, Pumpkin Seeds — in moderation"), ("LEAN PROTEIN (P2+)", "Egg, Chicken, Rohu, Catla, Salmon, Trout, Tuna — start Phase 2; avoid red meat"), ("LEGUMES", "Green Gram, Mung Bean, Chickpeas, Pigeon Pea, Horse Gram, Kidney Beans — excellent prebiotics"), ("PROBIOTIC SUPPLEMENTS", "Bifidobacterium infantis, Lactobacillus acidophilus, Saccharomyces boulardii, Bacillus coagulans — as per doctor"), ("PREBIOTIC FOODS", "Onion, Garlic, Cluster Beans (Arabinoxylan), Honey (Isomalto-oligosaccharides), Rice bran (Resistant starch)"), ("HYDRATION", "Water, Tender Coconut (P3+), Herbal teas — stay well hydrated throughout"), ] donts = [ ("PROCESSED FOODS — Avoid ALL Phases", "Pizza, Burger, Noodles, Pasta, Bread, Cakes, Cookies, Crackers, Pastry, Sandwich, Taco, Rolls, French Toast, Garlic Bread — ALL phases"), ("SWEETS & CONFECTIONERY", "Artificial Sweeteners, Ice Cream, Milk Chocolate, Dark Chocolate (P1-P2) — avoid or severely restrict"), ("BEVERAGES", "Carbonated drinks, Distilled alcohol, Beer, Milk Shakes, Sugarcane Juice — avoid ALL phases"), ("RED MEAT — Avoid Phase 1", "Beef, Goat, Pork, Sheep, Turkey — avoid completely in Phase 1; restrict or eliminate long-term"), ("DAIRY — Restrict Phase 1", "Butter Milk, Cheese, Paneer, Yogurt, Kefir — avoid Phase 1; reintroduce carefully from Phase 2"), ("REFINED GRAINS", "White Rice (limit), Refined wheat flour, Maida-based products — prefer whole grains and millets"), ("HIGH-SUGAR FRUITS (P1)", "Mango, Banana, Custard Apple — avoid in Phase 1; introduce gradually in Phase 2"), ("FUNGI-PROMOTING FOODS", "High sugar, refined carbs, excess yeast products — Candida detected; strictly limit sugar"), ("FOODS WORSENING CANDIDA", "Vinegar (except ACV), Mushrooms (limit), Beer, Wine, Fermented alcohols — Candida overgrowth found"), ("INFLAMMATORY OILS", "Palm Oil (limit), Vegetable shortening, Trans fats — use sparingly or avoid"), ("JAGGERY / HONEY (P1)", "Jaggery and Honey — restrict in Phase 1 only; can reintroduce in Phase 2 in small amounts"), ("IMPORTANT NOTE", "Yersinia enterocolitica and multiple Candida/Aspergillus species detected — follow strict Phase 1 protocol and consult your doctor/nutritionist"), ] for i, ((do_cat, do_txt), (dont_cat, dont_txt)) in enumerate(zip(dos, donts), 3): # DO column ws3.cell(row=i, column=1).fill = make_fill("D4EDDA") cell_b = ws3.cell(row=i, column=2) cell_b.value = f"[{do_cat}]\n{do_txt}" cell_b.font = Font(size=9, name='Calibri', color='1A5E34') cell_b.fill = make_fill("D4EDDA") cell_b.alignment = Alignment(horizontal='left', vertical='top', wrap_text=True) cell_b.border = thin_border() # DON'T column ws3.cell(row=i, column=3).fill = make_fill("F8D7DA") cell_d = ws3.cell(row=i, column=4) cell_d.value = f"[{dont_cat}]\n{dont_txt}" cell_d.font = Font(size=9, name='Calibri', color='721C24') cell_d.fill = make_fill("F8D7DA") cell_d.alignment = Alignment(horizontal='left', vertical='top', wrap_text=True) cell_d.border = thin_border() ws3.row_dimensions[i].height = 60 # Footer note last_row = 3 + len(dos) ws3.merge_cells(f'A{last_row}:D{last_row}') ws3[f'A{last_row}'] = ("⚠ DISCLAIMER: This is not a diagnostic report. These dietary recommendations are based on your gut microbiome profile. " "Always consult a certified physician, clinician, or nutritionist before implementing dietary changes. " "Generated from BugSpeaks® Report ID: BS042976 — P Jaswik — June 2026") ws3[f'A{last_row}'].font = Font(italic=True, size=8, color='555555', name='Calibri') ws3[f'A{last_row}'].fill = make_fill("F7F7F7") ws3[f'A{last_row}'].alignment = Alignment(horizontal='center', vertical='center', wrap_text=True) ws3.row_dimensions[last_row].height = 40 # Save out_path = '/home/daytona/workspace/gut-microbiome-report/P_Jaswik_Food_Guide.xlsx' wb.save(out_path) print(f"Saved: {out_path}") print(f"Total food items: {len(food_data)}") PYEOF python3 /home/daytona/workspace/gut-microbiome-report/build_table.py

python3 /home/daytona/workspace/gut-microbiome-report/build_table.py 2>&1 | head -5 # Try saving to a temp file first python3 -c " from openpyxl import Workbook wb = Workbook() ws = wb.active ws['A1'] = 'test' wb.save('/tmp/test.xlsx') import shutil shutil.copy('/tmp/test.xlsx', '/home/daytona/workspace/gut-microbiome-report/test.xlsx') print('Test save OK') "

ls -la /home/daytona/workspace/gut-microbiome-report/ # Try saving directly to /tmp python3 -c " from openpyxl import Workbook wb = Workbook() ws = wb.active ws['A1'] = 'test' wb.save('/tmp/test.xlsx') print('OK /tmp') " ls -la /tmp/test.xlsx

# The workspace dir exists but has permission issues for saving. Save to /tmp then move. # Modify the script to save to /tmp first sed 's|/home/daytona/workspace/gut-microbiome-report/P_Jaswik_Food_Guide.xlsx|/tmp/P_Jaswik_Food_Guide.xlsx|' /home/daytona/workspace/gut-microbiome-report/build_table.py > /tmp/build_fixed.py python3 /tmp/build_fixed.py # Now move to workspace cp /tmp/P_Jaswik_Food_Guide.xlsx /home/daytona/workspace/gut-microbiome-report/P_Jaswik_Food_Guide.xlsx ls -lh /home/daytona/workspace/gut-microbiome-report/P_Jaswik_Food_Guide.xlsx

python3 -c "from reportlab.pdfgen import canvas; print('reportlab OK')" python3 -c "from reportlab.lib.pagesizes import A4; from reportlab.platypus import SimpleDocTemplate; print('platypus OK')"

cat > /tmp/shopping_list.py << 'PYEOF' from reportlab.lib.pagesizes import A4 from reportlab.lib import colors from reportlab.lib.units import mm, cm from reportlab.lib.styles import getSampleStyleSheet, ParagraphStyle from reportlab.platypus import (SimpleDocTemplate, Paragraph, Spacer, Table, TableStyle, HRFlowable, KeepTogether) from reportlab.lib.enums import TA_LEFT, TA_CENTER, TA_RIGHT from reportlab.pdfbase import pdfmetrics from reportlab.pdfbase.ttfonts import TTFont import os # ───────────────────────────────────────────────────────── # DATA: foods grouped by SHOPPING CATEGORY (not report category) # Only foods rated E (Everyday) or A (Every Other Day) = "BUY" # 3 = "optional / buy occasionally" # X = NOT on shopping list # # Shopping categories: Vegetables, Fruits, Legumes & Pulses, # Grains & Millets, Nuts & Seeds, Oils & Fats, # Spices & Herbs, Fermented & Dairy, Protein (Eggs/Fish), # Probiotic Supplements # ───────────────────────────────────────────────────────── # Each entry: (item, best_phase, frequency_note, checkbox_tip) # frequency_note: "Daily" / "Every Other Day" / "Occasional (P2+)" # phase_start: 1/2/3 SHOPPING = { "🥦 VEGETABLES": { "color": (0.13, 0.55, 0.13), "bg": (0.90, 0.97, 0.90), "tip": "Buy fresh or frozen. Prioritise in Phase 1.", "items": [ # (name, freq, phase_note) ("Ash Gourd", "Daily", "All phases"), ("Beet Root", "Daily", "All phases"), ("Bottle Gourd", "Daily", "All phases ★"), ("Broccoli", "Every other day", "All phases"), ("Cabbage", "Daily", "All phases ★"), ("Capsicum / Bell Pepper","Every other day","All phases"), ("Carrot", "Daily", "All phases ★"), ("Cauliflower", "Every other day", "All phases"), ("Chickpeas (fresh/dried)", "Every other day","All phases"), ("Cho Cho / Chayote", "Every other day", "All phases"), ("Cluster Beans (Guar)","Every other day","All phases ★ prebiotic"), ("Cowpea / Lobia", "Every other day", "All phases"), ("Cucumber", "Every other day", "All phases"), ("Drumstick / Moringa","Every other day", "All phases"), ("Fenugreek Leaves (Methi)","Every other day","All phases"), ("French Beans", "Every other day", "All phases"), ("Green Chillies", "Every other day", "All phases"), ("Green Gram (Moong)", "Every other day", "All phases ★"), ("Green Peas", "Every other day (P2+)", "Phase 2 onwards"), ("Kidney Beans (Rajma)","Every other day","All phases"), ("Ladies Finger / Okra","Every other day","All phases"), ("Moth Bean", "Every other day", "All phases"), ("Mung Bean", "Daily", "All phases ★"), ("Onion", "Daily", "All phases ★ prebiotic"), ("Pigeon Pea / Toor Dal","Daily", "All phases"), ("Pumpkin", "Daily", "All phases ★"), ("Radish", "Daily", "All phases"), ("Ridge Gourd", "Every other day", "All phases"), ("Snake Gourd", "Every other day", "All phases"), ("Spinach", "Daily", "All phases ★"), ("Sweet Potato", "Daily", "All phases"), ("Tinda (Indian Round Gourd)","Every other day","All phases"), ("Tomatoes", "Daily", "All phases ★"), ("Yam", "Every other day", "All phases"), ("Bitter Gourd (Karela)","Every other day","All phases"), ("Brinjal / Eggplant", "Every other day", "All phases"), ("Field Bean", "Every other day", "All phases"), ("Broad Beans", "Daily", "All phases ★"), ] }, "🍎 FRUITS": { "color": (0.80, 0.10, 0.10), "bg": (0.99, 0.92, 0.92), "tip": "Prefer low-sugar fruits in Phase 1. Avoid Mango/Banana Phase 1.", "items": [ ("Apple", "Daily", "All phases ★"), ("Banana", "Daily", "Phase 2+ (limit P1)"), ("Fig", "Daily", "All phases"), ("Gooseberry (Amla)", "Daily", "All phases ★ antioxidant"), ("Grapes", "Daily", "All phases"), ("Guava", "Daily", "All phases ★"), ("Kokum", "Daily", "All phases"), ("Mango", "Every other day", "Phase 2+ (avoid P1)"), ("Mosambi / Sweet Lime","Every other day","All phases"), ("Muskmelon", "Every other day", "All phases"), ("Orange", "Daily", "All phases ★"), ("Papaya", "Every other day", "All phases"), ("Pomegranate", "Every other day", "All phases ★"), ("Pear", "Every other day", "All phases"), ("Pineapple", "Every other day", "All phases"), ("Sapota / Chiku", "Every other day", "All phases"), ("Strawberry", "Every other day", "All phases"), ("Watermelon", "Every other day", "All phases"), ("Wood Apple (Bael)", "Daily", "All phases"), ("Custard Apple", "Every other day", "Phase 2+"), ("Jack Fruit", "Every other day", "Phase 2+"), ("Kala Jamun", "Every other day", "All phases"), ("Lychee", "Every other day", "All phases"), ("Raisins", "Every other day", "Phase 2+"), ] }, "🌾 GRAINS, MILLETS & CEREALS": { "color": (0.60, 0.40, 0.05), "bg": (0.99, 0.95, 0.87), "tip": "Favour millets over white rice. Whole wheat preferred over maida.", "items": [ ("Finger Millet (Ragi)","Daily", "All phases ★"), ("Pearl Millet (Bajra)","Daily", "All phases ★"), ("Kodo Millet", "Every other day", "All phases"), ("Little Millet (Kutki)","Every other day","All phases"), ("Wheat / Whole Wheat Flour","Every other day","All phases"), ("Maize / Corn", "Daily", "All phases"), ("Oats", "Every other day", "All phases (inferred)"), ("Rice Flakes (Poha)", "Every other day", "Phase 2+"), ("White Rice", "Occasional", "Limit — prefer millets"), ] }, "🫘 LEGUMES & PULSES": { "color": (0.45, 0.25, 0.05), "bg": (0.96, 0.91, 0.83), "tip": "Excellent prebiotics — feed beneficial gut bacteria.", "items": [ ("Green Gram / Moong Dal","Daily", "All phases ★ prebiotic"), ("Mung Beans (whole)", "Daily", "All phases ★"), ("Pigeon Pea / Toor Dal","Daily", "All phases ★"), ("Cluster Beans / Guar","Every other day","All phases ★ prebiotic"), ("Chickpeas / Chana", "Every other day", "All phases"), ("Kidney Beans / Rajma","Every other day","All phases"), ("Cowpea / Lobia", "Every other day", "All phases"), ("Moth Bean", "Every other day", "All phases"), ("Horse Gram", "Occasional", "All phases"), ("Bengal Gram (Chana Dal)","Every other day","All phases"), ("Field Bean (Val)", "Every other day", "All phases"), ("Broad Beans (Fava)", "Daily", "All phases ★"), ] }, "🌿 SPICES, HERBS & CONDIMENTS": { "color": (0.10, 0.45, 0.25), "bg": (0.88, 0.97, 0.91), "tip": "Use daily — anti-inflammatory and anti-fungal properties.", "items": [ ("Garlic", "Daily", "All phases ★ antifungal"), ("Ginger", "Every other day", "All phases ★ antifungal"), ("Turmeric Powder", "Daily", "All phases ★ anti-inflammatory"), ("Cumin Seeds", "Daily", "All phases ★"), ("Coriander Seeds", "Daily", "All phases"), ("Mustard Seeds", "Daily", "All phases ★"), ("Fenugreek Seeds (Methi)","Daily", "All phases ★ prebiotic"), ("Coriander Leaves (Cilantro)","Daily", "All phases"), ("Mint Leaves", "Occasional", "All phases"), ("Curry Leaves", "Daily", "Phase 2+ ★"), ("Asafoetida (Hing)", "Daily", "All phases"), ("Cardamom (Elaichi)", "Every other day", "All phases"), ("Cloves (Laung)", "Daily", "All phases ★ antifungal"), ("Pepper (Black)", "Every other day", "All phases"), ("Red Chilli Powder", "Occasional", "All phases — use sparingly"), ] }, "🥜 NUTS & SEEDS": { "color": (0.55, 0.33, 0.05), "bg": (0.98, 0.94, 0.85), "tip": "Small daily portions. Rich in healthy fats and prebiotics.", "items": [ ("Almond", "Daily", "All phases ★"), ("Walnut", "Every other day", "Phase 2+"), ("Sunflower Seeds", "Daily", "All phases"), ("Sesame Seeds (Til)", "Every other day", "All phases"), ("Ground Nut / Peanut","Daily", "All phases"), ("Pistachio Nuts", "Every other day", "All phases"), ("Coconut (fresh/desiccated)","Daily", "All phases ★"), ("Poppy Seeds (Khus Khus)","Every other day","All phases"), ("Cashew Nut", "Every other day", "All phases — limit quantity"), ] }, "🫙 OILS & FATS": { "color": (0.60, 0.50, 0.05), "bg": (0.99, 0.97, 0.85), "tip": "Use cold-pressed oils where possible.", "items": [ ("Coconut Oil", "Daily", "All phases ★ antifungal"), ("Olive Oil", "Daily", "All phases ★"), ("Sunflower Oil", "Daily", "All phases"), ("Ghee", "Daily", "All phases — small amounts"), ("Sesame Oil", "Every other day", "Phase 2+"), ("Rice Bran Oil", "Every other day", "All phases"), ("Mustard Oil", "Occasional", "Phase 2+ — in moderation"), ] }, "🧄 SWEETENERS & EXTRAS": { "color": (0.40, 0.20, 0.50), "bg": (0.95, 0.90, 0.98), "tip": "Use honey sparingly. Avoid jaggery/honey in Phase 1 if Candida is a concern.", "items": [ ("Honey (raw)", "Occasional", "Phase 2+ ★ prebiotic (IMO)"), ("Jaggery", "Occasional", "Phase 2+ — use sparingly"), ("Dates", "Every other day", "All phases — limit quantity"), ("Tender Coconut Water","Daily", "Phase 3+ ★"), ] }, "🥛 FERMENTED & DAIRY (Phase 2+)": { "color": (0.10, 0.35, 0.65), "bg": (0.88, 0.93, 0.99), "tip": "START Phase 2 only. These reintroduce beneficial bacteria.", "items": [ ("Plain Yogurt (unsweetened)","Daily", "Phase 2+ ★★★"), ("Kefir", "Every other day", "Phase 2+ ★★★ probiotic"), ("Kimchi", "Every other day", "Phase 2+ ★★★ probiotic"), ("Kombucha", "Every other day", "Phase 2+ ★★ probiotic"), ("Sauerkraut", "Every other day", "Phase 2+ ★★ probiotic"), ("Butter Milk (Chaas)","Daily", "Phase 2+ ★★ probiotic"), ("Shrikhand", "Every other day", "Phase 2+"), ("Paneer (homemade)", "Every other day", "Phase 2+"), ("Cheese (mild, unprocessed)","Every other day","Phase 2+"), ("Soy Products (tofu/tempeh)","Every other day","Phase 2+"), ] }, "🐟 PROTEIN — EGGS & FISH (Phase 2+)": { "color": (0.10, 0.45, 0.60), "bg": (0.87, 0.95, 0.99), "tip": "AVOID Phase 1. Introduce from Phase 2. Avoid red meat (beef, pork, sheep).", "items": [ ("Eggs", "Every other day", "Phase 2+ ★"), ("Chicken (skinless)", "Every other day", "Phase 2+"), ("Salmon", "Every other day", "Phase 2+ ★ omega-3"), ("Rohu", "Every other day", "Phase 2+"), ("Catla", "Every other day", "Phase 2+"), ("Tuna", "Every other day", "Phase 2+"), ("Trout", "Every other day", "Phase 2+"), ("Haddock", "Every other day", "Phase 2+"), ("Sardine", "Every other day", "Phase 2+"), ("Prawns", "Every other day", "Phase 2+"), ] }, "💊 PROBIOTIC SUPPLEMENTS (Ask Your Doctor)": { "color": (0.50, 0.10, 0.50), "bg": (0.97, 0.91, 0.97), "tip": "Supplementation NEEDED for these strains (absent/very low in your sample).", "items": [ ("Bifidobacterium infantis","Supplementation","Not present — needed"), ("Lactobacillus acidophilus","Supplementation","Not present — needed"), ("Lacticaseibacillus casei","Supplementation","Not present — needed"), ("Bacillus coagulans", "Supplementation", "Not present — needed"), ("Saccharomyces boulardii","Supplementation","Not present — needed ★ anti-Candida"), ("Lacticaseibacillus paracasei","Supplementation","Not present — needed"), ("Bacillus indicus", "Supplementation", "Not present — needed"), ("Lactobacillus gallinarum","Supplementation","Not present — needed"), ("Lactobacillus amylovorus","Supplementation","Not present — needed"), ] }, } AVOID_LIST = { "🚫 AVOID — Do Not Buy": { "color": (0.75, 0.10, 0.10), "bg": (0.99, 0.90, 0.90), "items": [ ("Pizza, Burger, Noodles, Pasta", "All processed fast food"), ("Bakery Breads, Cakes, Cookies, Crackers","Refined flour products"), ("Carbonated / Fizzy Drinks", "All sodas and energy drinks"), ("Distilled Alcohol (Whisky, Vodka, Rum)", "All phases"), ("Sugarcane Juice, Milk Shakes", "High sugar beverages"), ("Artificial Sweeteners", "All types — all phases"), ("Beef, Pork, Goat, Sheep, Turkey", "Red/processed meat — all phases"), ("Ice Cream, Milk Chocolate, Pastry", "All confectionery"), ("Processed cheese, spreads", "Ultra-processed dairy"), ("Yeast extracts, fermented alcohol", "Candida overgrowth detected"), ] } } # ───────────────────────────────────────────────────────── # BUILD PDF # ───────────────────────────────────────────────────────── PAGE_W, PAGE_H = A4 # 595 x 842 pts MARGIN = 15 * mm COL_GAP = 6 * mm doc = SimpleDocTemplate( '/tmp/P_Jaswik_Shopping_List.pdf', pagesize=A4, leftMargin=MARGIN, rightMargin=MARGIN, topMargin=15*mm, bottomMargin=15*mm, ) story = [] styles = getSampleStyleSheet() # ── Custom styles ────────────────────────────────────────── title_style = ParagraphStyle('title', fontName='Helvetica-Bold', fontSize=16, textColor=colors.HexColor('#1a2e4a'), alignment=TA_CENTER, spaceAfter=2) subtitle_style = ParagraphStyle('subtitle', fontName='Helvetica', fontSize=9, textColor=colors.HexColor('#555555'), alignment=TA_CENTER, spaceAfter=6) phase_style = ParagraphStyle('phase', fontName='Helvetica-BoldOblique', fontSize=8, textColor=colors.HexColor('#333333'), alignment=TA_CENTER, spaceAfter=8) legend_style = ParagraphStyle('legend', fontName='Helvetica', fontSize=8, textColor=colors.HexColor('#333333'), alignment=TA_CENTER, spaceAfter=2) cat_header_style = ParagraphStyle('cathead', fontName='Helvetica-Bold', fontSize=10, textColor=colors.white, alignment=TA_LEFT, leftIndent=4, spaceAfter=0, spaceBefore=0) tip_style = ParagraphStyle('tip', fontName='Helvetica-Oblique', fontSize=7, textColor=colors.HexColor('#444444'), alignment=TA_LEFT, leftIndent=4, spaceAfter=2) item_style = ParagraphStyle('item', fontName='Helvetica', fontSize=8.5, textColor=colors.HexColor('#111111'), alignment=TA_LEFT, leftIndent=2) freq_style = ParagraphStyle('freq', fontName='Helvetica', fontSize=7.5, textColor=colors.HexColor('#444444'), alignment=TA_LEFT) avoid_style = ParagraphStyle('avoid', fontName='Helvetica', fontSize=8.5, textColor=colors.HexColor('#8B0000'), alignment=TA_LEFT, leftIndent=2) # ── HEADER ───────────────────────────────────────────────── story.append(Paragraph("Personalised Gut Health Shopping List", title_style)) story.append(Paragraph( "Patient: P Jaswik | ID: BS042976 | BugSpeaks® Microbiome Report | June 2026", subtitle_style)) # Legend box legend_data = [[ Paragraph("<font color='#28A745'>●</font> <b>Daily</b> — buy in bulk", legend_style), Paragraph("<font color='#0066CC'>●</font> <b>Every Other Day</b> — regular stock", legend_style), Paragraph("<font color='#CC8800'>●</font> <b>Occasional</b> — small amounts", legend_style), Paragraph("<font color='#CC0000'>✕</font> <b>Avoid</b> — do not buy", legend_style), ]] legend_tbl = Table(legend_data, colWidths=[(PAGE_W - 2*MARGIN)/4]*4) legend_tbl.setStyle(TableStyle([ ('BACKGROUND', (0,0), (-1,-1), colors.HexColor('#EBF3FB')), ('ROUNDEDCORNERS', [4]), ('BOX', (0,0), (-1,-1), 0.5, colors.HexColor('#AACCEE')), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('TOPPADDING', (0,0), (-1,-1), 4), ('BOTTOMPADDING', (0,0), (-1,-1), 4), ])) story.append(legend_tbl) story.append(Spacer(1, 6)) # Phase reference strip phase_data = [[ Paragraph("<b>PHASE 1 (Weeks 1-2):</b> Restore — strict anti-inflammatory, anti-fungal diet", phase_style), Paragraph("<b>PHASE 2 (Weeks 3-10):</b> Rebuild — add probiotics, fermented foods, fish & eggs", phase_style), Paragraph("<b>PHASE 3 (Weeks 11-12):</b> Maintain — sustain healthy microbiome long-term", phase_style), ]] phase_tbl = Table(phase_data, colWidths=[(PAGE_W - 2*MARGIN)/3]*3) phase_tbl.setStyle(TableStyle([ ('BACKGROUND', (0,0), (0,0), colors.HexColor('#D4EDDA')), ('BACKGROUND', (1,0), (1,0), colors.HexColor('#CCE5FF')), ('BACKGROUND', (2,0), (2,0), colors.HexColor('#FFF3CD')), ('BOX', (0,0), (-1,-1), 0.5, colors.HexColor('#BBBBBB')), ('INNERGRID', (0,0), (-1,-1), 0.5, colors.HexColor('#DDDDDD')), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('TOPPADDING', (0,0), (-1,-1), 5), ('BOTTOMPADDING', (0,0), (-1,-1), 5), ])) story.append(phase_tbl) story.append(Spacer(1, 8)) # ── HELPER: build one category section ────────────────────── FREQ_COLORS = { "Daily": "#28A745", "Every other day": "#0066CC", "Every other day (P2+)": "#0066CC", "Occasional": "#CC8800", "Supplementation": "#660099", } def freq_dot(freq): col = FREQ_COLORS.get(freq, "#888888") if freq == "Supplementation": return f'<font color="{col}">💊</font>' elif "Daily" in freq: return f'<font color="{col}">●</font>' elif "Occasional" in freq: return f'<font color="{col}">◌</font>' else: return f'<font color="{col}">◑</font>' COL_W = (PAGE_W - 2*MARGIN - COL_GAP) / 2 # two columns ITEM_COL = COL_W * 0.52 FREQ_COL = COL_W * 0.26 NOTE_COL = COL_W * 0.22 CHECK_COL = 14 def make_section(cat_name, cat_data): r, g, b = cat_data["color"] rbg, gbg, bbg = cat_data["bg"] cat_color = colors.Color(r, g, b) bg_color = colors.Color(rbg, gbg, bbg) items = cat_data["items"] tip = cat_data.get("tip", "") # Category header row header_para = Paragraph(cat_name, cat_header_style) header_row = [[header_para, "", "", ""]] # Column sub-headers sub_row = [[ Paragraph("<b>Item</b>", ParagraphStyle('sh', fontName='Helvetica-Bold', fontSize=7.5, textColor=colors.HexColor('#555555'))), Paragraph("<b>Frequency</b>", ParagraphStyle('sh', fontName='Helvetica-Bold', fontSize=7.5, textColor=colors.HexColor('#555555'), alignment=TA_CENTER)), Paragraph("<b>Phase Note</b>", ParagraphStyle('sh', fontName='Helvetica-Bold', fontSize=7.5, textColor=colors.HexColor('#555555'))), Paragraph("<b>✓</b>", ParagraphStyle('sh', fontName='Helvetica-Bold', fontSize=9, textColor=colors.HexColor('#555555'), alignment=TA_CENTER)), ]] # Item rows item_rows = [] for i, (name, freq, note) in enumerate(items): dot = freq_dot(freq) row_bg = colors.white if i % 2 == 0 else bg_color item_rows.append([ Paragraph(f"{dot} {name}", item_style), Paragraph(f"<i>{freq}</i>", ParagraphStyle('f', fontName='Helvetica-Oblique', fontSize=7.5, textColor=colors.HexColor(FREQ_COLORS.get(freq,"#888888")), alignment=TA_CENTER)), Paragraph(f"<i>{note}</i>", ParagraphStyle('n', fontName='Helvetica-Oblique', fontSize=7, textColor=colors.HexColor('#666666'))), "", # checkbox ]) all_data = header_row + sub_row + item_rows col_widths = [ITEM_COL, FREQ_COL, NOTE_COL, CHECK_COL] tbl_style = [ # Header row ('SPAN', (0,0), (3,0)), ('BACKGROUND', (0,0), (3,0), cat_color), ('TOPPADDING', (0,0), (3,0), 5), ('BOTTOMPADDING',(0,0), (3,0), 5), ('LEFTPADDING', (0,0), (3,0), 6), # Sub-header row ('BACKGROUND', (0,1), (3,1), colors.HexColor('#EEEEEE')), ('TOPPADDING', (0,1), (3,1), 2), ('BOTTOMPADDING',(0,1), (3,1), 2), ('LINEBELOW', (0,1), (3,1), 0.5, colors.HexColor('#CCCCCC')), # All rows ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('LEFTPADDING', (0,2), (3,-1), 5), ('RIGHTPADDING', (0,0), (-1,-1), 3), ('TOPPADDING', (0,2), (-1,-1), 3), ('BOTTOMPADDING',(0,2), (-1,-1), 3), # Alternating row backgrounds *[('BACKGROUND', (0, i+2), (3, i+2), colors.white if i % 2 == 0 else bg_color) for i in range(len(items))], # Checkbox column ('BACKGROUND', (3,2), (3,-1), colors.HexColor('#F5F5F5')), ('ALIGN', (3,2), (3,-1), 'CENTER'), # Border ('BOX', (0,0), (-1,-1), 1, cat_color), ('INNERGRID', (0,2), (-1,-1), 0.3, colors.HexColor('#DDDDDD')), ('LINEABOVE', (0,2), (-1,2), 0.5, colors.HexColor('#CCCCCC')), # Checkbox border ('BOX', (3,2), (3,-1), 0.8, colors.HexColor('#BBBBBB')), ] tbl = Table(all_data, colWidths=col_widths, repeatRows=2) tbl.setStyle(TableStyle(tbl_style)) block = [] if tip: block.append(Paragraph(f"💡 {tip}", tip_style)) block.append(tbl) block.append(Spacer(1, 6)) return KeepTogether(block) # ── AVOID SECTION ──────────────────────────────────────────── def make_avoid_section(): cat_color = colors.HexColor('#CC2222') bg_color = colors.HexColor('#FFF0F0') header_row = [[Paragraph("🚫 FOODS TO AVOID — Do NOT Buy These", ParagraphStyle( 'ah', fontName='Helvetica-Bold', fontSize=10, textColor=colors.white, leftIndent=4)), "", ""]] item_rows = [] for i, (item, reason) in enumerate(AVOID_LIST["🚫 AVOID — Do Not Buy"]["items"]): row_bg = colors.white if i % 2 == 0 else bg_color item_rows.append([ Paragraph(f"✕ {item}", avoid_style), Paragraph(f"<i>{reason}</i>", ParagraphStyle('ar', fontName='Helvetica-Oblique', fontSize=7.5, textColor=colors.HexColor('#992222'))), "", ]) all_data = header_row + item_rows col_widths = [ITEM_COL * 1.1, NOTE_COL * 2.1 + FREQ_COL, CHECK_COL] tbl_style = [ ('SPAN', (0,0), (2,0)), ('BACKGROUND', (0,0), (2,0), cat_color), ('TOPPADDING', (0,0), (2,0), 5), ('BOTTOMPADDING',(0,0), (2,0), 5), ('LEFTPADDING', (0,0), (2,0), 6), ('VALIGN', (0,0), (-1,-1), 'MIDDLE'), ('LEFTPADDING', (0,1), (-1,-1), 5), ('TOPPADDING', (0,1), (-1,-1), 3), ('BOTTOMPADDING',(0,1), (-1,-1), 3), *[('BACKGROUND', (0, i+1), (2, i+1), colors.white if i % 2 == 0 else bg_color) for i in range(len(item_rows))], ('BACKGROUND', (2,1), (2,-1), colors.HexColor('#F5F5F5')), ('ALIGN', (2,1), (2,-1), 'CENTER'), ('BOX', (0,0), (-1,-1), 1.5, cat_color), ('INNERGRID', (0,1), (-1,-1), 0.3, colors.HexColor('#FFCCCC')), ('BOX', (2,1), (2,-1), 0.8, colors.HexColor('#DDAAAA')), ] tbl = Table(all_data, colWidths=col_widths) tbl.setStyle(TableStyle(tbl_style)) return KeepTogether([tbl, Spacer(1, 6)]) # ── ASSEMBLE STORY ────────────────────────────────────────── # Left and right column layout by pairing categories cat_names = list(SHOPPING.keys()) for cat_name in cat_names: story.append(make_section(cat_name, SHOPPING[cat_name])) story.append(make_avoid_section()) # ── FOOTER DISCLAIMER ─────────────────────────────────────── story.append(HRFlowable(width="100%", thickness=0.5, color=colors.HexColor('#AAAAAA'))) story.append(Spacer(1, 3)) story.append(Paragraph( "⚠ This shopping list is based on your BugSpeaks® Gut Microbiome Report (ID: BS042976). " "It is NOT a diagnostic document. Consult your physician or nutritionist before making " "significant dietary changes, especially if diabetic, hypertensive, or on medication. " "★ = highest priority | Phase 2+ = avoid in Phase 1, introduce from Phase 2 onward.", ParagraphStyle('disc', fontName='Helvetica', fontSize=7, textColor=colors.HexColor('#666666'), alignment=TA_CENTER, spaceBefore=3) )) # ── BUILD ──────────────────────────────────────────────────── doc.build(story) print("PDF built successfully: /tmp/P_Jaswik_Shopping_List.pdf") import os size = os.path.getsize('/tmp/P_Jaswik_Shopping_List.pdf') print(f"File size: {size/1024:.1f} KB") PYEOF python3 /tmp/shopping_list.py

cp /tmp/P_Jaswik_Shopping_List.pdf /home/daytona/workspace/gut-microbiome-report/P_Jaswik_Shopping_List.pdf ls -lh /home/daytona/workspace/gut-microbiome-report/P_Jaswik_Shopping_List.pdf