View GitHub Repository silverstripe-pagerater

Schedule Inspection
Subscribe

Code Duplication    Length = 5-5 lines in 2 locations

code/extensions/PageRaterExtension_Controller.php 2 locations

@@ 158-162 (lines=5) @@
155 
        $sqlQuery = new SQLQuery();
156 
        $sqlQuery->setSelect("AVG(\"PageRating\".\"Rating\") RatingAverage, ParentID");
157 
        $sqlQuery->setFrom("\"PageRating\" ");
158 
        if ($this->onlyShowApprovedPageRatings()) {
159 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID." AND \"PageRating\".\"IsApproved\" = 1");
160 
        } else {
161 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID."");
162 
        }
163 
        $sqlQuery->setOrderBy("RatingAverage DESC");
164 
        $sqlQuery->setGroupby("\"ParentID\"");
165 
        $sqlQuery->setLimit(1);
@@ 278-282 (lines=5) @@
275 
        $sqlQuery = new SQLQuery();
276 
        $sqlQuery->setSelect("COUNT(\"PageRating\".\"Rating\") RatingCount");
277 
        $sqlQuery->setFrom("\"PageRating\" ");
278 
        if ($this->onlyShowApprovedPageRatings()) {
279 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID." AND \"PageRating\".\"IsApproved\" = 1");
280 
        } else {
281 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID."");
282 
        }
283 
        $sqlQuery->setOrderBy("RatingCount ASC");
284 
        $sqlQuery->setGroupBy("\"ParentID\"");
285 
        $sqlQuery->setLimit(1);