function HTMLformAdvancedSearch($array)
{
    global $CFG;
    $array = XSSpreventArray($array);
    $rows .= '<div class="row">';
    $rows .= '	<div class="col-md-6 col-md-offset-3">';
    $rows .= ' <h3>' . ucfirst(LABEL_BusquedaAvanzada) . '</h3>';
    $rows .= '<form  class="col-xs-8 form-horizontal" role="form" name="advancedsearch" action="index.php#xstring" method="get">';
    $rows .= '<fieldset>';
    $LABEL_Termino = ucfirst(LABEL_Termino);
    $LABEL_esNoPreferido = ucfirst(LABEL_esNoPreferido);
    $LABEL_CODE = ucfirst(LABEL_CODE);
    $LABEL_NOTE = ucfirst(LABEL_nota);
    $LABEL_META_TERM = ucfirst(LABEL_meta_term);
    $LABEL_TARGET_TERM = ucfirst(LABEL_TargetTerm);
    $arrayWS = array("t#{$LABEL_Termino}", "mt#{$LABEL_META_TERM}");
    $arrayVocabStats = ARRAYresumen($_SESSION[id_tesa], "G", "");
    if ($arrayVocabStats["cant_up"] > 0) {
        array_push($arrayWS, "uf#{$LABEL_esNoPreferido}");
    }
    if ($arrayVocabStats["cant_notas"] > 0) {
        array_push($arrayWS, "n#{$LABEL_NOTE}");
    }
    if ($CFG["_SHOW_CODE"] == '1') {
        array_push($arrayWS, "c#{$LABEL_CODE}");
    }
    if ($arrayVocabStats["cant_term2tterm"]) {
        array_push($arrayWS, "tgt#{$LABEL_TARGET_TERM}");
    }
    /*
    solo si hay m�s de un opci�n
    */
    if (count($arrayWS) > 1) {
        $rows .= '<div class="form-group"><label class="label_ttl control-label" for="ws" accesskey="f">' . ucfirst(LABEL_QueBuscar) . '</label>';
        $rows .= '<select class="select_ttl form-control" id="ws" name="ws">';
        $rows .= doSelectForm($arrayWS, "{$_GET['ws']}");
        $rows .= '</select>';
        $rows .= '</div>';
    }
    $rows .= '<div class="form-group"><label class="label_ln control-label" for="xstring" accesskey="s">' . ucfirst(LABEL_BuscaTermino) . '</label>';
    $rows .= '<input name="xstring" class="input_ln form-control" required type="search" id="xstring" size="25" maxlength="50" value="' . $array["xstring"] . '"/>';
    $rows .= '	<div class="checkbox-inline" ><label class="btn btn-default" for="isExactMatch" accesskey="f">';
    $rows .= '	<input name="isExactMatch" type="checkbox" id="isExactMatch" value="1" ' . do_check('1', $_GET["isExactMatch"], "checked") . '/>' . ucfirst(LABEL_esFraseExacta) . '</label>';
    $rows .= ' 	</div>';
    $rows .= '</div>';
    $rows .= '<div class="collapse" id="masOpcionesBusqueda">';
    //Evaluar si hay top terms
    $sqlTopTerm = SQLverTopTerm();
    if (SQLcount($sqlTopTerm) > 0) {
        while ($arrayTopTerms = $sqlTopTerm->FetchRow()) {
            $formSelectTopTerms[] = $arrayTopTerms["tema_id"] . '#' . $arrayTopTerms[tema];
        }
        $rows .= '<div class="form-group"><label class="label_ttl control-label" for="hasTopTerm" accesskey="t">' . ucfirst(LABEL_TopTerm) . '</label>';
        $rows .= '<select class="select_ttl form-control" id="hasTopTerm" name="hasTopTerm">';
        $rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
        $rows .= doSelectForm($formSelectTopTerms, "{$_GET['hasTopTerm']}");
        $rows .= '</select>';
        $rows .= '</div>';
    }
    //Evaluar si hay notas
    if (is_array($arrayVocabStats["cant_notas"])) {
        $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 ($arrayNotes = $sqlNoteType->FetchRow()) {
            if ($arrayNotes[cant] > 0) {
                //nota privada no
                if ($_SESSION[$_SESSION["CFGURL"]][ssuser_nivel] || $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, $LabelNH, $LabelNB, $LabelNP, $LabelNC), $arrayNotes["value_id"]) : $arrayNotes["value_code"] . '#' . $arrayNotes["value"];
                    $varNoteType .= ' (' . $arrayNotes[cant] . ')';
                    array_push($arrayNoteType, $varNoteType);
                }
            }
        }
        /*
        Si hay m�s de un tipo de nota
        */
        if (count($arrayVocabStats["cant_notas"]) > 0) {
            $rows .= '<div class="form-group"><label class="label_ttl control-label" for="hasNote" accesskey="n">' . ucfirst(LABEL_tipoNota) . '</label>';
            $rows .= '<select class="select_ttl form-control" id="hasNote" name="hasNote">';
            $rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
            $rows .= doSelectForm($arrayNoteType, "{$_GET['hasNote']}");
            $rows .= '</select>';
            $rows .= '</div>';
        }
    }
    //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] . ')';
        }
        $rows .= '<div class="form-group"><label class="label_ttl control-label" for="fromDate" accesskey="d">' . ucfirst(LABEL_DesdeFecha) . '</label>';
        $rows .= '<select class="select_ttl form-control" id="fromDate" name="fromDate">';
        $rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
        $rows .= doSelectForm($formSelectByDate, "{$_GET['fromDate']}");
        $rows .= '</select>';
        $rows .= '</div>';
    }
    //terms by deep
    $sqlTermsByDeep = SQLTermDeep();
    if (SQLcount($sqlTermsByDeep) > 1) {
        while ($arrayTermsByDeep = $sqlTermsByDeep->FetchRow()) {
            $formSelectByDeep[] = $arrayTermsByDeep[tdeep] . '#' . $arrayTermsByDeep[tdeep] . ' (' . $arrayTermsByDeep[cant] . ')';
        }
        $rows .= '<div class="form-group"><label class="label_ttl control-label" for="termDeep" accesskey="e">' . ucfirst(LABEL_ProfundidadTermino) . '</label>';
        $rows .= '<select class="select_ttl form-control" id="termDeep" name="termDeep">';
        $rows .= '<option value="">' . ucfirst(LABEL_Todos) . '</option>';
        $rows .= doSelectForm($formSelectByDeep, "{$_GET['termDeep']}");
        $rows .= '</select>';
        $rows .= '</div>';
    }
    $rows .= '</div>';
    //hide div
    $rows .= '<div class="btn-group">';
    $rows .= '<input type="submit"  id="boton" name="boton" class="btn btn-primary" value="' . LABEL_Enviar . '"/>';
    $rows .= ' <button class="btn btn-default" type="button" data-toggle="collapse" data-target="#masOpcionesBusqueda" aria-expanded="false" aria-controls="masOpcionesBusqueda">' . ucfirst(LABEL_Opciones) . '</button>';
    //$rows.='<input type="button" class="btn btn-default" name="cancelar" type="button" onClick="location.href=\'index.php\'" value="'.ucfirst(LABEL_Cancelar).'"/>';
    $rows .= '</div>';
    $rows .= '<input type="hidden"  name="xsearch" id="xsearch" value="1"/>';
    $rows .= '  </fieldset>';
    $rows .= '</form>';
    $rows .= '</div>';
    //div row
    $rows .= '</div>';
    //div col
    $rows .= '<div class="push"></div>';
    if ($_GET[boton] == LABEL_Enviar) {
        $rows .= HTMLadvancedSearchResult($array);
    }
    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 HTMLdeepStats()
{
    $sql = SQLTermDeep();
    $rows .= '<div class="table-responsive col-xs-6 col-md-4">
	  <table class="table  table-bordered table-condensed table-hover" summary="' . LABEL . '">
	  <thead><tr><tr><th>' . ucfirst(LABEL_deepLevel) . '</th><th>' . ucfirst(LABEL_cantTerms) . '</th></tr></thead>
	  <tbody>';
    while ($array = $sql->FetchRow()) {
        # code...
        $rows .= '<tr><td class="centrado">' . ucfirst(LABEL_deepLevel) . ' ' . $array["tdeep"] . '</td><td class="centrado">' . $array["cant"] . '</td>';
    }
    $rows .= '</tbody>
		</table>
		</div>';
    return $rows;
}