<?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/functions.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');
    }
    $codigoTas = !empty($_POST['codigoTas']) ? htmlspecialchars(mysqli_real_escape_string($con,$_POST['codigoTas'])) : '';
    $obs = htmlspecialchars(mysqli_real_escape_string($con,$_POST['obs']));
    $variableTas = htmlspecialchars(mysqli_real_escape_string($con,$_POST['variableTas']));
    $vehiculo = htmlspecialchars(mysqli_real_escape_string($con,$_POST['vehiculo']));
    $max = getMaxCod($con,'POS','VEHICULOS_NOTAS');

    $sql = "INSERT INTO VEHICULOS_NOTAS(CLAVE,POS,FECHA,USUARIO,NOTA,CODIGO_TAS,VARIABLE_TAS) VALUES(?,?,NOW(),?,?,?,?)";
    $stmt = $con->prepare($sql);
    $stmt->bind_param('iissss',$vehiculo,$max,$usuarioSession,$obs,$codigoTas,$variableTas);
    $stmt->execute();

    $html = '
        <li class="list-group-item d-flex justify-content-between bg-light">
            <div class="text-dark">
                <h6 class="my-0">' . $observaciones_lg . '</h6>
            </div>
        </li>';
    $sql = "SELECT * FROM VEHICULOS_NOTAS WHERE VARIABLE_TAS = ? AND CLAVE = ? ORDER BY FECHA DESC";
    $stmt = $con->prepare($sql);
    $stmt->bind_param('si',$variableTas,$vehiculo);
    $stmt->execute();
    $res = $stmt->get_result();
    while($fila = $res->fetch_array())
    {
        $html .= '
            <li class="list-group-item">
                <span class="d-block mb-3 mt-1">
                    &bull; ' . str_replace('\n','<br>',$fila['NOTA']) . '
                </span>
                <small class="text-muted d-block float-right text-muted">' . ucfirst($fila['USUARIO']) . ' - ' . date('H:i:s d/m/Y', strtotime($fila['FECHA'])) . '</small>
            </li>';
    }
    
    echo $html;
?>

