${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_nombre_resa($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 = mysql_query($rqt, $dbh); $row = mysql_fetch_row($res_dur_adhesion); $nb_jour_adhesion_categ = $row[0]; if ($empr_prolong_calc_date_adhes_depassee && $empr_temp->adhesion_depassee()) { $rqt_date = "select date_add(curdate(),INTERVAL 1 DAY) as nouv_date_debut, 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=mysql_query($rqt_date) or die ("
$rqt_date ".mysql_error()); $resdate=mysql_fetch_object($resultatdate); $date_clic = "onClick=\"openPopUp('./select.php?what=calendrier&caller=group_form&date_caller=".preg_replace('/-/', '', $resdate->nouv_date_fin)."¶m1=form_expiration_".$membre['id']."¶m2=form_expiration_lib_".$membre['id']."&auto_submit=NO&date_anterieure=YES', 'date_adhesion', 205, 300, -2, -2, 'toolbar=no, dependent=yes, resizable=yes')\" "; $expiration = " nouv_date_fin)."' /> "; print pmb_bidi(""); } else { print pmb_bidi(""); } } print pmb_bidi(" "); } print '

".$msg["nom_prenom_empr"]."	".$msg["code_barre_empr"]."	".$msg["empr_nb_pret"]."	".$msg["empr_nb_resa"]."	".$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 = mysql_query($requete); if (mysql_num_rows($res_pret)) { $rpret=mysql_fetch_object($res_pret); $nb_pret=$rpret->nb_pret; } return $nb_pret; } function get_nombre_resa($id_empr) { $requete = "SELECT count( resa_idempr ) as nb_resa FROM resa where resa_idempr = $id_empr"; $res_resa = mysql_query($requete); if (mysql_num_rows($res_resa)) { $rresa=mysql_fetch_object($res_resa); $nb_resa=$rresa->nb_resa; } return $nb_resa; }