AnalyseHandGrid.js 6.2 KB

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