View GitHub Repository silverstripe-pagerater

Schedule Inspection
Subscribe

Code Duplication    Length = 5-5 lines in 2 locations

code/extensions/PageRaterExtension.php 2 locations

@@ 112-116 (lines=5) @@
109 
        $sqlQuery = new SQLQuery();
110 
        $sqlQuery->setSelect("COUNT(\"PageRating\".\"Rating\") RatingCount");
111 
        $sqlQuery->setFrom("\"PageRating\" ");
112 
        if ($this->onlyShowApprovedPageRatings()) {
113 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID." AND \"PageRating\".\"IsApproved\" = 1");
114 
        } else {
115 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID."");
116 
        }
117 
        $sqlQuery->setOrderBy("RatingCount ASC");
118 
        $sqlQuery->setGroupBy("\"ParentID\"");
119 
        $sqlQuery->setLimit(1);
@@ 139-143 (lines=5) @@
136 
        $sqlQuery = new SQLQuery();
137 
        $sqlQuery->setSelect("AVG(\"PageRating\".\"Rating\") RatingAverage, ParentID");
138 
        $sqlQuery->setFrom("\"PageRating\" ");
139 
        if ($this->onlyShowApprovedPageRatings()) {
140 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID." AND \"PageRating\".\"IsApproved\" = 1");
141 
        } else {
142 
            $sqlQuery->setWhere("\"ParentID\" = ".$this->owner->ID."");
143 
        }
144 
        $sqlQuery->setOrderBy("RatingAverage DESC");
145 
        $sqlQuery->setGroupby("\"ParentID\"");
146 
        $sqlQuery->setLimit(1);