<?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('../class/Schema.php');
include('../class/Static.php');
include('../lg/config_vo.php');
include('../includes/historial.php');
include('../includes/functions.php');
include('../includes/esquemas.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');
}

$schema = new Schema($con);

//Datos del cliente
$cliente = Statics::SafeInput($con, $_POST['cliente']);
$sql = 'SELECT * FROM CONTACTOS WHERE CODIGO = ?';
$res = $schema->executeQuery($sql, 'i', [$cliente]);
$row = $res->fetch_array();


//Update RGPD
$var = '';
$key = 'i';
$value = 1;
$arrayValues = [];

$sql = "UPDATE CONTACTOS SET RGPD_1 = ?, RGPD_2 = ?, RGPD_3 = ?, RGPD_4 = ? WHERE CODIGO = ?";
$schema->executeQuery($sql, 'iiiii', [0, 0, 0, 0, $cliente]);


for($i = 0; $i < count($_POST['rgpd']); $i++)
{
    $rgpd = Statics::SafeInput($con, $_POST['rgpd'][$i]);

    $var .= $rgpd == 1 ? 'RGPD_1 = ?' : '';
    $key .= $rgpd == 1 ? 'i' : '';

    $var .= $rgpd == 2 ? ', RGPD_2 = ?' : '';
    $key .= $rgpd == 2 ? 'i' : '';

    $var .= $rgpd == 3 ? ', RGPD_3 = ?' : '';
    $key .= $rgpd == 3 ? 'i' : '';

    $var .= $rgpd == 4 ? ', RGPD_4 = ?' : '';
    $key .= $rgpd == 4 ? 'i' : '';


    array_push($arrayValues, $value);
    
}

array_push($arrayValues, $cliente);


$sql = 'UPDATE CONTACTOS SET ' . $var . ' WHERE CODIGO = ?';
$schema->executeQuery($sql, $key, $arrayValues);



//Create pdf
$location = '../ofertas/pdf/';
require_once __DIR__ . '../../vendor/autoload.php';
$mpdf = new \Mpdf\Mpdf();
$mpdf->showImageErrors = true;


$date = date('H:i:s d/m/Y');
$doc = '../ofertas/plantillas/justificante-rgpd.html';


//Modificar plantilla
$contents = file_get_contents($doc);
$contents = str_replace('[##LOGO##]', $logo_pdf_vo, $contents);
$contents = str_replace('[##JUSTIFICANTE##]', $justificante_acc_lg, $contents);
$contents = str_replace('[##NOMBRE_DOCUMENTO##]', $rgpd_lg, $contents);
$contents = str_replace('[##FECHA_LG##]', $fecha_lg, $contents);
$contents = str_replace('[##FECHA##]', $date, $contents);
$contents = str_replace('[##NOMBRE_LG##]', $nombre_del_receptor_lg, $contents);
$contents = str_replace('[##NOMBRE##]', $row['MOSTRAR'], $contents);
$contents = str_replace('[##DNI_LG##]', $dni_del_receptor_lg, $contents);
$contents = str_replace('[##DNI##]', $row['NIF'], $contents);
$contents = str_replace('[##NOMBRE_EMPRESA_LG##]', $el_nombre_empresa_lg, $contents);
$contents = str_replace('[##NOMBRE_EMPRESA##]', $nombre_concesionario_vo, $contents);
$contents = str_replace('[##GENERADO##]', $generado_lg, $contents);
$contents = str_replace('[##FECHA##]', $date, $contents);

//Leer la plantilla don datos dinamicos
$mpdf->WriteHTML($contents);


//Subir el pdf en las BBDD
$clave = get_id_unico();
$entrada = get_id_unico();
$parte = 1;
$version = 0;
$extension = 'PDF';

$nombreDOC = $row['MOSTRAR'] . "-rgpd" . ".pdf";
$item = $location . "" . $row['MOSTRAR'] . ".pdf";
$ruta = $row['MOSTRAR'] . "-rgpd" . ".pdf";
$mpdf->Output($item, "F");
$mpdf->Output($ruta, "D");

$size = filesize($item);
$clave_elemento_padre = get_id_unico();
$clave_elemento_carpeta_contacto = get_id_unico();


if(!alias_biblioteca_elementos($con,'##CN_DOCS##'))
{
    crear_elemento($con,$clave_elemento_padre,utf8_decode($carpeta_contacto_doc_lg),NULL,'##PUBLICO##',NULL,'##PUBLICO##/','C',0,'PUB',$usuarioSession,'WEB',1,NULL,NULL,'##CN_DOCS##');
}
else 
{
    $clave_elemento_padre = alias_biblioteca_elementos($con,'##CN_DOCS##'); 
}
if(!alias_biblioteca_elementos($con,"##CN_DOCS_$cliente##"))
{
    crear_elemento($con,$clave_elemento_carpeta_contacto,utf8_decode($carpeta_contacto_doc_codigo_lg.$cliente),NULL,$clave_elemento_padre,NULL,"##PUBLICO##/$clave_elemento_padre",'C',0,'PUB',$usuarioSession,'WEB',1,NULL,NULL,"##CN_DOCS_$cliente##");
    $clavePAU = $clave_elemento_carpeta_contacto;
}
else
{
    $clavePAU = alias_biblioteca_elementos($con,"##CN_DOCS_$cliente##");
}


$paramGb = valorParametros($con);
$padre = $clavePAU;
$acceso = getPAU($con,$clavePAU)['ACCESO'];
$ubicacion = getPAU($con,$clavePAU)['UBICACION']. "/" . $clavePAU;

$tipo = 'D';
$ambito = 'PUB';
$ordenador = selectOrdenador($con,$usuarioSession); 

$fopen = fopen($item,'r');
$fread = fread($fopen,filesize($item));
fclose($fopen);

if(selectTable($con,$database_cnx,$size,$paramGb))
{
    $sufijo = selectTable($con,$database_cnx,$size,$paramGb)['SUFIJO'];
    $table_name = selectTable($con,$database_cnx,$size,$paramGb)['TABLE_NAME'];
}
else
{
    $sufijo = substr(get_id_unico(),0, 14);
    $table_name = createTable($con,$sufijo);
}

insertDocInTable($con,$table_name,$clave,$parte,$version,$fread,$size,$entrada);
crear_elemento($con,$clave,$nombreDOC,$extension,$padre,$acceso,$ubicacion,$tipo,$size,$ambito,$usuarioSession,$ordenador,$parte,$entrada,$sufijo);

//Limpiar carpeta
eat_all_files("ofertas/pdf/");

//Mandar para firmar
if($_POST['submit'] == $awa_lg)
{
    $sql = "INSERT INTO AWASIGN_PENDIENTES_FIRMAS(CODIGO, USUARIO, FECHA) VALUES(?,?,?)";
    $schema->executeQuery($sql, 'sss', [$clave, $usuarioSession, date('Y-m-d H:i:s')]);
}










?>