function abm_targetVocabulary($do, $tvocab_id = "0")
{
global $DBCFG;
$user_id = $_SESSION[$_SESSION["CFGURL"]][ssuser_id];
switch ($do) {
case 'A':
//Alta de vocabulario de referencia
require 'vocabularyservices.php';
$arrayVocab[tvocab_uri_service] = $_POST[tvocab_uri_service];
$arrayVocab = xmlVocabulary2array($arrayVocab[tvocab_uri_service] . '?task=fetchVocabularyData');
/*
Check web services
*/
if ($arrayVocab[result][vocabulary_id] == '1') {
$array[tvocab_label] = $_POST[tvocab_label];
$array[tvocab_tag] = $_POST[tvocab_tag];
$array[tvocab_title] = $arrayVocab[result][title];
$array[tvocab_uri] = $arrayVocab[result][uri];
$array[tvocab_uri_service] = $_POST[tvocab_uri_service];
$array[tvocab_status] = $_POST[tvocab_status];
$sql = SQL("insert", "into {$DBCFG['DBprefix']}tvocab (tvocab_label, tvocab_tag, tvocab_title, tvocab_url, tvocab_uri_service, tvocab_status, cuando, uid) \r\n\t\tVALUES \r\n\t\t('{$array['tvocab_label']}', '{$array['tvocab_tag']}', '{$array['tvocab_title']}', '{$array['tvocab_uri']}', '{$array['tvocab_uri_service']}', '{$array['tvocab_status']}', now(), '{$user_id}')");
$tvocab_id = $sql[cant];
} else {
return false;
}
break;
case 'M':
require 'vocabularyservices.php';
$arrayVocab = ARRAYtargetVocabulary($tvocab_id);
$arrayVocab = xmlVocabulary2array($arrayVocab[tvocab_uri_service] . '?task=fetchVocabularyData');
/*
Check web services
*/
if ($arrayVocab[result][vocabulary_id] == '1') {
$array[tvocab_label] = $_POST[tvocab_label];
$array[tvocab_tag] = $_POST[tvocab_tag];
$array[tvocab_status] = $_POST[tvocab_status];
$array[tvocab_title] = $arrayVocab[result][title];
$array[tvocab_uri] = $arrayVocab[result][uri];
$array[tvocab_uri_service] = $arrayVocab[tvocab_uri_service];
$sql = SQL("update", "{$DBCFG['DBprefix']}tvocab set \r\n\t\ttvocab_label='{$array['tvocab_label']}', \r\n\t\ttvocab_tag='{$array['tvocab_tag']}', \r\n\t\ttvocab_title='{$array['tvocab_title']}',\r\n\t\ttvocab_url= '{$array['tvocab_uri']}', \r\n\t\ttvocab_uri_service='{$array['tvocab_uri_service']}', \r\n\t\ttvocab_status='{$array['tvocab_status']}', \r\n\t\tcuando=now(), \r\n\t\tuid='{$user_id}'\r\n\t\twhere tvocab_id='{$tvocab_id}'");
} else {
//actualiza solo datos consignados
$array[tvocab_label] = $_POST[tvocab_label];
$array[tvocab_tag] = $_POST[tvocab_tag];
$array[tvocab_status] = $_POST[tvocab_status];
$sql = SQL("update", "{$DBCFG['DBprefix']}tvocab set \r\n\t\ttvocab_label='{$array['tvocab_label']}', \r\n\t\ttvocab_tag='{$array['tvocab_tag']}', \r\n\t\ttvocab_status='{$array['tvocab_status']}', \r\n\t\tcuando=now(), \r\n\t\tuid='{$user_id}'\r\n\t\twhere tvocab_id='{$tvocab_id}'");
}
break;
case 'B':
//Eliminacion de un vocabulario de REFERENCIA
//delete referenced terms from the service
$sql = SQL("delete", "from {$DBCFG['DBprefix']}term2tterm where tvocab_id='{$tvocab_id}'");
//delete referenced service
$sql = SQL("delete", "from {$DBCFG['DBprefix']}tvocab where tvocab_id='{$tvocab_id}'");
break;
}
return array("tvocab_id" => $tvocab_id);
}
function HTMLformAssociateTargetTerms($ARRAYtermino, $term_id = "0")
{
$sql = SQLtargetVocabulary("1");
$rows = '<div id="bodyText">';
$rows .= '<a class="topOfPage" href="javascript: history.go(-1);">' . LABEL_Anterior . '</a>';
$rows .= '<h1>' . LABEL_EditorTermino . '</h1>';
$rows .= ' <fieldset>';
$rows .= ' <legend>' . LABEL_relacion_vocabulario . ' <a href="index.php?tema=' . $ARRAYtermino[idTema] . '">' . $ARRAYtermino[titTema] . '</a></legend>';
if (!$sql[cant]) {
//No hay vocabularios de referencia, solo vocabulario principal
$rows .= '<p class="error">' . ucfirst(LABEL_NO_vocabulario_referencia) . '</p>';
} else {
//Hay vobularios de referencia
$array_vocabularios = array();
while ($array = mysqli_fetch_array($sql[datos])) {
if ($array[vocabulario_id] !== '1') {
//vocabularios que no sean el vocabulario principal
array_push($array_vocabularios, $array[tvocab_id] . '#' . FixEncoding($array[tvocab_label]));
}
}
$rows .= '<form class="formdiv" name="alta_tt" action="index.php" method="get" onsubmit="return checkrequired(this)">';
$rows .= '<div>';
$rows .= '<label for="tvocab_id" accesskey="t">';
$rows .= FORM_LABEL_nombre_vocabulario . '*</label>';
$rows .= '<select id="tvocab_id" name="tvocab_id">';
$rows .= '<optgroup label="' . FORM_LABEL_nombre_vocabulario . '">';
$rows .= doSelectForm($array_vocabularios, "");
$rows .= '</optgroup>';
$rows .= '</select><br/>';
$rows .= '</div>';
$rows .= '<div>';
$rows .= '<label for="string2search" accesskey="s">';
$rows .= LABEL_Buscar . '</label>';
$rows .= '<input name="string2search" type="text" id="string2search" size="15" maxlength="50"/>';
$rows .= '</div>';
$rows .= '<div class="submit_form" align="center">';
$rows .= ' <input type="submit" name="boton" value="' . LABEL_Buscar . '"/>
<input type="button" name="cancelar" type="button" onClick="location.href=\'index.php?tema=' . $ARRAYtermino[idTema] . '\'" value="' . ucfirst(LABEL_Cancelar) . '"/>
<input type="hidden" name="tema" value="' . $ARRAYtermino[idTema] . '"/>
<input type="hidden" name="taskterm" value="findTargetTerm"/>';
$rows .= '</div>';
$rows .= '</form>';
}
$rows .= ' </fieldset>';
if ($_GET[string2search] && $_GET[tvocab_id]) {
require 'vocabularyservices.php';
$arrayVocab = ARRAYtargetVocabulary($_GET[tvocab_id]);
$arrayTerm = xmlVocabulary2array($arrayVocab[tvocab_uri_service] . '?task=search&arg=' . urlencode($_GET[string2search]));
$rows .= HTMLtargetVocabularySearchResult($arrayTerm, $_GET[string2search], $arrayVocab, $ARRAYtermino[idTema]);
}
//fin de if buscar
$rows .= ' </div>';
return $rows;
}
function arrayTerm2html($array)
{
global $URL_BASE;
$rows .= '<h2>' . utf8_decode($array[result][term][string]) . '</h2>';
/*
Notas // notes
*/
$arrayNotes = xmlVocabulary2array($URL_BASE . '?task=fetchNotes&arg=' . $array[result][term][tema_id]);
$rows .= arrayVocabulary2htmlNotes($arrayNotes, "Notes", "ul");
/*
Buscar términos genericos // fetch broader terms
*/
$arrayTG = xmlVocabulary2array($URL_BASE . '?task=fetchUp&arg=' . $array[result][term][tema_id]);
$rows .= arrayVocabulary2html($arrayTG, "Broader terms", "ol");
/*
Buscar términos específicos // fetch narrow terms
*/
$arrayTE = xmlVocabulary2array($URL_BASE . '?task=fetchDown&arg=' . $array[result][term][tema_id]);
$rows .= arrayVocabulary2html($arrayTE, "Narrower terms", "ul");
/*
Buscar términos relacionados // fetch related terms
*/
$arrayTR = xmlVocabulary2array($URL_BASE . '?task=fetchRelated&arg=' . $array[result][term][tema_id]);
$rows .= arrayVocabulary2html($arrayTR, "Related terms", "ul");
return $rows;
}
