<?php
include("functions.php");
include("../head.php");

    $id = $_GET['id'];

    $query = "SELECT bar.id,id_barrio,logo,banner,latitud,longitud
    FROM barrios as bar
    INNER JOIN id_barrios as idb
    ON bar.id_barrio = idb.id WHERE bar.id = $id";


    $result = mysqli_query($conexion, $query);

    if ($conexion->connect_errno) {
    printf("Connect failed: %s\n", $conexion->connect_error);
    die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
    }

    $row = mysqli_fetch_assoc($result);

    $barrio_id = $row['id_barrio'];
    $logo = $row['logo'];
    $banner = $row['banner'];
    $latitud = $row['latitud'];
    $longitud = $row['longitud'];


if($_SERVER['REQUEST_METHOD'] === 'POST') {

    $id = $_GET['id'];

    $barrio = $_POST['barrio'];
    $latitud = $_POST['latitud'];
    $longitud = $_POST['longitud'];

    $uploadDir = '/wamp64/www/paula_ss/imagenes/';
    $logoTmp = $_FILES['logo']['tmp_name'];

    if ($_FILES['logo']['name'] === "") {

        $logoName = $logo;

    } else {

        $logoName = $_FILES['logo']['name'];

        if (move_uploaded_file($logoTmp, $uploadDir . $logoName)) {
            echo "El logo se subió correctamente.\n";
        } else {
            echo "El logo no pudo ser cargado\n";
        }

    }

    $uploadDir = '/wamp64/www/paula_ss/imagenes/';
    $bannerTmp = $_FILES['banner']['tmp_name'];

    if ($_FILES['banner']['name'] === "") {

        $bannerName = $banner;

    } else {

        $bannerName = $_FILES['banner']['name'];

        if (move_uploaded_file($bannerTmp, $uploadDir . $bannerName)) {
            echo "El banner se subió correctamente.\n";
        } else {
            echo "El banner no pudo ser cargado\n";
        }
    }

    //ob_start();
    //var_dump($_FILES);
    //$dump = ob_get_clean();
    //echo $dump;

    $query = "UPDATE barrios
   SET id_barrio = '$barrio',
   logo = '$logoName',
   banner = '$bannerName',
   latitud = '$latitud',
   longitud = '$longitud'
   WHERE id = $id";

    $result = mysqli_query($conexion, $query);

    if(!$result) {
        die('Query Failed: ' . $conexion->error);
    } else {
        echo"<script language='javascript'>window.location='../index.php'</script>;";
    }
}

?>

<?php
    $barrio_id = $row['id_barrio'];
    $logo = $row['logo'];
    $banner = $row['banner'];
    $latitud = $row['latitud'];
?>

<div class="container">
        <div class="table-wrapper">
            <div class="table-title">
                <div class="row">
                    <div class="col-sm-5">
                        <h2> Paula SS - Editar Barrio</h2>
                    </div>
                </div>
        </div>

       <?php include('form.php'); ?>

</div>

<script src = "../js/new.js"> </script>
<?php include('../footer.php'); ?>