X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Fpo_db.inc;h=dac2ed5e211506560c03145cf4c2045b00b07dd4;hb=3b06c6c4718610a408cae2e9b76c3134ca30b84c;hp=b33a2fa00b1556914d5f87b065a3a864a3d6b7d6;hpb=1b9351ae81a67726e757eba55895a4f059c7f128;p=fa-stable.git

diff --git a/purchasing/includes/db/po_db.inc b/purchasing/includes/db/po_db.inc
index b33a2fa0..dac2ed5e 100644
--- a/purchasing/includes/db/po_db.inc
+++ b/purchasing/includes/db/po_db.inc
@@ -9,6 +9,38 @@
     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
+// ------------------------------------------------------------------------------
+
+function get_supplier_details_to_order(&$order, $supplier_id)
+{
+	$sql = "SELECT curr_code, supp_name, tax_group_id, supp.tax_included, supp.tax_algorithm,
+			supp.credit_limit - Sum(IFNULL(IF(trans.type=".ST_SUPPCREDIT.", -1, 1) 
+				* (ov_amount + ov_gst + ov_discount),0)) as cur_credit,
+				terms.terms, terms.days_before_due, terms.day_in_following_month
+		FROM ".TB_PREF."suppliers supp
+			 LEFT JOIN ".TB_PREF."supp_trans trans ON supp.supplier_id = trans.supplier_id
+			 LEFT JOIN ".TB_PREF."payment_terms terms ON supp.payment_terms=terms.terms_indicator
+		WHERE supp.supplier_id = ".db_escape($supplier_id)."
+		GROUP BY
+			  supp.supp_name";
+
+	$result = db_query($sql, "The supplier details could not be retreived");
+	$myrow = db_fetch($result);
+
+	$order->credit = $myrow["cur_credit"];
+	$order->terms = array( 
+		'description' => $myrow['terms'],
+		'days_before_due' => $myrow['days_before_due'], 
+		'day_in_following_month' => $myrow['day_in_following_month'] );
+
+	$_POST['supplier_id'] = $supplier_id;
+	$_POST['supplier_name'] = $myrow["supp_name"];
+	$_POST['curr_code'] = $myrow["curr_code"];
+
+	$order->set_supplier($supplier_id, $myrow["supp_name"], $myrow["curr_code"], 
+		$myrow["tax_group_id"], $myrow["tax_included"], $myrow["tax_algorithm"]);
+}
+
 //----------------------------------------------------------------------------------------
 
 function delete_po($po)