Skip to content
Snippets Groups Projects

Devel

Merged Dr. Marcel Wunderlich requested to merge devel into main
6 files
+ 9
16
Compare changes
  • Side-by-side
  • Inline
Files
6
@@ -8,7 +8,6 @@ use OCA\SccuotNG\Util\FileSize;
use OCP\IDBConnection;
use OCP\DB\QueryBuilder\IQueryBuilder;
use OC\User\Account;
class AccountsMapper extends ExtMapper {
const ACCOUNTS_TABLE = 'accounts';
@@ -83,7 +82,7 @@ class AccountsMapper extends ExtMapper {
->from(self::ACCOUNTS_TABLE, 'a')
->join('a', StoragesMapper::STORAGES_TABLE, 's', "s.id = CONCAT('home::', a.user_id)")
->join('s', FilecacheMapper::FILECACHE_TABLE, 'fc', 'fc.storage = s.numeric_id')
->where($query->expr()->eq('a.state', $query->createPositionalParameter(Account::STATE_ENABLED)))
->where($query->expr()->eq('a.state', $query->createPositionalParameter('1'))) #Account::STATE_ENABLED
->andWhere($query->expr()->eq('fc.path', $query->createPositionalParameter('files')));
$this->addChunkCondition($query,'a.id', $offset);
@@ -112,7 +111,7 @@ class AccountsMapper extends ExtMapper {
$query->select('id', 'user_id', 'quota', 'backend')
->from(self::ACCOUNTS_TABLE)
->where($query->expr()->eq('state', $query->createPositionalParameter(Account::STATE_ENABLED, IQueryBuilder::PARAM_INT)))
->where($query->expr()->eq('state', $query->createPositionalParameter('1', IQueryBuilder::PARAM_INT))) #Account::STATE_ENABLED
->andWhere($query->expr()->isNotNull('quota'))
->andWhere($query->expr()->neq('quota', $query->createPositionalParameter('')))
->andWhere($query->expr()->neq($query->createFunction('LOWER(quota)'), $query->createPositionalParameter('none')));
Loading