$objp = $db->fetch_object($resql);
$expensereportstatic->id = $objp->rowid;
$expensereportstatic->ref = $objp->ref;
$var = !$var;
print "<tr " . $bc[$var] . ">";
print '<td>' . $expensereportstatic->getNomUrl(1) . '</td>';
print '<td align="center">' . ($objp->date_debut > 0 ? dol_print_date($objp->date_debut, 'day') : '') . '</td>';
print '<td align="center">' . ($objp->date_fin > 0 ? dol_print_date($objp->date_fin, 'day') : '') . '</td>';
print '<td align="left"><a href="' . DOL_URL_ROOT . '/user/card.php?id=' . $objp->id_user . '">' . img_object($langs->trans("ShowUser"), "user") . ' ' . dolGetFirstLastname($objp->firstname, $objp->lastname) . '</a></td>';
print '<td align="right">' . price($objp->total_ht) . '</td>';
print '<td align="right">' . price($objp->total_tva) . '</td>';
print '<td align="right">' . price($objp->total_ttc) . '</td>';
$expensereporttmp->status = $objp->status;
print '<td align="right">';
//print $objp->status;
print $expensereporttmp->getLibStatut(5);
print '</td>';
print '<td></td>';
print "</tr>\n";
$total_total_ht = $total_total_ht + $objp->total_ht;
$total_total_tva = $total_total_tva + $objp->total_tva;
$total_total_ttc = $total_total_ttc + $objp->total_ttc;
$i++;
}
print '<tr class="liste_total">';
print '<td colspan="4">' . $langs->trans("Total") . '</td>';
print '<td style="text-align:right;">' . price($total_total_ht) . '</td>';
print '<td style="text-align:right;">' . price($total_total_tva) . '</td>';
print '<td style="text-align:right;">' . price($total_total_ttc) . '</td>';
print '<td></td>';
print '<td></td>';
print "</tr>\n";
if ($num > 0) {
$var = True;
while ($i < $num) {
$objp = $db->fetch_object($resql);
$var = !$var;
print '<tr ' . $bc[$var] . '>';
// Ref
print '<td>';
$expensereport->fetch($objp->did);
print $expensereport->getNomUrl(1);
print "</td>\n";
// Expected to pay
print '<td align="right">' . price($objp->total_ttc) . '</td>';
// Status
print '<td align="center">' . $expensereport->getLibStatut(4, $objp->amount) . '</td>';
// Amount paid
print '<td align="right">' . price($objp->amount) . '</td>';
print "</tr>\n";
if ($objp->paid == 1) {
$disable_delete = 1;
}
$total = $total + $objp->amount;
$i++;
}
}
$var = !$var;
print "</table>\n";
$db->free($resql);
} else {
dol_print_error($db);
