projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
5283682
)
DataObjects/Core_group.php
author
benny
<benny@roojs.com>
Thu, 26 Jul 2018 08:23:52 +0000
(16:23 +0800)
committer
benny
<benny@roojs.com>
Thu, 26 Jul 2018 08:23:52 +0000
(16:23 +0800)
DataObjects/Core_group.php
patch
|
blob
|
history
diff --git
a/DataObjects/Core_group.php
b/DataObjects/Core_group.php
index
2dd5d54
..
7b2ccbe
100644
(file)
--- a/
DataObjects/Core_group.php
+++ b/
DataObjects/Core_group.php
@@
-61,12
+61,17
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
$this->selectAdd("
(
$this->selectAdd("
(
- SELECT
- count(user_id)
- FROM
- core_group_member
-
- AS group_member_count
+ SELECT
+ COUNT(core_group_member.user_id)
+ FROM
+ core_group_member
+ LEFT JOIN
+ core_person
+ ON
+ core_person.id = core_group_member.user_id
+ WHERE
+ core_person.active = 1
+ ) AS group_member_count
");
/*WHERE
{$this->tableName()}.id = core_group_member.group_id
");
/*WHERE
{$this->tableName()}.id = core_group_member.group_id
@@
-76,9
+81,9
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
core_person.active = 1
)*/
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");
+
//
$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);