function show_list_categ()
{
global $dbh;
global $msg;
global $charset;
print "<table>\n\t<tr>\n\t\t<th>" . htmlentities($msg[103], ENT_QUOTES, $charset) . "</th>\n\t</tr>";
$tab_categ = suggestions_categ::getCategList();
$parity = 1;
foreach ($tab_categ as $id_categ => $lib_categ) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=categ&action=modif&id={$id_categ}';\" ";
print "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>" . htmlentities($lib_categ, ENT_QUOTES, $charset) . "</i></td>";
print "</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' " . $msg[acquisition_ajout_categ] . " ' onClick=\"document.location='./admin.php?categ=acquisition&sub=categ&action=add'\" />";
}
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;
}
}
if ($opac_sugg_categ == '1') {
if ($id_sug) {
$default_categ = $sugg->num_categ;
} else {
if (suggestions_categ::exists($opac_sugg_categ_default)) {
$default_categ = $opac_sugg_categ_default;
} else {
$default_categ = '1';
}
}
//Selecteur de categories
if ($acquisition_sugg_categ != '1') {
$sel_categ = "";
} else {
$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 == $default_categ) {
$sel_categ .= "selected='selected' ";
}
$sel_categ .= "> ";
$sel_categ .= htmlentities($lib_categ, ENT_QUOTES, $charset) . "</option>";
}
$sel_categ .= "</select>";
}
$sug_form .= "\n\t\t<tr>\n\t\t\t<td class='cell_header' align=right>" . htmlentities($msg['acquisition_categ'], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>{$sel_categ}</td>\n\t\t</tr>";
}
// Localisation de la suggestion
if ($_SESSION["id_empr_session"]) {
$su->url_suggestion = stripslashes($url_sug);
$su->commentaires = stripslashes($comment);
$su->date_creation = today();
$su->date_publi = stripslashes($date_publi);
$su->sugg_src = $sug_src;
// chargement de la PJ
if ($_FILES['piece_jointe_sug']['name']) {
$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') {
function update_sug()
{
global $id_bibli, $id_sug, $id_notice;
global $tit, $edi, $aut, $cod, $pri, $com, $com_gestion, $date_publi;
global $statut, $orig, $typ, $url_sug, $sug_src;
global $sug_map;
global $acquisition_sugg_categ, $acquisition_sugg_categ_default;
global $num_categ;
global $sugg_location_id;
global $nombre_expl;
global $creator_orig_id;
global $dbh;
if (!$id_sug && suggestions::exists($orig, $tit, $aut, $edi, $cod)) {
return;
}
$sug = new suggestions($id_sug);
$sug->titre = stripslashes($tit);
$sug->editeur = stripslashes($edi);
$sug->auteur = stripslashes($aut);
$sug->code = stripslashes($cod);
$sug->num_notice = $id_notice;
$pri = str_replace(',', '.', $pri);
if (is_numeric($pri)) {
$sug->prix = $pri;
}
$sug->url_suggestion = stripslashes($url_sug);
$sug->commentaires = stripslashes($com);
$sug->commentaires_gestion = stripslashes($com_gestion);
$sug->nb = $nombre_expl;
$sug->date_publi = $date_publi;
$sug->sugg_src = $sug_src;
$q = "select count(1) from docs_location where idlocation = '" . $sugg_location_id . "' ";
$r = mysql_query($q);
if ($sugg_location_id && mysql_result($r, 0, 0)) {
$sug->sugg_location = $sugg_location_id;
} else {
$sug->sugg_location = 0;
}
// chargement de la PJ
$explnum_doc = "";
if ($_FILES['piece_jointe_sug']['name']) {
$explnum_doc = new explnum_doc();
$explnum_doc->load_file($_FILES['piece_jointe_sug']);
$explnum_doc->analyse_file();
}
if (!$id_sug) {
$sug->statut = $sug_map->getFirstStateId();
$sug->date_creation = today();
if ($num_categ && suggestions_categ::exists($num_categ)) {
$sug->num_categ = $num_categ;
} else {
$sug->num_categ = '1';
}
$sug->save($explnum_doc);
$sug_orig = new suggestions_origine($orig, $sug->id_suggestion);
$sug_orig->type_origine = $typ;
$sug_orig->save();
} else {
if ($num_categ && suggestions_categ::exists($num_categ)) {
$sug->num_categ = $num_categ;
}
$sug->save($explnum_doc);
if ($creator_orig_id) {
$sug_orig = new suggestions_origine($creator_orig_id, $sug->id_suggestion);
$sug_orig->type_origine = $typ;
$sug_orig->save();
}
}
}
function changeCateg($chk, $to_categ)
{
foreach ($chk as $key => $id_sug) {
$sug = new suggestions($id_sug);
$state_name = $this->getStateNameFromId($sug->statut);
if ($this->getState_CATEG($state_name) == 'YES' && suggestions_categ::exists($to_categ)) {
$sug->num_categ = $to_categ;
$sug->save();
}
}
}
function edit_suggestion($session_id, $suggestion)
{
global $dbh, $msg;
if (!$session_id) {
return FALSE;
}
$session_info = $this->retrieve_session_information($session_id);
$empr_id = $session_info["empr_id"];
if (!$empr_id) {
return 0;
}
$id = $suggestion['sugg_id'] + 0;
if (!$id) {
return FALSE;
}
$exists = suggestions_origine::exists($empr_id, $id, 1);
if (!$exists) {
return FALSE;
}
$title = $suggestion['sugg_title'];
$author = $suggestion['sugg_author'];
$editor = $suggestion['sugg_editor'];
$isbn_or_ean = $suggestion['sugg_barcode'];
$price = $suggestion['sugg_price'];
$url = $suggestion['sugg_url'];
$comment = $suggestion['sugg_comment'];
$sugg_categ = $suggestion['sugg_category'];
$sugg_source = $suggestion['sugg_source'];
$sugg_location = $suggestion['sugg_location'];
global $charset;
if ($this->proxy_parent->input_charset != 'utf-8' && $charset == 'utf-8') {
$title = utf8_encode($suggestion['sugg_title']);
$author = utf8_encode($suggestion['sugg_author']);
$editor = utf8_encode($suggestion['sugg_editor']);
$isbn_or_ean = utf8_encode($suggestion['sugg_barcode']);
$price = utf8_encode($suggestion['sugg_price']);
$url = utf8_encode($suggestion['sugg_url']);
$comment = utf8_encode($suggestion['sugg_comment']);
$sugg_categ = utf8_encode($suggestion['sugg_category']);
$sugg_source = utf8_encode($suggestion['sugg_source']);
$sugg_location = utf8_encode($suggestion['sugg_location']);
} else {
if ($this->proxy_parent->input_charset == 'utf-8' && $charset != 'utf-8') {
$title = utf8_decode($suggestion['sugg_title']);
$author = utf8_decode($suggestion['sugg_author']);
$editor = utf8_decode($suggestion['sugg_editor']);
$isbn_or_ean = utf8_decode($suggestion['sugg_barcode']);
$price = utf8_decode($suggestion['sugg_price']);
$url = utf8_decode($suggestion['sugg_url']);
$comment = utf8_decode($suggestion['sugg_comment']);
$sugg_categ = utf8_decode($suggestion['sugg_category']);
$sugg_source = utf8_decode($suggestion['sugg_source']);
$sugg_location = utf8_decode($suggestion['sugg_location']);
}
}
$sug_map = new suggestions_map();
global $opac_sugg_categ, $opac_sugg_categ_default;
//copié de /opac_css/empr/make_sugg.inc.php
//On évite de saisir 2 fois la même suggestion
$su = new suggestions($id);
$su->titre = $title;
$su->editeur = $editor;
$su->auteur = $author;
$su->code = $isbn_or_ean;
$price = str_replace(',', '.', $price);
if (is_numeric($price)) {
$su->prix = $price;
}
$su->nb = 1;
$su->statut = $sug_map->getFirstStateId();
$su->url_suggestion = $url;
$su->commentaires = $comment;
$su->date_creation = today();
$su->sugg_src = $sugg_source;
if ($opac_sugg_categ == '1') {
if (!suggestions_categ::exists($sugg_categ)) {
$sugg_categ = $opac_sugg_categ_default;
}
if (!suggestions_categ::exists($sugg_categ)) {
$sugg_categ = '1';
}
$su->num_categ = $sugg_categ;
}
$su->sugg_location = $sugg_location;
$su->save();
return true;
}
/**
* Formulaire de saisie des suggestions multiples
*/
function display_form()
{
global $dbh, $multi_sug_form, $charset, $msg, $src_liste;
global $PMBusernom;
global $PMBuserprenom;
global $origine_id, $type_origine, $acquisition_sugg_categ, $acquisition_sugg_localises;
$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>";
$select = "";
while ($src = pmb_mysql_fetch_object($res)) {
$select = $src_liste == $src->id_source ? "selected" : "";
$option .= "<option value='" . $src->id_source . "' {$select} >" . htmlentities($src->libelle_source, ENT_QUOTES, $charset) . "</option>";
}
if (!$this->liste_sugg) {
$multi_sug_form = str_replace("!!max_lignes!!", "1", $multi_sug_form);
$ligne = "<tr id='sugg_0'>\n\t\t\t\t\t<td><input type='texte' name='sugg_tit_0' id='sugg_tit_0' value='' disabled /></td>\n\t\t\t\t\t<td><input type='texte' name='sugg_aut_0' id='sugg_aut_0' value=''disabled /></td>\n\t\t\t\t\t<td><input type='texte' name='sugg_edi_0' id='sugg_edi_0' value='' disabled /></td>\n\t\t\t\t\t<td><input type='texte' name='sugg_code_0' id='sugg_code_0' value='' disabled /></td>\n\t\t\t\t\t<td><input type='texte' name='sugg_prix_0' id='sugg_prix_0' value='' disabled /></td>\n\t\t\t\t\t<td><input type='texte' name='sugg_url_0' id='sugg_url_0' value='' disabled /></td>\n\t\t\t\t\t<td><textarea name='sugg_com_0' id='sugg_com_0' disabled ></textarea></td>\n\t\t\t\t\t<td><textarea name='sugg_com_gestion_0' id='sugg_com_gestion_0' disabled ></textarea></td>\n\t\t\t\t\t<td><input type='texte' name='sugg_date_0' id='sugg_date_0' value='' disabled /></td>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<select id='sugg_src_0' name='sugg_src_0' disabled>\n\t\t\t\t\t\t\t{$option}\n\t\t\t\t\t\t</select>\n\t\t\t\t\t</td>\n\t\t\t\t\t<td><input type='texte' name='sugg_qte_0' id='sugg_qte_0' value='1' disabled /></td>\n\t\t\t\t\t<td id='act_btn_0'><input type='button' class='bouton' name='add_line_0' id='add_line_0' value='+' onclick=\"add_line(0);\"/></td>\n\t\t\t\t</tr>";
} else {
$multi_sug_form = str_replace("!!max_lignes!!", count($this->liste_sugg), $multi_sug_form);
for ($i = 0; $i <= count($this->liste_sugg); $i++) {
if ($this->liste_sugg[$i]) {
$ligne .= "<tr id='sugg_{$i}'>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_tit_{$i}' id='sugg_tit_{$i}' value='" . htmlentities($this->liste_sugg[$i]['titre'], ENT_QUOTES, $charset) . "' /></td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_aut_{$i}' id='sugg_aut_{$i}' value='" . htmlentities($this->liste_sugg[$i]['auteur'], ENT_QUOTES, $charset) . "' /></td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_edi_{$i}' id='sugg_edi_{$i}' value='" . htmlentities($this->liste_sugg[$i]['editeur'], ENT_QUOTES, $charset) . "' /></td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_code_{$i}' id='sugg_code_{$i}' value='" . htmlentities($this->liste_sugg[$i]['code'], ENT_QUOTES, $charset) . "' /></td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_prix_{$i}' id='sugg_prix_{$i}' value='" . $this->liste_sugg[$i]['prix'] . "' /></td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_url_{$i}' id='sugg_url_{$i}' value='" . htmlentities($this->liste_sugg[$i]['url'], ENT_QUOTES, $charset) . "' /></td>\n\t\t\t\t\t\t<td><textarea name='sugg_com_{$i}' id='sugg_com_{$i}'></textarea></td>\n\t\t\t\t\t\t<td><textarea name='sugg_com_gestion_{$i}' id='sugg_com_gestion_{$i}'></textarea></td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_date_{$i}' id='sugg_date_{$i}' value='" . htmlentities($this->liste_sugg[$i]['date'], ENT_QUOTES, $charset) . "' /></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<select id='sugg_src_{$i}' name='sugg_src_{$i}'>\n\t\t\t\t\t\t\t\t{$option}\n\t\t\t\t\t\t\t</select>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td><input type='texte' name='sugg_qte_{$i}' id='sugg_qte_{$i}' value='1' /></td>";
if ($i == count($this->liste_sugg)) {
$ligne .= "<td id='act_btn_{$i}'><input type='button' class='bouton' name='add_line_{$i}' id='add_line_{$i}' value='+' onclick=\"add_line({$i});\"/></td>";
} else {
$ligne .= "<td id='act_btn_{$i}'><input type='button' class='bouton' name='del_line_{$i}' id='del_line_{$i}' value='X' onclick=\"del_line({$i});\"/></td>";
}
if ($this->liste_sugg[$i]['id_uni']) {
$ligne .= "<input type='hidden' name='id_unimarc_{$i}' id='id_unimarc_{$i}' value='" . $this->liste_sugg[$i]['id_uni'] . "'/> ";
}
$ligne .= "</tr>";
}
}
}
$multi_sug_form = str_replace('!!ligne!!', $ligne, $multi_sug_form);
if (!$origine_id) {
$multi_sug_form = str_replace('!!id_user!!', SESSuserid, $multi_sug_form);
$multi_sug_form = str_replace('!!type_user!!', 0, $multi_sug_form);
$multi_sug_form = str_replace('!!user_txt!!', $PMBusernom . ", " . $PMBuserprenom, $multi_sug_form);
} else {
$multi_sug_form = str_replace('!!id_user!!', $origine_id, $multi_sug_form);
$multi_sug_form = str_replace('!!type_user!!', $type_origine, $multi_sug_form);
if ($type_origine) {
$req = "select concat(empr_prenom,' ',empr_nom) as nom from empr where id_empr='" . $origine_id . "'";
} else {
$req = "select concat(prenom,' ',nom) as nom from users where userid='" . $origine_id . "'";
}
$res = pmb_mysql_query($req, $dbh);
$empr = pmb_mysql_fetch_object($res);
$multi_sug_form = str_replace('!!user_txt!!', $empr->nom, $multi_sug_form);
}
//Selecteur Affecter a une categorie
if ($acquisition_sugg_categ == '1') {
$sel_categ = "<label class='etiquette' >" . htmlentities($msg['acquisition_sug_sel_categ'], ENT_QUOTES, $charset) . "</label> ";
$tab_categ = suggestions_categ::getCategList();
$sel_categ .= "<select class='saisie-25em' id='num_categ' name='num_categ'>";
$sel_categ .= "<option value='-1'>" . htmlentities($msg['acquisition_sug_tous'], ENT_QUOTES, $charset) . "</option>";
foreach ($tab_categ as $id_categ => $lib_categ) {
$sel_categ .= "<option value='" . $id_categ . "' > ";
$sel_categ .= htmlentities($lib_categ, ENT_QUOTES, $charset) . "</option>";
}
$sel_categ .= "</select>";
} else {
$sel_categ = "";
}
//Selecteur de localisation
if ($acquisition_sugg_localises) {
$list_locs .= "<label class='etiquette' >" . htmlentities($msg['acquisition_sug_sel_localisation'], ENT_QUOTES, $charset) . "</label> ";
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);
} else {
$list_locs = '';
}
$multi_sug_form = str_replace('!!categorie!!', $sel_categ, $multi_sug_form);
$multi_sug_form = str_replace('!!localisation!!', $list_locs, $multi_sug_form);
return $multi_sug_form;
}
