Ext.define('erp.view.fa.ars.ProdToARBill.GridPanel',{
extend: 'Ext.grid.Panel',
alias: 'widget.erpProdToARBillGridPanel',
requires: ['erp.view.core.grid.HeaderFilter', 'erp.view.core.toolbar.Toolbar'],
id: 'batchDealGridPanel',
emptyText : $I18N.common.grid.emptyText,
columnLines : true,
autoScroll : true,
multiselected: [],
store: [],
columns: [],
bodyStyle:'background-color:#f1f1f1;',
bbar: {xtype: 'erpToolbar', enableAdd: false, enableDelete: false, enableCopy: false, enablePaste: false, enableUp: false, enableDown: false},
GridUtil: Ext.create('erp.util.GridUtil'),
BaseUtil: Ext.create('erp.util.BaseUtil'),
FormUtil: Ext.create('erp.util.FormUtil'),
plugins: [Ext.create('Ext.grid.plugin.CellEditing', {
clicksToEdit: 1
}), Ext.create('erp.view.core.grid.HeaderFilter'),Ext.create('erp.view.core.plugin.CopyPasteMenu')],
features : [Ext.create('Ext.grid.feature.Grouping',{
//startCollapsed: true,
hideGroupedHeader: true,
groupHeaderTpl: '{name} (Count:{rows.length})'
}),{
ftype : 'summary',
showSummaryRow : false,//不显示默认合计行
generateSummaryData: function(){
var me = this,
data = {},
store = me.view.store,
columns = me.view.headerCt.getColumnsForTpl(),
i = 0,
length = columns.length,
//fieldData,
//key,
comp;
//将feature的data打印在toolbar上面
for (i = 0, length = columns.length; i < length; ++i) {
comp = Ext.getCmp(columns[i].id);
data[comp.id] = me.getSummary(store, comp.summaryType, comp.dataIndex, false);
var tb = Ext.getCmp(columns[i].dataIndex + '_' + comp.summaryType);
if(tb){
tb.setText(tb.text.split(':')[0] + ':' + data[comp.id]);
}
}
return data;
}
}],
selModel: Ext.create('Ext.selection.CheckboxModel',{
ignoreRightMouseSelection : false,
checkOnly:true,
listeners:{
selectionchange:function(selModel, selected, options){
var me = this, grid = selModel.view.ownerCt;
me.countAmount();
grid.summary();
}
},
getEditor: function(){
return null;
},
countAmount: function(record){
var me = this;
var grid = Ext.getCmp('batchDealGridPanel');
var items = grid.selModel.selected.items;
var countamount=0;
var arcount=0;
var taxsum = 0;
var noamounttotal = 0;
var amount = 0, priceFormat = grid.down('gridcolumn[dataIndex=pd_thisvoprice]').format,
fsize = (priceFormat && priceFormat.indexOf('.') > -1) ?
priceFormat.substr(priceFormat.indexOf('.') + 1).length : 6;
if(caller =='ProdInOut!ToARBill!Deal!ars'){
Ext.each(items,function(item,index){
var a = grid.BaseUtil.numberFormat(Number(item.data['pd_thisvoprice']),fsize);
var b = grid.BaseUtil.numberFormat(Number(item.data['pd_thisvoqty']),2);
var rate = grid.BaseUtil.numberFormat(Number(item.data['pi_rate']),2);
var taxrate = grid.BaseUtil.numberFormat(Number(item.data['pd_taxrate']),4);
countamount += grid.BaseUtil.numberFormat(a*(b*100)/100,2);
arcount = arcount + b;
taxsum = taxsum + grid.BaseUtil.numberFormat((a*(b*100)/100)*taxrate/(100+taxrate),2);
noamounttotal = noamounttotal + grid.BaseUtil.numberFormat(Number(item.data['pd_nettotal']),2);
amount = amount + grid.BaseUtil.numberFormat((a*(b*100)/100)*rate,2);
});
//金额合计 不能填写 自动显示所选数据条目的本次发票数*本次发票单价 的总和
Ext.getCmp('pi_amounttotal').setValue(Ext.util.Format.number(countamount, "0.00"));
//开票数量 不能填写 自动显示所选条目的本次发票数的总和
Ext.getCmp('pi_counttotal').setValue(Ext.util.Format.number(arcount, "0.00"));
if(Ext.getCmp('ab_taxamount')){
Ext.getCmp('ab_taxamount')._val = taxsum;
Ext.getCmp('ab_taxamount').setValue(taxsum + Number(Ext.getCmp('ab_differ').value));
}
Ext.getCmp('noamounttotal').setValue(Ext.util.Format.number(noamounttotal, "0.00"));
if(Ext.getCmp('curr_amount')){
Ext.getCmp('curr_amount').setValue(amount);
}
}else if(caller=='ProdInOut!ToAPBill!Deal!ars'){
Ext.each(items,function(item,index){
var a = grid.BaseUtil.numberFormat(Number(item.data['pd_thisvoprice']),fsize);
var b = grid.BaseUtil.numberFormat(Number(item.data['pd_thisvoqty']),2);
var taxrate = grid.BaseUtil.numberFormat(Number(item.data['pd_taxrate']),4);
countamount += grid.BaseUtil.numberFormat(a*(b*100)/100,2);
arcount = arcount + b;
taxsum = taxsum + grid.BaseUtil.numberFormat((a*(b*100)/100)*taxrate/(100+taxrate),2);
noamounttotal = noamounttotal + grid.BaseUtil.numberFormat(Number(item.data['pd_nettotal']),2);
});
//金额合计 不能填写 自动显示所选数据条目的本次发票数*本次发票单价 的总和
Ext.getCmp('pi_amounttotal').setValue(Ext.util.Format.number(countamount, "0.00"));
//开票数量 不能填写 自动显示所选条目的本次发票数的总和
Ext.getCmp('pi_counttotal').setValue(Ext.util.Format.number(arcount, "0.00"));
Ext.getCmp('taxsum')._val = taxsum;
Ext.getCmp('taxsum').setValue(taxsum + Number(Ext.getCmp('differ').value));
Ext.getCmp('noamounttotal').setValue(Ext.util.Format.number(noamounttotal, "0.00"));
}else{
Ext.each(items,function(item,index){
var a = grid.BaseUtil.numberFormat(Number(item.data['pd_thisvoprice']),fsize);
var b = grid.BaseUtil.numberFormat(Number(item.data['pd_thisvoqty']),2);
var taxrate = grid.BaseUtil.numberFormat(Number(item.data['pd_taxrate']),4);
countamount += grid.BaseUtil.numberFormat(a*(b*100)/100,2);
arcount = arcount + b;
taxsum = taxsum + grid.BaseUtil.numberFormat((a*(b*100)/100)*taxrate/(100+taxrate),2);
noamounttotal = noamounttotal + grid.BaseUtil.numberFormat(Number(item.data['pd_nettotal']),2);
});
//金额合计 不能填写 自动显示所选数据条目的本次发票数*本次发票单价 的总和
Ext.getCmp('pi_amounttotal').setValue(Ext.util.Format.number(countamount, "0.00"));
//开票数量 不能填写 自动显示所选条目的本次发票数的总和
Ext.getCmp('pi_counttotal').setValue(Ext.util.Format.number(arcount, "0.00"));
Ext.getCmp('taxsum')._val = taxsum;
Ext.getCmp('taxsum').setValue(taxsum + Number(Ext.getCmp('differ').value));
Ext.getCmp('noamounttotal').setValue(Ext.util.Format.number(noamounttotal, "0.00"));
}
}
}),
setToolbar: function(columns){
var grid = this;
var items = [];
Ext.each(columns, function(column){
if(column.summaryType == 'sum'){
items.push('-',{
id: column.dataIndex + '_sum',
itemId: column.dataIndex,
xtype: 'tbtext',
text: column.text + '(sum):0'
});
} else if(column.summaryType == 'average') {
items.push('-',{
id: column.dataIndex + '_average',
itemId: column.dataIndex,
xtype: 'tbtext',
text: column.text + '(average):0'
});
} else if(column.summaryType == 'count') {
items.push('-',{
id: column.dataIndex + '_count',
itemId: column.dataIndex,
xtype: 'tbtext',
text: column.text + '(count):0'
});
}
});
grid.bbar = {
xtype: 'toolbar',
dock: 'bottom',
items: items
};
},
setRenderer: function(column){
var grid = this;
if(!column.haveRendered && column.renderer != null && column.renderer != ""){
var renderName = column.renderer;
if(contains(column.renderer, ':', true)){
var args = new Array();
Ext.each(column.renderer.split(':'), function(a, index){
if(index == 0){
renderName = a;
} else {
args.push(a);
}
});
if(!grid.RenderUtil.args[renderName]){
grid.RenderUtil.args[renderName] = new Object();
}
grid.RenderUtil.args[renderName][column.dataIndex] = args;
}
column.renderer = grid.RenderUtil[renderName];
column.haveRendered = true;
}
},
/**
* 修改为selection改变时，summary也动态改变
*/
summary: function(){
var me = this,
store = this.store,
value,
items = me.selModel.getSelection();
Ext.each(me.columns, function(c){
if(c.summaryType == 'sum'){
value = me.getSum(items, c.dataIndex);
if(c.xtype == 'numbercolumn') {
value = Ext.util.Format.number(value, (c.format || '0,000.000'));
}
me.down('tbtext[id=' + c.dataIndex + '_sum]').setText(c.text + '(sum):' + value);
} else if(c.summaryType == 'count'){
value = store.getCount();
me.down('tbtext[id=' + c.dataIndex + '_count]').setText(c.text + '(count):' + value);
} else if(c.summaryType == 'average'){
value = store.getAverage(c.dataIndex);
if(c.xtype == 'numbercolumn') {
value = Ext.util.Format.number(value, (c.format || '0,000.000'));
}
me.down('tbtext[id=' + c.dataIndex + '_average]').setText(c.text + '(average):' + value);
}
});
},
getSum: function(records, field) {
if (arguments.length < 2) {
return 0;
}
var total = 0,
i = 0,
len = records.length;
for (; i < len; ++i) {
total += records[i].get(field);
}
return total;
},
setLogicType: function(column, logic, y){
var grid = this;
if(logic == 'detno'){
grid.detno = column.dataIndex;
} else if(logic == 'keyField'){
grid.keyField = column.dataIndex;
} else if(logic == 'mainField'){
grid.mainField = column.dataIndex;
} else if(logic == 'necessaryField'){
grid.necessaryField = column.dataIndex;
if(!grid.necessaryFields){
grid.necessaryFields = new Array();
}
grid.necessaryFields.push(column.dataIndex);
if(!column.haveRendered){
column.renderer = function(val, meta, record, x, y, store, view){
var c = this.columns[y];
if(val != null && val.toString().trim() != ''){
if(c.xtype == 'datecolumn'){
val = Ext.Date.format(val, 'Y-m-d');
}
return val;
} else {
if(c.xtype == 'datecolumn'){
val = '';
}
return '
' +
'' + val + '';
}
};
}
} else if(logic == 'groupField'){
grid.groupField = column.dataIndex;
}
},
initRecords: function(){
var records = this.store.data.items;
var count = 0;
Ext.each(records, function(record){
if(!record.index){
record.index = count++;
}
});
},
headerCt: Ext.create("Ext.grid.header.Container"),
sync: true,
initComponent : function(){
condition = this.BaseUtil.getUrlParam('urlcondition');
this.RenderUtil = Ext.create('erp.util.RenderUtil');
condition = (condition == null) ? "" : condition;
condition = condition.replace(/@/,"'%").replace(/@/,"%'");
// this.defaultCondition = Ext.isEmpty(condition) ? 'abs(pd_invoqty)= 1000) {
var g = this, e = g.down('erpToolbar');
if(!g.bigVolume) {
var m = e.down('tool[name=more]');
if(!m) {
m = Ext.create('Ext.panel.Tool', {
name: 'more',
type: 'right',
margin: '0 5 0 5',
handler: function() {
g.bigVolume = true;
g.ownerCt.down('form').onQuery();
m.disable();
}
});
e.add('->');
e.add(m);
} else {
m.show();
}
}
}
}
});