Changeset 11992

Timestamp:

Jun 23, 2009, 9:18:07 PM (14 years ago)

Author:

nagasawa

Message:

#3906:added process in admin of community the member delete method(trunk)

Location:

OpenPNE3/trunk/lib/model/doctrine

Files:

• CommunityMemberTable.class.php (modified) (1 diff)
• Member.class.php (modified) (1 diff)

OpenPNE3/trunk/lib/model/doctrine/CommunityMemberTable.class.php

@@ -120 +120 @@
     return array();
   }
+
+  public function getCommunityMemberCount($communityId)
+  {
+    $communityMember = $this->createQuery()
+      ->select('COUNT(*)')
+      ->where('community_id = ?', $communityId)
+      ->addWhere('position = ?', '')
+      ->fetchArray();
+
+    return $communityMember[0]['COUNT'];
+  }
 }

OpenPNE3/trunk/lib/model/doctrine/Member.class.php

@@ -232 +232 @@
     return $result;
   }
+
+  public function delete(Doctrine_Connection $conn = null)
+  {
+    $memberId = $this->getId();
+    $communityMemberTable = Doctrine::getTable('CommunityMember');
+    $adminCommunity = $communityMemberTable->getCommunityIdsOfAdminByMemberId($this->getId());
+    foreach ($adminCommunity as $community)
+    {
+      $communityId = $community['community_id'];
+      $memberCount = $communityMemberTable->getCommunityMemberCount($communityId);
+      if (!$memberCount)
+      {
+          $community = Doctrine::getTable('Community')->find($communityId);
+          $community->delete();
+          continue;
+      }
+      $communityMember = $communityMemberTable->createQuery()
+        ->where('community_id = ?', $communityId)
+        ->addWhere('position = ?', '')
+        ->orderBy('random()')
+        ->limit(1)
+        ->fetchOne();
+      $communityMember->setPosition('admin');
+      $communityMember->save();
+      $communityMember = $communityMemberTable->retrieveByMemberIdAndCommunityId($memberId, $communityId);
+      $communityMember->delete();
+    }
+    return parent::delete($conn);
+  }
 }