src/Controller/TicketController.php line 1576

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\Product;
  6. use App\Entity\Supportcase;
  7. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  8. use Symfony\Component\HttpFoundation\Response;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\Routing\Annotation\Route;
  11. use Symfony\Contracts\Translation\TranslatorInterface;
  12. use App\Service\TrafficTracker;
  13. use App\Service\Translation;
  14. use App\Entity\User;
  15. use App\Entity\Ticket;
  16. use App\Entity\TicketComercial;
  17. use App\Entity\Tickettecnico;
  18. use App\Entity\Tipoticket;
  19. use App\Service\ReportingColors;
  20. use App\Service\ProductlineJsonTree;
  21. use App\Form\Type\TicketEditType;
  22. use App\Service\ServiceNotification;
  23. use Symfony\Component\HttpKernel\Exception\AccessDeniedHttpException;
  24. use App\Form\Ticket\MessageSupport;
  25. use Psr\Log\LoggerInterface;
  26. use Symfony\Component\HttpFoundation\JsonResponse;
  27. use App\Service\ExtensionFileService;
  28. use PhpOffice\PhpSpreadsheet\Calculation\Web\Service;
  30. class TicketController extends AbstractController
  31. {
  32.     protected static $level = 1;
  34.     /**
  35.      * @Route("/ticket/default/index", name="ticket_index")
  36.      */
  37.     public function index(TrafficTracker $trafficTracker, Translation $translation, ReportingColors $reportingColors, Request $request, LoggerInterface $logger): Response
  38.     {
  39.         $trafficTracker->registerTraffic();
  40.         $entityManager = $this->getDoctrine()->getManager();
  41.         $locale = $request->getLocale();
  42.         $user = $this->getUser();
  43.         $dataM = array();
  44.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  45.         $ticketmonthpreview[1] = 0;
  46.         $tickettotalYearPrev[1] = 0;
  47.         $ticketmonth[1] = 0;
  48.         $tickettotalYear[1] = 0;
  50.         /* datos de mis incidencia */
  52.         $incidencias = $entityManager->createQuery('SELECT sc'
  53.             . ' FROM App\Entity\Supportcase sc'
  54.             . ' WHERE sc.createdby = :user')
  55.             ->setParameter('user', $user)
  56.             ->getResult();
  58.         foreach ($incidencias as $incidencia) {
  59.             $ticketRepository = $this->getDoctrine()->getRepository(Ticket::class);
  60.             $supportcaseRepository = $this->getDoctrine()->getRepository(\App\Entity\Supportcase::class);
  62.             $userLevel = $userRepository->getUserLevel($request, $user);
  64.             $logger->info('>>>> Ticket Logs <<<< Case: ' . $incidencia->getId() . ' user: ' . $user->getId() . ' level: ' . $userLevel);
  65.             $myTicket = $entityManager->createQuery('SELECT t'
  66.                 . ' FROM App\Entity\Ticket t'
  67.                 . ' WHERE t.supportcase = :incidencia'
  68.                 . ' AND t.level = :level')
  69.                 ->setParameter('incidencia', $incidencia)
  70.                 ->setParameter('level', $userLevel)
  71.                 ->getOneOrNullResult();
  72.             $logger->info('>>>> End Ticket Logs <<<< Case: ' . $incidencia->getId() . ' user: ' . $user->getId() . ' level: ' . $userLevel);
  74.             $dataM[] = array(
  75.                 'id' => $incidencia->getId(),
  76.                 'tipo' => $translation->getTranslationBy($incidencia->getTipoTicket(), $locale, 'nombretipo'),
  77.                 'creationDate' => $incidencia->getCreationdate(),
  78.                 'orderDate' => $incidencia->getCreationdate()->format('Ymdhms'),
  79.                 'status' => $myTicket ? $myTicket->getStatus() : '',
  80.                 'subject' => $incidencia->getSubject(),
  81.                 'supportCaseId' => $supportcaseRepository->getSupportCaseId10Digits($incidencia),
  82.                 'myTicket' => $myTicket,
  83.                 'statusTicket' => $myTicket ? $ticketRepository->getStatusTicket($user, $myTicket) : '',
  84.             );
  85.         }
  87.         $ticketTipesToShow = array();
  88.         if ($userRepository->hasSupportRole($user)) {
  89.             $ticketTipesToShow[] = 1;
  90.         }
  91.         if ($userRepository->hasAdminRole($user)) {
  92.             $ticketTipesToShow[] = 2;
  93.         }
  94.         if ($userRepository->hasSeminarRole($user)) {
  95.             $ticketTipesToShow[] = 3;
  96.         }
  97.         if ($userRepository->hasCommercialRole($user)) {
  98.             $ticketTipesToShow[] = 4;
  99.         }
  101.         //Informacion de ticket segun Rol
  102.         //si el user es vendor
  103.         if ($user->getVendor()) {
  104.             $ticketmonth = $entityManager->createQuery('SELECT SUM(dv.ticket)'
  105.                 . ' FROM App\Entity\Dwvendor dv'
  106.                 . ' WHERE dv.vendor = :vendor'
  107.                 . ' AND dv.year = :year'
  108.                 . ' AND dv.month = :month')
  109.                 ->setParameter('vendor', $user->getVendor())
  110.                 ->setParameter('year', date('Y'))
  111.                 ->setParameter('month', date('n'))
  112.                 ->getOneOrNullResult();
  114.             $ticketmonthpreview = $entityManager->createQuery('SELECT SUM(dv.ticket)'
  115.                 . ' FROM App\Entity\Dwvendor dv'
  116.                 . ' WHERE dv.vendor = :vendor'
  117.                 . ' AND dv.year = :year'
  118.                 . ' AND dv.month = :month')
  119.                 ->setParameter('vendor', $user->getVendor())
  120.                 ->setParameter('year', date('Y'))
  121.                 ->setParameter('month', date('n') - 1)
  122.                 ->getOneOrNullResult();
  124.             $tickettotalYear = $entityManager->createQuery('SELECT SUM(dv.ticket)'
  125.                 . ' FROM App\Entity\Dwvendor dv'
  126.                 . ' WHERE dv.vendor = :vendor'
  127.                 . ' AND dv.year = :year')
  128.                 ->setParameter('vendor', $user->getVendor())
  129.                 ->setParameter('year', date('Y'))
  130.                 ->getOneOrNullResult();
  132.             $tickettotalYearPrev = $entityManager->createQuery('SELECT SUM(dv.ticket)'
  133.                 . ' FROM App\Entity\Dwvendor dv'
  134.                 . ' WHERE dv.vendor = :vendor'
  135.                 . ' AND dv.year = :year')
  136.                 ->setParameter('vendor', $user->getVendor())
  137.                 ->setParameter('year', date('Y') - 1)
  138.                 ->getOneOrNullResult();
  139.         } else
  141.             //si el user logueado es wholesaler
  142.             if ($user->getWholesaler()) {
  143.                 $fecha = new \DateTime();
  144.                 $month = $fecha->format('n');
  145.                 $year = $fecha->format('Y');
  147.                 if ($month == 1) {
  148.                     $monthp = 12;
  149.                     $yearp = $year - 1;
  150.                 } else {
  151.                     $monthp = $month - 1;
  152.                     $yearp = $year;
  153.                 }
  155.                 $ticketmonth = $entityManager->createQuery('SELECT SUM(dw.ticket)'
  156.                     . ' FROM App\Entity\Dwwholesaler dw'
  157.                     . ' WHERE dw.wholesaler = :wholesaler'
  158.                     . ' AND dw.year = :year'
  159.                     . ' AND dw.month = :month')
  160.                     ->setParameter('wholesaler', $user->getWholesaler())
  161.                     ->setParameter('year', $year)
  162.                     ->setParameter('month', $month)
  163.                     ->getOneOrNullResult();
  165.                 $ticketmonthpreview = $entityManager->createQuery('SELECT SUM(dw.ticket)'
  166.                     . ' FROM App\Entity\Dwwholesaler dw'
  167.                     . ' WHERE dw.wholesaler = :wholesaler'
  168.                     . ' AND dw.year = :year'
  169.                     . ' AND dw.month = :month')
  170.                     ->setParameter('wholesaler', $user->getWholesaler())
  171.                     ->setParameter('year', $yearp)
  172.                     ->setParameter('month', $monthp)
  173.                     ->getOneOrNullResult();
  175.                 $tickettotalYear = $entityManager->createQuery('SELECT SUM(dw.ticket)'
  176.                     . ' FROM App\Entity\Dwwholesaler dw'
  177.                     . ' WHERE dw.wholesaler = :wholesaler'
  178.                     . ' AND dw.year = :year')
  179.                     ->setParameter('wholesaler', $user->getWholesaler())
  180.                     ->setParameter('year', $year)
  181.                     ->getOneOrNullResult();
  183.                 $tickettotalYearPrev = $entityManager->createQuery('SELECT SUM(dw.ticket)'
  184.                     . ' FROM App\Entity\Dwwholesaler dw'
  185.                     . ' WHERE dw.wholesaler = :wholesaler'
  186.                     . ' AND dw.year = :year')
  187.                     ->setParameter('wholesaler', $user->getWholesaler())
  188.                     ->setParameter('year', $yearp)
  189.                     ->getOneOrNullResult();
  190.             } else
  191.                 //si el user logueado es Partner
  192.                 if ($user->getPartner()) {
  193.                     $ticketmonth = $entityManager->createQuery('SELECT SUM(dp.ticket)'
  194.                         . ' FROM App\Entity\Dwpartner dp'
  195.                         . ' WHERE dp.partner = :partner'
  196.                         . ' AND dp.year = :year'
  197.                         . ' AND dp.month = :month')
  198.                         ->setParameter('partner', $user->getPartner())
  199.                         ->setParameter('year', date('Y'))
  200.                         ->setParameter('month', date('n'))
  201.                         ->getOneOrNullResult();
  203.                     $ticketmonthpreview = $entityManager->createQuery('SELECT SUM(dp.ticket)'
  204.                         . ' FROM App\Entity\Dwpartner dp'
  205.                         . ' WHERE dp.partner = :partner'
  206.                         . ' AND dp.year = :year'
  207.                         . ' AND dp.month = :month')
  208.                         ->setParameter('partner', $user->getPartner())
  209.                         ->setParameter('year', date('Y'))
  210.                         ->setParameter('month', date('n') - 1)
  211.                         ->getOneOrNullResult();
  213.                     $tickettotalYear = $entityManager->createQuery('SELECT SUM(dp.ticket)'
  214.                         . ' FROM App\Entity\Dwpartner dp'
  215.                         . ' WHERE dp.partner = :partner'
  216.                         . ' AND dp.year = :year')
  217.                         ->setParameter('partner', $user->getPartner())
  218.                         ->setParameter('year', date('Y'))
  219.                         ->getOneOrNullResult();
  221.                     $tickettotalYearPrev = $entityManager->createQuery('SELECT SUM(dp.ticket)'
  222.                         . ' FROM App\Entity\Dwpartner dp'
  223.                         . ' WHERE dp.partner = :partner'
  224.                         . ' AND dp.year = :year')
  225.                         ->setParameter('partner', $user->getPartner())
  226.                         ->setParameter('year', date('Y') - 1)
  227.                         ->getOneOrNullResult();
  228.                 } else
  230.                     //si el user logueado es Customer
  231.                     if ($user->getCustomer()) {
  232.                         $ticketmonth = $entityManager->createQuery('SELECT SUM(dc.ticket)'
  233.                             . ' FROM App\Entity\Dwcustomer dc'
  234.                             . ' WHERE dc.customer = :customer'
  235.                             . ' AND dc.year = :year'
  236.                             . ' AND dc.month = :month')
  237.                             ->setParameter('customer', $user->getCustomer())
  238.                             ->setParameter('year', date('Y'))
  239.                             ->setParameter('month', date('n'))
  240.                             ->getOneOrNullResult();
  242.                         $ticketmonthpreview = $entityManager->createQuery('SELECT SUM(dc.ticket)'
  243.                             . ' FROM App\Entity\Dwcustomer dc'
  244.                             . ' WHERE dc.customer = :customer'
  245.                             . ' AND dc.year = :year'
  246.                             . ' AND dc.month = :month')
  247.                             ->setParameter('customer', $user->getCustomer())
  248.                             ->setParameter('year', date('Y'))
  249.                             ->setParameter('month', date('n') - 1)
  250.                             ->getOneOrNullResult();
  252.                         $tickettotalYear = $entityManager->createQuery('SELECT SUM(dc.ticket)'
  253.                             . ' FROM App\Entity\Dwcustomer dc'
  254.                             . ' WHERE dc.customer = :customer'
  255.                             . ' AND dc.year = :year')
  256.                             ->setParameter('customer', $user->getCustomer())
  257.                             ->setParameter('year', date('Y'))
  258.                             ->getOneOrNullResult();
  260.                         $tickettotalYearPrev = $entityManager->createQuery('SELECT SUM(dc.ticket)'
  261.                             . ' FROM App\Entity\Dwcustomer dc'
  262.                             . ' WHERE dc.customer = :customer'
  263.                             . ' AND dc.year = :year')
  264.                             ->setParameter('customer', $user->getCustomer())
  265.                             ->setParameter('year', date('Y') - 1)
  266.                             ->getOneOrNullResult();
  267.                     }
  269.         $ticketmonthporcent = $ticketmonthpreview[1] ? (100 * ($ticketmonth[1] - $ticketmonthpreview[1]) / $ticketmonthpreview[1]) : 0;
  270.         $ticketyearporcentprev = $tickettotalYearPrev[1] ? (100 * ($tickettotalYear[1] - $tickettotalYearPrev[1]) / $tickettotalYearPrev[1]) : 0;
  272.         return $this->render('ticket/index.html.twig', [
  273.             'dataM' => $dataM,
  274.             'ticketmonth' => $ticketmonth[1] ? $ticketmonth[1] : 0,
  275.             'ticketmonthporcent' => $ticketmonthporcent,
  276.             'ticketyears' => $tickettotalYear[1] ? $tickettotalYear[1] : 0,
  277.             'ticketyearporcent' => $ticketyearporcentprev,
  278.             'estadosticket' => json_encode($this->SupportTicketByStatus($reportingColors, $user)),
  279.         ]);
  280.     }
  282.     /**
  283.      * @Route("/ticket/default/indexclient", name="ticket_indexclient")
  284.      */
  285.     public function indexclient(TrafficTracker $trafficTracker, Translation $translation, ReportingColors $reportingColors, Request $request): Response
  286.     {
  287.         $trafficTracker->registerTraffic();
  288.         $entityManager = $this->getDoctrine()->getManager();
  289.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  290.         $supportcaseRepository = $this->getDoctrine()->getRepository(\App\Entity\Supportcase::class);
  291.         $locale = $request->getLocale();
  292.         $user = $this->getUser();
  293.         $dataC = array();
  294.         $incidencias = array();
  295.         $katy = false;
  297.         $ticketTipesToShow = array();
  298.         if ($userRepository->hasSupportRole($user) || $userRepository->hasRole($user, "ROLE_SUPPORT_TECHNICAL")) {
  299.             $ticketTipesToShow[] = 1;
  300.         }
  301.         if ($userRepository->hasAdminRole($user) || $userRepository->hasRole($user, "ROLE_SUPPORT_ADMINISTRATIVE")) {
  302.             $ticketTipesToShow[] = 2;
  303.         }
  305.         $katySupportUser = $entityManager->createQuery('SELECT distinct u'
  306.             . ' FROM App\Entity\User u'
  307.             . ' WHERE u.id = :user'
  308.             . ' AND u.roles like :role_one')
  309.             ->setParameter('user', $user)
  310.             ->setParameter('role_one', '%ROLE_SUPPORT_KATY%')
  311.             ->getOneOrNullResult();
  313.         $katySupportManagementUser = $entityManager->createQuery('SELECT distinct u'
  314.             . ' FROM App\Entity\User u'
  315.             . ' WHERE u.id = :user'
  316.             . ' AND u.roles like :role_one')
  317.             ->setParameter('user', $user)
  318.             ->setParameter('role_one', '%ROLE_SUPPORT_MANAGEMENT_KATY%')
  319.             ->getOneOrNullResult();
  321.         $katySupportBIUser = $entityManager->createQuery('SELECT distinct u'
  322.             . ' FROM App\Entity\User u'
  323.             . ' WHERE u.id = :user'
  324.             . ' AND u.roles like :role_one')
  325.             ->setParameter('user', $user)
  326.             ->setParameter('role_one', '%ROLE_BI_MANAGER%')
  327.             ->getOneOrNullResult();
  329.         $katySupportAdminUser = $entityManager->createQuery('SELECT distinct u'
  330.             . ' FROM App\Entity\User u'
  331.             . ' WHERE u.id = :user'
  332.             . ' AND u.roles like :role_one')
  333.             ->setParameter('user', $user)
  334.             ->setParameter('role_one', '%ROLE_SUPPORT_ADMIN_KATY%')
  335.             ->getOneOrNullResult();
  338.         //search the katy support type roles to show
  339.         $ticketKatyTypesToShow = array();
  340.         if ($katySupportUser) {
  341.             $ticketKatyTypesToShow[] = 4;
  342.         }
  343.         if ($katySupportBIUser) {
  344.             $ticketKatyTypesToShow[] = 5;
  345.         }
  346.         if ($katySupportManagementUser) {
  347.             $ticketKatyTypesToShow[] = 6;
  348.         }
  351.         //incidencias de canal                
  352.         if ($user->getVendor() && $user->getVendor()->getisMiniVendor()) {
  353.             $supportcaseQ = $supportcaseRepository->MySupportCaseQuery($user);
  354.             $supportcaseQ->andWhere('s.createdby != :user');
  355.             $supportcaseQ->setParameter('user', $user);
  356.             $supportcaseQ->andwhere('s.tipoticket in (:tipo)');
  357.             $supportcaseQ->setParameter('tipo', $ticketTipesToShow);
  358.         } elseif ($katySupportUser || $katySupportManagementUser || $katySupportBIUser) {
  359.             //show platform technical tickets and/or platform management tickets and/or bi tickets
  360.             $supportcaseQ = $supportcaseRepository->MySupportCaseQuery($user);
  361.             $supportcaseQ->andwhere('s.tipoticket in (:tipo)');
  362.             $supportcaseQ->andWhere('s.createdby != :user');
  363.             $supportcaseQ->innerJoin('\App\Entity\Ticket', 't', 'WITH', 't.supportcase = s.id');
  364.             $supportcaseQ->andWhere('t.status != :closed OR t.creationdate >= :limitDate');
  365.             $supportcaseQ->setParameter('closed', 'closed');
  366.             $supportcaseQ->setParameter('limitDate', (new \DateTime())->modify('-3 months'));
  367.             $supportcaseQ->setParameter('tipo', $ticketKatyTypesToShow);
  368.             $supportcaseQ->setParameter('user', $user);
  369.         } else {
  371.             $supportcaseQ = $supportcaseRepository->MySupportCaseQuery($user);
  372.             $supportcaseQ->andWhere('s.createdby != :user');
  373.             $supportcaseQ->setParameter('user', $user);
  374.             $supportcaseQ->andWhere('s.tipoticket in (:tipo)');
  375.             $supportcaseQ->setParameter('tipo', $ticketTipesToShow);
  376.             $supportcaseQ->innerJoin('\App\Entity\Ticket', 't', 'WITH', 't.supportcase = s.id');
  377.             $supportcaseQ->andWhere('t.level = :level');
  378.             $supportcaseQ->setParameter('level', $userRepository->getUserLevel($request, $user) + 1);
  379.             $supportcaseQ->andWhere('t.status != :closed OR t.creationdate >= :limitDate');
  380.             $supportcaseQ->setParameter('closed', 'closed');
  381.             $supportcaseQ->setParameter('limitDate', (new \DateTime())->modify('-3 months'));
  382.             $supportcaseQ->orderBy('s.creationdate', 'DESC');
  383.         }
  385.         $incidencias = $supportcaseQ->getQuery()->execute();
  387.         if ($katySupportAdminUser) {
  388.             //show administrative vendor tickets
  389.             $supportcaseQ = $supportcaseRepository->MySupportCaseQuery($user);
  390.             $supportcaseQ->innerJoin('\App\Entity\Ticket', 't', 'WITH', ' t.supportcase = s.id');
  391.             $supportcaseQ->andwhere('s.tipoticket = :tipo');
  392.             $supportcaseQ->andwhere('t.level = 1');
  393.             $supportcaseQ->setParameter('tipo', 2);
  395.             $incidencias2 = $supportcaseQ->getQuery()->execute();
  396.             $incidencias = array_merge($incidencias, $incidencias2);
  397.         }
  399.         if (($userRepository->hasCommercialRole($user) || $user->getMaster() || $userRepository->hasRole($user, "ROLE_SUPPORT_COMMERCIAL")) && !$katySupportUser
  400.             && !$katySupportManagementUser && !$katySupportAdminUser && !$katySupportBIUser
  401.         ) {
  402.             $ticketTipesToShow[] = 3;
  404.             if ($user->getMaster()) {
  406.                 $supportcaseQ->setParameter('tipo', '3');
  407.             } elseif ($user->getPartner()) {
  408.                 $supportcaseQ->andWhere('c.idcommercialagent = :user2');
  409.                 $supportcaseQ->setParameter('user2', $user);
  410.                 $supportcaseQ->setParameter('tipo', '3');
  411.             } elseif ($user->getWholesaler()) {
  412.                 $supportcaseQ->andWhere('pu.idcommercialagent = :user2');
  413.                 $supportcaseQ->setParameter('user2', $user->getId());
  414.                 $supportcaseQ->setParameter('tipo', '3');
  415.             }
  416.             $incidencias2 = $supportcaseQ->getQuery()->execute();
  417.             $incidencias = array_merge($incidencias, $incidencias2);
  418.         }
  420.         foreach ($incidencias as $incidencia) {
  422.             if ($user->getVendor() && $user->getVendor()->getisMiniVendor()) {
  423.                 $ticketToMe = $entityManager->createQuery('SELECT t'
  424.                     . ' FROM App\Entity\Ticket t'
  425.                     . ' WHERE t.supportcase = :supportcase')
  426.                     ->setParameter('supportcase', $incidencia)
  427.                     ->getOneOrNullResult();
  429.                 $myTicket = $entityManager->createQuery('SELECT t'
  430.                     . ' FROM App\Entity\Ticket t'
  431.                     . ' WHERE t.supportcase = :supportcase')
  432.                     ->setParameter('supportcase', $incidencia)
  433.                     ->getOneOrNullResult();
  434.             } else {
  435.                 if ($katySupportUser || $katySupportManagementUser || $katySupportAdminUser || $katySupportBIUser) { //if user katy
  436.                     $ticketToMe = $entityManager->createQuery('SELECT t'
  437.                         . ' FROM App\Entity\Ticket t'
  438.                         . ' WHERE t.supportcase = :supportcase')
  439.                         ->setParameter('supportcase', $incidencia)
  440.                         ->getOneOrNullResult();
  441.                 } else {
  442.                     $ticketToMe = $entityManager->createQuery('SELECT t'
  443.                         . ' FROM App\Entity\Ticket t'
  444.                         . ' WHERE t.supportcase = :supportcase'
  445.                         . ' AND t.level = :level')
  446.                         ->setParameter('supportcase', $incidencia)
  447.                         ->setParameter('level', $userRepository->getUserLevel($request, $user) + 1)
  448.                         ->getOneOrNullResult();
  449.                 }
  451.                 $myTicket = $entityManager->createQuery('SELECT t'
  452.                     . ' FROM App\Entity\Ticket t'
  453.                     . ' WHERE t.supportcase = :supportcase'
  454.                     . ' AND t.level = :level')
  455.                     ->setParameter('supportcase', $incidencia)
  456.                     ->setParameter('level', $userRepository->getUserLevel($request, $user))
  457.                     ->getOneOrNullResult();
  458.             }
  460.             $companyName = 'KATY';
  461.             $level = 0;
  463.             if ($incidencia->getCreatedby()->getCustomer()) {
  464.                 $customerName = $userRepository->getCompanyName($incidencia->getCreatedby());
  465.                 $companyName = $customerName;
  466.                 $level = 4;
  467.                 $partnerName = $incidencia->getCreatedby()->getCustomer()->getPartner()->getName();
  468.             } else {
  469.                 $customerName = null;
  470.             }
  472.             if ($incidencia->getCreatedby()->getPartner()) {
  473.                 $partnerName = $userRepository->getCompanyName($incidencia->getCreatedby());
  474.                 $companyName = $partnerName;
  475.                 $level = 3;
  476.                 if ($incidencia->getTipoTicket()->getId() === 1) {
  477.                     $TicketTecnico =  $entityManager->getRepository(\App\Entity\Tickettecnico::class)->find($incidencia);
  478.                     if ($TicketTecnico) {
  479.                         $customerName = $TicketTecnico->getCustomer() ? $TicketTecnico->getCustomer()->getCompany() : '';
  480.                     }
  481.                 }
  482.             } else {
  483.                 $partnerName = null;
  484.             }
  486.             if ($incidencia->getCreatedby()->getWholesaler()) {
  487.                 $companyName = $incidencia->getCreatedby()->getWholesaler()->getName();
  488.                 $level = 2;
  489.             }
  491.             if ($incidencia->getCreatedby()->getVendor()) {
  492.                 $companyName = $incidencia->getCreatedby()->getVendor()->getName();
  493.                 $level = 1;
  494.             }
  497.             $ticketRepository = $entityManager->getRepository(\App\Entity\Ticket::class);
  498.             $supportcaseRepository = $entityManager->getRepository(\App\Entity\Supportcase::class);
  499.             $supportCaseId = $supportcaseRepository->getSupportCaseId10Digits($incidencia);
  501.             if (!$user->getVendor() && !$user->getWholesaler() && !$user->getPartner() && !$user->getCustomer()) {
  502.                 $katy = true;
  503.             }
  505.             if (!$user->getVendor() && !$supportcaseRepository->isToMinivendor($incidencia)) {
  507.                 $dataC[] = array(
  508.                     'id' => $incidencia->getId(),
  509.                     'number' => $ticketToMe ? $ticketToMe->getSupportCase()->getId() : 'N/A',
  510.                     'tipo' => $translation->getTranslationBy($incidencia->getTipoticket(), $locale, 'nombretipo'),
  511.                     'creationDate' => $ticketToMe ? $ticketToMe->getCreationdate() : $incidencia->getCreationdate(),
  512.                     'orderDate' => $ticketToMe ? $ticketToMe->getCreationdate()->format('Ymdhms') : $incidencia->getCreationdate()->format('Ymdhms'),
  513.                     'status' => $ticketToMe ? $ticketToMe->getStatus() : '',
  514.                     'subject' => $incidencia->getSubject(),
  515.                     'userlevel' => $userRepository->getUserLevel($request, $user),
  516.                     'companyName' => $companyName,
  517.                     'level' => $level,
  518.                     'Partnername' => $partnerName,
  519.                     'supportCaseId' => $supportCaseId,
  520.                     'ClientName' => $customerName,
  521.                     'myTicket' => $myTicket ? $ticketRepository->getStatusTicket($user, $myTicket) : '-',
  522.                     'ticketToMe' => $ticketToMe ? $ticketRepository->getStatusTicket($user, $ticketToMe) : '-',
  523.                 );
  524.             } else {
  525.                 if ($user->getVendor()) {
  526.                     $dataC[] = array(
  527.                         'id' => $incidencia->getId(),
  528.                         'number' => $ticketToMe ? $ticketToMe->getSupportCase()->getId() : 'N/A',
  529.                         'tipo' => $translation->getTranslationBy($incidencia->getTipoticket(), $locale, 'nombretipo'),
  530.                         'creationDate' => $incidencia->getCreationdate(),
  531.                         'orderDate' => $incidencia->getCreationdate()->format('Ymdhms'),
  532.                         'status' => $ticketToMe ? $ticketToMe->getStatus() : '',
  533.                         'subject' => $incidencia->getSubject(),
  534.                         'userlevel' => $userRepository->getUserLevel($request, $user),
  535.                         'Partnername' => $partnerName,
  536.                         'supportCaseId' => $supportCaseId,
  537.                         'ClientName' => $customerName,
  538.                         'myTicket' => $myTicket ? $ticketRepository->getStatusTicket($user, $myTicket) : '-',
  539.                         'ticketToMe' => $ticketToMe ? $ticketRepository->getStatusTicket($user, $ticketToMe) : '-',
  540.                     );
  541.                 }
  542.             }
  543.         }
  546.         return $this->render('ticket/indexclient.html.twig', [
  547.             'dataC' => $dataC,
  548.             'isKatyUser' => $katy,
  549.             //'estadosticket' => json_encode($this->SupportTicketByStatus($reportingColors, $user)),
  550.         ]);
  551.     }
  553.     /**
  554.      * @Route("/ticket/default/new/{product}", defaults={"product"=null}, name="ticket_new")
  555.      */
  556.     public function new($product, TrafficTracker $trafficTracker, TranslatorInterface $translator, ServiceNotification $serviceNotification, ProductlineJsonTree $jsonTreeService, Translation $translation, Request $request): Response
  557.     {
  558.         $trafficTracker->registerTraffic();
  559.         $entityManager = $this->getDoctrine()->getManager();
  560.         $locale = $request->getLocale();
  561.         $user = $this->getUser();
  562.         $licenses = array();
  563.         $session = $this->get('session');
  564.         $jsonData = $jsonTreeService->getJsonTree(null, $locale, $user, true, true);
  565.         $ticket = new Ticket();
  567.         // Create form
  569.         if ($user->getCustomer()) {
  570.             $licenses = $entityManager->createQuery('SELECT l'
  571.                 . ' FROM App\Entity\License l'
  572.                 . ' WHERE l.customer = :customer')
  573.                 ->setParameter('customer', $user->getCustomer())
  574.                 ->getResult();
  575.         }
  577.         $form = $this->createForm(TicketEditType::class, $ticket, array(
  578.             'licenses' => $licenses,
  579.             'user' => $user,
  580.             'locale' => $locale,
  581.             'translator' => $translator,
  582.             'entityManager' => $entityManager,
  583.             'translation' => $translation,
  584.             'product' => $product
  585.         ));
  587.         // If submitted
  588.         $form->handleRequest($request);
  589.         // If cancelled
  590.         if ($form->getClickedButton() && 'cancel' === $form->getClickedButton()->getName()) {
  591.             $session->getFlashBag()->add('warning', $translator->trans('app.General.SystemMessages.NotCreated'));
  592.             return $this->redirectToRoute('ticket_index');
  593.         }
  595.         if ($form->isSubmitted()) {
  596.             if ($form->isValid()) {
  597.                 $tipoTicket =  $this->getDoctrine()->getRepository(Tipoticket::class)->find($_POST['ticket_edit']['tipoincidencia']);
  599.                 if ($tipoTicket->getId() == 1 && $user->getWholesaler()) {
  600.                     if (!isset($_POST['ticket_edit']['idproductline']) || $_POST['ticket_edit']['idproductline'] == '') {
  601.                         $session->getFlashBag()->add('danger', $translator->trans('app.Support.System.VendorNotSelected'));
  602.                         return $this->redirectToRoute('ticket_new');
  603.                     }
  604.                 }
  606.                 $this->createNewSupportCase($request, $_POST['ticket_edit'], $translator, $serviceNotification, $form);
  607.                 // Redirect and show result
  608.                 $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.Created'));
  609.                 return $this->redirectToRoute('ticket_index');
  610.             } else {
  612.                 //If form is not valid return flahsbag with errors
  613.                 $string = $this->getErrorMessages($form);
  615.                 foreach ($string as $clave => $valor) {
  616.                     $session->getFlashBag()->add('danger', $valor[0]);
  617.                 }
  619.                 return $this->redirectToRoute('ticket_index');
  620.             }
  621.         }
  623.         return $this->render('ticket/new.html.twig', [
  624.             'form' => $form->createView(),
  625.             'treedata' => $jsonData,
  626.             'product' => $product
  627.         ]);
  628.     }
  630.     /**
  631.      * @Route("/ticket/default/reply/{id}", name="ticket_reply", requirements={"id"="\d+"})
  632.      */
  633.     public function reply(TrafficTracker $trafficTracker, TranslatorInterface $translator, ServiceNotification $serviceNotification, Translation $translation, Request $request, $id = 0)
  634.     {
  635.         $trafficTracker->registerTraffic();
  636.         $session = $this->get('session');
  637.         $entityManager = $this->getDoctrine()->getManager();
  638.         $locale = $request->getLocale();
  639.         $user = $this->getUser();
  640.         $userRepository = $entityManager->getRepository(\App\Entity\User::class);
  641.         $selfUserLevel = $userRepository->getUserLevel($request, $user);
  642.         // Find ticket               
  643.         $supportCaseRepository = $entityManager->getRepository(\App\Entity\Supportcase::class);
  644.         $case = $supportCaseRepository->find($id);
  645.         $companiesData = ['partner' => 'N/A', 'customer' => 'N/A'];
  647.         $ticketRepository = $entityManager->getRepository(\App\Entity\Ticket::class);
  648.         $ticketQ = $ticketRepository->MyTicketQuery($user);
  649.         $ticketQ->andWhere('t.supportcase = :supportCase');
  650.         $ticketQ->setParameter('supportCase', $id);
  651.         $ticketQ->andwhere('t.level = :level');
  652.         $ticketQ->setParameter('level', $selfUserLevel);
  653.         $ticketR = $ticketQ->getQuery()->execute();
  655.         $myTicket = $ticketR[0];
  657.         if (!$myTicket) {
  658.             throw new AccessDeniedHttpException();
  659.         }
  661.         if (!$case) {
  662.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.TicketNotFound'));
  663.             return $this->redirectToRoute('ticket_index');
  664.         }
  666.         $userlist = array();
  668.         // notificar user mayorista
  669.         if ($user->getWholesaler()) {
  670.             $userlist = $entityManager->createQuery('SELECT u'
  671.                 . ' FROM App\Entity\User u'
  672.                 . ' WHERE u.wholesaler = :wholesaler'
  673.                 . ' AND u.id != :id')
  674.                 ->setParameter('wholesaler', $user->getWholesaler())
  675.                 ->setParameter('id', $user->getId())
  676.                 ->getResult();
  677.         }
  678.         if ($user->getPartner()) {
  679.             $userlist = $entityManager->createQuery('SELECT u'
  680.                 . ' FROM App\Entity\User u'
  681.                 . ' WHERE u.partner = :partner'
  682.                 . ' AND u.id != :id')
  683.                 ->setParameter('partner', $user->getPartner())
  684.                 ->setParameter('id', $user->getId())
  685.                 ->getResult();
  686.         }
  687.         if ($user->getCustomer()) {
  688.             $userlist = $entityManager->createQuery('SELECT u'
  689.                 . ' FROM App\Entity\User u'
  690.                 . ' WHERE u.customer = :customer'
  691.                 . ' AND u.id != :id')
  692.                 ->setParameter('customer', $user->getCustomer())
  693.                 ->setParameter('id', $user->getId())
  694.                 ->getResult();
  695.         }
  697.         $ticketTecnico = $entityManager->createQuery('SELECT tt'
  698.             . ' FROM App\Entity\Tickettecnico tt'
  699.             . ' WHERE tt.supportcase = :supportcase')
  700.             ->setParameter('supportcase', $id)
  701.             ->getOneOrNullResult();
  703.         $producto = $entityManager->createQuery('SELECT p'
  704.             . ' FROM App\Entity\Product p'
  705.             . ' JOIN App\Entity\License l'
  706.             . ' JOIN App\Entity\Tickettecnico tt'
  707.             . ' WITH p.id = l.product'
  708.             . ' AND l.id = tt.license'
  709.             . ' WHERE tt.supportcase = :supportcase')
  710.             ->setParameter('supportcase', $id)
  711.             ->getOneOrNullResult();
  713.         $ticketmessage2 = new \App\Entity\Ticketmessage();
  714.         $form2 = $this->get('form.factory')->createNamed('formLeft', MessageSupport::class, $ticketmessage2, array(
  715.             //'level' => $selfUserLevel,
  716.             'user' => $user,
  717.             //'myTicket' => $myTicket,
  718.             'listuser' => $userlist,
  719.             'translator' => $translator,
  720.             'em' => $entityManager,
  721.         ));
  723.         $ticketmessage = new \App\Entity\Ticketmessage();
  724.         $form = $this->get('form.factory')->createNamed('formRight', MessageSupport::class, $ticketmessage, array(
  725.             //'level' => $selfUserLevel,
  726.             'user' => $user,
  727.             'listuser' => $userlist,
  728.             //'myTicket' => $myTicket,
  729.             'translator' => $translator,
  730.             'em' => $entityManager,
  731.         ));
  733.         //Si se ha hecho submit en el formulario de la izquierda
  734.         if ($request->request->has('formLeft')) {
  736.             $form2->handleRequest($request);
  738.             if ($form2->isValid()) {
  740.                 $this->createTicketMessage($translator, $serviceNotification, $request, $form2, $myTicket, $case);
  742.                 // Redirect and show result
  743.                 return $this->redirectToRoute('ticket_reply', array('id' => $id));
  744.             }
  745.         }
  747.         //Si se ha hecho submit en el formulario de la derecha
  748.         if ($request->request->has('formRight')) {
  750.             $form->handleRequest($this->getRequest());
  752.             if ($form->isValid()) {
  754.                 $this->createTicketMessage($translator, $serviceNotification, $request, $form, $ticketRight, $case);
  756.                 // Redirect and show result
  757.                 return $this->redirectToRoute('ticket_reply', array('id' => $id));
  758.             }
  759.         }
  761.         if ($case->getCreatedBy()->getPartner()) {
  762.             $companiesData['partner'] = $case->getCreatedBy()->getPartner()->getName();
  763.             $companiesData['customer'] = 'N/A';
  764.         }
  766.         if ($case->getCreatedBy()->getCustomer()) {
  767.             $companiesData['partner'] = $case->getCreatedBy()->getCustomer()->getPartner()->getName();
  768.             $companiesData['customer'] = $case->getCreatedBy()->getCustomer()->getCompany();
  769.         }
  771.         if ($ticketTecnico) {
  772.             if ($ticketTecnico->getCustomer()) {
  773.                 $companiesData['partner'] = $ticketTecnico->getCustomer()->getPartner()->getName();
  774.                 $companiesData['customer'] = $ticketTecnico->getCustomer()->getCompany();
  775.             }
  776.         }
  778.         if ($ticketTecnico && $selfUserLevel == 2) {
  780.             $vendorData = $userRepository->getVendorByProduct($ticketTecnico, $user);
  782.             if ($vendorData) {
  783.                 $vendorName = $vendorData->getName();
  784.             } else {
  785.                 $vendorName = '';
  786.             }
  787.         } else {
  788.             $vendorName = '';
  789.         }
  791.         if (
  792.             $case->getTipoTicket()->getId() == 4 || $user->getVendor()
  793.             || $case->getTipoTicket()->getId() == 5 || $case->getTipoTicket()->getId() == 6
  794.         ) {
  795.             //platform tickets and administrative vendor tickets and bi tickets to katy user
  796.             $profileUp = 'KATY';
  797.         } else {
  798.             $profileUp = $selfUserLevel == 2 ? $vendorName : $userRepository->getLevelUpCompany($user)->getName();
  799.         }
  801.         return $this->render('ticket/reply.html.twig', [
  802.             'ticket' => $myTicket,
  803.             'case' => $case,
  804.             'caseId' => $supportCaseRepository->getSupportCaseId10Digits($case),
  805.             'tecnico' => $ticketTecnico ? $ticketTecnico : null,
  806.             'producto' => $producto ? $producto->getName() : null,
  807.             'files' => $this->getFiles($myTicket ? $myTicket->getId() : ''),
  808.             'messages' => $myTicket ? $ticketRepository->getTicketmessages($myTicket) : null,
  809.             'selfUserLevel' => $selfUserLevel,
  810.             'form' => $form->createView(),
  811.             'form2' => $form2->createView(),
  812.             'escalado' => false,
  813.             'escalable' => false,
  814.             'profileUp' => $profileUp,
  815.             'tipo' => $translation->getTranslationBy($case->getTipoTicket(), $locale, 'nombretipo'),
  816.             'isKatyUser' => false,
  817.             'companiesData' => $companiesData,
  818.         ]);
  819.     }
  821.     /**
  822.      * @Route("/ticket/default/replyclient/{id}", name="ticket_replyclient", requirements={"id"="\d+"})
  823.      */
  824.     public function replyclient(TrafficTracker $trafficTracker, TranslatorInterface $translator, ServiceNotification $serviceNotification, Translation $translation, Request $request, $id = 0)
  825.     {
  826.         $trafficTracker->registerTraffic();
  827.         $entityManager = $this->getDoctrine()->getManager();
  828.         $locale = $request->getLocale();
  829.         $user = $this->getUser();
  830.         $userRepository = $entityManager->getRepository(\App\Entity\User::class);
  831.         $ticketRepository = $this->getDoctrine()->getRepository(Ticket::class);
  832.         $supportcaseRepository = $entityManager->getRepository(\App\Entity\Supportcase::class);
  833.         $selfUserLevel = $userRepository->getUserLevel($request, $user);
  834.         $tecnico = null;
  835.         $session = $this->get('session');
  836.         $katy = false;
  837.         $companiesData = ['partner' => 'N/A', 'customer' => 'N/A'];
  839.         $case = $supportcaseRepository->find($id);
  841.         $ticketQ = $ticketRepository->MyTicketClientQuery($user);
  842.         $ticketQ->andWhere('t.supportcase = :supportcase');
  843.         $ticketQ->setParameter('supportcase', $id);
  844.         $ticketQ->andwhere('t.level = :level');
  845.         $ticketQ->setParameter('level', $selfUserLevel);
  847.         $ticketR = $ticketQ->getQuery()->execute();
  848.         $myTicket = $ticketR ? $ticketR[0] : null;
  850.         $ticketQ2 = $ticketRepository->MyTicketClientQuery($user);
  851.         $ticketQ2->andWhere('t.supportcase = :supportcase');
  852.         $ticketQ2->setParameter('supportcase', $id);
  853.         $ticketQ2->andwhere('t.level = :level');
  854.         $ticketQ2->setParameter('level', $selfUserLevel  + 1);
  856.         $ticketR2 = $ticketQ2->getQuery()->execute();
  857.         $ticketToMe = $ticketR2 ? $ticketR2[0] : null;
  860.         if ($user->getVendor() && $user->getVendor()->getisMiniVendor()) {
  861.             $ticketQ3 = $ticketRepository->MyTicketClientQuery($user);
  862.             $ticketQ3->andWhere('t.supportcase = :supportcase');
  863.             $ticketQ3->setParameter('supportcase', $id);
  865.             $ticketR3 = $ticketQ3->getQuery()->execute();
  866.             $ticketToMe = $ticketR3[0];
  867.         }
  869.         if ($ticketToMe && $ticketToMe->getSupportcase()->getTipoTicket()->getId() == 3) {
  870.             if ($user->getMaster()) {
  871.             } elseif ($ticketToMe->getUser()->getPartner()) {
  872.                 if ($ticketToMe->getUser()->getPartner()->getIdcommercialagent() != $user->getId()) {
  873.                     $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.TicketNotFound'));
  874.                     return $this->redirectToRoute('ticket_index');
  875.                 }
  876.             } elseif ($ticketToMe->getUser()->getCustomer()) {
  877.                 if ($ticketToMe->getUser()->getCustomer()->getIdcommercialagent() != $user->getId()) {
  878.                     $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.TicketNotFound'));
  879.                     return $this->redirectToRoute('ticket_index');
  880.                 }
  881.             }
  882.         }
  884.         if (!$case) {
  885.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.TicketNotFound'));
  886.             return $this->redirectToRoute('ticket_index');
  887.         }
  889.         if (
  890.             $case->getTipoTicket()->getId() == 4 || $case->getTipoTicket()->getId() == 5
  891.             || $case->getTipoTicket()->getId() == 6
  892.         ) { //platform ticket or bi ticket
  893.             $ticketQ3 = $ticketRepository->MyTicketClientQuery($user);
  894.             $ticketQ3->andWhere('t.supportcase = :supportcase');
  895.             $ticketQ3->setParameter('supportcase', $id);
  897.             $ticketR3 = $ticketQ3->getQuery()->execute();
  898.             $ticketToMe = $ticketR3[0];
  900.             $myTicket = null;
  901.         }
  903.         if ($user->getVendor()) {
  904.             if (!$ticketToMe)
  905.                 throw new AccessDeniedHttpException();
  906.         } else {
  907.             if (!$myTicket && !$ticketToMe)
  908.                 throw new AccessDeniedHttpException();
  909.         }
  912.         $userlist = array();
  914.         //TO DO
  915.         // notificar user mayorista
  916.         if ($user->getWholesaler()) {
  917.             $userlist = $entityManager->createQuery('SELECT u'
  918.                 . ' FROM App\Entity\User u'
  919.                 . ' WHERE u.wholesaler = :wholesaler'
  920.                 . ' AND u.id != :id')
  921.                 ->setParameter('wholesaler', $user->getWholesaler())
  922.                 ->setParameter('id', $user->getId())
  923.                 ->getResult();
  924.         }
  925.         if ($user->getPartner()) {
  926.             $userlist = $entityManager->createQuery('SELECT u'
  927.                 . ' FROM App\Entity\User u'
  928.                 . ' WHERE u.partner = :partner'
  929.                 . ' AND u.id != :id')
  930.                 ->setParameter('partner', $user->getPartner())
  931.                 ->setParameter('id', $user->getId())
  932.                 ->getResult();
  933.         }
  934.         if ($user->getCustomer()) {
  935.             $userlist = $entityManager->createQuery('SELECT u'
  936.                 . ' FROM App\Entity\User u'
  937.                 . ' WHERE u.customer = :customer'
  938.                 . ' AND u.id != :id')
  939.                 ->setParameter('customer', $user->getCustomer())
  940.                 ->setParameter('id', $user->getId())
  941.                 ->getResult();
  942.         }
  944.         $ticketTecnico = $entityManager->createQuery('SELECT tt'
  945.             . ' FROM App\Entity\Tickettecnico tt'
  946.             . ' WHERE tt.supportcase = :supportcase')
  947.             ->setParameter('supportcase', $id)
  948.             ->setMaxResults(1)
  949.             ->getOneOrNullResult();
  951.         $producto = $entityManager->createQuery('SELECT p'
  952.             . ' FROM App\Entity\Product p'
  953.             . ' JOIN App\Entity\License l'
  954.             . ' JOIN App\Entity\Tickettecnico tt'
  955.             . ' WITH p.id = l.product'
  956.             . ' AND l.id = tt.license'
  957.             . ' WHERE tt.supportcase = :supportcase')
  958.             ->setParameter('supportcase', $id)
  959.             ->setMaxResults(1)
  960.             ->getOneOrNullResult();
  962.         $ticketmessage = new \App\Entity\Ticketmessage();
  963.         $form = $this->get('form.factory')->createNamed('formRight', MessageSupport::class, $ticketmessage, array(
  964.             //'level' => $selfUserLevel,
  965.             'user' => $user,
  966.             //'statusticket' => $ticketToMe->getStatus(),
  967.             'listuser' => $userlist,
  968.             //'myTicket' => $myTicket ? $myTicket : null,
  969.             //'ticketToMe' => $ticketToMe,
  970.             'translator' => $translator,
  971.             'em' => $entityManager,
  972.         ));
  974.         $ticketmessage2 = new \App\Entity\Ticketmessage();
  975.         $form2 = $this->get('form.factory')->createNamed('formLeft', MessageSupport::class, $ticketmessage2, array(
  976.             //'level' => $selfUserLevel,
  977.             'user' => $user,
  978.             'listuser' => $userlist,
  979.             //'myTicket' => $myTicket ? $myTicket : null,
  980.             'translator' => $translator,
  981.             'em' => $entityManager,
  982.         ));
  984.         // If submitted
  986.         if ($request->request->has('formLeft')) {
  987.             $form2->handleRequest($request);
  989.             if ($form2->isValid()) {
  990.                 $this->createTicketMessage($translator, $serviceNotification, $request, $form2, $ticketToMe, $case);
  992.                 // Redirect and show result
  993.                 return $this->redirectToRoute('ticket_replyclient', array('id' => $id));
  994.             }
  995.         }
  997.         // If submitted
  998.         if ($request->request->has('formRight')) {
  999.             $form->handleRequest($request);
  1001.             if ($form->isValid()) {
  1002.                 $this->createTicketMessage($translator, $serviceNotification, $request, $form, $myTicket, $case);
  1004.                 // Redirect and show result
  1005.                 return $this->redirectToRoute('ticket_replyclient', array('id' => $id));
  1006.             }
  1007.         }
  1009.         if ($ticketToMe) {
  1010.             $ticketTecnico = $entityManager->createQuery('SELECT tt'
  1011.                 . ' FROM App\Entity\Tickettecnico tt'
  1012.                 . ' WHERE tt.supportcase = :supportcase')
  1013.                 ->setParameter('supportcase', $ticketToMe->getSupportcase())
  1014.                 ->getOneOrNullResult();
  1015.         } else {
  1016.             $ticketTecnico = null;
  1017.         }
  1020.         $profileUp = null;
  1021.         //Poner nombre de la compañia / vendor en el titulo del ticket escalado.
  1022.         if ($selfUserLevel == 2 && $case->getTipoTicket()->getId() == 1) {
  1023.             $vendor = $userRepository->getVendorByProduct($ticketTecnico, $user);
  1024.             if (!is_null($vendor)) {
  1025.                 $profileUp = $vendor->getName();
  1026.             }
  1027.         } elseif (
  1028.             $case->getTipoTicket()->getId() == 4 || $case->getTipoTicket()->getId() == 2
  1029.             || $case->getTipoTicket()->getId() == 5 || $case->getTipoTicket()->getId() == 6
  1030.         ) {
  1031.             //platform tickets and administrative vendor tickets and bi tickets to katy user
  1032.             $profileUp = 'KATY';
  1033.         } else {
  1034.             $profileUp = $userRepository->getLevelUpCompany($user)->getName();
  1035.         }
  1037.         if ($case->getCreatedBy()->getPartner()) {
  1038.             $companiesData['partner'] = $case->getCreatedBy()->getPartner()->getName();
  1039.             $companiesData['customer'] = 'N/A';
  1040.         }
  1042.         if ($case->getCreatedBy()->getCustomer()) {
  1043.             $companiesData['partner'] = $case->getCreatedBy()->getCustomer()->getPartner()->getName();
  1044.             $companiesData['customer'] = $case->getCreatedBy()->getCustomer()->getCompany();
  1045.         }
  1047.         //Return Ticket Commercial or Ticket Tecnico 
  1048.         $ticketComercial = $case->getTicketComercial();
  1049.         if (!is_null($ticketTecnico) || !is_null($ticketComercial)) {
  1050.             if (isset($ticketTecnico)) {
  1051.                 $tecnico = $ticketTecnico;
  1052.                 if ($ticketTecnico->getCustomer()) {
  1053.                     $companiesData['partner'] = $ticketTecnico->getCustomer()->getPartner()->getName();
  1054.                     $companiesData['customer'] = $ticketTecnico->getCustomer()->getCompany();
  1055.                 }
  1056.             }
  1057.             if (isset($ticketComercial)) {
  1058.                 $tecnico = $ticketComercial;
  1059.             }
  1060.         }
  1062.         if (!$user->getVendor() && !$user->getWholesaler() && !$user->getPartner() && !$user->getCustomer()) {
  1063.             $katy = true;
  1064.         }
  1066.         return $this->render('ticket/reply.html.twig', [
  1067.             'replyclient' => true,
  1068.             'ticketToMe' => $ticketToMe,
  1069.             'myTicket' => $myTicket,
  1070.             'userRepository' => $userRepository,
  1071.             'case' => $case,
  1072.             'caseId' => $case ? $supportcaseRepository->getSupportCaseId10Digits($case) : '',
  1073.             'tecnico' => $tecnico ? $tecnico : null,
  1074.             'producto' => $producto ? $producto->getName() : null,
  1075.             'files' => $ticketToMe ? $this->getFiles($ticketToMe->getId()) : '',
  1076.             'filesUp' => $myTicket ? $this->getFiles($myTicket->getId()) : '',
  1077.             'messages' => $ticketToMe ? $ticketRepository->getTicketmessages($ticketToMe) : null,
  1078.             'messagesScalated' => $myTicket ? $ticketRepository->getTicketmessages($myTicket) : null,
  1079.             'selfUserLevel' => $selfUserLevel,
  1080.             'form' => $form->createView(),
  1081.             'form2' => $form2->createView(),
  1082.             'level' => 1,
  1083.             'profileUp' => $profileUp,
  1084.             'profileDown' => $ticketToMe ? $userRepository->getCompanyName($ticketToMe->getUser()) : 'N/A',
  1085.             'escalado' => $ticketToMe && $myTicket ? true : false,
  1086.             'tipo' => $translation->getTranslationBy($case->getTipoTicket(), $locale, 'nombretipo'),
  1087.             'isKatyUser' => $katy,
  1088.             'companiesData' => $companiesData,
  1089.         ]);
  1090.     }
  1093.     /**
  1094.      * @Route("/ticket/default/deletefile/{id}", name="ticket_deletefile")
  1095.      */
  1096.     public function deletefile(TranslatorInterface $translator, $id)
  1097.     {
  1098.         $entityManager = $this->getDoctrine()->getManager();
  1100.         $path = $this->getParameter('private_folder') . 'ticket/';
  1101.         $file = $entityManager->createQuery('SELECT tmf'
  1102.             . ' FROM App\Entity\Ticketmessagefile tmf'
  1103.             . ' WHERE tmf.id = :id')
  1104.             ->setParameter('id', $id)
  1105.             ->getOneOrNullResult();
  1107.         $fileInTickets = $entityManager->createQuery('SELECT count(t.id)'
  1108.             . ' FROM App\Entity\Ticket t'
  1109.             . ' JOIN App\Entity\Ticketmessage tm'
  1110.             . ' JOIN App\Entity\Ticketmessagefile tmf'
  1111.             . ' WITH t.id = tm.ticket'
  1112.             . ' AND tm.id = tmf.message'
  1113.             . ' WHERE tmf.deletedby is null'
  1114.             . ' AND tmf.filename = :filename')
  1115.             ->setParameter('filename', $file->getFilename())
  1116.             ->getOneOrNullResult();
  1118.         $ticket = $file->getMessage()->getTicket();
  1119.         $ticketMessage = new \App\Entity\Ticketmessage();
  1121.         $ticketMessage->setUser($this->getUser());
  1122.         $ticketMessage->setTicket($ticket);
  1123.         $ticketMessage->setDate(new \DateTime);
  1124.         $ticketMessage->setMessage($translator->trans('app.Support.System.FileDeleted') . ' ' . $file->getOriginalfilename());
  1125.         $ticketMessage->setLocale($this->getUser()->getLocale());
  1126.         $ticketMessage->setLevel(0);
  1127.         $ticketMessage->setAutomatic(1);
  1128.         $entityManager->persist($ticketMessage);
  1129.         $entityManager->flush();
  1131.         //$ticket->addTicketmessage($ticketMessage);
  1133.         if ($fileInTickets == 1) {
  1134.             $file->setDeletedBy($this->getUser());
  1135.             $entityManager->persist($file);
  1136.             $entityManager->flush();
  1137.             unlink($path . $file->getFilename());
  1138.         } else {
  1139.             $file->setDeletedBy($this->getUser());
  1140.             $entityManager->persist($file);
  1141.             $entityManager->flush();
  1142.         }
  1144.         return $this->redirect($_SERVER['HTTP_REFERER']);
  1145.     }
  1148.     /**
  1149.      * @Route("/ticket/default/file/{name}", name="ticket_file", requirements={"name"="\S+"})
  1150.      */
  1151.     public function ticketFile($name)
  1152.     {
  1153.         $entityManager = $this->getDoctrine()->getManager();
  1154.         $fichero = $entityManager->createQuery('SELECT tmf'
  1155.             . ' FROM App\Entity\Ticketmessagefile tmf'
  1156.             . ' WHERE tmf.filename like :filename')
  1157.             ->setParameter('filename', $name . '%')
  1158.             ->setMaxResults(1)
  1159.             ->getOneOrNullResult();
  1161.         $user = $this->getUser();
  1163.         // Build internal full path
  1164.         $path = $this->getParameter('private_folder') . 'ticket/';
  1165.         $file = $path . $fichero->getFilename();
  1167.         if ($fichero->getFilename() && file_exists($file)) {
  1168.             $content = file_get_contents($file);
  1169.             $response = new Response();
  1171.             $response->headers->set('Content-Type', mime_content_type($file));
  1172.             $response->headers->set('Content-Disposition', 'attachment;filename="' . $fichero->getOriginalfilename());
  1174.             $response->setContent($content);
  1175.             return $response;
  1176.         }
  1177.     }
  1180.     /**
  1181.      * @Route("/ticket/default/pasarfichero/{id}/{to}", name="ticket_pasarfichero")
  1182.      */
  1183.     public function pasarfichero(TranslatorInterface $translator, Request $request, $id, $to)
  1184.     {
  1185.         $entityManager = $this->getDoctrine()->getManager();
  1186.         $session = $this->get('session');
  1187.         $isInArray = false;
  1189.         $file = $entityManager->createQuery('SELECT tmf'
  1190.             . ' FROM App\Entity\Ticketmessagefile tmf'
  1191.             . ' WHERE tmf.id = :id')
  1192.             ->setParameter('id', $id)
  1193.             ->getOneOrNullResult();
  1195.         $ticket = $file->getMessage()->getTicket();
  1196.         $user = $this->getUser();
  1198.         if ($to == 'up') {
  1199.             $level = $ticket->getLevel() - 1;
  1200.         } else {
  1201.             $level = $ticket->getLevel() + 1;
  1202.         }
  1204.         $ticketReceptor = $entityManager->createQuery('SELECT t'
  1205.             . ' FROM App\Entity\Ticket t'
  1206.             . ' WHERE t.supportcase = :supportcase'
  1207.             . ' AND t.level = :level')
  1208.             ->setParameter('supportcase', $ticket->getSupportCase())
  1209.             ->setParameter('level', $level)
  1210.             ->setMaxResults(1)
  1211.             ->getOneOrNullResult();
  1213.         if ($ticketReceptor) {
  1215.             $ficherosTicketReceptor = $entityManager->createQuery('SELECT tmf'
  1216.                 . ' FROM App\Entity\Ticketmessagefile tmf'
  1217.                 . ' JOIN tmf.message tm'
  1218.                 . ' JOIN tm.ticket t'
  1219.                 . ' WHERE t.supportcase = :supportcase'
  1220.                 . ' AND t.id = :id'
  1221.                 . ' AND tmf.deletedby is null')
  1222.                 ->setParameter('supportcase', $ticketReceptor->getSupportcase())
  1223.                 ->setParameter('id', $ticketReceptor->getId())
  1224.                 ->getResult();
  1226.             foreach ($ficherosTicketReceptor as $tmpfile) {
  1228.                 if ($tmpfile->getFilename() == $file->getFilename())
  1229.                     $isInArray = true;
  1230.             }
  1232.             if ($isInArray || $ticketReceptor->getStatus() == 'CLOSED') {
  1233.                 if ($isInArray)
  1234.                     $session->getFlashBag()->add('danger', $translator->trans('app.Support.System.ExistingFile'));
  1235.                 else
  1236.                     $session->getFlashBag()->add('danger', $translator->trans('app.Support.System.TicketClosed'));
  1237.             } else {
  1238.                 $message = new \App\Entity\Ticketmessage();
  1239.                 $message->setUser($user);
  1240.                 $message->setMessage($translator->trans('app.Support.System.FileMoved') . ' ' . $file->getOriginalfilename());
  1241.                 $message->setLocale($request->getLocale());
  1242.                 $message->setAutomatic(1);
  1243.                 $message->setDate(new \DateTime);
  1244.                 $message->setStatus('PENDING');
  1245.                 $message->setTicket($ticketReceptor);
  1246.                 $entityManager->persist($message);
  1247.                 $entityManager->flush();
  1249.                 $newFile = new \App\Entity\Ticketmessagefile();
  1250.                 $newFile->setFilename($file->getFilename());
  1251.                 $newFile->setOriginalfilename($file->getOriginalfilename());
  1252.                 $newFile->setFilename($file->getFilename());
  1253.                 $newFile->setMessage($message);
  1254.                 $entityManager->persist($newFile);
  1255.                 $entityManager->flush();
  1256.             }
  1257.         } else {
  1258.             $userRepository = $entityManager->getRepository(\App\Entity\User::class);
  1259.             $selfUserLevel = $userRepository->getUserLevel($request, $user);
  1261.             $newTicket = new Ticket();
  1262.             $newTicket->setSupportcase($ticket->getSupportcase());
  1263.             $newTicket->setUser($user);
  1264.             $newTicket->setLevel($selfUserLevel);
  1265.             $newTicket->setCreationdate(new \DateTime);
  1266.             $newTicket->setLastmodification(new \DateTime);
  1267.             $entityManager->persist($newTicket);
  1268.             $entityManager->flush();
  1270.             $ticketMessage = new \App\Entity\Ticketmessage();
  1271.             $ticketMessage->setUser($user);
  1272.             $ticketMessage->setMessage($translator->trans('app.Support.MoveFile') . ' ' . $file->getOriginalfilename());
  1273.             $ticketMessage->setLocale($request->getLocale());
  1274.             $ticketMessage->setAutomatic(1);
  1275.             $ticketMessage->setDate(new \DateTime);
  1276.             $ticketMessage->setStatus('PENDING');
  1277.             $entityManager->persist($ticketMessage);
  1278.             $entityManager->flush();
  1280.             $nwFile = new \App\Entity\Ticketmessagefile();
  1281.             $nwFile->setFilename($file->getFilename());
  1282.             $nwFile->setOriginalfilename($file->getOriginalfilename());
  1283.             $nwFile->setFilename($file->getFilename());
  1284.             $nwFile->setMessage($ticketMessage);
  1285.             $entityManager->persist($nwFile);
  1286.             $entityManager->flush();
  1287.         }
  1289.         return $this->redirect($_SERVER['HTTP_REFERER']);
  1290.     }
  1293.     /**
  1294.      * @Route("/ticket/default/getlicensesbyclient", name="ticket_getlicensesbyclient")
  1295.      */
  1296.     public function getlicensesbyclient(TranslatorInterface $translator, Request $request)
  1297.     {
  1298.         $user = $this->getUser();
  1299.         $arrayLicencias = array();
  1300.         $id = $request->get('id');
  1302.         $userRepository = $this->getDoctrine()->getRepository(\App\Entity\User::class)->findOneBy(['customer' => $id]);
  1303.         if (is_null($userRepository)) {
  1304.             return new JsonResponse();
  1305.         }
  1306.         $licenseRepository = $this->getDoctrine()->getRepository(\App\Entity\License::class);
  1307.         $licenseQ = $licenseRepository->MyLicenseQuery($userRepository);
  1308.         $licencias = $licenseQ->getQuery()->execute();
  1311.         $arrayLicencias['0'] = $translator->trans('app.General.Others');
  1313.         foreach ($licencias as $licencia) {
  1314.             $arrayLicencias[$licencia->getId()] = $licencia->getProduct()->getDescriptiveName() . $licenseRepository->getLast4Digits($licencia);
  1315.         }
  1317.         return new JsonResponse($arrayLicencias);
  1318.     }
  1321.     public function SupportTicketByStatus(ReportingColors $reportingColors, $user)
  1322.     {
  1323.         $entityManager = $this->getDoctrine()->getManager();
  1324.         $json_data = array();
  1326.         $estadosticket = $entityManager->createQuery('SELECT t.status, COUNT(t.status) as count'
  1327.             . ' FROM App\Entity\Ticket t'
  1328.             . ' WHERE t.user = :user'
  1329.             . ' GROUP BY t.status')
  1330.             ->setParameter('user', $user)
  1331.             ->getArrayResult();
  1333.         $color = $reportingColors->EstadoColor();
  1334.         foreach ($estadosticket as $estado) {
  1335.             $estad['status'] = $estado['status'];
  1336.             $estad['count'] = $estado['count'];
  1337.             if ($estado['status'] == 'PENDING')
  1338.                 $estad['color'] = $color['PENDING'];
  1339.             if ($estado['status'] == 'PROCESS')
  1340.                 $estad['color'] = $color['PROCESS'];
  1341.             if ($estado['status'] == 'RESOLVED')
  1342.                 $estad['color'] = $color['RESOLVED'];
  1343.             if ($estado['status'] == 'CLOSED')
  1344.                 $estad['color'] = $color['CLOSED'];
  1345.             array_push($json_data, $estad);
  1346.         }
  1348.         return $json_data;
  1349.     }
  1351.     public function getUsersAndRolesToNotify($case, $ticket, $translator)
  1352.     {
  1353.         $entityManager = $this->getDoctrine()->getManager();
  1354.         $userRepository = $entityManager->getRepository(\App\Entity\User::class);
  1355.         $vendorRepository = $entityManager->getRepository(\App\Entity\Vendors::class);
  1356.         $ticketTecnico = null;
  1358.         switch ($case->getTipoTicket()->getId()) {
  1359.             case 1:
  1360.                 //Técnico                   
  1361.                 $tipoticket = ($translator->trans('app.Support.DropDownTechnical'));
  1363.                 $ticketTecnico = $entityManager->createQuery('SELECT tt'
  1364.                     . ' FROM App\Entity\Tickettecnico tt'
  1365.                     . ' WHERE tt.supportcase = :id')
  1366.                     ->setParameter('id', $case->getId())
  1367.                     ->getOneOrNullResult();
  1368.                 break;
  1369.             case 2:
  1370.                 //Administración
  1371.                 $tipoticket = ($translator->trans('app.Support.DropDownAdministration'));
  1372.                 break;
  1373.             case 3:
  1374.                 //Comercial
  1375.                 $tipoticket = ($translator->trans('app.Support.DropDownCommercial'));
  1376.                 break;
  1377.             case 4:
  1378.                 //Plataforma técnico
  1379.                 $tipoticket = ($translator->trans('app.Support.DropDownPlatform'));
  1380.                 break;
  1381.             case 5:
  1382.                 //BI
  1383.                 $tipoticket = ($translator->trans('BI'));
  1384.                 break;
  1385.             case 6:
  1386.                 //Plataforma gestión
  1387.                 $tipoticket = ($translator->trans('app.Support.DropDownPlatform'));
  1388.                 break;
  1389.         }
  1391.         if ($ticket->getUser()->getWholesaler() && $ticketTecnico && $ticketTecnico->getProductline()) {
  1392.             $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1393.                 . ' FROM App\Entity\User u'
  1394.                 . ' WHERE u.vendor = :vendor'
  1395.                 . ' AND u.roles like :role_one')
  1396.                 ->setParameter('vendor', $ticketTecnico->getProductline()->getVendor())
  1397.                 ->setParameter('role_one', '%ROLE_SUPPORT_VENDOR%')
  1398.                 ->getResult();
  1399.         } else {
  1400.             $levelUp = $userRepository->getLevelUpCompany($ticket->getUser());
  1401.             $partner = $ticket->getUser()->getPartner();
  1403.             if ($case->getTipoTicket()->getId() == 4) {
  1404.                 //tickets platform technical to user katy
  1405.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1406.                     . ' FROM App\Entity\User u'
  1407.                     . ' WHERE u.roles like :role_one')
  1408.                     ->setParameter('role_one', '%ROLE_SUPPORT_KATY%')
  1409.                     ->getResult();
  1410.             } elseif ($case->getTipoTicket()->getId() == 5) {
  1411.                 //tickets bi to user katy
  1412.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1413.                     . ' FROM App\Entity\User u'
  1414.                     . ' WHERE u.roles like :role_one')
  1415.                     ->setParameter('role_one', '%ROLE_BI_MANAGER%')
  1416.                     ->getResult();
  1417.             } elseif ($case->getTipoTicket()->getId() == 6) {
  1418.                 //tickets platform management to user katy
  1419.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1420.                     . ' FROM App\Entity\User u'
  1421.                     . ' WHERE u.roles like :role_one')
  1422.                     ->setParameter('role_one', '%ROLE_SUPPORT_MANAGEMENT_KATY%')
  1423.                     ->getResult();
  1424.             } elseif ($ticket->getUser()->getVendor()) {
  1425.                 //tickets administratives
  1426.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1427.                     . ' FROM App\Entity\User u'
  1428.                     . ' WHERE u.roles like :role_one')
  1429.                     ->setParameter('role_one', '%ROLE_SUPPORT_ADMIN_KATY%')
  1430.                     ->getResult();
  1431.             } elseif ($ticket->getUser()->getWholesaler()) {
  1432.                 if ($case->getTipoTicket()->getId() == 3) { //commercial
  1433.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1434.                         . ' FROM App\Entity\User u'
  1435.                         . ' WHERE u.wholesaler = :wholesaler'
  1436.                         . ' AND u.roles like :role_one')
  1437.                         ->setParameter('wholesaler', $levelUp)
  1438.                         ->setParameter('role_one', '%ROLE_COMMERCIAL_AGENT_NEW%')
  1439.                         ->getResult();
  1440.                 } else { //administrative
  1441.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1442.                         . ' FROM App\Entity\User u'
  1443.                         . ' WHERE u.wholesaler = :wholesaler'
  1444.                         . ' AND u.roles like :role_one')
  1445.                         ->setParameter('wholesaler', $levelUp)
  1446.                         ->setParameter('role_one', '%ROLE_MANAGE_SUPPORT_TICKETS_NEW%')
  1447.                         ->getResult();
  1448.                 }
  1449.             } elseif ($ticket->getUser()->getPartner()) {
  1451.                 if ($case->getTipoTicket()->getId() == 3) { //commercial
  1452.                     $comercialAgent = $userRepository->find($partner->getIdcommercialagent());
  1453.                     $master = $userRepository->getMaster($partner->getWholesaler());
  1454.                     if ($comercialAgent->getEmail() != $master[0]->getEmail()) {
  1455.                         $usersToNotify = array_merge($master, array($comercialAgent));
  1456.                     } else {
  1457.                         $usersToNotify = $master;
  1458.                     }
  1459.                 } else {
  1460.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1461.                         . ' FROM App\Entity\User u'
  1462.                         . ' WHERE u.wholesaler = :wholesaler'
  1463.                         . ' AND u.roles like :role_one')
  1464.                         ->setParameter('wholesaler', $levelUp)
  1465.                         ->setParameter('role_one', '%ROLE_MANAGE_SUPPORT_TICKETS_NEW%')
  1466.                         ->getResult();
  1467.                 }
  1468.             } elseif ($ticket->getUser()->getCustomer()) {
  1470.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1471.                     . ' FROM App\Entity\User u'
  1472.                     . ' WHERE u.partner = :partner'
  1473.                     . ' AND u.roles like :role_one')
  1474.                     ->setParameter('partner', $levelUp)
  1475.                     ->setParameter('role_one', '%ROLE_SUPPORT_NEW%')
  1476.                     ->getResult();
  1477.             }
  1478.         }
  1480.         return array(
  1481.             'usersToNotify' => $usersToNotify,
  1482.             'tipoTicket' => $tipoticket
  1483.         );
  1484.     }
  1486.     private function getLastMessageToNotify($tmpLast)
  1487.     {
  1488.         $entityManager = $this->getDoctrine()->getManager();
  1490.         if ($tmpLast->getLevel() == 0 && $tmpLast->getAutomatic()) {
  1491.             $tmpCount = $entityManager->createQuery('SELECT tm'
  1492.                 . ' FROM App\Entity\Ticketmessage tm'
  1493.                 . ' WHERE tm.date = :date')
  1494.                 ->setParameter('date', $tmpLast->getDate())
  1495.                 ->getResult();
  1497.             if (count($tmpCount) == 2) {
  1498.                 $lastMessage = $tmpCount[0]->getMessage();
  1499.             } else {
  1500.                 $lastMessage = '';
  1501.             }
  1502.         } else {
  1503.             $ticketRepository = $entityManager->getRepository(\App\Entity\Ticket::class);
  1504.             //$lastMessage = $ticketRepository->getTicketmessages($tmpLast->getTicket())->last()->getMessage();
  1505.             $lastMessage = array_values(array_slice($ticketRepository->getTicketmessages($tmpLast->getTicket()), -1))[0]->getMessage();
  1506.         }
  1508.         return $lastMessage;
  1509.     }
  1511.     private function uploadFile($path, $tm, $form, $translator)
  1512.     {
  1513.         $entityManager = $this->getDoctrine()->getManager();
  1514.         $session = $this->get('session');
  1515.         $extensionFileService =  new ExtensionFileService($session, $translator);
  1516.         $files = $form->get('filename')->getData();
  1517.         $ticket = $tm->getTicket();
  1519.         foreach ($files as $file) {
  1520.             $sanitize = $extensionFileService->getSanitize('docx+pdf+img+excel+txt+ppt', $file->getClientOriginalName());
  1521.             if ($sanitize) {
  1522.                 if ((strlen($file->getClientOriginalName()) > 100)) {
  1523.                     $session->getFlashBag()->add('danger', $translator->trans('app.ManageUsers&Profiles.Max100Characters'));
  1524.                 } elseif (($file->getSize() > 26214400)) {
  1525.                     $session->getFlashBag()->add('danger', $translator->trans('app.General.Guidelines.FileSize'));
  1526.                 } else {
  1528.                     $tmFile = new \App\Entity\Ticketmessagefile();
  1530.                     $tmFile->setOriginalfilename($file->getClientOriginalName());
  1532.                     $extension = $file->guessExtension();
  1533.                     if (!$extension)
  1534.                         $extension = 'bin';
  1535.                     $newName = $ticket->getId() . '_' . time() . '_' . rand(1, 999) . '.' . $extension;
  1536.                     $tmFile->setFilename($newName);
  1538.                     // Try to save file
  1539.                     $file->move($path, $newName);
  1540.                     $tmFile->setMessage($tm);
  1541.                     $entityManager->persist($tmFile);
  1542.                     $entityManager->flush();
  1543.                 }
  1544.             }
  1545.         }
  1546.     }
  1548.     private function getErrorMessages(\Symfony\Component\Form\Form $form)
  1549.     {
  1550.         $errors = array();
  1552.         foreach ($form->getErrors() as $key => $error) {
  1553.             if ($form->isRoot()) {
  1554.                 $errors['#'][] = $error->getMessage();
  1555.             } else {
  1556.                 $errors[] = $error->getMessage();
  1557.             }
  1558.         }
  1560.         foreach ($form->all() as $child) {
  1561.             if (!$child->isValid()) {
  1562.                 $errors[$child->getName()] = $this->getErrorMessages($child);
  1563.             }
  1564.         }
  1566.         return $errors;
  1567.     }
  1570.     /**
  1571.      * Create a ticket message from post data
  1572.      * 
  1573.      * @param type $post
  1574.      * @param type $ticket
  1575.      */
  1576.     protected function createTicketMessage($translator, $serviceNotification, $request, $form, $ticket = null, $case)
  1577.     {
  1578.         $data = array();
  1579.         $tm = new \App\Entity\Ticketmessage();
  1580.         $bescalado = false;
  1581.         $idevento = null;
  1582.         $lastMessage = '';
  1584.         $session = $this->get('session');
  1585.         $entityManager = $this->getDoctrine()->getManager();
  1586.         $user = $this->getUser();
  1587.         $path = $this->getParameter('private_folder') . 'ticket/';
  1588.         $serverName = $this->getParameter('server_name');
  1589.         $userRepository = $entityManager->getRepository(\App\Entity\User::class);
  1590.         $selfUserLevel = $userRepository->getUserLevel($request, $user);
  1591.         $ticketRepository = $entityManager->getRepository(\App\Entity\Ticket::class);
  1592.         $supportcaseRepository = $entityManager->getRepository(\App\Entity\Supportcase::class);
  1594.         //Si existe el ticket creará el mensaje para ese ticket
  1595.         if ($ticket) {
  1597.             if ($form->get('send')->isClicked() && $form->get('message')->getData() == '') {
  1598.                 $session->getFlashBag()->add('danger', $translator->trans('app.Support.System.EmptyMessage'));
  1600.                 if ($user == $ticket->getUser()) {
  1601.                     return $this->redirectToRoute('ticket_reply', array('id' => $case->getId()));
  1602.                 } else {
  1603.                     return $this->redirectToRoute('ticket_replyclient', array('id' => $case->getId()));
  1604.                 }
  1605.             }
  1607.             // SI HA ELEGIDO CERRAR EL TICKET
  1608.             if ($form->get('close')->isClicked()) {
  1610.                 if ($ticket->getStatus() == 'CLOSED') {
  1612.                     $ticket->setMessagerate($form->get('ratingMessage')->getData());
  1613.                     $ticket->setRate($form->get('score')->getData() == '' ? 0 : $form->get('score')->getData());
  1614.                     $entityManager->persist($ticket);
  1615.                     $entityManager->flush();
  1617.                     return;
  1618.                 }
  1620.                 //SI EL CREADOR DEL CASO CIERRA EL TICKET
  1621.                 if ($user == $ticket->getUser() && $user == $ticket->getSupportcase()->getCreatedby()) {
  1623.                     $idevento = 74;
  1625.                     $ticket->setRate($form->get('score')->getData() == '' ? 0 : $form->get('score')->getData());
  1626.                     $ticket->setStatus('CLOSED');
  1627.                     $ticket->setCloseddate(new \DateTime);
  1628.                     $entityManager->persist($ticket);
  1629.                     $entityManager->flush();
  1631.                     $automMessage = new \App\Entity\Ticketmessage();
  1632.                     $automMessage->setUser($user);
  1633.                     $automMessage->setMessage($translator->trans('app.Support.System.TicketClosed'));
  1634.                     $automMessage->setAutomatic(1);
  1635.                     $automMessage->setLocale($request->getLocale());
  1636.                     $automMessage->setDate(new \DateTime);
  1637.                     $automMessage->setStatus('CLOSED_BY_CASE_OWNER');
  1638.                     $automMessage->setTicket($ticket);
  1639.                 } else {
  1640.                     //SI EL CREADOR DEL TICKET LO CIERRA
  1641.                     if ($user == $ticket->getUser()) {
  1643.                         $idevento = 74;
  1645.                         $ticket->setCloseddate(new \DateTime);
  1646.                         $ticket->setStatus('CLOSED');
  1647.                         $ticket->setRate($form->get('score')->getData() == '' ? 0 : $form->get('score')->getData());
  1648.                         $entityManager->persist($ticket);
  1649.                         $entityManager->flush();
  1651.                         $automMessage = new \App\Entity\Ticketmessage();
  1652.                         $automMessage->setUser($user);
  1653.                         $automMessage->setMessage($translator->trans('app.Support.System.TicketClosed'));
  1654.                         $automMessage->setAutomatic(1);
  1655.                         $automMessage->setLocale($request->getLocale());
  1656.                         $automMessage->setDate(new \DateTime);
  1657.                         $automMessage->setStatus('CLOSED_BY_TICKET_OWNER');
  1658.                         $automMessage->setTicket($ticket);
  1659.                     }
  1660.                     //SI EL USUARIO CON ROL PARA GESTIONAR ESA INCIDENCIA CIERRA EL TICKET
  1661.                     else {
  1663.                         $idevento = 75;
  1665.                         $ticket->setCloseddate(new \DateTime);
  1666.                         $ticket->setStatus('CLOSED');
  1667.                         $entityManager->persist($ticket);
  1668.                         $entityManager->flush();
  1670.                         $automMessage = new \App\Entity\Ticketmessage();
  1671.                         $automMessage->setUser($user);
  1672.                         $automMessage->setMessage($translator->trans('app.Support.System.TicketClosed'));
  1673.                         $automMessage->setAutomatic(1);
  1674.                         $automMessage->setLocale($request->getLocale());
  1675.                         $automMessage->setDate(new \DateTime);
  1676.                         $automMessage->setStatus('CLOSED_BY_SUPPORT');
  1677.                         $automMessage->setTicket($ticket);
  1678.                     }
  1679.                 }
  1680.             }
  1682.             //SI HA ELEGIDO REABRIR EL TICKET
  1683.             elseif ($ticket->getStatus() == 'CLOSED') {
  1685.                 $idevento = 73;
  1687.                 $ticket->setStatus('PENDING');
  1688.                 $entityManager->persist($ticket);
  1689.                 $entityManager->flush();
  1691.                 $tm->setStatus('REOPENED');
  1693.                 $automMessage = new \App\Entity\Ticketmessage();
  1694.                 $automMessage->setUser($user);
  1695.                 $automMessage->setMessage($translator->trans('app.Support.System.TicketReopened'));
  1696.                 $automMessage->setAutomatic(1);
  1697.                 $automMessage->setLocale($request->getLocale());
  1698.                 $automMessage->setDate(new \DateTime);
  1699.                 $automMessage->setStatus('REOPENED');
  1700.                 $automMessage->setTicket($ticket);
  1701.                 $entityManager->persist($automMessage);
  1702.                 $entityManager->flush();
  1703.             }
  1705.             if ($form->get('message')->getData() != '') {
  1707.                 $tm->setUser($user);
  1708.                 $tm->setDate(new \DateTime);
  1709.                 $tm->setMessage($form->get('message')->getData());
  1710.                 $tm->setLocale($request->getLocale());
  1711.                 $tm->setTicket($ticket);
  1712.                 $tm->setLevel($selfUserLevel);
  1713.                 $entityManager->persist($tm);
  1714.                 $entityManager->flush();
  1715.             }
  1717.             if ($idevento == 75 || $idevento == 74 && $automMessage) {
  1718.                 $entityManager->persist($automMessage);
  1719.                 $entityManager->flush();
  1720.             }
  1722.             if ($form->get('ratingMessage')->getData() != '') {
  1724.                 $ticket->setMessagerate($form->get('ratingMessage')->getData());
  1725.                 $entityManager->persist($ticket);
  1726.                 $entityManager->flush();
  1727.             }
  1730.             if (!empty($form->get('filename')) && $form->get('filename')->getData() != null) {
  1731.                 $this->uploadFile($path, $tm, $form, $translator);
  1732.             }
  1733.         } else {
  1734.             $idevento = 14;
  1735.             $bescalado = true;
  1736.             //Si el usuario escala el caso, crea un nuevo ticket con el mensaje escrito.
  1738.             $ticket = new Ticket();
  1739.             $ticket->setUser($user);
  1740.             $ticket->setSupportcase($case);
  1741.             $ticket->setCreationdate(new \DateTime);
  1742.             $ticket->setLastmodification(new \DateTime);
  1743.             $ticket->setLevel($selfUserLevel);
  1744.             $entityManager->persist($ticket);
  1745.             $entityManager->flush();
  1747.             $tm->setUser($user);
  1748.             $tm->setDate(new \DateTime);
  1749.             $tm->setMessage($form->get('message')->getData());
  1750.             $tm->setLocale($request->getLocale());
  1751.             $tm->setTicket($ticket);
  1752.             $tm->setLevel($selfUserLevel);
  1753.             $entityManager->persist($tm);
  1754.             $entityManager->flush();
  1756.             //Si hay ficheros adjuntos 
  1757.             if (!empty($form->get('filename')) && $form->get('filename')->getData() != null) {
  1758.                 $this->uploadFile($path, $tm, $form, $translator);
  1759.             }
  1761.             //Notifificaciones        
  1763.             $ticketTecnico = $entityManager->createQuery('SELECT tt'
  1764.                 . ' FROM App\Entity\Tickettecnico tt'
  1765.                 . ' WHERE tt.supportcase = :id')
  1766.                 ->setParameter('id', $case->getId())
  1767.                 ->getOneOrNullResult();
  1769.             $arrayusersandroles = $this->getUsersAndRolesToNotify($case, $ticket, $translator);
  1771.             $ticketuser = $ticket->getUser();
  1772.             $serverName = $this->getParameter('server_name');
  1774.             if ($ticketuser->getCustomer()) {
  1775.                 $company = $userRepository->getCompany($ticketuser);
  1776.                 $customer = $userRepository->getCompany($company);
  1777.             } else {
  1778.                 $customer = $userRepository->getCompany($ticketuser)->getName();
  1779.             }
  1782.             //datos para envio email
  1783.             $data = [
  1784.                 'ticket' => $ticket,
  1785.                 'tickettecnico' => isset($ticketTecnico) ? $ticketTecnico : null,
  1786.                 'tipoticket' => $arrayusersandroles['tipoTicket'],
  1787.                 'ticketLink' => "ticket/default/replyclient/" . $case->getId(),
  1788.                 'customerLevel' => $selfUserLevel,
  1789.                 'ticketmessage' => $tm->getMessage(),
  1790.                 'user' => $user,
  1791.                 'messageLevel' => $selfUserLevel,
  1792.                 'route' => 'ticket_replyclient',
  1793.                 'idview' => $case->getId(),
  1794.             ];
  1797.             $serviceNotification->Notify($idevento, $arrayusersandroles['usersToNotify'], $data);
  1798.         }
  1800.         //Notifica al que recibela incidencia que tiene una respuesta
  1801.         //eventos 16 - nuevo mensaje y 73 - reabrir ticket
  1802.         $tmessageUsers = $entityManager->createQuery('SELECT distinct u'
  1803.             . ' FROM App\Entity\User u'
  1804.             . ' JOIN App\Entity\Ticketmessage tm'
  1805.             . ' WITH u.id = tm.user'
  1806.             . ' WHERE tm.ticket = :ticket'
  1807.             . ' AND tm.user != :user')
  1808.             ->setParameter('ticket', $ticket)
  1809.             ->setParameter('user', $user)
  1810.             ->getResult();
  1812.         //$tmpLast = $ticketRepository->getTicketmessages($ticket)->last();
  1813.         $tmpLast = array_values(array_slice($ticketRepository->getTicketmessages($ticket), -1))[0];
  1815.         if ($idevento == 75) {
  1816.             $tmessageUsers = array($ticket->getUser());
  1817.         }
  1819.         if (!empty($tmessageUsers)) {
  1820.             foreach ($tmessageUsers as $tmessage_user) {
  1821.                 $usersNotyfy_reply = $tmessage_user;
  1822.                 $caseId = $ticket->getSupportCase()->getId();
  1824.                 $escalado = $entityManager->createQuery('SELECT count(t.id)'
  1825.                     . ' FROM App\Entity\Ticket t'
  1826.                     . ' WHERE t.supportcase = :supportcase'
  1827.                     . ' AND (t.level = :level'
  1828.                     . ' OR t.level = :level2)')
  1829.                     ->setParameter('supportcase', $ticket->getSupportcase())
  1830.                     ->setParameter('level', $userRepository->getUserLevel($request, $tmessage_user))
  1831.                     ->setParameter('level2', $userRepository->getUserLevel($request, $tmessage_user) + 1)
  1832.                     ->getSingleScalarResult();
  1834.                 $data = [
  1835.                     'ticket' => $ticket,
  1836.                     'ticketLink' => $user != $ticket->getUser() && $escalado < 2 ? 'ticket/default/reply/' . $caseId : 'ticket/default/replyclient/' . $caseId,
  1837.                     'customerLevel' =>  $userRepository->getUserLevel($request, $usersNotyfy_reply),
  1838.                     'ticketmessage' => $this->getLastMessageToNotify($tmpLast),
  1839.                     'user' => $user,
  1840.                     'messageLevel' => $selfUserLevel,
  1841.                     'companyName' => $userRepository->getCompanyName($ticket->getUser()),
  1842.                     'route' => $user != $ticket->getUser() && $escalado < 2 ? "ticket_reply" : "ticket_replyclient",
  1843.                     'idview' => $ticket->getSupportCase()->getId(),
  1844.                 ];
  1846.                 $serviceNotification->Notify($idevento ? $idevento : 16, array($usersNotyfy_reply), $data);
  1847.             }
  1848.         }
  1849.         //Si nadie le ha contestado la incidencia todavia, notificará a los usuarios on rol que pertoque
  1850.         else {
  1852.             if ($ticket && !$bescalado) {
  1854.                 $arrayusersandroles = $this->getUsersAndRolesToNotify($ticket->getSupportCase(), $ticket, $translator);
  1855.                 $ticketTecnico = $entityManager->createQuery('SELECT tt'
  1856.                     . ' FROM App\Entity\Tickettecnico tt'
  1857.                     . ' WHERE tt.supportcase = :id')
  1858.                     ->setParameter('id', $case->getId())
  1859.                     ->getOneOrNullResult();
  1861.                 $escalado = $entityManager->createQuery('SELECT count(t.id)'
  1862.                     . ' FROM App\Entity\Ticket t'
  1863.                     . ' WHERE t.supportcase = :supportcase')
  1864.                     ->setParameter('supportcase', $ticket->getSupportcase())
  1865.                     ->getOneOrNullResult();
  1867.                 $usersToNotify = $arrayusersandroles['usersToNotify'];
  1868.                 //$tmpLast = $ticketRepository->getTicketmessages($ticket)->last();
  1869.                 $tmpLast = array_values(array_slice($ticketRepository->getTicketmessages($ticket), -1))[0];
  1872.                 $ticketuser = $ticket->getUser();
  1873.                 $serverName = $this->getParameter('server_name');
  1875.                 //datos para envio email
  1876.                 $data = [
  1877.                     'ticket' => $ticket,
  1878.                     'ticketLink' => $user != $ticket->getUser() && $escalado < 2 ? 'ticket/default/reply/' . $ticket->getSupportCase()->getId() : 'ticket/default/replyclient/' . $ticket->getSupportCase()->getId(),
  1879.                     'customer' => $usersToNotify,
  1880.                     'customerLevel' => '',
  1881.                     'ticketmessage' => $this->getLastMessageToNotify($tmpLast),
  1882.                     'user' => $user,
  1883.                     'messageLevel' => $selfUserLevel,
  1884.                     'companyName' => $userRepository->getCompanyName($ticket->getUser()),
  1885.                     'route' => $user != $ticket->getUser() && $escalado < 2 ? "ticket_reply" : "ticket_replyclient",
  1886.                     'idview' => $ticket->getSupportCase()->getId(),
  1887.                 ];
  1890.                 $myticketTecnico = $entityManager->createQuery('SELECT tt'
  1891.                     . ' FROM App\Entity\Tickettecnico tt'
  1892.                     . ' WHERE tt.supportcase = :supportcase')
  1893.                     ->setParameter('supportcase', $case)
  1894.                     ->getOneOrNullResult();
  1896.                 if ($myticketTecnico && $myticketTecnico->getProductline() && $myticketTecnico->getProductline()->getVendor()->getisminivendor()) {
  1898.                     $vendor = $myticketTecnico->getProductline()->getVendor();
  1900.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  1901.                         . ' FROM App\Entity\User u'
  1902.                         . ' WHERE u.vendor = :vendor'
  1903.                         . ' AND u.roles like :role_one')
  1904.                         ->setParameter('vendor', $vendor)
  1905.                         ->setParameter('role_one', '%ROLE_SUPPORT_VENDOR%')
  1906.                         ->getResult();
  1907.                 }
  1908.                 //if ($idevento) { 
  1909.                 $serviceNotification->Notify($idevento ? $idevento : 16, $usersToNotify, $data);
  1910.                 //}
  1911.             }
  1912.         }
  1914.         return;
  1915.     }
  1917.     protected function getFiles($id)
  1918.     {
  1919.         $entityManager = $this->getDoctrine()->getManager();
  1921.         $files = $entityManager->createQuery('SELECT tmf'
  1922.             . ' FROM App\Entity\Ticketmessagefile tmf'
  1923.             . ' JOIN tmf.message tm'
  1924.             . ' WHERE tmf.deletedby is null'
  1925.             . ' AND tm.ticket = :ticket')
  1926.             ->setParameter('ticket', $id)
  1927.             ->getResult();
  1929.         return $files;
  1930.     }
  1932.     /**
  1933.      * @Route("/ticket/default/newticketajax", name="new_ticket_ajax")
  1934.      */
  1936.     public function newTicketAjax(Request $request, TranslatorInterface $translator, ServiceNotification $serviceNotification)
  1937.     {
  1939.         $success = $this->createNewSupportCase($request, $_POST, $translator, $serviceNotification);
  1941.         return new JsonResponse();
  1942.     }
  1944.     private function createNewSupportCase($request, $data, TranslatorInterface $translator, ServiceNotification $serviceNotification, $form = null)
  1945.     {
  1946.         $user = $this->getUser();
  1947.         $entityManager = $this->getDoctrine()->getManager();
  1948.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  1949.         $userwholesaler = $userRepository->getParentWholesaler($user);
  1950.         $countryCode = $userwholesaler ? $userwholesaler->getCountry()->getAlpha2Code() : '';
  1951.         $wholesalerid = $userwholesaler ? $userwholesaler->getId() : '';
  1952.         $codenumber = $countryCode . $wholesalerid . date('y') . date('m') . date('d');
  1953.         $path = $this->getParameter('private_folder') . 'ticket/';
  1954.         $locale = $request->getLocale();
  1956.         $ticketTecnico = new \App\Entity\Tickettecnico;
  1957.         $case = new Supportcase();
  1958.         $ticket = new Ticket();
  1960.         $tipoTicket =  $this->getDoctrine()->getRepository(Tipoticket::class)->find($data['tipoincidencia']);
  1962.         // Crear un nuevo caso con los datos de la incidencia
  1963.         $case->setSubject($data['subject']);
  1964.         $case->setTipoTicket($tipoTicket);
  1965.         $case->setCreatedBy($user);
  1966.         $case->setCreationdate(new \DateTime);
  1967.         $entityManager->persist($case);
  1968.         $entityManager->flush();
  1970.         // Crear nuevo ticket al caso creado anteriormente
  1971.         $ticket->setSupportcase($case);
  1972.         $ticket->setUser($user);
  1973.         $ticket->setLevel($userRepository->getUserLevel($request, $user));
  1974.         $ticket->setCreationdate(new \DateTime);
  1975.         $ticket->setLastmodification(new \DateTime);
  1976.         $ticket->setStatus('PENDING');
  1977.         $entityManager->persist($ticket);
  1978.         $entityManager->flush();
  1980.         $requestLicense = $user->getPartner() ? 'licensesByclient' : 'lista';
  1982.         if (isset($data['idproductline'])) {
  1983.             $idproductline = $data['idproductline'];
  1984.         } elseif ($data[$requestLicense]) {
  1985.             $licencia = $entityManager->createQuery('SELECT l'
  1986.                 . ' FROM App\Entity\License l'
  1987.                 . ' WHERE l.id = :id')
  1988.                 ->setParameter('id', $data[$requestLicense])
  1989.                 ->getOneOrNullResult();
  1991.             $idproductline = $licencia->getProduct()->getProductline()->getId();
  1992.         }
  1994.         // 2- Crear tipo de ticket                                
  1995.         switch ($data['tipoincidencia']) {
  1996.             case 1:
  1997.                 //Técnico
  1998.                 $tipoticket = ($translator->trans('app.Support.DropDownTechnical'));
  2000.                 $ticket_productline = null;
  2001.                 if (isset($idproductline)) {
  2002.                     $ticket_productline = $entityManager->createQuery('SELECT pl'
  2003.                         . ' FROM App\Entity\Productline pl'
  2004.                         . ' WHERE pl.id = :id')
  2005.                         ->setParameter('id', $idproductline)
  2006.                         ->getOneOrNullResult();
  2007.                 }
  2009.                 $ticketTecnico->setProductline($ticket_productline);
  2011.                 $licencia = null;
  2012.                 if ($form->get($requestLicense)->getData()) {
  2013.                     $licencia = $entityManager->createQuery('SELECT l'
  2014.                         . ' FROM App\Entity\License l'
  2015.                         . ' WHERE l.id = :id')
  2016.                         ->setParameter('id', $form->get($requestLicense)->getData())
  2017.                         ->getOneOrNullResult();
  2018.                 }
  2020.                 $ticketTecnico->setLicense($licencia);
  2021.                 $supportCase = $entityManager->createQuery('SELECT sc'
  2022.                     . ' FROM App\Entity\Supportcase sc'
  2023.                     . ' WHERE sc.id = :id')
  2024.                     ->setParameter('id', $ticket->getSupportCase()->getId())
  2025.                     ->getOneOrNullResult();
  2027.                 if ($user->getPartner()) {
  2028.                     // Por si la lista de clientes / licencnias está vacia
  2029.                     if (isset($form['lista']) && $form['lista']->getData()) {
  2030.                         $customer = $this->getDoctrine()->getRepository(\App\Entity\Customer::class)->find($form['lista']->getData());
  2031.                         $ticketTecnico->setCustomer($customer);
  2032.                     }
  2033.                 }
  2034.                 if ($user->getCustomer()) {
  2035.                     $ticketTecnico->setCustomer($user->getCustomer());
  2036.                 }
  2038.                 $ticketTecnico->setSupportCase($supportCase);
  2039.                 $entityManager->persist($ticketTecnico);
  2040.                 $entityManager->flush();
  2041.                 break;
  2042.             case 2:
  2043.                 //Administración
  2044.                 $tipoticket = ($translator->trans('app.Support.DropDownAdministration'));
  2045.                 break;
  2046.             case 3:
  2047.                 //Comercial
  2048.                 $productRepository = $entityManager->getRepository(Product::class);
  2049.                 $product = isset($data['product']) ? $productRepository->find($data['product']) : null;
  2051.                 $ticketComercial = new TicketComercial();
  2052.                 $ticketComercial->setSupportCase($case);
  2054.                 if (!is_null($product)) {
  2055.                     $ticketComercial->setProductline($product->getProductline());
  2056.                     $ticketComercial->setProduct($product);
  2057.                 }
  2059.                 $entityManager->persist($ticketComercial);
  2060.                 $entityManager->flush();
  2062.                 $tipoticket = ($translator->trans('app.Support.DropDownCommercial'));
  2063.                 break;
  2064.             case 4:
  2065.                 //Plataforma
  2066.                 $tipoticket = ($translator->trans('app.Support.DropDownPlatform'));
  2067.                 break;
  2068.         }
  2070.         // 3- creo el mensaje del ticket
  2071.         $tm = new \App\Entity\Ticketmessage;
  2072.         $tm->setUser($user);
  2073.         $tm->setDate(new \DateTime);
  2074.         $tm->setMessage($data['message']);
  2075.         $tm->setLocale($locale);
  2076.         $tm->setStatus($ticket->getStatus());
  2077.         $tm->setLevel($ticket->getLevel());
  2078.         $tm->setTicket($ticket);
  2079.         $entityManager->persist($tm);
  2080.         $entityManager->flush();
  2082.         //Si hay ficheros adjuntos 
  2083.         if (!is_null($form)) {
  2084.             if (!empty($form->get('filename')) && $form->get('filename')->getData() != null) {
  2085.                 $this->uploadFile($path, $tm, $form, $translator);
  2086.             }
  2087.         }
  2088.         $entityManager->persist($tm);
  2089.         $entityManager->flush();
  2091.         // Send email to support manager.
  2092.         if ($ticket->getUser()->getWholesaler() && $ticketTecnico->getProductline()) {
  2094.             $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2095.                 . ' FROM App\Entity\User u'
  2096.                 . ' WHERE u.vendor = :vendor'
  2097.                 . ' AND u.roles like :role_one'
  2098.                 . ' OR u.roles like :role2)')
  2099.                 ->setParameter('vendor', $ticketTecnico->getProductline()->getVendor())
  2100.                 ->setParameter('role_one', '%ROLE_SUPPORT_VENDOR%')
  2101.                 ->setParameter('role2', '%ROLE_ADMIN_USER_VENDOR%')
  2102.                 ->getResult();
  2103.         } else {
  2104.             $levelUp = $userRepository->getLevelUpCompany($ticket->getUser());
  2105.             $partner = $ticket->getUser()->getPartner();
  2107.             if ($case->getTipoTicket()->getId() == 4) {
  2108.                 //tickets platform technical to user katy
  2109.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2110.                     . ' FROM App\Entity\User u'
  2111.                     . ' WHERE u.roles like :role_one')
  2112.                     ->setParameter('role_one', '%ROLE_SUPPORT_KATY%')
  2113.                     ->getResult();
  2114.             } elseif ($case->getTipoTicket()->getId() == 5) {
  2115.                 //tickets bi to user katy
  2116.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2117.                     . ' FROM App\Entity\User u'
  2118.                     . ' WHERE u.roles like :role_one')
  2119.                     ->setParameter('role_one', '%ROLE_BI_MANAGER%')
  2120.                     ->getResult();
  2121.             } elseif ($case->getTipoTicket()->getId() == 6) {
  2122.                 //tickets platform management to user katy
  2123.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2124.                     . ' FROM App\Entity\User u'
  2125.                     . ' WHERE u.roles like :role_one')
  2126.                     ->setParameter('role_one', '%ROLE_SUPPORT_MANAGEMENT_KATY%')
  2127.                     ->getResult();
  2128.             } elseif ($ticket->getUser()->getVendor()) {
  2129.                 //tickets administratives
  2130.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2131.                     . ' FROM App\Entity\User u'
  2132.                     . ' WHERE u.roles like :role_one')
  2133.                     ->setParameter('role_one', '%ROLE_SUPPORT_ADMIN_KATY%')
  2134.                     ->getResult();
  2135.             } elseif ($ticket->getUser()->getWholesaler()) {
  2137.                 if ($case->getTipoTicket()->getId() == 3) { //commercial 
  2138.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2139.                         . ' FROM App\Entity\User u'
  2140.                         . ' WHERE u.wholesaler = :wholesaler'
  2141.                         . ' AND u.roles like :role_one'
  2142.                         . ' OR u.roles like :role2)')
  2143.                         ->setParameter('wholesaler', $levelUp)
  2144.                         ->setParameter('role_one', '%ROLE_COMMERCIAL_AGENT_NEW%')
  2145.                         ->setParameter('role2', '%ROLE_ADMIN_USER_NEW%')
  2146.                         ->getResult();
  2147.                 } else { //administrative
  2148.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2149.                         . ' FROM App\Entity\User u'
  2150.                         . ' WHERE u.wholesaler = :wholesaler'
  2151.                         . ' AND u.roles like :role_one'
  2152.                         . ' OR u.roles like :role2)')
  2153.                         ->setParameter('wholesaler', $levelUp)
  2154.                         ->setParameter('role_one', '%ROLE_MANAGE_SUPPORT_TICKETS_NEW%')
  2155.                         ->setParameter('role2', '%ROLE_ADMIN_USER_NEW%')
  2156.                         ->getResult();
  2157.                 }
  2158.             } elseif ($ticket->getUser()->getPartner()) {
  2160.                 if ($case->getTipoTicket()->getId() == 3) { //commercial
  2161.                     $comercialAgent = $userRepository->find($partner->getIdcommercialagent());
  2162.                     $master = $userRepository->getMaster($partner->getWholesaler());
  2163.                     if ($comercialAgent->getEmail() != $master[0]->getEmail()) {
  2164.                         $usersToNotify = array_merge($master, array($comercialAgent));
  2165.                     } else {
  2166.                         $usersToNotify = $master;
  2167.                     }
  2168.                 } else {
  2169.                     $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2170.                         . ' FROM App\Entity\User u'
  2171.                         . ' WHERE u.wholesaler = :wholesaler'
  2172.                         . ' AND (u.roles like :role_one'
  2173.                         . ' OR u.roles like :role2)')
  2174.                         ->setParameter('wholesaler', $levelUp)
  2175.                         ->setParameter('role_one', '%ROLE_MANAGE_SUPPORT_TICKETS_NEW%')
  2176.                         ->setParameter('role2', '%ROLE_ADMIN_USER_NEW%')
  2177.                         ->getResult();
  2178.                 }
  2179.             } elseif ($ticket->getUser()->getCustomer()) {
  2181.                 $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2182.                     . ' FROM App\Entity\User u'
  2183.                     . ' WHERE u.partner = :partner'
  2184.                     . ' AND (u.roles like :role_one'
  2185.                     . ' OR u.roles like :role2)')
  2186.                     ->setParameter('partner', $levelUp)
  2187.                     ->setParameter('role_one', '%ROLE_SUPPORT_NEW%')
  2188.                     ->setParameter('role2', '%ROLE_ADMIN_USER_NEW_PARTNER%')
  2189.                     ->getResult();
  2190.             }
  2191.         }
  2194.         $data = array();
  2195.         $ticketuser = $ticket->getUser();
  2196.         $serverName = $this->getParameter('server_name');
  2199.         //datos para envio email
  2200.         $data = [
  2201.             'ticket' => $ticket,
  2202.             'customerLevel' => $userRepository->getUserLevel($request, $user),
  2203.             'ticketmessage' => $tm->getMessage(),
  2204.             'user' => $user,
  2205.             'messageLevel' => $userRepository->getUserLevel($request, $user),
  2206.             'route' => 'ticket_replyclient',
  2207.             'idview' => $case->getId(),
  2208.         ];
  2211.         $existsticketTecnico = $entityManager->createQuery('SELECT tt'
  2212.             . ' FROM App\Entity\Tickettecnico tt'
  2213.             . ' WHERE tt.supportcase = :supportcase')
  2214.             ->setParameter('supportcase', $case)
  2215.             ->getOneOrNullResult();
  2217.         if ($existsticketTecnico && $existsticketTecnico->getProductline() && $existsticketTecnico->getProductline()->getVendor()->getisMiniVendor()) {
  2219.             $vendor = $existsticketTecnico->getProductline()->getVendor();
  2221.             $usersToNotify = $entityManager->createQuery('SELECT distinct u'
  2222.                 . ' FROM App\Entity\User u'
  2223.                 . ' WHERE u.vendor = :vendor'
  2224.                 . ' AND (u.roles like :role_one'
  2225.                 . ' OR u.roles like :role2)')
  2226.                 ->setParameter('role_one', '%ROLE_SUPPORT_VENDOR%')
  2227.                 ->setParameter('role2', '%ROLE_ADMIN_USER_VENDOR%')
  2228.                 ->setParameter('vendor', $vendor)
  2229.                 ->getResult();
  2230.         }
  2232.         $serviceNotification->Notify(14, $usersToNotify, $data);
  2233.         return true;
  2234.     }
  2235. }