*/ class SettingsFormMapper extends QBMapper { public function __construct(IDBConnection $db) { parent::__construct($db, 'ex_settings_forms'); } /** * @throws Exception */ public function findAllEnabled(): array { $qb = $this->db->getQueryBuilder(); $result = $qb->select('exs.*') ->from($this->tableName, 'exs') ->innerJoin('exs', 'ex_apps', 'exa', $qb->expr()->eq('exa.appid', 'exs.appid')) ->where( $qb->expr()->eq('exa.enabled', $qb->createNamedParameter(1, IQueryBuilder::PARAM_INT)) ) ->executeQuery(); return $result->fetchAll(); } /** * @param string $appId * @param string $formId * * @throws Exception * @throws MultipleObjectsReturnedException * * @throws DoesNotExistException */ public function findByAppidFormId(string $appId, string $formId): SettingsForm { $qb = $this->db->getQueryBuilder(); return $this->findEntity($qb->select('*') ->from($this->tableName) ->where($qb->expr()->eq('appid', $qb->createNamedParameter($appId), IQueryBuilder::PARAM_STR)) ->andWhere($qb->expr()->eq('formid', $qb->createNamedParameter($formId), IQueryBuilder::PARAM_STR)) ); } /** * @throws Exception */ public function removeAllByAppId(string $appId): int { $qb = $this->db->getQueryBuilder(); $qb->delete($this->tableName) ->where( $qb->expr()->eq('appid', $qb->createNamedParameter($appId, IQueryBuilder::PARAM_STR)) ); return $qb->executeStatement(); } }