manage/uas_mall/WebContent/app/controller/pm/outsource/MakeMaterialIssue.js

Ext.QuickTips.init();
Ext.define('erp.controller.pm.outsource.MakeMaterialIssue', {
    extend: 'Ext.app.Controller',
    requires: ['erp.util.RenderUtil', 'erp.util.GridUtil', 'erp.util.BaseUtil'],
    views:[
      		'pm.outsource.MakeMaterialIssue', 'core.grid.Panel5', 'common.editorColumn.GridPanel', 'core.grid.YnColumn',
      		'core.button.CreateDetail', 'core.button.PrintDetail', 'core.trigger.DbfindTrigger'
  	],
	init:function(){
		var me = this;
		me.GridUtil = Ext.create('erp.util.GridUtil');
	    me.BaseUtil = Ext.create('erp.util.BaseUtil');
		this.control({
			'button[id=create]': {
				click: function(btn){
					var grid = Ext.getCmp('editorColumnGridPanel');
					var e = me.checkQty(Ext.getCmp('grid'), grid);
					if(e.length > 0) {
						showError(e);return;
					}
					e = me.check(grid.selModel.getSelection());
					if(e.length > 0) {
						showError(e);return;
					}
					warnMsg("确定要生成领料单吗?", function(btn){
    					if(btn == 'yes'){
    						me.turnOut(grid);
    					}
    				});
				}
			},
			'button[name=query]': {
				click: function(btn){
					me.onQuery();
				}
			},
			'checkbox[id=whcode]' : {
				afterrender : function(f) {
					me.BaseUtil.getSetting('MakeMaterial!OS!issue', 'GroupWarehouse.OS', function(bool) {
						f.setValue(bool);
                    });
				}
			},
			'checkbox[id=set]' : {
				afterrender : function(f) {
					me.BaseUtil.getSetting('MakeMaterial!OS!issue', 'SetOfMaterial.OS', function(bool) {
						f.setValue(bool);
                    });
                    me.BaseUtil.getSetting('MakeMaterial!OS!issue', 'ifCanrepqty', function(v) {
						ifCanrepqty = v;					
					});
					me.BaseUtil.getSetting('MakeMaterial!OS!issue', 'includingLoss', function(v) {//套料数发料是否包含损耗
						ifIncludingLoss = v;					
					});
				}
			},
			'combo[id=groupPurs]': {
				beforerender: function(f) {
					me.BaseUtil.getSetting('MakeMaterial!OS!issue', 'isGroupPurc', function(v) {
						if(v){
							f.show();							
						}
					});
				}
			}
		});
	},
	turnOut: function(grid) {
		var me = this,
			material = this.getEffectData(grid.selModel.getSelection());
		if(material.length > 0){
			grid.setLoading(true);//loading...
			Ext.Ajax.request({
		   		url : basePath + 'pm/make/turnOut.action',
		   		params: {
		   			data: Ext.encode(material),
		   			wh: Ext.getCmp('whcode').checked,
		   			whman: Ext.getCmp('pr_whmancode').value,
		   			caller: caller,
		   			type: 'OS'
		   		},
		   		method : 'post',
		   		callback : function(options,success,response){
		   			grid.setLoading(false);
		   			var localJson = new Ext.decode(response.responseText);
		   			if(localJson.exceptionInfo){
		   				showError(localJson.exceptionInfo);
		   			}
		   			if(localJson.log.indexOf("转入成功") > -1){
		   				showMessage('提示', localJson.log);
		   				/*if(localJson.success){
	    				     turnSuccess(function(){
	    					    grid.multiselected = new Array();
	    				  });
		   			    }*/
		   				me.onQuery();
		   			}else{
		   				showError(localJson.log);
		   			}	    		
		   		}
			});
		}
	},
	/**
	 * 筛选
	 */
	onQuery: function(){
		var me=this,grid = Ext.getCmp('grid');
		//计算thisqty
		this.calThisQty(grid);
		//Query
		var condition = null;
		Ext.each(grid.store.data.items, function(item){
			if(item.data['ma_code'] != null && item.data['ma_code'] != ''){
				if (item.data['ma_id']==null || item.data['ma_id']==''){
					showError('制造单号'+item.data['ma_code']+'必须从放大镜选择');   
				}else{
					if(condition == null){
						condition = "(mm_code='" + item.data['ma_code'] + "'";
					} else {
						condition += " OR mm_code='" + item.data['ma_code'] + "'";
					}
				} 
			}
		});
		if(condition == null){
			condition = " 1=2 ";//未录入有效工单，则不筛选任何数据
		}else{
			condition +=  ")";
		}
		if (Ext.getCmp('pr_whmancode')){
			var whmancode=Ext.getCmp('pr_whmancode'); 
			if (whmancode && whmancode.value!=''){ 
				if (Ext.getCmp('ifnullwhman').checked){
					condition+="and (pr_whmancode='"+whmancode.value+"' or NVL(pr_whmancode,' ')=' ')";
				}else{
					condition+="and pr_whmancode='"+whmancode.value+"'";
				}
			}
		}
		if (Ext.getCmp('pr_location')){
			var location=Ext.getCmp('pr_location'); 
			if (location && location.value!=''){ 
				if (Ext.getCmp('ifnulllocation').checked){
					condition+="and (pr_location like '%"+location.value+"%' or NVL(pr_location,' ')=' ')";
				}else{
					condition+="and pr_location like '%"+location.value+"%'";
				}
			}
		}
		if (Ext.getCmp('ma_wccode')){
			var wccode=Ext.getCmp('ma_wccode'); 
			if (wccode && !Ext.isEmpty(wccode.value)){ 
				condition+="and mm_wccode='"+wccode.value+"'";
			}
		}
		if(Ext.getCmp('groupPurs')){
			var grouppurs = Ext.getCmp('groupPurs');
			if(grouppurs && grouppurs.value != ''){
				condition += " and "+ grouppurs.value ;
			}
		}
		if(condition != null){
			grid.busy = true;
			grid.multiselected = new Array();
			var dg = Ext.getCmp('editorColumnGridPanel');
			dg.busy = true;
			condition += " AND (nvl(mm_materialstatus,' ')=' ') AND (mm_qty-(nvl(mm_havegetqty,0)+nvl(mm_returnmqty,0)-nvl(mm_addqty,0)) > 0)";
			this.BaseUtil.getSetting('MakeMaterial!OS!issue', 'ifDisplayPull', function(val){
				if(!val){
					condition=condition+" and NVL(pr_supplytype,' ')<>'PULL' ";
				}
				dg.getGridColumnsAndStore(condition + ' order by mm_maid,mm_detno');
				me.showReplace(condition, dg);
				setTimeout(function(){
					dg.busy = false;
					grid.busy = false;
				}, 1000);
			});
		}
	},
	/**
	 * 计算可领料数
	 **/
	calThisQty: function(grid){
		var items = grid.store.data.items, idx = new Array();
		Ext.each(items, function(item){
			if(item.data['ma_code'] != null && item.data['ma_code'] != ''){
				idx.push(item.data['ma_id']);
			}
		});
		if(idx.length > 0) {
			Ext.Ajax.request({
				url : basePath + 'pm/make/calThisQty.action',
				async: false,
				params: {
					ids: Ext.Array.concate(idx, ',')
				},
				callback: function(opt, s, r){
					var res = Ext.decode(r.responseText);
					if(res.exceptionInfo) {
						showError(res.exceptionInfo);
					}
				}
			});
		}
	},
	/**
	 * 替代料
	 */
	showReplace: function(condition, grid){
		Ext.Ajax.request({
	   		url : basePath + 'common/getFieldsDatas.action',
	   		params: {
	   			caller: 'MakeMaterialReplace left join MakeMaterial on mm_id=mp_mmid left join Product on mp_prodcode=pr_code left join productwh on pw_whcode=mp_whcode and pw_prodcode=mp_prodcode',
				fields: 'mp_mmid,mp_detno,mp_thisqty,mp_canuseqty,mp_repqty,mp_haverepqty,mp_addqty,mp_returnmqty,mp_remark,mp_prodcode,pr_detail,pr_spec,pr_unit,pr_location,mp_whcode,pw_onhand',
				condition: condition + ' and (mp_thisqty > 0 or mm_thisqty>0)'
	   		},
	   		async: false,
	   		method : 'post',
	   		callback : function(options,success,response){
	   			var localJson = new Ext.decode(response.responseText);
	   			if(localJson.exceptionInfo){
	   				showError(localJson.exceptionInfo);return;
	   			}
    			if(localJson.success){
    				var data = Ext.decode(localJson.data);
    				if(data && data.length > 0) {
    					var idx, store = grid.store, record;
    					grid.lockrender = true;
    					Ext.each(data, function(d){
    						idx = store.find('mm_id', d.MP_MMID);
    						record = store.getAt(idx);
    						if(idx != null && idx >= 0) {
    							if(ifCanrepqty){//如果参数设置为不考虑可替代数
									store.insert(idx + 1, {
										mm_prodcode: d.MP_PRODCODE,
										mm_oneuseqty: record.data.mm_oneuseqty,
										mm_code: record.data.mm_code,
										pr_detail: d.PR_DETAIL,
										pr_spec: d.PR_SPEC,
										pr_unit: d.PR_UNIT,
										mm_canuserepqty: d.MP_CANUSEQTY,
										mm_qty:  record.data.mm_qty,
										mm_thisqty: record.data.mm_thisqty,
										mm_totaluseqty: record.data.mm_totaluseqty,
										mm_havegetqty: record.data.mm_haverepqty,
										mm_returnmqty: record.data.mm_returnmqty,
										mm_addqty: record.data.mm_addqty,
										mm_repqty:record.data.mm_repqty,
										mm_ifrep: 1,
										mm_remark: d.MP_REMARK,
										mm_whcode: d.MP_WHCODE,
										mm_detno: d.MP_DETNO,
										mm_id: d.MP_MMID,
										ma_vendcode:record.data.ma_vendcode,
										isrep: true,
										pr_location: d.PR_LOCATION,
										pw_onhand:d.PW_ONHAND
									});
								}else{
									store.insert(idx + 1, {
	    								mm_prodcode: d.MP_PRODCODE,
										mm_oneuseqty: record.data.mm_oneuseqty,
										mm_code: record.data.mm_code,
										pr_detail: d.PR_DETAIL,
										pr_spec: d.PR_SPEC,
										pr_unit: d.PR_UNIT,
										mm_canuserepqty: d.MP_CANUSEQTY,
										mm_qty: d.MP_CANUSEQTY,
										mm_thisqty: d.MP_THISQTY,
										mm_totaluseqty: d.MP_REPQTY,
										mm_havegetqty: d.MP_HAVEREPQTY,
										mm_returnmqty: d.MP_RETURNMQTY,
										mm_addqty: d.MP_ADDQTY,
										mm_ifrep: 1,
										mm_remark: d.MP_REMARK,
										mm_whcode: d.MP_WHCODE,
										mm_detno: d.MP_DETNO,
										mm_id: d.MP_MMID,
										ma_vendcode:record.data.ma_vendcode,
										isrep: true,
										pr_location: d.PR_LOCATION,
										pw_onhand:d.PW_ONHAND
	    							});
								}
    						}
    					});
    					grid.lockrender = false;
    				}
    				grid.store.fireEvent('load', grid.store);
	   			}
	   		}
		});
	},
	/**
	 * 转领料前，校验发料套数与领料数
	 */
	checkQty: function(a, b){
		var err='' ;
		var c = this.getMixedGroups(b.selModel.getSelection(), ['mm_code', 'mm_id']);
		/*//判断主料加替代料的和不能超过可领料数量
		Ext.Array.each(c,function(i) {
		    var mainqty =0 ,totalqty = 0,detno;
			Ext.Array.each(i.groups,function(j) {
				if(!j.get('isrep')){//主料
					mainqty = j.get('mm_qty') - (j.get('mm_havegetqty') - j.get('mm_addqty') + j.get('mm_returnmqty') )  - j.get('mm_totaluseqty');				
				}
				//计算该mm_id 领料之和
				totalqty +=j.get('mm_thisqty');
				detno = j.get('mm_detno');
			});
			if(totalqty > mainqty){
				err += "工单号["+i.keys.mm_code+"]序号["+detno+"]本次领料数超过可领数("+mainqty+")\n";
			}			
		});*/
		if (((!Ext.getCmp('set').value) && err == '') || (Ext.getCmp('set').value && ifIncludingLoss && err == '')) {
			return '';
		}else if(!Ext.getCmp('set').value && err != ''){
			return err;
		}
		var code,count,q = 0,m = 0;
		a.store.each(function(d){
			code = d.get('ma_code');
			if(!Ext.isEmpty(code)) {
				q = d.get('ma_thisqty');
				Ext.Array.each(c, function(i) {
					if(i.keys.mm_code == code) {
						count = 0;
						m = 0;
						Ext.Array.each(i.groups, function(j){
							if(m == 0)
								m = j.get('mm_oneuseqty');
							count += j.get('mm_thisqty');
						});
						if(Math.round(count - Number(q * m) ,5 ) > 0.0001) {
							err += '\n领料数超出发料套数，工单号[' + code + ']';
						}
					}
				});
			}
		});
		return err;
	},
	getMixedGroups: function(items, fields) {
		var data = new Object(),k,o;
		Ext.Array.each(items, function(d){
			k = '';
			o = new Object();
			Ext.each(fields, function(f){
				k += f + ':' + d.get(f) + ',';
				o[f] = d.get(f);
			});
			if(k.length > 0) {
				if(!data[k]) {
					data[k] = {keys: o, groups: [d]};
				} else {
					data[k].groups.push(d);
				}
			}
		});
		return Ext.Object.getValues(data);
	},
	check: function(items) {
		var e = '';
		Ext.Array.each(items, function(item){
			if(Ext.isEmpty(item.get('mm_whcode'))) {
				e += '\n工单[' + item.get('mm_code') + '],主料序号-替代料序号[' + item.get('mm_detno') + ']仓库为空';
			}
			if(Ext.isEmpty(item.get('mm_thisqty'))) {
				e += '\n工单[' + item.get('mm_code') + '],主料序号-替代料序号[' + item.get('mm_detno') + ']领料数为空';
			}
		});
		return e;
	},
	getEffectData: function(items) {
		var d = new Array();
		Ext.Array.each(items, function(item){
			d.push({
				mm_detno: item.get('mm_detno'),
				mm_code: item.get('mm_code'),
				mm_id: item.get('isrep') == null ? item.get('mm_id') : -item.get('mm_id'),
				mm_thisqty: item.get('mm_thisqty'),
				mm_whcode: item.get('mm_whcode'),
				ma_vendcode: item.get('ma_vendcode'),
				mm_prodcode: item.get('mm_prodcode')
			});
		});
		return d;
	}
});