EC-CUBE /
ec-cube
| @@ 145-165 (lines=21) @@ | ||
| 142 | * |
|
| 143 | * @deprecated since 3.0.0, to be removed in 3.1 |
|
| 144 | */ |
|
| 145 | public function getPageList(DeviceType $DeviceType, $where = null, $parameters = []) |
|
| 146 | { |
|
| 147 | $qb = $this->createQueryBuilder('l') |
|
| 148 | ->orderBy('l.id', 'DESC') |
|
| 149 | ->where('l.DeviceType = :DeviceType') |
|
| 150 | ->setParameter('DeviceType', $DeviceType) |
|
| 151 | ->andWhere('l.id <> 0') |
|
| 152 | ->orderBy('l.id', 'ASC'); |
|
| 153 | if (!is_null($where)) { |
|
| 154 | $qb->andWhere($where); |
|
| 155 | foreach ($parameters as $key => $val) { |
|
| 156 | $qb->setParameter($key, $val); |
|
| 157 | } |
|
| 158 | } |
|
| 159 | ||
| 160 | $Pages = $qb |
|
| 161 | ->getQuery() |
|
| 162 | ->getResult(); |
|
| 163 | ||
| 164 | return $Pages; |
|
| 165 | } |
|
| 166 | } |
|
| 167 | ||
| @@ 222-243 (lines=22) @@ | ||
| 219 | * |
|
| 220 | * @return array ページ属性の配列 |
|
| 221 | */ |
|
| 222 | public function getPageList(DeviceType $DeviceType, $where = null, $parameters = []) |
|
| 223 | { |
|
| 224 | $qb = $this->createQueryBuilder('l') |
|
| 225 | ->orderBy('l.id', 'DESC') |
|
| 226 | ->where('l.DeviceType = :DeviceType') |
|
| 227 | ->setParameter('DeviceType', $DeviceType) |
|
| 228 | ->andWhere('l.id <> 0') |
|
| 229 | ->andWhere('l.MasterPage is null') |
|
| 230 | ->orderBy('l.id', 'ASC'); |
|
| 231 | if (!is_null($where)) { |
|
| 232 | $qb->andWhere($where); |
|
| 233 | foreach ($parameters as $key => $val) { |
|
| 234 | $qb->setParameter($key, $val); |
|
| 235 | } |
|
| 236 | } |
|
| 237 | ||
| 238 | $Pages = $qb |
|
| 239 | ->getQuery() |
|
| 240 | ->getResult(); |
|
| 241 | ||
| 242 | return $Pages; |
|
| 243 | } |
|
| 244 | } |
|
| 245 | ||
