sunnysideup /
silverstripe-pagerater
| @@ 131-152 (lines=22) @@ | ||
| 128 | * |
|
| 129 | * @return int |
|
| 130 | */ |
|
| 131 | public function NumberOfPageRatings() |
|
| 132 | { |
|
| 133 | $doSet = new ArrayList(); |
|
| 134 | $sqlQuery = new SQLQuery(); |
|
| 135 | $sqlQuery->setSelect("COUNT(\"PageRating\".\"Rating\") RatingCount"); |
|
| 136 | $sqlQuery->setFrom("\"PageRating\" "); |
|
| 137 | if ($this->onlyShowApprovedPageRatings()) { |
|
| 138 | $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID." AND \"PageRating\".\"IsApproved\" = 1"); |
|
| 139 | } else { |
|
| 140 | $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID.""); |
|
| 141 | } |
|
| 142 | $sqlQuery->setOrderBy("RatingCount ASC"); |
|
| 143 | $sqlQuery->setGroupBy("\"ParentID\""); |
|
| 144 | $sqlQuery->setLimit(1); |
|
| 145 | $data = $sqlQuery->execute(); |
|
| 146 | if ($data) { |
|
| 147 | foreach ($data as $record) { |
|
| 148 | return $record["RatingCount"]; |
|
| 149 | } |
|
| 150 | } |
|
| 151 | return 0; |
|
| 152 | } |
|
| 153 | ||
| 154 | ||
| 155 | /** |
|
| @@ 271-292 (lines=22) @@ | ||
| 268 | * |
|
| 269 | * @return int |
|
| 270 | */ |
|
| 271 | public function NumberOfPageRatings() |
|
| 272 | { |
|
| 273 | $doSet = new ArrayList(); |
|
| 274 | $sqlQuery = new SQLQuery(); |
|
| 275 | $sqlQuery->setSelect("COUNT(\"PageRating\".\"Rating\") RatingCount"); |
|
| 276 | $sqlQuery->setFrom("\"PageRating\" "); |
|
| 277 | if ($this->onlyShowApprovedPageRatings()) { |
|
| 278 | $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID." AND \"PageRating\".\"IsApproved\" = 1"); |
|
| 279 | } else { |
|
| 280 | $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID.""); |
|
| 281 | } |
|
| 282 | $sqlQuery->setOrderBy("RatingCount ASC"); |
|
| 283 | $sqlQuery->setGroupBy("\"ParentID\""); |
|
| 284 | $sqlQuery->setLimit(1); |
|
| 285 | $data = $sqlQuery->execute(); |
|
| 286 | if ($data) { |
|
| 287 | foreach ($data as $record) { |
|
| 288 | return $record["RatingCount"]; |
|
| 289 | } |
|
| 290 | } |
|
| 291 | return 0; |
|
| 292 | } |
|
| 293 | ||
| 294 | protected function onlyShowApprovedPageRatings() |
|
| 295 | { |
|
