/** * */ Ext.define('erp.view.fa.arp.vmCopQuery.VmDetailGrid',{ extend: 'Ext.grid.Panel', alias: 'widget.vmcopdetailgrid', layout : 'fit', id: 'vmcopdetailgrid', emptyText : $I18N.common.grid.emptyText, columnLines : true, autoScroll : true, dockedItems : [{ xtype: 'toolbar', dock: 'top', items: [{ name: 'query', text: $I18N.common.button.erpQueryButton, iconCls: 'x-button-icon-query', cls: 'x-btn-gray' },'->',{ name: 'export', text: $I18N.common.button.erpExportButton, iconCls: 'x-button-icon-excel', cls: 'x-btn-gray', margin: '0 4 0 0' },'-',{ name: 'print', text: $I18N.common.button.erpPrintButton, iconCls: 'x-button-icon-print', margin: '0 4 0 0', cls: 'x-btn-gray' },'-',{ text: $I18N.common.button.erpCloseButton, iconCls: 'x-button-icon-close', id:'close', cls: 'x-btn-gray', margin: '0 4 0 0', handler: function(){ var main = parent.Ext.getCmp("content-panel"); main.getActiveTab().close(); } }] },{ xtype: 'toolbar', dock: 'top', items: [{ xtype: 'displayfield', fieldLabel: '供应商名称', value:'供应商名称:    '+vendname, hideLabel:true, labelWidth:'100' },'',{ xtype: 'displayfield', fieldLabel: '公司名', value:'公司名:    '+cop, hideLabel:true, labelWidth:'100' },'',{ xtype: 'displayfield', name: 'vm_currency', id: 'vm_currency', fieldLabel: '币别', hideLabel:true, value:'币别:    '+currency, labelWidth:'50' },'','','','',{ xtype: 'displayfield', name: 'vm_yearmonth', id: 'vm_yearmonth', labelAlign:'left', hideLabel:true, labelWidth:'50', fieldLabel:'期间', value:'期间:    '+yearmonth }] }], store: Ext.create('Ext.data.Store', { fields:[{ name: 'tb_code', type: 'string' },{ name: 'tb_kind', type: 'string' },{ name: 'tb_remark', type: 'string' },{ name: 'tb_date', type: 'string' },{ name: 'tb_apamount', type: 'string' },{ name: 'tb_inoutno', type: 'string' },{ name: 'tb_pdno', type: 'string' },{ name: 'tb_ordercode', type: 'string' },{ name: 'tb_prodcode', type: 'string' },{ name: 'tb_qty', type: 'string' },{ name: 'tb_price', type: 'string' },{ name: 'tb_pbamount', type: 'string' },{ name: 'tb_balance', type: 'string' },{ name: 'tb_index', type: 'number' },{ name: 'tb_id', type:'number' }], data: [] }), /* * 备注: *tb_index *value = 1 应收明细 ,发出商品 第一行期初余额详情 *value = 2 应收明细,发出商品 中间的信息详情 *value = 3 应收明细,发出商品 最后一行期余额详情 *value = 4 第二 三张表的表头 *value = 5 空白行 *value = 6 发货单明细 * */ defaultColumns: [{ dataIndex: 'tb_date', cls: 'x-grid-header-1', text: '日期', width: 100, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_kind', cls: 'x-grid-header-1', text: '单据类型', width: 120, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_code', cls: 'x-grid-header-1', text: '单据编号', width: 150, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_remark', cls: 'x-grid-header-1', text: '描述', width: 200, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_apamount', cls: 'x-grid-header-1', text: '应付金额', width: 120, align:'right', xtype:'numbercolumn', renderer:function(val, meta, record, x, y, s){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==1||record.data['tb_index']==3||record.data['tb_index']==6){ if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } /* if (record.get('tb_index') == 3) {// 期末余额 var d = 0; s.data.each(function(i){ if(i.get('tb_index') == 1 || i.get('tb_index') == 2) { d += Number(i.get('tb_apamount')); } }); val = d; } if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } */}else if(record.data['tb_index']==2){ val = Ext.util.Format.number(val,'0,000.00'); return val; } } },{ dataIndex: 'tb_pbamount', cls: 'x-grid-header-1', text: '付款金额', width: 120, align:'right', xtype:'numbercolumn', renderer:function(val, meta, record, x, y, s){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==1||record.data['tb_index']==3||record.data['tb_index']==6){ if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } /* if (record.get('tb_index') == 3) {// 期末余额 var d = 0; s.data.each(function(i){ if(i.get('tb_index') == 1 || i.get('tb_index') == 2) { d += Number(i.get('tb_pbamount')); } }); val = d; } if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } */}else if(record.data['tb_index']==2){ val = Ext.util.Format.number(val,'0,000.00'); return val; } } },{ dataIndex: 'tb_balance', cls: 'x-grid-header-1', text: '余额', width: 120, align:'right', xtype:'numbercolumn', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==6){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } } }], detailColumns: [{ dataIndex: 'tb_date', cls: 'x-grid-header-1', text: '日期', width: 100, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_kind', cls: 'x-grid-header-1', text: '单据类型', width: 120, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_code', cls: 'x-grid-header-1', text: '单据编号', width: 150, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_remark', cls: 'x-grid-header-1', text: '描述', width: 100, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_inoutno', cls: 'x-grid-header-1', text: '出入库单号', width: 130, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_pdno', cls: 'x-grid-header-1', text: '出入库序号', width: 100, align: 'center', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ if (val == 0) return ''; return val; } } },{ dataIndex: 'tb_ordercode', cls: 'x-grid-header-1', text: '采购单号', width: 150, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_prodcode', cls: 'x-grid-header-1', text: '物料编号', width: 150, renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else{ return val; } } },{ dataIndex: 'tb_qty', cls: 'x-grid-header-1', text: '数量', width: 100, align:'right', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==1||record.data['tb_index']==3){ if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0'); return val; } }else if(record.data['tb_index']==2||record.data['tb_index']==6){ val = Ext.util.Format.number(val,'0'); return val; } } },{ dataIndex: 'tb_price', cls: 'x-grid-header-1', text: '单价', width: 100, align:'right', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==1||record.data['tb_index']==3){ if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } }else if(record.data['tb_index']==2||record.data['tb_index']==6){ val = Ext.util.Format.number(val,'0,000.00'); return val; } } },{ dataIndex: 'tb_apamount', cls: 'x-grid-header-1', text: '应付金额', width: 120, align:'right', xtype:'numbercolumn', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==1||record.data['tb_index']==3||record.data['tb_index']==6){ if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } }else if(record.data['tb_index']==2){ val = Ext.util.Format.number(val,'0,000.00'); return val; } } },{ dataIndex: 'tb_pbamount', cls: 'x-grid-header-1', text: '付款金额', width: 120, align:'right', xtype:'numbercolumn', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==1||record.data['tb_index']==3||record.data['tb_index']==6){ if(val==0||val=='0'){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } }else if(record.data['tb_index']==2){ val = Ext.util.Format.number(val,'0,000.00'); return val; } } },{ dataIndex: 'tb_balance', cls: 'x-grid-header-1', text: '余额', width: 120, align:'right', xtype:'numbercolumn', renderer:function(val, meta, record){ if(record.data['tb_index']==4||record.data['tb_index']==5){ val = '
'+val+'
'; return val; }else if(record.data['tb_index']==6){ return ''; }else{ val = Ext.util.Format.number(val,'0,000.00'); return val; } } }], // bodyStyle:'background-color:#f1f1f1;', GridUtil: Ext.create('erp.util.GridUtil'), RenderUtil: Ext.create('erp.util.RenderUtil'), initComponent : function(){ this.columns = this.defaultColumns; this.callParent(arguments); }, viewConfig: { getRowClass: function(record) { // return record.get('isCount') ? 'isCount' : null; if(record.get('tb_index')=='4'){ return 'custom-total'; } } } });