$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);