"2024-1,2024-2,2025-1,2025-2,2026-1,2026-2,2027-1,2027-2",
"2020-2023" => "2020-1,2020-2,2021-1,2021-2,2022-1,2022-2,2023-1,2023-2",
"2015-2019" => "2015-1,2015-2,2016-1,2016-2,2017-1,2017-2,2018-1,2018-2,2019-1,2019-2"
];
// Mostrar los informes divididos por periodo
foreach ($periodos as $periodo_label => $periodo_values) {
$periodo_array = explode(",", $periodo_values);
echo "
Informes Dirección Periodo $periodo_label
";
echo "
| Director |
Descripción |
Periodo |
Acciones |
";
$sql = "SELECT * FROM informes WHERE periodo IN ('" . implode("','", $periodo_array) . "') ORDER BY periodo DESC";
try {
$stmt = $conexion->prepare($sql);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
echo "";
echo "| " . htmlspecialchars($row['nombre']) . " | ";
echo "" . htmlspecialchars($row['descripcion']) . " | ";
echo "" . htmlspecialchars($row['periodo']) . " | ";
echo "
PDF
| ";
echo "
";
}
} catch (PDOException $e) {
echo "Error en la consulta: " . $e->getMessage();
}
echo "
";
}
?>