| @@ 133-153 (lines=21) @@ | ||
| 130 | * @return array ページ属性の配列 |
|
| 131 | * @deprecated since 3.0.0, to be removed in 3.1 |
|
| 132 | */ |
|
| 133 | public function getPageList(DeviceType $DeviceType, $where = null, $parameters = array()) |
|
| 134 | { |
|
| 135 | $qb = $this->createQueryBuilder('l') |
|
| 136 | ->orderBy('l.id', 'DESC') |
|
| 137 | ->where('l.DeviceType = :DeviceType') |
|
| 138 | ->setParameter('DeviceType', $DeviceType) |
|
| 139 | ->andWhere('l.id <> 0') |
|
| 140 | ->orderBy('l.id', 'ASC'); |
|
| 141 | if (!is_null($where)) { |
|
| 142 | $qb->andWhere($where); |
|
| 143 | foreach ($parameters as $key => $val) { |
|
| 144 | $qb->setParameter($key, $val); |
|
| 145 | } |
|
| 146 | } |
|
| 147 | ||
| 148 | $PageLayouts = $qb |
|
| 149 | ->getQuery() |
|
| 150 | ->getResult(); |
|
| 151 | ||
| 152 | return $PageLayouts; |
|
| 153 | } |
|
| 154 | ||
| 155 | /** |
|
| 156 | * 書き込みパスの取得 |
|
| @@ 198-218 (lines=21) @@ | ||
| 195 | * @param string[] $parameters 追加の検索パラメーター |
|
| 196 | * @return array ページ属性の配列 |
|
| 197 | */ |
|
| 198 | public function getPageList(DeviceType $DeviceType, $where = null, $parameters = array()) |
|
| 199 | { |
|
| 200 | $qb = $this->createQueryBuilder('l') |
|
| 201 | ->orderBy('l.id', 'DESC') |
|
| 202 | ->where('l.DeviceType = :DeviceType') |
|
| 203 | ->setParameter('DeviceType', $DeviceType) |
|
| 204 | ->andWhere('l.id <> 0') |
|
| 205 | ->orderBy('l.id', 'ASC'); |
|
| 206 | if (!is_null($where)) { |
|
| 207 | $qb->andWhere($where); |
|
| 208 | foreach ($parameters as $key => $val) { |
|
| 209 | $qb->setParameter($key, $val); |
|
| 210 | } |
|
| 211 | } |
|
| 212 | ||
| 213 | $PageLayouts = $qb |
|
| 214 | ->getQuery() |
|
| 215 | ->getResult(); |
|
| 216 | ||
| 217 | return $PageLayouts; |
|
| 218 | } |
|
| 219 | ||
| 220 | /** |
|
| 221 | * 書き込みパスの取得 |
|