projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added a date column and combined the # and View column in 'View / Print Transactions.
[fa-stable.git]
/
dimensions
/
includes
/
dimensions_db.inc
diff --git
a/dimensions/includes/dimensions_db.inc
b/dimensions/includes/dimensions_db.inc
index 3335623dce8bdb2abcaafabf1ae0ca9e2eb4a5fc..54ece7c46dd0837d9412189d3cde1423dabff111 100644
(file)
--- a/
dimensions/includes/dimensions_db.inc
+++ b/
dimensions/includes/dimensions_db.inc
@@
-122,10
+122,11
@@
function dimension_has_deposits($id)
function dimension_has_payments($id)
{
function dimension_has_payments($id)
{
- $sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans WHERE dimension_id = ".db_escape($id);
+ $sql = "SELECT COUNT(*) FROM ".TB_PREF."gl_trans WHERE dimension_id = ".db_escape($id)
+ . " OR dimension2_id = ".db_escape($id);
$res = db_query($sql, "Transactions could not be calculated");
$row = db_fetch_row($res);
$res = db_query($sql, "Transactions could not be calculated");
$row = db_fetch_row($res);
- return ($row[0]
!= 0.
0);
+ return ($row[0]
>
0);
}
function dimension_is_closed($id)
}
function dimension_is_closed($id)