<?php
require ("../lib/genopar.lib.php");
require ("../lib/config.php");

if(!doAuth(LVLADM)) {
	$genopar->fechaPagina(); exit;
}

$genopar= new Genopar(__FILE__);

$genopar->abrePagina("Remover Anotação");
verGetPost(array("annot"));

if (!$annot){
	$annots = getAnnots($genopar);
	
	$genopar->abreForm();
	echo "<TABLE CELLSPACING=5 CELLPADDING=5 BORDER=1 RULES=ROWS FRAME=BOX>";
	echo "<TR>";
	echo "<TD>";
	echo "Annotation: ";
	echo "</TD>";
	echo "<TD>";
	$genopar->select("annot", $annots, "","", TRUE);
	echo "</TD>";
	echo "</TR>";
	echo "<TD align=center colspan=2>";
	$genopar->submit();
	echo "</TD>";
	echo "</TABLE>";
	$genopar->fechaForm();
}else{
	updateInfoAnnot($genopar, $annot);
	$genopar->abreBanco();
	$genopar->queryBanco("DROP DATABASE $annot");
	$genopar->fechaBanco();

	echo "<H2>Successfully removed <i>$annot</i> annotation.</H2>";
}

$genopar->fechaPagina();


function getAnnots($genopar){
	$annots = array();

	$genopar->abreBanco('infoAnnot');
	$q = "SELECT * FROM bancos";
	$n = $genopar->queryBanco($q);
	if($n > 0)
		while($res = $genopar->getArray()){
			if(!$res['data_remocao'])
				array_push($annots, $res['banco']);
		}
	$genopar->fechaBanco();

	return $annots;
}

function updateInfoAnnot($genopar, $annot){
	$date = date("o-m-d");

	$genopar->abreBanco('infoAnnot');
	$q = "UPDATE bancos SET data_criacao=NULL, data_remocao='$date' WHERE banco='$annot'";
	$genopar->queryBanco($q);
	$genopar->fechaBanco();
}

?>