function dataSimpleChkUpdateTterm($method, $tterm_uri)
{
require_once 'vocabularyservices.php';
switch ($method) {
case 'tematres':
return getURLdata($tterm_uri);
break;
default:
return getURLdata($tterm_uri);
break;
}
}
function HTMLformAssociateTargetTerms($ARRAYtermino, $term_id = "0")
{
$sql = SQLtargetVocabulary("1");
$rows = '<div class="container" id="bodyText">';
$rows .= '<a class="topOfPage" href="index.php?tema=' . $ARRAYtermino["idTema"] . '" title="' . LABEL_Anterior . '">' . LABEL_Anterior . '</a>';
if (SQLcount($sql) == '0') {
//No hay vocabularios de referencia, solo vocabulario principal
$rows .= HTMLalertNoTargetVocabulary();
} else {
//Hay vobularios de referencia
$array_vocabularios = array();
while ($array = $sql->FetchRow()) {
if ($array[vocabulario_id] !== '1') {
//vocabularios que no sean el vocabulario principal
array_push($array_vocabularios, $array[tvocab_id] . '#' . FixEncoding($array[tvocab_label]));
}
}
$arrayOptions = strlen($ARRAYtermino["code"]) > 0 ? array('string#' . ucfirst(LABEL_string2search), 'reverse#' . ucfirst(LABEL_reverseMappign), 'code#' . LABEL_CODE) : array('string#' . ucfirst(LABEL_string2search), 'reverse#' . ucfirst(LABEL_reverseMappign));
$display = in_array($_GET[search_by], array('reverse', 'code')) ? 'style="display: none;"' : '';
$string2search = $_GET[string2search] ? XSSprevent($_GET[string2search]) : $ARRAYtermino["titTema"];
$rows .= '<form class="" role="form" name="alta_tt" id="alta_tt" action="index.php" method="get">';
$rows .= ' <div class="row">
<div class="col-sm-12">
<legend>' . ucfirst(LABEL_relacion_vocabulario) . ' <a href="index.php?tema=' . $ARRAYtermino["idTema"] . '">' . $ARRAYtermino["titTema"] . '</a></legend>
</div>
<!-- panel -->
<div class="col-lg-7">
<div class="panel panel-default">
<div class="panel-body form-horizontal">
<div class="form-group">
<label for="tvocab_id" class="col-sm-3 control-label">' . ucfirst(FORM_LABEL_nombre_vocabulario) . '</label>
<div class="col-sm-9">
<select class="form-control" id="tvocab_id" name="tvocab_id">
' . doSelectForm($array_vocabularios, $_GET["tvocab_id"]) . '
</select>
</div>
</div>';
//Configurar opcion búsqueda por código
$rows .= '<div class="form-group">
<label for="search_by" class="col-sm-3 control-label">' . ucfirst(LABEL_selectMapMethod) . '</label>
<div class="col-sm-9">
<select class="form-control" id="search_by" name="search_by" onChange="mostrar(this.value);">
' . doSelectForm($arrayOptions, $_GET["search_by"]) . '
</select>
</div>
</div>';
$rows .= '<div id="by_string" class="form-group" ' . $display . '>
<label for="string2search" class="col-sm-3 control-label">' . ucfirst(LABEL_Buscar) . '</label>
<div class="col-sm-9">
<input type="text" class="form-control" required type="search" required id="string2search" name="string2search" value="' . $string2search . '">
</div>
</div>
<div class="form-group">
<div class="col-sm-12 text-right">
<button type="submit" class="btn btn-primary" value="' . LABEL_Buscar . '"/>' . ucfirst(LABEL_Buscar) . '</button>
<button type="button" class="btn btn" name="cancelar" type="button" onClick="location.href=\'index.php?tema=' . $ARRAYtermino["idTema"] . '\'" value="' . ucfirst(LABEL_Cancelar) . '"/>' . ucfirst(LABEL_Cancelar) . '</button>
</div>
</div>
</div>
</div>
</div> <!-- / panel -->';
$rows .= '<input type="hidden" name="tema" value="' . $ARRAYtermino["idTema"] . '"/>
<input type="hidden" name="taskterm" value="findTargetTerm"/>';
$rows .= '</form>';
}
$rows .= '</div>';
if ($string2search && $_GET["tvocab_id"]) {
require_once T3_ABSPATH . 'common/include/vocabularyservices.php';
$arrayVocab = ARRAYtargetVocabulary($_GET["tvocab_id"]);
switch ($_GET["search_by"]) {
case 'string':
$dataTerm = getURLdata($arrayVocab[tvocab_uri_service] . '?task=search&arg=' . urlencode($string2search));
break;
case 'code':
$dataTerm = getURLdata($arrayVocab[tvocab_uri_service] . '?task=fetchCode&arg=' . urlencode($ARRAYtermino["code"]));
break;
case 'reverse':
$dataTerm = getURLdata($arrayVocab[tvocab_uri_service] . '?task=fetchSourceTerms&arg=' . rawurlencode($ARRAYtermino["titTema"]));
break;
default:
$dataTerm = getURLdata($arrayVocab[tvocab_uri_service] . '?task=search&arg=' . urlencode($string2search));
break;
}
$rows .= HTMLtargetVocabularySearchResult($dataTerm, $_GET[string2search], $arrayVocab, $ARRAYtermino["idTema"]);
}
//fin de if buscar
$rows .= ' </div>';
$rows .= '<script type="text/javascript">
function mostrar(id) {
((id == "string") ? $("#by_string").show() : $("#by_string").hide());
}
</script>';
return $rows;
}
function do_target_temaXcode($tema_id, $code, $tvocab_id)
{
global $DBCFG;
$userId = $_SESSION[$_SESSION["CFGURL"]][ssuser_id];
// check valid data
$tema_id = secure_data($tema_id, "int");
$tvocab_id = secure_data($tvocab_id, "int");
$code = secure_data($code, "alnum");
// retrieve data about target vocabulary
$arrayVocab = ARRAYtargetVocabulary($tvocab_id);
require_once T3_ABSPATH . 'common/include/vocabularyservices.php';
$dataTterm = getURLdata($arrayVocab[tvocab_uri_service] . '?task=fetchCode&arg=' . $code);
$tterm_id = (int) $dataTterm->result->term->term_id;
$tterm_string = (string) $dataTterm->result->term->string;
if ((int) $dataTterm->result->term->term_id > 0) {
$arrayTterm["tterm_uri"] = $arrayVocab["tvocab_uri_service"] . '?task=fetchTerm&arg=' . $tterm_id;
$arrayTterm["tterm_url"] = $arrayVocab["tvocab_url"] . '?tema=' . $tterm_id;
$arrayTterm["tterm_string"] = secure_data($tterm_string, "ADOsql");
$sql = SQLo("insert", "into {$DBCFG['DBprefix']}term2tterm (tema_id,tvocab_id,tterm_url,tterm_uri,tterm_string,cuando,uid)\r\n\t\t\t\tvalues (?,?,?,?,{$arrayTterm['tterm_string']},now(),?)", array($tema_id, $arrayVocab[tvocab_id], $arrayTterm[tterm_url], $arrayTterm[tterm_uri], $userId));
$target_relation_id = $sql[cant];
}
return array("tterm_id" => $target_relation_id);
}
function getForeingStrings($tvocab_uri_service, $task, $array_terms)
{
$arrayTtermData = array();
if (!in_array($task, array('fetchAlt', 'fetchDown', 'fetchRelated', 'fetchTerms'))) {
return array();
}
if (count($array_terms) < 1) {
return array();
}
foreach ($array_terms as $term) {
$dataTerm = getURLdata($tvocab_uri_service . '?task=' . $task . '&arg=' . $term["term_id"]);
if ($dataTerm->resume->cant_result > "0") {
foreach ($dataTerm->result->term as $value) {
$i = ++$i;
$term_id = (int) $value->term_id;
$string = (string) $value->string;
$arrayTtermData[$term_id] = array("term_id" => $term_id, "string" => $string, "source_string" => $term["string"], "source_term_id" => $term["term_id"]);
}
}
}
return $arrayTtermData;
}
