<?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');
include('../includes/historial.php');
include('../class/Static.php');
include('../class/Schema.php');
include('../class/Agenda.php');
include('../class/Rgpd.php');
include('../class/PuzzleHTML.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');
}
$RGPD = new RGPD($con);
$Schema = new Schema($con);
$Agenda = new Agenda($con);
$value = Statics::SafeInput($con, $_POST['value']);
$request = Statics::SafeInput($con, $_POST['request']);
$values = [];


if($request == 1) {
    //Buscar contacto
    $subRequest = Statics::SafeInput($con, $_POST['subRequest']);
    if($subRequest == 1) {
        $word = "$value%";
        $res = $Schema->executeQuery('SELECT CODIGO, MOSTRAR, TLFNO1, EMAIL1, NIF 
        FROM CONTACTOS
        WHERE MOSTRAR LIKE ?
        OR TLFNO1 LIKE ?
        OR NIF LIKE ?
        OR EMAIL1 LIKE ?', 'ssss', [$word, $word, $word, $word]);
        if($res->num_rows) {
            while($row = $res->fetch_array()) {
                $values[] = [
                    'id'        =>      $row['CODIGO'],
                    'show'      =>      $row['MOSTRAR'],
                    'email'     =>      $row['EMAIL1'],
                    'phone'     =>      $row['TLFNO1']       
                ];
            }
        }
        echo json_encode($values);
    } elseif($subRequest == 2) {
        $res = $Schema->executeQuery('SELECT CODIGO, NOMBRE, APELLIDO1, APELLIDO2, MOSTRAR, TLFNO1, EMAIL1, NIF, DIRECCION_CP, RGPD_1
        FROM CONTACTOS
        WHERE CODIGO = ?', 'i', [$value]);
        if($res->num_rows) {
            $row = $res->fetch_array();
            $values = [
                'name'              =>      $row['NOMBRE'],
                'lastName'          =>      $row['APELLIDO1'],
                'secondLastName'    =>      $row['APELLIDO2'],
                'show'              =>      $row['MOSTRAR'],
                'phone'             =>      intval($row['TLFNO1']),
                'email'             =>      $row['EMAIL1'],
                'cardId'            =>      $row['NIF'],
                'address'           =>      $row['DIRECCION_CP'],
                'rgpd'              =>      $row['RGPD_1']
            ];
        }
        echo json_encode($values);
    } elseif($subRequest == 3) {
        $contacto = Statics::SafeInput($con, $_POST['contacto']);
        $control = Statics::SafeInput($con, $_POST['control']);
        $Schema->executeQuery('UPDATE CONTACTOS SET RGPD_' . $value . ' = ? WHERE CODIGO = ?', 'ii', [$control, $contacto]);
    } elseif($subRequest == 4) {
        $stauts = FALSE;
        $codigo_contacto = Statics::max_codigo($con, 'CONTACTOS');
        $Agenda->set_tipo_contacto(1);
        $Agenda->set_codigo_usuario($codigo_contacto);
        $Agenda->set_nombre(Statics::SafeInput($con, $_POST['name']));
        $Agenda->set_apellido(Statics::SafeInput($con, $_POST['lastName']));
        $Agenda->set_apellido2(Statics::SafeInput($con, $_POST['secondLastName']));
        $Agenda->set_email(Statics::SafeInput($con, $_POST['email']));
        $Agenda->set_telefono(Statics::SafeInput($con, $_POST['phone']));
        $Agenda->set_nif(Statics::SafeInput($con, $_POST['cardId']));
        $Agenda->set_direccion(Statics::SafeInput($con, $_POST['address']));
        $Agenda->set_usuario_session($usuarioSession);
        if($Agenda->insert_contacto()) {
            echo json_encode($codigo_contacto);
        } 
    } elseif($subRequest == 5) {
        $RGPD->update_rgpd($value, $_POST['rgpd']); 
    } else {
        echo "Error";
    }
} elseif($request == 2) {
    //Delete register
    $Agenda->set_codigo_usuario($value);
    $Agenda->set_activo(0);
    $Agenda->update_contacto();
    $values = ['status' => 1];
    echo json_encode($values);
} else {
    //Error
    echo "Error";
}

?>