import os
import sys
import base64
import subprocess
import shutil

GESTION_DIR = r"c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION"
LOGO_PATH = os.path.join(GESTION_DIR, "logo_raul.png")
OUTPUT_HTML = os.path.join(GESTION_DIR, "reportes", "Formulario_Movimientos_Entre_Almacenes_A4_Apaisado.html")
OUTPUT_PDF_DOCS = os.path.join(GESTION_DIR, "documentacion raul asencio", "Formulario_Movimientos_Entre_Almacenes_A4_Apaisado.pdf")
OUTPUT_PDF_REPS = os.path.join(GESTION_DIR, "reportes", "Formulario_Movimientos_Entre_Almacenes_A4_Apaisado.pdf")

# Read logo as base64
logo_b64 = ""
if os.path.exists(LOGO_PATH):
    with open(LOGO_PATH, "rb") as f:
        logo_b64 = base64.b64encode(f.read()).decode("utf-8")

logo_tag = f'<img src="data:image/png;base64,{logo_b64}" class="logo-img" alt="Raúl Asencio">' if logo_b64 else '<div class="logo-fallback">RAÚL ASENCIO</div>'

# Generate 25 rows to maximize the A4 Landscape sheet
TOTAL_ROWS = 25
rows_html = []
for i in range(1, TOTAL_ROWS + 1):
    rows_html.append(f"""
    <tr>
        <td class="col-num">{i}</td>
        <td class="col-fecha"></td>
        <td class="col-destino"></td>
        <td class="col-articulo"></td>
        <td class="col-lote"></td>
        <td class="col-uds"></td>
        <td class="col-retira"></td>
    </tr>
    """)
table_body = "\n".join(rows_html)

