public function getIndex() { $locale = Input::get('locale') ?: ''; $group = Input::get('group') ?: ''; $translations = Translation::with('language')->select('transdb_translations.id', 'transdb_translations.message', 'transdb_translations.translation', 'transdb_languages.code')->join('transdb_languages', 'transdb_languages.id', '=', 'language_id'); if ($locale) { $translations->where('transdb_languages.code', '=', $locale); } if ($group) { $translations->where('group_id', '=', $group); } $translations = $translations->get(); $languages = Language::lists('code', 'code'); $groups = Group::lists('name', 'id'); $this->layout->content = View::make('transdb::index')->with('translations', $translations)->with('languages', $languages)->with('groups', $groups); }