public function create(TableRow $row, array $input) { $type = array_get($input, 'type'); $pairs = array_get($input, $type); foreach ($pairs['names'] as $key => $value) { $pair = new TablePair(['key' => $pairs['names'][$key], 'value' => $pairs['values'][$key]]); $row->pairs()->save($pair); } }
public function create(TableRow $row, array $input) { $v = Validator::make($input, $this->rule); if ($v->fails()) { $exception = new ValidationFailException('Valid failed.'); $exception->setValidator($v); throw $exception; } $input['local_key'] = $row->column_name; $row->relationship()->save(new Relationship($input)); }
public function initialRows() { $table = $this->table_name; $columns = Schema::getColumnListing($table); foreach ($columns as $column) { if (0 != TableRow::where(['column_name' => $column])->count()) { continue; } TableRow::create(['table_name' => $table, 'column_name' => $column, 'type' => 'text', 'creatable' => true, 'editable' => true, 'listable' => true]); } //Delete unused columns TableRow::whereNotIn('column_name', $columns)->delete(); }
/** * 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); }
public function create(TableRow $row, array $range) { $pair = new TablePair(['key' => $range['from'], 'value' => $range['to']]); $row->pairs()->save($pair); }
/** * Show table's rows list * * @Get("table/{table_name}/list", as="table.show") */ public function all($table_name) { $table = Table::where('table_name', $table_name)->first(); $columns_names = TableRow::where('table_name', $table_name)->where('listable', 1)->lists('column_name'); $columns = DB::table($table_name)->select($columns_names)->paginate(15); $needles = DB::table($table_name)->paginate(15)->lists($table->needle); return view('tables.list', compact('columns_names', 'table', 'columns', 'needles')); }