function wichReport($task)
{
switch ($task) {
//advanced report
case 'csv1':
$sql = SQLadvancedTermReport($_GET);
break;
//free terms
//free terms
case 'csv2':
$sql = SQLverTerminosLibres();
break;
//duplicated terms
//duplicated terms
case 'csv3':
$sql = SQLverTerminosRepetidos();
break;
//polit BT terms
//polit BT terms
case 'csv4':
$sql = SQLpoliBT();
break;
//candidate terms
//candidate terms
case 'csv5':
$sql = SQLtermsXstatus($_SESSION["id_tesa"], "12");
break;
//rejected terms
//rejected terms
case 'csv6':
$sql = SQLtermsXstatus($_SESSION["id_tesa"], "14");
break;
//preferred and accepted terms without hierarchical relationships
//preferred and accepted terms without hierarchical relationships
case 'csv7':
$sql = SQLtermsXcantNT();
break;
//preferred and accepted terms with words count
//preferred and accepted terms with words count
case 'csv8':
$sql = SQLtermsXcantWords($_SESSION["id_tesa"]);
break;
//meta terms
//meta terms
case 'csv9':
$sql = SQLtermsIsMetaTerms($_SESSION["id_tesa"]);
break;
//Terms with related terms
//Terms with related terms
case 'csv10':
$sql = SQLtermsXrelatedTerms($_SESSION["id_tesa"]);
break;
//Terms with non prefered terms
//Terms with non prefered terms
case 'csv11':
$sql = SQLtermsXNonPreferedTerms($_SESSION["id_tesa"]);
break;
//Comparative report about mapped terms
//Comparative report about mapped terms
case 'csv12':
$sql = SQLreportTargetTerms($_GET["tvocabs"]);
break;
//Preferred terms
//Preferred terms
case 'csv13':
$sql = SQLreportTerminosPreferidos();
break;
//Terms without note o note type
//Terms without note o note type
case 'csv14':
$sql = SQLreportNullNotes($_GET["note_type_null"]);
break;
default:
break;
}
return sql2csv($sql, string2url($_SESSION["CFGTitulo"]) . '.csv', $_GET["csv_encode"]);
}
function verTerminosRepetidos()
{
$sql = SQLverTerminosRepetidos();
$rows .= '<div><h1>' . ucfirst(LABEL_terminosRepetidos) . ' (' . $sql[cant] . ') </h1>';
$rows .= '<ul>';
if ($sql[cant] == 0) {
$rows .= '<li>' . ucfirst(MSG_noTerminosRepetidos) . '<li/>';
} else {
while ($array = mysqli_fetch_array($sql[datos])) {
$rows .= '<li> <a title="' . $array[tema] . '" href="index.php?' . FORM_LABEL_buscar . '=' . $array[tema] . '&tipo=E">' . $array[tema] . '</a> (' . $array[cant] . ')<li/>';
}
}
$rows .= '</ul>';
$rows .= '</div>';
return $rows;
}
function HTMLformVerTerminosRepetidos()
{
$sql = SQLverTerminosRepetidos();
$rows .= '<div><h3>' . ucfirst(LABEL_terminosRepetidos) . ' (' . SQLcount($sql) . ') </h3>';
$rows .= '<ul>';
if (SQLcount($sql) == 0) {
$rows .= '<li>' . ucfirst(MSG_noTerminosRepetidos) . '</li>';
} else {
while ($array = $sql->FetchRow()) {
$i = ++$i;
if ($string_term !== $array["string_term"]) {
if (!$i !== 0) {
$rows .= '</ul></li>';
}
$rows .= '<li>' . $array["string_term"] . ' (' . $array["cant"] . ')<ul>';
}
$css_class_MT = $array["isMetaTerm"] == 1 ? ' class="metaTerm" ' : '';
$rows .= '<li> <a ' . $css_class_MT . ' title="' . $array["tema"] . '" href="index.php?tema=' . $array["tema_id"] . '">' . $array["tema"] . '</a></li>';
$string_term = $array["string_term"];
}
$rows .= '</ul></li>';
}
$rows .= '</ul>';
$rows .= '</div>';
return $rows;
}
