public function getPostThread($id)
 {
     return $this->createQueryBuilder('p')->select(array('p', 'c'))->join('\\sampleMessageBoard\\application\\model\\BoardModel', 'c', 'WITH', 'p.lft <= c.lft AND p.rgt >= c.rgt')->where('p.id = :id')->setParameter('id', $id)->getQuery()->getResults(\Doctrine\ORM\Query::HYDRATE_ARRAY);
     $nsm = new Manager(new Config($this->getEntityManager(), $this->_entityName));
     $model = $nsm->wrapNode($this->find($id));
     //$children =  $model->getChildren();
     $children = $model->{$model}->getDescendants();
     foreach ($children as $c) {
         $ret[] = $c->getNode()->toArray();
     }
     return $ret;
     $ret = array();
     $model = $this->getEntityManager()->find($id);
     $descendants = $model->getDescendants();
     foreach ($descendants as $d) {
         $ret[] = $d->toArray();
     }
     return $ret;
     //
     // $q = Doctrine_Query::create()
     //   ->select('p.*')
     //   ->from('Posts p')
     //   ->setHydrationMode(Doctrine_Core::HYDRATE_ARRAY);
     // $treeObject = Doctrine_Core::getTable('Posts')->getTree();
     // $treeObject->setBaseQuery($q);
     // $tree = $treeobject->fetchTree();
     // $treeObject->restBaseQuery();
     // return $tree;
 }
 /**
  * Retourne une vue de l'ensemble des Noeuds enregistrés 
  * (destiné à être appelé par un render)
  * @Template()
  */
 public function showAction($_locale)
 {
     /* Initialisation des repositories et du Manager */
     $em = $this->getDoctrine()->getEntityManager();
     $config = new Config($em, 'RNCMenuBundle:Item');
     $nsm = new Manager($config);
     /* Configuration du manager */
     $rep = $em->getRepository('RNCMenuBundle:Item');
     $qb = $rep->getTreeQB();
     $nsm->getConfiguration()->setBaseQueryBuilder($qb);
     /* Récupération des arbres */
     $roots = $rep->findAllRoots();
     $trees = array();
     foreach ($roots as $root) {
         $trees[$root->getId()] = $nsm->fetchTreeAsArray($root->getId());
     }
     return $this->render('RNCMenuBundle:Menu:show.html.twig', array('trees' => $trees, '_locale' => $_locale));
 }
 public function create($params)
 {
     $model = new $this->model();
     $nsm = new Manager(new Config($this->entityManager, $this->model));
     foreach ($params as $k => $v) {
         $f = 'set' . ucfirst($k);
         if (method_exists($model, $f)) {
             $model->{$f}($v);
         }
     }
     if ($model->getParentId() > 0) {
         // add new post as a child of another post
         $parent = $nsm->fetchTree($model->getParentId());
         $parent->addChild($model);
         return $model;
     } else {
         $nsm->createRoot($model);
         return $model;
     }
 }
Example #4
0
 /**
  * Delete entity and flush
  * @param MenuItem entity
  */
 public function deleteNode(MenuItem $entity)
 {
     $this->nestedSetManager->wrapNode($entity)->delete();
 }
