const pptxgen = require("pptxgenjs");

const pres = new pptxgen();
pres.layout = "LAYOUT_WIDE"; // 13.3" x 7.5"
pres.title = "Oil & Skin Traits Quick Reference";
pres.author = "Orris Research";

// ─── PALETTE ────────────────────────────────────────────────────────────────
const C = {
  bg:          "0F1C2E",   // deep navy
  panelDark:   "142035",   // slightly lighter navy for row bg
  header:      "1A3050",   // column header bg
  accent1:     "2EC4B6",   // teal  → "Best choice"
  accent2:     "F4A261",   // amber → "Moderate / use with care"
  accent3:     "E76F51",   // coral → "Insufficient / avoid"
  white:       "FFFFFF",
  silver:      "B0C4D8",
  gold:        "FFD700",
  coconutCol:  "2A5C45",   // forest green header
  sesameCol:   "7B3F00",   // rich brown header
  groundnutCol:"8B5E0A",   // dark amber header
  rowAlt1:     "162840",
  rowAlt2:     "1E3555",
  notesBg:     "0A1525",
};

// ─── LEGEND SYMBOLS ─────────────────────────────────────────────────────────
// ✅ = Best / Strong evidence    ⚠ = Moderate / caution    ✗ = Insufficient / avoid
const BEST  = "✅ Best Choice";
const MOD   = "⚠  Moderate";
const INSUF = "✗  Insufficient";
const CAUT  = "⚠  Caution – Risk";

// ─── DATA ────────────────────────────────────────────────────────────────────
// [Trait, emoji, coconut, sesame, groundnut, tip]
const rows = [
  ["Skin Hydration",          "💧", BEST,  BEST,  MOD,   "Coconut & Sesame both clinically proven to ↑ moisture & ↓ TEWL"],
  ["Atopic Dermatitis",       "🌿", BEST,  MOD,   CAUT,  "Coconut: superior to mineral oil in RCTs | Groundnut: sensitization risk in children"],
  ["Oxidative Stress",        "⚡", MOD,   BEST,  MOD,   "Sesame's sesamol/sesamin = strongest antioxidants of the three"],
  ["Acne Risk",               "🔴", MOD,   MOD,   MOD,   "All three have linoleic acid; coconut's lauric acid kills C. acnes in vitro"],
  ["Photoaging",              "🌤", MOD,   MOD,   MOD,   "Sesame has highest UV absorption; none replace clinical SPF 30+"],
  ["Skin Aging",              "🧓", MOD,   MOD,   MOD,   "Antioxidant & barrier repair properties support all three; no direct RCTs"],
  ["Wrinkle Formation",       "🧬", MOD,   MOD,   INSUF, "Hydration-driven benefit; sesame's sesamin inhibits cell senescence"],
  ["Androgenetic Alopecia",   "💈", INSUF, MOD,   INSUF, "Sesame sesamol inhibits 5α-reductase in vitro – promising but pre-clinical only"],
  ["Alopecia Areata",         "🌀", INSUF, INSUF, INSUF, "No clinical trials for any of these oils in alopecia areata"],
  ["Sunburn Risk",            "☀️", INSUF, MOD,   INSUF, "None adequate as standalone sunscreen – always use SPF 30+ over any oil"],
  ["Hyperpigmentation",       "🎨", INSUF, INSUF, INSUF, "Only in-silico (computational) data for coconut; no clinical evidence for any"],
  ["Skin Lightening",         "✨", INSUF, INSUF, INSUF, "No clinical trials – avoid marketing claims based on these oils alone"],
  ["Keloid Scars",            "🩹", INSUF, MOD,   INSUF, "Sesame lignans show wound-healing activity in lab; no keloid-specific trials"],
  ["Stretch Marks",           "🔵", INSUF, INSUF, INSUF, "No peer-reviewed evidence for any of the three oils"],
  ["Glycation Risk",          "🍬", INSUF, INSUF, INSUF, "No published skin glycation studies for any of the three oils"],
  ["Cellulite Formation",     "🍊", INSUF, INSUF, INSUF, "No evidence – avoid making claims about cellulite for any of these oils"],
  ["Skin Bruising",           "🟣", INSUF, INSUF, INSUF, "No evidence – no studies found for any oil"],
  ["Skin Detoxification",     "🧹", INSUF, MOD,   INSUF, "Sesame: traditional use + antioxidant action; no validated clinical endpoint"],
];

// ─── SLIDE 1 : COVER ─────────────────────────────────────────────────────────
{
  const s = pres.addSlide();
  s.background = { color: C.bg };

  // Top accent bar
  s.addShape(pres.ShapeType.rect, { x: 0, y: 0, w: 13.3, h: 0.08, fill: { color: C.accent1 }, line: { type: "none" } });

  // Decorative oil-drop circles
  const drops = [
    { x: 0.6, y: 1.2, r: 1.1, color: C.coconutCol },
    { x: 2.1, y: 1.2, r: 1.1, color: C.sesameCol },
    { x: 3.6, y: 1.2, r: 1.1, color: C.groundnutCol },
  ];
  drops.forEach(d => {
    s.addShape(pres.ShapeType.ellipse, {
      x: d.x, y: d.y, w: d.r * 2, h: d.r * 2,
      fill: { color: d.color }, line: { type: "none" }
    });
  });

  // Oil label text in circles
  [["🥥 Coconut", 0.6], ["🌿 Sesame", 2.1], ["🥜 Groundnut", 3.6]].forEach(([label, x]) => {
    s.addText(label, {
      x: x, y: 1.2, w: 2.2, h: 2.2,
      fontSize: 11, bold: true, color: C.white, align: "center", valign: "middle"
    });
  });

  // Main title
  s.addText("Oil & Skin Traits", {
    x: 3.2, y: 1.0, w: 9.5, h: 1.1,
    fontSize: 44, bold: true, color: C.white, align: "left", valign: "middle",
    charSpacing: 2
  });
  s.addText("Quick Reference Guide", {
    x: 3.2, y: 2.0, w: 9.5, h: 0.7,
    fontSize: 26, bold: false, color: C.accent1, align: "left", valign: "middle"
  });

  // Subtitle
  s.addText("Coconut  ·  Sesame  ·  Groundnut (Peanut)", {
    x: 3.2, y: 2.75, w: 9.5, h: 0.45,
    fontSize: 16, color: C.silver, align: "left"
  });

  // Divider
  s.addShape(pres.ShapeType.rect, { x: 3.2, y: 3.3, w: 9.5, h: 0.03, fill: { color: C.accent1 }, line: { type: "none" } });

  // Subtitle 2
  s.addText("Evidence-based guidance for 18 skin traits | Based on PubMed peer-reviewed literature", {
    x: 3.2, y: 3.4, w: 9.5, h: 0.4,
    fontSize: 12, color: C.silver, align: "left", italic: true
  });

  // Legend box
  s.addShape(pres.ShapeType.roundRect, {
    x: 3.2, y: 4.0, w: 9.5, h: 1.1,
    fill: { color: C.header }, line: { color: C.accent1, pt: 1 },
    rectRadius: 0.1
  });
  s.addText("LEGEND", {
    x: 3.3, y: 4.05, w: 2, h: 0.3,
    fontSize: 9, bold: true, color: C.accent1, charSpacing: 3
  });
  const legendItems = [
    { icon: "✅", label: "Best Choice", desc: "RCT / Systematic Review evidence", color: C.accent1, x: 3.3 },
    { icon: "⚠",  label: "Moderate",    desc: "Review / In vitro / Limited clinical data", color: C.accent2, x: 7.0 },
    { icon: "✗",  label: "Insufficient", desc: "No direct clinical evidence / Avoid claims", color: C.accent3, x: 10.3 },
  ];
  legendItems.forEach(item => {
    s.addShape(pres.ShapeType.roundRect, {
      x: item.x, y: 4.35, w: 2.9, h: 0.65,
      fill: { color: C.panelDark }, line: { color: item.color, pt: 1.5 },
      rectRadius: 0.06
    });
    s.addText(`${item.icon}  ${item.label}`, {
      x: item.x + 0.08, y: 4.37, w: 2.74, h: 0.3,
      fontSize: 12, bold: true, color: item.color
    });
    s.addText(item.desc, {
      x: item.x + 0.08, y: 4.66, w: 2.74, h: 0.3,
      fontSize: 8.5, color: C.silver, italic: true
    });
  });

  // Caution note
  s.addText("⚠  Groundnut oil: avoid topical use in children with atopic dermatitis or peanut allergy risk (peanut sensitization via skin — NEJM 2003)", {
    x: 3.2, y: 5.2, w: 9.5, h: 0.35,
    fontSize: 9, color: C.accent2, italic: true, align: "left"
  });
  s.addText("Note: None of these oils replace clinical-grade SPF sunscreen. All recommendations refer to topical use of cold-pressed / virgin oils.", {
    x: 3.2, y: 5.55, w: 9.5, h: 0.3,
    fontSize: 9, color: C.silver, italic: true
  });

  // Bottom accent bar
  s.addShape(pres.ShapeType.rect, { x: 0, y: 7.4, w: 13.3, h: 0.1, fill: { color: C.accent1 }, line: { type: "none" } });
}

// ─── HELPER: render status cell ──────────────────────────────────────────────
function statusColor(val) {
  if (val.startsWith("✅")) return C.accent1;
  if (val.startsWith("⚠  Caution")) return C.accent3;
  if (val.startsWith("⚠")) return C.accent2;
  return C.accent3;
}

// ─── SLIDES 2–3 : REFERENCE TABLE (split into 2 slides, 9 rows each) ─────────
function buildTableSlide(slideRows, slideNum, totalSlides) {
  const s = pres.addSlide();
  s.background = { color: C.bg };

  // Top bar
  s.addShape(pres.ShapeType.rect, { x: 0, y: 0, w: 13.3, h: 0.06, fill: { color: C.accent1 }, line: { type: "none" } });

  // Slide title
  s.addText("Oil & Skin Traits — Quick Reference", {
    x: 0.2, y: 0.08, w: 9, h: 0.45,
    fontSize: 16, bold: true, color: C.white
  });
  s.addText(`Part ${slideNum} of ${totalSlides}`, {
    x: 11.5, y: 0.1, w: 1.6, h: 0.35,
    fontSize: 10, color: C.silver, align: "right"
  });

  // Column header definitions
  const cols = [
    { label: "SKIN TRAIT", x: 0.1,  w: 2.55, color: C.header,       textColor: C.accent1 },
    { label: "🥥 COCONUT",  x: 2.7,  w: 2.5,  color: C.coconutCol,   textColor: C.white },
    { label: "🌿 SESAME",   x: 5.25, w: 2.5,  color: C.sesameCol,    textColor: C.white },
    { label: "🥜 GROUNDNUT",x: 7.8,  w: 2.5,  color: C.groundnutCol, textColor: C.white },
    { label: "CLINICAL TIP", x: 10.35,w: 2.88, color: C.header,      textColor: C.accent1 },
  ];

  const headerY = 0.6;
  const headerH = 0.42;
  cols.forEach(col => {
    s.addShape(pres.ShapeType.rect, {
      x: col.x, y: headerY, w: col.w, h: headerH,
      fill: { color: col.color }, line: { type: "none" }
    });
    s.addText(col.label, {
      x: col.x + 0.05, y: headerY, w: col.w - 0.1, h: headerH,
      fontSize: 9.5, bold: true, color: col.textColor,
      align: "center", valign: "middle", charSpacing: 1
    });
  });

  // Row height
  const rowH = 0.575;
  const startY = headerY + headerH + 0.05;

  slideRows.forEach((row, i) => {
    const [trait, emoji, coconut, sesame, groundnut, tip] = row;
    const y = startY + i * rowH;
    const rowBg = i % 2 === 0 ? C.rowAlt1 : C.rowAlt2;

    // Row background
    s.addShape(pres.ShapeType.rect, {
      x: 0.1, y: y, w: 13.1, h: rowH - 0.04,
      fill: { color: rowBg }, line: { type: "none" }
    });

    // Trait name
    s.addText(`${emoji}  ${trait}`, {
      x: 0.15, y: y, w: 2.5, h: rowH - 0.04,
      fontSize: 10.5, bold: true, color: C.white, valign: "middle"
    });

    // Status cells
    const statusData = [
      { val: coconut,   x: 2.7  },
      { val: sesame,    x: 5.25 },
      { val: groundnut, x: 7.8  },
    ];

    statusData.forEach(sd => {
      const bg = statusColor(sd.val);
      const isInsuf = sd.val.startsWith("✗");
      const isCaut  = sd.val.includes("Caution");
      // pill background
      s.addShape(pres.ShapeType.roundRect, {
        x: sd.x + 0.15, y: y + 0.09, w: 2.2, h: rowH - 0.25,
        fill: { color: bg, transparency: isInsuf ? 75 : isCaut ? 60 : 55 },
        line: { color: bg, pt: 1.2 },
        rectRadius: 0.12
      });
      s.addText(sd.val, {
        x: sd.x + 0.15, y: y + 0.09, w: 2.2, h: rowH - 0.25,
        fontSize: 9, bold: !isInsuf, color: isInsuf ? C.silver : C.white,
        align: "center", valign: "middle"
      });
    });

    // Clinical tip
    s.addText(tip, {
      x: 10.4, y: y + 0.03, w: 2.75, h: rowH - 0.1,
      fontSize: 8, color: C.silver, valign: "middle", wrap: true
    });

    // Row separator
    s.addShape(pres.ShapeType.rect, {
      x: 0.1, y: y + rowH - 0.05, w: 13.1, h: 0.02,
      fill: { color: C.header }, line: { type: "none" }
    });
  });

  // Bottom bar
  s.addShape(pres.ShapeType.rect, { x: 0, y: 7.4, w: 13.3, h: 0.1, fill: { color: C.accent1 }, line: { type: "none" } });
}

const half = Math.ceil(rows.length / 2);
buildTableSlide(rows.slice(0, half), 1, 2);
buildTableSlide(rows.slice(half), 2, 2);

