import json
import fitz # PyMuPDF

with open('parsed_recipes.json', encoding='utf-8') as f:
    recipes = json.load(f)

print(f"Generating consolidated PDF for {len(recipes)} recipes...")

doc = fitz.open()

PREELABORADO_KEYWORDS = [
    'crema', 'yema', 'trufa', 'nata', 'gelatina', 'almíbar', 'almibar', 'glasa', 'glaseado',
    'praliné', 'praline', 'variegato', 'cobertura', 'masa madre', 'fondant', 'caramelo',
    'pasta de almendra', 'pasta de avellana', 'gianduja', 'preparado'
]

def is_preelaborado(recipe):
    name = recipe['name'].lower()
    fam = recipe['family'].lower()
    if 'cremas' in fam or 'nata' in fam or 'trufas' in fam or 'rellenos' in fam:
        return True
    for kw in PREELABORADO_KEYWORDS:
        if kw in name:
            return True
    return False

# Colors
C_NAVY = (26/255, 54/255, 93/255)
C_SLATE = (45/255, 55/255, 72/255)
C_BLUE_HEADER = (43/255, 108/255, 176/255)
C_ACCENT_BG = (235/255, 248/255, 255/255)
C_ZEBRA = (248/255, 250/255, 252/255)
C_BORDER = (203/255, 213/255, 225/255)
C_TEXT_DARK = (30/255, 41/255, 59/255)
C_TEXT_MUTED = (100/255, 116/255, 139/255)
C_WHITE = (1, 1, 1)
C_PREELAB_BG = (254/255, 252/255, 191/255) # light yellow

