mes/WebContent/app/view/common/datalist/GridPanel.js

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')
    }
});