コード例 #1
0
$w_dat = round($w * 10 / 100);
$x_tit = $x_dat + $w_dat;
$w_tit = round($w * 30 / 100);
$x_edi = $x_tit + $w_tit;
$w_edi = round($w * 20 / 100);
$x_qte = $x_edi + $w_edi;
$w_qte = round($w * 7 / 100);
$x_com = $x_qte + $w_qte;
$w_com = round($w * 33 / 100);
printEntete_genes();
while ($row = pmb_mysql_fetch_object($res)) {
    //recuperation origine
    $lib_orig = "";
    $typ_orig = "0";
    $sug = new suggestions($row->id_suggestion);
    $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;
    }
    //Récupération du nom du créateur de la suggestion
    switch ($typ_orig) {
        default:
        case '0':
            $requete_user = "******" . $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]) {
コード例 #2
0
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 = "******" . 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] . ", " . $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 = "<select class='saisie-25em' id='num_categ' name='num_categ'>";
            foreach ($tab_categ as $id_categ => $lib_categ) {
                $sel_categ .= "<option value='" . $id_categ . "' ";
                if ($id_categ == $sugg_categ->id_categ) {
                    $sel_categ .= "selected='selected' ";
                }
                $sel_categ .= ">";
                $sel_categ .= htmlentities($lib_categ, ENT_QUOTES, $charset) . "</option>";
            }
            $sel_categ .= "</select>";
        }
        $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('<!-- sel_location -->', $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 = pmb_mysql_query($req, $dbh);
        $option = "<option value='0' selected>" . htmlentities($msg['acquisition_sugg_no_src'], ENT_QUOTES, $charset) . "</option>";
        while ($src = pmb_mysql_fetch_object($res)) {
            $option .= "<option value='" . $src->id_source . "' {$selected} >" . htmlentities($src->libelle_source, ENT_QUOTES, $charset) . "</option>";
            $selected = "";
        }
        $selecteur = "<select id='sug_src' name='sug_src'>" . $option . "</select>";
        $form = str_replace('!!liste_source!!', $selecteur, $form);
        $form = str_replace('!!date_publi!!', '', $form);
        $pj = "<div class='row'>\n\t\t\t\t\t<input type='file' id='piece_jointe_sug' name='piece_jointe_sug' class='saisie-80em' size='60' />\n\t\t\t  </div>";
        $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];
            }
            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; $i < sizeof($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 = "******" . $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 . "<br />";
                    }
                    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 . "<br />";
                    }
                    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 . "<br />";
                    }
                    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 = "<input id='creator_orig_id' type='hidden' name='creator_orig_id'>\n\t\t<input type='text' id='creator_lib_orig' name='creator_lib_orig' class='saisie-10emr'/>\n\t\t<input type='button' class='bouton_small' value='...' onclick=\"openPopUp('./select.php?what=origine&caller=sug_modif_form&param1=creator_orig_id&param2=creator_lib_orig&param3=typ&param4=&param5=&param6=&deb_rech=', 'select_creator_orig', 400, 400, -2, -2, 'scrollbars=yes, toolbar=no, dependent=yes, resizable=yes')\" />";
        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!!', "<br />" . $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!!', '&nbsp;', $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 = "<select class='saisie-25em' id='num_categ' name='num_categ'>";
                foreach ($tab_categ as $id_categ => $lib_categ) {
                    $sel_categ .= "<option value='" . $id_categ . "' ";
                    if ($id_categ == $sug->num_categ) {
                        $sel_categ .= "selected='selected' ";
                    }
                    $sel_categ .= ">";
                    $sel_categ .= htmlentities($lib_categ, ENT_QUOTES, $charset) . "</option>";
                }
                $sel_categ .= "</select>";
            } 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('<!-- sel_location -->', $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 = "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 = "<a href='{$url_view}'> " . $msg['acquisition_sug_view_not'] . "</a>";
            $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 = "<option value='0' selected>" . htmlentities($msg['acquisition_sugg_no_src'], ENT_QUOTES, $charset) . "</option>";
        while ($src = pmb_mysql_fetch_object($res)) {
            $src->id_source == $sug->sugg_src ? $selected = " selected " : ($selected = "");
            $option .= "<option value='" . $src->id_source . "' {$selected}>" . htmlentities($src->libelle_source, ENT_QUOTES, $charset) . "</option>";
        }
        $selecteur = "<select id='sug_src' name='sug_src'>" . $option . "</select>";
        $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 = "<div class='row'>\n\t\t\t\t\t<input type='file' id='piece_jointe_sug' name='piece_jointe_sug' class='saisie-80em' size='60' />\n\t\t\t  </div>";
        } else {
            $pj = "\n\t\t\t<input type='hidden' name='id_pj' id='id_pj' value='" . $sug->get_explnum('id') . "' />\n\t\t\t<div class='row'>" . $sug->get_explnum('nom') . "&nbsp;<input type='submit' class='bouton' name='del_pj' id='del_pj' value='X' onclick='this.form.action=\"./acquisition.php?categ=sug&action=del_pj&id_bibli=" . $id_bibli . "&id_sug=" . $id_sug . "\"' /> \n\t\t\t</div>";
        }
        $form = str_replace('!!div_pj!!', $pj, $form);
        if ($sug->url_suggestion) {
            $form = str_replace('<!-- url_sug -->', $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('<!-- bouton_sup -->', $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 = "<input type='radio' name='catal_type' id='not_type' value='0' checked /><label class='etiquette' for='not_type'>" . htmlentities($msg['acquisition_type_mono'], ENT_QUOTES, $charset) . "</label>\n\t\t\t<input type='radio' name='catal_type' value='1' id='art_type'/><label for='art_type' class='etiquette'>" . htmlentities($msg['acquisition_type_art'], ENT_QUOTES, $charset) . "</label>";
            if ($sug->sugg_noti_unimarc) {
                $bt_cat = str_replace('!!type_catal!!', "&nbsp;<label style='color:red'>Notice externe existante</label>", $bt_cat);
            } else {
                $bt_cat = str_replace('!!type_catal!!', $button, $bt_cat);
            }
            $form = str_replace('<!-- bouton_cat -->', $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 "<script type=\"text/javascript\" src=\"" . $javascript_path . "/tablist.js\"></script>";
    print $form;
}
コード例 #3
0
 function sendMail($sug)
 {
     global $dbh, $msg, $charset;
     global $biblio_name, $biblio_email, $biblio_phone;
     global $acquisition_mel_rej_obj, $acquisition_mel_rej_cor;
     global $acquisition_mel_con_obj, $acquisition_mel_con_cor;
     global $acquisition_mel_aba_obj, $acquisition_mel_aba_cor;
     global $acquisition_mel_cde_obj, $acquisition_mel_cde_cor;
     global $acquisition_mel_rec_obj, $acquisition_mel_rec_cor;
     $mask = $this->getMask_FILED();
     if (($sug->statut & $mask) == 0) {
         $state = $sug->statut;
     } else {
         $state = $mask;
     }
     $state_name = $this->id_to_name[$state];
     switch ($state_name) {
         case 'REJECTED':
             //Rejet
             $objet = $acquisition_mel_rej_obj;
             $corps = $acquisition_mel_rej_cor;
             break;
         case 'CONFIRMED':
             //Confirmation
             $objet = $acquisition_mel_con_obj;
             $corps = $acquisition_mel_con_cor;
             break;
         case 'GIVENUP':
             //Abandon
             $objet = $acquisition_mel_aba_obj;
             $corps = $acquisition_mel_aba_cor;
             break;
         case 'ORDERED':
             //Commande
             $objet = $acquisition_mel_cde_obj;
             $corps = $acquisition_mel_cde_cor;
             break;
         case 'RECEIVED':
             //Réception
             $objet = $acquisition_mel_rec_obj;
             $corps = $acquisition_mel_rec_cor;
             break;
         default:
             return;
             break;
     }
     $corps .= "\n\n " . $msg['acquisition_sug_tit'] . " :\t " . $sug->titre . "\n";
     if ($sug->auteur) {
         $corps .= $msg['acquisition_sug_aut'] . " :\t " . $sug->auteur . "\n";
     }
     if ($sug->editeur) {
         $corps .= $msg['acquisition_sug_edi'] . " :\t " . $sug->editeur . "\n";
     }
     if ($sug->code) {
         $corps .= $msg['acquisition_sug_cod'] . " :\t " . $sug->code . "\n";
     }
     if ($sug->prix) {
         $corps .= $msg['acquisition_sug_pri'] . " :\t " . $sug->prix . "\n";
     }
     if ($sug->commentaires) {
         $corps .= $msg['acquisition_sug_com'] . " :\t " . $sug->commentaires . "\n";
     }
     $corps .= "\n\n";
     $corps = str_replace('!!date!!', formatdate($sug->date_creation), $corps);
     $q = suggestions_origine::listOccurences($sug->id_suggestion);
     $list_orig = mysql_query($q, $dbh);
     while ($row = mysql_fetch_object($list_orig)) {
         switch ($row->type_origine) {
             default:
             case '0':
                 $q = "SELECT nom, prenom, user_email FROM users where userid = '" . $row->origine . "' limit 1 ";
                 $r = mysql_fetch_object(mysql_query($q, $dbh));
                 $tonom = $r->prenom . " " . $r->nom;
                 $tomail = $r->user_email;
                 break;
             case '1':
                 $q = "SELECT empr_nom, empr_prenom, empr_mail FROM empr where id_empr = '" . $row->origine . "' limit 1 ";
                 $r = mysql_fetch_object(mysql_query($q, $dbh));
                 $tonom = $r->empr_prenom . " " . $r->empr_nom;
                 $tomail = $r->empr_mail;
                 break;
             case '2':
                 $tonom = $row->origine;
                 $tomail = $row->origine;
                 break;
         }
         if ($tomail != '') {
             $res_envoi = mailpmb($tonom, $tomail, $objet, $corps, $biblio_name, $biblio_email, "Content-Type: text/plain; charset=\"{$charset}\"\n", "", "");
         }
     }
 }
コード例 #4
0
function sug_fusVal()
{
    global $dbh;
    global $msg, $charset;
    global $chk, $sug;
    $fus = new suggestions($chk[0]);
    $q = suggestions_origine::listOccurences($chk[0], 1);
    $tab_orig = mysql_query($q, $dbh);
    $row_orig = mysql_fetch_object($tab_orig);
    $orig = $row_orig->origine;
    foreach ($sug as $key => $id_sug) {
        if ($id_sug != $chk[0]) {
            suggestions::delete($id_sug);
            suggestions_origine::fusionne($orig, $id_sug, $chk[0]);
        }
    }
}
コード例 #5
0
ファイル: ajax_sugg.inc.php プロジェクト: bouchra012/PMB
function mod_origine()
{
    global $id_sugg, $orig, $type_orig, $dbh, $msg;
    global $quoifaire;
    $sug_ori = new suggestions_origine($orig, $id_sugg);
    if ($sug_ori) {
        if ($type_orig) {
            $sug_ori->type_origine = $type_orig;
        }
        switch ($quoifaire) {
            case 'ajout_origine':
                $sug_ori->save();
                break;
            case 'suppr_origine':
                $sug_ori->delete($sug_ori->num_suggestion, $sug_ori->origine, $sug_ori->type_origine);
                break;
        }
    }
    $list_user = "";
    $req_select = suggestions_origine::listOccurences($id_sugg);
    $res = mysql_query($req_select, $dbh);
    $nb_user = 0;
    while ($user = mysql_fetch_object($res)) {
        switch ($user->type_origine) {
            default:
            case '0':
                $requete_user = "******" . $user->origine . "'";
                $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];
                }
                $suppr_click = "onClick=\"if(confirm('" . $msg['confirm_suppr_origine'] . "')){ ajax_suppr_origine('" . $user->origine . "','" . $user->type_origine . "');}\"";
                if (empty($premier_user) || !isset($premier_user)) {
                    $premier_user = $lib_orig;
                } else {
                    $list_user .= $lib_orig . "<img src='./images/trash.png' align='middle' alt='basket' title=\"" . $msg["origine_suppr"] . "\" alt=\"" . $msg["origine_suppr"] . "\" {$suppr_click} /><br />";
                }
                break;
            case '1':
                $requete_empr = "SELECT id_empr, empr_nom, empr_prenom FROM empr where id_empr = '" . $user->origine . "'";
                $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];
                }
                $suppr_click = "onClick=\"if(confirm('" . $msg['confirm_suppr_origine'] . "')){ ajax_suppr_origine('" . $user->origine . "','" . $user->type_origine . "');}\"";
                if (empty($premier_user) || !isset($premier_user)) {
                    $premier_user = $lib_orig;
                } else {
                    $list_user .= $lib_orig . "<img src='./images/trash.png' align='middle' alt='basket' title=\"" . $msg["origine_suppr"] . "\" alt=\"" . $msg["origine_suppr"] . "\" {$suppr_click} /><br />";
                }
                break;
            case '2':
                if ($user->origine) {
                    $lib_orig = $user->origine;
                } else {
                    $lib_orig = $msg['suggest_anonyme'];
                }
                $suppr_click = "onClick=\"if(confirm('" . $msg['confirm_suppr_origine'] . "')){ ajax_suppr_origine('" . $user->origine . "','" . $user->type_origine . "');}\"";
                if (empty($premier_user) || !isset($premier_user)) {
                    $premier_user = $lib_orig;
                } else {
                    $list_user .= $lib_orig . "<img src='./images/trash.png' align='middle' alt='basket' title=\"" . $msg["origine_suppr"] . "\" alt=\"" . $msg["origine_suppr"] . "\" {$suppr_click} /><br />";
                }
                break;
        }
        $nb_user++;
    }
    $ajout_create = "\n\t\t<input type='text' id='creator_lib_orig_ajax' name='creator_lib_orig' class='saisie-10emr'/>\n\t\t<input type='button' id='creator_btn_orig_ajax' class='bouton_small' value='...' onclick=\"openPopUp('./select.php?what=origine&caller=sug_modif_form&param1=orig&param2=creator_lib_orig_ajax&param3=typ&param4=&param5=&param6=&callback=ajax_origine&deb_rech='+document.getElementById('creator_lib_orig_ajax').value, 'select_creator_orig', 400, 400, -2, -2, 'scrollbars=yes, toolbar=no, dependent=yes, resizable=yes')\" />";
    $list_user .= $ajout_create;
    if (mysql_num_rows($res) > 1) {
        $result = gen_plus('ori_ajax', $msg['suggest_creator'] . " (" . ($nb_user - 1) . ")", $list_user, 0);
    } else {
        if (mysql_num_rows($res) == 1) {
            $result = $list_user;
        }
    }
    ajax_http_send_response($result);
}