<?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('../includes/functions.php');
include('../includes/esquemas.php');
include('../class/Schema.php');
include('../class/MotherCar.php');
include('../class/Expediente.php');
include('../class/Bibliotecas.php');
include('../class/Static.php');
include('../class/WebServices.php');
include('../lg/config_vo.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, $database);
$MotherCar = new MotherCar($con);
$Expediente = new Expediente($con);
$Bibliotecas = new Bibliotecas($con);
$codigo_vehiculo = $_SESSION['VEHICULO_TASACION'];

$request = Statics::SafeInput($con ,$_POST['request']);
if($request == 1) {
    $alias = Statics::SafeInput($con, $_POST['alias']);
    $tasacion = Statics::SafeInput($con, $_POST['tasacion']);
    $titles = [
        'PERMCIRC'              =>      $permiso_circulacion_lg,
        'FICHATECNICA1'         =>      $ficha_tecnica_delantera_lg,
        'FICHATECNICA2'         =>      $ficha_tecnica_trasera_lg,
        'FRONTAL'               =>      $frontal_lg,
        'LUNAFRONT'             =>      $luna_delantera_lg,
        'LATERALLEFT'           =>      $lateral_izq_lg,
        'TRASERO'               =>      $trasero_lg,
        'LUNABACK'              =>      $luna_trasera_lg,
        'LATERALRIGHT'          =>      $lateral_dr_lg,
        'CUENTAKM'              =>      $cuentakm_lg
    ];
    $data = [
        "alias"         =>      $alias, 
        "title"         =>      $titles[$alias],
        "tasacion"      =>      $tasacion,
        'files'         =>      []
    ];
    
    
    
    $html = '';
    $ESQUEMA = $Schema->select_esquema_o_esquema_estructura(TRUE); 
    $GRUPO = $Schema->select_esquema_o_esquema_estructura();
    
    $res = $Schema->executeQuery('SELECT T.*, E.*, Q.*
    FROM VEHICULOS_TASACIONES_DOCS T
    INNER JOIN BIBLIOTECA_ELEMENTOS E ON T.DOCUMENTO = E.CLAVE 
    INNER JOIN BIBLIOTECA_ETIQUETAS Q ON Q.CLAVE = E.CLAVE
    WHERE T.ALIAS = ? AND T.TASACION = ?
    AND E.PAPELERA = ? 
    AND Q.ESQUEMA = ? 
    AND Q.GRUPOE = ? ', 'ssiii', [$alias, $tasacion, 0, $ESQUEMA, $GRUPO]);
    
    if($res->num_rows) {
        while($row = $res->fetch_array()) {
            $TMP_FILE = '../tmp_img/' . $row['NOMBRE'];
            $Schema->create_file($TMP_FILE, $row['PARTES'], $row['SUFIJO'], $row['CLAVE']);
            array_push($data['files'], $row['NOMBRE'] . "@" . $row['DOCUMENTO']);
        }
    }
    echo json_encode($data);
} else {
    $id = Statics::SafeInput($con, $_POST['id']);
    $codigo_tasacion = Statics::SafeInput($con, $_POST['codigo_tasacion']);
    $data = $Schema->executeQuery('SELECT N.*, U.GRUPO
    FROM VEHICULOS_NOTAS N
    INNER JOIN USUARIOS U ON U.USUARIO = N.USUARIO
    WHERE N.CODIGO_TAS = ? AND N.VARIABLE_TAS = ? ORDER BY N.POS DESC', 'ss', [$codigo_tasacion, $id])->fetch_array();
    echo json_encode($data);
}
?>