New files from unstable branch

[fa-stable.git] / inventory / includes / db / items_category_db.inc

diff --git a/inventory/includes/db/items_category_db.inc b/inventory/includes/db/items_category_db.inc
index 11f9486ddc3b7a2f3ef41bde988a0c1b1c500243..27a4ed6bf600da29132de2c44bf21cdf7a2dc566 100644 (file)
--- a/inventory/includes/db/items_category_db.inc
+++ b/inventory/includes/db/items_category_db.inc
@@ -64,6 +64,15 @@ function delete_item_category($id)
        db_query($sql,"an item category could not be deleted");
 }
 
+function get_item_categories($show_inactive)
+{
+       $sql = "SELECT c.*, t.name as tax_name FROM ".TB_PREF."stock_category c, "
+               .TB_PREF."item_tax_types t WHERE c.dflt_tax_type=t.id";
+       if (!$show_inactive) $sql .= " AND !c.inactive";
+
+       return db_query($sql, "could not get stock categories");
+}
+
 function get_item_category($id)
 {
        $sql="SELECT * FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);