NavigationMenuItemAssignmentDAO.inc.php

<?php
 
import('lib.pkp.classes.navigationMenu.NavigationMenu');
import('lib.pkp.classes.navigationMenu.NavigationMenuItem');
import('lib.pkp.classes.navigationMenu.NavigationMenuItemAssignment');
 
class NavigationMenuItemAssignmentDAO extends DAO {
 
   function getById($navigationMenuItemAssignmentId) {
      $params = array((int) $navigationMenuItemAssignmentId);
      $result = $this->retrieve(
         'SELECT  * FROM navigation_menu_item_assignments WHERE navigation_menu_item_assignment_id = ?',
         $params
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   public function newDataObject() {
      return new NavigationMenuItemAssignment();
   }
 
   public function getByMenuId($menuId) {
      $params = array((int) $menuId);
      $result = $this->retrieve(
         'SELECT nmi.*,nmh.navigation_menu_id,nmh.parent_id,nmh.seq, nmh.navigation_menu_item_assignment_id
            FROM navigation_menu_item_assignments as nmh
            LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
            WHERE nmh.navigation_menu_id = ?
            ORDER BY nmh.seq',
         $params
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   public function getByMenuItemId($menuItemId) {
      $params = array((int) $menuItemId);
      $result = $this->retrieve(
         'SELECT nmi.*, nmh.navigation_menu_id, nmh.parent_id, nmh.seq, nmh.navigation_menu_item_assignment_id
            FROM navigation_menu_item_assignments as nmh
            LEFT JOIN navigation_menu_items as nmi ON (nmh.navigation_menu_item_id = nmi.navigation_menu_item_id)
            WHERE nmh.navigation_menu_item_id = ?
            ORDER BY nmh.seq',
         $params
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   public function getByNMIIdAndMenuIdAndParentId($navigationMenuItemId, $menuId, $parentId = null) {
      $params = array(
         (int) $menuId,
         (int) $navigationMenuItemId
      );
      if ($parentId) $params[] = (int) $parentId;
 
      $result = $this->retrieve(
         'SELECT nmh.*
            FROM navigation_menu_item_assignments as nmh
            WHERE nmh.navigation_menu_id = ?
            AND nmh.navigation_menu_item_id = ?' .
            ($parentId?' AND nmh.parent_id = ?':''),
         $params
      );
 
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->_fromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
 
   public function getByMenuIdAndParentId($menuId, $parentId) {
      $params = array(
         (int) $menuId,
         (int) $parentId
      );
 
      $result = $this->retrieve(
         'SELECT nmh.*
            FROM navigation_menu_item_assignments as nmh
            WHERE nmh.navigation_menu_id = ?
            AND nmh.parent_id = ?',
         $params
      );
 
      return new DAOResultFactory($result, $this, '_fromRow');
   }
 
   public function _fromRow($row) {
      $assignment = $this->newDataObject();
      $assignment->setId($row['navigation_menu_item_assignment_id']);
      $assignment->setMenuId($row['navigation_menu_id']);
      $assignment->setMenuItemId($row['navigation_menu_item_id']);
      $assignment->setParentId($row['parent_id']);
      $assignment->setSequence($row['seq']);
 
      $this->getDataObjectSettings('navigation_menu_item_assignment_settings', 'navigation_menu_item_assignment_id', $row['navigation_menu_item_assignment_id'], $assignment);
 
      return $assignment;
   }
 
   function updateObject($navigationMenuItemAssignment) {
      $returner = $this->update(
            'UPDATE navigation_menu_item_assignments
            SET
               navigation_menu_id = ?,
               navigation_menu_item_id = ?,
               parent_id = ?,
               seq = ?,
            WHERE navigation_menu_item_assignment_id = ?',
         array(
            (int) $navigationMenuItemAssignment->getMenuId(),
            (int) $navigationMenuItemAssignment->getMenuItemId(),
            (int) $navigationMenuItemAssignment->getParentId(),
            (int) $navigationMenuItemAssignment->getSequence(),
            (int) $navigationMenuItemAssignment->getId(),
         )
      );
      $this->updateLocaleFields($navigationMenuItemAssignment);
 
      $this->unCacheRelatedNavigationMenus($navigationMenuItemAssignment->getId());
 
      return $returner;
   }
 
   public function insertObject($assignment) {
      $this->update(
            'INSERT INTO navigation_menu_item_assignments
            (navigation_menu_id, navigation_menu_item_id, parent_id, seq)
            VALUES
            (?, ?, ?, ?)',
         array(
            (int) $assignment->getMenuId(),
            (int) $assignment->getMenuItemId(),
            (int) $assignment->getParentId(),
            (int) $assignment->getSequence(),
         )
      );
 
      // Add default title (of the navigationMenuItem)
      $navigationMenuItemDao = DAORegistry::getDAO('NavigationMenuItemDAO'); /* @var $navigationMenuItemDao NavigationMenuItemDAO */
      $navigationMenuItem = $navigationMenuItemDao->getById($assignment->getMenuItemId());
 
      $assignment->setTitle($navigationMenuItem->getTitle(null), null);
 
      $assignment->setId($this->getInsertId());
      $this->updateLocaleFields($assignment);
 
      $this->unCacheRelatedNavigationMenus($assignment->getId());
 
      return $assignment->getId();
   }
 
   function deleteByMenuId($menuId) {
      $navigationMenuItemAssignments = $this->getByMenuId($menuId);
      while ($navigationMenuItemAssignment = $navigationMenuItemAssignments->next()) {
         $this->deleteObject($navigationMenuItemAssignment);
      }
 
      return true;
   }
 
   function deleteByMenuItemId($menuItemId) {
      $navigationMenuItemAssignments = $this->getByMenuItemId($menuItemId);
      while ($navigationMenuItemAssignment = $navigationMenuItemAssignments->next()) {
         $this->deleteObject($navigationMenuItemAssignment);
      }
 
      return true;
   }
 
   function deleteObject($navigationMenuItemAssignment) {
      return $this->deleteById($navigationMenuItemAssignment->getId());
   }
 
   function deleteById($navigationMenuItemAssignmentId) {
      $this->unCacheRelatedNavigationMenus($navigationMenuItemAssignmentId);
 
      $this->update('DELETE FROM navigation_menu_item_assignment_settings WHERE navigation_menu_item_assignment_id = ?', (int) $navigationMenuItemAssignmentId);
      $this->update('DELETE FROM navigation_menu_item_assignments WHERE navigation_menu_item_assignment_id = ?', (int) $navigationMenuItemAssignmentId);
   }
 
   function getLocaleFieldNames() {
      return array('title');
   }
 
   function getInsertId() {
      return $this->_getInsertId('navigation_menu_item_assignments', 'navigation_menu_item_assignment_id');
   }
 
   function updateLocaleFields($navigationMenuItemAssignment) {
      $this->updateDataObjectSettings('navigation_menu_item_assignment_settings', $navigationMenuItemAssignment, array(
         'navigation_menu_item_assignment_id' => $navigationMenuItemAssignment->getId()
      ));
   }
 
   function unCacheRelatedNavigationMenus($id) {
      $navigationMenuItemAssignment = $this->getById($id);
      if ($navigationMenuItemAssignment) {
         $navigationMenuDao = \DAORegistry::getDAO('NavigationMenuDAO');
         $cache = $navigationMenuDao->getCache($navigationMenuItemAssignment->getMenuId());
         if ($cache) $cache->flush();
      }
   }
}