projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Changed balance_sheet field in account class to ctype and fixed class editing.
[fa-stable.git]
/
gl
/
includes
/
db
/
gl_db_trans.inc
diff --git
a/gl/includes/db/gl_db_trans.inc
b/gl/includes/db/gl_db_trans.inc
index d80dfe4789c1b627386a55041678fce79732f223..5b559d33987a094334242f3620f30f066c3c45a3 100644
(file)
--- a/
gl/includes/db/gl_db_trans.inc
+++ b/
gl/includes/db/gl_db_trans.inc
@@
-215,7
+215,7
@@
function get_balance($account, $dimension, $dimension2, $from, $to, $from_incl=t
if ($from_incl)
$sql .= " tran_date >= '$from_date' AND";
else
if ($from_incl)
$sql .= " tran_date >= '$from_date' AND";
else
- $sql .= " tran_date > IF(
balance_sheet>0 AND balance_sheet
<".CL_INCOME.", '0000-00-00', '$from_date') AND";
+ $sql .= " tran_date > IF(
ctype>0 AND ctype
<".CL_INCOME.", '0000-00-00', '$from_date') AND";
$to_date = date2sql($to);
if ($to_incl)
$sql .= " tran_date <= '$to_date' ";
$to_date = date2sql($to);
if ($to_incl)
$sql .= " tran_date <= '$to_date' ";