From 1e75eb8d3ca9a590e16b5ca168a662998486cdfe Mon Sep 17 00:00:00 2001
From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Thu, 3 Dec 2009 23:20:08 +0000
Subject: [PATCH] New file

---
 inventory/includes/db/items_purchases_db.inc | 69 ++++++++++++++++++++
 1 file changed, 69 insertions(+)
 create mode 100644 inventory/includes/db/items_purchases_db.inc

diff --git a/inventory/includes/db/items_purchases_db.inc b/inventory/includes/db/items_purchases_db.inc
new file mode 100644
index 00000000..dccdc511
--- /dev/null
+++ b/inventory/includes/db/items_purchases_db.inc
@@ -0,0 +1,69 @@
+<?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_item_purchasing_data($supplier_id, $stock_id, $price,
+	$suppliers_uom, $conversion_factor, $supplier_description)
+{
+	$sql = "INSERT INTO ".TB_PREF."purch_data (supplier_id, stock_id, price, suppliers_uom,
+		conversion_factor, supplier_description) VALUES (";
+	$sql .= db_escape($supplier_id).", ".db_escape($stock_id). ", "
+		.$price . ", ".db_escape($suppliers_uom ). ", "
+		.$conversion_factor . ", "
+		.db_escape($supplier_description) . ")";
+
+	db_query($sql,"The supplier purchasing details could not be added");
+}
+
+function update_item_purchasing_data($selected_id, $stock_id, $price,
+	$suppliers_uom, $conversion_factor, $supplier_description)
+{
+	$sql = "UPDATE ".TB_PREF."purch_data SET price=" . $price . ",
+		suppliers_uom=".db_escape($suppliers_uom) . ",
+		conversion_factor=" . $conversion_factor . ",
+		supplier_description=" . db_escape($supplier_description) . "
+		WHERE stock_id=".db_escape($stock_id) . " AND
+		supplier_id=".db_escape($selected_id);
+	db_query($sql,"The supplier purchasing details could not be updated");
+}
+
+function delete_item_purchasing_data($selected_id, $stock_id)
+{
+	$sql = "DELETE FROM ".TB_PREF."purch_data WHERE supplier_id=".db_escape($selected_id)."
+		AND stock_id=".db_escape($stock_id);
+	db_query($sql,"could not delete purchasing data");
+}
+
+function get_items_purchasing_data($stock_id)
+{
+    $sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name,"
+    	.TB_PREF."suppliers.curr_code
+		FROM ".TB_PREF."purch_data INNER JOIN ".TB_PREF."suppliers
+		ON ".TB_PREF."purch_data.supplier_id=".TB_PREF."suppliers.supplier_id
+		WHERE stock_id = ".db_escape($stock_id);
+
+    return db_query($sql, "The supplier purchasing details for the selected part could not be retrieved");
+}
+
+function get_item_purchasing_data($selected_id, $stock_id)
+{
+	$sql = "SELECT ".TB_PREF."purch_data.*,".TB_PREF."suppliers.supp_name FROM ".TB_PREF."purch_data
+		INNER JOIN ".TB_PREF."suppliers ON ".TB_PREF."purch_data.supplier_id=".TB_PREF."suppliers.supplier_id
+		WHERE ".TB_PREF."purch_data.supplier_id=".db_escape($selected_id)."
+		AND ".TB_PREF."purch_data.stock_id=".db_escape($stock_id);
+
+	$result = db_query($sql, "The supplier purchasing details for the selected supplier and item could not be retrieved");
+
+	return db_fetch($result);
+}
+
+
+?>
\ No newline at end of file
-- 
2.30.2