mes/WebContent/app/view/common/batchPrint/Form.js

Ext.define('erp.view.common.batchPrint.Form',{ 
	extend: 'Ext.form.Panel', 
	alias: 'widget.erpBatchPrintFormPanel',
	id: 'printform', 
    region: 'north',
    frame : true,
    header: false,//不显示title
	layout : 'column',
	autoScroll : true,
	defaultType : 'textfield',
	labelSeparator : ':',
	buttonAlign : 'center',
	fieldDefaults : {
	       fieldStyle : "background:#FFFAFA;color:#515151;",
	       labelAlign : "right",
	       blankText : $I18N.common.form.blankText
	},
	FormUtil: Ext.create('erp.util.FormUtil'),
	tbar: [{
		name: 'query',
		text: $I18N.common.button.erpQueryButton,
		iconCls: 'x-button-icon-query',
    	cls: 'x-btn-gray',
    	handler: function(){
			var grid = Ext.getCmp('batchPrintGridPanel');
			var form = Ext.getCmp('printform');
			var gridParam = {caller: caller, condition: form.getCondition(), start: 1, end: 1000};
			form.beforeQuery(caller, gridParam.condition);//执行查询前逻辑
			grid.GridUtil.loadNewStore(grid, gridParam);
    	}
	}, '->', {
		name: 'batchPrint',
		text: $I18N.common.button.erpVastPrintButton,
    	iconCls: 'x-button-icon-print',
    	cls: 'x-btn-gray',
    	handler:function(btn){
    		var form = btn.ownerCt.ownerCt, grid = form.ownerCt.down('grid');
    		var keyField = form.fo_keyField;
    		var items = grid.getMultiSelected();
    		var ids =new Array();
    		var length = items.length;
    		var idStr ='';
    		Ext.each(items,function(item,index){
    			if(length!=index+1){
    				//idStr = idStr+'[[['+item.data[keyField]+']]],';
    				idStr = idStr+item.data[keyField]+',';
    			}else{
    				idStr = idStr+item.data[keyField];
    			}
//    			var id =item.data[keyField];
//    			ids.push(id);
    		});
    		var title = form.title;
    		var reportName="";
			var condition="";
			var todate='';
        	var dateFW='';
        	var fromdate='';
        	var enddate='';
    		if (title=='销售变更单打印'){
    			reportName="SaleChange_Batch";
    			condition='{SaleChange.sc_id}in[ '+idStr+' ]';
    		}else if(title=="出货通知单打印"){
    			reportName="SendNotify_batch";
    			condition='{SendNotify.sn_id}in[ '+idStr+' ]';
    		}else if(title=="出货单打印"){
    			reportName="sendlist_yessale_batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="请购单打印"){
    			reportName="application_batch";
    			condition='{application.ap_id}in[ '+idStr+' ]';
    		}
    		else if(title=="采购变更单打印"){
    			reportName="PURCChange_batch";
    			condition='{PurchaseChange.pc_id}in[ '+idStr+' ]';
    		}else if(title=="采购收料单打印"){
    			reportName="VerifyApply_batch";
    			condition='{VerifyApply.va_id}in[ '+idStr+' ]';
    		}else if(title=="估价单打印"){
    			reportName="sale_gj_batch";
    			condition='{evaluation.ev_id}in[ '+idStr+' ]';
    		}else if(title=="报价单打印"){
    			reportName="QUOTLIST_batch";
    			condition='{Quotation.qu_id}in[ '+idStr+' ]';
    		}else if(title=="销售订单评审表打印"){
    			reportName="SaleForecastAudit1_batch";
    			condition='{SaleForecast.sf_id}in[ '+idStr+' ]';
    		}else if(title=="借货出货单打印"){
    			reportName="jhch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="销售退货单打印"){
    			reportName="retulist_batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="采购物料明细表"){
    			reportName="ProductBuy";
    			condition='{Purchase.pu_id}in[ '+idStr+' ]';
    		}else if(title=="收料明细打印"){
    			reportName="VerifyApplyDetail";
    			condition='{verifyapply.va_id}in[ '+idStr+' ]';
    		}else if(title=="采购退料单打印"){
    			reportName="piolist_yt_batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="采购退货清单打印"){
    			reportName="piolistytList";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="采购退货清单打印"){
    			reportName="piolistytList";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="采购单批量打印"){
    			reportName="PURCLIST_Batch";
    			condition='{purchase.pu_id}in[ '+idStr+' ]';
    		}else if(title=="未审核采购单打印"){
    			reportName="PURCLIST_Batch";
    			condition='{purchase.pu_id}in[ '+idStr+' ]';
    		}else if(title=="采购单打印(英文版)"){
    			reportName="PURCLIST_ENGLISH";
    			condition='{purchase.pu_id}in[ '+idStr+' ]';
    		}else if(title=="采购预测单打印"){
    			reportName="PurchaseYC_Batch";
    			condition='{PurchaseForecast.pf_id}in[ '+idStr+' ]';
    		}else if(title=="委外加工单资料打印"){
    			reportName="MAKEWW_Batch";
    			condition='{make.ma_id}in[ '+idStr+' ]';
    		}else if(title=="委外领料单打印"){
    			reportName="PIOLISTMWW_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="委外退料单打印"){
    			reportName="EXPLIST_yt_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="委外补料单打印"){
    			reportName="Expiolist_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="委外报废单打印"){
    			reportName="MakeScrapWW_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="制造单资料打印"){
    			reportName="MakeList";
    			condition='{make.ma_id}in[ '+idStr+' ]';
    		}else if(title=="生产领料单打印"){
    			reportName="PIOLISTM_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="采购退货单打印"){
    			reportName="PIOLISTM_Back";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="生产补料单打印"){
    			reportName="PIOLIST_bl_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="生产报废单打印"){
    			reportName="MakeScrap_Batch";
    			condition='{make.ma_id}in[ '+idStr+' ]';
    		}else if(title=="完工入库单打印"){
    			reportName="finish_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="拆件完工入库单打印"){
    			reportName="chaijian_Batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		}else if(title=="工单备料单批量打印"){
    			reportName="MakeUsagePrebymake_batch";
    			condition='{MA_MAKEMATERIAL_VIEW.ma_id}in[ '+idStr+' ]';
    		}else if(title=="BOM多级展开"){
    			reportName="bomlevel3";
    			//var boid = Ext.getCmp('bo_id').getValue();
    			var kind=Ext.getCmp('bo_remark').getValue();
    			//console.log(kind);
    			//console.log(boid);
    			condition='{BomStruct.bs_sonbomid}in[ '+idStr+' ]';
    			//+' and '+' (isnull({BomDetail.bd_usestatus}) or {BomDetail.bd_usestatus}<>'+"'DISABLE')";
    			if(kind=="原材料"){
    				condition+=' and '+'{BomStruct.bs_sonbomid}='+"0";
    			}
    			if(kind=="半成品"){
    				condition+=' and '+'(isnull({product.pr_manutype}) or {product.pr_manutype}<>'+"'PURCHASE'"+') and '+'{BomStruct.bs_sonbomid}>'+"0";
    			}
    			console.log(condition);
    		}else if(title=="物料综合查询"){
    			reportName="ProductBalance";
    			var prodcode = Ext.getCmp('pr_code').getValue();
    			if(prodcode!=""){
    				condition='{Product.pr_code}='+"'"+prodcode+"'";
    			}
    		}else if(title=="FQC检验报告打印"){
    			reportName="verifyMake_Batch";
    			condition='{QUA_VerifyApplyDetail.ve_id}in[ '+idStr+' ]';
    		    console.log(condition);
    		}else if(title=="凭证批量打印"){
    			reportName="vouclist_rmb";
    			condition='{voucher.vo_id}in[ '+idStr+' ]';
    		    console.log(condition);
    		}else if(title=="采购验收单批量打印"){
    			reportName="acclist_batch";
    			condition='{ProdInout.pi_id}in[ '+idStr+' ]';
    		    console.log(condition);
    		}else if(title=="费用批量打印"){
    			reportName="AccountRegZW_batch";
    			condition='{FeePlease.fp_id}in[ '+idStr+' ]';
    		    console.log(condition);
    		}else if(title=="费用批量打印(无备注)"){
    			reportName="AccountRegZW_batch_no";
    			condition='{FeePlease.fp_id}in[ '+idStr+' ]';
    		    console.log(condition);
    		}else if(title=="IQC/FQC批量打印"){
    			reportName="verifyMake_batch";
    			condition='{QUA_VerifyApplyDetail.ve_id}in[ '+idStr+' ]';
    		    console.log(condition);
    		}
    		//reportName="rpts/"+reportName+'.rpt';
    		//=======================================================
    	 	var me = this;
	   		Ext.Ajax.request({
		   		url : basePath + 'common/enterprise/getprinturl.action?caller=' + caller,
		   		callback: function(opt, s, r) {
		   			var re = Ext.decode(r.responseText);
		   			thisreport=re.reportname;
		   			
		   			//===========================================
		   			var whichsystem = re.whichsystem;
					var urladdress = "";
					var rpname = re.reportName;
					if(Ext.isEmpty(rpname) || rpname == "null"){
						urladdress = re.printurl;
					} else if(rpname.indexOf(thisreport) > 0){
						urladdress = re.ErpPrintLargeData;
					} else{
						urladdress = re.printurl;
					}
					if(thisreport==""||thisreport==null||thisreport=='null'){
						thisreport=reportName;
					}
					console.log("reportname="+thisreport);
				   	//form.FormUtil.batchPrint(idStr,reportName,condition,title,todate,dateFW,fromdate,enddate,urladdress,whichsystem);
				   	form.FormUtil.batchPrint(idStr,thisreport,condition,title,todate,dateFW,fromdate,enddate,urladdress,whichsystem);
				   	 //在这里传条件和报表名字
		   		}
	   		});
    	}
	},'-',{
    	name: 'export',
		text: $I18N.common.button.erpExportButton,
		iconCls: 'x-button-icon-submit',
    	cls: 'x-btn-gray',
    	handler: function(btn){
    		var form = btn.ownerCt.ownerCt,
				grid = Ext.getCmp('batchPrintGridPanel');
			var cond = form.getCondition();
			if(Ext.isEmpty(cond)) {
				cond = '1=1';
			}
			grid.BaseUtil.createExcel(caller, 'detailgrid', cond);
    	}
    },'-',{
		text: $I18N.common.button.erpCloseButton,
		iconCls: 'x-button-icon-close',
    	cls: 'x-btn-gray',
    	handler: function(){
    		var main = parent.Ext.getCmp("content-panel"); 
    		main.getActiveTab().close();
    	}
	}],
	initComponent : function(){ 
		var urlcondition = getUrlParam('condition');//从url解析参数
		urlcondition = (urlcondition == null) ? "" : urlcondition.replace(/IS/g,"=");
		var param = {caller: caller, condition: urlcondition};
    	this.FormUtil.getItemsAndButtons(this, 'common/singleFormItems.action', param);
		this.callParent(arguments);
		this.addKeyBoardEvents();
	},
	getCondition: function(){
		var grid = Ext.getCmp('batchPrintGridPanel');
		var form = Ext.getCmp('printform');
		var condition = grid.defaultCondition || '';
		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.xtype == 'monthdatefield') && 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(contains(f.logic, 'to:', true)){
						if(!grid.toField){
							grid.toField = new Array();
						}
						grid.toField.push(f.logic.split(':')[1]);
					} else {
						if(!Ext.isEmpty(f.value)){
							if(contains(f.value.toString(), 'BETWEEN', true) && contains(f.value.toString(), 'AND', true)){
								if(condition == ''){
									condition += f.logic + " " + f.value;
								} else {
									condition += ' AND (' + f.logic + " " + f.value + ")";
								}
							} else if(contains(f.value.toString(), '||', 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(f.value.toString().charAt(0) == '!'){ 
								if(condition == ''){
									condition += 'nvl(' + f.logic + ",' ')<>'" + f.value.substr(1) + "'";
								} else {
									condition += ' AND (nvl(' + f.logic + ",' ')<>'" + f.value.substr(1) + "')";
								}
							} else {
								if(!Ext.isNumber(f.value) && f.value.indexOf('%') >= 0) {
									if(condition == ''){
										condition += f.logic + " like '" + f.value + "'";
									} else {
										condition += ' AND (' + f.logic + " like '" + f.value + "')";
									}
								} else {
									if(condition == ''){
										condition += f.logic + "='" + f.value + "'";
									} else {
										condition += ' AND (' + f.logic + "='" + f.value + "')";
									}
								}
							}
						}
					}
				}
			}
		});
		return condition;
	},
	/**
	 * 监听一些事件
	 * <br>
	 * Ctrl+Alt+S	单据配置维护
	 * Ctrl+Alt+P	参数、逻辑配置维护
	 */
	addKeyBoardEvents: function(){
		var me = this;
		Ext.EventManager.addListener(document.body, 'keydown', function(e){
			if(e.altKey && e.ctrlKey) {
				if(e.keyCode == Ext.EventObject.S) {
					var url = "jsps/ma/form.jsp?formCondition=fo_idIS" + me.fo_id + "&gridCondition=fd_foidIS" + me.fo_id, 
						forms = Ext.ComponentQuery.query('form'), 
						grids = Ext.ComponentQuery.query('gridpanel'),
						formSet = [], gridSet = [];
					if(forms.length > 0) {
						Ext.Array.each(forms, function(f){
							f.fo_id && (formSet.push(f.fo_id));
						});
					}
					if(grids.length > 0) {
						Ext.Array.each(grids, function(g){
							if(g.xtype.indexOf('erpBatchPrintGridPanel') > -1)
								gridSet.push(window.caller);
							else if(g.caller)
								gridSet.push(g.caller);
						});
					}
					if(formSet.length > 0 || gridSet.length > 0) {
						url = "jsps/ma/multiform.jsp?formParam=" + formSet.join(',') + '&gridParam=' + gridSet.join(',');
					}
					me.FormUtil.onAdd('form' + caller, 'Form配置维护(' + caller + ')', url);
				} else if(e.keyCode == Ext.EventObject.P) {
					me.FormUtil.onAdd('configs-' + caller, '逻辑配置维护(' + caller + ')', "jsps/ma/logic/config.jsp?whoami=" + caller);
				}
			}
		});
	},
	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);
				}
			}
		});
	}
});