<?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('../lg/config_vo.php');
include('../lg/text.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/Tasaciones.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');
}

require_once __DIR__ . '../../vendor/autoload.php';
$Schema = new Schema($con);
$Bibliotecas = new Bibliotecas($con);
$Expediente = new Expediente($con);
$Tasaciones = new Tasaciones($con);
$mpdf = new \Mpdf\Mpdf();
$mpdf->showImageErrors = true;
$TAS = Statics::SafeInput($con, $_GET['codigo_tasacion']);
$Tasaciones->set_codigo_tasacion($TAS);
$row = $Tasaciones->getDataTas();

$date = date('H:i:s d/m/Y');
$doc_plantilla = '../ofertas/plantillas/tasacion-pdf.html';
$contents = file_get_contents($doc_plantilla);
$contents = str_replace('[##LOGO##]', $logo_pdf_vo, $contents);
$contents = str_replace('[##NAME_BUSINESS##]', $nombre_concesionario_vo, $contents);
$contents = str_replace('[##ADDRESS##]', $address_vo, $contents);
$contents = str_replace('[##PHONE##]', $phone_vo, $contents);
$contents = str_replace('[##EMAIL##]', $email_vo, $contents);
$contents = str_replace('[##WEB##]', $web_vo, $contents);
$contents = str_replace('[##DATE##]', date('H:i:s d/m/y'), $contents);
$contents = str_replace('[##CLIENT_INFO_SECTION##]', $cliente_seccion_lg, $contents);
$contents = str_replace('[##NAME_CLIENTE##]', $row['MOSTRAR_C'], $contents);
$contents = str_replace('[##PHONE_CLIENTE##]', $row['TLFNO1'], $contents);
$contents = str_replace('[##EMAIL_CLIENTE##]', $row['EMAIL1'], $contents);
$contents = str_replace('[##VALUE_CAR_SECTION##]', $valoracion_vehiculo_lg, $contents);
$contents = str_replace('[##PRICE_CAR##]', $row['PRECIO_T'], $contents);
$contents = str_replace('[##MONEY_SYMBOL##]', $moneda_vo, $contents);
$contents = str_replace('[##INFO_CAR_SECTION##]', $datos_vehiculos_lg, $contents);
$contents = str_replace('[##ENROLLMENT_TITLE##]', $matricula_lg, $contents);
$contents = str_replace('[##ENROLLMENT##]', $row['MATRICULA'], $contents);
$contents = str_replace('[##VERSION_TITLE##]', $version_lg, $contents);
$contents = str_replace('[##VERSION##]', $row['VERSION'], $contents);
$contents = str_replace('[##ENROLLMENT_DATE_TITLE##]', $matriculacion_lg, $contents);
$contents = str_replace('[##ENROLLMENT_DATE##]', $row['MATRICULACION'], $contents);
$contents = str_replace('[##MOTOR_TITLE##]', $motor_cc_lg, $contents);
$contents = str_replace('[##MOTOR##]', $row['MOTOR'], $contents);
$contents = str_replace('[##GEAR_TITLE##]', $cambio_lg, $contents);
$contents = str_replace('[##GEAR##]', $row['CAJA_CAMBIOS'], $contents);
$contents = str_replace('[##POWER_TITLE##]', $potencia_lg, $contents);
$contents = str_replace('[##POWER##]', $row['POTENCIA'], $contents);
$contents = str_replace('[##FUEL_TITLE##]', $combustible_lg, $contents);
$contents = str_replace('[##FUEL##]', $row['COMBUSTIBLES'], $contents);
$contents = str_replace('[##NEXT_VERIFICATION_TITLE##]', $itv_proxima_lg, $contents);
$contents = str_replace('[##NEXT_VERIFICATION##]', $row['ITV_PROXIMA'], $contents);
$contents = str_replace('[##COLOR_TITLE##]', $color_lg, $contents);
$contents = str_replace('[##COLOR##]', $row['COLOR_PRINCIPAL'] ? $row['COLOR_PRINCIPAL'] : $sin_asignar_lg, $contents);
$contents = str_replace('[##KM_TITLE##]', $kilometros_lg, $contents);
$contents = str_replace('[##KM##]', $row['KM'] ? $row['KM'] : $sin_asignar_lg, $contents);
$contents = str_replace('[##ORIGIN_TITLE##]', $procedencia_lg, $contents);
$contents = str_replace('[##ORIGIN##]', $row['PROCEDENCIA'] ? $row['PROCEDENCIAS'] : $sin_asignar_lg, $contents);
$contents = str_replace('[##KEY_TITLE##]', $llaves_lg, $contents);
$contents = str_replace('[##KEY##]', $row['LLAVES'] ? $row['LLAVES'] : $sin_asignar_lg, $contents);
$contents = str_replace('[##SPEED_TITLE##]', $velocidades_lg, $contents);
$contents = str_replace('[##SPEED##]', $row['VELOCIDADES'] ? $row['VELOCIDADES'] : $sin_asignar_lg, $contents);
$contents = str_replace('[##CAR_STATUS_SECTION##]', $estado_vehiculo_lg, $contents);
$contents = str_replace('[##BRAKES_TITLE##]', $pedales_lg, $contents);
$contents = str_replace('[##BRAKES##]', $row['PEDALES'] == 2 ? $mal_estado_lg : $buen_estado_lg, $contents);
$contents = str_replace('[##STEERING_WHEEL_TITLE##]', $volante_lg, $contents);
$contents = str_replace('[##STEERING_WHEEL##]', $row['VOLANTE'] == 2 ? $mal_estado_lg : $buen_estado_lg, $contents);
$contents = str_replace('[##SHIFTER_TITLE##]', $palanca_lg, $contents);
$contents = str_replace('[##SHIFTER##]', $row['PALANCA'] == 2 ? $mal_estado_lg : $buen_estado_lg, $contents);
$contents = str_replace('[##USE_SECTION##]', $porcentaje_desgaste_ruedas_lg, $contents);
$contents = str_replace('[##FRONT_TITLE##]', $delanteras_lg, $contents);
$contents = str_replace('[##FRONT##]', $row['RUEDAS_F'] ? $row['RUEDAS_F'] . "%" : $sin_asignar_lg, $contents);
$contents = str_replace('[##BACK_TITLE##]', $traseras_lg, $contents);
$contents = str_replace('[##BACK##]', $row['RUEDAS_B'] ? $row['RUEDAS_B'] . "%" : $sin_asignar_lg, $contents);
$contents = str_replace('[##DMG_SECTION##]', $peritacion_lg, $contents);
$d = '';
$DMGs = [
    'A1@1'  =>      $frontal_superior_lg . ": " . $grave_lg,
    'A1@2'  =>      $frontal_superior_lg . ": " . $leve_lg,
    'A2@1'  =>      $frontal_izquierda_lg . ": " . $grave_lg,
    'A2@2'  =>      $frontal_izquierda_lg . ": " . $leve_lg,
    'A3@1'  =>      $frontal_centro_lg . ": " . $grave_lg,
    'A3@2'  =>      $frontal_centro_lg . ": " . $leve_lg,
    'A4@1'  =>      $frontal_derecho_lg . ": " . $grave_lg,
    'A4@2'  =>      $frontal_derecho_lg . ": " . $leve_lg,
    'A5@1'  =>      $frontal_inferior_lg . ": " . $grave_lg,
    'A5@2'  =>      $frontal_inferior_lg . ": " . $leve_lg,

    'B1@1'  =>      $trasero_superior_lg . ": " . $grave_lg,
    'B1@2'  =>      $trasero_superior_lg . ": " . $leve_lg,
    'B2@1'  =>      $trasero_izquierda_lg . ": " . $grave_lg,
    'B2@2'  =>      $trasero_izquierda_lg . ": " . $leve_lg,
    'B3@1'  =>      $trasero_centro_lg . ": " . $grave_lg,
    'B3@2'  =>      $trasero_centro_lg . ": " . $leve_lg,
    'B4@1'  =>      $trasero_derecho_lg . ": " . $grave_lg,
    'B4@2'  =>      $trasero_derecho_lg . ": " . $leve_lg,
    'B5@1'  =>      $trasero_inferior_lg . ": " . $grave_lg,
    'B5@2'  =>      $trasero_inferior_lg . ": " . $leve_lg,
    
    'C1@1'  =>      $frontal_lateral_izquierdo_lg . ": " . $grave_lg,
    'C1@2'  =>      $frontal_lateral_izquierdo_lg . ": " . $leve_lg,
    'C2@1'  =>      $p1_lateral_izquierdo_lg . ": " . $grave_lg,
    'C2@2'  =>      $p1_lateral_izquierdo_lg . ": " . $leve_lg,
    'C3@1'  =>      $p2_lateral_izquierdo_lg . ": " . $grave_lg,
    'C3@2'  =>      $p2_lateral_izquierdo_lg . ": " . $leve_lg,
    'C4@1'  =>      $trasero_lateral_izquierdo_lg . ": " . $grave_lg,
    'C4@2'  =>      $trasero_lateral_izquierdo_lg . ": " . $leve_lg,
    
    'D1@1'  =>      $frontal_latera_derecho_lg . ": " . $grave_lg,
    'D1@2'  =>      $frontal_latera_derecho_lg . ": " . $leve_lg,
    'D2@1'  =>      $p1_lateral_derecho_lg . ": " . $grave_lg,
    'D2@2'  =>      $p1_lateral_derecho_lg . ": " . $leve_lg,
    'D3@1'  =>      $p2_lateral_derecho_lg . ": " . $grave_lg,
    'D3@2'  =>      $p2_lateral_derecho_lg . ": " . $leve_lg,
    'D4@1'  =>      $trasero_lateral_derecho_lg . ": " . $grave_lg,
    'D4@2'  =>      $trasero_lateral_derecho_lg . ": " . $leve_lg,
    
    'E1@1'  =>      $techo_lg . ": " . $grave_lg,
    'E1@2'  =>      $techo_lg . ": " . $leve_lg

];
$damages = explode('#', $row['DANOS']);
foreach($damages as $damage) {
    if(isset($DMGs[$damage])) {
        $d .= '<div class="col-50"><p>' . $damage . ': ' . $DMGs[$damage] . '</p></div>';
    }
}
$contents = str_replace('[##DMGS##]', $d, $contents);
$contents = str_replace('[##IMG_SECTION##]', $imagenes_lg, $contents);


