| public createFindCommand ( $where = '1=1', $parameters = [], $ordering = [], $limit, $offset, $select = '*' ) : TDbCommand | ||
| return | TDbCommand | query command. |
public function createFindCommand($where = '1=1', $parameters = array(), $ordering = array(), $limit = -1, $offset = -1, $select = '*')
{
$table = $this->getTableInfo()->getTableFullName();
$fields = implode(', ', $this->getSelectFieldList($select));
$sql = "SELECT {$fields} FROM {$table}";
if (!empty($where)) {
$sql .= " WHERE {$where}";
}
return $this->applyCriterias($sql, $parameters, $ordering, $limit, $offset);
}