Vue Tables

This Vue component offers an easy and intuitive way of creating and displaying data tables with data coming from the client or from the server using AJAX requests. It includes all the usual features: a search field, limit select, total records, sorting and pagination. The Styling is based on Bootstrap, but of course you can write your own.

Dependencies

• JQuery. Required.
• Vue.js (>=1.0). Required.
• Bootstrap (CSS). Optional.
• Font Awesome (CSS for the sort icons). Optional.

Installation

Option 1

npm install vue-tables

Require the script:

var VueTables = require('vue-tables');

Option 2

Simply import the compiled standalone file into your HTML, which will expose a global VueTables variable.

Usage

Register the component(s)

Vue.use(VueTables.client);
Vue.use(VueTables.server);

Client Side

Add the following element to your page wherever you want it to render. Make sure to wrap it with a parent element you can latch your vue instance into.

<div id="people">
  <v-client-table :data="tableData" :options="options"></v-client-table>
</div>

As the name implies the options prop is optional.

Create a new Vue instance (You can also nest it within other components). An example works best to illustrate the syntax:

new Vue({
  el:"#people",
  data: {
    tableData: [
      {id:1, name:"John",age:"20"},
      {id:2, name:"Jane",age:"24"},
      {id:3, name:"Susan",age:"16"},
      {id:4, name:"Chris",age:"55"},
      {id:5, name:"Dan",age:"40"}
    ],
    options: {
         headings: {
          id:'ID',
          name:'Name',
          age:'Age'
      }
    }
  }
});

Note: you must pass an id field as it is used to track the data for faster rendering. Of course you don't have to show it. See below the columns option.

Check out the live demo

Server side

<div id="people">
  <v-server-table url="/people" :options="options"></v-server-table>
</div>

Javascript:

new Vue({
    el:"#people",
    data: {
      options: {
        headings: {
          id:'ID',
          name:'Name',
          age:'Age'
        }
     }
  }
  });

All the data is passed as GET parameters. You need to return JSON encoded associative array of two items: data and count. Here is an implemenation in Laravel:

extract(Input::all());

$fields = ['id',age','name'];

$direction = $ascending==1?"ASC":"DESC";

$people = Person::select($fields);

if ($query) {
  foreach ($fields as $index=>$field) {
    $method = $index?"orWhere":"where";
    $people = $people->{$method}($field,'LIKE',"%{$query}%");
  }

}

$count = $people->count();

$people->limit($limit)
      ->skip($limit * ($page-1))
      ->orderBy($orderBy,$direction);

return ['data'=>$people->get(),
       'count'=>$count];

Check out the live demo

Options

• headings Object

By default the column names are gleaned from the properties. Use this to set custom headings.

• columns Array

By default all columns passed as data will be displayed. If you want to set explicitly which columns will show use this option.

• sortable Array

By Default all columns (except extras) are sortable. Use this option to explicitly state which columns should be sortable.

• perPage number

Default records-per-page are set to 10. Acceptable values are 5,10,20,50.

• templates Object

Use this to wrap your cell content with a template using wildcards. You can also create new custom columns. e.g:

templates: {
  name:"<b>{name}</b>",
  edit:"<a href='{id}'><i class='fa fa-edit'></i></a>"
}

• texts Object

Override default texts for localization or otherwise. Defaults are:

texts:{
  count:"{count} Records",
  filter:"Filter Results:",
  filterPlaceholder:"Search query",
  limit:"Records:",
  noResults:"No matching records",
  page:"Page:" // for dropdown pagination
}

• pagination object

  • dropdown boolean For large sets of data you can set this option to true to use a dropdown select pagination next to the records-per-page list, instead of links at the bottom of the table.

  • chunk number By Default pagination links are presented in groups of 10, with navigation between the groups. Use this option to set your own chunk size.

• dateFormat string (client-side only)

When passing dates to the client-side component pass a Date object rather than a plain string.

This results in two benefits:

1. Dates are always correctly sorted regardless of their presentation.
2. You are not hardcoding the format into each date property.

By default date will be presented using the native toLocaleDateString() function. To override this behaviour specify your own format:

{
    dateFormat: "M-Y" // e.g "11-2015"
}

The conventions are:

Date:

Y or y - full year

M - Month with leading zeros

m - Month without leading zeros.

D - Day with leading zeros.

d - Day without leading zeros.

Time (separate from date by a single space):

H - 24-hour format of an hour with leading zeros 00 through 23

h - 12-hour format of an hour with leading zeros 01 through 12

G - 24-hour format of an hour without leading zeros

g - 12-hour format of an hour without leading zeros

i - Minutes with leading zeros

s - Seconds, with leading zeros

Spearators:

Date: -, . , / Time : :

If an invalid format was passed it will resort to the default format and spit out a warning to the console.

CSS Note: to center the pagination apply text-align:center to the wrapping element