import openpyxl
from openpyxl.styles import (
    PatternFill, Font, Alignment, Border, Side
)
from openpyxl.utils import get_column_letter
from openpyxl.worksheet.datavalidation import DataValidation
import datetime

wb = openpyxl.Workbook()

# ── Color palette ──────────────────────────────────────────────
C_DARK_GREEN  = "1B5E20"
C_GREEN       = "2E7D32"
C_LIGHT_GREEN = "A5D6A7"
C_MINT        = "E8F5E9"
C_ORANGE      = "E65100"
C_AMBER       = "FF8F00"
C_YELLOW_BG   = "FFF9C4"
C_BLUE_DARK   = "0D47A1"
C_BLUE        = "1565C0"
C_LIGHT_BLUE  = "BBDEFB"
C_BLUE_BG     = "E3F2FD"
C_RED         = "B71C1C"
C_LIGHT_RED   = "FFCDD2"
C_PURPLE      = "4A148C"
C_PURPLE_LIGHT= "E1BEE7"
C_GREY_DARK   = "37474F"
C_GREY        = "546E7A"
C_GREY_LIGHT  = "ECEFF1"
C_WHITE       = "FFFFFF"

def fill(hex_color):
    return PatternFill("solid", fgColor=hex_color)

def font(bold=False, color="000000", size=11, italic=False):
    return Font(name="Arial", bold=bold, color=color, size=size, italic=italic)

def align(h="center", v="center", wrap=False):
    return Alignment(horizontal=h, vertical=v, wrap_text=wrap)

def border_thin():
    s = Side(style="thin", color="BDBDBD")
    return Border(left=s, right=s, top=s, bottom=s)

def border_medium():
    s = Side(style="medium", color="757575")
    return Border(left=s, right=s, top=s, bottom=s)

def set_cell(ws, row, col, value, bold=False, fg_color=None, font_color="000000",
             font_size=11, h_align="center", v_align="center", wrap=False,
             italic=False, border=True):
    cell = ws.cell(row=row, column=col, value=value)
    cell.font = font(bold=bold, color=font_color, size=font_size, italic=italic)
    cell.alignment = align(h_align, v_align, wrap)
    if fg_color:
        cell.fill = fill(fg_color)
    if border:
        cell.border = border_thin()
    return cell

# ══════════════════════════════════════════════════════════════════
# SHEET 1 — DAILY STUDY CHECKLIST
# ══════════════════════════════════════════════════════════════════
ws1 = wb.active
ws1.title = "Daily Checklist"
ws1.sheet_view.showGridLines = False
ws1.column_dimensions["A"].width = 4
ws1.column_dimensions["B"].width = 28
ws1.column_dimensions["C"].width = 22
ws1.column_dimensions["D"].width = 14
ws1.column_dimensions["E"].width = 14
ws1.column_dimensions["F"].width = 14
ws1.column_dimensions["G"].width = 18
ws1.column_dimensions["H"].width = 22
ws1.row_dimensions[1].height = 50
ws1.row_dimensions[2].height = 22
ws1.row_dimensions[3].height = 22

# ── Title banner ──
ws1.merge_cells("A1:H1")
c = ws1["A1"]
c.value = "🎯  RAJASTHAN PHARMACIST EXAM — DAILY STUDY CHECKLIST"
c.font = Font(name="Arial", bold=True, size=16, color=C_WHITE)
c.fill = fill(C_DARK_GREEN)
c.alignment = align("center", "center")

# Date & Day row
ws1.merge_cells("A2:B2")
set_cell(ws1, 2, 1, "📅  Date:", bold=True, fg_color=C_LIGHT_GREEN, font_size=11)
ws1.merge_cells("C2:D2")
set_cell(ws1, 2, 3, "", fg_color=C_YELLOW_BG, h_align="left")  # user fills date
ws1.merge_cells("E2:F2")
set_cell(ws1, 2, 5, "📆  Day No.:", bold=True, fg_color=C_LIGHT_GREEN, font_size=11)
ws1.merge_cells("G2:H2")
set_cell(ws1, 2, 7, "", fg_color=C_YELLOW_BG, h_align="left")

# Target score row
ws1.merge_cells("A3:B3")
set_cell(ws1, 3, 1, "🏆  Target Score:", bold=True, fg_color=C_LIGHT_BLUE, font_size=11)
ws1.merge_cells("C3:D3")
set_cell(ws1, 3, 3, "120 / 150", bold=True, fg_color=C_BLUE_BG, font_color=C_BLUE_DARK)
ws1.merge_cells("E3:F3")
set_cell(ws1, 3, 5, "⚠️  Neg. Marking:", bold=True, fg_color=C_LIGHT_RED, font_size=11)
ws1.merge_cells("G3:H3")
set_cell(ws1, 3, 7, "0.33 per wrong answer", bold=True, fg_color=C_LIGHT_RED, font_color=C_RED)

# ── Section A: Time Management ──
row = 5
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "⏰  SECTION A — TIME MANAGEMENT (Daily Schedule)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_BLUE)
c.alignment = align("left", "center")

row += 1
headers = ["#", "Time Slot", "Activity / Subject", "Topic", "Duration", "Completed?", "MCQs Done", "Notes"]
col_fills = [C_LIGHT_BLUE]*8
ws1.row_dimensions[row].height = 20
for i, h in enumerate(headers, 1):
    set_cell(ws1, row, i, h, bold=True, fg_color=C_BLUE_DARK, font_color=C_WHITE, font_size=10)

time_slots = [
    ("1", "5:00 AM – 5:30 AM", "Morning Routine / Prayer", "–", "30 min"),
    ("2", "5:30 AM – 7:30 AM", "Pharmacology", "Topic of the day", "2 hrs"),
    ("3", "7:30 AM – 8:00 AM", "Breakfast Break", "–", "30 min"),
    ("4", "8:00 AM – 9:30 AM", "Pharmaceutical Jurisprudence", "Acts / Schedules", "1.5 hrs"),
    ("5", "9:30 AM – 10:30 AM", "MCQ Practice (Morning)", "Yesterday topics", "1 hr"),
    ("6", "10:30 AM – 11:00 AM", "Short Break / Walk", "–", "30 min"),
    ("7", "11:00 AM – 12:30 PM", "Pharmaceutics / Pharmacognosy", "Topic of the day", "1.5 hrs"),
    ("8", "12:30 PM – 1:30 PM", "Lunch + Rest", "–", "1 hr"),
    ("9", "1:30 PM – 3:00 PM", "Biochemistry / Anatomy", "Topic of the day", "1.5 hrs"),
    ("10", "3:00 PM – 4:00 PM", "Hospital / Community Pharmacy", "Topic of the day", "1 hr"),
    ("11", "4:00 PM – 4:30 PM", "Evening Break / Tea", "–", "30 min"),
    ("12", "4:30 PM – 5:30 PM", "General Knowledge (Rajasthan)", "Current affairs / GK", "1 hr"),
    ("13", "5:30 PM – 6:30 PM", "MCQ Practice (Evening)", "Today's topics", "1 hr"),
    ("14", "6:30 PM – 7:00 PM", "Exercise / Relax", "–", "30 min"),
    ("15", "7:00 PM – 8:00 PM", "Dinner + Rest", "–", "1 hr"),
    ("16", "8:00 PM – 9:30 PM", "Revision (Morning topics)", "Notes review", "1.5 hrs"),
    ("17", "9:30 PM – 10:00 PM", "Daily Summary + Tomorrow Plan", "Diary writing", "30 min"),
    ("18", "10:00 PM", "SLEEP 💤", "–", "7 hrs"),
]

