2 * MySlice Hazelnut plugin
3 * URL: http://trac.myslice.info
4 * Description: display a query result in a datatables-powered <table>
5 * Author: The MySlice Team
6 * Copyright (c) 2012 UPMC Sorbonne Universite - INRIA
11 * It's a best practice to pass jQuery to an IIFE (Immediately Invoked Function
12 * Expression) that maps it to the dollar sign so it can't be overwritten by
13 * another library in the scope of its execution.
21 $.fn.Hazelnut = function( method ) {
22 if ( methods[method] ) {
23 return methods[method].apply( this, Array.prototype.slice.call( arguments, 1 ));
24 } else if ( typeof method === 'object' || ! method ) {
25 return methods.init.apply( this, arguments );
27 $.error( 'Method ' + method + ' does not exist on jQuery.Hazelnut' );
31 /***************************************************************************
33 ***************************************************************************/
37 init : function ( options ) {
38 /* Default settings */
39 var options = $.extend( {
43 return this.each(function() {
46 $(this).on('show.Datatables', methods.show);
48 /* An object that will hold private variables and methods */
49 var hazelnut = new Hazelnut (options);
50 if (debug) console.log("Hazelnut object created");
51 $(this).data('Hazelnut', hazelnut);
53 var query_channel = '/query/' + options.query_uuid + '/changed';
54 var update_channel = '/update-set/' + options.query_uuid;
55 var results_channel = '/results/' + options.query_uuid + '/changed';
57 $.subscribe(query_channel, function(e, query) { hazelnut.set_query(query); });;
58 $.subscribe(update_channel, function(e, resources, instance) { hazelnut.set_resources(resources, instance); });
59 $.subscribe(results_channel, function(e, rows) { hazelnut.update_table(rows); });
64 destroy : function( ) {
65 return this.each(function() {
67 var hazelnut = $this.data('Hazelnut');
69 // Unbind all events using namespacing
70 $(window).unbind('Hazelnut');
72 // Remove associated data
74 $this.removeData('Hazelnut');
80 // xxx wtf. why [1] ? would expect 0...
81 var oTable = $($('.dataTable', $this)[1]).dataTable();
82 oTable.fnAdjustColumnSizing()
84 /* Refresh dataTabeles if click on the menu to display it : fix dataTables 1.9.x Bug */
85 $(this).each(function(i,elt) {
86 if (jQuery(elt).hasClass('dataTables')) {
87 var myDiv=jQuery('#hazelnut-' + this.id).parent();
88 if(myDiv.height()==0) {
89 var oTable=$('#hazelnut-' + this.id).dataTable();
99 /***************************************************************************
101 ***************************************************************************/
102 function Hazelnut(options) {
103 /* member variables */
104 this.options = options;
107 // xxx thierry : init this here - it was not, I expect this relied on set_query somehow..
108 //this.current_query = null;
109 this.current_query=manifold.find_query(this.options.query_uuid);
110 this.query_update = null;
111 this.current_resources = Array();
115 /* Transforms the table into DataTable, and keep a pointer to it */
116 this.table = $('#hazelnut-' + options.plugin_uuid).dataTable({
117 // Customize the position of Datatables elements (length,filter,button,...)
119 // http://datatables.net/release-datatables/examples/advanced_init/dom_toolbar.html
120 // http://www.datatables.net/forums/discussion/3914/adding-buttons-to-header-or-footer/p1
121 //"sDom": 'lf<"#datatableSelectAll-'+ options.plugin_uuid+'">rtip',
122 sDom: '<"H"Tfr>t<"F"ip>',
124 sPaginationType: 'full_numbers',
125 // Handle the null values & the error : Datatables warning Requested unknown parameter
126 // http://datatables.net/forums/discussion/5331/datatables-warning-...-requested-unknown-parameter/p2
127 aoColumnDefs: [{sDefaultContent: '',aTargets: [ '_all' ]}],
129 sScrollX: '100%', /* Horizontal scrolling */
130 bProcessing: true, /* Loading */
131 fnRowCallback: function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
132 $(nRow).attr('id', get_value(aData[3]));
135 fnDrawCallback: function() { hazelnut_draw_callback.call(object, options); }
138 /* Setup the SelectAll button in the dataTable header */
139 var oSelectAll = $('#datatableSelectAll-'+ options.plugin_uuid);
140 oSelectAll.html("<span class='ui-icon ui-icon-check' style='float:right;display:inline-block;'></span>Select All");
142 oSelectAll.css('font-size','11px');
143 oSelectAll.css('float','right');
144 oSelectAll.css('margin-right','15px');
145 oSelectAll.css('margin-bottom','5px');
146 oSelectAll.unbind('click');
147 oSelectAll.click(selectAll);
149 /* Spinner (could be done when the query is received = a query is in progress, also for update) */
150 $('#' + options.plugin_uuid).spin()
152 if (debug) console.log ("bing 005");
154 /* Add a filtering function to the current table
155 * Note: we use closure to get access to the 'options'
157 $.fn.dataTableExt.afnFiltering.push(function( oSettings, aData, iDataIndex ) {
158 /* No filtering if the table does not match */
159 if (oSettings.nTable.id != "hazelnut-" + options.plugin_uuid)
161 return hazelnut_filter.call(object, oSettings, aData, iDataIndex);
164 if (debug) console.log ("bing 010");
169 this.set_query = function(query) {
170 if (debug) console.log("entering set_query");
171 var o = this.options;
172 /* Compare current and advertised query to get added and removed fields */
173 previous_query = this.current_query;
174 /* Save the query as the current query */
175 this.current_query = query;
176 /* We check all necessary fields : in column editor I presume XXX */
177 // XXX ID naming has no plugin_uuid
178 if (typeof(query.fields) != 'undefined') {
179 $.each (query.fields, function(index, value) {
180 if (!$('#hazelnut-checkbox-' + o.plugin_uuid + "-" + value).attr('checked'))
181 $('#hazelnut-checkbox-' + o.plugin_uuid + "-" + value).attr('checked', true);
184 /*Process updates in filters / current_query must be updated before this call for filtering ! */
188 * Process updates in fields
190 if (typeof(query.fields) != 'undefined') {
191 /* DataTable Settings */
192 var oSettings = this.table.dataTable().fnSettings();
193 var cols = oSettings.aoColumns;
194 var colnames = cols.map(function(x) {return x.sTitle});
195 colnames = $.grep(colnames, function(value) {return value != "+/-";});
197 if (previous_query == null) {
198 var added_fields = query.fields;
199 var removed_fields = colnames;
200 removed_fields = $.grep(colnames, function(x) { return $.inArray(x, added_fields) == -1});
202 var tmp = previous_query.diff_fields(query);
203 var added_fields = tmp.added;
204 var removed_fields = tmp.removed;
207 /* Hide/unhide columns to match added/removed fields */
209 $.each(added_fields, function (index, field) {
210 var index = object.getColIndex(field,cols);
212 object.table.fnSetColumnVis(index, true);
214 $.each(removed_fields, function (index, field) {
215 var index = object.getColIndex(field,cols);
217 object.table.fnSetColumnVis(index, false);
222 this.set_resources = function(resources, instance) {
223 if (debug) console.log("entering set_resources");
224 var o = this.options;
225 var previous_resources = this.current_resources;
226 this.current_resources = resources;
228 /* We uncheck all checkboxes ... */
229 $('hazelnut-checkbox-' + o.plugin_uuid).attr('checked', false);
230 /* ... and check the ones specified in the resource list */
231 $.each(this.current_resources, function(index, urn) {
232 $('#hazelnut-checkbox-' + o.plugin_uuid + "-" + urn).attr('checked', true)
238 * @brief Determine index of key in the table columns
242 this.getColIndex = function(key, cols) {
243 var tabIndex = $.map(cols, function(x, i) { if (x.sTitle == key) return i; });
244 return (tabIndex.length > 0) ? tabIndex[0] : -1;
249 * XXX will be removed/replaced
251 this.selected_changed = function(e, change) {
252 if (debug) console.log("entering selected_changed");
253 var actions = change.split("/");
254 if (actions.length > 1) {
255 var oNodes = this.table.fnGetNodes();
256 var myNode = $.grep(oNodes, function(value) {
257 if (value.id == actions[1]) { return value; }
259 if( myNode.length>0 ) {
260 if ((actions[2]=="add" && actions[0]=="cancel") || actions[0]=="del")
263 checked="checked='checked' ";
264 var newValue = this.checkbox(actions[1], 'node', checked, false);
265 var columnPos = this.table.fnSettings().aoColumns.length - 1;
266 this.table.fnUpdate(newValue, myNode[0], columnPos);
277 * @param selected_str
278 * @param disabled_str
280 this.checkbox = function(plugin_uuid, header, field, selected_str, disabled_str) {
281 /* Prefix id with plugin_uuid */
282 return "<input class='hazelnut-checkbox-" + plugin_uuid + "' id='hazelnut-checkbox-" + plugin_uuid + "-" + get_value(header) + "' name='" + get_value(field) + "' type='checkbox' " + selected_str + disabled_str + "autocomplete='off' value='" + get_value(header) + "'></input>";
285 this.update_table = function(rows) {
286 var o = this.options;
289 $('#' + o.plugin_uuid).spin(false)
290 if (rows.length==0) {
291 this.table.html(errorDisplay("No Result"));
294 if (typeof(rows[0].error) != 'undefined') {
295 this.table.html(errorDisplay(rows[0].error));
299 newlines = new Array();
301 this.current_resources = Array();
303 $.each(rows, function(index, obj) {
304 newline = new Array();
306 // go through table headers to get column names we want
307 // in order (we have temporarily hack some adjustments in names)
308 var cols = object.table.fnSettings().aoColumns;
309 var colnames = cols.map(function(x) {return x.sTitle})
310 var nb_col = colnames.length;
313 for (var j = 0; j < nb_col; j++) {
314 if (typeof colnames[j] == 'undefined') {
316 } else if (colnames[j] == 'hostname') {
317 if (obj['type'] == 'resource,link')
318 //TODO: we need to add source/destination for links
321 newline.push(obj['hostname']);
323 if (obj[colnames[j]])
324 newline.push(obj[colnames[j]]);
332 if (typeof(obj['sliver']) != 'undefined') { /* It is equal to null when <sliver/> is present */
333 checked = 'checked ';
334 object.current_resources.push(obj['urn']);
336 // Use a key instead of hostname (hard coded...)
337 newline.push(object.checkbox(o.plugin_uuid, obj['urn'], obj['type'], checked, false));
340 newlines.push(newline);
345 this.table.fnAddData(newlines);
349 /***************************************************************************
351 ***************************************************************************/
354 * @brief Hazelnut filtering function
356 function hazelnut_filter (oSettings, aData, iDataIndex) {
357 var cur_query = this.current_query;
360 /* We have an array of filters : a filter is an array (key op val)
361 * field names (unless shortcut) : oSettings.aoColumns = [ sTitle ]
362 * can we exploit the data property somewhere ?
363 * field values (unless formatting) : aData
364 * formatting should leave original data available in a hidden field
366 * The current line should validate all filters
368 $.each (cur_query.filter, function(index, filter) {
369 /* XXX How to manage checkbox ? */
372 var value = filter[2];
374 /* Determine index of key in the table columns */
375 var col = $.map(oSettings.aoColumns, function(x, i) {if (x.sTitle == key) return i;})[0];
377 /* Unknown key: no filtering */
378 if (typeof(col) == 'undefined')
381 col_value=get_value(aData[col]);
382 /* Test whether current filter is compatible with the column */
383 if (op == '=' || op == '==') {
384 if ( col_value != value || col_value==null || col_value=="" || col_value=="n/a")
386 }else if (op == '!=') {
387 if ( col_value == value || col_value==null || col_value=="" || col_value=="n/a")
390 if ( parseFloat(col_value) >= value || col_value==null || col_value=="" || col_value=="n/a")
393 if ( parseFloat(col_value) <= value || col_value==null || col_value=="" || col_value=="n/a")
395 } else if(op=='<=' || op=='≤') {
396 if ( parseFloat(col_value) > value || col_value==null || col_value=="" || col_value=="n/a")
398 } else if(op=='>=' || op=='≥') {
399 if ( parseFloat(col_value) < value || col_value==null || col_value=="" || col_value=="n/a")
402 // How to break out of a loop ?
403 alert("filter not supported");
411 function hazelnut_draw_callback() {
412 var o = this.options;
414 * Handle clicks on checkboxes: reassociate checkbox click every time
415 * the table is redrawn
417 $('.hazelnut-checkbox-' + o.plugin_uuid).unbind('click');
418 $('.hazelnut-checkbox-' + o.plugin_uuid).click({instance: this}, check_click);
423 /* Remove pagination if we show only a few results */
424 var wrapper = this.table; //.parent().parent().parent();
425 var rowsPerPage = this.table.fnSettings()._iDisplayLength;
426 var rowsToShow = this.table.fnSettings().fnRecordsDisplay();
427 var minRowsPerPage = this.table.fnSettings().aLengthMenu[0];
429 if ( rowsToShow <= rowsPerPage || rowsPerPage == -1 ) {
430 $('.hazelnut_paginate', wrapper).css('visibility', 'hidden');
432 $('.hazelnut_paginate', wrapper).css('visibility', 'visible');
435 if ( rowsToShow <= minRowsPerPage ) {
436 $('.hazelnut_length', wrapper).css('visibility', 'hidden');
438 $('.hazelnut_length', wrapper).css('visibility', 'visible');
442 function check_click (e) {
443 var object = e.data.instance;
444 var value = this.value;
447 object.current_resources.push(value);
449 tmp = $.grep(object.current_resources, function(x) { return x != value; });
450 object.current_resources = tmp;
453 /* inform slice that our selected resources have changed */
454 $.publish('/update-set/' + object.options.query_uuid, [object.current_resources, true]);
458 function selectAll() {
459 // requires jQuery id
460 var uuid=this.id.split("-");
461 var oTable=$("#hazelnut-"+uuid[1]).dataTable();
462 // Function available in Hazelnut 1.9.x
463 // Filter : displayed data only
464 var filterData = oTable._('tr', {"filter":"applied"});
465 /* TODO: WARNING if too many nodes selected, use filters to reduce nuber of nodes */
466 if(filterData.length<=100){
467 $.each(filterData, function(index, obj) {
468 var last=$(obj).last();
469 var key_value=get_value(last[0]);
470 if(typeof($(last[0]).attr('checked'))=="undefined"){
471 $.publish('selected', 'add/'+key_value);