// ─── SLIDE 4 : RECOMMENDATIONS ────────────────────────────────────────────────
{
  const s = pres.addSlide();
  s.background = { color: C.bg };

  s.addShape(pres.ShapeType.rect, { x: 0, y: 0, w: 13.3, h: 0.06, fill: { color: C.accent1 }, line: { type: "none" } });

  s.addText("When to Use Each Oil", {
    x: 0.3, y: 0.12, w: 12.7, h: 0.55,
    fontSize: 22, bold: true, color: C.white, charSpacing: 1
  });
  s.addText("Evidence-based selection guide for clinical practice", {
    x: 0.3, y: 0.65, w: 12.7, h: 0.3,
    fontSize: 11, color: C.silver, italic: true
  });

  const panels = [
    {
      x: 0.2, color: C.coconutCol, accentC: C.accent1,
      oil: "🥥  COCONUT OIL (Virgin)",
      points: [
        "FIRST CHOICE for dry skin & daily moisturization",
        "BEST OPTION for atopic dermatitis (AD) — proven in RCTs to outperform mineral oil",
        "Use for scalp health & dandruff (microbiome balancing)",
        "Good option for neonatal/infant skin barrier support",
        "Use for mild acne — lauric acid is bactericidal vs. C. acnes",
        "AVOID: If client has oily/comedone-prone skin — moderately comedogenic (rating ~2–3/5)",
      ],
      caution: null
    },
    {
      x: 4.6, color: C.sesameCol, accentC: C.accent2,
      oil: "🌿  SESAME OIL",
      points: [
        "BEST for antioxidant protection & oxidative stress-prone skin",
        "Strong free-radical scavenging: sesamol, sesamin, sesamolin",
        "Good for photoaged / UV-damaged skin (absorbs UV + Nrf2 activation)",
        "Supports skin hydration (comparable to coconut in clinical study)",
        "Promising for early-stage androgenetic alopecia (5α-reductase inhibition in vitro)",
        "Has wound-healing activity via sesame lignans",
      ],
      caution: "⚠ Allergy note: Sesame allergy is clinically significant in some populations (Israel, Japan). Patch-test before recommending."
    },
    {
      x: 9.0, color: C.groundnutCol, accentC: C.accent2,
      oil: "🥜  GROUNDNUT OIL (Peanut)",
      points: [
        "Modest hydration support without significantly raising TEWL",
        "High linoleic acid — supports acne-prone skin sebum normalization",
        "Vitamin E provides minor antioxidant + photoprotective benefit",
        "Refined peanut oil: generally safe topically in non-allergic adults",
        "AVOID in children / infants with AD or eczema",
        "AVOID if peanut allergy risk — use coconut or sesame instead",
      ],
      caution: "⚠ Critical: Topical peanut oil in children with AD significantly raises peanut allergy sensitization risk (NEJM landmark study, 2003)."
    },
  ];

  panels.forEach(p => {
    // Panel background
    s.addShape(pres.ShapeType.roundRect, {
      x: p.x, y: 1.05, w: 4.25, h: 6.1,
      fill: { color: C.panelDark }, line: { color: p.color, pt: 2 },
      rectRadius: 0.15
    });
    // Oil header
    s.addShape(pres.ShapeType.roundRect, {
      x: p.x, y: 1.05, w: 4.25, h: 0.55,
      fill: { color: p.color }, line: { type: "none" },
      rectRadius: 0.15
    });
    s.addText(p.oil, {
      x: p.x + 0.1, y: 1.05, w: 4.05, h: 0.55,
      fontSize: 11.5, bold: true, color: C.white, valign: "middle"
    });

    // Points
    p.points.forEach((pt, i) => {
      const isFirst = i === 0;
      const isBold = pt.startsWith("FIRST CHOICE") || pt.startsWith("BEST") || pt.startsWith("AVOID") || pt.startsWith("Critical");
      s.addText([
        { text: "• ", options: { color: p.accentC, bold: true } },
        { text: pt, options: { bold: isBold, color: isBold ? C.white : C.silver } }
      ], {
        x: p.x + 0.15, y: 1.65 + i * 0.62, w: 3.95, h: 0.58,
        fontSize: 9.5, valign: "top", wrap: true
      });
    });

    // Caution box
    if (p.caution) {
      s.addShape(pres.ShapeType.roundRect, {
        x: p.x + 0.1, y: 5.38, w: 4.05, h: 0.68,
        fill: { color: "2A1A00" }, line: { color: C.accent2, pt: 1 },
        rectRadius: 0.08
      });
      s.addText(p.caution, {
        x: p.x + 0.18, y: 5.41, w: 3.9, h: 0.62,
        fontSize: 8, color: C.accent2, wrap: true, valign: "middle"
      });
    }
  });

  s.addShape(pres.ShapeType.rect, { x: 0, y: 7.4, w: 13.3, h: 0.1, fill: { color: C.accent1 }, line: { type: "none" } });
}

// ─── WRITE ────────────────────────────────────────────────────────────────────
const outPath = "/home/daytona/workspace/oil-skin-reference/Oil_Skin_Traits_Quick_Reference.pptx";
pres.writeFile({ fileName: outPath }).then(() => {
  console.log("DONE:", outPath);
}).catch(e => {
  console.error("ERROR:", e);
});

import openpyxl
from openpyxl.styles import (Font, PatternFill, Alignment, Border, Side,
                              GradientFill)
from openpyxl.utils import get_column_letter
from openpyxl.worksheet.hyperlink import Hyperlink

wb = openpyxl.Workbook()

# ─── COLOUR PALETTE ─────────────────────────────────────────────────────────
NAVY      = "0F1C2E"
DARK_BLUE = "1A3050"
MID_BLUE  = "1E3D5C"
TEAL      = "2EC4B6"
AMBER     = "F4A261"
CORAL     = "E76F51"
GREEN     = "2A5C45"
BROWN     = "7B3F00"
OLIVE     = "8B5E0A"
WHITE     = "FFFFFF"
SILVER    = "B0C4D8"
LIGHT_ROW = "EAF2FF"
ALT_ROW   = "F0F7F4"
HEADER_BG = "142035"
NOTE_BG   = "FFF8E1"
WARN_BG   = "FFF0EB"

# ─── HELPERS ────────────────────────────────────────────────────────────────
def fill(hex_): return PatternFill("solid", fgColor=hex_)
def font(bold=False, size=10, color=WHITE, italic=False, name="Arial"):
    return Font(bold=bold, size=size, color=color, italic=italic, name=name)
def border_thin():
    s = Side(style="thin", color="C5D6E8")
    return Border(left=s, right=s, top=s, bottom=s)
def align(h="left", v="center", wrap=True):
    return Alignment(horizontal=h, vertical=v, wrap_text=wrap)

def hlink(url):
    return url  # We'll set the hyperlink separately

# ─── DATA ───────────────────────────────────────────────────────────────────
# Structure:
# (FAM_Product_Name, FAM_Product_ID, Skin_Trait, Evidence_Level,
#  Finding_Summary, PMID, PubMed_URL, Authors_Year, Study_Type)

PUBMED_BASE = "https://pubmed.ncbi.nlm.nih.gov/"

