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;
}
