mambax7 /
extcal
| @@ 133-140 (lines=8) @@ | ||
| 130 | $ret = []; |
|
| 131 | $limit = $start = 0; |
|
| 132 | $sql = 'SELECT * FROM ' . $this->table; |
|
| 133 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
|
| 134 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 135 | if ('' != $criteria->getSort()) { |
|
| 136 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 137 | } |
|
| 138 | $limit = $criteria->getLimit(); |
|
| 139 | $start = $criteria->getStart(); |
|
| 140 | } |
|
| 141 | $result = $this->db->query($sql, $limit, $start); |
|
| 142 | if (!$result) { |
|
| 143 | return $ret; |
|
| @@ 220-227 (lines=8) @@ | ||
| 217 | $sql .= ', ' . $this->identifierName; |
|
| 218 | } |
|
| 219 | $sql .= ' FROM ' . $this->table; |
|
| 220 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
|
| 221 | $sql .= ' ' . $criteria->renderWhere(); |
|
| 222 | if ('' != $criteria->getSort()) { |
|
| 223 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
|
| 224 | } |
|
| 225 | $limit = $criteria->getLimit(); |
|
| 226 | $start = $criteria->getStart(); |
|
| 227 | } |
|
| 228 | $result = $this->db->query($sql, $limit, $start); |
|
| 229 | if (!$result) { |
|
| 230 | return $ret; |
|
