"; $lien_last_sug = ""; $sug_search_form = str_replace('!!form_title!!', $titre, $sug_search_form); $sug_search_form = str_replace('!!action!!', $action, $sug_search_form); $sug_search_form = str_replace('', $sug_map->getStateSelector(), $sug_search_form); $sug_search_form = str_replace('', $bouton_add, $sug_search_form); $sug_search_form = str_replace('', $lien_last_sug, $sug_search_form); //Selecteur de localisation $list_locs=''; if ($acquisition_sugg_localises) { if ($sugg_location_id) $temp_location=$sugg_location_id; else $temp_location=0; $locs=new docs_location(); $list_locs=$locs->gen_combo_box_sugg($temp_location,1,"submit();"); } $sug_search_form = str_replace('', $list_locs, $sug_search_form); //Selecteur de categories if ($acquisition_sugg_categ != '1') { $sel_categ=""; } else { $tab_categ = suggestions_categ::getCategList(); $sel_categ = ""; } $sug_search_form = str_replace('', $sel_categ, $sug_search_form); //Affichage du filtre par source $req = "select * from suggestions_source order by libelle_source"; $res= pmb_mysql_query($req,$dbh); $selected =""; $option = ""; while(($src=pmb_mysql_fetch_object($res))){ ($src->id_source == $filtre_src) ? $selected = "selected" : $selected=""; $option .= ""; } $selecteur = " "; $sug_search_form = str_replace('!!sug_filtre_src!!',$selecteur, $sug_search_form); //Affichage origine $i=0; if (is_array($user_id) && count($user_id) && is_array($user_statut) && count($user_statut)) { foreach($user_id as $k=>$v) { if ($v) { $user_name = $user_txt[$k]; if(!$user_txt[$k]){ if ($user_statut[$k]==='0') { $req = "select nom, prenom from users where userid='".$v."'"; $res = pmb_mysql_query($req,$dbh); $user = pmb_mysql_fetch_object($res); $user_name = $user->nom.($user->prenom ? ", ".$user->prenom : ""); } else { $req = "select concat(empr_nom,', ',empr_prenom) as nom from empr where id_empr='".$v."'"; $res = pmb_mysql_query($req,$dbh); $empr = pmb_mysql_fetch_object($res); $user_name = $empr->nom; } } if($i>0) { $sug_search_form=str_replace('',$sel_orig_form.'',$sug_search_form); $sug_search_form=str_replace('!!i!!',$i,$sug_search_form); } $sug_search_form = str_replace('!!user_txt!!',htmlentities($user_name,ENT_QUOTES,$charset), $sug_search_form); $sug_search_form = str_replace('!!user_id!!',htmlentities($v,ENT_QUOTES,$charset), $sug_search_form); $sug_search_form = str_replace('!!user_statut!!',htmlentities($user_statut[$k],ENT_QUOTES,$charset), $sug_search_form); $i++; } } $sug_search_form=str_replace('!!max_orig!!',$i,$sug_search_form); } if (!$i) { $sug_search_form=str_replace('!!user_id!!','',$sug_search_form); $sug_search_form=str_replace('!!user_statut!!','',$sug_search_form); $sug_search_form=str_replace('!!user_txt!!','',$sug_search_form); $sug_search_form=str_replace('!!max_orig!!','1',$sug_search_form); } $sug_search_form = str_replace('!!user_input!!',htmlentities($user_input,ENT_QUOTES,$charset), $sug_search_form); //Affichage selecteur dates $sel_date_form[0] = str_replace('!!msg!!', htmlentities($msg['acquisition_sugg_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]); $sug_search_form = str_replace('!!sel_date!!', $sel_date_form[0], $sug_search_form); print $sug_search_form; //Affiche par defaut toutes les categories de suggestions if ($acquisition_sugg_categ != '1') { $num_categ = "-1"; } else { if (!$num_categ) $num_categ = '-1'; print ""; } if (!$statut) { $statut = getSessionSugState(); //Recuperation du statut courant } else { setSessionSugState($statut); } print ""; //Prise en compte du formulaire de recherche $mask=$sug_map->getMask_FILED(); // traitement de la saisie utilisateur require_once($class_path."/analyse_query.class.php"); //comptage if(!$nbr_lignes) { if(!$user_input) { $nbr_lignes = suggestions::getNbSuggestions($id_bibli, $statut, $num_categ, $mask ,0,$sugg_location_id,'',$filtre_src,$user_id,$user_statut,$date_inf,$date_sup); } else { $aq=new analyse_query(stripslashes($user_input),0,0,0,0); if ($aq->error) { error_message($msg["searcher_syntax_error"],sprintf($msg["searcher_syntax_error_desc"],$aq->current_car,$aq->input_html,$aq->error_message)); exit; } $nbr_lignes = suggestions::getNbSuggestions($id_bibli, $statut, $num_categ, $mask, $aq,$sugg_location_id, $user_input,$filtre_src,$user_id,$user_statut,$date_inf,$date_sup); } } else { $aq=new analyse_query(stripslashes($user_input),0,0,0,0); } if(!$page) $page=1; $debut =($page-1)*$nb_per_page; if($nbr_lignes) { $url_base = "acquisition.php?categ=sug&action=list&id_bibli=$id_bibli&user_input=".rawurlencode(stripslashes($user_input))."&statut=$statut&num_categ=$num_categ&sugg_location_id=$sugg_location_id&filtre_src=$filtre_src&date_inf=$date_inf&date_sup=$date_sup"; if (is_array($user_id) && count($user_id) && is_array($user_statut) && count($user_statut)) { foreach($user_id as $k=>$v) { if ($v && (isset($user_statut[$k]))) { $url_base.="&user_id[]=".$v."&user_statut[]=".$user_statut[$k]; } } }else{ $url_base.="&user_id=".$user_id."&user_statut=".$user_statut; } //affichage if(!$user_input) { $q = suggestions::listSuggestions($id_bibli, $statut, $num_categ, $mask, $debut, $nb_per_page,0,'',$sugg_location_id,'', $filtre_src, $user_id, $user_statut, $date_inf, $date_sup); } else { $q = suggestions::listSuggestions($id_bibli, $statut, $num_categ, $mask, $debut, $nb_per_page, $aq,'',$sugg_location_id, $user_input, $filtre_src, $user_id, $user_statut, $date_inf, $date_sup); } $res = pmb_mysql_query($q, $dbh); //Affichage liste des suggestions $nbr = pmb_mysql_num_rows($res); $aff_row=""; $parity=1; for($i=0;$i<$nbr;$i++) { $row=pmb_mysql_fetch_object($res); //recuperation origine $lib_orig = ""; $typ_orig = "0"; $q = suggestions_origine::listOccurences($row->id_suggestion, '1'); $list_orig = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($list_orig)) { $row_orig = pmb_mysql_fetch_object($list_orig); $orig = $row_orig->origine; $typ_orig = $row_orig->type_origine; } //d'autres origines ? $q2 = suggestions_origine::listOccurences($row->id_suggestion); $list_orig2 = pmb_mysql_query($q2, $dbh); $orig_plus = ""; if (pmb_mysql_num_rows($list_orig2)>1) { $orig_plus_array = array(); while($row_orig2 = pmb_mysql_fetch_object($list_orig2)){ if (($row_orig2->origine!==$orig) || ($row_orig2->type_origine!==$typ_orig)) { switch($row_orig2->type_origine){ default: case '0' : $requete_user = "SELECT userid, nom, prenom FROM users where userid = '".$row_orig2->origine."' limit 1 "; $res_user = pmb_mysql_query($requete_user, $dbh); $row_user=pmb_mysql_fetch_row($res_user); $lib_orig_array = $row_user[1]; if ($row_user[2]) $lib_orig_array.= ", ".$row_user[2]; break; case '1' : $requete_empr = "SELECT id_empr, empr_nom, empr_prenom, empr_adr1 FROM empr where id_empr = '".$row_orig2->origine."' limit 1 "; $res_empr = pmb_mysql_query($requete_empr, $dbh); $row_empr=pmb_mysql_fetch_row($res_empr); $lib_orig_array = $row_empr[1]; if ($row_empr[2]) $lib_orig_array.= ", ".$row_empr[2]; break; case '2' : $lib_orig_array = $row_orig2->origine; break; } $orig_plus_array[] = htmlentities($lib_orig_array, ENT_QUOTES, $charset); } } $orig_plus = " (+)"; } //Récupération du nom du créateur de la suggestion $idempr = 0; switch($typ_orig){ default: case '0' : $requete_user = "SELECT userid, nom, prenom FROM users where userid = '".$orig."' limit 1 "; $res_user = pmb_mysql_query($requete_user, $dbh); $row_user=pmb_mysql_fetch_row($res_user); $lib_orig = $row_user[1]; if ($row_user[2]) $lib_orig.= ", ".$row_user[2]; break; case '1' : $requete_empr = "SELECT id_empr, empr_nom, empr_prenom, empr_adr1 FROM empr where id_empr = '".$orig."' limit 1 "; $res_empr = pmb_mysql_query($requete_empr, $dbh); $row_empr=pmb_mysql_fetch_row($res_empr); $lib_orig = $row_empr[1]; if ($row_empr[2]) $lib_orig.= ", ".$row_empr[2]; $idempr = $row_empr[0]; break; case '2' : $lib_orig = $orig; break; } $lib_statut=$sug_map->getHtmlComment($row->statut); $col2=""; if (trim($row->code)!="") $col2=htmlentities(trim($row->code), ENT_QUOTES, $charset)."
"; $col2.=htmlentities(trim($row->titre), ENT_QUOTES, $charset); $col3=""; $col30=""; $col31=""; if (trim($row->auteur)!="") $col30=htmlentities(trim($row->auteur), ENT_QUOTES, $charset); if (trim($row->editeur)!="") $col31 ="[".htmlentities(trim($row->editeur), ENT_QUOTES, $charset)."]"; $col3=$col30; if ($col3!="" && $col31!="") $col3.="
"; $col3.=$col31; if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript_l1 = "onmouseover=\"this.className='surbrillance';this.parentNode.rows[this.rowIndex+1].className='surbrillance';\" onmouseout=\"this.className='".$pair_impair."';this.parentNode.rows[this.rowIndex+1].className='".$pair_impair."'\" "; $tr_javascript_l2 = "onmouseover=\"this.className='surbrillance';this.parentNode.rows[this.rowIndex-1].className='surbrillance';\" onmouseout=\"this.className='".$pair_impair."';this.parentNode.rows[this.rowIndex-1].className='".$pair_impair."'\" "; $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=sug&action=modif&id_bibli=".$id_bibli."&id_sug=".$row->id_suggestion."' \" "; if($idempr) { $link_empr = ""; $link_empr_fin = ""; } else { $link_empr=""; $link_empr_fin=""; } $aff_row.= " ".formatdate($row->date_creation)."
".$link_empr.htmlentities($lib_orig, ENT_QUOTES, $charset).$link_empr_fin.($orig_plus?$orig_plus:"")." ".$col2." ".$col3." ".htmlentities($row->nb, ENT_QUOTES, $charset)." ".htmlentities($row->prix, ENT_QUOTES, $charset)." $lib_statut"; if(!$row->num_notice) { $aff_row.=""; } else { $req_ana = "select analysis_bulletin as bull , analysis_notice as noti from analysis where analysis_notice ='".$row->num_notice."'"; $res_ana = pmb_mysql_query($req_ana,$dbh); $num_rows_ana = pmb_mysql_num_rows($res_ana); if($num_rows_ana){ $ana = pmb_mysql_fetch_object($res_ana); $url_view = analysis::get_permalink($ana->noti, $ana->bull); } else $url_view = notice::get_permalink($row->num_notice); $aff_row.="\"".$msg['acquisition_sug_view_not']."\""; } $sug_src = new suggestion_source($row->sugg_source); if ($acquisition_sugg_categ == '1') { $categ = new suggestions_categ($row->num_categ); $aff_row.="".htmlentities($categ->libelle_categ, ENT_QUOTES, $charset)."
".htmlentities($sug_src->libelle_source, ENT_QUOTES, $charset).""; $colspan='10'; } else { $aff_row.="".htmlentities($sug_src->libelle_source, ENT_QUOTES, $charset).""; $colspan='9'; } $sug = new suggestions($row->id_suggestion); $img_pj = "get_explnum('id')."\" target=\"_blank\">"; $img_import = "get_explnum('id')." \">"; $aff_row .="".($sug->get_explnum('id') ? "$img_pj $img_import" : '' ).""; $aff_row.= " "; $aff_row.=" ".htmlentities($row->commentaires, ENT_QUOTES, $charset).($row->commentaires_gestion?"
".htmlentities($row->commentaires_gestion, ENT_QUOTES, $charset):"")." "; } $sug_list_form = str_replace('',$aff_row, $sug_list_form); //Affichage des boutons //Bouton Imprimer $imp = "openPopUp('./pdf.php?pdfdoc=listsug&user_input=".urlencode(stripslashes($user_input))."&statut=".$statut."&num_categ=".$num_categ."&sugg_location_id=".$sugg_location_id."' ,'print_PDF');" ; $bt_imp = str_replace('!!imp!!', $imp, $bt_imp); $sug_list_form=str_replace('', $bt_imp,$sug_list_form); //Génération de la liste des conversions possibles $catalog=_parser_text_no_function_(file_get_contents($base_path."/admin/convert/imports/catalog.xml"),"CATALOG"); $list_export=""; $bt_exporter=str_replace("",$list_export,$bt_exporter); $link_export="document.sug_list_form.action='acquisition.php?categ=sug&sub=export'; document.sug_list_form.submit();"; $bt_exporter=str_replace("!!exp!!",$link_export,$bt_exporter); $sug_list_form=str_replace('', $bt_exporter,$sug_list_form); //Bouton Sélectionner $sug_list_form=str_replace('', $bt_chk,$sug_list_form); //Liste Boutons $button_list=$sug_map->getButtonList($statut); $sug_list_form = str_replace('', $button_list,$sug_list_form); //Bouton Reprendre $bt_todo=$sug_map->getButtonList_TODO($statut); $sug_list_form=str_replace('', $bt_todo,$sug_list_form); if ($acquisition_sugg_categ == '1' ) { //Selecteur Affecter a une categorie $to_categ=$sug_map->getCategModifier($statut, $num_categ, $nb_per_page); } else { $to_categ = ""; } $sug_list_form=str_replace('', $to_categ,$sug_list_form); //Bouton Supprimer $button_sup = $sug_map->getButtonList_DELETED($statut); $sug_list_form = str_replace('', $button_sup, $sug_list_form); //JavaScript $script_list = $sug_map->getScriptList($statut,$num_categ,$nb_per_page); $script = str_replace('', $script_list, $script); $sug_list_form=str_replace('', $script,$sug_list_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 = ""; } $sug_list_form=str_replace('', $nav_bar,$sug_list_form); print $sug_list_form; } else { // la requête n'a produit aucun résultat error_message($msg['acquisition_sug_rech'], str_replace('!!sug_cle!!', stripslashes($user_input), $msg['acquisition_sug_rech_error']), 0, './categ=sug&sub=todo&action=list&id_bibli='.$id_bibli); } } //Affiche le formulaire de modification de suggestion function show_form_sug($update_action) { global $dbh, $msg, $charset; global $id_bibli, $id_sug; global $sug_map; global $sug_modif_form; global $acquisition_poids_sugg, $lk_url_sug; global $acquisition_sugg_categ, $acquisition_sugg_categ_default; global $orig_form_mod; global $orig_champ_modif; global $id_notice; global $acquisition_sugg_localises; global $deflt_docs_location; global $sugg_location_id; global $javascript_path; $form = $sug_modif_form; //Récupération des pondérations de suggestions $tab_poids = explode(",", $acquisition_poids_sugg); $tab_poids[0] = substr($tab_poids[0], 2); //utilisateur $tab_poids[1] = substr($tab_poids[1], 2); //abonné $tab_poids[2] = substr($tab_poids[2], 2); //visiteur if(!$id_sug) { //Création de suggestion $titre = htmlentities($msg['acquisition_sug_cre'], ENT_QUOTES, $charset); //Récupération de l'utilisateur $requete_user = "SELECT userid, nom, prenom FROM users where username='".SESSlogin."' limit 1 "; $res_user = pmb_mysql_query($requete_user, $dbh); $row_user=pmb_mysql_fetch_row($res_user); $orig = $row_user[0]; $lib_orig = $row_user[1]; if ($row_user[2]) $lib_orig.= ", ".$row_user[2]; $form = str_replace('!!lib_orig!!', $orig_form_mod, $form); $form = str_replace('!!dat_cre!!', formatdate(today()), $form); $form = str_replace('!!orig!!', $orig, $form); $form = str_replace('!!lib_orig!!', htmlentities($lib_orig, ENT_QUOTES, $charset), $form); $form = str_replace('!!typ!!', '0', $form); $form = str_replace('!!poi!!', $tab_poids[0], $form); $form = str_replace('!!poi_tot!!', $tab_poids[0], $form); $statut = $sug_map->getFirstStateId(); $form = str_replace('!!statut!!', $statut, $form); $form = str_replace('!!lib_statut!!', $sug_map->getHtmlComment($statut), $form); $form = str_replace('!!list_user!!', '', $form); $form = str_replace('!!creator_ajout!!', '', $form); $form = str_replace('!!lien!!', '', $form); if ($acquisition_sugg_categ != '1') { $sel_categ=""; } else { if (suggestions_categ::exists($acquisition_sugg_categ_default)) { $sugg_categ = new suggestions_categ($acquisition_sugg_categ_default); } else { $sugg_categ = new suggestions_categ('1'); } $tab_categ = suggestions_categ::getCategList(); $sel_categ = ""; } $form = str_replace('!!nombre_expl!!', '1', $form); $list_locs=''; if ($acquisition_sugg_localises) { $sugg_location_id=((string)$sugg_location_id==""?$deflt_docs_location:$sugg_location_id); if ($sugg_location_id) $temp_location=$sugg_location_id; else $temp_location=0; $locs=new docs_location(); $list_locs=$locs->gen_combo_box_sugg($temp_location,1,""); } $form = str_replace('', $list_locs, $form); // si suggestion concernant une notice avec $id_notice en parametre, on pre-rempli les champs if($id_notice) { $notice=new notice($id_notice); $tit=htmlentities($notice->tit1,ENT_QUOTES, $charset); $edi=htmlentities($notice->ed1,ENT_QUOTES, $charset); $prix=$notice->prix; $cod=$notice->code; $year=$notice->year; $url_sug=$notice->lien; $as = array_search ("0", $notice->responsabilites["responsabilites"]) ; if ($as!== FALSE && $as!== NULL) { $auteur_0 = $notice->responsabilites["auteurs"][$as] ; $auteur = new auteur($auteur_0["id"]); } $aut=htmlentities($auteur->display,ENT_QUOTES, $charset); $form = str_replace('!!id_notice!!', $id_notice, $form); } else { $form = str_replace('!!id_notice!!', 0, $form); } $form = str_replace('!!categ!!', $sel_categ, $form); $form = str_replace('!!tit!!', $tit, $form); $form = str_replace('!!edi!!', $edi, $form); $form = str_replace('!!aut!!', $aut, $form); $form = str_replace('!!cod!!', $cod, $form); $form = str_replace('!!pri!!', $prix, $form); $form = str_replace('!!com!!', '', $form); $form = str_replace('!!com_gestion!!', '', $form); $form = str_replace('!!url_sug!!', $url_sug, $form); //Affichage du selecteur de source $req = "select * from suggestions_source order by libelle_source"; $res= pmb_mysql_query($req,$dbh); $option = ""; while(($src=pmb_mysql_fetch_object($res))){ $option .= ""; $selected=""; } $selecteur = ""; $form = str_replace('!!liste_source!!',$selecteur, $form); $form = str_replace('!!date_publi!!',$year, $form); $pj = "
"; $form= str_replace('!!div_pj!!',$pj, $form); } else { //Modification de suggestion $titre = htmlentities($msg['acquisition_sug_mod'], ENT_QUOTES, $charset); $sug = new suggestions($id_sug); $q = suggestions_origine::listOccurences($id_sug); $list_orig = pmb_mysql_query($q, $dbh); $orig = 0; $poids_tot = 0; $users = array(); while(($row_orig = pmb_mysql_fetch_object($list_orig))) { if (!$orig) { $orig = $row_orig->origine; $typ = $row_orig->type_origine; $poids = $tab_poids[$row_orig->type_origine]; } $users[] = $row_orig; $poids_tot = $poids_tot + $tab_poids[$row_orig->type_origine]; } //On parcourt tous les créateurs de suggestions $nb_users = count($users); for ($i = 0; $i < $nb_users; $i++) { $orig = $users[$i]->origine; $typ = $users[$i]->type_origine; //Récupération du nom du créateur de la suggestion switch($typ){ default: case '0' : $requete_user = "SELECT userid, nom, prenom FROM users where userid = '".$orig."'"; $res_user = pmb_mysql_query($requete_user, $dbh); $row_user=pmb_mysql_fetch_row($res_user); $lib_orig = $row_user[1]; if ($row_user[2]) $lib_orig.= ", ".$row_user[2]; if(empty($premier_user) || !isset($premier_user)) $premier_user = $lib_orig; else $list_user .= $lib_orig."
"; break; case '1' : $requete_empr = "SELECT id_empr, empr_nom, empr_prenom FROM empr where id_empr = '".$orig."'"; $res_empr = pmb_mysql_query($requete_empr, $dbh); $row_empr=pmb_mysql_fetch_row($res_empr); $lib_orig = $row_empr[1]; if ($row_empr[2]) $lib_orig.= ", ".$row_empr[2]; if(empty($premier_user) || !isset($premier_user)) $premier_user = $lib_orig; else $list_user .= $lib_orig."
"; break; case '2' : if($orig) $lib_orig = $orig; else $lib_orig = $msg['suggest_anonyme']; if(empty($premier_user) || !isset($premier_user)) $premier_user = $lib_orig; else $list_user .= $lib_orig."
"; break; } } //Récupération du statut de la suggestion $lib_statut=$sug_map->getHtmlComment($sug->statut); $form = str_replace('!!dat_cre!!', formatdate($sug->date_creation), $form); $form = str_replace('!!orig!!', $orig, $form); //Ajout du champ de saisie du nouveau créateur $ajout_create = " "; if ($nb_users > 1) { //on ajoute le champ à la liste $list_user.=$ajout_create; $form = str_replace('!!creator_ajout!!', '', $form); } else $form = str_replace('!!creator_ajout!!', "
".$ajout_create, $form); //Menu dépliant $deroul_user = gen_plus('ori',$msg['suggest_creator']. " (".($nb_users-1).")", $list_user, 0); if ($lib_orig) { $form = str_replace('!!lib_orig!!', htmlentities($premier_user, ENT_QUOTES, $charset), $form); if ($nb_users > 1) { $form = str_replace('!!list_user!!', $deroul_user, $form); } else $form = str_replace('!!list_user!!', '', $form); } else { $form = str_replace('!!lib_orig!!', ' ', $form); $form = str_replace('!!list_user!!', '', $form); } $form = str_replace('!!typ!!', $typ, $form); $form = str_replace('!!poi!!', $poids, $form); $form = str_replace('!!poi_tot!!', $poids_tot, $form); $form = str_replace('!!statut!!', $sug->statut, $form); $form = str_replace('!!lib_statut!!', $lib_statut, $form); if ($acquisition_sugg_categ != '1') { $sel_categ=""; } else { $state_name = $sug_map->getStateNameFromId($sug->statut); $categ = $sug_map->getState_CATEG($state_name); $sugg_categ = new suggestions_categ($sug->num_categ); if ($categ == 'YES') { $tab_categ = suggestions_categ::getCategList(); $sel_categ = ""; } else { $sel_categ = htmlentities($sugg_categ->libelle_categ, ENT_QUOTES,$charset); } } //Nombre d'exemplaire $form = str_replace('!!nombre_expl!!', $sug->nb, $form); //Selecteur de localisation $list_locs=''; if ($acquisition_sugg_localises) { $sugg_location_id=$sug->sugg_location; if ($sugg_location_id) $temp_location=$sugg_location_id; else $temp_location=0; $locs=new docs_location(); $list_locs=$locs->gen_combo_box_sugg($temp_location,1,""); } $form = str_replace('', $list_locs, $form); if($sug->num_notice && $sug->num_notice !=0){ $req_ana = "select analysis_bulletin as bull , analysis_notice as noti from analysis where analysis_notice ='".$sug->num_notice."'"; $res_ana = pmb_mysql_query($req_ana,$dbh); $num_rows_ana = pmb_mysql_num_rows($res_ana); if($num_rows_ana){ $ana = pmb_mysql_fetch_object($res_ana); $url_view = analysis::get_permalink($ana->noti, $ana->bull); } else $url_view = notice::get_permalink($sug->num_notice); $lien = " ".$msg['acquisition_sug_view_not'].""; $form = str_replace('!!lien!!',$lien, $form); } else $form = str_replace('!!lien!!','', $form); $form = str_replace('!!categ!!', $sel_categ, $form); $form = str_replace('!!tit!!', htmlentities($sug->titre, ENT_QUOTES, $charset), $form); $form = str_replace('!!edi!!', htmlentities($sug->editeur, ENT_QUOTES, $charset), $form); $form = str_replace('!!aut!!', htmlentities($sug->auteur, ENT_QUOTES, $charset), $form); $form = str_replace('!!cod!!', htmlentities($sug->code, ENT_QUOTES, $charset), $form); $form = str_replace('!!pri!!', round($sug->prix, 2), $form); $form = str_replace('!!com!!', htmlentities($sug->commentaires, ENT_QUOTES, $charset), $form); $form = str_replace('!!com_gestion!!', htmlentities($sug->commentaires_gestion, ENT_QUOTES, $charset), $form); $req = "select * from suggestions_source order by libelle_source"; $res= pmb_mysql_query($req,$dbh); $selected = ""; $option = ""; while(($src=pmb_mysql_fetch_object($res))){ ($src->id_source == $sug->sugg_src ? $selected = " selected ": $selected =""); $option .= ""; } $selecteur = ""; $form = str_replace('!!liste_source!!',$selecteur, $form); $form=str_replace("!!date_publi!!",htmlentities($sug->date_publi, ENT_QUOTES, $charset),$form); if(!$sug->get_explnum('id')){ $pj = "
"; } else { $pj = "
". $sug->get_explnum('nom')." 
"; } $form= str_replace('!!div_pj!!',$pj, $form); if ($sug->url_suggestion ) { $form = str_replace('', $lk_url_sug, $form); } $form = str_replace('!!url_sug!!', htmlentities($sug->url_suggestion, ENT_QUOTES, $charset), $form); $form = str_replace('!!id_notice!!', $sug->num_notice, $form); // Affichage du bouton supprimer $bt_sup = $sug_map->getButton_DELETED($sug->statut, $id_bibli, $id_sug); $form = str_replace('', $bt_sup, $form); if ($sug->num_notice) { //Eventuellement, lien vers la notice } else { // Affichage du bouton cataloguer $bt_cat = $sug_map->getButton_CATALOG($sug->statut, $id_bibli, $id_sug); $button = " "; if($sug->sugg_noti_unimarc){ $bt_cat = str_replace('!!type_catal!!'," ",$bt_cat); } else $bt_cat = str_replace('!!type_catal!!',$button,$bt_cat); $form = str_replace('', $bt_cat, $form); } } //$action ="./acquisition.php?categ=sug&action=update&id_bibli=".$id_bibli."&id_sug=".$id_sug; $form = str_replace('!!action!!', $update_action, $form); $form = str_replace('!!form_title!!', $titre, $form); print ""; print $form; } ?>