Ext.define('make.view.make.makeBase.QueryPanel_1', {
extend: 'saas.view.core.query.QueryPanel',
xtype: 'make-makebase-querypanel-1',
controller: 'make-makebase-querypanel',
viewModel: {
extend: 'saas.view.core.query.QueryPanelModel',
data: {
form: {}, // 查询字段记录
addEnable: false, // 显示新增按钮
auditEnable: false, // 显示审核按钮
printEnable: false, // 显示打印按钮
importEnable: false, // 显示导入按钮
exportEnable: true, // 显示导出按钮
closeEnable: false, // 显示关闭按钮
deleteEnable: false, // 显示删除按钮
deleteDisable:false, //删除按钮是否可使用
openAudit:false,//单独显示审核按钮
openUnAudit:true,//单独显示反审核按钮
openEnable:false, //显示开启 针对已取消列表
configurable: true, // 允许列设置
}
},
viewName: 'make-makebase-querypanel',
caller: 'MakeBase',
//importUploadPath: '/api/purchse/makereturn/saveToFormal',
initComponent: function () {
var me = this;
Ext.apply(this, {
queryFormItems: [{
xtype: 'condatefield',
name: 'make.createTime',
fieldLabel: '日期',
columnWidth: 0.4,
minWidth:430,
value: '7',
operation: 'between',
},{
xtype: 'multiqueryField',
columnWidth: 0.4,
name: 'multi_query',
querys: {
"Prod": {"field": "ma_prodcode", "dbfinds": [{//物料
from: 'pr_code',
to: 'ma_prodcode'
},{
from: 'pr_detail',
to: 'pr_detail'
}]},
"MakeCode": {"field": "ma_code" ,"desc": "制造单号"},
"BillCode": {"field": "ma_salecode" ,"desc": "订单号"},
"Cust": {"field": "ma_custname", "dbfinds": [{
from: 'cu_name',
to: 'ma_custname'
}]},
"Emp":{"field": "make.creatorName", "dbfinds": [{
from: 'em_name',
to: 'make.creatorName'
}]},
},
setShowDetail: function(v){
this.showDetail = false;
}
},{
xtype: 'checkbox',
boxLabel: '展开明细',
name:'showDetail',
showDetail: true,
columnWidth: 0.1,
minWidth:75,
margin: '0 0 0 8',
getCondition: function (value) {
return '1=1';
},
listeners:{
change:function(t,n,o){
if(n != o){
var grid = t.ownerCt.ownerCt.down('core-query-querygridpanel');
/*groupField:'ma_code',
groupHeaderTpl: Ext.create('Ext.XTemplate',
'
'
),*/
grid.store.load();
}
}
}
}],
moreQueryFormItems: [{
xtype: 'saledetailDbfindTrigger',
name: 'ma_salecode',
fieldLabel: '订单编号'
},{
xtype: "customerDbfindTrigger",
name: "ma_custname",
fieldLabel: "客户名称",
},{
xtype: 'condatefield',
name: 'ma_delivery',
fieldLabel: '交货日期',
value:7,
columnWidth: 1
},{
xtype: 'productDbfindTrigger',
name: 'ma_prodcode',
fieldLabel: '物料编号'
},{
xtype: 'textfield',
name: 'pr_detail',
fieldLabel: '产品名称',
readOnly: true,
}, {
xtype: 'textfield',
name: 'pr_orispeccode',
fieldLabel: '产品型号',
readOnly: true,
}, {
xtype: "remotecombo",
name: "pr_brand",
fieldLabel: "厂家/品牌",
storeUrl: '/api/document/productbrand/getCombo',
editable: false,
hiddenBtn:true
},{
xtype: "remotecombo",
name: "ma_kind",
fieldLabel: "制造类型",
storeUrl:'/api/make/kind/list/make',
valueField:'mk_name',
displayField: 'mk_name',
editable: false,
hiddenBtn:true
},{
xtype: 'remotecombo',
name: "ma_wcname",
fieldLabel: "工作中心",
storeUrl: '/api/document/workcenter/getCombo',
editable: false,
hiddenBtn:true
},{
xtype: 'combobox',
name: 'ma_statuscode',
fieldLabel: '审核状态',
queryMode: 'local',
displayField: 'ma_status',
valueField: 'ma_statuscode',
emptyText :'全部',
editable:false,
store: Ext.create('Ext.data.ArrayStore', {
fields: ['ma_statuscode', 'ma_status'],
data: [
["ALL", "全部"],
["AUDITED", "已审核"],
["UNAUDITED", "未审核"]
]
}),
getCondition: function(value) {
if(value == 'ALL') {
return '1=1';
}else {
return 'ma_statuscode=\'' + value + '\'';
}
}
}, {
xtype: 'employeeDbfindTrigger',
name: 'creatorName',
fieldLabel: '录入人',
emptyText:'请输入账户名称或姓名',
getCondition: function(value) {
if(!value) {
return '1=1';
}else {
return 'make.creatorName like\'%' + value + '%\'';
}
}
},{
xtype: 'condatefield',
name: 'ma_planbegindate',
fieldLabel: '计划开工日期',
value:7,
columnWidth: 1
},{
xtype: 'condatefield',
name: 'ma_planenddate',
fieldLabel: '计划完工日期',
value:7,
columnWidth: 1
},{
xtype: 'condatefield',
name: 'make.createTime',
fieldLabel: '录入日期',
value:7,
columnWidth: 1
}, {
xtype: 'employeeDbfindTrigger',
name: 'ma_auditman',
fieldLabel: '审核人',
emptyText:'请输入账户名称或姓名',
}],
queryGridConfig: {
idField: 'ma_id',
codeField: 'ma_code',
mainIdField:'ma_id',
detailIdField:'mm_id',
addTitle: '制造单',
addXtype: 'make-makebase-formpanel',
baseVastUrl: '/api/make/make/',
caller: 'MakeBase',
defaultCondition:me.defaultCondition,
toolBtns: [{
text: '转领料',
xtype: 'button',
handler: 'onPick',
},{
text: '结案',
xtype: 'button',
handler: 'onEnd',
}],
baseColumn: [{
text: 'id',
dataIndex: 'ma_id',
hidden: true,
xtype: 'numbercolumn'
}, {
text: '制造单号',
dataIndex: 'ma_code',
width: 150
}, {
text: '单据日期',
dataIndex: 'createTime',
xtype: 'datecolumn',
width: 110
}, {
text: '销售单号',
dataIndex: 'ma_salecode',
width: 0
}, {
text: '客户名称',
dataIndex: 'ma_custname',
width: 150
}, {
text: '交货日期',
align: 'center',
dataIndex: 'ma_delivery',
width: 110,
xtype:'datecolumn'
},{
text: '产品编号',
dataIndex: 'ma_prodcode',
width: 150
},{
text: '产品名称',
dataIndex: 'ma_prdetail',
width: 150
},{
text: '产品型号',
dataIndex: 'ma_prorispeccode',
width: 150,
renderer : saas.util.RenderUtil['renderer_makeprod']
},{
text: '单位',
align: 'center',
dataIndex: 'ma_prunit',
width: 80
},{
text: '数量',
align: 'center',
dataIndex: 'ma_qty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '已完工数',
align: 'center',
dataIndex: 'ma_madeqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '已领齐套数',
align: 'center',
dataIndex: 'ma_setqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 0, true);
},
},{
text: '可完工数',
align: 'center',
dataIndex: 'ma_canmadeqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '制造类型',
dataIndex: 'ma_kind',
width: 100,
},{
text: '工作中心',
dataIndex: 'ma_wcname',
width: 100,
},{
text: '审核状态',
dataIndex: 'ma_status',
align: 'center',
width: 100,
},{
text: '领料状态',
dataIndex: 'ma_getstatus',
align: 'center',
width: 100,
},{
text: '完工状态',
dataIndex: 'ma_finishstatus',
align: 'center',
width: 100,
},{
text: '制单人',
dataIndex: 'creatorName',
align: 'center',
width: 100,
},{
text: '计划开工日期',
dataIndex: 'ma_planbegindate',
width: 130,
xtype:'datecolumn'
},{
text: '计划完工日期',
dataIndex: 'ma_planenddate',
width: 130,
xtype:'datecolumn'
},{
text: '实际开工日期',
dataIndex: 'ma_actbegindate',
width: 130,
xtype:'datecolumn'
},{
text: '实际完工日期',
dataIndex: 'ma_actenddate',
width: 130,
xtype:'datecolumn'
},{
text: '结案日期',
dataIndex: 'ma_enddate',
width: 130,
xtype:'datecolumn'
},{
text: '备注',
dataIndex: 'ma_remark',
width: 100
}],
relativeColumn: [{
text: 'id',
dataIndex: 'id',
hidden: true,
xtype: 'numbercolumn'
},{
text: '本次数量',
align: 'center',
dataIndex: 'mm_thisqty',
xtype: 'widgetcolumn',
width: 110,
widget: {
xtype: "numberfield",
cls:'widget-number',
bind: '{record.mm_thisqty}',
decimalPrecision: 6,
minValue: 0,
listeners:{
blur: function(f ,event, e){
var record = f.lookupViewModel().data.record,
maxVal,nowVal;
if(record){
if(!Ext.isEmpty(record.modified['mm_thisqty'])){ //若存在修改
maxVal = record.modified['mm_thisqty'];
nowVal = f.value;
if(Ext.isEmpty(nowVal)){
record.set('mm_thisqty', maxVal)
}else if(nowVal>maxVal){
record.set('mm_thisqty', maxVal)
saas.util.BaseUtil.showErrorToast('请不要输入超过最大数量' + maxVal + "的值!");
}
}
}
}
}
}
},{
text: '制造单号',
dataIndex: 'ma_code',
width: 150
}, {
text: '单据日期',
dataIndex: 'createTime',
xtype: 'datecolumn',
width: 110
},{
text: '工单序号',
dataIndex: 'mm_detno',
align: 'center',
width: 80
},{
text: '物料编号',
dataIndex: 'mm_prodcode',
width: 150
},{
text: '物料名称',
dataIndex: 'pr_detail',
width: 150
},{
text: '物料规格',
dataIndex: 'pr_desc',
width: 150
},{
text: '单位',
align: 'center',
dataIndex: 'pr_unit',
width: 80
},{
text: '单位用量',
align: 'center',
dataIndex: 'mm_oneuseqty',
width: 80
},{
text: '需求数',
align: 'center',
dataIndex: 'mm_qty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '已领数',
align: 'center',
dataIndex: 'mm_havegetqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '已转领数',
align: 'center',
dataIndex: 'mm_turngetqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '未领数',
align: 'center',
dataIndex: 'mm_restgetqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
v = r.get('mm_qty') + (r.get('mm_scrapqty')||0) - (r.get('mm_havegetqty')||0)-(r.get('mm_turngetqty')||0);
return saas.util.BaseUtil.numberFormat(v, 6, true);
}
},{
text: '制程不良数',
align: 'center',
dataIndex: 'mm_returnmqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '报废数',
align: 'center',
dataIndex: 'mm_turnscrapqty',
xtype: 'numbercolumn',
width: 110,
renderer : function(v, m, r) {
return saas.util.BaseUtil.numberFormat(v, 6, true);
},
},{
text: '备注',
dataIndex: 'ma_remark',
width: 100
}]
}
});
this.callParent(arguments);
},
});