\n";
}
public function set_properties_from_form() {
global $form_login, $form_pwd, $form_nom, $form_prenom;
global $droits, $user_lang;
global $form_nb_per_page_search, $form_nb_per_page_select, $form_nb_per_page_gestion;
global $form_expl_visibilite;
global $sel_group;
global $form_user_email;
global $form_user_alert_resamail, $form_user_alert_contribmail, $form_user_alert_demandesmail, $form_user_alert_subscribemail, $form_user_alert_suggmail, $form_user_alert_serialcircmail;
$form_login = stripslashes($form_login);
if($this->username != $form_login && !empty($form_login)) {
$this->username = $form_login;
}
if(!$this->userid && !empty($form_pwd)) {
$this->pwd = stripslashes($form_pwd);
}
$this->nom = stripslashes($form_nom);
$this->prenom = stripslashes($form_prenom);
$this->rights = stripslashes($droits);
$this->user_lang = $user_lang;
$this->nb_per_page_search = $form_nb_per_page_search+0;
$this->nb_per_page_select = $form_nb_per_page_select+0;
$this->nb_per_page_gestion = $form_nb_per_page_gestion+0;
$this->explr_invisible = $form_expl_visibilite[0];
$this->explr_visible_mod = $form_expl_visibilite[1];
$this->explr_visible_unmod = $form_expl_visibilite[2];
if (isset($sel_group)) {
$this->grp_num = $sel_group;
}
$this->user_email = stripslashes($form_user_email);
$this->user_alert_resamail = intval($form_user_alert_resamail);
$this->user_alert_contribmail = intval($form_user_alert_contribmail);
$this->user_alert_demandesmail = intval($form_user_alert_demandesmail);
$this->user_alert_subscribemail = intval($form_user_alert_subscribemail);
$this->user_alert_suggmail = intval($form_user_alert_suggmail);
$this->user_alert_serialcircmail = intval($form_user_alert_serialcircmail);
}
public function save() {
global $form_style;
global $form_deflt_docs_location;
$dummy=array();
$dummy[0] = "username='".addslashes($this->username)."'";
$dummy[1] = "nom='".addslashes($this->nom)."'";
$dummy[2] = "prenom='".addslashes($this->prenom)."'";
$dummy[3] = "rights='".$this->rights."'";
$dummy[4] = "user_lang='".addslashes($this->user_lang)."'";
$dummy[5] = "nb_per_page_search='".$this->nb_per_page_search."'";
$dummy[6] = "nb_per_page_select='".$this->nb_per_page_select."'";
$dummy[7] = "nb_per_page_gestion='".$this->nb_per_page_gestion."'";
$dummy[8] = "explr_invisible='".$this->explr_invisible."'";
$dummy[9] = "explr_visible_mod='".$this->explr_visible_mod."'";
$dummy[10]= "explr_visible_unmod='".$this->explr_visible_unmod."'";
if (isset($this->grp_num)) {
$dummy[11]= "grp_num='".$this->grp_num."'";
}
/* insérer ici la maj des param et deflt */
if($this->userid || $this->duplicate_from_userid) {
$i = 0;
if($this->duplicate_from_userid) {
$requete_param = "SELECT * FROM users WHERE userid='".$this->duplicate_from_userid."' LIMIT 1 ";
} else {
$requete_param = "SELECT * FROM users WHERE userid='".$this->userid."' LIMIT 1 ";
}
$res_param = pmb_mysql_query($requete_param);
while ($i < pmb_mysql_num_fields($res_param)) {
$field = pmb_mysql_field_name($res_param, $i) ;
$field_deb = substr($field,0,6);
switch ($field_deb) {
case "deflt_" :
if ($field == "deflt_styles") {
$dummy[$i+12]=$field."='".$form_style."'";
} elseif ($field == "deflt_docs_section") {
$formlocid="f_ex_section".$form_deflt_docs_location ;
global ${$formlocid};
$dummy[$i+12]=$field."='".${$formlocid}."'";
} else {
$var_form = "form_".$field;
global ${$var_form};
$dummy[$i+12]=$field."='".(isset(${$var_form}) ? ${$var_form} : '')."'";
}
break;
case "deflt2" :
$var_form = "form_".$field;
global ${$var_form};
$dummy[$i+12]=$field."='".${$var_form}."'";
break ;
case "param_" :
$var_form = "form_".$field;
global ${$var_form};
$dummy[$i+12]=$field."='".(isset(${$var_form}) ? ${$var_form} : '')."'";
break ;
case "value_" :
$var_form = "form_".$field;
global ${$var_form};
$dummy[$i+12]=$field."='".(isset(${$var_form}) ? ${$var_form} : '')."'";
break ;
case "deflt3" :
$var_form = "form_".$field;
global ${$var_form};
$dummy[$i+12]=$field."='".(isset(${$var_form}) ? ${$var_form} : '')."'";
break ;
case "xmlta_" :
$var_form = "form_".$field;
global ${$var_form};
$dummy[$i+12]=$field."='".(isset(${$var_form}) ? ${$var_form} : '')."'";
break ;
case "speci_" :
$speci_func = substr($field, 6);
eval('$dummy[$i+12] = set_'.$speci_func.'();');
break;
default :
break ;
}
$i++;
}
}
$dummy[] = "user_email='".addslashes($this->user_email)."'";
$dummy[] = "user_alert_resamail='".$this->user_alert_resamail."'";
$dummy[] = "user_alert_contribmail='".$this->user_alert_contribmail."'";
$dummy[] = "user_alert_demandesmail='".$this->user_alert_demandesmail."'";
$dummy[] = "user_alert_subscribemail='".$this->user_alert_subscribemail."'";
$dummy[] = "user_alert_suggmail='".$this->user_alert_suggmail."'";
$dummy[] = "user_alert_serialcircmail='".$this->user_alert_serialcircmail."'";
if(!$this->userid && $this->pwd) {
if(!$this->pwd_encrypted) {
$dummy[] = "pwd=password('".addslashes($this->pwd)."')";
} else {
$dummy[] = "pwd='".addslashes($this->pwd)."'";
}
}
if (!empty($dummy)) {
$set = implode($dummy, ", ");
}
if(!empty($set)) {
if($this->userid) {
$set = "SET last_updated_dt=curdate(),".$set;
$requete = "UPDATE users $set WHERE userid=".$this->userid." ";
} else {
$set = "SET create_dt=curdate(), last_updated_dt=curdate(),".$set;
$requete = "INSERT INTO users ".$set;
}
pmb_mysql_query($requete);
}
}
public static function delete($id, $user_encours) {
if($id && $id !=1) {
$requete = "select username from users where userid=$id ";
$res=pmb_mysql_fetch_row( pmb_mysql_query($requete));
$username_del=$res[0];
$requete = "DELETE FROM users WHERE userid=$id and username<>'".addslashes($user_encours)."'";
$res = pmb_mysql_query($requete);
if ($res) {
$requete = "DELETE FROM sessions WHERE login='".$username_del."'";
$res = pmb_mysql_query($requete);
$requete = "DELETE FROM es_methods_users WHERE num_user=$id ";
$res = pmb_mysql_query($requete);
}
$requete = "OPTIMIZE TABLE users ";
$res = pmb_mysql_query($requete);
return true;
}
return false;
}
public static function get_fields_query($id, $all_fields=false, $field='') {
if($all_fields) {
$query = "SELECT * ";
} elseif($field) {
$query = "SELECT ".$field." ";
} else {
$query = "SELECT username, nom, prenom, rights, userid, user_lang, ";
$query .="nb_per_page_search, nb_per_page_select, nb_per_page_gestion, ";
$query .="param_popup_ticket, param_sounds, ";
$query .="user_email, user_alert_resamail, user_alert_contribmail, user_alert_demandesmail, user_alert_subscribemail, user_alert_serialcircmail, user_alert_suggmail, explr_invisible, explr_visible_mod, explr_visible_unmod, grp_num ";
}
$query .="FROM users WHERE userid='$id' LIMIT 1 ";
return $query;
}
public static function get_field_radio($field, $selected) {
global $msg;
return
"
".$msg[$field]."
\n
".$msg[39]."
".$msg[40]."
\n";
}
public static function get_field_checkbox($field, $checked) {
global $msg;
return
"
".$msg[$field]."
\n
\n";
}
public static function get_form($id=0, $caller='', $field='') {
global $msg, $charset;
global $base_path, $class_path, $include_path;
global $deflt_concept_scheme, $thesaurus_concepts_active;
global $pmb_droits_explr_localises, $pmb_docnum_in_database_allow;
global $deflt_docs_location;
global $cms_active;
global $pmb_scan_request_activate;
global $pmb_short_loan_management;
global $pmb_printer_name;
global $acquisition_active, $begin_result_liste;
global $pmb_gestion_abonnement, $pmb_gestion_financiere;
//A verifier : si ce sont bien des globales
global $explr_invisible;
global $explr_visible_unmod;
global $explr_visible_mod;
global $user_lang;
$requete = static::get_fields_query($id);
$res = pmb_mysql_query($requete);
$nbr = pmb_mysql_num_rows($res);
if ($nbr) {
$usr=pmb_mysql_fetch_object($res);
} else die ('Unknown user');
if($field) {
$requete_param = static::get_fields_query($id, false, $field);
} else {
$requete_param = static::get_fields_query($id, true);
}
$res_param = pmb_mysql_query($requete_param);
$field_values = pmb_mysql_fetch_row( $res_param );
$param_user = '';
$deflt_user = '';
if (empty($field)) {
$param_user = "
".$msg["1500"]."
\n";
$deflt_user = "
".$msg["1501"]."
\n";
}
$speci_user="";
$deflt3user="";
$value_user="";
$param_user_allloc="";
$deflt_user_array = array();
$i = 0;
while ($i < pmb_mysql_num_fields($res_param)) {
$field = pmb_mysql_field_name($res_param, $i) ;
$field_deb = substr($field,0,6);
switch ($field_deb) {
case "deflt_" :
switch ($field) {
case 'deflt_styles':
$deflt_user_style = static::get_field_selector($field, make_user_style_combo($field_values[$i]));
break;
case 'deflt_docs_location':
// Visibilité des exemplaires
$where_clause_explr = '';
if ($pmb_droits_explr_localises && $usr->explr_visible_mod) {
$where_clause_explr = "idlocation in ($usr->explr_visible_mod) and";
}
$selector = gen_liste("select distinct idlocation, location_libelle from docs_location, docsloc_section where $where_clause_explr num_location=idlocation order by 2 ", "idlocation", "location_libelle", 'form_'.$field, "account_calcule_section(this);", $field_values[$i], "", "","","", 0);
$deflt_user_array['expl'][] = static::get_field_selector($field, $selector);
// Localisation de l'utilisateur pour le calcul de la section
$location_user_section = $field_values[$i];
break;
case 'deflt_collstate_location':
$selector = gen_liste("select distinct idlocation, location_libelle from docs_location order by 2 ", "idlocation", "location_libelle", 'form_'.$field, "", $field_values[$i], "", "", "0", $msg["all_location"], 0);
$deflt_user_array['collstate'][] = static::get_field_selector($field, $selector);
break;
case 'deflt_resas_location':
$selector = gen_liste("select distinct idlocation, location_libelle from docs_location order by 2 ", "idlocation", "location_libelle", 'form_'.$field, "", $field_values[$i], "", "", "0", $msg["all_location"], 0);
$deflt_user_array['other'][] = static::get_field_selector($field, $selector);
break;
case 'deflt_docs_section':
// Calcul des sections
$selector = '';
if (empty($location_user_section)) {
$location_user_section = $deflt_docs_location;
}
$where_clause_explr = '';
if ($pmb_droits_explr_localises && $usr->explr_visible_mod) {
$where_clause_explr = "where idlocation in ($usr->explr_visible_mod)";
}
$rqtloc = "SELECT idlocation FROM docs_location $where_clause_explr order by location_libelle";
$resloc = pmb_mysql_query($rqtloc);
while ($loc = pmb_mysql_fetch_object($resloc)) {
$requete = "SELECT idsection, section_libelle FROM docs_section, docsloc_section where idsection=num_section and num_location='$loc->idlocation' order by section_libelle";
$result = pmb_mysql_query($requete);
$nbr_lignes = pmb_mysql_num_rows($result);
if ($nbr_lignes) {
$display = 'none';
if ($loc->idlocation == $location_user_section) {
$display = 'block';
}
$selector .= "