function __construct($notice_ids, $user = 0)
{
global $PMBuserid;
$this->user = $user;
if ($this->user = 0) {
$this->user = $PMBuserid;
}
$this->notice_ids = $notice_ids;
if ($this->notice_ids != '') {
//filtrage sur statut ou droits d'accès..
$query = $this->_get_filter_query();
if ($query) {
$res = pmb_mysql_query($query);
$this->notice_ids = "";
if (pmb_mysql_num_rows($res)) {
while ($row = pmb_mysql_fetch_assoc($res)) {
if ($this->notice_ids != "") {
$this->notice_ids .= ",";
}
$this->notice_ids .= $row['id_notice'];
}
}
}
}
}
function fetch_data()
{
global $dbh;
$req = "SELECT surloc_num, location_id,location_libelle, rel_date_parution,rel_libelle_numero, rel_comment_opac \n\t\tfrom perio_relance, abts_abts, docs_location\n\t\twhere location_id=idlocation and rel_abt_num=abt_id and num_notice=" . $this->serial_id . " and rel_comment_opac!='' group by rel_abt_num,rel_date_parution,rel_libelle_numero order by rel_nb desc";
$result = pmb_mysql_query($req);
if (pmb_mysql_num_rows($result)) {
$tr_class = "";
while ($r = pmb_mysql_fetch_object($result)) {
$surloc_libelle = "";
if ($opac_sur_location_activate && $r->surloc_num) {
$req = "select surloc_libelle from sur_location where surloc_id = " . $r->surloc_num;
$res_surloc = pmb_mysql_query($req);
if (pmb_mysql_num_rows($res_surloc)) {
$surloc = pmb_mysql_fetch_object($res_surloc);
$surloc_libelle = $surloc->surloc_libelle . " / ";
}
}
$line = $bulletin_retard_line;
$line = str_replace("!!location_libelle!!", $surloc_libelle . $r->location_libelle, $line);
$line = str_replace("!!date_parution!!", $r->rel_date_parution, $line);
$line = str_replace("!!libelle_numero!!", $r->rel_libelle_numero, $line);
$line = str_replace("!!comment_opac!!", $r->rel_comment_opac, $line);
if ($tr_class == 'even') {
$tr_class = "odd";
} else {
$tr_class = 'even';
}
$line = str_replace("!!tr_class!!", $tr_class, $line);
$lines .= $line;
}
$tpl = $bulletin_retard_form;
$tpl = gen_plus("bulletin_retard", $msg["bulletin_retard_title"], str_replace("!!bulletin_retard_list!!", $lines, $tpl));
}
}
public function fetch_datas()
{
global $dbh;
$this->instruments = array();
$this->instruments_data = array();
$this->label = "";
$this->num_nomenclature = 0;
$this->order = 0;
if ($this->id) {
//le nom de l'atelier
$query = "select * from nomenclature_workshops where id_workshop = " . $this->id . " order by workshop_order asc, workshop_label";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
if ($row = pmb_mysql_fetch_object($result)) {
$this->label = $row->workshop_label;
$this->num_nomenclature = $row->workshop_num_nomenclature;
$this->order = $row->workshop_order;
//récupération des instruments
$query = "select workshop_instrument_num_instrument, workshop_instrument_number,workshop_instrument_order from nomenclature_workshops_instruments where workshop_instrument_num_workshop = " . $this->id . " order by workshop_instrument_order asc";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
$this->add_instrument(new nomenclature_instrument($row->workshop_instrument_num_instrument));
$this->instruments_data[$row->workshop_instrument_num_instrument]['effective'] = $row->workshop_instrument_number;
$this->instruments_data[$row->workshop_instrument_num_instrument]['order'] = $row->workshop_instrument_order;
}
}
}
}
}
}
function param_perso_form(&$p_perso)
{
global $dbh;
global $param_perso_900;
for ($i = 0; $i < count($param_perso_900); $i++) {
$req = " select idchamp, type, datatype from notices_custom where name='" . $param_perso_900[$i]['n'] . "'";
$res = pmb_mysql_query($req, $dbh);
if (pmb_mysql_num_rows($res)) {
$perso = pmb_mysql_fetch_object($res);
if ($perso->idchamp) {
if ($perso->type == 'list') {
$requete = "select notices_custom_list_value from notices_custom_lists where notices_custom_list_lib='" . addslashes($param_perso_900[$i]['a']) . "' and notices_custom_champ={$perso->idchamp}";
$resultat = pmb_mysql_query($requete);
if (pmb_mysql_num_rows($resultat)) {
$value = pmb_mysql_result($resultat, 0, 0);
} else {
$requete = "select max(notices_custom_list_value*1) from notices_custom_lists where notices_custom_champ={$perso->idchamp}";
$resultat = pmb_mysql_query($requete);
$max = @pmb_mysql_result($resultat, 0, 0);
$n = $max + 1;
$requete = "insert into notices_custom_lists (notices_custom_champ,notices_custom_list_value,notices_custom_list_lib) values({$perso->idchamp},{$n},'" . addslashes($param_perso_900[$i]['a']) . "')";
pmb_mysql_query($requete);
$value = $n;
}
$p_perso->values[$perso->idchamp][] = $value;
} else {
$p_perso->values[$perso->idchamp][] = $param_perso_900[$i]['a'];
}
}
}
}
}
function get_primaldata()
{
global $dbh;
$requete = "SELECT * FROM sub_collections WHERE sub_coll_id='" . addslashes($this->id) . "' ";
$result = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($result)) {
$obj = pmb_mysql_fetch_object($result);
pmb_mysql_free_result($result);
$this->get_primaldatafrom($obj);
} else {
// pas de sous-collection avec cette clé
$this->id = 0;
$this->name = '';
$this->parent = '';
$this->parent_libelle = '';
$this->parent_isbd = '';
$this->publisher = '';
$this->publisher_libelle = '';
$this->publisher_isbd = '';
$this->display = '';
$this->issn = '';
$this->isbd_entry = '';
$this->comment = '';
}
}
public function get_datas()
{
global $dbh;
$return = array();
$selector = $this->get_selected_selector();
if ($selector) {
$value = $selector->get_value();
if ($value != 0) {
//on part du premier exemplaire...
$query = "select expl_cote from exemplaires where expl_notice = " . $value . " order by expl_cote limit 1 ";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result) > 0) {
$row = pmb_mysql_fetch_object($result);
$cote = $row->expl_cote;
$query = "\n\t\t\t\t\t(select distinct expl_notice,expl_cote from exemplaires where expl_notice!=0 and expl_bulletin = 0 and expl_cote >= '" . $cote . "' and expl_notice = " . $value . " order by expl_cote asc limit 5)\n\t\t\t\t\t\tunion \n\t\t\t\t\t(select distinct expl_notice,expl_cote from exemplaires where expl_notice!=0 and expl_bulletin = 0 and expl_cote < '" . $cote . "' and expl_notice = " . $value . " order by expl_cote desc limit 5)";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result) > 0) {
$return["title"] = "";
while ($row = pmb_mysql_fetch_object($result)) {
$return["records"][] = $row->expl_notice;
}
}
$return['records'] = $this->filter_datas("notices", $return['records']);
if ($this->parameters['nb_max_elements'] > 0) {
$return['records'] = array_slice($return['records'], 0, $this->parameters['nb_max_elements']);
}
}
}
return $return;
}
return false;
}
public function get_datas()
{
global $opac_url_base;
global $opac_show_book_pics;
global $opac_book_pics_url;
$datas = parent::get_datas();
$notices = $datas['records'];
$query = "select notice_id,tit1,thumbnail_url,code from notices where notice_id in(" . implode(",", $notices) . ")";
$result = pmb_mysql_query($query);
$notices = array();
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
if ($opac_show_book_pics == '1' && ($opac_book_pics_url || $row->thumbnail_url)) {
$code_chiffre = pmb_preg_replace('/-|\\.| /', '', $row->code);
$url_image = $opac_book_pics_url;
$url_image = $opac_url_base . "getimage.php?url_image=" . urlencode($url_image) . "¬icecode=!!noticecode!!&vigurl=" . urlencode($row->thumbnail_url);
if ($row->thumbnail_url) {
$url_vign = $row->thumbnail_url;
} else {
if ($code_chiffre) {
$url_vign = str_replace("!!noticecode!!", $code_chiffre, $url_image);
} else {
$url_vign = $opac_url_base . "images/vide.png";
}
}
}
$notices[] = array('title' => $row->tit1, 'link' => $opac_url_base . "?lvl=notice_display&id=" . $row->notice_id, 'vign' => $url_vign);
}
}
return array('records' => $notices);
}
public function get_value()
{
if (!$this->value) {
$parent = new cms_module_common_selector_sections($this->get_sub_selector_id("cms_module_common_selector_sections"));
$cp = new cms_module_common_selector_type_section_filter($this->get_sub_selector_id("cms_module_common_selector_type_section_filter"));
$parents = $parent->get_value();
$field = $cp->get_value();
$var = new cms_module_common_selector_env_var($this->get_sub_selector_id("cms_module_common_selector_env_var"));
$this->value = array();
if (is_array($parents) && count($parents)) {
$query = "select id_section from cms_sections where section_num_parent in (" . implode(",", $parents) . ")";
$result = pmb_mysql_query($query);
$fields = new cms_editorial_parametres_perso($field['type']);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
$fields->get_values($row->id_section);
if (in_array($var->get_value(), $fields->values[$field['field']])) {
$this->value[] = $row->id_section;
}
}
}
}
}
return $this->value;
}
function fetch_data()
{
global $dbh;
$this->selected_list = array();
$req = "SELECT * FROM opac_filters where opac_filter_view_num=" . $this->id_vue . " and opac_filter_path='" . $this->path . "' ";
$myQuery = pmb_mysql_query($req, $dbh);
if (pmb_mysql_num_rows($myQuery)) {
$r = pmb_mysql_fetch_object($myQuery);
$param = unserialize($r->opac_filter_param);
$this->selected_list = $param["selected"];
}
$myQuery = pmb_mysql_query("SELECT * FROM docs_location order by location_libelle ", $dbh);
$this->liste_item = array();
$link = "";
$i = 0;
if (pmb_mysql_num_rows($myQuery)) {
while ($r = pmb_mysql_fetch_object($myQuery)) {
$this->liste_item[$i] = new stdClass();
$this->liste_item[$i]->id = $r->idlocation;
$this->liste_item[$i]->name = $r->location_libelle;
if (in_array($r->idlocation, $this->selected_list)) {
$this->liste_item[$i]->selected = 1;
} else {
$this->liste_item[$i]->selected = 0;
}
$i++;
}
}
return true;
}
function show_form($param = '')
{
global $dbh, $charset;
global $deflt_upload_repertoire;
//On créer le sélecteur pour choisir le repertoire d'upload
$query = "SELECT * FROM upload_repertoire";
$result = pmb_mysql_query($query, $dbh);
$select = "";
if (pmb_mysql_num_rows($result)) {
$select .= "<select name='upload_repertoire'>";
$allready_selected = false;
while ($upload_rep = pmb_mysql_fetch_object($result)) {
if ($param['upload_repertoire'] == $upload_rep->repertoire_id && !$allready_selected) {
$select .= "\t<option selected='true' value='{$upload_rep->repertoire_id}'>{$upload_rep->repertoire_nom}</option>";
$allready_selected = true;
} elseif ($deflt_upload_repertoire == $upload_rep->repertoire_id && !$allready_selected) {
$select .= "\t<option selected='true' value='{$upload_rep->repertoire_id}'>{$upload_rep->repertoire_nom}</option>";
$allready_selected = true;
} else {
$select .= "\t<option value='{$upload_rep->repertoire_id}'>{$upload_rep->repertoire_nom}</option>";
}
}
$select .= "</select>";
} else {
$select .= $this->msg['planificateur_scan_docnum_no_upload_repertoire'];
}
$form_task .= "\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>\n\t\t\t\t<label for='upload_folder'>" . $this->msg["planificateur_scan_docnum_upload_repertoire"] . "</label>\n\t\t\t</div>\n\t\t\t<div class='colonne_suite'>\n\t\t\t\t{$select}\t\n\t\t\t</div>\n\t\t</div>\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>\n\t\t\t\t<label for='upload_folder'>" . $this->msg["planificateur_scan_docnum_upload_folder"] . "</label>\n\t\t\t</div>\n\t\t\t<div class='colonne_suite'>\n\t\t\t\t<input type='text' id='upload_folder' name='upload_folder' value='" . htmlentities($param['upload_folder'], ENT_QUOTES, $charset) . "'/>\n\t\t\t</div>\n\t\t</div>";
return $form_task;
}
function search_other_function_filters()
{
global $recherche_loc;
global $charset;
global $msg, $dbh;
// mettre par défaut la localisation du lecteur
if (!isset($recherche_loc) && $_SESSION["empr_location"]) {
$recherche_loc = $_SESSION["empr_location"];
}
$r .= "<select name='recherche_loc'>";
$r .= "<option value='0'>" . htmlentities($msg["search_loc_all_site"], ENT_QUOTES, $charset) . "</option>";
$requete = "select location_libelle,idlocation from docs_location where location_visible_opac=1";
$result = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($result)) {
while ($loc = pmb_mysql_fetch_object($result)) {
$selected = "";
if ($recherche_loc == $loc->idlocation) {
$selected = "selected";
}
$r .= "<option value='{$loc->idlocation}' {$selected}>{$loc->location_libelle}</option>";
}
}
$r .= "</select>";
return $r;
}
function explnum_doc($id_expl = 0)
{
global $dbh;
$this->explnum_doc_id = $id_expl;
if (!$this->explnum_doc_id) {
$this->explnum_doc_nomfichier = '';
$this->explnum_doc_contenu = '';
$this->explnum_doc_mime = '';
$this->explnum_doc_extfichier = '';
} else {
$req = "select * from explnum_doc where id_explnum_doc='" . $this->explnum_doc_id . "'";
$res = pmb_mysql_query($req, $dbh);
if (pmb_mysql_num_rows($res)) {
$expl = pmb_mysql_fetch_object($res);
$this->explnum_doc_nomfichier = $expl->explnum_doc_nomfichier;
$this->explnum_doc_contenu = $expl->explnum_doc_data;
$this->explnum_doc_mime = $expl->explnum_doc_mimetype;
$this->explnum_doc_extfichier = $expl->explnum_doc_extfichier;
} else {
$this->explnum_doc_nomfichier = '';
$this->explnum_doc_contenu = '';
$this->explnum_doc_mime = '';
$this->explnum_doc_extfichier = '';
}
}
}
protected function fetch_datas()
{
global $dbh;
$this->name = "";
$this->nature = 0;
$this->order = 0;
$this->types = array();
if ($this->id) {
$query = "select * from nomenclature_formations where id_formation = " . $this->id;
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
$row = pmb_mysql_fetch_object($result);
$this->set_name($row->formation_name);
$this->set_nature($row->formation_nature);
$this->set_order($row->formation_order);
//récupération des types
$query = "select id_type from nomenclature_types where type_formation_num = " . $this->id . " order by type_order asc";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
$this->add_type(new nomenclature_type($row->id_type));
}
}
}
}
}
function get_link_user()
{
global $dbh, $PMBuserid;
$requete = "SELECT * FROM search_perso";
if ($PMBuserid != 1) {
$requete .= " WHERE (autorisations='{$PMBuserid}' or autorisations like '{$PMBuserid} %' or autorisations like '% {$PMBuserid} %' or autorisations like '% {$PMBuserid}') ";
}
$requete .= " order by search_name ";
$myQuery = pmb_mysql_query($requete, $dbh);
$this->search_perso_user = array();
$link = "";
if (pmb_mysql_num_rows($myQuery)) {
$i = 0;
while ($r = pmb_mysql_fetch_object($myQuery)) {
if ($r->search_directlink) {
if ($r->search_shortname) {
$libelle = $r->search_shortname;
} else {
$libelle = $r->search_name;
}
$link .= "\n\t\t\t\t\t<span>\n\t\t\t\t\t\t<a href=\"javascript:document.forms['search_form" . $r->search_id . "'].submit();\">{$libelle}</a>\n\t\t\t\t\t</span>\n\t\t\t\t";
}
$this->search_perso_user[$i] = new stdClass();
$this->search_perso_user[$i]->id = $r->search_id;
$this->search_perso_user[$i]->name = $r->search_name;
$this->search_perso_user[$i]->shortname = $r->search_shortname;
$this->search_perso_user[$i]->query = $r->search_query;
$this->search_perso_user[$i]->human = $r->search_human;
$this->search_perso_user[$i]->directlink = $r->search_directlink;
$i++;
}
}
$this->directlink_user = $link;
return true;
}
public function fetch_datas()
{
global $dbh;
if ($this->id) {
//le nom de la famille
$query = "select family_name from nomenclature_families where id_family = " . $this->id;
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
$this->set_name($row->family_name);
}
//récupération des pupitres
$query = "select id_musicstand from nomenclature_musicstands where musicstand_famille_num = " . $this->id . " order by musicstand_order asc";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
$this->add_musicstand(new nomenclature_musicstand($row->id_musicstand));
}
}
}
} else {
$this->musicstands = array();
$this->name = "";
}
}
function show_orinot($dbh)
{
global $msg;
global $charset;
print "<table>\n\t<tr>\n\t\t<th>{$msg['orinot_nom']}</th>\n\t\t<th>{$msg['orinot_pays']}</th>\n\t\t<th>{$msg['orinot_diffusable']}</th>\n\t</tr>";
// affichage du tableau des statuts
$requete = "SELECT orinot_id, orinot_nom, orinot_pays, orinot_diffusion FROM origine_notice ORDER BY orinot_nom ";
$res = pmb_mysql_query($requete, $dbh);
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_object($res);
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=notices&sub=orinot&action=modif&id={$row->orinot_id}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>" . htmlentities($row->orinot_nom, ENT_QUOTES, $charset) . "</td><td>" . htmlentities($row->orinot_pays, ENT_QUOTES, $charset) . "</td>");
if ($row->orinot_diffusion) {
print "<td>{$msg['orinot_diffusable_oui']}</td>";
} else {
print "<td>{$msg['orinot_diffusable_non']}</td>";
}
print "</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['orinot_ajout']} ' onClick=\"document.location='./admin.php?categ=notices&sub=orinot&action=add'\" />";
}
function show_form($param = '')
{
//paramètres pré-enregistré
$value_param = array();
if ($param['form_jeu_sauv']) {
foreach ($param['form_jeu_sauv'] as $jeu_sauvegarde) {
$value_param[$jeu_sauvegarde] = $jeu_sauvegarde;
}
}
$requete = "select sauv_sauvegarde_id, sauv_sauvegarde_nom from sauv_sauvegardes";
$result = pmb_mysql_query($requete);
$nb_rows = pmb_mysql_num_rows($result);
//taille du selecteur
if ($nb_rows < 3) {
$nb = 3;
} else {
if ($nb_rows > 10) {
$nb = 10;
} else {
$nb = $nb_rows;
}
}
//Choix du ou des jeux de sauvegardes
$form_task .= "\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>\n\t\t\t\t<label for='jeu_sauv'>" . $this->msg["planificateur_backup_choice"] . "</label>\n\t\t\t</div>\n\t\t\t<div class='colonne_suite'>\n\t\t\t\t<select id='form_jeu_sauv' class='saisie-50em' name='form_jeu_sauv[]' size='" . $size_select . "' multiple>";
while ($row = pmb_mysql_fetch_object($result)) {
$form_task .= "<option value='" . $row->sauv_sauvegarde_id . "' " . ($value_param[$row->sauv_sauvegarde_id] == $row->sauv_sauvegarde_id ? 'selected=\'selected\'' : '') . ">" . $row->sauv_sauvegarde_nom . "</option>";
}
$form_task .= "</select>";
$form_task .= "</div></div>";
return $form_task;
}
public function get_datas()
{
$selector = $this->get_selected_selector();
if ($selector) {
$return = array();
if (count($selector->get_value()) > 0) {
foreach ($selector->get_value() as $value) {
$return[] = $value;
}
}
$return = $this->filter_datas("articles", $return);
if (count($return)) {
$query = "select id_article,if(article_start_date != '0000-00-00 00:00:00',article_start_date,article_creation_date) as publication_date from cms_articles where id_article in (" . implode(",", $return) . ")";
if ($this->parameters["sort_by"] != "") {
$query .= " order by " . $this->parameters["sort_by"];
if ($this->parameters["sort_order"] != "") {
$query .= " " . $this->parameters["sort_order"];
}
}
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$return = array();
while ($row = pmb_mysql_fetch_object($result)) {
$return[] = $row->id_article;
}
}
}
return $return;
}
return false;
}
protected function build_tree_sections($id_parent, $depth = 0)
{
global $dbh;
if ($this->parameters['max_depth'] == 0 || $depth < $this->parameters['max_depth']) {
$items = $ids = $rows = array();
$query = "select id_section,section_title from cms_sections where section_num_parent = " . $id_parent . " order by section_order asc";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
$ids[] = $row->id_section;
$rows[] = $row;
}
$ids = $this->filter_datas("sections", $ids);
foreach ($rows as $row) {
if (in_array($row->id_section, $ids)) {
$section = cms_provider::get_instance("section", $row->id_section);
$item = array('id' => $row->id_section, 'title' => $row->section_title, 'link' => $this->get_constructed_link("section", $row->id_section), 'details' => $section->format_datas(false, false));
$sub_query = "select count(id_section) from cms_sections where section_num_parent = " . $row->id_section;
$sub_result = pmb_mysql_query($sub_query, $dbh);
if (pmb_mysql_num_rows($result) && pmb_mysql_result($sub_result, 0, 0) > 0) {
$item['children'] = $this->build_tree_sections($row->id_section, $depth + 1);
}
$items[] = $item;
}
}
}
}
return $items;
}
function do_selector_bul_section($section_id, $location_id)
{
global $dbh;
global $charset;
global $deflt_section;
global $deflt_location;
if (!$section_id) {
$section_id = $deflt_section;
}
if (!$location_id) {
$location_id = $deflt_location;
}
$rqtloc = "SELECT idlocation FROM docs_location order by location_libelle";
$resloc = pmb_mysql_query($rqtloc, $dbh);
while ($loc = pmb_mysql_fetch_object($resloc)) {
$requete = "SELECT idsection, section_libelle FROM docs_section, docsloc_section where idsection=num_section and num_location='{$loc->idlocation}' order by section_libelle";
$result = pmb_mysql_query($requete, $dbh);
$nbr_lignes = pmb_mysql_num_rows($result);
if ($nbr_lignes) {
if ($loc->idlocation == $location_id) {
$selector .= "<div id=\"docloc_section" . $loc->idlocation . "\" style=\"display:block\">";
} else {
$selector .= "<div id=\"docloc_section" . $loc->idlocation . "\" style=\"display:none\">";
}
$selector .= "<select name='f_ex_section" . $loc->idlocation . "' id='f_ex_section" . $loc->idlocation . "'>";
while ($line = pmb_mysql_fetch_row($result)) {
$selector .= "<option value='{$line['0']}'";
$line[0] == $section_id ? $selector .= ' SELECTED>' : ($selector .= '>');
$selector .= htmlentities($line[1], ENT_QUOTES, $charset) . '</option>';
}
$selector .= '</select></div>';
}
}
return $selector;
}
function show_abts($dbh)
{
global $msg;
global $charset;
print "<table>\n\t\t<tr>\n\t\t<th>" . $msg[103] . "</th>\n\t\t<th style='display:none'>" . $msg["type_abts_prepay"] . "</th>\n\t\t<th style='display:none'>" . $msg["type_abts_prepay_dflt"] . "</th>\n\t\t<th>" . $msg["type_abts_tarif"] . "</th>\n\t\t<th>" . $msg["type_abts_caution"] . "</th>\n\t\t</tr>";
// affichage du tableau des utilisateurs
$requete = "SELECT id_type_abt, type_abt_libelle, prepay, prepay_deflt_mnt,tarif,caution FROM type_abts ORDER BY type_abt_libelle,id_type_abt";
$res = pmb_mysql_query($requete, $dbh);
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_row($res);
if ($row[2]) {
$prepay = "x";
}
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=finance&sub=abts&action=modif&id={$row['0']}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>" . htmlentities($row[1], ENT_QUOTES, $charset) . "</td>\n\t\t\t<td style='text-align:center;display:none'>{$prepay}</td><td style='display:none'>" . $row[3] . "</td><td>" . $row[4] . "</td><td>" . $row[5] . "</td>\n\t\t\t\t\t\t</tr>");
}
print "</table>\n\t\t<input class='bouton' type='button' value=\" " . $msg["type_abts_add"] . " \" onClick=\"document.location='./admin.php?categ=finance&sub=abts&action=add'\" />";
}
public function get_datas()
{
global $dbh;
$return = array();
$selector = $this->get_selected_selector();
if ($selector) {
$value = $selector->get_value();
if ($value['publisher'] != 0) {
$query = "select notice_id from notices where ed1_id = " . $value['publisher'] . ' and notice_id != ' . $value['record'];
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result) > 0) {
$return["title"] = "Du même éditeur";
$records = array();
while ($row = pmb_mysql_fetch_object($result)) {
$records[] = $row->notice_id;
}
}
$return['records'] = $this->filter_datas("notices", $records);
if ($this->parameters['nb_max_elements'] > 0) {
$return['records'] = array_slice($return['records'], 0, $this->parameters['nb_max_elements']);
}
}
return $return;
}
return false;
}
public function get_datas()
{
global $dbh;
$selector = $this->get_selected_selector();
if ($selector) {
$query = "select distinct notice_id \n\t\t\t\tfrom notices join notices_categories on notice_id=notcateg_notice \n\t\t\t\tjoin cms_articles_descriptors on cms_articles_descriptors.num_noeud=notices_categories.num_noeud \n\t\t\t\tand num_article=" . $selector->get_value();
$result = pmb_mysql_query($query, $dbh);
$return = array();
if ($result && pmb_mysql_num_rows($result) > 0) {
$return["title"] = "Liste de notices";
while ($row = pmb_mysql_fetch_object($result)) {
$return["records"][] = $row->notice_id;
}
}
$return['records'] = $this->filter_datas("notices", $return['records']);
$return['records'] = array_slice($return['records'], 0, $this->parameters['nb_max_elements']);
if (!count($return['records'])) {
return false;
}
// on tri par pertinence
$query = "SELECT notice_id\n\t\t\tFROM notices\n\t\t\tJOIN notices_categories ON notice_id = notcateg_notice\n\t\t\tJOIN cms_articles_descriptors ON cms_articles_descriptors.num_noeud = notices_categories.num_noeud\n\t\t\tAND num_article =" . $selector->get_value() . " where notice_id in(" . implode(',', $return['records']) . ")group by notice_id order by count(*) desc, create_date desc";
$result = pmb_mysql_query($query, $dbh);
$return = array();
if ($result && pmb_mysql_num_rows($result) > 0) {
$return["title"] = "Liste de notices";
while ($row = pmb_mysql_fetch_object($result)) {
$return["records"][] = $row->notice_id;
}
}
return $return;
}
return false;
}
public function get_datas()
{
//on commence par récupérer l'identifiant retourné par le sélecteur...
$selector = $this->get_selected_selector();
if ($selector) {
$section_id = $selector->get_value();
$section_ids = $this->filter_datas("sections", array($section_id));
if ($section_ids[0]) {
$sections = array();
$section_id = $section_ids[0];
$datas = array();
$i = 0;
do {
$i++;
$query = "select id_section,section_num_parent from cms_sections where id_section = " . $section_id;
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
$row = pmb_mysql_fetch_object($result);
$section_id = $row->section_num_parent;
$datas[] = $row->id_section;
} else {
break;
}
//en théorie on sort toujours, mais comme c'est un pays formidable, on lock à 100 itérations...
} while ($row->section_num_parent != 0 || $i > 100);
return array_reverse($datas);
}
}
return false;
}
function getData()
{
global $dbh, $msg;
$this->ntu_data = array();
if ($this->id) {
$requete = "SELECT * FROM notices_titres_uniformes WHERE ntu_num_notice={$this->id} order by ntu_ordre";
$result = pmb_mysql_query($requete, $dbh);
$nb_result = 0;
if (pmb_mysql_num_rows($result)) {
while ($res_tu = pmb_mysql_fetch_object($result)) {
$this->ntu_data[$nb_result] = new stdClass();
$this->ntu_data[$nb_result]->num_tu = $res_tu->ntu_num_tu;
$this->ntu_data[$nb_result]->titre = $res_tu->ntu_titre;
$this->ntu_data[$nb_result]->date = $res_tu->ntu_date;
$this->ntu_data[$nb_result]->sous_vedette = $res_tu->ntu_sous_vedette;
$this->ntu_data[$nb_result]->langue = $res_tu->ntu_langue;
$this->ntu_data[$nb_result]->version = $res_tu->ntu_version;
$this->ntu_data[$nb_result]->mention = $res_tu->ntu_mention;
$this->ntu_data[$nb_result]->tu = new titre_uniforme($this->ntu_data[$nb_result]->num_tu);
/* Champs récupérés du titre uniforme:
name
tonalite
comment
distrib (array)
ref (array)
subdiv (array)
*/
$nb_result++;
}
} else {
// pas trouvé avec cette clé
}
}
}
function show_procs($idcaddie)
{
global $msg;
global $PMBuserid;
global $dbh;
print "<hr />{$msg['caddie_select_proc']}<br /><table>";
// affichage du tableau des procédures
if ($PMBuserid != 1) {
$where = " and (autorisations='{$PMBuserid}' or autorisations like '{$PMBuserid} %' or autorisations like '% {$PMBuserid} %' or autorisations like '% {$PMBuserid}') ";
}
$requete = "SELECT idproc, type, name, requete, comment, autorisations, parameters FROM caddie_procs WHERE type='SELECT' {$where} ORDER BY name ";
$res = pmb_mysql_query($requete, $dbh);
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_row($res);
$rqt_autorisation = explode(" ", $row[5]);
if (array_search($PMBuserid, $rqt_autorisation) !== FALSE || $PMBuserid == 1) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
if (preg_match_all("|!!(.*)!!|U", $row[3], $query_parameters)) {
$action = "form_proc";
} else {
$action = "add_item";
}
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./catalog.php?categ=caddie&sub=collecte&moyen=selection&action={$action}&id={$row['0']}&idcaddie={$idcaddie}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<strong>{$row['2']}</strong><br />\n\t\t\t\t\t\t<small>{$row['4']} </small>\n\t\t\t\t\t\t</td>\n\t\t\t\t</tr>");
}
}
print "</table>";
}
public function get_datas()
{
$selector = $this->get_selected_selector();
if ($selector) {
$query = "select distinct id_article,if(article_start_date != '0000-00-00 00:00:00',article_start_date,article_creation_date) as publication_date from cms_articles join cms_articles_descriptors on id_article=num_article where num_article != '" . $selector->get_value() . "' and num_noeud in (select num_noeud from cms_articles_descriptors where num_article = '" . $selector->get_value() . "')";
if ($this->parameters["sort_by"] != "") {
$query .= " order by " . $this->parameters["sort_by"];
if ($this->parameters["sort_order"] != "") {
$query .= " " . $this->parameters["sort_order"];
}
}
$result = pmb_mysql_query($query);
$return = array();
if (pmb_mysql_num_rows($result) > 0) {
while ($row = pmb_mysql_fetch_object($result)) {
$return[] = $row->id_article;
}
}
$return = $this->filter_datas("articles", $return);
if ($this->parameters["nb_max_elements"] > 0) {
$return = array_slice($return, 0, $this->parameters["nb_max_elements"]);
}
return $return;
}
return false;
}
function check_write_permission()
{
global $webdav_current_user_id;
if ($this->config['write_permission']) {
$tab = array();
$query = "";
switch ($this->config['authentication']) {
case "gestion":
$tab = $this->config['restrcited_user_write_permission'];
$query = "select grp_num from users where userid = " . $webdav_current_user_id;
break;
case "opac":
$query = "select empr_categ from empr where id_empr = " . $webdav_current_user_id;
case "anonymous":
default:
$tab = $this->config['restrcited_empr_write_permission'];
break;
}
//pas de restriction, on est bon
if (!count($tab)) {
return true;
} elseif ($query != "") {
//on doit s'assurer que la personne connectée est dispose des droits...
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
if (in_array(pmb_mysql_result($result, 0, 0), $tab)) {
return true;
}
}
}
}
//si on est encore dans la fonction, c'est qu'on correspond à aucun critère !
return false;
}
public function get_datas()
{
global $dbh;
$return = array();
$selector = $this->get_selected_selector();
if ($selector) {
$value = $selector->get_value();
$records = array();
if (is_array($value) && count($value)) {
for ($i = 0; $i < count($value); $i++) {
$query = "select notice_id from notices where notice_id='" . $value[$i] . "'";
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result) > 0) {
$row = pmb_mysql_fetch_object($result);
$records[] = $row->notice_id;
}
}
$records = array_reverse($records);
$return['records'] = $this->filter_datas("notices", $records);
if ($this->parameters['nb_max_elements'] > 0) {
$return['records'] = array_slice($return['records'], 0, $this->parameters['nb_max_elements']);
}
}
return $return;
}
return false;
}
public function get_datas()
{
//on commence par récupérer l'identifiant retourné par le sélecteur...
if ($this->parameters['selector'] != "") {
for ($i = 0; $i < count($this->selectors); $i++) {
if ($this->selectors[$i]['name'] == $this->parameters['selector']) {
$selector = new $this->parameters['selector']($this->selectors[$i]['id']);
break;
}
}
$shelves = $selector->get_value();
if (is_array($shelves) && count($shelves)) {
foreach ($shelves as $shelve_id) {
$query = "select id_tri from etagere where idetagere =" . $shelve_id;
$result = pmb_mysql_query($query);
$records = $notices = array();
if ($result && pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_object($result)) {
notices_caddie($shelve_id, $notices, '', '', '', 0, $row->id_tri);
}
}
foreach ($notices as $id => $niv) {
$records[] = $id;
}
}
}
$records = $this->filter_datas("notices", $records);
if ($this->parameters['nb_max_elements'] > 0) {
$records = array_slice($records, 0, $this->parameters['nb_max_elements']);
}
$return = array('title' => 'Liste de Notices', 'records' => $records);
return $return;
}
return false;
}
