/**
* 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);
}
