function doBrowseTermsByDate()
{
global $MONTHS;
$sql = SQLtermsByDate();
$rows .= '<table class="contenido" cellpadding="0" cellspacing="0" summary="' . ucfirst(LABEL_auditoria) . '">';
$rows .= '<thead>';
$rows .= '<tr>';
$rows .= '<th colspan="3" class="titulo_tabla">' . ucfirst(LABEL_auditoria) . '</th>';
$rows .= '</tr>';
$rows .= '<tr>';
$rows .= '<th>' . ucfirst(LABEL_ano) . '</th>';
$rows .= '<th>' . ucfirst(LABEL_mes) . '</th>';
$rows .= '<th>' . ucfirst(LABEL_Terminos) . '</th>';
$rows .= '</tr>';
$rows .= '</thead>';
$rows .= '<tbody>';
while ($array = mysqli_fetch_array($sql[datos])) {
$fecha_termino = do_fecha($array[cuando]);
$rows .= '<tr>';
$rows .= '<td class="centrado">' . $array[years] . '</td>';
$rows .= '<td class="centrado"><a href="sobre.php?m=' . $array[months] . '&y=' . $array[years] . '" title="' . LABEL_verDetalle . $fecha_termino[descMes] . '">' . $fecha_termino[descMes] . '</a></td>';
$rows .= '<td class="centrado">' . $array[cant] . '</td>';
$rows .= '</tr>';
$TotalTerminos += $array[cant];
}
$rows .= '</tbody>';
$rows .= '<tfoot>';
$rows .= '<tr>';
$rows .= '<td colspan="2">' . ucfirst(LABEL_TotalTerminos) . '</td>';
$rows .= '<td>' . $TotalTerminos . '</td>';
$rows .= '</tr>';
$rows .= '</tfoot>';
$rows .= '</table> ';
return $rows;
}
function HTMLformAdvancedTermReport($array)
{
global $CFG;
$LABEL_Termino = ucfirst(LABEL_Termino);
$LABEL_esNoPreferido = ucfirst(LABEL_esNoPreferido);
$LABEL_CODE = ucfirst(LABEL_CODE);
$LABEL_NOTE = ucfirst(LABEL_nota);
$LABEL_TARGET_TERM = ucfirst(LABEL_TargetTerm);
$LABEL_haveEQ = LABEL_haveEQ;
$LABEL_nohaveEQ = LABEL_nohaveEQ;
$LABEL_start = LABEL_start;
$LABEL_end = LABEL_end;
$LABEL_equalThisWord = LABEL_equalThisWord;
$arrayVocabStats = ARRAYresumen($_SESSION["id_tesa"], "G", "");
$arrayWS = array("t#{$LABEL_Termino}");
if ($arrayVocabStats["cant_up"] > 0) {
array_push($arrayWS, "uf#{$LABEL_esNoPreferido}");
}
//Notes
if ($arrayVocabStats["cant_notas"] > 0) {
array_push($arrayWS, "n#{$LABEL_NOTE}");
$LabelNB = 'NB#' . LABEL_NB;
$LabelNH = 'NH#' . LABEL_NH;
$LabelNA = 'NA#' . LABEL_NA;
$LabelNP = 'NP#' . LABEL_NP;
$LabelNC = 'NC#' . LABEL_NC;
$sqlNoteType = SQLcantNotas();
$arrayNoteType = array();
while ($array = $sqlNoteType->FetchRow()) {
if ($array[cant] > 0) {
$varNoteType = in_array($array["value_id"], array(8, 9, 10, 11, 15)) ? arrayReplace(array(8, 9, 10, 11, 15), array($LabelNA, $LabelNH, $LabelNB, $LabelNP, $LabelNC), $array["value_id"]) : $array["value_code"] . '#' . $array["value"];
$varNoteType .= ' (' . $array["cant"] . ')';
array_push($arrayNoteType, $varNoteType);
}
}
}
//target vocabularies
if ($arrayVocabStats["cant_term2tterm"]) {
$sql = SQLtargetVocabulary("1");
$array_vocabularios = array();
while ($array = $sql->FetchRow()) {
//vocabularios que no sean el vocabulario principal
array_push($array_vocabularios, $array[tvocab_id] . '#' . FixEncoding($array[tvocab_label]));
}
}
//Evaluar si hay top terms
$sqlTopTerm = SQLverTopTerm();
if (SQLcount($sqlTopTerm) > 0) {
while ($arrayTopTerms = $sqlTopTerm->FetchRow()) {
$formSelectTopTerms[] = $arrayTopTerms["tema_id"] . '#' . $arrayTopTerms[tema];
}
}
//Evaluar si hay terminos
$sqlTermsByDates = SQLtermsByDate();
if (SQLcount($sqlTermsByDates) > 0) {
global $MONTHS;
while ($arrayTermsByDates = $sqlTermsByDates->FetchRow()) {
//normalizacion de fechas
$arrayTermsByDates[months] = strlen($arrayTermsByDates[months]) == 1 ? '0' . $arrayTermsByDates[months] : $arrayTermsByDates[months];
$formSelectByDate[] = $arrayTermsByDates["years"] . '-' . $arrayTermsByDates["months"] . '#' . $MONTHS["{$arrayTermsByDates['months']}"] . '/' . $arrayTermsByDates["years"] . ' (' . $arrayTermsByDates["cant"] . ')';
}
}
//internal reference vocabularies
$sql = SQLdatosVocabulario();
if (SQLcount($sql) > '1') {
//Hay vobularios de referencia
$array_ivocabularios = array();
while ($array = $sql->FetchRow()) {
if ($array[vocabulario_id] !== '1') {
//vocabularios que no sean el vocabulario principal
array_push($array_ivocabularios, $array[vocabulario_id] . '#' . $array[titulo]);
}
}
}
$rows = '<form class="form-horizontal" role="form" name="advancedreport" action="index.php#csv" method="get">
<fieldset>
<!-- Form Name -->
<legend>' . ucfirst(LABEL_FORM_advancedReport) . '</legend>';
if (SQLcount($sqlTopTerm) > 0) {
$rows .= '<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="hasTopTerm">' . ucfirst(LABEL_TopTerm) . '</label>
<div class="col-md-5">
<select id="hasTopTerm" name="hasTopTerm" class="form-control">
<option value="">' . ucfirst(LABEL_FORM_nullValue) . '</option>
' . doSelectForm($formSelectTopTerms, $_GET["hasTopTerm"]) . '
</select>
</div>
</div>';
}
if ($arrayVocabStats["cant_notas"] > 0) {
$rows .= '<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="hasNote">' . ucfirst(LABEL_FORM_haveNoteType) . '</label>
<div class="col-md-4">
<select id="hasNote" name="hasNote" class="form-control">
<option value="">' . ucfirst(LABEL_FORM_nullValue) . '</option>
' . doSelectForm($arrayNoteType, $_GET["hasNote"]) . '
</select>
</div>
</div>';
}
$rows .= '<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="fromDate">' . ucfirst(LABEL_DesdeFecha) . '</label>
<div class="col-md-3">
<select id="fromDate" name="fromDate" class="form-control">
<option value="">' . ucfirst(LABEL_FORM_nullValue) . '</option>
' . doSelectForm($formSelectByDate, $_GET["fromDate"]) . ' </select>
</div>
</div>';
//target vocabularies
if ($arrayVocabStats["cant_term2tterm"]) {
$rows .= '<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="csv_tvocab_id">' . ucfirst(LABEL_TargetTerms) . '</label>
<div class="col-md-3">
<select id="csv_tvocab_id" name="csv_tvocab_id" class="form-control">
<option value="">' . ucfirst(LABEL_FORM_nullValue) . '</option>
' . doSelectForm($array_vocabularios, $_GET["csv_tvocab_id"]) . '
</select>
</div>
<div class="col-md-3">
<select id="mapped" name="mapped" class="form-control">
' . doSelectForm(array("y#{$LABEL_haveEQ}", "n#{$LABEL_nohaveEQ}"), $_GET["mapped"]) . '
</select>
</div>
</div>';
}
if (SQLcount($sql) > '1') {
$rows .= '<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="csv_itvocab_id">' . ucfirst(LABEL_vocabulario_referencia) . '</label>
<div class="col-md-3">
<select id="csv_itvocab_id" name="csv_itvocab_id" class="form-control">
<option value="">' . ucfirst(LABEL_FORM_nullValue) . '</option>
' . doSelectForm($array_ivocabularios, $_GET["csv_itvocab_id"]) . '
</select>
</div>
<div class="col-md-3">
<select id="int_mapped" name="int_mapped" class="form-control">
' . doSelectForm(array("y#{$LABEL_haveEQ}", "n#{$LABEL_nohaveEQ}"), $_GET["int_mapped"]) . '
</select>
</div>
</div>';
}
//only for admin
if ($_SESSION[$_SESSION["CFGURL"]][ssuser_nivel] == '1') {
$sqlUsers = SQLdatosUsuarios();
if (SQLcount($sqlUsers) > 1) {
while ($arrayUsers = $sqlUsers->FetchRow()) {
$formSelectUsers[] = $arrayUsers[id] . '#' . $arrayUsers[apellido] . ', ' . $arrayUsers[nombres];
}
$rows .= '<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="byuser_id">' . ucfirst(MENU_Usuarios) . '</label>
<div class="col-md-4">
<select id="user_id" name="byuser_id" class="form-control">
<option value="">' . ucfirst(LABEL_FORM_nullValue) . '</option>
' . doSelectForm($formSelectUsers, $_GET["byuser_id"]) . '
</select>
</div>
</div>';
}
}
$rows .= '<div class="form-group">
<label class="col-md-4 control-label" for="w_string">' . ucfirst(LABEL_haveWords) . '</label>
<div class="col-md-3">
<select id="w_string" name="w_string" class="form-control">
' . doSelectForm(array("x#{$LABEL_equalThisWord}", "s#{$LABEL_start}", "e#{$LABEL_end}"), $_GET["w_string"]) . '
</select>
</div>
<div class="col-md-3">
<input id="csvstring" name="csvstring" class="form-control" placeholder="' . LABEL_haveWords . '" type="text">
</div>
</div>
<!-- Checkboxes (inline) -->
<div class="form-group">
<label class="col-md-4 control-label" for="csv_encodeAdvance">' . ucfirst(LABEL_encode) . ' latin1</label>
<div class="col-md-4">
<input name="csv_encode" id="csv_encodeAdvance" value="latin1" type="checkbox">
</div>
</div>
<!-- Button -->
<div class="form-group">
<div class="text-center">
<input type="submit" class="btn btn-primary" id="boton" name="boton" value="' . ucfirst(LABEL_Guardar) . '"/>
</div>
</div>
<input type="hidden" name="mod" id="mod" value="csv"/><input type="hidden" name="task" id="mod" value="csv1"/>
</fieldset>
</form>
';
return $rows;
}
function HTMLformAdvancedSearch($array)
{
global $CFG;
$rows .= ' <fieldset>
<legend>' . ucfirst(LABEL_BusquedaAvanzada) . '</legend>
<form class="formdiv" name="advancedsearch" action="index.php#xstring" method="get" onsubmit="return checkrequired(this)">';
$LABEL_Termino = ucfirst(LABEL_Termino);
$LABEL_esNoPreferido = ucfirst(LABEL_esNoPreferido);
$LABEL_CODE = ucfirst(LABEL_CODE);
$rows .= '<div><label for="ws" accesskey="f">' . ucfirst(LABEL_QueBuscar) . '</label>';
$rows .= '<select id="ws" name="ws">';
$arrayWS = $CFG["_USE_CODE"] == '1' ? array("t#{$LABEL_Termino}", "uf#{$LABEL_esNoPreferido}", "c#{$LABEL_CODE}") : array("t#{$LABEL_Termino}", "uf#{$LABEL_esNoPreferido}");
$rows .= doSelectForm($arrayWS, "{$_GET['ws']}");
$rows .= '</select>';
// $rows.='<input name="isUF" type="checkbox" id="isUF" value="1" '.do_check('1',$_GET[isUF],"checked").'/>';
$rows .= '</div>';
$rows .= '<div><label for="xstring" accesskey="s">' . ucfirst(LABEL_BuscaTermino) . '</label>';
$rows .= '<input name="xstring" type="text" id="xstring" size="25" maxlength="50" value="' . $_GET[xstring] . '"/>';
$rows .= '</div>';
$rows .= '<div><label for="isExactMatch" accesskey="f">' . ucfirst(LABEL_esFraseExacta) . '</label>';
$rows .= '<input name="isExactMatch" type="checkbox" id="isExactMatch" value="1" ' . do_check('1', $_GET[isExactMatch], "checked") . '/>';
$rows .= '</div>';
//Evaluar si hay top terms
$sqlTopTerm = SQLverTopTerm();
if ($sqlTopTerm[cant]) {
while ($arrayTopTerms = mysqli_fetch_array($sqlTopTerm[datos])) {
$formSelectTopTerms[] = $arrayTopTerms[tema_id] . '#' . $arrayTopTerms[tema];
}
$rows .= '<div><label for="hasTopTerm" accesskey="t">' . ucfirst(LABEL_TopTerm) . '</label>';
$rows .= '<select id="hasTopTerm" name="hasTopTerm">';
$rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
$rows .= doSelectForm($formSelectTopTerms, "{$_GET['hasTopTerm']}");
$rows .= '</select>';
$rows .= '</div>';
}
//Evaluar si hay notas
$resumen = ARRAYresumen($_SESSION[id_tesa], "G", "");
if (is_array($resumen["cant_notas"])) {
$arrayTiposNotas = array('NA' => LABEL_NA, 'NH' => LABEL_NH, 'NC' => LABEL_NC, 'NB' => LABEL_NB, 'NP' => LABEL_NP);
foreach ($resumen["cant_notas"] as $knotas => $vnotas) {
$formSelectTipoNota[] = $knotas . '#' . $arrayTiposNotas[$knotas] . ' (' . $vnotas . ')';
}
$rows .= '<div><label for="hasNote" accesskey="n">' . ucfirst(LABEL_tipoNota) . '</label>';
$rows .= '<select id="hasNote" name="hasNote">';
$rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
$rows .= doSelectForm($formSelectTipoNota, "{$_GET['hasNote']}");
$rows .= '</select>';
$rows .= '</div>';
}
//Evaluar si hay terminos
$sqlTermsByDates = SQLtermsByDate();
if ($sqlTermsByDates[cant]) {
global $MONTHS;
while ($arrayTermsByDates = mysqli_fetch_array($sqlTermsByDates[datos])) {
//normalizacion de fechas
$arrayTermsByDates[months] = strlen($arrayTermsByDates[months]) == 1 ? '0' . $arrayTermsByDates[months] : $arrayTermsByDates[months];
$formSelectByDate[] = $arrayTermsByDates[years] . '-' . $arrayTermsByDates[months] . '#' . $MONTHS["{$arrayTermsByDates['months']}"] . '/' . $arrayTermsByDates[years] . ' (' . $arrayTermsByDates[cant] . ')';
}
$rows .= '<div><label for="fromDate" accesskey="d">' . ucfirst(LABEL_DesdeFecha) . '</label>';
$rows .= '<select id="fromDate" name="fromDate">';
$rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
$rows .= doSelectForm($formSelectByDate, "{$_GET['fromDate']}");
$rows .= '</select>' . ucfirst(LABEL_mes) . '/' . ucfirst(LABEL_ano);
$rows .= '</div>';
}
//Evaluar si hay candidatos
$sqlTermsByDeep = SQLTermDeep();
if ($sqlTermsByDeep[cant] > 1) {
while ($arrayTermsByDeep = mysqli_fetch_array($sqlTermsByDeep[datos])) {
$formSelectByDeep[] = $arrayTermsByDeep[tdeep] . '#' . $arrayTermsByDeep[tdeep] . ' (' . $arrayTermsByDeep[cant] . ')';
}
$rows .= '<div><label for="termDeep" accesskey="e">' . ucfirst(LABEL_ProfundidadTermino) . '</label>';
$rows .= '<select id="termDeep" name="termDeep">';
$rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
$rows .= doSelectForm($formSelectByDeep, "{$_GET['termDeep']}");
$rows .= '</select>';
$rows .= '</div>';
}
$rows .= '<div class="submit_form" align="center">';
$rows .= '<input type="submit" id="boton" name="boton" value="' . LABEL_Enviar . '"/>';
$rows .= '<input type="hidden" name="xsearch" id="xsearch" value="1"/>';
$rows .= '<input type="button" name="cancelar" type="button" onClick="location.href=\'index.php\'" value="' . ucfirst(LABEL_Cancelar) . '"/>';
$rows .= '</div>';
$rows .= '</form>';
$rows .= ' </fieldset>';
if ($_GET[boton] == LABEL_Enviar) {
$rows .= HTMLadvancedSearchResult($_GET);
}
return $rows;
}
function doBrowseTermsByDate()
{
global $MONTHS;
$sql = SQLtermsByDate();
$rows .= '<div class="table-responsive"> ';
$rows .= '<table class="table table-striped table-bordered table-condensed table-hover" summary="' . ucfirst(LABEL_auditoria) . '">';
$rows .= '<thead>';
$rows .= '<tr>';
$rows .= '<th colspan="3" class="titulo_tabla">' . ucfirst(LABEL_auditoria) . '</th>';
$rows .= '</tr>';
$rows .= '<tr>';
$rows .= '<th>' . ucfirst(LABEL_ano) . '</th>';
$rows .= '<th>' . ucfirst(LABEL_mes) . '</th>';
$rows .= '<th>' . ucfirst(LABEL_Terminos) . '</th>';
$rows .= '</tr>';
$rows .= '</thead>';
$rows .= '<tbody>';
while ($array = $sql->FetchRow()) {
$fecha_termino = do_fecha($array[cuando]);
$rows .= '<tr>';
$rows .= '<td class="centrado">' . $array[years] . '</td>';
$rows .= '<td class="centrado"><a href="sobre.php?m=' . $array[months] . '&y=' . $array[years] . '" title="' . LABEL_verDetalle . $fecha_termino[descMes] . '">' . $fecha_termino[descMes] . '</a></td>';
$rows .= '<td class="centrado">' . $array["cant"] . '</td>';
$rows .= '</tr>';
$TotalTerminos += $array["cant"];
}
$rows .= '</tbody>';
$rows .= '<tfoot>';
$rows .= '<tr>';
$rows .= '<td colspan="2">' . ucfirst(LABEL_TotalTerminos) . '</td>';
$rows .= '<td>' . $TotalTerminos . '</td>';
$rows .= '</tr>';
$rows .= '</tfoot>';
$rows .= '</table> ';
$rows .= '</div> ';
return $rows;
}
