Ext.define('saas.view.purchase.purchaseIn.QueryPanel', { extend: 'saas.view.core.query.QueryPanel', xtype: 'purchase-purchasein-querypanel', controller: 'purchase-purchasein-querypanel', viewModel: 'purchase-purchasein-querypanel', viewName: 'purchase-purchasein-querypanel', queryFormItems: [{ xtype: 'hidden', name: 'id', fieldLabel: 'ID', columnWidth: 0 },{ xtype: 'textfield', name: 'pi_inoutno', fieldLabel: '单号/供应商', emptyText:'请输入单号或供应商', getCondition: function(value) { return ' (pi_inoutno like\'%' + value + '%\' or pi_vendcode like \'%'+value+'%\' or pi_vendname like \'%'+value+'%\') '; } }, { xtype: 'textfield', name: 'pd_prodcode', fieldLabel: '物料编号', hidden:true, showDetail: true }, { xtype: 'productDbfindTrigger', name: 'pr_detail', fieldLabel: '物料', emptyText:'输入物料编号或名称', showDetail: true }, { xtype: 'textfield', name: 'pi_pucode', fieldLabel: '关联单号' }, { xtype: 'condatefield', name: 'pi_date', fieldLabel: '日期', columnWidth: 0.5, operation: 'between' }, { xtype: 'combobox', name: 'pi_statuscode', fieldLabel: '单据状态', allowBlank: true, emptyText :'全部', editable:false, queryMode: 'local', 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 + '\''; } } }], queryGridConfig: { idField:'id', codeField:'pi_inoutno', addTitle:'采购验收单', addXtype:'purchase-purchasein-formpanel', defaultCondition:' pi_class = \'采购验收单\'', baseVastUrl:'/api/purchase/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_vendname', width: 150 },{ text: '关联采购单号', dataIndex: 'pi_pucode', width: 150 },{ text: '总金额', dataIndex: 'pi_total', width: 110 },{ text: '单据状态', dataIndex: 'pi_status', width: 90 },{ text: '付款状态', dataIndex: 'pi_prstatus', width: 90 },{ text: '录入人', dataIndex: 'creatorName', width: 110 },{ text: '审核人', dataIndex: 'pi_auditman', width: 110 },{ text: '备注', dataIndex: 'pi_remark', width: 250 }], relativeColumn: [ { text: 'id', dataIndex: 'pu_id', xtype: 'numbercolumn', hidden:true }, { text: '单据编号', dataIndex: 'pi_inoutno', width: 150 }, { text: '单据类型', dataIndex: 'pd_piclass', width: 0 },{ text: '单据日期', dataIndex: 'pi_date', xtype:'datecolumn', width: 110 },{ text: '供应商编号', dataIndex: 'pi_vendcode', width: 0 },{ text: '供应商名称', dataIndex: 'pi_vendname', width: 150 },{ 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: 110, renderer : function(v) { var arr = (v + '.').split('.'); var xr = (new Array(arr[1].length > 3 ? 3 : arr[1].length)).fill('0'); var format = '0,000.' + xr.join(); return Ext.util.Format.number(v, format); }, },{ text: '仓库', dataIndex: 'pd_whname', width: 150 },{ text: '单价', dataIndex: 'pd_orderprice', xtype:'numbercolumn', 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); }, width: 110 },{ 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 > 2 ? 2 : arr[1].length)).fill('0'); var format = '0,000.' + xr.join(); return Ext.util.Format.number(v, format); }, }] } });