html_content = f"""<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<title>Registro de Movimientos entre Almacenes - Raúl Asencio Pastelerías</title>
<style>
    @page {{
        size: A4 landscape;
        margin: 5mm 7mm 4mm 7mm;
    }}
    * {{
        box-sizing: border-box;
        -webkit-print-color-adjust: exact;
        print-color-adjust: exact;
    }}
    html, body {{
        margin: 0;
        padding: 0;
        font-family: 'Segoe UI', Arial, Helvetica, sans-serif;
        color: #1a1a1a;
        background-color: #ffffff;
        font-size: 8.5pt;
    }}
    .sheet {{
        width: 100%;
        display: block;
    }}

    /* HEADER */
    .header-table {{
        width: 100%;
        border-collapse: collapse;
        margin-bottom: 4px;
    }}
    .header-table td {{
        vertical-align: middle;
        padding: 0 4px;
    }}
    .logo-container {{
        width: 22%;
    }}
    .logo-img {{
        max-height: 40px;
        max-width: 165px;
        object-fit: contain;
    }}
    .logo-fallback {{
        font-weight: 800;
        font-size: 14pt;
        letter-spacing: 1px;
        color: #632d16;
    }}
    .title-container {{
        width: 53%;
        text-align: center;
    }}
    .title-main {{
        font-size: 13pt;
        font-weight: 800;
        letter-spacing: 0.6px;
        color: #2b1810;
        text-transform: uppercase;
        margin: 0;
        line-height: 1.15;
    }}
    .title-sub {{
        font-size: 7.5pt;
        font-weight: 600;
        color: #555;
        margin-top: 2px;
        letter-spacing: 0.3px;
    }}
    .folio-box {{
        width: 100%;
        border: 1.2px solid #2b1810;
        border-radius: 4px;
        padding: 3px 6px;
        background-color: #faf7f4;
        font-size: 7.5pt;
    }}
    .folio-row {{
        display: flex;
        justify-content: space-between;
        margin-bottom: 2px;
    }}
    .folio-row:last-child {{
        margin-bottom: 0;
    }}
    .folio-label {{
        font-weight: 700;
        color: #2b1810;
    }}
    .folio-dots {{
        flex-grow: 1;
        border-bottom: 1px dotted #888;
        margin-left: 5px;
        height: 10px;
    }}

    /* ORIGIN METADATA BAR */
    .metadata-bar {{
        width: 100%;
        border: 1.2px solid #a89485;
        border-radius: 3px;
        background-color: #faf8f5;
        padding: 3px 8px;
        margin-bottom: 5px;
        display: flex;
        gap: 14px;
        font-size: 8pt;
    }}
    .meta-field {{
        display: flex;
        align-items: flex-end;
    }}
    .meta-field.flex-1 {{ flex: 1.4; }}
    .meta-field.flex-2 {{ flex: 1.2; }}
    .meta-field.flex-3 {{ flex: 1.1; }}
    .meta-field.flex-4 {{ flex: 0.6; }}
    .meta-label {{
        font-weight: 700;
        color: #2b1810;
        white-space: nowrap;
        margin-right: 5px;
        font-size: 8pt;
    }}
    .meta-line {{
        flex-grow: 1;
        border-bottom: 1.2px solid #444;
        height: 11px;
    }}

    /* MAIN MOVEMENT TABLE */
    .movement-table {{
        width: 100%;
        border-collapse: collapse;
        table-layout: fixed;
    }}
    .movement-table th {{
        background: linear-gradient(180deg, #3d2314 0%, #2b1810 100%);
        color: #ffffff;
        font-weight: 700;
        font-size: 7.5pt;
        text-align: center;
        padding: 4px 2px;
        border: 1px solid #1a0f0a;
        letter-spacing: 0.2px;
        text-transform: uppercase;
    }}
    .movement-table th small {{
        display: block;
        font-size: 6pt;
        font-weight: 400;
        opacity: 0.9;
        text-transform: none;
    }}
    .movement-table td {{
        border: 1px solid #666666;
        height: 23px; /* Espaciado cómodo y uniforme para 25 filas */
        padding: 1px 4px;
        vertical-align: middle;
        font-size: 8pt;
    }}
    .movement-table tbody tr:nth-child(even) {{
        background-color: #fcfbf9;
    }}

    /* Column Widths (Total 100%) */
    .col-num     {{ width: 3.5%; text-align: center; font-weight: bold; color: #444; background-color: #f2eee8; }}
    .col-fecha   {{ width: 8%; text-align: center; }} /* Fecha */
    .col-destino {{ width: 18%; }} /* Para dónde va */
    .col-articulo{{ width: 35.5%; }} /* Artículo */
    .col-lote    {{ width: 13%; }} /* Lote */
    .col-uds     {{ width: 7%; text-align: right; }} /* Unidades */
    .col-retira  {{ width: 15%; }} /* Persona que retira */

    .total-row td {{
        background-color: #e5ded4 !important;
        font-weight: 800;
        border-top: 2px solid #2b1810;
        height: 20px;
        font-size: 8pt;
    }}
</style>
</head>
<body>
<div class="sheet">
    <!-- HEADER -->
    <table class="header-table">
        <tr>
            <td class="logo-container">
                {logo_tag}
            </td>
            <td class="title-container">
                <h1 class="title-main">Registro de Movimientos entre Almacenes</h1>
                <div class="title-sub">HOJA DE CONTROL DE TRASPASOS INTERNOS DE MERCANCÍA Y TRAZABILIDAD (EN PAPEL)</div>
            </td>
            <td style="width: 25%;">
                <div class="folio-box">
                    <div class="folio-row">
                        <span class="folio-label">FOLIO / Nº HOJA:</span>
                        <span class="folio-dots"></span>
                    </div>
                    <div class="folio-row">
                        <span class="folio-label">FECHA DE SALIDA:</span>
                        <span class="folio-dots"></span>
                    </div>
                    <div class="folio-row">
                        <span class="folio-label">TURNO / HORA:</span>
                        <span class="folio-dots"></span>
                    </div>
                </div>
            </td>
        </tr>
    </table>

    <!-- ORIGIN BAR -->
    <div class="metadata-bar">
        <div class="meta-field flex-1">
            <span class="meta-label">ALMACÉN / ORIGEN:</span>
            <span class="meta-line"></span>
        </div>
        <div class="meta-field flex-2">
            <span class="meta-label">RESPONSABLE SALIDA:</span>
            <span class="meta-line"></span>
        </div>
        <div class="meta-field flex-3">
            <span class="meta-label">VEHÍCULO / CONDUCTOR:</span>
            <span class="meta-line"></span>
        </div>
        <div class="meta-field flex-4">
            <span class="meta-label">HORA:</span>
            <span class="meta-line"></span>
        </div>
    </div>

    <!-- MAIN MOVEMENT TABLE -->
    <table class="movement-table">
        <thead>
            <tr>
                <th class="col-num">Nº</th>
                <th class="col-fecha">Fecha <small>(dd/mm)</small></th>
                <th class="col-destino">Destino <small>(¿Para dónde va? Tienda / Obrador)</small></th>
                <th class="col-articulo">Artículo <small>(Código / Descripción completa del producto o materia prima)</small></th>
                <th class="col-lote">Lote <small>(Trazabilidad / Lote)</small></th>
                <th class="col-uds">Unidades <small>(Cantidad / Uds.)</small></th>
                <th class="col-retira">Persona que Retira <small>(Nombre / Firma / Observaciones)</small></th>
            </tr>
        </thead>
        <tbody>
            {table_body}
            <tr class="total-row">
                <td colspan="5" style="text-align: right; padding-right: 8px;">TOTAL UNIDADES TRASPASADAS:</td>
                <td class="col-uds" style="text-align: right; padding-right: 4px;"></td>
                <td></td>
            </tr>
        </tbody>
    </table>
</div>
</body>
</html>
"""

# Write HTML file
os.makedirs(os.path.dirname(OUTPUT_HTML), exist_ok=True)
with open(OUTPUT_HTML, "w", encoding="utf-8") as f:
    f.write(html_content)
print(f"HTML generado: {OUTPUT_HTML}")

# Render to PDF using headless Edge
edge_exe = r"C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe"
if not os.path.exists(edge_exe):
    edge_exe = r"C:\Program Files\Microsoft\Edge\Application\msedge.exe"

os.makedirs(os.path.dirname(OUTPUT_PDF_DOCS), exist_ok=True)
os.makedirs(os.path.dirname(OUTPUT_PDF_REPS), exist_ok=True)

cmd = [
    edge_exe,
    "--headless",
    "--disable-gpu",
    "--no-pdf-header-footer",
    f"--print-to-pdf={OUTPUT_PDF_DOCS}",
    OUTPUT_HTML
]

print("Generando PDF con Edge headless...")
result = subprocess.run(cmd, capture_output=True, text=True)
if os.path.exists(OUTPUT_PDF_DOCS) and os.path.getsize(OUTPUT_PDF_DOCS) > 0:
    print(f"PDF generado exitosamente en: {OUTPUT_PDF_DOCS} ({os.path.getsize(OUTPUT_PDF_DOCS)} bytes)")
    # Copiar también a reportes
    shutil.copy2(OUTPUT_PDF_DOCS, OUTPUT_PDF_REPS)
    print(f"Copia guardada en: {OUTPUT_PDF_REPS}")
else:
    print("Error generando PDF:")
    print(result.stdout)
    print(result.stderr)
    sys.exit(1)
