projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
b3eee33
)
DataObjects/Core_group.php
author
benny
<benny@roojs.com>
Thu, 26 Jul 2018 04:23:49 +0000
(12:23 +0800)
committer
benny
<benny@roojs.com>
Thu, 26 Jul 2018 04:23:49 +0000
(12:23 +0800)
DataObjects/Core_group.php
patch
|
blob
|
history
diff --git
a/DataObjects/Core_group.php
b/DataObjects/Core_group.php
index
595d44e
..
9ac4757
100644
(file)
--- a/
DataObjects/Core_group.php
+++ b/
DataObjects/Core_group.php
@@
-55,7
+55,7
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
}
$cgm = DB_DataObject::Factory('core_group_member')->tableName();;
}
$cgm = DB_DataObject::Factory('core_group_member')->tableName();;
- $this->selectAdd("
+
/*
$this->selectAdd("
(
SELECT
count(user_id)
(
SELECT
count(user_id)
@@
-65,7
+65,30
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
{$this->tableName()}.id = {$cgm}.group_id
)
AS group_member_count
{$this->tableName()}.id = {$cgm}.group_id
)
AS group_member_count
+ ");*/
+ $this->selectAdd("
+ (
+ SELECT
+ count(user_id)
+ FROM
+ {$cgm}
+ LEFT JOIN
+ core_group_member
+ ON
+ core_group.id = core_group_member.group_id
+ Left JOIN
+ core_person
+ ON
+ core_user_id = core_person.id
+ WHERE
+ {$this->tableName()}.id = {$cgm}.group_id
+ AND
+ core_person.active = 1
+
+ )
+ AS group_member_count
");
");
+
}
function toEventString() {
}
function toEventString() {