projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merged stable branch up to 2.3.10
[fa-stable.git]
/
dimensions
/
includes
/
dimensions_db.inc
diff --git
a/dimensions/includes/dimensions_db.inc
b/dimensions/includes/dimensions_db.inc
index c048371042cad41d51c32a4b6ddb5cf1cdd063ee..3bd30f3c6642e46cef9c6d5ac3574c653f18b18a 100644
(file)
--- a/
dimensions/includes/dimensions_db.inc
+++ b/
dimensions/includes/dimensions_db.inc
@@
-172,8
+172,7
@@
function get_dimension_balance($id, $from, $to)
$id = db_escape($id);
$sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" .
date2sql($from) . "' AND
$id = db_escape($id);
$sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE tran_date >= '" .
date2sql($from) . "' AND
- tran_date <= '" . date2sql($to) . "' AND (dimension_id = " .
- db_escape($id)." OR dimension2_id = " .db_escape($id).")";
+ tran_date <= '" . date2sql($to) . "' AND (dimension_id = $id OR dimension2_id = $id)";
$res = db_query($sql, "Sum of transactions could not be calculated");
$row = db_fetch_row($res);
$res = db_query($sql, "Sum of transactions could not be calculated");
$row = db_fetch_row($res);