Ejemplo n.º 1
0
 $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">&nbsp;</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;
Ejemplo n.º 2
0
            // 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 ' &nbsp; &nbsp; ';
            print '<input type="submit" class="button" name="cancel" value="'.$langs->trans('Cancel').'">';

            print '</td></tr>';
            print '</table>';
            print '</form>';

            print '</table>';
        }
        else
        {
            /*
             *	View card