function show_results($dbh, $nbr_lignes = 0, $page = 0) { global $nb_per_page; global $base_url; global $caller; global $charset; global $msg; global $id_fou; // on récupére le nombre de lignes qui vont bien $nbr_lignes = types_produits::countTypes(); if (!$page) { $page = 1; } $debut = ($page - 1) * $nb_per_page; if ($nbr_lignes) { // on lance la vraie requête $q = types_produits::listTypes($debut, $nb_per_page); $res = mysql_query($q, $dbh); while ($row = mysql_fetch_object($res)) { $typ = $row->id_produit; $lib_typ = $row->libelle; $taux_tva = new tva_achats($row->num_tva_achat); $lib_tva = htmlentities($taux_tva->taux_tva, ENT_QUOTES, $charset); $offre = new offres_remises($id_fou, $row->id_produit); if ($offre->remise) { $lib_rem = htmlentities($offre->remise, ENT_QUOTES, $charset); } else { $lib_rem = '0'; } print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_produit}', '" . htmlentities(addslashes($lib_typ), ENT_QUOTES, $charset) . "', '{$lib_rem}', '{$lib_tva}' )\">{$lib_typ}</a>"); print "<br />"; } mysql_free_result($res); // constitution des liens $nbepages = ceil($nbr_lignes / $nb_per_page); $suivante = $page + 1; $precedente = $page - 1; // affichage du lien précédent si nécessaire print '<hr /><div align=center>'; if ($precedente > 0) { print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>"; } for ($i = 1; $i <= $nbepages; $i++) { if ($i == $page) { print "<b>{$i}/{$nbepages}</b>"; } } if ($suivante <= $nbepages) { print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>"; } } print '</div>'; }
function show_list_type() { global $dbh, $msg, $charset; global $acquisition_gestion_tva; $aff = ''; $aff .= "<table>\n\t<tr>\n\t\t<th>" . htmlentities($msg[103], ENT_QUOTES, $charset) . "</th>\n\t\t<th>" . htmlentities($msg['acquisition_num_cp_compta'], ENT_QUOTES, $charset) . "</th>"; if ($acquisition_gestion_tva) { $aff .= "<th>" . htmlentities($msg['acquisition_num_tva_achat'], ENT_QUOTES, $charset) . "</th>"; } $aff .= "</tr>"; $q = types_produits::listTypes(); $res = pmb_mysql_query($q, $dbh); $nbr = pmb_mysql_num_rows($res); $tab_tva = array(); if ($acquisition_gestion_tva) { $q2 = tva_achats::listTva(); $r2 = pmb_mysql_query($q2, $dbh); while ($row = pmb_mysql_fetch_object($r2)) { $tab_tva[$row->id_tva] = $row->libelle; } } $parity = 1; for ($i = 0; $i < $nbr; $i++) { $row = pmb_mysql_fetch_object($res); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=type&action=modif&id={$row->id_produit}';\" "; $aff .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'>"; $aff .= "<td><i>" . htmlentities($row->libelle, ENT_QUOTES, $charset) . "</i></td>"; $aff .= "<td><i>" . htmlentities($row->num_cp_compta, ENT_QUOTES, $charset) . "</i></td>"; if ($acquisition_gestion_tva) { $aff .= "<td><i>" . htmlentities($tab_tva[$row->num_tva_achat], ENT_QUOTES, $charset) . "</i></td>"; } $aff .= "</tr>"; } $aff .= "</table>\n\t\t<input class='bouton' type='button' value=' " . $msg[acquisition_ajout_type] . " ' onClick=\"document.location='./admin.php?categ=acquisition&sub=type&action=add'\" />"; print $aff; }
$array_selector = $p_perso->get_ajax_list($persofield, $start); $origine = 'ARRAY'; break; case 'perso_collstate': require_once $class_path . '/parametres_perso.class.php'; $p_perso = new parametres_perso('notices'); $array_selector = $p_perso->get_ajax_list($persofield, $start); $origine = 'ARRAY'; break; case 'types_produits': // $param1 : id_fournisseur $array_selector = array(); require_once $class_path . '/types_produits.class.php'; require_once $class_path . '/tva_achats.class.php'; require_once $class_path . '/offres_remises.class.php'; $q = types_produits::listTypes(); $res = pmb_mysql_query($q, $dbh); while ($row = pmb_mysql_fetch_object($res)) { $typ = $row->id_produit; $lib_typ = $row->libelle; $taux_tva = new tva_achats($row->num_tva_achat); $lib_tva = htmlentities($taux_tva->taux_tva, ENT_QUOTES, $charset); $offre = new offres_remises($linkfield, $row->id_produit); if ($offre->remise) { $lib_rem = htmlentities($offre->remise, ENT_QUOTES, $charset); } else { $lib_rem = '0'; } $array_selector[$typ . ',' . $lib_rem . ',' . $lib_tva] = htmlentities($lib_typ, ENT_QUOTES, $charset); } $origine = "ARRAY";