//-------------------------------------------------------------------------------------------------------------
function add_supp_trans($type, $supplier_id, $date_, $due_date, $reference, $supp_reference,
- $amount, $amount_tax, $discount, $err_msg="")
+ $amount, $amount_tax, $discount, $err_msg="", $rate=0)
{
$date = date2sql($date_);
if ($due_date == "")
$trans_no = get_next_trans_no($type);
$curr = get_supplier_currency($supplier_id);
- $rate = get_exchange_rate_from_home_currency($curr, $date_);
+
+ if ($rate == 0)
+ $rate = get_exchange_rate_from_home_currency($curr, $date_);
$sql = "INSERT INTO ".TB_PREF."supp_trans (trans_no, type, supplier_id, tran_date, due_date,
//----------------------------------------------------------------------------------------
-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)