projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
2696d29
)
DataObjects/Core_group.php
author
Edward
<edward@roojs.com>
Tue, 18 Sep 2018 06:04:13 +0000
(14:04 +0800)
committer
Edward
<edward@roojs.com>
Tue, 18 Sep 2018 06:04:13 +0000
(14:04 +0800)
DataObjects/Core_group.php
patch
|
blob
|
history
diff --git
a/DataObjects/Core_group.php
b/DataObjects/Core_group.php
index
9932a4f
..
2a6de41
100644
(file)
--- a/
DataObjects/Core_group.php
+++ b/
DataObjects/Core_group.php
@@
-57,14
+57,16
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
if(!empty($q['_is_in_group'])){
$this->selectAdd("
- COALESCE(
- (SELECT id from core_group_member
+ COALESCE((
+ SELECT
+ COUNT(id)
+ FROM
+ core_group_member
WHERE
user_id = {$q['_is_in_group']}
AND
group_id = {$this->tableName()}.id
- LIMIT 1
- ),0) as group_membership_user_id
+ ), 0) AS is_in_group
");
}