uas6.0/WebContent/app/view/fa/ars/ProdToARBill/GridPanel.js

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 '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' + 
			  			'<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
					}
			   };
			}
		} 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)<abs(pd_inqty-pd_outqty)' : 
//			(condition + ' AND abs(pd_invoqty)<abs(pd_inqty-pd_outqty)');
		var gridParam = {caller: caller, condition: condition};
    	this.GridUtil.getGridColumnsAndStore(this, 'common/singleGridPanel.action?', gridParam, "");
    	this.callParent(arguments); 
	},
	listeners : {
		storeloaded : function(grid, data) {
			this.setMore(data.length);
		}
	},
	setMore : function(c) {
		if(c >= 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();
		    	}
		    }
		}
	}
});