コード例 #1
0
ファイル: perio.inc.php プロジェクト: noble82/proyectos-ULS
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $msg;
    global $no_display;
    global $charset;
    // on récupére le nombre de lignes qui vont bien
    if ($user_input == "") {
        $requete = "SELECT COUNT(1) FROM notices where notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1' ";
    } else {
        $aq = new analyse_query(stripslashes($user_input));
        if ($aq->error) {
            error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
            exit;
        }
        $members = $aq->get_query_members("notices", "index_wew", "index_sew", "notice_id");
        $requete = "select count(notice_id) from notices where (" . $members["where"] . " or code like '" . stripslashes($user_input) . "') and notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1'";
    }
    $res = pmb_mysql_query($requete, $dbh);
    $nbr_lignes = @pmb_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 notice_id, tit1, code FROM notices where notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1' ORDER BY tit1, code LIMIT {$debut},{$nb_per_page} ";
        } else {
            $requete = "select notice_id, tit1, code, " . $members["select"] . " as pert from notices where (" . $members["where"] . " or code like '" . stripslashes($user_input) . "') and notice_id!='" . $no_display . "' and niveau_biblio='s' and niveau_hierar='1' group by notice_id order by pert desc, index_serie, tnvol, index_sew, code limit {$debut},{$nb_per_page}";
        }
        $res = @pmb_mysql_query($requete, $dbh);
        print "<table><tr>";
        while ($notice = pmb_mysql_fetch_object($res)) {
            $notice_entry = $notice->tit1 . "&nbsp;" . $notice->code;
            print "\n\t\t\t\t<tr>\n\t\t\t\t\t<td>\n\t\t\t\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$notice->notice_id}', '" . htmlentities(addslashes($notice->tit1), ENT_QUOTES, $charset) . " ({$notice->code})')\">" . htmlentities($notice->tit1, ENT_QUOTES, $charset) . "</a></td>\n\t\t\t\t\t<td>{$notice->code}</td>";
            print "</tr>";
        }
        print "</table>";
        pmb_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 "<div class='row'>&nbsp;<hr /></div><div align='center'>";
    $url_base = $base_url . "&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>";
}
コード例 #2
0
ファイル: func_clas.inc.php プロジェクト: bouchra012/PMB
function dsi_list_classements()
{
    global $dbh, $msg;
    global $page, $nbr_lignes;
    global $dsi_list_tmpl;
    global $form_cb;
    // nombre de références par pages
    $nb_per_page = 10;
    if (!$nbr_lignes) {
        $requete = "SELECT COUNT(1) FROM classements ";
        $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
        $requete = "SELECT id_classement, nom_classement, type_classement FROM classements ORDER BY type_classement, nom_classement, id_classement LIMIT {$debut},{$nb_per_page} ";
        $res = @mysql_query($requete, $dbh);
        $parity = 0;
        while ($clas = mysql_fetch_object($res)) {
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./dsi.php?categ=options&sub=classements&id_classement={$clas->id_classement}&suite=acces';\" ";
            $empr_list .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>";
            $empr_list .= "\n\t\t\t\t<td>\n\t\t\t\t\t<strong>" . $msg['dsi_clas_type_class_' . $clas->type_classement] . "</strong>\n\t\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t<strong>{$clas->nom_classement}</strong>\n\t\t\t\t\t</td>\n\t\t\t\t</tr>";
            $parity += 1;
        }
        mysql_free_result($res);
        // affichage de la barre de navig
        $url_base = "{$PHP_SELF}?categ=options&sub=classements";
        $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
        if ($nbr_lignes > 0) {
            $dsi_list_tmpl = str_replace("<!--!!nb_total!!-->", "(" . $nbr_lignes . ")", $dsi_list_tmpl);
        }
        $dsi_list_tmpl = str_replace("!!cle!!", $form_cb, $dsi_list_tmpl);
        $dsi_list_tmpl = str_replace("!!list!!", $empr_list, $dsi_list_tmpl);
        $dsi_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $dsi_list_tmpl);
        $dsi_list_tmpl = str_replace("!!message_trouve!!", "", $dsi_list_tmpl);
        $ajout = "<br /><input type='button' class='bouton' value='{$msg['dsi_clas_ajouter']}' onclick=\"document.location='./dsi.php?categ=options&sub=classements&suite=add'\" />";
        return $dsi_list_tmpl . $ajout;
    } else {
        return "";
    }
}
コード例 #3
0
ファイル: codepostal.inc.php プロジェクト: bouchra012/PMB
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>';
    }
}
コード例 #4
0
ファイル: notes.inc.php プロジェクト: noble82/proyectos-ULS
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $msg;
    global $charset;
    global $idaction;
    global $current_note;
    $user_input = str_replace('*', '%', $user_input);
    if ($user_input == "") {
        $req_count = "select count(1) from demandes_notes where num_action='" . $idaction . "' and id_note !='" . $current_note . "'";
    } else {
        $req_count = "select count(1) from demandes_notes where num_action='" . $idaction . "' and contenu like '%" . $user_input . "%' and id_note !='" . $current_note . "'";
    }
    $res = pmb_mysql_query($req_count, $dbh);
    $nbr_lignes = @pmb_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 == "") {
            $req = "select id_note, date_note, CONCAT(SUBSTRING(contenu,1,50),'','...') as note from demandes_notes where num_action='" . $idaction . "' and id_note !='" . $current_note . "'";
        } else {
            $req = "select id_note, date_note, CONCAT(SUBSTRING(contenu,1,50),'','...') as note from demandes_notes where num_action='" . $idaction . "' and contenu like '%" . $user_input . "%' and id_note !='" . $current_note . "'";
        }
        $res = pmb_mysql_query($req, $dbh);
        while ($note = pmb_mysql_fetch_object($res)) {
            print "<div class='row'>";
            print "<a href='#' onclick=\"set_parent('{$caller}', '{$note->id_note}', '" . htmlentities(addslashes($note->note), ENT_QUOTES, $charset) . "')\"> [" . htmlentities(formatdate($note->date_note), ENT_QUOTES, $charset) . '] ' . htmlentities($note->note, ENT_QUOTES, $charset) . "</a>";
            print "</div>";
        }
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
    }
    print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
    $url_base = $base_url . "&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>";
}
コード例 #5
0
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $charset;
    global $msg;
    global $expl_list_id;
    // on récupére le nombre de lignes qui vont bien
    if (!$id) {
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM groupexpl";
        } else {
            $aq = new analyse_query(stripslashes($user_input));
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $requete = "select count(distinct id_groupexpl) from groupexpl where groupexpl_name like '%" . $user_input . "%'";
        }
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $expl_list = explode(",", $expl_list_id);
        $expl_list_cb = array();
        foreach ($expl_list as $id_expl) {
            $query = "SELECT expl_cb FROM exemplaires WHERE expl_id='" . $id_expl . "'";
            $result = pmb_mysql_query($query);
            if ($result && pmb_mysql_num_rows($result)) {
                $cb = pmb_mysql_result($result, 0, 0);
                $expl_list_cb[] = $cb;
            }
        }
        $last_id_used = session::get_last_used("groupexpl");
        if ($last_id_used) {
            print "<div class='selector_last_used'>\n \t\t\t\t<div class='row'>\n \t\t\t\t\t<b>" . $msg["selector_last_groupexpl_used"] . "</b>\n \t\t\t\t</div>\n \t\t\t\t<div class='row'>";
            $query = "select id_groupexpl, groupexpl_name from groupexpl where id_groupexpl=" . $last_id_used;
            $result = pmb_mysql_query($query);
            while ($group = pmb_mysql_fetch_object($result)) {
                print pmb_bidi("\n\t\t\t\t\t\t<a href=\"{$base_url}&action=add_expl&id_groupexpl=" . $group->id_groupexpl . "&expl_list=" . implode(",", $expl_list_cb) . "\">\n\t\t\t\t\t\t{$group->groupexpl_name}</a><br />");
            }
            print "</div></div>";
        }
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT groupexpl.* FROM groupexpl";
                $requete .= " ORDER BY groupexpl_name LIMIT {$debut},{$nb_per_page} ";
            } else {
                $requete = "select groupexpl.* from groupexpl where groupexpl_name like '%" . $user_input . "%' order by groupexpl_name LIMIT {$debut},{$nb_per_page}";
            }
        } else {
            $requete = "select groupexpl.* FROM groupexpl where id_groupexpl='" . $id . "'";
        }
        $res = @pmb_mysql_query($requete, $dbh);
        while ($group = pmb_mysql_fetch_object($res)) {
            print pmb_bidi("\n \t\t\t<a href=\"{$base_url}&action=add_expl&id_groupexpl=" . $group->id_groupexpl . "&expl_list=" . implode(",", $expl_list_cb) . "\">\n\t\t\t\t\t{$group->groupexpl_name}</a><br />");
        }
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage pagination
        print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
        $url_base = $base_url . "&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>";
    }
}
コード例 #6
0
ファイル: abts.inc.php プロジェクト: noble82/proyectos-ULS
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $no_display;
    global $charset;
    global $msg;
    global $callback;
    global $param1;
    // on récupére le nombre de lignes qui vont bien
    //	if($param1) $restrict=" and abt_id  not in (select num_serialcirc_abt from serialcirc) ";
    if (!$id) {
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM abts_abts where abt_id!='{$no_display}' {$restrict}";
        } else {
            $requete = "select count(distinct abt_id) from abts_abts where abt_name like '%abt%' and abt_id!='{$no_display}' {$restrict}";
        }
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = pmb_mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT * FROM abts_abts where abt_id!='{$no_display}' {$restrict} ";
                $requete .= "ORDER BY abt_name LIMIT {$debut},{$nb_per_page} ";
            } else {
                $requete = "SELECT * FROM abts_abts where  abt_name like '%{$user_input}%' and abt_id!='{$no_display}' {$restrict}";
                $requete .= "ORDER BY abt_name LIMIT {$debut},{$nb_per_page} ";
            }
        } else {
            $requete = "select * from abts_abts where abt_id='" . $id . "'";
        }
        print "<table>";
        $res = @pmb_mysql_query($requete, $dbh);
        while ($abt = pmb_mysql_fetch_object($res)) {
            $circlist_info = "";
            $flag_circlist_info = 0;
            $requete = "select id_serialcirc from serialcirc where num_serialcirc_abt=" . $abt->abt_id;
            $res_circlist = pmb_mysql_query($requete);
            print "<tr><td>";
            if (pmb_mysql_num_rows($res_circlist)) {
                $circlist_info = "<img align='top' title='" . $msg["serialcirc_img_info"] . "'  height='18' width='18' alt='" . $msg["serialcirc_img_info"] . "' src='./images/icon_a.gif'>";
                $flag_circlist_info = 1;
            }
            print "{$circlist_info}</td><td width='100%'>";
            $entry = $abt->abt_name;
            print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$abt->abt_id}', '" . htmlentities(addslashes($entry), ENT_QUOTES, $charset) . "','{$callback}',{$flag_circlist_info})\">\n\t\t\t\t{$entry}</a>");
            print "</td>";
        }
        print "</table>";
        pmb_mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage pagination
        print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
        $url_base = $base_url . "&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>";
    }
}
コード例 #7
0
function show_list_sug($id_bibli = 0)
{
    global $dbh, $base_path;
    global $msg, $charset;
    global $sug_map;
    global $sug_search_form, $sug_list_form, $filtre_src, $user_txt, $user_id, $user_statut;
    global $nb_per_page;
    global $class_path;
    global $user_input, $statut, $num_categ, $page, $nbr_lignes, $last_param;
    global $script, $bt_chk, $bt_imp, $bt_exporter;
    global $acquisition_sugg_categ;
    global $acquisition_sugg_localises, $sugg_location_id;
    global $deflt_docs_location;
    if ($acquisition_sugg_localises) {
        $sugg_location_id = (string) $sugg_location_id == "" ? $deflt_docs_location : $sugg_location_id;
    }
    // nombre de références par pages
    if (!$nb_per_page) {
        $nb_per_page = 10;
    }
    //Affichage form de recherche
    $titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_sug'], ENT_QUOTES, $charset);
    $action = "./acquisition.php?categ=sug&action=list&id_bibli=" . $id_bibli . "&user_input=&nb_per_page=" . $nb_per_page;
    $bouton_add = "<input class='bouton' type='button' value='" . $msg['acquisition_ajout_sug'] . "' onClick=\"document.location='./acquisition.php?categ=sug&sub=todo&action=modif&id_bibli=" . $id_bibli . "&sugg_location_id={$sugg_location_id}';\" />";
    $lien_last_sug = "";
    $sug_search_form = str_replace('!!form_title!!', $titre, $sug_search_form);
    $sug_search_form = str_replace('!!action!!', $action, $sug_search_form);
    $sug_search_form = str_replace('<!-- sel_state -->', $sug_map->getStateSelector(), $sug_search_form);
    $sug_search_form = str_replace('<!-- bouton_add -->', $bouton_add, $sug_search_form);
    $sug_search_form = str_replace('<!-- lien_last -->', $lien_last_sug, $sug_search_form);
    //Selecteur de localisation
    $list_locs = '';
    if ($acquisition_sugg_localises) {
        if ($sugg_location_id) {
            $temp_location = $sugg_location_id;
        } else {
            $temp_location = 0;
        }
        $locs = new docs_location();
        $list_locs = $locs->gen_combo_box_sugg($temp_location, 1, "submit();");
    }
    $sug_search_form = str_replace('<!-- sel_location -->', $list_locs, $sug_search_form);
    //Selecteur de categories
    if ($acquisition_sugg_categ != '1') {
        $sel_categ = "";
    } else {
        $tab_categ = suggestions_categ::getCategList();
        $sel_categ = "<select class='saisie-25em' id='num_categ' name='num_categ' onchange=\"submit();\">";
        $sel_categ .= "<option value='-1'>" . htmlentities($msg['acquisition_sug_tous'], ENT_QUOTES, $charset) . "</option>";
        foreach ($tab_categ as $id_categ => $lib_categ) {
            $sel_categ .= "<option value='" . $id_categ . "' > ";
            $sel_categ .= htmlentities($lib_categ, ENT_QUOTES, $charset) . "</option>";
        }
        $sel_categ .= "</select>";
    }
    $sug_search_form = str_replace('<!-- sel_categ -->', $sel_categ, $sug_search_form);
    //Affichage du filtre par source
    $req = "select * from suggestions_source order by libelle_source";
    $res = pmb_mysql_query($req, $dbh);
    $selected = "";
    $option = "<option value='0'>" . htmlentities($msg['acquisition_sugg_all_sources'], ENT_QUOTES, $charset) . "</option>";
    while ($src = pmb_mysql_fetch_object($res)) {
        $src->id_source == $filtre_src ? $selected = "selected" : ($selected = "");
        $option .= "<option value='" . $src->id_source . "' {$selected}>" . htmlentities($src->libelle_source, ENT_QUOTES, $charset) . "</option>";
    }
    $selecteur = "&nbsp;<select id='filtre_src' name='filtre_src' onchange=\"this.form.submit();\">" . $option . "</select>";
    $sug_search_form = str_replace('!!sug_filtre_src!!', $selecteur, $sug_search_form);
    $user_name = $user_txt;
    if (!$user_txt && $user_id) {
        $req = "select concat(empr_nom,', ',empr_prenom) as nom from empr where id_empr='" . $user_id . "'";
        $res = pmb_mysql_query($req, $dbh);
        $empr = pmb_mysql_fetch_object($res);
        $user_name = $empr->nom;
    }
    $sug_search_form = str_replace('!!user_txt!!', htmlentities($user_name, ENT_QUOTES, $charset), $sug_search_form);
    $sug_search_form = str_replace('!!user_id!!', htmlentities($user_id, ENT_QUOTES, $charset), $sug_search_form);
    $sug_search_form = str_replace('!!user_statut!!', htmlentities($user_statut, ENT_QUOTES, $charset), $sug_search_form);
    $sug_search_form = str_replace('!!user_input!!', htmlentities($user_input, ENT_QUOTES, $charset), $sug_search_form);
    print $sug_search_form;
    //Affiche par defaut toutes les categories de suggestions
    if ($acquisition_sugg_categ != '1') {
        $num_categ = "-1";
    } else {
        if (!$num_categ) {
            $num_categ = '-1';
        }
        print "<script type='text/javascript' >document.forms['search'].elements['num_categ'].value = '" . $num_categ . "';</script>";
    }
    if (!$statut) {
        $statut = getSessionSugState();
        //Recuperation du statut courant
    } else {
        setSessionSugState($statut);
    }
    print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = '" . $statut . "';document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
    //Prise en compte du formulaire de recherche
    $mask = $sug_map->getMask_FILED();
    // traitement de la saisie utilisateur
    require_once $class_path . "/analyse_query.class.php";
    //comptage
    if (!$nbr_lignes) {
        if (!$user_input) {
            $nbr_lignes = suggestions::getNbSuggestions($id_bibli, $statut, $num_categ, $mask, 0, $sugg_location_id, '', $filtre_src, $user_id, $user_statut);
        } else {
            $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $nbr_lignes = suggestions::getNbSuggestions($id_bibli, $statut, $num_categ, $mask, $aq, $sugg_location_id, $user_input, $filtre_src, $user_id, $user_statut);
        }
    } else {
        $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $url_base = "acquisition.php?categ=sug&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}&num_categ={$num_categ}&sugg_location_id={$sugg_location_id}&filtre_src={$filtre_src}&user_id={$user_id}&user_statut={$user_statut}";
        //affichage
        if (!$user_input) {
            $q = suggestions::listSuggestions($id_bibli, $statut, $num_categ, $mask, $debut, $nb_per_page, 0, '', $sugg_location_id, '', $filtre_src, $user_id, $user_statut);
        } else {
            $q = suggestions::listSuggestions($id_bibli, $statut, $num_categ, $mask, $debut, $nb_per_page, $aq, '', $sugg_location_id, $user_input, $filtre_src, $user_id, $user_statut);
        }
        $res = pmb_mysql_query($q, $dbh);
        //Affichage liste des suggestions
        $nbr = pmb_mysql_num_rows($res);
        $aff_row = "";
        $parity = 1;
        for ($i = 0; $i < $nbr; $i++) {
            $row = pmb_mysql_fetch_object($res);
            //recuperation origine
            $lib_orig = "";
            $typ_orig = "0";
            $q = suggestions_origine::listOccurences($row->id_suggestion, '1');
            $list_orig = pmb_mysql_query($q, $dbh);
            if (pmb_mysql_num_rows($list_orig)) {
                $row_orig = pmb_mysql_fetch_object($list_orig);
                $orig = $row_orig->origine;
                $typ_orig = $row_orig->type_origine;
            }
            //Récupération du nom du créateur de la suggestion
            $idempr = 0;
            switch ($typ_orig) {
                default:
                case '0':
                    $requete_user = "******" . $orig . "' limit 1 ";
                    $res_user = pmb_mysql_query($requete_user, $dbh);
                    $row_user = pmb_mysql_fetch_row($res_user);
                    $lib_orig = $row_user[1];
                    if ($row_user[2]) {
                        $lib_orig .= ", " . $row_user[2];
                    }
                    break;
                case '1':
                    $requete_empr = "SELECT id_empr, empr_nom, empr_prenom, empr_adr1 FROM empr where id_empr = '" . $orig . "' limit 1 ";
                    $res_empr = pmb_mysql_query($requete_empr, $dbh);
                    $row_empr = pmb_mysql_fetch_row($res_empr);
                    $lib_orig = $row_empr[1];
                    if ($row_empr[2]) {
                        $lib_orig .= ", " . $row_empr[2];
                    }
                    $idempr = $row_empr[0];
                    break;
                case '2':
                    $lib_orig = $orig;
                    break;
            }
            $lib_statut = $sug_map->getHtmlComment($row->statut);
            $col2 = "";
            if (trim($row->code) != "") {
                $col2 = htmlentities(trim($row->code), ENT_QUOTES, $charset) . "<br />";
            }
            $col2 .= htmlentities(trim($row->titre), ENT_QUOTES, $charset);
            $col3 = "";
            $col30 = "";
            $col31 = "";
            if (trim($row->auteur) != "") {
                $col30 = htmlentities(trim($row->auteur), ENT_QUOTES, $charset);
            }
            if (trim($row->editeur) != "") {
                $col31 = "[" . htmlentities(trim($row->editeur), ENT_QUOTES, $charset) . "]";
            }
            $col3 = $col30;
            if ($col3 != "" && $col31 != "") {
                $col3 .= "<br />";
            }
            $col3 .= $col31;
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $parity += 1;
            $tr_javascript_l1 = "onmouseover=\"this.className='surbrillance';this.parentNode.rows[this.rowIndex+1].className='surbrillance';\" onmouseout=\"this.className='" . $pair_impair . "';this.parentNode.rows[this.rowIndex+1].className='" . $pair_impair . "'\" ";
            $tr_javascript_l2 = "onmouseover=\"this.className='surbrillance';this.parentNode.rows[this.rowIndex-1].className='surbrillance';\" onmouseout=\"this.className='" . $pair_impair . "';this.parentNode.rows[this.rowIndex-1].className='" . $pair_impair . "'\" ";
            $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=sug&action=modif&id_bibli=" . $id_bibli . "&id_sug=" . $row->id_suggestion . "' \" ";
            if ($idempr) {
                $link_empr = "<a href='circ.php?categ=pret&id_empr={$idempr}'>";
                $link_empr_fin = "</a>";
            } else {
                $link_empr = "";
                $link_empr_fin = "";
            }
            $aff_row .= "<tr class='" . $pair_impair . "' " . $tr_javascript_l1 . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . formatdate($row->date_creation) . "<br />{$link_empr}" . htmlentities($lib_orig, ENT_QUOTES, $charset) . "{$link_empr_fin}</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . $col2 . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . $col3 . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . htmlentities($row->nb, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >" . htmlentities($row->prix, ENT_QUOTES, $charset) . "</td>\n\t\t\t\t\t\t<td " . $dn_javascript . " >{$lib_statut}</td>";
            if (!$row->num_notice) {
                $aff_row .= "<td " . $dn_javascript . " ></td>";
            } else {
                $req_ana = "select analysis_bulletin as bull , analysis_notice as noti from analysis where analysis_notice ='" . $row->num_notice . "'";
                $res_ana = pmb_mysql_query($req_ana, $dbh);
                $num_rows_ana = pmb_mysql_num_rows($res_ana);
                if ($num_rows_ana) {
                    $ana = pmb_mysql_fetch_object($res_ana);
                    $url_view = "catalog.php?categ=serials&sub=bulletinage&action=view&bul_id={$ana->bull}&art_to_show=" . $ana->noti;
                } else {
                    $url_view = "./catalog.php?categ=isbd&id=" . $row->num_notice;
                }
                $aff_row .= "<td style='text-align:center;'><a href=\"" . $url_view . "\"><img border=\"0\" align=\"middle\" title=\"" . $msg['acquisition_sug_view_not'] . "\" alt=\"" . $msg['acquisition_sug_view_not'] . "\" src=\"./images/notice.gif\" /></a></td>";
            }
            $sug_src = new suggestion_source($row->sugg_source);
            if ($acquisition_sugg_categ == '1') {
                $categ = new suggestions_categ($row->num_categ);
                $aff_row .= "<td " . $dn_javascript . " >" . htmlentities($categ->libelle_categ, ENT_QUOTES, $charset) . "<br />" . htmlentities($sug_src->libelle_source, ENT_QUOTES, $charset) . "</td>";
                $colspan = '10';
            } else {
                $aff_row .= "<td " . $dn_javascript . " >" . htmlentities($sug_src->libelle_source, ENT_QUOTES, $charset) . "</td>";
                $colspan = '9';
            }
            $sug = new suggestions($row->id_suggestion);
            $img_pj = "<a href=\"{$base_path}/explnum_doc.php?explnumdoc_id=" . $sug->get_explnum('id') . "\" target=\"_LINK_\"><img src='{$base_path}/images/globe_orange.png' /></a>";
            $img_import = "<a href=\"{$base_path}/acquisition.php?categ=sug&sub=import&explnumdoc_id=" . $sug->get_explnum('id') . " \"><img src='{$base_path}/images/upload.gif' /></a>";
            $aff_row .= "<td align='center'><i>" . ($sug->get_explnum('id') ? "{$img_pj}&nbsp;{$img_import}" : '') . "</i></td>";
            $aff_row .= "<td ><input type='checkbox' id='chk[" . $row->id_suggestion . "]' name='chk[]' value='" . $row->id_suggestion . "' /></td>\n\t\t\t\t\t</tr>";
            $aff_row .= "\t\t<tr class='" . $pair_impair . "' " . $tr_javascript_l2 . " style='cursor: pointer' >\n\t\t\t\t\t\t<td colspan='" . $colspan . "' " . $dn_javascript . " ><i>" . htmlentities($row->commentaires, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t</tr>";
        }
        $sug_list_form = str_replace('<!-- sug_list -->', $aff_row, $sug_list_form);
        //Affichage des boutons
        //Bouton Imprimer
        $imp = "openPopUp('./pdf.php?pdfdoc=listsug&user_input=" . urlencode(stripslashes($user_input)) . "&statut=" . $statut . "&num_categ=" . $num_categ . "&sugg_location_id=" . $sugg_location_id . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');";
        $bt_imp = str_replace('!!imp!!', $imp, $bt_imp);
        $sug_list_form = str_replace('<!-- bt_imp -->', $bt_imp, $sug_list_form);
        //Génération de la liste des conversions possibles
        $catalog = _parser_text_no_function_(file_get_contents($base_path . "/admin/convert/imports/catalog.xml"), "CATALOG");
        $list_export = "<select name='export_list'>";
        for ($i = 0; $i < count($catalog["ITEM"]); $i++) {
            $item = $catalog["ITEM"][$i];
            if ($item["EXPORT"] == "yes") {
                $list_export .= "<option value='" . $i . "'>" . htmlentities($item["EXPORTNAME"], ENT_QUOTES, $charset) . "</option>\n";
            }
        }
        $list_export .= "</select>";
        $bt_exporter = str_replace("<!-- list_export -->", $list_export, $bt_exporter);
        //Lien vers la page suivante
        $link_export = "document.sug_list_form.action='acquisition.php?categ=sug&sub=export'; document.sug_list_form.submit();";
        $bt_exporter = str_replace("!!exp!!", $link_export, $bt_exporter);
        $sug_list_form = str_replace('<!-- bt_exporter -->', $bt_exporter, $sug_list_form);
        //Bouton Sélectionner
        $sug_list_form = str_replace('<!-- bt_chk -->', $bt_chk, $sug_list_form);
        //Liste Boutons
        $button_list = $sug_map->getButtonList($statut);
        $sug_list_form = str_replace('<!-- bt_list -->', $button_list, $sug_list_form);
        //Bouton Reprendre
        $bt_todo = $sug_map->getButtonList_TODO($statut);
        $sug_list_form = str_replace('<!-- bt_todo -->', $bt_todo, $sug_list_form);
        if ($acquisition_sugg_categ == '1') {
            //Selecteur Affecter a une categorie
            $to_categ = $sug_map->getCategModifier($statut, $num_categ, $nb_per_page);
        } else {
            $to_categ = "";
        }
        $sug_list_form = str_replace('<!-- to_categ -->', $to_categ, $sug_list_form);
        //Bouton Supprimer
        $button_sup = $sug_map->getButtonList_DELETED($statut);
        $sug_list_form = str_replace('<!-- bt_sup -->', $button_sup, $sug_list_form);
        //JavaScript
        $script_list = $sug_map->getScriptList($statut, $num_categ, $nb_per_page);
        $script = str_replace('<!-- script_list -->', $script_list, $script);
        $sug_list_form = str_replace('<!-- script -->', $script, $sug_list_form);
        //Barre de navigation
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true);
        } else {
            $nav_bar = "";
        }
        $sug_list_form = str_replace('<!-- nav_bar -->', $nav_bar, $sug_list_form);
        print $sug_list_form;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_sug_rech'], str_replace('!!sug_cle!!', stripslashes($user_input), $msg['acquisition_sug_rech_error']), 0, './categ=sug&sub=todo&action=list&id_bibli=' . $id_bibli);
    }
}
コード例 #8
0
function show_list_fac($id_bibli)
{
    global $msg, $charset;
    global $search_form_actes, $faclist_form, $faclist_bt_chk, $faclist_script;
    global $faclist_bt_pay;
    global $nb_per_page_acq, $nb_per_page;
    global $class_path;
    global $user_input, $statut, $page, $nbr_lignes, $tri_param, $limit_param, $last_param, $sortBy;
    global $tab_bib;
    //gestion du tri
    if (!isset($sortBy)) {
        if (trim($_SESSION["acquisition_fac_sort"])) {
            $sortBy = $_SESSION["acquisition_fac_sort"];
        } else {
            $sortBy = "";
        }
    } else {
        $_SESSION["acquisition_fac_sort"] = $sortBy;
    }
    //Creation selecteur etablissement
    $sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
    foreach ($tab_bib[0] as $k => $v) {
        $sel_bibli .= "<option value='" . $v . "' ";
        if ($v == $id_bibli) {
            $sel_bibli .= "selected='selected' ";
        }
        $sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
    }
    $sel_bibli .= "</select>";
    $search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
    //Creation selecteur statut
    $sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
    $list_statut = actes::getStatelist(TYP_ACT_FAC);
    foreach ($list_statut as $k => $v) {
        $sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
    }
    $sel_statut .= "</select>";
    $search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
    //Affichage form de recherche
    $titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_fac'], ENT_QUOTES, $charset);
    $action = "./acquisition.php?categ=ach&sub=fact&action=list&user_input=";
    $search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
    $search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
    $search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
    $search_form_actes = str_replace('!!sortBy!!', $sortBy, $search_form_actes);
    print $search_form_actes;
    if (!$statut) {
        $statut = getSessionFacState();
        //Recuperation du statut courant
    } else {
        setSessionFacState($statut);
    }
    print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = " . $statut . ";document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
    //Prise en compte du formulaire de recherche
    // nombre de références par pages
    if (!isset($nb_per_page)) {
        if ($nb_per_page_acq != "") {
            $nb_per_page = $nb_per_page_acq;
        } else {
            $nb_per_page = 10;
        }
    }
    // traitement de la saisie utilisateur
    require_once $class_path . "/analyse_query.class.php";
    // on récupére le nombre de lignes qui vont bien
    if (!$nbr_lignes) {
        if (!$user_input) {
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_FAC, $statut);
        } else {
            $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_FAC, $statut, $aq, $user_input);
        }
    } else {
        $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $url_base = "{$PHP_SELF}?categ=ach&sub=fact&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}&sortBy={$sortBy}";
        // on lance la vraie requête
        if (!$user_input) {
            $res = entites::listActes($id_bibli, TYP_ACT_FAC, $statut, $debut, $nb_per_page, 0, '', $sortBy);
        } else {
            $res = entites::listActes($id_bibli, TYP_ACT_FAC, $statut, $debut, $nb_per_page, $aq, $user_input, $sortBy);
        }
        //Affichage liste des factures
        $fac_list = "";
        $nbr = pmb_mysql_num_rows($res);
        $parity = 1;
        for ($i = 0; $i < $nbr; $i++) {
            $row = pmb_mysql_fetch_object($res);
            $st = $row->statut & ~STA_ACT_ARC;
            switch ($st) {
                case STA_ACT_REC:
                    $st_fac = htmlentities($msg['acquisition_fac_rec'], ENT_QUOTES, $charset);
                    break;
                case STA_ACT_PAY:
                    $st_fac = htmlentities($msg['acquisition_fac_pay'], ENT_QUOTES, $charset);
                    break;
                default:
                    $st_fac = '';
            }
            if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
                $st_fac = '<s>' . $st_fac . '</s>';
            }
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $parity += 1;
            $tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
            $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=fact&action=modif&id_bibli=" . $id_bibli . "&id_fac=" . $row->id_acte . "' \" ";
            $fac_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->num_acte_parent . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($row->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_fac}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"openPopUp('./pdf.php?pdfdoc=fact&id_fac=" . $row->id_acte . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</td>";
            if ($statut == STA_ACT_REC) {
                $fac_list .= "<td><input type='checkbox' name='chk[]' id='chk[" . $row->id_acte . "]' value='" . $row->id_acte . "'/></td>";
            }
            $fac_list .= "</tr>";
        }
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true);
        } else {
            $nav_bar = "";
        }
        $fieldList = array("1" => "numero", "2" => "num_acte_parent", "3" => "raison_sociale", "4" => "date_acte");
        foreach ($fieldList as $k => $field) {
            if ($sortBy == $field) {
                $faclist_form = str_replace('!!sortBy_' . $k . '_1!!', "-" . $field, $faclist_form);
                $faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "&nbsp;&#x25B4;", $faclist_form);
            } elseif ($sortBy == "-" . $field) {
                $faclist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $faclist_form);
                $faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "&nbsp;&#x25BE;", $faclist_form);
            } else {
                $faclist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $faclist_form);
                $faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "", $faclist_form);
            }
        }
        $faclist_form = str_replace('<!-- fac_list -->', $fac_list, $faclist_form);
        $faclist_form = str_replace('<!-- nav_bar -->', $nav_bar, $faclist_form);
        $bt_list = '';
        $bt_sup = '';
        if ($statut == STA_ACT_REC) {
            //colonne chk
            $faclist_form = str_replace("<!-- chk_th -->", "<th class='act_cell_chkbox'>&nbsp;</th>", $faclist_form);
            //Bouton Sélectionner
            $faclist_form = str_replace('<!-- bt_chk -->', $faclist_bt_chk, $faclist_form);
            //JavaScript
            $faclist_form = str_replace('<!-- script -->', $faclist_script, $faclist_form);
            //bouton payer
            $bt_list = $faclist_bt_pay;
        }
        $faclist_form = str_replace('<!-- bt_list -->', $bt_list, $faclist_form);
        $faclist_form = str_replace('<!-- bt_sup -->', $bt_sup, $faclist_form);
        print $faclist_form;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_fac_rech'], str_replace('!!fac_cle!!', stripslashes($user_input), $msg['acquisition_fac_rech_error']), 0, './categ=ach&sub=fact&action=list&id_bibli=' . $id_bibli);
    }
}
コード例 #9
0
ファイル: collection.inc.php プロジェクト: bouchra012/PMB
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $callback;
    global $charset;
    global $msg;
    global $no_display;
    // on récupére le nombre de lignes qui vont bien
    if (!$id) {
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM collections where collection_id!='{$no_display}' ";
        } else {
            $aq = new analyse_query(stripslashes($user_input));
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $requete = $aq->get_query_count("collections", "collection_name", "index_coll", "collection_id", "collection_id!='{$no_display}'");
        }
        $res = mysql_query($requete, $dbh);
        $nbr_lignes = @mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT collections.*,publishers.* FROM collections, publishers WHERE collection_id!='{$no_display}' and ed_id=collection_parent group by collection_id";
                $requete .= " ORDER BY index_coll, index_publisher LIMIT {$debut},{$nb_per_page} ";
            } else {
                $members = $aq->get_query_members("collections", "collection_name", "index_coll", "collection_id");
                $requete = "select collections.*,publishers.*, " . $members["select"] . " as pert from collections, publishers where " . $members["where"] . " and collection_id!='{$no_display}' and ed_id=collection_parent group by collection_id order by pert desc, index_coll, index_publisher LIMIT {$debut},{$nb_per_page}";
            }
        } else {
            $requete = "select collections.*,publishers.* from collections,publishers where collection_id='" . $id . "' and collection_parent=ed_id group by collection_id";
        }
        $res = @mysql_query($requete, $dbh);
        while ($col = mysql_fetch_object($res)) {
            print pmb_bidi("\n \t\t\t<a href='#' onclick=\"set_parent('{$caller}', {$col->collection_id}, '" . htmlentities(addslashes($col->collection_name), ENT_QUOTES, $charset) . "', {$col->ed_id}, '" . htmlentities(addslashes($col->ed_name), ENT_QUOTES, $charset) . "','{$callback}')\">\n\t\t\t\t{$col->collection_name}</a>");
            print pmb_bidi(".&nbsp;{$col->ed_name}<br />");
        }
        mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage pagination
        print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
        $url_base = $base_url . "&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>";
    }
}
コード例 #10
0
                    $pair_impair = "even";
                } else {
                    $pair_impair = "odd";
                }
                $parity += 1;
                $liste_mots .= "<tr class='{$pair_impair}'><td><strong>" . stripslashes($r->mot) . "</strong></td>";
                $liste_mots .= "<td width='50%'>&nbsp;</td><td><input type='radio' id='type_lien2_" . $r->id_mot . "' name='type_lien2_" . $r->id_mot . "' onClick='modify_type_mot_vide(" . $r->id_mot . ",2);'";
                if ($r->type_lien == 2) {
                    $liste_mots .= " checked";
                }
                $liste_mots .= "></td><td><input type='radio' id='type_lien3_" . $r->id_mot . "' name='type_lien3_" . $r->id_mot . "' onClick='modify_type_mot_vide(" . $r->id_mot . ",3);'";
                if ($r->type_lien == 3) {
                    $liste_mots .= " checked";
                }
                $liste_mots .= "></td><td><input type='radio' id='type_lien4_" . $r->id_mot . "' name='type_lien4_" . $r->id_mot . "' onClick='modify_type_mot_vide(" . $r->id_mot . ",4);'";
                if ($r->type_lien == 4) {
                    $liste_mots .= " checked";
                }
                $liste_mots .= "></td><td><div class='right'><input type='button' class='bouton_small' value='" . $msg["63"] . "' onClick=\"response=confirm('" . $msg["word_del_confirm"] . "'); if (response) document.location='./autorites.php?categ=semantique&sub=empty_words&action=del&id_mot=" . $r->id_mot . "&type_lien=" . $r->type_lien . "';\"></div></td>";
                $liste_mots .= "</tr>\n";
            }
            //affichage de la pagination
            $autorites_list_empty_word = str_replace("!!pagination!!", "<div class='row'>" . aff_pagination($baseurl, $compt, $nb_per_page, $page) . "</div>", $autorites_list_empty_word);
        } else {
            $autorites_list_empty_word = str_replace("!!pagination!!", "", $autorites_list_empty_word);
        }
        $autorites_list_empty_word = str_replace("!!see_last_words!!", "<div class='right'><a href='./autorites.php?categ=semantique&sub=empty_words&action=last_words'>" . $msg["see_last_words_added"] . "</a></div>", $autorites_list_empty_word);
    }
    $autorites_list_empty_word = str_replace("!!liste_mots!!", $liste_mots, $autorites_list_empty_word);
    print $autorites_list_empty_word;
}
コード例 #11
0
ファイル: func_abo.inc.php プロジェクト: bouchra012/PMB
function dsi_list_empr($form_cb = "", $ban_priv_seuls = 1)
{
    global $dbh, $msg;
    global $page, $nbr_lignes;
    global $dsi_list_tmpl, $empr_location_id;
    global $deflt2docs_location, $empr_location_id, $pmb_lecteurs_localises;
    if ($ban_priv_seuls) {
        $form_restrict_priv = " join bannettes on num_bannette=id_bannette ";
        $where_restrict_priv = " and  proprio_bannette=id_empr ";
    }
    $retour = array();
    // nombre de références par pages
    $nb_per_page = 10;
    if ($form_cb) {
        $form_cb_rech = str_replace("*", "%", $form_cb);
        $clause = "WHERE empr_nom like '{$form_cb_rech}%' and empr_categ=id_categ_empr";
        if ($pmb_lecteurs_localises && $empr_location_id) {
            $clause .= " and empr_location={$empr_location_id} ";
        }
    } else {
        $clause = "WHERE empr_categ=id_categ_empr";
    }
    if ($empr_location_id && $pmb_lecteurs_localises) {
        $clause .= " and empr_location='{$empr_location_id}' ";
    }
    if (!$nbr_lignes) {
        $requete = "SELECT COUNT(distinct id_empr) FROM empr join bannette_abon on id_empr=num_empr {$form_restrict_priv}, empr_categ {$clause} {$where_restrict_priv} ";
        $res = mysql_query($requete, $dbh) or die(mysql_error() . "<br /><br />{$requete}");
        $nbr_lignes = @mysql_result($res, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes == 1) {
        // on lance la vraie requête
        $requete = "SELECT distinct id_empr as id FROM empr join bannette_abon on id_empr=num_empr {$form_restrict_priv}, empr_categ {$clause} {$where_restrict_priv} ";
        $res = @mysql_query($requete, $dbh);
        $id = @mysql_result($res, '0', 'id');
        if ($id) {
            $retour['id_empr'] = $id;
            $retour['message'] = $msg[dsi_encours_de_dev] . " // lecteur trouvé à partir du nom...";
            return $retour;
        }
    } else {
        if ($nbr_lignes) {
            // on lance la vraie requête
            $requete = "SELECT distinct libelle, empr_cb, empr_nom, empr_prenom, id_empr  FROM empr join bannette_abon on id_empr=num_empr {$form_restrict_priv}, empr_categ {$clause} {$where_restrict_priv} ORDER BY empr_nom, empr_prenom LIMIT {$debut},{$nb_per_page} ";
            $res = mysql_query($requete, $dbh) or die(mysql_error() . $requete);
            $parity = 0;
            while ($empr = mysql_fetch_object($res)) {
                if ($parity % 2) {
                    $pair_impair = "even";
                } else {
                    $pair_impair = "odd";
                }
                $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./dsi.php?categ=bannettes&sub=abo&id_empr={$empr->id_empr}&suite=acces';\" ";
                $empr_list .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>";
                $empr_list .= "\n\t\t\t\t<td>\n\t\t\t\t\t<strong>{$empr->empr_cb}</strong>\n\t\t\t\t\t</td>\n\t\t\t\t<td>\n        \t\t\t\t{$empr->empr_nom}&nbsp;{$empr->empr_prenom}\n\t\t\t\t\t</td>\n\t\t\t\t<td>\n\t\t\t\t\t{$empr->libelle}\n\t\t\t\t\t</td>\n\t\t\t\t</tr>";
                $parity += 1;
            }
            mysql_free_result($res);
            // affichage de la barre de navig
            $url_base = "{$PHP_SELF}?categ=bannettes&sub=abo&suite=search&form_cb=" . rawurlencode($form_cb) . "&ban_priv_seuls={$ban_priv_seuls}&empr_location_id={$empr_location_id}";
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
            $dsi_list_tmpl = str_replace("!!cle!!", $form_cb, $dsi_list_tmpl);
            $dsi_list_tmpl = str_replace("!!list!!", $empr_list, $dsi_list_tmpl);
            $dsi_list_tmpl = str_replace("!!nav_bar!!", $nav_bar, $dsi_list_tmpl);
            $dsi_list_tmpl = str_replace("!!message_trouve!!", $msg['dsi_empr_trouves'], $dsi_list_tmpl);
            $retour['id_empr'] = 0;
            $retour['message'] = $dsi_list_tmpl;
            return $retour;
        } else {
            $retour['id_empr'] = 0;
            $retour['message'] = $msg[dsi_lect_aucun_trouve];
            return $retour;
        }
    }
}
コード例 #12
0
ファイル: expl.inc.php プロジェクト: hogsim/PMB
             break;
         case "retard":
         case "retard_par_date":
             $bouton_imprime_tout = "<input type='hidden' name='act' value=''><input type='button' class='bouton' value=\"" . $msg['lettres_relance'] . "\" onclick=\"this.form.act.value='print'; this.form.submit();\" >";
             break;
         case "owner":
             break;
         case "encours":
         default:
             break;
     }
     if ($bouton_imprime_tout) {
         echo "\n\t\t\t\t\t<br />\n\t\t\t\t\t<form class='form-{$current_module}' action='' method='post'>\n\t\t\t\t\t{$bouton_imprime_tout}\n\t\t\t\t\t</form>";
     }
 }
 $nav_bar = aff_pagination("{$url_page}?categ={$categ}&sub={$sub}", $nombre_lignes_pret, $nb_per_page, $page, 10, false, true);
 print $nav_bar;
 //impression/emails (on est dans le cas retards/retards par date)
 if ($act == "print") {
     $not_all_mail = array();
     if ($nombre_lignes_pret) {
         $resultat = pmb_mysql_query($sql);
         while ($r = pmb_mysql_fetch_object($resultat)) {
             $mail_sended = 0;
             if (($mailretard_priorite_email == 1 || $mailretard_priorite_email == 2) && $r->empr_mail) {
                 // l'objet du mail
                 $var = "mailretard_" . $relance . "objet";
                 eval("\$objet=\"" . ${$var} . "\";");
                 // la formule de politesse du bas (le signataire)
                 $var = "mailretard_" . $relance . "fdp";
                 eval("\$fdp=\"" . ${$var} . "\";");
コード例 #13
0
ファイル: sel_word.inc.php プロジェクト: bouchra012/PMB
                                $affichage_mots .= htmlentities($valeur_syn, ENT_QUOTES, $charset) . "</a><br />\n";
                            }
                            $compt++;
                        }
                    } else {
                        if (pmb_substr($valeur_syn, 0, 1) == '0' || !array_search(convert_diacrit(pmb_strtolower(pmb_substr($valeur_syn, 0, 1))), $alphabet)) {
                            if ($compt >= ($page - 1) * $nb_per_page && $compt < $page * $nb_per_page) {
                                $affichage_mots .= "<a href='#' onClick=\"set_parent('" . $key . "','" . htmlentities(addslashes($valeur_syn), ENT_QUOTES, $charset) . "')\">";
                                $affichage_mots .= htmlentities($valeur_syn, ENT_QUOTES, $charset) . "</a><br />\n";
                            }
                        }
                        $compt++;
                    }
                }
            }
            $affichage_mots .= "</div>";
            $affichage_mots .= "<div class='row'>&nbsp;</div><hr />\n";
            //affichage de la pagination
            $affichage_mots .= aff_pagination($baseurl . "&user_input={$user_input}&letter=" . $letter, $compt, $nb_per_page, $page);
            $affichage_mots .= "<div class='row'>&nbsp;</div>\n";
        }
        //ajout du script
        $sel_word = str_replace("!!jscript!!", $jscript, $sel_word);
        //ajout des lettres
        $sel_word = str_replace("!!lettres!!", $affichage_lettres, $sel_word);
        //ajout des mots
        $sel_word = str_replace("!!liste_mots!!", $affichage_mots, $sel_word);
        //ajout de l'url
        $sel_word = str_replace("!!action!!", $baseurl, $sel_word);
        print $sel_word;
}
コード例 #14
0
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 $callback;
    if (!$id) {
        // on récupére le nombre de lignes
        if ($user_input == "") {
            $requete = "SELECT COUNT(1) FROM titres_uniformes where tu_id!='{$no_display}' ";
        } else {
            $aq = new analyse_query(stripslashes($user_input));
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $requete = $aq->get_query_count("titres_uniformes", "tu_name,", "index_tu", "tu_id", "tu_id!='{$no_display}'");
        }
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = @pmb_mysql_result($res, 0, 0);
    } else {
        $nbr_lignes = 1;
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        // on lance la vraie requête
        if (!$id) {
            if ($user_input == "") {
                $requete = "SELECT * FROM titres_uniformes where tu_id!='{$no_display}' ORDER BY tu_name LIMIT {$debut},{$nb_per_page} ";
            } else {
                $members = $aq->get_query_members("titres_uniformes", "tu_name", "index_tu", "tu_id");
                $requete = "select *," . $members["select"] . " as pert from titres_uniformes where " . $members["where"] . " and tu_id!='{$no_display}' group by tu_id order by pert desc,index_tu limit {$debut},{$nb_per_page}";
            }
        } else {
            $requete = "select * from titres_uniformes where tu_id='" . $id . "'";
        }
        $res = @pmb_mysql_query($requete, $dbh);
        while ($titre_uniforme = pmb_mysql_fetch_object($res)) {
            $tu = new titre_uniforme($titre_uniforme->tu_id);
            $titre_uniforme_entry = $tu->display;
            print "<div class='row'>";
            print pmb_bidi("<a href='#' onclick=\"set_parent('{$caller}', '{$titre_uniforme->tu_id}', '" . htmlentities(addslashes($titre_uniforme_entry), ENT_QUOTES, $charset) . "','{$callback}')\">{$titre_uniforme_entry}</a>");
            print "</div>";
        }
        pmb_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 "<div class='row'>&nbsp;<hr /></div><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>";
    } else {
        print $msg["aut_titre_uniforme_not_found"];
    }
}
コード例 #15
0
ファイル: frame_liste_items.php プロジェクト: bouchra012/PMB
        break;
}
$nb_per_page = 100;
if (!$page) {
    $page = 1;
}
$debut = ($page - 1) * $nb_per_page;
$rqt .= " limit {$debut},{$nb_per_page}";
$res = mysql_query($rqt, $dbh);
$st = "odd";
while ($data = mysql_fetch_array($res)) {
    if ($st == "odd") {
        $st = "even";
    } else {
        $st = "odd";
    }
    $lien = str_replace("!!id!!", $data[0], $link);
    if ($data[2]) {
        $lien = str_replace("!!id_notice!!", $data[2], $lien);
    }
    $liste .= "<tr class='" . $st . "' onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $st . "'\"  style='cursor: pointer'>\n\t\t\t\t\t<td onClick=\"parent.location.href='" . $lien . "';\">" . $data[1] . "</td>\n\t\t\t\t</tr>";
}
$global = "\n<div class='row'>\n\t<div class='right'><a href='#' onClick='parent.kill_frame_items();return false;'><img src='" . $base_path . "/images/close.gif' border='0' align='right'></a></div>\n\t<h3>" . $titre . " (" . $total . ")</h3>\n\t<table>\t\n\t\t!!liste!!\n\t</table>\n</div>";
print str_replace("!!liste!!", $liste, $global);
print "<div class='row'><div align='center'>";
$url_base = $base_path . "/admin/docs/frame_liste_items.php?what=" . $what . "&item=" . $item . "&total=" . $total;
$nav_bar = aff_pagination($url_base, $total, $nb_per_page, $page, 10, false, true);
print $nav_bar;
print "</div>";
print "</body></html>";
mysql_close($dbh);
コード例 #16
0
 /**
  * Renvoie l'affichage html de la liste pour le selecteur d'autorité
  *
  * @param onto_common_controler $controler
  * @param onto_param $params
  *
  * @return string $form
  */
 public static function get_list_selector($controler, $params)
 {
     global $msg, $charset, $element_form, $ontology_tpl, $list_form, $lang;
     if ($params->objs) {
         $property = $controler->get_onto_property_from_pmb_name($params->objs);
         $element = $property->range[$params->range];
     } else {
         $element = $controler->get_class_uri($params->element);
     }
     $elements = $controler->get_list_elements($params);
     $elements_form = "";
     $list = $list_form;
     if ($elements["nb_total_elements"]) {
         foreach ($elements['elements'] as $uri => $item) {
             switch ($element) {
                 case "http://www.w3.org/2004/02/skos/core#Concept":
                     if ($controler->has_narrower($uri, $params)) {
                         $current_element_form = $ontology_tpl['skos_concept_list_selector_line_folder'];
                         $current_element_form = str_replace("!!folder_href!!", $params->base_url . "&parent_id=" . onto_common_uri::get_id($uri), $current_element_form);
                     } else {
                         $current_element_form = $ontology_tpl['skos_concept_list_selector_line_doc'];
                     }
                     break;
                 default:
                     $current_element_form = $element_form;
                     break;
             }
             $current_element_form = str_replace("!!caller!!", $params->caller, $current_element_form);
             $current_element_form = str_replace("!!element!!", $params->element, $current_element_form);
             $current_element_form = str_replace("!!order!!", $params->order, $current_element_form);
             $current_element_form = str_replace("!!uri!!", $uri, $current_element_form);
             $current_element_form = str_replace("!!item!!", addslashes(isset($item[substr($lang, 0, 2)]) ? $item[substr($lang, 0, 2)] : $item['default']), $current_element_form);
             $current_element_form = str_replace("!!range!!", rawurlencode($element ? $element : $controler->get_class_uri($params->sub)), $current_element_form);
             $current_element_form = str_replace("!!callback!!", $params->callback, $current_element_form);
             $current_element_form = str_replace("!!item_libelle!!", htmlentities(isset($item[substr($lang, 0, 2)]) ? $item[substr($lang, 0, 2)] : $item['default'], ENT_QUOTES, $charset), $current_element_form);
             $infobulle_libelle = "";
             if ($controler->has_broader($uri, $params)) {
                 $parents = $controler->get_broaders($uri, $params);
                 if ($parents[0]["id"]) {
                     $infobulle_libelle .= $msg["onto_skos_concept_broader"] . " " . $parents[0]["label"] . ". ";
                 }
             }
             $infos = $controler->get_informations_concept($uri);
             if ($infos[0]["scopeNote"]) {
                 $infobulle_libelle .= $msg["onto_skos_concept_scopenote"] . " " . $infos[0]["scopeNote"];
             }
             $current_element_form = str_replace("!!infobulle_libelle!!", htmlentities($infobulle_libelle, ENT_QUOTES, $charset), $current_element_form);
             $elements_form .= $current_element_form;
         }
         $list = str_replace("!!elements_form!!", $elements_form, $list);
         $list = str_replace("!!aff_pagination!!", aff_pagination($params->base_url . "&concept_scheme=" . $params->concept_scheme . "&parent_id=" . $params->parent_id, $elements['nb_total_elements'], $elements['nb_onto_element_per_page'], $params->page, 10, true, true), $list);
     } else {
         $list = $msg["1915"];
     }
     return $list;
 }
