src/Controller/PartnerController.php line 808

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\User;
  6. use App\Entity\Partner;
  7. use App\Entity\Wholesaler;
  8. use App\Entity\Partnerfiles;
  9. use App\Entity\Task;
  10. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  11. use Symfony\Component\HttpFoundation\Request;
  12. use Symfony\Component\HttpFoundation\Response;
  13. use Symfony\Component\Routing\Annotation\Route;
  14. use Symfony\Contracts\Translation\TranslatorInterface;
  15. use App\Form\Resources\PartnerSearch;
  16. use App\Form\Type\PartnerlevelbyvendorEditType;
  17. use App\Form\Type\PartnerEditType;
  18. use App\Form\Type\PartnerQuestionnaireEditType;
  19. use App\Service\RegisterEvent;
  20. use App\Service\ServiceCompanyLogo;
  21. use App\Service\TrafficTracker;
  22. use App\Service\Translation;
  23. use App\Service\ServiceNotification;
  24. use App\Command\ProcessPartnerFiles;
  25. use App\Entity\Currency;
  26. use DateTime;
  27. use Ramsey\Uuid\Uuid;
  28. use App\Entity\Partnerproducttype;
  29. use App\Entity\Partnervendorsinterested;
  30. use App\Entity\Partnercategoryinterested;
  31. use App\Entity\Vendors;
  32. use App\Service\CustomerCreator;
  33. use Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface;
  34. use App\Entity\CompanyAddress;
  35. use App\Entity\Regions;
  36. use App\Entity\Countries;
  37. use Psr\Log\LoggerInterface;
  39. class PartnerController extends AbstractController
  40. {
  42.     private $customerCreator;
  43.     private $passwordHasher;
  45.     public function __construct(UserPasswordHasherInterface $passwordHasher, CustomerCreator $customerCreator)
  46.     {
  47.         $this->passwordHasher = $passwordHasher;
  48.         $this->customerCreator = $customerCreator;
  49.     }
  51.     /**
  52.      * @Route("/partner/default/index", name="partner_index")
  53.      */
  54.     public function index(TranslatorInterface $translator, Translation $translation, Request $request, TrafficTracker $trafficTracker): Response
  55.     {
  56.         $trafficTracker->registerTraffic();
  57.         $em = $this->getDoctrine()->getManager();
  58.         $locale = $request->getLocale();
  59.         $data = array();
  61.         $user = $this->getUser();
  62.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  64.         $queryData = $userRepository->MyComercialQuery($user);
  65.         $comercialUsers = $queryData->getQuery()->execute();
  67.         $form = $this->createForm(PartnerSearch::class, null, array(
  68.             'translator' => $translator,
  69.             'text' => $request->get('text'),
  70.             'idcommercialagent' => $request->get('idcommercialagent'),
  71.             'province' => $request->get('province'),
  72.             'comercial' => $comercialUsers,
  73.             'active' => $request->get('active'),
  74.         ));
  76.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  77.         $partnerQ = $partnerRepository->MyPartnerQuery($user);
  78.         $partnerList = $partnerQ->getQuery()->execute();
  81.         foreach ($partnerList as $partner) {
  82.             if ($partner->getIdcommercialagent() == NULL) {
  83.                 $commercialName = $translator->trans('app.ManageUsers&Profiles.NoAgent');
  84.             } else {
  85.                 $iduser = $partner->getIdcommercialagent();
  86.                 $wholesalerUser = $em->createQuery('SELECT u'
  87.                     . ' FROM App\Entity\User u'
  88.                     . ' WHERE u.id = :userId')
  89.                     ->setParameter('userId', $iduser)
  90.                     ->getOneOrNullResult();
  92.                 $commercialName = $wholesalerUser->getName() . ' ' . $wholesalerUser->getSurname();
  93.             }
  95.             $partnerPrealta = $em->createQuery('SELECT p'
  96.                 . ' FROM App\Entity\Partnerprealta p'
  97.                 . ' WHERE p.unregistrationdate IS NULL'
  98.                 . ' AND p.partner = :partner')
  99.                 ->setParameter('partner', $partner)
  100.                 ->getOneOrNullResult();
  102.             if (!empty($partnerPrealta)) {
  103.                 $prealta = true;
  104.             } else {
  105.                 $prealta = false;
  106.             }
  109.             $region = $em->createQuery('SELECT r'
  110.                 . ' FROM App\Entity\Regions r'
  111.                 . ' WHERE r.id = :id')
  112.                 ->setParameter('id', $partner->getRegion()->getId())
  113.                 ->getOneOrNullResult();
  115.             $data[] = array(
  116.                 'id' => $partner->getId(),
  117.                 'name' => $partner->getSocialReason(),
  118.                 'nameComercial' => $partner->getName(),
  119.                 'partnerLevel' => $partner->getkatyPartnerLevel(),
  120.                 'comercial' => $commercialName,
  121.                 'registrationDate' => $partner->getRegistrationdate(),
  122.                 'unregistrationDate' => $partner->getUnRegistrationdate(),
  123.                 'region' => $translation->getTranslationBy($region, $locale, 'regionName'),
  124.                 'prealta' => $prealta,
  125.                 'katyAccess' => $partner->getKatyAccess(),
  126.                 'externalId' => $partner->getExternalId(),
  127.                 'creditLimit' => $partner->getFinancialRisk(),
  128.                 'cif' => $partner->getCif()
  129.             );
  130.         }
  133.         return $this->render('partner/index.html.twig', [
  134.             'data' => $data,
  135.             'form' => $form->createView(),
  136.         ]);
  137.     }
  139.     /**
  140.      * @Route("/partner/default/view/{id}", name="partner_view", requirements={"id"="\d+"})
  141.      */
  142.     public function view(TranslatorInterface $translator, Translation $translation, Request $request, $id, TrafficTracker $trafficTracker): Response
  143.     {
  144.         $trafficTracker->registerTraffic();
  145.         $em = $this->getDoctrine()->getManager();
  146.         $locale = $request->getLocale();
  147.         $session = $this->get('session');
  148.         $sector = 'N/A';
  149.         $level_by_vendor = [];
  150.         $user = $this->getUser();
  152.         /** @var CompanyAddress */
  153.         $companyAddressRepository = $em->getRepository(CompanyAddress::class);
  155.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  157.         $partner = $partnerRepository->MyPartnerQuery($user)
  158.             ->andWhere('p.id = :id')
  159.             ->setParameter('id', $id)
  160.             ->getQuery()->getOneOrNullResult();
  162.         if (is_null($partner)) {
  163.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.NoResults'));
  165.             if ($user->getPartner()) {
  166.                 return $this->redirect($this->generateUrl('home'));
  167.             } else {
  168.                 return $this->redirect($this->generateUrl('partner_index'));
  169.             }
  170.         }
  172.         $users = $em->createQuery('SELECT u'
  173.             . ' FROM App\Entity\User u'
  174.             . ' WHERE u.partner = :partner'
  175.             . ' AND u.ghost = false')
  176.             ->setParameter('partner', $partner)
  177.             ->getResult();
  179.         $userList = [];
  181.         foreach ($users as $user) {
  182.             $userroles = $em->createQuery('SELECT r'
  183.                 . ' FROM App\Entity\Role r'
  184.                 . ' WHERE r.internalRole in (:roles)')
  185.                 ->setParameter('roles', $user->getRoles())
  186.                 ->getResult();
  188.             $roles = array();
  190.             foreach ($userroles as $userR) {
  191.                 $roleName = $translation->getTranslationBy($userR, $locale, 'name');
  192.                 $roles[] = $roleName;
  193.             }
  195.             $userList[] = [
  196.                 'user' => $user,
  197.                 'roles' => $roles,
  198.             ];
  199.         }
  201.         if ($partner->getIdcommercialagent() == NULL) {
  202.             $commercialName = "No asignado";
  203.         } else {
  204.             $iduser = $partner->getIdCommercialAgent();
  205.             $user = $em->createQuery('SELECT u'
  206.                 . ' FROM App\Entity\User u'
  207.                 . ' WHERE u.id = :userId')
  208.                 ->setParameter('userId', $iduser)
  209.                 ->getOneOrNullResult();
  211.             $commercialName = $user->getName() . ' ' . $user->getSurname();
  212.         }
  214.         //Agreements
  215.         $vendor_agreements = $em->createQuery('SELECT a'
  216.             . ' FROM App\Entity\Agreements a'
  217.             . ' JOIN a.programm vp'
  218.             . ' JOIN vp.vendor v'
  219.             . ' WHERE a.partner = :partner'
  220.             . ' ORDER BY v.name')
  221.             ->setParameter('partner', $partner)
  222.             ->getResult();
  224.         //Level by vendor        
  225.         $level_by_vendorQuery = $em->createQuery('SELECT p'
  226.             . ' FROM App\Entity\Partnerlevelbyvendor p'
  227.             . ' JOIN p.vendor v'
  228.             . ' WHERE v.followskatypartnerlevel = 0'
  229.             . ' AND p.partner = :partner'
  230.             . ' ORDER BY v.name')
  231.             ->setParameter('partner', $partner)
  232.             ->getResult();
  234.         $level_by_vendor = [];
  236.         foreach ($level_by_vendorQuery as $partnerLevel) {
  237.             $level = $partnerLevel->getLevel();
  239.             $levelName = $em->createQuery('SELECT v'
  240.                 . ' FROM App\Entity\Vendorpartnerlevel v'
  241.                 . ' WHERE v.vendor = :vendor'
  242.                 . ' AND v.level = :level')
  243.                 ->setParameter('vendor', $partnerLevel->getVendor())
  244.                 ->setParameter('level', $partnerLevel->getLevel())
  245.                 ->getOneOrNullResult();
  247.             if (!empty($levelName)) {
  248.                 $level = $levelName->getName();
  249.             }
  251.             $level_by_vendor[] = [
  252.                 'id' =>   $partnerLevel->getId(),
  253.                 'vendor' => $partnerLevel->getVendor()->getName(),
  254.                 'level' => $level
  255.             ];
  256.         }
  258.         if (is_null($partner->getExternalId())) {
  259.             $partner->setExternalId('N/A');
  260.         }
  262.         $country = $em->createQuery('SELECT c'
  263.             . ' FROM App\Entity\Countries c'
  264.             . ' JOIN App\Entity\Regions r'
  265.             . ' WITH c.id = r.country'
  266.             . ' WHERE r.id = :id')
  267.             ->setParameter('id', $partner->getRegion()->getId())
  268.             ->getOneOrNullResult();
  270.         $companyAddresses = $companyAddressRepository->MyCompanyAddressQuery($partner)->getQuery()->getResult();
  273.         return $this->render('partner/view.html.twig', [
  274.             'id' => $id,
  275.             'partner' => $partner,
  276.             'country' => $translation->getTranslationBy($country, $locale, 'name'),
  277.             'sector' => $sector,
  278.             'commercial_agent' => $commercialName,
  279.             'vendor_agreements' => $vendor_agreements,
  280.             'level_by_vendor' => $level_by_vendor,
  281.             'datasales' => $this->SalesTotal($id),
  282.             'totalclient' => $this->TotalClient($id),
  283.             'totalsalesWidget' => $this->TotalSalesWidget($id),
  284.             'totalTicket' => $this->TotalTicket($id),
  285.             'users' => $userList,
  286.             'user' => $this->getUser(),
  287.             'companyAddresses' => $companyAddresses
  288.         ]);
  289.     }
  291.     /**
  292.      * @Route("/partner/default/create", name="partner_create")
  293.      */
  294.     public function create(TranslatorInterface $translator, Translation $translation, ServiceNotification $serviceNotification, Request $request, RegisterEvent $registerEvent, TrafficTracker $trafficTracker): Response
  295.     {
  296.         $trafficTracker->registerTraffic();
  297.         $em = $this->getDoctrine()->getManager();
  298.         $locale = $request->getLocale();
  299.         $session = $this->get('session');
  300.         $user = $this->getUser();
  301.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  302.         $regionsRepository = $em->getRepository(Regions::class);
  304.         $country = null;
  305.         $edit = false;
  306.         $partner = new Partner();
  308.         $wholesalerRepository = $this->getDoctrine()->getRepository(Wholesaler::class);
  309.         $wholesaler = $wholesalerRepository->find($user->getWholesaler()->getId());
  310.         $country = $wholesaler->getCountry();
  311.         $localelist = explode("|", $this->getParameter('app_locales'));
  313.         $queryData = $userRepository->MyComercialQuery($user);
  314.         $comercial = $queryData->getQuery()->execute();
  316.         $editFinancialRisk = 0;
  318.         //search if the wholesaler user has the role to manage the financial risk of the partner
  319.         $hasFinancialRiskRole = $em->createQuery('SELECT u'
  320.             . ' FROM App\Entity\User u'
  321.             . ' WHERE u.id = :user'
  322.             . ' AND (u.roles like :role_one'
  323.             . ' OR u.roles like :role_two)')
  324.             ->setParameter('user', $user->getId())
  325.             ->setParameter('role_one', '%ROLE_MANAGE_PARTNER_FINANCIAL_RISK%')
  326.             ->setParameter('role_two', '%ROLE_ADMIN_USER_NEW%')
  327.             ->getOneOrNullResult();
  329.         if (!is_null($hasFinancialRiskRole)) {
  330.             $editFinancialRisk = 1;
  331.         }
  333.         if ($user->getMaster() || in_array("ROLE_ADMIN_USER_NEW", $user->getRoles()) || in_array("ROLE_MANAGE_PARTNERS_NEW", $user->getRoles())) {
  334.             $canEditMfa = true;
  335.         } else {
  336.             $canEditMfa = false;
  337.         }
  339.         $form = $this->createForm(PartnerEditType::class, $partner, array(
  340.             'localelist' => $localelist,
  341.             'locale' => $locale,
  342.             'comercial' => $comercial,
  343.             'country' => $country,
  344.             'edit' => $edit,
  345.             'translator' => $translator,
  346.             'entitymanager' => $em,
  347.             'translation' => $translation,
  348.             'editFinancialRisk' => $editFinancialRisk,
  349.             'canEditCurrency' => $user->getWholesaler() ? true : false,
  350.             'mandatoryMfa' => $partner->isMandatoryMfa(),
  351.             'canEditMfa' => $canEditMfa,
  352.             'currentUser' => $this->getUser(),
  353.             'wholesaler' => $wholesaler,
  354.             'currencyRepository' => $this->getDoctrine()->getRepository(Currency::class),
  355.             'partner' => $partner ? $partner : null,
  356.             'country_default' => $partner->getCountry() ? $partner->getCountry() : $wholesaler->getCountry()
  357.         ));
  359.         // If posting data
  360.         $form->handleRequest($request);
  362.         if ($form->isSubmitted()) {
  364.             // If cancelled
  365.             if ($form->getClickedButton() && 'cancel' === $form->getClickedButton()->getName()) {
  366.                 return $this->redirect($this->generateUrl('partner_index'));
  367.             }
  369.             if ($form->isValid()) {
  370.                 $post = $form->getData();
  371.                 $userAdmin = new User();
  373.                 if (!is_null($form->get('userEmail')->getData())) {
  374.                     $userExist = $em->createQuery('SELECT u'
  375.                         . ' FROM App\Entity\User u'
  376.                         . ' WHERE u.email = :email')
  377.                         ->setParameter('email', $form->get('userEmail')->getData())
  378.                         ->getOneOrNullResult();
  380.                     if (!is_null($userExist)) {
  381.                         $session->getFlashBag()->add('warning', $translator->trans('app.Settings.MyAccount.ValidEmail'));
  382.                         return $this->render('partner/create.html.twig', [
  383.                             'form' => $form->createView(),
  384.                             'edit' => $edit,
  385.                             'editFinancialRisk' => $editFinancialRisk,
  386.                             'canEditMfa' => $canEditMfa
  388.                         ]);
  389.                     }
  391.                     $existPartner = $em->createQuery('SELECT count(p.id)'
  392.                         . ' FROM App\Entity\Partner p'
  393.                         . ' WHERE p.katycif = :cif'
  394.                         . ' AND p.wholesaler = :wholesaler')
  395.                         ->setParameter('cif', preg_replace("/[^a-zA-Z0-9]/", "", strtoupper($form->get('cif')->getData())))
  396.                         ->setParameter('wholesaler', $user->getWholesaler())
  397.                         ->getSingleScalarResult();
  399.                     if ($existPartner != 0) {
  400.                         $session->getFlashBag()->add('warning', $translator->trans('app.ManageUsers&Profiles.CifDuplicated'));
  401.                         return $this->render('partner/create.html.twig', [
  402.                             'form' => $form->createView(),
  403.                             'edit' => $edit,
  404.                             'editFinancialRisk' => $editFinancialRisk,
  405.                             'canEditMfa' => $canEditMfa
  406.                         ]);
  407.                     }
  409.                     $existPartnerExternalId = $em->createQuery('SELECT count(p.id)'
  410.                         . ' FROM App\Entity\Partner p'
  411.                         . ' WHERE p.externalid = :externalId'
  412.                         . ' AND p.wholesaler = :wholesaler')
  413.                         ->setParameter('externalId', $post->getExternalId())
  414.                         ->setParameter('wholesaler', $user->getWholesaler())
  415.                         ->getSingleScalarResult();
  417.                     if ($existPartnerExternalId != 0) {
  418.                         $session->getFlashBag()->add('warning', $translator->trans('app.ManageUsers&Profiles.ExternalIdDuplicated'));
  419.                         return $this->render('partner/create.html.twig', [
  420.                             'form' => $form->createView(),
  421.                             'edit' => $edit,
  422.                             'editFinancialRisk' => $editFinancialRisk,
  423.                         ]);
  424.                     }
  426.                     $userAdmin->setEmail($form->get('userEmail')->getData());
  427.                     $userAdmin->setTimezone($user->getTimezone());
  429.                     $myPassword = $userRepository->randomPassword();
  430.                     $userAdmin->setPassword($this->passwordHasher->hashPassword($user, $myPassword));
  431.                 }
  433.                 if (!is_null($form->get('region')) && $form->get('region')->getData()) {
  434.                     $reg = $regionsRepository->find($form->get('region')->getData());
  435.                     $partner->setRegion($reg);
  436.                 }
  439.                 if (!$partner->getCountry()) {
  440.                     $partner->setCountry($country);
  441.                 }
  442.                 if (!$partner->getRegion()) {
  443.                     $region1 = $regionsRepository->findRegionsByCountry($partner->getCountry())->getQuery()->getResult();
  444.                     $partner->setRegion(reset($region1));
  445.                 }
  447.                 if ($editFinancialRisk != 0) {
  448.                     $partner->setFinancialRisk($post->getFinancialRisk());
  449.                 } else {
  450.                     $partner->setFinancialRisk(0);
  451.                 }
  453.                 if ($userRepository->isMiniVendor($user)) {
  454.                     $partner->setRelatedVendor($user->getVendor());
  455.                 }
  457.                 $partner->setWholesaler($wholesaler);
  458.                 $partner->setRegistrationDate(new DateTime());
  459.                 $partner->setKatyCif(preg_replace("/[^a-zA-Z0-9]/", "", strtoupper($form->get('cif')->getData())));
  460.                 $country = $em->createQuery('SELECT c'
  461.                     . ' FROM App\Entity\Countries c'
  462.                     . ' WHERE c.id = :id')
  463.                     ->setParameter('id', $form->get('country')->getData())
  464.                     ->getOneOrNullResult();
  466.                 $partner->setCountry($country);
  467.                 $em->persist($partner);
  468.                 $em->flush();
  470.                 $registerEvent->addCreatedBy($partner, $user->getId());
  472.                 $userAdmin->setMaster(true);
  473.                 $userAdmin->setRegistrationdate(new DateTime());
  474.                 $userAdmin->setPartner($partner);
  475.                 $userAdmin->setName($form->get('userName')->getData());
  476.                 $userAdmin->setSurname($form->get('userSurname')->getData());
  477.                 $userAdmin->setLocale($form->get('userLocale')->getData());
  478.                 $userAdmin->setTimeZone($form->get('userTimeZone')->getData());
  479.                 $userAdmin->setPhone($form->get('userPhone')->getData());
  481.                 $roles = $this->addUserRoles();
  482.                 $userAdmin->setRoles($roles);
  484.                 $em->persist($userAdmin);
  485.                 $em->flush();
  487.                 $registerEvent->addCreatedBy($userAdmin, $user->getId());
  489.                 $data = [
  490.                     'password' => $myPassword,
  491.                     'user' => $userAdmin,
  492.                 ];
  494.                 $selfConsumptionCustomer = $this->customerCreator->createSelfConsumptionCustomer($partner);
  496.                 //Send email
  497.                 $serviceNotification->Notify(1, array($userAdmin), $data);
  499.                 // Redirect and show result                
  500.                 $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.Created'));
  501.                 return $this->redirect($this->generateUrl('partner_view', array('id' => $partner->getId())));
  502.             }
  503.         }
  505.         return $this->render('partner/create.html.twig', [
  506.             'form' => $form->createView(),
  507.             'edit' => $edit,
  508.             'editFinancialRisk' => $editFinancialRisk,
  509.             'canEditMfa' => $canEditMfa
  511.         ]);
  512.     }
  514.     /**
  515.      * @Route("/partner/default/edit/{id}", name="partner_edit", requirements={"id"="\d+"})
  516.      */
  517.     public function edit(TranslatorInterface $translator, Translation $translation, ServiceNotification $serviceNotification, Request $request, RegisterEvent $registerEvent, $id, ServiceCompanyLogo $companylogoService, TrafficTracker $trafficTracker): Response
  518.     {
  519.         $trafficTracker->registerTraffic();
  520.         $em = $this->getDoctrine()->getManager();
  521.         $locale = $request->getLocale();
  522.         $session = $this->get('session');
  523.         $user = $this->getUser();
  524.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  525.         $partnerRepository = $this->getDoctrine()->getRepository(Partner::class);
  527.         $partner = $partnerRepository->find($id);
  529.         if (is_null($partner)) {
  530.             $session->getFlashBag()->add('danger', $translator->trans('app.General.SystemMessages.NoResults'));
  531.             return $this->redirect($this->generateUrl('partner_index'));
  532.         }
  534.         $country = $partner->getWholesaler()->getCountry();
  536.         $edit = true;
  537.         $userList = $em->createQuery('SELECT u'
  538.             . ' FROM App\Entity\User u'
  539.             . ' WHERE u.partner = :partner'
  540.             . ' ORDER BY u.master desc')
  541.             ->setParameter('partner', $partner)
  542.             ->getResult();
  544.         $userListMaster = $em->createQuery('SELECT u'
  545.             . ' FROM App\Entity\User u'
  546.             . ' WHERE u.partner = :partner'
  547.             . ' AND u.ghost = 0'
  548.             . ' AND u.unregistrationdate is null'
  549.             . ' ORDER BY u.master desc')
  550.             ->setParameter('partner', $partner)
  551.             ->getResult();
  553.         $companyLogoId = $companylogoService->checkLogo();
  555.         if ($companyLogoId) {
  557.             $path = '/uploads/images/companylogo/';
  558.             $logo = $em->createQuery('SELECT c'
  559.                 . ' FROM App\Entity\Companylogo c'
  560.                 . ' WHERE c.id = :id')
  561.                 ->setParameter('id', $companyLogoId)
  562.                 ->getOneOrNullResult();
  564.             $companyLogo = [
  565.                 'id' => $logo->getId(),
  566.                 'pathNegative' => $path . $logo->getFilenameNegative(),
  567.                 'pathPositive' => $path . $logo->getFilenamePositive(),
  568.                 'hasNegative' => $logo->getFilenameNegative(),
  569.                 'hasPositive' => $logo->getFilenamePositive(),
  570.             ];
  571.         } else {
  573.             $companyLogo = null;
  574.         }
  576.         $localelist = explode("|", $this->getParameter('app_locales'));
  578.         $queryData = $userRepository->MyComercialQuery($user);
  579.         $comercial = $queryData->getQuery()->execute();
  581.         $editFinancialRisk = 0;
  583.         if (!$user->getPartner()) {
  584.             //search if the wholesaler user has the role to manage the financial risk of the partner
  585.             $hasFinancialRiskRole = $em->createQuery('SELECT u'
  586.                 . ' FROM App\Entity\User u'
  587.                 . ' WHERE u.id = :user'
  588.                 . ' AND (u.roles like :role_one'
  589.                 . ' OR u.roles like :role_two)')
  590.                 ->setParameter('user', $user->getId())
  591.                 ->setParameter('role_one', '%ROLE_MANAGE_PARTNER_FINANCIAL_RISK%')
  592.                 ->setParameter('role_two', '%ROLE_ADMIN_USER_NEW%')
  593.                 ->getOneOrNullResult();
  595.             if (!is_null($hasFinancialRiskRole)) {
  596.                 $editFinancialRisk = 1;
  597.             }
  598.         }
  600.         if ($user->getWholesaler() && ($user->getMaster() || in_array("ROLE_ADMIN_USER_NEW", $user->getRoles()) || in_array("ROLE_MANAGE_PARTNERS_NEW", $user->getRoles()))) {
  601.             $canEditMfa = true;
  602.         } else {
  603.             $canEditMfa = false;
  604.         }
  606.         $form = $this->createForm(PartnerEditType::class, $partner, array(
  607.             'localelist' => $localelist,
  608.             'locale' => $locale,
  609.             'comercial' => $comercial,
  610.             'country' => $country,
  611.             'edit' => $edit,
  612.             'userList' => $userList,
  613.             'userListMaster' => $userListMaster,
  614.             'wholesaler' => $user->getWholesaler() ? $user->getWholesaler() : null,
  615.             'partnerUser' => $user->getPartner(),
  616.             'translator' => $translator,
  617.             'entitymanager' => $em,
  618.             'translation' => $translation,
  619.             'currentRegion' => $partner->getRegion()->getId(),
  620.             'editFinancialRisk' => $editFinancialRisk,
  621.             'canEditCurrency' => $user->getWholesaler() ? true : false,
  622.             'katyAccess' => $partner->getKatyAccess(),
  623.             'mandatoryMfa' => $partner->isMandatoryMfa(),
  624.             'currentUser' => $this->getUser(),
  625.             'currencyRepository' => $this->getDoctrine()->getRepository(Currency::class),
  626.             'canEditMfa' => $canEditMfa,
  627.             'partner' => $partner ? $partner : null,
  628.             'regions_default' => $partner->getRegion() ? $partner->getRegion()->getId() : null,
  629.             'country_default' => $partner->getCountry() ? $partner->getCountry() : $wholesaler->getCountry()
  630.         ));
  633.         // If posting data
  634.         $form->handleRequest($request);
  636.         if ($form->isSubmitted()) {
  637.             if ($form->getClickedButton() && PartnerEditType::BUTTON_CANCEL === $form->getClickedButton()->getName()) {
  638.                 return $this->redirect($this->generateUrl('partner_view', array('id' => $id)));
  639.             } else {
  640.                 if ($user->getPartner()) {
  641.                     if ($form->getClickedButton() && PartnerEditType::BUTTON_CHANGE_MASTER === $form->getClickedButton()->getName()) {
  643.                         $partner = $partnerRepository->find($user->getPartner()->getId());
  645.                         $comercialUser = $em->createQuery('SELECT distinct u'
  646.                             . ' FROM App\Entity\User u'
  647.                             . ' WHERE u.wholesaler = :wholesaler'
  648.                             . ' AND (u.id = :commercialId'
  649.                             . ' OR u.roles like :role_one)')
  650.                             ->setParameter('commercialId', $partner->getIdcommercialagent())
  651.                             ->setParameter('role_one', '%ROLE_MANAGE_PARTNERS_NEW%')
  652.                             ->setParameter('wholesaler', $partner->getWholesaler())
  653.                             ->getResult();
  656.                         $currentUserMaster = $em->createQuery('SELECT u'
  657.                             . ' FROM App\Entity\User u'
  658.                             . ' WHERE u.master = 1'
  659.                             . ' AND u.partner = :partner')
  660.                             ->setParameter('partner', $user->getPartner())
  661.                             ->getOneOrNullResult();
  663.                         $data = [
  664.                             'companyName' => $partner->getName(),
  665.                             'user_email' => $user->getEmail(),
  666.                             'master' => $currentUserMaster,
  667.                             'route' => 'partner_view',
  668.                             'idview' => $partner->getId(),
  669.                         ];
  671.                         $serviceNotification->Notify(68, $comercialUser, $data);
  673.                         $session->getFlashBag()->add('success', $translator->trans('app.ManageUsers&Profiles.CTAs.RequestMasterChange'));
  674.                         return $this->redirect($this->generateUrl('partner_view', array('id' => $id)));
  675.                     }
  676.                 }
  677.             }
  679.             if ($form->isValid()) {
  681.                 $currentUserMaster = $em->createQuery('SELECT u'
  682.                     . ' FROM App\Entity\User u'
  683.                     . ' WHERE u.master = 1'
  684.                     . ' AND u.partner = :partner')
  685.                     ->setParameter('partner', $partner)
  686.                     ->getOneOrNullResult();
  688.                 $fileNegative = null;
  689.                 $filePositive = null;
  691.                 $wholesaler = $user->getWholesaler() ?? $user->getPartner()->getWholesaler();
  693.                 $existPartner = $em->createQuery('SELECT count(p.id)'
  694.                     . ' FROM App\Entity\Partner p'
  695.                     . ' WHERE p.katycif = :cif'
  696.                     . ' AND p.wholesaler = :wholesaler'
  697.                     . ' AND p.id != :id')
  698.                     ->setParameter('cif', preg_replace("/[^a-zA-Z0-9]/", "", strtoupper($form->get('cif')->getData())))
  699.                     ->setParameter('wholesaler', $wholesaler)
  700.                     ->setParameter('id', $id)
  701.                     ->getSingleScalarResult();
  703.                 if ($existPartner != 0) {
  704.                     $session->getFlashBag()->add('warning', $translator->trans('app.ManageUsers&Profiles.CifDuplicated'));
  705.                     return $this->redirect($this->generateUrl('partner_edit', array('id' => $id)));
  706.                 }
  708.                 $existPartnerExternalId = $em->createQuery('SELECT count(p.id)'
  709.                     . ' FROM App\Entity\Partner p'
  710.                     . ' WHERE p.externalid = :externalId'
  711.                     . ' AND p.wholesaler = :wholesaler'
  712.                     . ' AND p.id != :id')
  713.                     ->setParameter('externalId', $form->get('externalId')->getData())
  714.                     ->setParameter('wholesaler', $wholesaler)
  715.                     ->setParameter('id', $id)
  716.                     ->getSingleScalarResult();
  718.                 if ($existPartnerExternalId != 0) {
  719.                     $session->getFlashBag()->add('warning', $translator->trans('app.ManageUsers&Profiles.ExternalIdDuplicated'));
  720.                     return $this->redirect($this->generateUrl('partner_edit', array('id' => $id)));
  721.                 }
  723.                 if (!is_null($form->get('region')) && $form->get('region')->getData()) {
  724.                     $regionsRepository = $em->getRepository(Regions::class);
  725.                     $reg = $regionsRepository->find($form->get('region')->getData());
  726.                     $partner->setRegion($reg);
  727.                 }
  728.                 if ($edit && $user->getPartner()) {
  729.                     $fileNegative = $form->get('fileNegative')->getData();
  730.                     $logocompanyNegative = $companylogoService->setCompanyLogo($fileNegative, 0);
  732.                     $filePositive = $form->get('filePositive')->getData();
  733.                     $logocompanyPositive = $companylogoService->setCompanyLogo($filePositive, 1);
  735.                     if (!$logocompanyNegative || !$logocompanyPositive) {
  736.                         return $this->redirect($this->generateUrl('partner_edit', array('id' => $id)));
  737.                     }
  738.                 }
  740.                 $lastMaster = $em->createQuery('SELECT u'
  741.                     . ' FROM App\Entity\User u'
  742.                     . ' WHERE u.master = 1'
  743.                     . ' AND u.partner = :partner')
  744.                     ->setParameter('partner', $partner)
  745.                     ->getOneOrNullResult();
  749.                 $partner->setCif($form->get('cif')->getData());
  750.                 $partner->setKatyCif(preg_replace("/[^a-zA-Z0-9]/", "", strtoupper($form->get('cif')->getData())));
  752.                 $country = $em->createQuery('SELECT c'
  753.                     . ' FROM App\Entity\Countries c'
  754.                     . ' WHERE c.id = :id')
  755.                     ->setParameter('id', $form->get('country')->getData())
  756.                     ->getOneOrNullResult();
  757.                 $partner->setCountry($country);
  759.                 $em->persist($partner);
  760.                 $em->flush();
  762.                 $registerEvent->addModifiedBy($partner, $user->getId());
  764.                 if ($user->getWholesaler() && ($lastMaster->getId() != $form->get('master')->getData())) {
  765.                     $lastMaster->setMaster(0);
  766.                     $em->persist($lastMaster);
  767.                     $em->flush();
  769.                     $registerEvent->addModifiedBy($lastMaster, $user->getId());
  770.                     $newMaster = $em->createQuery('SELECT u'
  771.                         . ' FROM App\Entity\User u'
  772.                         . ' WHERE u.id = :id')
  773.                         ->setParameter('id', $form->get('master')->getData())
  774.                         ->getOneOrNullResult();
  776.                     $newMaster->setMaster(1);
  777.                     $roles = $this->addUserRoles();
  778.                     $newMaster->setRoles($roles);
  780.                     $em->persist($newMaster);
  781.                     $em->flush();
  783.                     $registerEvent->addModifiedBy($newMaster, $user->getId());
  784.                 }
  786.                 // Redirect and show result
  787.                 $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  790.                 return $this->redirect($this->generateUrl('partner_view', array('id' => $id)));
  791.             }
  792.         }
  794.         return $this->render('partner/edit.html.twig', [
  795.             'form' => $form->createView(),
  796.             'edit' => $edit,
  797.             'editFinancialRisk' => $editFinancialRisk,
  798.             'user' => $user->getWholesaler() ? $user->getWholesaler()->getId() : null,
  799.             'companylogo' => $companyLogo,
  800.             'fRisk' => $partner->getFinancialrisk(),
  801.             'canEditMfa' => $canEditMfa
  802.         ]);
  803.     }
  805.     /**
  806.      * @Route("/partner/default/editlevelbyvendor/{id}/{idlevel}", name="partner_editlevelbyvendor", requirements={"id"="\d+", "idlevel"="\d+"})
  807.      */
  808.     public function editlevelbyvendor($idlevel = 0, $id, TranslatorInterface $translator, Request $request, TrafficTracker $trafficTracker): Response
  809.     {
  810.         $trafficTracker->registerTraffic();
  811.         $em = $this->getDoctrine()->getManager();
  812.         $session = $this->get('session');
  814.         $partner = $em->createQuery('SELECT p'
  815.             . ' FROM App\Entity\Partner p'
  816.             . ' WHERE p.id = :id')
  817.             ->setParameter('id', $id)
  818.             ->getOneOrNullResult();
  820.         $partnerLevelByVendor = null;
  822.         if ($idlevel) {
  823.             $partnerLevelByVendor = $em->createQuery('SELECT p'
  824.                 .  ' FROM App\Entity\Partnerlevelbyvendor p'
  825.                 . ' WHERE p.id = :id')
  826.                 ->setParameter('id', $idlevel)
  827.                 ->getOneOrNullResult();
  829.             $currentlevel = $partnerLevelByVendor->getLevel();
  830.             $action = 'edit';
  831.         } else {
  832.             $action = 'new';
  833.             $currentlevel = null;
  834.         }
  837.         $form = $this->createForm(PartnerlevelbyvendorEditType::class, null, array(
  838.             'translator' => $translator,
  839.             'action' => $action,
  840.             'level' => $partnerLevelByVendor,
  841.             'partner' => $partner,
  842.             'entitymanager' => $em,
  843.         ));
  846.         $form->handleRequest($request);
  848.         // If cancelled
  849.         if ($form->getClickedButton() && 'cancel' === $form->getClickedButton()->getName()) {
  851.             return $this->redirect($this->generateUrl('partner_view', array('id' => $partner->getId())));
  852.         }
  854.         if ($form->isSubmitted() && $form->isValid()) {
  856.             $post = $form->getData();
  858.             if ($post['level'] == 0 && !$idlevel) {
  860.                 $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  861.             } else {
  863.                 if (!$idlevel) {
  864.                     $partnerLevelByVendor = new \App\Entity\Partnerlevelbyvendor();
  865.                     $partnerLevelByVendor->setPartner($partner);
  866.                 }
  868.                 if ($post['level'] == 0) {
  869.                     $em->remove($partnerLevelByVendor);
  870.                     $em->flush();
  871.                 } else {
  872.                     $vendor = $em->createQuery('SELECT v'
  873.                         . ' FROM App\Entity\Vendors v'
  874.                         . ' WHERE v.id = :id')
  875.                         ->setParameter('id', $post['idVendor'])
  876.                         ->getOneOrNullResult();
  878.                     $partnerLevelByVendor->setVendor($vendor);
  879.                     $partnerLevelByVendor->setLevel($post['level']);
  880.                     $em->persist($partnerLevelByVendor);
  881.                     $em->flush();
  882.                 }
  884.                 // Redirect and show result
  885.                 $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  886.             }
  888.             return $this->redirect($this->generateUrl('partner_view', array('id' => $partner->getId())));
  889.         }
  892.         return $this->render('partner/editlevelbyvendor.html.twig', [
  893.             'currentlevel' => $currentlevel,
  894.             'form' => $form->createView(),
  895.         ]);
  896.     }
  898.     /**
  899.      * @Route("/partner/default/findvendorpartnerlevels", name="partner_findvendorpartnerlevels")
  900.      */
  901.     public function findvendorpartnerlevels(Request $request)
  902.     {
  903.         $em = $this->getDoctrine()->getManager();
  904.         $idVendor = $request->request->get('idVendor');
  906.         $levels = $em->createQuery('SELECT v'
  907.             . ' FROM App\Entity\Vendorpartnerlevel v'
  908.             . ' WHERE v.vendor = :idvendor')
  909.             ->setParameter('idvendor', $idVendor)
  910.             ->getResult();
  912.         $vendorPartnerLevels = array();
  913.         $vendorPartnerLevels[0] = "---";
  914.         foreach ($levels as $level) {
  915.             $vendorPartnerLevels[$level->getLevel()] = $level->getName();
  916.         }
  918.         $response = new \Symfony\Component\HttpFoundation\JsonResponse();
  919.         $response->setStatusCode(200);
  920.         $response->setData($vendorPartnerLevels);
  922.         return $response;
  923.     }
  926.     /**
  927.      * @Route("/partner/default/block/{id}", name="partner_block", requirements={"id"="\d+"})
  928.      */
  929.     public function block(TranslatorInterface $translator, Request $request, RegisterEvent $registerEvent, TrafficTracker $trafficTracker): Response
  930.     {
  931.         $trafficTracker->registerTraffic();
  932.         $em = $this->getDoctrine()->getManager();
  933.         $session = $this->get('session');
  934.         $currentUser = $this->getUser();
  936.         $id = $request->get('id');
  937.         $partner = $em->createQuery('SELECT p'
  938.             . ' FROM App\Entity\Partner p'
  939.             . ' WHERE p.id = :id'
  940.             . ' AND p.unregistrationdate is null')
  941.             ->setParameter('id', $id)
  942.             ->getOneOrNullResult();
  944.         $partner->setKatyAccess(0);
  945.         $em->persist($partner);
  946.         $em->flush();
  948.         $registerEvent->addModifiedBy($partner, $currentUser->getId());
  949.         $master = $em->createQuery('SELECT u'
  950.             . ' FROM App\Entity\User u'
  951.             . ' WHERE u.master = 1'
  952.             . ' AND u.partner = :partner')
  953.             ->setParameter('partner', $partner)
  954.             ->getOneOrNullResult();
  956.         $master->setLocked(1);
  957.         $em->persist($master);
  958.         $em->flush();
  959.         $registerEvent->addModifiedBy($master, $currentUser->getId());
  961.         $users = $em->createQuery('SELECT u'
  962.             . ' FROM App\Entity\User u'
  963.             . ' WHERE u.master = 0'
  964.             . ' AND u.partner = :partner')
  965.             ->setParameter('partner', $partner)
  966.             ->getResult();
  968.         foreach ($users as $user) {
  969.             $user->setLocked(1);
  970.             $em->persist($user);
  971.             $em->flush();
  972.             $registerEvent->addModifiedBy($user, $currentUser->getId());
  973.         }
  976.         $session->getFlashBag()->add('success', $partner->getName() . ' ' . $translator->trans('app.General.SystemMessages.Blocked'));
  977.         return $this->redirect($this->generateUrl('partner_view', ['id' => $id]));
  978.     }
  980.     /**
  981.      * @Route("/partner/default/unblock/{id}", name="partner_unblock", requirements={"id"="\d+"})
  982.      */
  983.     public function unblock(TranslatorInterface $translator, Request $request, ServiceNotification $serviceNotification, RegisterEvent $registerEvent, TrafficTracker $trafficTracker): Response
  984.     {
  985.         $trafficTracker->registerTraffic();
  986.         $em = $this->getDoctrine()->getManager();
  987.         $session = $this->get('session');
  988.         $currentUser = $this->getUser();
  989.         $userRepository = $this->getDoctrine()->getRepository(User::class);
  991.         $id = $request->get('id');
  992.         $partner = $em->createQuery('SELECT p'
  993.             . ' FROM App\Entity\Partner p'
  994.             . ' WHERE p.id = :id'
  995.             . ' AND p.unregistrationdate is null')
  996.             ->setParameter('id', $id)
  997.             ->getOneOrNullResult();
  999.         $partner->setKatyAccess(1);
  1000.         $em->persist($partner);
  1001.         $em->flush();
  1003.         $registerEvent->addModifiedBy($partner, $currentUser->getId());
  1004.         $master = $em->createQuery('SELECT u'
  1005.             . ' FROM App\Entity\User u'
  1006.             . ' WHERE u.master = 1'
  1007.             . ' AND u.partner = :partner')
  1008.             ->setParameter('partner', $partner)
  1009.             ->getOneOrNullResult();
  1011.         $master->setLocked(0);
  1013.         $myPassword = $userRepository->randomPassword();
  1014.         $master->setPassword($this->passwordHasher->hashPassword($currentUser, $myPassword));
  1015.         $master->setChangepassdate(null);
  1016.         $em->persist($master);
  1017.         $em->flush();
  1019.         $registerEvent->addModifiedBy($master, $currentUser->getId());
  1021.         $data = [
  1022.             'password' => $myPassword,
  1023.             'user' => $master,
  1024.         ];
  1026.         //Send email
  1027.         $serviceNotification->Notify(1, array($master), $data);
  1029.         $session->getFlashBag()->add('success', $partner->getName() . ' ' . $translator->trans('app.General.SystemMessages.Activated'));
  1030.         return $this->redirect($this->generateUrl('partner_view', ['id' => $id]));
  1031.     }
  1033.     /**
  1034.      * @Route("/partner/default/partnerquestionnaire", name="partner_questionnaire")
  1035.      */
  1036.     public function partnerquestionnaire(TranslatorInterface $translator, Translation $translation, Request $request, TrafficTracker $trafficTracker): Response
  1037.     {
  1038.         $trafficTracker->registerTraffic();
  1039.         $session = $this->get('session');
  1040.         $em = $this->getDoctrine()->getManager();
  1041.         $user = $this->getUser();
  1042.         $locale = $request->getLocale();
  1044.         $partnerProfile = new \App\Entity\Partnerprofile();
  1045.         $partnerProfile->setPartner($user->getPartner());
  1047.         $employeesRange = $em->createQuery('SELECT er'
  1048.             . ' FROM App\Entity\Employeesrange er')
  1049.             ->getResult();
  1051.         $categoryList = $em->createQuery('SELECT c'
  1052.             . ' FROM App\Entity\Category c'
  1053.             . ' ORDER BY c.name')
  1054.             ->getResult();
  1056.         $invoiceRange = $em->createQuery('SELECT ir'
  1057.             . ' FROM App\Entity\Invoicerange ir')
  1058.             ->getResult();
  1060.         $vendorsList = $em->createQuery('SELECT v'
  1061.             . ' FROM App\Entity\Vendors v'
  1062.             . ' WHERE v.isminivendor = 0'
  1063.             . ' AND v.name not like \'Katy\''
  1064.             . ' ORDER BY v.name')
  1065.             ->getResult();
  1067.         $productTypes = $em->createQuery('SELECT q'
  1068.             . ' FROM App\Entity\Questionnaireproducttype q')
  1069.             ->getResult();
  1071.         // Init form
  1072.         $form = $this->createForm(PartnerQuestionnaireEditType::class, null, array(
  1073.             'translator' => $translator,
  1074.             'employeesRange' => $employeesRange,
  1075.             'categoryList' => $categoryList,
  1076.             'invoiceRange' => $invoiceRange,
  1077.             'vendorsList' => $vendorsList,
  1078.             'productTypes' => $productTypes,
  1079.             'translation' => $translation,
  1080.             'locale' => $locale,
  1081.         ));
  1083.         // If posting data
  1084.         $form->handleRequest($request);
  1086.         if ($form->isSubmitted()) {
  1087.             $post = $form->getData();
  1089.             if (
  1090.                 empty($post['businessType']) || empty($post['productType']) ||
  1091.                 (empty($post['vendorsInterested']) && empty($post['otherVendorsInterested']))
  1092.                 || (empty($post['categoryInterested']) && empty($post['otherCategoryInterested']))
  1093.             ) {
  1095.                 $session->getFlashBag()->add('warning', $translator->trans('app.ManageUsers&Profiles.CheckAllLists'));
  1096.                 return $this->render('partner/partnerquestionnaire.html.twig', [
  1097.                     'form' => $form->createView(),
  1098.                 ]);
  1099.             }
  1101.             $employeesRange = $em->createQuery('SELECT er'
  1102.                 . ' FROM App\Entity\Employeesrange er'
  1103.                 . ' WHERE er.id = :id')
  1104.                 ->setParameter('id', $form->get('idEmployeesRange')->getData())
  1105.                 ->getOneOrNullResult();
  1107.             $partnerProfile->setEpmloyeesRange($employeesRange);
  1109.             $partnerProfile->setActiveclients($post['activeClients']);
  1111.             $invoiceRange = $em->createQuery('SELECT ir'
  1112.                 . ' FROM App\Entity\Invoicerange ir'
  1113.                 . ' WHERE ir.id = :id')
  1114.                 ->setParameter('id', $form->get('idInvoiceRange')->getData())
  1115.                 ->getOneOrNullResult();
  1117.             $partnerProfile->setInvoiceRange($invoiceRange);
  1119.             $businessType = '';
  1121.             $businessTypeData = $post['businessType'];
  1123.             if (count($businessTypeData) == 2) {
  1124.                 $businessType = $translator->trans('app.ManageUsers&Profiles.PartnerForm.A1Business') . ' / ' . $translator->trans('app.ManageUsers&Profiles.PartnerForm.A2Business');
  1125.             } else {
  1126.                 switch ($businessTypeData[0]) {
  1127.                     case 1:
  1128.                         $businessType = $translator->trans('app.ManageUsers&Profiles.PartnerForm.A1Business');
  1129.                         break;
  1130.                     case 2:
  1131.                         $businessType = $translator->trans('app.ManageUsers&Profiles.PartnerForm.A2Business');
  1132.                         break;
  1133.                 }
  1134.             }
  1136.             $partnerProfile->setBusinesstype($businessType);
  1138.             foreach ($post['productType'] as $key => $value) {
  1139.                 if ($value != 0) {
  1140.                     $partnerProductType = new Partnerproducttype();
  1141.                     $partnerProductType->setPartner($user->getPartner());
  1143.                     $questionnaireProductType = $em->createQuery('SELECT q'
  1144.                         . ' FROM App\Entity\QuestionnaireProductType q'
  1145.                         . ' WHERE q.id = :id')
  1146.                         ->setParameter('id', $value)
  1147.                         ->getOneOrNullResult();
  1149.                     $partnerProductType->setQuestionnaireProductType($questionnaireProductType);
  1150.                     $em->persist($partnerProductType);
  1151.                     $em->flush();
  1152.                 }
  1153.             }
  1155.             foreach ($post['vendorsInterested'] as $key => $value) {
  1156.                 if ($value != 0) {
  1157.                     $partnerVendorsInterested = new Partnervendorsinterested();
  1158.                     $partnerVendorsInterested->setPartner($user->getPartner());
  1160.                     $vendor = $em->createQuery('SELECT v'
  1161.                         . ' FROM App\Entity\Vendors v'
  1162.                         . ' WHERE v.id = :id')
  1163.                         ->setParameter('id', $value)
  1164.                         ->getOneOrNullResult();
  1166.                     $partnerVendorsInterested->setVendor($vendor);
  1167.                     $em->persist($partnerVendorsInterested);
  1168.                     $em->flush();
  1169.                 }
  1170.             }
  1172.             $partnerProfile->setOthervendorsinterested($post['otherVendorsInterested']);
  1174.             foreach ($post['categoryInterested'] as $key => $value) {
  1175.                 if ($value != 0) {
  1176.                     $partnerCategoryInterested = new Partnercategoryinterested();
  1177.                     $partnerCategoryInterested->setPartner($user->getPartner());
  1179.                     $category = $em->createQuery('SELECT c'
  1180.                         . ' FROM App\Entity\Category c'
  1181.                         . ' WHERE c.id = :id')
  1182.                         ->setParameter('id', $value)
  1183.                         ->getOneOrNullResult();
  1185.                     $partnerCategoryInterested->setCategory($category);
  1186.                     $em->persist($partnerCategoryInterested);
  1187.                     $em->flush();
  1188.                 }
  1189.             }
  1191.             $partnerProfile->setOthercategoryinterested($post['otherCategoryInterested']);
  1193.             $partnerProfile->setCreatedby($user);
  1194.             $partnerProfile->setModifiedby($user);
  1196.             $partnerProfile->setSupporttool($post['supportTool']);
  1198.             if ($post['supportTool'] == 1) {
  1199.                 $partnerProfile->setInfosupporttool($post['infoSupportTool']);
  1200.             }
  1202.             $em->persist($partnerProfile);
  1203.             $em->flush();
  1205.             // Redirect and show result
  1206.             $session->getFlashBag()->add('success', $translator->trans('app.General.SystemMessages.ChangesSaved'));
  1208.             if (!$user->getAcceptedpolicies() || !$user->getAcceptedcookies()) {
  1209.                 return $this->redirectToRoute('user_policies');
  1210.             }
  1212.             return $this->redirectToRoute('home');
  1213.         }
  1216.         return $this->render('partner/partnerquestionnaire.html.twig', [
  1217.             'form' => $form->createView(),
  1218.         ]);
  1219.     }
  1222.     private function addUserRoles()
  1223.     {
  1224.         $em = $this->getDoctrine()->getManager();
  1226.         $partnerRoles = $em->createQuery('SELECT r'
  1227.             . ' FROM App\Entity\Role r'
  1228.             . ' WHERE r.partner = true')
  1229.             ->getResult();
  1231.         $roles = array();
  1233.         foreach ($partnerRoles as $roleValue) {
  1234.             $roles[] = $roleValue->getInternalRole();
  1235.         }
  1237.         return $roles;
  1238.     }
  1241.     private function SalesTotal($idpartner)
  1242.     {
  1243.         $em = $this->getDoctrine()->getManager();
  1245.         $arraysales = $em->createQuery('SELECT SUM(s.price) as totalprice,'
  1246.             . ' CONCAT(YEAR(s.datecreated), \' -\',MONTH(s.datecreated), \' -\', DAY(s.datecreated)) as date'
  1247.             . ' FROM App\Entity\Sales s'
  1248.             . ' JOIN s.customer c'
  1249.             . ' JOIN c.partner p'
  1250.             . ' WHERE p.id = :idpartner'
  1251.             . ' GROUP BY date')
  1252.             ->setParameter('idpartner', $idpartner)
  1253.             ->getArrayResult();
  1256.         $data = array();
  1257.         $salesdata = array();
  1259.         foreach ($arraysales as $sales) {
  1260.             $data['date'] = $sales['date'];
  1261.             $data['value'] = $sales['totalprice'];
  1262.             array_push($salesdata, $data);
  1263.         }
  1265.         return json_encode($salesdata);
  1266.     }
  1268.     private function TotalClient($idpartner)
  1269.     {
  1270.         $em = $this->getDoctrine()->getManager();
  1272.         $total_client = $em->createQuery('SELECT count(c.id)'
  1273.             . ' FROM App\Entity\Customer c'
  1274.             . ' JOIN c.partner p'
  1275.             . ' WHERE p.id = :idpartner'
  1276.             . ' AND p.wholesaler = :wholesaler')
  1277.             ->setParameter('idpartner', $idpartner)
  1278.             ->setParameter('wholesaler', $this->getUser()->getWholesaler())
  1279.             ->getOneOrNullResult();
  1282.         return $total_client[1];
  1283.     }
  1285.     private function TotalSalesWidget($idpartner)
  1286.     {
  1287.         $em = $this->getDoctrine()->getManager();
  1289.         $total_sales = $em->createQuery('SELECT count(s.id)'
  1290.             . ' FROM App\Entity\Sales s'
  1291.             . ' JOIN s.customer c'
  1292.             . ' JOIN c.partner p'
  1293.             . ' WHERE p.id = :idpartner'
  1294.             . ' AND p.wholesaler = :wholesaler')
  1295.             ->setParameter('idpartner', $idpartner)
  1296.             ->setParameter('wholesaler', $this->getUser()->getWholesaler())
  1297.             ->getOneOrNullResult();
  1299.         return $total_sales[1];
  1300.     }
  1302.     private function TotalTicket($idpartner)
  1303.     {
  1304.         $em = $this->getDoctrine()->getManager();
  1306.         $total_ticket = $em->createQuery('SELECT count(t.id)'
  1307.             . ' FROM App\Entity\Ticket t'
  1308.             . ' JOIN t.user u'
  1309.             . ' JOIN u.partner p'
  1310.             . ' WHERE p.id = :idpartner'
  1311.             . ' AND p.wholesaler = :wholesaler')
  1312.             ->setParameter('idpartner', $idpartner)
  1313.             ->setParameter('wholesaler', $this->getUser()->getWholesaler())
  1314.             ->getOneOrNullResult();
  1316.         return $total_ticket[1];
  1317.     }
  1319.     /**
  1320.      * @Route("/partner/default/getregions", name="partner_create_regions" )
  1321.      */
  1322.     public function partnerCreateRegions(Request $request, TrafficTracker $trafficTracker, TranslatorInterface $translator, Translation $translation)
  1323.     {
  1324.         $trafficTracker->registerTraffic();
  1325.         /** @var EntityManager */
  1326.         $entityManager = $this->getDoctrine()->getManager();
  1327.         $user = $this->getUser();
  1328.         $responseArray = null;
  1329.         $countryRepository = $entityManager->getRepository(Countries::class);
  1330.         $country = $countryRepository->find($request->get('country'));
  1331.         $regionsRepository = $entityManager->getRepository(Regions::class);
  1333.         $regions = $regionsRepository->findRegionsByCountry($country)->getQuery()->getResult();
  1335.         foreach ($regions as $region) {
  1336.             $responseArray[$region->getId()] = $translation->getTranslationBy($region, $user->getLocale(), 'regionName') . ' (' . $region->getCode() . ')';
  1337.         }
  1338.         $response = json_encode($responseArray);
  1340.         return new Response($response, 200, array(
  1341.             'Content-Type' => 'application/json'
  1342.         ));
  1343.     }
  1344. }