$ESQUEMA = $Schema->select_esquema_o_esquema_estructura(TRUE); 
$GRUPO = $Schema->select_esquema_o_esquema_estructura(); 
$GRUPOE_TIPO = $Schema->select_esquema_estructura_valores('TIPO',$ESQUEMA);

$LISTA = $Schema->select_esquema_estructura_valores('TIPO', $ESQUEMA, 'LISTA');
$sql_codigo_etiqueta = "SELECT CODIGO FROM ETIQUETAS WHERE GRUPO = $LISTA AND DESCRIPCION = 'FOTO'";
$res_codigo_etiqueta = $con->query($sql_codigo_etiqueta);
$row_codigo_etiqueta = $res_codigo_etiqueta->fetch_array(); 
$ETIQUETA = $row_codigo_etiqueta['CODIGO'];
$GRUPOE_PUBLICABLE = $Schema->select_esquema_estructura_valores('PUBLICABLE', $ESQUEMA);

$sql = "SELECT E.CLAVE, E.NOMBRE, E.SUFIJO, E.PARTES, E.POS
FROM BIBLIOTECA_ELEMENTOS E INNER JOIN BIBLIOTECA_ETIQUETAS T1 ON E.CLAVE = T1.CLAVE
INNER JOIN BIBLIOTECA_ETIQUETAS T2 ON E.CLAVE = T2.CLAVE
INNER JOIN BIBLIOTECA_ETIQUETAS T3 ON E.CLAVE = T3.CLAVE
WHERE T1.ESQUEMA = ? AND T1.GRUPOE = ? AND T1.ETIQUETA = ?
AND T2.ESQUEMA = ? AND T2.GRUPOE = ? AND T2.ETIQUETA = ?
AND T3.ESQUEMA = ? AND T3.GRUPOE = ? AND T3.ETIQUETA = ?
AND E.PAPELERA = ?
AND E.CLAVE IN (SELECT DOCUMENTO FROM VEHICULOS_TASACIONES_DOCS)";
$res = $Schema->executeQuery($sql, 'iiiiiiiiii', [$ESQUEMA, $GRUPO, $row['CODIGO_VEHICULO'], $ESQUEMA, $GRUPOE_TIPO, $ETIQUETA, $ESQUEMA, $GRUPOE_PUBLICABLE, 1, 0]);
if($res->num_rows) {
    $html = '';
    while($row = $res->fetch_array()) { 
        $file_info = pathinfo($row['NOMBRE']);
        if($file_info['extension'] != 'PDF') {
            $splited = str_split($row['CLAVE'],9);
            $TMP_FILE = '../tmp_img/' . $row['NOMBRE'];
            $Schema->create_file($TMP_FILE, $row['PARTES'], $row['SUFIJO'], $row['CLAVE']);
            $html .= '<img src="' . $TMP_FILE . '" width="33%" style="margin-bottom:10px;">'; 
        }
    }
} else {
    $html = strtoupper($sin_asignar_lg);
} 
$contents = str_replace('[##IMGS##]', $html, $contents);

$contents = mb_convert_encoding($contents, 'UTF-8', 'UTF-8');
$mpdf->WriteHTML($contents);
$mpdf->Output();

?>