require_once '../modelo/utilidades/Conexion.php';
require_once '../modelo/utilidades/BackUp.php';
require_once '../modelo/dao/BackupDAO.php';
require_once '../facades/FacadeBackup.php';
//  Generar BackUp por tablas
if (isset($_POST['backUpTablas'])) {
    $fBack = new FacadeBackup();
    $fecha = date('_d-m-Y_h-i-s');
    $table_name = $_POST['tablas'];
    $tipo_archivo = $_POST['tipo'];
    $rute = $_SERVER['DOCUMENT_ROOT'];
    $bacup_file = $rute . '/BackUp/' . $table_name . $fecha . '.' . $tipo_archivo;
    $mensaje = $fBack->BackupTablas($table_name);
    header("location: ../vista/backup?mensaje=" . $mensaje);
} else {
    if (isset($_POST['backUpGeneral'])) {
        $fBack = new FacadeBackup();
        $datos = $fBack->Backup_Database();
        $mensaje = "Backup generado con éxtio";
        header("location: ../vista/backup?mensaje=" . $mensaje);
    } else {
        if (isset($_GET['idDownload'])) {
            $enlace = $_SERVER["DOCUMENT_ROOT"] . '/BackUp/' . $_GET['idDownload'];
            header("Content-Disposition: attachment; filename={$enlace} ");
            header("Content-Type: application/force-download");
            header("Content-Length: " . filesize($enlace));
            readfile($enlace);
        }
    }
}
?>
     
           <div class="container">
                <div class="row"> 
                    <span class="animationSandbox">
                      <h1 style=" font-size:30px;font-weight: bold;
                    text-align: center;
                    font-family:sans-serif;   
                    color: #83AF44;" class="animated zoomIn">Generación de BackUp's</h1>
                    </span>
                <hr>
                <?php 
require_once '../modelo/utilidades/Conexion.php';
require_once '../modelo/dao/BackupDAO.php';
require_once '../facades/FacadeBackup.php';
$fBack = new FacadeBackup();
$tablas = $fBack->listarTablas();
?>
  
                <div class="row">
                     <form rol="form" class="animated fadeInDown" method="post" action="../controlador/ControladorBackUp.php" >
                        <div class="form-group">
                             <label for="reportType" >BackUp por tablas:</label>
                                <select name="tablas" class="form-control" required>
                                    <option value="" disabled selected>Seleccione una tabla</option>
                                   <?php 
foreach ($tablas as $tabla) {
    echo '<option value="' . $tabla['Tables_in_ges_productivitymanager'] . '">' . $tabla['Tables_in_ges_productivitymanager'] . '</option>';
}
?>
                                </select>