コード例 #17
0
ファイル: serial_search.inc.php プロジェクト: bouchra012/PMB
    }
    while ($perio = mysql_fetch_object($myQuery)) {
        if ($nb++ > 5) {
            $recherche_ajax_mode = 1;
        }
        $edPerio = "";
        if ($perio->ed1_id) {
            $editeur = new editeur($perio->ed1_id);
            $edPerio = ' - ' . $editeur->display;
        }
        $link_serial = './catalog.php?categ=serials&sub=view&serial_id=!!id!!';
        $link_analysis = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!bul_id!!&art_to_show=!!id!!';
        $link_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!id!!';
        $link_explnum = "./catalog.php?categ=serials&sub=analysis&action=explnum_form&bul_id=!!bul_id!!&analysis_id=!!analysis_id!!&explnum_id=!!explnum_id!!";
        // function serial_display ($id, $level='1', $action_serial='', $action_analysis='', $action_bulletin='', $lien_suppr_cart="", $lien_explnum="", $bouton_explnum=1,$print=0,$show_explnum=1, $show_statut=0)
        $serial = new serial_display($perio->notice_id, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum, 0, 0, 1, 1, true, 0, $recherche_ajax_mode);
        print pmb_bidi($serial->result);
    }
    print '</div>';
    // affichage de la pagination
    print "<div class='row'><div align='center'>";
    $nav_bar = aff_pagination($base_url, $nbr_lignes, $nb_per_page_a_search, $page, 10, false, true);
    print $nav_bar;
    print '</div></div>';
} else {
    // la recherche ne renvoit qu'un résultat -> on y va direct
    $requete = "SELECT notice_id FROM notices {$acces_j} WHERE {$where} limit 1";
    $myQuery = mysql_query($requete, $dbh);
    $perio = mysql_fetch_object($myQuery);
    show_serial_info($perio->notice_id, 0, 0);
}
コード例 #18
0
ファイル: collstate.class.php プロジェクト: hogsim/PMB
 function get_display_list($base_url, $filtre, $debut = 0, $page = 0, $type = 0, $form = 1, $no_pagination = false)
 {
     global $dbh, $msg, $nb_per_page_a_search, $tpl_collstate_liste, $tpl_collstate_liste_line, $tpl_collstate_liste_form, $tpl_collstate_surloc_liste, $tpl_collstate_surloc_liste_line;
     global $explr_invisible, $pmb_droits_explr_localises, $pmb_etat_collections_localise, $deflt_docs_location;
     global $pmb_sur_location_activate;
     $location = $filtre->location;
     if (!$pmb_etat_collections_localise) {
         $location = "";
     }
     if ($pmb_droits_explr_localises && $explr_invisible) {
         $restrict_location = " location_id not in (" . $explr_invisible . ") and ";
     } else {
         $restrict_location = "";
     }
     if ($pmb_sur_location_activate) {
         $join_sur_loc = " left join sur_location on docs_location.surloc_num=sur_location.surloc_id ";
         $order_sur_loc = "surloc_libelle,";
     } else {
         $join_sur_loc = "";
         $order_sur_loc = "";
     }
     //On compte les bulletins à afficher
     $rqt = "SELECT count( collstate_id) FROM collections_state WHERE {$restrict_location} " . ($location ? "(location_id='{$location}') and " : "") . " id_serial='" . $this->serial_id . "' ";
     $myQuery = pmb_mysql_query($rqt, $dbh);
     $nbr_lignes = pmb_mysql_result($myQuery, 0, 0);
     $req = "SELECT  collstate_id , location_id FROM collections_state LEFT JOIN docs_location ON location_id=idlocation " . $join_sur_loc . " LEFT JOIN arch_emplacement ON collstate_emplacement=archempla_id WHERE {$restrict_location} " . ($location ? "(location_id='{$location}') and " : "") . "\n\tid_serial='" . $this->serial_id . "' ORDER BY " . $order_sur_loc . " " . ($pmb_etat_collections_localise ? "location_libelle, " : "") . "archempla_libelle, collstate_cote " . ($no_pagination ? '' : "LIMIT {$debut},{$nb_per_page_a_search}");
     $myQuery = pmb_mysql_query($req, $dbh);
     if (pmb_mysql_num_rows($myQuery)) {
         if ($pmb_sur_location_activate) {
             $tpl_collstate_liste[$type] = str_replace('<!-- surloc -->', $tpl_collstate_surloc_liste, $tpl_collstate_liste[$type]);
             $tpl_collstate_liste_line[$type] = str_replace('<!-- surloc -->', $tpl_collstate_surloc_liste_line, $tpl_collstate_liste_line[$type]);
         }
         $parity = 1;
         while ($coll = pmb_mysql_fetch_object($myQuery)) {
             $my_collstate = new collstate($coll->collstate_id);
             /*
             	Avoir comment gerer un + pour des grands etats de collections
             			if (count($my_collstate->state_collections)>80 || count($my_collstate->lacune)>80) {
             				$plus_statecollection="<img src='images/plus.gif' class='img_plus' onClick='if (event) e=event; else e=window.event; e.cancelBubble=true; if (e.stopPropagation) e.stopPropagation(); show_sources(\"!!id!!\"); '/>";
             				$texte_statecollection="<tr class='$pair_impair' style='display:none' id='".$coll->collstate_id."'><td>&nbsp;</td><td colspan='3'><table style='border:1px solid'>
             				<td>".str_replace("\n","<br />",$my_collstate->state_collections)."</td>
             				<td>".str_replace("\n","<br />",$my_collstate->lacune)."</td>";
             			} else $plus_statecollection="<td>&nbsp;</td>";
             */
             if ($parity++ % 2) {
                 $pair_impair = "even";
             } else {
                 $pair_impair = "odd";
             }
             // Si modifiable, ajout du lien vers le formulaire
             if ($my_collstate->explr_acces_autorise == "MODIF") {
                 $tr_javascript = "  onmousedown=\"document.location='./catalog.php?categ=serials&sub=collstate_form&id=" . $coll->collstate_id . "&serial_id=" . $this->serial_id . "';\" ";
             } else {
                 $tr_javascript = "";
             }
             $tr_surbrillance = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
             $line = str_replace('!!tr_javascript!!', $tr_javascript, $tpl_collstate_liste_line[$type]);
             $line = str_replace('!!tr_surbrillance!!', $tr_surbrillance, $line);
             $line = str_replace('!!pair_impair!!', $pair_impair, $line);
             if ($pmb_sur_location_activate) {
                 $line = str_replace('!!surloc!!', $my_collstate->surloc_libelle, $line);
             }
             $line = str_replace('!!localisation!!', $my_collstate->location_libelle, $line);
             $line = str_replace('!!cote!!', $my_collstate->cote, $line);
             $line = str_replace('!!type_libelle!!', $my_collstate->type_libelle, $line);
             $line = str_replace('!!emplacement_libelle!!', $my_collstate->emplacement_libelle, $line);
             $line = str_replace('!!statut_libelle!!', "<span class='" . $my_collstate->statut_class_html . "'  style='margin-right: 3px;'><img src='./images/spacer.gif' width='10' height='10' /></span>" . $my_collstate->statut_gestion_libelle, $line);
             $line = str_replace('!!origine!!', $my_collstate->origine, $line);
             $line = str_replace('!!state_collections!!', str_replace("\n", "<br />", $my_collstate->state_collections), $line);
             $line = str_replace('!!archive!!', $my_collstate->archive, $line);
             $line = str_replace('!!lacune!!', str_replace("\n", "<br />", $my_collstate->lacune), $line);
             $liste .= $line;
         }
         $liste = str_replace('!!collstate_liste!!', $liste, $tpl_collstate_liste[$type]);
     } else {
         $liste = $msg["collstate_no_collstate"];
     }
     if ($form) {
         $liste = str_replace('!!collstate_table!!', $liste, $tpl_collstate_liste_form);
     }
     $liste = str_replace('!!base_url!!', $base_url, $liste);
     $liste = str_replace('!!location!!', $location, $liste);
     $this->liste = $liste;
     $this->nbr = $nbr_lignes;
     // barre de navigation par page
     $this->pagination = aff_pagination($base_url . "&location={$location}", $nbr_lignes, $nb_per_page_a_search, $page, 10, false, true);
 }
