/** * Store crud * * @Post("crud", as="crud.store") */ public function store() { $v = Validator::make(Input::all(), Table::$rules); if ($v->fails()) { $msg = Utils::buildMessages($v->errors()->all()); Flash::error($msg); return redirect()->back()->withErrors($v)->withInput(); } Table::create(Input::all()); Flash::success('CRUD created successfully.'); return redirect()->route('index'); }
/** * Update Settings * * @Post("table/{table_name}/settings", as="setting.update") */ public function postSettings($table) { $columns = Input::get('columns'); foreach ($columns as $column) { $row = TableRow::where('column_name', $column)->where('table_name', $table)->first(); $row_data = Input::get($column); try { $row->updateRow($row_data); } catch (ValidationFailException $e) { Flash::error(Utils::buildMessages($e->getValidator()->errors()->all())); return redirect()->back(); } } Flash::success('Table metadata has been updated.'); return redirect()->route('setting.show', $table); }
/** * Store Row * * @Post("table/{table_name}/create", as="table.store") */ public function store($table) { $columns = TableRow::where('table_name', $table)->where('creatable', 1)->get(); $rules = []; foreach ($columns as $column) { $rules[$column->column_name] = $column->create_rule; } $v = Validator::make(Input::all(), $rules); if ($v->fails()) { $msg = Utils::buildMessages($v->errors()->all()); Flash::error($msg); return redirect()->back()->withErrors($v)->withInput(); } DB::table($table)->insertGetId(Input::except(['_token'])); Flash::success('Entry created successfully.'); return redirect()->route('table.show', $table); }