src/Controller/SiteController.php line 634

Open in your IDE?
  1. <?php
  3. namespace Slivki\Controller;
  5. use Psr\Container\ContainerInterface;
  6. use Slivki\Entity\AuthToken;
  7. use Slivki\Entity\Banner;
  8. use Slivki\Entity\Category;
  9. use Slivki\Entity\City;
  10. use Slivki\Entity\Comment;
  11. use Slivki\Entity\FoodOfferOptionExtension;
  12. use Slivki\Entity\FoodOrder;
  13. use Slivki\Entity\GeoLocation;
  14. use Slivki\Entity\GiftCertificate;
  15. use Slivki\Entity\GiftCertificateOrder;
  16. use Slivki\Entity\HotFeed;
  17. use Slivki\Entity\Media;
  18. use Slivki\Entity\Media\OfferExtensionMedia;
  19. use Slivki\Entity\Offer;
  20. use Slivki\Entity\OfferOrder;
  21. use Slivki\Entity\OfferOrderDetails;
  22. use Slivki\Entity\Partner;
  23. use Slivki\Entity\PartnerOffer;
  24. use Slivki\Entity\Sale;
  25. use Slivki\Entity\Seo;
  26. use Slivki\Entity\SiteSettings;
  27. use Slivki\Entity\User;
  28. use Slivki\Entity\UserActivity;
  29. use Slivki\Entity\UserBalanceActivityType;
  30. use Slivki\Entity\UserConfirmation;
  31. use Slivki\Entity\UserGroup;
  32. use Slivki\Entity\Visit;
  33. use Slivki\Repository\CategoryRepository;
  34. use Slivki\Repository\OfferRepository;
  35. use Slivki\Repository\SeoRepository;
  36. use Slivki\Services\BannerService;
  37. use Slivki\Services\Comment\CommentCacheService;
  38. use Slivki\Services\ImageService;
  39. use Slivki\Services\Mailer;
  40. use Slivki\Services\Offer\CustomProductOfferSorter;
  41. use Slivki\Services\Offer\OfferCacheService;
  42. use Slivki\Services\QRCodeGenerator\Generators\SosediBarcodeGenerator;
  43. use Slivki\Services\Sale\SaleCacheService;
  44. use Slivki\Util\Iiko\AbstractDelivery;
  45. use Slivki\Util\Logger;
  46. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  47. use Symfony\Bundle\FrameworkBundle\Controller\Controller;
  48. use Symfony\Component\Filesystem\Filesystem;
  49. use Symfony\Component\HttpFoundation\Request;
  50. use Symfony\Component\HttpFoundation\Response;
  51. use Symfony\Component\HttpFoundation\Cookie;
  52. use Symfony\Component\HttpFoundation\Session\Session;
  53. use Symfony\Component\HttpKernel\KernelInterface;
  54. use Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken;
  55. use Symfony\Component\Security\Http\Event\InteractiveLoginEvent;
  56. use Slivki\Util\SoftCache;
  57. use Slivki\Util\CommonUtil;
  58. use Slivki\Repository\CommentRepository;
  59. use Mpdf\Config\ConfigVariables;
  60. use Mpdf\Config\FontVariables;
  61. use Mpdf\Mpdf;
  63. class SiteController extends AbstractController {
  64.     const UTM_SOURCE_COOKIE_NAME = 'utmSource';
  65.     const PARAMETER_MOBILE_DEVICE = "mobileDevice";
  66.     const PARAMETER_META_INFO = "slivkiMetaInfo";
  67.     const USER_TOKEN_COOKIE ='visitedoffers4';
  68.     const SHOW_INFO_DIALOG_PARAMETER = 'showInfoPopup';
  69.     const DEVICE_TYPE_DESKTOP = 0;
  70.     const DEVICE_TYPE_MOBILE = 1;
  71.     const DEVICE_TYPE_MOBILE_APP = 2;
  72.     const DEVICE_TYPE_FOOD_COURT = 3;
  73.     const LAST_OFFER_RATE_ACTIVITY_PARAMETER_NAME = 'lastOfferRateActivity';
  74.     const TARANTOOL_CATEGORY_BOX = true;
  76.     public function __construct(KernelInterface $kernel) {
  77.         $this->setUtmSourceCookie();
  78.         $this->kernel = $kernel;
  79.     }
  81.     public function setContainer(ContainerInterface $container): ?ContainerInterface {
  82.         $previous = parent::setContainer($container);
  83.         if ($container) {
  84.             $user = $this->getUser();
  85.             if ($user && !$user->isAccountNonLocked()) {
  86.                 $user->setToken('');
  87.                 $this->getDoctrine()->getManager()->flush($user);
  88.                 $this->get('security.token_storage')->setToken(null);
  89.                 $this->get('request_stack')->getCurrentRequest()->getSession()->invalidate();
  90.             }
  91.         }
  92.         return $previous;
  93.     }
  95.     private function setUtmSourceCookie() {
  96.         $request = Request::createFromGlobals();
  97.         $utmSource = $request->query->get('utm_source');
  98.         $referer = $request->headers->get('referer');
  99.         $response = new Response();
  100.         if ($utmSource && $referer && parse_url($referer)['host'] != $request->getHost()) {
  101.             $cookie = [
  102.                 'utmSource' => $utmSource,
  103.                 'utm_medium' => $request->query->get('utm_medium'),
  104.                 'utm_campaign' => $request->query->get('utm_campaign'),
  105.                 'utm_term' => $request->query->get('utm_term'),
  106.                 'utm_content' => $request->query->get('utm_content'),
  107.                 'ref_code' => $request->query->get('ref_code'),
  108.                 'time' => time(),
  110.             ];
  111.             $expire = $utmSource == 'rtbhouse' ? 60*60*24*30 : 604800;
  112.             $cookie = Cookie::create(self::UTM_SOURCE_COOKIE_NAME, serialize($cookie),  $expire + time());
  113.             $response->headers->setCookie($cookie);
  114.             $response->sendHeaders();
  115.         }
  116.     }
  118.     protected function getUtmSourceCookie(Request $request) {
  119.         $cookie = $request->cookies->get(self::UTM_SOURCE_COOKIE_NAME);
  120.         if (!$cookie) {
  121.             return false;
  122.         }
  123.         $result = unserialize($cookie);
  124.         if (count($result) < 2) {
  125.             return false;
  126.         }
  127.         $result['period'] = round((time() - $result['time']) / 86400);
  129.         return $result;
  130.     }
  132.     protected function getUtmSourceArray(Request $request) {
  133.         return [
  134.             'utm_source' => $request->query->get('utm_source', ''),
  135.             'utm_medium' => $request->query->get('utm_medium', ''),
  136.             'utm_campaign' => $request->query->get('utm_campaign', ''),
  137.             'utm_term' => $request->query->get('utm_term', ''),
  138.             'utm_content' => $request->query->get('utm_content', '')
  139.         ];
  140.     }
  142.     protected function getUtmDataFromReferer($referer) {
  143.         $query = parse_url($referer, PHP_URL_QUERY);
  144.         if ($query) {
  145.             $utmArray = [];
  146.             $parameters = explode('&', $query);
  147.             foreach ($parameters as $parameter) {
  148.                 if (CommonUtil::isBeginsWith($parameter, 'utm_')) {
  149.                     $utmArray[] = $parameter;
  150.                 }
  151.             }
  152.             return implode('&', $utmArray);
  153.         }
  155.         return '';
  156.     }
  158.     public static function getMobileDevice(Request $request) {
  159.         return CommonUtil::isMobileDevice($request);
  160.     }
  162.     /**
  163.      * @return \Slivki\Repository\PartnerOfferRepository
  164.      */
  165.     protected function getPartnerOfferRepository() {
  166.         return $this->getDoctrine()->getRepository(PartnerOffer::class);
  167.     }
  169.     protected function getGiftSupplierRepository(){
  170.         return $this->getDoctrine()->getRepository(Partner::class);
  171.     }
  173.     /**
  174.      * @return \Slivki\Repository\OfferRepository
  175.      */
  176.     protected function getOfferRepository() {
  177.         return $this->getDoctrine()->getRepository(Offer::class);
  178.     }
  180.     /**
  181.      * @return \Slivki\Repository\CategoryRepository
  182.      */
  183.     protected function getCategoryRepository() {
  184.         return $this->getDoctrine()->getRepository(Category::class);
  185.     }
  187.     /**
  188.      * @return \Slivki\Repository\SaleRepository
  189.      */
  190.     protected function getSaleRepository() {
  191.         return $this->getDoctrine()->getRepository(Sale::class);
  192.     }
  194.     /**
  195.      * @return \Slivki\Repository\MediaRepository
  196.      */
  197.     protected function getMediaRepository() {
  198.         return $this->getDoctrine()->getRepository(Media::class);
  199.     }
  201.     /**
  202.      * @return \Slivki\Repository\OfferOrderRepository
  203.      */
  204.     protected function getOfferOrderRepository() {
  205.         return $this->getDoctrine()->getRepository(OfferOrder::class);
  206.     }
  208.     /**
  209.      * @return \Slivki\Repository\OfferOrderDetails
  210.      */
  211.     protected function getOfferOrderDetailsRepository() {
  212.         return $this->getDoctrine()->getRepository(OfferOrderDetails::class);
  213.     }
  215.     /**
  216.      * @return \Slivki\Repository\SeoRepository
  217.      */
  218.     protected function getSeoRepository() {
  219.         return $this->getDoctrine()->getRepository(Seo::class);
  220.     }
  222.     /**
  223.      * @return \Slivki\Repository\GeoLocationRepository
  224.      */
  225.     protected function getGeoLocationRepository() {
  226.         return $this->getDoctrine()->getRepository(GeoLocation::class);
  227.     }
  229.     /**
  230.      * @return \Slivki\Repository\CommentRepository
  231.      */
  232.     protected function getCommentRepository() {
  233.         return $this->getDoctrine()->getRepository(Comment::class);
  234.     }
  236.     /**
  237.      * @return \Slivki\Repository\BannerRepository
  238.      */
  239.     protected function getBannerRepository() {
  240.         return $this->getDoctrine()->getRepository(Banner::class);
  241.     }
  243.     /**
  244.      * @return \Slivki\Repository\UserBalanceActivityType
  245.      */
  246.     protected function getUserBalanceActivityTypeRepository() {
  247.         return $this->getDoctrine()->getRepository(UserBalanceActivityType::class);
  248.     }
  250.     /**
  251.      * @return \Slivki\Repository\SiteSettingsRepository
  252.      */
  253.     protected  function getSiteSettingsRepository(){
  254.         return $this->getDoctrine()->getRepository(SiteSettings::class);
  255.     }
  256.     
  257.     /**
  258.      * @return \Slivki\Repository\UserRepository
  259.      */
  260.     protected function getUserRepository() {
  261.         return $this->getDoctrine()->getRepository(User::class);
  262.     }
  264.     /**
  265.      * @return \Slivki\Repository\UserActivity
  266.      */
  267.     protected function getUserActivityRepository() {
  268.         return $this->getDoctrine()->getRepository(UserActivity::class);
  269.     }
  271.     /**
  272.      * @return \Slivki\Entity\SiteSettings
  273.      */
  274.     protected function getSiteSettings() {
  275.         return $this->getDoctrine()->getRepository(SiteSettings::class)->getSiteSettingsCached();
  276.     }
  278.     /**
  279.      * @return \Slivki\Repository\Visit
  280.      */
  281.     protected function getVisitRepository() {
  282.         return $this->getDoctrine()->getRepository(Visit::class);
  283.     }
  285.     public function sendCode(Mailer $mailer, OfferOrder $offerOrder): void
  286.     {
  287.         if ($offerOrder instanceof GiftCertificateOrder || $offerOrder instanceof FoodOrder) {
  288.             return;
  289.         }
  291.         $email = trim($offerOrder->getUser()->getEmail());
  293.         if (!$email || $email == '') {
  294.             return;
  295.         }
  296.         if ($offerOrder instanceof GiftCertificateOrder) {
  297.             foreach ($offerOrder->getOfferOrderDetails() as $offerOrderDetails) {
  298.                 if ($offerOrder->getUser()->getEmail()) {
  299.                     $mpdf = $this->getGiftCertificateMpdf($this->kernel, $offerOrderDetails);
  300.                     if (!$mpdf) {
  301.                         continue;
  302.                     }
  303.                     $path = '/tmp/certificate'.$offerOrderDetails->getID().'.pdf';
  304.                     $mpdf->Output($path, 'F');
  305.                     $message = $mailer->createMessage();
  306.                     $message->setSubject('Slivki.by - промокод на акцию')
  307.                         ->setFrom('info@slivki.by', 'Slivki.by')
  308.                         ->setTo($offerOrder->getUser()->getEmail())
  309.                         ->setBody($this->get('twig')->render('Slivki/emails/code.html.twig', ['offerOrder' => $offerOrder]), 'text/html')
  310.                         ->attachFromPath($path);
  311.                     $mailer->send($message);
  312.                 }
  313.             }
  314.         } else {
  315.             if ($offerOrder->getUser()->getEmail()) {
  316.                 $message = $mailer->createMessage();
  317.                 $message->setSubject('Slivki.by - промокод на акцию')
  318.                     ->setFrom('info@slivki.by', 'Slivki.by')
  319.                     ->setTo($offerOrder->getUser()->getEmail())
  320.                     ->setBody($this->get('twig')->render('Slivki/emails/code.html.twig', ['offerOrder' => $offerOrder]), 'text/html');
  321.                 $mailer->send($message);
  322.             }
  323.         }
  324.     }
  326.     private function sendGiftCertificate(KernelInterface $kernel, Mailer $mailer, OfferOrder $order) {
  327.         foreach ($order->getOfferOrderDetails() as $offerOrderDetails) {
  328.             $mpdf = $this->getGiftCertificateMpdf($kernel, $offerOrderDetails);
  329.             if (!$mpdf) {
  330.                 continue;
  331.             }
  332.             $content = $mpdf->Output('', 'S');
  334.             // save preview
  335.             $iMagick = new \Imagick();
  336.             $iMagick->readImageBlob($content);
  337.             $iMagick->setImageFormat('png');
  338.             $iMagick->writeImage($kernel->getProjectDir() . GiftCertificate::PREVIEW_PATH . $offerOrderDetails->getID() . '.png');
  340.             $attachment = new \Swift_Attachment($content, 'certificate.pdf', 'application/pdf');
  341.             $message = $mailer->createMessage();
  342.             $user = $offerOrderDetails->getOfferOrder()->getUser();
  343.             $message->setSubject('Подарочный сертификат Slivki.by')
  344.                 ->setFrom("info@slivki.by", 'Slivki.by')
  345.                 ->setTo($user->getEmail())
  346.                 ->attach($attachment)
  347.                 ->setBody($this->renderView('Slivki/emails/gift_certificate.html.twig', [
  348.                     'name' => $user->getFirstName()]), 'text/html');
  349.             $mailer->send($message);
  350.         }
  351.     }
  353.     /**
  354.      * @return null|\Mpdf\Mpdf
  355.      */
  356.     protected function getGiftCertificateMpdf(KernelInterface $kernel, OfferOrderDetails $offerOrderDetails) {
  357.         $giftCertificate = $offerOrderDetails->getGiftCertificate();
  358.         if (!$giftCertificate) {
  359.             return null;
  360.         }
  361.         $customFontDir = $kernel->getProjectDir() . '/public/fonts/crt-fonts/ttf';
  362.         $defaultConfig = (new ConfigVariables())->getDefaults();
  363.         $defaultFontDir = $defaultConfig['fontDir'];
  364.         $defaultFontConfig = (new FontVariables())->getDefaults();
  365.         $defaultFontData = $defaultFontConfig['fontdata'];
  366.         $mpdf = new Mpdf([
  367.             'fontDir' => array_merge($defaultFontDir, [
  368.                 $customFontDir,
  369.             ]),
  370.             'tempDir' => '/tmp',
  371.             'fontdata' => $defaultFontData + [
  372.                     'sfrounded' => [
  373.                         'R' => 'SFRounded-Ultralight.ttf',
  374.                     ],
  375.                     'sf' => [
  376.                         'R' => 'SFProText-Regular.ttf',
  377.                     ],
  378.                 ],
  379.             'mode' => 'utf-8',
  380.             'format' => 'A4',
  381.             'orientation' => 'P',
  382.             'margin_top' => 10,
  383.             'margin_bottom' => 0,
  384.             'margin_left' => 0,
  385.             'margin_right' => 0,
  386.         ]);
  387.         $mpdf->curlAllowUnsafeSslRequests = true;
  388.         $template = 'Slivki/gift_certificates/crt_pdf.html.twig';
  389.         if (SosediBarcodeGenerator::OFFER_ID === (int) $offerOrderDetails->getOfferOrder()->getOffer()->getID()) {
  390.             $template = 'Slivki/gift_certificates/sosedi_pdf.html.twig';
  391.         }
  392.         $mpdf->WriteHTML($this->renderView($template, [
  393.             'offerOrderDetails' => $offerOrderDetails,
  394.             'giftCertificate' => $giftCertificate,
  395.             'offer' => $giftCertificate->getOffer(),
  396.         ]));
  398.         return $mpdf;
  399.     }
  401.     protected function sendConfirm(Mailer $mailer, $user) {
  402.         $userConfirmation = $this->getDoctrine()->getRepository(UserConfirmation::class)->findOneByUserID($user->getID());
  403.         if(!$userConfirmation){
  404.             return false;
  405.         }
  406.         $confirmURL = "/confirm/" . md5($userConfirmation->getID() . $user->getID());
  407.         $message = $mailer->createMessage();
  408.         $message->setSubject("Регистрация на Slivki.by")
  409.             ->setFrom("info@slivki.by", 'Slivki.by')
  410.             ->setTo($user->getEmail())
  411.             ->setBody(
  412.                 $this->renderView(
  413.                     'Slivki/emails/confirm_user.html.twig',
  414.                     array('link' => $confirmURL)
  415.                 ),
  416.                 'text/html'
  417.             );
  418.         $mailer->send($message);
  419.         
  420.         return true;
  421.     }
  423.     /**
  424.      * @deprecated Use OfferOrderRepository::getNewOrderNumber
  425.      */
  426.     protected function getNewOrderNumber() {
  427.         return $this->getDoctrine()->getRepository(OfferOrder::class)->getNewOrderNumber();
  428.     }
  430.     protected function getLogger() {
  431.         return Logger::instance('Controller');
  432.     }
  434.     protected function log($text) {
  435.         $this->getLogger()->info($this->container->get('request_stack')->getMainRequest()->getRequestUri() . ": $text");
  436.     }
  438.     protected function getComments(Request $request, BannerService $bannerService, $entityID, $typeID, $lastCommentID = 0, $categoryID = 0, $directorID = 0, $cacheName = CommentCacheService::CACHE_NAME) {
  439.         $firstPage = $lastCommentID == 0 && $entityID != 0;
  440.         $softCache = new SoftCache($cacheName);
  441.         $commentsBlock = '';
  442.         $cacheKey = $typeID . '-' . $entityID;
  443.         $mobileDevice = false;
  444.         $cityID = $request->getSession()->get(City::CITY_ID_SESSION_KEY, City::DEFAULT_CITY_ID);
  445.         if ($cacheName == CommentRepository::MOBILE_CACHE_NAME) {
  446.             $mobileDevice = true;
  447.         }
  448.         $offerId = 1 === $typeID ? $entityID : null;
  449.         if ($firstPage) {
  450.             $commentsBlock = $softCache->getDataForLockedKey($cacheKey, 0);
  451.             if ($commentsBlock == SoftCache::LOCKED_KEY) {
  452.                 return '';
  453.             }
  454.             if ($commentsBlock) {
  455.                 return $directorID != 5596 ? $this->insertBannersToComments($bannerService, $commentsBlock, $mobileDevice, $cityID, $offerId) : $commentsBlock;
  456.             }
  457.             $softCache->set($cacheKey, SoftCache::LOCKED_KEY, 10);
  458.         }
  459.         if ($entityID == 0 ) {
  460.             $commentRepository = $this->getCommentRepository();
  461.             if ($categoryID == 0) {
  462.                 $data['isLiveComments'] = 1;
  463.                 if ($directorID > 0) {
  464.                     $data['comments'] = $commentRepository->getCommentsByDirectorID($directorID,CommentRepository::COMMENTS_PER_PAGE, $lastCommentID);
  465.                 } else {
  466.                     $data['comments'] = $commentRepository->getLiveComments(CommentRepository::COMMENTS_PER_PAGE, $lastCommentID);
  467.                 }
  468.                 $data['commentsAmount'] = CommentRepository::COMMENTS_PER_PAGE;
  469.                 $data['hasMore'] = true;
  470.             } else {
  471.                 $data['isLiveComments'] = 1;
  472.                 $data['hasMore'] = true;
  473.                 $data['commentsAmount'] = CommentRepository::COMMENTS_PER_PAGE;
  474.                 $data['categoryID'] = $categoryID;
  475.                 $data['comments'] = $commentRepository->getCommentsByCategoryID($categoryID, $data['commentsAmount'], $lastCommentID);
  476.             }
  477.         } else {
  478.             $comments = $this->getCommentRepository()->getCommentsByEntityID($entityID, CommentRepository::COMMENTS_PER_PAGE, $lastCommentID);
  479.             if (empty($comments)) {
  480.                 return '';
  481.             }
  483.             $lastCommentID = $comments[count($comments) - 1]->getID();
  484.             $data['comments'] = $comments;
  485.             if ($firstPage && $typeID == Comment::TYPE_OFFER_COMMENT) {
  486.                 $offer = $this->getOfferRepository()->getAnyWay($entityID);
  487.                 if ($offer && !$offer->isHideBannersInComments()) {
  488.                     $data['showBanners'] = true;
  489.                 }
  490.             }
  491.             $data['commentsAmount'] = CommentRepository::COMMENTS_PER_PAGE;
  492.             $dql = 'select comment from Slivki:Comment comment
  493.                 where comment.entityID = :entityID and comment.typeID = :typeID and comment.parentID is null and comment.ID < :lastCommentID and comment.hidden = false and comment.confirmedPhone = true';
  494.             $query = $this->getDoctrine()->getManager()->createQuery($dql)
  495.                 ->setParameter('entityID', $entityID)->setParameter('lastCommentID', $lastCommentID)->setParameter('typeID', $typeID);
  496.             $query->setMaxResults(1);
  497.             if ($typeID == Comment::TYPE_OFFER_COMMENT) {
  498.                 $commentsAmount = $this->getCommentRepository()->getCommentsCountByEntityID($entityID, Comment::TYPE_OFFER_COMMENT);
  499.                 $data['hasMore'] = false;
  500.                 $data['pagination'] = $this->renderView('Slivki/pagination.html.twig', [
  501.                     'paginationID' => 'offerCommentPagination',
  502.                     'current' => 1,
  503.                     'total' => ceil($commentsAmount/CommentRepository::COMMENTS_PER_PAGE),
  504.                     'url' => $this->getDoctrine()->getRepository(Seo::class)->getOfferURL($entityID)->getMainAlias() . '?page='
  505.                 ]);
  506.             } else {
  507.                 $data['hasMore'] = count($query->getResult()) > 0;
  508.             }
  509.         }
  510.         $view = 'Slivki/comments/comments.html.twig';
  511.         if ($mobileDevice) {
  512.             $view = 'Slivki/mobile/comment/list.html.twig';
  513.         }
  514.         $response = $this->get('twig')->render($view, $data);
  515.         if ($firstPage) {
  516.             $softCache->set($cacheKey, $response, 48 * 60 * 60);
  517.         }
  519.         return $directorID != 5596 ? $this->insertBannersToComments($bannerService, $response, $mobileDevice, $cityID, $offerId) : $response;
  520.     }
  522.     // TODO: Refactor and remove to service
  523.     private function insertBannersToComments(BannerService $bannerService, $commentsHTML, $mobileDevice, $cityID = City::DEFAULT_CITY_ID, $offerId = null) {
  524.         $bannerList = [];
  525.         if (!($this->getUser() and $this->getUser()->hasRole(UserGroup::ROLE_ADS_FREE))) {
  526.             $bannerList = $bannerService->getCommentsBanners($mobileDevice, $cityID, $offerId);
  527.             if (count($bannerList) == 0 && $cityID != City::DEFAULT_CITY_ID) {
  528.                 $bannerList = $bannerService->getCommentsBanners($mobileDevice, City::DEFAULT_CITY_ID, $offerId);
  529.             }
  530.         }
  531.         if (count($bannerList) == 0) {
  532.             return $commentsHTML;
  533.         }
  534.         $session = new Session();
  535.         $sessionKey = 'lastBannerIndex';
  536.         foreach ($bannerList as $position => $banners) {
  537.             $bannerHTML = '';
  538.             if (count($banners) == 1) {
  539.                 $bannerHTML = $banners[0];
  540.             } else {
  541.                 $lastBannerIndex = $session->get($sessionKey . $position, 0);
  542.                 $nextBannerIndex = $lastBannerIndex + 1 < count($banners) ? $lastBannerIndex + 1 : 0;
  543.                 $bannerHTML = $banners[$nextBannerIndex];
  544.                 $session->set($sessionKey . $position, $nextBannerIndex);
  545.             }
  547.             $commentsHTML = str_replace('<span id="commentBannerPlaceHolder' . ($position + 1) . '" class="hidden"></span>', $bannerHTML, $commentsHTML);
  548.         }
  550.         return $commentsHTML;
  551.     }
  553.     /**
  554.      * @deprecated use CommentCacheService
  555.      */
  556.     public function resetCommentsCache($entityID, $typeID) {
  557.         (new SoftCache(CommentCacheService::CACHE_NAME))->delete($typeID . '-' . $entityID);
  558.         (new SoftCache(CommentCacheService::MOBILE_CACHE_NAME))->delete($typeID . '-' . $entityID);
  559.     }
  561.     public function getParentCategoryList(Request $request, $defaultCategoryID = null) {
  562.         $data['siteSettings'] = $this->getSiteSettings();
  563.         $parentCategoryID = $request->cookies->get('referrerCategory');
  564.         if (!$parentCategoryID) {
  565.             $parentCategoryID = $defaultCategoryID;
  566.         }
  567.         if (!$parentCategoryID) {
  568.             return false;
  569.         }
  570.         $categoryRepository = $this->getCategoryRepository();
  571.         $category = $categoryRepository->findCached($parentCategoryID);
  572.         if (!$category) {
  573.             return false;
  574.         }
  575.         $parentCategoryList = $this->getCategoryRepository()->getCategoryParentList($category['category']);
  576.         $parentCategoryList[] = $category['category'];
  578.         return $parentCategoryList;
  579.     }
  581.     protected function addVisit($entityID, $entityTypeID, $deviceType, $user, $clientIPAddress, $referrer = '') {
  582.         $visit = new Visit();
  583.         $visit->setEntityID($entityID);
  584.         $visit->setEntityTypeID($entityTypeID);
  585.         if($user) {
  586.             $visit->setUser($user);
  587.         }
  588.         $visit->setDeviceType($deviceType);
  589.         $visit->setReferrer($referrer);
  590.         $visit->setIPAddress($clientIPAddress);
  591.         $entityManager = $this->getDoctrine()->getManager();
  592.         $entityManager->persist($visit);
  593.         $entityManager->flush($visit);
  594.     }
  596.     protected function sendPassword(Mailer $mailer, $email) {
  597.         if (!$email) {
  598.             return false;
  599.         }
  600.         $user = $this->getDoctrine()->getRepository(User::class)->loadUserByUsername($email, false);
  601.         if(!$user){
  602.             return false;
  603.         }
  604.         $message = $mailer->createMessage();
  605.         $message->setSubject("Восстановление пароля")
  606.             ->setFrom("info@slivki.by", 'Slivki.by')
  607.             ->setTo($user->getEmail())
  608.             ->setBody(
  609.                 $this->renderView(
  610.                     'Slivki/emails/lost_password.html.twig',
  611.                     array('password' => $user->getPasswordClear())
  612.                 ),
  613.                 'text/html'
  614.             );
  615.         $mailer->send($message);
  617.         return true;
  618.     }
  620.     /** @deprecated  */
  621.     protected function getOfferTeaserCached(Offer $offer) {
  622.         $softCache = new SoftCache(OfferRepository::CACHE_NAME_TEASERS);
  623.         $offerTeaserCached = $softCache->get($offer->getID());
  624.         if ($offerTeaserCached) {
  625.             return $offerTeaserCached;
  626.         }
  627.         $teaserHTML = $this->get('twig')->render('Slivki/offers/teaser.html.twig', ['offer' => $offer]);
  628.         $softCache->set($offer->getID(), $teaserHTML, 24 * 60 * 60);
  629.         return $teaserHTML;
  630.     }
  632.     protected function getOfferRateSchedule(Session $session) {
  633.         $user = $this->getUser();
  634.         $lastActivity = $session->get(self::LAST_OFFER_RATE_ACTIVITY_PARAMETER_NAME);
  635.         if (!$user || !$user->isWantRatePopup() || ($lastActivity && time() - $lastActivity < 300) ) {
  636.             return false;
  637.         }
  638.         $dql = 'select schedule from Slivki:OfferRateSchedule schedule where schedule.userID = :userID and schedule.showOn < CURRENT_TIMESTAMP() order by schedule.ID ASC';
  639.         $rateSchedule = $this->getDoctrine()->getManager()->createQuery($dql)->setParameter('userID', $user->getID())->getResult();
  641.         return count($rateSchedule) > 0 ? $rateSchedule[0] : false;
  642.     }
  644.     protected function handleFileUpload(KernelInterface $kernel, $uploadedFile, $destinationPath) {
  645.         $fileSystem = new Filesystem();
  646.         $filePath = $kernel->getProjectDir() . '/public' . $destinationPath;
  647.         $fileName = $uploadedFile->getClientOriginalName();
  648.         while ($fileSystem->exists($filePath . $fileName)) {
  649.             $fileName = time() . '_' . $fileName;
  650.         }
  651.         $uploadedFile->move($filePath, $fileName);
  653.         return $fileName;
  654.     }
  656.     public function getShareClicks($entityID) {
  657.         $sql = "select month_share.network_name as network, coalesce(yesterday_click_count, 0) as yesterday, coalesce(month_click_count, 0) as month from 
  658.         (select network_name, count(id) as month_click_count from share_click 
  659.         where entity_id = $entityID and created_on::date between (CURRENT_DATE + INTERVAL '-31 day')::date and CURRENT_DATE group by network_name) as month_share 
  660.         LEFT JOIN
  661.         (select network_name, count(id) as yesterday_click_count from share_click 
  662.         where entity_id = $entityID and created_on::date = (CURRENT_DATE + INTERVAL '-1 day')::date group by network_name) as yestarday_share 
  663.         on yestarday_share.network_name = month_share.network_name";
  665.         return $this->getDoctrine()->getManager()->getConnection()->executeQuery($sql)->fetchAll();
  666.     }
  668.     public function getMainHotFeed(OfferCacheService $offerCacheService, SaleCacheService $saleCacheService, $limit = null, $offset = 0, $type = HotFeed::TYPE_MAIN_PAGE, $cityID = null) {
  669.         $entityManager = $this->getDoctrine()->getManager();
  670.         $cityCondition = '';
  671.         if ($cityID > 0) {
  672.             $cityCondition = ' and city_id = ' . $cityID;
  673.         }
  674.         $sql = 'select * from hot_feed where type = ' . (int)$type . " $cityCondition order by created_on desc limit " . (int)$limit . ' offset ' . (int)$offset;
  675.         $entityIDList = $entityManager->getConnection()->executeQuery($sql)->fetchAll();
  676.         $entityList = [];
  677.         $saleRepository = $entityManager->getRepository(Sale::class);
  678.         $categorySoftCache = new SoftCache(CategoryRepository::CACHE_NAME);
  679.         $categoryRepository = $entityManager->getRepository(Category::class);
  680.         foreach ($entityIDList as $item) {
  681.             $entity = null;
  682.             switch ($item['entity_type_id']) {
  683.                 case Category::SALE_CATEGORY_ID:
  684.                     $entity = $saleCacheService->getSale($item['entity_id']);
  685.                     break;
  686.                 case Category::OFFER_CATEGORY_ID:
  687.                     $entity = $offerCacheService->getOffer($item['entity_id'], true);
  688.                     break;
  689.                 case Category::CATEGORY_ID:
  690.                     $entity = $categorySoftCache->get($item['entity_id']);
  691.                     $entity = $entity["category"];
  692.                     break;
  693.             }
  694.             if ($entity) {
  695.                 $iconMedia = $entity->getHotFeedIconMedia();
  696.                 $isVideoGuide = false;
  697.                 switch ($item['entity_type_id']) {
  698.                     case Category::OFFER_CATEGORY_ID:
  699.                         $title = $entity->getTitle();
  700.                         $entityUrlType = SeoRepository::RESOURCE_URL_OFFER_DETAILS;
  701.                         if (!$iconMedia && $entity->getCategories()->count() > 0) {
  702.                             $categoryID = $entity->getCategories()->first()->getID();
  703.                             $category = $entityManager->getRepository(Category::class)->findCached($categoryID);
  704.                             if ($category) {
  705.                                 $iconMedia = $category['category']->getHotFeedIconMedia();
  706.                             }
  707.                         }
  708.                         $imageMedia = $entity->getTeaserMedia();
  709.                         break;
  710.                     case Category::SALE_CATEGORY_ID:
  711.                         $title = $entity->getTitle();
  712.                         $entityUrlType = SeoRepository::RESOURCE_URL_SALE_DETAILS;
  713.                         $isVideoGuide = $entity->isInCategory(Category::SALE_VIDEO_GUIDE_CATEGORY_ID);
  714.                         if (!$iconMedia) {
  715.                             foreach ($entity->getCategories() as $category) {
  716.                                 $category = $categoryRepository->findCached($category->getID());
  717.                                 if ($category) {
  718.                                     $iconMedia = $category['category']->getHotFeedIconMedia();
  719.                                     if ($iconMedia) {
  720.                                         break;
  721.                                     }
  722.                                 }
  723.                             }
  724.                         }
  725.                         $imageMedia = $entity->getIcon();
  726.                         break;
  727.                     case Category::CATEGORY_ID:
  728.                         $title = $entity->getHotFeedName() ? $entity->getHotFeedName() : $entity->getName();
  729.                         switch ($entity->getDomainObjectID()) {
  730.                             case Category::OFFER_CATEGORY_ID:
  731.                                 $entityUrlType = SeoRepository::RESOURCE_URL_OFFER_CATEGORY;
  732.                                 break;
  733.                             case Category::SALE_CATEGORY_ID:
  734.                                 $entityUrlType = SeoRepository::RESOURCE_URL_OFFER_CATEGORY;
  735.                                 break;
  736.                         }
  737.                         $imageMedia = $entity->getHotFeedMedia();
  738.                         break;
  739.                 }
  740.                 $createdOn = \DateTime::createFromFormat('Y-m-d H:i:s', $item['created_on']);
  741.                 $todayStart = \DateTime::createFromFormat('Y-m-d H:i:s', date('Y-m-d H:i:s'))->modify('-23 hour');
  742.                 $yesterdayStart = \DateTime::createFromFormat('Y-m-d  H:i:s', date('Y-m-d 00:00:00'))->modify('-1 day');
  743.                 $timeText = $createdOn->format('d.m.y');
  744.                 if ($createdOn >= $todayStart) {
  745.                     $timeText = $createdOn->format('H:i');
  746.                 } elseif ($createdOn >= $yesterdayStart) {
  747.                     $timeText = "вчера";
  748.                 }
  749.                 $entityList[] = [
  750.                     'createdOn' => $createdOn,
  751.                     'title' => $title,
  752.                     'isVideoGuide' => $isVideoGuide,
  753.                     'entityUrlType' => $entityUrlType,
  754.                     'iconMedia'=> $iconMedia,
  755.                     'imageMedia' => $imageMedia,
  756.                     'timeText' => $timeText,
  757.                     'entity' => $entity
  758.                 ];
  759.             }
  760.         }
  761.         return $entityList;
  762.     }
  764.     /**
  765.      * @deprecated use CommentHelper
  766.      */
  767.     public function prepareCommentText($commentText) {
  768.         $commentText = str_replace(['<div>', '</div>', '<br>', '<br/>', '<br />'], "\n", $commentText);
  769.         $commentText = strip_tags($commentText, '<img><a>');
  770.         return preg_replace("/[\r\n]+/", "\n", $commentText);
  771.     }
  773.     public function sendOfferCommentNotice(Mailer $mailer, Offer $offer, Comment $comment, Comment $parentComment = null) {
  774.         if (!$comment->isConfirmedPhone()) {
  775.             return false;
  776.         }
  777.         // Send Answer To Customer Comment
  778.         if ($parentComment) {
  779.             $email = $parentComment->getUser()->getEmail();
  780.             if ($email) {
  781.                 $message = $mailer->createMessage();
  782.                 $message->setSubject("Отзыв на акцию")
  783.                     ->setFrom("info@slivki.by", 'Slivki.by')
  784.                     ->setTo($parentComment->getUser()->getEmail())
  785.                     ->setBody(
  786.                         $this->renderView(
  787.                             'Slivki/emails/answer_to_customer_comment.html.twig',
  788.                             array('comment' => $comment)
  789.                         ),
  790.                         'text/html'
  791.                     );
  792.                 $mailer->send($message);
  793.             }
  794.         }
  795.         $directors = $offer->getDirectors();
  796.         if ($directors && $directors->count() > 0  && $directors->first()->getEmail() != '') {
  797.             $message = $mailer->createMessage();
  798.             $message->setSubject("Отзыв на акцию")
  799.                 ->setFrom("info@slivki.by", 'Slivki.by')
  800.                 ->setTo($directors->first()->getEmail())
  801.                 ->setBody($this->renderView('Slivki/emails/comment_to_supplier.html.twig', ['comment' => $comment, 'offer' => $offer]), 'text/html');
  802.             $mailer->send($message);
  803.         }
  804.     }
  806.     public function getCheckAddressResponse($orderInfo) {
  807.         $message = '';
  808.         switch ($orderInfo->resultState) {
  809.             case 1:
  810.                 if (isset($orderInfo->problem)) {
  811.                     $message = $orderInfo->problem;
  812.                 }
  813.                 if (isset($orderInfo->minSumForFreeDelivery)) {
  814.                     $message = \sprintf('Минимальная сумма заказа %s руб.', (string) $orderInfo->minSumForFreeDelivery);
  815.                 }
  816.                 break;
  817.             case 2:
  818.                 $message = 'Извините, в данное время заказ невозможен. Пожалуйста, выберите другое время';
  819.                 break;
  820.             case 3:
  821.                 $message = 'Извините, на данный адрес доставка не осуществляется';
  822.                 break;
  823.             case 4:
  824.             case 5:
  825.                 $message = 'На данный момент заказ одного из товаров невозможен';
  826.                 break;
  827.             case 9999:
  828.                 $message = 'Заказы принимаются с 11:00 по 22:22';
  829.         }
  830.         return [
  831.             'status' => $orderInfo->resultState === 0 ? 'success' : 'error',
  832.             'error' => $orderInfo->resultState != 0,
  833.             'deliveryPrice' => isset($orderInfo->deliveryServiceProductInfo) ? $orderInfo->deliveryServiceProductInfo->productSum : 0,
  834.             'message' => $message
  835.         ];
  837.     }
  839.     public function getOptions(
  840.         ImageService $imageService,
  841.         Offer &$offer,
  842.         AbstractDelivery $iikoUtil,
  843.         $sticksCount,
  844.         $shippingType = null
  845.     ) {
  846.         $entityManager = $this->getDoctrine()->getManager();
  847.         $optionRepository = $entityManager->getRepository(FoodOfferOptionExtension::class);
  848.         $options = [];
  849.         $sticks = $iikoUtil->getProduct($iikoUtil::STICKS_PRODUCT_ID);
  850.         $sticksID = null;
  851.         if ($sticks) {
  852.             $option = $optionRepository->findOneBy(['offer' => $offer, 'partnerItemID' => $sticks->id]);
  853.             if ($option) {
  854.                 $sticksID = $sticks->id;
  855.                 $sticks->partnerID = $sticks->id;
  856.                 $sticks->id = $option->getID();
  857.                 $sticks->offerPrice = $sticks->price;
  858.                 $sticks->regularPrice = $sticks->price;
  859.                 $sticks->inBasketCount = $sticksCount;
  860.                 $sticks->isSticks = true;
  861.                 $sticks->isIncluded = false;
  862.                 $sticks->position = $option->getPosition() ?: CustomProductOfferSorter::DEFAULT_POSITION;
  863.                 $sticks->imageURL = '';
  864.                 if (null !== $sticks->images && count($sticks->images) > 0) {
  865.                     if ($sticks->images[count($sticks->images) - 1] instanceof OfferExtensionMedia) {
  866.                         $sticks->imageURL = $imageService->getImageURLCached($sticks->images[count($sticks->images) - 1], 540, 0);
  867.                     } else if ($sticks->images[count($sticks->images) - 1]) {
  868.                         $sticks->imageURL = $sticks->images[count($sticks->images) - 1]->imageUrl;
  869.                     }
  870.                 }
  871.                 if ($option->isActive()) {
  872.                     $options[] = $sticks;
  873.                 }
  874.             }
  875.         }
  877.         foreach ($iikoUtil->getOptions() as $item) {
  878.             if (($sticks && $sticksID == $item->id) || (isset($item->isSticks) && $item->isSticks)) {
  879.                 continue;
  880.             }
  881.             $option = $optionRepository->findOneBy(['offer' => $offer, 'partnerItemID' => $item->id]);
  882.             if ($option) {
  883.                 switch ($item->id) {
  884.                     case $iikoUtil::SOY_SAUCE_PRODUCT_ID:
  885.                         $item->isSoySauce = true;
  886.                         $item->isIncluded = false;
  887.                         break;
  888.                     case $iikoUtil::WASABI_PRODUCT_ID:
  889.                         $item->isWasabi = true;
  890.                         $item->isIncluded = false;
  891.                         break;
  892.                     case $iikoUtil::GINGER_PRODUCT_ID:
  893.                         $item->isGinger = true;
  894.                         $item->isIncluded = false;
  895.                 }
  896.                 $item->partnerID = $item->id;
  897.                 $item->id = $option->getID();
  898.                 $item->offerPrice = $item->price;
  899.                 $item->regularPrice = $item->price;
  900.                 $item->imageURL = null;
  901.                 $item->itemCount = (int) $option->getComponentsCount();
  902.                 $item->weight = (double) $option->getWeight();
  903.                 $item->position = $option->getPosition() ?: CustomProductOfferSorter::DEFAULT_POSITION;
  904.                 if (isset($item->images[count($item->images) - 1])) {
  905.                     if ($item->images[count($item->images) - 1] instanceof OfferExtensionMedia) {
  906.                         $item->imageURL = $imageService->getImageURLCached($item->images[count($item->images) - 1], 540, 0);
  907.                     } else if ($item->images[count($item->images) - 1]) {
  908.                         $item->imageURL = $item->images[count($item->images) - 1]->imageUrl;
  909.                     }
  910.                 }
  911.                 if ($option->isActive()) {
  912.                     if (null !== $shippingType) {
  913.                         $isShippingType = 'getIs' . ucfirst($shippingType);
  914.                         if ($option->{$isShippingType}()) {
  915.                             $options[] = $item;
  916.                         }
  917.                     } else {
  918.                         $options[] = $item;
  919.                     }
  920.                 }
  921.             }
  922.         }
  924.         return $options;
  925.     }
  926. }