123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180 |
- Ext.define('erp.view.pm.atp.ATPOpDetailGridPanel5',{
- extend: 'Ext.grid.Panel',
- requires: ['erp.view.core.plugin.CopyPasteMenu'],
- alias: 'widget.ATPOpDetailGridPanel5',
- emptyText : $I18N.common.grid.emptyText,
- columnLines : true,
- autoScroll : true,
- id:'grid5',
- store: [],
- columns: new Array(),
- height:height,
- gridcondition:"",
- bodyStyle:'background-color:#f1f1f1;',
- selModel: Ext.create('Ext.selection.CheckboxModel',{
- headerWidth: 0
- }),
- LastCondition:"",
- dockedItems: [{
- id : 'pagingtoolbar5',
- xtype: 'erpMpsToolbar',
- dock: 'bottom',
- displayInfo: true
- }],
- GridUtil: Ext.create('erp.util.GridUtil'),
- BaseUtil: Ext.create('erp.util.BaseUtil'),
- plugins: [Ext.create('Ext.ux.grid.GridHeaderFilters'), Ext.create('erp.view.core.plugin.CopyPasteMenu')],
- initComponent : function(){
- this.getCount(caller,"");
- this.callParent(arguments);
- },
- getCount: function(c, condition){
- var me = this;
- c=c||caller;
- condition=me.getCondition(condition);
- Ext.Ajax.request({//拿到grid的数据总数count
- url : basePath + '/common/datalistCount.action',
- params: {
- caller: c,
- condition: condition,
- _noc:1
- },
- method : 'post',
- callback : function(options,success,response){
- var res = new Ext.decode(response.responseText);
- if(res.exception || res.exceptionInfo){
- showError(res.exceptionInfo);
- return;
- }
- dataCount = res.count;
- me.getColumnsAndStore(caller, condition, page, pageSize);
- }
- });
- },
- getCondition:function(condition){
- condition=(!condition || condition=="")?atpcondition:condition+" AND "+atpcondition;
- condition+=" AND ad_kind='SUPPLY'";
- condition =BaseQueryCondition==""?condition:condition+" AND "+BaseQueryCondition;
- condition=condition.replace(/pr_code/g,'ad_prodcode');
- if(!Ext.isEmpty(this.filterCondition)) {
- if(condition == '') {
- condition = this.filterCondition;
- } else {
- condition = '(' + condition + ') AND (' + this.filterCondition + ')';
- }
- }
- return condition;
- },
- listeners: {
- 'headerfiltersapply': function(grid, filters) {
- if(this.allowFilter){
- var condition = null;
- for(var fn in filters){
- var value = filters[fn],f = grid.getHeaderFilterField(fn);
- if(!Ext.isEmpty(value)){
- if(f.filtertype) {
- if (f.filtertype == 'numberfield') {
- value = fn + "=" + value + " ";
- }
- } else {
- if(Ext.isDate(value)){
- value = Ext.Date.toString(value);
- value = "to_char(" + fn + ",'yyyy-MM-dd')='" + value + "' ";
- } else {
- var exp_t = /^(\d{4})\-(\d{2})\-(\d{2}) (\d{2}):(\d{2}):(\d{2})$/,
- exp_d = /^(\d{4})\-(\d{2})\-(\d{2})$/;
- if(exp_d.test(value)){
- value = "to_char(" + fn + ",'yyyy-MM-dd')='" + value + "' ";
- } else if(exp_t.test(value)){
- value = "to_char(" + fn + ",'yyyy-MM-dd')='" + value.substr(0, 10) + "' ";
- } else{
- if(!f.autoDim) {
- value = fn + " LIKE '" + value + "%' ";
- } else {
- value = fn + " LIKE '%" + value + "%' ";
- }
- }
- }
- }
- if(condition == null){
- condition = value;
- } else {
- condition = condition + " AND " + value;
- }
- }
- }
- this.filterCondition = condition;
- page = 1;
- this.getCount(caller,"");
- } else {
- this.allowFilter = true;
- }
- return false;
- }
- },
- getColumnsAndStore: function(caller, condition, page, pageSize){
- var me = this;
- me.gridcondition=condition;
- me.BaseUtil.getActiveTab().setLoading(true);//loading...
- Ext.Ajax.request({//拿到grid的columns
- url : basePath + 'common/datalist.action',
- params: {
- caller: caller,
- condition: condition,
- page: page,
- pageSize: pageSize,
- _noc:1
- },
- method : 'post',
- callback : function(options,success,response){
- me.BaseUtil.getActiveTab().setLoading(false);
- var res = new Ext.decode(response.responseText);
- if(res.exception || res.exceptionInfo){
- showError(res.exceptionInfo);
- return;
- }
- var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];//一定要去掉多余逗号,ie对此很敏感
- if(me.columns && me.columns.length > 2){
- me.store.loadData(data);
- }else {
- var store = Ext.create('Ext.data.Store', {
- fields: res.fields,
- data: data
- });
- Ext.getCmp('grid5').reconfigure(store, res.columns);
- }
- Ext.getCmp('pagingtoolbar5').afterOnLoad();
- Ext.Ajax.request({//拿到grid的columns
- url : basePath + 'pm/mps/getSum.action',
- params: {
- caller: caller,
- condition:condition,
- fields:'ad_needqty',
- _noc:1
- },
- method : 'post',
- callback : function(options,success,response){
- me.BaseUtil.getActiveTab().setLoading(false);
- var res = new Ext.decode(response.responseText);
- if(res.exception || res.exceptionInfo){
- showError(res.exceptionInfo);
- return;
- }else if(res.success){
- var obj=new Ext.decode(res.data);
- var text=Ext.getCmp('text5');
- if(text){
- text.setText('数量 :'+obj.md_Needqty);
- }else {
- Ext.getCmp('pagingtoolbar5').insert(16,{
- xtype:'tbtext',
- id:'text5',
- text:'数量 :'+obj.md_Needqty
- });
- }
- }
- }
- });
- }
- });
- },
- });
|