/**
* @param EloquentBuilder|QueryBuilder|Model $query
* @param string $key
* @param bool $returnExpression
*
* @return string
*/
public function scopeToSubQuery($query, $key, $returnExpression = false)
{
$index = 0;
$bindings = array();
if (!Str::contains($key, '.')) {
/** @var Model|BetterEloquentTrait $model */
$model = $query->getModel();
$key = $model->getField($key);
}
$sql = $query->select(array($key))->toSql();
foreach ($query->getBindings() as $binding) {
$bindings[] = is_array($binding) ? array_merge($bindings, $binding) : $binding;
}
while (Str::contains($sql, '?')) {
$sql = $this->replaceFirst('?', $bindings[$index++], $sql);
}
$sql = "({$sql})";
return $returnExpression ? new Expression($sql) : $sql;
}
