/**
*
*/
Ext.define('erp.view.fa.ars.cmQuery.CmDetailGrid',{
extend: 'Ext.grid.Panel',
alias: 'widget.cmdetailgrid',
layout : 'fit',
id: 'cmdetailgrid',
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:'客户名称: '+custname,
hideLabel:true,
labelWidth:'100'
},'','','','',{
xtype: 'displayfield',
name: 'cm_currency',
id: 'cm_currency',
fieldLabel: '币别',
hideLabel:true,
value:'币别: '+currency,
labelWidth:'50'
},'','','','',{
xtype: 'displayfield',
name: 'cm_yearmonth',
id: 'cm_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_vouc',
type: 'string'
},{
name: 'tb_date',
type: 'string'
},{
name: 'tb_aramount',
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_rbamount',
type: 'string'
},{
name: 'tb_rbamounts',
type: 'string'
},{
name: 'tb_aramounts',
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_vouc',
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_aramount',
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_rbamount',
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_aramounts',
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_rbamounts',
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;
}
}
}],
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_vouc',
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_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_aramount',
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;
}
}else if(record.data['tb_index']==2){
val = Ext.util.Format.number(val,'0,000.00');
return val;
}
}
},{
dataIndex: 'tb_rbamount',
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;
}
}else if(record.data['tb_index']==2){
val = Ext.util.Format.number(val,'0,000.00');
return val;
}
}
},{
dataIndex: 'tb_aramounts',
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_rbamounts',
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';
}
}
}
});