public function countMessagesForSubject(Subject $subject) { $dql = "\n SELECT Count(m) FROM Claroline\\ForumBundle\\Entity\\Message m\n JOIN m.subject s\n WHERE s.id = :subjectId"; $query = $this->_em->createQuery($dql); $query->setParameter('subjectId', $subject->getId()); return $query->getSingleScalarResult(); }
/** * @param Subject $subject */ public function __construct(Subject $subject) { $details = array('subject' => array('id' => $subject->getId(), 'title' => $subject->getTitle()), 'category' => array('id' => $subject->getCategory()->getId()), 'forum' => array('id' => $subject->getCategory()->getForum()->getId())); parent::__construct($subject->getCategory()->getForum()->getResourceNode(), $details); }
/** * @param \Claroline\ForumBundle\Entity\Message $message * @param \Claroline\ForumBundle\Entity\Subject $oldSubject * @param \Claroline\ForumBundle\Entity\Subject $newSubject */ public function __construct(Message $message, Subject $oldSubject, Subject $newSubject) { $details = array('message' => array('id' => $message->getId()), 'subject' => array('oldSubjectId' => $oldSubject->getId(), 'newSubjectId' => $newSubject->getId()), 'category' => array('id' => $message->getSubject()->getCategory()->getId()), 'forum' => array('id' => $message->getSubject()->getCategory()->getForum()->getId())); parent::__construct($message->getSubject()->getCategory()->getForum()->getResourceNode(), $details); }
public function findBySubject(Subject $subject, $getQuery = false) { $dql = "\n SELECT m, u, pws FROM Claroline\\ForumBundle\\Entity\\Message m\n JOIN m.creator u\n LEFT JOIN u.personalWorkspace pws\n JOIN m.subject subject\n WHERE subject.id = {$subject->getId()}"; $query = $this->_em->createQuery($dql); return $getQuery ? $query : $query->getResult(); }
/** * @param \Claroline\ForumBundle\Entity\Subject $subject * @param \Claroline\ForumBundle\Entity\Category $oldCategory * @param \Claroline\ForumBundle\Entity\Category $newCategory */ public function __construct(Subject $subject, Category $oldCategory, Category $newCategory) { $details = array('subject' => array('id' => $subject->getId()), 'category' => array('oldCategoryId' => $oldCategory->getId(), 'newCategoryId' => $newCategory->getId()), 'forum' => array('id' => $subject->getCategory()->getForum()->getId())); parent::__construct($subject->getCategory()->getForum()->getResourceNode(), $details); }