print_liste_field_titre($langs->trans("DatePayment"), $_SERVER["PHP_SELF"], "pv.datev", "", $param, 'align="center"', $sortfield, $sortorder);
print_liste_field_titre($langs->trans("PayedByThisPayment"), $_SERVER["PHP_SELF"], "pv.amount", "", $param, 'align="right"', $sortfield, $sortorder);
print "</tr>\n";
$var = 1;
while ($i < $num) {
$obj = $db->fetch_object($result);
$total = $total + $obj->amount;
$var = !$var;
print "<tr " . $bc[$var] . ">";
print '<td align="left">' . dol_print_date($db->jdate($obj->dm), 'day') . '</td>' . "\n";
print "<td>" . $obj->label . "</td>\n";
print '<td align="right">' . price($obj->amount) . "</td>";
// Ref payment
$tva_static->id = $obj->rowid;
$tva_static->ref = $obj->rowid;
print '<td align="left">' . $tva_static->getNomUrl(1) . "</td>\n";
print '<td align="center">' . dol_print_date($db->jdate($obj->dm), 'day') . "</td>\n";
print '<td align="right">' . price($obj->amount) . "</td>";
print "</tr>\n";
$i++;
}
print '<tr class="liste_total"><td colspan="2">' . $langs->trans("Total") . '</td>';
print '<td align="right">' . price($total) . "</td>";
print '<td align="center"> </td>';
print '<td align="center"> </td>';
print '<td align="right">' . price($total) . "</td>";
print "</tr>";
print "</table>";
$db->free($result);
} else {
dol_print_error($db);
$total = 0;
print '<table class="noborder" width="100%">';
print '<tr class="liste_titre">';
print '<td nowrap align="left">' . $langs->trans("Ref") . '</td>';
print "<td>" . $langs->trans("Label") . "</td>";
print '<td 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]}>";
$tva_static->id = $obj->rowid;
$tva_static->ref = $obj->rowid;
print "<td>" . $tva_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();
