$solde = 0; // Boucle sur chaque facture for ($i = 0; $i < $num; $i++) { $objf = $db->fetch_object($resql); $fac = new FactureFournisseur($db); $ret = $fac->fetch($objf->facid); if ($ret < 0) { print $fac->error . "<br>"; continue; } $totalpaye = $fac->getSommePaiement(); $var = !$var; print "<tr {$bc[$var]}>"; print "<td align=\"center\">" . dol_print_date($fac->date) . "</td>\n"; print "<td><a href=\"facture/fiche.php?facid={$fac->id}\">" . img_object($langs->trans("ShowBill"), "bill") . " " . $fac->ref . "</a></td>\n"; print '<td aling="left">' . $fac->getLibStatut(2, $totalpaye) . '</td>'; print '<td align="right">' . price($fac->total_ttc) . "</td>\n"; $solde = $solde + $fac->total_ttc; print '<td align="right"> </td>'; print '<td align="right">' . price($solde) . "</td>\n"; // Author print '<td nowrap="nowrap" width="50"><a href="' . DOL_URL_ROOT . '/user/fiche.php?id=' . $objf->userid . '">' . img_object($langs->trans("ShowUser"), 'user') . ' ' . $objf->login . '</a></td>'; print "</tr>\n"; // Payments $sql = "SELECT p.rowid, p.datep as dp, pf.amount, p.statut,"; $sql .= " p.fk_user_author, u.login, u.rowid as userid"; $sql .= " FROM " . MAIN_DB_PREFIX . "paiementfourn_facturefourn as pf,"; $sql .= " " . MAIN_DB_PREFIX . "paiementfourn as p"; $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "user as u ON p.fk_user_author = u.rowid"; $sql .= " WHERE pf.fk_paiementfourn = p.rowid"; $sql .= " AND pf.fk_facturefourn = " . $fac->id;
// Date invoice print '<tr><td class="fieldrequired">'.$langs->trans('DateInvoice').'</td><td nowrap="nowrap">'; $html->select_date($fac->datep,'','','','',"update",1,1); print '</td></tr>'; // Due date print '<tr><td>'.$langs->trans('DateEcheance').'</td><td nowrap="nowrap">'; $html->select_date($fac->date_echeance,'ech','','','',"update",1,1); if (($fac->paye == 0) && ($fac->statut > 0) && $fac->date_echeance < ($now - $conf->facture->fournisseur->warning_delay)) print img_picto($langs->trans("Late"),"warning"); print '</td></tr>'; print '<tr><td>'.$langs->trans('AmountHT').'</td><td nowrap="nowrap"><b>'.price($fac->total_ht).'</b></td></tr>'; print '<tr><td>'.$langs->trans('AmountVAT').'</td><td nowrap="nowrap">'.price($fac->total_tva).'</td></tr>'; print '<tr><td>'.$langs->trans('AmountTTC').'</td><td nowrap="nowrap">'.price($fac->total_ttc).'</td></tr>'; print '<tr><td>'.$langs->trans('Status').'</td><td>'.$fac->getLibStatut(4).'</td></tr>'; print '<tr><td colspan="2" align="center">'; print '<input type="submit" class="button" name="save" value="'.$langs->trans('Save').'">'; print ' '; print '<input type="submit" class="button" name="cancel" value="'.$langs->trans('Cancel').'">'; print '</td></tr>'; print '</table>'; print '</form>'; print '</table>'; } else { /* * View card