<?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');
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');
}
if(isset($_SESSION['CODIGO_COCHE']))
{
    $codigo = $_SESSION['CODIGO_COCHE'];
    historial($con,2,$codigo,$imagen_eliminada_lg);
}
$clave = htmlspecialchars(mysqli_real_escape_string($con,$_POST['clave']));
$papelera = 1;
$papelera2 = 0;
$estado = 0;
$sql = "UPDATE BIBLIOTECA_ELEMENTOS SET PAPELERA = ? WHERE CLAVE = ?";
$stmt = $con->prepare($sql);
$stmt->bind_param('is',$papelera,$clave);
$stmt->execute();
if(isset($_POST['tasacion']))
{
    $tasacion = htmlspecialchars(mysqli_real_escape_string($con,$_POST['tasacion']));
    $alias = htmlspecialchars(mysqli_real_escape_string($con,$_POST['alias']));
    $arrayDoc = array('PERMCIRC', 'FTECNI1', 'FTECNI2');
    $arrayLados = array('L1','L2','L3','L4','R1','R2','R3','R4','F1','B1','I1','RUEDA_FL','RUEDA_FR','RUEDA_BL','RUEDA_BR', 'LATERAL_L', 'LATERAL_R', 'LUNA_F', 'LUNA_B', 'CUENTAKM', 'FRONTAL', 'TRASERO', 'LATERAL_L', 'LATERAL_R', 'LUNA_F', 'LUNA_B', 'VOLANTE', 'PALANCA', 'ASIENTOS', 'PEDALES', 'ALFOMBRILLAS');
    if(in_array($alias,$arrayDoc))
    {
        $sql = "SELECT D.*, T.CODIGO
        FROM VEHICULOS_TASACIONES_DOCS D
        INNER JOIN BIBLIOTECA_ELEMENTOS E ON E.CLAVE = D.DOCUMENTO AND E.PAPELERA = ? AND D.TASACION = ?
        INNER JOIN VEHICULOS_TASACIONES T ON T.TASACION = D.TASACION
        WHERE D.ALIAS = ? OR D.ALIAS = ? OR D.ALIAS = ?";
        $stmt = $con->prepare($sql);
        $stmt->bind_param('issss',$papelera2,$tasacion,$arrayDoc[0],$arrayDoc[1],$arrayDoc[2]);
        $stmt->execute();
        $res = $stmt->get_result();
        if($res->num_rows == 0)
        {
            $sql = "UPDATE VEHICULOS_TASACIONES SET ESTADO_DOCUMENTAL = ? WHERE TASACION = ? ";
            $stmt = $con->prepare($sql);
            $stmt->bind_param('is',$estado,$tasacion);
            $stmt->execute();
        }
        
        header("Location:" . $_SESSION['HEADER_TAS']); 
    }
    elseif(in_array($alias,$arrayLados))
    {

        $sql = "SELECT D.* 
        FROM VEHICULOS_TASACIONES_DOCS D
        INNER JOIN BIBLIOTECA_ELEMENTOS E ON E.CLAVE = D.DOCUMENTO AND E.PAPELERA = ? AND D.TASACION = ?
        WHERE D.ALIAS = ?";
        $stmt = $con->prepare($sql);
        $stmt->bind_param('iss',$papelera2,$tasacion,$alias);
        $stmt->execute();
        $res = $stmt->get_result();
        if($res->num_rows == 0)
        {
            $sql = "UPDATE VEHICULOS_TASACIONES SET ESTADO_FOTO = ? WHERE TASACION = ? ";
            $stmt = $con->prepare($sql);
            $stmt->bind_param('is',$estado,$tasacion);
            $stmt->execute();
        }
        header("Location:../tasacion-revision-carroceria.php?matricula=" . $_SESSION['matricula_inactivo'] . "&codigo_inactivo=" . $_SESSION['codigo_inactivo']);
        $_SESSION['msg_tas'] = 'other';
    }
    else
    {
        header("Location:../tasacion-elegir.php");
    }
}
else
{
    $_SESSION['edit'] = 6;
    header("Location:../resultados-editar.php");
} 
?>