$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]) {
$explnum_doc = new explnum_doc();
$explnum_doc->load_file($_FILES['piece_jointe_sug']);
$explnum_doc->analyse_file();
}
if ($opac_sugg_categ == '1') {
if (!suggestions_categ::exists($num_categ)) {
$num_categ = $opac_sugg_categ_default;
}
if (!suggestions_categ::exists($num_categ)) {
$num_categ = '1';
}
$su->num_categ = $num_categ;
}
$su->sugg_location = $sugg_location_id;
$su->save($explnum_doc);
$orig = new suggestions_origine($userid, $su->id_suggestion);
$orig->type_origine = $type;
$orig->save();
//Ré-affichage de la suggestion
$sug_form .= "\n\t\t<table width='60%' cellpadding='5'>\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg["empr_sugg_tit"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->titre, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg["empr_sugg_aut"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->auteur, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg["empr_sugg_edi"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->editeur, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg["empr_sugg_code"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->code, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg["empr_sugg_prix"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->prix, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg['empr_sugg_url'], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->url_suggestion, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>" . htmlentities($msg['empr_sugg_comment'], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($su->commentaires, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>";
if (!$_SESSION["id_empr_session"]) {
$sug_form .= "\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg["empr_sugg_mail"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($mail, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>";
}
if ($opac_sugg_categ == '1') {
$categ = new suggestions_categ($su->num_categ);
$sug_form .= "\n\t\t\t<tr>\n\t\t\t\t<td >" . htmlentities($msg['acquisition_categ'], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($categ->libelle_categ, ENT_QUOTES, $charset) . "</td>\n\t\t\t</tr>";
}
$sug_form .= "\n\t\t<tr>\n\t\t\t<td >" . htmlentities($msg["empr_sugg_datepubli"], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>" . htmlentities($su->date_publi, ENT_QUOTES, $charset) . "</td>\n\t\t</tr>";
$sug_form .= "\n\t\t<tr>\n\t\t\t<td >" . htmlentities($msg["empr_sugg_qte"], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>" . htmlentities($su->nb, ENT_QUOTES, $charset) . "</td>\n\t\t</tr>";
$source = new suggestion_source($su->sugg_src);
$sug_form .= "\n\t\t<tr>\n\t\t\t<td >" . htmlentities($msg["empr_sugg_src"], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>" . htmlentities($source->libelle_source, ENT_QUOTES, $charset) . "</td>\n\t\t</tr>";
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¶m1=creator_orig_id¶m2=creator_lib_orig¶m3=typ¶m4=¶m5=¶m6=&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!!', ' ', $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') . " <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!!', " <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;
}
function save()
{
global $dbh, $max_nblignes, $msg, $id_empr, $empr_location, $num_categ;
for ($i = 0; $i < $max_nblignes; $i++) {
$tit = "sugg_tit_" . $i;
$aut = "sugg_aut_" . $i;
$edi = "sugg_edi_" . $i;
$code = "sugg_code_" . $i;
$prix = "sugg_prix_" . $i;
$com = "sugg_com_" . $i;
$url = "sugg_url_" . $i;
$qte = "sugg_qte_" . $i;
$src = "sugg_src_" . $i;
$date = "sugg_date_" . $i;
$unimarc = "id_unimarc_" . $i;
$notice = "id_notice_" . $i;
global $sug_tr, ${$tit}, ${$aut}, ${$edi}, ${$code}, ${$com}, ${$prix}, ${$url}, ${$qte}, ${$src}, ${$date}, ${$unimarc}, ${$notice};
if (isset(${$tit})) {
if (!is_numeric(${$qte})) {
print "<strong>" . $msg[empr_sugg_qte_error] . "<strong>";
return;
} else {
if (!${$tit} || !${$edi} && !${$aut} && !${$code}) {
print "<strong>" . str_replace('\\n', '<br />', $msg['empr_sugg_ko']) . "<strong>";
return;
} else {
if (!suggestions::exists($id_empr, ${$tit}, ${$aut}, ${$edi}, ${$code})) {
${$prix} = str_replace(',', '.', ${$prix});
$req = "insert into suggestions set \n\t\t\t\t\t\t\ttitre='" . ${$tit} . "',\n\t\t\t\t\t\t\tauteur='" . ${$aut} . "',\n\t\t\t\t\t\t\tediteur='" . ${$edi} . "',\n\t\t\t\t\t\t\tcode='" . ${$code} . "',\n\t\t\t\t\t\t\tprix='" . ${$prix} . "',\n\t\t\t\t\t\t\tcommentaires='" . ${$com} . "',\n\t\t\t\t\t\t\turl_suggestion='" . ${$url} . "',\n\t\t\t\t\t\t\tnb='" . ${$qte} . "',\n\t\t\t\t\t\t\tsugg_source='" . ${$src} . "',\n\t\t\t\t\t\t\tstatut=1,\n\t\t\t\t\t\t\tdate_publication='" . ${$date} . "',\n\t\t\t\t\t\t\tdate_creation='" . date("Y-m-d") . "',\n\t\t\t\t\t\t\tsugg_location='" . $empr_location . "',\n\t\t\t\t\t\t\tnum_categ='" . $num_categ . "'\n\t\t\t\t\t\t\t";
if (${$unimarc}) {
$uni = new suggestions_unimarc(${$unimarc});
$req .= ", notice_unimarc ='" . addslashes($uni->sugg_uni_notice) . "'";
}
if (${$notice}) {
$req .= ", num_notice ='" . ${$notice} . "'";
}
pmb_mysql_query($req, $dbh);
$idSugg = pmb_mysql_insert_id();
if (is_object($uni)) {
$uni->delete();
}
$sug_orig = new suggestions_origine($id_empr, $idSugg);
$sug_orig->type_origine = 1;
$sug_orig->save();
//Envoi mail
$su = new suggestions($idSugg);
suggestions::alert_mail_sugg_users_pmb(1, $id_empr, $su->get_table(), $su->sugg_location);
print $msg['empr_sugg_ok'];
} else {
print $msg['empr_sugg_already_exist'];
}
}
}
}
}
}
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]);
}
}
}
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", "", "");
}
}
}
function delete_suggestion($session_id, $suggestion_id)
{
global $dbh;
if (!$session_id) {
return FALSE;
}
$session_info = $this->retrieve_session_information($session_id);
$empr_id = $session_info["empr_id"];
if (!$empr_id) {
return FALSE;
}
$exists = suggestions_origine::exists($empr_id, $suggestion_id, 1);
if (!$exists) {
return FALSE;
}
$sugg = new suggestions($suggestion_id);
if (!($sugg->sugg_origine_type == 1) && $sugg->sugg_origine == $empr_id) {
return FALSE;
}
$sugg->delete($suggestion_id);
return TRUE;
}
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¶m1=orig¶m2=creator_lib_orig_ajax¶m3=typ¶m4=¶m5=¶m6=&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);
}
