"
);
this.cellTpl.disableFormats = true;
}
this.cellTpl.compile();
},
/**
* Toggle the display of the summary row on/off
* @param {Boolean} visible true to show the summary, false to hide the summary.
*/
toggleSummaries : function(visible){
var el = this.grid.getGridEl();
if(el){
if(visible === undefined){
visible = el.hasClass('x-grid-hide-summary');
}
el[visible ? 'removeClass' : 'addClass']('x-grid-hide-summary');
}
},
renderSummary : function(o, cs){
cs = cs || this.view.getColumnData();
var cfg = this.cm.config;
var buf = [], c, p = {}, cf, last = cs.length-1;
for(var i = 0, len = cs.length; i < len; i++){
c = cs[i];
cf = cfg[i];
p.id = c.id;
p.style = c.style;
p.css = i == 0 ? 'x-grid3-cell-first ' : (i == last ? 'x-grid3-cell-last ' : '');
if(cf.summaryType || cf.summaryRenderer){
p.value = (cf.summaryRenderer || c.renderer)(o.data[c.name], p, o);
}else{
p.value = '';
}
if(p.value == undefined || p.value === "") p.value = " ";
buf[buf.length] = this.cellTpl.apply(p);
}
return this.rowTpl.apply({
tstyle: 'width:'+this.view.getTotalWidth()+';',
cells: buf.join('')
});
},
/**
* @private
* @param {Object} rs
* @param {Object} cs
*/
calculate : function(rs, cs){
var data = {}, r, c, cfg = this.cm.config, cf;
for(var i = 0, len = cs.length; i < len; i++){
c = cs[i];
cf = cfg[i];
if (cf.summaryType == "special") {
data[c.name] = GetSpecialSummary(cf, rs);
} else {
for(var j = 0, jlen = rs.length; j < jlen; j++){
r = rs[j];
if(cf.summaryType){
data[c.name] = Ext.ux.grid.GroupSummary.Calculations[cf.summaryType](data[c.name] || 0, r, c.name, data);
}
}
}
}
return data;
},
doGroupEnd : function(buf, g, cs, ds, colCount){
var data = this.calculate(g.rs, cs);
buf.push('', this.renderSummary({data: data}, cs), '');
},
doWidth : function(col, w, tw){
var gs = this.view.getGroups(), s;
for(var i = 0, len = gs.length; i < len; i++){
s = gs[i].childNodes[2];
s.style.width = tw;
s.firstChild.style.width = tw;
s.firstChild.rows[0].childNodes[col].style.width = w;
}
},
doAllWidths : function(ws, tw){
var gs = this.view.getGroups(), s, cells, wlen = ws.length;
for(var i = 0, len = gs.length; i < len; i++){
s = gs[i].childNodes[2];
s.style.width = tw;
s.firstChild.style.width = tw;
cells = s.firstChild.rows[0].childNodes;
for(var j = 0; j < wlen; j++){
cells[j].style.width = ws[j];
}
}
},
doHidden : function(col, hidden, tw){
var gs = this.view.getGroups(), s, display = hidden ? 'none' : '';
for(var i = 0, len = gs.length; i < len; i++){
s = gs[i].childNodes[2];
s.style.width = tw;
s.firstChild.style.width = tw;
s.firstChild.rows[0].childNodes[col].style.display = display;
}
},
// Note: requires that all (or the first) record in the
// group share the same group value. Returns false if the group
// could not be found.
refreshSummary : function(groupValue){
return this.refreshSummaryById(this.view.getGroupId(groupValue));
},
getSummaryNode : function(gid){
var g = Ext.fly(gid, '_gsummary');
if(g){
return g.down('.x-grid3-summary-row', true);
}
return null;
},
refreshSummaryById : function(gid){
var g = document.getElementById(gid);
if(!g){
return false;
}
var rs = [];
this.grid.store.each(function(r){
if(r._groupId == gid){
rs[rs.length] = r;
}
});
var cs = this.view.getColumnData();
var data = this.calculate(rs, cs);
var markup = this.renderSummary({data: data}, cs);
var existing = this.getSummaryNode(gid);
if(existing){
g.removeChild(existing);
}
Ext.DomHelper.append(g, markup);
return true;
},
doUpdate : function(ds, record){
this.refreshSummaryById(record._groupId);
},
doRemove : function(ds, record, index, isUpdate){
if(!isUpdate){
this.refreshSummaryById(record._groupId);
}
},
/**
* Show a message in the summary row.
*
grid.on('afteredit', function(){
var groupValue = 'Ext Forms: Field Anchoring';
summary.showSummaryMsg(groupValue, 'Updating Summary...');
});
*
* @param {String} groupValue
* @param {String} msg Text to use as innerHTML for the summary row.
*/
showSummaryMsg : function(groupValue, msg){
var gid = this.view.getGroupId(groupValue);
var node = this.getSummaryNode(gid);
if(node){
node.innerHTML = '
grid.on('afteredit', function(){
var groupValue = 'Ext Forms: Field Anchoring';
summary.showSummaryMsg(groupValue, 'Updating Summary...');
setTimeout(function(){ // simulate server call
// HybridSummary class implements updateSummaryData
summary.updateSummaryData(groupValue,
// create data object based on configured dataIndex
{description: 22, estimate: 888, rate: 888, due: new Date(), cost: 8});
}, 2000);
});
*
* @param {String} groupValue
* @param {Object} data data object
* @param {Boolean} skipRefresh (Optional) Defaults to false
*/
updateSummaryData : function(groupValue, data, skipRefresh){
var json = this.grid.store.reader.jsonData;
if(!json.summaryData){
json.summaryData = {};
}
json.summaryData[groupValue] = data;
if(!skipRefresh){
this.refreshSummary(groupValue);
}
},
/**
* Returns the summaryData for the specified groupValue or null.
* @param {String} groupValue
* @return {Object} summaryData
*/
getSummaryData : function(groupValue){
var json = this.grid.store.reader.jsonData;
if(json && json.summaryData){
return json.summaryData[groupValue];
}
return null;
}
});
//backwards compat
Ext.grid.HybridSummary = Ext.ux.grid.HybridSummary;
function GetSpecialSummary(cf, rs)
{
if (cf.dataIndex == "profitFactor") return SpecialSummary_ProfitFactor(rs);
if (cf.dataIndex == "winpc") return SpecialSummary_PercentOf(rs, "winners", "trades");
if (cf.dataIndex == "losepc") return SpecialSummary_PercentOf(rs, "losers", "trades");
if (cf.dataIndex == "averagewin") return SpecialSummary_Divide(rs, "bankedProfit", "winners");
if (cf.dataIndex == "averageloss") return SpecialSummary_Divide(rs, "bankedLoss", "losers");
if (cf.dataIndex == "averagetrade") return SpecialSummary_Divide(rs, "netProfit", "trades");
if (cf.dataIndex == "averagePipWin") return SpecialSummary_Divide(rs, "winningBankedPips", "winners");
if (cf.dataIndex == "averagePipLoss") return SpecialSummary_Divide(rs, "losingBankedPips", "losers");
if (cf.dataIndex == "averageBankedPips") return SpecialSummary_Divide(rs, "totalBankedPips", "trades");
if (cf.dataIndex == "averageLotsTraded") return SpecialSummary_Divide(rs, "lotsTraded", "trades");
}
function SpecialSummary_ProfitFactor(rs)
{
var t_gp = 0;
var t_gl = 0;
for (var j = 0, jlen = rs.length; j < jlen; j++) {
var r = rs[j]; // get a single Record
t_gp += r.get('bankedProfit');
t_gl += r.get('bankedLoss');
}
if (t_gl != 0) {
return t_gp / Math.abs(t_gl);
}
}
function SpecialSummary_PercentOf(rs, field1, field2)
{
var t_f1 = 0;
var t_f2 = 0;
for (var j = 0, jlen = rs.length; j < jlen; j++) {
var r = rs[j]; // get a single Record
t_f1 += r.get(field1);
t_f2 += r.get(field2);
}
if (t_f2 != 0) {
return t_f1 / t_f2 * 100;
}
}
function SpecialSummary_Divide(rs, field1, field2)
{
var t_f1 = 0;
var t_f2 = 0;
for (var j = 0, jlen = rs.length; j < jlen; j++) {
var r = rs[j]; // get a single Record
t_f1 += r.get(field1);
t_f2 += r.get(field2);
}
if (t_f2 != 0) {
return t_f1 / t_f2;
}
}
/**
* @class GetIt.GridPrinter
* @author Ed Spencer (edward@domine.co.uk)
* Helper class to easily print the contents of a grid. Will open a new window with a table where the first row
* contains the headings from your column model, and with a row for each item in your grid's store. When formatted
* with appropriate CSS it should look very similar to a default grid. If renderers are specified in your column
* model, they will be used in creating the table. Override headerTpl and bodyTpl to change how the markup is generated
*
* Usage:
*
* var grid = new Ext.grid.GridPanel({
* colModel: //some column model,
* store : //some store
* });
*
* Ext.ux.GridPrinter.print(grid);
*
*/
Ext.ns('Ext.ux.GridPrinter');
Ext.ux.GridPrinter = {
/**
* Prints the passed grid. Reflects on the grid's column model to build a table, and fills it using the store
* @param {Ext.grid.GridPanel} grid The grid to print
*/
print: function(grid) {
//We generate an XTemplate here by using 2 intermediary XTemplates - one to create the header,
//the other to create the body (see the escaped {} below)
var columns = grid.getColumnModel().config;
//build a useable array of store data for the XTemplate
var data = [];
grid.store.data.each(function(item) {
var convertedData = [];
//apply renderers from column model
for (var key in item.data) {
var value = item.data[key];
Ext.each(columns, function(column) {
if (column.dataIndex == key) {
convertedData[key] = column.renderer ? column.renderer(value) : value;
}
}, this);
}
data.push(convertedData);
});
//use the headerTpl and bodyTpl XTemplates to create the main XTemplate below
var headings = Ext.ux.GridPrinter.headerTpl.apply(columns);
var body = Ext.ux.GridPrinter.bodyTpl.apply(columns);
var html = new Ext.XTemplate(
'',
'',
'',
'',
'',
'' + glbUserId + ' - ' + grid.title + ' grid',
'',
'',
'
',
headings,
'',
body,
'',
'
',
'',
''
).apply(data);
//open up a new printing window, write to it, print it and close
var win = window.open('', 'printgrid');
win.document.write(html);
win.focus();
win.print();
//win.close();
},
/**
* @property stylesheetPath
* @type String
* The path at which the print stylesheet can be found (defaults to '/stylesheets/print.css')
*/
stylesheetPath: glbSiteRoot + 'css/GridPrint.css',
/**
* @property headerTpl
* @type Ext.XTemplate
* The XTemplate used to create the headings row. By default this just uses
elements, override to provide your own
*/
headerTpl: new Ext.XTemplate(
'
',
'',
'
{header}
',
'',
'
'
),
/**
* @property bodyTpl
* @type Ext.XTemplate
* The XTemplate used to create each row. This is used inside the 'print' function to build another XTemplate, to which the data
* are then applied (see the escaped dataIndex attribute here - this ends up as "{dataIndex}")
*/
bodyTpl: new Ext.XTemplate(
'