X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=purchasing%2Fincludes%2Fdb%2Fsupp_trans_db.inc;h=991fe7ddbbde383f8b58e10af502e2b3990e4f3c;hb=827b3428d4c8c473cb637ac9df6621f4a0ba6f9a;hp=bf5e539f747f8c66c92e86e8d0a66196c0f71516;hpb=45e45a854c40a7a2f9cc8f11e07a259c6923babd;p=fa-stable.git diff --git a/purchasing/includes/db/supp_trans_db.inc b/purchasing/includes/db/supp_trans_db.inc index bf5e539f..991fe7dd 100644 --- a/purchasing/includes/db/supp_trans_db.inc +++ b/purchasing/includes/db/supp_trans_db.inc @@ -88,32 +88,6 @@ function get_supp_trans($trans_no, $trans_type=-1) //---------------------------------------------------------------------------------------- -function get_supplier_transactions($extra_fields=null, $extra_conditions=null, $extra_tables=null) -{ - $sql = "SELECT ".TB_PREF."supp_trans.*, - ov_amount+ov_gst+ov_discount AS Total, - ".TB_PREF."suppliers.supp_name, ".TB_PREF."suppliers.address, - ".TB_PREF."suppliers.curr_code "; - - if ($extra_fields) - $sql .= ", $extra_fields "; - - $sql .= " FROM ".TB_PREF."supp_trans, ".TB_PREF."suppliers "; - if ($extra_tables) - $sql .= " ,$extra_tables "; - - $sql .= " WHERE ".TB_PREF."supp_trans.supplier_id=".TB_PREF."suppliers.supplier_id"; - - if ($extra_conditions) - $sql .= " AND $extra_conditions "; - - $sql .= " ORDER BY trans_no"; - - return db_query($sql, "Cannot retreive supplier transactions"); -} - -//---------------------------------------------------------------------------------------- - function exists_supp_trans($type, $type_no) { if ($type == 25)