Project

General

Profile

Download (2.36 KB)

Bug #90216 » 90216.patch

Benjamin Serfhos, 2020-01-27 16:00

View differences:

typo3/sysext/sys_note/Classes/Domain/Repository/SysNoteRepository.php
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)
->getQueryBuilderForTable('sys_note');
$queryBuilder->getRestrictions()->removeAll();
$res = $queryBuilder
->select('sys_note.*', 'be_users.username', 'be_users.realName')
->from('sys_note')
......
$queryBuilder->expr()->eq('sys_note.cruser', $queryBuilder->quoteIdentifier('be_users.uid'))
)
->where(
$queryBuilder->expr()->eq('sys_note.deleted', 0),
$queryBuilder->expr()->in('sys_note.pid', $queryBuilder->createNamedParameter($pids, Connection::PARAM_INT_ARRAY)),
$queryBuilder->expr()->orX(
$queryBuilder->expr()->in('sys_note.personal', $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)),
$queryBuilder->expr()->in('sys_note.cruser', $queryBuilder->createNamedParameter($author, \PDO::PARAM_INT))
$queryBuilder->expr()->eq('sys_note.personal', $queryBuilder->createNamedParameter(0, \PDO::PARAM_INT)),
$queryBuilder->expr()->eq('sys_note.cruser', $queryBuilder->createNamedParameter($author, \PDO::PARAM_INT))
)
)
->orderBy('sorting', 'asc')
(2-2/2)