window.location='index.php';";
}
$estado = EstadoData::getAll();
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
$con = Database::getCon();
$etnias = $con->query("SELECT * from etnia_type");
$discapacidad = $con->query("SELECT * from disability_type");
$professions = $con->query("SELECT * from professions order by p_name");
$occupations = $con->query("SELECT * from occupations order by p_name");
$user_brigade_id = $_GET["id"];
$sql = "SELECT
final_users.id as user_id,
user_brigades.id as user_brigade_id,
final_users.user_estado as estado,
brigades.info_cod as info_cod,
brigades.nombre as brigada,
final_users.user_has_document as user_has_document,
final_users.user_nationality as user_nationality,
final_users.user_nombres as primer_nombre,
final_users.user_nombre_2 as segundo_nombre,
final_users.user_apellidos as primer_apellido,
final_users.user_apellido_2 as segundo_apellido,
final_users.user_correo as correo,
final_users.user_estado as estado,
final_users.user_municipio as u_municipio,
user_brigades.parroquia as parroquia,
user_brigades.ciudad as ciudad,
user_brigades.comunidad as comunidad,
user_brigades.fk_id_brigade,
final_users.red_x as red_x,
final_users.red_facebook as red_facebook,
final_users.red_instagram as red_instagram,
final_users.red_linkedin as red_linkedin,
final_users.red_youtube as red_youtube,
final_users.red_whatsapp as red_whatsapp,
final_users.red_telegram as red_telegram,
final_users.red_tiktok as red_tiktok,
final_users.red_snapchat as red_snapchat,
final_users.red_pinterest as red_pinterest,
final_users.user_has_document as cedulado,
final_users.user_dni as cedula,
final_users.user_f_nacimiento as f_nacimiento,
final_users.user_edad as edad,
final_users.user_telefono as telefono,
final_users.user_fecha_reg as fecha_reg
FROM final_users INNER JOIN user_brigades ON final_users.id = user_brigades.fk_id_user INNER JOIN brigades ON user_brigades.fk_id_brigade = brigades.id WHERE user_brigades.id = $user_brigade_id";
$base = new DatabasePg();
$conn = $base->connectPg();
$user = FinalUsersData::getBySQLPg($sql)[0];
// var_dump(value: $user);
$nombre_estado = $user["estado"];
$municipio = $user["u_municipio"];
$parroquia = $user["parroquia"];
$estado_id = EstadoData::getByNmae("'$nombre_estado'")->id_estado;
// $sql = "select * from municipios where id_estado=$estado_id";
// $municipios = MunicipioData::getBySQL($sql);
// $nombre_municipio = $user["municipio"];
// $user_municipio_id = MunicipioData::getByName("'$nombre_municipio'")->id_municipio;
// $sql = "select * from parroquias where id_municipio=$user_municipio_id";
// $parroquias = ParroquiaData::getBySQL($sql);
// $sql = "select * from ciudades where id_estado=$estado_id";
// $ciudades = ParroquiaData::getBySQL($sql);
$row_table = $conn->prepare("SELECT * from brigades where estado = '$nombre_estado' ");
$row_table->execute();
$brigadas = $row_table->fetchAll(PDO::FETCH_ASSOC);
$is_new = "0";
if (isset($_GET['new'])) {
$is_new = $_GET["new"];
}
?>