PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 4.0.8
Visualizer – Tables & Charts Manager with Built-in AI Generator v4.0.8
4.0.8 4.0.7 4.0.6 4.0.5 4.0.4 4.0.3 3.0.5 3.0.6 3.0.7 3.0.8 3.0.9 3.1.0 3.1.1 3.1.2 3.1.3 3.10.0 3.10.1 3.10.10 3.10.11 3.10.12 3.10.13 3.10.14 3.10.15 3.10.2 3.10.3 All 149 releases
← All changes | js/render-google.js +372 -56 3.1.34.0.8 View file →
@@ -3,8 +3,10 @@
3 3 /* global console */
4 4
5 5 // this will store the images for each chart rendered.
6 6 var __visualizer_chart_images = [];
7 +var chartWrapperError = [];
8 +var isResizeRequest = false;
7 9
8 10 (function($) {
9 11 var gv;
10 12 var all_charts, objects;
@@ -11,17 +13,61 @@
11 13 // so that we know which charts belong to our library.
12 14 var rendered_charts = [];
13 15
14 16 function renderChart(id) {
15 - renderSpecificChart(id, all_charts[id]);
17 +
18 + if ( ! all_charts || 0 === Object.keys( all_charts ).length ) {
19 + return;
20 + }
21 +
22 + var chart = all_charts[id];
23 + var hasAnnotation = false;
24 +
25 + if ( ! chart ) {
26 + return;
27 + }
28 +
29 + if ( chart.library && chart.library !== 'google' && chart.library !== 'GoogleCharts' ) {
30 + return;
31 + }
32 +
33 + // re-render the chart only if it doesn't have annotations and it is on the front-end
34 + // this is to prevent the chart from showing "All series on a given axis must be of the same data type" during resize.
35 + // remember, some charts do not support annotations so they should not be included in this.
36 + var no_annotation_charts = ['tabular', 'timeline', 'gauge', 'geo', 'bubble', 'candlestick'];
37 + if ( undefined !== chart.settings && undefined !== chart.settings.series && undefined === chart.settings.series.length ) {
38 + var seriesKeys = Object.keys( chart.settings.series );
39 + // Only convert when keys are numeric indices (PHP JSON-encoded array).
40 + // String keys (e.g. named series from manual config) must be left as-is.
41 + if ( seriesKeys.every( function( k ) { return ! isNaN( k ); } ) ) {
42 + var chartSeries = [];
43 + var chartSeriesValue = Object.values( chart.settings.series );
44 + $.each( seriesKeys, function( index, element ) {
45 + chartSeries[ element ] = chartSeriesValue[ index ];
46 + } );
47 + chart.settings.series = chartSeries;
48 + }
49 + }
50 + if(id !== 'canvas' && typeof chart.series !== 'undefined' && typeof chart.settings.series !== 'undefined' && ! no_annotation_charts.includes(chart.type) ) {
51 + hasAnnotation = chart.series.length - chart.settings.series.length > 1;
52 + }
53 +
54 + if(! hasAnnotation){
55 + renderSpecificChart(id, all_charts[id]);
56 + }
16 57 }
17 58
18 59 function renderSpecificChart(id, chart) {
19 60 var render, container, series, data, table, settings, i, j, row, date, axis, property, format, formatter;
20 61
21 - if(chart.library !== 'google'){
62 + if( chart.library !== 'google' ) {
22 63 return;
23 64 }
65 +
66 + // Bail if the chart is already rendered or is being rendered.
67 + if ( ! window.isResizeRequest && ( $('#' + id).hasClass('visualizer-chart-loaded') || ( 'canvas' !== id && $('#' + id).children( ':not(.loader, style)' ).length > 0 ) ) ) {
68 + return;
69 + }
24 70 rendered_charts[id] = 'yes';
25 71
26 72 series = chart.series;
27 73 data = chart.data;
@@ -35,8 +81,11 @@
35 81
36 82 render = objects[id] || null;
37 83 if (!render) {
38 84 switch (chart.type) {
85 + case "tabular":
86 + render = "Table";
87 + break;
39 88 case "gauge":
40 89 case "table":
41 90 case "timeline":
42 91 render = chart.type.charAt(0).toUpperCase() + chart.type.slice(1);
@@ -45,9 +94,43 @@
45 94 render = chart.type.charAt(0).toUpperCase() + chart.type.slice(1) + 'Chart';
46 95 break;
47 96 }
48 97
49 - render = new gv[render](container);
98 + var controlWrapperElement = document.getElementById( "control_wrapper_" + id ) || null;
99 + var withControlMode = ( typeof settings.controls !== 'undefined' && '' !== settings.controls.controlType ) && controlWrapperElement ? true : false;
100 +
101 + if ( $( controlWrapperElement ).hasClass( 'no-filter' ) ) {
102 + withControlMode = false;
103 + }
104 + if ( withControlMode ) {
105 + // Chart wrapper.
106 + render = new gv.ChartWrapper({
107 + 'chartType': render,
108 + 'containerId': id,
109 + });
110 + // Chart dashboard wrapper.
111 + var chartWrapperElement = document.getElementById( "chart_wrapper_" + id ) || null;
112 + var chartWrapper = new gv.Dashboard( chartWrapperElement );
113 +
114 + // Error Handler.
115 + gv.events.addListener(chartWrapper, 'error', function ( err ) {
116 + if ( chartWrapperError.length === 0 ) {
117 + chartWrapperError.push( err );
118 + gv.errors.removeError( err.id );
119 + var chartContainer = $( chartWrapperElement ).find( '.visualizer-front' );
120 + if ( chartContainer && chartContainer.is(':visible')) {
121 + if (chartContainer.parents('div').next( '#sidebar' ).length === 0) {
122 + chartContainer.addClass( 'visualizer-chart-loaded' ).addClass( 'visualizer-cw-error' );
123 + $( chartWrapperElement ).addClass( 'visualizer-cw-error' );
124 + }
125 + }
126 + } else {
127 + gv.errors.removeError( err.id );
128 + }
129 + } );
130 + } else {
131 + render = new gv[render](container);
132 + }
50 133 }
51 134
52 135 if (settings['animation'] && parseInt(settings['animation']['startup']) === 1)
53 136 {
@@ -53,9 +136,53 @@
53 136 {
54 137 settings['animation']['startup'] = true;
55 138 settings['animation']['duration'] = parseInt(settings['animation']['duration']);
56 139 }
140 + if ( settings['controls'] ) {
141 + settings['controls']['ui']['allowMultiple'] = 'true' === settings['controls']['allowMultiple'] ? true : false;
142 + settings['controls']['ui']['allowTyping'] = 'true' === settings['controls']['allowTyping'] ? true : false;
143 + settings['controls']['ui']['showRangeValues'] = 'true' === settings['controls']['showRangeValues'] ? true : false;
144 + }
57 145
146 + // mark roles for series that have specified a role
147 + // and then remove them from future processing
148 + // and also adjust the indices of the series array so that
149 + // the ones with a role are ignored
150 + // e.g. if there are 6 columns (0-5) out of which 1, 3 and 5 are annotations
151 + // the final series will only include 0, 2, 4 (reindexed as 0, 1, 2)
152 +
153 + // this will capture all the series indexes that became annotations.
154 + var series_annotations = [];
155 + if (settings.series) {
156 + var adjusted_series = [];
157 + for (i = 0; i < settings.series.length; i++) {
158 + if (!series[i + 1] || typeof settings.series[i] === 'undefined') {
159 + continue;
160 + }
161 + if(typeof settings.series[i].role !== 'undefined'){
162 + table.setColumnProperty(i + 1, 'role', settings.series[i].role);
163 + if(settings.series[i].role === '') {
164 + adjusted_series.push(settings.series[i]);
165 + }else{
166 + series_annotations.push(i);
167 + }
168 + }
169 + }
170 + if(adjusted_series.length > 0){
171 + settings.series = adjusted_series;
172 + }
173 + }
174 +
175 + if ( settings['explorer_enabled'] && settings['explorer_enabled'] == 'true' ) { // jshint ignore:line
176 + var $explorer = {};
177 + $explorer['keepInBounds'] = true;
178 +
179 + if ( settings['explorer_actions'] ) {
180 + $explorer['actions'] = settings['explorer_actions'];
181 + }
182 + settings['explorer'] = $explorer;
183 + }
184 +
58 185 switch (chart.type) {
59 186 case 'pie':
60 187 if (settings.slices) {
61 188 for (i in settings.slices) {
@@ -89,8 +216,9 @@
89 216 settings['region'] = 'world';
90 217 }
91 218 break;
92 219 case 'table':
220 + case 'tabular':
93 221 if (parseInt(settings['pagination']) !== 1)
94 222 {
95 223 delete settings['pageSize'];
96 224 }
@@ -96,10 +224,13 @@
96 224 }
97 225 break;
98 226 case 'gauge':
99 227 break;
228 + case 'bubble':
229 + settings.sortBubblesBySize = settings.sortBubblesBySize ? settings.sortBubblesBySize == 1 : false; // jshint ignore:line
230 + break;
100 231 case 'timeline':
101 - settings['timeline'] = [];
232 + settings['timeline'] = {};
102 233 settings['timeline']['groupByRowLabel'] = settings['groupByRowLabel'] ? true : false;
103 234 settings['timeline']['colorByRowLabel'] = settings['colorByRowLabel'] ? true : false;
104 235 settings['timeline']['showRowLabels'] = settings['showRowLabels'] ? true : false;
105 236 if(settings['singleColor'] !== '') {
@@ -155,8 +286,12 @@
155 286
156 287 delete axis.viewWindow[property];
157 288 }
158 289 }
290 +
291 + if(settings.hAxis && settings.hAxis.format == ''){
292 + settings.hAxis.format = 'yyyy-MM-dd';
293 + }
159 294 }
160 295
161 296 if(settings.hAxis){
162 297 if(settings.hAxis.textStyle && settings.hAxis.textStyle !== ''){
@@ -176,16 +311,38 @@
176 311
177 312 for (i = 0; i < data.length; i++) {
178 313 row = [];
179 314 for (j = 0; j < series.length; j++) {
180 - if (series[j].type === 'date' || series[j].type === 'datetime') {
181 - date = new Date(data[i][j]);
182 - data[i][j] = null;
183 - if (Object.prototype.toString.call(date) === "[object Date]") {
184 - if (!isNaN(date.getTime())) {
185 - data[i][j] = date;
186 - }
187 - }
315 + switch(series[j].type) {
316 + case 'string':
317 + if(data[i][j] === ''){
318 + data[i][j] = null;
319 + }
320 + break;
321 + case 'boolean':
322 + if (typeof data[i][j] === 'string'){
323 + data[i][j] = data[i][j] === 'true';
324 + }
325 + break;
326 + case 'date':
327 + // fall-through.
328 + case 'datetime':
329 + if (typeof data[i][j] === 'string') {
330 + var dateParse = Date.parse(data[i][j].replace(/-/g, '/'));
331 + if ( isNaN( dateParse ) ) {
332 + dateParse = Date.parse(data[i][j]);
333 + }
334 + date = new Date( dateParse );
335 + } else if(typeof data[i][j] === 'object') {
336 + date = data[i][j];
337 + }
338 + data[i][j] = null;
339 + if (Object.prototype.toString.call(date) === "[object Date]") {
340 + if (!isNaN(date.getTime())) {
341 + data[i][j] = date;
342 + }
343 + }
344 + break;
188 345 }
189 346 row.push(data[i][j]);
190 347 }
191 348 table.addRow(row);
@@ -193,8 +350,9 @@
193 350
194 351 if (settings.series) {
195 352 switch(chart.type){
196 353 case 'table':
354 + case 'tabular':
197 355 for(i in settings.series){
198 356 i = parseInt(i);
199 357 if (!series[i + 1]) {
200 358 continue;
@@ -202,13 +360,16 @@
202 360 format_data(id, table, series[i + 1].type, settings.series[i].format, i + 1);
203 361 }
204 362 break;
205 363 default:
206 - for (i = 0; i < settings.series.length; i++) {
207 - if (!series[i + 1]) {
208 - continue;
209 - }
210 - format_data(id, table, series[i + 1].type, settings.series[i].format, i + 1);
364 + // Single-pass: walk columns, skip annotation/helper roles, apply formats in order.
365 + var k = 0; // index into settings.series (visible series)
366 + for (var c = 1; c < series.length && k < settings.series.length; c++) { // skip label at 0
367 + if (table.getColumnProperty(c, 'role')) continue; // helper/annotation column
368 + var s = settings.series[k++];
369 + if (!s || !s.format) continue;
370 + if (!series[c]) continue;
371 + format_data(id, table, series[c].type, s.format, c);
211 372 }
212 373 break;
213 374 }
214 375 } else if (chart.type === 'pie' && settings.format && settings.format !== '') {
@@ -213,23 +374,78 @@
213 374 }
214 375 } else if (chart.type === 'pie' && settings.format && settings.format !== '') {
215 376 format_data(id, table, 'number', settings.format, 1);
216 377 }
378 +
379 + if(settings.hAxis && series[0]) {
380 + format_data(id, table, series[0].type, settings.hAxis.format, 0);
381 + }
382 +
217 383 override(settings);
218 384
219 385 gv.events.addListener(render, 'ready', function () {
220 386 var arr = id.split('-');
387 + render = typeof render.getChart !== 'undefined' ? render.getChart() : render;
221 388 __visualizer_chart_images[ arr[0] + '-' + arr[1] ] = '';
389 +
390 + if (render.container && $(render.container).is(':visible')) {
391 + if ($(render.container).parents('div').next( '#sidebar' ).length === 0) {
392 + $(render.container).addClass( 'visualizer-chart-loaded' );
393 + }
394 + }
395 +
222 396 try{
223 - var img = render.getImageURI();
224 - __visualizer_chart_images[ arr[0] + '-' + arr[1] ] = img;
225 - $('body').trigger('visualizer:render:chart', {id: arr[1], image: img});
397 + if ( typeof render.getImageURI !== 'undefined' ) {
398 + var img = render.getImageURI();
399 + __visualizer_chart_images[ arr[0] + '-' + arr[1] ] = img;
400 + $('body').trigger('visualizer:render:chart', {id: arr[1], image: img});
401 + if ( $( '#chart-img' ).length ) {
402 + $( '#chart-img' ).val( img );
403 + }
404 + }
226 405 }catch(error){
227 - console.warn('render.getImageURI not defined for ' + arr[0] + '-' + arr[1]);
406 + var canvas = document.getElementById( 'canvas' );
407 + domtoimage.toPng(canvas)
408 + .then(function ( img ) {
409 + __visualizer_chart_images[ arr[0] + '-' + arr[1] ] = img;
410 + $('body').trigger('visualizer:render:chart', {id: arr[1], image: img});
411 + if ( $( '#chart-img' ).length ) {
412 + $( '#chart-img' ).val( img );
413 + }
414 + })
415 + .catch(function (error) {
416 + console.warn('render.getImageURI not defined for ' + arr[0] + '-' + arr[1]);
417 + });
228 418 }
229 419 });
230 420
231 - render.draw(table, settings);
421 + if ( withControlMode ) {
422 + // alert( chart.is_library_page );
423 + // Create a control wrapper, passing some options.
424 + var controlWrapper = new gv.ControlWrapper( {
425 + containerId: 'control_wrapper_' + id,
426 + controlType: settings.controls.controlType,
427 + 'options': settings.controls,
428 + } );
429 +
430 + $('body').trigger('visualizer:chart:settings:extend', {id: id, chart: chart, settings: settings, data: table});
431 + render.setOptions(settings);
432 + chartWrapper.bind(controlWrapper, render);
433 + chartWrapper.draw(table);
434 +
435 + gv.events.addListener(controlWrapper, 'ready', function ( err ) {
436 + if ( 'vertical' === settings.controls.ui.orientation ) {
437 + if ( 'canvas' === id ) {
438 + jQuery( '#' + id ).addClass( 'vz-vertical' );
439 + }
440 + } else {
441 + jQuery( '#' + id ).removeClass( 'vz-vertical' );
442 + }
443 + });
444 + } else {
445 + $('body').trigger('visualizer:chart:settings:extend', {id: id, chart: chart, settings: settings, data: table});
446 + render.draw(table, settings);
447 + }
232 448 }
233 449
234 450 function format_data(id, table, type, format, index) {
235 451 if (!format || format === '') {
@@ -236,21 +452,32 @@
236 452 return;
237 453 }
238 454
239 455 var formatter = null;
240 - switch (type) {
241 - case 'number':
242 - formatter = new gv.NumberFormat({pattern: format});
243 - break;
244 - case 'date':
245 - case 'datetime':
246 - case 'timeofday':
247 - formatter = new gv.DateFormat({pattern: format});
248 - break;
249 - }
456 + var $formatInput = $('input.control-text[name*="[format]"]').filter(function() {
457 + return $(this).val() === format;
458 + });
459 + try {
460 + switch (type) {
461 + case 'number':
462 + formatter = new gv.NumberFormat({pattern: format});
463 + break;
464 + case 'date':
465 + case 'datetime':
466 + case 'timeofday':
467 + formatter = new gv.DateFormat({pattern: format});
468 + break;
469 + }
250 470
251 - if (formatter) {
252 - formatter.format(table, index);
471 + if (formatter) {
472 + formatter.format(table, index);
473 + $formatInput.nextAll('.visualizer-format-error').remove();
474 + }
475 + } catch (e) {
476 + if ($formatInput.length) {
477 + $formatInput.nextAll('.visualizer-format-error').remove();
478 + $('<p class="visualizer-format-error" style="color:#cc0000;margin:4px 0 0"></p>').text(visualizer.l10n.invalid_format).insertAfter($formatInput);
479 + }
253 480 }
254 481
255 482 var arr = id.split('-');
256 483 $('body').trigger('visualizer:format:chart', {id: parseInt(arr[1]), data: table, column: index});
@@ -270,32 +497,39 @@
270 497 }
271 498
272 499 function render() {
273 500 for (var id in (all_charts || {})) {
274 - renderChart(id);
501 + var chartElement = document.getElementById( id );
502 + if (chartElement && chartElement.offsetParent) {
503 + renderChart(id);
504 + }
275 505 }
276 506 }
277 507
278 - if(typeof visualizer !== 'undefined'){
279 - // called while updating the chart.
280 - visualizer.update = function(){
281 - renderChart('canvas');
282 - };
283 - }
284 -
285 -
286 508 var resizeTimeout;
287 509
288 510 $(document).ready(function() {
289 - $(window).resize(function() {
511 + $(window).resize(function(e) {
290 512 clearTimeout(resizeTimeout);
513 + window.isResizeRequest = 'undefined' !== typeof e.originalEvent ? true : false;
291 514 resizeTimeout = setTimeout(render, 100);
292 515 });
293 516
294 517 resizeHiddenContainers(true);
518 +
519 + if ( $( '.visualizer-hidden-container' ).length ) {
520 + setInterval( function() {
521 + $( '.visualizer-hidden-container' ).find(".visualizer-front:not(.visualizer-chart-loaded)").resize();
522 + }, 500 );
523 + }
524 +
525 + window.addEventListener( 'orientationchange', function() {
526 + $( '.visualizer-chart-loaded' ).removeClass( 'visualizer-chart-loaded' ).resize();
527 + }, false);
295 528 });
296 529
297 530 $(window).on('load', function(){
531 + $( '.visualizer-front:not(.visualizer-chart-loaded)' ).resize();
298 532 resizeHiddenContainers(true);
299 533 });
300 534
301 535 function resizeHiddenContainers(everytime){
@@ -324,15 +558,70 @@
324 558 });
325 559 }
326 560
327 561 $('body').on('visualizer:render:chart:start', function(event, v){
562 + var $chart_types = ['corechart', 'geochart', 'gauge', 'table', 'timeline'];
563 + if(v.is_front == true){ // jshint ignore:line
564 + // check what all chart types to load.
565 + $chart_types = [];
566 + $.each(v.charts, function(i, c){
567 + // Only consider charts rendered by Google Charts.
568 + if ( c.library && c.library !== 'google' && c.library !== 'GoogleCharts' ) {
569 + return;
570 + }
571 + var $type = c.type;
572 + switch($type){
573 + case 'bar':
574 + case 'column':
575 + case 'line':
576 + case 'area':
577 + case 'stepped area':
578 + case 'bubble':
579 + case 'pie':
580 + case 'donut':
581 + case 'combo':
582 + case 'candlestick':
583 + case 'histogram':
584 + case 'scatter':
585 + case 'bubble':
586 + $type = 'corechart';
587 + break;
588 + case 'geo':
589 + $type = 'geochart';
590 + break;
591 + case 'tabular':
592 + case 'table':
593 + $type = 'table';
594 + break;
595 + case 'dataTable':
596 + case 'polarArea':
597 + case 'radar':
598 + $type = null;
599 + break;
600 + }
601 + if($type != null && $type !== ''){
602 + $chart_types.push($type);
603 + }
604 + });
605 + }
606 +
328 607 objects = {};
329 - google.charts.load("current", {packages: ["corechart", "geochart", "gauge", "table", "timeline"], mapsApiKey: v.map_api_key, 'language' : v.language});
330 - google.charts.setOnLoadCallback(function() {
331 - gv = google.visualization;
332 - all_charts = v.charts;
333 - render();
334 - });
608 + if ( 'object' === typeof google ) {
609 + $chart_types.push( 'controls' );
610 + google.load( 'visualization', '51', {packages: $chart_types, mapsApiKey: v.map_api_key, 'language' : v.language,
611 + callback: function () {
612 + gv = google.visualization;
613 + all_charts = v.charts;
614 + if(v.is_front == true && typeof v.id !== 'undefined'){ // jshint ignore:line
615 + if ( document.getElementById( v.id ).offsetParent !== null ) {
616 + renderChart(v.id);
617 + }
618 + } else {
619 + render();
620 + }
621 + }
622 + });
623 + }
335 624 });
336 625
337 626 $('body').on('visualizer:render:specificchart:start', function(event, v){
338 627 objects = {};
@@ -339,18 +628,23 @@
339 628 gv = google.visualization;
340 629 renderSpecificChart(v.id, v.chart);
341 630 });
342 631
632 + $('body').on('visualizer:render:currentchart:update', function(event, v){
633 + renderChart('canvas');
634 + });
635 +
343 636 // front end actions
637 + // 'image' is also called from the library
344 638 $('body').on('visualizer:action:specificchart', function(event, v){
639 + var id = v.id;
640 + if(typeof rendered_charts[id] === 'undefined'){
641 + return;
642 + }
643 + var arr = id.split('-');
644 + var img = __visualizer_chart_images[ arr[0] + '-' + arr[1] ];
345 645 switch(v.action){
346 646 case 'print':
347 - var id = v.id;
348 - if(typeof rendered_charts[id] === 'undefined'){
349 - return;
350 - }
351 - var arr = id.split('-');
352 - var img = __visualizer_chart_images[ arr[0] + '-' + arr[1] ];
353 647 // for charts that have no rendered image defined, we print the data instead.
354 648 var html = v.data;
355 649 if(img !== ''){
356 650 html = "<html><body><img src='" + img + "' /></body></html>";
@@ -356,8 +650,30 @@
356 650 html = "<html><body><img src='" + img + "' /></body></html>";
357 651 }
358 652 $('body').trigger('visualizer:action:specificchart:defaultprint', {data: html});
359 653 break;
654 + case 'image':
655 + if(img !== ''){
656 + var $a = $("<a>"); // jshint ignore:line
657 + $a.attr("href", img);
658 + $("body").append($a);
659 + $a.attr("download", v.dataObj.name);
660 + $a[0].click();
661 + $a.remove();
662 + }else{
663 + console.warn("No image generated");
664 + }
665 + break;
360 666 }
361 667 });
362 668
669 + var timer = 0;
670 + $( document ).on( 'input', '.series-linewidth', function() {
671 + var seriesLineWidth = $( this );
672 + clearTimeout( timer );
673 + timer = setTimeout( function() {
674 + if ( seriesLineWidth.val() != '' && seriesLineWidth.val() <= 0 ) {
675 + seriesLineWidth.val( '0.1' );
676 + }
677 + }, 700 );
678 + } );
363 679 })(jQuery);