| @@ 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 | ||
| @@ 1865-1875 (lines=11) @@ | ||
| 1862 | } |
|
| 1863 | ||
| 1864 | // relation type |
|
| 1865 | if (isset($relationType)) { |
|
| 1866 | $query->where( |
|
| 1867 | $query->expr->gt( |
|
| 1868 | $query->expr->bitAnd( |
|
| 1869 | $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'), |
|
| 1870 | $query->bindValue($relationType, null, \PDO::PARAM_INT) |
|
| 1871 | ), |
|
| 1872 | 0 |
|
| 1873 | ) |
|
| 1874 | ); |
|
| 1875 | } |
|
| 1876 | ||
| 1877 | $statement = $query->prepare(); |
|
| 1878 | $statement->execute(); |
|
| @@ 1922-1932 (lines=11) @@ | ||
| 1919 | ); |
|
| 1920 | ||
| 1921 | // relation type |
|
| 1922 | if (isset($relationType)) { |
|
| 1923 | $query->where( |
|
| 1924 | $query->expr->gt( |
|
| 1925 | $query->expr->bitAnd( |
|
| 1926 | $this->dbHandler->quoteColumn('relation_type', 'ezcontentobject_link'), |
|
| 1927 | $query->bindValue($relationType, null, \PDO::PARAM_INT) |
|
| 1928 | ), |
|
| 1929 | 0 |
|
| 1930 | ) |
|
| 1931 | ); |
|
| 1932 | } |
|
| 1933 | ||
| 1934 | $statement = $query->prepare(); |
|
| 1935 | ||