| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241 |
- Ext.QuickTips.init();
- Ext.define('erp.controller.pm.outsource.MakeMaterialGive', {
- extend: 'Ext.app.Controller',
- requires: ['erp.util.RenderUtil', 'erp.util.GridUtil', 'erp.util.BaseUtil'],
- views:[
- 'pm.outsource.MakeMaterialGive', '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){
- warnMsg("确定要生成补料单吗?", function(btn){
- if(btn == 'yes'){
- var grid = Ext.getCmp('editorColumnGridPanel');
- me.turnAdd(grid);
- }
- });
- }
- },
- 'button[name=query]': {
- click: function(btn){
- me.onQuery();
- }
- },
- 'checkbox[id=whcode]' : {
- afterrender : function(f) {
- me.BaseUtil.getSetting('MakeMaterial!OS!Give', 'GroupWarehouse.OS', function(bool) {
- f.setValue(bool);
- });
- }
- },
- 'combo[id=groupPurs]': {
- beforerender: function(f) {
- me.BaseUtil.getSetting('MakeMaterial!OS!Give', 'isGroupPurc', function(v) {
- if(v){
- f.show();
- }
- });
- }
- },
- 'dbfindtrigger[name=ma_code]':{
- aftertrigger:function(){
- var record = Ext.getCmp('grid').selModel.getLastSelected();
- record.set('ma_thisqty',0);
- }
- }
- });
- },
- onQuery: function(){
- var grid = Ext.getCmp('grid');
- //计算thisqty
- this.calAddQty(grid);
- 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_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('groupPurs')){
- var grouppurs = Ext.getCmp('groupPurs');
- if(grouppurs && grouppurs.value != ''){
- condition += " and "+ grouppurs.value ;
- }
- }
- if(condition != null){
- grid.multiselected = new Array();
- grid.busy = true;
- var dg = Ext.getCmp('editorColumnGridPanel');
- dg.busy = true;
- condition += " AND ( nvl(mm_scrapqty,0)+nvl(mm_returnmqty,0)-nvl(mm_balance,0)-nvl(mm_addqty,0)-NVL(mm_turnaddqty,0)>0)";
- dg.getGridColumnsAndStore(condition + ' order by mm_maid,mm_detno');
- this.showReplace(condition, dg);
- setTimeout(function(){
- dg.busy = false;
- grid.busy = false;
- }, 1000);
- }
-
- },
- /**
- * 计算可补料数
- **/
- calAddQty: 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/calAddQty.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 make on mm_maid=ma_id 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,mm_thisqty as mp_thisqty,mp_canuseqty,mp_repqty,mp_haverepqty,mm_turnaddqty,mp_remark,mp_prodcode,pr_detail,pr_spec,pr_unit,pr_location,mp_whcode,ma_vendcode,mp_whcode,pw_onhand',
- condition: condition + ' and ( nvl(mm_scrapqty,0)+nvl(mm_returnmqty,0)-nvl(mm_balance,0)-nvl(mm_addqty,0)-NVL(mm_turnaddqty,0)>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_havegetqty: d.MP_HAVEREPQTY,
- mm_qty: d.MP_CANUSEQTY,
- mm_turnaddqty: d.MM_TURNADDQTY,
- mm_ifrep: 1,
- mm_remark: d.MP_REMARK,
- mm_whcode: d.MP_WHCODE,
- mm_detno: d.MP_DETNO,
- mm_id: d.MP_MMID,
- isrep: true,
- pr_location:d.PR_LOCATION,
- ma_vendcode: d.MA_VENDCODE,
- pw_onhand:d.PW_ONHAND
- });
- }
- });
- grid.lockrender = false;
- }
- grid.store.fireEvent('load', grid.store);
- grid.fireEvent('storeloaded', grid);
- }
- }
- });
- },
- turnAdd: function(grid) {
- var me = this,
- material = me.getEffectData(grid.selModel.getSelection());
- if(material.length > 0){
- grid.setLoading(true);//loading...
- Ext.Ajax.request({
- url : basePath + 'pm/make/turnAdd.action',
- params: {
- data: Ext.encode(material),
- wh: Ext.getCmp('whcode').checked,
- 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){
- showMessage('提示', localJson.log);
- }
- if(localJson.success){
- turnSuccess(function(){
- grid.multiselected = new Array();
- });
- }
- me.onQuery();
- }
- });
- }
- },
- 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')
- });
- });
- return d;
- }
- });
|