本文整理汇总了PHP中pmb_mysql_error函数的典型用法代码示例。如果您正苦于以下问题:PHP pmb_mysql_error函数的具体用法?PHP pmb_mysql_error怎么用?PHP pmb_mysql_error使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了pmb_mysql_error函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: traite_rqt
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>";
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:29,代码来源:alter.php
示例2: getData
function getData()
{
global $dbh;
if (!$this->s_id) {
// pas d'identifiant. on retourne un tableau vide
$this->s_id = 0;
$this->name = '';
$this->index = '';
$this->num_statut = 1;
} else {
$requete = "SELECT * FROM series WHERE serie_id='" . $this->s_id . "' ";
$result = pmb_mysql_query($requete, $dbh) or die($requete . "<br />" . pmb_mysql_error());
if (pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$this->s_id = $temp->serie_id;
$this->name = $temp->serie_name;
$this->index = $temp->serie_index;
$authority = new authority(0, $this->s_id, AUT_TABLE_SERIES);
$this->num_statut = $authority->get_num_statut();
// Ajoute un lien sur la fiche série si l'utilisateur à accès aux autorités
if (SESSrights & AUTORITES_AUTH) {
//$this->isbd_entry_lien_gestion = "<a href='./autorites.php?categ=series&sub=serie_form&id=".$this->s_id."' class='lien_gestion'>".$this->name."</a>";
$this->isbd_entry_lien_gestion = "<a href='./autorites.php?categ=see&sub=serie&id=" . $this->s_id . "' class='lien_gestion'>" . $this->name . "</a>";
} else {
$this->isbd_entry_lien_gestion = $this->name;
}
} else {
// pas de titre avec cette clé
$this->s_id = 0;
$this->name = '';
$this->index = '';
$this->num_statut = 1;
}
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:35,代码来源:serie.class.php
示例3: getData
function getData()
{
global $dbh;
if (!$this->indexint_id) {
if ($this->name) {
// rech par cote et non par $id
$requete = "SELECT indexint_id,indexint_name,indexint_comment,num_pclass FROM indexint WHERE indexint_name='" . $this->name . "' ";
$result = pmb_mysql_query($requete, $dbh) or die($requete . "<br />" . pmb_mysql_error());
if (pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$this->indexint_id = $temp->indexint_id;
$this->name = $temp->indexint_name;
$this->comment = $temp->indexint_comment;
$this->pclass = $temp->num_pclass;
if ($this->comment) {
$this->display = $this->name . " ({$this->comment})";
} else {
$this->display = $this->name;
}
} else {
// pas de titre avec cette clé
$this->indexint_id = 0;
$this->name = '';
$this->comment = '';
$this->pclass = 0;
$this->display = "";
}
} else {
// pas d'identifiant. on retourne un tableau vide
$this->indexint_id = 0;
$this->name = '';
$this->comment = '';
$this->pclass = 0;
$this->display = "";
}
} else {
$requete = "SELECT indexint_id,indexint_name,indexint_comment,num_pclass FROM indexint WHERE indexint_id='" . $this->indexint_id . "' ";
$result = pmb_mysql_query($requete, $dbh) or die($requete . "<br />" . pmb_mysql_error());
if (pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$this->indexint_id = $temp->indexint_id;
$this->name = $temp->indexint_name;
$this->comment = $temp->indexint_comment;
$this->pclass = $temp->num_pclass;
if ($this->comment) {
$this->display = $this->name . " ({$this->comment})";
} else {
$this->display = $this->name;
}
} else {
// pas de titre avec cette clé
$this->indexint_id = 0;
$this->name = '';
$this->comment = '';
$this->pclass = 0;
$this->display = "";
}
}
$this->cherche_child();
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:60,代码来源:indexint.class.php
示例4: traite_rqt
function traite_rqt($requete = "", $message = "")
{
global $dbh, $charset;
$retour = "";
if ($charset == "utf-8") {
$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>";
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:29,代码来源:addon.inc.php
示例5: cpt_transferts
function cpt_transferts($clause_where)
{
global $deflt_docs_location;
global $msg;
$rqt = "SELECT 1 " . "FROM transferts " . "INNER JOIN transferts_demande ON id_transfert = num_transfert " . "WHERE " . $clause_where . " " . "LIMIT 1";
//echo $rqt."<br />";
$req = pmb_mysql_query($rqt) or die($msg["err_sql"] . "<br />" . $rqt . "<br />" . pmb_mysql_error());
$nb_limite = pmb_mysql_num_rows($req);
return $nb_limite;
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:10,代码来源:transferts.inc.php
示例6: my_error
function my_error($echo = 1)
{
if (!pmb_mysql_errno()) {
return "";
}
$erreur = 'erreur ' . pmb_mysql_errno() . ' : ' . pmb_mysql_error() . '<br />';
if ($echo) {
echo $erreur;
} else {
trigger_error($erreur, E_USER_ERROR);
return $erreur;
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:13,代码来源:mysql_connect.inc.php
示例7: alerte_demandes
function alerte_demandes()
{
global $dbh;
global $msg;
// comptage des demandes à valider
$sql = " SELECT 1 FROM demandes where etat_demande=1 limit 1";
$req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
$nb_limite = pmb_mysql_num_rows($req);
if (!$nb_limite) {
return "";
} else {
return "<li><a href='./demandes.php?categ=list&idetat=1' target='_parent'>{$msg['alerte_demandes_traiter']}</a></li>";
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:14,代码来源:demandes.inc.php
示例8: get_info_surloc_from_location
static function get_info_surloc_from_location($id_docs_location = 0)
{
global $dbh;
if ($id_docs_location) {
$requete = "SELECT * FROM docs_location where idlocation='{$id_docs_location}'";
$res = pmb_mysql_query($requete, $dbh) or die(pmb_mysql_error() . "<br />{$requete}");
if (pmb_mysql_num_rows($res)) {
$row = pmb_mysql_fetch_object($res);
if ($row->surloc_num) {
$sur_loc = new sur_location($row->surloc_num);
return $sur_loc;
}
}
}
return $sur_loc = new sur_location();
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:16,代码来源:sur_location.class.php
示例9: expl_retour_todo
function expl_retour_todo()
{
global $dbh;
global $msg;
global $deflt_docs_location;
if (!$deflt_docs_location) {
return "";
}
$sql = "SELECT expl_id FROM exemplaires where expl_retloc='{$deflt_docs_location}' limit 1";
$req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
$nb = pmb_mysql_num_rows($req);
if (!$nb) {
return "";
} else {
return "<li><a href='./circ.php?categ=ret_todo' target='_parent'>" . $msg["alert_circ_retour_todo"] . "</a></li>";
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:17,代码来源:expl_todo.inc.php
示例10: alerte_sugg
function alerte_sugg()
{
global $dbh;
global $msg;
global $opac_show_suggest;
if (!$opac_show_suggest) {
return "";
}
// comptage des tags à valider
$sql = " SELECT 1 FROM suggestions where statut=1 limit 1";
$req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
$nb_limite = pmb_mysql_num_rows($req);
if (!$nb_limite) {
return "";
} else {
return "<li><a href='./acquisition.php?categ=sug&action=list&statut=1' target='_parent'>{$msg['alerte_suggestion_traiter']}</a></li>";
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:18,代码来源:sugg.inc.php
示例11: alerte_avis
function alerte_avis()
{
global $dbh;
global $msg;
global $opac_avis_allow;
if (!$opac_avis_allow) {
return "";
}
// comptage des avis à valider
$sql = " SELECT 1 FROM avis where valide=0 limit 1";
$req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
$nb_depasse = pmb_mysql_num_rows($req);
if (!$nb_depasse) {
return "";
} else {
return "<li><a href='./catalog.php?categ=avis' target='_parent'>{$msg['alerte_avis_a_valider']}</a></li>";
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:18,代码来源:tag.inc.php
示例12: get_info_expl
function get_info_expl($cb_doc)
{
global $dbh, $msg;
$requete = "SELECT notices_m.notice_id as m_id, notices_s.notice_id as s_id, expl_cb, expl_cote, expl_location,pret_date, pret_retour, tdoc_libelle, section_libelle, location_libelle, trim(concat(ifnull(notices_m.tit1,''),ifnull(notices_s.tit1,''),' ',ifnull(bulletin_numero,''), if (mention_date, concat(' (',mention_date,')') ,''))) as tit, ";
$requete .= " date_format(pret_date, '" . $msg["format_date"] . "') as aff_pret_date, ";
$requete .= " date_format(pret_retour, '" . $msg["format_date"] . "') as aff_pret_retour, ";
$requete .= " IF(pret_retour>sysdate(),0,1) as retard, notices_m.tparent_id, notices_m.tnvol ";
$requete .= " FROM (((exemplaires LEFT JOIN notices AS notices_m ON expl_notice = notices_m.notice_id ) LEFT JOIN bulletins ON expl_bulletin = bulletins.bulletin_id) LEFT JOIN notices AS notices_s ON bulletin_notice = notices_s.notice_id), docs_type, docs_section, docs_location, pret ";
$requete .= " WHERE expl_cb='" . $cb_doc . "' and expl_typdoc = idtyp_doc and expl_section = idsection and expl_location = idlocation and pret_idexpl = expl_id ";
$res = pmb_mysql_query($requete, $dbh) or die("<br />" . pmb_mysql_error());
$expl = pmb_mysql_fetch_object($res);
$responsabilites = get_notice_authors($expl->m_id + $expl->s_id);
$as = array_search("0", $responsabilites["responsabilites"]);
if ($as !== FALSE && $as !== NULL) {
$auteur_0 = $responsabilites["auteurs"][$as];
$auteur = new auteur($auteur_0["id"]);
$header_aut .= $auteur->isbd_entry;
} else {
$aut1_libelle = array();
$as = array_keys($responsabilites["responsabilites"], "1");
for ($i = 0; $i < count($as); $i++) {
$indice = $as[$i];
$auteur_1 = $responsabilites["auteurs"][$indice];
$auteur = new auteur($auteur_1["id"]);
$aut1_libelle[] = $auteur->isbd_entry;
}
$header_aut .= implode(", ", $aut1_libelle);
}
$header_aut ? $auteur = " / " . $header_aut : ($auteur = "");
$expl->header_aut = $header_aut;
// récupération du titre de série
if ($expl->tparent_id && $expl->m_id) {
$parent = new serie($expl->tparent_id);
$tit_serie = $parent->name;
if ($expl->tnvol) {
$tit_serie .= ', ' . $expl->tnvol;
}
}
if ($tit_serie) {
$expl->tit = $tit_serie . '. ' . $expl->tit;
}
return $expl;
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:43,代码来源:func.inc.php
示例13: add_days
static function add_days($dd, $md, $yd, $days)
{
global $pmb_utiliser_calendrier;
global $deflt2docs_location;
if ($pmb_utiliser_calendrier) {
$requete = "select min(date_ouverture) from ouvertures where ouvert=1 and num_location={$deflt2docs_location} and date_ouverture>=adddate('" . $yd . "-" . $md . "-" . $dd . "', interval {$days} day)";
$resultat = pmb_mysql_query($requete) or die($requete . " " . pmb_mysql_error());
if (!@pmb_mysql_num_rows($resultat)) {
$requete = "select adddate('" . $yd . "-" . $md . "-" . $dd . "', interval {$days} day)";
$resultat = pmb_mysql_query($requete) or die($requete . " " . pmb_mysql_error());
}
if ($date = pmb_mysql_result($resultat, 0, 0)) {
return $date;
}
}
$requete = "select adddate('" . $yd . "-" . $md . "-" . $dd . "', interval {$days} day)";
$resultat = pmb_mysql_query($requete) or die($requete . " " . pmb_mysql_error());
$date = pmb_mysql_result($resultat, 0, 0);
return $date;
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:20,代码来源:calendar.class.php
示例14: empr_categ_change
function empr_categ_change()
{
global $dbh;
global $msg;
global $pmb_lecteurs_localises, $deflt2docs_location;
// comptage des emprunteurs qui n'ont pas le droit d'être dans la catégorie
$sql = "select 1 from empr left join empr_categ on empr_categ = id_categ_empr ";
$sql .= " where ((((age_min<> 0) || (age_max <> 0)) && (age_max >= age_min)) && (((DATE_FORMAT( curdate() , '%Y' )-empr_year) < age_min) || ((DATE_FORMAT( curdate() , '%Y' )-empr_year) > age_max)))";
// restriction localisation le cas échéant
if ($pmb_lecteurs_localises) {
$sql .= " AND empr_location='{$deflt2docs_location}' ";
}
$req = pmb_mysql_query($sql) or die($msg["err_sql"] . "<br />" . $sql . "<br />" . pmb_mysql_error());
$nb_change = pmb_mysql_num_rows($req);
if (!$nb_change) {
return "";
} else {
return "<li><a href='./edit.php?categ=empr&sub=categ_change' target='_parent'>{$msg['empr_change_categ_todo']}</a></li>";
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:20,代码来源:empr.inc.php
示例15: getData
function getData()
{
global $dbh;
if ($this->idlender == "") {
// pas d'identifiant. on retourne un tableau vide
$this->idlender = 0;
$this->lender_libelle = "";
} else {
$requete = "SELECT idlender, lender_libelle FROM lenders WHERE idlender='" . $this->idlender . "' LIMIT 1 " or die(pmb_mysql_error());
$result = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$this->idlender = $temp->idlender;
$this->lender_libelle = $temp->lender_libelle;
} else {
// pas de lender avec cette clé
$this->idlender = 0;
$this->lender_libelle = "";
}
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:21,代码来源:lender.class.php
示例16: show_procs
function show_procs($dbh)
{
global $msg;
global $PMBuserid;
print "<hr /><table>";
// affichage du tableau des procédures
if ($PMBuserid != 1) {
$where = " where (autorisations='{$PMBuserid}' or autorisations like '{$PMBuserid} %' or autorisations like '% {$PMBuserid} %' or autorisations like '% {$PMBuserid}') ";
}
$requete = "SELECT idproc, type, name, requete, comment, autorisations FROM empr_caddie_procs {$where} ORDER BY type, name ";
$res = pmb_mysql_query($requete, $dbh) or die(pmb_mysql_error() . $requete);
$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;
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./circ.php?categ=caddie&sub=gestion&quoi=procs&action=modif&id={$row['0']}';\" ";
print "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>\n \t\t<td width='10'>\n \t\t";
if ($row[1] != "ACTION") {
print "\t<input class='bouton' type='button' value=' {$msg['procs_options_tester_requete']} ' onClick=\"document.location='./circ.php?categ=caddie&sub=gestion&quoi=procs&action=execute&id={$row['0']}'\" />";
} else {
print " ";
}
print "\n\t\t\t\t\t</td>\n\t\t\t\t\t<td width='80'>\n\t\t\t\t\t\t{$row['1']}\n\t\t\t\t\t\t</td>\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\t<td>";
if (preg_match_all("|!!(.*)!!|U", $row[3], $query_parameters)) {
print "<a href='./circ.php?categ=caddie&sub=gestion&quoi=procs&action=configure&id_query=" . $row[0] . "'>{$msg['procs_options_config_param']}</a>";
}
print "</td>";
print "<td><input class='bouton' type='button' value=\"" . $msg[procs_bt_export] . "\" onClick=\"document.location='./export.php?quoi=procs&sub=empr_caddie&id={$row['0']}'\" /></td>\n\t\t\t\t\t\t</tr>";
}
}
print "</table><hr />\n\t\t<input class='bouton' type='button' value=' {$msg['704']} ' onClick=\"document.location='./circ.php?categ=caddie&sub=gestion&quoi=procs&action=add'\" />\n\t\t<input class='bouton' type='button' value=' {$msg['procs_bt_import']} ' onClick=\"document.location='./circ.php?categ=caddie&sub=gestion&quoi=procs&action=import'\" />";
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:40,代码来源:procs.inc.php
示例17: getData
function getData()
{
global $dbh;
global $msg;
if (!$this->id_equation) {
// pas d'identifiant. on retourne un tableau vide
$this->id_equation = 0;
$this->num_classement = 1;
$this->nom_equation = "";
$this->comment_equation = "";
$this->requete = "";
$this->proprio_equation = 0;
$this->human_query = "";
} else {
$requete = "SELECT id_equation, num_classement, nom_equation,comment_equation,requete, proprio_equation FROM equations WHERE id_equation='" . $this->id_equation . "' ";
$result = pmb_mysql_query($requete, $dbh) or die($requete . "<br /> in equation.class.php : " . pmb_mysql_error());
if (pmb_mysql_num_rows($result)) {
$temp = pmb_mysql_fetch_object($result);
$this->id_equation = $temp->id_equation;
$this->num_classement = $temp->num_classement;
$this->nom_equation = $temp->nom_equation;
$this->comment_equation = $temp->comment_equation;
$this->requete = $temp->requete;
$this->proprio_equation = $temp->proprio_equation;
$this->human_query = $this->search_class->make_serialized_human_query($this->requete);
} else {
// pas de bannette avec cette clé
$this->id_equation = 0;
$this->num_classement = 1;
$this->nom_equation = "";
$this->comment_equation = "";
$this->requete = "";
$this->proprio_equation = 0;
$this->human_query = "";
}
}
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:37,代码来源:equation.class.php
示例18: opacitem_globals_list
//.........这里部分代码省略.........
break;
case 'cms_module_opacitem_item_bannettes_abo':
global $opac_show_subscribed_bannettes;
global $opac_bannette_nb_liste;
global $opac_bannette_notices_format;
global $opac_bannette_notices_depliables;
$globals_list['opac_show_subscribed_bannettes']['value'] = $opac_show_subscribed_bannettes;
$globals_list['opac_bannette_nb_liste']['value'] = $opac_bannette_nb_liste;
$globals_list['opac_bannette_notices_format']['value'] = $opac_bannette_notices_format;
$globals_list['opac_bannette_notices_depliables']['value'] = $opac_bannette_notices_depliables;
break;
case 'cms_module_opacitem_item_bannettes_pub':
global $opac_show_public_bannettes;
global $opac_bannette_nb_liste;
global $opac_bannette_notices_format;
global $opac_bannette_notices_depliables;
$globals_list['opac_show_public_bannettes']['value'] = $opac_show_public_bannettes;
$globals_list['opac_bannette_nb_liste']['value'] = $opac_bannette_nb_liste;
$globals_list['opac_bannette_notices_format']['value'] = $opac_bannette_notices_format;
$globals_list['opac_bannette_notices_depliables']['value'] = $opac_bannette_notices_depliables;
break;
case 'cms_module_opacitem_item_section':
global $opac_show_section_browser;
global $opac_sur_location_activate;
global $opac_nb_localisations_per_line;
$globals_list['opac_show_section_browser']['value'] = $opac_show_section_browser;
$globals_list['opac_sur_location_activate']['value'] = $opac_sur_location_activate;
$globals_list['opac_nb_localisations_per_line']['value'] = $opac_nb_localisations_per_line;
break;
case 'cms_module_opacitem_item_margueritte':
global $opac_show_marguerite_browser;
$globals_list['opac_show_marguerite_browser']['value'] = $opac_show_marguerite_browser;
break;
case 'cms_module_opacitem_item_centcases':
global $opac_show_100cases_browser;
$globals_list['opac_show_100cases_browser']['value'] = $opac_show_100cases_browser;
break;
case 'cms_module_opacitem_item_dernotices':
global $opac_show_dernieresnotices;
global $opac_show_dernieresnotices_nb;
$globals_list['opac_show_dernieresnotices']['value'] = $opac_show_dernieresnotices;
$globals_list['opac_show_dernieresnotices_nb']['value'] = $opac_show_dernieresnotices_nb;
break;
case 'cms_module_opacitem_item_etageres':
global $opac_show_etageresaccueil;
global $opac_etagere_nbnotices_accueil;
global $opac_etagere_notices_format;
global $opac_etagere_notices_depliables;
global $opac_websubscribe_show;
global $opac_password_forgotten_show;
global $opac_photo_filtre_mimetype;
global $opac_explnum_order;
global $opac_show_links_invisible_docnums;
global $opac_photo_mean_size_x;
global $opac_photo_mean_size_y;
global $opac_photo_watermark;
global $opac_photo_watermark_transparency;
global $opac_default_sort;
global $opac_default_sort_list;
global $opac_nb_max_criteres_tri;
global $opac_etagere_order;
global $opac_etagere_notices_order;
$globals_list['opac_show_etageresaccueil']['value'] = $opac_show_etageresaccueil;
$globals_list['opac_etagere_nbnotices_accueil']['value'] = $opac_etagere_nbnotices_accueil;
$globals_list['opac_etagere_notices_format']['value'] = $opac_etagere_notices_format;
$globals_list['opac_etagere_notices_depliables']['value'] = $opac_etagere_notices_depliables;
$globals_list['opac_websubscribe_show']['value'] = $opac_websubscribe_show;
$globals_list['opac_password_forgotten_show']['value'] = $opac_password_forgotten_show;
$globals_list['opac_photo_filtre_mimetype']['value'] = $opac_photo_filtre_mimetype;
$globals_list['opac_explnum_order']['value'] = $opac_explnum_order;
$globals_list['opac_show_links_invisible_docnums']['value'] = $opac_show_links_invisible_docnums;
$globals_list['opac_photo_mean_size_x']['value'] = $opac_photo_mean_size_x;
$globals_list['opac_photo_mean_size_y']['value'] = $opac_photo_mean_size_y;
$globals_list['opac_photo_watermark']['value'] = $opac_photo_watermark;
$globals_list['opac_photo_watermark_transparency']['value'] = $opac_photo_watermark_transparency;
$globals_list['opac_default_sort']['value'] = $opac_default_sort;
$globals_list['opac_default_sort_list']['value'] = $opac_default_sort_list;
$globals_list['opac_nb_max_criteres_tri']['value'] = $opac_nb_max_criteres_tri;
$globals_list['opac_etagere_order']['value'] = $opac_etagere_order;
$globals_list['opac_etagere_notices_order']['value'] = $opac_etagere_notices_order;
break;
case 'cms_module_opacitem_item_rssflux':
global $opac_show_rss_browser;
global $opac_curl_available;
$globals_list['opac_show_rss_browser']['value'] = $opac_show_rss_browser;
$globals_list['opac_curl_available']['value'] = $opac_curl_available;
break;
}
}
$query = 'SELECT type_param,sstype_param,comment_param FROM parametres WHERE CONCAT(type_param,"_",sstype_param) IN ("' . implode('","', array_keys($globals_list)) . '")';
$result = pmb_mysql_query($query);
if (!pmb_mysql_error() && pmb_mysql_num_rows($result)) {
while ($param = pmb_mysql_fetch_array($result, MYSQL_ASSOC)) {
if (sizeof($globals_list[$param['type_param'] . '_' . $param['sstype_param']])) {
$globals_list[$param['type_param'] . '_' . $param['sstype_param']] += $param;
}
}
}
return $globals_list;
}
开发者ID:noble82,项目名称:proyectos-ULS,代码行数:101,代码来源:cms_module_opacitem_selector_opacitem.class.php
示例19: show_expl_per_notice
function show_expl_per_notice($no_notice, $link_expl = '', $expl_bulletin = 0)
{
global $msg, $dbh, $base_path, $class_path;
global $explr_invisible, $explr_visible_unmod, $explr_visible_mod, $pmb_droits_explr_localises, $transferts_gestion_transferts;
global $pmb_expl_list_display_comments;
global $pmb_sur_location_activate;
global $pmb_url_base, $pmb_expl_data, $charset;
global $pmb_expl_display_location_without_expl;
global $pmb_html_allow_expl_cote;
// params :
// $no_notice= id de la notice
// $link_expl= lien associé à l'exemplaire avec !!expl_id!! et !!expl_cb!! à mettre à jour
if (!$no_notice && !$expl_bulletin) {
return;
}
$explr_tab_invis = explode(",", $explr_invisible);
$explr_tab_unmod = explode(",", $explr_visible_unmod);
$explr_tab_modif = explode(",", $explr_visible_mod);
// récupération du nombre total d'exemplaires
if ($expl_bulletin) {
$requete = "SELECT COUNT(1) FROM exemplaires WHERE expl_bulletin='{$expl_bulletin}' ";
} else {
$requete = "SELECT COUNT(1) FROM exemplaires WHERE expl_notice='{$no_notice}' ";
}
$res = pmb_mysql_query($requete, $dbh);
$nb_ex = pmb_mysql_result($res, 0, 0);
if ($nb_ex) {
// on récupère les données des exemplaires
// visibilité des exemplaires:
if ($pmb_droits_explr_localises && $explr_invisible) {
$where_expl_localises = "and expl_location not in ({$explr_invisible})";
} else {
$where_expl_localises = "";
}
//Liste des champs d'exemplaires
if ($pmb_sur_location_activate) {
$surloc_field = "surloc_libelle,";
}
if (!$pmb_expl_data) {
$pmb_expl_data = "expl_cb,expl_cote," . $surloc_field . "location_libelle,section_libelle,statut_libelle,tdoc_libelle";
}
$colonnesarray = explode(",", $pmb_expl_data);
if (!in_array("expl_cb", $colonnesarray)) {
array_unshift($colonnesarray, "expl_cb");
}
$total_columns = count($colonnesarray);
//Présence de champs personnalisés
if (strstr($pmb_expl_data, "#")) {
require_once $class_path . "/parametres_perso.class.php";
$cp = new parametres_perso("expl");
}
if ($expl_bulletin) {
$where_expl_notice_expl_bulletin = " expl_bulletin='{$expl_bulletin}' ";
} else {
$where_expl_notice_expl_bulletin = " expl_notice='{$no_notice}' ";
}
$requete = "SELECT exemplaires.*, pret.*, docs_location.*, docs_section.*, docs_statut.*, docs_codestat.*, lenders.*, tdoc_libelle, ";
if (in_array("surloc_libelle", $colonnesarray)) {
$requete .= "sur_location.*, ";
}
$requete .= " date_format(pret_date, '" . $msg["format_date"] . "') as aff_pret_date, ";
$requete .= " date_format(pret_retour, '" . $msg["format_date"] . "') as aff_pret_retour, ";
$requete .= " IF(pret_retour>sysdate(),0,1) as retard ";
$requete .= " FROM exemplaires LEFT JOIN pret ON exemplaires.expl_id=pret.pret_idexpl ";
$requete .= " left join docs_location on exemplaires.expl_location=docs_location.idlocation ";
if (in_array("surloc_libelle", $colonnesarray)) {
$requete .= " left join sur_location on docs_location.surloc_num=sur_location.surloc_id ";
}
$requete .= " left join docs_section on exemplaires.expl_section=docs_section.idsection ";
$requete .= " left join docs_statut on exemplaires.expl_statut=docs_statut.idstatut ";
$requete .= " left join docs_codestat on exemplaires.expl_codestat=docs_codestat.idcode ";
$requete .= " left join lenders on exemplaires.expl_owner=lenders.idlender ";
$requete .= " left join docs_type on exemplaires.expl_typdoc=docs_type.idtyp_doc ";
$requete .= " WHERE {$where_expl_notice_expl_bulletin} {$where_expl_localises} ";
if (in_array("surloc_libelle", $colonnesarray)) {
$requete .= " order by surloc_libelle,location_libelle, section_libelle, expl_cote, expl_cb ";
} else {
$requete .= " order by location_libelle, section_libelle, expl_cote, expl_cb ";
}
$result = pmb_mysql_query($requete, $dbh) or die("<br />" . pmb_mysql_error() . "<br />" . $requete);
$nbr_expl = pmb_mysql_num_rows($result);
if ($nbr_expl) {
while ($expl = pmb_mysql_fetch_object($result)) {
//visibilité des exemplaires
if ($pmb_droits_explr_localises) {
$as_invis = array_search($expl->idlocation, $explr_tab_invis);
$as_unmod = array_search($expl->idlocation, $explr_tab_unmod);
$as_modif = array_search($expl->idlocation, $explr_tab_modif);
} else {
$as_invis = false;
$as_unmod = false;
$as_modif = true;
}
if ($link_expl) {
if ($expl_bulletin) {
$tlink = "./catalog.php?categ=serials&sub=bulletinage&action=expl_form&bul_id=!!bull_id!!&expl_id=!!expl_id!!";
$tlink = str_replace('!!bull_id!!', $expl_bulletin, $tlink);
$tlink = str_replace('!!expl_id!!', $expl->expl_id, $tlink);
$tlink = str_replace('!!expl_cb!!', rawurlencode($expl->expl_cb), $tlink);
} else {
//.........这里部分代码省略.........
开发者ID:hogsim,项目名称:PMB,代码行数:101,代码来源:mono_display.class.php
示例20: get_next_notice
//.........这里部分代码省略.........
$ind = "0 ";
$subfields_101 = array();
while ($tmp_lang = pmb_mysql_fetch_object($restmp_lang)) {
if ($tmp_lang->type_langue) {
$ind = "1 ";
$subfields_101['c'][] = $tmp_lang->code_langue;
} else {
$subfields_101['a'][] = $tmp_lang->code_langue;
}
}
$this->add_field('101', $ind, $subfields_101);
//Mention d'edition
$subfields = array();
$subfields["a"] = $res->mention_edition;
$this->add_field("205", " ", $subfields);
//Collation
$subfields = array();
$subfields["a"] = $res->npages;
$subfields["c"] = $res->ill;
$subfields["d"] = $res->size;
$subfields["e"] = $res->accomp;
$this->add_field("215", " ", $subfields);
//Notes
$subfields = array();
$subfields["a"] = $res->n_gen;
$this->add_field("300", " &
|
请发表评论