src/Controller/IndexController.php line 481

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('/test-ps', name: 'app_test_ps')]
  212.     public function testPs(){
  213.         return $this->render('_test/index.html.twig');
  214.     }
  215.     
  216.     #[Route('/.well-known/acme-challenge/mgA7s-0tGAUQoi4x0RunYQdubFbLbK5qduzB6ZMl_b0', name: 'app_hello')]
  217.     public function hello(): Response
  218.     {
  219.         // Принудительно очищаем системный кэш через код
  220.         $cacheDir = $this->getParameter('kernel.cache_dir');
  221.         
  222.         return new Response('mgA7s-0tGAUQoi4x0RunYQdubFbLbK5qduzB6ZMl_b0.eAhR_HhmleA4zOdOioJjXrelMNMQAUZoIHQEAN4ULX4');
  223.     }
  224.     
  225.     #[Route('/ps/ps-page', name: 'app_ps_page')]
  226.     public function newPage(ManagerRegistry $doctrine, $oderNumber = false): Response
  227.     {
  228.         $itogs = $doctrine->getRepository(Itog::class)->findBy([],['title'=>'DESC']);
  229.         $news = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true],['created'=>'DESC']);
  230.         $projects = $doctrine->getRepository(project::class)->findBy(['enabled' => true]);
  231.         $localProjects = $doctrine->getRepository(LocalProject::class)->filter(['page'=>0]);
  232.         $localProjectsCount = ceil(count($doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]))/4);
  233.         $partners = $doctrine->getRepository(Partner::class)->findBy(['enabled' => true]);
  235.         $publicationCategory = $doctrine->getRepository(PublicationCategory::class)->find(1);
  236.         $publicationCategoryVideo = $doctrine->getRepository(PublicationCategory::class)->find(2);
  237.         $publicationCategorySmi = $doctrine->getRepository(PublicationCategory::class)->find(3);
  238.         $publicationCategoryJournal = $doctrine->getRepository(PublicationCategory::class)->find(4);
  239.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled'=>true]);
  241.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'category' => $publicationCategory], ['created'=>'DESC'], 6);
  242.         $publicationVideo = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategoryVideo], ['created'=>'DESC'], 6);
  243.         $publicationSmi = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategorySmi], ['created'=>'DESC'], 6);
  244.         $publicationJournal = $doctrine->getRepository(Publication::class)->findBy(['enabled' => true, 'isMain'=> true, 'category' => $publicationCategoryJournal], ['created'=>'DESC'], 6);
  245.         $reviews = $doctrine->getRepository(Review::class)->findAll();
  246.         shuffle($reviews);
  248.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'main']);
  249.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  251.         $indexPriceHome = $doctrine->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  252.         $tmpData = [];
  253.         /** @var PriceIndex $elems */
  254.         foreach ($indexPriceHome as $elems){
  255.             /** @var PriceIndexItem $tmpItem*/
  256.             foreach ($elems->getItems() as $tmpItem ){
  257.                 if ($tmpItem->getDate()->format('Y') == 2024){
  258.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  259.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  260.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  261.                     }else{
  262.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  263.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  264.                     }
  265.                 }
  267.             }
  268.         }
  269.         $indexPriceHome = $tmpData;
  272.         $indexPriceArea = $doctrine->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  273.         $tmpData = [];
  274.         /** @var PriceIndex $elems */
  275.         foreach ($indexPriceArea as $elems){
  276.             /** @var PriceIndexItem $tmpItem*/
  277.             foreach ($elems->getItems() as $tmpItem ){
  278.                 if ($tmpItem->getDate()->format('Y') == 2024){
  279.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  280.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  281.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  282.                     }else{
  283.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  284.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  285.                     }
  286.                 }
  287.             }
  288.         }
  289.         $indexPriceArea = $tmpData;
  292.         $indexPriceHomeElems = $doctrine->getRepository(PriceIndexItem::class)->filter('home');
  293.         $tmpData = [];
  294.         foreach ($indexPriceHomeElems as $tmp){
  295.             $tmpData[] = $tmp['price'];
  296.         }
  297.         $indexPriceHomeElems = $tmpData;
  299.         $indexPriceAreaElems = $doctrine->getRepository(PriceIndexItem::class)->filter('area');
  300.         $tmpData = [];
  301.         foreach ($indexPriceAreaElems as $tmp){
  302.             $tmpData[] = $tmp['price'];
  303.         }
  304.         $indexPriceAreaElems = $tmpData;
  305.         
  306.         return $this->render('ps_page.html.twig', [
  307.             'indexPriceHomeElems' => $indexPriceHomeElems,
  308.             'indexPriceAreaElems' => $indexPriceAreaElems,
  309.             'indexPriceHome' => $indexPriceHome,
  310.             'indexPriceArea' => $indexPriceArea,
  311.             'partners' => $partners,
  312. //            'charts' => $charts,
  313.             'news' => $news,
  314.             'projects' => $projects,
  315.             'localProjects' => $localProjects,
  316.             'localProjectsCount' => $localProjectsCount,
  317.             'oderNumber' => $oderNumber,
  318.             'publications' => $publications,
  319.             'publicationVideos' => $publicationVideo,
  320.             'publicationSmi' => $publicationSmi,
  321.             'publicationJournal' => $publicationJournal,
  322.             'categories' => $categories,
  323.             'blocks' => $this->blocks,
  324.             'reviews' => $reviews,
  325.             'action'=> 'index',
  326.             'itogs'=> $itogs,
  327.             'page'=> $page,
  328.             'pageBlocks'=> $pageBlocks,
  329.         ]);
  330.     }
  332.     #[Route('/rss', name: 'app_rss', defaults: ["_format" => "xml"])]
  333.     public function rss(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request): Response
  334.     {
  335.         $category = $doctrine->getRepository(PublicationCategory::class)->findOneBy(['slug' => 'news']);
  336.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $category],['created'=>'DESC']);
  338.         return  $this->render('rss.html.twig', ['publications'=>$publications]);
  339.     }
  341.     #[Route('/publications/{type}', name: 'app_publications', defaults: ['type' => 'news'])]
  342.     public function publications(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request, $type = 'news'): Response
  343.     {
  345.         $category = $doctrine->getRepository(PublicationCategory::class)->findOneBy(['slug' => $type]);
  347.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled' => true]);
  348.         if ($request->query->get('newId')){
  349.             $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $category, 'parent' => $request->query->get('newId')],['created'=>'DESC']);
  350.         }else{
  351.             $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $category],['created'=>'DESC']);
  352.         }
  354.         $videosCategory = $doctrine->getRepository(PublicationCategory::class)->find(2);
  355.         $videos = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $videosCategory ],['created'=>'DESC'], 3);
  359.         $pagination = $paginator->paginate(
  360.             $publications,
  361.             $request->query->getInt('page', 1), /*page number*/
  362.             6 /*limit per page*/
  363.         );
  365.         return $this->render('new/index/publications.html.twig', [
  366.             'publications' => $pagination,
  367.             'category' => $category,
  368.             'videos' => $videos,
  369.             'categories' => $categories,
  370.             'action'=> 'publications',
  371.         ]);
  372.     }
  375.     #[Route('/partners', name: 'app_partners')]
  376.     public function partners(ManagerRegistry $doctrine): Response
  377.     {
  378.         $partners = $doctrine->getRepository(Partner::class)->findBy(['enabled' => true]);
  380.         return $this->render('index/partners.html.twig', [
  381.             'partners' => $partners
  382.         ]);
  383.     }
  385.     #[Route('/404', name: 'app_error')]
  386.     public function error(ManagerRegistry $doctrine): Response
  387.     {
  389.         return $this->render('new/index/error.html.twig', [
  390.         ]);
  391.     }
  393.     #[Route('/contacts', name: 'app_contacts')]
  394.     public function contacts(
  395.         ManagerRegistry $doctrine,
  396.         Request $request,
  397.         \Swift_Mailer $mailer,
  398.         ValidatorInterface $validator,
  399.     ): Response
  400.     {
  401. //        Ключ сайта 6LeZ0HooAAAAAJqqEP7jAsh8o1kIN1yKLw19ATo6
  402. //        Секретный ключ 6LeZ0HooAAAAAL7a8xNrwIWes5rPE09FfX6nH8FW
  403.         $personCategories = $doctrine->getRepository(PersonCategory::class)->findBy(['inContact' => true]);
  404.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'contacts']);
  405.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  407.         if ($request->getMethod() == 'POST'){
  409.             if(isset($_POST['g-recaptcha-response'])){
  410.                 $captcha=$_POST['g-recaptcha-response'];
  411.                 if ( !$captcha ) {
  412. //                    $form->addError(new FormError('Не верна заполнена капча'));
  413. //                    return $this->render('@App/Modal/register_modal_element.html.twig', ['form' => $form->createView()]);
  414.                     return  $this->redirectToRoute('app_contacts');
  415.                 }
  417.                 $secretKey = "6LeZ0HooAAAAAL7a8xNrwIWes5rPE09FfX6nH8FW";
  419.                 $url = 'https://www.google.com/recaptcha/api/siteverify?secret=' . urlencode($secretKey) .  '&response=' . urlencode($captcha);
  420.                 $response = file_get_contents($url);
  421.                 $responseKeys = json_decode($response,true);
  422.                 if($responseKeys["success"] || true) {
  424.                     $contactSendUserData = new ContactSendUserData(
  425.                         trim($request->request->get('phone')),
  426.                         trim($request->request->get('email')),
  427.                         trim($request->request->get('name')),
  428.                         trim($request->request->get('comment')),
  429.                     );
  430.                     $errors = $validator->validate($contactSendUserData);
  432.                     if (count($errors) === 0) {
  433.                         $order = [
  434.                             'name' => $request->request->get('name'),
  435.                             'email' => $request->request->get('email'),
  436.                             'phone' => $request->request->get('phone'),
  437.                             'comment' => $request->request->get('comment'),
  438.                         ];
  439.                         $mailhtml = $this->renderView('mail/contacts.html.twig', ['order'=>$order]);
  440.                         $message = (new \Swift_Message('Новый запрос из формы контактов'))
  441.                             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  442.                             ->setTo(['marketing@mosregco.ru'])
  443.                             ->setBody(
  444.                                 $mailhtml
  445.                                 ,
  446.                                 'text/html'
  447.                             );
  449. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  450. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  452.                         $mailer->send($message);
  453.                         $this->addFlash('modal', 'emailSuccess');
  454.                     } else {
  455.                         $this->addFlash('modal', 'emailError');
  456.                     }
  457.                 }
  458.             }
  461.             return $this->render('new/index/contacts.html.twig', [
  462.                 'personCategories' => $personCategories,
  463.                 'blocks' => $this->blocks,
  464.                 'post' => true,
  465.                 'action'=> 'contacts',
  466.                 'page'=> $page,
  467.                 'pageBlocks'=> $pageBlocks,
  468.             ]);
  469.         }
  471.         return $this->render('new/index/contacts.html.twig', [
  472.             'blocks' => $this->blocks,
  473.             'personCategories' => $personCategories,
  474.             'action'=> 'contacts',
  475.             'page'=> $page,
  476.             'pageBlocks'=> $pageBlocks,
  477.         ]);
  478.     }
  480.     #[Route('/about', name: 'app_about')]
  481.     public function about(ManagerRegistry $doctrine): Response
  482.     {
  484.         $personCategories = $doctrine->getRepository(PersonCategory::class)->findBy([], ['sort'=>'ASC']);
  485.         $persons = $doctrine->getRepository(Person::class)->findBy(['category' => $personCategories[0], 'enabled'=>true],['priority'=>'ASC']);
  486.         $personsAll = $doctrine->getRepository(Person::class)->findBy(['enabled'=>true],['priority'=>'ASC']);
  487.         $localProjects = $doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]);
  488.         $page_1 = $doctrine->getRepository(Page::class)->findOneBy(['slug'=> 'about_1']);
  489.         $page_2 = $doctrine->getRepository(Page::class)->findOneBy(['slug'=> 'about_2']);
  490.         $page_3 = $doctrine->getRepository(Page::class)->findOneBy(['slug'=> 'about_3']);
  492.         $gallery = $doctrine->getRepository(Gallery::class)->findBy(['enabled'=> true]);
  493.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'about']);
  494.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  495.         $docsGroups = $doctrine->getRepository(DocumentGroup::class)->findAll();
  497.         return $this->render('new/index/about.html.twig', [
  498.             'docsGroups' => $docsGroups,
  499.             'personCategories' => $personCategories,
  500.             'persons' => $persons,
  501.             'personsAll' => $personsAll,
  502.             'localProjects' => $localProjects,
  503.             'page_1' => $page_1,
  504.             'page_2' => $page_2,
  505.             'page_3' => $page_3,
  506.             'gallery' => $gallery,
  507.             'blocks' => $this->blocks,
  508.             'action'=> 'about',
  509.             'page'=> $page,
  510.             'pageBlocks'=> $pageBlocks,
  511.         ]);
  512.     }
  514.     #[Route('/o-regione', name: 'app_region')]
  515.     public function oregione(ManagerRegistry $doctrine): Response
  516.     {
  518.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'o-regione']);
  519.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  521.         return $this->render('new/index/region.html.twig', [
  522.             'blocks' => $this->blocks,
  523.             'action'=> 'o-regione',
  524.             'page'=> $page,
  525.             'pageBlocks'=> $pageBlocks,
  526.         ]);
  527.     }
  529.     #[Route('/invest', name: 'app_invest')]
  530.     public function invest(ManagerRegistry $doctrine): Response
  531.     {
  532.         $localProjects = $doctrine->getRepository(LocalProject::class)->findBy(['enabled' => true]);
  534.         return $this->render('index/invest.html.twig', [
  535.             'localProjects' =>$localProjects
  536.         ]);
  537.     }
  539.     #[Route('/calc', name: 'app_calc')]
  540.     public function calc(ManagerRegistry $doctrine): Response
  541.     {
  542.         return $this->render('index/calc.html.twig');
  543.     }
  545.     #[Route('/policy', name: 'app_policy')]
  546.     public function policy(ManagerRegistry $doctrine): Response
  547.     {
  548.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug'=>'policy']);
  549.         return $this->render('new/index/page.html.twig',['page' => $page]);
  550.     }
  553.     #[Route('/publication/{slug}', name: 'app_publication_show', defaults: ['id'=>null])]
  554.     public function publication(ManagerRegistry $doctrine, $slug = null): Response
  555.     {
  558.         $publication = $doctrine->getRepository(Publication::class)->findOneBy(['slug'=>$slug, 'enabled'=>true]);
  560.         if (!$publication){
  561.             throw $this->createNotFoundException();
  562.         }
  563.         $categories = $doctrine->getRepository(PublicationCategory::class)->findBy(['enabled'=>true]);
  564.         $publications = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true],['created'=>'DESC'], 20);
  566.         $videosCategory = $doctrine->getRepository(PublicationCategory::class)->find(2);
  567.         $videos = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $videosCategory ],['created'=>'DESC'], 3);
  569.         $smiCategory = $doctrine->getRepository(PublicationCategory::class)->find(3);
  570.         $smi = $doctrine->getRepository(Publication::class)->findBy(['enabled'=>true, 'category' => $smiCategory ],['created'=>'DESC'], 3);
  573.         return $this->render('new/index/publication.html.twig', [
  574.             'categories' => $categories,
  575.             'videosCategory' => $videosCategory,
  576.             'videos' => $videos,
  577.             'news' => $publications,
  578.             'publication' => $publication,
  579.             'action'=> 'publications',
  580.             'smi'=> $smi,
  581.         ]);
  582.     }
  586.     #[Route('/publications/smi', name: 'app_publications_smi')]
  587.     public function publicationsSmi(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request): Response
  588.     {
  590.         $publications = $doctrine->getRepository(Smi::class)->findBy([],['created'=>'DESC']);
  591.         $pagination = $paginator->paginate(
  592.             $publications,
  593.             $request->query->getInt('page', 1), /*page number*/
  594.             10 /*limit per page*/
  595.         );
  597.         return $this->render('index/publications_smi.html.twig', [
  598.             'publications' => $pagination,
  599.             'action'=> 'publications',
  600.         ]);
  601.     }
  604.     #[Route('/search', name: 'app_search', options: ['expose' => true])]
  605.     public function search(ManagerRegistry $doctrine, PaginatorInterface $paginator, Request $request): Response
  606.     {
  609.         if ($request->isXmlHttpRequest()){
  610.             if ($request->query->get('search')){
  611.                 $news = $doctrine->getRepository(Publication::class)->filter(['text'=>$request->query->get('search'),
  612.                     'category' => 1], 4);
  613.             }else{
  614.                 $news = [];
  615.             }
  617.             $json = [];
  618.             /** @var Publication $n */
  619.             foreach ($news as $n){
  620.                 $json[$n->getId()] = [
  621.                     'title' => $n->getTitle(),
  622.                     'url' => $this->generateUrl('app_publication_show', ['slug' => $n->getSlug()]),
  623.                 ];
  624.             }
  626.             return new JsonResponse($json);
  627.         }else{
  628.             if ($request->query->get('search')){
  629.                 $news = $doctrine->getRepository(Publication::class)->filter(['text'=>$request->query->get('search'),
  630.                     'category' => 1], -1);
  631.             }else{
  632.                 $news = [];
  633.             }
  634.             $pagination = $paginator->paginate(
  635.                 $news,
  636.                 $request->query->getInt('page', 1), /*page number*/
  637.                 10 /*limit per page*/
  638.             );
  641.             return $this->render('new/index/search.html.twig', [
  642.                 'publications' => $pagination,
  643.                 'action'=> 'search',
  644.             ]);
  645.         }
  647.     }
  649.     #[Route('/person/json', name: 'app_person', options: ['expose' => true])]
  650.     public function personByCategory(ManagerRegistry $doctrine, Request $request, UploaderHelper $helper): Response
  651.     {
  653.         if ($request->query->get('categoryId')){
  654.             $personCategories = $doctrine->getRepository(PersonCategory::class)->findBy(['id'=>$request->query->get('categoryId')], ['sort'=>'ASC']);
  655.             $persons = $doctrine->getRepository(Person::class)->findBy(['category' => $personCategories[0]],['priority'=>'ASC']);
  656.         }else{
  657.             $persons = [];
  658.         }
  660.         $json = [];
  661.         /** @var Person $p */
  662.         foreach ($persons as $p){
  663.             $json[$p->getId()] = [
  664.                 'title' => $p->getName(),
  665.                 'postwork' => $p->getPost(),
  666.                 'phone' => $p->getPhone(),
  667.                 'email' => $p->getEmail(),
  668.                 'image' => $helper->asset($p,'imageFile'),
  669.                 'preview' => $helper->asset($p,'previewFile'),
  670.             ];
  671.         }
  673.         return new JsonResponse($json);
  675.     }
  677.     #[Route('/project/korolev', name: 'app_project_korolev')]
  678.     public function projectKorolev(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  679.     {
  680.         $id = 2;
  681.         $project = $doctrine->getRepository(Project::class)->findOneBy(['id'=> $id, 'enabled'=>true]);
  682.         $projectItems0 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']);
  683.         $projectItems0Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']));
  684.         $projectItems0Count = ceil($projectItems0Count/8);
  685.         $projectItems1 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']);
  686.         $projectItems1Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']));
  687.         $projectItems1Count = ceil($projectItems1Count/8);
  689.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'korolev']);
  690.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  692.         if ($request->getMethod() == 'POST' && $request->request->get('name') && $request->request->get('email')) {
  693.             $order = [
  694.                 'name' => $request->request->get('name'),
  695.                 'email' => $request->request->get('email'),
  696.                 'phone' => $request->request->get('phone'),
  697.                 'comment' => $request->request->get('comment'),
  698.             ];
  699.             $mailhtml = $this->renderView('mail/contacts_2.html.twig', ['order' => $order]);
  700.             $message = (new \Swift_Message('Новый запрос из формы земельных участков'))
  701.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  702.                 ->setTo(['marketing@mosregco.ru'])
  703.                 ->setBody(
  704.                     $mailhtml
  705.                     ,
  706.                     'text/html'
  707.                 );
  709. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  710. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  712.             $mailer->send($message);
  713.             $this->addFlash('modal', 'formSuccess');
  714.             return $this->render('new/index/project_korolev.html.twig', [
  715.                 'project'=>$project,
  716.                 'projectItems0' => $projectItems0,
  717.                 'projectItems1'=>$projectItems1,
  718.                 'post' => true,
  719.                 'projectItems0Count' => $projectItems0Count,
  720.                 'projectItems1Count' => $projectItems1Count,
  721.                 'blocks' => $this->blocks,
  722.                 'action'=> 'korolev',
  723.                 'page'=> $page,
  724.                 'pageBlocks'=> $pageBlocks,
  726.             ]);
  727.         }
  730.         return $this->render('new/index/project_korolev.html.twig', [
  731.             'project'=>$project,
  732.             'projectItems0' => $projectItems0,
  733.             'projectItems1'=>$projectItems1,
  734.             'projectItems0Count' => $projectItems0Count,
  735.             'projectItems1Count' => $projectItems1Count,
  736.             'blocks' => $this->blocks,
  737.             'action'=> 'korolev',
  738.             'page'=> $page,
  739.             'pageBlocks'=> $pageBlocks,
  740.         ]);
  741.     }
  743.     #[Route('/project/jukovskii', name: 'app_project_jukovskii')]
  744.     public function projectJukovskii(EntityManagerInterface $manager, Request $request, \Swift_Mailer $mailer): Response
  745.     {
  746.         return new Response('');
  748.         if ($request->getMethod() == 'POST'){
  751.             $order = [
  752.                 'name' => $request->request->get('name'),
  753.                 'phone' => $request->request->get('phone'),
  754.             ];
  757.             $client = CRest::call(
  759.                 'crm.contact.add',
  760.                 ['FIELDS' => [
  761.                     'NAME' => $request->request->get('name') ,
  762.                     'PHONE' => ['0' => ['VALUE' => $request->request->get('phone'), 'VALUE_TYPE' => 'WORK' ]],
  763.                 ]
  764.                 ]
  765.             );
  767.             $fields = [
  768.                 'CLIENT_ID' => $client['result'],
  769.                 'TITLE' => 'Новая заявка Жуковский (главная страница)'
  770.             ];
  771.             $result = CRest::call(
  772.                 'crm.deal.add',
  773.                 ['FIELDS' => $fields]
  774.             );
  776.             $mailhtml = $this->renderView('mail/jukovskii_contact_form.html.twig', ['order' => $order]);
  777.             $message = (new \Swift_Message('Запрос со страницы Жуковский '))
  778.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  779.                 ->setTo(['marketing@mosregco.ru'])
  780.                 ->setBody(
  781.                     $mailhtml
  782.                     ,
  783.                     'text/html'
  784.                 );
  786. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  787. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  789.             $mailer->send($message);
  791.         }
  793.         $data1 = [
  794.             [
  795.                 'title' => 'Пищевая промышленность',
  796.                 'desc' => 'Производство пищевых продуктов, мясо, молочные продукты, хлеб и др.',
  797.                 'img' => 'ic_10.svg',
  798.             ],
  799.             [
  800.                 'title' => 'Легкая промышленность',
  801.                 'desc' => 'Текстильные изделия, одежда, кожаные изделия, обувь и др.',
  802.                 'img' => 'ic_9.svg',
  803.             ],
  804.             [
  805.                 'title' => 'Медицинское производство',
  806.                 'desc' => 'Производство лекарственных средств и медицинской техники',
  807.                 'img' => 'ic_8.svg',
  808.             ],
  809.             [
  810.                 'title' => 'Химическое производство',
  811.                 'desc' => 'Производство химических веществ , резиновых и пластмассовых изделий',
  812.                 'img' => 'ic_7.svg',
  813.             ],
  814.             [
  815.                 'title' => 'Строительная промышленность',
  816.                 'desc' => 'Материалы для строительства, кроме размещения АБЗ',
  817.                 'img' => 'ic_7.svg',
  818.             ],
  819.             [
  820.                 'title' => 'Машиностроение',
  821.                 'desc' => 'производство транспортных средств, прицепов, полуприцепов и так далее, ремонт и монтаж',
  822.                 'img' => 'ic_6.svg',
  823.             ],
  824.             [
  825.                 'title' => 'Полиграфия',
  826.                 'desc' => 'Производство бумаги и бумажных изделий, полиграфии',
  827.                 'img' => 'ic_5.svg',
  828.             ],
  829.             [
  830.                 'title' => 'Электроника',
  831.                 'desc' => 'Компьютеры, электронные и оптические изделия, электрическое оборудование',
  832.                 'img' => 'ic_4.svg',
  833.             ],
  834.             [
  835.                 'title' => 'Станкостроение',
  836.                 'desc' => 'производство оборудования и станков',
  837.                 'img' => 'ic_3.svg',
  838.             ],
  839.             [
  840.                 'title' => 'Деревообработка',
  841.                 'desc' => 'Производство мебели из дерева, изделий из дерева и др.',
  842.                 'img' => 'ic_2.svg',
  843.             ],
  844.             [
  845.                 'title' => 'Металлообработка',
  846.                 'desc' => 'Производство крупномасштабных конструкций, изделий из металла и др.',
  847.                 'img' => 'ic_1.svg',
  848.             ],
  849.         ];
  851.         $page = $manager->getRepository(Page::class)->findOneBy(['slug' => 'jukovskii']);
  852.         $pageBlocks = $manager->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  853.         $project = $manager->getRepository(Project::class)->find(3);
  854.         $jukSmi  = $manager->getRepository(JukSmi::class)->findAll();
  855.         $jukIcons  = $manager->getRepository(JukIcon::class)->findAll();
  856.         $gallery  = $manager->getRepository(Gallery::class)->find(3);
  858.         return $this->render('new/index/jukovskii.html.twig', [
  859.             'action'=> 'project',
  860.             'datas'=> $data1,
  861.             'page'=> $page,
  862.             'blocks' => $this->blocks,
  863.             'pageBlocks'=> $pageBlocks,
  864.             'project' => $project,
  865.             'jukSmi' => $jukSmi,
  866.             'jukIcons' => $jukIcons,
  867.             'gallery' => $gallery,
  868.         ]);
  869.     }
  871.     #[Route('/priceindex/{type}', name: 'app_priceindex', defaults: ["type"=>'area'])]
  872.     public function priceindex(EntityManagerInterface $manager, Request $request, \Swift_Mailer $mailer, $type = 'area'): Response
  873.     {
  876.         if ($type == 'area'){
  877.             $indexes = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  878.         }elseif ($type == 'home'){
  879.             $indexes = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  880.         }
  884.         $page = $manager->getRepository(Page::class)->findOneBy(['slug' => 'priceindex']);
  885.         $pageBlocks = $manager->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  887.         $indexPriceHome = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'home'], ['id'=>'DESC']);
  888.         $tmpData = [];
  889.         /** @var PriceIndex $elems */
  890.         foreach ($indexPriceHome as $elems){
  891.             /** @var PriceIndexItem $tmpItem*/
  892.             foreach ($elems->getItems() as $tmpItem ){
  893.                 if ($tmpItem->getDate()->format('Y') == 2024){
  894.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  895.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  896.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  897.                     }else{
  898.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  899.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  900.                     }
  901.                 }
  902.             }
  903.         }
  904.         $indexPriceHome = $tmpData;
  907.         $indexPriceArea = $manager->getRepository(PriceIndex::class)->findBy(['type'=>'area'], ['id'=>'DESC']);
  908.         $tmpData = [];
  909.         /** @var PriceIndex $elems */
  910.         foreach ($indexPriceArea as $elems){
  911.             /** @var PriceIndexItem $tmpItem*/
  912.             foreach ($elems->getItems() as $tmpItem ){
  913.                 if ($tmpItem->getDate()->format('Y') == 2024){
  914.                     if (isset($tmpData['prices'][$tmpItem->getDate()->format('m')])){
  915.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] += $tmpItem->getPrice();
  916.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] += 1;
  917.                     }else{
  918.                         $tmpData['prices'][$tmpItem->getDate()->format('m')] = $tmpItem->getPrice();
  919.                         $tmpData['counts'][$tmpItem->getDate()->format('m')] = 1;
  920.                     }
  921.                 }
  922.             }
  923.         }
  924.         $indexPriceArea = $tmpData;
  928.         $indexPriceHomeElems = $manager->getRepository(PriceIndexItem::class)->filter('home');
  929.         $tmpData = [];
  930.         foreach ($indexPriceHomeElems as $tmp){
  931.             $tmpData[] = $tmp['price'];
  932.         }
  933.         $indexPriceHomeElems = $tmpData;
  935.         $indexPriceAreaElems = $manager->getRepository(PriceIndexItem::class)->filter('area');
  936.         $tmpData = [];
  937.         foreach ($indexPriceAreaElems as $tmp){
  938.             $tmpData[] = $tmp['price'];
  939.         }
  940.         $indexPriceAreaElems = $tmpData;
  942.         return $this->render('new/index/price_index.html.twig', [
  943.             'blocks' => $this->blocks,
  944.             'type'=>$type,
  945.             'page'=>$page,
  946.             'indexes'=>$indexes,
  947.             'pageBlocks'=>$pageBlocks,
  948.             'indexPriceHome' => $indexPriceHome,
  949.             'indexPriceArea' => $indexPriceArea,
  950.             'indexPriceHomeElems' => $indexPriceHomeElems,
  951.             'indexPriceAreaElems' => $indexPriceAreaElems,
  952.         ]);
  954.     }
  955.     #[Route('/project', name: 'app_project')]
  956.     public function project(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  957.     {
  958.         $id = 1;
  959.         $project = $doctrine->getRepository(Project::class)->findOneBy(['id'=> $id, 'enabled'=>true]);
  960.         $projectItems0 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']);
  961.         $projectItems0Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '0']));
  962.         $projectItems0Count = ceil($projectItems0Count/8);
  963.         $projectItems1 = $doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']);
  964.         $projectItems1Count = count($doctrine->getRepository(ProjectItem::class)->findBy(['project' => $project, 'type' => '1']));
  965.         $projectItems1Count = ceil($projectItems1Count/8);
  967.         $page = $doctrine->getRepository(Page::class)->findOneBy(['slug' => 'project']);
  968.         $pageBlocks = $doctrine->getRepository(PagePageBlock::class)->findBy(['Page'=>$page],['sort'=>'ASC']);
  970.         if ($request->getMethod() == 'POST') {
  971.             $order = [
  972.                 'name' => $request->request->get('name'),
  973.                 'email' => $request->request->get('email'),
  974.                 'phone' => $request->request->get('phone'),
  975.                 'comment' => $request->request->get('comment'),
  976.             ];
  977.             $mailhtml = $this->renderView('mail/contacts_2.html.twig', ['order' => $order]);
  978.             $message = (new \Swift_Message('Новый запрос из формы земельных участков'))
  979.                 ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  980.                 ->setTo(['marketing@mosregco.ru'])
  981.                 ->setBody(
  982.                     $mailhtml
  983.                     ,
  984.                     'text/html'
  985.                 );
  987. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  988. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  990.             $mailer->send($message);
  991.             $this->addFlash('modal', 'formSuccess');
  992.             return $this->render('new/index/project.html.twig', [
  993.                 'project'=>$project,
  994.                 'projectItems0' => $projectItems0,
  995.                 'projectItems1'=>$projectItems1,
  996.                 'post' => true,
  997.                 'projectItems0Count' => $projectItems0Count,
  998.                 'projectItems1Count' => $projectItems1Count,
  999.                 'blocks' => $this->blocks,
  1000.                 'action'=> 'project',
  1001.                 'page'=> $page,
  1002.                 'pageBlocks'=> $pageBlocks,
  1004.             ]);
  1005.         }
  1008.         return $this->render('new/index/project.html.twig', [
  1009.             'project'=>$project,
  1010.             'projectItems0' => $projectItems0,
  1011.             'projectItems1'=>$projectItems1,
  1012.             'projectItems0Count' => $projectItems0Count,
  1013.             'projectItems1Count' => $projectItems1Count,
  1014.             'blocks' => $this->blocks,
  1015.             'action'=> 'project',
  1016.             'page'=> $page,
  1017.             'pageBlocks'=> $pageBlocks,
  1018.         ]);
  1019.     }
  1022.     #[Route('/localproject/list', name: 'app_localproject_list')]
  1023.     public function localprojectList(ManagerRegistry $doctrine): Response
  1024.     {
  1025.         $localProjects = $doctrine->getRepository(LocalProject::class)->findBy(['enabled' => true]);
  1026.         return $this->render('new/index/local_project_list.html.twig', ['projects'=>$localProjects]);
  1027.     }
  1029.     #[Route('/localproject/{id}', name: 'app_localproject')]
  1030.     public function localproject(ManagerRegistry $doctrine, $id): Response
  1031.     {
  1032.         $localProjects = $doctrine->getRepository(LocalProject::class)->otherProjects(['page'=>0, 'notId'=>$id]);
  1033.         $localProjectsCount = ceil(count($doctrine->getRepository(LocalProject::class)->findBy(['enabled'=>true]))/4);
  1035.         $project = $doctrine->getRepository(LocalProject::class)->findOneBy(['id'=> $id, 'enabled'=>true]);
  1036.         return $this->render('new/index/local_project.html.twig', [
  1037.             'localProjects'=>$localProjects,
  1038.             'localProjectsCount'=>$localProjectsCount,
  1039.             'project'=>$project,
  1040.         ]);
  1041.     }
  1044.     #[Route('/projectitem', name: 'app_project_item')]
  1045.     public function projectitem(ManagerRegistry $doctrine, Request $request,UploaderHelper $helper): Response
  1046.     {
  1047.         $id = $request->query->get('id');
  1048.         $project = $doctrine->getRepository(ProjectItem::class)->findOneBy(['id'=> $id]);
  1050.         return $this->render('new/modals/project_item_content.html.twig', ['project'=>$project]);
  1051.     }
  1053.     #[Route('/project-item/{id}', name: 'app_iframe_project_item')]
  1054.     public function projectitemByIframe(ManagerRegistry $doctrine, Request $request, $id): Response
  1055.     {
  1056.         $project = $doctrine->getRepository(ProjectItem::class)->findOneBy(['id'=> $id]);
  1058.         return $this->render('new/project_item_iframe.html.twig', ['project'=>$project]);
  1059.     }
  1062.     #[Route('/projectitem-json', name: 'app_project_item_json')]
  1063.     public function projectitemJson(ManagerRegistry $doctrine, Request $request,UploaderHelper $helper): Response
  1064.     {
  1065.         $id = $request->query->get('id');
  1066.         $project = $doctrine->getRepository(ProjectItem::class)->findOneBy(['id'=> $id]);
  1068.         $json = [
  1069.             'area' => $project->getArea(),
  1071.             'image' => $helper->asset($project, 'mapFile'),
  1072.             'content' => $project->getContent()
  1073.         ];
  1074.         return new JsonResponse($json);
  1075.     }
  1080.     #[Route('/order/area/send', name: 'app_order_area_send')]
  1081.     public function orderAreaSend(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  1082.     {
  1085.         if ($request->getMethod() != 'POST'){
  1086.             return  $this->redirectToRoute('app_index');
  1087.         }
  1090.         if (!is_array($request->get('areaType', []))){
  1091.             $areaType = [$request->get('areaType')];
  1092.         }else{
  1093.             $areaType = $request->get('areaType', []);
  1094.         }
  1096.         if (!is_array($request->get('payType', []))){
  1097.             $payType = [$request->get('payType')];
  1098.         }else{
  1099.             $payType = $request->get('payType');
  1100.         }
  1101.         $userOrder = new UserOrder();
  1102.         $userOrder->setCreated(new \DateTime());
  1103.         if ($areaType){
  1104.             $userOrder->setTypeArea(implode(' ', $areaType));
  1105.         }
  1107.         if ($payType){
  1108.             $userOrder->setTypePrice(implode(' ', $payType));
  1109.         }
  1111.         $userOrder->setName($request->get('name'));
  1112. //        $userOrder->setEmail($request->get('email'));
  1113.         $userOrder->setPhone($request->get('phone'));
  1114.         $doctrine->getManager()->persist($userOrder);
  1115.         $doctrine->getManager()->flush();
  1116.         $doctrine->getManager()->refresh($userOrder);
  1118.         $fip = explode(' ', $_POST['name']);
  1120. //        $client = CRest::call(
  1121. //            'crm.contact.add',
  1122. //            ['FIELDS' => [
  1123. //                'LAST_NAME' => (isset($fip[0]) ? $fip[0] : '') ,
  1124. //                'NAME' => (isset($fip[1]) ? $fip[1] : '') ,
  1125. //                'SECOND_NAME' => (isset($fip[2]) ? $fip[2] : '') ,
  1126. //                'PHONE' => ['0' => ['VALUE' => $_POST['phone'], 'VALUE_TYPE' => 'WORK' ]],
  1127. //            ]
  1128. //            ]
  1129. //        );
  1130. //
  1131. //        $fields = [
  1132. //            'TITLE' => 'Заявка из модального окна',
  1133. //            'CLIENT_ID' => $client['result'],
  1134. //            'UF_CRM_1675845053079' => $this->zeml($client['areaType']),
  1135. //            'UF_CRM_1679571797939' => $client['payType'],
  1136. //
  1137. //            ];
  1138. //
  1139. //        $result = CRest::call(
  1140. //            'crm.deal.add',
  1141. //            ['FIELDS' => $fields]
  1142. //        );
  1143. //
  1144. //
  1145. //        $addcon = CRest::call(
  1146. //            'crm.deal.contact.add',
  1147. //            [
  1148. //                'ID' => $result['result'],
  1149. //                'FIELDS'=> [
  1150. //                    'CONTACT_ID'=>$client['result'],
  1151. //                    'SORT'=>0,
  1152. //                    'PRIMARY'=>true,
  1153. //                ]
  1154. //            ]
  1155. //        );
  1157.         if ($request->request->get('pr') == 1){
  1158.             $mailTitle = 'Подбор площадки. Королев.';
  1159.         }else{
  1160.             $mailTitle = 'Новый запрос на подбор участка';
  1161.         }
  1162. //        formType
  1163.         $formType = $request->request->get('formType', null);
  1164.         $mailhtml = $this->renderView('mail/order.html.twig', ['order'=>$userOrder, 'formType' => $formType]);
  1165.         $message = (new \Swift_Message($mailTitle))
  1166.             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  1167.             ->setTo(['marketing@mosregco.ru'])
  1168.             ->setBody(
  1169.                 $mailhtml
  1170.                 ,
  1171.                 'text/html'
  1172.             );
  1174.         $mailer->send($message);
  1176.         $str1 = $userOrder->getTypeArea();
  1177.         $str2 = $userOrder->getTypePrice();
  1178.         $result = CRest::call(
  1179.             'crm.lead.add',
  1180.             ['FIELDS' => [
  1181.                 'TITLE' => $mailTitle,
  1182.                 'NAME' => $userOrder->getName(),
  1183.                 'LAST_NAME' => '',
  1184.                 'EMAIL' => ['0' => ['VALUE' => '', 'VALUE_TYPE' => 'WORK', ], ],
  1185.                 'PHONE' => ['0' => ['VALUE' => $userOrder->getPhone(), 'VALUE_TYPE' => 'WORK', ], ],
  1186.                 'SOURCE_ID' => 'STORE',
  1187.                 'COMMENTS' => '',
  1188.                 'UF_CRM_1674208325432' => $str1.' '.$str2 ],
  1189.             ]
  1190.         );
  1193.         if ($request->isXmlHttpRequest()){
  1194.             return new JsonResponse(['status'=> 'success', 'data' => $result]);
  1195.         }else{
  1196.             $this->addFlash('modal', 'formSuccess');
  1197.             $referer = $request->headers->get('referer');
  1198.             return $this->redirect($referer);
  1199.         }
  1202.     }
  1205.     #[Route('/subscription/news', name: 'app_subscription')]
  1206.     public function subscription(ManagerRegistry $doctrine, Request $request, \Swift_Mailer $mailer): Response
  1207.     {
  1208.         $email = $request->request->get('email');
  1209.         $user = $doctrine->getRepository(Subscribtion::class)->findOneBy(['email' => $email]);
  1210.         if ($user){
  1211.             if ($user->isCancel() == false){
  1212.                 $user->setCancel(true);
  1213.                 $doctrine->getManager()->flush();
  1215.                 if ($request->isXmlHttpRequest()){
  1216.                     return new JsonResponse(['status'=>'cancel', 'email'=>$email]);
  1217.                 }else{
  1218.                     $this->addFlash('modal', 'emailSuccess');
  1219.                     $referer = $request->headers->get('referer');
  1220.                     return $this->redirect($referer);
  1221.                 }
  1222.             }else{
  1223.                 $user->setCancel(true);
  1224.                 $user->setCreated(new \DateTime());
  1225.                 $doctrine->getManager()->flush();
  1227.                 if ($request->isXmlHttpRequest()){
  1228.                     return new JsonResponse(['status'=>'success', 'email'=>$email]);
  1229.                 }else{
  1230.                     $this->addFlash('modal', 'subscriberSuccess');
  1231.                     $referer = $request->headers->get('referer');
  1232.                     return $this->redirect($referer);
  1233.                 }
  1234.             }
  1235.         }else{
  1236.             $user = new Subscribtion();
  1237.             $user->setEmail($email);
  1238.             $doctrine->getManager()->persist($user);
  1239.             $doctrine->getManager()->flush();
  1240.             if ($request->isXmlHttpRequest()){
  1241.                 return new JsonResponse(['status'=>'success', 'email'=>$email]);
  1242.             }else{
  1243.                 $this->addFlash('modal', 'subscriberSuccess');
  1244.                 $referer = $request->headers->get('referer');
  1245.                 return $this->redirect($referer);
  1246.             }
  1248.         }
  1249.     }
  1251.     #[Route('/presentation/send', name: 'send_presentation', options: ['expose' => true] )]
  1252.     public function sendPresentation(
  1253.         ManagerRegistry $doctrine,
  1254.         Request $request,
  1255.         \Swift_Mailer $mailer,
  1256.         UploaderHelper $helper,
  1257.         ValidatorInterface $validator,
  1258.     ): Response
  1259.     {
  1260.         $presentationSendUserData = new PresentationSendUserData(
  1261.             trim($request->request->get('phone')),
  1262.             trim($request->request->get('email')),
  1263.         );
  1264.         $errors = $validator->validate($presentationSendUserData);
  1265.         $url = $request->headers->get('referer');
  1267.         if (count($errors) > 0) {
  1268.             $this->addFlash('modal', 'emailError');
  1269.             return $this->redirect($url ?? '/');
  1270.         }
  1272.         if ($request->query->get('type') == 'jukovskii'){
  1273.             $park = $doctrine->getRepository(Project::class)->find(3);
  1274.         }else{
  1275.             $park = $doctrine->getRepository(Project::class)->find(1);
  1276.         }
  1278.         $mailhtml = $this->renderView('mail/present.html.twig', [
  1279.             'email'=>$presentationSendUserData->getEmail(),
  1280.             'phone'=> $presentationSendUserData->getPhone(),
  1281.             'url' => $url
  1282.         ]);
  1283.         $message = (new \Swift_Message('Пользователь скачал презентацию'))
  1284.             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  1285.             ->setTo(['marketing@mosregco.ru'])
  1286.             ->setBody(
  1287.                 $mailhtml
  1288.                 ,
  1289.                 'text/html'
  1290.             );
  1292. //            $logger = new \Swift_Plugins_Loggers_EchoLogger();
  1293. //            $mailer->registerPlugin(new \Swift_Plugins_LoggerPlugin($logger));
  1295.         $result = CRest::call(
  1296.             'crm.lead.add',
  1297.             ['FIELDS' => [
  1298.                 'TITLE' => 'Скачивание презентации'.($request->query->get('type') == 'jukovskii' ? ' Жуковский' : ''),
  1299.                 'EMAIL' => ['0' => ['VALUE' => $request->request->get('email'), 'VALUE_TYPE' => 'WORK', ], ],
  1300.                 'PHONE' => ['0' => ['VALUE' => $request->request->get('phone'), 'VALUE_TYPE' => 'WORK', ], ],
  1301.                 'SOURCE_ID' => 'SITE',
  1302.                 'COMMENTS' => '',
  1303.             ],
  1304.             ]
  1305.         );
  1308.         $mailer->send($message);
  1309.         $this->addFlash('modal', 'emailSuccess');
  1311.         if ($request->query->get('type') == 'jukovskii'){
  1312.             return $this->redirect( 'https://mosregco.ru' . $helper->asset($park,'presentationFile') );
  1313.         }else{
  1314.             return new Response( $helper->asset($park,'presentationFile') );
  1315.         }
  1317.     }
  1321.     #[Route('/p/{slug}', name: 'app_index_page')]
  1322.     public function page(EntityManagerInterface $manager, $slug){
  1323.         $page = $manager->getRepository(Page::class)->findOneBy(['slug'=>$slug, 'enabled'=>true]);
  1324.         return $this->render('new/index/page.html.twig', ['page'=>$page]);
  1325. //        55.803479, 37.390514
  1326.     }
  1329.     #[Route('/sitemap.xml', defaults:['_format'=>'xml'])]
  1330.     public function xml(EntityManagerInterface $manager){
  1331.         $localprojects = $manager->getRepository(LocalProject::class)->findBy(['enabled'=>true]);
  1332.         $publications = $manager->getRepository(Publication::class)->findBy(['enabled'=>true],['id'=>'DESC']);
  1333.         return $this->render('new/xml.xml.twig', ['localprojects'=>$localprojects, 'publications' => $publications]);
  1334. //        55.803479, 37.390514
  1335.     }
  1337.     private function zeml($post)
  1338.     {
  1339.         if (in_array('Участок',$post) && in_array('Помещение',$post)){
  1340.             return 1788;
  1341.         }elseif(in_array('Участок',$post)){
  1342.             return 1786;
  1343.         }elseif(in_array('Помещение',$post)){
  1344.             return 1787;
  1345.         }
  1346.         return null;
  1347.     }
  1349.     #[Route('/testtesttest')]
  1350.     public function testest1c(\Swift_Mailer $mailer){
  1351.         $message = (new \Swift_Message('тест тест 2024'))
  1352.             ->setFrom('marketing@mosregco.ru', 'marketing@mosregco.ru')
  1353.             ->setTo(['bhd.m@ya.ru'])
  1354.             ->setBody(
  1355.                 '<div>TEST</div>'
  1356.                 ,
  1357.                 'text/html'
  1358.             );
  1359.         $result = $mailer->send($message);
  1360.         dump($result);
  1361.         return $this->render('new/index/null.html.twig');
  1362.     }
  1365. }