$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
");
}
}
if ($this->to_group != -1) {
- $c = DB_DataObject::factory('core_group_member');
- //$c->groud_id = $this->to_group;
-
- //$c->setFrom(array(
- // 'groud_id' => $this->to_group
- //));
- $c->whereAdd("group_id = {$this->to_group}");
- if (!$c->find(true)) {
- echo "not found";
+
+ $c = DB_DataObject::factory('core_group_member');
+ $c->whereAdd("group_id = {$this->to_group}");
+
+ 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));
+ }
}
-
- //print_r($this->to_group);
- print_r($c);
- print_r($c->count());exit;
+
}
}