');
$('table.details TR:odd').each(function(){
// get the next row
$(this).next().hide(); // initially hidden
// add a expand collapse column
$(this).prepend('
');
// first row is table header (0)
// odd rows are content header rows (1, 3, etc..)
// even rows are detail rows (2, 4, etc..)
});
});
*/
$.fn.detailstable.defaults = {
expandImgSrc: '/DesktopModules/ELP.Profile/images/DNN-plus.gif',
collapseImgSrc: '/DesktopModules/ELP.Profile/images/DNN-minus.gif',
hideDetail: true
};
})(jQuery);
var _ChartIndex = 0;
(function($){
$.fn.charttable = function(options){
return this.each(function(){
var l_Table;
var l_TableDiv;
var l_ChartId;
var l_ChartDiv;
var l_ToggleDataLink;
l_Table = $(this);
l_ChartId = 'chart' + (++_ChartIndex);
l_ChartDiv = $('');
l_TableDiv = l_Table.wrap('')
l_TableDiv.hide();
l_TableDiv.before(l_ChartDiv);
//l_ToggleDataLink = $('Show/Hide Data');
l_ToggleDataLink = $('Show/Hide Data');
l_ToggleDataLink.click(function(){ $(l_TableDiv).toggle(); return false; });
l_TableDiv.before(l_ToggleDataLink);
// table first row is header
// table first col is series labels
// table second col is series values
/*
var chart = new Highcharts.Chart({
chart: {
renderTo: l_ChartId,
defaultSeriesType: 'column'
},
title: {
text: 'Data extracted from a HTML table in the page'
},
xAxis: {
categories: ['Apples', 'Pears', 'Plums', 'Bananas', 'Oranges']
},
yAxis: {
title: {
text: 'Units'
}
},
tooltip: {
formatter: function() {
return ''+ this.series.name +' '+
this.y +' '+ this.x.toLowerCase();
}
},
plotOptions: {
column: {
data: 'datatable',
// define a custom data parser function for both series
dataParser: function(data) {
var table = document.getElementById(data),
// get the data rows from the tbody element
rows = table.getElementsByTagName('tbody')[0].getElementsByTagName('tr'),
// define the array to hold the real data
result = [],
// decide which column to use for this series
column = { 'Jane': 0, 'John': 1 }[this.options.name];
// loop through the rows and get the data depending on the series (this) name
for (var i = 0; i < rows.length; i++) {
result.push(
parseInt(
rows[i].getElementsByTagName('td')[column]. // the data cell
innerHTML
)
);
}
return result;
}
}
},
series: [{
name: 'Jane'
}, {
name: 'John'
}]
});
*/
if (l_Table.hasClass('chart-ly')){
//alert('pies');
chart = new Highcharts.Chart({
chart: {
renderTo: l_ChartId//,
//margin: [50, 200, 60, 170]
},
credits: {
enabled: false
},
title: {
text: '' // could be the closest , or table title tag
},
plotArea: {
shadow: null,
borderWidth: null,
backgroundColor: null
},
tooltip: {
formatter: function() {
return ''+ this.point.name +': '+ this.y;// +' %';
}
},
plotOptions: {
pie: {
allowPointSelect: true,
dataLabels: {
enabled: true,
formatter: function() {
return this.point.y;
},
color: 'white',
style: {
font: '11px Trebuchet MS, Verdana, sans-serif'
}
}
}
},
legend: {
layout: 'vertical',
style: {
left: 'auto',
bottom: 'auto',
right: '50px',
top: '100px'
}
},
series: [{
type: 'pie',
name: 'Browser share',
/*data: [
['Firefox', 44.2],
['IE7', 26.6],
{
name: 'IE6',
y: 20,
sliced: true,
selected: true
},
['Chrome', 3.1],
['Safari', 2.7],
['Opera', 2.3],
['Mozilla', 0.4]
]*/
dataParser: function(data) {
//alert('dataParsercalled');
/*var table = document.getElementById(data),
// get the data rows from the tbody element
rows = table.getElementsByTagName('tbody')[0].getElementsByTagName('tr'),
// define the array to hold the real data
result = [],
// decide which column to use for this series
column = { 'Jane': 0, 'John': 1 }[this.options.name];
// loop through the rows and get the data depending on the series (this) name
for (var i = 0; i < rows.length; i++) {
result.push(
parseInt(
rows[i].getElementsByTagName('td')[column]. // the data cell
innerHTML
)
);
}
return result;
*/
l_Results = [];
$('tr:gt(0)', l_Table).each(function(){
l_Results.push([$('td:eq(0)', this).text(), parseFloat($('td:eq(1)', this).text())]);
});
//l_Results.push(['first', 20]);
//l_Results.push(['second', 50]);
//l_Results.push(['third', 70]);
//l_Results.push(50);
//l_Results.push(80);
return l_Results;
}
}]
});
} else if (l_Table.hasClass('chart-xsy')){
//alert('lines');
//l_ChartInfo.series = [];
var l_XAxisLabels = [];
var l_SeriesLabels = [];
var l_Points = [];//= new Object();// = [];
var l_RemoveRows = [];
var l_debug = false;
$('tr:gt(0)', l_Table).each(function(){
var l_Row = $(this)
var l_Cells = l_Row.children('td, th');
if (l_Cells.size() < 3){ l_RemoveRows.push(l_Row); return; }
var l_XLabel = $(l_Cells.get(0)).text();
if (IsEmptyString(l_XLabel)){ l_RemoveRows.push(l_Row); return; }
if($.inArray(l_XLabel, l_XAxisLabels) < 0) l_XAxisLabels.push(l_XLabel);
var l_SeriesLabel = $(l_Cells.get(1)).text();
if (IsEmptyString(l_SeriesLabel)){ l_RemoveRows.push(l_Row); return; }
if($.inArray(l_SeriesLabel, l_SeriesLabels) < 0) l_SeriesLabels.push(l_SeriesLabel);
var l_YValue = parseValue($(l_Cells.get(2)).text());
if (IsEmptyString(l_YValue)){
l_YValue = null;
} else {
//parse it
if (isNaN(l_YValue)){ l_RemoveRows.push(l_Row); return; }
l_YValue = parseFloat(l_YValue);
if (isNaN(l_YValue)){ l_RemoveRows.push(l_Row); return; }
}
l_Points.push([l_SeriesLabel, l_XLabel, l_YValue ]);
//l_Points[l_SeriesLabel][l_XLabel] = l_YValue;
/*
if(l_debug) return;
alert(l_SeriesLabel + ' - ' + l_XLabel + ' - ' + l_YValue);
l_debug=true;
*/
//alert($(l_Cells.get(0)).text());
//for (var i = 0; i < l_Values.length; i++) { if (l_Values[i] === l_Value) { return; } } // already exists
});
for (var l_RemoveRowIndex = l_RemoveRows.length - 1; l_RemoveRowIndex >= 0; l_RemoveRowIndex--) {
var l_RemoveRow = l_RemoveRows[l_RemoveRowIndex];
l_RemoveRow.remove();
//alert('removerow' + l_RemoveRow);
}
var l_XAxisTitle = 'Order Date';//Text:$('th:eq(0),td:eq(0)', $('tr:eq(0)', l_Table)).text()
var l_YAxisTitle = 'Sales';
var l_SeriesTitle = 'Affiliate';
var l_ChartInfo = {
credits: {
enabled: false
},
chart: {
renderTo: l_ChartId,
defaultSeriesType: 'line',
margin: [50, 250, 100, 80]
},
title: {
text: l_SeriesTitle + ' ' + l_YAxisTitle + ' by ' + l_XAxisTitle,
style: {
margin: '10px auto 0 auto'
}
},
/*subtitle: {
text: 'Source: WorldClimate.com',
style: {
margin: '0 100px 0 0' // center it
}
},*/
xAxis: {
title: {
text: l_XAxisTitle
},
categories: l_XAxisLabels,
labels: {
rotation: -45,
align: 'right',
style: {
font: 'normal 11px Verdana, sans-serif'
}
}
},
yAxis: {
title: {
text: l_YAxisTitle
},
plotLines: [{
value: 0,
width: 1,
color: '#A0A0A0'
}]
},
tooltip: {
formatter: function() {
return '' +
'