/**
* 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);
}