コード例 #19
0
            $nb_pret = 0;
            $requete = "SELECT count( pret_idempr ) as nb_pret FROM empr_groupe,pret where groupe_id={$rgroup->id_groupe} and empr_id = pret_idempr";
            $res_pret = pmb_mysql_query($requete, $dbh);
            if (pmb_mysql_num_rows($res_pret)) {
                $rpret = pmb_mysql_fetch_object($res_pret);
                $nb_pret = $rpret->nb_pret;
            }
            $nb_resa = 0;
            $requete = "SELECT count( resa_idempr ) as nb_resa FROM empr_groupe,resa where groupe_id={$rgroup->id_groupe} and empr_id = resa_idempr";
            $res_resa = pmb_mysql_query($requete, $dbh);
            if (pmb_mysql_num_rows($res_resa)) {
                $rresa = pmb_mysql_fetch_object($res_resa);
                $nb_resa = $rresa->nb_resa;
            }
            $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./circ.php?categ=groups&action=showgroup&groupID={$rgroup->id_groupe}';\" ";
            $group_list .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>\n\t\t  \t\t\t<td>{$rgroup->libelle_groupe}</td>\n\t\t\t\t\t<td>{$rgroup->resp_name}</td>\n\t\t\t\t\t<td>{$rgroup->nb_empr}</td>\n\t\t\t\t\t<td>{$nb_pret}</td>\n\t\t\t\t\t<td>{$nb_resa}</td>\n\t\t\t\t\t</tr>";
        }
        pmb_mysql_free_result($res);
        $nav_bar = aff_pagination("{$PHP_SELF}?categ=groups&action=listgroups", $nbr_lignes, $nb_per_page, $page, 10, false, true);
        // affichage du résultat
        list_group($group_query, $filter_list, $group_list, $nav_bar, $nbr_lignes);
    } else {
        $rgroup = $rgroup = pmb_mysql_fetch_object($res);
        $groupID = $rgroup->id_groupe;
        include './circ/groups/show_group.inc.php';
    }
} else {
    // la requête n'a produit aucun résultat
    print pmb_bidi($group_search);
    error_message($msg[917], str_replace('!!group_cle!!', htmlentities(stripslashes($group_query), ENT_QUOTES, $charset), $msg[918]), 0, './circ.php?categ=groups');
}
コード例 #20
0
ファイル: expl.inc.php プロジェクト: noble82/proyectos-ULS
             break;
         case "retard":
         case "retard_par_date":
             $bouton_imprime_tout = "<input type='hidden' name='act' value=''><input type='button' class='bouton' value=\"" . $msg['lettres_relance'] . "\" onclick=\"this.form.act.value='print'; this.form.submit();\" >";
             break;
         case "owner":
             break;
         case "encours":
         default:
             break;
     }
     if ($bouton_imprime_tout) {
         echo "\n\t\t\t\t\t<br />\n\t\t\t\t\t<form class='form-{$current_module}' action='' method='post'>\n\t\t\t\t\t{$bouton_imprime_tout}\n\t\t\t\t\t</form>";
     }
 }
 $nav_bar = aff_pagination("{$url_page}?categ={$categ}&sub={$sub}&empr_location_id={$empr_location_id}&docs_location_id={$docs_location_id}", $nombre_lignes_pret, $nb_per_page, $page, 10, false, true);
 print $nav_bar;
 //impression/emails (on est dans le cas retards/retards par date)
 if ($act == "print") {
     $not_all_mail = array();
     if ($nombre_lignes_pret) {
         $resultat = pmb_mysql_query($sql);
         while ($r = pmb_mysql_fetch_object($resultat)) {
             $mail_sended = 0;
             if (($mailretard_priorite_email == 1 || $mailretard_priorite_email == 2) && $r->empr_mail) {
                 // l'objet du mail
                 $var = "mailretard_" . $relance . "objet";
                 eval("\$objet=\"" . ${$var} . "\";");
                 // la formule de politesse du bas (le signataire)
                 $var = "mailretard_" . $relance . "fdp";
                 eval("\$fdp=\"" . ${$var} . "\";");
コード例 #21
0
ファイル: devis.inc.php プロジェクト: noble82/proyectos-ULS
function show_list_dev($id_bibli)
{
    global $msg, $charset;
    global $search_form_actes, $devlist_form, $devlist_bt_chk, $devlist_script;
    global $devlist_bt_arc, $devlist_bt_delete, $devlist_bt_rec;
    global $nb_per_page_acq;
    global $class_path;
    global $user_input, $statut, $page, $nbr_lignes, $last_param;
    global $tab_bib;
    global $acquisition_pdfdev_by_mail;
    $bib = new entites($id_bibli);
    $bib_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_bibli, 1));
    //Creation selecteur etablissement
    $sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
    foreach ($tab_bib[0] as $k => $v) {
        $sel_bibli .= "<option value='" . $v . "' ";
        if ($v == $id_bibli) {
            $sel_bibli .= "selected='selected' ";
        }
        $sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
    }
    $sel_bibli .= "</select>";
    $search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
    //Creation selecteur statut
    $sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
    $list_statut = actes::getStatelist(TYP_ACT_DEV);
    foreach ($list_statut as $k => $v) {
        $sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
    }
    $sel_statut .= "</select>";
    $search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
    //Affichage form de recherche
    $titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_dev'], ENT_QUOTES, $charset);
    $action = "./acquisition.php?categ=ach&sub=devi&action=list&user_input=";
    $bouton_add = "<input class='bouton' type='button' value='" . $msg['acquisition_ajout_dev'] . "' onClick=\"document.location='./acquisition.php?categ=ach&sub=devi&action=modif&id_bibli=" . $id_bibli . "&id_dev=0';\" />";
    $search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
    $search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
    $search_form_actes = str_replace('<!-- bouton_add -->', $bouton_add, $search_form_actes);
    $search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
    print $search_form_actes;
    if (!$statut) {
        $statut = getSessionDevState();
        //Recuperation du statut courant
    } else {
        setSessionDevState($statut);
    }
    print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = '" . $statut . "';document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
    //Prise en compte du formulaire de recherche
    // nombre de références par pages
    if ($nb_per_page_acq != "") {
        $nb_per_page = $nb_per_page_acq;
    } else {
        $nb_per_page = 10;
    }
    // traitement de la saisie utilisateur
    require_once $class_path . "/analyse_query.class.php";
    // on récupére le nombre de lignes qui vont bien
    if (!$nbr_lignes) {
        if (!$user_input) {
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_DEV, $statut);
        } else {
            $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_DEV, $statut, $aq, $user_input);
        }
    } else {
        $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $url_base = "{$PHP_SELF}?categ=ach&sub=devi&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}";
        // on lance la requete
        if (!$user_input) {
            $res = entites::listActes($id_bibli, TYP_ACT_DEV, $statut, $debut, $nb_per_page);
        } else {
            $res = entites::listActes($id_bibli, TYP_ACT_DEV, $statut, $debut, $nb_per_page, $aq, $user_input);
        }
        //Affichage liste des devis
        $dev_list = "";
        $nbr = pmb_mysql_num_rows($res);
        $parity = 1;
        for ($i = 0; $i < $nbr; $i++) {
            $row = pmb_mysql_fetch_object($res);
            $fourn = new entites($row->num_fournisseur);
            $st = $row->statut & ~STA_ACT_ARC;
            switch ($st) {
                case STA_ACT_ENC:
                    $st_dev = htmlentities($msg['acquisition_dev_enc'], ENT_QUOTES, $charset);
                    break;
                case STA_ACT_REC:
                    $st_dev = htmlentities($msg['acquisition_dev_rec'], ENT_QUOTES, $charset);
                    break;
                default:
                    $st_dev = htmlentities($msg['acquisition_dev_enc'], ENT_QUOTES, $charset);
            }
            if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
                $st_dev = '<s>' . $st_dev . '</s>';
            }
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $parity += 1;
            $tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
            $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=devi&action=modif&id_bibli=" . $id_bibli . "&id_dev=" . $row->id_acte . "' \" ";
            $dev_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($fourn->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_dev}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"document.location='./acquisition.php?categ=ach&sub=devi&action=print&id_bibli=" . $id_bibli . "&id_dev=" . $row->id_acte . "&page=" . $page . "&by_mail=0'\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities(addslashes($msg['imprimer']), ENT_QUOTES, $charset) . "' title='" . htmlentities(addslashes($msg['imprimer']), ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>";
            if (($row->statut & ~STA_ACT_ARC) == STA_ACT_ENC && $acquisition_pdfdev_by_mail && strpos($bib_coord->email, '@')) {
                $dev_list .= "\t\t\t\n\t\t\t\t\t\t\t<a href=# onclick=\"document.location='./acquisition.php?categ=ach&sub=devi&action=print&id_bibli=" . $id_bibli . "&id_dev=" . $row->id_acte . "&page=" . $page . "&by_mail=1'\" >\n\t\t\t\t\t\t\t\t<img src='./images/mail.png' border='0' align='center' alt='" . htmlentities($msg['58'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['58'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>";
            }
            $dev_list .= "\t</td>";
            if ($statut != STA_ACT_ALL) {
                $dev_list .= "<td><input type='checkbox' name='chk[]' id='chk[" . $row->id_acte . "]' value='" . $row->id_acte . "'/></td>";
            }
            $dev_list .= "</tr>";
        }
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page);
        } else {
            $nav_bar = "";
        }
        $devlist_form = str_replace('<!-- dev_list -->', $dev_list, $devlist_form);
        $devlist_form = str_replace('<!-- nav_bar -->', $nav_bar, $devlist_form);
        $bt_list = '';
        $bt_sup = '';
        if ($statut != STA_ACT_ALL) {
            //colonne chk
            $devlist_form = str_replace("<!-- chk_th -->", "<th class='act_cell_chkbox'>&nbsp;</th>", $devlist_form);
            //Bouton Sélectionner
            $devlist_form = str_replace('<!-- bt_chk -->', $devlist_bt_chk, $devlist_form);
            //JavaScript
            $devlist_form = str_replace('<!-- script -->', $devlist_script, $devlist_form);
            //Bouton recevoir + archiver
            if ($statut == STA_ACT_ENC) {
                $bt_list = $devlist_bt_rec . '&nbsp;' . $devlist_bt_arc;
            }
            //Bouton archiver
            if ($statut == STA_ACT_REC) {
                $bt_list = $devlist_bt_arc;
            }
            //Bouton supprimer
            $bt_sup = $devlist_bt_delete;
        }
        $devlist_form = str_replace('<!-- bt_list -->', $bt_list, $devlist_form);
        $devlist_form = str_replace('<!-- bt_sup -->', $bt_sup, $devlist_form);
        print $devlist_form;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_dev_rech'], str_replace('!!dev_cle!!', stripslashes($user_input), $msg['acquisition_dev_rech_error']), 0, './categ=ach&sub=devi&action=list&id_bibli=' . $id_bibli);
    }
}
コード例 #22
0
ファイル: notice.inc.php プロジェクト: bouchra012/PMB
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0)
{
    global $nb_per_page;
    global $base_url;
    global $caller;
    global $msg;
    global $no_display;
    global $charset;
    global $niveau_biblio, $modele_id, $serial_id;
    global $acces_j;
    if ($niveau_biblio) {
        $filtre_notice = " and niveau_biblio='{$niveau_biblio}' ";
    }
    // on récupére le nombre de lignes qui vont bien
    if ($user_input == "") {
        $requete_count = "SELECT COUNT(1) FROM notices ";
        $requete_count .= $acces_j;
        $requete_count .= "where notice_id!='" . $no_display . "' {$filtre_notice} ";
    } else {
        $aq = new analyse_query(stripslashes($user_input));
        if ($aq->error) {
            error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
            exit;
        }
        $members = $aq->get_query_members("notices", "index_wew", "index_sew", "notice_id");
        $isbn_verif = traite_code_isbn(stripslashes($user_input));
        $suite_rqt = "";
        if (isISBN($isbn_verif)) {
            if (strlen($isbn_verif) == 13) {
                $suite_rqt = "  code like '" . formatISBN($isbn_verif, 13) . "' or code like '" . addslashes($isbn_verif) . "' ";
            } else {
                $suite_rqt = " code like '" . formatISBN($isbn_verif, 10) . "' or code like '" . addslashes($isbn_verif) . "' ";
            }
            $requete_count = "select count(1) from notices ";
            $requete_count .= $acces_j;
            $requete_count .= "where ( " . $suite_rqt . " ) ";
            $requete_count .= "and notice_id!='" . $no_display . "' {$filtre_notice}";
        } else {
            $requete_count = "select count(1) from notices ";
            $requete_count .= $acces_j;
            $requete_count .= "where (" . $members["where"] . " or code like '" . addslashes($isbn_verif) . "' ) ";
            $requete_count .= "and notice_id!='" . $no_display . "' {$filtre_notice}";
        }
    }
    $res = mysql_query($requete_count, $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 notice_id, tit1, serie_name, tnvol, code FROM notices ";
            $requete .= $acces_j;
            $requete .= "left join series on serie_id=tparent_id ";
            $requete .= "where notice_id!='" . $no_display . "' {$filtre_notice} ORDER BY index_sew, code LIMIT {$debut},{$nb_per_page} ";
        } else {
            $isbn_verif = traite_code_isbn(stripslashes($user_input));
            $suite_rqt = "";
            if (isISBN($isbn_verif)) {
                if (strlen($isbn_verif) == 13) {
                    $suite_rqt = "  code like '" . formatISBN($isbn_verif, 13) . "' or code like '" . addslashes($isbn_verif) . "' ";
                } else {
                    $suite_rqt = " code like '" . formatISBN($isbn_verif, 10) . "' or code like '" . addslashes($isbn_verif) . "' ";
                }
                $requete = "select notice_id, tit1, serie_name, tnvol, code from notices ";
                $requete .= $acces_j;
                $requete .= "left join series on serie_id=tparent_id ";
                $requete .= "where (  " . $suite_rqt . " ) ";
                $requete .= "and notice_id!='" . $no_display . "' {$filtre_notice} group by notice_id limit {$debut},{$nb_per_page}";
            } else {
                $requete = "select notice_id, tit1, serie_name, tnvol, code, " . $members["select"] . " as pert from notices ";
                $requete .= $acces_j;
                $requete .= "left join series on serie_id=tparent_id where (" . $members["where"] . " or (code like '" . addslashes($isbn_verif) . "' )) ";
                $requete .= "and notice_id!='" . $no_display . "' {$filtre_notice} group by notice_id order by pert desc, index_sew, code limit {$debut},{$nb_per_page}";
            }
        }
        $res = @mysql_query($requete, $dbh);
        while ($notice = mysql_fetch_object($res)) {
            $notice_entry = "";
            if ($notice->serie_name) {
                $notice_entry .= $notice->serie_name;
                if ($notice->tnvol) {
                    $notice_entry .= ", " . $notice->tnvol;
                }
            }
            $notice_entry ? $notice_entry .= '. ' . $notice->tit1 : ($notice_entry = $notice->tit1);
            if ($niveau_biblio) {
                $location = "./catalog.php?categ=serials&sub=modele&act=copy&modele_id={$modele_id}&serial_id={$serial_id}&new_serial_id={$notice->notice_id}";
                $display = new mono_display($notice->notice_id, 0, '', 0, '', '', '', 0, 0, 0, 0, "", 0, false, true);
                print pmb_bidi("<div class='row'>\n\t\t\t\t\t\t\t\t<div class='left'>\n\t\t\t\t\t\t\t\t\t<a href='#' onclick=\"copier_modele('{$location}')\">" . $display->result . "</a>\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class='right'>\n\t\t\t\t\t\t\t\t\t" . htmlentities($notice->code, ENT_QUOTES, $charset) . "\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>");
            } else {
                $display = new mono_display($notice->notice_id, 0, '', 0, '', '', '', 0, 0, 0, 0, "", 0, false, true);
                print pmb_bidi("<div class='row'>\n\t\t\t\t\t\t\t\t<div class='left'>\n\t\t\t\t\t\t\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$notice->notice_id}', '" . htmlentities(addslashes($notice_entry), ENT_QUOTES, $charset) . " ({$notice->code})')\">" . $display->result . "</a>\n\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t<div class='right'>\n\t\t\t\t\t\t\t\t\t" . htmlentities($notice->code, ENT_QUOTES, $charset) . "\n\t\t\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t\t\t</div>");
            }
        }
        mysql_free_result($res);
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
    }
    print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
    $url_base = $base_url . "&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>";
}
コード例 #23
0
function show_list_liv($id_bibli)
{
    global $msg, $charset;
    global $search_form_actes, $livlist_form;
    global $nb_per_page_acq;
    global $class_path;
    global $user_input, $statut, $page, $nbr_lignes, $tri_param, $limit_param, $last_param;
    global $tab_bib;
    //Creation selecteur etablissement
    $sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
    foreach ($tab_bib[0] as $k => $v) {
        $sel_bibli .= "<option value='" . $v . "' ";
        if ($v == $id_bibli) {
            $sel_bibli .= "selected='selected' ";
        }
        $sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
    }
    $sel_bibli .= "</select>";
    $search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
    //Creation selecteur statut
    $sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
    $list_statut = actes::getStatelist(TYP_ACT_LIV);
    foreach ($list_statut as $k => $v) {
        $sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
    }
    $sel_statut .= "</select>";
    $search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
    //Affichage form de recherche
    $titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_liv'], ENT_QUOTES, $charset);
    $action = "./acquisition.php?categ=ach&sub=livr&action=list&user_input=";
    $search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
    $search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
    $search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
    print $search_form_actes;
    if (!$statut) {
        $statut = getSessionLivState();
        //Recuperation du statut courant
    } else {
        setSessionLivState($statut);
    }
    print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = " . $statut . ";document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
    //Prise en compte du formulaire de recherche
    // nombre de références par pages
    if ($nb_per_page_acq != "") {
        $nb_per_page = $nb_per_page_acq;
    } else {
        $nb_per_page = 10;
    }
    // traitement de la saisie utilisateur
    require_once $class_path . "/analyse_query.class.php";
    // on récupére le nombre de lignes qui vont bien
    if (!$nbr_lignes) {
        if (!$user_input) {
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_LIV, $statut);
        } else {
            $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_LIV, $statut, $aq, $user_input);
        }
    } else {
        $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $url_base = "{$PHP_SELF}?categ=ach&sub=livr&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}";
        // on lance la vraie requête
        if (!$user_input) {
            $res = entites::listActes($id_bibli, TYP_ACT_LIV, $statut, $debut, $nb_per_page);
        } else {
            $res = entites::listActes($id_bibli, TYP_ACT_LIV, $statut, $debut, $nb_per_page, $aq, $user_input);
        }
        //Affichage liste des livraisons
        $liv_list = "";
        $nbr = pmb_mysql_num_rows($res);
        $parity = 1;
        for ($i = 0; $i < $nbr; $i++) {
            $row = pmb_mysql_fetch_object($res);
            $fourn = new entites($row->num_fournisseur);
            $id_cde = liens_actes::getParent($row->id_acte);
            $cde = new actes($id_cde);
            $st = $row->statut & ~STA_ACT_ARC;
            switch ($st) {
                case STA_ACT_REC:
                    $st_liv = htmlentities($msg['acquisition_liv_rec'], ENT_QUOTES, $charset);
                    break;
                default:
                    $st_liv = '';
            }
            if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
                $st_liv = '<s>' . $st_liv . '</s>';
            }
            if ($parity % 2) {
                $pair_impair = "even";
            } else {
                $pair_impair = "odd";
            }
            $parity += 1;
            $tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
            $dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=livr&action=modif&id_bibli=" . $id_bibli . "&id_liv=" . $row->id_acte . "' \" ";
            $liv_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $cde->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($fourn->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_liv}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"openPopUp('./pdf.php?pdfdoc=livr&id_liv=" . $row->id_acte . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>";
        }
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page);
        } else {
            $nav_bar = "";
        }
        $livlist_form = str_replace('<!-- liv_list -->', $liv_list, $livlist_form);
        $livlist_form = str_replace('<!-- nav_bar -->', $nav_bar, $livlist_form);
        print $livlist_form;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_liv_rech'], str_replace('!!liv_cle!!', stripslashes($user_input), $msg['acquisition_liv_rech_error']), 0, './categ=ach&sub=livr&action=list&id_bibli=' . $id_bibli);
    }
}
コード例 #24
0
ファイル: ontology.class.php プロジェクト: bouchra012/PMB
 public function showlist($params = array())
 {
     //un handler specifique ?
     $this->get_handler('showlist', $params);
     if (!$this->handled && $params['object'] && array_key_exists($params['object'], $this->op->t_objects)) {
         //recuperation et verification parametres
         $this->params = array('object' => $params['object'], 'page' => 1, 'offset' => 0, 'limit' => $this->limit);
         if ($params['page']) {
             $this->params['page'] = $params['page'];
         }
         $this->params['page'] += 0;
         if (!$this->params['page']) {
             $this->params['page'] = 1;
             $this->params['offset'] = 0;
         }
         if ($params['limit']) {
             $this->params['limit'] = $params['limit'];
         }
         $this->params['limit'] += 0;
         if (!$this->params['limit']) {
             $this->params['limit'] = $this->limit;
         }
         if ($this->params['page'] > 1) {
             $this->params['offset'] = ($this->params['page'] * 1 - 1) * $this->params['limit'];
         }
         $this->params['url_base'] = $params['url_base'];
         global $msg, $charset;
         global $ontology_tpl;
         $fname = $this->format($this->params['object']);
         //comptage des objets
         $count = $this->count_objects($this->params);
         //récupération des objets
         $objs = $this->get_objects($this->params);
         //récupération des proprietes a afficher dans la liste
         $p = $this->op->get_pmb_display_label($this->params['object']);
         if ($p && count($objs)) {
             foreach ($objs as $ko => $vo) {
                 $op = $this->get_object_properties($vo['s'], array($p));
                 $objs[$ko]['properties'] = $op;
             }
         }
         //Affichage entete liste
         $tpl = $ontology_tpl['list'];
         if ($msg['ontology_' . $fname]) {
             $m = $msg['ontology_' . $fname];
         } else {
             $m = $this->params['object'];
         }
         $tpl = str_replace('!!list_header!!', $m, $tpl);
         //Generation de l'affichage des lignes
         if (count($objs)) {
             $parity = 1;
             foreach ($objs as $ko => $vo) {
                 $row = $ontology_tpl['odd_row'];
                 if ($parity % 2) {
                     $row = $ontology_tpl['even_row'];
                 }
                 $parity += 1;
                 $tpl = str_replace('<!-- rows -->', $row . '<!-- rows -->', $tpl);
                 $uri = $vo['s'];
                 //lien edition
                 if ($this->params['url_base']) {
                     $form_edit_js = $ontology_tpl['edit_js'];
                     $form_edit_js = str_replace('!!edit_url!!', $this->params['url_base'] . 'edit&uri=' . rawurlencode($uri), $form_edit_js);
                     $tpl = str_replace('!!edit_url!!', $form_edit_js, $tpl);
                 } else {
                     $tpl = str_replace('!!edit_url!!', '', $tpl);
                 }
                 $t_label = array('uri' => $uri);
                 foreach ($vo['properties'] as $kp => $vp) {
                     if ($vp['p'] == $p) {
                         $t_label[$vp['o lang']] = $vp['o'];
                     }
                 }
                 $label = $t_label['uri'];
                 foreach ($this->t_lang as $kl => $vl) {
                     if (array_key_exists($kl, $t_label)) {
                         $label = $t_label[$kl];
                         break;
                     }
                 }
                 if ($charset == 'iso-8859-1') {
                     $label = utf8_decode($label);
                 }
                 $label = htmlentities($label, ENT_QUOTES, $charset);
                 $title = htmlentities($t_label['uri'], ENT_QUOTES, $charset);
                 $tpl = str_replace('!!row_content!!', $label, $tpl);
                 $tpl = str_replace('!!row_title!!', $title, $tpl);
             }
             //Affichage pagination
             $pagination_bar = '';
             if ($this->params['url_base']) {
                 $pagination_bar = aff_pagination($this->params['url_base'], $count, $this->params['limit'], $this->params['page']);
             }
             $tpl = str_replace('<!-- pagination -->', $ontology_tpl['pagination'], $tpl);
             $tpl = str_replace('<!-- pagination -->', $pagination_bar, $tpl);
         }
         //Affichage du bouton ajouter
         if ($this->params['url_base']) {
             $tpl = str_replace('<!-- add_button -->', $ontology_tpl['add_button'], $tpl);
             $tpl = str_replace('!!add_url!!', $this->params['url_base'] . 'add', $tpl);
             if ($msg['ontology_' . $fname . '_toadd']) {
                 $m = $msg['ontology_' . $fname . '_toadd'];
             } else {
                 $m = sprintf($msg['ontology_object_add'], $this->params['object']);
             }
             $tpl = str_replace('!!add_msg!!', $m, $tpl);
         }
     }
     $this->result = $tpl;
     return $this->result;
 }
