"; $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= mysql_query($req,$dbh); $selected =""; $option = ""; while(($src=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 ($user_id[$k]) { $user_name = $user_txt[$k]; if(!$user_txt[$k]){ if ($user_statut[$k]==='0') { $req = "select nom, prenom from users where userid='".$user_id[$k]."'"; $res = mysql_query($req,$dbh); $user = 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='".$user_id[$k]."'"; $res = mysql_query($req,$dbh); $empr = 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($user_id[$k],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); 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); } 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); } } 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&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); } 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); } $res = mysql_query($q, $dbh); //Affichage liste des suggestions $nbr = mysql_num_rows($res); $aff_row=""; $parity=1; for($i=0;$i<$nbr;$i++) { $row=mysql_fetch_object($res); $lib_statut=$sug_map->getHtmlComment($row->statut); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" "; $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=sug&action=modif&id_bibli=".$id_bibli."&id_sug=".$row->id_suggestion."' \" "; $aff_row.= " ".formatdate($row->date_creation)." ".htmlentities($row->titre, ENT_QUOTES, $charset)." ".htmlentities($row->editeur, ENT_QUOTES, $charset)." ".htmlentities($row->auteur, 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 = mysql_query($req_ana,$dbh); $num_rows_ana = mysql_num_rows($res_ana); if($num_rows_ana){ $ana = mysql_fetch_object($res_ana); $url_view = "catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=$ana->bull&art_to_show=".$ana->noti; } else $url_view = "./catalog.php?categ=isbd&id=".$row->num_notice; $aff_row.="\"".$msg['acquisition_sug_view_not']."\""; } if ($acquisition_sugg_categ == '1') { $categ = new suggestions_categ($row->num_categ); $aff_row.="".htmlentities($categ->libelle_categ, ENT_QUOTES, $charset).""; } $source = new suggestion_source($row->sugg_source); $aff_row .="".htmlentities($source->libelle_source, ENT_QUOTES, $charset).""; $aff_row .="".htmlentities($row->date_publication, ENT_QUOTES, $charset).""; $sug = new suggestions($row->id_suggestion); $img_pj = "get_explnum('id')."\" target=\"_LINK_\">"; $img_import = "get_explnum('id')." \">"; $aff_row .="".($sug->get_explnum('id') ? "$img_pj $img_import" : '' ).""; $aff_row.= " "; } $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."&origine_id=".$user_id."&type_origine=".$user_statut."' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');" ; $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); //Lien vers la page suivante $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 = mysql_query($requete_user, $dbh); $row_user=mysql_fetch_row($res_user); $orig = $row_user[0]; $lib_orig = $row_user[1]; if ($row_user[2]) $lib_orig.= $row_user[2].", ".$row_user[1]; $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; $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= mysql_query($req,$dbh); $option = ""; while(($src=mysql_fetch_object($res))){ $option .= ""; $selected=""; } $selecteur = ""; $form = str_replace('!!liste_source!!',$selecteur, $form); $form = str_replace('!!date_publi!!','', $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 = mysql_query($q, $dbh); $orig = 0; $poids_tot = 0; $users = array(); while(($row_orig = mysql_fetch_object($list_orig))) { if (!$orig) { $orig = $row_orig->origine; $typ = $row_orig->type_origine; $poids = $tab_poids[$row_orig->type_origine]; } array_push($users,$row_orig); $poids_tot = $poids_tot + $tab_poids[$row_orig->type_origine]; } //On parcourt tous les créateurs de suggestions for($i=0;$iorigine; $typ = $users[$i]->type_origine; $suppr_click = "onClick=\"if(confirm('".$msg['confirm_suppr_origine']."')){ ajax_suppr_origine('".$orig."','".$typ."');}\""; //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 = mysql_query($requete_user, $dbh); $row_user=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."basket
"; break; case '1' : $requete_empr = "SELECT id_empr, empr_nom, empr_prenom FROM empr where id_empr = '".$orig."'"; $res_empr = mysql_query($requete_empr, $dbh); $row_empr=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."basket
"; 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."basket
"; 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 = " "; $form = str_replace('!!id_sug!!', $id_sug, $form); if(sizeof($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']. " (".(sizeof($users)-1).")",$list_user,0); if ($lib_orig) { $form = str_replace('!!lib_orig!!', htmlentities($premier_user, ENT_QUOTES, $charset), $form); if(sizeof($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 = mysql_query($req_ana,$dbh); $num_rows_ana = mysql_num_rows($res_ana); if($num_rows_ana){ $ana = mysql_fetch_object($res_ana); $url_view = "catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=$ana->bull&art_to_show=".$ana->noti; } else $url_view = "./catalog.php?categ=isbd&id=".$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= mysql_query($req,$dbh); $selected = ""; $option = ""; while(($src=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; } ?>