function import_new_notice_suite() { global $dbh, $q; global $notice_id, $bulletin_ex; global $thesaurus_defaut; global $info_503, $info_503_j, $info_503_d, $info_305; global $info_999, $info_001, $info_994_x, $info_994_y, $info_901, $editor, $info_905, $info_906, $editor; $bulletin_ex = 0; global $info_600_a, $info_600_j, $info_600_x, $info_600_y, $info_600_z, $info_600_f, $info_600_b, $info_600_3; global $info_601_a, $info_601_j, $info_601_x, $info_601_y, $info_601_z, $info_601_3; global $info_606_a, $info_606_j, $info_606_x, $info_606_y, $info_606_z, $info_606_3; global $info_607_a, $info_607_j, $info_607_x, $info_607_y, $info_607_z, $info_607_3; global $info_608_a, $info_608_j, $info_608_x, $info_608_y, $info_608_z, $info_608_3; //Indexation global $pmb_keyword_sep; if (!$pmb_keyword_sep) { $pmb_keyword_sep = " ; "; } $champ_rameau = ""; for ($a = 0; $a < sizeof($info_600_a); $a++) { $libelle_final = ""; $libelle_j = ""; for ($j = 0; $j < sizeof($info_600_j[$a]); $j++) { if (!$libelle_j) { $libelle_j .= trim($info_600_j[$a][$j]); } else { $libelle_j .= " ** " . trim($info_600_j[$a][$j]); } } if ($info_600_b[$a][0]) { $libelle_final .= " " . trim($info_600_b[$a][0]); } if ($info_600_f[$a][0]) { $libelle_final .= " (" . trim($info_600_f[$a][0]) . ")"; } if (!$libelle_j) { $libelle_final = trim($info_600_a[$a][0]) . $libelle_final; } else { $libelle_final = trim($info_600_a[$a][0]) . $libelle_final . " ** " . $libelle_j; } if (!$libelle_final) { break; } for ($j = 0; $j < sizeof($info_600_x[$a]); $j++) { $libelle_final .= " -- " . trim($info_600_x[$a][$j]); } for ($j = 0; $j < sizeof($info_600_y[$a]); $j++) { $libelle_final .= " -- " . trim($info_600_y[$a][$j]); } for ($j = 0; $j < sizeof($info_600_z[$a]); $j++) { $libelle_final .= " -- " . trim($info_600_z[$a][$j]); } //if($info_600_3[$a][0])$libelle_final.=" @@3 ".trim($info_600_3[$a][0]); if ($champ_rameau) { $champ_rameau .= $pmb_keyword_sep; } $champ_rameau .= $libelle_final; } for ($a = 0; $a < sizeof($info_601_a); $a++) { $libelle_final = ""; $libelle_j = ""; for ($j = 0; $j < sizeof($info_601_j[$a]); $j++) { if (!$libelle_j) { $libelle_j .= trim($info_601_j[$a][$j]); } else { $libelle_j .= " ** " . trim($info_601_j[$a][$j]); } } if (!$libelle_j) { $libelle_final = trim($info_601_a[$a][0]); } else { $libelle_final = trim($info_601_a[$a][0]) . " ** " . $libelle_j; } if (!$libelle_final) { break; } for ($j = 0; $j < sizeof($info_601_x[$a]); $j++) { $libelle_final .= " -- " . trim($info_601_x[$a][$j]); } for ($j = 0; $j < sizeof($info_601_y[$a]); $j++) { $libelle_final .= " -- " . trim($info_601_y[$a][$j]); } for ($j = 0; $j < sizeof($info_601_z[$a]); $j++) { $libelle_final .= " -- " . trim($info_601_z[$a][$j]); } //if($info_601_3[$a][0])$libelle_final.=" @@3 ".trim($info_601_3[$a][0]); if ($champ_rameau) { $champ_rameau .= $pmb_keyword_sep; } $champ_rameau .= $libelle_final; } for ($a = 0; $a < sizeof($info_606_a); $a++) { $libelle_final = ""; $libelle_j = ""; for ($j = 0; $j < sizeof($info_606_j[$a]); $j++) { if (!$libelle_j) { $libelle_j .= trim($info_606_j[$a][$j]); } else { $libelle_j .= " ** " . trim($info_606_j[$a][$j]); } } if (!$libelle_j) { $libelle_final = trim($info_606_a[$a][0]); } else { $libelle_final = trim($info_606_a[$a][0]) . " ** " . $libelle_j; } if (!$libelle_final) { break; } for ($j = 0; $j < sizeof($info_606_x[$a]); $j++) { $libelle_final .= " -- " . trim($info_606_x[$a][$j]); } for ($j = 0; $j < sizeof($info_606_y[$a]); $j++) { $libelle_final .= " -- " . trim($info_606_y[$a][$j]); } for ($j = 0; $j < sizeof($info_606_z[$a]); $j++) { $libelle_final .= " -- " . trim($info_606_z[$a][$j]); } //if($info_606_3[$a][0])$libelle_final.=" @@3 ".trim($info_606_3[$a][0]); if ($champ_rameau) { $champ_rameau .= $pmb_keyword_sep; } $champ_rameau .= $libelle_final; } for ($a = 0; $a < sizeof($info_607_a); $a++) { $libelle_final = ""; $libelle_j = ""; for ($j = 0; $j < sizeof($info_607_j[$a]); $j++) { if (!$libelle_j) { $libelle_j .= trim($info_607_j[$a][$j]); } else { $libelle_j .= " ** " . trim($info_607_j[$a][$j]); } } if (!$libelle_j) { $libelle_final = trim($info_607_a[$a][0]); } else { $libelle_final = trim($info_607_a[$a][0]) . " ** " . $libelle_j; } if (!$libelle_final) { break; } for ($j = 0; $j < sizeof($info_607_x[$a]); $j++) { $libelle_final .= " -- " . trim($info_607_x[$a][$j]); } for ($j = 0; $j < sizeof($info_607_y[$a]); $j++) { $libelle_final .= " -- " . trim($info_607_y[$a][$j]); } for ($j = 0; $j < sizeof($info_607_z[$a]); $j++) { $libelle_final .= " -- " . trim($info_607_z[$a][$j]); } //if($info_607_3[$a][0])$libelle_final.=" @@3 ".trim($info_607_3[$a][0]); if ($champ_rameau) { $champ_rameau .= $pmb_keyword_sep; } $champ_rameau .= $libelle_final; } for ($a = 0; $a < sizeof($info_608_a); $a++) { $libelle_final = ""; $libelle_j = ""; for ($j = 0; $j < sizeof($info_608_j[$a]); $j++) { if (!$libelle_j) { $libelle_j .= trim($info_608_j[$a][$j]); } else { $libelle_j .= " ** " . trim($info_608_j[$a][$j]); } } if (!$libelle_j) { $libelle_final = trim($info_608_a[$a][0]); } else { $libelle_final = trim($info_608_a[$a][0]) . " ** " . $libelle_j; } if (!$libelle_final) { break; } for ($j = 0; $j < sizeof($info_608_x[$a]); $j++) { $libelle_final .= " -- " . trim($info_608_x[$a][$j]); } for ($j = 0; $j < sizeof($info_608_y[$a]); $j++) { $libelle_final .= " -- " . trim($info_608_y[$a][$j]); } for ($j = 0; $j < sizeof($info_608_z[$a]); $j++) { $libelle_final .= " -- " . trim($info_608_z[$a][$j]); } //if($info_608_3[$a][0])$libelle_final.=" @@3 ".trim($info_608_3[$a][0]); if ($champ_rameau) { $champ_rameau .= $pmb_keyword_sep; } $champ_rameau .= $libelle_final; } //A mettre en note if (count($info_305)) { $n_gen = implode("\n", $info_305); $requete = "update notices set n_gen=IF(TRIM(n_gen) != '', CONCAT(n_gen,'\n','" . addslashes($n_gen) . "'),'" . addslashes($n_gen) . "') WHERE notice_id='" . $notice_id . "' "; if (!pmb_mysql_query($requete)) { echo "Requete echoué : " . $requete . "<br>"; } } if ($champ_rameau) { //echo "valeur : ".$champ_rameau."<br>"; $requete = "SELECT index_l FROM notices WHERE notice_id='" . $notice_id . "' "; $res = pmb_mysql_query($requete); if (pmb_mysql_num_rows($res)) { $ind = pmb_mysql_result($res, 0, 0); if ($ind) { $requete = "UPDATE notices SET index_l='" . addslashes(trim($ind . $pmb_keyword_sep . $champ_rameau)) . "' WHERE notice_id='" . $notice_id . "'"; if (!pmb_mysql_query($requete)) { echo "Requete echoué : " . $requete . "<br>"; } } else { $requete = "UPDATE notices SET index_l='" . addslashes(trim($champ_rameau)) . "' WHERE notice_id='" . $notice_id . "'"; if (!pmb_mysql_query($requete)) { echo "Requete echoué : " . $requete . "<br>"; } } } else { $requete = "UPDATE notices SET index_l='" . addslashes(trim($champ_rameau)) . "' WHERE notice_id='" . $notice_id . "'"; if (!pmb_mysql_query($requete)) { echo "Requete echoué : " . $requete . "<br>"; } } } //echo "Valeur <br>"; //echo $champ_rameau."<br>"; /*$ligne=explode("@@@",$champ_rameau); for($i=0;$i<count($ligne);$i++){ $data=explode("@@3",$ligne[$i]); if(trim($data[0])){ $descripteur=trim($data[0]); $thes = new thesaurus($thesaurus_defaut); $id_categorie = categories::searchLibelle(addslashes($descripteur),$thesaurus_defaut,'fr_FR',$thes->num_noeud_racine); if(!$id_categorie){ $n=new noeuds(); $n->num_parent=$thes->num_noeud_racine; $n->num_thesaurus=$thesaurus_defaut; $n->autorite = trim($data[1]); $n->save(); $id_n=$n->id_noeud; $c=new categories($id_n, 'fr_FR'); $c->libelle_categorie=$descripteur; $c->index_categorie=" ".strip_empty_words($descripteur)." "; $c->save(); $id_categorie = categories::searchLibelle(addslashes($descripteur),$thesaurus_defaut,'fr_FR',$thes->num_noeud_racine); } $requete = "INSERT INTO notices_categories (notcateg_notice,num_noeud,ordre_categorie) VALUES($notice_id,$id_categorie,$i)"; // Je fait le lien entre ma notice et la catégorie pmb_mysql_query($requete); } }*/ //Champs perso if (count($editor) > 2) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='autre_editeur'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); for ($i = 2; $i < count($editor); $i++) { $ed['name'] = clean_string($editor[$i]['c']); $ed['ville'] = clean_string($editor[$i]['a']); $ed1_id = editeur::import($ed); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_integer) values('" . $id_champ . "','" . $notice_id . "','" . $ed1_id . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } } //Ancien num if ($info_001[0]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='ancien_num'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($info_001[0]) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } //Titre de forme $tab_non_rep = array(); if (count($info_503)) { for ($i = 0; $i < count($info_503); $i++) { if ($info_503[$i]["a"] && !$tab_non_rep["titre"]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='t_d_f_titre'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "select notices_custom_list_value from notices_custom_lists where notices_custom_list_lib='" . addslashes(trim($info_503[$i]["a"])) . "' and notices_custom_champ='" . $id_champ . "'"; $resultat = pmb_mysql_query($requete); if (pmb_mysql_num_rows($resultat)) { $value = pmb_mysql_result($resultat, 0, 0); } else { $requete = "select max(notices_custom_list_value*1) from notices_custom_lists where notices_custom_champ='" . $id_champ . "'"; $resultat = pmb_mysql_query($requete); $max = @pmb_mysql_result($resultat, 0, 0); $n = $max + 1; $requete = "insert into notices_custom_lists (notices_custom_champ,notices_custom_list_value,notices_custom_list_lib) values('" . $id_champ . "',{$n},'" . addslashes(trim($info_503[$i]["a"])) . "')"; pmb_mysql_query($requete); $value = $n; } $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_integer) values('" . $id_champ . "',{$notice_id},{$value})"; $tab_non_rep["titre"] = 1; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } if ($info_503[$i]["e"] && !$tab_non_rep["nom"]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='t_d_f_nom'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes(trim($info_503[$i]["e"])) . "')"; $tab_non_rep["nom"] = 1; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } if ($info_503[$i]["f"] && !$tab_non_rep["prenom"]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='t_d_f_prenom'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes(trim($info_503[$i]["f"])) . "')"; $tab_non_rep["prenom"] = 1; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } if ($info_503[$i]["h"] && !$tab_non_rep["qual"]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='t_d_f_qualificatif'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes(trim($info_503[$i]["h"])) . "')"; $tab_non_rep["qual"] = 1; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } if (count($info_503_j[$i]) && !$tab_non_rep["date"]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='t_d_f_date'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $date = ""; for ($p = 0; $p < count($info_503_j[$i]); $p++) { if (trim($info_503_j[$i][$p])) { $jm = trim($info_503_d[$i][$p]); if ($jm) { //Si j'ai aussi le mois et le jour if (strlen($jm) == 4) { if ($date) { $date .= " - " . substr($jm, 2, 2) . "/" . substr($jm, 0, 2) . "/" . trim($info_503_j[$i][$p]); } else { $date = substr($jm, 2, 2) . "/" . substr($jm, 0, 2) . "/" . trim($info_503_j[$i][$p]); } } else { if ($date) { $date .= " - " . $jm . " " . trim($info_503_j[$i][$p]); } else { $date = $jm . " " . trim($info_503_j[$i][$p]); } } } else { if ($date) { $date .= " - " . trim($info_503_j[$i][$p]); } else { $date = trim($info_503_j[$i][$p]); } } } } if ($date) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($date) . "')"; $tab_non_rep["date"] = 1; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } } $lieu_etabl = ""; if (trim($info_503[$i]["m"]) and trim($info_503[$i]["n"])) { $lieu_etabl = trim($info_503[$i]["m"]) . ", " . trim($info_503[$i]["n"]); } elseif (trim($info_503[$i]["m"])) { $lieu_etabl = trim($info_503[$i]["m"]); } elseif (trim($info_503[$i]["m"]) and trim($info_503[$i]["n"])) { $lieu_etabl = trim($info_503[$i]["n"]); } if ($lieu_etabl) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='t_d_f_lieu_etabl'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($lieu_etabl) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } } } //Autre isbn if (count($info_901)) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='autre_isbn'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); for ($i = 0; $i < count($info_901); $i++) { $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($info_901[$i]) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } } //Anomalie if ($info_999[0]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='pb_fiche'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($info_999[0]) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } //Donnée codées monographie if ($info_905[0]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='dc_mono'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($info_905[0]) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } //Donnée codées description physique if ($info_906[0]) { $rqt = "SELECT idchamp FROM notices_custom WHERE name='dc_phys'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_small_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes($info_906[0]) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } //oeuvre du musée reproduite if (count($info_994_x)) { $val = implode(" ; ", $info_994_x); $rqt = "SELECT idchamp FROM notices_custom WHERE name='oeuvre_reproduite'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes(trim($val)) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } //oeuvre du musée citéé if (count($info_994_y)) { $val = implode(" ; ", $info_994_y); $rqt = "SELECT idchamp FROM notices_custom WHERE name='oeuvre_citee'"; $res = pmb_mysql_query($rqt); if (pmb_mysql_num_rows($res) > 0) { $id_champ = pmb_mysql_result($res, 0); $requete = "insert into notices_custom_values (notices_custom_champ,notices_custom_origine,notices_custom_text) values('" . $id_champ . "','" . $notice_id . "','" . addslashes(trim($val)) . "')"; if (!pmb_mysql_query($requete)) { echo "requete echoué : " . $requete . "<br>"; } } } }
static function import($data) { // cette méthode prend en entrée un tableau constitué des informations éditeurs suivantes : // $data['name'] Nom de la collection // $data['parent'] id de l'éditeur parent de la collection // $data['issn'] numéro ISSN de la collection global $dbh; // check sur le type de la variable passée en paramètre if (!sizeof($data) || !is_array($data)) { // si ce n'est pas un tableau ou un tableau vide, on retourne 0 return 0; } // check sur les éléments du tableau (data['name'] est requis). $long_maxi_name = pmb_mysql_field_len(pmb_mysql_query("SELECT collection_name FROM collections limit 1"), 0); $data['name'] = rtrim(substr(preg_replace('/\\[|\\]/', '', rtrim(ltrim($data['name']))), 0, $long_maxi_name)); //si on a pas d'id, on peut avoir les infos de l'éditeur if (!$data['parent']) { if ($data['publisher']) { //on les a, on crée l'éditeur $data['parent'] = editeur::import($data['publisher']); } } if ($data['name'] == "" || $data['parent'] == 0) { /* il nous faut impérativement un éditeur */ return 0; } // préparation de la requête $key0 = addslashes($data['name']); $key1 = $data['parent']; $key2 = addslashes($data['issn']); /* vérification que l'éditeur existe bien ! */ $query = "SELECT ed_id FROM publishers WHERE ed_id='{$key1}' LIMIT 1 "; $result = @pmb_mysql_query($query, $dbh); if (!$result) { die("can't SELECT publishers " . $query); } if (pmb_mysql_num_rows($result) == 0) { return 0; } /* vérification que la collection existe */ $query = "SELECT collection_id FROM collections WHERE collection_name='{$key0}' AND collection_parent='{$key1}' LIMIT 1 "; $result = @pmb_mysql_query($query, $dbh); if (!$result) { die("can't SELECT collections " . $query); } $collection = pmb_mysql_fetch_object($result); /* la collection existe, on retourne l'ID */ if ($collection->collection_id) { return $collection->collection_id; } // id non-récupérée, il faut créer la forme. $query = 'INSERT INTO collections SET collection_name="' . $key0 . '", '; $query .= 'collection_parent="' . $key1 . '", '; $query .= 'collection_issn="' . $key2 . '", '; $query .= 'index_coll=" ' . strip_empty_words($key0) . ' ' . strip_empty_words($key2) . ' ", '; $query .= 'collection_comment = "' . addslashes($data['comment']) . '" '; $result = @pmb_mysql_query($query, $dbh); if (!$result) { die("can't INSERT into database"); } $id = pmb_mysql_insert_id($dbh); if ($data['subcollections']) { for ($i = 0; $i < count($data['subcollections']); $i++) { $subcoll = $data['subcollections'][$i]; $subcoll['coll_parent'] = $id; subcollection::import($subcoll); } } audit::insert_creation(AUDIT_COLLECTION, $id); //update authority informations $authority = new authority(0, $id, AUT_TABLE_COLLECTIONS); $authority->set_num_statut($data['statut']); $authority->update(); collection::update_index($id); return $id; }
function update_in_database($id_notice = 0) { global $dbh; global $pmb_synchro_rdf; $new_notice = 2; $notice_retour = $id_notice; if (!$id_notice) { $retour = array(2, 0); return $retour; } //synchro_rdf if ($pmb_synchro_rdf) { $synchro_rdf = new synchro_rdf(); $synchro_rdf->delRdf($notice_retour, 0); } // traitement des titres uniformes global $pmb_use_uniform_title; if ($pmb_use_uniform_title) { if (count($this->titres_uniformes)) { $ntu = new tu_notice($id_notice); $ntu->update($this->titres_uniformes); } } for ($i = 0; $i < 2; $i++) { if ($this->editors[$i]['id']) { $editor_ids[$i] = $this->editors[$i]['id']; } else { $editor_ids[$i] = editeur::import($this->editors[$i]); } } if ($this->collection["id"]) { $collection_id = $this->collection["id"]; } else { $this->collection['parent'] = $editor_ids[0]; $collection_id = collection::import($this->collection); } if ($this->subcollection["id"]) { $subcollection_id = $this->subcollection["id"]; } else { $this->subcollection['coll_parent'] = $collection_id; $subcollection_id = subcollection::import($this->subcollection); $serie_id = serie::import(stripslashes($this->serie)); } /* traitement de Dewey */ if (!$this->internal_index) { if (!$this->dewey["new_comment"]) { $this->dewey["new_comment"] = ""; } if (!$this->dewey["new_pclass"]) { $this->dewey["new_pclass"] = ""; } $this->internal_index = indexint::import(clean_string($this->dewey[0]), clean_string($this->dewey["new_comment"]), clean_string($this->dewey["new_pclass"])); } $date_parution_z3950 = notice::get_date_parution($this->year); /* Origine de la notice */ $this->orinot_id = origine_notice::import($this->origine_notice); if ($this->orinot_id == 0) { $this->orinot_id = 1; } $sql_ins = "update notices set\n\t\t\ttypdoc \t='" . $this->document_type . "',\n\t\t\tcode \t ='" . $this->isbn . "',\t \n\t\t\ttit1 ='" . $this->titles[0] . "', \n\t\t\ttit2 ='" . $this->titles[1] . "', \n\t\t\ttit3 ='" . $this->titles[2] . "', \n\t\t\ttit4 ='" . $this->titles[3] . "', \n\t\t\ttparent_id ='" . $serie_id . "', \n\t\t\ttnvol ='" . $this->nbr_in_serie . "', \n\t\t\ted1_id =" . $editor_ids[0] . " , \n\t\t\ted2_id =" . $editor_ids[1] . " , \n\t\t\tyear ='" . $this->year . "', \n\t\t\tnpages ='" . $this->page_nbr . "', \n\t\t\till ='" . $this->illustration . "', \n\t\t\tsize ='" . $this->size . "', \n\t\t\taccomp ='" . $this->accompagnement . "', \n\t\t\tcoll_id =" . $collection_id . " , \n\t\t\tsubcoll_id =" . $subcollection_id . " , \n\t\t\tnocoll ='" . $this->nbr_in_collection . "', \n\t\t\tmention_edition ='" . $this->mention_edition . "', \n\t\t\tn_gen ='" . $this->general_note . "', \n\t\t\tn_contenu ='" . $this->content_note . "', \n\t\t\tn_resume ='" . $this->abstract_note . "', \n\t\t\tindexint ='" . $this->internal_index . "', \n\t\t\tstatut\t\t\t\t\t='" . $this->statut . "',\n\t\t\tcommentaire_gestion\t\t='" . $this->commentaire_gestion . "',\n\t\t\tindexation_lang\t\t\t='" . $this->indexation_lang . "',\n\t\t\tthumbnail_url\t\t\t='" . $this->thumbnail_url . "',\n\t\t\tindex_l ='" . clean_tags($this->free_index) . "', \n\t\t\tniveau_biblio ='" . $this->bibliographic_level . "', \n\t\t\tniveau_hierar ='" . $this->hierarchic_level . "', \n\t\t\tlien ='" . $this->link_url . "', \n\t\t\teformat ='" . $this->link_format . "', \n\t\t\torigine_catalogage ='" . $this->orinot_id . "', \n\t\t\tprix ='" . $this->prix . "',\n\t\t\tdate_parution \t\t\t='" . $date_parution_z3950 . "' \n\t\t\twhere notice_id='{$id_notice}' "; //echo "<pre>"; //print_r($this->aut_array); //echo "</pre>"; //echo $sql_ins."<br />"; //echo "<pre>"; //print_r($this->categories); //echo "</pre>"; //exit; $sql_result_ins = pmb_mysql_query($sql_ins) or die("Couldn't update notices : " . $sql_ins); $notice_retour = $id_notice; audit::insert_modif(AUDIT_NOTICE, $id_notice); // purge de la base des responsabilités de la notice intégrée... if ($notice_retour) { $rqt_del = "delete from responsability where responsability_notice='{$notice_retour}'"; $sql_result_del = pmb_mysql_query($rqt_del) or die("Couldn't purge table responsability : " . $rqt_del); } $rqt_ins = "insert into responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES "; for ($i = 0; $i < sizeof($this->aut_array); $i++) { $aut['id'] = clean_string($this->aut_array[$i]['id']); $aut['name'] = clean_string($this->aut_array[$i]['entree']); $aut['rejete'] = clean_string($this->aut_array[$i]['rejete']); $aut['date'] = clean_string($this->aut_array[$i]['date']); $aut['type'] = $this->aut_array[$i]['type_auteur']; $aut['subdivision'] = clean_string($this->aut_array[$i]['subdivision']); $aut['numero'] = clean_string($this->aut_array[$i]['numero']); $aut['lieu'] = clean_string($this->aut_array[$i]['lieu']); $aut['ville'] = clean_string($this->aut_array[$i]['ville']); $aut['pays'] = clean_string($this->aut_array[$i]['pays']); $aut['web'] = clean_string($this->aut_array[$i]['web']); $aut['author_comment'] = clean_string($this->aut_array[$i]['author_comment']); $aut['authority_number'] = clean_string($this->aut_array[$i]['authority_number']); /* Origine de l'autorité : on reprend les infos d'origine de la notice pour les attribuées aux origines des autorités */ $id_origine_auth = 0; $id_origine_auth = origin_authorities::import($this->origine_notice); if ($id_origine_auth == 0) { $id_origine_auth = 1; } // import de l'autorité auteur si elle n'existe pas et conservation des infos sur l'origine de l'autorité if ($aut['authority_number'] != '' && $id_origine_auth) { $this->aut_array[$i]["id"] = $this->insert_authority_infos($aut['authority_number'], "author", $id_origine_auth, $aut); } if (!$this->aut_array[$i]["id"]) { $this->aut_array[$i]["id"] = auteur::import($aut); } if ($this->aut_array[$i]["id"]) { $rqt = $rqt_ins . " (" . $this->aut_array[$i]["id"] . "," . $notice_retour . ",'" . $this->aut_array[$i]['fonction'] . "'," . $this->aut_array[$i]['responsabilite'] . "," . $i . ") "; $res_ins = pmb_mysql_query($rqt, $dbh); } } // traitement des categories if ($this->categorisation_type == "categorisation_auto") { traite_categories_enreg($notice_retour, $this->categories); } else { $rqt_del = "delete from notices_categories where notcateg_notice='{$notice_retour}' "; $res_del = @pmb_mysql_query($rqt_del, $dbh); $rqt_ins = "insert into notices_categories (notcateg_notice, num_noeud, ordre_categorie) VALUES "; $rqt_ins_values = array(); foreach ($this->categories as $i => $category) { $id_categ = $category['categ_id']; if ($id_categ) { $rqt_ins_values[] = " ('{$notice_retour}','{$id_categ}', {$i}) "; } } $rqt_ins .= implode(",", $rqt_ins_values); $res_ins = @pmb_mysql_query($rqt_ins, $dbh); } // traitement des langues // langues de la publication $rqt_del = "delete from notices_langues where num_notice='{$notice_retour}' "; $res_del = pmb_mysql_query($rqt_del, $dbh); if (is_array($this->language_code) && count($this->language_code)) { $rqt_ins = "insert into notices_langues (num_notice, type_langue, code_langue, ordre_langue) VALUES "; foreach ($this->language_code as $ordre_lang => $code_lang) { if ($code_lang) { $rqt = $rqt_ins . " ('{$notice_retour}',0, '{$code_lang}', {$ordre_lang}) "; $res_ins = @pmb_mysql_query($rqt, $dbh); } } } // langues originales if (is_array($this->original_language_code) && count($this->original_language_code)) { $rqt_ins = "insert into notices_langues (num_notice, type_langue, code_langue, ordre_langue) VALUES "; foreach ($this->original_language_code as $ordre_lang => $code_lang) { if ($code_lang) { $rqt = $rqt_ins . " ('{$notice_retour}',1, '{$code_lang}', {$ordre_lang}) "; $res_ins = @pmb_mysql_query($rqt, $dbh); } } } //Traitement des champs personnalisés (du formulaire !!!) $p_perso = new parametres_perso("notices"); $nberrors = $p_perso->check_submited_fields(); $p_perso->rec_fields_perso($notice_retour); //Traitement import perso global $notice_id, $notice_org, $notice_type_org; if (function_exists('z_recup_noticeunimarc_suite') && function_exists('recup_noticeunimarc_suite')) { //Suppression des champs persos $requete = "delete from notices_custom_values where notices_custom_origine=" . $notice_retour; @pmb_mysql_query($requete); $notice_id = $notice_retour; z_recup_noticeunimarc_suite($notice_org); z_import_new_notice_suite(); } // Mise à jour des index de la notice notice::majNotices($notice_retour); // Mise à jour de la table notices_global_index notice::majNoticesGlobalIndex($notice_retour); // Mise à jour de la table notices_mots_global_index notice::majNoticesMotsGlobalIndex($notice_retour); //Documents numériques foreach ($this->doc_nums as $doc_num) { if (!$doc_num["a"]) { continue; } explnum_add_from_url($notice_retour, $this->bull_id, $doc_num["b"], $doc_num["a"], false, $this->source_id, $doc_num["f"], '', $doc_num["s"]); } //synchro_rdf if ($pmb_synchro_rdf) { $synchro_rdf->addRdf($notice_retour, 0); } $retour = array($new_notice, $notice_retour); return $retour; }
function import_new_notice() { global $dbh; global $notice_id; global $bulletin_ex; //Identifiant du bulletin $bulletin_ex = 0; global $id_unimarc; global $notices_crees; global $bulletins_crees; global $notices_a_creer; global $bulletins_a_creer; global $base_path; global $pmb_keyword_sep; global $link_generate; global $doc_type; global $hierarchic_level; global $bibliographic_level; global $isbn_OK; global $prix; global $prix_cd; global $cb; global $tit_200a; global $tit_200c; global $tit_200d; global $tit_200e; global $tit_200v; global $serie_200; global $editor; global $editeur_lieu; global $editeur_adr; global $editeur_nom; global $editeur_date; global $editeur_pays; global $editeur_pmbfields; global $no_edition; global $npages; global $ill; global $size; global $accomp; global $collection_225; global $n_contenu; global $n_resume; global $n_gen; global $EAN; global $collection_410; global $collection_411; global $tu_500; global $tu_500_r; global $tu_500_s; global $tu_500_j; global $serie; global $index_sujets; global $dewey; global $dewey_l; global $aut_700; global $aut_701; global $aut_702; global $aut_710; global $aut_711; global $aut_712; global $origine_notice; global $lien; global $eformat; global $analytique; global $statutnot; global $indicateur; global $add_explnum; global $info_686; global $authorities_notices; global $authorities_default_origin; $origin_authority = $authorities_default_origin; $add_explnum = FALSE; /* traitement des éditeurs */ $coll_id = 0; $subcoll_id = 0; $serie_id = 0; $tnvol_ins = ""; $ed1_id = 0; $ed2_id = 0; $year = ""; $date_parution = "0000-00-00"; //On récupère le tableau des notices créées à partir du fichier temporaire (rechargement d'iframe) if ($link_generate && !isset($notices_crees)) { $tabimport_id = file_get_contents("{$base_path}/temp/liste_id" . SESSid . ".txt"); if ($tabimport_id) { $tabimport_id = unserialize($tabimport_id); $notices_crees = $tabimport_id['notices_existantes']; $notices_a_creer = $tabimport_id['notices_a_creer']; $bulletins_crees = $tabimport_id['bulletins_crees']; $bulletins_a_creer = $tabimport_id['bulletins_a_creer']; } } if (!is_array($notices_crees)) { $notices_crees = array(); } //Pour le cas ou on est sur une notice (bidon) d'article juste pour les exemplaires de bulletin if ($bibliographic_level == "a" && $tit_200d[0] == "Article_expl_bulletin") { //On importe rien return; } elseif ($tit_200d[0] == "Article_expl_bulletin") { //Pour le cas ou on import sans les liens un fichier exporter avec les exemplaires et les liens $tit_200d[0] = ""; } if ($bibliographic_level != "a" && $bibliographic_level != "b") { //Pour les articles et les bulletins on ne garde pas les informations suivantes $year = clean_string($editeur_date[0]); $date_parution = notice::get_date_parution($year); //traitement des éditeurs $editor = array(); foreach ($editeur_nom as $key_nom1 => $nom1) { foreach ($nom1 as $key_nom2 => $nom2) { $mon_ed = array(); $mon_ed["c"] = $nom2; if ($editeur_adr[$key_nom1][$key_nom2]) { $mon_ed["b"] = $editeur_adr[$key_nom1][$key_nom2]; } if ($editeur_lieu[$key_nom1][$key_nom2]) { $mon_ed["a"] = $editeur_lieu[$key_nom1][$key_nom2]; } if ($editeur_pays[$key_nom1][$key_nom2]) { $mon_ed["z"] = $editeur_pays[$key_nom1][$key_nom2]; } if ($editeur_pmbfields[$key_nom1][$key_nom2]) { //Si j'ai ces informations c'est un export PMB donc je n'ai pas deux editeurs dans le même 210 foreach ($editeur_pmbfields[$key_nom1] as $val9) { if (preg_match("/^(.+?):(.+)\$/", $val9, $matches)) { $mon_ed[trim($matches[1])] = $matches[2]; } } } $editor[] = $mon_ed; } } $ed = array(); $ed['name'] = clean_string($editor[0]['c']); $ed['adr'] = clean_string($editor[0]['b']); if ($editor[0]['adr1']) { $ed['adr'] = clean_string($editor[0]['adr1']); } //Si cela vient de PMB dans $b j'ai un concat $ed['ville'] = clean_string($editor[0]['a']); $ed['adr2'] = clean_string($editor[0]['adr2']); $ed['cp'] = clean_string($editor[0]['cp']); $ed['pays'] = clean_string($editor[0]['z']); $ed['web'] = clean_string($editor[0]['web']); $ed['ed_comment'] = clean_string($editor[0]['comment']); $ed1_id = editeur::import($ed); $ed = array(); $ed['name'] = clean_string($editor[1]['c']); $ed['adr'] = clean_string($editor[1]['b']); if ($editor[1]['adr1']) { $ed['adr'] = clean_string($editor[1]['adr1']); } //Si cela vient de PMB dans $b j'ai un concat $ed['ville'] = clean_string($editor[1]['a']); $ed['adr2'] = clean_string($editor[1]['adr2']); $ed['cp'] = clean_string($editor[1]['cp']); $ed['pays'] = clean_string($editor[1]['z']); $ed['web'] = clean_string($editor[1]['web']); $ed['ed_comment'] = clean_string($editor[1]['comment']); $ed2_id = editeur::import($ed); if ($bibliographic_level != "s") { //Pour les periodiques on ne garde pas les informations suivantes /* traitement des collections */ $coll_name = ""; $subcoll_name = ""; $coll_issn = ""; $subcoll_issn = ""; $nocoll_ins = ""; /* traitement de 225$a, si rien alors 410$t pour la collection */ if ($collection_225[0]['a'] != "") { $coll_name = $collection_225[0]['a']; $coll_issn = $collection_225[0]['x']; } elseif ($collection_410[0]['t'] != "") { $coll_name = $collection_410[0]['t']; $coll_issn = $collection_410[0]['x']; $coll_aut_number = $collection_410[0]['3']; } /* traitement de 225$i, si rien alors 411$t pour la sous-collection */ if ($collection_225[0]['i'] != "") { $subcoll_name = $collection_225[0]['i']; $subcoll_issn = $collection_225[1]['x']; } elseif ($collection_411[0]['t'] != "") { $subcoll_name = $collection_411[0]['t']; $subcoll_issn = $collection_411[0]['x']; $coll_aut_number = $collection_411[0]['3']; } /* gaffe au nocoll, en principe en 225$v selon FL sinon en 410$v ou 411$v*/ if ($collection_225[0]['v'] != "") { $nocoll_ins = $collection_225[0]['v']; } elseif ($collection_410[0]['v'] != "") { $nocoll_ins = $collection_410[0]['v']; } elseif ($collection_411[0]['v'] != "") { $nocoll_ins = $collection_411[0]['v']; } else { $nocoll_ins = ""; } $collec['name'] = clean_string($coll_name); $collec['parent'] = $ed1_id; $collec['issn'] = clean_string($coll_issn); $collec['authority_number'] = $coll_aut_number; if ($collec['authority_number']) { $coll_id = keep_authority_infos($collec['authority_number'], "collection", $origin_authority, 0, $collec); } else { $coll_id = collection::import($collec); } /* sous collection */ $subcollec['name'] = clean_string($subcoll_name); $subcollec['coll_parent'] = $coll_id; $subcollec['issn'] = clean_string($subcoll_issn); $subcollec['authority_number'] = $subcoll_aut_number; if ($subcollec['authority_number']) { $subcoll_id = keep_authority_infos($subcollec['authority_number'], "subcollection", $origin_authority, 0, $subcollec); } else { $subcoll_id = collection::import($subcollec); } $subcoll_id = subcollection::import($subcollec); /* traitement des séries */ $serie_id = serie::import(clean_string($serie[0]['t'])); $tnvol_ins = $serie[0]['v']; if (!$serie_id) { $serie_id = serie::import(clean_string($serie_200[0]['i'])); $serie[0]['t'] = $serie_200[0]['i']; //$tnvol_ins=$serie_200[0]['h']; } if (!$tnvol_ins) { $tnvol_ins = $serie_200[0]['h']; } } } /* traitement de Dewey */ $indexint_id = indexint::import(clean_string($dewey[0]), $dewey_l[0]); if (!$indexint_id and count($info_686)) { $indexint_id = indexint::import(clean_string($info_686[0]["a"]), $info_686[0]["l"], 99); } /* Traitement des notes */ $n_resume_total = ""; $n_gen_total = ""; $n_contenu_total = ""; if (!$n_resume) { $n_resume = array(); } $n_resume_total = implode("\n", $n_resume); if (!$n_gen) { $n_gen = array(); } $n_gen_total = implode("\n", $n_gen); if (!$n_contenu) { $n_contenu = array(); } $n_contenu_total = implode("\n", $n_contenu); // ajout : les 464$a sont ajouté aux notes de contenu à déporter éventuellement dans func_bdp41 si besoin for ($i = 0; $i < count($analytique); $i++) { $ana = array(); for ($j = 0; $j < count($analytique[$i]); $j++) { $ana[$analytique[$i][$j]["label"]][] = $analytique[$i][$j]["content"]; } if (count($ana["a"]) == 1) { //Selon la norme le $a n'est pas répétable dans le même champ 4XX $n_contenu_total .= $ana["a"][0] . (count($ana["e"]) ? " ; " . implode(" ; ", $ana["e"]) : "") . (count($ana["f"]) ? " / " . implode(" / ", $ana["f"]) : "") . (count($ana["g"]) ? " / " . implode(" / ", $ana["g"]) : "") . "\n"; } else { //Au cas où for ($j = 0; $j < count($ana["a"]); $j++) { $n_contenu_total .= $ana["a"][$j] . ($ana["e"][$j] ? " ; " . $ana["e"][$j] : "") . ($ana["f"][$j] ? " / " . $ana["f"][$j] : "") . ($ana["g"][$j] ? " / " . $ana["g"][$j] : "") . "\n"; } } } // Préparation des titres $tit[0]['a'] = implode(" ; ", $tit_200a); if ($bibliographic_level != "a" && $bibliographic_level != "b" && $bibliographic_level != "s") { //Pour les articles et les bulletins on ne garde pas les informations suivantes $tit[0]['c'] = implode(" ; ", $tit_200c); } else { $tit[0]['c'] = ""; } $tit[0]['d'] = implode(" ; ", $tit_200d); $tit[0]['e'] = implode(" ; ", $tit_200e); if (is_array($index_sujets)) { $index_l = implode(' ' . $pmb_keyword_sep . ' ', $index_sujets); } else { $index_l = $index_sujets; } // if (trim($n_resume_total)=="") $n_resume_total = $n_gen_total." ".$n_contenu_total ; /* Origine de la notice */ $origine_not['nom'] = clean_string($origine_notice[0]['b']); $origine_not['pays'] = clean_string($origine_notice[0]['a']); $orinot_id = origine_notice::import($origine_not); if ($orinot_id == 0) { $orinot_id = 1; } if ($bibliographic_level != "a" && $bibliographic_level != "s") { //Pour les articles et les periodiques on ne garde pas les informations suivantes // prix $price = $prix[0]; //Pour les CDs if (!$price) { $price = $prix_cd[0]; } $illustration = implode(" : ", $ill); $taille = implode(" ; ", $size); $mat_accomp = implode(" + ", $accomp); if ($bibliographic_level != "b") { $mention_edit = implode(", ", $no_edition); } else { $mention_edit = ""; } } else { $illustration = ""; $taille = ""; $mat_accomp = ""; } if ($bibliographic_level != "s") { //Pour les periodiques on ne garde pas les informations suivantes $nbpages = implode(" - ", $npages); } else { $nbpages = ""; } /* and at least, the insertion in notices table */ $sql_ins = "insert into notices (\n\t\t\t\t\t\ttypdoc\t\t\t,\n\t\t\t\t\t\tcode \t,\n\t\t\t\t\t\tstatut\t\t\t,\n\t\t tit1 ,\n\t\t tit2 ,\n\t\t tit3 ,\n\t\t tit4 ,\n\t\t tparent_id ,\n\t\t tnvol ,\n\t\t ed1_id ,\n\t\t ed2_id ,\n\t\t year ,\n\t\t npages ,\n\t\t ill ,\n\t\t size ,\n\t\t accomp ,\n\t\t coll_id ,\n\t\t subcoll_id ,\n\t\t nocoll ,\n\t\t mention_edition\t,\n\t\t n_gen ,\n\t\t n_contenu ,\n\t\t n_resume ,\n\t\t index_l,\n\t\t indexint,\n\t\t niveau_biblio,\n\t\t niveau_hierar,\n\t\t lien,\n\t\t eformat,\n\t\t origine_catalogage,\n\t\t prix,\n\t\t\t\t\t\tcreate_date,\n\t\t\t\t\t\tdate_parution\n\t\t\t\t) values (\n\t\t\t\t\t\t'" . $doc_type . "',\t\n\t\t\t\t\t\t'" . addslashes($isbn_OK) . "',\t\n\t\t\t\t\t\t'" . $statutnot . "',\n\t\t '" . addslashes(clean_string($tit[0]['a'])) . "',\n\t\t '" . addslashes(clean_string($tit[0]['c'])) . "',\n\t\t '" . addslashes(clean_string($tit[0]['d'])) . "',\n\t\t '" . addslashes(clean_string($tit[0]['e'])) . "',\n\t\t '" . $serie_id . "',\n\t\t '" . addslashes($tnvol_ins) . "',\n\t\t " . $ed1_id . " ,\n\t\t " . $ed2_id . " ,\n\t\t '" . addslashes($year) . "',\n\t\t '" . addslashes($nbpages) . "',\n\t\t '" . addslashes($illustration) . "',\n\t\t '" . addslashes($taille) . "',\n\t\t '" . addslashes($mat_accomp) . "',\n\t\t " . $coll_id . " ,\n\t\t " . $subcoll_id . " ,\n\t\t '" . addslashes($nocoll_ins) . "',\n\t\t '" . addslashes($mention_edit) . "',\n\t\t '" . addslashes($n_gen_total) . "',\n\t\t \t'" . addslashes($n_contenu_total) . "',\n\t\t \t'" . addslashes($n_resume_total) . "',\n\t\t '" . addslashes($index_l) . "',\n\t\t '" . $indexint_id . "',\n\t\t '" . $bibliographic_level . "',\n\t\t '" . $hierarchic_level . "',\n\t\t '" . addslashes($lien[0]) . "',\n\t\t '" . addslashes($eformat[0]) . "',\n\t\t '" . $orinot_id . "',\n\t\t '" . addslashes($price) . "',\n\t\t\t\t\t\tsysdate(),\n\t\t\t\t\t\t'" . addslashes($date_parution) . "'\n\t\t\t\t\t\t)"; mysql_query($sql_ins, $dbh) or die("Couldn't insert into notices ! = " . $sql_ins); $notice_id = mysql_insert_id($dbh); notice::majNotices($notice_id); audit::insert_creation(AUDIT_NOTICE, $notice_id); //calcul des droits d'accès s'ils sont activés calc_notice_acces_rights($notice_id); // on devait attendre que la notice soit intégrée pour faire l'association avec la notice..; if ($collec['authority_number']) { keep_authority_infos($collec['authority_number'], "scollection", $origin_authority, $notice_id, $collec); } if ($subcollec['authority_number']) { keep_authority_infos($subcollec['authority_number'], "subcollection", $origin_authority, $notice_id, $subcollec); } /* INSERT de la notice OK, on va traiter les auteurs 70# : personnal : type auteur 70 71# : collectivités : type auteur 71 1 seul en 700 idem pour les déclinaisons n en 701 n en 702 les 7#0 tombent en auteur principal : responsability_type = 0 les 7#1 tombent en autre auteur : responsability_type = 1 les 7#2 tombent en auteur secondaire : responsability_type = 2 */ $aut_array = array(); /* on compte tout de suite le nbre d'enreg dans les répétables */ $nb_repet_701 = sizeof($aut_701); $nb_repet_711 = sizeof($aut_711); $nb_repet_702 = sizeof($aut_702); $nb_repet_712 = sizeof($aut_712); //indicateur["710"]; /* renseignement de aut0 */ if ($aut_700[0][a] != "") { /* auteur principal en 700 ? */ $aut_array[] = array("entree" => $aut_700[0]['a'], "rejete" => $aut_700[0]['b'], "author_comment" => $aut_700[0]['c'] . " " . $aut_700[0]['d'], "date" => $aut_700[0]['f'], "type_auteur" => "70", "fonction" => $aut_700[0][4], "id" => 0, "responsabilite" => 0, "ordre" => 0, 'authority_number' => $aut_700[0][3]); } elseif ($aut_710[0]['a'] != "") { /* auteur principal en 710 ? */ if (substr($indicateur["710"][0], 0, 1) == "1") { $type_auteur = "72"; } else { $type_auteur = "71"; } $lieu = $aut_710[0]['e']; if (!$lieu) { $lieu = $aut_710[0]['k']; } $aut_array[] = array("entree" => $aut_710[0]['a'], "rejete" => $aut_710[0]['g'], "subdivision" => $aut_710[0]['b'], "author_comment" => $aut_710[0]['c'], "numero" => $aut_710[0]['d'], "lieu" => $lieu, "ville" => $aut_710[0]['l'], "pays" => $aut_710[0]['m'], "web" => $aut_710[0]['n'], "date" => $aut_710[0]['f'], "type_auteur" => $type_auteur, "fonction" => $aut_710[0][4], "id" => 0, "responsabilite" => 0, "ordre" => 0, 'authority_number' => $aut_710[0][3]); } /* renseignement de aut1 */ for ($i = 0; $i < $nb_repet_701; $i++) { $aut_array[] = array("entree" => $aut_701[$i]['a'], "rejete" => $aut_701[$i]['b'], "author_comment" => $aut_701[$i]['c'] . " " . $aut_701[$i]['d'], "date" => $aut_701[$i]['f'], "type_auteur" => "70", "fonction" => $aut_701[$i][4], "id" => 0, "responsabilite" => 1, "ordre" => $i + 1, 'authority_number' => $aut_701[$i][3]); } for ($i = 0; $i < $nb_repet_711; $i++) { if (substr($indicateur["711"][$i], 0, 1) == "1") { $type_auteur = "72"; } else { $type_auteur = "71"; } $lieu = $aut_711[$i]['e']; if (!$lieu) { $lieu = $aut_711[$i]['k']; } $aut_array[] = array("entree" => $aut_711[$i]['a'], "rejete" => $aut_711[$i]['g'], "subdivision" => $aut_711[$i]['b'], "author_comment" => $aut_711[$i]['c'], "numero" => $aut_711[$i]['d'], "lieu" => $lieu, "ville" => $aut_711[$i]['l'], "pays" => $aut_711[$i]['m'], "web" => $aut_711[$i]['n'], "date" => $aut_711[$i]['f'], "type_auteur" => $type_auteur, "fonction" => $aut_711[$i][4], "id" => 0, "responsabilite" => 1, "ordre" => $i + 1, 'authority_number' => $aut_711[$i][3]); } /* renseignement de aut2 */ for ($i = 0; $i < $nb_repet_702; $i++) { $aut_array[] = array("entree" => $aut_702[$i]['a'], "rejete" => $aut_702[$i]['b'], "author_comment" => $aut_702[$i]['c'] . " " . $aut_702[$i]['d'], "date" => $aut_702[$i]['f'], "type_auteur" => "70", "fonction" => $aut_702[$i][4], "id" => 0, "responsabilite" => 2, "ordre" => $i + 1, 'authority_number' => $aut_702[$i][3]); } for ($i = 0; $i < $nb_repet_712; $i++) { if (substr($indicateur["712"][$i], 0, 1) == "1") { $type_auteur = "72"; } else { $type_auteur = "71"; } $lieu = $aut_712[$i]['e']; if (!$lieu) { $lieu = $aut_712[$i]['k']; } $aut_array[] = array("entree" => $aut_712[$i]['a'], "rejete" => $aut_712[$i]['g'], "subdivision" => $aut_712[$i]['b'], "author_comment" => $aut_712[$i]['c'], "numero" => $aut_712[$i]['d'], "lieu" => $lieu, "ville" => $aut_712[$i]['l'], "pays" => $aut_712[$i]['m'], "web" => $aut_712[$i]['n'], "date" => $aut_712[$i]['f'], "type_auteur" => $type_auteur, "fonction" => $aut_712[$i][4], "id" => 0, "responsabilite" => 2, "ordre" => $i + 1, 'authority_number' => $aut_712[$i][3]); } // récup des infos auteurs et mise en tableau : // appel de la fonction membre d'importation et insertion en table $rqt_ins = "insert into responsability (responsability_author, responsability_notice, responsability_fonction, responsability_type, responsability_ordre) VALUES "; $values = ""; if (count($aut_array)) { for ($i = 0; $i < sizeof($aut_array); $i++) { $aut = array(); $aut['name'] = clean_string($aut_array[$i]['entree']); $aut['rejete'] = clean_string($aut_array[$i]['rejete']); $aut['type'] = $aut_array[$i]['type_auteur']; $aut['date'] = clean_string($aut_array[$i]['date']); $aut['subdivision'] = clean_string($aut_array[$i]['subdivision']); $aut['numero'] = clean_string($aut_array[$i]['numero']); $aut['lieu'] = clean_string($aut_array[$i]['lieu']); $aut['ville'] = clean_string($aut_array[$i]['ville']); $aut['pays'] = clean_string($aut_array[$i]['pays']); $aut['web'] = clean_string($aut_array[$i]['web']); $aut['author_comment'] = clean_string($aut_array[$i]['author_comment']); $aut['authority_number'] = clean_string($aut_array[$i]['authority_number']); //si on à demander la prise en compte des numéro d'autorités if ($authorities_notices && $aut['authority_number'] != "") { $aut_array[$i]["id"] = keep_authority_infos($aut['authority_number'], "author", $origin_authority, $notice_id, $aut); } if (!$aut_array[$i]["id"]) { $aut_array[$i]["id"] = auteur::import($aut); } $aut_array[$i]['fonction'] = trim($aut_array[$i]['fonction']); if ($aut_array[$i]["id"]) { if ($values != "") { $values .= ","; } $values .= " ('" . $aut_array[$i]["id"] . "','" . $notice_id . "','" . addslashes($aut_array[$i]['fonction']) . "','" . $aut_array[$i]['responsabilite'] . "','" . $aut_array[$i]['ordre'] . "') "; // $rqt = $rqt_ins . " ('".$aut_array[$i]["id"]."','".$notice_id."','".addslashes($aut_array[$i]['fonction'])."','".$aut_array[$i]['responsabilite']."','".$aut_array[$i]['ordre']."') " ; // @mysql_query($rqt, $dbh); } } @mysql_query($rqt_ins . $values); } // Titres uniformes global $pmb_use_uniform_title; if ($pmb_use_uniform_title) { $nb_tu = sizeof($tu_500); for ($i = 0; $i < $nb_tu; $i++) { $value_tu[$i]['name'] = $tu_500[$i]['a']; $value_tu[$i]['tonalite'] = $tu_500[$i]['u']; $value_tu[$i]['comment'] = $tu_500[$i]['n']; $value_tu[$i]['authority_number'] = $tu_500[$i]['3']; for ($j = 0; $j < count($tu_500_r[$i]); $j++) { $value_tu[$i]['distrib'][$j] = $tu_500_r[$i][$j]; } for ($j = 0; $j < count($tu_500_s[$i]); $j++) { $value_tu[$i]['ref'][$j] = $tu_500_s[$i][$j]; } for ($j = 0; $j < count($tu_500_j[$i]); $j++) { $value_tu[$i]['subdiv'][$j] = $tu_500_j[$i][$j]; } if ($authorities_notices && $aut['authority_number'] != "") { $tu_id = keep_authority_infos($value_tu[$i]['authority_number'], "uniform_title", $origin_authority, $notice_id, $value_tu[$i]); } else { $tu_id = titre_uniforme::import($value_tu[$i]); } if ($tu_id) { $requete = "INSERT INTO notices_titres_uniformes SET \n\t\t\t\t\tntu_num_notice='{$notice_id}', \n\t\t\t\t\tntu_num_tu='{$tu_id}', \n\t\t\t\t\tntu_titre='" . addslashes($tu_500[$i]['i']) . "', \n\t\t\t\t\tntu_date='" . addslashes($tu_500[$i]['k']) . "', \n\t\t\t\t\tntu_sous_vedette='" . addslashes($tu_500[$i]['l']) . "', \n\t\t\t\t\tntu_langue='" . addslashes($tu_500[$i]['m']) . "', \n\t\t\t\t\tntu_version='" . addslashes($tu_500[$i]['q']) . "', \n\t\t\t\t\tntu_mention='" . addslashes($tu_500[$i]['w']) . "',\n\t\t\t\t\tntu_ordre={$i} \t\t\t\t\n\t\t\t\t\t"; mysql_query($requete, $dbh); } } } global $lang_code; global $org_lang_code; $rqt_ins = "insert into notices_langues (num_notice, type_langue, code_langue, ordre_langue) VALUES "; $values = ""; for ($i = 0; $i < count($lang_code); $i++) { $lang_code[$i] = trim($lang_code[$i]); if ($values != "") { $values .= ","; } $values .= "('{$notice_id}',0, '" . addslashes($lang_code[$i]) . "','{$i}') "; //$rqt_ins = "insert into notices_langues (num_notice, type_langue, code_langue) VALUES ('$notice_id',0, '".addslashes($lang_code[$i])."') " ; //@mysql_query($rqt_ins, $dbh); } for ($i = 0; $i < count($org_lang_code); $i++) { $org_lang_code[$i] = trim($org_lang_code[$i]); if ($values != "") { $values .= ","; } $values .= "('{$notice_id}',1, '" . addslashes($org_lang_code[$i]) . "','" . $i . "') "; //$rqt_ins = "insert into notices_langues (num_notice, type_langue, code_langue) VALUES ('$notice_id',1, '".addslashes($org_lang_code[$i])."') " ; // @mysql_query($rqt_ins, $dbh); } @mysql_query($rqt_ins . $values, $dbh); //Import des catégories category_auto::save_info_categ(); //Calcule de la signature $sign = new notice_doublon(); $val = $sign->gen_signature($notice_id); mysql_query("update notices set signature='{$val}' where notice_id=" . $notice_id, $dbh); //Si on a un id de notice et qu'il n'est pas dans le tableau des notices créées, on l'ajoute if ($link_generate && trim($id_unimarc) !== "" && !$notices_crees[$id_unimarc]) { $notices_crees[$id_unimarc] = $notice_id; } elseif ($link_generate && trim($id_unimarc) !== "" && $notices_crees[$id_unimarc]) { //Si la notice a déjà été créé (Export des liens dans les notices liées) on remplace celle précédemment par celle en cour de traitement $niveau_biblio = $bibliographic_level . $hierarchic_level; switch ($niveau_biblio) { case 'm0': //On a une notice de monographie $notice_a_supp = $notices_crees[$id_unimarc]; //On garde les liens $requete = "UPDATE notices_relations SET num_notice='" . $notice_id . "' WHERE num_notice='" . $notice_a_supp . "' "; @mysql_query($requete, $dbh); $requete = "UPDATE notices_relations SET linked_notice='" . $notice_id . "' WHERE linked_notice='" . $notice_a_supp . "' "; @mysql_query($requete, $dbh); $ma_notice = new notice($notice_a_supp); $ma_notice->replace($notice_id); break; case 's1': //On a une notice de periodique $notice_a_supp = $notices_crees[$id_unimarc]; $ma_notice = new serial($notice_a_supp); $ma_notice->replace($notice_id); break; case 'b2': //On a une notice de bulletin $notice_a_supp = $notices_crees[$id_unimarc]; //Dans les bulletins $requete = "update bulletins set num_notice='" . $notice_id . "' where num_notice='" . $notice_a_supp . "' "; mysql_query($requete, $dbh); //Dans les relations entre notice $requete = "update notices_relations set num_notice='" . $notice_id . "' where num_notice='" . $notice_a_supp . "'"; mysql_query($requete, $dbh); $requete = "update notices_relations set linked_notice='" . $notice_id . "' where linked_notice='" . $notice_a_supp . "'"; mysql_query($requete, $dbh); notice::del_notice($notice_a_supp); break; case 'a2': //On a une notice d'article $notice_a_supp = $notices_crees[$id_unimarc]; //Dans les bulletins $requete = "update analysis set analysis_notice='" . $notice_id . "' where analysis_notice='" . $notice_a_supp . "' "; mysql_query($requete, $dbh); //Dans les relations entre notice $requete = "update notices_relations set num_notice='" . $notice_id . "' where num_notice='" . $notice_a_supp . "'"; mysql_query($requete, $dbh); $requete = "update notices_relations set linked_notice='" . $notice_id . "' where linked_notice='" . $notice_a_supp . "'"; mysql_query($requete, $dbh); notice::del_notice($notice_a_supp); break; } $notices_crees[$id_unimarc] = $notice_id; } }
protected function create_notice() { global $pmb_keyword_sep; global $pmb_type_audit; global $webdav_current_user_name, $webdav_current_user_id; if ($this->data['publisher']) { $ed_1 = \editeur::import(array('name' => $this->data['publisher'])); } else { $ed_1 = 0; } $ind_wew = $this->data['tit1'] . " " . $this->data['tit4']; $ind_sew = \strip_empty_words($ind_wew); $query = "insert into notices set\n\t\t\t\ttit1 = '" . addslashes($this->data['tit1']) . "'," . ($this->data['code'] ? "code='" . $this->data['code'] . "'," : "") . "ed1_id = '" . $ed_1 . "'," . ($this->data['tit4'] ? "tit4 = '" . addslashes($this->data['tit4']) . "'," : "") . ($this->data['npages'] ? "npages = '" . addslashes($this->data['npages']) . "'," : "") . ($this->data['index_l'] ? "index_l = '" . addslashes($this->data['index_l']) . "'," : "") . "\n\t\t\t\tyear = '" . $this->data['year'] . "',\n\t\t\t\tniveau_biblio='m',\n\t\t\t\tniveau_hierar='0',\n\t\t\t\tstatut = '" . $this->config['default_statut'] . "',\n\t\t\t\tindex_wew = '" . $ind_wew . "',\n\t\t\t\tindex_sew = '" . $ind_sew . "',\n\t\t\t\tn_resume = '" . addslashes($this->data['n_resume']) . "',\n\t\t\t\tlien = '" . addslashes($url) . "',\n\t\t\t\tindex_n_resume = '" . \strip_empty_words($this->data['n_resume']) . "'," . ($this->data['thumbnail_content'] ? "thumbnail_url = 'data:image/png;base64," . base64_encode($this->data['thumbnail_content']) . "'," : "") . "create_date = sysdate(),\n\t\t\t\tupdate_date = sysdate()"; pmb_mysql_query($query); $notice_id = pmb_mysql_insert_id(); //traitement audit if ($pmb_type_audit) { $query = "INSERT INTO audit SET "; $query .= "type_obj='1', "; $query .= "object_id='{$notice_id}', "; $query .= "user_id='{$webdav_current_user_id}', "; $query .= "user_name='{$webdav_current_user_name}', "; $query .= "type_modif=1 "; $result = @pmb_mysql_query($query); } if (count($this->data['authors'])) { $i = 0; foreach ($this->data['authors'] as $author) { $aut = array(); if ($author['file-as']) { $infos = explode(",", $author['file-as']); $aut = array('name' => $infos[0], 'rejete' => $infos[1], 'type' => 70); } if (!$aut['name']) { $aut = array('name' => $author['value'], 'type' => 70); } $aut_id = \auteur::import($aut); if ($aut_id) { $query = "insert into responsability set\n\t\t\t\t\t\t\tresponsability_author = '" . $aut_id . "',\n\t\t\t\t\t\t\tresponsability_notice = '" . $notice_id . "',\n\t\t\t\t\t\t\tresponsability_type = '0'"; pmb_mysql_query($query); $i++; } } } if (count($this->data['co_authors'])) { foreach ($this->data['co_authors'] as $author) { $aut = array(); if ($author['file-as']) { $infos = explode(",", $author['file-as']); $aut = array('name' => $infos[0], 'rejete' => $infos[1], 'type' => 70); } if (!$aut['name']) { $aut = array('name' => $author['value'], 'type' => 70); } $aut_id = \auteur::import($aut); if ($aut_id) { $query = "insert into responsability set\n\t\t\t\t\t\t\tresponsability_author = '" . $aut_id . "',\n\t\t\t\t\t\t\tresponsability_notice = '" . $notice_id . "',\n\t\t\t\t\t\t\tresponsability_type = '0',\n\t\t\t\t\t\t\trepsonsability_ordre = '" . $i . "'"; pmb_mysql_query($query); $i++; } } } return $notice_id; }
/** * @param array $entry le tableau $entry généré par la fonction buildEntry() * * Fonction d'import d'une notice formaté par la fonction buildEntry() * Ajoute les informations d'audit * Ajoute les champs personnalisés * Ajoute les tables annexes [responsability], [notices_categories] et [notices_langues] * Met à jours l'indexation de la notice */ static function buildNotice(&$entry) { global $pmb_type_audit; global $webdav_current_user_name, $webdav_current_user_id; //la notice existe déjà ? si oui, on renvoi l'id trouvé if ($entry['niveau_biblio'] . $entry['niveau_hierar'] == 'a2') { $query = ' SELECT n1.* FROM notices AS n1 JOIN analysis ON n1.notice_id=analysis_notice JOIN bulletins ON bulletin_id=analysis_bulletin JOIN notices AS n2 ON n2.notice_id=bulletin_notice WHERE n1.tit1="' . addslashes($entry['tit1']) . '" AND n1.niveau_biblio="' . addslashes($entry['niveau_biblio']) . '" AND n1.niveau_hierar="' . addslashes($entry['niveau_hierar']) . '" AND bulletin_numero="' . addslashes($entry['bulletin']['bulletin_numero']) . '" AND mention_date="' . addslashes($entry['bulletin']['mention_date']) . '" AND date_date="' . addslashes($entry['bulletin']['date_date']) . '" AND n2.tit1="' . addslashes($entry['periodique']['tit1']) . '" AND n2.niveau_biblio="' . addslashes($entry['periodique']['niveau_biblio']) . '" AND n2.niveau_hierar="' . addslashes($entry['periodique']['niveau_hierar']) . '" '; $result = mysql_query($query); } else { $query = 'SELECT * FROM notices WHERE tit1="' . addslashes($entry['tit1']) . '" AND niveau_biblio="' . addslashes($entry['niveau_biblio']) . '" AND niveau_hierar="' . addslashes($entry['niveau_hierar']) . '"'; $result = mysql_query($query); } if (mysql_num_rows($result)) { // La notice existe $entry = array_merge(mysql_fetch_array($result, MYSQL_ASSOC), $entry); //TODO : A vérifier $first = true; $query = 'UPDATE notices SET '; foreach (array_keys($entry) as $fieldName) { if (!is_array($entry[$fieldName]) && $entry[$fieldName] != '' && $fieldName != 'ancien_num_name') { if (!$first) { $query .= ','; } $query .= $fieldName . '="' . addslashes($entry[$fieldName]) . '"'; $first = false; } } $query .= ' WHERE notice_id="' . addslashes($entry['notice_id']) . '"'; mysql_query($query) or die('echec de la requete : ' . $query . '<br/>' . mysql_error() . "\n"); } else { //les éditeurs if (sizeof($entry['publishers'])) { foreach ($entry['publishers'] as $id => $publisher) { if ($id < 2) { if ($id === 0) { $entry['ed1_id'] = \editeur::import($publisher); } elseif ($id === 1) { $entry['ed2_id'] = \editeur::import($publisher); } } } } //la collection if (sizeof($entry['collections']) && $entry['ed1_id']) { $entry['collections']['parent'] = $entry['ed1_id']; $entry['coll_id'] = \collection::import($entry['collections']); } $first = true; $query = 'INSERT INTO notices SET '; foreach ($entry as $fieldName => $value) { if (!is_array($value) && $value != '') { if (!$first) { $query .= ','; } $query .= $fieldName . '="' . addslashes(trim($value)) . '"'; $first = false; } } mysql_query($query) or die('Echec d\'execution de la requete ' . $query . ' : ' . mysql_error()); $entry['notice_id'] = mysql_insert_id(); if ($pmb_type_audit && ($webdav_current_user_id || $webdav_current_user_name) && $entry['create_date']) { //ajout des informations d'audit $query = 'INSERT INTO audit (type_obj,object_id,user_id,user_name,type_modif,quand) VALUES (1,' . $entry['notice_id'] . ',' . $webdav_current_user_id . ',"' . addslashes($webdav_current_user_name) . '",1,"' . $entry['create_date'] . '")'; mysql_query($query) or die('Echec d\'execution de la requete ' . $query . ' : ' . mysql_error()); } } //les champs persos if (sizeof($entry['cp'])) { foreach ($entry['cp'] as $cp) { \parametres_perso::import($entry['notice_id'], $cp['field'], $cp['value'], 'notices'); } } //ajout dans les tables annexes a la notice if (sizeof($entry['annexes'])) { foreach ($entry['annexes'] as $typeAnnexe => $annexes) { foreach ($annexes as $id => $annexe) { switch ($typeAnnexe) { case 'responsability': //Import et récupération des identifiants auteurs $entry['annexes'][$typeAnnexe][$id]['responsability_author'] = \auteur::import($entry['annexes'][$typeAnnexe][$id]['authors']); $entry['annexes'][$typeAnnexe][$id]['responsability_notice'] = $entry['notice_id']; break; case 'notices_categories': //Import et récupération des identifiants catégories $query = 'SELECT num_noeud FROM categories WHERE libelle_categorie="' . addslashes(trim($entry['annexes'][$typeAnnexe][$id]['categories']['libelle_categorie'])) . '" AND num_thesaurus=' . $entry['annexes'][$typeAnnexe][$id]['categories']['num_thesaurus'] . ' AND langue="' . $entry['annexes'][$typeAnnexe][$id]['categories']['langue'] . '"'; $result = mysql_query($query) or die('Echec d\'execution de la requete ' . $query . ' : ' . mysql_error()); if (mysql_num_rows($result)) { //le noeud existe déjà $entry['annexes'][$typeAnnexe][$id]['num_noeud'] = mysql_result($result, 0, 0); } else { //le noeud n'existe pas, on cherche le parent non classé $query = 'SELECT id_noeud FROM noeuds WHERE autorite="NONCLASSES" AND num_thesaurus=' . $entry['annexes'][$typeAnnexe][$id]['categories']['num_thesaurus']; $result = mysql_query($query) or die('Echec d\'execution de la requete ' . $query . ' : ' . mysql_error()); if (mysql_num_rows($result)) { //on ajoute le noeud $query = 'INSERT INTO noeuds SET num_parent=' . mysql_result($result, 0, 0) . ', visible=1, num_thesaurus=' . $entry['annexes'][$typeAnnexe][$id]['categories']['num_thesaurus']; mysql_query($query) or die('Echec d\'execution de la requete ' . $query . ' : ' . mysql_error()); $entry['annexes']['notices_categories'][$id]['num_noeud'] = mysql_insert_id(); //on ajoute la catégorie $categorie = new \categories($entry['annexes'][$typeAnnexe][$id]['num_noeud'], $entry['annexes'][$typeAnnexe][$id]['categories']['langue']); $categorie->libelle_categorie = trim($entry['annexes'][$typeAnnexe][$id]['categories']['libelle_categorie']); $categorie->save(); } } $entry['annexes'][$typeAnnexe][$id]['notcateg_notice'] = $entry['notice_id']; break; case 'notices_langues': $entry['annexes'][$typeAnnexe][$id]['num_notice'] = $entry['notice_id']; break; case 'notices_authorities_sources': $entry['annexes'][$typeAnnexe][$id]['num_notice'] = $entry['notice_id']; break; case 'notices_relations': $entry['annexes'][$typeAnnexe][$id]['num_notice'] = $entry['notice_id']; break; case 'notices_titres_uniformes': $entry['annexes'][$typeAnnexe][$id]['ntu_num_notice'] = $entry['notice_id']; break; } $first = true; $query = 'INSERT IGNORE INTO ' . $typeAnnexe . ' SET '; foreach ($entry['annexes'][$typeAnnexe][$id] as $fieldName => $value) { if (!is_array($value) && $value != '') { if (!$first) { $query .= ','; } $query .= $fieldName . '="' . addslashes(trim($value)) . '"'; $first = false; } } mysql_query($query) or die('Echec d\'execution de la requete ' . $query . ' : ' . mysql_error()); } } } \notice::majNoticesTotal($entry['notice_id']); }
function get_notice_by_meta($name, $filename) { global $pmb_keyword_sep; global $pmb_type_audit; global $webdav_current_user_name, $webdav_current_user_id; \create_tableau_mimetype(); $mimetype = \trouve_mimetype($filename, extension_fichier($name)); $notice_id = 0; $title = $cplt = $code = $pages = $year = $keywords = $url = $thumbnail_content = ""; //on commence avec la gymnatisque des métas... if ($mimetype == "application/epub+zip") { //pour les ebook, on gère ca directement ici ! $epub = new \epubData(realpath($filename)); $title = $epub->metas['title'][0]; $authors = $epub->metas['creator']; $co_authors = $epub->metas['contributor']; if ($epub->metas['identifier']['isbn']) { $code = \formatISBN($epub->metas['identifier']['isbn'], 13); } else { if ($epub->metas['identifier']['ean']) { $code = \EANtoISBN($epub->metas['identifier']['ean']); $code = \formatISBN($code, 13); } } if ($epub->metas['identifier']['uri']) { $url = \clean_string($epub->metas['identifier']['uri']); } $publisher = $epub->metas['publisher'][0]; $year = $epub->metas['date'][0]['value']; if (strlen($year) && strlen($year) != 4) { $year = \formatdate(detectFormatDate($year)); } $lang = $epub->metas['language']; $resume = implode("\n", $epub->metas['description']); $keywords = implode($pmb_keyword_sep, $epub->metas['subject']); //jouons à et si on trouvait a vignette... $img = imagecreatefromstring($epub->getCoverContent()); $file = tempnam(sys_get_temp_dir(), "vign"); imagepng($img, $file); $thumbnail_content = file_get_contents($file); unlink($file); } else { $metas = \extract_metas(realpath($filename), $mimetype); if ($metas['Title'] && $metas['Author'] && $metas['Subject']) { $title = $metas['Title']; $author = $metas['Author']; $cplt = $metas['Subject']; } else { // métas non fiable, on regarde avec le titre... $title = $name; } //date de création... if ($metas["CreateDate"]) { $year = substr($metas["CreateDate"], 0, 4); } //pages if ($metas['PageCount']) { $pages = $metas['PageCount']; } //keywords if ($metas['Keywords']) { foreach ($metas['Keywords'] as $keyword) { if ($keywords != "") { $keywords .= $pmb_keyword_sep; } $keywords .= $keyword; } } } $query = "select notice_id from notices where tit1 = '" . addslashes($title) . "'"; $result = mysql_query($query); if (mysql_num_rows($result)) { $notice_id = mysql_result($result, 0, 0); } if (!$notice_id) { //en cas d'une leture moyenne des infos, on s'assure d'avoir au moins un titre.... if (!$title) { $title = $name; } if ($publisher) { $ed_1 = \editeur::import(array('name' => $publisher)); } else { $ed_1 = 0; } $ind_wew = $title . " " . $cplt; $ind_sew = \strip_empty_words($ind_wew); $query = "insert into notices set \n\t\t\t\ttit1 = '" . addslashes($title) . "'," . ($code ? "code='" . $code . "'," : "") . "ed1_id = '" . $ed_1 . "'," . ($cplt ? "tit4 = '" . addslashes($cplt) . "'," : "") . ($pages ? "npages = '" . addslashes($pages) . "'," : "") . ($keywords ? "index_l = '" . addslashes($keywords) . "'," : "") . "\n\t\t\t\tyear = '" . $year . "',\n\t\t\t\tniveau_biblio='m', \n\t\t\t\tniveau_hierar='0',\n\t\t\t\tstatut = '" . $this->config['default_statut'] . "',\n\t\t\t\tindex_wew = '" . $ind_wew . "',\n\t\t\t\tindex_sew = '" . $ind_sew . "',\n\t\t\t\tn_resume = '" . addslashes($resume) . "',\n\t\t\t\tlien = '" . addslashes($url) . "',\n\t\t\t\tindex_n_resume = '" . \strip_empty_words($resume) . "'," . ($thumbnail_content ? "thumbnail_url = 'data:image/png;base64," . base64_encode($thumbnail_content) . "'," : "") . "create_date = sysdate(), \n\t\t\t\tupdate_date = sysdate()"; mysql_query($query); $notice_id = mysql_insert_id(); $sign = new \notice_doublon(); mysql_query("update notices set signature = '" . $sign->gen_signature($notice_id) . "' where notice_id = " . $notice_id); //traitement audit if ($pmb_type_audit) { $query = "INSERT INTO audit SET "; $query .= "type_obj='1', "; $query .= "object_id='{$notice_id}', "; $query .= "user_id='{$webdav_current_user_id}', "; $query .= "user_name='{$webdav_current_user_name}', "; $query .= "type_modif=1 "; $result = @mysql_query($query); } if (count($authors)) { $i = 0; foreach ($authors as $author) { $aut = array(); if ($author['file-as']) { $infos = explode(",", $author['file-as']); $aut = array('name' => $infos[0], 'rejete' => $infos[1], 'type' => 70); } if (!$aut['name']) { $aut = array('name' => $author['value'], 'type' => 70); } $aut_id = \auteur::import($aut); if ($aut_id) { $query = "insert into responsability set \n\t\t\t\t\t\t\tresponsability_author = '" . $aut_id . "',\n\t\t\t\t\t\t\tresponsability_notice = '" . $notice_id . "',\n\t\t\t\t\t\t\tresponsability_type = '0'"; mysql_query($query); $i++; } } } if (count($co_authors)) { foreach ($co_authors as $author) { $aut = array(); if ($author['file-as']) { $infos = explode(",", $author['file-as']); $aut = array('name' => $infos[0], 'rejete' => $infos[1], 'type' => 70); } if (!$aut['name']) { $aut = array('name' => $author['value'], 'type' => 70); } $aut_id = \auteur::import($aut); if ($aut_id) { $query = "insert into responsability set \n\t\t\t\t\t\t\tresponsability_author = '" . $aut_id . "',\n\t\t\t\t\t\t\tresponsability_notice = '" . $notice_id . "',\n\t\t\t\t\t\t\tresponsability_type = '0',\n\t\t\t\t\t\t\trepsonsability_ordre = '" . $i . "'"; mysql_query($query); $i++; } } } } return $notice_id; }