public function getTopRatings($minRating, $limit, $withinLastDays = 60) { $ratingList = new Object\TrustedShopReview\Listing(); $reviewChangeDate = time() - 3600 * 24 * $withinLastDays; $ratingList->setCondition("shopConfig__id = ? AND reviewChangeDate > ? AND mark >= ? ", array($this->getShopConfig()->getId(), $reviewChangeDate, $minRating)); if ($limit) { $ratingList->setLimit($limit); } $ratingList->setOrderKey("RAND()", false); return $ratingList; }
protected function getReview(Object\OnlineShopConfiguration $configuration, $uid, $email, $creationDate) { $db = \Pimcore\Resource::get(); $list = new Object\TrustedShopReview\Listing(); $list->setCondition("uid = " . $db->quote($uid)); $list->setLimit(1); $list->setUnpublished(true); $list = $list->load(); if ($list) { $item = $list[0]; } else { $item = new Object\TrustedShopReview(); $item->setPublished(1); } $item->setKey(Pimcore\File::getValidFilename($email . "_" . $uid)); return $item; }