Example #1
0
 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;
 }
Example #2
0
 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;
 }