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'); }