function show_empr_form($form_action, $form_cancel, $link, $id, $cb, $duplicate_empr_from_id = "")
{
global $empr_form;
global $dbh, $msg, $charset;
global $biblio_email;
global $aff_list_empr;
global $deflt2docs_location;
global $pmb_lecteurs_localises;
global $pmb_gestion_abonnement, $pmb_gestion_financiere, $empr_abonnement_default_debit;
global $empr_prolong_calc_date_adhes_depassee;
global $database_window_title;
global $lang;
global $pmb_rfid_activate, $pmb_rfid_serveur_url;
global $pmb_opac_view_activate;
// si $id est fourni, il s'agit d'une modification. on recupere les donnees dans $link
if ($id) {
// modification
echo window_title($database_window_title . $msg[55]);
$entete = $msg[55];
if ($pmb_rfid_activate == 1 && $pmb_rfid_serveur_url) {
$script_rfid_encode = "if(script_rfid_encode()==false) return false;";
} else {
$script_rfid_encode = '';
}
$empr_form = str_replace("!!questionrfid!!", $script_rfid_encode, $empr_form);
$requete = "SELECT * FROM empr WHERE id_empr='{$id}' ";
$res = mysql_query($requete, $link);
if ($res) {
$empr = mysql_fetch_object($res);
} else {
error_message($msg[53], $msg[54], 0);
}
} else {
// création
$empr = new stdClass();
$entete = $msg[15];
$empr_form = str_replace("!!questionrfid!!", '', $empr_form);
}
if ($duplicate_empr_from_id) {
$empr_form = str_replace("!!id!!", "", $empr_form);
$empr_form = str_replace("!!entete!!", $msg["empr_duplicate"], $empr_form);
} else {
$empr_form = str_replace("!!id!!", $id, $empr_form);
$empr_form = str_replace("!!entete!!", $entete, $empr_form);
}
$empr_form = str_replace("!!form_action!!", $form_action, $empr_form);
if ($empr->empr_cb) {
//Si il y a un code lecteur
if (!$duplicate_empr_from_id) {
$empr_form = str_replace("!!cb!!", $empr->empr_cb, $empr_form);
} else {
$empr_form = str_replace("!!cb!!", $cb, $empr_form);
}
$date_adhesion = !$duplicate_empr_from_id ? $empr->empr_date_adhesion : date('Y-m-d');
$date_clic = "onClick=\"openPopUp('./select.php?what=calendrier&caller=empr_form&date_caller=" . preg_replace('/-/', '', $date_adhesion) . "¶m1=form_adhesion¶m2=form_adhesion_lib&auto_submit=NO&date_anterieure=YES', 'date_adhesion', 250, 300, -2, -2, 'toolbar=no, dependent=yes, resizable=yes')\" ";
$adhesion = "\n\t\t\t\t<input type='hidden' name='form_adhesion' value='" . preg_replace('/-/', '', $date_adhesion) . "' />\n\t\t\t\t<input class='bouton' type='button' name='form_adhesion_lib' value='" . formatdate($date_adhesion) . "' " . $date_clic . " />";
$empr_form = str_replace("!!adhesion!!", $adhesion, $empr_form);
$date_clic = "onClick=\"openPopUp('./select.php?what=calendrier&caller=empr_form&date_caller=" . preg_replace('/-/', '', $empr->empr_date_expiration) . "¶m1=form_expiration¶m2=form_expiration_lib&auto_submit=NO&date_anterieure=YES', 'date_adhesion', 205, 300, -2, -2, 'toolbar=no, dependent=yes, resizable=yes')\" ";
$expiration = "\n\t\t\t\t<input type='hidden' id='form_expiration' name='form_expiration' value='" . preg_replace('/-/', '', $empr->empr_date_expiration) . "' />\n\t\t\t\t<input class='bouton' type='button' id='form_expiration_lib' name='form_expiration_lib' value='" . formatdate($empr->empr_date_expiration) . "' " . $date_clic . " />";
$empr_form = str_replace("!!expiration!!", $expiration, $empr_form);
// ajout ici des trucs sur la relance adhésion
$empr_temp = new emprunteur($id, '', FALSE, 0);
$aff_relance = "";
if ($empr_temp->adhesion_renouv_proche() || $empr_temp->adhesion_depassee()) {
if ($empr_temp->adhesion_depassee()) {
$mess_relance = $msg[empr_date_depassee];
} else {
$mess_relance = $msg[empr_date_renouv_proche];
}
$rqt = "select duree_adhesion from empr_categ where id_categ_empr='{$empr_temp->categ}'";
$res_dur_adhesion = mysql_query($rqt, $dbh);
$row = mysql_fetch_row($res_dur_adhesion);
$nb_jour_adhesion_categ = $row[0];
if ($empr_prolong_calc_date_adhes_depassee && $empr_temp->adhesion_depassee()) {
$rqt_date = "select date_add(curdate(),INTERVAL 1 DAY) as nouv_date_debut,\n\t\t\t\t\t\tdate_add(curdate(),INTERVAL {$nb_jour_adhesion_categ} DAY) as nouv_date_fin ";
} else {
$rqt_date = "select date_add('{$empr_temp->date_expiration}',INTERVAL 1 DAY) as nouv_date_debut,\n\t\t\t\t\t\tdate_add('{$empr_temp->date_expiration}',INTERVAL {$nb_jour_adhesion_categ} DAY) as nouv_date_fin ";
}
$resultatdate = mysql_query($rqt_date) or die("<br /> {$rqt_date} " . mysql_error());
$resdate = mysql_fetch_object($resultatdate);
$nouv_date_debut = $resdate->nouv_date_debut;
$nouv_date_fin = $resdate->nouv_date_fin;
$nouv_date_debut_formatee = formatdate($nouv_date_debut);
$nouv_date_fin_formatee = formatdate($nouv_date_fin);
// on conserve la date d'adhésion initiale
$action_prolonger = "this.form.form_expiration.value = '{$nouv_date_fin}';\n\t\t\t\tthis.form.form_expiration_lib.value = '{$nouv_date_fin_formatee}';\n\t\t\t\t";
$action_relance_courrier = "openPopUp('./pdf.php?pdfdoc=lettre_relance_adhesion&id_empr={$id}', 'lettre', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes'); return(false) ";
$aff_relance = "<div class='row'>\n\t\t\t\t\t\t<span class='erreur'>{$mess_relance}</span><br />\n\t\t\t\t\t\t<input class='bouton' type='button' value=\"" . $msg[prolonger] . "\" onClick=\"{$action_prolonger}\" /> \n\t\t\t\t\t\t<input class='bouton' type='button' value=\"" . $msg[prolong_courrier] . "\" onClick=\"{$action_relance_courrier}\" />";
if ($empr_temp->mail && $biblio_email) {
$action_relance_mail = "if (confirm('" . $msg["mail_retard_confirm"] . "')) {openPopUp('./mail.php?type_mail=mail_relance_adhesion&id_empr={$id}', 'mail', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes, scrollbars=yes'); } return(false) ";
$aff_relance .= " <input class='bouton' type='button' value=\"" . $msg['prolong_mail'] . "\" onClick=\"{$action_relance_mail}\" />";
}
$aff_relance .= "</div>";
if ($pmb_gestion_financiere && $pmb_gestion_abonnement) {
$aff_relance .= "<div class='row'><input type='radio' name='debit' value='0' id='debit_0' " . (!$empr_abonnement_default_debit ? "checked" : "") . " /><label for='debit_0'>" . $msg["finance_abt_no_debit"] . "</label> <input type='radio' name='debit' value='1' id='debit_1' " . ($empr_abonnement_default_debit == 1 ? "checked" : "") . " />";
$aff_relance .= "<label for='debit_1'>" . $msg["finance_abt_debit_wo_caution"] . "</label> ";
if ($pmb_gestion_abonnement == 2) {
$aff_relance .= "<input type='radio' name='debit' value='2' id='debit_2' " . ($empr_abonnement_default_debit == 2 ? "checked" : "") . " /><label for='debit_2'>" . $msg["finance_abt_debit_wt_caution"] . "</label>";
}
$aff_relance .= "</div>";
}
}
$empr_form = str_replace("!!adhesion_proche_depassee!!", $aff_relance, $empr_form);
//Liste des types d'abonnement
$list_type_abt = "";
if ($pmb_gestion_abonnement == 2 && $pmb_gestion_financiere) {
$requete = "select * from type_abts order by type_abt_libelle ";
$resultat_abt = mysql_query($requete);
$user_loc = $deflt2docs_location;
$t_type_abt = array();
while ($res_abt = mysql_fetch_object($resultat_abt)) {
$locs = explode(",", $res_abt->localisations);
$as = array_search($user_loc, $locs);
if ($as !== false && $as !== null || !$res_abt->localisations) {
$t_type_abt[] = $res_abt;
}
}
if (count($t_type_abt)) {
$list_type_abt = "<div class='row'>\n<label for='type_abt'>" . $msg["finance_type_abt"] . "</label></div>\n<div class='row'>\n<select name='type_abt' id='type_abt'>\n";
for ($i = 0; $i < count($t_type_abt); $i++) {
$list_type_abt .= "<option value='" . $t_type_abt[$i]->id_type_abt . "'";
if ($empr->type_abt == $t_type_abt[$i]->id_type_abt) {
$list_type_abt .= " selected";
}
$list_type_abt .= ">" . htmlentities($t_type_abt[$i]->type_abt_libelle, ENT_QUOTES, $charset) . "</option>\n";
}
$list_type_abt .= "</select></div>";
}
}
$empr_form = str_replace("!!typ_abonnement!!", $list_type_abt, $empr_form);
} else {
// création de lecteur
$empr->empr_date_adhesion = today();
$empr_form = str_replace('!!cb!!', $cb, $empr_form);
$date_clic = "onClick=\"openPopUp('./select.php?what=calendrier&caller=empr_form&date_caller=" . preg_replace('/-/', '', $empr->empr_date_adhesion) . "¶m1=form_adhesion¶m2=form_adhesion_lib&auto_submit=NO&date_anterieure=YES', 'date_adhesion', 250, 260, -2, -2, 'toolbar=no, dependent=yes, resizable=yes')\" ";
$adhesion = "{$msg['1401']}{$msg['1901']}\n\t\t\t\t<input type='hidden' name='form_adhesion' value='" . preg_replace('/-/', '', $empr->empr_date_adhesion) . "'>\n\t\t\t\t<input class='bouton' type='button' name='form_adhesion_lib' value='" . formatdate($empr->empr_date_adhesion) . "' " . $date_clic . " />";
$empr_form = str_replace("!!adhesion!!", $adhesion, $empr_form);
$empr_form = str_replace("!!adhesion_proche_depassee!!", "", $empr_form);
$empr_form = str_replace("!!expiration!!", "<input type='hidden' name='form_expiration' value=''>", $empr_form);
//Liste des types d'abonnement
$list_type_abt = "";
if ($pmb_gestion_abonnement == 2 && $pmb_gestion_financiere) {
$requete = "select * from type_abts";
$resultat_abt = mysql_query($requete);
$user_loc = $deflt2docs_location;
$t_type_abt = array();
while ($res_abt = mysql_fetch_object($resultat_abt)) {
$locs = explode(",", $res_abt->localisations);
$as = array_search($user_loc, $locs);
if ($as !== false && $as !== null || !$res_abt->localisations) {
$t_type_abt[] = $res_abt;
}
}
if (count($t_type_abt)) {
$list_type_abt = "<div class='row'>\n<label for='type_abt'>" . $msg["finance_type_abt"] . "</label></div>\n<div class='row'>\n<select name='type_abt' id='type_abt'>\n";
for ($i = 0; $i < count($t_type_abt); $i++) {
$list_type_abt .= "<option value='" . $t_type_abt[$i]->id_type_abt . "'>" . htmlentities($t_type_abt[$i]->type_abt_libelle, ENT_QUOTES, $charset) . "</option>\n";
}
$list_type_abt .= "</select></div>";
}
}
$empr_form = str_replace("!!typ_abonnement!!", $list_type_abt, $empr_form);
}
$empr_form = str_replace("!!nom!!", htmlentities($empr->empr_nom, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!prenom!!", htmlentities($empr->empr_prenom, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!adr1!!", htmlentities($empr->empr_adr1, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!adr2!!", htmlentities($empr->empr_adr2, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!cp!!", htmlentities($empr->empr_cp, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!ville!!", htmlentities($empr->empr_ville, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!pays!!", htmlentities($empr->empr_pays, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!mail!!", htmlentities($empr->empr_mail, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!tel1!!", htmlentities($empr->empr_tel1, ENT_QUOTES, $charset), $empr_form);
if (!$empr->empr_sms) {
$empr_sms_chk = '';
} else {
$empr_sms_chk = "checked='checked'";
}
$empr_form = str_replace('!!sms!!', $empr_sms_chk, $empr_form);
$empr_form = str_replace("!!tel2!!", htmlentities($empr->empr_tel2, ENT_QUOTES, $charset), $empr_form);
$empr_form = str_replace("!!prof!!", htmlentities($empr->empr_prof, ENT_QUOTES, $charset), $empr_form);
if ($empr->empr_year != 0) {
$empr_form = str_replace("!!year!!", htmlentities($empr->empr_year, ENT_QUOTES, $charset), $empr_form);
} else {
$empr_form = str_replace("!!year!!", "", $empr_form);
}
if (!$empr->empr_lang) {
$empr->empr_lang = $lang;
}
$empr_form = str_replace('!!combo_empr_lang!!', make_empr_lang_combo($empr->empr_lang), $empr_form);
if (!$duplicate_empr_from_id) {
$empr_form = str_replace('!!empr_login!!', $empr->empr_login, $empr_form);
$empr_form = str_replace("!!empr_msg!!", htmlentities($empr->empr_msg, ENT_QUOTES, $charset), $empr_form);
} else {
$empr_form = str_replace('!!empr_login!!', "", $empr_form);
$empr_form = str_replace("!!empr_msg!!", "", $empr_form);
}
// on récupère le select catégorie
$requete = "SELECT id_categ_empr, libelle, duree_adhesion FROM empr_categ ORDER BY libelle ";
$res = mysql_query($requete, $link);
$nbr_lignes = mysql_num_rows($res);
$categ_content = '';
$empr_grille_categ = "<select id='empr_grille_categ' style='display:none;'><option value='0' selected='selected' >" . $msg['all_categories_empr'] . "</value>";
for ($i = 0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
$categ_content .= "<option value='{$row['0']}'";
if ($row[0] == $empr->empr_categ) {
$categ_content .= " selected='selected'";
}
$categ_content .= ">{$row['1']}</option>";
$empr_grille_categ .= "<option value='{$row['0']}'>{$row['1']}</option>";
}
$empr_grille_categ .= '</select>';
$empr_form = str_replace("!!categ!!", $categ_content, $empr_form);
// Ajout des categories et localisations pour edition des grilles
$empr_form = str_replace("<!-- empr_grille_categ -->", $empr_grille_categ, $empr_form);
if ($pmb_lecteurs_localises) {
$empr_grille_location = docs_location::get_html_select(array(0), array('id' => 0, 'msg' => $msg['all_locations_empr']), array('id' => 'empr_grille_location', 'class' => 'saisie-20em', 'style' => 'display:none;'));
} else {
$empr_grille_location = "<input type='hidden' id='empr_grille_location' value='0' />";
}
$empr_form = str_replace("<!-- empr_grille_location -->", $empr_grille_location, $empr_form);
$requete = "SELECT id_categ_empr, libelle, duree_adhesion FROM empr_categ ORDER BY libelle ";
$res = mysql_query($requete, $link);
$grille_categ = "<option value='0' selected='selected'>" . $msg['all_categories_empr'] . "</value>";
for ($i = 0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
$categ_content .= "<option value='{$row['0']}'";
if ($row[0] == $empr->empr_categ) {
$categ_content .= " selected='selected'";
}
$categ_content .= ">{$row['1']}</option>";
$grille_categ .= "<option value='{$row['0']}'>{$row['1']}</option>";
}
$empr_form = str_replace("!!categ!!", $categ_content, $empr_form);
// on récupère le select statut
$requete = "SELECT idstatut, statut_libelle FROM empr_statut ORDER BY statut_libelle ";
//Si il n'y a pas de statut on prend celui définit pour l'utilisateur
if (!$empr->empr_statut) {
global $deflt_empr_statut;
$empr->empr_statut = $deflt_empr_statut;
}
$res = mysql_query($requete, $link);
$nbr_lignes = mysql_num_rows($res);
for ($i = 0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
$statut_content .= "<option value='{$row['0']}'";
if ($row[0] == $empr->empr_statut) {
$statut_content .= " selected='selected'";
}
$statut_content .= ">{$row['1']}</option>";
}
$empr_form = str_replace("!!statut!!", $statut_content, $empr_form);
// et le select code stat
// on récupère le select cod stat
$requete = "SELECT idcode, libelle FROM empr_codestat ORDER BY libelle ";
$res = mysql_query($requete, $link);
$nbr_lignes = mysql_num_rows($res);
for ($i = 0; $i < $nbr_lignes; $i++) {
$row = mysql_fetch_row($res);
$cstat_content .= "<option value='{$row['0']}'";
if ($row[0] == $empr->empr_codestat) {
$cstat_content .= " selected='selected'";
}
$cstat_content .= ">{$row['1']}</option>";
}
// mise à jour du sexe
switch ($empr->empr_sexe) {
case 1:
$empr_form = str_replace("sexe_select_1", 'selected', $empr_form);
break;
case 2:
$empr_form = str_replace("sexe_select_2", 'selected', $empr_form);
break;
default:
$empr_form = str_replace("sexe_select_0", 'selected', $empr_form);
break;
}
$empr_form = preg_replace("/sexe_select_[0-2]/m", '', $empr_form);
$empr_form = str_replace("!!cstat!!", $cstat_content, $empr_form);
// mise à jour du groupe
if ($id) {
$requete = "SELECT id_groupe, libelle_groupe, ifnull(empr_id,0) as inscription FROM groupe left join empr_groupe on (id_groupe=groupe_id and empr_id=" . $id . ") ORDER BY libelle_groupe";
} else {
$requete = "SELECT id_groupe, libelle_groupe, 0 as inscription FROM groupe ORDER BY libelle_groupe";
}
$groupe_form_aff = gen_liste_multiple($requete, "id_groupe", "libelle_groupe", "inscription", "id_grp[]", "", $id, 0, $msg[empr_form_aucungroupe], 0, $msg[empr_form_nogroupe], 5);
$empr_form = str_replace("!!groupe_ajout!!", $groupe_form_aff, $empr_form);
$empr_form = str_replace('!!cancel!!', $form_cancel, $empr_form);
// ldap MaxMan
if ($empr->empr_ldap) {
$form_ldap = "checked";
} else {
$form_ldap = "";
}
//$empr_form = str_replace('!!empr_password!!', $empr_password, $empr_form);
$empr_form = str_replace("!!ldap!!", $form_ldap, $empr_form);
$empr_form = str_replace('!!empr_password!!', '', $empr_form);
if (!$empr->empr_location) {
$empr->empr_location = $deflt2docs_location;
}
if ($pmb_lecteurs_localises) {
$loc = "\n\t\t<div class='row' id='g2_r1' etirable='yes' recept='yes' recepttype='circrow' highlight='circrow_highlight' downlight='circrow_downlight' >\n\t\t\t<div class='colonne4' id='g2_r1_f0' movable='yes' draggable='yes' dragtype='circcell' recept='yes' recepttype='circcell' highlight='circcell_highlight' downlight='circcell_downlight' title='" . htmlentities($msg['empr_location'], ENT_QUOTES, $charset) . "'>\n\t\t\t\t<div class='row'>\n\t\t\t\t\t<label for='form_empr_location' class='etiquette'>" . $msg['empr_location'] . "</label>\n\t\t\t\t\t</div>\n\t\t\t\t<div class='row'>\n\t\t\t\t\t!!localisation!!\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t<div class='row'></div>\n\t\t</div>";
//$loc = str_replace('!!localisation!!', docs_location::gen_combo_box_empr($empr->empr_location, 0), $loc);
$loc = str_replace('!!localisation!!', docs_location::get_html_select(array($empr->empr_location), array(), array('id' => 'empr_location_id', 'name' => 'empr_location_id')), $loc);
} else {
$loc = "<input type='hidden' name='empr_location_id' id='empr_location_id' value='" . $empr->empr_location . "'>";
$empr_form = str_replace('<!-- !!localisation!! -->', $loc, $empr_form);
}
$empr_form = str_replace('<!-- !!localisation!! -->', $loc, $empr_form);
if ($pmb_opac_view_activate) {
$opac_view_tpl = "\n\t\t\t<div class='row' id='g4_r1_f0' movable='yes' draggable='yes' dragtype='circcell' recept='yes' recepttype='circcell' highlight='circcell_highlight' downlight='circcell_downlight' title='" . htmlentities($msg['empr_form_opac_view'], ENT_QUOTES, $charset) . "'>\t\t\t\t\n\t\t\t\t\t!!opac_view!!\n\t\t\t</div>";
$opac_view = new opac_view(0, $id);
$opac_view_tpl = str_replace("!!opac_view!!", gen_plus("opac_view", $msg["empr_form_opac_view"], $opac_view->do_sel_list(), 0), $opac_view_tpl);
}
$empr_form = str_replace('<!-- !!opac_view!! -->', $opac_view_tpl, $empr_form);
//Champs persos
$p_perso = new parametres_perso("empr");
$perso_ = $p_perso->show_editable_fields($id);
if (count($perso_["FIELDS"])) {
$perso = "<div class='row'></div>";
} else {
$perso = "";
}
$class = "colonne2";
for ($i = 0; $i < count($perso_["FIELDS"]); $i++) {
$p = $perso_["FIELDS"][$i];
$perso .= "<div class='{$class}' id='g6_r0_f" . $i . "' movable='yes' draggable='yes' dragtype='circcell' recept='yes' recepttype='circcell' highlight='circcell_highlight' downlight='circcell_downlight' title='" . htmlentities($p['TITRE'], ENT_QUOTES, $charset) . "' >";
$perso .= "<div class='row'><label for='" . $p["NAME"] . "' class='etiquette'>" . $p["TITRE"] . "</label></div>\n";
$perso .= "<div class='row'>";
$perso .= $p["AFF"] . "</div>";
$perso .= "</div>";
if ($class == "colonne2") {
$class = "colonne_suite";
} else {
$class = "colonne2";
}
}
if ($class == "colonne_suite") {
$perso .= "<div class='{$class}'> </div>";
}
$perso .= $perso_["CHECK_SCRIPTS"];
$empr_form = str_replace("!!champs_perso!!", $perso, $empr_form);
$empr_form = str_replace('!!empr_notice_override!!', get_rights_form($id), $empr_form);
print pmb_bidi($empr_form);
}
