| Conditions | 1 |
| Paths | 1 |
| Total Lines | 66 |
| Code Lines | 41 |
| Lines | 0 |
| Ratio | 0 % |
| Changes | 1 | ||
| Bugs | 0 | Features | 0 |
Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.
For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.
Commonly applied refactorings include:
If many parameters/temporary variables are present:
| 1 | <?php |
||
| 84 | private function smallStats() |
||
| 85 | { |
||
| 86 | global $smarty; |
||
| 87 | |||
| 88 | $database = gGetDb(); |
||
| 89 | $requestsQuery = "SELECT COUNT(*) FROM request WHERE status = :status AND emailconfirm = 'Confirmed';"; |
||
| 90 | |||
| 91 | $requestsStatement = $database->prepare($requestsQuery); |
||
| 92 | |||
| 93 | // TODO: use the request states thing here. |
||
| 94 | |||
| 95 | // Open Requests |
||
| 96 | $requestsStatement->execute(array(":status" => "Open")); |
||
| 97 | $open = $requestsStatement->fetchColumn(); |
||
| 98 | $requestsStatement->closeCursor(); |
||
| 99 | $smarty->assign("statsOpen", $open); |
||
| 100 | |||
| 101 | // Admin Requests |
||
| 102 | $requestsStatement->execute(array(":status" => "Flagged users")); |
||
| 103 | $admin = $requestsStatement->fetchColumn(); |
||
| 104 | $requestsStatement->closeCursor(); |
||
| 105 | $smarty->assign("statsAdmin", $admin); |
||
| 106 | |||
| 107 | // Checkuser Requests |
||
| 108 | $requestsStatement->execute(array(":status" => "Checkuser")); |
||
| 109 | $checkuser = $requestsStatement->fetchColumn(); |
||
| 110 | $requestsStatement->closeCursor(); |
||
| 111 | $smarty->assign("statsCheckuser", $checkuser); |
||
| 112 | |||
| 113 | // Unconfirmed requests |
||
| 114 | $unconfirmedStatement = $database->query("SELECT COUNT(*) FROM request WHERE emailconfirm != 'Confirmed' AND emailconfirm != '';"); |
||
| 115 | $unconfirmed = $unconfirmedStatement->fetchColumn(); |
||
| 116 | $unconfirmedStatement->closeCursor(); |
||
| 117 | $smarty->assign("statsUnconfirmed", $unconfirmed); |
||
| 118 | |||
| 119 | $userStatusStatement = $database->prepare("SELECT COUNT(*) FROM user WHERE status = :status;"); |
||
| 120 | |||
| 121 | // Admin users |
||
| 122 | $userStatusStatement->execute(array(":status" => "Admin")); |
||
| 123 | $adminusers = $userStatusStatement->fetchColumn(); |
||
| 124 | $userStatusStatement->closeCursor(); |
||
| 125 | $smarty->assign("statsAdminUsers", $adminusers); |
||
| 126 | |||
| 127 | // Users |
||
| 128 | $userStatusStatement->execute(array(":status" => "User")); |
||
| 129 | $users = $userStatusStatement->fetchColumn(); |
||
| 130 | $userStatusStatement->closeCursor(); |
||
| 131 | $smarty->assign("statsUsers", $users); |
||
| 132 | |||
| 133 | // Suspended users |
||
| 134 | $userStatusStatement->execute(array(":status" => "Suspended")); |
||
| 135 | $suspendedUsers = $userStatusStatement->fetchColumn(); |
||
| 136 | $userStatusStatement->closeCursor(); |
||
| 137 | $smarty->assign("statsSuspendedUsers", $suspendedUsers); |
||
| 138 | |||
| 139 | // New users |
||
| 140 | $userStatusStatement->execute(array(":status" => "New")); |
||
| 141 | $newUsers = $userStatusStatement->fetchColumn(); |
||
| 142 | $userStatusStatement->closeCursor(); |
||
| 143 | $smarty->assign("statsNewUsers", $newUsers); |
||
| 144 | |||
| 145 | // Most comments on a request |
||
| 146 | $mostCommentsStatement = $database->query("SELECT request FROM comment GROUP BY request ORDER BY COUNT(*) DESC LIMIT 1;"); |
||
| 147 | $mostComments = $mostCommentsStatement->fetchColumn(); |
||
| 148 | $mostCommentsStatement->closeCursor(); |
||
| 149 | $smarty->assign("mostComments", $mostComments); |
||
| 150 | } |
||
| 152 |