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 = 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."
";
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."
";
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 = "
";
$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);
$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;
}
?>
![\"".$msg['acquisition_sug_view_not']."\"](\"./images/notice.gif\" "\\"\".$msg['acquisition_sug_view_not'].\"\\"")
";
$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('!!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 = "