/**
* Method to test quoteName().
*
* @return void
*
* @covers Windwalker\Query\Query::qn
*/
public function testQuoteName()
{
$this->assertEquals('"foo"', $this->instance->quoteName('foo'));
}
/**
* registerQueryTables
*
* @param Query $query
*
* @return Query
*/
public function registerQueryTables(Query $query)
{
foreach ($this->tables as $alias => $table) {
if ($table['join'] == 'FROM') {
$query->from($query->quoteName($table['name']) . ' AS ' . $query->quoteName($alias));
} else {
$query->join($table['join'], $query->quoteName($table['name']) . ' AS ' . $query->quoteName($alias) . ' ' . $table['condition']);
}
}
return $query;
}
/**
* Process ordering query.
*
* @param Query $query The query object.
* @param string $ordering The ordering string.
* @param string $direction ASC or DESC.
*
* @return void
*/
protected function processOrdering(Query $query, $ordering = null, $direction = null)
{
$ordering = $this->state->get('list.ordering', $ordering);
$this->state->set('list.ordering', $ordering);
// If no ordering set, ignore this function.
if (!$ordering) {
return;
}
$self = $this;
$direction = $this->state->get('list.direction', $direction);
$this->state->set('list.direction', $direction);
$ordering = explode(',', $ordering);
// Add quote
$ordering = array_map(function ($value) use($query, $self) {
// Remove extra spaces
preg_replace('/\\s+/', ' ', $value);
$value = explode(' ', trim($value));
// Check it is an allowed field.
if (!$self->filterField($value[0])) {
return '';
}
$field = $this->mapField($value[0]);
if (!empty($field) && $field[strlen($field) - 1] != ')') {
$field = $query->quoteName($field);
}
// $value[1] is direction
if (isset($value[1])) {
return $field . ' ' . $value[1];
}
return $field;
}, $ordering);
$ordering = array_filter($ordering, 'strlen');
$ordering = implode(', ', $ordering);
if (!$ordering) {
return;
}
$query->order($ordering . ' ' . $direction);
}