for i, (num, slot, activity, topic, dur) in enumerate(time_slots):
    r = row + 1 + i
    ws1.row_dimensions[r].height = 18
    bg = C_MINT if i % 2 == 0 else C_WHITE
    # grey out break rows
    if "Break" in activity or "Routine" in activity or "Rest" in activity or \
       "Exercise" in activity or "Dinner" in activity or "SLEEP" in activity:
        bg = C_GREY_LIGHT
    set_cell(ws1, r, 1, num, fg_color=bg, font_color=C_GREY_DARK)
    set_cell(ws1, r, 2, slot, bold=True, fg_color=bg, font_color=C_BLUE_DARK, h_align="left")
    set_cell(ws1, r, 3, activity, fg_color=bg, h_align="left", font_color=C_GREY_DARK, bold=("Break" not in activity and "Routine" not in activity))
    set_cell(ws1, r, 4, topic, fg_color=bg, h_align="left", italic=True, font_color=C_GREY)
    set_cell(ws1, r, 5, dur, fg_color=bg, font_color=C_ORANGE, bold=True)
    # Completed? dropdown
    set_cell(ws1, r, 6, "☐ Pending", fg_color=C_YELLOW_BG, font_color=C_AMBER, bold=True)
    set_cell(ws1, r, 7, 0, fg_color=bg, font_color=C_BLUE)
    set_cell(ws1, r, 8, "", fg_color=bg, h_align="left")

current_row = row + 1 + len(time_slots) + 1

# ── Section B: Subject Checklist ──
row = current_row + 1
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "📚  SECTION B — SUBJECT CHECKLIST (Today's Topics)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_GREEN)
c.alignment = align("left", "center")

row += 1
subj_headers = ["#", "Subject", "Topic Covered Today", "Pages / Chapter", "Status", "Difficulty", "MCQ Score", "Revision Needed?"]
for i, h in enumerate(subj_headers, 1):
    set_cell(ws1, row, i, h, bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE, font_size=10)

subjects = [
    ("1", "Pharmacology & Toxicology", "", "", "☐ Done", "⭐⭐⭐", "", ""),
    ("2", "Pharmaceutical Jurisprudence", "", "", "☐ Done", "⭐⭐", "", ""),
    ("3", "Pharmaceutics", "", "", "☐ Done", "⭐⭐", "", ""),
    ("4", "Pharmacognosy", "", "", "☐ Done", "⭐⭐", "", ""),
    ("5", "Biochemistry & Clinical Path.", "", "", "☐ Done", "⭐⭐", "", ""),
    ("6", "Human Anatomy & Physiology", "", "", "☐ Done", "⭐", "", ""),
    ("7", "Pharmaceutical Chemistry", "", "", "☐ Done", "⭐⭐", "", ""),
    ("8", "Hospital & Clinical Pharmacy", "", "", "☐ Done", "⭐", "", ""),
    ("9", "Community & Health Education", "", "", "☐ Done", "⭐", "", ""),
    ("10","Drug Store & Business Mgmt.", "", "", "☐ Done", "⭐", "", ""),
    ("11","General Knowledge (Rajasthan)", "", "", "☐ Done", "⭐", "", ""),
]

for i, row_data in enumerate(subjects):
    r = row + 1 + i
    ws1.row_dimensions[r].height = 18
    bg = C_MINT if i % 2 == 0 else C_WHITE
    colors = [C_GREY_DARK, C_BLUE_DARK, "000000", C_GREY, C_AMBER, C_ORANGE, C_BLUE, C_GREEN]
    for j, val in enumerate(row_data):
        fc = colors[j] if j < len(colors) else "000000"
        set_cell(ws1, r, j+1, val, fg_color=bg, font_color=fc,
                 h_align="left" if j in [1,2,3] else "center",
                 bold=(j == 1))

current_row = row + 1 + len(subjects) + 1

# ── Section C: MCQ Tracker ──
row = current_row + 1
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "📝  SECTION C — MCQ TRACKER (Daily Practice)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_PURPLE)
c.alignment = align("left", "center")

row += 1
mcq_headers = ["#", "Subject", "MCQs Attempted", "Correct", "Wrong", "Score %", "Negative Marks", "Remarks"]
for i, h in enumerate(mcq_headers, 1):
    set_cell(ws1, row, i, h, bold=True, fg_color=C_PURPLE, font_color=C_WHITE, font_size=10)

for i in range(1, 6):
    r = row + i
    ws1.row_dimensions[r].height = 18
    bg = C_PURPLE_LIGHT if i % 2 == 0 else C_WHITE
    set_cell(ws1, r, 1, str(i), fg_color=bg)
    for j in range(2, 9):
        set_cell(ws1, r, j, "", fg_color=bg)

# Total row
r = row + 6
ws1.row_dimensions[r].height = 20
ws1.merge_cells(f"A{r}:B{r}")
set_cell(ws1, r, 1, "DAILY TOTAL", bold=True, fg_color=C_PURPLE, font_color=C_WHITE)
for j in range(3, 9):
    set_cell(ws1, r, j, "", fg_color=C_PURPLE_LIGHT, bold=True)

# ── Section D: Daily Self-Assessment ──
row = r + 2
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "🌟  SECTION D — DAILY SELF-ASSESSMENT"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_ORANGE)
c.alignment = align("left", "center")

row += 1
assess_items = [
    ("Today ki study kaisi rahi?",         "⭐⭐⭐⭐⭐ (1-5 stars)"),
    ("Kitne ghante padha?",                 "____ hours"),
    ("Total MCQs solved today?",            "____ MCQs"),
    ("Accuracy rate?",                      "____%"),
    ("Kya mujhe neend aayi padhte waqt?",   "Haan / Nahi"),
    ("Kal kya improve karna hai?",          "________________________"),
    ("Motivational note to self:",          "________________________"),
]

for i, (question, placeholder) in enumerate(assess_items):
    r = row + i
    ws1.row_dimensions[r].height = 20
    bg = C_YELLOW_BG if i % 2 == 0 else C_WHITE
    ws1.merge_cells(f"A{r}:D{r}")
    set_cell(ws1, r, 1, question, bold=True, fg_color=bg, font_color=C_GREY_DARK, h_align="left")
    ws1.merge_cells(f"E{r}:H{r}")
    set_cell(ws1, r, 5, placeholder, fg_color=C_WHITE, font_color=C_ORANGE, italic=True, h_align="left")


# ══════════════════════════════════════════════════════════════════
# SHEET 2 — 3-MONTH PLANNER
# ══════════════════════════════════════════════════════════════════
ws2 = wb.create_sheet("3-Month Planner")
ws2.sheet_view.showGridLines = False
ws2.column_dimensions["A"].width = 8
ws2.column_dimensions["B"].width = 12
ws2.column_dimensions["C"].width = 22
ws2.column_dimensions["D"].width = 28
ws2.column_dimensions["E"].width = 20
ws2.column_dimensions["F"].width = 14
ws2.column_dimensions["G"].width = 14
ws2.column_dimensions["H"].width = 14
ws2.column_dimensions["I"].width = 20

# Title
ws2.merge_cells("A1:I1")
ws2.row_dimensions[1].height = 46
c = ws2["A1"]
c.value = "📅  RAJASTHAN PHARMACIST — 3 MONTH STUDY PLANNER (350 Classes)"
c.font = Font(name="Arial", bold=True, size=15, color=C_WHITE)
c.fill = fill(C_DARK_GREEN)
c.alignment = align("center", "center")

# Subject distribution header
row = 3
ws2.merge_cells(f"A{row}:I{row}")
ws2.row_dimensions[row].height = 22
c = ws2[f"A{row}"]
c.value = "📊  SUBJECT-WISE CLASS DISTRIBUTION"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_BLUE)
c.alignment = align("left", "center")

row += 1
dist_headers = ["#", "Subject", "Classes", "% of Total", "Priority", "Month 1", "Month 2", "Month 3", "Status"]
for i, h in enumerate(dist_headers, 1):
    set_cell(ws2, row, i, h, bold=True, fg_color=C_BLUE_DARK, font_color=C_WHITE)

