Ext.define('saas.view.sale.saleout.QueryPanel', { extend: 'saas.view.core.query.QueryPanel', xtype: 'sale-saleout-querypanel', controller: 'sale-saleout-querypanel', viewModel: 'sale-saleout-querypanel', viewName: 'sale-saleout-querypanel', queryFormItems: [{ xtype: 'textfield', name: 'pi_inoutno', emptyText:'请输入单号或客户名称', getCondition: function(value) { return ' (pi_inoutno like\'%' + value + '%\' or pi_custcode like \'%'+value+'%\' or pi_custname like \'%'+value+'%\' ) '; } },{ margin:'0 0 0 20', xtype: 'productDbfindTrigger', name: 'pr_detail', showDetail: true, emptyText:'输入物料编号、名称或型号' }, { xtype: 'condatefield', name: 'pi_date', fieldLabel: '日期', allowBlank: true, columnWidth: 0.5 },{ xtype: 'combobox', name: 'pi_statuscode', fieldLabel: '单据状态', 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: 'multicombo', name: 'pi_prstatuscode', fieldLabel: '收款状态', emptyText :'全部', datas: [ ["RECNONE", "未收款"], ["RECPART", "部分收款"], ["RECALL", "已收款"] ] }, { xtype: 'warehouseDbfindTrigger', name: 'pd_whname', emptyText:'请输入仓库编号或名称', fieldLabel: '仓库', showDetail: true }, { xtype: 'textfield', name: 'pi_sacode', fieldLabel: '关联销售单号', emptyText: '请输入关联销售单号', }, { xtype: 'accountDbfindTrigger', name: 'creatorName', fieldLabel: '录入人', emptyText: '请输入账户名称或姓名', getCondition: function(value) { if(!value) { return '1=1'; }else { return 'prodinout.creatorName like\'%' + value + '%\''; } } }, { xtype: 'accountDbfindTrigger', name: 'pi_auditman', fieldLabel: '审核人', emptyText: '请输入账户名称或姓名', }], moreQueryFormItems: [], queryGridConfig: { idField:'id', codeField:'pi_inoutno', addTitle:'出货单', addXtype:'sale-saleout-formpanel', defaultCondition:' pi_class = \'出货单\'', baseVastUrl: '/api/sale/prodinout/', caller:'SaleOut', baseColumn: [{ text: 'id', dataIndex: 'id', hidden:true, xtype: 'numbercolumn' }, { text: '出货单号', dataIndex: 'pi_inoutno', width: 150 }, { text: '单据日期', dataIndex: 'pi_date', xtype:'datecolumn', width: 110 },{ text: '客户名称', dataIndex: 'pi_custname', width: 200 }, { text: '金额(元)', dataIndex: 'pi_nettotal', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 2, true); }, }, { text: '价税合计(元)', dataIndex: 'pi_total', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 2, true); } },{ text: '币别', align: 'center', dataIndex: "pi_currency", defaultValue: 'RMB', width:80, }, { text: '审核状态', align: 'center', dataIndex: 'pi_status', width: 80 },{ text: '收款状态', align: 'center', dataIndex: 'pi_prstatus', width: 80 }, { text: '关联销售单号', dataIndex: 'pi_sacode', width: 150 }, { text: '备注', dataIndex: 'pi_remark', width: 250 }], relativeColumn: [{ text: 'id', dataIndex: 'id', hidden:true, xtype: 'numbercolumn' }, { text: '出货单号', dataIndex: 'pi_inoutno', width: 150 }, { text: '单据日期', dataIndex: 'pi_date', xtype:'datecolumn', width: 110 },{ text: '客户名称', dataIndex: 'pi_custname', width: 200 },{ text: '币别', align: 'center', dataIndex: "pi_currency", defaultValue: 'RMB', width:80 }, { text: '审核状态', align: 'center', dataIndex: 'pi_status', width: 80 }, { text: '物料编号', dataIndex: 'pd_prodcode', width: 150 },{ text: '品牌', dataIndex: 'pr_brand', width: 100 },{ text: '物料名称', dataIndex: 'pr_detail', width: 150 },{ text: '型号', dataIndex: 'pr_orispeccode', width: 200 }, { text: '规格', dataIndex: 'pr_spec', width: 150 },{ text: '仓库', dataIndex: 'pd_whname', width: 120 }, { text: '数量', dataIndex: 'pd_outqty', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 3, false); } }, { text: '单位', dataIndex: 'pr_unit', width: 65 }, { text: '单价(元)', dataIndex: 'pd_netprice', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 4, true); } }, { text: '含税单价(元)', dataIndex: 'pd_sendprice', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 4, true); } }, { text: '金额(元)', dataIndex: 'pd_nettotal', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 2, true); } }, { text: '税额(元)', dataIndex: 'pd_taxamount', xtype:'numbercolumn', width: 110, renderer : function(v,g,r) { return saas.util.BaseUtil.numberFormat(v, 2, true); } }, { text: '价税合计(元)', dataIndex: 'pd_ordertotal', xtype:'numbercolumn', width: 110, renderer : function(v) { return saas.util.BaseUtil.numberFormat(v, 2, true); } }, { text: '关联销售单号', dataIndex: 'pd_ordercode', width: 150 }, { text: '备注', dataIndex: 'pd_remark', width: 250 }] } });