/**
* Handle the command.
*/
public function handle()
{
$stream = $this->builder->getTableStream();
if (!$stream instanceof StreamInterface) {
return;
}
$eager = [];
if ($stream->isTranslatable()) {
$eager[] = 'translations';
}
$assignments = $stream->getRelationshipAssignments();
foreach ($this->builder->getColumns() as $column) {
/**
* If the column value is a string and uses a dot
* format then check if it's a relation.
*/
if (isset($column['value']) && is_string($column['value']) && preg_match("/^entry.([a-zA-Z\\_]+)./", $column['value'], $match)) {
if ($assignment = $assignments->findByFieldSlug($match[1])) {
if ($assignment->getFieldType()->getNamespace() == 'anomaly.field_type.polymorphic') {
continue;
}
$eager[] = camel_case($match[1]);
}
}
}
$this->builder->setTableOption('eager', array_unique($this->builder->getTableOption('eager', []) + $eager));
}
/**
* Handle the command.
*
* @param Resolver $resolver
* @param Evaluator $evaluator
*/
public function handle(Resolver $resolver, Evaluator $evaluator)
{
$evaluator->evaluate($resolver->resolve($this->builder->getOptions(), ['builder' => $this->builder]), ['builder' => $this->builder]);
foreach ($this->builder->getOptions() as $key => $value) {
$this->builder->setTableOption($key, $value);
}
}
/**
* Get the table entries.
*
* @param TableBuilder $builder
* @return Collection
*/
public function get(TableBuilder $builder)
{
// Grab any stream we have.
$stream = $builder->getTableStream();
// Start a new query.
$query = $this->model->newQuery();
/*
* Prevent joins from overriding intended columns
* by prefixing with the model's table name.
*/
$query = $query->select($this->model->getTable() . '.*');
/*
* Eager load any relations to
* save resources and queries.
*/
$query = $query->with($builder->getTableOption('eager', []));
/*
* Raise and fire an event here to allow
* other things (including filters / views)
* to modify the query before proceeding.
*/
$builder->fire('querying', compact('builder', 'query'));
app('events')->fire(new TableIsQuerying($builder, $query));
/*
* Before we actually adjust the baseline query
* set the total amount of entries possible back
* on the table so it can be used later.
*/
$total = $query->count();
$builder->setTableOption('total_results', $total);
/*
* Assure that our page exists. If the page does
* not exist then start walking backwards until
* we find a page that is has something to show us.
*/
$limit = (int) $builder->getTableOption('limit', config('streams::system.per_page', 15));
$page = app('request')->get($builder->getTableOption('prefix') . 'page', 1);
$offset = $limit * ($page - 1);
if ($total < $offset && $page > 1) {
$url = str_replace($builder->getTableOption('prefix') . 'page=' . $page, $builder->getTableOption('prefix') . 'page=' . ($page - 1), app('request')->fullUrl());
header('Location: ' . $url);
}
/*
* Limit the results to the limit and offset
* based on the page if any.
*/
$offset = $limit * (app('request')->get($builder->getTableOption('prefix') . 'page', 1) - 1);
$query = $query->take($limit)->offset($offset);
/*
* Order the query results.
*/
if ($order = $builder->getTableOption('order_by')) {
foreach ($order as $column => $direction) {
if ($stream && ($utility = $stream->getFieldTypeQuery($column))) {
$utility->orderBy($query, $direction);
} else {
$query = $query->orderBy($column, $direction);
}
}
}
if ($builder->getTableOption('sortable')) {
$query = $query->orderBy('sort_order', 'ASC');
}
return $query->get();
}
