public function postSearch() { User::onlyHas('var-edit'); $query = Input::get('varname'); $list = VarLangModel::where(VarLangModel::getField('value'), 'like', "%{$query}%")->get(); $count = count($list); if ($count == 0) { return \Illuminate\Support\Facades\Redirect::back()->with('searchfail', 1); } elseif ($count == 1) { $item = $list[0]; return \Illuminate\Support\Facades\Redirect::to('var/index/' . $item->var_key); } else { return \Illuminate\Support\Facades\Redirect::back()->with('searchfail', 0)->with('searchresult', $list->toArray()); } }
public static function prepareQuery() { return VarModel::join(VarLangModel::getTableName(), VarLangModel::getField('var_key'), '=', VarModel::getField('key'))->select(VarLangModel::getField('*'), DB::raw(VarModel::getField('id') . " as vid"), VarModel::getField('parent_key'), VarModel::getField('key'))->where(VarLangModel::getField('lang_id'), \WebAPL\Language::getId()); }
/** * Load Vars */ protected static function loadVars() { $vars = \VarModel::prepareQuery()->select(\VarModel::getField('key'), \VarLangModel::getField('value'))->get(); $tmpv = array(); foreach ($vars as $var) { $tmpv[$var->key] = $var->value; } static::$vars = $tmpv; }