src/Controller/RegistroController.php line 555

Open in your IDE?
  1. <?php
  5. namespace App\Controller;
  7. use App\Entity\Eventos;
  8. use App\Entity\Estilistas;
  9. use App\Entity\Clientes;
  10. use App\Entity\Productos;
  11. use App\Entity\SoldProducts;
  12. use App\Entity\Notifications;
  13. use App\Form\UserType;
  14. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  15. use Symfony\Component\HttpFoundation\Response;
  16. use Symfony\Component\HttpFoundation\Request;
  17. use Symfony\Component\Asset\Package;
  18. use Doctrine\ORM\EntityManagerInterface;
  19. use Symfony\Component\HttpFoundation\JsonResponse;
  20. use Symfony\Component\Routing\Annotation\Route;
  21. use Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface;
  22. use Symfony\Component\Validator\Constraints\DateTime;
  23. use Symfony\Component\Asset\VersionStrategy\EmptyVersionStrategy;
  24. use Symfony\Component\HttpFoundation\RedirectResponse;
  26. class RegistroController extends AbstractController
  27. {
  29.     private function getLanguage()
  30.     {
  31.       
  32.       $language = "es";
  33.       if (isset($_COOKIE['lang']))
  34.       {
  35.         $language = $_COOKIE['lang'];
  36.       }
  37.       $package = new Package(new EmptyVersionStrategy());
  38.       $urlLang = $package->getUrl('language/'.$language.'.json');
  39.       $lang = json_decode(file_get_contents($urlLang));
  41.       return $lang;
  42.     }
  44.     function activeWorkers($em)
  45.     {
  46.       $wokerName = [];
  47.       $user = $this->getUser();
  48.       if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  49.       else{ $company = $user->getId(); } 
  50.       // $em = $this->getDoctrine()->getManager();
  51.       $workers = $em->getRepository(Estilistas::class)->findBy(['enabled'=> true, 'company'=>$company]);
  52.       foreach ($workers as $worker) 
  53.       {
  54.         $wokerName[] = [ 
  55.           'id'          => $worker->getId(),
  56.           'nombre'      => $worker->getNombre(),
  57.           'apellidos'   => $worker->getApellidos()
  58.         ]; 
  59.       }
  60.       return $wokerName;
  61.     }
  65.     /**
  66.      * @Route("/registro", name="registro")
  67.      */
  68.     public function registro(Request $request, UserPasswordEncoderInterface $encoder): Response
  69.     { //crear usuario
  70.       $user = new User();
  71.       $form = $this->createForm(UserType::class, $user);
  72.       $form->handleRequest($request);
  73.       if ($form->isSubmitted() && $form->isValid())
  74.       {
  75.         $em = $this->getDoctrine()->getManager();
  76.         $user->setRoles(['ROLE_ADMIN']);
  77.         $user->setPassword($encoder->encodePassword($user, $form['password']->getData()));
  78.         $em->persist($user);
  79.         $em->flush();
  80.         $this->addFlash('exito', 'Data uploaded');
  81.         return $this->redirectToRoute('registro');
  82.       }
  84.         return $this->render('registro/index.html.twig', [
  85.             'formulario' => $form->createView(),
  86.         ]);
  87.     }
  91.     /**
  92.     * @Route("/access_registros", name="accessRegistros", options={"expose"=true})
  93.     */
  94.     public function accessRegistros(Request $request, EntityManagerInterface $em): Response
  95.     {
  96.       $user = $this->getUser();
  97.       if (method_exists($user, 'getCompany')) { $company= $user->getCompany(); }
  98.       else{ $company = $user; } 
  99.       $lang = self::getLanguage();
  100.       $workers = self::activeWorkers($em);
  102.       if ($content = $request->request->all()) 
  103.       {
  104.         if (!array_key_exists('workerName', $content)) 
  105.         {
  106.           $this->addFlash(
  107.             'error',
  108.             $lang->login->tellMeHowAreYou
  109.           );
  110.           return $this->render('registro/index.html.twig', [
  111.               'lang' => $lang,
  112.               'workers'=> $workers
  113.           ]);
  114.         }
  116.         $pass = hash('sha256', $content['password']);
  117.         $fullName = explode(",", $content['workerName']);
  118.         $name = $fullName[0];
  119.         $surname = $fullName[1];
  120.         $id = $fullName[2];
  121.         $codeConfirmed = false;
  122.         $isAdmin = false;
  123.         $worker = $em->getRepository(Estilistas::class)->findOneBy(['id'=>$id]);
  125.         if ($worker) 
  126.         {
  127.           if ($worker->getCode() === $pass) {
  128.             $codeConfirmed = true;
  129.             if ( in_array("ROLE_ADMIN", $worker->getRoles()) ) //$realPass->getAdminPass() == true
  130.             {
  131.               $isAdmin = true;
  132.             }
  133.           }
  135.           if ($codeConfirmed) {
  136.             if ($isAdmin) {
  137.               return $this->redirectToRoute('registros', ['id'=>$worker->getId()]);
  138.             }else{
  139.               return $this->redirectToRoute('registrosWorker', ['id'=>$worker->getId()] );
  140.             }
  141.           }else{
  142.             $this->addFlash(
  143.               'error',
  144.               $lang->login->userNotActive
  145.             );
  146.             return $this->render('registro/index.html.twig', [
  147.               'lang' => $lang,
  148.               'workers'=> $workers
  149.           ]);
  150.           }
  152.           // if ($realPass->getNombre() == $name) 
  153.           // {
  154.           //   if ($realPass->getEnabled() == true) 
  155.           //   {
  156.           //     if ( in_array("ROLE_ADMIN", $realPass->getRoles()) ) //$realPass->getAdminPass() == true
  157.           //     {
  158.           //       return $this->redirectToRoute('registros', ['id'=>$realPass->getId()]);
  159.           //     }
  160.           //     else
  161.           //     {
  162.           //       return $this->redirectToRoute('registrosWorker', ['id'=>$realPass->getId()] );
  163.           //     }
  164.           //   }
  165.           //   else
  166.           //   {
  167.           //     $this->addFlash(
  168.           //         'error',
  169.           //         $lang->login->userNotActive
  170.           //       );
  171.           //       return $this->render('registro/index.html.twig', [
  172.           //         'lang' => $lang,
  173.           //         'workers'=> $workers
  174.           //     ]);
  175.           //   }
  176.           // }
  177.           // else
  178.           // {
  179.           //   $this->addFlash(
  180.           //     'error',
  181.           //     $lang->login->passIncorrect
  182.           //   );
  183.           //   return $this->render('registro/index.html.twig', [
  184.           //       'lang' => $lang,
  185.           //       'workers'=> $workers
  186.           //   ]);
  187.           // }
  189.         }
  190.         else 
  191.         {
  192.           $this->addFlash(
  193.             'error',
  194.             $lang->login->passIncorrect
  195.           );
  196.           return $this->render('registro/index.html.twig', [
  197.             'lang' => $lang,
  198.             'workers'=> $workers
  199.           ]);
  200.           // $response = new JsonResponse('error');
  201.         }
  202.       }
  203.       else
  204.       {
  205.         return $this->render('registro/index.html.twig', [
  206.           'data'=> new \DateTime(),
  207.           'lang' => $lang,
  208.           'workers'=> $workers
  209.         ]);
  210.       }
  211.       return $response;
  212.     }
  216.     /**
  217.     * @Route("/registros/{id}", name="registros")
  218.     */
  219.     public function resgitros($id, Request $request, EntityManagerInterface $em): Response
  220.     {
  221.       $user = $this->getUser();
  222.       if ($user) {
  223.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  224.         else{ $company = $user->getId(); } 
  225.         $lang = self::getLanguage();
  226.         $month = $lang->setting->months;
  227.         foreach ($month as $mes)
  228.         {
  229.           $meses[] = $mes;
  230.         }
  231.         $workers = [];
  232.         $stylist = $em->getRepository(Estilistas::class)->findBy(['company'=>$company, 'showed'=>1]);
  233.         if($stylist){
  234.           foreach ($stylist as $employee) 
  235.           { 
  236.             $workers[] = [
  237.               'id'      => $employee->getId(),
  238.               'name'    => $employee->getNombre(),
  239.               'surName' => $employee->getApellidos(),
  240.             ];
  241.           }
  242.         }
  243.   
  244.         $now = new \DateTime('Europe/london');
  245.         $fisrtDay = new \DateTime('first day of this month');
  246.         $mesesHastaAhora = $now->format('m');
  247.   
  248.         return $this->render('registro/registros.html.twig', [
  249.           'dateStart'     => $fisrtDay,
  250.           'dateEnd'       => $now,
  251.           'months'        => $meses,
  252.           'lang'          => $lang,
  253.           'workers'       => $workers,
  254.           'userAccess'    => $id,
  255.           'notifications' => $notifications=[]
  256.         ]);
  257.       }else{
  258.         return $this->redirectToRoute('app_login');
  259.       }
  260.     }
  263.     /**
  264.      * @Route("/balance_serv", name="balanceServ", options={"expose"=true})
  265.      */
  266.     public function balanceServ(Request $request, EntityManagerInterface $em): Response
  267.     {
  268.       if ($request->isXmlHttpRequest())
  269.       {
  270.         $lang= self::getLanguage();
  271.         $user = $this->getUser();
  272.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  273.         else{ $company = $user->getId(); }
  274.         $dateFrom = new \DateTime($request->request->get('desde'));
  275.         $dateTo = new \DateTime($request->request->get('hasta'));
  276.         $desde = $dateFrom->format('Y-m-d').' 00:00:00';
  277.         $hasta = $dateTo->format('Y-m-d').' 23:59:59';
  278.         $response = [];
  279.         $workers = $em->getRepository(Estilistas::class)->findBy(['company'=>$company]);
  280.         foreach ($workers as $worker)
  281.         {
  282.           $detailsId = [];
  283.           $totalCash =0;
  284.           $totalCard =0;
  285.           $totalGiftCard =0;
  286.           $total =0;
  287.           $totalForward = 0;
  288.           $elTotal = 0;
  289.     
  290.           $result = $em->getRepository(Eventos::class)->getRegistro($desde, $hasta, $worker->getId(), '#1c7430');
  291.           if (!empty($result))
  292.           {
  293.             $isResult= true;
  294.             $paidBy='';
  295.             foreach ($result as $balanceWorker)
  296.             {
  297.               $servicios = explode("-", $balanceWorker['servicios']);
  298.               $tamanio = $servicios[0];
  299.               $services = $servicios[1];
  300.               $total = $balanceWorker['total'];
  301.   
  302.               $detailsId[] = [
  303.                 'id'          => $balanceWorker['id'],
  304.                 'customer'    =>$balanceWorker['kunde'],
  305.                 'description' =>$balanceWorker['descripcion'],
  306.                 'date'        =>$balanceWorker['start']->format('d/m/y'),
  307.                 'name'        =>$balanceWorker['nombre'],
  308.                 'payment'     =>$balanceWorker['payment'],
  309.                 'total'       =>$balanceWorker['total'],
  310.                 'cash'        => $balanceWorker['cash'],
  311.                 'card'        => $balanceWorker['card'],
  312.                 'giftCard'    => $balanceWorker['giftCard']
  313.               ];
  314.                 
  315.               if ($balanceWorker['payment'] == 1)
  316.               {
  317.                 $totalCash += $total;
  318.               }
  319.               elseif ($balanceWorker['payment'] == 2)
  320.               {
  321.                 $totalCard += $total;
  322.               }
  323.               elseif ($balanceWorker['payment'] == 3)
  324.               {
  325.                 if (!is_null($balanceWorker['cash'])) { $totalCash += $balanceWorker['cash']; $paidBy.='1';}
  326.                 if (!is_null($balanceWorker['card'])) { $totalCard += $balanceWorker['card']; $paidBy.='2';}
  327.                 if (!is_null($balanceWorker['giftCard'])) { $totalGiftCard += $balanceWorker['giftCard']; $paidBy.='3';}
  328.               }
  329.             }            
  330.           }
  331.           else
  332.           {
  333.             $isResult= false;
  334.           }
  336.           $elTotal += $totalCash + $totalCard + $totalGiftCard;
  337.           $analiticTotal = $elTotal + $totalForward; 
  338.           if ($isResult) {
  339.             $response[]= [
  340.               'totalCash'         => $totalCash,
  341.               'totalCard'         => $totalCard,
  342.               'totalGiftCard'     => $totalGiftCard,
  343.               'totalDone'         => $elTotal,
  344.               'paidBy'            => $paidBy,
  345.               'estilista'         => $worker->getNombre(),
  346.               'detailsId'         => $detailsId,
  347.               'enabled'           => $worker->getEnabled()
  348.             ];
  349.           }else{
  350.             $response[]= [
  351.               'totalCash'         => 0,
  352.               'totalCard'         => 0,
  353.               'totalGiftCard'     => 0,
  354.               'totalDone'         => 0,
  355.               'paidBy'            => '',
  356.               'estilista'         => $worker->getNombre(),
  357.               'detailsId'         => $detailsId,
  358.               'enabled'           => $worker->getEnabled()
  359.             ];
  360.           }
  361.         }
  362.       }
  363.       else
  364.       {
  365.         $response = ['error'=>'no results found'];
  366.       }
  367.       return new JsonResponse(['response'=>$response, 'lang'=>$lang]);
  368.     }
  371.     /**
  372.      * @Route("/balance_booking", name="balanceBooking", options={"expose"=true})
  373.      */
  374.     public function balanceBooking(Request $request, EntityManagerInterface $em): Response
  375.     {
  376.       if ($request->isXmlHttpRequest())
  377.       {
  378.         $lang= self::getLanguage();
  379.         $user = $this->getUser();
  380.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  381.         else{ $company = $user->getId(); } 
  382.         $lang= self::getLanguage();
  383.         $user = $this->getUser();
  384.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  385.         else{ $company = $user->getId(); } 
  386.         $dateFrom = new \DateTime($request->request->get('desde'));
  387.         $dateTo = new \DateTime($request->request->get('hasta'));
  388.         $desde = $dateFrom->format('Y-m-d').' 00:00:00';
  389.         $hasta = $dateTo->format('Y-m-d').' 23:59:59';
  390.         // $state = $request->request->get('status');
  391.         // $estado = explode(',', $state);
  392.         $response = [];
  393.         $workers = $em->getRepository(Estilistas::class)->findBy(['company'=>$company]);
  394.         foreach ($workers as $worker)
  395.         {
  396.           $detailsId = [];
  397.           $totalCash =0;
  398.           $totalCard =0;
  399.           $totalGiftCard =0;
  400.           $total =0;
  401.           $totalForward = 0;
  402.           $elTotal = 0;
  403.     
  404.           $result = $em->getRepository(Eventos::class)->getRegistro($desde, $hasta, $worker->getId(), '#000000');
  405.           if (!empty($result))
  406.           {
  407.             $isResult= true;
  408.             $paidBy='';
  409.             foreach ($result as $balanceWorker)
  410.             {
  411.               $servicios = explode("-", $balanceWorker['servicios']);
  412.               $tamanio = $servicios[0];
  413.               $services = $servicios[1];
  414.               $total = $balanceWorker['total'];
  415.   
  416.               $detailsId[] = [
  417.                 'id'          => $balanceWorker['id'],
  418.                 'customer'    => $balanceWorker['kunde'],
  419.                 'description' => $balanceWorker['descripcion'],
  420.                 'date'        => $balanceWorker['start']->format('d-M-Y'),
  421.                 'name'        => $balanceWorker['nombre'],
  422.                 'payment'     => $balanceWorker['payment'],
  423.                 'total'       => $balanceWorker['total'],
  424.                 'cash'        => $balanceWorker['cash'],
  425.                 'card'        => $balanceWorker['card'],
  426.                 'giftCard'    => $balanceWorker['giftCard']
  427.               ];
  428.   
  429.               $totalForward += $total;
  430.             }            
  431.           }
  432.           else
  433.           {
  434.             $isResult= false;
  435.           }
  437.           $elTotal += $totalCash + $totalCard + $totalGiftCard;
  438.           $analiticTotal = $elTotal + $totalForward;
  439.           if ($isResult) {
  440.             $response[]= [
  441.               'totalForward'      => $totalForward,
  442.               'estilista'         => $worker->getNombre(),
  443.               'detailsId'         => $detailsId,
  444.               'enabled'           => $worker->getEnabled()
  445.             ];
  446.           }else{
  447.             $response[]= [
  448.               'totalForward'      => 0,
  449.               'estilista'         => $worker->getNombre(),
  450.               'detailsId'         => $detailsId,
  451.               'enabled'           => $worker->getEnabled()
  452.             ];
  453.           }
  454.         }
  455.       }
  456.       else
  457.       {
  458.         $response = ['error'=>'no results found'];
  459.       }
  460.       return new JsonResponse(['response'=>$response, 'lang'=>$lang]);
  461.     }
  465.     /**
  466.      * @Route("/balance_prod", name="balanceProd", options={"expose"=true})
  467.      */
  468.     public function balanceProd(Request $request, EntityManagerInterface $em): Response
  469.     {
  470.       if ($request->isXmlHttpRequest())
  471.       {
  472.         $lang= self::getLanguage();
  473.         $user = $this->getUser();
  474.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  475.         else{ $company = $user->getId(); } 
  476.         $dateFrom = new \DateTime($request->request->get('desde'));
  477.         $dateTo = new \DateTime($request->request->get('hasta'));
  478.         $desde = $dateFrom->format('Y-m-d').' 00:00:00';
  479.         $hasta = $dateTo->format('Y-m-d').' 23:59:59';
  480.         // $state = $request->request->get('status');
  481.         // $stado = explode(',', $state);
  482.         $response = [];
  483.         $workers = $em->getRepository(Estilistas::class)->findBy(['company'=>$company]);
  484.         foreach ($workers as $worker)
  485.         {
  486.           $totalProducts = 0;
  487.           $detailsProd = [];
  488.           $products = $em->getRepository(SoldProducts::class)->getProducts($desde, $hasta, $worker->getId());
  489.           if ($products) 
  490.           {
  491.             $isResult= true;
  492.             foreach ($products as $prod) 
  493.             {
  494.               for ($i=0; $i < count($prod['productosId']); $i++) 
  495.               {
  496.                 $prueba = $prod['productosId'][$i];
  497.                 $prodSplit = explode('-', $prod['productosId'][$i]);
  498.                 $product = $em->getRepository(Productos::class)->findOneBy(['id'=>$prodSplit[0]]);
  499.                 if ($product) 
  500.                 {
  501.                   $total = $product->getPrecioVp() * $prodSplit[1];
  502.                   $detailsProd[] = [
  503.                     $product->getId(),
  504.                     $product->getCodigoProducto(),
  505.                     $product->getNombre(),
  506.                     $product->getMarca(),
  507.                     number_format($product->getPrecioVp(), 2),
  508.                     $prodSplit[1],
  509.                     number_format($total, 2),
  510.                     $prod['paymentMethod'],
  511.                     $prod['date']->format('d/m/y H:i'),
  512.                     number_format($prod['total'], 2)
  513.                   ];
  514.                 }
  515.                 // else
  516.                 // {
  517.                 //   $detailsProd[] = 'no data';
  518.                 // }
  519.               } 
  520.               $totalProducts = $totalProducts + $prod['total'];
  521.             }
  522.           }
  523.           else{
  524.             $isResult= false;
  525.           }
  526.           if ($isResult) {
  527.             $response[]= [
  528.               'totalProducts'     => number_format($totalProducts, 2),
  529.               'estilista'         => $worker->getNombre(),
  530.               'detailsProd'       => $detailsProd,
  531.               'enabled'           => $worker->getEnabled()
  532.             ];
  533.           }else{
  534.             $response[]= [
  535.               'totalProducts'     => 0,
  536.               'estilista'         => $worker->getNombre(),
  537.               'detailsProd'       => $detailsProd,
  538.               'enabled'           => $worker->getEnabled()
  539.             ];
  540.           }
  541.         }
  542.       }
  543.       else
  544.       {
  545.         $response = ['error'=>'no results found'];
  546.       }
  547.       return new JsonResponse(['response'=>$response, 'lang'=>$lang]);
  548.     }
  552.     /**
  553.      * @Route("/balance_analitic", name="balanceAnalitic", options={"expose"=true})
  554.      */
  555.     public function balanceAnalitic(Request $request, EntityManagerInterface $em): Response
  556.     {
  557.       if ($request->isXmlHttpRequest())
  558.       {
  559.         $lang= self::getLanguage();
  560.         $user = $this->getUser();
  561.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  562.         else{ $company = $user->getId(); } 
  563.         $dateFrom = new \DateTime($request->request->get('desde'));
  564.         $dateTo = new \DateTime($request->request->get('hasta'));
  565.         $desde = $dateFrom->format('Y-m-d').' 00:00:00';
  566.         $hasta = $dateTo->format('Y-m-d').' 23:59:59';
  567.         // $state = $request->request->get('status');
  568.         // $stado = explode(',', $state);
  569.         $response = [];
  570.         $workers = $em->getRepository(Estilistas::class)->findBy(['company'=>$company]);
  571.         foreach ($workers as $worker)
  572.         {
  573.           $totalProducts = 0;
  574.           $detailsProd = [];
  575.           $products = $em->getRepository(SoldProducts::class)->getProducts($desde, $hasta, $worker->getId());
  576.           if ($products) 
  577.           {
  578.             foreach ($products as $prod) 
  579.             {
  580.               for ($i=0; $i < count($prod['productosId']); $i++) 
  581.               {
  582.                 $prodSplit = explode('-', $prod['productosId'][$i]);
  583.                 $product = $em->getRepository(Productos::class)->findOneBy(['id'=>$prodSplit[0]]);
  584.                 if ($product) 
  585.                 {
  586.                   $detailsProd[] = [
  587.                     $product->getId(),
  588.                     $product->getCodigoProducto(),
  589.                     $product->getNombre(),
  590.                     $product->getMarca(),
  591.                     $product->getPrecioVp(),
  592.                   ];
  593.                 }
  594.                 else
  595.                 {
  596.                   $detailsProd[] = 'no data';
  597.                 }
  598.               } 
  599.               $totalProducts = $totalProducts + $prod['total'];
  600.             }
  601.           }
  602.           $detailsId = [];
  603.           $totalCash =0;
  604.           $totalCard =0;
  605.           $totalGiftCard =0;
  606.           $total =0;
  607.           $totalForward = 0;
  608.           $elTotal = 0;
  609.           $result = $em->getRepository(Eventos::class)->getAllRegistro($desde, $hasta, $worker->getId());
  610.           if (!empty($result))
  611.           {
  612.             $isResult= true;
  613.             $paidBy='';
  614.             foreach ($result as $balanceWorker)
  615.             {
  616.               $servicios = explode("-", $balanceWorker['servicios']);
  617.               $tamanio = $servicios[0];
  618.               $services = $servicios[1];
  619.               $total = $balanceWorker['total'];
  620.   
  621.               $detailsId[] = [
  622.                 'id'          => $balanceWorker['id'],
  623.                 'customer'    =>$balanceWorker['kunde'],
  624.                 'description' =>$balanceWorker['descripcion'],
  625.                 'date'        =>$balanceWorker['start']->format('d-M-Y'),
  626.                 'name'        =>$balanceWorker['nombre'],
  627.                 'payment'     =>$balanceWorker['payment'],
  628.                 'total'       =>$balanceWorker['total']
  629.               ];
  630.   
  631.               if (!is_null($balanceWorker['payment']))
  632.               {
  633.                 if ($balanceWorker['payment'] == 1)
  634.                 {
  635.                   $totalCash += $total;
  636.                 }
  637.                 elseif ($balanceWorker['payment'] == 2)
  638.                 {
  639.                   $totalCard += $total;
  640.                 }
  641.                 elseif ($balanceWorker['payment'] == 3)
  642.                 {
  643.                   if (!is_null($balanceWorker['cash'])) { $totalCash += $balanceWorker['cash']; $paidBy.='1';}
  644.                   if (!is_null($balanceWorker['card'])) { $totalCard += $balanceWorker['card']; $paidBy.='2';}
  645.                   if (!is_null($balanceWorker['giftCard'])) { $totalGiftCard += $balanceWorker['giftCard']; $paidBy.='3';}
  646.                 }
  647.               }
  648.               else
  649.               {
  650.                 $totalForward += $total;
  651.               }
  652.   
  653.             }            
  654.           }
  655.           else
  656.           {
  657.             $isResult= false;
  658.           }
  659.           $elTotal += $totalCash + $totalCard + $totalGiftCard;
  660.           $analiticTotal = $elTotal + $totalForward ;//+ $totalProducts;
  661.           if ($isResult) {
  662.             $response[]= [
  663.               'totalCash'         => number_format($totalCash, 2),
  664.               'totalCard'         => number_format($totalCard, 2),
  665.               'totalGiftCard'     => number_format($totalGiftCard, 2),
  666.               'totalProducts'     => number_format($totalProducts, 2),
  667.               'totalDone'         => number_format($elTotal, 2),
  668.               'analiticTotal'     => $analiticTotal,
  669.               'totalForward'      => number_format($totalForward, 2),
  670.               'paidBy'            => $paidBy,
  671.               'estilista'         => $worker->getNombre(),
  672.               'detailsId'         => $detailsId,
  673.               'detailsProd'       => $detailsProd,
  674.               'enabled'           => $worker->getEnabled()
  675.             ];
  676.           }else{
  677.             $response[]= [
  678.               'totalCash'         => 0,
  679.               'totalCard'         => 0,
  680.               'totalGiftCard'     => 0,
  681.               'totalProducts'     => number_format($totalProducts, 2),
  682.               'totalDone'         => 0,
  683.               'analiticTotal'     => 0,
  684.               'totalForward'      => 0,
  685.               'paidBy'            => '',
  686.               'estilista'         => $worker->getNombre(),
  687.               'detailsId'         => $detailsId,
  688.               'detailsProd'       => $detailsProd,
  689.               'enabled'           => $worker->getEnabled()
  690.             ];
  691.           }
  692.         }        
  693.       }
  694.       else
  695.       {
  696.         $response = ['error'=>'no results found'];
  697.       }
  698.       return new JsonResponse(['response'=>$response, 'lang'=>$lang]);
  699.     }
  703.     // /**
  704.     //  * @Route("/balance", name="balance", options={"expose"=true})
  705.     //  */
  706.     // public function balance(Request $request, EntityManagerInterface $em): Response
  707.     // {
  708.     //   if ($request->isXmlHttpRequest())
  709.     //   {
  710.     //     $lang= self::getLanguage();
  711.     //     $user = $this->getUser();
  712.     //     if (method_exists($user, 'getCompany')) { $company= $user->getCompany()->getId(); }
  713.     //     else{ $company = $user->getId(); } 
  714.     //     $dateFrom = new \DateTime($request->request->get('desde'));
  715.     //     $dateTo = new \DateTime($request->request->get('hasta'));
  716.     //     $desde = $dateFrom->format('Y-m-d').' 00:00:00';
  717.     //     $hasta = $dateTo->format('Y-m-d').' 23:59:59';
  718.     //     $state = $request->request->get('status');
  719.     //     $stado = explode(',', $state);
  720.     //     $response = [];
  721.     //     $workers = $em->getRepository(Estilistas::class)->findBy(['company'=>$company]);
  722.     //     foreach ($workers as $worker)
  723.     //     {
  724.     //       $totalProducts = 0;
  725.     //       $detailsProd = [];
  726.     //       $products = $em->getRepository(SoldProducts::class)->getProducts($desde, $hasta, $worker->getId());
  727.     //       if ($products) 
  728.     //       {
  729.     //         foreach ($products as $prod) 
  730.     //         {
  731.     //           $idProd = explode('-', $prod['idProductos']);
  732.     //           for ($i=0; $i < count($idProd); $i++) 
  733.     //           {
  734.     //             $product = $em->getRepository(Productos::class)->findOneBy(['id'=>$idProd[$i]]);
  735.     //             if ($product) 
  736.     //             {
  737.     //               $detailsProd[] = [
  738.     //                 $product->getId(),
  739.     //                 $product->getCodigoProducto(),
  740.     //                 $product->getNombre(),
  741.     //                 $product->getMarca(),
  742.     //                 $product->getPrecioVp(),
  743.     //               ];
  744.     //             }
  745.     //             else
  746.     //             {
  747.     //               $detailsProd[] = 'no data';
  748.     //             }
  749.     //           } 
  750.     //           $totalProducts = $totalProducts + $prod['total'];
  751.     //         }
  752.     //       }
  753.     //       $detailsId = [];
  754.     //       $totalCash =0;
  755.     //       $totalCard =0;
  756.     //       $totalGiftCard =0;
  757.     //       $total =0;
  758.     //       $totalForward = 0;
  759.     //       $elTotal = 0;
  760.     //       foreach ($stado as $status) 
  761.     //       {
  762.     //         $result = $em->getRepository(Eventos::class)->getRegistro($desde, $hasta, $worker->getId(), $status);
  763.     //         if (!empty($result))
  764.     //         {
  765.     //           $isResult= true;
  766.     //           $paidBy='';
  767.     //           foreach ($result as $balanceWorker)
  768.     //           {
  769.     //             $servicios = explode("-", $balanceWorker['servicios']);
  770.     //             $tamanio = $servicios[0];
  771.     //             $services = $servicios[1];
  772.     //             $total = $balanceWorker['total'];
  773.   
  774.     //             $detailsId[] = [
  775.     //               'id'          => $balanceWorker['id'],
  776.     //               'customer'    =>$balanceWorker['kunde'],
  777.     //               'description' =>$balanceWorker['descripcion'],
  778.     //               'date'        =>$balanceWorker['start']->format('d-M-Y'),
  779.     //               'name'        =>$balanceWorker['nombre'],
  780.     //               'payment'     =>$balanceWorker['payment'],
  781.     //               'total'       =>$balanceWorker['total']
  782.     //             ];
  783.   
  784.     //             if (array_key_exists(2, $servicios)) //si existe forma de pago
  785.     //             {
  786.     //               $formaPago = $servicios[2];
  787.     //             }
  788.     //             else{ $formaPago = 0; }
  789.   
  790.     //             if ($status == '#1c7430')
  791.     //             {
  792.     //               if ($balanceWorker['payment'] == 1)
  793.     //               {
  794.     //                 $totalCash += $total;
  795.     //               }
  796.     //               elseif ($balanceWorker['payment'] == 2)
  797.     //               {
  798.     //                 $totalCard += $total;
  799.     //               }
  800.     //               elseif ($balanceWorker['payment'] == 3)
  801.     //               {
  802.     //                 if (!is_null($balanceWorker['cash'])) { $totalCash += $balanceWorker['cash']; $paidBy.='1';}
  803.     //                 if (!is_null($balanceWorker['card'])) { $totalCard += $balanceWorker['card']; $paidBy.='2';}
  804.     //                 if (!is_null($balanceWorker['giftCard'])) { $totalGiftCard += $balanceWorker['giftCard']; $paidBy.='3';}
  805.     //                 // $totalNoRegistrado += $total;
  806.     //               }
  808.                   
  809.     //             }
  810.     //             else
  811.     //             {
  812.     //               $totalForward += $total;
  813.     //             }
  814.   
  815.     //           }
  816.               
  817.     //           // si checka los pagados o no
  818.     //           // if ($totalCash == 0 && $totalCard == 0 && $totalGiftCard == 0)
  819.     //           // {
  820.     //           //   $elTotal += $totalForward;
  821.     //           // }
  822.     //           // else
  823.     //           // {
  824.     //           //   $elTotal += $totalCash + $totalCard + $totalGiftCard;
  825.     //           // }
  826.   
  827.     //           // $elTotal += $totalCash + $totalCard + $totalGiftCard + $totalForward;
  828.             
  829.     //         }
  830.     //         else
  831.     //         {
  832.     //           $isResult= false;
  833.     //         }
  834.     //       }
  835.     //       $elTotal += $totalCash + $totalCard + $totalGiftCard;
  836.     //       $analiticTotal = $elTotal + $totalForward; 
  837.     //       if ($isResult) {
  838.     //         $response[]= [
  839.     //           'totalCash'         => $totalCash,
  840.     //           'totalCard'         => $totalCard,
  841.     //           'totalGiftCard'     => $totalGiftCard,
  842.     //           'totalProducts'     => $totalProducts,
  843.     //           'totalDone'         => $elTotal,
  844.     //           'analiticTotal'     => $analiticTotal,
  845.     //           'totalForward'      => $totalForward,
  846.     //           'paidBy'            => $paidBy,
  847.     //           'estilista'         => $worker->getNombre(),
  848.     //           'status'            => $status,
  849.     //           'detailsId'         => $detailsId,
  850.     //           'detailsProd'       => $detailsProd,
  851.     //           'enabled'           => $worker->getEnabled()
  852.     //         ];
  853.     //       }else{
  854.     //         $response[]= [
  855.     //           'totalCash'         => 0,
  856.     //           'totalCard'         => 0,
  857.     //           'totalGiftCard'     => 0,
  858.     //           'totalProducts'     => 0,
  859.     //           'totalDone'         => 0,
  860.     //           'analiticTotal'     => 0,
  861.     //           'totalForward'      => 0,
  862.     //           'paidBy'            => '',
  863.     //           'estilista'         => $worker->getNombre(),
  864.     //           'status'            => $status,
  865.     //           'detailsId'         => $detailsId,
  866.     //           'detailsProd'       => $detailsProd,
  867.     //           'enabled'           => $worker->getEnabled()
  868.     //         ];
  869.     //       }
  870.     //     }
  871.     //   }
  872.     //   else
  873.     //   {
  874.     //     $response = ['error'=>'no results found'];
  875.     //   }
  876.     //   return new JsonResponse(['response'=>$response, 'lang'=>$lang]);
  877.     // }
  884.     /**
  885.      * @Route("/acceso_balance", name="accesoBalance")
  886.      */
  887.     public function accesoBalance(Request $request, UserPasswordEncoderInterface $encoder): Response
  888.     {
  889.       $lang = self::getLanguage();
  890.       return $this->render('registro/accesoBalance.html.twig', [
  891.           'formulario' => $form->createView(),
  892.           'lang' => $lang
  893.       ]);
  894.     }
  901.     // /**
  902.     //  * @Route("/get_profits/{id}", name="getProfits")
  903.     //  */
  904.     // public function getProfits($id, Request $request): Response
  905.     // {
  906.     //   $lang = self::getLanguage();
  908.     //   return $this->render('registro/profits.html.twig', [
  909.     //   //     'formulario' => $form->createView(),
  910.     //     'lang' => $lang,
  911.     //     'userAccess'    => $id,
  912.     //   ]);
  913.     // }
  916.     /**
  917.      * @Route("/vista_anual", name="vistaAnual", options={"expose"=true})
  918.      */
  919.     public function vistaAnual(Request $request, EntityManagerInterface $em): Response
  920.     {
  921.       if ($request->isXmlHttpRequest()) {
  922.         $lang = self::getLanguage();
  923.         $user = $this->getUser();
  924.         if (method_exists($user, 'getCompany')) { $company= $user->getCompany(); }
  925.         else{ $company = $user; } 
  926.         $year = $request->request->get('year');
  927.         $max = 1000;
  928.         if($company->getMax()){
  929.           if ($company->getMax() > $max) {
  930.             $max = $company->getMax();
  931.           }
  932.         }else{
  933.           $company->setMax($max);
  934.           $em->flush();
  935.         }
  936.         $now = new \DateTime('Europe/London');
  937.         $anio = $now->format('Y');
  938.         $anual=[];
  939.         $quantityYear=[];
  940.         if ($year != '' || $year != null)
  941.         {
  942.           $anio = $year;
  943.         }
  944.   
  945.         for ($i=1; $i <= 12; $i++)
  946.         {
  947.           $desde = $anio.'-'.$i.'-01 00:00:00';
  948.           $hasta = $anio.'-'.$i.'-31 23:59:59';
  949.           $mensual = $em->getRepository(Eventos::class)->getMothly($desde, $hasta, $company->getId());
  950.           //Codigo de test
  951.           // if (!$mensual) {
  952.           //   for ($x=1; $x <=12 ; $x++) { 
  953.           //     $mensual = [];
  954.           //     $aleatorio = mt_rand(3500, 20000);
  955.           //     $mensual[] = ['total'=> $aleatorio];
  956.           //   }
  957.           // }
  958.           //
  959.           $total=0;
  960.           $amount=0;
  961.           foreach ($mensual as $mes)
  962.           {
  963.             $porcent = ($mes['total']*100) / $max;
  964.             $result = $porcent;
  965.             $total += $result;
  966.             $amount +=$mes['total']; 
  967.           }
  968.           if ($total > $max) {
  969.             $company->setMax($total);
  970.             $em->flush();
  971.           }
  972.           $anual[] = $total;
  973.           $quantityYear[]= $amount;
  974.         }
  975.   
  976.         $actual = $now->format('Y-m');
  977.         $from = $actual.'-01 00:00:00';
  978.         $to = $actual.'-31 23:59:59';
  979.         $nuevosClientes = 0;
  980.         $newKunder = $em->getRepository(Clientes::class)->getNewCostumers($from, $to, $company->getId());
  981.         foreach ($newKunder as $value)
  982.         {
  983.           $nuevosClientes++;
  984.         }
  985.         $response = new JsonResponse(['anual'=>$anual, 'max'=>$max, 'anio'=>$anio, 'newKunder'=>$nuevosClientes, 'amount'=>$quantityYear, 'new'=>$lang->setting->balance->newCustomers]);
  986.   
  987.         return $response; 
  988.       }
  989.       else{
  990.         throw new Exception("Error Processing Request", 1);
  991.       }
  992.     }
  996.     // /**
  997.     //  * @Route("/db_import", name="dbImport")
  998.     //  */
  999.     // public function dbImport(Request $request, UserPasswordEncoderInterface $encoder, EntityManagerInterface $em): Response
  1000.     // {
  1001.     //   $server = "localhost";
  1002.     //   $user = "sirox";
  1003.     //   $pass = "Vidaeterna22";
  1004.     //   $database = "tpv";
  1005.     //   $conexion = mysqli_connect($server, $user, $pass, $database);
  1006.     //
  1007.     //   $query = mysqli_query($conexion, "SELECT * FROM eventos");
  1008.     //   if (mysqli_num_rows($query))
  1009.     //   {
  1010.     //     while($listaEventos = mysqli_fetch_array($query))
  1011.     //     {
  1012.     //       // LETRAS NORUEGAS
  1013.     //       $cambio1 = mb_convert_encoding($listaEventos['comentario'], "HTML-ENTITIES", "UTF-8");
  1014.     //       $cambio2 = str_replace('&#2013265925;', 'å', $cambio1);
  1015.     //       $cambio3 = str_replace('&#2013266168;', 'ø', $cambio2);
  1016.     //       $cambio4 = str_replace('&#2013265926;', 'æ', $cambio3);
  1017.     //       // $cambio4 = str_replace('&#2013265926;', 'Å', $cambio3);
  1018.     //       $cambio5 = str_replace('&#2013265944;', 'Ø', $cambio4);
  1019.     //       // $cambio6 = str_replace('&#2013265926;', 'Æ', $cambio3);
  1020.     //       $cambio6 = str_replace('&#2013265921;', 'ø', $cambio5);
  1021.     //
  1022.     //
  1023.     //       // NOMBRE DE CLIENTES
  1024.     //       $query3 = mysqli_query($conexion, "SELECT * FROM clientes WHERE id = ".$listaEventos['id_cliente']);
  1025.     //       if (mysqli_num_rows($query3))
  1026.     //       {
  1027.     //         while ($cliente = mysqli_fetch_array($query3))
  1028.     //         {
  1029.     //           $nombeCliente = $cliente['nombre'];
  1030.     //         }
  1031.     //       }
  1032.     //
  1033.     //
  1034.     //
  1035.     //
  1036.     //       // DESCIPCION DE LOS SERVICIOS
  1037.     //       $service = "";
  1038.     //       $servicios1 = explode("-", $listaEventos['id_servicio']);
  1039.     //       if (array_key_exists(1, $servicios1))
  1040.     //       {
  1041.     //         $servicios2 = explode(" / ", $servicios1[1]);
  1042.     //       }
  1043.     //       else{ $servicios2 = ['7','']; }
  1044.     //       //
  1045.     //       // // $service = var_dump($servicios2);
  1046.     //       //
  1047.     //       for ($i=0; $i <count($servicios2)-1 ; $i++) //Sacamos los nombres de los servicios asociados al evento
  1048.     //       {
  1049.     //         $query2 = mysqli_query($conexion, "SELECT * FROM servicios WHERE id = ".$servicios2[$i]);
  1050.     //         if (mysqli_num_rows($query2))
  1051.     //         {
  1052.     //           while($serv = mysqli_fetch_array($query2))
  1053.     //           {
  1054.     //             $service .= $serv['servicio']." / ";
  1055.     //           }
  1056.     //         }
  1057.     //       }
  1058.     //       //   // $serviceName = $em->getRepository(Servicios::class)->findOneBy(['id'=>$servicios2[$i]]); // MODIFICAR !!
  1059.     //       //   // if (!is_null($serviceName) )
  1060.     //       //   // {
  1061.     //       //   // }
  1062.     //
  1063.     //
  1064.     //
  1065.     //       $response[] = [
  1066.     //         'id'=>$listaEventos['id'],
  1067.     //         'start'=>$listaEventos['start'],
  1068.     //         'end'=>$listaEventos['end'],
  1069.     //         'color'=>$listaEventos['color'],
  1070.     //         'textColor'=>$listaEventos['textColor'],
  1071.     //         'total'=>$listaEventos['total'],
  1072.     //         'comentario'=>$cambio6,
  1073.     //         'id_cliente'=>$listaEventos['id_cliente'],
  1074.     //         'id_servicio'=>$listaEventos['id_servicio'],
  1075.     //         'id_producto'=>$listaEventos['id_producto'],
  1076.     //         'id_estilista'=>$listaEventos['id_estilista'],
  1077.     //         'nombreCliente'=>$nombeCliente,
  1078.     //         'descripcion'=>$service
  1079.     //         ];
  1080.     //     }
  1081.     //   }
  1082.     //
  1083.     //   foreach ($response as $value)
  1084.     //   {
  1085.     //     if ($value['id_cliente'] == 0)
  1086.     //     {
  1087.     //       $value['id_cliente'] = 1;
  1088.     //     }
  1089.     //     $estilista = $em->getRepository(Estilistas::class)->findOneBy(['id'=>$value['id_estilista']]);
  1090.     //     $cliente = $em->getRepository(Clientes::class)->findOneBy(['id'=>$value['id_cliente']]);
  1091.     //
  1092.     //     $eventos = new Eventos();
  1093.     //     $eventos->setStart(new \DateTime($value['start']));
  1094.     //     $eventos->setEnd(new \DateTime($value['end']));
  1095.     //     $eventos->setColor($value['color']);
  1096.     //     $eventos->setTextColor($value['textColor']);
  1097.     //     $eventos->setTotal($value['total']);
  1098.     //     $eventos->setComentario($value['comentario']);
  1099.     //     $eventos->setServicios($value['id_servicio']);
  1100.     //     $eventos->setProductos($value['id_producto']);
  1101.     //     $eventos->setEstilistas($estilista);
  1102.     //     $eventos->setClientes($cliente);
  1103.     //     $eventos->setDescripcion($value['descripcion']);
  1104.     //     $eventos->setKunde($value['nombreCliente']);
  1105.     //
  1106.     //     $em->persist($eventos);
  1107.     //   }
  1108.     //
  1109.     //   $em->flush();
  1110.     //   return new JsonResponse(['msg'=>'Data uploaded']);
  1111.     //
  1112.     // }
  1118.         //############-----REGISTROS WORKER-----##############
  1120.     /**
  1121.     * @Route("/registros_worker/{id}", name="registrosWorker")
  1122.     */
  1123.     public function resgitrosWorker($id, Request $request, EntityManagerInterface $em): Response
  1124.     {
  1125.       $lang = self::getLanguage();
  1126.       // $fisrtDay = new \DateTime('first day of this month');
  1127.       // $lastDay = new \DateTime('last day of this month');
  1128.       // $now = new \DateTime('Europe/London');
  1129.       // $date = $now->format('Y-m');
  1130.       // $fecha = $now->format('M - Y');
  1131.       // $desde = $date.'-01 00:00:00';
  1132.       // $hasta = $date.'-31 23:59:59';
  1133.       // $status = '#1c7430';
  1135.       // $resultado=[];
  1136.       // $response =[];
  1137.       // $total=0;
  1138.       // $sueldo = 0;
  1139.       // $comision = 0;
  1140.       $worker = $em->getRepository(Estilistas::class)->findOneBy(['id'=>$id]);
  1142.       // $eventos = $em->getRepository(Eventos::class)->getRegistro($desde, $hasta, $worker->getId(), $status);
  1143.       // foreach ($eventos as $totally)
  1144.       // {
  1145.       //   $total += $totally['total'];
  1146.       // }
  1147.       // $resultado = [
  1148.       //   'total'       => $total,
  1149.       //   'porcent'     => $worker->getPorcent(),
  1150.       //   'salary'      => $worker->getSalary(),
  1151.       //   'salaryHour'  => $worker->getSalaryHour()
  1152.       // ];
  1154.       // if ($resultado['porcent'] != 0) {
  1155.       //   $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1156.       // }
  1157.       // if ($resultado['salary'] != 0) {
  1158.       //   $sueldo = $resultado['salary'];
  1159.       // }
  1160.       // POR COMISION
  1161.       // if ($resultado['salary'] == 0 && $resultado['salaryHour'] == 0)
  1162.       // {
  1163.       //   $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1164.       // }
  1165.       // POR HORAS
  1166.       // elseif ($resultado['salary'] == 0 && $resultado['porcent'] == 0)
  1167.       // {
  1169.       // }
  1170.       // SUELDO FIJO
  1171.       // elseif ($resultado['porcent'] == 0 && $resultado['salaryHour'] == 0)
  1172.       // {
  1173.       //   $sueldo = $resultado['salary'];
  1174.       // }
  1175.       // // SUELDO FIJO + COMISIÓN
  1176.       // elseif ($resultado['salaryHour'] == 0)
  1177.       // {
  1178.       //   $sueldo = $resultado['salary'];
  1179.       //   $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1180.       //   // $sueldo = $salary + $comision;
  1181.       // }
  1183.       // $response = [
  1184.       //   'total'     => $resultado['total'],
  1185.       //   'porcent'   => $resultado['porcent'],
  1186.       //   'fijo'      => $sueldo,
  1187.       //   'comision'  => $comision
  1188.       // ];
  1189.       
  1190.       return $this->render('registro/registrosWorker.html.twig', [
  1191.         'lang'          => $lang,
  1192.         'id'            => $worker->getId(),
  1193.         // 'fecha'         => $fecha,
  1194.         // 'firstDay'      => $fisrtDay, 
  1195.         // 'lastDay'       => $lastDay,
  1196.         'nombre'        => $worker->getNombre(),
  1197.         'apellidos'     => $worker->getApellidos(),
  1198.         // 'response'      => $response,
  1199.         'workers'       => self::activeWorkers($em)
  1200.       ]);
  1201.     }
  1205.     /**
  1206.      * @Route("/registros_worker_by_date", name="registrosWorkerByDate", options={"expose"=true})
  1207.      */
  1208.     public function registrosWorkerByDate(Request $request, EntityManagerInterface $em): Response
  1209.     {
  1210.       $response = new JsonResponse('nope');
  1211.       if ($request->isXMLHttpRequest()) 
  1212.       {
  1213.         $lang = self::getLanguage();
  1214.         $status = '#1c7430';
  1216.         $date = $request->request->get('date');
  1217.         $from = new \DateTime($date.'-01');
  1218.         $lastDay = date('t', strtotime("$date-01"));
  1219.         $to = new \DateTime($date.'-'.$lastDay);
  1220.         $desde = $from->format('Y-m-d').' 00:00:00';
  1221.         $hasta = $to->format('Y-m-d').' 23:59:59';
  1222.   
  1223.         $now = new \DateTime("now");
  1224.         $result=[];
  1225.         $response =[];
  1226.         $total=0;
  1227.         $sueldo = 0;
  1228.         $comision = 0;
  1229.         $comisionProd = 0;
  1230.         $totalProd = 0;
  1231.         $worker = $em->getRepository(Estilistas::class)->findOneBy(['id'=>$request->request->get('id')]);
  1232.         $products = $em->getRepository(SoldProducts::class)->getProducts($desde, $hasta, $worker->getId());
  1233.         $eventos = $em->getRepository(Eventos::class)->getRegistro($desde, $hasta, $worker->getId(), $status);
  1234.         foreach ($eventos as $totally)
  1235.         {
  1236.           $total += $totally['total'];
  1237.         }
  1238.         $resultado = [
  1239.           'total'       => $total,
  1240.           'porcent'     => $worker->getPorcent(),
  1241.           'salary'      => $worker->getSalary(),
  1242.           'salaryHour'  => $worker->getSalaryHour()
  1243.         ];
  1244.   
  1245.         
  1247.          // POR COMISION
  1248.          if ($resultado['salary'] == 0 && $resultado['salaryHour'] == 0)
  1249.          {
  1250.            $sueldo = $resultado['total'] * $resultado['porcent'] / 100;
  1251.            $comision = $sueldo;
  1252.          }
  1253.          // POR HORAS
  1254.          elseif ($resultado['salary'] == 0 && $resultado['porcent'] == 0)
  1255.          {
  1256.            
  1257.          }
  1258.          // SUELDO FIJO
  1259.          elseif ($resultado['porcent'] == 0 && $resultado['salaryHour'] == 0)
  1260.          {
  1261.            $sueldo = $resultado['salary'];
  1262.          }
  1263.          // SUELDO FIJO + COMISIÓN
  1264.          elseif ($resultado['salaryHour'] == 0)
  1265.          {
  1266.            $salary = $resultado['salary'];
  1267.            $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1268.            $sueldo = $salary + $comision;
  1269.          }
  1274.         // if ($resultado['porcent'] != 0) {
  1275.         //   $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1276.         // }
  1277.         // if ($resultado['salary'] != 0) {
  1278.         //   $sueldo = $resultado['salary'];
  1279.         // }
  1280.         // POR COMISION
  1281.         // if ($resultado['salary'] == 0 && $resultado['salaryHour'] == 0)
  1282.         // {
  1283.         //   $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1284.         // }
  1285.         // POR HORAS
  1286.         // elseif ($resultado['salary'] == 0 && $resultado['porcent'] == 0)
  1287.         // {
  1288.   
  1289.         // }
  1290.         // SUELDO FIJO
  1291.         // elseif ($resultado['porcent'] == 0 && $resultado['salaryHour'] == 0)
  1292.         // {
  1293.         //   $sueldo = $resultado['salary'];
  1294.         // }
  1295.         // // SUELDO FIJO + COMISIÓN
  1296.         // elseif ($resultado['salaryHour'] == 0)
  1297.         // {
  1298.         //   $sueldo = $resultado['salary'];
  1299.         //   $comision = $resultado['total'] * $resultado['porcent'] / 100;
  1300.         //   // $sueldo = $salary + $comision;
  1301.         // }
  1303.         if ($products){
  1304.           $comisionProd = 0;
  1305.           foreach ($products as $product) {
  1306.             $comisionProd = $comisionProd + $product['total'];
  1307.             $totalProd = $totalProd + $product['total'];
  1308.           }
  1309.           $comisionProd = $comisionProd * $worker->getProductPercent() / 100;
  1310.           // $resultado['products'] = [
  1311.           //   'percent'   => $worker->getProductPercent(),
  1312.           //   'total'     => $comisionProd,
  1313.           //   'comision'  => $comisionProd * $worker->getProductPercent() / 100
  1314.           // ];
  1315.         }
  1316.   
  1317.         $response = [
  1318.           'total'         => $resultado['total'],
  1319.           'porcent'       => $resultado['porcent'],
  1320.           'fijo'          => $resultado['salary'],
  1321.           'comision'      => $comision,
  1322.           'comisionProd'  => $comisionProd,
  1323.           'totalProd'     => $totalProd,
  1324.           'percentProd'   => $worker->getProductPercent()
  1325.         ];
  1326.       }
  1327.       return new JsonResponse(['data'=>$response, 'lang'=>$lang]);
  1328.     }
  1337. }
  1357. // namespace App\Controller;
  1359. // use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  1360. // use Symfony\Component\HttpFoundation\Response;
  1361. // use Symfony\Component\Routing\Annotation\Route;
  1363. // class RegistroController extends AbstractController
  1364. // {
  1365. //     #[Route('/registro', name: 'app_registro')]
  1366. //     public function index(): Response
  1367. //     {
  1368. //         return $this->render('registro/index.html.twig', [
  1369. //             'controller_name' => 'RegistroController',
  1370. //         ]);
  1371. //     }
  1372. // }