subject_dist = [
    (1, "Pharmacology & Toxicology",      75, "21.4%", "🔴 Highest", 40, 20, 15, ""),
    (2, "Pharmaceutical Jurisprudence",   50, "14.3%", "🔴 High",    25, 15, 10, ""),
    (3, "Pharmaceutics",                  45, "12.9%", "🟠 High",    13, 25,  7, ""),
    (4, "Pharmacognosy",                  35, "10.0%", "🟠 Medium",   5, 22,  8, ""),
    (5, "Biochemistry & Clinical Path.",  30,  "8.6%", "🟡 Medium",   0, 20, 10, ""),
    (6, "Human Anatomy & Physiology",     25,  "7.1%", "🟡 Medium",   0,  5, 20, ""),
    (7, "Pharmaceutical Chemistry",       25,  "7.1%", "🟡 Medium",   0,  5, 20, ""),
    (8, "Hospital & Clinical Pharmacy",   20,  "5.7%", "🟢 Low-Med",  0,  0, 20, ""),
    (9, "Health Ed & Community Pharm.",   20,  "5.7%", "🟢 Low-Med",  0,  0, 20, ""),
    (10,"Drug Store & Business Mgmt.",    15,  "4.3%", "🟢 Low",      0,  0, 15, ""),
    (11,"General Knowledge (Rajasthan)",  10,  "2.9%", "🔵 GK",       0,  0, 10, ""),
    ("", "REVISION + MOCK TESTS",        100,  "--",   "🔁 Ongoing", 10, 10, 80, ""),
]

total_row_colors = {11: C_LIGHT_RED}
for i, row_data in enumerate(subject_dist):
    r = row + 1 + i
    ws2.row_dimensions[r].height = 18
    is_total = (row_data[0] == "")
    bg = C_LIGHT_GREEN if is_total else (C_MINT if i % 2 == 0 else C_WHITE)
    for j, val in enumerate(row_data):
        fc = C_RED if is_total else (C_BLUE_DARK if j == 1 else "000000")
        set_cell(ws2, r, j+1, val, fg_color=bg, font_color=fc,
                 h_align="left" if j == 1 else "center", bold=is_total or j==1)

