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

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

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