manage/uas_mall/WebContent/app/view/pm/atp/.svn/text-base/ATPOpDetailGridPanel4.js.svn-base

Ext.define('erp.view.pm.atp.ATPOpDetailGridPanel4',{ 
	extend: 'Ext.grid.Panel', 
	requires: ['erp.view.core.plugin.CopyPasteMenu'],
	alias: 'widget.ATPOpDetailGridPanel4',
 	emptyText : $I18N.common.grid.emptyText,
    columnLines : true,
    autoScroll : true,
    height:height,
    id:'grid4',
    gridcondition:"",
    store: [],
    columns: new Array(),
    bodyStyle:'background-color:#f1f1f1;',
    selModel: Ext.create('Ext.selection.CheckboxModel',{
    	headerWidth: 0
	}),
	layout:'fit',
	LastCondition:"",
	dockedItems: [{
    id : 'pagingtoolbar4',
    xtype: 'erpMpsToolbar',
    dock: 'bottom',
    displayInfo: true
	}],
	caller:'ATPDATA',
    GridUtil: Ext.create('erp.util.GridUtil'),
    BaseUtil: Ext.create('erp.util.BaseUtil'),
    plugins: [Ext.create('Ext.ux.grid.GridHeaderFilters'), Ext.create('erp.view.core.plugin.CopyPasteMenu')],
	initComponent : function(){
		this.getCount(caller,"");
    	this.callParent(arguments); 
	},
	getCount: function(c, condition){
		var me = this;
		c=c||caller;
		var findcondition=me.getCondition(condition);
		Ext.Ajax.request({//拿到grid的数据总数count
        	url : basePath + '/common/datalistCount.action',
        	params: {
        		caller: caller,
        		condition: findcondition,
        		_noc:1
        	},
        	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(caller, findcondition, page, pageSize);
        	}
        });
	},
	getCondition:function(condition){
	    condition =(!condition || condition=="")?atpcondition:condition+" AND "+atpcondition;
		condition+=" AND ad_kind='NEED'";
		condition =BaseQueryCondition==""?condition:condition+" AND "+BaseQueryCondition;
		condition=condition.replace(/pr_code/g,'ad_prodcode');
    	if(!Ext.isEmpty(this.defaultCondition)) {
    		condition = this.defaultCondition;
    	}
    	if(!Ext.isEmpty(this.filterCondition)) {
    		if(condition == '' ) {
    			condition = this.filterCondition;
    		} else {
    			condition = '(' + condition + ') AND (' + this.filterCondition + ')';
    		}
    	}
    	condition =BaseQueryCondition==""?condition:condition+" AND "+BaseQueryCondition;
    	return condition;
	},
	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(!Ext.isEmpty(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 (value == '-无-') {
    	                    				value = 'nvl(' + fn + ',\' \')=\' \'';
    	                    			} else {
    	                    				value = fn + " LIKE '" + value + "%' ";
    	                    			}
    	                    		} else {
    	                    			if(f.ignoreCase) {// 忽略大小写
        	                    			fn = 'upper(' + fn + ')';
        	                    			value = value.toUpperCase();
        	                    		}
        	                    		if(!f.autoDim) {
        	                    			value = fn + " LIKE '" + value + "%' ";
        	                    		} else {
        	                    			value = fn + " LIKE '%" + value + "%' ";
        	                    		}
    	                    		}
    	                    	}
                        	}
                    	}
                    	if(condition == null){
                    		condition = value;
                    	} else {
                    		condition = condition + " AND " + value;
                    	}
                    }
                }
                this.filterCondition = condition;
                page = 1;
                this.getCount(caller,"");
        	} else {
        		this.allowFilter = true;
        	}
        	return false;
        }
    },
	getColumnsAndStore: function(caller, condition, page, pageSize){	
		var me = this;
		me.gridcondition=condition;
		me.BaseUtil.getActiveTab().setLoading(true);//loading...
		Ext.Ajax.request({//拿到grid的columns
        	url : basePath + 'common/datalist.action',
        	params: {
        		caller: caller,
        		condition:  condition, 
        		page: page,
        		pageSize: pageSize,
        		_noc:1
        	},
        	method : 'post',
        	callback : function(options,success,response){
        		me.BaseUtil.getActiveTab().setLoading(false);
        		var res = new Ext.decode(response.responseText);
        		if(res.exception || res.exceptionInfo){
        			showError(res.exceptionInfo);
        			return;
        		}
        		var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];//一定要去掉多余逗号，ie对此很敏感        		
        			if(me.columns && me.columns.length > 2){
            			me.store.loadData(data);
            		}else {
            			var store = Ext.create('Ext.data.Store', {
                		    fields: res.fields,
                		    data: data
                		});
            			Ext.getCmp('grid4').reconfigure(store, res.columns);
            		} 	   
            	   Ext.getCmp("pagingtoolbar4").afterOnLoad();
            	   Ext.Ajax.request({//拿到grid的columns
                   	url : basePath + 'pm/mps/getSum.action',
                   	params: {
                   		caller: caller,
                   		condition:condition,
                   		fields:'ad_needqty',
                   		_noc:1
                   	},
                   	method : 'post',
                   	callback : function(options,success,response){
                   		me.BaseUtil.getActiveTab().setLoading(false);
                   		var res = new Ext.decode(response.responseText);
                   		if(res.exception || res.exceptionInfo){
                   			showError(res.exceptionInfo);
                   			return;
                   		}else if(res.success){
                   			var obj=new Ext.decode(res.data);
                   			var text=Ext.getCmp('text4');
                   			if(text){
                   				text.setText('需求数:'+obj.md_Needqty);
                   			}else {
                   			     Ext.getCmp('pagingtoolbar4').insert(16,{
                  				xtype:'tbtext',
                  				id:'text4',
                  				text:'需求数 :'+obj.md_Needqty
                  			});
                   			}
                   		}
                   	}
                   });	
        	}
        });
	},
});