| ".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']."\"](\"./images/notice.gif\" "\\"\".$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
$source = new suggestion_source($row->sugg_source);
$aff_row .="".htmlentities($source->libelle_source, ENT_QUOTES, $charset)." | ";
//Pondération
$q = suggestions_origine::listOccurences($row->id_suggestion);
$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];
}
$aff_row .="".htmlentities($poids_tot, ENT_QUOTES, $charset)." | ";
//Origine
$list_user="";
//On parcourt tous les créateurs de suggestions
for($j=0;$jorigine;
$typ = $users[$j]->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($list_user) $list_user.="\n";
$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($list_user) $list_user.="\n";
$list_user .= $lib_orig;
break;
case '2' :
if($orig) $lib_orig = $orig;
else $lib_orig = $msg['suggest_anonyme'];
if($list_user) $list_user.="\n";
$list_user .= $lib_orig;
break;
}
}
$aff_row .="".nl2br(htmlentities($list_user, 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="