Example #5
0
 /**
  * Выводит меню публикаций
  *
  * @Route("/categories-menu/{feedType}/{selectedCategory}/{specialtyId}/{groupId}/{userId}", name = "categories_menu", defaults = {"feedType" = "main-feed", "specialtyId" = 0, "groupId" = 0, "userId" = 0})
  */
 public function categoriesMenuAction($selectedCategory = 'all', $specialtyId, $groupId, $feedType, $userId)
 {
     $em = $this->getDoctrine()->getManager();
     $config = new Config($em, 'Evrika\\MainBundle\\Entity\\Category');
     $nsManager = new Manager($config);
     $categories = $nsManager->fetchTreeAsArray(1);
     // @todo переделать в нормальный switch. Вместо unset лучше сразу выбирать только то что нам нужно (но при этом важно чтобы они были отсортированы (потомки должны идти сразу вслед за своими родителями))
     if ($feedType != 'user_feed') {
         if ($groupId != 0) {
             // group feed
             foreach ($categories as $key => $category) {
                 if (!$category->getNode()->isInGroupFeed()) {
                     unset($categories[$key]);
                 }
             }
         } else {
             // main feed
             foreach ($categories as $key => $category) {
                 if (!$category->getNode()->isInMainFeed()) {
                     unset($categories[$key]);
                 }
             }
         }
     } else {
         // user feed
         foreach ($categories as $key => $category) {
             if (!$category->getNode()->isInUserFeed()) {
                 unset($categories[$key]);
             }
         }
     }
     if (!($this->get('security.context')->isGranted('ROLE_DOCTOR') || $this->get('security.context')->isGranted('ROLE_STUDENT'))) {
         // exclude non public
         foreach ($categories as $key => $category) {
             if (!$category->getNode()->isPublic()) {
                 unset($categories[$key]);
             }
         }
     }
     // Если выбран подпункт, подсвечиваем всё равно родительскую категорию
     foreach ($categories as $key => $category) {
         if ($category->getId() == $selectedCategory) {
             if ($categories[$key]->getLevel() > 1) {
                 $selectedCategory = $categories[$key]->getParent()->getNode()->getId();
             }
         }
     }
     return $this->render('EvrikaMainBundle::publications_menu.html.twig', array('categories' => $categories, 'feedType' => $feedType, 'selectedCategory' => $selectedCategory, 'specialtyId' => $specialtyId, 'groupId' => $groupId, 'userId' => $userId));
 }
Example #6
0
 /**
  * Добавляет лайк к публикации или комментарию от имени текущего пользователя
  *
  * @Route("/vote/{type}/{entityId}", name = "vote", defaults = {"type" = "publication"}, requirements = {"entityId" = "\d+", "type" = "comment|publication"})
  * @Secure(roles = "ROLE_DOCTOR, ROLE_STUDENT")
  */
 public function voteAction($type, $entityId)
 {
     $em = $this->getDoctrine()->getManager();
     $status = 'ERROR';
     $data = null;
     if ($this->get('security.context')->isGranted('IS_AUTHENTICATED_REMEMBERED')) {
         $entity = $em->find('EvrikaMainBundle:' . ucfirst($type), $entityId);
         $user = $this->getUser();
         $author = $entity->getAuthor();
         # если у публикации/комментария нету автора или автор является текущим пользователем
         if (!$author || !($author->getId() === $user->getId())) {
             # если текущий пользователь еще НЕ проголосовал
             if (!$entity->hasVote($user)) {
                 # добавляем лайк
                 $entity->addVote($user);
                 # добавляем уведомление автору публикации или комментария
                 $type == 'publication' ? $this->get('evrika.notice_manager')->publicationVoted($entity, $user) : $this->get('evrika.notice_manager')->commentVoted($entity, $user);
                 // @todo Начисление рейтинга (не удлаось вынести в DoctrineEventSubscriber из-за ограничений preUpdate, поэтому лучше вынести в отдельный сервис)
                 if ($entity->getNumberOfLikes() == ($entity instanceof Publication ? 10 : 5)) {
                     if ($author = $entity->getAuthor()) {
                         $ratingAdder = 0;
                         if ($entity instanceof Publication) {
                             $config = new Config($em, 'Evrika\\MainBundle\\Entity\\Category');
                             $nsManager = new Manager($config);
                             $categoryId = $entity->getCategory()->getId();
                             $category = $nsManager->wrapNode($entity->getCategory());
                             $ancestors = $category->getAncestors();
                             $ancestorsIds = array();
                             foreach ($ancestors as $ancestor) {
                                 $ancestorsIds[] = $ancestor->getNode()->getId();
                             }
                             if ($categoryId == Category::VIDEO_CATEGORY_ID || in_array(Category::VIDEO_CATEGORY_ID, $ancestorsIds)) {
                                 $ratingAdder = 10;
                             } else {
                                 if ($categoryId == Category::COUNCIL_CATEGORY_ID || in_array(Category::COUNCIL_CATEGORY_ID, $ancestorsIds)) {
                                     $ratingAdder = 15;
                                 } else {
                                     if ($categoryId == Category::ARTICLE_CATEGORY_ID || in_array(Category::ARTICLE_CATEGORY_ID, $ancestorsIds)) {
                                         $ratingAdder = 25;
                                     }
                                 }
                             }
                         } else {
                             $ratingAdder = 1;
                         }
                         if ($ratingAdder) {
                             $author->addRating($ratingAdder);
                         }
                     }
                 }
                 if ($type == 'publication') {
                     $log = new LikeLog();
                     $log->setUser($this->getUser());
                     $log->setType('publication');
                     $log->setCategory($entity->getCategory()->getId());
                     $em->persist($log);
                     $em->flush();
                 }
                 $em->flush();
                 $status = 'OK';
             } else {
                 $data = $type == 'publication' ? 'Вы уже голосовали за эту статью' : 'Вы уже голосовали за этот комментарий';
             }
         } else {
             $data = 'Вы не можете голосовать за собственные материалы';
         }
     } else {
         $data = 'Вы не авторизованы';
     }
     return $this->render('EvrikaMainBundle::response.json.twig', array('status' => $status, 'data' => $data));
 }
