static function majNoticesMotsGlobalIndex($notice, $datatype = 'all')
{
global $include_path;
global $dbh, $champ_base;
global $lang;
global $indexation_lang;
//recuperation du fichier xml de configuration
if (!count($champ_base)) {
$file = $include_path . "/indexation/notices/champs_base_subst.xml";
if (!file_exists($file)) {
$file = $include_path . "/indexation/notices/champs_base.xml";
}
$fp = fopen($file, "r");
if ($fp) {
$xml = fread($fp, filesize($file));
}
fclose($fp);
$champ_base = _parser_text_no_function_($xml, "INDEXATION");
}
$tableau = $champ_base;
//analyse des donnees des tables
$temp_not = array();
$temp_not['t'][0][0] = $tableau['REFERENCE'][0][value];
$temp_ext = array();
$temp_marc = array();
$champ_trouve = false;
$tab_code_champ = array();
$tab_languages = array();
$tab_keep_empty = array();
$tab_pp = array();
$tab_authperso = array();
$authperso_code_champ_start = 0;
$isbd_ask_list = array();
for ($i = 0; $i < count($tableau['FIELD']); $i++) {
//pour chacun des champs decrits
//recuperation de la liste des informations a mettre a jour
if ($datatype == 'all' || $datatype == $tableau['FIELD'][$i]['DATATYPE']) {
//conservation des mots vides
if ($tableau['FIELD'][$i]['KEEPEMPTYWORD'] == "yes") {
$tab_keep_empty[] = $tableau['FIELD'][$i]['ID'];
}
//champ perso
if ($tableau['FIELD'][$i]['DATATYPE'] == "custom_field") {
$tab_pp[$tableau['FIELD'][$i]['ID']] = $tableau['FIELD'][$i]['TABLE'][0]['value'];
//autorité perso
} elseif ($tableau['FIELD'][$i]['DATATYPE'] == "authperso") {
$tab_authperso[$tableau['FIELD'][$i]['ID']] = $tableau['FIELD'][$i]['TABLE'][0]['value'];
$authperso_code_champ_start = $tableau['FIELD'][$i]['ID'];
$authpersos = new authperso_notice($notice);
} else {
if ($tableau['FIELD'][$i]['EXTERNAL'] == "yes") {
//champ externe à la table notice
//Stockage de la structure pour un accès plus facile
$temp_ext[$tableau['FIELD'][$i]['ID']] = $tableau['FIELD'][$i];
} else {
//champ de la table notice
$temp_not['f'][0][$tableau['FIELD'][$i]['ID']] = $tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['value'];
$tab_code_champ[0][$tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['value']] = array('champ' => $tableau['FIELD'][$i]['ID'], 'ss_champ' => 0, 'pond' => $tableau['FIELD'][$i]['POND'], 'no_words' => $tableau['FIELD'][$i]['DATATYPE'] == "marclist" ? true : false, 'internal' => 1, 'use_global_separator' => $tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['USE_GLOBAL_SEPARATOR']);
if ($tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['MARCTYPE']) {
$tab_code_champ[0][$tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['value']]['marctype'] = $tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['MARCTYPE'];
$temp_not['f'][0][$tableau['FIELD'][$i]['ID'] . "_marc"] = $tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['value'] . " as " . "subst_for_marc_" . $tableau['FIELD'][$i]['TABLE'][0]['TABLEFIELD'][0]['MARCTYPE'];
}
}
}
if ($tableau['FIELD'][$i]['ISBD']) {
// isbd autorités
$isbd_ask_list[$tableau['FIELD'][$i]['ID']] = array('champ' => $tableau['FIELD'][$i]['ID'], 'ss_champ' => $tableau['FIELD'][$i]['ISBD'][0]['ID'], 'pond' => $tableau['FIELD'][$i]['ISBD'][0]['POND'], 'class_name' => $tableau['FIELD'][$i]['ISBD'][0]['CLASS_NAME']);
}
$champ_trouve = true;
}
}
if ($champ_trouve) {
$tab_req = array();
//Recherche des champs directs
if ($datatype == 'all') {
$tab_req[0]["rqt"] = "select " . implode(',', $temp_not['f'][0]) . " from " . $temp_not['t'][0][0];
$tab_req[0]["rqt"] .= " where " . $tableau['REFERENCEKEY'][0][value] . "='" . $notice . "'";
$tab_req[0]["table"] = $temp_not['t'][0][0];
}
foreach ($temp_ext as $k => $v) {
$isbd_tab_req = array();
$no_word_field = false;
//Construction de la requete
//Champs pour le select
$select = array();
//on harmonise les fichiers XML décrivant des requetes...
for ($i = 0; $i < count($v["TABLE"]); $i++) {
$table = $v['TABLE'][$i];
$select = array();
if (count($table['TABLEFIELD'])) {
$use_word = true;
} else {
$use_word = false;
}
if ($table['IDKEY'][0]) {
$select[] = $table['NAME'] . "." . $table['IDKEY'][0]['value'] . " as subst_for_autorite_" . $table['IDKEY'][0]['value'];
}
for ($j = 0; $j < count($table['TABLEFIELD']); $j++) {
$select[] = ($table['ALIAS'] ? $table['ALIAS'] . "." : "") . $table['TABLEFIELD'][$j]["value"];
if ($table['LANGUAGE']) {
$select[] = $table['LANGUAGE'][0]['value'];
$tab_languages[$k] = $table['LANGUAGE'][0]['value'];
}
$field_name = $table['TABLEFIELD'][$j]["value"];
if (strpos(strtolower($table['TABLEFIELD'][$j]["value"]), " as ") !== false) {
//Pour le cas où l'on a besoin de nommer un champ et d'utiliser un alias
$field_name = substr($table['TABLEFIELD'][$j]["value"], strpos(strtolower($table['TABLEFIELD'][$j]["value"]), " as ") + 4);
} elseif (strpos($table['TABLEFIELD'][$j]["value"], ".") !== false) {
$field_name = substr($table['TABLEFIELD'][$j]["value"], strpos($table['TABLEFIELD'][$j]["value"], ".") + 1);
}
$field_name = trim($field_name);
$tab_code_champ[$v['ID']][$field_name] = array('champ' => $v['ID'], 'ss_champ' => $table['TABLEFIELD'][$j]["ID"], 'pond' => $table['TABLEFIELD'][$j]['POND'], 'no_words' => $v['DATATYPE'] == "marclist" ? true : false, 'autorite' => $table['IDKEY'][0]['value']);
if ($table['TABLEFIELD'][$j]['MARCTYPE']) {
$tab_code_champ[$v['ID']][$table['TABLEFIELD'][$j]["value"]]['marctype'] = $table['TABLEFIELD'][$j]['MARCTYPE'];
$select[] = $table['NAME'] . "." . $table['TABLEFIELD'][$j]["value"] . " as subst_for_marc_" . $table['TABLEFIELD'][$j]['MARCTYPE'];
}
}
$query = "select " . implode(",", $select) . " from notices";
$jointure = "";
for ($j = 0; $j < count($table['LINK']); $j++) {
$link = $table['LINK'][$j];
if ($link["TABLE"][0]['ALIAS']) {
$alias = $link["TABLE"][0]['ALIAS'];
} else {
$alias = $link["TABLE"][0]['value'];
}
switch ($link["TYPE"]) {
case "n0":
if ($link["TABLEKEY"][0]['value']) {
$jointure .= " LEFT JOIN " . $link["TABLE"][0]['value'] . ($link["TABLE"][0]['value'] != $alias ? " AS " . $alias : "");
if ($link["EXTERNALTABLE"][0]['value']) {
$jointure .= " ON " . $link["EXTERNALTABLE"][0]['value'] . "." . $link["EXTERNALFIELD"][0]['value'];
} else {
$jointure .= " ON " . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $link["EXTERNALFIELD"][0]['value'];
}
$jointure .= "=" . $alias . "." . $link["TABLEKEY"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'];
} else {
$jointure .= " LEFT JOIN " . $table['NAME'] . ($table['ALIAS'] ? " as " . $table['ALIAS'] : "");
$jointure .= " ON " . $tableau['REFERENCE'][0]['value'] . "." . $tableau['REFERENCEKEY'][0]['value'];
$jointure .= "=" . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $link["EXTERNALFIELD"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'];
}
break;
case "n1":
if ($link["TABLEKEY"][0]['value']) {
$jointure .= " JOIN " . $link["TABLE"][0]['value'] . ($link["TABLE"][0]['value'] != $alias ? " AS " . $alias : "");
if ($link["EXTERNALTABLE"][0]['value']) {
$jointure .= " ON " . $link["EXTERNALTABLE"][0]['value'] . "." . $link["EXTERNALFIELD"][0]['value'];
} else {
$jointure .= " ON " . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $link["EXTERNALFIELD"][0]['value'];
}
$jointure .= "=" . $alias . "." . $link["TABLEKEY"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'];
} else {
$jointure .= " JOIN " . $table['NAME'] . ($table['ALIAS'] ? " as " . $table['ALIAS'] : "");
$jointure .= " ON " . $tableau['REFERENCE'][0]['value'] . "." . $tableau['REFERENCEKEY'][0]['value'];
$jointure .= "=" . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $link["EXTERNALFIELD"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'];
}
break;
case "1n":
$jointure .= " JOIN " . $table['NAME'] . ($table['ALIAS'] ? " as " . $table['ALIAS'] : "");
$jointure .= " ON (" . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $table["TABLEKEY"][0]['value'];
$jointure .= "=" . $tableau['REFERENCE'][0]['value'] . "." . $link["REFERENCEFIELD"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'] . ") ";
break;
case "nn":
$jointure .= " JOIN " . $link["TABLE"][0]['value'] . ($link["TABLE"][0]['value'] != $alias ? " AS " . $alias : "");
$jointure .= " ON (" . $tableau['REFERENCE'][0]['value'] . "." . $tableau['REFERENCEKEY'][0]['value'];
$jointure .= "=" . $alias . "." . $link["REFERENCEFIELD"][0]['value'] . ") ";
if ($link["TABLEKEY"][0]['value']) {
$jointure .= " JOIN " . $table['NAME'] . ($table['ALIAS'] ? " as " . $table['ALIAS'] : "");
$jointure .= " ON (" . $alias . "." . $link["TABLEKEY"][0]['value'];
$jointure .= "=" . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $link["EXTERNALFIELD"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'] . ") ";
} else {
$jointure .= " JOIN " . $table['NAME'] . ($table['ALIAS'] ? " as " . $table['ALIAS'] : "");
$jointure .= " ON (" . $alias . "." . $link["EXTERNALFIELD"][0]['value'];
$jointure .= "=" . ($table['ALIAS'] ? $table['ALIAS'] : $table['NAME']) . "." . $table["TABLEKEY"][0]['value'] . " " . $link["LINKRESTRICT"][0]['value'] . ") ";
}
break;
}
}
$where = " where " . $temp_not['t'][0][0] . "." . $tableau['REFERENCEKEY'][0][value] . "=" . $notice;
if ($table['FILTER']) {
foreach ($table['FILTER'] as $filter) {
if ($tmp = trim($filter["value"])) {
$where .= " AND (" . $tmp . ")";
}
}
}
if ($table['LANGUAGE']) {
$tab_req_lang[$k] = "select " . $table['LANGUAGE'][0]['value'] . " from ";
}
$query .= $jointure . $where;
if ($table['LANGUAGE']) {
$tab_req_lang[$k] .= $jointure . $where;
}
if ($use_word) {
$tab_req[$k]["new_rqt"]['rqt'][] = $query;
}
if ($isbd_ask_list[$k]) {
// isbd => memo de la requete pour retrouver les id des autorités
$id_aut = $table['NAME'] . "." . $table["TABLEKEY"][0]['value'];
$req = "select {$id_aut} as id_aut_for_isbd from notices" . $jointure . $where;
$isbd_tab_req[] = $req;
}
}
if ($use_word) {
$tab_req[$k]["rqt"] = implode(" union ", $tab_req[$k]["new_rqt"]['rqt']);
}
if ($isbd_ask_list[$k]) {
// isbd => memo de la requete pour retrouver les id des autorités
$req = implode(" union ", $isbd_tab_req);
$isbd_ask_list[$k]['req'] = $req;
}
}
//qu'est-ce qu'on efface?
if ($datatype == 'all') {
$req_del = "delete from notices_mots_global_index where id_notice='" . $notice . "' ";
pmb_mysql_query($req_del, $dbh);
//la table pour les recherche exacte
$req_del = "delete from notices_fields_global_index where id_notice='" . $notice . "' ";
pmb_mysql_query($req_del, $dbh);
} else {
foreach ($tab_code_champ as $subfields) {
foreach ($subfields as $subfield) {
$req_del = "delete from notices_mots_global_index where id_notice='" . $notice . "' and code_champ='" . $subfield['champ'] . "'";
pmb_mysql_query($req_del, $dbh);
//la table pour les recherche exacte
$req_del = "delete from notices_fields_global_index where id_notice='" . $notice . "' and code_champ='" . $subfield['champ'] . "'";
pmb_mysql_query($req_del, $dbh);
break;
}
}
//Les champs perso
if (count($tab_pp)) {
foreach ($tab_pp as $id) {
$req_del = "delete from notices_mots_global_index where id_notice='" . $notice . "' and code_champ=100 and code_ss_champ='" . $id . "' ";
pmb_mysql_query($req_del, $dbh);
//la table pour les recherche exacte
$req_del = "delete from notices_fields_global_index where id_notice='" . $notice . "' and code_champ=100 and code_ss_champ='" . $id . "' ";
pmb_mysql_query($req_del, $dbh);
}
}
//Les autorités perso
if (count($tab_authperso)) {
$authperso_fields = $authpersos->get_index_fields_to_delete();
foreach ($authperso_fields as $code_champ) {
$code_champ += $authperso_code_champ_start;
$req_del = "delete from notices_mots_global_index where id_notice='" . $notice . "' and code_champ={$code_champ} ";
pmb_mysql_query($req_del, $dbh);
//la table pour les recherche exacte
$req_del = "delete from notices_fields_global_index where id_notice='" . $notice . "' and code_champ={$code_champ} ";
pmb_mysql_query($req_del, $dbh);
}
}
}
//qu'est-ce qu'on met a jour ?
$tab_insert = array();
$tab_field_insert = array();
foreach ($tab_req as $k => $v) {
$r = pmb_mysql_query($v["rqt"], $dbh);
$tab_mots = array();
$tab_fields = array();
if (pmb_mysql_num_rows($r)) {
while ($tab_row = pmb_mysql_fetch_array($r, MYSQL_ASSOC)) {
$langage = "";
if (isset($tab_row[$tab_languages[$k]])) {
$langage = $tab_row[$tab_languages[$k]];
unset($tab_row[$tab_languages[$k]]);
}
foreach ($tab_row as $nom_champ => $liste_mots) {
if (substr($nom_champ, 0, 10) == 'subst_for_') {
continue;
}
if ($tab_code_champ[$k][$nom_champ]['internal']) {
$langage = $indexation_lang;
}
if ($tab_code_champ[$k][$nom_champ]['marctype']) {
//on veut toutes les langues, pas seulement celle de l'interface...
$saved_lang = $lang;
$code = $liste_mots;
$dir = opendir($include_path . "/marc_tables");
while ($dir_lang = readdir($dir)) {
if ($dir_lang != "." && $dir_lang != ".." && $dir_lang != "CVS" && $dir_lang != ".svn" && is_dir($include_path . "/marc_tables/" . $dir_lang)) {
$lang = $dir_lang;
$marclist = new marc_list($tab_code_champ[$k][$nom_champ]['marctype']);
$liste_mots = $marclist->table[$code];
$tab_fields[$nom_champ][] = array('value' => trim($liste_mots), 'lang' => $lang, 'autorite' => $tab_row["subst_for_marc_" . $tab_code_champ[$k][$nom_champ]['marctype']]);
}
}
$lang = $saved_lang;
$liste_mots = "";
}
if ($liste_mots != '') {
$tab_tmp = array();
$liste_mots = strip_tags($liste_mots);
if (!in_array($k, $tab_keep_empty)) {
$tab_tmp = explode(' ', strip_empty_words($liste_mots));
} else {
$tab_tmp = explode(' ', strip_empty_chars(clean_string($liste_mots)));
}
// if($lang!="") $tab_tmp[]=$lang;
//la table pour les recherche exacte
if (!$tab_fields[$nom_champ]) {
$tab_fields[$nom_champ] = array();
}
if (!$tab_code_champ[$k][$nom_champ]['use_global_separator']) {
$tab_fields[$nom_champ][] = array('value' => trim($liste_mots), 'lang' => $langage, 'autorite' => $tab_row["subst_for_autorite_" . $tab_code_champ[$k][$nom_champ]['autorite']]);
} else {
$var_global_sep = $tab_code_champ[$k][$nom_champ]['use_global_separator'];
global ${$var_global_sep};
$tab_liste_mots = explode(${$var_global_sep}, $liste_mots);
if (count($tab_liste_mots)) {
foreach ($tab_liste_mots as $mot) {
$tab_fields[$nom_champ][] = array('value' => trim($mot), 'lang' => $langage, 'autorite' => $tab_row["subst_for_autorite_" . $tab_code_champ[$k][$nom_champ]['autorite']]);
}
}
}
if (!$tab_code_champ[$k][$nom_champ]['no_words']) {
foreach ($tab_tmp as $mot) {
if (trim($mot)) {
$langageKey = $langage;
if (!trim($langageKey)) {
$langageKey = "empty";
}
$tab_mots[$nom_champ][$langageKey][] = $mot;
}
}
}
}
}
}
}
foreach ($tab_mots as $nom_champ => $tab) {
$memo_ss_champ = "";
$order_fields = 1;
$pos = 1;
foreach ($tab as $langage => $mots) {
if ($langage == "empty") {
$langage = "";
}
foreach ($mots as $mot) {
//on cherche le mot dans la table de mot...
$num_word = 0;
$query = "select id_word from words where word = '" . $mot . "' and lang = '" . $langage . "'";
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$num_word = pmb_mysql_result($result, 0, 0);
} else {
$dmeta = new DoubleMetaPhone($mot);
$stemming = new stemming($mot);
$element_to_update = "";
if ($dmeta->primary || $dmeta->secondary) {
$element_to_update .= "\n\t\t\t\t\t\t\t\t\t\tdouble_metaphone = '" . $dmeta->primary . " " . $dmeta->secondary . "'";
}
if ($element_to_update) {
$element_to_update .= ",";
}
$element_to_update .= "stem = '" . $stemming->stem . "'";
$query = "insert into words set word = '" . $mot . "', lang = '" . $langage . "'" . ($element_to_update ? ", " . $element_to_update : "");
pmb_mysql_query($query);
$num_word = pmb_mysql_insert_id();
}
if ($num_word != 0) {
$tab_insert[] = "(" . $notice . "," . $tab_code_champ[$k][$nom_champ]['champ'] . "," . $tab_code_champ[$k][$nom_champ]['ss_champ'] . "," . $num_word . "," . $tab_code_champ[$k][$nom_champ]['pond'] . ",{$order_fields},{$pos})";
$pos++;
if ($tab_code_champ[$k][$nom_champ]['ss_champ'] != $memo_ss_champ) {
$order_fields++;
}
$memo_ss_champ = $tab_code_champ[$k][$nom_champ]['ss_champ'];
}
}
}
}
//la table pour les recherche exacte
foreach ($tab_fields as $nom_champ => $tab) {
foreach ($tab as $order => $values) {
//$tab_field_insert[]="(".$notice.",".$tab_code_champ[$v["table"]][$nom_champ][0].",".$tab_code_champ[$v["table"]][$nom_champ][1].",".$order.",'".addslashes($values['value'])."','".addslashes($values['lang'])."',".$tab_code_champ[$v["table"]][$nom_champ][2].")";
$tab_field_insert[] = "(" . $notice . "," . $tab_code_champ[$k][$nom_champ]['champ'] . "," . $tab_code_champ[$k][$nom_champ]['ss_champ'] . "," . ($order + 1) . ",'" . addslashes($values['value']) . "','" . addslashes($values['lang']) . "'," . $tab_code_champ[$k][$nom_champ]['pond'] . ",'" . addslashes($values['autorite']) . "')";
}
}
}
//Les champs perso
if (count($tab_pp)) {
foreach ($tab_pp as $code_champ => $table) {
$p_perso = new parametres_perso($table);
//on doit retrouver l'id des eléments...
switch ($table) {
case "expl":
$rqt = "select expl_id from notices join exemplaires on expl_notice = notice_id and expl_notice!=0 where notice_id = {$notice} union select expl_id from notices join bulletins on num_notice = notice_id join exemplaires on expl_bulletin = bulletin_id and expl_bulletin != 0 where notice_id = {$notice}";
$res = pmb_mysql_query($rqt);
if (pmb_mysql_num_rows($res)) {
$ids = array();
while ($row = pmb_mysql_fetch_object($res)) {
$ids[] = $row->expl_id;
}
}
break;
case "collstate":
break;
default:
$ids = array($notice);
}
if (count($ids)) {
for ($i = 0; $i < count($ids); $i++) {
$data = $p_perso->get_fields_recherche_mot_array($ids[$i]);
$j = 0;
$order_fields = 1;
foreach ($data as $code_ss_champ => $value) {
$tab_mots = array();
foreach ($value as $val) {
$tab_tmp = explode(' ', strip_empty_words($val));
//la table pour les recherche exacte
$tab_field_insert[] = "(" . $notice . "," . $code_champ . "," . $code_ss_champ . "," . $j . ",'" . addslashes(trim($val)) . "',''," . $p_perso->get_pond($code_ss_champ) . ",0)";
$j++;
foreach ($tab_tmp as $mot) {
if (trim($mot)) {
$tab_mots[$mot] = "";
}
}
}
$pos = 1;
foreach ($tab_mots as $mot => $langage) {
$num_word = 0;
//on cherche le mot dans la table de mot...
$query = "select id_word from words where word = '" . $mot . "' and lang = '" . $langage . "'";
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$num_word = pmb_mysql_result($result, 0, 0);
} else {
$dmeta = new DoubleMetaPhone($mot);
$stemming = new stemming($mot);
$element_to_update = "";
if ($dmeta->primary || $dmeta->secondary) {
$element_to_update .= "\n\t\t\t\t\t\t\t\t\t\t\t\tdouble_metaphone = '" . $dmeta->primary . " " . $dmeta->secondary . "'";
}
if ($element_to_update) {
$element_to_update .= ",";
}
$element_to_update .= "stem = '" . $stemming->stem . "'";
$query = "insert into words set word = '" . $mot . "', lang = '" . $langage . "'" . ($element_to_update ? ", " . $element_to_update : "");
pmb_mysql_query($query);
$num_word = pmb_mysql_insert_id();
}
if ($num_word != 0) {
$tab_insert[] = "(" . $notice . "," . $code_champ . "," . $code_ss_champ . "," . $num_word . "," . $p_perso->get_pond($code_ss_champ) . ",{$order_fields},{$pos})";
$pos++;
}
}
$order_fields++;
}
}
}
}
}
//Les autorités perso
if (count($tab_authperso)) {
$order_fields = 1;
$index_fields = $authpersos->get_index_fields($notice);
foreach ($index_fields as $code_champ => $auth) {
$code_champ += $authperso_code_champ_start;
$tab_mots = array();
foreach ($auth['ss_champ'] as $ss_field) {
foreach ($ss_field as $code_ss_champ => $val) {
$tab_field_insert[] = "(" . $notice . "," . $code_champ . "," . $code_ss_champ . "," . $j . ",'" . addslashes(trim($val)) . "',''," . $auth['pond'] . ",0)";
$tab_tmp = explode(' ', strip_empty_words($val));
foreach ($tab_tmp as $mot) {
if (trim($mot)) {
$tab_mots[$mot] = "";
}
}
$pos = 1;
foreach ($tab_mots as $mot => $langage) {
$num_word = 0;
//on cherche le mot dans la table de mot...
$query = "select id_word from words where word = '" . $mot . "' and lang = '" . $langage . "'";
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$num_word = pmb_mysql_result($result, 0, 0);
} else {
$dmeta = new DoubleMetaPhone($mot);
$stemming = new stemming($mot);
$element_to_update = "";
if ($dmeta->primary || $dmeta->secondary) {
$element_to_update .= "\n\t\t\t\t\t\t\t\t\t\t\tdouble_metaphone = '" . $dmeta->primary . " " . $dmeta->secondary . "'";
}
if ($element_to_update) {
$element_to_update .= ",";
}
$element_to_update .= "stem = '" . $stemming->stem . "'";
$query = "insert into words set word = '" . $mot . "', lang = '" . $langage . "'" . ($element_to_update ? ", " . $element_to_update : "");
pmb_mysql_query($query);
$num_word = pmb_mysql_insert_id();
}
if ($num_word != 0) {
$tab_insert[] = "(" . $notice . "," . $code_champ . "," . $code_ss_champ . "," . $num_word . "," . $auth['pond'] . ",{$order_fields},{$pos})";
$pos++;
}
}
$order_fields++;
}
}
}
}
if (count($isbd_ask_list)) {
// Les isbd d'autorités
foreach ($isbd_ask_list as $infos) {
$isbd_s = array();
// cumul des isbd
$res = pmb_mysql_query($infos["req"]) or die($infos["req"]);
if (pmb_mysql_num_rows($res)) {
switch ($infos["class_name"]) {
case 'author':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new auteur($row->id_aut_for_isbd);
$isbd_s[] = $aut->isbd_entry;
}
break;
case 'editeur':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new editeur($row->id_aut_for_isbd);
$isbd_s[] = $aut->isbd_entry;
}
break;
case 'indexint':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new indexint($row->id_aut_for_isbd);
$isbd_s[] = $aut->display;
}
break;
case 'collection':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new collection($row->id_aut_for_isbd);
$isbd_s[] = $aut->isbd_entry;
}
break;
case 'subcollection':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new subcollection($row->id_aut_for_isbd);
$isbd_s[] = $aut->isbd_entry;
}
break;
case 'serie':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new serie($row->id_aut_for_isbd);
$isbd_s[] = $aut->name;
}
break;
case 'categories':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new categories($row->id_aut_for_isbd, $lang);
$isbd_s[] = $aut->libelle_categorie;
}
break;
case 'titre_uniforme':
while ($row = pmb_mysql_fetch_object($res)) {
$aut = new titre_uniforme($row->id_aut_for_isbd);
$isbd_s[] = $aut->libelle;
}
break;
}
}
$order_fields = 1;
for ($i = 0; $i < count($isbd_s); $i++) {
$tab_mots = array();
$tab_field_insert[] = "(" . $notice . "," . $infos["champ"] . "," . $infos["ss_champ"] . "," . $order_fields . ",'" . addslashes(trim($isbd_s[$i])) . "',''," . $infos["pond"] . ",0)";
$tab_tmp = explode(' ', strip_empty_words($isbd_s[$i]));
foreach ($tab_tmp as $mot) {
if (trim($mot)) {
$tab_mots[$mot] = "";
}
}
$pos = 1;
foreach ($tab_mots as $mot => $langage) {
$num_word = 0;
//on cherche le mot dans la table de mot...
$query = "select id_word from words where word = '" . $mot . "' and lang = '" . $langage . "'";
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$num_word = pmb_mysql_result($result, 0, 0);
} else {
$dmeta = new DoubleMetaPhone($mot);
$stemming = new stemming($mot);
$element_to_update = "";
if ($dmeta->primary || $dmeta->secondary) {
$element_to_update .= "\n\t\t\t\t\t\t\t\t\t\tdouble_metaphone = '" . $dmeta->primary . " " . $dmeta->secondary . "'";
}
if ($element_to_update) {
$element_to_update .= ",";
}
$element_to_update .= "stem = '" . $stemming->stem . "'";
$query = "insert into words set word = '" . $mot . "', lang = '" . $langage . "'" . ($element_to_update ? ", " . $element_to_update : "");
pmb_mysql_query($query);
$num_word = pmb_mysql_insert_id();
}
if ($num_word != 0) {
$tab_insert[] = "(" . $notice . "," . $infos["champ"] . "," . $infos["ss_champ"] . "," . $num_word . "," . $infos["pond"] . ",{$order_fields},{$pos})";
$pos++;
}
}
$order_fields++;
}
}
}
if (count($tab_insert)) {
$req_insert = "insert ignore into notices_mots_global_index(id_notice,code_champ,code_ss_champ,num_word,pond,position, field_position) values " . implode(',', $tab_insert);
pmb_mysql_query($req_insert, $dbh);
}
if (count($tab_field_insert)) {
//la table pour les recherche exacte
$req_insert = "insert ignore into notices_fields_global_index(id_notice,code_champ,code_ss_champ,ordre,value,lang,pond,authority_num) values " . implode(',', $tab_field_insert);
pmb_mysql_query($req_insert, $dbh);
}
}
}
