src/Globals/CoreBundle/Controller/TopLossWidgetController.php line 45

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: POlleros
  5.  * Date: 12/11/2017
  6.  * Time: 11:04 AM
  7.  */
  10. namespace Globals\CoreBundle\Controller;
  12. use Globals\CustomerManagementBundle\Entity\AutoDiary;
  13. use Globals\CustomerManagementBundle\Form\AutoDiaryType;
  14. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  15. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
  16. use Globals\CustomerManagementBundle\Entity\Customer;
  17. use Symfony\Component\HttpFoundation\Request;
  18. use Symfony\Component\HttpFoundation\JsonResponse;
  19. use Globals\CoreBundle\Helpers\DbUtilities;
  20. use DateTime;
  21. use Globals\ClaimManagementBundle\Entity\Claim;
  24. /**
  25.  * @Route("/administration")
  26.  */
  27. class TopLossWidgetController extends Controller
  28. {
  30.     /**
  31.      * @Route("/toploss/show")
  32.      */
  33.     public function showToploss()
  34.     {
  35.         return $this->render('@Core/Widget/widget_toploss.html.twig', array(
  36.             'active_class' => 'diary'
  37.         ));
  38.     }
  40.     # Load Datatables
  42.     /**
  43.      * @Route("/toploss/data")
  44.      */
  45.     public function toplossWidgetData(Request $request)
  46.     {
  47.         // $user = $this->get('security.token_storage')->getToken()->getUser();
  48.         $em = $this->getDoctrine()->getManager();
  50.         $sql = "SELECT
  51.                     perils.description,
  52.                     Count(perils.description) AS counter,
  53.                     perils.id AS peril_id,
  54.                     claim.id AS claim_id
  55.                     FROM
  56.                     claim
  57.                     INNER JOIN perils ON perils.id = claim.peril_id
  58.                     WHERE
  59.                     claim.status_id != 30
  60.                     GROUP BY
  61.                     perils.description
  62.                     ORDER BY counter DESC
  63.                     LIMIT 5";
  65.         //echo $sql;
  66.         $stmt = $em->getConnection()->prepare($sql);
  67.         $stmt->execute();
  69.         $results = $stmt->fetchAll();
  70.         //print_r($statuses);
  72.         return new JsonResponse($results);
  73.     }
  74. }