src/Controller/Admin/AdminController.php line 60

Open in your IDE?
  1. <?php
  3. namespace Slivki\Controller\Admin;
  5. use Imagine\Gd\Imagine;
  6. use Imagine\Image\Box;
  7. use Imagine\Image\Point;
  8. use League\Period\Period;
  9. use Slivki\Dao\Statistic\VirtualWallet\VirtualWalletDaoInterface;
  10. use Slivki\Dbal\Category\CategoryDbalInterface;
  11. use Slivki\Entity\AbstractOrderBase;
  12. use Slivki\Entity\AdSlot;
  13. use Slivki\Entity\CategoryType;
  14. use Slivki\Entity\CityArea;
  15. use Slivki\Entity\MailingCampaign;
  16. use Slivki\Entity\Sale;
  17. use Slivki\Entity\SiteSettings;
  18. use Slivki\Entity\User;
  19. use Slivki\Entity\UserBalanceActivity;
  20. use Slivki\Entity\UserGroup;
  21. use Slivki\Repository\Category\Admin\CategoryChildRelationRepositoryInterface;
  22. use Slivki\Repository\GiftCertificate\GiftCertificateGroup\Admin\GiftCertificateGroupRepositoryInterface;
  23. use Slivki\Repository\GiftCertificateCategory\Admin\GiftCertificateCategoryRepositoryInterface;
  24. use Slivki\Repository\GiftCertificateGiftCategory\Admin\GiftCertificateGiftCategoryRepositoryInterface;
  25. use Slivki\Repository\UserRepository;
  26. use Slivki\Services\CategoryBoxCacheService;
  27. use Slivki\Services\StatService;
  28. use Symfony\Component\Routing\Annotation\Route;
  29. use Slivki\Controller\SiteController;
  30. use Slivki\Entity\Banner;
  31. use Slivki\Entity\Category;
  32. use Slivki\Entity\City;
  33. use Slivki\Entity\Comment;
  34. use Slivki\Entity\HotFeed;
  35. use Slivki\Services\ImageService;
  36. use Slivki\Services\Mailer;
  37. use Symfony\Component\Filesystem\Filesystem;
  38. use Slivki\Entity\MainMenu;
  39. use Slivki\Entity\Media;
  40. use Slivki\Entity\MediaType;
  41. use Slivki\Entity\OperatorActionLog;
  42. use Slivki\Entity\Seo;
  43. use Slivki\Entity\Offer;
  44. use Slivki\Repository\SeoRepository;
  45. use Symfony\Component\HttpFoundation\JsonResponse;
  46. use Symfony\Component\HttpFoundation\Request;
  47. use Symfony\Component\HttpFoundation\Response;
  48. use Symfony\Component\DomCrawler\Crawler;
  49. use Symfony\Component\HttpKernel\KernelInterface;
  50. use Symfony\Component\Validator\Constraints\Email as EmailConstraint;
  51. use Symfony\Component\Validator\Validator\ValidatorInterface;
  53. class AdminController extends SiteController
  54. {
  55.     private const DEFAULT_CATEGORY_SORT_ORDER = 9999;
  57.     /**
  58.      * @Route("/admin/ajax_check_version")
  59.      */
  60.     public function ajaxCheckVersionAction() {
  61.         $twigGlobals = $this->get('twig')->getGlobals();
  62.         return new Response($twigGlobals['version']);
  63.     }
  65.     /** @Route("/admin/dashboard") */
  66.     public function ajaxDashboardAction(
  67.         Request $request,
  68.         StatService $statService,
  69.         VirtualWalletDaoInterface $virtualWalletDao
  70.     ): Response {
  71.         if (!$request->isXmlHttpRequest()) {
  72.             return $this->redirect("/admin");
  73.         }
  74.         $entityManager = $this->getEntityManager();
  75.         $connection = $entityManager->getConnection();
  76.         $requestDateFrom = $request->request->get('dashboardDateFrom');
  77.         $requestDateTo = $request->request->get('dashboardDateTo');
  78.         $dateFrom = $requestDateFrom ? (new \DateTime())->setTimestamp(strtotime($requestDateFrom)) : (new \DateTime())->setTime(0, 0, 0);
  79.         $dateTo = $requestDateTo ? (new \DateTime())->setTimestamp(strtotime($requestDateTo)) : (new \DateTime())->setTime(0, 0, 0);
  80.         $dateTo->add(new \DateInterval('P1D'));
  81.         $from = $dateFrom->format('Y-m-d 00:00:00');
  82.         $to = $dateTo->format('Y-m-d 00:00:00');
  83.         $period = new \DatePeriod($dateFrom, \DateInterval::createFromDateString('+1 day'), $dateTo);
  85.         $sql = "select date(created_on) as x, coalesce(sum(amount), 0) as y from offer_order where created_on between '$from' and '$to' and status = "
  86.             . AbstractOrderBase::STATUS_BALANCE_CONFIRM . ' group by 1';
  87.         $balanceReplenishmentChartData = $this->getChartData($period, $connection->executeQuery($sql)->fetchAll());
  89.         $dateTo->sub(new \DateInterval('P1D'));
  90.         $codesCountByDatesStat = $statService->getCodesCountByDates($dateFrom, $dateTo);
  91.         $codesChartData = [
  92.             'x' => [],
  93.             'total' => [],
  94.             'free' => [],
  95.             'online' => [],
  96.             'balance' => [],
  97.         ];
  98.         $appCodesChartData = $codesChartData;
  99.         foreach ($codesCountByDatesStat as $key => $item) {
  100.             if ($key == 'aggregate') {
  101.                 continue;
  102.             }
  103.             $codesChartData['x'][] = $key;
  104.             $codesChartData['total'][] = $item['total']['total'];
  105.             $codesChartData['balance'][] = $item['total']['balance'];
  106.             $codesChartData['free'][] = $item['total']['free'];
  107.             $codesChartData['online'][] = $item['total']['online'];
  108.             $appCodesChartData['x'][] = $key;
  109.             $appCodesChartData['total'][] = $item['app']['total'];
  110.             $appCodesChartData['balance'][] = $item['app']['balance'];
  111.             $appCodesChartData['free'][] = $item['app']['free'];
  112.             $appCodesChartData['online'][] = $item['app']['online'];
  113.         }
  115.         return $this->render('Slivki/admin/dashboard/index.html.twig', [
  116.             'dateFrom' => $dateFrom,
  117.             'dateTo' => $dateTo,
  118.             'balanceReplenishmentChartData' => $balanceReplenishmentChartData,
  119.             'virtualWalletChartData' => $this->getChartData($period, $virtualWalletDao->getChartData(
  120.                 Period::fromDatePeriod($period)
  121.             )),
  122.             'codesCountByDatesStat' => $codesCountByDatesStat,
  123.             'codesChartData' => $codesChartData,
  124.             'appCodesChartData' => $appCodesChartData,
  125.             'codesByDevicesChartData' => [
  126.                 $codesCountByDatesStat['aggregate']['desktop']['total'],
  127.                 $codesCountByDatesStat['aggregate']['mobile']['total'],
  128.                 $codesCountByDatesStat['aggregate']['app']['total']
  129.             ],
  130.             'codesByDevicesFreeChartData' => [
  131.                 $codesCountByDatesStat['aggregate']['desktop']['free'],
  132.                 $codesCountByDatesStat['aggregate']['desktop']['total'] - $codesCountByDatesStat['aggregate']['desktop']['free'],
  133.                 $codesCountByDatesStat['aggregate']['mobile']['free'],
  134.                 $codesCountByDatesStat['aggregate']['mobile']['total'] - $codesCountByDatesStat['aggregate']['mobile']['free'],
  135.                 $codesCountByDatesStat['aggregate']['app']['free'],
  136.                 $codesCountByDatesStat['aggregate']['app']['total'] - $codesCountByDatesStat['aggregate']['app']['free']
  137.             ],
  138.             'codesByTypesChartData' => [
  139.                 $codesCountByDatesStat['aggregate']['total']['balance'],
  140.                 $codesCountByDatesStat['aggregate']['total']['free'],
  141.                 $codesCountByDatesStat['aggregate']['total']['online']
  142.             ]
  143.         ]);
  144.     }
  146.     private function getChartData($period, $data): array
  147.     {
  148.         $chartData = ['x' => [], 'y' => []];
  149.         $dataByX = [];
  150.         foreach ($data as $item) {
  151.             $dataByX[$item['x']] = $item['y'];
  152.         }
  153.         /** @var \DateTime $tick */
  154.         foreach ($period as $tick) {
  155.             $chartData['x'][] = $tick->format('d.m.Y');
  156.             if (isset($dataByX[$tick->format('Y-m-d')])) {
  157.                 $chartData['y'][] = $dataByX[$tick->format('Y-m-d')];
  158.             } else {
  159.                 $chartData['y'][] = 0;
  160.             }
  161.         }
  162.         return $chartData;
  163.     }
  165.     /**
  166.      * @Route("/admin/offer/descriptions/{offerID}/{descriptionType}")
  167.      */
  168.     public function descriptionsAction($offerID, $descriptionType) {
  169.         $entityManager = $this->getDoctrine()->getManager('admin');
  170.         $sql = "select description from entity_description_version where entity_id = $offerID and entity_type_id = 1 and type_id = $descriptionType order by id desc limit 1";
  171.         return new Response('<textarea>'.$entityManager->getConnection()->executeQuery($sql)->fetchColumn().'</textarea>');
  172.     }
  174.     /**
  175.      * @Route("/admin")
  176.      */
  177.     public function adminAction(
  178.         GiftCertificateCategoryRepositoryInterface $giftCertificateCategoryRepository,
  179.         GiftCertificateGroupRepositoryInterface $giftCertificateGroupRepository,
  180.         GiftCertificateGiftCategoryRepositoryInterface $giftCertificateGiftCategoryRepository
  181.     ) {
  182.         ini_set('memory_limit', '1g');
  183.         ini_set('max_execution_time', 240);
  184.         $entityManager = $this->getEntityManager();
  185.         $categoryRepository = $entityManager->getRepository(Category::class);
  187.         return $this->render('Slivki/admin/index.html.twig', [
  188.             'managerList' =>  $entityManager->getRepository(UserGroup::class)->findOneByName('MANAGER')->getUsers(),
  189.             'cityAreaList' => $entityManager->getRepository(CityArea::class)->findBy([], ['name' => 'ASC']),
  190.             'priceCategoriesDefault' => $categoryRepository->findBy(['domainObjectID' => Category::PRICE_CATEGORY_ID, 'typeID' => Category::DEFAULT_PRICE_CATEGORY_TYPE], ['sortOrder' => 'ASC']),
  191.             'priceCategoriesTourism' => $categoryRepository->findBy(['domainObjectID' => Category::PRICE_CATEGORY_ID, 'typeID' => Category::TOURISM_PRICE_CATEGORY_TYPE], ['sortOrder' => 'ASC']),
  192.             'genderCategories' => $categoryRepository->findBy(['domainObjectID' => Category::GENDER_CATEGORY_ID], ['sortOrder' => 'ASC']),
  193.             'tourismTourTypes' => $categoryRepository->findBy(['domainObjectID' => Category::TOUR_TYPE_CATEGORY_ID], ['sortOrder' => 'ASC']),
  194.             'tourismTransportType' => $categoryRepository->findBy(['domainObjectID' => Category::TRANSPORT_TYPE_CATEGORY_ID], ['sortOrder' => 'ASC']),
  195.         ]);
  196.     }
  198.     /**
  199.      * @Route("/admin/category/ajax_get_category")
  200.      */
  201.     public function ajaxGetCategoryAction(
  202.         Request $request,
  203.         ImageService $imageService,
  204.         CategoryChildRelationRepositoryInterface $categoryChildRelationRepository
  205.     ) {
  206.         ini_set('memory_limit', '256m');
  207.         if (!$request->isXmlHttpRequest()) {
  208.             return $this->redirect("/admin");
  209.         }
  210.         $entityManager = $this->getDoctrine()->getManager("admin");
  211.         $categoryID = $request->request->get('categoryID');
  212.         $categoryRepository = $entityManager->getRepository(Category::class);
  213.         /** @var Category $category */
  214.         $category = $categoryRepository->find($categoryID);
  215.         $categoryType = $category->getCategoryType() ? $category->getCategoryType()->getID() : Category::DEFAULT_CATEGORY_TYPE;
  216.         $seoRepository = $entityManager->getRepository(Seo::class);
  217.         $requestDomainObjectID = $request->request->get('domainObjectID');
  218.         $resourceURL = 'Slivki:Default:category';
  219.         $mainMenuType = null;
  220.         $cityID = $category->getCity() ? $category->getCity()->getID() : City::DEFAULT_CITY_ID;
  221.         switch($requestDomainObjectID) {
  222.             case Category::OFFER_CATEGORY_ID:
  223.                 $resourceURL = 'Slivki:Default:category';
  224.                 $mainMenuType = MainMenu::TYPE_OFFER_CATEGORY;
  225.                 $selectedCategoryIDList = [];
  226.                 foreach ($category->getParentCategories() as $parentCategory) {
  227.                     $selectedCategoryIDList[] = $parentCategory->getID();
  228.                 }
  229.                 $data['categories'] = $categoryRepository->getCategoryTree(Category::OFFER_CATEGORY_ID, 0, $cityID);
  230.                 $data['selectedCategoryIDList'] = $selectedCategoryIDList;
  231.                 $result['parentCategories'] = $this->get('twig')->render('Slivki/admin/categories/recursive_category_with_checkboxes_macro.html.twig', $data);
  232.                 $result['selectedParentCategories'] = $this->get('twig')->render('Slivki/admin/categories/selected_parent_categories.html.twig', ['selectedCategoryList' =>  $category->getParentCategories()]);
  233.                 $result['categoryChildRelation'] = $categoryChildRelationRepository->findByChildId($categoryID);
  234.                 break;
  235.             case Category::SALE_CATEGORY_ID:
  236.                 $resourceURL = 'Slivki:Sale:category';
  237.                 $mainMenuType = MainMenu::TYPE_SALE_CATEGORY;
  238.                 $selectedCategoryIDList = [];
  239.                 foreach ($category->getParentCategories() as $parentCategory) {
  240.                     $selectedCategoryIDList[] = $parentCategory->getID();
  241.                 }
  242.                 $data['categories'] = $categoryRepository->getCategoryTree(Category::SALE_CATEGORY_ID);
  243.                 $data['selectedCategoryIDList'] = $selectedCategoryIDList;
  244.                 $result['parentCategories'] = $this->get('twig')->render('Slivki/admin/categories/recursive_category_with_checkboxes_macro.html.twig', $data);
  245.                 break;
  246.             case Category::DISCOUNT_CARD_CATEGORY_ID:
  247.                 $resourceURL = 'Slivki:DiscountCard:category';
  248.                 break;
  249.         }
  250.         if($mainMenuType) {
  251.             $isCategoryInMainMenu = $entityManager->getRepository(MainMenu::class)->findOneBy(['entityID' => $categoryID, 'type' => $mainMenuType]);
  252.         }
  253.         $result['isCategoryInMainMenu'] = $isCategoryInMainMenu instanceof MainMenu;
  255.         $alias = $seoRepository->findBy(array('entityID' => $categoryID, 'resourceURL' => $resourceURL), array('ID' => 'DESC'), 1);
  256.         $result['category'] = $category;
  257.         $result['lastModified'] = $category->getLastModified()->format('Y-m-d H:i:s');
  258.         $result['categoryType'] = $categoryType;
  259.         $result['categoryBanner'] = $this->get('twig')->render('Slivki/admin/banners/list.html.twig', ['bannerList' => $category->getBannersByType(Banner::TYPE_CATEGORY_BANNER)]);
  260.         $adSlotRepository = $entityManager->getRepository(AdSlot::class);
  261.         $result['categoryBannersAdSlot'][1]['usedAdSlot'] = $category->getCountActiveBannersByType(Banner::TYPE_CATEGORY_BANNER);
  262.         $adSlotObjects = $adSlotRepository->findBy(['bannerTypeID' => 1, 'categoryID' => $categoryID]);
  263.         if (!empty($adSlotObjects)) {
  264.             $result['categoryBannersAdSlot'][1]['activeAdSlot'] = $adSlotObjects[0]->getActiveAdSlot();
  265.         } else {
  266.             $result['categoryBannersAdSlot'][1]['activeAdSlot'] = 0;
  267.         }
  268.         $result['verticalTeaserBanner'] = $this->get('twig')->render('Slivki/admin/banners/vertical_teaser_banner/list.html.twig', ['bannerList' => $category->getBannersByType(Banner::TYPE_TEASER_VERTICAL_BANNER)]);
  269.         $result['categoryBannersAdSlot'][2]['usedAdSlot'] = $category->getCountActiveBannersByType(Banner::TYPE_TEASER_BANNER);
  270.         $adSlotObjects = $adSlotRepository->findBy(['bannerTypeID' => 2, 'categoryID' => $categoryID]);
  271.         if (!empty($adSlotObjects)) {
  272.             $result['categoryBannersAdSlot'][2]['activeAdSlot'] = $adSlotObjects[0]->getActiveAdSlot();
  273.         } else {
  274.             $result['categoryBannersAdSlot'][2]['activeAdSlot'] = 0;
  275.         }
  276.         $result['teaserBanner'] = $this->get('twig')->render('Slivki/admin/banners/teaser_banner/list.html.twig', ['bannerList' => $category->getBannersByType(Banner::TYPE_TEASER_BANNER)]);
  277.         $result['categoryBannersAdSlot'][3]['usedAdSlot'] = $category->getCountActiveBannersByType(Banner::TYPE_TEASER_BANNER);
  278.         $adSlotObjects = $adSlotRepository->findBy(['bannerTypeID' => 3, 'categoryID' => $categoryID]);
  279.         if (!empty($adSlotObjects)) {
  280.             $result['categoryBannersAdSlot'][3]['activeAdSlot'] = $adSlotObjects[0]->getActiveAdSlot();
  281.         } else {
  282.             $result['categoryBannersAdSlot'][3]['activeAdSlot'] = 0;
  283.         }
  284.         if($alias) {
  285.             $alias = $alias[0];
  286.             $result['alias'] = $alias->getMainAlias();
  287.             $result['metaTitle'] = $alias->getMetaTitle();
  288.             $result['metaDescription'] = $alias->getMetaDescription();
  289.             $result['metaKeywords'] = $alias->getMetaKeywords();
  290.         }
  291.         $commentAlias = $seoRepository->getByEntity(SeoRepository::RESOURCE_URL_CATEGORY_COMMENTS, $categoryID);
  292.         if ($commentAlias) {
  293.             $result['commentALias']['alias']= $commentAlias->getMainAlias();
  294.             $result['commentALias']['metaTitle'] = $commentAlias->getMetaTitle();
  295.             $result['commentALias']['metaDescription'] = $commentAlias->getMetaDescription();
  296.             $result['commentALias']['metaKeywords'] = $commentAlias->getMetaKeywords();
  297.         }
  299.         $landingImage = $entityManager->getRepository(Media::class)->getСategoryLandingImageMedia($categoryID);
  300.         $result['landingImage'] = $landingImage ? $imageService->getImageURL($landingImage, 0, 0) : '';
  301.         $hotFeed = $entityManager->getRepository(HotFeed::class)->findBy(['entityTypeID' => Category::CATEGORY_ID, 'entityID' => $categoryID]);
  302.         if ($hotFeed) {
  303.             $result['hotFeed'] = true;
  304.         }
  305.         $hotFeedImage = $entityManager->getRepository(Media::class)->getСategoryHotFeedImageMedia($categoryID);
  306.         $hotFeedIcon = $entityManager->getRepository(Media::class)->getСategoryHotFeedIconMedia($categoryID);
  307.         $result['hotFeedImage'] = $hotFeedImage ? $imageService->getImageURL($hotFeedImage, 0, 0) : '';
  308.         $result['hotFeedIcon'] = $hotFeedIcon ? $imageService->getImageURL($hotFeedIcon, 0, 0) : '';
  309.         $mobileMenuIcon = $category->getMobileMenuIconMedia();
  310.         $result['mobileMenuIcon'] = $mobileMenuIcon ? $imageService->getImageURL($mobileMenuIcon, 0, 0) : '';
  311.         $appIcon = $category->getAppIconMedia();
  312.         $result['appIcon'] = $appIcon ? $imageService->getImageURL($appIcon, 0, 0) : '';
  313.         $mapPinIcon = $category->getMapPinIconMedia();
  314.         $result['mapPinIcon'] = $mapPinIcon ? $imageService->getImageURL($mapPinIcon, 0, 0) : '';
  315.         return new Response(json_encode($result));
  316.     }
  318.     /**
  319.      * @Route("/admin/category/ajax_add_category")
  320.      */
  321.     public function ajaxAddCategoryAction(Request $request, ImageService $imageService, CategoryDbalInterface $categoryDbal) {
  322.         if (!$request->isXmlHttpRequest()) {
  323.             return $this->redirect("/admin");
  324.         }
  326.         $entityManager = $this->getDoctrine()->getManager("admin");
  327.         $categoryRepository =  $entityManager->getRepository(Category::class);
  328.         $cityID = $request->request->get('edit-category-city-id', City::DEFAULT_CITY_ID);
  329.         if ($cityID == '') {
  330.             $cityID = City::DEFAULT_CITY_ID;
  331.         }
  332.         $city = $entityManager->getRepository(City::class)->find($cityID);
  333.         $category = new Category();
  334.         if ($city) {
  335.             $category->setCity($city);
  336.         }
  337.         $category->setName(trim($request->request->get('edit-category-name')));
  338.         $h1 = trim($request->request->get('editCategoryH1', ''));
  339.         $category->setH1($h1 == '' ? null : $h1);
  340.         $category->setSortOrder(
  341.             $request->request->getInt('edit-category-order') ?: self::DEFAULT_CATEGORY_SORT_ORDER
  342.         );
  343.         $category->setTelegramBotName(trim($request->request->get('editCategoryTelegramBotName')));
  344.         $category->setTelegramBotShow($request->request->getBoolean('editCategoryTelegramBotShow'));
  345.         $category->setPosition($request->request->getInt('editСategoryPosition'));
  346.         $category->setCode($request->request->get('edit-category-code'));
  347.         $category->setTopCount((int)$request->request->get('edit-category-tops'));
  348.         $category->setPast(false);
  349.         $category->setLastModified(new \DateTime());
  350.         $category->setInMenuBottom($request->request->has('inMenuBottom'));
  351.         $category->setUtmCampaign($request->request->get('editCategoryUtmCampaign'));
  352.         $category->setSplitOffersWithSameCategories($request->request->getInt('splitOffersWithSameCategories'));
  353.         $category->setUnpopular($request->request->has('unpopular'));
  354.         $category->setFeaturedInMenu($request->request->getBoolean('categoryFeaturedInMenu'));
  355.         $category->setShowItemsCatalog($request->request->getBoolean('showItemsCatalog'));
  356.         $category->setHideWorkExamples($request->request->getBoolean('hideWorkExamples'));
  357.         $category->setIsBonusCode($request->request->getBoolean('isBonusCode'));
  360.         $categoryTypeID = $request->request->getInt('edit-category-group');
  361.         $categoryType = $entityManager->find(CategoryType::class, $categoryTypeID);
  362.         if ($categoryType) {
  363.             $category->setCategoryType($categoryType);
  364.         }
  365.         if ($request->request->get('edit-category-active')) {
  366.             $category->setActive(true);
  367.         } else {
  368.             $category->setActive(false);
  369.         }
  370.         $category->setDescription($request->request->get('edit-category-description'));
  371.         $requestDomainObjectID = $request->request->get('edit-category-domain-object-id');
  372.         $category->setDomainObjectID($requestDomainObjectID);
  373.         $entityManager->persist($category);
  375.         $categoryDbal->updateChildBonusCodes($category->getID(), $category->isBonusCode());
  377.         $this->getCategoryRepository()->scheduleCategoryReload($category->getID());
  379.         $requestCategoryBannerList = $request->request->get('admin-category-banner-id', []);
  380.         foreach ($requestCategoryBannerList as $index => $bannerID) {
  381.             $banner = $entityManager->getRepository(Banner::class)->find($bannerID);
  382.             if($banner) {
  383.                 if ($request->request->get('admin-category-banner-deleted')[$index] == "true") {
  384.                     $category->deleteBanner($banner);
  385.                 } else {
  386.                     $category->addBanner($banner);
  387.                 }
  388.                 $entityManager->flush($banner);
  389.             }
  390.         }
  392.         $requestTeaserBannerList = $request->request->get('admin-teaser-banner-id', []);
  393.         foreach ($requestTeaserBannerList as $index => $bannerID) {
  394.             $banner = $entityManager->getRepository(Banner::class)->find($bannerID);
  395.             if($banner) {
  396.                 if ($request->request->get('admin-teaser-banner-deleted')[$index] == "true") {
  397.                     $category->deleteBanner($banner);
  398.                 } else {
  399.                     $category->addBanner($banner);
  400.                 }
  401.                 $entityManager->flush($banner);
  402.             }
  403.         }
  405.         $requestVerticalTeaserBannerList = $request->request->get('admin-vertical-teaser-banner-id', []);
  406.         foreach ($requestVerticalTeaserBannerList as $index => $bannerID) {
  407.             $banner = $entityManager->getRepository(Banner::class)->find($bannerID);
  408.             if($banner) {
  409.                 if ($request->request->get('admin-vertical-teaser-banner-deleted')[$index] == "true") {
  410.                     $category->deleteBanner($banner);
  411.                 } else {
  412.                     $category->addBanner($banner);
  413.                 }
  414.                 $entityManager->flush($banner);
  415.             }
  416.         }
  418.         $alias = new Seo();
  419.         $seoRepository = $entityManager->getRepository(Seo::class);
  420.         $requestAlias = $request->request->get('edit-category-alias');
  421.         if (trim($requestAlias) == '') {
  422.             $result = array(
  423.                 'title' => 'Ошибка!',
  424.                 'message' => 'Введите алиас',
  425.                 'type' => 'modal-danger'
  426.             );
  427.             return new Response(json_encode($result));
  428.         }
  429.         if ($requestAlias[0] != '/') {
  430.             $requestAlias = '/' . $requestAlias;
  431.         }
  432.         $alias->setMainAlias($requestAlias);
  433.         $alias->setEntityID($category->getID());
  434.         $alias->setActive(true);
  435.         $alias->setMetaTitle($request->request->get('edit-category-meta-title'));
  436.         $alias->setMetaDescription($request->request->get('edit-category-meta-description'));
  437.         $alias->setMetaKeywords($request->request->get('edit-category-meta-keywords'));
  438.         $alias->setDomain($city->getDomain());
  439.         switch($requestDomainObjectID) {
  440.             case Category::OFFER_CATEGORY_ID:
  441.                 $alias->setResourceURL('Slivki:Default:category');
  442.                 break;
  443.             case Category::SALE_CATEGORY_ID:
  444.                 $alias->setResourceURL('Slivki:Sale:category');
  445.                 break;
  446.             case Category::DISCOUNT_CARD_CATEGORY_ID:
  447.                 $alias->setResourceURL('Slivki:DiscountCard:category');
  448.                 break;
  449.         }
  450.         if (!$seoRepository->setAlias($alias)) {
  451.             $result = array(
  452.                 'title' => 'Ошибка!',
  453.                 'message' => 'Алиас ' . $requestAlias . ' уже существует!',
  454.                 'type' => 'modal-danger'
  455.             );
  456.             return new Response(json_encode($result));
  457.         }
  458.         $parentCategoryIDList = $request->request->get('categories', []);
  459.         if (is_array($parentCategoryIDList)) {
  460.             foreach ($parentCategoryIDList as $parentCategoryID) {
  461.                 $parentCategory = $categoryRepository->find($parentCategoryID);
  462.                 if ($parentCategory->addSubCategory($category)) {
  463.                     $entityManager->flush($parentCategory);
  464.                     $this->getCategoryRepository()->scheduleCategoryReload($parentCategory->getID());
  465.                 }
  466.             }
  467.         }
  468.         $category->setHotFeedName($request->request->get('edit-category-hot-feed-name'));
  469.         $entityManager->flush($category);
  470.         $entityManager->detach($category);
  471.         $seoRepository->setAlias($seoRepository->getCategoryCommentsSeo($category));
  472.         $data['categories'] = [];
  473.         if ($category->getParentCategories()->count() > 0) {
  474.             $data['categories'] = $categoryRepository->getCategoryTree($requestDomainObjectID, $parentCategory->getID());
  475.         } else {
  476.             $data['categories'] = $categoryRepository->getCategoryTree($requestDomainObjectID, 0, $cityID);
  477.         }
  479.         $newCategoryList = $this->get('twig')->render('Slivki/admin/categories/refresh_categories.html.twig', $data);
  480.         $result = array(
  481.             'title' => 'Успех!',
  482.             'message' => 'Раздел успешно добавлен!',
  483.             'type' => 'modal-success',
  484.             'newCategoryList' => $newCategoryList,
  485.             'newLastModified' => $category->getLastModified()->format('Y-m-d H:i:s')
  486.         );
  488.         if (!$category->getParentCategories()->count() == 0 && $category->isActive() && !$category->isPast() && $category->getDomainObjectID() == Category::OFFER_CATEGORY_ID) {
  489.             $this->getDoctrine()->getManager('admin')->getRepository(MainMenu::class)->addMenuItem($category->getID(), MainMenu::TYPE_OFFER_CATEGORY);
  490.         }
  491.         if ($category->isActive()) {
  492.             foreach ($parentCategoryIDList as $parentCategoryID) {
  493.                 if ($parentCategoryID == Category::FLIER_SALE_CATEGORY_ID) {
  494.                     $entityManager->getRepository(MainMenu::class)->addMenuItem($category->getID(), MainMenu::TYPE_SALE_CATEGORY, MainMenu::MENU_ID_FLIER);
  495.                     break;
  496.                 }
  497.             }
  498.         }
  499.         $mediaTypeRepository = $entityManager->getRepository(MediaType::class);
  500.         $landingImage = $request->request->get('editCategoryLandingImage');
  501.         if ($landingImage) {
  502.             $this->saveMedia($imageService, $category->getID(),MediaType::TYPE_CATEGORY_LANDING_IMAGE_ID, MediaType::TYPE_CATEGORY_LANDING_IMAGE_PATH, $landingImage);
  503.         }
  504.         if ($request->request->get('edit-category-hot-feed') == 'on') {
  505.             $hotFeed = new HotFeed();
  506.             $hotFeed->setCreatedOn(new \DateTime());
  507.             $hotFeed->setEntityTypeID(Category::CATEGORY_ID);
  508.             $hotFeed->setEntityID($category->getID());
  509.             $hotFeed->setCityID($cityID);
  510.             $entityManager->persist($hotFeed);
  511.             $entityManager->flush($hotFeed);
  512.         }
  513.         $hotFeedImage = $request->request->get('editCategoryHotFeedImage');
  514.         if ($hotFeedImage) {
  515.             $this->saveMedia($imageService, $category->getID(),MediaType::TYPE_CATEGORY_HOT_FEED_IMAGE_ID, MediaType::TYPE_CATEGORY_HOT_FEED_IMAGE_PATH, $hotFeedImage);
  516.         }
  518.         $mapPinIcon = $request->request->get('editCategoryMapPinIcon');
  519.         if ($mapPinIcon) {
  520.             $category = $categoryRepository->findOneBy(['ID' => $category->getID()]);
  521.             $mapPinIconMedia = new Media\CategoryMapPinIconMedia();
  522.             $mapPinIconMedia->setPath(MediaType::TYPE_CATEGORY_LANDING_IMAGE_PATH);
  523.             $mapPinIconMedia->setCategory($category);
  524.             $mapPinIconMedia->setName($mapPinIcon);
  525.             $category->setMapPinIconMedia($mapPinIconMedia);
  526.             $entityManager->persist($mapPinIconMedia);
  527.             $entityManager->flush($mapPinIconMedia);
  528.         }
  529.         return new Response(json_encode($result));
  530.     }
  532.     /**
  533.      * @Route("/admin/category/ajax_edit_category")
  534.      */
  535.     public function ajaxEditCategoryAction(
  536.         Request $request,
  537.         ImageService $imageService,
  538.         CategoryChildRelationRepositoryInterface $categoryChildRelationRepository,
  539.         CategoryDbalInterface $categoryDbal
  540.     ) {
  541.         if (!$request->isXmlHttpRequest()) {
  542.             return $this->redirect("/admin");
  543.         }
  545.         if($request->request->get('edit-category-name') == '') {
  546.             $result = array(
  547.                 'title' => 'Ошибка!',
  548.                 'message' => 'Введите название раздела!',
  549.                 'type' => 'modal-danger'
  550.             );
  551.             return new Response(json_encode($result));
  552.         }
  554.         $entityManager = $this->getDoctrine()->getManager("admin");
  555.         $categoryRepository =  $entityManager->getRepository(Category::class);
  556.         $mainMenuRepository = $entityManager->getRepository(MainMenu::class);
  557.         $requestCategoryID = (int)$request->request->get('edit-category-id');
  558.         /** @var Category $category */
  559.         $category = $categoryRepository->find($requestCategoryID);
  561.         if(!$category) {
  562.             $result = array(
  563.                 'title' => 'Ошибка!',
  564.                 'message' => 'Категории с ID = ' . $requestCategoryID . ' не существует!',
  565.                 'type' => 'modal-danger'
  566.             );
  567.             return new Response(json_encode($result));
  568.         }
  570.         if (!$request->request->get('forceSave', false) && $category->getLastModified() > new \DateTime($request->request->get('edit-category-last-modified'))) {
  571.             return new Response(json_encode(['error' => 'categoryChanged']));
  572.         }
  574.         $parentCategoryIDList = $request->request->get('categories', []);
  575.         /** @var Category $parentCategory */
  576.         foreach ($category->getParentCategories() as $parentCategory) {
  577.             if (!in_array($parentCategory->getID(), $parentCategoryIDList)) {
  578.                 $parentCategory->getSubCategories()->removeElement($category);
  579.                 $parentCategory->setMobileApiHash(md5(time()));
  580.                 $entityManager->flush($parentCategory);
  581.                 $this->getCategoryRepository()->scheduleCategoryReload($parentCategory->getID());
  582.                 if ($parentCategory->getID() == Category::FLIER_SALE_CATEGORY_ID && $category->isActive()) {//TODO: check $parentCategoryIDList
  583.                     $entityManager->getRepository(MainMenu::class)->deleteMenuItem($category->getID(), MainMenu::TYPE_SALE_CATEGORY, MainMenu::MENU_ID_FLIER);
  584.                 }
  585.             }
  586.         }
  588.         if ($parentCategoryIDList) {
  589.             foreach ($parentCategoryIDList as $parentCategoryID) {
  590.                 $parentCategory = $categoryRepository->find($parentCategoryID);
  591.                 if ($parentCategory->addSubCategory($category)) {
  592.                     $entityManager->flush($parentCategory);
  593.                     $this->getCategoryRepository()->scheduleCategoryReload($parentCategory->getID());
  594.                 }
  595.             }
  596.         }
  598.         $reloadMenuCache = false;
  599.         if ($category->getName() != $request->request->get('edit-category-name')) {
  600.             foreach ($category->getParentCategories() as $parentCategory) {
  601.                 $parentCategory->setMobileApiHash(md5(time()));
  602.                 $entityManager->flush($parentCategory);
  603.                 $this->getCategoryRepository()->scheduleCategoryReload($parentCategory->getID());
  604.             }
  605.             if ($category->getDomainObjectID() != Category::OFFER_CATEGORY_ID) {
  606.                 $reloadMenuCache = true;
  607.             }
  608.         }
  610.         $category->setName(trim($request->request->get('edit-category-name')));
  611.         $h1 = trim($request->request->get('editCategoryH1', ''));
  612.         $category->setH1($h1 == '' ? null : $h1);
  613.         $category->setLastModified(new \DateTime());
  614.         $category->setSortOrder(
  615.             $request->request->getInt('edit-category-order') ?: self::DEFAULT_CATEGORY_SORT_ORDER
  616.         );
  617.         $category->setTelegramBotName(trim($request->request->get('editCategoryTelegramBotName')));
  618.         $category->setTelegramBotShow($request->request->getBoolean('editCategoryTelegramBotShow'));
  619.         $category->setPosition($request->request->getInt('editСategoryPosition'));
  620.         $category->setCode($request->request->get('edit-category-code'));
  621.         $category->setTopCount((int)$request->request->get('edit-category-tops'));
  622.         $category->setInMenuBottom($request->request->has('inMenuBottom'));
  623.         $category->setUtmCampaign($request->request->get('editCategoryUtmCampaign'));
  624.         $category->setSplitOffersWithSameCategories($request->request->getInt('splitOffersWithSameCategories'));
  625.         $category->setUnpopular($request->request->has('unpopular'));
  626.         $category->setFeaturedInMenu($request->request->getBoolean('categoryFeaturedInMenu'));
  627.         $category->setShowItemsCatalog($request->request->getBoolean('showItemsCatalog'));
  628.         $category->setHideWorkExamples($request->request->getBoolean('hideWorkExamples'));
  629.         $category->setIsBonusCode($request->request->getBoolean('isBonusCode'));
  631.         $categoryDbal->updateChildBonusCodes($category->getID(), $category->isBonusCode());
  633.         $category->setMapPinColor($request->request->get('editCategoryMapPinColor'));
  634.         $categoryType = $entityManager->find(CategoryType::class, (int)$request->request->get('edit-category-group'));
  635.         if ($categoryType) {
  636.             $category->setCategoryType($categoryType);
  637.         }
  639.         $categoryParentRelations = $categoryChildRelationRepository->findByChildId($requestCategoryID);
  640.         $endOfBlockParentCategoryIds = (array) $request->request->get('endOfBlock', []);
  641.         foreach ($categoryParentRelations as $categoryParentRelation) {
  642.             if (!$categoryParentRelation->isEndOfBlock() && in_array($categoryParentRelation->getParentId(), $endOfBlockParentCategoryIds)) {
  643.                 $categoryParentRelation->setEndOfBlock(true);
  644.                 $categoryChildRelationRepository->save($categoryParentRelation);
  645.             }
  647.             if ($categoryParentRelation->isEndOfBlock() && !in_array($categoryParentRelation->getParentId(), $endOfBlockParentCategoryIds)) {
  648.                 $categoryParentRelation->setEndOfBlock(false);
  649.                 $categoryChildRelationRepository->save($categoryParentRelation);
  650.             }
  651.         }
  653.         $editCategoryMobileMenuIcon = $request->request->get('editCategoryMobileMenuIcon');
  654.         if ($editCategoryMobileMenuIcon) {
  655.             $mobileMenuIconMedia = $category->getMobileMenuIconMedia();
  656.             if (!$mobileMenuIconMedia) {
  657.                 $mobileMenuIconMedia = new Media\CategoryMobileMenuIconMedia();
  658.                 $mobileMenuIconMedia->setPath(MediaType::TYPE_CATEGORY_LANDING_IMAGE_PATH);
  659.                 $mobileMenuIconMedia->setCategory($category);
  660.                 $entityManager->persist($mobileMenuIconMedia);
  661.             }
  662.             $mobileMenuIconMedia->setName($editCategoryMobileMenuIcon);
  663.             $category->setMobileMenuIconMedia($mobileMenuIconMedia);
  664.         }
  666.         $editCategoryAppIcon = $request->request->get('editCategoryAppIcon');
  667.         if ($editCategoryAppIcon) {
  668.             $appIconMedia = $category->getAppIconMedia();
  669.             if (!$appIconMedia) {
  670.                 $appIconMedia = new Media\CategoryAppIconMedia();
  671.                 $appIconMedia->setPath(MediaType::TYPE_CATEGORY_LANDING_IMAGE_PATH);
  672.                 $appIconMedia->setCategory($category);
  673.                 $entityManager->persist($appIconMedia);
  674.             }
  675.             $appIconMedia->setName($editCategoryAppIcon);
  676.             $category->setAppIconMedia($appIconMedia);
  677.             $entityManager->flush($appIconMedia);
  678.         }
  680.         $editCategoryMapPinIcon = $request->request->get('editCategoryMapPinIcon');
  681.         if ($editCategoryMapPinIcon) {
  682.             $mapPinIconMedia = $category->getMapPinIconMedia();
  683.             if (!$mapPinIconMedia) {
  684.                 $mapPinIconMedia = new Media\CategoryMapPinIconMedia();
  685.                 $mapPinIconMedia->setPath(MediaType::TYPE_CATEGORY_LANDING_IMAGE_PATH);
  686.                 $mapPinIconMedia->setCategory($category);
  687.                 $entityManager->persist($mapPinIconMedia);
  688.             }
  689.             $mapPinIconMedia->setName($editCategoryMapPinIcon);
  690.             $category->setMapPinIconMedia($mapPinIconMedia);
  691.             $entityManager->flush($mapPinIconMedia);
  692.         }
  694.         if ($this->isGranted('ROLE_CATEGORY_MANAGER')) {
  695.             $active = $request->request->get('edit-category-active');
  696.             if ($active != $category->isActive()) {
  697.                 $category->setActive($active);
  698.                 if ($active) {
  699.                     $this->logOperatorAction($request, $requestCategoryID, "activation category " . Category::OFFER_CATEGORY_ID, OperatorActionLog::ACTIVATION_CATEGORY);
  700.                 } else {
  701.                     $this->logOperatorAction($request, $requestCategoryID, "deactivation category " . Category::OFFER_CATEGORY_ID, OperatorActionLog::ACTIVATION_CATEGORY);
  702.                     foreach ($category->getSubCategories() as $subCategory) {
  703.                         $subCategory->setActive(false);
  704.                         $entityManager->flush($subCategory);
  705.                         $categoryRepository->scheduleCategoryReload($subCategory->getID());
  706.                     }
  707.                 }
  708.             }
  709.         }
  711.         if ($parentCategoryIDList) {
  712.             foreach ($parentCategoryIDList as $parentCategoryID) {
  713.                 if ($parentCategoryID == Category::FLIER_SALE_CATEGORY_ID) {
  714.                     if ($category->isActive()) {
  715.                         $entityManager->getRepository(MainMenu::class)->addMenuItem($category->getID(), MainMenu::TYPE_SALE_CATEGORY, MainMenu::MENU_ID_FLIER, City::DEFAULT_CITY_ID);
  716.                     } else {
  717.                         $entityManager->getRepository(MainMenu::class)->deleteMenuItem($category->getID(), MainMenu::TYPE_SALE_CATEGORY, MainMenu::MENU_ID_FLIER);
  718.                     }
  719.                     break;
  720.                 }
  721.             }
  722.         }
  724.         $category->setDescription($request->request->get('edit-category-description'));
  726.         $requestCategoryBannerList = $request->request->get('admin-category-banner-id', []);
  727.         foreach ($requestCategoryBannerList as $index => $bannerID) {
  728.             $banner = $entityManager->getRepository(Banner::class)->find($bannerID);
  729.             if($banner) {
  730.                 if ($request->request->get('admin-category-banner-deleted')[$index] == "true") {
  731.                     $category->deleteBanner($banner);
  732.                 } else {
  733.                     $category->addBanner($banner);
  734.                 }
  735.                 $entityManager->flush($banner);
  736.                 $categoryRepository->scheduleCategoryBannerReload($requestCategoryID);
  737.             }
  738.         }
  740.         $requestTeaserBannerList = $request->request->get('admin-teaser-banner-id', []);
  741.         foreach ($requestTeaserBannerList as $index => $bannerID) {
  742.             $banner = $entityManager->getRepository(Banner::class)->find($bannerID);
  743.             if($banner) {
  744.                 if ($request->request->get('admin-teaser-banner-deleted')[$index] == "true") {
  745.                     $category->deleteBanner($banner);
  746.                 } else {
  747.                     $category->addBanner($banner);
  748.                 }
  749.                 $entityManager->flush($banner);
  750.                 $categoryRepository->scheduleCategoryBannerReload($requestCategoryID);
  751.             }
  752.         }
  753.         $requestVerticalTeaserBannerList = $request->request->get('admin-vertical-teaser-banner-id', []);
  754.         foreach ($requestVerticalTeaserBannerList as $index => $bannerID) {
  755.             $banner = $entityManager->getRepository(Banner::class)->find($bannerID);
  756.             if($banner) {
  757.                 if ($request->request->get('admin-vertical-teaser-banner-deleted')[$index] == "true") {
  758.                     $category->deleteBanner($banner);
  759.                 } else {
  760.                     $category->addBanner($banner);
  761.                 }
  762.                 $entityManager->flush($banner);
  763.                 $categoryRepository->scheduleCategoryBannerReload($requestCategoryID);
  764.             }
  765.         }
  766.         $landingImage = $request->request->get('editCategoryLandingImage');
  767.         if ($landingImage) {
  768.             $this->saveMedia($imageService, $requestCategoryID,MediaType::TYPE_CATEGORY_LANDING_IMAGE_ID, MediaType::TYPE_CATEGORY_LANDING_IMAGE_PATH, $landingImage);
  769.         }
  770.         $hotFeed = $entityManager->getRepository(HotFeed::class)->findBy(['entityTypeID' => Category::CATEGORY_ID, 'entityID' => $requestCategoryID]);
  771.         $showInHotFeed = $request->request->get('edit-category-hot-feed') == 'on';
  772.         if ($showInHotFeed && !$hotFeed) {
  773.             $hotFeed = new HotFeed();
  774.             $hotFeed->setCreatedOn(new \DateTime());
  775.             $hotFeed->setEntityTypeID(Category::CATEGORY_ID);
  776.             $hotFeed->setEntityID($category->getID());
  777.             $categoryCityID = City::DEFAULT_CITY_ID;
  778.             if ($category->getCity()) {
  779.                 $categoryCityID = $category->getCity()->getID();
  780.             }
  781.             $hotFeed->setCityID($categoryCityID);
  782.             $entityManager->persist($hotFeed);
  783.             $entityManager->flush($hotFeed);
  784.         } else if (!$showInHotFeed && $hotFeed) {
  785.             $entityManager->remove($hotFeed[0]);
  786.             $entityManager->flush($hotFeed[0]);
  787.         }
  788.         $hotFeedImage = $request->request->get('editCategoryHotFeedImage');
  789.         if ($hotFeedImage) {
  790.             $this->saveMedia($imageService, $requestCategoryID,MediaType::TYPE_CATEGORY_HOT_FEED_IMAGE_ID, MediaType::TYPE_CATEGORY_HOT_FEED_IMAGE_PATH, $hotFeedImage);
  791.         }
  792.         $category->setHotFeedName($request->request->get('edit-category-hot-feed-name'));
  793.         $entityManager->flush($category);
  794.         $mainMenuType = MainMenu::TYPE_OFFER_CATEGORY;
  795.         $resourceURL = 'Slivki:Default:category';
  797.         switch ($request->request->get('edit-category-domain-object-id')) {
  798.             case Category::OFFER_CATEGORY_ID:
  799.                 $resourceURL = SeoRepository::RESOURCE_URL_OFFER_CATEGORY;
  800.                 $mainMenuType = MainMenu::TYPE_OFFER_CATEGORY;
  801.                 break;
  802.             case Category::SALE_CATEGORY_ID:
  803.                 $resourceURL = SeoRepository::RESOURCE_URL_SALE_CATEGORY;
  804.                 $mainMenuType = MainMenu::TYPE_SALE_CATEGORY;
  805.                 break;
  806.         }
  808.         $hotFeedIcon = $request->request->get('editCategoryHotFeedIcon');
  809.         if ($hotFeedIcon) {
  810.             $this->saveMedia($imageService, $requestCategoryID, MediaType::TYPE_HOT_FEED_CATEGORY_ICON_IMAGE_ID, MediaType::TYPE_HOT_FEED_ICON_IMAGE_PATH, $hotFeedIcon);
  811.         }
  812.         $seoRepository = $entityManager->getRepository(Seo::class);
  813.         $requestAlias = $request->request->get('edit-category-alias');
  814.         if (trim($requestAlias) == '') {
  815.             $result = array(
  816.                 'title' => 'Ошибка!',
  817.                 'message' => 'Введите алиас',
  818.                 'type' => 'modal-danger'
  819.             );
  820.             return new Response(json_encode($result));
  821.         }
  822.         if ($requestAlias[0] != '/') {
  823.             $requestAlias = '/' . $requestAlias;
  824.         }
  825.         $metaTitle = $request->request->get('edit-category-meta-title');
  826.         $metaDescription = $request->request->get('edit-category-meta-description');
  827.         $metaKeywords = $request->request->get('edit-category-meta-keywords');
  828.         $alias = new Seo();
  829.         $alias->setMainAlias($requestAlias);
  830.         $alias->setEntityID($category->getID());
  831.         $alias->setActive(true);
  832.         $alias->setMetaTitle($metaTitle);
  833.         $alias->setMetaDescription($metaDescription);
  834.         $alias->setMetaKeywords($metaKeywords);
  835.         $alias->setResourceURL($resourceURL);
  836.         $alias->setDomain($category->getCity()->getDomain());
  837.         if(!$seoRepository->setAlias($alias)) {
  838.             $result = array(
  839.                 'title' => 'Ошибка!',
  840.                 'message' => 'Алиас ' . $requestAlias . ' уже существует!',
  841.                 'type' => 'modal-danger'
  842.             );
  843.             return new Response(json_encode($result));
  844.         }
  845.         $commentSeo = $seoRepository->getCategoryCommentsSeo($category);
  846.         if ($commentSeo) {
  847.             $commentSeo->setMainAlias($requestAlias);
  848.             $commentSeo->setMetaTitle($metaTitle);
  849.             $commentSeo->setMetaDescription($metaDescription);
  850.             $commentSeo->setMetaKeywords($metaKeywords);
  851.             $seoRepository->setAlias($commentSeo);
  852.         }
  854.         $cityID = null;
  855.         if ($category->getDomainObjectID() == Category::OFFER_CATEGORY_ID) {
  856.             $cityID = $category->getCity()->getID();
  857.         }
  858.         $menuID = $category->getDomainObjectID() == Category::OFFER_CATEGORY_ID ? MainMenu::MENU_ID_MAIN : MainMenu::MENU_ID_SALE;
  859.         if($request->request->get('edit-category-show-in-main-menu') == 'on') {
  860.             $entityManager->getRepository(MainMenu::class)->addMenuItem($category->getID(), $mainMenuType, $menuID, $cityID);
  861.         } else {
  862.             $entityManager->getRepository(MainMenu::class)->deleteMenuItem($category->getID(), $mainMenuType, $menuID);
  863.         }
  865.         $result = array(
  866.             'title' => 'Успех!',
  867.             'message' => 'Раздел успешно сохранен!',
  868.             'type' => 'modal-success',
  869.             'newLastModified' => $category->getLastModified()->format('Y-m-d H:i:s')
  870.         );
  872.         if ($reloadMenuCache) {
  873.             $mainMenuRepository->reloadCache($menuID, $cityID);
  874.         }
  876.         $categoryRepository->scheduleCategoryReload($requestCategoryID);
  877.         return new Response(json_encode($result));
  878.     }
  880.     /**
  881.      * @route("/admin/category/banner/save")
  882.      */
  883.     public function saveCategoryBanner(Request $request) {
  884.         if (!$request->isXmlHttpRequest()) {
  885.             return $this->redirect("/admin");
  886.         }
  888.         $result['message'] = $this->validateCategoryBannerForm($request);
  889.         if($result['message'] !== true) {
  890.             return new Response(json_encode($result));
  891.         }
  892.         $entityManager = $this->getDoctrine()->getManager("admin");
  893.         $bannerRepository = $entityManager->getRepository(Banner::class);
  895.         $requestBannerID = $request->request->get("category-banner-id");
  896.         $banner = new Banner();
  897.         if(!$requestBannerID) {
  898.             $banner->setTypeID(Banner::TYPE_CATEGORY_BANNER);
  899.             $entityManager->persist($banner);
  900.         } else {
  901.             $banner = $bannerRepository->find($requestBannerID);
  902.             if(!$banner) {
  903.                 $result['message'] = array(
  904.                     'title' => 'Ошибка!',
  905.                     'message' => 'Банер с id = ' . $requestBannerID . ' не существует!',
  906.                     'type' => 'modal-danger'
  907.                 );
  908.                 return new Response(json_encode($result));
  909.             }
  910.         }
  911.         $banner->setTitle($request->request->get("edit-category-banner-name"));
  912.         $banner->setActive($request->request->get("edit-category-banner-active", false) !== false);
  913.         $banner->setJavaScript($request->request->get("edit-category-banner-javascript", false) !== false);
  914.         $banner->setCode($request->request->get("edit-category-banner-code"));
  915.         $banner->setURL($request->request->get("edit-category-banner-link", ""));
  916.         $requestBannerFilePath = $request->request->get("edit-category-banner-banner-file-path", '');
  917.         if($requestBannerFilePath != '') {
  918.             $banner->setFilePath($requestBannerFilePath);
  919.         }
  920.         $requestBannerSubstitutePath = $request->request->get("edit-category-banner-substitute-path", '');
  921.         if($requestBannerSubstitutePath != '') {
  922.             $banner->setSubstitutePath($requestBannerSubstitutePath);
  923.         }
  925.         $entityManager->flush();
  927.         $bannerList = [$banner];
  928.         $result['bannerID'] = $banner->getID();
  929.         $result['bannerLine'] = $this->get('twig')->render('Slivki/admin/banners/list.html.twig', ['bannerList' => $bannerList]);
  931.         return new Response(json_encode($result));
  932.     }
  934.     private function validateCategoryBannerForm(Request $request) {
  935.         $errorMessage = '';
  937.         if($request->request->get('edit-category-banner-name') == '') {
  938.             $errorMessage .= 'Введите название!<br>';
  939.         }
  941.         if($errorMessage != '') {
  942.             $result = array(
  943.                 'title' => 'Ошибка!',
  944.                 'message' => $errorMessage,
  945.                 'type' => 'modal-danger'
  946.             );
  947.             return $result;
  948.         }
  950.         return true;
  951.     }
  953.     /**
  954.      * @route("/admin/category/banner/list")
  955.      */
  956.     public function categoryBannerList() {
  957.         $entityManager = $this->getDoctrine()->getManager();
  958.         $bannerRepository = $entityManager->getRepository(Banner::class);
  959.         $bannerList = $bannerRepository->findByTypeID(Banner::TYPE_CATEGORY_BANNER);
  960.         return $this->render('Slivki/admin/banners/list.html.twig', ['bannerList' => $bannerList]);
  961.     }
  963.     /**
  964.      * @route("/admin/category/teaser_banner/list")
  965.      */
  966.     public function categoryTeaserBannerList() {
  967.         $entityManager = $this->getDoctrine()->getManager();
  968.         $bannerRepository = $entityManager->getRepository(Banner::class);
  969.         $bannerList = $bannerRepository->findByTypeID(Banner::TYPE_TEASER_BANNER);
  970.         return $this->render('Slivki/admin/banners/teaser_banner/list.html.twig', ['bannerList' => $bannerList]);
  971.     }
  973.     /**
  974.      * @route("/admin/category/teaser_banner/save")
  975.      */
  976.     public function saveCategoryTeaserBanner(Request $request, CategoryBoxCacheService $categoryBoxCacheService) {
  977.         if (!$request->isXmlHttpRequest()) {
  978.             return $this->redirect("/admin");
  979.         }
  981.         $result['message'] = $this->validateCategoryTeaserBannerForm($request);
  982.         if($result['message'] !== true) {
  983.             return new Response(json_encode($result));
  984.         }
  985.         $entityManager = $this->getDoctrine()->getManager("admin");
  986.         $bannerRepository = $entityManager->getRepository(Banner::class);
  988.         $requestBannerID = $request->request->get("category-teaser-banner-id");
  989.         $banner = new Banner();
  990.         if(!$requestBannerID) {
  991.             $banner->setTypeID(Banner::TYPE_TEASER_BANNER);
  992.             $entityManager->persist($banner);
  993.         } else {
  994.             $banner = $bannerRepository->find($requestBannerID);
  995.             if(!$banner) {
  996.                 $result['message'] = array(
  997.                     'title' => 'Ошибка!',
  998.                     'message' => 'Банер с id = ' . $requestBannerID . ' не существует!',
  999.                     'type' => 'modal-danger'
  1000.                 );
  1001.                 return new Response(json_encode($result));
  1002.             }
  1003.         }
  1004.         $banner->setTitle($request->request->get("edit-category-teaser-banner-name"));
  1005.         $banner->setActive($request->request->get("edit-category-teaser-banner-active", false) !== false);
  1006.         $banner->setJavaScript($request->request->get("edit-category-teaser-banner-javascript", false) !== false);
  1007.         $banner->setJson($request->request->getBoolean('edit-category-teaser-banner-json'));
  1008.         $banner->setCode($request->request->get("edit-category-teaser-banner-code"));
  1009.         $banner->setURL($request->request->get("edit-category-teaser-banner-link", ""));
  1010.         $banner->setPositionRow((int)$request->request->get("edit-category-teaser-banner-row"));
  1011.         $banner->setPositionColumn((int)$request->request->get("edit-category-teaser-banner-column"));
  1012.         $banner->setUtmCampaign($request->request->get("edit-category-teaser-banner-campaign"));
  1013.         $requestBannerFilePath = $request->request->get("edit-category-teaser-banner-banner-file-path", '');
  1014.         if($requestBannerFilePath != '') {
  1015.             $banner->setFilePath($requestBannerFilePath);
  1016.         }
  1017.         $requestBannerSubstitutePath = $request->request->get("edit-category-teaser-banner-substitute-path", '');
  1018.         if($requestBannerSubstitutePath != '') {
  1019.             $banner->setSubstitutePath($requestBannerSubstitutePath);
  1020.         }
  1022.         $entityManager->flush();
  1024.         $categoryBoxCacheService->setTeaser($banner);
  1026.         $bannerList = [$banner];
  1027.         $result['bannerID'] = $banner->getID();
  1028.         $result['bannerLine'] = $this->get('twig')->render('Slivki/admin/banners/teaser_banner/list.html.twig', ['bannerList' => $bannerList]);
  1030.         foreach($banner->getCategories() as $category) {
  1031.             $entityManager->getRepository(Category::class)->scheduleCategoryReload($category->getID());
  1032.         }
  1034.         return new Response(json_encode($result));
  1035.     }
  1037.     private function validateCategoryTeaserBannerForm(Request $request) {
  1038.         $errorMessage = '';
  1040.         if($request->request->get('edit-category-teaser-banner-name') == '') {
  1041.             $errorMessage .= 'Введите название!<br>';
  1042.         }
  1044.         if($errorMessage != '') {
  1045.             $result = array(
  1046.                 'title' => 'Ошибка!',
  1047.                 'message' => $errorMessage,
  1048.                 'type' => 'modal-danger'
  1049.             );
  1050.             return $result;
  1051.         }
  1053.         return true;
  1054.     }
  1056.     /**
  1057.      * @route("/admin/category/vertical_teaser_banner/list")
  1058.      */
  1059.     public function categoryVerticalTeaserBannerList() {
  1060.         $entityManager = $this->getDoctrine()->getManager();
  1061.         $bannerRepository = $entityManager->getRepository(Banner::class);
  1062.         $bannerList = $bannerRepository->findByTypeID(Banner::TYPE_TEASER_VERTICAL_BANNER);
  1063.         return $this->render('Slivki/admin/banners/vertical_teaser_banner/list.html.twig', ['bannerList' => $bannerList]);
  1064.     }
  1066.     /**
  1067.      * @route("/admin/category/vertical_teaser_banner/save")
  1068.      */
  1069.     public function saveCategoryVerticalTeaserBanner(Request $request) {
  1070.         if (!$request->isXmlHttpRequest()) {
  1071.             return $this->redirect("/admin");
  1072.         }
  1074.         $result['message'] = $this->validateCategoryVerticalTeaserBannerForm($request);
  1075.         if($result['message'] !== true) {
  1076.             return new Response(json_encode($result));
  1077.         }
  1078.         $entityManager = $this->getDoctrine()->getManager("admin");
  1079.         $bannerRepository = $entityManager->getRepository(Banner::class);
  1081.         $requestBannerID = $request->request->get("category-vertical-teaser-banner-id");
  1082.         $banner = new Banner();
  1083.         if(!$requestBannerID) {
  1084.             $banner->setTypeID(Banner::TYPE_TEASER_VERTICAL_BANNER);
  1085.             $entityManager->persist($banner);
  1086.         } else {
  1087.             $banner = $bannerRepository->find($requestBannerID);
  1088.             if(!$banner) {
  1089.                 $result['message'] = array(
  1090.                     'title' => 'Ошибка!',
  1091.                     'message' => 'Банер с id = ' . $requestBannerID . ' не существует!',
  1092.                     'type' => 'modal-danger'
  1093.                 );
  1094.                 return new Response(json_encode($result));
  1095.             }
  1096.         }
  1097.         $banner->setTitle($request->request->get("edit-category-vertical-teaser-banner-name"));
  1098.         $banner->setActive($request->request->get("edit-category-vertical-teaser-banner-active", false) !== false);
  1099.         $banner->setJavaScript($request->request->get("edit-category-vertical-teaser-banner-javascript", false) !== false);
  1100.         $banner->setCode($request->request->get("edit-category-vertical-teaser-banner-code"));
  1101.         $banner->setURL($request->request->get("edit-category-vertical-teaser-banner-link", ""));
  1102.         $banner->setPositionRow((int)$request->request->get("edit-category-vertical-teaser-banner-row"));
  1103.         $banner->setPositionColumn((int)$request->request->get("edit-category-vertical-teaser-banner-column"));
  1104.         $requestBannerFilePath = $request->request->get("edit-category-vertical-teaser-banner-banner-file-path", '');
  1105.         if($requestBannerFilePath != '') {
  1106.             $banner->setFilePath($requestBannerFilePath);
  1107.         }
  1108.         $requestBannerSubstitutePath = $request->request->get("edit-category-vertical-teaser-banner-substitute-path", '');
  1109.         if($requestBannerSubstitutePath != '') {
  1110.             $banner->setSubstitutePath($requestBannerSubstitutePath);
  1111.         }
  1113.         $entityManager->flush();
  1115.         $bannerList = [$banner];
  1116.         $result['bannerID'] = $banner->getID();
  1117.         $result['bannerLine'] = $this->get('twig')->render('Slivki/admin/banners/vertical_teaser_banner/list.html.twig', ['bannerList' => $bannerList]);
  1119.         foreach($banner->getCategories() as $category) {
  1120.             $entityManager->getRepository(Category::class)->scheduleCategoryReload($category->getID());
  1121.         }
  1123.         return new Response(json_encode($result));
  1124.     }
  1126.     /**
  1127.      * @Route("/admin/site_settings")
  1128.      */
  1129.     public function ajaxSiteSettings(){
  1130.         return $this->render('Slivki/admin/site_settings/edit_site_settings.html.twig');
  1131.     }
  1133.     public function sendCommentBonusMessage(Mailer $mailer, ValidatorInterface $validator, Comment $comment) {
  1134.         $user = $comment->getUser();
  1135.         $emailConstraint = new EmailConstraint();
  1136.         $emailConstraint->message = 'Invalid email';
  1137.         if (!$user->getEmail()) {
  1138.             return false;
  1139.         }
  1140.         $to = trim($user->getEmail());
  1141.         if ($to == '' || $validator->validate($to, $emailConstraint) != '') {
  1142.             return false;
  1143.         }
  1145.         $entityManager = $this->getDoctrine()->getManager();
  1146.         $balanceActivity = $entityManager->getRepository(UserBalanceActivity::class)->findByEntityID($comment->getID());
  1147.         if (!$balanceActivity || count($balanceActivity) == 0) {
  1148.             return;
  1149.         }
  1150.         $data['balanceActivity'] = $balanceActivity[0];
  1151.         $data['offer'] = $entityManager->find(Offer::class, $comment->getEntityID());
  1152.         if (!$data['offer']) {
  1153.             return false;
  1154.         }
  1155.         $message = $mailer->createMessage();
  1156.         $message->setSubject("Поздравляем! Вам зачислен Бонус!")
  1157.             ->setFrom("info@slivki.by", 'Slivki.by')
  1158.             ->setTo($to)
  1159.             ->setBody(
  1160.                 $this->renderView(
  1161.                     'Slivki/emails/bonus/comment_bonus.html.twig',
  1162.                     $data
  1163.                 ),
  1164.                 'text/html'
  1165.             );
  1166.         $mailer->send($message);
  1167.     }
  1169.     /**
  1170.      * @Route("/admin/site_settings/edit_confirm")
  1171.      */
  1172.     public function ajaxEditConfirm(Request $request){
  1173.         if (!$request->isXmlHttpRequest()) {
  1174.             return $this->redirect("/admin");
  1175.         }
  1176.         $message = $this->validateSiteSettings($request);
  1177.         if (!$message) {
  1178.             $siteSettings = $this->getSiteSettings();
  1179.             /** @var SiteSettings $siteSettings */
  1180.             $siteSettings = $this->getDoctrine()->getManager('admin')->getRepository(SiteSettings::class)->find($siteSettings->getID());
  1181.             $codeCost = str_replace(',', '.', $request->request->get('edit-code-cost'));
  1182.             if ($codeCost) {
  1183.                 $siteSettings->setCodeCost($codeCost);
  1184.             }
  1185.             $regionsCodeCost = $request->request->get('editRegionsCodeCost', '');
  1186.             $siteSettings->setRegionsCodeCost((float)str_replace(',', '.', $regionsCodeCost));
  1187.             $rateHomePhoneText = $request->request->get('edit-rate-home-phone-text');
  1188.             if ($rateHomePhoneText) {
  1189.                 $siteSettings->setRateHomePhoneText($rateHomePhoneText);
  1190.             }
  1191.             $rateMobilePhoneText = $request->request->get('edit-rate-mobile-phone-text');
  1192.             if ($rateMobilePhoneText) {
  1193.                 $siteSettings->setRateMobilePhoneText($rateMobilePhoneText);
  1194.             }
  1195.             $commentBoughtBonus = str_replace(',', '.', $request->request->get('edit-comment-bought-bonus'));
  1196.             if ($commentBoughtBonus) {
  1197.                 $siteSettings->setCommentBoughtBonus($commentBoughtBonus);
  1198.             }
  1200.             $replishmentBonus = str_replace(',', '.', $request->request->get('edit-replenishment-bonus'));
  1201.             if ($replishmentBonus) {
  1202.                 $siteSettings->setReplenishmentBonus($replishmentBonus);
  1203.             }
  1204.             $replishmentBonus = str_replace(',', '.', $request->request->get('edit-replenishment-bonus1'));
  1205.             if ($replishmentBonus) {
  1206.                 $siteSettings->setReplenishmentBonus1($replishmentBonus);
  1207.             }
  1209.             $replenishmentBonus2 = \str_replace(',', '.', $request->request->get('replenishmentBonus2', 0));
  1210.             $siteSettings->setReplenishmentBonus2((float) $replenishmentBonus2);
  1212.             $replishmentBonus = str_replace(',', '.', $request->request->get('edit-replenishment-bonus3'));
  1213.             if ($replishmentBonus) {
  1214.                 $siteSettings->setReplenishmentBonus3($replishmentBonus);
  1215.             }
  1217.             $replishmentBonus = str_replace(',', '.', $request->request->get('edit-replenishment-bonus4'));
  1218.             if ($replishmentBonus) {
  1219.                 $siteSettings->setReplenishmentBonus4($replishmentBonus);
  1220.             }
  1222.             $defaultBalanceRepl = str_replace(',', '.', $request->request->get('edit-default-balance-repl'));
  1223.             if ($defaultBalanceRepl) {
  1224.                 $siteSettings->setDefaultBalanceReplenishment($defaultBalanceRepl);
  1225.             }
  1226.             $defaultBalanceReplCall = str_replace(',', '.', $request->request->get('edit-default-balance-repl-call'));
  1227.             if (\strlen(\trim($defaultBalanceReplCall)) !== 0) {
  1228.                 $siteSettings->setdefaultBalanceReplenishmentCall($defaultBalanceReplCall);
  1229.             }
  1231.             $promisedPaymentLimit = \str_replace(',', '.', $request->request->get('promisedPaymentLimit', 0));
  1232.             $siteSettings->setPromisedPaymentLimit((float) $promisedPaymentLimit);
  1234.             $monthlyCodeCount = $request->request->get('edit-monthly-code-count');
  1235.             if ($monthlyCodeCount) {
  1236.                 $siteSettings->setMonthlyCodeCount($monthlyCodeCount);
  1237.             }
  1238.             $avatarBonus = str_replace(',', '.', $request->request->get('edit-avatar-bonus'));
  1239.             if ($avatarBonus) {
  1240.                 $siteSettings->setAvatarBonus($avatarBonus);
  1241.             }
  1242.             $monthlyBonus = str_replace(',', '.', $request->request->get('edit-monthly-bonus'));
  1243.             if ($monthlyBonus) {
  1244.                 $siteSettings->setMonthlyBonus($monthlyBonus);
  1245.             }
  1246.             $registerBonus = str_replace(',', '.', $request->request->get('edit-registration-bonus'));
  1247.             if ($registerBonus) {
  1248.                 $siteSettings->setRegistrationBonus($registerBonus);
  1249.             }
  1250.             $commentBonus = str_replace(',', '.', $request->request->get('edit-comment-bonus'));
  1251.             if ($commentBonus) {
  1252.                 $siteSettings->setCommentBonus($commentBonus);
  1253.             }
  1254.             $commentPhotoBonus = str_replace(',', '.', $request->request->get('edit-comment-photo-bonus'));
  1255.             if ($commentPhotoBonus) {
  1256.                 $siteSettings->setCommentPhotoBonus($commentPhotoBonus);
  1257.             }
  1258.             $mediaKitManager = $request->request->get('edit-mediakit-manager');
  1259.             if ($mediaKitManager) {
  1260.                 $siteSettings->setMediaKitManager($mediaKitManager);
  1261.             }
  1262.             $mediaKitPhone = $request->request->get('edit-mediakit-phone');
  1263.             if ($mediaKitPhone) {
  1264.                 $siteSettings->setMediaKitPhone($mediaKitPhone);
  1265.             }
  1266.             $subscriptionFirstPayment = $request->request->get('subscriptionFirstPayment');
  1267.             if (!$subscriptionFirstPayment) {
  1268.                 $subscriptionFirstPayment = 0;
  1269.             } else {
  1270.                 $subscriptionFirstPayment = str_replace(',', '.', $subscriptionFirstPayment);
  1271.             }
  1272.             $siteSettings->setSubscriptionFirstPayment($subscriptionFirstPayment);
  1273.             $subscriptionCodeActivePeriodInDays = $request->request->getInt('subscriptionCodeActivePeriodInDays');
  1274.             $siteSettings->setSubscriptionCodeActivePeriodInDays(0 === $subscriptionCodeActivePeriodInDays ? null : $subscriptionCodeActivePeriodInDays);
  1276.             $subscriptionPrice = $request->request->get('subscriptionPrice');
  1277.             if (!$subscriptionPrice) {
  1278.                 $subscriptionPrice = 0;
  1279.             } else {
  1280.                 $subscriptionPrice = str_replace(',', '.', $subscriptionPrice);
  1281.             }
  1282.             $siteSettings->setSubscriptionPrice($subscriptionPrice);
  1283.             $cashBack = str_replace(',', '.', $request->request->get('cashBack'));
  1284.             $siteSettings->setCashBackBonus($cashBack);
  1285.             $siteSettings->setMainPagePromoText($request->request->get('edit-main-page-text'));
  1286.             $siteSettings->setReferralBonus(str_replace(',', '.', $request->request->get('referralBonus')));
  1287.             $mobAppLoginBonus = str_replace(',', '.', $request->request->get('mobAppLoginBonus', ''));
  1288.             if ($mobAppLoginBonus == '') {
  1289.                 $mobAppLoginBonus = 0;
  1290.             }
  1291.             $siteSettings->setMobAppLoginBonus($mobAppLoginBonus);
  1292.             $siteSettings->setMobileApplicationVersion($request->request->get('mobileApplicationVersion', ''));
  1293.             $siteSettings->setMobileApplicationLockVersion($request->request->get('mobileApplicationLockVersion', ''));
  1295.             $this->getDoctrine()->getManager('admin')->flush($siteSettings);
  1296.             if($this->getSiteSettingsRepository()->setSiteSettingsToCache($siteSettings)) {
  1297.                 $message['message'] = array(
  1298.                     "title" => "Успех!",
  1299.                     "message" => "Настройки успешно сохранены!",
  1300.                     "type" => "modal-success"
  1301.                 );
  1302.             } else {
  1303.                 $message['message'] = array(
  1304.                     "title" => "Ошибка!",
  1305.                     "message" => "Изменения не удалось сохранить!",
  1306.                     "type" => "modal-danger"
  1307.                 );
  1308.             }
  1309.         }
  1310.         return new JsonResponse(json_encode($message));
  1311.     }
  1313.     private function validateSiteSettings(Request $request){
  1314.         return false;
  1315.         $settings = $request->request->all();
  1316.         $message = "";
  1317.         foreach ($settings as $field => $value){
  1318.             if($value && (!is_numeric($value) && ($field != "edit-rate-home-phone-text" && $field != "edit-rate-mobile-phone-text"))){
  1319.                 $message['message'] = array(
  1320.                     "title" => "Ошибка!",
  1321.                     "message" => "Неправильно заполнено одно из полей!",
  1322.                     "type" => "modal-danger"
  1323.                 );
  1324.             };
  1325.         }
  1326.         return $message;
  1327.     }
  1329.     private function validateCategoryVerticalTeaserBannerForm(Request $request) {
  1330.         $errorMessage = '';
  1332.         if($request->request->get('edit-category-vertical-teaser-banner-name') == '') {
  1333.             $errorMessage .= 'Введите название!<br>';
  1334.         }
  1336.         if($errorMessage != '') {
  1337.             $result = array(
  1338.                 'title' => 'Ошибка!',
  1339.                 'message' => $errorMessage,
  1340.                 'type' => 'modal-danger'
  1341.             );
  1342.             return $result;
  1343.         }
  1345.         return true;
  1346.     }
  1348.     /**
  1349.      * @return \Slivki\Repository\SaleRepository
  1350.      */
  1351.     protected function getSaleRepository() {
  1352.         return $this->getDoctrine()->getManager('admin')->getRepository(Sale::class);
  1353.     }
  1355.     /**
  1356.      * @return \Slivki\Repository\OfferRepository
  1357.      */
  1358.     protected function getOfferRepository() {
  1359.         return $this->getDoctrine()->getManager('admin')->getRepository(Offer::class);
  1360.     }
  1362.     protected function logOperatorAction($request, $entityID, $description, $type) {
  1363.         $entityManager = $this->getDoctrine()->getManager('admin');
  1364.         $actionLog = new OperatorActionLog();
  1365.         $actionLog->setEntityID($entityID);
  1366.         $actionLog->setOperatorID($this->getUser()->getID());
  1367.         $actionLog->setType($type);
  1368.         $actionLog->setDescription($description);
  1369.         $actionLog->setIpAddress($request->getClientIp());
  1370.         $actionLog->setBrowser($request->headers->get('user-agent'));
  1371.         $entityManager->persist($actionLog);
  1372.         $entityManager->flush($actionLog);
  1373.     }
  1375.     /**
  1376.      * @Route("/admin/category/category-tree/{domainObjectID}/{cityID}/{parentCategoryID}")
  1377.      */
  1378.     public function categoryTreeAction($domainObjectID, $cityID, $parentCategoryID) {
  1379.         $data['categories'] = $this->getCategoryRepository()->getCategoryTree($domainObjectID, 0, $cityID);
  1380.         $result['html'] = $this->get('twig')->render('Slivki/admin/categories/recursive_category_with_checkboxes_macro.html.twig', $data);
  1381.         $result['parentCategoryURL'] = $this->getSeoRepository()->getCategoryURL($this->getCategoryRepository()->find($parentCategoryID));
  1383.         return new JsonResponse($result);
  1384.     }
  1386.     public function getGeoLocationList($entity) {
  1387.         return $this->get('twig')->render('Slivki/admin/offers/geo_location_item.html.twig', array('geoLocations' => $entity->getGeoLocations()));
  1388.     }
  1390.     protected function saveMedia(
  1391.         ImageService $imageService,
  1392.         $entityID, $mediaType,
  1393.         $mediaPath, $fileName,
  1394.         $sortOrder = null,
  1395.         $multiple = false,
  1396.         bool $isVideo = false
  1397.     ) {
  1398.         $entityManager = $this->getEntityManager();
  1399.         $mediaRepository = $entityManager->getRepository(Media::class);
  1400.         $mediaTypeRepository = $entityManager->getRepository(MediaType::class);
  1401.         $media = $mediaRepository->findOneBy(['entityID' => $entityID, 'mediaType' => $mediaType]);
  1402.         if (!$media || $multiple) {
  1403.             $media = new Media();
  1404.             $media->setEntityID($entityID);
  1405.             $media->setMediaType($mediaTypeRepository->find($mediaType));
  1406.             $entityManager->persist($media);
  1407.         }
  1408.         $media->setPath($mediaPath);
  1409.         $media->setName($fileName);
  1410.         if ($sortOrder) {
  1411.             $media->setSortOrder($sortOrder);
  1412.         }
  1413.         $media->setTypeID($mediaType);
  1414.         $entityManager->flush($media);
  1416.         if ($isVideo) {
  1417.             $media->setYoutube(true);
  1418.         }
  1420.         $mediaSizeList = $media->getSizes();
  1421.         foreach ($mediaSizeList->toArray() as $mediaSize) {
  1422.             $imageService->resizeImage($media, $mediaSize->getWidth(), $mediaSize->getHeight());
  1423.         }
  1424.     }
  1426.     /** @Route("/admin/save-special-mailing/{direction}") */
  1427.     public function saveSpecialMailing(KernelInterface $kernel, $direction) {
  1428.         $filePath = $kernel->getProjectDir() . '/etc/slivki-cache/mailing.html';
  1429.         $entityManager = $this->getDoctrine()->getManager('admin');
  1430.         $specialMailing = $entityManager->find(MailingCampaign::class, 376);
  1431.         if ($direction == 'out') {
  1432.             file_put_contents($filePath, $specialMailing->getMailBody());
  1433.         } else if ($direction == 'in') {
  1434.             $specialMailing->setMailBody(file_get_contents($filePath));
  1435.             $entityManager->flush($specialMailing);
  1436.         }
  1438.         return new Response();
  1439.     }
  1441.     /** @return \Doctrine\Orm\EntityManager */
  1442.     protected function getEntityManager() {
  1443.         return $this->getDoctrine()->getManager('admin');
  1444.     }
  1446.     protected function getUserRepository(): UserRepository
  1447.     {
  1448.         return $this->getDoctrine()->getRepository(User::class, 'admin');
  1449.     }
  1451.     public function setImageRatio(KernelInterface $kernel, $description) {
  1452.         if (trim($description) == '') {
  1453.             return '';
  1454.         }
  1455.         $html = new Crawler();
  1456.         $html->addHtmlContent($description);
  1457.         $nodeList = $html->filter('img');
  1458.         if (!empty($nodeList)) {
  1459.             $nodeList->each(function (Crawler $node) use ($kernel) {
  1460.                 $nodeElem = $node->getNode(0);
  1461.                 $source = parse_url($nodeElem->getAttribute('src'));
  1462.                 if (isset($source['path'])) {
  1463.                     $imagePath = $kernel->getProjectDir() . '/public' . $source['path'];
  1464.                     $imageSize = @getimagesize($imagePath);
  1465.                     $nodeElemWidth = $nodeElem->getAttribute('width');
  1466.                     if ($nodeElemWidth == '') {
  1467.                         $nodeElem->setAttribute('width', $imageSize[0]);
  1468.                     }
  1469.                     if ($imageSize) {
  1470.                         $nodeElem->setAttribute('data-ratio', round(100 * $imageSize[1]/$imageSize[0], 2));
  1471.                     }
  1472.                 }
  1473.             });
  1474.         }
  1475.         $result = str_replace('<body>', '', $html->html());
  1476.         $result = str_replace('</body>', '', $result);
  1477.         return $result;
  1478.     }
  1480.     /** @Route("/admin/upload-image") */
  1481.     public function uploadImageAction(Request $request, KernelInterface $kernel) {
  1482.         if (!$request->isMethod('POST')) {
  1483.             return $this->redirect("/admin");
  1484.         }
  1485.         $initialMediaPath = $kernel->getProjectDir() . '/public' . ImageService::MEDIA_ROOT . ImageService::INITIAL_PATH;
  1486.         $fileInputName = $request->request->get('fileInputName');
  1487.         $filePath = $request->request->get('filePath');
  1488.         $uploadedFile = $request->files->get($fileInputName);
  1489.         $realFilePath = $initialMediaPath . $filePath;
  1490.         $fs = new Filesystem();
  1491.         $fileName = $uploadedFile->getClientOriginalName();
  1493.         while ($fs->exists($realFilePath . $fileName)) {
  1494.             $fileName = time() . '_' . $fileName;
  1495.         }
  1496.         $uploadedFile->move($realFilePath, $fileName);
  1497.         $selection = $request->request->get('selection');
  1498.         if ($selection) {
  1499.             $selection = json_decode($selection);
  1500.             $this->cropImage($realFilePath . $fileName, $selection);
  1501.         }
  1504.         return new Response(json_encode([
  1505.             'imageURL' => ImageService::MEDIA_ROOT . ImageService::INITIAL_PATH . $filePath . $fileName,
  1506.             'imageName' => $fileName
  1507.         ]));
  1508.     }
  1510.     public function cropImage($filePath, $selection) {
  1511.         $x = $selection->x > 0 ? $selection->x : 0;
  1512.         $y = $selection->y > 0 ? $selection->y : 0;
  1513.         $imagine = new Imagine();
  1514.         $image = $imagine->open($filePath);
  1515.         $image->crop(new Point($x, $y), new Box($selection->width, $selection->height));
  1516.         $image->save($filePath);
  1517.     }
  1518. }