CWebDavTmpFile::getList

static function getList(array $order = array(), array $filter = array())
{
	$t = static::TABLE_NAME;
	$order = array_intersect_key($order, static::$_columns);
	$sqlWhere = self::buildWhereExpression($filter);

	$sqlOrder = '';
	if($order)
	{
		$sqlOrder = array();
		foreach ($order as $by => $ord)
		{
			$by = mb_strtoupper($by);
			$sqlOrder[] = $by . ' ' . (mb_strtoupper($ord) == 'DESC' ? 'DESC' : 'ASC');
		}
		unset($by);
		$sqlOrder = ' ORDER BY ' . implode(', ', $sqlOrder);
	}

	return static::getDb()->query("SELECT * FROM {$t} {$sqlWhere} {$sqlOrder}");
}