/** * Finds & returns records by custom SQL query * * @param string $sqlQuery Query text (input parameters can be placeholdered by "?") * @param array $sqlParams Parameters array for substitution in query * @param bool $singleItem If true, returns single Record object, else - RecordSet * @return null|static|RecordSet */ public static function findBySql($sqlQuery, $sqlParams = null, $singleItem = false) { if ($singleItem) { $result = self::_dbResult($sqlQuery, $sqlParams); if (!empty($result)) { return new static($result[0]); } return null; } $qualifiedName = Helper::qualifyClassName(get_called_class()); return RecordSet::createFromSql($qualifiedName, $sqlQuery, $sqlParams); }