示例#1
0
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;
}
示例#2
0
<?php

#   TemaTres : aplicación para la gestión de lenguajes documentales #       #
#                                                                        #
#   Copyright (C) 2004-2008 Diego Ferreyra tematres@r020.com.ar
#   Distribuido bajo Licencia GNU Public License, versión 2 (de junio de 1.991) Free Software Foundation
#
###############################################################################################################
# Include para alta y modificacion de usuarios genericos.
if ($_GET[user_id] == 'new') {
    $nombre_boton = LABEL_Enviar;
} else {
    $dato_user = ARRAYdatosUser($_GET[user_id]);
    $resumen = ARRAYresumen($_SESSION[id_tesa], "U", "{$dato_user['id']}");
    $row_resumen .= '<div id="cajaAncha">' . "\n\r";
    $row_resumen .= '  <div><strong>' . LABEL_Acciones . '</strong></div><dl class="dosCol">' . "\n\r";
    if ($resumen[cant_total] > 0) {
        $row_resumen .= '<dt><a href="sobre.php?user_id=' . $dato_user[id] . '" title="' . LABEL_Terminos . '">' . ucfirst(LABEL_Terminos) . '</dt><dd>' . $resumen[cant_total] . '</a>&nbsp;</dd>' . "\n\r";
    } else {
        $row_resumen .= '<dt>' . ucfirst(LABEL_Terminos) . '</dt><dd>' . $resumen[cant_total] . "&nbsp;</dd>\n\r";
    }
    $row_resumen .= '<dt>' . ucfirst(LABEL_RelTerminos) . '</dt><dd>' . $resumen[cant_rel] . "&nbsp;</dd>\n\r";
    $row_resumen .= '<dt>' . ucfirst(LABEL_TerminosUP) . '</dt><dd>' . $resumen[cant_up] . "&nbsp;</dd>\n\r";
    $row_resumen .= '</dl></div>';
    if ($dato_user[estado]) {
        if ($dato_user[estado] == 'ACTIVO') {
            $textoEnlace = MENU_Caducar;
        } else {
            $textoEnlace = MENU_Habilitar;
        }
        $boton_estado = '<input name="boton" type="button" value="' . $textoEnlace . '" onclick="location.href=\'admin.php?user_id=list&usestado=' . $dato_user[id] . '&estado=' . $dato_user[estado] . '\'"/>' . "\n\r";
if (stristr($_SERVER['REQUEST_URI'], "session.php") || !defined('T3_ABSPATH')) {
    die("no access");
}
#   TemaTres : aplicación para la gestión de lenguajes documentales #       #
#                                                                        #
#   Copyright (C) 2004-2015 Diego Ferreyra tematres@r020.com.ar
#   Distribuido bajo Licencia GNU Public License, versión 2 (de junio de 1.991) Free Software Foundation
#
###############################################################################################################
# Include para alta y modificacion de usuarios genericos.
if (is_numeric($_GET["user_id"])) {
    $dato_user = ARRAYdatosUser($_GET["user_id"]);
}
if ($dato_user["id"]) {
    $resumen = ARRAYresumen($_SESSION["id_tesa"], "U", $dato_user["id"]);
    $row_resumen .= '<div id="cajaAncha">' . "\n\r";
    $row_resumen .= '  <div><strong>' . LABEL_Acciones . '</strong></div><dl class="dosCol">' . "\n\r";
    if ($resumen[cant_total] > 0) {
        $row_resumen .= '<dt><a href="sobre.php?user_id=' . $dato_user["id"] . '" title="' . LABEL_Terminos . '">' . ucfirst(LABEL_Terminos) . '</dt><dd>' . $resumen[cant_total] . '</a>&nbsp;</dd>' . "\n\r";
    } else {
        $row_resumen .= '<dt>' . ucfirst(LABEL_Terminos) . '</dt><dd>' . $resumen["cant_total"] . "&nbsp;</dd>\n\r";
    }
    $row_resumen .= '<dt>' . ucfirst(LABEL_RelTerminos) . '</dt><dd>' . $resumen["cant_rel"] . "&nbsp;</dd>\n\r";
    $row_resumen .= '<dt>' . ucfirst(LABEL_TerminosUP) . '</dt><dd>' . $resumen["cant_up"] . "&nbsp;</dd>\n\r";
    $row_resumen .= '</dl></div>';
}
$rows .= '<form role="form" name="login" id="form-users" data-toggle="validator" action="admin.php" method="post">';
$rows .= '	<div class="row">
		<div class="col-sm-12">
				<legend><a href="admin.php?user_id=list" title="' . LABEL_AdminUser . '">' . LABEL_AdminUser . '</a></legend>
示例#4
0
#   TemaTres : aplicación para la gestión de lenguajes documentales #       #
#                                                                        #
#   Copyright (C) 2004-2008 Diego Ferreyra tematres@r020.com.ar
#   Distribuido bajo Licencia GNU Public License, versión 2 (de junio de 1.991) Free Software Foundation
#
###############################################################################################################
# Include para actualizacion de datos propios. #
$user_id = '0';
$user_id = $_GET[user_id] && $_SESSION[$_SESSION["CFGURL"]][ssuser_nivel] == '1' ? $_GET[user_id] : $_SESSION[$_SESSION["CFGURL"]][ssuser_id];
if ($_POST[actuaDatos]) {
    $user_id = $_SESSION[$_SESSION["CFGURL"]][ssuser_nivel] == '1' ? $_POST[actuaDatos] : $_SESSION[$_SESSION["CFGURL"]][ssuser_id];
    $user_id = admin_users("actua", secure_data($user_id, "sql"));
    $row_resumen = '<p class="success">' . MSG_ResultCambios . '</p>' . "\n\r";
}
$resumen = ARRAYresumen($_SESSION[id_tesa], "U", secure_data($user_id, "sql"));
$row_resumen .= '<div id="cajaAncha">' . "\n\r";
$row_resumen .= '<strong>' . ucfirst(LABEL_Acciones) . '</strong><dl class="dosCol">' . "\n\r";
$row_resumen .= '<dt>' . ucfirst(LABEL_Terminos) . '</dt><dd>' . $resumen[cant_total] . "</dd>\n\r";
$row_resumen .= '<dt>' . ucfirst(LABEL_RelTerminos) . '</dt><dd>' . $resumen[cant_rel] . "</dd>\n\r";
$row_resumen .= '<dt>' . ucfirst(LABEL_TerminosUP) . '</dt><dd> ' . $resumen[cant_up] . "</dd>\n\r";
$row_resumen .= '</dl></div>';
$dato_user = ARRAYdatosUser($user_id);
$nombre_boton = LABEL_actualizar;
?>
<div id="bodyText">
<fieldset>
    <legend><?php 
echo MENU_MisDatos;
?>
</legend>
function HTMLformExport()
{
    $LABEL_jtxt = MENU_ListaSis . ' (txt)';
    $LABEL_abctxt = MENU_ListaAbc . ' (txt)';
    $rows .= '<form class="" role="form"  name="export" action="xml.php" method="get">';
    $rows .= '	<div class="row">
    <div class="col-sm-12">
        <legend>' . ucfirst(LABEL_Admin) . '</legend>
    </div>
    <!-- panel  -->

    <div class="col-lg-7">
        <h4>' . ucfirst(LABEL_export) . '</h4>
        <div class="panel panel-default">
            <div class="panel-body form-horizontal">';
    $rows .= '<div class="form-group"><label class="col-sm-3 control-label" for="report_tvocab_id" accesskey="t">' . ucfirst(FORM_LABEL_format_export) . '</label>';
    $rows .= '<div class="col-sm-9">';
    $rows .= '<select class="form-control" id="dis" name="dis">';
    $rows .= doSelectForm(array("jtxt#{$LABEL_jtxt}", "txt#{$LABEL_abctxt}", "moodfile#Moodle", "zline#Zthes", "rfile#Skos-Core", "rxtm#TopicMap", "BSfile#BS8723", "madsFile#Metadata Authority Description Schema (MADS)", "vfile#IMS Vocabulary Definition Exchange (VDEX)", "wxr#WXR (Wordpress XML)", "siteMap#SiteMap", "rsql#SQL (Backup)"), "{$_GET['dis']}");
    $rows .= '</select>';
    $rows .= '</div>';
    $rows .= '</div>';
    $rows .= '<div style="display:none;" id="skos_config">';
    $sqlTopTerm = SQLverTopTerm();
    if (SQLcount($sqlTopTerm) > 0) {
        while ($arrayTopTerms = $sqlTopTerm->FetchRow()) {
            $formSelectTopTerms[] = $arrayTopTerms[tema_id] . '#' . $arrayTopTerms[tema];
        }
        $rows .= '<div class="form-group"><label class="col-sm-3 control-label" for="hasTopTermSKOS" accesskey="t">' . ucfirst(LABEL_TopTerm) . '</label>';
        $rows .= '<div class="col-sm-9">';
        $rows .= '<select class="form-control" id="hasTopTermSKOS" name="hasTopTermSKOS">';
        $rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
        $rows .= doSelectForm($formSelectTopTerms, "{$_GET['hasTopTermSKOS']}");
        $rows .= '</select>';
        $rows .= '</div>';
        $rows .= '</div>';
    }
    $rows .= '</div>';
    $rows .= '<div style="display:none;" id="txt_config">';
    $arrayVocabStats = ARRAYresumen($_SESSION[id_tesa], "G", "");
    if (SQLcount($sqlTopTerm) > 0) {
        $rows .= '<div class="form-group"><label class="col-sm-3 control-label" for="hasTopTerm" accesskey="t">' . ucfirst(LABEL_TopTerm) . '</label>';
        $rows .= '<div class="col-sm-9">';
        $rows .= '<select class="form-control" id="hasTopTerm" name="hasTopTerm">';
        $rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
        $rows .= doSelectForm($formSelectTopTerms, "{$_GET['hasTopTerm']}");
        $rows .= '</select>';
        $rows .= '</div>';
        $rows .= '</div>';
    }
    $rows .= '<fieldset>    <legend>' . ucfirst(LABEL_include_data) . '</legend>';
    //Evaluar si hay notas
    if (is_array($arrayVocabStats["cant_notas"])) {
        $LabelNB = array('NB', LABEL_NB);
        $LabelNH = array('NH', LABEL_NH);
        $LabelNA = array('NA', LABEL_NA);
        $LabelNP = array('NP', LABEL_NP);
        $LabelNC = array('NC', LABEL_NC);
        $sqlNoteType = SQLcantNotas();
        $arrayNoteType = array();
        while ($arrayNotes = $sqlNoteType->FetchRow()) {
            if ($arrayNotes[cant] > 0) {
                //nota privada no
                if ($arrayNotes["value_id"] !== '11') {
                    $varNoteType = in_array($arrayNotes["value_id"], array(8, 9, 10, 11, 15)) ? arrayReplace(array(8, 9, 10, 11, 15), array($LabelNA[1], $LabelNH[1], $LabelNB[1], $LabelNP[1], $LabelNC[1]), $arrayNotes["value_id"]) : $arrayNotes["value"];
                    $varNoteTypeCode = in_array($arrayNotes["value_id"], array(8, 9, 10, 11, 15)) ? arrayReplace(array(8, 9, 10, 11, 15), array($LabelNA[0], $LabelNH[0], $LabelNB[0], $LabelNP[0], $LabelNC[0]), $arrayNotes["value_id"]) : $arrayNotes["value_code"];
                    $rows_notes .= '<div class="form-group"><div class="col-sm-4"><label for="includeNote' . $arrayNotes["value_id"] . '" accesskey="d">' . ucfirst($varNoteType) . '</label>';
                    $rows_notes .= '</div>';
                    $rows_notes .= '<input name="includeNote[]" type="checkbox" id="includeNote' . $arrayNotes["value_id"] . '" value="' . $varNoteTypeCode . '" />';
                    $rows_notes .= '</div>';
                }
            }
        }
        $rows .= '<div class="form-group">					<div class="col-sm-4"><label for="includeTopTerm" accesskey="t">' . ucfirst(TT_terminos) . '</label></div>';
        $rows .= '<input name="includeTopTerm" type="checkbox" id="includeTopTerm" value="1" />';
        $rows .= '</div>';
        /*
        Si hay m�s de un tipo de nota
        */
        if (count($arrayVocabStats["cant_notas"]) > 0) {
            $rows .= $rows_notes;
        }
    }
    $rows .= '<div class="form-group"><div class="col-sm-4"><label for="includeCreatedDate" accesskey="d">' . ucfirst(LABEL_Fecha) . '</label></div>';
    $rows .= '<input name="includeCreatedDate" type="checkbox" id="includeCreatedDate" value="1" />';
    $rows .= '</div>';
    $rows .= '<div class="form-group"><div class="col-sm-4"><label for="includeModDate" accesskey="m">' . ucfirst(LABEL_lastChangeDate) . '</label></div>';
    $rows .= '<input name="includeModDate" type="checkbox" id="includeModDate" value="1" />';
    $rows .= '</div>';
    $rows .= '				</div>';
    $rows .= '<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>';
    $rows .= '				</div>
		</div>
	</div> <!-- / panel  -->';
    $rows .= '</form>';
    $rows .= '<script type=\'text/javascript\'>//<![CDATA[
$(window).load(function(){
$(\'#dis\').bind(\'change\', function(event) {

    var x = $(\'#dis\').val();
    if (x == "txt") {
        $(\'#txt_config\').show();
    }
    else{
        $(\'#txt_config\').hide();
    };

    if (x == "rfile") {
        $(\'#skos_config\').show();
    }
    else{
        $(\'#skos_config\').hide();
    }
});
});//]]>

</script>';
    return $rows;
}
示例#6
0
			</div>	
<!-- body, or middle section of our header -->   

    <!-- ###### Header ###### -->
    <div id="header">
      <h1><a href="index.php" title="<?php 
echo $_SESSION[CFGTitulo] . ': ' . MENU_ListaSis;
?>
 "><?php 
echo $_SESSION[CFGTitulo];
?>
</a></h1>
	</div>	

    <?php 
$resumen = ARRAYresumen($_SESSION[id_tesa], "G", "");
$fecha_crea = do_fecha($_SESSION[CFGCreacion]);
?>
<div id="bodyText">
     <h1><?php 
echo $_SESSION[CFGTitulo];
?>
 / <?php 
echo $_SESSION[CFGAutor];
?>
</h1>
        <dl id="sumario">
        <dt><?php 
echo ucfirst(LABEL_URI);
?>
</dt><dd><?php 
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;
}
"  type="text">
               <input class="btn btn-default" type="submit" value="<?php 
echo LABEL_Buscar;
?>
" />
             </div>
           </div>
         </form>

       </div>

     </div>
   </nav>
   <div class="container">
    <?php 
$resumen = ARRAYresumen($_SESSION["id_tesa"], "G", "");
$fecha_crea = do_fecha($_SESSION["CFGCreacion"]);
$fecha_mod = do_fecha($_SESSION["CFGlastMod"]);
$ARRAYmailContact = ARRAYfetchValue('CONTACT_MAIL');
?>
<div class="container" id="bodyText">

     <h1><?php 
echo $_SESSION[CFGTitulo];
?>
 / <?php 
echo $_SESSION[CFGAutor];
?>
</h1>
        <dl class="dl-horizontal" id="sumario">
        <dt><?php