} elseif ($opac_sugg_localises == 2) { $sug_form .= "<input type=\"hidden\" name=\"sugg_location_id\" value=\"" . $empr->empr_location . "\"/>"; } } } //Affichage du selecteur de source $req = "select * from suggestions_source order by libelle_source"; $res = mysql_query($req, $dbh); $option = "<option value='0' selected>" . htmlentities($msg['empr_sugg_no_src'], ENT_QUOTES, $charset) . "</option>"; while ($src = mysql_fetch_object($res)) { if ($id_sug) { $selected = $sugg->sugg_src == $src->id_source ? '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>"; $sug_form .= "<tr>\n\t\t\t<td class='cell_header' align=right>" . htmlentities($msg['empr_sugg_src'], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>{$selecteur}</td>\n\t\t</tr>"; if ($sugg) { if ($sugg->get_explnum('nom')) { $file_field = "<label>" . htmlentities($sugg->get_explnum('nom'), ENT_QUOTES, $charset) . "</label>"; } else { $file_field = "<input type=\"file\" id=\"piece_jointe_sug\" name=\"piece_jointe_sug\" size=\"40\" border=\"0\"/>"; } $sug_form .= "\n\t\t<tr>\n\t\t\t<td class='cell_header' align=right>" . htmlentities($msg["empr_sugg_piece_jointe"], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>\n\t\t\t\t{$file_field}\n\t\t\t</td>\n\t\t</tr>"; $btn_del = "<input type='button' class='bouton' name='ok' value=' " . htmlentities($msg[empr_suppr_sugg], ENT_QUOTES, $charset) . " ' onClick=\"if(confirm_suppr()) {this.form.lvl.value='suppr_sugg'; this.form.submit();}\"/>"; } else { $sug_form .= "\n\t\t<tr>\n\t\t\t<td class='cell_header' align=right>" . htmlentities($msg["empr_sugg_piece_jointe"], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td>\n\t\t\t\t<input type=\"file\" id=\"piece_jointe_sug\" name=\"piece_jointe_sug\" size=\"40\" border=\"0\"/>\n\t\t\t</td>\n\t\t</tr>"; $btn_del = ""; } $sug_form .= "\n\t\t<tr>\n\t\t\t<td colspan=2 align=right>\n\t\t\t\t<input type='button' class='bouton' name='ok' value=' " . addslashes($msg[empr_bt_valid_sugg]) . " ' onClick='this.form.lvl.value=\"valid_sugg\";this.form.submit()'/>\n\t\t\t\t{$btn_del}\n\t\t\t</td>\n\t\t</tr>\n\t</table>\n</form>\n\n</div></div>"; print $sug_form;
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; }
} else { $pair_impair = "odd"; } if ($row->statut == 1) { //Si la suggestion n'est pas validée on peut la modifier $modif_sugg = "onclick=\"document.location='" . $opac_url_base . "empr.php?lvl=make_sugg&id_sug={$row->id_suggestion}'\" "; $pointer = "style='cursor:pointer'"; } else { $modif_sugg = ""; $pointer = ""; } $sug_form .= "\n\t\t\t<tr class='{$pair_impair}' >\n\t\t\t\t<td {$modif_sugg} {$pointer}>" . formatdate($row->date_suggestion) . "</td>\n\t\t\t\t<td {$modif_sugg} {$pointer}>" . htmlentities($row->titre, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td {$modif_sugg} {$pointer}>" . htmlentities($row->editeur, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td {$modif_sugg} {$pointer}>" . htmlentities($row->auteur, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td {$modif_sugg} {$pointer}>" . $lib_statut . "</td>\n\t\t\t\t<td {$modif_sugg} {$pointer}>" . htmlentities($row->date_publication, ENT_QUOTES, $charset) . "</td>"; $source = new suggestion_source($row->sugg_source); $sug_form .= "<td {$pointer}>" . htmlentities($source->libelle_source, ENT_QUOTES, $charset) . "</td>"; if ($opac_sugg_categ == '1') { $categ = new suggestions_categ($row->num_categ); $sug_form .= "<td {$modif_sugg} {$pointer}>" . htmlentities($categ->libelle_categ, ENT_QUOTES, $charset) . "</td>"; } $sug = new suggestions($row->id_suggestion); if ($sug->get_explnum('id')) { $sug_form .= "<td align='center'><i>" . ($sug->get_explnum('id') ? "<a href=\"{$base_path}/explnum_doc.php?explnumdoc_id=" . $sug->get_explnum('id') . "\" target=\"_LINK_\"><img src='" . get_url_icon("globe_orange.png") . "' border='0' /></a>" : '') . "</i></td>"; } else { $sug_form .= "<td></td>"; } $sug_form .= "\n\t\t\t</tr>"; } $sug_form .= "</table></div></div>"; print $sug_form; } else { print "\n\t\t<h3>" . htmlentities($msg['empr_view_sugg'], ENT_QUOTES, $charset) . "</h3>\n\t\t<div class='row'>" . htmlentities($msg['empr_view_no_sugg'], ENT_QUOTES, $charset) . "\n\t\t</div>"; }