@@ 110-114 (lines=5) @@ | ||
107 | ->innerJoin('m', 'external_applicable', 'a', $builder->expr()->eq('m.mount_id', 'a.mount_id')) |
|
108 | ->where($builder->expr()->eq('a.type', $builder->createNamedParameter($type, IQueryBuilder::PARAM_INT))); |
|
109 | ||
110 | if (is_null($value)) { |
|
111 | $query = $query->andWhere($builder->expr()->isNull('a.value')); |
|
112 | } else { |
|
113 | $query = $query->andWhere($builder->expr()->eq('a.value', $builder->createNamedParameter($value))); |
|
114 | } |
|
115 | ||
116 | return $query; |
|
117 | } |
|
@@ 325-329 (lines=5) @@ | ||
322 | ->where($builder->expr()->eq('mount_id', $builder->createNamedParameter($mountId, IQueryBuilder::PARAM_INT))) |
|
323 | ->andWhere($builder->expr()->eq('type', $builder->createNamedParameter($type, IQueryBuilder::PARAM_INT))); |
|
324 | ||
325 | if (is_null($value)) { |
|
326 | $query = $query->andWhere($builder->expr()->isNull('value')); |
|
327 | } else { |
|
328 | $query = $query->andWhere($builder->expr()->eq('value', $builder->createNamedParameter($value, IQueryBuilder::PARAM_STR))); |
|
329 | } |
|
330 | ||
331 | $query->execute(); |
|
332 | } |