while ($i < $num && $i < $max) { $obj = $db->fetch_object($result); $expensereportstatic->id = $obj->rowid; $expensereportstatic->ref = $obj->ref; $userstatic->id = $obj->uid; $userstatic->lastname = $obj->lastname; $userstatic->firstname = $obj->firstname; print '<tr ' . $bc[$var] . '>'; print '<td>' . $expensereportstatic->getNomUrl(1) . '</td>'; print '<td>' . $userstatic->getNomUrl(1) . '</td>'; print '<td align="right">' . price($obj->total_ht) . '</td>'; print '<td align="right">' . price($obj->total_ttc) . '</td>'; print '<td align="right">' . dol_print_date($db->jdate($obj->dm), 'day') . '</td>'; print '<td align="right">'; //print $obj->libelle; print $expensereportstatic->LibStatut($obj->fk_status, 3); print '</td>'; print '</tr>'; $var = !$var; $i++; } } else { print '<tr ' . $bc[$var] . '><td colspan="6">' . $langs->trans("None") . '</td></tr>'; } print '</table><br>'; } else { dol_print_error($db); } print '</div></div></div>'; llxFooter(); $db->close();
$total_ttc = $totalam = $total = 0; $expensereportstatic = new ExpenseReport($db); $userstatic = new User($db); while ($i < $num && $i < $max) { $obj = $db->fetch_object($result); $expensereportstatic->id = $obj->rowid; $expensereportstatic->ref = $obj->ref; $userstatic->id = $obj->uid; $userstatic->lastname = $obj->lastname; $userstatic->firstname = $obj->firstname; print '<tr ' . $bc[$var] . '>'; print '<td>' . $expensereportstatic->getNomUrl(1) . '</td>'; print '<td>' . $userstatic->getNomUrl(1) . '</td>'; print '<td align="right">' . price($obj->total_ttc) . '</td>'; print '<td align="right">' . dol_print_date($db->jdate($obj->dm), 'day') . '</td>'; print '<td>' . $expensereportstatic->LibStatut($obj->status, 3) . '</td>'; print '</tr>'; $var = !$var; $i++; } } else { print '<tr ' . $bc[$var] . '><td colspan="5">' . $langs->trans("None") . '</td></tr>'; } print '</table><br>'; } else { dol_print_error($db); } } print '</div></div></div>'; llxFooter(); $db->close();