connection = $connection; $this->l = $l; } /** * @return string */ public function getCategory() { return 'apps'; } /** * @return string */ public function getDisplayName() { return $this->l->t('App list (for each app: name, version, enabled status)'); } /** * @return array (string => string|int) */ public function getData() { $query = $this->connection->getQueryBuilder(); $query->select('*') ->from('appconfig') ->where($query->expr()->in('configkey', $query->createNamedParameter( ['enabled', 'installed_version'], IQueryBuilder::PARAM_STR_ARRAY ))); $result = $query->executeQuery(); $data = []; while ($row = $result->fetch()) { if ($row['configkey'] === 'enabled' && $row['configvalue'] === 'no') { $data[$row['appid']] = 'disabled'; } if ($row['configkey'] === 'installed_version' && !isset($data[$row['appid']])) { $data[$row['appid']] = $row['configvalue']; } } $result->closeCursor(); return $data; } }