function delete_analysis() { global $dbh, $pmb_archive_warehouse; if ($this->bulletin_id) { $requete = "SELECT analysis_notice FROM analysis WHERE analysis_bulletin=" . $this->bulletin_id; $myQuery2 = pmb_mysql_query($requete, $dbh); while ($dep = pmb_mysql_fetch_object($myQuery2)) { $ana = new analysis($dep->analysis_notice); if ($pmb_archive_warehouse) { analysis::save_to_agnostic_warehouse(array(0 => $dep->analysis_notice), $pmb_archive_warehouse); } $ana->analysis_delete(); } } }
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; }
public function pageanalysis() { $this->load->library('Analysis'); $this->load->library('Extractor'); $urlcheck = $this->input->post('urlcheck', TRUE); var_dump($urlcheck); if (empty($urlcheck)) { $this->template->title($this->module_details['name'])->append_css('module::style.css')->build('admin/pageanalysis'); } else { define('GOOGLE_MAGIC', 0.0); if (strtolower($urlcheck) == "http://") { } else { if (!preg_match('/^(http|https|ftp):\\/\\/([A-Z0-9][A-Z0-9_-]*(?:\\.[A-Z0-9][A-Z0-9_-]*)+):?(\\d+)?\\/?/i', $urlcheck)) { ?> <div class="errorurl" style="width: 395px"> <strong class="redb">ERROR: Please Provide proper URL to index the page.</strong><br /><br /> Kindly Provide a proper URL. <br /><br />The <b>Format of URL should be:</b> <br />http://www.example.com, or<br />http://www.example.com/sample-page.php, or<br />http://subdomain.example.com/sub-directory/sample-page.php,<br />or similar to the above formats. </div> <?php } else { $url = str_replace('http://', '', $urlcheck); $url = 'http://' . $url; $meta = new analysis(); $res = $meta->getValues($url); $ext = new extractor($url); $links = $ext->ExtractLinks(''); $res['links'] = $ext->links; } } $pch = url_exists($urlcheck); // var_dump($pch); $this->template->title($this->module_details['name'])->append_css('module::style.css')->build('admin/pageanalysisresult'); } }
$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 analysis_delete() { global $dbh; global $pmb_synchro_rdf, $pmb_notice_img_folder_id; //Suppression de la vignette de la notice si il y en a une d'uploadée if ($pmb_notice_img_folder_id) { $req = "select repertoire_path from upload_repertoire where repertoire_id ='" . $pmb_notice_img_folder_id . "'"; $res = pmb_mysql_query($req, $dbh); if (pmb_mysql_num_rows($res)) { $rep = pmb_mysql_fetch_object($res); $img = $rep->repertoire_path . "img_" . $this->analysis_id; @unlink($img); } } //synchro rdf if ($pmb_synchro_rdf) { $synchro_rdf = new synchro_rdf(); $synchro_rdf->delRdf($this->analysis_id, 0); } //elimination des docs numeriques $req_explNum = "select explnum_id from explnum where explnum_notice=" . $this->analysis_id . " "; $result_explNum = @pmb_mysql_query($req_explNum, $dbh); while ($explNum = pmb_mysql_fetch_object($result_explNum)) { $myExplNum = new explnum($explNum->explnum_id); $myExplNum->delete(); } // suppression des entrees dans les caddies $query_caddie = "select caddie_id from caddie_content, caddie where type='NOTI' and object_id in ({$this->analysis_id}) and caddie_id=idcaddie "; $result_caddie = @pmb_mysql_query($query_caddie, $dbh); while ($cad = pmb_mysql_fetch_object($result_caddie)) { $req_suppr_caddie = "delete from caddie_content where caddie_id = '{$cad->caddie_id}' and object_id in ({$this->analysis_id}) "; @pmb_mysql_query($req_suppr_caddie, $dbh); } //elimination des champs persos $p_perso = new parametres_perso("notices"); $p_perso->delete_values($this->analysis_id); // on supprime l'entree dans la table 'analysis' $requete = "DELETE FROM analysis WHERE analysis_notice=" . $this->analysis_id; pmb_mysql_query($requete, $dbh); $result = pmb_mysql_affected_rows($dbh); // on supprime la notice du dépouillement $requete = "DELETE FROM notices WHERE notice_id='" . $this->analysis_id . "' "; pmb_mysql_query($requete, $dbh); $result += pmb_mysql_affected_rows($dbh); //suppression des droits d'acces user_notice $requete = "delete from acces_res_1 where res_num=" . $this->analysis_id; @pmb_mysql_query($requete, $dbh); //suppression des droits d'acces empr_notice $requete = "delete from acces_res_2 where res_num=" . $this->analysis_id; @pmb_mysql_query($requete, $dbh); // suppression des audits audit::delete_audit(AUDIT_NOTICE, $this->analysis_id); // suppression des categories $rqt_del = "delete from notices_categories where notcateg_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($rqt_del, $dbh); // Clean des vedettes analysis::delete_vedette_links($this->analysis_id); // suppression des responsabilités $rqt_del = "delete from responsability where responsability_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($rqt_del, $dbh); // suppression des liens $rqt_del = "delete from notices_relations where num_notice='" . $this->analysis_id . "' OR linked_notice='" . $this->analysis_id . "'"; @pmb_mysql_query($rqt_del, $dbh); // suppression des bannettes $rqt_del = "delete from bannette_contenu where num_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($rqt_del, $dbh); // suppression des tags $rqt_del = "delete from tags where num_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($rqt_del, $dbh); // suppression des avis $rqt_del = "delete from avis where num_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($rqt_del, $dbh); //suppression des langues $query = "delete from notices_langues where num_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($query, $dbh); // suppression index global $query = "delete from notices_global_index where num_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($query, $dbh); // suppression notices_mots_global_index $query = "delete from notices_mots_global_index where id_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($query, $dbh); // suppression notices_fields_global_index $query = "delete from notices_fields_global_index where id_notice='" . $this->analysis_id . "' "; @pmb_mysql_query($query, $dbh); //Suppression de la reference a la notice dans la table suggestions $query = "UPDATE suggestions set num_notice = 0 where num_notice=" . $this->analysis_id; @pmb_mysql_query($query, $dbh); //Suppression de la reference a la notice dans la table lignes_actes $requete = "UPDATE lignes_actes set num_produit=0, type_ligne=0 where num_produit='" . $this->analysis_id . "' and type_ligne in ('1','5') "; @pmb_mysql_query($requete, $dbh); //Suppression de la référence de la source si exitante.. $query = "delete from notices_externes where num_notice=" . $this->analysis_id; @pmb_mysql_query($query, $dbh); //Suppression dans les listes de lecture partagées $requete = "SELECT id_liste, notices_associees from opac_liste_lecture"; $res = pmb_mysql_query($requete, $dbh); $id_tab = array(); while ($notices = pmb_mysql_fetch_object($res)) { $id_tab = explode(',', $notices->notices_associees); for ($i = 0; $i < sizeof($id_tab); $i++) { if ($id_tab[$i] == $this->analysis_id) { unset($id_tab[$i]); } } $requete = "UPDATE opac_liste_lecture set notices_associees='" . addslashes(implode(',', $id_tab)) . "' where id_liste='" . $notices->id_liste . "'"; pmb_mysql_query($requete, $dbh); } $req = "delete from notices_authperso where notice_authperso_notice_num=" . $id; pmb_mysql_query($req, $dbh); return $result; }
$acces_m = 1; if ($gestion_acces_active == 1 && $gestion_acces_user_notice == 1) { require_once "{$class_path}/acces.class.php"; $ac = new acces(); $dom_1 = $ac->setDomain(1); $acces_j = $dom_1->getJoin($PMBuserid, 8, 'bulletin_notice'); $q = "select count(1) from bulletins {$acces_j} where bulletin_id=" . $bul_id; $r = mysql_query($q, $dbh); if (mysql_result($r, 0, 0) == 0) { $acces_m = 0; } } if ($acces_m == 0) { error_message('', htmlentities($dom_1->getComment('mod_bull_error'), ENT_QUOTES, $charset), 1, ''); } else { // script de suppression d'un dépouillement de périodique // mise à jour de l'entête de page echo str_replace('!!page_title!!', $msg[4000] . $msg[1003] . $msg[4023], $serial_header); $myAnalysis = new analysis($analysis_id, $bul_id); if ($pmb_archive_warehouse) { analysis::save_to_agnostic_warehouse(array(0 => $analysis_id), $pmb_archive_warehouse); } $result = $myAnalysis->analysis_delete(); if ($result) { $retour = "./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=" . $myAnalysis->bulletin_id; print "<div class=\"row\"><div class=\"msg-perio\" size=\"+2\">" . $msg['catalog_notices_suppression'] . "</div></div>"; print "\n\t\t\t<form class='form-{$current_module}' name=\"dummy\" method=\"post\" action=\"{$retour}\" style=\"display:none\">\n\t\t\t\t<input type=\"hidden\" name=\"id_form\" value=\"{$id_form}\">\n\t\t\t</form>\n\t\t\t<script type=\"text/javascript\">document.dummy.submit();</script>\n\t\t\t"; } else { error_message($msg['catalog_serie_supp_depouill'], $msg['catalog_serie_supp_depouill_imp'], 1, "./catalog.php?categ=serials&sub=bulletinage&action=view&serial_id={$serial_id}&bul_id={$bul_id}"); } }
echo str_replace('!!page_title!!', $msg['4000'] . $msg['1003'] . $msg['analysis_move'], $serial_header); // on instancie le truc $myAnalysis = new analysis($analysis_id, $bul_id); $myBul = new bulletinage($bul_id); // lien vers la notice chapeau $link_parent = "<a href=\"./catalog.php?categ=serials\">"; $link_parent .= $msg[4010] . "</a>"; $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">"; $link_parent .= "<a href=\"./catalog.php?categ=serials&sub=view&serial_id="; $link_parent .= $myBul->bulletin_notice . "\">" . $myBul->tit1 . '</a>'; $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">"; $link_parent .= "<a href=\"./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id={$bul_id}\">"; if ($myBul->bulletin_numero) { $link_parent .= $myBul->bulletin_numero . " "; } if ($myBul->mention_date) { $link_parent .= " (" . $myBul->mention_date . ") "; } $link_parent .= "[" . $myBul->aff_date_date . "]"; $link_parent .= "</a> <img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">"; $link_parent .= "<h3>" . $myAnalysis->analysis_tit1 . "</h3>"; print pmb_bidi("<div class='row'><div class='perio-barre'>" . $link_parent . "</div></div><br />"); print "<div class='row'>" . $myAnalysis->move_form() . "</div>"; } else { // routine de déplacmeent $myAnalysis = new analysis($analysis_id, $bul_id); $myAnalysis->move($to_bul); print pmb_bidi("<script type=\"text/javascript\">document.location='./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=" . $to_bul . "'</script>"); //Redirection } }
if ($acces_m == 0) { if (!$analysis_id) { error_message('', htmlentities($dom_1->getComment('mod_bull_error'), ENT_QUOTES, $charset), 1, ''); } else { error_message('', htmlentities($dom_1->getComment('mod_depo_error'), ENT_QUOTES, $charset), 1, ''); } } else { // affichage d'un form pour création, modification d'un article de périodique if (!$analysis_id) { // pas d'id, c'est une création echo str_replace('!!page_title!!', $msg[4000] . $msg[1003] . $msg[4022], $serial_header); } else { echo str_replace('!!page_title!!', $msg[4000] . $msg[1003] . $msg[analysis_duplicate], $serial_header); } // on instancie le truc $myAnalysis = new analysis($analysis_id, $bul_id); $myAnalysis->analysis_id = 0; $myAnalysis->duplicate_from_id = $analysis_id; $myBul = new bulletinage($bul_id); // lien vers la notice chapeau $link_parent = "<a href=\"./catalog.php?categ=serials\">"; $link_parent .= $msg[4010] . "</a>"; $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">"; $link_parent .= "<a href=\"./catalog.php?categ=serials&sub=view&serial_id="; $link_parent .= $myBul->bulletin_notice . "\">" . $myBul->tit1 . '</a>'; $link_parent .= "<img src=\"./images/d.gif\" align=\"middle\" hspace=\"5\">"; $link_parent .= "<a href=\"./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id={$bul_id}\">"; if ($myBul->bulletin_numero) { $link_parent .= $myBul->bulletin_numero . " "; } if ($myBul->mention_date) {
$req_notice_date_is_new = ", notice_date_is_new =now() "; } else { // raz date $req_notice_date_is_new = ", notice_date_is_new ='' "; } } } } else { if ($f_notice_is_new) { // flag affecté comme new en création $req_notice_date_is_new = ", notice_date_is_new =now() "; } } $table['notice_is_new'] = $f_notice_is_new + 0; if (!$nberrors) { $myAnalysis = new analysis($analysis_id, $bul_id); $result = $myAnalysis->analysis_update($table, $req_notice_date_is_new); } else { error_message_history($msg["notice_champs_perso"], $p_perso->error_message, 1); exit; } if ($id_sug && $result) { $req_sug = "update suggestions set num_notice='" . $result . "' where id_suggestion='" . $id_sug . "'"; pmb_mysql_query($req_sug, $dbh); } if ($result) { //Traitement des liens $requete = "DELETE FROM notices_relations WHERE num_notice='{$result}' OR linked_notice='{$result}'"; pmb_mysql_query($requete); for ($i = 0; $i < $max_rel; $i++) { $f_rel = "f_rel_type_" . $i;
$synchro_rdf->addRdf($serial_id, 0); } } //Bulletin if ($bull_type == 'insert_new' && !$bul_id) { $req = "insert into bulletins set bulletin_numero='" . $f_bull_new_num . "',\n\t\t\t mention_date='" . $f_bull_new_mention . "',\n\t\t\t date_date='" . $f_bull_new_date . "',\n\t\t\t bulletin_titre='" . $f_bull_new_titre . "',\n\t\t\t bulletin_notice='" . $serial_id . "'"; mysql_query($req, $dbh); $bul_id = mysql_insert_id(); if ($pmb_synchro_rdf) { $synchro_rdf->addRdf(0, $bul_id); } } $table['serial_id'] = $serial_id; $table['bul_id'] = $bul_id; if (!$nberrors) { $myAnalysis = new analysis($analysis_id, $bul_id); $result = $myAnalysis->analysis_update($table); } else { error_message_history($msg["notice_champs_perso"], $p_perso->error_message, 1); exit; } if ($id_sug && $result) { $req_sug = "update suggestions set num_notice='" . $result . "' where id_suggestion='" . $id_sug . "'"; mysql_query($req_sug, $dbh); } if ($result) { //Traitement des liens $requete = "DELETE FROM notices_relations WHERE num_notice='{$result}' OR linked_notice='{$result}'"; mysql_query($requete); for ($i = 0; $i < $max_rel; $i++) { $f_rel = "f_rel_type_" . $i;
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); } }