collective.js.datatables 4.1.2

Plone Integration of jquery.dataTables plugin

Introduction

DataTables is a plug-in for the jQuery Javascript library. It is a highly flexible tool, based upon the principle of progressive enhancement, which will add advanced interaction controls to any HTML table.

This version includes datatables 1.10.11 without the examples available in the source distribution of the plugin. It is provided with an @@example.datatables view.

Install

A genericsetup profile is provided to add jquery.dataTables to portal_javascript in a minified version with compression option set to none.

Upgrade

WARNING, with 10.0.4 JS, CSS from core plugins were all renamed in the upstream packaging, preprare to update your inclusions urls for plugins JS & CSS!

Key features of jquery.dataTables

• Variable-length pagination

• On-the-fly filtering

• Multi-column sorting with data type detection

• Smart handling of column widths

• Display data from almost any data source

• Scrolling options for table viewport

• Fully internationalisable

• jQueryUI ThemeRoller support

• Rock solid - backed by a suite of 1400+ unit tests

• Wide variety of plug-ins inc. TableTools, FixedHeader and KeyTable

• It’s free!

• State saving

• Hidden columns

• Dynamic creation of tables

• Ajax auto-loading of data

• Custom DOM positioning

• Single-column filtering

• Alternative pagination types

• Non-destructive DOM interaction

• Sorting column(s) highlighting

• Extensive plug-in support

• Fully themeable by CSS

• Solid documentation

• 60+ pre-built examples

• Full support for Adobe AIR

• Source available at github

Plugins

This addon embed extras plugins:

• AutoFill 1.2.1

• ColReorder 1.1.2

• ColVis 1.1.1

• FixedColumns 3.0.2

• FixedHeader 2.1.2

• KeyTable 1.2.1

• Responsive 1.0.3

• Scroller 1.2.2

• TableTools 2.2.3

How to use tabletools

First include dependencies in your template, or register theses in portal_javascripts:

<link rel="stylesheet" type="text/css" media="screen" href="++resource++jquery.datatables/media/css/jquery.dataTables.css">
<link rel="stylesheet" type="text/css" media="screen" href="++resource++jquery.datatables/media/css/jquery.dataTables_themeroller.css">
<link rel="stylesheet" type="text/css" media="screen" href="++resource++jquery.datatables/extras/TableTools/media/css/dataTables.tableTools.min.css">
<script type="text/javascript" src="++resource++jquery.datatables.js"></script>
<script type="text/javascript" src="++resource++jquery.datatables/extras/TableTools/media/js/dataTables.TableTools.js"></script>
<style type="text/css">.clear{clear:both}</style>

Next you can create your datatable:

var oTable = $('#mydatatable').dataTable({
  "sDom": 'T<"clear">lfrtip',
  "oTableTools": {"sSwfPath": "++resource++jquery.datatables/extras/TableTools/media/swf/copy_csv_xls_pdf.swf"}
});

How to use translations

This addon provide translations of datatables. To use translations you have to init your datatables providing sUrl param:

$(document).ready(function() {
  $('#example').dataTable( {
      "oLanguage": {
          "sUrl": "@@collective.js.datatables.translation"
      }
  } );
} );

Credits

Companies

• Planet Makina Corpus

• Contact us

Authors

• JeanMichel FRANCOIS aka toutpt <[e-mail]>

Contributors

• Nejc Zupan (zupo)

• Martijn Pieters

• Luca Fabbri (keul)

• Jens Klein (jensens)

• Mathieu Le Marec - Pasquet (kiorky) <[e-mail]>

• Robert Niederreiter (rnix)

• Peter Holzer (agitator)

Changelog

4.1.2 (2016-09-21)

• Use minified version with added require.js packaging workaround [agitator]

4.1.1 (2016-05-07)

• Added Chinese Simplified translation. [jianaijun]

• Update Datatables to 1.10.11, due to a XSS vulnerability in 1.10.4 (cve-2015-6384) [gemnasium]

4.0.0 (2016-04-25)

• Basic plone 5 support. Split up profiles and register resources the way done in https://github.com/collective/example.p4p5#cssjs-declaration-in-plone-5 [rnix]

3.1.10.5 (2015-06-25)

• Manually disable AMD loading. As long this isn’t included in Mockup, it doesn’t work well with it. [thet]

3.1.10.4 (2015-01-29)

• datatables 1.10.4 MAJOR [kiorky]

• Finnish translation [petri]

2.0.1 (2014-01-25)

• minor fixes to italian translation [keul]

• now activate the minified JS [keul]

2.0 (2012-10-19)

• use zope.i18n.translate directly and avoid resticted python calls. [jensens]

• refactor code to do more genric recursive dict-tree walking.[jensens]

• Update German translation and use more genric word Einträge instaed of Datensätze. [jensens]

• upgrade DataTables to 1.9.4 [toutpt]

1.9.3.1 (2012-08-09)

• Add translations: de, nl, es, it [ebrehault]

• upgrade DataTables to 1.9.3

1.9.2.3 (2012-07-14)

• Add locales folder with french translations [toutpt]

• Add collective.js.datatables.translation view to use translations [toutpt]

• Add italian translations [keul]

1.9.2.2 (2012-06-22)

• update to DataTables to 1.9.2

1.9.2.1 (2012-04-25)

• register css of datatable in cssregistry. [toutpt]

• move example in splited module [toutpt]

1.9.2 (2012-04-24)

• Upgrade all plugins and add documentation about them [toutpt]

• Upgrade jquery.datatables to 1.9.1 [toutpt]

1.9.1 (2012-02-12)

• Add a missing trailing newline in README. [zupo]

• Also increase version number in README. [zupo]

1.9 (2012-02-12)

• Upgrade to the latest version of jquery.datatables. [zupo]

1.8.0.2 (2011-09-26)

• update contributors [toutpt]

1.8.0.1 (2011-08-08)

• Applied commit 547af3f4987d6194438d from github.com/DataTables/TableTools.git that fixes TableTools when using server-side processing. [zupo]

1.8.0 (2011-06-18)

• Upgrade to the latest version of jquery.datatables. [zupo]

1.7.5.2 (2011-05-23)

• Remove compression none in default profile. add upgrade step

1.7.5.1 (2011-01-13)

• Upgrade to the latest version of jquery.datatables. [mj]

1.7.4.3 (2010-11-16)

• Fix packaging issue. [esteele]

1.7.4.2 (2010-11-09)

• Add compatibility with old version from esteele. [toutpt]

1.7.4.1 (2010-11-09)

• Initial release.