|
@@ 214-226 (lines=13) @@
|
| 211 |
|
$ret = array(); |
| 212 |
|
$limit = $start = 0; |
| 213 |
|
$sql = 'SELECT ' . $fields . ' FROM ' . $this->table; |
| 214 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 215 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 216 |
|
if ($criteria->groupby != '') { |
| 217 |
|
$sql .= $criteria->getGroupby(); |
| 218 |
|
} |
| 219 |
|
if ($criteria->getSort() != '') { |
| 220 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 221 |
|
} elseif ($this->identifierName != '' && $autoSort) { |
| 222 |
|
$sql .= ' ORDER BY ' . $this->identifierName; |
| 223 |
|
} |
| 224 |
|
$limit = $criteria->getLimit(); |
| 225 |
|
$start = $criteria->getStart(); |
| 226 |
|
} |
| 227 |
|
//$Cache_Lite = new oledrion_Cache_Lite($this->cacheOptions); |
| 228 |
|
$id = $this->_getIdForCache($sql, $start, $limit); |
| 229 |
|
//$cacheData = $Cache_Lite->get($id); |
|
@@ 308-320 (lines=13) @@
|
| 305 |
|
|
| 306 |
|
//$Cache_Lite = new oledrion_Cache_Lite($this->cacheOptions); |
| 307 |
|
$sql = 'SELECT ' . $this->keyName . ' FROM ' . $this->table; |
| 308 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 309 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 310 |
|
if ($criteria->groupby != '') { |
| 311 |
|
$sql .= $criteria->getGroupby(); |
| 312 |
|
} |
| 313 |
|
if ($criteria->getSort() != '') { |
| 314 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 315 |
|
} elseif ($this->identifierName != '') { |
| 316 |
|
$sql .= ' ORDER BY ' . $this->identifierName; |
| 317 |
|
} |
| 318 |
|
$limit = $criteria->getLimit(); |
| 319 |
|
$start = $criteria->getStart(); |
| 320 |
|
} |
| 321 |
|
|
| 322 |
|
$id = $this->_getIdForCache($sql, $start, $limit); |
| 323 |
|
//$cacheData = $Cache_Lite->get($id); |
|
@@ 357-369 (lines=13) @@
|
| 354 |
|
$sql .= ', ' . $this->identifierName; |
| 355 |
|
} |
| 356 |
|
$sql .= ' FROM ' . $this->table; |
| 357 |
|
if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) { |
| 358 |
|
$sql .= ' ' . $criteria->renderWhere(); |
| 359 |
|
if ($criteria->groupby != '') { |
| 360 |
|
$sql .= $criteria->getGroupby(); |
| 361 |
|
} |
| 362 |
|
if ($criteria->getSort() != '') { |
| 363 |
|
$sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
| 364 |
|
} elseif ($this->identifierName != '') { |
| 365 |
|
$sql .= ' ORDER BY ' . $this->identifierName; |
| 366 |
|
} |
| 367 |
|
$limit = $criteria->getLimit(); |
| 368 |
|
$start = $criteria->getStart(); |
| 369 |
|
} |
| 370 |
|
|
| 371 |
|
$id = $this->_getIdForCache($sql, $start, $limit); |
| 372 |
|
// $cacheData = $Cache_Lite->get($id); |
XoopsModules25x /
oledrion
