src/Controller/KnowledgeBaseController.php line 70

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\Service;
  24. use App\Entity\Contact;
  25. use App\Entity\ContactGroup;
  26. use App\Entity\CustomList;
  27. use App\Entity\CustomListItem;
  28. use App\Entity\Address;
  29. use App\Entity\User;
  30. use App\Entity\UserStory;
  31. use App\Entity\Module;
  32. use App\Entity\Consent;
  33. use App\Entity\PriceLevel;
  34. use App\Entity\Eshop;
  35. use App\Entity\TradeLead;
  37. use Symfony\Contracts\Translation\TranslatorInterface;
  39. class KnowledgeBaseController extends DefaultController
  40. {
  41.     protected KernelInterface $appKernel;
  42.     protected ManagerRegistry $doctrine;
  43.     protected TranslatorInterface $translator;
  44.     public function __construct(KernelInterface $appKernel,
  45.                                 ManagerRegistry $doctrine,
  46.                                 TranslatorInterface $translator)
  47.     {
  48.         $this->appKernel = $appKernel;
  49.         $this->doctrine = $doctrine;
  50.         $this->translator = $translator;
  51.     }
  53.     /**
  54.      * @Route("/knowledgebase", name="knowledgebase")
  55.      */
  56.     public function indexAction(Request $request)
  57.     {
  59.         /* we load session data */
  60.         parent::init($request);
  61.         $session = $request->getSession();
  63.         /* we load entity managers */
  64.         $em = $this->doctrine->getManager();
  66.         /* we load list of modules for connector service */
  67.         $service = $em->getRepository(Service::class)->getService(2);
  69.         /* we get current user */
  70.         if (!empty($session->get('user'))) {
  71.             $currentUserId = $session->get('user')->getUserId();
  72.             $user = $em->getRepository(User::class)->getUser($currentUserId);
  73.             $userModuleList = $user->getModules();
  74.         } else {
  75.             $userModuleList = [];
  76.         }
  78.         /* we render data */
  79.         return $this->render('knowledgebase.html.twig',
  80.             array('headerData' => $this -> getPageHeader($request),
  81.                   'moduleList' => $service->getModules(),
  82.                   'userModuleList' => $userModuleList,
  83.                   'service' => $service,
  84.                 )
  85.         );        
  87.     }
  89.     /**
  90.      * @Route("/knowledgebaseAdmin", name="knowledgebaseAdmin")
  91.      */    
  92.     public function knowledgebaseAdminAction(Request $request)
  93.     {
  95.         /* we load session data */
  96.         parent::init($request);
  97.          
  98.         $session = $request->getSession();
  100.         /* we check if user is logged in */
  101.         if(empty($session->get('user'))) {
  102.             return $this->redirectToRoute('login');
  103.         }         
  104.         
  105.         /* we load entity managers */
  106.         $em = $this->doctrine->getManager();
  107.         $dem = $this->doctrine->getManager('dynamic_em');
  108.         
  109.         /* we get current user */
  110.         $currentUserId = $session->get('user')->getUserId();
  111.         $user = $em->getRepository(User::class)->getUser($currentUserId);
  112.         
  113.         /* we load service */
  114.         $service = $em->getRepository(Service::class)->getService(2);
  116.         //we check if user has UserStory module and get recent form responses
  117.         $module = $em->getRepository(Module::class)->getModule(24);
  118.         $isModule = $em->getRepository(User::class)->userHasModule($user, $module);
  119.         $taskList = null;
  120.         if($isModule) {
  121.             $dateStart = date("Y-m-d",strtotime('monday this week'));
  122.             $dateEnd = date("Y-m-d",strtotime('sunday this week'));
  123.             $taskList = $dem->getRepository(UserStory::class)->getUserStoryStartBetweenDatesList($dateStart, $dateEnd);
  124.         }
  126.         /* we render data */
  127.         return $this->render('knowledgebaseAdmin.html.twig',
  128.                 array(    'headerData' => $this -> getPageHeader($request),
  129.                         'moduleList' => $service->getModules(),
  130.                         'userModuleList' => $user->getModules(),
  131.                         'user' => $user,
  132.                         'menu' => $this -> adminMenu($request),
  133.                         'taskList' => $taskList,
  134.                         'mainMenu' => $this -> adminMainMenu($request)                    
  135.                 )
  136.                 );
  137.     
  138.     }
  139.     
  140.     /**
  141.      * @Route("/contactnew", name="contactNew")
  142.      */
  143.     public function contactNewAction(Request $request)
  144.     {
  146.         /* we load session data */
  147.         parent::init($request);
  148.     
  149.         $session = $request->getSession();
  150.     
  151.         $em = $this->doctrine->getManager();
  153.         /* we get current user */
  154.         $currentUserId = $session->get('user')->getUserId();
  155.         $user = $em->getRepository(User::class)->getUser($currentUserId);
  157.         $contact = new Contact();
  158.     
  159.         /* we build login form */
  160.         $formBuilder = $this->createFormBuilder($contact);
  161.     
  162.         $formBuilder->add('firstName', TextType::class, array(
  163.                 'required' => true,
  164.                 'label' => $this->translator->trans('knowledgebase.first_name'),
  165.                 'attr' => array('class' => 'text_form', 'size' => 22),
  166.                 'label_attr' => array('class' => 'form_field_label'),
  167.         ));
  168.         
  169.         $formBuilder->add('lastName', TextType::class, array(
  170.                 'required' => true,
  171.                 'label' => $this->translator->trans('knowledgebase.last_name'),
  172.                 'attr' => array('class' => 'text_form', 'size' => 22),
  173.                 'label_attr' => array('class' => 'form_field_label'),
  174.         )); 
  176.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  177.                 'attr' => array('class' => 'butt_big')));
  179.         $form = $formBuilder->getForm();
  180.         $form->handleRequest($request);
  181.     
  182.         if ($request->getMethod() == 'POST') {
  183.     
  184.             if ($form->isValid()) {
  185.                 // perform some action, such as save the object to the database
  186.     
  187.                 /* we load users entity manager */
  188.                 $dem = $this->doctrine->getManager('dynamic_em');
  189.                 $formData = $form->getData();
  191.                 print('<br>qqw saving data');
  192.                 \Doctrine\Common\Util\Debug::dump($formData);
  194.                 $address = new Address();
  195.                 $deliveryAddress = new Address();
  197.                 print('<br>qqw firstName form: '.$formData->getFirstName());
  198.                 print('<br>qqw firstName object: '.$contact->getFirstName());
  200.                 $contact->setFirstName($formData->getFirstName());
  201.                 $contact->setLastName($formData->getLastName());
  202.                 //$contact->setAddress($address);
  203.                 //$contact->setDeliveryAddress($deliveryAddress);
  205.                 /* we persist and save */
  206.                 //$dem->persist($address);
  207.                 //$dem->persist($deliveryAddress);
  208.                 $dem->persist($contact);
  209.                 $dem->flush();
  210.     
  211.                 $this->addFlash('notice', 'New contact was created.');
  212.                  
  213.                 return $this->redirectToRoute('contactEdit', array('contactId' => $contact->getContactId()));
  214.     
  215.             }
  216.              
  217.         }
  218.     
  219.         /* we render data */
  220.         return $this->render('contactNew.html.twig',
  221.                 array(    'form' => $formBuilder->getForm()->createView(),
  222.                         'headerData' => $this -> getPageHeader($request),
  223.                         'menu' => $this -> adminMenu($request),
  224.                         'user' => $user,
  225.                         'mainMenu' => $this -> adminMainMenu($request)
  226.                 )
  227.                 );
  228.     
  229.     }
  230.     
  231.     /**
  232.      * @Route("/contacts", name="contacts")
  233.      */
  234.     public function contactsAction(Request $request)
  235.     {
  236.     
  237.         /* we load session data */
  238.         parent::init($request);
  239.         $session = $request->getSession();
  241.         /* we check if an user is logged in */
  242.         if(empty($session->get('user'))) {
  243.             return $this->redirectToRoute('login');
  244.         }          
  245.     
  246.         /* we load users entity manager */
  247.         $em = $this->doctrine->getManager();
  248.         $dem = $this->doctrine->getManager('dynamic_em');
  250.         /* removing contact */
  251.         if(!empty($request->query->get('removeContact'))) { 
  252.             //print('<br>qqw removing Contact 33: '.$request->query->get('removeContact'));   
  254.             try {
  255.                 $contact = $dem->getRepository(Contact::class)->removeContact($request->query->get('removeContact'));
  256.                 $this->addFlash('notice', 'Contact was removed.');
  257.             } catch(\Doctrine\DBAL\DBALException $e) {
  258.                 $this->addFlash('error', "This contact has connected services (orders etc.), so it can't be removed.");
  259.             }
  260.             
  261.         }
  263.         $userId = $session->get('user')->getUserId();
  264.         $user = $em->getRepository(User::class)->getUser($userId);
  266.         $contactList = $dem->getRepository(Contact::class)->getContactList();
  267.         $contactGroupList = $dem->getRepository(ContactGroup::class)->getContactGroupList();
  269.         /* we render data */
  270.         return $this->render('contacts.html.twig',
  271.                 array(    'headerData' => $this -> getPageHeader($request),
  272.                         'contactList' => $contactList,
  273.                         'contactGroupList' => $contactGroupList,
  274.                         'menu' => $this -> adminMenu($request),
  275.                         'user' => $user,
  276.                         'mainMenu' => $this -> adminMainMenu($request)
  277.                 )
  278.                 );
  279.     
  280.     }    
  282.     /**
  283.      * @Route("/contactedit/{contactId}", name="contactEdit")
  284.      */
  285.     public function contactEditAction(Request $request, $contactId)
  286.     {
  288.         /* we load session data */
  289.         parent::init($request);
  290.         $session = $request->getSession();
  292.         /* we check if an user is logged in */
  293.         if(empty($session->get('user'))) {
  294.             return $this->redirectToRoute('login');
  295.         }
  297.         /* we load entity managers */
  298.         $em = $this->doctrine->getManager();
  299.         $dem = $this->doctrine->getManager('dynamic_em');
  300.     
  301.         $userId = $session->get('user')->getUserId();
  302.         $user = $em->getRepository(User::class)->getUser($userId);
  304.         $contact = $dem->getRepository(Contact::class)->getContact($contactId);
  306.         //$contactExists = $em->getRepository(Contact::class)->findOneBy(['contactId' => $contactId]);
  308.            //->findOneBy(array('order_id' => $orderId));
  309.         //print('<hr>qqw x contact id 1: '.$contactId.': ');
  310.         //\Doctrine\Common\Util\Debug::dump($contact);
  312.          //print('<hr>qqw x contact id 2: '.$contactId.': ');
  313.          //\Doctrine\Common\Util\Debug::dump($contactExists);
  315.         /* we get collection of contact groups */
  316.         $contactGroupList = $dem->getRepository(ContactGroup::class)->getContactGroupList();
  317.         /* we get collection of consents */
  318.         $consents = $dem->getRepository(Consent::class)->getConsentList();
  320.         /* we build edit form */ 
  321.         $formBuilder = $this->createFormBuilder($contact);
  322.     
  323.         $formBuilder->add('firstName', TextType::class, array(
  324.                 'required' => false,
  325.                 'label' => $this->translator->trans('knowledgebase.first_name'),
  326.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getFirstName()),
  327.                 'label_attr' => array('class' => 'form_field_label')
  328.         ));
  329.         
  330.         $formBuilder->add('middleName', TextType::class, array(
  331.                 'required' => false,
  332.                 'label' => $this->translator->trans('knowledgebase.middle_name'),
  333.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getMiddleName()),
  334.                 'label_attr' => array('class' => 'form_field_label')
  335.         ));        
  336.         
  337.         $formBuilder->add('lastName', TextType::class, array(
  338.                 'required' => false,
  339.                 'label' => $this->translator->trans('knowledgebase.last_name'),
  340.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getLastName()),
  341.                 'label_attr' => array('class' => 'form_field_label')
  342.         ));        
  344.         $formBuilder->add('companyName', TextType::class, array(
  345.                 'required' => false,
  346.                 'label' => $this->translator->trans('knowledgebase.company_name'),
  347.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getCompanyName()),
  348.                 'label_attr' => array('class' => 'form_field_label')
  349.         ));         
  351.         $formBuilder->add('email', TextType::class, array(
  352.                 'required' => false,
  353.                 'label' => $this->translator->trans('knowledgebase.email'),
  354.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getEmail()),
  355.                 'label_attr' => array('class' => 'form_field_label')
  356.         ));           
  358.         $formBuilder->add('email2', TextType::class, array(
  359.                 'required' => false,
  360.                 'label' => $this->translator->trans('knowledgebase.email').' 2',
  361.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getEmail2()),
  362.                 'label_attr' => array('class' => 'form_field_label')
  363.         ));     
  365.         $formBuilder->add('email3', TextType::class, array(
  366.                 'required' => false,
  367.                 'label' => $this->translator->trans('knowledgebase.email').' 3',
  368.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getEmail3()),
  369.                 'label_attr' => array('class' => 'form_field_label')
  370.         ));     
  372.         $formBuilder->add('phone', TextType::class, array(
  373.                 'required' => false,
  374.                 'label' => $this->translator->trans('knowledgebase.phone'),
  375.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getPhone()),
  376.                 'label_attr' => array('class' => 'form_field_label')
  377.         ));   
  379.         $formBuilder->add('phone2', TextType::class, array(
  380.                 'required' => false,
  381.                 'label' => $this->translator->trans('knowledgebase.phone').' 2',
  382.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getPhone2()),
  383.                 'label_attr' => array('class' => 'form_field_label')
  384.         ));  
  386.         $formBuilder->add('phone3', TextType::class, array(
  387.                 'required' => false,
  388.                 'label' => $this->translator->trans('knowledgebase.phone').' 3',
  389.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getPhone3()),
  390.                 'label_attr' => array('class' => 'form_field_label')
  391.         ));    
  393.         /* we set addresses */
  394.         if(empty($contact->getAddress())) {
  395.             $address = new Address;
  396.             $contact->setAddress($address);
  397.         }
  398.         $formBuilder->add('addressStreet', TextType::class, array(
  399.                 'required' => false,
  400.                 'label' => $this->translator->trans('address.street'),
  401.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress()->getStreet()),
  402.                 'label_attr' => array('class' => 'form_field_label_top'),
  403.                 'mapped' => false
  404.         ));
  406.         $formBuilder->add('addressStreetNumber', TextType::class, array(
  407.                 'required' => false,
  408.                 'label' => $this->translator->trans('address.street_number'),
  409.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getAddress()->getStreetNumber()),
  410.                 'label_attr' => array('class' => 'form_field_label'),
  411.                 'mapped' => false
  412.         ));   
  414.         $formBuilder->add('addressZipCode', TextType::class, array(
  415.                 'required' => false,
  416.                 'label' => $this->translator->trans('address.zip_code'),
  417.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getAddress()->getZipCode()),
  418.                 'label_attr' => array('class' => 'form_field_label'),
  419.                 'mapped' => false
  420.         ));          
  422.         $formBuilder->add('addressCity', TextType::class, array(
  423.                 'required' => false,
  424.                 'label' => $this->translator->trans('address.city'),
  425.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress()->getCity()),
  426.                 'label_attr' => array('class' => 'form_field_label'),
  427.                 'mapped' => false
  428.         ));                      
  430.         $formBuilder->add('addressCountry', TextType::class, array(
  431.                 'required' => false,
  432.                 'label' => $this->translator->trans('address.country'),
  433.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress()->getCountry()),
  434.                 'label_attr' => array('class' => 'form_field_label_bottom'),
  435.                 'mapped' => false
  436.         ));                 
  438.         
  439.         /* we set delivery address */
  440.         if(empty($contact->getDeliveryAddress())) {
  441.             $deliveryAddress = new Address;
  442.             $contact->setDeliveryAddress($deliveryAddress);
  443.         }
  444.         $formBuilder->add('deliveryAddressStreet', TextType::class, array(
  445.                 'required' => false,
  446.                 'label' => $this->translator->trans('address.street_delivery'),
  447.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDeliveryAddress()->getStreet()),
  448.                 'label_attr' => array('class' => 'form_field_label'),
  449.                 'mapped' => false
  450.         ));
  452.         $formBuilder->add('deliveryAddressStreetNumber', TextType::class, array(
  453.                 'required' => false,
  454.                 'label' => $this->translator->trans('address.street_number_delivery'),
  455.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getDeliveryAddress()->getStreetNumber()),
  456.                 'label_attr' => array('class' => 'form_field_label'),
  457.                 'mapped' => false
  458.         ));   
  460.         $formBuilder->add('deliveryAddressZipCode', TextType::class, array(
  461.                 'required' => false,
  462.                 'label' => $this->translator->trans('address.zip_code_delivery'),
  463.                 'attr' => array('class' => 'text_form', 'size' => 10, 'value' => $contact->getDeliveryAddress()->getZipCode()),
  464.                 'label_attr' => array('class' => 'form_field_label'),
  465.                 'mapped' => false
  466.         ));          
  468.         $formBuilder->add('deliveryAddressCity', TextType::class, array(
  469.                 'required' => false,
  470.                 'label' => $this->translator->trans('address.city_delivery'),
  471.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDeliveryAddress()->getCity()),
  472.                 'label_attr' => array('class' => 'form_field_label'),
  473.                 'mapped' => false
  474.         ));                      
  476.         $formBuilder->add('deliveryAddressCountry', TextType::class, array(
  477.                 'required' => false,
  478.                 'label' => $this->translator->trans('address.country_delivery'),
  479.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDeliveryAddress()->getCountry()),
  480.                 'label_attr' => array('class' => 'form_field_label_bottom'),
  481.                 'mapped' => false
  482.         ));         
  485.         /*  
  486.         $formBuilder->add('address', TextType::class, array(
  487.                 'required' => false,
  488.                 'label' => $this->translator->trans('user.address').' 1',
  489.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress1()),
  490.                 'label_attr' => array('class' => 'form_field_label')
  491.         ));   
  493.         $formBuilder->add('address2', TextType::class, array(
  494.                 'required' => false,
  495.                 'label' => $this->translator->trans('user.address').' 2',
  496.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getAddress2()),
  497.                 'label_attr' => array('class' => 'form_field_label')
  498.         )); 
  500.         $formBuilder->add('invoiceAddress', TextType::class, array(
  501.                 'required' => false,
  502.                 'label' => $this->translator->trans('module.invoice_address').' 1',
  503.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getInvoiceAddress1()),
  504.                 'label_attr' => array('class' => 'form_field_label')
  505.         ));   
  507.         $formBuilder->add('invoiceAddress2', TextType::class, array(
  508.                 'required' => false,
  509.                 'label' => $this->translator->trans('module.invoice_address').' 2',
  510.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getInvoiceAddress2()),
  511.                 'label_attr' => array('class' => 'form_field_label')
  512.         )); 
  513.         */  
  515.         $formBuilder->add('businessId', TextType::class, array(
  516.                 'required' => false,
  517.                 'label' => $this->translator->trans('user.business_number'),
  518.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getBusinessId()),
  519.                 'label_attr' => array('class' => 'form_field_label')
  520.         ));   
  522.         $formBuilder->add('DICId', TextType::class, array(
  523.                 'required' => false,
  524.                 'label' => $this->translator->trans('user.DIC_number'),
  525.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getDICId()),
  526.                 'label_attr' => array('class' => 'form_field_label')
  527.         ));    
  529.         $formBuilder->add('ERPKey', TextType::class, array(
  530.                 'required' => false,
  531.                 'label' => $this->translator->trans('system.erp_key'),
  532.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getERPKey()),
  533.                 'label_attr' => array('class' => 'form_field_label')
  534.         ));        
  536.         $formBuilder->add('notes', TextareaType::class, array(
  537.                 'required' => false,
  538.                 'label' => $this->translator->trans('system.notes'),
  539.                 'attr' => array('class' => 'textarea_form', 'cols' => 55, 'rows' => 4, 'value' => $contact->getNotes()),
  540.                 'label_attr' => array('class' => 'form_textarea_label'),
  541.                 'data' => $contact->getNotes(),
  542.         ));                
  544.         $formBuilder->add('contactUserName', TextType::class, array(
  545.                 'required' => false,
  546.                 'label' => $this->translator->trans('knowledgebase.user_name'),
  547.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getContactUserName()),
  548.                 'label_attr' => array('class' => 'form_field_label')
  549.         ));    
  550.         
  551.         $formBuilder->add('contactUserPassword', TextType::class, array(
  552.                 'required' => false,
  553.                 'label' => $this->translator->trans('knowledgebase.password'),
  554.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $contact->getContactUserPassword()),
  555.                 'label_attr' => array('class' => 'form_field_label')
  556.         ));   
  558.         /* we add all contact groups */
  559.         $contactGroups = array();
  560.         foreach($contactGroupList as $contactGroup)
  561.         {
  562.             $contactGroups[$contactGroup->getContactGroupName()] = $contactGroup->getContactGroupId();
  563.         }
  565. //        print('<br>All ContactGroups: ');
  566. //        print_r($contactGroups);
  568.         $selectedContactGroups = array();
  570. //        print('<br>------------------- ContactGroups 0: ');
  571. //        \Doctrine\Common\Util\Debug::dump($contact->getContactGroups());
  573.         if (!empty($contact->getContactGroups())) {
  574.             foreach($contact->getContactGroups() as $contactGroup) {
  576.               if(!empty($contactGroup)) {
  577.                 $selectedContactGroups[] = $contactGroup->getContactGroupId();
  578.               }
  579.             }
  580.         }
  582. //        print('<br>ContactGroups: ');
  583. //        \Doctrine\Common\Util\Debug::dump($contact->getContactGroups());
  584.         //print_r($contact->getContactGroups());
  586.         $formBuilder->add('contactGroups', ChoiceType::class, array(
  587.                 'choices' => $contactGroups,
  588.                 'required' => false,
  589.                 'mapped' => false,
  590.                 'multiple' => true,
  591.                 'expanded' => true,
  592.                 'label_attr' => array('class' => 'form_field_label'),
  593.                 'attr' => array('class' => 'form_field_text'),
  594.                 'data' => $selectedContactGroups
  595.         ));  
  597.         /* we add all consents */
  598.         $consentList = array();
  600.         foreach($consents as $consent)
  601.         {
  603.             $consent->setLocale($session->get('lang')->getLangKey());
  604.             $dem->refresh($consent);  
  606.             $consentList[$consent->getConsentName()] = $consent->getConsentId();
  607.         }
  609. //        print('<br>------------------- all consents: ');
  610. //        \Doctrine\Common\Util\Debug::dump($consentList);
  612.         $selectedConsents = array();
  613.         if (!empty($contact->getConsents())) {
  614.             foreach ($contact->getConsents() as $consent) {
  615.                 if (!empty($consent)) {
  616.                     $selectedConsents[] = $consent->getConsentId();
  617.                 }
  618.             }
  619.         }
  621.         $formBuilder->add('consents', ChoiceType::class, array(
  622.                 'choices' => $consentList,
  623.                 'required' => false,
  624.                 'mapped' => false,
  625.                 'multiple' => true,
  626.                 'expanded' => true,
  627.                 'label_attr' => array('class' => 'form_field_label'),
  628.                 'attr' => array('class' => 'form_field_text'),
  629.                 'data' => $selectedConsents
  630.         ));   
  632.         //isModule Price Levels
  633.         $module = $em->getRepository(Module::class)->getModule(22);
  634.         $isPriceLevelModule = $em->getRepository(User::class)->userHasModule($user, $module);
  635.         $consentList = null;
  636.         if($isPriceLevelModule) {
  637.             //print('<br>qqw is module Price Levels');
  639.             $priceLevels = $dem->getRepository(PriceLevel::class)->getPriceLevelList();
  641.             /* we add all price levels */
  642.             $priceLevelList = array();
  643.             foreach($priceLevels as $priceLevel)
  644.             {
  645.                 $priceLevel->setLocale($session->get('lang')->getLangKey());
  646.                 $dem->refresh($priceLevel); 
  647.                 
  648.                 $priceLevelList[$priceLevel->getPriceLevelName()] = $priceLevel->getPriceLevelId();
  649.             }
  651.             $selectedPriceLevels = array();
  652.             $selectedPriceLevel = 1;
  653.             if(!empty($contact->getPriceLevel())) {
  655. //                print('<br>contactPriceLevel: ');
  656. //                \Doctrine\Common\Util\Debug::dump($contact->getPriceLevel());
  657.                 //print_r($contact->getPriceLevel());
  659.               //$selectedPriceLevels[] = $contact->getPriceLevel()->getPriceLevelId();
  660.               $selectedPriceLevel = $contact->getPriceLevel()->getPriceLevelId();
  661.             }
  663.             $formBuilder->add('priceLevel', ChoiceType::class, array(
  664.                     'choices' => $priceLevelList,
  665.                     'required' => false,
  666.                     'mapped' => false,
  667.                     'multiple' => false,
  668.                     'expanded' => true,
  669.                     'label_attr' => array('class' => 'form_field_label'),
  670.                     'attr' => array('class' => 'form_field_text'),
  671.                     'data' => $selectedPriceLevel
  672.             ));              
  674.         }               
  676.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  677.                 'attr' => array('class' => 'butt_big')));
  678.     
  679.         $form = $formBuilder->getForm();
  680.         $form->handleRequest($request);
  681.     
  682.         if ($request->getMethod() == 'POST') {
  684.             if ($form->isValid()) {
  685.                 // perform some action, such as save the object to the database
  686.                 //print('<br>qqw post form 2: ');
  687.                 $formData = $form->getData();
  688.     
  689.                 /* we load data from form into contact object */
  690.                 $contact->setFirstName($formData->getFirstName());
  691.                 $contact->setMiddleName($formData->getMiddleName());
  692.                 $contact->setLastName($formData->getLastName());
  693.                 $contact->setCompanyName($formData->getCompanyName());
  695.                 $contact->setEmail($formData->getEmail());
  696.                 $contact->setEmail2($formData->getEmail2());
  697.                 $contact->setEmail3($formData->getEmail3());
  699.                 $contact->setPhone($formData->getPhone());
  700.                 $contact->setPhone2($formData->getPhone2());
  701.                 $contact->setPhone3($formData->getPhone3());
  703.                 $address = $contact->getAddress();
  704.                 $address->setStreet($form['addressStreet']->getData());
  705.                 $address->setStreetNumber($form['addressStreetNumber']->getData());
  706.                 $address->setCity($form['addressCity']->getData());
  707.                 $address->setZipCode($form['addressZipCode']->getData());
  708.                 $address->setCountry($form['addressCountry']->getData());
  709.                 //$contact->setAddress($address);
  711.                 $deliveryAddress = $contact->getDeliveryAddress();
  712.                 $deliveryAddress->setStreet($form['deliveryAddressStreet']->getData());
  713.                 $deliveryAddress->setStreetNumber($form['deliveryAddressStreetNumber']->getData());
  714.                 $deliveryAddress->setCity($form['deliveryAddressCity']->getData());
  715.                 $deliveryAddress->setZipCode($form['deliveryAddressZipCode']->getData());
  716.                 $deliveryAddress->setCountry($form['deliveryAddressCountry']->getData());
  717.                 //$contact->setDeliveryAddress($deliveryAddress);
  719.                 $contact->setBusinessId($formData->getBusinessId());
  720.                 $contact->setDICId($formData->getDICId());
  722.                 $contact->setNotes($formData->getNotes());
  724.                 $contact->setContactUserName($formData->getContactUserName());
  725.                 // if the password is md5 hash already we do not hash
  726.                 $cuPsw = $formData->getContactUserPassword();
  727.                 if(strlen($cuPsw) == 32 && ctype_xdigit($cuPsw)) {
  728.                     $password = $cuPsw;
  729.                 } else {
  730.                     $password = md5($cuPsw);
  731.                 }
  732.                 $contact->setContactUserPassword($password);
  734.                 // we remove old contact groups
  735.                 if(!empty($contact->getContactGroups())) {
  736.                     foreach ($contact->getContactGroups() as $group) {
  737.                         print('<br>Group: ');
  738.                         $contact->removeContactGroup($group);
  739.                         //$dem->refresh($product);
  740.                         //$dem->persist($cat);
  741.                     }
  742.                 }
  744.                 // we save contact groups
  745.                 $formContactGroups = $form['contactGroups']->getData();
  746.                 if(is_array($formContactGroups)) {
  747.                     foreach($formContactGroups as $contactGroupId) {
  749.                         //print('');
  750.                         $group = $dem->getRepository(ContactGroup::class)->getContactGroup($contactGroupId);
  752.                         $contact->addContactGroup($group);
  754.                     }
  755.                 }
  757.                 // we save selected price level
  758.                 if($isPriceLevelModule && !empty($form['priceLevel']->getData())) {
  760.                     print('<br>PLId : '.$form['priceLevel']->getData());
  762.                     $priceLevel = $dem->getRepository(PriceLevel::class)->getPriceLevel($form['priceLevel']->getData());
  763.                     $contact->setPriceLevel($priceLevel);
  765.                     //print('<br>QQW selected price level: ');
  766.                     //\Doctrine\Common\Util\Debug::dump($priceLevel);
  768.                 }
  770.                 // we remove old consents
  771.                 if(!empty($contact->getConsents())) {
  772.                     foreach ($contact->getConsents() as $consent) {
  773.                         print('<br>Consent: ');
  774.                         $contact->removeConsent($consent);
  775.                     }
  776.                 }
  778.                 // we save consents
  779.                 $formConsents = $form['consents']->getData();
  780.                 if(is_array($formConsents)) {
  781.                     foreach($formConsents as $consentId) {
  783.                         $consent = $dem->getRepository(Consent::class)->getConsent($consentId);
  784.                         $contact->addConsent($consent);
  786.                     }
  787.                 }
  789.                 /* we persist and save */
  790.                 $em->persist($contact);
  791.                 $dem->flush();
  792.     
  793.                 $this->addFlash('notice', 'Contact was updated.');
  794.     
  795.                 return $this->redirectToRoute('contactEdit', array('contactId' => $contact->getContactId()));
  796.     
  797.             }
  798.     
  799.         }
  800.     
  801.         /* we render data */
  802.         return $this->render('contactEdit.html.twig',
  803.                 array(  'headerData' => $this -> getPageHeader($request),
  804.                         'form' => $formBuilder->getForm()->createView(),
  805.                         'user' => $user,
  806.                         'contact' => $contact,
  807.                         'menu' => $this -> adminMenu($request),
  808.                         'mainMenu' => $this -> adminMainMenu($request)
  809.                 )
  810.                 );
  811.     
  812.     }   
  814.          /**
  815.      * @Route("/contactGroupNew", name="contactGroupNew")
  816.      */
  817.     public function contactGroupNewAction(Request $request)
  818.     {
  820.         /* we load session data */
  821.         parent::init($request);
  822.          
  823.         $session = $request->getSession();
  825.         $em = $this->doctrine->getManager();
  827.         $userId = $session->get('user')->getUserId();
  828.         $user = $em->getRepository(User::class)->getUser($userId);
  830.         $contactGroup = new ContactGroup();
  832.         /* we build login form */
  833.         $formBuilder = $this->createFormBuilder($contactGroup);
  834.         
  835.         $formBuilder->add('contactGroupName', TextType::class, array(
  836.                 'required' => true,
  837.                 'label' => $this->translator->trans('knowledgebase.contact_group_name'),
  838.                 'attr' => array('class' => 'text_form', 'size' => 22),
  839.                 'label_attr' => array('class' => 'form_field_label'),
  840.         ));     
  841.     
  842.         //form.button.save
  843.         
  844.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  845.                 'attr' => array('class' => 'butt_big')));
  846.         
  847.         $form = $formBuilder->getForm();        
  848.         $form->handleRequest($request);
  849.         
  850.         if ($request->getMethod() == 'POST') {
  852.             if ($form->isValid()) {
  853.                 // perform some action, such as save the object to the database
  854.         
  855.                 /* we load users entity manager */
  856.                 $dem = $this->doctrine->getManager('dynamic_em');
  857.                 $formData = $form->getData();
  859.                 $contactGroup = new ContactGroup;
  860.                 $contactGroup->setContactGroupName($formData->getContactGroupName());
  861.                 
  862.                 /* we persist and save */
  863.                 $dem->persist($contactGroup);
  864.                 $dem->flush();
  865.                 
  866.                 $this->addFlash('notice', 'New contact group was created.');
  867.                 
  868.                 return $this->redirectToRoute('contactGroupEdit', array('contactGroupId' => $contactGroup->getContactGroupId()));
  869.         
  870.             }
  871.         
  872.         }
  873.     
  874.         /* we render data */
  875.         return $this->render('contactGroupNew.html.twig',
  876.                 array(  'form' => $formBuilder->getForm()->createView(),
  877.                         'headerData' => $this -> getPageHeader($request),
  878.                         'menu' => $this -> adminMenu($request),
  879.                         'user' => $user,
  880.                         'mainMenu' => $this -> adminMainMenu($request)
  881.                 )
  882.                 );
  883.     
  884.     }  
  886.     /**
  887.      * @Route("/contactGroupEdit/{contactGroupId}", name="contactGroupEdit")
  888.      */
  889.     public function contactGroupEditAction(Request $request, $contactGroupId)
  890.     {
  892.         /* we load session data */
  893.         parent::init($request);
  894.         $session = $request->getSession();
  895.         
  896.         /* we load entity managers */
  897.         $em = $this->doctrine->getManager();
  898.         $dem = $this->doctrine->getManager('dynamic_em');
  899.          
  900.         /* we get user */ 
  901.         $userId = $session->get('user')->getUserId();
  902.         $user = $em->getRepository(User::class)->getUser($userId);
  903.         
  904.         /* we get current e-shop */
  905.         $eshop = $em->getRepository(Eshop::class)->getCurrentEshop($userId);
  906.  
  907.         /* we get product parameter group */
  908.         $contactGroup = $dem->getRepository(ContactGroup::class)->getContactGroup($contactGroupId);
  910.         $userDirs = $this->getUserFolderPaths($request);
  911.         
  912.         /*
  913.         print('<br>QQW categoryCollection: ');
  914.         \Doctrine\Common\Util\Debug::dump($categoryCollection);
  915.         */
  916.           
  917.         /* we build edit form */
  918.         $formBuilder = $this->createFormBuilder($contactGroup);
  920.         $formBuilder->add('contactGroupName', TextType::class, array(
  921.                 'required' => true,
  922.                 'label' => $this->translator->trans('knowledgebase.contact_group_name'),
  923.                 'attr' => array('class' => 'text_form', 'size' => 22, 'value' => $contactGroup->getContactGroupName()),
  924.                 'label_attr' => array('class' => 'form_field_label'),
  925.         ));         
  926.        
  927.          $formBuilder->add('contactGroupBoard', TextareaType::class, array(
  928.                 'required' => false,
  929.                 'label' => $this->translator->trans('knowledgebase.contact_group_board'),
  930.                 'attr' => array('class' => 'textarea_form', 'cols' => 77, 'rows' => 7, 'value' => $contactGroup->getContactGroupBoard()),
  931.                 'label_attr' => array('class' => 'form_field_label'),
  932.                 'data' => $contactGroup->getContactGroupBoard(),
  933.         )); 
  935.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  936.                 'attr' => array('class' => 'butt_big')));
  937.          
  938.         $form = $formBuilder->getForm();
  939.          
  940.         $form->handleRequest($request);
  941.          
  942.         if ($request->getMethod() == 'POST') {
  943.              
  944.             //$form->bindRequest($request);
  945.              
  946.             if ($form->isValid()) {
  947.                 // perform some action, such as save the object to the database
  949.                 $formData = $form->getData();
  950.         
  951.                 $contactGroup->setContactGroupName($formData->getContactGroupName());
  952.                 $contactGroup->setContactGroupBoard($formData->getContactGroupBoard());
  954.                 /* we persist and save */
  955.                 $dem->persist($contactGroup);
  956.                 $dem->flush();
  958.                 $this->addFlash('notice', 'Contact group was updated.');
  960.                 return $this->redirectToRoute('contactGroupEdit', array('contactGroupId' => $contactGroup->getContactGroupId()));
  961.                  
  962.             }
  963.              
  964.         }
  966.         /* we render data */
  967.         return $this->render('contactGroupEdit.html.twig',
  968.             array('headerData' => $this -> getPageHeader($request),
  969.                   'form' => $formBuilder->getForm()->createView(),
  970.                   'contactGroup' => $contactGroup,
  971.                   'userDirs' => $userDirs,
  972.                   'menu' => $this -> adminMenu($request),
  973.                   'user' => $user,
  974.                   'mainMenu' => $this -> adminMainMenu($request)
  975.                 )
  976.         );        
  978.     }
  979.     
  980.     /**
  981.      * @Route("/lists", name="lists")
  982.      */
  983.     public function listsAction(Request $request)
  984.     {
  986.         /* we load session data */
  987.         parent::init($request);
  988.         $session = $request->getSession();
  990.         // we check if any user is logged in
  991.         if(!$this->isLoggedUser($request)) {
  992.             return $this->redirectToRoute('login');
  993.         } 
  995.         /* we load entity managers */
  996.         $em = $this->doctrine->getManager();
  997.         $dem = $this->doctrine->getManager('dynamic_em');
  999.         /* we get user */
  1000.         $userId = $session->get('user')->getUserId();
  1001.         $user = $em->getRepository(User::class)->getUser($userId);
  1003.         /* we check if user is logged in */
  1004.         if(empty($session->get('user'))) {
  1005.             return $this->redirectToRoute('login');
  1006.         }          
  1008.         /* we get file name and paths */
  1009.         $userDirs = $this->getUserFolderPaths($request);        
  1010.     
  1011.         $customLists = $dem->getRepository(CustomList::class)->getCustomLists();
  1013.         /* we build search form */
  1014.         $formBuilder = $this->createFormBuilder();
  1016.         $searchString = null;
  1017.         $searchResult = null;
  1018.     
  1019.         $formBuilder->add('searchString', TextType::class, array(
  1020.                 'required' => true,
  1021.                 'label' => ' ',
  1022.                 'attr' => array('class' => 'text_form', 'size' => 22),
  1023.                 'label_attr' => array('class' => 'form_field_label22'),
  1024.         ));
  1026.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('system.search'),
  1027.                 'attr' => array('class' => 'inlineButton')));
  1028.     
  1029.         $form = $formBuilder->getForm();
  1030.         $form->handleRequest($request);
  1031.     
  1032.         if ($request->getMethod() == 'POST') {
  1033.     
  1034.             if ($form->isValid()) {
  1036.                 $searchString = $request->request->get('form')['searchString'];
  1037.                 $searchResult['listItems'] = $dem->getRepository(CustomListItem::class)->getCustomListItemBySearch(trim($searchString));
  1038.     
  1039.                 $this->addFlash('notice', 'Searched string:'.$searchString);
  1041.             }
  1042.              
  1043.         }
  1045.         /* we render data */
  1046.         return $this->render('lists.html.twig',
  1047.                 array(    'form' => $formBuilder->getForm()->createView(),
  1048.                         'headerData' => $this -> getPageHeader($request),
  1049.                         'customLists' => $customLists,
  1050.                         'menu' => $this -> adminMenu($request),
  1051.                         'userDirs' => $userDirs,
  1052.                         'searchResult' => $searchResult,    
  1053.                         'searchString' => $searchString,
  1054.                         'user' => $user,
  1055.                         'mainMenu' => $this -> adminMainMenu($request)
  1056.                 )
  1057.                 );
  1058.     
  1059.     }    
  1060.     
  1061.    /**
  1062.      * @Route("/listnew", name="listNew")
  1063.      */
  1064.     public function listNewAction(Request $request)
  1065.     {
  1067.         /* we load session data */
  1068.         parent::init($request);
  1069.     
  1070.         $session = $request->getSession();
  1071.     
  1072.         $em = $this->doctrine->getManager();
  1074.         /* we get user */
  1075.         $userId = $session->get('user')->getUserId();
  1076.         $user = $em->getRepository(User::class)->getUser($userId);
  1077.     
  1078.         /* we build login form */
  1079.         $list = new CustomList();
  1080.         $formBuilder = $this->createFormBuilder($list);
  1082.         $formBuilder->add('listName', TextType::class, array(
  1083.                 'required' => true,
  1084.                 'label' => $this->translator->trans('knowledgebase.list_name'),
  1085.                 'attr' => array('class' => 'text_form', 'size' => 22),
  1086.                 'label_attr' => array('class' => 'form_field_label'),
  1087.         ));
  1089.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  1090.                 'attr' => array('class' => 'butt_big')));
  1091.     
  1092.         $form = $formBuilder->getForm();
  1093.         $form->handleRequest($request);
  1094.     
  1095.         if ($request->getMethod() == 'POST') {
  1096.     
  1097.             if ($form->isValid()) {
  1098.                 // perform some action, such as save the object to the database
  1100.                 /* we load users entity manager */
  1101.                 $dem = $this->doctrine->getManager('dynamic_em');
  1102.                 $formData = $form->getData();
  1104.                 print('<br>qqw saving data');
  1105.                 \Doctrine\Common\Util\Debug::dump($formData);
  1107.                 $list->setListName($formData->getListName());
  1109.                 /* we persist and save */
  1110.                 $dem->persist($list);
  1111.                 $dem->flush();
  1112.     
  1113.                 $this->addFlash('notice', 'New list was created.');
  1114.                  
  1115.                 return $this->redirectToRoute('listEdit', array('listId' => $list->getListId()));
  1116.     
  1117.             }
  1118.              
  1119.         }
  1120.     
  1121.         /* we render data */
  1122.         return $this->render('listNew.html.twig',
  1123.                 array(    'form' => $formBuilder->getForm()->createView(),
  1124.                         'headerData' => $this -> getPageHeader($request),
  1125.                         'menu' => $this -> adminMenu($request),
  1126.                         'user' => $user,
  1127.                         'mainMenu' => $this -> adminMainMenu($request)
  1128.                 )
  1129.                 );
  1130.     
  1131.     }       
  1132.     
  1134.     /**
  1135.      * @Route("/listedit/{listId}", name="listEdit")
  1136.      */
  1137.     public function listEditAction(Request $request, $listId)
  1138.     {
  1140.         /* we load session data */
  1141.         parent::init($request);
  1142.         $session = $request->getSession();
  1144.         // we check if any user is logged in
  1145.         if(!$this->isLoggedUser($request)) {
  1146.             return $this->redirectToRoute('login');
  1147.         }   
  1148.     
  1149.         /* we load users entity manager */
  1150.         $em = $this->doctrine->getManager();
  1151.         $dem = $this->doctrine->getManager('dynamic_em');
  1152.     
  1153.         $userId = $session->get('user')->getUserId();
  1154.         $user = $em->getRepository(User::class)->getUser($userId);
  1156.         /* removing list item */
  1157.         if(!empty($request->query->get('removeListItem'))) {
  1158.             $listItem = $dem->getRepository(CustomListItem::class)->removeCustomListItem($request->query->get('removeListItem'));
  1159.             $this->addFlash('notice', 'List item was removed.');
  1160.         }  
  1162.         if(!empty($request->query->get('saveXml'))) {  
  1163.             //print('<br>qqw saving xml');
  1165.             $this->saveListXML($request, $listId);
  1166.             $this->addFlash('notice', 'List was exported to XML.');
  1167.         }      
  1168.     
  1169.         $list = $dem->getRepository(CustomList::class)->getCustomList($listId);
  1170.         $listItems = $dem->getRepository(CustomListItem::class)->getCustomListItems($listId);
  1172.         /* we get file name and paths */
  1173.         $userDirs = $this->getUserFolderPaths($request);
  1175.         /*
  1176.         print('<br>QQW list ID: '.$listId);
  1177.         \Doctrine\Common\Util\Debug::dump($list);
  1178.         */
  1179.     
  1180.         /* we build form for new items */
  1181.         $listItem = new CustomListItem();
  1182.         $formNewItemsBuilder = $this->createFormBuilder($listItem);
  1184.         $formNewItemsBuilder->add('listItemName', TextType::class, array(
  1185.                 'required' => true,
  1186.                 'label' => $this->translator->trans('knowledgebase.new_list_item'),
  1187.                 'attr' => array('class' => 'text_form_file2', 'size' => 35, 'value' => ''),
  1188.                 'label_attr' => array('class' => 'form_field_label'),
  1189.         )); 
  1191.         $formNewItemsBuilder->add('listItemShortDescription', TextType::class, array(
  1192.                 'required' => false,
  1193.                 'label' => $this->translator->trans('knowledgebase.list_short_description'),
  1194.                 'attr' => array('class' => 'text_form_file2', 'size' => 35, 'value' => ''),
  1195.                 'label_attr' => array('class' => 'form_field_label'),
  1196.         ));   
  1198.         $formNewItemsBuilder->add('listItemLongDescription', TextareaType::class, array(
  1199.                 'required' => false,
  1200.                 'label' => $this->translator->trans('knowledgebase.list_item_long_description'),
  1201.                 'attr' => array('class' => 'textarea_form', 'cols' => 50, 'rows' => 3, 'value' => ''),
  1202.                 'label_attr' => array('class' => 'form_textarea_label'),
  1203.         ));         
  1205.         $formNewItemsBuilder->add('clickURL', TextType::class, array(
  1206.                 'required' => false,
  1207.                 'label' => $this->translator->trans('system.link_url'),
  1208.                 'attr' => array('class' => 'text_form_file2', 'size' => 35, 'value' => ''),
  1209.                 'label_attr' => array('class' => 'form_field_label'),
  1210.         ));               
  1212.         $formNewItemsBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('knowledgebase.create_list_item'),
  1213.                 'attr' => array('class' => 'butt_big')));  
  1215.         /* we build edit form */
  1216.         $formBuilder = $this->createFormBuilder($list);
  1217.     
  1218.         $formBuilder->add('listName', TextType::class, array(
  1219.                 'required' => false,
  1220.                 'label' => $this->translator->trans('knowledgebase.list_name'),
  1221.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $list->getListName()),
  1222.                 'label_attr' => array('class' => 'form_field_label')
  1223.         ));
  1225.         $formBuilder->add('linkURL', TextType::class, array(
  1226.                 'required' => false,
  1227.                 'label' => $this->translator->trans('system.link_url'),
  1228.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $list->getLinkURL()),
  1229.                 'label_attr' => array('class' => 'form_field_label')
  1230.         ));   
  1232.         $formBuilder->add('xmlFile', TextType::class, array(
  1233.                 'required' => false,
  1234.                 'label' => $this->translator->trans('system.xml_file'),
  1235.                 'attr' => array('class' => 'text_form', 'size' => 25, 'value' => $list->getXmlFile()),
  1236.                 'label_attr' => array('class' => 'form_field_label')
  1237.         ));  
  1239.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  1240.                 'attr' => array('class' => 'butt_big')));
  1243.         if ($request->getMethod() == 'POST') {
  1245.             $formNewItems = $formNewItemsBuilder->getForm();
  1246.             $formNewItems->handleRequest($request);
  1248.             if ($formNewItems->isValid()) {
  1250.                 $formNewItemsData = $formNewItems->getData();
  1251.                 
  1252.                 /* we load users entity manager */
  1253.                 //$dem = $this->doctrine->getManager('dynamic_em');
  1254.                 $listItem->setListItemName($formNewItemsData->getListItemName());
  1255.                 $listItem->setListItemShortDescription($formNewItemsData->getListItemShortDescription());
  1256.                 $listItem->setListItemLongDescription($formNewItemsData->getListItemLongDescription());
  1257.                 $listItem->setClickURL($formNewItemsData->getClickURL());
  1258.                 $listItem->setListId($listId);
  1260.                 /* we persist and save */
  1261.                 $dem->persist($listItem);
  1262.                 $dem->flush();
  1264.                 $this->addFlash('notice', 'New Item was Created');
  1265.                 
  1266.                 return $this->redirectToRoute('listEdit', array('listId' => $listId));               
  1267.                 
  1268.             }
  1270.             $form = $formBuilder->getForm();
  1271.             $form->handleRequest($request);
  1273.             if ($form->isValid()) {
  1275.                 $formData = $form->getData();
  1276.     
  1277.                 /* we load data from form into contact object */
  1278.                 $list->setListName($formData->getListName());
  1279.                 $list->setXmlFile($formData->getXmlFile());
  1280.                 $list->setLinkURL($formData->getLinkURL());
  1282.                 /* we persist and save */
  1283.                 //$em->persist($contact);
  1284.                 $dem->flush();
  1285.     
  1286.                 $this->addFlash('notice', 'List was updated.');
  1287.     
  1288.                 return $this->redirectToRoute('listEdit', array('listId' => $list->getListId()));
  1289.     
  1290.             }
  1291.     
  1292.         }
  1293.     
  1294.         /* we render data */
  1295.         return $this->render('listEdit.html.twig',
  1296.                 array(  'headerData' => $this -> getPageHeader($request),
  1297.                         'formNewItems' => $formNewItemsBuilder->getForm()->createView(),
  1298.                         'form' => $formBuilder->getForm()->createView(),
  1299.                         'list' => $list,
  1300.                         'listItems' => $listItems,
  1301.                         'userDirs' => $userDirs,
  1302.                         'user' => $user,
  1303.                         'menu' => $this -> adminMenu($request),
  1304.                         'mainMenu' => $this -> adminMainMenu($request)
  1305.                 )
  1306.                 );
  1307.     
  1308.     }      
  1311.     public function saveListXML(Request $request, $listId)
  1312.     { 
  1314.         /* we load session data */
  1315.         parent::init($request);
  1316.         $session = $request->getSession();
  1317.     
  1318.         /* we load users entity manager */
  1319.         $dem = $this->doctrine->getManager('dynamic_em');
  1320.     
  1321.         $userId = $session->get('user')->getUserId();
  1322.         //print('<br>user id: '.$userId);
  1324.         //die('<br>qqw 22 user id: ');          
  1325.     
  1326.         $list = $dem->getRepository(CustomList::class)->getCustomList($listId);
  1327.         $listItems = $dem->getRepository(CustomListItem::class)->getCustomListItems($listId);
  1329.         if(!$this->isUserFolder($request)) {
  1330.             $this->createUserFolder($request);
  1331.         }
  1333.         /* we get file name and paths */
  1334.         $userDirs = $this->getUserFolderPaths($request);
  1335.         if(!empty($list->getXmlFile())) {
  1336.             $fileName = $list->getXmlFile();
  1337.         } else {
  1338.             $fileName = "list_".$listId.".xml";
  1339.         }
  1341.         /*
  1342.         print('<br>QQW list ID: '.$listId);
  1343.         \Doctrine\Common\Util\Debug::dump($list);
  1344.         */
  1346.         $xmlDocument = new \DOMDocument('1.0', 'UTF-8');
  1348.         $style = " 
  1349.             list { display: block; padding-left: 10px; }
  1350.             listItem {
  1351.                 display: block; 
  1352.             }
  1354.             listItem:hover {
  1355.                 display: block;
  1356.                 background-color: #EFEFEF;  
  1357.             }
  1359.             .listItemTitle {
  1360.                 display: inline-block;
  1361.                 /* width: 300px; */
  1362.                 width: 45%;
  1363.                 height: 22px;
  1364.                 padding: 1px;
  1365.                 border: #DDD solid 1px; 
  1366.                 background-color: #EFEFEF;
  1367.             }
  1369.             listItemShortDescription {
  1370.                 display: inline-block;
  1371.                 /* width: 300px; */
  1372.                 width: 45%;
  1373.                 height: 22px;   
  1374.                 padding: 1px;
  1375.                 border: #DDD solid 1px; 
  1376.                 /*  background-color: #EFEFEF;  */
  1377.             }
  1379.             listTitle {
  1380.              font-family : Arial, Helvetica, sans-serif;
  1381.              display: block;
  1382.              font-size : 22px; 
  1383.              font-weight : bold;
  1384.              padding-top: 5px;
  1385.              padding-bottom: 5px; 
  1386.              height: 22px;
  1387.             }
  1389.             listItemAttribute1 {
  1390.              font-family : Arial, Helvetica, sans-serif;
  1391.              display: block;
  1392.              font-size : 22px; 
  1393.              font-weight : bold;
  1394.              padding-top: 5px;
  1395.              padding-bottom: 5px; 
  1396.              height: 22px;
  1397.             }    
  1398.             
  1399.             listItemAttribute2 {
  1400.              font-family : Arial, Helvetica, sans-serif;
  1401.              display: block;
  1402.              font-size : 22px; 
  1403.              font-weight : bold;
  1404.              padding-top: 5px;
  1405.              padding-bottom: 5px; 
  1406.              height: 22px;
  1407.             }                      
  1409.         ";
  1411.         $css = $xmlDocument->createProcessingInstruction("xml-stylesheet", "type=\"text/css\" href=\"https://www.vrcommerce.cz/css/list1.css\"");
  1412.         //$css = $xmlDocument->createProcessingInstruction("xml-stylesheet", "type=\"text/css\" href=\"#style\"");
  1413.         $xmlDocument->appendChild($css); 
  1415.         $rootElement = $xmlDocument->createElement('list');
  1416.         $titleTag = $xmlDocument->createElement('listTitle', $list->getListName());
  1417.         //$titleTag->setAttribute("class", "listTitle");
  1418.         //$titleTag->setAttribute("style", "background-color: #EFEFEF;");
  1419.         $rootElement->appendChild($titleTag);
  1421.         //$styleTag = $xmlDocument->createElement('style', $style);
  1422.         //$styleTag->setAttribute("type", "text/css");
  1423.         //$styleTag->setAttribute("id", "style");
  1424.         //<style type = "text/css">
  1425.         //$rootElement->appendChild($styleTag);
  1427.         $listItemsTag = $xmlDocument->createElement('listItems');
  1429.         foreach($listItems as $listItem) {
  1430.             $listItemsTag = $xmlDocument->createElement('listItem');
  1431.             $listItemsTitleTag = $xmlDocument->createElement('listItemTitle', $listItem->getListItemName()); 
  1432.             $listItemsShortDescriptionTag = $xmlDocument->createElement('listItemShortDescription', $listItem->getListItemShortDescription()); 
  1434.             $listItemsTag->appendChild($listItemsTitleTag);
  1435.             $listItemsTag->appendChild($listItemsShortDescriptionTag);
  1437.             $listItemsLongDescriptionTag = $xmlDocument->createElement('listItemLongDescription');
  1438.             $listItemsLongDescriptionTag->appendChild($xmlDocument->createCDATASection(html_entity_decode(strip_tags($listItem->getListItemLongDescription()))));
  1439.             $listItemsTag->appendChild($listItemsLongDescriptionTag);  
  1442.             $listItemsAttribute1Tag = $xmlDocument->createElement('listItemAttribute1', $listItem->getFreeProperty1()); 
  1443.             $listItemsAttribute2Tag = $xmlDocument->createElement('listItemAttribute2', $listItem->getFreeProperty2()); 
  1444.             $listItemsTag->appendChild($listItemsAttribute1Tag);  
  1445.             $listItemsTag->appendChild($listItemsAttribute2Tag);  
  1447.             $rootElement->appendChild($listItemsTag); 
  1448.         }
  1450.         $xmlDocument->appendChild($rootElement);
  1452.         $xmlDocument->saveXML();
  1453.         $xmlDocument->save($userDirs['user'].'/'.$fileName);
  1455.         $list->setXmlFile($fileName);
  1456.         $dem->persist($list);
  1457.         $dem->flush();
  1459.         /*
  1460.         $response = new Response($xmlDocument->saveXML());
  1461.         $response->headers->set('Content-Type', 'xml');
  1462.         */
  1463.         
  1464.         //return $response;
  1466.     
  1467.         /* we render data */
  1468.         /*
  1469.         return $this->render('listXML.html.php',
  1470.                 array(  'headerData' => $this -> getPageHeader($request),
  1471.                         'list' => $list,
  1472.                         'listItems' => $listItems,
  1473.                 )
  1474.                 );
  1475.         */
  1476.     
  1477.     }          
  1480.     /**
  1481.      * @Route("/listitemedit/{listItemId}", name="listItemEdit")
  1482.      */
  1483.     public function listItemEditAction(Request $request, $listItemId)
  1484.     {
  1486.         /* we load session data */
  1487.         parent::init($request);
  1488.         $session = $request->getSession();
  1490.         // we check if any user is logged in
  1491.         if(!$this->isLoggedUser($request)) {
  1492.             return $this->redirectToRoute('login');
  1493.         }   
  1494.     
  1495.         /* we load users entity manager */
  1496.         $em = $this->doctrine->getManager();
  1497.         $dem = $this->doctrine->getManager('dynamic_em');
  1498.     
  1499.         $userId = $session->get('user')->getUserId();
  1500.         $user = $em->getRepository(User::class)->getUser($userId);
  1501.     
  1502.         $listItem = $dem->getRepository(CustomListItem::class)->getCustomListItem($listItemId);
  1503.         $list = $dem->getRepository(CustomList::class)->getCustomList($listItem->getListId());
  1505.         /*
  1506.         print('<br>QQW list ID: '.$listId);
  1507.         \Doctrine\Common\Util\Debug::dump($list);
  1508.         */
  1510.         /* we build edit form */
  1511.         $formBuilder = $this->createFormBuilder($listItem);
  1512.     
  1513.         $formBuilder->add('listItemName', TextType::class, array(
  1514.                 'required' => false,
  1515.                 'label' => $this->translator->trans('knowledgebase.list_item_name'),
  1516.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $listItem->getListItemName()),
  1517.                 'label_attr' => array('class' => 'form_field_label')
  1518.         ));
  1520.         $formBuilder->add('listItemShortDescription', TextareaType::class, array(
  1521.                 'required' => false,
  1522.                 'label' => $this->translator->trans('knowledgebase.list_item_short_description'),
  1523.                 'attr' => array('class' => 'textarea_form', 'cols' => 55, 'rows' => 4, 'value' => $listItem->getListItemShortDescription()),
  1524.                 'label_attr' => array('class' => 'form_textarea_label'),
  1525.                 'data' => $listItem->getListItemShortDescription(),
  1526.         ));      
  1528.         $formBuilder->add('clickURL', TextType::class, array(
  1529.                 'required' => false,
  1530.                 'label' => $this->translator->trans('system.link_url'),
  1531.                 'attr' => array('class' => 'text_form', 'size' => 53, 'value' => $listItem->getClickURL()),
  1532.                 'label_attr' => array('class' => 'form_field_label')
  1533.         ));         
  1535.         $formBuilder->add('listItemLongDescription', TextareaType::class, array(
  1536.                 'required' => false,
  1537.                 'label' => $this->translator->trans('knowledgebase.list_item_long_description'),
  1538.                 'attr' => array('class' => 'textarea_form', 'cols' => 101, 'rows' => 5, 'value' => $listItem->getListItemLongDescription()),
  1539.                 'label_attr' => array('class' => 'form_textarea_label'),
  1540.                 'data' => $listItem->getListItemLongDescription(),
  1541.         )); 
  1543.         $formBuilder->add('freeProperty1', TextType::class, array(
  1544.                 'required' => false,
  1545.                 'label' => $this->translator->trans('knowledgebase.list_item_free_property1'),
  1546.                 'attr' => array('class' => 'text_form', 'size' => 53, 'value' => $listItem->getFreeProperty1()),
  1547.                 'label_attr' => array('class' => 'form_field_label')
  1548.         ));      
  1550.         $formBuilder->add('freeProperty2', TextType::class, array(
  1551.                 'required' => false,
  1552.                 'label' => $this->translator->trans('knowledgebase.list_item_free_property2'),
  1553.                 'attr' => array('class' => 'text_form', 'size' => 53, 'value' => $listItem->getFreeProperty2()),
  1554.                 'label_attr' => array('class' => 'form_field_label')
  1555.         ));               
  1557.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  1558.                 'attr' => array('class' => 'butt_big')));
  1560.         $form = $formBuilder->getForm();
  1561.         $form->handleRequest($request);
  1562.     
  1563.         if ($request->getMethod() == 'POST') {
  1566.             if ($form->isValid()) {
  1567.                 // perform some action, such as save the object to the database
  1568.                 //print('<br>qqw post form 2: ');
  1569.                 $formData = $form->getData();
  1570.     
  1571.                 /* we load data from form into contact object */
  1572.                 $listItem->setListItemName($formData->getListItemName());
  1573.                 $listItem->setListItemShortDescription($formData->getListItemShortDescription());
  1574.                 $listItem->setListItemLongDescription($formData->getListItemLongDescription());
  1575.                 $listItem->setClickURL($formData->getClickURL());
  1576.                 $listItem->setFreeProperty1($formData->getFreeProperty1());
  1577.                 $listItem->setFreeProperty2($formData->getFreeProperty2());
  1579.                 /* we persist and save */
  1580.                 //$em->persist($contact);
  1581.                 $dem->flush();
  1582.     
  1583.                 $this->addFlash('notice', 'List item was updated.');
  1584.     
  1585.                 return $this->redirectToRoute('listEdit', array('listId' => $listItem->getListId()));
  1586.     
  1587.             }
  1588.     
  1589.         }
  1590.     
  1591.         /* we render data */
  1592.         return $this->render('listItemEdit.html.twig',
  1593.                 array(  'headerData' => $this -> getPageHeader($request),
  1594.                         'form' => $formBuilder->getForm()->createView(),
  1595.                         'list' => $list,
  1596.                         'listItem' => $listItem,
  1597.                         'menu' => $this -> adminMenu($request),
  1598.                         'user' => $user,
  1599.                         'mainMenu' => $this -> adminMainMenu($request)
  1600.                 )
  1601.                 );
  1602.     
  1603.     }    
  1607.     /**
  1608.      * @Route("/tradeLead", name="tradeLead")
  1609.      */
  1610.     public function tradeLeadAction(Request $request)
  1611.     {
  1612.     
  1613.         /* we load session data */
  1614.         parent::init($request);
  1615.         $session = $request->getSession();
  1616.     
  1617.         /* we load users entity manager */
  1618.         $em = $this->doctrine->getManager();
  1619.         $dem = $this->doctrine->getManager('dynamic_em');
  1621.         $userId = $session->get('user')->getUserId();
  1622.         $user = $em->getRepository(User::class)->getUser($userId);
  1624.         /* removing tradelead */
  1625.         if(!empty($request->query->get('removeLead'))) {   
  1627.             try {
  1628.                 $tradeLead = $dem->getRepository(TradeLead::class)->removeTradeLead($request->query->get('removeLead'));
  1629.                 $this->addFlash('notice', 'Trade Lead was removed.');
  1630.             } catch(\Doctrine\DBAL\DBALException $e) {
  1631.                 $this->addFlash('error', "This Trade Lead has connected services (orders etc.), so it can't be removed.");
  1632.             }
  1633.             
  1634.         }         
  1636.         /* import tradelead */
  1637.         if(!empty($request->query->get('importLeads'))) {   
  1639.             print('<br>qqw import leads');
  1641.             ini_set('max_execution_time', 1800); 
  1642.             set_time_limit(1800);
  1644.             $mem = $this->doctrine->getManager('marketplace_em');
  1645.             $marketplaceConn = $mem->getConnection('marketplace_conn');
  1647.             $sql = "SELECT * FROM eshops e INNER JOIN eshops_description ed ON e.id_shop = ed.id_shop AND ed.title != ''";
  1648.             $stmt = $marketplaceConn->prepare($sql);
  1649.             $stmt->execute();
  1650.             $result = $stmt->fetchAll();
  1652.             foreach($result as $row) {
  1653.                 print('<hr>row: ');
  1654.                 \Doctrine\Common\Util\Debug::dump($row);
  1656.                 $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(array('externalId' => $row['id_shop']));
  1658.                 if(empty($tradeLead)) {
  1659.                     $tradeLead = new TradeLead;
  1660.                 }
  1662.                 $tradeLead->setTitle($row['title']);
  1663.                 $tradeLead->setDescription($row['description']);
  1664.                 $tradeLead->setNotes($row['notes']);
  1665.                 $tradeLead->setEmail($row['email']);  
  1666.                 $tradeLead->setStatus($row['status']);              
  1667.                 $tradeLead->setContactPersonEmail($row['email_director']);   
  1668.                 $tradeLead->setLinkUrl($row['url']);  
  1669.                 $tradeLead->setExternalId($row['id_shop']);  
  1671.                 print('<br>tradeLead: ');
  1672.                 \Doctrine\Common\Util\Debug::dump($tradeLead);
  1673.    
  1675.                 /* we persist and save */
  1676.                 $dem->persist($tradeLead);
  1677.                 $dem->flush();
  1679.             }
  1680.             
  1682.         } 
  1683.     
  1684.         $tradeLeadList = $dem->getRepository(TradeLead::class)->findAll();
  1686.         /* we render data */
  1687.         return $this->render('tradeLeads.html.twig',
  1688.                 array(  'headerData' => $this -> getPageHeader($request),
  1689.                         'tradeLeadList' => $tradeLeadList,
  1690.                         'menu' => $this -> adminMenu($request),
  1691.                         'user' => $user,
  1692.                         'mainMenu' => $this -> adminMainMenu($request)
  1693.                 )
  1694.                 );
  1695.     
  1696.     }    
  1698.     /**
  1699.      * @Route("/tradeLeadExec", name="tradeLeadExec")
  1700.      */
  1701.     public function tradeLeadExecAction(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.         /* we get user */ 
  1713.         $userId = $session->get('user')->getUserId();
  1714.         $user = $em->getRepository(User::class)->getUser($userId);
  1715.         $userDirs = $this->getUserFolderPaths($request);
  1717.         $selectedTradeLeads = array();
  1718.         if(!empty($request->request->get('selectedTradeLeads'))) {
  1719.             //print(' tradeleads POSTED');
  1721.             $selectedTradeLeads = $request->request->get('selectedTradeLeads');
  1723.             $leadList = json_encode($selectedTradeLeads);
  1725.             //\Doctrine\Common\Util\Debug::dump($request->request->get('selectedTradeLeads'));
  1726.         }
  1728.         if(!empty($request->request->get('form')['leadList'])) {
  1729.             $leadList = $request->request->get('form')['leadList'];
  1730.         }
  1732.         $emailSubject = '';
  1733.         if(!empty($request->request->get('form')['emailSubject'])) {
  1734.             $emailSubject = $request->request->get('form')['emailSubject'];
  1735.         }
  1736.         $emailBodyHtml = '';
  1737.         if(!empty($request->request->get('form')['emailBodyHtml'])) {
  1738.             $emailBodyHtml = $request->request->get('form')['emailBodyHtml'];
  1739.         }       
  1741.         //Doctrine\Common\Util\Debug::dump($request->request->get('selectedTradeLeads'));
  1742.         //$tradeLeadList = $dem->getRepository(TradeLead::class)->findAll();
  1743.         
  1744.        
  1745.         /* we build edit form */
  1746.         $formBuilder = $this->createFormBuilder();
  1748.         $formBuilder->add('emailSubject', TextType::class, array(
  1749.                 'required' => false,
  1750.                 'label' => 'email subject',
  1751.                 'attr' => array('class' => 'text_form', 'size' => 70, 'value' => $emailSubject),
  1752.                 'label_attr' => array('class' => 'form_field_label'),
  1753.         ));         
  1754.        
  1755.          $formBuilder->add('emailBodyHtml', CKEditorType::class, array(
  1756.                 'required' => false,
  1757.                 'label' => 'html email',
  1758.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $emailBodyHtml),
  1759.                 'label_attr' => array('class' => 'form_field_label'),
  1760.                 'data' => $emailBodyHtml,
  1761.         )); 
  1765.         $formBuilder->add('leadList', HiddenType::class, array(
  1766.                 'data' => $leadList,
  1767.         ));         
  1769.         $formBuilder->add('save', SubmitType::class, array('label' => 'Execute Action',
  1770.                 'attr' => array('class' => 'butt_big')));
  1771.          
  1772.         $form = $formBuilder->getForm();
  1773.          
  1774.         $form->handleRequest($request);
  1775.          
  1776.         if ($request->getMethod() == 'POST') {
  1777.              
  1778.             //$form->bindRequest($request);
  1779.              
  1780.             if ($form->isValid()) {
  1781.                 // perform some action, such as save the object to the database
  1783.                 //print('<br>tradeleads ids json: ');
  1784.                 //print_r($request->request->get('form')['selectedTradeLeads']);
  1786.                 $leadIdList = json_decode($request->request->get('form')['leadList']);
  1788.                 foreach($leadIdList as $leadId) {
  1789.                     
  1790.                     $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(array('tradeLeadId' => $leadId));
  1791.                     print('<hr>executing on lead: '.$tradeLead->getTitle().' , id: '.$leadId);
  1792.                     //Doctrine\Common\Util\Debug::dump($tradeLead);
  1793.                     //print_r($tradeLead);
  1795.                     $now = new \DateTime();
  1796.                     $nowDate = $now->format('Y-m-d H:i:s'); 
  1798.                     if(!empty($tradeLead->getEmail())) {
  1800.                         $to = $tradeLead->getEmail();
  1801.                         $subject = $emailSubject;
  1802.                         $message = $emailBodyHtml;
  1803.                         $name = $user->getCompany();
  1804.                         $from = $user->getEmail();
  1806.                         $headers  = "MIME-Version: 1.0\r\n";
  1807.                         $headers .= "Content-type: text/html; charset=UTF-8\r\n";
  1808.                         $headers .= "From: {$name} <{$from}>\r\n";
  1809.                         $headers .= "Reply-To: <{$from}>\r\n";
  1810.                         $headers .= "Subject: {$subject}\r\n";
  1811.                         $headers .= "X-Mailer: PHP/".phpversion()."\r\n";
  1812.                         
  1813.                         /* we send email to e-shop admin */
  1814.                         if(@mail($to, $subject, $message, $headers)) {
  1815.                             $message = '['.$nowDate.'] Email `'.$emailSubject.'` was sent to: '.$to;
  1816.                             print('<br>'.$message);
  1817.                             $tradeLead->setNotes($tradeLead->getNotes()."\n".$message);
  1818.                         } else {
  1819.                             print('<br>Email was not sent to: '.$to);
  1820.                         }   
  1822.                     }
  1824.                     if(!empty($tradeLead->getContactPersonEmail())) {
  1826.                         $to = $tradeLead->getContactPersonEmail();
  1827.                         $subject = $emailSubject;
  1828.                         $message = $emailBodyHtml;
  1829.                         $name = $user->getCompany();
  1830.                         $from = $user->getEmail();
  1832.                         $headers  = "MIME-Version: 1.0\r\n";
  1833.                         $headers .= "Content-type: text/html; charset=UTF-8\r\n";
  1834.                         $headers .= "From: {$name} <{$from}>\r\n";
  1835.                         $headers .= "Reply-To: <{$from}>\r\n";
  1836.                         $headers .= "Subject: {$subject}\r\n";
  1837.                         $headers .= "X-Mailer: PHP/".phpversion()."\r\n";
  1838.                         
  1839.                         /* we send email to e-shop admin */
  1840.                         if(@mail($to, $subject, $message, $headers)) {
  1841.                             $message = '['.$nowDate.'] Email `'.$emailSubject.'` was sent to: '.$to;
  1842.                             print('<br>'.$message);
  1843.                             $tradeLead->setNotes($tradeLead->getNotes()."\n".$message);
  1844.                         } else {
  1845.                             print('<br>Email was not sent to: '.$to); 
  1846.                         }   
  1848.                     }  
  1850.                     $dem->persist($tradeLead);
  1851.                     $dem->flush();                  
  1853.                 }
  1855.                 //Doctrine\Common\Util\Debug::dump($request->request->get('form')['emailSubject']);
  1858.                 $this->addFlash('notice', 'Trade Lead Action was executed.');
  1860.                  
  1861.             }
  1862.              
  1863.         }        
  1865.         /* we render data */
  1866.         return $this->render('tradeLeadExec.html.php',
  1867.                 array(  'headerData' => $this -> getPageHeader($request),
  1868.                         'form' => $formBuilder->getForm()->createView(),
  1869.                         'selectedTradeLeads' => $selectedTradeLeads,
  1870.                         'leadList' => $leadList,                        
  1871.                         'menu' => $this -> adminMenu($request),
  1872.                         'mainMenu' => $this -> adminMainMenu($request)
  1873.                 )
  1874.                 );
  1875.     
  1876.     }        
  1878.     /**
  1879.      * @Route("/tradeleadedit/{tradeLeadId}", name="tradeLeadEdit")
  1880.      */
  1881.     public function tradeLeadEditAction(Request $request, $tradeLeadId)
  1882.     {
  1884.         /* we load session data */
  1885.         parent::init($request);
  1886.         $session = $request->getSession();
  1887.     
  1888.         /* we load entity managers */
  1889.         $em = $this->doctrine->getManager();
  1890.         $dem = $this->doctrine->getManager('dynamic_em');
  1891.     
  1892.         $userId = $session->get('user')->getUserId();
  1893.         $user = $em->getRepository(User::class)->getUser($userId);
  1894.     
  1895.         $tradeLead = $dem->getRepository(TradeLead::class)->findOneBy(array('tradeLeadId' => $tradeLeadId));
  1897.         /* we build edit form */ 
  1898.         $formBuilder = $this->createFormBuilder($tradeLead);
  1899.     
  1900.         $formBuilder->add('title', TextType::class, array(
  1901.                 'required' => false,
  1902.                 'label' => $this->translator->trans('marketplace.trade_lead_title'),
  1903.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getTitle()),
  1904.                 'label_attr' => array('class' => 'form_field_label')
  1905.         ));
  1906.         
  1907.         $formBuilder->add('company', TextType::class, array(
  1908.                 'required' => false,
  1909.                 //'label' => $this->translator->trans('knowledgebase.middle_name'),
  1910.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getCompany()),
  1911.                 'label_attr' => array('class' => 'form_field_label')
  1912.         ));     
  1913.         
  1914.         $formBuilder->add('email', TextType::class, array(
  1915.                 'required' => false,
  1916.                 //'label' => $this->translator->trans('knowledgebase.last_name'),
  1917.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getEmail()),
  1918.                 'label_attr' => array('class' => 'form_field_label')
  1919.         ));  
  1921.         $formBuilder->add('linkUrl', TextType::class, array(
  1922.                 'required' => false,
  1923.                 //'label' => $this->translator->trans('knowledgebase.middle_name'),
  1924.                 'attr' => array('class' => 'text_form', 'size' => 91, 'value' => $tradeLead->getLinkUrl()),
  1925.                 'label_attr' => array('class' => 'form_field_label')
  1926.         ));            
  1928.         $formBuilder->add('description', TextareaType::class, array(
  1929.                 'required' => false,
  1930.                 //'label' => $this->translator->trans('knowledgebase.list_item_short_description'),
  1931.                 'attr' => array('class' => 'textarea_form', 'cols' => 90, 'rows' => 10, 'value' => $tradeLead->getDescription()),
  1932.                 'label_attr' => array('class' => 'form_textarea_label'),
  1933.                 'data' => $tradeLead->getDescription(),
  1934.         ));  
  1936.         $formBuilder->add('notes', TextareaType::class, array(
  1937.                 'required' => false,
  1938.                 //'label' => $this->translator->trans('knowledgebase.list_item_short_description'),
  1939.                 'attr' => array('class' => 'textarea_form', 'cols' => 90, 'rows' => 10, 'value' => $tradeLead->getNotes()),
  1940.                 'label_attr' => array('class' => 'form_textarea_label'),
  1941.                 'data' => $tradeLead->getNotes(),
  1942.         ));  
  1944.         $formBuilder->add('contactPerson', TextType::class, array(
  1945.                 'required' => false,
  1946.                 //'label' => $this->translator->trans('knowledgebase.company_name'),
  1947.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getContactPerson()),
  1948.                 'label_attr' => array('class' => 'form_field_label')
  1949.         ));         
  1951.         $formBuilder->add('contactPersonEmail', TextType::class, array(
  1952.                 'required' => false,
  1953.                 //'label' => $this->translator->trans('knowledgebase.email'),
  1954.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getContactPersonEmail()),
  1955.                 'label_attr' => array('class' => 'form_field_label')
  1956.         ));           
  1958.         $formBuilder->add('telephone', TextType::class, array(
  1959.                 'required' => false,
  1960.                 //'label' => $this->translator->trans('knowledgebase.email'),
  1961.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getTelephone()),
  1962.                 'label_attr' => array('class' => 'form_field_label')
  1963.         ));         
  1965.         $formBuilder->add('address', TextType::class, array(
  1966.                 'required' => false,
  1967.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  1968.                 'attr' => array('class' => 'text_form', 'size' => 91, 'value' => $tradeLead->getAddress()),
  1969.                 'label_attr' => array('class' => 'form_field_label')
  1970.         ));   
  1972.         $formBuilder->add('invoiceAddress', TextType::class, array(
  1973.                 'required' => false,
  1974.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  1975.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getInvoiceAddress()),
  1976.                 'label_attr' => array('class' => 'form_field_label')
  1977.         ));  
  1979.         $formBuilder->add('responsibleAdminUserId', TextType::class, array(
  1980.                 'required' => false,
  1981.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  1982.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getResponsibleAdminUserId()),
  1983.                 'label_attr' => array('class' => 'form_field_label')
  1984.         ));  
  1987.         $formBuilder->add('dateResponsibilityGiven', TextType::class, array(
  1988.                 'required' => false,
  1989.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  1990.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getDateResponsibilityGiven()),
  1991.                 'label_attr' => array('class' => 'form_field_label')
  1992.         ));  
  1994.         $formBuilder->add('status', TextType::class, array(
  1995.                 'required' => false,
  1996.                 //label' => $this->translator->trans('knowledgebase.phone'),
  1997.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getStatus()),
  1998.                 'label_attr' => array('class' => 'form_field_label')
  1999.         ));  
  2001.         $formBuilder->add('serverId', TextType::class, array(
  2002.                 'required' => false,
  2003.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2004.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getServerId()),
  2005.                 'label_attr' => array('class' => 'form_field_label')
  2006.         ));  
  2008.         $formBuilder->add('areaId', TextType::class, array(
  2009.                 'required' => false,
  2010.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2011.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getAreaId()),
  2012.                 'label_attr' => array('class' => 'form_field_label')
  2013.         ));  
  2015.         $formBuilder->add('preferredSectionId', TextType::class, array(
  2016.                 'required' => false,
  2017.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2018.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getPreferredSectionId()),
  2019.                 'label_attr' => array('class' => 'form_field_label')
  2020.         ));  
  2022.         $formBuilder->add('preferredSectionId2', TextType::class, array(
  2023.                 'required' => false,
  2024.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2025.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getPreferredSectionId2()),
  2026.                 'label_attr' => array('class' => 'form_field_label')
  2027.         ));  
  2029.         $formBuilder->add('avatarUrl', TextType::class, array(
  2030.                 'required' => false,
  2031.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2032.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getAvatarUrl()),
  2033.                 'label_attr' => array('class' => 'form_field_label')
  2034.         ));  
  2036.         $formBuilder->add('logoUrl', TextType::class, array(
  2037.                 'required' => false,
  2038.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2039.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getLogoUrl()),
  2040.                 'label_attr' => array('class' => 'form_field_label')
  2041.         ));  
  2043.         $formBuilder->add('bankAccount', TextType::class, array(
  2044.                 'required' => false,
  2045.                 //'label' => $this->translator->trans('knowledgebase.phone'),
  2046.                 'attr' => array('class' => 'text_form', 'size' => 35, 'value' => $tradeLead->getBankAccount()),
  2047.                 'label_attr' => array('class' => 'form_field_label')
  2048.         ));                                                                          
  2050.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  2051.                 'attr' => array('class' => 'butt_big')));
  2052.     
  2053.         $form = $formBuilder->getForm();
  2054.         $form->handleRequest($request);
  2055.     
  2056.         if ($request->getMethod() == 'POST') {
  2058.             if ($form->isValid()) {
  2060.                 $formData = $form->getData();
  2061.     
  2062.                 /* we load data from form into TradeLead object */
  2063.                 $tradeLead->setTitle($formData->getTitle());
  2064.                 $tradeLead->setCompany($formData->getCompany());
  2065.                 $tradeLead->setEmail($formData->getEmail());
  2066.                 $tradeLead->setLinkUrl($formData->getLinkUrl());
  2067.                 $tradeLead->setContactPerson($formData->getContactPerson());
  2069.                 $tradeLead->setContactPersonEmail($formData->getContactPerson());
  2070.                 $tradeLead->setTelephone($formData->getTelephone());
  2071.                 $tradeLead->setNotes($formData->getNotes());
  2072.                 $tradeLead->setDescription($formData->getDescription());
  2073.                 $tradeLead->setAddress($formData->getAddress());
  2074.                 $tradeLead->setInvoiceAddress($formData->getInvoiceAddress());
  2075.                 $tradeLead->setResponsibleAdminUserId($formData->getResponsibleAdminUserId());
  2076.                 //$tradeLead->setDateResponsibilityGiven($request->request->get('form')['dateResponsibilityGiven']);                
  2078.                 $tradeLead->setStatus($formData->getStatus());
  2079.                 $tradeLead->setServerId($formData->getServerId());
  2080.                 $tradeLead->setAreaId($formData->getAreaId());
  2081.                 $tradeLead->setPreferredSectionId($formData->getPreferredSectionId());
  2082.                 $tradeLead->setPreferredSectionId2($formData->getPreferredSectionId2());
  2084.                 $tradeLead->setAvatarUrl($formData->getAvatarUrl());
  2085.                 $tradeLead->setLogoUrl($formData->getLogoUrl());
  2086.                 $tradeLead->setBankAccount($formData->getBankAccount());
  2088.                 /* we persist and save */
  2089.                 $dem->persist($tradeLead);
  2090.                 $dem->flush();
  2091.     
  2092.                 $this->addFlash('notice', 'Trade Lead was updated.');
  2093.     
  2094.                 return $this->redirectToRoute('tradeLeadEdit', array('tradeLeadId' => $tradeLead->getTradeLeadId()));
  2095.     
  2096.             }
  2097.     
  2098.         }
  2099.     
  2100.         /* we render data */
  2101.         return $this->render('tradeLeadEdit.html.twig',
  2102.                 array(  'headerData' => $this -> getPageHeader($request),
  2103.                         'form' => $formBuilder->getForm()->createView(),
  2104.                         'tradeLead' => $tradeLead,
  2105.                         'menu' => $this -> adminMenu($request),
  2106.                         'mainMenu' => $this -> adminMainMenu($request),
  2107.                         'user' => $user
  2108.                 )
  2109.                 );
  2110.     
  2111.     }   
  2113.     /**
  2114.      * @Route("/tradeLeadNew", name="tradeLeadNew")
  2115.      */
  2116.     public function tradeLeadNewAction(Request $request)
  2117.     {
  2119.         /* we load session data */
  2120.         parent::init($request);
  2121.     
  2122.         $session = $request->getSession();
  2124.         /* we load users entity manager */
  2125.         $em = $this->doctrine->getManager();
  2126.         $dem = $this->doctrine->getManager('dynamic_em');
  2128.         $userId = $session->get('user')->getUserId();
  2129.         $user = $em->getRepository(User::class)->getUser($userId);
  2130.     
  2131.         /* we build login form */
  2132.         $tradeLead = new TradeLead();
  2133.         $formBuilder = $this->createFormBuilder($tradeLead);
  2134.     
  2135.         $formBuilder->add('title', TextType::class, array(
  2136.                 'required' => true,
  2137.                 'label' => $this->translator->trans('marketplace.trade_lead_title'),
  2138.                 'attr' => array('class' => 'text_form', 'size' => 22),
  2139.                 'label_attr' => array('class' => 'form_field_label'),
  2140.         ));
  2141.         
  2143.         $formBuilder->add('save', SubmitType::class, array('label' => $this->translator->trans('form.button.save'),
  2144.                 'attr' => array('class' => 'butt_big')));
  2145.     
  2146.         $form = $formBuilder->getForm();
  2147.         $form->handleRequest($request);
  2148.     
  2149.         if ($request->getMethod() == 'POST') {
  2150.     
  2151.             if ($form->isValid()) {
  2152.                 // perform some action, such as save the object to the database
  2153.     
  2154.                 /* we load users entity manager */
  2155.                 $dem = $this->doctrine->getManager('dynamic_em');
  2157.                 $formData = $form->getData();
  2159.                 $tradeLead->setTitle($formData->getTitle());
  2161.                 /* we persist and save */
  2162.                 $dem->persist($tradeLead);
  2163.                 $dem->flush();
  2164.     
  2165.                 $this->addFlash('notice', 'New Trade lead was created.');
  2166.                  
  2167.                 return $this->redirectToRoute('tradeLeadEdit', array('tradeLeadId' => $tradeLead->getTradeLeadId()));
  2168.     
  2169.             }
  2170.              
  2171.         }
  2172.     
  2173.         /* we render data */
  2174.         return $this->render('tradeLeadNew.html.twig',
  2175.                 array(  'form' => $formBuilder->getForm()->createView(),
  2176.                         'headerData' => $this -> getPageHeader($request),
  2177.                         'menu' => $this -> adminMenu($request),
  2178.                         'mainMenu' => $this -> adminMainMenu($request),
  2179.                         'user' => $user
  2180.                 )
  2181.                 );
  2182.     
  2183.     }
  2186.     
  2187.     public function adminMenu(Request $request)
  2188.     {
  2189.         $menuItems = array(
  2190.           1 => array('link' => 'knowledgebaseAdmin', 'langKey' => 'knowledgebase.admin', 'routeName' => 'knowledgebaseAdmin'),
  2191.           2 => array('link' => 'contacts', 'langKey' => 'knowledgebase.contacts', 'routeName' => 'contacts'),
  2192.           3 => array('link' => 'contactnew', 'langKey' => 'knowledgebase.new_contact', 'routeName' => 'contactNew'),
  2193.           4 => array('link' => 'tasks', 'langKey' => 'knowledgebase.tasks', 'routeName' => 'tasks'),
  2194.           5 => array('link' => 'tasknew', 'langKey' => 'knowledgebase.new_task', 'routeName' => 'taskNew'),                
  2195.           6 => array('link' => 'lists', 'langKey' => 'knowledgebase.lists', 'routeName' => 'lists'),
  2196.           7 => array('link' => 'listnew', 'langKey' => 'knowledgebase.new_list', 'routeName' => 'listNew'),
  2197.         );
  2199.         return $menuItems;
  2200.     }
  2201.     
  2202. }