Cleanup: various random sql queries found in UI files moved to database interface...

[fa-stable.git] / reporting / includes / doctext.inc

diff --git a/reporting/includes/doctext.inc b/reporting/includes/doctext.inc
index de3082a9e1eadd6dfe906313b37786ac1219ccad..be391fde7392bb3905c77ca602327c691b11f678 100644 (file)
--- a/reporting/includes/doctext.inc
+++ b/reporting/includes/doctext.inc
@@ -34,10 +34,7 @@
 
        if (!in_array($this->formData['doctype'], array(ST_STATEMENT, ST_WORKORDER)))
        {
-               $id = $this->formData['payment_terms'];
-               $sql = "SELECT terms, days_before_due FROM ".TB_PREF."payment_terms WHERE terms_indicator=".db_escape($id);
-               $result = db_query($sql,"could not get paymentterms");
-               $row = db_fetch($result);
+               $row = get_payment_terms($this->formData['payment_terms']);
                $Payment_Terms = _("Payment Terms") . ': ' . $row["terms"];
                if ($this->formData['doctype'] == ST_SALESINVOICE && $this->formData['prepaid'])
                        $this->formData['prepaid'] = ($row['days_before_due'] >= 0) ? 'final' : 'partial';