コード例 #25
0
 /**
  * Renvoie l'affichage html de la liste
  *
  * @param onto_common_controler $controler
  * @param onto_param $params
  */
 public static function get_list($controler, $params)
 {
     global $msg, $charset, $ontology_tpl;
     $elements = $controler->get_list_elements($params);
     $list = $ontology_tpl['list'];
     $list = str_replace("!!list_header!!", htmlentities($msg['103'], ENT_QUOTES, $charset), $list);
     $list_content = '';
     foreach ($elements['elements'] as $uri => $item) {
         $line = $ontology_tpl['list_line'];
         $line = str_replace("!!list_line_href!!", './' . $controler->get_base_resource() . 'categ=' . $params->categ . '&sub=' . $params->sub . '&action=edit&id=' . onto_common_uri::get_id($uri), $line);
         $line = str_replace("!!list_line_libelle!!", htmlentities(isset($item[substr($lang, 0, 2)]) ? $item[substr($lang, 0, 2)] : $item['default'], ENT_QUOTES, $charset), $line);
         $list_content .= $line;
     }
     $list = str_replace("!!list_content!!", $list_content, $list);
     if (isset($msg['onto_' . $controler->get_onto_name() . '_add_' . $params->sub])) {
         $add_msg = $msg['onto_' . $controler->get_onto_name() . '_add_' . $params->sub];
     } else {
         $add_msg = sprintf($msg['onto_common_add'], $controler->get_label($params->sub));
     }
     $list = str_replace("!!list_onclick!!", 'document.location=\'./' . $controler->get_base_resource() . 'categ=' . $params->categ . '&sub=' . $params->sub . '&id=&action=edit\'', $list);
     $list = str_replace("!!list_value!!", htmlentities($add_msg, ENT_QUOTES, $charset), $list);
     $list = str_replace("!!list_pagination!!", aff_pagination("./" . $controler->get_base_resource() . "categ=" . $params->categ . "&sub=" . $params->sub . "&action=" . $params->action, $elements['nb_total_elements'], $elements['nb_onto_element_per_page'], $params->page, 10, true, true), $list);
     return $list;
 }
