<?php
    include ("Comun.php");
	$db = Conectar();
	
	$usuario_id = mysql_real_escape_string($_GET['usuario_id'], $db);
	
	$version = consultar("SELECT version FROM Version;");		
	$assemblies = ejecutar("SELECT a.id, a.nombre, a.inicio_planificado, a.fin_planificado, a.ruta, a.asset, a.posicion_dron, a.rotacion_dron, a.rotacion_camara, a.posicion_topdown_dron, a.replicar, p.rol_id FROM Assembly a, Permisos p WHERE p.usuario_id = '$usuario_id' AND a.proyecto_id = p.proyecto_id");
	$n = mysql_num_rows($assemblies);
	
	$xml = new SimpleXMLElement("<Assemblies></Assemblies>");
	
	$xml->addChild("version", $version);
	
	for ($i = 0; $i < $n; $i++)
		{
			$assembly = $xml->addChild("Assembly");
			$tupla = mysql_fetch_row($assemblies);
			$assembly->addChild("id", $tupla[0]);
			$assembly->addChild("nombre", $tupla[1]);	
			$assembly->addChild("inicio_planificado", $tupla[2]);	
			$assembly->addChild("fin_planificado", $tupla[3]);	
			$assembly->addChild("ruta", $tupla[4]);	
			$assembly->addChild("asset", $tupla[5]);
			$assembly->addChild("posicion_dron", $tupla[6]);
			$assembly->addChild("rotacion_dron", $tupla[7]);
			$assembly->addChild("rotacion_camara", $tupla[8]);
			$assembly->addChild("posicion_topdown_dron", $tupla[9]);
			$assembly->addChild("replicar", $tupla[10]);
			$assembly->addChild("rol", $tupla[11]);
		}	
	
	echo($xml->asXML());
	
 ?>