AnalyseTestGrid.js 6.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  1. Ext.require([
  2. 'erp.util.*'
  3. ]);
  4. Ext.define('erp.view.plm.test.AnalyseTestGrid',{
  5. extend: 'Ext.grid.Panel',
  6. alias: 'widget.erpAnalyseTestGridPanel',
  7. layout : 'fit',
  8. emptyText : '无数据',
  9. columnLines : true,
  10. autoScroll : true,
  11. url:null,
  12. store: [],
  13. columns: new Array(),
  14. bodyStyle:'background-color:#f1f1f1;',
  15. BaseUtil: Ext.create('erp.util.BaseUtil'),
  16. RenderUtil:Ext.create('erp.util.RenderUtil'),
  17. initComponent : function(){
  18. this.getColumnsAndStore(condition);
  19. this.callParent(arguments);
  20. } ,
  21. features: [{
  22. ftype: 'summary',
  23. groupHeaderTpl: '{name}',
  24. hideGroupedHeader: false,
  25. enableGroupingMenu: false,
  26. enableLocking: true,
  27. }],
  28. getColumnsAndStore: function(condition){
  29. condition=condition==''?"1=1":condition;
  30. startdate=startdate==''?'2012-04-01':startdate;
  31. enddate=enddate==''?Ext.Date.format(new Date(),'Y-m-d'):enddate;
  32. var me = this;
  33. me.BaseUtil.getActiveTab().setLoading(true);//loading...
  34. Ext.Ajax.request({//拿到grid的columns
  35. url : basePath +this.url,
  36. params: {
  37. condition: condition,
  38. startdate:startdate,
  39. enddate:enddate
  40. },
  41. method : 'post',
  42. callback : function(options,success,response){
  43. me.BaseUtil.getActiveTab().setLoading(false);
  44. var res = new Ext.decode(response.responseText);
  45. if(res.exception || res.exceptionInfo){
  46. showError(res.exceptionInfo);
  47. return;
  48. }
  49. var data=res.data;
  50. if(me.columns && me.columns.length > 2){
  51. me.store.loadData(data);
  52. } else {
  53. var store = Ext.create('Ext.data.Store', {
  54. fields: res.fields,
  55. data: data
  56. });
  57. var grid=this;
  58. Ext.Array.each(res.columns, function(column, y) {
  59. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  60. if(!grid.RenderUtil){
  61. grid.RenderUtil = Ext.create('erp.util.RenderUtil');
  62. }
  63. var renderName = column.renderer;
  64. if(contains(column.renderer, ':', true)){
  65. var args = new Array();
  66. Ext.each(column.renderer.split(':'), function(a, index){
  67. if(index == 0){
  68. renderName = a;
  69. } else {
  70. args.push(a);
  71. }
  72. });
  73. if(!grid.RenderUtil.args[renderName]){
  74. grid.RenderUtil.args[renderName] = new Object();
  75. }
  76. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  77. //这里只能用column.dataIndex来标志,不能用x,y,index等,
  78. //grid在render时,checkbox占一列
  79. }
  80. column.flex=1;
  81. column.renderer = grid.RenderUtil[renderName];
  82. column.haveRendered = true;
  83. }
  84. if(column.summaryType!=""){
  85. if(column.summaryType=='sum'){
  86. column.summaryRenderer=function(value, summaryData, dataIndex) {
  87. return '<h2>' + value + '</h2>' ;
  88. };
  89. }else {
  90. column.summaryRenderer=function(value, summaryData, dataIndex) {
  91. return '<h2>共' + value + ' 项</h2>' ;
  92. };
  93. }
  94. }
  95. });
  96. me.reconfigure(store, res.columns);//用这个方法每次都会add一个checkbox列
  97. }
  98. //keyField = res.keyField;//form表主键字段
  99. }
  100. });
  101. },
  102. getCount: function(caller, condition){
  103. var me = this;
  104. Ext.Ajax.request({//拿到grid的数据总数count
  105. url : basePath + '/common/datalistCount.action',
  106. params: {
  107. caller: caller,
  108. condition: condition
  109. },
  110. method : 'post',
  111. callback : function(options,success,response){
  112. var res = new Ext.decode(response.responseText);
  113. if(res.exception || res.exceptionInfo){
  114. showError(res.exceptionInfo);
  115. return;
  116. }
  117. dataCount = res.count;
  118. me.getColumnsAndStore(caller, condition, page, pageSize);
  119. }
  120. });
  121. },
  122. listeners: {
  123. 'beforeheaderfiltersapply': function(grid, filters) {
  124. var condition = "1=1";
  125. for(var fn in filters){
  126. var value = filters[fn];
  127. if(!Ext.isEmpty(value)){
  128. value = " AND " + fn + " LIKE '%" + value + "%' ";
  129. Ext.each(grid.columns, function(c){
  130. if(c.dataIndex == fn && c.xtype == 'datecolumn'){//日期形式的特殊处理成oracle支持的格式哦
  131. value = " AND " + fn + "=to_date('" + Ext.Date.toString(filters[fn]) + "','YYYY-MM-DD') ";
  132. }
  133. });
  134. condition = condition + value;
  135. }
  136. }
  137. if (condition == "1=1") return false;
  138. this.getColumnsAndStore(caller, condition, page, pageSize);
  139. return false;
  140. }
  141. },
  142. reconfigure: function(store, columns){
  143. //改写reconfigure方法
  144. var d = this.headerCt;
  145. if (this.columns.length <= 1 && columns) {//this.columns.length > 1表示grid的columns已存在,没必要remove再add
  146. if(Ext.isIE){//ie下,format出现NaN-NaN-NaN,暂时作string处理
  147. Ext.each(columns, function(c){
  148. if(c.xtype == 'datecolumn'){
  149. c.xtype = "";
  150. c.format = "";
  151. }
  152. });
  153. }
  154. d.suspendLayout = true;
  155. d.removeAll();
  156. d.add(columns);
  157. }
  158. if (store) {
  159. if(Ext.isIE){//ie下,format出现NaN-NaN-NaN
  160. Ext.each(store.fields, function(f){
  161. if(f.type == 'date'){
  162. f.type = "string";
  163. f.format = "";
  164. }
  165. });
  166. }
  167. this.bindStore(store);
  168. } else {
  169. this.getView().refresh();
  170. }
  171. if (columns) {
  172. d.suspendLayout = false;
  173. this.forceComponentLayout();
  174. }
  175. this.fireEvent("reconfigure", this);
  176. }
  177. });