/** * Add new parameters from CSV. */ public function newParameters() { $parameters = Input::get('unknownParameter'); $allParameters = session()->get('unknownParameters'); $allParametersNames = session()->get('unknownParametersNames'); // create parameters foreach ($allParametersNames as $allParameter) { if (in_array($allParameter, $parameters)) { $newParameter = ["DESCRIPTION" => $allParameter, "NAME" => $allParameter]; astParameterModel::create($newParameter); } } // create parameter values foreach ($allParameters as $allParameter) { if (in_array($allParameter['name'], $parameters)) { $parameterId = astParameterModel::where('NAME', '=', $allParameter['name'])->get(); $parameterId = $parameterId[0]->PARAMETER_ID; $newParameterValue = ["PHONE_ID" => $allParameter['PHONE_ID'], "PARAMETER_ID" => $parameterId, "VALUE" => $allParameter['VALUE']]; astPhoneParameterValueModel::create($newParameterValue); } } session()->forget('unknownParameters'); session()->forget('unknownParametersNames'); $query = (new astPhoneModel())->newQuery(); $astPhones = $query->orderBy('MAC')->get(); Session::flash('astMessage', 'Parameters added!'); return View::make('ast.astPhones.index')->with('astPhones', $astPhones); }