src/MDS/CommercialBundle/Controller/CommercialTrackingController.php line 607

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by Mediterranean Develup Solutions
  4.  * User: jorge.defreitas@develup.solutions
  5.  * Date: 17/10/2017
  6.  * Time: 11:05
  7.  */
  9. namespace App\MDS\CommercialBundle\Controller;
  11. use App\Entity\Client;
  12. use App\Entity\ClientContact;
  13. use App\Entity\SettingsRol;
  14. use App\Entity\SettingsTeam;
  15. use App\Entity\Supplier;
  16. use App\Entity\SupplierContact;
  17. use App\Entity\User;
  18. use App\MDS\CommercialBundle\Entity\CommercialBreakdownVolume;
  19. use App\MDS\CommercialBundle\Entity\CommercialBreakdownVolumeControl;
  20. use App\MDS\CommercialBundle\Entity\CommercialTracking;
  21. use App\MDS\CommercialBundle\Form\CommercialTrackingType;
  22. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  23. use Symfony\Component\Routing\Annotation\Route;
  24. use Symfony\Component\HttpFoundation\JsonResponse;
  25. use Symfony\Component\HttpFoundation\Request;
  26. use Symfony\Component\Validator\Constraints as Assert;
  27. use Symfony\Component\Validator\Validator\ValidatorInterface;
  28. use Symfony\Contracts\Translation\TranslatorInterface;
  30. class CommercialTrackingController  extends AbstractController
  31. {
  32.     private $translator;
  33.     private $validator;
  35.     public function __construct(TranslatorInterface $translator, ValidatorInterface $validator) {
  36.         $this->translator = $translator;
  37.         $this->validator = $validator;
  38.     }
  39.     
  40.     /**
  41.      * @Route("/tracking/prueba/{page}", name="commercial_tracking_list_prueba")
  42.      */
  43.     public function listPruebaAction($page, Request $request)
  44.     {
  45.         $limit = 10;
  46.         $em = $this->getDoctrine()->getManager();
  47.         $tracking_base = $em->getRepository(CommercialTracking::class);
  50.         $paginator = $tracking_base->paginateDos($limit, $page);
  51. //        $paginator->findAll(array(),array('dateAt' => 'DESC'));
  52.         $totalItems = count($paginator);
  53.         $pagesCount = ceil($totalItems / $limit);
  55.         return $this->render('MDS/CommercialBundle/tracking/list-prueba-tracking.html.twig', array(
  56.             'trackings' => $paginator,
  57.             'totalItems' => $totalItems,
  58.             'pagesCount' => $pagesCount,
  59.             'thisPage' => $page
  60.         ));
  61.     }
  63.     /**
  64.      * @Route("/tracking/list/{page}/{id}", defaults={"page" = 1, "id" = 0}, name="commercial_tracking_list")
  65.      */
  66.     public function listAction($page, $id, Request $request)
  67.     {
  69.         $limit = 10;
  70.         $em = $this->getDoctrine()->getManager();
  71.         $trackingBase = $em->getRepository(CommercialTracking::class);
  73.         /* Obtengo usuario logueado */
  74.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  75.         $user_id = $user_logueado->getId();
  76.         $user_role = $user_logueado->getRole();
  77.         $user_userrol = $user_logueado->getUserrol();
  78.         $user_team = $user_logueado->getTeam();
  79.         $user_teamleader = $user_logueado->getTeamleader();
  82.         /* VERIFICAR EL weight DEL USUARIO */
  83.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  84.         $nivelAcceso = $accesoNivel->getWeight();
  87.         $tracking = array();
  88.         $usertitle = array();
  89.         $verNombre="no";
  90.         $user_url = array();
  91.         if( ( $user_role == "ROLE_ADMIN" || ($nivelAcceso <= '3' AND $user_teamleader == true) )  AND $id == "0"){
  92. //            $tracking = $em->getRepository(CommercialTracking::class)->findBy(
  93. //                array(),
  94. //                array('id' => 'DESC')
  95. //            );
  97.             $user_del_team = $em->getRepository(User::class)->findByTeam($user_team);
  98.             $teamId = array();
  101.             foreach($user_del_team as $user){
  102.                 $teamId[] = $user->getId();
  104.                 $user_url[$user->getId()] = array(
  105.                     'userid' => $user->getId(),
  106.                     'name' => $user->getName()
  107.                 );
  108.             };
  109. //            d($user_url);
  110.             $teamIdver= implode(",", $teamId);
  112.             if (!empty($request->request->get('buscarClient')['palabra'])){
  113.                 $buscarPalabra = $request->request->get('buscarClient')['palabra'];
  115.                 // CONSULTA A ENTIDAD CLIENTE PARA SACAR EL ID DEL CLIENTE QUE RESULTE DE LA CONSULTA
  116.                 $limit = 100;
  117.                 $parametersBs = array(
  118.                     'name' => '%'.$buscarPalabra.'%',
  119.                     'title' => '%'.$buscarPalabra.'%',
  120.                 );
  121.                 $dqlBs = 'SELECT cl.id
  122.                 FROM App:Client cl
  123.                 WHERE cl.name LIKE :name OR cl.title LIKE :title';
  124.                 $queryBs = $em->createQuery($dqlBs)->setParameters($parametersBs);
  125.                 $consultaDentroCliente = $queryBs->getResult();
  126.                 $hay=array();
  127.                 foreach($consultaDentroCliente as $dentro){
  128.                     $hay[] = $dentro['id'];
  129.                 }
  131.                 if(!empty($hay)){
  132.                     $id_hay = implode(",", $hay);
  133.                 }else{
  134.                     $id_hay = "0";
  135.                 }
  138. //                $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.clientId IN($id_hay) ORDER BY p.id DESC";
  139.                 if ($user_role == "ROLE_ADMIN"){
  140.                     $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.clientId IN($id_hay) ORDER BY p.id DESC";
  141.                 }else{
  142.                     $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.clientId IN($id_hay) AND p.commercialId IN($teamIdver) ORDER BY p.id DESC";
  143.                 }
  144.             }else{
  145. //                $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p";
  146.                 if ($user_role == "ROLE_ADMIN"){
  147.                     $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p ORDER BY p.id DESC";
  148.                 }else{
  149.                     $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.commercialId IN($teamIdver) ORDER BY p.id DESC";
  150.                 }
  153.             }
  154.             $usertitle = array(
  155.                 'name' => 'All Tracking',
  156.                 'lastname' => '',
  157.                 'team' => 'Everybody'
  158.             );
  159.             $verNombre="si";
  161.         }else{
  163.             if(( $user_role == "ROLE_USER" AND $nivelAcceso > '2' AND $user_teamleader == false ) AND ($id == "0" OR $id != "0")){
  164.                 $id = $user_id;
  165.                 $verNombre="no";
  166.             }
  168. //            $tracking = $em->getRepository(CommercialTracking::class)->findBy(
  169. //                array('commercialId' => $id),
  170. //                array('id' => 'DESC')
  171. //            );
  173.             if (!empty($request->request->get('buscarClient')['palabra'])){
  175.                 // CONSULTA A ENTIDAD CLIENTE PARA SACAR EL ID DEL CLIENTE QUE RESULTE DE LA CONSULTA
  176.                 $limit = 100;
  177.                 $parametersBs = array(
  178.                     'name' => '%'.$buscarPalabra.'%',
  179.                     'title' => '%'.$buscarPalabra.'%',
  180.                 );
  181.                 $dqlBs = 'SELECT cl.id
  182.                 FROM App:Client cl
  183.                 WHERE cl.name LIKE :name OR cl.title LIKE :title';
  184.                 $queryBs = $em->createQuery($dqlBs)->setParameters($parametersBs);
  185.                 $consultaDentroCliente = $queryBs->getResult();
  186.                 $hay=array();
  187.                 foreach($consultaDentroCliente as $dentro){
  188.                     $hay[] = $dentro['id'];
  189.                 }
  190.                 $id_hay= implode(",", $hay);
  192.                 $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.clientId IN($id_hay) AND p.commercialId = $id";
  194.             }else{
  195.                 $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.commercialId = $id ORDER BY p.id DESC";
  196. //                $dql = "SELECT p FROM App\MDS\CommercialBundle\Entity\CommercialTracking p WHERE p.commercialId = $id";
  197.             }
  200.             $usertitle = $em->getRepository(User::class)->findOneById($id);
  201.             $team = $em->getRepository(SettingsTeam::class)->findOneById($usertitle->getTeam());
  202.             $usertitle->setTeam($team->getTeam());
  204.         }
  205.         $tracking =  $trackingBase->paginate($dql, $limit, $page);
  206.         $totalItems = count($tracking);
  207.         $pagesCount = ceil($totalItems / $limit);
  209.         $data = array();
  210.         $client = array();
  211.         $n="0";
  213.         foreach($tracking as $trackings){
  215. //            d($trackings);
  217.             $user = $em->getRepository(User::class)->findOneById($trackings->getCommercialId());
  218.             $team = $em->getRepository(SettingsTeam::class)->findOneById($user->getTeam());
  220.             $clientType = $trackings->getClientType();
  222.             if($clientType == 'client') {
  223.                 $parameters = array(
  224.                     'clientId' => $trackings->getClientId()
  225.                 );
  227.                 $dql = 'SELECT cl
  228.                 FROM App:Client cl
  229.                 INNER JOIN App:Country c WITH c.id = cl.country
  230.                 INNER JOIN App:Regions p WITH p.id = cl.region
  231.                 INNER JOIN App:Provinces pr WITH pr.id = cl.province
  232.                 INNER JOIN App:Cities r WITH r.id = cl.population
  233.                 WHERE cl.id = :clientId';
  234. //                ORDER BY p.dateProposedAt DESC';
  236.                 $query = $em->createQuery($dql)->setParameters($parameters);
  237.                 $client = $query->getResult();
  239. //                ACA
  240.                 $contact = $em->getRepository(ClientContact::class)->findOneById($trackings->getContactId());
  242.                 $breakdownControl = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  243.                     array(
  244.                         'clientId' => $trackings->getClientId(),
  245.                         'contactId' => $trackings->getContactId(),
  246.                     )
  247.                 );
  248.                 $breakdown = null;
  249.                 if (!empty($breakdownControl)){
  250.                     $breakdown = $em->getRepository(CommercialBreakdownVolume::class)->findByControlId($breakdownControl->getId());
  251.                 }
  253.                 $fecha = $trackings->getDateAt()->format('d/m/Y');
  254.                 $countClient = count($client);
  256.                 if($countClient === 0){
  257.                     $clientP = null;
  258. //                    d('es cero'); die();
  259.                 }else{
  260.                     $clientP = $client[0];
  261.                 }
  263. //                if($client !== null or $client !== 0 or !empty($client) or $countClient !== 0){
  264. ////                if($client !== null or $client !== 0 or !empty($client) or $countClient === 0){
  265. //                    d('viene lleno'); die();
  266. //
  267. //                }else if($countClient === 0){
  268. //                    d('vacio'); die();
  269. //                }
  270.                 $data[] = array(
  271.                     'id' => $trackings->getId(),
  272.                     'fecha' => $fecha,
  273.                     'user' => $user,
  274.                     'team' => $team,
  275.                     'tracking' => $trackings,
  276.                     'client' => $clientP,
  277.                     'contact' => $contact,
  278.                     'breakdownControl' => $breakdownControl,
  279.                     'breakdown' => $breakdown,
  280.                     'clientType' => $clientType,
  281.                 );
  283. //            $em->clear();
  285.             }elseif ($clientType == 'supplier'){
  287.                 $parameters = array(
  288.                     'supplierId' => $trackings->getSupplierId()
  289.                 );
  291.                 $dql = 'SELECT cl
  292.                 FROM App:Supplier cl
  293.                 INNER JOIN App:Country c WITH c.id = cl.country
  294.                 INNER JOIN App:Regions p WITH p.id = cl.region
  295.                 INNER JOIN App:Provinces pr WITH pr.id = cl.province
  296.                 INNER JOIN App:Cities r WITH r.id = cl.population
  297.                 WHERE cl.id = :supplierId';
  299.                 $query = $em->createQuery($dql)->setParameters($parameters);
  300.                 $supplier = $query->getResult();
  302.                 $contact = $em->getRepository(SupplierContact::class)->findOneById($trackings->getContactId());
  304. //                $breakdownControl = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  305. //                    array(
  306. //                        'supplierId' => $trackings->getSupplierId(),
  307. //                        'contactId' => $trackings->getContactId(),
  308. //                    )
  309. //                );
  310. //
  311. //                $breakdown = null;
  312. //                if (!empty($breakdownControl)){
  313. //                    $breakdown = $em->getRepository(CommercialBreakdownVolume::class)->findByControlId($breakdownControl->getId());
  314. //                }
  316.                 $fecha = $trackings->getDateAt()->format('d/m/Y');
  318.                 $data[] = array(
  319.                     'id' => $trackings->getId(),
  320.                     'fecha' => $fecha,
  321.                     'user' => $user,
  322.                     'team' => $team,
  323.                     'tracking' => $trackings,
  324.                     'client' => $supplier[0],
  325.                     'contact' => $contact,
  326.                     'breakdownControl' => ' ',
  327.                     'breakdown' => ' ',
  328.                     'clientType' => $clientType,
  329.                 );
  331.             } else {
  332.                 if (empty($clientType)){
  333.                     $parameters = array(
  334.                         'clientId' => $trackings->getClientId()
  335.                     );
  337.                     $dql = 'SELECT cl
  338.                 FROM App:Client cl
  339.                 INNER JOIN App:Country c WITH c.id = cl.country
  340.                 INNER JOIN App:Regions p WITH p.id = cl.region
  341.                 INNER JOIN App:Provinces pr WITH pr.id = cl.province
  342.                 INNER JOIN App:Cities r WITH r.id = cl.population
  343.                 WHERE cl.id = :clientId';
  344. //                ORDER BY p.dateProposedAt DESC';
  346.                     $query = $em->createQuery($dql)->setParameters($parameters);
  347.                     $client = $query->getResult();
  349. //                ACA
  350.                     $contact = $em->getRepository(ClientContact::class)->findOneById($trackings->getContactId());
  352.                     $breakdownControl = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  353.                         array(
  354.                             'clientId' => $trackings->getClientId(),
  355.                             'contactId' => $trackings->getContactId(),
  356.                         )
  357.                     );
  358.                     $breakdown = null;
  359.                     if (!empty($breakdownControl)){
  360.                         $breakdown = $em->getRepository(CommercialBreakdownVolume::class)->findByControlId($breakdownControl->getId());
  361.                     }
  363.                     $fecha = $trackings->getDateAt()->format('d/m/Y');
  364.                     $countClient = count($client);
  366.                     if($countClient === 0){
  367.                         $clientP = null;
  368. //                    d('es cero'); die();
  369.                     }else{
  370.                         $clientP = $client[0];
  371.                     }
  373. //                if($client !== null or $client !== 0 or !empty($client) or $countClient !== 0){
  374. ////                if($client !== null or $client !== 0 or !empty($client) or $countClient === 0){
  375. //                    d('viene lleno'); die();
  376. //
  377. //                }else if($countClient === 0){
  378. //                    d('vacio'); die();
  379. //                }
  380.                     $data[] = array(
  381.                         'id' => $trackings->getId(),
  382.                         'fecha' => $fecha,
  383.                         'user' => $user,
  384.                         'team' => $team,
  385.                         'tracking' => $trackings,
  386.                         'client' => $clientP,
  387.                         'contact' => $contact,
  388.                         'breakdownControl' => $breakdownControl,
  389.                         'breakdown' => $breakdown,
  390.                         'clientType' => $clientType,
  391.                     );
  393.                 }
  394.             }
  395.         }
  397.         if ( $user_role == "ROLE_ADMIN" ){
  398.             $users = $em->getRepository(User::class)->findBy(['team' => 7]); //Filtrar los usuarios por Comercial MICE
  399.             $user_url = array();
  400.             foreach($users as $user){
  401.                 $user_url[$user->getId()] = array(
  402.                     'userid' => $user->getId(),
  403.                     'name' => $user->getName()
  404.                 );
  405.             };
  406.         }
  408.         return $this->render('MDS/CommercialBundle/tracking/list-tracking.html.twig', array(
  409.             'idview' =>$id,
  410.             'verNombre' => $verNombre,
  411.             'userurl' => $user_url,
  412.             'commercial' => $usertitle,
  413.             'trackings' => $data,
  414.             'totalItems' => $totalItems,
  415.             'pagesCount' => $pagesCount,
  416.             'thisPage' => $page,
  417.             'limitPage' => $limit
  418.         ));
  420.     }
  421.     /**
  422.      * @Route("/tracking/details/{id}", name="commercial_tracking_list_details")
  423.      */
  424.     public function listDetailsAction($id, Request $request)
  425.     {
  426. //        $buscarPalabra = $request->request->get('buscarClient')['palabra'];
  428.         $em = $this->getDoctrine()->getManager();
  429.         $trackingBase = $em->getRepository(CommercialTracking::class);
  431.         /*- Obtengo usuario logueado -*/
  432.         $user_logueado = $this->getUser();
  433.         $user_id = $user_logueado->getId();
  434.         $user_role = $user_logueado->getRole();
  435.         $user_userrol = $user_logueado->getUserrol();
  436.         $user_team = $user_logueado->getTeam();
  437.         $user_teamleader = $user_logueado->getTeamleader();
  439.         /* VERIFICAR EL weight DEL USUARIO */
  440.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  441.         $nivelAcceso = $accesoNivel->getWeight();
  444.         if( $user_role == "ROLE_ADMIN" ){
  445.             $tracking = $em->getRepository(CommercialTracking::class)->findOneById($id);
  446.         }
  447.         if( $nivelAcceso <= '3' AND $user_teamleader == true ){
  448.             $tracking = $em->getRepository(CommercialTracking::class)->findOneById($id);
  449.         }
  450.         if( $user_role == "ROLE_USER" ){
  451.             $tracking = $em->getRepository(CommercialTracking::class)->findOneById($id);
  452.         }
  454.         $user = $user_logueado;
  455.         $team = $em->getRepository(SettingsTeam::class)->findOneById($user->getTeam());
  457.         $parameters = array(
  458.             'clientId' => $tracking->getClientId()
  459.         );
  460.         $dql = 'SELECT cl.id, cl.name, cl.picture, cl.address, cl.addressNumber, cl.zipCode, cl.competency, c.country, re.region, p.name, r.city
  461.             FROM App:Client cl
  462.             INNER JOIN App:Country c WITH c.id = cl.country
  463.             INNER JOIN App:Regions re WITH re.id = cl.region
  464.             INNER JOIN App:Provinces p WITH p.id = cl.province
  465.             INNER JOIN App:Cities r WITH r.id = cl.population
  466.             WHERE cl.id = :clientId';
  467.         $query = $em->createQuery($dql)->setParameters($parameters);
  468.         $client = $query->getResult();
  470.         $contact = $em->getRepository(ClientContact::class)->findOneById($tracking->getContactId());
  472.         $breakdownControl = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  473.             array(
  474.                 'clientId' => $tracking->getClientId(),
  475.                 'contactId' => $tracking->getContactId(),
  476.             )
  477.         );
  478.         $breakdown = null;
  479.         if (!empty($breakdownControl)){
  480.             $breakdown = $em->getRepository(CommercialBreakdownVolume::class)->findByControlId($breakdownControl->getId());
  481.         }
  483.         $fecha = $tracking->getDateAt()->format('d/m/Y');
  485.         $data = array(
  486.             'user' => $user,
  487.             'team' => $team,
  488.             'tracking' => $tracking,
  489.             'client' => $client['0'],
  490.             'contact' => $contact,
  491.             'breakdownControl' => $breakdownControl,
  492.             'breakdown' => $breakdown,
  493.         );
  495.         return $this->render('MDS/CommercialBundle/tracking/list-tracking-details.html.twig', array(
  496.             'tracking' => $data,
  497.         ));
  499.     }
  501.     /**
  502.      * @Route("/tracking/historic/{id}", defaults={"id" = 0},  name="commercial_historic_list")
  503.      */
  504.     public function listHistoricAction($id, Request $request)
  505.     {
  507.         $em = $this->getDoctrine()->getManager();
  508.         $trackingBase = $em->getRepository(CommercialTracking::class);
  510.         /* Obtengo usuario logueado */
  511.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  512.         $user_id = $user_logueado->getId();
  513.         $user_role = $user_logueado->getRole();
  514.         $user_userrol = $user_logueado->getUserrol();
  515.         $user_team = $user_logueado->getTeam();
  516.         $user_teamleader = $user_logueado->getTeamleader();
  518.         /* VERIFICAR EL weight DEL USUARIO */
  519.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  520.         $nivelAcceso = $accesoNivel->getWeight();
  522.         $verNombre="no";
  523.         $user_url = array();
  524.         if($nivelAcceso <= '3' AND $user_teamleader == true){
  525.             $verNombre="si";
  527.             $user_del_team = $em->getRepository(User::class)->findByTeam($user_team);
  528.             $teamId = array();
  530.             foreach($user_del_team as $user){
  531.                 $teamId[] = $user->getId();
  533.                 $user_url[$user->getId()] = array(
  534.                     'userid' => $user->getId(),
  535.                     'name' => $user->getName()
  536.                 );
  537.             };
  538.             $teamIdver= implode(",", $teamId);
  541.             if($id == "0"){
  543. //                $tracking = $em->getRepository(CommercialTracking::class)->findBy(
  544. //                    array('dateAt' => 'DESC')
  545. //                );
  546.                 $parameters = array(
  547.                     'teamIdver' => $teamIdver
  548.                 );
  549.                 $dql = 'SELECT tr
  550.                 FROM App\MDS\CommercialBundle\Entity\CommercialTracking tr
  551.                 WHERE tr.commercialId IN ( :teamIdver )';
  552.                 $query = $em->createQuery($dql)->setParameters($parameters);
  553.                 $tracking = $query->getResult();
  555.             }else{
  556.                 $tracking = $em->getRepository(CommercialTracking::class)->findBy(
  557.                     array('commercialId' => $id),
  558.                     array('dateAt' => 'DESC')
  559.                 );
  560.             }
  561.             $usertitle = array(
  562.                 'name' => 'All Tracking',
  563.                 'lastname' => '',
  564.                 'team' => 'Everybody'
  565.             );
  566.         }else{
  567.             $tracking = $em->getRepository(CommercialTracking::class)->findBy(
  568.                 array('commercialId' => $user_id),
  569.                 array('dateAt' => 'DESC')
  570.             );
  572.             $usertitle = $em->getRepository(User::class)->findOneById($user_id);
  573.         }
  576.         $data = array();
  577.         $client = array();
  578.         $n="0";
  579.         foreach($tracking as $trackings){
  581.             $commercial = $em->getRepository(User::class)->findOneById($trackings->getCommercialId());
  582.             $client = $em->getRepository(Client::class)->findOneById($trackings->getClientId());
  583.             $contact = $em->getRepository(ClientContact::class)->findOneById($trackings->getContactId());
  585.             $data[] = array(
  586.                 'tracking' => $trackings,
  587.                 'client' => $client,
  588.                 'contact' => $contact,
  589.                 'commercial' => $commercial,
  590.             );
  592.         }
  594.         return $this->render('MDS/CommercialBundle/historic/list-historic.html.twig', array(
  595.             'trackings' => $data,
  596.             'commercial' => $usertitle,
  597.             'userurl' => $user_url,
  598.             'verNombre' => $verNombre
  599.         ));
  602.     }
  604.     /**
  605.      * @Route("/tracking/addcc/{cid}/{coid}", defaults={"cid" = 0, "coid" = 0},  name="commercial_tracking_add_client_contact")
  606.      */
  607.     public function addCcAction($cid, $coid, Request $request)
  608.     {
  609.         $em = $this->getDoctrine()->getManager();
  610.         $tracking = new CommercialTracking();
  611. //        $tracking->setDateAt();
  612.         //d('entro');
  613.         $client = $em->getRepository(Client::class)->findOneById($cid);
  614.         //d($client); die();
  615.         $tracking->setClientId($client);
  616.         $tracking->setContactId($coid);
  618.         $tracking->setTimeStart(new \DateTime('00:00:00'));
  619.         $tracking->setTimeEnd(new \DateTime('00:00:00'));
  620.         $tracking->setDateAt(new \DateTime("now"));
  621.         $form = $this->createTrackingCreateForm($tracking);
  623.         return $this->render('MDS/CommercialBundle/tracking/add-tracking.html.twig', array('form' => $form->createView()));
  624.     }
  625.     /**
  626.      * @Route("/tracking/add/", name="commercial_tracking_add")
  627.      */
  628.     public function addAction(Request $request)
  629.     {
  630.         $tracking = new CommercialTracking();
  631. //        $tracking->setDateAt();
  632.         $tracking->setTimeStart(new \DateTime('00:00:00'));
  633.         $tracking->setTimeEnd(new \DateTime('00:00:00'));
  634.         $tracking->setDateAt(new \DateTime("now"));
  635.         $form = $this->createTrackingCreateForm($tracking);
  637.         return $this->render('MDS/CommercialBundle/tracking/add-tracking.html.twig', array('form' => $form->createView()));
  638.     }
  640.     private function createTrackingCreateForm(CommercialTracking $entity)
  641.     {
  642.         $form = $this->createForm(CommercialTrackingType::class, $entity, array(
  643.             'action' => $this->generateUrl('commercial_tracking_create'),
  644.             'method' => 'POST'
  645.         ));
  647.         return $form;
  648.     }
  650.     /**
  651.      * @Route("/tracking/create", name="commercial_tracking_create")
  652.      */
  653.     public function createTrackingAction(Request $request)
  654.     {
  655.         /* prevenir que contacto no este en blanco */
  656. //        $contactId2 = $request->request->get('proposal')['contactId'];
  657.         $em = $this->getDoctrine()->getManager();
  659.         $tracking = new CommercialTracking();
  660.         $form = $this->createTrackingCreateForm($tracking);
  661.         $form->handleRequest($request);
  663.         $title = $form->get('title')->getData();
  664.         $contactId = $form->get('contactId')->getData();
  665.         $volume = $form->get('volume')->getData();
  666.         $year = $form->get('year')->getData();
  667.         $timeEnd = $form->get('timeEnd')->getData();
  668.         $payment = $form->get('payment')->getData();
  669.         $comerciales = $form->get('visit')->getData();
  672.         /* Obtengo usuario logueado */
  673.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  674.         $user_id = $user_logueado->getId();
  675.         $type = $form->get('clientType')->getData();
  677.         $titleIdConstraint = new Assert\NotBlank();
  678. //        $contactIdConstraint = new Assert\NotBlank();
  679.         $errorList = $this->validator->validate($title, $titleIdConstraint);
  680. //        $errorList = $this->validator->validate($contactId, $contactIdConstraint);
  682.         if (!count($errorList) == 0) {
  683.             $errorMessage_contact = $this->translator->trans('Check contact field');
  684.         } else {
  685.             $errorMessage_contact = "";
  686.             if($contactId !== null){
  687.                 /* Consulta el agente comercial asignado */
  688.                 $data_contact = $em->getRepository(ClientContact::class)->findOneById($contactId);
  689.             } else {
  690.                 $data_contact = null;
  691.             }
  692.         }
  694.         if (count($errorList) == 0) {
  696. //        if ($form->isSubmitted()) {
  697. //        if ($form->isValid() && count($errorList) == 0) {
  699.             if(count($comerciales) > 0){
  700.                 for ($i = 0; $i < count($comerciales); ++$i) {
  702.                     $tracking = new CommercialTracking();
  703.                     $form = $this->createTrackingCreateForm($tracking);
  704.                     $form->handleRequest($request);
  706.                     if (empty($timeEnd)) {
  707.                         $tracking->setTimeEnd(new \DateTime('00:00:00'));
  708.                     }
  710.                     if ($type == 'supplier') {
  711.                         $supplierID = $form->get('supplierId')->getData();
  713.                         $tracking->setSupplierId($supplierID->getId());
  714.                         $tracking->setClientId(0);
  716.                     } elseif ($type == 'client') {
  717.                         $client_tracking = $form->get('clientId')->getData();
  719.                         if (!is_null($client_tracking)) {
  720.                             $clientId = $client_tracking->getId();
  721.                             $tracking->setClientId($client_tracking->getId());
  722.                             $tracking->setSupplierId(0);
  723.                         }
  724.                     }
  726.                     $tracking->setContactId($contactId);
  727.                     $tracking->setCommercialId($comerciales[$i]->getId());
  728.                     $tracking->setCreatedId($user_id);
  729.                     $tracking->setUpdatedId($user_id);
  731.                     $situation = $tracking->getSituation();
  732.                     $status = $tracking->getStatus();
  733.                     if (!empty($situation) and !empty($status)) {
  735.                         if ($type == 'client') {
  736.                             $data_client = $em->getRepository(Client::class)->findOneById($clientId);
  737.                             $status_Client = $data_client->getAction();
  738.                             if (
  739.                                 $status == "FOLLOW UP" or
  740.                                 $status == "INCIDENCE" or
  741.                                 $status == "RISK/RFP" or
  742.                                 $status == "CLIENT LOST"
  743.                             ) {
  744.                                 $status_Client = "CLIENT";
  745.                             }
  746.                             $data_client->setAction($status_Client);
  747.                             $em->persist($data_client);
  748.                         }
  750.                         $data_contact->setSituation($situation);
  751.                         $data_contact->setStatus($status);
  753.                         $em->persist($data_contact);
  754.                         $em->flush();
  755.                     }
  757.                     if (!empty($volume) AND !empty($year)) {
  758.                         $data_control = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  759.                             array(
  760.                                 'contactId' => $contactId,
  761.                                 'year' => $year,
  762.                             )
  763.                         );
  765.                         if ($tracking->getClientType() == 'client') {
  766.                             $clientId = $clientId;
  767.                         } elseif ($tracking->getClientType() == 'supplier') {
  768.                             $clientId = 0;
  769.                         }
  770.                         if (empty($data_control)) {
  771.                             $breakdowncontrol = new CommercialBreakdownVolumeControl();
  772.                             $breakdowncontrol->setTrackingId($tracking->getId());
  773.                             $breakdowncontrol->setClientId($clientId);
  774.                             $breakdowncontrol->setContactId($contactId);
  775.                             $breakdowncontrol->setYear($year);
  776.                             $breakdowncontrol->setVolume($volume);
  777.                             $breakdowncontrol->setCommercialId($user_id);
  778.                             $breakdowncontrol->setPayment($payment);
  779.                             $breakdowncontrol->setCreatedId($user_id);
  780.                             $breakdowncontrol->setUpdatedId($user_id);
  781.                             $em->persist($breakdowncontrol);
  782.                         } else {
  783.                             $breakdowncontroledit = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneById($data_control->getId());
  784.                             $breakdowncontroledit->setTrackingId($tracking->getId());
  785.                             $breakdowncontroledit->setYear($year);
  786.                             $breakdowncontroledit->setVolume($volume);
  787.                             $breakdowncontroledit->setCommercialId($user_id);
  788.                             $breakdowncontroledit->setPayment($payment);
  789.                             $breakdowncontroledit->setCreatedId($user_id);
  790.                             $breakdowncontroledit->setUpdatedId($user_id);
  791.                             $em->persist($breakdowncontroledit);
  792.                         }
  793.                     }
  794.                     $em->persist($tracking);
  795.                 }
  796.             } else {
  798.                 $tracking = new CommercialTracking();
  799.                 $form = $this->createTrackingCreateForm($tracking);
  800.                 $form->handleRequest($request);
  802.                 if (empty($timeEnd)) { $tracking->setTimeEnd(new \DateTime('00:00:00')); }
  803.                 
  804.                 $typology = $request->request->get('commercialtracking')['typology'] ?? null;
  805.                 if ($type == 'supplier') {
  806.                     $supplierID = $form->get('supplierId')->getData();
  808.                     $tracking->setSupplierId($supplierID->getId());
  809.                     $tracking->setClientId(0);
  811.                     if (!empty($typology) and $supplierID->getTypology() == null) {
  812.                         $data_supplier = $em->getRepository(Supplier::class)->findOneById($supplierID);
  813.                         $data_supplier->setTypology($typology);
  814.                         $em->persist($data_supplier);
  815.                     }
  817.                 } elseif ($type == 'client') {
  818.                     $client_tracking = $form->get('clientId')->getData();
  820.                     if (!is_null($client_tracking)) {
  821.                         $clientId = $client_tracking->getId();
  822.                         $tracking->setClientId($client_tracking->getId());
  823.                         $tracking->setSupplierId(0);
  824.                     }
  826.                     if (!empty($typology) and $client_tracking->getTypology() == null) {
  827.                         $data_client = $em->getRepository(Client::class)->findOneById($clientId);
  828.                         $data_client->setTypology($typology);
  829.                         $em->persist($data_client);
  830.                     }
  831.                 }
  833.                 $tracking->setContactId($contactId);
  834.                 $tracking->setCommercialId($user_id);
  835.                 $tracking->setCreatedId($user_id);
  836.                 $tracking->setUpdatedId($user_id);
  838. //            $em->persist($tracking);
  839.                 $situation = $tracking->getSituation();
  840.                 $status = $tracking->getStatus();
  841.                 if (!empty($situation) and !empty($status) and !empty($clientId)) {
  843.                     if ($type == 'client') {
  844.                         $data_client = $em->getRepository(Client::class)->findOneById($clientId);
  845.                         $status_Client = $data_client->getAction();
  846.                         if (
  847.                             $status == "FOLLOW UP" or
  848.                             $status == "INCIDENCE" or
  849.                             $status == "RISK/RFP" or
  850.                             $status == "CLIENT LOST"
  851.                         ) {
  852.                             $status_Client = "CLIENT";
  853.                         }
  854.                         $data_client->setAction($status_Client);
  855.                         $em->persist($data_client);
  856.                     }
  858.                     if (!empty($data_contact)) {
  859.                         $data_contact->setSituation($situation);
  860.                         $data_contact->setStatus($status);
  862.                         $em->persist($data_contact);
  863.                         $em->flush();
  864.                     }
  865.                 }
  867.                 if (!empty($volume) AND !empty($year)) {
  868.                     $data_control = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  869.                         array(
  870.                             'contactId' => $contactId,
  871.                             'year' => $year,
  872.                         )
  873.                     );
  875.                     if ($tracking->getClientType() == 'client') {
  876.                         $clientId = $clientId;
  877.                     } elseif ($tracking->getClientType() == 'supplier') {
  878.                         $clientId = 0;
  879.                     }
  880.                     if (empty($data_control)) {
  881.                         $breakdowncontrol = new CommercialBreakdownVolumeControl();
  882.                         $breakdowncontrol->setTrackingId($tracking->getId());
  883.                         $breakdowncontrol->setClientId($clientId);
  884.                         $breakdowncontrol->setContactId($contactId);
  885.                         $breakdowncontrol->setYear($year);
  886.                         $breakdowncontrol->setVolume($volume);
  887.                         $breakdowncontrol->setCommercialId($user_id);
  888.                         $breakdowncontrol->setPayment($payment);
  889.                         $breakdowncontrol->setCreatedId($user_id);
  890.                         $breakdowncontrol->setUpdatedId($user_id);
  891.                         $em->persist($breakdowncontrol);
  892.                     } else {
  893.                         $breakdowncontroledit = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneById($data_control->getId());
  894.                         $breakdowncontroledit->setTrackingId($tracking->getId());
  895.                         $breakdowncontroledit->setYear($year);
  896.                         $breakdowncontroledit->setVolume($volume);
  897.                         $breakdowncontroledit->setCommercialId($user_id);
  898.                         $breakdowncontroledit->setPayment($payment);
  899.                         $breakdowncontroledit->setCreatedId($user_id);
  900.                         $breakdowncontroledit->setUpdatedId($user_id);
  901.                         $em->persist($breakdowncontroledit);
  902.                     }
  903.                 }
  905.                 $em->persist($tracking);
  906.             }
  908.             $em->flush();
  909.             $event = 'The Commercial Tracking has been created.';
  910.             $successMessage = $this->translator->trans($event);
  911.             $this->addFlash('mensajetracking', $successMessage);
  912.         } else {
  913.             $errorMessagebase = $this->translator->trans('Error, some fields are empty');
  914.             $errorMessage = $errorMessagebase . ' | ' . $errorMessage_contact;
  915.             $this->addFlash('mensajetrackingerror', $errorMessage);
  916.         }
  918.         return $this->redirectToRoute('commercial_tracking_list');
  919.     }
  922.     /**
  923.      * @Route("/tracking/listdesplegable", name="post_tracking_select")
  924.      */
  925.     public function clientSelectAction(Request $request) {
  927. //        $idclient = $_POST['client'];
  928.         $id = $_POST['client'];
  930.         /* Obtengo usuario logueado */
  931.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  932.         $user_id = $user_logueado->getId();
  933.         $user_role = $user_logueado->getRole();
  935.         $em = $this->getDoctrine()->getManager();
  936.         $contacts = $em->getRepository(ClientContact::class)->findBy(
  937.             array(
  938.                 'clientId' => $id
  939.             )
  940.         );
  942. //        if($user_role == "ROLE_ADMIN"){
  943. //            $contacts = $em->getRepository(ClientContact::class)->findBy(
  944. //                array(
  945. //                    'clientId' => $id
  946. //                )
  947. //            );
  948. //        }else{
  949. //            $contacts = $em->getRepository(ClientContact::class)->findBy(
  950. //                array(
  951. //                    'clientId' => $id,
  952. //                    'assignedAgent' => $user_id,
  953. //                )
  954. //
  955. //            );
  956. //        }
  957.         $datos = array();
  958.         if (!empty($contacts)){
  959. //            $datos = array();
  960.             foreach($contacts as $contact){
  961.                 $datos[] = array(
  962.                     "idcliente" => $contact->getClientId(),
  963.                     "id" => $contact->getId(),
  964.                     "name" => $contact->getName(),
  965.                     "lastname" => $contact->getLastname(),
  966.                     "department" => $contact->getDepartment(),
  967.                 );
  968.                 $agenteid = $contact->getAssignedAgent();
  969.             }
  971.         }
  972. //        else
  973. //        {
  974. //            $datos[] = array(
  975. //                "idcliente" => '',
  976. //                "id" => '',
  977. //                "name" => $this->translator->trans('No assigned contact'),
  978. //                "lastname" => '',
  979. //                "department" => $this->translator->trans('Please add contact'),
  980. //            );
  981. //
  982. //        }
  984.         /* VERIFICAR EL weight DEL USUARIO */
  985.         $user_userrol = $user_logueado->getUserrol();
  986.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  989.         if($user_role == "ROLE_ADMIN"){
  990.             $disabled = "no";
  991.         }else{
  992.             if ($agenteid == $user_id){
  993.                 $disabled = "no";
  994.             }else{
  995.                 $disabled = "yes";
  996.             }
  997.         }
  999.         $return = array(
  1000.             'contacts' => $datos,
  1001.             'disabled' => $disabled,
  1002.         );
  1004.         $response = new JsonResponse($return);
  1005.         return $response;
  1006.     }
  1009.     /**
  1010.      * @Route("/tracking/contactSuppliers", name="tracking_supplier")
  1011.      */
  1012.     public function suppliersSelectAction(Request $request) {
  1015.         /* Obtengo usuario logueado */
  1016.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1017.         $user_id = $user_logueado->getId();
  1018.         $user_role = $user_logueado->getRole();
  1020. //        $idclient = $_POST['client'];
  1021.         $idSupplier = $_POST['idSupplier'];
  1022. //        $idSupplier = 6;
  1023. //        $idSupplier = 3;
  1024.         $em = $this->getDoctrine()->getManager();
  1025.         $supplierContact = $em->getRepository(SupplierContact::class)->findBySupplierId($idSupplier);
  1027. //        d($supplierContact); die();
  1031. //        if($user_role == "ROLE_ADMIN"){
  1032. //            $contacts = $em->getRepository(ClientContact::class)->findBy(
  1033. //                array(
  1034. //                    'clientId' => $idclient
  1035. //                )
  1036. //            );
  1037. //        }else{
  1038. //            $contacts = $em->getRepository(ClientContact::class)->findBy(
  1039. //                array(
  1040. //                    'clientId' => $idclient,
  1041. //                    'assignedAgent' => $user_id,
  1042. //                )
  1043. //
  1044. //            );
  1045. //        }
  1047.         $datos = array();
  1048.         if (!empty($supplierContact)){
  1049. //            $datos = array();
  1050.             foreach($supplierContact as $contact){
  1051.                 $datos[] = array(
  1052. //                    "idcliente" => $contact->getClientId(),
  1053.                     "id" => $contact->getId(),
  1054.                     "name" => $contact->getName(),
  1055.                     "lastname" => $contact->getLastname(),
  1056. //                    "department" => $contact->getDepartment(),
  1057.                 );
  1058. //                $agenteid = $contact->getAssignedAgent();
  1059.             }
  1061.         }
  1063. //        d($datos); die();
  1064. //        else
  1065. //        {
  1066. //            $datos[] = array(
  1067. //                "idcliente" => '',
  1068. //                "id" => '',
  1069. //                "name" => $this->translator->trans('No assigned contact'),
  1070. //                "lastname" => '',
  1071. //                "department" => $this->translator->trans('Please add contact'),
  1072. //            );
  1073. //
  1074. //        }
  1076.         /* VERIFICAR EL weight DEL USUARIO */
  1077.         $user_userrol = $user_logueado->getUserrol();
  1078.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  1081. //        if($user_role == "ROLE_ADMIN"){
  1082. //            $disabled = "no";
  1083. //        }else{
  1084. //            if ($agenteid == $user_id){
  1085. //                $disabled = "no";
  1086. //            }else{
  1087. //                $disabled = "yes";
  1088. //            }
  1089. //        }
  1091.         $return = array(
  1092.             'contacts' => $datos,
  1093. //            'disabled' => $disabled,
  1094.         );
  1096.         $response = new JsonResponse($return);
  1097.         return $response;
  1098.     }
  1101.     /**
  1102.      * @Route("/tracking/contactClients", name="tracking_clients")
  1103.      */
  1104.     public function clientsSelectAction(Request $request) {
  1107.         /* Obtengo usuario logueado */
  1108.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1109.         $user_id = $user_logueado->getId();
  1110.         $user_role = $user_logueado->getRole();
  1112.         $idClient = $_POST['client'];
  1113.         $em = $this->getDoctrine()->getManager();
  1114.         $supplierContact = $em->getRepository(ClientContact::class)->findByClientId($idClient);
  1116.         $datos = array();
  1117.         if (!empty($supplierContact)){
  1118. //            $datos = array();
  1119.             foreach($supplierContact as $contact){
  1120.                 $datos[] = array(
  1121. //                    "idcliente" => $contact->getClientId(),
  1122.                     "id" => $contact->getId(),
  1123.                     "name" => $contact->getName(),
  1124.                     "lastname" => $contact->getLastname(),
  1125. //                    "department" => $contact->getDepartment(),
  1126.                 );
  1127. //                $agenteid = $contact->getAssignedAgent();
  1128.             }
  1130.         }
  1132.         /* VERIFICAR EL weight DEL USUARIO */
  1133.         $user_userrol = $user_logueado->getUserrol();
  1134.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  1136.         $return = array(
  1137.             'contacts' => $datos,
  1138. //            'disabled' => $disabled,
  1139.         );
  1141.         $response = new JsonResponse($return);
  1142.         return $response;
  1143.     }
  1146.     /**
  1147.      * @Route("/tracking/contactdepartment", name="get_edit_tracking_select_contact")
  1148.      */
  1149. //    public function clientSelectActionEdit($idclient, $idtracking, Request $request) {
  1150.     public function clientSelectActionContactEdit(Request $request) {
  1152.         $id = $_POST['id'];
  1154.         $em = $this->getDoctrine()->getManager();
  1155.         $contacts = $em->getRepository(ClientContact::class)->findOneById($id);
  1157.         $year_now = date('Y');
  1158.         $datatrakincontrol = $em->getRepository(CommercialBreakdownVolumeControl::class)->findOneBy(
  1159.             array(
  1160.                 'contactId' => $id,
  1161. //                'year' => $year_now,
  1162.             )
  1163.         );
  1164.         if (!empty($datatrakincontrol)){
  1165.             //$volume
  1166.             if (is_null($datatrakincontrol->getVolume()) or empty($datatrakincontrol->getVolume())){
  1167.                 $volume = "";
  1168.             }else{
  1169.                 $volume = $datatrakincontrol->getVolume();
  1170.             }
  1171.             //$year
  1172.             if (is_null($datatrakincontrol->getYear()) or empty($datatrakincontrol->getYear())){
  1173.                 $year = "";
  1174.             }else{
  1175.                 $year = $datatrakincontrol->getYear();
  1176.             }
  1177.             //$payment
  1178.             if (is_null($datatrakincontrol->getPayment()) or empty($datatrakincontrol->getPayment())){
  1179.                 $payment = "";
  1180.             }else{
  1181.                 $payment = $datatrakincontrol->getPayment();
  1182.             }
  1183.         }else{
  1184.             $volume = "";
  1185.             $year = "";
  1186.             $payment = "";
  1187.         }
  1188.         //$department
  1189.         if (!empty($contacts)){
  1190.             $department = $contacts->getDepartment();
  1191.         }else{
  1192.             $department = $this->translator->trans('Please add contact');
  1193.         }
  1196.         $return = array(
  1197.             'department' => $department,
  1198.             'volume' => $volume,
  1199.             'year' => $year,
  1200.             'payment' => $payment,
  1201.         );
  1203.         $response = new JsonResponse($return);
  1204.         return $response;
  1205.     }
  1209.     /**
  1210.      * @Route("/tracking/contactName", name="get_edit_tracking_contact")
  1211.      */
  1212.     public function contactNameActionContactEdit(Request $request) {
  1214.         $client = $_POST['client'];
  1216.         $em = $this->getDoctrine()->getManager();
  1217.         $contactCommercial = $em->getRepository(ClientContact::class)->findByClientId($client);
  1219.         $return = array(
  1220.             'contacts' => $contactCommercial,
  1221.         );
  1222.         $response = new JsonResponse($return);
  1223.         return $response;
  1224.     }
  1226.     /**
  1227.      * @Route("/tracking/edit/{id}",  name="commercial_tracking_edit")
  1228.      */
  1229.     public function editAction($id)
  1231.     {
  1232.         $em = $this->getDoctrine()->getManager();
  1234.         /* Obtengo usuario logueado */
  1235.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1236.         $user_id = $user_logueado->getId();
  1237.         $user_role = $user_logueado->getRole();
  1238.         $user_userrol = $user_logueado->getUserrol();
  1240.         /* VERIFICAR EL weight DEL USUARIO */
  1241.         $accesoNivel = $em->getRepository(SettingsRol::class)->findOneById($user_userrol);
  1242.         $nivelAcceso = $accesoNivel->getWeight();
  1244.         $tracking = $em->getRepository(CommercialTracking::class)->findOneById($id);
  1246.         if($tracking->getClientId() == 0){
  1247.             $contact = $em->getRepository(SupplierContact::class)->findOneBy(array(
  1248.                 'id' => $tracking->getContactId(),
  1249.             ));
  1250. //            $fullNameContact = $contact->getName().' '.$contact->getLastname();
  1252.             $departament = null;
  1254.             if($user_id == $tracking->getCommercialId() || $user_role == "ROLE_ADMIN" || $nivelAcceso <= '2'){
  1256.                 $client = $em->getRepository(Supplier::class)->findOneById($tracking->getSupplierId());
  1258. //                d($client);
  1259.                 $tracking->setSupplierId($client);
  1260. //                $tracking->setContactId($contact);
  1262. //            d($tracking); die();
  1264.                 $form = $this->EditTrackingForm($tracking, $id);
  1266.                 return $this->render('MDS/CommercialBundle/tracking/edit-tracking.html.twig',
  1267.                     array(
  1268.                         'department' => $departament,
  1269.                         'form' => $form->createView()
  1270.                     )
  1271.                 );
  1272.             }
  1274.         }else{
  1275.             $contact = $em->getRepository(ClientContact::class)->findOneBy(array(
  1276.                 'clientId' => $tracking->getClientId(),
  1277.                 'id' => $tracking->getContactId(),
  1278.             ));
  1279.             
  1280.             $fullNameContact = $contact->getName().' '.$contact->getLastname();
  1282.             $departament = $contact->getDepartment();
  1284.             if($user_id == $tracking->getCommercialId() || $user_role == "ROLE_ADMIN" || $nivelAcceso <= '2'){
  1286.                 $client = $em->getRepository(Client::class)->findOneById($tracking->getClientId());
  1288.                 $tracking->setClientId($client);
  1289.                 // $tracking->setContactId($fullNameContact);
  1291.                 $form = $this->EditTrackingForm($tracking, $id);
  1293.                 return $this->render('MDS/CommercialBundle/tracking/edit-tracking.html.twig',
  1294.                     array(
  1295.                         'department' => $departament,
  1296.                         'form' => $form->createView()
  1297.                     )
  1298.                 );
  1299.             }
  1300.         }
  1302.         return $this->redirectToRoute('error_access');
  1303.     }
  1306.     private function EditTrackingForm(CommercialTracking $entity, $id)
  1307.     {
  1308.         $form = $this->createForm(CommercialTrackingType::class, $entity,
  1309.             array(
  1310.                 'action' => $this->generateUrl('commercial_tracking_update',
  1311.                     array(
  1312.                         'id' => $id
  1313.                     )
  1314.                 )));
  1316.         return $form;
  1317.     }
  1320.     /**
  1321.      * @Route("/tracking/update/{id}", name="commercial_tracking_update", methods={"POST"})
  1322.      */
  1323.     public function updateAction($id, Request $request)
  1324.     {
  1326.         $em = $this->getDoctrine()->getManager();
  1327.         $tracking = $em->getRepository(CommercialTracking::class)->findOneById($id);
  1328.         
  1329.         $form = $this->EditTrackingForm($tracking, $id);
  1330.         $form->handleRequest($request);
  1332.         if($tracking->getClientType() == 'supplier'){
  1333.             $client_proposal = $form->get('supplierId')->getData();
  1334.             $tracking->setSupplierId($client_proposal->getId());
  1335.             $tracking->setClientId(0);
  1336.         }else{
  1337.             $client_proposal = $form->get('clientId')->getData();
  1338.             $tracking->setClientId($client_proposal->getId());
  1339.             $tracking->setSupplierId(0);
  1340.         }
  1342.         if($form->isValid())
  1343.         {
  1345.             if($tracking->getClientType() == 'supplier') {
  1346.                 $data_contact = $em->getRepository(SupplierContact::class)->findOneById($tracking->getContactId());
  1347.             }else{
  1348.                 $data_contact = $em->getRepository(ClientContact::class)->findOneById($tracking->getContactId());
  1349.                 $situation = $tracking->getSituation();
  1350.                 if (!empty($situation)){
  1351.                     $data_contact->setSituation($situation);
  1352.                     $em->persist($data_contact);
  1353.                     $em->flush();
  1354.                 }
  1355.             }
  1357.             /* Obtengo usuario logueado */
  1358.             $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1359.             $user_id = $user_logueado->getId();
  1361.             $tracking->getUpdatedId($user_id);
  1364.             /* Gestión de eventos en Log */
  1365.             $user_lastname = $user_logueado->getLastname();
  1366.             $user_name = $user_logueado->getName();
  1367.             $user_email = $user_logueado->getEmail();
  1368.             $user_rol = $user_logueado->getRoles();
  1369.             $event_url = $request->getPathInfo();
  1370.             $event_complete = $user_name.' '.$user_lastname.' - '.$user_email.' - '.$user_rol[0].' | '.$event_url;
  1372.             $em->persist($tracking);
  1373.             $em->flush();
  1374.             $event = 'The Tracking has been Updated. Now';
  1376.             $successMessage = $this->translator->trans($event);
  1377.             $this->addFlash('mensajetracking', $successMessage);
  1379.             return $this->redirectToRoute('commercial_tracking_list',
  1380.                 array(
  1381.                     '_fragment' => 's'.$tracking->getId()
  1382.                 )
  1383.             );
  1385.         }else{
  1386.             $errorMessage = $this->translator->trans('Error, some fields are empty');
  1387.             $this->addFlash('mensajetrackingerror', $errorMessage);
  1388.         }
  1390.         return $this->render('MDS/CommercialBundle/tracking/edit-tracking.html.twig', array(
  1391.                     'department' => '', 
  1392.                     'form' => $form->createView()
  1393.             )
  1394.         );
  1395.     }
  1397.     /**
  1398.      * @Route("/tracking/events", name="get_commercial_tracking_select")
  1399.      */
  1400.     public function TrackingSelectAction(Request $request) {
  1402.         $em = $this->getDoctrine()->getManager();
  1403.         $user_logueado = $this->get('security.token_storage')->getToken()->getUser();
  1404.         $user_id = $user_logueado->getId();
  1405. //        $trackings = $em->getRepository(CommercialTracking::class)->findBy(
  1406. //            array('commercialId' => $user_id),
  1407. //            array('timeStart' => 'ASC')
  1408. //        );
  1410.         $parametersA = array(
  1411.             'commercialId' => $user_id
  1412.         );
  1413.         $dql = 'SELECT ct, cl.title, cn.name, cn.lastName, cn.phone, cn.mobile, cn.email
  1414.                 FROM App\MDS\CommercialBundle\Entity\CommercialTracking ct
  1415.                 INNER JOIN App:Client cl WITH cl.id = ct.clientId
  1416.                 INNER JOIN App:ClientContact cn WITH cn.id = ct.contactId
  1417.                 WHERE ct.commercialId = :commercialId 
  1418.                 ORDER BY ct.timeStart ASC ';
  1419.         $query = $em->createQuery($dql)->setParameters($parametersA);;
  1420.         $trackings = $query->getResult();
  1422.         $parametersB = array(
  1423.             'commercialId' => $user_id,
  1424.         );
  1425.         $dqlb = 'SELECT ct, cl.title, cn.name, cn.lastName, cn.phone, cn.mobile, cn.email
  1426.                 FROM App\MDS\CommercialBundle\Entity\CommercialTracking ct
  1427.                 INNER JOIN App:Client cl WITH cl.id = ct.clientId
  1428.                 INNER JOIN App:ClientContact cn WITH cn.id = ct.contactId
  1429.                 WHERE ct.commercialId = :commercialId
  1430.                 AND ct.alertAt is not NULL
  1431.                 ORDER BY ct.timeStart ASC ';
  1432.         $queryb = $em->createQuery($dqlb)->setParameters($parametersB);;
  1433.         $trackingAlerts = $queryb->getResult();
  1436.         $datos = array();
  1437.         if (!empty($trackings) or !empty($trackingAlerts)){
  1440.             foreach($trackings as $tracking){
  1441.                 if(empty($tracking['0']->getTitle())){
  1442.                     $title =  $tracking['0']->getTimeStart()->format('H:i').' | '.$this->translator->trans('Tracking of commercial performance in client');
  1443.                 }else{
  1444.                     $title = $tracking['0']->getTimeStart()->format('H:i').' | '.$tracking['0']->getTitle();
  1445.                 }
  1446.                 $client_tr = $this->translator->trans('Client');
  1447.                 $contact_tr = $this->translator->trans('Contact');
  1448.                 $telephone_tr = $this->translator->trans('Telephone');
  1449.                 $mobile_tr = $this->translator->trans('Mobile');
  1451.                 $tooltip = $title."<br>".$client_tr.": <b>".$tracking['title']."</b><br>
  1452.                     ".$contact_tr.": <b>".$tracking['name']." ".$tracking['lastName']."</b><br>
  1453.                     <i class='icon-phone position-left'></i>".$telephone_tr.": ".$tracking['phone']." <br> 
  1454.                     <i class='icon-mobile position-left'></i>".$mobile_tr.": ".$tracking['mobile']."<br>
  1455.                     <i class='icon-mail-read position-left'></i>: ".$tracking['email']."<br><br>
  1456.                     ".$tracking['0']->getMessage();
  1458.                 $datos[] = array(
  1459.                     "id" => $tracking['0']->getId(),
  1460.                     "title" => $title,
  1461.                     "tooltip" => $tooltip,
  1462.                     "date" => $tracking['0']->getDateAt(),
  1463.                     "start" => $tracking['0']->getTimeStart()->format('H:i'),
  1464.                     "end" => $tracking['0']->getTimeEnd()->format('H:i'),
  1465.                     "color" => '#01DF01',
  1466.                     "url" => "commercial/tracking/details/".$tracking['0']->getId()
  1467.                 );
  1468.             }
  1469.             if (!empty($trackingAlerts)){
  1470.                 foreach($trackingAlerts as $trackingAlert){
  1471.                     $reminder_tr = $this->translator->trans('Reminder');
  1472.                     if(empty($trackingAlert['0']->getTitle())){
  1473.                         $titleB = $reminder_tr.': '.$this->translator->trans('Tracking of commercial performance in client');
  1474.                     }else{
  1475.                         $titleB = $reminder_tr.': '.$trackingAlert['0']->getTitle();
  1476.                     }
  1477.                     $client_tr = $this->translator->trans('Client');
  1478.                     $contact_tr = $this->translator->trans('Contact');
  1479.                     $telephone_tr = $this->translator->trans('Telephone');
  1480.                     $mobile_tr = $this->translator->trans('Mobile');
  1483.                     $tooltipB = $reminder_tr.": ".$title."<br>".$client_tr.": <b>".$trackingAlert['title']."</b><br>
  1484.                         ".$contact_tr.": <b>".$trackingAlert['name']." ".$trackingAlert['lastName']."</b><br>
  1485.                         <i class='icon-phone position-left'></i>".$telephone_tr.": ".$trackingAlert['phone']." <br>
  1486.                         <i class='icon-mobile position-left'></i>".$mobile_tr.": ".$trackingAlert['mobile']."<br>
  1487.                         <i class='icon-mail-read position-left'></i>: ".$trackingAlert['email']."<br><br>
  1488.                         ".$trackingAlert['0']->getMessage();
  1490.                     $datos[] = array(
  1491.                         "id" => $trackingAlert['0']->getId(),
  1492.                         "title" => $titleB,
  1493.                         "tooltip" => $tooltipB,
  1494.                         "date" => $trackingAlert['0']->getAlertAt(),
  1495.                         "start" => $trackingAlert['0']->getTimeStart()->format('H:i'),
  1496.                         "end" => $trackingAlert['0']->getTimeEnd()->format('H:i'),
  1497.                         "color" => '#610B0B',
  1498.                         "url" => "commercial/tracking/details/".$trackingAlert['0']->getId()
  1499.                     );
  1500.                 }
  1501.             }
  1502.         }
  1503.         else
  1504.         {
  1505.             $datos = [];
  1506.         }
  1509.         $return = array(
  1510.             'tracking' => $datos,
  1511.         );
  1514.         $response = new JsonResponse($return);
  1515.         return $response;
  1516.     }
  1518.     /**
  1519.      * @Route("/tracking/statistics/{iduser}/{desde}/{hasta}", name="post_commercial_tracking_statistics")
  1520.      */
  1521.     public function statisticsSelectAction($iduser, $desde, $hasta, Request $request) {
  1523. //        $iduser = $_POST['iduser'];
  1524.         $em = $this->getDoctrine()->getManager();
  1525. //        $commercials = $em->getRepository(CommercialTracking::class)->findByCommercialId($iduser);
  1527. //        $desde = date_create($desde);
  1528. //        $hasta = date_create($hasta);
  1529. //        $desde = Date('now');
  1530. //        $hasta = Date('now');
  1532.         $parametersA = array(
  1533.             'commercialId' => $iduser,
  1534.             'desde' => $desde,
  1535.             'hasta' => $hasta,
  1536.         );
  1537.         $dql = 'SELECT ct
  1538.                 FROM App\MDS\CommercialBundle\Entity\CommercialTracking ct
  1539.                 WHERE ct.commercialId = :commercialId 
  1540.                 AND ct.createdAt >= :desde 
  1541.                 AND ct.createdAt <= :hasta 
  1542.                 ORDER BY ct.id ASC ';
  1543.         $query = $em->createQuery($dql)->setParameters($parametersA);;
  1544.         $commercials = $query->getResult();
  1546. //        d($commercials);
  1548.         $stllamada = strtoupper($this->translator->trans('CALL'));
  1549.         $llamada = 0;
  1551.         $stalcance = strtoupper($this->translator->trans('SCOPE'));
  1552.         $alcance = 0;
  1554.         $stseguimiento = strtoupper($this->translator->trans('TRACING'));
  1555.         $seguimiento = 0;
  1557.         $stpresentacion = strtoupper($this->translator->trans('PRESENTATION'));
  1558.         $presentacion = 0;
  1560.         $stpresentacionSend = strtoupper($this->translator->trans('PRESENTATION SEND'));
  1561.         $presentacionSend = 0;
  1563.         $stofertaPendiente = strtoupper($this->translator->trans('PENDING OFFER'));
  1564.         $ofertaPendiente = 0;
  1566.         $stofertaEnviada = strtoupper($this->translator->trans('OFFER SENT'));
  1567.         $ofertaEnviada = 0;
  1569.         $stofertaPresentada = strtoupper($this->translator->trans('PRESENTED OFFER'));
  1570.         $ofertaPresentada= 0;
  1572.         $stofertaDescartada = strtoupper($this->translator->trans('OFFER DISCARDED'));
  1573.         $ofertaDescartada = 0;
  1575.         $stofertaDescartadaSeg = strtoupper($this->translator->trans('OFFERED DISCARDED TRACKING'));
  1576.         $ofertaDescartadaSeg = 0;
  1578.         $stcliente = strtoupper($this->translator->trans('CLIENT'));
  1579.         $cliente= 0;
  1581.         $stclientePerdido = strtoupper($this->translator->trans('CLIENT LOST'));
  1582.         $clientePerdido = 0;
  1584.         foreach($commercials as $commercial){
  1586.             switch ($commercial->getSituation()) {
  1587.                 case "CALL":
  1588.                     $llamada = $llamada + 1;
  1589.                     break;
  1590.                 case "SCOPE":
  1591.                     $alcance = $alcance + 1;
  1592.                     break;
  1593.                 case "TRACING":
  1594.                     $seguimiento = $seguimiento + 1;
  1595.                     break;
  1596.                 case "PRESENTATION":
  1597.                     $presentacion = $presentacion + 1;
  1598.                     break;
  1599.                 case "PRESENTATION SEND":
  1600.                     $presentacionSend = $presentacionSend + 1;
  1601.                     break;
  1602.                 case "PENDING OFFER":
  1603.                     $ofertaPendiente = $ofertaPendiente + 1;
  1604.                     break;
  1605.                 case "OFFER SENT":
  1606.                     $ofertaEnviada = $ofertaEnviada + 1;
  1607.                     break;
  1608.                 case "PRESENTED OFFER":
  1609.                     $ofertaPresentada = $ofertaPresentada + 1;
  1610.                     break;
  1611.                 case "OFFER DISCARDED":
  1612.                     $ofertaDescartada = $ofertaDescartada + 1;
  1613.                     break;
  1614.                 case "OFFERED DISCARDED TRACKING":
  1615.                     $ofertaDescartadaSeg = $ofertaDescartadaSeg + 1;
  1616.                     break;
  1617.                 case "CLIENT":
  1618.                     $cliente = $cliente + 1;
  1619.                     break;
  1620.                 case "CLIENT LOST":
  1621.                     $clientePerdido = $clientePerdido + 1;
  1622.                     break;
  1623.             }
  1624.         }
  1625.         $datos = array(
  1626.             "llamada" => array(
  1627.                 'status' => $stllamada,
  1628.                 'value' => $llamada,
  1629.             ),
  1630.             "alcance" => array(
  1631.                 'status' => $stalcance,
  1632.                 'value' => $alcance,
  1633.             ),
  1634.             "seguimiento" => array(
  1635.                 'status' => $stseguimiento,
  1636.                 'value' => $seguimiento,
  1637.             ),
  1638.             "presentacion" => array(
  1639.                 'status' => $stpresentacion,
  1640.                 'value' => $presentacion,
  1641.             ),
  1642.             "presentacionSend" => array(
  1643.                 'status' => $stpresentacionSend,
  1644.                 'value' => $presentacionSend,
  1645.             ),
  1646.             "ofertaPendiente" => array(
  1647.                 'status' => $stofertaPendiente,
  1648.                 'value' => $ofertaPendiente,
  1649.             ),
  1650.             "ofertaEnviada" => array(
  1651.                 'status' => $stofertaEnviada,
  1652.                 'value' => $ofertaEnviada,
  1653.             ),
  1654.             "ofertaPresentada" => array(
  1655.                 'status' => $stofertaPresentada,
  1656.                 'value' => $ofertaPresentada,
  1657.             ),
  1658.             "ofertaDescartada" => array(
  1659.                 'status' => $stofertaDescartada,
  1660.                 'value' => $ofertaDescartada,
  1661.             ),
  1662.             "ofertaDescartadaSeg" => array(
  1663.                 'status' => $stofertaDescartadaSeg,
  1664.                 'value' => $ofertaDescartadaSeg,
  1665.             ),
  1666.             "cliente" => array(
  1667.                 'status' => $stcliente,
  1668.                 'value' => $cliente,
  1669.             ),
  1670.             "clientePerdido" => array(
  1671.                 'status' => $stclientePerdido,
  1672.                 'value' => $clientePerdido,
  1673.             ),
  1674.         );
  1676. //        $datos = array(
  1677. //            "llamada" => $llamada,
  1678. //            "alcance" => $alcance,
  1679. //            "seguimiento" => $seguimiento,
  1680. //            "presentacion" => $presentacion,
  1681. //            "presentacionSend" => $presentacionSend,
  1682. //            "ofertaPendiente" => $ofertaPendiente,
  1683. //            "ofertaEnviada" => $ofertaEnviada,
  1684. //            "ofertaPresentada" => $ofertaPresentada,
  1685. //            "ofertaDescartada" => $ofertaDescartada,
  1686. //            "ofertaDescartadaSeg" => $ofertaDescartadaSeg,
  1687. //            "cliente" => $cliente,
  1688. //            "clientePerdido" => $clientePerdido,
  1689. //        );
  1692.         $return = array(
  1693.             'datos' => $datos,
  1694.         );
  1697.         $response = new JsonResponse($return);
  1698.         return $response;
  1699.     }
  1701.     /**
  1702.      * @Route("/tracking/user", name="commercial_statistics_tracing_user")
  1703.      */
  1704.     public function CommercialuserAction(Request $request) {
  1706.         $em = $this->getDoctrine()->getManager();
  1707.         $tracing_user = $em->getRepository(CommercialTracking::class)->findAll();
  1708.         foreach($tracing_user as $tracinguser){
  1709.             $idUserdata[$tracinguser->getCommercialId()] = $tracinguser->getCommercialId();
  1710.         }
  1712.         foreach($idUserdata as $idUserdos){
  1713.             $idUser[] = $idUserdos;
  1715.         }
  1716.         $return = array(
  1717.             'idUser' => $idUser,
  1718.             'year' => date('2016-01-01'),
  1719.             'today' => date('Y-m-d')
  1720.         );
  1722.         $response = new JsonResponse($return);
  1723.         return $response;
  1724.     }
  1726. }