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, $assembly_account,
  14         $units, $mb_flag, $dim1, $dim2, $no_sale)
  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_assembly_act,
  19                         dflt_dim1, dflt_dim2, dflt_no_sale)
  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($assembly_account).","
  30                 .db_escape($dim1).","
  31                 .db_escape($dim2).","
  32                 .db_escape($no_sale).")";
  33
  34         db_query($sql,"an item category could not be added");
  35 }
  36
  37 function update_item_category($id, $description, $tax_type_id,
  38         $sales_account, $cogs_account, $inventory_account, $adjustment_account,
  39         $assembly_account, $units, $mb_flag, $dim1, $dim2, $no_sale)
  40
  41 {
  42         $sql = "UPDATE ".TB_PREF."stock_category SET "
  43                 ."description = ".db_escape($description).","
  44                 ."dflt_tax_type = ".db_escape($tax_type_id).","
  45                 ."dflt_units = ".db_escape($units).","
  46                 ."dflt_mb_flag = ".db_escape($mb_flag).","
  47                 ."dflt_sales_act = ".db_escape($sales_account).","
  48                 ."dflt_cogs_act = ".db_escape($cogs_account).","
  49                 ."dflt_inventory_act = ".db_escape($inventory_account).","
  50                 ."dflt_adjustment_act = ".db_escape($adjustment_account).","
  51                 ."dflt_assembly_act = ".db_escape($assembly_account).","
  52                 ."dflt_dim1 = ".db_escape($dim1).","
  53                 ."dflt_dim2 = ".db_escape($dim2).","
  54                 ."dflt_no_sale = '$no_sale'"
  55         ." WHERE category_id = '$id'";
  56
  57         db_query($sql,"an item category could not be updated");
  58 }
  59
  60 function delete_item_category($id)
  61 {
  62         $sql="DELETE FROM ".TB_PREF."stock_category WHERE category_id='$id'";
  63
  64         db_query($sql,"an item category could not be deleted");
  65 }
  66
  67 function get_item_category($id)
  68 {
  69         $sql="SELECT * FROM ".TB_PREF."stock_category WHERE category_id='$id'";
  70
  71         $result = db_query($sql,"an item category could not be retrieved");
  72
  73         return db_fetch($result);
  74 }
  75
  76 function get_category_name($id)
  77 {
  78         $sql = "SELECT description FROM ".TB_PREF."stock_category WHERE category_id=$id";
  79
  80         $result = db_query($sql, "could not get sales type");
  81
  82         $row = db_fetch_row($result);
  83         return $row[0];
  84 }
  85
  86 ?>