123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382 |
- Ext.define('erp.view.pm.make.MakeResourceGrid',{
- extend: 'Ext.grid.Panel',
- alias: 'widget.erpQueryGridPanel',
- requires: ['erp.view.core.grid.HeaderFilter'],
- id: 'grid',
- emptyText : $I18N.common.grid.emptyText,
- columnLines : true,
- autoScroll : true,
- multiselected: [],
- store: [],
- columns: [],
- bodyStyle: 'background-color:#f1f1f1;',
- headerCt: Ext.create("Ext.grid.header.Container",{
- forceFit: false,
- sortable: true,
- enableColumnMove:true,
- enableColumnResize:true,
- enableColumnHide: true
- }),
- invalidateScrollerOnRefresh: false,
- viewConfig: {
- trackOver: false
- },
- buffered: true,
- sync: true,
- _noc:1,
- bbar: {xtype: 'toolbar',id:'toolbar',
- items:[{
- xtype:'tbtext',
- id:'gridcount'
- }]
- },
- features : [Ext.create('Ext.grid.feature.Grouping',{
- //startCollapsed: true,
- hideGroupedHeader: true,
- groupHeaderTpl: '{name} (Count:{rows.length})'
- }),{
- ftype : 'summary',
- showSummaryRow : false,//不显示默认合计行
- generateSummaryData: function(){
- var me = this,
- data = {},
- store = me.view.store,
- columns = me.view.headerCt.getColumnsForTpl(),
- i = 0,
- length = columns.length,
- //fieldData,
- //key,
- comp;
- //将feature的data打印在toolbar上面
- for (i = 0, length = columns.length; i < length; ++i) {
- comp = Ext.getCmp(columns[i].id);
- data[comp.id] = me.getSummary(store, comp.summaryType, comp.dataIndex, false);
- var tb = Ext.getCmp(columns[i].dataIndex + '_' + comp.summaryType);
- if(tb){
- tb.setText(tb.text.split(':')[0] + ':' + data[comp.id]);
- }
- }
- return data;
- }
- }],
- selModel: Ext.create('Ext.selection.CheckboxModel',{
- ignoreRightMouseSelection : false,
- listeners:{
- selectionchange:function(selectionModel, selected, options){
-
- }
- },
- getEditor: function(){
- return null;
- },
- onRowMouseDown: function(view, record, item, index, e) {//改写的onRowMouseDown方法
- var me = Ext.getCmp('grid');
- var bool = true;
- var items = me.selModel.getSelection();
- Ext.each(items, function(item, index){
- if(this.index == record.index){
- bool = false;
- me.selModel.deselect(record);
- Ext.Array.remove(items, item);
- Ext.Array.remove(me.multiselected, record);
- }
- });
- Ext.each(me.multiselected, function(item, index){
- items.push(item);
- });
- me.selModel.select(items);
- if(bool){
- view.el.focus();
- var checkbox = item.childNodes[0].childNodes[0].childNodes[0];
- if(checkbox.getAttribute && checkbox.getAttribute('class') == 'x-grid-row-checker'){
- me.multiselected.push(record);
- items.push(record);
- me.selModel.select(items);
- } else {
- me.selModel.deselect(record);
- Ext.Array.remove(me.multiselected, record);
- }
- }
- me.summary();
- },
- onHeaderClick: function(headerCt, header, e) {
- if (header.isCheckerHd) {
- e.stopEvent();
- var isChecked = header.el.hasCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');
- if (isChecked) {
- this.deselectAll(true);
- var grid = Ext.getCmp('grid');
- this.deselect(grid.multiselected);
- grid.multiselected = new Array();
- var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
- Ext.each(els, function(el, index){
- el.setAttribute('class','x-grid-row-checker');
- });
- header.el.removeCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
- } else {
- var grid = Ext.getCmp('grid');
- this.deselect(grid.multiselected);
- grid.multiselected = new Array();
- var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
- Ext.each(els, function(el, index){
- el.setAttribute('class','x-grid-row-checker');
- });
- this.selectAll(true);
- header.el.addCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
- }
- }
- Ext.getCmp('grid').summary();
- }
- }),
- initComponent : function(){
- this.GridUtil = Ext.create('erp.util.GridUtil');
- this.BaseUtil = Ext.create('erp.util.BaseUtil');
- this.RenderUtil = Ext.create('erp.util.RenderUtil');
- condition = this.BaseUtil.getUrlParam('urlcondition');
- condition = (condition == null) ? "" : condition;
- condition = condition.replace(/@/,"'%").replace(/@/,"%'");
- this.defaultCondition = condition;
- var gridParam = {caller: caller, condition: condition,_noc:this.BaseUtil.getUrlParam('_noc')};
- this.GridUtil.getGridColumnsAndStore(this, 'common/singleGridPanel.action?', gridParam, "");
-
- this.callParent(arguments);
- this.initRecords();
- },
- /*getGridColumnsAndStore: function(grid, url, param, no){
- var me = this;
- me.setLoading(true);//loading...
- Ext.Ajax.request({//拿到grid的columns
- url : basePath + url,
- params: param,
- method : 'post',
- async: false,
- callback : function(options,success,response){
- me.setLoading(false);
- var res = new Ext.decode(response.responseText);
- if(res.exceptionInfo){
- showError(res.exceptionInfo);return;
- }
- if(me.columns && me.columns.length > 2){
- var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];
- me.store.loadData(data);
- //解决固定列左右不对齐的情况
- var lockedView = me.view.lockedView;
- if(lockedView){
- var tableEl = lockedView.el.child('.x-grid-table');
- if(tableEl){
- tableEl.dom.style.marginBottom = '7px';
- }
- }
- me.initRecords();
- } else {
- if(res.columns){
- Ext.each(res.columns, function(column, y){
- me.setRenderer(column);
- var logic = column.logic;
- if(logic != null){
- me.setLogicType(column, logic, y);
- }
- });
- //store
- me.store = me.setDefaultStore(res.data, res.fields);
- //view
- if(me.selModel.views == null){
- me.selModel.views = [];
- }
- if(res.dbfinds.length > 0){
- me.dbfinds = res.dbfinds;
- }
- //toolbar
- me.setToolbar(res.columns);
- //reconfigure store&columns
- me.columns = res.columns;
- }
- }
- }
- });
- },*/
- getMultiSelected: function(){
- var grid = this;
- var items = grid.selModel.getSelection();
- Ext.each(items, function(item, index){
- if(this.data[grid.keyField] != null && this.data[grid.keyField] != ''
- && this.data[grid.keyField] != '0' && this.data[grid.keyField] != 0){
- grid.multiselected.push(item);
- }
- });
- return Ext.Array.unique(grid.multiselected);
- },
- setRenderer: function(column){
- var grid = this;
- if(!column.haveRendered && column.renderer != null && column.renderer != ""){
- var renderName = column.renderer;
- if(contains(column.renderer, ':', true)){
- var args = new Array();
- Ext.each(column.renderer.split(':'), function(a, index){
- if(index == 0){
- renderName = a;
- } else {
- args.push(a);
- }
- });
- if(!grid.RenderUtil.args[renderName]){
- grid.RenderUtil.args[renderName] = new Object();
- }
- grid.RenderUtil.args[renderName][column.dataIndex] = args;
- }
- column.renderer = grid.RenderUtil[renderName];
- column.haveRendered = true;
- }
- },
- setLogicType: function(column, logic, y){
- var grid = this;
- if(logic == 'detno'){
- grid.detno = column.dataIndex;
- } else if(logic == 'keyField'){
- grid.keyField = column.dataIndex;
- } else if(logic == 'mainField'){
- grid.mainField = column.dataIndex;
- } else if(logic == 'necessaryField'){
- grid.necessaryField = column.dataIndex;
- if(!grid.necessaryFields){
- grid.necessaryFields = new Array();
- }
- grid.necessaryFields.push(column.dataIndex);
- if(!column.haveRendered){
- column.renderer = function(val, meta, record, x, y, store, view){
- var c = this.columns[y];
- if(val != null && val.toString().trim() != ''){
- if(c.xtype == 'datecolumn'){
- val = Ext.Date.format(val, 'Y-m-d');
- }
- return val;
- } else {
- if(c.xtype == 'datecolumn'){
- val = '';
- }
- return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
- '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
- }
- };
- }
- } else if(logic == 'groupField'){
- grid.groupField = column.dataIndex;
- }
- },
- setToolbar: function(columns){
- var grid = this;
- var items = [];
- Ext.each(columns, function(column){
- if(column.summaryType == 'sum'){
- items.push('-',{
- id: column.dataIndex + '_sum',
- itemId: column.dataIndex,
- xtype: 'tbtext',
- text: column.text + '(sum):0'
- });
- } else if(column.summaryType == 'average') {
- items.push('-',{
- id: column.dataIndex + '_average',
- itemId: column.dataIndex,
- xtype: 'tbtext',
- text: column.text + '(average):0'
- });
- } else if(column.summaryType == 'count') {
- items.push('-',{
- id: column.dataIndex + '_count',
- itemId: column.dataIndex,
- xtype: 'tbtext',
- text: column.text + '(count):0'
- });
- }
- });
- grid.bbar = {
- xtype: 'toolbar',
- dock: 'bottom',
- items: items
- };
- },
- setDefaultStore: function(d, f){
- var me = this;
- var data = [];
- if(!d || d.length == 2){
- me.GridUtil.add10EmptyData(me.detno, data);
- me.GridUtil.add10EmptyData(me.detno, data);
- } else {
- data = Ext.decode(d.replace(/,}/g, '}').replace(/,]/g, ']'));
- }
- var store = Ext.create('Ext.data.Store', {
- fields: f,
- data: data,
- pageSize: 30,
- buffered: true,
- purgePageCount: 0,
- groupField: me.groupField,
- autoLoad:false,
- listeners:{
- load:function(store){
- store.guaranteeRange(0, 29);
- }
- },
- getSum: function(field) {
- var records = me.selModel.getSelection(),
- total = 0,
- i = 0,
- len = records.length;
- for (; i < len; ++i) {
- total += records[i].get(field);
- }
- return total;
- },
- getCount: function() {
- var records = me.selModel.getSelection(),
- count = 0;
- Ext.each(records, function(item){
- count++;
- });
- return count;
- },
- getAverage: function(field) {
- var records = me.selModel.getSelection(),
- count = 0,
- sum = 0;
- Ext.each(records, function(item){
- if(item.data[me.necessaryField] != null && item.data[me.necessaryField] != ''){
- count++;sum += item.data[field];
- }
- });
- return Ext.Number.format(sum/count, '0.00');
- }
- });
- return store;
- },
- /**
- * 修改为selection改变时,summary也动态改变
- */
- summary: function(){
- var me = this,
- store = this.store,
- value;
- Ext.each(me.columns, function(c){
- if(c.summaryType == 'sum'){
- value = store.getSum(c.dataIndex);
- me.down('tbtext[id=' + c.dataIndex + '_sum]').setText(c.header + '(sum):' + value);
- } else if(c.summaryType == 'count'){
- value = store.getCount();
- me.down('tbtext[id=' + c.dataIndex + '_count]').setText(c.header + '(count):' + value);
- } else if(c.summaryType == 'average'){
- value = store.getAverage(c.dataIndex);
- me.down('tbtext[id=' + c.dataIndex + '_average]').setText(c.header + '(average):' + value);
- }
- });
- },
- initRecords: function(){
- var records = this.store.data.items;
- var count = 0;
- Ext.each(records, function(record){
- if(!record.index){
- record.index = count++;
- }
- });
- }
- });
|