# Grand total
r = row + 1 + len(subject_dist)
ws2.row_dimensions[r].height = 22
ws2.merge_cells(f"A{r}:B{r}")
set_cell(ws2, r, 1, "GRAND TOTAL", bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
set_cell(ws2, r, 3, 350, bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
set_cell(ws2, r, 4, "100%", bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
for j in [5,6,7,8,9]:
    set_cell(ws2, r, j, "", fg_color=C_DARK_GREEN)

# ── Monthly breakdown ──
months_data = [
    ("MONTH 1 — Foundation Phase", C_BLUE, C_BLUE_BG, [
        ("Week 1", "Day 1–7",   "Pharmacology",                   "Autonomic NS, CVS Drugs",         18),
        ("Week 2", "Day 8–14",  "Pharmacology",                   "CNS, Antibiotics, Antidiabetics", 18),
        ("Week 3", "Day 15–21", "Pharmacology + Jurisprudence",   "Remaining Pharma + D&C Act 1940", 20),
        ("Week 4", "Day 22–30", "Jurisprudence + Pharmaceutics",  "Pharmacy Act, NDPS, Schedules",   22),
    ]),
    ("MONTH 2 — Core Building Phase", C_GREEN, C_MINT, [
        ("Week 5", "Day 31–37", "Pharmaceutics",                  "Dosage forms, Tablets, Injections",20),
        ("Week 6", "Day 38–44", "Pharmaceutics + Pharmacognosy",  "Remaining + Alkaloids, Glycosides",20),
        ("Week 7", "Day 45–51", "Pharmacognosy",                  "Volatile oils, Crude drugs",       18),
        ("Week 8", "Day 52–60", "Biochemistry & Clinical Path.",  "Metabolism, Lab values",           22),
    ]),
    ("MONTH 3 — Revision + Completion Phase", C_ORANGE, C_YELLOW_BG, [
        ("Week 9",  "Day 61–67", "Anatomy & Physiology",           "Body systems, CVS, Renal, NS",    20),
        ("Week 10", "Day 68–74", "Pharma Chemistry + Hospital",    "Assay, Stability, Formulary",     22),
        ("Week 11", "Day 75–81", "Community + Drug Store + GK",    "Health programs, Raj. schemes",   22),
        ("Week 12", "Day 82–90", "FULL REVISION + MOCK TESTS",     "All subjects + Prev. yr papers",  28),
    ]),
]

row = r + 2
for month_name, h_color, bg_color, weeks in months_data:
    ws2.merge_cells(f"A{row}:I{row}")
    ws2.row_dimensions[row].height = 24
    c = ws2[f"A{row}"]
    c.value = f"🗓️  {month_name}"
    c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
    c.fill = fill(h_color)
    c.alignment = align("left", "center")
    row += 1

    week_headers = ["Week", "Days", "Primary Subject", "Topics", "Classes", "Done?", "MCQ Target", "Actual MCQ", "Notes"]
    for i, h in enumerate(week_headers, 1):
        set_cell(ws2, row, i, h, bold=True, fg_color=h_color, font_color=C_WHITE)
    row += 1

    for i, (week, days, subj, topics, classes) in enumerate(weeks):
        ws2.row_dimensions[row].height = 18
        bg = bg_color if i % 2 == 0 else C_WHITE
        set_cell(ws2, row, 1, week, bold=True, fg_color=bg, font_color=h_color)
        set_cell(ws2, row, 2, days, fg_color=bg, font_color=C_GREY_DARK)
        set_cell(ws2, row, 3, subj, bold=True, fg_color=bg, font_color="000000", h_align="left")
        set_cell(ws2, row, 4, topics, fg_color=bg, h_align="left", italic=True, font_color=C_GREY)
        set_cell(ws2, row, 5, classes, bold=True, fg_color=bg, font_color=C_ORANGE)
        set_cell(ws2, row, 6, "☐", fg_color=C_YELLOW_BG, font_color=C_AMBER, bold=True)
        set_cell(ws2, row, 7, classes * 5, fg_color=bg, font_color=C_BLUE)  # 5 MCQ per class target
        set_cell(ws2, row, 8, "", fg_color=bg)
        set_cell(ws2, row, 9, "", fg_color=bg, h_align="left")
        row += 1
    row += 1


# ══════════════════════════════════════════════════════════════════
# SHEET 3 — WEEKLY PROGRESS TRACKER
# ══════════════════════════════════════════════════════════════════
ws3 = wb.create_sheet("Weekly Progress")
ws3.sheet_view.showGridLines = False
for col, w in zip("ABCDEFGHIJ", [8,14,14,14,14,14,14,16,16,18]):
    ws3.column_dimensions[col].width = w

ws3.merge_cells("A1:J1")
ws3.row_dimensions[1].height = 44
c = ws3["A1"]
c.value = "📈  WEEKLY PROGRESS TRACKER — Rajasthan Pharmacist Exam"
c.font = Font(name="Arial", bold=True, size=14, color=C_WHITE)
c.fill = fill(C_PURPLE)
c.alignment = align("center", "center")

row = 3
ws3.merge_cells(f"A{row}:J{row}")
ws3.row_dimensions[row].height = 22
c = ws3[f"A{row}"]
c.value = "📊  Week-by-Week Study Summary (12 Weeks)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_GREY_DARK)
c.alignment = align("left", "center")

row += 1
wp_headers = ["Week", "Dates", "Classes Done", "MCQs Done", "Correct %", "Weak Topics", "Hours Studied", "Mock Score", "Revision Done?", "Plan for Next Week"]
for i, h in enumerate(wp_headers, 1):
    set_cell(ws3, row, i, h, bold=True, fg_color=C_GREY_DARK, font_color=C_WHITE)

week_dates = [
    ("Wk 1","Day 1-7"),("Wk 2","Day 8-14"),("Wk 3","Day 15-21"),("Wk 4","Day 22-30"),
    ("Wk 5","Day 31-37"),("Wk 6","Day 38-44"),("Wk 7","Day 45-51"),("Wk 8","Day 52-60"),
    ("Wk 9","Day 61-67"),("Wk 10","Day 68-74"),("Wk 11","Day 75-81"),("Wk 12","Day 82-90"),
]
for i, (wk, dates) in enumerate(week_dates):
    r = row + 1 + i
    ws3.row_dimensions[r].height = 20
    bg = C_PURPLE_LIGHT if i % 2 == 0 else C_WHITE
    month_bg = {0:C_BLUE_BG, 1:C_BLUE_BG, 2:C_BLUE_BG, 3:C_BLUE_BG,
                4:C_MINT,    5:C_MINT,    6:C_MINT,    7:C_MINT,
                8:C_YELLOW_BG,9:C_YELLOW_BG,10:C_YELLOW_BG,11:C_YELLOW_BG}
    bg = month_bg.get(i, C_WHITE)
    set_cell(ws3, r, 1, wk, bold=True, fg_color=bg, font_color=C_PURPLE)
    set_cell(ws3, r, 2, dates, fg_color=bg, font_color=C_GREY_DARK)
    for j in range(3, 11):
        set_cell(ws3, r, j, "", fg_color=bg)


# ══════════════════════════════════════════════════════════════════
# SHEET 4 — SUBJECT NOTES QUICK REFERENCE
# ══════════════════════════════════════════════════════════════════
ws4 = wb.create_sheet("Quick Reference")
ws4.sheet_view.showGridLines = False
ws4.column_dimensions["A"].width = 4
ws4.column_dimensions["B"].width = 26
ws4.column_dimensions["C"].width = 32
ws4.column_dimensions["D"].width = 32
ws4.column_dimensions["E"].width = 28

ws4.merge_cells("A1:E1")
ws4.row_dimensions[1].height = 44
c = ws4["A1"]
c.value = "⚡  QUICK REFERENCE — Important Topics per Subject"
c.font = Font(name="Arial", bold=True, size=14, color=C_WHITE)
c.fill = fill(C_AMBER)
c.alignment = align("center", "center")

qr_data = [
    ("Pharmacology & Toxicology",  C_RED,
     "• Autonomic drugs: Atropine, Neostigmine\n• CVS: Beta blockers, ACE inhibitors, Digoxin\n• CNS: Benzodiazepines, Opioids, Antiepileptics\n• Antibiotics: Penicillin, Cephalosporins, Aminoglycosides\n• Antidiabetics: Insulin, Metformin, Sulfonylureas\n• NSAIDs: Aspirin, Ibuprofen, COX-2 inhibitors",
     "• Organophosphate poisoning → Atropine antidote\n• Morphine overdose → Naloxone\n• Paracetamol overdose → NAC (N-Acetylcysteine)\n• Iron poisoning → Deferoxamine\n• Cyanide → Sodium Nitrite + Sodium Thiosulfate",
     "KD Tripathi - Essentials of Pharmacology\nRS Satoskar Pharmacology"),

    ("Pharmaceutical Jurisprudence", C_BLUE_DARK,
     "• D&C Act 1940 + Rules 1945\n• Pharmacy Act 1948 (PCI, State Councils)\n• NDPS Act 1985\n• Schedule H, H1, X, G, C, C1\n• Drug Controller General of India (DCGI)\n• Central Drugs Standard Control Organization",
     "• Schedule H = Rx only drugs\n• Schedule H1 = Rx + special record keeping\n• Schedule X = Habit-forming (30 day supply)\n• Schedule G = Caution/Industrial drugs\n• Schedule C = Biological products\n• Penalty: Adulteration = up to 10 yrs imprisonment",
     "Pharmaceutical Jurisprudence by Mithal\nGovt. of India Acts (free PDF)"),

    ("Pharmaceutics",              C_GREEN,
     "• Tablets: Direct compression, granulation\n• Capsules: Hard gelatin, soft gelatin\n• Injections: Pyrogen-free, isotonic\n• Ointments/Creams: Oil-in-water, water-in-oil\n• Suppositories: Cocoa butter base\n• Aerosols: MDI, DPI",
     "• Sterilization: Autoclave 121°C/15 min\n• Dry heat: 160°C/1 hr or 170°C/30 min\n• Bioavailability = AUC oral / AUC IV × 100\n• IP = Indian Pharmacopoeia\n• BCS Class I = High solubility, high permeability",
     "Lachman & Lieberman - Theory & Practice\nRemington's Pharmaceutical Sciences"),

    ("Pharmacognosy",              C_DARK_GREEN,
     "• Opium (Papaver somniferum) → Morphine, Codeine\n• Cinchona bark → Quinine, Quinidine\n• Rauwolfia → Reserpine\n• Digitalis purpurea → Digoxin, Digitoxin\n• Belladonna → Atropine, Hyoscine\n• Senna → Sennosides (laxative)",
     "• Adulteration tests: Ash value, moisture content\n• Extraction: Maceration, percolation, infusion\n• TLC, UV spectroscopy for identification\n• WHO guidelines for herbal drugs\n• Ayurvedic plants: Neem, Tulsi, Ashwagandha",
     "CK Kokate - Pharmacognosy\nTyler, Brady & Robbers"),

    ("Biochemistry & Clinical Path.", C_PURPLE,
     "• Blood glucose: Fasting 70-110 mg/dL\n• HbA1c: Normal <5.7%, Diabetic >6.5%\n• Hemoglobin: Male 13-17 g/dL, Female 12-15\n• Creatinine: 0.6-1.2 mg/dL\n• Total Cholesterol: <200 mg/dL desirable",
     "• Glycolysis → Pyruvate → Acetyl CoA\n• TCA Cycle (Krebs) → 38 ATP total\n• Beta oxidation of fatty acids\n• Urea cycle: NH3 → Urea (liver)\n• Liver enzymes: SGOT, SGPT (ALT, AST)\n• Kidney: GFR, creatinine clearance",
     "Harper's Illustrated Biochemistry\nLippincott's Biochemistry"),
]

row = 3
qr_headers = ["#", "Subject", "Key Topics / Drugs", "Important Facts / Values", "Recommended Books"]
for i, h in enumerate(qr_headers, 1):
    set_cell(ws4, row, i, h, bold=True, fg_color=C_GREY_DARK, font_color=C_WHITE)

for idx, (subj, color, topics, facts, books) in enumerate(qr_data):
    r = row + 1 + idx
    ws4.row_dimensions[r].height = 90
    set_cell(ws4, r, 1, str(idx+1), fg_color=C_GREY_LIGHT, font_color=C_GREY_DARK, bold=True)
    set_cell(ws4, r, 2, subj, bold=True, fg_color=color, font_color=C_WHITE, v_align="top", h_align="left")
    set_cell(ws4, r, 3, topics, fg_color=C_MINT if idx%2==0 else C_WHITE,
             h_align="left", v_align="top", wrap=True, font_size=9)
    set_cell(ws4, r, 4, facts, fg_color=C_LIGHT_BLUE if idx%2==0 else C_WHITE,
             h_align="left", v_align="top", wrap=True, font_size=9)
    set_cell(ws4, r, 5, books, fg_color=C_YELLOW_BG, h_align="left", v_align="top",
             wrap=True, font_size=9, italic=True, font_color=C_GREY)

# ── Footer note on Sheet 4 ──
r = row + 1 + len(qr_data) + 1
ws4.merge_cells(f"A{r}:E{r}")
ws4.row_dimensions[r].height = 28
c = ws4[f"A{r}"]
c.value = "💊  Best of luck for Rajasthan Pharmacist Exam! Study smart, revise daily, practice MCQs every day. You can do it! 🎯"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_DARK_GREEN)
c.alignment = align("center", "center")


# ══════════════════════════════════════════════════════════════════
# Save
# ══════════════════════════════════════════════════════════════════
output_path = "/tmp/workspace/raj-pharmacist/Rajasthan_Pharmacist_Study_Template.xlsx"
wb.save(output_path)
print(f"Saved: {output_path}")

import openpyxl
from openpyxl.styles import PatternFill, Font, Alignment, Border, Side

wb = openpyxl.Workbook()

# ── Colors ─────────────────────────────────────────────────────
C_DARK_GREEN   = "1B5E20"
C_GREEN        = "2E7D32"
C_LIGHT_GREEN  = "A5D6A7"
C_MINT         = "E8F5E9"
C_ORANGE       = "E65100"
C_AMBER        = "FF8F00"
C_YELLOW_BG    = "FFF9C4"
C_BLUE_DARK    = "0D47A1"
C_BLUE         = "1565C0"
C_LIGHT_BLUE   = "BBDEFB"
C_BLUE_BG      = "E3F2FD"
C_RED          = "B71C1C"
C_LIGHT_RED    = "FFCDD2"
C_PURPLE       = "4A148C"
C_PURPLE_LIGHT = "E1BEE7"
C_GREY_DARK    = "37474F"
C_GREY         = "546E7A"
C_GREY_LIGHT   = "ECEFF1"
C_WHITE        = "FFFFFF"
C_TEAL         = "004D40"
C_TEAL_LIGHT   = "B2DFDB"

def fill(hex_color):
    return PatternFill("solid", fgColor=hex_color)

def font(bold=False, color="000000", size=11, italic=False):
    return Font(name="Arial", bold=bold, color=color, size=size, italic=italic)

def align(h="center", v="center", wrap=False):
    return Alignment(horizontal=h, vertical=v, wrap_text=wrap)

def thin_border():
    s = Side(style="thin", color="BDBDBD")
    return Border(left=s, right=s, top=s, bottom=s)

def set_cell(ws, row, col, value, bold=False, fg_color=None, font_color="000000",
             font_size=11, h_align="center", v_align="center", wrap=False,
             italic=False, border=True):
    cell = ws.cell(row=row, column=col, value=value)
    cell.font = font(bold=bold, color=font_color, size=font_size, italic=italic)
    cell.alignment = align(h_align, v_align, wrap)
    if fg_color:
        cell.fill = fill(fg_color)
    if border:
        cell.border = thin_border()
    return cell


# ═══════════════════════════════════════════════════════════════
# SHEET 1 — DAILY CHECKLIST  (9 AM – 5 PM)
# ═══════════════════════════════════════════════════════════════
ws1 = wb.active
ws1.title = "Daily Checklist"
ws1.sheet_view.showGridLines = False

col_widths = {"A":4,"B":22,"C":26,"D":26,"E":14,"F":14,"G":16,"H":22}
for col, w in col_widths.items():
    ws1.column_dimensions[col].width = w

# ── Title ──
ws1.merge_cells("A1:H1")
ws1.row_dimensions[1].height = 48
c = ws1["A1"]
c.value = "🎯  RAJASTHAN PHARMACIST EXAM — DAILY STUDY CHECKLIST  (9:00 AM – 5:00 PM)"
c.font = Font(name="Arial", bold=True, size=15, color=C_WHITE)
c.fill = fill(C_DARK_GREEN)
c.alignment = align("center", "center")

# ── Info row ──
for r_num, items in [(2, [("A2:B2","📅  Date:","left",C_LIGHT_GREEN,True),
                           ("C2:D2","","left",C_YELLOW_BG,False),
                           ("E2:F2","📆  Day No.:","center",C_LIGHT_GREEN,True),
                           ("G2:H2","","left",C_YELLOW_BG,False)]),
                     (3, [("A3:C3","⏱  Study Window:  9:00 AM – 5:00 PM  (8 hrs)","left",C_LIGHT_BLUE,True),
                           ("D3:F3","❌  Neg. Marking: 0.33 / wrong answer","center",C_LIGHT_RED,True),
                           ("G3:H3","🏆  Target: 120/150","center",C_MINT,True)])]:
    ws1.row_dimensions[r_num].height = 22
    for merge_range, val, ha, bg, bld in items:
        ws1.merge_cells(merge_range)
        start = merge_range.split(":")[0]
        rc = ws1[start]
        rc.value = val
        rc.font = Font(name="Arial", bold=bld, size=11,
                       color=C_RED if "Neg" in val else
                             C_BLUE_DARK if "Window" in val else
                             C_DARK_GREEN if "Target" in val else "000000")
        rc.fill = fill(bg)
        rc.alignment = align(ha, "center")
        rc.border = thin_border()

# ── Section A header ──
row = 5
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "⏰  SECTION A — TIME TABLE  (9:00 AM to 5:00 PM)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_BLUE)
c.alignment = align("left", "center")

row += 1
ws1.row_dimensions[row].height = 20
for i, h in enumerate(["#","Time Slot","Subject","Today's Topic","Duration","Done?","MCQs Done","Notes"],1):
    set_cell(ws1, row, i, h, bold=True, fg_color=C_BLUE_DARK, font_color=C_WHITE)

# 8-hour schedule 9 AM – 5 PM
# Sessions: each ~1 hr study + short breaks, lunch break
time_slots = [
    # num  slot                   subject                       topic                   dur     break?
    ("1","9:00 – 10:00 AM",  "Pharmacology",              "Drug classification / Mechanisms",  "1 hr",  False),
    ("2","10:00 – 11:00 AM", "Pharmacology",              "CVS / Autonomic drugs",              "1 hr",  False),
    ("3","11:00 – 11:15 AM", "☕  Short Break",            "–",                                 "15 min", True),
    ("4","11:15 AM – 12:15 PM","Pharmaceutical Jurisprudence","D&C Act / Schedules",           "1 hr",  False),
    ("5","12:15 – 1:00 PM",  "Pharmaceutics",             "Dosage forms",                      "45 min", False),
    ("6","1:00 – 1:45 PM",   "🍽  Lunch Break",            "–",                                 "45 min", True),
    ("7","1:45 – 2:45 PM",   "Pharmacognosy",             "Crude drugs / Alkaloids",           "1 hr",  False),
    ("8","2:45 – 3:45 PM",   "Biochemistry / Physiology", "Metabolism / Lab values",           "1 hr",  False),
    ("9","3:45 – 4:00 PM",   "☕  Short Break",            "–",                                 "15 min", True),
    ("10","4:00 – 4:30 PM",  "General Knowledge",         "Rajasthan GK / Health schemes",     "30 min", False),
    ("11","4:30 – 5:00 PM",  "📝  MCQ Revision Session",  "All today's topics",                "30 min", False),
]

for i, (num, slot, subj, topic, dur, is_break) in enumerate(time_slots):
    r = row + 1 + i
    ws1.row_dimensions[r].height = 20
    if is_break:
        bg = C_GREY_LIGHT
        fc = C_GREY
    else:
        bg = C_MINT if i % 2 == 0 else C_WHITE
        fc = "000000"

    set_cell(ws1, r, 1, num, fg_color=bg, font_color=C_GREY_DARK, bold=True)
    set_cell(ws1, r, 2, slot, fg_color=bg, font_color=C_BLUE_DARK, bold=not is_break, h_align="left")
    set_cell(ws1, r, 3, subj, fg_color=bg, font_color=fc, bold=not is_break, h_align="left")
    set_cell(ws1, r, 4, topic, fg_color=bg, font_color=C_GREY, italic=True, h_align="left")
    set_cell(ws1, r, 5, dur, fg_color=bg, font_color=C_ORANGE, bold=True)
    if is_break:
        set_cell(ws1, r, 6, "–", fg_color=C_GREY_LIGHT, font_color=C_GREY)
        set_cell(ws1, r, 7, "–", fg_color=C_GREY_LIGHT, font_color=C_GREY)
        set_cell(ws1, r, 8, "–", fg_color=C_GREY_LIGHT, font_color=C_GREY)
    else:
        set_cell(ws1, r, 6, "☐ Pending", fg_color=C_YELLOW_BG, font_color=C_AMBER, bold=True)
        set_cell(ws1, r, 7, 0, fg_color=bg, font_color=C_BLUE)
        set_cell(ws1, r, 8, "", fg_color=bg, h_align="left")

# Summary row – total study hours
r_sum = row + 1 + len(time_slots)
ws1.row_dimensions[r_sum].height = 22
ws1.merge_cells(f"A{r_sum}:D{r_sum}")
set_cell(ws1, r_sum, 1, "✅  Total Study Time (excl. breaks)  →  6 hrs 15 min  |  MCQ Revision: 30 min", bold=True,
         fg_color=C_DARK_GREEN, font_color=C_WHITE, h_align="left")
set_cell(ws1, r_sum, 5, "6h 15m", bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
ws1.merge_cells(f"F{r_sum}:H{r_sum}")
set_cell(ws1, r_sum, 6, "Total MCQs Today →", bold=True, fg_color=C_BLUE_DARK, font_color=C_WHITE)

# ── Section B — Subject checklist ──
row = r_sum + 2
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "📚  SECTION B — SUBJECT COMPLETION TRACKER"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_GREEN)
c.alignment = align("left", "center")

row += 1
for i, h in enumerate(["#","Subject","Topic Covered Today","Pages / Chapter","Status","Difficulty (1-5)","MCQ Score %","Revise Tomorrow?"],1):
    set_cell(ws1, row, i, h, bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)

subjects = [
    ("1","Pharmacology & Toxicology","","","☐ Done","","",""),
    ("2","Pharmaceutical Jurisprudence","","","☐ Done","","",""),
    ("3","Pharmaceutics","","","☐ Done","","",""),
    ("4","Pharmacognosy","","","☐ Done","","",""),
    ("5","Biochemistry & Clinical Path.","","","☐ Done","","",""),
    ("6","Human Anatomy & Physiology","","","☐ Done","","",""),
    ("7","Pharmaceutical Chemistry","","","☐ Done","","",""),
    ("8","Hospital & Clinical Pharmacy","","","☐ Done","","",""),
    ("9","Community & Health Ed.","","","☐ Done","","",""),
    ("10","Drug Store & Business Mgmt.","","","☐ Done","","",""),
    ("11","General Knowledge (Rajasthan)","","","☐ Done","","",""),
]
for i, row_data in enumerate(subjects):
    r = row + 1 + i
    ws1.row_dimensions[r].height = 18
    bg = C_MINT if i % 2 == 0 else C_WHITE
    for j, val in enumerate(row_data):
        set_cell(ws1, r, j+1, val,
                 fg_color=bg,
                 font_color=C_BLUE_DARK if j==1 else C_AMBER if j==4 else C_GREY_DARK,
                 bold=(j==1),
                 h_align="left" if j in [1,2,3] else "center")

# ── Section C — MCQ Tracker ──
row = row + 1 + len(subjects) + 1
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "📝  SECTION C — MCQ PRACTICE TRACKER"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_PURPLE)
c.alignment = align("left", "center")

row += 1
for i, h in enumerate(["#","Subject","Attempted","Correct","Wrong","Score %","Neg. Marks Cut","Remarks"],1):
    set_cell(ws1, row, i, h, bold=True, fg_color=C_PURPLE, font_color=C_WHITE)

for i in range(1, 7):
    r = row + i
    ws1.row_dimensions[r].height = 18
    bg = C_PURPLE_LIGHT if i % 2 == 0 else C_WHITE
    for j in range(1, 9):
        set_cell(ws1, r, j, "" if j > 1 else str(i), fg_color=bg,
                 font_color=C_PURPLE if j==1 else "000000")

r_tot = row + 7
ws1.row_dimensions[r_tot].height = 22
ws1.merge_cells(f"A{r_tot}:B{r_tot}")
set_cell(ws1, r_tot, 1, "DAILY TOTAL", bold=True, fg_color=C_PURPLE, font_color=C_WHITE)
for j in range(3, 9):
    set_cell(ws1, r_tot, j, "", fg_color=C_PURPLE_LIGHT, bold=True)

# ── Section D — Self Assessment ──
row = r_tot + 2
ws1.merge_cells(f"A{row}:H{row}")
ws1.row_dimensions[row].height = 24
c = ws1[f"A{row}"]
c.value = "🌟  SECTION D — END OF DAY SELF-ASSESSMENT  (5:00 PM)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_ORANGE)
c.alignment = align("left", "center")

assess = [
    ("Aaj kitne ghante padha?",              "______ hours (max 8)"),
    ("Total MCQs solve kiye?",               "______ MCQs"),
    ("MCQ accuracy?",                        "______%"),
    ("Sabse difficult subject aaj?",         "______________________________"),
    ("Kya sabhi time slots complete hue?",   "Haan ✅  /  Nahi ❌"),
    ("Kal kya improve karna hai?",           "______________________________"),
    ("Motivational note:",                   "______________________________"),
]
for i, (q, ans) in enumerate(assess):
    r = row + 1 + i
    ws1.row_dimensions[r].height = 20
    bg = C_YELLOW_BG if i % 2 == 0 else C_WHITE
    ws1.merge_cells(f"A{r}:D{r}")
    c = ws1[f"A{r}"]
    c.value = q; c.font = Font(name="Arial", bold=True, size=11, color=C_GREY_DARK)
    c.fill = fill(bg); c.alignment = align("left", "center"); c.border = thin_border()
    ws1.merge_cells(f"E{r}:H{r}")
    c2 = ws1[f"E{r}"]
    c2.value = ans; c2.font = Font(name="Arial", italic=True, size=11, color=C_ORANGE)
    c2.fill = fill(C_WHITE); c2.alignment = align("left", "center"); c2.border = thin_border()


# ═══════════════════════════════════════════════════════════════
# SHEET 2 — 3-MONTH PLANNER
# ═══════════════════════════════════════════════════════════════
ws2 = wb.create_sheet("3-Month Planner")
ws2.sheet_view.showGridLines = False
for col, w in zip("ABCDEFGHI", [8,12,22,30,20,12,14,14,20]):
    ws2.column_dimensions[col].width = w

ws2.merge_cells("A1:I1")
ws2.row_dimensions[1].height = 46
c = ws2["A1"]
c.value = "📅  RAJASTHAN PHARMACIST — 3-MONTH PLANNER  |  350 Classes  |  9 AM – 5 PM"
c.font = Font(name="Arial", bold=True, size=14, color=C_WHITE)
c.fill = fill(C_DARK_GREEN)
c.alignment = align("center", "center")

# Study hours summary box
row = 3
ws2.merge_cells(f"A{row}:I{row}")
ws2.row_dimensions[row].height = 22
c = ws2[f"A{row}"]
c.value = "📊  Daily: 8 hrs total  |  6h 15min study  |  45min lunch  |  30min breaks  |  30min MCQ revision  |  90 days × ~3.9 classes/day = 350 classes"
c.font = Font(name="Arial", bold=True, size=11, color=C_WHITE)
c.fill = fill(C_TEAL)
c.alignment = align("left", "center")

# Subject distribution
row = 5
ws2.merge_cells(f"A{row}:I{row}")
ws2.row_dimensions[row].height = 22
c = ws2[f"A{row}"]
c.value = "📋  SUBJECT-WISE CLASS DISTRIBUTION (Total = 350)"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_BLUE)
c.alignment = align("left", "center")