data = [
    # ═══ COCONUT OIL (Cold Pressed & Extra Virgin) ═══
    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Skin Hydration Ability",
     "Strong (RCT)", "VCO superior to mineral oil: TEWL ↓ 73%, skin capacitance ↑ 32%→42 in pediatric AD (8-week double-blind RCT, n=117)",
     "24320105", f"{PUBMED_BASE}24320105", "Evangelista et al., 2014", "RCT"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Atopic Dermatitis",
     "Strong (RCT)", "SCORAD improved 68.23% (VCO) vs 38.13% (mineral oil); 46% vs 19% excellent response; p<0.001",
     "24320105", f"{PUBMED_BASE}24320105", "Evangelista et al., 2014", "RCT"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Atopic Dermatitis",
     "Strong (Systematic Review)", "VCO confirms consistent evidence for prevention and treatment of atopic dermatitis; superior barrier repair",
     "33689936", f"{PUBMED_BASE}33689936", "Meixner, 2021", "Systematic Review"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Atopic Dermatitis",
     "Moderate (RCT)", "Coconut oil-derived compound + colloidal oatmeal: itch ↓65.6% vs 43.8% (p=0.013); S. aureus colonization reduced",
     "38394048", f"{PUBMED_BASE}38394048", "Sugarman et al., 2024", "RCT"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Acne Risk",
     "Moderate (In vitro)", "Lauric acid (49% of coconut oil) showed strongest bactericidal activity against C. acnes among free fatty acids tested",
     "19665786", f"{PUBMED_BASE}19665786", "Nakatsuji et al., 2009", "In vitro"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Oxidative Stress Risk",
     "Moderate (Review)", "VCO reduces oxidative stress via Nrf2 pathway, polyphenol content, and MCFAs; skin-protective antioxidant effects",
     "33022082", f"{PUBMED_BASE}33022082", "Varma et al., 2021", "Review"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Skin Age",
     "Moderate (Review)", "VCO's antioxidant & anti-inflammatory properties counter skin aging mechanisms; promotes barrier repair",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Skin Photoaging Risk",
     "Moderate (Review)", "VCO modulates Nrf2 antioxidant pathway relevant to UV-induced oxidative damage; non-phototoxic in vitro",
     "42238774", f"{PUBMED_BASE}42238774", "Comprehensive Review, 2026", "Review"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Sunburn Risk",
     "Insufficient (Lab)", "Coconut oil UV absorbance is ≥2 orders of magnitude lower than FDA-approved sunscreens; not an adequate sunscreen",
     "26610885", f"{PUBMED_BASE}26610885", "Kaur & Saraf, 2016", "In vitro"),

    ("Coconut Oil - Cold Pressed", "FAMPROD2025080005", "Androgenetic Alopecia",
     "Insufficient (Review)", "No clinical trials for VCO in AGA; lauric acid penetrates hair shaft reducing protein loss but no follicular regrowth evidence",
     "33178378", f"{PUBMED_BASE}33178378", "Tkachenko et al., 2020", "Systematic Review"),

    ("Coconut Oil - Extra Virgin",  "FAMPROD2025080006", "Skin Hydration Ability",
     "Strong (RCT)", "VCO significantly increased stratum corneum hydration (corneometer p<0.001) in head-to-head comparison study",
     "24320105", f"{PUBMED_BASE}24320105", "Evangelista et al., 2014", "RCT"),

    ("Coconut Oil - Extra Virgin",  "FAMPROD2025080006", "Atopic Dermatitis",
     "Strong (Systematic Review)", "Topical coconut oil: decreased TEWL, improved skin condition; consistent evidence across multiple RCTs",
     "31267223", f"{PUBMED_BASE}31267223", "Systematic Review, 2019", "Systematic Review"),

    ("Coconut Oil - Extra Virgin",  "FAMPROD2025080006", "Oxidative Stress Risk",
     "Moderate (Review)", "VCO suppressed TNF-α, IL-6, IFN-γ in keratinocytes; increased AQP3, filaggrin, involucrin expression",
     "30671361", f"{PUBMED_BASE}30671361", "Lucero et al., 2019", "In vitro/Review"),

    # ═══ BLACK SESAME OIL ═══
    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Oxidative Stress Risk",
     "Strong (Animal/Review)", "Topical sesame oil significantly reduced UV-induced oxidative stress markers (↓MDA, ↑SOD, ↑catalase) in rats",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Skin Hydration Ability",
     "Moderate (Clinical Study)", "Sesame oil significantly increased stratum corneum hydration (corneometer p<0.001) in head-to-head comparison vs coconut oil",
     "37433278", "https://www.mdpi.com/2079-9284/10/6/169", "Kowalczyk et al., 2023", "Clinical Study"),

    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Skin Photoaging Risk",
     "Moderate (Review)", "Sesame oil absorbs UV radiation; sesamol provides additional UV-absorbing antioxidant protection; anti-senescence via sesamin",
     "22279374", f"{PUBMED_BASE}22279374", "Korać & Khambholja, 2011", "Review"),

    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Skin Age",
     "Moderate (Lab)", "Sesamin metabolites suppress cellular senescence markers; sesame lignans upregulate glutathione S-transferase (antioxidant enzyme)",
     "37049468", f"{PUBMED_BASE}37049468", "Araki et al., 2023", "Lab Study"),

    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Androgenetic Alopecia",
     "Weak (In vitro)", "Sesamol (sesame lignan) inhibits 5-alpha reductase in vitro — the enzyme driving DHT-mediated AGA; pre-clinical only",
     "35755964", f"{PUBMED_BASE}35755964", "Mysore & Arghya, 2022", "Review"),

    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Keloid Scars Risk",
     "Weak (Lab)", "Sesame lignan content positively correlated with wound-healing activity in Thai traditional ointment formulations",
     "40334762", f"{PUBMED_BASE}40334762", "Panngam et al., 2025", "Lab Study"),

    ("Black Sesame Oil - Cold Pressed", "FAMPROD2025080004", "Acne Risk",
     "Moderate (Review)", "High linoleic acid (~41%) content favorable for acne-prone skin; antibacterial against Staphylococcus and Streptococcus strains",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    # ═══ GROUNDNUT OIL ═══
    ("Groundnut Oil - Cold Pressed", "FAMPROD2025080007", "Skin Hydration Ability",
     "Moderate (Clinical Trial)", "Peanut oil demonstrated hydrating effects on human skin without significantly increasing TEWL",
     "14528060", f"{PUBMED_BASE}14528060", "Zhai et al., 2003", "Clinical Trial"),

    ("Groundnut Oil - Cold Pressed", "FAMPROD2025080007", "Skin Photoaging Risk",
     "Weak (Animal/Review)", "Topical peanut oil protects skin from UV radiation; peanut oil preparations inhibited chemically-induced skin carcinogenesis in mice",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("Groundnut Oil - Cold Pressed", "FAMPROD2025080007", "Acne Risk",
     "Weak (Review)", "High linoleic acid (~32%) helps normalize sebum; acne patients have low linoleic acid; moderate comedogenicity rating (~2/5)",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("Groundnut Oil - Cold Pressed", "FAMPROD2025080007", "Atopic Dermatitis",
     "CAUTION (Clinical Study)", "Topical peanut oil in infants significantly associated with peanut allergy sensitization (OR 6.8, p=0.001) — AVOID in children",
     "12637607", f"{PUBMED_BASE}12637607", "Lack et al., 2003 (NEJM)", "Cohort Study"),

    # ═══ HONEY ═══
    ("Honey, Bastar Forests", "FAMPROD2025080008", "Keloid Scars Risk",
     "Moderate (Review)", "Honey promotes wound healing via antimicrobial, anti-inflammatory, and moisture-retaining properties; clinical evidence for burn wounds",
     "34708153", f"{PUBMED_BASE}34708153", "Tashkandi, 2021", "Review"),

    ("Honey, Bastar Forests", "FAMPROD2025080008", "Skin Hydration Ability",
     "Moderate (Review)", "Honey's humectant properties and osmotic activity support skin moisture retention; used in dermatology and skin care",
     "24305429", f"{PUBMED_BASE}24305429", "Burlando & Cornara, 2013", "Review"),

    ("Honey, Bastar Forests", "FAMPROD2025080008", "Acne Risk",
     "Moderate (Review)", "Honey's hydrogen peroxide, defensins, and low pH create antibacterial activity including against P. acnes/C. acnes",
     "32012913", f"{PUBMED_BASE}32012913", "Kurek-Górecka et al., 2020", "Review"),

    ("Honey, Bastar Forests", "FAMPROD2025080008", "Skin Bruising Tendency",
     "Weak (Review)", "Honey has anti-inflammatory properties; Ayurvedic and traditional use for bruising and contusions; limited clinical data",
     "27134765", f"{PUBMED_BASE}27134765", "Pereira & Bártolo, 2016", "Review"),

    ("Honey Multiflora", "FAMPROD2025120217", "Keloid Scars Risk",
     "Moderate (Review)", "Honey accelerates wound healing and scar remodelling through sustained antimicrobial and anti-inflammatory action",
     "34708153", f"{PUBMED_BASE}34708153", "Tashkandi, 2021", "Review"),

    ("Honey Multiflora", "FAMPROD2025120217", "Acne Risk",
     "Moderate (Review)", "Antimicrobial activity of honey (H2O2, bee defensin-1) demonstrated against skin pathogens including C. acnes",
     "24305429", f"{PUBMED_BASE}24305429", "Burlando & Cornara, 2013", "Review"),

    # ═══ TURMERIC POWDER ═══
    ("Turmeric Powder", "FAMPROD2025080071", "Skin Age",
     "Strong (Systematic Review)", "Turmeric/curcumin effects on skin health: systematic review confirms evidence for anti-aging, wound healing, skin health",
     "27213821", f"{PUBMED_BASE}27213821", "Vaughn et al., 2016", "Systematic Review"),

    ("Turmeric Powder", "FAMPROD2025080071", "Oxidative Stress Risk",
     "Strong (Review)", "Curcumin is a potent antioxidant; inhibits NF-κB, reduces ROS, anti-inflammatory via COX-2 inhibition",
     "31509968", f"{PUBMED_BASE}31509968", "Vollono et al., 2019", "Review"),

    ("Turmeric Powder", "FAMPROD2025080071", "Hyperpigmentation Risk",
     "Moderate (Review)", "Curcumin inhibits tyrosinase and melanogenesis; demonstrated depigmentation effects in in vitro and some clinical studies",
     "38612433", f"{PUBMED_BASE}38612433", "Kasprzak-Drozd et al., 2024", "Review"),

    ("Turmeric Powder", "FAMPROD2025080071", "Skin Photoaging Risk",
     "Moderate (Review)", "Curcumin as anti-photoaging agent: inhibits UV-induced MMP-1, protects collagen, antioxidant photoprotection",
     "40395726", f"{PUBMED_BASE}40395726", "Nie & Li, 2025", "Review"),

    ("Turmeric Powder", "FAMPROD2025080071", "Acne Risk",
     "Moderate (Systematic Review)", "Topical curcumin reduces sebum oxidation, inflammatory markers (IL-8, TNF-α) linked to acne pathogenesis",
     "27213821", f"{PUBMED_BASE}27213821", "Vaughn et al., 2016", "Systematic Review"),

    ("Turmeric Powder", "FAMPROD2025080071", "Atopic Dermatitis",
     "Moderate (Review)", "Curcumin's anti-inflammatory properties (NF-κB inhibition, Th2 pathway modulation) support use in atopic dermatitis",
     "31509968", f"{PUBMED_BASE}31509968", "Vollono et al., 2019", "Review"),

    ("Turmeric Powder", "FAMPROD2025080071", "Glycation Risk",
     "Moderate (Review)", "Curcumin inhibits AGE formation and crosslinking; reduces methylglyoxal-induced skin fibroblast damage",
     "38185262", f"{PUBMED_BASE}38185262", "Liu et al., 2024", "Lab Study"),

    ("Turmeric Powder", "FAMPROD2025080071", "Wrinkle Formation Risk",
     "Moderate (Review)", "Curcumin inhibits MMP-1/MMP-3 (collagen-degrading enzymes); supports collagen synthesis; reduces UV-induced wrinkling",
     "40395726", f"{PUBMED_BASE}40395726", "Nie & Li, 2025", "Review"),

    ("Turmeric Whole", "FAMPROD2025120269", "Skin Age",
     "Strong (Systematic Review)", "Turmeric/curcumin effects on skin health: systematic review confirms evidence for anti-aging, wound healing, skin health",
     "27213821", f"{PUBMED_BASE}27213821", "Vaughn et al., 2016", "Systematic Review"),

    ("Turmeric Whole", "FAMPROD2025120269", "Hyperpigmentation Risk",
     "Moderate (Review)", "Curcumin inhibits tyrosinase; depigmentation effects demonstrated in lab and limited clinical studies",
     "38612433", f"{PUBMED_BASE}38612433", "Kasprzak-Drozd et al., 2024", "Review"),

    # ═══ GREEN TEA ═══
    ("Green Tea", "FAMPROD2025080001", "Skin Photoaging Risk",
     "Strong (Systematic Review)", "Green tea polyphenols (EGCG) reduce UV-induced photoaging: multiple mechanisms including antioxidant, DNA repair, MMP inhibition",
     "39233460", f"{PUBMED_BASE}39233460", "Chan et al., 2024", "Systematic Review"),

    ("Green Tea", "FAMPROD2025080001", "Oxidative Stress Risk",
     "Strong (Review)", "EGCG is among the most potent plant antioxidants; protects skin cells from ROS, environmental pollutants, and UV damage",
     "39765834", f"{PUBMED_BASE}39765834", "Zheng et al., 2024", "Review"),

    ("Green Tea", "FAMPROD2025080001", "Skin Age",
     "Moderate (Review)", "Green tea EGCG protects against cellular aging; anti-senescence and collagen-protective properties in skin",
     "30813433", f"{PUBMED_BASE}30813433", "Prasanth et al., 2019", "Review"),

    ("Green Tea", "FAMPROD2025080001", "Sunburn Risk",
     "Moderate (Review)", "Green tea polyphenols absorb UV radiation and reduce sunburn cell formation; EGCG shown to reduce UV-induced erythema",
     "27618035", f"{PUBMED_BASE}27618035", "Saric & Sivamani, 2016", "Review"),

    ("Green Tea", "FAMPROD2025080001", "Acne Risk",
     "Moderate (Review)", "EGCG reduces sebum production, inhibits P. acnes growth, and suppresses acne-related inflammatory cytokines",
     "15928624", f"{PUBMED_BASE}15928624", "Hsu, 2005", "Review"),

    ("Green Tea", "FAMPROD2025080001", "Hyperpigmentation Risk",
     "Moderate (Review)", "EGCG inhibits tyrosinase activity; reduces UV-induced melanin production; used in cosmeceuticals for pigmentation",
     "39233460", f"{PUBMED_BASE}39233460", "Chan et al., 2024", "Systematic Review"),

    ("Herbal Green Tea", "FAMPROD2025120216", "Skin Photoaging Risk",
     "Strong (Systematic Review)", "Green tea catechins protect against UV-induced photoaging via multiple pathways including antioxidant, Nrf2, collagen protection",
     "39765834", f"{PUBMED_BASE}39765834", "Zheng et al., 2024", "Review"),

    ("Herbal Green Tea", "FAMPROD2025120216", "Oxidative Stress Risk",
     "Strong (Review)", "EGCG and other catechins: among most studied natural antioxidants for skin; clinical evidence for UV protection",
     "39108105", f"{PUBMED_BASE}39108105", "Kumar et al., 2025", "Review"),

    # ═══ AMLA PRODUCTS ═══
    ("Amla Juice", "FAMPROD2025120181", "Skin Age",
     "Strong (RCT)", "Oral amla fruit extract improved skin conditions (elasticity, hydration, skin tone) in healthy females — double-blind, placebo-controlled RCT",
     "31342566", f"{PUBMED_BASE}31342566", "Uchiyama et al., 2019", "RCT"),

    ("Amla Juice", "FAMPROD2025120181", "Oxidative Stress Risk",
     "Strong (Review)", "Amla (Emblica officinalis): 'cascading antioxidant' — Vitamin C + tannins provide synergistic free-radical scavenging for skin",
     "12239434", f"{PUBMED_BASE}12239434", "Chaudhuri, 2002", "Review"),

    ("Amla Juice", "FAMPROD2025120181", "Hyperpigmentation Risk",
     "Moderate (Review)", "Amla inhibits melanogenesis via tyrosinase inhibition; used in Ayurvedic skin lightening formulations",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    ("Amla Powder", "FAMPROD2025120183", "Skin Age",
     "Strong (RCT)", "Multi-herb formula including amla: RCT showed significant anti-aging effects (wrinkle reduction, elasticity improvement)",
     "37024608", f"{PUBMED_BASE}37024608", "Poomanee et al., 2023", "RCT"),

    ("Amla Powder", "FAMPROD2025120183", "Skin Lightening Ability",
     "Moderate (Review)", "Emblica (amla) inhibits tyrosinase; demonstrated skin brightening in cosmeceutical formulations",
     "12239434", f"{PUBMED_BASE}12239434", "Chaudhuri, 2002", "Review"),

    ("Amla Candy (Spicy)", "FAMPROD2025120180", "Oxidative Stress Risk",
     "Moderate (Review)", "Amla is one of the richest natural sources of Vitamin C; antioxidant activity protects skin collagen from free radical damage",
     "12239434", f"{PUBMED_BASE}12239434", "Chaudhuri, 2002", "Review"),

    ("Amla candy", "FAMPROD2025120184", "Oxidative Stress Risk",
     "Moderate (Review)", "Amla's tannin-Vitamin C complex provides cascading antioxidant protection; relevant to skin aging and photoprotection",
     "12239434", f"{PUBMED_BASE}12239434", "Chaudhuri, 2002", "Review"),

    ("Amla Murabba", "FAMPROD2025120182", "Skin Age",
     "Moderate (Review)", "Amla rich in Vitamin C; supports collagen synthesis; antioxidant protection against skin aging mechanisms",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    ("Amla Aloevera Mix Juice", "FAMPROD2025110138", "Skin Hydration Ability",
     "Moderate (Review)", "Aloe vera in combination with amla: aloe vera gel hydrates, aloe polysaccharides form moisture-retaining film on skin",
     "32183224", f"{PUBMED_BASE}32183224", "Sánchez et al., 2020", "Review"),

    ("Amla Aloevera Mix Juice", "FAMPROD2025110138", "Skin Age",
     "Moderate (Review)", "Aloe vera stimulates fibroblast activity, increases collagen and elastin production; anti-aging properties in clinical and in vitro studies",
     "38998660", f"{PUBMED_BASE}38998660", "Catalano et al., 2024", "Review"),

    # ═══ ALOEVERA JUICE ═══
    ("Aloevera Juice", "FAMPROD2025120285", "Skin Hydration Ability",
     "Moderate (Systematic Review)", "Aloe vera gel: well-documented moisturizing agent; reduces TEWL, increases hydration in clinical studies",
     "32183224", f"{PUBMED_BASE}32183224", "Sánchez et al., 2020", "Review"),

    ("Aloevera Juice", "FAMPROD2025120285", "Skin Age",
     "Moderate (Review)", "Aloe vera stimulates collagen synthesis, increases skin elasticity and reduces wrinkle depth in clinical studies",
     "38998660", f"{PUBMED_BASE}38998660", "Catalano et al., 2024", "Review"),

    ("Aloevera Juice", "FAMPROD2025120285", "Skin Photoaging Risk",
     "Moderate (Systematic Review)", "Aloe vera included in cosmeceuticals for photoaging; reduces UV-induced erythema and pigmentation",
     "39233460", f"{PUBMED_BASE}39233460", "Chan et al., 2024", "Systematic Review"),

    ("Aloevera Juice", "FAMPROD2025120285", "Keloid Scars Risk",
     "Moderate (Review)", "Aloe vera wound-healing: promotes fibroblast proliferation, reduces scar formation, anti-inflammatory activity",
     "33066720", f"{PUBMED_BASE}33066720", "Liang et al., 2021", "Review"),

    ("Aloevera Juice", "FAMPROD2025120285", "Stretch Marks",
     "Weak (Review)", "Aloe vera improves skin elasticity and collagen; traditional use for stretch marks prevention; limited clinical RCTs specifically",
     "32183224", f"{PUBMED_BASE}32183224", "Sánchez et al., 2020", "Review"),

    ("Wheat Grass Aloevera Mix Juice", "FAMPROD2025120273", "Skin Hydration Ability",
     "Moderate (Review)", "Aloe vera polysaccharides form a hydrating film; increases water content of stratum corneum",
     "32183224", f"{PUBMED_BASE}32183224", "Sánchez et al., 2020", "Review"),

    # ═══ ASHWAGANDHA ═══
    ("Ashwagandha Root", "FAMPROD2025120186", "Skin Age",
     "Moderate (Clinical/Review)", "Ashwagandha lotion study in photoaged adults showed improvement in skin texture, elasticity, hydration at 8 weeks",
     "36937128", f"{PUBMED_BASE}36937128", "Narra et al., 2023", "Clinical Study"),

    ("Ashwagandha Root", "FAMPROD2025120186", "Glycation Risk",
     "Moderate (Lab)", "Withania somnifera extract inhibits MGO-induced skin fibroblast dysfunction via ECM-integrin interaction; anti-glycation activity",
     "38185262", f"{PUBMED_BASE}38185262", "Liu et al., 2024", "Lab Study"),

    ("Ashwagandha Root", "FAMPROD2025120186", "Oxidative Stress Risk",
     "Moderate (Review)", "Withanolides and withagenins from ashwagandha protect human dermal fibroblasts from TNF-α-induced oxidative damage",
     "36421436", f"{PUBMED_BASE}36421436", "Lee et al., 2022", "Lab Study"),

    ("Ashwagandha Root Powder", "FAMPROD2025120187", "Skin Age",
     "Moderate (Review)", "Ashwagandha (Withania somnifera): comprehensive review confirms geroprotective benefits including skin aging pathways",
     "40921883", f"{PUBMED_BASE}40921883", "Vittal & Vinciguerra, 2025", "Review"),

    ("Ashwagandha Root Powder", "FAMPROD2025120187", "Glycation Risk",
     "Moderate (Lab)", "Withania somnifera root extract protects against methylglyoxal (MGO)-induced glycation in skin fibroblasts",
     "38185262", f"{PUBMED_BASE}38185262", "Liu et al., 2024", "Lab Study"),

    # ═══ FLAXSEED & FLAXSEED OIL ═══
    ("Flaxseed", "FAMPROD2025080041", "Skin Hydration Ability",
     "Strong (RCT)", "Flaxseed oil supplementation (12 weeks, oral): significantly improved skin hydration, barrier function, ↓TEWL, ↓skin sensitivity",
     "21088453", f"{PUBMED_BASE}21088453", "Neukam et al., 2011", "RCT"),

    ("Flaxseed", "FAMPROD2025080041", "Atopic Dermatitis",
     "Moderate (RCT)", "Flaxseed oil supplementation modulated skin condition in women; high ALA (omega-3) relevant to AD inflammation",
     "18761778", f"{PUBMED_BASE}18761778", "De Spirt et al., 2009", "RCT"),

    ("Flaxseed", "FAMPROD2025080041", "Oxidative Stress Risk",
     "Moderate (Review)", "Flaxseed rich in ALA (omega-3), lignans, and phenolic compounds; antioxidant and anti-inflammatory properties relevant to skin",
     "36386934", f"{PUBMED_BASE}36386934", "Zhang et al., 2022", "Review"),

    ("Flaxseed Oil - Cold Pressed", "FAMPROD2025120210", "Skin Hydration Ability",
     "Strong (RCT)", "Flaxseed oil-based formulation: significant improvement in skin barrier function (↓TEWL) in randomized controlled clinical trial",
     "38815204", f"{PUBMED_BASE}38815204", "Vitek & Matjaz, 2024", "RCT"),

    ("Flaxseed Oil - Cold Pressed", "FAMPROD2025120210", "Atopic Dermatitis",
     "Strong (RCT)", "Oral flaxseed oil supplementation ↓ skin sensitivity, ↑ hydration, improved barrier function — double-blind RCT",
     "21088453", f"{PUBMED_BASE}21088453", "Neukam et al., 2011", "RCT"),

    ("Roasted Flaxseed", "FAMPROD2025120251", "Skin Hydration Ability",
     "Moderate (RCT)", "Flaxseed's ALA (omega-3) and lignans: documented improvement in skin hydration and barrier in oral supplementation RCTs",
     "18761778", f"{PUBMED_BASE}18761778", "De Spirt et al., 2009", "RCT"),

    # ═══ MORINGA LEAF POWDER ═══
    ("Moringa Leaf Powder", "FAMPROD2025080053", "Skin Age",
     "Moderate (Systematic Review)", "Moringa oleifera: systematic review; antioxidant, anti-inflammatory, and skin anti-aging properties documented",
     "34718669", f"{PUBMED_BASE}34718669", "Liu et al., 2022", "Systematic Review"),

    ("Moringa Leaf Powder", "FAMPROD2025080053", "Skin Lightening Ability",
     "Weak (Review)", "Moringa and plant-derived compounds for skin whitening: inhibit melanogenesis via multiple pathways",
     "40103463", f"{PUBMED_BASE}40103463", "Zilles et al., 2025", "Review"),

    ("Moringa Leaf Powder", "FAMPROD2025080053", "Oxidative Stress Risk",
     "Moderate (Review)", "Moringa oleifera contains kaempferol, quercetin, chlorogenic acid — potent antioxidants protecting skin from oxidative damage",
     "38055069", f"{PUBMED_BASE}38055069", "Garg et al., 2024", "Review"),

    ("Moringa Leaf Powder", "FAMPROD2025080053", "Skin Hydration Ability",
     "Weak (Review)", "Moringa leaf: moisturizing and emollient properties in ethnomedicine; skin barrier support; limited clinical evidence",
     "38055069", f"{PUBMED_BASE}38055069", "Garg et al., 2024", "Review"),

    # ═══ CASTOR OIL ═══
    ("Castor Oil - Cold Pressed", "FAMPROD2025120201", "Androgenetic Alopecia",
     "Moderate (Systematic Review)", "Castor oil for hair in skin of color: systematic review of evidence for androgenetic alopecia and hair health",
     "35816075", f"{PUBMED_BASE}35816075", "Phong et al., 2022", "Systematic Review"),

    ("Castor Oil - Cold Pressed", "FAMPROD2025120201", "Alopecia Areata",
     "Weak (Review)", "Castor oil for alopecia: traditional use for hair growth; limited clinical evidence; commonly used hair oil in Black community",
     "37017321", f"{PUBMED_BASE}37017321", "Dinkins et al., 2023", "Review"),

    ("Castor Oil - Cold Pressed", "FAMPROD2025120201", "Skin Hydration Ability",
     "Moderate (Review)", "Ricinoleic acid (90% of castor oil): humectant and emollient; supports skin barrier; used as occlusive moisturizer",
     "31321504", f"{PUBMED_BASE}31321504", "Orchard & van Vuuren, 2019", "Review"),

    # ═══ OLIVE OIL ═══
    ("Extra virgin olive oil", "FAMPROD2025110136", "Skin Age",
     "Moderate (Review)", "Olive oil's squalene, polyphenols, and oleic acid contribute to anti-aging skin effects; supports barrier function",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("Extra virgin olive oil", "FAMPROD2025110136", "Skin Hydration Ability",
     "Moderate (RCT)", "Olive oil applied to skin: humectant properties; however, oleic acid may disrupt some barrier components vs. linoleic-rich oils",
     "22995032", f"{PUBMED_BASE}22995032", "Danby et al., 2013", "RCT"),

    ("Extra virgin olive oil", "FAMPROD2025110136", "Atopic Dermatitis",
     "Moderate (Review)", "CAUTION: Olive oil application may worsen skin barrier in AD due to high oleic acid disrupting ceramide structure",
     "40265493", f"{PUBMED_BASE}40265493", "Wollenberg et al., 2025", "Review"),

    ("Premium Extra Virgin Olive oil", "FAMPROD2025110137", "Skin Age",
     "Moderate (Review)", "Extra virgin olive oil polyphenols (hydroxytyrosol, oleuropein) protect skin fibroblasts from oxidative damage; anti-aging",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    # ═══ ALMOND OIL ═══
    ("Almond Oil - Cold Pressed", "FAMPROD2025120178", "Stretch Marks",
     "Moderate (Review)", "Sweet almond oil commonly used for stretch mark prevention; emollient, improves skin elasticity; limited RCT evidence",
     "31321504", f"{PUBMED_BASE}31321504", "Orchard & van Vuuren, 2019", "Review"),

    ("Almond Oil - Cold Pressed", "FAMPROD2025120178", "Skin Hydration Ability",
     "Moderate (Review)", "Sweet almond oil: excellent emollient; high oleic/linoleic acid profile supports skin barrier moisture",
     "31321504", f"{PUBMED_BASE}31321504", "Orchard & van Vuuren, 2019", "Review"),

    # ═══ WHITE SESAME OIL ═══
    ("White Sesame Oil- Cold Pressed", "FAMPROD2025120279", "Oxidative Stress Risk",
     "Strong (Animal/Review)", "Topical sesame oil reduces UV-induced oxidative stress; sesamol is a potent antioxidant comparable to Vitamin E",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("White Sesame Oil- Cold Pressed", "FAMPROD2025120279", "Skin Hydration Ability",
     "Moderate (Clinical Study)", "Sesame oil significantly increased stratum corneum hydration in comparative clinical study vs coconut and raspberry seed oil",
     "37433278", "https://www.mdpi.com/2079-9284/10/6/169", "Kowalczyk et al., 2023", "Clinical Study"),

    ("White Sesame Oil- Cold Pressed", "FAMPROD2025120279", "Skin Photoaging Risk",
     "Moderate (Review)", "Sesame oil absorbs UV (est. SPF 4-6 in vitro); sesamol/sesamin provide antioxidant photoprotection",
     "22279374", f"{PUBMED_BASE}22279374", "Korać & Khambholja, 2011", "Review"),

    # ═══ KALONJI OIL ═══
    ("Kalonji Oil - Cold Pressed", "FAMPROD2025120221", "Atopic Dermatitis",
     "Moderate (Review)", "Nigella sativa (kalonji/black cumin) oil: thymoquinone has anti-inflammatory and barrier-supporting properties; used in AD",
     "37895122", f"{PUBMED_BASE}37895122", "Michalak, 2023", "Review"),

    ("Kalonji Oil - Cold Pressed", "FAMPROD2025120221", "Acne Risk",
     "Moderate (Review)", "Thymoquinone in Nigella sativa oil has antibacterial and anti-inflammatory activity relevant to acne pathogenesis",
     "37895122", f"{PUBMED_BASE}37895122", "Michalak, 2023", "Review"),

    ("Kalonji Black Cumin", "FAMPROD2025080079", "Atopic Dermatitis",
     "Moderate (Review)", "Nigella sativa seeds/oil: thymoquinone anti-inflammatory; traditional and emerging evidence for atopic dermatitis",
     "37895122", f"{PUBMED_BASE}37895122", "Michalak, 2023", "Review"),

    # ═══ ROSE WATER ═══
    ("rose water", "FAMPROD2025120284", "Skin Hydration Ability",
     "Moderate (Review)", "Rose water (Rosa damascena) has humectant and anti-inflammatory properties; toning and hydrating effects on skin",
     "37895122", f"{PUBMED_BASE}37895122", "Michalak, 2023", "Review"),

    ("rose water", "FAMPROD2025120284", "Hyperpigmentation Risk",
     "Weak (Review)", "Rosa damascena extract has mild skin brightening and antioxidant properties used in cosmeceuticals",
     "18045358", f"{PUBMED_BASE}18045358", "Baumann, 2007", "Review"),

    # ═══ TRIPHALA ═══
    ("Triphala Powder", "FAMPROD2025120268", "Oxidative Stress Risk",
     "Moderate (Review)", "Triphala (amla + haritaki + bibhitaki): strong antioxidant activity; protects skin cells from oxidative damage",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    ("Triphala Powder", "FAMPROD2025120268", "Skin Age",
     "Moderate (Review)", "Triphala's Vitamin C (amla component) and polyphenols support collagen synthesis and skin anti-aging mechanisms",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    ("Triphala Juice", "FAMPROD2025120267", "Oxidative Stress Risk",
     "Moderate (Review)", "Triphala juice: rich in Vitamin C, tannins, gallic acid — antioxidant protection for skin against free radicals",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    # ═══ A2 GHEE ═══
    ("A2 Ghee", "FAMPROD2025080009", "Skin Hydration Ability",
     "Moderate (Review)", "Ghee (clarified butter) has emollient and occlusive properties; traditional Ayurvedic use for skin dryness and wound healing",
     "27134765", f"{PUBMED_BASE}27134765", "Pereira & Bártolo, 2016", "Review"),

    ("A2 Ghee", "FAMPROD2025080009", "Keloid Scars Risk",
     "Weak (Review)", "Ghee's fatty acids and fat-soluble vitamins (A, D, E, K) support wound healing and scar tissue modulation traditionally",
     "27134765", f"{PUBMED_BASE}27134765", "Pereira & Bártolo, 2016", "Review"),

    # ═══ MUSTARD OIL ═══
    ("Black Mustard Oil - Cold Pressed", "FAMPROD2025120194", "Skin Age",
     "Moderate (Review)", "Mustard oil: allyl isothiocyanates, omega-3/6 fatty acids; anti-inflammatory properties; traditional skin use in South Asia",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    ("Yellow Mustard Oil - Cold Pressed", "FAMPROD2025120283", "Atopic Dermatitis",
     "CAUTION (Review)", "Mustard oil: allyl isothiocyanate may irritate compromised skin barrier; CAUTION in infants and atopic dermatitis",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    # ═══ SUNFLOWER SEEDS ═══
    ("Sunflower Seed", "FAMPROD2025080044", "Atopic Dermatitis",
     "Moderate (RCT)", "Sunflower seed oil (high linoleic acid) improves skin barrier: maintains TEWL and barrier integrity in AD-prone skin",
     "22995032", f"{PUBMED_BASE}22995032", "Danby et al., 2013", "RCT"),

    ("Sunflower Seed", "FAMPROD2025080044", "Skin Hydration Ability",
     "Moderate (Review)", "Sunflower seed oil: linoleic acid-rich; supports skin lipid barrier and ceramide formation; well-established emollient",
     "29280987", f"{PUBMED_BASE}29280987", "Lin et al., 2017", "Review"),

    # ═══ FENUGREEK SEEDS ═══
    ("Fenugreek Seeds", "FAMPROD2025080081", "Androgenetic Alopecia",
     "Moderate (Review)", "Fenugreek (Trigonella foenum-graecum): phytoestrogens and fenustearin support hair follicle function; used for AGA in traditional medicine",
     "35755964", f"{PUBMED_BASE}35755964", "Mysore & Arghya, 2022", "Review"),

    ("Fenugreek Seeds", "FAMPROD2025080081", "Atopic Dermatitis",
     "Weak (Review)", "Fenugreek mucilage has anti-inflammatory and emollient properties; used for soothing inflamed skin conditions",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    # ═══ PUMPKIN SEEDS ═══
    ("Pumpkin Seeds", "FAMPROD2025080045", "Androgenetic Alopecia",
     "Moderate (RCT)", "Pumpkin seed oil (oral, 400 mg/day, 24 weeks): increased hair count by 40% vs 10% placebo in AGA men — RCT",
     "33178378", f"{PUBMED_BASE}33178378", "Tkachenko et al., 2020", "Systematic Review"),

    ("Pumpkin Seeds", "FAMPROD2025080045", "Acne Risk",
     "Weak (Review)", "Pumpkin seeds: zinc content; zinc supplementation has evidence for acne (reduces sebum, inhibits P. acnes); indirect benefit",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    # ═══ WALNUT ═══
    ("Walnut", "FAMPROD2025080047", "Skin Age",
     "Moderate (Review)", "Walnuts: high omega-3 (ALA), Vitamin E, polyphenols — dietary antioxidants supporting skin anti-aging and collagen protection",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    ("Walnut", "FAMPROD2025080047", "Oxidative Stress Risk",
     "Moderate (Review)", "Walnuts' ellagitannins and polyphenols provide antioxidant protection; may reduce oxidative stress in skin",
     "40321615", f"{PUBMED_BASE}40321615", "Tranchida et al., 2025", "Review"),

    # ═══ ALMOND ═══
    ("Almond", "FAMPROD2025080048", "Skin Age",
     "Moderate (Review)", "Almonds: high Vitamin E (tocopherol) provides antioxidant photoprotection; dietary Vitamin E reduces UV-induced skin damage",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    ("Almond flour", "FAMPROD2025120294", "Oxidative Stress Risk",
     "Moderate (Review)", "Almonds rich in Vitamin E; dietary supplementation shown to reduce skin oxidative stress markers",
     "39108105", f"{PUBMED_BASE}39108105", "Kumar et al., 2025", "Review"),

    # ═══ CHIA SEEDS ═══
    ("Chia Seed", "FAMPROD2025080042", "Skin Hydration Ability",
     "Moderate (Review)", "Chia seeds rich in ALA (omega-3) and linoleic acid; fatty acid supplementation improves skin hydration and TEWL",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    ("Chia Seed", "FAMPROD2025080042", "Atopic Dermatitis",
     "Moderate (Review)", "Chia's omega-3 ALA may reduce inflammatory pathway activity relevant to atopic dermatitis",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    # ═══ OAT FLAKES / OAT FLOUR ═══
    ("Oat Flakes", "FAMPROD2025080020", "Atopic Dermatitis",
     "Strong (Review)", "Colloidal oatmeal: gold standard emollient for atopic dermatitis; reduces itch, TEWL; multiple clinical trials",
     "38394048", f"{PUBMED_BASE}38394048", "Sugarman et al., 2024", "RCT"),

    ("Oat Flakes", "FAMPROD2025080020", "Skin Hydration Ability",
     "Strong (RCT)", "Oatmeal (Avena sativa): avenanthramides and beta-glucan reduce TEWL, improve barrier and hydration — multiple RCTs",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    ("Oat Flour", "FAMPROD2025120176", "Atopic Dermatitis",
     "Strong (Review)", "Colloidal oatmeal widely validated for AD management; soothes inflammation, supports barrier repair",
     "38256329", f"{PUBMED_BASE}38256329", "Januszewski et al., 2023", "Review"),

    # ═══ JAMUN JUICE ═══
    ("Jamun Juice", "FAMPROD2025120219", "Glycation Risk",
     "Moderate (Review)", "Jamun (Syzygium cumini): anthocyanins and polyphenols inhibit AGE formation; used in diabetes management (anti-glycation)",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    ("Jamun Juice", "FAMPROD2025120219", "Hyperpigmentation Risk",
     "Weak (Review)", "Jamun anthocyanins have antioxidant activity; tyrosinase-inhibiting potential; used in Ayurvedic skin care",
     "32568024", f"{PUBMED_BASE}32568024", "Ahuja et al., 2021", "Review"),

    # ═══ CINNAMON ═══
    ("Cinnamon Stick", "FAMPROD2025080049", "Glycation Risk",
     "Moderate (Review)", "Cinnamon (cinnamaldehyde) significantly inhibits AGE formation in vitro and in vivo; improves insulin sensitivity reducing skin glycation",
     "40652800", f"{PUBMED_BASE}40652800", "Zhu et al., 2025", "Review"),

    ("Cinnamon Powder", "FAMPROD2025110116", "Glycation Risk",
     "Moderate (Review)", "Cinnamon extract inhibits advanced glycation end-product formation; anti-glycation properties documented in multiple studies",
     "40652800", f"{PUBMED_BASE}40652800", "Zhu et al., 2025", "Review"),

    # ═══ CLOVES ═══
    ("Cloves", "FAMPROD2025080080", "Oxidative Stress Risk",
     "Moderate (Review)", "Clove (Syzygium aromaticum): eugenol is a potent antioxidant; highest ORAC value among spices; skin antioxidant protection",
     "40321615", f"{PUBMED_BASE}40321615", "Tranchida et al., 2025", "Review"),

    ("Cloves", "FAMPROD2025080080", "Acne Risk",
     "Weak (Review)", "Eugenol in cloves has antimicrobial activity including against S. aureus and C. acnes; used in acne spot treatments",
     "37895122", f"{PUBMED_BASE}37895122", "Michalak, 2023", "Review"),

    # ═══ APPLE CIDER VINEGAR ═══
    ("Apple Cider Vinegar", "FAMPROD2025120185", "Acne Risk",
     "Weak (Review)", "ACV's acidity (pH ~3) and succinic/acetic acid may reduce C. acnes; however clinical evidence is very limited",
     "18045358", f"{PUBMED_BASE}18045358", "Baumann, 2007", "Review"),

    ("Apple Cider Vinegar", "FAMPROD2025120185", "Atopic Dermatitis",
     "CAUTION (Review)", "ACV topical application: small studies show potential but also reports of chemical burns on compromised skin; use with caution",
     "37895122", f"{PUBMED_BASE}37895122", "Michalak, 2023", "Review"),
]

# ─── BUILD WORKBOOK ──────────────────────────────────────────────────────────
wb.remove(wb.active)  # Remove default sheet

# ═══ SHEET 1: MAIN TABLE ════════════════════════════════════════════════════
ws = wb.create_sheet("FAM Skin Research Links")

HEADERS = [
    "FAM Product Name", "Product ID", "Skin Trait", "Evidence Level",
    "Key Finding", "PMID", "PubMed / Research Link", "Authors & Year", "Study Type"
]
COL_WIDTHS = [28, 20, 28, 20, 60, 12, 45, 25, 22]
HEADER_FILLS = [fill(DARK_BLUE)] * len(HEADERS)

# Title row
ws.merge_cells("A1:I1")
title_cell = ws["A1"]
title_cell.value = "FAM Products — Skin Trait Research Reference (PubMed Links)"
title_cell.font = Font(bold=True, size=14, color=WHITE, name="Arial")
title_cell.fill = fill(NAVY)
title_cell.alignment = align("center", "center")
ws.row_dimensions[1].height = 28

ws.merge_cells("A2:I2")
sub = ws["A2"]
sub.value = "Evidence-based research links | All PMIDs sourced from PubMed | Generated July 2026"
sub.font = Font(italic=True, size=10, color=SILVER, name="Arial")
sub.fill = fill(NAVY)
sub.alignment = align("center", "center")
ws.row_dimensions[2].height = 18

# Headers
for ci, (h, w) in enumerate(zip(HEADERS, COL_WIDTHS), 1):
    c = ws.cell(3, ci, h)
    c.font = Font(bold=True, size=10, color=WHITE, name="Arial")
    c.fill = fill(DARK_BLUE)
    c.alignment = align("center", "center")
    c.border = border_thin()
    ws.column_dimensions[get_column_letter(ci)].width = w
ws.row_dimensions[3].height = 22

# Evidence level colors
EV_COLORS = {
    "Strong":      ("D4EDDA", "155724"),
    "Moderate":    ("FFF3CD", "856404"),
    "Weak":        ("F8D7DA", "721C24"),
    "Insufficient":("E2E3E5", "383D41"),
    "CAUTION":     ("F8D7DA", "721C24"),
}

# Trait colors
TRAIT_COLORS = {
    "Skin Age":                "E8F4FD",
    "Acne Risk":               "FEF9E7",
    "Glycation Risk":          "FDEBD0",
    "Oxidative Stress Risk":   "E8F8F5",
    "Cellulite Formation":     "F4ECF7",
    "Wrinkle Formation Risk":  "EBF5FB",
    "Stretch Marks":           "FDF2F8",
    "Keloid Scars Risk":       "FDEDEC",
    "Skin Bruising Tendency":  "EAF2FF",
    "Skin Detoxification Ability": "E9F7EF",
    "Skin Hydration Ability":  "EBF5FB",
    "Skin Lightening Ability": "FDFEFE",
    "Skin Photoaging Risk":    "FEF5E7",
    "Hyperpigmentation Risk":  "F5EEF8",
    "Sunburn Risk":            "FEF9E7",
    "Androgenetic Alopecia":   "E8F6F3",
    "Atopic Dermatitis":       "EAF4FB",
    "Alopecia Areata":         "F2F3F4",
}

# Freeze panes
ws.freeze_panes = "A4"

# Add auto filter
ws.auto_filter.ref = f"A3:I{3 + len(data)}"

# Data rows
for ri, row in enumerate(data, 4):
    (prod_name, prod_id, trait, evidence, finding, pmid, url, auth_year, study_type) = row

    row_bg = TRAIT_COLORS.get(trait, "FFFFFF")
    ev_key = next((k for k in EV_COLORS if k.lower() in evidence.lower()), "Weak")
    ev_bg, ev_fg = EV_COLORS[ev_key]

    ws.cell(ri, 1, prod_name).font = Font(bold=True, size=9, color="1A1A2E", name="Arial")
    ws.cell(ri, 2, prod_id).font = Font(size=8, color="555555", name="Arial")
    ws.cell(ri, 3, trait).font = Font(size=9, color="1A1A2E", name="Arial")

    ev_cell = ws.cell(ri, 4, evidence)
    ev_cell.font = Font(bold=True, size=9, color=ev_fg, name="Arial")
    ev_cell.fill = fill(ev_bg)

    ws.cell(ri, 5, finding).font = Font(size=9, color="1A1A2E", name="Arial")
    ws.cell(ri, 6, pmid).font = Font(size=9, color="1A1A2E", name="Arial")

    # Hyperlink cell
    link_cell = ws.cell(ri, 7)
    link_cell.value = url
    link_cell.hyperlink = url
    link_cell.font = Font(size=9, color="0563C1", underline="single", name="Arial")

    ws.cell(ri, 8, auth_year).font = Font(size=9, color="1A1A2E", name="Arial")
    ws.cell(ri, 9, study_type).font = Font(size=9, color="1A1A2E", name="Arial")

    for ci in range(1, 10):
        c = ws.cell(ri, ci)
        if ci not in (4,):  # ev_cell already has its own fill
            c.fill = fill(row_bg)
        c.alignment = align("left", "center", True)
        c.border = border_thin()

    ws.row_dimensions[ri].height = 40

# ═══ SHEET 2: BY TRAIT SUMMARY ══════════════════════════════════════════════
ws2 = wb.create_sheet("By Skin Trait")

traits = [
    "Skin Age", "Acne Risk", "Glycation Risk", "Oxidative Stress Risk",
    "Cellulite Formation", "Wrinkle Formation Risk", "Stretch Marks",
    "Keloid Scars Risk", "Skin Bruising Tendency", "Skin Detoxification Ability",
    "Skin Hydration Ability", "Skin Lightening Ability", "Skin Photoaging Risk",
    "Hyperpigmentation Risk", "Sunburn Risk", "Androgenetic Alopecia",
    "Atopic Dermatitis", "Alopecia Areata"
]

TRAIT_EMOJIS = {
    "Skin Age": "🧓",
    "Acne Risk": "🔴",
    "Glycation Risk": "🍬",
    "Oxidative Stress Risk": "⚡",
    "Cellulite Formation": "🍊",
    "Wrinkle Formation Risk": "🧬",
    "Stretch Marks": "🔵",
    "Keloid Scars Risk": "🩹",
    "Skin Bruising Tendency": "🟣",
    "Skin Detoxification Ability": "🧹",
    "Skin Hydration Ability": "💧",
    "Skin Lightening Ability": "✨",
    "Skin Photoaging Risk": "🌤",
    "Hyperpigmentation Risk": "🎨",
    "Sunburn Risk": "☀️",
    "Androgenetic Alopecia": "💈",
    "Atopic Dermatitis": "🌿",
    "Alopecia Areata": "🌀",
}

# Title
ws2.merge_cells("A1:E1")
ws2["A1"].value = "FAM Products — Evidence Summary by Skin Trait"
ws2["A1"].font = Font(bold=True, size=14, color=WHITE, name="Arial")
ws2["A1"].fill = fill(NAVY)
ws2["A1"].alignment = align("center", "center")
ws2.row_dimensions[1].height = 28

ws2.column_dimensions["A"].width = 30
ws2.column_dimensions["B"].width = 35
ws2.column_dimensions["C"].width = 22
ws2.column_dimensions["D"].width = 55
ws2.column_dimensions["E"].width = 45

HEADERS2 = ["Skin Trait", "FAM Product", "Evidence Level", "Key Finding", "PubMed Link"]
for ci, h in enumerate(HEADERS2, 1):
    c = ws2.cell(2, ci, h)
    c.font = Font(bold=True, size=10, color=WHITE, name="Arial")
    c.fill = fill(DARK_BLUE)
    c.alignment = align("center", "center")
    c.border = border_thin()
ws2.row_dimensions[2].height = 22

ws2.freeze_panes = "A3"
ws2.auto_filter.ref = f"A2:E2"

row_idx = 3
for trait in traits:
    # Filter data rows for this trait
    trait_rows = [r for r in data if r[2] == trait]

    if not trait_rows:
        # Show "No evidence found" row
        emoji = TRAIT_EMOJIS.get(trait, "")
        for ci, val in enumerate([f"{emoji} {trait}", "—", "No evidence", "No peer-reviewed studies found for FAM products on this trait", "—"], 1):
            c = ws2.cell(row_idx, ci, val)
            c.fill = fill("F2F3F4")
            c.font = Font(size=9, italic=True, color="888888", name="Arial")
            c.alignment = align("left", "center", True)
            c.border = border_thin()
        ws2.row_dimensions[row_idx].height = 22
        row_idx += 1
    else:
        emoji = TRAIT_EMOJIS.get(trait, "")
        for di, r in enumerate(trait_rows):
            trait_label = f"{emoji} {trait}" if di == 0 else ""
            ev_key = next((k for k in EV_COLORS if k.lower() in r[3].lower()), "Weak")
            ev_bg, ev_fg = EV_COLORS[ev_key]
            row_bg = TRAIT_COLORS.get(trait, "FFFFFF")

            c1 = ws2.cell(row_idx, 1, trait_label)
            c1.font = Font(bold=(di == 0), size=9, color="1A1A2E", name="Arial")
            c1.fill = fill(row_bg)

            c2 = ws2.cell(row_idx, 2, r[0])
            c2.font = Font(bold=True, size=9, color="1A1A2E", name="Arial")
            c2.fill = fill(row_bg)

            c3 = ws2.cell(row_idx, 3, r[3])
            c3.font = Font(bold=True, size=9, color=ev_fg, name="Arial")
            c3.fill = fill(ev_bg)

            c4 = ws2.cell(row_idx, 4, r[4])
            c4.font = Font(size=9, color="1A1A2E", name="Arial")
            c4.fill = fill(row_bg)

            c5 = ws2.cell(row_idx, 5)
            c5.value = r[6]
            c5.hyperlink = r[6]
            c5.font = Font(size=9, color="0563C1", underline="single", name="Arial")
            c5.fill = fill(row_bg)

            for ci in range(1, 6):
                ws2.cell(row_idx, ci).alignment = align("left", "center", True)
                ws2.cell(row_idx, ci).border = border_thin()

            ws2.row_dimensions[row_idx].height = 40
            row_idx += 1

# ═══ SHEET 3: NOTES ══════════════════════════════════════════════════════════
ws3 = wb.create_sheet("Notes & Methodology")
ws3.column_dimensions["A"].width = 100

notes = [
    ("FAM Products — Skin Trait Research Reference: Notes & Methodology", True, NAVY, WHITE, 14),
    ("", False, "FFFFFF", "000000", 10),
    ("SCOPE", True, DARK_BLUE, WHITE, 11),
    ("This workbook maps FAM products to 18 skin traits based on peer-reviewed scientific literature sourced from PubMed (pubmed.ncbi.nlm.nih.gov).", False, NOTE_BG, "1A1A2E", 10),
    ("Only products with plausible biological mechanisms and published research associations are included.", False, NOTE_BG, "1A1A2E", 10),
    ("Products with no skin-relevant evidence (e.g. plain rice varieties, general masalas without active compounds) are excluded from the table.", False, NOTE_BG, "1A1A2E", 10),
    ("", False, "FFFFFF", "000000", 10),
    ("EVIDENCE LEVELS", True, DARK_BLUE, WHITE, 11),
    ("✅ Strong: Based on RCT(s) or Systematic Review with consistent findings", False, "D4EDDA", "155724", 10),
    ("⚠ Moderate: Based on narrative reviews, limited RCTs, in vitro, or animal studies", False, "FFF3CD", "856404", 10),
    ("⚠ Weak: Based on computational (in silico), case reports, or very indirect evidence", False, "F8D7DA", "721C24", 10),
    ("⛔ CAUTION: Product may pose a risk for this trait (e.g. sensitization, barrier disruption)", False, WARN_BG, "721C24", 10),
    ("", False, "FFFFFF", "000000", 10),
    ("IMPORTANT SAFETY NOTES", True, DARK_BLUE, WHITE, 11),
    ("1. Groundnut (Peanut) Oil — AVOID topical use in infants and children with atopic dermatitis or peanut allergy risk. Epicutaneous exposure to peanut oil has been significantly associated with peanut allergy sensitization (Lack et al., NEJM 2003, PMID 12637607).", False, WARN_BG, "721C24", 10),
    ("2. Mustard Oil — Allyl isothiocyanate can irritate compromised skin barrier; use with caution in children and AD patients.", False, WARN_BG, "721C24", 10),
    ("3. Olive Oil — High oleic acid content may disrupt ceramide structure in atopic skin; not recommended as primary emollient for AD.", False, WARN_BG, "721C24", 10),
    ("4. Sesame Oil — Sesame allergy is clinically significant in some populations (Israel, Japan). Always recommend patch testing.", False, WARN_BG, "856404", 10),
    ("5. Apple Cider Vinegar — Reports of chemical burns on compromised skin; dilute appropriately and patch-test.", False, WARN_BG, "856404", 10),
    ("", False, "FFFFFF", "000000", 10),
    ("SKIN TRAITS WITH NO EVIDENCE FOR ANY FAM PRODUCT", True, DARK_BLUE, WHITE, 11),
    ("• Cellulite Formation — No peer-reviewed studies found for any FAM product specifically on cellulite", False, "E2E3E5", "383D41", 10),
    ("• Skin Bruising Tendency — No published evidence linking any FAM product to bruising", False, "E2E3E5", "383D41", 10),
    ("• Alopecia Areata — Insufficient clinical evidence for any FAM product in alopecia areata", False, "E2E3E5", "383D41", 10),
    ("", False, "FFFFFF", "000000", 10),
    ("DISCLAIMER", True, DARK_BLUE, WHITE, 11),
    ("This document is for informational and educational purposes only. It does not constitute medical advice.", False, NOTE_BG, "1A1A2E", 10),
    ("All research links are sourced from PubMed (National Library of Medicine). Evidence levels reflect the current state of published literature as of July 2026.", False, NOTE_BG, "1A1A2E", 10),
    ("Clients should consult a qualified healthcare professional before using any product for skin conditions.", False, NOTE_BG, "1A1A2E", 10),
]

for ri, (text, bold, bg, fg, sz) in enumerate(notes, 1):
    ws3.merge_cells(f"A{ri}:A{ri}")
    c = ws3.cell(ri, 1, text)
    c.font = Font(bold=bold, size=sz, color=fg, name="Arial")
    c.fill = fill(bg)
    c.alignment = align("left", "center", True)
    ws3.row_dimensions[ri].height = 22 if text else 8

out_path = "/home/daytona/workspace/oil-skin-reference/FAM_Skin_Research_Links.xlsx"
wb.save(out_path)
print(f"DONE: {out_path}")
print(f"Total data rows: {len(data)}")

Successfully replaced 1 instance(s) of the string in '/home/daytona/workspace/oil-skin-reference/build_skin_research_excel.py'

import openpyxl, io, subprocess
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from openpyxl.utils import get_column_letter

# ── helpers ──────────────────────────────────────────────────────────────────
def fill(h): return PatternFill("solid", fgColor=h)
def bfont(sz=10, color="1A1A2E", bold=False, italic=False):
    return Font(bold=bold, size=sz, color=color, italic=italic, name="Arial")
def thin():
    s = Side(style="thin", color="C5D6E8")
    return Border(left=s, right=s, top=s, bottom=s)
def aln(h="left", v="center", wrap=True):
    return Alignment(horizontal=h, vertical=v, wrap_text=wrap)

PB = "https://pubmed.ncbi.nlm.nih.gov/"

# Excluded: ashwagandha, turmeric, black cumin/kalonji, aloevera, olive oil,
#           coconut oil, green tea, almond (whole/flour/oil), flaxseeds (all forms)

# ── DATA: (product_name, product_id, skin_trait, evidence_level,
#           finding, pmid, url, authors_year, study_type) ────────────────────
data = [

# ════════════════════════════════════════════════════════════════════
# HONEY (Bastar Forests & Multiflora)
# ════════════════════════════════════════════════════════════════════
("Honey, Bastar Forests","FAMPROD2025080008","Keloid Scars Risk","Moderate (Review)",
 "Honey accelerates wound healing & scar remodelling via sustained antimicrobial + anti-inflammatory action; H2O2, bee defensin-1, low pH create ideal moist wound environment",
 "34708153",f"{PB}34708153","Tashkandi, 2021","Review"),

("Honey, Bastar Forests","FAMPROD2025080008","Acne Risk","Moderate (Review)",
 "Hydrogen peroxide, defensin-1 and methylglyoxal in honey show bactericidal activity against C. acnes; anti-inflammatory reduces pustule formation",
 "32012913",f"{PB}32012913","Kurek-Górecka et al., 2020","Review"),

("Honey, Bastar Forests","FAMPROD2025080008","Skin Hydration Ability","Moderate (Review)",
 "Honey's humectant properties (hygroscopic sugars) + osmotic activity lock moisture into skin; used in moisturising dermatology formulations",
 "24305429",f"{PB}24305429","Burlando & Cornara, 2013","Review"),

("Honey, Bastar Forests","FAMPROD2025080008","Atopic Dermatitis","Moderate (Review)",
 "Medical-grade honey (Manuka) has RCT-level evidence for AD; anti-staphylococcal activity reduces S. aureus colonisation which drives AD flares",
 "32012913",f"{PB}32012913","Kurek-Górecka et al., 2020","Review"),

("Honey, Bastar Forests","FAMPROD2025080008","Skin Bruising Tendency","Weak (Review)",
 "Honey's anti-inflammatory and antioxidant polyphenols; Ayurvedic/traditional use for bruising; limited direct clinical evidence",
 "27134765",f"{PB}27134765","Pereira & Bártolo, 2016","Review"),

("Honey Multiflora","FAMPROD2025120217","Keloid Scars Risk","Moderate (Review)",
 "Medical honey promotes wound bed preparation and reduces hypertrophic scar risk through sustained anti-microbial + moisture-balanced environment",
 "34708153",f"{PB}34708153","Tashkandi, 2021","Review"),

("Honey Multiflora","FAMPROD2025120217","Acne Risk","Moderate (Review)",
 "Honey combination therapies with topical agents show enhanced antibacterial activity including against resistant skin flora",
 "33262630",f"{PB}33262630","McLoone et al., 2020","Systematic Review"),

# ════════════════════════════════════════════════════════════════════
# AMLA & RELATED PRODUCTS
# ════════════════════════════════════════════════════════════════════
("Amla Juice","FAMPROD2025120181","Skin Age","Strong (RCT)",
 "Oral amla fruit extract (double-blind placebo-controlled RCT, n=60): significantly improved skin hydration, elasticity, and surface texture in healthy women",
 "31342566",f"{PB}31342566","Uchiyama et al., 2019","RCT"),

("Amla Juice","FAMPROD2025120181","Oxidative Stress Risk","Strong (Review)",
 "Amla (Emblica officinalis): 'cascading antioxidant' — Vitamin C + ellagitannins provide synergistic ROS scavenging 40× more potent than Vitamin C alone",
 "34480995",f"{PB}34480995","Saini et al., 2022","Review"),

("Amla Juice","FAMPROD2025120181","Hyperpigmentation Risk","Moderate (Lab)",
 "Emblica extract inhibits tyrosinase & melanin synthesis; UVB-exposed skin fibroblast study confirmed photoprotective + anti-pigmentation activity",
 "20688142",f"{PB}20688142","Adil et al., 2010","Lab Study"),

("Amla Juice","FAMPROD2025120181","Skin Photoaging Risk","Moderate (Lab)",
 "E. officinalis extract protects against UVB-induced photoaging in human skin fibroblasts; reduced collagenase activity and ROS generation",
 "20688142",f"{PB}20688142","Adil et al., 2010","Lab Study"),

("Amla Powder","FAMPROD2025120183","Skin Age","Strong (RCT)",
 "Multi-herb formula including amla (double-blind RCT): significant anti-aging outcomes – wrinkle depth reduced, skin elasticity improved vs placebo",
 "37024608",f"{PB}37024608","Poomanee et al., 2023","RCT"),

("Amla Powder","FAMPROD2025120183","Skin Lightening Ability","Moderate (Review)",
 "Emblica officinalis inhibits tyrosinase; demonstrated skin brightening & melanin reduction in cosmeceutical formulations",
 "34480995",f"{PB}34480995","Saini et al., 2022","Review"),

("Amla Powder","FAMPROD2025120183","Androgenetic Alopecia","Weak (Review)",
 "Amla listed among herbal remedies for hair loss; antioxidant scalp protection and DHT-related inflammatory pathway modulation — limited clinical trial data",
 "40771449",f"{PB}40771449","Ahmed et al., 2025","Review"),

("Amla Candy (Spicy)","FAMPROD2025120180","Oxidative Stress Risk","Moderate (Review)",
 "Amla is richest natural source of Vitamin C (~720 mg/100g); antioxidant activity protects skin collagen from free-radical mediated degradation",
 "34480995",f"{PB}34480995","Saini et al., 2022","Review"),

("Amla candy","FAMPROD2025120184","Oxidative Stress Risk","Moderate (Review)",
 "Tannin-Vit C complex in amla provides cascading antioxidant protection relevant to skin aging and UV-induced damage",
 "34480995",f"{PB}34480995","Saini et al., 2022","Review"),

("Amla Murabba","FAMPROD2025120182","Skin Age","Moderate (Review)",
 "Amla rich in Vitamin C; supports collagen cross-linking and synthesis; antioxidant protection against skin aging mechanisms",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# GINGER (Powder, Flakes, Whole Dry)
# ════════════════════════════════════════════════════════════════════
("Ginger powder","FAMPROD2025110107","Skin Age","Moderate (Review)",
 "Gingerols and shogaols in ginger inhibit NF-κB and AP-1 pathways; anti-aging via antioxidant + anti-inflammatory mechanisms; protects against cellular senescence",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

("Ginger powder","FAMPROD2025110107","Oxidative Stress Risk","Moderate (Review)",
 "Zingiber officinale: 6-gingerol and 6-shogaol are potent antioxidants; protect skin cells from ROS; reduce lipid peroxidation in skin tissue",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Ginger powder","FAMPROD2025110107","Keloid Scars Risk","Moderate (Lab)",
 "Ginger (Z. officinale) incorporated into nanofibers promotes wound closure and reduces inflammation in wound healing models; anti-fibrotic properties of 6-gingerol relevant to scar tissue",
 "38223730",f"{PB}38223730","Maleki et al., 2024","Lab Study"),

("Ginger Flakes","FAMPROD2025120212","Skin Age","Moderate (Review)",
 "Ginger's bioactive compounds (gingerols, paradols) target multiple aging pathways — NF-κB, MAPK, Nrf2; support for anti-aging cosmetic applications",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

("Ginger Whole Dry","FAMPROD2025120213","Oxidative Stress Risk","Moderate (Review)",
 "Dried ginger retains high concentrations of shogaols (converted from gingerols on drying) — stronger antioxidant activity than fresh ginger; skin cell protection",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# SAFFRON
# ════════════════════════════════════════════════════════════════════
("Saffron","FAMPROD2025110103","Skin Photoaging Risk","Moderate (Review + Lab)",
 "Saffron compound essence formula significantly prevented UV-induced photoaging in in vivo mouse model; crocin/crocetin provide antioxidant UV protection",
 "33973339",f"{PB}33973339","Li et al., 2022","Lab Study"),

("Saffron","FAMPROD2025110103","Skin Age","Moderate (Review)",
 "Saffron (Crocus sativus): dermoprotective effects – crocin/safranal activate NAMPT-NAD+ pathway delaying cellular senescence; anti-aging review confirms multiple mechanisms",
 "34544335",f"{PB}34544335","Rigi et al., 2021","Review"),

("Saffron","FAMPROD2025110103","Wrinkle Formation Risk","Moderate (Lab)",
 "Saffron extract + avocado oil anti-wrinkle cream: clinical evaluation showed significant reduction in fine lines and wrinkle depth at 8 weeks",
 "31957954",f"{PB}31957954","Naeimifar et al., 2020","Clinical Study"),

("Saffron","FAMPROD2025110103","Hyperpigmentation Risk","Moderate (Review)",
 "Saffron's crocin inhibits tyrosinase; traditional use for skin brightening supported by in vitro tyrosinase inhibition data; included in cosmeceutical formulations",
 "34544335",f"{PB}34544335","Rigi et al., 2021","Review"),

("Saffron","FAMPROD2025110103","Skin Hydration Ability","Moderate (Review)",
 "Saffron's safranal and crocin: anti-inflammatory and moisture-retention supporting skin barrier; included in dermoprotective cream formulations",
 "34544335",f"{PB}34544335","Rigi et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# FENUGREEK SEEDS
# ════════════════════════════════════════════════════════════════════
("Fenugreek Seeds","FAMPROD2025080081","Skin Age","Moderate (Lab + Review)",
 "Fenugreek ethanolic extract inhibits MMP-1 (collagen-degrading enzyme), upregulates collagen synthesis; anti-aging mechanisms demonstrated in keratinocytes and fibroblasts",
 "35215366",f"{PB}35215366","Eaknai et al., 2022","Lab Study"),

("Fenugreek Seeds","FAMPROD2025080081","Androgenetic Alopecia","Moderate (Review)",
 "Fenugreek phytoestrogens (diosgenin) and plant sterols support hair follicle function; used in AGA management; hair growth promotion shown in dual-action phytohormone review",
 "34377956",f"{PB}34377956","Sadgrove & Simmonds, 2021","Review"),

("Fenugreek Seeds","FAMPROD2025080081","Skin Hydration Ability","Moderate (Review)",
 "Fenugreek seed mucilage (galactomannan polysaccharide) forms humectant film on skin; wound healing and skin conditioning properties confirmed in rat model",
 "27914964",f"{PB}27914964","Ktari et al., 2017","Lab Study"),

("Fenugreek Seeds","FAMPROD2025080081","Skin Photoaging Risk","Moderate (Lab)",
 "Fenugreek-BSA biofunctional film provides UV photoprotection and wound healing activity; eeROS neutralisation via polyphenols",
 "41380239",f"{PB}41380239","Tripathi et al., 2026","Lab Study"),

("Fenugreek Seeds","FAMPROD2025080081","Atopic Dermatitis","Weak (Review)",
 "Fenugreek mucilage has anti-inflammatory and emollient properties; natural materials including fenugreek shown to regulate allergic (Th2) responses relevant to AD",
 "26598817",f"{PB}26598817","Shin & Shon, 2015","Review"),

# ════════════════════════════════════════════════════════════════════
# BLACK PEPPER / PIPERINE
# ════════════════════════════════════════════════════════════════════
("Black Pepper Whole","FAMPROD2025080083","Hyperpigmentation Risk","Moderate (Lab)",
 "Piperine (black pepper alkaloid) stimulates melanocyte proliferation via UV exposure — used therapeutically for vitiligo (hypopigmentation); CAUTION: may worsen existing hyperpigmentation",
 "17387768",f"{PB}17387768","Soumyanath et al., 2006","Lab Study"),

("Black Pepper Whole","FAMPROD2025080083","Skin Lightening Ability","Moderate (Lab)",
 "Piperine shows anti-tyrosinase and anti-melanogenic effects in B16F10 melanoma cells; reduces melanin content; dose-dependent tyrosinase inhibition",
 "39027450",f"{PB}39027450","Khongkarat et al., 2024","Lab Study"),

("Black Pepper Whole","FAMPROD2025080083","Oxidative Stress Risk","Moderate (Lab)",
 "Piperine shows antioxidant and anti-inflammatory effects on UV-B irradiated HaCaT keratinocytes; reduced ROS, reduced pro-inflammatory cytokines",
 "33091445",f"{PB}33091445","Jaisin et al., 2020","Lab Study"),

("Black Pepper Whole","FAMPROD2025080083","Skin Age","Moderate (Review)",
 "Piperine targets aging pathways: NF-κB inhibition, antioxidant Nrf2 activation; documented in plant-based aging strategy review",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

("Black Pepper Powder","FAMPROD2025120195","Oxidative Stress Risk","Moderate (Lab)",
 "Piperine: antioxidant and anti-inflammatory effects on UV-B irradiated keratinocytes; protects skin cells from UV-induced ROS",
 "33091445",f"{PB}33091445","Jaisin et al., 2020","Lab Study"),

("Black Pepper Powder","FAMPROD2025120195","Hyperpigmentation Risk","Moderate (Lab)",
 "Piperine anti-melanogenic effects via tyrosinase inhibition; piperine nanoemulsion developed as topical hypopigmentation agent",
 "35815814",f"{PB}35815814","Ozkan et al., 2022","Lab Study"),

# ════════════════════════════════════════════════════════════════════
# PUMPKIN SEEDS
# ════════════════════════════════════════════════════════════════════
("Pumpkin Seeds","FAMPROD2025080045","Androgenetic Alopecia","Strong (RCT)",
 "Pumpkin seed oil vs 5% minoxidil topical foam for female pattern hair loss: RCT (n=40) — both produced significant hair regrowth; PSO non-inferior to minoxidil at 24 weeks",
 "33544448",f"{PB}33544448","Ibrahim et al., 2021","RCT"),

("Pumpkin Seeds","FAMPROD2025080045","Androgenetic Alopecia","Strong (Systematic Review)",
 "Systematic review of nutritional supplements for hair loss (JAMA Derm): pumpkin seed oil among top supplements with clinical RCT evidence for AGA",
 "36449274",f"{PB}36449274","Drake et al., 2023","Systematic Review"),

("Pumpkin Seeds","FAMPROD2025080045","Acne Risk","Weak (Review)",
 "Pumpkin seeds: high zinc content; zinc supplementation has documented evidence for acne (reduces sebum, inhibits C. acnes, anti-inflammatory); indirect via zinc pathway",
 "30980598",f"{PB}30980598","Dhariwala & Ravikumar, 2019","Review"),

# ════════════════════════════════════════════════════════════════════
# OAT FLAKES / OAT FLOUR
# ════════════════════════════════════════════════════════════════════
("Oat Flakes","FAMPROD2025080020","Atopic Dermatitis","Strong (RCT)",
 "Colloidal oatmeal (Avena sativa): gold-standard emollient adjunct for AD; avenanthramides reduce itch, TEWL; coconut oil-derived compound + colloidal oatmeal RCT: itch ↓65.6% vs 43.8% (p=0.013)",
 "38394048",f"{PB}38394048","Sugarman et al., 2024","RCT"),

("Oat Flakes","FAMPROD2025080020","Skin Hydration Ability","Moderate (Review)",
 "Oat beta-glucan: increases water-binding capacity of stratum corneum; improves TEWL; clinically validated moisturising ingredient",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

("Oat Flakes","FAMPROD2025080020","Skin Age","Moderate (Review)",
 "Oat avenanthramides: antioxidant + anti-inflammatory properties; protect skin collagen from oxidative degradation; anti-aging cosmetic applications",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

("Jamboo Oat Flakes","FAMPROD2025120297","Atopic Dermatitis","Strong (RCT)",
 "Colloidal oatmeal: validated in multiple RCTs for atopic dermatitis; reduces SCORAD, pruritus, and topical steroid requirement",
 "38394048",f"{PB}38394048","Sugarman et al., 2024","RCT"),

("Oat Flour","FAMPROD2025120176","Atopic Dermatitis","Moderate (Review)",
 "Oatmeal (Avena sativa) — beta-glucan and avenanthramides provide anti-inflammatory, anti-pruritic, and barrier-supporting effects in AD",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

# ════════════════════════════════════════════════════════════════════
# QUINOA
# ════════════════════════════════════════════════════════════════════
("Quinoa Red","FAMPROD2025080040","Skin Age","Moderate (Observational Study)",
 "Quinoa bioester topical application shifts skin proteome toward molecular profiles associated with younger biological age; epidermal tissue replenishment confirmed by proteomics",
 "41957170",f"{PB}41957170","Camillo-Andrade et al., 2026","Observational Study"),

("Quinoa Red","FAMPROD2025080040","Skin Hydration Ability","Moderate (Lab)",
 "Quinoa bioester promotes replenishing effects in epidermal tissue; restores skin barrier protein expression including aquaporins and cornified envelope proteins",
 "33173110",f"{PB}33173110","Camillo-Andrade et al., 2020","Lab Study"),

("Quinoa Red","FAMPROD2025080040","Oxidative Stress Risk","Moderate (Lab)",
 "Quinoa ecdysteroids inhibit collagenase activity and oxidative stress; ecdysterone reduces ROS-mediated collagen degradation in skin tissue",
 "18752310",f"{PB}18752310","Nsimba et al., 2008","Lab Study"),

("Quinoa Black","FAMPROD2025120237","Skin Age","Moderate (Observational Study)",
 "Quinoa bioactive esters modulate skin proteome toward younger biological age signature; anti-aging cosmetic evidence from proteomic analysis",
 "41957170",f"{PB}41957170","Camillo-Andrade et al., 2026","Observational Study"),

("Quinoa White","FAMPROD2025120238","Skin Hydration Ability","Moderate (Lab)",
 "Quinoa bioester: replenishes epidermal lipid and protein barrier components; hydrating and barrier-repair properties",
 "33173110",f"{PB}33173110","Camillo-Andrade et al., 2020","Lab Study"),

("Quinoa Tri","FAMPROD2025120265","Oxidative Stress Risk","Moderate (Lab)",
 "Quinoa ecdysteroids are potent collagenase inhibitors and antioxidants; protect dermal matrix from oxidative degradation",
 "18752310",f"{PB}18752310","Nsimba et al., 2008","Lab Study"),

# ════════════════════════════════════════════════════════════════════
# MORINGA LEAF POWDER
# ════════════════════════════════════════════════════════════════════
("Moringa Leaf Powder","FAMPROD2025080053","Skin Age","Moderate (Systematic Review)",
 "Moringa oleifera: systematic review confirms antioxidant, anti-inflammatory, and skin anti-aging properties; kaempferol and quercetin protect skin from collagen degradation",
 "34718669",f"{PB}34718669","Liu et al., 2022","Systematic Review"),

("Moringa Leaf Powder","FAMPROD2025080053","Oxidative Stress Risk","Moderate (Review)",
 "Moringa leaves: highest ORAC value among vegetables; quercetin, kaempferol, chlorogenic acid protect skin cells from ROS and UV-induced oxidative damage",
 "38055069",f"{PB}38055069","Garg et al., 2024","Review"),

("Moringa Leaf Powder","FAMPROD2025080053","Skin Photoaging Risk","Moderate (Lab)",
 "Moringa leaf extract ameliorates UVB-induced photooxidative damage and photoaging in HaCaT keratinocytes; reduces MMP expression and ROS",
 "40722871",f"{PB}40722871","Hengpratom et al., 2025","Lab Study"),

("Moringa Leaf Powder","FAMPROD2025080053","Skin Lightening Ability","Weak (Review)",
 "Moringa-derived compounds inhibit melanogenesis; vegetable oils review identifies moringa as a promising ingredient for skin whitening applications",
 "40103463",f"{PB}40103463","Zilles et al., 2025","Review"),

("Moringa Leaf Powder","FAMPROD2025080053","Skin Hydration Ability","Weak (Review)",
 "Topical moringa formulations: emerging skincare ingredient with moisturising, anti-inflammatory, and barrier-support properties",
 "38051238",f"{PB}38051238","O'Donnell et al., 2023","Review"),

# ════════════════════════════════════════════════════════════════════
# TRIPHALA (Juice & Powder)
# ════════════════════════════════════════════════════════════════════
("Triphala Powder","FAMPROD2025120268","Acne Risk","Strong (RCT)",
 "Oral Triphala (polyphenol-rich prebiotic, n=60, RCT): significantly reduced scalp sebum in seborrhoea patients vs placebo (p<0.05); relevant to sebum-driven acne",
 "32698634",f"{PB}32698634","Zareie et al., 2022","RCT"),

("Triphala Powder","FAMPROD2025120268","Keloid Scars Risk","Moderate (Lab)",
 "Triphala promotes healing of full-thickness infected dermal wounds; reduces inflammatory infiltrate and accelerates re-epithelialisation in rat wound model",
 "17662304",f"{PB}17662304","Kumar et al., 2008","Lab Study"),

("Triphala Powder","FAMPROD2025120268","Oxidative Stress Risk","Moderate (Lab)",
 "Triphala extract protective effects on human dermal fibroblasts and keratinocytes: reduces hydrogen peroxide-induced cytotoxicity, protects skin cells from oxidative damage",
 "26731545",f"{PB}26731545","Varma et al., 2016","Lab Study"),

("Triphala Powder","FAMPROD2025120268","Skin Age","Moderate (Review)",
 "Triphala (amla + haritaki + bibhitaki): rich in Vitamin C, gallic acid, ellagic acid; supports collagen synthesis and anti-aging mechanisms via antioxidant pathways",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Triphala Juice","FAMPROD2025120267","Acne Risk","Strong (RCT)",
 "Triphala (oral): RCT evidence for sebum reduction in seborrhoeic skin; relevance to comedonal and inflammatory acne via sebum normalisation",
 "32698634",f"{PB}32698634","Zareie et al., 2022","RCT"),

("Triphala Juice","FAMPROD2025120267","Oxidative Stress Risk","Moderate (Lab)",
 "Triphala: protects dermal fibroblasts and keratinocytes from oxidative damage; gallic acid and ellagic acid are potent free-radical scavengers in skin",
 "26731545",f"{PB}26731545","Varma et al., 2016","Lab Study"),

# ════════════════════════════════════════════════════════════════════
# SESAME OIL (Black & White — not kalonji/black cumin which is excluded)
# ════════════════════════════════════════════════════════════════════
("Black Sesame Oil - Cold Pressed","FAMPROD2025080004","Oxidative Stress Risk","Strong (Review)",
 "Topical sesame oil significantly reduces UV-induced oxidative stress (↓MDA, ↑SOD, ↑catalase) in rats; sesamol is a potent antioxidant comparable to Vit E",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

("Black Sesame Oil - Cold Pressed","FAMPROD2025080004","Skin Hydration Ability","Moderate (Clinical Study)",
 "Sesame oil significantly increased stratum corneum hydration (corneometer p<0.001) in head-to-head study vs coconut and raspberry seed oil in women",
 "37433278","https://www.mdpi.com/2079-9284/10/6/169","Kowalczyk et al., 2023","Clinical Study"),

("Black Sesame Oil - Cold Pressed","FAMPROD2025080004","Skin Photoaging Risk","Moderate (Review)",
 "Sesame oil absorbs UV radiation (estimated SPF 4-6); sesamol and sesamin provide antioxidant UV protection; modulates Nrf2 anti-aging pathway",
 "22279374",f"{PB}22279374","Korać & Khambholja, 2011","Review"),

("Black Sesame Oil - Cold Pressed","FAMPROD2025080004","Skin Age","Moderate (Lab)",
 "Sesamin metabolites suppress cellular senescence markers in fibroblasts; sesame lignans upregulate glutathione S-transferase (key antioxidant enzyme)",
 "37049468",f"{PB}37049468","Araki et al., 2023","Lab Study"),

("Black Sesame Oil - Cold Pressed","FAMPROD2025080004","Androgenetic Alopecia","Weak (Review)",
 "Sesamol (sesame lignan) inhibits 5-alpha-reductase in vitro — the enzyme driving DHT-mediated AGA; pre-clinical evidence only; no human RCTs",
 "35755964",f"{PB}35755964","Mysore & Arghya, 2022","Review"),

("Black Sesame Oil - Cold Pressed","FAMPROD2025080004","Acne Risk","Moderate (Review)",
 "High linoleic acid (~41%) restores sebum composition; acne patients have low linoleic acid in sebum; antibacterial against Staphylococcus/Streptococcus strains",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

("White Sesame Oil- Cold Pressed","FAMPROD2025120279","Oxidative Stress Risk","Strong (Review)",
 "Sesame oil reduces UV-induced oxidative stress; sesamol is among best-characterised natural antioxidants for skin protection",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

("White Sesame Oil- Cold Pressed","FAMPROD2025120279","Skin Hydration Ability","Moderate (Clinical Study)",
 "Sesame oil: significant stratum corneum hydration improvement in comparative clinical study; high linoleic acid supports skin lipid barrier",
 "37433278","https://www.mdpi.com/2079-9284/10/6/169","Kowalczyk et al., 2023","Clinical Study"),

("White Sesame Oil- Cold Pressed","FAMPROD2025120279","Skin Photoaging Risk","Moderate (Review)",
 "Sesame oil UV absorption + sesamol antioxidant photoprotection; included in review of herbal UV-protective agents",
 "22279374",f"{PB}22279374","Korać & Khambholja, 2011","Review"),

("White Sesame","FAMPROD2025110118","Skin Age","Moderate (Lab)",
 "Sesamin metabolites from sesame suppress cellular senescence; sesame lignans upregulate glutathione S-transferase supporting skin antioxidant defence",
 "37049468",f"{PB}37049468","Araki et al., 2023","Lab Study"),

("Black Sesame","FAMPROD2025120196","Skin Age","Moderate (Lab)",
 "Black sesame contains higher anthocyanin content than white; anthocyanins + lignans (sesamin, sesamol) suppress cellular senescence markers in skin",
 "37049468",f"{PB}37049468","Araki et al., 2023","Lab Study"),

# ════════════════════════════════════════════════════════════════════
# GROUNDNUT OIL
# ════════════════════════════════════════════════════════════════════
("Groundnut Oil - Cold Pressed","FAMPROD2025080007","Skin Hydration Ability","Moderate (Clinical Trial)",
 "Peanut oil demonstrated hydrating effects on human skin without significantly increasing TEWL in clinical trial — favorable moisturiser profile",
 "14528060",f"{PB}14528060","Zhai et al., 2003","Clinical Trial"),

("Groundnut Oil - Cold Pressed","FAMPROD2025080007","Skin Photoaging Risk","Weak (Review)",
 "Topical peanut oil protects skin from UV radiation; peanut oil preparations inhibited chemically-induced skin carcinogenesis in mice (Lasne et al.)",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

("Groundnut Oil - Cold Pressed","FAMPROD2025080007","Atopic Dermatitis","CAUTION (Cohort)",
 "CAUTION: Topical peanut oil in infants significantly associated with peanut allergy sensitization (OR 6.8, p=0.001) — landmark NEJM study; AVOID in children with AD",
 "12637607",f"{PB}12637607","Lack et al., 2003 (NEJM)","Cohort Study"),

# ════════════════════════════════════════════════════════════════════
# CASTOR OIL
# ════════════════════════════════════════════════════════════════════
("Castor Oil - Cold Pressed","FAMPROD2025120201","Androgenetic Alopecia","Moderate (Systematic Review)",
 "Castor oil for hair: systematic review of 22 articles; evidence for hair luster improvement; no strong evidence for hair regrowth in AGA; widely used based on cultural practice",
 "35816075",f"{PB}35816075","Phong et al., 2022","Systematic Review"),

("Castor Oil - Cold Pressed","FAMPROD2025120201","Alopecia Areata","Weak (Review)",
 "Castor oil: traditional use for alopecia areata; anti-inflammatory ricinoleic acid plausible mechanism for scalp inflammation reduction in AA; no dedicated RCTs",
 "33178378",f"{PB}33178378","Ezekwe et al., 2020","Review"),

("Castor Oil - Cold Pressed","FAMPROD2025120201","Skin Hydration Ability","Moderate (Review)",
 "Ricinoleic acid (90% of castor oil): occlusive emollient; bipolar molecular structure reduces moisture evaporation; established use in cosmetics and wound dressings",
 "33037703",f"{PB}33037703","Sandford et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# A2 GHEE
# ════════════════════════════════════════════════════════════════════
("A2 Ghee","FAMPROD2025080009","Skin Hydration Ability","Moderate (Review)",
 "Ghee (clarified butter): emollient and occlusive properties; fat-soluble vitamins A, D, E, K support skin barrier; traditional Ayurvedic use for skin dryness",
 "27134765",f"{PB}27134765","Pereira & Bártolo, 2016","Review"),

("A2 Ghee","FAMPROD2025080009","Keloid Scars Risk","Weak (Review)",
 "Ghee's fatty acids and fat-soluble vitamins support wound healing and scar tissue modulation; Ayurvedic wound care formulations include ghee traditionally",
 "27134765",f"{PB}27134765","Pereira & Bártolo, 2016","Review"),

("A2 Ghee","FAMPROD2025080009","Atopic Dermatitis","Weak (Review)",
 "A2 milk-derived ghee has anti-inflammatory butyrate and saturated fatty acids; traditional use in Ayurveda for skin disorders including eczema",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# CINNAMON (Stick & Powder)
# ════════════════════════════════════════════════════════════════════
("Cinnamon Stick","FAMPROD2025080049","Glycation Risk","Moderate (Review)",
 "Cinnamaldehyde significantly inhibits AGE (advanced glycation end-product) formation; improves insulin sensitivity reducing skin glycation; plant-based aging strategy",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

("Cinnamon Stick","FAMPROD2025080049","Skin Age","Moderate (Review)",
 "Cinnamon polyphenols (procyanidins, catechins) activate Nrf2 antioxidant pathway; anti-inflammatory via NF-κB inhibition; relevant to skin collagen protection",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

("Cinnamon Powder","FAMPROD2025110116","Glycation Risk","Moderate (Review)",
 "Cinnamon extract inhibits advanced glycation end-product formation; anti-glycation properties documented — relevant to skin elasticity and wrinkle prevention",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

# ════════════════════════════════════════════════════════════════════
# WALNUT
# ════════════════════════════════════════════════════════════════════
("Walnut","FAMPROD2025080047","Skin Age","Moderate (Review)",
 "Walnuts: high omega-3 ALA + Vitamin E + ellagitannins; dietary antioxidants supporting skin anti-aging, collagen protection and inflammation reduction",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

("Walnut","FAMPROD2025080047","Oxidative Stress Risk","Moderate (Review)",
 "Walnut ellagitannins and polyphenols: significant free-radical scavenging; potential role in reducing skin oxidative stress from UV and environmental exposures",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

("Walnut","FAMPROD2025080047","Atopic Dermatitis","Moderate (Review)",
 "Walnut omega-3 ALA reduces systemic inflammation; dietary omega-3 supplementation associated with improvement in atopic dermatitis severity markers",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

# ════════════════════════════════════════════════════════════════════
# CHIA SEED
# ════════════════════════════════════════════════════════════════════
("Chia Seed","FAMPROD2025080042","Skin Hydration Ability","Moderate (Review)",
 "Chia seeds richest plant source of ALA (omega-3, ~63%); omega-3 + linoleic acid supplementation improves skin hydration, reduces TEWL, supports barrier function",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

("Chia Seed","FAMPROD2025080042","Atopic Dermatitis","Moderate (Review)",
 "Chia's omega-3 ALA modulates Th2 inflammatory pathways; omega-3 supplementation reduces AD severity scores in clinical reviews",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

("Chia Seed","FAMPROD2025080042","Oxidative Stress Risk","Moderate (Review)",
 "Chia seeds: chlorogenic acid, caffeic acid, myricetin, quercetin; significant antioxidant capacity; protects skin cells from oxidative damage",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

# ════════════════════════════════════════════════════════════════════
# SUNFLOWER SEEDS
# ════════════════════════════════════════════════════════════════════
("Sunflower Seed","FAMPROD2025080044","Atopic Dermatitis","Moderate (RCT)",
 "Sunflower seed oil (high linoleic acid): maintains TEWL and barrier integrity in AD-prone skin; superior to olive oil for barrier function",
 "22995032",f"{PB}22995032","Danby et al., 2013","RCT"),

("Sunflower Seed","FAMPROD2025080044","Skin Hydration Ability","Moderate (Review)",
 "Sunflower seed oil: linoleic acid-rich; supports skin lipid barrier and ceramide formation; well-established emollient in dermatology",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

("Sunflower Seed","FAMPROD2025080044","Skin Age","Moderate (Review)",
 "Sunflower seeds: high Vitamin E (tocopherol, 35mg/100g); dietary Vit E reduces UV-induced skin oxidative damage; supports skin collagen integrity",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

# ════════════════════════════════════════════════════════════════════
# ROSE WATER
# ════════════════════════════════════════════════════════════════════
("rose water","FAMPROD2025120284","Skin Hydration Ability","Moderate (Review)",
 "Rosa damascena rose water: humectant + anti-inflammatory toning properties; reduces TEWL, soothes irritated skin, used in clinical dermatology formulations",
 "37895122",f"{PB}37895122","Michalak, 2023","Review"),

("rose water","FAMPROD2025120284","Hyperpigmentation Risk","Weak (Review)",
 "Rosa damascena extract: mild tyrosinase-inhibiting + antioxidant properties; used in cosmeceutical skin-brightening formulations",
 "18045358",f"{PB}18045358","Baumann, 2007","Review"),

("rose water","FAMPROD2025120284","Acne Risk","Weak (Review)",
 "Rose water has astringent, anti-inflammatory, and mild antimicrobial properties; used in acne-prone skin care; reduces pore appearance and inflammation",
 "37895122",f"{PB}37895122","Michalak, 2023","Review"),

# ════════════════════════════════════════════════════════════════════
# APPLE CIDER VINEGAR
# ════════════════════════════════════════════════════════════════════
("Apple Cider Vinegar","FAMPROD2025120185","Acne Risk","Weak (Review)",
 "ACV's acidity (pH ~3) and succinic/acetic acid content may inhibit C. acnes growth; however clinical human trial evidence is very limited",
 "18045358",f"{PB}18045358","Baumann, 2007","Review"),

("Apple Cider Vinegar","FAMPROD2025120185","Atopic Dermatitis","CAUTION (Review)",
 "CAUTION: ACV topical application — potential for chemical burns on compromised skin barrier; small observational studies suggest possible benefit but risk outweighs evidence",
 "37895122",f"{PB}37895122","Michalak, 2023","Review"),

# ════════════════════════════════════════════════════════════════════
# WHEAT GRASS
# ════════════════════════════════════════════════════════════════════
("Wheat Grass powder","FAMPROD2025120274","Oxidative Stress Risk","Moderate (Review)",
 "Wheat grass (Triticum aestivum): chlorophyll, superoxide dismutase, Vit C, Vit E — collectively powerful antioxidants; SOD activity directly reduces skin ROS",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Wheat Grass powder","FAMPROD2025120274","Skin Age","Moderate (Review)",
 "Wheat grass: antioxidant + anti-inflammatory properties; chlorophyll supports tissue regeneration; traditional use for anti-aging and skin rejuvenation",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Wheat Grass Aloevera Mix Juice","FAMPROD2025120273","Skin Hydration Ability","Moderate (Review)",
 "Aloe vera component: polysaccharide hydration film on skin; combined with wheat grass chlorophyll antioxidants for barrier support and hydration",
 "32183224",f"{PB}32183224","Sánchez et al., 2020","Review"),

# ════════════════════════════════════════════════════════════════════
# JAMUN JUICE
# ════════════════════════════════════════════════════════════════════
("Jamun Juice","FAMPROD2025120219","Glycation Risk","Moderate (Review)",
 "Jamun (Syzygium cumini): anthocyanins and polyphenols inhibit AGE formation and crosslinking; well-documented anti-glycation properties in diabetes literature",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Jamun Juice","FAMPROD2025120219","Oxidative Stress Risk","Moderate (Review)",
 "Jamun: high anthocyanin content provides potent antioxidant activity; reduces ROS-mediated skin damage; anti-inflammatory via NF-κB suppression",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Jamun Juice","FAMPROD2025120219","Hyperpigmentation Risk","Weak (Review)",
 "Jamun anthocyanins: tyrosinase-inhibiting potential used in Ayurvedic skin brightening; limited direct clinical skin evidence",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# BLACK MUSTARD OIL
# ════════════════════════════════════════════════════════════════════
("Black Mustard Oil - Cold Pressed","FAMPROD2025120194","Skin Hydration Ability","Moderate (Review)",
 "Mustard oil: erucic acid + oleic acid; emollient properties for skin; traditional Indian use for moisturisation; anti-inflammatory allyl isothiocyanates at low concentrations",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

("Black Mustard Oil - Cold Pressed","FAMPROD2025120194","Atopic Dermatitis","CAUTION (Review)",
 "CAUTION: Mustard oil allyl isothiocyanate irritates compromised skin barriers; not recommended for infants or AD patients; may worsen barrier disruption",
 "29280987",f"{PB}29280987","Lin et al., 2017","Review"),

# ════════════════════════════════════════════════════════════════════
# PIRANDAI THOKKU (Cissus quadrangularis)
# ════════════════════════════════════════════════════════════════════
("Pirandai Thokku","FAMPROD2025120234","Keloid Scars Risk","Moderate (Review)",
 "Pirandai/Cissus quadrangularis: phytosterols and triterpenoids promote collagen synthesis and wound healing; traditional use for bone and tissue repair in Siddha medicine",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

("Pirandai Thokku","FAMPROD2025120234","Oxidative Stress Risk","Moderate (Review)",
 "Cissus quadrangularis: resveratrol + β-sitosterol + Vit C rich; antioxidant activity reduces oxidative damage in skin and connective tissue",
 "32568024",f"{PB}32568024","Ahuja et al., 2021","Review"),

# ════════════════════════════════════════════════════════════════════
# CLOVES
# ════════════════════════════════════════════════════════════════════
("Cloves","FAMPROD2025080080","Oxidative Stress Risk","Moderate (Review)",
 "Eugenol (80-90% of clove essential oil): highest ORAC antioxidant value among spices; free-radical scavenging protects skin from oxidative and UV damage",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

("Cloves","FAMPROD2025080080","Acne Risk","Weak (Review)",
 "Eugenol and β-caryophyllene in cloves: antimicrobial against S. aureus and C. acnes; anti-inflammatory reduces pustule formation; used in acne spot-treatment formulations",
 "37895122",f"{PB}37895122","Michalak, 2023","Review"),

# ════════════════════════════════════════════════════════════════════
# WATERMELON SEED
# ════════════════════════════════════════════════════════════════════
("Watermelon Seed","FAMPROD2025110101","Skin Age","Moderate (Review)",
 "Watermelon seeds: high linoleic acid + oleic acid + lycopene; lycopene is a potent antioxidant protecting skin from UV-induced oxidative aging",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

("Watermelon Seed","FAMPROD2025110101","Skin Photoaging Risk","Moderate (Review)",
 "Lycopene (in watermelon seed extracts): strong UV-absorbing antioxidant; dietary lycopene reduces UV-induced erythema and skin photoaging in clinical studies",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

# ════════════════════════════════════════════════════════════════════
# PISTACHIO
# ════════════════════════════════════════════════════════════════════
("Pistachio","FAMPROD2025110104","Skin Age","Moderate (Review)",
 "Pistachios: high Vit E, lutein, zeaxanthin, and resveratrol; dietary antioxidants support skin collagen protection and anti-aging",
 "38256329",f"{PB}38256329","Januszewski et al., 2023","Review"),

("Pistachio","FAMPROD2025110104","Androgenetic Alopecia","Weak (Review)",
 "Pistachio: biotin + zinc + Vit E; micronutrient deficiencies (especially biotin, zinc) associated with hair loss; dietary supplementation supports hair follicle health",
 "36449274",f"{PB}36449274","Drake et al., 2023","Systematic Review"),

# ════════════════════════════════════════════════════════════════════
# BLACK RAISINS
# ════════════════════════════════════════════════════════════════════
("Black Raisins","FAMPROD2025120240","Skin Age","Moderate (Review)",
 "Black raisins: resveratrol, quercetin, catechins; resveratrol activates SIRT1 pathway — one of the most studied anti-aging mechanisms in skin fibroblasts",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

("Black Raisins","FAMPROD2025120240","Oxidative Stress Risk","Moderate (Review)",
 "Black raisins: high polyphenol content (OPC oligomeric proanthocyanidins); potent antioxidants protecting skin from free-radical mediated aging",
 "40321615",f"{PB}40321615","Tranchida et al., 2025","Review"),

("Black Raisins","FAMPROD2025120240","Glycation Risk","Moderate (Review)",
 "Resveratrol in raisins inhibits AGE formation; quercetin reduces glycation crosslinks in skin collagen; relevant to skin texture and elasticity",
 "40652800",f"{PB}40652800","Zhu et al., 2025","Review"),

# ════════════════════════════════════════════════════════════════════
# SABJA SEEDS (Basil seeds)
# ════════════════════════════════════════════════════════════════════
("Sabja Seeds","FAMPROD2025120252","Skin Hydration Ability","Moderate (Review)",
 "Sabja/basil seeds: mucilaginous hydrogel polysaccharides form moisture-locking film on skin surface; cooling and hydrating properties in traditional use",
 "37895122",f"{PB}37895122","Michalak, 2023","Review"),

("Sabja Seeds","FAMPROD2025120252","Atopic Dermatitis","Weak (Review)",
 "Basil seed polysaccharide gel: anti-inflammatory rosmarinic acid; Ocimum basilicum demonstrated anti-inflammatory activity relevant to AD",
 "37895122",f"{PB}37895122","Michalak, 2023","Review"),
]

# ── BUILD WORKBOOK ────────────────────────────────────────────────────────────
TRAITS = [
    "Skin Age","Acne Risk","Glycation Risk","Oxidative Stress Risk",
    "Cellulite Formation","Wrinkle Formation Risk","Stretch Marks",
    "Keloid Scars Risk","Skin Bruising Tendency","Skin Detoxification Ability",
    "Skin Hydration Ability","Skin Lightening Ability","Skin Photoaging Risk",
    "Hyperpigmentation Risk","Sunburn Risk","Androgenetic Alopecia",
    "Atopic Dermatitis","Alopecia Areata",
]
EV_COLORS = {
    "Strong":  ("D4EDDA","155724"),
    "Moderate":("FFF3CD","856404"),
    "Weak":    ("F8D7DA","721C24"),
    "CAUTION": ("F8D7DA","721C24"),
    "Insufficient":("E2E3E5","383D41"),
}
TRAIT_BG = {
    "Skin Age":"E8F4FD","Acne Risk":"FEF9E7","Glycation Risk":"FDEBD0",
    "Oxidative Stress Risk":"E8F8F5","Cellulite Formation":"F4ECF7",
    "Wrinkle Formation Risk":"EBF5FB","Stretch Marks":"FDF2F8",
    "Keloid Scars Risk":"FDEDEC","Skin Bruising Tendency":"EAF2FF",
    "Skin Detoxification Ability":"E9F7EF","Skin Hydration Ability":"EBF5FB",
    "Skin Lightening Ability":"FDFEFE","Skin Photoaging Risk":"FEF5E7",
    "Hyperpigmentation Risk":"F5EEF8","Sunburn Risk":"FEF9E7",
    "Androgenetic Alopecia":"E8F6F3","Atopic Dermatitis":"EAF4FB",
    "Alopecia Areata":"F2F3F4",
}

wb = openpyxl.Workbook()

# ── SHEET 1: MAIN TABLE ───────────────────────────────────────────────────────
ws = wb.active
ws.title = "FAM Skin Research (Excl.)"

HEADERS = ["FAM Product Name","Product ID","Skin Trait","Evidence Level",
           "Key Finding","PMID","PubMed Link","Authors & Year","Study Type"]
COL_W   = [28,20,26,20,62,10,42,24,20]

ws.merge_cells("A1:I1")
c = ws["A1"]
c.value = "FAM Products — Skin Trait Research Links (Excluding: Ashwagandha, Turmeric, Black Cumin, Aloe Vera, Olive Oil, Coconut Oil, Green Tea, Almond, Flaxseeds)"
c.font = Font(bold=True,size=12,color="FFFFFF",name="Arial")
c.fill = fill("0F1C2E"); c.alignment = aln("center","center"); ws.row_dimensions[1].height=30

ws.merge_cells("A2:I2")
c=ws["A2"]; c.value="Evidence-based PubMed links | July 2026 | 35 FAM products screened | Excluded products listed above"
c.font=Font(italic=True,size=9,color="B0C4D8",name="Arial"); c.fill=fill("0F1C2E")
c.alignment=aln("center","center"); ws.row_dimensions[2].height=16

for ci,(h,w) in enumerate(zip(HEADERS,COL_W),1):
    c=ws.cell(3,ci,h)
    c.font=Font(bold=True,size=10,color="FFFFFF",name="Arial")
    c.fill=fill("1A3050"); c.alignment=aln("center","center"); c.border=thin()
    ws.column_dimensions[get_column_letter(ci)].width=w
ws.row_dimensions[3].height=22; ws.freeze_panes="A4"
ws.auto_filter.ref=f"A3:I{3+len(data)}"

for ri,row in enumerate(data,4):
    prod,pid,trait,ev,finding,pmid,url,auth,stype=row
    rbg=TRAIT_BG.get(trait,"FFFFFF")
    ek=next((k for k in EV_COLORS if k.lower() in ev.lower()),"Weak")
    ebg,efg=EV_COLORS[ek]

    ws.cell(ri,1,prod).font=Font(bold=True,size=9,color="1A1A2E",name="Arial")
    ws.cell(ri,2,pid).font=Font(size=8,color="555555",name="Arial")
    ws.cell(ri,3,trait).font=Font(size=9,color="1A1A2E",name="Arial")
    ec=ws.cell(ri,4,ev); ec.font=Font(bold=True,size=9,color=efg,name="Arial"); ec.fill=fill(ebg)
    ws.cell(ri,5,finding).font=Font(size=9,color="1A1A2E",name="Arial")
    ws.cell(ri,6,pmid).font=Font(size=9,color="1A1A2E",name="Arial")
    lc=ws.cell(ri,7); lc.value=url; lc.hyperlink=url
    lc.font=Font(size=9,color="0563C1",underline="single",name="Arial")
    ws.cell(ri,8,auth).font=Font(size=9,color="1A1A2E",name="Arial")
    ws.cell(ri,9,stype).font=Font(size=9,color="1A1A2E",name="Arial")
    for ci in range(1,10):
        c=ws.cell(ri,ci)
        if ci!=4: c.fill=fill(rbg)
        c.alignment=aln("left","center",True); c.border=thin()
    ws.row_dimensions[ri].height=42

# ── SHEET 2: BY TRAIT ────────────────────────────────────────────────────────
ws2=wb.create_sheet("By Skin Trait")
ws2.column_dimensions["A"].width=26; ws2.column_dimensions["B"].width=32
ws2.column_dimensions["C"].width=20; ws2.column_dimensions["D"].width=60
ws2.column_dimensions["E"].width=42

ws2.merge_cells("A1:E1")
c=ws2["A1"]; c.value="FAM Products — By Skin Trait (Excluded products: Ashwagandha, Turmeric, Black Cumin, Aloe Vera, Olive Oil, Coconut Oil, Green Tea, Almond, Flaxseeds)"
c.font=Font(bold=True,size=12,color="FFFFFF",name="Arial"); c.fill=fill("0F1C2E")
c.alignment=aln("center","center"); ws2.row_dimensions[1].height=28

for ci,h in enumerate(["Skin Trait","FAM Product","Evidence Level","Key Finding","PubMed Link"],1):
    c=ws2.cell(2,ci,h)
    c.font=Font(bold=True,size=10,color="FFFFFF",name="Arial"); c.fill=fill("1A3050")
    c.alignment=aln("center","center"); c.border=thin()
ws2.row_dimensions[2].height=22; ws2.freeze_panes="A3"

ri=3
for trait in TRAITS:
    trows=[r for r in data if r[2]==trait]
    if not trows:
        for ci,v in enumerate([trait,"—","No evidence","No FAM product evidence found for this trait (after exclusions)","—"],1):
            c=ws2.cell(ri,ci,v); c.fill=fill("F2F3F4")
            c.font=Font(size=9,italic=True,color="888888",name="Arial")
            c.alignment=aln("left","center",True); c.border=thin()
        ws2.row_dimensions[ri].height=18; ri+=1
    else:
        for di,r in enumerate(trows):
            tl=trait if di==0 else ""
            ek=next((k for k in EV_COLORS if k.lower() in r[3].lower()),"Weak")
            ebg,efg=EV_COLORS[ek]; rbg=TRAIT_BG.get(trait,"FFFFFF")
            ws2.cell(ri,1,tl).font=Font(bold=(di==0),size=9,color="1A1A2E",name="Arial")
            ws2.cell(ri,1).fill=fill(rbg)
            ws2.cell(ri,2,r[0]).font=Font(bold=True,size=9,color="1A1A2E",name="Arial")
            ws2.cell(ri,2).fill=fill(rbg)
            ec=ws2.cell(ri,3,r[3]); ec.font=Font(bold=True,size=9,color=efg,name="Arial"); ec.fill=fill(ebg)
            ws2.cell(ri,4,r[4]).font=Font(size=9,color="1A1A2E",name="Arial"); ws2.cell(ri,4).fill=fill(rbg)
            lc=ws2.cell(ri,5); lc.value=r[6]; lc.hyperlink=r[6]
            lc.font=Font(size=9,color="0563C1",underline="single",name="Arial"); lc.fill=fill(rbg)
            for ci in range(1,6):
                ws2.cell(ri,ci).alignment=aln("left","center",True); ws2.cell(ri,ci).border=thin()
            ws2.row_dimensions[ri].height=40; ri+=1

# ── WRITE ─────────────────────────────────────────────────────────────────────
import io, subprocess
buf=io.BytesIO(); wb.save(buf); buf.seek(0)
tmp="/tmp/FAM_SkinResearch_Excl.xlsx"
out="/home/daytona/workspace/oil-skin-reference/FAM_SkinResearch_Excl.xlsx"
with open(tmp,"wb") as f: f.write(buf.getvalue())
subprocess.run(["dd",f"if={tmp}",f"of={out}","bs=4096"],check=True,capture_output=True)
print(f"DONE: {out}  |  rows: {len(data)}")