Ext.define('make.view.osmake.osMakeCheckIn.QueryPanel_2', { extend: 'saas.view.core.query.QueryPanel', xtype: 'osmake-osmakecheckin-querypanel-2', controller: 'osmake-osmakecheckin-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,//单独显示反审核按钮 cancelEnable:false, //单独显示取消 openEnable:false, //显示开启 针对已取消列表 configurable: true, // 允许列设置 } }, viewName: 'osmake-osmakecheckin-querypanel', caller: 'OsMakeIn', //importUploadPath: '/api/osmake/osmakeReturn/saveToFormal', initComponent: function () { var me = this; Ext.apply(me, { queryFormItems: [ { xtype: 'condatefield', name: 'pi_date', fieldLabel: '日期', columnWidth: 0.5, operation: 'between', },{ xtype: 'multiqueryField', columnWidth: 0.4, name: 'multi_query', querys: { "Vend":{"field": "pi_vendname", "dbfinds": [{//仓库 from: 've_name', to: 'pi_vendname' }]}, "BillCode": {"field": "pi_inoutno" ,"desc": "验收单号"}, "MakeCode": {"field": "prodiodetail.pd_ordercode" ,"desc": "外协单号"}, "Prod": {"field": "pr_code", "dbfinds": [{//物料 from: 'pr_code', to: 'pr_code' },{ from: 'pr_detail', to: 'pr_detail' }]}, "Emp":{"field": "prodinout.creatorName", "dbfinds": [{ from: 'em_name', to: 'prodinout.creatorName' }]}, }, setShowDetail: function(v){ this.showDetail = (v == 'Prod' ||v=='MakeCode'); }, }], moreQueryFormItems: [{ xtype: 'condatefield', name: 'pi_date', fieldLabel: '单据日期', columnWidth: 1 },{ xtype: 'vendorDbfindTrigger', name: 'pi_vendname', fieldLabel: '外协厂商' },{ xtype: 'combobox', name: 'pi_currency', fieldLabel: '币别', queryMode: 'local', displayField: 'pi_currency', valueField: 'pi_currency', emptyText :'', editable:false, store: Ext.create('Ext.data.ArrayStore', { fields: ['pi_currency', 'pi_currency'], data: [ ["RMB", "RMB"], ["USD", "USD"], ["HKD", "HKD"] ] }), getCondition: function(value) { if(!value) { return '1=1'; }else { return 'pi_currency=\'' + value + '\''; } } },{ xtype: 'warehouseDbfindTrigger', name: 'pi_whname', fieldLabel: '仓库' },{ xtype: 'productDbfindTrigger', name: 'prodiodetail.pd_prodcode', showDetail: true, fieldLabel: '物料编号' },{ xtype: 'textfield', name: 'pr_detail', fieldLabel: '产品名称', readOnly: true, }, { xtype: 'textfield', name: 'pr_orispeccode', fieldLabel: '产品型号', readOnly: true, }, { editable: false, xtype: "remotecombo", storeUrl: '/api/document/productbrand/getCombo', name: "pr_brand", fieldLabel: "厂家/品牌", hiddenBtn:true },{ xtype: 'combobox', name: 'pi_statuscode', fieldLabel: '审核状态', queryMode: 'local', displayField: 'pi_status', valueField: 'pi_statuscode', emptyText :'全部', editable:false, 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: 'employeeDbfindTrigger', name: 'creatorName', fieldLabel: '录入人', emptyText:'请输入账户名称或姓名', getCondition: function(value) { if(!value) { return '1=1'; }else { return 'prodinout.creatorName like\'%' + value + '%\''; } } }, { xtype: 'employeeDbfindTrigger', name: 'pi_auditman', fieldLabel: '审核人', emptyText:'请输入账户名称或姓名', }], queryGridConfig: { idField: 'id', codeField: 'pi_inoutno', mainIdField:'_id', detailIdField:'pd_id', addTitle: me.addTitle, addXtype: me.addXtype, defaultCondition: me.defaultCondition, baseVastUrl: me.baseVastUrl, caller: 'OsMakeIn', 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_vendname', width: 200 }, { text: '价税合计(元)', xtype: 'numbercolumn', dataIndex: 'pi_total', width: 110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 2, true); } }, { text: '金额(元)', xtype: 'numbercolumn', dataIndex: 'pi_nettotal', width: 110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 2, true); } }, { text: '币种', dataIndex: 'pi_currency', align: 'center', width: 65, }, { text: '审核状态', align: 'center', dataIndex: 'pi_status', width: 80 }, { text: '录入人', align: 'center', dataIndex: 'creatorName', width: 100 }, { text: '审核人', align: 'center', dataIndex: 'pi_auditman', width: 100 }, { text: '审核日期', align: 'center', dataIndex: 'pi_auditdate', xtype: 'datecolumn', width: 100 }, { text: '开票金额', dataIndex: 'pi_billamount', xtype: 'numbercolumn', width: (saas.util.BaseUtil.getBillOutSource("BillOutAPSource") == 'PRODIOAUTO')? 0.0:110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 2, true); } }, { text: '开票状态', dataIndex: 'pi_billstatus', width: (saas.util.BaseUtil.getBillOutSource("BillOutAPSource") == 'PRODIOAUTO')? 0.0:100 }, { text: '备注', dataIndex: 'pi_remark', width: 250 }], relativeColumn: [{ text: 'id', dataIndex: 'pd_id', xtype: 'numbercolumn', hidden: true }, { text: '入库单号', dataIndex: 'pi_inoutno', width: 150 }, { text: '单据日期', dataIndex: 'pi_date', xtype: 'datecolumn', width: 110 }, { text: '供应商名称', dataIndex: 'pi_vendname', width: 200, hidden: true }, { text: '审核状态', align: 'center', dataIndex: 'pi_status', width: 80 }, { text: '物料编号', dataIndex: 'pr_code', width: 150, }, { text: '厂家/品牌', dataIndex: 'pr_brand', width: 100 }, { text: '物料名称', dataIndex: 'pr_detail', width: 150 }, { text: '型号', dataIndex: 'pr_orispeccode', width: 200, renderer: saas.util.RenderUtil['renderer_prod'] }, { text: '规格', dataIndex: 'pr_spec', width: 200 }, { text: '仓库', dataIndex: 'pd_whname', width: 120 }, { text: '数量', dataIndex: 'pd_inqty', xtype: 'numbercolumn', width: 110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFormat(v, 6, true); } }, { text: '单位', dataIndex: 'pr_unit', width: 65 }, { text: '单价(元)', dataIndex: 'pd_netprice', xtype: 'numbercolumn', renderer: function(v, m, r) { return saas.util.BaseUtil.numberFormat(v, 8, true); }, width: 110 }, { text: '含税单价(元)', dataIndex: 'pd_orderprice', xtype: 'numbercolumn', renderer: function(v, m, r) { return saas.util.BaseUtil.numberFormat(v, 8, true); }, width: 110 }, { text: '金额(元)', dataIndex: 'pd_nettotal', xtype: 'numbercolumn', width: 110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 2, true); }, }, { text: '税额(元)', dataIndex: 'pd_taxamount', xtype: 'numbercolumn', width: 110, renderer: function (v, g, r) { v = (r.data["pd_ordertotal"] || 0.0) - (r.data["pd_nettotal"] || 0.0); return saas.util.BaseUtil.numberFixFormat(v, 2, true); } }, { text: '价税合计(元)', dataIndex: 'pd_ordertotal', xtype: 'numbercolumn', width: 110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 2, true); }, }, { text: 'B2B上传状态', dataIndex: 'b2bStatus', textAlign: 'center', width:120, hidden: !Ext.getCmp('mainView').getViewModel().get('enableB2B'), initHidden: !Ext.getCmp('mainView').getViewModel().get('enableB2B'), renderer: function(v) { return v ? v : '待上传' } }, { text: '开票数量', dataIndex: 'pd_auditbillqty', xtype: 'numbercolumn', width: (saas.util.BaseUtil.getBillOutSource("BillOutAPSource") == 'PRODIOAUTO')? 0.0:110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 6, true); } }, { text: '开票金额', dataIndex: 'pd_auditbillamount', xtype: 'numbercolumn', width: (saas.util.BaseUtil.getBillOutSource("BillOutAPSource") == 'PRODIOAUTO')? 0.0:110, renderer: function(v, m, r) { return saas.util.BaseUtil.numberFixFormat(v, 2, true); } }, { text: '开票状态', dataIndex: 'pi_billstatus', width: (saas.util.BaseUtil.getBillOutSource("BillOutAPSource") == 'PRODIOAUTO')? 0.0:100 }, { text: '备注', dataIndex: 'pd_remark', width: 250 }] } }); this.callParent(arguments); }, });