/**
* Handle the command.
*
* @param Guard $auth
*/
public function handle(Guard $auth)
{
if ($this->entry->created_at) {
$this->entry->updated_at = time();
$this->entry->updated_by = $auth->id();
}
if (!$this->entry->created_at) {
$this->entry->created_at = time();
$this->entry->created_by = $auth->id();
}
if (!$this->entry->sort_order) {
/* @var Builder $query */
$query = $this->entry->newQuery();
$this->entry->sort_order = $query->count('id') + 1;
}
}
/**
* Get the tree entries.
*
* @param TreeBuilder $builder
* @return Collection
*/
public function get(TreeBuilder $builder)
{
// Start a new query.
$query = $this->model->newQuery();
/**
* Prevent joins from overriding intended columns
* by prefixing with the model's tree name.
*/
$query = $query->select($this->model->getTable() . '.*');
/**
* Eager load any relations to
* save resources and queries.
*/
$query = $query->with($builder->getTreeOption('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 TreeIsQuerying($builder, $query));
/**
* Before we actually adjust the baseline query
* set the total amount of entries possible back
* on the tree so it can be used later.
*/
$total = $query->count();
$builder->setTreeOption('total_results', $total);
/**
* Order the query results.
*/
foreach ($builder->getTreeOption('order_by', ['sort_order' => 'asc']) as $column => $direction) {
$query = $query->orderBy($column, $direction);
}
return $query->get();
}
/**
* 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();
}
