// $date_ is display date (non-sql)
function add_bank_trans($type, $trans_no, $bank_act, $ref, $date_,
- $amount, $person_type_id, $person_id, $currency="", $err_msg="", $rate=0)
+ $amount, $person_type_id, $person_id, $currency="", $rate=0)
{
$sqlDate = date2sql($date_);
".db_escape($amount_bank).", ".db_escape($person_type_id)
.", ". db_escape($person_id).")";
- if ($err_msg == "")
- $err_msg = "The bank transaction could not be inserted";
-
- db_query($sql, $err_msg);
+ db_query($sql, "The bank transaction could not be inserted");
}
//----------------------------------------------------------------------------------------
{
if (!$nested)
- begin_transaction();
+ begin_transaction(__FUNCTION__, func_get_args());
$sql = "UPDATE ".TB_PREF."bank_trans
SET amount=0
return true;
}
+function update_reconcile_date($type, $trans_no, $date=NULL)
+{
+ $sql = "UPDATE ".TB_PREF."bank_trans SET reconciled=".($date ? "'".date2sql($date)."'" : 'NULL')
+ ." WHERE type=" . db_escape($type). " AND trans_no=".db_escape($trans_no);
+
+ db_query($sql, "Can't change reconciliation status");
+}