src/Controller/BaseController.php line 67

Open in your IDE?
  1. <?php
  2. namespace App\Controller;
  4. use App\Bitrix\CRest;
  5. use App\Entity\Menu;
  6. use App\Entity\Order;
  7. use App\Entity\Page;
  8. use App\Entity\PageBlock;
  10. use App\Service\SmsService;
  11. use Doctrine\Persistence\ManagerRegistry;
  12. use Mpdf\Mpdf;
  13. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use Symfony\Component\Routing\Annotation\Route;
  19. class BaseController extends AbstractController
  20. {
  21.     public function header(ManagerRegistry $doctrine, $route, $request, $action = null): Response
  22.     {
  23.         $em = $doctrine->getManager();
  24.         $menuItems = $em->getRepository(Menu::class)->findBy(['enabled'=>true, 'parent'=>null], ['sort'=>'ASC']);
  26.         $menus = [
  27.             'about'=> $em->getRepository(Page::class)->findOneBy(['slug' => 'about']),
  28.             'project'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'project']),
  29.             'korolev'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'korolev']),
  30.             'publications'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'publications']),
  31.             'contacts'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'contacts']),
  32.             'region'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'o-regione']),
  33. //            'jukovskii'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'jukovskii'])
  34.         ];
  36.         return $this->render('new/base/header.html.twig', [
  37.             'items' => $menuItems, 'route'=> $route, 'request' => $request, 'action' => $action, 'menus' => $menus]);
  38.     }
  40.     public function headerNew(ManagerRegistry $doctrine, $route, $request, $action = null): Response
  41.     {
  42.         $em = $doctrine->getManager();
  43.         $menuItems = $em->getRepository(Menu::class)->findBy(['enabled'=>true, 'parent'=>null], ['sort'=>'ASC']);
  45.         $menus = [
  46.             'about'=> $em->getRepository(Page::class)->findOneBy(['slug' => 'about']),
  47.             'project'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'project']),
  48.             'korolev'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'korolev']),
  49.             'publications'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'publications']),
  50.             'contacts'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'contacts']),
  51.             'region'=>  $em->getRepository(Page::class)->findOneBy(['slug' => 'o-regione'])
  52.         ];
  54.         return $this->render('new/index/jukovskii_header.html.twig', [
  55.             'items' => $menuItems, 'route'=> $route, 'request' => $request, 'action' => $action, 'menus' => $menus]);
  56.     }
  58.     public function siteSelected(){
  59.         return $this->render('base/site_selected.html.twig');
  60.     }
  62.     #[Route('/map', name: "app_map")]
  63.     public function map(){
  64.         return $this->render('new/index/map.html.twig');
  65.     }
  67.     public function modal(ManagerRegistry $doctrine, $modalName){
  68.         $modal = $doctrine->getRepository(PageBlock::class)->findOneBy(['name'=>$modalName]);
  69.         if ($modal){
  70.             return $this->render('new/modals/modal_template.html.twig', ['modal'=> $modal]);
  71.         }else{
  72.             return  new Response();
  73.         }
  75.     }
  76.     #[Route('/order/{orderNumber}', defaults: ['orderNumber' => null])]
  77.     public function orderAction(Request $request, \Swift_Mailer $mailer, $orderNumber = null){
  78.         if ($orderNumber && $request->getMethod() != 'POST'){
  79.             $data = CRest::call(
  80.                 'crm.deal.get',
  81.                 [ 'id' => $orderNumber ]
  82.             );
  83.             if ($data['result']['UF_CRM_1682083532812'] == '1804'){
  84.                 return $this->redirectToRoute('app_index');
  85.             }
  86.         }
  88.         if ($request->getMethod() == 'POST'){
  91. //            ')
  92.             $order = new Order();
  93.             $order->setCompanyTitle($request->request->get('companyTitle'));
  94.             $order->setCompanyInn($request->request->get('inn'));
  95.             $order->setCompanyKpp($request->request->get('ogrn'));
  96.             $order->setCompanyCity($request->request->get('city'));
  97.             $order->setIndustry($request->request->get('a2-5'));
  98.             $order->setIndustryDesc($request->request->get('a2-1'));
  99.             $order->setProjectType($request->request->get('a2-2'));
  100.             $order->setSiteOrBuilding($request->request->get('a3-1'));
  101.             $order->setBuyOrRent($request->request->get('a3-2'));
  102.             $order->setDirection($request->request->get('a3-3'));
  103.             $order->setRemotenessByMkad($request->request->get('a3-4-1'));
  104.             $order->setSquareMin(isset($_POST['a4-1-1']) ? $_POST['a4-1-1'] : 0);
  105.             $order->setSquareMax(isset($_POST['a4-1-2']) ? $_POST['a4-1-2'] : 0);
  107.             $order->setHeightMin(isset($_POST['a4-4-1']) ? $_POST['a4-4-1'] : 0);
  108.             $order->setHeightMin(isset($_POST['a4-4-2']) ? $_POST['a4-4-2'] : 0);
  110. //            $order->setHeightMin($_POST['a4-4-1']);
  111. //            $order->setHeightMax($_POST['a4-4-2']);
  113.             $order->setLandAreaMin($request->request->get('a3-5-1'));
  114.             $order->setLendAreaMax($request->request->get('a3-5-2'));
  116.             $order->setClassZone($request->request->get('a5-1', ''));
  117.             $order->setRzd($request->request->get('a6-1'));
  120.             $order->setPowerSupply($request->request->get('a7-1-1'));
  121.             $order->setGasSupply($request->request->get('a7-2-1'));
  122.             $order->setWaterDisposal($request->request->get('a7-4-1'));
  123.             $order->setWaterSupply($request->request->get('a7-6-1'));
  125.             $order->setWorkPeople($request->request->get('a8-1-1'));
  126.             $order->setInvestCount($request->request->get('a9-1'));
  127.             $order->setTaxCount($request->request->get('a9-2'));
  128.             $order->setPercentSelfMoney($request->request->get('a9-3'));
  129.             $order->setAttractingFinancing($request->request->get('a9-4'));
  130.             $order->setExportProducts($request->request->get('a10-1'));
  131.             $order->setDatePlan($request->request->get('a11-1'));
  132. //            $order->setSourceinfo($request->request->get('a12-1'));
  133.             $order->setContactFio($request->request->get('a13-1'));
  134.             $order->setContactPost($request->request->get('a13-2'));
  135.             $order->setContactEmail($request->request->get('a13-4'));
  136.             $order->setContactPhone($request->request->get('a13-3'));
  137.             $order->setCreated(new \DateTime());
  138. //            dump($order);
  139. //            exit;
  140.             $this->getDoctrine()->getManager()->persist($order);
  141.             $this->getDoctrine()->getManager()->flush($order);
  146.             $array = $request->request->all();
  148.             $time = time();
  149.             $filename = '/pdf/'.$time.'.pdf';
  153.             $company = CRest::call(
  154.                 'crm.company.add',
  155.                 ['FIELDS' => [
  156.                     'TITLE' => $_POST['companyTitle'] ,
  157.                     'COMPANY_TYPE' => 'COSTOMER' ,
  158.                 ]
  159.                 ]
  160.             );
  162.             $fip = explode(' ', $_POST['a13-1']);
  163.             $client = CRest::call(
  165.                 'crm.contact.add',
  166.                 ['FIELDS' => [
  167.                     'LAST_NAME' => (isset($fip[0]) ? $fip[0] : '') ,
  168.                     'NAME' => (isset($fip[1]) ? $fip[1] : '') ,
  169.                     'SECOND_NAME' => (isset($fip[2]) ? $fip[2] : '') ,
  170.                     'POST' => $_POST['a13-2'] ,
  171.                     'COMPANY_ID' => $company['result'] ,
  172.                     'PHONE' => ['0' => ['VALUE' => $_POST['a13-3'], 'VALUE_TYPE' => 'WORK' ]],
  173.                     'EMAIL' => ['0' => ['VALUE' => $_POST['a13-4'], 'VALUE_TYPE' => 'WORK' ]]
  174.                 ]
  175.                 ]
  176.             );
  178.             $fields = [
  179.                 // 1
  180.                 'CLIENT_ID' => $client['result'],
  181.                 'COMPANY_ID' => $company['result'],
  182.                 'TITLE' => $_POST['companyTitle'] ,
  185.                 // 2
  186.                 'UF_CRM_1606465800' => htmlspecialchars($request->request->get('a2-1')) ,
  187.                 'UF_CRM_1670866739817' => htmlspecialchars($request->request->get('a2-2')) ,
  189.                 // 3
  191.                 'UF_CRM_1675845053079' => $this->zeml($_POST['a3-1']) ,
  192.                 'UF_CRM_1606377438' => $_POST['a2-2'] ,
  193.                 'UF_CRM_1606381074' => $_POST['a2-5'] ,
  194.                 'UF_CRM_1695918921855' => $_POST['a2-6'] ,
  197.                 'UF_CRM_1679571797939' => $_POST['a3-2'],
  200.                 'UF_CRM_1670869181929' => $_POST['a3-3'],
  201.                 'UF_CRM_1607609497932' => htmlspecialchars(implode(', ', $_POST['a3-4-1'])),
  202.                 'UF_CRM_1677854515829' => @htmlspecialchars($_POST['a3-5-1']) . ' - ' . @htmlspecialchars($_POST['a3-5-2']),
  203. //                    'UF_CRM_1675321766138' => htmlspecialchars($_POST['a3-6']),
  205.                 // 4
  206.                 'UF_CRM_1679568817892' => @htmlspecialchars($_POST['a4-1-1']). ' - ' . @htmlspecialchars($_POST['a4-1-2']),
  207. //                    'UF_CRM_1675337484117' => htmlspecialchars($_POST['a4-2-1']) . ' - ' . htmlspecialchars($_POST['a4-2-2']),
  208. //                    'UF_CRM_1675337493501' => htmlspecialchars($_POST['a4-3-1']) . ' - ' . htmlspecialchars($_POST['a4-3-2']),
  209.                 'UF_CRM_1675337503316' => @htmlspecialchars($_POST['a4-4-1']) . ' - ' . @htmlspecialchars($_POST['a4-4-2']),
  211.                 // 5
  212.                 'UF_CRM_1606467793' => htmlspecialchars($_POST['a5-1']),
  213.                 'UF_CRM_1671092333590' => ($_POST['a5-1'] == 259 ? '1 000 м' : ($_POST['a5-1'] == 260 ? '500 м' : ($_POST['a5-1'] == 261 ? '100 м' : '50 м' ))) ,
  214. //                    'UF_CRM_1675337610212' => htmlspecialchars($_POST['a5-2']) . ' '.htmlspecialchars($_POST['a5-3']),
  216.                 // 6
  217.                 'UF_CRM_1675362708976' => $_POST['a6-1'],
  218.                 'UF_CRM_1606378175' => ($_POST['a6-1'] ? 172 : 173),
  221.                 // 7
  222.                 'UF_CRM_1606307259' => $_POST['a7-1-1'],
  223. //                    'UF_CRM_1676454782840' => $_POST['a7-1-2'],
  224. //                    'UF_CRM_1676454792113' => $_POST['a7-1-3'],
  225. //                    'UF_CRM_1676454802581' => $_POST['a7-1-4'],
  227.                 'UF_CRM_1606307305' =>    $_POST['a7-2-1'],
  228. //                    'UF_CRM_1676454942092' => $_POST['a7-2-2'],
  229. //                    'UF_CRM_1676454949378' => $_POST['a7-2-3'],
  230. //                    'UF_CRM_1676454956188' => $_POST['a7-2-4'],
  232.                 'UF_CRM_1607609478634' => $_POST['a7-4-1'],
  233. //                    'UF_CRM_1676455787543' => $_POST['a7-4-2'],
  234. //                    'UF_CRM_1676455794233' => $_POST['a7-4-3'],
  235. //                    'UF_CRM_1676455801248' => $request->request->get('a7-4-4'),
  237.                 'UF_CRM_1675362597546' => $request->request->get('a7-5-1'),
  239. //                    'UF_CRM_1677584791600' => $request->request->get('a7-5-2'),
  240. //                    'UF_CRM_1677584801663' => $request->request->get('a7-5-3'),
  241. //                    'UF_CRM_1677584809559' => $request->request->get('a7-5-4'),
  243.                 'UF_CRM_1606307281' => $request->request->get('a7-6-1'),
  246.                 // 8
  247.                 'UF_CRM_1606738971379' => $request->request->get('a8-1-1'),
  249.                 // 9
  250.                 'OPPORTUNITY' => htmlspecialchars($request->request->get('a9-1')) ,
  251.                 // Заинтересованность в привлечении финансирования
  252.                 'UF_CRM_1670869865629' => htmlspecialchars($request->request->get('a9-2')) ,
  253.                 'UF_CRM_1675363011684' => htmlspecialchars($request->request->get('a9-4')) ,
  254.                 'UF_CRM_1675848015746' => htmlspecialchars($request->request->get('a9-3')) ,
  256.                 // 10
  257.                 'UF_CRM_1675363052446' => htmlspecialchars($request->request->get('a10-1')) ,
  259.                 // 11
  260.                 'UF_CRM_1675363070079' => htmlspecialchars($request->request->get('a11-1')) ,
  262.                 // 12
  263. //                'UF_CRM_1675363093767' => htmlspecialchars($request->request->get('a12-1')) ,
  265.                 // PDF
  266.                 'UF_CRM_1678207562009' => 'https://mosregco.ru'.$filename ,
  267.                 'UF_CRM_1682083532812' => '1804' ,
  269.                 'UF_CRM_1685378974312' => (new \DateTime())->format('Y-m-d H:i:s'),
  270.             ];
  272.             if (!$orderNumber){
  273.                 $fields['SOURCE_ID'] = 'Сайт';
  274.             }
  276.             if ($orderNumber == null){
  277.                 $result = CRest::call(
  278.                     'crm.deal.add',
  279.                     ['FIELDS' => $fields]
  280.                 );
  282.                 $filename2 = '/pdf-generate/'.$result['result'];
  283.                 CRest::call(
  284.                     'crm.deal.update',
  285.                     [
  286.                         'ID' => $orderNumber,
  287.                         'FIELDS' => [
  288.                             'UF_CRM_1697204561963' => 'https://mosregco.ru'.$filename2 ,
  289.                         ]
  290.                     ]
  291.                 );
  293.             }else{
  294.                 $result = CRest::call(
  295.                     'crm.deal.update',
  296.                     [
  297.                         'ID' => $orderNumber,
  298.                         'FIELDS' => $fields
  299.                     ]
  300.                 );
  301.             }
  304.             $addcon = CRest::call(
  305.                 'crm.deal.contact.add',
  306.                [
  307.                    'ID' => $result['result'],
  308.                    'FIELDS'=> [
  309.                        'CONTACT_ID'=>$client['result'],
  310.                        'SORT'=>0,
  311.                        'PRIMARY'=>true,
  312.                    ]
  313.                 ]
  314.             );
  317.             $array['orderId'] = ($orderNumber ? $orderNumber : $result['result']);
  318.             $path = $this->generatePdf($array, $time);
  320.             $order->setBitrixCode($array['orderId']);
  321.             $this->getDoctrine()->getManager()->flush();
  323.             $mailhtml = $this->renderView('new/mail/order.html.twig', ['order'=>$array, 'path' => $path]);
  324.             $message = (new \Swift_Message('Новый запрос формы заявки'))
  325.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  326. //                ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  327. //                ->setFrom('test@projectwork.ru', 'test@projectwork.ru')
  328.                 ->setTo(['marketing@mosregco.ru', 't.ershova@mosregco.ru'])
  330.                 ->setBody(
  331.                     $mailhtml,
  332.                     'text/html'
  333.                 );
  334.             $mailer->send($message);
  336.             if (filter_var($request->request->get('a13-4'), FILTER_VALIDATE_EMAIL)) {
  337.                 $mailhtml = $this->renderView('new/mail/order_client.html.twig', ['order'=>$array, 'path' => $path]);
  338.                 $message = (new \Swift_Message('Заявка с сайта КРМО'))
  339. //                    ->setFrom('test@projectwork.ru', 'test@projectwork.ru')
  340.                     ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  341.                     ->setTo($request->request->get('a13-4'))
  342.                     ->setBody(
  343.                         $mailhtml,
  344.                         'text/html'
  345.                     );
  346.                 
  347.                 @$mailer->send($message);
  348.             }
  351. //            dump($result);
  352.             return $this->render('new/order.html.twig', [ 'data'=> $array ]);
  353.         }
  354.         return $this->render('new/order.html.twig');
  355.     }
  358.     #[Route('/order-sms', name: "send_sms", options: ["expose" => true ])]
  359.     public function orderSmsAction(Request $request, SmsService $smsService){
  361.         $phone = $request->request->get('a13-3');
  363.         if (!$phone){
  364.             return new JsonResponse('error');
  365.         }
  367.         $num = rand(1234,9854);
  368.         $session = $request->getSession()->set('sms', $num);
  369. //        $session->save();
  371.         $phone = str_replace(['-',' ','(',')'],'',$phone);
  372.         $r = $smsService->smsapi_push_msg_nologin('s.cherkasov@mosregco.ru', 'eKoxZ(e2yxmo', $phone,
  373.             "Код: $num", array("sender_name"=>"KRMO"));
  375.         return  new JsonResponse(['code' => $num]);
  376.     }
  380.     #[Route('/pdf-generate/{code}')]
  381.     public function pdfGenerate($code){
  382.         $order = $this->getDoctrine()->getRepository(Order::class)->findOneBy(['bitrixCode'=>$code]);
  384.         if (!$order){
  385.             echo '<h1>Документ не найден</h1>';
  386.             exit;
  387.         }
  388.         $arguments = array(
  389.             'constructorArgs' => ['','', 0, '', 0, 0, 0, 0, 0, 0, 'P'],
  390.             'writeHtmlMode' => null, //$mode argument for WriteHTML method
  391.             'writeHtmlInitialise' => null, //$mode argument for WriteHTML method
  392.             'writeHtmlClose' => null, //$close argument for WriteHTML method
  393.             'outputFilename' => null, //$filename argument for Output method
  394.             'outputDest' => null, //$dest argument for Output method
  395.             'defaultheaderline' => 0,  //for header
  396.             'defaulfooterline' => 0  //for footer
  397.         );
  398.         $mpdf = new Mpdf(['mode' => 'utf-8', 'format' => [360, 472]]);
  400. //        $mpdfService = $this->container->get('t_fox_mpdf_port.mpdf');
  401.         $mpdf->defaultheaderline = 0;
  402.         $mpdf->defaultfooterline = 0;
  407.         $stylesheet = file_get_contents(__DIR__.'/../../public/assets/bootstrap/dist/css/bootstrap.css');
  408.         $mpdf->WriteHTML($stylesheet,\Mpdf\HTMLParserMode::HEADER_CSS);
  409.         $stylesheet = file_get_contents(__DIR__.'/../../public/assets/less/newsite2.css');
  410.         $mpdf->WriteHTML($stylesheet,\Mpdf\HTMLParserMode::HEADER_CSS);
  411.         $stylesheet = file_get_contents(__DIR__.'/../../public/assets/less/fonts.css');
  412.         $mpdf->WriteHTML($stylesheet,\Mpdf\HTMLParserMode::HEADER_CSS);
  414.         $html = $this->renderView('new/pdf/order_2.html.twig', ['order' => $order]);
  415.         $mpdf->WriteHTML($html);
  416.         $name = $code.'.pdf';
  417.         $mpdf->Output($name,'D');
  418.         return $name;
  419.     }
  422.     private function generatePdf(array $array, $time)
  423.     {
  424.         $arguments = array(
  425.             'constructorArgs' => ['','', 0, '', 0, 0, 0, 0, 0, 0, 'P'],
  426.             'writeHtmlMode' => null, //$mode argument for WriteHTML method
  427.             'writeHtmlInitialise' => null, //$mode argument for WriteHTML method
  428.             'writeHtmlClose' => null, //$close argument for WriteHTML method
  429.             'outputFilename' => null, //$filename argument for Output method
  430.             'outputDest' => null, //$dest argument for Output method
  431.             'defaultheaderline' => 0,  //for header
  432.             'defaulfooterline' => 0  //for footer
  433.         );
  434.         $mpdf = new Mpdf(['mode' => 'utf-8', 'format' => [360, 472]]);
  436. //        $mpdfService = $this->container->get('t_fox_mpdf_port.mpdf');
  437.         $mpdf->defaultheaderline = 0;
  438.         $mpdf->defaultfooterline = 0;
  443.         $stylesheet = file_get_contents(__DIR__.'/../../public/assets/bootstrap/dist/css/bootstrap.css');
  444.         $mpdf->WriteHTML($stylesheet,\Mpdf\HTMLParserMode::HEADER_CSS);
  445.         $stylesheet = file_get_contents(__DIR__.'/../../public/assets/less/newsite.css');
  446.         $stylesheet = file_get_contents(__DIR__.'/../../public/assets/less/fonts.css');
  447.         $mpdf->WriteHTML($stylesheet,\Mpdf\HTMLParserMode::HEADER_CSS);
  448.         $mpdf->WriteHTML($stylesheet,\Mpdf\HTMLParserMode::HEADER_CSS);
  450.         $html = $this->renderView('new/pdf/order.html.twig', ['order' => $array]);
  451.         $mpdf->WriteHTML($html);
  452.         $name = '/pdf/'.$time.'.pdf';
  453.         $mpdf->Output(__DIR__.'/../../public'.$name,'F');
  454.         return $name;
  455.     }
  457.     private function zeml($post)
  458.     {
  459.         if (in_array(1786,$post) && in_array(1787,$post)){
  460.             return 1788;
  461.         }elseif(in_array(1786,$post)){
  462.             return 1786;
  463.         }elseif(in_array(1787,$post)){
  464.             return 1787;
  465.         }
  466.         return null;
  467.     }
  468. }