classes/note/NoteDAO.inc.php

<?php

import('lib.pkp.classes.note.PKPNoteDAO');
import('classes.note.Note');

class NoteDAO extends PKPNoteDAO {
   function NoteDAO() {
      parent::PKPNoteDAO();
   }

   function newDataObject() {
      return new Note();
   }

   function unreadNotesExistByAssoc($assocType, $assocId, $userId) {
      $params = array((int) $assocId, (int) $assocType);
      if (isset($userId)) $params[] = (int) $userId;

      $result = $this->retrieve(
         'SELECT  COUNT(*)
         FROM  notes n
            LEFT JOIN item_views v ON (v.assoc_type = ? AND v.assoc_id = CAST(n.note_id AS CHAR) AND v.user_id = ?)
         WHERE n.assoc_type = ? AND
            n.assoc_id = ? AND
            v.assoc_id IS NULL',
         array(
            (int) ASSOC_TYPE_NOTE,
            (int) $userId,
            (int) $assocType,
            (int) $assocId
         )
      );

      $returner = isset($result->fields[0]) && $result->fields[0] == 0 ? false : true;
      $result->Close();

      return $returner;
   }
}

?>