Payment terms related functions moved to separate file, common function for calculati...

[fa-stable.git] / admin / db / payment_terms_db.inc

diff --git a/admin/db/payment_terms_db.inc b/admin/db/payment_terms_db.inc
new file mode 100644 (file)
index 0000000..3934622
--- /dev/null
+++ b/admin/db/payment_terms_db.inc
@@ -0,0 +1,91 @@
+<?php
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+       Released under the terms of the GNU General Public License, GPL, 
+       as published by the Free Software Foundation, either version 3 
+       of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
+
+function add_payment_terms($terms, $type, $days=0, $early_discount=0, $early_days=0)
+{
+       begin_transaction(__FUNCTION__, func_get_args());
+
+       $sql = "INSERT INTO ".TB_PREF."payment_terms (terms, type, days, early_discount, early_days)
+               VALUES (" .db_escape($terms) . "," . db_escape($type) . ", ".db_escape($days). ", ".db_escape($early_discount). ", ".db_escape($early_days).")";
+
+       db_query($sql,"The payment term could not be added");
+
+       commit_transaction();
+}
+
+function update_payment_terms($selected_id, $terms, $type, $days=0, $early_discount=0, $early_days=0)
+{
+       begin_transaction(__FUNCTION__, func_get_args());
+
+       $sql = "UPDATE ".TB_PREF."payment_terms SET terms=" . db_escape($terms) . ",
+               type=".db_escape($type).",
+               days=" . db_escape($days).",
+               early_discount=".db_escape($early_discount).",
+               early_days=".db_escape($early_days).
+               " WHERE id = " .db_escape($selected_id);
+
+       db_query($sql,"The payment term could not be updated");
+
+       commit_transaction();
+}
+
+function delete_payment_terms($selected_id)
+{
+       begin_transaction(__FUNCTION__, func_get_args());
+
+       $sql="DELETE FROM ".TB_PREF."payment_terms WHERE id=".db_escape($selected_id);
+       db_query($sql,"could not delete a payment terms");
+
+       commit_transaction();
+}
+
+function get_payment_terms($selected_id)
+{
+       $sql = "SELECT * FROM ".TB_PREF."payment_terms t WHERE id=".db_escape($selected_id);
+
+       $result = db_query($sql,"could not get payment term");
+
+       return db_fetch($result);
+}
+
+function get_payment_terms_all($show_inactive)
+{
+       $sql = "SELECT * FROM ".TB_PREF."payment_terms";
+       if (!$show_inactive) $sql .= " WHERE !inactive";
+       return db_query($sql,"could not get payment terms");
+}
+
+/*
+       Calculate due date using terms data provided either as table of payment data or payment terms id
+*/
+function get_payment_due_date($terms_data, $date)
+{
+       if (!is_array($terms_data))
+               $terms_data = get_payment_terms($terms_data);
+
+       if (!is_date($date))
+               $date = new_doc_date();
+       
+       if (!$terms_data)
+               return $date;
+
+       if ($terms_data['type'] == PTT_FOLLOWING) {
+               $end = end_month(add_months(begin_month($date), 1));
+               $duedate = add_days(end_month($date), $terms_data['days']);
+               if (date1_greater_date2($duedate, $end))
+                       $duedate = $end;
+       } elseif ($terms_data['type'] == PTT_DAYS)
+               $duedate = add_days($date, $terms_data['days']);
+       else
+               $duedate = $date;
+       return $duedate;
+}