src/Controller/DefaultController.php line 19

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Symfony\Component\HttpFoundation\Response;
  6. use Pimcore\Controller\FrontendController;
  7. use Symfony\Component\HttpFoundation\Request;
  8. use Sensio\Bundle\FrameworkExtraBundle\Configuration\Template;
  9. use Symfony\Component\Routing\Annotation\Route;
  10. use \Pimcore\Model\DataObject\City;
  11. use \Pimcore\Model\DataObject\Ward;
  12. use \Pimcore\Model\DataObject\District;
  13. use Pimcore\Model\DataObject\Service as DataObjectService;
  14. use Pimcore\Model\DataObject;
  16. use Pimcore\Model\Notification\Service\NotificationService;
  17. use Pimcore\Db;
  19. class DefaultController extends BaseController
  20. {    
  21.     private $notificationService;
  23.     public function __construct(
  24.         NotificationService $notificationService
  25.     )
  26.     {
  27.         $this->notificationService = $notificationService;
  28.     }
  30.     /**
  31.      * @Route("/notifications", name="notifications")
  32.      */
  33.     public function notifications(Request $request)
  34.     {
  35.         $queryBuilder  = Db::getConnection()->createQueryBuilder();
  36.             
  37.         $queryBuilder->addSelect([
  38.             'count(notifications.id) as total'
  39.         ]);
  40.         
  41.         $queryBuilder->from('notifications', 'notifications');
  42.         $queryBuilder->andWhere('notifications.read = 0');
  43.         $result = $queryBuilder->execute()->fetchAll();
  44.         
  45.         $data=0;
  46.         foreach($result as $value){
  47.             $data = $value['total'];
  48.         }
  49.         
  50.         return $this->sendResponse(['total' => $data]);
  51.     }
  53.      /**
  54.      * @Template
  55.      * @param Request $request
  56.      * @return array
  57.      */
  58.     public function defaultAction(Request $request)
  59.     {
  60.         return [];
  61.     }
  63. }