sphinx\QueryBuilder $db

$db public property The Sphinx connection. public yii\sphinx\Connection $db = null

sphinx\QueryBuilder $conditionBuilders

$conditionBuilders protected property Map of query condition to builder methods. These methods are used by buildCondition() to build SQL conditions from array syntax. protected array $conditionBuilders = ['AND' => 'buildAndCondition', 'OR' => 'buildAndCondition', 'BETWEEN' => 'buildBetweenCondition', 'NOT BETWEEN' => 'buildBetweenCondition', 'IN' => 'buildInCondition', 'NOT IN' => 'buildInCondition', 'LIKE' => 'buildLikeCondition', 'NOT LIKE' => 'buildLikeCondition'

sphinx\Query within()

within() public method Sets the WITHIN GROUP ORDER BY part of the query. See also addWithin(). public $this within ( $columns )$columns string|array The columns (and the directions) to find best row within a group. Columns can be specified in either a string (e.g. "id ASC, name DESC") or an array (e.g. ['id' => Query::SORT_ASC, 'name' => Query::SORT_DESC]). The method will automatically quote the column names unless a column contains some parenthesis (which means the column conta

sphinx\Query snippetOptions()

snippetOptions() public method Sets the call snippets query options. See also snippetCallback(). public $this snippetOptions ( $options )$options array Call snippet options in format: option_name => option_value return $this The query object itself

sphinx\Query snippetCallback()

snippetCallback() public method Sets the PHP callback, which should be used to retrieve the source data for the snippets building. See also snippetCallback(). public $this snippetCallback ( $callback )$callback callable PHP callback, which should be used to fetch source data for the snippets. return $this The query object itself

sphinx\Query showMeta()

showMeta() public method Sets whether to automatically perform 'SHOW META' for the search query. See also showMeta(). public $this showMeta ( $showMeta )$showMeta boolean|string|yii\db\Expression Whether to automatically perform 'SHOW META' return $this The query object itself

sphinx\Query setConnection()

setConnection() public method public $this setConnection ( $connection )$connection yii\sphinx\Connection Sphinx connection instance return $this The query object itself

sphinx\Query search()

search() public method Executes the query and returns the complete search result including e.g. hits, facets. public array search ( $db = null )$db yii\sphinx\Connection The Sphinx connection used to generate the SQL statement. return array The query results.

sphinx\Query rightJoin()

rightJoin() public method Appends a RIGHT OUTER JOIN part to the query. public $this rightJoin ( $table, $on = '', $params = [] )$table string|array The table to be joined. Use a string to represent the name of the table to be joined. The table name can contain a schema prefix (e.g. 'public.user') and/or table alias (e.g. 'user u'). The method will automatically quote the table name unless it contains some parenthesis (which means the table is given as a sub-query or DB expression). Us

sphinx\Query queryScalar()

queryScalar() protected method Queries a scalar value by setting select() first. Restores the value of select to make this query reusable. protected boolean|string queryScalar ( $selectExpression, $db )$selectExpression string|yii\db\Expression $db yii\db\Connection|null