projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
49f4ce8
)
DataObjects/Core_group.php
author
benny
<benny@roojs.com>
Thu, 26 Jul 2018 08:20:11 +0000
(16:20 +0800)
committer
benny
<benny@roojs.com>
Thu, 26 Jul 2018 08:20:11 +0000
(16:20 +0800)
DataObjects/Core_group.php
patch
|
blob
|
history
diff --git
a/DataObjects/Core_group.php
b/DataObjects/Core_group.php
index
a7feecd
..
2dd5d54
100644
(file)
--- a/
DataObjects/Core_group.php
+++ b/
DataObjects/Core_group.php
@@
-65,16
+65,20
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
count(user_id)
FROM
core_group_member
count(user_id)
FROM
core_group_member
- WHERE
- {$this->tableName()}.id = core_group_member.group_id
- AND
- core_group_member.user_id = core_person.id
-
- )
+
AS group_member_count
");
AS group_member_count
");
-
-
+ /*WHERE
+ {$this->tableName()}.id = core_group_member.group_id
+ AND
+ core_group_member.user_id = core_person.id
+ AND
+ core_person.active = 1
+ )*/
+
+ $this->whereAdd("{$this->tableName()}.id = core_group_member.group_id");
+ $this->whereAdd("core_group_member.user_id = core_person.id");
+ $this->whereAdd("core_person.active = 1");
/*$cgmDBObj->joinAdd($cpObj);
/*$cgmDBObj->joinAdd($cpObj);