/**
* @param Forum $forum
* @param $data
* @param string $prefix
* @return mixed
*/
protected function addForumToTreeArray(Forum $forum, $data, $prefix = "")
{
$name = $forum->getName();
if (!empty($prefix)) {
$name = $prefix . " - " . $name;
}
$data[] = array("id" => $forum->getId(), "name" => $name, "type" => $forum->getType());
foreach ($forum->getChildren() as $subforum) {
$data = $this->addForumToTreeArray($subforum, $data, $name);
}
return $data;
}
/**
* @param Forum $forum
* @return Post
*/
public function getLastPost(Forum $forum)
{
$ids = array($forum->getId());
$this->getAllForumChildIds($forum, $ids);
$sql = "SELECT\n p\n FROM\n SymbbCoreForumBundle:Post p\n JOIN\n p.topic t\n WHERE\n t.forum IN (?0)\n ORDER BY\n p.created DESC";
$query = $this->em->createQuery($sql);
$query->setParameter(0, $ids);
$query->setMaxResults(1);
$post = $query->getOneOrNullResult();
return $post;
}
