projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
a88603a
)
DataObjects/Core_group.php
author
benny
<benny@roojs.com>
Thu, 26 Jul 2018 04:35:43 +0000
(12:35 +0800)
committer
benny
<benny@roojs.com>
Thu, 26 Jul 2018 04:35:43 +0000
(12:35 +0800)
DataObjects/Core_group.php
patch
|
blob
|
history
diff --git
a/DataObjects/Core_group.php
b/DataObjects/Core_group.php
index
024cbed
..
d34ac9b
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,13
+65,9
@@
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}
+ ");
+
+ $this->_join .= "
LEFT JOIN
core_group_member
ON
LEFT JOIN
core_group_member
ON
@@
-80,14
+76,8
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
core_person
ON
core_user_id = core_person.id
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
- ");
+ ";
+
}
}