Ext.require([ 'erp.util.*' ]); Ext.override(Ext.grid.column.Column, { // 点列头后,进行后台数据排序查找 doSort: function(state) { var tablePanel = this.up('tablepanel'); if(typeof tablePanel.getCount === 'function') { var sortParam = this.getSortParam(),column=this; //var column = tablePanel.down('gridcolumn[dataIndex=' + sortParam + ']'); if(column && (Ext.isEmpty(column.xtype) || column.xtype == 'textcolumn')) { sortParam = "nlssort(" + sortParam + ",'NLS_SORT=SCHINESE_PINYIN_M')"; } tablePanel.sorts = 'ORDER BY ' + sortParam + ' ' + state; tablePanel.getCount(); } else { var tablePanel = this.up('tablepanel'), store = tablePanel.store; if (tablePanel.ownerLockable && store.isNodeStore) { store = tablePanel.ownerLockable.lockedGrid.store; } store.sort({ property: this.getSortParam(), direction: state }); } } }); Ext.define('erp.view.common.datalist.GridPanel',{ extend: 'Ext.grid.Panel', requires: ['erp.view.core.plugin.CopyPasteMenu'], alias: 'widget.erpDatalistGridPanel', layout : 'fit', id: 'grid', emptyText : '无数据', columnLines : true, autoScroll : true, store: [], columns: new Array(), bodyStyle:'background-color:#f1f1f1;', selModel: Ext.create('Ext.selection.CheckboxModel',{ headerWidth: 0 }), dockedItems: [{ id : 'pagingtoolbar', xtype: 'erpDatalistToolbar', dock: 'bottom', displayInfo: true }], BaseUtil: Ext.create('erp.util.BaseUtil'), GridUtil: Ext.create('erp.util.GridUtil'), RenderUtil:Ext.create('erp.util.RenderUtil'), showRowNum:true, autoQuery: true, constructor: function(cfg) { if(cfg) { cfg.plugins = cfg.plugins || [Ext.create('Ext.ux.grid.GridHeaderFilters'), Ext.create('erp.view.core.plugin.CopyPasteMenu')]; Ext.apply(this, cfg); } this.callParent(arguments); }, initComponent : function(){ condition = this.BaseUtil.getUrlParam('urlcondition'); condition = (condition == null) ? "" : condition; condition = condition.replace(/@@/,"'%").replace(/@@/,"%'"); this.defaultCondition = this.defaultCondition?this.defaultCondition+condition:condition;//固定条件;从url里面获取 caller = this.caller || this.BaseUtil.getUrlParam('whoami'); if(this.autoQuery) { this.getCount(caller, condition); } else { //易方数据量大 可能明细显示的是datalist var gridCondition=this.BaseUtil.getUrlParam('gridCondition'); if(gridCondition){ condition=gridCondition.replace(/IS/g, "="); this.getCount(caller,condition); } else this.getCount(caller, '1=2'); } this.callParent(arguments); this.addEvents({ keydown: true }); } , _noc: 0, _f: 0, getColumnsAndStore: function(c, d, g, s){ c = c || caller; d = d || this.getCondition(); g = g || page; s = s || pageSize; var me = this, rendered = (me.columns && me.columns.length > 2); var f = d; this.setLoading(true);//loading... Ext.Ajax.request({//拿到grid的columns url : basePath + (rendered ? 'common/datalist/data.action' : 'common/datalist.action'), params: { _noc: (me._noc || getUrlParam('_noc')), _f: (me._f || getUrlParam('_f')), caller: c, condition: f, page: g, pageSize: s, orderby: me.sorts }, method : 'post', callback : function(options,success,response){ me.setLoading(false); if (!response) return; var res = new Ext.decode(response.responseText); if(res.exception || res.exceptionInfo){ showError(res.exceptionInfo); return; } var data = res.data != null ? (rendered ? res.data : Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']'))) : [];//一定要去掉多余逗号,ie对此很敏感 if(rendered){ me.store.loadData(data); //zhouy 列表多次筛选出现列错位的情况 暂时解决办法 var scrollers=me.query('gridscroller'); Ext.Array.each(scrollers,function(scroller){ if(scroller.dock=="bottom"){ var el = scroller.scrollEl, elDom = el && el.dom; if (elDom) { elDom.scrollLeft = Ext.Number.constrain(elDom.scrollLeft, 0, elDom.scrollWidth - elDom.clientWidth)-1; } } }); if(me.lastSelected && me.lastSelected.length > 0){//grid刷新后,仍然选中上次选中的record Ext.each(me.store.data.items, function(item){ if(item.data[keyField] == me.lastSelected[0].data[keyField]){ me.selModel.select(item); } }); } //修改pagingtoolbar信息 me.down('erpDatalistToolbar').afterOnLoad(page); } else { if(!Ext.isChrome){ Ext.each(res.fields, function(f){ if(f.type == 'date'){ f.dateFormat = 'Y-m-d H:m:s'; } }); } var store = Ext.create('Ext.data.Store', { fields: res.fields, data: data, //模糊查询的结果在Ext.Array.filter()方法之后,部分数据被过滤掉,设置为false不调用该方法 //yingp filterOnLoad: false }); var limits = res.limits, limitArr = new Array(); if(limits != null && limits.length > 0) {//权限外字段 limitArr = Ext.Array.pluck(limits, 'lf_field'); } var grid = this; Ext.Array.each(res.columns, function(column, y) { // power if(limitArr.length > 0 && Ext.Array.contains(limitArr, column.dataIndex)) { column.hidden = true; } // 处理render if(!column.haveRendered && column.renderer != null && column.renderer != ""){ if(!grid.RenderUtil){ grid.RenderUtil = Ext.create('erp.util.RenderUtil'); } 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.dataIndex来标志,不能用x,y,index等, //grid在render时,checkbox占一列 } column.renderer = grid.RenderUtil[renderName]; column.haveRendered = true; } }); var col = me.showRowNum?Ext.Array.insert(res.columns, 0, [{xtype: 'rownumberer', width: 35, cls: 'x-grid-header-1', align: 'center'}]):res.columns; me.reconfigure(store, col);//用这个方法每次都会add一个checkbox列 me.basecolumns=res.basecolumns; //拿到datalist对应的单表的关键词 keyField = res.keyField;//form表主键字段 pfField = res.pfField;//grid表主键字段 url = basePath + res.url;//grid行选择之后iframe嵌入的页面链接 relative = res.relative; if(res.vastbutton && res.vastbutton == 'erpAddButton'){//[新增]功能 Ext.getCmp('erpAddButton').show(); } } me.down('erpDatalistToolbar').afterOnLoad(); } }); }, getCount: function(c, d, m){ c = c || caller; d = d || this.getCondition(); var me = this; var f = d; if(!me.filterCondition && !me.searchGrid && !m) {// 大数据如果没有筛选条件 var _f = me._f || getUrlParam('_f'); if(_f == 1) { dataCount = 1000*pageSize;// 直接作1000页数据处理 me.noCount = true; me.getColumnsAndStore(c, d); return; } } Ext.Ajax.request({//拿到grid的数据总数count url : basePath + 'common/datalistCount.action', params: { caller: c, condition: f }, method : 'post', callback : function(options,success,response){ var res = new Ext.decode(response.responseText); if(res.exception || res.exceptionInfo){ showError(res.exceptionInfo); return; } dataCount = res.count; me.getColumnsAndStore(c, d); } }); }, listeners: { 'headerfiltersapply': function(grid, filters) { if(this.allowFilter){ var condition = null; for(var fn in filters){ var value = filters[fn], f = grid.getHeaderFilterField(fn); if(f.xtype == 'datefield') value = f.getRawValue(); if(!Ext.isEmpty(value)) { if("null"!=value){ if(f.filtertype) { if (f.filtertype == 'numberfield') { value = fn + "=" + value + " "; } } else { if(Ext.isDate(value)){ value = Ext.Date.toString(value); value = "to_char(" + fn + ",'yyyy-MM-dd')='" + value + "' "; } else { var exp_t = /^(\d{4})\-(\d{2})\-(\d{2}) (\d{2}):(\d{2}):(\d{2})$/, exp_d = /^(\d{4})\-(\d{2})\-(\d{2})$/; if(exp_d.test(value)){ value = "to_char(" + fn + ",'yyyy-MM-dd')='" + value + "' "; } else if(exp_t.test(value)){ value = "to_char(" + fn + ",'yyyy-MM-dd')='" + value.substr(0, 10) + "' "; } else{ if (f.xtype == 'combo' || f.xtype == 'combofield') { if (value == '-所有-') { continue; } else { if (f.column && f.column.xtype == 'yncolumn'){ if (value == '-无-') { value = fn + ' is null'; } else { value = fn + ((value == '是' || value == '-1' || value == '1') ? '<>0' : '=0'); } } else { if (value == '-无-') { value = 'nvl(' + fn + ',\' \')=\' \''; } else { if(value)value=value.replace(/\'/g,"''"); value = fn + " LIKE '" + value + "%' "; } } } } else if(f.xtype == 'datefield') { value = "to_char(" + fn + ",'yyyy-MM-dd') like '%" + value + "%' "; } else if(f.column && f.column.xtype == 'numbercolumn'){ if(f.column.format) { var precision = f.column.format.substr(f.column.format.indexOf('.') + 1).length; value = "to_char(round(" + fn + "," + precision + ")) like '%" + value + "%' "; } else value = "to_char(" + fn + ") like '%" + value + "%' "; } else { /**字符串转换下简体*/ if(value)value=value.replace(/\'/g,"''"); var SimplizedValue=this.BaseUtil.Simplized(value); //可能就是按繁体筛选 if(f.ignoreCase) {// 忽略大小写 fn = 'upper(' + fn + ')'; value = value.toUpperCase(); } if(!f.autoDim) { if(SimplizedValue!=value){ value = "("+fn + " LIKE '" + value + "%' or "+fn+" LIKE '"+SimplizedValue+"%')"; }else value = fn + " LIKE '" + value + "%' "; } else if(f.exactSearch){ value=fn+"='"+value+"'"; } else { if(SimplizedValue!=value){ value = "("+fn + " LIKE '%" + value + "%' or "+fn+" LIKE '%"+SimplizedValue+"%')"; }else value = fn + " LIKE '%" + value + "%' "; } } } } } }else value ="nvl("+fn+",' ')=' '"; if(condition == null){ condition = value; } else { condition = condition + " AND " + value; } } } this.filterCondition = condition; page = 1; this.getCount(); } else { this.allowFilter = true; } return false; } }, reconfigure: function(store, columns){ //改写reconfigure方法 var d = this.headerCt; if (this.columns.length <= 1 && columns) {//this.columns.length > 1表示grid的columns已存在,没必要remove再add d.suspendLayout = true; d.removeAll(); d.add(columns); } if (store) { this.bindStore(store); } else { this.getView().refresh(); } if (columns) { d.suspendLayout = false; this.forceComponentLayout(); } this.fireEvent("reconfigure", this); }, getCondition: function(isForm){ var condition = ''; if(!Ext.isEmpty(this.defaultCondition)) { condition = this.defaultCondition; } if (this.searchGrid) { var s = this.searchGrid.getCondition(); if(s != null && s.length > 0) { if(condition.length > 0) condition += ' AND (' + s + ')'; else condition = s; } } if(!isForm && this.formCondition) { if(condition.length > 0) condition += ' AND (' + this.formCondition + ')'; else condition = this.formCondition; } if(!Ext.isEmpty(this.filterCondition)) { if(condition == '') { condition = this.filterCondition; } else { condition = '(' + condition + ') AND (' + this.filterCondition + ')'; } } return condition;// .replace(/=/g, '%3D') } });