demo_propel.php

demo_propel.php

<?php
$property = PropertyQuery::create()->findByIdWithRelated($request->get('id'));

$medias = $property->getMediasJoinMedia();

$reviews = $property->getReviews(
    ReviewQuery::create()
        ->innerJoinWithAnswer()
        ->useAnswerQuery()
         ->innerJoinWithQuestion()
        ->endUse()
        ->leftJoinWithBooking()
        ->useBookingQuery()
          ->leftJoinWithUser()
        ->endUse()
        ->leftJoinWithExternalReview()
        ->leftJoinWithGuestReview()
        ->filterByIsModerated(true)
);

$information = $property->getInformation(
    PropertyInformationQuery::create()
    ->innerJoinWithInformation()
    ->useInformationQuery()
        ->filterByIsActive(true)
        ->filterByRequiresBooking(false)
        ->orderByRank()
    ->endUse()
    ->filterByContent('', PropertyInformationQuery::NOT_EQUAL)
    ->filterByContent(null, PropertyInformationQuery::ISNOTNULL)
);