![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.="
";
$n_c++;
}
if ($n_c<3) {
for ($i=$n_c; $i<4; $i++)
$compte.=" ";
}
$compte.="
".$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)."
";
$compte.="'.$this->message; } $order = " order by p.pret_date desc"; $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); $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); $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' => (isset($sur_loc) ? $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' => (isset($sur_loc) ? $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); $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); $resa_planning = pmb_mysql_fetch_object($result_resa_planning); $this->nb_previsions = $resa_planning->nb_previsions ; } return TRUE; } // fabrication de la fiche lecteur public 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 $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; global $pmb_pret_date_retour_adhesion_depassee; global $pmb_pret_restriction_prolongation,$pmb_pret_nombre_prolongation,$pmb_utiliser_calendrier; global $pmb_pret_aff_limitation; global $pmb_pret_aff_nombre; global $see_all_pret; global $current_module; $loc_prolongation = 0; $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;
} else {
$resume_localisation="";
}
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);
$resume_groupe = '';
}
// 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, pret_idexpl"; $requete .= " from pret p"; $requete .= " where p.pret_idempr=".$this->id; $result = pmb_mysql_query($requete); while($bloca = pmb_mysql_fetch_object($result)) { if ($bloca->pret_retour){ $pret_retour=$bloca->pret_retour; $date_debut=explode("-",$pret_retour); //choix du mode de calcul $loc_calendar = 0; global $pmb_utiliser_calendrier, $pmb_utiliser_calendrier_location; if (($pmb_utiliser_calendrier==1) && $pmb_utiliser_calendrier_location) { $res=pmb_mysql_query("select expl_location from exemplaires where expl_id=".$bloca->pret_idexpl); if (pmb_mysql_num_rows($res)) { $row = pmb_mysql_fetch_object($res); $loc_calendar = $row->expl_location; } } $ndays=calendar::get_open_days($date_debut[2],$date_debut[1],$date_debut[0],date("d"),date("m"),date("Y"),$loc_calendar); if ($ndays>$pmb_blocage_delai) { $ndays=$ndays*$pmb_blocage_coef; if (($ndays>$pmb_blocage_max)&&($pmb_blocage_max!=0)) { if ($pmb_blocage_max!=-1) { $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="
!!comment!!
!!aff!!
";
if (isset($perso_['FIELDS']) && 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);
$field_tpl = str_replace("!!comment!!", $field['COMMENT_DISPLAY'], $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, '');} 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']." (".$this->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'=>''); $vdr = ''; $id_inpret = ''; if(!count($this->prets)) { // dans ce cas, le lecteur n'a rien en prêt $prets_list[0] = "
![".addslashes($qt_resas." ".$msg["reserv_en_cours_doc"])."](./images/alert.gif "\".addslashes($qt_resas.\" \".$msg[\"reserv_en_cours_doc\"]).\"")
";
}
}
//Affichage des prolongations
$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'];
if($pmb_pret_date_retour_adhesion_depassee) {
$rqt_date = "select date_add('".$pret_date."', INTERVAL '$duree_prolongation' DAY) as date_prolongation ";
} else {
$rqt_date = "select if(empr_date_expiration>date_add('".$pret_date."', INTERVAL '$duree_prolongation' DAY),date_add('".$pret_date."', INTERVAL '$duree_prolongation' DAY),empr_date_expiration) as date_prolongation from empr where id_empr=".$this->id;
}
$resultatdate = pmb_mysql_query($rqt_date);
$res = pmb_mysql_fetch_object($resultatdate) ;
$date_prolongation=str_replace('-' , "" , $res->date_prolongation);
$loc_prolongation = $valeur["idlocation"];
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); } public 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 $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); 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); 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); 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); 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); $this->categ =pmb_mysql_insert_id(); } }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); 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); 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); 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); $this->cstat =pmb_mysql_insert_id(); } }elseif($data['codestat_libelle'] != ''){ $q="select idcode from empr_codestat where libelle='".addslashes($data['codestat_libelle'])."' limit 1"; $r = pmb_mysql_query($q); 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); 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); 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); $this->empr_statut =pmb_mysql_insert_id(); } }elseif($data['statut_libelle'] != ''){ $q="select idstatut from empr_statut where statut_libelle='".addslashes($data['statut_libelle'])."' limit 1"; $r = pmb_mysql_query($q); 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); 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); $id_empr = pmb_mysql_insert_id(); emprunteur::update_digest($this->login,$this->pwd); emprunteur::hash_password($this->login,$this->pwd); return $id_empr; } public static function do_login($nom,$prenom) { $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); $nb = pmb_mysql_num_rows($r); if ($nb) { $empr_login2 =$empr_login.$num_login ; $num_login++; } else $pb = 0 ; } return $empr_login2; } public function do_fiche_retard(){ global $charset, $empr_retard_tpl, $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 |
id."', true); bannette_expand_form(); return false;\" hspace='3'>