$tn.subject LIKE '%{$this->escape($q['search']['nameortitle'])}%'
");
}
-
+ $cgm = DB_DataObject::Factory('core_group_member')->tableName();;
+
$this->selectAdd("
(
SELECT
count(user_id)
FROM
- core_group_member
+ {$cgm}
WHERE
- to_group_id = core_group_member.group_id
+ to_group_id = {$cgm}.group_id
)
- AS group_member_count
+ AS group_member_count,
+
+ (
+ SELECT
+ count(user_id)
+ FROM
+ {$cgm}
+ WHERE
+ bcc_group = {$cgm}.group_id
+ )
+ AS bcc_group_member_count
");
}
$c = DB_DataObject::factory('core_group_member');
$c->whereAdd("group_id = {$this->to_group}");
- if (!$c->find(true)) {
- if (empty($request['_ignore_group_count'])) {
- $roo->jerr('not found');
- }
-
- if (!$request['_ignore_group_count']) {
- $roo->jerr('not found');
- }
- }
+ if (!$c->count()) {
+ if (!empty($request['_ignore_group_count'])) {
+ if (!$request['_ignore_group_count']) {
+ $roo->jerr('no_member',array('errcode'=> 100));
+ }
+ } else {
+ $roo->jerr('no_member',array('errcode'=> 100));
+ }
+ }
+
}
}