$total = 0; print '<table class="noborder" width="100%">'; print '<tr class="liste_titre">'; print '<td class="nowrap" align="left">' . $langs->trans("Ref") . '</td>'; print "<td>" . $langs->trans("Label") . "</td>"; print '<td class="nowrap" align="left">' . $langs->trans("DatePayment") . '</td>'; print "<td align=\"right\">" . $langs->trans("PayedByThisPayment") . "</td>"; print "</tr>\n"; $var = 1; while ($i < $num) { $obj = $db->fetch_object($result); $var = !$var; print "<tr " . $bc[$var] . ">"; $localtax_static->id = $obj->rowid; $localtax_static->ref = $obj->rowid; print "<td>" . $localtax_static->getNomUrl(1) . "</td>\n"; print "<td>" . dol_trunc($obj->label, 40) . "</td>\n"; print '<td align="left">' . dol_print_date($db->jdate($obj->dm), 'day') . "</td>\n"; $total = $total + $obj->amount; print "<td align=\"right\">" . price($obj->amount) . "</td>"; print "</tr>\n"; $i++; } print '<tr class="liste_total"><td colspan="3">' . $langs->trans("Total") . '</td>'; print "<td align=\"right\"><b>" . price($total) . "</b></td></tr>"; print "</table>"; $db->free($result); } else { dol_print_error($db); } $db->close();