inventory/includes/db/items_category_db.inc

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 function add_item_category($description, $tax_type_id, $sales_account,
  13         $cogs_account, $inventory_account, $adjustment_account, $wip_account,
  14         $units, $mb_flag, $dim1, $dim2, $no_sale, $no_purchase)
  15 {
  16         $sql = "INSERT INTO ".TB_PREF."stock_category (description, dflt_tax_type,
  17                         dflt_units, dflt_mb_flag, dflt_sales_act, dflt_cogs_act,
  18                         dflt_inventory_act, dflt_adjustment_act, dflt_wip_act,
  19                         dflt_dim1, dflt_dim2, dflt_no_sale, dflt_no_purchase)
  20                 VALUES ("
  21                 .db_escape($description).","
  22                 .db_escape($tax_type_id).","
  23                 .db_escape($units).","
  24                 .db_escape($mb_flag).","
  25                 .db_escape($sales_account).","
  26                 .db_escape($cogs_account).","
  27                 .db_escape($inventory_account).","
  28                 .db_escape($adjustment_account).","
  29                 .db_escape($wip_account).","
  30                 .db_escape($dim1).","
  31                 .db_escape($dim2).","
  32                 .db_escape($no_sale).","
  33                 .db_escape($no_purchase).")";
  34
  35         db_query($sql,"an item category could not be added");
  36 }
  37
  38 function update_item_category($id, $description, $tax_type_id,
  39         $sales_account, $cogs_account, $inventory_account, $adjustment_account,
  40         $wip_account, $units, $mb_flag, $dim1, $dim2, $no_sale, $no_purchase)
  41
  42 {
  43         $sql = "UPDATE ".TB_PREF."stock_category SET "
  44                 ."description = ".db_escape($description).","
  45                 ."dflt_tax_type = ".db_escape($tax_type_id).","
  46                 ."dflt_units = ".db_escape($units).","
  47                 ."dflt_mb_flag = ".db_escape($mb_flag).","
  48                 ."dflt_sales_act = ".db_escape($sales_account).","
  49                 ."dflt_cogs_act = ".db_escape($cogs_account).","
  50                 ."dflt_inventory_act = ".db_escape($inventory_account).","
  51                 ."dflt_adjustment_act = ".db_escape($adjustment_account).","
  52                 ."dflt_wip_act = ".db_escape($wip_account).","
  53                 ."dflt_dim1 = ".db_escape($dim1).","
  54                 ."dflt_dim2 = ".db_escape($dim2).","
  55                 ."dflt_no_sale = ".db_escape($no_sale).","
  56                 ."dflt_no_purchase = ".db_escape($no_purchase)
  57         ."WHERE category_id = ".db_escape($id);
  58
  59         db_query($sql,"an item category could not be updated");
  60 }
  61
  62 function delete_item_category($id)
  63 {
  64         $sql="DELETE FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);
  65
  66         db_query($sql,"an item category could not be deleted");
  67 }
  68
  69 function get_item_categories($show_inactive, $fixed_asset=false)
  70 {
  71         $sql = "SELECT c.*, t.name as tax_name FROM ".TB_PREF."stock_category c, "
  72                 .TB_PREF."item_tax_types t WHERE c.dflt_tax_type=t.id";
  73         if (!$show_inactive)
  74                 $sql .= " AND !c.inactive";
  75         if ($fixed_asset)
  76                 $sql .= " AND c.dflt_mb_flag='F'";
  77         else
  78                 $sql .= " AND c.dflt_mb_flag!='F'";
  79
  80         $sql .= " ORDER by description";
  81
  82         return db_query($sql, "could not get stock categories");
  83 }
  84
  85 function get_item_category($id)
  86 {
  87         $sql="SELECT * FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);
  88
  89         $result = db_query($sql,"an item category could not be retrieved");
  90
  91         return db_fetch($result);
  92 }
  93
  94 function get_category_name($id)
  95 {
  96         $sql = "SELECT description FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);
  97
  98         $result = db_query($sql, "could not get sales type");
  99
 100         $row = db_fetch_row($result);
 101         return is_array($row) ? $row[0] : false;
 102 }
 103