projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (from parent 1:
146ee34
)
DataObjects/Core_group.php
author
benny
<benny@roojs.com>
Thu, 26 Jul 2018 07:26:40 +0000
(15:26 +0800)
committer
benny
<benny@roojs.com>
Thu, 26 Jul 2018 07:26:40 +0000
(15:26 +0800)
DataObjects/Core_group.php
patch
|
blob
|
history
diff --git
a/DataObjects/Core_group.php
b/DataObjects/Core_group.php
index
2d62fb8
..
23f8865
100644
(file)
--- a/
DataObjects/Core_group.php
+++ b/
DataObjects/Core_group.php
@@
-54,13
+54,16
@@
class Pman_Core_DataObjects_Core_group extends DB_DataObject
}
}
}
}
- $cgm = DB_DataObject::Factory('core_group_member')->tableName();
-
/*
$cgmDBObj = DB_DataObject::Factory('core_group_member');
+
+ $cgmDBObj = DB_DataObject::Factory('core_group_member');
$cpObj = DB_DataObject::Factory('core_person');
$cgm = DB_DataObject::Factory('core_group_member')->tableName();
$cpObj = DB_DataObject::Factory('core_person');
$cgm = DB_DataObject::Factory('core_group_member')->tableName();
- $cpObj->active = 1; // set the where condition with active = 1*/
- DB_DataObject::debugLevel(1);
- $this->selectAdd("
+ $cpObj->active = 1; // set the where condition with active = 1
+
+ $core_group->joinAdd($cgmDBObj, array('joinType' => 'LEFT', 'useWhereAsOn' => false));
+ $core_group->joinAdd($cpObj, array('joinType' => 'LEFT', 'useWhereAsOn' => true));
+ $core_group->find();
+ /*$this->selectAdd("
(
SELECT
count(user_id)
(
SELECT
count(user_id)
@@
-70,8
+73,8
@@
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
- ");
- DB_DataObject::debugLevel();
+ ");
*/
+
/*$cgmDBObj->joinAdd($cpObj);
$this->joinAdd($cgmDBObj);
/*$cgmDBObj->joinAdd($cpObj);
$this->joinAdd($cgmDBObj);