classes/group/GroupDAO.inc.php

<?php

// $Id: GroupDAO.inc.php,v 1.11 2008/07/01 01:16:09 asmecher Exp $


import ('group.Group');

class GroupDAO extends DAO {
   function &getGroup($groupId) {
      $result = &$this->retrieve(
         'SELECT * FROM groups WHERE group_id = ?', $groupId
      );

      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = &$this->_returnGroupFromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      unset($result);
      return $returner;
   }

   function &getGroups($journalId, $context = null, $rangeInfo = null) {
      $params = array($journalId);
      if ($context !== null) $params[] = $context;

      $result =& $this->retrieveRange(
         'SELECT * FROM groups WHERE journal_id = ? ' . ($context!==null?'AND context = ? ':'') . 'ORDER BY context, seq',
         $params, $rangeInfo
      );

      $returner =& new DAOResultFactory($result, $this, '_returnGroupFromRow');
      return $returner;
   }

   function getLocaleFieldNames() {
      return array('title');
   }

   function &_returnGroupFromRow(&$row) {
      $group = &new Group();
      $group->setGroupId($row['group_id']);
      $group->setAboutDisplayed($row['about_displayed']);
      $group->setSequence($row['seq']);
      $group->setContext($row['context']);
      $group->setJournalId($row['journal_id']);
      $this->getDataObjectSettings('group_settings', 'group_id', $row['group_id'], $group);

      HookRegistry::call('GroupDAO::_returnGroupFromRow', array(&$group, &$row));

      return $group;
   }

   function updateLocaleFields(&$group) {
      $this->updateDataObjectSettings('group_settings', $group, array(
         'group_id' => $group->getGroupId()
      ));
   }

   function insertGroup(&$group) {
      $this->update(
         'INSERT INTO groups
            (seq, journal_id, about_displayed, context)
            VALUES
            (?, ?, ?, ?)',
         array(
            $group->getSequence() == null ? 0 : $group->getSequence(),
            $group->getJournalId(),
            $group->getAboutDisplayed(),
            $group->getContext()
         )
      );

      $group->setGroupId($this->getInsertGroupId());
      $this->updateLocaleFields($group);
      return $group->getGroupId();
   }

   function updateGroup(&$group) {
      $returner = $this->update(
         'UPDATE groups
            SET
               seq = ?,
               journal_id = ?,
               about_displayed = ?,
               context = ?
            WHERE group_id = ?',
         array(
            $group->getSequence(),
            $group->getJournalId(),
            $group->getAboutDisplayed(),
            $group->getContext(),
            $group->getGroupId()
         )
      );
      $this->updateLocaleFields($group);
      return $returner;
   }

   function deleteGroup(&$group) {
      return $this->deleteGroupById($group->getGroupId());
   }

   function deleteGroupById($groupId) {
      $groupMembershipDao = &DAORegistry::getDAO('GroupMembershipDAO');
      $groupMembershipDao->deleteMembershipByGroupId($groupId);
      $this->update('DELETE FROM group_settings WHERE group_id = ?', $groupId);
      return $this->update('DELETE FROM groups WHERE group_id = ?', $groupId);
   }

   function deleteGroupsByJournalId($journalId) {
      $groups =& $this->getGroups($journalId);
      while ($group =& $groups->next()) {
         $this->deleteGroup($group);
      }
   }

   function resequenceGroups($journalId = null) {
      $result = &$this->retrieve(
         'SELECT group_id FROM groups ' .
         ($journalId !== null?'WHERE journal_id = ?':'') .
         'ORDER BY seq',
         $journalId
      );

      for ($i=1; !$result->EOF; $i++) {
         list($groupId) = $result->fields;
         $this->update(
            'UPDATE groups SET seq = ? WHERE group_id = ?',
            array(
               $i,
               $groupId
            )
         );

         $result->moveNext();
      }

      $result->close();
      unset($result);
   }

   function getInsertGroupId() {
      return $this->getInsertId('groups', 'group_id');
   }
}

?>

---