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; }