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 = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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'\" />";
}
function show_codstat($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th>" . $msg[103] . "</th>\n\t\t<th>" . $msg['proprio_codage_proprio'] . "</th>\n\t\t<th>" . $msg['import_codage'] . "</th>\n\t</tr>";
$requete = "SELECT idcode, codestat_libelle, statisdoc_codage_import, statisdoc_owner, lender_libelle FROM docs_codestat left join lenders on statisdoc_owner=idlender ORDER BY codestat_libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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=docs&sub=codstat&action=modif&id={$row->idcode}';\" ";
if ($row->statisdoc_owner) {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>{$row->codestat_libelle}</i></td>");
} else {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><strong>{$row->codestat_libelle}</strong></td>");
}
print pmb_bidi("<td>{$row->lender_libelle}</td>");
print pmb_bidi("<td>{$row->statisdoc_codage_import}</td></tr>");
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['99']} ' onClick=\"document.location='./admin.php?categ=docs&sub=codstat&action=add'\" />";
}
function expl_list($type, $id)
{
global $dbh;
global $msg;
$requete = "SELECT exemplaires.*, pret.*, docs_location.*, docs_section.*, docs_statut.*";
$requete .= " FROM exemplaires, docs_location, docs_section, docs_statut";
$requete .= " LEFT JOIN pret ON exemplaires.expl_id=pret.pret_idexpl";
// selon le type de données d'origine : ouvrage ou bulletin d'un périodique
// on adapte la requête
switch ($type) {
case 'b':
$requete .= " WHERE expl_bulletin='{$id}'";
break;
case 'm':
default:
$requete .= " WHERE expl_notice='{$id}'";
break;
}
$requete .= " AND exemplaires.expl_location=docs_location.idlocation";
$requete .= " AND exemplaires.expl_section=docs_section.idsection ";
$requete .= " AND exemplaires.expl_statut=docs_statut.idstatut ";
$requete .= " AND section_visible_opac = 1 ";
$requete .= " AND statut_visible_opac = 1 ";
// récupération du nombre d'exemplaires
$res = mysql_query($requete, $dbh);
$compteur = 0;
while ($expl = mysql_fetch_object($res)) {
$compteur = $compteur + 1;
$expl_liste .= "<tr><td>";
$expl_liste .= $expl->expl_cb . " ";
$expl_liste .= "</td><td><strong>";
$expl_liste .= $expl->expl_cote . " ";
$expl_liste .= "</strong></td><td>";
$expl_liste .= $expl->location_libelle . " ";
$expl_liste .= "</td><td>";
$expl_liste .= $expl->section_libelle . " ";
$situation = "";
if ($expl->statut_libelle_opac != "") {
$situation .= $expl->statut_libelle_opac . "<br />";
}
if ($expl->pret_flag) {
if ($expl->pret_retour) {
// exemplaire sorti
$situation .= "<strong>{$msg['out_until']} " . formatdate($expl->pret_retour) . '</strong>';
} else {
// exemplaire disponible
$situation .= "<strong>{$msg['available']}</strong> ";
}
} else {
$situation .= "<strong>{$msg['exclu']}</strong>";
}
$expl_liste .= "</td><td>{$situation} </td>";
$expl_liste .= "</tr>";
}
// affichage de la liste d'exemplaires calculées ci-dessus
if ($compteur == 0) {
$expl_liste = "<tr class=even><td colspan=5>" . $msg["no_expl"] . "</td></tr>";
}
print pmb_bidi($expl_liste);
}
function show_statut($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th colspan=2>" . $msg["noti_statut_gestion"] . "</th>\n\t\t<th colspan=5>" . $msg["noti_statut_opac"] . "</th>\n\t</tr><tr>\n\t\t<th>" . $msg["noti_statut_libelle"] . "</th>\n\t\t<th>" . $msg["noti_statut_visu_gestion"] . "</th>\n\t\t<th>" . $msg["noti_statut_libelle"] . "</th>\n\t\t<th>" . $msg["noti_statut_visu_opac"] . "</th>\n\t\t<th>" . $msg["noti_statut_visu_expl"] . "</th>\n\t\t<th>" . $msg["noti_statut_visu_explnum"] . "</th>\n\t\t<th>" . $msg["noti_statut_scan_request_opac"] . "</th>\n\t</tr>";
// affichage du tableau des statuts
$requete = "SELECT id_notice_statut, gestion_libelle, opac_libelle, ";
$requete .= "notice_visible_opac, notice_visible_gestion, notice_visible_opac_abon,";
$requete .= "expl_visible_opac, expl_visible_opac_abon, ";
$requete .= "explnum_visible_opac, explnum_visible_opac_abon, ";
$requete .= "notice_scan_request_opac, notice_scan_request_opac_abon, ";
$requete .= "class_html FROM notice_statut ORDER BY gestion_libelle ";
$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=statut&action=modif&id={$row->id_notice_statut}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>");
print pmb_bidi("<td><span class='{$row->class_html}' style='margin-right: 3px;'><img src='./images/spacer.gif' width='10' height='10' /></span>");
if ($row->id_notice_statut < 3) {
print pmb_bidi("<strong>{$row->gestion_libelle}</strong></td>");
} else {
print pmb_bidi("{$row->gestion_libelle}</td>");
}
if ($row->notice_visible_gestion) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
print "<td>{$row->opac_libelle}</td>";
if ($row->notice_visible_opac) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
if ($row->expl_visible_opac) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
if ($row->explnum_visible_opac) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
if ($row->notice_scan_request_opac) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
print "</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['115']} ' onClick=\"document.location='./admin.php?categ=notices&sub=statut&action=add'\" />";
}
function affichage_liste_bulletins_tableau($res)
{
global $charset, $msg;
print "<table cellpadding='2' class='exemplaires' width='100%'><tr><th><b>" . $msg[bull_numero] . "</b></th><th><b>" . $msg[bull_mention_date] . "</b></th><th><b>" . $msg['etat_collection_title'] . "</b></th></tr>";
$odd_even = 1;
while ($tableau = mysql_fetch_array($res)) {
if ($odd_even == 0) {
$pair_impair = "odd";
$odd_even = 1;
} else {
if ($odd_even == 1) {
$pair_impair = "even";
$odd_even = 0;
}
}
$tr_javascript = " class='{$pair_impair}' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./index.php?lvl=bulletin_display&id=" . $tableau['bulletin_id'] . "';\" style='cursor: pointer' ";
print "<tr {$tr_javascript}><td><table width='100%'><tr><td style='border:none;width:16px'>" . ($tableau['nbexplnum'] != 0 ? $tableau['nbexplnum'] > 1 ? "<img src='./images/globe_rouge.png' />" : "<img src='./images/globe_orange.png' />" : "") . "</td><td style='border:none;'>" . $tableau['bulletin_numero'] . "</td></tr></table>";
print "</td><td>";
if ($tableau['mention_date']) {
print pmb_bidi(" " . $tableau['mention_date'] . "\n");
} elseif ($tableau['date_date']) {
print pmb_bidi(" " . formatdate($tableau['date_date']) . "\n");
}
print "</td><td>";
if ($tableau['bulletin_titre']) {
print pmb_bidi(" " . htmlentities($tableau['bulletin_titre'], ENT_QUOTES, $charset) . "\n");
}
print "</td></tr>";
}
print "</table><br /><br />";
}
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_procs($idcaddie)
{
global $msg;
global $PMBuserid;
global $dbh;
print "<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 = "pointe_item";
}
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./catalog.php?categ=caddie&sub=pointage&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 show_statut($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th rowspan=2 >" . $msg["collstate_statut_gestion"] . "</th>\n\t\t<th colspan=2 >" . $msg["collstate_statut_opac"] . "</th>\n\t</tr><tr>\n\t\t\n\t\t\n\t\t<th>" . $msg["collstate_statut_libelle"] . "</th>\n\t\t<th>" . $msg["collstate_statut_visu_opac"] . "</th>\n\t</tr>";
//<th>".$msg["collstate_statut_libelle"]."</th> <th>".$msg["collstate_statut_visu_gestion"]."</th>
// affichage du tableau des statuts
$requete = "SELECT * FROM arch_statut ORDER BY archstatut_gestion_libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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=collstate&sub=statut&action=modif&id={$row->archstatut_id}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>");
print pmb_bidi("<td><span class='{$row->archstatut_class_html}' style='margin-right: 3px;'><img src='./images/spacer.gif' width='10' height='10' /></span>");
print pmb_bidi("{$row->archstatut_gestion_libelle}</td>");
/*if($row->archstatut_visible_gestion) print "<td>X</td>";
else print "<td> </td>";*/
print "<td>{$row->archstatut_opac_libelle}</td>";
if ($row->archstatut_visible_opac) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
print "</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['115']} ' onClick=\"document.location='./admin.php?categ=collstate&sub=statut&action=add'\" />";
}
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $rech_regexp = 0)
{
global $nb_per_page;
global $base_url;
global $caller;
global $charset;
$user_input = str_replace("*", "%", $user_input);
$where = "empr_nom like '{$user_input}%' ";
// on récupére le nombre de lignes qui vont bien
if (!$user_input) {
$requete = "SELECT COUNT(1) FROM empr ";
} else {
$requete = "SELECT COUNT(1) FROM empr WHERE {$where} ";
}
$res = mysql_query($requete, $dbh);
$nbr_lignes = @mysql_result($res, 0, 0);
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
// on lance la vraie requête
if (!$user_input) {
$requete = "SELECT id_empr, empr_nom, empr_prenom, empr_cb, trim(concat(empr_cp,' ',empr_ville)) as lieu FROM empr ORDER BY empr_nom, empr_prenom LIMIT {$debut},{$nb_per_page} ";
} else {
$requete = "SELECT id_empr, empr_nom, empr_prenom, empr_cb, trim(concat(empr_cp,' ',empr_ville)) as lieu FROM empr WHERE {$where} ";
$requete .= "ORDER BY empr_nom, empr_prenom LIMIT {$debut},{$nb_per_page} ";
}
$res = @mysql_query($requete, $dbh);
while ($empr = mysql_fetch_object($res)) {
$empr_entry = $empr->empr_nom;
if ($empr->empr_prenom) {
$empr_entry .= ', ' . $empr->empr_prenom;
}
print pmb_bidi("\n \t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$empr->id_empr}', '" . htmlentities(addslashes($empr_entry), ENT_QUOTES, $charset) . " ({$empr->empr_cb})')\">\n\t\t\t\t{$empr_entry}</a>");
print pmb_bidi(' <i><small>' . $empr->lieu . '</small></i> (' . $empr->empr_cb . ')');
print "<br />";
}
mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes / $nb_per_page);
$suivante = $page + 1;
$precedente = $page - 1;
// affichage du lien précédent si nécéssaire
print '<hr /><div align=center>';
if ($precedente > 0) {
print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&user_input={$user_input}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>";
}
for ($i = 1; $i <= $nbepages; $i++) {
if ($i == $page) {
print "<b>{$i}/{$nbepages}</b>";
}
}
if ($suivante <= $nbepages) {
print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&user_input={$user_input}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>";
}
}
print '</div>';
}
function list_categ($cle, $categ_list, $nav_bar)
{
global $categ_list_tmpl;
$categ_list_tmpl = str_replace("!!cle!!", $cle, $categ_list_tmpl);
$categ_list_tmpl = str_replace("!!list!!", $categ_list, $categ_list_tmpl);
$categ_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $categ_list_tmpl);
categ_browser::search_form();
print pmb_bidi($categ_list_tmpl);
}
function list_ed($cb, $empr_list, $nav_bar)
{
global $ed_list_tmpl;
$ed_list_tmpl = str_replace("!!cle!!", $cb, $ed_list_tmpl);
$ed_list_tmpl = str_replace("!!list!!", $empr_list, $ed_list_tmpl);
$ed_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $ed_list_tmpl);
editeur::search_form();
print pmb_bidi($ed_list_tmpl);
}
function list_serie($cb, $empr_list, $nav_bar)
{
global $serie_list_tmpl;
$serie_list_tmpl = str_replace("!!cle!!", $cb, $serie_list_tmpl);
$serie_list_tmpl = str_replace("!!list!!", $empr_list, $serie_list_tmpl);
$serie_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $serie_list_tmpl);
serie::search_form();
print pmb_bidi($serie_list_tmpl);
}
function show_lines_list()
{
global $id_empr, $msg, $charset;
//Liste des recouvrements
print "\n\t<div class='row'>\t\n\t<script type='text/javascript' src='./javascript/sorttable.js'></script>\n\t<table class='sortable'>\n\n\t\t<tr>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_date"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_type"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_titre"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_cb"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_cote"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_pret_date"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_relance_date1"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_relance_date2"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_relance_date3"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_prix_calcul"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th>" . htmlentities($msg["relance_recouvrement_montant"], ENT_QUOTES, $charset) . "</th>\n\t\t\t<th></th>\n\t\t\t<th></th>\t\t\n\t\t</tr>";
$requete = "select recouvr_id,id_expl,date_rec,libelle,montant, expl_notice,expl_bulletin, recouvr_type, date_pret,date_relance1,date_relance2,date_relance3, expl_cote ,\texpl_cb\n\tfrom recouvrements left join exemplaires on expl_id=id_expl where empr_id={$id_empr} order by date_rec,recouvr_id";
$resultat = pmb_mysql_query($requete);
$pair = false;
while ($r = pmb_mysql_fetch_object($resultat)) {
if (!$pair) {
$pair_impair = "odd";
} else {
$pair_impair = "even";
}
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" ";
$pair = !$pair;
if ($r->id_expl) {
if ($r->expl_notice) {
$notice = new mono_display($r->expl_notice);
} elseif ($r->expl_bulletin) {
$req = "select bulletin_notice from bulletins where bulletin_id={$r->expl_bulletin}";
$res = pmb_mysql_query($req);
$id_bull_notice = pmb_mysql_result($res, 0, 0);
$notice = new serial_display($id_bull_notice);
}
$libelle = strip_tags(html_entity_decode($notice->header, ENT_QUOTES, $charset));
} else {
$libelle = $r->libelle;
}
if (!$r->recouvr_type) {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript}>\n\t\t\t\t<td>" . format_date($r->date_rec) . "</td>\n\t\t\t\t<td>" . htmlentities($msg["relance_recouvrement_amende"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($libelle, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td><a href='./circ.php?categ=visu_ex&form_cb_expl=" . $r->expl_cb . "'>" . $r->expl_cb . "</a></td>\n\t\t\t\t<td>" . htmlentities($r->expl_cote, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . format_date($r->date_pret) . "</td>\n\t\t\t\t<td>" . format_date($r->date_relance1) . "</td>\n\t\t\t\t<td>" . format_date($r->date_relance2) . "</td>\n\t\t\t\t<td>" . format_date($r->date_relance3) . "</td>\n\t\t\t\t<td></td>\n\t\t\t\t<td style='text-align:right'><span dynamics='circ,recouvr_prix' dynamics_params='text' id='prix_" . $r->recouvr_id . "'>" . comptes::format_simple($r->montant) . "</span></td>\n\t\t\t\t<td style='text-align:center'><input type='checkbox' name='recouvr_ligne[]' value='" . $r->recouvr_id . "'></td>\n\t\t\t\t<td>");
if (!$r->id_expl) {
print "<input type='button' value='...' class='bouton' onClick=\"this.form.act_line.value='update_line'; this.form.recouvr_id.value='" . $r->recouvr_id . "'; this.form.submit();\"/>";
} else {
print " ";
}
print "</td>";
print "</tr>";
} elseif ($r->id_expl) {
$requete = "select expl_prix, prix from exemplaires, notices where (notice_id=expl_notice or notice_id=expl_bulletin) and expl_id =" . $r->id_expl;
//http://localhost/~ngantier/pmb/circ.php?categ=visu_ex&form_cb_expl=p
$res_prix = pmb_mysql_query($requete);
$comment_prix = '';
if ($r_prix = pmb_mysql_fetch_object($res_prix)) {
if (!($comment_prix = $r_prix->expl_prix)) {
$comment_prix = $r_prix->prix;
}
}
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript}>\n\t\t\t\t<td>" . format_date($r->date_rec) . "</td>\n\t\t\t\t<td>" . htmlentities($msg["relance_recouvrement_prix"], ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td>" . htmlentities($libelle, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td><a href='./circ.php?categ=visu_ex&form_cb_expl=" . $r->expl_cb . "'>" . $r->expl_cb . "</a></td>\n\t\t\t\t<td>" . htmlentities($r->expl_cote, ENT_QUOTES, $charset) . "</td>\t\t\t\n\t\t\t\t<td>" . format_date($r->date_pret) . "</td>\n\t\t\t\t<td>" . format_date($r->date_relance1) . "</td>\n\t\t\t\t<td>" . format_date($r->date_relance2) . "</td>\n\t\t\t\t<td>" . format_date($r->date_relance3) . "</td>\n\t\t\t\t<td>" . htmlentities($comment_prix, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t<td style='text-align:right'><span dynamics='circ,recouvr_prix' dynamics_params='text' id='prix_" . $r->recouvr_id . "'>" . comptes::format_simple($r->montant) . "</span></td>\n\t\t\t\t<td style='text-align:center'><input type='checkbox' name='recouvr_ligne[]' value='" . $r->recouvr_id . "'></td>\n\t\t\t\t<td>");
print "</td>";
print "</tr>";
}
}
print "</table></div>";
print "\n\t\t<div class='row'></div>\n\t</div>\n\t<!--boutons -->\n\t<div class='row'>\n\t\t<input type='button' value='" . $msg["relance_recouvrement_del_all_lines"] . "' class='bouton' onClick=\"if (confirm('" . $msg["relance_recouvrement_confirm_del"] . "')) { this.form.act_line.value='del_line'; this.form.submit(); }\"/>\n\t\t<input type='button' value='" . $msg["relance_recouvrement_add_line"] . "' class='bouton' onClick=\"this.form.act_line.value='update_line'; this.form.recouvr_id.value=''; this.form.submit();\"/>\n\t\t<input type='button' value='" . $msg["relance_recouvrement_export_tableur"] . "' class='bouton' onClick=\"document.location='./circ/relance/recouvr_reader_excel.php?id_empr={$id_empr}';\"/>\n\t\t<input type='button' value='" . $msg["relance_recouvrement_solder"] . "' class='bouton' onClick=\"if (confirm('" . $msg["relance_recouvrement_confirm_solder"] . "')) { this.form.act_line.value='solde'; this.form.submit(); }\"/>\n\t\t<input type='button' value='" . $msg["76"] . "' class='bouton' onClick=\"document.location='./circ.php?categ=relance&sub=recouvr&act=recouvr_liste'\"/>\n\t</div>";
}
function list_collection($coll, $collection_list, $nav_bar)
{
global $collection_list_tmpl;
global $charset;
$collection_list_tmpl = str_replace("!!cle!!", $coll, $collection_list_tmpl);
$collection_list_tmpl = str_replace("!!list!!", $collection_list, $collection_list_tmpl);
$collection_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $collection_list_tmpl);
collection::search_form();
print pmb_bidi($collection_list_tmpl);
}
function list_indexint($cle, $indexint_list, $nav_bar)
{
global $indexint_list_tmpl;
global $charset, $id_pclass;
$indexint_list_tmpl = str_replace("!!cle!!", $cle, $indexint_list_tmpl);
$indexint_list_tmpl = str_replace("!!list!!", $indexint_list, $indexint_list_tmpl);
$indexint_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $indexint_list_tmpl);
indexint::search_form($id_pclass);
print pmb_bidi($indexint_list_tmpl);
}
function affiche()
{
global $thes_browser;
global $browser_content;
global $action;
global $browser_header;
$thes_browser = str_replace('!!browser_header!!', $browser_header, $thes_browser);
$thes_browser = str_replace('!!browser_content!!', $browser_content, $thes_browser);
$thes_browser = str_replace('!!action!!', $action, $thes_browser);
print pmb_bidi($thes_browser);
}
function show_results($dbh, $nbr_lignes = 0, $page = 0)
{
global $nb_per_page;
global $base_url;
global $caller;
global $charset;
global $msg;
global $id_fou;
// on récupére le nombre de lignes qui vont bien
$nbr_lignes = types_produits::countTypes();
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
// on lance la vraie requête
$q = types_produits::listTypes($debut, $nb_per_page);
$res = mysql_query($q, $dbh);
while ($row = mysql_fetch_object($res)) {
$typ = $row->id_produit;
$lib_typ = $row->libelle;
$taux_tva = new tva_achats($row->num_tva_achat);
$lib_tva = htmlentities($taux_tva->taux_tva, ENT_QUOTES, $charset);
$offre = new offres_remises($id_fou, $row->id_produit);
if ($offre->remise) {
$lib_rem = htmlentities($offre->remise, ENT_QUOTES, $charset);
} else {
$lib_rem = '0';
}
print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_produit}', '" . htmlentities(addslashes($lib_typ), ENT_QUOTES, $charset) . "', '{$lib_rem}', '{$lib_tva}' )\">{$lib_typ}</a>");
print "<br />";
}
mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes / $nb_per_page);
$suivante = $page + 1;
$precedente = $page - 1;
// affichage du lien précédent si nécessaire
print '<hr /><div align=center>';
if ($precedente > 0) {
print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>";
}
for ($i = 1; $i <= $nbepages; $i++) {
if ($i == $page) {
print "<b>{$i}/{$nbepages}</b>";
}
}
if ($suivante <= $nbepages) {
print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>";
}
}
print '</div>';
}
function list_group($clef, $filter_list, $group_list, $nav_bar, $nb_total)
{
global $group_list_tmpl;
global $charset;
$group_list_tmpl = str_replace("!!filter_list!!", $filter_list, $group_list_tmpl);
$group_list_tmpl = str_replace("!!cle!!", $clef, $group_list_tmpl);
if ($nb_total > 0) {
$group_list_tmpl = str_replace("<!--!!nb_total!!-->", "(" . $nb_total . ")", $group_list_tmpl);
}
$group_list_tmpl = str_replace("!!list!!", $group_list, $group_list_tmpl);
$group_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $group_list_tmpl);
print pmb_bidi($group_list_tmpl);
}
function aff_etagere($action, $bouton_ajout = 1)
{
global $msg;
global $PMBuserid;
global $charset, $opac_url_base;
$liste = etagere::get_etagere_list();
if (sizeof($liste)) {
print "<table>";
print "<tr><th>" . $msg['etagere_name'] . "</th><th>" . $msg["etagere_cart_count"] . "</th><th>" . $msg['etagere_visible_date'] . "</th><th>" . $msg['etagere_visible_accueil'] . "</th></tr>";
$parity = 1;
while (list($cle, $valeur) = each($liste)) {
$rqt_autorisation = explode(" ", $valeur['autorisations']);
if (array_search($PMBuserid, $rqt_autorisation) !== FALSE || $PMBuserid == 1) {
$link = "./catalog.php?categ=etagere&sub={$action}&action=edit_etagere&idetagere=" . $valeur['idetagere'];
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" ";
$td_javascript_click = " onmousedown=\"document.location='{$link}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} >\n \t\t\t<td {$td_javascript_click} style='cursor: pointer'><strong>" . $valeur['name'] . "</strong>");
if ($valeur['comment']) {
print pmb_bidi(" (" . $valeur['comment'] . ")");
}
print "</td><td {$td_javascript_click} style='cursor: pointer'>";
print $valeur['nb_paniers'];
print "</td><td {$td_javascript_click} style='cursor: pointer'>";
if ($valeur['validite']) {
print $msg['etagere_visible_date_all'];
} else {
print $msg['etagere_visible_date_du'] . " " . $valeur['validite_date_deb_f'] . " " . $msg['etagere_visible_date_fin'] . " " . $valeur['validite_date_fin_f'];
}
print "</td><td>";
if ($valeur['visible_accueil']) {
print "X<br /><a href='" . $opac_url_base . "index.php?lvl=etagere_see&id=" . $valeur['idetagere'] . "' target=_blank>" . $opac_url_base . "index.php?lvl=etagere_see&id=" . $valeur['idetagere'] . "</a>";
} else {
print "<br /><a href='" . $opac_url_base . "index.php?lvl=etagere_see&id=" . $valeur['idetagere'] . "' target=_blank>" . $opac_url_base . "index.php?lvl=etagere_see&id=" . $valeur['idetagere'] . "</a>";
}
print "</td>\n\t\t\t</tr>";
}
}
print "</table>";
} else {
print $msg['etagere_no_etagere'];
}
if ($bouton_ajout) {
print "<div class='row'>\n\t<input class='bouton' type='button' value=' {$msg['etagere_new_etagere']} ' onClick=\"document.location='./catalog.php?categ=etagere&sub=gestion&action=new_etagere'\" />\n\t</div>";
}
}
function show_typdoc_list()
{
global $dbh, $msg, $charset;
global $pmb_quotas_avances;
global $pmb_gestion_financiere, $pmb_gestion_tarif_prets;
global $pmb_short_loan_management;
$form = '<table>
<tr>
<th>' . $msg[103] . '</th>
<th>' . $msg[120] . '</th>';
if ($pmb_short_loan_management) {
$form .= '<th>' . $msg['short_loan_duration'] . '</th>';
}
$form .= '<th>' . $msg['duree_resa'] . '</th>';
if ($pmb_gestion_financiere && $pmb_gestion_tarif_prets) {
$form .= '<th>' . $msg['typ_doc_tarif'] . '</th>';
}
$form .= '<th>' . $msg['proprio_codage_proprio'] . '</th>
<th>' . $msg['import_codage'] . '</th>
</tr>';
$q = 'SELECT idtyp_doc, tdoc_libelle, duree_pret, duree_resa, tdoc_owner, tdoc_codage_import, lender_libelle, tarif_pret, short_loan_duration FROM docs_type left join lenders on tdoc_owner=idlender ORDER BY tdoc_libelle, idtyp_doc';
$res = mysql_query($q, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = mysql_fetch_object($res);
$pair_impair = $parity % 2 ? 'even' : 'odd';
$parity += 1;
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./admin.php?categ=docs&sub=typdoc&action=modif&id={$row->idtyp_doc}';\" ";
if ($row->tdoc_owner) {
$form .= pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>" . htmlentities($row->tdoc_libelle, ENT_QUOTES, $charset) . "</i></td>");
} else {
$form .= pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><strong>" . htmlentities($row->tdoc_libelle, ENT_QUOTES, $charset) . "</strong></td>");
}
$form .= '<td>' . (!$pmb_quotas_avances ? htmlentities($row->duree_pret, ENT_QUOTES, $charset) . ' ' . $msg[121] : $msg['quotas_see_quotas']) . '</td>';
if ($pmb_short_loan_management) {
$form .= '<td>' . (!$pmb_quotas_avances ? htmlentities($row->short_loan_duration, ENT_QUOTES, $charset) . ' ' . $msg[121] : $msg['quotas_see_quotas']) . '</td>';
}
$form .= '<td>' . (!$pmb_quotas_avances ? htmlentities($row->duree_resa, ENT_QUOTES, $charset) . ' ' . $msg[121] : $msg['quotas_see_quotas']) . '</td>';
if ($pmb_gestion_financiere && $pmb_gestion_tarif_prets) {
$form .= '<td>' . htmlentities($pmb_gestion_tarif_prets == 1 ? $row->tarif_pret : $msg['finance_see_finance'], ENT_QUOTES, $charset) . '</td>';
}
$form .= pmb_bidi('<td>' . htmlentities($row->lender_libelle, ENT_QUOTES, $charset) . '</td>');
$form .= pmb_bidi('<td>' . htmlentities($row->tdoc_codage_import, ENT_QUOTES, $charset) . '</td>');
$form .= '</tr>';
}
$form .= "</table>\n\t\t<input class='bouton' type='button' value='" . $msg[122] . "' onClick=\"document.location='./admin.php?categ=docs&sub=typdoc&action=add'\" />";
print $form;
}
function affiche_notice_navigopac($requete)
{
global $page, $nbr_lignes, $id, $location, $dcote, $lcote, $nc, $main, $ssub, $plettreaut;
global $opac_nb_aut_rec_per_page, $opac_section_notices_order, $msg, $dbh, $opac_notices_depliable, $begin_result_liste, $add_cart_link_spe, $base_path;
global $back_surloc, $back_loc, $back_section_see;
global $opac_perio_a2z_abc_search, $opac_perio_a2z_max_per_onglet;
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $opac_nb_aut_rec_per_page;
//On controle paramètre de tri
if (!trim($opac_section_notices_order)) {
$opac_section_notices_order = "index_serie, tnvol, index_sew";
}
if ($plettreaut && $plettreaut != "vide") {
$opac_section_notices_order = "index_author, " . $opac_section_notices_order;
}
$requete .= " ORDER BY " . $opac_section_notices_order . " LIMIT {$debut},{$opac_nb_aut_rec_per_page}";
$res = @mysql_query($requete, $dbh);
print $nbr_lignes . " " . $msg["results"] . "<br />";
if ($opac_notices_depliable) {
print $begin_result_liste;
}
if ($add_cart_link_spe) {
print pmb_bidi(str_replace("!!spe!!", "&location={$location}&dcote={$dcote}&lcote={$lcote}&ssub={$ssub}&nc={$nc}&plettreaut={$plettreaut}", $add_cart_link_spe));
}
//affinage
//enregistrement de l'endroit actuel dans la session
$_SESSION["last_module_search"]["search_mod"] = "section_see";
$_SESSION["last_module_search"]["search_id"] = $id;
$_SESSION["last_module_search"]["search_location"] = $location;
$_SESSION["last_module_search"]["search_page"] = $page;
//affinage
if ($dcote == "" && $plettreaut == "" && $nc == "") {
print " <a href='{$base_path}/index.php?search_type_asked=extended_search&mode_aff=aff_module'>" . $msg["affiner_recherche"] . "</a>";
}
//fin affinage
print "<blockquote>";
print aff_notice(-1);
while ($obj = mysql_fetch_object($res)) {
print pmb_bidi(aff_notice($obj->notice_id));
}
print aff_notice(-2);
print "</blockquote>";
mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes / $opac_nb_aut_rec_per_page);
print '<div id="navbar"><hr /><center>' . printnavbar($page, $nbepages, './index.php?lvl=section_see&id=' . $id . '&location=' . $location . ($back_surloc ? '&back_surloc=' . urlencode($back_surloc) : '') . ($back_loc ? '&back_loc=' . urlencode($back_loc) : '') . ($back_section_see ? '&back_section_see=' . urlencode($back_section_see) : '') . '&page=!!page!!&nbr_lignes=' . $nbr_lignes . '&dcote=' . $dcote . '&lcote=' . $lcote . '&nc=' . $nc . '&main=' . $main . '&ssub=' . $ssub . '&plettreaut=' . $plettreaut) . '</center></div>';
}
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
global $nb_per_page;
global $base_url;
global $caller;
global $class_path;
global $no_display;
global $charset;
global $msg;
global $dbh;
// on récupére le nombre de lignes
if ($user_input == "") {
$requete = "SELECT empr_cp, empr_ville FROM empr group by empr_cp, empr_ville ";
} else {
$requete = "SELECT empr_cp, empr_ville FROM empr where empr_cp like '{$user_input}%' group by empr_cp, empr_ville ";
}
$res = mysql_query($requete, $dbh);
$nbr_lignes = mysql_num_rows($res);
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
// on lance la vraie requête
if ($user_input == "") {
$requete = "SELECT empr_cp, empr_ville, count(id_empr) as nbre FROM empr group by empr_cp, empr_ville ORDER BY empr_cp, empr_ville LIMIT {$debut},{$nb_per_page} ";
} else {
$requete = "SELECT empr_cp, empr_ville, count(id_empr) as nbre FROM empr where empr_cp like '{$user_input}%' group by empr_cp, empr_ville ORDER BY empr_cp, empr_ville LIMIT {$debut},{$nb_per_page} ";
}
$res = mysql_query($requete, $dbh);
while ($cp_ville = mysql_fetch_object($res)) {
print "<div class='row'>";
print pmb_bidi("<a href='#' onclick=\"set_parent('{$caller}', '" . htmlentities(addslashes($cp_ville->empr_ville), ENT_QUOTES, $charset) . "', '" . htmlentities(addslashes($cp_ville->empr_cp), ENT_QUOTES, $charset) . "')\">{$cp_ville->empr_cp} - {$cp_ville->empr_ville} : {$cp_ville->nbre}</a>");
print "</div>";
}
mysql_free_result($res);
// constitution des liens
$nbepages = ceil($nbr_lignes / $nb_per_page);
$suivante = $page + 1;
$precedente = $page - 1;
// affichage de la pagination
print "<hr /><div align='center'>";
$url_base = $base_url . "&rech_regexp={$rech_regexp}&user_input=" . rawurlencode(stripslashes($user_input));
$nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
print $nav_bar;
print '</div>';
}
}
function show_statut($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th colspan=5>" . $msg['docs_statut_gestion'] . "</th>\n\t\t<th colspan=2>" . $msg['docs_statut_opac'] . "</th>\n\t</tr>\n\t<tr>\n\t\t<th>" . $msg[103] . "</th>\n\t\t<th> </th>\n\t\t<th> </th>\n\t\t<th>" . $msg['proprio_codage_proprio'] . "</th>\n\t\t<th>" . $msg['import_codage'] . "</th>\n\t\t<th>" . $msg[103] . "</th>\n\t\t<th>" . $msg['docs_statut_visu_opac'] . "</th>\n\t</tr>";
// affichage du tableau des statuts
$requete = "SELECT * FROM docs_statut left join lenders on statusdoc_owner=idlender ORDER BY statut_libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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=docs&sub=statut&action=modif&id={$row->idstatut}';\" ";
if ($row->statusdoc_owner) {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>{$row->statut_libelle}</i></td>");
} else {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><strong>{$row->statut_libelle}</strong></td>");
}
if ($row->pret_flag) {
print "<td>{$msg['113']}</td>";
} else {
print "<td>{$msg['114']}</td>";
}
if ($row->statut_allow_resa) {
print "<td>" . $msg["statut_allow_resa_yes"] . "</td>";
} else {
print "<td>" . $msg["statut_allow_resa_no"] . "</td>";
}
print pmb_bidi("<td>{$row->lender_libelle}</td>");
print pmb_bidi("<td>{$row->statusdoc_codage_import}</td>");
print pmb_bidi("<td>{$row->statut_libelle_opac}</td>");
if ($row->statut_visible_opac) {
print "<td>X</td>";
} else {
print "<td> </td>";
}
print "</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['115']} ' onClick=\"document.location='./admin.php?categ=docs&sub=statut&action=add'\" />";
}
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 caddie_procs {$where} ORDER BY type, 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;
$action = " onmousedown=\"document.location='./catalog.php?categ=caddie&sub=gestion&quoi=procs&action=modif&id={$row['0']}';\"";
$tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" ";
print "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>";
if ($row[1] != "ACTION") {
print "\t<td width='10'><input class='bouton' type='button' value=' {$msg['procs_options_tester_requete']} ' onClick=\"document.location='./catalog.php?categ=caddie&sub=gestion&quoi=procs&action=execute&id={$row['0']}'\" />";
} else {
print "\t<td width='10' {$action}> ";
}
print pmb_bidi("\n\t\t\t\t\t</td>\n\t\t\t\t\t<td width='80' {$action}>\n\t\t\t\t\t\t{$row['1']}\n\t\t\t\t\t\t</td>\n\t\t\t\t\t<td {$action}>\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>");
if (preg_match_all("|!!(.*)!!|U", $row[3], $query_parameters)) {
print "<td><a href='catalog.php?categ=caddie&sub=gestion&quoi=procs&action=configure&id_query=" . $row[0] . "'>{$msg['procs_options_config_param']}</a>";
} else {
print "<td {$action}> ";
}
print "</td>";
print "<td><input class='bouton' type='button' value=\"" . $msg[procs_bt_export] . "\" onClick=\"document.location='./export.php?quoi=procs&sub=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='./catalog.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='./catalog.php?categ=caddie&sub=gestion&quoi=procs&action=import'\" />";
}
function show_section($dbh)
{
global $msg;
global $pmb_gestion_financiere, $pmb_gestion_abonnement;
if ($pmb_gestion_financiere) {
$gestion_abts = $pmb_gestion_abonnement;
} else {
$gestion_abts = 0;
}
print "<table>\n\t<tr>\n\t\t<th>" . $msg[103] . "</th>\n\t\t<th>" . $msg[1400] . "</th>";
if ($gestion_abts) {
print "<th>" . $msg["empr_categ_tarif"] . "</th>";
}
print "<th>" . $msg["empr_categ_age_min"] . "</th>\n\t\t<th>" . $msg["empr_categ_age_max"] . "</th>\n\t</tr>";
// affichage du tableau des utilisateurs
$requete = "SELECT id_categ_empr, libelle, duree_adhesion, tarif_abt, age_min, age_max FROM empr_categ ORDER BY libelle, id_categ_empr";
$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 ($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=empr&sub=categ&action=modif&id={$row['0']}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>{$row['1']}</td>\n\t\t\t\t\t\t<td>{$row['2']}</td>");
if ($gestion_abts == 1) {
$tarif = $row[3];
} else {
if ($gestion_abts == 2) {
$tarif = $msg["finance_see_finance"];
}
}
if ($gestion_abts) {
print "<td>" . $tarif . "</td>";
}
print "<td>" . $row[4] . "</td>\n\t\t\t\t<td>" . $row[5] . "</td>\n\t\t\t\t\t</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['524']} ' onClick=\"document.location='./admin.php?categ=empr&sub=categ&action=add'\" />";
}
function show_statut($dbh)
{
global $msg;
print "<table>\n\t\t<th>" . $msg[abonnements_periodicite_libelle] . "</th>\n\t\t<th>" . $msg[abonnements_periodicite_duree] . "</th>\n\t\t<th>" . $msg[abonnements_periodicite_unite] . "</th>\n\t\t<th>" . $msg['seuil_periodicite'] . "</th>\n\t\t<th>" . $msg['retard_periodicite'] . "</th>\n\t\t<th>" . $msg['serialcirc_consultation_duration'] . "</th>\n\t</tr>";
// affichage du tableau des périodicités
$requete = "SELECT periodicite_id, libelle, duree, unite, seuil_periodicite, retard_periodicite,consultation_duration ";
$requete .= "FROM abts_periodicites ORDER BY libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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=abonnements&sub=periodicite&action=modif&id={$row->periodicite_id}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>");
print pmb_bidi("<td><strong>{$row->libelle}</strong></td>");
print "<td>{$row->duree}</td>";
print "<td>";
switch ($row->unite) {
case '0':
print "{$msg['abonnements_periodicite_unite_jour']}";
break;
case '1':
print "{$msg['abonnements_periodicite_unite_mois']}";
break;
case '2':
print "{$msg['abonnements_periodicite_unite_annee']}";
break;
}
print "</td>";
print "<td>{$row->seuil_periodicite}</td>";
print "<td>{$row->retard_periodicite}</td>";
print "<td>{$row->consultation_duration}</td>";
print "</tr>";
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['abonnements_ajouter_une_periodicite']} ' onClick=\"document.location='./admin.php?categ=abonnements&sub=periodicite&action=add'\" />";
}
function show_section($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th>" . $msg[103] . "</th>\n\t\t<th>" . $msg['opac_object_visible_short'] . "</th>\n\t\t<th>" . $msg['section_visible_loc'] . "</th>\n\t\t<th>" . $msg['proprio_codage_proprio'] . "</th>\n\t\t<th>" . $msg['import_codage'] . "</th>\n\t</tr>";
$requete = "SELECT idsection, section_libelle, sdoc_codage_import, sdoc_owner, lender_libelle, section_visible_opac FROM docs_section left join lenders on sdoc_owner=idlender ORDER BY section_libelle";
$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);
$rqtloc = "select location_libelle from docsloc_section, docs_location where num_section='{$row->idsection}' and idlocation=num_location order by location_libelle ";
$resloc = pmb_mysql_query($rqtloc, $dbh);
$localisations = array();
while ($loc = pmb_mysql_fetch_object($resloc)) {
$localisations[] = $loc->location_libelle;
}
$locaff = implode("<br />", $localisations);
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=docs&sub=section&action=modif&id={$row->idsection}';\" ";
if ($row->sdoc_owner) {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>{$row->section_libelle}</i></td>");
} else {
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><strong>{$row->section_libelle}</strong></td>");
}
if ($row->section_visible_opac) {
$visible = "X";
} else {
$visible = " ";
}
print "<td>{$visible}</td>";
print "<td>{$locaff}</td>";
print pmb_bidi("<td>{$row->lender_libelle}</td>");
print pmb_bidi("<td>{$row->sdoc_codage_import}</td></tr>");
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['110']} ' onClick=\"document.location='./admin.php?categ=docs&sub=section&action=add'\" />";
}
function show_emplacement($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th>" . $msg["admin_collstate_emplacement_nom"] . "</th>\n\t</tr>";
// affichage du tableau des emplacements
$requete = "SELECT * FROM arch_emplacement ORDER BY archempla_libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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=collstate&sub=emplacement&action=modif&id={$row->archempla_id}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>{$row->archempla_libelle}</td></tr>");
}
print "</table>\n\t\t<input class='bouton' type='button' value=\"" . $msg["admin_collstate_add_emplacement"] . " \" onClick=\"document.location='./admin.php?categ=collstate&sub=emplacement&action=add'\" />";
}
function show_codstat($dbh)
{
global $msg;
print "<table>\n\t\t<tr>\n\t\t<th>" . $msg[103] . "</th>\n\t\t</tr>";
// affichage du tableau des utilisateurs
$requete = "SELECT idcode, libelle FROM empr_codestat ORDER BY libelle, idcode ";
$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 ($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=empr&sub=codstat&action=modif&id={$row['0']}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>{$row['1']}</td>\n\t\t\t\t\t\t</tr>");
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['99']} ' onClick=\"document.location='./admin.php?categ=empr&sub=codstat&action=add'\" />";
}
function show_lender($dbh)
{
global $msg;
print "<table>\n\t<tr>\n\t\t<th>" . $msg[558] . "</th>\n\t</tr>";
// affichage du tableau des utilisateurs
$requete = "SELECT idlender,lender_libelle FROM lenders ORDER BY lender_libelle ";
$res = mysql_query($requete, $dbh);
$nbr = mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = 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=docs&sub=lenders&action=modif&id={$row->idlender}';\" ";
print pmb_bidi("<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>{$row->lender_libelle}</td>\n \t</tr>");
}
print "</table>\n\t\t<input class='bouton' type='button' value=' {$msg['555']} ' onClick=\"document.location='./admin.php?categ=docs&sub=lenders&action=add'\" />";
}
