X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Finvoice_items_db.inc;h=0d69d8682661475b252a53896cc237a8fe5e0dcf;hb=d567a10b7925c8bb97c734e213d6651a979af29d;hp=621309bb0464dcb21bd2d1171c008d3e784fc53e;hpb=231b2de9031a927156a58998fdb5601447732b38;p=fa-stable.git diff --git a/purchasing/includes/db/invoice_items_db.inc b/purchasing/includes/db/invoice_items_db.inc index 621309bb..0d69d868 100644 --- a/purchasing/includes/db/invoice_items_db.inc +++ b/purchasing/includes/db/invoice_items_db.inc @@ -1,5 +1,14 @@ . +***********************************************************************/ //------------------------------------------------------------------------------------------------------------- function add_supp_invoice_item($supp_trans_type, $supp_trans_no, $stock_id, $description, @@ -48,39 +57,4 @@ function void_supp_invoice_items($type, $type_no) db_query($sql, "could not void supptrans details"); } -//---------------------------------------------------------------------------------------- - -function add_supp_invoice_tax_item($supp_trans_type, $supp_trans_no, $tax_type_id, - $rate, $included_in_price, $amount) -{ - $sql = "INSERT INTO ".TB_PREF."supp_invoice_tax_items (supp_trans_type, supp_trans_no, tax_type_id, rate, included_in_price, amount) - VALUES ($supp_trans_type, $supp_trans_no, $tax_type_id, $rate, $included_in_price, $amount)"; - - db_query($sql, "The supplier transaction tax detail could not be added"); -} - -//---------------------------------------------------------------------------------------- - -function get_supp_invoice_tax_items($supp_trans_type, $supp_trans_no) -{ - $sql = "SELECT ".TB_PREF."supp_invoice_tax_items.*, ".TB_PREF."tax_types.name AS tax_type_name - FROM ".TB_PREF."supp_invoice_tax_items,".TB_PREF."tax_types - WHERE supp_trans_type = $supp_trans_type - AND supp_trans_no = $supp_trans_no - AND ".TB_PREF."tax_types.id = ".TB_PREF."supp_invoice_tax_items.tax_type_id"; - - return db_query($sql, "The supplier transaction tax details could not be queried"); -} - -//---------------------------------------------------------------------------------------- - -function void_supp_invoice_tax_items($type, $type_no) -{ - $sql = "UPDATE ".TB_PREF."supp_invoice_tax_items SET amount=0 - WHERE supp_trans_type = $type - AND supp_trans_no=$type_no"; - - db_query($sql, "The supplier transaction tax details could not be voided"); -} - ?> \ No newline at end of file