}
}
+ if(!empty($q['_is_in_group'])){
+ $this->selectAdd("
+ COALESCE((
+ SELECT
+ COUNT(id)
+ FROM
+ core_group_member
+ WHERE
+ user_id = {$q['_is_in_group']}
+ AND
+ group_id = {$this->tableName()}.id
+ ), 0) AS is_in_group
+ ");
+ }
+
+
$cp = DB_DataObject::Factory('core_person')->tableName();
$cgm = DB_DataObject::Factory('core_group_member')->tableName();
$roo->jerr("missing group id");
}
- foreach(explode(',', $q['user_ids']) as $uid) {
+
+ $user_ids = explode(',', $q['user_ids']);
+
+ foreach($user_ids as $uid) {
+
switch($q['_action']) {
case 'add':
$g->addMember($uid,$roo);
$gm = DB_Dataobject::factory('core_group_member');
$gm->group_id = $this->id;
$gm->user_id = is_object($person) ? $person->id : $person;
+
if (!$gm->count()) {
$gm->insert();
}
function postListFilter($ar, $au, $req)
{
- $ret = array();
-
- if(!empty($req['_is_group'])){
-
-
-
- }
-
- if(!empty($req['_add_everyone'])){
- $ret[] = array( 'id' => 0, 'name' => 'EVERYONE');
- $ret[] = array( 'id' => -1, 'name' => 'NOT_IN_GROUP');
- $ar = array_merge($ret, $ar);
+ if(empty($req['_add_everyone'])){
+ return $ar;
}
-
-
+
+ $ret[] = array( 'id' => 0, 'name' => 'EVERYONE');
+ $ret[] = array( 'id' => -1, 'name' => 'NOT_IN_GROUP');
+ return array_merge($ret, $ar);
}