print '<td align="center">' . $langs->trans("DateCreation") . '</td>'; print '<td align="center">' . $langs->trans("DateStart") . '</td>'; print '<td align="center">' . $langs->trans("DateEnd") . '</td>'; print '<td align="right">' . $langs->trans("Amount") . '</td>'; if (!empty($conf->banque->enabled)) { print '<td align="right">' . $langs->trans("Account") . '</td>'; } print "</tr>\n"; $var = True; while ($i < $num) { $objp = $db->fetch_object($result); $var = !$var; print "<tr " . $bc[$var] . ">"; $cotisationstatic->ref = $objp->crowid; $cotisationstatic->id = $objp->crowid; print '<td>' . $cotisationstatic->getNomUrl(1) . '</td>'; print '<td align="center">' . dol_print_date($db->jdate($objp->datec), 'dayhour') . "</td>\n"; print '<td align="center">' . dol_print_date($db->jdate($objp->dateh), 'day') . "</td>\n"; print '<td align="center">' . dol_print_date($db->jdate($objp->datef), 'day') . "</td>\n"; print '<td align="right">' . price($objp->cotisation) . '</td>'; if (!empty($conf->banque->enabled)) { print '<td align="right">'; if ($objp->bid) { $accountstatic->label = $objp->label; $accountstatic->id = $objp->baid; print $accountstatic->getNomUrl(1); } else { print ' '; } print '</td>'; }
$obj = $db->fetch_object($resql); print "<tr " . $bc[$var] . ">"; $subscriptionstatic->id = $obj->cid; $subscriptionstatic->ref = $obj->cid; $staticmember->id = $obj->rowid; $staticmember->lastname = $obj->lastname; $staticmember->firstname = $obj->firstname; if (!empty($obj->fk_soc)) { $staticmember->socid = $obj->fk_soc; $staticmember->fetch_thirdparty(); $staticmember->name = $staticmember->thirdparty->name; } else { $staticmember->name = $obj->company; } $staticmember->ref = $staticmember->getFullName($langs); print '<td>' . $subscriptionstatic->getNomUrl(1) . '</td>'; print '<td>' . $staticmember->getNomUrl(1, 32, 'subscription') . '</td>'; print '<td>' . get_date_range($db->jdate($obj->date_start), $db->jdate($obj->date_end)) . '</td>'; print '<td align="right">' . price($obj->cotisation) . '</td>'; //print '<td align="right">'.$staticmember->LibStatut($obj->statut,($obj->cotisation=='yes'?1:0),$db->jdate($obj->date_end_subscription),5).'</td>'; print '<td align="right">' . dol_print_date($db->jdate($obj->datem ? $obj->datem : $obj->datec), 'dayhour') . '</td>'; print '</tr>'; $i++; } } print "</table><br>"; } else { dol_print_error($db); } // Summary of members by type print '<table class="noborder" width="100%">';