${msg[929]} 

"; if ($empr_allow_prolong_members_group) { $dbt = 0; if ($action == "prolonggroup") { if ($debit) $dbt = $debit; } else { if ($empr_abonnement_default_debit) $dbt = $empr_abonnement_default_debit; } print pmb_bidi(" "; } print "

"; if($myGroup->nb_members) { print ""; if ($empr_allow_prolong_members_group) { print ""; } print ""; $parity=1; while(list($cle, $membre) = each($myGroup->members)) { if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $nb_pret=get_nombre_pret($membre['id']); $nb_resa=get_aff_nb_resa_and_validees($membre['id']); $tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" "; $dn_javascript = "onmousedown=\"document.location='./circ.php?categ=pret&form_cb=".rawurlencode($membre['cb'])."&groupID=$groupID';\" style='cursor: pointer' "; print pmb_bidi(""); if ($empr_allow_prolong_members_group) { $empr_temp = new emprunteur($membre['id'], '', FALSE, 0) ; print pmb_bidi(" "); if ($empr_temp->adhesion_renouv_proche() || $empr_temp->adhesion_depassee()) { $rqt="select duree_adhesion from empr_categ where id_categ_empr='$empr_temp->categ'"; $res_dur_adhesion = pmb_mysql_query($rqt, $dbh); $row = pmb_mysql_fetch_row($res_dur_adhesion); $nb_jour_adhesion_categ = $row[0]; if ($empr_prolong_calc_date_adhes_depassee && $empr_temp->adhesion_depassee()) { $rqt_date = "select date_add(curdate(),INTERVAL 1 DAY) as nouv_date_debut, date_add(curdate(),INTERVAL $nb_jour_adhesion_categ DAY) as nouv_date_fin "; } else { $rqt_date = "select date_add('$empr_temp->date_expiration',INTERVAL 1 DAY) as nouv_date_debut, date_add('$empr_temp->date_expiration',INTERVAL $nb_jour_adhesion_categ DAY) as nouv_date_fin "; } $resultatdate=pmb_mysql_query($rqt_date) or die ("
$rqt_date ".pmb_mysql_error()); $resdate=pmb_mysql_fetch_object($resultatdate); $expiration = ""; print pmb_bidi(""); } else { print pmb_bidi(""); } } print pmb_bidi(" "); } print '

".$msg["nom_prenom_empr"]."	".$msg["code_barre_empr"]."	".$msg["empr_nb_pret"]."	".$msg["groupes_nb_resa_dont_valides"]."	".$msg["group_empr_date_adhesion"]."	".$msg["group_empr_date_expiration"]."	".$msg["group_empr_date_prolong"]."
".$membre['nom']); if($membre['prenom'])print pmb_bidi(", ${membre['prenom']}"); print pmb_bidi("	${membre['cb']}	".$nb_pret."	".$nb_resa."	".$empr_temp->aff_date_adhesion."	".$empr_temp->aff_date_expiration."	".$expiration."

'; } else { print "

$msg[922]

"; } if ($empr_allow_prolong_members_group) { print pmb_bidi(" "); } // pour que le formulaire soit OK juste après la création du groupe $group_form_add_membre = str_replace("!!groupID!!", $groupID, $group_form_add_membre); print $group_form_add_membre ; function get_nombre_pret($id_empr) { $requete = "SELECT count( pret_idempr ) as nb_pret FROM pret where pret_idempr = $id_empr"; $res_pret = pmb_mysql_query($requete); if (pmb_mysql_num_rows($res_pret)) { $rpret=pmb_mysql_fetch_object($res_pret); $nb_pret=$rpret->nb_pret; } return $nb_pret; } function get_aff_nb_resa_and_validees($id_empr) { $aff_nb_resa = ''; $requete = "SELECT count( resa_idempr ) as nb_resa FROM resa where resa_idempr = ".$id_empr; $res_resa = pmb_mysql_query($requete); if (pmb_mysql_num_rows($res_resa)) { $rresa = pmb_mysql_fetch_object($res_resa); $aff_nb_resa = $rresa->nb_resa; $requete = "SELECT count( resa_idempr ) as nb_resa_val FROM resa where resa_idempr = ".$id_empr." AND resa_cb<>''"; $res_resa = pmb_mysql_query($requete); if (pmb_mysql_num_rows($res_resa)) { $rresa = pmb_mysql_fetch_object($res_resa); if ($rresa->nb_resa_val) { $aff_nb_resa .= " (".$rresa->nb_resa_val.")"; } } } return $aff_nb_resa; }