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 verTerminosLibres()
{
$sql = SQLverTerminosLibres();
$rows .= '<div><h1>' . ucfirst(LABEL_terminosLibres) . ' (' . $sql[cant] . ') </h1>';
$rows .= '<ul>';
if ($sql[cant] == 0) {
$rows .= '<li>' . ucfirst(MSG_noTerminosLibres) . '<li/>';
} else {
while ($array = mysqli_fetch_array($sql[datos])) {
$rows .= '<li><a title="' . $array[tema] . '" href="index.php?tema=' . $array[id] . '">' . $array[tema] . '</a><li/>';
}
}
$rows .= '</ul>';
$rows .= '</div>';
return $rows;
}
function HTMLformVerTerminosLibres($taskterm = 'null', $freeTerms_id = array())
{
//borrado masivo de términos libres
if ($taskterm == 'deleteFreeTerms') {
$task = REMTerms($freeTerms_id, 1);
}
$sql = SQLverTerminosLibres();
$rows .= '<div>';
$rows .= '<h3>' . ucfirst(LABEL_terminosLibres) . ' (' . SQLcount($sql) . ') </h3>';
if (is_array($task)) {
if ($task["error"] > 0) {
$rows .= '<p class="error">' . $task["error"] . ' ' . MSG_termsNoDeleted . ' </p>';
} else {
$rows .= '<p class="success">' . $task["success"] . ' ' . MSG_termsDeleted . ' </p>';
}
}
if (SQLcount($sql) > 0) {
$rows .= '<div><input id="filter" type="text" class="form-control" placeholder="' . ucfirst(LABEL_type2filter) . '"></div>';
$rows .= '<form role="form" id="delete_free_terms" name="delete_free_terms" action="index.php?verT=L" method="post">';
$rows .= '<div class="table-responsive"> ';
$rows .= '<table class="table table-striped table-bordered table-condensed table-hover">
<thead>
<tr>
<th></th>
<th>' . ucfirst(LABEL_Termino) . '</th>
<th>' . ucfirst(LABEL_Fecha) . '</th>
</tr>
</thead>
<tbody class="searchable">';
while ($array = $sql->FetchRow()) {
$css_class_MT = $array["isMetaTerm"] == 1 ? ' class="metaTerm" ' : '';
$rows .= '<tr>';
$rows .= ' <td align="center"><input type="checkbox" name="deleteFreeTerms_id[]" id="freeTerm_' . $array["tema_id"] . '" title="' . ucfirst(MENU_BorrarT) . ' ' . $array["tema"] . ' " value="' . $array["tema_id"] . '" /></td>';
$rows .= ' <td><label class="check_label" value="' . $value["tema_id"] . ' title="' . $value["tema"] . ' " for="freeTerm_' . $array["tema_id"] . '"><a ' . $css_class_MT . ' title="' . $array["tema"] . '" href="index.php?tema=' . $array["tema_id"] . '" >' . $array["tema"] . '</a></label></td>';
$rows .= ' <td>' . $array["cuando"] . '</td>';
$rows .= ' </tr>';
}
$rows .= ' </tbody> </table>';
$rows .= ' </div>';
$rows .= '<div class="submit_form" align="center">';
$rows .= '<p class="warning">' . MSG__warningDeleteTerm2row . '</p>';
$rows .= ' <input type="hidden" id="taskterm" name="taskterm" value="deleteFreeTerms"/>';
$rows .= ' <input class="submit ui-corner-all" type="submit" name="boton" value="' . ucfirst(MENU_BorrarT) . '"/>';
$rows .= '</div>';
$rows .= '</form>';
}
//if cant
$rows .= '</div>';
return $rows;
}