PHP pmb_bidi函数代码示例

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 . "&nbsp;";
        $expl_liste .= "</td><td><strong>";
        $expl_liste .= $expl->expl_cote . "&nbsp;";
        $expl_liste .= "</strong></td><td>";
        $expl_liste .= $expl->location_libelle . "&nbsp;";
        $expl_liste .= "</td><td>";
        $expl_liste .= $expl->section_libelle . "&nbsp;";
        $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>&nbsp;";
            }
        } else {
            $situation .= "<strong>{$msg['exclu']}</strong>";
        }
        $expl_liste .= "</td><td>{$situation} &nbsp;</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>&nbsp;</td>";
        }
        print "<td>{$row->opac_libelle}</td>";
        if ($row->notice_visible_opac) {
            print "<td>X</td>";
        } else {
            print "<td>&nbsp;</td>";
        }
        if ($row->expl_visible_opac) {
            print "<td>X</td>";
        } else {
            print "<td>&nbsp;</td>";
        }
        if ($row->explnum_visible_opac) {
            print "<td>X</td>";
        } else {
            print "<td>&nbsp;</td>";
        }
        if ($row->notice_scan_request_opac) {
            print "<td>X</td>";
        } else {
            print "<td>&nbsp;</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']}&nbsp;</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>&nbsp;</td>";*/
        print "<td>{$row->archstatut_opac_libelle}</td>";
        if ($row->archstatut_visible_opac) {
            print "<td>X</td>";
        } else {
            print "<td>&nbsp;</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 "&nbsp;";
            }
            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);
}