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