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'\" />"; }