}
}
- if(!empty($q['_with_member_id'])){
- $this->selectAdd("
- COALESCE(
- (SELECT id from core_group_member
- WHERE ...
-
- LIMIT 1
- ),0) as ....
- ");
- }
-
-
$cp = DB_DataObject::Factory('core_person')->tableName();
$cgm = DB_DataObject::Factory('core_group_member')->tableName();
) AS group_member_count
");
- /*WHERE
- {$this->tableName()}.id = core_group_member.group_id
- AND
- core_group_member.user_id = core_person.id
- AND
- core_person.active = 1
- )*/
-
-// $this->whereAdd("{$this->tableName()}.id = core_group_member.group_id");
-// $this->whereAdd("core_group_member.user_id = core_person.id");
-// $this->whereAdd("core_person.active = 1");
-
-
- /*$cgmDBObj->joinAdd($cpObj);
- $this->joinAdd($cgmDBObj);
- DB_DataObject::debugLevel();*/
}
function toEventString() {
foreach($data as $gi) {
$g = DB_DataObject::factory($this->tableName());
+
+ $o = false;
+
+ if($g->get('name', $gi['name'])){
+ $o = clone($g);
+ }
+
+ $display_name = (isset($gi['display_name'])) ? $gi['display_name'] : '';
+
+ unset($gi['display_name']);
+
$g->setFrom($gi);
-
- if(!$g->find(true)){
- $g->insert();
+
+ if(empty($o) || empty($o->display_name)){
+ $g->display_name = $display_name;
}
+
+ (empty($o)) ? $g->insert() : $g->update($o);
if(count($g->members()) || empty($gi['members'])){
continue;