Example #7
0
 private function onPublicationCreated(LifecycleEventArgs $args)
 {
     $publication = $args->getEntity();
     # установить автора публикации
     $publication->setAuthor($this->container->get('security.context')->getToken()->getUser());
     # добавить ему рейтинг за публикацию
     if ($author = $publication->getAuthor()) {
         $em = $args->getEntityManager();
         $config = new Config($em, 'Evrika\\MainBundle\\Entity\\Category');
         $nsManager = new Manager($config);
         $categoryId = $publication->getCategory()->getId();
         $category = $nsManager->wrapNode($publication->getCategory());
         $ancestors = $category->getAncestors();
         $ancestorsIds = array();
         foreach ($ancestors as $ancestor) {
             $ancestorsIds[] = $ancestor->getNode()->getId();
         }
         $ratingAdder = 0;
         if ($categoryId == Category::VIDEO_CATEGORY_ID || in_array(Category::VIDEO_CATEGORY_ID, $ancestorsIds)) {
             $ratingAdder = 2;
         } else {
             if ($categoryId == Category::COUNCIL_CATEGORY_ID || in_array(Category::COUNCIL_CATEGORY_ID, $ancestorsIds)) {
                 $ratingAdder = 3;
             } else {
                 if ($categoryId == Category::ARTICLE_CATEGORY_ID || in_array(Category::ARTICLE_CATEGORY_ID, $ancestorsIds)) {
                     $ratingAdder = 5;
                 }
             }
         }
         if ($ratingAdder) {
             $author->addRating($ratingAdder);
         }
     }
 }
 public function __construct(EntityManager $em, $clazz = null)
 {
     parent::__construct(new Config($em, $clazz));
 }
 /**
  *
  * @Route("/move", name="rnc_admin_menu_move", requirements={"_method"="POST"})
  * @Template()
  * @Secure(roles="ROLE_ADMIN")
  */
 public function moveAction()
 {
     $request = $this->get('request');
     if ($request->isXmlHttpRequest()) {
         $cur = $request->request->get('cur');
         $prev = $request->request->get('prev');
         $next = $request->request->get('next');
         $em = $this->getDoctrine()->getEntityManager();
         $config = new Config($em, 'RNCMenuBundle:Item');
         $nsm = new Manager($config);
         $rep = $em->getRepository('RNCMenuBundle:Item');
         $cur_node = $rep->find($cur);
         $prev_node = $rep->find($prev);
         $next_node = $rep->find($next);
         if ($cur_node == null) {
             throw new NotFoundHttpException("Elément introuvable");
         }
         $node = $nsm->wrapNode($cur_node);
         if ($prev_node != null) {
             $wrp = $nsm->wrapNode($prev_node);
             if ($node->isRoot()) {
                 $new_pos = $prev_node->getPosition();
                 $old_pos = $cur_node->getPosition();
                 if ($old_pos < $new_pos) {
                     $rep->moveItemDown($old_pos, $new_pos);
                     $cur_node->setPosition($new_pos);
                 } else {
                     $rep->moveItemUp($old_pos, $new_pos + 1);
                     $cur_node->setPosition($new_pos + 1);
                 }
                 $em->persist($cur_node);
             } else {
                 $node->moveAsNextSiblingOf($wrp);
             }
         } else {
             if ($next_node != null) {
                 $wrp = $nsm->wrapNode($next_node);
                 if ($node->isRoot()) {
                     $new_pos = 1;
                     $old_pos = $cur_node->getPosition();
                     $rep->moveItemUp($old_pos, $new_pos);
                     $cur_node->setPosition($new_pos);
                     $em->persist($cur_node);
                 } else {
                     $node->moveAsPrevSiblingOf($wrp);
                 }
             }
         }
         $em->flush();
         $qb = $rep->getTreeQB();
         $nsm->getConfiguration()->setBaseQueryBuilder($qb);
         $roots = $rep->findAllRoots();
         $trees = array();
         foreach ($roots as $root) {
             $trees[$root->getId()] = $nsm->fetchTreeAsArray($root->getId());
         }
         return $this->render('RNCMenuBundle:Menu:show.html.twig', array('trees' => $trees));
     } else {
         return $this->indexAction();
     }
 }
