public function asJsonResponse() { $data = []; $total = $amount_displayed = 0; if ($this->model) { $model_name = $this->model; if ($this->columns) { } $sql = $model_name::query()->select($this->columns ?: '*'); $search_info = $this->a->input('search'); if (!empty($search_info['value'])) { foreach ($this->a->input('columns') as $index => $column) { if ($index) { $sql->orWhere($column['name'], 'LIKE', '%' . $search_info['value'] . '%'); } else { $sql->where($column['name'], 'LIKE', '%' . $search_info['value'] . '%'); } } } foreach ($this->a->input('order', []) as $order) { $sql->orderBy($this->a->input('columns')[$order['col']]['name'], $order['dir']); } \Illuminate\Database\Capsule\Manager::enableQueryLog(); $total = $sql->count(); $sql->skip($this->a->input('start')); $models = $sql->take($this->a->input('length'))->get(); $data = $models->toArray(); $total = $total; $amount_displayed = count($models); } $data = ['aaData' => $data, 'iTotalRecords' => $total, 'iTotalDisplayRecords' => $amount_displayed]; return new JsonResponse($data, 200); }
public static function setUpBeforeClass() { $schema = Capsule::schema(); $schema->dropIfExists('categories'); $schema->create('categories', function (\Illuminate\Database\Schema\Blueprint $table) { $table->increments('id'); $table->string('name'); $table->softDeletes(); NestedSet::columns($table); }); Capsule::enableQueryLog(); }
public static function setUpBeforeClass() { $schema = Capsule::schema(); $schema->dropIfExists('menu_items'); Capsule::disableQueryLog(); $schema->create('menu_items', function (\Illuminate\Database\Schema\Blueprint $table) { $table->increments('id'); $table->unsignedInteger('menu_id'); $table->string('title')->nullable(); NestedSet::columns($table); }); Capsule::enableQueryLog(); }