src/Controller/ClientController.php line 370

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Client;
  6. use App\Entity\Brand;
  7. use App\Form\ClientType;
  8. use App\Repository\ClientRepository;
  9. use App\Repository\CarSaleRepository;
  10. use App\Repository\CarBuyRepository;
  11. use App\Repository\BrandRepository;
  12. use App\Repository\UserRepository;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\Request;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\Routing\Annotation\Route;
  18. /**
  19.  * @Route("/client")
  20.  */
  21. class ClientController extends AbstractController
  22. {
  23.     /**
  24.      * @Route("/indexJson", name="client_index_json", methods={"GET", "POST"})
  25.      */
  26.     public function indexJson(Request $request, ClientRepository $entityRepository, CarSaleRepository $carSaleRepository): Response
  27.     {
  28.         /*---- Filters [START] ----*/
  29.         $search       = $request->get('searchPhrase');
  30.         $dateFrom     = $request->get('dateFrom').' 00:00:00';
  31.         $dateTo       = $request->get('dateTo').' 23:59:59';
  32.         $dateFilter   = $request->get('dateFilter');
  33.         $operFilter   = $request->get('operationsFilter');
  34.         $patentFilter = $request->get('patentFilter');
  36.         //exit($dateFrom.';'.$dateTo);
  38.         if (!empty($search)) {
  40.         }
  41.         /*---- Filters [END] ----*/
  43.         $totalR = 0;
  44.         $curPage   = $request->get('current');
  45.         $sizePage  = $request->get('rowCount');
  46.         $startPage = $curPage == 1 ? 0 : (($curPage - 1) * $sizePage);
  48.         $data = $entityRepository->createQueryBuilder('c')
  49.             ->where('c.id > :id')
  50.             ->setParameter('id', '0');
  52.         if ($patentFilter == 'true') {
  54.         } else {
  55.             $data = $data->andWhere('c.firstName like :search')
  56.                 ->orWhere('c.lastName like :search')
  57.                 ->orWhere('c.dni like :search')
  58.                 ->orWhere('c.telephone like :search')
  59.                 ->orWhere('c.cellphone like :search')
  60.                 ->orWhere('c.address like :search')
  61.                 ->setParameter(':search', "%$search%");
  62.         }
  64.         if ($dateFilter == 'true') {
  65.             $data = $data->andWhere('c.createdAt BETWEEN :dateFrom AND :dateTo')
  66.                 ->setParameter(':dateFrom', $dateFrom)
  67.                 ->setParameter(':dateTo', $dateTo);
  68.         }
  70.         $data = $data->leftJoin('c.user', 'u')
  71.             ->addSelect('u');
  73.         if ($this->getUser()->getRoles()[0] == 'ROLE_ADMIN' || $this->getUser()->getRoles()[0] == 'ROLE_AGENCY') {
  75.         } else {
  76.             $data = $data->having('u.id = :user')
  77.                 ->setParameter(':user', $this->getUser()->getId());
  78.         }
  80.         //dump($data->getDQL()); exit();
  82.         if ($operFilter == 'true') {
  83.             $filterPatent = '';
  84.             if ($patentFilter == 'true') {
  85.                 $filterPatent = "
  86.                 LEFT JOIN car c ON c.id = cs.car_sale_id
  87.                 WHERE c.patent like '%$search%'";
  88.             }
  90.             $query = "
  91.                 SELECT DISTINCT cs.client_id, cs.client_id
  92.                 FROM car_sale cs  
  93.                 $filterPatent
  94.             ";
  95.             $em = $this->getDoctrine()->getManager();
  96.             $db = $em->getConnection();
  97.             $stmt   = $db->prepare($query);
  98.             $result = $stmt->executeQuery();
  99.             $sales = $result->fetchAllKeyValue();
  101.             $aOperFilter = array();
  103.             foreach ($sales as $item) {
  104.                 $aOperFilter[] = $item;
  105.             }
  107.             $filterPatent = '';
  108.             if ($patentFilter == 'true') {
  109.                 $filterPatent = "
  110.                 LEFT JOIN car c ON c.id = cb.car_id
  111.                 WHERE c.patent like '%$search%'";
  112.             }
  114.             $query = "
  115.                 SELECT DISTINCT cb.client_id, cb.client_id
  116.                 FROM car_buy cb  
  117.                 $filterPatent
  118.             ";
  119.             $em = $this->getDoctrine()->getManager();
  120.             $db = $em->getConnection();
  121.             $stmt   = $db->prepare($query);
  122.             $result = $stmt->executeQuery();
  123.             $purchases = $result->fetchAllKeyValue();
  125.             foreach ($purchases as $item) {
  126.                 $aOperFilter[] = $item;
  127.             }
  129.             //dump($aOperFilter); exit();
  130.             //dump(implode(',', $aOperFilter)); exit();
  132.             if (count($aOperFilter) > 0) {
  133.                 $data = $data->andWhere('c.id IN (:clients)')
  134.                     ->setParameter(':clients', $aOperFilter);
  135.             } else if ($patentFilter == 'true') {
  136.                 $data = $data->andWhere('c.id IN (:clients)')
  137.                     ->setParameter(':clients', 0);
  138.             }
  139.         }
  141.         //echo $search.'<br>'; print_r($aOperFilter); exit();
  142.         //echo $data->getQuery()->getSQL(); exit();
  144.         $total = $data->getQuery()
  145.             ->getArrayResult();
  147.         $data = $data->setFirstResult($startPage)
  148.             ->setMaxResults($sizePage)
  149.             ->getQuery()
  150.             ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  151.             ->getArrayResult();
  153.         //dump($total); exit();
  155.         //dump($data); exit();
  157.         /*
  158.         if ($this->getUser()->getRoles()[0] == 'ROLE_ADMIN') {
  159.             if ($dateFilter == 'true') {
  160.                 $data = $entityRepository->createQueryBuilder('c')
  161.                     ->leftJoin('c.user', 'u')
  162.                     ->addSelect('u')
  163.                     ->where('c.id > :id')
  164.                     ->andWhere('c.firstName like :search')
  165.                     ->orWhere('c.lastName like :search')
  166.                     ->orWhere('c.dni like :search')
  167.                     ->orWhere('c.telephone like :search')
  168.                     ->orWhere('c.cellphone like :search')
  169.                     ->orWhere('c.address like :search')
  170.                     ->andWhere('c.createdAt BETWEEN :dateFrom AND :dateTo')
  171.                     ->setParameter('id', '0')
  172.                     ->setParameter(':search', "%$search%")
  173.                     ->setParameter(':dateFrom', $dateFrom)
  174.                     ->setParameter(':dateTo', $dateTo)
  175.                     ->getQuery()
  176.                     ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  177.                     ->getArrayResult();
  179.                     //dump($data->getSql());
  180.                     //dump($data->getParameters());
  181.                     //exit();
  182.             } else {
  183.                 $data = $entityRepository->createQueryBuilder('c')
  184.                     ->leftJoin('c.user', 'u')
  185.                     ->addSelect('u')
  186.                     ->where('c.id > :id')
  187.                     ->andWhere('c.firstName like :search')
  188.                     ->orWhere('c.lastName like :search')
  189.                     ->orWhere('c.dni like :search')
  190.                     ->orWhere('c.telephone like :search')
  191.                     ->orWhere('c.cellphone like :search')
  192.                     ->orWhere('c.address like :search')
  193.                     ->setParameter('id', '0')
  194.                     ->setParameter(':search', "%$search%")
  195.                     ->getQuery()
  196.                     ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  197.                     ->getArrayResult();
  199.                 //dump($data->getSql()); exit();
  200.             }
  201.         } else {
  202.             if ($dateFilter == 'true') {
  203.                 $data = $entityRepository->createQueryBuilder('c')
  204.                     ->where('c.id > :id')
  205.                     ->andWhere('c.firstName like :search')
  206.                     ->andWhere('c.createdAt BETWEEN :dateFrom AND :dateTo')
  207.                     ->orWhere('c.lastName like :search')
  208.                     ->orWhere('c.dni like :search')
  209.                     ->orWhere('c.telephone like :search')
  210.                     ->orWhere('c.cellphone like :search')
  211.                     ->orWhere('c.address like :search')
  212.                     ->setParameter('id', '0')
  213.                     ->having('c.user = :user')
  214.                     ->setParameter(':search', "%$search%")
  215.                     ->setParameter(':user', $this->getUser()->getId())
  216.                     ->setParameter(':dateFrom', $dateFrom)
  217.                     ->setParameter(':dateTo', $dateTo)
  218.                     ->getQuery()
  219.                     ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  220.                     ->getArrayResult();
  221.             } else {
  222.                 $data = $entityRepository->createQueryBuilder('c')
  223.                     ->where('c.id > :id')
  224.                     ->andWhere('c.firstName like :search')
  225.                     ->orWhere('c.lastName like :search')
  226.                     ->orWhere('c.dni like :search')
  227.                     ->orWhere('c.telephone like :search')
  228.                     ->orWhere('c.cellphone like :search')
  229.                     ->orWhere('c.address like :search')
  230.                     ->setParameter('id', '0')
  231.                     ->having('c.user = :user')
  232.                     ->setParameter(':search', "%$search%")
  233.                     ->setParameter(':user', $this->getUser()->getId())
  234.                     ->getQuery()
  235.                     ->setHint(\Doctrine\ORM\Query::HINT_INCLUDE_META_COLUMNS, true)
  236.                     ->getArrayResult();
  237.             }
  238.         }
  239.         */
  241.         $json_data = array(
  242.             "current" => intval($curPage),
  243.             "rowCount" => $sizePage,
  244.             "total" => count($total),
  245.             "rows" => $data,
  246.         );
  248.         return $this->json($json_data);
  249.     }
  251.     /**
  252.      * @Route("/clientList", name="client_list", methods={"GET", "POST"})
  253.      */
  254.     public function clientList(Request $request, ClientRepository $entityRepository): Response
  255.     {
  256.         $list = '<option value=""></option>';
  257.         $data = $entityRepository->findAll();
  259.         foreach ($data as $item) {
  260.             $list .= '<option value="'.$item->getId().'">'.$item->getFirstName().' '.$item->getLastName().'</option>';
  261.         }
  263.         return new Response($list);
  264.     }
  266.     /**
  267.      * @Route("/", name="client_index", methods={"GET"})
  268.      */
  269.     public function index(ClientRepository $clientRepository, CarSaleRepository $carSaleRepository, CarBuyRepository $carBuyRepository): Response
  270.     {
  271.         $sales     = $carSaleRepository->getCountSales();
  272.         $purchases = $carBuyRepository->getCountPurchases();
  274.         return $this->render('client/index.html.twig', [
  275.             'clients' => $clientRepository->findAll(),
  276.             'currentMenu' => 'client',
  277.             'sales' => $sales,
  278.             'purchases' => $purchases,
  279.         ]);
  280.     }
  282.     /**
  283.      * @Route("/settings", name="client_settings", methods={"GET"})
  284.      */
  285.     public function settings(ClientRepository $clientRepository): Response
  286.     {
  287.         return $this->render('client/settings.html.twig', [
  288.             'clients' => $clientRepository->findAll(),
  289.             'currentMenu' => 'system',
  290.         ]);
  291.     }
  293.     /**
  294.      * @Route("/new", name="client_new", methods={"GET","POST"})
  295.      */
  296.     public function new(Request $request): Response
  297.     {
  298.         $client = new Client();
  299.         $form = $this->createForm(ClientType::class, $client);
  300.         $form->handleRequest($request);
  302.         if ($form->isSubmitted() && $form->isValid()) {
  303.             if ($this->getUser()->getRoles()[0] != 'ROLE_ADMIN') {
  304.                 $client->SetUser($this->getUser());
  305.             }
  307.             $entityManager = $this->getDoctrine()->getManager();
  308.             $entityManager->persist($client);
  309.             $entityManager->flush();
  311.             return $this->redirectToRoute('client_index', [], Response::HTTP_SEE_OTHER);
  312.         }
  314.         return $this->render('client/new.html.twig', [
  315.             'client' => $client,
  316.             'form' => $form->createView(),
  317.             'currentMenu' => 'client',
  318.         ]);
  319.     }
  321.     /**
  322.      * @Route("/new/modal", name="client_new_modal", methods={"GET","POST"})
  323.      */
  324.     public function newModal(Request $request): Response
  325.     {
  326.         $client = new Client();
  327.         $form = $this->createForm(ClientType::class, $client, [
  328.             'action' => $this->generateUrl('client_new_modal')
  329.         ]);
  330.         $form->handleRequest($request);
  332.         if ($form->isSubmitted() && $form->isValid()) {
  333.             if ($this->getUser()->getRoles()[0] != 'ROLE_ADMIN') {
  334.                 $client->SetUser($this->getUser());
  335.             }
  337.             $entityManager = $this->getDoctrine()->getManager();
  338.             $entityManager->persist($client);
  340.             try {
  341.                 $entityManager->flush();
  342.                 $status  = 'success';
  343.                 $message = 'New client created';
  344.                 $clientId   = $client->getId();
  345.             } catch (\Exception $e) {
  346.                 $status = 'error';
  347.                 $message = $e->getMessage();
  348.                 $clientId   = 0;
  349.             }
  351.             $response = array(
  352.                 'status' => $status,
  353.                 'message' => $message,
  354.                 'clientId' => $clientId,
  355.             );
  357.             return $this->json($response);
  358.         }
  360.         return $this->render('client/new_modal.html.twig', [
  361.             'client' => $client,
  362.             'form' => $form->createView(),
  363.             'currentMenu' => 'client',
  364.         ]);
  365.     }
  367.     /**
  368.      * @Route("/{id}", name="client_show", methods={"GET"})
  369.      */
  370.     public function show(Client $client): Response
  371.     {
  372.         return $this->render('client/show.html.twig', [
  373.             'client' => $client,
  374.             'currentMenu' => 'client',
  375.         ]);
  376.     }
  378.     /**
  379.      * @Route("/{id}/modal", name="client_show_modal", methods={"GET"})
  380.      */
  381.     public function showModal(Client $client): Response
  382.     {
  383.         return $this->render('client/show_modal.html.twig', [
  384.             'client' => $client,
  385.             'currentMenu' => 'client',
  386.         ]);
  387.     }
  389.     /**
  390.      * @Route("/{id}/operations", name="client_operations_modal", methods={"GET"})
  391.      */
  392.     public function operationsModal($id, Client $client, CarSaleRepository $carSaleRepository, CarBuyRepository $carBuyRepository): Response
  393.     {
  394.         /*
  395.         $query = "
  396.             SELECT *
  397.             FROM car_sale
  398.             WHERE client_id = $id
  399.         ";
  400.         $em = $this->getDoctrine()->getManager();
  401.         $db = $em->getConnection();
  402.         $stmt      = $db->prepare($query);
  403.         $result    = $stmt->executeQuery();
  404.         $sales = $result->fetchAllKeyValue();
  405.         //$sales = $result->fetchAllAssociativeIndexed();
  406.         */
  408.         $sales     = $carSaleRepository->findBy( ['client' => $id] );
  409.         $purchases = $carBuyRepository->findBy( ['client' => $id] );
  410.         //dump($purchases); exit();
  412.         return $this->render('client/operations_modal.html.twig', [
  413.             'client' => $client,
  414.             'currentMenu' => 'client',
  415.             'sales' => $sales,
  416.             'purchases' => $purchases,
  417.         ]);
  418.     }
  420.     /**
  421.      * @Route("/{id}/notifications", name="client_notifications_modal", methods={"GET"})
  422.      */
  423.     public function notificationsModal($id, Client $client, BrandRepository $entityRepository): Response
  424.     {
  425.         $brand = $entityRepository->createQueryBuilder('b')
  426.             ->indexBy('b', 'b.id')
  427.             ->orderBy('b.name', 'ASC')
  428.             ->getQuery()
  429.             ->getArrayResult();
  431.         return $this->render('client/notifications_modal.html.twig', [
  432.             'client' => $client,
  433.             'currentMenu' => 'client',
  434.             'brand' => $brand,
  435.         ]);
  436.     }
  438.     /**
  439.      * @Route("/{id}/notificationsSave", name="client_notifications_save", methods={"POST"})
  440.      */
  441.     public function notificationsSave($id, Client $client, Request $request): Response
  442.     {
  443.         $notifyByEmail      = $request->get('notification-mail') == 'true' ? 1 : 0;
  444.         $notifyByWhatsapp   = $request->get('notification-whatsapp') == 'true' ? 1 : 0;
  445.         $notifyVehicleEntry = $request->get('notification-vehicle-entry') == 'true' ? 1 : 0;
  447.         $client->setNotifyByEmail($notifyByEmail);
  448.         $client->setNotifyByWhatsapp($notifyByWhatsapp);
  449.         $client->setNotifyVehicleEntry($notifyVehicleEntry);
  451.         $this->getDoctrine()->getManager()->flush();
  453.         return $this->json('1');
  454.     }
  456.     /**
  457.      * @Route("/{id}/notificationsNewCriteria", name="client_notifications_new_criteria", methods={"POST"})
  458.      */
  459.     public function notificationsNewCriteria($id, Client $client, Request $request): Response
  460.     {
  461.         $brand       = $request->get('brand');
  462.         $vehicleName = $request->get('vehicle-name');
  464.         if ($client->getNotifyCriteria() != null && count($client->getNotifyCriteria()) > 0) {
  465.             $data = $client->getNotifyCriteria();
  466.             $data[$brand][$vehicleName] = $vehicleName;
  467.         } else {
  468.             $data[$brand] = array($vehicleName => $vehicleName);
  469.         }
  471.         $client->setNotifyCriteria($data);
  473.         $this->getDoctrine()->getManager()->flush();
  475.         return $this->json('1');
  476.     }
  478.     /**
  479.      * @Route("/{id}/notificationsShowCriteria", name="client_notifications_show_criteria", methods={"POST"})
  480.      */
  481.     public function notificationsShowCriteria(Client $client): Response
  482.     {
  483.         return $this->json($client->getNotifyCriteria());
  484.     }
  486.     /**
  487.      * @Route("/{id}/notificationsDeleteCriteria", name="client_notifications_delete_criteria", methods={"POST"})
  488.      */
  489.     public function notificationsDeleteCriteria(Client $client, Request $request): Response
  490.     {
  491.         $brand    = $request->get('brand');
  492.         $criteria = $request->get('criteria');
  494.         $data = $client->getNotifyCriteria();
  495.         unset($data[$brand][$criteria]);
  497.         $client->setNotifyCriteria($data);
  499.         $this->getDoctrine()->getManager()->flush();
  501.         return $this->json('1');
  502.     }
  504.     /**
  505.      * @Route("/oneNotificationSave", name="client_one_notification_save", methods={"POST"})
  506.      */
  507.     public function oneNotificationSave(ClientRepository $client, Request $request): Response
  508.     {
  509.         $id    = $request->get('id');
  510.         $type  = $request->get('type');
  511.         $state = $request->get('state') == 'true' ? 1 : 0;
  513.         $client = $client->find($id);
  515.         switch ($type) {
  516.             case 'e':
  517.                 $client->setNotifyByEmail($state);
  518.                 break;
  519.             case 'w':
  520.                 $client->setNotifyByWhatsapp($state);
  521.                 break;
  522.             case 'v':
  523.                 $client->setNotifyVehicleEntry($state);
  524.                 break;
  525.         }
  527.         $this->getDoctrine()->getManager()->persist($client);
  528.         $this->getDoctrine()->getManager()->flush();
  530.         return $this->json('1');
  531.     }
  533.     /**
  534.      * @Route("/{id}/edit", name="client_edit", methods={"GET","POST"})
  535.      */
  536.     public function edit(Request $request, Client $client): Response
  537.     {
  538.         $form = $this->createForm(ClientType::class, $client);
  539.         $form->handleRequest($request);
  541.         if ($form->isSubmitted() && $form->isValid()) {
  542.             if ($this->getUser()->getRoles()[0] != 'ROLE_ADMIN') {
  543.                 $client->SetUser($this->getUser());
  544.             }
  546.             $this->getDoctrine()->getManager()->flush();
  548.             return $this->redirectToRoute('client_index', [], Response::HTTP_SEE_OTHER);
  549.         }
  551.         return $this->render('client/edit.html.twig', [
  552.             'client' => $client,
  553.             'form' => $form->createView(),
  554.             'currentMenu' => 'client',
  555.         ]);
  556.     }
  558.     /**
  559.      * @Route("/{id}", name="client_delete", methods={"POST"})
  560.      */
  561.     public function delete(Request $request, Client $client): Response
  562.     {
  563.         if ($this->isCsrfTokenValid('delete'.$client->getId(), $request->request->get('_token'))) {
  564.             $entityManager = $this->getDoctrine()->getManager();
  565.             $entityManager->remove($client);
  566.             $entityManager->flush();
  567.         }
  569.         return $this->redirectToRoute('client_index', [], Response::HTTP_SEE_OTHER);
  570.     }
  572.     /**
  573.      * @Route("/{id}/delete", name="client_delete_ra", methods={"GET"})
  574.      */
  575.     public function deleteRa(Request $request): Response
  576.     {
  577.         $entityManager = $this->getDoctrine()->getManager();
  578.         $user = $entityManager->getReference(\App\Entity\Client::class, $request->get('id'));
  579.         $entityManager->remove($user);
  580.         $entityManager->flush();
  582.         return $this->redirectToRoute('client_index', [], Response::HTTP_SEE_OTHER);
  583.     }
  584. }