TYPO3 /
TYPO3.CMS
| @@ 3285-3308 (lines=24) @@ | ||
| 3282 | * @param string[] $fields Field list to select, * for all |
|
| 3283 | * @return \TYPO3\CMS\Core\Database\Query\QueryBuilder |
|
| 3284 | */ |
|
| 3285 | public function getQueryBuilder( |
|
| 3286 | string $table, |
|
| 3287 | int $pageId, |
|
| 3288 | array $additionalConstraints = [], |
|
| 3289 | array $fields = ['*'] |
|
| 3290 | ): QueryBuilder { |
|
| 3291 | $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class) |
|
| 3292 | ->getQueryBuilderForTable($table); |
|
| 3293 | $queryBuilder->getRestrictions() |
|
| 3294 | ->removeAll() |
|
| 3295 | ->add(GeneralUtility::makeInstance(DeletedRestriction::class)) |
|
| 3296 | ->add(GeneralUtility::makeInstance(BackendWorkspaceRestriction::class)); |
|
| 3297 | $queryBuilder |
|
| 3298 | ->select(...$fields) |
|
| 3299 | ->from($table); |
|
| 3300 | ||
| 3301 | if (!empty($additionalConstraints)) { |
|
| 3302 | $queryBuilder->andWhere(...$additionalConstraints); |
|
| 3303 | } |
|
| 3304 | ||
| 3305 | $queryBuilder = $this->prepareQueryBuilder($table, $pageId, $fields, $additionalConstraints, $queryBuilder); |
|
| 3306 | ||
| 3307 | return $queryBuilder; |
|
| 3308 | } |
|
| 3309 | ||
| 3310 | /** |
|
| 3311 | * Return the modified QueryBuilder object ($queryBuilder) which will be |
|
| @@ 711-734 (lines=24) @@ | ||
| 708 | * @return \TYPO3\CMS\Core\Database\Query\QueryBuilder |
|
| 709 | * @deprecated since TYPO3 v9, will be removed in TYPO3 v10 |
|
| 710 | */ |
|
| 711 | public function getQueryBuilder( |
|
| 712 | string $table, |
|
| 713 | int $pageId, |
|
| 714 | array $additionalConstraints = [], |
|
| 715 | array $fields = ['*'] |
|
| 716 | ): QueryBuilder { |
|
| 717 | $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class) |
|
| 718 | ->getQueryBuilderForTable($table); |
|
| 719 | $queryBuilder->getRestrictions() |
|
| 720 | ->removeAll() |
|
| 721 | ->add(GeneralUtility::makeInstance(DeletedRestriction::class)) |
|
| 722 | ->add(GeneralUtility::makeInstance(BackendWorkspaceRestriction::class)); |
|
| 723 | $queryBuilder |
|
| 724 | ->select(...$fields) |
|
| 725 | ->from($table); |
|
| 726 | ||
| 727 | if (!empty($additionalConstraints)) { |
|
| 728 | $queryBuilder->andWhere(...$additionalConstraints); |
|
| 729 | } |
|
| 730 | ||
| 731 | $queryBuilder = $this->prepareQueryBuilder($table, $pageId, $fields, $additionalConstraints, $queryBuilder); |
|
| 732 | ||
| 733 | return $queryBuilder; |
|
| 734 | } |
|
| 735 | ||
| 736 | /** |
|
| 737 | * Return the modified QueryBuilder object ($queryBuilder) which will be |
|
| @@ 3145-3168 (lines=24) @@ | ||
| 3142 | * @param string[] $fields Field list to select, * for all |
|
| 3143 | * @return \TYPO3\CMS\Core\Database\Query\QueryBuilder |
|
| 3144 | */ |
|
| 3145 | public function getQueryBuilder( |
|
| 3146 | string $table, |
|
| 3147 | int $pageId, |
|
| 3148 | array $additionalConstraints = [], |
|
| 3149 | array $fields = ['*'] |
|
| 3150 | ): QueryBuilder { |
|
| 3151 | $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class) |
|
| 3152 | ->getQueryBuilderForTable($table); |
|
| 3153 | $queryBuilder->getRestrictions() |
|
| 3154 | ->removeAll() |
|
| 3155 | ->add(GeneralUtility::makeInstance(DeletedRestriction::class)) |
|
| 3156 | ->add(GeneralUtility::makeInstance(BackendWorkspaceRestriction::class)); |
|
| 3157 | $queryBuilder |
|
| 3158 | ->select(...$fields) |
|
| 3159 | ->from($table); |
|
| 3160 | ||
| 3161 | if (!empty($additionalConstraints)) { |
|
| 3162 | $queryBuilder->andWhere(...$additionalConstraints); |
|
| 3163 | } |
|
| 3164 | ||
| 3165 | $queryBuilder = $this->prepareQueryBuilder($table, $pageId, $fields, $additionalConstraints, $queryBuilder); |
|
| 3166 | ||
| 3167 | return $queryBuilder; |
|
| 3168 | } |
|
| 3169 | ||
| 3170 | /** |
|
| 3171 | * Return the modified QueryBuilder object ($queryBuilder) which will be |
|
