![basket](./images/basket_empr.gif "\\"${msg[400]}\\"")
img_ajout_empr_caddie .= "onClick=\"openPopUp('./cart.php?object_type=EMPR&item=".$this->id."', 'cart', 600, 700, -2, -2, '$selector_prop_ajout_caddie_empr');\" ";
$this->img_ajout_empr_caddie .= "onMouseOver=\"show_div_access_carts(event,".$this->id.",'EMPR');\" onMouseOut=\"set_flag_info_div(false);\">";
} else
$this->img_ajout_empr_caddie="";
$this->lien_nom_prenom="";
if ($pmb_gestion_abonnement) {
$cpt_id=comptes::get_compte_id_from_empr($this->id,1);
$cpt=new comptes($cpt_id);
$solde=$cpt->update_solde();
$novalid=$cpt->summarize_transactions("","",0,0);
if ($cpt_id) {
$compte.="";
}
$n_c++;
}
if ($pmb_gestion_tarif_prets) {
$cpt_id=comptes::get_compte_id_from_empr($this->id,3);
$cpt=new comptes($cpt_id);
$solde=$cpt->update_solde();
$novalid=$cpt->summarize_transactions("","",0,0);
if ($cpt_id) {
$compte.="";
}
$n_c++;
}
if ($pmb_gestion_amende) {
$cpt_id=comptes::get_compte_id_from_empr($this->id,2);
$cpt=new comptes($cpt_id);
$solde=$cpt->update_solde();
$novalid=$cpt->summarize_transactions("","",0,0);
if ($cpt_id) {
//Calcul des amendes
$amende=new amende($this->id,true);
$total_amende=$amende->get_total_amendes();
$this->nb_amendes=$amende->nb_amendes;
$compte.="";
}
$n_c++;
}
// Autre compte, que s'il y a des types de transaction
$transactype=new transactype_list();
if ($transactype->get_count()) {
$cpt_id=comptes::get_compte_id_from_empr($this->id,4);
$cpt=new comptes($cpt_id);
$solde=$cpt->update_solde();
$novalid=$cpt->summarize_transactions("","",0,0);
$compte.="
";
}
$compte.="";
}
$this->compte=$compte;
if($pmb_gestion_amende && $pmb_gestion_financiere)$this->relance.= $this->do_tablo_relance();
// ces propriétés sont absentes de la table emprunteurs pour le moment
// $this->adate = $empr->empr_??? ; // date d'abonnement
// $this->rdate = $empr->empr_??? ; // date de réabonnement
if($this->message) {
$this->message = $empr->message.'
'.$this->message; } else { $this->message = $empr->message; } $order = " order by p.pret_retour, p.pret_date, e.expl_cb"; $requete_nb_pret = "select count(1) as nb_pret from pret where pret_idempr=".$this->id; $result_nb_pret = pmb_mysql_query($requete_nb_pret, $dbh); $r_nb_pret = pmb_mysql_fetch_object($result_nb_pret); $this->nb_pret = $r_nb_pret->nb_pret ; // récupération du tableau des exemplaires empruntés // il nous faut : code barre exemplaire, titre/auteur, type doc, date de pret, date de retour $requete = "select e.expl_cb, e.expl_id, e.expl_notice, docs_location.location_libelle, docs_location.idlocation, docs_section.section_libelle, e.expl_bulletin,"; $requete.= " p.pret_date, p.pret_retour, p.short_loan_flag, t.tdoc_libelle,"; $requete.= " date_format(pret_date, '".$msg["format_date"]."') as aff_pret_date, date_format(pret_retour, '".$msg["format_date"]."') as aff_pret_retour,"; $requete.= " if (pret_retour< CURDATE(),1 ,0 ) as retard , date_format(retour_initial, '".$msg["format_date"]."') as aff_retour_initial, cpt_prolongation, e.expl_cote"; $requete.= " from pret p, exemplaires e, docs_type t, docs_location, docs_section "; $requete.= " where p.pret_idempr=".$this->id; $requete.= " and p.pret_idexpl=e.expl_id"; $requete.= " and e.expl_section=docs_section.idsection"; $requete.= " and e.expl_location=docs_location.idlocation"; $requete.= " and t.idtyp_doc=e.expl_typdoc"; $requete.= " ".$order; $result = pmb_mysql_query($requete, $dbh); $this->retard=0; // Gestion de limitation de la visualisation de la liste de pret. global $pmb_pret_aff_limitation; global $pmb_pret_aff_nombre; global $see_all_pret; $with_print_info=true; $nb_ligne_traite=0; while($pret = pmb_mysql_fetch_object($result)) { // Gestion de limitation de la visualisation de la liste de pret. if( $pmb_pret_aff_limitation==1 && $pmb_pret_aff_nombre && !$see_all_pret && ($nb_ligne_traite >= $pmb_pret_aff_nombre)) { $with_print_info=false; } $nb_ligne_traite++; if($pmb_sur_location_activate) { $sur_loc= sur_location::get_info_surloc_from_location($pret->idlocation); } if ($pret->expl_notice) { if($with_print_info){ $notice = new mono_display($pret->expl_notice, 0); }else{ $notice = new stdClass(); $notice->header=""; $notice->header_texte=""; } $this->prets[] = array( 'cb' => $pret->expl_cb, 'id' => $pret->expl_id, 'libelle' => $notice->header, 'title' => $notice->header_texte, 'typdoc' => $pret->tdoc_libelle, 'section' => $pret->section_libelle, 'location' => $pret->location_libelle, 'idlocation' => $pret->idlocation, 'date_pret' => $pret->aff_pret_date, 'date_retour' => $pret->aff_pret_retour, 'short_loan_flag' => $pret->short_loan_flag, 'sql_date_retour' => $pret->pret_retour, 'org_ret_date' => str_replace('-', '', $pret->pret_retour), 'pret_retard' => $pret->retard, 'retour_initial' => $pret->aff_retour_initial, 'cpt_prolongation' => $pret->cpt_prolongation, 'sur_location' => $sur_loc->libelle, 'cote' => $pret->expl_cote, 'notice_id' => $pret->expl_notice, 'bulletin_id' => 0 ); }elseif ($pret->expl_bulletin) { if($with_print_info){ $bulletin = new bulletinage_display($pret->expl_bulletin); }else{ $bulletin = new stdClass(); $notice->display=""; } $this->prets[] = array( 'cb' => $pret->expl_cb, 'id' => $pret->expl_id, 'libelle' => $bulletin->display, 'title' => $bulletin->display, 'typdoc' => $pret->tdoc_libelle, 'section' => $pret->section_libelle, 'location' => $pret->location_libelle, 'idlocation' => $pret->idlocation, 'date_pret' => $pret->aff_pret_date, 'date_retour' => $pret->aff_pret_retour, 'short_loan_flag' => $pret->short_loan_flag, 'sql_date_retour' => $pret->pret_retour, 'org_ret_date' => str_replace('-', '', $pret->pret_retour), 'pret_retard' => $pret->retard, 'retour_initial' => $pret->aff_retour_initial, 'cpt_prolongation' => $pret->cpt_prolongation, 'sur_location' => $sur_loc->libelle, 'cote' => $pret->expl_cote, 'notice_id' => 0, 'bulletin_id' => $pret->expl_bulletin ); } $this->retard = $this->retard+$pret->retard; } $requete_resa = "select count(1) as nb_reservations "; $requete_resa .= " from resa "; $requete_resa .= " where resa_idempr=".$this->id; $result_resa = pmb_mysql_query($requete_resa, $dbh); $resa = pmb_mysql_fetch_object($result_resa); $this->nb_reservations = $resa->nb_reservations ; if ($pmb_resa_planning) { $requete_resa_planning = "select count(1) as nb_previsions "; $requete_resa_planning .= " from resa_planning "; $requete_resa_planning .= " where resa_idempr=".$this->id; $result_resa_planning = pmb_mysql_query($requete_resa_planning, $dbh); $resa_planning = pmb_mysql_fetch_object($result_resa_planning); $this->nb_previsions = $resa_planning->nb_previsions ; } return TRUE; } // fabrication de la fiche lecteur function do_fiche() { global $empr_tmpl, $empr_pret_allowed; global $msg,$charset; global $groupID; global $biblio_email; global $pmb_lecteurs_localises ; global $pmb_gestion_abonnement,$pmb_gestion_financiere, $pmb_gestion_tarif_prets, $pmb_gestion_amende; global $finance_blocage_abt,$finance_blocage_amende,$finance_blocage_pret,$pmb_blocage_retard,$pmb_blocage_retard_force; global $force_finance; global $pmb_resa_planning; global $dbh; global $pmb_blocage_retard,$pmb_blocage_coef,$pmb_blocage_max,$pmb_blocage_delai; global $empr_fiche_depliee; global $pmb_opac_view_activate; global $pmb_sur_location_activate; global $alert_sound_list; // l'utilisateur veut-il les sons d'alerte global $pmb_short_loan_management; global $pmb_location_reservation,$deflt2docs_location; global $id_expl; $this->fiche = $empr_tmpl; $this->fiche = str_replace('!!cb!!' , $this->cb , $this->fiche); $this->fiche = str_replace('!!nom!!' , pmb_strtoupper($this->nom) , $this->fiche); $this->fiche = str_replace('!!prenom!!' , $this->prenom , $this->fiche); $this->fiche = str_replace('!!image_caddie_empr!!', $this->img_ajout_empr_caddie, $this->fiche); $this->fiche = str_replace('!!info_nb_pret!!' , $this->nb_pret , $this->fiche); $this->fiche = str_replace('!!info_nb_resa!!' , $this->nb_reservations , $this->fiche); if ($pmb_resa_planning) $this->fiche = str_replace('!!info_resa_planning!!' , $msg[empr_nb_resa_planning].":".$this->nb_previsions , $this->fiche); else $this->fiche = str_replace('!!info_resa_planning!!' , "", $this->fiche); $this->fiche = str_replace('!!info_authldap!!' , $this->ldap, $this->fiche); $this->fiche = str_replace('!!id!!' , $this->id , $this->fiche); $this->fiche = str_replace('!!adr1!!' , $this->adr1 , $this->fiche); $this->fiche = str_replace('!!adr2!!' , $this->adr2 , $this->fiche); $tel = $this->tel1; if ($this->tel2) { if (trim($tel)) { $tel.=" / "; } $tel .= $this->tel2; } $this->fiche = str_replace('!!tel!!' , ''.$tel.'', $this->fiche); $this->fiche = str_replace('!!sms!!' , $this->sms , $this->fiche); $this->fiche = str_replace('!!cp!!' , $this->cp , $this->fiche); $this->fiche = str_replace('!!ville!!' , $this->ville , $this->fiche); $this->fiche = str_replace('!!pays!!' , $this->pays , $this->fiche); $emails=array(); $email_final=array(); $emails = explode(';',$this->mail); for ($i=0;$i".$emails[$i]."";
$this->fiche = str_replace('!!mail_all!!' , implode(" ",$email_final) , $this->fiche);
$this->fiche = str_replace('!!prof!!' , $this->prof , $this->fiche);
$this->fiche = str_replace('!!date!!' , $this->birth , $this->fiche);
$this->fiche = str_replace('!!categ!!' , $this->cat_l , $this->fiche);
$this->fiche = str_replace('!!codestat!!' , $this->cstat_l, $this->fiche);
$this->fiche = str_replace('!!adhesion!!' , $this->aff_date_adhesion, $this->fiche);
$this->fiche = str_replace('!!expiration!!' , $this->aff_date_expiration, $this->fiche);
$this->fiche = str_replace('!!last_loan_date!!' , $this->aff_last_loan_date, $this->fiche);
$this->fiche = str_replace('!!perso!!' , $this->perso, $this->fiche);
$this->fiche = str_replace('!!header_format!!' , $this->header_format, $this->fiche);
$this->fiche = str_replace('!!empr_login!!' , $this->login, $this->fiche);
if ($this->pwd != password::gen_hash("",$this->id))
$this->fiche = str_replace('!!empr_pwd!!',"".$msg["empr_pwd_opac_affected"]."",$this->fiche);
else
$this->fiche = str_replace('!!empr_pwd!!',"",$this->fiche);
$this->fiche = str_replace('!!comptes!!' , $this->compte, $this->fiche);
$this->fiche = str_replace('!!empr_statut_libelle!!', $this->empr_statut_libelle, $this->fiche);
$this->fiche = str_replace('!!empr_picture!!', $this->picture_empr($this->cb), $this->fiche);
if ($empr_fiche_depliee=="1")
$this->fiche = str_replace('!!depliee!!'," startOpen=\"Yes\"", $this->fiche);
else
$this->fiche = str_replace('!!depliee!!',"", $this->fiche);
if ($pmb_lecteurs_localises) {
$this->fiche = str_replace("", "
"; $this->blocage_abt=$finance_blocage_abt; } if ($solde_neg*1<0) $this->compte_abt=abs($solde_neg); } } if ($pmb_gestion_tarif_prets) { //Vérification du compte $cpte_pret_id=comptes::get_compte_id_from_empr($this->id,3); if ($cpte_pret_id) { $cpte_pret=new comptes($cpte_pret_id); $solde_neg=$cpte_pret->get_solde(); if (($finance_blocage_pret)&&($solde_neg*1<0)) { if ($pret_ok<2) $pret_ok=$finance_blocage_pret; $message_pret.=sprintf($msg["finance_pret_solde_pret"],comptes::format($solde_neg))."
"; $this->blocage_tarifs=$finance_blocage_pret; } if ($solde_neg*1<0) $this->compte_tarifs=abs($solde_neg); } } if ($pmb_gestion_amende) { //Vérification du compte $cpte_amende_id=comptes::get_compte_id_from_empr($this->id,2); if ($cpte_amende_id) { $cpte_amende=new comptes($cpte_amende_id); $solde_neg=$cpte_amende->get_solde(); $amende=new amende($this->id,true); $amende_neg=$amende->get_total_amendes(); if (($finance_blocage_amende)&&(($solde_neg*1<0)||($amende_neg*1))) { $this->blocage_amendes=$finance_blocage_amende; if ($pret_ok<2) $pret_ok=$finance_blocage_amende; if ($solde_neg*1<0) $message_pret.=sprintf($msg["finance_pret_solde_amende"],comptes::format($solde_neg))."
"; if ($amende_neg*1) $message_pret.=sprintf($msg["finance_pret_amende_en_cours_blocage"],comptes::format($amende_neg))."
"; } if ($solde_neg*1<0) $this->compte_amendes=abs($solde_neg); if ($amende_neg*1) $this->amendes_en_cours=abs($amende_neg); } } } if (($pmb_blocage_retard)&&($force_finance==0)) { if (($this->date_blocage)&&($this->blocage_active)) { $this->blocage_retard=$pmb_blocage_retard_force; //pas de forçage possible if ($pmb_blocage_retard_force == 2) { $message_pret.=sprintf($msg["blocage_retard_pret"],formatdate($this->date_blocage))."
"; } else { $message_pret.=sprintf($msg["blocage_retard_pret"],formatdate($this->date_blocage))." id."','blocage_params',400,200,-2,-2,'toolbar=no, dependent=yes,resizable=yes');\"/>
"; } if ($pret_ok<2) $pret_ok=$pmb_blocage_retard_force; } } // Ajout de l'impossibilité d'effectuer un prêt si un document n'est pas rendu // alors qu'il a dépassé le délai de blocage (NG72) . if (($pmb_blocage_retard)&&($force_finance==0)) { // Recherche la date de retour du document la plus petite, soit le plus gros retard potentiel $requete = "select MIN(pret_retour)as pret_retour"; $requete .= " from pret p"; $requete .= " where p.pret_idempr=".$this->id; $result = pmb_mysql_query($requete, $dbh); while($bloca = pmb_mysql_fetch_object($result)) { if ($bloca->pret_retour){ $pret_retour=$bloca->pret_retour; $date_debut=explode("-",$pret_retour); $ndays=calendar::get_open_days($date_debut[2],$date_debut[1],$date_debut[0],date("d"),date("m"),date("Y")); if ($ndays>$pmb_blocage_delai) { $ndays=$ndays*$pmb_blocage_coef; if (($ndays>$pmb_blocage_max)&&($pmb_blocage_max!=0)) { $ndays=$pmb_blocage_max; } } else $ndays=0; if ($ndays) { // Interdire alors de nouveau pret if ($pret_ok<2) $pret_ok=$pmb_blocage_retard_force; $this->blocage_retard=$pmb_blocage_retard_force; } } } } $p_perso=new pret_parametres_perso("pret"); $pret_arc_id = 0; if ($id_expl) { $query_custom = "select pret_arc_id from pret where pret_idempr='".$this->id."' and pret_idexpl='".$id_expl."'"; $result_custom = pmb_mysql_query($query_custom); if ($result_custom && pmb_mysql_num_rows($result_custom)) { $pret_arc_id = pmb_mysql_result($result_custom,0,0); } } $perso_=$p_perso->show_editable_fields($pret_arc_id); $pretperso_field_tpl="
"; $alert_sound_list[]="information"; $this->fiche = str_replace('!!empr_msg!!' ,$message_fiche_empr , $this->fiche); } else $this->fiche = str_replace('!!empr_msg!!', "", $this->fiche); // on distingue les messages de prêts du message sur l'emprunteur $this->fiche = str_replace('!!pret_msg!!' , $this->message , $this->fiche); if ($this->adhesion_renouv_proche()) { $message_date_depassee = $msg[empr_date_renouv_proche]; } elseif ($this->adhesion_depassee()) { $message_date_depassee = $msg[empr_date_depassee]; } else { $message_date_depassee=""; } if ($message_date_depassee) $alert_sound_list[]="critique"; $this->fiche = str_replace('!!empr_date_depassee!!', $message_date_depassee, $this->fiche); if ($this->age_categ_change()) { $message_categ_age_change = $msg[empr_categ_age_change]; } else { $message_categ_age_change=""; } if ($message_categ_age_change) $alert_sound_list[]="information"; $this->fiche = str_replace('!!empr_categ_age_change!!', $message_categ_age_change, $this->fiche); $group_zone = "$msg[64]"; if($groupID) $group_zone .= " $msg[grp_autre_lecteur]" ; $this->fiche = str_replace('!!group_zone!!', $group_zone, $this->fiche); $fsexe[0] = $msg[128]; $fsexe[1] = $msg[126]; $fsexe[2] = $msg[127]; $this->fiche = str_replace('!!sexe!!' , $fsexe[$this->sexe], $this->fiche); // valeur pour les champ hidden du prêt. L'id empr est pris en charge plus haut (voir Eric) $this->fiche = str_replace('!!cb!!' , $this->cb , $this->fiche); // traitement liste exemplaires en prêt $this->fiche = str_replace('!!nb_prets_encours!!' , $this->nb_pret , $this->fiche); //On affiche le bouton de mail si le destinataire a une adresse mail if ($this->mail) { $mail_click = "onclick=\"if (confirm('".$msg["mail_pret_confirm"]."')) { openPopUp('./pdf.php?pdfdoc=mail_liste_pret&id_empr=".$this->id."', 'print_PDF', 600, 500, -2, -2, '$PDF_win_prop');} return(false) \""; $bouton_mail_liste_pret=""; } else { $bouton_mail_liste_pret=""; } $this->fiche=str_replace("!!mail_liste_pret!!",$bouton_mail_liste_pret,$this->fiche); //Si mail de rappel affecté au responsable du groupe $requete="select id_groupe,resp_groupe from groupe,empr_groupe where id_groupe=groupe_id and empr_id=".$this->id." and resp_groupe and mail_rappel limit 1"; $res=pmb_mysql_query($requete); if(pmb_mysql_num_rows($res) > 0) { $requete="select id_empr, empr_mail from empr where id_empr='".pmb_mysql_result($res, 0,1)."'"; $result=pmb_mysql_query($requete); $has_mail = (pmb_mysql_result($result, 0,1) ? 1 : 0); } else { $has_mail = ($this->mail ? 1 : 0); } //Si retard sur un document, proposer la lettre de retard ou l'email de retard if ($this->retard>=1) { $imprime_click = "onclick=\"openPopUp('./pdf.php?pdfdoc=lettre_retard&id_empr=".$this->id."', 'lettre', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes'); return(false) \""; $bouton_lettre_retard=$msg['retard']." "; if (($has_mail)&&($biblio_email)) { $mail_click = "onclick=\"if (confirm('".$msg["mail_retard_confirm"]."')) { openPopUp('./mail.php?type_mail=mail_retard&id_empr=".$this->id."', 'mail', 600, 500, -2,- 2, 'toolbar=no, dependent=yes, resizable=yes, scrollbars=yes');} return(false) \""; $bouton_mail_retard=""; } else { $bouton_mail_retard=""; } } else { $bouton_lettre_retard=""; $bouton_mail_retard=""; } $this->fiche=str_replace("!!lettre_retard!!",$bouton_lettre_retard,$this->fiche); $this->fiche=str_replace("!!mail_retard!!",$bouton_mail_retard,$this->fiche); $voir_tout_pret=""; //separation prets classiques et prets courts $prets_list=array('0'=>'','1'=>''); if(!count($this->prets)) { // dans ce cas, le lecteur n'a rien en prêt $prets_list[0] = "$msg[650] ![".addslashes($qt_resas." ".$msg["reserv_en_cours_doc"])."](./images/alert.gif "\".addslashes($qt_resas.\" \".$msg[\"reserv_en_cours_doc\"]).\"")
";
}
}
//Affichage des prolongations
global $pmb_pret_restriction_prolongation,$pmb_pret_nombre_prolongation,$pmb_utiliser_calendrier;
$pret_nombre_prolongation=0;
$forcage_prolongation=TRUE;
$duree_prolongation=0;
// Limitation simple du pret
if($pmb_pret_restriction_prolongation==1) {
$pret_nombre_prolongation=$pmb_pret_nombre_prolongation;
} elseif($pmb_pret_restriction_prolongation==2) {
// Limitation du pret par les quotas
//Initialisation des quotas pour nombre de prolongations
$qt = new quota("PROLONG_NMBR_QUOTA");
//Tableau de passage des paramètres
$struct["READER"] = $this->id;
$struct["EXPL"] = $valeur['id'];
$pret_nombre_prolongation=$qt -> get_quota_value($struct);
$forcage_prolongation=$qt -> get_force_value($struct);
//Initialisation des quotas de durée de prolongation
$qt = new quota("PROLONG_TIME_QUOTA");
$struct["READER"] = $this->id;
$struct["EXPL"] = $valeur['id'];
$duree_prolongation=$qt -> get_quota_value($struct);
}
//$forcage_prolongation=FALSE;
/* on prépare la date de début*/
$pret_date = $valeur['sql_date_retour'];
$rqt_date = "select date_add('".$pret_date."', INTERVAL '$duree_prolongation' DAY) as date_prolongation ";
$resultatdate = pmb_mysql_query($rqt_date);
$res = pmb_mysql_fetch_object($resultatdate) ;
$date_prolongation=str_replace('-' , "" , $res->date_prolongation);
if ($pmb_utiliser_calendrier) {
$req_date_calendrier = "select date_ouverture from ouvertures where ouvert=1 and num_location='".$valeur["idlocation"]."' and DATEDIFF(date_ouverture,'$date_prolongation')>=0 order by date_ouverture asc limit 1";
$res_date_calendrier = pmb_mysql_query($req_date_calendrier);
if (pmb_mysql_num_rows($res_date_calendrier) > 0) {
$date_prolongation=str_replace('-' , "" , pmb_mysql_result($res_date_calendrier,0,0));
}
}
if ($odd_even==0) {
$pair_impair = "odd";
$odd_even=1;
} else if ($odd_even==1) {
$pair_impair = "even";
$odd_even=0;
}
$expl_sur_loc="";
if($pmb_sur_location_activate){
$expl_sur_loc= "".$valeur["sur_location"]."
";
} else {
$date_clic = " onClick=\"openPopUp('./select.php?what=calendrier";
$date_clic .= "&caller=prolong".$valeur['id'];
$date_clic .= "&date_caller=$date_prolongation";
$date_clic .= "¶m1=date_retour¶m2=date_retour_lib&auto_submit=YES',";
$date_clic .= " 'date_retour', 250, 300, -2, -2,";
$date_clic .= " 'toolbar=no, dependent=yes, resizable=yes')\"";
$prets_list[$valeur['short_loan_flag']] .= "
";
$prets_list[$valeur['short_loan_flag']] .= "";
$prets_list[$valeur['short_loan_flag']] .= " ".$msg['short_loans']."
"; $alert_sound_list[]="information"; $this->fiche_affichage = str_replace('!!empr_msg!!' ,$message_fiche_empr , $this->fiche_affichage); } else $this->fiche_affichage = str_replace('!!empr_msg!!', "", $this->fiche_affichage); // on distingue les messages de prêts du message sur l'emprunteur $this->fiche_affichage = str_replace('!!pret_msg!!' , $this->message , $this->fiche_affichage); if ($this->adhesion_renouv_proche()) { $message_date_depassee = $msg[empr_date_renouv_proche]; } elseif ($this->adhesion_depassee()) { $message_date_depassee = $msg[empr_date_depassee]; } else { $message_date_depassee=""; } if ($message_date_depassee) $alert_sound_list[]="critique"; $this->fiche_affichage = str_replace('!!empr_date_depassee!!', $message_date_depassee, $this->fiche_affichage); if ($this->age_categ_change()) { $message_categ_age_change = $msg[empr_categ_age_change]; } else { $message_categ_age_change=""; } if ($message_categ_age_change) $alert_sound_list[]="information"; $this->fiche_affichage = str_replace('!!empr_categ_age_change!!', $message_categ_age_change, $this->fiche_affichage); $fsexe[0] = $msg[128]; $fsexe[1] = $msg[126]; $fsexe[2] = $msg[127]; $this->fiche_affichage = str_replace('!!sexe!!' , $fsexe[$this->sexe], $this->fiche_affichage); // valeur pour les champ hidden du prêt. L'id empr est pris en charge plus haut $this->fiche_affichage = str_replace('!!cb!!' , $this->cb , $this->fiche_affichage); // traitement liste exemplaires en prêt $this->fiche_affichage = str_replace('!!nb_prets_encours!!' , $this->nb_pret , $this->fiche_affichage); if(!count($this->prets)) // dans ce cas, le lecteur n'a rien en prêt $prets_list = "$msg[650]
";
// ouf, c'est fini ;-)
// Gestion de limitation de la visualisation de la liste de pret.
if( $pmb_pret_aff_limitation==1 && $pmb_pret_aff_nombre && !$see_all_pret && ($cle+1 >= $pmb_pret_aff_nombre)) {
break;
}
}
// Gestion de limitation de la visualisation de la liste de pret.
if( $pmb_pret_aff_limitation==1) {
if($pmb_pret_aff_nombre) {
if (!$see_all_pret && ($this->nb_pret > $pmb_pret_aff_nombre)) {
// le bouton 'Voir tous les prets' n'a pas été posté et on arrive à la limite imposée
//Affichage du bouton 'Voir tous les prets'
$tout_voir_click = "onclick=\"document.location='circ.php?categ=pret&see_all_pret=1&form_cb=".$this->cb."'\"";
$prets_list .= "
![]()
avec l'url de la photo de l'emprunteur
function picture_empr($empr_cb) {
global $charset;
global $empr_pics_url, $empr_pics_max_size ;
if ($empr_pics_url) {
$code_chiffre = pmb_preg_replace('/ /', '', $empr_cb);
$url_image = $empr_pics_url ;
$url_image = "./getimage.php?url_image=".urlencode($url_image)."&empr_pic=1" ;
$url_image_ok = str_replace("%21%21num_carte%21%21", $code_chiffre, $url_image) ;
$image = "![](".$url_image_ok.")
";
} else
$image="" ;
return $image;
}
// fabrication de la fiche lecteur
function do_fiche_consultation() {
global $empr_tmpl_consultation, $empr_pret_allowed;
global $msg,$charset;
global $groupID;
global $biblio_email;
global $pmb_lecteurs_localises ;
global $pmb_gestion_abonnement,$pmb_gestion_financiere, $pmb_gestion_tarif_prets, $pmb_gestion_amende;
global $finance_blocage_abt,$finance_blocage_amende,$finance_blocage_pret,$pmb_blocage_retard,$pmb_blocage_retard_force;
global $force_finance;
global $pmb_resa_planning;
global $dbh;
global $pmb_blocage_retard,$pmb_blocage_coef,$pmb_blocage_max,$pmb_blocage_delai;
global $empr_fiche_depliee;
//global $cb_inpret;
global $alert_sound_list; // l'utilisateur veut-il les sons d'alerte
$this->fiche_consultation = $empr_tmpl_consultation;
$this->fiche_consultation = str_replace('!!cb!!' , $this->cb , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!nom!!' , pmb_strtoupper($this->nom) , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!prenom!!' , $this->prenom , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!image_caddie_empr!! ', $this->img_ajout_empr_caddie, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!info_nb_pret!!' , $this->nb_pret , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!info_nb_resa!!' , $this->nb_reservations , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!info_authldap!!' , $this->ldap, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!id!!' , $this->id , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!adr1!!' , $this->adr1 , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!adr2!!' , $this->adr2 , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!tel1!!' , $this->tel1 , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!sms!!' , $this->sms , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!tel2!!' , $this->tel2 , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!cp!!' , $this->cp , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!ville!!' , $this->ville , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!pays!!' , $this->pays , $this->fiche_consultation);
$emails=array();
$email_final=array();
$emails = explode(';',$this->mail);
for ($i=0;$i".$emails[$i]."";
$this->fiche_consultation = str_replace('!!mail_all!!' , implode(" ",$email_final) , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!prof!!' , $this->prof , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!date!!' , $this->birth , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!categ!!' , $this->cat_l , $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!codestat!!' , $this->cstat_l, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!adhesion!!' , $this->aff_date_adhesion, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!expiration!!' , $this->aff_date_expiration, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!last_loan_date!!' , $this->aff_last_loan_date, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!perso!!' , $this->perso, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!header_format!!' , $this->header_format, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!empr_login!!' , $this->login, $this->fiche_consultation);
if ($this->pwd != password::gen_hash("",$this->id)) {
$this->fiche_consultation = str_replace('!!empr_pwd!!',"".$msg["empr_pwd_opac_affected"]."",$this->fiche_consultation);
} else {
$this->fiche_consultation = str_replace('!!empr_pwd!!',"",$this->fiche_consultation);
}
$this->fiche_consultation = str_replace('!!comptes!!' , $this->compte, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!empr_statut_libelle!!', $this->empr_statut_libelle, $this->fiche_consultation);
$this->fiche_consultation = str_replace('!!empr_picture!!', $this->picture_empr($this->cb), $this->fiche_consultation);
if ($empr_fiche_depliee=="1") $this->fiche_consultation = str_replace('!!depliee!!'," startOpen=\"Yes\"", $this->fiche_consultation);
else $this->fiche_consultation = str_replace('!!depliee!!',"", $this->fiche_consultation);
if ($pmb_lecteurs_localises) $this->fiche_consultation = str_replace("", "
"; $this->fiche_consultation = str_replace('!!empr_msg!!' ,$message_fiche_empr , $this->fiche_consultation); } else $this->fiche_consultation = str_replace('!!empr_msg!!', "", $this->fiche_consultation); $fsexe[0] = $msg[128]; $fsexe[1] = $msg[126]; $fsexe[2] = $msg[127]; $this->fiche_consultation = str_replace('!!sexe!!' , $fsexe[$this->sexe], $this->fiche_consultation); } function import($data){ //champs de data : nom, prenom, cb, adr1, adr2,cp, ville, pays, mail, tel1, sms, tel2, year, sexe, login, password, date_adhesion, date_fin_blocage, date_expiration, date_creation //date_modif, prof, total_loans,last_loan_date, lang, msg, type_abt, //Pour la localisation : location, location_libelle, location_libelle_create, locdoc_owner //Pour la categorie : categ, categ_libelle, categ_libelle_create; //Pour le codestat: codestat, codestat_libelle, codestat_libelle_create; //Pour le statut: statut, statut_libelle, statut_libelle_create; global $dbh, $lang; // check sur le type de la variable passée en paramètre if(!sizeof($data) || !is_array($data)) { // si ce n'est pas un tableau ou un tableau vide, on retourne 0 return 0; } //Check si le lecteur a au moin un nom ou un prenom if(!$data['nom']) return 0; //Check si le code barre n'est pas déja utilisé $this->cb=addslashes($data['cb']); $query = "SELECT id_empr FROM empr WHERE empr_cb='".$this->cb."' LIMIT 1 "; $result = @pmb_mysql_query($query, $dbh); if(!$result) die("can't SELECT in database"); //On prepare les paramètres $this->empr_location=0; if(!$data['location'] and !$data['location_libelle'] and $data['location_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $data2=array(); $data2['location_libelle'] = $data['location_libelle_create']; $data2['locdoc_codage_import'] = $data['location_libelle_create']; $data2['locdoc_owner'] = $data['locdoc_owner']; $this->empr_location = docs_location::import($data2); }elseif($data['location_libelle'] != ''){ $q="select idlocation from docs_location where location_libelle='".addslashes($data['location_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_location =pmb_mysql_result($r,0,0); } }else{ $q="select idlocation from docs_location where idlocation='".addslashes($data['location'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_location =pmb_mysql_result($r,0,0); } } if(!$this->empr_location) return 0; $this->categ =0; if(!$data['categ'] and !$data['categ_libelle'] and $data['categ_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $q="select id_categ_empr from empr_categ where libelle='".addslashes($data['categ_libelle_create'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->categ =pmb_mysql_result($r,0,0); } else { $q= "insert into empr_categ (libelle) values ('".addslashes($data['categ_libelle_create'])."') "; $r = pmb_mysql_query($q, $dbh); $this->categ =pmb_mysql_insert_id($dbh); } }elseif($data['categ_libelle'] != ''){ $q="select id_categ_empr from empr_categ where libelle='".addslashes($data['categ_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->categ =pmb_mysql_result($r,0,0); } }else{ $q="select id_categ_empr from empr_categ where id_categ_empr='".addslashes($data['categ'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->categ =pmb_mysql_result($r,0,0); } } if(!$this->categ) return 0; $this->cstat=0; if(!$data['codestat'] and !$data['codestat_libelle'] and $data['codestat_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $q="select idcode from empr_codestat where libelle='".addslashes($data['codestat_libelle_create'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->cstat =pmb_mysql_result($r,0,0); } else { $q= "insert into empr_codestat (libelle) values ('".addslashes($data['codestat_libelle_create'])."') "; $r = pmb_mysql_query($q, $dbh); $this->cstat =pmb_mysql_insert_id($dbh); } }elseif($data['codestat_libelle'] != ''){ $q="select idcode from empr_codestat where libelle='".addslashes($data['codestat_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->cstat =pmb_mysql_result($r,0,0); } }else{ $q="select idcode from empr_codestat where idcode='".addslashes($data['codestat'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->cstat =pmb_mysql_result($r,0,0); } } if(!$this->cstat) return 0; $this->empr_statut=0; if(!$data['statut'] and !$data['statut_libelle'] and $data['statut_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $q="select idstatut from empr_statut where statut_libelle='".addslashes($data['statut_libelle_create'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_statut =pmb_mysql_result($r,0,0); } else { $q= "insert into empr_statut (statut_libelle) values ('".addslashes($data['statut_libelle_create'])."') "; $r = pmb_mysql_query($q, $dbh); $this->empr_statut =pmb_mysql_insert_id($dbh); } }elseif($data['statut_libelle'] != ''){ $q="select idstatut from empr_statut where statut_libelle='".addslashes($data['statut_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_statut =pmb_mysql_result($r,0,0); } }else{ $q="select idstatut from empr_statut where idstatut='".addslashes($data['statut'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_statut =pmb_mysql_result($r,0,0); } } if(!$this->empr_statut) return 0; $this->nom=addslashes($data['nom']); $this->prenom=addslashes($data['prenom']); $this->adr1=addslashes($data['adr1']); $this->adr2=addslashes($data['adr2']); $this->cp=addslashes($data['cp']); $this->ville=addslashes($data['ville']); $this->pays=addslashes($data['pays']); $this->mail=addslashes($data['mail']); $this->tel1=addslashes($data['tel1']); $this->sms=addslashes($data['sms']); $this->tel2=addslashes($data['tel2']); if($data['sexe'] === 0 or $data['sexe'] == 1 or $data['sexe'] == 2){ $this->sexe=$data['sexe']; }else{ $this->sexe=0; } $this->birth=addslashes($data['year']); $this->date_adhesion=addslashes($data['date_adhesion']); $this->date_blocage=addslashes($data['date_fin_blocage']); $this->date_expiration=addslashes($data['date_expiration']); if(!$data['date_creation']){ $this->cdate=today(); }else{ $this->cdate=addslashes($data['date_creation']); } if(!$data['date_modif']){ $this->mdate=today(); }else{ $this->mdate=addslashes($data['date_modif']); } $this->pwd=addslashes($data['password']); $this->prof=addslashes($data['prof']); $this->total_loans=addslashes($data['total_loans']); $this->last_loan_date=addslashes($data['last_loan_date']); if(!$data['lang']){ $this->empr_lang=$lang; }else{ $this->empr_lang=addslashes($data['lang']); } $this->empr_msg=addslashes($data['msg']); $this->type_abt=addslashes($data['type_abt']); $this->login=addslashes($data['login']); $q = "insert into empr (empr_cb, empr_nom, empr_prenom, empr_adr1, empr_cp, empr_ville, empr_pays, "; $q.= "empr_mail, empr_tel1, empr_sms, empr_categ, empr_codestat, empr_sexe, empr_login, empr_date_adhesion, "; $q.= "empr_date_expiration, empr_lang, empr_location,empr_msg,empr_year,empr_creation,empr_adr2,empr_tel2, empr_modif,empr_password,empr_prof,type_abt,empr_statut,total_loans,last_loan_date,date_fin_blocage) "; $q.= "values ('".$this->cb."', '".$this->nom."', '".$this->prenom."', '".$this->adr1."', '".$this->cp."', '".$this->ville."', '".$this->pays."', "; $q.= "'".$this->mail."', '".$this->tel1."', '".$this->sms."', '".$this->categ."', '".$this->cstat."', '".$this->sexe."', '".$this->login."', '".$this->date_adhesion."', "; $q.= "'".$this->date_expiration."', '".$this->empr_lang."', '".$this->empr_location."', '".$this->empr_msg."', '".$this->birth."', '".$this->cdate."', '".$this->adr2."', '".$this->tel2."', '".$this->mdate."', '".$this->pwd."', '".$this->prof."','".$this->type_abt."','".$this->empr_statut."','".$this->total_loans."', '".$this->last_loan_date."', '".$this->date_blocage."') "; $r=pmb_mysql_query($q, $dbh); $id_empr = pmb_mysql_insert_id($dbh); emprunteur::update_digest($this->login,$this->pwd); emprunteur::hash_password($this->login,$this->pwd); return $id_empr; } static function do_login($nom,$prenom) { global $dbh; $nom_forate=str_replace(' ','',strtolower(strip_empty_chars($nom))); $prenom_forate=str_replace(' ','',strtolower(strip_empty_chars($prenom))); $empr_login = substr($prenom_forate,0,1).$nom_forate; $pb = 1 ; $num_login=1 ; $empr_login2=$empr_login; while ($pb==1) { $q = "SELECT empr_login FROM empr WHERE empr_login='$empr_login2' LIMIT 1 "; $r = pmb_mysql_query($q, $dbh); $nb = pmb_mysql_num_rows($r); if ($nb) { $empr_login2 =$empr_login.$num_login ; $num_login++; } else $pb = 0 ; } return $empr_login2; } function do_fiche_retard(){ global $charset, $empr_retard_tpl, $dbh, $msg; global $opac_empr_hist_nb_jour_max; $empr_retard_tpl = str_replace("!!prenom!!",htmlentities($this->prenom,ENT_QUOTES,$charset),$empr_retard_tpl); $empr_retard_tpl = str_replace("!!nom!!",htmlentities($this->nom,ENT_QUOTES,$charset),$empr_retard_tpl); if ($opac_empr_hist_nb_jour_max){ $req_retards = "select id_log from log_retard where idempr='".$this->id."' and date_add(date_log, INTERVAL $opac_empr_hist_nb_jour_max day)id_log;
pmb_mysql_query($req_del);
$req_del="delete from log_retard where id_log =".$retard->id_log;
pmb_mysql_query($req_del);
}
}
$req_retards = "select * from log_retard where idempr='".$this->id."' order by date_log desc";
$res_ret = pmb_mysql_query($req_retards);
while(($retard = pmb_mysql_fetch_object($res_ret))){
$empr_retard_tpl = str_replace("!!nivo_relance!!",$retard->niveau_reel,$empr_retard_tpl);
$titre_relance= "".$msg['empr_nivo_relance']." : ".$retard->niveau_reel." ".$msg['empr_late_relance']." ".formatdate($retard->date_log)." ".($retard->log_mail ? $msg['empr_late_relance_mail'] : $msg['empr_late_relance_letter'])." (".$msg['empr_late_amende']." : ".comptes::format($retard->amende_totale)." ".$msg['empr_late_frais']." : ".comptes::format($retard->frais).")";
$liste= "
";
$result.= gen_plus("relance_".$retard->id_log,$titre_relance,$liste,1);
}
$empr_retard_tpl = str_replace("!!id!!",$this->id,$empr_retard_tpl);
$empr_retard_tpl = str_replace("!!liste_retard!!",$result,$empr_retard_tpl);
$empr_retard_tpl = str_replace("!!nivo_relance!!",0,$empr_retard_tpl);// si aucun imprimé
$this->fiche_retard = $empr_retard_tpl;
}
function do_tablo_relance(){
global $msg, $dbh;
$tableau ="";
$amende = new amende($this->id);
$level = $amende->get_max_level();
$niveau=$level["level"];
$niveau_min=$level["level_min"];
$niveau_normal=$level["level_normal"];
$printed=$level["printed"];
$date_relance=$level["level_min_date_relance"];
$list_dates[$date_relance]=format_date($date_relance);
if($niveau_min || $niveau_normal){
$requete ="select count(pret_idexpl) as empr_nb from empr, pret, exemplaires where
pret_retour < CURDATE() and pret_idempr=id_empr and pret_idexpl=expl_id and id_empr='".$this->id."'";
$res = pmb_mysql_query($requete,$dbh);
$empr =pmb_mysql_fetch_object($res);
$tableau = "";
// $tableau .= "
";
}
return $tableau;
}
//Retourne un tableau (id_empr=>empr_nom empr_prenom) à partir d'un tableau d'id
static function getName($tab=array()) {
global $dbh;
$res=array();
if(is_array($tab) && count($tab)) {
$q ="select id_empr, concat(empr_nom,' ',empr_prenom) as lib from empr where id_empr in ('".implode("','", $tab)."') ";
$r = pmb_mysql_query($q,$dbh);
while($row=pmb_mysql_fetch_object($r)) {
$res[$row->id_empr]=$row->lib;
}
}
return $res;
}
//Retourne le code-barre d'un emprunteur
static function get_cb_empr($id_empr) {
global $dbh;
if (!$id_empr) return false;
$q ="select empr_cb from empr where id_empr=$id_empr";
$r = pmb_mysql_query($q,$dbh);
return pmb_mysql_result($r,0,0);
}
static function rec_abonnement($id_empr,$type_abt,$empr_categ,$rec_caution=true) {
global $pmb_gestion_financiere,$pmb_gestion_abonnement;
if ($pmb_gestion_financiere) {
//Récupération du tarif
if ($pmb_gestion_abonnement==1) {
$requete="select tarif_abt, libelle from empr_categ where id_categ_empr=$empr_categ";
$resultat=pmb_mysql_query($requete);
} else {
if ($pmb_gestion_abonnement==2) {
$requete="select tarif, type_abt_libelle, caution from type_abts where id_type_abt=$type_abt";
$resultat=pmb_mysql_query($requete);
}
}
if (@pmb_mysql_num_rows($resultat)) {
$tarif=pmb_mysql_result($resultat,0,0);
$libelle=pmb_mysql_result($resultat,0,1);
if ($pmb_gestion_abonnement==2) $caution=pmb_mysql_result($resultat,0,2);
}
$compte_id=comptes::get_compte_id_from_empr($id_empr,1);
if ($compte_id) {
$cpte=new comptes($compte_id);
}
if ($tarif*1) {
//Enregistrement de la transaction
$cpte->record_transaction("",abs($tarif),-1,"Inscription : ".$libelle,0);
}
if (($caution*1)&&($rec_caution)) {
$cpte->record_transaction("",abs($caution),-1,"Caution : ".$libelle,0);
$requete="update empr set caution='".abs($caution)."' where id_empr=$id_empr";
pmb_mysql_query($requete);
}
}
}
static function rec_groupe_empr($id_empr, $tableau_groupe) {
global $dbh;
$requete="delete from empr_groupe where empr_id='$id_empr' ";
pmb_mysql_query($requete, $dbh);
for ($i = 0 ; $i < sizeof($tableau_groupe) ; $i++) {
$rqt = "insert into empr_groupe (empr_id, groupe_id) values ('".$id_empr."', '".$tableau_groupe[$i]."') " ;
pmb_mysql_query($rqt, $dbh);
}
}
// inscription automatique du lecteur dans la DSI de sa catégorie
static function ins_lect_categ_dsi($id_empr=0, $categorie_lecteurs=0, $anc_categorie_lecteurs=0) {
global $dbh;
global $dsi_insc_categ ;
if (!$dsi_insc_categ || !$id_empr || !$categorie_lecteurs) return ;
// suppression de l'inscription dans les bannettes de son ancienne catégorie
if ($anc_categorie_lecteurs) {
$req_ban = "select id_bannette from bannettes where categorie_lecteurs='$anc_categorie_lecteurs'" ;
$res_ban=pmb_mysql_query($req_ban, $dbh) ;
while ($ban=pmb_mysql_fetch_object($res_ban)) {
pmb_mysql_query("delete from bannette_abon where num_bannette='$ban->id_bannette' and num_empr='$id_empr' ", $dbh) ;
}
}
// inscription du lecteur dans la DSI de sa nouvelle catégorie
$req_ban = "select id_bannette from bannettes where categorie_lecteurs='$categorie_lecteurs'" ;
$res_ban=pmb_mysql_query($req_ban, $dbh) ;
while ($ban=pmb_mysql_fetch_object($res_ban)) {
pmb_mysql_query("delete from bannette_abon where num_bannette='$ban->id_bannette' and num_empr='$id_empr' ", $dbh) ;
pmb_mysql_query("insert into bannette_abon (num_bannette, num_empr) values('$ban->id_bannette', '$id_empr')", $dbh) ;
}
return ;
}
static function get_hashed_password($empr_login='',$empr_password='') {
global $dbh;
$id_empr = 0;
if ($empr_login) {
$query = "select id_empr from empr where empr_login='".$empr_login."'";
$result = pmb_mysql_query($query,$dbh);
if (pmb_mysql_num_rows($result) == 1) {
$id_empr = pmb_mysql_result($result, 0, "id_empr");
}
}
if ($id_empr) {
return password::gen_hash($empr_password, $id_empr);
} else {
return "";
}
}
static function hash_password($empr_login='',$empr_password='') {
global $dbh;
global $opac_empr_password_salt;
if (!$opac_empr_password_salt) {
$salt_base = password::gen_salt_base();
if (!$salt_base) return false;
}
$id_empr = 0;
if ($empr_login) {
$query = "select id_empr from empr where empr_login='".addslashes($empr_login)."'";
$result = pmb_mysql_query($query,$dbh);
if (pmb_mysql_num_rows($result) == 1) {
$id_empr = pmb_mysql_result($result, 0, "id_empr");
}
}
if ($id_empr) {
$rqt = "show tables like 'empr_passwords'";
if (pmb_mysql_num_rows(mysql_query($rqt,$dbh))) {
$q = "update empr_passwords set empr_password='".addslashes($empr_password)."' where id_empr='".$id_empr."'";
pmb_mysql_query($q,$dbh);
}
$q = "update empr set empr_password='".addslashes(password::gen_hash($empr_password, $id_empr))."', empr_password_is_encrypted = 1 where empr_login='".addslashes($empr_login)."'";
pmb_mysql_query($q,$dbh);
}
}
static function update_digest($empr_login='',$empr_password='') {
global $dbh, $pmb_url_base;
if (!$empr_login) return;
$q = "update empr set empr_digest='".addslashes(md5($empr_login.":".md5($pmb_url_base).":".$empr_password))."' where empr_login='".addslashes($empr_login)."'";
pmb_mysql_query($q,$dbh);
}
} # fin de déclaration classe emprunteur
".$msg["finance_solde_abt"]." ".comptes::format($solde)."
";
if ($novalid)
$compte.="".$msg["finance_not_validated"]." : ".comptes::format($novalid)."
";
$compte.="".$msg["finance_solde_pret"]." ".comptes::format($solde)."
";
if ($novalid)
$compte.="".$msg["finance_not_validated"]." : ".comptes::format($novalid)."
";
$compte.="".$msg["finance_solde_amende"]." ".comptes::format($solde)."
";
if ($novalid)
$compte.="".$msg["finance_not_validated"]." : ".comptes::format($novalid)."
";
if ($total_amende)
$compte.=" ".$msg["finance_pret_amende_en_cours"]." : ".comptes::format($total_amende)."
";
$compte.="
".$msg["transactype_empr_compte"]." ".comptes::format($solde)."
";
if ($novalid)
$compte.="".$msg["finance_not_validated"]." : ".comptes::format($novalid)."
";
$n_c++;
}
if ($n_c<3) {
for ($i=$n_c; $i<4; $i++)
$compte.="'.$this->message; } else { $this->message = $empr->message; } $order = " order by p.pret_retour, p.pret_date, e.expl_cb"; $requete_nb_pret = "select count(1) as nb_pret from pret where pret_idempr=".$this->id; $result_nb_pret = pmb_mysql_query($requete_nb_pret, $dbh); $r_nb_pret = pmb_mysql_fetch_object($result_nb_pret); $this->nb_pret = $r_nb_pret->nb_pret ; // récupération du tableau des exemplaires empruntés // il nous faut : code barre exemplaire, titre/auteur, type doc, date de pret, date de retour $requete = "select e.expl_cb, e.expl_id, e.expl_notice, docs_location.location_libelle, docs_location.idlocation, docs_section.section_libelle, e.expl_bulletin,"; $requete.= " p.pret_date, p.pret_retour, p.short_loan_flag, t.tdoc_libelle,"; $requete.= " date_format(pret_date, '".$msg["format_date"]."') as aff_pret_date, date_format(pret_retour, '".$msg["format_date"]."') as aff_pret_retour,"; $requete.= " if (pret_retour< CURDATE(),1 ,0 ) as retard , date_format(retour_initial, '".$msg["format_date"]."') as aff_retour_initial, cpt_prolongation, e.expl_cote"; $requete.= " from pret p, exemplaires e, docs_type t, docs_location, docs_section "; $requete.= " where p.pret_idempr=".$this->id; $requete.= " and p.pret_idexpl=e.expl_id"; $requete.= " and e.expl_section=docs_section.idsection"; $requete.= " and e.expl_location=docs_location.idlocation"; $requete.= " and t.idtyp_doc=e.expl_typdoc"; $requete.= " ".$order; $result = pmb_mysql_query($requete, $dbh); $this->retard=0; // Gestion de limitation de la visualisation de la liste de pret. global $pmb_pret_aff_limitation; global $pmb_pret_aff_nombre; global $see_all_pret; $with_print_info=true; $nb_ligne_traite=0; while($pret = pmb_mysql_fetch_object($result)) { // Gestion de limitation de la visualisation de la liste de pret. if( $pmb_pret_aff_limitation==1 && $pmb_pret_aff_nombre && !$see_all_pret && ($nb_ligne_traite >= $pmb_pret_aff_nombre)) { $with_print_info=false; } $nb_ligne_traite++; if($pmb_sur_location_activate) { $sur_loc= sur_location::get_info_surloc_from_location($pret->idlocation); } if ($pret->expl_notice) { if($with_print_info){ $notice = new mono_display($pret->expl_notice, 0); }else{ $notice = new stdClass(); $notice->header=""; $notice->header_texte=""; } $this->prets[] = array( 'cb' => $pret->expl_cb, 'id' => $pret->expl_id, 'libelle' => $notice->header, 'title' => $notice->header_texte, 'typdoc' => $pret->tdoc_libelle, 'section' => $pret->section_libelle, 'location' => $pret->location_libelle, 'idlocation' => $pret->idlocation, 'date_pret' => $pret->aff_pret_date, 'date_retour' => $pret->aff_pret_retour, 'short_loan_flag' => $pret->short_loan_flag, 'sql_date_retour' => $pret->pret_retour, 'org_ret_date' => str_replace('-', '', $pret->pret_retour), 'pret_retard' => $pret->retard, 'retour_initial' => $pret->aff_retour_initial, 'cpt_prolongation' => $pret->cpt_prolongation, 'sur_location' => $sur_loc->libelle, 'cote' => $pret->expl_cote, 'notice_id' => $pret->expl_notice, 'bulletin_id' => 0 ); }elseif ($pret->expl_bulletin) { if($with_print_info){ $bulletin = new bulletinage_display($pret->expl_bulletin); }else{ $bulletin = new stdClass(); $notice->display=""; } $this->prets[] = array( 'cb' => $pret->expl_cb, 'id' => $pret->expl_id, 'libelle' => $bulletin->display, 'title' => $bulletin->display, 'typdoc' => $pret->tdoc_libelle, 'section' => $pret->section_libelle, 'location' => $pret->location_libelle, 'idlocation' => $pret->idlocation, 'date_pret' => $pret->aff_pret_date, 'date_retour' => $pret->aff_pret_retour, 'short_loan_flag' => $pret->short_loan_flag, 'sql_date_retour' => $pret->pret_retour, 'org_ret_date' => str_replace('-', '', $pret->pret_retour), 'pret_retard' => $pret->retard, 'retour_initial' => $pret->aff_retour_initial, 'cpt_prolongation' => $pret->cpt_prolongation, 'sur_location' => $sur_loc->libelle, 'cote' => $pret->expl_cote, 'notice_id' => 0, 'bulletin_id' => $pret->expl_bulletin ); } $this->retard = $this->retard+$pret->retard; } $requete_resa = "select count(1) as nb_reservations "; $requete_resa .= " from resa "; $requete_resa .= " where resa_idempr=".$this->id; $result_resa = pmb_mysql_query($requete_resa, $dbh); $resa = pmb_mysql_fetch_object($result_resa); $this->nb_reservations = $resa->nb_reservations ; if ($pmb_resa_planning) { $requete_resa_planning = "select count(1) as nb_previsions "; $requete_resa_planning .= " from resa_planning "; $requete_resa_planning .= " where resa_idempr=".$this->id; $result_resa_planning = pmb_mysql_query($requete_resa_planning, $dbh); $resa_planning = pmb_mysql_fetch_object($result_resa_planning); $this->nb_previsions = $resa_planning->nb_previsions ; } return TRUE; } // fabrication de la fiche lecteur function do_fiche() { global $empr_tmpl, $empr_pret_allowed; global $msg,$charset; global $groupID; global $biblio_email; global $pmb_lecteurs_localises ; global $pmb_gestion_abonnement,$pmb_gestion_financiere, $pmb_gestion_tarif_prets, $pmb_gestion_amende; global $finance_blocage_abt,$finance_blocage_amende,$finance_blocage_pret,$pmb_blocage_retard,$pmb_blocage_retard_force; global $force_finance; global $pmb_resa_planning; global $dbh; global $pmb_blocage_retard,$pmb_blocage_coef,$pmb_blocage_max,$pmb_blocage_delai; global $empr_fiche_depliee; global $pmb_opac_view_activate; global $pmb_sur_location_activate; global $alert_sound_list; // l'utilisateur veut-il les sons d'alerte global $pmb_short_loan_management; global $pmb_location_reservation,$deflt2docs_location; global $id_expl; $this->fiche = $empr_tmpl; $this->fiche = str_replace('!!cb!!' , $this->cb , $this->fiche); $this->fiche = str_replace('!!nom!!' , pmb_strtoupper($this->nom) , $this->fiche); $this->fiche = str_replace('!!prenom!!' , $this->prenom , $this->fiche); $this->fiche = str_replace('!!image_caddie_empr!!', $this->img_ajout_empr_caddie, $this->fiche); $this->fiche = str_replace('!!info_nb_pret!!' , $this->nb_pret , $this->fiche); $this->fiche = str_replace('!!info_nb_resa!!' , $this->nb_reservations , $this->fiche); if ($pmb_resa_planning) $this->fiche = str_replace('!!info_resa_planning!!' , $msg[empr_nb_resa_planning].":".$this->nb_previsions , $this->fiche); else $this->fiche = str_replace('!!info_resa_planning!!' , "", $this->fiche); $this->fiche = str_replace('!!info_authldap!!' , $this->ldap, $this->fiche); $this->fiche = str_replace('!!id!!' , $this->id , $this->fiche); $this->fiche = str_replace('!!adr1!!' , $this->adr1 , $this->fiche); $this->fiche = str_replace('!!adr2!!' , $this->adr2 , $this->fiche); $tel = $this->tel1; if ($this->tel2) { if (trim($tel)) { $tel.=" / "; } $tel .= $this->tel2; } $this->fiche = str_replace('!!tel!!' , ''.$tel.'', $this->fiche); $this->fiche = str_replace('!!sms!!' , $this->sms , $this->fiche); $this->fiche = str_replace('!!cp!!' , $this->cp , $this->fiche); $this->fiche = str_replace('!!ville!!' , $this->ville , $this->fiche); $this->fiche = str_replace('!!pays!!' , $this->pays , $this->fiche); $emails=array(); $email_final=array(); $emails = explode(';',$this->mail); for ($i=0;$i
$msg[empr_location] : ".$this->empr_location_l."
", $this->fiche);
$resume_localisation=$this->empr_location_l;
}
if ($pmb_opac_view_activate) {
}
//Groupes
if (count($this->groupes)) {
$this->fiche = str_replace('!!groupes!!',"".$msg[groupes_empr]." : ".implode(" / ",$this->groupes)."\n",$this->fiche);
$resume_groupe=implode(" / ",$this->groupes);
} else {
$this->fiche = str_replace('!!groupes!!'," ",$this->fiche);
}
// Ajout d'infos complémentaires lorsque la fiche lecteur est repliée par défaut
$empr_resume='';
if ($empr_fiche_depliee=="0") {
//localisation
if($resume_localisation) $empr_resume=$resume_localisation." - ";
//categ
if($this->cat_l) $empr_resume.=$this->cat_l." - ";
//groupe
if($resume_groupe) $empr_resume.=$resume_groupe." - ";
}
$this->fiche = str_replace('!!empr_resume!!',$empr_resume,$this->fiche);
//Pret autorisé ou non ?
$pret_ok=0;
if (($pmb_gestion_financiere)&&($force_finance==0)) {
$message_pret="";
if ($pmb_gestion_abonnement) {
//Vérification du compte
$cpte_abt_id=comptes::get_compte_id_from_empr($this->id,1);
if ($cpte_abt_id) {
$cpte_abt=new comptes($cpte_abt_id);
$solde_neg=$cpte_abt->get_solde();
if (($finance_blocage_abt)&&($solde_neg*1<0)) {
if ($pret_ok<2) $pret_ok=$finance_blocage_abt;
$message_pret.=sprintf($msg["finance_pret_solde_abt"],comptes::format($solde_neg)).""; $this->blocage_abt=$finance_blocage_abt; } if ($solde_neg*1<0) $this->compte_abt=abs($solde_neg); } } if ($pmb_gestion_tarif_prets) { //Vérification du compte $cpte_pret_id=comptes::get_compte_id_from_empr($this->id,3); if ($cpte_pret_id) { $cpte_pret=new comptes($cpte_pret_id); $solde_neg=$cpte_pret->get_solde(); if (($finance_blocage_pret)&&($solde_neg*1<0)) { if ($pret_ok<2) $pret_ok=$finance_blocage_pret; $message_pret.=sprintf($msg["finance_pret_solde_pret"],comptes::format($solde_neg))."
"; $this->blocage_tarifs=$finance_blocage_pret; } if ($solde_neg*1<0) $this->compte_tarifs=abs($solde_neg); } } if ($pmb_gestion_amende) { //Vérification du compte $cpte_amende_id=comptes::get_compte_id_from_empr($this->id,2); if ($cpte_amende_id) { $cpte_amende=new comptes($cpte_amende_id); $solde_neg=$cpte_amende->get_solde(); $amende=new amende($this->id,true); $amende_neg=$amende->get_total_amendes(); if (($finance_blocage_amende)&&(($solde_neg*1<0)||($amende_neg*1))) { $this->blocage_amendes=$finance_blocage_amende; if ($pret_ok<2) $pret_ok=$finance_blocage_amende; if ($solde_neg*1<0) $message_pret.=sprintf($msg["finance_pret_solde_amende"],comptes::format($solde_neg))."
"; if ($amende_neg*1) $message_pret.=sprintf($msg["finance_pret_amende_en_cours_blocage"],comptes::format($amende_neg))."
"; } if ($solde_neg*1<0) $this->compte_amendes=abs($solde_neg); if ($amende_neg*1) $this->amendes_en_cours=abs($amende_neg); } } } if (($pmb_blocage_retard)&&($force_finance==0)) { if (($this->date_blocage)&&($this->blocage_active)) { $this->blocage_retard=$pmb_blocage_retard_force; //pas de forçage possible if ($pmb_blocage_retard_force == 2) { $message_pret.=sprintf($msg["blocage_retard_pret"],formatdate($this->date_blocage))."
"; } else { $message_pret.=sprintf($msg["blocage_retard_pret"],formatdate($this->date_blocage))." id."','blocage_params',400,200,-2,-2,'toolbar=no, dependent=yes,resizable=yes');\"/>
"; } if ($pret_ok<2) $pret_ok=$pmb_blocage_retard_force; } } // Ajout de l'impossibilité d'effectuer un prêt si un document n'est pas rendu // alors qu'il a dépassé le délai de blocage (NG72) . if (($pmb_blocage_retard)&&($force_finance==0)) { // Recherche la date de retour du document la plus petite, soit le plus gros retard potentiel $requete = "select MIN(pret_retour)as pret_retour"; $requete .= " from pret p"; $requete .= " where p.pret_idempr=".$this->id; $result = pmb_mysql_query($requete, $dbh); while($bloca = pmb_mysql_fetch_object($result)) { if ($bloca->pret_retour){ $pret_retour=$bloca->pret_retour; $date_debut=explode("-",$pret_retour); $ndays=calendar::get_open_days($date_debut[2],$date_debut[1],$date_debut[0],date("d"),date("m"),date("Y")); if ($ndays>$pmb_blocage_delai) { $ndays=$ndays*$pmb_blocage_coef; if (($ndays>$pmb_blocage_max)&&($pmb_blocage_max!=0)) { $ndays=$pmb_blocage_max; } } else $ndays=0; if ($ndays) { // Interdire alors de nouveau pret if ($pret_ok<2) $pret_ok=$pmb_blocage_retard_force; $this->blocage_retard=$pmb_blocage_retard_force; } } } } $p_perso=new pret_parametres_perso("pret"); $pret_arc_id = 0; if ($id_expl) { $query_custom = "select pret_arc_id from pret where pret_idempr='".$this->id."' and pret_idexpl='".$id_expl."'"; $result_custom = pmb_mysql_query($query_custom); if ($result_custom && pmb_mysql_num_rows($result_custom)) { $pret_arc_id = pmb_mysql_result($result_custom,0,0); } } $perso_=$p_perso->show_editable_fields($pret_arc_id); $pretperso_field_tpl="
!!aff!!
";
if (count($perso_['FIELDS'])) {
$custom_fields = "";
foreach($perso_['FIELDS'] as $field){
if($field['MANDATORY']) {
$field_tpl="".$pretperso_field_tpl."
";
} else {
$field_tpl=$pretperso_field_tpl;
}
$field_tpl = str_replace("!!titre!!", $field['TITRE'], $field_tpl);
$field_tpl = str_replace("!!aff!!", $field['AFF'], $field_tpl);
$custom_fields.= $field_tpl;
}
$custom_fields.=$perso_["CHECK_SCRIPTS"];
$empr_pret_allowed = str_replace('',$custom_fields,$empr_pret_allowed);
} else {
$empr_pret_allowed = str_replace('',"\n\n",$empr_pret_allowed);
}
if (!$pret_ok && $this->allow_loan) {
$this->fiche = str_replace("!!empr_case_pret!!", $empr_pret_allowed,$this->fiche);
$this->fiche = str_replace('!!id!!' , $this->id , $this->fiche);
} else {
if ($pret_ok==1 && $this->allow_loan) {
$message_pret.="";
} elseif($this->allow_loan) {
$message_pret.="".$msg["finance_pret_bloque"]."
";
} else $message_pret.="".$msg["empr_no_allow_loan"]."
";
$this->fiche = str_replace("!!empr_case_pret!!", $message_pret,$this->fiche);
}
$abonnement="";
if (($pmb_gestion_financiere)&&($pmb_gestion_abonnement==2)) {
if ($this->type_abt) {
$requete="select type_abt_libelle from type_abts where id_type_abt='".$this->type_abt."'";
$resultat_type_abt=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($resultat_type_abt)) {
$abonnement=pmb_mysql_result($resultat_type_abt,0,0);
}
}
}
if ($abonnement) {
$this->fiche = str_replace("!!abonnement!!", "".$msg["finance_type_abt"]." : ".htmlentities($abonnement,ENT_QUOTES,$charset)."
\n",$this->fiche);
} else {
$this->fiche = str_replace("!!abonnement!!","",$this->fiche);
}
// message
if ($this->empr_msg) {
$message_fiche_empr= "
$this->empr_msg
"; $alert_sound_list[]="information"; $this->fiche = str_replace('!!empr_msg!!' ,$message_fiche_empr , $this->fiche); } else $this->fiche = str_replace('!!empr_msg!!', "", $this->fiche); // on distingue les messages de prêts du message sur l'emprunteur $this->fiche = str_replace('!!pret_msg!!' , $this->message , $this->fiche); if ($this->adhesion_renouv_proche()) { $message_date_depassee = $msg[empr_date_renouv_proche]; } elseif ($this->adhesion_depassee()) { $message_date_depassee = $msg[empr_date_depassee]; } else { $message_date_depassee=""; } if ($message_date_depassee) $alert_sound_list[]="critique"; $this->fiche = str_replace('!!empr_date_depassee!!', $message_date_depassee, $this->fiche); if ($this->age_categ_change()) { $message_categ_age_change = $msg[empr_categ_age_change]; } else { $message_categ_age_change=""; } if ($message_categ_age_change) $alert_sound_list[]="information"; $this->fiche = str_replace('!!empr_categ_age_change!!', $message_categ_age_change, $this->fiche); $group_zone = "$msg[64]"; if($groupID) $group_zone .= " $msg[grp_autre_lecteur]" ; $this->fiche = str_replace('!!group_zone!!', $group_zone, $this->fiche); $fsexe[0] = $msg[128]; $fsexe[1] = $msg[126]; $fsexe[2] = $msg[127]; $this->fiche = str_replace('!!sexe!!' , $fsexe[$this->sexe], $this->fiche); // valeur pour les champ hidden du prêt. L'id empr est pris en charge plus haut (voir Eric) $this->fiche = str_replace('!!cb!!' , $this->cb , $this->fiche); // traitement liste exemplaires en prêt $this->fiche = str_replace('!!nb_prets_encours!!' , $this->nb_pret , $this->fiche); //On affiche le bouton de mail si le destinataire a une adresse mail if ($this->mail) { $mail_click = "onclick=\"if (confirm('".$msg["mail_pret_confirm"]."')) { openPopUp('./pdf.php?pdfdoc=mail_liste_pret&id_empr=".$this->id."', 'print_PDF', 600, 500, -2, -2, '$PDF_win_prop');} return(false) \""; $bouton_mail_liste_pret=""; } else { $bouton_mail_liste_pret=""; } $this->fiche=str_replace("!!mail_liste_pret!!",$bouton_mail_liste_pret,$this->fiche); //Si mail de rappel affecté au responsable du groupe $requete="select id_groupe,resp_groupe from groupe,empr_groupe where id_groupe=groupe_id and empr_id=".$this->id." and resp_groupe and mail_rappel limit 1"; $res=pmb_mysql_query($requete); if(pmb_mysql_num_rows($res) > 0) { $requete="select id_empr, empr_mail from empr where id_empr='".pmb_mysql_result($res, 0,1)."'"; $result=pmb_mysql_query($requete); $has_mail = (pmb_mysql_result($result, 0,1) ? 1 : 0); } else { $has_mail = ($this->mail ? 1 : 0); } //Si retard sur un document, proposer la lettre de retard ou l'email de retard if ($this->retard>=1) { $imprime_click = "onclick=\"openPopUp('./pdf.php?pdfdoc=lettre_retard&id_empr=".$this->id."', 'lettre', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes'); return(false) \""; $bouton_lettre_retard=$msg['retard']." "; if (($has_mail)&&($biblio_email)) { $mail_click = "onclick=\"if (confirm('".$msg["mail_retard_confirm"]."')) { openPopUp('./mail.php?type_mail=mail_retard&id_empr=".$this->id."', 'mail', 600, 500, -2,- 2, 'toolbar=no, dependent=yes, resizable=yes, scrollbars=yes');} return(false) \""; $bouton_mail_retard=""; } else { $bouton_mail_retard=""; } } else { $bouton_lettre_retard=""; $bouton_mail_retard=""; } $this->fiche=str_replace("!!lettre_retard!!",$bouton_lettre_retard,$this->fiche); $this->fiche=str_replace("!!mail_retard!!",$bouton_mail_retard,$this->fiche); $voir_tout_pret=""; //separation prets classiques et prets courts $prets_list=array('0'=>'','1'=>''); if(!count($this->prets)) { // dans ce cas, le lecteur n'a rien en prêt $prets_list[0] = "
";
}
}
//Affichage des prolongations
global $pmb_pret_restriction_prolongation,$pmb_pret_nombre_prolongation,$pmb_utiliser_calendrier;
$pret_nombre_prolongation=0;
$forcage_prolongation=TRUE;
$duree_prolongation=0;
// Limitation simple du pret
if($pmb_pret_restriction_prolongation==1) {
$pret_nombre_prolongation=$pmb_pret_nombre_prolongation;
} elseif($pmb_pret_restriction_prolongation==2) {
// Limitation du pret par les quotas
//Initialisation des quotas pour nombre de prolongations
$qt = new quota("PROLONG_NMBR_QUOTA");
//Tableau de passage des paramètres
$struct["READER"] = $this->id;
$struct["EXPL"] = $valeur['id'];
$pret_nombre_prolongation=$qt -> get_quota_value($struct);
$forcage_prolongation=$qt -> get_force_value($struct);
//Initialisation des quotas de durée de prolongation
$qt = new quota("PROLONG_TIME_QUOTA");
$struct["READER"] = $this->id;
$struct["EXPL"] = $valeur['id'];
$duree_prolongation=$qt -> get_quota_value($struct);
}
//$forcage_prolongation=FALSE;
/* on prépare la date de début*/
$pret_date = $valeur['sql_date_retour'];
$rqt_date = "select date_add('".$pret_date."', INTERVAL '$duree_prolongation' DAY) as date_prolongation ";
$resultatdate = pmb_mysql_query($rqt_date);
$res = pmb_mysql_fetch_object($resultatdate) ;
$date_prolongation=str_replace('-' , "" , $res->date_prolongation);
if ($pmb_utiliser_calendrier) {
$req_date_calendrier = "select date_ouverture from ouvertures where ouvert=1 and num_location='".$valeur["idlocation"]."' and DATEDIFF(date_ouverture,'$date_prolongation')>=0 order by date_ouverture asc limit 1";
$res_date_calendrier = pmb_mysql_query($req_date_calendrier);
if (pmb_mysql_num_rows($res_date_calendrier) > 0) {
$date_prolongation=str_replace('-' , "" , pmb_mysql_result($res_date_calendrier,0,0));
}
}
if ($odd_even==0) {
$pair_impair = "odd";
$odd_even=1;
} else if ($odd_even==1) {
$pair_impair = "even";
$odd_even=0;
}
$expl_sur_loc="";
if($pmb_sur_location_activate){
$expl_sur_loc= "$this->empr_msg
"; $alert_sound_list[]="information"; $this->fiche_affichage = str_replace('!!empr_msg!!' ,$message_fiche_empr , $this->fiche_affichage); } else $this->fiche_affichage = str_replace('!!empr_msg!!', "", $this->fiche_affichage); // on distingue les messages de prêts du message sur l'emprunteur $this->fiche_affichage = str_replace('!!pret_msg!!' , $this->message , $this->fiche_affichage); if ($this->adhesion_renouv_proche()) { $message_date_depassee = $msg[empr_date_renouv_proche]; } elseif ($this->adhesion_depassee()) { $message_date_depassee = $msg[empr_date_depassee]; } else { $message_date_depassee=""; } if ($message_date_depassee) $alert_sound_list[]="critique"; $this->fiche_affichage = str_replace('!!empr_date_depassee!!', $message_date_depassee, $this->fiche_affichage); if ($this->age_categ_change()) { $message_categ_age_change = $msg[empr_categ_age_change]; } else { $message_categ_age_change=""; } if ($message_categ_age_change) $alert_sound_list[]="information"; $this->fiche_affichage = str_replace('!!empr_categ_age_change!!', $message_categ_age_change, $this->fiche_affichage); $fsexe[0] = $msg[128]; $fsexe[1] = $msg[126]; $fsexe[2] = $msg[127]; $this->fiche_affichage = str_replace('!!sexe!!' , $fsexe[$this->sexe], $this->fiche_affichage); // valeur pour les champ hidden du prêt. L'id empr est pris en charge plus haut $this->fiche_affichage = str_replace('!!cb!!' , $this->cb , $this->fiche_affichage); // traitement liste exemplaires en prêt $this->fiche_affichage = str_replace('!!nb_prets_encours!!' , $this->nb_pret , $this->fiche_affichage); if(!count($this->prets)) // dans ce cas, le lecteur n'a rien en prêt $prets_list = "
'.$msg[resa_menu_planning].'
$msg[empr_location] : ".$this->empr_location_l."
", $this->fiche_consultation);
//Groupes
if (count($this->groupes)) {
$this->fiche_consultation = str_replace('!!groupes!!',"".$msg[groupes_empr]." : ".implode(" / ",$this->groupes)."\n",$this->fiche_consultation);
} else {
$this->fiche_consultation = str_replace('!!groupes!!'," ",$this->fiche_consultation);
}
if (($pmb_gestion_financiere)&&($pmb_gestion_abonnement==2)) {
if ($this->type_abt) {
$requete="select type_abt_libelle from type_abts where id_type_abt='".$this->type_abt."'";
$resultat_type_abt=pmb_mysql_query($requete);
if (@pmb_mysql_num_rows($resultat_type_abt)) {
$abonnement=pmb_mysql_result($resultat_type_abt,0,0);
}
}
}
if ($abonnement) {
$this->fiche_consultation = str_replace("!!abonnement!!", "".$msg["finance_type_abt"]." : ".htmlentities($abonnement,ENT_QUOTES,$charset)."
\n",$this->fiche_consultation);
} else {
$this->fiche_consultation = str_replace("!!abonnement!!","",$this->fiche_consultation);
}
if ($this->empr_msg) {
$message_fiche_empr= "
$this->empr_msg
"; $this->fiche_consultation = str_replace('!!empr_msg!!' ,$message_fiche_empr , $this->fiche_consultation); } else $this->fiche_consultation = str_replace('!!empr_msg!!', "", $this->fiche_consultation); $fsexe[0] = $msg[128]; $fsexe[1] = $msg[126]; $fsexe[2] = $msg[127]; $this->fiche_consultation = str_replace('!!sexe!!' , $fsexe[$this->sexe], $this->fiche_consultation); } function import($data){ //champs de data : nom, prenom, cb, adr1, adr2,cp, ville, pays, mail, tel1, sms, tel2, year, sexe, login, password, date_adhesion, date_fin_blocage, date_expiration, date_creation //date_modif, prof, total_loans,last_loan_date, lang, msg, type_abt, //Pour la localisation : location, location_libelle, location_libelle_create, locdoc_owner //Pour la categorie : categ, categ_libelle, categ_libelle_create; //Pour le codestat: codestat, codestat_libelle, codestat_libelle_create; //Pour le statut: statut, statut_libelle, statut_libelle_create; global $dbh, $lang; // check sur le type de la variable passée en paramètre if(!sizeof($data) || !is_array($data)) { // si ce n'est pas un tableau ou un tableau vide, on retourne 0 return 0; } //Check si le lecteur a au moin un nom ou un prenom if(!$data['nom']) return 0; //Check si le code barre n'est pas déja utilisé $this->cb=addslashes($data['cb']); $query = "SELECT id_empr FROM empr WHERE empr_cb='".$this->cb."' LIMIT 1 "; $result = @pmb_mysql_query($query, $dbh); if(!$result) die("can't SELECT in database"); //On prepare les paramètres $this->empr_location=0; if(!$data['location'] and !$data['location_libelle'] and $data['location_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $data2=array(); $data2['location_libelle'] = $data['location_libelle_create']; $data2['locdoc_codage_import'] = $data['location_libelle_create']; $data2['locdoc_owner'] = $data['locdoc_owner']; $this->empr_location = docs_location::import($data2); }elseif($data['location_libelle'] != ''){ $q="select idlocation from docs_location where location_libelle='".addslashes($data['location_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_location =pmb_mysql_result($r,0,0); } }else{ $q="select idlocation from docs_location where idlocation='".addslashes($data['location'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_location =pmb_mysql_result($r,0,0); } } if(!$this->empr_location) return 0; $this->categ =0; if(!$data['categ'] and !$data['categ_libelle'] and $data['categ_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $q="select id_categ_empr from empr_categ where libelle='".addslashes($data['categ_libelle_create'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->categ =pmb_mysql_result($r,0,0); } else { $q= "insert into empr_categ (libelle) values ('".addslashes($data['categ_libelle_create'])."') "; $r = pmb_mysql_query($q, $dbh); $this->categ =pmb_mysql_insert_id($dbh); } }elseif($data['categ_libelle'] != ''){ $q="select id_categ_empr from empr_categ where libelle='".addslashes($data['categ_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->categ =pmb_mysql_result($r,0,0); } }else{ $q="select id_categ_empr from empr_categ where id_categ_empr='".addslashes($data['categ'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->categ =pmb_mysql_result($r,0,0); } } if(!$this->categ) return 0; $this->cstat=0; if(!$data['codestat'] and !$data['codestat_libelle'] and $data['codestat_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $q="select idcode from empr_codestat where libelle='".addslashes($data['codestat_libelle_create'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->cstat =pmb_mysql_result($r,0,0); } else { $q= "insert into empr_codestat (libelle) values ('".addslashes($data['codestat_libelle_create'])."') "; $r = pmb_mysql_query($q, $dbh); $this->cstat =pmb_mysql_insert_id($dbh); } }elseif($data['codestat_libelle'] != ''){ $q="select idcode from empr_codestat where libelle='".addslashes($data['codestat_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->cstat =pmb_mysql_result($r,0,0); } }else{ $q="select idcode from empr_codestat where idcode='".addslashes($data['codestat'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->cstat =pmb_mysql_result($r,0,0); } } if(!$this->cstat) return 0; $this->empr_statut=0; if(!$data['statut'] and !$data['statut_libelle'] and $data['statut_libelle_create'] != ''){ //Dans la cas ou l'on veut creer la location $q="select idstatut from empr_statut where statut_libelle='".addslashes($data['statut_libelle_create'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_statut =pmb_mysql_result($r,0,0); } else { $q= "insert into empr_statut (statut_libelle) values ('".addslashes($data['statut_libelle_create'])."') "; $r = pmb_mysql_query($q, $dbh); $this->empr_statut =pmb_mysql_insert_id($dbh); } }elseif($data['statut_libelle'] != ''){ $q="select idstatut from empr_statut where statut_libelle='".addslashes($data['statut_libelle'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_statut =pmb_mysql_result($r,0,0); } }else{ $q="select idstatut from empr_statut where idstatut='".addslashes($data['statut'])."' limit 1"; $r = pmb_mysql_query($q, $dbh); if (pmb_mysql_num_rows($r)) { $this->empr_statut =pmb_mysql_result($r,0,0); } } if(!$this->empr_statut) return 0; $this->nom=addslashes($data['nom']); $this->prenom=addslashes($data['prenom']); $this->adr1=addslashes($data['adr1']); $this->adr2=addslashes($data['adr2']); $this->cp=addslashes($data['cp']); $this->ville=addslashes($data['ville']); $this->pays=addslashes($data['pays']); $this->mail=addslashes($data['mail']); $this->tel1=addslashes($data['tel1']); $this->sms=addslashes($data['sms']); $this->tel2=addslashes($data['tel2']); if($data['sexe'] === 0 or $data['sexe'] == 1 or $data['sexe'] == 2){ $this->sexe=$data['sexe']; }else{ $this->sexe=0; } $this->birth=addslashes($data['year']); $this->date_adhesion=addslashes($data['date_adhesion']); $this->date_blocage=addslashes($data['date_fin_blocage']); $this->date_expiration=addslashes($data['date_expiration']); if(!$data['date_creation']){ $this->cdate=today(); }else{ $this->cdate=addslashes($data['date_creation']); } if(!$data['date_modif']){ $this->mdate=today(); }else{ $this->mdate=addslashes($data['date_modif']); } $this->pwd=addslashes($data['password']); $this->prof=addslashes($data['prof']); $this->total_loans=addslashes($data['total_loans']); $this->last_loan_date=addslashes($data['last_loan_date']); if(!$data['lang']){ $this->empr_lang=$lang; }else{ $this->empr_lang=addslashes($data['lang']); } $this->empr_msg=addslashes($data['msg']); $this->type_abt=addslashes($data['type_abt']); $this->login=addslashes($data['login']); $q = "insert into empr (empr_cb, empr_nom, empr_prenom, empr_adr1, empr_cp, empr_ville, empr_pays, "; $q.= "empr_mail, empr_tel1, empr_sms, empr_categ, empr_codestat, empr_sexe, empr_login, empr_date_adhesion, "; $q.= "empr_date_expiration, empr_lang, empr_location,empr_msg,empr_year,empr_creation,empr_adr2,empr_tel2, empr_modif,empr_password,empr_prof,type_abt,empr_statut,total_loans,last_loan_date,date_fin_blocage) "; $q.= "values ('".$this->cb."', '".$this->nom."', '".$this->prenom."', '".$this->adr1."', '".$this->cp."', '".$this->ville."', '".$this->pays."', "; $q.= "'".$this->mail."', '".$this->tel1."', '".$this->sms."', '".$this->categ."', '".$this->cstat."', '".$this->sexe."', '".$this->login."', '".$this->date_adhesion."', "; $q.= "'".$this->date_expiration."', '".$this->empr_lang."', '".$this->empr_location."', '".$this->empr_msg."', '".$this->birth."', '".$this->cdate."', '".$this->adr2."', '".$this->tel2."', '".$this->mdate."', '".$this->pwd."', '".$this->prof."','".$this->type_abt."','".$this->empr_statut."','".$this->total_loans."', '".$this->last_loan_date."', '".$this->date_blocage."') "; $r=pmb_mysql_query($q, $dbh); $id_empr = pmb_mysql_insert_id($dbh); emprunteur::update_digest($this->login,$this->pwd); emprunteur::hash_password($this->login,$this->pwd); return $id_empr; } static function do_login($nom,$prenom) { global $dbh; $nom_forate=str_replace(' ','',strtolower(strip_empty_chars($nom))); $prenom_forate=str_replace(' ','',strtolower(strip_empty_chars($prenom))); $empr_login = substr($prenom_forate,0,1).$nom_forate; $pb = 1 ; $num_login=1 ; $empr_login2=$empr_login; while ($pb==1) { $q = "SELECT empr_login FROM empr WHERE empr_login='$empr_login2' LIMIT 1 "; $r = pmb_mysql_query($q, $dbh); $nb = pmb_mysql_num_rows($r); if ($nb) { $empr_login2 =$empr_login.$num_login ; $num_login++; } else $pb = 0 ; } return $empr_login2; } function do_fiche_retard(){ global $charset, $empr_retard_tpl, $dbh, $msg; global $opac_empr_hist_nb_jour_max; $empr_retard_tpl = str_replace("!!prenom!!",htmlentities($this->prenom,ENT_QUOTES,$charset),$empr_retard_tpl); $empr_retard_tpl = str_replace("!!nom!!",htmlentities($this->nom,ENT_QUOTES,$charset),$empr_retard_tpl); if ($opac_empr_hist_nb_jour_max){ $req_retards = "select id_log from log_retard where idempr='".$this->id."' and date_add(date_log, INTERVAL $opac_empr_hist_nb_jour_max day)
| ".$msg['empr_late_titre']." | ".$msg['empr_late_expl_cb']." | ".$msg['empr_late_date_pret']." | ".$msg['empr_late_date_retour']." | ".$msg['empr_late_amende']." | "; $req_expl = "select * from log_expl_retard where num_log_retard='".$retard->id_log."'"; $res = pmb_mysql_query($req_expl); $content=""; while($expl = pmb_mysql_fetch_object($res)){ if($tr_class=='odd') $tr_class='even'; else $tr_class='odd'; $content.= "
|---|---|---|---|---|
| ".$expl->titre." | ".$expl->expl_cb." | ".formatdate($expl->date_pret)." | ".formatdate($expl->date_retour)." | ".comptes::format($expl->amende)." |
| ".$msg["relance_nb_retard"]." | ".$msg["relance_dernier_niveau"]." | ".$msg["relance_date_derniere"]." | ".$msg["relance_imprime"]." | ".$msg["relance_niveau_suppose"]." |
|---|---|---|---|---|
| ".$msg["relance_nb_retard"].": $empr->empr_nb | ".$msg["relance_dernier_niveau"].": $niveau_min | ".$msg["relance_date_derniere"].": ".$list_dates[$date_relance]." | ".$msg["relance_imprime"].": ".($printed?"".$msg[40]."":"".$msg[39]."")." | ".$msg["relance_niveau_suppose"].": $niveau_normal |