uas6.0/WebContent/app/controller/pm/make/MakeMaterialIssue.js

Ext.QuickTips.init();
Ext.define('erp.controller.pm.make.MakeMaterialIssue', {
	extend: 'Ext.app.Controller',
	requires: ['erp.util.RenderUtil', 'erp.util.GridUtil', 'erp.util.BaseUtil'],
	views:[
	       'pm.make.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[id=createbc]': {  
	    			   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.turnProdIOBC(grid);
	    					   }
	    				   });
	    			   }
	    		   },
	    		   'button[name=query]': {
	    			   click: function(btn){
	    				   me.onQuery();
	    			   }
	    		   },
	    		   'erpEditorColumnGridPanel' : {
	    			   afterlayout: function(grid) {
	    				   grid.store.on('load', function(store){
	    					   me.getProductWh(grid);
	    				   });
	    			   }
	    		   },
	    		   'checkbox[id=whcode]' : {
	    			   afterrender : function(f) {
	    				   me.getSetting(f, 'GroupWarehouse');
	    			   }
	    		   },
	    		   'checkbox[id=set]' : {
	    			   afterrender : function(f) {
	    				   me.getSetting(f, 'SetOfMaterial');
	    			   }
	    		   },
	    		   'textfield[id=pr_location]':{
	    			   specialkey:function(field,e){   
	    				   if (e.getKey()==Ext.EventObject.ENTER){
	    					   me.onQuery();
	    				   } 
	    			   }   
	    		   }
	    	   });
	       },
	       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: 'MAKE'
	    			   },
	    			   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){
	    					   showMessage('提示', localJson.log);
	    				   }
	    				   if(localJson.success){
	    					   turnSuccess(function(){
	    						   grid.selModel.deselectAll(true);
	    						   grid.multiselected = new Array();
	    					   });
	    				   }
	    				   me.onQuery();
	    			   }
	    		   });
	    	   }
	       },
	       turnProdIOBC: function(grid) {
	    	   var me = this,
	    	   material = this.getEffectData(grid.selModel.getSelection());
	    	   if(material.length > 0){
	    		   Ext.create('Ext.window.Window',{
	    			   width:350,
	    			   height:185,
	    			   id:'win',
	    			   title:'<h1>生成拨出单</h1>',
	    			   layout:'column',
	    			   items:[{
	    				   margin: '10 0 0 0',
	    				   xtype: 'dbfindtrigger',
	    				   fieldLabel: '拨入仓库编号',
	    				   name:'wh_code',
	    				   value: '',
	    				   listeners:{
	    					   aftertrigger:function(t, d){
	    						   t.ownerCt.down('textfield[name=wh_code]').setValue(d.get('wh_code'));
	    						   t.ownerCt.down('textfield[name=inwhname]').setValue(d.get('wh_description'));
	    					   }
	    				   }
	    			   },{
	    				   margin: '3 0 0 0',
	    				   xtype: 'textfield',
	    				   fieldLabel: '拨入仓库名称',
	    				   readOnly:true,
	    				   name:'inwhname',
	    				   value: ''
	    			   }],
	    			   buttonAlign:'center',
	    			   buttons:[{
	    				   xtype:'button',
	    				   columnWidth:0.12,
	    				   text:'确定',
	    				   width:60,
	    				   iconCls: 'x-button-icon-save',
	    				   handler:function(btn){
	    					   var inwhcode=btn.ownerCt.ownerCt.down('dbfindtrigger[name=wh_code]').value;	 
	    					   if(!inwhcode){
	    						   showError('请先填写拨入的仓库编号!') ;  
	    						   return;
	    					   }else{ 
	    						   grid.setLoading(true);//loading... 
	    						   Ext.Ajax.request({
	    							   url : basePath + 'pm/make/turnProdIOBC.action',
	    							   params: {
	    								   data: Ext.encode(material),
	    								   inwhcode: inwhcode ,
	    								   whmancode:Ext.getCmp('pr_whmancode').value
	    							   },
	    							   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){
	    									   showMessage('提示', localJson.log);
	    								   }
	    								   if(localJson.success){
	    									   turnSuccess(function(){
	    										   grid.selModel.deselectAll(true);
	    										   grid.multiselected = new Array();
	    									   });
	    								   }
	    								   Ext.getCmp('win').close();
	    								   me.onQuery();
	    							   }
	    						   });

	    					   }
	    				   }
	    			   },{
	    				   xtype:'button',
	    				   columnWidth:0.1,
	    				   text:'取消',
	    				   width:60,
	    				   iconCls: 'x-button-icon-close',
	    				   margin:'0 0 0 10',
	    				   handler:function(btn){
	    					   Ext.getCmp('win').close();
	    				   }
	    			   }]
	    		   }).show(); 
	    	   }
	       },
	       /**
	        * 筛选
	        */
	       onQuery: function(){
	    	   var grid = Ext.getCmp('grid');
	    	   grid.selModel.deselectAll(true);
	    	   grid.multiselected = new Array();
	    	   //计算thisqty
	    	   var bool=this.calThisQty(grid);
	    	   if(!bool) return;
	    	   //Query
	    	   var condition = null;
	    	   Ext.each(grid.store.data.items, function(item){
	    		   if(item.data['ma_code'] != null && item.data['ma_code'] != ''){
	    			   if(condition == null){
	    				   condition = "(mm_code='" + item.data['ma_code'] + "'";
	    			   } else {
	    				   condition += " OR mm_code='" + item.data['ma_code'] + "'";
	    			   }
	    		   }
	    	   });
	    	   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(condition != null){
	    		   grid.busy = true;
	    		   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)";
	    		   var urlcondition=getUrlParam('urlcondition');
	    		   condition=urlcondition!=null?condition+" and "+urlcondition:condition;
	    		   dg.getGridColumnsAndStore(condition + ' order by mm_maid,mm_detno');
	    		   this.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']);
	    		   }
	    	   });
	    	   var bool=true;
	    	   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);
	    					   bool=false;
	    				   }
	    			   }
	    		   });
	    	   }
	    	   return bool;
	       },
	       /**
	        * 替代料
	        */
	       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 WareHouse on wh_id=mp_warehouseid',
	    			   fields: 'mp_mmid,mp_detno,mp_thisqty,mp_canuseqty,mp_repqty,mp_remark,mp_prodcode,pr_detail,pr_spec,pr_unit,pr_location,wh_code',
	    			   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) {
	    							   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_thisqty: d.MP_THISQTY,
	    								   mm_totaluseqty: d.MP_REPQTY,
	    								   mm_ifrep: 1,
	    								   mm_remark: d.MP_REMARK,
	    								   mm_whcode: d.WH_CODE,
	    								   mm_detno: d.MP_DETNO,
	    								   mm_id: d.MP_MMID,
	    								   isrep: true,
	    								   pr_location:d.PR_LOCATION
	    							   });
	    						   }
	    					   });
	    					   grid.lockrender = false;
	    				   }
	    				   grid.store.fireEvent('load', grid.store);
	    			   }
	    		   }
	    	   });
	       },
	       /**
	        * 转领料前，校验发料套数与领料数
	        */
	       checkQty: function(a, b){
	    	   if(!Ext.getCmp('set').value) {
	    		   return '';
	    	   }
	    	   var c = this.getMixedGroups(b.selModel.getSelection(), ['mm_code', 'mm_id']),
	    	   code,count,q = 0,m = 0,err = '';
	    	   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){
	    		   if (item.get('mm_thisqty') == 0) {
	    			   showError('本次数量不允许为0!');
	    			   return [];
	    		   }
	    		   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'),
	    					   mm_prodcode:item.get('mm_prodcode')
	    		   });
	    	   });
	    	   return d;
	       },
	       getProductWh: function(grid) {
	    	   var codes = [];
	    	   grid.store.each(function(d){
	    		   codes.push("'" + d.get('mm_prodcode') + "'");
	    	   });
	    	   Ext.Ajax.request({
	    		   url: basePath + 'scm/product/getProductwh.action',
	    		   params: {
	    			   codes: codes.join(',')
	    		   },
	    		   callback: function (opt, s, r) {
	    			   if(s) {
	    				   var rs = Ext.decode(r.responseText);
	    				   if(rs.data) {
	    					   grid.productwh = rs.data;
	    				   }
	    			   }
	    		   }
	    	   });
	       },
	       getSetting : function(f, type) {
	    	   Ext.Ajax.request({
	    		   url : basePath + 'common/getFieldData.action',
	    		   async: false,
	    		   params: {
	    			   caller: 'Setting',
	    			   field: 'se_value',
	    			   condition: 'se_what=\'' + type + '\''
	    		   },
	    		   method : 'post',
	    		   callback : function(opt, s, res){
	    			   var r = new Ext.decode(res.responseText);
	    			   if(r.exceptionInfo){
	    				   showError(r.exceptionInfo);return;
	    			   }
	    			   if(r.success && r.data){
	    				   if (r.data == 'false') {
	    					   f.setValue(false);
	    				   } else {
	    					   f.setValue(true);
	    				   }
	    			   }
	    		   }
	    	   });
	       }
});