";
echo $deb_ligne ;
echo "| ".$titre." | ";
echo "".$auteur." | ";
echo "".$data["tdoc_libelle"]." | ";
echo "".$data['aff_pret_date']." | ";
if ($data['retard']) echo "".$data['aff_pret_retour']." | ";
else echo "".$data['aff_pret_retour']." | ";
// Paramètre de l'opac $opac_pret_prolongation autorisant la gestion des prolongations
if ($opac_pret_prolongation==1 && $allow_prol) {
$prolongation=TRUE;
$no_prolong_explanation = '';
$expl_id = $data['expl_id'] ;
$query = "select cpt_prolongation, pret_date,pret_retour, expl_location, niveau_relance, short_loan_flag from pret, exemplaires where expl_id=pret_idexpl and pret_idexpl='".$data['expl_id']."'";
$result = pmb_mysql_query($query, $dbh);
$data_expl = pmb_mysql_fetch_array($result);
$nb_prolongation = $cpt_prolongation = $data_expl['cpt_prolongation'];
$pret_date = $data_expl['pret_date'];
$date_retour= $data_expl['pret_retour'];
if ($data_expl['short_loan_flag']) {
$prolongation = FALSE;
$no_prolong_explanation = $msg['empr_no_prolongation_short_loan_flag'];
}
$cpt_prolongation++;
$duree_prolongation=$opac_pret_duree_prolongation;
$today=sql_value("SELECT CURRENT_DATE()");
if ($pmb_pret_restriction_prolongation==0) {
// Aucune limitation des prolongations
$prolongation=true;
$duree_prolongation=$opac_pret_duree_prolongation;
} else if ($pmb_pret_restriction_prolongation>0) {
$pret_nombre_prolongation=$pmb_pret_nombre_prolongation;
if(($pmb_pret_restriction_prolongation==1) && ($cpt_prolongation>$pret_nombre_prolongation)) {
// Limitation simple de la prolongation
$prolongation=FALSE;
$no_prolong_explanation = $msg['empr_no_prolongation_limit'];
} else if($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"] = $id_empr;
$struct["EXPL"] = $expl_id;
$struct["NOTI"] = exemplaire::get_expl_notice_from_id($expl_id);
$struct["BULL"] = exemplaire::get_expl_bulletin_from_id($expl_id);
$pret_nombre_prolongation=$qt -> get_quota_value($struct);
if($cpt_prolongation>$pret_nombre_prolongation){
$prolongation=FALSE;
$no_prolong_explanation = $msg['empr_no_prolongation_limit'];
}
//Initialisation des quotas la durée de prolongations
$qt = new quota("PROLONG_TIME_QUOTA");
$struct["READER"] = $id_empr;
$struct["EXPL"] = $expl_id;
$struct["NOTI"] = exemplaire::get_expl_notice_from_id($expl_id);
$struct["BULL"] = exemplaire::get_expl_bulletin_from_id($expl_id);
$duree_prolongation=$qt -> get_quota_value($struct);
} // fin if gestion par quotas
} // fin else if pmb_pret_restriction_prolongation>0
$empr_date_expiration=sql_value("SELECT empr_date_expiration FROM empr WHERE id_empr=".$id_empr);
if($pmb_pret_date_retour_adhesion_depassee) {
$date_prolongation=sql_value("SELECT DATE_ADD('$date_retour', INTERVAL $duree_prolongation DAY)");
} else {
if ($empr_date_expiration < $today) {
$prolongation=FALSE;
$no_prolong_explanation = $msg['empr_no_prolongation_adhesion_depassee'];
}
$date_prolongation=sql_value("SELECT if('".$empr_date_expiration."'>DATE_ADD('".$date_retour."', INTERVAL '$duree_prolongation' DAY),DATE_ADD('".$date_retour."', INTERVAL '$duree_prolongation' DAY),'".$empr_date_expiration."')");
}
if ((!$pmb_pret_date_retour_adhesion_depassee) && ($prolongation==TRUE)) {
if ($date_prolongation<$date_retour) {
$prolongation=FALSE;
$no_prolong_explanation = $msg['empr_no_prolongation_retour_ahesion_depassee'];
}
}
if ($prolongation==TRUE) {
$diff=sql_value("SELECT DATEDIFF('$date_retour','$today')");
if($diff<-$duree_prolongation || $diff>$duree_prolongation) {
$prolongation=FALSE;
$date_deb_prolongation = sql_value("SELECT DATE_ADD('$date_retour', INTERVAL -$duree_prolongation DAY)");
$date_fin_prolongation = sql_value("SELECT DATE_ADD('$date_retour', INTERVAL $duree_prolongation DAY)");
$no_prolong_explanation = sprintf($msg['empr_prolongation_not_yet_dispo'],formatdate($date_deb_prolongation),formatdate($date_fin_prolongation));
}
}
$req_date_calendrier = "select date_ouverture from ouvertures where ouvert=1 and num_location='".$data_expl['expl_location']."' 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)) {
$date_prolongation=pmb_mysql_result($res_date_calendrier,0,0);
}
// Verif s'il y a des résa et plus d'exemplaire dispo
if ($prolongation==TRUE) {
if($data['num_notice_mono']) $data['bulletin_id']=0;
else $data['num_notice_mono']=0;
// chercher le premier (par ordre de rang, donc de date de début de résa, non validé
$rqt = "SELECT count(1) FROM resa
WHERE resa_idnotice='".$data['num_notice_mono']."' AND resa_idbulletin='".$data['bulletin_id']."'
AND resa_cb='' AND resa_date_fin='0000-00-00' ";
$res= pmb_mysql_query($rqt);
$nbresa = pmb_mysql_result($res, 0, 0);
if($nbresa){
$rqt="SELECT count(1) FROM exemplaires, docs_statut WHERE expl_statut=idstatut and pret_flag=1 and statut_visible_opac=1 AND expl_notice=".$data['num_notice_mono']." AND expl_bulletin=".$data['bulletin_id']." ";
if($pmb_location_reservation) {
$rqt.=" and expl_location in (select resa_loc from resa_loc where resa_emprloc=".$data['empr_location'].") ";
}
$res= pmb_mysql_query($rqt);
$nbexpl = pmb_mysql_result($res, 0, 0);
$rqt="SELECT count(1) FROM pret,exemplaires WHERE pret_idexpl=expl_id AND expl_notice=".$data['num_notice_mono']." AND expl_bulletin=".$data['bulletin_id']." ";
if($pmb_location_reservation) {
$rqt.=" and expl_location in (select resa_loc from resa_loc where resa_emprloc=".$data['empr_location'].") ";
}
$res= pmb_mysql_query($rqt);
$nbexpl_en_pret = pmb_mysql_result($res, 0, 0);
if(($nbexpl-$nbexpl_en_pret) < $nbresa){
$prolongation=FALSE;
$no_prolong_explanation = $msg['empr_no_prolongation_resa'];
}
}
}
echo "".$nb_prolongation."/".$pret_nombre_prolongation." | ";
//Blocage des prolongations si relance sur pret, selon paramètre
if ($opac_pret_prolongation_blocage) {
if ($data_expl['niveau_relance']!='0') {
$prolongation=false;
$no_prolong_explanation = $msg['empr_no_prolongation_relance'];
}
}
// Proposer le bouton prolongation
if ($prolongation==TRUE) {
// Mettre au format affichable
$rqt_date = "select date_format('$date_prolongation', '".$msg["format_date_sql"]."') as aff_date_prolongation ";
$resultatdate = pmb_mysql_query($rqt_date);
$res = pmb_mysql_fetch_object($resultatdate) ;
$aff_date_prolongation= $res->aff_date_prolongation;
// Bouton de prolongation
if (sql_value("SELECT DATEDIFF('$date_retour','$date_prolongation')") == 0) {
$prolongation=false;
$no_prolong_explanation = $msg['empr_no_prolongation_date_prolongation'];
}
}
$js="onmousedown=\"if (event) e=event; else e=window.event; if (e.target) elt=e.target; else elt=e.srcElement; e.cancelBubble = true; if (e.stopPropagation) e.stopPropagation(); return false;\" ";
if ($prolongation) {
echo "$aff_date_prolongation | ";
} else {
echo "![](".get_url_icon("no_prolongation.png")." "\".htmlentities($no_prolong_explanation,ENT_QUOTES,$charset).\"") | ";
}
} // fin if prolongeable
/* test de date de retour dépassée */
if ($lvl!="late")
if ($data['retard']) echo "× | ";
else echo " | ";
echo "
\n";
} // fin du while
echo "