Watable - A swiss army jQuery table plugin

Watable is a swiss army jQuery table plugin with filter, format, paginate and sort your data with ease and lightning speed. 

• denizli escort
• denizli escort
• didim escort
• düzce escort
• edirne escort
• edirne escort
• edremit escort

Source: wootapa-watable.appspot.com

1. INCLUDE CSS AND JS FILES

<link rel='stylesheet' href="http://netdna.bootstrapcdn.com/bootstrap/3.3.1/css/bootstrap.min.css" />
<link rel='stylesheet' href='watable.css'/>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.js" type="text/javascript"></script>
<script src="http://netdna.bootstrapcdn.com/bootstrap/3.3.1/js/bootstrap.min.js" type="text/javascript"></script>
<script src="jquery.watable.js" type="text/javascript" charset="utf-8"></script>

2. HTML

<div id="example1" style="width:auto"></div>

3. JAVASCRIPT

$('#example1').WATable({
	data: generateSampleData(2)
});
//Generates some data.
function generateSampleData(limit) {
	//First define the columns
	var cols = {
		userId: {
			index: 1, //The order this column should appear in the table
			type: "number", //The type. Possible are string, number, bool, date(in milliseconds).
			friendly: "<span class='glyphicon glyphicon-user'></span>",  //Name that will be used in header. Can also be any html as shown here.
			format: "<a href='#' target='_blank'>{0}</a>",  //Used to format the data anything you want. Use {0} as placeholder for the actual data.
			unique: true,  //This is required if you want checkable rows, databinding or to use the rowClicked callback. Be certain the values are really unique or weird things will happen.
			sortOrder: "asc", //Data will initially be sorted by this column. Possible are "asc" or "desc"
			tooltip: "This column has an initial filter" //Show some additional info about column
			//filter: "1..400" //Set initial filter.
		},
		name: {
			index: 2,
			type: "string",
			friendly: "Name",
			cls: "blue, anotherClass", //apply some css classes
			tooltip: "This column has a custom placeholder and css classes", //Show some additional info about column
			placeHolder: "abc123" //Overrides default placeholder and placeholder specified in data types(row 34).
		},
		age: {
			index: 3,
			type: "number",
			friendly: "Age",
			sorting: true, //dont allow sorting
			tooltip: "This column has filtering and sorting turned off", //Show some additional info about column
			filter: false //Removes filter field for this column
		},
		weight: {
			index: 4,
			type: "number",
			decimals: 2, //Force decimal precision
			friendly: "Weight",
			placeHolder: "50..90",
			format: "{0}kg",
			tooltip: "This column has no tooltip for the filter", //Show some additional info about column
			filterTooltip: false //Turn off tooltip for this column
		},
		height: {
			index: 5,
			type: "number",
			friendly: "Height",
			hidden:true //Hides the column. Useful if you want this value later on but not visible to user. It can be made visible if columnPicker is enabled.
		},
		important: {
			index: 6,
			type: "bool",
			friendly: "Important"
		},
		someDate: {
			index: 7,
			type: "date", //Don't forget dates are expressed in milliseconds
			friendly: "SomeDate"
		},
		someDateDay: {
			index: 8,
			type: "date", //Don't forget dates are expressed in milliseconds
			dateFormat: "dddd", //Special date format
			friendly: "Day"
		}
	};
	/*
	  Create the rows (This step is of course normally done by your web server). 
	  What's worth mentioning is the special row properties. See some examples below.
	  <column>Format allows you to override column format and have it formatted the way you want.
	  <column>Cls allows you to add css classes on the cell(td) element.
	  row-checkable allows you to prevent rows from being checkable.
	  row-checked allows you to pre-check a row.
	  row-cls allows you to add css classes to the row(tr) element.
	*/
	var rows = [];
	var i = 1;
	while(i <= limit)
	{
		//We leave some fields intentionally undefined, so you can see how sorting/filtering works with these.
		var row = {};
		row.userId           = i;
		row.name             = i % 100 == 0 ? undefined : elfName(); //Random name
		row.age              = Math.floor(Math.random() * 50) + 20; //Random age
		row.ageFormat        = row.age + (row.age > 50 ? " (senior)" : " (junior)"); //Special formatting
		row.weight           = (Math.floor(Math.random() * 40) + 50) + (Math.floor(Math.random() * 100) / 100); //Random weight
		row.weightCls        = row.weight < 70 ? 'green' : row.weight < 80 && row.weight >= 70 ? 'yellow' : 'red'; //Add css class to cell
		row.height           = Math.floor(Math.random() * 50) + 150; //Random height
		row.important        = i % 5 == 0 ? 1 : 0; //Random important
		row.someDate         = i % 4 == 0 ? undefined : Date.now() + (i*Math.floor(Math.random()*(60 * 60 * 24 * 100))); //Random date
		row.someDateDay      = row.someDate; //Use same date as above, but its column has different formatting
		row["row-checkable"] = i % 4 != 0; //disable checking for every 4th row
		row["row-checked"]   = i % 3 == 0; //pre check every 3rd row
		row["row-cls"]       = i % 3 == 0 ? "gray, anotherClass" : ""; //apply some row css classes for every 3rd row
		
		row.secret           = { "secret" : "foobar" }; //Add something else that you want later(ex in rowClicked event)
		rows.push(row);
		i++;
	}
	//Create the returning object. Besides cols and rows, you can also pass any other object you would need later on.
	var data = {
		cols: cols,
		rows: rows,
		otherStuff: {
			thatIMight: 1,
			needLater: true
		}
	};
	return data;
}

4. OPTIONS

Init Options

actions: {
  filter: true, //Toggle visibility
  columnPicker: true, //Toggle visibility
  custom: [
    $('<a href="#">someLink</a>'),
    $('<a href="#">anotherLink</a>')
  ]
}

types: {
  string: {
    placeHolder: "Jane Doe", //false for empty
    filterTooltip: "Type something..." //false to remove
  },
  number: {
    //placeHolder: (as string),
    //filterTooltip: (as string),
    decimals: 2 //Decimal precision for floats
  },
  date: {
    //placeHolder: (as string),
    //filterTooltip: (as string),
    utc: true, //Use without timezone
    format: 'yy/dd/MM', 
    datePicker: false
  },
  bool: {
    //filterTooltip: (as string)
  }
}

{ reportId: 15 }

Column Options

<a href="/somewhere/user/{0}" class="myClass">{0}</a>

Row Options

row.ageFormat = "<div class='comeClass'>{0} years</div>";

row.ageCls = "red,green,blue";

5. METHODS

.getData

Returns all data that was collected from server or via .setData method.

.getRow

Returns the row(and array index) related to the unique id.

.option

Get/Set options. If value is left out, it will act as a getter.

.setData

Sets columns and rows.

.update

Collects new data from server. This has no effect if data was set via .setData method.

6. EVENTS