Example #10
0
 private function getSubcategoriesDQL($rootCategoryId = 'all', $countryId = null)
 {
     $em = $this->getEntityManager();
     $config = new Config($em, 'Evrika\\MainBundle\\Entity\\Category');
     $nsManager = new Manager($config);
     if ($rootCategoryId == 'all') {
         $rootNode = $nsManager->fetchTree(Category::FEED_CATEGORIES_ROOT_ID);
         $selectedCategories = $rootNode->getDescendants();
     } else {
         $rootNode = $em->find('EvrikaMainBundle:Category', $rootCategoryId);
         $rootNode = $nsManager->wrapNode($rootNode);
         $selectedCategories = $rootNode->getDescendants();
         $selectedCategories[] = $rootNode;
     }
     $regionalCategoriesIds = array();
     $commonCategoriesIds = array();
     foreach ($selectedCategories as $category) {
         if ($category->getNode()->isRegional()) {
             $regionalCategoriesIds[] = $category->getNode()->getId();
         } else {
             $commonCategoriesIds[] = $category->getNode()->getId();
         }
         $categoriesIds[] = $category->getNode()->getId();
     }
     $regionalCategoriesDQL = '';
     $commonCategoriesDQL = '';
     if (!empty($regionalCategoriesIds)) {
         $regionalCategoriesDQL = '(c.id IN (' . implode(',', $regionalCategoriesIds) . ')' . ($countryId ? ' AND p.country = ' . $countryId : '') . ')';
     }
     if (!empty($commonCategoriesIds)) {
         $commonCategoriesDQL = 'c.id IN (' . implode(',', $commonCategoriesIds) . ')';
     }
     $query = ' AND (' . $regionalCategoriesDQL . ($commonCategoriesDQL && $regionalCategoriesDQL ? ' OR ' : '') . $commonCategoriesDQL . ' OR (c.id IN (' . implode(',', $categoriesIds) . ') AND p.country IS NULL))';
     return $query;
 }