uas6.0/WebContent/app/view/common/query/Form.js

Ext.define('erp.view.common.query.Form',{ 
	extend: 'Ext.form.Panel', 
	alias: 'widget.erpQueryFormPanel',
	id: 'queryform', 
    region: 'north',
    frame : true,
	layout : 'column',
	header: false,//不显示title
	autoScroll : true,
	defaultType : 'textfield',
	labelSeparator : ':',
	buttonAlign : 'center',
	fieldDefaults : {
	       margin : '2 2 2 2',
	       fieldStyle : "background:#FFFAFA;color:#515151;",
	       labelAlign : "right",
	       blankText : $I18N.common.form.blankText
	},
	FormUtil: Ext.create('erp.util.FormUtil'),
	BaseUtil: Ext.create('erp.util.BaseUtil'),
	prevTime:null,
	tbar: [{
		id:'query',
		name: 'query',
		text: $I18N.common.button.erpQueryButton,
		iconCls: 'x-button-icon-query',
    	cls: 'x-btn-gray',
    	handler: function(btn){
    		//限制点击筛选时间间隔不能超过2秒
    		var form=btn.ownerCt.ownerCt;
    		if(form.prevTime==null){
    			form.prevTime=new Date().getTime();
    			form.onQuery();
    		}else {
    			var nowtime=new Date().getTime();
    			if((nowtime-form.prevTime)/1000<2){
    				showError('请控制筛选时间间隔不能小于2秒!');
    				return;
    			}else {
    				form.prevTime=nowtime;
    				form.onQuery();
    			}
    		}
			
    	}
	}, '->'
	,{
		name: 'export',
		text: $I18N.common.button.erpExportButton,
		iconCls: 'x-button-icon-excel',
    	cls: 'x-btn-gray',
    	handler: function(btn){
    		var grid = Ext.getCmp('querygrid');
    		if(grid.xtype == 'erpQueryGridPanel') {
    			var condition = grid.defaultCondition || '';
    			condition = btn.ownerCt.ownerCt.spellCondition(condition);
    			if(Ext.isEmpty(condition)) {
    				condition = grid.emptyCondition || '1=1';
    			}
        		grid.BaseUtil.createExcel(caller, 'detailgrid', condition, null, null, null, grid);
    		} else if(grid.xtype == 'erpDatalistGridPanel') {
    			var condition = btn.ownerCt.ownerCt.spellCondition(condition);
    			if(Ext.isEmpty(condition)) {
    				condition = '1=1';
    			}
    			if(typeof grid.getCondition === 'function') {
    				condition += ' and ' + grid.getCondition();
    			}
    			grid.BaseUtil.createExcel(caller, 'datalist', condition, null, null, null, grid);
    		} else {
    			btn.ownerCt.ownerCt.BaseUtil.exportGrid(grid);
    		}
    	}
	}, '-',{
		name: 'refresh',
		text: $I18N.common.button.erpRefreshButton,
		iconCls: 'x-button-icon-check',
    	cls: 'x-btn-gray'
	}, {
		text: $I18N.common.button.erpCloseButton,
		iconCls: 'x-button-icon-close',
    	cls: 'x-btn-gray',
    	id:'close',
    	handler: function(){
    		var main = parent.Ext.getCmp("content-panel"); 
    		main.getActiveTab().close();
    	}
	}],
	initComponent : function(){ 
		this.getItemsAndButtons();
		this.callParent(arguments);
		this.addKeyBoardEvents();
	},
	onQuery: function() {
		var grid = Ext.getCmp('querygrid');
		if(!grid){
			grid = Ext.getCmp('grid');
		}
		var form = this;
		var condition = grid.defaultCondition || '';
		condition = form.spellCondition(condition);
		if(Ext.isEmpty(condition)) {
			condition = grid.emptyCondition || '1=1';
		}
		form.beforeQuery(caller, condition);//执行查询前逻辑
		var gridParam = {caller: caller, condition: condition, start: 1, end: getUrlParam('_end')||1000};
		grid.GridUtil.loadNewStore(grid, gridParam);
	},
	spellCondition: function(condition){
		var form = this;
		Ext.each(form.items.items, function(f){
			if(f.logic != null && f.logic != ''){
				if(f.xtype == 'checkbox' && f.value == true){
					if(condition == ''){
						condition += f.logic;
					} else {
						condition += ' AND ' + f.logic;
					}
				} else if(f.xtype == 'datefield' && f.value != null){
					var v = Ext.Date.format(new Date(f.value), 'Y-m-d');
					if(condition == ''){
						condition += f.logic + "=to_date('" + v + "', 'yyyy-MM-dd')";
					} else {
						condition += ' AND ' + f.logic + "=to_date('" + v + "', 'yyyy-MM-dd')";
					}
				} else if(f.xtype == 'datetimefield' && f.value != null){
					var v = Ext.Date.format(new Date(f.value), 'Y-m-d H:i:s');
					if(condition == ''){
						condition += f.logic + "=to_date('" + v + "', 'yyyy-MM-dd HH24:mi:ss')";
					} else {
						condition += ' AND ' + f.logic + "=to_date('" + v + "', 'yyyy-MM-dd HH24:mi:ss')";
					}
				} else if(f.xtype == 'numberfield' && f.value != null && f.value != ''){
					if(condition == ''){
						condition += f.logic + '=' + f.value;
					} else {
						condition += ' AND ' + f.logic + '=' + f.value;
					}
				} else if(f.xtype == 'yeardatefield' && f.value != null && f.value != ''){
					if(condition == ''){
						condition += f.logic + '=' + f.value;
					} else {
						condition += ' AND ' + f.logic + '=' + f.value;
					}
				}else if(f.xtype == 'combo' && f.value == '$ALL'){
					if(f.store.data.length > 1) {
						if(condition == ''){
							condition += '(';
						} else {
							condition += ' AND (';
						}
						var _a = '';
						f.store.each(function(d, idx){
							if(d.data.value != '$ALL') {
								if(_a == ''){
									_a += f.logic + "='" + d.data.value + "'";
								} else {
									_a += ' OR ' + f.logic + "='" + d.data.value + "'";
								}
							}
						});
						condition += _a + ')';
					}
				}	else if(f.xtype=='adddbfindtrigger' && f.value != null && f.value != ''){
					if(condition == ''){
						condition += f.logic + ' in (' ;		
					} else {
						condition += ' AND ' + f.logic + ' in (';
					}
					var str=f.value,constr="";
					for(var i=0;i<str.split("#").length;i++){
						if(i<str.split("#").length-1){
							constr+="'"+str.split("#")[i]+"',";
						}else constr+="'"+str.split("#")[i]+"'";
					}
					condition +=constr+")";
				} else {
					if(f.value != null && f.value != ''){
						var val = String(f.value);
						if(contains(val, 'BETWEEN', true) && contains(val, 'AND', true)){
							if(condition == ''){
								condition += f.logic + " " + f.value;
							} else {
								condition += ' AND (' + f.logic + " " + f.value + ")";
							}
						} else if(f.logic == 'ym_view_param') {
							if(condition == ''){
								condition += " " + f.value;
							} else {
								condition += ' AND (' + f.value + ")";
							}
						} else if(contains(val, '||', true)){
							var str = '';
							Ext.each(f.value.split('||'), function(v){
								if(v != null && v != ''){
									if(str == ''){
										str += f.logic + "='" + v + "'";
									} else {
										str += ' OR ' + f.logic + "='" + v + "'";
									}
								}
							});
							if(condition == ''){
								condition += str;
							} else {
								condition += ' AND (' + str + ")";
							}
						} else {
							
							if(val.indexOf('%') >= 0) {
								if(condition == ''){
									condition += f.logic + " like '" + f.value + "'";
								} else {
									condition += ' AND (' + f.logic + " like '" + f.value + "')";
								}
							} else {
								if(f.logic=='CONDITION'){
									if(condition == ''){
										condition +=  f.value ;
									} else {
										condition += ' AND '  + f.value;
									}
								}else{
									if(condition == ''){
										condition += f.logic + "='" + f.value + "'";
									} else {
										condition += ' AND (' + f.logic + "='" + f.value + "')";
									}
								}
					
							}
						}
					}
				}
			}
		});
		return condition;
	},
	_noc: 0,
	getItemsAndButtons: function(){
		var me = this;
		this.setLoading(true);
		Ext.Ajax.request({//拿到form的items
        	url : basePath + 'common/singleFormItems.action',
        	params: {
        		caller: caller, 
        		condition: '',
        		_noc: (getUrlParam('_noc') || me._noc)
        	},
        	method : 'post',
        	callback : function(options,success,response){
        		me.setLoading(false);
        		var res = new Ext.decode(response.responseText);
        		if(res.exceptionInfo != null){
        			showError(res.exceptionInfo);return;
        		}
        		me.fo_keyField = res.fo_keyField;
        		me.tablename = res.tablename;
        		me.fo_id=res.fo_id;
        		if(res.keyField){
        			me.keyField = res.keyField;
        		}
        		if(res.dealUrl){
        			me.dealUrl = res.dealUrl;
        		}
        		me.fo_detailMainKeyField = res.fo_detailMainKeyField;
        		Ext.each(res.items, function(item){
        			if(screen.width < 1280){//根据屏幕宽度，调整列显示宽度
        				if(item.columnWidth > 0 && item.columnWidth <= 0.25){
        					item.columnWidth = 1/3;
        				} else if(item.columnWidth > 0.25 && item.columnWidth <= 0.5){
        					item.columnWidth = 2/3;
        				} else if(item.columnWidth >= 1){
        					item.columnWidth = 1;
        				}
        			} else {
        				if(item.columnWidth > 0.25 && item.columnWidth < 0.5){
        					item.columnWidth = 2/3;
        				}
        			}
        			if(item.xtype == 'hidden') {
        				item.columnWidth = 0;
        			}
        		});
        		me.add(res.items);
        		me.fireEvent('alladded', me);
        		//解析buttons字符串，并拼成json格式
        		var buttonString = res.buttons;
        		if(buttonString != null && buttonString != ''){
        			if(contains(buttonString, '#', true)){
        				Ext.each(buttonString.split('#'), function(b, index){
        					if(!Ext.getCmp(b)){
        						var btn = Ext.getCmp('erpVastDealButton');
        						if(btn){
        							btn.ownerCt.insert(2, {
        								xtype: b
        							});
        						}
        					} else {
        						Ext.getCmp(b).show();
        					}
        				});
        			} else {
        				if(Ext.getCmp(buttonString)){
        					Ext.getCmp(buttonString).show();
        				} else {
        					var btn = Ext.getCmp('erpVastDealButton');//Ext.getCmp(buttonString);
                			if(btn){
                				btn.setText($I18N.common.button[buttonString]);
                				btn.show();
                			}
        				}
        			}
        		}
        	}
        });
	},
	addKeyBoardEvents: function(){
		var me = this;
		if(Ext.isIE){
			document.body.attachEvent('onkeydown', function(){//ie的事件名称不同,也不支持addEventListener
				if(window.event.altKey && window.event.ctrlKey && window.event.keyCode == 83){
					if(Ext.ComponentQuery.query('gridpanel').length > 0){//有grid
						me.FormUtil.onAdd('form' + caller, 'Form配置维护(' + caller + ')', "jsps/ma/multiform.jsp?formCondition=fo_idIS" + me.fo_id + 
								"&gridCondition=fd_foidIS" + me.fo_id + "&whoami=" + caller);
					} else {
						me.FormUtil.onAdd('form' + caller, 'Form配置维护(' + caller + ')', "jsps/ma/form.jsp?formCondition=fo_idIS" + me.fo_id + 
								"&gridCondition=fd_foidIS" + me.fo_id);
					}
				}
			});
			document.body.attachEvent("onmouseover", function(){
				if(window.event.ctrlKey){
					var e = window.event;
					me.Contextvalue = e.target.textContent == "" ? e.target.value : e.target.textContent;
					textarea_text = parent.document.getElementById("textarea_text");
					textarea_text.value = me.Contextvalue;
						textarea_text.focus();
						textarea_text.select();
					}
			});
		} else {
			document.body.addEventListener("keydown", function(e){
				if(Ext.isFF5){//firefox不支持window.event
					e = e || window.event;
				}
				if(e.altKey && e.ctrlKey && e.keyCode == 83){
					if(Ext.ComponentQuery.query('gridpanel').length > 0){//有grid
						me.FormUtil.onAdd('form' + caller, 'Form配置维护(' + caller + ')', "jsps/ma/multiform.jsp?formCondition=fo_idIS" + me.fo_id + 
								"&gridCondition=fd_foidIS" + me.fo_id + "&whoami=" + caller);
					} else {
						me.FormUtil.onAdd('form' + caller, 'Form配置维护(' + caller + ')', "jsps/ma/form.jsp?formCondition=fo_idIS" + me.fo_id + 
								"&gridCondition=fd_foidIS" + me.fo_id);
					}
				}
			});
			document.body.addEventListener("mouseover", function(e){
				if(Ext.isFF5){
					e = e || window.event;
				}
				if(e.ctrlKey){
					me.Contextvalue = e.target.textContent == "" ? e.target.value : e.target.textContent;
					textarea_text = parent.document.getElementById("textarea_text");
					textarea_text.value = me.Contextvalue;
						textarea_text.focus();
						textarea_text.select();
					}
			});
		}
	},
	beforeQuery: function(call, cond) {
		Ext.Ajax.request({
			url: basePath + 'common/form/beforeQuery.action',
			params: {
				caller: call,
				condition: cond
			},
			async: false,
			callback: function(opt, s, r) {
				var rs = Ext.decode(r.responseText);
				if(rs.exceptionInfo) {
					showError(rs.exceptionInfo);
				}
			}
		});
	}
});