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 connection_mysql($er_connec = 1, $my_bd = '', $bd = 1, $er_bd = 1)
{
global $opac_nb_documents;
global $charset, $SQL_MOTOR_TYPE;
global $charset, $SQL_MOTOR_TYPE, $time_zone, $time_zone_mysql;
if (isset($time_zone) && trim($time_zone)) {
date_default_timezone_set($time_zone);
}
//Pour l'heure PHP
$my_connec = @pmb_mysql_connect(SQL_SERVER, USER_NAME, USER_PASS);
if ($my_connec == 0 && $er_connec == 1) {
die(my_error(0));
}
if ($bd) {
$my_bd == '' ? $my_bd = DATA_BASE : $my_bd;
if (pmb_mysql_select_db($my_bd, $my_connec) == 0 && $er_bd == 1) {
die(my_error(0));
}
}
$opac_nb_documents = @pmb_mysql_result(pmb_mysql_query("select count(*) from notices", $my_connec), 0, 0) * 1;
if ($charset == 'utf-8') {
pmb_mysql_query("set names utf8 ", $my_connec);
} else {
pmb_mysql_query("set names latin1 ", $my_connec);
}
if ($SQL_MOTOR_TYPE) {
pmb_mysql_query("set storage_engine={$SQL_MOTOR_TYPE}", $my_connec);
}
if (isset($time_zone_mysql) && trim($time_zone_mysql)) {
pmb_mysql_query("SET time_zone = {$time_zone_mysql}", $my_connec);
}
//Pour l'heure MySQL
return $my_connec;
}
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;
}
public function get_datas()
{
$selector = $this->get_selected_selector();
if ($selector) {
$tab_values = $selector->get_value();
if (!is_array($tab_values)) {
$tab_values = array($tab_values);
}
if (count($tab_values) > 0) {
$list_values = implode(",", $tab_values);
$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 num_section in (" . $list_values . ")";
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 ($result) {
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;
}
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;
}
function update_notice_infos($notice_id)
{
if ($notice_id * 1 > 0) {
$query = "update notices set indexint = " . $this->indexint->indexint_id . " where notice_id = " . $notice_id;
pmb_mysql_query($query);
}
}
function search_other_function_filters()
{
global $code_langue_restrict;
global $charset, $msg, $marc_liste_langues;
if (!$marc_liste_langues) {
$marc_liste_langues = new marc_list('lang');
}
$r = "<select name='code_langue_restrict'>";
$r .= "<option value=''>" . $msg[all_languages] . "</option>";
$requete = "select distinct code_langue from notices_langues where code_langue is not null and code_langue!='' order by ordre_langue";
$resultat = pmb_mysql_query($requete);
// on met les balises <option> dans un tableau, indexé par le nom traduit de la langue
$t = array();
while ($res = pmb_mysql_fetch_object($resultat)) {
if ($marc_liste_langues->table[$res->code_langue]) {
$s = "<option value='" . htmlentities($res->code_langue, ENT_QUOTES, $charset) . "' ";
if ($res->code_langue == $code_langue_restrict) {
$s .= "selected";
}
$s .= ">" . $marc_liste_langues->table[$res->code_langue];
$s .= "</option>";
$t[$marc_liste_langues->table[$res->code_langue]] = $s;
}
}
// tri le tableau selon les clés (ici les noms des langues, pas les codes)
ksort($t);
// recopie des balises triées dans la liste <select>
foreach ($t as $k => $v) {
$r .= $v;
}
$r .= "</select>";
return $r;
}
function traite_rqt($requete = "", $message = "")
{
global $dbh, $charset;
$retour = "";
/*if($charset == "utf-8"){ //Contrairement au addon ce n'est pas à faire car dans les fichiers alter_vX.inc.php on fait un set names latin1
$requete=utf8_encode($requete);
}*/
$res = pmb_mysql_query($requete, $dbh);
$erreur_no = pmb_mysql_errno();
if (!$erreur_no) {
$retour = "Successful";
} else {
switch ($erreur_no) {
case "1060":
$retour = "Field already exists, no problem.";
break;
case "1061":
$retour = "Key already exists, no problem.";
break;
case "1091":
$retour = "Object already deleted, no problem.";
break;
default:
$retour = "<font color=\"#FF0000\">Error may be fatal : <i>" . pmb_mysql_error() . "<i></font>";
break;
}
}
return "<tr><td><font size='1'>" . ($charset == "utf-8" ? utf8_encode($message) : $message) . "</font></td><td><font size='1'>" . $retour . "</font></td></tr>";
}
function update_avis($id)
{
global $dbh, $desc, $sujet, $msg, $charset;
header('Content-Type: text/html;charset=' . $charset);
$req = "update avis set sujet='" . $sujet . "', commentaire='" . $desc . "' where id_avis='" . $id . "'";
pmb_mysql_query($req, $dbh);
$requete = "select avis.note, avis.sujet, avis.commentaire, avis.id_avis, DATE_FORMAT(avis.dateAjout,'" . $msg[format_date] . "') as ladate, ";
$requete .= "empr_login, empr_nom, empr_prenom, ";
$requete .= "niveau_biblio, niveau_biblio, valide, notice_id ";
$requete .= "from avis ";
$requete .= "left join empr on empr.id_empr=avis.num_empr ";
$requete .= "left join notices on notices.notice_id=avis.num_notice ";
$requete .= "where id_avis='" . $id . "'";
$requete .= "order by index_serie, tnvol, index_sew ,dateAjout desc ";
$res = pmb_mysql_query($requete, $dbh);
while ($loc = pmb_mysql_fetch_object($res)) {
$display = "\n\t\t\t<div class='left'>\n\t\t\t\t<input type='checkbox' name='valid_id_avis[]' id='valid_id_avis[]' value='{$loc->id_avis}' onClick=\"stop_evenement(event);\" />";
if (!$loc->valide) {
$display .= "<font color='#CC0000'>" . $msg[gestion_avis_note] . " <span >" . htmlentities($loc->note, ENT_QUOTES, $charset) . " <b>" . htmlentities($loc->sujet, ENT_QUOTES, $charset) . "</b></span></font>";
} else {
$display .= "<font color='#00BB00'>" . $msg[gestion_avis_note] . " <span >" . htmlentities($loc->note, ENT_QUOTES, $charset) . " <b>" . htmlentities($loc->sujet, ENT_QUOTES, $charset) . "</b></span></font>";
}
if ($charset != "utf-8") {
$loc->commentaire = cp1252Toiso88591($loc->commentaire);
}
$display .= ", " . htmlentities($loc->ladate, ENT_QUOTES, $charset) . " " . htmlentities($loc->empr_prenom . " " . $loc->empr_nom, ENT_QUOTES, $charset) . "\n\t\t\t</div>\n\t\t\t<div class='row'>" . do_bbcode($loc->commentaire) . "\t</div>\n\t\t";
}
print $display;
}
public function get_value()
{
global $dbh;
if ($this->parameters['sub_selector']) {
$sub_selector = new $this->parameters['sub_selector']($this->get_sub_selector_id($this->parameters['sub_selector']));
$values = $sub_selector->get_value();
if (!is_array($values)) {
if ($values != "") {
$values = array($values);
} else {
$values = array();
}
}
if (count($values)) {
$tagslist = array();
switch ($this->parameters['sub_selector']) {
case "cms_module_item_selector_item_generic":
$query = "select id_tag from docwatch_tags left join docwatch_items_tags on num_tag=id_tag where num_item in (" . implode(",", $values) . ")";
$result = pmb_mysql_query($query, $dbh);
if ($result) {
while ($row = pmb_mysql_fetch_object($result)) {
$tagslist[] = $row->id_tag;
}
}
return $tagslist;
break;
case "cms_module_common_selector_env_var":
return $values;
break;
}
}
}
return array();
}
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 cree_export_notices($liste = array(), $typeexport = 'pmbxml2marciso', $expl = 1)
{
global $base_path;
global $keep_expl, $dbh;
$keep_expl = $expl;
// Récupération des notices
$n_notices = count($liste);
if ($n_notices == 0) {
return "";
} else {
$_SESSION["param_export"]["notice_exporte"] = array();
// Export !
$z = 0;
$e_notice = "";
while ($z < count($liste)) {
$id = $liste[$z];
// Exclure de l'export (opac, panier) les fiches interdites de diffusion dans administration, Notices > Origines des notices NG72
$sql = "select orinot_diffusion from origine_notice,notices where notice_id = '{$id}' and origine_catalogage = orinot_id";
$res = pmb_mysql_query($sql, $dbh);
$diffusable = pmb_mysql_result($res, 0, 0);
if ($diffusable) {
$export = new start_export($id, $typeexport);
$e_notice .= $export->output_notice;
$z++;
} else {
$z++;
}
}
}
return $e_notice;
}
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 genere_page_rss($id = 0)
{
global $dbh, $opac_url_base, $charset, $msg;
global $opac_view_filter_class;
if ($id) {
$clause = " where id_rss_flux='{$id}' ";
}
$rqt = "select id_rss_flux, nom_rss_flux, img_url_rss_flux from rss_flux {$clause} order by 2 ";
$res = pmb_mysql_query($rqt, $dbh);
while ($obj = pmb_mysql_fetch_object($res)) {
if ($opac_view_filter_class) {
if (!$opac_view_filter_class->is_selected("flux_rss", $obj->id_rss_flux)) {
continue;
}
}
$liens .= "\n\t\t<tr>\n\t\t\t<td width=10%>";
if ($obj->img_url_rss_flux) {
$liens .= "<a href=\"index.php?lvl=rss_see&id=" . $obj->id_rss_flux . "\"><img src='" . $obj->img_url_rss_flux . "' border=none /></a>";
}
$liens .= "</td><td width=50%><a href=\"index.php?lvl=rss_see&id=" . $obj->id_rss_flux . "\">" . htmlentities($obj->nom_rss_flux, ENT_QUOTES, $charset) . "</a>\n\t\t\t</td><td><a href=\"" . $opac_url_base . "rss.php?id=" . $obj->id_rss_flux . "\" alt=\"" . $msg[abonne_rss_dispo] . "\" title=\"" . $msg[abonne_rss_dispo] . "\"><img id=\"rss_logo\" src='" . $opac_url_base . "images/rss.png' border=none /></a>\n\t\t\t" . htmlentities($opac_url_base . "rss.php?id=" . $obj->id_rss_flux, ENT_QUOTES, $charset) . "\n\t\t\t\t</td></tr>";
}
if ($liens) {
$liens = "<table> {$liens} </table>";
}
return $liens;
}
function calcNumero($id_entite, $type_acte)
{
global $dbh;
global $acquisition_format;
$p = array();
$p = explode(",", $acquisition_format);
$prefix = $p[$type_acte + 1];
//recuperation du dernier numero pour le type d'acte concerné et l'entité en cours
$q = "select max(substring(numero," . (strlen($prefix) + 1) . ")*1) from actes where type_acte = '" . $type_acte . "' ";
$q .= "and num_entite = '" . $id_entite . "' ";
$r = pmb_mysql_query($q, $dbh);
$res = pmb_mysql_result($r, 0, 0);
if (!$res) {
$res = '0';
}
//creation du numéro avec prefixe et padding
$res++;
$numero = $prefix;
if ($p[0] != 0) {
$numero = str_pad($numero, $p[0] - strlen($res) + strlen($prefix), '0') . $res;
} else {
$numero = $numero . $res;
}
return $numero;
}
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;
}
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 $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;
}
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;
}
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;
}
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);
}
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>";
}
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 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;
}
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 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 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));
}
}
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()
{
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;
}
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));
}
}
}
}
}
