src/AppBundle/Controller/DefaultController.php line 13

Open in your IDE?
  1. <?php
  3. namespace AppBundle\Controller;
  5. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  6. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  8. class DefaultController extends Controller {
  10.     /**
  11.      * @Route("/", name="homepage", schemes={"https"})
  12.      */
  13.     public function indexAction() {
  14.         $em = $this->getDoctrine()->getManager();
  16.         $numberOfCallAttemptsSQLQuery = $em->getConnection()->prepare("SELECT COUNT(*) as count FROM callattempts");
  17.         $numberOfCallAttemptsSQLQuery->execute();
  19.         $numberOfArchivedCallAttemptsSQLQuery = $em->getConnection()->prepare("SELECT COUNT(*) as count FROM archivedcallattempts");
  20.         $numberOfArchivedCallAttemptsSQLQuery->execute();
  22.         $numberOfMinutesTalkedSQLQuery = $em->getConnection()->prepare("SELECT ROUND(SUM(TIMEDIFF(c.conversationend,c.conversationbegin)/60), 0) AS duration FROM callattempts c");
  23.         $numberOfMinutesTalkedSQLQuery->execute();
  25.         $numberOfMinutesTalkedArchivedCallAttemptsSQLQuery = $em->getConnection()->prepare("SELECT ROUND(SUM(TIMEDIFF(c.conversationend,c.conversationbegin)/60), 0) AS duration FROM archivedcallattempts c");
  26.         $numberOfMinutesTalkedArchivedCallAttemptsSQLQuery->execute();
  28.         $numberOfOpportunitiesSQLQuery = $em->getConnection()->prepare("SELECT COUNT(*) as count FROM opportunities");
  29.         $numberOfOpportunitiesSQLQuery->execute();
  31.         $numberOfAppointmentsSQLQuery = $em->getConnection()->prepare("SELECT COUNT(*) as count FROM appointments");
  32.         $numberOfAppointmentsSQLQuery->execute();
  34.         return $this->render('index/index.html.twig', array(
  35.                     'entitymanager' => $em,
  36.                     'numberOfCallAttempts' => number_format($numberOfCallAttemptsSQLQuery->fetchAll()[0]['count'] + $numberOfArchivedCallAttemptsSQLQuery->fetchAll()[0]['count'], 0, ',', '.'),
  37.                     'numberOfMinutesTalked' => number_format($numberOfMinutesTalkedSQLQuery->fetchAll()[0]['duration'] + $numberOfMinutesTalkedArchivedCallAttemptsSQLQuery->fetchAll()[0]['duration'], 0, ',', '.'),
  38.                     'numberOfOpportunities' => number_format($numberOfOpportunitiesSQLQuery->fetchAll()[0]['count'], 0, ',', '.'),
  39.                     'numberOfAppointments' => number_format($numberOfAppointmentsSQLQuery->fetchAll()[0]['count'], 0, ',', '.')
  40.         ));
  41.     }
  43.     /**
  44.      * @Route("/phpinfo", name="phpinfo", schemes={"https"})
  45.      */
  46.     public function phpinfoAction() {
  47.         ob_start();
  48.         phpinfo();
  50.         $phpinfo = ob_get_clean();
  52.         return $this->render('index/phpinfo.html.twig', array('phpinfo' => $phpinfo, 'entitymanager' => $this->getDoctrine()->getManager()));
  53.     }
  54.     
  55.     /**
  56.      * @Route("/documentation", name="documentation", schemes={"https"})
  57.      */
  58.     public function documentationAction() {
  59.         return $this->render('index/documentation.html.twig', array('entitymanager' => $this->getDoctrine()->getManager()));
  60.     }
  61.     
  62. }