import os import re filepath = r'c:\xampp\htdocs\Procurement\dashboard\index.php' with open(filepath, 'r', encoding='utf-8') as f: content = f.read() # 1. ADD PHP LOGIC php_logic = """ // ─── DATE FILTER LOGIC ───────────────────────────────────────────── $f_inicio = $_GET['inicio'] ?? ''; $f_fin = $_GET['fin'] ?? ''; $df = ""; $dp = []; if ($f_inicio && $f_fin) { $df = " AND fecha_creacion >= :inicio AND fecha_creacion <= :fin "; $dp = [':inicio' => $f_inicio . ' 00:00:00', ':fin' => $f_fin . ' 23:59:59']; } elseif ($f_inicio) { $df = " AND fecha_creacion >= :inicio "; $dp = [':inicio' => $f_inicio . ' 00:00:00']; } elseif ($f_fin) { $df = " AND fecha_creacion <= :fin "; $dp = [':fin' => $f_fin . ' 23:59:59']; } """ content = content.replace("// ═══════════════════════════════════════════════════════════════════\n// DATA QUERIES - All sections", php_logic + "\n// ═══════════════════════════════════════════════════════════════════\n// DATA QUERIES - All sections") # 2. INJECT SQL WHERE CLAUSES AND PARAMS # All queries end with "); # We can replace all `);` with `, $dp);` if they are `safeQuery` calls without params def query_replacer(match): full_call = match.group(0) # Check if we already have params if ', $dp' in full_call: return full_call # Inject the WHERE clause $df full_call = full_call.replace('FROM v_proceso_completo\n WHERE ', 'FROM v_proceso_completo\n WHERE 1=1 " . $df . " AND ') full_call = full_call.replace('FROM v_proceso_completo WHERE ', 'FROM v_proceso_completo WHERE 1=1 " . $df . " AND ') # In one query we have: "FROM ( SELECT TIMESTAMPDIFF... FROM v_proceso_completo WHERE ...) t" # The replacement above covers it because it replaces "FROM v_proceso_completo\n WHERE " # Replace ending to add $dp full_call = re.sub(r'("\s*\);)$', '", $dp);', full_call) return full_call # Find all safeQuery and safeQuerySingle calls content = re.sub(r'safeQuery(Single)?\(\$pdo, ".*?"\s*\);', query_replacer, content, flags=re.DOTALL) # 3. ADD UI FILTERS TO HTML ui_html = """

Resumen Ejecutivo

Visión general de KPIs principales de compras y abastecimiento

Limpiar
""" # Replace the first page-header (for Resumen Ejecutivo) content = content.replace("""

Resumen Ejecutivo

Visión general de KPIs principales de compras y abastecimiento

""", ui_html) # To make the title dynamic based on the section, we can update it via JS, but for now it's okay since the sidebar changes it via JS already. Wait, let's check how sections change. # Section change is done via `showSection()` in JS. We need to move the date filter outside of `
` so it applies to all sections, OR we just let the JS update the title. # Let's move the `date-filters` to be outside the section divs, at the very top of `.main`. ui_global = """

Resumen Ejecutivo

Visión general de KPIs principales de compras y abastecimiento

X Limpiar
""" # Insert ui_global right after `
` content = content.replace('
', '
\n' + ui_global) # Remove all individual `.page-header` divs from sections to avoid duplicate titles content = re.sub(r'
.*?
', '', content, flags=re.DOTALL) # Add JS logic to update global title js_logic = """ // Update global title const titles = { 'resumen': ['Resumen Ejecutivo', 'Visión general de KPIs principales de compras y abastecimiento'], 'tiempos': ['Análisis de Tiempos', 'Desglose del ciclo de vida de compras por etapa'], 'backlog': ['Backlog Operativo', 'Análisis de órdenes pendientes y antigüedad'], 'proveedores': ['Scorecard Proveedores', 'Rendimiento y tiempos de entrega por proveedor'], 'alertas': ['Alertas y Anomalías', 'Detección estadística de órdenes que exceden los tiempos normales'], 'tendencias': ['Tendencias', 'Evolución temporal del rendimiento de compras'], 'compradores': ['Compradores', 'Análisis de carga de trabajo y rendimiento por comprador'] }; if (titles[sectionId]) { document.getElementById('global-section-title').textContent = titles[sectionId][0]; document.getElementById('global-section-desc').textContent = titles[sectionId][1]; } // Add date filter params to sidebar links const urlParams = new URLSearchParams(window.location.search); const inicio = urlParams.get('inicio'); const fin = urlParams.get('fin'); """ content = content.replace("document.getElementById('sec-' + sectionId).classList.add('active');", "document.getElementById('sec-' + sectionId).classList.add('active');\n" + js_logic) # Fix the JavaScript onclicks so they don't lose the query parameters # The JS doesn't reload the page, it just hides/shows divs. So we don't need to append GET params to links. The form handles the GET params. with open(filepath, 'w', encoding='utf-8') as f: f.write(content) print("Dates applied!")