row += 1
for i, h in enumerate(["#","Subject","Classes","% Share","Priority","Month 1","Month 2","Month 3","Remarks"],1):
    set_cell(ws2, row, i, h, bold=True, fg_color=C_BLUE_DARK, font_color=C_WHITE)

dist = [
    (1,"Pharmacology & Toxicology",     75,"21.4%","🔴 Highest",40,20,15,"Roz 2 hrs, 9-11 AM"),
    (2,"Pharmaceutical Jurisprudence",  50,"14.3%","🔴 High",   25,15,10,"Acts + Schedules"),
    (3,"Pharmaceutics",                 45,"12.9%","🟠 High",   13,25, 7,"Dosage forms focus"),
    (4,"Pharmacognosy",                 35,"10.0%","🟠 Medium",  5,22, 8,"Plants + alkaloids"),
    (5,"Biochemistry & Clinical Path.", 30, "8.6%","🟡 Medium",  0,20,10,"Lab values yaad karo"),
    (6,"Human Anatomy & Physiology",    25, "7.1%","🟡 Medium",  0, 5,20,"Body systems"),
    (7,"Pharmaceutical Chemistry",      25, "7.1%","🟡 Medium",  0, 5,20,"Assay + stability"),
    (8,"Hospital & Clinical Pharmacy",  20, "5.7%","🟢 Low-Med", 0, 0,20,"Formulary + TPN"),
    (9,"Health Ed & Community Pharm.",  20, "5.7%","🟢 Low-Med", 0, 0,20,"Nat. health programs"),
    (10,"Drug Store & Business Mgmt.",  15, "4.3%","🟢 Low",     0, 0,15,"Inventory, purchase"),
    (11,"General Knowledge (Rajasthan)",10, "2.9%","🔵 GK",      0, 0,10,"Raj. schemes + GK"),
    ("","REVISION + MOCK TESTS",       100,"  --","🔁 Ongoing", 10,10,80,"Daily MCQ + weekly mock"),
]

