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); } }
} show_list_coord(); break; case 'add': show_coord_form(); break; case 'modif': if (entites::exists($id)) { show_coord_form($id); } else { show_list_coord(); } break; case 'del': if ($id) { $total2 = entites::getNbFournisseurs($id); $total3 = entites::has_exercices($id); $total4 = entites::has_budgets($id); $total5 = entites::has_suggestions($id); $total7 = entites::has_actes($id, 1); if ($total2 + $total3 + $total4 + $total5 + $total7 == 0) { entites::delete($id); show_list_coord(); } else { $msg_suppr_err = $msg[acquisition_entite_used]; if ($total2) { $msg_suppr_err .= "<br />- " . $msg[acquisition_entite_used_fou]; } if ($total3) { $msg_suppr_err .= "<br />- " . $msg[acquisition_entite_used_exe]; }
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 $id_bibli; //comptage if ($user_input == "") { $nbr_lignes = entites::getNbFournisseurs($id_bibli); } 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; } $nbr_lignes = entites::getNbFournisseurs($id_bibli, $aq); } if (!$page) { $page = 1; } $debut = ($page - 1) * $nb_per_page; if ($nbr_lignes) { //liste 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); } while ($row = mysql_fetch_object($res)) { $entry = $row->raison_sociale; $adresse = ''; if ($caller != 'form_abonnement') { $coord = entites::get_coordonnees($row->id_entite, '1'); if (mysql_num_rows($coord) != 0) { $coord = mysql_fetch_object($coord); if ($coord->libelle != '') { $adresse = htmlentities(addslashes($coord->libelle), ENT_QUOTES, $charset) . "\\n"; } if ($coord->contact != '') { $adresse .= htmlentities(addslashes($coord->contact), ENT_QUOTES, $charset) . "\\n"; } if ($coord->adr1 != '') { $adresse .= htmlentities(addslashes($coord->adr1), ENT_QUOTES, $charset) . "\\n"; } if ($coord->adr2 != '') { $adresse .= htmlentities(addslashes($coord->adr2), ENT_QUOTES, $charset) . "\\n"; } if ($coord->cp != '') { $adresse .= htmlentities(addslashes($coord->cp), ENT_QUOTES, $charset) . ' '; } if ($coord->ville != '') { $adresse .= htmlentities(addslashes($coord->ville), ENT_QUOTES, $charset); } } } print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_entite}', '" . htmlentities(addslashes($entry), ENT_QUOTES, $charset) . "', '{$adresse}' )\">{$entry}</a>"); print "<br />"; } mysql_free_result($res); // constitution des liens $nbepages = ceil($nbr_lignes / $nb_per_page); $suivante = $page + 1; $precedente = $page - 1; // affichage du lien précédent si nécessaire print '<hr /><div align=center>'; if ($precedente > 0) { print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&user_input=" . rawurlencode(stripslashes($user_input)) . "&no_display={$no_display}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>"; } for ($i = 1; $i <= $nbepages; $i++) { if ($i == $page) { print "<b>{$i}/{$nbepages}</b>"; } } if ($suivante <= $nbepages) { print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&user_input=" . rawurlencode(stripslashes($user_input)) . "&no_display={$no_display}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>"; } } print '</div>'; }