function cleanSynchroRdfStore() { global $msg, $dbh, $charset, $PMBusername; if (SESSrights & ADMINISTRATION_AUTH) { $result .= "<h3>" . htmlentities($msg["nettoyage_synchrordfstore_reindexation"], ENT_QUOTES, $charset) . "</h3>"; $synchro_rdf = new synchro_rdf(); //remise a zero des tables de synchro rdf $synchro_rdf->truncateStore(); //reindex $query = mysql_query("select notice_id from notices order by notice_id"); if (mysql_num_rows($query)) { while ($mesNotices = mysql_fetch_assoc($query)) { $synchro_rdf->addRdf($mesNotices['notice_id'], 0); $notice = new notice($mesNotices['notice_id']); $niveauB = strtolower($notice->biblio_level); //Si c'est un article, il faut réindexer son bulletin if ($niveauB == 'a') { $bulletin = analysis::getBulletinIdFromAnalysisId($mesNotices['notice_id']); $synchro_rdf->addRdf(0, $bulletin); } } mysql_free_result($query); } $compte = 0; $q = "SELECT *\n\t\t\tWHERE {\n\t\t\t FILTER (!regex(?p, rdf:type,'i')) .\n\t\t\t ?s ?p ?o\n\t\t\t}"; $r = $synchro_rdf->store->query($q); if (is_array($r['result']['rows'])) { $compte = count($r['result']['rows']); } $result .= $compte . " " . htmlentities($msg["nettoyage_synchrordfstore_reindex_total"], ENT_QUOTES, $charset); } else { $result .= sprintf($msg["planificateur_rights_bad_user_rights"], $PMBusername); } return $result; }
} else { $maxAffiche = $nb_per_page_search; echo "<div class='row'><strong>" . sprintf($msg["gen_signature_erreur_similaire_nb"], $maxAffiche, $dbls) . "</strong></div>"; } $enCours = 1; while ($enCours <= $maxAffiche) { $r = pmb_mysql_fetch_object($result); if ($r->niveau_biblio != 's' && $r->niveau_biblio != 'a') { // notice de monographie $nt = new mono_display($r->notice_id, 1, 'catalog.php?categ=isbd&id=' . $r->notice_id); } elseif ($r->niveau_biblio == 's') { // on a affaire à un périodique $nt = new serial_display($r->notice_id, 1, 'catalog.php?categ=serials&sub=view&serial_id=' . $r->notice_id); } else { // on a affaire à un article $bulletin_id = analysis::getBulletinIdFromAnalysisId($r->notice_id); $nt = new serial_display($r->notice_id, 1, '', 'catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=' . $bulletin_id); } echo "\n\t\t\t\t<div class='row'>\n\t\t\t\t{$nt->result}\n\t\t \t </div>\n\t\t\t\t<script>document.getElementById('el" . $r->notice_id . "Child').setAttribute('startOpen','Yes');</script>\n\t\t\t\t<script type='text/javascript'>document.forms['dummy'].elements['ok'].focus();</script>"; $enCours++; } exit; } } //verification des droits de modification notice //droits d'acces if ($gestion_acces_active == 1) { require_once "{$class_path}/acces.class.php"; $ac = new acces(); } $acces_m = 1;
$state = floor($start / ($count / $jauge_size)); $state .= "px"; // mise à jour de l'affichage de la jauge print "<table border='0' align='center' width='{$jauge_size}' cellpadding='0'><tr><td class='jauge' width='100%'>"; print "<img src='../../images/jauge.png' width='{$state}' height='16px'></td></tr></table>"; // calcul pourcentage avancement $percent = floor($start / $count * 100); // affichage du % d'avancement et de l'état print "<div align='center'>{$percent}%</div>"; while ($mesNotices = pmb_mysql_fetch_assoc($query)) { $synchro_rdf->addRdf($mesNotices['notice_id'], 0); $notice = new notice($mesNotices['notice_id']); $niveauB = strtolower($notice->biblio_level); //Si c'est un article, il faut réindexer son bulletin if ($niveauB == 'a') { $bulletin = analysis::getBulletinIdFromAnalysisId($mesNotices['notice_id']); $synchro_rdf->addRdf(0, $bulletin); } } pmb_mysql_free_result($query); $next = $start + $lot; print "\n\t<form class='form-{$current_module}' name='current_state' action='./clean.php' method='post'>\n\t<input type='hidden' name='v_state' value=\"" . urlencode($v_state) . "\">\n\t<input type='hidden' name='spec' value=\"{$spec}\">\n\t<input type='hidden' name='start' value=\"{$next}\">\n\t<input type='hidden' name='count' value=\"{$count}\">\n\t</form>\n\t<script type=\"text/javascript\"><!-- \n\tsetTimeout(\"document.forms['current_state'].submit()\",1000); \n\t-->\n\t</script>"; } else { $spec = $spec - INDEX_SYNCHRORDFSTORE; $compte = 0; $q = "SELECT *\n\t\t\tWHERE {\n\t\t\t FILTER (!regex(?p, rdf:type,'i')) .\n\t\t\t ?s ?p ?o\n\t\t\t}"; $r = $synchro_rdf->store->query($q); if (is_array($r['result']['rows'])) { $compte = count($r['result']['rows']); } $v_state .= "<br /><img src=../../images/d.gif hspace=3>" . htmlentities($msg["nettoyage_synchrordfstore_reindexation"], ENT_QUOTES, $charset) . " :";
function show_list_recept() { global $msg, $charset, $dbh, $tab_bib; global $recept_search_form, $recept_list_form, $recept_search_form_suite, $recept_hrow_form, $recept_row_form, $sel_fou_form, $sel_dem_form, $sel_rub_form, $sel_date_form; global $bt_app, $bt_rel, $bt_chk, $link_not, $link_bull, $link_art, $link_sug, $bt_cat; global $user_userid; global $lgstat_filter, $deflt3lgstatcde; global $id_bibli, $id_exer; global $f_fou_code, $f_dem_code, $t_dem, $f_rub_code; global $cde_query, $all_query, $recept_query; global $chk_dev; global $lgstat_all, $comment_lg_all, $comment_lo_all; global $page, $nb_per_page, $nbr_lignes, $last_param; global $date_inf, $date_sup; //verifications if (!$id_bibli) { $id_bibli = entites::getSessionBibliID(); } if (!$id_bibli) { $id_bibli = $tab_bib[0][0]; } entites::setSessionBibliId($id_bibli); $id_exer = exercices::getSessionExerciceId($id_bibli, $id_exer); //Affichage form de recherche $titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_recept'], ENT_QUOTES, $charset); $recept_form = $recept_search_form; $recept_form = str_replace('!!form_title!!', $titre, $recept_form); $serialized_search = rawurlencode(serialize(array('id_bibli' => $id_bibli, 'id_exer' => $id_exer, 'f_fou_code' => $f_fou_code, 'f_dem_code' => $f_dem_code, 't_dem' => $t_dem, 'f_rub_code' => $f_rub_code, 'cde_query' => stripslashes($cde_query), 'all_query' => stripslashes($all_query), 'chk_dev' => $chk_dev, 'lgstat_filter' => $lgstat_filter))); $recept_form = str_replace('!!serialized_search!!', $serialized_search, $recept_form); //Affichage selecteur etablissement $sel_bibli = entites::getBibliHtmlSelect(SESSuserid, $id_bibli, FALSE, array('class' => 'saisie-50em', 'id' => 'id_bibli', 'name' => 'id_bibli', 'onChange' => 'submit();')); $recept_form = str_replace('<!-- sel_bibli -->', $sel_bibli, $recept_form); //Affichage selecteur exercice $sel_exer = exercices::getHtmlSelect($id_bibli, $id_exer, FALSE, array('id' => 'id_exer', 'name' => 'id_exer', 'onChange' => 'submit();')); $recept_form = str_replace('<!-- sel_exer -->', $sel_exer, $recept_form); //Affichage fournisseurs $i = 0; $tab_fou2 = array(); if (is_array($f_fou_code) && count($f_fou_code)) { $tab_fou = entites::getRaisonSociale($f_fou_code, $id_bibli); foreach ($f_fou_code as $v) { if ($v && $tab_fou[$v]) { $tab_fou2[$v] = $tab_fou[$v]; if ($i > 0) { $recept_form = str_replace('<!-- sel_fou -->', $sel_fou_form . '<!-- sel_fou -->', $recept_form); $recept_form = str_replace('!!i!!', $i, $recept_form); } $recept_form = str_replace('!!f_fou_code!!', $v, $recept_form); $recept_form = str_replace('!!f_fou!!', htmlentities($tab_fou[$v], ENT_QUOTES, $charset), $recept_form); $i++; } } $recept_form = str_replace('!!max_fou!!', $i > 0 ? $i : '1', $recept_form); } if (!$i) { $recept_form = str_replace('!!f_fou_code!!', '0', $recept_form); $recept_form = str_replace('!!f_fou!!', '', $recept_form); $recept_form = str_replace('!!max_fou!!', '1', $recept_form); } //Affichage demandeurs $i = 0; $tab_empr = array(); $tab_user = array(); if (is_array($f_dem_code) && count($f_dem_code) && is_array($t_dem) && count($t_dem)) { foreach ($f_dem_code as $k => $v) { if ($t_dem[$k]) { $tab_empr[] = $v; } else { $tab_user[] = $v; } } $tab_empr = emprunteur::getName($tab_empr); $tab_user = getUserName($tab_user); foreach ($f_dem_code as $k => $v) { if ($v && ($t_dem[$k] === '0' && $tab_user[$v] || $t_dem[$k] === '1' && $tab_empr[$v])) { if ($i > 0) { $recept_form = str_replace('<!-- sel_dem -->', $sel_dem_form . '<!-- sel_dem -->', $recept_form); $recept_form = str_replace('!!i!!', $i, $recept_form); } $recept_form = str_replace('!!f_dem_code!!', $v, $recept_form); $recept_form = str_replace('!!t_dem!!', $t_dem[$k], $recept_form); if ($t_dem[$k]) { $recept_form = str_replace('!!f_dem!!', htmlentities($tab_empr[$v], ENT_QUOTES, $charset), $recept_form); } else { $recept_form = str_replace('!!f_dem!!', htmlentities($tab_user[$v], ENT_QUOTES, $charset), $recept_form); } $i++; } } $recept_form = str_replace('!!max_dem!!', $i > 0 ? $i : '1', $recept_form); } if (!$i) { $recept_form = str_replace('!!f_dem_code!!', '0', $recept_form); $recept_form = str_replace('!!t_dem!!', '0', $recept_form); $recept_form = str_replace('!!f_dem!!', '', $recept_form); $recept_form = str_replace('!!max_dem!!', '1', $recept_form); } //Affichage rubriques budgetaires $i = 0; $tab_rub2 = array(); if (is_array($f_rub_code) && count($f_rub_code)) { $tab_rub = rubriques::getLibelle($f_rub_code, $id_bibli, $id_exer, SESSuserid); foreach ($f_rub_code as $v) { if ($v && $tab_rub[$v]) { $tab_rub2[$v] = $tab_rub[$v]; if ($i > 0) { $recept_form = str_replace('<!-- sel_rub -->', $sel_rub_form . '<!-- sel_rub -->', $recept_form); $recept_form = str_replace('!!i!!', $i, $recept_form); } $recept_form = str_replace('!!f_rub_code!!', $v, $recept_form); $recept_form = str_replace('!!f_rub!!', htmlentities($tab_rub[$v], ENT_QUOTES, $charset), $recept_form); $i++; } } $recept_form = str_replace('!!max_rub!!', $i > 0 ? $i : '1', $recept_form); } if (!$i) { $recept_form = str_replace('!!f_rub_code!!', '0', $recept_form); $recept_form = str_replace('!!f_rub!!', '', $recept_form); $recept_form = str_replace('!!max_rub!!', '1', $recept_form); } //Affichage zone commande if (!isset($chk_dev)) { $chk_dev = TYP_ACT_CDE; } if ($chk_dev) { $recept_form = str_replace('!!dev_checked!!', "checked='checked'", $recept_form); $recept_form = str_replace('!!cde_checked!!', '', $recept_form); } else { $recept_form = str_replace('!!dev_checked!!', '', $recept_form); $recept_form = str_replace('!!cde_checked!!', "checked='checked'", $recept_form); } $recept_form = str_replace('!!cde_query!!', htmlentities(stripslashes($cde_query), ENT_QUOTES, $charset), $recept_form); //Affichage selecteur dates $sel_date_form[0] = str_replace('!!msg!!', htmlentities($msg['acquisition_recept_date'], ENT_QUOTES, $charset), $sel_date_form[0]); if ($date_inf) { $date_inf_lib = formatdate($date_inf); } else { $date_inf_lib = $msg['parperso_nodate']; } $sel_date_form[1] = str_replace('!!date_inf!!', $date_inf, $sel_date_form[1]); $sel_date_form[1] = str_replace('!!date_inf_lib!!', $date_inf_lib, $sel_date_form[1]); if ($date_sup) { $date_sup_lib = formatdate($date_sup); } else { $date_sup_lib = $msg['parperso_nodate']; } $sel_date_form[2] = str_replace('!!date_sup!!', $date_sup, $sel_date_form[2]); $sel_date_form[2] = str_replace('!!date_sup_lib!!', $date_sup_lib, $sel_date_form[2]); $sel_date_form[0] = sprintf($sel_date_form[0], $sel_date_form[1], $sel_date_form[2]); $recept_form = str_replace('<!-- sel_date -->', $sel_date_form[0], $recept_form); //Creation selecteur statut de lignes de commandes if (!(is_array($lgstat_filter) && count($lgstat_filter))) { $lgstat_filter = array(0 => $deflt3lgstatcde); } $sel_lgstat = lgstat::getHtmlSelect($lgstat_filter, FALSE, array('id' => 'lgstat_filter[]', 'name' => 'lgstat_filter[]', 'multiple' => 'multiple', 'size' => '5')); $recept_form = str_replace('<!-- sel_lgstat -->', $sel_lgstat, $recept_form); //Affichage zone tous les champs $recept_form = str_replace('!!all_query!!', htmlentities(stripslashes($all_query), ENT_QUOTES, $charset), $recept_form); //Prise en compte du formulaire de recherche // nombre de références par pages if (!$nb_per_page) { $nb_per_page = 10; } if (!$page) { $page = 1; } $debut = ($page - 1) * $nb_per_page; //La recherche ici $recept = new receptions($id_bibli, $id_exer); //filtre $filtres = $recept->setFiltres(array_keys($tab_fou2), array_keys($tab_empr), array_keys($tab_user), array_keys($tab_rub2), $chk_dev, $cde_query, $lgstat_filter, $date_inf, $date_sup); // comptage if (!$nbr_lignes) { $nbr_lignes = $recept->calcNbLignes($all_query); $err = $recept->getError(); } // liste if ($nbr_lignes) { $t_list = $recept->getLignes(); //Affichage des lignes $recept_form .= $recept_list_form; //Affichage zone de reception $recept_form = str_replace('!!recept_query!!', htmlentities(stripslashes($recept_query), ENT_QUOTES, $charset), $recept_form); $tab_aff = array(); $lgstat_form = lgstat::getHtmlSelect(array(0 => 0), FALSE, array('id' => 'sel_lgstat_!!id_lig!!', 'onchange' => 'recept_upd_lgstat(this.getAttribute("id"));')); $act_form = ''; $i = 1; foreach ($t_list as $id_acte => $t_row) { //Affichage lignes à recevoir foreach ($t_row as $id_ligne => $row) { if (!in_array($id_acte, $tab_aff)) { array_push($tab_aff, $id_acte); $recept_form = str_replace('<!-- actes -->', $act_form . '<!-- actes -->', $recept_form); $act_form = str_replace('!!lib_acte!!', htmlentities($msg['acquisition_recept_fou'], ENT_QUOTES, $charset) . " <a href=\"./acquisition.php?categ=ach&sub=fourn&action=modif&id_bibli=" . $id_bibli . '&id=' . $row['num_fournisseur'] . "\">" . htmlentities($row['raison_sociale'], ENT_QUOTES, $charset) . "</a>" . ' ' . (htmlentities($row['type_acte'] ? $msg['acquisition_act_num_dev'] : $msg['acquisition_act_num_cde'], ENT_QUOTES, $charset) . "<a href=\"./acquisition.php?categ=ach&sub=" . ($row['type_acte'] ? 'devi' : 'cmde') . "&action=modif&id_bibli=" . $id_bibli . ($row['type_acte'] ? '&id_dev=' : '&id_cde=') . $id_acte . "\">" . htmlentities($row['numero'], ENT_QUOTES, $charset) . "</a>") . ' ' . htmlentities($msg['653'], ENT_QUOTES, $charset) . ' ' . formatdate($row['date_acte']), $recept_hrow_form); } $row_form = $recept_row_form; $row_form = str_replace('!!code!!', htmlentities($row['code'], ENT_QUOTES, $charset), $row_form); $row_form = str_replace('!!lib!!', nl2br(htmlentities($row['libelle'], ENT_QUOTES, $charset)), $row_form); $row_form = str_replace('!!qte_cde!!', $row['nb_cde'], $row_form); $row_form = str_replace('!!qte_liv!!', $row['nb_liv'], $row_form); $row_form = str_replace('!!qte_sol!!', $row['nb_sol'], $row_form); $lgstat_row_form = str_replace("value='" . $row['statut'] . "'", "value='" . $row['statut'] . "' selected='selected' ", $lgstat_form); $row_form = str_replace('!!lgstat!!', $lgstat_row_form, $row_form); $row_form = str_replace('!!comment_lg!!', nl2br(htmlentities($row['commentaires_gestion'], ENT_QUOTES, $charset)), $row_form); $row_form = str_replace('!!comment_lo!!', nl2br(htmlentities($row['commentaires_opac'], ENT_QUOTES, $charset)), $row_form); $row_form = str_replace('!!id_lig!!', $id_ligne, $row_form); $row_form = str_replace('!!typ_lig!!', $row['type_ligne'], $row_form); if ($row['num_produit']) { switch ($row['type_ligne']) { case '1': //notice $row_form = str_replace('<!-- link_cat -->', $link_not, $row_form); break; case '2': //bulletin $row_form = str_replace('<!-- link_cat -->', $link_bull, $row_form); break; case '5': //article $id_bull = analysis::getBulletinIdFromAnalysisId($row['num_produit']); if ($id_bull) { $row_form = str_replace('<!-- link_cat -->', $link_art, $row_form); $row_form = str_replace('!!id_bull!!', $id_bull, $row_form); } break; default: break; } } else { $tmp_bt_cat = str_replace('!!id_lig!!', $id_ligne, $bt_cat); $row_form = str_replace('<!-- bt_cat -->', $tmp_bt_cat, $row_form); } if ($row['num_acquisition']) { $row_form = str_replace('<!-- link_sug -->', $link_sug, $row_form); $row_form = str_replace('!!id_sug!!', $row['num_acquisition'], $row_form); } $row_form = str_replace('!!id_prod!!', $row['num_produit'], $row_form); $row_form = str_replace('!!no!!', $i, $row_form); $tab_rel = array(); $tab_rel = lignes_actes::getRelances($id_ligne); $row_form = str_replace('!!nb_relances!!', htmlentities(sprintf($msg['acquisition_recept_hist'], count($tab_rel)), ENT_QUOTES, $charset), $row_form); if (count($tab_rel)) { $row_form = str_replace('<!-- relances -->', implode(' - ', $tab_rel), $row_form); } $act_form = str_replace('<!-- lignes -->', $row_form . '<!-- lignes -->', $act_form); $i++; } } $recept_form = str_replace('<!-- actes -->', $act_form . '<!-- actes -->', $recept_form); $recept_form = str_replace('!!max_no!!', $i * 1 - 1, $recept_form); //Affichage commentaires $recept_form = str_replace('!!comment_lg_all!!', htmlentities(stripslashes($comment_lg_all), ENT_QUOTES, $charset), $recept_form); $recept_form = str_replace('!!comment_lo_all!!', htmlentities(stripslashes($comment_lo_all), ENT_QUOTES, $charset), $recept_form); //boutons $lgstat_all = lgstat::getHtmlSelect(array(0 => 0), $msg['acquisition_recept_lgstat_none'], array('id' => 'sel_lgstat_all', 'name' => 'sel_lgstat_all')); $recept_form = str_replace('<!-- sel_lgstat_all -->', $lgstat_all, $recept_form); $recept_form = str_replace('<!-- bt_app -->', $bt_app, $recept_form); $recept_form = str_replace('<!-- bt_rel -->', $bt_rel, $recept_form); $recept_form = str_replace('<!-- bt_chk -->', $bt_chk, $recept_form); //Barre de navigation /* if (!$last_param) { $nav_bar = aff_pagination ($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true) ; } else { $nav_bar = ""; } $recept_form=str_replace('<!-- nav_bar -->', $nav_bar,$recept_form); */ $recept_form .= $recept_search_form_suite; print $recept_form; } elseif ($err) { //erreur dans la recherche $recept_form .= $recept_search_form_suite; print $recept_form; print $err; } else { // pas de resultat $recept_form .= $recept_search_form_suite; print $recept_form; $cle = array(); if ($cde_query) { $cle[] = htmlentities($msg['acquisition_recept_act_search'] . ' ' . stripslashes($cde_query), ENT_QUOTES, $charset); } if ($all_query) { $cle[] = htmlentities($msg['acquisition_recept_global_search'] . ' ' . stripslashes($all_query), ENT_QUOTES, $charset); } error_message($msg['acquisition_recept_rech'], str_replace('!!cle!!', implode(',', $cle), $msg['acquisition_recept_rech_error']), 0); } }