<?php
require 'db.php';
?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>Ver Usuario</title>
        <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet" integrity="
        sha384-QWTKZyjpPEjISv5WaRU9OFeRpok6YctnYmDr5pNlyT2bRjXh0JMhjY6hW+ALEwIH" crossorigin="anonymous">
        <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
    </head>
    <body>
        <?php include('navbar.php'); ?>
        <div class="container mt-5">
            <div class="row">
                <div class="col-md-12">
                    <div class="card">
                        <div class="card-header">
                            <h4>Ver Región
                                <a href="gestionar_regiones.php" class="btn btn-danger float-end"><span class="bi bi-arrow-left"></span>&nbsp;Volver</a>
                            </h4>
                        </div>
                        <div class="card-body">
                            <?php
                            if (isset($_GET['idRegion'])) {
								$idRegion = mysqli_real_escape_string($conn, $_GET['idRegion']);
                                $sql = "SELECT idRegion, idPais, nombreRegion, codRegion FROM regiones WHERE idRegion ='$idRegion' AND vigente = 1";
                                $query = mysqli_query($conn, $sql);
                                
                            if(mysqli_num_rows($query)> 0) {
                                $region = mysqli_fetch_array($query);
								
								$idPais = $region['idPais'];
								$sql = "SELECT nombrePais FROM paises WHERE idPais ='$idPais' AND vigente = 1";
								$query = mysqli_query($conn, $sql);
								if(mysqli_num_rows($query)> 0) {
									$pais = mysqli_fetch_array($query);
									$nombrePais = $pais['nombrePais'];
								} else {
									$nombrePais = "País no encontrado";
								}
								
                            ?>
                            <div class="mb-3">
                                <label><b>Nombre del País</b></label>
                                <p class="form-control">
                                    <?php echo $nombrePais; ?>
                                </p>
                            </div>
                            <div class="mb-3">
                                <label><b>Nombre de la Región</b></label>
                                <p class="form-control">
                                    <?php echo $region['nombreRegion']; ?>
                                </p>
                            </div>
                            <div class="mb-3">
                                <label><b>Código de la Región</b></label>
                                <p class="form-control">
                                    <?php echo $region['codRegion']; ?>
                                </p>
                            </div>
                            <?php
                            } else {
                            echo '<h5>No se ha encontrado la Región</h5>';
                            }   
                        } 
                        ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>

        <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js" integrity="
        sha384-YvpcrYf0tY3lHB60NNkmXc5s9fDVZLESaAA55NDzOxhy9GkcIdslK1eN7N6jIeHz" crossorigin="anonymous"></script>
  </body>
</html>
