<?php
    require_once("comun/conexion_mysqli.php");
	$db = fdp_connect();
	
	$id_assembly = $_GET['id_assembly'];
	$sql_workpackages_vacios = "
		SELECT id, nombre
		FROM WorkPackage
		WHERE id_assembly = '$id_assembly'
		AND id NOT IN (
			SELECT DISTINCT id_workpackage
			FROM Disciplina disc, Descripcion d, Elemento e, Instancia i
			WHERE disc.id_assembly = '$id_assembly'
			AND disc.id = d.id_disciplina
			AND e.id_descripcion = d.id
			AND i.id_elemento = e.id)";

	$workpackages_vacios = fdp_query_all($db, $sql_workpackages_vacios);

	$xml = new SimpleXMLElement("<WorkPackagesVacios></WorkPackagesVacios>");
	
	foreach ($workpackages_vacios as $key => $tupla) {
		$id_wp = $tupla[0];
		$xml->addChild("wp", $tupla[1]);
		$sql_delete = "DELETE FROM WorkPackage WHERE id = '$id_wp'";
		fdp_query($db, $sql_delete);
	}
	
	echo($xml->asXML());
 ?>