Ext.define('saas.view.stock.appropriationInOut.QueryPanel', { extend: 'saas.view.core.query.QueryPanel', xtype: 'stock-appropriationinout-querypanel', controller: 'stock-appropriationinout-querypanel', viewModel: 'stock-appropriationinout-querypanel', viewName: 'stock-appropriationinout-querypanel', queryFormItems: [{ xtype: 'hidden', name: 'id', fieldLabel: 'ID', allowBlank: true, columnWidth: 0 },{ xtype: 'textfield', name: 'pi_inoutno', emptyText:'请输入单号或物料', showDetail: true, getCondition: function(value) { if(value != '') { return ' (pi_inoutno like\'%' + value + '%\' or pd_prodcode like \'%'+value+'%\' ) '; } } }, { xtype: 'condatefield', name: 'pi_date', fieldLabel: '日期', allowBlank: true, columnWidth: 0.5 }, { xtype: 'combobox', name: 'pi_statuscode', fieldLabel: '状态', allowBlank: true, editable:false, columnWidth: 0.25, showDetail: true, queryMode: 'local', emptyText :'全部', editable:false, displayField: 'pi_status', valueField: 'pi_statuscode', store: Ext.create('Ext.data.ArrayStore', { fields: ['pi_statuscode', 'pi_status'], data: [ ["ALL", "全部"], ["AUDITED", "已审核"], ["UNAUDITED", "未审核"] ] }), getCondition: function(value) { if(value == 'ALL') { return '1=1'; }else { return 'pi_statuscode=\'' + value + '\''; } } },{ xtype: 'warehouseDbfindTrigger', name: 'pd_whcode', fieldLabel: '仓库', emptyText :'请输入仓库名或仓库编号', showDetail: true, getCondition: function(value) { if(value != '') { return ' (pd_whcode like\'%' + value + '%\' or pd_whname like \'%'+value+'%\' or pd_inwhcode like\'%' + value + '%\' or pd_inwhname like \'%'+value+'%\') '; } } }], moreQueryFormItems: [], queryGridConfig: { idField:'id', codeField:'pi_inoutno', addTitle:'调拨单', addXtype:'stock-appropriationinout-formpanel', defaultCondition:' pi_class = \'调拨单\'', baseVastUrl:'/api/storage/prodinout/', baseColumn: [{ text: 'id', dataIndex: 'id', hidden:true, xtype: 'numbercolumn' }, { text: '调拨单号', dataIndex: 'pi_inoutno', width: 150 },{ text: '单据类型', dataIndex: 'pi_class', width: 0 },{ text: '单据日期', dataIndex: 'pi_date', xtype:'datecolumn', width: 110 },{ text: '状态', dataIndex: 'pi_status', width: 90 },{ text: '录入人', dataIndex: 'creatorName', width: 110 },{ text: '审核人', dataIndex: 'pi_auditman', width: 110 },{ text: '备注', dataIndex: 'pi_remark', width: 250 }], relativeColumn: [ { text: 'id', dataIndex: 'pi_id', xtype: 'numbercolumn', hidden:true },{ text: '调拨单号', dataIndex: 'pi_inoutno', width: 150 },{ text: '单据类型', dataIndex: 'pi_class', width: 0 },{ text: '单据日期', dataIndex: 'pi_date', xtype:'datecolumn', width: 110 },{ text: '状态', dataIndex: 'pi_status', width: 90 },{ text: '序号', dataIndex: 'pd_pdno', width: 80 },{ text: '相关单号', dataIndex: 'pd_ordercode', width: 150 },{ text: '物料编号', dataIndex: 'pd_prodcode', width: 150 },{ text: '物料名称', dataIndex: 'pr_detail', width: 200 },{ text: '物料规格', dataIndex: 'pr_spec', width: 150 },{ text: '单位', dataIndex: 'pr_unit', width: 80 },{ text: '数量', dataIndex: 'pd_inqty', xtype:'numbercolumn', width: 10 },{ text: '仓库', dataIndex: 'pd_whname', width: 150 },{ text: '单价', dataIndex: 'pd_orderprice', xtype:'numbercolumn', width: 110, renderer : function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length)).fill('0'); var format = '0,000.' + xr.join(); return Ext.util.Format.number(v, format); } },{ text: '税率', dataIndex: 'pd_taxrate', xtype:'numbercolumn', width: 80, renderer : function(v) { return Ext.util.Format.number(v, '0'); }, },{ text: '金额', dataIndex: 'pd_total', xtype:'numbercolumn', width: 110, renderer : function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length)).fill('0'); var format = '0,000.' + xr.join(); return Ext.util.Format.number(v, format); } },{ text: '备注', dataIndex: 'pd_remark', width:250 }] } });