コード例 #26
0
function show_list_coord($id_bibli)
{
    global $msg, $charset;
    global $search_form;
    global $nb_per_page_acq;
    global $class_path;
    global $user_input, $page, $nbr_lignes, $tri_param, $limit_param, $last_param;
    global $tab_bib;
    //Creation selecteur etablissement
    $sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
    foreach ($tab_bib[0] as $k => $v) {
        $sel_bibli .= "<option value='" . $v . "' ";
        if ($v == $id_bibli) {
            $sel_bibli .= "selected='selected' ";
        }
        $sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
    }
    $sel_bibli .= "</select>";
    $search_form = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form);
    //Affichage form de recherche
    $titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_fou'], ENT_QUOTES, $charset);
    $action = "./acquisition.php?categ=ach&sub=fourn&action=list&user_input=";
    $bouton_add = "<input class='bouton' type='button' value=' " . $msg[acquisition_ajout_fourn] . " ' onclick=\"document.location='./acquisition.php?categ=ach&sub=fourn&action=add&id_bibli=" . $id_bibli . "';\" />";
    $lien_last_fou = "";
    $search_form = str_replace('!!form_title!!', $titre, $search_form);
    $search_form = str_replace('!!action!!', $action, $search_form);
    $search_form = str_replace('<!-- bouton_add -->', $bouton_add, $search_form);
    $search_form = str_replace('<!-- lien_last -->', $lien_last_fou, $search_form);
    $search_form = str_replace('!!user_input!!', $user_input, $search_form);
    print $search_form;
    print "<script type='text/javascript' >document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
    //Prise en compte du formulaire de recherche
    // nombre de références par pages
    if ($nb_per_page_acq != "") {
        $nb_per_page = $nb_per_page_acq;
    } else {
        $nb_per_page = 10;
    }
    // traitement de la saisie utilisateur
    require_once $class_path . "/analyse_query.class.php";
    // on récupére le nombre de lignes qui vont bien
    if (!$nbr_lignes) {
        if (!$user_input) {
            $nbr_lignes = entites::getNbFournisseurs($id_bibli);
        } else {
            $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
            if ($aq->error) {
                error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
                exit;
            }
            $nbr_lignes = entites::getNbFournisseurs($id_bibli, $aq);
        }
    } else {
        $aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        $url_base = "{$PHP_SELF}?categ=ach&sub=fourn&action=list&id_bibli=" . $id_bibli . "&user_input=" . rawurlencode(stripslashes($user_input));
        // on lance la vraie requête
        if (!$user_input) {
            $res = entites::list_fournisseurs($id_bibli, $debut, $nb_per_page);
        } else {
            $res = entites::list_fournisseurs($id_bibli, $debut, $nb_per_page, $aq);
        }
        //Affichage liste des fournisseurs
        print "<table>";
        $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 . "'\" ";
            $dn_javascript = " onmousedown=\"document.location='./acquisition.php?categ=ach&sub=fourn&action=modif&id_bibli=" . $id_bibli . "&id=" . $row->id_entite . "'\" ";
            print "<tr class='" . $pair_impair . "' " . $tr_javascript . " >\n\t\t\t\t\t\t<td " . $dn_javascript . " style='cursor: pointer'><i>" . htmlentities($row->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td ><a href='./acquisition.php?categ=ach&sub=fourn&action=cond&id_bibli=" . $id_bibli . "&id=" . $row->id_entite . "' >" . htmlentities($msg['acquisition_cond_fourn'], ENT_QUOTES, $charset) . "</a></td>\n\t\t\t\t\t\t<td ><a href='./acquisition.php?categ=ach&sub=fourn&action=histrel&id_bibli=" . $id_bibli . "&id=" . $row->id_entite . "' >" . htmlentities($msg['acquisition_hist_rel_fou'], ENT_QUOTES, $charset) . "</a></td>\n\t\t\t\t\t</tr>";
        }
        print "</table>";
        if (!$last_param) {
            $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page);
        } else {
            $nav_bar = "";
        }
        print $nav_bar;
    } else {
        // la requête n'a produit aucun résultat
        error_message($msg['acquisition_fou_rech'], str_replace('!!fou_cle!!', stripslashes($user_input), $msg['acquisition_fou_rech_error']), 0, './categ=ach&sub=fourn&action=list&id_bibli=' . $id_bibli);
    }
}
コード例 #27
0
ファイル: ontology.inc.php プロジェクト: bouchra012/PMB
//show_results($dbh, $user_input, $nbr_lignes, $page);
$params['objects'] = $t_objs;
$params['user_input'] = $user_input;
$res = $sh->search_objects($params);
if (!is_array($res)) {
    print $res;
    print "<br />";
} else {
    $nbr_lignes = count($res);
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    if ($nbr_lignes) {
        for ($i = $debut; $i < $nb_per_page + $debut; $i++) {
            $label = $sh->get_object_label($res[$i]["subject_type"], $res[$i]["subject_uri"]);
            print pmb_bidi("\n \t\t\t\t<a href='#' onclick=\"set_parent('" . $caller . "', '" . rawurlencode($res[$i]["subject_uri"]) . "', '" . htmlentities(addslashes($label), ENT_QUOTES, $charset) . "','" . $callback . "')\">" . htmlentities($label, ENT_QUOTES, $charset) . "</a><br />");
        }
        // constitution des liens
        $nbepages = ceil($nbr_lignes / $nb_per_page);
        $suivante = $page + 1;
        $precedente = $page - 1;
        // affichage pagination
        print "<div class='row'>&nbsp;<hr /></div><div align='center'>";
        $url_base = $base_url . "&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>";
    }
}
print $sel_footer;
コード例 #28
0
ファイル: cart.inc.php プロジェクト: hogsim/PMB
function aff_cart_objects($idcaddie = 0, $url_base = "./catalog.php?categ=caddie&sub=gestion&quoi=panier&idcaddie=0", $no_del = false, $rec_history = 0, $no_point = false)
{
    global $msg;
    global $dbh;
    global $begin_result_liste, $end_result_liste;
    global $affich_tris_result_liste;
    global $pmb_nb_max_tri;
    global $nbr_lignes, $page, $nb_per_page_search;
    global $url_base_suppr_cart;
    $url_base_suppr_cart = $url_base;
    $cb_display = "\n\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t    \t\t<span class=\"notice-heada\">!!heada!!</span>\n\t    \t\t<br />\n\t\t\t</div>\n\t\t\t";
    // nombre de références par pages
    if ($nb_per_page_search != "") {
        $nb_per_page = $nb_per_page_search;
    } else {
        $nb_per_page = 10;
    }
    // on récupére le nombre de lignes
    if (!$nbr_lignes) {
        $requete = "SELECT count(1) FROM caddie_content where caddie_id='" . $idcaddie . "' ";
        $res = pmb_mysql_query($requete, $dbh);
        $nbr_lignes = pmb_mysql_result($res, 0, 0);
    }
    if (!$page) {
        $page = 1;
    }
    $debut = ($page - 1) * $nb_per_page;
    //Calcul des variables pour la suppression de notices
    $modulo = $nbr_lignes % $nb_per_page;
    if ($modulo == 1) {
        $page_suppr = !$page ? 1 : $page - 1;
    } else {
        $page_suppr = $page;
    }
    $nb_after_suppr = $nbr_lignes ? $nbr_lignes - 1 : 0;
    if ($nbr_lignes) {
        // on lance la vraie requête
        $myCart = new caddie($idcaddie);
        $caddie_type = $myCart->type;
        switch ($caddie_type) {
            case "NOTI":
                $from = " caddie_content left join notices on notice_id = object_id ";
                $order_by = " index_sew ";
                break;
            case "EXPL":
                $from = " caddie_content left join exemplaires on expl_id=object_id left join notices on notice_id = expl_notice ";
                $order_by = " index_sew ";
                break;
            case "BULL":
                $from = " caddie_content left join bulletins on bulletin_id = object_id ";
                $order_by = " date_date ";
                break;
        }
        $requete = "SELECT * FROM {$from} where caddie_id='" . $idcaddie . "' order by {$order_by}";
        $requete .= " LIMIT {$debut},{$nb_per_page} ";
        //gestion du tri
        if ($caddie_type == "NOTI") {
            if ($nbr_lignes <= $pmb_nb_max_tri) {
                if ($_SESSION["tri"]) {
                    $requete = "SELECT notice_id,caddie_content.* FROM {$from} where caddie_id='" . $idcaddie . "'";
                    $sort = new sort('notices', 'base');
                    $requete = $sort->appliquer_tri($_SESSION["tri"], $requete, "notice_id", $debut, $nb_per_page);
                }
            }
        }
        // fin gestion tri
        $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
        // l'affichage du résultat est fait après le else
    } else {
        print $msg[399];
        return;
    }
    $liste = array();
    $result = @pmb_mysql_query($requete, $dbh);
    // or die (pmb_mysql_error());
    if ($result) {
        if (pmb_mysql_num_rows($result)) {
            while ($temp = pmb_mysql_fetch_object($result)) {
                $liste[] = array('object_id' => $temp->object_id, 'content' => $temp->content, 'blob_type' => $temp->blob_type, 'flag' => $temp->flag);
            }
        }
    }
    if (!sizeof($liste) || !is_array($liste)) {
        print $msg[399];
        return;
    } else {
        print "\n\t\t<script>\n\t\t\tvar ajax_pointage=new http_request();\n\t\t\tvar num_caddie=0;\n\t\t\tvar num_item=0;\n\t\t\tvar action='';\n\t\t\tfunction add_pointage_item(idcaddie,id_item) {\n\t\t\t\tnum_caddie=idcaddie;\n\t\t\t\tnum_item=id_item;\n\t\t\t\taction='add_item';\t\n\t\t\t\tvar url = './ajax.php?module=catalog&categ=pointage_add&sub=pointage&moyen=manu&action=add_item&idcaddie='+idcaddie+'&id_item='+id_item;\n\t\t \t\tajax_pointage.request(url,0,'',1,pointage_callback,0,0);\n\t\t\t}\n\t\t\t\n\t\t\tfunction del_pointage_item(idcaddie,id_item) {\n\t\t\t\tnum_caddie=idcaddie;\n\t\t\t\tnum_item=id_item;\n\t\t\t\taction='del_item';\n\t\t\t\tvar url = './ajax.php?module=catalog&categ=pointage_del&sub=pointage&moyen=manu&action=del_item&idcaddie='+idcaddie+'&id_item='+id_item;\n\t\t\t\tajax_pointage.request(url,0,'',1,pointage_callback,0,0);   \n\t\t\t}\n\t\t\tfunction pointage_callback(response) {\n\t\t\t\tdata = eval('('+response+')');\n\t\t\t\tswitch (action) {\n\t\t\t\t\tcase 'add_item':\n\t\t\t\t\t\tif (data.res_pointage == 1) {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/depointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_depointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','del_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/pointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_pointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','add_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t}\n\t\t\t\t\t\tbreak;\n\t\t\t\t\tcase 'del_item':\n\t\t\t\t\t\tif (data.res_pointage == 1) {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/pointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_pointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','add_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).src='./images/depointer.png';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).title='" . $msg['caddie_item_depointer'] . "';\n\t\t\t\t\t\t\tdocument.getElementById('caddie_'+num_caddie+'_item_'+num_item).setAttribute('onclick','del_pointage_item('+num_caddie+','+num_item+')');\n\t\t\t\t\t\t}\n\t\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tvar div = document.createElement('div');\n\t\t\t\tdiv.setAttribute('id','cart_'+data.idcaddie+'_nb_items');\n\t\t\t\tdiv.innerHTML = data.aff_cart_nb_items;\n\t\t\t\tdocument.getElementById('cart_'+data.idcaddie+'_nb_items').parentNode.replaceChild(div,document.getElementById('cart_'+data.idcaddie+'_nb_items'));\n\t\t\t}\n\t\t</script>";
        // en fonction du type de caddie on affiche ce qu'il faut
        if ($caddie_type == "NOTI") {
            // boucle de parcours des notices trouvées
            // inclusion du javascript de gestion des listes dépliables
            // début de liste
            print $begin_result_liste;
            //Affichage du lien impression et panier
            if ($rec_history && $_SESSION["CURRENT"] !== false) {
                $current = $_SESSION["CURRENT"];
                print "&nbsp;<a href='#' onClick=\"openPopUp('./print_cart.php?current_print={$current}&action=print_prepare','print',600,700,-2,-2,'scrollbars=yes,menubar=0'); return false;\"><img src='./images/basket_small_20x20.gif' border='0' align='center' alt=\"" . $msg["histo_add_to_cart"] . "\" title=\"" . $msg["histo_add_to_cart"] . "\"></a>&nbsp;<a href='#' onClick=\"openPopUp('./print.php?current_print={$current}&action_print=print_prepare','print',500,600,-2,-2,'scrollbars=yes,menubar=0'); return false;\"><img src='./images/print.gif' border='0' align='center' alt=\"" . $msg["histo_print"] . "\" title=\"" . $msg["histo_print"] . "\"/></a>";
                print "&nbsp;<a href='#' onClick=\"openPopUp('./download.php?current_download={$current}&action_download=download_prepare" . $tri_id_info . "','download',500,600,-2,-2,'scrollbars=yes,menubar=0'); return false;\"><img src='./images/upload_docnum.gif' border='0' align='center' alt=\"" . $msg["docnum_download"] . "\" title=\"" . $msg["docnum_download"] . "\"/></a>";
                if ($nbr_lignes <= $pmb_nb_max_tri) {
                    print "&nbsp;" . $affich_tris_result_liste;
                }
            }
            print caddie::show_actions($idcaddie, $caddie_type);
            while (list($cle, $object) = each($liste)) {
                if ($object[content] == "") {
                    // affichage de la liste des notices sous la forme 'expandable'
                    $requete = "SELECT * FROM notices WHERE notice_id={$object['object_id']} LIMIT 1";
                    $fetch = pmb_mysql_query($requete);
                    if (pmb_mysql_num_rows($fetch)) {
                        $notice = pmb_mysql_fetch_object($fetch);
                        if ($notice->niveau_biblio == 'b') {
                            // notice de bulletin
                            $rqtbull = "select bulletin_id from bulletins where num_notice=" . $notice->notice_id;
                            $fetchbull = pmb_mysql_query($rqtbull);
                            $bull = pmb_mysql_fetch_object($fetchbull);
                            $link = "./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=" . $bull->bulletin_id;
                            // pas affichés pour l'instant:
                            $link_expl = '';
                            $link_explnum = '';
                            if (!$no_point) {
                                if ($object[flag]) {
                                    $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $notice->notice_id . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $notice->notice_id . ");' style='cursor: pointer'/>";
                                } else {
                                    $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $notice->notice_id . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $notice->notice_id . ");' style='cursor: pointer'/>";
                                }
                            } else {
                                if ($object[flag]) {
                                    $marque_flag = "<img src='images/tick.gif'/>";
                                } else {
                                    $marque_flag = "";
                                }
                            }
                            if (!$no_del) {
                                $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=NOTI&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                            } else {
                                $lien_suppr_cart = $marque_flag;
                            }
                            $display = new mono_display($notice, 6, $link, 1, $link_expl, $lien_suppr_cart, $link_explnum, 0, 0, 1, 1);
                            print pmb_bidi($display->result);
                        } elseif ($notice->niveau_biblio != 's' && $notice->niveau_biblio != 'a') {
                            // notice de monographie
                            $link = './catalog.php?categ=isbd&id=!!id!!';
                            $link_expl = './catalog.php?categ=edit_expl&id=!!notice_id!!&cb=!!expl_cb!!&expl_id=!!expl_id!!';
                            $link_explnum = './catalog.php?categ=edit_explnum&id=!!notice_id!!&explnum_id=!!explnum_id!!';
                            if (!$no_point) {
                                if ($object[flag]) {
                                    $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $notice->notice_id . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $notice->notice_id . ");' style='cursor: pointer'/>";
                                } else {
                                    $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $notice->notice_id . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $notice->notice_id . ");' style='cursor: pointer'/>";
                                }
                            } else {
                                if ($object[flag]) {
                                    $marque_flag = "<img src='images/tick.gif'/>";
                                } else {
                                    $marque_flag = "";
                                }
                            }
                            if (!$no_del) {
                                $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=NOTI&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                            } else {
                                $lien_suppr_cart = $marque_flag;
                            }
                            $display = new mono_display($notice, 6, $link, 1, $link_expl, $lien_suppr_cart, $link_explnum, 0, 0, 1, 1);
                            print pmb_bidi($display->result);
                        } else {
                            // on a affaire à un périodique
                            // préparation des liens pour lui
                            $link_serial = './catalog.php?categ=serials&sub=view&serial_id=!!id!!';
                            $link_analysis = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!bul_id!!&art_to_show=!!id!!';
                            $link_bulletin = './catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=!!id!!';
                            if (!$no_point) {
                                if ($object[flag]) {
                                    $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $notice->notice_id . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $notice->notice_id . ");' style='cursor: pointer'/>";
                                } else {
                                    $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $notice->notice_id . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $notice->notice_id . ");' style='cursor: pointer'/>";
                                }
                            } else {
                                if ($object[flag]) {
                                    $marque_flag = "<img src='images/tick.gif'/>";
                                } else {
                                    $marque_flag = "";
                                }
                            }
                            if (!$no_del) {
                                $lien_suppr_cart = "<a href='{$url_base}&action=del_item&action=del_item&object_type=NOTI&item={$notice->notice_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                            } else {
                                $lien_suppr_cart = $marque_flag;
                            }
                            if ($notice->niveau_biblio == 's') {
                                $link_explnum = "./catalog.php?categ=serials&sub=explnum_form&serial_id=!!serial_id!!&explnum_id=!!explnum_id!!";
                            } else {
                                $link_explnum = "./catalog.php?categ=serials&sub=analysis&action=explnum_form&bul_id=!!bul_id!!&analysis_id=!!analysis_id!!&explnum_id=!!explnum_id!!";
                            }
                            $serial = new serial_display($notice, 6, $link_serial, $link_analysis, $link_bulletin, $lien_suppr_cart, $link_explnum, 0, 0, 1, 1);
                            print pmb_bidi($serial->result);
                        }
                    }
                } else {
                    if ($object[flag]) {
                        $marque_flag = "<img src='images/tick.gif'/>";
                    } else {
                        $marque_flag = "";
                    }
                    if (!$no_del) {
                        $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=EXPL_CB&item=" . $object[content] . "&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                    } else {
                        $lien_suppr_cart = $marque_flag;
                    }
                    $cb_display = "\n\t\t\t\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t\t\t\t    \t\t<span class=\"notice-heada\"><strong>{$lien_suppr_cart} " . $msg["4014"] . " : {$object['content']}&nbsp;: {$msg[395]}</strong></span>\n\t\t\t\t    \t\t<br />\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t";
                    print $cb_display;
                }
            }
            // fin de liste
            print $end_result_liste;
        }
        // fin si NOTI
        // si EXPL
        if ($caddie_type == "EXPL") {
            // boucle de parcours des exemplaires trouvés
            // inclusion du javascript de gestion des listes dépliables
            // début de liste
            print $begin_result_liste;
            print caddie::show_actions($idcaddie, $caddie_type);
            while (list($cle, $expl) = each($liste)) {
                if (!$expl[content]) {
                    if ($stuff = get_expl_info($expl[object_id])) {
                        if (!$no_point) {
                            if ($expl[flag]) {
                                $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $stuff->expl_id . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $stuff->expl_id . ");' style='cursor: pointer'/>";
                            } else {
                                $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $stuff->expl_id . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $stuff->expl_id . ");' style='cursor: pointer'/>";
                            }
                        } else {
                            if ($expl[flag]) {
                                $marque_flag = "<img src='images/tick.gif'/>";
                            } else {
                                $marque_flag = "";
                            }
                        }
                        if (!$no_del) {
                            $stuff->lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=EXPL&item={$stuff->expl_id}&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                        } else {
                            $stuff->lien_suppr_cart = $marque_flag;
                        }
                        $stuff = check_pret($stuff);
                        print pmb_bidi(print_info($stuff, 0, 1));
                    } else {
                        print "<strong>ID : {$expl['object_id']}&nbsp;: {$msg[395]}</strong>";
                    }
                } else {
                    if (!$no_point) {
                        if ($expl[flag]) {
                            $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $stuff->expl_id . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $stuff->expl_id . ");' style='cursor: pointer'/>";
                        } else {
                            $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $stuff->expl_id . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $stuff->expl_id . ");' style='cursor: pointer'/>";
                        }
                    } else {
                        if ($expl[flag]) {
                            $marque_flag = "<img src='images/tick.gif'/>";
                        } else {
                            $marque_flag = "";
                        }
                    }
                    if (!$no_del) {
                        $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=EXPL_CB&item=" . $expl[content] . "&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                    } else {
                        $lien_suppr_cart = $marque_flag;
                    }
                    $cb_display = "\n\t\t\t\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t\t\t\t    \t\t<span class=\"notice-heada\"><strong>{$lien_suppr_cart} Code-barre : {$expl['content']}&nbsp;: {$msg[395]}</strong></span>\n\t\t\t\t    \t\t<br />\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t";
                    print $cb_display;
                }
            }
            // fin de liste
            print $end_result_liste;
        }
        // fin si EXPL
        if ($caddie_type == "BULL") {
            // boucle de parcours des bulletins trouvés
            // inclusion du javascript de gestion des listes dépliables
            // début de liste
            print $begin_result_liste;
            print caddie::show_actions($idcaddie, $caddie_type);
            while (list($cle, $expl) = each($liste)) {
                if (!$no_del) {
                    $show_del = 1;
                } else {
                    $show_del = 0;
                }
                if ($bull_aff = show_bulletinage_info($expl[object_id], 0, $show_del, $expl[flag], 1)) {
                    print pmb_bidi($bull_aff);
                } else {
                    if (!$no_point) {
                        if ($expl[flag]) {
                            $marque_flag = "<img src='images/depointer.png' id='caddie_" . $idcaddie . "_item_" . $expl[object_id] . "' title=\"" . $msg['caddie_item_depointer'] . "\" onClick='del_pointage_item(" . $idcaddie . "," . $expl[object_id] . ");' style='cursor: pointer'/>";
                        } else {
                            $marque_flag = "<img src='images/pointer.png' id='caddie_" . $idcaddie . "_item_" . $expl[object_id] . "' title=\"" . $msg['caddie_item_pointer'] . "\" onClick='add_pointage_item(" . $idcaddie . "," . $expl[object_id] . ");' style='cursor: pointer'/>";
                        }
                    } else {
                        if ($expl[flag]) {
                            $marque_flag = "<img src='images/tick.gif'/>";
                        } else {
                            $marque_flag = "";
                        }
                    }
                    if (!$no_del) {
                        $lien_suppr_cart = "<a href='{$url_base}&action=del_item&object_type=EXPL_CB&item=" . $expl[content] . "&page={$page_suppr}&nbr_lignes={$nb_after_suppr}&nb_per_page={$nb_per_page}'><img src='./images/basket_empty_20x20.gif' alt='basket' title=\"" . $msg[caddie_icone_suppr_elt] . "\" /></a> {$marque_flag}";
                    } else {
                        $lien_suppr_cart = $marque_flag;
                    }
                    $cb_display = "\n\t\t\t\t\t\t<div id=\"el!!id!!Parent\" class=\"notice-parent\">\n\t\t\t\t    \t\t<span class=\"notice-heada\"><strong>{$lien_suppr_cart} Code-barre : {$expl['content']}&nbsp;: {$msg[395]}</strong></span>\n\t\t\t\t    \t\t<br />\n\t\t\t\t\t\t</div>\n\t\t\t\t\t\t";
                    print $cb_display;
                }
            }
            // fin de liste
            print $end_result_liste;
        }
        // fin si BULL
    }
    print "<br />" . $nav_bar;
    return;
}
コード例 #29
0
 function get_list_selector()
 {
     global $msg, $charset, $dbh;
     global $user_query, $user_input, $page, $nbr_lignes, $last_param;
     global $callback;
     global $caller;
     global $base_url;
     $nb_per_page = 10;
     if (!$page) {
         $page = 1;
     }
     $debut = ($page - 1) * $nb_per_page;
     $search_word = str_replace('*', '%', $user_input);
     if (!($nb_per_page * 1)) {
         $nb_per_page = $nb_per_page_search;
     }
     if (!$page) {
         $page = 1;
     }
     if (!$last_param) {
         $debut = ($page - 1) * $nb_per_page;
         $requete = "SELECT count(1) FROM authperso_authorities where ( authperso_infos_global like '%" . $search_word . "%' or authperso_index_infos_global like '%" . $user_input . "%' ) and authperso_authority_authperso_num= " . $this->id;
         $res = pmb_mysql_query($requete, $dbh);
         $nbr_lignes = pmb_mysql_result($res, 0, 0);
         $req = "select * from authperso_authorities where ( authperso_infos_global like '%" . $search_word . "%' or authperso_index_infos_global like '%" . $user_input . "%' ) and  authperso_authority_authperso_num= " . $this->id;
         $req .= " order by authperso_index_infos_global LIMIT " . $debut . "," . $nb_per_page . " ";
     } else {
         // les derniers créés
         $req = "select * from authperso_authorities where  authperso_authority_authperso_num= " . $this->id;
         $req .= " order by id_authperso_authority DESC LIMIT {$nb_per_page}";
     }
     $res = pmb_mysql_query($req, $dbh);
     while ($r = pmb_mysql_fetch_object($res)) {
         $id = $r->id_authperso_authority;
         $isbd = $this->get_isbd($id);
         $auth_lines .= "<a href='#' onclick=\"set_parent('" . $caller . "', '" . $id . "', '" . htmlentities(addslashes($isbd), ENT_QUOTES, $charset) . "','" . $callback . "')\">" . htmlentities($isbd, ENT_QUOTES, $charset) . "</a><br />";
     }
     //$url_base = $base_url."&user_input=".rawurlencode(stripslashes($user_input));
     $nav_bar = aff_pagination($base_url, $nbr_lignes, $nb_per_page, $page, 10, false, true);
     $authperso_list_tpl = "\t\t\r\n\t\t\t<br />\r\n\t\t\t\t{$auth_lines}\n\t\t\t<div class='row'>&nbsp;<hr /></div><div align='center'>\t\t\t\r\n\t\t\t\t{$nav_bar}\r\n\t\t\t</div>\r\n\t\t";
     return $authperso_list_tpl;
 }
