<?php
    session_start();
    $usuarioSession = $_SESSION['USUARIO'];
    $grupo = $_SESSION['GRUPO'];
    $contacto = $_SESSION['CONTACTO'];
    $awa_session_id = $_SESSION['AWA_SESION_ID'];
    include('../lg/config_vo.php');
    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/Static.php');
    include('../class/Agenda.php');
    include('../class/Rgpd.php');
    include('../class/Bibliotecas.php');
    include('../class/PuzzleHTML.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);

   
    $category = Statics::SafeInput($con, $_POST['category']);
    $alias = Statics::SafeInput($con, $_POST['alias']);
    $update = Statics::SafeInput($con, $_POST['update']);



    if($update == 1) {
        $gear = Statics::SafeInput($con, $_POST['gear']);
        $sql = 'INSERT INTO VEHICULOS_EQUIPAMIENTOS_REL(VEHICULO, EQUIPAMIENTO, CATEGORIA, ALIAS) VALUES(?, ? ,?, ?)';
        $type = 'isis';
        $values = [$_SESSION['CODIGO_COCHE'], $gear, $category, $alias];
        echo "Gear: $gear <br>  Category: $category  <br>  Update: $update <br> Alias: $alias";
    } else {
        $sql = 'DELETE FROM VEHICULOS_EQUIPAMIENTOS_REL WHERE VEHICULO = ? AND ALIAS = ? AND CATEGORIA = ?';
        $type = 'isi';
        $values = [$_SESSION['CODIGO_COCHE'], $alias, $category];
        echo "Category: $category  <br>  Update: $update <br> Alias: $alias";

    }
    $Schema->executeQuery($sql, $type, $values);
    
    
?>