src/Controller/KnowledgeBaseController.php line 56

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use Doctrine\Persistence\ManagerRegistry;
  6. use Symfony\Component\HttpKernel\KernelInterface;
  7. use Symfony\Component\Routing\Annotation\Route;
  8. //use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  9. use Symfony\Component\HttpFoundation\Request;
  10. use Symfony\Component\HttpFoundation\Response;
  11. use Symfony\Component\Form\Extension\Core\Type\TextType;
  12. use Symfony\Component\Form\Extension\Core\Type\PasswordType;
  13. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  14. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  15. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  16. use Symfony\Component\Form\Extension\Core\Type\EmailType;
  17. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  18. use Ivory\CKEditorBundle\Form\Type\CKEditorType;
  19. use Symfony\Component\Console\Input\ArrayInput;
  20. use Symfony\Bundle\FrameworkBundle\Console\Application;
  21. use Symfony\Component\Validator\Constraints\DateTime;
  23. use App\Entity\Eshop;
  24. use App\Entity\EshopLink;
  25. use App\Entity\Service;
  26. use App\Entity\Contact;
  27. use App\Entity\ContactGroup;
  28. use App\Entity\CustomList;
  29. use App\Entity\CustomListItem;
  30. use App\Entity\Address;
  31. use App\Entity\User;
  32. use App\Entity\UserStory;
  33. use App\Entity\Module;
  34. use App\Entity\Consent;
  35. use App\Entity\PriceLevel;
  37. use App\Entity\Order; 
  38. use App\Entity\TradeLead;
  40. use Symfony\Contracts\Translation\TranslatorInterface;
  42. class KnowledgeBaseController extends DefaultController
  43. {
  44.     protected KernelInterface $appKernel;
  45.     protected ManagerRegistry $doctrine;
  46.     protected TranslatorInterface $translator;
  47.     public function __construct(KernelInterface $appKernel,
  48.                                 ManagerRegistry $doctrine,
  49.                                 TranslatorInterface $translator)
  50.     {
  51.         $this->appKernel = $appKernel;
  52.         $this->doctrine = $doctrine;
  53.         $this->translator = $translator;
  54.     }
  56.     /**
  57.      * @Route("/knowledgebase", name="knowledgebase")
  58.      */
  59.     public function indexAction(Request $request)
  60.     {
  62.         /* we load session data */
  63.         parent::init($request);
  64.         $session = $request->getSession();
  66.         /* we load entity managers */
  67.         $em = $this->doctrine->getManager();
  69.         /* we load list of modules for connector service */
  70.         $service = $em->getRepository(Service::class)->getService(2);
  72.         /* we get current user */
  73.         if (!empty($session->get('user'))) {
  74.             $currentUserId = $session->get('user')->getUserId();
  75.             $user = $em->getRepository(User::class)->getUser($currentUserId);
  76.             $userModuleList = $user->getModules();
  77.         } else {
  78.             $userModuleList = [];
  79.         }
  81.         /* we render data */
  82.         return $this->render('knowledgebase.html.twig',
  83.             array('headerData' => $this -> getPageHeader($request),
  84.                   'moduleList' => $service->getModules(),
  85.                   'userModuleList' => $userModuleList,
  86.                   'service' => $service,
  87.                 )
  88.         );        
  90.     }
  92.     /**
  93.      * @Route("/knowledgebaseAdmin", name="knowledgebaseAdmin")
  94.      */    
  95.     public function knowledgebaseAdminAction(Request $request)
  96.     {
  98.         /* we load session data */
  99.         parent::init($request);
  100.          
  101.         $session = $request->getSession();
  103.         /* we check if user is logged in */
  104.         if(empty($session->get('user'))) {
  105.             return $this->redirectToRoute('login');
  106.         }         
  107.         
  108.         /* we load entity managers */
  109.         $em = $this->doctrine->getManager();
  110.         $dem = $this->doctrine->getManager('dynamic_em');
  111.         
  112.         /* we get current user */
  113.         $currentUserId = $session->get('user')->getUserId();
  114.         $user = $em->getRepository(User::class)->getUser($currentUserId);
  115.         
  116.         /* we load service */
  117.         $service = $em->getRepository(Service::class)->getService(2);
  119.         //we check if user has UserStory module and get recent form responses
  120.         $module = $em->getRepository(Module::class)->getModule(24);
  121.         $isModule = $em->getRepository(User::class)->userHasModule($user, $module);
  122.         $taskList = null;
  123.         if($isModule) {
  124.             $dateStart = date("Y-m-d",strtotime('monday this week'));
  125.             $dateEnd = date("Y-m-d",strtotime('sunday this week'));
  126.             $taskList = $dem->getRepository(UserStory::class)->getUserStoryStartBetweenDatesList($dateStart, $dateEnd);
  127.         }
  129.         /* we render data */
  130.         return $this->render('knowledgebaseAdmin.html.twig',
  131.                 array(    'headerData' => $this -> getPageHeader($request),
  132.                         'moduleList' => $service->getModules(),
  133.                         'userModuleList' => $user->getModules(),
  134.                         'user' => $user,
  135.                         'menu' => $this -> adminMenu($request),
  136.                         'taskList' => $taskList,
  137.                         'mainMenu' => $this -> adminMainMenu($request)                    
  138.                 )
  139.                 );
  140.     
  141.     }
  142.     
  143.     /**
  144.      * @Route("/contactnew", name="contactNew")
  145.      */
  146.     public function contactNewAction(Request $request)
  147.     {
  149.         /* we load session data */
  150.         parent::init($request);
  151.     
  152.         $session = $request->getSession();
  153.     
  154.         $em = $this->doctrine->getManager();
  156.         /* we get current user */
  157.         $currentUserId = $session->get('user')->getUserId();
  158.         $user = $em->getRepository(User::class)->getUser($currentUserId);
  160.         $contact = new Contact();
  161.     
  162.         /* we build login form */
  163.         $formBuilder = $this->createFormBuilder($contact);
  164.     
  165.         $formBuilder->add('firstName', TextType::class, array(
  166.                 'required' => true,
  167.                 'label' => $this->translator->trans('knowledgebase.first_name'),
  168.                 'attr' => array('class' => 'text_form', 'size' => 22),
  169.                 'label_attr' => array('class' => 'form_field_label'),
  170.         ));
  171.         
  172.         $formBuilder->add('lastName', TextType::class, array(
  173.                 'required' => true,
  174.                 'label' => $this->translator->trans('knowledgebase.last_name'),
  175.                 'attr' => array('class' => 'text_form', 'size' => 22),
  176.                 'label_attr' => array('class' => 'form_field_label'),
  177.         )); 
  179.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  180.                 'attr' => array('class' => 'butt_big')));
  182.         $form = $formBuilder->getForm();
  183.         $form->handleRequest($request);
  184.     
  185.         if ($request->getMethod() == 'POST') {
  186.     
  187.             if ($form->isValid()) {
  188.                 // perform some action, such as save the object to the database
  189.     
  190.                 /* we load users entity manager */
  191.                 $dem = $this->doctrine->getManager('dynamic_em');
  192.                 $formData = $form->getData();
  194.                 print('<br>qqw saving data');
  195.                 \Doctrine\Common\Util\Debug::dump($formData);
  197.                 $address = new Address();
  198.                 $deliveryAddress = new Address();
  200.                 print('<br>qqw firstName form: '.$formData->getFirstName());
  201.                 print('<br>qqw firstName object: '.$contact->getFirstName());
  203.                 $contact->setFirstName($formData->getFirstName());
  204.                 $contact->setLastName($formData->getLastName());
  205.                 //$contact->setAddress($address);
  206.                 //$contact->setDeliveryAddress($deliveryAddress);
  208.                 /* we persist and save */
  209.                 //$dem->persist($address);
  210.                 //$dem->persist($deliveryAddress);
  211.                 $dem->persist($contact);
  212.                 $dem->flush();
  214.                 $this->addFlash('notice', $this->translator->trans('eshop.contact_created'));
  216.                 return $this->redirectToRoute('contactEdit', array('contactId' => $contact->getContactId()));
  217.     
  218.             }
  219.              
  220.         }
  221.     
  222.         /* we render data */
  223.         return $this->render('contactNew.html.twig',
  224.                 array(    'form' => $formBuilder->getForm()->createView(),
  225.                         'headerData' => $this -> getPageHeader($request),
  226.                         'menu' => $this -> adminMenu($request),
  227.                         'user' => $user,
  228.                         'mainMenu' => $this -> adminMainMenu($request)
  229.                 )
  230.                 );
  231.     
  232.     }
  233.     
  234.     /**
  235.      * @Route("/contacts", name="contacts")
  236.      */
  237.     public function contactsAction(Request $request)
  238.     {
  239.     
  240.         /* we load session data */
  241.         parent::init($request);
  242.         $session = $request->getSession();
  244.         /* we check if an user is logged in */
  245.         if(empty($session->get('user'))) {
  246.             return $this->redirectToRoute('login');
  247.         }          
  248.     
  249.         /* we load users entity manager */
  250.         $em = $this->doctrine->getManager();
  251.         $dem = $this->doctrine->getManager('dynamic_em');
  253.         /* removing contact */
  254.         if(!empty($request->query->get('removeContact'))) { 
  255.             //print('<br>qqw removing Contact 33: '.$request->query->get('removeContact'));   
  257.             try {
  258.                 $isRemovable = true;
  259.                 $resultMessage = '';
  260.                 $contactId = $request->query->get('removeContact');
  261.                 $contact = $dem->getRepository(Contact::class)->getContact($contactId);
  262.                 //$contact = $dem->getRepository(Contact::class)
  264.                 //removes contacts consents
  265.                 if (!empty($contact->getConsents())) {
  267.                     foreach ($contact->getConsents() as $consent) {
  268.                         //print('<hr>consent: ');  
  269.                         //\Doctrine\Common\Util\Debug::dump($consent);   
  271.                          $contact->removeConsent($consent);
  272.                          $dem->persist($contact);
  273.                          $dem->flush();
  274.                     }
  275.                 }
  277.                 //check orders
  278.                 $orderList = $dem->getRepository(Order::class)->getOrderListByCustomer($contact,'orderId','DESC');
  279.                 if (!empty($orderList)) {
  281.                     foreach ($orderList as $order) {
  282.                         //print('<hr>order: '.$order->getOrderId());  
  283.                         $resultMessage .= $order->getOrderId().', ';
  284.                         $isRemovable = false;
  285.                     }
  286.                 } 
  288.                 if ($isRemovable) {
  289.                     $contact = $dem->getRepository(Contact::class)->removeContact($request->query->get('removeContact'));
  291.                     $this->addFlash('notice', $this->translator->trans('eshop.contact_removed'));
  293.                 } else {
  294.                     $this->addFlash('error', 'Contact not removed. There are associated orders: '.$resultMessage);
  295.                 }
  296.                 
  297.             } catch(\Doctrine\DBAL\DBALException $e) {
  298.                 $this->addFlash('error', "This contact has connected services (orders etc.), so it can't be removed.");
  299.             }
  300.             
  301.         }
  303.         $userId = $session->get('user')->getUserId();
  304.         $user = $em->getRepository(User::class)->getUser($userId);
  306.         $contactList = $dem->getRepository(Contact::class)->getContactList();
  307.         $contactGroupList = $dem->getRepository(ContactGroup::class)->getContactGroupList();
  309.         /* we render data */
  310.         return $this->render('contacts.html.twig',
  311.                 array(    'headerData' => $this -> getPageHeader($request),
  312.                         'contactList' => $contactList,
  313.                         'contactGroupList' => $contactGroupList,
  314.                         'menu' => $this -> adminMenu($request),
  315.                         'user' => $user,
  316.                         'mainMenu' => $this -> adminMainMenu($request)
  317.                 )
  318.                 );
  319.     
  320.     }    
  322.     /**
  323.      * @Route("/contactedit/{contactId}", name="contactEdit")
  324.      */
  325.     public function contactEditAction(Request $request, $contactId)
  326.     {
  328.         /* we load session data */
  329.         parent::init($request);
  330.         $session = $request->getSession();
  332.         /* we check if an user is logged in */
  333.         if(empty($session->get('user'))) {
  334.             return $this->redirectToRoute('login');
  335.         }
  337.         /* we load entity managers */
  338.         $em = $this->doctrine->getManager();
  339.         $dem = $this->doctrine->getManager('dynamic_em');
  340.     
  341.         $userId = $session->get('user')->getUserId();
  342.         $user = $em->getRepository(User::class)->getUser($userId);
  344.         $contact = $dem->getRepository(Contact::class)->getContact($contactId);
  346.         //$contactExists = $em->getRepository(Contact::class)->findOneBy(['contactId' => $contactId]);
  348.            //->findOneBy(array('order_id' => $orderId));
  349.         //print('<hr>qqw x contact id 1: '.$contactId.': ');
  350.         //\Doctrine\Common\Util\Debug::dump($contact);
  352.          //print('<hr>qqw x contact id 2: '.$contactId.': ');
  353.          //\Doctrine\Common\Util\Debug::dump($contactExists);
  355.         /* we get collection of contact groups */
  356.         $contactGroupList = $dem->getRepository(ContactGroup::class)->getContactGroupList();
  357.         /* we get collection of consents */
  358.         $consents = $dem->getRepository(Consent::class)->getConsentList();
  360.         /* we build edit form */ 
  361.         $formBuilder = $this->createFormBuilder($contact);
  362.     
  363.         $formBuilder->add('firstName', TextType::class, array(
  364.                 'required' => false,
  365.                 'label' => $this->translator->trans('knowledgebase.first_name'),
  366.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getFirstName()),
  367.                 'label_attr' => array('class' => 'form_field_label')
  368.         ));
  369.         
  370.         $formBuilder->add('middleName', TextType::class, array(
  371.                 'required' => false,
  372.                 'label' => $this->translator->trans('knowledgebase.middle_name'),
  373.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getMiddleName()),
  374.                 'label_attr' => array('class' => 'form_field_label')
  375.         ));        
  376.         
  377.         $formBuilder->add('lastName', TextType::class, array(
  378.                 'required' => false,
  379.                 'label' => $this->translator->trans('knowledgebase.last_name'),
  380.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getLastName()),
  381.                 'label_attr' => array('class' => 'form_field_label')
  382.         ));        
  384.         $formBuilder->add('companyName', TextType::class, array(
  385.                 'required' => false,
  386.                 'label' => $this->translator->trans('knowledgebase.company_name'),
  387.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getCompanyName()),
  388.                 'label_attr' => array('class' => 'form_field_label')
  389.         ));         
  391.         $formBuilder->add('email', TextType::class, array(
  392.                 'required' => false,
  393.                 'label' => $this->translator->trans('knowledgebase.email'),
  394.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getEmail()),
  395.                 'label_attr' => array('class' => 'form_field_label')
  396.         ));           
  398.         $formBuilder->add('email2', TextType::class, array(
  399.                 'required' => false,
  400.                 'label' => $this->translator->trans('knowledgebase.email').' 2',
  401.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getEmail2()),
  402.                 'label_attr' => array('class' => 'form_field_label')
  403.         ));     
  405.         $formBuilder->add('email3', TextType::class, array(
  406.                 'required' => false,
  407.                 'label' => $this->translator->trans('knowledgebase.email').' 3',
  408.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getEmail3()),
  409.                 'label_attr' => array('class' => 'form_field_label')
  410.         ));     
  412.         $formBuilder->add('phone', TextType::class, array(
  413.                 'required' => false,
  414.                 'label' => $this->translator->trans('knowledgebase.phone'),
  415.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getPhone()),
  416.                 'label_attr' => array('class' => 'form_field_label')
  417.         ));   
  419.         $formBuilder->add('phone2', TextType::class, array(
  420.                 'required' => false,
  421.                 'label' => $this->translator->trans('knowledgebase.phone').' 2',
  422.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getPhone2()),
  423.                 'label_attr' => array('class' => 'form_field_label')
  424.         ));  
  426.         $formBuilder->add('phone3', TextType::class, array(
  427.                 'required' => false,
  428.                 'label' => $this->translator->trans('knowledgebase.phone').' 3',
  429.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getPhone3()),
  430.                 'label_attr' => array('class' => 'form_field_label')
  431.         ));    
  433.         /* we set addresses */
  434.         if(empty($contact->getAddress())) {
  435.             $address = new Address;
  436.             $contact->setAddress($address);
  437.         }
  438.         $formBuilder->add('addressStreet', TextType::class, array(
  439.                 'required' => false,
  440.                 'label' => $this->translator->trans('address.street'),
  441.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress()->getStreet()),
  442.                 'label_attr' => array('class' => 'form_field_label_top'),
  443.                 'mapped' => false
  444.         ));
  446.         $formBuilder->add('addressStreetNumber', TextType::class, array(
  447.                 'required' => false,
  448.                 'label' => $this->translator->trans('address.street_number'),
  449.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getAddress()->getStreetNumber()),
  450.                 'label_attr' => array('class' => 'form_field_label'),
  451.                 'mapped' => false
  452.         ));   
  454.         $formBuilder->add('addressZipCode', TextType::class, array(
  455.                 'required' => false,
  456.                 'label' => $this->translator->trans('address.zip_code'),
  457.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getAddress()->getZipCode()),
  458.                 'label_attr' => array('class' => 'form_field_label'),
  459.                 'mapped' => false
  460.         ));          
  462.         $formBuilder->add('addressCity', TextType::class, array(
  463.                 'required' => false,
  464.                 'label' => $this->translator->trans('address.city'),
  465.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress()->getCity()),
  466.                 'label_attr' => array('class' => 'form_field_label'),
  467.                 'mapped' => false
  468.         ));                      
  470.         $formBuilder->add('addressCountry', TextType::class, array(
  471.                 'required' => false,
  472.                 'label' => $this->translator->trans('address.country'),
  473.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress()->getCountry()),
  474.                 'label_attr' => array('class' => 'form_field_label_bottom'),
  475.                 'mapped' => false
  476.         ));                 
  478.         
  479.         /* we set delivery address */
  480.         if(empty($contact->getDeliveryAddress())) {
  481.             $deliveryAddress = new Address;
  482.             $contact->setDeliveryAddress($deliveryAddress);
  483.         }
  484.         $formBuilder->add('deliveryAddressStreet', TextType::class, array(
  485.                 'required' => false,
  486.                 'label' => $this->translator->trans('address.street_delivery'),
  487.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDeliveryAddress()->getStreet()),
  488.                 'label_attr' => array('class' => 'form_field_label'),
  489.                 'mapped' => false
  490.         ));
  492.         $formBuilder->add('deliveryAddressStreetNumber', TextType::class, array(
  493.                 'required' => false,
  494.                 'label' => $this->translator->trans('address.street_number_delivery'),
  495.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getDeliveryAddress()->getStreetNumber()),
  496.                 'label_attr' => array('class' => 'form_field_label'),
  497.                 'mapped' => false
  498.         ));   
  500.         $formBuilder->add('deliveryAddressZipCode', TextType::class, array(
  501.                 'required' => false,
  502.                 'label' => $this->translator->trans('address.zip_code_delivery'),
  503.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getDeliveryAddress()->getZipCode()),
  504.                 'label_attr' => array('class' => 'form_field_label'),
  505.                 'mapped' => false
  506.         ));          
  508.         $formBuilder->add('deliveryAddressCity', TextType::class, array(
  509.                 'required' => false,
  510.                 'label' => $this->translator->trans('address.city_delivery'),
  511.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDeliveryAddress()->getCity()),
  512.                 'label_attr' => array('class' => 'form_field_label'),
  513.                 'mapped' => false
  514.         ));                      
  516.         $formBuilder->add('deliveryAddressCountry', TextType::class, array(
  517.                 'required' => false,
  518.                 'label' => $this->translator->trans('address.country_delivery'),
  519.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDeliveryAddress()->getCountry()),
  520.                 'label_attr' => array('class' => 'form_field_label_bottom'),
  521.                 'mapped' => false
  522.         ));         
  525.         /*  
  526.         $formBuilder->add('address', TextType::class, array(
  527.                 'required' => false,
  528.                 'label' => $this->translator->trans('user.address').' 1',
  529.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress1()),
  530.                 'label_attr' => array('class' => 'form_field_label')
  531.         ));   
  533.         $formBuilder->add('address2', TextType::class, array(
  534.                 'required' => false,
  535.                 'label' => $this->translator->trans('user.address').' 2',
  536.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress2()),
  537.                 'label_attr' => array('class' => 'form_field_label')
  538.         )); 
  540.         $formBuilder->add('invoiceAddress', TextType::class, array(
  541.                 'required' => false,
  542.                 'label' => $this->translator->trans('module.invoice_address').' 1',
  543.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getInvoiceAddress1()),
  544.                 'label_attr' => array('class' => 'form_field_label')
  545.         ));   
  547.         $formBuilder->add('invoiceAddress2', TextType::class, array(
  548.                 'required' => false,
  549.                 'label' => $this->translator->trans('module.invoice_address').' 2',
  550.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getInvoiceAddress2()),
  551.                 'label_attr' => array('class' => 'form_field_label')
  552.         )); 
  553.         */  
  555.         $formBuilder->add('businessId', TextType::class, array(
  556.                 'required' => false,
  557.                 'label' => $this->translator->trans('user.business_number'),
  558.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getBusinessId()),
  559.                 'label_attr' => array('class' => 'form_field_label')
  560.         ));   
  562.         $formBuilder->add('DICId', TextType::class, array(
  563.                 'required' => false,
  564.                 'label' => $this->translator->trans('user.DIC_number'),
  565.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDICId()),
  566.                 'label_attr' => array('class' => 'form_field_label')
  567.         ));    
  569.         $formBuilder->add('ERPKey', TextType::class, array(
  570.                 'required' => false,
  571.                 'label' => $this->translator->trans('system.erp_key'),
  572.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getERPKey()),
  573.                 'label_attr' => array('class' => 'form_field_label')
  574.         ));        
  576.         $formBuilder->add('notes', TextareaType::class, array(
  577.                 'required' => false,
  578.                 'label' => $this->translator->trans('system.notes'),
  579.                 'attr' => array('class' => 'textarea_form', 'cols' => 55, 'rows' => 4, 'value' => $contact->getNotes()),
  580.                 'label_attr' => array('class' => 'form_textarea_label'),
  581.                 'data' => $contact->getNotes(),
  582.         ));                
  584.         $formBuilder->add('contactUserName', TextType::class, array(
  585.                 'required' => false,
  586.                 'label' => $this->translator->trans('knowledgebase.user_name'),
  587.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getContactUserName()),
  588.                 'label_attr' => array('class' => 'form_field_label')
  589.         ));    
  590.         
  591.         $formBuilder->add('contactUserPassword', TextType::class, array(
  592.                 'required' => false,
  593.                 'label' => $this->translator->trans('knowledgebase.password'),
  594.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getContactUserPassword()),
  595.                 'label_attr' => array('class' => 'form_field_label')
  596.         ));   
  598.         /* we add all contact groups */
  599.         $contactGroups = array();
  600.         foreach($contactGroupList as $contactGroup)
  601.         {
  602.             $contactGroups[$contactGroup->getContactGroupName()] = $contactGroup->getContactGroupId();
  603.         }
  605. //        print('<br>All ContactGroups: ');
  606. //        print_r($contactGroups);
  608.         $selectedContactGroups = array();
  610. //        print('<br>------------------- ContactGroups 0: ');
  611. //        \Doctrine\Common\Util\Debug::dump($contact->getContactGroups());
  613.         if (!empty($contact->getContactGroups())) {
  614.             foreach($contact->getContactGroups() as $contactGroup) {
  616.               if(!empty($contactGroup)) {
  617.                 $selectedContactGroups[] = $contactGroup->getContactGroupId();
  618.               }
  619.             }
  620.         }
  622. //        print('<br>ContactGroups: ');
  623. //        \Doctrine\Common\Util\Debug::dump($contact->getContactGroups());
  624.         //print_r($contact->getContactGroups());
  626.         $formBuilder->add('contactGroups', ChoiceType::class, array(
  627.                 'choices' => $contactGroups,
  628.                 'required' => false,
  629.                 'mapped' => false,
  630.                 'multiple' => true,
  631.                 'expanded' => true,
  632.                 'label_attr' => array('class' => 'form_field_label'),
  633.                 'attr' => array('class' => 'form_field_text'),
  634.                 'data' => $selectedContactGroups
  635.         ));  
  637.         /* we add all consents */
  638.         $consentList = array();
  640.         foreach($consents as $consent)
  641.         {
  643.             $consent->setLocale($session->get('lang')->getLangKey());
  644.             $dem->refresh($consent);  
  646.             $consentList[$consent->getConsentName()] = $consent->getConsentId();
  647.         }
  649. //        print('<br>------------------- all consents: ');
  650. //        \Doctrine\Common\Util\Debug::dump($consentList);
  652.         $selectedConsents = array();
  653.         if (!empty($contact->getConsents())) {
  654.             foreach ($contact->getConsents() as $consent) {
  655.                 if (!empty($consent)) {
  656.                     $selectedConsents[] = $consent->getConsentId();
  657.                 }
  658.             }
  659.         }
  661.         $formBuilder->add('consents', ChoiceType::class, array(
  662.                 'choices' => $consentList,
  663.                 'required' => false,
  664.                 'mapped' => false,
  665.                 'multiple' => true,
  666.                 'expanded' => true,
  667.                 'label_attr' => array('class' => 'form_field_label'),
  668.                 'attr' => array('class' => 'form_field_text'),
  669.                 'data' => $selectedConsents
  670.         ));   
  672.         //isModule Price Levels
  673.         $module = $em->getRepository(Module::class)->getModule(22);
  674.         $isPriceLevelModule = $em->getRepository(User::class)->userHasModule($user, $module);
  675.         $consentList = null;
  676.         if($isPriceLevelModule) {
  677.             //print('<br>qqw is module Price Levels');
  679.             $priceLevels = $dem->getRepository(PriceLevel::class)->getPriceLevelList();
  681.             /* we add all price levels */
  682.             $priceLevelList = array();
  683.             foreach($priceLevels as $priceLevel)
  684.             {
  685.                 $priceLevel->setLocale($session->get('lang')->getLangKey());
  686.                 $dem->refresh($priceLevel); 
  687.                 
  688.                 $priceLevelList[$priceLevel->getPriceLevelName()] = $priceLevel->getPriceLevelId();
  689.             }
  691.             $selectedPriceLevels = array();
  692.             $selectedPriceLevel = 1;
  693.             if(!empty($contact->getPriceLevel())) {
  695. //                print('<br>contactPriceLevel: ');
  696. //                \Doctrine\Common\Util\Debug::dump($contact->getPriceLevel());
  697.                 //print_r($contact->getPriceLevel());
  699.               //$selectedPriceLevels[] = $contact->getPriceLevel()->getPriceLevelId();
  700.               $selectedPriceLevel = $contact->getPriceLevel()->getPriceLevelId();
  701.             }
  703.             $formBuilder->add('priceLevel', ChoiceType::class, array(
  704.                     'choices' => $priceLevelList,
  705.                     'required' => false,
  706.                     'mapped' => false,
  707.                     'multiple' => false,
  708.                     'expanded' => true,
  709.                     'label_attr' => array('class' => 'form_field_label'),
  710.                     'attr' => array('class' => 'form_field_text'),
  711.                     'data' => $selectedPriceLevel
  712.             ));              
  714.         }               
  716.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  717.                 'attr' => array('class' => 'butt_big')));
  718.     
  719.         $form = $formBuilder->getForm();
  720.         $form->handleRequest($request);
  721.     
  722.         if ($request->getMethod() == 'POST') {
  724.             if ($form->isValid()) {
  725.                 // perform some action, such as save the object to the database
  726.                 //print('<br>qqw post form 2: ');
  727.                 $formData = $form->getData();
  728.     
  729.                 /* we load data from form into contact object */
  730.                 $contact->setFirstName($formData->getFirstName());
  731.                 $contact->setMiddleName($formData->getMiddleName());
  732.                 $contact->setLastName($formData->getLastName());
  733.                 $contact->setCompanyName($formData->getCompanyName());
  735.                 $contact->setEmail($formData->getEmail());
  736.                 $contact->setEmail2($formData->getEmail2());
  737.                 $contact->setEmail3($formData->getEmail3());
  739.                 $contact->setPhone($formData->getPhone());
  740.                 $contact->setPhone2($formData->getPhone2());
  741.                 $contact->setPhone3($formData->getPhone3());
  743.                 $address = $contact->getAddress();
  744.                 $address->setStreet($form['addressStreet']->getData());
  745.                 $address->setStreetNumber($form['addressStreetNumber']->getData());
  746.                 $address->setCity($form['addressCity']->getData());
  747.                 $address->setZipCode($form['addressZipCode']->getData());
  748.                 $address->setCountry($form['addressCountry']->getData());
  749.                 //$contact->setAddress($address);
  751.                 $deliveryAddress = $contact->getDeliveryAddress();
  752.                 $deliveryAddress->setStreet($form['deliveryAddressStreet']->getData());
  753.                 $deliveryAddress->setStreetNumber($form['deliveryAddressStreetNumber']->getData());
  754.                 $deliveryAddress->setCity($form['deliveryAddressCity']->getData());
  755.                 $deliveryAddress->setZipCode($form['deliveryAddressZipCode']->getData());
  756.                 $deliveryAddress->setCountry($form['deliveryAddressCountry']->getData());
  757.                 //$contact->setDeliveryAddress($deliveryAddress);
  759.                 $contact->setBusinessId($formData->getBusinessId());
  760.                 $contact->setDICId($formData->getDICId());
  762.                 $contact->setNotes($formData->getNotes());
  764.                 $contact->setContactUserName($formData->getContactUserName());
  765.                 // if the password is md5 hash already we do not hash
  766.                 $cuPsw = $formData->getContactUserPassword();
  767.                 if(strlen($cuPsw) == 32 && ctype_xdigit($cuPsw)) {
  768.                     $password = $cuPsw;
  769.                 } else {
  770.                     $password = md5($cuPsw);
  771.                 }
  772.                 $contact->setContactUserPassword($password);
  774.                 // we remove old contact groups
  775.                 if(!empty($contact->getContactGroups())) {
  776.                     foreach ($contact->getContactGroups() as $group) {
  777.                         print('<br>Group: ');
  778.                         $contact->removeContactGroup($group);
  779.                         //$dem->refresh($product);
  780.                         //$dem->persist($cat);
  781.                     }
  782.                 }
  784.                 // we save contact groups
  785.                 $formContactGroups = $form['contactGroups']->getData();
  786.                 if(is_array($formContactGroups)) {
  787.                     foreach($formContactGroups as $contactGroupId) {
  789.                         //print('');
  790.                         $group = $dem->getRepository(ContactGroup::class)->getContactGroup($contactGroupId);
  792.                         $contact->addContactGroup($group);
  794.                     }
  795.                 }
  797.                 // we save selected price level
  798.                 if($isPriceLevelModule && !empty($form['priceLevel']->getData())) {
  800.                     print('<br>PLId : '.$form['priceLevel']->getData());
  802.                     $priceLevel = $dem->getRepository(PriceLevel::class)->getPriceLevel($form['priceLevel']->getData());
  803.                     $contact->setPriceLevel($priceLevel);
  805.                     //print('<br>QQW selected price level: ');
  806.                     //\Doctrine\Common\Util\Debug::dump($priceLevel);
  808.                 }
  810.                 // we remove old consents
  811.                 if(!empty($contact->getConsents())) {
  812.                     foreach ($contact->getConsents() as $consent) {
  813.                         print('<br>Consent: ');
  814.                         $contact->removeConsent($consent);
  815.                     }
  816.                 }
  818.                 // we save consents
  819.                 $formConsents = $form['consents']->getData();
  820.                 if(is_array($formConsents)) {
  821.                     foreach($formConsents as $consentId) {
  823.                         $consent = $dem->getRepository(Consent::class)->getConsent($consentId);
  824.                         $contact->addConsent($consent);
  826.                     }
  827.                 }
  829.                 /* we persist and save */
  830.                 $em->persist($contact);
  831.                 $dem->flush();
  833.                 $this->addFlash('notice', $this->translator->trans('eshop.contact_updated'));
  835.                 return $this->redirectToRoute('contactEdit', array('contactId' => $contact->getContactId()));
  836.     
  837.             }
  838.     
  839.         }
  840.     
  841.         /* we render data */
  842.         return $this->render('contactEdit.html.twig',
  843.                 array(  'headerData' => $this -> getPageHeader($request),
  844.                         'form' => $formBuilder->getForm()->createView(),
  845.                         'user' => $user,
  846.                         'contact' => $contact,
  847.                         'menu' => $this -> adminMenu($request),
  848.                         'mainMenu' => $this -> adminMainMenu($request)
  849.                 )
  850.                 );
  851.     
  852.     }   
  854.          /**
  855.      * @Route("/contactGroupNew", name="contactGroupNew")
  856.      */
  857.     public function contactGroupNewAction(Request $request)
  858.     {
  860.         /* we load session data */
  861.         parent::init($request);
  862.          
  863.         $session = $request->getSession();
  865.         $em = $this->doctrine->getManager();
  867.         $userId = $session->get('user')->getUserId();
  868.         $user = $em->getRepository(User::class)->getUser($userId);
  870.         $contactGroup = new ContactGroup();
  872.         /* we build login form */
  873.         $formBuilder = $this->createFormBuilder($contactGroup);
  874.         
  875.         $formBuilder->add('contactGroupName', TextType::class, array(
  876.                 'required' => true,
  877.                 'label' => $this->translator->trans('knowledgebase.contact_group_name'),
  878.                 'attr' => array('class' => 'text_form', 'size' => 22),
  879.                 'label_attr' => array('class' => 'form_field_label'),
  880.         ));     
  881.     
  882.         //form.button.save
  883.         
  884.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  885.                 'attr' => array('class' => 'butt_big')));
  886.         
  887.         $form = $formBuilder->getForm();        
  888.         $form->handleRequest($request);
  889.         
  890.         if ($request->getMethod() == 'POST') {
  892.             if ($form->isValid()) {
  893.                 // perform some action, such as save the object to the database
  894.         
  895.                 /* we load users entity manager */
  896.                 $dem = $this->doctrine->getManager('dynamic_em');
  897.                 $formData = $form->getData();
  899.                 $contactGroup = new ContactGroup;
  900.                 $contactGroup->setContactGroupName($formData->getContactGroupName());
  901.                 
  902.                 /* we persist and save */
  903.                 $dem->persist($contactGroup);
  904.                 $dem->flush();
  905.                 
  906.                 $this->addFlash('notice', 'New contact group was created.');
  907.                 
  908.                 return $this->redirectToRoute('contactGroupEdit', array('contactGroupId' => $contactGroup->getContactGroupId()));
  909.         
  910.             }
  911.         
  912.         }
  913.     
  914.         /* we render data */
  915.         return $this->render('contactGroupNew.html.twig',
  916.                 array(  'form' => $formBuilder->getForm()->createView(),
  917.                         'headerData' => $this -> getPageHeader($request),
  918.                         'menu' => $this -> adminMenu($request),
  919.                         'user' => $user,
  920.                         'mainMenu' => $this -> adminMainMenu($request)
  921.                 )
  922.                 );
  923.     
  924.     }  
  926.     /**
  927.      * @Route("/contactGroupEdit/{contactGroupId}", name="contactGroupEdit")
  928.      */
  929.     public function contactGroupEditAction(Request $request, $contactGroupId)
  930.     {
  932.         /* we load session data */
  933.         parent::init($request);
  934.         $session = $request->getSession();
  935.         
  936.         /* we load entity managers */
  937.         $em = $this->doctrine->getManager();
  938.         $dem = $this->doctrine->getManager('dynamic_em');
  939.          
  940.         /* we get user */ 
  941.         $userId = $session->get('user')->getUserId();
  942.         $user = $em->getRepository(User::class)->getUser($userId);
  943.         
  944.         /* we get current e-shop */
  945.         $eshop = $em->getRepository(Eshop::class)->getCurrentEshop($userId);
  946.  
  947.         /* we get product parameter group */
  948.         $contactGroup = $dem->getRepository(ContactGroup::class)->getContactGroup($contactGroupId);
  950.         $userDirs = $this->getUserFolderPaths($request);
  951.         
  952.         /*
  953.         print('<br>QQW categoryCollection: ');
  954.         \Doctrine\Common\Util\Debug::dump($categoryCollection);
  955.         */
  956.           
  957.         /* we build edit form */
  958.         $formBuilder = $this->createFormBuilder($contactGroup);
  960.         $formBuilder->add('contactGroupName', TextType::class, array(
  961.                 'required' => true,
  962.                 'label' => $this->translator->trans('knowledgebase.contact_group_name'),
  963.                 'attr' => array('class' => 'text_form', 'size' => 22, 'value' => $contactGroup->getContactGroupName()),
  964.                 'label_attr' => array('class' => 'form_field_label'),
  965.         ));         
  966.        
  967.          $formBuilder->add('contactGroupBoard', TextareaType::class, array(
  968.                 'required' => false,
  969.                 'label' => $this->translator->trans('knowledgebase.contact_group_board'),
  970.                 'attr' => array('class' => 'textarea_form', 'cols' => 77, 'rows' => 7, 'value' => $contactGroup->getContactGroupBoard()),
  971.                 'label_attr' => array('class' => 'form_field_label'),
  972.                 'data' => $contactGroup->getContactGroupBoard(),
  973.         )); 
  975.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  976.                 'attr' => array('class' => 'butt_big')));
  977.          
  978.         $form = $formBuilder->getForm();
  979.          
  980.         $form->handleRequest($request);
  981.          
  982.         if ($request->getMethod() == 'POST') {
  983.              
  984.             //$form->bindRequest($request);
  985.              
  986.             if ($form->isValid()) {
  987.                 // perform some action, such as save the object to the database
  989.                 $formData = $form->getData();
  990.         
  991.                 $contactGroup->setContactGroupName($formData->getContactGroupName());
  992.                 $contactGroup->setContactGroupBoard($formData->getContactGroupBoard());
  994.                 /* we persist and save */
  995.                 $dem->persist($contactGroup);
  996.                 $dem->flush();
  998.                 $this->addFlash('notice', 'Contact group was updated.');
  1000.                 return $this->redirectToRoute('contactGroupEdit', array('contactGroupId' => $contactGroup->getContactGroupId()));
  1001.                  
  1002.             }
  1003.              
  1004.         }
  1006.         /* we render data */
  1007.         return $this->render('contactGroupEdit.html.twig',
  1008.             array('headerData' => $this -> getPageHeader($request),
  1009.                   'form' => $formBuilder->getForm()->createView(),
  1010.                   'contactGroup' => $contactGroup,
  1011.                   'userDirs' => $userDirs,
  1012.                   'menu' => $this -> adminMenu($request),
  1013.                   'user' => $user,
  1014.                   'mainMenu' => $this -> adminMainMenu($request)
  1015.                 )
  1016.         );        
  1018.     }
  1020.     /**
  1021.      * @Route("/contactGroupRemove/{contactGroupId}", name="contactGroupRemove")
  1022.      */
  1023.     public function contactGroupRemoveAction(Request $request, $contactGroupId)
  1024.     {
  1026.         /* we load session data */
  1027.         parent::init($request);
  1028.         $session = $request->getSession();
  1029.         
  1030.         /* we load entity managers */
  1031.         $em = $this->doctrine->getManager();
  1032.         $dem = $this->doctrine->getManager('dynamic_em');
  1033.          
  1034.         /* we get user */ 
  1035.         $userId = $session->get('user')->getUserId();
  1036.         $user = $em->getRepository(User::class)->getUser($userId);
  1037.         
  1038.         /* we get current e-shop */
  1039.         $eshop = $em->getRepository(Eshop::class)->getCurrentEshop($userId);
  1040.  
  1041.         /* we get product parameter group */
  1042.         $contactGroup = $dem->getRepository(ContactGroup::class)->getContactGroup($contactGroupId);
  1044.         //we remove association from contacts
  1045.         $contactList = $dem->getRepository(Contact::class)->getContactList();
  1047.         foreach($contactList as $contact) {
  1048.             
  1049.             $contactGroupList = $contact->getContactGroups();
  1050.             foreach($contactGroupList as $group) {
  1051.                 if ($group->getContactGroupId() == $contactGroupId) {
  1052.                     
  1053.                     //print('<br>contact: '.$contact->getContactId());
  1054.                     $contact->removeContactGroup($group);
  1056.                 }
  1057.             }
  1059.         }
  1061.         //we remove ContactGroup object
  1062.         $dem->remove($contactGroup);
  1063.         $dem->flush();   
  1065.         $this->addFlash('notice', 'Contact group was removed.');
  1067.         return $this->redirectToRoute('contacts');
  1069.     }
  1070.     
  1071.     /**
  1072.      * @Route("/lists", name="lists")
  1073.      */
  1074.     public function listsAction(Request $request)
  1075.     {
  1077.         /* we load session data */
  1078.         parent::init($request);
  1079.         $session = $request->getSession();
  1081.         // we check if any user is logged in
  1082.         if(!$this->isLoggedUser($request)) {
  1083.             return $this->redirectToRoute('login');
  1084.         } 
  1086.         /* we load entity managers */
  1087.         $em = $this->doctrine->getManager();
  1088.         $dem = $this->doctrine->getManager('dynamic_em');
  1090.         /* we get user */
  1091.         $userId = $session->get('user')->getUserId();
  1092.         $user = $em->getRepository(User::class)->getUser($userId);
  1094.         /* we check if user is logged in */
  1095.         if(empty($session->get('user'))) {
  1096.             return $this->redirectToRoute('login');
  1097.         }          
  1099.         /* we get file name and paths */
  1100.         $userDirs = $this->getUserFolderPaths($request);        
  1101.     
  1102.         $customLists = $dem->getRepository(CustomList::class)->getCustomLists();
  1104.         /* we build search form */
  1105.         $formBuilder = $this->createFormBuilder();
  1107.         $searchString = null;
  1108.         $searchResult = null;
  1109.     
  1110.         $formBuilder->add('searchString', TextType::class, array(
  1111.                 'required' => true,
  1112.                 'label' => ' ',
  1113.                 'attr' => array('class' => 'text_form', 'size' => 22),
  1114.                 'label_attr' => array('class' => 'form_field_label22'),
  1115.         ));
  1117.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('system.search'),
  1118.                 'attr' => array('class' => 'inlineButton')));
  1119.     
  1120.         $form = $formBuilder->getForm();
  1121.         $form->handleRequest($request);
  1122.     
  1123.         if ($request->getMethod() == 'POST') {
  1124.     
  1125.             if ($form->isValid()) {
  1127.                 $searchString = $request->request->get('form')['searchString'];
  1128.                 $searchResult['listItems'] = $dem->getRepository(CustomListItem::class)->getCustomListItemBySearch(trim($searchString));
  1129.     
  1130.                 $this->addFlash('notice', 'Searched string:'.$searchString);
  1132.             }
  1133.              
  1134.         }
  1136.         /* we render data */
  1137.         return $this->render('lists.html.twig',
  1138.                 array(    'form' => $formBuilder->getForm()->createView(),
  1139.                         'headerData' => $this -> getPageHeader($request),
  1140.                         'customLists' => $customLists,
  1141.                         'menu' => $this -> adminMenu($request),
  1142.                         'userDirs' => $userDirs,
  1143.                         'searchResult' => $searchResult,    
  1144.                         'searchString' => $searchString,
  1145.                         'user' => $user,
  1146.                         'mainMenu' => $this -> adminMainMenu($request)
  1147.                 )
  1148.                 );
  1149.     
  1150.     }    
  1151.     
  1152.    /**
  1153.      * @Route("/listnew", name="listNew")
  1154.      */
  1155.     public function listNewAction(Request $request)
  1156.     {
  1158.         /* we load session data */
  1159.         parent::init($request);
  1160.     
  1161.         $session = $request->getSession();
  1162.     
  1163.         $em = $this->doctrine->getManager();
  1165.         /* we get user */
  1166.         $userId = $session->get('user')->getUserId();
  1167.         $user = $em->getRepository(User::class)->getUser($userId);
  1168.     
  1169.         /* we build login form */
  1170.         $list = new CustomList();
  1171.         $formBuilder = $this->createFormBuilder($list);
  1173.         $formBuilder->add('listName', TextType::class, array(
  1174.                 'required' => true,
  1175.                 'label' => $this->translator->trans('knowledgebase.list_name'),
  1176.                 'attr' => array('class' => 'text_form', 'size' => 22),
  1177.                 'label_attr' => array('class' => 'form_field_label'),
  1178.         ));
  1180.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  1181.                 'attr' => array('class' => 'butt_big')));
  1182.     
  1183.         $form = $formBuilder->getForm();
  1184.         $form->handleRequest($request);
  1185.     
  1186.         if ($request->getMethod() == 'POST') {
  1187.     
  1188.             if ($form->isValid()) {
  1189.                 // perform some action, such as save the object to the database
  1191.                 /* we load users entity manager */
  1192.                 $dem = $this->doctrine->getManager('dynamic_em');
  1193.                 $formData = $form->getData();
  1195.                 print('<br>qqw saving data');
  1196.                 \Doctrine\Common\Util\Debug::dump($formData);
  1198.                 $list->setListName($formData->getListName());
  1200.                 /* we persist and save */
  1201.                 $dem->persist($list);
  1202.                 $dem->flush();
  1203.     
  1204.                 $this->addFlash('notice', 'New list was created.');
  1205.                  
  1206.                 return $this->redirectToRoute('listEdit', array('listId' => $list->getListId()));
  1207.     
  1208.             }
  1209.              
  1210.         }
  1211.     
  1212.         /* we render data */
  1213.         return $this->render('listNew.html.twig',
  1214.                 array(    'form' => $formBuilder->getForm()->createView(),
  1215.                         'headerData' => $this -> getPageHeader($request),
  1216.                         'menu' => $this -> adminMenu($request),
  1217.                         'user' => $user,
  1218.                         'mainMenu' => $this -> adminMainMenu($request)
  1219.                 )
  1220.                 );
  1221.     
  1222.     }       
  1223.     
  1225.     /**
  1226.      * @Route("/listedit/{listId}", name="listEdit")
  1227.      */
  1228.     public function listEditAction(Request $request, $listId)
  1229.     {
  1231.         /* we load session data */
  1232.         parent::init($request);
  1233.         $session = $request->getSession();
  1235.         // we check if any user is logged in
  1236.         if(!$this->isLoggedUser($request)) {
  1237.             return $this->redirectToRoute('login');
  1238.         }   
  1239.     
  1240.         /* we load users entity manager */
  1241.         $em = $this->doctrine->getManager();
  1242.         $dem = $this->doctrine->getManager('dynamic_em');
  1243.     
  1244.         $userId = $session->get('user')->getUserId();
  1245.         $user = $em->getRepository(User::class)->getUser($userId);
  1247.         /* removing list item */
  1248.         if(!empty($request->query->get('removeListItem'))) {
  1249.             $listItem = $dem->getRepository(CustomListItem::class)->removeCustomListItem($request->query->get('removeListItem'));
  1250.             $this->addFlash('notice', 'List item was removed.');
  1251.         }  
  1253.         if(!empty($request->query->get('saveXml'))) {  
  1254.             //print('<br>qqw saving xml');
  1256.             $this->saveListXML($request, $listId);
  1257.             $this->addFlash('notice', 'List was exported to XML.');
  1258.         }      
  1259.     
  1260.         $list = $dem->getRepository(CustomList::class)->getCustomList($listId);
  1261.         $listItems = $dem->getRepository(CustomListItem::class)->getCustomListItems($listId);
  1263.         /* we get file name and paths */
  1264.         $userDirs = $this->getUserFolderPaths($request);
  1266.         /*
  1267.         print('<br>QQW list ID: '.$listId);
  1268.         \Doctrine\Common\Util\Debug::dump($list);
  1269.         */
  1270.     
  1271.         /* we build form for new items */
  1272.         $listItem = new CustomListItem();
  1273.         $formNewItemsBuilder = $this->createFormBuilder($listItem);
  1275.         $formNewItemsBuilder->add('listItemName', TextType::class, array(
  1276.                 'required' => true,
  1277.                 'label' => $this->translator->trans('knowledgebase.new_list_item'),
  1278.                 'attr' => array('class' => 'text_form_file2', 'size' => 35, 'value' => ''),
  1279.                 'label_attr' => array('class' => 'form_field_label'),
  1280.         )); 
  1282.         $formNewItemsBuilder->add('listItemShortDescription', TextType::class, array(
  1283.                 'required' => false,
  1284.                 'label' => $this->translator->trans('knowledgebase.list_short_description'),
  1285.                 'attr' => array('class' => 'text_form_file2', 'size' => 35, 'value' => ''),
  1286.                 'label_attr' => array('class' => 'form_field_label'),
  1287.         ));   
  1289.         $formNewItemsBuilder->add('listItemLongDescription', TextareaType::class, array(
  1290.                 'required' => false,
  1291.                 'label' => $this->translator->trans('knowledgebase.list_item_long_description'),
  1292.                 'attr' => array('class' => 'textarea_form', 'cols' => 50, 'rows' => 3, 'value' => ''),
  1293.                 'label_attr' => array('class' => 'form_textarea_label'),
  1294.         ));         
  1296.         $formNewItemsBuilder->add('clickURL', TextType::class, array(
  1297.                 'required' => false,
  1298.                 'label' => $this->translator->trans('system.link_url'),
  1299.                 'attr' => array('class' => 'text_form_file2', 'size' => 35, 'value' => ''),
  1300.                 'label_attr' => array('class' => 'form_field_label'),
  1301.         ));               
  1303.         $formNewItemsBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('knowledgebase.create_list_item'),
  1304.                 'attr' => array('class' => 'butt_big')));  
  1306.         /* we build edit form */
  1307.         $formBuilder = $this->createFormBuilder($list);
  1308.     
  1309.         $formBuilder->add('listName', TextType::class, array(
  1310.                 'required' => false,
  1311.                 'label' => $this->translator->trans('knowledgebase.list_name'),
  1312.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $list->getListName()),
  1313.                 'label_attr' => array('class' => 'form_field_label')
  1314.         ));
  1316.         $formBuilder->add('linkURL', TextType::class, array(
  1317.                 'required' => false,
  1318.                 'label' => $this->translator->trans('system.link_url'),
  1319.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $list->getLinkURL()),
  1320.                 'label_attr' => array('class' => 'form_field_label')
  1321.         ));   
  1323.         $formBuilder->add('xmlFile', TextType::class, array(
  1324.                 'required' => false,
  1325.                 'label' => $this->translator->trans('system.xml_file'),
  1326.                 'attr' => array('class' => 'text_form', 'size' => 25, 'value' => $list->getXmlFile()),
  1327.                 'label_attr' => array('class' => 'form_field_label')
  1328.         ));  
  1330.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  1331.                 'attr' => array('class' => 'butt_big')));
  1334.         if ($request->getMethod() == 'POST') {
  1336.             $formNewItems = $formNewItemsBuilder->getForm();
  1337.             $formNewItems->handleRequest($request);
  1339.             if ($formNewItems->isValid()) {
  1341.                 $formNewItemsData = $formNewItems->getData();
  1342.                 
  1343.                 /* we load users entity manager */
  1344.                 //$dem = $this->doctrine->getManager('dynamic_em');
  1345.                 $listItem->setListItemName($formNewItemsData->getListItemName());
  1346.                 $listItem->setListItemShortDescription($formNewItemsData->getListItemShortDescription());
  1347.                 $listItem->setListItemLongDescription($formNewItemsData->getListItemLongDescription());
  1348.                 $listItem->setClickURL($formNewItemsData->getClickURL());
  1349.                 $listItem->setListId($listId);
  1351.                 /* we persist and save */
  1352.                 $dem->persist($listItem);
  1353.                 $dem->flush();
  1355.                 $this->addFlash('notice', 'New Item was Created');
  1356.                 
  1357.                 return $this->redirectToRoute('listEdit', array('listId' => $listId));               
  1358.                 
  1359.             }
  1361.             $form = $formBuilder->getForm();
  1362.             $form->handleRequest($request);
  1364.             if ($form->isValid()) {
  1366.                 $formData = $form->getData();
  1367.     
  1368.                 /* we load data from form into contact object */
  1369.                 $list->setListName($formData->getListName());
  1370.                 $list->setXmlFile($formData->getXmlFile());
  1371.                 $list->setLinkURL($formData->getLinkURL());
  1373.                 /* we persist and save */
  1374.                 //$em->persist($contact);
  1375.                 $dem->flush();
  1376.     
  1377.                 $this->addFlash('notice', 'List was updated.');
  1378.     
  1379.                 return $this->redirectToRoute('listEdit', array('listId' => $list->getListId()));
  1380.     
  1381.             }
  1382.     
  1383.         }
  1384.     
  1385.         /* we render data */
  1386.         return $this->render('listEdit.html.twig',
  1387.                 array(  'headerData' => $this -> getPageHeader($request),
  1388.                         'formNewItems' => $formNewItemsBuilder->getForm()->createView(),
  1389.                         'form' => $formBuilder->getForm()->createView(),
  1390.                         'list' => $list,
  1391.                         'listItems' => $listItems,
  1392.                         'userDirs' => $userDirs,
  1393.                         'user' => $user,
  1394.                         'menu' => $this -> adminMenu($request),
  1395.                         'mainMenu' => $this -> adminMainMenu($request)
  1396.                 )
  1397.                 );
  1398.     
  1399.     }      
  1402.     public function saveListXML(Request $request, $listId)
  1403.     { 
  1405.         /* we load session data */
  1406.         parent::init($request);
  1407.         $session = $request->getSession();
  1408.     
  1409.         /* we load users entity manager */
  1410.         $dem = $this->doctrine->getManager('dynamic_em');
  1411.     
  1412.         $userId = $session->get('user')->getUserId();
  1413.         //print('<br>user id: '.$userId);
  1415.         //die('<br>qqw 22 user id: ');          
  1416.     
  1417.         $list = $dem->getRepository(CustomList::class)->getCustomList($listId);
  1418.         $listItems = $dem->getRepository(CustomListItem::class)->getCustomListItems($listId);
  1420.         if(!$this->isUserFolder($request)) {
  1421.             $this->createUserFolder($request);
  1422.         }
  1424.         /* we get file name and paths */
  1425.         $userDirs = $this->getUserFolderPaths($request);
  1426.         if(!empty($list->getXmlFile())) {
  1427.             $fileName = $list->getXmlFile();
  1428.         } else {
  1429.             $fileName = "list_".$listId.".xml";
  1430.         }
  1432.         /*
  1433.         print('<br>QQW list ID: '.$listId);
  1434.         \Doctrine\Common\Util\Debug::dump($list);
  1435.         */
  1437.         $xmlDocument = new \DOMDocument('1.0', 'UTF-8');
  1439.         $style = " 
  1440.             list { display: block; padding-left: 10px; }
  1441.             listItem {
  1442.                 display: block; 
  1443.             }
  1445.             listItem:hover {
  1446.                 display: block;
  1447.                 background-color: #EFEFEF;  
  1448.             }
  1450.             .listItemTitle {
  1451.                 display: inline-block;
  1452.                 /* width: 300px; */
  1453.                 width: 45%;
  1454.                 height: 22px;
  1455.                 padding: 1px;
  1456.                 border: #DDD solid 1px; 
  1457.                 background-color: #EFEFEF;
  1458.             }
  1460.             listItemShortDescription {
  1461.                 display: inline-block;
  1462.                 /* width: 300px; */
  1463.                 width: 45%;
  1464.                 height: 22px;   
  1465.                 padding: 1px;
  1466.                 border: #DDD solid 1px; 
  1467.                 /*  background-color: #EFEFEF;  */
  1468.             }
  1470.             listTitle {
  1471.              font-family : Arial, Helvetica, sans-serif;
  1472.              display: block;
  1473.              font-size : 22px; 
  1474.              font-weight : bold;
  1475.              padding-top: 5px;
  1476.              padding-bottom: 5px; 
  1477.              height: 22px;
  1478.             }
  1480.             listItemAttribute1 {
  1481.              font-family : Arial, Helvetica, sans-serif;
  1482.              display: block;
  1483.              font-size : 22px; 
  1484.              font-weight : bold;
  1485.              padding-top: 5px;
  1486.              padding-bottom: 5px; 
  1487.              height: 22px;
  1488.             }    
  1489.             
  1490.             listItemAttribute2 {
  1491.              font-family : Arial, Helvetica, sans-serif;
  1492.              display: block;
  1493.              font-size : 22px; 
  1494.              font-weight : bold;
  1495.              padding-top: 5px;
  1496.              padding-bottom: 5px; 
  1497.              height: 22px;
  1498.             }                      
  1500.         ";
  1502.         $css = $xmlDocument->createProcessingInstruction("xml-stylesheet", "type=\"text/css\" href=\"https://www.vrcommerce.cz/css/list1.css\"");
  1503.         //$css = $xmlDocument->createProcessingInstruction("xml-stylesheet", "type=\"text/css\" href=\"#style\"");
  1504.         $xmlDocument->appendChild($css); 
  1506.         $rootElement = $xmlDocument->createElement('list');
  1507.         $titleTag = $xmlDocument->createElement('listTitle', $list->getListName());
  1508.         //$titleTag->setAttribute("class", "listTitle");
  1509.         //$titleTag->setAttribute("style", "background-color: #EFEFEF;");
  1510.         $rootElement->appendChild($titleTag);
  1512.         //$styleTag = $xmlDocument->createElement('style', $style);
  1513.         //$styleTag->setAttribute("type", "text/css");
  1514.         //$styleTag->setAttribute("id", "style");
  1515.         //<style type = "text/css">
  1516.         //$rootElement->appendChild($styleTag);
  1518.         $listItemsTag = $xmlDocument->createElement('listItems');
  1520.         foreach($listItems as $listItem) {
  1521.             $listItemsTag = $xmlDocument->createElement('listItem');
  1522.             $listItemsTitleTag = $xmlDocument->createElement('listItemTitle', $listItem->getListItemName()); 
  1523.             $listItemsShortDescriptionTag = $xmlDocument->createElement('listItemShortDescription', $listItem->getListItemShortDescription()); 
  1525.             $listItemsTag->appendChild($listItemsTitleTag);
  1526.             $listItemsTag->appendChild($listItemsShortDescriptionTag);
  1528.             $listItemsLongDescriptionTag = $xmlDocument->createElement('listItemLongDescription');
  1529.             $listItemsLongDescriptionTag->appendChild($xmlDocument->createCDATASection(html_entity_decode(strip_tags($listItem->getListItemLongDescription()))));
  1530.             $listItemsTag->appendChild($listItemsLongDescriptionTag);  
  1533.             $listItemsAttribute1Tag = $xmlDocument->createElement('listItemAttribute1', $listItem->getFreeProperty1()); 
  1534.             $listItemsAttribute2Tag = $xmlDocument->createElement('listItemAttribute2', $listItem->getFreeProperty2()); 
  1535.             $listItemsTag->appendChild($listItemsAttribute1Tag);  
  1536.             $listItemsTag->appendChild($listItemsAttribute2Tag);  
  1538.             $rootElement->appendChild($listItemsTag); 
  1539.         }
  1541.         $xmlDocument->appendChild($rootElement);
  1543.         $xmlDocument->saveXML();
  1544.         $xmlDocument->save($userDirs['user'].'/'.$fileName);
  1546.         $list->setXmlFile($fileName);
  1547.         $dem->persist($list);
  1548.         $dem->flush();
  1550.         /*
  1551.         $response = new Response($xmlDocument->saveXML());
  1552.         $response->headers->set('Content-Type', 'xml');
  1553.         */
  1554.         
  1555.         //return $response;
  1557.     
  1558.         /* we render data */
  1559.         /*
  1560.         return $this->render('listXML.html.php',
  1561.                 array(  'headerData' => $this -> getPageHeader($request),
  1562.                         'list' => $list,
  1563.                         'listItems' => $listItems,
  1564.                 )
  1565.                 );
  1566.         */
  1567.     
  1568.     }          
  1571.     /**
  1572.      * @Route("/listitemedit/{listItemId}", name="listItemEdit")
  1573.      */
  1574.     public function listItemEditAction(Request $request, $listItemId)
  1575.     {
  1577.         /* we load session data */
  1578.         parent::init($request);
  1579.         $session = $request->getSession();
  1581.         // we check if any user is logged in
  1582.         if(!$this->isLoggedUser($request)) {
  1583.             return $this->redirectToRoute('login');
  1584.         }   
  1585.     
  1586.         /* we load users entity manager */
  1587.         $em = $this->doctrine->getManager();
  1588.         $dem = $this->doctrine->getManager('dynamic_em');
  1589.     
  1590.         $userId = $session->get('user')->getUserId();
  1591.         $user = $em->getRepository(User::class)->getUser($userId);
  1592.     
  1593.         $listItem = $dem->getRepository(CustomListItem::class)->getCustomListItem($listItemId);
  1594.         $list = $dem->getRepository(CustomList::class)->getCustomList($listItem->getListId());
  1596.         /*
  1597.         print('<br>QQW list ID: '.$listId);
  1598.         \Doctrine\Common\Util\Debug::dump($list);
  1599.         */
  1601.         /* we build edit form */
  1602.         $formBuilder = $this->createFormBuilder($listItem);
  1603.     
  1604.         $formBuilder->add('listItemName', TextType::class, array(
  1605.                 'required' => false,
  1606.                 'label' => $this->translator->trans('knowledgebase.list_item_name'),
  1607.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $listItem->getListItemName()),
  1608.                 'label_attr' => array('class' => 'form_field_label')
  1609.         ));
  1611.         $formBuilder->add('listItemShortDescription', TextareaType::class, array(
  1612.                 'required' => false,
  1613.                 'label' => $this->translator->trans('knowledgebase.list_item_short_description'),
  1614.                 'attr' => array('class' => 'textarea_form', 'cols' => 55, 'rows' => 4, 'value' => $listItem->getListItemShortDescription()),
  1615.                 'label_attr' => array('class' => 'form_textarea_label'),
  1616.                 'data' => $listItem->getListItemShortDescription(),
  1617.         ));      
  1619.         $formBuilder->add('clickURL', TextType::class, array(
  1620.                 'required' => false,
  1621.                 'label' => $this->translator->trans('system.link_url'),
  1622.                 'attr' => array('class' => 'text_form', 'size' => 53, 'value' => $listItem->getClickURL()),
  1623.                 'label_attr' => array('class' => 'form_field_label')
  1624.         ));         
  1626.         $formBuilder->add('listItemLongDescription', TextareaType::class, array(
  1627.                 'required' => false,
  1628.                 'label' => $this->translator->trans('knowledgebase.list_item_long_description'),
  1629.                 'attr' => array('class' => 'textarea_form', 'cols' => 101, 'rows' => 5, 'value' => $listItem->getListItemLongDescription()),
  1630.                 'label_attr' => array('class' => 'form_textarea_label'),
  1631.                 'data' => $listItem->getListItemLongDescription(),
  1632.         )); 
  1634.         $formBuilder->add('freeProperty1', TextType::class, array(
  1635.                 'required' => false,
  1636.                 'label' => $this->translator->trans('knowledgebase.list_item_free_property1'),
  1637.                 'attr' => array('class' => 'text_form', 'size' => 53, 'value' => $listItem->getFreeProperty1()),
  1638.                 'label_attr' => array('class' => 'form_field_label')
  1639.         ));      
  1641.         $formBuilder->add('freeProperty2', TextType::class, array(
  1642.                 'required' => false,
  1643.                 'label' => $this->translator->trans('knowledgebase.list_item_free_property2'),
  1644.                 'attr' => array('class' => 'text_form', 'size' => 53, 'value' => $listItem->getFreeProperty2()),
  1645.                 'label_attr' => array('class' => 'form_field_label')
  1646.         ));               
  1648.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  1649.                 'attr' => array('class' => 'butt_big')));
  1651.         $form = $formBuilder->getForm();
  1652.         $form->handleRequest($request);
  1653.     
  1654.         if ($request->getMethod() == 'POST') {
  1657.             if ($form->isValid()) {
  1658.                 // perform some action, such as save the object to the database
  1659.                 //print('<br>qqw post form 2: ');
  1660.                 $formData = $form->getData();
  1661.     
  1662.                 /* we load data from form into contact object */
  1663.                 $listItem->setListItemName($formData->getListItemName());
  1664.                 $listItem->setListItemShortDescription($formData->getListItemShortDescription());
  1665.                 $listItem->setListItemLongDescription($formData->getListItemLongDescription());
  1666.                 $listItem->setClickURL($formData->getClickURL());
  1667.                 $listItem->setFreeProperty1($formData->getFreeProperty1());
  1668.                 $listItem->setFreeProperty2($formData->getFreeProperty2());
  1670.                 /* we persist and save */
  1671.                 //$em->persist($contact);
  1672.                 $dem->flush();
  1673.     
  1674.                 $this->addFlash('notice', 'List item was updated.');
  1675.     
  1676.                 return $this->redirectToRoute('listEdit', array('listId' => $listItem->getListId()));
  1677.     
  1678.             }
  1679.     
  1680.         }
  1681.     
  1682.         /* we render data */
  1683.         return $this->render('listItemEdit.html.twig',
  1684.                 array(  'headerData' => $this -> getPageHeader($request),
  1685.                         'form' => $formBuilder->getForm()->createView(),
  1686.                         'list' => $list,
  1687.                         'listItem' => $listItem,
  1688.                         'menu' => $this -> adminMenu($request),
  1689.                         'user' => $user,
  1690.                         'mainMenu' => $this -> adminMainMenu($request)
  1691.                 )
  1692.                 );
  1693.     
  1694.     }    
  1698.     /**
  1699.      * @Route("/tradeLead", name="tradeLead")
  1700.      */
  1701.     public function tradeLeadAction(Request $request)
  1702.     {
  1703.     
  1704.         /* we load session data */
  1705.         parent::init($request);
  1706.         $session = $request->getSession();
  1707.     
  1708.         /* we load users entity manager */
  1709.         $em = $this->doctrine->getManager();
  1710.         $dem = $this->doctrine->getManager('dynamic_em');
  1712.         $userId = $session->get('user')->getUserId();
  1713.         $user = $em->getRepository(User::class)->getUser($userId);
  1715.         /* removing tradelead */
  1716.         if(!empty($request->query->get('removeLead'))) {   
  1718.             $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(['tradeLeadId' => $request->query->get('removeLead')]);
  1720.             if(!empty($tradeLead)) {
  1721.                 try {
  1722.                     
  1723.                     $dem->remove($tradeLead);        
  1724.                     //$em->persist($tradeLead);
  1725.                     $dem->flush();
  1727.                     //$tradeLead = $dem->getRepository(TradeLead::class)->removeTradeLead($request->query->get('removeLead'));
  1728.                     $this->addFlash('notice', 'Trade Lead was removed.');
  1729.                 } catch(\Doctrine\DBAL\DBALException $e) {
  1730.                     $this->addFlash('error', "This Trade Lead has connected services (orders etc.), so it can't be removed.");
  1731.                 }                
  1732.             }
  1733.             
  1734.         }         
  1736.         /* import tradelead */
  1737.         if(!empty($request->query->get('importLeads'))) {   
  1739.             print('<br>qqw import leads');
  1741.             ini_set('max_execution_time', 1800); 
  1742.             set_time_limit(1800);
  1744.             $mem = $this->doctrine->getManager('marketplace_em');
  1745.             $marketplaceConn = $mem->getConnection('marketplace_conn');
  1747.             $sql = "SELECT * FROM eshops e INNER JOIN eshops_description ed ON e.id_shop = ed.id_shop AND ed.title != ''";
  1748.             $stmt = $marketplaceConn->prepare($sql);
  1749.             $stmt->execute();
  1750.             $result = $stmt->fetchAll();
  1752.             foreach($result as $row) {
  1753.                 print('<hr>row: ');
  1754.                 \Doctrine\Common\Util\Debug::dump($row);
  1756.                 $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(array('externalId' => $row['id_shop']));
  1758.                 if(empty($tradeLead)) {
  1759.                     $tradeLead = new TradeLead;
  1760.                 }
  1762.                 $tradeLead->setTitle($row['title']);
  1763.                 $tradeLead->setDescription($row['description']);
  1764.                 $tradeLead->setNotes($row['notes']);
  1765.                 $tradeLead->setEmail($row['email']);  
  1766.                 $tradeLead->setStatus($row['status']);              
  1767.                 $tradeLead->setContactPersonEmail($row['email_director']);   
  1768.                 $tradeLead->setLinkUrl($row['url']);  
  1769.                 $tradeLead->setExternalId($row['id_shop']);  
  1771.                 print('<br>tradeLead: ');
  1772.                 \Doctrine\Common\Util\Debug::dump($tradeLead);
  1773.    
  1775.                 /* we persist and save */
  1776.                 $dem->persist($tradeLead);
  1777.                 $dem->flush();
  1779.             }
  1780.             
  1782.         } 
  1783.     
  1784.         $tradeLeadList = $dem->getRepository(TradeLead::class)->findAll();
  1786.         /* we render data */
  1787.         return $this->render('tradeLeads.html.twig',
  1788.                 array(  'headerData' => $this -> getPageHeader($request),
  1789.                         'tradeLeadList' => $tradeLeadList,
  1790.                         'menu' => $this -> adminMenu($request),
  1791.                         'user' => $user,
  1792.                         'mainMenu' => $this -> adminMainMenu($request)
  1793.                 )
  1794.                 );
  1795.     
  1796.     }    
  1798.     /**
  1799.      * @Route("/tradeLeadExec", name="tradeLeadExec")
  1800.      */
  1801.     public function tradeLeadExecAction(Request $request)
  1802.     {
  1803.     
  1804.         /* we load session data */
  1805.         parent::init($request);
  1806.         $session = $request->getSession();
  1807.     
  1808.         /* we load users entity manager */
  1809.         $em = $this->doctrine->getManager();
  1810.         $dem = $this->doctrine->getManager('dynamic_em');
  1812.         /* we get user */ 
  1813.         $userId = $session->get('user')->getUserId();
  1814.         $user = $em->getRepository(User::class)->getUser($userId);
  1815.         $userDirs = $this->getUserFolderPaths($request);
  1817.         $selectedTradeLeads = array();
  1818.         if(!empty($request->request->get('selectedTradeLeads'))) {
  1819.             //print(' tradeleads POSTED');
  1821.             $selectedTradeLeads = $request->request->get('selectedTradeLeads');
  1823.             $leadList = json_encode($selectedTradeLeads);
  1825.             //\Doctrine\Common\Util\Debug::dump($request->request->get('selectedTradeLeads'));
  1826.         }
  1828.         if(!empty($request->request->get('form')['leadList'])) {
  1829.             $leadList = $request->request->get('form')['leadList'];
  1830.         }
  1832.         $emailSubject = '';
  1833.         if(!empty($request->request->get('form')['emailSubject'])) {
  1834.             $emailSubject = $request->request->get('form')['emailSubject'];
  1835.         }
  1836.         $emailBodyHtml = '';
  1837.         if(!empty($request->request->get('form')['emailBodyHtml'])) {
  1838.             $emailBodyHtml = $request->request->get('form')['emailBodyHtml'];
  1839.         }       
  1841.         //Doctrine\Common\Util\Debug::dump($request->request->get('selectedTradeLeads'));
  1842.         //$tradeLeadList = $dem->getRepository(TradeLead::class)->findAll();
  1843.         
  1844.        
  1845.         /* we build edit form */
  1846.         $formBuilder = $this->createFormBuilder();
  1848.         $formBuilder->add('emailSubject', TextType::class, array(
  1849.                 'required' => false,
  1850.                 'label' => 'email subject',
  1851.                 'attr' => array('class' => 'text_form', 'size' => 70, 'value' => $emailSubject),
  1852.                 'label_attr' => array('class' => 'form_field_label'),
  1853.         ));         
  1854.        
  1855.          $formBuilder->add('emailBodyHtml', CKEditorType::class, array(
  1856.                 'required' => false,
  1857.                 'label' => 'html email',
  1858.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $emailBodyHtml),
  1859.                 'label_attr' => array('class' => 'form_field_label'),
  1860.                 'data' => $emailBodyHtml,
  1861.         )); 
  1865.         $formBuilder->add('leadList', HiddenType::class, array(
  1866.                 'data' => $leadList,
  1867.         ));         
  1869.         $formBuilder->add('save', SubmitType::class, array('label' => 'Execute Action',
  1870.                 'attr' => array('class' => 'butt_big')));
  1871.          
  1872.         $form = $formBuilder->getForm();
  1873.          
  1874.         $form->handleRequest($request);
  1875.          
  1876.         if ($request->getMethod() == 'POST') {
  1877.              
  1878.             //$form->bindRequest($request);
  1879.              
  1880.             if ($form->isValid()) {
  1881.                 // perform some action, such as save the object to the database
  1883.                 //print('<br>tradeleads ids json: ');
  1884.                 //print_r($request->request->get('form')['selectedTradeLeads']);
  1886.                 $leadIdList = json_decode($request->request->get('form')['leadList']);
  1888.                 foreach($leadIdList as $leadId) {
  1889.                     
  1890.                     $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(array('tradeLeadId' => $leadId));
  1891.                     print('<hr>executing on lead: '.$tradeLead->getTitle().' , id: '.$leadId);
  1892.                     //Doctrine\Common\Util\Debug::dump($tradeLead);
  1893.                     //print_r($tradeLead);
  1895.                     $now = new \DateTime();
  1896.                     $nowDate = $now->format('Y-m-d H:i:s'); 
  1898.                     if(!empty($tradeLead->getEmail())) {
  1900.                         $to = $tradeLead->getEmail();
  1901.                         $subject = $emailSubject;
  1902.                         $message = $emailBodyHtml;
  1903.                         $name = $user->getCompany();
  1904.                         $from = $user->getEmail();
  1906.                         $headers  = "MIME-Version: 1.0\r\n";
  1907.                         $headers .= "Content-type: text/html; charset=UTF-8\r\n";
  1908.                         $headers .= "From: {$name} <{$from}>\r\n";
  1909.                         $headers .= "Reply-To: <{$from}>\r\n";
  1910.                         $headers .= "Subject: {$subject}\r\n";
  1911.                         $headers .= "X-Mailer: PHP/".phpversion()."\r\n";
  1912.                         
  1913.                         /* we send email to e-shop admin */
  1914.                         if(@mail($to, $subject, $message, $headers)) {
  1915.                             $message = '['.$nowDate.'] Email `'.$emailSubject.'` was sent to: '.$to;
  1916.                             print('<br>'.$message);
  1917.                             $tradeLead->setNotes($tradeLead->getNotes()."\n".$message);
  1918.                         } else {
  1919.                             print('<br>Email was not sent to: '.$to);
  1920.                         }   
  1922.                     }
  1924.                     if(!empty($tradeLead->getContactPersonEmail())) {
  1926.                         $to = $tradeLead->getContactPersonEmail();
  1927.                         $subject = $emailSubject;
  1928.                         $message = $emailBodyHtml;
  1929.                         $name = $user->getCompany();
  1930.                         $from = $user->getEmail();
  1932.                         $headers  = "MIME-Version: 1.0\r\n";
  1933.                         $headers .= "Content-type: text/html; charset=UTF-8\r\n";
  1934.                         $headers .= "From: {$name} <{$from}>\r\n";
  1935.                         $headers .= "Reply-To: <{$from}>\r\n";
  1936.                         $headers .= "Subject: {$subject}\r\n";
  1937.                         $headers .= "X-Mailer: PHP/".phpversion()."\r\n";
  1938.                         
  1939.                         /* we send email to e-shop admin */
  1940.                         if(@mail($to, $subject, $message, $headers)) {
  1941.                             $message = '['.$nowDate.'] Email `'.$emailSubject.'` was sent to: '.$to;
  1942.                             print('<br>'.$message);
  1943.                             $tradeLead->setNotes($tradeLead->getNotes()."\n".$message);
  1944.                         } else {
  1945.                             print('<br>Email was not sent to: '.$to); 
  1946.                         }   
  1948.                     }  
  1950.                     $dem->persist($tradeLead);
  1951.                     $dem->flush();                  
  1953.                 }
  1955.                 //Doctrine\Common\Util\Debug::dump($request->request->get('form')['emailSubject']);
  1958.                 $this->addFlash('notice', 'Trade Lead Action was executed.');
  1960.                  
  1961.             }
  1962.              
  1963.         }        
  1965.         /* we render data */
  1966.         return $this->render('tradeLeadExec.html.php',
  1967.                 array(  'headerData' => $this -> getPageHeader($request),
  1968.                         'form' => $formBuilder->getForm()->createView(),
  1969.                         'selectedTradeLeads' => $selectedTradeLeads,
  1970.                         'leadList' => $leadList,                        
  1971.                         'menu' => $this -> adminMenu($request),
  1972.                         'mainMenu' => $this -> adminMainMenu($request)
  1973.                 )
  1974.                 );
  1975.     
  1976.     }        
  1978.     /**
  1979.      * @Route("/tradeleadedit/{tradeLeadId}", name="tradeLeadEdit")
  1980.      */
  1981.     public function tradeLeadEditAction(Request $request, $tradeLeadId)
  1982.     {
  1984.         /* we load session data */
  1985.         parent::init($request);
  1986.         $session = $request->getSession();
  1987.     
  1988.         /* we load entity managers */
  1989.         $em = $this->doctrine->getManager();
  1990.         $dem = $this->doctrine->getManager('dynamic_em');
  1991.     
  1992.         $userId = $session->get('user')->getUserId();
  1993.         $user = $em->getRepository(User::class)->getUser($userId);
  1994.     
  1995.         $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(array('tradeLeadId' => $tradeLeadId));
  1997.         /* removing tradelead */
  1998.         if(!empty($request->query->get('createEshopLink'))) {  
  1999.             print('<br>createEshopLink ...');
  2001.             $eshopLink = new EshopLink;
  2002.             $eshopLink->setEshopLinkName($tradeLead->getTitle());
  2003.             $eshopLink->setEshopLinkUrl($tradeLead->getLinkUrl());
  2004.             $eshopLink->addLanguage($session->get('lang'));
  2006.             $em->persist($eshopLink);
  2007.             $em->flush();                     
  2009.             $this->addFlash('notice', 'New Eshop Link was created.');
  2012.         }
  2014.         /* we build edit form */ 
  2015.         $formBuilder = $this->createFormBuilder($tradeLead);
  2016.     
  2017.         $formBuilder->add('title', TextType::class, array(
  2018.                 'required' => false,
  2019.                 'label' => $this->translator->trans('marketplace.trade_lead_title'),
  2020.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getTitle()),
  2021.                 'label_attr' => array('class' => 'form_field_label')
  2022.         ));
  2023.         
  2024.         $formBuilder->add('company', TextType::class, array(
  2025.                 'required' => false,
  2026.                 //'label' => $this->translator->trans('knowledgebase.middle_name'),
  2027.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getCompany()),
  2028.                 'label_attr' => array('class' => 'form_field_label')
  2029.         ));     
  2030.         
  2031.         $formBuilder->add('email', TextType::class, array(
  2032.                 'required' => false,
  2033.                 //'label' => $this->translator->trans('knowledgebase.last_name'),
  2034.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getEmail()),
  2035.                 'label_attr' => array('class' => 'form_field_label')
  2036.         ));  
  2038.         $formBuilder->add('linkUrl', TextType::class, array(
  2039.                 'required' => false,
  2040.                 //'label' => $this->translator->trans('knowledgebase.middle_name'),
  2041.                 'attr' => array('class' => 'text_form', 'size' => 91, 'value' => $tradeLead->getLinkUrl()),
  2042.                 'label_attr' => array('class' => 'form_field_label')
  2043.         ));            
  2045.         $formBuilder->add('description', TextareaType::class, array(
  2046.                 'required' => false,
  2047.                 //'label' => $this->translator->trans('knowledgebase.list_item_short_description'),
  2048.                 'attr' => array('class' => 'textarea_form', 'cols' => 90, 'rows' => 10, 'value' => $tradeLead->getDescription()),
  2049.                 'label_attr' => array('class' => 'form_textarea_label'),
  2050.                 'data' => $tradeLead->getDescription(),
  2051.         ));  
  2053.         $formBuilder->add('notes', TextareaType::class, array(
  2054.                 'required' => false,
  2055.                 //'label' => $this->translator->trans('knowledgebase.list_item_short_description'),
  2056.                 'attr' => array('class' => 'textarea_form', 'cols' => 90, 'rows' => 10, 'value' => $tradeLead->getNotes()),
  2057.                 'label_attr' => array('class' => 'form_textarea_label'),
  2058.                 'data' => $tradeLead->getNotes(),
  2059.         ));  
  2061.         $formBuilder->add('contactPerson', TextType::class, array(
  2062.                 'required' => false,
  2063.                 //'label' => $this->translator->trans('knowledgebase.company_name'),
  2064.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getContactPerson()),
  2065.                 'label_attr' => array('class' => 'form_field_label')
  2066.         ));         
  2068.         $formBuilder->add('contactPersonEmail', TextType::class, array(
  2069.                 'required' => false,
  2070.                 //'label' => $this->translator->trans('knowledgebase.email'),
  2071.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getContactPersonEmail()),
  2072.                 'label_attr' => array('class' => 'form_field_label')
  2073.         ));           
  2075.         $formBuilder->add('telephone', TextType::class, array(
  2076.                 'required' => false,
  2077.                 //'label' => $this->translator->trans('knowledgebase.email'),
  2078.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getTelephone()),
  2079.                 'label_attr' => array('class' => 'form_field_label')
  2080.         ));         
  2082.         $formBuilder->add('address', TextType::class, array(
  2083.                 'required' => false,
  2084.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2085.                 'attr' => array('class' => 'text_form', 'size' => 91, 'value' => $tradeLead->getAddress()),
  2086.                 'label_attr' => array('class' => 'form_field_label')
  2087.         ));   
  2089.         $formBuilder->add('invoiceAddress', TextType::class, array(
  2090.                 'required' => false,
  2091.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2092.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getInvoiceAddress()),
  2093.                 'label_attr' => array('class' => 'form_field_label')
  2094.         ));  
  2096.         $formBuilder->add('responsibleAdminUserId', TextType::class, array(
  2097.                 'required' => false,
  2098.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2099.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getResponsibleAdminUserId()),
  2100.                 'label_attr' => array('class' => 'form_field_label')
  2101.         ));  
  2104.         $formBuilder->add('dateResponsibilityGiven', TextType::class, array(
  2105.                 'required' => false,
  2106.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2107.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getDateResponsibilityGiven()),
  2108.                 'label_attr' => array('class' => 'form_field_label')
  2109.         ));  
  2111.         $formBuilder->add('status', TextType::class, array(
  2112.                 'required' => false,
  2113.                 //label' => $this->translator->trans('knowledgebase.phone'),
  2114.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getStatus()),
  2115.                 'label_attr' => array('class' => 'form_field_label')
  2116.         ));  
  2118.         $formBuilder->add('serverId', TextType::class, array(
  2119.                 'required' => false,
  2120.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2121.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getServerId()),
  2122.                 'label_attr' => array('class' => 'form_field_label')
  2123.         ));  
  2125.         $formBuilder->add('areaId', TextType::class, array(
  2126.                 'required' => false,
  2127.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2128.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getAreaId()),
  2129.                 'label_attr' => array('class' => 'form_field_label')
  2130.         ));  
  2132.         $formBuilder->add('preferredSectionId', TextType::class, array(
  2133.                 'required' => false,
  2134.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2135.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getPreferredSectionId()),
  2136.                 'label_attr' => array('class' => 'form_field_label')
  2137.         ));  
  2139.         $formBuilder->add('preferredSectionId2', TextType::class, array(
  2140.                 'required' => false,
  2141.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2142.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getPreferredSectionId2()),
  2143.                 'label_attr' => array('class' => 'form_field_label')
  2144.         ));  
  2146.         $formBuilder->add('avatarUrl', TextType::class, array(
  2147.                 'required' => false,
  2148.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2149.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getAvatarUrl()),
  2150.                 'label_attr' => array('class' => 'form_field_label')
  2151.         ));  
  2153.         $formBuilder->add('logoUrl', TextType::class, array(
  2154.                 'required' => false,
  2155.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2156.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getLogoUrl()),
  2157.                 'label_attr' => array('class' => 'form_field_label')
  2158.         ));  
  2160.         $formBuilder->add('bankAccount', TextType::class, array(
  2161.                 'required' => false,
  2162.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2163.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getBankAccount()),
  2164.                 'label_attr' => array('class' => 'form_field_label')
  2165.         ));                                                                          
  2167.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  2168.                 'attr' => array('class' => 'butt_big')));
  2169.     
  2170.         $form = $formBuilder->getForm();
  2171.         $form->handleRequest($request);
  2172.     
  2173.         if ($request->getMethod() == 'POST') {
  2175.             if ($form->isValid()) {
  2177.                 $formData = $form->getData();
  2178.     
  2179.                 /* we load data from form into TradeLead object */
  2180.                 $tradeLead->setTitle($formData->getTitle());
  2181.                 $tradeLead->setCompany($formData->getCompany());
  2182.                 $tradeLead->setEmail($formData->getEmail());
  2183.                 $tradeLead->setLinkUrl($formData->getLinkUrl());
  2184.                 $tradeLead->setContactPerson($formData->getContactPerson());
  2186.                 $tradeLead->setContactPersonEmail($formData->getContactPerson());
  2187.                 $tradeLead->setTelephone($formData->getTelephone());
  2188.                 $tradeLead->setNotes($formData->getNotes());
  2189.                 $tradeLead->setDescription($formData->getDescription());
  2190.                 $tradeLead->setAddress($formData->getAddress());
  2191.                 $tradeLead->setInvoiceAddress($formData->getInvoiceAddress());
  2192.                 $tradeLead->setResponsibleAdminUserId($formData->getResponsibleAdminUserId());
  2193.                 //$tradeLead->setDateResponsibilityGiven($request->request->get('form')['dateResponsibilityGiven']);                
  2195.                 $tradeLead->setStatus($formData->getStatus());
  2196.                 $tradeLead->setServerId($formData->getServerId());
  2197.                 $tradeLead->setAreaId($formData->getAreaId());
  2198.                 $tradeLead->setPreferredSectionId($formData->getPreferredSectionId());
  2199.                 $tradeLead->setPreferredSectionId2($formData->getPreferredSectionId2());
  2201.                 $tradeLead->setAvatarUrl($formData->getAvatarUrl());
  2202.                 $tradeLead->setLogoUrl($formData->getLogoUrl());
  2203.                 $tradeLead->setBankAccount($formData->getBankAccount());
  2205.                 /* we persist and save */
  2206.                 $dem->persist($tradeLead);
  2207.                 $dem->flush();
  2208.     
  2209.                 $this->addFlash('notice', 'Trade Lead was updated.');
  2210.     
  2211.                 return $this->redirectToRoute('tradeLeadEdit', array('tradeLeadId' => $tradeLead->getTradeLeadId()));
  2212.     
  2213.             }
  2214.     
  2215.         }
  2216.     
  2217.         /* we render data */
  2218.         return $this->render('tradeLeadEdit.html.twig',
  2219.                 array(  'headerData' => $this -> getPageHeader($request),
  2220.                         'form' => $formBuilder->getForm()->createView(),
  2221.                         'tradeLead' => $tradeLead,
  2222.                         'menu' => $this -> adminMenu($request),
  2223.                         'mainMenu' => $this -> adminMainMenu($request),
  2224.                         'user' => $user
  2225.                 )
  2226.                 );
  2227.     
  2228.     }   
  2230.     /**
  2231.      * @Route("/tradeLeadNew", name="tradeLeadNew")
  2232.      */
  2233.     public function tradeLeadNewAction(Request $request)
  2234.     {
  2236.         /* we load session data */
  2237.         parent::init($request);
  2238.     
  2239.         $session = $request->getSession();
  2241.         /* we load users entity manager */
  2242.         $em = $this->doctrine->getManager();
  2243.         $dem = $this->doctrine->getManager('dynamic_em');
  2245.         $userId = $session->get('user')->getUserId();
  2246.         $user = $em->getRepository(User::class)->getUser($userId);
  2247.     
  2248.         /* we build login form */
  2249.         $tradeLead = new TradeLead();
  2250.         $formBuilder = $this->createFormBuilder($tradeLead);
  2251.     
  2252.         $formBuilder->add('title', TextType::class, array(
  2253.                 'required' => true,
  2254.                 'label' => $this->translator->trans('marketplace.trade_lead_title'),
  2255.                 'attr' => array('class' => 'text_form', 'size' => 22),
  2256.                 'label_attr' => array('class' => 'form_field_label'),
  2257.         ));
  2258.         
  2260.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  2261.                 'attr' => array('class' => 'butt_big')));
  2262.     
  2263.         $form = $formBuilder->getForm();
  2264.         $form->handleRequest($request);
  2265.     
  2266.         if ($request->getMethod() == 'POST') {
  2267.     
  2268.             if ($form->isValid()) {
  2269.                 // perform some action, such as save the object to the database
  2270.     
  2271.                 /* we load users entity manager */
  2272.                 $dem = $this->doctrine->getManager('dynamic_em');
  2274.                 $formData = $form->getData();
  2276.                 $tradeLead->setTitle($formData->getTitle());
  2278.                 /* we persist and save */
  2279.                 $dem->persist($tradeLead);
  2280.                 $dem->flush();
  2281.     
  2282.                 $this->addFlash('notice', 'New Trade lead was created.');
  2283.                  
  2284.                 return $this->redirectToRoute('tradeLeadEdit', array('tradeLeadId' => $tradeLead->getTradeLeadId()));
  2285.     
  2286.             }
  2287.              
  2288.         }
  2289.     
  2290.         /* we render data */
  2291.         return $this->render('tradeLeadNew.html.twig',
  2292.                 array(  'form' => $formBuilder->getForm()->createView(),
  2293.                         'headerData' => $this -> getPageHeader($request),
  2294.                         'menu' => $this -> adminMenu($request),
  2295.                         'mainMenu' => $this -> adminMainMenu($request),
  2296.                         'user' => $user
  2297.                 )
  2298.                 );
  2299.     
  2300.     }
  2303.     
  2304.     public function adminMenu(Request $request)
  2305.     {
  2306.         $menuItems = array(
  2307.           1 => array('link' => 'knowledgebaseAdmin', 'langKey' => 'knowledgebase.admin', 'routeName' => 'knowledgebaseAdmin'),
  2308.           2 => array('link' => 'contacts', 'langKey' => 'knowledgebase.contacts', 'routeName' => 'contacts'),
  2309.           3 => array('link' => 'contactnew', 'langKey' => 'knowledgebase.new_contact', 'routeName' => 'contactNew'),
  2310.           4 => array('link' => 'tasks', 'langKey' => 'knowledgebase.tasks', 'routeName' => 'tasks'),
  2311.           5 => array('link' => 'tasknew', 'langKey' => 'knowledgebase.new_task', 'routeName' => 'taskNew'),                
  2312.           6 => array('link' => 'lists', 'langKey' => 'knowledgebase.lists', 'routeName' => 'lists'),
  2313.           7 => array('link' => 'listnew', 'langKey' => 'knowledgebase.new_list', 'routeName' => 'listNew'),
  2314.         );
  2316.         return $menuItems;
  2317.     }
  2318.     
  2319. }