コード例 #30
0
ファイル: fiche.class.php プロジェクト: hogsim/PMB
 function show_search_list($action = '', $url_base = '', $page = 1)
 {
     global $form_search, $fichier_menu_display, $perso_word, $prefix;
     global $dbh, $msg, $charset;
     global $nb_per_page_search, $nb_per_page;
     global $dest;
     $search_word = str_replace('*', '%', $perso_word);
     if (!($nb_per_page * 1)) {
         $nb_per_page = $nb_per_page_search;
     }
     if (!$page) {
         $page = 1;
     }
     $debut = ($page - 1) * $nb_per_page;
     $requete = "SELECT count(1) FROM fiche where infos_global like '%" . $search_word . "%' or index_infos_global like '%" . $perso_word . "%'";
     $res = pmb_mysql_query($requete, $dbh);
     $nbr_lignes = pmb_mysql_result($res, 0, 0);
     $req = "select id_fiche from fiche where infos_global like '%" . $search_word . "%' or index_infos_global like '%" . $perso_word . "%' ";
     if (!isset($dest) || !$dest) {
         $req .= " LIMIT " . $debut . "," . $nb_per_page . " ";
     }
     $res = pmb_mysql_query($req, $dbh);
     while ($fic = pmb_mysql_fetch_object($res)) {
         $result[$fic->id_fiche] = $this->get_values($fic->id_fiche, 1);
     }
     $form_search = str_replace("!!nb_per_page!!", $nb_per_page, $form_search);
     $form_search = str_replace("!!perso_word!!", htmlentities(stripslashes($perso_word), ENT_QUOTES, $charset), $form_search);
     if (!$result) {
         $form_search = str_replace("!!message_result!!", sprintf($msg['fichier_no_result_found'], $perso_word), $form_search);
         print $form_search;
     } else {
         $nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true);
         $form_search = str_replace("!!message_result!!", "", $form_search);
         if ($dest == "TABLEAUHTML") {
             print $this->display_results_tableau($result, "", $debut, true);
         } elseif ($dest == "TABLEAU") {
             $this->print_results_tableau($result);
         } else {
             print $form_search;
             print $this->display_results_tableau($result, "", $debut);
             print $nav_bar;
         }
     }
 }