protected function _buildQueryJoins(KDatabaseQueryInterface $query)
{
parent::_buildQueryJoins($query);
if ($this->getState()->container) {
$query->join(array('c' => 'files_containers'), 'c.files_container_id = tbl.files_container_id');
}
}
protected function _buildQueryJoins(KDatabaseQueryInterface $query)
{
$state = $this->getState();
parent::_buildQueryJoins($query);
if ($state->table) {
$identity_column = KStringInflector::singularize($state->table) . '_id';
$table = KStringInflector::singularize($state->table) . '_translations';
$query->columns('IFNULL(' . $identity_column . ', 0) AS translated')->columns('IFNULL(r.original, 0) AS original')->join(array('r' => $table), 'r.locale = tbl.lang_code AND r.' . $identity_column . ' = :id', 'left')->bind(array('id' => $state->row));
}
}
protected function _buildQueryJoins(KDatabaseQueryInterface $query)
{
parent::_buildQueryJoins($query);
$query->join('files_containers AS containers', 'containers.files_container_id = tbl.files_container_id', 'INNER');
}
