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, $vat_category)
  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, vat_category)
  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                 .db_escape($vat_category).")";
  35
  36         db_query($sql,"an item category could not be added");
  37 }
  38
  39 function update_item_category($id, $description, $tax_type_id,
  40         $sales_account, $cogs_account, $inventory_account, $adjustment_account,
  41         $wip_account, $units, $mb_flag, $dim1, $dim2, $no_sale, $no_purchase, $vat_category)
  42
  43 {
  44         $sql = "UPDATE ".TB_PREF."stock_category SET "
  45                 ."description = ".db_escape($description).","
  46                 ."dflt_tax_type = ".db_escape($tax_type_id).","
  47                 ."dflt_units = ".db_escape($units).","
  48                 ."dflt_mb_flag = ".db_escape($mb_flag).","
  49                 ."dflt_sales_act = ".db_escape($sales_account).","
  50                 ."dflt_cogs_act = ".db_escape($cogs_account).","
  51                 ."dflt_inventory_act = ".db_escape($inventory_account).","
  52                 ."dflt_adjustment_act = ".db_escape($adjustment_account).","
  53                 ."dflt_wip_act = ".db_escape($wip_account).","
  54                 ."dflt_dim1 = ".db_escape($dim1).","
  55                 ."dflt_dim2 = ".db_escape($dim2).","
  56                 ."dflt_no_sale = ".db_escape($no_sale).","
  57                 ."dflt_no_purchase = ".db_escape($no_purchase).","
  58                 ."vat_category = ".db_escape($vat_category)
  59         ."WHERE category_id = ".db_escape($id);
  60
  61         db_query($sql,"an item category could not be updated");
  62 }
  63
  64 function delete_item_category($id)
  65 {
  66         $sql="DELETE FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);
  67
  68         db_query($sql,"an item category could not be deleted");
  69 }
  70
  71 function get_item_categories($show_inactive, $fixed_asset=false)
  72 {
  73         $sql = "SELECT c.*, t.name as tax_name FROM ".TB_PREF."stock_category c, "
  74                 .TB_PREF."item_tax_types t WHERE c.dflt_tax_type=t.id";
  75         if (!$show_inactive)
  76                 $sql .= " AND !c.inactive";
  77         if ($fixed_asset)
  78                 $sql .= " AND c.dflt_mb_flag='F'";
  79         else
  80                 $sql .= " AND c.dflt_mb_flag!='F'";
  81
  82         $sql .= " ORDER by description";
  83
  84         return db_query($sql, "could not get stock categories");
  85 }
  86
  87 function get_item_category($id)
  88 {
  89         $sql="SELECT * FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);
  90
  91         $result = db_query($sql,"an item category could not be retrieved");
  92
  93         return db_fetch($result);
  94 }
  95
  96 function get_category_name($id)
  97 {
  98         $sql = "SELECT description FROM ".TB_PREF."stock_category WHERE category_id=".db_escape($id);
  99
 100         $result = db_query($sql, "could not get sales type");
 101
 102         $row = db_fetch_row($result);
 103         return $row[0];
 104 }
 105