MakeResourceGrid.js 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382
  1. Ext.define('erp.view.pm.make.MakeResourceGrid',{
  2. extend: 'Ext.grid.Panel',
  3. alias: 'widget.erpQueryGridPanel',
  4. requires: ['erp.view.core.grid.HeaderFilter'],
  5. id: 'grid',
  6. emptyText : $I18N.common.grid.emptyText,
  7. columnLines : true,
  8. autoScroll : true,
  9. multiselected: [],
  10. store: [],
  11. columns: [],
  12. bodyStyle: 'background-color:#f1f1f1;',
  13. headerCt: Ext.create("Ext.grid.header.Container",{
  14. forceFit: false,
  15. sortable: true,
  16. enableColumnMove:true,
  17. enableColumnResize:true,
  18. enableColumnHide: true
  19. }),
  20. invalidateScrollerOnRefresh: false,
  21. viewConfig: {
  22. trackOver: false
  23. },
  24. buffered: true,
  25. sync: true,
  26. _noc:1,
  27. bbar: {xtype: 'toolbar',id:'toolbar',
  28. items:[{
  29. xtype:'tbtext',
  30. id:'gridcount'
  31. }]
  32. },
  33. features : [Ext.create('Ext.grid.feature.Grouping',{
  34. //startCollapsed: true,
  35. hideGroupedHeader: true,
  36. groupHeaderTpl: '{name} (Count:{rows.length})'
  37. }),{
  38. ftype : 'summary',
  39. showSummaryRow : false,//不显示默认合计行
  40. generateSummaryData: function(){
  41. var me = this,
  42. data = {},
  43. store = me.view.store,
  44. columns = me.view.headerCt.getColumnsForTpl(),
  45. i = 0,
  46. length = columns.length,
  47. //fieldData,
  48. //key,
  49. comp;
  50. //将feature的data打印在toolbar上面
  51. for (i = 0, length = columns.length; i < length; ++i) {
  52. comp = Ext.getCmp(columns[i].id);
  53. data[comp.id] = me.getSummary(store, comp.summaryType, comp.dataIndex, false);
  54. var tb = Ext.getCmp(columns[i].dataIndex + '_' + comp.summaryType);
  55. if(tb){
  56. tb.setText(tb.text.split(':')[0] + ':' + data[comp.id]);
  57. }
  58. }
  59. return data;
  60. }
  61. }],
  62. selModel: Ext.create('Ext.selection.CheckboxModel',{
  63. ignoreRightMouseSelection : false,
  64. listeners:{
  65. selectionchange:function(selectionModel, selected, options){
  66. }
  67. },
  68. getEditor: function(){
  69. return null;
  70. },
  71. onRowMouseDown: function(view, record, item, index, e) {//改写的onRowMouseDown方法
  72. var me = Ext.getCmp('grid');
  73. var bool = true;
  74. var items = me.selModel.getSelection();
  75. Ext.each(items, function(item, index){
  76. if(this.index == record.index){
  77. bool = false;
  78. me.selModel.deselect(record);
  79. Ext.Array.remove(items, item);
  80. Ext.Array.remove(me.multiselected, record);
  81. }
  82. });
  83. Ext.each(me.multiselected, function(item, index){
  84. items.push(item);
  85. });
  86. me.selModel.select(items);
  87. if(bool){
  88. view.el.focus();
  89. var checkbox = item.childNodes[0].childNodes[0].childNodes[0];
  90. if(checkbox.getAttribute && checkbox.getAttribute('class') == 'x-grid-row-checker'){
  91. me.multiselected.push(record);
  92. items.push(record);
  93. me.selModel.select(items);
  94. } else {
  95. me.selModel.deselect(record);
  96. Ext.Array.remove(me.multiselected, record);
  97. }
  98. }
  99. me.summary();
  100. },
  101. onHeaderClick: function(headerCt, header, e) {
  102. if (header.isCheckerHd) {
  103. e.stopEvent();
  104. var isChecked = header.el.hasCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');
  105. if (isChecked) {
  106. this.deselectAll(true);
  107. var grid = Ext.getCmp('grid');
  108. this.deselect(grid.multiselected);
  109. grid.multiselected = new Array();
  110. var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
  111. Ext.each(els, function(el, index){
  112. el.setAttribute('class','x-grid-row-checker');
  113. });
  114. header.el.removeCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
  115. } else {
  116. var grid = Ext.getCmp('grid');
  117. this.deselect(grid.multiselected);
  118. grid.multiselected = new Array();
  119. var els = Ext.select('div[@class=x-grid-row-checker-checked]').elements;
  120. Ext.each(els, function(el, index){
  121. el.setAttribute('class','x-grid-row-checker');
  122. });
  123. this.selectAll(true);
  124. header.el.addCls(Ext.baseCSSPrefix + 'grid-hd-checker-on');//添加这个
  125. }
  126. }
  127. Ext.getCmp('grid').summary();
  128. }
  129. }),
  130. initComponent : function(){
  131. this.GridUtil = Ext.create('erp.util.GridUtil');
  132. this.BaseUtil = Ext.create('erp.util.BaseUtil');
  133. this.RenderUtil = Ext.create('erp.util.RenderUtil');
  134. condition = this.BaseUtil.getUrlParam('urlcondition');
  135. condition = (condition == null) ? "" : condition;
  136. condition = condition.replace(/@/,"'%").replace(/@/,"%'");
  137. this.defaultCondition = condition;
  138. var gridParam = {caller: caller, condition: condition,_noc:this.BaseUtil.getUrlParam('_noc')};
  139. this.GridUtil.getGridColumnsAndStore(this, 'common/singleGridPanel.action?', gridParam, "");
  140. this.callParent(arguments);
  141. this.initRecords();
  142. },
  143. /*getGridColumnsAndStore: function(grid, url, param, no){
  144. var me = this;
  145. me.setLoading(true);//loading...
  146. Ext.Ajax.request({//拿到grid的columns
  147. url : basePath + url,
  148. params: param,
  149. method : 'post',
  150. async: false,
  151. callback : function(options,success,response){
  152. me.setLoading(false);
  153. var res = new Ext.decode(response.responseText);
  154. if(res.exceptionInfo){
  155. showError(res.exceptionInfo);return;
  156. }
  157. if(me.columns && me.columns.length > 2){
  158. var data = res.data != null ? Ext.decode(res.data.replace(/,}/g, '}').replace(/,]/g, ']')) : [];
  159. me.store.loadData(data);
  160. //解决固定列左右不对齐的情况
  161. var lockedView = me.view.lockedView;
  162. if(lockedView){
  163. var tableEl = lockedView.el.child('.x-grid-table');
  164. if(tableEl){
  165. tableEl.dom.style.marginBottom = '7px';
  166. }
  167. }
  168. me.initRecords();
  169. } else {
  170. if(res.columns){
  171. Ext.each(res.columns, function(column, y){
  172. me.setRenderer(column);
  173. var logic = column.logic;
  174. if(logic != null){
  175. me.setLogicType(column, logic, y);
  176. }
  177. });
  178. //store
  179. me.store = me.setDefaultStore(res.data, res.fields);
  180. //view
  181. if(me.selModel.views == null){
  182. me.selModel.views = [];
  183. }
  184. if(res.dbfinds.length > 0){
  185. me.dbfinds = res.dbfinds;
  186. }
  187. //toolbar
  188. me.setToolbar(res.columns);
  189. //reconfigure store&columns
  190. me.columns = res.columns;
  191. }
  192. }
  193. }
  194. });
  195. },*/
  196. getMultiSelected: function(){
  197. var grid = this;
  198. var items = grid.selModel.getSelection();
  199. Ext.each(items, function(item, index){
  200. if(this.data[grid.keyField] != null && this.data[grid.keyField] != ''
  201. && this.data[grid.keyField] != '0' && this.data[grid.keyField] != 0){
  202. grid.multiselected.push(item);
  203. }
  204. });
  205. return Ext.Array.unique(grid.multiselected);
  206. },
  207. setRenderer: function(column){
  208. var grid = this;
  209. if(!column.haveRendered && column.renderer != null && column.renderer != ""){
  210. var renderName = column.renderer;
  211. if(contains(column.renderer, ':', true)){
  212. var args = new Array();
  213. Ext.each(column.renderer.split(':'), function(a, index){
  214. if(index == 0){
  215. renderName = a;
  216. } else {
  217. args.push(a);
  218. }
  219. });
  220. if(!grid.RenderUtil.args[renderName]){
  221. grid.RenderUtil.args[renderName] = new Object();
  222. }
  223. grid.RenderUtil.args[renderName][column.dataIndex] = args;
  224. }
  225. column.renderer = grid.RenderUtil[renderName];
  226. column.haveRendered = true;
  227. }
  228. },
  229. setLogicType: function(column, logic, y){
  230. var grid = this;
  231. if(logic == 'detno'){
  232. grid.detno = column.dataIndex;
  233. } else if(logic == 'keyField'){
  234. grid.keyField = column.dataIndex;
  235. } else if(logic == 'mainField'){
  236. grid.mainField = column.dataIndex;
  237. } else if(logic == 'necessaryField'){
  238. grid.necessaryField = column.dataIndex;
  239. if(!grid.necessaryFields){
  240. grid.necessaryFields = new Array();
  241. }
  242. grid.necessaryFields.push(column.dataIndex);
  243. if(!column.haveRendered){
  244. column.renderer = function(val, meta, record, x, y, store, view){
  245. var c = this.columns[y];
  246. if(val != null && val.toString().trim() != ''){
  247. if(c.xtype == 'datecolumn'){
  248. val = Ext.Date.format(val, 'Y-m-d');
  249. }
  250. return val;
  251. } else {
  252. if(c.xtype == 'datecolumn'){
  253. val = '';
  254. }
  255. return '<img src="' + basePath + 'resource/images/icon/need.png" title="必填字段">' +
  256. '<span style="color:blue;padding-left:2px;" title="必填字段">' + val + '</span>';
  257. }
  258. };
  259. }
  260. } else if(logic == 'groupField'){
  261. grid.groupField = column.dataIndex;
  262. }
  263. },
  264. setToolbar: function(columns){
  265. var grid = this;
  266. var items = [];
  267. Ext.each(columns, function(column){
  268. if(column.summaryType == 'sum'){
  269. items.push('-',{
  270. id: column.dataIndex + '_sum',
  271. itemId: column.dataIndex,
  272. xtype: 'tbtext',
  273. text: column.text + '(sum):0'
  274. });
  275. } else if(column.summaryType == 'average') {
  276. items.push('-',{
  277. id: column.dataIndex + '_average',
  278. itemId: column.dataIndex,
  279. xtype: 'tbtext',
  280. text: column.text + '(average):0'
  281. });
  282. } else if(column.summaryType == 'count') {
  283. items.push('-',{
  284. id: column.dataIndex + '_count',
  285. itemId: column.dataIndex,
  286. xtype: 'tbtext',
  287. text: column.text + '(count):0'
  288. });
  289. }
  290. });
  291. grid.bbar = {
  292. xtype: 'toolbar',
  293. dock: 'bottom',
  294. items: items
  295. };
  296. },
  297. setDefaultStore: function(d, f){
  298. var me = this;
  299. var data = [];
  300. if(!d || d.length == 2){
  301. me.GridUtil.add10EmptyData(me.detno, data);
  302. me.GridUtil.add10EmptyData(me.detno, data);
  303. } else {
  304. data = Ext.decode(d.replace(/,}/g, '}').replace(/,]/g, ']'));
  305. }
  306. var store = Ext.create('Ext.data.Store', {
  307. fields: f,
  308. data: data,
  309. pageSize: 30,
  310. buffered: true,
  311. purgePageCount: 0,
  312. groupField: me.groupField,
  313. autoLoad:false,
  314. listeners:{
  315. load:function(store){
  316. store.guaranteeRange(0, 29);
  317. }
  318. },
  319. getSum: function(field) {
  320. var records = me.selModel.getSelection(),
  321. total = 0,
  322. i = 0,
  323. len = records.length;
  324. for (; i < len; ++i) {
  325. total += records[i].get(field);
  326. }
  327. return total;
  328. },
  329. getCount: function() {
  330. var records = me.selModel.getSelection(),
  331. count = 0;
  332. Ext.each(records, function(item){
  333. count++;
  334. });
  335. return count;
  336. },
  337. getAverage: function(field) {
  338. var records = me.selModel.getSelection(),
  339. count = 0,
  340. sum = 0;
  341. Ext.each(records, function(item){
  342. if(item.data[me.necessaryField] != null && item.data[me.necessaryField] != ''){
  343. count++;sum += item.data[field];
  344. }
  345. });
  346. return Ext.Number.format(sum/count, '0.00');
  347. }
  348. });
  349. return store;
  350. },
  351. /**
  352. * 修改为selection改变时,summary也动态改变
  353. */
  354. summary: function(){
  355. var me = this,
  356. store = this.store,
  357. value;
  358. Ext.each(me.columns, function(c){
  359. if(c.summaryType == 'sum'){
  360. value = store.getSum(c.dataIndex);
  361. me.down('tbtext[id=' + c.dataIndex + '_sum]').setText(c.header + '(sum):' + value);
  362. } else if(c.summaryType == 'count'){
  363. value = store.getCount();
  364. me.down('tbtext[id=' + c.dataIndex + '_count]').setText(c.header + '(count):' + value);
  365. } else if(c.summaryType == 'average'){
  366. value = store.getAverage(c.dataIndex);
  367. me.down('tbtext[id=' + c.dataIndex + '_average]').setText(c.header + '(average):' + value);
  368. }
  369. });
  370. },
  371. initRecords: function(){
  372. var records = this.store.data.items;
  373. var count = 0;
  374. Ext.each(records, function(record){
  375. if(!record.index){
  376. record.index = count++;
  377. }
  378. });
  379. }
  380. });