src/Controller/IndexController.php line 337

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Bitrix\CRest;
  6. use App\Entity\Chart;
  7. use App\Entity\ContactSendUserData;
  8. use App\Entity\DocumentGroup;
  9. use App\Entity\Gallery;
  10. use App\Entity\Itog;
  11. use App\Entity\JukIcon;
  12. use App\Entity\JukSmi;
  13. use App\Entity\LocalProject;
  14. use App\Entity\Page;
  15. use App\Entity\PageBlock;
  16. use App\Entity\PagePageBlock;
  17. use App\Entity\Partner;
  18. use App\Entity\Person;
  19. use App\Entity\PersonCategory;
  20. use App\Entity\PresentationSendUserData;
  21. use App\Entity\PriceIndex;
  22. use App\Entity\PriceIndexItem;
  23. use App\Entity\ProjectItem;
  24. use App\Entity\Publication;
  25. use App\Entity\Project;
  26. use App\Entity\PublicationCategory;
  27. use App\Entity\Review;
  28. use App\Entity\Smi;
  29. use App\Entity\Subscribtion;
  30. use App\Entity\UserOrder;
  31. use Doctrine\ORM\EntityManagerInterface;
  32. use Doctrine\Persistence\ManagerRegistry;
  33. use Knp\Component\Pager\PaginatorInterface;
  34. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  35. use Symfony\Component\HttpFoundation\JsonResponse;
  36. use Symfony\Component\HttpFoundation\RedirectResponse;
  37. use Symfony\Component\HttpFoundation\Request;
  38. use Symfony\Component\HttpFoundation\Response;
  39. use Symfony\Component\Routing\Annotation\Route;
  40. use Symfony\Component\Validator\Validator\ValidatorInterface;
  41. use Vich\UploaderBundle\Templating\Helper\UploaderHelper;
  42. use Vich\UploaderBundle\Templating\Helper\UploaderHelperInterface;
  44. class IndexController extends AbstractController
  45. {
  47.     protected $blocks = [];
  48.     public function __construct(EntityManagerInterface $manager)
  49.     {
  50.         $blocks = $manager->getRepository(PageBlock::class)->findAll();
  51.         foreach ($blocks as $block){
  52.             $this->blocks[$block->getName()] = $block;
  53.         }
  54.     }
  55.     
  56.     #[Route('/for-the-investor/parks')]
  57.     public function red1(): Response
  58.     {
  59.         return $this->redirectToRoute('app_index');
  60.     }
  63.     #[Route('/medias/newscorp/{all}', defaults: ["all"=>null])]
  64.     public function redNews($all = null): Response
  65.     {
  66.         return $this->redirectToRoute('app_publications', ['type'=> 'journal' ]);
  67.     }
  71.     #[Route('/upload/for-the-investor/ip_esipovo_mo.pdf')]
  72.     public function red2(): Response
  73.     {
  74.         return $this->redirectToRoute('app_project');
  75.     }
  77.     #[Route('/parks/')]
  78.     public function red3(): Response
  79.     {
  80.         return $this->redirectToRoute('app_project');
  81.     }
  83.     #[Route('/parks')]
  84.     public function red4(): Response
  85.     {
  86.         return $this->redirectToRoute('app_project');
  87.     }
  90.     #[Route('/for-the-investor/parks')]
  91.     public function red5(): Response
  92.     {
  93.         return $this->redirectToRoute('app_project');
  94.     }
  96.     #[Route('/', name: 'app_index')]
  97.     public function index(ManagerRegistry $doctrine, $oderNumber = false): Response
  98.     {
  99. //        $charts = $doctrine->getRepository(Chart::class)->findBy(['enabled' => true]);
  100.         $itogs = $doctrine->getRepository(Itog::class)->findBy([],['title'=>'DESC']);
  101.         $news = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true],['created'=>'DESC']);
  102.         $projects = $doctrine->getRepository(project::class)->findBy(['enabled' => true]);
  103.         $localProjects = $doctrine->getRepository(LocalProject::class)->filter(['page'=>0]);
  104.         $localProjectsCount = ceil(count($doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]))/4);
  105.         $partners = $doctrine->getRepository(Partner::class)->findBy(['enabled' => true]);
  107.         $publicationCategory = $doctrine->getRepository(PublicationCategory::class)->find(1);
  108.         $publicationCategoryVideo = $doctrine->getRepository(PublicationCategory::class)->find(2);
  109.         $publicationCategorySmi = $doctrine->getRepository(PublicationCategory::class)->find(3);
  110.         $publicationCategoryJournal = $doctrine->getRepository(PublicationCategory::class)->find(4);
  111.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled'=>true]);
  113.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'category' => $publicationCategory], ['created'=>'DESC'], 6);
  114.         $publicationVideo = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategoryVideo], ['created'=>'DESC'], 6);
  115.         $publicationSmi = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategorySmi], ['created'=>'DESC'], 6);
  116.         $publicationJournal = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategoryJournal], ['created'=>'DESC'], 6);
  117.         $reviews = $doctrine->getRepository(Review::class)->findAll();
  118.         shuffle($reviews);
  120.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'main']);
  121.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  123.         $indexPriceHome = $doctrine->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  124.         $tmpData = [];
  125.         /** @var PriceIndex $elems */
  126.         foreach ($indexPriceHome as $elems){
  127.             /** @var PriceIndexItem $tmpItem*/
  128.             foreach ($elems->getItems() as $tmpItem ){
  129.                 if ($tmpItem->getDate()->format('Y') == 2024){
  130.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  131.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  132.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  133.                     }else{
  134.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  135.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  136.                     }
  137.                 }
  139.             }
  140.         }
  141.         $indexPriceHome = $tmpData;
  144.         $indexPriceArea = $doctrine->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  145.         $tmpData = [];
  146.         /** @var PriceIndex $elems */
  147.         foreach ($indexPriceArea as $elems){
  148.             /** @var PriceIndexItem $tmpItem*/
  149.             foreach ($elems->getItems() as $tmpItem ){
  150.                 if ($tmpItem->getDate()->format('Y') == 2024){
  151.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  152.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  153.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  154.                     }else{
  155.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  156.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  157.                     }
  158.                 }
  159.             }
  160.         }
  161.         $indexPriceArea = $tmpData;
  164.         $indexPriceHomeElems = $doctrine->getRepository(PriceIndexItem::class)->filter('home');
  165.         $tmpData = [];
  166.         foreach ($indexPriceHomeElems as $tmp){
  167.             $tmpData[] = $tmp['price'];
  168.         }
  169.         $indexPriceHomeElems = $tmpData;
  171.         $indexPriceAreaElems = $doctrine->getRepository(PriceIndexItem::class)->filter('area');
  172.         $tmpData = [];
  173.         foreach ($indexPriceAreaElems as $tmp){
  174.             $tmpData[] = $tmp['price'];
  175.         }
  176.         $indexPriceAreaElems = $tmpData;
  180.         return $this->render('new/index/index.html.twig', [
  181.             'indexPriceHomeElems' => $indexPriceHomeElems,
  182.             'indexPriceAreaElems' => $indexPriceAreaElems,
  183.             'indexPriceHome' => $indexPriceHome,
  184.             'indexPriceArea' => $indexPriceArea,
  185.             'partners' => $partners,
  186. //            'charts' => $charts,
  187.             'news' => $news,
  188.             'projects' => $projects,
  189.             'localProjects' => $localProjects,
  190.             'localProjectsCount' => $localProjectsCount,
  191.             'oderNumber' => $oderNumber,
  192.             'publications' => $publications,
  193.             'publicationVideos' => $publicationVideo,
  194.             'publicationSmi' => $publicationSmi,
  195.             'publicationJournal' => $publicationJournal,
  196.             'categories' => $categories,
  197.             'blocks' => $this->blocks,
  198.             'reviews' => $reviews,
  199.             'action'=> 'index',
  200.             'itogs'=> $itogs,
  201.             'page'=> $page,
  202.             'pageBlocks'=> $pageBlocks,
  203.         ]);
  204.     }
  206.     #[Route('/pnorama', name: 'app_iframe')]
  207.     public function iframe(){
  208.         return $this->render('new/iframe.html.twig', ['blocks' => $this->blocks]);
  209.     }
  210.     
  211.     #[Route('/.well-known/acme-challenge/mgA7s-0tGAUQoi4x0RunYQdubFbLbK5qduzB6ZMl_b0', name: 'app_hello')]
  212.     public function hello(): Response
  213.     {
  214.         // Принудительно очищаем системный кэш через код
  215.         $cacheDir = $this->getParameter('kernel.cache_dir');
  216.         
  217.         return new Response('mgA7s-0tGAUQoi4x0RunYQdubFbLbK5qduzB6ZMl_b0.eAhR_HhmleA4zOdOioJjXrelMNMQAUZoIHQEAN4ULX4');
  218.     }
  219.     
  220.     #[Route('/ps/ps-page', name: 'app_ps_page')]
  221.     public function newPage(ManagerRegistry $doctrine, $oderNumber = false): Response
  222.     {
  223.         $itogs = $doctrine->getRepository(Itog::class)->findBy([],['title'=>'DESC']);
  224.         $news = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true],['created'=>'DESC']);
  225.         $projects = $doctrine->getRepository(project::class)->findBy(['enabled' => true]);
  226.         $localProjects = $doctrine->getRepository(LocalProject::class)->filter(['page'=>0]);
  227.         $localProjectsCount = ceil(count($doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]))/4);
  228.         $partners = $doctrine->getRepository(Partner::class)->findBy(['enabled' => true]);
  230.         $publicationCategory = $doctrine->getRepository(PublicationCategory::class)->find(1);
  231.         $publicationCategoryVideo = $doctrine->getRepository(PublicationCategory::class)->find(2);
  232.         $publicationCategorySmi = $doctrine->getRepository(PublicationCategory::class)->find(3);
  233.         $publicationCategoryJournal = $doctrine->getRepository(PublicationCategory::class)->find(4);
  234.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled'=>true]);
  236.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'category' => $publicationCategory], ['created'=>'DESC'], 6);
  237.         $publicationVideo = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategoryVideo], ['created'=>'DESC'], 6);
  238.         $publicationSmi = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategorySmi], ['created'=>'DESC'], 6);
  239.         $publicationJournal = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategoryJournal], ['created'=>'DESC'], 6);
  240.         $reviews = $doctrine->getRepository(Review::class)->findAll();
  241.         shuffle($reviews);
  243.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'main']);
  244.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  246.         $indexPriceHome = $doctrine->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  247.         $tmpData = [];
  248.         /** @var PriceIndex $elems */
  249.         foreach ($indexPriceHome as $elems){
  250.             /** @var PriceIndexItem $tmpItem*/
  251.             foreach ($elems->getItems() as $tmpItem ){
  252.                 if ($tmpItem->getDate()->format('Y') == 2024){
  253.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  254.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  255.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  256.                     }else{
  257.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  258.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  259.                     }
  260.                 }
  262.             }
  263.         }
  264.         $indexPriceHome = $tmpData;
  267.         $indexPriceArea = $doctrine->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  268.         $tmpData = [];
  269.         /** @var PriceIndex $elems */
  270.         foreach ($indexPriceArea as $elems){
  271.             /** @var PriceIndexItem $tmpItem*/
  272.             foreach ($elems->getItems() as $tmpItem ){
  273.                 if ($tmpItem->getDate()->format('Y') == 2024){
  274.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  275.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  276.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  277.                     }else{
  278.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  279.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  280.                     }
  281.                 }
  282.             }
  283.         }
  284.         $indexPriceArea = $tmpData;
  287.         $indexPriceHomeElems = $doctrine->getRepository(PriceIndexItem::class)->filter('home');
  288.         $tmpData = [];
  289.         foreach ($indexPriceHomeElems as $tmp){
  290.             $tmpData[] = $tmp['price'];
  291.         }
  292.         $indexPriceHomeElems = $tmpData;
  294.         $indexPriceAreaElems = $doctrine->getRepository(PriceIndexItem::class)->filter('area');
  295.         $tmpData = [];
  296.         foreach ($indexPriceAreaElems as $tmp){
  297.             $tmpData[] = $tmp['price'];
  298.         }
  299.         $indexPriceAreaElems = $tmpData;
  300.         
  301.         return $this->render('ps_page.html.twig', [
  302.             'indexPriceHomeElems' => $indexPriceHomeElems,
  303.             'indexPriceAreaElems' => $indexPriceAreaElems,
  304.             'indexPriceHome' => $indexPriceHome,
  305.             'indexPriceArea' => $indexPriceArea,
  306.             'partners' => $partners,
  307. //            'charts' => $charts,
  308.             'news' => $news,
  309.             'projects' => $projects,
  310.             'localProjects' => $localProjects,
  311.             'localProjectsCount' => $localProjectsCount,
  312.             'oderNumber' => $oderNumber,
  313.             'publications' => $publications,
  314.             'publicationVideos' => $publicationVideo,
  315.             'publicationSmi' => $publicationSmi,
  316.             'publicationJournal' => $publicationJournal,
  317.             'categories' => $categories,
  318.             'blocks' => $this->blocks,
  319.             'reviews' => $reviews,
  320.             'action'=> 'index',
  321.             'itogs'=> $itogs,
  322.             'page'=> $page,
  323.             'pageBlocks'=> $pageBlocks,
  324.         ]);
  325.     }
  327.     #[Route('/rss', name: 'app_rss', defaults: ["_format" => "xml"])]
  328.     public function rss(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request): Response
  329.     {
  330.         $category = $doctrine->getRepository(PublicationCategory::class)->findOneBy(['slug' => 'news']);
  331.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $category],['created'=>'DESC']);
  333.         return  $this->render('rss.html.twig', ['publications'=>$publications]);
  334.     }
  336.     #[Route('/publications/{type}', name: 'app_publications', defaults: ['type' => 'news'])]
  337.     public function publications(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request, $type = 'news'): Response
  338.     {
  340.         $category = $doctrine->getRepository(PublicationCategory::class)->findOneBy(['slug' => $type]);
  342.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled' => true]);
  343.         if ($request->query->get('newId')){
  344.             $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $category, 'parent' => $request->query->get('newId')],['created'=>'DESC']);
  345.         }else{
  346.             $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $category],['created'=>'DESC']);
  347.         }
  349.         $videosCategory = $doctrine->getRepository(PublicationCategory::class)->find(2);
  350.         $videos = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $videosCategory ],['created'=>'DESC'], 3);
  354.         $pagination = $paginator->paginate(
  355.             $publications,
  356.             $request->query->getInt('page', 1), /*page number*/
  357.             6 /*limit per page*/
  358.         );
  360.         return $this->render('new/index/publications.html.twig', [
  361.             'publications' => $pagination,
  362.             'category' => $category,
  363.             'videos' => $videos,
  364.             'categories' => $categories,
  365.             'action'=> 'publications',
  366.         ]);
  367.     }
  370.     #[Route('/partners', name: 'app_partners')]
  371.     public function partners(ManagerRegistry $doctrine): Response
  372.     {
  373.         $partners = $doctrine->getRepository(Partner::class)->findBy(['enabled' => true]);
  375.         return $this->render('index/partners.html.twig', [
  376.             'partners' => $partners
  377.         ]);
  378.     }
  380.     #[Route('/404', name: 'app_error')]
  381.     public function error(ManagerRegistry $doctrine): Response
  382.     {
  384.         return $this->render('new/index/error.html.twig', [
  385.         ]);
  386.     }
  388.     #[Route('/contacts', name: 'app_contacts')]
  389.     public function contacts(
  390.         ManagerRegistry $doctrine,
  391.         Request $request,
  392.         \Swift_Mailer $mailer,
  393.         ValidatorInterface $validator,
  394.     ): Response
  395.     {
  396. //        Ключ сайта 6LeZ0HooAAAAAJqqEP7jAsh8o1kIN1yKLw19ATo6
  397. //        Секретный ключ 6LeZ0HooAAAAAL7a8xNrwIWes5rPE09FfX6nH8FW
  398.         $personCategories = $doctrine->getRepository(PersonCategory::class)->findBy(['inContact' => true]);
  399.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'contacts']);
  400.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  402.         if ($request->getMethod() == 'POST'){
  404.             if(isset($_POST['g-recaptcha-response'])){
  405.                 $captcha=$_POST['g-recaptcha-response'];
  406.                 if ( !$captcha ) {
  407. //                    $form->addError(new FormError('Не верна заполнена капча'));
  408. //                    return $this->render('@App/Modal/register_modal_element.html.twig', ['form' => $form->createView()]);
  409.                     return  $this->redirectToRoute('app_contacts');
  410.                 }
  412.                 $secretKey = "6LeZ0HooAAAAAL7a8xNrwIWes5rPE09FfX6nH8FW";
  414.                 $url = 'https://www.google.com/recaptcha/api/siteverify?secret=' . urlencode($secretKey) .  '&response=' . urlencode($captcha);
  415.                 $response = file_get_contents($url);
  416.                 $responseKeys = json_decode($response,true);
  417.                 if($responseKeys["success"] || true) {
  419.                     $contactSendUserData = new ContactSendUserData(
  420.                         trim($request->request->get('phone')),
  421.                         trim($request->request->get('email')),
  422.                         trim($request->request->get('name')),
  423.                         trim($request->request->get('comment')),
  424.                     );
  425.                     $errors = $validator->validate($contactSendUserData);
  427.                     if (count($errors) === 0) {
  428.                         $order = [
  429.                             'name' => $request->request->get('name'),
  430.                             'email' => $request->request->get('email'),
  431.                             'phone' => $request->request->get('phone'),
  432.                             'comment' => $request->request->get('comment'),
  433.                         ];
  434.                         $mailhtml = $this->renderView('mail/contacts.html.twig', ['order'=>$order]);
  435.                         $message = (new \Swift_Message('Новый запрос из формы контактов'))
  436.                             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  437.                             ->setTo(['marketing@mosregco.ru'])
  438.                             ->setBody(
  439.                                 $mailhtml
  440.                                 ,
  441.                                 'text/html'
  442.                             );
  444. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  445. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  447.                         $mailer->send($message);
  448.                         $this->addFlash('modal', 'emailSuccess');
  449.                     } else {
  450.                         $this->addFlash('modal', 'emailError');
  451.                     }
  452.                 }
  453.             }
  456.             return $this->render('new/index/contacts.html.twig', [
  457.                 'personCategories' => $personCategories,
  458.                 'blocks' => $this->blocks,
  459.                 'post' => true,
  460.                 'action'=> 'contacts',
  461.                 'page'=> $page,
  462.                 'pageBlocks'=> $pageBlocks,
  463.             ]);
  464.         }
  466.         return $this->render('new/index/contacts.html.twig', [
  467.             'blocks' => $this->blocks,
  468.             'personCategories' => $personCategories,
  469.             'action'=> 'contacts',
  470.             'page'=> $page,
  471.             'pageBlocks'=> $pageBlocks,
  472.         ]);
  473.     }
  475.     #[Route('/about', name: 'app_about')]
  476.     public function about(ManagerRegistry $doctrine): Response
  477.     {
  479.         $personCategories = $doctrine->getRepository(PersonCategory::class)->findBy([], ['sort'=>'ASC']);
  480.         $persons = $doctrine->getRepository(Person::class)->findBy(['category' => $personCategories[0], 'enabled'=>true],['priority'=>'ASC']);
  481.         $personsAll = $doctrine->getRepository(Person::class)->findBy(['enabled'=>true],['priority'=>'ASC']);
  482.         $localProjects = $doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]);
  483.         $page_1 = $doctrine->getRepository(Page::class)->findOneBy(['slug'=> 'about_1']);
  484.         $page_2 = $doctrine->getRepository(Page::class)->findOneBy(['slug'=> 'about_2']);
  485.         $page_3 = $doctrine->getRepository(Page::class)->findOneBy(['slug'=> 'about_3']);
  487.         $gallery = $doctrine->getRepository(Gallery::class)->findBy(['enabled'=> true]);
  488.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'about']);
  489.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  490.         $docsGroups = $doctrine->getRepository(DocumentGroup::class)->findAll();
  492.         return $this->render('new/index/about.html.twig', [
  493.             'docsGroups' => $docsGroups,
  494.             'personCategories' => $personCategories,
  495.             'persons' => $persons,
  496.             'personsAll' => $personsAll,
  497.             'localProjects' => $localProjects,
  498.             'page_1' => $page_1,
  499.             'page_2' => $page_2,
  500.             'page_3' => $page_3,
  501.             'gallery' => $gallery,
  502.             'blocks' => $this->blocks,
  503.             'action'=> 'about',
  504.             'page'=> $page,
  505.             'pageBlocks'=> $pageBlocks,
  506.         ]);
  507.     }
  509.     #[Route('/o-regione', name: 'app_region')]
  510.     public function oregione(ManagerRegistry $doctrine): Response
  511.     {
  513.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'o-regione']);
  514.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  516.         return $this->render('new/index/region.html.twig', [
  517.             'blocks' => $this->blocks,
  518.             'action'=> 'o-regione',
  519.             'page'=> $page,
  520.             'pageBlocks'=> $pageBlocks,
  521.         ]);
  522.     }
  524.     #[Route('/invest', name: 'app_invest')]
  525.     public function invest(ManagerRegistry $doctrine): Response
  526.     {
  527.         $localProjects = $doctrine->getRepository(LocalProject::class)->findBy(['enabled' => true]);
  529.         return $this->render('index/invest.html.twig', [
  530.             'localProjects' =>$localProjects
  531.         ]);
  532.     }
  534.     #[Route('/calc', name: 'app_calc')]
  535.     public function calc(ManagerRegistry $doctrine): Response
  536.     {
  537.         return $this->render('index/calc.html.twig');
  538.     }
  540.     #[Route('/policy', name: 'app_policy')]
  541.     public function policy(ManagerRegistry $doctrine): Response
  542.     {
  543.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug'=>'policy']);
  544.         return $this->render('new/index/page.html.twig',['page' => $page]);
  545.     }
  548.     #[Route('/publication/{slug}', name: 'app_publication_show', defaults: ['id'=>null])]
  549.     public function publication(ManagerRegistry $doctrine, $slug = null): Response
  550.     {
  553.         $publication = $doctrine->getRepository(Publication::class)->findOneBy(['slug'=>$slug, 'enabled'=>true]);
  555.         if (!$publication){
  556.             throw $this->createNotFoundException();
  557.         }
  558.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled'=>true]);
  559.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true],['created'=>'DESC'], 20);
  561.         $videosCategory = $doctrine->getRepository(PublicationCategory::class)->find(2);
  562.         $videos = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $videosCategory ],['created'=>'DESC'], 3);
  564.         $smiCategory = $doctrine->getRepository(PublicationCategory::class)->find(3);
  565.         $smi = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $smiCategory ],['created'=>'DESC'], 3);
  568.         return $this->render('new/index/publication.html.twig', [
  569.             'categories' => $categories,
  570.             'videosCategory' => $videosCategory,
  571.             'videos' => $videos,
  572.             'news' => $publications,
  573.             'publication' => $publication,
  574.             'action'=> 'publications',
  575.             'smi'=> $smi,
  576.         ]);
  577.     }
  581.     #[Route('/publications/smi', name: 'app_publications_smi')]
  582.     public function publicationsSmi(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request): Response
  583.     {
  585.         $publications = $doctrine->getRepository(Smi::class)->findBy([],['created'=>'DESC']);
  586.         $pagination = $paginator->paginate(
  587.             $publications,
  588.             $request->query->getInt('page', 1), /*page number*/
  589.             10 /*limit per page*/
  590.         );
  592.         return $this->render('index/publications_smi.html.twig', [
  593.             'publications' => $pagination,
  594.             'action'=> 'publications',
  595.         ]);
  596.     }
  599.     #[Route('/search', name: 'app_search', options: ['expose' => true])]
  600.     public function search(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request): Response
  601.     {
  604.         if ($request->isXmlHttpRequest()){
  605.             if ($request->query->get('search')){
  606.                 $news = $doctrine->getRepository(Publication::class)->filter(['text'=>$request->query->get('search'),
  607.                     'category' => 1], 4);
  608.             }else{
  609.                 $news = [];
  610.             }
  612.             $json = [];
  613.             /** @var Publication $n */
  614.             foreach ($news as $n){
  615.                 $json[$n->getId()] = [
  616.                     'title' => $n->getTitle(),
  617.                     'url' => $this->generateUrl('app_publication_show', ['slug' => $n->getSlug()]),
  618.                 ];
  619.             }
  621.             return new JsonResponse($json);
  622.         }else{
  623.             if ($request->query->get('search')){
  624.                 $news = $doctrine->getRepository(Publication::class)->filter(['text'=>$request->query->get('search'),
  625.                     'category' => 1], -1);
  626.             }else{
  627.                 $news = [];
  628.             }
  629.             $pagination = $paginator->paginate(
  630.                 $news,
  631.                 $request->query->getInt('page', 1), /*page number*/
  632.                 10 /*limit per page*/
  633.             );
  636.             return $this->render('new/index/search.html.twig', [
  637.                 'publications' => $pagination,
  638.                 'action'=> 'search',
  639.             ]);
  640.         }
  642.     }
  644.     #[Route('/person/json', name: 'app_person', options: ['expose' => true])]
  645.     public function personByCategory(ManagerRegistry $doctrine, Request $request, UploaderHelper $helper): Response
  646.     {
  648.         if ($request->query->get('categoryId')){
  649.             $personCategories = $doctrine->getRepository(PersonCategory::class)->findBy(['id'=>$request->query->get('categoryId')], ['sort'=>'ASC']);
  650.             $persons = $doctrine->getRepository(Person::class)->findBy(['category' => $personCategories[0]],['priority'=>'ASC']);
  651.         }else{
  652.             $persons = [];
  653.         }
  655.         $json = [];
  656.         /** @var Person $p */
  657.         foreach ($persons as $p){
  658.             $json[$p->getId()] = [
  659.                 'title' => $p->getName(),
  660.                 'postwork' => $p->getPost(),
  661.                 'phone' => $p->getPhone(),
  662.                 'email' => $p->getEmail(),
  663.                 'image' => $helper->asset($p,'imageFile'),
  664.                 'preview' => $helper->asset($p,'previewFile'),
  665.             ];
  666.         }
  668.         return new JsonResponse($json);
  670.     }
  672.     #[Route('/project/korolev', name: 'app_project_korolev')]
  673.     public function projectKorolev(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  674.     {
  675.         $id = 2;
  676.         $project = $doctrine->getRepository(Project::class)->findOneBy(['id'=> $id, 'enabled'=>true]);
  677.         $projectItems0 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']);
  678.         $projectItems0Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']));
  679.         $projectItems0Count = ceil($projectItems0Count/8);
  680.         $projectItems1 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']);
  681.         $projectItems1Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']));
  682.         $projectItems1Count = ceil($projectItems1Count/8);
  684.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'korolev']);
  685.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  687.         if ($request->getMethod() == 'POST' && $request->request->get('name') && $request->request->get('email')) {
  688.             $order = [
  689.                 'name' => $request->request->get('name'),
  690.                 'email' => $request->request->get('email'),
  691.                 'phone' => $request->request->get('phone'),
  692.                 'comment' => $request->request->get('comment'),
  693.             ];
  694.             $mailhtml = $this->renderView('mail/contacts_2.html.twig', ['order' => $order]);
  695.             $message = (new \Swift_Message('Новый запрос из формы земельных участков'))
  696.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  697.                 ->setTo(['marketing@mosregco.ru'])
  698.                 ->setBody(
  699.                     $mailhtml
  700.                     ,
  701.                     'text/html'
  702.                 );
  704. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  705. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  707.             $mailer->send($message);
  708.             $this->addFlash('modal', 'formSuccess');
  709.             return $this->render('new/index/project_korolev.html.twig', [
  710.                 'project'=>$project,
  711.                 'projectItems0' => $projectItems0,
  712.                 'projectItems1'=>$projectItems1,
  713.                 'post' => true,
  714.                 'projectItems0Count' => $projectItems0Count,
  715.                 'projectItems1Count' => $projectItems1Count,
  716.                 'blocks' => $this->blocks,
  717.                 'action'=> 'korolev',
  718.                 'page'=> $page,
  719.                 'pageBlocks'=> $pageBlocks,
  721.             ]);
  722.         }
  725.         return $this->render('new/index/project_korolev.html.twig', [
  726.             'project'=>$project,
  727.             'projectItems0' => $projectItems0,
  728.             'projectItems1'=>$projectItems1,
  729.             'projectItems0Count' => $projectItems0Count,
  730.             'projectItems1Count' => $projectItems1Count,
  731.             'blocks' => $this->blocks,
  732.             'action'=> 'korolev',
  733.             'page'=> $page,
  734.             'pageBlocks'=> $pageBlocks,
  735.         ]);
  736.     }
  738.     #[Route('/project/jukovskii', name: 'app_project_jukovskii')]
  739.     public function projectJukovskii(EntityManagerInterface $manager, Request $request, \Swift_Mailer $mailer): Response
  740.     {
  741.         return new Response('');
  743.         if ($request->getMethod() == 'POST'){
  746.             $order = [
  747.                 'name' => $request->request->get('name'),
  748.                 'phone' => $request->request->get('phone'),
  749.             ];
  752.             $client = CRest::call(
  754.                 'crm.contact.add',
  755.                 ['FIELDS' => [
  756.                     'NAME' => $request->request->get('name') ,
  757.                     'PHONE' => ['0' => ['VALUE' => $request->request->get('phone'), 'VALUE_TYPE' => 'WORK' ]],
  758.                 ]
  759.                 ]
  760.             );
  762.             $fields = [
  763.                 'CLIENT_ID' => $client['result'],
  764.                 'TITLE' => 'Новая заявка Жуковский (главная страница)'
  765.             ];
  766.             $result = CRest::call(
  767.                 'crm.deal.add',
  768.                 ['FIELDS' => $fields]
  769.             );
  771.             $mailhtml = $this->renderView('mail/jukovskii_contact_form.html.twig', ['order' => $order]);
  772.             $message = (new \Swift_Message('Запрос со страницы Жуковский '))
  773.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  774.                 ->setTo(['marketing@mosregco.ru'])
  775.                 ->setBody(
  776.                     $mailhtml
  777.                     ,
  778.                     'text/html'
  779.                 );
  781. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  782. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  784.             $mailer->send($message);
  786.         }
  788.         $data1 = [
  789.             [
  790.                 'title' => 'Пищевая промышленность',
  791.                 'desc' => 'Производство пищевых продуктов, мясо, молочные продукты, хлеб и др.',
  792.                 'img' => 'ic_10.svg',
  793.             ],
  794.             [
  795.                 'title' => 'Легкая промышленность',
  796.                 'desc' => 'Текстильные изделия, одежда, кожаные изделия, обувь и др.',
  797.                 'img' => 'ic_9.svg',
  798.             ],
  799.             [
  800.                 'title' => 'Медицинское производство',
  801.                 'desc' => 'Производство лекарственных средств и медицинской техники',
  802.                 'img' => 'ic_8.svg',
  803.             ],
  804.             [
  805.                 'title' => 'Химическое производство',
  806.                 'desc' => 'Производство химических веществ , резиновых и пластмассовых изделий',
  807.                 'img' => 'ic_7.svg',
  808.             ],
  809.             [
  810.                 'title' => 'Строительная промышленность',
  811.                 'desc' => 'Материалы для строительства, кроме размещения АБЗ',
  812.                 'img' => 'ic_7.svg',
  813.             ],
  814.             [
  815.                 'title' => 'Машиностроение',
  816.                 'desc' => 'производство транспортных средств, прицепов, полуприцепов и так далее, ремонт и монтаж',
  817.                 'img' => 'ic_6.svg',
  818.             ],
  819.             [
  820.                 'title' => 'Полиграфия',
  821.                 'desc' => 'Производство бумаги и бумажных изделий, полиграфии',
  822.                 'img' => 'ic_5.svg',
  823.             ],
  824.             [
  825.                 'title' => 'Электроника',
  826.                 'desc' => 'Компьютеры, электронные и оптические изделия, электрическое оборудование',
  827.                 'img' => 'ic_4.svg',
  828.             ],
  829.             [
  830.                 'title' => 'Станкостроение',
  831.                 'desc' => 'производство оборудования и станков',
  832.                 'img' => 'ic_3.svg',
  833.             ],
  834.             [
  835.                 'title' => 'Деревообработка',
  836.                 'desc' => 'Производство мебели из дерева, изделий из дерева и др.',
  837.                 'img' => 'ic_2.svg',
  838.             ],
  839.             [
  840.                 'title' => 'Металлообработка',
  841.                 'desc' => 'Производство крупномасштабных конструкций, изделий из металла и др.',
  842.                 'img' => 'ic_1.svg',
  843.             ],
  844.         ];
  846.         $page = $manager->getRepository(Page::class)->findOneBy(['slug' => 'jukovskii']);
  847.         $pageBlocks = $manager->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  848.         $project = $manager->getRepository(Project::class)->find(3);
  849.         $jukSmi  = $manager->getRepository(JukSmi::class)->findAll();
  850.         $jukIcons  = $manager->getRepository(JukIcon::class)->findAll();
  851.         $gallery  = $manager->getRepository(Gallery::class)->find(3);
  853.         return $this->render('new/index/jukovskii.html.twig', [
  854.             'action'=> 'project',
  855.             'datas'=> $data1,
  856.             'page'=> $page,
  857.             'blocks' => $this->blocks,
  858.             'pageBlocks'=> $pageBlocks,
  859.             'project' => $project,
  860.             'jukSmi' => $jukSmi,
  861.             'jukIcons' => $jukIcons,
  862.             'gallery' => $gallery,
  863.         ]);
  864.     }
  866.     #[Route('/priceindex/{type}', name: 'app_priceindex', defaults: ["type"=>'area'])]
  867.     public function priceindex(EntityManagerInterface $manager, Request $request, \Swift_Mailer $mailer, $type = 'area'): Response
  868.     {
  871.         if ($type == 'area'){
  872.             $indexes = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  873.         }elseif ($type == 'home'){
  874.             $indexes = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  875.         }
  879.         $page = $manager->getRepository(Page::class)->findOneBy(['slug' => 'priceindex']);
  880.         $pageBlocks = $manager->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  882.         $indexPriceHome = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  883.         $tmpData = [];
  884.         /** @var PriceIndex $elems */
  885.         foreach ($indexPriceHome as $elems){
  886.             /** @var PriceIndexItem $tmpItem*/
  887.             foreach ($elems->getItems() as $tmpItem ){
  888.                 if ($tmpItem->getDate()->format('Y') == 2024){
  889.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  890.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  891.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  892.                     }else{
  893.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  894.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  895.                     }
  896.                 }
  897.             }
  898.         }
  899.         $indexPriceHome = $tmpData;
  902.         $indexPriceArea = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  903.         $tmpData = [];
  904.         /** @var PriceIndex $elems */
  905.         foreach ($indexPriceArea as $elems){
  906.             /** @var PriceIndexItem $tmpItem*/
  907.             foreach ($elems->getItems() as $tmpItem ){
  908.                 if ($tmpItem->getDate()->format('Y') == 2024){
  909.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  910.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  911.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  912.                     }else{
  913.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  914.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  915.                     }
  916.                 }
  917.             }
  918.         }
  919.         $indexPriceArea = $tmpData;
  923.         $indexPriceHomeElems = $manager->getRepository(PriceIndexItem::class)->filter('home');
  924.         $tmpData = [];
  925.         foreach ($indexPriceHomeElems as $tmp){
  926.             $tmpData[] = $tmp['price'];
  927.         }
  928.         $indexPriceHomeElems = $tmpData;
  930.         $indexPriceAreaElems = $manager->getRepository(PriceIndexItem::class)->filter('area');
  931.         $tmpData = [];
  932.         foreach ($indexPriceAreaElems as $tmp){
  933.             $tmpData[] = $tmp['price'];
  934.         }
  935.         $indexPriceAreaElems = $tmpData;
  937.         return $this->render('new/index/price_index.html.twig', [
  938.             'blocks' => $this->blocks,
  939.             'type'=>$type,
  940.             'page'=>$page,
  941.             'indexes'=>$indexes,
  942.             'pageBlocks'=>$pageBlocks,
  943.             'indexPriceHome' => $indexPriceHome,
  944.             'indexPriceArea' => $indexPriceArea,
  945.             'indexPriceHomeElems' => $indexPriceHomeElems,
  946.             'indexPriceAreaElems' => $indexPriceAreaElems,
  947.         ]);
  949.     }
  950.     #[Route('/project', name: 'app_project')]
  951.     public function project(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  952.     {
  953.         $id = 1;
  954.         $project = $doctrine->getRepository(Project::class)->findOneBy(['id'=> $id, 'enabled'=>true]);
  955.         $projectItems0 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']);
  956.         $projectItems0Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']));
  957.         $projectItems0Count = ceil($projectItems0Count/8);
  958.         $projectItems1 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']);
  959.         $projectItems1Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']));
  960.         $projectItems1Count = ceil($projectItems1Count/8);
  962.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'project']);
  963.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  965.         if ($request->getMethod() == 'POST') {
  966.             $order = [
  967.                 'name' => $request->request->get('name'),
  968.                 'email' => $request->request->get('email'),
  969.                 'phone' => $request->request->get('phone'),
  970.                 'comment' => $request->request->get('comment'),
  971.             ];
  972.             $mailhtml = $this->renderView('mail/contacts_2.html.twig', ['order' => $order]);
  973.             $message = (new \Swift_Message('Новый запрос из формы земельных участков'))
  974.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  975.                 ->setTo(['marketing@mosregco.ru'])
  976.                 ->setBody(
  977.                     $mailhtml
  978.                     ,
  979.                     'text/html'
  980.                 );
  982. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  983. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  985.             $mailer->send($message);
  986.             $this->addFlash('modal', 'formSuccess');
  987.             return $this->render('new/index/project.html.twig', [
  988.                 'project'=>$project,
  989.                 'projectItems0' => $projectItems0,
  990.                 'projectItems1'=>$projectItems1,
  991.                 'post' => true,
  992.                 'projectItems0Count' => $projectItems0Count,
  993.                 'projectItems1Count' => $projectItems1Count,
  994.                 'blocks' => $this->blocks,
  995.                 'action'=> 'project',
  996.                 'page'=> $page,
  997.                 'pageBlocks'=> $pageBlocks,
  999.             ]);
  1000.         }
  1003.         return $this->render('new/index/project.html.twig', [
  1004.             'project'=>$project,
  1005.             'projectItems0' => $projectItems0,
  1006.             'projectItems1'=>$projectItems1,
  1007.             'projectItems0Count' => $projectItems0Count,
  1008.             'projectItems1Count' => $projectItems1Count,
  1009.             'blocks' => $this->blocks,
  1010.             'action'=> 'project',
  1011.             'page'=> $page,
  1012.             'pageBlocks'=> $pageBlocks,
  1013.         ]);
  1014.     }
  1017.     #[Route('/localproject/list', name: 'app_localproject_list')]
  1018.     public function localprojectList(ManagerRegistry $doctrine): Response
  1019.     {
  1020.         $localProjects = $doctrine->getRepository(LocalProject::class)->findBy(['enabled' => true]);
  1021.         return $this->render('new/index/local_project_list.html.twig', ['projects'=>$localProjects]);
  1022.     }
  1024.     #[Route('/localproject/{id}', name: 'app_localproject')]
  1025.     public function localproject(ManagerRegistry $doctrine, $id): Response
  1026.     {
  1027.         $localProjects = $doctrine->getRepository(LocalProject::class)->otherProjects(['page'=>0, 'notId'=>$id]);
  1028.         $localProjectsCount = ceil(count($doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]))/4);
  1030.         $project = $doctrine->getRepository(LocalProject::class)->findOneBy(['id'=> $id, 'enabled'=>true]);
  1031.         return $this->render('new/index/local_project.html.twig', [
  1032.             'localProjects'=>$localProjects,
  1033.             'localProjectsCount'=>$localProjectsCount,
  1034.             'project'=>$project,
  1035.         ]);
  1036.     }
  1039.     #[Route('/projectitem', name: 'app_project_item')]
  1040.     public function projectitem(ManagerRegistry $doctrine, Request $request,UploaderHelper $helper): Response
  1041.     {
  1042.         $id = $request->query->get('id');
  1043.         $project = $doctrine->getRepository(ProjectItem::class)->findOneBy(['id'=> $id]);
  1045.         return $this->render('new/modals/project_item_content.html.twig', ['project'=>$project]);
  1046.     }
  1048.     #[Route('/project-item/{id}', name: 'app_iframe_project_item')]
  1049.     public function projectitemByIframe(ManagerRegistry $doctrine, Request $request, $id): Response
  1050.     {
  1051.         $project = $doctrine->getRepository(ProjectItem::class)->findOneBy(['id'=> $id]);
  1053.         return $this->render('new/project_item_iframe.html.twig', ['project'=>$project]);
  1054.     }
  1057.     #[Route('/projectitem-json', name: 'app_project_item_json')]
  1058.     public function projectitemJson(ManagerRegistry $doctrine, Request $request,UploaderHelper $helper): Response
  1059.     {
  1060.         $id = $request->query->get('id');
  1061.         $project = $doctrine->getRepository(ProjectItem::class)->findOneBy(['id'=> $id]);
  1063.         $json = [
  1064.             'area' => $project->getArea(),
  1066.             'image' => $helper->asset($project, 'mapFile'),
  1067.             'content' => $project->getContent()
  1068.         ];
  1069.         return new JsonResponse($json);
  1070.     }
  1075.     #[Route('/order/area/send', name: 'app_order_area_send')]
  1076.     public function orderAreaSend(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  1077.     {
  1080.         if ($request->getMethod() != 'POST'){
  1081.             return  $this->redirectToRoute('app_index');
  1082.         }
  1085.         if (!is_array($request->get('areaType', []))){
  1086.             $areaType = [$request->get('areaType')];
  1087.         }else{
  1088.             $areaType = $request->get('areaType', []);
  1089.         }
  1091.         if (!is_array($request->get('payType', []))){
  1092.             $payType = [$request->get('payType')];
  1093.         }else{
  1094.             $payType = $request->get('payType');
  1095.         }
  1096.         $userOrder = new UserOrder();
  1097.         $userOrder->setCreated(new \DateTime());
  1098.         if ($areaType){
  1099.             $userOrder->setTypeArea(implode(' ', $areaType));
  1100.         }
  1102.         if ($payType){
  1103.             $userOrder->setTypePrice(implode(' ', $payType));
  1104.         }
  1106.         $userOrder->setName($request->get('name'));
  1107. //        $userOrder->setEmail($request->get('email'));
  1108.         $userOrder->setPhone($request->get('phone'));
  1109.         $doctrine->getManager()->persist($userOrder);
  1110.         $doctrine->getManager()->flush();
  1111.         $doctrine->getManager()->refresh($userOrder);
  1113.         $fip = explode(' ', $_POST['name']);
  1115. //        $client = CRest::call(
  1116. //            'crm.contact.add',
  1117. //            ['FIELDS' => [
  1118. //                'LAST_NAME' => (isset($fip[0]) ? $fip[0] : '') ,
  1119. //                'NAME' => (isset($fip[1]) ? $fip[1] : '') ,
  1120. //                'SECOND_NAME' => (isset($fip[2]) ? $fip[2] : '') ,
  1121. //                'PHONE' => ['0' => ['VALUE' => $_POST['phone'], 'VALUE_TYPE' => 'WORK' ]],
  1122. //            ]
  1123. //            ]
  1124. //        );
  1125. //
  1126. //        $fields = [
  1127. //            'TITLE' => 'Заявка из модального окна',
  1128. //            'CLIENT_ID' => $client['result'],
  1129. //            'UF_CRM_1675845053079' => $this->zeml($client['areaType']),
  1130. //            'UF_CRM_1679571797939' => $client['payType'],
  1131. //
  1132. //            ];
  1133. //
  1134. //        $result = CRest::call(
  1135. //            'crm.deal.add',
  1136. //            ['FIELDS' => $fields]
  1137. //        );
  1138. //
  1139. //
  1140. //        $addcon = CRest::call(
  1141. //            'crm.deal.contact.add',
  1142. //            [
  1143. //                'ID' => $result['result'],
  1144. //                'FIELDS'=> [
  1145. //                    'CONTACT_ID'=>$client['result'],
  1146. //                    'SORT'=>0,
  1147. //                    'PRIMARY'=>true,
  1148. //                ]
  1149. //            ]
  1150. //        );
  1152.         if ($request->request->get('pr') == 1){
  1153.             $mailTitle = 'Подбор площадки. Королев.';
  1154.         }else{
  1155.             $mailTitle = 'Новый запрос на подбор участка';
  1156.         }
  1157. //        formType
  1158.         $formType = $request->request->get('formType', null);
  1159.         $mailhtml = $this->renderView('mail/order.html.twig', ['order'=>$userOrder, 'formType' => $formType]);
  1160.         $message = (new \Swift_Message($mailTitle))
  1161.             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  1162.             ->setTo(['marketing@mosregco.ru'])
  1163.             ->setBody(
  1164.                 $mailhtml
  1165.                 ,
  1166.                 'text/html'
  1167.             );
  1169.         $mailer->send($message);
  1171.         $str1 = $userOrder->getTypeArea();
  1172.         $str2 = $userOrder->getTypePrice();
  1173.         $result = CRest::call(
  1174.             'crm.lead.add',
  1175.             ['FIELDS' => [
  1176.                 'TITLE' => $mailTitle,
  1177.                 'NAME' => $userOrder->getName(),
  1178.                 'LAST_NAME' => '',
  1179.                 'EMAIL' => ['0' => ['VALUE' => '', 'VALUE_TYPE' => 'WORK', ], ],
  1180.                 'PHONE' => ['0' => ['VALUE' => $userOrder->getPhone(), 'VALUE_TYPE' => 'WORK', ], ],
  1181.                 'SOURCE_ID' => 'STORE',
  1182.                 'COMMENTS' => '',
  1183.                 'UF_CRM_1674208325432' => $str1.' '.$str2 ],
  1184.             ]
  1185.         );
  1188.         if ($request->isXmlHttpRequest()){
  1189.             return new JsonResponse(['status'=> 'success', 'data' => $result]);
  1190.         }else{
  1191.             $this->addFlash('modal', 'formSuccess');
  1192.             $referer = $request->headers->get('referer');
  1193.             return $this->redirect($referer);
  1194.         }
  1197.     }
  1200.     #[Route('/subscription/news', name: 'app_subscription')]
  1201.     public function subscription(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  1202.     {
  1203.         $email = $request->request->get('email');
  1204.         $user = $doctrine->getRepository(Subscribtion::class)->findOneBy(['email' => $email]);
  1205.         if ($user){
  1206.             if ($user->isCancel() == false){
  1207.                 $user->setCancel(true);
  1208.                 $doctrine->getManager()->flush();
  1210.                 if ($request->isXmlHttpRequest()){
  1211.                     return new JsonResponse(['status'=>'cancel', 'email'=>$email]);
  1212.                 }else{
  1213.                     $this->addFlash('modal', 'emailSuccess');
  1214.                     $referer = $request->headers->get('referer');
  1215.                     return $this->redirect($referer);
  1216.                 }
  1217.             }else{
  1218.                 $user->setCancel(true);
  1219.                 $user->setCreated(new \DateTime());
  1220.                 $doctrine->getManager()->flush();
  1222.                 if ($request->isXmlHttpRequest()){
  1223.                     return new JsonResponse(['status'=>'success', 'email'=>$email]);
  1224.                 }else{
  1225.                     $this->addFlash('modal', 'subscriberSuccess');
  1226.                     $referer = $request->headers->get('referer');
  1227.                     return $this->redirect($referer);
  1228.                 }
  1229.             }
  1230.         }else{
  1231.             $user = new Subscribtion();
  1232.             $user->setEmail($email);
  1233.             $doctrine->getManager()->persist($user);
  1234.             $doctrine->getManager()->flush();
  1235.             if ($request->isXmlHttpRequest()){
  1236.                 return new JsonResponse(['status'=>'success', 'email'=>$email]);
  1237.             }else{
  1238.                 $this->addFlash('modal', 'subscriberSuccess');
  1239.                 $referer = $request->headers->get('referer');
  1240.                 return $this->redirect($referer);
  1241.             }
  1243.         }
  1244.     }
  1246.     #[Route('/presentation/send', name: 'send_presentation', options: ['expose' => true] )]
  1247.     public function sendPresentation(
  1248.         ManagerRegistry $doctrine,
  1249.         Request $request,
  1250.         \Swift_Mailer $mailer,
  1251.         UploaderHelper $helper,
  1252.         ValidatorInterface $validator,
  1253.     ): Response
  1254.     {
  1255.         $presentationSendUserData = new PresentationSendUserData(
  1256.             trim($request->request->get('phone')),
  1257.             trim($request->request->get('email')),
  1258.         );
  1259.         $errors = $validator->validate($presentationSendUserData);
  1260.         $url = $request->headers->get('referer');
  1262.         if (count($errors) > 0) {
  1263.             $this->addFlash('modal', 'emailError');
  1264.             return $this->redirect($url ?? '/');
  1265.         }
  1267.         if ($request->query->get('type') == 'jukovskii'){
  1268.             $park = $doctrine->getRepository(Project::class)->find(3);
  1269.         }else{
  1270.             $park = $doctrine->getRepository(Project::class)->find(1);
  1271.         }
  1273.         $mailhtml = $this->renderView('mail/present.html.twig', [
  1274.             'email'=>$presentationSendUserData->getEmail(),
  1275.             'phone'=> $presentationSendUserData->getPhone(),
  1276.             'url' => $url
  1277.         ]);
  1278.         $message = (new \Swift_Message('Пользователь скачал презентацию'))
  1279.             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  1280.             ->setTo(['marketing@mosregco.ru'])
  1281.             ->setBody(
  1282.                 $mailhtml
  1283.                 ,
  1284.                 'text/html'
  1285.             );
  1287. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  1288. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  1290.         $result = CRest::call(
  1291.             'crm.lead.add',
  1292.             ['FIELDS' => [
  1293.                 'TITLE' => 'Скачивание презентации'.($request->query->get('type') == 'jukovskii' ? ' Жуковский' : ''),
  1294.                 'EMAIL' => ['0' => ['VALUE' => $request->request->get('email'), 'VALUE_TYPE' => 'WORK', ], ],
  1295.                 'PHONE' => ['0' => ['VALUE' => $request->request->get('phone'), 'VALUE_TYPE' => 'WORK', ], ],
  1296.                 'SOURCE_ID' => 'SITE',
  1297.                 'COMMENTS' => '',
  1298.             ],
  1299.             ]
  1300.         );
  1303.         $mailer->send($message);
  1304.         $this->addFlash('modal', 'emailSuccess');
  1306.         if ($request->query->get('type') == 'jukovskii'){
  1307.             return $this->redirect( 'https://mosregco.ru' . $helper->asset($park,'presentationFile') );
  1308.         }else{
  1309.             return new Response( $helper->asset($park,'presentationFile') );
  1310.         }
  1312.     }
  1316.     #[Route('/p/{slug}', name: 'app_index_page')]
  1317.     public function page(EntityManagerInterface $manager, $slug){
  1318.         $page = $manager->getRepository(Page::class)->findOneBy(['slug'=>$slug, 'enabled'=>true]);
  1319.         return $this->render('new/index/page.html.twig', ['page'=>$page]);
  1320. //        55.803479, 37.390514
  1321.     }
  1324.     #[Route('/sitemap.xml', defaults:['_format'=>'xml'])]
  1325.     public function xml(EntityManagerInterface $manager){
  1326.         $localprojects = $manager->getRepository(LocalProject::class)->findBy(['enabled'=>true]);
  1327.         $publications = $manager->getRepository(Publication::class)->findBy(['enabled'=>true],['id'=>'DESC']);
  1328.         return $this->render('new/xml.xml.twig', ['localprojects'=>$localprojects, 'publications' => $publications]);
  1329. //        55.803479, 37.390514
  1330.     }
  1332.     private function zeml($post)
  1333.     {
  1334.         if (in_array('Участок',$post) && in_array('Помещение',$post)){
  1335.             return 1788;
  1336.         }elseif(in_array('Участок',$post)){
  1337.             return 1786;
  1338.         }elseif(in_array('Помещение',$post)){
  1339.             return 1787;
  1340.         }
  1341.         return null;
  1342.     }
  1344.     #[Route('/testtesttest')]
  1345.     public function testest1c(\Swift_Mailer $mailer){
  1346.         $message = (new \Swift_Message('тест тест 2024'))
  1347.             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  1348.             ->setTo(['bhd.m@ya.ru'])
  1349.             ->setBody(
  1350.                 '<div>TEST</div>'
  1351.                 ,
  1352.                 'text/html'
  1353.             );
  1354.         $result = $mailer->send($message);
  1355.         dump($result);
  1356.         return $this->render('new/index/null.html.twig');
  1357.     }
  1360. }