YUI Library Home

Site Search (YDN & YUIBlog):

# YUI Library Examples: DataTable Control: Complex Example of Multiple Features

# DataTable Control: Complex Example of Multiple Features

A demonstration of several DataTable features combined in one instance. The features implemented in this example require the Drag and Drop and Animation utilities.

View example in new window.

## Sample Code for this Example

Data:

YAHOO.example.Data = { areacodes: [ {areacode: "201", state: "New Jersey"}, {areacode: "202", state: "Washington, DC"}, {areacode: "203", state: "Connecticut"}, ... ] }

CSS:

/* No custom CSS */

Markup:

<div id="complex"></div>

JavaScript:

YAHOO.util.Event.addListener(window, "load", function() { YAHOO.example.MultipleFeatures = function() { // Custom sort handler to sort by state and then by areacode // where a and b are Record instances to compare var sortStates = function(a, b, desc) { // Deal with empty values if(!YAHOO.lang.isValue(a)) { return (!YAHOO.lang.isValue(b)) ? 0 : 1; } else if(!YAHOO.lang.isValue(b)) { return -1; } // First compare by state var comp = YAHOO.util.Sort.compare; var compState = comp(a.getData("state"), b.getData("state"), desc); // If states are equal, then compare by areacode return (compState !== 0) ? compState : comp(a.getData("areacode"), b.getData("areacode"), desc); }; var myColumnDefs = [ {key:"areacode",label:"Area Codes",width:100,resizeable:true,sortable:true}, {key:"state",label:"States",width:250,resizeable:true,sortable:true, sortOptions:{sortFunction:sortStates}}, {key:"notes",label:"Notes (editable)",editor:"textbox",resizeable:true,sortable:true} ]; var myDataSource = new YAHOO.util.DataSource(YAHOO.example.Data.areacodes); myDataSource.responseType = YAHOO.util.DataSource.TYPE_JSARRAY; myDataSource.responseSchema = { fields: ["areacode","state"] }; var myConfigs = { sortedBy:{key:"areacode",dir:"asc"}, paginator: new YAHOO.widget.Paginator({ rowsPerPage: 25, template: YAHOO.widget.Paginator.TEMPLATE_ROWS_PER_PAGE, rowsPerPageOptions: [10,25,50,100], pageLinks: 5 }), draggableColumns:true } var myDataTable = new YAHOO.widget.DataTable("complex", myColumnDefs, myDataSource, myConfigs); myDataTable.subscribe("rowClickEvent",myDataTable.onEventSelectRow); myDataTable.subscribe("cellDblclickEvent",myDataTable.onEventShowCellEditor); myDataTable.subscribe("editorBlurEvent", myDataTable.onEventSaveCellEditor); // When cell is edited, pulse the color of the row yellow var onCellEdit = function(oArgs) { var elCell = oArgs.editor.getTdEl(); var oOldData = oArgs.oldData; var oNewData = oArgs.newData; // Grab the row el and the 2 colors var elRow = this.getTrEl(elCell); var origColor = YAHOO.util.Dom.getStyle(elRow.cells[0], "backgroundColor"); var pulseColor = "#ff0"; // Create a temp anim instance that nulls out when anim is complete var rowColorAnim = new YAHOO.util.ColorAnim(elRow.cells, { backgroundColor:{to:origColor, from:pulseColor}, duration:2}); var onComplete = function() { rowColorAnim = null; YAHOO.util.Dom.setStyle(elRow.cells, "backgroundColor", ""); } rowColorAnim.onComplete.subscribe(onComplete); rowColorAnim.animate(); } myDataTable.subscribe("editorSaveEvent", onCellEdit); return { oDS: myDataSource, oDT: myDataTable }; }(); });

## Configuration for This Example

You can load the necessary JavaScript and CSS for this example from Yahoo's servers. Click here to load the YUI Dependency Configurator with all of this example's dependencies preconfigured.

### YUI Logger Output:

Note: Logging and debugging is currently turned off for this example.

Reload with logging
and debugging enabled.

### DataTable Control Examples:

- Basic Example
- Progressive Enhancement
- Custom Cell Formatting
- Conditional row coloring
- Nested Headers
- JSON Data Over XHR
- XML Data Over XHR With POST
- XML Data with XPath
- Textual Data Over XHR
- Polling the DataSource
- Adding, Updating, and Deleting Rows
- Client-side Pagination
- Client-side Sorting
- Server-side Pagination and Sorting for Dynamic Data
- Integrating Browser History Manager with Server-side Pagination and Sorting
- XY-scrolling, Y-scrolling, and X-scrolling
- Row Selection
- Cell Selection
- Inline Cell Editing
- Showing, Hiding, and Reordering Columns.
- Highlighting Cells, Rows, or Columns
- Reorder Rows with Drag and Drop
- Row Expansion
- Context Menu Integration
- Configuring the Paginator (included with examples for Paginator)
- TabView Integration
- Complex Example of Multiple Features
- Client-side Filtering of Local Data
- Filtering of Dynamic Data
- Datatable with Autocomplete
- Skinning Model
- Ratings (included with examples for ProgressBar Control)
- YQLDataSource (included with examples for DataSource Utility)
- Complex Application (included with examples for Layout Manager)

### More DataTable Control Resources:

- User's Guide (external)
- API Documentation
- Cheat Sheet PDF (external)

Copyright © 2010 Yahoo! Inc. All rights reserved.

Privacy Policy - Terms of Service - Copyright Policy - Job Openings