public function updateResponseCountQuestion(Question $question)
{
$query = $this->getEntityManager()->createQuery('UPDATE Civix\\CoreBundle\\Entity\\Activities\\Question a
SET a.responsesCount = :questions_count
WHERE a.questionId = :question');
$query->setParameter('question', $question->getId())->setParameter('questions_count', $question->getAnswersCount());
return $query->execute();
}
private function getQuestionDetails(Question $question, $class)
{
try {
$questionDetails = $this->getDoctrine()->getRepository('CivixCoreBundle:Poll\\Question')->getPublishedQuestionWithAnswers($question->getId(), $class);
} catch (LogicException $e) {
throw $this->createNotFoundException();
}
if (!$questionDetails) {
throw $this->createNotFoundException();
}
$statistics = $question->getStatistic(['#7ac768', '#ba3830', '#4fb0f3', '#dbfa08', '#08fac4']);
return ['statistics' => $statistics, 'question' => $questionDetails];
}
public function findNotPaidOut(Question $question)
{
return $this->createQueryBuilder('ph')->where('ph.question_id = :question')->andWhere('ph.state = :state')->andWhere('ph.paidOut IS NULL')->andWhere('ph.toUser IS NOT NULL')->setParameter('state', PaymentHistory::STATE_SUCCESS)->setParameter('question', $question->getId())->getQuery()->getResult();
}
/**
* @Route("/details/{id}", requirements={"id"="\d+"})
* @ParamConverter("question", class="CivixCoreBundle:Poll\Question")
* @Template("CivixFrontBundle:Question:details.html.twig")
*/
public function detailsAction(Request $request, Question $question)
{
$entityManager = $this->getDoctrine()->getManager();
$statistics = $question->getStatistic(['#7ac768', '#ba3830', '#4fb0f3', '#dbfa08', '#08fac4']);
$query = $entityManager->getRepository('CivixCoreBundle:Poll\\Answer')->getAnswersByQuestion($question->getId());
$pagination = $this->get('knp_paginator')->paginate($query, $this->getRequest()->get('page', 1), 20);
return ['statistics' => $statistics, 'pagination' => $pagination];
}
