protected function _buildQueryWhere(Library\DatabaseQuerySelect $query)
{
$state = $this->getState();
if ($state->search) {
$query->where('tbl.title LIKE :search')->bind(array('search' => '%' . $state->search . '%'));
}
if ($this->getState()->table) {
$query->where('tbl.table = :table')->bind(array('table' => $this->getState()->table));
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query)
{
if (!$this->getState()->isUnique()) {
if ($this->getState()->table) {
$query->where('relations.table = :table')->bind(array('table' => $this->getState()->table));
}
if ($this->getState()->row) {
$query->where('relations.row IN :row')->bind(array('row' => (array) $this->getState()->row));
}
}
parent::_buildQueryWhere($query);
}
protected function _buildQueryWhere(Library\DatabaseQuerySelect $query)
{
$state = $this->getState();
if ($state->container) {
$query->where('tbl.files_container_id = :container_id')->bind(array('container_id' => $this->getContainer()->id));
}
if ($state->folder !== false) {
$query->where('tbl.folder = :folder')->bind(array('folder' => ltrim($state->folder, '/')));
}
// Need this for BC
if (!empty($state->files)) {
$query->where('tbl.filename IN :files')->bind(array('files' => $state->files));
} elseif ($state->filename) {
$query->where('tbl.filename IN :filename')->bind(array('filename' => (array) $state->filename));
}
}
