67 lines
1.6 KiB
PHP
67 lines
1.6 KiB
PHP
<?php
|
|
|
|
namespace SilverStripe\ORM;
|
|
|
|
use SilverStripe\ORM\Queries\SQLConditionGroup;
|
|
use SilverStripe\ORM\Queries\SQLSelect;
|
|
|
|
/**
|
|
* Represents a subgroup inside a WHERE clause in a {@link DataQuery}
|
|
*
|
|
* Stores the clauses for the subgroup inside a specific {@link SQLSelect} object.
|
|
* All non-where methods call their DataQuery versions, which uses the base
|
|
* query object.
|
|
*/
|
|
class DataQuery_SubGroup extends DataQuery implements SQLConditionGroup
|
|
{
|
|
|
|
/**
|
|
*
|
|
* @var SQLSelect
|
|
*/
|
|
protected $whereQuery;
|
|
|
|
public function __construct(DataQuery $base, $connective)
|
|
{
|
|
parent::__construct($base->dataClass);
|
|
$this->query = $base->query;
|
|
$this->whereQuery = new SQLSelect();
|
|
$this->whereQuery->setConnective($connective);
|
|
|
|
$base->where($this);
|
|
}
|
|
|
|
public function where($filter)
|
|
{
|
|
if ($filter) {
|
|
$this->whereQuery->addWhere($filter);
|
|
}
|
|
|
|
return $this;
|
|
}
|
|
|
|
public function whereAny($filter)
|
|
{
|
|
if ($filter) {
|
|
$this->whereQuery->addWhereAny($filter);
|
|
}
|
|
|
|
return $this;
|
|
}
|
|
|
|
public function conditionSQL(&$parameters)
|
|
{
|
|
$parameters = [];
|
|
|
|
// Ignore empty conditions
|
|
$where = $this->whereQuery->getWhere();
|
|
if (empty($where)) {
|
|
return null;
|
|
}
|
|
|
|
// Allow database to manage joining of conditions
|
|
$sql = DB::get_conn()->getQueryBuilder()->buildWhereFragment($this->whereQuery, $parameters);
|
|
return preg_replace('/^\s*WHERE\s*/i', '', $sql ?? '');
|
|
}
|
|
}
|