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

Ext.define('erp.view.pm.atp.ATPOpDetailGridPanel6',{ 
	extend: 'Ext.grid.Panel', 
	requires: ['erp.view.core.plugin.CopyPasteMenu'],
	alias: 'widget.ATPOpDetailGridPanel6',
 	emptyText : $I18N.common.grid.emptyText,
    columnLines : true,
    autoScroll : true,
    id:'grid6',
    store: [],
    columns: new Array(),
    height:height,
    LastCondition:"",
    gridcondition:"",
    bodyStyle:'background-color:#f1f1f1;',
    selModel: Ext.create('Ext.selection.CheckboxModel',{
    	headerWidth: 0
	}),
	autoQuery: true,
    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(){
	    caller='Desk!ATPResultDetail';	  
	    this.getCount(caller,"");	 
    	this.callParent(arguments); 
	},
	dockedItems: [{
    	id : 'pagingtoolbar6',
        xtype: 'erpMpsToolbar',
        dock: 'bottom',
        displayInfo: true
	}],
	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: c,
        		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 =BaseQueryCondition==""?condition:condition+" AND "+BaseQueryCondition;
		 condition=condition.replace(/pr_code/g,'ad_prodcode');
		 if(!Ext.isEmpty(this.filterCondition)) {
	    		if(condition == '') {
	    			condition = this.filterCondition;
	    		} else {
	    			condition = '(' + condition + ') AND (' + this.filterCondition + ')';
	    		}
	     }
		 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);
            			Ext.getCmp('pagingtoolbar6').afterOnLoad();
            		}else {
            			var store = Ext.create('Ext.data.Store', {
                		    fields: res.fields,
                		    data: data
                		});
            			 Ext.getCmp('grid6').reconfigure(store, res.columns);
            		}            	  
            	   Ext.getCmp('pagingtoolbar6').afterOnLoad();
            	   Ext.Ajax.request({//拿到grid的columns
                   	url : basePath + 'pm/mps/getSum.action',
                   	params: {
                   		caller: caller,
                   		condition:condition,
                   		fields:'ad_grossqty#ad_usedonhand#ad_usedonorder#ad_netqty',
                   		_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('text6');
                   			if(text){
                   				text.setText('毛需求 :'+obj.ad_grossqty +'净需求:'+obj.ad_netqty+' 库存分配:'+obj.ad_usedonhand+' 在途分配:'+obj.ad_usedonorder);
                   			}else {
                   			Ext.getCmp('pagingtoolbar6').insert(16,{
                  				xtype:'tbtext',
                  				id:'text6',
                  				text:'毛需求 :'+obj.ad_grossqty +'净需求:'+obj.ad_netqty+' 库存分配:'+obj.ad_usedonhand+' 在途分配:'+obj.ad_usedonorder
                  			});
                   			}
                   		}
                   	}
                   });	
        	}
        });
	},
});