|
@@ 234-243 (lines=10) @@
|
| 231 |
|
endif; |
| 232 |
|
|
| 233 |
|
$sql = $this->selectSQL($this->selectCollumns) . ' ' . $this->whereSQL($filters) . ' ' . $option; |
| 234 |
|
if ($this->pdo) { |
| 235 |
|
$this->debug($sql, $this->getFilterValues($filters)); |
| 236 |
|
$stmt = $this->pdo->prepare($sql); |
| 237 |
|
$stmt->execute($this->getFilterValues($filters)); |
| 238 |
|
|
| 239 |
|
$results = $stmt->fetchAll(); |
| 240 |
|
foreach ($results as $result): |
| 241 |
|
$array[] = $this->mapObject($result); |
| 242 |
|
endforeach; |
| 243 |
|
} |
| 244 |
|
return $array; |
| 245 |
|
} |
| 246 |
|
|
|
@@ 281-288 (lines=8) @@
|
| 278 |
|
|
| 279 |
|
$sql = 'SELECT count(*) as total FROM ' . static::TABLE . ' ' . static::JOIN . ' ' . $this->whereSQL($filters) . ' ' . $option; |
| 280 |
|
|
| 281 |
|
if ($this->pdo) { |
| 282 |
|
$this->debug($sql, $this->getFilterValues($filters)); |
| 283 |
|
$stmt = $this->pdo->prepare($sql); |
| 284 |
|
$stmt->execute($this->getFilterValues($filters)); |
| 285 |
|
|
| 286 |
|
$result = $stmt->fetch(); |
| 287 |
|
$total = $result['total']; |
| 288 |
|
} |
| 289 |
|
return (int) $total; |
| 290 |
|
} |
| 291 |
|
|