for i, rd in enumerate(dist):
    r = row + 1 + i
    ws2.row_dimensions[r].height = 18
    is_rev = (rd[0] == "")
    bg = C_LIGHT_GREEN if is_rev else (C_MINT if i%2==0 else C_WHITE)
    for j, val in enumerate(rd):
        set_cell(ws2, r, j+1, val, fg_color=bg,
                 font_color=C_RED if is_rev else (C_BLUE_DARK if j==1 else "000000"),
                 bold=is_rev or j==1,
                 h_align="left" if j==1 else ("left" if j==8 else "center"))

# Grand total
r_gt = row + 1 + len(dist)
ws2.row_dimensions[r_gt].height = 22
ws2.merge_cells(f"A{r_gt}:B{r_gt}")
set_cell(ws2, r_gt, 1, "GRAND TOTAL", bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
set_cell(ws2, r_gt, 3, 350, bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
set_cell(ws2, r_gt, 4, "100%", bold=True, fg_color=C_DARK_GREEN, font_color=C_WHITE)
for j in range(5, 10):
    set_cell(ws2, r_gt, j, "", fg_color=C_DARK_GREEN)

# Monthly week-by-week
months = [
    ("MONTH 1 — Foundation  (Day 1–30)", C_BLUE, C_BLUE_BG, [
        ("Wk 1","Day 1–7",  "Pharmacology",                "Autonomic NS, CVS drugs",          18,"9-11 AM: Pharma, 11:15–12: Jurisprudence"),
        ("Wk 2","Day 8–14", "Pharmacology",                "CNS, Antibiotics, Antidiabetics",  18,"Roz 2 sessions pharma"),
        ("Wk 3","Day 15–21","Pharmacology + Jurisprudence","Remaining Pharma + D&C Act",       20,"Jurisprudence 11:15–12:15"),
        ("Wk 4","Day 22–30","Jurisprudence + Pharmaceutics","Pharmacy Act, NDPS, Schedules",  22,"Pharmaceutics 12:15–1 PM"),
    ]),
    ("MONTH 2 — Core Building  (Day 31–60)", C_GREEN, C_MINT, [
        ("Wk 5","Day 31–37","Pharmaceutics",               "Dosage forms, Tablets, Injections",20,"Morning slot: Pharmaceutics"),
        ("Wk 6","Day 38–44","Pharmaceutics + Pharmacognosy","Remaining + Alkaloids, Glycosides",20,"Afternoon: Pharmacognosy"),
        ("Wk 7","Day 45–51","Pharmacognosy",               "Volatile oils, Crude drugs",       18,"Roz 1 hr Pharmacognosy"),
        ("Wk 8","Day 52–60","Biochemistry & Clinical Path.","Metabolism, Lab values",          22,"2:45–3:45 PM slot"),
    ]),
    ("MONTH 3 — Completion + Revision  (Day 61–90)", C_ORANGE, C_YELLOW_BG, [
        ("Wk 9", "Day 61–67","Anatomy + Hospital Pharmacy", "Body systems, Hospital formulary", 20,"9–10 AM: Anatomy"),
        ("Wk 10","Day 68–74","Pharma Chemistry + Community","Assay, Health programs",          22,"11:15 + 2:45 slots"),
        ("Wk 11","Day 75–81","Drug Store + GK + Revision",  "Rajasthan schemes, Store mgmt",   22,"Last hour: Full revision"),
        ("Wk 12","Day 82–90","FULL REVISION + MOCK TESTS",  "All subjects + Prev. year papers",28,"5 mock tests, 100 MCQ/day"),
    ]),
]

row = r_gt + 2
for mname, hcol, bgcol, weeks in months:
    ws2.merge_cells(f"A{row}:I{row}")
    ws2.row_dimensions[row].height = 24
    c = ws2[f"A{row}"]
    c.value = f"🗓️  {mname}"
    c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
    c.fill = fill(hcol)
    c.alignment = align("left", "center")
    row += 1

    for i, h in enumerate(["Week","Days","Subject","Topics","Classes","Done?","MCQ Target","Actual MCQ","Notes"],1):
        set_cell(ws2, row, i, h, bold=True, fg_color=hcol, font_color=C_WHITE)
    row += 1

    for i, (wk, days, subj, topics, classes, notes) in enumerate(weeks):
        ws2.row_dimensions[row].height = 20
        bg = bgcol if i%2==0 else C_WHITE
        set_cell(ws2, row, 1, wk, bold=True, fg_color=bg, font_color=hcol)
        set_cell(ws2, row, 2, days, fg_color=bg, font_color=C_GREY_DARK)
        set_cell(ws2, row, 3, subj, bold=True, fg_color=bg, h_align="left")
        set_cell(ws2, row, 4, topics, fg_color=bg, h_align="left", italic=True, font_color=C_GREY)
        set_cell(ws2, row, 5, classes, bold=True, fg_color=bg, font_color=C_ORANGE)
        set_cell(ws2, row, 6, "☐", fg_color=C_YELLOW_BG, font_color=C_AMBER, bold=True)
        set_cell(ws2, row, 7, classes*5, fg_color=bg, font_color=C_BLUE)
        set_cell(ws2, row, 8, "", fg_color=bg)
        set_cell(ws2, row, 9, notes, fg_color=bg, h_align="left", font_size=9, font_color=C_GREY)
        row += 1
    row += 1


# ═══════════════════════════════════════════════════════════════
# SHEET 3 — WEEKLY PROGRESS TRACKER
# ═══════════════════════════════════════════════════════════════
ws3 = wb.create_sheet("Weekly Progress")
ws3.sheet_view.showGridLines = False
for col, w in zip("ABCDEFGHIJ", [8,14,14,14,14,18,14,16,16,22]):
    ws3.column_dimensions[col].width = w

ws3.merge_cells("A1:J1")
ws3.row_dimensions[1].height = 44
c = ws3["A1"]
c.value = "📈  WEEKLY PROGRESS TRACKER — Rajasthan Pharmacist Exam  (12 Weeks)"
c.font = Font(name="Arial", bold=True, size=13, color=C_WHITE)
c.fill = fill(C_PURPLE)
c.alignment = align("center", "center")

row = 3
ws3.merge_cells(f"A{row}:J{row}")
ws3.row_dimensions[row].height = 20
c = ws3[f"A{row}"]
c.value = "🔵 Month 1 (Wk 1-4)  |  🟢 Month 2 (Wk 5-8)  |  🟡 Month 3 (Wk 9-12)"
c.font = Font(name="Arial", bold=True, size=11, color=C_WHITE)
c.fill = fill(C_GREY_DARK)
c.alignment = align("left", "center")

row += 1
for i, h in enumerate(["Week","Dates","Classes Done","MCQs Done","Accuracy %","Weak Topics","Hours Studied","Mock Score /150","Revision Done?","Next Week Plan"],1):
    set_cell(ws3, row, i, h, bold=True, fg_color=C_GREY_DARK, font_color=C_WHITE)

week_info = [
    ("Wk 1","Day 1-7"),  ("Wk 2","Day 8-14"),  ("Wk 3","Day 15-21"),("Wk 4","Day 22-30"),
    ("Wk 5","Day 31-37"),("Wk 6","Day 38-44"),  ("Wk 7","Day 45-51"),("Wk 8","Day 52-60"),
    ("Wk 9","Day 61-67"),("Wk 10","Day 68-74"),("Wk 11","Day 75-81"),("Wk 12","Day 82-90"),
]
m_bg = [C_BLUE_BG]*4 + [C_MINT]*4 + [C_YELLOW_BG]*4
for i, (wk, dates) in enumerate(week_info):
    r = row + 1 + i
    ws3.row_dimensions[r].height = 22
    bg = m_bg[i]
    set_cell(ws3, r, 1, wk, bold=True, fg_color=bg, font_color=C_PURPLE)
    set_cell(ws3, r, 2, dates, fg_color=bg, font_color=C_GREY_DARK)
    for j in range(3, 11):
        set_cell(ws3, r, j, "", fg_color=bg)


# ═══════════════════════════════════════════════════════════════
# SHEET 4 — QUICK REFERENCE CARD
# ═══════════════════════════════════════════════════════════════
ws4 = wb.create_sheet("Quick Reference")
ws4.sheet_view.showGridLines = False
for col, w in zip("ABCDE", [4,26,32,30,26]):
    ws4.column_dimensions[col].width = w

ws4.merge_cells("A1:E1")
ws4.row_dimensions[1].height = 44
c = ws4["A1"]
c.value = "⚡  QUICK REFERENCE — Key Topics, Important Values & Books"
c.font = Font(name="Arial", bold=True, size=14, color=C_WHITE)
c.fill = fill(C_AMBER)
c.alignment = align("center", "center")

row = 3
for i, h in enumerate(["#","Subject","Important Drugs / Topics","Key Facts / Values","Best Books"],1):
    set_cell(ws4, row, i, h, bold=True, fg_color=C_GREY_DARK, font_color=C_WHITE)

qr = [
    ("Pharmacology", C_RED,
     "Autonomic: Atropine, Neostigmine, Adrenaline\nCVS: Digoxin, Amlodipine, Atenolol, Enalapril\nCNS: Diazepam, Phenytoin, Morphine, Haloperidol\nAntibiotics: Amoxicillin, Ciprofloxacin, Gentamicin\nAntidiabetics: Metformin, Glibenclamide, Insulin\nNSAIDs: Aspirin, Ibuprofen, Diclofenac",
     "Antidotes:\n• Organophosphate → Atropine + PAM\n• Morphine OD → Naloxone\n• Paracetamol OD → N-Acetylcysteine\n• Iron OD → Deferoxamine\n• Heparin OD → Protamine sulfate\n• Warfarin OD → Vit K / FFP",
     "KD Tripathi - Pharmacology\nRS Satoskar\nRL Miglani MCQ Book"),

    ("Pharmaceutical Jurisprudence", C_BLUE_DARK,
     "Drug Schedules:\n• Schedule H = Rx only\n• Schedule H1 = Antibiotics + special record\n• Schedule X = Habit-forming (30-day limit)\n• Schedule G = Caution label\n• Schedule C & C1 = Biologicals\n• Schedule Y = Clinical trials",
     "Important Acts:\n• Drugs & Cosmetics Act 1940 + Rules 1945\n• Pharmacy Act 1948 (PCI registration)\n• NDPS Act 1985\n• Drugs (Price Control) Order\n• Consumer Protection Act\nPenalty: Adulteration = up to 10 yrs jail",
     "Pharmaceutical Jurisprudence - Mithal\nOfficial acts (free govt. PDF)"),

    ("Pharmaceutics", C_TEAL,
     "Dosage Forms:\n• Tablets: DC, wet granulation, dry granulation\n• Capsules: Hard gelatin, soft gelatin\n• Injections: IV, IM, SC — pyrogen-free\n• Ointments: W/O and O/W bases\n• Suspensions: Flocculated vs deflocculated\n• Aerosols: MDI propellants",
     "Key Values:\n• Autoclave: 121°C / 15 min (moist heat)\n• Dry heat: 160°C / 1 hr\n• Isotonic NaCl: 0.9%\n• Isotonic dextrose: 5%\n• Pyrogen test: Rabbit test / LAL test\n• BCS Class I = High sol + High perm",
     "Lachman & Lieberman\nRemington's Pharmaceutical Sciences"),

    ("Pharmacognosy", C_GREEN,
     "Alkaloids:\n• Opium (Papaver) → Morphine, Codeine\n• Cinchona → Quinine, Quinidine\n• Rauwolfia → Reserpine\n• Belladonna → Atropine\n• Ergot → Ergotamine\nGlycosides:\n• Digitalis → Digoxin (cardiac)\n• Senna → Sennosides (laxative)",
     "Evaluation tests:\n• Ash value: Total, acid-insoluble, water-soluble\n• Moisture content (Loss on drying)\n• Extractive values\n• Foreign matter test\nTLC Rf values used for identification\nWHO guidelines for herbal quality",
     "CK Kokate - Pharmacognosy\nTyler, Brady & Robbers"),

    ("Biochemistry + Physiology", C_PURPLE,
     "Normal Lab Values:\n• Fasting glucose: 70–110 mg/dL\n• HbA1c: Normal <5.7%, DM >6.5%\n• Hb: Male 13–17 g/dL, Female 12–15\n• Creatinine: 0.6–1.2 mg/dL\n• Total Cholesterol: <200 mg/dL\n• BP: 120/80 mmHg (normal)",
     "Key Pathways:\n• Glycolysis: Glucose → 2 Pyruvate (2 ATP)\n• TCA Cycle: 38 ATP total\n• Urea cycle: NH3 → Urea (liver)\n• Liver enzymes: ALT (SGPT), AST (SGOT)\n• INR: Coagulation test\n• GFR: Kidney function (normal >90 mL/min)",
     "Harper's Biochemistry\nGanong's Review of Medical Physiology"),
]

for i, (subj, color, topics, facts, books) in enumerate(qr):
    r = row + 1 + i
    ws4.row_dimensions[r].height = 105
    set_cell(ws4, r, 1, str(i+1), fg_color=C_GREY_LIGHT, bold=True, font_color=C_GREY_DARK)
    set_cell(ws4, r, 2, subj, bold=True, fg_color=color, font_color=C_WHITE, v_align="top", h_align="left")
    set_cell(ws4, r, 3, topics, fg_color=C_MINT if i%2==0 else C_WHITE,
             h_align="left", v_align="top", wrap=True, font_size=9)
    set_cell(ws4, r, 4, facts, fg_color=C_LIGHT_BLUE if i%2==0 else C_WHITE,
             h_align="left", v_align="top", wrap=True, font_size=9)
    set_cell(ws4, r, 5, books, fg_color=C_YELLOW_BG, h_align="left", v_align="top",
             wrap=True, font_size=9, italic=True, font_color=C_GREY)

# Footer
r_f = row + 1 + len(qr) + 1
ws4.merge_cells(f"A{r_f}:E{r_f}")
ws4.row_dimensions[r_f].height = 30
c = ws4[f"A{r_f}"]
c.value = "💊  Roz 9 AM se 5 PM tak padho, MCQs solve karo, aur revision mat chhodo — Rajasthan Pharmacist exam zaroor clear hoga! 🎯"
c.font = Font(name="Arial", bold=True, size=12, color=C_WHITE)
c.fill = fill(C_DARK_GREEN)
c.alignment = align("center", "center")


# ── Save ──
path = "/tmp/workspace/raj-pharmacist/Rajasthan_Pharmacist_9AM_5PM_Template.xlsx"
wb.save(path)
print(f"Saved: {path}")