for r in recipes:
    preelab = is_preelaborado(r)
    page = doc.new_page(width=595.3, height=841.9) # A4 points
    
    # Header Banner
    page.draw_rect(fitz.Rect(30, 30, 565, 72), color=C_NAVY, fill=C_NAVY)
    page.insert_text(fitz.Point(45, 54), "RAÚL ASENCIO PASTELERÍAS", fontsize=15, fontname="helv", color=C_WHITE)
    page.insert_text(fitz.Point(45, 66), "FICHA TÉCNICA DE RECETA / FORMULACIÓN DE OBRADOR", fontsize=8.5, fontname="helv", color=(0.85, 0.9, 0.95))
    
    num_txt = f"RECETA Nº {r['num']}"
    page.insert_text(fitz.Point(450, 52), num_txt, fontsize=12, fontname="helv", color=C_WHITE)
    page.insert_text(fitz.Point(420, 66), f"{r['family'][:24]}", fontsize=8, fontname="helv", color=(0.8, 0.85, 0.9))
    
    # Meta Box: RECETA & PREELABORADO
    page.draw_rect(fitz.Rect(30, 78, 380, 106), color=C_BORDER, fill=C_ACCENT_BG)
    page.draw_rect(fitz.Rect(380, 78, 565, 106), color=C_BORDER, fill=C_PREELAB_BG if preelab else C_ACCENT_BG)
    
    page.insert_text(fitz.Point(40, 96), "RECETA:", fontsize=10, fontname="helv", color=C_TEXT_DARK)
    page.insert_text(fitz.Point(92, 96), f"{r['name'].upper()}", fontsize=11, fontname="helv", color=C_NAVY)
    
    si_mark = "[X]" if preelab else "[  ]"
    no_mark = "[X]" if not preelab else "[  ]"
    page.insert_text(fitz.Point(395, 96), f"¿ES PREELABORADO?  {si_mark} SÍ    {no_mark} NO", fontsize=10, fontname="helv", color=C_TEXT_DARK)
    
    # Sub Meta
    page.draw_rect(fitz.Rect(30, 106, 380, 126), color=C_BORDER, fill=C_WHITE)
    page.draw_rect(fitz.Rect(380, 106, 565, 126), color=C_BORDER, fill=C_WHITE)
    page.insert_text(fitz.Point(40, 120), "FECHA REVISIÓN: 05/11/2026     RESPONSABLE: Obrador Raúl Asencio", fontsize=8, fontname="helv", color=C_TEXT_MUTED)
    page.insert_text(fitz.Point(395, 120), f"FUENTE: {r['source'][:28]}", fontsize=8, fontname="helv", color=C_TEXT_MUTED)
    
    # Table Header
    y_table = 138
    row_h = 19
    col_x = [30, 65, 340, 440, 565]
    
    page.draw_rect(fitz.Rect(30, y_table, 565, y_table + 20), color=C_BLUE_HEADER, fill=C_BLUE_HEADER)
    page.insert_text(fitz.Point(38, y_table + 14), "Nº", fontsize=8.5, fontname="helv", color=C_WHITE)
    page.insert_text(fitz.Point(80, y_table + 14), "INGREDIENTE / MATERIA PRIMA", fontsize=8.5, fontname="helv", color=C_WHITE)
    page.insert_text(fitz.Point(350, y_table + 14), "CANTIDAD", fontsize=8.5, fontname="helv", color=C_WHITE)
    page.insert_text(fitz.Point(455, y_table + 14), "UNIDAD / DETALLES", fontsize=8.5, fontname="helv", color=C_WHITE)
    
    curr_y = y_table + 20
    max_table_rows = 18
    
    for i in range(1, max_table_rows + 1):
        bg = C_ZEBRA if i % 2 == 0 else C_WHITE
        page.draw_rect(fitz.Rect(30, curr_y, 565, curr_y + row_h), color=C_BORDER, fill=bg)
        
        # Vertical gridlines
        for cx in col_x:
            page.draw_line(fitz.Point(cx, curr_y), fitz.Point(cx, curr_y + row_h), color=C_BORDER)
            
        page.insert_text(fitz.Point(42, curr_y + 13), str(i), fontsize=8, fontname="helv", color=C_TEXT_MUTED)
        
        ing_idx = i - 1
        if ing_idx < len(r['ingredients']):
            ing_data = r['ingredients'][ing_idx]
            page.insert_text(fitz.Point(75, curr_y + 13), ing_data['ingrediente'][:45], fontsize=8.5, fontname="helv", color=C_TEXT_DARK)
            page.insert_text(fitz.Point(365, curr_y + 13), ing_data['cantidad'], fontsize=8.5, fontname="helv", color=C_TEXT_DARK)
            
            u_str = ing_data['unidad']
            if ing_data['obs']:
                u_str += f" ({ing_data['obs']})" if u_str else ing_data['obs']
            page.insert_text(fitz.Point(448, curr_y + 13), u_str[:32], fontsize=7.5, fontname="helv", color=C_TEXT_MUTED)
            
        curr_y += row_h
        
    # Process / Notes section
    curr_y += 10
    page.draw_rect(fitz.Rect(30, curr_y, 565, curr_y + 18), color=C_SLATE, fill=C_SLATE)
    page.insert_text(fitz.Point(40, curr_y + 13), "MÉTODO DE ELABORACIÓN / PROCESO Y PARÁMETROS TÉCNICOS", fontsize=8.5, fontname="helv", color=C_WHITE)
    curr_y += 18
    
    proc_rect = fitz.Rect(30, curr_y, 565, 800)
    page.draw_rect(proc_rect, color=C_BORDER, fill=C_WHITE)
    
    proc_lines = []
    if r['proceso']:
        proc_lines.append(f"Proceso: {r['proceso'].strip()}")
    if r['notas']:
        proc_lines.extend(r['notas'])
    if not proc_lines:
        proc_lines.append("No se detallan instrucciones específicas en el manuscrito original.")
        
    page.insert_textbox(fitz.Rect(38, curr_y + 6, 555, 794), "\n".join(proc_lines), fontsize=8.5, fontname="helv", color=C_TEXT_DARK)

pdf_path = r'c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION\documentacion raul asencio\recetas\Recetario_Completo_Rellenado_Raul_Asencio.pdf'
doc.save(pdf_path)
print(f"Consolidated PDF saved successfully at: {pdf_path}")

