PDA

View Full Version : Change data.store to data.jsonstore



thomsonzh
4 Oct 2013, 7:29 AM
Please advise how to convert data.store to data.jsonstore and make it work?

Code as below,
/*
This file is part of Ext JS 3.4

Copyright (c) 2011-2013 Sencha Inc

Contact: http://www.sencha.com/contact

GNU General Public License Usage
This file may be used under the terms of the GNU General Public License version 3.0 as
published by the Free Software Foundation and appearing in the file LICENSE included in the
packaging of this file.

Please review the following information to ensure the GNU General Public License version 3.0
requirements will be met: http://www.gnu.org/copyleft/gpl.html.

If you are unsure which license is appropriate for your use, please contact the sales department
at http://www.sencha.com/contact.

Build date: 2013-04-03 15:07:25
*/
SampleGrid = function(limitColumns){

function italic(value){
return '<i>' + value + '</i>';
}

function change(val){
if(val > 0){
return '<span style="color:green;">' + val + '</span>';
}else if(val < 0){
return '<span style="color:red;">' + val + '</span>';
}
return val;
}

function pctChange(val){
if(val > 0){
return '<span style="color:green;">' + val + '%</span>';
}else if(val < 0){
return '<span style="color:red;">' + val + '%</span>';
}
return val;
}


var columns = [
{id:'company',header: "Company", width: 160, sortable: true, dataIndex: 'company'},
{header: "Price", width: 75, sortable: true, renderer: Ext.util.Format.usMoney, dataIndex: 'price'},
{header: "Change", width: 75, sortable: true, renderer: change, dataIndex: 'change'},
{header: "% Change", width: 75, sortable: true, renderer: pctChange, dataIndex: 'pctChange'},
{header: "Last Updated", width: 85, sortable: true, renderer: Ext.util.Format.dateRenderer('m/d/Y'), dataIndex: 'lastChange'}
];

// allow samples to limit columns
if(limitColumns){
var cs = [];
for(var i = 0, len = limitColumns.length; i < len; i++){
cs.push(columns[limitColumns[i]]);
}
columns = cs;
}

SampleGrid.superclass.constructor.call(this, {
store: new Ext.data.Store({
reader: new Ext.data.ArrayReader({}, [
{name: 'company'},
{name: 'price', type: 'float'},
{name: 'change', type: 'float'},
{name: 'pctChange', type: 'float'},
{name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
]),
data: [
['3m Co',71.72,0.02,0.03,'9/1 12:00am'],
['Alcoa Inc',29.01,0.42,1.47,'9/1 12:00am'],
['Altria Group Inc',83.81,0.28,0.34,'9/1 12:00am'],
['American Express Company',52.55,0.01,0.02,'9/1 12:00am'],
['American International Group, Inc.',64.13,0.31,0.49,'9/1 12:00am'],
['AT&T Inc.',31.61,-0.48,-1.54,'9/1 12:00am'],
['Boeing Co.',75.43,0.53,0.71,'9/1 12:00am'],
['Caterpillar Inc.',67.27,0.92,1.39,'9/1 12:00am'],
['Citigroup, Inc.',49.37,0.02,0.04,'9/1 12:00am'],
['E.I. du Pont de Nemours and Company',40.48,0.51,1.28,'9/1 12:00am'],
['Exxon Mobil Corp',68.1,-0.43,-0.64,'9/1 12:00am'],
['General Electric Company',34.14,-0.08,-0.23,'9/1 12:00am'],
['General Motors Corporation',30.27,1.09,3.74,'9/1 12:00am'],
['Hewlett-Packard Co.',36.53,-0.03,-0.08,'9/1 12:00am'],
['Honeywell Intl Inc',38.77,0.05,0.13,'9/1 12:00am'],
['Intel Corporation',19.88,0.31,1.58,'9/1 12:00am'],
['International Business Machines',81.41,0.44,0.54,'9/1 12:00am'],
['Johnson & Johnson',64.72,0.06,0.09,'9/1 12:00am'],
['JP Morgan & Chase & Co',45.73,0.07,0.15,'9/1 12:00am'],
['McDonald\'s Corporation',36.76,0.86,2.40,'9/1 12:00am'],
['Merck & Co., Inc.',40.96,0.41,1.01,'9/1 12:00am'],
['Microsoft Corporation',25.84,0.14,0.54,'9/1 12:00am'],
['Pfizer Inc',27.96,0.4,1.45,'9/1 12:00am'],
['The Coca-Cola Company',45.07,0.26,0.58,'9/1 12:00am'],
['The Home Depot, Inc.',34.64,0.35,1.02,'9/1 12:00am'],
['The Procter & Gamble Company',61.91,0.01,0.02,'9/1 12:00am'],
['United Technologies Corporation',63.26,0.55,0.88,'9/1 12:00am'],
['Verizon Communications',35.57,0.39,1.11,'9/1 12:00am'],
['Wal-Mart Stores, Inc.',45.45,0.73,1.63,'9/1 12:00am']
]
}),
columns: columns,
autoExpandColumn: 'company',
height:250,
width:600
});


}

Ext.extend(SampleGrid, Ext.grid.GridPanel);

Gary Schlosberg
11 Oct 2013, 3:43 PM
Looks like Ext 3 code so I moved this thread to an Ext 3 forum.

willigogs
12 Oct 2013, 2:59 AM
var data = [
{"company":"3m Co","price":71.72,"change":0.02,"pctchange":0.03,"lastupdated":"9/1 12:00am"},
{"company":"Alcoa Inc","price":29.01,"change":0.42,"pctchange":1.47,"lastupdated":"9/1 12:00am"},
{"company":"Altria Group Inc","price":83.81,"change":0.28,"pctchange":0.34,"lastupdated":"9/1 12:00am"},
{"company":"American Express Company","price":52.55,"change":0.01,"pctchange":0.02,"lastupdated":"9/1 12:00am"},
{"company":"American International Group, Inc.","price":64.13,"change":0.31,"pctchange":0.49,"lastupdated":"9/1 12:00am"},
{"company":"AT&T Inc.","price":31.61,"change":-0.48,"pctchange":-1.54,"lastupdated":"9/1 12:00am"},
{"company":"Boeing Co.","price":75.43,"change":0.53,"pctchange":0.71,"lastupdated":"9/1 12:00am"},
{"company":"Caterpillar Inc.","price":67.27,"change":0.92,"pctchange":1.39,"lastupdated":"9/1 12:00am"},
{"company":"Citigroup, Inc.","price":49.37,"change":0.02,"pctchange":0.04,"lastupdated":"9/1 12:00am"},
{"company":"E.I. du Pont de Nemours and Company","price":40.48,"change":0.51,"pctchange":1.28,"lastupdated":"9/1 12:00am"},
{"company":"Exxon Mobil Corp","price":68.1,"change":-0.43,"pctchange":-0.64,"lastupdated":"9/1 12:00am"},
{"company":"General Electric Company","price":34.14,"change":-0.08,"pctchange":-0.23,"lastupdated":"9/1 12:00am"},
{"company":"General Motors Corporation","price":30.27,"change":1.09,"pctchange":3.74,"lastupdated":"9/1 12:00am"},
{"company":"Hewlett-Packard Co.","price":36.53,"change":-0.03,"pctchange":-0.08,"lastupdated":"9/1 12:00am"},
{"company":"Honeywell Intl Inc","price":38.77,"change":0.05,"pctchange":0.13,"lastupdated":"9/1 12:00am"},
{"company":"Intel Corporation","price":19.88,"change":0.31,"pctchange":1.58,"lastupdated":"9/1 12:00am"},
{"company":"International Business Machines","price":81.41,"change":0.44,"pctchange":0.54,"lastupdated":"9/1 12:00am"},
{"company":"Johnson & Johnson","price":64.72,"change":0.06,"pctchange":0.09,"lastupdated":"9/1 12:00am"},
{"company":"JP Morgan & Chase & Co","price":45.73,"change":0.07,"pctchange":0.15,"lastupdated":"9/1 12:00am"},
{"company":"McDonald\"s Corporation","price":36.76,"change":0.86,"pctchange":2.40,"lastupdated":"9/1 12:00am"},
{"company":"Merck & Co., Inc.","price":40.96,"change":0.41,"pctchange":1.01,"lastupdated":"9/1 12:00am"},
{"company":"Microsoft Corporation","price":25.84,"change":0.14,"pctchange":0.54,"lastupdated":"9/1 12:00am"},
{"company":"Pfizer Inc","price":27.96,"change":0.4,"pctchange":1.45,"lastupdated":"9/1 12:00am"},
{"company":"The Coca-Cola Company","price":45.07,"change":0.26,"pctchange":0.58,"lastupdated":"9/1 12:00am"},
{"company":"The Home Depot, Inc.","price":34.64,"change":0.35,"pctchange":1.02,"lastupdated":"9/1 12:00am"},
{"company":"The Procter & Gamble Company","price":61.91,"change":0.01,"pctchange":0.02,"lastupdated":"9/1 12:00am"},
{"company":"United Technologies Corporation","price":63.26,"change":0.55,"pctchange":0.88,"lastupdated":"9/1 12:00am"},
{"company":"Verizon Communications","price":35.57,"change":0.39,"pctchange":1.11,"lastupdated":"9/1 12:00am"},
{"company":"Wal-Mart Stores, Inc.","price":45.45,"change":0.73,"pctchange":1.63,"lastupdated":"9/1 12:00am"}
]


var store = new Ext.data.JsonStore({
root: 'records',
fields: ['company','price','change','pctchange','lastupdated'],
data: data
});