/**
* Add the constraints for a relationship count query on the same table.
*
* @param \Illuminate\Database\Eloquent\Builder $query
* @param \Illuminate\Database\Eloquent\Builder $parent
* @return \Illuminate\Database\Eloquent\Builder
*/
public function getRelationCountQueryForSelfRelation(Builder $query, Builder $parent)
{
$query->select(new Expression('count(*)'));
$query->from($query->getModel()->getTable() . ' as ' . ($hash = $this->getRelationCountHash()));
$query->getModel()->setTable($hash);
$key = DbDongle::cast($this->wrap($this->getQualifiedParentKeyName()), 'TEXT');
return $query->where($hash . '.' . $this->getPlainForeignKey(), '=', new Expression($key));
}
/**
* Returns the model query with deferred bindings added
*/
public function withDeferred($sessionKey)
{
$modelQuery = $this->query;
$newQuery = $modelQuery->getQuery()->newQuery();
$newQuery->from($this->related->getTable());
/*
* No join table will be used, strip the selected "pivot_" columns
*/
if ($this instanceof BelongsToManyBase) {
$this->orphanMode = true;
}
$newQuery->where(function ($query) use($sessionKey) {
if ($this->parent->exists) {
if ($this instanceof BelongsToManyBase) {
/*
* Custom query for BelongsToManyBase since a "join" cannot be used
*/
$query->whereExists(function ($query) {
$query->from($this->table)->whereRaw(DbDongle::cast($this->getOtherKey(), 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName())->where($this->getForeignKey(), $this->parent->getKey());
});
} else {
/*
* Trick the relation to add constraints to this nested query
*/
$this->query = $query;
$this->addConstraints();
}
}
/*
* Bind (Add)
*/
$query = $query->orWhereExists(function ($query) use($sessionKey) {
$query->from('deferred_bindings')->whereRaw(DbDongle::cast('slave_id', 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName())->where('master_field', $this->relationName)->where('master_type', get_class($this->parent))->where('session_key', $sessionKey)->where('is_bind', 1);
});
});
/*
* Unbind (Remove)
*/
$newQuery->whereNotExists(function ($query) use($sessionKey) {
$query->from('deferred_bindings')->whereRaw(DbDongle::cast('slave_id', 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName())->where('master_field', $this->relationName)->where('master_type', get_class($this->parent))->where('session_key', $sessionKey)->where('is_bind', 0)->whereRaw(DbDongle::parse('id > ifnull((select max(id) from ' . DbDongle::getTablePrefix() . 'deferred_bindings where
' . DbDongle::cast('slave_id', 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName() . ' and
master_field = ? and
master_type = ? and
session_key = ? and
is_bind = ?
), 0)'), [$this->relationName, get_class($this->parent), $sessionKey, 1]);
});
$modelQuery->setQuery($newQuery);
$modelQuery = $this->related->applyGlobalScopes($modelQuery);
return $this->query = $modelQuery;
}
/**
* Returns the model query with deferred bindings added
*/
public function withDeferred($sessionKey)
{
$modelQuery = $this->query;
$newQuery = $modelQuery->getQuery()->newQuery();
$newQuery->from($this->related->getTable());
// A left join so the ON constraint is not strict
if ($this instanceof BelongsToManyBase) {
$this->setLeftJoin($newQuery);
}
$newQuery->where(function ($query) use($sessionKey) {
// Trick the relation to add constraints to this nested query
if ($this->parent->exists) {
$this->query = $query;
if ($this instanceof BelongsToManyBase) {
$this->setWhere();
} else {
$this->addConstraints();
}
}
// Bind (Add)
$query = $query->orWhereExists(function ($query) use($sessionKey) {
$query->from('deferred_bindings')->whereRaw(DbDongle::cast('slave_id', 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName())->where('master_field', $this->relationName)->where('master_type', get_class($this->parent))->where('session_key', $sessionKey)->where('is_bind', true);
});
});
// Unbind (Remove)
$newQuery->whereNotExists(function ($query) use($sessionKey) {
$query->from('deferred_bindings')->whereRaw(DbDongle::cast('slave_id', 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName())->where('master_field', $this->relationName)->where('master_type', get_class($this->parent))->where('session_key', $sessionKey)->where('is_bind', false)->whereRaw(DbDongle::parse('id > ifnull((select max(id) from ' . DbDongle::getTablePrefix() . 'deferred_bindings where
' . DbDongle::cast('slave_id', 'INTEGER') . ' = ' . DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName() . ' and
master_field = ? and
master_type = ? and
session_key = ? and
is_bind = ?
), 0)'), [$this->relationName, get_class($this->parent), $sessionKey, true]);
});
$modelQuery->setQuery($newQuery);
$modelQuery = $this->related->applyGlobalScopes($modelQuery);
return $this->query = $modelQuery;
}
/**
* Returns the related "slave id" key in a database friendly format.
* @return string
*/
protected function getWithDeferredQualifiedKeyName()
{
return DbDongle::cast(DbDongle::getTablePrefix() . $this->related->getQualifiedKeyName(), 'TEXT');
}
