@@ -10,21 +10,21 @@ |
||
| 10 | 10 | |
| 11 | 11 | abstract class PublicInterfacePageBase extends PageBase |
| 12 | 12 | { |
| 13 | - /** |
|
| 14 | - * PublicInterfaceInternalPageBase constructor. |
|
| 15 | - */ |
|
| 16 | - public function __construct() |
|
| 17 | - { |
|
| 18 | - $this->template = 'publicbase.tpl'; |
|
| 19 | - } |
|
| 13 | + /** |
|
| 14 | + * PublicInterfaceInternalPageBase constructor. |
|
| 15 | + */ |
|
| 16 | + public function __construct() |
|
| 17 | + { |
|
| 18 | + $this->template = 'publicbase.tpl'; |
|
| 19 | + } |
|
| 20 | 20 | |
| 21 | - final public function execute() |
|
| 22 | - { |
|
| 23 | - parent::execute(); |
|
| 24 | - } |
|
| 21 | + final public function execute() |
|
| 22 | + { |
|
| 23 | + parent::execute(); |
|
| 24 | + } |
|
| 25 | 25 | |
| 26 | - final public function finalisePage() |
|
| 27 | - { |
|
| 28 | - parent::finalisePage(); |
|
| 29 | - } |
|
| 26 | + final public function finalisePage() |
|
| 27 | + { |
|
| 28 | + parent::finalisePage(); |
|
| 29 | + } |
|
| 30 | 30 | } |
| 31 | 31 | \ No newline at end of file |
@@ -23,124 +23,124 @@ |
||
| 23 | 23 | */ |
| 24 | 24 | abstract class DataObject |
| 25 | 25 | { |
| 26 | - /** @var int ID of the object */ |
|
| 27 | - protected $id = null; |
|
| 28 | - /** @var int update version for optimistic locking */ |
|
| 29 | - protected $updateversion = 0; |
|
| 30 | - /** |
|
| 31 | - * @var PdoDatabase |
|
| 32 | - */ |
|
| 33 | - protected $dbObject; |
|
| 34 | - |
|
| 35 | - /** |
|
| 36 | - * Retrieves a data object by it's row ID. |
|
| 37 | - * |
|
| 38 | - * @param int $id |
|
| 39 | - * @param PdoDatabase $database |
|
| 40 | - * |
|
| 41 | - * @return DataObject|false |
|
| 42 | - */ |
|
| 43 | - public static function getById($id, PdoDatabase $database) |
|
| 44 | - { |
|
| 45 | - $array = explode('\\', get_called_class()); |
|
| 46 | - $realClassName = strtolower(end($array)); |
|
| 47 | - |
|
| 48 | - $statement = $database->prepare("SELECT * FROM {$realClassName} WHERE id = :id LIMIT 1;"); |
|
| 49 | - $statement->bindValue(":id", $id); |
|
| 50 | - |
|
| 51 | - $statement->execute(); |
|
| 52 | - |
|
| 53 | - $resultObject = $statement->fetchObject(get_called_class()); |
|
| 54 | - |
|
| 55 | - if ($resultObject != false) { |
|
| 56 | - $resultObject->setDatabase($database); |
|
| 57 | - } |
|
| 58 | - |
|
| 59 | - return $resultObject; |
|
| 60 | - } |
|
| 61 | - |
|
| 62 | - public function setDatabase(PdoDatabase $db) |
|
| 63 | - { |
|
| 64 | - $this->dbObject = $db; |
|
| 65 | - } |
|
| 66 | - |
|
| 67 | - /** |
|
| 68 | - * Gets the database associated with this data object. |
|
| 69 | - * @return PdoDatabase |
|
| 70 | - */ |
|
| 71 | - public function getDatabase() |
|
| 72 | - { |
|
| 73 | - return $this->dbObject; |
|
| 74 | - } |
|
| 75 | - |
|
| 76 | - /** |
|
| 77 | - * Saves a data object to the database, either updating or inserting a record. |
|
| 78 | - * |
|
| 79 | - * @return void |
|
| 80 | - */ |
|
| 81 | - abstract public function save(); |
|
| 82 | - |
|
| 83 | - /** |
|
| 84 | - * Retrieves the ID attribute |
|
| 85 | - */ |
|
| 86 | - public function getId() |
|
| 87 | - { |
|
| 88 | - return (int)$this->id; |
|
| 89 | - } |
|
| 90 | - |
|
| 91 | - /** |
|
| 92 | - * Deletes the object from the database |
|
| 93 | - */ |
|
| 94 | - public function delete() |
|
| 95 | - { |
|
| 96 | - if ($this->id === null) { |
|
| 97 | - // wtf? |
|
| 98 | - return; |
|
| 99 | - } |
|
| 100 | - |
|
| 101 | - $array = explode('\\', get_called_class()); |
|
| 102 | - $realClassName = strtolower(end($array)); |
|
| 103 | - |
|
| 104 | - $deleteQuery = "DELETE FROM {$realClassName} WHERE id = :id AND updateversion = :updateversion LIMIT 1;"; |
|
| 105 | - $statement = $this->dbObject->prepare($deleteQuery); |
|
| 106 | - |
|
| 107 | - $statement->bindValue(":id", $this->id); |
|
| 108 | - $statement->bindValue(":updateversion", $this->updateversion); |
|
| 109 | - $statement->execute(); |
|
| 110 | - |
|
| 111 | - if ($statement->rowCount() !== 1) { |
|
| 112 | - throw new OptimisticLockFailedException(); |
|
| 113 | - } |
|
| 114 | - |
|
| 115 | - $this->id = null; |
|
| 116 | - } |
|
| 117 | - |
|
| 118 | - /** |
|
| 119 | - * @return int |
|
| 120 | - */ |
|
| 121 | - public function getUpdateVersion() |
|
| 122 | - { |
|
| 123 | - return $this->updateversion; |
|
| 124 | - } |
|
| 125 | - |
|
| 126 | - /** |
|
| 127 | - * Sets the update version. |
|
| 128 | - * |
|
| 129 | - * You should never call this to change the value of the update version. You should only call it when passing user |
|
| 130 | - * input through. |
|
| 131 | - * |
|
| 132 | - * @param int $updateVersion |
|
| 133 | - */ |
|
| 134 | - public function setUpdateVersion($updateVersion) |
|
| 135 | - { |
|
| 136 | - $this->updateversion = $updateVersion; |
|
| 137 | - } |
|
| 138 | - |
|
| 139 | - /** |
|
| 140 | - * @return bool |
|
| 141 | - */ |
|
| 142 | - public function isNew() |
|
| 143 | - { |
|
| 144 | - return $this->id === null; |
|
| 145 | - } |
|
| 26 | + /** @var int ID of the object */ |
|
| 27 | + protected $id = null; |
|
| 28 | + /** @var int update version for optimistic locking */ |
|
| 29 | + protected $updateversion = 0; |
|
| 30 | + /** |
|
| 31 | + * @var PdoDatabase |
|
| 32 | + */ |
|
| 33 | + protected $dbObject; |
|
| 34 | + |
|
| 35 | + /** |
|
| 36 | + * Retrieves a data object by it's row ID. |
|
| 37 | + * |
|
| 38 | + * @param int $id |
|
| 39 | + * @param PdoDatabase $database |
|
| 40 | + * |
|
| 41 | + * @return DataObject|false |
|
| 42 | + */ |
|
| 43 | + public static function getById($id, PdoDatabase $database) |
|
| 44 | + { |
|
| 45 | + $array = explode('\\', get_called_class()); |
|
| 46 | + $realClassName = strtolower(end($array)); |
|
| 47 | + |
|
| 48 | + $statement = $database->prepare("SELECT * FROM {$realClassName} WHERE id = :id LIMIT 1;"); |
|
| 49 | + $statement->bindValue(":id", $id); |
|
| 50 | + |
|
| 51 | + $statement->execute(); |
|
| 52 | + |
|
| 53 | + $resultObject = $statement->fetchObject(get_called_class()); |
|
| 54 | + |
|
| 55 | + if ($resultObject != false) { |
|
| 56 | + $resultObject->setDatabase($database); |
|
| 57 | + } |
|
| 58 | + |
|
| 59 | + return $resultObject; |
|
| 60 | + } |
|
| 61 | + |
|
| 62 | + public function setDatabase(PdoDatabase $db) |
|
| 63 | + { |
|
| 64 | + $this->dbObject = $db; |
|
| 65 | + } |
|
| 66 | + |
|
| 67 | + /** |
|
| 68 | + * Gets the database associated with this data object. |
|
| 69 | + * @return PdoDatabase |
|
| 70 | + */ |
|
| 71 | + public function getDatabase() |
|
| 72 | + { |
|
| 73 | + return $this->dbObject; |
|
| 74 | + } |
|
| 75 | + |
|
| 76 | + /** |
|
| 77 | + * Saves a data object to the database, either updating or inserting a record. |
|
| 78 | + * |
|
| 79 | + * @return void |
|
| 80 | + */ |
|
| 81 | + abstract public function save(); |
|
| 82 | + |
|
| 83 | + /** |
|
| 84 | + * Retrieves the ID attribute |
|
| 85 | + */ |
|
| 86 | + public function getId() |
|
| 87 | + { |
|
| 88 | + return (int)$this->id; |
|
| 89 | + } |
|
| 90 | + |
|
| 91 | + /** |
|
| 92 | + * Deletes the object from the database |
|
| 93 | + */ |
|
| 94 | + public function delete() |
|
| 95 | + { |
|
| 96 | + if ($this->id === null) { |
|
| 97 | + // wtf? |
|
| 98 | + return; |
|
| 99 | + } |
|
| 100 | + |
|
| 101 | + $array = explode('\\', get_called_class()); |
|
| 102 | + $realClassName = strtolower(end($array)); |
|
| 103 | + |
|
| 104 | + $deleteQuery = "DELETE FROM {$realClassName} WHERE id = :id AND updateversion = :updateversion LIMIT 1;"; |
|
| 105 | + $statement = $this->dbObject->prepare($deleteQuery); |
|
| 106 | + |
|
| 107 | + $statement->bindValue(":id", $this->id); |
|
| 108 | + $statement->bindValue(":updateversion", $this->updateversion); |
|
| 109 | + $statement->execute(); |
|
| 110 | + |
|
| 111 | + if ($statement->rowCount() !== 1) { |
|
| 112 | + throw new OptimisticLockFailedException(); |
|
| 113 | + } |
|
| 114 | + |
|
| 115 | + $this->id = null; |
|
| 116 | + } |
|
| 117 | + |
|
| 118 | + /** |
|
| 119 | + * @return int |
|
| 120 | + */ |
|
| 121 | + public function getUpdateVersion() |
|
| 122 | + { |
|
| 123 | + return $this->updateversion; |
|
| 124 | + } |
|
| 125 | + |
|
| 126 | + /** |
|
| 127 | + * Sets the update version. |
|
| 128 | + * |
|
| 129 | + * You should never call this to change the value of the update version. You should only call it when passing user |
|
| 130 | + * input through. |
|
| 131 | + * |
|
| 132 | + * @param int $updateVersion |
|
| 133 | + */ |
|
| 134 | + public function setUpdateVersion($updateVersion) |
|
| 135 | + { |
|
| 136 | + $this->updateversion = $updateVersion; |
|
| 137 | + } |
|
| 138 | + |
|
| 139 | + /** |
|
| 140 | + * @return bool |
|
| 141 | + */ |
|
| 142 | + public function isNew() |
|
| 143 | + { |
|
| 144 | + return $this->id === null; |
|
| 145 | + } |
|
| 146 | 146 | } |
@@ -15,55 +15,55 @@ |
||
| 15 | 15 | */ |
| 16 | 16 | class Offline |
| 17 | 17 | { |
| 18 | - /** |
|
| 19 | - * Determines if the tool is offline |
|
| 20 | - * @return bool |
|
| 21 | - */ |
|
| 22 | - public static function isOffline() |
|
| 23 | - { |
|
| 24 | - global $dontUseDb; |
|
| 18 | + /** |
|
| 19 | + * Determines if the tool is offline |
|
| 20 | + * @return bool |
|
| 21 | + */ |
|
| 22 | + public static function isOffline() |
|
| 23 | + { |
|
| 24 | + global $dontUseDb; |
|
| 25 | 25 | |
| 26 | - return (bool)$dontUseDb; |
|
| 27 | - } |
|
| 26 | + return (bool)$dontUseDb; |
|
| 27 | + } |
|
| 28 | 28 | |
| 29 | - /** |
|
| 30 | - * Gets the offline message |
|
| 31 | - * |
|
| 32 | - * @param bool $external |
|
| 33 | - * @param null $message |
|
| 34 | - * |
|
| 35 | - * @return string |
|
| 36 | - */ |
|
| 37 | - public static function getOfflineMessage($external, $message = null) |
|
| 38 | - { |
|
| 39 | - global $dontUseDbCulprit, $dontUseDbReason, $baseurl; |
|
| 29 | + /** |
|
| 30 | + * Gets the offline message |
|
| 31 | + * |
|
| 32 | + * @param bool $external |
|
| 33 | + * @param null $message |
|
| 34 | + * |
|
| 35 | + * @return string |
|
| 36 | + */ |
|
| 37 | + public static function getOfflineMessage($external, $message = null) |
|
| 38 | + { |
|
| 39 | + global $dontUseDbCulprit, $dontUseDbReason, $baseurl; |
|
| 40 | 40 | |
| 41 | - $smarty = new Smarty(); |
|
| 42 | - $smarty->assign("baseurl", $baseurl); |
|
| 43 | - $smarty->assign("toolversion", Environment::getToolVersion()); |
|
| 41 | + $smarty = new Smarty(); |
|
| 42 | + $smarty->assign("baseurl", $baseurl); |
|
| 43 | + $smarty->assign("toolversion", Environment::getToolVersion()); |
|
| 44 | 44 | |
| 45 | - if (!headers_sent()) { |
|
| 46 | - header("HTTP/1.1 503 Service Unavailable"); |
|
| 47 | - } |
|
| 45 | + if (!headers_sent()) { |
|
| 46 | + header("HTTP/1.1 503 Service Unavailable"); |
|
| 47 | + } |
|
| 48 | 48 | |
| 49 | - if ($external) { |
|
| 50 | - return $smarty->fetch("offline/external.tpl"); |
|
| 51 | - } |
|
| 52 | - else { |
|
| 53 | - $hideCulprit = true; |
|
| 49 | + if ($external) { |
|
| 50 | + return $smarty->fetch("offline/external.tpl"); |
|
| 51 | + } |
|
| 52 | + else { |
|
| 53 | + $hideCulprit = true; |
|
| 54 | 54 | |
| 55 | - // Use the provided message if possible |
|
| 56 | - if ($message === null) { |
|
| 57 | - $hideCulprit = false; |
|
| 58 | - $message = $dontUseDbReason; |
|
| 59 | - } |
|
| 55 | + // Use the provided message if possible |
|
| 56 | + if ($message === null) { |
|
| 57 | + $hideCulprit = false; |
|
| 58 | + $message = $dontUseDbReason; |
|
| 59 | + } |
|
| 60 | 60 | |
| 61 | - $smarty->assign("hideCulprit", $hideCulprit); |
|
| 62 | - $smarty->assign("dontUseDbCulprit", $dontUseDbCulprit); |
|
| 63 | - $smarty->assign("dontUseDbReason", $message); |
|
| 64 | - $smarty->assign("alerts", array()); |
|
| 61 | + $smarty->assign("hideCulprit", $hideCulprit); |
|
| 62 | + $smarty->assign("dontUseDbCulprit", $dontUseDbCulprit); |
|
| 63 | + $smarty->assign("dontUseDbReason", $message); |
|
| 64 | + $smarty->assign("alerts", array()); |
|
| 65 | 65 | |
| 66 | - return $smarty->fetch("offline/internal.tpl"); |
|
| 67 | - } |
|
| 68 | - } |
|
| 66 | + return $smarty->fetch("offline/internal.tpl"); |
|
| 67 | + } |
|
| 68 | + } |
|
| 69 | 69 | } |
@@ -19,157 +19,157 @@ |
||
| 19 | 19 | |
| 20 | 20 | class PageSearch extends InternalPageBase |
| 21 | 21 | { |
| 22 | - /** |
|
| 23 | - * Main function for this page, when no specific actions are called. |
|
| 24 | - */ |
|
| 25 | - protected function main() |
|
| 26 | - { |
|
| 27 | - $this->setHtmlTitle('Search'); |
|
| 28 | - |
|
| 29 | - // Dual-mode page |
|
| 30 | - if (WebRequest::wasPosted()) { |
|
| 31 | - $this->validateCSRFToken(); |
|
| 32 | - |
|
| 33 | - $searchType = WebRequest::postString('type'); |
|
| 34 | - $searchTerm = WebRequest::postString('term'); |
|
| 35 | - |
|
| 36 | - $validationError = ""; |
|
| 37 | - if (!$this->validateSearchParameters($searchType, $searchTerm, $validationError)) { |
|
| 38 | - SessionAlert::error($validationError, "Search error"); |
|
| 39 | - $this->redirect("search"); |
|
| 40 | - |
|
| 41 | - return; |
|
| 42 | - } |
|
| 43 | - |
|
| 44 | - $results = array(); |
|
| 45 | - |
|
| 46 | - switch ($searchType) { |
|
| 47 | - case 'name': |
|
| 48 | - $results = $this->getNameSearchResults($searchTerm); |
|
| 49 | - break; |
|
| 50 | - case 'email': |
|
| 51 | - $results = $this->getEmailSearchResults($searchTerm); |
|
| 52 | - break; |
|
| 53 | - case 'ip': |
|
| 54 | - $results = $this->getIpSearchResults($searchTerm); |
|
| 55 | - break; |
|
| 56 | - } |
|
| 57 | - |
|
| 58 | - // deal with results |
|
| 59 | - $this->assign('requests', $results); |
|
| 60 | - $this->assign('term', $searchTerm); |
|
| 61 | - $this->assign('target', $searchType); |
|
| 62 | - |
|
| 63 | - $userIds = array_map( |
|
| 64 | - function(Request $entry) { |
|
| 65 | - return $entry->getReserved(); |
|
| 66 | - }, |
|
| 67 | - $results); |
|
| 68 | - $userList = User::getUsernames($userIds, $this->getDatabase()); |
|
| 69 | - $this->assign('userlist', $userList); |
|
| 70 | - |
|
| 71 | - $this->assignCSRFToken(); |
|
| 72 | - $this->setTemplate('search/searchResult.tpl'); |
|
| 73 | - } |
|
| 74 | - else { |
|
| 75 | - $this->assignCSRFToken(); |
|
| 76 | - $this->setTemplate('search/searchForm.tpl'); |
|
| 77 | - } |
|
| 78 | - } |
|
| 79 | - |
|
| 80 | - /** |
|
| 81 | - * Gets search results by name |
|
| 82 | - * |
|
| 83 | - * @param string $searchTerm |
|
| 84 | - * |
|
| 85 | - * @returns Request[] |
|
| 86 | - */ |
|
| 87 | - private function getNameSearchResults($searchTerm) |
|
| 88 | - { |
|
| 89 | - $padded = '%' . $searchTerm . '%'; |
|
| 90 | - |
|
| 91 | - return RequestSearchHelper::get($this->getDatabase()) |
|
| 92 | - ->byName($padded) |
|
| 93 | - ->excludingPurgedData($this->getSiteConfiguration()) |
|
| 94 | - ->fetch(); |
|
| 95 | - } |
|
| 96 | - |
|
| 97 | - /** |
|
| 98 | - * Gets search results by email |
|
| 99 | - * |
|
| 100 | - * @param string $searchTerm |
|
| 101 | - * |
|
| 102 | - * @return Request[] |
|
| 103 | - * @throws ApplicationLogicException |
|
| 104 | - */ |
|
| 105 | - private function getEmailSearchResults($searchTerm) |
|
| 106 | - { |
|
| 107 | - if ($searchTerm === "@") { |
|
| 108 | - throw new ApplicationLogicException('The search term "@" is not valid for email address searches!'); |
|
| 109 | - } |
|
| 110 | - |
|
| 111 | - $padded = '%' . $searchTerm . '%'; |
|
| 112 | - |
|
| 113 | - return RequestSearchHelper::get($this->getDatabase()) |
|
| 114 | - ->byEmailAddress($padded) |
|
| 115 | - ->excludingPurgedData($this->getSiteConfiguration()) |
|
| 116 | - ->fetch(); |
|
| 117 | - } |
|
| 118 | - |
|
| 119 | - /** |
|
| 120 | - * Gets search results by IP address or XFF IP address |
|
| 121 | - * |
|
| 122 | - * @param string $searchTerm |
|
| 123 | - * |
|
| 124 | - * @returns Request[] |
|
| 125 | - */ |
|
| 126 | - private function getIpSearchResults($searchTerm) |
|
| 127 | - { |
|
| 128 | - return RequestSearchHelper::get($this->getDatabase()) |
|
| 129 | - ->byIp($searchTerm) |
|
| 130 | - ->excludingPurgedData($this->getSiteConfiguration()) |
|
| 131 | - ->fetch(); |
|
| 132 | - } |
|
| 133 | - |
|
| 134 | - /** |
|
| 135 | - * Sets up the security for this page. If certain actions have different permissions, this should be reflected in |
|
| 136 | - * the return value from this function. |
|
| 137 | - * |
|
| 138 | - * If this page even supports actions, you will need to check the route |
|
| 139 | - * |
|
| 140 | - * @return SecurityConfiguration |
|
| 141 | - * @category Security-Critical |
|
| 142 | - */ |
|
| 143 | - protected function getSecurityConfiguration() |
|
| 144 | - { |
|
| 145 | - return $this->getSecurityManager()->configure()->asInternalPage(); |
|
| 146 | - } |
|
| 147 | - |
|
| 148 | - /** |
|
| 149 | - * @param string $searchType |
|
| 150 | - * @param string $searchTerm |
|
| 151 | - * |
|
| 152 | - * @param string $errorMessage |
|
| 153 | - * |
|
| 154 | - * @return bool true if parameters are valid |
|
| 155 | - * @throws ApplicationLogicException |
|
| 156 | - */ |
|
| 157 | - protected function validateSearchParameters($searchType, $searchTerm, &$errorMessage) |
|
| 158 | - { |
|
| 159 | - if (!in_array($searchType, array('name', 'email', 'ip'))) { |
|
| 160 | - $errorMessage = 'Unknown search type'; |
|
| 161 | - |
|
| 162 | - return false; |
|
| 163 | - } |
|
| 164 | - |
|
| 165 | - if ($searchTerm === '%' || $searchTerm === '' || $searchTerm === null) { |
|
| 166 | - $errorMessage = 'No search term specified entered'; |
|
| 167 | - |
|
| 168 | - return false; |
|
| 169 | - } |
|
| 170 | - |
|
| 171 | - $errorMessage = ""; |
|
| 172 | - |
|
| 173 | - return true; |
|
| 174 | - } |
|
| 22 | + /** |
|
| 23 | + * Main function for this page, when no specific actions are called. |
|
| 24 | + */ |
|
| 25 | + protected function main() |
|
| 26 | + { |
|
| 27 | + $this->setHtmlTitle('Search'); |
|
| 28 | + |
|
| 29 | + // Dual-mode page |
|
| 30 | + if (WebRequest::wasPosted()) { |
|
| 31 | + $this->validateCSRFToken(); |
|
| 32 | + |
|
| 33 | + $searchType = WebRequest::postString('type'); |
|
| 34 | + $searchTerm = WebRequest::postString('term'); |
|
| 35 | + |
|
| 36 | + $validationError = ""; |
|
| 37 | + if (!$this->validateSearchParameters($searchType, $searchTerm, $validationError)) { |
|
| 38 | + SessionAlert::error($validationError, "Search error"); |
|
| 39 | + $this->redirect("search"); |
|
| 40 | + |
|
| 41 | + return; |
|
| 42 | + } |
|
| 43 | + |
|
| 44 | + $results = array(); |
|
| 45 | + |
|
| 46 | + switch ($searchType) { |
|
| 47 | + case 'name': |
|
| 48 | + $results = $this->getNameSearchResults($searchTerm); |
|
| 49 | + break; |
|
| 50 | + case 'email': |
|
| 51 | + $results = $this->getEmailSearchResults($searchTerm); |
|
| 52 | + break; |
|
| 53 | + case 'ip': |
|
| 54 | + $results = $this->getIpSearchResults($searchTerm); |
|
| 55 | + break; |
|
| 56 | + } |
|
| 57 | + |
|
| 58 | + // deal with results |
|
| 59 | + $this->assign('requests', $results); |
|
| 60 | + $this->assign('term', $searchTerm); |
|
| 61 | + $this->assign('target', $searchType); |
|
| 62 | + |
|
| 63 | + $userIds = array_map( |
|
| 64 | + function(Request $entry) { |
|
| 65 | + return $entry->getReserved(); |
|
| 66 | + }, |
|
| 67 | + $results); |
|
| 68 | + $userList = User::getUsernames($userIds, $this->getDatabase()); |
|
| 69 | + $this->assign('userlist', $userList); |
|
| 70 | + |
|
| 71 | + $this->assignCSRFToken(); |
|
| 72 | + $this->setTemplate('search/searchResult.tpl'); |
|
| 73 | + } |
|
| 74 | + else { |
|
| 75 | + $this->assignCSRFToken(); |
|
| 76 | + $this->setTemplate('search/searchForm.tpl'); |
|
| 77 | + } |
|
| 78 | + } |
|
| 79 | + |
|
| 80 | + /** |
|
| 81 | + * Gets search results by name |
|
| 82 | + * |
|
| 83 | + * @param string $searchTerm |
|
| 84 | + * |
|
| 85 | + * @returns Request[] |
|
| 86 | + */ |
|
| 87 | + private function getNameSearchResults($searchTerm) |
|
| 88 | + { |
|
| 89 | + $padded = '%' . $searchTerm . '%'; |
|
| 90 | + |
|
| 91 | + return RequestSearchHelper::get($this->getDatabase()) |
|
| 92 | + ->byName($padded) |
|
| 93 | + ->excludingPurgedData($this->getSiteConfiguration()) |
|
| 94 | + ->fetch(); |
|
| 95 | + } |
|
| 96 | + |
|
| 97 | + /** |
|
| 98 | + * Gets search results by email |
|
| 99 | + * |
|
| 100 | + * @param string $searchTerm |
|
| 101 | + * |
|
| 102 | + * @return Request[] |
|
| 103 | + * @throws ApplicationLogicException |
|
| 104 | + */ |
|
| 105 | + private function getEmailSearchResults($searchTerm) |
|
| 106 | + { |
|
| 107 | + if ($searchTerm === "@") { |
|
| 108 | + throw new ApplicationLogicException('The search term "@" is not valid for email address searches!'); |
|
| 109 | + } |
|
| 110 | + |
|
| 111 | + $padded = '%' . $searchTerm . '%'; |
|
| 112 | + |
|
| 113 | + return RequestSearchHelper::get($this->getDatabase()) |
|
| 114 | + ->byEmailAddress($padded) |
|
| 115 | + ->excludingPurgedData($this->getSiteConfiguration()) |
|
| 116 | + ->fetch(); |
|
| 117 | + } |
|
| 118 | + |
|
| 119 | + /** |
|
| 120 | + * Gets search results by IP address or XFF IP address |
|
| 121 | + * |
|
| 122 | + * @param string $searchTerm |
|
| 123 | + * |
|
| 124 | + * @returns Request[] |
|
| 125 | + */ |
|
| 126 | + private function getIpSearchResults($searchTerm) |
|
| 127 | + { |
|
| 128 | + return RequestSearchHelper::get($this->getDatabase()) |
|
| 129 | + ->byIp($searchTerm) |
|
| 130 | + ->excludingPurgedData($this->getSiteConfiguration()) |
|
| 131 | + ->fetch(); |
|
| 132 | + } |
|
| 133 | + |
|
| 134 | + /** |
|
| 135 | + * Sets up the security for this page. If certain actions have different permissions, this should be reflected in |
|
| 136 | + * the return value from this function. |
|
| 137 | + * |
|
| 138 | + * If this page even supports actions, you will need to check the route |
|
| 139 | + * |
|
| 140 | + * @return SecurityConfiguration |
|
| 141 | + * @category Security-Critical |
|
| 142 | + */ |
|
| 143 | + protected function getSecurityConfiguration() |
|
| 144 | + { |
|
| 145 | + return $this->getSecurityManager()->configure()->asInternalPage(); |
|
| 146 | + } |
|
| 147 | + |
|
| 148 | + /** |
|
| 149 | + * @param string $searchType |
|
| 150 | + * @param string $searchTerm |
|
| 151 | + * |
|
| 152 | + * @param string $errorMessage |
|
| 153 | + * |
|
| 154 | + * @return bool true if parameters are valid |
|
| 155 | + * @throws ApplicationLogicException |
|
| 156 | + */ |
|
| 157 | + protected function validateSearchParameters($searchType, $searchTerm, &$errorMessage) |
|
| 158 | + { |
|
| 159 | + if (!in_array($searchType, array('name', 'email', 'ip'))) { |
|
| 160 | + $errorMessage = 'Unknown search type'; |
|
| 161 | + |
|
| 162 | + return false; |
|
| 163 | + } |
|
| 164 | + |
|
| 165 | + if ($searchTerm === '%' || $searchTerm === '' || $searchTerm === null) { |
|
| 166 | + $errorMessage = 'No search term specified entered'; |
|
| 167 | + |
|
| 168 | + return false; |
|
| 169 | + } |
|
| 170 | + |
|
| 171 | + $errorMessage = ""; |
|
| 172 | + |
|
| 173 | + return true; |
|
| 174 | + } |
|
| 175 | 175 | } |
| 176 | 176 | \ No newline at end of file |
@@ -86,7 +86,7 @@ discard block |
||
| 86 | 86 | */ |
| 87 | 87 | private function getNameSearchResults($searchTerm) |
| 88 | 88 | { |
| 89 | - $padded = '%' . $searchTerm . '%'; |
|
| 89 | + $padded = '%'.$searchTerm.'%'; |
|
| 90 | 90 | |
| 91 | 91 | return RequestSearchHelper::get($this->getDatabase()) |
| 92 | 92 | ->byName($padded) |
@@ -108,7 +108,7 @@ discard block |
||
| 108 | 108 | throw new ApplicationLogicException('The search term "@" is not valid for email address searches!'); |
| 109 | 109 | } |
| 110 | 110 | |
| 111 | - $padded = '%' . $searchTerm . '%'; |
|
| 111 | + $padded = '%'.$searchTerm.'%'; |
|
| 112 | 112 | |
| 113 | 113 | return RequestSearchHelper::get($this->getDatabase()) |
| 114 | 114 | ->byEmailAddress($padded) |
@@ -13,45 +13,45 @@ |
||
| 13 | 13 | |
| 14 | 14 | class PageTeam extends InternalPageBase |
| 15 | 15 | { |
| 16 | - /** |
|
| 17 | - * Main function for this page, when no specific actions are called. |
|
| 18 | - * @return void |
|
| 19 | - */ |
|
| 20 | - protected function main() |
|
| 21 | - { |
|
| 22 | - $path = $this->getSiteConfiguration()->getFilePath() . '/team.json'; |
|
| 23 | - $json = file_get_contents($path); |
|
| 24 | - |
|
| 25 | - $teamData = json_decode($json, true); |
|
| 26 | - |
|
| 27 | - $active = array(); |
|
| 28 | - $inactive = array(); |
|
| 29 | - |
|
| 30 | - foreach ($teamData as $name => $item) { |
|
| 31 | - if (count($item['Role']) == 0) { |
|
| 32 | - $inactive[$name] = $item; |
|
| 33 | - } |
|
| 34 | - else { |
|
| 35 | - $active[$name] = $item; |
|
| 36 | - } |
|
| 37 | - } |
|
| 38 | - |
|
| 39 | - $this->assign('developer', $active); |
|
| 40 | - $this->assign('inactiveDeveloper', $inactive); |
|
| 41 | - $this->setTemplate('team/team.tpl'); |
|
| 42 | - } |
|
| 43 | - |
|
| 44 | - /** |
|
| 45 | - * Sets up the security for this page. If certain actions have different permissions, this should be reflected in |
|
| 46 | - * the return value from this function. |
|
| 47 | - * |
|
| 48 | - * If this page even supports actions, you will need to check the route |
|
| 49 | - * |
|
| 50 | - * @return SecurityConfiguration |
|
| 51 | - * @category Security-Critical |
|
| 52 | - */ |
|
| 53 | - protected function getSecurityConfiguration() |
|
| 54 | - { |
|
| 55 | - return $this->getSecurityManager()->configure()->asPublicPage(); |
|
| 56 | - } |
|
| 16 | + /** |
|
| 17 | + * Main function for this page, when no specific actions are called. |
|
| 18 | + * @return void |
|
| 19 | + */ |
|
| 20 | + protected function main() |
|
| 21 | + { |
|
| 22 | + $path = $this->getSiteConfiguration()->getFilePath() . '/team.json'; |
|
| 23 | + $json = file_get_contents($path); |
|
| 24 | + |
|
| 25 | + $teamData = json_decode($json, true); |
|
| 26 | + |
|
| 27 | + $active = array(); |
|
| 28 | + $inactive = array(); |
|
| 29 | + |
|
| 30 | + foreach ($teamData as $name => $item) { |
|
| 31 | + if (count($item['Role']) == 0) { |
|
| 32 | + $inactive[$name] = $item; |
|
| 33 | + } |
|
| 34 | + else { |
|
| 35 | + $active[$name] = $item; |
|
| 36 | + } |
|
| 37 | + } |
|
| 38 | + |
|
| 39 | + $this->assign('developer', $active); |
|
| 40 | + $this->assign('inactiveDeveloper', $inactive); |
|
| 41 | + $this->setTemplate('team/team.tpl'); |
|
| 42 | + } |
|
| 43 | + |
|
| 44 | + /** |
|
| 45 | + * Sets up the security for this page. If certain actions have different permissions, this should be reflected in |
|
| 46 | + * the return value from this function. |
|
| 47 | + * |
|
| 48 | + * If this page even supports actions, you will need to check the route |
|
| 49 | + * |
|
| 50 | + * @return SecurityConfiguration |
|
| 51 | + * @category Security-Critical |
|
| 52 | + */ |
|
| 53 | + protected function getSecurityConfiguration() |
|
| 54 | + { |
|
| 55 | + return $this->getSecurityManager()->configure()->asPublicPage(); |
|
| 56 | + } |
|
| 57 | 57 | } |
| 58 | 58 | \ No newline at end of file |
@@ -19,7 +19,7 @@ |
||
| 19 | 19 | */ |
| 20 | 20 | protected function main() |
| 21 | 21 | { |
| 22 | - $path = $this->getSiteConfiguration()->getFilePath() . '/team.json'; |
|
| 22 | + $path = $this->getSiteConfiguration()->getFilePath().'/team.json'; |
|
| 23 | 23 | $json = file_get_contents($path); |
| 24 | 24 | |
| 25 | 25 | $teamData = json_decode($json, true); |
@@ -13,12 +13,12 @@ discard block |
||
| 13 | 13 | |
| 14 | 14 | class StatsTopCreators extends InternalPageBase |
| 15 | 15 | { |
| 16 | - public function main() |
|
| 17 | - { |
|
| 18 | - $this->setHtmlTitle('Top Creators :: Statistics'); |
|
| 16 | + public function main() |
|
| 17 | + { |
|
| 18 | + $this->setHtmlTitle('Top Creators :: Statistics'); |
|
| 19 | 19 | |
| 20 | - // Retrieve all-time stats |
|
| 21 | - $queryAllTime = <<<SQL |
|
| 20 | + // Retrieve all-time stats |
|
| 21 | + $queryAllTime = <<<SQL |
|
| 22 | 22 | SELECT |
| 23 | 23 | /* StatsTopCreators::execute()/queryAllTime */ |
| 24 | 24 | COUNT(*) count, |
@@ -35,8 +35,8 @@ discard block |
||
| 35 | 35 | ORDER BY COUNT(*) DESC; |
| 36 | 36 | SQL; |
| 37 | 37 | |
| 38 | - // Retrieve all-time stats for active users only |
|
| 39 | - $queryAllTimeActive = <<<SQL |
|
| 38 | + // Retrieve all-time stats for active users only |
|
| 39 | + $queryAllTimeActive = <<<SQL |
|
| 40 | 40 | SELECT |
| 41 | 41 | /* StatsTopCreators::execute()/queryAllTimeActive */ |
| 42 | 42 | COUNT(*) count, |
@@ -53,8 +53,8 @@ discard block |
||
| 53 | 53 | ORDER BY COUNT(*) DESC; |
| 54 | 54 | SQL; |
| 55 | 55 | |
| 56 | - // Retrieve today's stats (so far) |
|
| 57 | - $queryToday = <<<SQL |
|
| 56 | + // Retrieve today's stats (so far) |
|
| 57 | + $queryToday = <<<SQL |
|
| 58 | 58 | SELECT |
| 59 | 59 | /* StatsTopCreators::execute()/top5out */ |
| 60 | 60 | COUNT(*) count, |
@@ -70,8 +70,8 @@ discard block |
||
| 70 | 70 | ORDER BY COUNT(*) DESC; |
| 71 | 71 | SQL; |
| 72 | 72 | |
| 73 | - // Retrieve Yesterday's stats |
|
| 74 | - $queryYesterday = <<<SQL |
|
| 73 | + // Retrieve Yesterday's stats |
|
| 74 | + $queryYesterday = <<<SQL |
|
| 75 | 75 | SELECT |
| 76 | 76 | /* StatsTopCreators::execute()/top5yout */ |
| 77 | 77 | COUNT(*) count, |
@@ -87,8 +87,8 @@ discard block |
||
| 87 | 87 | ORDER BY COUNT(*) DESC; |
| 88 | 88 | SQL; |
| 89 | 89 | |
| 90 | - // Retrieve last 7 days |
|
| 91 | - $queryLast7Days = <<<SQL |
|
| 90 | + // Retrieve last 7 days |
|
| 91 | + $queryLast7Days = <<<SQL |
|
| 92 | 92 | SELECT |
| 93 | 93 | /* StatsTopCreators::execute()/top5wout */ |
| 94 | 94 | COUNT(*) count, |
@@ -104,8 +104,8 @@ discard block |
||
| 104 | 104 | ORDER BY COUNT(*) DESC; |
| 105 | 105 | SQL; |
| 106 | 106 | |
| 107 | - // Retrieve last month's stats |
|
| 108 | - $queryLast28Days = <<<SQL |
|
| 107 | + // Retrieve last month's stats |
|
| 108 | + $queryLast28Days = <<<SQL |
|
| 109 | 109 | SELECT |
| 110 | 110 | /* StatsTopCreators::execute()/top5mout */ |
| 111 | 111 | COUNT(*) count, |
@@ -121,29 +121,29 @@ discard block |
||
| 121 | 121 | ORDER BY COUNT(*) DESC; |
| 122 | 122 | SQL; |
| 123 | 123 | |
| 124 | - // Put it all together |
|
| 125 | - $queries = array( |
|
| 126 | - 'queryAllTime' => $queryAllTime, |
|
| 127 | - 'queryAllTimeActive' => $queryAllTimeActive, |
|
| 128 | - 'queryToday' => $queryToday, |
|
| 129 | - 'queryYesterday' => $queryYesterday, |
|
| 130 | - 'queryLast7Days' => $queryLast7Days, |
|
| 131 | - 'queryLast28Days' => $queryLast28Days, |
|
| 132 | - ); |
|
| 124 | + // Put it all together |
|
| 125 | + $queries = array( |
|
| 126 | + 'queryAllTime' => $queryAllTime, |
|
| 127 | + 'queryAllTimeActive' => $queryAllTimeActive, |
|
| 128 | + 'queryToday' => $queryToday, |
|
| 129 | + 'queryYesterday' => $queryYesterday, |
|
| 130 | + 'queryLast7Days' => $queryLast7Days, |
|
| 131 | + 'queryLast28Days' => $queryLast28Days, |
|
| 132 | + ); |
|
| 133 | 133 | |
| 134 | - $database = $this->getDatabase(); |
|
| 135 | - foreach ($queries as $name => $sql) { |
|
| 136 | - $statement = $database->query($sql); |
|
| 137 | - $data = $statement->fetchAll(PDO::FETCH_ASSOC); |
|
| 138 | - $this->assign($name, $data); |
|
| 139 | - } |
|
| 134 | + $database = $this->getDatabase(); |
|
| 135 | + foreach ($queries as $name => $sql) { |
|
| 136 | + $statement = $database->query($sql); |
|
| 137 | + $data = $statement->fetchAll(PDO::FETCH_ASSOC); |
|
| 138 | + $this->assign($name, $data); |
|
| 139 | + } |
|
| 140 | 140 | |
| 141 | - $this->assign('statsPageTitle', 'Top Account Creators'); |
|
| 142 | - $this->setTemplate('statistics/top-creators.tpl'); |
|
| 143 | - } |
|
| 141 | + $this->assign('statsPageTitle', 'Top Account Creators'); |
|
| 142 | + $this->setTemplate('statistics/top-creators.tpl'); |
|
| 143 | + } |
|
| 144 | 144 | |
| 145 | - public function getSecurityConfiguration() |
|
| 146 | - { |
|
| 147 | - return $this->getSecurityManager()->configure()->asPublicPage(); |
|
| 148 | - } |
|
| 145 | + public function getSecurityConfiguration() |
|
| 146 | + { |
|
| 147 | + return $this->getSecurityManager()->configure()->asPublicPage(); |
|
| 148 | + } |
|
| 149 | 149 | } |
| 150 | 150 | \ No newline at end of file |
@@ -13,11 +13,11 @@ discard block |
||
| 13 | 13 | |
| 14 | 14 | class StatsFastCloses extends InternalPageBase |
| 15 | 15 | { |
| 16 | - public function main() |
|
| 17 | - { |
|
| 18 | - $this->setHtmlTitle('Fast Closes :: Statistics'); |
|
| 16 | + public function main() |
|
| 17 | + { |
|
| 18 | + $this->setHtmlTitle('Fast Closes :: Statistics'); |
|
| 19 | 19 | |
| 20 | - $query = <<<SQL |
|
| 20 | + $query = <<<SQL |
|
| 21 | 21 | SELECT |
| 22 | 22 | log_closed.objectid AS request, |
| 23 | 23 | user.username AS user, |
@@ -42,16 +42,16 @@ discard block |
||
| 42 | 42 | ORDER BY TIMEDIFF(log_closed.timestamp, log_reserved.timestamp) ASC |
| 43 | 43 | ; |
| 44 | 44 | SQL; |
| 45 | - $database = $this->getDatabase(); |
|
| 46 | - $statement = $database->query($query); |
|
| 47 | - $data = $statement->fetchAll(PDO::FETCH_ASSOC); |
|
| 48 | - $this->assign('dataTable', $data); |
|
| 49 | - $this->assign('statsPageTitle', 'Requests closed less than 30 seconds after reservation in the past 3 months'); |
|
| 50 | - $this->setTemplate('statistics/fast-closes.tpl'); |
|
| 51 | - } |
|
| 52 | - |
|
| 53 | - public function getSecurityConfiguration() |
|
| 54 | - { |
|
| 55 | - return $this->getSecurityManager()->configure()->asInternalPage(); |
|
| 56 | - } |
|
| 45 | + $database = $this->getDatabase(); |
|
| 46 | + $statement = $database->query($query); |
|
| 47 | + $data = $statement->fetchAll(PDO::FETCH_ASSOC); |
|
| 48 | + $this->assign('dataTable', $data); |
|
| 49 | + $this->assign('statsPageTitle', 'Requests closed less than 30 seconds after reservation in the past 3 months'); |
|
| 50 | + $this->setTemplate('statistics/fast-closes.tpl'); |
|
| 51 | + } |
|
| 52 | + |
|
| 53 | + public function getSecurityConfiguration() |
|
| 54 | + { |
|
| 55 | + return $this->getSecurityManager()->configure()->asInternalPage(); |
|
| 56 | + } |
|
| 57 | 57 | } |
@@ -14,25 +14,25 @@ |
||
| 14 | 14 | |
| 15 | 15 | class StatsInactiveUsers extends InternalPageBase |
| 16 | 16 | { |
| 17 | - public function main() |
|
| 18 | - { |
|
| 19 | - $this->setHtmlTitle('Inactive Users :: Statistics'); |
|
| 17 | + public function main() |
|
| 18 | + { |
|
| 19 | + $this->setHtmlTitle('Inactive Users :: Statistics'); |
|
| 20 | 20 | |
| 21 | - $showImmune = false; |
|
| 22 | - if (WebRequest::getBoolean('showimmune')) { |
|
| 23 | - $showImmune = true; |
|
| 24 | - } |
|
| 21 | + $showImmune = false; |
|
| 22 | + if (WebRequest::getBoolean('showimmune')) { |
|
| 23 | + $showImmune = true; |
|
| 24 | + } |
|
| 25 | 25 | |
| 26 | - $this->assign('showImmune', $showImmune); |
|
| 27 | - $inactiveUsers = User::getAllInactive($this->getDatabase()); |
|
| 28 | - $this->assign('inactiveUsers', $inactiveUsers); |
|
| 26 | + $this->assign('showImmune', $showImmune); |
|
| 27 | + $inactiveUsers = User::getAllInactive($this->getDatabase()); |
|
| 28 | + $this->assign('inactiveUsers', $inactiveUsers); |
|
| 29 | 29 | |
| 30 | - $this->setTemplate('statistics/inactive-users.tpl'); |
|
| 31 | - $this->assign('statsPageTitle', 'Inactive tool users'); |
|
| 32 | - } |
|
| 30 | + $this->setTemplate('statistics/inactive-users.tpl'); |
|
| 31 | + $this->assign('statsPageTitle', 'Inactive tool users'); |
|
| 32 | + } |
|
| 33 | 33 | |
| 34 | - public function getSecurityConfiguration() |
|
| 35 | - { |
|
| 36 | - return $this->getSecurityManager()->configure()->asInternalPage(); |
|
| 37 | - } |
|
| 34 | + public function getSecurityConfiguration() |
|
| 35 | + { |
|
| 36 | + return $this->getSecurityManager()->configure()->asInternalPage(); |
|
| 37 | + } |
|
| 38 | 38 | } |
@@ -19,52 +19,52 @@ discard block |
||
| 19 | 19 | |
| 20 | 20 | class StatsUsers extends InternalPageBase |
| 21 | 21 | { |
| 22 | - public function main() |
|
| 23 | - { |
|
| 24 | - $this->setHtmlTitle('Users :: Statistics'); |
|
| 25 | - |
|
| 26 | - $database = $this->getDatabase(); |
|
| 27 | - |
|
| 28 | - $lists = array( |
|
| 29 | - "Admin" => User::getAllWithStatus("Admin", $database), |
|
| 30 | - "User" => User::getAllWithStatus("User", $database), |
|
| 31 | - "CheckUsers" => User::getAllCheckusers($database), |
|
| 32 | - ); |
|
| 33 | - |
|
| 34 | - $this->assign("lists", $lists); |
|
| 35 | - |
|
| 36 | - $this->assign('statsPageTitle', 'Account Creation Tool users'); |
|
| 37 | - $this->setTemplate("statistics/users.tpl"); |
|
| 38 | - } |
|
| 39 | - |
|
| 40 | - public function getSecurityConfiguration() |
|
| 41 | - { |
|
| 42 | - return $this->getSecurityManager()->configure()->asPublicPage(); |
|
| 43 | - } |
|
| 44 | - |
|
| 45 | - /** |
|
| 46 | - * Entry point for the detail action. |
|
| 47 | - * |
|
| 48 | - * @throws ApplicationLogicException |
|
| 49 | - */ |
|
| 50 | - protected function detail() |
|
| 51 | - { |
|
| 52 | - $userId = WebRequest::getInt('user'); |
|
| 53 | - if ($userId === null) { |
|
| 54 | - throw new ApplicationLogicException("User not found"); |
|
| 55 | - } |
|
| 56 | - |
|
| 57 | - $database = $this->getDatabase(); |
|
| 58 | - |
|
| 59 | - $user = User::getById($userId, $database); |
|
| 60 | - if ($user == false) { |
|
| 61 | - throw new ApplicationLogicException('User not found'); |
|
| 62 | - } |
|
| 63 | - |
|
| 64 | - $safeUsername = htmlentities($user->getUsername(), ENT_COMPAT, 'UTF-8'); |
|
| 65 | - $this->setHtmlTitle($safeUsername . ' :: Users :: Statistics'); |
|
| 66 | - |
|
| 67 | - $activitySummary = $database->prepare(<<<SQL |
|
| 22 | + public function main() |
|
| 23 | + { |
|
| 24 | + $this->setHtmlTitle('Users :: Statistics'); |
|
| 25 | + |
|
| 26 | + $database = $this->getDatabase(); |
|
| 27 | + |
|
| 28 | + $lists = array( |
|
| 29 | + "Admin" => User::getAllWithStatus("Admin", $database), |
|
| 30 | + "User" => User::getAllWithStatus("User", $database), |
|
| 31 | + "CheckUsers" => User::getAllCheckusers($database), |
|
| 32 | + ); |
|
| 33 | + |
|
| 34 | + $this->assign("lists", $lists); |
|
| 35 | + |
|
| 36 | + $this->assign('statsPageTitle', 'Account Creation Tool users'); |
|
| 37 | + $this->setTemplate("statistics/users.tpl"); |
|
| 38 | + } |
|
| 39 | + |
|
| 40 | + public function getSecurityConfiguration() |
|
| 41 | + { |
|
| 42 | + return $this->getSecurityManager()->configure()->asPublicPage(); |
|
| 43 | + } |
|
| 44 | + |
|
| 45 | + /** |
|
| 46 | + * Entry point for the detail action. |
|
| 47 | + * |
|
| 48 | + * @throws ApplicationLogicException |
|
| 49 | + */ |
|
| 50 | + protected function detail() |
|
| 51 | + { |
|
| 52 | + $userId = WebRequest::getInt('user'); |
|
| 53 | + if ($userId === null) { |
|
| 54 | + throw new ApplicationLogicException("User not found"); |
|
| 55 | + } |
|
| 56 | + |
|
| 57 | + $database = $this->getDatabase(); |
|
| 58 | + |
|
| 59 | + $user = User::getById($userId, $database); |
|
| 60 | + if ($user == false) { |
|
| 61 | + throw new ApplicationLogicException('User not found'); |
|
| 62 | + } |
|
| 63 | + |
|
| 64 | + $safeUsername = htmlentities($user->getUsername(), ENT_COMPAT, 'UTF-8'); |
|
| 65 | + $this->setHtmlTitle($safeUsername . ' :: Users :: Statistics'); |
|
| 66 | + |
|
| 67 | + $activitySummary = $database->prepare(<<<SQL |
|
| 68 | 68 | SELECT COALESCE(closes.mail_desc, log.action) AS action, COUNT(*) AS count |
| 69 | 69 | FROM log |
| 70 | 70 | INNER JOIN user ON log.user = user.id |
@@ -72,14 +72,14 @@ discard block |
||
| 72 | 72 | WHERE user.username = :username |
| 73 | 73 | GROUP BY action; |
| 74 | 74 | SQL |
| 75 | - ); |
|
| 76 | - $activitySummary->execute(array(":username" => $user->getUsername())); |
|
| 77 | - $activitySummaryData = $activitySummary->fetchAll(PDO::FETCH_ASSOC); |
|
| 75 | + ); |
|
| 76 | + $activitySummary->execute(array(":username" => $user->getUsername())); |
|
| 77 | + $activitySummaryData = $activitySummary->fetchAll(PDO::FETCH_ASSOC); |
|
| 78 | 78 | |
| 79 | - $this->assign("user", $user); |
|
| 80 | - $this->assign("activity", $activitySummaryData); |
|
| 79 | + $this->assign("user", $user); |
|
| 80 | + $this->assign("activity", $activitySummaryData); |
|
| 81 | 81 | |
| 82 | - $usersCreatedQuery = $database->prepare(<<<SQL |
|
| 82 | + $usersCreatedQuery = $database->prepare(<<<SQL |
|
| 83 | 83 | SELECT log.timestamp time, request.name name, request.id id |
| 84 | 84 | FROM log |
| 85 | 85 | INNER JOIN request ON (request.id = log.objectid AND log.objecttype = 'Request') |
@@ -90,12 +90,12 @@ discard block |
||
| 90 | 90 | AND (emailtemplate.oncreated = '1' OR log.action = 'Closed custom-y') |
| 91 | 91 | ORDER BY log.timestamp; |
| 92 | 92 | SQL |
| 93 | - ); |
|
| 94 | - $usersCreatedQuery->execute(array(":username" => $user->getUsername())); |
|
| 95 | - $usersCreated = $usersCreatedQuery->fetchAll(PDO::FETCH_ASSOC); |
|
| 96 | - $this->assign("created", $usersCreated); |
|
| 93 | + ); |
|
| 94 | + $usersCreatedQuery->execute(array(":username" => $user->getUsername())); |
|
| 95 | + $usersCreated = $usersCreatedQuery->fetchAll(PDO::FETCH_ASSOC); |
|
| 96 | + $this->assign("created", $usersCreated); |
|
| 97 | 97 | |
| 98 | - $usersNotCreatedQuery = $database->prepare(<<<SQL |
|
| 98 | + $usersNotCreatedQuery = $database->prepare(<<<SQL |
|
| 99 | 99 | SELECT log.timestamp time, request.name name, request.id id |
| 100 | 100 | FROM log |
| 101 | 101 | JOIN request ON request.id = log.objectid AND log.objecttype = 'Request' |
@@ -106,29 +106,29 @@ discard block |
||
| 106 | 106 | AND (emailtemplate.oncreated = '0' OR log.action = 'Closed custom-n' OR log.action = 'Closed 0') |
| 107 | 107 | ORDER BY log.timestamp; |
| 108 | 108 | SQL |
| 109 | - ); |
|
| 110 | - $usersNotCreatedQuery->execute(array(":username" => $user->getUsername())); |
|
| 111 | - $usersNotCreated = $usersNotCreatedQuery->fetchAll(PDO::FETCH_ASSOC); |
|
| 112 | - $this->assign("notcreated", $usersNotCreated); |
|
| 113 | - |
|
| 114 | - /** @var Log[] $logs */ |
|
| 115 | - $logs = LogSearchHelper::get($database) |
|
| 116 | - ->byObjectType('User') |
|
| 117 | - ->byObjectId($user->getId()) |
|
| 118 | - ->getRecordCount($logCount) |
|
| 119 | - ->fetch(); |
|
| 120 | - |
|
| 121 | - if ($logCount === 0) { |
|
| 122 | - $this->assign('accountlog', array()); |
|
| 123 | - } |
|
| 124 | - else { |
|
| 125 | - list($users, $logData) = LogHelper::prepareLogsForTemplate($logs, $database, $this->getSiteConfiguration()); |
|
| 126 | - |
|
| 127 | - $this->assign("accountlog", $logData); |
|
| 128 | - $this->assign("users", $users); |
|
| 129 | - } |
|
| 130 | - |
|
| 131 | - $this->assign('statsPageTitle', 'Account Creation Tool users'); |
|
| 132 | - $this->setTemplate("statistics/userdetail.tpl"); |
|
| 133 | - } |
|
| 109 | + ); |
|
| 110 | + $usersNotCreatedQuery->execute(array(":username" => $user->getUsername())); |
|
| 111 | + $usersNotCreated = $usersNotCreatedQuery->fetchAll(PDO::FETCH_ASSOC); |
|
| 112 | + $this->assign("notcreated", $usersNotCreated); |
|
| 113 | + |
|
| 114 | + /** @var Log[] $logs */ |
|
| 115 | + $logs = LogSearchHelper::get($database) |
|
| 116 | + ->byObjectType('User') |
|
| 117 | + ->byObjectId($user->getId()) |
|
| 118 | + ->getRecordCount($logCount) |
|
| 119 | + ->fetch(); |
|
| 120 | + |
|
| 121 | + if ($logCount === 0) { |
|
| 122 | + $this->assign('accountlog', array()); |
|
| 123 | + } |
|
| 124 | + else { |
|
| 125 | + list($users, $logData) = LogHelper::prepareLogsForTemplate($logs, $database, $this->getSiteConfiguration()); |
|
| 126 | + |
|
| 127 | + $this->assign("accountlog", $logData); |
|
| 128 | + $this->assign("users", $users); |
|
| 129 | + } |
|
| 130 | + |
|
| 131 | + $this->assign('statsPageTitle', 'Account Creation Tool users'); |
|
| 132 | + $this->setTemplate("statistics/userdetail.tpl"); |
|
| 133 | + } |
|
| 134 | 134 | } |
@@ -62,7 +62,7 @@ |
||
| 62 | 62 | } |
| 63 | 63 | |
| 64 | 64 | $safeUsername = htmlentities($user->getUsername(), ENT_COMPAT, 'UTF-8'); |
| 65 | - $this->setHtmlTitle($safeUsername . ' :: Users :: Statistics'); |
|
| 65 | + $this->setHtmlTitle($safeUsername.' :: Users :: Statistics'); |
|
| 66 | 66 | |
| 67 | 67 | $activitySummary = $database->prepare(<<<SQL |
| 68 | 68 | SELECT COALESCE(closes.mail_desc, log.action) AS action, COUNT(*) AS count |