<?php
include("../../../assets/conn/conexion.php"); 
$bd_conn = new connexion($host_avanws,$user_avanws,$pass_avanws,$name_avanws,$port_avanws);
$bd_conn->query("SET NAMES 'utf8'");
date_default_timezone_set('Europe/Madrid');
/////////////////////////////////////
define('CODIGO_STOCK', '9');
/////////////////////////////////////
$q_publicaciones =  deletePublicaciones($bd_conn, CODIGO_STOCK);
echo 'Eliminadas ' . $q_publicaciones . ' Publicaciones<br>';
$q_links =  deleteLinks($bd_conn, CODIGO_STOCK);
echo 'Eliminadas ' . $q_links . ' Links<br>';
$q_equipamientos =  deleteEquipamientos($bd_conn, CODIGO_STOCK);
echo 'Eliminadas ' . $q_equipamientos . ' Equipamientos<br>';
$q_vehiculos =  deleteVehiculos($bd_conn, CODIGO_STOCK);
echo 'Eliminadas ' . $q_vehiculos . ' Vehiculos<br>';
/////////////////////////////////////
function deletePublicaciones($bd, $codigo_stock)
{
	$sql =  "   DELETE FROM VEHICULOS_PUBLICACIONES
                WHERE VEHICULO IN( SELECT CODIGO FROM VEHICULOS WHERE STOCK = $codigo_stock)";
    $base = $bd->prepare($sql);
    $base->execute();
    return mysqli_affected_rows($bd);
}
function deleteLinks($bd, $codigo_stock)
{
	$sql =  "   DELETE FROM VEHICULOS_MULTIMEDIA_LINKS
                WHERE VEHICULO IN( SELECT CODIGO FROM VEHICULOS WHERE STOCK = $codigo_stock)";
    $base = $bd->prepare($sql);
    $base->execute();
    return mysqli_affected_rows($bd);
}
function deleteEquipamientos($bd, $codigo_stock)
{
	$sql =  "   DELETE FROM VEHICULOS_EQUIPAMIENTOS_REL
                WHERE VEHICULO IN( SELECT CODIGO FROM VEHICULOS WHERE STOCK = $codigo_stock)";
    $base = $bd->prepare($sql);
    $base->execute();
    return mysqli_affected_rows($bd);
}
function deleteVehiculos($bd, $codigo_stock)
{
	$sql =  "   DELETE FROM VEHICULOS
                WHERE STOCK = $codigo_stock";
    $base = $bd->prepare($sql);
    $base->execute();
    return mysqli_affected_rows($bd);
}
?>