src/Controller/ListingController.php line 75

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\AccommodationType;
  6. use App\Entity\Addons;
  7. use App\Entity\BookableExperiences;
  8. use App\Entity\Bookings;
  9. use App\Entity\Favourites;
  10. use App\Entity\ListingQuestions;
  11. use App\Entity\Media;
  12. use App\Entity\MinimumNightOverride;
  13. use App\Entity\PricingNights;
  14. use App\Entity\PricingStay;
  15. use App\Entity\Property;
  16. use App\Entity\PropertyReviews;
  17. use App\Entity\PropertyTags;
  18. use App\Entity\PropertyTagsApplied;
  19. use App\Entity\Regions;
  20. use App\Entity\RoomBannersSpecific;
  21. use App\Entity\RoomURLAlias;
  22. use App\Entity\TrackedCalendars;
  23. use App\Entity\User;
  24. use App\Security\LoginFormAuthenticator;
  25. use App\Service\GlobalFunctions;
  26. use Cocur\Slugify\Slugify;
  27. use Liip\ImagineBundle\Message\WarmupCache;
  28. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  29. use Symfony\Component\Form\Extension\Core\Type\ChoiceType;
  30. use Symfony\Component\Form\Extension\Core\Type\DateType;
  31. use Symfony\Component\Form\Extension\Core\Type\HiddenType;
  32. use Symfony\Component\Form\Extension\Core\Type\MoneyType;
  33. use Symfony\Component\Form\Extension\Core\Type\NumberType;
  34. use Symfony\Component\Form\Extension\Core\Type\SubmitType;
  35. use Symfony\Component\Form\Extension\Core\Type\TextareaType;
  36. use Symfony\Component\Form\Extension\Core\Type\TextType;
  37. use Symfony\Component\HttpFoundation\Request;
  38. use Symfony\Component\HttpFoundation\Response;
  39. use Symfony\Component\Messenger\MessageBusInterface;
  40. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  41. use Symfony\Component\Security\Guard\GuardAuthenticatorHandler;
  42. use Vich\UploaderBundle\Form\Type\VichImageType;
  44. class ListingController extends AbstractController
  45. {
  46.     public function oldlisting($listing_slug, $room_slug)
  47.     {
  48.         $em = $this->getDoctrine()->getManager();
  50.         $AccommInfo = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  51.                 'RoomSlug' => $room_slug,
  52.                 'Enabled' => true,
  53.             ]);
  55.         $NewSlug = $AccommInfo->getRoomSlugNew();
  57.         if (null == $NewSlug) {
  58.             $slugify = new Slugify();
  59.             $NewHeadlineSlug = $slugify->slugify($AccommInfo->getSearchHeadline());
  61.             $AccommInfo->setRoomSlugNew($NewHeadlineSlug);
  62.             $em->persist($AccommInfo);
  63.             $em->flush();
  65.             $NewSlug = $NewHeadlineSlug;
  66.         }
  68.         if (isset($_GET['preview_listing'])) {
  69.             return $this->redirectToRoute('listing_new_url', ['room_slug_new' => $NewSlug, 'preview_listing' => 'true']);
  70.         } else {
  71.             return $this->redirectToRoute('listing_new_url', ['room_slug_new' => $NewSlug]);
  72.         }
  73.     }
  75.     public function index($room_slug_new, GlobalFunctions $GlobalFn)
  76.     {
  77.         $em = $this->getDoctrine()->getManager();
  79.         // Overrides for the URL and Aliases
  81.         $URL = $this->getDoctrine()->getRepository(RoomURLAlias::class)->findOneBy(['Alias' => $room_slug_new]);
  82.         if ($URL) {
  83.             return $this->redirectToRoute('listing_new_url', ['room_slug_new' => $URL->getRoom()->getRoomSlugNew()]);
  84.         } else {
  85.             if (isset($_GET['preview_listing'])) {
  86.                 $AccommInfo = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  87.                     'RoomSlugNew' => $room_slug_new,
  88.                 ]);
  89.             } else {
  90.                 $AccommInfo = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  91.                     'RoomSlugNew' => $room_slug_new,
  92.                     'Enabled' => true,
  93.                 ]);
  94.             }
  95.         }
  97.         if (!$AccommInfo) {
  98.             return new Response('Sorry, the requested property is not currently available');
  99.         }
  101.         if (isset($_GET['check_in'])) {
  102.             $CheckIn = $_GET['check_in'];
  103.             $CheckOut = $_GET['check_out'];
  104.         } else {
  105.             $CheckIn = null;
  106.             $CheckOut = null;
  107.         }
  109.         $room_slug = $AccommInfo->getRoomSlug();
  110.         $PropertyCode = $AccommInfo->getPropertyCode();
  112.         $ListingInfo = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  113.                 'ListingCode' => $PropertyCode,
  114.             ]);
  116.         $listing_slug = $ListingInfo->getListingSlug();
  118.         if (isset($_GET['preview_listing']) or 'Listed' == $ListingInfo->getListingStatus()) {
  119.             $LandownerInfo = $this->getDoctrine()->getRepository(User::class)->find($ListingInfo->getLandownerId());
  121.             $ListingCode = $ListingInfo->getListingCode();
  123.             $RoomTonightPrice = $GlobalFn->nightPrice(0, $AccommInfo->getRoomCode(), date('Y-m-d'));
  125.             $GetListingRooms = $this->getDoctrine()->getRepository(AccommodationType::class)->findBy([
  126.                     'PropertyCode' => $ListingCode,
  127.                     'Enabled' => true,
  128.             ]);
  130.             $OtherListingRooms = [];
  131.             foreach ($GetListingRooms as $thisRoom) {
  132.                 if ('Listed' == $thisRoom->getProperty()->getListingStatus()) {
  133.                     if ($thisRoom->getRoomCode() !== $AccommInfo->getRoomCode()) {
  134.                         $OtherListingRooms[] = $thisRoom;
  135.                     }
  136.                 }
  137.             }
  139.             $CurrentRecentlyViewed = $this->get('session')->get('recently_viewed');
  141.             $NewRecentlyViewed = '['.$AccommInfo->getRoomCode().']'.str_replace('['.$AccommInfo->getRoomCode().']', '', $CurrentRecentlyViewed);
  142.             $this->get('session')->set('recently_viewed', $NewRecentlyViewed);
  144.             // $GetImages = $GlobalFn->listing_photos($ListingCode, 0);
  145.             $MainImg = $GlobalFn->room_photos($AccommInfo->getRoomCode(), 1);
  146.             $RoomImg = $GlobalFn->room_photos($AccommInfo->getRoomCode(), 0);
  148.             $Images = [];
  149.             foreach ($RoomImg as $ThisImage) {
  150.                 $Images[] = ['id' => $ThisImage['id'], 'document_file_name' => 'media/'.$ThisImage['document_file_name'], 'description' => $ThisImage['description']];
  151.             }
  153.             $UserImg = $this->getDoctrine()->getRepository(Media::class)->findOneBy(['UserId' => $LandownerInfo->getId()]);
  154.             if ($UserImg) {
  155.                 if ('' == $UserImg->getDocumentFileName()) {
  156.                     $UserImg = ['DocumentFileName' => 'media/OTBT_logo_green_RGB-01.png'];
  157.                 } else {
  158.                     $UserImg = ['DocumentFileName' => 'media/'.$UserImg->getDocumentFileName()];
  159.                 }
  160.             } else {
  161.                 $UserImg = ['DocumentFileName' => 'media/OTBT_logo_green_RGB-01.png'];
  162.             }
  164.             $Addons = $this->getDoctrine()->getRepository(Addons::class)->findBy([
  165.                     'PropertyCode' => $ListingCode,
  166.                     'Enabled' => true,
  167.                 ]);
  169.             $AddonImg = [];
  170.             foreach ($Addons as $ThisAddon) {
  171.                 $AddonImg[$ThisAddon->getId()] = $GlobalFn->addon_photos($ThisAddon->getId(), 1);
  172.             }
  174.             /*$Amenities = $this->getDoctrine()->getRepository(PropertyTags::class)->findBy([
  175.                     'TagType' => 'amenity',
  176.                 ]);
  178.                 */
  180.             $GetRoomTags = $ChosenAmenity = $this->getDoctrine()->getRepository(PropertyTagsApplied::class)->findBy([
  181.                 'Room' => $AccommInfo,
  182.             ]);
  183.             $AllRoomTags = [];
  184.             foreach ($GetRoomTags as $thisTag) {
  185.                 $AllRoomTags[] = $thisTag->getTag()->getId();
  186.             }
  188.             $ActivitiesFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  189.                 ->where('t.TagType = :tag_type')
  190.                 ->andWhere('t.Params IS NULL')
  191.                 ->setParameter('tag_type', 'activities')
  192.                 ->orderBy('t.TagName', 'ASC')
  193.                 ->getQuery()
  194.                 ->getResult();
  196.             $ChosenActivitiesFilters = [];
  197.             $ContraActivitiesFilters = [];
  198.             foreach ($ActivitiesFilters as $thisFilter) {
  199.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  200.                     $ChosenActivitiesFilters[] = $thisFilter;
  201.                 } else {
  202.                     if (null !== $thisFilter->getContraTagName()) {
  203.                         $ContraActivitiesFilters[] = $thisFilter;
  204.                     }
  205.                 }
  206.             }
  208.             // ---
  210.             $AmenitiesFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  211.                ->where('t.TagType = :tag_type')
  212.                ->setParameter('tag_type', 'amenity')
  213.                ->orderBy('t.TagName', 'ASC')
  214.                ->getQuery()
  215.                ->getResult();
  217.             $ChosenAmenitiesFilters = [];
  218.             $ContraAmenitiesFilters = [];
  219.             foreach ($AmenitiesFilters as $thisFilter) {
  220.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  221.                     $ChosenAmenitiesFilters[] = $thisFilter;
  222.                 } else {
  223.                     if (null !== $thisFilter->getContraTagName()) {
  224.                         $ContraAmenitiesFilters[] = $thisFilter;
  225.                     }
  226.                 }
  227.             }
  229.             // ---
  231.             $ExperienceFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  232.                ->where('t.TagType = :tag_type')
  233.                ->setParameter('tag_type', 'experience')
  234.                ->orderBy('t.TagName', 'ASC')
  235.                ->getQuery()
  236.                ->getResult();
  238.             $ChosenExperienceFilters = [];
  239.             foreach ($ExperienceFilters as $thisFilter) {
  240.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  241.                     $ChosenExperienceFilters[] = $thisFilter;
  242.                 }
  243.             }
  245.             // ---
  247.             $EatingDrinkingFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  248.                ->where('t.TagType = :tag_type')
  249.                ->setParameter('tag_type', 'eating_drinking')
  250.                ->orderBy('t.TagName', 'ASC')
  251.                ->getQuery()
  252.                ->getResult();
  254.             $ChosenEatingDrinkingFilters = [];
  255.             $ContraEatingDrinkingFilters = [];
  256.             foreach ($EatingDrinkingFilters as $thisFilter) {
  257.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  258.                     $ChosenEatingDrinkingFilters[] = $thisFilter;
  259.                 } else {
  260.                     if (null !== $thisFilter->getContraTagName()) {
  261.                         $ContraEatingDrinkingFilters[] = $thisFilter;
  262.                     }
  263.                 }
  264.             }
  266.             // ---
  268.             $AccommTypeFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  269.                ->where('t.TagType = :tag_type')
  270.                ->setParameter('tag_type', 'accomm_type')
  271.                ->orderBy('t.TagName', 'ASC')
  272.                ->getQuery()
  273.                ->getResult();
  275.             $ChosenAccommTypeFilters = [];
  276.             $ContraAccommTypeFilters = [];
  277.             foreach ($AccommTypeFilters as $thisFilter) {
  278.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  279.                     $ChosenAccommTypeFilters[] = $thisFilter;
  280.                 } else {
  281.                     if (null !== $thisFilter->getContraTagName()) {
  282.                         $ContraAccommTypeFilters[] = $thisFilter;
  283.                     }
  284.                 }
  285.             }
  287.             // ---
  289.             $StayInfoFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  290.                ->where('t.TagType = :tag_type')
  291.                ->setParameter('tag_type', 'stay_info')
  292.                ->orderBy('t.TagName', 'ASC')
  293.                ->getQuery()
  294.                ->getResult();
  296.             $ChosenStayInfoFilters = [];
  297.             $ContraStayInfoFilters = [];
  298.             foreach ($StayInfoFilters as $thisFilter) {
  299.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  300.                     $ChosenStayInfoFilters[] = $thisFilter;
  301.                 } else {
  302.                     if (null !== $thisFilter->getContraTagName()) {
  303.                         $ContraStayInfoFilters[] = $thisFilter;
  304.                     }
  305.                 }
  306.             }
  308.             // ---
  310.             $UniqueThingsFilters = $em->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  311.                ->where('t.TagType = :tag_type')
  312.                ->setParameter('tag_type', 'unique_things')
  313.                ->orderBy('t.TagName', 'ASC')
  314.                ->getQuery()
  315.                ->getResult();
  317.             $ChosenUniqueThingsFilters = [];
  318.             $ContraUniqueThingsFilters = [];
  319.             foreach ($UniqueThingsFilters as $thisFilter) {
  320.                 if (in_array($thisFilter->getId(), $AllRoomTags)) {
  321.                     $ChosenUniqueThingsFilters[] = $thisFilter;
  322.                 } else {
  323.                     if (null !== $thisFilter->getContraTagName()) {
  324.                         $ContraUniqueThingsFilters[] = $thisFilter;
  325.                     }
  326.                 }
  327.             }
  329.             $GetRegion = $this->getDoctrine()->getRepository(Regions::class)->findOneBy([
  330.                 'Name' => $ListingInfo->getPhysAddr3(),
  331.             ]);
  333.             $NearbyListings = $em->getRepository("App\Entity\AccommodationType")->createQueryBuilder('t')
  334.                ->where('t.Region = :Region')
  335.                ->andWhere('t.Enabled = 1')
  336.                ->andWhere('t.Property != :ThisListingCode')
  337.                ->setParameter('Region', $GetRegion)
  338.                ->setParameter('ThisListingCode', $ListingInfo)
  339.                ->setMaxResults(4)
  340.                ->getQuery()
  341.                ->getResult();
  343.             shuffle($NearbyListings);
  345.             $ReviewData = [];
  346.             $Reviews = $this->getDoctrine()->getRepository(PropertyReviews::class)->findBy([
  347.                 'PropertyCode' => $ListingCode,
  348.                 'Approved' => true,
  349.             ], ['id' => 'DESC']);
  350.             foreach ($Reviews as $ThisReview) {
  351.                 if ($ThisReview->getBookingId() > 0) {
  352.                     $BookingInfo = $this->getDoctrine()->getRepository(Bookings::class)->find($ThisReview->getBookingId());
  353.                     $HolidaymakerInfoReview = $this->getDoctrine()->getRepository(User::class)->find($BookingInfo->getHolidaymakerId());
  354.                     $ReviewData[$ThisReview->getId()] = [
  355.                         'holidaymakerinfo' => $HolidaymakerInfoReview,
  356.                         'bookinginfo' => $BookingInfo,
  357.                     ];
  358.                 } else {
  359.                     $ReviewData[$ThisReview->getId()] = [
  360.                         'holidaymakerinfo' => [],
  361.                         'bookinginfo' => [],
  362.                     ];
  363.                 }
  364.             }
  366.             $RoomBanners = $em->getRepository("App\Entity\RoomBanners")->createQueryBuilder('t')
  367.                ->where('t.Enabled = true')
  368.                ->andWhere(':time_now BETWEEN t.ApplyFrom AND t.ApplyTo')
  369.                ->setParameter('time_now', new \DateTime('now'))
  370.                ->getQuery()
  371.                ->getResult();
  373.             $RoomBannerOutput = '';
  375.             foreach ($RoomBanners as $ThisRoomBanner) {
  376.                 $RoomSpecificBanner = $this->getDoctrine()->getRepository(RoomBannersSpecific::class)->findOneBy([
  377.                     'RoomBanner' => $ThisRoomBanner,
  378.                     'Enabled' => true,
  379.                     'Room' => $AccommInfo,
  380.                 ]);
  382.                 if ($RoomSpecificBanner) {
  383.                     $RoomBannerOutput .= "<div class='alert' style='".$ThisRoomBanner->getBoxStyling()."'>";
  384.                     $RoomBannerOutput .= "<div class='row'>";
  385.                     $RoomBannerOutput .= "<div class='col-sm-2' style='text-align:center;'>";
  386.                     $RoomBannerOutput .= "<i class='fa ".$ThisRoomBanner->getBannerFAIcon()."' style='font-size:90px;'></i>";
  387.                     $RoomBannerOutput .= '</div>';
  388.                     $RoomBannerOutput .= "<div class='col-sm-10'>";
  389.                     $RoomBannerOutput .= $RoomSpecificBanner->getMessage();
  390.                     $RoomBannerOutput .= '</div>';
  391.                     $RoomBannerOutput .= '</div>';
  392.                     $RoomBannerOutput .= '</div>';
  393.                 } elseif (true == $ThisRoomBanner->getForceDefaultMessage()) {
  394.                     $RoomBannerOutput .= "<div class='alert' style='".$ThisRoomBanner->getBoxStyling()."'>";
  395.                     $RoomBannerOutput .= "<div class='row'>";
  396.                     $RoomBannerOutput .= "<div class='col-sm-2' style='text-align:center;'>";
  397.                     $RoomBannerOutput .= "<i class='fa ".$ThisRoomBanner->getBannerFAIcon()."' style='font-size:90px;'></i>";
  398.                     $RoomBannerOutput .= '</div>';
  399.                     $RoomBannerOutput .= "<div class='col-sm-10'>";
  400.                     $RoomBannerOutput .= $ThisRoomBanner->getDefaultMessage();
  401.                     $RoomBannerOutput .= '</div>';
  402.                     $RoomBannerOutput .= '</div>';
  403.                     $RoomBannerOutput .= '</div>';
  404.                 } else {
  405.                 }
  406.             }
  407.             if (count($RoomBanners) > 0) {
  408.                 // $RoomBannerOutput .="<hr>";
  409.             }
  411.             // Listing QnAs
  413.             $ListingQuestions = $em->getRepository("App\Entity\ListingQuestions")->createQueryBuilder('t')
  414.                ->where('t.Room = :room')
  415.                ->andWhere('t.ModeratedBy > 0')
  416.                ->andWhere('t.ShowOnListing=1')
  417.                ->setParameter('room', $AccommInfo)
  418.                ->getQuery()
  419.                ->getResult();
  421.             // Bookable Experiences
  423.             $GetAllBookables = $this->getDoctrine()->getRepository(BookableExperiences::class)->findBy(['Status' => 'Listed']);
  424.             $BookableExperiences = [];
  425.             $SearchDistance = $GlobalFn->datedVar('bookableExperiencesSearchDistanceKm', date('Y-m-d'));
  426.             foreach ($GetAllBookables as $thisBookable) {
  427.                 $DistanceAway = $GlobalFn->distanceCalculation($ListingInfo->getCoordLat(), $ListingInfo->getCoordLong(), $thisBookable->getCoordLat(), $thisBookable->getCoordLong());
  428.                 if ($DistanceAway < $SearchDistance) {
  429.                     $BookableExperiences[] = [$thisBookable, $DistanceAway];
  430.                 }
  431.             }
  432.             usort($BookableExperiences, function ($a, $b) {
  433.                 return $a[1] <=> $b[1];
  434.             });
  436.             $UserExistingBooking = $this->getDoctrine()->getRepository(Bookings::class)->findOneBy([
  437.                 'RelatedRoom' => $AccommInfo,
  438.                 'RelatedHolidaymaker' => $this->getUser(),
  439.                 'Status' => 'Draft',
  440.             ]);
  442.             return $this->render('listing/index.html.twig', [
  443.                 'controller_name' => 'ListingController',
  444.                 'listing_slug' => $listing_slug,
  445.                 'room_code' => $AccommInfo->getRoomCode(),
  446.                 'room_slug' => $room_slug,
  447.                 'listing_info' => $ListingInfo,
  448.                 'room_info' => $AccommInfo,
  449.                 'today_date' => date('Y-m-d'),
  450.                 'other_rooms' => $OtherListingRooms,
  451.                 'images_arr' => $Images,
  452.                 'tomorrow_date' => date('Y-m-d', strtotime('tomorrow')),
  453.                 'default_image' => '../../'.$MainImg,
  454.                 'other_room_count' => count($OtherListingRooms),
  455.                 'addons' => $Addons,
  456.                 'addons_img' => $AddonImg,
  457.                 'landowner_info' => $LandownerInfo,
  458.                 'map_lat' => $ListingInfo->getCoordLat(),
  459.                 'map_long' => $ListingInfo->getCoordLong(),
  460.                 'reviews' => $Reviews,
  461.                 'landowner_img' => $UserImg,
  462.                 'room_photos' => $RoomImg,
  463.                 'room_tonight_price' => $RoomTonightPrice,
  464.                 'room_banner_output' => $RoomBannerOutput,
  465.                 'nearby_listings' => $NearbyListings,
  466.                 'review_data' => $ReviewData,
  467.                 'listing_questions' => $ListingQuestions,
  468.                 'bookable_experiences' => $BookableExperiences,
  469.                 'checkin' => $CheckIn,
  470.                 'checkout' => $CheckOut,
  471.                 'user_existing_booking' => $UserExistingBooking,
  472.                 'filters_activities' => $ChosenActivitiesFilters,
  473.                 'filters_activities_contra' => $ContraActivitiesFilters,
  474.                 'filters_amenities' => $ChosenAmenitiesFilters,
  475.                 'filters_amenities_contra' => $ContraAmenitiesFilters,
  476.                 'filters_uniquethings' => $ChosenUniqueThingsFilters,
  477.                 'filters_uniquethings_contra' => $ContraUniqueThingsFilters,
  478.                 'filters_eatingdrinking' => $ChosenEatingDrinkingFilters,
  479.                 'filters_eatingdrinking_contra' => $ContraEatingDrinkingFilters,
  480.                 'filters_accommtype' => $ChosenAccommTypeFilters,
  481.                 'filters_accommtype_contra' => $ContraAccommTypeFilters,
  482.                 'filters_stayinfo' => $ChosenStayInfoFilters,
  483.                 'filters_stayinfo_contra' => $ContraStayInfoFilters,
  484.                 'filters_experience' => $ChosenExperienceFilters,
  485.             ]);
  486.         } else {
  487.             return new Response('Sorry, this listing can not be shown right now');
  488.         }
  489.     }
  491.     public function loginForFav($listing_slug, $room_slug)
  492.     {
  493.         return $this->redirectToRoute('listing', ['listing_slug' => $listing_slug, 'room_slug' => $room_slug]);
  494.     }
  496.     public function toggleFavourite($room_id, $ajax = true)
  497.     {
  498.         $user_id = $this->getUser()->getId();
  500.         $Room = $this->getDoctrine()->getRepository(AccommodationType::class)->find($room_id);
  502.         $Favourite = $this->getDoctrine()->getRepository(Favourites::class)->findOneBy([
  503.             'UserId' => $user_id,
  504.             'RoomId' => $room_id,
  505.         ]);
  507.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy(['ListingCode' => $Room->getPropertyCode()]);
  509.         $entityManager = $this->getDoctrine()->getManager();
  511.         if ($Favourite) {
  512.             $entityManager->remove($Favourite);
  513.             $entityManager->flush();
  515.             if (true == $ajax) {
  516.                 return new Response('ADD FAV');
  517.             } else {
  518.                 return $this->redirectToRoute('listing', ['listing_slug' => $Property->getListingSlug(), 'room_slug' => $Room->getRoomSlug()]);
  519.             }
  520.         } else {
  521.             $Favourite = new Favourites();
  522.             $Favourite->setRoomId($room_id);
  523.             $Favourite->setUserId($user_id);
  525.             $entityManager->persist($Favourite);
  526.             $entityManager->flush();
  528.             if (true == $ajax) {
  529.                 return new Response('REMOVE FAV');
  530.             } else {
  531.                 return $this->redirectToRoute('listing', ['listing_slug' => $Property->getListingSlug(), 'room_slug' => $Room->getRoomSlug()]);
  532.             }
  533.         }
  534.     }
  536.     public function loadFavourite($user_id, $room_id)
  537.     {
  538.         $Room = $this->getDoctrine()->getRepository(AccommodationType::class)->find($room_id);
  540.         $Favourite = $this->getDoctrine()->getRepository(Favourites::class)->findOneBy([
  541.             'UserId' => $user_id,
  542.             'RoomId' => $room_id,
  543.         ]);
  545.         if ($Favourite) {
  546.             return new Response('REMOVE FAV');
  547.         } else {
  548.             return new Response('ADD FAV');
  549.         }
  550.     }
  552.     public function updateCaption($photo_id, Request $request)
  553.     {
  554.         $GetPhoto = $this->getDoctrine()->getRepository(Media::class)->find($photo_id);
  556.         $GetPhoto->setDescription($request->request->get('caption'));
  558.         $entityManager = $this->getDoctrine()->getManager();
  559.         $entityManager->persist($GetPhoto);
  560.         $entityManager->flush();
  562.         return new Response('success');
  563.     }
  565.     public function photoManager($room_code, Request $request, MessageBusInterface $messageBus)
  566.     {
  567.         if (isset($_GET['mode'])) {
  568.             $Mode = $_GET['mode'];
  569.         } else {
  570.             $Mode = 'normal';
  571.         }
  573.         $AccommType = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  574.                 'RoomCode' => $room_code,
  575.         ]);
  577.         $user = $this->get('security.token_storage')->getToken()->getUser();
  579.         if ($this->isGranted('ROLE_ADMIN')) {
  580.             $user = $this->getDoctrine()->getRepository(User::class)->find($AccommType->getLandownerId());
  581.         }
  583.         $MatchListing = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  584.                 'ListingCode' => $AccommType->getPropertyCode(),
  585.                 'LandownerId' => $user,
  586.         ]);
  588.         if ($MatchListing) {
  589.             $GetPhotos = $this->getDoctrine()->getRepository(Media::class)->findBy([
  590.                 'RoomCode' => $room_code,
  591.             ], ['DisplayOrder' => 'ASC']);
  593.             $NewPhoto = new Media();
  595.             $entityManager = $this->getDoctrine()->getManager();
  597.             $form = $this->createFormBuilder($NewPhoto)
  598.                 ->add('documentFile', VichImageType::class)
  599.                 ->add('Description', TextType::class, ['label' => 'Caption', 'required' => false])
  600.                 ->add('save', SubmitType::class, ['label' => 'Upload'])
  601.                 ->getForm();
  603.             $form->handleRequest($request);
  605.             if ($form->isSubmitted() && $form->isValid()) {
  606.                 // $form->getData() holds the submitted values
  607.                 // but, the original `$task` variable has also been updated
  608.                 $NewPhoto = $form->getData();
  609.                 $NewPhoto->setRoomCode($room_code);
  611.                 $NewPhoto->setAccommType($AccommType);
  613.                 $entityManager->persist($NewPhoto);
  614.                 $entityManager->flush();
  616.                 $RandomFileName = time().'_'.$NewPhoto->getDocumentFileName();
  618.                 rename('../public/media/'.$NewPhoto->getDocumentFileName(), '../public/media/'.$RandomFileName);
  620.                 $messageBus->dispatch(new WarmupCache('/media/'.$RandomFileName));
  622.                 $NewPhoto->setDocumentFileName($RandomFileName);
  624.                 $entityManager->persist($NewPhoto);
  625.                 $entityManager->flush();
  627.                 // var_dump($NewPhoto);
  628.                 // exit();
  629.                 return $this->redirectToRoute('edit_listing_photos', ['room_code' => $room_code, 'mode' => $Mode]);
  630.             }
  632.             $random_number = rand(100000, 999999);
  634.             return $this->render('listing/photomanager.html.twig', [
  635.                 'listing_info' => $MatchListing,
  636.                 'photos' => $GetPhotos,
  637.                 'listing_code' => $MatchListing->getListingCode(),
  638.                 'room_code' => $room_code,
  639.                 'uploadForm' => $form->createView(),
  640.                 'mode' => $Mode,
  641.                 'random_number' => $random_number,
  642.             ]);
  643.         } else {
  644.             return new Response('No access');
  645.         }
  646.     }
  648.     public function resetPhotos($room_code, Request $request)
  649.     {
  650.         $ListingPhotos = $this->getDoctrine()->getRepository(Media::class)->findBy([
  651.             'RoomCode' => $room_code,
  652.         ], ['id' => 'ASC']);
  654.         $i = 1;
  655.         foreach ($ListingPhotos as $thisPhoto) {
  656.             $thisPhoto->setDisplayOrder($i);
  658.             $entityManager = $this->getDoctrine()->getManager();
  659.             $entityManager->persist($thisPhoto);
  661.             ++$i;
  662.         }
  664.         $entityManager->flush();
  666.         return $this->redirectToRoute('edit_listing_photos', ['room_code' => $room_code]);
  667.     }
  669.     public function newListing(GuardAuthenticatorHandler $guardHandler, Request $request, LoginFormAuthenticator $authenticator, GlobalFunctions $GlobalFn)
  670.     {
  671.         $entityManager = $this->getDoctrine()->getManager();
  673.         /*$NewListingCode = substr(str_shuffle("ABCDEFGHIJKLMNPQRSTUVWXYZ1234567890"),0,9);
  675.         $GetUserProperties = $this->getDoctrine()->getRepository(Property::class)->findBy([
  676.             'LandownerId' => $this->getUser()->getId()
  677.         ]);
  679.         foreach($GetUserProperties as $thisProperty) {
  680.             if($thisProperty->getListingStatus()=="New") {
  681.                 return $this->redirectToRoute('new_listing_form_edit',array('listing_code'=>$thisProperty->getListingCode()));
  682.                 exit;
  683.             }
  684.         }
  686.         $Property = new Property();
  687.         $user_id = $this->getUser()->getId();
  688.         $Property->setLandownerId($user_id);
  689.         $Property->setPropertyTitle("");
  690.         $Property->setListingSlug("listing-".$NewListingCode);
  691.         $Property->setListingCode($NewListingCode);
  692.         $Property->setListingStatus("New");
  693.         $Property->setCreatedDate(new \DateTime('today'));*/
  695.         $user = $this->getUser();
  697.         $user->addRole('ROLE_LANDOWNER');
  699.         $entityManager->flush();
  701.         $GlobalFn->addUserToList($user->getId(), 3);
  703.         $doLogin = $guardHandler->authenticateUserAndHandleSuccess(
  704.             $user,
  705.             $request,
  706.             $authenticator,
  707.             'main' // firewall name in security.yaml
  708.         );
  710.         return $this->redirectToRoute('onboarding_new');
  711.     }
  713.     public function updateListingField(Request $request)
  714.     {
  715.         $entityManager = $this->getDoctrine()->getManager();
  717.         $listing_id = $request->request->get('listing_id');
  718.         $field = $request->request->get('field');
  720.         $user_id = $this->getUser()->getId();
  721.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  722.                 'id' => $listing_id,
  723.                 'LandownerId' => $user_id,
  724.             ]);
  726.         $NewValue = $request->request->get('NewValue');
  728.         if ('setPhysAddr3' == $field) {
  729.             if ('Manawatu-Wanganui' == $NewValue) {
  730.                 $NewValue = 'Manawatu-Whanganui';
  731.             }
  732.         }
  734.         $Property->$field($NewValue);
  735.         $entityManager->persist($Property);
  736.         $entityManager->flush();
  738.         return new Response('success');
  739.     }
  741.     public function updateAccommField(Request $request)
  742.     {
  743.         $entityManager = $this->getDoctrine()->getManager();
  745.         $accomm_id = $request->request->get('accomm_id');
  746.         $field = $request->request->get('field');
  748.         $user_id = $this->getUser()->getId();
  749.         $Accomm = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  750.                 'id' => $accomm_id,
  751.                 'LandownerId' => $user_id,
  752.             ]);
  754.         $NewValue = $request->request->get('NewValue');
  756.         if ('setEnabled' === $field && '1' === $NewValue) {
  757.             return new Response('You do not have permission to change this. Please contact OTBT support for help.', 403);
  758.         }
  760.         $Accomm->$field($NewValue);
  761.         $entityManager->persist($Accomm);
  762.         $entityManager->flush();
  764.         return new Response('success');
  765.     }
  767.     public function editNewListing($listing_code, $mode, Request $request)
  768.     {
  769.         $user_id = $this->getUser()->getId();
  770.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  771.                 'ListingCode' => $listing_code,
  772.                 'LandownerId' => $user_id,
  773.             ]);
  775.         return $this->render('listing/newlisting.html.twig', [
  776.             'mode' => $mode,
  777.             'listing' => $Property,
  778.         ]);
  779.     }
  781.     public function newListingPart2($property_code, $mode, Request $request)
  782.     {
  783.         $user_id = $this->getUser()->getId();
  784.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  785.                 'ListingCode' => $property_code,
  786.                 'LandownerId' => $user_id,
  787.         ]);
  789.         return $this->render('listing/listingpart2.html.twig', [
  790.             'listing' => $Property,
  791.         ]);
  792.     }
  794.     public function newAccommType($listing_code, Request $request)
  795.     {
  796.         $entityManager = $this->getDoctrine()->getManager();
  798.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  799.             'ListingCode' => $listing_code,
  800.         ]);
  802.         $ExistingAccomms = $this->getDoctrine()->getRepository(AccommodationType::class)->findBy([
  803.             'PropertyCode' => $Property->getListingCode(),
  804.         ]);
  806.         foreach ($ExistingAccomms as $thisAccomm) {
  807.             if ('New Accommodation Type' == $thisAccomm->getRoomName()) {
  808.                 return $this->redirectToRoute('newroom_edit', ['room_code' => $thisAccomm->getRoomCode()]);
  809.             }
  810.         }
  812.         $AccommType = new AccommodationType();
  813.         $AccommType->setEnabled(0);
  814.         $NewRoomCode = substr(str_shuffle('ABCDEFGHIJKLMNPQRSTUVWXYZ1234567890'), 0, 9);
  816.         $AccommType->setPropertyCode($listing_code);
  817.         $AccommType->setProperty($Property);
  818.         $AccommType->setRoomCode($NewRoomCode);
  819.         $AccommType->setRoomName('New Accommodation Type');
  820.         $AccommType->setRoomSlug('room-'.$NewRoomCode);
  821.         $AccommType->setSearchHeadline('Display Name of Listing');
  822.         $AccommType->setRoomSlugNew('room-'.$NewRoomCode);
  823.         $AccommType->setMinimumNights(1);
  824.         $AccommType->setNightlyQnt(1);
  825.         $AccommType->setPriceMode('pn');
  827.         $user_id = $this->getUser()->getId();
  828.         $AccommType->setLandownerId($user_id);
  830.         $entityManager->persist($AccommType);
  831.         $entityManager->flush();
  833.         return $this->redirectToRoute('newroom_edit', ['room_code' => $NewRoomCode]);
  834.     }
  836.     public function editNewAccommType($room_code, $mode, Request $request)
  837.     {
  838.         $user_id = $this->getUser()->getId();
  840.         $AccommType = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  841.             'RoomCode' => $room_code,
  842.             'LandownerId' => $user_id,
  843.         ]);
  845.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  846.             'ListingCode' => $AccommType->getPropertyCode(),
  847.         ]);
  849.         $listing_code = $Property->getListingCode();
  851.         $entityManager = $this->getDoctrine()->getManager();
  853.         $RoomAmenities = $entityManager->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  854.            ->where('t.TagType = :tag_type')
  855.            ->setParameter('tag_type', 'amenity')
  856.            ->orderBy('t.TagName', 'ASC')
  857.            ->getQuery()
  858.            ->getResult();
  860.         $EatingDrinking = $entityManager->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  861.            ->where('t.TagType = :tag_type')
  862.            ->setParameter('tag_type', 'eating_drinking')
  863.            ->orderBy('t.TagName', 'ASC')
  864.            ->getQuery()
  865.            ->getResult();
  867.         $AccommTypeTags = $entityManager->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  868.            ->where('t.TagType = :tag_type')
  869.            ->setParameter('tag_type', 'accomm_type')
  870.            ->orderBy('t.TagName', 'ASC')
  871.            ->getQuery()
  872.            ->getResult();
  874.         $EssentialStayInfo = $entityManager->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  875.            ->where('t.TagType = :tag_type')
  876.            ->setParameter('tag_type', 'stay_info')
  877.            ->orderBy('t.TagName', 'ASC')
  878.            ->getQuery()
  879.            ->getResult();
  881.         $UniqueThings = $entityManager->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  882.            ->where('t.TagType = :tag_type')
  883.            ->setParameter('tag_type', 'unique_things')
  884.            ->orderBy('t.TagName', 'ASC')
  885.            ->getQuery()
  886.            ->getResult();
  888.         $Activities = $entityManager->getRepository("App\Entity\PropertyTags")->createQueryBuilder('t')
  889.            ->where('t.TagType = :tag_type')
  890.            ->setParameter('tag_type', 'activities')
  891.            ->orderBy('t.TagName', 'ASC')
  892.            ->getQuery()
  893.            ->getResult();
  895.         $RegionList = $this->getDoctrine()->getRepository(Regions::class)->findAll();
  897.         $GetSelectedTags = $this->getDoctrine()->getRepository(PropertyTagsApplied::class)->findBy([
  898.                 'Room' => $AccommType,
  899.         ]);
  901.         $SelectedTags = [];
  902.         foreach ($GetSelectedTags as $ThisTag) {
  903.             $SelectedTags[$ThisTag->getTag()->getId()] = $ThisTag->getTag()->getId();
  904.         }
  906.         $SyncList = $this->getDoctrine()->getRepository(TrackedCalendars::class)->findBy([
  907.             'RoomCode' => $AccommType->getRoomCode(),
  908.         ]);
  910.         return $this->render('listing/newaccomm.html.twig', [
  911.             'listing' => $Property,
  912.             'room' => $AccommType,
  913.             'room_amenities' => $RoomAmenities,
  914.             'selected_tags' => $SelectedTags,
  915.             'eating_drinking' => $EatingDrinking,
  916.             'accomm_type' => $AccommTypeTags,
  917.             'essential_stay' => $EssentialStayInfo,
  918.             'unique_things' => $UniqueThings,
  919.             'activities' => $Activities,
  920.             'regions' => $RegionList,
  921.             'synclist' => $SyncList,
  922.         ]);
  923.     }
  925.     public function setRegion($room_id, $region_id)
  926.     {
  927.         $Room = $this->getDoctrine()->getRepository(AccommodationType::class)->find($room_id);
  928.         $Region = $this->getDoctrine()->getRepository(Regions::class)->find($region_id);
  930.         $Room->setRegion($Region);
  932.         $entityManager = $this->getDoctrine()->getManager();
  933.         $entityManager->persist($Room);
  934.         $entityManager->flush();
  936.         return new Response('success');
  937.     }
  939.     public function newAddon($listing_code, Request $request)
  940.     {
  941.         $Addon = new Addons();
  943.         $Addon->setPropertyCode($listing_code);
  944.         $Addon->setPriceMode('A');
  945.         $Addon->setEnabled(true);
  947.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  948.             'ListingCode' => $listing_code,
  949.         ]);
  951.         $form = $this->createFormBuilder($Addon)
  952.             ->add('Title', TextType::class)
  953.             ->add('Description', TextareaType::class)
  954.             ->add('PriceMode', ChoiceType::class, [
  955.                 'choices' => [
  956.                     'One Off / Per Person' => 'A',
  957.                     'Daily / Per Person' => 'B',
  958.                     'Daily / Per Trip (flat rate)' => 'C',
  959.                     'One Off / Per Trip (flat rate)' => 'D',
  960.                 ],
  961.             ])
  962.             ->add('PricePer', MoneyType::class)
  963.             ->add('PerName', TextType::class)
  964.             ->add('MaxPeople', NumberType::class)
  965.             ->add('save', SubmitType::class, ['label' => 'Save'])
  966.             ->getForm();
  968.         $form->handleRequest($request);
  970.         if ($form->isSubmitted() && $form->isValid()) {
  971.             // $form->getData() holds the submitted values
  972.             // but, the original `$task` variable has also been updated
  973.             $Addon = $form->getData();
  975.             // ... perform some action, such as saving the Property to the database
  976.             // for example, if Property is a Doctrine entity, save it!
  977.             $entityManager = $this->getDoctrine()->getManager();
  978.             $entityManager->persist($Addon);
  979.             $entityManager->flush();
  981.             $email = new \SendGrid\Mail\Mail();
  982.             $email->setFrom('support@otbt.co.nz', 'OTBT System');
  983.             $email->addTo('info@otbt.co.nz');
  984.             $email->setSubject('New Addon Created - Property: '.$Property->getPropertyTitle());
  985.             $email->addContent(
  986.                 'text/html',
  987.                 'Hi Admin, <br><br>A new addon has been added to '.$Property->getPropertyTitle().'. The new data is as follows:<br><br><pre>'.print_r($Addon, true).'</pre><br>  <br><br>Thanks, <br>OTBT System'
  988.             );
  990.             $sendgrid = new \App\Classes\SendGrid();
  991.             try {
  992.                 $response = $sendgrid->send($email);
  993.             } catch (Exception $e) {
  994.                 echo 'Caught exception: ',  $e->getMessage(), "\n";
  995.             }
  997.             return $this->redirectToRoute('new_listing_overview', ['property_id' => $Property->getId()]);
  998.         }
  1000.         return $this->render('listing/addon.html.twig', [
  1001.             'newaddon' => $form->createView(),
  1002.         ]);
  1003.     }
  1005.     public function editAddon($addon_id, Request $request)
  1006.     {
  1007.         $Addon = $this->getDoctrine()->getRepository(Addons::class)->find($addon_id);
  1009.         $AddonCurrently = print_r($Addon, true);
  1011.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  1012.             'ListingCode' => $Addon->getPropertyCode(),
  1013.         ]);
  1015.         $form = $this->createFormBuilder($Addon)
  1016.             ->add('Title', TextType::class)
  1017.             ->add('Description', TextareaType::class)
  1018.             ->add('PriceMode', ChoiceType::class, [
  1019.                 'choices' => [
  1020.                     'One Off / Per Person' => 'A',
  1021.                     'Daily / Per Person' => 'B',
  1022.                     'Daily / Per Trip (flat rate)' => 'C',
  1023.                     'One Off / Per Trip (flat rate)' => 'D',
  1024.                 ],
  1025.             ])
  1026.             ->add('PricePer', TextType::class)
  1027.             ->add('PerName', TextType::class)
  1028.             ->add('MaxPeople', TextType::class)
  1029.             ->add('save', SubmitType::class, ['label' => 'Save'])
  1030.             ->getForm();
  1032.         $form->handleRequest($request);
  1034.         if ($form->isSubmitted() && $form->isValid()) {
  1035.             // $form->getData() holds the submitted values
  1036.             // but, the original `$task` variable has also been updated
  1037.             $Addon = $form->getData();
  1039.             // ... perform some action, such as saving the Property to the database
  1040.             // for example, if Property is a Doctrine entity, save it!
  1041.             $entityManager = $this->getDoctrine()->getManager();
  1042.             $entityManager->persist($Addon);
  1043.             $entityManager->flush();
  1045.             $email = new \SendGrid\Mail\Mail();
  1046.             $email->setFrom('support@otbt.co.nz', 'OTBT System');
  1047.             $email->addTo('info@otbt.co.nz');
  1048.             $email->setSubject('Addon has been Edited: '.$Addon->getTitle());
  1049.             $email->addContent(
  1050.                 'text/html',
  1051.                 'Hi Admin, <br><br>An addon: '.$Addon->getTitle().' at '.$Property->getPropertyTitle()." has been edited. The new data is as follows:<br><br><table border='1'><tr><td>The data was:<br><br><pre>".$AddonCurrently.'</pre></td><td>The new data is as follows:<br><br><pre>'.print_r($Addon, true).'</pre></td></tr></table><pre>'.print_r($Addon, true).'</pre><br>  <br><br>Thanks, <br>OTBT System'
  1052.             );
  1054.             $sendgrid = new \App\Classes\SendGrid();
  1055.             try {
  1056.                 $response = $sendgrid->send($email);
  1057.             } catch (Exception $e) {
  1058.                 echo 'Caught exception: ',  $e->getMessage(), "\n";
  1059.             }
  1061.             if ('Draft' == $Property->getListingStatus()) {
  1062.                 return $this->redirectToRoute('new_listing_overview', ['property_id' => $Property->getId()]);
  1063.             } else {
  1064.                 return $this->redirectToRoute('edit_listing', ['listing_code' => $Property->getListingCode()]);
  1065.             }
  1066.         }
  1068.         return $this->render('listing/addon.html.twig', [
  1069.             'newaddon' => $form->createView(),
  1070.         ]);
  1071.     }
  1073.     public function listingQuestion(Request $request)
  1074.     {
  1075.         $person_name = $request->request->get('person_name');
  1076.         $person_email = $request->request->get('person_email');
  1077.         $question = $request->request->get('question');
  1078.         $room_name = $request->request->get('room_name');
  1080.         $email = new \SendGrid\Mail\Mail();
  1081.         $email->setFrom('support@otbt.co.nz', 'OTBT System');
  1082.         $email->addTo('info@otbt.co.nz');
  1083.         $email->addTo('support@otbt.co.nz');
  1084.         $email->setTemplateId('d-fb55f6c29f294cae97c063f9f97dd95e'); // UPDATED SG TEMPLATE 20224
  1086.         $email->addDynamicTemplateDatas([
  1087.             'person_name' => $person_name,
  1088.             'person_email' => $person_email,
  1089.             'question' => $question,
  1090.             'room_name' => $room_name,
  1091.         ]);
  1093.         $sendgrid = new \App\Classes\SendGrid();
  1094.         try {
  1095.             $response = $sendgrid->send($email);
  1096.         } catch (Exception $e) {
  1097.             echo 'Caught exception: ',  $e->getMessage(), "\n";
  1098.         }
  1100.         return new Response('success');
  1101.     }
  1103.     public function landownerQAreply(ListingQuestions $qa, Request $request, UrlGeneratorInterface $router)
  1104.     {
  1105.         $entityManager = $this->getDoctrine()->getManager();
  1106.         $Room = $qa->getRoom();
  1107.         $Landowner = $this->getDoctrine()->getRepository(User::class)->find($Room->getLandownerId());
  1109.         if ($Landowner->getId() !== $this->getUser()->getId()) {
  1110.             return new Response('unauthorized');
  1111.         } else {
  1112.             $form = $this->createFormBuilder($qa)
  1113.             ->add('Answer', TextareaType::class)
  1114.             ->add('save', SubmitType::class, ['label' => 'Submit Answer'])
  1115.             ->getForm();
  1117.             $form->handleRequest($request);
  1119.             if ($form->isSubmitted() && $form->isValid()) {
  1120.                 // $form->getData() holds the submitted values
  1121.                 // but, the original `$task` variable has also been updated
  1122.                 $qa = $form->getData();
  1123.                 $qa->setAnsweredDate(new \DateTime());
  1124.                 $qa->setAnsweredBy($this->getUser());
  1126.                 $ModerateURL = 'https://'.$_SERVER['SERVER_NAME'].$router->generate('admin_listingquestions_moderate', ['id' => $qa->getId()]);
  1128.                 $entityManager->persist($qa);
  1129.                 $entityManager->flush();
  1131.                 $email = new \SendGrid\Mail\Mail();
  1132.                 $email->setFrom('support@otbt.co.nz', 'OTBT System');
  1133.                 $email->addTo('info@otbt.co.nz');
  1134.                 // $email->addTo("partner.otbt@luminate.one");
  1135.                 $email->setSubject('New QA to be moderated');
  1136.                 $email->addContent(
  1137.                     'text/html',
  1138.                     "Hi team, <br>a new question has been answered by a landowner. <a href='".$ModerateURL."'>Please moderate now</a> so the answer can be released to the asker."
  1139.                 );
  1141.                 $sendgrid = new \App\Classes\SendGrid();
  1142.                 try {
  1143.                     $response = $sendgrid->send($email);
  1144.                 } catch (Exception $e) {
  1145.                     echo 'Caught exception: ',  $e->getMessage(), "\n";
  1146.                 }
  1148.                 return $this->render('listing/landownerQAreplyDONE.html.twig', [
  1149.                     'qa' => $qa,
  1150.                 ]);
  1151.             } else {
  1152.                 return $this->render('listing/landownerQAreply.html.twig', [
  1153.                     'form' => $form->createView(),
  1154.                     'qa' => $qa,
  1155.                 ]);
  1156.             }
  1157.         }
  1158.     }
  1160.     public function reviewNewListing($listing_code)
  1161.     {
  1162.         $user_id = $this->getUser()->getId();
  1164.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  1165.             'ListingCode' => $listing_code,
  1166.             'LandownerId' => $user_id,
  1167.         ]);
  1169.         $AccommType = $this->getDoctrine()->getRepository(AccommodationType::class)->findOneBy([
  1170.             'PropertyCode' => $listing_code,
  1171.             'LandownerId' => $user_id,
  1172.         ]);
  1174.         $AllTags = $this->getDoctrine()->getRepository(PropertyTags::class)->findAll();
  1175.         $GetAllTags = [];
  1176.         foreach ($AllTags as $ThisTag) {
  1177.             $GetAllTags[$ThisTag->getId()] = $ThisTag;
  1178.         }
  1179.         $GetSelectedTags = $this->getDoctrine()->getRepository(PropertyTagsApplied::class)->findBy([
  1180.                 'Room' => $AccommType,
  1181.         ]);
  1182.         $SelectedTags = [];
  1183.         foreach ($GetSelectedTags as $ThisTag) {
  1184.             $SelectedTags[] = $GetAllTags[$ThisTag->getTag()->getId()];
  1185.         }
  1187.         return $this->render('listing/reviewlisting.html.twig', [
  1188.             'property' => $Property,
  1189.             'accomm' => $AccommType,
  1190.             'listing_code' => $listing_code,
  1191.             'room_code' => $AccommType->getRoomCode(),
  1192.             'selected_tags' => $SelectedTags,
  1193.             'mode' => 'review',
  1194.         ]);
  1195.     }
  1197.     public function editListingNew($listing_code)
  1198.     {
  1199.         $user_id = $this->getUser()->getId();
  1201.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  1202.             'ListingCode' => $listing_code,
  1203.             'LandownerId' => $user_id,
  1204.         ]);
  1206.         if ('New' == $Property->getListingStatus()) {
  1207.             return $this->redirectToRoute('new_listing_overview', ['property_id' => $Property->getId()]);
  1208.         }
  1210.         $AccommTypes = $this->getDoctrine()->getRepository(AccommodationType::class)->findBy([
  1211.             'PropertyCode' => $listing_code,
  1212.             'LandownerId' => $user_id,
  1213.         ]);
  1215.         $Addons = $this->getDoctrine()->getRepository(Addons::class)->findBy([
  1216.             'PropertyCode' => $listing_code,
  1217.                 'Enabled' => true,
  1218.         ]);
  1220.         return $this->render('listing/reviewlisting.html.twig', [
  1221.             'property' => $Property,
  1222.             'listing_code' => $listing_code,
  1223.             'mode' => 'edit',
  1224.             'accomm_types' => $AccommTypes,
  1225.             'addons' => $Addons,
  1226.         ]);
  1227.     }
  1229.     public function submitNewListing($listing_code)
  1230.     {
  1231.         $user_id = $this->getUser()->getId();
  1233.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy([
  1234.             'ListingCode' => $listing_code,
  1235.             'LandownerId' => $user_id,
  1236.         ]);
  1238.         $UserInfo = $this->getDoctrine()->getRepository(User::class)->find($user_id);
  1240.         $Property->setListingStatus('Awaiting Review');
  1242.         $entityManager = $this->getDoctrine()->getManager();
  1243.         $entityManager->persist($Property);
  1244.         $entityManager->flush();
  1246.         $email = new \SendGrid\Mail\Mail();
  1247.         $email->setFrom('support@otbt.co.nz', 'OTBT System');
  1248.         $email->addTo($UserInfo->getEmail());
  1249.         $email->setTemplateId('d-a89cf56c0e214ca0bd825836128c26cd'); // UPDATE SG TEMPLATE 2024
  1251.         $sendgrid = new \App\Classes\SendGrid();
  1252.         try {
  1253.             $response = $sendgrid->send($email);
  1254.         } catch (Exception $e) {
  1255.             echo 'Caught exception: ',  $e->getMessage(), "\n";
  1256.         }
  1258.         $email = new \SendGrid\Mail\Mail();
  1259.         $email->setFrom('support@otbt.co.nz', 'OTBT System');
  1260.         $email->addTo('info@otbt.co.nz');
  1261.         $email->setSubject('New Property Submitted for Review');
  1262.         $email->addContent(
  1263.             'text/html',
  1264.             'Hi Admin, <br>A new property has been submitted for review - '.$Property->getPropertyTitle().'. It is available to look at in the Properties section of the admin panel.<br><br>Thanks, <br>OTBT System'
  1265.         );
  1267.         $sendgrid = new \App\Classes\SendGrid();
  1268.         try {
  1269.             $response = $sendgrid->send($email);
  1270.         } catch (Exception $e) {
  1271.             echo 'Caught exception: ',  $e->getMessage(), "\n";
  1272.         }
  1274.         $GetAccommTypes = $this->getDoctrine()->getRepository(AccommodationType::class)->findBy(['PropertyCode' => $Property->getListingCode()]);
  1275.         foreach ($GetAccommTypes as $thisAccomm) {
  1276.             if ('New Accommodation Type' == $thisAccomm->getRoomName() && 0 == $thisAccomm->getEnabled() && null == $thisAccomm->getRoomDescription() && null == $thisAccomm->getNormalPrice() && null == $thisAccomm->getBeddingConfiguration() && null == $thisAccomm->getEatingDrinking()) {
  1277.                 $entityManager->remove($thisAccomm);
  1278.             }
  1279.         }
  1280.         $entityManager->flush();
  1282.         return $this->render('listing/submitreview.html.twig', [
  1283.             'listing_code' => $listing_code,
  1284.         ]);
  1285.     }
  1287.     public function deletePhoto($photo_id)
  1288.     {
  1289.         $Media = $this->getDoctrine()->getRepository(Media::class)->find($photo_id);
  1291.         $entityManager = $this->getDoctrine()->getManager();
  1292.         $entityManager->remove($Media);
  1293.         $entityManager->flush();
  1295.         return new Response('success');
  1296.     }
  1298.     public function applyTag($room_id, $tag_id)
  1299.     {
  1300.         $GetTag = $this->getDoctrine()->getRepository(PropertyTags::class)->find($tag_id);
  1301.         $Room = $this->getDoctrine()->getRepository(AccommodationType::class)->find($room_id);
  1303.         $entityManager = $this->getDoctrine()->getManager();
  1305.         $TagApplied = new PropertyTagsApplied();
  1306.         $TagApplied->setRoom($Room);
  1307.         $TagApplied->setTag($GetTag);
  1308.         $entityManager->persist($TagApplied);
  1310.         $entityManager->flush();
  1312.         return new Response('success');
  1313.     }
  1315.     public function removeTag($room_id, $tag_id)
  1316.     {
  1317.         $Room = $this->getDoctrine()->getRepository(AccommodationType::class)->find($room_id);
  1318.         $Tag = $this->getDoctrine()->getRepository(PropertyTags::class)->find($tag_id);
  1320.         $entityManager = $this->getDoctrine()->getManager();
  1322.         $TagApplied = $this->getDoctrine()->getRepository(PropertyTagsApplied::class)->findOneBy(['Room' => $Room, 'Tag' => $Tag]);
  1324.         $entityManager = $this->getDoctrine()->getManager();
  1325.         $entityManager->remove($TagApplied);
  1327.         $entityManager->flush();
  1329.         return new Response('success');
  1330.     }
  1332.     public function updateProfilePicture(Request $request, GlobalFunctions $GlobalFn, MessageBusInterface $messageBus)
  1333.     {
  1334.         @$Mode = $_GET['mode'];
  1335.         if (!isset($Mode)) {
  1336.             $Mode = 'edit';
  1337.         }
  1339.         @$PropertyId = $_GET['property_id'];
  1340.         if (!isset($PropertyId)) {
  1341.             $PropertyId = null;
  1342.         }
  1344.         $user_id = $this->getUser()->getId();
  1345.         $Media = $this->getDoctrine()->getRepository(Media::class)->findOneBy(['UserId' => $user_id]);
  1347.         $ProfilePicture = $GlobalFn->user_photo($user_id);
  1349.         if (!$Media) {
  1350.             $Media = new Media();
  1351.             $Media->setUserId($user_id);
  1352.         }
  1354.         $entityManager = $this->getDoctrine()->getManager();
  1356.         $form = $this->createFormBuilder($Media)
  1357.             ->add('documentFile', VichImageType::class, ['allow_delete' => true, 'download_link' => false])
  1358.             ->add('save', SubmitType::class, ['label' => 'Upload'])
  1359.             ->getForm();
  1361.         $form->handleRequest($request);
  1363.         if ($form->isSubmitted() && $form->isValid()) {
  1364.             // $form->getData() holds the submitted values
  1365.             // but, the original `$task` variable has also been updated
  1366.             $Media = $form->getData();
  1368.             $entityManager->persist($Media);
  1369.             $entityManager->flush();
  1371.             $ProfilePicture = $GlobalFn->user_photo($user_id);
  1372.             $messageBus->dispatch(new WarmupCache($ProfilePicture));
  1374.             return $this->redirectToRoute('profile_picture');
  1375.         }
  1377.         return $this->render('listing/updateprofilepic.html.twig', [
  1378.             'form' => $form->createView(),
  1379.             'user' => $this->getUser(),
  1380.             'profile_picture' => $ProfilePicture,
  1381.             'updatemessage' => 0,
  1382.             'mode' => $Mode,
  1383.             'property_id' => $PropertyId,
  1384.         ]);
  1385.     }
  1387.     public function landownerPriceAdjustment($accomm_id, Request $request)
  1388.     {
  1389.         $entityManager = $this->getDoctrine()->getManager();
  1391.         $Accomm = $this->getDoctrine()->getRepository(AccommodationType::class)->find($accomm_id);
  1392.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy(['ListingCode' => $Accomm->getPropertyCode()]);
  1393.         if ($Accomm->getLandownerId() !== $this->getUser()->getId()) {
  1394.             return new Exception('You do not have permission to access this');
  1395.         } else {
  1396.             $AccommPricing = $this->getDoctrine()->getRepository(PricingNights::class)->findBy(['RoomCode' => $Accomm->getRoomCode()]);
  1398.             $StayPricing = $this->getDoctrine()->getRepository(PricingStay::class)->findBy(['RoomCode' => $Accomm->getRoomCode()]);
  1400.             $accommForm = $this->createFormBuilder($Accomm)
  1401.                 ->add('NightlyQnt', ChoiceType::class, [
  1402.                 'required' => true,
  1403.                 'choices' => [
  1404.                     1 => 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
  1405.                 ],
  1406.                 ])
  1407.                 ->add('NormalPrice', MoneyType::class, ['required' => true, 'currency' => 'NZD'])
  1408.                 ->add('MaxGuests', ChoiceType::class, [
  1409.                     'required' => true,
  1410.                     'choices' => [
  1411.                         1 => 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
  1412.                     ],
  1413.                 ])
  1414.                 ->add('MaxAdditionalGuests', ChoiceType::class, [
  1415.                     'required' => true,
  1416.                     'choices' => [
  1417.                         'No additional guests' => 0, 1 => 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15,
  1418.                     ],
  1419.                 ])
  1420.                 ->add('AdditionalGuestPrice', MoneyType::class, ['required' => false, 'currency' => 'NZD'])
  1421.                 ->add('PriceMode', ChoiceType::class, [
  1422.                     'required' => true,
  1423.                     'choices' => [
  1424.                         'Per Night' => 'pn',
  1425.                         'Per Person Per Night' => 'pppn',
  1426.                     ],
  1427.                     'expanded' => false,
  1428.                     'multiple' => false,
  1429.                 ])
  1430.                 ->add('MinimumNights', ChoiceType::class, [
  1431.                     'required' => true,
  1432.                     'choices' => [
  1433.                         'Minimum 1 night' => 1, 2 => 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
  1434.                     ],
  1435.                 ])
  1436.                 ->add('save', SubmitType::class, ['label' => 'Update'])
  1437.                 ->getForm();
  1439.             $accommForm->handleRequest($request);
  1441.             if ($accommForm->isSubmitted() && $accommForm->isValid()) {
  1442.                 // $accommForm->getData() holds the submitted values
  1443.                 // but, the original `$task` variable has also been updated
  1444.                 $Accomm = $accommForm->getData();
  1445.                 $Accomm->setRoomCode($Accomm->getRoomCode());
  1447.                 $entityManager->persist($Accomm);
  1448.                 $entityManager->flush();
  1450.                 return $this->redirectToRoute('landowner_price_adjustments', ['accomm_id' => $accomm_id]);
  1451.             }
  1453.             $MinimumNightAdjustments = $this->getDoctrine()->getRepository(MinimumNightOverride::class)->findBy(['Room' => $Accomm]);
  1455.             return $this->render('listing/landownerpriceadjustments.html.twig', [
  1456.                 'accomm_form' => $accommForm->createView(),
  1457.                 'pricing' => $AccommPricing,
  1458.                 'accomm' => $Accomm,
  1459.                 'property' => $Property,
  1460.                 'staypricing' => $StayPricing,
  1461.                 'minimum_night_adjustments' => $MinimumNightAdjustments,
  1462.             ]);
  1463.         }
  1464.     }
  1466.     public function newMinimumNightAdjustment(AccommodationType $room, Request $request)
  1467.     {
  1468.         $newadj_fromdate = $request->request->get('date_from');
  1469.         $newadj_todate = $request->request->get('date_to');
  1470.         $newadj_selectedweek = $request->request->get('selecteddow');
  1471.         $newadj_minnights = (int) $request->request->get('setminimumnight');
  1473.         if ('' == $newadj_fromdate) {
  1474.             $newadj_fromdate = null;
  1475.         } else {
  1476.             $newadj_fromdate = new \DateTime($newadj_fromdate);
  1477.             $newadj_todate = new \DateTime($newadj_todate);
  1478.         }
  1480.         if ('-' == $newadj_selectedweek) {
  1481.             $newadj_selectedweek = null;
  1482.         }
  1484.         $MinNightOverride = new MinimumNightOverride();
  1485.         $MinNightOverride->setRoom($room);
  1486.         if (!empty($newadj_fromdate)) {
  1487.             $MinNightOverride->setAppliesFromDate($newadj_fromdate);
  1488.             $MinNightOverride->setAppliesToDate($newadj_todate);
  1489.         }
  1490.         $MinNightOverride->setDayOfWeek($newadj_selectedweek);
  1491.         $MinNightOverride->setSetMinimumNights($newadj_minnights);
  1493.         $entityManager = $this->getDoctrine()->getManager();
  1494.         $entityManager->persist($MinNightOverride);
  1495.         $entityManager->flush();
  1497.         return new Response('success');
  1498.     }
  1500.     public function deleteMinNightAdjustment(Request $request)
  1501.     {
  1502.         $adj = $this->getDoctrine()->getRepository(MinimumNightOverride::class)->find($request->request->get('adj_id'));
  1504.         $entityManager = $this->getDoctrine()->getManager();
  1505.         $entityManager->remove($adj);
  1506.         $entityManager->flush();
  1508.         return new Response('success');
  1509.     }
  1511.     public function landownerPriceAdjustmentAdd($accomm_id, Request $request)
  1512.     {
  1513.         $entityManager = $this->getDoctrine()->getManager();
  1515.         $Accomm = $this->getDoctrine()->getRepository(AccommodationType::class)->find($accomm_id);
  1516.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy(['ListingCode' => $Accomm->getPropertyCode()]);
  1517.         if ($Accomm->getLandownerId() !== $this->getUser()->getId()) {
  1518.             return new Exception('You do not have permission to access this');
  1519.         } else {
  1520.             $AccommPricing = $this->getDoctrine()->getRepository(PricingNights::class)->findBy(['RoomCode' => $Accomm->getRoomCode()]);
  1522.             $NewPricing = new PricingNights();
  1523.             $NewPricing->setDaysOfWeek('[Mon][Tue][Wed][Thu][Fri][Sat][Sun]');
  1525.             $form = $this->createFormBuilder($NewPricing)
  1526.                 ->add('DateFrom', DateType::class, ['required' => true])
  1527.                 ->add('DateTo', DateType::class, ['required' => true])
  1528.                 ->add('DaysOfWeek', HiddenType::class, ['required' => true])
  1529.                 ->add('Adjustment', TextType::class, ['required' => true])
  1530.                 ->add('Description', TextType::class, ['required' => true])
  1531.                 ->add('save', SubmitType::class, ['label' => 'Add New'])
  1532.                 ->getForm();
  1534.             $form->handleRequest($request);
  1536.             if ($form->isSubmitted() && $form->isValid()) {
  1537.                 // $form->getData() holds the submitted values
  1538.                 // but, the original `$task` variable has also been updated
  1539.                 $NewPricing = $form->getData();
  1540.                 $NewPricing->setRoomCode($Accomm->getRoomCode());
  1542.                 $entityManager->persist($NewPricing);
  1543.                 $entityManager->flush();
  1545.                 return $this->redirectToRoute('landowner_price_adjustments', ['accomm_id' => $accomm_id]);
  1546.             }
  1548.             return $this->render('listing/landownerpriceadjustmentsadd.html.twig', [
  1549.                 'form' => $form->createView(),
  1550.                 'pricing' => $AccommPricing,
  1551.                 'accomm' => $Accomm,
  1552.                 'property' => $Property,
  1553.             ]);
  1554.         }
  1555.     }
  1557.     public function stayPricingAdd($accomm_id, Request $request)
  1558.     {
  1559.         $entityManager = $this->getDoctrine()->getManager();
  1561.         $Accomm = $this->getDoctrine()->getRepository(AccommodationType::class)->find($accomm_id);
  1562.         $Property = $this->getDoctrine()->getRepository(Property::class)->findOneBy(['ListingCode' => $Accomm->getPropertyCode()]);
  1563.         if ($Accomm->getLandownerId() !== $this->getUser()->getId()) {
  1564.             return new Exception('You do not have permission to access this');
  1565.         } else {
  1566.             $NewPricing = new PricingStay();
  1568.             $form = $this->createFormBuilder($NewPricing)
  1569.                 ->add('DateFrom', DateType::class, ['required' => true])
  1570.                 ->add('DateTo', DateType::class, ['required' => true])
  1571.                 ->add('MinNights', TextType::class, ['required' => true])
  1572.                 ->add('Adjustment', TextType::class, ['required' => false])
  1573.                 ->add('PercentageAdjustment', TextType::class, ['required' => false])
  1574.                 ->add('LineDescription', TextType::class, ['required' => true])
  1575.                 ->add('save', SubmitType::class, ['label' => 'Add New'])
  1576.                 ->getForm();
  1578.             $form->handleRequest($request);
  1580.             if ($form->isSubmitted() && $form->isValid()) {
  1581.                 // $form->getData() holds the submitted values
  1582.                 // but, the original `$task` variable has also been updated
  1583.                 $NewPricing = $form->getData();
  1584.                 $NewPricing->setRoomCode($Accomm->getRoomCode());
  1586.                 $entityManager->persist($NewPricing);
  1587.                 $entityManager->flush();
  1589.                 return $this->redirectToRoute('landowner_price_adjustments', ['accomm_id' => $accomm_id]);
  1590.             }
  1592.             return $this->render('listing/staypricingadd.html.twig', [
  1593.                 'form' => $form->createView(),
  1594.                 'accomm' => $Accomm,
  1595.                 'property' => $Property,
  1596.             ]);
  1597.         }
  1598.     }
  1600.     public function landownerPriceAdjustmentDelete($accomm_id, $adj_id)
  1601.     {
  1602.         $entityManager = $this->getDoctrine()->getManager();
  1604.         $Accomm = $this->getDoctrine()->getRepository(AccommodationType::class)->find($accomm_id);
  1605.         if ($Accomm->getLandownerId() !== $this->getUser()->getId()) {
  1606.             return new Exception('You do not have permission to access this');
  1607.         } else {
  1608.             $AccommPricing = $this->getDoctrine()->getRepository(PricingNights::class)->find($adj_id);
  1610.             $entityManager->remove($AccommPricing);
  1611.             $entityManager->flush();
  1613.             return new Response('success');
  1614.         }
  1615.     }
  1617.     public function priceStayDelete($accomm_id, $price_id)
  1618.     {
  1619.         $entityManager = $this->getDoctrine()->getManager();
  1621.         $Accomm = $this->getDoctrine()->getRepository(AccommodationType::class)->find($accomm_id);
  1622.         if ($Accomm->getLandownerId() !== $this->getUser()->getId()) {
  1623.             return new Exception('You do not have permission to access this');
  1624.         } else {
  1625.             $AccommPricing = $this->getDoctrine()->getRepository(PricingStay::class)->find($price_id);
  1627.             $entityManager->remove($AccommPricing);
  1628.             $entityManager->flush();
  1630.             return new Response('success');
  1631.         }
  1632.     }
  1634.     public function newlistingoverview($property_id, GlobalFunctions $GlobalFn)
  1635.     {
  1636.         $entityManager = $this->getDoctrine()->getManager();
  1638.         $Property = $this->getDoctrine()->getRepository(Property::class)->find($property_id);
  1639.         $Landowner = $this->getDoctrine()->getRepository(User::class)->find($Property->getLandownerId());
  1641.         $ProfilePicture = $GlobalFn->user_photo($this->getUser()->getId());
  1643.         if ($Property) {
  1644.             if ($Property->getLandownerId() == $this->getUser()->getId()) {
  1645.                 $AccommTypes = $this->getDoctrine()->getRepository(AccommodationType::class)->findBy(['PropertyCode' => $Property->getListingCode()]);
  1646.                 $Addons = $this->getDoctrine()->getRepository(Addons::class)->findBy(['PropertyCode' => $Property->getListingCode(), 'Enabled' => 1]);
  1648.                 $TrackedCalendars = [];
  1649.                 foreach ($AccommTypes as $thisAccomm) {
  1650.                     $Calendars = $this->getDoctrine()->getRepository(TrackedCalendars::class)->findBy(['RoomCode' => $thisAccomm->getRoomCode()]);
  1651.                     $TrackedCalendars[$thisAccomm->getRoomCode()] = count($Calendars);
  1652.                 }
  1654.                 $TagsApplied = [];
  1656.                 foreach ($AccommTypes as $thisAccomm) {
  1657.                     $PropertyTags = $this->getDoctrine()->getRepository(PropertyTagsApplied::class)->findBy(['Room' => $thisAccomm]);
  1658.                     $TagsApplied[$thisAccomm->getId()] = count($PropertyTags);
  1659.                 }
  1661.                 return $this->render('listing/newlistingoverview.html.twig', [
  1662.                     'property' => $Property,
  1663.                     'landowner' => $Landowner,
  1664.                     'accomm_types' => $AccommTypes,
  1665.                     'addons' => $Addons,
  1666.                     'profile_picture' => $ProfilePicture,
  1667.                     'tracked_calendars' => $TrackedCalendars,
  1668.                     'tags_applied' => $TagsApplied,
  1669.                 ]);
  1670.             } else {
  1671.                 return new Response('Sorry, you are not authorised to see this item');
  1672.             }
  1673.         } else {
  1674.             return new Response('Sorry, you are not authorised to see this item');
  1675.         }
  1676.     }
  1678.     public function imgjseditor($photo_id)
  1679.     {
  1680.         $entityManager = $this->getDoctrine()->getManager();
  1682.         $Photo = $this->getDoctrine()->getRepository(Media::class)->find($photo_id);
  1684.         $random_number = rand(100000, 999999);
  1686.         return $this->render('listing/imgjseditor.html.twig', [
  1687.             'photo' => $Photo,
  1688.             'random_number' => $random_number,
  1689.         ]);
  1690.     }
  1692.     public function rotate_img($photo_id, $degrees, MessageBusInterface $messageBus)
  1693.     {
  1694.         @ini_set('memory_limit', '256M');
  1696.         $entityManager = $this->getDoctrine()->getManager();
  1698.         $Photo = $this->getDoctrine()->getRepository(Media::class)->find($photo_id);
  1700.         $filepath = '../public/media/'.$Photo->getDocumentFileName();
  1701.         if (IMAGETYPE_JPEG == exif_imagetype($filepath)) {
  1702.             /** @var resource $source */
  1703.             $source = imagecreatefromjpeg($filepath);
  1704.             /** @var resource $rotate */
  1705.             $rotate = imagerotate($source, $degrees, 0);
  1706.             imagejpeg($rotate, $filepath);
  1707.         } elseif (IMAGETYPE_PNG == exif_imagetype($filepath)) {
  1708.             /** @var resource $source */
  1709.             $source = imagecreatefrompng($filepath);
  1710.             /** @var resource $rotate */
  1711.             $rotate = imagerotate($source, $degrees, 0);
  1713.             imagepng($rotate, $filepath);
  1714.         } else {
  1715.             return new Response('error - image type not accepted');
  1716.         }
  1718.         imagedestroy($source);
  1719.         imagedestroy($rotate);
  1721.         if ('1' == substr($Photo->getDocumentFileName(), 0, 1) && '_' == substr($Photo->getDocumentFileName(), 10, 1)) {
  1722.             $ActualFilename = time().'_'.substr($Photo->getDocumentFileName(), 11);
  1723.             $NewFileName = $ActualFilename;
  1724.             rename('../public/media/'.$Photo->getDocumentFileName(), '../public/media/'.$NewFileName);
  1726.             $messageBus->dispatch(new WarmupCache('media/'.$NewFileName));
  1727.         } else {
  1728.             $ActualFilename = time().'_'.$Photo->getDocumentFileName();
  1729.             $NewFileName = $ActualFilename;
  1730.             rename('../public/media/'.$Photo->getDocumentFileName(), '../public/media/'.$NewFileName);
  1731.             $messageBus->dispatch(new WarmupCache('media/'.$NewFileName));
  1732.         }
  1734.         $Photo->setDocumentFileName($ActualFilename);
  1736.         $entityManager->persist($Photo);
  1737.         $entityManager->flush();
  1739.         return new Response('success');
  1740.     }
  1742.     public function reorder_photo($photo_id, $direction)
  1743.     {
  1744.         $entityManager = $this->getDoctrine()->getManager();
  1746.         $Photo = $this->getDoctrine()->getRepository(Media::class)->find($photo_id);
  1748.         $AllPhotos = $this->getDoctrine()->getRepository(Media::class)->findBy(['RoomCode' => $Photo->getRoomCode()], ['DisplayOrder' => 'ASC']);
  1749.         $Order = 1;
  1750.         foreach ($AllPhotos as $ThisPhoto) {
  1751.             if (null === $ThisPhoto->getDisplayOrder()) {
  1752.                 $ThisPhoto->setDisplayOrder($Order);
  1753.                 $entityManager->persist($ThisPhoto);
  1754.             }
  1755.             ++$Order;
  1756.         }
  1758.         $entityManager->flush();
  1760.         if ('up' == $direction) {
  1761.             $DirectionBelow = $Photo->getDisplayOrder() - 1;
  1762.             $PhotoBelow = $this->getDoctrine()->getRepository(Media::class)->findOneBy(['RoomCode' => $Photo->getRoomCode(), 'DisplayOrder' => $DirectionBelow]);
  1764.             $PhotoBelow->setDisplayOrder($Photo->getDisplayOrder());
  1765.             $Photo->setDisplayOrder($DirectionBelow);
  1767.             $entityManager->persist($Photo);
  1768.             $entityManager->persist($PhotoBelow);
  1769.             $entityManager->flush();
  1770.         }
  1772.         if ('down' == $direction) {
  1773.             $DirectionAbove = $Photo->getDisplayOrder() + 1;
  1774.             $PhotoAbove = $this->getDoctrine()->getRepository(Media::class)->findOneBy(['RoomCode' => $Photo->getRoomCode(), 'DisplayOrder' => $DirectionAbove]);
  1776.             $PhotoAbove->setDisplayOrder($Photo->getDisplayOrder());
  1777.             $Photo->setDisplayOrder($DirectionAbove);
  1779.             $entityManager->persist($Photo);
  1780.             $entityManager->persist($PhotoAbove);
  1781.             $entityManager->flush();
  1782.         }
  1784.         return new Response('success');
  1785.     }
  1787.     public function makeDefault($photo_id)
  1788.     {
  1789.         $entityManager = $this->getDoctrine()->getManager();
  1791.         $Photo = $this->getDoctrine()->getRepository(Media::class)->find($photo_id);
  1793.         $AllPhotos = $this->getDoctrine()->getRepository(Media::class)->findBy(['RoomCode' => $Photo->getRoomCode()], ['DisplayOrder' => 'ASC']);
  1794.         foreach ($AllPhotos as $ThisPhoto) {
  1795.             $ThisPhoto->setSearchDefault(null);
  1796.             $ThisPhoto->setDefaultImage(null);
  1797.         }
  1799.         $Photo->setSearchDefault(1);
  1800.         $Photo->setDefaultImage(1);
  1802.         // Get room ID as frontend uses this to display the correct images on search
  1803.         $room = $this->getDoctrine()->getRepository(AccommodationType::class)->findBy(['RoomCode' => $Photo->getRoomCode()])[0];
  1804.         if (null !== $room && $Photo) {
  1805.             $Photo->setAccommType($room);
  1806.         }
  1808.         $entityManager->persist($Photo);
  1810.         $entityManager->flush();
  1812.         return new Response('success');
  1813.     }
  1815.     public function updateUserBio(Request $request)
  1816.     {
  1817.         $new_bio = $request->request->get('new_bio');
  1819.         $entityManager = $this->getDoctrine()->getManager();
  1821.         $User = $this->getUser();
  1822.         $User->setBio($new_bio);
  1824.         $entityManager->persist($User);
  1825.         $entityManager->flush();
  1827.         return new Response('success');
  1828.     }
  1830.     public function updateUserAcc(Request $request)
  1831.     {
  1832.         $new_acc = $request->request->get('new_acc');
  1834.         $entityManager = $this->getDoctrine()->getManager();
  1836.         $User = $this->getUser();
  1837.         $User->setBankAccountNumber($new_acc);
  1839.         $entityManager->persist($User);
  1840.         $entityManager->flush();
  1842.         return new Response('success');
  1843.     }
  1844. }