public function testUpdate() { $row = $this->table->create(array())->current(); $data = array("created" => new \pq\DateTime("2013-03-03 03:03:03"), "counter" => 2, "number" => 2.2, "data" => "this is a test", "list" => array(3, 2, 1), "prop" => null); $row = $this->table->update(array("id = " => $row->id), $data)->current(); $data = array("id" => $row->id->get()) + $data; $this->assertEquals($data, $row->getData()); }
/** * show all torrent or one based on search. * * @param Request $request * * @return \Illuminate\View\View */ public function index(Request $request) { //$output = \Tmdb::getSearchApi()->searchMovies('saw',array('language' => 'fr')); $perPage = 2; $input = $request->input('q'); $tags = ''; if ($request->input('tags') != '') { $tags = explode(',', $request->input('tags')); } if ($input && !$tags) { $rows = Movie::title($input)->sortAndPaginate($perPage); } elseif ($tags) { $rows = Movie::title($input)->tags($tags)->sortAndPaginate($perPage); } else { $rows = Movie::sortAndPaginate($perPage); } if (!$tags) { $tags = []; } $table = \Table::create($rows, ['test']); $table->addColumn('title', 'Nom', function ($torrent) { return $torrent->title; }); $table->addColumn('created_at', 'Ajouté', function ($torrent) { return $torrent->created_at->diffForHumans(); }); return view('torrents.index', ['table' => $table, 'input' => $input, 'tags' => implode(',', $tags)]); }
public function run() { $faker = Faker::create(); foreach (range(1, 20) as $index) { Table::create(['number' => $index, 'seats' => $faker->randomElement([2, 4, 8]), 'position' => $faker->sentence(1), 'description' => $faker->text(200), 'available' => rand(0, 1), 'image_url' => $faker->imageUrl($width = 640, $height = 480)]); } }
public function search(Request $request) { $post = $request->all(); $query = $post['search']; $result = exam::where('exam_name', 'LIKE', '%' . $query . '%')->paginate(5); $table = \Table::create($result, ['id', 'exam_name', 'total_question', 'duration_per_que', 'mark_per_que', 'passing_marks', 'exam_status']); return view('admin.manage_exam')->with('searchResult', $table); }
public function search(Request $request) { $post = $request->all(); $que = $post['search']; $exam_id = $post['exam_id']; $result = question::where('question', 'LIKE', '%' . $que . '%')->where('exam_id', $exam_id)->paginate(5); $table = \Table::create($result, ['question', 'correct_ans']); return view('admin.manage_questions')->with('searchResult', $table)->with('exam_id', $exam_id); }
public function show($config) { if (empty($config['view'])) { throw new \Exception(__METHOD__ . '. View parameter not defined.'); } if (empty($config['name'])) { throw new \Exception(__METHOD__ . '. Javascript datatable variable name not defined.'); } $other_info = array_key_exists('other-info', $config) ? $config['other-info'] : []; // $this->layout->title = strip_tags($config['caption']); if (!$config['form']) { $form = NULL; } else { $form = $config['form']::make()->other_info($other_info); } return view($config['view'], ['dt' => Table::create($config), 'toolbar' => \View::make($config['toolbar'])->with($other_info)->render(), 'form' => $form] + $other_info); }
$e->addField('openat'); $e->addField('time'); $e->addField('location'); $e->addField('short'); $e->addField('description'); $e->addField('archive'); $e->addField('hashtag'); $e->addField('facebook'); $e->addField('image'); $e->addField('imagesection'); $e->addField('gallery'); $e->addField('audio'); $e->addField('color'); $e->addField('number_staff'); $e->addField('number_visitors'); Table::create('categories', array('title')); $c = new Table('categories'); $c->addField('deleted'); $c->addField('color'); $c->addField('hidden_in_archive'); Table::create('locations', array('title')); $l = new Table('locations'); $l->addField('deleted'); $l->addField('website'); $l->addField('address'); $l->addField('lon'); $l->addField('lat'); // Add Options Option::add('events_image_directory', '/'); Option::add('events_placeholder_archive', ''); Option::add('events_audio_directory', '/');
<?php require_once '../func/admin.class.php'; $authorizer = new Authorizer(); $uid = $authorizer->isLogged(); require_once '../func/admin.class.php'; require_once '../inc/vars.php'; if ($_POST['_check']) { if ($_POST['_name']) { $table = new Table(MT_TABLE); $table->create($_POST['_name']); die('<p>Table created succesfully</p><p><a href="#" onclick="return c_new_table()">Close</a></p>'); } else { echo '<span class="error">Please provide a table name</span>'; } } ?> <div id="form-small"> <form id="new_table" method="post" action=""> <div class="form-row"> <div class="field-label">Table Name</div> <div class="field-widget"><input type="text" name="_name" class="required" size="20"></div> </div> <input type="hidden" name ="_check" value="1"/> <input type="submit" value="Create" onclick="return new_table()"/> </form> </div>
<?php // Create the table if (Table::create('slider', ['title', 'summary', 'link', 'category', 'target', 'order', 'misc_text', 'image'])) { // created a new table } $table = new Table('slider'); $table->updateField('button_class', 'misc_text'); $table->deleteField('has_button'); // Ensure there is a slider snipper (don't overwrite though) $snippets_path = STORAGE . DS . 'snippets' . DS; $install_path = PLUGINS . DS . 'slider' . DS . 'install' . DS; if (!File::exists($snippets_path . 'slider.snippet.php')) { // Copy our default one File::copy($install_path . 'slider.default.snippet.php', $snippets_path . 'slider.snippet.php'); }
protected function renderRows(Rows $rows) { Table::create($rows)->render(); }
public function index() { $result = user::where('status', 1)->sorted()->paginate(5); $table = \Table::create($result, ['name', 'email']); return view('admin.admin_registration')->with('result', $table); }
/** * @expectedException \InvalidArgumentException */ public function testCreateInvalidData() { $table = new Table($this->connection, 'psx_handler_comment', array('foo' => TableInterface::TYPE_VARCHAR)); $table->create('foo'); }