projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added Purchase Invice edition.
[fa-stable.git]
/
purchasing
/
includes
/
db
/
invoice_items_db.inc
diff --git
a/purchasing/includes/db/invoice_items_db.inc
b/purchasing/includes/db/invoice_items_db.inc
index efcdcb4bd323b1af4a737c2cbd2225ed10b176c2..d69531578f68061f100de7939838b2337f55a4d3 100644
(file)
--- a/
purchasing/includes/db/invoice_items_db.inc
+++ b/
purchasing/includes/db/invoice_items_db.inc
@@
-44,9
+44,12
@@
function add_supp_invoice_gl_item($supp_trans_type, $supp_trans_no, $gl_code, $a
function get_supp_invoice_items($supp_trans_type, $supp_trans_no)
{
function get_supp_invoice_items($supp_trans_type, $supp_trans_no)
{
- $sql = "SELECT *, unit_price AS FullUnitPrice FROM ".TB_PREF."supp_invoice_items
+ $sql = "SELECT *, unit_price AS FullUnitPrice FROM ".TB_PREF."supp_invoice_items inv,
+ ".TB_PREF."grn_items grn
WHERE supp_trans_type = ".db_escape($supp_trans_type)."
WHERE supp_trans_type = ".db_escape($supp_trans_type)."
- AND supp_trans_no = ".db_escape($supp_trans_no)." ORDER BY id";
+ AND supp_trans_no = ".db_escape($supp_trans_no)
+ ." AND grn.id =inv.grn_item_id"
+ ." ORDER BY inv.id";
return db_query($sql, "Cannot retreive supplier transaction detail records");
}
return db_query($sql, "Cannot retreive supplier transaction detail records");
}