<?php
    session_start();
    $usuarioSession = $_SESSION['USUARIO'];
    $grupo = $_SESSION['GRUPO'];
    $contacto = $_SESSION['CONTACTO'];
    $awa_session_id = $_SESSION['AWA_SESION_ID'];
    include('../includes/conex.php');
    include('../includes/eat.php');
    if(!isset($usuarioSession) or $awa_session_id != $awa_id)
    {
      eatCookies();
      header('Location:../index.php');
    }
    if(isset($_COOKIE['usuario']) AND $_COOKIE['usuario'] != $staticUsu )
    {
      eatCookies();
      header('Loction:../index.php');
    }
    if(isset($_COOKIE['idioma']))
    {
      include('../lg/LG_' . $_COOKIE['idioma'] . '.php');
    }
    else
    {
      include('../lg/LG_SP.php');
    }
    
    $codigo = htmlspecialchars(mysqli_real_escape_string($con,$_POST['codigo']));
    $var = "";
    $sql = 'SELECT C.CODIGO AS CODIGO,C.NOMBRE,C.APELLIDO1,C.MOSTRAR,C.EMAIL1,O.CONTACTO AS CONTACTO,O.ORGANIZACION AS ORG
    FROM CONTACTOS C
    LEFT JOIN CONTACTOS_ORGANIZACIONES O ON C.CODIGO = O.CONTACTO
    WHERE C.ACTIVO = 1
    ORDER BY NOMBRE ASC';
    $res = $con->query($sql);
    while($fila = $res->fetch_array())
    {   
        echo '
            <tr>
                <td>
                <div class="custom-control custom-checkbox mr-sm-2 text-center" style="cursor:default;" >
                    <input type="checkbox" class="custom-control-input" onclick="checkBox(' . $fila['CODIGO'] . ')" id="customControlAutosizing' . $fila['CODIGO'] . '" name="agendaRelacionCheck" value="' . $codigo . '" >
                    <label class="custom-control-label" for="customControlAutosizing' . $fila['CODIGO'] . '" style="cursor:pointer;"></label>
                </div>
                </td>
                <td>' . utf8_decode($fila['NOMBRE']) . ' ' . utf8_encode($fila['APELLIDO1']) . '</td>
                <td>' . $fila['EMAIL1'] . '</td>
            </tr>';
    }
?>

