function show_list_biblio() { global $dbh; global $msg; global $charset; //Récupération de l'utilisateur $requete_user = "******" . SESSlogin . "' limit 1 "; $res_user = pmb_mysql_query($requete_user, $dbh); $row_user = pmb_mysql_fetch_row($res_user); $user_userid = $row_user[0]; //Affichage de la liste des etablissements auxquels a acces l'utilisateur $aff = "<table>"; $q = entites::list_biblio($user_userid); $res = pmb_mysql_query($q, $dbh); $nbr = pmb_mysql_num_rows($res); if (!$nbr) { //Pas d'etablissements définis pour l'utilisateur $error = true; $error_msg .= htmlentities($msg["acquisition_err_coord"], ENT_QUOTES, $charset) . "<div class='row'></div>"; } if ($error) { error_message($msg[321], $error_msg . htmlentities($msg["acquisition_err_par"], ENT_QUOTES, $charset), '1', './admin.php?categ=acquisition'); die; } if ($nbr == '1') { $row = pmb_mysql_fetch_object($res); show_list_exer($row->id_entite); } else { $parity = 1; while ($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=compta&action=list&ent={$row->id_entite}';\" "; $aff .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>{$row->raison_sociale}</i></td></tr>"; } $aff .= "</table>"; print $aff; } }
function show_list_coord() { global $dbh; global $msg; global $charset; print "<table>"; $q = entites::list_biblio(); $res = mysql_query($q, $dbh); $nbr = mysql_num_rows($res); $parity = 1; for ($i = 0; $i < $nbr; $i++) { $row = mysql_fetch_object($res); if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript = " onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='{$pair_impair}'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=entite&action=modif&id={$row->id_entite}';\" "; print "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td><i>{$row->raison_sociale}</i></td></tr>"; } print "</table>\n\t\t<input class='bouton' type='button' value=' " . htmlentities($msg[acquisition_ajout_biblio], ENT_QUOTES, $charset) . " ' onClick=\"document.location='./admin.php?categ=acquisition&sub=entite&action=add'\" />"; }
// +-------------------------------------------------+ // © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net) // +-------------------------------------------------+ // $Id: acquisition.inc.php,v 1.15 2015-08-13 08:06:36 jpermanne Exp $ if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) { die("no access"); } require_once "{$class_path}/entites.class.php"; require_once "{$class_path}/paiements.class.php"; require_once "{$class_path}/frais.class.php"; require_once "{$class_path}/types_produits.class.php"; require_once "{$class_path}/offres_remises.class.php"; require_once "{$class_path}/tva_achats.class.php"; //Recherche des etablissements auxquels a acces l'utilisateur $q = entites::list_biblio(SESSuserid); $list_bib = pmb_mysql_query($q, $dbh); $nb_bib = pmb_mysql_num_rows($list_bib); $tab_bib = array(); while ($row = pmb_mysql_fetch_object($list_bib)) { $tab_bib[0][] = $row->id_entite; $tab_bib[1][] = $row->raison_sociale; } //si on arrive par print_acquisition.php, pas d'entêtes if (!$acquisition_no_html) { echo window_title($database_window_title . $msg[acquisition_menu] . $msg[1003] . $msg[1001]); } switch ($categ) { case 'ach': if (!$nb_bib) { //Pas de bibliothèques définies pour l'utilisateur
function get_coordonnees_etab($user_id = '0', $field_values, $current_field, $form_name) { global $dbh, $msg, $charset; global $acquisition_active; global $user_acquisition_adr_form; if (!$acquisition_active) { return; } if (!($field_values[7] & ACQUISITION_AUTH)) { return; } if ($user_id == '0') { return; } //Affichage de la liste des bibliothèques auxquelles a accès l'utilisateur $q = entites::list_biblio($user_id); $res = mysql_query($q, $dbh); $nbr = mysql_num_rows($res); if ($nbr == '0') { return; } $tab1 = explode('|', $field_values[$current_field]); $tab_adr = array(); foreach ($tab1 as $key => $value) { $tab2 = explode(',', $value); $tab_adr[$tab2[0]]['id_adr_fac'] = $tab2[1]; $tab_adr[$tab2[0]]['id_adr_liv'] = $tab2[2]; } while ($row = mysql_fetch_object($res)) { $acquisition_user_param .= "<div class='row'>"; $acquisition_user_param .= "<label class='etiquette'>" . htmlentities($row->raison_sociale, ENT_QUOTES, $charset) . "</label>"; $temp_adr_form = $user_acquisition_adr_form; if ($tab_adr[$row->id_entite]['id_adr_fac']) { $coord = new coordonnees($tab_adr[$row->id_entite]['id_adr_fac']); $id_adr_fac = $coord->id_contact; if ($coord->libelle != '') { $adr_fac = htmlentities($coord->libelle, ENT_QUOTES, $charset) . "\n"; } if ($coord->contact != '') { $adr_fac .= htmlentities($coord->contact, ENT_QUOTES, $charset) . "\n"; } if ($coord->adr1 != '') { $adr_fac .= htmlentities($coord->adr1, ENT_QUOTES, $charset) . "\n"; } if ($coord->adr2 != '') { $adr_fac .= htmlentities($coord->adr2, ENT_QUOTES, $charset) . "\n"; } if ($coord->cp != '') { $adr_fac .= htmlentities($coord->cp, ENT_QUOTES, $charset) . ' '; } if ($coord->ville != '') { $adr_fac .= htmlentities($coord->ville, ENT_QUOTES, $charset); } } else { $id_adr_fac = '0'; $adr_fac = ''; } if ($tab_adr[$row->id_entite]['id_adr_liv']) { $coord = new coordonnees($tab_adr[$row->id_entite]['id_adr_liv']); $id_adr_liv = $coord->id_contact; if ($coord->libelle != '') { $adr_liv = htmlentities($coord->libelle, ENT_QUOTES, $charset) . "\n"; } if ($coord->contact != '') { $adr_liv .= htmlentities($coord->contact, ENT_QUOTES, $charset) . "\n"; } if ($coord->adr1 != '') { $adr_liv .= htmlentities($coord->adr1, ENT_QUOTES, $charset) . "\n"; } if ($coord->adr2 != '') { $adr_liv .= htmlentities($coord->adr2, ENT_QUOTES, $charset) . "\n"; } if ($coord->cp != '') { $adr_liv .= htmlentities($coord->cp, ENT_QUOTES, $charset) . ' '; } if ($coord->ville != '') { $adr_liv .= htmlentities($coord->ville, ENT_QUOTES, $charset); } } else { $id_adr_liv = 0; $adr_liv = ''; } $temp_adr_form = str_replace('!!id_bibli!!', $row->id_entite, $temp_adr_form); $temp_adr_form = str_replace('!!id_adr_liv!!', $id_adr_liv, $temp_adr_form); $temp_adr_form = str_replace('!!adr_liv!!', $adr_liv, $temp_adr_form); $temp_adr_form = str_replace('!!id_adr_fac!!', $id_adr_fac, $temp_adr_form); $temp_adr_form = str_replace('!!adr_fac!!', $adr_fac, $temp_adr_form); $acquisition_user_param .= $temp_adr_form; $acquisition_user_param .= "</div>"; } $acquisition_user_param = str_replace('!!form_name!!', $form_name, $acquisition_user_param); $acquisition_user_param = "<hr /><div class='row'>" . htmlentities($msg['acquisition_user_deflt_adr'], ENT_QUOTES, $charset) . $acquisition_user_param . "</div>"; return $acquisition_user_param; }