projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
More bugs related to debtor_trans changes (positive amounts)
[fa-stable.git]
/
sales
/
includes
/
db
/
sales_types_db.inc
diff --git
a/sales/includes/db/sales_types_db.inc
b/sales/includes/db/sales_types_db.inc
index 96acf4fb6861165b378ce86a982d2999ea3838e6..4bde37506bf08cc65b12fe54ff816b6fa8da8ec2 100644
(file)
--- a/
sales/includes/db/sales_types_db.inc
+++ b/
sales/includes/db/sales_types_db.inc
@@
-1,15
+1,20
@@
<?php
<?php
-function add_sales_type($name)
+function add_sales_type($name
, $tax_included, $factor
)
{
{
- $sql = "INSERT INTO ".TB_PREF."sales_types (sales_type) VALUES ('$name')";
+ // maximum one base price list
+ clear_base_sales_type();
+
+ $sql = "INSERT INTO ".TB_PREF."sales_types (sales_type,tax_included,factor) VALUES (".db_escape($name).",'$tax_included',$factor)";
db_query($sql, "could not add sales type");
}
db_query($sql, "could not add sales type");
}
-function update_sales_type($id, $name)
+function update_sales_type($id, $name
, $tax_included, $factor
)
{
{
- $sql = "UPDATE ".TB_PREF."sales_types SET sales_type = '$name' WHERE id = $id";
+
+ $sql = "UPDATE ".TB_PREF."sales_types SET sales_type = ".db_escape($name).",
+ tax_included =$tax_included, factor=$factor WHERE id = $id";
db_query($sql, "could not update sales type");
}
db_query($sql, "could not update sales type");
}