<?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');
}
$i = 0;
$response = [];
$Schema = new Schema($con);
$request = Statics::SafeInput($con, $_POST['request']);
$default = isset($_POST['default']) ? Statics::SafeInput($con, $_POST['default']) : null;

switch($request) {
    case 1:
        $stock = Statics::SafeInput($con, $_POST['stock']); 
        $status = Statics::SafeInput($con, $_POST['status']); 
        $status ? $Schema->executeQuery('INSERT INTO VEHICULOS_PUBLICACIONES_REL VALUES(?, ?)', 'ii', [$stock, $default]) : $Schema->executeQuery('DELETE FROM VEHICULOS_PUBLICACIONES_REL WHERE STOCK = ? AND PORTAL = ?', 'ii', [$stock, $default]);
        $respones = ['status'   =>  $status];
    break;
    case 2:
        $res = $Schema->executeQuery('SELECT S.*, R.*
        FROM VEHICULOS_STOCKS S
        LEFT JOIN VEHICULOS_PUBLICACIONES_REL R ON S.CODIGO = R.STOCK
        AND R.PORTAL = ?
        WHERE S.ACTIVO = ?
        ORDER BY S.DESCRIPCION ASC', 'ii', [$default, 1]);
        while($row = $res->fetch_assoc()) {
            $response[] = [
                'key'   =>  $row['CODIGO'],
                'alias' =>  $row['ALIAS'],
                'title' =>  ucfirst(strtolower($row['DESCRIPCION'])),
                'checked' =>  $row['PORTAL'] ? true : false
            ];
        }
    break;
    default:
        $response = ['status' => false];
}
echo json_encode($response);