| @@ 151-161 (lines=11) @@ | ||
| 148 | ) |
|
| 149 | ); |
|
| 150 | ||
| 151 | if ($languageId !== false) { |
|
| 152 | $query->where( |
|
| 153 | $query->expr->gt( |
|
| 154 | $query->expr->bitAnd( |
|
| 155 | $this->dbHandler->quoteColumn('lang_mask'), |
|
| 156 | $query->bindValue($languageId, null, \PDO::PARAM_INT) |
|
| 157 | ), |
|
| 158 | 0 |
|
| 159 | ) |
|
| 160 | ); |
|
| 161 | } |
|
| 162 | ||
| 163 | $statement = $query->prepare(); |
|
| 164 | $statement->execute(); |
|
| @@ 215-229 (lines=15) @@ | ||
| 212 | $limit, |
|
| 213 | $offset |
|
| 214 | ); |
|
| 215 | if (isset($languageCode)) { |
|
| 216 | $query->where( |
|
| 217 | $query->expr->gt( |
|
| 218 | $query->expr->bitAnd( |
|
| 219 | $this->dbHandler->quoteColumn('lang_mask'), |
|
| 220 | $query->bindValue( |
|
| 221 | $this->languageMaskGenerator->generateLanguageIndicator($languageCode, false), |
|
| 222 | null, |
|
| 223 | \PDO::PARAM_INT |
|
| 224 | ) |
|
| 225 | ), |
|
| 226 | 0 |
|
| 227 | ) |
|
| 228 | ); |
|
| 229 | } |
|
| 230 | $statement = $query->prepare(); |
|
| 231 | $statement->execute(); |
|
| 232 | ||
| @@ 1787-1797 (lines=11) @@ | ||
| 1784 | } |
|
| 1785 | ||
| 1786 | // relation type |
|
| 1787 | if (isset($relationType)) { |
|
| 1788 | $query->where( |
|
| 1789 | $query->expr->gt( |
|
| 1790 | $query->expr->bitAnd( |
|
| 1791 | $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'), |
|
| 1792 | $query->bindValue($relationType, null, \PDO::PARAM_INT) |
|
| 1793 | ), |
|
| 1794 | 0 |
|
| 1795 | ) |
|
| 1796 | ); |
|
| 1797 | } |
|
| 1798 | ||
| 1799 | $statement = $query->prepare(); |
|
| 1800 | $statement->execute(); |
|
| @@ 1844-1854 (lines=11) @@ | ||
| 1841 | ); |
|
| 1842 | ||
| 1843 | // relation type |
|
| 1844 | if (isset($relationType)) { |
|
| 1845 | $query->where( |
|
| 1846 | $query->expr->gt( |
|
| 1847 | $query->expr->bitAnd( |
|
| 1848 | $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'), |
|
| 1849 | $query->bindValue($relationType, null, \PDO::PARAM_INT) |
|
| 1850 | ), |
|
| 1851 | 0 |
|
| 1852 | ) |
|
| 1853 | ); |
|
| 1854 | } |
|
| 1855 | ||
| 1856 | $statement = $query->prepare(); |
|
| 1857 | ||