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);
}
